4

I use Oracle MapViewer to generate my mapping data and currently I'm using an Oracle database as my spatial back-end. I would like to move my data over the PostGIS but I can't find any references if Oracle MapViewer actually supports PostGIS.

So my question is? Is there out of the box support for PostGIS? Would I have to write my own custom spatial data provider?

  • 3
    MapViewer is specifically built for Oracle Spatial. It not as good as one wishes. Geoserver was a better option in our workplace. – Mapperz Jan 10 '13 at 22:18
  • @Mapperz Hmmm... not good to hear. Sadly we already have a lot invested in MapViewer. – Mark Robinson Jan 11 '13 at 0:19
1

There is no support for PostGIS in Oracle MapViewer, AFAIK.

MapViewer relies on Oracle Spatial, their SDO_GEOMETRY type and Oracle SQL syntax dialect. MDSYS database schema is full of Oracle-specific GIS metadata, custom types etc. which cannot be easily ported to another database engine.
It uses JDBC to connect to database, which could theoretically allow it to connect to a non-Oracle server too, but it's not enough.

  • I know MapViewer has an alternative spatial provider interface but I think it's more intended for things like Shapefiles to supplement an Oracle installation. I ended up going with GeoServer. – Mark Robinson Jan 23 '13 at 16:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.