metric areas greater than total DGO area in scrape

[jtgilbert]

results from select * from vw_metrics where active_area > dgo_area_acres

[jtgilbert]

694 rows returned

[philipbaileynar]

The source of the problem is that there are multiple polygons for some DGOs. When we join RCAT DGOAttributes to RME DGOs we have to do it based on level_path and seg_distance because the FIDs can be different between RCAT and RME. But this causes duplicate data when there are multiple DGOs in RCAT with the same level_path and seg_distance. The root cause of the problem is VBET, when it creates weird centrelines and DGO polygons. These cascade to RCAT and all other downstream models.

Example: HUC 0808010105 in Louisiana. Level path 20000200000091 and seg_distance 50 have two DGO records. They are discontinuous polygons, each with their own VBET metrics shown below.

Bottom line. We need to review VBET in these new landscapes, such as the flat, bayou. Here's a satellite and VBET centerlines.

[philipbaileynar]

and here's a video explaining the problem further

https://youtu.be/PeN3z8UAG8Y