# spatial_ref_sys

auth_name: epsg
ref_sys_name: ED50 / UTM zone 32N
proj4text: +proj=utm +zone=32 +ellps=intl +towgs84=-87,-98,-121,0,0,0,0 +units=m +no_defs
srtext:
PROJCS["ED50 / UTM zone 32N",GEOGCS["ED50",DATUM["European_Datum_1950",SPHEROID["International 1924",6378388,297,AUTHORITY["EPSG","7022"]],TOWGS84[-87,-98,-121,0,0,0,0],AUTHORITY["EPSG","6230"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4230"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",9],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","23032"]]


# sql_statements_log

time_start: 2013-10-31T19:07:23.099Z
time_end: 2013-10-31T19:07:23.278Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "PK_UID", "COD_REG", "COD_PRO", "PRO_COM", "NOME_COM", "NOME_TED", "SHAPE_Leng", "SHAPE_Area", "Geometry"
FROM "com"
where nome_com like '%arezzo'


time_start: 2013-10-31T19:13:29.747Z
time_end: 2013-10-31T19:13:30.027Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*) FROM comuni AS a, comuni AS b WHERE a.name = 'Arezzo' AND ST_Equals(a.geometry, b.geometry) = 1


time_start: 2013-10-31T19:14:29.429Z
time_end: 2013-10-31T19:14:29.647Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*) FROM comuni AS a, comuni AS b WHERE a.name = 'Arezzo' AND a.rowid <> b.rowid AND ST_Equals(a.geometry, b.geometry) = 1


time_start: 2013-10-31T19:15:04.316Z
time_end: 2013-10-31T19:15:04.517Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*) FROM comuni AS a, comuni AS b WHERE a.rowid = 2 AND b.rowid <> 2 AND ST_Equals(a.geometry, b.geometry) = 1


time_start: 2013-10-31T19:15:15.188Z
time_end: 2013-10-31T19:15:15.387Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Count(*) FROM comuni AS a, comuni AS b WHERE a.rowid = 2 AND b.rowid <> 2 AND ST_Disjoint(a.geometry, b.geometry) = 1


time_start: 2013-11-07T11:39:48.377Z
time_end: 2013-11-07T11:39:48.474Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT AsEwkt(BdMPolyFromText('MULTILINESTRING((0 0, 10 0, 10 10, 0 10, 0 0),(2 2, 2 8, 8 8, 8 2, 2 2))'));


time_start: 2013-11-07T11:40:11.360Z
time_end: 2013-11-07T11:40:11.379Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT AsText(ST_ForceLHR(GUnion(GeomFromText("POLYGON((10 10, 15 10, 15 15, 10 15, 10 10))"), GeomFromText("POLYGON((1 1, 2 1, 2 2, 1 2, 1 1))"))));


