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.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to