spatial_ref_sys
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
4 rows where auth_name = "gfoss.it" sorted by srid descending
This data as json, CSV (advanced)
srid ▲ | auth_name | auth_srid | ref_sys_name | proj4text | srtext |
---|---|---|---|---|---|
40003 | gfoss.it | 4 | Italy Sicily GB Roma40 | +proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +units=m +towgs84=-50.2,-50.4,84.8,-0.690,-2.012,0.459,-28.08 +no_defs | Undefined |
40002 | gfoss.it | 3 | Italy Sardinia GB Roma40 | +proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +units=m +towgs84=-168.6,-34.0,38.6,-0.374,-0.679,-1.379,-9.48 +no_defs | Undefined |
40001 | gfoss.it | 2 | Italy mainland zone 2 GB Roma40 | +proj=tmerc +lat_0=0 +lon_0=15 +k=0.9996 +x_0=2520000 +y_0=0 +ellps=intl +units=m +towgs84=-104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68 +no_defs | Undefined |
40000 | gfoss.it | 1 | Italy mainland zone 1 GB Roma40 | +proj=tmerc+lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +units=m +towgs84=-104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68 +no_defs | Undefined |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE spatial_ref_sys ( srid INTEGER NOT NULL PRIMARY KEY, auth_name TEXT NOT NULL, auth_srid INTEGER NOT NULL, ref_sys_name TEXT NOT NULL DEFAULT 'Unknown', proj4text TEXT NOT NULL, srtext TEXT NOT NULL DEFAULT 'Undefined'); CREATE UNIQUE INDEX idx_spatial_ref_sys ON spatial_ref_sys (auth_srid, auth_name);