Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://jira.codehaus.org/browse/GEOS-249
Here is an overview of the issue:
---------------------------------------------------------------------
Key: GEOS-249
Summary: 3d poinst from oracle are not rendered
Type: Bug
Status: Open
Priority: Major
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: GeoServer
Components:
Oracle
Versions:
1.2.3
Assignee: Sean Geoghegan
Reporter: Dirk Wilhelm
Created: Tue, 2 Nov 2004 3:50 AM
Updated: Tue, 2 Nov 2004 3:50 AM
Description:
Hello,
i did a little testing on sld. I tried to oracle db with 2d and 3d coordinates. From the 2d table all geometries are rendered, but of the 3d geometries only the polygon is rendered, and not the point.
SQL statements for table creation and some example geometries:
//creating 2d table
create table point2d (GID Number Primary Key, GEOM MDSYS.SDO_GEOMETRY);
//adding information to user_sdo_geom_metadata
INSERT INTO USER_SDO_GEOM_METADATA VALUES ('POINT2D', 'GEOM',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X', 0, 1000, 0.01),
MDSYS.SDO_DIM_ELEMENT('Y', 0, 1000, 0.01)),NULL);
//adding a 2d-point
insert into point2d values(1,
MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(500, 500, NULL), NULL, NULL));
//adding a 2d-polygon
insert into point2d values(2,
MDSYS.SDO_GEOMETRY(2003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1),
MDSYS.SDO_ORDINATE_ARRAY(200, 200, 200, 700, 800, 700, 800, 200, 200, 200)));
//creating 3d table
create table point3d (GID Number Primary Key, GEOM MDSYS.SDO_GEOMETRY);
//adding information to user_sdo_geom_metadata
INSERT INTO USER_SDO_GEOM_METADATA VALUES ('POINT3D', 'GEOM',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X', 0, 1000, 0.01),
MDSYS.SDO_DIM_ELEMENT('Y', 0, 1000, 0.01),
MDSYS.SDO_DIM_ELEMENT('Z', 0, 1000, 0.01)),NULL);
//adding a 3d-point
insert into point3d values(1,
MDSYS.SDO_GEOMETRY(3001, NULL, MDSYS.SDO_POINT_TYPE(500, 500, 500), NULL, NULL));
//adding a 3d-polygon
insert into point3d values(2,
MDSYS.SDO_GEOMETRY(3003, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1),
MDSYS.SDO_ORDINATE_ARRAY(200, 200, 150, 200, 700, 150, 800, 700, 150, 800, 200, 150, 200, 200, 150)));
cu,
Dirk
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira