Lat and Long for a set of node from a way

Question

Hi,

I'm mapping areas for fire-stations and we use a "tactical grid" over our map. I want to get all street names from the fire-service area and then create a list saying eg:

Nelson Street - A5
Duty Road - B6

where A5 is a square in our tactical grid and so on. I've a routine, converting GPS Lat and Long to our grid system.

The problem is that when I export OSM file (using eg this: https://www.openstreetmap.org/export#map=14/51.4898/-0.0882&layers=N )I get a file where the "real node" have their GPS values, but streets has only the "nd" reference of their node, without the GPS values.

Of course, I can ask OSM server for Lat and Long for each "nd", one bye one using : http://api.openstreetmap.org/api/0.6/node/2639002010 but it will take time: I need the GPS values for each point, in case of a street overlapping more than one square of our grid;

How can I get, in one call, GPS values of all "nd"? Is-it possible to get an OSM file, directly with them, or is there a way to send a "pack" of "nd" references to the server and get pack in one call, all Lat and Long fo each of them?

Thanks a lot

Answer 1

The export you mention already contains the lat/lon for all nodes. If a way says

<nd ref="1234" />

then there will be a

<node id="1234" lat="1.234" lon="2.345" ... />

later in the file.

You might however be approaching this in a way that causes you more headache and the OSM server more load than necessary. You could simply download all the data for your region of interest, import it into PostGIS with osm2pgsql (use the -l flag) and then with relative ease query the database for all roads that are inside a certain rectangle - with a query like

SELECT name 
FROM planet_osm_line
WHERE highway is not null AND
   way && ST_MakeBox2D(
       ST_Point(lon, lat), -- place lower left coordinates of box here
       ST_Point(lon, lat)) -- place upper right coordinates of box here

Another alternative is using the Overpass API to return all highway-type ways in a given bounding box.

Answer 2

0	for those who ask for : lon, lat from planet_osm_nodes, here is your response : "select lon::numeric/10000000 as lon, lat::numeric/10000000 as lat from planet_osm_nodes". permanent link answered 15 Jul '20, 05:04 Abdelkader 10●1 accept rate: 0%

Lat and Long for a set of node from a way

Follow this question

Related questions