geometry_columns

Data source: Verschiedene Organisationen und Projekte

1 row

descending

Link	f_table_name	f_geometry_column	geometry_type	coord_dimension	srid	spatial_index_enabled
incidents,point_geom	incidents	point_geom	1	2	4326 4326	1

Advanced export

JSON shape: default, array, newline-delimited, object

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)));
CREATE INDEX idx_srid_geocols ON geometry_columns
(srid) ;