AROSS Stations database

This project aims to provide an interface to spatially and temporally search measurements from AROSS observation stations and visualize the results on a map or bar chart.

Architecture

These components will be developed in the order they are listed. If the link is broken, we haven't got to it yet :)

• aross-stations-db: A PostGIS database indexed by space and time.
  • Is loaded from measurements in files on disk. There are 1.8 million events from 1923-present.
  • We will likely limit our database to 2000-present.
  • Will need to be updated with new data as it comes in.
  • Does not need to be backed up because the database isn't the source of truth; it can instead be re-initialized from source data.
• aross-stations-api: Sits on top of the database and allows programmatically searching events by various facets, most importantly space (bbox, polygon) and time.
  • Can be used by writing Python, wget, curl, or other programmatic tools.
  • Returns data in machine-readable format.
• aross-stations-ui: Sits on top of the API and allows non-technical users to search events in the browser.
  • Visualizes event locations and total count for each station on a map.
  • Visualizes event frequency for a single station on a bar plot.

graph TD
  DISK[(fa:fa-box-archive Event files fa:fa-box-archive)]
  INGEST[[fa:fa-cog Daily? ingest fa:fa-cog]]
  DB[(fa:fa-bolt Events DB fa:fa-bolt)]

  API{{fa:fa-server HTTP API fa:fa-server}}
  UI{{fa:fa-window-restore HTTP UI fa:fa-window-restore}}

  TECHNICAL_USERS([fa:fa-users-gear Technical users fa:fa-users-gear])
  NONTECHNICAL_USERS([fa:fa-users Non-technical users fa:fa-users])


  DISK -->|read| INGEST
  INGEST -->|load| DB

  DB <-->|SQL query for data| API

  API <-->|HTTP request for data| UI

  API <-->|HTTP request for data| TECHNICAL_USERS
  UI <-->|browse for data| NONTECHNICAL_USERS

Loading