# sql_statements_log

time_start: 2023-01-18T16:26:07.922Z
time_end: 2023-01-18T16:26:07.923Z
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-18T16:26:07.932Z
time_end: 2023-01-18T16:26:07.946Z
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-18T16:26:07.967Z
time_end: 2023-01-18T16:26:07.978Z
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-18T16:26:08.220Z
time_end: 2023-01-18T16:26:08.247Z
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-18T16:26:09.139Z
time_end: 2023-01-18T16:26:09.141Z
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-18T16:26:09.151Z
time_end: 2023-01-18T16:26:09.162Z
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-18T16:26:09.183Z
time_end: 2023-01-18T16:26:09.193Z
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-18T16:26:09.210Z
time_end: 2023-01-18T16:26:09.220Z
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-18T16:26:09.240Z
time_end: 2023-01-18T16:26:09.255Z
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-18T16:26:09.257Z
time_end: 2023-01-18T16:26:09.258Z
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-18T16:26:09.259Z
time_end: 2023-01-18T16:26:09.261Z
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-18T16:26:09.262Z
time_end: 2023-01-18T16:26:09.263Z
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-18T16:26:09.265Z
time_end: 2023-01-18T16:26:09.266Z
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-18T16:26:09.267Z
time_end: 2023-01-18T16:26:09.268Z
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-18T16:26:09.270Z
time_end: 2023-01-18T16:26:09.271Z
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-18T16:26:09.275Z
time_end: 2023-01-18T16:26:09.513Z
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-18T16:26:09.526Z
time_end: 2023-01-18T16:26:09.527Z
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-18T16:26:09.529Z
time_end: 2023-01-18T16:26:09.531Z
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-18T16:26:09.532Z
time_end: 2023-01-18T16:26:09.535Z
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-18T16:26:09.543Z
time_end: 2023-01-18T16:26:09.546Z
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-18T16:26:09.549Z
time_end: 2023-01-18T16:26:09.557Z
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-18T16:26:09.582Z
time_end: 2023-01-18T16:26:09.594Z
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-18T16:26:09.611Z
time_end: 2023-01-18T16:26:09.625Z
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-18T16:26:09.645Z
time_end: 2023-01-18T16:26:09.653Z
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-18T16:26:09.664Z
time_end: 2023-01-18T16:26:09.668Z
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-18T16:26:09.670Z
time_end: 2023-01-18T16:26:09.920Z
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-18T16:26:09.933Z
time_end: 2023-01-18T16:26:09.934Z
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-18T16:26:10.526Z
time_end: 2023-01-18T16:26:10.551Z
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-18T16:26:10.563Z
time_end: 2023-01-18T16:26:10.565Z
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-18T16:26:10.569Z
time_end: 2023-01-18T16:26:10.574Z
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-18T16:26:10.597Z
time_end: 2023-01-18T16:26:10.609Z
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-18T16:26:10.629Z
time_end: 2023-01-18T16:26:10.638Z
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-18T16:26:10.660Z
time_end: 2023-01-18T16:26:10.678Z
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-18T16:26:10.683Z
time_end: 2023-01-18T16:26:10.684Z
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-18T16:26:10.685Z
time_end: 2023-01-18T16:26:10.687Z
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-18T16:26:10.688Z
time_end: 2023-01-18T16:26:10.690Z
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-18T16:26:10.691Z
time_end: 2023-01-18T16:26:10.692Z
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-18T16:26:10.694Z
time_end: 2023-01-18T16:26:10.695Z
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-18T16:26:10.697Z
time_end: 2023-01-18T16:26:10.698Z
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-18T16:26:10.699Z
time_end: 2023-01-18T16:26:10.700Z
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-18T16:26:10.702Z
time_end: 2023-01-18T16:26:10.703Z
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-18T16:26:10.704Z
time_end: 2023-01-18T16:26:10.706Z
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-18T16:26:10.707Z
time_end: 2023-01-18T16:26:10.708Z
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

name: მაჭის ციხის ბილიკი
name_en: Machi Fortress Trail
type: path
ref:
  http://apa.gov.ge/en/eco-tourism/Trails/lagodexis-daculi-teritoriebis-turistuli-bilikebi/3-machis-cixe


