2
votes
1answer
106 views

Retrieve geographic coordinates from OSM imported data

We have just finished importing OSM data into our PostGIS (Postgresql) database. And we are having difficulty understanding the geometry of various shapes imported. We run a query to retrieve the ...
2
votes
1answer
1k views

Import database (Excel file) into PostgreSQL [closed]

In order to import my database (excel file) into PostgreSQL, I converted the Excel file into ".csv" file. Then, I used the application: "Import Data For PostgreSQL" and I could import my database but ...
0
votes
1answer
676 views

Could not add the specified data object to the map

I have registered the postgresql database with arcgis desktop 10.1. In ArcMap, When I try to drag and drop one of the tables to the map I get this error: Could not add the specified data object to ...
3
votes
1answer
416 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
196 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
0answers
92 views

I've converted a kml to shp and want to import it to pgsql database, but no geometry column [closed]

As the title explains, I have a shapefile whose attribute table has no geometry column specifying the location of points. Rendered in QGIS, it looks fine, so the geometry data is obviously there. ...
3
votes
2answers
3k views

Import Shapefile to Postgres

I am trying to import a shapefile to Postgres using the following: shp2pgsql c:\location\water_areas.shp water > water.sql I am receiving the following message: c:\location\water_areas.shp: ...