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 ...
1
vote
1answer
31 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
2answers
34 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 ...
2
votes
2answers
43 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 ...
1
vote
2answers
40 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 ...
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
35 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
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 ...
1
vote
1answer
131 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
2answers
50 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
95 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
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
71 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
87 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 ...
3
votes
1answer
178 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
181 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 ...
2
votes
3answers
82 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 ...
2
votes
1answer
512 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" ...
3
votes
3answers
191 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
1answer
373 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
121 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
205 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 ...
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
483 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 ...
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 ...
3
votes
2answers
903 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 ...
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
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 ...
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 ...
2
votes
1answer
971 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
186 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 ...
4
votes
2answers
204 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 ...
5
votes
3answers
2k 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
2answers
452 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
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 ...
3
votes
1answer
143 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
1answer
274 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 ...
4
votes
1answer
394 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: ...
10
votes
1answer
686 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
1k 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 ...