1
vote
1answer
33 views

Will ogr2ogr correctly merge features from several OSM files to resulting set

In GDAL >= 1.10, ogr2ogr contains osm driver I want to try this feature and migrate OSM to PostGIS (I'm aware of osm2pqsql existence) I have several relatively small OSM files and wonder if ...
2
votes
2answers
103 views

Extract a PostGIS dump from OSM with a particular tag

I'm new to OpenStreetMap. I want to extract all restaurants from Switzerland with their capacity if available. I am using osmosis. I tried: osmosis --read-pbf file=switzerland.pbf --tf accept-nodes ...
2
votes
2answers
72 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
2answers
137 views

How to get the linestring of a way in postgis with pg_snapshot schema

I have loaded some data from openstreetmap using osmosis and its pg_snapshot schema. This results in a table wayswhich contains a list of nodesreferenced by their ids: select w.nodes from ways as w ...
1
vote
1answer
357 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
1answer
512 views

How to import Osmosis DB schemas into PostGIS DB

I'm trying to import Osmosis schema into into a PostGIS DB. I followed this article. I created a DB: createdb osm_schema Then I executed the following command: osmosis --write-pgsql ...
1
vote
1answer
164 views

Looking for a template project for OSM data

I have a PostGIS 2 database filled with OSM data for my country via Osmosis. Is there perhaps a template/project (!styling) for QGIS i could download, where i would simply change the provider of data ...
12
votes
3answers
8k views

Select bounding box using postgis

I want to create a query to select all ways and their nodes that exist within a bounding box using postGIS. The bounding box shall includes all details as osmosis "--bounding-box" command will ...
6
votes
3answers
1k views

Large Open Street Map OSM file to Shapefile. Is there any hope for 32-bit FME?

I have a large OSM XML file (around 8 GB) that I was hoping to process in FME. I have a workbench that I previously used to process smaller files (500 MB) into feature type-specific Shapefiles (e.g. ...