home / cryptids

spatialite_history

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

16 rows

View and edit SQL

Suggested facets: table_name, geometry_column, event, timestamp

event_id table_name geometry_column event timestamp ver_sqlite ver_splite
1 spatial_ref_sys   table successfully created 2018-10-16T21:53:55.575Z 3.8.2 4.1.1
2 geometry_columns   table successfully created 2018-10-16T21:53:55.575Z 3.8.2 4.1.1
3 geometry_columns   trigger 'geometry_columns_f_table_name_insert' successfully created 2018-10-16T21:53:55.575Z 3.8.2 4.1.1
4 geometry_columns   trigger 'geometry_columns_f_table_name_update' successfully created 2018-10-16T21:53:55.576Z 3.8.2 4.1.1
5 geometry_columns   trigger 'geometry_columns_f_geometry_column_insert' successfully created 2018-10-16T21:53:55.576Z 3.8.2 4.1.1
6 geometry_columns   trigger 'geometry_columns_f_geometry_column_update' successfully created 2018-10-16T21:53:55.576Z 3.8.2 4.1.1
7 geometry_columns   trigger 'geometry_columns_geometry_type_insert' successfully created 2018-10-16T21:53:55.576Z 3.8.2 4.1.1
8 geometry_columns   trigger 'geometry_columns_geometry_type_update' successfully created 2018-10-16T21:53:55.576Z 3.8.2 4.1.1
9 geometry_columns   trigger 'geometry_columns_coord_dimension_insert' successfully created 2018-10-16T21:53:55.576Z 3.8.2 4.1.1
10 geometry_columns   trigger 'geometry_columns_coord_dimension_update' successfully created 2018-10-16T21:53:55.576Z 3.8.2 4.1.1
11 geom_cols_ref_sys   view 'geom_cols_ref_sys' successfully created 2018-10-16T21:53:55.576Z 3.8.2 4.1.1
12 spatial_ref_sys   table successfully populated 2018-10-16T21:53:55.628Z 3.8.2 4.1.1
13 cryptids geom Geometry [MULTIPOLYGON,XY,SRID=4326] successfully created 2018-10-16T21:53:55.686Z 3.8.2 4.1.1
14 cryptids geom R*Tree Spatial Index successfully created 2018-10-16T21:53:55.743Z 3.8.2 4.1.1
15 cryptids range Geometry [MULTIPOLYGON,XY,SRID=4326] successfully created 2018-10-16T21:53:55.786Z 3.8.2 4.1.1
16 cryptids range R*Tree Spatial Index successfully created 2018-10-16T21:53:55.842Z 3.8.2 4.1.1

Advanced export

JSON shape: default, array, object

CSV options:

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)
Powered by Datasette · Query took 6.304ms · Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology