spatialite_history
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
16 rows sorted by event
This data as json, CSV (advanced)
Suggested facets: event, timestamp, timestamp (date)
table_name 5 ✖
event_id | table_name | geometry_column | event ▼ | timestamp | ver_sqlite | ver_splite |
---|---|---|---|---|---|---|
13 | timezones | geometry | Geometry [GEOMETRY,XY,SRID=4326] successfully created | 2023-01-08T20:28:03.230Z | 3.39.4 | 5.0.1 |
15 | countries | geometry | Geometry [GEOMETRY,XY,SRID=4326] successfully created | 2023-01-08T20:29:53.779Z | 3.39.4 | 5.0.1 |
14 | timezones | geometry | R*Tree Spatial Index successfully created | 2023-01-08T20:29:52.766Z | 3.39.4 | 5.0.1 |
16 | countries | geometry | R*Tree Spatial Index successfully created | 2023-01-08T20:29:58.484Z | 3.39.4 | 5.0.1 |
1 | spatial_ref_sys | table successfully created | 2023-01-08T20:27:58.940Z | 3.39.4 | 5.0.1 | |
2 | geometry_columns | table successfully created | 2023-01-08T20:27:58.941Z | 3.39.4 | 5.0.1 | |
12 | spatial_ref_sys | table successfully populated | 2023-01-08T20:27:59.115Z | 3.39.4 | 5.0.1 | |
9 | geometry_columns | trigger 'geometry_columns_coord_dimension_insert' successfully created | 2023-01-08T20:27:58.941Z | 3.39.4 | 5.0.1 | |
10 | geometry_columns | trigger 'geometry_columns_coord_dimension_update' successfully created | 2023-01-08T20:27:58.941Z | 3.39.4 | 5.0.1 | |
5 | geometry_columns | trigger 'geometry_columns_f_geometry_column_insert' successfully created | 2023-01-08T20:27:58.941Z | 3.39.4 | 5.0.1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE spatialite_history ( event_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, table_name TEXT NOT NULL, geometry_column TEXT, event TEXT NOT NULL, timestamp TEXT NOT NULL, ver_sqlite TEXT NOT NULL, ver_splite TEXT NOT NULL);