Implement Statistical Data in Grafana Dashboard and Webservice

[DonZandbergen]

Description

Calculate and include the following comprehensive statistical data in both the Grafana Dashboard and the webservice (WS). The statistics should be updated once per day from the database.

Statistics

Foundation Type Distribution

• foundation_type, count, percentage

Foundation Type Reliability Distribution

• foundation_type_reliability, count, percentage

Construction Year Distribution

• decades (bins of 10 years), count, percentage

Foundation Risk Distribution

• risk category (A-E), count, percentage

Data Collected Percentage

• number of buildings, percentage

Total Building Restored Count

• count

Total Incident Count

• bin (1 year), count

Report Count

• report type, count

Total Report Count

• bin (1 year), count

Restoration Cost

• min, max, mean, pc95

Total Report Contractor

• count

Total Report Organization

• count

Total Owner

• count

Data Collected

• Count of foundation_type samples per area
• Count of inquiries per area

Buildings Restored

• Count of recovery samples per area

Restoration Cost

• Minimum restoration cost per area
• Maximum restoration cost per area

Droogstand

• Distribution of drought risk

Ontwateringsdiepte

• Distribution of drainage depth risk

Bacteriële aantasting

• Distribution of bacterial damage risk

Vastgesteld risico

• Distribution of established risk

Funderingstype

• Distribution of foundation types

Funderingstype per betrouwbaarheid

• Distribution of foundation types by reliability

Herstelde funderingen

• Number of restored foundations

Rapporten

• Number of reports (inquiries)

Rapporten per type

• Number of reports (inquiries) by type (inquiries_type)

Rapporten per opsteller

• Number of reports (inquiries) by contractor

Rapporten per eigenaar

• Number of reports (inquiries) by owner (organisation)

Bouwjaar

• Number of buildings by construction year (bins of 10 years)

Eigendom

• Number of buildings by ownership (owner)

Verdeling risico’s verschilzakking

• Distribution of differential settlement risk

Verdeling risico’s vastgesteld risico

• Distribution of established risk

Special Consideration

The above statistics must be filtered for the ownership (owner) of a specific user (especially for corporations).

Geographic Areas

These statistics need to be calculated for the following geographic areas:

• Land
• Province
• Municipality
• District
• Neighborhood
• PC4 (optional)
• PC6 (optional)

Additionally, statistics should also be determined per ownership category (owner).

Actions

1. Data Aggregation and Calculation

   • Aggregate and calculate data for each required statistic once per day from the database.

2. Integration with Grafana and Webservice

   • Integrate the calculated statistics into Grafana for visualization.
   • Integrate the calculated statistics into the webservice (WS) for access.

3. Backend Development

   • Ensure the backend supports the calculation, storage, and retrieval of the required statistics.

4. Frontend Development

   • Design and implement the dashboard interface in maps.fundermaps.com using Grafana visualizations.

5. Testing and Validation

   • Test the accuracy and functionality of the calculated statistics.
   • Validate the integration and visualization in Grafana and the webservice.

6. Deployment

   • Deploy the dashboard functionality and webservice updates to the production environment.

Expected Behavior

Admins and users should be able to view the specified statistics in the Grafana Dashboard and access them through the webservice, filtered by the ownership of the specific user. The statistics should be visualized accurately in Grafana and accessible through the webservice.

Additional Information

• The statistics should be updated once per day.
• Ensure that all the statistics are accessible through the webservice (WS).

[DonZandbergen]

Data dichtheid en betrouwbaarheidsverdeling maken zodat inzichtelkijk wordt welke wijk/buurten/gemeentes de hoogste data dichtheid heeft.