Oracle - Exporting to Non UK Coordinate Systems

SIS Desktop uses a lookup file (ini file) to match coordinate systems between Oracle and SIS Desktop. This file can be located at:

C:\Program Files\Cadcorp SIS Desktop 9.1\COM\CadcorpOracleSpatialDataset.ini

The ini file matches coordinate systems from Cadcorp SIS Desktop 9.1 using the EPSG code to Oracle's SRID.

The ini file by default only matches commonly used coordinate systems, however, it is possible to modify the ini file and add additional coordinate systems.

The file will need to be modified in the following situations:

  1. when reading data from Oracle if Cadcorp SIS Desktop 9.1 is unable to identify the SRID for the spatial layer.

  2. when exporting data to Oracle and Cadcorp SIS Desktop 9.1 is unable to find the matching coordinate system in Oracle.

Modifying the ini file

The file is divided into two sections:

  1. [FromOracle]
  2. [ToOracle]

[FromOracle]

This section allows Cadcorp SIS Desktop 9.1 to match coordinate systems when reading data from Oracle. The format of each entry is:

SRID = EPSG

e.g. 81989 = 27700

[ToOracle]

This section allows Cadcorp SIS Desktop 9.1 to match coordinate systems when exporting data to Oracle. The format of each entry is:

EPSG = SRID

e.g. 27700 = 81989