MONICA COP.DB

The MONICA COP.DB is the database schema used for the COP.API

All data required to build shared situational awareness in MONICA is managed by the COP database, it includes instance data, i.e. points of interest, zones et c. But it also keeps track of incidents e tc.

The database schema is based on PostgreSQL.

Getting Started

If you want to install it without Docker on your DB host, please jump to the deployment section. The easiest way of installing and having example populated COP.DB databases is to use the Docker Compose with complete demonstration environment.

Docker Compose with complete demonstration environments including the COP.DB

• Demonstration of staff management with LoRa based locators
• Demonstration of crowd management using smart wristbands
• Demonstration of Sound Monitoring an event using Sound Level Meters
• Environment Sensors for managing weather related incidents Demo

Deployment

• Download the database SQL definition file copdbmodel.sql
• Create the COP.DB from the sql dump by using PostgreSQL command line:
  • psql monica_copdb < copdbmodel.sql
  • The restoring of sql dumps have changed a lot between PostgreSQL versions, please consult the documentation for the version used here

Prerequisite

• PostgreSQL. Installation instructions are available here

Contributing

Contributions are welcome.

Please fork, make your changes, and submit a pull request. For major changes, please open an issue first and discuss it with the other authors.

Affiliation

This work is supported by the European Commission through the MONICA H2020 PROJECT under grant agreement No 732350.