This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

creating PostGIS

0

How do I load OSM data into a PostGIS database.

asked 19 Mar '14, 17:00

deco2208's gravatar image

deco2208
26111214
accept rate: 0%

edited 19 Mar '14, 17:01


2 Answers:

1

The switch2osm instructions should help. That was written for PostGIS 1.5, so if you're using a later version some bits will be slightly different (e.g. something like "psql -d gis -c 'create extension postgis;'" instead of "psql -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql -d gis")

answered 19 Mar '14, 17:06

SomeoneElse's gravatar image

SomeoneElse ♦
36.9k71370866
accept rate: 16%

I don't get it. I went to the site and couldn't find how to set up PostGIS.

(21 Mar '14, 23:11) deco2208
2

Presumably you read the bit that says "Installing postgresql / postgis"? What did you try and what did not work?

(21 Mar '14, 23:13) SomeoneElse ♦

0

I would recommend using osm2pgsql. See the page on the OSM wiki

answered 25 Sep '14, 00:05

mpmckenna8's gravatar image

mpmckenna8
1
accept rate: 0%

Source code available on GitHub .