Congestion Mitigation Air Quality System (CMAQ)

U.S. Department of Transportation/Federal Highway Administration

Office of Planning, Environment, & Realty (HEP)
PlanningEnvironmentReal Estate

HEP Events Guidance Publications Awards Contacts

Help

How to use system tables to sort and filter data

For all tables in the system, you can sort the data based on any table column. For all tables in the system, you can filter the data based on any table column or based on combination of table columns.

Click each table header to sort the data based on that column. To undo the sort click the column again. To filter data click on the filter logo in the column header, enter your selections criteria, and press filter. To undo each filter click on the filter logo of the filtered column to see the filtering window again and press "Clear" button. As an example you can filter data to see projects for years 2012 or 2013, and for states “Arizona” or “Alaska".

Simple Search
  • Allows the user to generate a list of projects by year and state.
  • To select multiple years, use the <ctrl> key.
  • On any search results page, click on the "Details" button of each project to see an individual project report. The CMAQ Project ID is a unique tracking number assigned when project data is entered into the CMAQ project tracking system. Every project in the system beginning from 1992 and after has a CMAQ Project ID. The FMIS Project ID is a tracking number that is assigned to projects in FHWA's Fiscal Management Information System. FMIS, State and TIP Project IDs exist for some projects only.
1. Year Required field. CMAQ Project Year
2. State Required field. Project State

Return to top


Advanced Search
  • Allows the user to search for projects with specific terms.
  • To select multiple years, use the <ctrl> key.
  • The Search by Keyword function allows you to search the database (Project Title, Project Description, Reporting Category) for projects that include your specific search term(s). The system does a soft search of the data; a search for “diesel bus” will bring back projects that include “diesel bus” or “diesel buses,” for example.
  • On any search results page, click on the "Details" button of each project to see an individual project report. The CMAQ Project ID is a unique tracking number assigned when project data is entered into the CMAQ project tracking system. Every project in the system beginning from 1992 and after has a CMAQ Project ID. The FMIS Project ID is a tracking number that is assigned to projects in FHWA's Fiscal Management Information System. FMIS, State and TIP Project IDs exist for some projects only.
1. Year Required field. CMAQ Project Year
2. Project Type Project Reporting Category
3. CMAQ ID CMAQ Project ID
4. FMIS Financial Management Information System
5. TIP Transportation Improvement Plan
6. State ID Project State ID
7. Operating Assistance Does this project include operating assistance?
8. Keyword Type in word(s) to Search in Project Title, Project Description and Reporting Category
9. State Required field. Project State
10. Update MPO & NonAtt/Maint Area Once a state is selected from the List, Press the Update button to update the MPO, NonAttainment/Maintenance  Area lists
11. MPO Metropolitan Planning Organization
12. NonAtt/Maint Area NonAttainment/Maintenance  Area

Return to top


Reports
  • Allows the user to generate a variety of specific reports, and to narrow down the data based on specific parameters.
  • To select multiple years, use the <ctrl> key.
  • The Search by Keyword function allows you to search the database (Project Title, Project Description, Reporting Category) for projects that include your specific search term(s). The system does a soft search of the data; a search for “diesel bus” will bring back projects that include “diesel bus” or “diesel buses,” for example.
1. PDF Select Portable Format Document(PDF)
2. Excel Select Microsoft Excel Spreadsheet Format
3. Year Required field. CMAQ Project Year
4. Project Type Project Reporting Category
5. CMAQ ID CMAQ Project ID
6. FMIS Financial Management Information System
7. TIP Transportation Improvement Plan
8. State ID Project State ID
9. Operating Assistance Does this project include operating assistance?
10. Keyword Type in word(s) to Search in Project Title, Project Description and Reporting Category
11. State Required field. Project State
12. Update MPO & NonAtt/Maint Area Once a state is selected from the Drop Down List, Press the Update button to update the MPO, NonAttainment/Maintenance  Area lists
13. MPO Metropolitan Planning Organization
14. NonAtt/Maint Area NonAttainment/Maintenance  Area

Note Advanced Search and Reports pages are essentially identical. The only difference is that you can use Reports to generate distinct reports, while Advanced Search produces a simple list of projects that match the search criteria selected.

For each project and subsequent project "Total Project Funding" is the sum of "CMAQ amount", "Operating assistance amount", and "Non-CMAQ funding".

Return to top



HEP Home Planning Environment Real Estate