Instructional videos: National Pollutant Release Inventory

The National Pollutant Release Inventory (NPRI): an overview

Transcript

Intro page

Hi,

This webinar will provide you with an overview of Environment and Climate Change Canada’s National Pollutant Release Inventory program.

The following topics will be discussed during this presentation:

What is the NPRI and why it exists, who reports to the program, what are the requirements for reporting, what substances are listed on the NPRI and what type of information is reported to the NPRI.

We are also going to talk about who uses the NPRI data, what is the standard timeline of the NPRI, the support we provide to reporting facilities, how to access the data, what type of data products are available and what can the data show us.

And finally we are going to talk about the reporting requirements and how they have changed over time.

What is the NPRI?

The NPRI is Canada’s inventory of pollutant releases to air, water and land, as well as disposals and transfers for treatment and recycling.

It was established in 1993, and includes data from 1993 to the most recent reporting year.

The information is collected annually from approximately 7,500 facilities across Canada on over 300 pollutants.

The NPRI includes reporting on toxic substances, air pollutants which contribute to the formation of smog and acid rain, and other pollutants of concern.

Why the NPRI exists?

The NPRI and publication of data collected is mandated under the Canadian Environmental Protection Act, 1999.

The NPRI is a key resource for identifying and monitoring sources of pollution in Canada.

The public “right to know” is one of the fundamental principles of the NPRI.

NPRI data can be used to:

Encourage actions to reduce the release of pollutants into the environment;

Improve public understanding; and

Inform other governmental programs.

Who currently reports to the NPRI?

They are many different types of facilities that report to the NPRI program.  A large portion of the reporting facilities are from industrial sectors, such as oil and gas extraction, forest products mills, petroleum refineries, mines, chemical manufacturing facilities, and many others.

Other types of facilities that report to the NPRI include, for example, waste management facilities, municipal waste water treatment plants, electric power generation facilities, and airports.

Certain government departments, such as the Department of National Defence also report to the program.

There are a few sectors and certain activities that are exempt from reporting to the NPRI, such as agriculture, forestry, and oil and gas exploration and drilling.

Also, not all facilities within a sector report to the NPRI because some of them do not meet the reporting requirements of the program.

Reporting Requirements

The NPRI reporting requirements are published every 2 years in Part I of the Canada Gazette, which is the official newspaper of the Government of Canada.

The NPRI is a mandatory survey. Facilities must report to the NPRI if they have a certain number of employees, equivalent to 10 full time employees, or if they carry out certain listed activities, such as incineration or municipal sewage treatment and exceed certain quantities of substances.

Facilities that fail to report to the NPRI when they should have can face penalties under the Canadian Environmental Protection Act.

The NPRI team is available all year through the helpdesk, to provide guidance and support to facilities who must report. Contact information is available on our website and later in this video.

Which substances are on the NPRI?

Over 300 substances are currently listed on the NPRI, including toxic substances, such as asbestos, bisphenol A and benzene, heavy metals, such as mercury and lead, polycyclic aromatic hydrocarbons, dioxins and furans, air pollutants, such as sulphur dioxide, carbon monoxide and nitrogen oxides, and many substances of concern.

The substances are divided into groups with their own set of reporting criteria. These are based on the quantity of a substance that is manufactured, processed or used at the facility, or the quantity of a substance that is released from the facility; or when certain activities occur at the facility.

The full list of substances is available on the NPRI’s website.

What is reported to the NPRI?

The NPRI collects a lot of information. The main part of this information is on the quantities of substances that are released to air, water and land, disposed or recycled.  Each category has several sub-categories.

The releases category includes direct releases to air, surface water and land. And each of these types of releases is further broken down into more specific types, such as smoke stack emissions, spills and leaks, and direct discharges.

Another category of information collected is disposals. A facility can dispose of a substance on-site or off-site, and the disposals can fall into sub categories, such as landfill, land application, underground injection, mine tailings and waste rock.

The substances can also be transferred off-site to be recycled, or further treated prior to their final disposal. Facilities must also report the type of recycling or treatment performed as a sub category, and they must also provide the destination of the transfers.

What is reported to the NPRI? (2)

The NPRI collects many other types of information, such as data about the ownership, the location and the sector type, for each facility.

The program collects information on the type of use of each substance by the facility, if facilities performed pollution prevention activities and the reasons for changes compared to quantities reported in previous years.

Facilities are encouraged to provide additional comments and explanations in their reports to help users understand the data that was reported.

Who uses NPRI data?

NPRI data is used by a variety of users.

These users range from government and international organizations, industry associations and individual companies, to the media, academics, students, non-government organizations and the general Canadian public.

Given the broad variety of users, the NPRI strives to publish information and data that meets the need of all these different user groups.

Standard NPRI timeline

Every two years, in the winter, the NPRI publishes a notice with reporting requirements in the Canada Gazette for the 2 upcoming reporting years.

Facilities can submit their report using the online reporting system, which is launched in March. They have until June 1st to report their data for the previous calendar year.

As soon as the deadline is passed, the NPRI team starts the review of the data to identify potential reporting errors.  In early July, the NPRI publishes the preliminary set of data, as it was reported by the facilities. This step is to invite facilities to review their data to identify and correct any potential errors. This preliminary data is in draft form and should not be used to perform data analysis, because it can contain errors.

In the fall, once the data has been reviewed, the NPRI team starts preparing a summary report and other analysis, which are published along the reviewed data in multiple formats in December.

Support to reporting facilities

Support is provided to facilities in order to assist them with reporting to the NPRI.

The type of support provided, which are all available through the NPRI website, include general guidance to explain the reporting requirements such as frequently asked questions and video tutorials. 

A Toolbox is also available, which provides facilities with technical guidance, for example on estimation methods, estimation tools and calculators and links to external resources.

And finally, the NPRI team is available all year to provide guidance and support to facilities through the helpdesk. They can contact the program by phone or email.

Tools for accessing NPRI data

NPRI data is available in various formats on the NPRI website, and through the Government of Canada’s Open data portal.

Some are very intuitive and easy to use, whereas others are more comprehensive. Some are tailored to more advanced users and allow for advanced analysis, such as time trends.

A very intuitive and easy way to search for information on a particular facility, substance or location is through the online query site.

The online query site also includes tables of data, called predefined queries, which provide a quick and easy way to find information on a particular topic, such as data by province, industry type and substance.

The NPRI publishes its data for the most recent year in a map layer format that can be used with Google Earth or other virtual globe softwares. This allows users to “explore” NPRI data in an intuitive and visual way and to find recent data about facilities in your city, near your house or anywhere in Canada.

Data is also available for download in various file formats, such as .csv, Excel and Access. These files can be used to create custom analysis and look at data over time.

What can the NPRI data show us?

NPRI data can be used and analyzed for many different purposes. Examples of analysis that can be done using NPRI data include finding pollutant releases, disposals and transfers for the last reporting year and trends over time, defining pollutant profiles of industrial sectors, and pollutant profiles by province or by city. It also allows users to find pollutant releases, disposals and transfers near their house or what kind of pollution prevention activities are facilities doing. 

The NPRI also publishes a summary report on its web site every year, which provides users with an overall analysis of NPRI data.

Can the NPRI requirement be changed?

Anyone can propose changes to the NPRI reporting requirements.

Example of possible changes include: additions of new substances, deletions of listed substances, and changes to reporting thresholds.

Proposed changes are evaluated against a set of criteria as outlined in the Process for proposing and considering changes to the NPRI.

Any proposed changes also undergo consultation with the NPRI Multi-Stakeholder Work Group and are posted on the NPRI website for a public comment period.

More information on how changes are made to the NPRI is available on the NPRI website.

How the NPRI requirements changed overtime

Since the start of the NPRI, the program has expanded to better meet the needs of data users.

As shown by the red line in the graph, over 150 substances have been added to the initial list, including toxic substances and air pollutants.

Environment and Climate Change Canada has also increased the number of facilities required to report by making stricter reporting requirements and by removing certain exemptions.  The blue line on the graph shows the number of facilities that have been reporting to the NPRI each year.

It is important to consider these changes to reporting requirements when analyzing NPRI data.

Contact the NPRI

We hope that this video has provided you with a good introduction to the National Pollutant Release Inventory.

Please contact the NPRI via phone or email if you have questions or require any assistance.

Thank you.

Changes to the NPRI reporting requirements and reporting site

Transcript

This tutorials covers changes to the National Pollutant Release Inventory’s (or NPRI’s) reporting requirements for the 2018 and 2019 reporting years.

We will start with the three changes to the Single Window Information Manager, or SWIM

This is the SWIM home page.

The first one is on the facility address screen. From the SWIM home page, you can get to that screen by clicking on “Organizations” in the left menu, then selecting an organization. As the left menu expands, click on “Facilities” and select a facility. Click on the “Physical Address” tab and scroll to the bottom.

The “Land Survey Description or National Topographic Description” sections are now drop-down fields instead of open-ended text boxes. If you are using these types of addresses, choose the options that apply from the drop-down fields and then click “Save”.

The next SWIM change is to the reporting of North American Industry Classification System codes, more commonly referred to as NAICS codes. To start, click on “NAICS, Identifiers and Permits” in the left menu. You’ve always had to report the facility’s Primary NAICS code. That Primary code is the code that generally represents the activity that generates the largest economic value to the facility. What’s new is that now, along with that Primary code, you have to report Secondary and Tertiary NAICS codes if other activities take place at the facility.

If this change applies to you, enter the Secondary and Tertiary NAICS codes in SWIM. Then click “Save”.

The last SWIM change is related to Stacks. Click on “Stacks” from the left menu and select your stack. You now have to report latitude and longitude coordinates for stacks that are 50 metres or higher. Once you enter and save the latitude and longitude fields, new fields for provincial identifiers appear. These are required if the stacks have a provincial identifier.

Those are all of the changes for SWIM.

Now I will show you the changes in the NPRI reporting module. Click on “Home” from the left menu and then select the “National Pollutant Release Inventory (NPRI) and Partners” link.

We can open an in-progress report by clicking the edit icon to the right of a facility. From the left menu, click on “Employees and Activities”.

At the bottom of this screen, there are 2 new questions. One relates to the oil and gas sector. The question is about activities relevant to the reporting of oil batteries.  If this applies to you, visit the Video Tutorials page on our website to access a separate tutorial that explains this change.

The second question is about activities that are relevant to electricity generating units. This new requirement is intended for facilities that operate one or more electricity generating units and meet specific criteria. The new reporting section for this change is on the left menu. If this applies to you, visit our Video Tutorials page on our website to access a separate tutorial that explains this change.

Click “Save/Continue” to go to the General Facility Information screen where we can see another new question: “Is this facility a compressor station in the oil and gas extraction sector?” This question also relates to the new requirement for the oil and gas sector and is covered in the oil and gas sector tutorial.

There are also some changes to the shutdown periods on this screen. When you click the plus sign to add a new shutdown period, you must indicate the start and end dates of the shutdown and answer the following two new questions:

  1. Will the shutdown period occur at or around the same time in future years?
  2. Was the shutdown a partial or complete shutdown?

You may also add comments to help explain the shutdown period.

Once you have provided the necessary information, you can click “Save”.  Then click “Save/Continue”.

There are no changes to the Verify Facility Information screen. Click “Save/Continue”.

We’re now on the Substance List screen. For 2018 and 2019, some substances have been deleted from the NPRI substance list. If you have reported any of these substances in a previous year’s report and you use the prepopulation function to create a 2018 inventory report, those substances will automatically be removed from your substance list.

There have also been additions to the substance list for 2018 and 2019. Please review those changes and add any new substances by clicking the plus sign on this screen. You should note that changes to the substance list for the Part 5 Speciated volatile organic compounds can only be viewed within the screen for the Part 5 list.

There have been a few changes to existing substances. First, the Chemical Abstract Service or CAS number was removed for vanadium and n-butyl acetate and replaced with a generic identifier because multiple substances can now be reported under these listings. This means that if you reported vanadium or n-butyl acetate in a previous year’s report and you use the prepopulation function to create your 2018 inventory report, that substance will no longer appear on your list and you will have to add vanadium or butyl acetate (all isomers), respectively, again if you continue to meet the reporting requirements for these substances.

Benzo(a)phenanthrene is now listed by its more common name, chrysene. So if you had benzo(a)phenanthrene on your substance list previously, and you use the prepopulation function to create your 2018 inventory report, you will now see chrysene instead. It will include a copy of all previously submitted data.

Another substance change is anthracene, which moved from Part 1A to Part 2 of the NPRI substances list. The reporting threshold for this substance is now 5 kg if the total PAH threshold of 50 kg is met. If you reported anthracene previously, and you use the prepopulation function to create your 2018 inventory report, then anthracene will be on your substances list, but all previously submitted data will be erased and you will need to enter all of the data. It is also important to note that the unit for this substance has changed from tonnes to kg.

Click on the edit icon beside chrysene to go into the substance report. I will go directly to the on-site releases screen from the left menu and scroll to the bottom of the screen to see the section called “Reasons for Changes in Quantities Released from Previous Year”. This section has been expanded to help you accurately explain changes in reported quantities. Many of the options now require you to add a comment. The recycling and disposal screens also now include space for you to explain changes in reported quantities.

The last changes to the module are on the pollution prevention screens. Click on “Pollution Prevention” from the left menu. If you have implemented a pollution prevention plan, you must report the name of the Pollution Prevention Planning Notice for which the plan was prepared. You can do this by selecting from the list of notices on this screen. If the pollution prevention plan was prepared or implemented for another government jurisdiction, you must also report the name of the jurisdiction, program or requirement in the comments box.

Now I will scroll down to the Pollution Prevention Activities section. If you say “no” to completing any pollution prevention activities during the year, you must select one of the reasons from the list on this screen.

One more group of changes has been made, but these changes haven’t affected the reporting module. I’ll run through the changes quickly. There have been changes to the reporting thresholds for facilities that fall under the Chromium Electroplating, Chromium Anodizing and Reverse Etching Regulations. Regulations must now report their Hexavalent chromium (and its compounds) releases and transfers, regardless of the number of employees and quantities manufactured, processed or otherwise used.

This concludes the tutorial on changes to the NPRI’s reporting requirements for the 2018 and 2019 reporting years.

If you have any questions, please contact us. You can get the contact information for NPRI and Partners from the Help option on the top menu bar. Just click “Contact NPRI”.

Electricity Generating Units Reporting

Transcript

Hello, and welcome to the tutorial on unit level reporting to the National Pollutant Release Inventory or NPRI.

New for the 2018 and 2019 reporting years is the requirement to report the breakdown of emissions of Part 4 substances and mercury from electricity generating units. The new requirements apply to any facility that operated electricity generation units that had a capacity of 25 MW or more and that distributed or sold to the grid 33% or more of its potential electrical output in the calendar year.

This is the Single Window Information Manager, or SWIM, homepage. Click “National Pollutant Release Inventory (NPRI) and Partners” to continue.

This takes you to the Reporting Dashboard screen.

Click on the edit icon from the Actions menu to go to the in-progress report.

Select “Employees and Activities” from the left menu. On this screen, you will see a new question field that reads, “Did the facility operate one or more electricity generation units that had a capacity of 25 MW or more and that distributed or sold to the grid 33% or more of its potential electrical output in the calendar year?”

When you select “Yes” to this question and then click “Save/Continue”, you will notice an Electricity Generating Units report appear under the Special Reports heading on the left side of the screen. You will not be able to fill out the Electricity Generating Units report until you have completed the rest of your NPRI report. Work through the screens as usual until all parts of your NPRI report have a green checkmark beside them.

Now it is time to fill out your unit-level information.

Click the Electricity Generating Units report on the left side of the screen. Then add a new unit by clicking on the plus icon.

Assign a name to your unit. That name will help you distinguish between multiple units at your facility. Then add the commissioning year, the capacity in megawatts, and the fuel type or types used in the unit.

The new requirements for electricity generating units apply to releases of all Part 4 substances and mercury. If you reported releases to air of these substances in your NPRI report, they will automatically be listed here. Fill out the quantity released by the unit and the basis of estimate used to determine the release. You should note that the total quantity of a substance released by a unit cannot exceed the total amount you reported in your NPRI report. You should also note that Mercury (and its compounds) is reported in kilograms.

Now fill out the information for technology and pollution controls installed on your unit. Include any other information about your unit in the comment boxes provided. Click “Save & Return” when you are finished.

Repeat the steps for each applicable unit at your facility. Click “Save/Continue” to return to SWIM and submit your report.

This concludes the tutorial on unit level reporting changes to the NPRI for the 2018 and 2019 reporting years.

If you have any questions, please contact us. You can get the contact information for NPRI and Partners from the Help option on the top menu bar. Just click “Contact NPRI”.

Oil and Gas Reporting Changes

Transcript

Welcome. Today we will go through the changes to the 2018 and 2019 National Pollutant Reporting Inventory, or NPRI, reporting requirements as they apply to the oil and gas extraction industry.

Please refer to the new Oil and Gas sector reporting guide available on the NPRI website to determine how to meet the new reporting requirements. You can use this flowchart from the guide to determine which case of reporting requirements apply to your facility. This video will focus on explaining how a facility with Case 3 or Case 4 reporting requirements must report to the NPRI.

Now we will log into Single Window Information Manager, or SWIM, and see how to report for these situations, starting with a case 3 facility. A case 3 facility is an oil and gas extraction facility that has less than 20,000 employee hours, meets the threshold for at least 1 part 4 substance from stationary combustion sources and is not solely a compressor station.

On the SWIM homepage, click “National Pollutant Release Inventory (NPRI) and Partners” to continue. 

This takes you to the Reporting Dashboard screen.

Click on the edit icon from the Actions menu to go to the in-progress report.

Select “General Facility Information” from the left menu.

In the General Facility Information section, you will see a new question field that reads, “Does this facility solely consist of compression equipment in the oil and gas extraction sector?” A Case 3 facility must answer this question by selecting “No” from the drop-down field.

Next click on “Save/Continue”. 

Click on “Substance List” from the left menu. On this screen, a Case 3 facility will need to report all seven Part 4 substances, as long as the facility meets the reporting threshold for at least one substance. If you need to add a substance, click the plus icon to the right of the screen to go to the Substance Search screen.

On the Substance Search screen, you can easily view all Part 4 substances by clicking on the drop-down arrow under “Programs” and selecting “NPRI”. Then you can click on the drop-down arrow under “Substance Part” and select “4”. This will take you to the Part 4 substances. Click the Search icon. The substances must be added one at a time by selecting the plus sign from the Actions menu.

Once you have added all your substances, click the Edit icon to open a substance report. Click “On-site Releases” from the left menu.

For each substance, the quantity reported must include all sources of releases to air (not just releases from stationary combustion sources). If there are no releases of certain Part 4 substances, these substances must still be included in your report, but the quantity reported should be zero. Click on “Edit” beside the appropriate category, enter your release data, and then click “Save and Return”.

Case 3 facilities also have to report for Part 5 benzene. On the “Substance List” screen, click “Edit” beside “Volatile Organic Compounds (VOCs)”.  When you reach the “General Information about the Substance” section, you must select the checkbox that reads “Select the check box if 1 tonne or more of a Part 5 Substance (Speciated VOC) was released to air, or your facility’s activities fall under NAICS 211110 and you’re required to report Part 5 benzene.  Click “Save/Continue”.

On the “On-site Releases” screen, enter the quantity of volatile organic compounds released to air by clicking “Edit” beside the appropriate category. Then you can enter your release data and click “Save and Return”. You can report benzene by selecting the “Edit” button under the section “Enter the values for releases to air for Part 5 VOCs”. The quantity reported for benzene must include all sources of releases (not just releases from stationary combustion sources). Enter the release quantity in the field beside benzene. If there are no releases of benzene, you must still include it in your report by entering a quantity of  zero for this substance. Once you have finished click, “Save and Return”.

We will now go through the reporting situation for Case 4 facilities.  A Case 4 facility is an oil and gas extraction facility that has less than 20,000 employee hours, does not meet the threshold for any part 4 substance from stationary combustion sources and has one or more light or medium crude oil batteries with a total oil throughput for the facility of 1,900 cubic metres or more per year. Case 4 facilities must report the Part 4 substance “Volatile Organic Compounds (VOCs)” and Part 5 “benzene”.

In the Employees and Activities section, you will see a new question that reads, “Does this facility release less than the reporting threshold for each Part 4 substance AND have one or more light or medium crude oil batteries with a total oil throughput for the facility of ≥1,900 m3 per year?” If you are reporting for a Case 4 facility, you must select “Yes” from the drop-down menu under this question and then click “Save/Continue”.

In the General Facility Information section, you will see a new question that reads, “Does this facility solely consist of compression equipment in the oil and gas extraction sector?”. If you are reporting for a Case 4 facility, you must select “No” from the drop-down menu under this question and then click “Save/Continue”.

You will need to report the Part 4 substance “Volatile Organic Compounds (VOCs)”. This applies to you even if your emissions are below the reporting threshold of 10 tonnes.

Report VOCs and part 5 benzene in the same way as I described for case 3 facilities. However, the quantity reported only needs to include releases from storage tank sources. As such, you enter it next to the Storage or Handling Releases category. If your facility did not have any storage tank releases of VOCs or benzene, you can enter a value of zero for the Storage or Handling Releases category of VOCs and for the benzene quantity.

This concludes the tutorial on changes to the NPRI reporting requirements for the 2018 and 2019 reporting years as they apply to the oil and gas extraction industry.

If you have any questions, please contact us.  You can get the contact information for NPRI and Partners from the Help option on the top menu bar. Just click “Contact NPRI”.

How to create and submit an NPRI report using a previous year's report

Transcript

Hello and welcome to the tutorial on how to create and submit a report to the National Pollutant Release Inventory or NPRI using a previously submitted report

This is the Single Window Information Manager homepage or SWIM for short. To learn how to access the SWIM homepage, please visit our tutorial on how to Sign in and navigate the Single Window Information Manager. 

Click National Pollutant Release Inventory and Partners to continue. 

This takes you to the Reporting Dashboard screen.

You can file an inventory report by either clicking on “Add New Report” on the bottom of this screen or on the plus icon.  You can also file an inventory report by using a previously submitted report or by “prepopulating” a new report. We will use the Prepopulation function to submit our report. Ensure you have your company selected, the report year you want to submit for, and the Inventory report type. In order to ensure that you haven’t already started a report for this facility for the year that you want to report, click the search button to the right to bring up all in-progress and submitted NPRI reports. When the list is returned and you don’t see an in-progress or already submitted report, you can begin to create a prepopulated report by clicking on Prepopulation on the bottom of the screen to view the previously submitted reports for this facility.

Search for the submitted report that you want to use to prepopulate your new report.  Use the most recent report. Select the report you want to use by clicking the add icon to the right of the facility name.

This takes us back to the Reporting Dashboard where you can see that a prepopulated report has been created for your desired report year. When you are ready to edit the report, click the Edit icon on the right hand action menu to go into the report.

Each screen will have the previously submitted information on it. On the applicable programs screen, you can add programs but you cannot remove them. If you need to remove a program, you will have to return to the dashboard, delete the newly prepopulated report from the drop-down arrow and then add a new report that is not prepopulated. To continue editing the prepopulated report click Save/Continue to navigate to the next page. Notice that the orange exclamation marks on the left menu change to green check marks as we navigate through the screens.

Update your facility contacts on the Contacts screen. Once finished, click Save/Continue

Next, review and adjust the number of full-time employees and the activities that are done at the facility and again click Save/Continue.
On the General Facility Information screen, read each question as your answers may have changed from the previous year. In our case it is no longer the first year reporting so we need to edit that answer. If you intend on reporting criteria air contaminants, answer yes to the fourth question and answer the related information. Click Save/Continue once you are finished.

You must now validate the information on the “Verify Facility Information” screen. This is information pulled from SWIM and matches some of the questions answered on the “General Facility Information” screen. If you added any information in SWIM, you need to click on Refresh from SWIM to get that information to show up on this screen. Click on Validate to let you know if there are any errors or missing information on the page. Click directly on the error message text to bring you to the error where you can make your corrections. Then click Save/Continue.

This is the substance list screen. In this case, last year’s report contained one substance. Add an additional substance by either clicking on the add icon on the right hand side of the screen or the Add New button below the table.

You can search for a substance in a variety of ways, such as by Programs, Substance Part, CAS RN#, or Substance Name. Then click on the search icon.  Once you have found your substance, add it to the list by clicking the Add icon. Note that if the substance is already on the substance list, then it won’t appear on the Substance Search screen. You can also delete a substance by clicking on the drop-down list to the right of the substance name and clicking on Delete. Select yes to the pop-up warning if you are certain you want to delete the substance.

You must now go through each substance and update the information. Let’s start with mercury by clicking the Edit icon.

The Substance Reporting Status screen may have more questions if you added programs on the Applicable Programs screen. Answer each question carefully before moving on. If you did not meet the criteria for reporting a substance but wished to report it voluntarily, select No on this screen to indicate voluntary reporting.  If you did meet the legal requirements then say Yes on this screen.  Continue by clicking Save/Continue.

Again, ensure that you select the correct answer to each question on the General Information about the Substance screen. This will activate further pages for completion. For example, if you say No to the recycling question, you will not see the recycling screen to enter data. Once finished, click Save/Continue.
This is the On-Site Releases screen, where you enter data about emissions or on-site releases such as releases to air, water or land at the facility. Values are updated by clicking Edit on the right hand side of the category. Note that this facility reported 55 kilograms the previous year.  Click Edit to update the value. Enter the updated value and update the Basis of Estimate if needed.  Once finished, click Save and Return. 

Now scroll through the rest of the screen to ensure all of the information is up to date for the reporting year. Click Save/Continue.

Next, proceed to the disposals screen where you can enter data on transfers on-site and off-site and update any data.  Click Save/Continue.

Next, go to the recycling screen where you again must update the information. Once finished, click Save/Continue to be brought back to the Substance List screen.  From this screen, you can see any substances that still need to be reviewed and updated when the Report Status column indicates the status as New or In Progress.  A Completed status indicates that we have reviewed all of the screens for that substance.

You can run an error check on the entire report by clicking Validate on the Substance List screen. The system indicates that the Pollution Prevention screen has not been completed. In addition, the left menu indicates that the Reasons for adding or removing substances screen still needs to be completed. Access these using the left menu. First, navigate to the Reasons for adding or removing substances screen.

This screen requires you to provide reasons as to why you are adding or removing substances relative to the previous year. The information provided here is used by Environment and Climate Change Canada as part of its quality control exercise. Enter the reasons for adding this substance, if applicable. Next, click Save/Continue.  Now click on the Pollution Prevention option from the left menu.

Update this information and click Save/Continue.

Once all of the screens in the report are complete, the system navigates back to the Reporting Dashboard screen and  the report status is “Ready to Submit”. Click on the drop-down list to the right of the facility report to see the actions available for this report. In this case, we can edit the report if we want to make further changes, delete the report, submit the report, view a summary of the report or generate a report for printing. You can submit the report by clicking on Submit.

Click once on the electronic certification check box. Then click Save/Continue. Finally, click Ok to return to the Reporting Dashboard screen.
Now you will see the submitted report with the date and time the report was submitted. If you need to go back and update the report, click on the drop-down list and choose Update or Update (deletes existing data) to start from a blank report.

This concludes the tutorial on how to create and submit a report to the NPRI using a previously submitted report. If you have any questions, please contact the NPRI. You can get the contact information for NPRI and partners from the Help option on the top menu bar, and clicking Contact NPRI.

What is a Does Not Meet Criteria (DNMC) report and how to submit one to the NPRI

Transcript

Hello and welcome to the tutorial on what is a “Does not meet criteria”, or DNMC report, and how to submit one to the National Pollutant Release Inventory or NPRI using the Single Window system.

A “Does Not Meet Criteria” report lets the NPRI know that your facility did not meet the reporting requirements for the calendar year.

The DNMC report must be submitted online through the Single Window system. A DNMC report does not need to be submitted if an inventory report has never been submitted for a facility. This type of report is only required if a regular inventory report was submitted for the previous reporting cycle. Once a DNMC report is submitted, there is no requirement to submit one for subsequent years.  The owner or operator must simply check the reporting requirements annually to see if they need to submit an inventory report again.

We will now look at how to create and submit a DNMC report online.

This is the Single Window Information Manager homepage or SWIM for short. To learn how to access the SWIM homepage, please visit our tutorial on how to Sign in and navigate the Single Window Information Manager. 

Select National Pollutant Release Inventory and Partners to continue. 

This takes you to the Reporting Dashboard screen.

Before filing a DNMC report, make sure you have your company selected from the first drop-down menu, the report year in the second drop-down list, and DNMC in the third drop-down list. Click the search icon on the right of the screen to bring up a list of all in-progress or submitted DNMC report types for your company. If the desired facility’s DNMC report is not on the list, click “Add New Report” from the bottom to choose your facility.

You will now be on the Find facility screen, where all the facilities that you have access to are displayed. Select the facility for which you want to file a DNMC report by clicking the plus icon to the right of the facility name.

This creates a report on your dashboard screen for that facility. Open the report and begin editing by clicking on the Edit or pencil icon to the right of the facility name.

This will take you to the Applicable Programs screen. First, select the programs to which you want to send the DNMC report and click Save/Continue. The system will prompt you with a pop-up window, warning you that programs cannot be removed later. Select Yes to continue.

This takes you to the “Facility does not meet reporting criteria” screen.  Enter the reason why the reporting criteria were not met for the reporting year in the provided comment field; provide as much detail as possible. Click Save/Continue.

On the “Contacts” screen you must select the appropriate name for each contact type by using the drop-down menus beside each one. If you need to add a name that doesn’t appear on the drop-down list, return to SWIM by clicking on the SWIM button at the top left of the screen, and add the contact under the organization. Once you have selected all the contacts, click Save/Continue.

Next is the “Verify Facility Information” screen. If you click Validate at the bottom of the screen, the system will tell you if you have any errors on this screen and list them at the top. Clicking directly on the text will bring you to the error, where you can make your corrections. Click Validate again to ensure you have fixed all errors. Then click Save/Continue to save the changes and move ahead.

Once the DNMC is complete, you will be taken back to the “Reporting Dashboard” screen where you can perform a series of actions and submit your report. You can perform these actions by clicking on the drop-down list to the right of the facility name. You can edit the report if you want to go back and make changes, delete the report, submit the report, or generate a report for printing. Continue to submit the report by clicking on the word Submit.
You will be taken to the “Report Submission and Electronic Certification” screen. Select the check box for the electronic certification. Then click Save/Continue to complete the submission. Click OK from the pop-up window to return to the dashboard.

You will now see the submitted report with the date and time stamp on the dashboard screen. If you expand the white arrow beside the facility name, you can see more details about the facility, including the date that the report was submitted. You will also notice from the action drop-down list that your options have changed. You can now update the report, generate a report for printing, print a Statement of certification, or view the submission history.

This concludes the tutorial on what is a DNMC report and how to submit one to the NPRI. If you have any questions, please contact the NPRI. You can get the contact information for NPRI and partners by clicking on the Help option from the top menu bar, and clicking Contact NPRI.

What is a Notification of Sale, Closure, or Purchase report and how to submit one to the NPRI

Transcript

Hello and welcome to the tutorial on what is a Sale, Close or Purchase report and how to submit one to the National Pollutant Release Inventory or NPRI using the Single Window system.

If a facility closed, was sold or purchased during the reporting year, the owner or operator is required to notify Environment and Climate Change Canada. For a facility’s closure, enter the date of closure and verify whether or not reporting requirements were met for the portion of the year that the facility was in operation. Then the owner or operator should submit either an inventory report or a DNMC – does not meet criteria report. See the tutorial for How to file a DNMC report for details.

For a sale or purchase, the sale or purchase date is requested, along with information on the old and new facility owners. The person responsible for submitting the NPRI report for the reporting year is the owner or operator as of December 31 of that year. This notification can be done through the Single Window system, which I will now demonstrate.

This is the Single Window Information Manager homepage or SWIM for short. To learn how to access the SWIM homepage, please visit our tutorial on how to Sign in and navigate the Single Window Information Manager. 

Click National Pollutant Release Inventory and Partners to continue. 

This takes you to the Reporting Dashboard screen.

To file a Sale, Close or Purchase report, ensure you have your company selected, the report year, and the Sale, Close or Purchase option from the Report Category drop-down list. Click Add New Report from the bottom to choose your facility.

You will now be on the Find Facility screen, where all the facilities that you have access to are displayed. Select the facility for which you want to file a Sale, Close or Purchase report by clicking the plus icon to the right of the facility name.

This creates a report on the Reporting Dashboard screen for that facility. Open the report to begin editing by clicking on the Edit or pencil icon to the right of the facility name.

This takes you to the Sale, Close or Purchase screen. First, you must select the appropriate radio button to indicate whether you are submitting a Sale, Close or Purchase report. Then enter the date where the Sale, Close or Purchase came into effect.

For a Sale or Purchase report, you must enter the information about the previous owner and the new owner in the fields provided. You must also, answer the questions at the bottom of the screen concerning releasing NPRI records and the last year of known reporting to the NPRI.

For a Closure report, you are only required to enter the effective date.

Once you have completed all the details on this screen, click Validate and correct any displayed errors.  When finished, click Save/Continue.
This will return you to the Reporting Dashboard screen where you can perform a series of actions and submit your report. If you click on the drop-down arrow to the right of the facility report, you will see the actions available for this report. In this case, we can edit the report if you want to make changes, delete the report, submit the report, or generate a report for printing. We will now continue to submit the report by clicking on the Submit.

This takes you to the Report Submission and Electronic Certification screen. Select the check box for the electronic certification, then click Save/Continue to complete the submission. Click OK to return to the Reporting Dashboard screen.

Now you will see the submitted report with the date and time the report was submitted. If you need to go back and make further changes to the report, click Update.

This concludes the tutorial on what is a Sale, Close or Purchase report. If you have any questions, please contact the NPRI. You can get the contact information for NPRI and partners by clicking on the Help option from the top menu bar, and clicking Contact NPRI.

How to validate, submit, print, and update NPRI reports

Transcript

Hello and welcome to the tutorial on how to validate, submit, print and update a report to the National Pollutant Release Inventory or NPRI using the Single Window system.

This is the Single Window Information Manager homepage or SWIM for short. To learn how to access the SWIM homepage, please visit our tutorial on how to Sign in and navigate SWIM.

Click National Pollutant Release Inventory and Partners to continue.

This takes you to the Reporting Dashboard screen.

You can see the completion status of any report you created at any time from this screen. If you have a report status of In-Progress then you must complete all of the screens in the report in order to be able to submit it. The report status must say “Ready to Submit” in order to proceed to the Submission screen. If you have an In-Progress report but don’t know where your errors are, you can check where the errors are by going into the report.

Open the report and begin editing by clicking on the Edit or pencil icon to the right of the facility name.

This will take you to the Applicable programs screen.  Navigate to the Substance List screen by selecting it from the left menu.

You can tell where the errors in the report are by clicking Validate on the Substance List screen. This runs an error check on the entire report. In this case we find incomplete pollution prevention screens and one or more substance reports not being completed.

If you look at the Report Status in the Substances table, you can see which substance needs to be completed. Ensure that your Programs and Report Status filters are set to “All” to ensure that all substances are showing. A substance that has not been completed will have the status listed as In Progress.  Click Edit or the pencil icon on the right-hand side to complete all the information for this substance.

The left menu is now expanded again and you can see the screen with the  error as it will have an orange exclamation mark in the left menu. Click on it to go directly to that screen.

If you click Validate on the bottom of the screen, the errors will pop up at the top. You can click on them one at a time to go directly to that section on the screen. In this case, the on-site releases screen is missing the breakdown of annual releases and the reasons for changes in quantities released from the previous year. Make the selections and click Validate again to ensure you have saved all of the changes on this screen. Once you have corrected the errors, you will see a green check mark on the left menu for that screen. Then click Save/Continue.

Click on the Substance List screen from the left menu and click Validate again. The Pollution Prevention section on the left menu still has an orange exclamation mark. Click on this section.

Ensure to fully complete the Pollution Prevention screen. 

Click Save/Continue to return to the Reporting Dashboard screen.

Now you should see a status of “Ready to Submit”. If you have more than one report that is ready to submit, you can select “Submit in Batch” from the bottom left of the dashboard.  Select Submit from the action drop-down menu to proceed to the Report Submission and Electronic Certification screen.
The Report Submission and Electronic Certification screen requires you to select the authorization checkbox, and if you are doing a batch submission, selecting the multiple reports to submit. Then click Save/Continue to complete the submission. Click OK to return to the Reporting Dashboard screen.

Now you will see the submitted report with date and time the report was submitted. 

Click on the drop-down arrow to the right of the facility report.   The action items have now changed. You can update the report, print a summary report or generate a full report, print a statement of certification and see the history of submission.

If you forgot to include something or need to make changes to the submitted report, select Update from the action menu. You would only select the option of Update - deletes existing data if you want to erase all of the data to start from a blank report. Most users simply want to make updates to the existing data. Do this by selecting Update.

You will first be required to provide a reason why you are making the update.  Then click Save/Continue to go into the report. Then make your edits in the report, clicking Save/Continue throughout. Once you are finished click Reporting Dashboard on the top left menu.

After an update has been made, you will see that you have to resubmit the report. If you click the white arrow before the facility name, the information will expand, and you will be able to see the report has been submitted once in the past. You can also see these details by clicking on the drop-down arrow and selecting History.

Now click Submit. Check the authorization box and then click Save/Continue to re-submit the report. Click OK to return to the Reporting Dashboard screen.

Now, if you expand the white arrow again, you can see the report has been submitted twice.

To print a summary from the Reporting Dashboard, click on the drop-down arrow and select Summary Report.

You can print the summary by clicking Export from the bottom left of the screen in order to export a summary of the report to pdf, and then printing the pdf.

Click Back to return to the Reporting Dashboard screen and if you wish to print a full report, click on the drop-down arrow and select Generate Report.

This concludes the tutorial on how to validate, submit, print and update a report to the NPRI. If you have any questions, please contact the NPRI.  You can get the contact information for NPRI and partners by clicking on the Help option from the top menu bar, and clicking Contact NPRI.

How to report for the Part 4 and Part 5 Volatile Organic Compounds (VOCs)

Transcript

Hello and welcome to the tutorial on how to report for the Part 4 and Part 5 Volatile Organic Compounds or VOCs from all sources and stacks to the National Pollutant Release Inventory or NPRI using the Single Window system.

This is the Single Window Information Manager homepage or SWIM for short. To learn how to access the SWIM homepage, please visit our tutorial on how to Sign in and navigate SWIM.

Click National Pollutant Release Inventory and Partners to continue.

This takes you to the Reporting Dashboard screen. Open the report and begin editing by clicking on the Edit or pencil icon to the right of the facility name.
Click on the Substance List item on the left menu. This takes you to the list of substances you have chosen for your report.  If you do not have “Volatile Organic Compounds (VOCs)” on your substance list already, then you need to add it. Click the plus sign on the right of the screen to go to the Substance Search page.

You can search by Programs, Substance Part, C-A-S Registry Number or Substance Name.  We will search by Substance name. Type “volatile” into the search field under Substance Name and click the filter icon to the right. When you see “Volatile Organic Compounds” in the search results, click the Add row icon to the right of it and this will add it to your substance list and return you to the Substance List screen. Please note that Part 5 Speciated VOCs are only required to be reported to the NPRI if you meet the 10-tonne release threshold for Part 4 Total VOCs. Therefore the Part 5 Speciated VOC list is not available from the previous Substance Search screen.

Once you have added VOCs, continue into the report by clicking Edit Selected Substance to the right.

From the drop-down menu, select Yes if the substance meets the criteria for reporting to the NPRI or No if you are voluntarily reporting.  You can also add any general comments about this substance in the Comments box provided. Click Save/Continue.

On the General Information about the Substance screen, if you met the one-tonne release threshold or stack release threshold for any of the Part 5 Speciated VOCs, select the checkbox on this screen to activate the Part 5 Speciated VOC list. You can leave the box unchecked if you did not meet any release thresholds for the Part 5 Speciated VOCs. Click Save/Continue.

On the On-site Releases screen, you report all Part 4 total VOC releases from the entire facility in the first 5 categories.  Let’s say you had 50 tonnes of total VOC releases from all stacks at your facility, and you had 25 tonnes of total VOCs releases from fugitive sources at your facility.

You would first enter the fugitive releases data by clicking on edit to the right of that category. This opens up the onsite releases/disposals page.   Select the basis of estimate used for the calculations. Then enter the quantity in the quantity field. When you are done, click Save and Return.

You will now see the value on the main On-site Releases screen. To enter the stack data, click edit to the right of the stack category.

Again, select the basis of estimate used for the calculation. Then enter the total Part 4 VOC release quantity:  this is the total for Part 4 VOCs from the entire facility from all stacks.

If you have a stack 50 metres or more above grade, then you must report the Part 4 VOCs from that stack separately on this screen.  Go to the section called Stacks (greater than 50 metres) and ensure you have entered the information about the 50 metre stack in SWIM, so that it shows up on this screen. If you have not entered that information in SWIM, you can visit our tutorial on how to Sign in and navigate SWIM to learn how.  To enter the data for it, click Edit from the right drop-down menu.

At the top of the screen enter your Part 4 VOCs that came from this stack alone. Let’s say that of the 50 total VOCs at the whole facility from stacks, 10 tonnes came from this stack.

The next part of stack reporting is Part 5 Speciated VOCs. In this example you have 10 tonnes of all VOCs coming from this stack. From those 10 tonnes, let’s enter 2 tonnes of 1,2,4 trimethylbenzene and 3 tonnes of 1,3 butadiene in the quantity fields beside those substances. Then click Save and Return to go back to the stack screen.

I have completed my Speciated VOC reporting for this 50-metre stack only. Now click Save and Return to go back to the main On-site Releases screen.
Now there is data in the Stack or Point Releases field, the Fugitive Releases field and the Other Sources – Speciated VOCs field. The Other Sources – Speciated VOCs field is where you enter data for Part 5 Speciated VOCs that were released at your facility that did NOT come from the 50 metre stack.
So let’s say you had 5 tonnes of Speciated VOCs from fugitive releases and 5 tonnes of Speciated VOCs from stacks or point sources less than 50 metres.  To enter this data, select Edit in the Other Sources – Speciated VOCs category to go to the VOC Breakdown screen

Enter the values for Speciated VOCs in the quantity fields. 

When you are finished click Save and Return.

Once completed, click Save/Continue.

This concludes the tutorial on how to report for the Part 4 and Part 5 VOCs from all sources and stacks to the NPRI. If you have any questions, please contact the NPRI.  You can get the contact information for NPRI and partners by clicking on the Help option from the top menu bar, and clicking Contact NPRI.

How to use the NPRI query site

Transcript

Hello, and welcome to the video tutorial for the NPRI query site. This demonstration will provide an overview of how to access and use this tool to obtain information reported by facilities to the NPRI, as well as some high level summaries of the data.

The NPRI includes information collected from approximately 7,500 facilities across Canada on over 300 substances, based on specific criteria for reporting.

There are three options for querying the data: the NPRI data search box; pre-defined queries; and custom queries.

On the right hand side of the NPRI home page is a NPRI data search box, which allows the user to either perform a quick search by facility name or postal code, or enter the query site by selecting ‘More Search Options’.

If you are interested in a particular facility, say from an article in the newspaper, simply type the facility name, click send, and you will be provided with a list of facilities that have a match in the name. If you are interested about a particular location, such as your neighborhood, simply enter the first three digits of the area’s postal code, click send, and the query site will return a list of facilities that are in that area.

Choosing “More Search Options” brings the user to the main query site page. From here, there are two broad options - ‘pre-defined’ queries, which show high level summaries of the NPRI data, and ‘Custom’ queries, which allow the user to select a list of facilities that meet a series of criteria.

There are 4 pre-defined queries for the user to choose - Total On-site releases by substance provides a list of all substances for which facilities reported information on, with total amounts released by all facilities for the 5 most recent years. The information is grouped into Air, water, and land releases, and each of these three media can be jumped to by clicking on the shortcuts available at the top of the page.

Total on-site releases by industrial sector shows each sector, with releases totaled across all substances, and the number of facilities reporting, for the most recent 5 years, sorted alphabetically. The right-most column on the table provides an icon that links to a list of facilities in the sector.

Highest on-site releases by substance shows the ten substances with the highest reported releases for the last five years. The right-most column contains icons that link to lists of facilities that reported releases of that substance.

“Highest on-site releases by province” is the same as the previous table, with added provinces. As before, the right-most column contains icons link to a list of facilities that reported on the substance in the province selected.

Under each table is a link to the NPRI downloadable datasets page. These data sets are available for download in CSV format under ‘Facility data’.

Clicking on “View Custom Query” shows options for creating a list of facilities that meet a specified set of criteria. Criteria include Company or Facility name, Substance, Location and Industry. While a list can be generated with any combination of these criteria selected, care must be taken to not choose two inconsistent selections in the same criteria. For example, choosing a substance by name and then choosing a different substance by CAS number in the same search will return an error message.

As an example, we could select Mercury under substance, Alberta under Province, and Electricity under Key industrial sectors. Clicking ‘Submit’ starts the search.

The search results show the criteria we chose and the number of facilities that met those criteria in 2013. Below is a table with these facilities, and their total releases and transfers. Clicking on a facility will bring us to that facility’s main page.

The facility main page shows information about the facility itself, such as Name, address, and industry. Further down the page we see a summary of the facility’s reported releases, disposals, and transfers for recycling for all substances that it reported on. The summary on reported releases of criteria air contaminants is separate from the main table.

The right hand column contains links to information from environment Canada on several substances, where you can find information on how the government is regulating and monitoring the environmental impacts of this substance.

Clicking on a substance will bring you to the substance report page. This page shows a detailed summary of the facility’s report for one substance, with breakdowns of the releases by source, and Disposals and Recycling broken down by activity. Comments reported by the facility are in a separate Reporter Comments box.

Going back to the facility main page, there is a link under ‘Substance Reports’ called ‘Other Year’s Substance Reports’. This link will take you to a page that shows a multi-year summary of releases and transfer from the facility for all substances. This page allows you to see how quantities reported by this facility have changed over time. Clicking on any of the years will take you to the relevant Substance report page.

In conclusion, the query site is a useful tool for helping you find out information about a particular facility of interest, and it provides some high level summaries in a quick to access format.

There are a number of factors to keep in mind when using and interpreting NPRI data. These can be found in the link “Using and Interpreting NPRI Data” from the Home page.

If you wish to obtain more information about the NPRI, please contact the NPR I by email or by phone, as shown on the “Contact” page.

Thank you for your interest in the NPRI program.

How to use NPRI map layers

Transcript

Hello, Welcome to the video tutorial for NPRI data users. This module addresses how to access NPRI data using a map layer for use with virtual globe software such as Google Earth™. First, we will show you how to obtain the files and then do a demo about its content and how to use it.

The NPRI includes information collected each year from approximately 7,500 facilities across Canada on over 300 substances, based on specified criteria for reporting.

The map layer allows visualizing the location of all facilities reporting to the NPRI for a given year, as well as the data reported by each facility. But keep in mind that a facility's "Placemark" may not fall directly on the facility in Google Earth™, due to differences in map projections or errors in a facility’s coordinates.

First, go on the NPRI home page

From there, click on “Pollution Data and Reports”, “NPRI Mapping”, and then “NPRI Map Layers for Use with Google Earth™”.

In order to be able to use this data format, you need to have Google Earth™ or any other virtual globe software that is compatible with .kml or .kmz files installed on your computer. An Internet connection of at least 128 kilobits per second is required to run Google Earth™.

Google Earth can be downloaded for free by clicking on the link “Download Google Earth™”. Follow the instructions in order to install the software.

Once this is done, download the map layer to your computer. The two most recent data years are usually available, in English and in French, as single year files.

To view the map layer, double-click on the file you’ve just downloaded and it will open in Google Earth. You should now see the location of all facilities reporting to the NPRI on the map.

Each color represents a different industrial sector, as shown in the legend on the lower left hand corner.

The file contains two sets of folders: the facilities are grouped by province in one and by industrial sector in the other. You can choose between the two by selecting the province or the industrial sector radio button. If the “Off” radio button is selected, all the NPRI layers are turned off and will not be visible in Google Earth.

In the expanded menu, you have the option to check and uncheck the province when the “By province/territory” radio button is active, or the sectors when the “By selected sectors” radio button is active. This allows you to display facilities in one or many provinces or sectors at a time.

By further expanding the province or the sector folder, you will get a list of facilities in each province or sector, depending on which radio button is activated. You can unselect facilities by unchecking the check boxes and they will not be visible on the map anymore. If you double-click on any facility’s link, a pop-up balloon containing the facility’s releases, disposals and transfers information will be displayed and Google Earth will automatically zoom to this facility’s location.

When hovering on any placemark, the name of the facility will be displayed and when you click on the placemark, a pop-up balloon containing the name of the facility, NPRI ID, as well as a summary of pollutant release, disposals and transfers information for that facility will appear. It also contains a link to this facility’s information page on the NPRI query site, another format in which NPRI data is provided.

To search by name for specific facilities that have reported to the NPRI, type "CTRL+F" and enter the facility's name into the search box at the bottom of the Places panel. In this example, let’s search for Syncrude. Scroll through the facilities containing the specified name by clicking the up and down arrows. Once you found the facility you were looking for, double-click on the facility’s link to view the reported data and zoom in to that specific facility.

Google Earth also allows you to search by location, for example, city, street address, latitude and longitude. By typing the name of a city - for example, Sudbury - in the Search panel and clicking Search, Google Earth will zoom to that city and this will allow you to see all the facilities reporting to the NPRI located in Sudbury. You can also zoom in or out by using the slider at the top right of the map.

Finally, Google Earth has a functionality called Street View, which allows you to go down at street level and see the facility as if you were walking by. Not all areas of Canada have this functionality, but most cities do. You just need to drag and drop the orange icon that is located above the scroll bar on a street that is highlighted in blue. The blue line that appears indicates that Street View is available.

You can access additional information about the NPRI map layer by clicking on the help file in the “Map Layer for Use with Google Earth” web page.

There are a number of factors to keep in mind when using and interpreting NPRI data. These can be found in the link “Using and Interpreting NPRI Data” from the NPRI Home page.

If you wish to obtain more information, please contact the NPRI. Thanks you for your interest in the NPRI program

How to use NPRI Excel tabular data

Transcript

Hello, this is a tutorial on how to access the National Pollutant Release Inventory, or NPRI data using the Excel spreadsheet.

First, we will show you where to obtain the Excel spreadsheet. Then, a quick description of the spreadsheet will be shown.And finally, you will see an example of data use.

The NPRI includes information collected each year from approximately 7,500 facilities across Canada on over 300 substances, based on specified criteria for reporting.

To access the NPRI Excel spreadsheet from the NPRI Home page, click on “Pollution Data and Reports” link.

Click on “Downloadable NPRI and Air Pollutant Emissions Datasets” link.

You will find the downloadable Excel files in the top table.

2 years are available: for 2012 and 2013.

When you click on the 2013 file, a pop-up window appears and you will have the option of opening or saving the file on your computer.

The Excel file contains the most commonly used data, such as company information and release quantities.

The fourth row of the spreadsheet lists the headings, starting with the year, NPRI id# and Company and facility information.

If you scroll to the right hand side, you will find geographical data, sector descriptions, and substance names.Each row contains 1 substance report from 1 facility.

Further to the right hand side, for each substance report, you will find quantities reported as releases to air water land and you will also find on-site and off-site transfers for disposal quantities, and finally off-site transfers for recycling quantities.

The Excel spreadsheet is easy to use and is helpful to find or extract data. If you click on the arrow, you have the option of sorting the column alphabetically or numerically, or you can also filter out information in order to find specific data.

For example, if you would like to know who reports air releases in the city of Ottawa, click on the arrow beneath the City Heading, deselect all the city names, and scroll down to Ottawa and select it. You will then notice that the City column now shows a filter which indicates that only Ottawa is selected.

By scrolling to the right, you will find the list of substances reported by facilities in Ottawa along with the quantities released to air, water and land, as well as disposals and transfers for recycling.

If you are further interested in air releases, you can sort them in the Total Air Emissions column, from the Largest to the smallest values, and obtain a sorted view of Total Air releases in the Ottawa area.

Then you may be interested in only viewing air releases of Nitrogen oxides. For this, go to the Substance Name column, deselect all the substance names, scroll down to Nitrogen oxides and select it. You will then obtain a shorter listing of the Ottawa facilities that reported air releases of nitrogen oxides, sorted from the largest to the smallest quantities.

In conclusion, the spreadsheet is user-friendly and allows you to navigate, sort and filter NPRI information depending on your interests, including company names, locations such as city or province, industry sectors, substance names and media such as air/water/land releases, disposals and transfers for recycling.

There are a number of factors to keep in mind when using and interpreting NPRI data. These can be found in the link “Using and Interpreting NPRI Data” from the Home page.

If you wish to obtain more information about the NPRI, please “Contact the NPRI” by email or by phone, as shown on the Contact page.

Thank you for your interest in the NPRI.

Report a problem or mistake on this page
Please select all that apply:

Thank you for your help!

You will not receive a reply. For enquiries, contact us.

Date modified: