home / cryptids

geometry_columns

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

2 rows

View and edit SQL

Link f_table_name f_geometry_column geometry_type coord_dimension srid spatial_index_enabled
cryptids geom 6 2 4326 4326 1
cryptids range 6 2 4326 4326 1

Advanced export

JSON shape: default, array, object

CSV options:

CREATE TABLE geometry_columns (
f_table_name TEXT NOT NULL,
f_geometry_column TEXT NOT NULL,
geometry_type INTEGER NOT NULL,
coord_dimension INTEGER NOT NULL,
srid INTEGER NOT NULL,
spatial_index_enabled INTEGER NOT NULL,
CONSTRAINT pk_geom_cols PRIMARY KEY (f_table_name, f_geometry_column),
CONSTRAINT fk_gc_srs FOREIGN KEY (srid) REFERENCES spatial_ref_sys (srid),
CONSTRAINT ck_gc_rtree CHECK (spatial_index_enabled IN (0,1,2)))
Powered by Datasette · Query took 3.801ms · Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology