Hi Wolfgang,make sense : ST_Contains Returns TRUE if geometry B is
completely inside geometry A
You can use ST_intersects ...
Fred
On Wed, Oct 1, 2008 at 3:00 PM, <[EMAIL PROTECTED]> wrote:
> 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 <http://www.aol.de/Webmail/> Sie sich jetzt
> kostenlos.
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
