search

USEPA / EPA_MOVES_Model

Estimating emissions for mobile sources
Other
80 stars 20 forks source link

NEI2020 QA Script Issues #35

Closed danielbizercox closed 2 years ago

danielbizercox commented 2 years ago

The onroadNEIQA command in MOVES3.0.1/3.0.2 has the following issues:

  1. Error 2806 ("Missing combination of valid sourceTypeID, roadTypeID, dayID, hourID") for hourVMTFraction is always triggered, regardless if any combinations are missing or not.
  2. If an onroad CDB is missing the hpmsvtypeday, sourcetypedayvmt, or sourcetypeyearvmt tables, the script will error out instead of issuing and error message and continuing.
  3. Check 3804 lists having all VMT on one road type as an error. This should be a warning instead.
  4. Warnings 2808 and 2809 are triggered for most databases, complaining about roadTypeID 100. This warning can be safely ignored.

Fixes for these issues will be posted to the MOVES3.0.3 development branch shortly, along with instructions for how to apply the fixes before we release MOVES3.0.3. If there are any other issues identified with the NEI2020 QA scripts, they will be posted here, as well.

danielbizercox commented 2 years ago

This issue will be fixed when we release MOVES3.0.3. Users that need to use the NEI2020 QA scripts before we release can simply save M3onroadCDBchecks.sql to the "database\NEIQA" sub-directory wherever MOVES is installed. By default, this location will be C:\Users\Public\EPA\MOVES\MOVES3.0\database\NEIQA. If prompted, overwrite the existing file.

To confirm that the fix was implemented, run the QA tool and look in the versioncolumn of the output spreadsheet. It should indicate movesdb20210209-rev20220104 if you are using MOVES3.0.1 or movesdb20210726-rev20220104 if you are using MOVES3.0.2.