This includes a multi-tab excel spreadsheet import with on-screen validation, shapefile uploads and a well documented REST API allowing scientists to import and update data programatically and export it to track changes.

Such a complex database with tables for habitats, ecosystems, species and much more relating to each site, required a lot of validators, unit tests and database queries but we worked to make the system sit neatly in the existing code base. This meant that sites assessed or re-assessed via the user interface worked the same way as the importer without the validation falling out of sync.

We also built an integration with their ESRI mapping server to pull data from ESRI into a self-hosted PostGIS database.