<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html lang="en">
<head><meta http-equiv="Content-Type" content="text/html;">
<title>Scalix message content</title>
<style type="text/css">
<!--
.Normal { text-align: left; text-indent:0pt; margin-top:0pt; margin-bottom:0pt; font-family: Arial; font-size: 12pt; }
.Default_Paragraph_Font {font-family: Arial; color: Black; background-color: white ; font-size: 12pt; font-weight: normal; font-style: normal; font-variant: normal; vertical-align: normal; text-decoration: none;}
div.ltTOCtitle { font-family: Verdana; font-size: 8pt; font-weight: bold; text-align: center;}
div.ltTOCl1 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:32pt; text-indent:-32pt;}
div.ltTOCl2 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:40pt; text-indent:-32pt;}
div.ltTOCl3 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:48pt; text-indent:-32pt;}
div.ltTOCl4 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:56pt; text-indent:-32pt;}
div.ltTOCl5 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:64pt; text-indent:-32pt;}
div.ltTOCl6 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:72pt; text-indent:-32pt;}
-->
</style>
</head>
<body>
<div class="Normal"><span style='font-size: 10pt; '>strk</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>I attached the geometries in
my initial mail.</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Take a look at aline1.sql
and aline2.sql</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>regards</span><br><span style='font-size: 10pt; '>Horst</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>------------------------------------------------</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Dr. Horst
Düster</span><br><span style='font-size: 10pt; '>Stv. Amtschef /
GIS-Koordinator </span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Kanton
Solothurn</span><br><span style='font-size: 10pt; '>Bau- und
Justizdepartement</span><br><span style='font-size: 10pt; '>Amt für
Geoinformation</span><br><span style='font-size: 10pt; '>SO!GIS
Koordination</span><br><span style='font-size: 10pt; '>Rötistrasse
4</span><br><span style='font-size: 10pt; '>CH-4501 Solothurn</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Telefon ++41(0)32 627 25
32</span><br><span style='font-size: 10pt; '>Telefax ++41(0)32 627 22
14</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>mailto:horst.duester@bd.so.ch</span><br><span style='font-size: 10pt; '>http://www.agi.so.ch</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>-----Ursprüngliche
Nachricht-----</span><br><span style='font-size: 10pt; '>Von: strk
[mailto:strk@keybit.net]</span><br><span style='font-size: 10pt; '>Gesendet am:
Dienstag, 15. September 2009 10:27</span><br><span style='font-size: 10pt; '>An:
PostGIS Users Discussion</span><br><span style='font-size: 10pt; '>Betreff: Re:
[postgis-users] st_intersection error</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>On Tue, Sep 15, 2009 at
08:43:10AM +0200, Düster Horst
wrote:</span><br><span style='font-size: 10pt; '>> I do have 2 simple
linestrings which partly have the same geometry
(see</span><br><span style='font-size: 10pt; '>> attached dump and image). My
aim is to detect the common part of
these</span><br><span style='font-size: 10pt; '>> two linestrings with the
following query:</span><br><span style='font-size: 10pt; '>>
</span><br><span style='font-size: 10pt; '>> select
st_intersection(a.the_geom, b.the_geom),
a.myid</span><br><span style='font-size: 10pt; '>> from aline1,
aline2</span><br><span style='font-size: 10pt; '>>
</span><br><span style='font-size: 10pt; '>> But as the result I get a
geometrycollection with one POINT and
one</span><br><span style='font-size: 10pt; '>> LINESTING. I expected one
linestring. Is it a bug??</span><br><span style='font-size: 10pt; '>> I'll
appreciate any hints.</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Could be a bug, or a
dimensional collapse.</span><br><span style='font-size: 10pt; '>Try posting the
geometries, Martin Davis might have a
try</span><br><span style='font-size: 10pt; '>with
JTS.</span><br><span style='font-size: 10pt; '>Try also upgrading
GEOS.</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>--strk;</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>>
</span><br><span style='font-size: 10pt; '>> My
system:</span><br><span style='font-size: 10pt; '>> Postgis
1.4.0</span><br><span style='font-size: 10pt; '>> Geos
3.1.1</span><br><span style='font-size: 10pt; '>> Postgres
8.3.6</span><br><span style='font-size: 10pt; '>>
</span><br><span style='font-size: 10pt; '>> Best
regards</span><br><span style='font-size: 10pt; '>>
</span><br><span style='font-size: 10pt; '>> Dr. Horst
Düster</span><br><span style='font-size: 10pt; '>> Stv. Amtschef /
GIS-Koordinator </span><br><span style='font-size: 10pt; '>>
</span><br><span style='font-size: 10pt; '>> Kanton
Solothurn</span><br><span style='font-size: 10pt; '>> Bau- und
Justizdepartement</span><br><span style='font-size: 10pt; '>> Amt für
Geoinformation</span><br><span style='font-size: 10pt; '>> SO!GIS
Koordination</span><br><span style='font-size: 10pt; '>> Rötistrasse
4</span><br><span style='font-size: 10pt; '>> CH-4501
Solothurn</span><br><span style='font-size: 10pt; '>>
</span><br><span style='font-size: 10pt; '>> Telefon ++41(0)32 627 25
32</span><br><span style='font-size: 10pt; '>> Telefax ++41(0)32 627 22
14</span><br><span style='font-size: 10pt; '>>
</span><br><span style='font-size: 10pt; '>>
mailto:horst.duester@bd.so.ch</span><br><span style='font-size: 10pt; '>>
http://www.agi.so.ch</span><br><span style='font-size: 10pt; '>>
</span><br><span style='font-size: 10pt; '>> </span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>>
_______________________________________________</span><br><span style='font-size: 10pt; '>>
postgis-users mailing list</span><br><span style='font-size: 10pt; '>>
postgis-users@postgis.refractions.net</span><br><span style='font-size: 10pt; '>>
http://postgis.refractions.net/mailman/listinfo/postgis-users</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>-- </span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '> Free GIS & Flash
consultant/developer () ASCII Ribbon
Campaign</span><br><span style='font-size: 10pt; '>
http://foo.keybit.net/~strk/services.html /\ Keep it simple!
</span><br><span style='font-size: 10pt; '>_______________________________________________</span><br><span style='font-size: 10pt; '>postgis-users
mailing
list</span><br><span style='font-size: 10pt; '>postgis-users@postgis.refractions.net</span><br><span style='font-size: 10pt; '>http://postgis.refractions.net/mailman/listinfo/postgis-users</span></div>
</body>
</html>