Hi experts,
We are facing an issue when a spatial table is copied from ArcSDE 9.2 (Oracle DB) into Oracle Spatial (12c).
Below are the steps which were taken to get the data from ArcSDE.
1. In ArcCatalog (10.4 version), a connection was made to 9.2 ArcSDE and a feature class was right clicked and was copied.
2. Another connection was made to Oracle Spatial 12c in ArcCatalog and connected to it.
3. The feature class was pasted by right clicking and selecting Paste.
4. The ArcGIS copied the feature class and reported that it was copied successfully (about 11k rows, so not much of data)
There are certain geometries for which a difference has been noticed between ArcGIS and Oracle Spatial. E.g. for the same geometry, the ArcGIS reports are area as 577822.498 and Oracle Spatial reported the area for the geometry as 577813.775. So, there is a difference here of 8.72 Sq.M. To get the area in Oracle Spatial, I used the following query,
SELECT SDO_GEOM.SDO_AREA(GEOMETRY,0.001) as SITE_AREA
And, this has been noticed for many features, not just this one.
Any help is appreciated on this issue.
Thanks in advance,
Kiran.