# 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"]],AXIS["Latitude",NORTH],AXIS["Longitude",EAST],AUTHORITY["EPSG","4326"]]


auth_name: epsg
ref_sys_name: WGS 84 / UTM zone 31N
proj4text: +proj=utm +zone=31 +datum=WGS84 +units=m +no_defs
srtext:
PROJCS["WGS 84 / UTM zone 31N",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"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",3],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","32631"]]


# sql_statements_log

time_start: 2017-05-20T14:21:22.942Z
time_end: 2017-05-20T14:21:22.971Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT extent_minx + ((extent_maxx - extent_minx) / 2.0), extent_miny + ((extent_maxy - extent_miny) / 2.0), 
      (extent_maxx - extent_minx) / 2.0, (extent_maxy - extent_miny) / 2.0 
FROM vector_coverages_ref_sys WHERE srid = 32631


time_start: 2017-05-20T14:22:53.576Z
time_end: 2017-05-20T14:22:53.599Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Min(extent_minx), Max(extent_maxx), Min(extent_miny), Max(extent_maxy) 
FROM vector_coverages_ref_sys WHERE srid = 32631


time_start: 2017-05-20T14:39:26.247Z
time_end: 2017-05-20T14:39:26.271Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Min(extent_minx), Max(extent_maxx), Min(extent_miny), Max(extent_maxy) FROM vector_coverages_ref_sys WHERE srid = 4326


time_start: 2017-05-20T14:39:39.450Z
time_end: 2017-05-20T14:39:39.475Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Min(extent_minx), Max(extent_maxx), Min(extent_miny), Max(extent_maxy) FROM vector_coverages_ref_sys WHERE srid = 32631


time_start: 2017-05-20T15:01:36.439Z
time_end: 2017-05-20T15:01:36.468Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE countries_z (
pk_uid INTEGER PRIMARY KEY AUTOINCREMENT,
scalerank INTEGER,
featurecla TEXT,
labelrank DOUBLE,
sovereignt TEXT,
sov_a3 TEXT,
adm0_dif DOUBLE,
level DOUBLE,
type TEXT,
admin TEXT,
adm0_a3 TEXT,
geou_dif DOUBLE,
geounit TEXT,
gu_a3 TEXT,
su_dif DOUBLE,
subunit TEXT,
su_a3 TEXT,
brk_diff DOUBLE,
name TEXT,
name_long TEXT,
brk_a3 TEXT,
brk_name TEXT,
brk_group TEXT,
abbrev TEXT,
postal TEXT,
formal_en TEXT,
formal_fr TEXT,
note_adm0 TEXT,
note_brk TEXT,
name_sort TEXT,
name_alt TEXT,
mapcolor7 DOUBLE,
mapcolor8 DOUBLE,
mapcolor9 DOUBLE,
mapcolor13 DOUBLE,
pop_est DOUBLE,
gdp_md_est DOUBLE,
pop_year DOUBLE,
lastcensus DOUBLE,
gdp_year DOUBLE,
economy TEXT,
income_grp TEXT,
wikipedia DOUBLE,
fips_10 TEXT,
iso_a2 TEXT,
iso_a3 TEXT,
iso_n3 TEXT,
un_a3 TEXT,
wb_a2 TEXT,
wb_a3 TEXT,
woe_id DOUBLE,
adm0_a3_is TEXT,
adm0_a3_us TEXT,
adm0_a3_un DOUBLE,
adm0_a3_wb DOUBLE,
continent TEXT,
region_un TEXT,
subregion TEXT,
region_wb TEXT,
name_len DOUBLE,
long_len DOUBLE,
abbrev_len DOUBLE,
tiny DOUBLE,
homepart DOUBLE)


time_start: 2017-05-20T15:02:00.623Z
time_end: 2017-05-20T15:02:00.670Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE countries_m (
pk_uid INTEGER PRIMARY KEY AUTOINCREMENT,
scalerank INTEGER,
featurecla TEXT,
labelrank DOUBLE,
sovereignt TEXT,
sov_a3 TEXT,
adm0_dif DOUBLE,
level DOUBLE,
type TEXT,
admin TEXT,
adm0_a3 TEXT,
geou_dif DOUBLE,
geounit TEXT,
gu_a3 TEXT,
su_dif DOUBLE,
subunit TEXT,
su_a3 TEXT,
brk_diff DOUBLE,
name TEXT,
name_long TEXT,
brk_a3 TEXT,
brk_name TEXT,
brk_group TEXT,
abbrev TEXT,
postal TEXT,
formal_en TEXT,
formal_fr TEXT,
note_adm0 TEXT,
note_brk TEXT,
name_sort TEXT,
name_alt TEXT,
mapcolor7 DOUBLE,
mapcolor8 DOUBLE,
mapcolor9 DOUBLE,
mapcolor13 DOUBLE,
pop_est DOUBLE,
gdp_md_est DOUBLE,
pop_year DOUBLE,
lastcensus DOUBLE,
gdp_year DOUBLE,
economy TEXT,
income_grp TEXT,
wikipedia DOUBLE,
fips_10 TEXT,
iso_a2 TEXT,
iso_a3 TEXT,
iso_n3 TEXT,
un_a3 TEXT,
wb_a2 TEXT,
wb_a3 TEXT,
woe_id DOUBLE,
adm0_a3_is TEXT,
adm0_a3_us TEXT,
adm0_a3_un DOUBLE,
adm0_a3_wb DOUBLE,
continent TEXT,
region_un TEXT,
subregion TEXT,
region_wb TEXT,
name_len DOUBLE,
long_len DOUBLE,
abbrev_len DOUBLE,
tiny DOUBLE,
homepart DOUBLE)


time_start: 2017-05-20T15:02:08.245Z
time_end: 2017-05-20T15:02:08.309Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE countries_zm (
pk_uid INTEGER PRIMARY KEY AUTOINCREMENT,
scalerank INTEGER,
featurecla TEXT,
labelrank DOUBLE,
sovereignt TEXT,
sov_a3 TEXT,
adm0_dif DOUBLE,
level DOUBLE,
type TEXT,
admin TEXT,
adm0_a3 TEXT,
geou_dif DOUBLE,
geounit TEXT,
gu_a3 TEXT,
su_dif DOUBLE,
subunit TEXT,
su_a3 TEXT,
brk_diff DOUBLE,
name TEXT,
name_long TEXT,
brk_a3 TEXT,
brk_name TEXT,
brk_group TEXT,
abbrev TEXT,
postal TEXT,
formal_en TEXT,
formal_fr TEXT,
note_adm0 TEXT,
note_brk TEXT,
name_sort TEXT,
name_alt TEXT,
mapcolor7 DOUBLE,
mapcolor8 DOUBLE,
mapcolor9 DOUBLE,
mapcolor13 DOUBLE,
pop_est DOUBLE,
gdp_md_est DOUBLE,
pop_year DOUBLE,
lastcensus DOUBLE,
gdp_year DOUBLE,
economy TEXT,
income_grp TEXT,
wikipedia DOUBLE,
fips_10 TEXT,
iso_a2 TEXT,
iso_a3 TEXT,
iso_n3 TEXT,
un_a3 TEXT,
wb_a2 TEXT,
wb_a3 TEXT,
woe_id DOUBLE,
adm0_a3_is TEXT,
adm0_a3_us TEXT,
adm0_a3_un DOUBLE,
adm0_a3_wb DOUBLE,
continent TEXT,
region_un TEXT,
subregion TEXT,
region_wb TEXT,
name_len DOUBLE,
long_len DOUBLE,
abbrev_len DOUBLE,
tiny DOUBLE,
homepart DOUBLE)


time_start: 2017-05-20T15:06:09.523Z
time_end: 2017-05-20T15:06:09.563Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO countries_z SELECT
pk_uid,
scalerank,
featurecla,
labelrank,
sovereignt,
sov_a3,
adm0_dif,
level,
type,
admin,
adm0_a3,
geou_dif,
geounit,
gu_a3,
su_dif,
subunit,
su_a3,
brk_diff,
name,
name_long,
brk_a3,
brk_name,
brk_group,
abbrev,
postal,
formal_en,
formal_fr,
note_adm0,
note_brk,
name_sort,
name_alt,
mapcolor7,
mapcolor8,
mapcolor9,
mapcolor13,
pop_est,
gdp_md_est,
pop_year,
lastcensus,
gdp_year,
economy,
income_grp,
wikipedia,
fips_10,
iso_a2,
iso_a3,
iso_n3,
un_a3,
wb_a2,
wb_a3,
woe_id,
adm0_a3_is,
adm0_a3_us,
adm0_a3_un,
adm0_a3_wb,
continent,
region_un,
subregion,
region_wb,
name_len,
long_len,
abbrev_len,
tiny,
homepart, CastToXYZ(geometry) FROM countries


time_start: 2017-05-20T15:06:32.731Z
time_end: 2017-05-20T15:06:32.769Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO countries_m SELECT
pk_uid,
scalerank,
featurecla,
labelrank,
sovereignt,
sov_a3,
adm0_dif,
level,
type,
admin,
adm0_a3,
geou_dif,
geounit,
gu_a3,
su_dif,
subunit,
su_a3,
brk_diff,
name,
name_long,
brk_a3,
brk_name,
brk_group,
abbrev,
postal,
formal_en,
formal_fr,
note_adm0,
note_brk,
name_sort,
name_alt,
mapcolor7,
mapcolor8,
mapcolor9,
mapcolor13,
pop_est,
gdp_md_est,
pop_year,
lastcensus,
gdp_year,
economy,
income_grp,
wikipedia,
fips_10,
iso_a2,
iso_a3,
iso_n3,
un_a3,
wb_a2,
wb_a3,
woe_id,
adm0_a3_is,
adm0_a3_us,
adm0_a3_un,
adm0_a3_wb,
continent,
region_un,
subregion,
region_wb,
name_len,
long_len,
abbrev_len,
tiny,
homepart, CastToXYM(geometry) FROM countries


time_start: 2017-05-20T15:06:43.159Z
time_end: 2017-05-20T15:06:43.199Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO countries_zm SELECT
pk_uid,
scalerank,
featurecla,
labelrank,
sovereignt,
sov_a3,
adm0_dif,
level,
type,
admin,
adm0_a3,
geou_dif,
geounit,
gu_a3,
su_dif,
subunit,
su_a3,
brk_diff,
name,
name_long,
brk_a3,
brk_name,
brk_group,
abbrev,
postal,
formal_en,
formal_fr,
note_adm0,
note_brk,
name_sort,
name_alt,
mapcolor7,
mapcolor8,
mapcolor9,
mapcolor13,
pop_est,
gdp_md_est,
pop_year,
lastcensus,
gdp_year,
economy,
income_grp,
wikipedia,
fips_10,
iso_a2,
iso_a3,
iso_n3,
un_a3,
wb_a2,
wb_a3,
woe_id,
adm0_a3_is,
adm0_a3_us,
adm0_a3_un,
adm0_a3_wb,
continent,
region_un,
subregion,
region_wb,
name_len,
long_len,
abbrev_len,
tiny,
homepart, CastToXYZM(geometry) FROM countries


time_start: 2017-05-20T15:11:55.242Z
time_end: 2017-05-20T15:11:55.287Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE populated_places_m (
pk_uid INTEGER PRIMARY KEY AUTOINCREMENT,
scalerank INTEGER,
natscale INTEGER,
labelrank INTEGER,
featurecla TEXT,
name TEXT,
namepar TEXT,
namealt TEXT,
diffascii INTEGER,
nameascii TEXT,
adm0cap DOUBLE,
capalt DOUBLE,
capin TEXT,
worldcity DOUBLE,
megacity INTEGER,
sov0name TEXT,
sov_a3 TEXT,
adm0name TEXT,
adm0_a3 TEXT,
adm1name TEXT,
iso_a2 TEXT,
note TEXT,
latitude DOUBLE,
longitude DOUBLE,
changed DOUBLE,
namediff INTEGER,
diffnote TEXT,
pop_max INTEGER,
pop_min INTEGER,
pop_other INTEGER,
rank_max INTEGER,
rank_min INTEGER,
geonameid DOUBLE,
meganame TEXT,
ls_name TEXT,
ls_match INTEGER,
checkme INTEGER,
max_pop10 DOUBLE,
max_pop20 DOUBLE,
max_pop50 DOUBLE,
max_pop300 DOUBLE,
max_pop310 DOUBLE,
max_natsca DOUBLE,
min_areakm DOUBLE,
max_areakm DOUBLE,
min_areami DOUBLE,
max_areami DOUBLE,
min_perkm DOUBLE,
max_perkm DOUBLE,
min_permi DOUBLE,
max_permi DOUBLE,
min_bbxmin DOUBLE,
max_bbxmin DOUBLE,
min_bbxmax DOUBLE,
max_bbxmax DOUBLE,
min_bbymin DOUBLE,
max_bbymin DOUBLE,
min_bbymax DOUBLE,
max_bbymax DOUBLE,
mean_bbxc DOUBLE,
mean_bbyc DOUBLE,
compare INTEGER,
gn_ascii TEXT,
feature_cl TEXT,
feature_co TEXT,
admin1_cod DOUBLE,
gn_pop DOUBLE,
elevation DOUBLE,
gtopo30 DOUBLE,
timezone TEXT,
geonamesno TEXT,
un_fid INTEGER,
un_adm0 TEXT,
un_lat DOUBLE,
un_long DOUBLE,
pop1950 DOUBLE,
pop1955 DOUBLE,
pop1960 DOUBLE,
pop1965 DOUBLE,
pop1970 DOUBLE,
pop1975 DOUBLE,
pop1980 DOUBLE,
pop1985 DOUBLE,
pop1990 DOUBLE,
pop1995 DOUBLE,
pop2000 DOUBLE,
pop2005 DOUBLE,
pop2010 DOUBLE,
pop2015 DOUBLE,
pop2020 DOUBLE,
pop2025 DOUBLE,
pop2050 DOUBLE,
cityalt TEXT)


time_start: 2017-05-20T15:12:07.066Z
time_end: 2017-05-20T15:12:07.107Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE populated_places_z (
pk_uid INTEGER PRIMARY KEY AUTOINCREMENT,
scalerank INTEGER,
natscale INTEGER,
labelrank INTEGER,
featurecla TEXT,
name TEXT,
namepar TEXT,
namealt TEXT,
diffascii INTEGER,
nameascii TEXT,
adm0cap DOUBLE,
capalt DOUBLE,
capin TEXT,
worldcity DOUBLE,
megacity INTEGER,
sov0name TEXT,
sov_a3 TEXT,
adm0name TEXT,
adm0_a3 TEXT,
adm1name TEXT,
iso_a2 TEXT,
note TEXT,
latitude DOUBLE,
longitude DOUBLE,
changed DOUBLE,
namediff INTEGER,
diffnote TEXT,
pop_max INTEGER,
pop_min INTEGER,
pop_other INTEGER,
rank_max INTEGER,
rank_min INTEGER,
geonameid DOUBLE,
meganame TEXT,
ls_name TEXT,
ls_match INTEGER,
checkme INTEGER,
max_pop10 DOUBLE,
max_pop20 DOUBLE,
max_pop50 DOUBLE,
max_pop300 DOUBLE,
max_pop310 DOUBLE,
max_natsca DOUBLE,
min_areakm DOUBLE,
max_areakm DOUBLE,
min_areami DOUBLE,
max_areami DOUBLE,
min_perkm DOUBLE,
max_perkm DOUBLE,
min_permi DOUBLE,
max_permi DOUBLE,
min_bbxmin DOUBLE,
max_bbxmin DOUBLE,
min_bbxmax DOUBLE,
max_bbxmax DOUBLE,
min_bbymin DOUBLE,
max_bbymin DOUBLE,
min_bbymax DOUBLE,
max_bbymax DOUBLE,
mean_bbxc DOUBLE,
mean_bbyc DOUBLE,
compare INTEGER,
gn_ascii TEXT,
feature_cl TEXT,
feature_co TEXT,
admin1_cod DOUBLE,
gn_pop DOUBLE,
elevation DOUBLE,
gtopo30 DOUBLE,
timezone TEXT,
geonamesno TEXT,
un_fid INTEGER,
un_adm0 TEXT,
un_lat DOUBLE,
un_long DOUBLE,
pop1950 DOUBLE,
pop1955 DOUBLE,
pop1960 DOUBLE,
pop1965 DOUBLE,
pop1970 DOUBLE,
pop1975 DOUBLE,
pop1980 DOUBLE,
pop1985 DOUBLE,
pop1990 DOUBLE,
pop1995 DOUBLE,
pop2000 DOUBLE,
pop2005 DOUBLE,
pop2010 DOUBLE,
pop2015 DOUBLE,
pop2020 DOUBLE,
pop2025 DOUBLE,
pop2050 DOUBLE,
cityalt TEXT)


time_start: 2017-05-20T15:12:13.350Z
time_end: 2017-05-20T15:12:13.393Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE populated_places_zm (
pk_uid INTEGER PRIMARY KEY AUTOINCREMENT,
scalerank INTEGER,
natscale INTEGER,
labelrank INTEGER,
featurecla TEXT,
name TEXT,
namepar TEXT,
namealt TEXT,
diffascii INTEGER,
nameascii TEXT,
adm0cap DOUBLE,
capalt DOUBLE,
capin TEXT,
worldcity DOUBLE,
megacity INTEGER,
sov0name TEXT,
sov_a3 TEXT,
adm0name TEXT,
adm0_a3 TEXT,
adm1name TEXT,
iso_a2 TEXT,
note TEXT,
latitude DOUBLE,
longitude DOUBLE,
changed DOUBLE,
namediff INTEGER,
diffnote TEXT,
pop_max INTEGER,
pop_min INTEGER,
pop_other INTEGER,
rank_max INTEGER,
rank_min INTEGER,
geonameid DOUBLE,
meganame TEXT,
ls_name TEXT,
ls_match INTEGER,
checkme INTEGER,
max_pop10 DOUBLE,
max_pop20 DOUBLE,
max_pop50 DOUBLE,
max_pop300 DOUBLE,
max_pop310 DOUBLE,
max_natsca DOUBLE,
min_areakm DOUBLE,
max_areakm DOUBLE,
min_areami DOUBLE,
max_areami DOUBLE,
min_perkm DOUBLE,
max_perkm DOUBLE,
min_permi DOUBLE,
max_permi DOUBLE,
min_bbxmin DOUBLE,
max_bbxmin DOUBLE,
min_bbxmax DOUBLE,
max_bbxmax DOUBLE,
min_bbymin DOUBLE,
max_bbymin DOUBLE,
min_bbymax DOUBLE,
max_bbymax DOUBLE,
mean_bbxc DOUBLE,
mean_bbyc DOUBLE,
compare INTEGER,
gn_ascii TEXT,
feature_cl TEXT,
feature_co TEXT,
admin1_cod DOUBLE,
gn_pop DOUBLE,
elevation DOUBLE,
gtopo30 DOUBLE,
timezone TEXT,
geonamesno TEXT,
un_fid INTEGER,
un_adm0 TEXT,
un_lat DOUBLE,
un_long DOUBLE,
pop1950 DOUBLE,
pop1955 DOUBLE,
pop1960 DOUBLE,
pop1965 DOUBLE,
pop1970 DOUBLE,
pop1975 DOUBLE,
pop1980 DOUBLE,
pop1985 DOUBLE,
pop1990 DOUBLE,
pop1995 DOUBLE,
pop2000 DOUBLE,
pop2005 DOUBLE,
pop2010 DOUBLE,
pop2015 DOUBLE,
pop2020 DOUBLE,
pop2025 DOUBLE,
pop2050 DOUBLE,
cityalt TEXT)


time_start: 2017-05-20T15:15:11.815Z
time_end: 2017-05-20T15:15:11.826Z
user_agent: spatialite_gui
error_cause: SQL error: no such column: pk_uid
sql_statement:
INSERT INTO populated_places_z SELECT
pk_uid,
scalerank,
natscale,
labelrank,
featurecla,
name,
namepar,
namealt,
diffascii,
nameascii,
adm0cap,
capalt,
capin,
worldcity,
megacity,
sov0name,
sov_a3,
adm0name,
adm0_a3,
adm1name,
iso_a2,
note,
latitude,
longitude,
changed,
namediff,
diffnote,
pop_max,
pop_min,
pop_other,
rank_max,
rank_min,
geonameid,
meganame,
ls_name,
ls_match,
checkme,
max_pop10,
max_pop20,
max_pop50,
max_pop300,
max_pop310,
max_natsca,
min_areakm,
max_areakm,
min_areami,
max_areami,
min_perkm,
max_perkm,
min_permi,
max_permi,
min_bbxmin,
max_bbxmin,
min_bbxmax,
max_bbxmax,
min_bbymin,
max_bbymin,
min_bbymax,
max_bbymax,
mean_bbxc,
mean_bbyc,
compare,
gn_ascii,
feature_cl,
feature_co,
admin1_cod,
gn_pop,
elevation,
gtopo30,
timezone,
geonamesno,
un_fid,
un_adm0,
un_lat,
un_long,
pop1950,
pop1955,
pop1960,
pop1965,
pop1970,
pop1975,
pop1980,
pop1985,
pop1990,
pop1995,
pop2000,
pop2005,
pop2010,
pop2015,
pop2020,
pop2025,
pop2050,
cityalt, CastToXYZ(geometry)


time_start: 2017-05-20T15:16:00.387Z
time_end: 2017-05-20T15:16:00.400Z
user_agent: spatialite_gui
error_cause: SQL error: no such column: pk_uid
sql_statement:
INSERT INTO populated_places_z 
SELECT pk_uid,
scalerank,
natscale,
labelrank,
featurecla,
name,
namepar,
namealt,
diffascii,
nameascii,
adm0cap,
capalt,
capin,
worldcity,
megacity,
sov0name,
sov_a3,
adm0name,
adm0_a3,
adm1name,
iso_a2,
note,
latitude,
longitude,
changed,
namediff,
diffnote,
pop_max,
pop_min,
pop_other,
rank_max,
rank_min,
geonameid,
meganame,
ls_name,
ls_match,
checkme,
max_pop10,
max_pop20,
max_pop50,
max_pop300,
max_pop310,
max_natsca,
min_areakm,
max_areakm,
min_areami,
max_areami,
min_perkm,
max_perkm,
min_permi,
max_permi,
min_bbxmin,
max_bbxmin,
min_bbxmax,
max_bbxmax,
min_bbymin,
max_bbymin,
min_bbymax,
max_bbymax,
mean_bbxc,
mean_bbyc,
compare,
gn_ascii,
feature_cl,
feature_co,
admin1_cod,
gn_pop,
elevation,
gtopo30,
timezone,
geonamesno,
un_fid,
un_adm0,
un_lat,
un_long,
pop1950,
pop1955,
pop1960,
pop1965,
pop1970,
pop1975,
pop1980,
pop1985,
pop1990,
pop1995,
pop2000,
pop2005,
pop2010,
pop2015,
pop2020,
pop2025,
pop2050,
cityalt, CastToXYZ(geometry)


time_start: 2017-05-20T15:17:53.373Z
time_end: 2017-05-20T15:17:53.407Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO populated_places_z 
SELECT pk_uid,
scalerank,
natscale,
labelrank,
featurecla,
name,
namepar,
namealt,
diffascii,
nameascii,
adm0cap,
capalt,
capin,
worldcity,
megacity,
sov0name,
sov_a3,
adm0name,
adm0_a3,
adm1name,
iso_a2,
note,
latitude,
longitude,
changed,
namediff,
diffnote,
pop_max,
pop_min,
pop_other,
rank_max,
rank_min,
geonameid,
meganame,
ls_name,
ls_match,
checkme,
max_pop10,
max_pop20,
max_pop50,
max_pop300,
max_pop310,
max_natsca,
min_areakm,
max_areakm,
min_areami,
max_areami,
min_perkm,
max_perkm,
min_permi,
max_permi,
min_bbxmin,
max_bbxmin,
min_bbxmax,
max_bbxmax,
min_bbymin,
max_bbymin,
min_bbymax,
max_bbymax,
mean_bbxc,
mean_bbyc,
compare,
gn_ascii,
feature_cl,
feature_co,
admin1_cod,
gn_pop,
elevation,
gtopo30,
timezone,
geonamesno,
un_fid,
un_adm0,
un_lat,
un_long,
pop1950,
pop1955,
pop1960,
pop1965,
pop1970,
pop1975,
pop1980,
pop1985,
pop1990,
pop1995,
pop2000,
pop2005,
pop2010,
pop2015,
pop2020,
pop2025,
pop2050,
cityalt, CastToXYZ(geometry) FROM populated_places


time_start: 2017-05-20T15:18:12.417Z
time_end: 2017-05-20T15:18:12.449Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO populated_places_m 
SELECT pk_uid,
scalerank,
natscale,
labelrank,
featurecla,
name,
namepar,
namealt,
diffascii,
nameascii,
adm0cap,
capalt,
capin,
worldcity,
megacity,
sov0name,
sov_a3,
adm0name,
adm0_a3,
adm1name,
iso_a2,
note,
latitude,
longitude,
changed,
namediff,
diffnote,
pop_max,
pop_min,
pop_other,
rank_max,
rank_min,
geonameid,
meganame,
ls_name,
ls_match,
checkme,
max_pop10,
max_pop20,
max_pop50,
max_pop300,
max_pop310,
max_natsca,
min_areakm,
max_areakm,
min_areami,
max_areami,
min_perkm,
max_perkm,
min_permi,
max_permi,
min_bbxmin,
max_bbxmin,
min_bbxmax,
max_bbxmax,
min_bbymin,
max_bbymin,
min_bbymax,
max_bbymax,
mean_bbxc,
mean_bbyc,
compare,
gn_ascii,
feature_cl,
feature_co,
admin1_cod,
gn_pop,
elevation,
gtopo30,
timezone,
geonamesno,
un_fid,
un_adm0,
un_lat,
un_long,
pop1950,
pop1955,
pop1960,
pop1965,
pop1970,
pop1975,
pop1980,
pop1985,
pop1990,
pop1995,
pop2000,
pop2005,
pop2010,
pop2015,
pop2020,
pop2025,
pop2050,
cityalt, CastToXYM(geometry) FROM populated_places


time_start: 2017-05-20T15:18:23.083Z
time_end: 2017-05-20T15:18:23.113Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO populated_places_zm 
SELECT pk_uid,
scalerank,
natscale,
labelrank,
featurecla,
name,
namepar,
namealt,
diffascii,
nameascii,
adm0cap,
capalt,
capin,
worldcity,
megacity,
sov0name,
sov_a3,
adm0name,
adm0_a3,
adm1name,
iso_a2,
note,
latitude,
longitude,
changed,
namediff,
diffnote,
pop_max,
pop_min,
pop_other,
rank_max,
rank_min,
geonameid,
meganame,
ls_name,
ls_match,
checkme,
max_pop10,
max_pop20,
max_pop50,
max_pop300,
max_pop310,
max_natsca,
min_areakm,
max_areakm,
min_areami,
max_areami,
min_perkm,
max_perkm,
min_permi,
max_permi,
min_bbxmin,
max_bbxmin,
min_bbxmax,
max_bbxmax,
min_bbymin,
max_bbymin,
min_bbymax,
max_bbymax,
mean_bbxc,
mean_bbyc,
compare,
gn_ascii,
feature_cl,
feature_co,
admin1_cod,
gn_pop,
elevation,
gtopo30,
timezone,
geonamesno,
un_fid,
un_adm0,
un_lat,
un_long,
pop1950,
pop1955,
pop1960,
pop1965,
pop1970,
pop1975,
pop1980,
pop1985,
pop1990,
pop1995,
pop2000,
pop2005,
pop2010,
pop2015,
pop2020,
pop2025,
pop2050,
cityalt, CastToXYZM(geometry) FROM populated_places


time_start: 2017-05-20T15:22:52.498Z
time_end: 2017-05-20T15:22:52.518Z
user_agent: spatialite_gui
error_cause: SQL error: near "add": syntax error
sql_statement:
CREATE TABLE railroads_m (
pk_uid INTEGER PRIMARY KEY AUTOINCREMENT,
rwdb_rr_id INTEGER,
mult_track INTEGER,
electric INTEGER,
other_code INTEGER,
category INTEGER,
disp_scale TEXT,
add INTEGER,
featurecla TEXT,
scalerank INTEGER,
natlscale DOUBLE,
part TEXT,
continent TEXT)


time_start: 2017-05-20T15:23:13.529Z
time_end: 2017-05-20T15:23:13.568Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE railroads_m (
pk_uid INTEGER PRIMARY KEY AUTOINCREMENT,
rwdb_rr_id INTEGER,
mult_track INTEGER,
electric INTEGER,
other_code INTEGER,
category INTEGER,
disp_scale TEXT,
"add" INTEGER,
featurecla TEXT,
scalerank INTEGER,
natlscale DOUBLE,
part TEXT,
continent TEXT)


time_start: 2017-05-20T15:23:21.631Z
time_end: 2017-05-20T15:23:21.675Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE railroads_zm (
pk_uid INTEGER PRIMARY KEY AUTOINCREMENT,
rwdb_rr_id INTEGER,
mult_track INTEGER,
electric INTEGER,
other_code INTEGER,
category INTEGER,
disp_scale TEXT,
"add" INTEGER,
featurecla TEXT,
scalerank INTEGER,
natlscale DOUBLE,
part TEXT,
continent TEXT)


time_start: 2017-05-20T15:23:27.150Z
time_end: 2017-05-20T15:23:27.197Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
CREATE TABLE railroads_z (
pk_uid INTEGER PRIMARY KEY AUTOINCREMENT,
rwdb_rr_id INTEGER,
mult_track INTEGER,
electric INTEGER,
other_code INTEGER,
category INTEGER,
disp_scale TEXT,
"add" INTEGER,
featurecla TEXT,
scalerank INTEGER,
natlscale DOUBLE,
part TEXT,
continent TEXT)


time_start: 2017-05-20T15:26:33.282Z
time_end: 2017-05-20T15:26:33.334Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO railroads_m SELECT
pk_uid,
rwdb_rr_id,
mult_track,
electric,
other_code,
category,
disp_scale,
"add",
featurecla,
scalerank,
natlscale,
part,
continent, CastToXYM(geometry) FROM railroads


time_start: 2017-05-20T15:26:43.502Z
time_end: 2017-05-20T15:26:43.530Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO railroads_zm SELECT
pk_uid,
rwdb_rr_id,
mult_track,
electric,
other_code,
category,
disp_scale,
"add",
featurecla,
scalerank,
natlscale,
part,
continent, CastToXYZM(geometry) FROM railroads


time_start: 2017-05-20T15:26:59.254Z
time_end: 2017-05-20T15:26:59.286Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
INSERT INTO railroads_z SELECT
pk_uid,
rwdb_rr_id,
mult_track,
electric,
other_code,
category,
disp_scale,
"add",
featurecla,
scalerank,
natlscale,
part,
continent, CastToXYZ(geometry) FROM railroads


time_start: 2017-05-20T15:49:04.604Z
time_end: 2017-05-20T15:49:04.621Z
user_agent: spatialite_gui
error_cause: SQL error: near "-": syntax error
sql_statement:
SELECT c.title, c.abstract, g.geometry_type, g.srid, c.copyright, l.name 
FROM MAIN-vector_coverages AS c 
JOIN MAIN.geometry_columns AS g ON (Lower(c.f_table_name) = Lower(g.f_table_name) AND Lower(c.f_geometry_column) = Lower(g.f_geometry_column)) 
JOIN data_licenses AS l ON (c.license = l.id) 
WHERE Lower(c.coverage_name) = Lower('populated_places_z')


time_start: 2017-05-20T17:47:53.900Z
time_end: 2017-05-20T17:47:53.927Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
insert into countries_m
SELECT "pk_uid", "scalerank", "featurecla", "labelrank", "sovereignt", "sov_a3", "adm0_dif", "level", "type", "admin", "adm0_a3", "geou_dif", "geounit", "gu_a3", "su_dif", 
"subunit", "su_a3", "brk_diff", "name", "name_long", "brk_a3", "brk_name", "brk_group", "abbrev", "postal", "formal_en", "formal_fr", "note_adm0", "note_brk", "name_sort", 
"name_alt", "mapcolor7", "mapcolor8", "mapcolor9", "mapcolor13", "pop_est", "gdp_md_est", "pop_year", "lastcensus", "gdp_year", "economy", "income_grp", "wikipedia", 
"fips_10", "iso_a2", "iso_a3", "iso_n3", "un_a3", "wb_a2", "wb_a3", "woe_id", "adm0_a3_is", "adm0_a3_us", "adm0_a3_un", "adm0_a3_wb", "continent", "region_un", "subregion", 
"region_wb", "name_len", "long_len", "abbrev_len", "tiny", "homepart", CastToXYM(geometry)
FROM "countries"
where pk_uid = 168


time_start: 2017-05-20T17:47:58.005Z
time_end: 2017-05-20T17:47:58.019Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
insert into countries_zm
SELECT "pk_uid", "scalerank", "featurecla", "labelrank", "sovereignt", "sov_a3", "adm0_dif", "level", "type", "admin", "adm0_a3", "geou_dif", "geounit", "gu_a3", "su_dif", 
"subunit", "su_a3", "brk_diff", "name", "name_long", "brk_a3", "brk_name", "brk_group", "abbrev", "postal", "formal_en", "formal_fr", "note_adm0", "note_brk", "name_sort", 
"name_alt", "mapcolor7", "mapcolor8", "mapcolor9", "mapcolor13", "pop_est", "gdp_md_est", "pop_year", "lastcensus", "gdp_year", "economy", "income_grp", "wikipedia", 
"fips_10", "iso_a2", "iso_a3", "iso_n3", "un_a3", "wb_a2", "wb_a3", "woe_id", "adm0_a3_is", "adm0_a3_us", "adm0_a3_un", "adm0_a3_wb", "continent", "region_un", "subregion", 
"region_wb", "name_len", "long_len", "abbrev_len", "tiny", "homepart", CastToXYM(geometry)
FROM "countries"
where pk_uid = 168


time_start: 2017-05-20T17:48:06.795Z
time_end: 2017-05-20T17:48:06.827Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
insert into countries_zm
SELECT "pk_uid", "scalerank", "featurecla", "labelrank", "sovereignt", "sov_a3", "adm0_dif", "level", "type", "admin", "adm0_a3", "geou_dif", "geounit", "gu_a3", "su_dif", 
"subunit", "su_a3", "brk_diff", "name", "name_long", "brk_a3", "brk_name", "brk_group", "abbrev", "postal", "formal_en", "formal_fr", "note_adm0", "note_brk", "name_sort", 
"name_alt", "mapcolor7", "mapcolor8", "mapcolor9", "mapcolor13", "pop_est", "gdp_md_est", "pop_year", "lastcensus", "gdp_year", "economy", "income_grp", "wikipedia", 
"fips_10", "iso_a2", "iso_a3", "iso_n3", "un_a3", "wb_a2", "wb_a3", "woe_id", "adm0_a3_is", "adm0_a3_us", "adm0_a3_un", "adm0_a3_wb", "continent", "region_un", "subregion", 
"region_wb", "name_len", "long_len", "abbrev_len", "tiny", "homepart", CastToXYZM(geometry)
FROM "countries"
where pk_uid = 168


time_start: 2017-05-20T17:48:17.220Z
time_end: 2017-05-20T17:48:17.243Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
insert into countries_z
SELECT "pk_uid", "scalerank", "featurecla", "labelrank", "sovereignt", "sov_a3", "adm0_dif", "level", "type", "admin", "adm0_a3", "geou_dif", "geounit", "gu_a3", "su_dif", 
"subunit", "su_a3", "brk_diff", "name", "name_long", "brk_a3", "brk_name", "brk_group", "abbrev", "postal", "formal_en", "formal_fr", "note_adm0", "note_brk", "name_sort", 
"name_alt", "mapcolor7", "mapcolor8", "mapcolor9", "mapcolor13", "pop_est", "gdp_md_est", "pop_year", "lastcensus", "gdp_year", "economy", "income_grp", "wikipedia", 
"fips_10", "iso_a2", "iso_a3", "iso_n3", "un_a3", "wb_a2", "wb_a3", "woe_id", "adm0_a3_is", "adm0_a3_us", "adm0_a3_un", "adm0_a3_wb", "continent", "region_un", "subregion", 
"region_wb", "name_len", "long_len", "abbrev_len", "tiny", "homepart", CastToXYZ(geometry)
FROM "countries"
where pk_uid = 168


time_start: 2017-05-21T10:38:43.527Z
time_end: 2017-05-21T10:38:43.586Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Min(extent_minx), Max(extent_maxx), Min(extent_miny), Max(extent_maxy) 
FROM vector_coverages_ref_sys WHERE srid = 4236


time_start: 2017-05-21T10:39:01.424Z
time_end: 2017-05-21T10:39:01.458Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT Min(extent_minx), Max(extent_maxx), Min(extent_miny), Max(extent_maxy) 
FROM vector_coverages_ref_sys WHERE srid = 4326


time_start: 2017-05-21T10:39:33.776Z
time_end: 2017-05-21T10:39:33.804Z
user_agent: spatialite_gui
error_cause: success
sql_statement:
SELECT extent_minx, extent_maxx, extent_miny, extent_maxy 
FROM vector_coverages_ref_sys WHERE srid = 4326


# wms_server_log

timestamp: 2017-04-29T10:47:45
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: airports
wms_style: default
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=airports&CRS=EPSG:4326&BBOX=-73.495988,-175.135635,97.961230,179.195442&WIDTH=1707&HEIGHT=826&STYLES=default&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:49:53
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: airports
wms_style: Airports
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=airports&CRS=EPSG:4326&BBOX=-73.495988,-175.135635,97.961230,179.195442&WIDTH=1707&HEIGHT=826&STYLES=Airports&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:50:04
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: countries
wms_style: Countries - categorize
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=countries&CRS=EPSG:4326&BBOX=-73.495988,-175.135635,97.961230,179.195442&WIDTH=1707&HEIGHT=826&STYLES=Countries - categorize&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:50:21
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=-73.495988,-175.135635,97.961230,179.195442&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:50:38
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: ports
wms_style: Ports
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=ports&CRS=EPSG:4326&BBOX=-73.495988,-175.135635,97.961230,179.195442&WIDTH=1707&HEIGHT=826&STYLES=Ports&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:51:00
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: railroads
wms_style: Railroads
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=railroads&CRS=EPSG:4326&BBOX=-73.495988,-175.135635,97.961230,179.195442&WIDTH=1707&HEIGHT=826&STYLES=Railroads&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:51:15
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: countries
wms_style: Countries - categorize
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=countries&CRS=EPSG:4326&BBOX=26.970469,-15.592261,51.256782,34.597492&WIDTH=1707&HEIGHT=826&STYLES=Countries - categorize&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:51:16
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: railroads
wms_style: Railroads
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=railroads&CRS=EPSG:4326&BBOX=26.970469,-15.592261,51.256782,34.597492&WIDTH=1707&HEIGHT=826&STYLES=Railroads&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:51:16
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: airports
wms_style: Airports
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=airports&CRS=EPSG:4326&BBOX=26.970469,-15.592261,51.256782,34.597492&WIDTH=1707&HEIGHT=826&STYLES=Airports&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:51:16
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=26.970469,-15.592261,51.256782,34.597492&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:51:16
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: ports
wms_style: Ports
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=ports&CRS=EPSG:4326&BBOX=26.970469,-15.592261,51.256782,34.597492&WIDTH=1707&HEIGHT=826&STYLES=Ports&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:51:33
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: ports
wms_style: default
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=ports&CRS=EPSG:4326&BBOX=26.970469,-15.592261,51.256782,34.597492&WIDTH=1707&HEIGHT=826&STYLES=default&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:51:59
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: countries
wms_style: Country Boundaries
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=countries&CRS=EPSG:4326&BBOX=26.970469,-15.592261,51.256782,34.597492&WIDTH=1707&HEIGHT=826&STYLES=Country Boundaries&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:52:10
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: countries
wms_style: default
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=countries&CRS=EPSG:4326&BBOX=26.970469,-15.592261,51.256782,34.597492&WIDTH=1707&HEIGHT=826&STYLES=default&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:52:17
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: countries
wms_style: Countries - simple
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=countries&CRS=EPSG:4326&BBOX=26.970469,-15.592261,51.256782,34.597492&WIDTH=1707&HEIGHT=826&STYLES=Countries - simple&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:52:49
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - simple
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=26.970469,-15.592261,51.256782,34.597492&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - simple&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:54:53
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: countries
wms_style: Countries - simple
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=countries&CRS=EPSG:4326&BBOX=-90.000000,-185.992736,90.000000,185.992736&WIDTH=1707&HEIGHT=826&STYLES=Countries - simple&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:54:53
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: airports
wms_style: Airports
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=airports&CRS=EPSG:4326&BBOX=-90.000000,-185.992736,90.000000,185.992736&WIDTH=1707&HEIGHT=826&STYLES=Airports&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:55:19
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: countries
wms_style: Country Boundaries
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=countries&CRS=EPSG:4326&BBOX=-90.000000,-185.992736,90.000000,185.992736&WIDTH=1707&HEIGHT=826&STYLES=Country Boundaries&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T07:55:34
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: ocean
wms_style: Ocean
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=ocean&CRS=EPSG:4326&BBOX=-90.000000,-185.992736,90.000000,185.992736&WIDTH=1707&HEIGHT=826&STYLES=Ocean&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:32:01
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=-90.610105,-179.589979,83.093428,179.383304&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:32:24
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=27.365297,-20.094204,56.175689,39.444948&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:33:22
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=34.829491,-0.646104,47.316319,25.159001&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:34:45
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=-90.000000,-185.992736,90.000000,185.992736&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:34:53
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=29.636804,-15.224161,54.915254,37.015929&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:34:58
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=34.961804,-0.672739,47.386805,25.004593&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:35:48
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=35.413076,-19.265114,47.838077,6.412219&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:36:00
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=40.617737,-8.013418,53.042738,17.663915&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:36:08
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=48.153966,-13.819774,60.578967,11.857558&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:36:16
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=45.611805,1.628744,58.036806,27.306077&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:36:36
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: countries
wms_style: Countries - categorize
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=countries&CRS=EPSG:4326&BBOX=45.611805,1.628744,58.036806,27.306077&WIDTH=1707&HEIGHT=826&STYLES=Countries - categorize&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:36:52
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: countries
wms_style: Countries - categorize
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=countries&CRS=EPSG:4326&BBOX=41.084051,-11.428037,53.509052,14.249296&WIDTH=1707&HEIGHT=826&STYLES=Countries - categorize&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:36:52
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=41.084051,-11.428037,53.509052,14.249296&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:36:54
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: countries
wms_style: Countries - categorize
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=countries&CRS=EPSG:4326&BBOX=35.428118,-11.668715,47.853119,14.008618&WIDTH=1707&HEIGHT=826&STYLES=Countries - categorize&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:36:54
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=35.428118,-11.668715,47.853119,14.008618&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:37:17
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: ports
wms_style: Ports
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=ports&CRS=EPSG:4326&BBOX=35.428118,-11.668715,47.853119,14.008618&WIDTH=1707&HEIGHT=826&STYLES=Ports&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:37:26
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: countries
wms_style: Countries - categorize
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=countries&CRS=EPSG:4326&BBOX=34.029177,5.268998,46.454178,30.946331&WIDTH=1707&HEIGHT=826&STYLES=Countries - categorize&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:37:27
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: popplaces
wms_style: Populated Places - categorized
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=popplaces&CRS=EPSG:4326&BBOX=34.029177,5.268998,46.454178,30.946331&WIDTH=1707&HEIGHT=826&STYLES=Populated Places - categorized&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


timestamp: 2017-05-02T10:37:27
client_ip_addr: 127.0.0.1
http_method: GET
wms_request: GetMap1
wms_version: 1.3.0
wms_layer: ports
wms_style: Ports
wms_format: image/png
wms_bgcolor: #ffffff
request_url:
/wmslite?SERVICE=WMS&REQUEST=GetMap&VERSION=1.3.0&LAYERS=ports&CRS=EPSG:4326&BBOX=34.029177,5.268998,46.454178,30.946331&WIDTH=1707&HEIGHT=826&STYLES=Ports&FORMAT=image/png&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF 


