[Tile-serving] [osm2pgsql-dev/osm2pgsql] Check intersection with preprocessed (area) dataset (Discussion #2264)

[Tobias]

A extension for this feature could be, to also count and sum stuff in other tables inside an osm2pgsql-run.

The setup could be very similar to what is described above. The main difference is, that here the osm2pgsql-run in step 3 would ideally represent the area which then counts points or lines in a different table.

The UseCases are more in the area of statistics:

- I have a table of Mapillary picture points and want to add properties to my way. The most comprehensive lookup would be "number of Mapillary foto points that are junger than 2 years (created at) and panoramas (pano:true) and inside a buffer of the given way"

- Have a boundaries table and add properties to it based on the length of certain ways in a different table.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2264#discussioncomment-10877750
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2264/comments/10877750 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20241008/6f749dc0/attachment.htm>