[postgis-users] st_intersection error

[strk]

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!