[postgis-users] Function ST_CONTAINS respectively CONTAINS does not find Start-Endpoints in MultiLineString

pleasecontactmee at aim.com pleasecontactmee at aim.com
Wed Oct 1 07:00:56 PDT 2008


Hello,

Can you please help me, where am I wrong by using the PostGIS Function "Contains(geometry A, geometry B)" (referring to chapter 6.1. OpenGIS Functions of PostGIS manual)
which delivers back only points within a MULTILINESTRING except "start-" and "endpoint" of it?

Here are some examples
This statement returns "false" even though the first POINT(7.0 50.0) is part of the MultiLineString
SELECT Contains (GeomFromEWKT('SRID=4326;MULTILINESTRING((7.0 50.0,8.0 51.0,9.0 52.0))'), (GeomFromEWKT('SRID=4326;POINT(7.0 50.0)')) );
e.g. the "middle" point delivers what I expect="true"
SELECT Contains (GeomFromEWKT('SRID=4326;MULTILINESTRING((7.0 50.0,8.0 51.0,9.0 52.0))'), (GeomFromEWKT('SRID=4326;POINT(8.0 51.0)')) );

What I need is a function which is able to find ONE point within a MULTILINESTRING which can be the first, last or a point between them.
I am using pgAdminIII v1.6.3, "PostgreSQL 8.2.5" and PostGIS Version "1.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"

Thank you very much,
Wolfgang
________________________________________________________________________
AOL eMail auf Ihrem Handy! Ab sofort können Sie auch unterwegs Ihre AOL email abrufen. Registrieren Sie sich jetzt kostenlos.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081001/0f8b01e1/attachment.html>


More information about the postgis-users mailing list