geometry_columns_time

Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api

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
countries,geometry countries geometry 2023-01-08T20:29:58.458Z 0000-01-01T00:00:00.000Z 0000-01-01T00:00:00.000Z
timezones,geometry timezones geometry 2023-01-08T20:29:50.875Z 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);