home / cryptids

Menu
  • GraphQL API
  • Log in

geometry_columns_statistics

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

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
cryptids,geom cryptids geom            
cryptids,range cryptids range            

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);
Powered by Datasette · Queries took 16.925ms · Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology