views_geometry_columns_statistics

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

This data as json, copyable

0 records

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);
CREATE INDEX [idx_views_geometry_columns_statistics_view_name]
    ON [views_geometry_columns_statistics] ([view_name]);
CREATE INDEX [idx_views_geometry_columns_statistics_view_geometry]
    ON [views_geometry_columns_statistics] ([view_geometry]);