A version of the PostGIS open source spatial database

learn more… | top users | synonyms

0
votes
1answer
45 views

Why can't I perform any operation over a 700MB MIF file containing 5 multipolygons? It takes forever

I'm trying to work with a MIF file containing 5 really big multipolygons, but every operation I try takes hours, or just crash because of memory issues. Mainly using ogr2ogr, to transform MIF file to ...
3
votes
0answers
327 views

Select features within a country or bounding box effectively using PostGIS

I imported the planet OSM file into a PostgreSQL 9.2/PostGIS 1.5 server using osm2pgsql. I now want to select certain map features which lie within the bounding box formed by a countries borders, e.g. ...
3
votes
0answers
497 views

How can I properly add PostGIS data into MapGuide Maestro?

I am having trouble connecting a PostGIS database to MapGuide Maestro. Actually, I have added the PostGIS data into Maestro, but when I click to validate the layer it shows an error message: ...
1
vote
0answers
13 views

PostGIS 1.5 libstdc++ error

After some package updates on my Debian machine all my database queries involving postgis functions or types are returning: Error message from server: ERROR: could not load library ...
0
votes
0answers
31 views

Can't get X coordinate of PointM in PostGIS

Here are two queries, and I can't understand how to filter points if st_x does not work in WHERE clause. select st_x(geom_merk), st_asewkt(geom_merk) from road_density limit 5; ...
0
votes
0answers
113 views

How can I ensure srid is properly set on Postgis when importing shapefile?

I am uploading a shapefile to Postgis via Geoserver rest api but I end up with querying issues especially with srid i.e "ERROR: XX000: Operation on two geometries with different SRIDs". The import has ...