# sql_statements_log

time_start: 2023-01-18T21:52:01.035Z
time_end: 2023-01-18T21:52:01.036Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_admin AS SELECT geometry FROM multipolygons
  WHERE boundary IN ('administrative') AND admin_level IN ('2');


time_start: 2023-01-18T21:52:01.038Z
time_end: 2023-01-18T21:52:01.039Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_aeroways AS SELECT geometry, (aeroway='runway') AS is_runway FROM lines
  WHERE aeroway IN ('runway', 'taxiway');


time_start: 2023-01-18T21:52:01.040Z
time_end: 2023-01-18T21:52:01.041Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_airports AS SELECT geometry, name, name_en, iata
  FROM (
  SELECT geometry, name, name_en, iata FROM points WHERE aeroway='aerodrome'
  UNION ALL
  SELECT ST_PointOnSurface(geometry) AS geometry, name, name_en, iata FROM multipolygons
  WHERE aeroway='aerodrome' AND ST_IsValid(geometry)
  );


time_start: 2023-01-18T21:52:01.043Z
time_end: 2023-01-18T21:52:01.044Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_amenity AS SELECT osm_id, geometry, name, name_en,
  CASE
  WHEN amenity IN ('place_of_worship') THEN
  CASE
  WHEN religion='christian' THEN 'religion_christian'
  WHEN religion='jewish' THEN 'religion_jewish'
  WHEN religion='muslim' THEN 'religion_muslim'
  ELSE 'amenity_place_of_worship' END
  WHEN tourism IS NOT NULL THEN 'tourism_' || tourism
  WHEN highway IS NOT NULL THEN 'highway_' || highway
  WHEN man_made IS NOT NULL THEN 'man_made_' || man_made
  WHEN shop IS NOT NULL THEN 'shop_' || shop
  WHEN leisure IS NOT NULL THEN 'leisure_' || leisure
  WHEN natural IS NOT NULL THEN 'natural_' || natural
  WHEN building IS NOT NULL THEN 'building_' || building
  WHEN barrier IS NOT NULL THEN 'barrier_' || barrier
  WHEN amenity IS NOT NULL THEN 'amenity_' || amenity
  ELSE NULL END AS feature
  FROM (
  SELECT osm_id, geometry, name, name_en, tourism, aeroway, highway, man_made, shop, leisure, natural, amenity, building, barrier, religion FROM points WHERE name IS NOT NULL
  UNION ALL
  SELECT osm_id, ST_PointOnSurface(geometry) AS geometry, name, name_en, tourism, aeroway, highway, man_made, shop, leisure, natural, amenity, building, barrier, religion FROM multipolygons
  WHERE name IS NOT NULL AND ST_IsValid(geometry)
  )
  WHERE
  amenity IN ('hospital', 'townhall', 'shelter', 'bus_station', 'atm', 'bank', 'bar', 'bicycle_rental', 'taxi',
  'cafe', 'car_rental', 'cinema', 'fire_station', 'charging_station', 'fuel', 'embassy',
  'parking', 'library', 'courthouse', 'clinic', 'doctors', 'place_of_worship', 'police', 'post_office', 'pub', 'biergarten',
  'restaurant', 'food_court', 'fast_food', 'theatre', 'arts_centre', 'toilets', 'university', 'college', 'school', 'kindergarten' ) OR
  building IN ('university', 'college', 'school', 'kindergarten') OR
  barrier IN ('border_control') OR
  highway IN ('bus_stop', 'ford' ) OR
  leisure IN ('water_park', 'dog_park', 'playground' ) OR
  man_made IN ('lighthouse') OR
  shop IN ('bicycle', 'department_store', 'supermarket', 'art', 'bag', 'bakery', 'beverages', 'books', 'butcher', 'coffee', 'convenience', 'deli', 'doityourself', 'hardware',
  'fishmonger', 'ice_cream', 'seafood', 'garden_centre', 'toys', 'sports') OR
  tourism IN ('alpine_hut', 'wilderness_hut', 'museum', 'camp_site', 'caravan_site', 'picnic_site', 'artwork', 'hostel', 'hotel', 'motel', 'information', 'zoo' );


time_start: 2023-01-18T21:52:03.130Z
time_end: 2023-01-18T21:52:03.131Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_amenity_z13 AS SELECT geometry, name, name_en,
  CASE
  WHEN feature IN ('amenity_hospital') THEN 'hospital'
  WHEN feature IN ('natural_peak') THEN 'mountain'
  WHEN feature IN ('natural_volcano') THEN 'volcano'
  ELSE NULL END AS icon,
  CASE
  WHEN feature GLOB ('*hospital*') THEN 1
  WHEN feature GLOB ('natural_*') THEN 2
  ELSE 0 END AS color
  FROM vw_osm_amenity
  WHERE icon IS NOT NULL;


time_start: 2023-01-18T21:52:03.133Z
time_end: 2023-01-18T21:52:03.134Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_amenity_z14 AS SELECT geometry, name, name_en,
  CASE
  WHEN feature IN ('amenity_townhall') THEN 'town-hall'
  WHEN feature IN ('amenity_fire_station') THEN 'fire-station'
  ELSE NULL END AS icon, 0 AS color
  FROM vw_osm_amenity
  WHERE icon IS NOT NULL;


time_start: 2023-01-18T21:52:03.135Z
time_end: 2023-01-18T21:52:03.136Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_amenity_z15 AS SELECT geometry, name, name_en,
  CASE
  WHEN feature IN ('amenity_university', 'building_university', 'amenity_college', 'building_college' ) THEN 'college'
  WHEN feature IN ('amenity_police', 'barrier_border_control') THEN 'police'
  WHEN feature IN ('amenity_bank') THEN 'bank'
  WHEN feature IN ('amenity_taxi') THEN 'car'
  ELSE NULL END AS icon, 0 AS color
  FROM vw_osm_amenity
  WHERE icon IS NOT NULL;


time_start: 2023-01-18T21:52:03.138Z
time_end: 2023-01-18T21:52:03.139Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_amenity_z16 AS SELECT geometry, name, name_en,
  CASE
  WHEN feature IN ('amenity_school', 'building_school' ) THEN 'school'
  WHEN feature IN ('amenity_kindergarten', 'building_kindergarten' ) THEN 'playground'
  WHEN feature IN ('amenity_embassy') THEN 'embassy'
  WHEN feature IN ('tourism_zoo') THEN 'zoo'
  WHEN feature IN ('amenity_place_of_worship') THEN 'place-of-worship'
  WHEN feature IN ('religion_christian') THEN 'religious-christian'
  WHEN feature IN ('religion_jewish') THEN 'religious-jewish'
  WHEN feature IN ('religion_muslim') THEN 'religious-muslim'
  WHEN feature IN ('amenity_post_office') THEN 'post'
  ELSE NULL END AS icon,
  CASE
  WHEN feature IN ('amenity_embassy') THEN 3
  ELSE 0 END AS color
  FROM vw_osm_amenity
  WHERE icon IS NOT NULL;


time_start: 2023-01-18T21:52:03.140Z
time_end: 2023-01-18T21:52:03.142Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_amenity_z17 AS SELECT geometry, name, name_en,
  CASE
  WHEN feature IN ('tourism_alpine_hut', 'tourism_wilderness_hut', 'amenity_shelter') THEN 'shelter'
  WHEN feature IN ('highway_bus_stop', 'amenity_bus_station') THEN 'bus'
  WHEN feature IN ('amenity_parking') THEN 'parking'
  WHEN feature IN ('amenity_bicycle_parking') THEN 'bicycle'
  WHEN feature IN ('amenity_motorcycle_parking') THEN 'motorcycle-parking'
  WHEN feature IN ('tourism_museum') THEN 'museum'
  WHEN feature IN ('amenity_pharmacy') THEN 'pharmacy'
  WHEN feature IN ('man_made_lighthouse') THEN 'lighthouse'
  WHEN feature IN ('tourism_camp_site', 'tourism_caravan_site') THEN 'campsite'
  WHEN feature IN ('tourism_picnic_site') THEN 'picnic-site'
  WHEN feature IN ('shop_department_store') THEN 'shop/department-store'
  WHEN feature IN ('amenity_atm') THEN 'atm'
  WHEN feature IN ('amenity_bar') THEN 'bar'
  WHEN feature IN ('amenity_bicycle_rental') THEN 'bicycle-share'
  WHEN feature IN ('amenity_cafe') THEN 'cafe'
  WHEN feature IN ('tourism_artwork') THEN 'monument'
  WHEN feature IN ('amenity_car_rental') THEN 'rental-car'
  WHEN feature IN ('amenity_cinema') THEN 'cinema'
  WHEN feature IN ('tourism_hostel', 'tourism_hotel', 'tourism_motel') THEN 'lodging'
  WHEN feature IN ('tourism_information') THEN 'information'
  WHEN feature IN ('amenity_library') THEN 'library'
  WHEN feature IN ('amenity_courthouse') THEN 'courthouse'
  WHEN feature IN ('amenity_clinic', 'amenity_doctors') THEN 'doctor'
  WHEN feature IN ('amenity_pub', 'amenity_biergarten') THEN 'beer'
  WHEN feature IN ('amenity_restaurant', 'amenity_food_court') THEN 'restaurant'
  WHEN feature IN ('amenity_fast_food') THEN 'fast-food'
  WHEN feature IN ('amenity_theatre') THEN 'theatre'
  WHEN feature IN ('amenity_arts_centre') THEN 'art-gallery'
  WHEN feature IN ('amenity_toilets') THEN 'toilet'
  WHEN feature IN ('shop_supermarket', 'shop_butcher') THEN 'shop'
  WHEN feature IN ('shop_art') THEN 'shop/art'
  WHEN feature IN ('shop_bag') THEN 'shop/bag'
  WHEN feature IN ('shop_bakery') THEN 'shop/bakery'
  WHEN feature IN ('shop_beverages') THEN 'shop/alcohol-shop'
  WHEN feature IN ('shop_books') THEN 'library'
  WHEN feature IN ('shop_bicycle') THEN 'bicycle'
  WHEN feature IN ('shop_coffee') THEN 'shop/coffee'
  WHEN feature IN ('shop_convenience') THEN 'shop/convenience'
  WHEN feature IN ('shop_deli') THEN 'shop/deli'
  WHEN feature IN ('shop_doityourself', 'shop_hardware') THEN 'shop/diy'
  WHEN feature IN ('shop_fishmonger', 'shop_seafood') THEN 'shop/seafood'
  WHEN feature IN ('shop_garden_centre') THEN 'garden-center'
  WHEN feature IN ('shop_ice_cream') THEN 'ice-cream'
  WHEN feature IN ('shop_toys') THEN 'shop/toys'
  WHEN feature IN ('shop_sports') THEN 'shop/sports'
  WHEN feature IN ('leisure_water_park') THEN 'water-park'
  WHEN feature IN ('leisure_dog_park') THEN 'dog-park'
  WHEN feature IN ('leisure_playground') THEN 'playground'
  ELSE NULL END AS icon,
  CASE
  WHEN feature IN ('tourism_artwork', 'tourism_information', 'tourism_museum', 'tourism_zoo') THEN 0
  WHEN feature IN ('amenity_clinic', 'amenity_doctors', 'amenity_pharmacy') THEN 1
  WHEN feature GLOB 'tourism_*' OR feature IN ('amenity_bicycle_rental', 'amenity_car_rental', 'amenity_shelter', 'amenity_bus_station', 'amenity_parking', 'amenity_bicycle_parking', 'amenity_motorcycle_parking', 'highway_bus_stop') THEN 3
  WHEN feature GLOB 'shop_*' THEN 4
  ELSE 0 END AS color
  FROM vw_osm_amenity
  WHERE icon IS NOT NULL;


time_start: 2023-01-18T21:52:03.143Z
time_end: 2023-01-18T21:52:03.144Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_amenity_fuel AS SELECT geometry, name, name_en, feature FROM vw_osm_amenity
  WHERE feature IN ('amenity_charging_station', 'amenity_fuel');


time_start: 2023-01-18T21:52:03.163Z
time_end: 2023-01-18T21:52:03.164Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_area_labels AS SELECT ST_PointOnSurface(geometry) AS geometry, name, name_en,
  CASE
  WHEN leisure IN ('park', 'garden') THEN 'park'
  WHEN leisure IN ('golf_course') THEN leisure
  WHEN landuse='cemetery' OR amenity = 'grave_yard' THEN 'cemetery'
  WHEN amenity='hospital' THEN 'hospital'
  WHEN amenity IN ('college', 'kindergarten', 'school', 'university') THEN 'school'
  WHEN landuse IN ('basin', 'reservoir') OR natural IN ('water') OR waterway IN ('riverbank') THEN 'water'
  ELSE NULL END AS type, ST_Area(geometry) AS area
  FROM multipolygons
  WHERE ST_IsValid(geometry) AND building IS NULL AND name IS NOT NULL AND (aeroway IS NULL OR aeroway NOT IN ('aerodrome'))
  AND NOT EXISTS(SELECT 1 FROM tmp_osm_amenity_ids WHERE tmp_osm_amenity_ids.osm_id=multipolygons.osm_id);


time_start: 2023-01-18T21:52:03.166Z
time_end: 2023-01-18T21:52:03.167Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_barrierpoints AS SELECT geometry
  FROM points WHERE barrier IN ('block', 'bollard', 'chain', 'cycle_barrier', 'spikes', 'fence', 'wire_fence','yes');


time_start: 2023-01-18T21:52:03.168Z
time_end: 2023-01-18T21:52:03.169Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_barrierways AS SELECT geometry, 
  CASE 
  WHEN barrier IN ('city_wall', 'fence', 'retaining_wall', 'wall', 'wire_fence', 'yes') THEN 'fence'
  WHEN barrier IN ('gate', 'spikes', 'bollard', 'lift_gate', 'kissing_gate') THEN 'gate'
  WHEN barrier IN ('hedge') THEN 'hedge'
  END AS type FROM lines WHERE type IS NOT NULL;


time_start: 2023-01-18T21:52:03.171Z
time_end: 2023-01-18T21:52:03.173Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_buildings AS
  SELECT geometry, ST_MinY(geometry) AS y_min FROM   multipolygons
  WHERE  building IS NOT NULL OR railway IN ('station') OR aeroway IN ('terminal');


time_start: 2023-01-18T21:52:03.174Z
time_end: 2023-01-18T21:52:03.175Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_building_labels AS SELECT ST_PointOnSurface(geometry) AS geometry,
  CASE
  WHEN name IS NOT NULL AND addr_housenumber IS NOT NULL THEN name || ' ' || addr_housenumber
  WHEN name IS NOT NULL THEN name
  ELSE addr_housenumber
  END AS bname,
  CASE
  WHEN name_en IS NOT NULL AND addr_housenumber IS NOT NULL THEN name_en || ' ' || addr_housenumber
  WHEN name_en IS NOT NULL THEN name_en
  ELSE NULL
  END AS bname_en
  FROM multipolygons
  WHERE ST_IsValid(geometry) AND building IS NOT NULL AND bname IS NOT NULL
  UNION ALL SELECT geometry, CASE
  WHEN addr_housename IS NOT NULL AND addr_housenumber IS NOT NULL THEN addr_housename || ' ' || addr_housenumber
  WHEN addr_housename IS NOT NULL THEN addr_housename
  ELSE addr_housenumber
  END AS bname, NULL AS bname_en
  FROM points
  WHERE addr_housenumber IS NOT NULL OR addr_housename IS NOT NULL;


time_start: 2023-01-18T21:52:03.179Z
time_end: 2023-01-18T21:52:03.180Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_landusages AS SELECT geometry, amenity AS type, ST_Area(geometry) AS area FROM   multipolygons
  WHERE  amenity IN ('university', 'school', 'college', 'library', 'fuel', 'parking', 'cinema', 'theatre', 'place_of_worship', 'hospital')
  UNION ALL SELECT geometry, aeroway AS type, ST_Area(geometry) AS area FROM   multipolygons
  WHERE aeroway IN ('apron', 'aerodrome', 'helipad')
  UNION ALL SELECT geometry, natural AS type, ST_Area(geometry) AS area FROM   multipolygons
  WHERE  natural IN ('wood', 'land', 'scrub', 'wetland')
  UNION ALL SELECT geometry, highway AS type, ST_Area(geometry) AS area FROM   multipolygons
  WHERE highway IN ('pedestrian', 'footway')
  UNION ALL SELECT geometry, place AS type, ST_Area(geometry) AS area FROM   multipolygons
  WHERE  place IN ('island')
  UNION ALL SELECT geometry, landuse AS type, ST_Area(geometry) AS area FROM   multipolygons
  WHERE  landuse IN ('park', 'forest', 'residential', 'retail', 'commercial', 'industrial', 'railway', 'cemetery', 'grass', 'farmyard', 'farm', 'farmland', 'wood', 'meadow', 'village_green', 'recreation_ground', 'allotments', 'quarry')
  UNION ALL SELECT geometry, tourism AS type, ST_Area(geometry) AS area FROM   multipolygons
  WHERE  tourism IN ('zoo')
  UNION ALL SELECT geometry, leisure AS type, ST_Area(geometry) AS area FROM   multipolygons
  WHERE  leisure IN ('park', 'garden', 'playground', 'golf_course', 'sports_centre', 'pitch', 'stadium', 'common', 'nature_reserve');


time_start: 2023-01-18T21:52:03.194Z
time_end: 2023-01-18T21:52:03.195Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_motorways AS SELECT geometry, ref, highway AS type
  FROM lines
  WHERE highway IN ('motorway', 'trunk');


time_start: 2023-01-18T21:52:03.436Z
time_end: 2023-01-18T21:52:03.449Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_roads_gen1 AS SELECT ST_Simplify(geometry, 0.0005) AS geometry,
  name, name_en, ref, highway AS type
  FROM lines
  WHERE highway IN ('motorway', 'motorway_link', 'trunk', 'trunk_link', 'primary', 'secondary');


time_start: 2023-01-18T21:52:03.451Z
time_end: 2023-01-18T21:52:03.452Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_roads_gen2 AS SELECT ST_Simplify(geometry, 0.0002) AS geometry,
  name, name_en, ref, oneway, z_order, 
  CASE
  WHEN railway IN ('light_rail', 'subway', 'narrow_gauge', 'rail', 'tram') THEN 'railway'
  WHEN highway IN ('primary_link', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclassified', 'road', 'living_street') THEN 'minorroad'
  WHEN highway IN ('motorway', 'motorway_link', 'trunk', 'trunk_link', 'primary', 'secondary') THEN highway
  ELSE NULL END AS type
  FROM lines WHERE type IS NOT NULL AND (tunnel IS NULL OR tunnel NOT IN ('yes', '1', 'true'));


time_start: 2023-01-18T21:52:03.454Z
time_end: 2023-01-18T21:52:03.455Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_roads AS SELECT geometry, name, name_en, ref, oneway, z_order, 
  CASE
  WHEN highway IN ('motorway', 'motorway_link', 'trunk', 'trunk_link', 'primary', 'secondary') THEN highway
  WHEN highway IN ('primary_link', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclassified', 'road', 'living_street') THEN 'minorroad'
  WHEN highway IN ('path', 'steps', 'footway') THEN 'path'
  WHEN highway IN ('cycleway') THEN highway
  WHEN highway IN ('service', 'track') THEN 'service'
  WHEN highway IN ('pedestrian') THEN 'noauto'
  WHEN railway IN ('light_rail', 'subway', 'narrow_gauge', 'rail', 'tram') THEN 'railway'
  ELSE NULL END AS type
  FROM lines WHERE type IS NOT NULL AND (tunnel IS NULL OR tunnel NOT IN ('yes', '1', 'true'));


time_start: 2023-01-18T21:52:03.456Z
time_end: 2023-01-18T21:52:03.458Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_tunnels AS SELECT geometry, z_order, 
  CASE
  WHEN highway IN ('motorway', 'motorway_link', 'trunk', 'trunk_link', 'primary', 'secondary') THEN highway
  WHEN highway IN ('primary_link', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclassified', 'road', 'living_street') THEN 'minorroad'
  WHEN highway IN ('path', 'cycleway') THEN highway
  WHEN highway IN ('service', 'track') THEN 'service'
  WHEN highway IN ('footway', 'pedestrian', 'steps', 'bridleway') THEN 'noauto'
  WHEN railway IN ('light_rail', 'subway', 'narrow_gauge', 'rail', 'tram') THEN 'railway'
  ELSE NULL END AS type
  FROM lines WHERE type IS NOT NULL AND tunnel IN ('yes', '1', 'true');


time_start: 2023-01-18T21:52:03.459Z
time_end: 2023-01-18T21:52:03.460Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_bridges AS SELECT geometry, z_order, 
  CASE
  WHEN highway IN ('motorway', 'motorway_link', 'trunk', 'trunk_link', 'primary', 'secondary') THEN highway
  WHEN highway IN ('primary_link', 'secondary_link', 'tertiary', 'tertiary_link', 'residential', 'unclassified', 'road', 'living_street') THEN 'minorroad'
  WHEN highway IN ('path', 'cycleway') THEN highway
  WHEN highway IN ('service', 'track') THEN 'service'
  WHEN highway IN ('footway', 'pedestrian', 'steps', 'bridleway') THEN 'noauto'
  WHEN railway IN ('light_rail', 'subway', 'narrow_gauge', 'rail', 'tram') THEN 'railway'
  ELSE NULL END AS type
  FROM lines WHERE type IS NOT NULL AND bridge IN ('yes', '1', 'true');


time_start: 2023-01-18T21:52:03.462Z
time_end: 2023-01-18T21:52:03.463Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_places_country AS SELECT geometry, name, name_en, 
  CASE
  WHEN population IS NOT NULL THEN CAST(population AS INTEGER)
  ELSE 0
  END AS population FROM points
  WHERE  place IN ('country');


time_start: 2023-01-18T21:52:03.464Z
time_end: 2023-01-18T21:52:03.465Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_places_state AS SELECT geometry, name, name_en, 
  CASE
  WHEN population IS NOT NULL THEN CAST(population AS INTEGER)
  ELSE 0
  END AS population FROM points
  WHERE  place IN ('state');


time_start: 2023-01-18T21:52:03.479Z
time_end: 2023-01-18T21:52:03.482Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_places_city AS SELECT geometry, name, name_en, 
  CASE
  WHEN place = 'city' THEN 6
  WHEN place = 'region' THEN 8
  WHEN place = 'county' THEN 7
  ELSE -1
  END AS z_order, 
  CASE
  WHEN population IS NOT NULL THEN CAST(population AS INTEGER)
  ELSE 0
  END AS population FROM points
  WHERE  place IN ('region', 'county', 'city');


time_start: 2023-01-18T21:52:03.483Z
time_end: 2023-01-18T21:52:03.485Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_places_town AS SELECT geometry, name, name_en, 
  CASE
  WHEN population IS NOT NULL THEN CAST(population AS INTEGER)
  ELSE 0
  END AS population FROM points
  WHERE  place IN ('town');


time_start: 2023-01-18T21:52:03.486Z
time_end: 2023-01-18T21:52:03.487Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_places_small AS SELECT geometry, name, name_en, 
  CASE
  WHEN place = 'hamlet' THEN 3
  WHEN place = 'suburb' THEN 2
  WHEN place = 'village' THEN 4
  WHEN place = 'neighbourhood' THEN 1
  ELSE 0
  END AS z_order, 
  CASE
  WHEN population IS NOT NULL THEN CAST(population AS INTEGER)
  ELSE 0
  END AS population FROM points
  WHERE  place IN ('village', 'hamlet', 'suburb', 'neighbourhood');


time_start: 2023-01-18T21:52:03.489Z
time_end: 2023-01-18T21:52:03.490Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_places_tiny AS SELECT geometry, name, name_en
  FROM points
  WHERE  place IN ('locality');


time_start: 2023-01-18T21:52:03.492Z
time_end: 2023-01-18T21:52:03.494Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_railway_stations AS SELECT geometry, name, name_en, railway
  FROM points WHERE railway IN ('subway_entrance', 'station', 'halt', 'tram_stop');


time_start: 2023-01-18T21:52:03.495Z
time_end: 2023-01-18T21:52:03.510Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_turning_circles AS SELECT geometry FROM points WHERE highway IN ('turning_circle');


time_start: 2023-01-18T21:52:03.512Z
time_end: 2023-01-18T21:52:03.513Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_waterways AS SELECT geometry, name, name_en, waterway AS type FROM lines
  WHERE  waterway IN ('stream', 'river', 'canal', 'drain', 'ditch')
  UNION ALL SELECT geometry, name, name_en, barrier AS type FROM lines
  WHERE  barrier IN ('ditch');


time_start: 2023-01-18T21:52:03.516Z
time_end: 2023-01-18T21:52:03.517Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_waterareas AS SELECT geometry, name, name_en, waterway AS type FROM multipolygons
  WHERE waterway IN ('riverbank')
  UNION ALL SELECT geometry, name, name_en, landuse AS type FROM multipolygons
  WHERE  landuse IN ('basin', 'reservoir')
  UNION ALL SELECT geometry, name, name_en, natural AS type FROM multipolygons
  WHERE  natural IN ('water');


time_start: 2023-01-18T21:52:03.520Z
time_end: 2023-01-18T21:52:03.522Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_admin_gen0 AS SELECT CastToMultiPolygon(ST_SimplifyPreserveTopology(geometry, 0.005)) AS geometry
  FROM vw_osm_admin;


time_start: 2023-01-18T21:52:03.524Z
time_end: 2023-01-18T21:52:03.525Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_admin_gen1 AS SELECT CastToMultiPolygon(ST_SimplifyPreserveTopology(geometry, 0.0003)) AS geometry
  FROM vw_osm_admin;


time_start: 2023-01-18T21:52:03.527Z
time_end: 2023-01-18T21:52:03.528Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_landusages_gen0 AS
  SELECT CastToMultiPolygon(ST_SimplifyPreserveTopology(geometry, 0.005)) AS geometry, type, area
  FROM   vw_osm_landusages
  WHERE  ST_Area(geometry)>1e-3;


time_start: 2023-01-18T21:52:03.530Z
time_end: 2023-01-18T21:52:03.531Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_landusages_gen1 AS
  SELECT CastToMultiPolygon(ST_SimplifyPreserveTopology(geometry, 5e-4)) AS geometry, type, area
  FROM   vw_osm_landusages
  WHERE  ST_Area(geometry)>1e-5;


time_start: 2023-01-18T21:52:03.548Z
time_end: 2023-01-18T21:52:03.549Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_landusage_overlays AS
  SELECT geometry, type, area
  FROM   vw_osm_landusages
  WHERE  type IN ('nature_reserve', 'wetland');


time_start: 2023-01-18T21:52:03.551Z
time_end: 2023-01-18T21:52:03.553Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_landusage_overlays_gen0 AS
  SELECT CastToMultiPolygon(ST_SimplifyPreserveTopology(geometry, 0.005)) AS geometry, type, area
  FROM   vw_osm_landusage_overlays
  WHERE  ST_Area(geometry)>1e-3;


time_start: 2023-01-18T21:52:03.555Z
time_end: 2023-01-18T21:52:03.556Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_landusage_overlays_gen1 AS
  SELECT CastToMultiPolygon(ST_SimplifyPreserveTopology(geometry, 5e-4)) AS geometry, type, area
  FROM   vw_osm_landusage_overlays
  WHERE  ST_Area(geometry)>1e-5;


time_start: 2023-01-18T21:52:03.558Z
time_end: 2023-01-18T21:52:03.560Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_motorways_gen0 AS
  SELECT ST_SimplifyPreserveTopology(geometry, 0.002) AS geometry, type, ref
  FROM   vw_osm_motorways;


time_start: 2023-01-18T21:52:03.561Z
time_end: 2023-01-18T21:52:03.563Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_waterareas_gen0 AS
  SELECT CastToMultiPolygon(ST_SimplifyPreserveTopology(geometry, 0.005)) AS geometry
  FROM   vw_osm_waterareas
  WHERE  ST_Area(geometry)>1e-3;


time_start: 2023-01-18T21:52:03.564Z
time_end: 2023-01-18T21:52:03.566Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_waterareas_gen1 AS
  SELECT CastToMultiPolygon(ST_SimplifyPreserveTopology(geometry, 5e-4)) AS geometry
  FROM   vw_osm_waterareas
  WHERE  ST_Area(geometry)>1e-05;


time_start: 2023-01-18T21:52:03.568Z
time_end: 2023-01-18T21:52:03.569Z
user_agent: spatialite CLI
error_cause: success
sql_statement:
  CREATE VIEW vw_osm_waterways_low AS
  SELECT ST_SimplifyPreserveTopology(geometry, 0.0003) AS geometry
  FROM   vw_osm_waterways
  WHERE  type IN ('river', 'canal');


# osm_building_labels

bname:
  Horry County Fire/ Resuce Station 19 Cherry Hill;Horry County Fire / Rescue Station 19 Cherry Hill 2501


