geometry_columns_statistics
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows
This data as json, copyable, 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 |
---|---|---|---|---|---|---|---|---|
cpad_2020a_superunits,geometry | cpad_2020a_superunits | geometry | ||||||
cpad_2020a_units,geometry | cpad_2020a_units | geometry |
Advanced export
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); CREATE INDEX [idx_geometry_columns_statistics_f_table_name] ON [geometry_columns_statistics] ([f_table_name]); CREATE INDEX [idx_geometry_columns_statistics_f_geometry_column] ON [geometry_columns_statistics] ([f_geometry_column]);