# sql_statements_log

time_start: 2014-05-11T16:59:59.673Z
time_end: 2014-05-11T16:59:59.734Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "coords_32633.PK_UID", "Ordine", "Tipo", "Lat", "Lon", "ID", "id_t", "Geometry"
FROM "coords_32633"
ORDER BY ROWID


time_start: 2014-05-11T17:00:09.705Z
time_end: 2014-05-11T17:00:09.758Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, coords_32633.PK_UID, "Ordine", "Tipo", "Lat", "Lon", "ID", "id_t", "Geometry"
FROM "coords_32633"
ORDER BY ROWID


time_start: 2014-05-11T17:07:28.681Z
time_end: 2014-05-11T17:07:28.835Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Snap(coords_32633.geometry,sicilia_32633.Geometry,100) AS puntisnappati FROM coords_32633,sicilia_32633


time_start: 2014-05-11T17:07:47.001Z
time_end: 2014-05-11T17:07:47.049Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Snap(coords_32633.geometry,sicilia_32633.Geometry,10) AS puntisnappati FROM coords_32633,sicilia_32633


time_start: 2014-05-11T17:09:40.009Z
time_end: 2014-05-11T17:09:40.053Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Snap(coords_32633.geometry,sicilia_32633.Geometry,10) AS puntisnappati,coords_32633.Ordine FROM coords_32633,sicilia_32633


time_start: 2014-05-11T17:10:02.889Z
time_end: 2014-05-11T17:10:04.944Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE test AS
SELECT ST_Snap(coords_32633.geometry,sicilia_32633.Geometry,10) AS puntisnappati,coords_32633.Ordine FROM coords_32633,sicilia_32633


time_start: 2014-05-11T17:22:20.137Z
time_end: 2014-05-11T17:22:20.229Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Line_Interpolate_Point(
		sicilia_32633_linee.Geometry,
		ST_Line_Locate_Point(
			sicilia_32633_linee.Geometry,
			coords_32633.geometry
		)
	)
FROM sicilia_32633_linee, coords_32633;


time_start: 2014-05-11T17:22:45.865Z
time_end: 2014-05-11T17:22:45.923Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Line_Interpolate_Point(
		sicilia_32633_linee.Geometry,
		ST_Line_Locate_Point(
			sicilia_32633_linee.Geometry,
			coords_32633.geometry
		)
	) AS TEST
FROM sicilia_32633_linee, coords_32633;


time_start: 2014-05-11T17:57:18.537Z
time_end: 2014-05-11T17:57:18.556Z
user_agent: spatialite_gui
error_cause: SQL error: no such column: coords_32633.geometry
sql_statement:
SELECT
    f.PK_UID as gid,
    ST_Snap(coords_32633.geometry, g.Geometry, 2) as geom
FROM
    coords_32633 as f,
    (SELECT ST_Collect(Geometry) as Geometry
     FROM sicilia_32633_linee) as g


time_start: 2014-05-11T17:57:34.338Z
time_end: 2014-05-11T17:57:35.279Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT
    f.PK_UID as gid,
    ST_Snap(f.geometry, g.Geometry, 2) as geom
FROM
    coords_32633 as f,
    (SELECT ST_Collect(Geometry) as Geometry
     FROM sicilia_32633_linee) as g


time_start: 2014-05-11T17:57:52.105Z
time_end: 2014-05-11T17:57:52.888Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT
    f.PK_UID as gid,
    ST_Snap(f.geometry, g.Geometry, 20) as geom
FROM
    coords_32633 as f,
    (SELECT ST_Collect(Geometry) as Geometry
     FROM sicilia_32633_linee) as g


time_start: 2014-05-11T17:58:17.385Z
time_end: 2014-05-11T17:58:17.401Z
user_agent: spatialite_gui
error_cause: SQL error: near "ST_Snap": syntax error
sql_statement:
SELECT
    f.PK_UID as gid, f.Ordine AS Ordine
    ST_Snap(f.geometry, g.Geometry, 20) as geom
FROM
    coords_32633 as f,
    (SELECT ST_Collect(Geometry) as Geometry
     FROM sicilia_32633_linee) as g


time_start: 2014-05-11T17:58:25.689Z
time_end: 2014-05-11T17:58:26.460Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT
    f.PK_UID as gid, f.Ordine AS Ordine,
    ST_Snap(f.geometry, g.Geometry, 20) as geom
FROM
    coords_32633 as f,
    (SELECT ST_Collect(Geometry) as Geometry
     FROM sicilia_32633_linee) as g


time_start: 2014-05-11T17:58:48.073Z
time_end: 2014-05-11T17:58:48.844Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT
    f.PK_UID as gid, f.Ordine AS Ordine,
    ST_Snap(f.geometry, g.Geometry, 200) as geom
FROM
    coords_32633 as f,
    (SELECT ST_Collect(Geometry) as Geometry
     FROM sicilia_32633_linee) as g


time_start: 2014-05-11T17:59:13.425Z
time_end: 2014-05-11T17:59:15.553Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE TEST AS
SELECT
    f.PK_UID as gid, f.Ordine AS Ordine,
    ST_Snap(f.geometry, g.Geometry, 20) as geom
FROM
    coords_32633 as f,
    (SELECT ST_Collect(Geometry) as Geometry
     FROM sicilia_32633_linee) as g


time_start: 2014-05-11T18:01:52.281Z
time_end: 2014-05-11T18:01:54.634Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE TEST AS
SELECT
    f.PK_UID as gid, f.Ordine AS Ordine,
    ST_Snap(f.geometry, g.Geometry, 20000) as geom
FROM
    coords_32633 as f,
    (SELECT ST_Collect(Geometry) as Geometry
     FROM sicilia_32633_linee) as g


time_start: 2014-05-11T18:03:50.241Z
time_end: 2014-05-11T18:03:52.357Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE TEST AS
SELECT
    f.PK_UID as gid, f.Ordine AS Ordine,
    ST_Snap(f.geometry, g.Geometry, 200) as geom
FROM
    coords_32633 as f,
    (SELECT ST_Collect(Geometry) as Geometry
     FROM sicilia_32633) as g


time_start: 2014-05-11T18:12:39.753Z
time_end: 2014-05-11T18:12:39.771Z
user_agent: spatialite_gui
error_cause: SQL error: near "ON": syntax error
sql_statement:
SELECT DISTINCT ON(b.PK_UID) b.id as id_city, a.PK_UID as id_road, a.Geometry
FROM sicilia_32633_linee a INNER JOIN coords_32633 b
ON ST_DWithin(b.Geometry, a.Geometry, 20)
ORDER BY b.id, ST_Distance(a.Geometry, b.Geometry);


time_start: 2014-05-11T18:12:53.681Z
time_end: 2014-05-11T18:12:53.695Z
user_agent: spatialite_gui
error_cause: SQL error: near "ON": syntax error
sql_statement:
SELECT DISTINCT ON(b.PK_UID) b.id as id_city, a.PK_UID as id_road, a.Geometry
FROM sicilia_32633_linee AS a INNER JOIN coords_32633 AS b
ON ST_DWithin(b.Geometry, a.Geometry, 20)
ORDER BY b.id, ST_Distance(a.Geometry, b.Geometry);


time_start: 2014-05-11T18:14:56.993Z
time_end: 2014-05-11T18:14:57.007Z
user_agent: spatialite_gui
error_cause: SQL error: no such function: ST_Dwithin
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom
from sicilia_32633_linee a inner join coords_32633 b
on ST_Dwithin(a.Geometry, b.Geometry, 100)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T18:16:13.530Z
time_end: 2014-05-11T18:16:13.862Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom
from sicilia_32633_linee a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 100)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T18:16:25.939Z
time_end: 2014-05-11T18:16:26.574Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom
from sicilia_32633_linee a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 10)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T18:16:53.345Z
time_end: 2014-05-11T18:16:54.644Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE TEST AS
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom
from sicilia_32633_linee a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 10)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T18:19:41.946Z
time_end: 2014-05-11T18:19:42.055Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom
from sicilia_32633_linee a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 200)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T18:20:06.881Z
time_end: 2014-05-11T18:20:07.249Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 200)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T18:21:29.921Z
time_end: 2014-05-11T18:21:29.946Z
user_agent: spatialite_gui
error_cause: SQL error: near "b": syntax error
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom b.id_t
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 200)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T18:21:35.865Z
time_end: 2014-05-11T18:21:36.227Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom, b.id_t
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 200)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T18:22:32.617Z
time_end: 2014-05-11T18:22:34.351Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Create TABLE posizione AS
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom, b.id_t
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 200)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T18:23:10.892Z
time_end: 2014-05-11T18:23:10.935Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT "a"."id_t" AS "id_t", "b"."b.id_t" AS "b.id_t"
FROM "coords_32633" AS "a"
LEFT JOIN "posizione" AS "b" ON ("a"."id_t" = "b"."b.id_t")


time_start: 2014-05-11T18:24:09.137Z
time_end: 2014-05-11T18:24:09.255Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom, b.id_t
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 100)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T18:24:24.873Z
time_end: 2014-05-11T18:24:24.986Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom, b.id_t
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 150)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T18:24:31.441Z
time_end: 2014-05-11T18:24:31.646Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom, b.id_t
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 170)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T19:46:12.876Z
time_end: 2014-05-11T19:46:12.995Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as the_geom, b.id_t,b.Ordine, b.Tipo, b.ID
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 170)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T19:46:47.796Z
time_end: 2014-05-11T19:46:47.843Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE coordinate_ordini AS
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as Geometry, b.id_t,b.Ordine, b.Tipo, b.ID
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 170)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T19:47:06.300Z
time_end: 2014-05-11T19:47:06.406Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as Geometry, b.id_t,b.Ordine, b.Tipo, b.ID
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 170)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T19:47:15.252Z
time_end: 2014-05-11T19:47:15.369Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as Geometry, b.id_t,b.Ordine, b.Tipo, b.ID
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 150)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T19:55:41.740Z
time_end: 2014-05-11T19:55:42.299Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as Geometry, b.id_t,b.Ordine, b.Tipo, b.ID
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 150)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T19:56:15.220Z
time_end: 2014-05-11T19:56:15.745Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as Geometry, b.id_t,b.Ordine, b.Tipo, b.ID
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 100)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T19:56:42.980Z
time_end: 2014-05-11T19:56:51.797Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE TEST AS
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as Geometry, b.id_t,b.Ordine, b.Tipo, b.ID
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 100)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T20:00:48.428Z
time_end: 2014-05-11T20:00:55.541Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE CoordSnap AS
Select ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) as Geometry, b.id_t AS id_t,b.Ordine AS Ordine, 
b.Tipo AS Tipo, b.ID AS ID
from sicilia_32633 a inner join coords_32633 b
on PtDistWithin(a.Geometry, b.Geometry, 100)
group by b.PK_UID, b.Geometry;


time_start: 2014-05-11T20:01:17.323Z
time_end: 2014-05-11T20:01:17.391Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("Geometry"), Srid("Geometry"), CoordDimension("Geometry")
FROM "CoordSnap"
GROUP BY 2, 3, 4


time_start: 2014-05-12T20:23:34.544Z
time_end: 2014-05-12T20:23:34.633Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT "a"."Geometry" AS "Geometry", "b"."Ordinanza" AS "Ordinanza",
    "b"."Data" AS "Data", "b"."Zona" AS "Zona", "b"."MotivazioneDivieto" AS "MotivazioneDivieto",
    "b"."LatInizio" AS "LatInizio", "b"."LonInizio" AS "LonInizio",
    "b"."LatFine" AS "LatFine", "b"."LonFine" AS "LonFine",
    "b"."LunghDaOrd" AS "LunghDaOrd", "b"."LunghCalcolata" AS "LunghCalcolata",
    "b"."Note" AS "Note", "b"."URL_Ordinanza" AS "URL_Ordinanza"
FROM "linee" AS "a"
LEFT JOIN "Palermo" AS "b" ON ("a"."Orinanza" = "b"."Ordinanza")


time_start: 2014-05-12T20:24:11.950Z
time_end: 2014-05-12T20:24:12.012Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE Divieti AS
SELECT "a"."Geometry" AS "Geometry", "b"."Ordinanza" AS "Ordinanza",
    "b"."Data" AS "Data", "b"."Zona" AS "Zona", "b"."MotivazioneDivieto" AS "MotivazioneDivieto",
    "b"."LatInizio" AS "LatInizio", "b"."LonInizio" AS "LonInizio",
    "b"."LatFine" AS "LatFine", "b"."LonFine" AS "LonFine",
    "b"."LunghDaOrd" AS "LunghDaOrd", "b"."LunghCalcolata" AS "LunghCalcolata",
    "b"."Note" AS "Note", "b"."URL_Ordinanza" AS "URL_Ordinanza"
FROM "linee" AS "a"
LEFT JOIN "Palermo" AS "b" ON ("a"."Orinanza" = "b"."Ordinanza")


time_start: 2014-05-12T20:24:21.263Z
time_end: 2014-05-12T20:24:21.341Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("Geometry"), Srid("Geometry"), CoordDimension("Geometry")
FROM "Divieti"
GROUP BY 2, 3, 4


time_start: 2015-04-02T15:09:20.830Z
time_end: 2015-04-02T15:09:21.166Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("Geometry"), Srid("Geometry"), CoordDimension("Geometry")
FROM "sicilia_costa"
GROUP BY 2, 3, 4


time_start: 2015-04-02T15:45:20.618Z
time_end: 2015-04-02T15:45:25.732Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) AS Geometry
FROM sicilia_32633 a INNER JOIN coords_32633 b
ON PtDistWithin(a.Geometry, b.Geometry, 100)
GROUP BY b.PK_UID, b.Geometry;


time_start: 2015-04-02T15:46:07.323Z
time_end: 2015-04-02T15:46:07.418Z
user_agent: spatialite_gui
error_cause: SQL error: near "AS": syntax error
sql_statement:
CREATE TABLE AS coords_mooved AS SELECT ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) AS Geometry
FROM sicilia_32633 a INNER JOIN coords_32633 b
ON PtDistWithin(a.Geometry, b.Geometry, 100)
GROUP BY b.PK_UID, b.Geometry;


time_start: 2015-04-02T15:46:17.980Z
time_end: 2015-04-02T15:46:24.849Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE coords_mooved AS SELECT ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) AS Geometry
FROM sicilia_32633 a INNER JOIN coords_32633 b
ON PtDistWithin(a.Geometry, b.Geometry, 100)
GROUP BY b.PK_UID, b.Geometry;


time_start: 2015-04-02T15:46:34.349Z
time_end: 2015-04-02T15:46:34.491Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("Geometry"), Srid("Geometry"), CoordDimension("Geometry")
FROM "coords_mooved"
GROUP BY 2, 3, 4


time_start: 2015-04-02T15:56:11.749Z
time_end: 2015-04-02T15:56:18.484Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE coords_mooved AS SELECT ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) AS Geometry
FROM sicilia_32633 a INNER JOIN coords_32633 b
ON PtDistWithin(a.Geometry, b.Geometry, 180)
GROUP BY b.PK_UID, b.Geometry;


time_start: 2015-04-03T08:34:59.319Z
time_end: 2015-04-03T08:34:59.470Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, b."PK_UID", "Longitude", "Latitude", "Tipo", "ID_T", "ID", "Geometry"
FROM "coords_32633" AS b
ORDER BY ROWID


time_start: 2015-04-03T08:35:11.311Z
time_end: 2015-04-03T08:35:11.456Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, b."PK_UID", b."Longitude", b."Latitude", b."Tipo", b."ID_T", b."ID", b."Geometry"
FROM "coords_32633" AS b
ORDER BY ROWID


time_start: 2015-04-03T08:35:28.959Z
time_end: 2015-04-03T08:35:35.615Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE coords_mooved AS SELECT ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) AS Geometry,b."Longitude", b."Latitude", b."Tipo", b."ID_T", b."ID"
FROM sicilia_32633 a INNER JOIN coords_32633 b
ON PtDistWithin(a.Geometry, b.Geometry, 100)
GROUP BY b.PK_UID, b.Geometry;


time_start: 2015-04-03T08:35:41.647Z
time_end: 2015-04-03T08:35:46.726Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) AS Geometry,b."Longitude", b."Latitude", b."Tipo", b."ID_T", b."ID"
FROM sicilia_32633 a INNER JOIN coords_32633 b
ON PtDistWithin(a.Geometry, b.Geometry, 100)
GROUP BY b.PK_UID, b.Geometry;


time_start: 2015-04-03T09:39:08.943Z
time_end: 2015-04-03T09:39:10.541Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("Geometry"), Srid("Geometry"), CoordDimension("Geometry")
FROM "sicilia_costa2"
GROUP BY 2, 3, 4


time_start: 2015-04-03T09:40:35.363Z
time_end: 2015-04-03T09:40:35.877Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) AS Geometry,b."Longitude", b."Latitude", b."Tipo", b."ID_T", b."ID"
FROM sicilia_costa a INNER JOIN coords_32633 b
ON PtDistWithin(a.Geometry, b.Geometry, 100)
GROUP BY b.PK_UID, b.Geometry;


time_start: 2015-04-03T09:41:32.211Z
time_end: 2015-04-03T09:41:32.346Z
user_agent: spatialite_gui
error_cause: SQL error: near "Closestpoint": syntax error
sql_statement:
Closestpoint(ST_Collect(a.Geometry), b.Geometry) AS Geometry,b."Longitude" AS old_longitude, b."Latitude" AS old_latitude, b."Tipo", b."ID_T", b."ID"
FROM sicilia_costa a INNER JOIN coords_32633 b
ON PtDistWithin(a.Geometry, b.Geometry, 100)
GROUP BY b.PK_UID, b.Geometry;


time_start: 2015-04-03T09:41:56.668Z
time_end: 2015-04-03T09:41:57.200Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) AS Geometry,b."Longitude" AS old_longitude, b."Latitude" AS old_latitude, b."Tipo", b."ID_T", b."ID"
FROM sicilia_costa a INNER JOIN coords_32633 b
ON PtDistWithin(a.Geometry, b.Geometry, 100)
GROUP BY b.PK_UID, b.Geometry;


time_start: 2015-04-03T09:42:09.649Z
time_end: 2015-04-03T09:42:17.027Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE coords_mooved AS SELECT ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) AS Geometry,b."Longitude" AS old_longitude, b."Latitude" AS old_latitude, b."Tipo", b."ID_T", b."ID"
FROM sicilia_costa a INNER JOIN coords_32633 b
ON PtDistWithin(a.Geometry, b.Geometry, 100)
GROUP BY b.PK_UID, b.Geometry;


time_start: 2015-04-03T09:43:54.984Z
time_end: 2015-04-03T09:44:02.349Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE coords_mooved AS SELECT ST_Closestpoint(ST_Collect(a.Geometry), b.Geometry) AS Geometry,b."Longitude" AS old_longitude, b."Latitude" AS old_latitude, b."Tipo" AS Tipo, b."ID_T" AS ID_T, b."ID" AS ID
FROM sicilia_costa a INNER JOIN coords_32633 b
ON PtDistWithin(a.Geometry, b.Geometry, 100)
GROUP BY b.PK_UID, b.Geometry;


time_start: 2015-04-05T07:48:43.387Z
time_end: 2015-04-05T07:48:56.937Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE "PalermoLimiteAmministrativo" AS
SELECT "PK_UID", "COD_REG", "COD_PRO", "PRO_COM", "NOME_COM", "NOME_TED", "SHAPE_Leng", "SHAPE_Area",Boundary(geometry) AS "Geometry"
FROM "sicilia_32633"


time_start: 2015-04-05T07:49:42.247Z
time_end: 2015-04-05T07:49:42.428Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("Geometry"), Srid("Geometry"), CoordDimension("Geometry")
FROM "PalermoLimiteAmministrativo"
GROUP BY 2, 3, 4


time_start: 2015-04-05T07:55:48.483Z
time_end: 2015-04-05T07:55:49.468Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT "PK_UID", "COD_REG", "COD_PRO", "PRO_COM", "NOME_COM", "NOME_TED", "SHAPE_Leng", "SHAPE_Area",Boundary(geometry) AS "Geometry"
FROM "sicilia_32633"
WHERE NOME_COM LIKE "Palermo" OR "Ficarazzi"


time_start: 2015-04-05T07:56:57.657Z
time_end: 2015-04-05T07:56:57.848Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT "PK_UID", "COD_REG", "COD_PRO", "PRO_COM", "NOME_COM", "NOME_TED", "SHAPE_Leng", "SHAPE_Area",Boundary(geometry) AS "Geometry"
FROM "sicilia_32633"
WHERE NOME_COM LIKE "Ficarazzi" OR "Ficarazzi"


time_start: 2015-04-05T07:57:22.045Z
time_end: 2015-04-05T07:57:22.157Z
user_agent: spatialite_gui
error_cause: SQL error: near "WHERE": syntax error
sql_statement:
SELECT "PK_UID", "COD_REG", "COD_PRO", "PRO_COM", "NOME_COM", "NOME_TED", "SHAPE_Leng", "SHAPE_Area",Boundary(geometry) AS "Geometry"
FROM "sicilia_32633"
WHERE NOME_COM LIKE "Palermo" OR WHERE NOME_COM LIKE "Ficarazzi"


time_start: 2015-04-05T07:57:29.748Z
time_end: 2015-04-05T07:57:29.790Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT "PK_UID", "COD_REG", "COD_PRO", "PRO_COM", "NOME_COM", "NOME_TED", "SHAPE_Leng", "SHAPE_Area",Boundary(geometry) AS "Geometry"
FROM "sicilia_32633"
WHERE NOME_COM LIKE "Palermo" OR NOME_COM LIKE "Ficarazzi"


time_start: 2015-04-05T07:58:32.728Z
time_end: 2015-04-05T07:58:33.369Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE "ContornoPerCosta" AS
SELECT "PK_UID", "COD_REG", "COD_PRO", "PRO_COM", "NOME_COM", "NOME_TED", "SHAPE_Leng", "SHAPE_Area",Boundary(geometry) AS "Geometry"
FROM "sicilia_32633"
WHERE NOME_COM LIKE "Palermo" OR NOME_COM LIKE "Ficarazzi"


time_start: 2015-04-05T07:58:58.284Z
time_end: 2015-04-05T07:58:58.333Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("Geometry"), Srid("Geometry"), CoordDimension("Geometry")
FROM "ContornoPerCosta"
GROUP BY 2, 3, 4


time_start: 2015-04-05T08:05:01.033Z
time_end: 2015-04-05T08:05:01.073Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE Table "trash" AS
SELECT
ST_Split(a.geometry, b.geometry)
FROM "ContornoPerCosta" AS a, "coords_mooved" AS b;


time_start: 2015-04-05T08:05:15.358Z
time_end: 2015-04-05T08:05:15.447Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("ST_Split(a.geometry, b.geometry)"), Srid("ST_Split(a.geometry, b.geometry)"), CoordDimension("ST_Split(a.geometry, b.geometry)")
FROM "trash"
GROUP BY 2, 3, 4


time_start: 2015-04-05T08:07:43.860Z
time_end: 2015-04-05T08:07:43.907Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE Table "trash" AS
SELECT
ST_Split(a.geometry, b.geometry) AS Geometry
FROM "ContornoPerCosta" AS a, "coords_mooved" AS b;


time_start: 2015-04-05T08:07:54.406Z
time_end: 2015-04-05T08:07:54.525Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("Geometry"), Srid("Geometry"), CoordDimension("Geometry")
FROM "trash"
GROUP BY 2, 3, 4


time_start: 2015-04-05T08:09:26.059Z
time_end: 2015-04-05T08:09:26.319Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE Table "trash2" AS
SELECT ROWID, "Geometry"
FROM "trash"
WHERE GeometryType("Geometry") Like "LineString"


time_start: 2015-04-05T08:09:35.861Z
time_end: 2015-04-05T08:09:35.912Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("Geometry"), Srid("Geometry"), CoordDimension("Geometry")
FROM "trash2"
GROUP BY 2, 3, 4


time_start: 2015-04-05T08:22:20.231Z
time_end: 2015-04-05T08:22:20.286Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("Geometry"), Srid("Geometry"), CoordDimension("Geometry")
FROM "ContornoPerCosta_elem"
GROUP BY 2, 3, 4


time_start: 2015-04-05T08:23:18.499Z
time_end: 2015-04-05T08:23:18.754Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE Table "trash" AS
SELECT
ST_Split(a.geometry, b.geometry) AS Geometry
FROM "ContornoPerCosta_elem" AS a, "coords_mooved" AS b;


time_start: 2015-04-08T18:57:39.462Z
time_end: 2015-04-08T18:57:39.475Z
user_agent: spatialite_gui
error_cause: SQL error: no such column: ContornoPerCosta_elem.geometry
sql_statement:
SELECT ST_Split(ContornoPerCosta_elem.geometry, coords_mooved.geometry) 
From ContornoPerCosta, coords_mooved


time_start: 2015-04-08T18:57:55.398Z
time_end: 2015-04-08T18:57:55.412Z
user_agent: spatialite_gui
error_cause: SQL error: no such column: ContornoPerCosta_elem.Geometry
sql_statement:
SELECT ST_Split(ContornoPerCosta_elem.Geometry, coords_mooved.Geometry) 
From ContornoPerCosta, coords_mooved


time_start: 2015-04-08T18:58:18.510Z
time_end: 2015-04-08T18:58:18.534Z
user_agent: spatialite_gui
error_cause: SQL error: no such column: ContornoPerCosta_elem.Geometry
sql_statement:
SELECT ST_Split("ContornoPerCosta_elem".Geometry, "coords_mooved".Geometry) 
From ContornoPerCosta, coords_mooved


time_start: 2015-04-08T18:58:38.943Z
time_end: 2015-04-08T18:58:38.960Z
user_agent: spatialite_gui
error_cause: SQL error: no such column: ContornoPerCosta_elem.Geometry
sql_statement:
SELECT ST_Split("ContornoPerCosta_elem".Geometry, "coords_mooved".Geometry) 
From ContornoPerCosta, coords_mooved


time_start: 2015-04-08T19:00:24.655Z
time_end: 2015-04-08T19:00:24.735Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Split("ContornoPerCosta_elem"."Geometry","coords_32633"."Geometry")
FROM "ContornoPerCosta_elem","coords_32633"


time_start: 2015-04-08T19:00:56.286Z
time_end: 2015-04-08T19:00:56.501Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Create Table "trash" AS
SELECT ST_Split("ContornoPerCosta_elem"."Geometry","coords_32633"."Geometry")
FROM "ContornoPerCosta_elem","coords_32633"


time_start: 2015-04-08T19:06:15.191Z
time_end: 2015-04-08T19:06:15.241Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*), GeometryType("ST_Split(""ContornoPerCosta_elem"".""Geometry"",""coords_32633"".""Geometry"")"), Srid("ST_Split(""ContornoPerCosta_elem"".""Geometry"",""coords_32633"".""Geometry"")"), CoordDimension("ST_Split(""ContornoPerCosta_elem"".""Geometry"",""coords_32633"".""Geometry"")")
FROM "trash"
GROUP BY 2, 3, 4


time_start: 2015-04-08T19:07:15.799Z
time_end: 2015-04-08T19:07:16.543Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Create Table "trash" AS
SELECT ST_Split("ContornoPerCosta_elem"."Geometry","coords_32633"."Geometry") AS Geometry
FROM "ContornoPerCosta_elem","coords_32633"


time_start: 2015-04-08T19:10:35.281Z
time_end: 2015-04-08T19:10:35.450Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Split(input."Geometry",blade."Geometry") AS Geometry,
ST_SplitLeft(input.Geometry, blade.Geometry), 
ST_SplitRight(input.Geometry, blade.Geometry)
FROM "ContornoPerCosta_elem" as input,"coords_32633" as blade


time_start: 2015-04-08T19:11:10.054Z
time_end: 2015-04-08T19:11:11.357Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
Create Table "trash" AS
SELECT ST_Split(input."Geometry",blade."Geometry") AS Geometry,
ST_SplitLeft(input.Geometry, blade.Geometry), 
ST_SplitRight(input.Geometry, blade.Geometry)
FROM "ContornoPerCosta_elem" as input,"coords_32633" as blade


time_start: 2015-04-08T19:12:51.102Z
time_end: 2015-04-08T19:12:51.137Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Split(input."Geometry",blade."Geometry") AS Geometry,
ST_SplitLeft(input.Geometry, blade.Geometry), 
ST_SplitRight(input.Geometry, blade.Geometry)
FROM "ContornoPerCosta_elem" as input,"coords_32633" as blade


time_start: 2015-04-08T19:13:14.743Z
time_end: 2015-04-08T19:13:14.777Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Split(input."Geometry",blade."Geometry") AS Geometry,
ST_SplitLeft(input.Geometry, blade.Geometry) AS left, 
ST_SplitRight(input.Geometry, blade.Geometry) AS right
FROM "ContornoPerCosta_elem" as input,"coords_32633" as blade


time_start: 2015-04-08T19:23:47.575Z
time_end: 2015-04-08T19:23:47.607Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ST_Split(input."Geometry",blade."Geometry") AS Geometry,
ST_SplitLeft(input.Geometry, blade.Geometry), 
ST_SplitRight(input.Geometry, blade.Geometry)
FROM "ContornoPerCosta_elem" as input,"coords_mooved" as blade


