spatialite_history
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
16 rows
This data as json, copyable, CSV (advanced)
Suggested facets: table_name, event, timestamp, timestamp (date)
| event_id ▼ | table_name | geometry_column | event | timestamp | ver_sqlite | ver_splite |
|---|---|---|---|---|---|---|
| 1 | spatial_ref_sys | table successfully created | 2023-01-09T19:48:38.178Z | 3.37.2 | 5.0.1 | |
| 2 | geometry_columns | table successfully created | 2023-01-09T19:48:38.179Z | 3.37.2 | 5.0.1 | |
| 3 | geometry_columns | trigger 'geometry_columns_f_table_name_insert' successfully created | 2023-01-09T19:48:38.179Z | 3.37.2 | 5.0.1 | |
| 4 | geometry_columns | trigger 'geometry_columns_f_table_name_update' successfully created | 2023-01-09T19:48:38.179Z | 3.37.2 | 5.0.1 | |
| 5 | geometry_columns | trigger 'geometry_columns_f_geometry_column_insert' successfully created | 2023-01-09T19:48:38.179Z | 3.37.2 | 5.0.1 | |
| 6 | geometry_columns | trigger 'geometry_columns_f_geometry_column_update' successfully created | 2023-01-09T19:48:38.179Z | 3.37.2 | 5.0.1 | |
| 7 | geometry_columns | trigger 'geometry_columns_geometry_type_insert' successfully created | 2023-01-09T19:48:38.179Z | 3.37.2 | 5.0.1 | |
| 8 | geometry_columns | trigger 'geometry_columns_geometry_type_update' successfully created | 2023-01-09T19:48:38.179Z | 3.37.2 | 5.0.1 | |
| 9 | geometry_columns | trigger 'geometry_columns_coord_dimension_insert' successfully created | 2023-01-09T19:48:38.179Z | 3.37.2 | 5.0.1 | |
| 10 | geometry_columns | trigger 'geometry_columns_coord_dimension_update' successfully created | 2023-01-09T19:48:38.180Z | 3.37.2 | 5.0.1 | |
| 11 | geom_cols_ref_sys | view 'geom_cols_ref_sys' successfully created | 2023-01-09T19:48:38.180Z | 3.37.2 | 5.0.1 | |
| 12 | spatial_ref_sys | table successfully populated | 2023-01-09T19:48:38.241Z | 3.37.2 | 5.0.1 | |
| 13 | CPAD_2020a_Units | geometry | Geometry [GEOMETRY,XY,SRID=4326] successfully created | 2023-01-09T19:48:38.419Z | 3.37.2 | 5.0.1 |
| 14 | CPAD_2020a_Units | geometry | R*Tree Spatial Index successfully created | 2023-01-09T19:50:07.578Z | 3.37.2 | 5.0.1 |
| 15 | CPAD_2020a_SuperUnits | geometry | Geometry [GEOMETRY,XY,SRID=4326] successfully created | 2023-01-09T19:50:08.224Z | 3.37.2 | 5.0.1 |
| 16 | CPAD_2020a_SuperUnits | geometry | R*Tree Spatial Index successfully created | 2023-01-09T19:51:20.759Z | 3.37.2 | 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);