home / cryptids

views_geometry_columns_statistics

Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology

View and edit SQL

Link view_name view_geometry last_verified row_count extent_min_x extent_min_y extent_max_x extent_max_y
CREATE TABLE views_geometry_columns_statistics (
view_name TEXT NOT NULL,
view_geometry 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_vwgc_statistics PRIMARY KEY (view_name, view_geometry),
CONSTRAINT fk_vwgc_statistics FOREIGN KEY (view_name, view_geometry) REFERENCES views_geometry_columns (view_name, view_geometry) ON DELETE CASCADE)
Powered by Datasette · Query took 23.099ms · Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology