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


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


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.