+ Spatial to report-v2

[bbest]

See:

• tblSpatial section in report/server.R: https://github.com/marineenergy/apps/blob/22c09fafb9bbab7290b508d248b15c9c427d1c76/report/server.R#L327-L440
• tabulate_dataset_shp_within_aoi in scripts/report-v1.R: https://github.com/marineenergy/apps/blob/bbdbe4775c35f45e8f38e0b0d68d449b45b9676e/scripts/report-v1.R#L46-L157
• fields select_sql, summarize_sql in spatial | marineenergy.app Google Sheet

[bbest]

Spatial progress in report-v2

• Currently: @cdobbelaere had success with summarizing Spatial by dataset with Tags & Location filtering, then nesting the SQL results in a tibble.

• Issue: getting overlapping geometries for some Tags, ie datasets.

Existing layout of Spatial results in report-v1

App

Show only number of rows per dataset, no details:

Report

Showing details in the Report:

[bbest]

Approach for displaying Spatial in report-v2

1. Try to recreate hierarchy of report-v1:
   1. Summary in app: Dataset | Rows of Results
   2. Details in report: unique columns per dataset with separate tables
2. Try to fold Details into displaying in app. Not sure best way yet...

[bbest]

Yay! For fish & Location got to work:

[bbest]

Let's consider other scenarios:

1. Fish but no Location
2. Location but no Fish (or any Tag)