top of page

Request for Tender

Project: Cloud-Based Database for Camera Trap Data

Lion Landscapes, a leading conservation organisation, is inviting tenders for the development of a cloud-based hierarchical SQL database to store and manage camera trap data. This project aims to migrate existing and historical data from Google Sheets to a centralised and accessible cloud database.

Project Scope

  1. Cloud Server Selection:

    • Evaluate and select a reliable cloud server provider (e.g., AWS).

  2. Database Development:

    • Develop a PostgreSQL database to house camera trap data.

    • Design a hierarchical structure with fields such as photograph ID, date/time, species present, camera location, and image link.

    • Implement QAQC rules for data consistency.

  3. Data Migration:

    • Transfer data from Google Sheets to the new database

    • Apply QAQC rules to clean and validate data.

  4. R Package Development:

    • Create an R package to interact with the database for data upload, QAQC, summary, and export functions.

Deliverables

  1. Access credentials and 12 months of online PostgreSQL database access.

  2. R package with detailed documentation and example usage.

  3. Personalised setup and usage instructions via Zoom.

  4. Routine maintenance and bug-fixes for 12 months.

  5. Instructions for PostgreSQL access from Excel.

Requirements

  • Proven experience in cloud database development.

  • Expertise in PostgreSQL and R programming.

  • Familiarity with ecological data management

Proposal Submission

Submit your proposals to hr@lionlandscapes.org including a summary of your approach, timeline, and a tentative budget.

​

Submission deadline: 31 August 2024

bottom of page