0
votes
2answers
151 views

Update database via osmosis and osm2pgsql too slow

I got a box with the current hardware config: CPU: Intel Xeon E3-1220 V2 3.1 GHz RAM: 10gb Hard Disk: Western Digital WD10EZRX SATA Hard Drive OS: Centos 6.5 64 bit DB: PostgreSQL 9.3.2 and ...
1
vote
1answer
55 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 ...
0
votes
2answers
51 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 ...
3
votes
1answer
481 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
305 views

Improve database performance for geospatial

I have a database with osm data imported with osmosis tool. I want to search for the nearest POIs from a given point. For this purpose, I perform this query: select id from nodes where ...
2
votes
0answers
221 views

OSM Database created: now what happens?

I imported an OSM file into a Postgres DB using the Osmosis tool. Now, I need to extract some data but I can't find any schema description (I'm really a newbie in GIS). Where can I find it? Do you ...