spatial_ref_sys_all (view)

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

45 rows where auth_name = "mj10777.de"

This data as json, CSV (advanced)

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
187900 mj10777.de 187900 DHDN / Soldner Rathausnetz 660                       +proj=cass +lat_0=52.41864827777778 +lon_0=13.62720366666667 +x_0=14741.77 +y_0=-11288.28 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner Rathausnetz 660",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.41864827777778],PARAMETER["central_meridian",13.62720366666667],PARAMETER["false_easting",14741.77],PARAMETER["false_northing",-11288.28],AUTHORITY["mj10777.de","187900"],AXIS["x",NORTH],AXIS["y",EAST]]
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]]
187902 mj10777.de 187902 DHDN / Soldner 2 Paulinen                       +proj=cass +lat_0=54.28921067 +lon_0=20.73315431 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 2 Paulinen",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.28921067],PARAMETER["central_meridian",20.73315431],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187902"],AXIS["x",NORTH],AXIS["y",EAST]]
187903 mj10777.de 187903 DHDN / Soldner 3 Markushof I                       +proj=cass +lat_0=54.05881333 +lon_0=19.37343583 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 3 Markushof 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",54.05881333],PARAMETER["central_meridian",19.37343583],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187903"],AXIS["x",NORTH],AXIS["y",EAST]]
187904 mj10777.de 187904 DHDN / Soldner 4 Thurmberg                       +proj=cass +lat_0=54.22552092 +lon_0=18.12569375 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 4 Thurmberg",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.22552092],PARAMETER["central_meridian",18.12569375],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187904"],AXIS["x",NORTH],AXIS["y",EAST]]
187905 mj10777.de 187905 DHDN / Soldner 5 Kauernick I                       +proj=cass +lat_0=53.38933197 +lon_0=19.59810438 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 5 Kauernick 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.38933197],PARAMETER["central_meridian",19.59810438],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187905"],AXIS["x",NORTH],AXIS["y",EAST]]
187906 mj10777.de 187906 DHDN / Soldner 6 Thorn, Rathausturm                       +proj=cass +lat_0=53.01181586 +lon_0=18.60725428 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 6 Thorn, Rathausturm",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.01181586],PARAMETER["central_meridian",18.60725428],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187906"],AXIS["x",NORTH],AXIS["y",EAST]]
187907 mj10777.de 187907 DHDN / Soldner 7 Heinrichsthal                       +proj=cass +lat_0=53.71289217 +lon_0=17.49676781 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 7 Heinrichsthal",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.71289217],PARAMETER["central_meridian",17.49676781],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187907"],AXIS["x",NORTH],AXIS["y",EAST]]
187908 mj10777.de 187908 DHDN / Soldner 8 Gollenberg, Denkmal                       +proj=cass +lat_0=54.20857178 +lon_0=16.22956781 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 8 Gollenberg, Denkmal",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.20857178],PARAMETER["central_meridian",16.22956781],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187908"],AXIS["x",NORTH],AXIS["y",EAST]]
187909 mj10777.de 187909 DHDN / Soldner 9 Gnesen                       +proj=cass +lat_0=52.53820406 +lon_0=17.59450500 +x_0=0 +y_0=0 +ellps=bessel +datum=potsdam +units=m +no_defs PROJCS["DHDN / Soldner 9 Gnesen",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.53820406],PARAMETER["central_meridian",17.59450500],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["mj10777.de","187909"],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);