Data Converter - Oracle Spatial to GeoJson

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

Data Converter - Oracle Spatial to GeoJson

This project is to convert data from Oracle Spatial to GeoJson.

Features:

------------

Export a specified Oracle Table with geometry column to a GeoJson file

Source code should be written in Java

It should use the latest Oracle JDBC driver (12C)

Code should be able to handle all geometry feature types Point, Line, Polygon, MultiPoint, MultiLine, MultiPolygon

Code should be able to handle all data types integer, double, varchar, date, datetime, geometry (all types)

Generated GeoJson file should be standard GeoJson file that should be opening in any GIS viewer. Test it on QGIS.

This should be developed as library to be used by some other code

This should be able to handle large number of records (5 million)

Requirements to be selected to do the project:

Must have a development environment with Oracle Server loaded with some sample spatial data.

Sample code

---------------------

String dbName = “mydata”;

String dbPort = 5151;

String dbUser = “someuser”;

String dbPassword = “somepassword”;

String tableName = “countries”;

String geoJsonFile= “C:/temp/[login to view URL]”;

OracleSpatialConverter converter = new OracleSpatialConverter();

[login to view URL](dbName, dbPort, dbUser, dbPassword);

[login to view URL](tableName,geoJsonFile);

String tableName = “provinces”;

String geoJsonFile= “C:/temp/[login to view URL]”;

[login to view URL](tableName,geoJsonFile);

Please only apply if you have done any projects in this nature.

Geospatial Java Oracle Software Architecture

Project ID: #12301407

About the project

13 proposals Remote project Active 7 years ago