Seeking common interface for ST_Geometry SDO_Geomtry

Question

I've worked a fair bit with Oracle Spatial and I've had some requests to transition to PostgreSQL Spatial.

Is there a common interface for SDO_Geometry and ST_Geometry? I'm working in Java with EclipseLink ORM.

Ian Turton · Accepted Answer · 2011-02-01 15:33:44Z

2

GeoTools http://geotools.org provides PostGIS and OracleSpatial datastores which will abstract away the differences.

answered Feb 1, 2011 at 15:33

Ian Turton

83.2k6 gold badges89 silver badges189 bronze badges

Add a comment |

Glorfindel · Accepted Answer · 2022-08-24 13:13:59Z

2

OGR supports both Oracle Spatial and PostGIS and there are Java bindings for OGR. Maybe OGR's ogr2ogr can help.

Glorfindel

1,0962 gold badges10 silver badges15 bronze badges

answered Jan 31, 2011 at 23:03

underdark

84.5k22 gold badges233 silver badges415 bronze badges

Add a comment |

2 Answers 2