Generating node information from point A to point B from OpenStreetMap?

I have the OpenStreetMap database of Saxony and i want to Return a street which is between 2 given Node ID I should return in POSTGRE SQL

answer should be something like

{…,name: “Annaberger Straße”, points:[ {Lng, Lat}, {Lng, Lat}, …], distance: ???,…}

i want find the distance between two nodes and also i need to return the street name, and geometries between the nodes from openstreetmap database?

nearest nodes postgis distance

asked 29 Sep '15, 16:56

vinod12b
11●1●1●2
accept rate: 0%

aseerel4c26 ♦
32.2k●16●241●552

do you mean routing or a straight line between the two nodes?

(29 Sep '15, 20:36) aseerel4c26 ♦

Have you already imported the data into a PostgreSQL database, and if yes, how?

(29 Sep '15, 22:24) Frederik Ramm ♦

aseerel4c26- thank you and yeah straight line between two nodes ..

Frederik Ramm- i imported .pbf file from gofabrik to postgre sql using osm2pgsql through cmd

(30 Sep '15, 14:32) vinod12b

Be the first one to answer this question!

toggle preview

community wiki:

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

Question tags:

question asked: 29 Sep '15, 16:56

question was seen: 2,109 times

last updated: 30 Sep '15, 14:32