v1.0.0 - release with all tables added to dB SPL
Languages: Python, SQLite
dB SPL is a CDM designed for standardizing the organisation and analysis of amplified sound data.
- Python v3.7* should be available on your machine
*or above
Once the GitHub repo is downloaded/cloned, the db file should be visible in the root, as dbspl.db. If another version of the db file is needed, this can be created by running the command python3 main.py.
dB SPL revolves around one table predominantly - the SPL table. This table is where all sound pressure levels should be stored.
| Column | Field Description | User-editable? |
|---|---|---|
| id | Unique identifier for all SPL entries | N |
| end_time | End time of measurement | Y |
| measurement_time_interval | The preceding time interval of an SPL from it's end time, e.g. 00:01:00 | Y |
| value | The raw value of the sound pressure level | Y |
| spl_type_concept_id | The L descriptor measured, referenced by concept ID | Y |
| frequency_weighting_concept_id | The weighting of frequency, referenced by concept ID (e.g., A, C, Z) | Y |
| bandwidth_concept_id | The range of frequencies measured | Y |
| centre-frequency_concept_id | The central frequency value for the measured bandwidth | Y |
| time_weighting_concept_id | Fast, slow, or N/A | Y |
| sound_monitor_id | The sound monitor used to measure SPL | Y |
| measurement_position_id | The measurement location of the SPL | Y |
| operator_id | The operator in charge of measuring the SPL | Y |
Outside of the SPL table, we have the following context tables:
- Event
- Venue
- Stage
- Event_at_venue
- Operator
- Sound monitor
- Measurement_position
- Musical_set