D9.3 Web-based online indicator observatory
Summary:
This report is a deliverable (D9.3) that covers the development of a Web-based online indicator observatory, that is updated on a regular basis with information on Key Performance Indicators (KPIs) gathered for the demonstration sites.
This web-based observatory is built based on several processes and items, as follows:
- Data gathering & consolidation. Data is obtained from individual data sources, integrated and consolidated into a single dataset
- Data is made available online for automated reading by authorized users through an Application Programming Interface (API)
- KPIs are calculated
- A visualization layer is developed and made available online through an open website.
Data gathering and consolidation is performed once per month, about 1 week after the end of each reporting period. This is due to limitations in some of the data sources1.
Data consolidation, KPI calculation and visualization processes are made consistent with the methodology outlined in D9.2. Specific scenarios are defined so that the performance of the PEDs is corrected for climate and other specific issues so that it is traceable to the expectations during the design phase.
The data structure has been defined commonly for Amsterdam and Bilbao, but individual databases are deployed for each of the sites.
The process presented in this report has been tested with monitoring data for Amsterdam, particularly with data flows for the Republica site. A similar approach will be used for replication in Poppies and Bilbao, along the population of the districts, and the setting-up of data flows.
Interaction with the database is possible at two independent layers. Consolidated data is made available for secondary research/use through an Application Programming Interface (API, i.e. for other researchers and WPs within ATELIER), as well as through a web interface for final use (i.e. for direct assessment of the PEDs, within or outside the ATELIER consortium).