I'm using OSM2PgSQL to load osm data into my PostGIS db. I am shortage of space and also do not need the entire data to be loaded. I only want to load osm_lines and osm_polygons. How can I configure this?

Any other import tool which would help me accomplish this would do as well.

asked 26 Aug '17, 10:27

Ones%20Infinite's gravatar image

Ones Infinite
61338
accept rate: 0%

edited 27 Aug '17, 20:21

SimonPoole's gravatar image

SimonPoole ♦
44.1k13321692


You need to edit the default.style file to only import what you are interested in and drop the slim mode tables once you've imported. In any case you will still be initially importing nodes because they are required for building the geometries (and given that most OSM nodes are actually way nodes it is going to be nearly all of them).

With other words at least temporarily you will need more space or lots of memory to be able to run osm2pgsql in non-slim mode.

permanent link

answered 27 Aug '17, 20:18

SimonPoole's gravatar image

SimonPoole ♦
44.1k13321692
accept rate: 18%

edited 27 Aug '17, 20: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:

×258
×134

question asked: 26 Aug '17, 10:27

question was seen: 1,872 times

last updated: 27 Aug '17, 20:21

powered by OSQA