0

We have a system built using an Oracle database with geographical informations (latitude/longitude) but without spatial extensions (Locator). We would like to connect a GeoServer to it in order to deliver WFS services (i.e. physical values measured at some coordinates). Is it possible to adapt a GeoServer for such a database access?

Our system delivers also REST web services able to give this same latitude/longitude/value information.

Can GeoServer translate it to WFS service?

  • I suppose that you do not want to use Locator even it is free and would make working with GeoServer rather simple. – user30184 Jun 14 '18 at 7:39
  • Unfortunately, years ago the DBA chose not to install Locator to this product. Since then all upgrades do not contain it, nor Oracle Multimedia, JAVAVM, etc. – Alex Jun 14 '18 at 9:13
2

You can do both by writing your own data store: http://docs.geotools.org/latest/userguide/tutorial/datastore/index.html

Once it's ready, drop its jar and eventual dependencies inside GeoServer own WEB-INF/lib directory, restart, and you'll be able to configure the store and use it (assuming it's properly implemented, of course)

For the Oracle with lat/lon columns, I would probably write a wrapper around an existing JDBC based store, transforming queries hitting the store to checks over the lat/lon columns based on the following classes:

In case coding is a problem, or you find the process hard, you can also check commercial support

1

Another approach for the Oracle database would be to use a PostGIS foreign-data wrapper, and then add the PostGIS table to GeoServer. I've no idea how slow that would be though.

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.