<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16671"></HEAD>
<BODY bgColor=#ffffff text=#000000>
<DIV dir=ltr align=left><SPAN class=703564916-31102010><FONT color=#0000ff
size=2 face=Arial>Mike,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=703564916-31102010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=703564916-31102010><FONT color=#0000ff
size=2 face=Arial>Thanks for the tip. Is there any way to render the
Z coordinates aside from the info panel. We don't have too many 3 D
examples in the book (and much of the book is already finalized), but in the
PostGIS Raster chapter we are in the middle of rewriting we do have an
example that converts a 2-D linestring into a 3 D linestring by intersecting
with Raster elevation data. Would be nice to have a 3D representation of
it.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=703564916-31102010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=703564916-31102010><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=703564916-31102010><FONT color=#0000ff
size=2 face=Arial>Leo and Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=703564916-31102010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Michaël Michaud<BR><B>Sent:</B> Sunday, October 31, 2010 11:52
AM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users]
ST_AsBinary<BR></FONT><BR></DIV>
<DIV></DIV>Hi,<BR><BR>Thanks for the link. Very interesting faq indeed.<BR>If
you think it can be useful for the faq or for your book, I suggest to add
examples using As_EWKB instead of As_Binary to get data from PostGIS with
OpenJUMP as it seems to be the way to go not to loose z
ordinates.<BR><BR>Michaël<BR><BR>Le 31/10/2010 04:03, Paragon Corporation a
écrit :
<BLOCKQUOTE cite=mid:63391C9307A84656A3CE76DB9487C12B@J type="cite">
<META name=GENERATOR content="MSHTML 8.00.7600.16671">
<DIV dir=ltr align=left><SPAN class=723230203-31102010><FONT color=#0000ff
size=2 face=Arial>Correct. In fact we even has this as our #1 FAQ for
1.5</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=723230203-31102010></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=723230203-31102010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.org/documentation/manual-1.5SVN/ch03.html#id2872420"
moz-do-not-send="true">http://www.postgis.org/documentation/manual-1.5SVN/ch03.html#id2872420</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=723230203-31102010></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=723230203-31102010><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=723230203-31102010><FONT color=#0000ff
size=2 face=Arial>Regina and Leo</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=723230203-31102010><FONT color=#0000ff
size=2 face=Arial><A href="http://www.postgis.us"
moz-do-not-send="true">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=723230203-31102010></SPAN> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> <A class=moz-txt-link-abbreviated
href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A>
[<A class=moz-txt-link-freetext
href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</A>]
<B>On Behalf Of </B>Michaël Michaud<BR><B>Sent:</B> Saturday, October 30, 2010
4:54 PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re:
[postgis-users] ST_AsBinary<BR></FONT><BR></DIV>Hi Ravi,<BR><BR>Did you try to
update your jdbc driver ?<BR><BR>Again, there is a link here to download it
:<BR><A class=moz-txt-link-freetext
href="http://jdbc.postgresql.org/download.html"
moz-do-not-send="true">http://jdbc.postgresql.org/download.html</A><BR><BR>You
should download <A
href="http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar"
moz-do-not-send="true">http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc3.jar</A><BR>Then,
you have to go in your OpenJUMP intallation directory and replace
<BR>postgresql-8.3-603.jdbc3.jar<BR>by<BR>postgresql-9.0-801.jdbc3.jar<BR><BR>If
you're using java6, you should be able to use <A
href="http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar"
moz-do-not-send="true">9.0-801 JDBC 4</A> instead of <A
href="http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar"
moz-do-not-send="true">9.0-801 JDBC 3</A><BR><BR>Note that I haven't yet
install postgresql 9.0 to check everything is fine, but it comes from a
discussion I had with postgis developpers that something changed in the
postgresql 9.0 byte array format, which is the reason why a new driver is
required.<BR><BR>Hope that helps<BR><BR>Michaël<BR><BR>Le 30/10/2010 21:06,
Ravi a écrit :
<BLOCKQUOTE cite=mid:47332.33973.qm@web30107.mail.mud.yahoo.com type="cite">
<TABLE border=0 cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD vAlign=top>ST_AsBinary<BR>Other that OpenJUMP, suggest which
FOSS4G tool can be used.<BR>Finding some road blocks using<BR>PostGIS
and Seeing it on OpenJUMP.<BR>Ravi Kumar<BR></TD></TR></TBODY></TABLE><BR><PRE wrap=""><FIELDSET class=mimeAttachmentHeader></FIELDSET>
_______________________________________________
postgis-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:postgis-users@postgis.refractions.net" moz-do-not-send="true">postgis-users@postgis.refractions.net</A>
<A class=moz-txt-link-freetext href="http://postgis.refractions.net/mailman/listinfo/postgis-users" moz-do-not-send="true">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
</PRE></BLOCKQUOTE><BR><PRE wrap=""><FIELDSET class=mimeAttachmentHeader></FIELDSET>
_______________________________________________
postgis-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
<A class=moz-txt-link-freetext href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
</PRE></BLOCKQUOTE><BR></BODY></HTML>