Tuesday, April 27, 2010
ArcSDE ST_GEOMETRY and Geoserver
I've been working on a migration plan to upgrade the HGL database. It's about 1.5 TB and we're moving from SDE 9.1/ Oracle 10G to SDE 9.3.1/ Oracle 11G. It took some testing to figure it all out but it's working now. However, part of the migration means upgrading the spatial geometry type which brings up a question about Geoserver and SDE. Are we all using the same data type? And, what's the compatibility matrix looking like between Geoserver and SDE in terms of correctly handling data stored as ST_GEOMETRY in SDE?
Subscribe to:
Post Comments (Atom)
Dave, at MIT we are using 9.3.1 & 10G w/ sdo_geometry. A preliminary look at the Geoserver forums seems to indicate that st_geometry is not supported by Geoserver connecting directly to Oracle. However, it appears to be supported if you connect Geoserver to SDE.
ReplyDelete