Converts OpenStreetMap data to a PostgreSQL / PostGIS database

learn more… | top users | synonyms (1)

0
votes
0answers
16 views

How to ensure that Tilemill interprets my postgis query as intended?

One of my layers (a postgis query from my local osm2pgsql database) is being translated incorrectly in Tilemill. The query is attempting to select the way, the area of the polygon, and the sport=* ...
3
votes
3answers
225 views

Why is sum of st_length() of segments 20% too big?

I'm running a query to return the total length of some bike paths, from OpenStreetMap. Compared to the known actual length of these paths, they're all a bit too big - something like 10-30%. I know it ...
1
vote
2answers
39 views

osm2pgsql: modifing the default.style - newly added columns are empty

I would like to import a osm-db (from planet) with the "name_de" and "source" column. So I added/changed those lines in the default.style: node,way source text linear node,way ...
1
vote
2answers
33 views

Convert OSM File to get addresses using Osm2pgsql

I am working to covert OSM File to get all building's informations in the city. I am using osm2pgsql package to transform the data. Now I am confused as I have 5 tables : - planet_osm_point ...
1
vote
2answers
42 views

Getting OSM maps in Equirectangular Projection via osm2pgsql

I'm trying to import some OSM data into psql as equirectangular projection using osm2pgsql with the following command: osm2pgsql -c -d osm -S /usr/local/share/osm2pgsql/default.style -l ...
3
votes
3answers
190 views

osm2pgsql --hstore

I'm working with postgreSQL 8.$ and PostGIS and I need to import osm file to database. I tried it with utility osm2pgsql, but I have problem with hstore extension. Does anyone know how to solve this ...
3
votes
2answers
898 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
264 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 ...
1
vote
1answer
29 views

Osm2pgsql crashed on import. Can I continue with what has been imported so far?

I recently imported the osm planet file using osm2pgsql. The process crashed (hung my whole box) when creating the geometry indices and other indices on the tables. Scouring through the source code, ...
1
vote
1answer
242 views

Using osm2pgsql data with pgrouting 2.0

I have successfully manage to make the workshop from of pgrouting (wrote for v1) with pgrouting v2. Now I want to use pgrouting 2 on my postgis database created with osm2pgsql. The problem is first ...
2
votes
2answers
41 views

How to obtain timestamp and user id from .osm file in PostGIS enabled Postgres database

At present, osm2pgsql seems to ignore the timestamp and user id of the elements, a serious drawback for some applications. According to a bug report this is not solved by the addition of the ...
0
votes
0answers
24 views

Postgis and osm2pgsql: find all cities that belong to selected state [duplicate]

I'm pretty new to postgis, so I don't quite understand it's mechanisms yet. My task is to build database with relations: +---------+ +------------+ +----------+ | country | | adm_unit ...
0
votes
0answers
16 views

Transforming multiple LineStrings to shape for ST_Contains

I want to find cities, villages etc inside each region of Poland. For most of them querying something like this is enough: ... AND ST_Contains((SELECT way FROM planet_osm_polygon WHERE osm_id = ...
1
vote
1answer
33 views

How to make osm2pgsql import a tag?

I loaded OSM data into PostgeSQL with Osmosis&Osm2PgSQL, and see many tags are missing. I need to make it import lanes tag. How can I make it save this tag too? edit: my solution was to copy ...
1
vote
1answer
29 views

ST_AsLatLonText returns wrong data

I want to list all cities in lubelskie vovoidenship, which is relation 130919. I also want to get latLong data for each city. To perform this I do: SELECT name, ST_AsLatLonText(way), place ...
0
votes
2answers
49 views

Osm2pgsql style file question

I have a question about the style files used for osm2pgsql. These files have a structure as follows: # OsmType Tag DataType Flags node,way access text linear node,way ...
1
vote
1answer
118 views

How can I style OSM data in geoserver? [closed]

I've been trying to style OSM data imported using osm2pgsql and served through geoserver. The tables generated by osm2pgsql are: planet_osm_line, planet_osm_point, planet_osm_polygon, apart from the ...
0
votes
0answers
26 views

osm2pgsql ,AddGeometryColumn : Could not choose a best candidate function

I tried to load osm data into postgresql database using osm2pgsql, but an error occured : SELECT AddGeometryColumn('planet_osm_point', 'way', 4326, 'P... HINT: Could not choose a best candidate ...
3
votes
1answer
363 views

osm2pgsql loses connection at end of import for large PBF, north-america-latest.osm.pbf

I just wanted to check and see if anybody else out there encountered this issue before I started diving into the code. I'm using osm2pgsql to import OSM data into my Postgres database. I encounter the ...
1
vote
2answers
451 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 ...
1
vote
1answer
86 views

Publishing OSM data in GeoServer that has been imported into PostGIS

I'm trying to publish data on GeoServer. I'm using Postgres/PostGIS and I've used osm2pgsql to load the data into the database. I've configured a store correctly (I can see the tables from the ...
0
votes
1answer
160 views

postgis and osm2pgsql: authentication failed

Id like to import osm into my postgis to use it with qgis. I followed exactly these instructions: http://wiki.openstreetmap.org/wiki/PostGIS/Installation At step #Activate_PostGIS: psql ...
0
votes
1answer
39 views

Osmosis, Save to different schema

Does anyone know how to use osmosis to save to a different schema? I used the pgsnapshot_schema_0.6.sql to create a blank data table, but it always creates it in the public schema. I need to create ...
1
vote
1answer
70 views

Import OSM data into ArcSDE using osm2pgsql

I am trying to import OpenStreetMap (osm) data into a PostGRES database using OSM2PGSQL, and then I need to convert that data so I can use it in ArcSDE/ArcGIS Desktop 10.2. Here is what I do: ...
1
vote
0answers
96 views

identify subgraphs within planet_osm_line table

I want to identify subgraphs within the planet_osm_line table of the osm2pgsql-schema. those subgraphs are classified by certain tags i want to check. My first attempt was to do this recursively with ...
1
vote
0answers
85 views

Limit data imported into PostGIS database?

I am building a web application in which members will be able to find other members in their area. This is your typical "nearest neighbor" search which I'll perform using their latitude and ...
4
votes
2answers
203 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 been a solution posted: Download the OSM files (in .osm ...
10
votes
1answer
684 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 ...
3
votes
1answer
174 views

osm2pgsql: Import data in custom projection

I have osm-file and I want to import it to the postgresql via osm2pgsql with custom projection EPSG:20022. I look to the help and found out any keys like -E EPSG: but when I try to do with it I get ...
3
votes
1answer
179 views

Import of OSM data into PostgreSQL using osm2pgsql: which formats are supported?

I followed a tutorial to install a PostgreSQL server on my Mac OS X Mavericks, and to import some OSM data with the osm2pgsql converter ...
3
votes
1answer
171 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
3answers
79 views

GeoWebCache: Is there a way to see cache size per zoom level?

I seeded a layer group (of data imported from OpenStreetMaps via osm2pgsql) from levels 0 to 15 (PNG; EPSG:900913), it completed successfully, and now I am seeding again only for levels 16 and 17. I ...
0
votes
1answer
160 views

Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type

After import some data from OSM file into Postgre, the coordinates numbers are too big and having trouble to cast to Geography: Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY ...
2
votes
1answer
508 views

Problem with loading OSM planet into PostgreSQL

I try download OSM planet into PostgreSQL database. I do all steps from instruction http://switch2osm.org/serving-tiles/manually-building-a-tile-server-12-04/ I also modify string "kernel.shmmax" ...
4
votes
1answer
400 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): ...
2
votes
1answer
99 views

What the difference: mapnik and mapnik2?

I use Ubuntu 12.04 LTC, postgres 9.1, postgis 2.0. I install mapnik. $ sudo add-apt-repository ppa:mapnik/nightly-trunk $ sudo apt-get update $ sudo apt-get install libmapnik mapnik-utils ...
2
votes
1answer
468 views

Where can I download the last default.style for osm2pgsql?

Where can I download the last default.style for osm2pgsql? I get http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/default.style - this directory does not exist when I try to download ...
3
votes
1answer
88 views

Strange exposure of a PostGIS layer in QGIS after importing OSM data into a database

I've imported a osm layer into my postgres/postgis database. osm2pqsql -E 3857 -c -S /usr/share/osm2pgsql/default.style -H localhost -W -d landslide -U postgres oberpfalz-latest.osm.bz2 During the ...
2
votes
1answer
84 views

Postgis and python parameterised queries

I have a python script that i am trying to run in order to dump a postgres table and I noticed there is a pgsql2shp command in bash to perform this easily but I would like to incoperate the same ...
1
vote
2answers
119 views

Cutting OSM roads in sections using PostGis

I'm a newby in postgis. I define a section by a part of a road that has no intersection. See image bellow: I'd like to extract all sections from all the roads of my postgis database. This gis ...
1
vote
0answers
203 views

Adding osm data to Postgres via Osm2pgsql : duplicate key value violates unique constraint

I'm trying to import osm global world data into a database created in postgreSQL but after a while of processing, I've got this error : Reading in file: E:\planet-latest.osm\planet-latest.osm ...
0
votes
0answers
47 views

OSMOSIS tag filtering “OR” statement

I want to import only all ways with a specific tag OR all ways used by relations having a specific tag. With the following command, I only get ways with the tag and the relations but not the ways ...
0
votes
0answers
54 views

Easy way to set up a blank PostGIS database for OSM2pgsql?

When you install PostGIS you get one database 'gis' created for free. But soon I want another, then another. So far, the way I do this is by messing around with "CREATE DATABASE ... WITH TEMPLATE"... ...
1
vote
2answers
479 views

OSM data on MapServer

I'm making an evaluation to replace the TomTom commercial Database (ex TeleAtlas) with Open Street Map data. What I need to do is use the street map as a base layer for my WebGIS applications. I use ...
2
votes
2answers
216 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
0answers
19 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 ...
0
votes
1answer
362 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
1answer
240 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 ...
5
votes
1answer
140 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 ...
0
votes
2answers
1k 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 ...