add linestring to osm streets within postgres

Here is what I did

I have imported streets from OSM into my postgres db with osmosis.

Here is my question

After importing the osm data with osmosis, I now wanna add a linestring to the osm streets. Is there a way to edit the linestring in the existing osm schema/structure that osmosis has defined within postgres

osm data structure within postgres via osmosis

Postgres is showing me following tables:

nodes
ways
way_nodes
relations
relation_members

can't figure out the relationship between the tables. I now that the table 'ways' is connected with the table 'way__nodes' via the way_id column.

osm postgresql osmosis

asked 10 Nov '19, 20:31

Tara
21●2●2●4
accept rate: 0%

edited 10 Nov '19, 20:32

I suspect you may be better with an osm2pgsql database rather than an API or snapshot DB (from your comment this looks like a snapshot DB). Depending which osmosis options you used there may well be a column containing line strings in the ways table. Otherwise you need to write (quite) complex queries linking nodes, way_nodes and ways.

(11 Nov '19, 11:28) SK53 ♦

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:

osm ×710
osmosis ×252
postgresql ×165

question asked: 10 Nov '19, 20:31

question was seen: 1,048 times

last updated: 11 Nov '19, 11:28

add linestring to osm streets within postgres

Follow this question

Related questions