Converts OpenStreetMap data to a PostgreSQL / PostGIS database

learn more… | top users | synonyms (1)

1
vote
2answers
40 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 ...
1
vote
1answer
69 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
1answer
241 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 ...
0
votes
1answer
263 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
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
84 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 ...
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 ...
1
vote
0answers
131 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 ...
0
votes
0answers
11 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=* ...
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 = ...
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 ...
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"... ...