Importing Oracle Spatial Data

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

Note: 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:

• Polygons where the boundary is connected by arcs or is a circle
• Compound Polygons
• Complex Collections