Importing Oracle Spatial Data
This topic contains information on the Oracle spatial data types supported for import via the Open Data Import Centre.
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