spatial_ref_sys_all (view)
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
856 rows where unit = "degree" sorted by proj4text
This data as json, copyable, CSV (advanced)
Suggested facets: has_flipped_axes, prime_meridian, axis_1_name, axis_1_orientation, axis_2_name, axis_2_orientation
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4052 | epsg | 4052 | Unspecified datum based upon the Clarke 1866 Authalic Sphere (deprecated) | 1 | 1 | Clarke 1866 Authalic Sphere | Greenwich | Not_specified_based_on_Clarke_1866_Authalic_Sphere | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6370997 +b=6370997 +no_defs | GEOGCS["Unspecified datum based upon the Clarke 1866 Authalic Sphere (deprecated)",DATUM["Not_specified_based_on_Clarke_1866_Authalic_Sphere",SPHEROID["Clarke 1866 Authalic Sphere",6370997,0,AUTHORITY["EPSG","7052"]],AUTHORITY["EPSG","6052"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4052"]] |
4035 | epsg | 4035 | Unspecified datum based upon the GRS 1980 Authalic Sphere (deprecated) | 1 | 1 | GRS 1980 Authalic Sphere | Greenwich | Not_specified_based_on_GRS_1980_Authalic_Sphere | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6371000 +b=6371000 +no_defs | GEOGCS["Unspecified datum based upon the GRS 1980 Authalic Sphere (deprecated)",DATUM["Not_specified_based_on_GRS_1980_Authalic_Sphere",SPHEROID["GRS 1980 Authalic Sphere",6371007,0,AUTHORITY["EPSG","7048"]],AUTHORITY["EPSG","6047"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4047"]] |
4047 | epsg | 4047 | Unspecified datum based upon the GRS 1980 Authalic Sphere (deprecated) | 1 | 1 | GRS 1980 Authalic Sphere | Greenwich | Not_specified_based_on_GRS_1980_Authalic_Sphere | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6371007 +b=6371007 +no_defs | GEOGCS["Unspecified datum based upon the GRS 1980 Authalic Sphere (deprecated)",DATUM["Not_specified_based_on_GRS_1980_Authalic_Sphere",SPHEROID["GRS 1980 Authalic Sphere",6371007,0,AUTHORITY["EPSG","7048"]],AUTHORITY["EPSG","6047"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4047"]] |
4053 | epsg | 4053 | Unspecified datum based upon the International 1924 Authalic Sphere (deprecated) | 1 | 1 | International 1924 Authalic Sphere | Greenwich | Not_specified_based_on_International_1924_Authalic_Sphere | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6371228 +b=6371228 +no_defs | GEOGCS["Unspecified datum based upon the International 1924 Authalic Sphere (deprecated)",DATUM["Not_specified_based_on_International_1924_Authalic_Sphere",SPHEROID["International 1924 Authalic Sphere",6371228,0,AUTHORITY["EPSG","7057"]],AUTHORITY["EPSG","6053"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4053"]] |
8042 | epsg | 8042 | Gusterberg (Ferro) | 1 | 1 | Zach 1812 | Ferro | Gusterberg_Ferro | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6376045 +rf=310 +pm=ferro +no_defs | GEOGCS["Gusterberg (Ferro)",DATUM["Gusterberg_Ferro",SPHEROID["Zach 1812",6376045,310,AUTHORITY["EPSG","1026"]],AUTHORITY["EPSG","1188"]],PRIMEM["Ferro",-17.6666666666667,AUTHORITY["EPSG","8909"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","8042"]] |
8043 | epsg | 8043 | St. Stephen (Ferro) | 1 | 1 | Zach 1812 | Ferro | St_Stephen_Ferro | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6376045 +rf=310 +pm=ferro +no_defs | GEOGCS["St. Stephen (Ferro)",DATUM["St_Stephen_Ferro",SPHEROID["Zach 1812",6376045,310,AUTHORITY["EPSG","1026"]],AUTHORITY["EPSG","1189"]],PRIMEM["Ferro",-17.6666666666667,AUTHORITY["EPSG","8909"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","8043"]] |
4027 | epsg | 4027 | Unknown datum based upon the Plessis 1817 ellipsoid (deprecated) | 1 | 1 | Plessis 1817 | Greenwich | Not_specified_based_on_Plessis_1817_ellipsoid | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6376523 +b=6355862.933255573 +no_defs | GEOGCS["Unknown datum based upon the Plessis 1817 ellipsoid (deprecated)",DATUM["Not_specified_based_on_Plessis_1817_ellipsoid",SPHEROID["Plessis 1817",6376523,308.64,AUTHORITY["EPSG","7027"]],AUTHORITY["EPSG","6027"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4027"]] |
4657 | epsg | 4657 | Reykjavik 1900 | 1 | 1 | Danish 1876 | Greenwich | Reykjavik_1900 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377019.27 +b=6355762.5391 +towgs84=-28,199,5,0,0,0,0 +no_defs | GEOGCS["Reykjavik 1900",DATUM["Reykjavik_1900",SPHEROID["Danish 1876",6377019.27,300,AUTHORITY["EPSG","7051"]],AUTHORITY["EPSG","6657"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4657"]] |
4015 | epsg | 4015 | Unknown datum based upon the Everest 1830 (1937 Adjustment) ellipsoid (deprecated) | 1 | 1 | Everest 1830 (1937 Adjustment) | Greenwich | Not_specified_based_on_Everest_1830_1937_Adjustment_ellipsoid | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377276.345 +b=6356075.41314024 +no_defs | GEOGCS["Unknown datum based upon the Everest 1830 (1937 Adjustment) ellipsoid (deprecated)",DATUM["Not_specified_based_on_Everest_1830_1937_Adjustment_ellipsoid",SPHEROID["Everest 1830 (1937 Adjustment)",6377276.345,300.8017,AUTHORITY["EPSG","7015"]],AUTHORITY["EPSG","6015"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4015"]] |
5233 | epsg | 5233 | SLD99 | 1 | 1 | Everest 1830 (1937 Adjustment) | Greenwich | Sri_Lanka_Datum_1999 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377276.345 +b=6356075.41314024 +towgs84=-0.293,766.95,87.713,0.195704,1.695068,3.473016,-0.039338 +no_defs | GEOGCS["SLD99",DATUM["Sri_Lanka_Datum_1999",SPHEROID["Everest 1830 (1937 Adjustment)",6377276.345,300.8017,AUTHORITY["EPSG","7015"]],AUTHORITY["EPSG","1053"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","5233"]] |
4244 | epsg | 4244 | Kandawala | 1 | 1 | Everest 1830 (1937 Adjustment) | Greenwich | Kandawala | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377276.345 +b=6356075.41314024 +towgs84=-97,787,86,0,0,0,0 +no_defs | GEOGCS["Kandawala",DATUM["Kandawala",SPHEROID["Everest 1830 (1937 Adjustment)",6377276.345,300.8017,AUTHORITY["EPSG","7015"]],AUTHORITY["EPSG","6244"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4244"]] |
4131 | epsg | 4131 | Indian 1960 | 1 | 1 | Everest 1830 (1937 Adjustment) | Greenwich | Indian_1960 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377276.345 +b=6356075.41314024 +towgs84=198,881,317,0,0,0,0 +no_defs | GEOGCS["Indian 1960",DATUM["Indian_1960",SPHEROID["Everest 1830 (1937 Adjustment)",6377276.345,300.8017,AUTHORITY["EPSG","7015"]],AUTHORITY["EPSG","6131"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4131"]] |
4240 | epsg | 4240 | Indian 1975 | 1 | 1 | Everest 1830 (1937 Adjustment) | Greenwich | Indian_1975 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377276.345 +b=6356075.41314024 +towgs84=210,814,289,0,0,0,0 +no_defs | GEOGCS["Indian 1975",DATUM["Indian_1975",SPHEROID["Everest 1830 (1937 Adjustment)",6377276.345,300.8017,AUTHORITY["EPSG","7015"]],AUTHORITY["EPSG","6240"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4240"]] |
4144 | epsg | 4144 | Kalianpur 1937 | 1 | 1 | Everest 1830 (1937 Adjustment) | Greenwich | Kalianpur_1937 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377276.345 +b=6356075.41314024 +towgs84=214,804,268,0,0,0,0 +no_defs | GEOGCS["Kalianpur 1937",DATUM["Kalianpur_1937",SPHEROID["Everest 1830 (1937 Adjustment)",6377276.345,300.8017,AUTHORITY["EPSG","7015"]],AUTHORITY["EPSG","6144"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4144"]] |
4239 | epsg | 4239 | Indian 1954 | 1 | 1 | Everest 1830 (1937 Adjustment) | Greenwich | Indian_1954 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377276.345 +b=6356075.41314024 +towgs84=217,823,299,0,0,0,0 +no_defs | GEOGCS["Indian 1954",DATUM["Indian_1954",SPHEROID["Everest 1830 (1937 Adjustment)",6377276.345,300.8017,AUTHORITY["EPSG","7015"]],AUTHORITY["EPSG","6239"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4239"]] |
4682 | epsg | 4682 | Gulshan 303 | 1 | 1 | Everest 1830 (1937 Adjustment) | Greenwich | Gulshan_303 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377276.345 +b=6356075.41314024 +towgs84=283.7,735.9,261.1,0,0,0,0 +no_defs | GEOGCS["Gulshan 303",DATUM["Gulshan_303",SPHEROID["Everest 1830 (1937 Adjustment)",6377276.345,300.8017,AUTHORITY["EPSG","7015"]],AUTHORITY["EPSG","6682"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4682"]] |
6207 | epsg | 6207 | Nepal 1981 | 1 | 1 | Everest 1830 (1937 Adjustment) | Greenwich | Nepal_1981 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377276.345 +b=6356075.41314024 +towgs84=293.17,726.18,245.36,0,0,0,0 +no_defs | GEOGCS["Nepal 1981",DATUM["Nepal_1981",SPHEROID["Everest 1830 (1937 Adjustment)",6377276.345,300.8017,AUTHORITY["EPSG","7015"]],AUTHORITY["EPSG","1111"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","6207"]] |
4751 | epsg | 4751 | Kertau (RSO) | 1 | 1 | Everest 1830 (RSO 1969) | Greenwich | Kertau_RSO | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377295.664 +b=6356094.667915204 +no_defs | GEOGCS["Kertau (RSO)",DATUM["Kertau_RSO",SPHEROID["Everest 1830 (RSO 1969)",6377295.664,300.8017,AUTHORITY["EPSG","7056"]],AUTHORITY["EPSG","6751"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4751"]] |
4045 | epsg | 4045 | Unknown datum based upon the Everest 1830 (1975 Definition) ellipsoid (deprecated) | 1 | 1 | Everest 1830 (1975 Definition) | Greenwich | Not_specified_based_on_Everest_1830_1975_Definition_ellipsoid | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377299.151 +b=6356098.145120132 +no_defs | GEOGCS["Unknown datum based upon the Everest 1830 (1975 Definition) ellipsoid (deprecated)",DATUM["Not_specified_based_on_Everest_1830_1975_Definition_ellipsoid",SPHEROID["Everest 1830 (1975 Definition)",6377299.151,300.8017255,AUTHORITY["EPSG","7045"]],AUTHORITY["EPSG","6045"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4045"]] |
4146 | epsg | 4146 | Kalianpur 1975 | 1 | 1 | Everest 1830 (1975 Definition) | Greenwich | Kalianpur_1975 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6377299.151 +b=6356098.145120132 +towgs84=295,736,257,0,0,0,0 +no_defs | GEOGCS["Kalianpur 1975",DATUM["Kalianpur_1975",SPHEROID["Everest 1830 (1975 Definition)",6377299.151,300.8017255,AUTHORITY["EPSG","7045"]],AUTHORITY["EPSG","6146"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4146"]] |
Advanced export
JSON shape: default, array, newline-delimited
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);