Flowpath OFE to Field database schema is inadequate for fields crossing HUC12s - Githubissues

dailyerosion / dep

Iowa Daily Erosion Project (version 2)

MIT License

4 stars 7 forks source link

Flowpath OFE to Field database schema is inadequate for fields crossing HUC12s #240

Open akrherz opened 3 months ago

akrherz commented 3 months ago

Presently, the database join for the flowpath_ofes to fields relations is based on the (fbndid) field along with an annoying further join between flowpaths and fields on the (huc12, scenario) fields. I really want to get de-duplication running on my end before ACPF comes up with something more robust. So this schema is not going to suffice.

[x] flowpath_ofes should use a foreign key to fields(field_id)
[ ] fbndid should be dropped from flowpath_ofes
~~The huc12 value in fields is super handy, but needs to go away as the value will not be unique to the field.~~ This field is necessary to keep the import straight.

akrherz commented 3 months ago

Presently, Forest DEP OFEs do not have associated fields. As a temporary hack, I added huc12 geom fields for each so that we have no orphans.