# sql_statements_log

time_start: 2023-01-18T20:26:29.920Z
time_end: 2023-01-18T20:26:29.921Z
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-18T20:26:29.922Z
time_end: 2023-01-18T20:26:29.923Z
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-18T20:26:29.924Z
time_end: 2023-01-18T20:26:29.925Z
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-18T20:26:29.935Z
time_end: 2023-01-18T20:26:29.938Z
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-18T20:26:30.947Z
time_end: 2023-01-18T20:26:30.948Z
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-18T20:26:30.949Z
time_end: 2023-01-18T20:26:30.950Z
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-18T20:26:30.956Z
time_end: 2023-01-18T20:26:30.958Z
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-18T20:26:31.086Z
time_end: 2023-01-18T20:26:31.093Z
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-18T20:26:31.096Z
time_end: 2023-01-18T20:26:31.098Z
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-18T20:26:31.100Z
time_end: 2023-01-18T20:26:31.101Z
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-18T20:26:31.103Z
time_end: 2023-01-18T20:26:31.104Z
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-18T20:26:31.106Z
time_end: 2023-01-18T20:26:31.108Z
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-18T20:26:31.109Z
time_end: 2023-01-18T20:26:31.111Z
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-18T20:26:31.112Z
time_end: 2023-01-18T20:26:31.114Z
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-18T20:26:31.115Z
time_end: 2023-01-18T20:26:31.117Z
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-18T20:26:31.123Z
time_end: 2023-01-18T20:26:31.125Z
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-18T20:26:31.127Z
time_end: 2023-01-18T20:26:31.129Z
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-18T20:26:31.130Z
time_end: 2023-01-18T20:26:31.132Z
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-18T20:26:31.133Z
time_end: 2023-01-18T20:26:31.134Z
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-18T20:26:31.135Z
time_end: 2023-01-18T20:26:31.136Z
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-18T20:26:31.138Z
time_end: 2023-01-18T20:26:31.139Z
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-18T20:26:31.140Z
time_end: 2023-01-18T20:26:31.142Z
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-18T20:26:31.143Z
time_end: 2023-01-18T20:26:31.144Z
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-18T20:26:31.146Z
time_end: 2023-01-18T20:26:31.147Z
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-18T20:26:31.149Z
time_end: 2023-01-18T20:26:31.150Z
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-18T20:26:31.152Z
time_end: 2023-01-18T20:26:31.153Z
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-18T20:26:31.155Z
time_end: 2023-01-18T20:26:31.157Z
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-18T20:26:31.159Z
time_end: 2023-01-18T20:26:31.160Z
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-18T20:26:31.162Z
time_end: 2023-01-18T20:26:31.163Z
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-18T20:26:31.165Z
time_end: 2023-01-18T20:26:31.166Z
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-18T20:26:31.168Z
time_end: 2023-01-18T20:26:31.169Z
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-18T20:26:31.171Z
time_end: 2023-01-18T20:26:31.173Z
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-18T20:26:31.175Z
time_end: 2023-01-18T20:26:31.176Z
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-18T20:26:31.178Z
time_end: 2023-01-18T20:26:31.179Z
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-18T20:26:31.181Z
time_end: 2023-01-18T20:26:31.182Z
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-18T20:26:31.184Z
time_end: 2023-01-18T20:26:31.185Z
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-18T20:26:31.187Z
time_end: 2023-01-18T20:26:31.188Z
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-18T20:26:31.190Z
time_end: 2023-01-18T20:26:31.192Z
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-18T20:26:31.194Z
time_end: 2023-01-18T20:26:31.195Z
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-18T20:26:31.197Z
time_end: 2023-01-18T20:26:31.198Z
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-18T20:26:31.200Z
time_end: 2023-01-18T20:26:31.201Z
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-18T20:26:31.203Z
time_end: 2023-01-18T20:26:31.205Z
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-18T20:26:31.207Z
time_end: 2023-01-18T20:26:31.208Z
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_amenity_z15

icon: college
name:
  Архангельский колледж телекоммуникаций им. Б.Л. Розинга (филиал) ФГБОУ ВО СПбГУТ им. проф. М.А. Бонч-Бруевича


# osm_area_labels

name:
  Воинский мемориал "Воинам, павшим в годы ВОВ 1941-1945 г.г.", умершим в госпиталях г. Архангельска в годы ВОВ, с захоронением


# osm_building_labels

bname:
  Архангельский колледж телекоммуникаций им. Б.Л. Розинга (филиал) ФГБОУ ВО СПбГУТ им. проф. М.А. Бонч-Бруевича 24


bname:
  Консультативно-диагностический центр специализированной помощи детскому и подростковому населению Архангельской области Государственное бюджетное учреждение здравоохранения Архангельской области "Архангельский противотуберкулезный диспансер" 28 к1


bname:
  Московский государственный образовательный университет экономики, статистики и информатики, филиал в г. Архангельске 42


bname:
  бюджетное учреждение здравоохранения Вологодской области "Верховажская центральная районная больница", Климушинский ФАП 21


bname:
  Всероссийская общественная организация ветеранов(пенсионеров) войны и труда, вооруженных сил и правоохранительных органов, Верховажское районное отделение 30


bname:
  Администрация Сусоловского сельского поселения Великоустюгского муниципального района Вологодской области 5


bname:
  бюджетное учреждение здравоохранения Вологодской области "Верховажская центральная районная больница", Пежемский ФАП 6


bname:
  Муниципальное бюджетное учреждение социальной защиты "Комплексный Центр социального обслуживания населения" Верховажского муниципального района Вологодской области 4А


bname:
  Администрация Верховажского сельского поселения Верховажского муниципального района Вологодской области 3


bname:
  ФЕДЕРАЛЬНОЕ ГОСУДАРСТВЕННОЕ УЧРЕЖДЕНИЕ "ВЕРХОВАЖСКАЯ РАЙОННАЯ СТАНЦИЯ ПО БОРЬБЕ С БОЛЕЗНЯМИ ЖИВОТНЫХ" 7


bname:
  Муниципальное бюджетное общеобразовательное учреждение "Верховажская средняя школа имени Я.Я.Кремлева 16


bname:
  Администрация Красавинского сельского поселения Великоустюгского муниципального района Вологодской области 7


bname:
  бюджетное учреждение здравоохранения Вологодской области "Великоустюгская центральная районная больница", Красавинский ФАП 32


bname:
  бюджетное учреждение здравоохранения Вологодской области "Верховажская центральная районная больница", Косковский ФАП 74


bname:
  Муниципальное бюджетное общеобразовательное учреждение "Климушинская начальная школа-детский сад" 13


bname:
  Администрация Ломоватского сельского поселения Великоустюгского муниципального района Вологодской области 27


