spatial_ref_sys_all (view)
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
868 rows where is_geographic = 1 sorted by srtext descending
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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9053 | epsg | 9053 | WGS 84 (G730) | 1 | 1 | WGS 84 | Greenwich | World_Geodetic_System_1984_G730 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +ellps=WGS84 +no_defs | GEOGCS["WGS 84 (G730)",DATUM["World_Geodetic_System_1984_G730",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","1152"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","9053"]] |
9057 | epsg | 9057 | WGS 84 (G1762) | 1 | 1 | WGS 84 | Greenwich | World_Geodetic_System_1984_G1762 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +ellps=WGS84 +no_defs | GEOGCS["WGS 84 (G1762)",DATUM["World_Geodetic_System_1984_G1762",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","1156"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","9057"]] |
9056 | epsg | 9056 | WGS 84 (G1674) | 1 | 1 | WGS 84 | Greenwich | World_Geodetic_System_1984_G1674 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +ellps=WGS84 +no_defs | GEOGCS["WGS 84 (G1674)",DATUM["World_Geodetic_System_1984_G1674",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","1155"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","9056"]] |
9055 | epsg | 9055 | WGS 84 (G1150) | 1 | 1 | WGS 84 | Greenwich | World_Geodetic_System_1984_G1150 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +ellps=WGS84 +no_defs | GEOGCS["WGS 84 (G1150)",DATUM["World_Geodetic_System_1984_G1150",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","1154"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","9055"]] |
4324 | epsg | 4324 | WGS 72BE | 1 | 1 | WGS 72 | Greenwich | WGS_72_Transit_Broadcast_Ephemeris | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +ellps=WGS72 +towgs84=0,0,1.9,0,0,0.814,-0.38 +no_defs | GEOGCS["WGS 72BE",DATUM["WGS_72_Transit_Broadcast_Ephemeris",SPHEROID["WGS 72",6378135,298.26,AUTHORITY["EPSG","7043"]],AUTHORITY["EPSG","6324"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4324"]] |
4322 | epsg | 4322 | WGS 72 | 1 | 1 | WGS 72 | Greenwich | World_Geodetic_System_1972 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +ellps=WGS72 +towgs84=0,0,4.5,0,0,0.554,0.2263 +no_defs | GEOGCS["WGS 72",DATUM["World_Geodetic_System_1972",SPHEROID["WGS 72",6378135,298.26,AUTHORITY["EPSG","7043"]],AUTHORITY["EPSG","6322"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4322"]] |
4760 | epsg | 4760 | WGS 66 | 1 | 1 | NWL 9D | Greenwich | World_Geodetic_System_1966 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +ellps=WGS66 +no_defs | GEOGCS["WGS 66",DATUM["World_Geodetic_System_1966",SPHEROID["NWL 9D",6378145,298.25,AUTHORITY["EPSG","7025"]],AUTHORITY["EPSG","6760"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4760"]] |
4671 | epsg | 4671 | Voirol 1879 | 1 | 1 | Clarke 1880 (IGN) | Greenwich | Voirol_1879 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6378249.2 +b=6356515 +no_defs | GEOGCS["Voirol 1879",DATUM["Voirol_1879",SPHEROID["Clarke 1880 (IGN)",6378249.2,293.466021293627,AUTHORITY["EPSG","7011"]],AUTHORITY["EPSG","6671"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4671"]] |
4821 | epsg | 4821 | Voirol 1879 (Paris) | 1 | 1 | Clarke 1880 (IGN) | Paris | Voirol_1879_Paris | none | grad | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6378249.2 +b=6356515 +pm=paris +no_defs | GEOGCS["Voirol 1879 (Paris)",DATUM["Voirol_1879_Paris",SPHEROID["Clarke 1880 (IGN)",6378249.2,293.466021293627,AUTHORITY["EPSG","7011"]],AUTHORITY["EPSG","6821"]],PRIMEM["Paris",2.33722917,AUTHORITY["EPSG","8903"]],UNIT["grad",0.0157079632679489,AUTHORITY["EPSG","9105"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4821"]] |
4304 | epsg | 4304 | Voirol 1875 | 1 | 1 | Clarke 1880 (IGN) | Greenwich | Voirol_1875 | none | degree | Geodetic latitude | North | Geodetic longitude | East | +proj=longlat +a=6378249.2 +b=6356515 +towgs84=-73,-247,227,0,0,0,0 +no_defs | GEOGCS["Voirol 1875",DATUM["Voirol_1875",SPHEROID["Clarke 1880 (IGN)",6378249.2,293.466021293627,AUTHORITY["EPSG","7011"]],AUTHORITY["EPSG","6304"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4304"]] |
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);