Database Software

As I've been working my way through all the errors my the data, I've finally come to 13349 [Element <1>] [Ring <1>][Edge <1>][Edge <3>], where it is a funky polygon, but technically correct.  I had found this blog that talks about it somewhat (http://www.spatialdbadvisor.com/oracle_spatial_tips_tricks/110/esri-arcsde-exverted-and-inverted-polygons-and-oracle-spa… ) and I thought it might be my answer to get my data to process properly when I query it (determining a point in a window), but I question the values of the data that get changed. 

These are nautical charts and my window is the 4 corners of the charts.  So, when the coordinates get changed from something like

(29.89531 -90.15322, 29.89531 -89.99156, 30.00592 -89.99156,  30.00592 -90.15306, 29.89531 -90.15322)

to

(-150.01621952311,-90,30.00592,-89.99156,29.89531,-89.99156,-150.01621952311,-90,-150.10469,-89.84678,-150.01621952311,-90,-149.99408,-89.84694,-150.10469,-89.84678)

I question why the change from i.e. lat 29.89531 to lat -150.01621952311.

The elem_info_array seems to have a few extra numbers added too and I don't understand what they are or why. i.e. ((1,1003,1) to (1,1003,1,9,1003,1).

This is the query I am using:

select bd.title, bd.kapp, bd.chart,

          bd.sdo_window.sdo_elem_info,

          bd.sdo_window.get_wkt(),

          SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT (bd.sdo_window, 0.005),

          sdo_util.rectify_geometry(bd.sdo_window,0.5) as rectgeom

  from boundaries_data bd

  where SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT (bd.sdo_window, 0.005) not like 'TRUE'

  and SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT (bd.sdo_window, 0.005) not like '13356%';

See the table below for more complete data.