[postgis-users] View area

[Sean M. Montague]

I sent this in response to the wrong post.

The select statement below is close to what I'm looking for.  I don't
know if I'm imagining this, but I thought it was possible to define a
box and extract just what is inside that box, clipping all that lies
outside, including polygons.  Is this possible using a different sql
statement? 

SELECT AsSVG(the_geom,0,8) as the_geom FROM usa WHERE the_geom &&
GeomFromText('BOX3D(-2243528 2679134,-1689106 2002338)'::box3d,42102);

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Sean
M. Montague
Sent: Monday, February 14, 2005 5:42 PM
To: PostGIS Users Discussion
Subject: [postgis-users] View area

Is there a way to extract data based on viewable area coordinates.  For
instance, can I extract roads that are only within my viewer area, or
part of a polygon, but not the whole thing?  I've tinkered with
intersection, but have failed to accomplish anything.  Thanks.

Sean
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users