home / cryptids

geom_cols_ref_sys (view)

Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology

2 rows

View and edit SQL

f_table_name f_geometry_column geometry_type coord_dimension srid auth_name auth_srid ref_sys_name proj4text srtext
cryptids geom 6 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"]],AUTHORITY["EPSG","4326"]]
cryptids range 6 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"]],AUTHORITY["EPSG","4326"]]

Advanced export

JSON shape: default, array

CSV options:

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
Powered by Datasette · Query took 4.772ms · Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology