<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2523" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff size=2>Hi
Danny,</FONT></SPAN></DIV>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff size=2>Hmmm,
looks like something isn't quite right somewhere.....</FONT></SPAN></DIV>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff
size=2>dcmms=# select
postgis_version();<BR>
postgis_version<BR>---------------------------------------<BR> 1.0
USE_GEOS=1 USE_PROJ=1 USE_STATS=1<BR>(1 row)</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff
size=2>dcmms=# select
GeomFromWKB('010300000001000000050000003A6484B530A012418C2BD61<BR>7C48413A6484B520A112418C2BD617CF7C48413A6484B520A112418C2BD617ED7C48413A6484B<BR>A012418C2BD617ED7C48413A6484B530A012418C2BD617CF7C4841');<BR>ERROR:
parse error - invalid geometry<BR>dcmms=# select
GeomFromEWKB('010300000001000000050000003A6484B530A012418C2BD6<BR>F7C48413A6484B520A112418C2BD617CF7C48413A6484B520A112418C2BD617ED7C48413A6484<BR>0A012418C2BD617ED7C48413A6484B530A012418C2BD617CF7C4841');<BR>ERROR:
parse error - invalid geometry<BR></FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=331582209-21012005>Going
back to 0.9.1, I find that the AsText representation of your WKB geometry
is:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=331582209-21012005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=331582209-21012005>POLYGON((305164.177262846
3209630.18622345,30522<BR>77262846 3209630.18622345,305224.177262846
3209690.18622345,305164.177262846<BR>9690.18622345,305164.177262846
3209630.18622345))</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=331582209-21012005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=331582209-21012005>However, if I then go back to 1.0 and insert this as a
LWGEOM:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=331582209-21012005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=331582209-21012005>dcmms=# select GeomFromText('POLYGON((305164.177262846
3209630.18622345,30522<BR>77262846 3209630.18622345,305224.177262846
3209690.18622345,305164.177262846<BR>9690.18622345,305164.177262846
3209630.18622345))');<FONT face=Arial color=#0000ff size=2>
<DIV><BR> geomfromtext</DIV>
<DIV> </DIV>
<DIV>--------------------------------------------------------------------------------<BR>--------------------------------------------------------------------------------<BR>----------------------------<BR> 01030000000100000005000000396484B530A01241862BD617CF7C4841396484B520A11241862BD<BR>617CF7C4841396484B520A11241862BD617ED7C4841396484B530A01241862BD617ED7C484139648<BR>4B530A01241862BD617CF7C4841<BR>(1
row)</DIV>
<DIV> </DIV>
<DIV>dcmms=#</FONT></DIV></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff
size=2>....which is different from the original WKB you gave at the top(!).
Strk, can you confirm if this is a bug in 1.0-rc1?</FONT></SPAN></DIV>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff size=2>Kind
regards,</FONT></SPAN></DIV>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=331582209-21012005><FONT face=Arial color=#0000ff
size=2>Mark.</FONT></SPAN></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>------------------------<BR>WebBased Ltd<BR>South West
Technology Centre<BR>Tamar Science Park<BR>Plymouth<BR>PL6 8BT<BR><BR>T: +44
(0)1752 791021<BR>F: +44 (0)1752 791023<BR>W: <A
href="http://www.webbased.co.uk/">http://www.webbased.co.uk</A><BR> </FONT>
</P>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>postgis@dannykent.com<BR><B>Sent:</B> 20 January 2005 18:04<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
Problem with PostGIS 1.0.0 RC1<BR><BR></FONT></DIV>I have been using PostGIS
0.9.1 for awhile and developed some software for our spatial intelligence
applications. It works fine under 0.9, but when I run the following query on
1.0.0 I get a "parse error - invalid geometry"<BR><BR>The query I am running
is:<BR>select asbinary(intersection(rddfpolygon.geom,
GeomFromWKB('010300000001000000050000003A6484B530A012418C2BD617CF7C48413A6484B520A112418C2BD617CF7C48413A6484B520A112418C2BD617ED7C48413A6484B530A012418C2BD617ED7C48413A6484B530A012418C2BD617CF7C4841')));<BR><BR>After
a little more digging I figured the problem is in my WKB String. It hasn't
changed in my code at all. Is there something in the lwgeom I need to be aware
of?<BR><BR>Thanks!<BR>~Danny Kent<BR>University of
Florida<BR></BLOCKQUOTE></BODY></HTML>