Tagged Questions

0
votes
0answers
18 views

Importing openstreetmaps exported OSM to opengeo using osm2pgsql problems [duplicate]

i'm having some issues when i go to import osm using osm2pgsql. My layers are showing all the roads coming from a single point. See photo link. I have loaded the same OSM file into Qgis and ...
2
votes
1answer
140 views

osm2pgsql Error: operator class “gist_geometry_ops” does not exist for access method “gist”

When using osm2pgsql to import massachusetts-latest.osm.bz2 into PostGIS 2.0.1 database osm (running on PostgreSQL 9.1 on an Ubuntu 12.04), I get the error failed: ERROR: operator class ...
2
votes
0answers
116 views

Geoserver, PostGIS and KML: Creating clickable nodes from OSM data

I have a PostGIS database that has OSM data imported into it using osm2pgsql and I'm using GeoServer to plot the points into a networked KML file for Google Earth. What I'd like to do is make the ...
2
votes
1answer
158 views

Updating routing graph based on GIS changes in DB

I am using Osm2PO for route finding which reads a graph file created from a pbf file downloaded from OpenStreetMap. I have my own GIS database where updates may be applied to the data. I would like ...
0
votes
2answers
305 views

slow import via osm2pgsql to postgresql database

I try to import berlin.osm (33Mb) into the postgres database 9.1 via osm2pgsql. My desktop is mem 2Gb,proc 2Ghz,hdd 60Gb, RHEL6u2x64. This process is so slowly in particular when I'm going over ...
1
vote
1answer
348 views

Creating osm2pgsql tables in PostGIS database

I managed to partially setup osm2psql to work with my PostGIS DB. My DB contains now the following tables: Schema | Name | Type | Owner --------+-------------------+-------+------- ...
1
vote
1answer
113 views

Howto setup osm2psql

I'm following these instructions to setup osm2psql . I need it to import osm data file inside a PostGIS DB. The following steps worked fine: createdb -E UTF8 -O user mydb createlang plpgsql mydb I ...
1
vote
1answer
66 views

How to find out what features /tags are included in an .osm or .pbf file?

I would like to load osm data into a postgis (postgresql) database. In How to load OSM data into PostGIS preserving all Tags? there has beeen a solution posted: Download the OSM files (in .osm ...
5
votes
3answers
459 views

How to import OSM data into Postgres DB using osm2pgsql in Linux?

I'm using the following command to import an osm file into a Postgres DB using Linux: osm2pgsql -v -a -U user -S default.style -d routing myfile.osm I got the following error: Setting up table: ...
1
vote
1answer
165 views

In osm2pgsql how is the planet_osm_roads table populated?

I'm using osm2pgsql to populate a North America OSM database from planet.osm. I like how simple the resulting PostGIS schema is, but I'm a bit confused by its contents. I have the two tables ...
5
votes
1answer
93 views

What is the bare minimum data I would need to import from an OSM data file in order to geocode an address?

I'm using osm2pgsql to import an extract of OpenStreetMap's data so I can geocode an address to a lat/lng. But I'm new to OSM and mapping so I'm having trouble figuring out what data is relevant and ...
3
votes
1answer
105 views

How to draw parallel or curved labels for OSM data in QGIS?

I'm trying to recreate a Google style map using OpenStreetMap data and QGIS. I've been following underdarks many wonderful guides but am getting stuck at the labels. The OSM data was taken from ...
0
votes
0answers
104 views

Can Nominatim use another OSM importer?

Nominatim comes with osm2pgsql by default and uses it to import the osm files during the initial set up (utils/setup.php). Problem: I am experiencing problems with importing us-northeast.osm.pbf ...
0
votes
1answer
142 views

osm2pgsql import crashed!

I am currently importing a bz2 country file into PostgreSQL 9.1 database for Nominatim 2 using its setup.php that runs osm2pgsql. After processing the nodes. it seems to be stuck at a certain spot ...
0
votes
0answers
82 views

Nominatim (postgresql) import problem: unable to start pgsql

While importing the planet files into Nominatim, I encounter the following error below. The import command used is ./setup.php --osm-file us-northeast.osm.pbf --all I have been following the ...
2
votes
1answer
226 views

Problem processing OSM file with osm2pgsql

I have an OSM file and when I want to import it in my PostGIS base using osm2pgsql, I get the following error: Processing: Node(130k 8.7k/s) Way(0k 0.00k/s) Relation(0 0.00/s)Assertion failed: ...
9
votes
1answer
432 views

Conflate (merge) private shapefile data with OSM data

Background Downloaded Alberta OSM data from Geofabrik and have it running on a private Linux server using PostgreSQL 9.1, PostGIS 2.0, Mapnik 2.1.0, osm2pgsql, Apache 2, mod_tile, renderd, and ...
4
votes
4answers
847 views

OSM To Postgis & WGS84 problems

I’m trying to import OpenStreetMap (OSM) data into postGIS it doesn’t appear to be working in that features do not appear to be in the correct place.. Using the QGIS OSM add in and a coastal shape ...