spatial_ref_sys_aux

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

6,164 rows

This data as json, copyable, CSV (advanced)

Suggested facets: is_geographic, has_flipped_axes, prime_meridian, projection, unit, axis_1_name, axis_1_orientation, axis_2_name, axis_2_orientation

srid ▼ is_geographic has_flipped_axes spheroid prime_meridian datum projection unit axis_1_name axis_1_orientation axis_2_name axis_2_orientation
2000 0 0 Clarke 1880 (RGS) Greenwich Anguilla_1957 Transverse_Mercator metre Easting East Northing North
2001 0 0 Clarke 1880 (RGS) Greenwich Antigua_1943 Transverse_Mercator metre Easting East Northing North
2002 0 0 Clarke 1880 (RGS) Greenwich Dominica_1945 Transverse_Mercator metre Easting East Northing North
2003 0 0 Clarke 1880 (RGS) Greenwich Grenada_1953 Transverse_Mercator metre Easting East Northing North
2004 0 0 Clarke 1880 (RGS) Greenwich Montserrat_1958 Transverse_Mercator metre Easting East Northing North
2005 0 0 Clarke 1880 (RGS) Greenwich St_Kitts_1955 Transverse_Mercator metre Easting East Northing North
2006 0 0 Clarke 1880 (RGS) Greenwich St_Lucia_1955 Transverse_Mercator metre Easting East Northing North
2007 0 0 Clarke 1880 (RGS) Greenwich St_Vincent_1945 Transverse_Mercator metre Easting East Northing North
2008 0 0 Clarke 1866 Greenwich North_American_Datum_1927_CGQ77 Transverse_Mercator metre Easting East Northing North
2009 0 0 Clarke 1866 Greenwich North_American_Datum_1927_CGQ77 Transverse_Mercator metre Easting East Northing North
2010 0 0 Clarke 1866 Greenwich North_American_Datum_1927_CGQ77 Transverse_Mercator metre Easting East Northing North
2011 0 0 Clarke 1866 Greenwich North_American_Datum_1927_CGQ77 Transverse_Mercator metre Easting East Northing North
2012 0 0 Clarke 1866 Greenwich North_American_Datum_1927_CGQ77 Transverse_Mercator metre Easting East Northing North
2013 0 0 Clarke 1866 Greenwich North_American_Datum_1927_CGQ77 Transverse_Mercator metre Easting East Northing North
2014 0 0 Clarke 1866 Greenwich North_American_Datum_1927_CGQ77 Transverse_Mercator metre Easting East Northing North
2015 0 0 Clarke 1866 Greenwich North_American_Datum_1927_CGQ77 Transverse_Mercator metre Easting East Northing North
2016 0 0 Clarke 1866 Greenwich North_American_Datum_1927_CGQ77 Transverse_Mercator metre Easting East Northing North
2017 0 0 Clarke 1866 Greenwich North_American_Datum_1927_1976 Transverse_Mercator metre Easting East Northing North
2018 0 0 Clarke 1866 Greenwich North_American_Datum_1927_1976 Transverse_Mercator metre Easting East Northing North
2019 0 0 Clarke 1866 Greenwich North_American_Datum_1927_1976 Transverse_Mercator metre Easting East Northing North

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE spatial_ref_sys_aux (
	srid INTEGER NOT NULL PRIMARY KEY,
	is_geographic INTEGER,
	has_flipped_axes INTEGER,
	spheroid TEXT,
	prime_meridian TEXT,
	datum TEXT,
	projection TEXT,
	unit TEXT,
	axis_1_name TEXT,
	axis_1_orientation TEXT,
	axis_2_name TEXT,
	axis_2_orientation TEXT,
	CONSTRAINT fk_sprefsys FOREIGN KEY (srid) 	REFERENCES spatial_ref_sys (srid));
CREATE INDEX [idx_spatial_ref_sys_aux_srid]
    ON [spatial_ref_sys_aux] ([srid]);