[postgis-users]

[strk]

Using GEOS you should be able to clip the polygon by whatever other 
geometry (in your case a box) using the intersect(geometry, geometry)
function. 

In order to use it you have to download GEOS and the latest postgis
from cvs.

--strk;

chrisf wrote:
> Hello
> 
> I am selecting a large polygon (coastline of Great Britain) from my
> geometry_field, using a clause like this
> 
> geometry_field &&GeometryFromText('BOX3D(189858.0 746543.0,195858.0
> 750543.0)'::box3d,-1)
> 
> This obviously retrieves the whole geometry where it overlaps with the
> coastline - a lot of coordinates ! Are there any functions or operators I
> can retrieve so that this polygon is clipped to my box and yet retain the
> polygon ?
> 
> Thanks
> 
> Chris
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
pallamondo.net  <-- take a look !