spatial_ref_sys_all (view)

Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api

45 rows where auth_name = "mj10777.de" sorted by srtext

This data as json, CSV (advanced)

auth_name 1 ✖

  • mj10777.de · 45 ✖

has_flipped_axes 0 ✖

axis_2_orientation 0 ✖

srid auth_name auth_srid ref_sys_name is_geographic has_flipped_axes spheroid prime_meridian datum projection unit axis_1_name axis_1_orientation axis_2_name axis_2_orientation proj4text srtext ▼
187998 mj10777.de 187998 DHDN / Ferro / Deutsches_Hauptdreiecksnetz                       +proj=longlat +ellps=bessel +datum=potsdam +pm=ferro +no_defs PROJCS["DHDN / Ferro / Deutsches_Hauptdreiecksnetz",GEOGCS["DHDN",DATUM["Deutsches_Hauptdreiecksnetz",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]], AUTHORITY["EPSG","6314"]],PRIMEM["ferro",-17.66666666666667],UNIT["Degree",0.017453292519943295,AUTHORITY["mj10777.de","187998"]],AUTHORITY["EPSG","4314"]]]
187901 mj10777.de 187901 DHDN / Soldner 1 Kucklinsberg                       +proj=cass +lat_0=54.46022375 +lon_0=21.95509736 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 1 Kucklinsberg",GEOGCS["DHDN",DATUM["Deutsches_Hauptdreiecksnetz",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],AUTHORITY["EPSG","6314"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4314"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Cassini_Soldner"],PARAMETER["latitude_of_origin",54.46022375],PARAMETER["central_meridian",21.95509736],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187901"],AXIS["x",NORTH],AXIS["y",EAST]]
187910 mj10777.de 187910 DHDN / Soldner 10 Josefsberg                       +proj=cass +lat_0=51.98768806 +lon_0=16.20044389 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 10 Josefsberg",GEOGCS["DHDN",DATUM["Deutsches_Hauptdreiecksnetz",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],AUTHORITY["EPSG","6314"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4314"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Cassini_Soldner"],PARAMETER["latitude_of_origin",51.98768806],PARAMETER["central_meridian",16.20044389],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187910"],AXIS["x",NORTH],AXIS["y",EAST]]
187911 mj10777.de 187911 DHDN / Soldner 11 Schroda                       +proj=cass +lat_0=52.23137372 +lon_0=17.27795372 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 11 Schroda",GEOGCS["DHDN",DATUM["Deutsches_Hauptdreiecksnetz",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],AUTHORITY["EPSG","6314"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4314"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Cassini_Soldner"],PARAMETER["latitude_of_origin",52.23137372],PARAMETER["central_meridian",17.27795372],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187911"],AXIS["x",NORTH],AXIS["y",EAST]]
187912 mj10777.de 187912 DHDN / Soldner 12 Pschow                       +proj=cass +lat_0=50.04206544 +lon_0=18.39610692 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 12 Pschow",GEOGCS["DHDN",DATUM["Deutsches_Hauptdreiecksnetz",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],AUTHORITY["EPSG","6314"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4314"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Cassini_Soldner"],PARAMETER["latitude_of_origin",50.04206544],PARAMETER["central_meridian",18.39610692],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187912"],AXIS["x",NORTH],AXIS["y",EAST]]
187913 mj10777.de 187913 DHDN / Soldner 13 Rummelsberg                       +proj=cass +lat_0=50.70352314 +lon_0=17.11233917 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 13 Rummelsberg",GEOGCS["DHDN",DATUM["Deutsches_Hauptdreiecksnetz",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],AUTHORITY["EPSG","6314"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4314"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Cassini_Soldner"],PARAMETER["latitude_of_origin",50.70352314],PARAMETER["central_meridian",17.11233917],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187913"],AXIS["x",NORTH],AXIS["y",EAST]]
187914 mj10777.de 187914 DHDN / Soldner 14 Gröditzberg I                       +proj=cass +lat_0=51.17819342 +lon_0=15.76127086 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 14 Gröditzberg I",GEOGCS["DHDN",DATUM["Deutsches_Hauptdreiecksnetz",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],AUTHORITY["EPSG","6314"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4314"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Cassini_Soldner"],PARAMETER["latitude_of_origin",51.17819342],PARAMETER["central_meridian",15.76127086],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187914"],AXIS["x",NORTH],AXIS["y",EAST]]
187915 mj10777.de 187915 DHDN / Soldner 15 Kaltenborn                       +proj=cass +lat_0=51.92903708 +lon_0=14.66212942 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 15 Kaltenborn",GEOGCS["DHDN",DATUM["Deutsches_Hauptdreiecksnetz",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],AUTHORITY["EPSG","6314"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4314"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Cassini_Soldner"],PARAMETER["latitude_of_origin",51.92903708],PARAMETER["central_meridian",14.66212942],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187915"],AXIS["x",NORTH],AXIS["y",EAST]]
187916 mj10777.de 187916 DHDN / Soldner 16 Bahn I                       +proj=cass +lat_0=53.10184583 +lon_0=14.70144539 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 16 Bahn I",GEOGCS["DHDN",DATUM["Deutsches_Hauptdreiecksnetz",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],AUTHORITY["EPSG","6314"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4314"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Cassini_Soldner"],PARAMETER["latitude_of_origin",53.10184583],PARAMETER["central_meridian",14.70144539],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187916"],AXIS["x",NORTH],AXIS["y",EAST]]
187917 mj10777.de 187917 DHDN / Soldner 17 Greifswald, Nikolaikirche                       +proj=cass +lat_0=54.09698872 +lon_0=13.37880703 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 17 Greifswald, Nikolaikirche",GEOGCS["DHDN",DATUM["Deutsches_Hauptdreiecksnetz",SPHEROID["Bessel 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],AUTHORITY["EPSG","6314"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4314"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Cassini_Soldner"],PARAMETER["latitude_of_origin",54.09698872],PARAMETER["central_meridian",13.37880703],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187917"],AXIS["x",NORTH],AXIS["y",EAST]]

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW spatial_ref_sys_all AS
SELECT a.srid AS srid, a.auth_name AS auth_name, a.auth_srid AS auth_srid, a.ref_sys_name AS ref_sys_name,
b.is_geographic AS is_geographic, b.has_flipped_axes AS has_flipped_axes, b.spheroid AS spheroid, b.prime_meridian AS prime_meridian, b.datum AS datum, b.projection AS projection, b.unit AS unit,
b.axis_1_name AS axis_1_name, b.axis_1_orientation AS axis_1_orientation,
b.axis_2_name AS axis_2_name, b.axis_2_orientation AS axis_2_orientation,
a.proj4text AS proj4text, a.srtext AS srtext
FROM spatial_ref_sys AS a
LEFT JOIN spatial_ref_sys_aux AS b ON (a.srid = b.srid);