Hello all! I'm sure folks here have experience with outfall and water-related infrastructure, and mapping/recording information such as outfall inspections and evaluations, stormwater inspections, etc.
I'm hoping to gather input and suggestions about best practices and data management, using two options:
1. A feature layer for storm drains/outfalls/etc. AND an unrelated feature layer to map outfall inspections (e.g., one point for each inspection) with a common ID.
2. A feature layer for storm drains/outfalls/etc. AND a related table containing all outfall inspections.
I know best practices for data management will often point towards #2; however, there are such limitations to visualizing data and trends with related tables using ArcGIS Online as well as other potential data collection issues (bugs associated with AGOL arcade calculations with related tables), I'm wondering if anyone has more to share regarding either option, what their organization does, and any advantages/pitfalls that they've experienced.
Thank you!
