Hi

I extracted and have written a postgresql database using the following tool. https://imposm.org/docs/imposm3/latest/

I want to extract lat, lon of the way points of a given way OSM ID using psql command. How can I do this ?

Thanks.

asked 21 Jan, 04:03

mkandula's gravatar image

mkandula
11111
accept rate: 0%


Imposm is optimized for rendering OSM data, and is not really suitable for a more general purpose spatial database, most people will use osm2pgsql for that.

In particular imposm will create separate tables for each mapping that you have defined, so you will need to see what table the objects you are interested were mapped to query that for the geometry column by osm_id and then step through the linestring to retrieve the individual coordinate pairs (both imposm and osm2pgsql schemas don't have a direct way to access individual, untagged way nodes once the data has been imported with SQL).

permanent link

answered 21 Jan, 07:01

SimonPoole's gravatar image

SimonPoole ♦
38.7k13287614
accept rate: 19%

Your answer
toggle preview

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

Question tags:

×146
×24
×6
×2

question asked: 21 Jan, 04:03

question was seen: 545 times

last updated: 21 Jan, 07:01

powered by OSQA