Subject: SQLite output database tables species codes (FVS, PLANTS and FIA)

Name: Lance David

Date: 03/13/2020

Variants affected: All variants

Description: Only involves the SQLite FVS variant executables and has not
             been extended to the ODBC executables used with Suppose interface.
             Output database tables that included a Species column was 
             updated to include columns for FVS 2-character alpha codes,
             PLANTS database species symbols and the FIA species codes.
             Where there was a Species column, there are now 3 new columns:
             SpeciesFVS, SpeciesPLANTS and SpeciesFIA.

             The updated output database tables are listed below with
             their associated source code file that generates them.


Impact on users: Users can easily choose preferred species code series when
                 processing results using the FVS interface.

Files:
                         Database table with Species modification
dbsqlite\dbsatrtls.f   - FVS_ATRTList / FVS_ATRTList_East
dbsqlite\dbscalib.f    - FVS_CalibStats
dbsqlite\dbsclsum.f    - FVS_Climate
dbsqlite\dbscuts.f     - FVS_CutList / FVS_CutList_East
dbsqlite\dbsecharv.f   - FVS_EconHarvestValue
dbsqlite\dbsfmdsnag.f  - FVS_SnagDet
dbsqlite\dbsfmmort.f   - FVS_Mortality
dbsqlite\dbsingrow.f   - FVS_Regen_Ingrow
dbsqlite\dbsmis.f      - FVS_DM_Spp_Sum
dbsqlite\dbsrd.f       - FVS_RD_Det, FVS_RD_Beetle
dbsqlite\dbssprt.f     - FVS_Regen_Sprouts
dbsqlite\dbsstats.f    - FVS_Stats_Species
dbsqlite\dbstally.f    - FVS_Regen_Tally
dbsqlite\dbstrls.f     - FVS_TreeList / FVS_TreeList_East
dbsqlite\dbsstrclass.f - FVS_StrClass