Tagged Questions

An open source software that will let you perform Database GIS tasks

learn more… | top users | synonyms (1)

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
121 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 ...
0
votes
1answer
98 views

Unable to load Shapefile using pgShapeloader / shp2pgsql-gui (pgAdmin3's PostGIS Shapefile Import/Export Tool)

I am trying to load a shapefile (http://dds.cr.usgs.gov/pub/data/nationalatlas/statesp020_nt00032.tar.gz) into PostGIS 2.0.1 using pgAdmin3's PostGIS Shapefile Import/Export Tool. However its not ...
2
votes
0answers
112 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
155 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
0answers
100 views

Merging OSM files with OSMOSIS and import to Postgres with OSM2PGSQL

I have a problem merging and then importing two OSM files. I downloaded to distinct .osm-files from cloudmade. They are not sharing any geographical attribute (as the first is the country Monaco, the ...
2
votes
2answers
105 views

Applying osm2pgsql .diff patch in windows 7

When attempting to run osm2pgsql in command prompt, I ran into the password prompt as described here. This requires installing a patch. I'm unfamiliar on how to install a .diff patch on Windows 7. Do ...
0
votes
2answers
295 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
188 views

How to manage the osmosis command line?

This refer to this post : Read Here I'm in trouble when using osmosis command line to export data from planet-latest.osm.bz2 directly to osm2pgsql using some criteria to select what to transfer. I ...
4
votes
1answer
109 views

Is there a way to select what to import from planet-latest.osm.bz2 to database?

Is there a way to select what to import from planet-latest.osm.bz2 to database? I want to do something like : osm2pgsql ... --place='city' --admin_level='2' My goal is to use only cities and ...
1
vote
1answer
326 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
111 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
62 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
441 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: ...
3
votes
1answer
124 views

Error Installing libgdal1 Package

I'm trying to install the libgdal1 package on Ubuntu 12.04, but the apt is returing this error: dpkg: error processing /var/cache/apt/archives/libgdal1_1.9.1-2~precise4_amd64.deb (--unpack): ...
1
vote
1answer
156 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
92 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
101 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 ...
1
vote
0answers
30 views

Do any know another application like pgrouting? [duplicate]

Possible Duplicate: Alternatives to pgRouting I'm using pgrouting to generate routes over a network based on navteq information. It look like a good application but I would like to know if ...
1
vote
1answer
226 views

OSM Nominatim Server Installation Projection Error

Environment: Ubuntu 12.4 Postgresql 9.1.4 PostGIS 2.0.1 Latest Nominatim installation instructions posted at http://wiki.openstreetmap.org/wiki/Nominatim/Installation The installation is failing ...
0
votes
0answers
103 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
136 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
81 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 ...
1
vote
0answers
93 views

How to retrieve transport infrastructure data from google map?

I imported into postgis osm data using osm2pgsql. My objective was to get a database with roads elements for a specific region of Italy (i.e. traffic lights, driving directions and turning direction ...
2
votes
1answer
223 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: ...
1
vote
1answer
278 views

osm2pgsql import planet.osm.bz2 slowness

I am trying to import whole planet data to my i7 3770k + postgres on SSD + 16gb RAM in order to render my custom tiles. But the process is painfully slow and multi core is not helping (though you ...
9
votes
1answer
427 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 ...
1
vote
1answer
117 views

Geometry of edges created after using osm2pgsql

I used osm2pgsql to convert osm data to postgresql. Now I have a table with edges and they have geometry like multilinestring. I am not sure what is meant be geometry of an edge. An edge is supposed ...
4
votes
4answers
836 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 ...
2
votes
1answer
198 views

How can I put OSM data in a geography view in PostGIS?

I loaded the *.osm file to postgis with osm2pgsql. The data are stored in lat/long, so the same time I expect them to should be available in geography view, but they are not (only present in geometry ...