[Gvsig_english] oracle spatial wrong interpretation ofrectangles (at least 3d)

[Benjamin Ducke]

Right, by definition, a polygon is a _planar_ structure, which a cube is
not. I have never seen a 3D cube as a GIS primitive type, either. I think
the only way to represent this in gvSIG's data model (or in any OGC-like
datamodel) would be to break the cube up into its six faces, each of
which could then be represented as a 3D polygon with four vertices.

Ben

----- Original Message -----
From: "Juan Lucas Dominguez Rubio" <jldominguez at prodevelop.es>
To: "Users and Developers mailing list" <gvsig_internacional at listserv.gva.es>, "Users and Developers mailing list" <gvsig_internacional at runas.cap.gva.es>
Sent: Monday, January 18, 2010 6:20:14 PM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna
Subject: Re: [Gvsig_english] oracle spatial wrong interpretation ofrectangles (at least 3d)


Re: [Gvsig_english] oracle spatial wrong interpretation ofrectangles (at least 3d) 

Hello, Giovanni. 

This is an interesting point. I think Oracle Spatial's 3D rectangles are beyond the scope of gvSIG's geometry model. gvSIG deals with 3D polygons in the sense that each vertex has a Z value, but this geometry: 

SDO_GEOMETRY(3003,NULL,NULL,SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(0,0,0,1,1,1)) 

is a cube with eight vertices. If we read it into gvSIG as a square, which Z must be set for each vertex? 

The Oracle Spatial driver knows that rectangles can be created in Oracle Spatial in a special way and it should work for 2D rectangles, and also for 3D polygons with 4 vertices, but not with those special 3D rectangles (cuboids). 

Honestly, I didnt know it was possible to create those cubes in Oracle Spatial, so I thought it was not necessary to manage that case. 

What should we do with those cubes that -in my opinion- cannot be represented properly in gvSIG 1.9? 

Regards, 

Juan Lucas Domínguez Rubio 
--- 

Prodevelop SL, Valencia (España) 

Tlf.: 96.351.06.12 -- Fax: 96.351.09.68 
http://www.prodevelop.es 
--- 


De: gvsig_internacional-bounces at listserv.gva.es en nombre de G. Allegri 
Enviado el: lun 18/01/2010 16:06 
Para: Users and Developers mailing list 
Asunto: Re: [Gvsig_english] oracle spatial wrong interpretation ofrectangles (at least 3d) 




Five minutes for my coffe break... 
--- 
I see that OracleSpatialUtils.getFMapGeometryMultipolygon(...) checks 
if the data is Circle, otherwise it treats them as regular polygons. 
Maybe an "isRectangle" management would solve the issue... 
--- 
Back to work. 

giovanni 

2010/1/18 G. Allegri <giohappy at gmail.com>: 
> I think there's a bug in the interpretation of 3d rectangles in oracle 
> spatial (3d polygons with interpretion code 3). I haven't the time in 
> this moment to debug it, but I see that getFMapGeometry returns a 
> multipolygon with the wrong set of coordinates, causing the geometry 
> to be meaningless (a big triangle going to infinity). 
> I don't know if it happens on 2d rectangles too (I suppose yes), 
> because in this moment I don't have 2d metadata tables on the 
> production db to test. 
> 
> giovanni 
> 
_______________________________________________ 
Gvsig_internacional mailing list 
Gvsig_internacional at listserv.gva.es 
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional 

_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at listserv.gva.es
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional


------
Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit http://iso26300.info for more information.