A version of the PostGIS open source spatial database

learn more… | top users | synonyms

1
vote
2answers
261 views

Function for Selecting Points in a Polygon

I've been banging on this for a few hours, but since I'm relatively new to PostgreSQL and PostGIS, I can't find the solution. I'm trying to create a stored procedure (function) which will return all ...
2
votes
1answer
351 views

generate height data from DTED maps

I have 16 DTED maps of (1 degree x 1 degree). I have to generate combined height matrix of maximum 4 (1 degree x 1 degree) DTED maps in my C++ application. Can someone suggest to me which open source ...
0
votes
1answer
40 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
214 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
426 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: ...
0
votes
0answers
15 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
32 views

Best way to filter points dynamically in PostGIS?

I have a table with geom column (all SRID=4326) with a gist index on it a dynamically generated grid of points I generate a raster heatmap. I want to find each geom in a bounding box around ...
0
votes
0answers
87 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 ...
0
votes
0answers
34 views

drupal cartaro ask me postgis 1.5

I would install drupal cartaro, I have a host service with postgis 2.0 and a service with geoserver installed. Cartaro recommend me to use postgis 1.5. Do you know some solution for to use pg 2.0? I ...
0
votes
0answers
28 views

Can driving_distance return all sets of distance from different starting points at one time?

I'm now using the extension of pgRouting, driving_distance, to search for the distance along the river system: In the figure, the starting point is 3, but I want to get the distance starting from ...
0
votes
0answers
38 views

driving_distance does not return all sets of distance

As title, I am working with pgRouting, trying to get the distance matrix along the river system. I use driving_distance function and it seems like I am getting what I want: But when I check the ...