Data source: Verschiedene Organisationen und Projekte
This data as json, CSV (advanced)
Link | f_table_name | f_geometry_column | last_verified | row_count | extent_min_x | extent_min_y | extent_max_x | extent_max_y |
---|---|---|---|---|---|---|---|---|
incidents,point_geom | incidents | point_geom |
JSON shape: default, array, newline-delimited, object
CREATE TABLE geometry_columns_statistics ( f_table_name TEXT NOT NULL, f_geometry_column TEXT NOT NULL, last_verified TIMESTAMP, row_count INTEGER, extent_min_x DOUBLE, extent_min_y DOUBLE, extent_max_x DOUBLE, extent_max_y DOUBLE, CONSTRAINT pk_gc_statistics PRIMARY KEY (f_table_name, f_geometry_column), CONSTRAINT fk_gc_statistics FOREIGN KEY (f_table_name, f_geometry_column) REFERENCES geometry_columns (f_table_name, f_geometry_column) ON DELETE CASCADE);