2015  Inventory:   Main  Speciation Profiles
 Inventory Version Code:   DefaultxxStwdxxxx20120920
Click Here to Change Inventory Version                                   Click Here to Change Inventory Year
Select inventory year, above, then: EITHER click on a RED master file for access to the entire master file, from which you can select portions of detail files; OR, in order to access an entire detail file at one time, click on a GREEN detail file (below red master files).  The search/filter method will work either way.
For additional information on the file structures, field descriptions, and how the MASTER-DETAIL files are linked, click the file name, below:
ORGPROF: info ORGSPEC: info SCCORG: info PMPROF: info PMSPEC: info SCCPM: info SCCLIST: info CHEMXREF: info

 

Interactive Data Access: Main Page

This page provides access to the interactive option, which allows you to search/filter on a variety of data fields.  This page allows interactive access to most of the same data that are posted on the DOWNLOAD OPTION page.  As with the download page, you can use these interactive mode tables to download data.  For the interactive tables, however, you can choose to download (export as Excel or CSV (text)) the entire file, or just a portion of the file (even a single record), you can also choose to print the data.  These are VIEW-ONLY tables, and you will not be able to edit these tables on-line. 

Be sure to read and understand the information, presented below, on this page, before accessing the interactive tables.

  • SELECTION BARS:  The selection bars at the top of this page will be present on all the pages of this interactive site:
  1. Inventory selection bar:  The top selection bar allows you to select the inventory year to which the speciation profiles will be applied.  This is important, since, for some emission source categories, the speciation profiles applied to that category may change between inventory years.
  2. File selection bar:  The second selection bar from the top allows you to select the file(s) from which you wish to access data.  There are two rows within this selection bar.  The top row files are colored red, and are MASTER files.  The second row files in the file selection bar are colored green, and are the DETAIL files.  There are red linking lines running from the MASTER files to the DETAIL files that apply to them.  You will notice that there are repeat references for some files in the  DETAIL row of the file selection bar.  This indicates that these files are DETAIL files for more than one MASTER file.  If you click on a MASTER file, that will allow you to access that entire MASTER file, as well as then select subsets of the linked DETAIL file.  The subset files will consist of all records in the DETAIL file that match the currently selected record in the MASTER file.
  3. Information selection bar:   The third selection bar from the top, below the yellow text bar, provides access to file-specific information.  This includes information on the fields and field content of the files, as well as the selected file relates, and links to other files.  This includes additional explanations of the MASTER-DETAIL relationships.
  • SEARCH FILTERS:  Search filters, and/or the MASTER-DETAIL table selection method, of the interactive mode tables allow you to select records based on pollutants, source type codes (SCC or EIC code), source type descriptions, speciation profile codes, or speciation profile descriptions.  Using the advanced search-filter method, you can even select based on several of these fields.  The search-filter feature allows searching using exact matches, or partial field data matches. 
  • MASTER-DETAIL SELECTION METHOD:   Linked tables are a powerful data selection method.    If you click on a MASTER file, that will allow you to access that entire MASTER file, as well as subsequently select subsets of the linked DETAIL file.  The subset files will consist of all records in the DETAIL file that match the currently selected record in the MASTER file.  You can also combine this approach with the SEARCH FILTER approach, described above, for even more powerful data selection.  Once you have selected the MASTER page, you will find the links to the two DETAIL files in columns near the left of the page.  They will be highlighted links with the name of the DETAIL file in each row of the file.  Clicking on that link will open the subset DETAIL page.  the single selected record from the MASTER file will be shown at the top of the subset DETAIL page.  To return to the MASTER page, click on the link below the selection bars, and near the top of the page that says "RETURN TO MASTER TABLE."

 

 

Top of Page  | Speciation Home Page