Tagged Questions
1
vote
2answers
24 views
Searching planet_osm_point by longitude and latitude
I used osm2pgsql to import data into my PostgreSQL database and it put gave me the following 4 tables, planet_osm_point, planet_osm_line, planet_osm_polygon and planet_osm_roads.
I have looked at ...
1
vote
2answers
44 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
192 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
904 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 ...
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 ...
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
73 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:
...
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 ...
3
votes
1answer
181 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
183 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
1answer
516 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"
...
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
0answers
206 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
1answer
365 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 ...
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 ...
3
votes
1answer
418 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
198 views
Is there a way to select what to import from planet-latest.osm.bz2 to database?
Is there a way to select what to import from planet-latest.osm.bz2 to database?
I want to do something like :
osm2pgsql ... --place='city' --admin_level='2'
My goal is to use only cities and ...
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: ...
