When running the onroad speciation profile weight script using the non-volatility resolved profiles, the script fails and does not produce output.
This is because one query is missing a join with the list of counties that are being run, which exists in the script for volatility-resolved profiles. A workaround is to open the profileWeights_onroad_cb6.sql file (which is in the database/ProfileWeightScripts folder) and add JOIN ##newDB##.countylist cl on (cl.countyID = rc.countyID) after line 133. The script can then be run via the MOVES GUI and should produce output.
When running the onroad speciation profile weight script using the non-volatility resolved profiles, the script fails and does not produce output.
This is because one query is missing a join with the list of counties that are being run, which exists in the script for volatility-resolved profiles. A workaround is to open the
profileWeights_onroad_cb6.sql
file (which is in thedatabase/ProfileWeightScripts
folder) and addJOIN ##newDB##.countylist cl on (cl.countyID = rc.countyID)
after line 133. The script can then be run via the MOVES GUI and should produce output.