Connect to oracle spatial

Syarief · March 22, 2016, 8:00am

Hi,

I’m trying to display spatial data from oracle using MapSuite Silverlight,

here is the code i use

1.string _connectionString = “User ID=user;Password=***;Data Source=server/servicename;”;
2.string _tableName = “table”;
3.string _featureIdColumn = “id”;
4.OracleFeatureLayer _layer = new OracleFeatureLayer(_connectionString, _tableName, _featureIdColumn);
5._layerOverlay.Layers.Add(MapHelper.ServerLayerName, _layer);

but i get an error “Oracle dependencies cannot be found” on line 4.

could you please explain what happened?

and what is the prerequisites that I have to have to be able to connect to oracle spatial?

and please explain about connection string, is it using oracle client? is there direct connect mode?

Thanks.

Troy · March 22, 2016, 11:21am

Hi Syarief,

The exception is because the Oracle Dependencies are not included by default after the installation and we need to add them manually. Please download it from wiki.thinkgeo.com/wiki/File:…0.63.0.zip

As for the connection string, please refer to connectionstrings.com/oracle/. for more details. We are not using Oracle Client but use Oracle.DataAccess.dll which is in Oracle Dependencies dlls to access oracle.

For the question “is there direct connect mode?”, sorry I didn’t get it.

Any questions, please feel free to let us know.
Thanks,
Troy

Syarief · March 22, 2016, 11:21am

Hi Troy,

thanks for the reply even though I haven’t tried the dll dependencies. I’ll let you know the result if it works.

I just wanna comment on direct connect mode, what I mean with direct connect mode is we don’t need to install oracle client or setting up tnsnames if we want to connect to oracle. we just have to define the host, port, and servicename or sid in the connection string to be able to connect. hope you understand what I mean.

Thanks.

Ethan · March 22, 2016, 11:21am

Hi Syarief,

Thanks for your explain about direct connect mode.

Our map control choose Oracle client because it warp good for connect Oracle database.

If don’t choose that, we can choose write related code based on oledb, we thought that’s not a better solution.

But if customer have this requirement, we will let our developer knows that and I think they will discuss about it.

Regards,

Don

Syarief · March 22, 2016, 11:21am

Hi Don,

I don’t really know if its a better solution or not, but in my point of view it’s more simple and clear.

I have tried installing oracle dependencies that Troy gave, and the error “Oracle Dependencies” is not there anymore.

but another problem raise up, I load oracle spatial table via server overlay.

this is my code to load oracle spatial table

ServerLayerOverlay _layerOverlay = new ServerLayerOverlay(MapHelperShared.ServerOverlayKeyName);
_layerOverlay.ServerCache = new ServerCache(MapHelper.MapDirectory);
_layerOverlay.ClientCache = null;
SmartMapConnector.ServerLayerOverlays.Add(MapHelperShared.ServerOverlayKeyName, _layerOverlay);

OracleFeatureLayer _spatialLayer =
new OracleFeatureLayer(MapHelperShared.ConnectionString,
MapHelperShared.SpatialTableName, MapHelperShared.SpatialIdColumn);

// some layer styling

_layerOverlay.Layers.Add(MapHelperShared.ServerLayerKeyName, _spatialLayer);

the above code doesn’t throw any exception, but when I tried to get the boundary via service, it throws error below

"System.Reflection.TargetInvocationException was caught

  HResult=-2146232828

  Message=Exception has been thrown by the target of an invocation.

  Source=mscorlib

  StackTrace:

       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

       at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)

       at ThinkGeo.MapSuite.Core.OracleFeatureSource.GetBoundingBoxCore()

       at ThinkGeo.MapSuite.Core.FeatureSource.GetBoundingBox()

       at ThinkGeo.MapSuite.Core.FeatureLayer.GetBoundingBoxCore()

       at ThinkGeo.MapSuite.Core.Layer.GetBoundingBox()

       at iProTax.Website.Services.SmartMapOraWcfService.GetBoundingBoxMap(String MapId, FeatureType ObjectType) in e:\CARTENZ\PROJECT\IPROTAX\CODE\NET\iProTax\iProTax.Website\Services\SmartMapWcfService.Ora.cs:line 63

  InnerException: Oracle.DataAccess.Client.OracleException

       HResult=-2147467259

       Message=ORA-01403: no data found

ORA-06512: at line 1

       Source=Oracle Data Provider for .NET

       ErrorCode=-2147467259

       DataSource=sanserver/iprotax

       Number=1403

       Procedure=""

       StackTrace:

            at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

            at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

            at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()

            at OracleApiWrapper.OracleApiWrapper.GetBoundingBox()

       InnerException: "

this is the code I use to retrieve map boundary.

1.OracleFeatureLayer _spatialLayer = new OracleFeatureLayer(ConnectionString, _tableName, _featureIdColumn);
2._spatialLayer.Open();
3._result.WellKnownText = _spatialLayer.GetBoundingBox().GetWellKnownText();
4._spatialLayer.Close();

the error is thrown at line 3.

Troy · March 22, 2016, 11:21am

Hi Syarief,

Actually, the reason we don’t use OracleClient(The .NET Framework Data Provider for Oracle) is because this have been marked deprecated in MSDN, please refer to msdn.microsoft.com/en-us/lib…110).aspx As it suggests to use third-party provider, we are choosing the Oracle Data Provider for .NET Provided from Oracle itself and we can find it from oracle.com/technetwork/t…85163.html

For your second issue, based on the exception message “Message=ORA-01403: no data found”, This error always happens when we use “select into” and there is no data returned. The the blow statement will be used when calling getBoundingBox, would you please execute it in your Oracle database to see if no data returned?

BEGIN SELECT DIMINFO INTO metaData FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME=‘myTableName’;END;

I am guessing if your table name not exist in your database?

Hope it helps and any questions, please feel free to let us know.

Thanks,

Troy

Syarief · March 22, 2016, 11:21am

Hi Troy,

thanks for your help, now I can get the bounding area.

FYI, for my case the problem rely on how I specified “TableName”, I use “SchemaName”.“TableName” when instantiating OracleFeatureLayer.

I guess the table name that should be provided when creating OracleFeatureLayer must be the same with column TABLE_NAME on table USER_SDO_GEOM_METADATA.

Now another problem, it seems the projection is wrong, I have google Maps as base layer and add OracleLayer on top of it. I have specified the OracleLayer.FeatureSource.Projection as below

ManagedProj4Projection _mapProjection = new ManagedProj4Projection(Proj4Projection.GetEpsgParametersString(4326),
Proj4Projection.GetGoogleMapParametersString());
OracleFeatureLayer _spatialLayer = new OracleFeatureLayer(ConnectionString, _tableName, _featureIdColumn);
_spatialLayer.FeatureSource.Projection = _mapProjection ;

I have done the same using shapefile, and it works great. I use Oracle Map Builder to convert that shapefile into Oracle Spatial Data and trying to do the same. but I don’t get the same result.

Troy · March 22, 2016, 11:21am

Hi Syarief,

For the new issue, would you please make sure the coordinate system of the oracle data source is 4326? I am note sure whether you import the shape file into oracle with a difference projection.

I think you can compare the layer boundingbox value between the layer without projection and a layer with projection, then you can attach the wkt here. Some codes like the below:

ManagedProj4Projection _mapProjection = new ManagedProj4Projection(Proj4Projection.GetEpsgParametersString(4326),
                Proj4Projection.GetGoogleMapParametersString());
                OracleFeatureLayer _spatialLayer = new OracleFeatureLayer();
                //_spatialLayer.FeatureSource.Projection = _mapProjection;
                _spatialLayer.Open();
          string boundingBoxWKT = _spatialLayer.GetBoundingBox().GetWellKnownText();
I hope we can have some insights on that.

Thanks,

Troy

Syarief · March 22, 2016, 11:21am

Hi Troy,

I’m not really sure how to make sure coordinate system of oracle data source, but I’m really sure I have provided EPSG 4326 when I convert it using Oracle MapBuilder, and also I checked on table MDSYS.SDO_GEOM_METADATA_TABLE the SDO_SRID column value is 4326.

this is wkt on shp bounding box:

POLYGON((12812502.362443 -920315.248258333,12812502.362443 -970800.821323967,12829511.0678164 -970800.821323967,12829511.0678164 -920315.248258333,12812502.362443 -920315.248258333))

and this is wkt on oracle spatial bounding box:

POLYGON((-20037508.2314698 20037508.2314698,-20037508.2314698 -20037508.2314698,20037508.2314698 -20037508.2314698,20037508.2314698 20037508.2314698,-20037508.2314698 20037508.2314698))

Troy · March 22, 2016, 11:21am

Hi Syarief,

From the bounding box value you provided for us, seems your shape file’s is under google projection now. Does you have added the projection on your shapeFileFeatureLayer?

As the Oracle wkt boundingbox, the value is also under the Google projection(EPSG 900913) and cover the whole world, so we don’t need to add the projection converter on the OracleFeatureLayer’s featuresource.

Here is an online sample to see what’s the area with the wkt string, please have a look and the below is the steps:

1. openlayers.org/dev/examples/vector-formats.html

2. select format dropdownlist as wkt.

3. select the input projection as Spherical Mercator
4. then type your wkt.

Please let me know if there is anything I am missing.

Thanks,

Troy

Syarief · March 22, 2016, 11:21am

Hi Troy,

All of the wkt that I provide you are using Google Projection

I get the Bounding Box using this code,

01.ManagedProj4Projection _mapProjection = new ManagedProj4Projection(Proj4Projection.GetEpsgParametersString(4326),
02. Proj4Projection.GetGoogleMapParametersString());
03.
04.ShapeFileFeatureLayer _shapeLayer = new ShapeFileFeatureLayer(mapPath);
05._shapeLayer.FeatureSource.Projection = _mapProjection;
06._shapeLayer.Open();
07.string boundingBoxShapeFile = _shapeLayer.GetBoundingBox().GetWellKnownText();
08._shapeLayer.Close();
09.
10.OracleFeatureLayer _spatialLayer = new OracleFeatureLayer();
11._spatialLayer.FeatureSource.Projection = _mapProjection;
12._spatialLayer.Open();
13.string boundingBoxOracle = _spatialLayer.GetBoundingBox().GetWellKnownText();
14._spatialLayer.Close();

those wkt I provided is base on line 07 and line 13.

I have tried using openlayers.org/dev/examples/vector-formats.html, and I get the same result using MapSuite.

I have tried to load those spatial using Oracle MapBuilder and it shows perfectly, just like the ShapeFile, I attach the screenshoot for your ref.

below are rows from my spatial table in oracle, hope you could help me know what’s wrong or missing.

"

Row 1

MDSYS.SDO_GEOMETRY(3003, 4326, null, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1), MDSYS.SDO_ORDINATE_ARRAY(115.247835, -8.570103, 0, 115.247861, -8.564443, 0, 115.245836, -8.560139, 0, 115.244934, -8.558779, 0, 115.243129, -8.556059, 0, 115.242904, -8.555606, 0, 115.239742, -8.551749, 0, 115.238393, -8.548804, 0, 115.237490, -8.547444, 0, 115.234102, -8.543586, 0, 115.233423, -8.542905, 0, 115.232069, -8.541090, 0, 115.231393, -8.539957, 0, 115.230053, -8.534752, 0, 115.230075, -8.529997, 0, 115.229637, -8.526604, 0, 115.229416, -8.525247, 0, 115.229665, -8.520502, 0, 115.230587, -8.517567, 0, 115.231054, -8.514857, 0, 115.231745, -8.512826, 0, 115.233124, -8.508990, 0, 115.235192, -8.504027, 0, 115.236579, -8.498599, 0, 115.237732, -8.494536, 0, 115.238665, -8.489341, 0, 115.239136, -8.485727, 0, 115.239599, -8.483695, 0, 115.239603, -8.482791, 0, 115.239848, -8.478949, 0, 115.239424, -8.472166, 0, 115.239227, -8.465602, 0, 115.238336, -8.461981, 0, 115.237445, -8.457909, 0, 115.236995, -8.457002, 0, 115.229743, -8.453805, 0, 115.229517, -8.453578, 0, 115.229291, -8.453351, 0, 115.229065, -8.453124, 0, 115.228613, -8.452896, 0, 115.228387, -8.452669, 0, 115.228159, -8.452668, 0, 115.227706, -8.452440, 0, 115.227480, -8.452213, 0, 115.227026, -8.452211, 0, 115.226799, -8.452210, 0, 115.226345, -8.452208, 0, 115.225891, -8.452206, 0, 115.225664, -8.452205, 0, 115.225436, -8.452430, 0, 115.224980, -8.452653, 0, 115.224751, -8.452879, 0, 115.224296, -8.453102, 0, 115.224068, -8.453327, 0, 115.223839, -8.453778, 0, 115.223383, -8.454228, 0, 115.223155, -8.454453, 0, 115.223154, -8.454679, 0, 115.222926, -8.454904, 0, 115.223016, -8.455086, 0, 115.222697, -8.455355, 0, 115.222468, -8.455806, 0, 115.222238, -8.456257, 0, 115.222009, -8.456709, 0, 115.221780, -8.457160, 0, 115.221551, -8.457611, 0, 115.221321, -8.458288, 0, 115.221092, -8.458739, 0, 115.220862, -8.459190, 0, 115.220634, -8.459415, 0, 115.220405, -8.459866, 0, 115.220177, -8.460091, 0, 115.219949, -8.460316, 0, 115.219493, -8.460766, 0, 115.219265, -8.460991, 0, 115.218810, -8.461215, 0, 115.218582, -8.461440, 0, 115.218126, -8.461664, 0, 115.217899, -8.461662, 0, 115.217671, -8.461887, 0, 115.217443, -8.462112, 0, 115.216762, -8.462109, 0, 115.216534, -8.462334, 0, 115.216080, -8.462332, 0, 115.215397, -8.462555, 0, 115.215170, -8.462554, 0, 115.214717, -8.462326, 0, 115.214263, -8.462324, 0, 115.214038, -8.461871, 0, 115.213585, -8.461643, 0, 115.213359, -8.461416, 0, 115.213134, -8.460963, 0, 115.213135, -8.460737, 0, 115.212910, -8.460284, 0, 115.212684, -8.460056, 0, 115.212458, -8.459603, 0, 115.212232, -8.459376, 0, 115.212008, -8.458697, 0, 115.211783, -8.458244, 0, 115.211785, -8.457792, 0, 115.211560, -8.457339, 0, 115.211336, -8.456886, 0, 115.211110, -8.456659, 0, 115.210885, -8.456206, 0, 115.210659, -8.455979, 0, 115.210433, -8.455752, 0, 115.209980, -8.455524, 0, 115.209526, -8.455295, 0, 115.209299, -8.455294, 0, 115.208846, -8.455066, 0, 115.208393, -8.454838, 0, 115.207027, -8.455736, 0, 115.204740, -8.459116, 0, 115.203131, -8.463403, 0, 115.201972, -8.468370, 0, 115.201719, -8.474029, 0, 115.201473, -8.478096, 0, 115.201456, -8.481713, 0, 115.200991, -8.483971, 0, 115.200074, -8.486001, 0, 115.199846, -8.486226, 0, 115.198023, -8.487347, 0, 115.198019, -8.488251, 0, 115.198017, -8.488703, 0, 115.198015, -8.489156, 0, 115.198013, -8.489608, 0, 115.198011, -8.490060, 0, 115.198009, -8.490512, 0, 115.198007, -8.490738, 0, 115.198006, -8.490964, 0, 115.197777, -8.491415, 0, 115.197776, -8.491641, 0, 115.197774, -8.492093, 0, 115.197545, -8.492544, 0, 115.197543, -8.492996, 0, 115.197768, -8.493449, 0, 115.197766, -8.493901, 0, 115.197764, -8.494353, 0, 115.197760, -8.495031, 0, 115.197757, -8.495709, 0, 115.197754, -8.496387, 0, 115.197753, -8.496613, 0, 115.197750, -8.497291, 0, 115.197748, -8.497743, 0, 115.197747, -8.497969, 0, 115.197744, -8.498647, 0, 115.197740, -8.499325, 0, 115.197738, -8.499777, 0, 115.197734, -8.500682, 0, 115.197732, -8.501134, 0, 115.197502, -8.501811, 0, 115.1975, -8.502263, 0, 115.197726, -8.502490, 0, 115.197723, -8.502951, 0, 115.197495, -8.503176, 0, 115.197493, -8.503628, 0, 115.197491, -8.504080, 0, 115.197488, -8.504758, 0, 115.197260, -8.504983, 0, 115.197258, -8.505435, 0, 115.197028, -8.506112, 0, 115.197252, -8.506565, 0, 115.197024, -8.506790, 0, 115.197022, -8.507242, 0, 115.197021, -8.507468, 0, 115.197019, -8.507920, 0, 115.197017, -8.508372, 0, 115.197015, -8.508824, 0, 115.196785, -8.509501, 0, 115.196782, -8.509953, 0, 115.196781, -8.510179, 0, 115.196551, -8.510630, 0, 115.196550, -8.510856, 0, 115.196321, -8.511307, 0, 115.196320, -8.511533, 0, 115.196319, -8.511759, 0, 115.196317, -8.512211, 0, 115.196316, -8.512437, 0, 115.196086, -8.513114, 0, 115.196084, -8.513566, 0, 115.196080, -8.514244, 0, 115.196078, -8.514696, 0, 115.196076, -8.515148, 0, 115.196075, -8.515375, 0, 115.196072, -8.516053, 0, 115.196071, -8.516279, 0, 115.196069, -8.516731, 0, 115.196066, -8.517409, 0, 115.196292, -8.517636, 0, 115.196516, -8.518089, 0, 115.196514, -8.518541, 0, 115.196740, -8.518994, 0, 115.196738, -8.519446, 0, 115.196964, -8.519673, 0, 115.197190, -8.5199, 0, 115.197415, -8.520353, 0, 115.197641, -8.520580, 0, 115.197866, -8.521034, 0, 115.198092, -8.521261, 0, 115.198090, -8.521713, 0, 115.198544, -8.521715, 0, 115.198997, -8.521943, 0, 115.199678, -8.522172, 0, 115.200132, -8.522174, 0, 115.200358, -8.522401, 0, 115.200812, -8.522403, 0, 115.201267, -8.522179, 0, 115.201721, -8.522181, 0, 115.202175, -8.522184, 0, 115.202630, -8.522186, 0, 115.202857, -8.522187, 0, 115.203312, -8.522189, 0, 115.203538, -8.522416, 0, 115.203764, -8.522643, 0, 115.203990, -8.522870, 0, 115.204207, -8.522826, 0, 115.204214, -8.523323, 0, 115.204440, -8.523550, 0, 115.204438, -8.524002, 0, 115.204436, -8.524454, 0, 115.204435, -8.524680, 0, 115.204433, -8.525132, 0, 115.204431, -8.525584, 0, 115.204429, -8.526036, 0, 115.2042, -8.526487, 0, 115.204198, -8.526939, 0, 115.204196, -8.527165, 0, 115.203968, -8.527390, 0, 115.203966, -8.527843, 0, 115.203964, -8.528295, 0, 115.203963, -8.528521, 0, 115.203734, -8.528972, 0, 115.203959, -8.529425, 0, 115.203729, -8.530102, 0, 115.203726, -8.530780, 0, 115.203496, -8.531231, 0, 115.203494, -8.531683, 0, 115.203493, -8.531909, 0, 115.203263, -8.532586, 0, 115.203034, -8.533037, 0, 115.203032, -8.533489, 0, 115.202802, -8.533949, 0, 115.2028, -8.534401, 0, 115.202342, -8.535077, 0, 115.202340, -8.535529, 0, 115.202111, -8.535980, 0, 115.201882, -8.536431, 0, 115.201652, -8.536882, 0, 115.201424, -8.537107, 0, 115.201194, -8.537784, 0, 115.201193, -8.538010, 0, 115.200737, -8.538460, 0, 115.200509, -8.538685, 0, 115.200508, -8.538911, 0, 115.200051, -8.539361, 0, 115.199822, -8.539812, 0, 115.199593, -8.540263, 0, 115.199363, -8.540714, 0, 115.199134, -8.541165, 0, 115.198451, -8.541614, 0, 115.198448, -8.542066, 0, 115.198219, -8.542517, 0, 115.197762, -8.543192, 0, 115.197533, -8.543643, 0, 115.197304, -8.544094, 0, 115.197074, -8.544545, 0, 115.196845, -8.544996, 0, 115.196388, -8.545446, 0, 115.196158, -8.546123, 0, 115.195929, -8.546574, 0, 115.195698, -8.547251, 0, 115.195469, -8.547702, 0, 115.195239, -8.548379, 0, 115.195010, -8.548830, 0, 115.194782, -8.549055, 0, 115.194552, -8.549506, 0, 115.194323, -8.549957, 0, 115.194321, -8.550409, 0, 115.194091, -8.551086, 0, 115.193863, -8.551311, 0, 115.193634, -8.551762, 0, 115.193402, -8.552439, 0, 115.193172, -8.553116, 0, 115.192943, -8.553567, 0, 115.192714, -8.554018, 0, 115.192712, -8.554470, 0, 115.192482, -8.554921, 0, 115.192481, -8.555147, 0, 115.192252, -8.555598, 0, 115.192250, -8.556050, 0, 115.192022, -8.556275, 0, 115.192019, -8.556953, 0, 115.192017, -8.557405, 0, 115.191787, -8.557856, 0, 115.191785, -8.558308, 0, 115.191784, -8.558534, 0, 115.191555, -8.558985, 0, 115.191553, -8.559437, 0, 115.191552, -8.559663, 0, 115.191322, -8.560114, 0, 115.191320, -8.560566, 0, 115.191318, -8.561018, 0, 115.191543, -8.561471, 0, 115.191542, -8.561697, 0, 115.191540, -8.562150, 0, 115.191538, -8.562602, 0, 115.191536, -8.563054, 0, 115.191760, -8.563733, 0, 115.191757, -8.564185, 0, 115.191755, -8.564637, 0, 115.191753, -8.565098, 0, 115.191978, -8.565551, 0, 115.191976, -8.566003, 0, 115.191974, -8.566455, 0, 115.192199, -8.566908, 0, 115.192197, -8.567360, 0, 115.192422, -8.567813, 0, 115.192419, -8.568265, 0, 115.192644, -8.568718, 0, 115.192869, -8.569172, 0, 115.192867, -8.569624, 0, 115.192865, -8.570076, 0, 115.192861, -8.570980, 0, 115.192857, -8.571658, 0, 115.193084, -8.571885, 0, 115.193080, -8.572563, 0, 115.193078, -8.573015, 0, 115.193077, -8.573241, 0, 115.193302, -8.573694, 0, 115.193299, -8.574372, 0, 115.193298, -8.574598, 0, 115.193524, -8.575051, 0, 115.193748, -8.575730, 0, 115.193972, -8.576183, 0, 115.193970, -8.576636, 0, 115.193968, -8.577088, 0, 115.194193, -8.577541, 0, 115.194192, -8.577767, 0, 115.194190, -8.578219, 0, 115.194415, -8.578672, 0, 115.194640, -8.579125, 0, 115.194638, -8.579577, 0, 115.194863, -8.580030, 0, 115.194862, -8.580256, 0, 115.194859, -8.580708, 0, 115.195084, -8.581161, 0, 115.195082, -8.581613, 0, 115.195307, -8.582066, 0, 115.195306, -8.582292, 0, 115.195304, -8.582744, 0, 115.195527, -8.583650, 0, 115.195525, -8.584102, 0, 115.195522, -8.584554, 0, 115.195521, -8.584780, 0, 115.195745, -8.585459, 0, 115.195743, -8.585911, 0, 115.195969, -8.586138, 0, 115.196194, -8.586591, 0, 115.196420, -8.587044, 0, 115.196418, -8.587496, 0, 115.196643, -8.587949, 0, 115.196868, -8.588402, 0, 115.196866, -8.588854, 0, 115.197092, -8.589081, 0, 115.197090, -8.589533, 0, 115.197314, -8.589987, 0, 115.197313, -8.590213, 0, 115.197311, -8.590665, 0, 115.197537, -8.590892, 0, 115.197534, -8.591570, 0, 115.197533, -8.591796, 0, 115.197758, -8.592249, 0, 115.197757, -8.592475, 0, 115.197755, -8.592927, 0, 115.197980, -8.593380, 0, 115.197978, -8.593832, 0, 115.197975, -8.594284, 0, 115.197973, -8.594736, 0, 115.198199, -8.594963, 0, 115.198197, -8.595415, 0, 115.198422, -8.595868, 0, 115.198421, -8.596103, 0, 115.198418, -8.596782, 0, 115.198644, -8.597009, 0, 115.198642, -8.597461, 0, 115.198867, -8.597914, 0, 115.198866, -8.598140, 0, 115.199091, -8.598593, 0, 115.199090, -8.598819, 0, 115.199315, -8.599272, 0, 115.199539, -8.599951, 0, 115.199765, -8.600178, 0, 115.200218, -8.600406, 0, 115.200217, -8.600632, 0, 115.200442, -8.601085, 0, 115.200895, -8.601314, 0, 115.201120, -8.601767, 0, 115.201119, -8.601993, 0, 115.201344, -8.602446, 0, 115.201343, -8.602672, 0, 115.201341, -8.603124, 0, 115.201566, -8.603577, 0, 115.201565, -8.603803, 0, 115.201791, -8.604030, 0, 115.201789, -8.604482, 0, 115.201788, -8.604708, 0, 115.202013, -8.605161, 0, 115.202240, -8.605388, 0, 115.202239, -8.605614, 0, 115.202511, -8.605751, 0, 115.202692, -8.605842, 0, 115.209530, -8.600902, 0, 115.209758, -8.600677, 0, 115.209759, -8.600451, 0, 115.209987, -8.600226, 0, 115.209988, -8.60, 0, 115.210215, -8.600001, 0, 115.210444, -8.599776, 0, 115.210445, -8.599550, 0, 115.210673, -8.599325, 0, 115.210674, -8.599099, 0, 115.210902, -8.598874, 0, 115.210903, -8.598648, 0, 115.210904, -8.598422, 0, 115.211132, -8.598197, 0, 115.211359, -8.598198, 0, 115.211362, -8.597746, 0, 115.211589, -8.597747, 0, 115.211591, -8.597295, 0, 115.211818, -8.597296, 0, 115.212047, -8.597071, 0, 115.212048, -8.596845, 0, 115.212276, -8.596620, 0, 115.212504, -8.596395, 0, 115.212732, -8.596170, 0, 115.212962, -8.595710, 0, 115.213191, -8.595259, 0, 115.213646, -8.595035, 0, 115.213648, -8.594583, 0, 115.214103, -8.594359, 0, 115.214105, -8.594133, 0, 115.214560, -8.593909, 0, 115.214789, -8.593458, 0, 115.215018, -8.593233, 0, 115.215246, -8.593008, 0, 115.215474, -8.592783, 0, 115.215930, -8.592559, 0, 115.216385, -8.592336, 0, 115.216613, -8.592111, 0, 115.217068, -8.591887, 0, 115.217296, -8.591662, 0, 115.217980, -8.591439, 0, 115.218435, -8.591215, 0, 115.218889, -8.591217, 0, 115.219344, -8.590993, 0, 115.220027, -8.590770, 0, 115.220482, -8.590546, 0, 115.220936, -8.590548, 0, 115.221391, -8.590324, 0, 115.221846, -8.590327, 0, 115.222074, -8.590102, 0, 115.222302, -8.590103, 0, 115.222756, -8.590105, 0, 115.223211, -8.589881, 0, 115.223438, -8.589882, 0, 115.223666, -8.589657, 0, 115.224122, -8.589207, 0, 115.227537, -8.587640, 0, 115.228903, -8.587195, 0, 115.229131, -8.586970, 0, 115.229358, -8.586971, 0, 115.229585, -8.586972, 0, 115.230040, -8.586748, 0, 115.230268, -8.586523, 0, 115.230723, -8.586525, 0, 115.230724, -8.586299, 0, 115.231179, -8.586301, 0, 115.231406, -8.586302, 0, 115.231634, -8.586077, 0, 115.231861, -8.586078, 0, 115.232315, -8.586080, 0, 115.232770, -8.585856, 0, 115.232997, -8.585857, 0, 115.233225, -8.585858, 0, 115.233680, -8.585860, 0, 115.233907, -8.585861, 0, 115.234134, -8.585863, 0, 115.234361, -8.585864, 0, 115.234815, -8.585866, 0, 115.235269, -8.585868, 0, 115.235952, -8.585645, 0, 115.236633, -8.585648, 0, 115.237315, -8.585425, 0, 115.237770, -8.585427, 0, 115.238224, -8.585429, 0, 115.238453, -8.585204, 0, 115.238907, -8.585206, 0, 115.239134, -8.585207, 0, 115.239361, -8.585208, 0, 115.239816, -8.584984, 0, 115.240043, -8.584985, 0, 115.240270, -8.584986, 0, 115.240499, -8.584762, 0, 115.240953, -8.584764, 0, 115.241181, -8.584765, 0, 115.241635, -8.584767, 0, 115.241863, -8.584542, 0, 115.242317, -8.584544, 0, 115.242544, -8.584545, 0, 115.242545, -8.584319, 0, 115.242772, -8.584320, 0, 115.243227, -8.584322, 0, 115.243455, -8.584323, 0, 115.243682, -8.584324, 0, 115.244136, -8.584326, 0, 115.244363, -8.584327, 0, 115.244590, -8.584328, 0, 115.244817, -8.584329, 0, 115.245271, -8.584331, 0, 115.245498, -8.584332, 0, 115.246633, -8.584789, 0, 115.247326, -8.582080, 0, 115.247568, -8.578917, 0, 115.248037, -8.575755, 0, 115.248038, -8.575529, 0, 115.247834, -8.570329, 0, 115.247835, -8.570103, 0))

Row 2

MDSYS.SDO_GEOMETRY(3003, 4326, null, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1), MDSYS.SDO_ORDINATE_ARRAY(115.174671, -8.479102, 0, 115.174654, -8.482718, 0, 115.175093, -8.485885, 0, 115.176221, -8.487472, 0, 115.176672, -8.488152, 0, 115.178264, -8.487708, 0, 115.180307, -8.487943, 0, 115.181433, -8.489983, 0, 115.180965, -8.492693, 0, 115.178896, -8.498108, 0, 115.177517, -8.501491, 0, 115.174762, -8.507816, 0, 115.173841, -8.510524, 0, 115.172005, -8.514584, 0, 115.170859, -8.516839, 0, 115.169938, -8.519547, 0, 115.168098, -8.524284, 0, 115.167853, -8.5279, 0, 115.166244, -8.532186, 0, 115.164943, -8.535556, 0, 115.163714, -8.538738, 0, 115.162557, -8.543253, 0, 115.161863, -8.545736, 0, 115.159322, -8.554539, 0, 115.159320, -8.554991, 0, 115.156103, -8.562886, 0, 115.155186, -8.564464, 0, 115.151283, -8.573269, 0, 115.146239, -8.582738, 0, 115.144640, -8.584764, 0, 115.140521, -8.591073, 0, 115.135040, -8.596932, 0, 115.133669, -8.598507, 0, 115.130473, -8.601656, 0, 115.129573, -8.600069, 0, 115.127540, -8.597573, 0, 115.126186, -8.595985, 0, 115.124828, -8.595065, 0, 115.123922, -8.594382, 0, 115.122790, -8.593699, 0, 115.121428, -8.593466, 0, 115.120066, -8.593234, 0, 115.118932, -8.593002, 0, 115.118017, -8.594128, 0, 115.116192, -8.595710, 0, 115.115050, -8.596834, 0, 115.114823, -8.596833, 0, 115.112996, -8.599084, 0, 115.111624, -8.600660, 0, 115.110708, -8.602237, 0, 115.109332, -8.604943, 0, 115.108410, -8.607650, 0, 115.107487, -8.610584, 0, 115.106568, -8.612614, 0, 115.106107, -8.613968, 0, 115.105873, -8.615322, 0, 115.105410, -8.617128, 0, 115.105174, -8.618709, 0, 115.104258, -8.620287, 0, 115.104477, -8.621870, 0, 115.104702, -8.622323, 0, 115.104929, -8.622324, 0, 115.104015, -8.623450, 0, 115.100995, -8.628082, 0, 115.099895, -8.629767, 0, 115.096667, -8.634841, 0, 115.096809, -8.635140, 0, 115.097221, -8.636868, 0, 115.097687, -8.638191, 0, 115.098091, -8.638825, 0, 115.098899, -8.639507, 0, 115.099716, -8.640434, 0, 115.100410, -8.641124, 0, 115.101570, -8.641925, 0, 115.102844, -8.642953, 0, 115.104462, -8.643992, 0, 115.106773, -8.644338, 0, 115.109024, -8.644566, 0, 115.110360, -8.644961, 0, 115.111862, -8.645828, 0, 115.113426, -8.646857, 0, 115.114464, -8.647205, 0, 115.116898, -8.648583, 0, 115.119095, -8.650257, 0, 115.119571, -8.650693, 0, 115.122584, -8.653484, 0, 115.124596, -8.655536, 0, 115.127846, -8.658816, 0, 115.129463, -8.660017, 0, 115.131889, -8.661385, 0, 115.144998, -8.651007, 0, 115.145226, -8.650782, 0, 115.145682, -8.650558, 0, 115.145911, -8.650108, 0, 115.146367, -8.649884, 0, 115.146595, -8.649659, 0, 115.147052, -8.649209, 0, 115.147280, -8.648984, 0, 115.147736, -8.648534, 0, 115.147966, -8.648083, 0, 115.148422, -8.647633, 0, 115.148650, -8.647409, 0, 115.149107, -8.646959, 0, 115.149336, -8.646734, 0, 115.149565, -8.646283, 0, 115.150022, -8.645833, 0, 115.150251, -8.645382, 0, 115.150709, -8.644706, 0, 115.150937, -8.644481, 0, 115.151166, -8.644030, 0, 115.151395, -8.643580, 0, 115.151624, -8.643355, 0, 115.151853, -8.642904, 0, 115.152309, -8.642680, 0, 115.152539, -8.642229, 0, 115.152541, -8.641777, 0, 115.152996, -8.641553, 0, 115.153225, -8.641102, 0, 115.153455, -8.640651, 0, 115.153457, -8.640199, 0, 115.153685, -8.639974, 0, 115.153914, -8.639523, 0, 115.153916, -8.639297, 0, 115.154144, -8.639072, 0, 115.154146, -8.638620, 0, 115.154375, -8.638169, 0, 115.154605, -8.637719, 0, 115.154834, -8.637268, 0, 115.154836, -8.636816, 0, 115.155066, -8.636365, 0, 115.155067, -8.636139, 0, 115.155297, -8.635688, 0, 115.155299, -8.635236, 0, 115.1553, -8.635010, 0, 115.155302, -8.634558, 0, 115.155303, -8.634332, 0, 115.155533, -8.633881, 0, 115.155536, -8.633203, 0, 115.155539, -8.632525, 0, 115.155768, -8.632074, 0, 115.155771, -8.631622, 0, 115.1560, -8.631171, 0, 115.156002, -8.630719, 0, 115.156231, -8.630268, 0, 115.156461, -8.629817, 0, 115.156464, -8.629139, 0, 115.156692, -8.628914, 0, 115.156694, -8.628462, 0, 115.156696, -8.628236, 0, 115.156925, -8.627785, 0, 115.157154, -8.627334, 0, 115.157155, -8.627108, 0, 115.157385, -8.626648, 0, 115.157614, -8.626197, 0, 115.157842, -8.625972, 0, 115.158071, -8.625521, 0, 115.158074, -8.625069, 0, 115.158531, -8.624393, 0, 115.158760, -8.623942, 0, 115.158762, -8.623490, 0, 115.158992, -8.623039, 0, 115.159221, -8.622814, 0, 115.159450, -8.622363, 0, 115.159680, -8.621912, 0, 115.159908, -8.621688, 0, 115.160137, -8.621237, 0, 115.160366, -8.620786, 0, 115.160367, -8.620560, 0, 115.160597, -8.620109, 0, 115.160825, -8.619884, 0, 115.161053, -8.619659, 0, 115.161281, -8.619434, 0, 115.161283, -8.618982, 0, 115.161513, -8.618531, 0, 115.161742, -8.618080, 0, 115.162199, -8.617630, 0, 115.162427, -8.617405, 0, 115.162657, -8.616954, 0, 115.163114, -8.616278, 0, 115.163342, -8.616054, 0, 115.163571, -8.615829, 0, 115.164026, -8.615605, 0, 115.164709, -8.615156, 0, 115.164938, -8.614931, 0, 115.165167, -8.614706, 0, 115.165849, -8.614483, 0, 115.166077, -8.614258, 0, 115.166533, -8.614035, 0, 115.166989, -8.613585, 0, 115.167443, -8.613587, 0, 115.168126, -8.613364, 0, 115.168355, -8.613139, 0, 115.168582, -8.613140, 0, 115.169037, -8.612916, 0, 115.169491, -8.612919, 0, 115.170173, -8.612696, 0, 115.170857, -8.612473, 0, 115.171084, -8.612474, 0, 115.171539, -8.612250, 0, 115.171993, -8.612252, 0, 115.172448, -8.612255, 0, 115.173130, -8.612032, 0, 115.173584, -8.612034, 0, 115.174265, -8.612037, 0, 115.174949, -8.611814, 0, 115.175403, -8.611817, 0, 115.175857, -8.611819, 0, 115.176311, -8.611821, 0, 115.176766, -8.611823, 0, 115.177220, -8.611825, 0, 115.177675, -8.611827, 0, 115.178129, -8.611830, 0, 115.178583, -8.611832, 0, 115.179037, -8.611834, 0, 115.179491, -8.612062, 0, 115.179718, -8.612063, 0, 115.180171, -8.612291, 0, 115.180852, -8.612521, 0, 115.181078, -8.612748, 0, 115.181305, -8.612749, 0, 115.181758, -8.612977, 0, 115.182211, -8.613205, 0, 115.182437, -8.613432, 0, 115.182663, -8.613659, 0, 115.183116, -8.613887, 0, 115.184478, -8.614346, 0, 115.185386, -8.614350, 0, 115.189937, -8.612789, 0, 115.190164, -8.612790, 0, 115.190392, -8.612792, 0, 115.190619, -8.612793, 0, 115.190846, -8.612794, 0, 115.191073, -8.612795, 0, 115.1913, -8.612796, 0, 115.191527, -8.612797, 0, 115.191754, -8.612798, 0, 115.191981, -8.612799, 0, 115.192208, -8.6128, 0, 115.192436, -8.612801, 0, 115.192434, -8.613027, 0, 115.192662, -8.613028, 0, 115.192889, -8.613029, 0, 115.193116, -8.613030, 0, 115.193344, -8.613031, 0, 115.193571, -8.613033, 0, 115.193798, -8.613034, 0, 115.194025, -8.613035, 0, 115.194252, -8.613036, 0, 115.194479, -8.613037, 0, 115.194706, -8.613038, 0, 115.194934, -8.613039, 0, 115.195162, -8.612814, 0, 115.195389, -8.612815, 0, 115.195617, -8.612590, 0, 115.195845, -8.612365, 0, 115.196072, -8.612366, 0, 115.196301, -8.612141, 0, 115.196529, -8.611916, 0, 115.196758, -8.611691, 0, 115.196986, -8.611466, 0, 115.197214, -8.611241, 0, 115.197216, -8.610789, 0, 115.197443, -8.610791, 0, 115.197671, -8.610566, 0, 115.197901, -8.610115, 0, 115.197902, -8.609889, 0, 115.198130, -8.609664, 0, 115.198131, -8.609438, 0, 115.198359, -8.609213, 0, 115.198587, -8.608988, 0, 115.198588, -8.608762, 0, 115.198816, -8.608537, 0, 115.199045, -8.608312, 0, 115.199274, -8.608087, 0, 115.199275, -8.607861, 0, 115.199729, -8.607863, 0, 115.199957, -8.607638, 0, 115.200185, -8.607413, 0, 115.200412, -8.607414, 0, 115.200641, -8.607189, 0, 115.200868, -8.607190, 0, 115.201096, -8.606965, 0, 115.201323, -8.606966, 0, 115.201551, -8.606741, 0, 115.201779, -8.606516, 0, 115.202511, -8.605751, 0, 115.202239, -8.605614, 0, 115.202240, -8.605388, 0, 115.202013, -8.605161, 0, 115.201788, -8.604708, 0, 115.201789, -8.604482, 0, 115.201791, -8.604030, 0, 115.201565, -8.603803, 0, 115.201566, -8.603577, 0, 115.201341, -8.603124, 0, 115.201343, -8.602672, 0, 115.201344, -8.602446, 0, 115.201119, -8.601993, 0, 115.201120, -8.601767, 0, 115.200895, -8.601314, 0, 115.200442, -8.601085, 0, 115.200217, -8.600632, 0, 115.200218, -8.600406, 0, 115.199765, -8.600178, 0, 115.199539, -8.599951, 0, 115.199315, -8.599272, 0, 115.199090, -8.598819, 0, 115.199091, -8.598593, 0, 115.198866, -8.598140, 0, 115.198867, -8.597914, 0, 115.198642, -8.597461, 0, 115.198644, -8.597009, 0, 115.198418, -8.596782, 0, 115.198421, -8.596103, 0, 115.198422, -8.595868, 0, 115.198197, -8.595415, 0, 115.198199, -8.594963, 0, 115.197973, -8.594736, 0, 115.197975, -8.594284, 0, 115.197978, -8.593832, 0, 115.197980, -8.593380, 0, 115.197755, -8.592927, 0, 115.197757, -8.592475, 0, 115.197758, -8.592249, 0, 115.197533, -8.591796, 0, 115.197534, -8.591570, 0, 115.197537, -8.590892, 0, 115.197311, -8.590665, 0, 115.197313, -8.590213, 0, 115.197314, -8.589987, 0, 115.197090, -8.589533, 0, 115.197092, -8.589081, 0, 115.196866, -8.588854, 0, 115.196868, -8.588402, 0, 115.196643, -8.587949, 0, 115.196418, -8.587496, 0, 115.196420, -8.587044, 0, 115.196194, -8.586591, 0, 115.195969, -8.586138, 0, 115.195743, -8.585911, 0, 115.195745, -8.585459, 0, 115.195521, -8.584780, 0, 115.195522, -8.584554, 0, 115.195525, -8.584102, 0, 115.195527, -8.583650, 0, 115.195304, -8.582744, 0, 115.195306, -8.582292, 0, 115.195307, -8.582066, 0, 115.195082, -8.581613, 0, 115.195084, -8.581161, 0, 115.194859, -8.580708, 0, 115.194862, -8.580256, 0, 115.194863, -8.580030, 0, 115.194638, -8.579577, 0, 115.194640, -8.579125, 0, 115.194415, -8.578672, 0, 115.194190, -8.578219, 0, 115.194192, -8.577767, 0, 115.194193, -8.577541, 0, 115.193968, -8.577088, 0, 115.193970, -8.576636, 0, 115.193972, -8.576183, 0, 115.193748, -8.575730, 0, 115.193524, -8.575051, 0, 115.193298, -8.574598, 0, 115.193299, -8.574372, 0, 115.193302, -8.573694, 0, 115.193077, -8.573241, 0, 115.193078, -8.573015, 0, 115.193080, -8.572563, 0, 115.193084, -8.571885, 0, 115.192857, -8.571658, 0, 115.192861, -8.570980, 0, 115.192865, -8.570076, 0, 115.192867, -8.569624, 0, 115.192869, -8.569172, 0, 115.192644, -8.568718, 0, 115.192419, -8.568265, 0, 115.192422, -8.567813, 0, 115.192197, -8.567360, 0, 115.192199, -8.566908, 0, 115.191974, -8.566455, 0, 115.191976, -8.566003, 0, 115.191978, -8.565551, 0, 115.191753, -8.565098, 0, 115.191755, -8.564637, 0, 115.191757, -8.564185, 0, 115.191760, -8.563733, 0, 115.191536, -8.563054, 0, 115.191538, -8.562602, 0, 115.191540, -8.562150, 0, 115.191542, -8.561697, 0, 115.191543, -8.561471, 0, 115.191318, -8.561018, 0, 115.191320, -8.560566, 0, 115.191322, -8.560114, 0, 115.191552, -8.559663, 0, 115.191553, -8.559437, 0, 115.191555, -8.558985, 0, 115.191784, -8.558534, 0, 115.191785, -8.558308, 0, 115.191787, -8.557856, 0, 115.192017, -8.557405, 0, 115.192019, -8.556953, 0, 115.192022, -8.556275, 0, 115.192250, -8.556050, 0, 115.192252, -8.555598, 0, 115.192481, -8.555147, 0, 115.192482, -8.554921, 0, 115.192712, -8.554470, 0, 115.192714, -8.554018, 0, 115.192943, -8.553567, 0, 115.193172, -8.553116, 0, 115.193402, -8.552439, 0, 115.193634, -8.551762, 0, 115.193863, -8.551311, 0, 115.194091, -8.551086, 0, 115.194321, -8.550409, 0, 115.194323, -8.549957, 0, 115.194552, -8.549506, 0, 115.194782, -8.549055, 0, 115.195010, -8.548830, 0, 115.195239, -8.548379, 0, 115.195469, -8.547702, 0, 115.195698, -8.547251, 0, 115.195929, -8.546574, 0, 115.196158, -8.546123, 0, 115.196388, -8.545446, 0, 115.196845, -8.544996, 0, 115.197074, -8.544545, 0, 115.197304, -8.544094, 0, 115.197533, -8.543643, 0, 115.197762, -8.543192, 0, 115.198219, -8.542517, 0, 115.198448, -8.542066, 0, 115.198451, -8.541614, 0, 115.199134, -8.541165, 0, 115.199363, -8.540714, 0, 115.199593, -8.540263, 0, 115.199822, -8.539812, 0, 115.200051, -8.539361, 0, 115.200508, -8.538911, 0, 115.200509, -8.538685, 0, 115.200737, -8.538460, 0, 115.201193, -8.538010, 0, 115.201194, -8.537784, 0, 115.201424, -8.537107, 0, 115.201652, -8.536882, 0, 115.201882, -8.536431, 0, 115.202111, -8.535980, 0, 115.202340, -8.535529, 0, 115.202342, -8.535077, 0, 115.2028, -8.534401, 0, 115.202802, -8.533949, 0, 115.203032, -8.533489, 0, 115.203034, -8.533037, 0, 115.203263, -8.532586, 0, 115.203493, -8.531909, 0, 115.203494, -8.531683, 0, 115.203496, -8.531231, 0, 115.203726, -8.530780, 0, 115.203729, -8.530102, 0, 115.203959, -8.529425, 0, 115.203734, -8.528972, 0, 115.203963, -8.528521, 0, 115.203964, -8.528295, 0, 115.203966, -8.527843, 0, 115.203968, -8.527390, 0, 115.204196, -8.527165, 0, 115.204198, -8.526939, 0, 115.2042, -8.526487, 0, 115.204429, -8.526036, 0, 115.204431, -8.525584, 0, 115.204433, -8.525132, 0, 115.204435, -8.524680, 0, 115.204436, -8.524454, 0, 115.204438, -8.524002, 0, 115.204440, -8.523550, 0, 115.204214, -8.523323, 0, 115.204207, -8.522826, 0, 115.203990, -8.522870, 0, 115.203764, -8.522643, 0, 115.203538, -8.522416, 0, 115.203312, -8.522189, 0, 115.202857, -8.522187, 0, 115.202630, -8.522186, 0, 115.202175, -8.522184, 0, 115.201721, -8.522181, 0, 115.201267, -8.522179, 0, 115.200812, -8.522403, 0, 115.200358, -8.522401, 0, 115.200132, -8.522174, 0, 115.199678, -8.522172, 0, 115.198997, -8.521943, 0, 115.198544, -8.521715, 0, 115.198090, -8.521713, 0, 115.198092, -8.521261, 0, 115.197866, -8.521034, 0, 115.197641, -8.520580, 0, 115.197415, -8.520353, 0, 115.197190, -8.5199, 0, 115.196964, -8.519673, 0, 115.196738, -8.519446, 0, 115.196740, -8.518994, 0, 115.196514, -8.518541, 0, 115.196516, -8.518089, 0, 115.196292, -8.517636, 0, 115.196066, -8.517409, 0, 115.196069, -8.516731, 0, 115.196071, -8.516279, 0, 115.196072, -8.516053, 0, 115.196075, -8.515375, 0, 115.196076, -8.515166, 0, 115.196076, -8.515148, 0, 115.196078, -8.514696, 0, 115.196080, -8.514244, 0, 115.196084, -8.513566, 0, 115.196086, -8.513114, 0, 115.196316, -8.512437, 0, 115.196317, -8.512211, 0, 115.196319, -8.511759, 0, 115.196320, -8.511533, 0, 115.196321, -8.511307, 0, 115.196550, -8.510856, 0, 115.196551, -8.510630, 0, 115.196781, -8.510179, 0, 115.196782, -8.509953, 0, 115.196785, -8.509501, 0, 115.197015, -8.508824, 0, 115.197017, -8.508372, 0, 115.197019, -8.507920, 0, 115.197021, -8.507468, 0, 115.197022, -8.507242, 0, 115.197024, -8.506790, 0, 115.197252, -8.506565, 0, 115.197028, -8.506112, 0, 115.197258, -8.505435, 0, 115.197260, -8.504983, 0, 115.197488, -8.504758, 0, 115.197491, -8.504080, 0, 115.197493, -8.503628, 0, 115.197495, -8.503176, 0, 115.197723, -8.502951, 0, 115.197726, -8.502490, 0, 115.1975, -8.502263, 0, 115.197502, -8.501811, 0, 115.197732, -8.501134, 0, 115.197734, -8.500682, 0, 115.197738, -8.499777, 0, 115.197740, -8.499325, 0, 115.197744, -8.498647, 0, 115.197747, -8.497969, 0, 115.197748, -8.497743, 0, 115.197750, -8.497291, 0, 115.197753, -8.496613, 0, 115.197754, -8.496387, 0, 115.197757, -8.495709, 0, 115.197760, -8.495031, 0, 115.197764, -8.494353, 0, 115.197766, -8.493901, 0, 115.197768, -8.493449, 0, 115.197543, -8.492996, 0, 115.197545, -8.492544, 0, 115.197774, -8.492093, 0, 115.197776, -8.491641, 0, 115.197777, -8.491415, 0, 115.198006, -8.490964, 0, 115.198007, -8.490738, 0, 115.198009, -8.490512, 0, 115.198011, -8.490060, 0, 115.198013, -8.489608, 0, 115.198015, -8.489156, 0, 115.198017, -8.488703, 0, 115.198019, -8.488251, 0, 115.198023, -8.487347, 0, 115.194393, -8.486652, 0, 115.193719, -8.485067, 0, 115.193504, -8.482354, 0, 115.193736, -8.481225, 0, 115.193975, -8.478966, 0, 115.194909, -8.473319, 0, 115.195610, -8.469245, 0, 115.195864, -8.463370, 0, 115.194982, -8.457715, 0, 115.195452, -8.454327, 0, 115.196152, -8.450261, 0, 115.195490, -8.446190, 0, 115.192549, -8.443690, 0, 115.188926, -8.441639, 0, 115.186199, -8.442079, 0, 115.185062, -8.442525, 0, 115.183696, -8.443197, 0, 115.182553, -8.444774, 0, 115.181184, -8.446124, 0, 115.178681, -8.447468, 0, 115.176857, -8.448816, 0, 115.175026, -8.451972, 0, 115.174095, -8.456714, 0, 115.172950, -8.458969, 0, 115.172260, -8.460774, 0, 115.172706, -8.462584, 0, 115.1752, -8.463274, 0, 115.176785, -8.464185, 0, 115.176318, -8.466895, 0, 115.175161, -8.471419, 0, 115.174680, -8.477068, 0, 115.174671, -8.479102, 0))

Row 3

MDSYS.SDO_GEOMETRY(3003, 4326, null, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1), MDSYS.SDO_ORDINATE_ARRAY(115.209129, -8.243668, 0, 115.207992, -8.244115, 0, 115.206174, -8.244559, 0, 115.204815, -8.2441, 0, 115.200962, -8.242953, 0, 115.196877, -8.242709, 0, 115.194381, -8.242697, 0, 115.191655, -8.243137, 0, 115.188478, -8.243349, 0, 115.185073, -8.243333, 0, 115.182353, -8.242643, 0, 115.184836, -8.245593, 0, 115.187545, -8.248769, 0, 115.1898, -8.251944, 0, 115.190458, -8.256929, 0, 115.1893, -8.262122, 0, 115.188150, -8.265507, 0, 115.186547, -8.268438, 0, 115.184723, -8.270238, 0, 115.183579, -8.272267, 0, 115.184471, -8.275662, 0, 115.186278, -8.277704, 0, 115.186501, -8.278609, 0, 115.187848, -8.281780, 0, 115.188965, -8.285862, 0, 115.190773, -8.287453, 0, 115.191903, -8.288588, 0, 115.194394, -8.289729, 0, 115.197343, -8.289969, 0, 115.199828, -8.292692, 0, 115.201634, -8.294961, 0, 115.202982, -8.297905, 0, 115.204775, -8.303112, 0, 115.206342, -8.307866, 0, 115.206546, -8.312839, 0, 115.206062, -8.319401, 0, 115.205828, -8.320982, 0, 115.205581, -8.325501, 0, 115.204198, -8.330016, 0, 115.202140, -8.333397, 0, 115.199627, -8.336776, 0, 115.198704, -8.340162, 0, 115.199820, -8.344236, 0, 115.200492, -8.346273, 0, 115.200021, -8.349896, 0, 115.198417, -8.353279, 0, 115.197961, -8.353729, 0, 115.196586, -8.356209, 0, 115.196342, -8.360051, 0, 115.197238, -8.362541, 0, 115.198137, -8.364805, 0, 115.200611, -8.369789, 0, 115.203088, -8.374095, 0, 115.205343, -8.377496, 0, 115.206681, -8.382710, 0, 115.208690, -8.390178, 0, 115.208903, -8.393343, 0, 115.209122, -8.395152, 0, 115.209551, -8.400579, 0, 115.208397, -8.404642, 0, 115.208372, -8.410076, 0, 115.209711, -8.415054, 0, 115.211726, -8.421392, 0, 115.211950, -8.422071, 0, 115.212597, -8.429533, 0, 115.213707, -8.434963, 0, 115.213002, -8.440384, 0, 115.212766, -8.442201, 0, 115.2107, -8.446938, 0, 115.209093, -8.450773, 0, 115.207945, -8.453480, 0, 115.207027, -8.455736, 0, 115.208393, -8.454838, 0, 115.208846, -8.455066, 0, 115.209299, -8.455294, 0, 115.209526, -8.455295, 0, 115.209980, -8.455524, 0, 115.210433, -8.455752, 0, 115.210659, -8.455979, 0, 115.210885, -8.456206, 0, 115.211110, -8.456659, 0, 115.211336, -8.456886, 0, 115.211560, -8.457339, 0, 115.211785, -8.457792, 0, 115.211783, -8.458244, 0, 115.212008, -8.458697, 0, 115.212232, -8.459376, 0, 115.212458, -8.459603, 0, 115.212684, -8.460056, 0, 115.212910, -8.460284, 0, 115.213135, -8.460737, 0, 115.213134, -8.460963, 0, 115.213359, -8.461416, 0, 115.213585, -8.461643, 0, 115.214038, -8.461871, 0, 115.214263, -8.462324, 0, 115.214717, -8.462326, 0, 115.215170, -8.462554, 0, 115.215397, -8.462555, 0, 115.216080, -8.462332, 0, 115.216534, -8.462334, 0, 115.216762, -8.462109, 0, 115.217443, -8.462112, 0, 115.217671, -8.461887, 0, 115.217899, -8.461662, 0, 115.218126, -8.461664, 0, 115.218582, -8.461440, 0, 115.218810, -8.461215, 0, 115.219265, -8.460991, 0, 115.219493, -8.460766, 0, 115.219949, -8.460316, 0, 115.220177, -8.460091, 0, 115.220405, -8.459866, 0, 115.220634, -8.459415, 0, 115.220862, -8.459190, 0, 115.221092, -8.458739, 0, 115.221321, -8.458288, 0, 115.221551, -8.457611, 0, 115.221780, -8.457160, 0, 115.222009, -8.456709, 0, 115.222238, -8.456257, 0, 115.222468, -8.455806, 0, 115.222697, -8.455355, 0, 115.223016, -8.455086, 0, 115.222926, -8.454904, 0, 115.223154, -8.454679, 0, 115.223155, -8.454453, 0, 115.223383, -8.454228, 0, 115.223839, -8.453778, 0, 115.224068, -8.453327, 0, 115.224296, -8.453102, 0, 115.224751, -8.452879, 0, 115.224980, -8.452653, 0, 115.225436, -8.452430, 0, 115.225664, -8.452205, 0, 115.225891, -8.452206, 0, 115.226345, -8.452208, 0, 115.226799, -8.452210, 0, 115.227026, -8.452211, 0, 115.227480, -8.452213, 0, 115.227706, -8.452440, 0, 115.228159, -8.452668, 0, 115.228387, -8.452669, 0, 115.228613, -8.452896, 0, 115.229065, -8.453124, 0, 115.229291, -8.453351, 0, 115.229517, -8.453578, 0, 115.229743, -8.453805, 0, 115.236995, -8.457002, 0, 115.235643, -8.454736, 0, 115.232477, -8.452009, 0, 115.231137, -8.446805, 0, 115.229113, -8.442727, 0, 115.228899, -8.439779, 0, 115.228902, -8.4391, 0, 115.2296, -8.435487, 0, 115.230079, -8.430065, 0, 115.229648, -8.424864, 0, 115.229655, -8.423282, 0, 115.229658, -8.422830, 0, 115.229221, -8.418985, 0, 115.228566, -8.413332, 0, 115.228347, -8.411296, 0, 115.227911, -8.407443, 0, 115.227027, -8.402014, 0, 115.226368, -8.397264, 0, 115.225711, -8.392063, 0, 115.225504, -8.387315, 0, 115.226423, -8.385059, 0, 115.227338, -8.383481, 0, 115.229853, -8.379650, 0, 115.231227, -8.376935, 0, 115.232612, -8.372194, 0, 115.233994, -8.367680, 0, 115.235595, -8.3652, 0, 115.235371, -8.364521, 0, 115.235160, -8.360904, 0, 115.234712, -8.359546, 0, 115.234498, -8.356606, 0, 115.235646, -8.353673, 0, 115.238616, -8.349618, 0, 115.242267, -8.345330, 0, 115.246151, -8.339923, 0, 115.247766, -8.334053, 0, 115.247789, -8.328854, 0, 115.246435, -8.327040, 0, 115.244852, -8.325677, 0, 115.244864, -8.322965, 0, 115.246470, -8.319129, 0, 115.248301, -8.315964, 0, 115.249446, -8.313482, 0, 115.249458, -8.310770, 0, 115.249015, -8.308508, 0, 115.247894, -8.305338, 0, 115.247215, -8.304657, 0, 115.246539, -8.303524, 0, 115.245871, -8.300809, 0, 115.245431, -8.297642, 0, 115.244765, -8.294249, 0, 115.243871, -8.291080, 0, 115.243662, -8.287011, 0, 115.244138, -8.282031, 0, 115.244616, -8.276609, 0, 115.245999, -8.271868, 0, 115.247379, -8.267579, 0, 115.247380, -8.267353, 0, 115.248309, -8.262837, 0, 115.249006, -8.259223, 0, 115.248566, -8.256057, 0, 115.246985, -8.254016, 0, 115.244493, -8.253091, 0, 115.241317, -8.252625, 0, 115.240191, -8.250812, 0, 115.240203, -8.2481, 0, 115.239084, -8.244478, 0, 115.235916, -8.242430, 0, 115.233202, -8.240158, 0, 115.231165, -8.238793, 0, 115.231164, -8.239019, 0, 115.225941, -8.239674, 0, 115.222989, -8.240113, 0, 115.219584, -8.240550, 0, 115.217084, -8.241217, 0, 115.213447, -8.242331, 0, 115.210722, -8.242771, 0, 115.209129, -8.243668, 0))

Row 4

MDSYS.SDO_GEOMETRY(3003, 4326, null, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1), MDSYS.SDO_ORDINATE_ARRAY(115.152256, -8.685108, 0, 115.156423, -8.684296, 0, 115.160515, -8.683638, 0, 115.163015, -8.683650, 0, 115.167103, -8.683896, 0, 115.169375, -8.683907, 0, 115.170738, -8.684139, 0, 115.172782, -8.684149, 0, 115.174598, -8.684610, 0, 115.176866, -8.685299, 0, 115.179136, -8.685762, 0, 115.180952, -8.686222, 0, 115.183221, -8.686911, 0, 115.185036, -8.687372, 0, 115.185037, -8.687146, 0, 115.184588, -8.686240, 0, 115.184361, -8.686012, 0, 115.184364, -8.685560, 0, 115.184365, -8.685334, 0, 115.184139, -8.685107, 0, 115.184141, -8.684655, 0, 115.183915, -8.684428, 0, 115.183917, -8.683976, 0, 115.183918, -8.683750, 0, 115.183692, -8.683523, 0, 115.183693, -8.683297, 0, 115.183694, -8.683071, 0, 115.183468, -8.682844, 0, 115.183469, -8.682618, 0, 115.183470, -8.682392, 0, 115.183245, -8.681939, 0, 115.183246, -8.681713, 0, 115.183249, -8.681261, 0, 115.183250, -8.681035, 0, 115.183251, -8.680809, 0, 115.183024, -8.680582, 0, 115.183025, -8.680355, 0, 115.1828, -8.679902, 0, 115.182801, -8.679676, 0, 115.182802, -8.679450, 0, 115.182804, -8.678998, 0, 115.182805, -8.678772, 0, 115.182579, -8.678545, 0, 115.182581, -8.678093, 0, 115.182583, -8.677867, 0, 115.182357, -8.677640, 0, 115.182359, -8.677188, 0, 115.182361, -8.676736, 0, 115.182362, -8.676510, 0, 115.182363, -8.676284, 0, 115.182364, -8.676058, 0, 115.182367, -8.675380, 0, 115.182141, -8.675153, 0, 115.182144, -8.674701, 0, 115.182146, -8.674249, 0, 115.182148, -8.673797, 0, 115.182150, -8.673345, 0, 115.182151, -8.673119, 0, 115.181926, -8.672666, 0, 115.182156, -8.672215, 0, 115.182157, -8.671989, 0, 115.181932, -8.671535, 0, 115.181934, -8.671083, 0, 115.181936, -8.670631, 0, 115.181938, -8.670179, 0, 115.181940, -8.669727, 0, 115.181943, -8.669275, 0, 115.181945, -8.668823, 0, 115.181947, -8.668371, 0, 115.181949, -8.667919, 0, 115.181950, -8.667693, 0, 115.181951, -8.667467, 0, 115.181953, -8.667015, 0, 115.181954, -8.666789, 0, 115.181957, -8.666337, 0, 115.181959, -8.665885, 0, 115.181961, -8.665433, 0, 115.181963, -8.664981, 0, 115.181964, -8.664755, 0, 115.181966, -8.664303, 0, 115.182196, -8.663852, 0, 115.182198, -8.6634, 0, 115.1822, -8.662948, 0, 115.182201, -8.662722, 0, 115.182430, -8.662271, 0, 115.182431, -8.662045, 0, 115.182433, -8.661819, 0, 115.182663, -8.661142, 0, 115.182665, -8.660690, 0, 115.182894, -8.660239, 0, 115.182897, -8.659787, 0, 115.183126, -8.659336, 0, 115.183127, -8.659110, 0, 115.183130, -8.658432, 0, 115.183131, -8.658206, 0, 115.183362, -8.657746, 0, 115.183364, -8.657294, 0, 115.183366, -8.656842, 0, 115.183368, -8.656390, 0, 115.183369, -8.656164, 0, 115.183142, -8.655937, 0, 115.183145, -8.655259, 0, 115.183147, -8.655033, 0, 115.183149, -8.654581, 0, 115.183150, -8.654355, 0, 115.183151, -8.654128, 0, 115.183153, -8.653676, 0, 115.183155, -8.653224, 0, 115.183157, -8.652772, 0, 115.183158, -8.652546, 0, 115.182935, -8.651867, 0, 115.182937, -8.651415, 0, 115.182938, -8.651189, 0, 115.182940, -8.650737, 0, 115.182942, -8.650285, 0, 115.182944, -8.649833, 0, 115.182945, -8.649607, 0, 115.182948, -8.649155, 0, 115.182950, -8.648703, 0, 115.182953, -8.648025, 0, 115.182954, -8.647799, 0, 115.182955, -8.647573, 0, 115.182956, -8.647347, 0, 115.182958, -8.646895, 0, 115.182961, -8.646443, 0, 115.182963, -8.645991, 0, 115.182965, -8.645539, 0, 115.182967, -8.645087, 0, 115.182968, -8.644861, 0, 115.182970, -8.644409, 0, 115.182744, -8.644182, 0, 115.182748, -8.643504, 0, 115.182749, -8.643278, 0, 115.182751, -8.642826, 0, 115.182753, -8.642373, 0, 115.182755, -8.641921, 0, 115.182757, -8.641469, 0, 115.182758, -8.641243, 0, 115.182761, -8.640791, 0, 115.182763, -8.640339, 0, 115.182765, -8.639887, 0, 115.182767, -8.639435, 0, 115.182770, -8.638757, 0, 115.182772, -8.638305, 0, 115.182776, -8.637627, 0, 115.183006, -8.636950, 0, 115.183008, -8.636498, 0, 115.183010, -8.636046, 0, 115.183013, -8.635594, 0, 115.183015, -8.635142, 0, 115.183017, -8.634690, 0, 115.183019, -8.634238, 0, 115.183020, -8.634012, 0, 115.183021, -8.633786, 0, 115.183023, -8.633334, 0, 115.183026, -8.632882, 0, 115.183028, -8.632430, 0, 115.183030, -8.631978, 0, 115.183031, -8.631752, 0, 115.183032, -8.631526, 0, 115.183034, -8.631074, 0, 115.183036, -8.630622, 0, 115.183039, -8.630170, 0, 115.183040, -8.629944, 0, 115.183042, -8.629492, 0, 115.183043, -8.629266, 0, 115.183045, -8.628813, 0, 115.183046, -8.628588, 0, 115.183048, -8.628135, 0, 115.183051, -8.627457, 0, 115.183053, -8.627231, 0, 115.183282, -8.626771, 0, 115.183284, -8.626319, 0, 115.183286, -8.625867, 0, 115.183288, -8.625415, 0, 115.183291, -8.624963, 0, 115.183292, -8.624737, 0, 115.183522, -8.624286, 0, 115.183523, -8.624060, 0, 115.183525, -8.623608, 0, 115.183527, -8.623156, 0, 115.183529, -8.622704, 0, 115.183530, -8.622478, 0, 115.183532, -8.622252, 0, 115.183534, -8.6218, 0, 115.183536, -8.621348, 0, 115.183537, -8.621122, 0, 115.183311, -8.620669, 0, 115.183312, -8.620443, 0, 115.183542, -8.619992, 0, 115.183543, -8.619766, 0, 115.183544, -8.619540, 0, 115.183547, -8.619088, 0, 115.183548, -8.618862, 0, 115.183550, -8.618410, 0, 115.183778, -8.618185, 0, 115.183779, -8.617959, 0, 115.183781, -8.617507, 0, 115.183782, -8.617281, 0, 115.184011, -8.617056, 0, 115.184012, -8.616830, 0, 115.184013, -8.616604, 0, 115.184242, -8.616153, 0, 115.184702, -8.615025, 0, 115.185386, -8.614350, 0, 115.184478, -8.614346, 0, 115.183116, -8.613887, 0, 115.182663, -8.613659, 0, 115.182437, -8.613432, 0, 115.182211, -8.613205, 0, 115.181758, -8.612977, 0, 115.181305, -8.612749, 0, 115.181078, -8.612748, 0, 115.180852, -8.612521, 0, 115.180171, -8.612291, 0, 115.179718, -8.612063, 0, 115.179491, -8.612062, 0, 115.179037, -8.611834, 0, 115.178583, -8.611832, 0, 115.178129, -8.611830, 0, 115.177675, -8.611827, 0, 115.177220, -8.611825, 0, 115.176766, -8.611823, 0, 115.176311, -8.611821, 0, 115.175857, -8.611819, 0, 115.175403, -8.611817, 0, 115.174949, -8.611814, 0, 115.174265, -8.612037, 0, 115.173584, -8.612034, 0, 115.173130, -8.612032, 0, 115.172448, -8.612255, 0, 115.171993, -8.612252, 0, 115.171539, -8.612250, 0, 115.171084, -8.612474, 0, 115.170857, -8.612473, 0, 115.170173, -8.612696, 0, 115.169491, -8.612919, 0, 115.169037, -8.612916, 0, 115.168582, -8.613140, 0, 115.168355, -8.613139, 0, 115.168126, -8.613364, 0, 115.167443, -8.613587, 0, 115.166989, -8.613585, 0, 115.166533, -8.614035, 0, 115.166077, -8.614258, 0, 115.165849, -8.614483, 0, 115.165167, -8.614706, 0, 115.164938, -8.614931, 0, 115.164709, -8.615156, 0, 115.164026, -8.615605, 0, 115.163571, -8.615829, 0, 115.163342, -8.616054, 0, 115.163114, -8.616278, 0, 115.162657, -8.616954, 0, 115.162427, -8.617405, 0, 115.162199, -8.617630, 0, 115.161742, -8.618080, 0, 115.161513, -8.618531, 0, 115.161283, -8.618982, 0, 115.161281, -8.619434, 0, 115.161053, -8.619659, 0, 115.160825, -8.619884, 0, 115.160597, -8.620109, 0, 115.160367, -8.620560, 0, 115.160366, -8.620786, 0, 115.160137, -8.621237, 0, 115.159908, -8.621688, 0, 115.159680, -8.621912, 0, 115.159450, -8.622363, 0, 115.159221, -8.622814, 0, 115.158992, -8.623039, 0, 115.158762, -8.623490, 0, 115.158760, -8.623942, 0, 115.158531, -8.624393, 0, 115.158074, -8.625069, 0, 115.158071, -8.625521, 0, 115.157842, -8.625972, 0, 115.157614, -8.626197, 0, 115.157385, -8.626648, 0, 115.157155, -8.627108, 0, 115.157154, -8.627334, 0, 115.156925, -8.627785, 0, 115.156696, -8.628236, 0, 115.156694, -8.628462, 0, 115.156692, -8.628914, 0, 115.156464, -8.629139, 0, 115.156461, -8.629817, 0, 115.156231, -8.630268, 0, 115.156002, -8.630719, 0, 115.1560, -8.631171, 0, 115.155771, -8.631622, 0, 115.155768, -8.632074, 0, 115.155539, -8.632525, 0, 115.155536, -8.633203, 0, 115.155533, -8.633881, 0, 115.155303, -8.634332, 0, 115.155302, -8.634558, 0, 115.1553, -8.635010, 0, 115.155299, -8.635236, 0, 115.155297, -8.635688, 0, 115.155067, -8.636139, 0, 115.155066, -8.636365, 0, 115.154836, -8.636816, 0, 115.154834, -8.637268, 0, 115.154605, -8.637719, 0, 115.154375, -8.638169, 0, 115.154146, -8.638620, 0, 115.154144, -8.639072, 0, 115.153916, -8.639297, 0, 115.153914, -8.639523, 0, 115.153685, -8.639974, 0, 115.153457, -8.640199, 0, 115.153455, -8.640651, 0, 115.153225, -8.641102, 0, 115.152996, -8.641553, 0, 115.152541, -8.641777, 0, 115.152539, -8.642229, 0, 115.152309, -8.642680, 0, 115.151853, -8.642904, 0, 115.151624, -8.643355, 0, 115.151395, -8.643580, 0, 115.151166, -8.644030, 0, 115.150937, -8.644481, 0, 115.150709, -8.644706, 0, 115.150251, -8.645382, 0, 115.150022, -8.645833, 0, 115.149565, -8.646283, 0, 115.149336, -8.646734, 0, 115.149107, -8.646959, 0, 115.148650, -8.647409, 0, 115.148422, -8.647633, 0, 115.147966, -8.648083, 0, 115.147736, -8.648534, 0, 115.147280, -8.648984, 0, 115.147052, -8.649209, 0, 115.146595, -8.649659, 0, 115.146367, -8.649884, 0, 115.145911, -8.650108, 0, 115.145682, -8.650558, 0, 115.145226, -8.650782, 0, 115.144998, -8.651007, 0, 115.131889, -8.661385, 0, 115.132011, -8.661458, 0, 115.132560, -8.661696, 0, 115.133453, -8.662089, 0, 115.135536, -8.663528, 0, 115.136528, -8.664382, 0, 115.138092, -8.665818, 0, 115.139191, -8.666339, 0, 115.139709, -8.666685, 0, 115.140114, -8.666859, 0, 115.140343, -8.667086, 0, 115.140518, -8.667376, 0, 115.140694, -8.667775, 0, 115.140640, -8.668118, 0, 115.140465, -8.668696, 0, 115.140640, -8.669673, 0, 115.141624, -8.670591, 0, 115.142339, -8.671444, 0, 115.143021, -8.672261, 0, 115.144470, -8.673986, 0, 115.146132, -8.675992, 0, 115.146904, -8.676918, 0, 115.147988, -8.678451, 0, 115.148125, -8.678642, 0, 115.148819, -8.680028, 0, 115.151840, -8.684509, 0, 115.152256, -8.685108, 0))"

Thanks before.

MapBuilder_Preview.png (36 KB)

Troy · March 22, 2016, 11:21am

Hi Syarief,

Thanks for your data, I noticed your oracle data is building under three-dimensional (we can see it as the SDO type is 3003.).
However, map suite OracleFeatureLayer doesn’t support three-dimensional data currently and I am guessing that results map suite can’t convert the oracle data to map suite feature.

Currently, I submit this issue into our issue system and our development team will work on it once we have enough resources. Before we figure out a solution for that, a temporary solution I suppose is there are some ways for us to convert two-dimensional to three-dimensional data and then import it into oracle.

In order to speed the fix up, would you mind to share your shape file or export the oracle data with us? you can send them to forumsupport@thinkgeo.com via email if the data is not too big, or you can upload it under your ftp after you contact support@thinkgeo.com and they will setup a ftp account for you.

Thanks,

Troy

Syarief · March 22, 2016, 11:21am

Hi Troy,

yes it was changed to 3D by the Oracle Map Builder, I don’t know how their logic to export shapefile into spatial data, but that’s what I got using MapBuilder.

I have sent shapefile and data to forumsupport@thinkgeo.com.

Thanks.

Syarief · March 22, 2016, 11:21am

Hi Troy,

I make my own migrator for shapefile to oracle spatial in 2D, but still below code doesn’t return the correct value (neither line 7 or 8) for the bounding box.

01.ManagedProj4Projection _mapProjection = new ManagedProj4Projection(Proj4Projection.GetEpsgParametersString(4326),
02.Proj4Projection.GetGoogleMapParametersString());
03.
04.OracleFeatureLayer _spatialLayer = new OracleFeatureLayer();
05._spatialLayer.FeatureSource.Projection = _mapProjection;
06._spatialLayer.Open();
07.string boundingBoxOracle = _spatialLayer.GetBoundingBox().GetWellKnownText();
08.string boundingBoxOracle1 = _spatialLayer.FeatureSource.GetBoundingBox().GetWellKnownText();
09._spatialLayer.Close();

But when I make a slight changes to my code,

01.ManagedProj4Projection _mapProjection = new ManagedProj4Projection(Proj4Projection.GetEpsgParametersString(4326),
02.Proj4Projection.GetGoogleMapParametersString());
03.
04.OracleFeatureLayer _spatialLayer = new OracleFeatureLayer();
05._spatialLayer.FeatureSource.Projection = _mapProjection;
06._spatialLayer.Open();
07.Collection<Feature> _allFeatures = _spatialLayer.FeatureSource.GetAllFeatures();
08.
09.InMemoryFeatureLayer _copiedLayer = new InMemoryFeatureLayer();
10._copiedLayer.FeatureSource.Projection = _mapProjection;
11._copiedLayer.Open();
12._copiedLayer.EditTools.BeginTransaction();
13.
14.for (int i = 0; i < _allFeatures.Count; i++)
15.{
16. _copiedLayer.EditTools.Add(_allFeatures<i>);
17.}
18.
19._copiedLayer.EditTools.CommitTransaction();
20._result.WellKnownText = _copiedLayer.GetBoundingBox().GetWellKnownText();
21._copiedLayer.Close();
22.
23._spatialLayer.Close();

it works, and the map shows perfectly.

But, the thing is I think above codes is consuming more time and memory and I don’t want that.

Thanks.

Troy · March 22, 2016, 11:21am

Hi Syarief,

We downloaded Oracle Map Builder, finally we found the reason why we always get the world extent is because Oracle Map Builder don’t set the bounding box as imported layer's boundingbox but use the world extent by default. So, Oracle layer will always get the world extent as its bounding box. I am not familiar with Map Builder very well and I have no idea why it will give a world extent for the imported layer as its boundingbox, but I will keep doing investigations on the exact reason.

I think there are two options .

a)Save the bounding box of the original shapefile, when map loaded and then set this value to Map’s CurrentExtent property. The oracle layer will be rendered.

b)Using other tools to import the shape file to oracle. We test a tool named shp2sdo and it works fine in our end.

Any question please don’t hesitate to let us know.

Thanks,

Troy

Syarief · March 22, 2016, 11:21am

Hi Troy,

I’m not an expert in Oracle Spatial, now I’m still exploring what it has.

From what you said, if I understand you right, then I assume that Oracle saves its spatial table boundingBox in another table? may I know what table? and do I have to recalculate and update boundingBox every time I add new feature or edit an existing one? or does Oracle has its internal mechanism for updating the table boundingBox?

Thanks.

Troy · March 22, 2016, 11:21am

Hi Syarief,

I checked it and we get the bounding box from the system-view USER_SDO_GEOM_METADATA. The statement is like the below:

DECLARE v_outer PLS_INTEGER;boundingBox VARCHAR(200);point01_X NUMBER;point01_Y NUMBER;point02_X NUMBER;point02_Y NUMBER;metaData USER_SDO_GEOM_METADATA.DIMINFO%TYPE;BEGIN SELECT DIMINFO INTO metaData FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME=‘TableName’;v_outer := metaData.FIRST;point01_X := metaData(v_outer).SDO_LB;point02_X := metaData(v_outer).SDO_UB;v_outer := metaData.NEXT(v_outer);point02_Y := metaData(v_outer).SDO_LB;point01_Y := metaData(v_outer).SDO_UB;:X1 := point01_X;:Y1 := point01_Y;:X2 := point02_X;:Y2 := point02_Y;END;

Here is a link on this view and document says

USER_SDO_GEOM_METADATA contains metadata information for all spatial tables owned by the user (schema). This is the only view that you can update, and it is the one in which Spatial users must insert metadata related to spatial tables.

From the above comment we can know it can be edit. But, in map suite OracleFeatureLayer, we didn’t update the view after the adding or delete the features. Now, I have submit this enhancement in our issue system and I guess we will do it if it pass the evaluation and the resource is enough.

I did another investigation on the Oracle Internal mechanism to update the bouningbox but didn’t find. There is a related link: docs.oracle.com/cd/B19306_01…4730

Hope it helps.

Thanks,Troy