geometry_columns_time

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

2 rows

This data as json, 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
cryptids,geom cryptids geom 2023-07-16T20:29:04.280Z 0000-01-01T00:00:00.000Z 0000-01-01T00:00:00.000Z
cryptids,range cryptids range 2023-07-16T20:29:04.280Z 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);