Revision of RuleShoppingMall
Going through the Attica OBM buildings, I've found the following case of a shopping mall that ends up classified as UNK
:
OSM ID 160067840
Querying the OSM replication databases following the queries in GetBuildingTagsOSMLands and GetBuildingTagsOSMSpots returns:
osm_replication=> SELECT tags FROM osm_building_polygons WHERE osm_id = 160067840;
tags
-------------------------------------------------------------------------------------------------------------------------------------------------------------
"name"=>"Village Shopping and More Ρεντης", "shop"=>"mall", "website"=>"https://www.villageshopping.gr/", "building"=>"yes", "operator"=>"Village Roadshow"
(1 row)
osm_replication=> SELECT os.key, os.type FROM osm_building_polygons AS obp INNER JOIN osm_lands AS os ON ST_Contains(os.geometry, obp.geometry) WHERE obp.osm_id = 160067840;
key | type
---------+--------
landuse | retail
(1 row)
osm_replication=> SELECT os.key, os.type FROM osm_building_polygons AS obp INNER JOIN osm_spots AS os ON ST_Intersects(obp.geometry, os.geometry) WHERE obp.osm_id = 160067840;
key | type
---------+---------------------
shop | clothes
amenity | fast_food
shop | books
shop | jewelry
amenity | fast_food
amenity | ice_cream
amenity | cafe
amenity | restaurant
amenity | fast_food
amenity | cafe
amenity | cinema
shop | fashion_accessories
amenity | restaurant
(13 rows)
Can we please take a look in detail at why this is not resulting in COM1
?
obm_buildings=> SELECT occupancy FROM obm_buildings WHERE osm_id = 160067840;
occupancy
-----------
UNK
(1 row)