geom_cols_ref_sys (view)

Data source: Verschiedene Organisationen und Projekte

1 row sorted by srtext

View and edit SQL

f_table_name f_geometry_column geometry_type coord_dimension srid auth_name auth_srid ref_sys_name proj4text srtext ▼
incidents point_geom 1 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"]]

Advanced export

JSON shape: default, array, newline-delimited

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 20.265ms · Data source: Verschiedene Organisationen und Projekte