Data Converter - Oracle Spatial to GeoJson
$250-750 CAD
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.
Project ID: #12301407