Create POI (Points of Interest) layer

[rustprooflabs]

Details

This idea was listed in the legacy PgOSM project's wish list, was not yet implemented.

---

Thoughts for moving forward:

• Determine what features to include/exclude
• Converts Line / Polygon layers to Point (ST_Centroid) (cannot currently achieve in .lua, will require point/line/polygon tables and a view/mv like the buildings layer)
• PK: osm_id + geom_type
• What about osm_type/osm_subtype?
• Provide linkages to source tables in osm schema? <-- Maybe bring up in the future, likely too complicated for v1

Columns for POI feature tables

Beyond the osm_id, geom_type, osm_type,osm_subtype` columns, some ideas:

• name
• operator
• address parts
• ele <-- Decided to exclude for now, can get from tags table easy enough if needed.

POIs

• Buildings (only if they have a name, operator, and/or address?)
• Are really tall buildings by default a landmark? I would assume many have names/operators already, but...?
• Shops
• Amenities
• Leisure
• Parks
• Artwork

Not POIs

• Traffic control (stop sign, lights)
• Landuse (residential/retail/etc)
• Trees
• what else?

Unsure

• Rural landmarks (Water towers, Grain elevators)
• Neighborhood / Suburb?
• :question: What else??

[rustprooflabs]

Suggestions to look at from Twitter:

• https://github.com/GIScience/openpoiservice
• https://github.com/whosonfirst/whosonfirst-categories
• https://github.com/openstreetmap/id-tagging-schema/tree/main/data