MOVES4 does not report emissions for CNG long-haul combination trucks for:
PM (all processIDs)
All pollutant crankcase emissions (processIDs 15, 16, 17)
The impact on the total emissions inventory varies by pollutant and calendar year, but in general, emissions are between 0% and 0.1% too low because of this bug.
This issue will be corrected in a future version of MOVES. However, modelers that wish to run a corrected version of MOVES4 may follow these steps to fix it:
In your MariaDB data folder, find the default MOVES database directory:
If you are running MOVES4.0.0, it will be movesdb20230615
If you are running MOVES4.0.1, it will be movesdb20240104
Copy this database and give it a new name (e.g., movesdb20240104_issue67).
In a SQL editor (such as HeidiSQL or MySQL Workbench), select your new database and run the following SQL commands:
-- Duplicate short-haul combination truck CNG values for long-haul
-- This fixes non-extended idle PM and non-extended idle crankcase
INSERT INTO crankcaseemissionratio
SELECT polProcessID, minModelYearID, maxModelYearID, 62 AS sourceTypeID, regClassID, fuelTypeID, crankcaseRatio, crankcaseRatioCV
FROM crankcaseemissionratio
WHERE sourceTypeID = 61 AND fuelTypeID = 3;
-- Duplicate diesel extended idle for CNG extended idle (the values are all 1s)
-- This fixes extended idle PM
INSERT INTO crankcaseemissionratio
SELECT polProcessID, minModelYearID, maxModelYearID, sourceTypeID, regClassID,
3 as fuelTypeID, crankcaseRatio, crankcaseRatioCV
FROM crankcaseemissionratio
WHERE sourceTypeID = 62 AND fueltypeid = 2 AND regClassID = 47
AND RIGHT(polProcessID, 2) = 90;
-- Duplicate crankcase running long-haul CNG values for extended idle crankcase
-- This fixes extended idle crankcase
INSERT INTO crankcaseemissionratio
SELECT FLOOR(polProcessID/100)*100 + 17 AS polProcessID,
minModelYearID, maxModelYearID, sourceTypeID, regClassID, fuelTypeID, crankcaseRatio, crankcaseRatioCV
FROM crankcaseemissionratio
WHERE sourceTypeID = 62 AND fueltypeid = 3
AND RIGHT(polProcessID, 2) = 15;
3. Update `MOVESConfiguration.txt` and `maketodo.txt` to replace the value for `defaultDatabaseName` with your new database's name.
MOVES4 does not report emissions for CNG long-haul combination trucks for:
The impact on the total emissions inventory varies by pollutant and calendar year, but in general, emissions are between 0% and 0.1% too low because of this bug.
This issue will be corrected in a future version of MOVES. However, modelers that wish to run a corrected version of MOVES4 may follow these steps to fix it:
-- Duplicate diesel extended idle for CNG extended idle (the values are all 1s) -- This fixes extended idle PM INSERT INTO crankcaseemissionratio SELECT polProcessID, minModelYearID, maxModelYearID, sourceTypeID, regClassID, 3 as fuelTypeID, crankcaseRatio, crankcaseRatioCV FROM crankcaseemissionratio WHERE sourceTypeID = 62 AND fueltypeid = 2 AND regClassID = 47 AND RIGHT(polProcessID, 2) = 90;
-- Duplicate crankcase running long-haul CNG values for extended idle crankcase -- This fixes extended idle crankcase INSERT INTO crankcaseemissionratio SELECT FLOOR(polProcessID/100)*100 + 17 AS polProcessID, minModelYearID, maxModelYearID, sourceTypeID, regClassID, fuelTypeID, crankcaseRatio, crankcaseRatioCV FROM crankcaseemissionratio WHERE sourceTypeID = 62 AND fueltypeid = 3 AND RIGHT(polProcessID, 2) = 15;