<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=919541614-01102008><FONT face=Arial
color=#0000ff size=2>Use Intersects.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=919541614-01102008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=919541614-01102008><FONT face=Arial
color=#0000ff size=2>SELECT
Intersects(GeomFromEWKT('SRID=4326;MULTILINESTRING((7.0 50.0,8.0 51.0,9.0
52.0))'), (GeomFromEWKT('SRID=4326;POINT(7.0 50.0)')) );</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>pleasecontactmee@aim.com<BR><B>Sent:</B> Wednesday, October 01, 2008 10:01
AM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] Function ST_CONTAINS respectively CONTAINS does not find
Start-Endpoints in MultiLineString<BR></FONT><BR></DIV>
<DIV></DIV><FONT face="Arial, Helvetica, sans-serif">Hello,<BR><BR>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)<BR>which delivers back only points within a MULTILINESTRING
except "start-" and "endpoint" of it?<BR><BR>Here are some examples<BR>This
statement returns "false" even though the first POINT(7.0 50.0) is part of the
MultiLineString<BR>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)'))
);<BR>e.g. the "middle" point delivers what I expect="true"<BR>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)')) );<BR><BR>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.<BR>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"<BR><BR>Thank
you very much,<BR>Wolfgang</FONT>
<DIV class=AOLPromoFooter>
<HR style="MARGIN-TOP: 10px">
<B>AOL eMail auf Ihrem Handy!</B>Ab sofort können Sie auch unterwegs Ihre AOL
email abrufen. <A href="http://www.aol.de/Webmail/"
target=_blank>Registrieren</A> Sie sich jetzt kostenlos.<BR></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>