geom_cols_ref_sys (view)

Explore the data

✎ View and edit SQL This data as json, CSV (advanced)

f_table_name	f_geometry_column	geometry_type	coord_dimension	srid	auth_name	auth_srid	ref_sys_name	proj4text	srtext
regions	geometry	0	2	4326	epsg	4326	WGS 84	+proj=longlat +datum=WGS84 +no_defs	GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4326"]]

CREATE VIEW geom_cols_ref_sys AS
SELECT f_table_name, f_geometry_column, geometry_type,
coord_dimension, spatial_ref_sys.srid AS srid,
auth_name, auth_srid, ref_sys_name, proj4text, srtext
FROM geometry_columns, spatial_ref_sys
WHERE geometry_columns.srid = spatial_ref_sys.srid;