Data source: Verschiedene Organisationen und Projekte
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 |
---|---|---|---|---|---|
incidents,point_geom | incidents | point_geom | 0000-01-01T00:00:00.000Z | 2024-04-15T18:21:42.104Z | 0000-01-01T00:00:00.000Z |
JSON shape: default, array, newline-delimited, object
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);