1
vote
2answers
74 views

Is it best to use multipolygon or polygon features for large intersect operations?

I have two large layers that I want to do intersect operations. One is municipalities and the other is landuse. Right now, the landuse layer is of MultiPolygon type that is, for the entire state, I ...
0
votes
1answer
207 views

Maximum size on the bounding box with ST_MakeEnvelope and && and geography column in PostGIS?

I've done quite a few google searches, but haven't managed to find anything that has helped me directly. I've got a few features in a PostGIS table with a geography column. The features are focused ...
0
votes
2answers
163 views

How to transform a PostGIS bounding box?

I need to query the bounding box of a table (in WGS 84, srid 4326), and transform it to Web Mercator to be consumed by an OpenLayers map. Currently, I am using this to retrieve the bounding box: ...
0
votes
1answer
246 views

GeoServer not reading bounding box from PostGIS geometry correctly

We are using GeoServer (tried on version 2.2 and 2.4) to render WMS with a PostGIS (version 1.5) data store. We set up the geometry field with all the appropriate constraints and validated/cleaned ...
0
votes
0answers
27 views

Bounding Boxes around nearby points [duplicate]

I've got a table with 200.000 points. My aim is to draw bounding boxes around points where this point have the same name and that are in a maximum distance of 500 meters to each other. I guess I can ...
0
votes
1answer
146 views

Circles created by points inside bounding box query - PostGIS

The table that i want to perform this query has 3 columns: id, the_geom and seen_count. The query i've been using to get points inside a bounding box is as follows: SELECT id, ST_AsGeoJSON(the_geom) ...
0
votes
1answer
198 views

It seems there is a bug in St_Clip function of PostGIS

The code I am using for clip feature is : raster ST_Clip(raster rast, geometry geom, double precision[] nodataval=NULL, boolean crop=true); I tried clip a shape depends on the polygon from the ...