[postgis-users] st_intersection error

Düster Horst Horst.Duester at bd.so.ch
Mon Sep 14 23:43:10 PDT 2009


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.

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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090915/d3b3b03b/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/d3b3b03b/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/d3b3b03b/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: intersecterror.png
Type: application/octet-stream
Size: 13093 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090915/d3b3b03b/attachment-0002.obj>


More information about the postgis-users mailing list