# spatial_ref_sys

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"]],AUTHORITY["EPSG","4326"]]


# sql_statements_log

time_start: 2016-03-27T21:07:30.669Z
time_end: 2016-03-27T21:07:30.684Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
create table "pk_text" ( "pk_txt" text primary key);
SELECT AddGeometryColumn("pk_txt", "geometry", 4326, "POINT", "XY", 0);


time_start: 2016-03-27T21:08:13.220Z
time_end: 2016-03-27T21:08:13.234Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
create table "pk_integers" ( "pk_int" integer primary key autoincrement);
SELECT AddGeometryColumn("pk_integers", "geometry", 4326, "POINT", "XY", 0);


time_start: 2016-03-27T21:09:13.245Z
time_end: 2016-03-27T21:09:13.253Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "srid", "auth_name", "auth_srid", "ref_sys_name", "proj4text", "srtext"
FROM "spatial_ref_sys"
where srid = 4326


time_start: 2016-03-27T21:09:33.570Z
time_end: 2016-03-27T21:09:33.578Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "srid", "auth_name", "auth_srid", "ref_sys_name", "proj4text", "srtext"
FROM "spatial_ref_sys"
where srid not in (0,1,-1,4326)


time_start: 2016-03-27T21:09:38.970Z
time_end: 2016-03-27T21:09:38.984Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT ROWID, "srid", "auth_name", "auth_srid", "ref_sys_name", "proj4text", "srtext"
FROM "spatial_ref_sys"
ORDER BY ROWID


