[postgis-users] Sql 3Dbox

[eehab hamzeh]

Hello,


I try to use the && operator to select the boxes that intersect one line in 3d .. i need help to develop the Sql statement,

Select AsText(line_geom) as geom from line where line_geom && geomFromText(Select astext(the_geom) from boxex)',-1);

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.

Thanks





> From: postgis-users-request at postgis.refractions.net
> Subject: postgis-users Digest, Vol 71, Issue 15
> To: postgis-users at postgis.refractions.net
> Date: Mon, 15 Sep 2008 12:00:20 -0700
> 
> Send postgis-users mailing list submissions to
> 	postgis-users at postgis.refractions.net
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://postgis.refractions.net/mailman/listinfo/postgis-users
> or, via email, send a message with subject or body 'help' to
> 	postgis-users-request at postgis.refractions.net
> 
> You can reach the person managing the list at
> 	postgis-users-owner at postgis.refractions.net
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of postgis-users digest..."
> 
> 
> Today's Topics:
> 
>    1. Re: Function 60821c60 returned NULL (Mark Cave-Ayland)
>    2. how to connect to oracle 9i (volker.emmel at lwk-rlp.de)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Mon, 15 Sep 2008 10:47:33 +0100
> From: Mark Cave-Ayland <mark.cave-ayland at siriusit.co.uk>
> Subject: Re: [postgis-users] Function 60821c60 returned NULL
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <48CE2F35.4070308 at siriusit.co.uk>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> David R Robison wrote:
> > My version is 1.1.6. Can I upgrade just the PostGIS version without 
> > upgrading PostgreSQL? I am running PostgreSQL 8.2. David
> 
> Yes. Please see the "Soft Upgrade" instructions in the PostGIS 
> documentation at 
> http://postgis.refractions.net/documentation/manual-1.3/ch02.html.
> 
> 
> HTH,
> 
> Mark.
> 
> -- 
> Mark Cave-Ayland
> Sirius Corporation - The Open Source Experts
> http://www.siriusit.co.uk
> T: +44 870 608 0063
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Mon, 15 Sep 2008 11:55:14 +0200
> From: volker.emmel at lwk-rlp.de
> Subject: [postgis-users] how to connect to oracle 9i
> To: postgis-users at postgis.refractions.net
> Message-ID:
> 	<OF02D63256.494AD279-ONC12574C5.0035C221-C12574C5.0036865A at lwk-rlp.de>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> hi list,
> 
> is it possible to connect PostGIS with an Oracle 9i Database ???
> 
> Could I do this via odbc ???
> 
> I´d like to join oracle-stored-informations with my geometries from 
> PostGIS...
> 
> If someone knows a way....
> 
> Thanks
> Volker
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://lists.refractions.net/pipermail/postgis-users/attachments/20080915/a2b2afc6/attachment-0001.html
> 
> ------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> End of postgis-users Digest, Vol 71, Issue 15
> *********************************************

_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081016/64c532bd/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Intersection.jpg
Type: image/jpeg
Size: 48960 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081016/64c532bd/attachment.jpg>