NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

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.7k13326701


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.7k13326701
accept rate: 18%

edited 27 Aug '17, 20:19

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:

×263
×134

question asked: 26 Aug '17, 10:27

question was seen: 2,313 times

last updated: 27 Aug '17, 20:21

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum