geometry_columns_statistics
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
2 rows sorted by extent_max_x
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 |
---|---|---|---|---|---|---|---|---|
timezones,geometry | timezones | geometry | ||||||
countries,geometry | countries | 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);