Tagged Questions

1
vote
2answers
34 views

PostgreSQL error: subquery must return only one column

Using PostgreSQL-9.1 and PostGIS 2.0.1, when doing a SELECT query containing a sub-query that returns multiple columns, I am getting the error subquery must return only one column. How can the ...
0
votes
1answer
346 views

Storing PostgreSQL/PostGIS “geometry(MultiPolygon)” data type in java

I need to store PostgreSQL's geometry(MultiPolygon) type variable into a java variable this is because im trying to add the geometry column to a non-spatial table for querying a map using mapserver i ...
0
votes
1answer
241 views

postGIS for latitude and longitude

I created a table named zipcode with the following columns Id State Zip Latitude Longitude column1 column2 Columns named column1 and column2 are the 2 geometry columns i have created to store the ...
1
vote
1answer
116 views

Using PostGIS for location based data

I have a table in postgresql 9.2 that stores the latitude and longitude of locations as integer values. I intend to do something like when a user searches for a location, he also gets information on ...
-1
votes
1answer
121 views

Converting a SQL Server 2008 R2 database to PostGIS

I have a database in SQL Server 2008 R2 which needs to be converted into a PostGIS one. I have PostGres 9.2 installed with the PostGIS extension. What should be my next step to convert my existing ...
0
votes
1answer
209 views

Unit of return value of ST_Distance

I need to calculate the distance between all buildings and all hospitals in a map imported from OSM. I use following query: SELECT building_id, hospital_id, ST_Distance(building_centroid, ...
0
votes
1answer
506 views

Importing OpenStreetMap data into PostgreSQL database

I'm trying to import one of the following OpenStreetMap maps 1, 2, 3 into a PostgreSQL database using calls like call osmosis.bat --read-xml file="map.osm" --write-pgsimp user="ccp-web-user" ...
1
vote
1answer
840 views

osm2pgsql: Function AddGeometryColumn doesn't exist

I want to import OSM file into my PostgreSQL database (Windows, Postgres Version 9.2) using the tool Osm2pgsql. When I run following command osm2pgsql.exe --create -d mydb artyom.xml -U myuser -W ...