# sql_statements_log

time_start: 2023-01-18T20:10:08.540Z
time_end: 2023-01-18T20:10:08.541Z
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:10:12.236Z
time_end: 2023-01-18T20:10:12.292Z
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:10:12.772Z
time_end: 2023-01-18T20:10:12.786Z
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:10:12.959Z
time_end: 2023-01-18T20:10:12.962Z
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:10:14.855Z
time_end: 2023-01-18T20:10:14.856Z
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:10:14.873Z
time_end: 2023-01-18T20:10:14.874Z
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:10:14.876Z
time_end: 2023-01-18T20:10:14.877Z
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:10:14.879Z
time_end: 2023-01-18T20:10:14.918Z
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:10:14.920Z
time_end: 2023-01-18T20:10:14.921Z
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:10:14.923Z
time_end: 2023-01-18T20:10:14.947Z
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:10:14.952Z
time_end: 2023-01-18T20:10:14.954Z
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:10:14.955Z
time_end: 2023-01-18T20:10:14.956Z
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:10:14.958Z
time_end: 2023-01-18T20:10:14.959Z
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:10:14.960Z
time_end: 2023-01-18T20:10:14.961Z
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:10:14.963Z
time_end: 2023-01-18T20:10:14.964Z
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:10:14.968Z
time_end: 2023-01-18T20:10:14.969Z
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:10:15.013Z
time_end: 2023-01-18T20:10:15.031Z
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:10:15.033Z
time_end: 2023-01-18T20:10:15.034Z
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:10:15.035Z
time_end: 2023-01-18T20:10:15.037Z
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:10:15.038Z
time_end: 2023-01-18T20:10:15.039Z
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:10:15.040Z
time_end: 2023-01-18T20:10:15.042Z
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:10:15.043Z
time_end: 2023-01-18T20:10:15.044Z
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:10:15.046Z
time_end: 2023-01-18T20:10:15.047Z
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:10:15.048Z
time_end: 2023-01-18T20:10:15.049Z
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:10:15.050Z
time_end: 2023-01-18T20:10:15.051Z
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:10:15.052Z
time_end: 2023-01-18T20:10:15.053Z
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:10:15.055Z
time_end: 2023-01-18T20:10:15.055Z
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:10:15.057Z
time_end: 2023-01-18T20:10:15.058Z
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:10:15.060Z
time_end: 2023-01-18T20:10:15.123Z
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:10:15.124Z
time_end: 2023-01-18T20:10:15.125Z
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:10:15.127Z
time_end: 2023-01-18T20:10:15.284Z
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:10:15.285Z
time_end: 2023-01-18T20:10:15.286Z
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:10:15.288Z
time_end: 2023-01-18T20:10:15.289Z
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:10:15.290Z
time_end: 2023-01-18T20:10:15.291Z
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:10:15.292Z
time_end: 2023-01-18T20:10:15.293Z
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:10:15.294Z
time_end: 2023-01-18T20:10:15.295Z
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:10:15.296Z
time_end: 2023-01-18T20:10:15.297Z
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:10:15.299Z
time_end: 2023-01-18T20:10:15.300Z
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:10:15.301Z
time_end: 2023-01-18T20:10:15.302Z
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:10:15.304Z
time_end: 2023-01-18T20:10:15.305Z
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:10:15.307Z
time_end: 2023-01-18T20:10:15.308Z
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:10:15.309Z
time_end: 2023-01-18T20:10:15.310Z
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:10:15.311Z
time_end: 2023-01-18T20:10:15.312Z
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_roads_gen2

ref: 65К-1403120
type: minorroad
name:
  Подъезд к д. Верхняя Бобровка от км 29+352 а/д «г. Красноуфимск — с. Нижнеиргинское — с. Красносоколье»


