<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'><div style="text-align: left;">Hello,<br><br><br>I try to use the && operator to select the boxes that intersect one line in 3d .. i need help to develop the Sql statement,<br><br>Select AsText(line_geom) as geom from line where line_geom && geomFromText(Select astext(the_geom) from boxex)',-1);<br><br>attached is a graph shows how the query result should looks i need just the red box to be seleced since the line intersect only the red box and not the another box which is lower than the line height.<br><br>Thanks<br><br><br></div><br><br><br><hr id="stopSpelling">> From: postgis-users-request@postgis.refractions.net<br>> Subject: postgis-users Digest, Vol 71, Issue 15<br>> To: postgis-users@postgis.refractions.net<br>> Date: Mon, 15 Sep 2008 12:00:20 -0700<br>> <br>> Send postgis-users mailing list submissions to<br>> postgis-users@postgis.refractions.net<br>> <br>> To subscribe or unsubscribe via the World Wide Web, visit<br>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br>> or, via email, send a message with subject or body 'help' to<br>> postgis-users-request@postgis.refractions.net<br>> <br>> You can reach the person managing the list at<br>> postgis-users-owner@postgis.refractions.net<br>> <br>> When replying, please edit your Subject line so it is more specific<br>> than "Re: Contents of postgis-users digest..."<br>> <br>> <br>> Today's Topics:<br>> <br>> 1. Re: Function 60821c60 returned NULL (Mark Cave-Ayland)<br>> 2. how to connect to oracle 9i (volker.emmel@lwk-rlp.de)<br>> <br>> <br>> ----------------------------------------------------------------------<br>> <br>> Message: 1<br>> Date: Mon, 15 Sep 2008 10:47:33 +0100<br>> From: Mark Cave-Ayland <mark.cave-ayland@siriusit.co.uk><br>> Subject: Re: [postgis-users] Function 60821c60 returned NULL<br>> To: PostGIS Users Discussion <postgis-users@postgis.refractions.net><br>> Message-ID: <48CE2F35.4070308@siriusit.co.uk><br>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br>> <br>> David R Robison wrote:<br>> > My version is 1.1.6. Can I upgrade just the PostGIS version without <br>> > upgrading PostgreSQL? I am running PostgreSQL 8.2. David<br>> <br>> Yes. Please see the "Soft Upgrade" instructions in the PostGIS <br>> documentation at <br>> http://postgis.refractions.net/documentation/manual-1.3/ch02.html.<br>> <br>> <br>> HTH,<br>> <br>> Mark.<br>> <br>> -- <br>> Mark Cave-Ayland<br>> Sirius Corporation - The Open Source Experts<br>> http://www.siriusit.co.uk<br>> T: +44 870 608 0063<br>> <br>> <br>> ------------------------------<br>> <br>> Message: 2<br>> Date: Mon, 15 Sep 2008 11:55:14 +0200<br>> From: volker.emmel@lwk-rlp.de<br>> Subject: [postgis-users] how to connect to oracle 9i<br>> To: postgis-users@postgis.refractions.net<br>> Message-ID:<br>> <OF02D63256.494AD279-ONC12574C5.0035C221-C12574C5.0036865A@lwk-rlp.de><br>> Content-Type: text/plain; charset="iso-8859-1"<br>> <br>> hi list,<br>> <br>> is it possible to connect PostGIS with an Oracle 9i Database ???<br>> <br>> Could I do this via odbc ???<br>> <br>> IŽd like to join oracle-stored-informations with my geometries from <br>> PostGIS...<br>> <br>> If someone knows a way....<br>> <br>> Thanks<br>> Volker<br>> -------------- next part --------------<br>> An HTML attachment was scrubbed...<br>> URL: http://lists.refractions.net/pipermail/postgis-users/attachments/20080915/a2b2afc6/attachment-0001.html<br>> <br>> ------------------------------<br>> <br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@postgis.refractions.net<br>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br>> <br>> <br>> End of postgis-users Digest, Vol 71, Issue 15<br>> *********************************************<br><br /><hr />Explore the seven wonders of the world <a href='http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE' target='_new'>Learn more!</a></body>
</html>