# sql_statements_log

time_start: 2023-01-18T15:08:26.437Z
time_end: 2023-01-18T15:08:26.440Z
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-18T15:08:26.445Z
time_end: 2023-01-18T15:08:26.446Z
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-18T15:08:26.447Z
time_end: 2023-01-18T15:08:26.448Z
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-18T15:08:26.450Z
time_end: 2023-01-18T15:08:26.451Z
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-18T15:08:29.669Z
time_end: 2023-01-18T15:08:29.788Z
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-18T15:08:29.789Z
time_end: 2023-01-18T15:08:29.790Z
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-18T15:08:29.998Z
time_end: 2023-01-18T15:08:30.000Z
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-18T15:08:30.001Z
time_end: 2023-01-18T15:08:30.003Z
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-18T15:08:30.005Z
time_end: 2023-01-18T15:08:30.007Z
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-18T15:08:30.009Z
time_end: 2023-01-18T15:08:30.010Z
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-18T15:08:30.011Z
time_end: 2023-01-18T15:08:30.014Z
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-18T15:08:30.015Z
time_end: 2023-01-18T15:08:30.016Z
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-18T15:08:30.042Z
time_end: 2023-01-18T15:08:30.049Z
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-18T15:08:30.065Z
time_end: 2023-01-18T15:08:30.071Z
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-18T15:08:30.076Z
time_end: 2023-01-18T15:08:30.078Z
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-18T15:08:30.082Z
time_end: 2023-01-18T15:08:30.083Z
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-18T15:08:30.085Z
time_end: 2023-01-18T15:08:30.086Z
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-18T15:08:30.090Z
time_end: 2023-01-18T15:08:30.091Z
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-18T15:08:30.093Z
time_end: 2023-01-18T15:08:30.094Z
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-18T15:08:30.096Z
time_end: 2023-01-18T15:08:30.097Z
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-18T15:08:30.099Z
time_end: 2023-01-18T15:08:30.100Z
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-18T15:08:30.102Z
time_end: 2023-01-18T15:08:30.103Z
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-18T15:08:30.105Z
time_end: 2023-01-18T15:08:30.106Z
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-18T15:08:30.108Z
time_end: 2023-01-18T15:08:30.111Z
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-18T15:08:30.116Z
time_end: 2023-01-18T15:08:30.117Z
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-18T15:08:30.119Z
time_end: 2023-01-18T15:08:30.120Z
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-18T15:08:30.123Z
time_end: 2023-01-18T15:08:30.124Z
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-18T15:08:30.126Z
time_end: 2023-01-18T15:08:30.127Z
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-18T15:08:30.130Z
time_end: 2023-01-18T15:08:30.132Z
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-18T15:08:30.134Z
time_end: 2023-01-18T15:08:30.135Z
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-18T15:08:30.137Z
time_end: 2023-01-18T15:08:30.138Z
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-18T15:08:30.139Z
time_end: 2023-01-18T15:08:30.141Z
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-18T15:08:30.142Z
time_end: 2023-01-18T15:08:30.143Z
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-18T15:08:30.145Z
time_end: 2023-01-18T15:08:30.146Z
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-18T15:08:30.148Z
time_end: 2023-01-18T15:08:30.149Z
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-18T15:08:30.150Z
time_end: 2023-01-18T15:08:30.152Z
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-18T15:08:30.154Z
time_end: 2023-01-18T15:08:30.155Z
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-18T15:08:30.156Z
time_end: 2023-01-18T15:08:30.157Z
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-18T15:08:30.159Z
time_end: 2023-01-18T15:08:30.160Z
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-18T15:08:30.162Z
time_end: 2023-01-18T15:08:30.163Z
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-18T15:08:30.165Z
time_end: 2023-01-18T15:08:30.166Z
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-18T15:08:30.167Z
time_end: 2023-01-18T15:08:30.168Z
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-18T15:08:30.170Z
time_end: 2023-01-18T15:08:30.171Z
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_z13

icon: hospital
name:
  المؤسسة الاستشفائية المتخصصة عبد الله نواورية البوني أمراض النساء والتوليد جراحة الأطفال جراحة التوليد


# osm_amenity_z15

icon: college
name:
  Institut de formation,Sidi Abdel-Rahman El-Yellouly معهد التكوين للأسلاك الخاصة سيدي عبد الرحمن اليلولي


icon: college
name:
  Tasdawit Mulud At Mεammer - Tizi Uzzu - Ḥesnawa Université Mouloud Mammeri de Tizi Ouzou Campus Hasnaoua


# osm_amenity_z17

name_en: Sellahi Hardware Store
icon: shop/diy
name:
  بيع بالتجزئة للخردوات و العقاقير و مواد البناء و الدهن و الكهرباء العامة وادوات منزلية و الكهرومنزلية و اجهزة اعادة الصوت و الصورة


icon: bus
name:
  سوق ليبيا - محطة حافلات الجهة الشمالية - مديرية الصحة - مديرية الوظيف العمومي - الصندوق الوطني للقرض المصغر وكالة الوادي

name_en:
  Libya Market - North Bus Station - Directorate of Health - Directorate of Public Employment - National Fund for Microcredit Agency Of El-Oued


icon: doctor
name:
  Dr Benadla Ramdane Medecin spécialiste OTR Orthopédie, traumatologie, chirurgie de la main, maladies rhumatismales, médecin du sport


icon: doctor
name:
  dr.zahi salim: nephrologist diabetologist cardiologists ultrasound دكتور زاهي سليم : أخصائي كلى و السكر و القلب و الموجات فوق الصوتية


icon: museum
name:
  Musée Public National de l’Enluminure de la Miniature et de la Calligraphie المتحف العمومي الوطني للزخرفة والمنمنمات وفن الخط


# osm_area_labels

name:
  ancienne mosquée Idriside d'Agadir المسجد الإدريسي العتيق لأكادير ⵜⴰⵎⵣⴳⵉⴷⴰ ⵜⵉⴷⵔⵉⵙⵉⵜ ⵜⴰⵇⴱⵓⵔⵜ ⵏ ⴰⴳⴰⴷⵉⵔ


# osm_building_labels

bname:
  Bureau International de la Coopération Décentralisée - Figuig المكتب الدولي التعاون اللامركزي لمدينة فكيك


bname:
  Services Publics : Station météo . Eau potable . Assainissement liquide . Laboratoire municipal مصالح عمومية : محطة الأرصاد . الماء الصالح للشرب . التطهير السائل . المختبر البلدي


bname:
  l'Institut national de formation spécialisée des corps spécifiques de l'administration des affaires religieuses


# osm_roads_gen1

name_en: Algiers-Tizi Ouzou Highway;Bypass of Bordj Menail
type: motorway
name:
  Autoroute Alger-Tizi Ouzou;Evitement de Bordj Menaïl الطريق السيار الجزائر-تيزي وزو;الطريق الاجتنابي لبرج منايل


name_en: Algiers-Tizi Ouzou Highway;Southern Bypass of Tizi Ouzou
type: motorway
name:
  Autoroute Alger-Tizi Ouzou الطريق السيار الجزائر-تيزي وزو;Rocade Sud de Tizi Ouzou الطريق الاجتنابي الجنوبي لتيزي وزو


name_en: Algiers-Tizi Ouzou Highway;Southern Bypass of Tizi Ouzou
type: motorway
name:
  Autoroute Alger-Tizi Ouzou الطريق السيار الجزائر-تيزي وزو;Rocade Sud de Tizi Ouzou التجنب الجنوبي لتيزي وزو


