# sql_statements_log

time_start: 2015-09-04T13:15:45.377Z
time_end: 2015-09-04T13:32:57.176Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "PK_UID", "short_name", "pre_2012", "code", "name", st_isvalidreason(Geometry) as reason
FROM "BiogeoRegions2015"
where st_isvalid(geometry) = 0 and short_name = 'ALP'


time_start: 2015-09-04T13:34:11.218Z
time_end: 2015-09-04T13:34:23.608Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "PK_UID", "short_name", "pre_2012", "code", "name", st_isvalidreason(Geometry) as reason
FROM "BiogeoRegions2015_elem"
where st_isvalid(geometry) = 0 and short_name = 'ATL'


time_start: 2015-09-04T13:34:29.080Z
time_end: 2015-09-04T13:34:32.678Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "PK_UID", "short_name", "pre_2012", "code", "name", st_isvalidreason(Geometry) as reason
FROM "BiogeoRegions2015_elem"
where st_isvalid(geometry) = 0


time_start: 2015-09-04T13:35:18.068Z
time_end: 2015-09-04T13:52:23.723Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "PK_UID", "short_name", "pre_2012", "code", "name", st_isvalidreason(Geometry) as reason
FROM "BiogeoRegions2015"
where st_isvalid(geometry) = 0 and short_name = 'MED'


time_start: 2015-09-04T13:53:07.468Z
time_end: 2015-09-04T13:53:20.588Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "PK_UID", "short_name", "pre_2012", "code", "name", st_isvalidreason(Geometry) as reason
FROM "BiogeoRegions2015"
where st_isvalid(geometry) = 0


time_start: 2015-09-04T14:11:39.287Z
time_end: 2015-09-04T14:11:39.394Z
user_agent: spatialite_gui
error_cause: SQL error: near "io": syntax error
sql_statement:
update BiogeoRegions2015 set geometry = st_buffer(geometry, 0) where pre_2012 io ('ATL', 'BLS', 'MED', 'STE'))


time_start: 2015-09-04T14:11:43.795Z
time_end: 2015-09-04T14:11:43.908Z
user_agent: spatialite_gui
error_cause: SQL error: near ")": syntax error
sql_statement:
update BiogeoRegions2015 set geometry = st_buffer(geometry, 0) where pre_2012 in ('ATL', 'BLS', 'MED', 'STE'))


time_start: 2015-09-04T14:11:47.731Z
time_end: 2015-09-04T14:13:24.299Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
update BiogeoRegions2015 set geometry = st_buffer(geometry, 0) where pre_2012 in ('ATL', 'BLS', 'MED', 'STE')


time_start: 2015-09-04T14:13:33.488Z
time_end: 2015-09-04T14:13:33.669Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "PK_UID", "short_name", "pre_2012", "code", "name", st_isvalidreason(Geometry) as reason
FROM "BiogeoRegions2015"


time_start: 2015-09-04T14:47:00.652Z
time_end: 2015-09-04T14:47:03.057Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("Geometry"), Srid("Geometry"), CoordDimension("Geometry")
FROM "BiogeoRegions2015"
GROUP BY 2, 3, 4


time_start: 2015-09-04T15:11:52.850Z
time_end: 2015-09-04T15:11:53.120Z
user_agent: spatialite_gui
error_cause: SQL error: no such column: geoemtry
sql_statement:
select st_isvalidreason(geoemtry) as reagion, * from BiogeoRegions2015_uncompressed where st_isvalid(geometry) = 0


time_start: 2015-09-04T15:11:59.220Z
time_end: 2015-09-04T15:12:12.352Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
select st_isvalidreason(geometry) as reagion, * from BiogeoRegions2015_uncompressed where st_isvalid(geometry) = 0


time_start: 2015-09-04T16:18:58.407Z
time_end: 2015-09-04T16:19:28.818Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
update "BiogeoRegions2015_uncompressed_elem" set geometry = st_makevalid(geometry) where st_isvalid(geometry) = 0


time_start: 2015-09-04T16:25:09.247Z
time_end: 2015-09-04T16:25:09.748Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
explain 
SELECT short_name, pre_2012, code, name, st_union(geometry) as geometry
FROM "BiogeoRegions2015_uncompressed_elem"
Group BY short_name, pre_2012, code, name


time_start: 2015-09-04T16:25:42.928Z
time_end: 2015-09-04T16:43:26.841Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
create table BiogeoRegions2015_final as 
SELECT short_name, pre_2012, code, name, st_union(geometry) as geometry
FROM "BiogeoRegions2015_uncompressed_elem"
Group BY short_name, pre_2012, code, name


time_start: 2015-09-04T17:15:20.524Z
time_end: 2015-09-04T17:15:20.724Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE "BiogeoRegions2015" (
"PK_UID" INTEGER PRIMARY KEY AUTOINCREMENT,
"short_name" TEXT,
"pre_2012" TEXT,
"code" TEXT,
"name" TEXT, "Geometry" MULTIPOLYGON)


time_start: 2015-09-04T17:15:53.845Z
time_end: 2015-09-04T17:15:54.805Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
insert into BiogeoRegions2015 SELECT ROWID, "short_name", "pre_2012", "code", "name", "geometry"
FROM "BiogeoRegions2015_final"
ORDER BY ROWID


