How to find the neighbouring nodes of a particular node

I have imported the osm file into postgresql. The tables I have are planet_osm_ndes,planet_osm_ways, planet_osm_point. planet_osm_roads etc. But no table contains the information of neighbouring nodes of a node. I tried connecting to the database using java and tried finding the neighbours, but the code runs for hrs and still no output. Is there a easy way to do it

postgresql postgis sql

asked 12 Feb '18, 03:21

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

edited 12 Feb '18, 03:22

One Answer:

active answers oldest answers newest answers popular answers

The osm2pgsql database schema is optimised for drawing maps; for this use case, neighbouring nodes are uninteresting. If you have used the --slim flag on osm2pgsql (which you apparently have since you mention planet_osm_nodes), you can look at the "nodes" array of ways in planet_osm_ways (step 1: find out which ways contain your node of interest, step 2: find out where in the node list your node occurs, step 3: find the nodes before and after, if applicable). However, it sounds as if your use case might warrant a different kind of database import that gives you easier access to the node/way connections, for example check out the "ApiDB" import offered by Osmosis.

permanent link

answered 12 Feb '18, 09:54

Frederik Ramm ♦
82.4k●92●720●1272
accept rate: 23%

Your answer

toggle preview

community wiki:

Follow this question

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

learn more about Markdown

Question tags:

postgresql ×165
postgis ×134
sql ×18

question asked: 12 Feb '18, 03:21

question was seen: 1,794 times

last updated: 12 Feb '18, 09:54

How to find the neighbouring nodes of a particular node

Follow this question

Related questions