Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Transform 3D to 2D Data via a Materialized View

Jeff HobbsAug 24 2007 — edited Oct 10 2007

Hi,

I'm playing with Geoserver against an Oracle Locator database. Things are starting well, but I did notice a bug where 3D points and lines are not supported. I guess this is an issue with GeoTools. Anybody have a way to transform my 3D data to 2D. Since I do use the 3rd dimension for storing elevation, I don't want to lose the data. So I was thinking that I could create materialized views to "virtually strip" the 3rd dimension. Any thoughts? I'm not very strong in PL/SQL, so any code hints would be greatly appreciated as well.

Thanks!

Jeff

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2007

Added on Aug 24 2007

#database-key-features, #spatial

6 comments

4,221 views