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

  • name
  • Longitude and Latitude of all points between the nodes
  • Distance (double value in km)

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?

asked 29 Sep '15, 16:56

vinod12b's gravatar image

accept rate: 0%

edited 29 Sep '15, 20:37

aseerel4c26's gravatar image

aseerel4c26 ♦


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

Follow this question

By Email:

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



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,296 times

last updated: 30 Sep '15, 14:32

powered by OSQA