Wrong column names in fvs-dbs-user-guide.pdf

[jgrn307]

I did an AI summary of fvs-dbs-user-guide.pdf so I could have a "master list" of all tables and metrics that FVS can output, and I think there is a discrepancy between the documentation and the actual outputs for, at least, FVS_Summary. Specifically, the columns that the PDF describes are "TPA" and "RTPA" but I'm finding the sqlites are named "Tpa" and "RTpa" (note the capitalization). Can someone confirm this and potential update the official documentation? Thanks!

[wagnerds]

That is correct. The casing of the variables in the FVS_Summary table are 'Tpa' and 'Rtpa'. I will work to get the documentation updated.

When ever you see issues like these, please feel free to send our help desk a note. https://www.fs.usda.gov/fvs/support/index.shtml

Thanks!

[jgrn307]

Cool - I THINK there may be some more casing problems. FWIW I'm attaching a JSON I've been compiling for all the tables/metrics. I'm not sure it's 100% accurate yet but it's getting there. There are some other parameters I'm using for my coding (summary and default stuff) -- you can ignore those.

fvs_metric_master_list.json