OracleSpatial

Introduction

Oracle Spatial is an advanced feature of the Oracle database that allows store and process spatial data.

Configuration

This section describes configuration parameters used in OracleSpatial data source provider. They are:

Parameter NameValue TypeDescriptionRequired
ConnectionStringDefines the string used to open an Oracle database.Yes
GeometryColumnStringDetermines a spatial column that contains data of a spatial data type (e.g., geometry or geography).Yes
QueryStringThe query used to select data from a database.Yes
OwnerStringThe owner of the retrieved data set.No
ExtentStringSets the extent of spatial data in a table. It is used by MapSurfer.NET Studio to speed up Zoom To Layer function.No

IMPORTANT:

OracleSpatial plugin requires Oracle Data Provider for .NET (see also Nuget package to be installed on a computer. You can also install the required assemblies manually by copying Oracle.ManagedDataAccess.dll assembly into MapSurfer.NET_Installation_Folder\Core\Plugins\Providers\MsSQLSpatial. Dynamic link libraries Oracle.ManagedDataAccessDTC.dll and Oracle.ManagedDataAccessIOP.dll need to be copied into Native.x64 (for 64-bit OS) or Native.x86 (for 32-bit OS) directory respectively.

This provider is available since v2.6.

OGR is another data source provider that can access spatial data from Oracle.