[postgis-users] View area

[Sean M. Montague]

For some reason this returns as SVG a bunch of points.  My whole
statement is below.

SELECT AsSVG(intersection(the_geom, setSRID('BOX3D(xxx yyy, xxx
yyy)'::box3d,42102)),0,8)
As the_geom From usa
WHERE the_geom && setSRID('BOX3D(xxx yyy, xxx yyy)'::box3d,42102);


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
strk at refractions.net
Sent: Tuesday, February 15, 2005 10:52 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] View area

Intersection should do.
Don't use GeomFromText() with anything but OGC Well Known Text format.

Try something like this:

 SELECT AsSVG(intersection(the_geom,
setSRID('BOX3D(...)'::box3d,42102)))
 WHERE the_geom && setSRID('BOX3D(...)'::box3d,42102);

--strk;

On Tue, Feb 15, 2005 at 10:47:32AM -0700, Sean M. Montague wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users