<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16625"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT face=Calibri>Rick - thanks for answering.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>I am in the process of learning a little
XML.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>I understood that a query such as 'Select
AsSvg(the_geom) from p_id.image' went to Postgis and the return (the geometry)
comes back.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>I think you are saying that this is also in the xml path
and xml interprets this expression differently than 'Select the_geom from
p_id.image'</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>Bob</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV style="FONT: 10pt Tahoma">
<DIV><BR></DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A
title="mailto:graham.rick@gmail.com
CTRL + Click to follow link"
href="mailto:graham.rick@gmail.com">Rick</A> </DIV>
<DIV><B>Sent:</B> Monday, September 13, 2010 9:08 AM</DIV>
<DIV><B>To:</B> <A
title="mailto:postgis-users@postgis.refractions.net
CTRL + Click to follow link"
href="mailto:postgis-users@postgis.refractions.net">PostGIS Users Discussion</A>
</DIV>
<DIV><B>Subject:</B> Re: [postgis-users] AsSvg</DIV></DIV></DIV>
<DIV><BR></DIV><BR>Not sure what you are asking, but I'll take a stab in the
dark.<BR><BR>When you retrieve geometry as SVG what you get back is the contents
of a path attribute node.<BR><BR>So if an SVG path element is written <path
d="X"/> the result of the query is "X", or the value of the 'd' (data)
attribute, not an XML element, and certainly not a valid SVG document. You
have to construct these yourself.<BR><BR>
<DIV class=gmail_quote>On Mon, Sep 13, 2010 at 12:00 PM, Bob Pawley <SPAN
dir=ltr><<A title="mailto:rjpawley@shaw.ca
CTRL + Click to follow link"
href="mailto:rjpawley@shaw.ca">rjpawley@shaw.ca</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
name="Compose message area">
<DIV><FONT face=Calibri>Hi</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>I may be on the wrong list but xml and Delphi guys
that know Postgis seem to be few and far between.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>I`m using the following to display the
binary data on a memo component as text.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri> PSQLQUery1.SQL.Add('Select the_geom from
p_id.image');<BR> PSQLQUery1.SQL.Add ('where
p_id.image.p_id_id = ''1534''');<BR>
PSQLQUery1.Open;</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>This works fine.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>When I change it to select AsSvg the xml
consider assvg as another node and the geometry data does not
appear.</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri> PSQLQUery1.SQL.Add('Select AsSvg(the_geom) from
p_id.image');<BR> PSQLQUery1.SQL.Add ('where
p_id.image.p_id_id = ''1534''');<BR>
PSQLQUery1.Open;</FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV>
<DIV><FONT face=Calibri>If any one can suggest a
possible reason for this behavior It would be
appreciated. </FONT></DIV>
<DIV><FONT face=Calibri></FONT> </DIV><FONT color=#888888>
<DIV><FONT
face=Calibri>Bob</FONT></DIV></FONT></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>Cheers!<BR>Rick<BR>Eeny, Meeny, Jelly Beanie, the spirits
are about to speak!<BR> -- Bullwinkle
Moose<BR><BR>
<P>
<HR>
<P></P>_______________________________________________<BR>postgis-users mailing
list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></BODY></HTML>