<HTML dir=ltr><HEAD><TITLE>Re: [Gvsig_english] oracle spatial wrong interpretation ofrectangles (at least 3d)</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16945" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText86191 dir=ltr>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>Hello.</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>Yes, according to the Oracle Spatial documentation, that's the semantics of the 3D rectangle: a cuboid defined by two opposite vertices and the heights being those of two opposite sides. It was not my invention!</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>Since gvSIG 1.9 does not deal with truly 3D objects, I think I'll do what Giovanni suggests (discarding the Z in this case).</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>As for gvSIG 2.0, I think I'll have to look into it a bit further.</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3>Regards,<BR></FONT></DIV>
<DIV dir=ltr><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV></DIV>
<DIV id=idSignature43374 dir=ltr>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de Benjamin Ducke<BR><B>Enviado el:</B> mar 19/01/2010 12:37<BR><B>Para:</B> Users and Developers mailing list<BR><B>Asunto:</B> Re: [Gvsig_english] oracle spatial wrong interpretation ofrectangles (at least 3d)<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>It makes sense to me: like you can define a 2D rectangle by giving<BR>just the top-left and bottom-right extreme coordinate pairs (x1,y1)<BR>and(x2,y2), you can define a cuboid perfectly well by giving the<BR>two extreme 3D points (x1,y1,z1) and (x2,y2,z2).<BR>Since the whole structure is by definition orthogonal<BR>(all interior angles are 90 degrees), this information is enough<BR>to construct the entire cube.<BR><BR>Ben<BR><BR><BR>----- Original Message -----<BR>From: "G. Allegri" <giohappy@gmail.com><BR>To: "Users and Developers mailing list" <gvsig_internacional@runas.cap.gva.es><BR>Sent: Tuesday, January 19, 2010 12:21:54 PM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna<BR>Subject: Re: [Gvsig_english] oracle spatial wrong interpretation ofrectangles (at least 3d)<BR><BR>I honestly think that the 3d rectangle (cuboid) structure in oracle is<BR>erroneous. It is defined as (x1,y1,z1,x2,y2,z2), which lets the other<BR>two vertices without a Z definition (and this lets the user decide<BR>what assign them...), while it would have been consistent if it was<BR>(x1,y1,y1,y2,z): this define completely a cuboid (with a fixed Z for<BR>all the vertices).<BR>So, I would avoid using them but they exist and may create problems<BR>for viewers.<BR><BR>What to do? In a 2D canvas I would simply discard the Z, while in a 3D<BR>env I would simply use the first one (subjective but argumentative).<BR>This is just a workaround to not break the viewer, not a consistent<BR>choice...<BR><BR>giovanni<BR>_______________________________________________<BR>Gvsig_internacional mailing list<BR>Gvsig_internacional@listserv.gva.es<BR><A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR><BR><BR><BR>------<BR>Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit <A href="http://iso26300.info/">http://iso26300.info</A> for more information.<BR><BR>_______________________________________________<BR>Gvsig_internacional mailing list<BR>Gvsig_internacional@listserv.gva.es<BR><A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR></FONT></P></DIV></BODY></HTML>