search

USFS-PNW / Fia-Biosum-Manager

User interface and main code repository for Biosum
http://biosum.info/
Other
3 stars 3 forks source link

DATABASE: Update fiadb_fvs_variant table in biosum_ref.accdb #317

Open lbross opened 5 months ago

lbross commented 5 months ago

From @jsfried: I did a quick check in Oregon and found that the VARIANT code in PLOTGEOM is the same as the one in our BioSum look-up table for all but 2 of 31505 plot locations. However, the LOC_CODE is different (701 vs 702) for 1688 of those cases. Not sure how often PLOTGEOM is updated but out BioSum internal fiadb_fvs_variant table hasn’t been updated in probably 5-6 years (I never thought to). I now see that it does need updating because FVS tweaks its maps a bit over time, apparently, and because new plots get added when spatial intensifications are undertaken (as they were in Oregon over the last few years).

Optional: Get the default move distance (fiadb_fvs_variant.MoveDistance_ft) as the midpoint of the road distance class in PLOT.RDDISTCD given that this distance is populated from the actual plot location, not from a point that can be up to .71 miles away.

We would like to include this updated table in v5.11.0. Another issue will be opened for a longer term fix to populate the VARIANT directly from an FIADB table when a plot is loaded.

lbross commented 3 months ago

The versioning in the biosum_ref.accdb needs to be updated when this is ready for deployment. This tells BioSum to pull down the updated reference database. This database is shared between projects so this only happens once. Any pre-existing customizations to tables in this database will be overwritten/lost.

lbross commented 1 month ago

From Nathan: Here’s a screenshot of the REF_VERSION table in biosum_ref.accdb in my ~\AppData\Roaming\FIABiosum folder, which confirms that the version number and date are correct. I loaded a bunch of plots for the Mount Hood WCS landscape and had no problem having the FVS variant (EC or WC) being assigned. Sounds like this item (Issue #317) can be crossed of, correct?

lbross commented 3 days ago

@jsfried has additional updates for this table. He would like to leave all plots (including only nonforest conditions and nonsampled conditions) in the table. He posted an updated table to BioSumBox\Development\BioSumRef\fiadb_fvs_variant\FFV24a.accdb. At the August 15 DEV call we agreed to hold of on deploying this new table until v5.11.1.