spatial_ref_sys_aux

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

7 rows where has_flipped_axes = 0, projection = "Mercator_1SP" and spheroid = "WGS 84"

This data as json, CSV (advanced)

srid ▼ is_geographic has_flipped_axes spheroid prime_meridian datum projection unit axis_1_name axis_1_orientation axis_2_name axis_2_orientation
3349 0 0 WGS 84 Greenwich WGS_1984 Mercator_1SP metre Easting East Northing North
3395 0 0 WGS 84 Greenwich WGS_1984 Mercator_1SP metre Easting East Northing North
3785 0 0 WGS 84 Greenwich WGS_1984 Mercator_1SP metre Easting East Northing North
3832 0 0 WGS 84 Greenwich WGS_1984 Mercator_1SP metre Easting East Northing North
3857 0 0 WGS 84 Greenwich WGS_1984 Mercator_1SP metre Easting East Northing North
6871 0 0 WGS 84 Greenwich WGS_1984 Mercator_1SP metre Easting East Northing North
6893 0 0 WGS 84 Greenwich WGS_1984 Mercator_1SP metre Easting East Northing North

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));