[postgis-users] postgis newbie AsSVG question

Tue Feb 15 09:36:35 PST 2005

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: Tuesday, February 15, 2005 9:57 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] postgis newbie AsSVG question

Whatever came with the postgreSQL 8.0.1 windows installer.  I'm assuming the latest version.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of klaus Förster
Sent: Tuesday, February 15, 2005 9:56 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] postgis newbie AsSVG question

what version of postgis are you running?

Sean M. Montague wrote:
> Thanks.  I was playing around with it and realized that relative will
> draw states from my map of the US all over the place, versus drawing
> them in their proper location.
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> TECHER Jean David
> Sent: Tuesday, February 15, 2005 1:33 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] postgis newbie AsSVG question
> 
> Hi Sean,
> 
> I think when U use AsSVG function U have to know that for the 2nd
> argument
> you asked :
> 
>  m -- Relative "Move To" command. Starts a new subpath at the given x,y
> coordinate. If a moveto is followed by multiple pairs of coordinates,
> the
> subsequent pairs are treated as implicit "Line To" commands.
> 
> M --  Absolute "Move To" command. Starts a new subpath at the given x,y
> coordinate. If a moveto is followed by multiple pairs of coordinates,
> the
> subsequent pairs are treated as implicit "Line To" commands.
> 
> l -- Relative "Line To" command. Draws a line from the current point to
> the
> given x,y coordinate, which becomes the new current point. A number of
> coordinate pairs can be specified to draw a polyline.
> 
> L -- Absolute "Line To" command. Draws a line from the current point to
> the
> given x,y coordinate, which becomes the new current point. A number of
> coordinate pairs can be specified to draw a polyline.
> 
> h -- Relative "Horizontal Line To" command. Draws a line from the
> current
> point (cpx, cpy) to (x, cpy). Multiple values can be provided.HAbsolute
> "Horizontal Line To" command. Draws a line from the current point (cpx,
> cpy)
> to (x, cpy).
> 
> v -- Relative "Vertical Line To" command. Draws a line from the current
> point (cpx, cpy) to (cpx, y). Multiple values can be provided.VAbsolute
> "Vertical Line To" command. Draws a line from the current point (cpx,
> cpy)
> to (cpx, y).
> 
> z -- Relative "Closepath" command. Causes an automatic straight line to
> be
> drawn from the current point to the initial point of the current
> subpath.
> 
> Z --  Absolute "Closepath" command. Causes an automatic straight line to
> be
> drawn from the current point to the initial point of the current
> subpath.
> ----------------------------------------------------------------
> TECHER Jean David
> Responsable Informatique 01MAP
> e-mail: davidtecher at yahoo.fr
> Bureau: 04 67 45 60 27
> Portable: 06 85 37 36 75
> site perso : http://techer.pascal.free.fr/postgis/
> site pro: http://www.01map.com/download/
> K-S:"The greatest trick the devil pulled off was convincing people he
> didn't
> exist"
> ------------------------------------------------------------
> ----- Original Message -----
> From: "Sean M. Montague" <smontague at ATSDenver.com>
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Sent: Monday, February 14, 2005 8:48 PM
> Subject: RE: [postgis-users] postgis newbie AsSVG question
> 
> 
> I've figured it, but could some tell me what the 2nd argument means by
> relative or absolute moves?  Also, is there a way to have it not output
> the points using exponents?  Thanks.
> 
> -----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 12:33 PM
> To: PostGIS Users Discussion
> Subject: [postgis-users] postgis newbie AsSVG question
> 
> I'm trying to get up to speed quickly with postgis and php, I'm moving
> away from MySQL, and I have an AsSVG question.  Below is a select
> statement I modified, and works, that returns a list of states.  I'm
> trying to export it AsSVG, but can't get it to work.  I've inserted it
> in several places with no luck.  Any insight would be most appreciated.
> 
> select the_geom from usa where the_geom &&
> GeomFromText('LINESTRING(-1862016 717184, -956486 935033)', 42102) and
> crosses(the_geom, GeomFromText('LINESTRING(-1862016 717184, -956486
> 935033)', 42102))
> 
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
          O-.
          /_ )
           | (U
klaus*   /|
         / /
         ~ ~
_______________________________________________
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