[postgis-users] st_intersection error

[Düster Horst]

strk

I attached the geometries in my initial mail.

Take a look at aline1.sql and aline2.sql

regards
Horst

------------------------------------------------

Dr. Horst Düster
Stv. Amtschef / GIS-Koordinator 

Kanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
SO!GIS Koordination
Rötistrasse 4
CH-4501 Solothurn

Telefon ++41(0)32 627 25 32
Telefax ++41(0)32 627 22 14

mailto:horst.duester at bd.so.ch
http://www.agi.so.ch



-----Ursprüngliche Nachricht-----
Von: strk [mailto:strk at keybit.net]
Gesendet am: Dienstag, 15. September 2009 10:27
An: PostGIS Users Discussion
Betreff: Re: [postgis-users] st_intersection error

On Tue, Sep 15, 2009 at 08:43:10AM +0200, Düster Horst wrote:
> I do have 2 simple linestrings which partly have the same geometry
(see
> attached dump and image). My aim is to detect the common part of these
> two linestrings with the following query:
> 
> select st_intersection(a.the_geom, b.the_geom), a.myid
> from aline1, aline2
> 
> But as the result I get a geometrycollection with one POINT and one
> LINESTING. I expected one linestring. Is it a bug??
> I'll appreciate any hints.

Could be a bug, or a dimensional collapse.
Try posting the geometries, Martin Davis might have a try
with JTS.
Try also upgrading GEOS.

--strk;

> 
> My system:
> Postgis 1.4.0
> Geos 3.1.1
> Postgres 8.3.6
> 
> Best regards
>    
> Dr. Horst Düster
> Stv. Amtschef / GIS-Koordinator 
> 
> Kanton Solothurn
> Bau- und Justizdepartement
> Amt für Geoinformation
> SO!GIS Koordination
> Rötistrasse 4
> CH-4501 Solothurn
> 
> Telefon ++41(0)32 627 25 32
> Telefax ++41(0)32 627 22 14
> 
> mailto:horst.duester at bd.so.ch
> http://www.agi.so.ch
> 
> 




> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 

 Free GIS & Flash consultant/developer      ()  ASCII Ribbon Campaign
 http://foo.keybit.net/~strk/services.html  /\  Keep it simple! 
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090915/202c8a98/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: aline1.sql
Type: application/octet-stream
Size: 1199 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090915/202c8a98/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: aline2.sql
Type: application/octet-stream
Size: 1268 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090915/202c8a98/attachment-0001.obj>