OpenPlaceGuide / openplaceguide

Main organizational Repository for OpenPlaceGuide (formerly known as Open Business Map) - OpenStreetMap-based business directory
https://www.openplaceguide.org/
GNU Affero General Public License v3.0
2 stars 1 forks source link

Database Structure #8

Open amenk opened 2 years ago

amenk commented 2 years ago

Notes: osm_poi_polygon of the openmaptiles structure has negativ osm_ids für relations, positive for way osm_poi_point: positive osm ids for points

amenk commented 2 years ago

The tiles do have a mapped version of the OSM ID, see https://github.com/openmaptiles/openmaptiles/pull/378

amenk commented 1 year ago

We would probably use Overpass to fetch the info, not the rendering database. This has the advantage the installation being more modular. Example query to fetch a way%3B%0Aout%20body%3B%0A%3E%3B&C=85.05113;-83.67187;0&R) - remember to switch to the data tab.

[out:json][timeout:25];
(
  way(id:162817836);
);
out body;
>;