geometry_columns_time

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

2 rows

This data as json, copyable, CSV (advanced)

Suggested facets: last_insert (date), last_update (date), last_delete (date)

Link f_table_name f_geometry_column last_insert last_update last_delete
cpad_2020a_superunits,geometry cpad_2020a_superunits geometry 2023-01-09T19:51:19.855Z 0000-01-01T00:00:00.000Z 0000-01-01T00:00:00.000Z
cpad_2020a_units,geometry cpad_2020a_units geometry 2023-01-09T19:50:06.960Z 0000-01-01T00:00:00.000Z 0000-01-01T00:00:00.000Z

Advanced export

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

CSV options: 

CREATE TABLE geometry_columns_time (
f_table_name TEXT NOT NULL,
f_geometry_column TEXT NOT NULL,
last_insert TIMESTAMP NOT NULL DEFAULT '0000-01-01T00:00:00.000Z',
last_update TIMESTAMP NOT NULL DEFAULT '0000-01-01T00:00:00.000Z',
last_delete TIMESTAMP NOT NULL DEFAULT '0000-01-01T00:00:00.000Z',
CONSTRAINT pk_gc_time PRIMARY KEY (f_table_name, f_geometry_column),
CONSTRAINT fk_gc_time FOREIGN KEY (f_table_name, f_geometry_column) REFERENCES geometry_columns (f_table_name, f_geometry_column) ON DELETE CASCADE);
CREATE INDEX [idx_geometry_columns_time_f_table_name]
    ON [geometry_columns_time] ([f_table_name]);
CREATE INDEX [idx_geometry_columns_time_f_geometry_column]
    ON [geometry_columns_time] ([f_geometry_column]);