View on GitHub

FME Oracle to GitHub

FME code for updating geographic information from Oracle database to GitHub

Download this project as a .zip file Download this project as a tar.gz file

Icono Sharing Open Data on GitHub using FME tool

We use FME based tool to automatically update geographical git repositories. For that purpose, we designed a workbench with FME to create GeoJSON files from different spatial formats (Oracle database table in our workbench) and host them in a GitHub repository.

GitHub allows us to store our open data and use as a collaborative mapping framework where users can contribute to the edition of the GeoJSON files (geojson.io, Chrome extension). This has huge implications for data collaboration.

The workbench exports Oracle tables to geoJSON, uses the git version control system to manage the versions of the files and the inclusion in Github.

In GitHub repository there is a layer list file FeatureTypesToRead.txt defining which Oracle tables are read and ultimately translated to geoJSON. FME reads the layer list from GitHub using Python Scripted parameter (git pull).

workbench image 1

workbench image 2

FME commits updated geoJSON files to GitHub in Shutdown TCL script (git push).

The project was presented in the FME International User Conference 2014

More information about IDErioja project is available at:
www.iderioja.org
@iderioja