Importing Oracle Spatial Data

This topic contains information on the Oracle spatial data types supported for import via the Open Data Import Centre.

Oracle Supported Versions

To import Oracle spatial data, a minimum version of Oracle 9.2 is required.

Spatial Geometries Supported for Import

The following Oracle spatial geometries are supported for import:

Spatial Data Type

Import Comment

Point

-

Oriented Point

Orientation vector is ignored

Multi-Point

First point only imported

Point Cluster

First point only imported

Line String

Line strings where points are connected by arcs are converted to straight lines with multiple points added along the arc.

Compound Line String Arc lines are converted to straight lines and the straight lines are imported as a normal line string.

Polygon

Supported where the boundary is connected only by straight lines or where it is a rectangle

Multi-Polygon

First polygon (connected by straight lines or a rectangle) only imported

Collection

First compatible element only imported (if present)

The following Oracle spatial geometries are partially supported for import:

Spatial Data Type

Import Comment

Multi-Line String

First line string only imported

Spatial Geometries Not Supported for Import

The following Oracle spatial geometries are not currently supported for import:

Open Data Import Centre

Open Data Import Centre - Advanced Features