# spatial_ref_sys

auth_name: epsg
ref_sys_name: Monte Mario / Italy zone 1
proj4text:
+proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +towgs84=-104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68 +units=m +no_defs

srtext:
PROJCS["Monte Mario / Italy zone 1",GEOGCS["Monte Mario",DATUM["Monte_Mario",SPHEROID["International 1924",6378388,297,AUTHORITY["EPSG","7022"]],TOWGS84[-104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68],AUTHORITY["EPSG","6265"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4265"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",9],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",1500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","3003"]]


auth_name: epsg
ref_sys_name: WGS 84
proj4text: +proj=longlat +datum=WGS84 +no_defs
srtext:
GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4326"]]


# sql_statements_log

time_start: 2018-03-05T11:11:29.029Z
time_end: 2018-03-05T11:11:29.041Z
user_agent: spatialite_gui
error_cause: SQL error: near ")": syntax error
sql_statement:
CREATE TABLE bad_roads_1 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from TEXT NOT NULL,
    node_to TEXT NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL,
)


time_start: 2018-03-05T11:11:36.674Z
time_end: 2018-03-05T11:11:36.715Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_1 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from TEXT NOT NULL,
    node_to TEXT NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T11:11:43.516Z
time_end: 2018-03-05T11:11:43.564Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_2 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from TEXT NOT NULL,
    node_to TEXT NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T11:16:01.149Z
time_end: 2018-03-05T11:16:01.177Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_1 VALUES(NULL, 1.1, 'a', 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T11:16:45.834Z
time_end: 2018-03-05T11:16:45.901Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_2 VALUES(NULL, 'a', 'b', 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T11:16:53.730Z
time_end: 2018-03-05T11:16:53.761Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_2 VALUES(NULL, 1, 'b', 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T11:17:37.350Z
time_end: 2018-03-05T11:17:37.376Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_3 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from TEXT NOT NULL,
    node_to TEXT NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T11:17:45.750Z
time_end: 2018-03-05T11:17:45.789Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_4 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from TEXT NOT NULL,
    node_to TEXT NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T11:18:49.593Z
time_end: 2018-03-05T11:18:49.635Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_3 VALUES(NULL, 'a', 1.1, 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T11:19:23.085Z
time_end: 2018-03-05T11:19:23.118Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_4 VALUES(NULL, 'a', 'b', 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T11:19:29.042Z
time_end: 2018-03-05T11:19:29.067Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_4 VALUES(NULL, 'a', 1, 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T11:45:17.433Z
time_end: 2018-03-05T11:45:17.442Z
user_agent: spatialite_gui
error_cause: SQL error: table bad_roads_3 already exists
sql_statement:
CREATE TABLE bad_roads_3 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T11:46:23.905Z
time_end: 2018-03-05T11:46:23.928Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_2 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T11:46:29.951Z
time_end: 2018-03-05T11:46:29.981Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_4 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T11:47:48.128Z
time_end: 2018-03-05T11:47:48.164Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_4 VALUES(NULL, 1, 2, 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T11:48:07.600Z
time_end: 2018-03-05T11:48:07.637Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_4 VALUES(NULL, 3, 'node', 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T11:48:34.121Z
time_end: 2018-03-05T11:48:34.143Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_2 VALUES(NULL, 1, 2, 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T11:48:42.465Z
time_end: 2018-03-05T11:48:42.480Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_2 VALUES(NULL, 'node', 2, 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T12:02:05.982Z
time_end: 2018-03-05T12:02:05.999Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_5 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T12:02:12.255Z
time_end: 2018-03-05T12:02:12.276Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_6 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T12:02:18.582Z
time_end: 2018-03-05T12:02:18.609Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_7 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T12:07:30.068Z
time_end: 2018-03-05T12:07:30.087Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_6 VALUES(NULL, 'node', 2, 1, 'name', 1, 1, ST_GeomFromText('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 3003) )


time_start: 2018-03-05T12:08:36.673Z
time_end: 2018-03-05T12:08:36.697Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_7 VALUES(NULL,1, 2, 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3004) )


time_start: 2018-03-05T12:12:12.835Z
time_end: 2018-03-05T12:12:12.869Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_7 VALUES(0, 3, 4, 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T12:21:45.277Z
time_end: 2018-03-05T12:21:45.306Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_8 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T12:21:53.037Z
time_end: 2018-03-05T12:21:53.075Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_9 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T12:22:01.047Z
time_end: 2018-03-05T12:22:01.060Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_10 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T12:23:13.933Z
time_end: 2018-03-05T12:23:13.957Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_7 VALUES(0, 1, 2, 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T12:23:27.850Z
time_end: 2018-03-05T12:23:27.884Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_8 VALUES(0, 1, 2, 1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T12:23:52.922Z
time_end: 2018-03-05T12:23:52.950Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_8 VALUES(NULL, 3, 4, 1, 'name', 1, 1, ST_GeomFromText('LINESTRINGZ(0 0 0, 1 1 1)', 3003) )


time_start: 2018-03-05T12:28:25.885Z
time_end: 2018-03-05T12:28:25.902Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_10 VALUES(NULL, 1, 2, 'cost', 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T12:57:06.434Z
time_end: 2018-03-05T12:57:06.449Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_11 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T12:57:45.906Z
time_end: 2018-03-05T12:57:45.920Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_11 VALUES(NULL, 1, 2, -1, 'name', 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T13:02:19.490Z
time_end: 2018-03-05T13:02:19.502Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_12 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T13:02:26.256Z
time_end: 2018-03-05T13:02:26.271Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_13 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T13:02:31.858Z
time_end: 2018-03-05T13:02:31.874Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_14 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T13:04:00.712Z
time_end: 2018-03-05T13:04:00.727Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_12 VALUES(NULL, 1, 2, 1, zeroblob(40), 1, 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T13:04:19.673Z
time_end: 2018-03-05T13:04:19.696Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_13 VALUES(NULL, 1, 2, 1, 1, zeroblob(40), 1, ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T13:04:36.068Z
time_end: 2018-03-05T13:04:36.087Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_14 VALUES(NULL, 1, 2, 1, 1, 1, zeroblob(40), ST_GeomFromText('LINESTRING(0 0, 1 1)', 3003) )


time_start: 2018-03-05T13:11:04.984Z
time_end: 2018-03-05T13:11:04.995Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_15 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from INTEGER NOT NULL,
    node_to INTEGER NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T13:11:29.467Z
time_end: 2018-03-05T13:11:29.490Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE bad_roads_16 (
    id INTEGER NOT NULL PRIMARY KEY,
    node_from TEXT NOT NULL,
    node_to TEXT NOT NULL,
    cost DOUBLE NOT NULL,
    road_name TEXT NOT NULL,
    oneway_from_to INTEGER NOT NULL,
    oneway_to_from INTEGER NOT NULL
)


time_start: 2018-03-05T13:13:05.487Z
time_end: 2018-03-05T13:13:05.506Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_15 VALUES(NULL, 1, 2, 1, 1, 1, 1, ST_GeomFromText('LINESTRINGZ(0 0 0, 1 1 1)', 3003) )


time_start: 2018-03-05T13:13:19.807Z
time_end: 2018-03-05T13:13:19.821Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_15 VALUES(NULL, 2, 3, 1, 1, 1, 1, ST_GeomFromText('LINESTRINGZ(0 0 0, 1 1 1)', 3003) )


time_start: 2018-03-05T13:13:55.541Z
time_end: 2018-03-05T13:13:55.555Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_15 VALUES(NULL, 'one', 'two', 1, 1, 1, 1, ST_GeomFromText('LINESTRINGZ(0 0 0, 1 1 1)', 3003) )


time_start: 2018-03-05T13:14:11.348Z
time_end: 2018-03-05T13:14:11.362Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_15 VALUES(NULL, 'two', 'three', 1, 1, 1, 1, ST_GeomFromText('LINESTRINGZ(0 0 0, 1 1 1)', 3003) )


time_start: 2018-03-05T13:14:50.953Z
time_end: 2018-03-05T13:14:50.960Z
user_agent: spatialite_gui
error_cause: SQL error: table bad_roads_16 has 7 columns but 8 values were supplied
sql_statement:
INSERT INTO bad_roads_16 VALUES(NULL, 'one', 'two', 1, 1, 1, 1, ST_GeomFromText('LINESTRINGZ(0 0 0, 1 1 1)', 3003) )


time_start: 2018-03-05T13:16:25.700Z
time_end: 2018-03-05T13:16:25.713Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO bad_roads_16 VALUES(NULL, 'two', 'three', 1, 1, 1, 1, ST_GeomFromText('LINESTRINGZ(0 0 0, 1 1 1)', 3003) )


