geometry_columns_statistics

Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api

2 rows

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
countries,geometry countries geometry            
timezones,geometry timezones geometry            

Advanced export

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

CSV options: 

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);