[Tile-serving] [openstreetmap/osm2pgsql] Add get_node_location() function to middle (PR #1724)

[Jochen Topf]

Before we had only a function to retrieve a list of locations from a
list of nodes which is inconvenient if you only need a single location.

The new function is needed in the context of retrieving locations for
member nodes of relations.

There are probably ways to improve on this:
* We are using the get_node_list prepared statement to get the single
  id when a simpler prepared statement would do. But then we'd need
  another prepared statement.
* When using this it might be possible to first assemble a list of
  several ids and get them all in one go. But its more difficult to
  write code like this and there aren't that many relations around
  that have lots of node members, so we'll leave it at that and
  optimize this later if needed.
You can view, comment on, or merge this pull request online at:

  https://github.com/openstreetmap/osm2pgsql/pull/1724

-- Commit Summary --

  * Add get_node_location() function to middle

-- File Changes --

    M src/middle-pgsql.cpp (32)
    M src/middle-pgsql.hpp (4)
    M src/middle-ram.cpp (5)
    M src/middle-ram.hpp (2)
    M src/middle.hpp (5)
    M tests/test-middle.cpp (15)

-- Patch Links --

https://github.com/openstreetmap/osm2pgsql/pull/1724.patch
https://github.com/openstreetmap/osm2pgsql/pull/1724.diff

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/pull/1724
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/pull/1724 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220731/306e1090/attachment.htm>