>>Lissa McCracken: So, this is Lissa McCracken
with KPPC and also the ESRC representing EPA Regions 3 and 4, and so we’re happy to have
everybody on the call. We’re doing this as a joint Region 3 and 4
call, and the purpose of the call, really, is to share a little more about the Qlik Sense
tool, which helps explore information about the TRI and P2 information for the Food Manufacturing
sector. Many of you were there in Philadelphia when
Jeff come with the EPA, demoed it for us, and kind of introduced us to it. Some of you who were on a E3 call that we
did with E3 Alliance. We also did a demo for it. But now, as EPA has progressed working on
this tool, we wanted to kind of get it out to the larger group because they’ve definitely
done more work with it and find it to be a resource to share. And so the way the day is going to go we really
want it to be interactive and have some discussion. Vaughn Cassidy with the Tennessee Department
of Environment and Conservation’s going to be sharing a highlight of one of their stories
and projects that they’re working on, so we’re going to see how this tool may be able to
help with that. Jeff Kohn with headquarters at EPA is going
to … I’m going to turn it over to him in a minute. He’ll have some remarks to kick us off. Then turn it over to TJ Pepping who’s been
working as a contractor with Jeff to get this rolling, and as TJ’s going through the process,
please feel free to talk, ask questions, anything that you can think of. This is a good time to get your questions
answered. And then we will wrap up. Start our wrap up by 3:15 and then work to
get everybody off the call by 3:30 at the latest. So we’ve got plenty of time for discussion,
and at this point, Jeff, I’m going to go ahead and turn it over to you.>>Jeff Kohn: So welcome, everybody, and thanks
for being on the call. This is, for some of you, maybe the second
or even third time you’ve seen the tool, but we really only just released it to the public
after getting great feedback from you in Philadelphia. Again, great feedback from during the E3 call,
and now it’s something that is available to the public, and I’m hoping it becomes a tool
that multiple people can use. That’s why we’re calling this more of a training
session where my goal is for people to be able to use this tool for themselves, and
they don’t need to access me or Lissa or anybody else; they can use it anytime they want. So I just want to step back for a second for
anybody who hasn’t been involved in this effort to take a moment to tell you why we developed
this tool. Here’s the thing. When I first came on and they asked me to
think through the Food Manufacturing industry, I got together with my TRI colleagues, and
I’m hoping Sandra Gann is on the phone. Are you on the phone?>>Sandra Gann: I am, Jeff.>>Jeff Kohn: Okay, great. She and I got together, and when we talked
about how … she’s from the TRI, the Toxic Release Inventory Division, the program division,
and we said we really wanted profile the Food Manufacturing industry. We both had an interest in doing this. She has also a strong interest in pollution
prevention from the TRI perspective. So as we started developing the profile, which
is a document that we hope to publish in the near future, we were talking about different
ways of visualizing the data. And as we were talking to the contractor,
they said, “Well, why not use data visualization?” And I got to tell you I Knew nothing about
data visualization at that point. I Had heard the term before. I had no idea what it meant. That there was this idea that you could be
interactive with the data, and you could narrow down the way you view the data to be specific,
or customized, to what you’re doing. And we took a first look at it, and we really
thought there was something special there. And I think, honestly, that this is probably
the first of many tools you’ll start seeing in data visualization. And I think it’s a great start, and we’ll
start seeing more and more from EPA and from other places. So we started developing the data visualization
tool in parallel with the report, and it just so happens that the data visualization tool
became available publicly before the report. So the report is still not available, but
I want to make sure that everybody is aware that there is a report coming. It does a really nice job of summarizing the
Food Manufacturing industry and summarizing pollution prevention possibilities and descriptions. So they really kind of go hand in hand. This is more of a focused data-driven look
at the information. Now, the other think I want to make sure you’re
aware of before I hand of to TJ is that this is Toxics Release Inventory information, which
is really, really excellent information if a facility reports to it. And the criteria is you have to have ten or
more employees, and that’s pretty normal for pollution prevention. We work with smaller facilities, but usually
it’s above ten employees. But the other criteria is you have to manufacture
or process 25,000 pounds of any one toxic chemical or otherwise use 10,000 pounds of
any toxic chemical. So you really have to be … and that doesn’t
include the persistent bioaccumulative and toxic chemicals, but, yeah, that’s another
… there’s all sorts of nuances here, but the basics is you really have to be managing
or using a good amount of these chemicals to have to report. And we’re actually working on a separate … we’re
starting to think through doing separate state reports to characterize the industry within
each state, and we’re starting with California. And one thing we’re realizing, cause we’re
comparing the TRI data to the Dun & Bradstreet data, is that for some of the sub-industries
in Food Manufacturing, the TRI data does a pretty good job of describing it. Like the Meats industry … in California,
it describes about 25% of the industry, but for some of the other subsectors, like bakeries
and tortillas, it’s less than 5%. What this ends up being is an excellent start
to the types of information that’s available in the industry, but there’s more layers to
unfold as you work with the industry. That’s the things I wanted to cover before
I hand off to TJ. Any questions for me before he gets started? Okay, TJ, take off!>>TJ Pepping: Okay, great. So again, this is intended to be a fairly
interactive presentation. Feel free to interrupt with questions at any
time. My plan for this is kind of give a brief overview
of Qlik Sense in general and just kind of why it’s used for data visualization at EPA
and sort of the different features and capabilities of it at a high level. Then I’ll walk through the different pieces
of the Food Manufacturing application that we’ve built, and I’ll go through a specific
demo how you might use the application to drill down and get some insight into pollution
prevention opportunities. So Qlik Sense, it’s … their kind of jargon
for it is, “A self-service data visualization tool.” And essentially what that means is it’s intended
to provide the user a chance to very quickly and easily change different selections within
the data that you’re looking at, explore different trends, different relationships amongst fields,
and kind of quickly see how all of that changes across the different charts and maps, figures
that you may have incorporated into the applications. And really just kind of tease out different
either narratives or trends. Gain more insight into the data that you’re
looking at. It can be data related to your business, data
related to health. In this case, we’ve incorporated the TRI chemical
release data and pollution prevention data just to provide more insight into opportunities
within the Food Manufacturing sector. So it was recently selected by EPA as their
kind of preferred data visualization platform because of a lot of the different capabilities
it provides. You can attach a lot of different sources
to it. You can quickly look at a lot of different
data. Just prior to this call, I was on another
one demoing another app we’ve built that has millions of records, and it takes a few seconds
to quickly change the year or the chemical that you’re looking at. So, there’s a lot of capabilities that Clix
offers in terms of just quickly looking at data and helping to better visualize it. The license the EPA has purchased for Qlik
Sense allows them to develop these public applications, so you don’t have to download
any kind of software. There’s no login required for the ones that
are public. You just can access them via most browsers. Later in this, I’ll share the links so that
if you want to follow along with the demo I give for the Food Manufacturing application
you can follow along. I believe that link was included in the meeting
invite, but I’ll share that again later as well. One of the nice things with Qlik Sense, in
addition to being accessible just via whatever browser you have, is that it has a responsive
design, which means you can look at it whether you’re on a desktop, if you’re on your tablet. The charts and maps are designed to just respond
to whatever the screen size is. Quickly change what’s shown on the screen
to just fit whatever viewing platform you’re using. So just another nice feature of Qlik Sense
that makes it kind of more adaptable and allows the users to more easily and quickly interact
with the visualizations included. So that’s kind of why Qlik Sense is being
used as the data visualization platform for EPA. Again, this Food Manufacturing one is just
one of the first, but I’m assuming there’ll be a lot more down the road that you’ll see. So specific to the pollution prevention profile
that we developed for Food Manufacturing, it contains TRI data for roughly the past
ten years, so from 2005 through 2015, which is the most current reporting year available. Links to them are included in a few places
on EPA’s pages, including the most recent National Analysis, which has a specific profile
on the Food Manufacturing sector. There’s also a link on the pollution prevention
page. So this really hasn’t been publicized as a
public tool even though it is available publicly. Part of that is we’re still kind of … it’s
definitely a iterative process. As we’ve been doing these webinars and sharing
it with regional stakeholders, other folks, and just getting more input on how to improve,
this has been really helpful. So as you’re going through this if you have
any ideas for things we can include in the next iteration of this, I’m more than happy
to hear that. This is a link here. I’ll copy it over into the chat window in
a bit, so if you don’t have that pulled up from the meeting invite, I’ll add that to
the chat window in a bit so you can quickly get to that. One caveat is … even though I said it’s
accessible with pretty much any browser, one limitation is that if you have Internet Explorer
10 or earlier it won’t work. Most people, I think nowadays, have either
11 or 12, so it shouldn’t be an issue. But if you are trying to open this in Internet
Explorer, and it doesn’t’ work, it might just be that you’re version of Internet Explorer
isn’t up-to-date. Other browsers should work. I’ll do the demo in Chrome. Works in Firefox as well, so you should be
able to access it through most browsers. If for whatever reason you’re not able to,
you can always at this point just follow along the demo through the WebEX window and access
it later. We’ll have a recording provided so you can
always go back through and kind of walkthrough the demo again if for whatever reason you
can’t follow along yourself. Are there any questions about kind of Qlik
Sense in general at this point? If not, I’ll just jump right into the tool
itself. Okay. In that case, so you should see in the WebEx
screen the tool right now. I’ll add the link to the chat window if you
want to access it yourself. If you want to follow along with looking at
it in WebEx, there should be a sort of zoom full screen button that’ll just make it a
lot easier to follow along because there’s a lot of detail in some of these charts. If anyone is having trouble seeing it, just
let me know. Otherwise, I’ll continue with kind of walking
through what we’ve included here. So, again, this is publicly available. You just have to go to this URL from pretty
much any browser on either your desktop, your tablet, and things will resize kind of automatically. I’ll walkthrough some of the kind of the layout
of everything just to kind give a sense of what we’ve included, and then as I said before,
after that, I’ll kind of walkthrough a specific demos how you could walk through the information
that’s included in this tool to kind of drill down and get some key insights into potential
pollution prevention opportunities. So, Qlik Sense in general … as I said, it’s
set up to kind of quickly enable the user to toggle through different filters and different
settings. This black bar at the top is kind of a key
feature, the selections bar. Right now, you’ll see it says, “No selections
are applied.” That means there’s no selections applied. As we walkthrough this and make different
changes, you’ll see that change. I’ll point that out as we’re going through
and kind of the different features that are available through this selections bar. How we’ve laid out this Food Manufacturing
profile this gray header is available at the top of every page. It just provides kind of a home base with
some key information. So you have some of these key performance
indicators like the number of facilities included in the current selection, the total releases
associated with those facilities. So, again, we’re looking at all Food Manufacturing
facilities that reported to TRI, from 2005 through 2015, at this point. And you’ll see these numbers change as we
kind of drill down into different selections. These right here are the different tabs included. So I’ll walk through each of these before
doing the demo just to kind of give you a sense of what we’ve included here. And then at the bottom of this gray bar are
these different filters. So we’ve included some of kind of the key
fields that we thought people would be interested in. So you can quickly go to subsector and select
one chemical, year, and drill down for region, state, zone, so on and so forth. And at any point, if you want to kind of free
up screen real estate to lookup some of the actual visualizations, you can just use this
green toggle selection panel button to toggle that on and off. So it just provides more room. You can always click it to turn it back on. Just something if your laptop screen happens
to be fairly small. It just kind of helps. You can use the header to make some selections
from the filters and then toggle it off to really provide more real estate to look at
the actual visualizations. So that’s kind of like I said. You’ll see that the headers are there throughout
all of these. I’ll walk through the individual tabs now. So this first one on the landing page is the
facility map. So this is showing a map of all the facilities
included in this profile. So currently they’re color coded by subsector
within Food Manufacturing and sized by release. So the larger one of these dots is, that means
the more releases that were reported to TRI from that facility. So you can see a kind of the difference in
size across the US. If you’re interested in looking at these in
a different lens, we’ve also included a legend related to some kind of demographic index. I believe that was one of the items of feedback
Jeff got from one of his demos that people were interested in looking at, some kind of
environmental justice indicator. So what we did was pulled in … we created
a demographic index based on some information included in EJ’s screen just based on census
data. So when we toggle this demographic index view,
it will now color code the facilities by an index that we’ve set up that’s based off of
the percent of the population living within three miles of each facility. Oh, sorry. I lost connection. Let me reload this. There we go. It’ll just take a bit to reload. And turn off wifi. So we set it up to just be based off of this
demographic index. So it’s the percent of the population living
within three miles of the facility that is either of minority status or living below
the poverty threshold. So, again, if we just click that button, it’ll
toggle the legend color coding. So now you can see it’s colored by demographic
index. The redder a facility is it means the higher
the index is, so the more of the population living near that facility that’s either of
minority status or low-income. So it’s intuitive just to provide kind of
a different way to look at these facilities. You can always toggle it back on to show the
subsector view.>>Pam Swingle: I have a quick question. Can we ask questions?>>TJ Pepping: Oh, yeah. Yes. Of course.>>Pam Swingle: This is Deanne [00:19:07]
Swinger from Region 4. Do you guys have the background information
that explains, located somewhere on the site, that gives us how the data has been incorporated,
like the explanation that you just gave, from the website? Do you know what I’m asking?>>TJ Pepping: Yeah. So, most of the information is just pulled
directly from TRI. Some of these other ones we did try to include
a little bit more of an explanation if it was something we added to supplement the TRI
data.>>Pam Swingle: Okay.>>TJ Pepping: I think that’s something, certainly
moving forward, if we end up including more sources of data beyond TRI. Probably kind of a good practice to follow
is making sure it’s clear what all these different fields are, how we’ve kind of incorporated
them. Anyway, so I’ve mentioned with Qlik Sense,
if you do make selections, the charts will update. So right now let’s get into the facility map. If you wanted to delve into a certain subsector,
for example, Grain and Oilseed Milling. We can just do that from these filters, and
the map will automatically update. So you can see now the only facilities shown
are those in the Grain and Oilseed Milling subsector. If you wanted a specific region, maybe Region
4, we can just select that there, and now we’ll see those facilities specific to Region
4. And again, if you look up in the selections
bar, that gray-black bar at the top. You can see now, instead of no selections
applied, it now shows we’re looking at, for subsector, Grain and Oilseed Milling, and
for EPA Region, 4. One thing with the region filter here is we’ve
built it so once you’ve selected a region, it’ll drill down into the states within that
region. So if we want to get rid of the selections,
there’s a few ways to do it. We could select this little x here to clear
the selection. So now we’re back to just looking at Grain
and Oilseed Milling. If you want to clear all at once, you can
click this button here to clear all selections, and that’ll just clear everything, and you’ll
start fresh. You could also … if we had selected Region
4 from here, we could always go back to this filter and select a different option here. Maybe we’ll select everything but Region 4. So you can see now that Region 4 is kind of
excluded from the map. So there’s a few different ways to click around. No pun intended. But again, you’ll see as we go through this,
any selections we have in this gray-black bar at the top will apply through all the
different fields, sorry, all of the tabs and visualizations. So if we go back … let’s do Grain and Oilseed
Milling. We have that here. If we now work through the next tabs for source
reduction activities. So you’ll see here at the top that that selection
on subsector is still applied. So right now we’re looking at the source reduction
activities specific to facilities in the Grain and Oilseed Milling subsector. So this tab here is just providing a chance
to look at the source reduction information that’s reported to TRI. We have these radio buttons here on the left
that work through the eight different categories of source reduction activity. So, for example, if you wanted to look at
… it looks like a lot of Grain and Oilseed Milling facilities report process modifications. So if we wanted just to look at those facilities
which reported process modifications, we can just select that from the list. You’ll see that at the top now, and so any
facility that reported process modifications in Grain and Oilseed Milling is now shown. One caveat is that facilities can report multiple
source reduction activities so that’s why there’s still some of these other categories
showing up. It just means those facilities may have reported
process modification and good operating practice or something like that. I’ll go ahead and clear all of this selections
now. So some of the other pieces we’ve shown in
here, just looking at the top chemicals and which activities are reported, looking at
the top chemicals and subsectors. We’ve included a facility list here, which
we’ll come back to later, that if you find a specific facility that reported a chemical
and activity you’re interested in, you can just click on this P2 Report link. And it’ll take you to the Envirofacts facility
report for the P2 information reported by that facility, which just allows you to get
even more insight into what that facility might be doing in terms of source reduction. We’ll come back to this later as part of the
demo, but this just kind of gives you a sense of what’s included here. On the waste managed tab, we’ve included some
different visualizations to look at the waste managed. One thing you’ll note here on the map you
can see, if we’re looking at all facilities across all years and subsectors, Illinois
really stands out as an outlier. That’s because there happens to be one soy
bean processing facility in Illinois that is just kind of an order of magnitude beyond
all the other facilities in terms of the waste reports. It just happens to recycle a lot of n-Hexane,
which is used to … it’s a solvent that’s used to extract the oil from soybeans. And it just reports a lot. We’ve checked [inaudible 00:24:50] to verify
that everything’s accurate, and it is, though. It’s just an outlier compared to other facilities. Because of that … it’s kind of specific
to Food Manufacturing … we’ve included in the header this facility’s filter, the last
one on the right. There’s a toggle for looking at … this facility
is called Incobrasa. So if you want to look at all other facilities
besides Incobrasa, you can just select that from this filter, and it’ll automatically
look at all facilities but that one outlier. And so now you can see Illinois still reports
a lot of waste to TRI, but all the other … there’s a bit more of a reasonable distribution amongst
all the other states. Illinois’s not so far ahead of them. So I’ll keep that on for most of this. So you can see here some of the other things
we’ve broken it down by region again, looking at waste managed by subsector over time. In this case looking at the different methods
of waste managed that can be reported: releases, treatment, energy recovery and recycling. So just looking at different cuts of the data. For example, if we look at Meats, you’ll see
a lot of that is popping up as treatment, whereas for a different subsector … Dairy
I think is all … yeah, Dairy is even more treatment. So you just kind of see as you’re looking
through. Let’s maybe select ammonia and Dairy. You can kind of see how that changes since
we’ve selected Dairy. This is drilled down to the specific six-digit
NAICS code. You can see milk manufacturing, cheese manufacturing,
all those different things. So this is an example of kind of how you can
quickly drill down into some specific views of the data. And if we go to the releases tab … so all
the same information … and again, these filters are still applied. So we’re still looking at releases in this
case but still for ammonia reported by facilities in the Dairy subsector. And then you can clear those selections if
we want. And again, it’s a lot of the same information
as the waste managed tabs, just this time for releases. So, again, by location, by subsector, over
time. Now since we’re looking at releases, which
is a sort of subset of the waste managed, we’re looking at how those releases are released
into the environment, so whether it’s to air, surface water, land, or off-site disposal. You can see one interesting thing with the
Food Manufacturing subsector is even though it’s an industry subsector, there’s a lot
of variety within it. So Meats, for example, has a lot of releases
to water, whereas Grain and Oilseed Milling, for example, most of the releases are to air. So there’s a lot of variety in terms of the
subsectors and facilities that are included in Food Manufacturing as a whole. I think that was one reason, initially, why
we kind of got on this data visualization track is because there was so much nuance
and so much variety in the data that it really helped to kind of see, depending on which,
maybe, subsector, which region you’re looking at, how the different release quantities and
potential source reduction opportunities might change. The chemicals tab is the next one we have,
and that’s something we built just to kind of look at some of the top chemicals. So each of these is looking at the top five
chemicals, and then the gray box is just representing all others. You can see for waste managed and for releases,
nitrate compounds is a big one. And we’ve color coded by subsector, so for
both of these, you can see Meats is really the driver of nitrate compound reporting as
well as a little bit of Dairy and Fruit and Vegetable. So these tree maps are kind of showing it
in terms or relative proportions. We’ve also included these bar charts here
just to show the quantities. So you can see nitrate compounds is really
kind of above and beyond a lot of the other chemicals. Those are probably mostly reported by Meats
subsector facilities. It’s just kind of inherent to the wastewater
that’s produced as a result of the animal processing and the byproducts associated with
that. So if you maybe didn’t want to look at nitrate
compounds because it’s kind of above and beyond the others, you could select it. And then if you go into the black subsector
selections bar at the top, one option, if you select on, click on it, this ellipses
gives you more options, and you can select the alternative. So it’ll select everything except for nitrate
compounds. So now you can see what the top five chemicals
are without nitrate compounds just because it is kind of above and beyond a lot of the
other chemicals. So this is an example of kind of the different
features available in Qlik Sense to kind of change and customize the visualizations. So we’ll keep working through. The data summary tab … it’s a lot of the
same information we’ve already looked at, just in a tabular format, if that happens
to be something you’re interested in looking at. These measures are things we’ve already seen:
waste managed, treatment, air releases. We’ve also included greenhouse gas emissions,
which I’ll get to on the next tab. So again, this is just looking in tabular
format if you … as you select … we would have done sugar and confectionary at this
point. So now it’s showing this different six-digit
NAICS code within that. It’s just kind of an example of another way
to look at the data, if this is something you’re interested in. The greenhouse gas tab … so EPA has another
program, the Greenhouse Gas Reporting Program. So that program it’s intended to capture the
greenhouse gas emissions of the sort of the largest facilities in the country. So I believe facilities that emit more than
25,000 metric tons of CO2 equivalent are required to report their greenhouse gas emissions to
this program. I want to say … I forget the exact number
… I want to say it captures about 80% of greenhouse gas emissions in the country. So again, it’s capturing sort of the highest
echelon of facilities that have greenhouse gas emissions but capturing most of them. So what we’ve done here is combine the data
reported for 2015 to that program with the data reported to TRI in 2015. So this tab in particular only shows TRI data
for 2015, facilities in that one year, just because that was the data set we were working
with for the Greenhouse Gas Reporting Program. But this tab is just kind of taking the data
visualization beyond TRI to kind of see, if you are interested in greenhouse gas emissions,
kind of the overlap with that. So you can see for some of these subsectors,
these charts at the bottom in blue, are showing TRI air emissions just cause that’s kind of
an equivalent, I guess, to greenhouse gas emissions. And then the pink dots are showing the Greenhouse
Gas Reporting Program emissions. So you can kind of see how they compare across
subsector as well, on the right, by region. So, again, this is just kind of intended to
provide a way to look at something beyond TRI data. So if we were looking at a specific sector,
like Dairy. Well, Dairy doesn’t have a lot. Grain and Oilseed Milling has a lot. We can quickly see what Corn Milling [inaudible
00:32:57] to Soybean Processing. They’re just some of the big drivers of greenhouse
gas emissions. So just another way to kind of go beyond TRI
data and look at something relevant to the environmental impact of facilities in Food
Manufacturing. And, finally, this last tab is just a list
of facilities. So based on whatever selections you have in
this black bar at the top, all of the facilities relevant to that will show up in this tab. It just has some of a lot of the information
we’ve kind of gone over already: the TRI-fed, the facility name, the subsector … sorry,
TRI facility ID is what TRI-fed stands for … facility name, where it’s located, the
subsector, then, if it reported to the Greenhouse Gas Reporting Program, it’s demographic index
from that legend we had on the facility map page, the waste and release quantities. And then if you want to find more information
about that facility, you can just click on this P2 report link, and it’ll take you to
the Envirofacts page that has more information about that that facility. You can get to the facility profile from here
and just look at more information. So it’s just intended to kind of provide a
link between this tool and some of the other tools that EPA has available, so you can see
some of the compliance information out in just a couple of clicks away from the Qlik
Sense Dashboard. So that’s kind of a walkthrough of everything
that’s included in here. I’ll stop if anyone has questions at this
point. Feel free to ask. Otherwise, I’ll get started with the demo
of kind of specific drilling down into some pollution prevention information. Okay, well, in that case … feel free to
interrupt with questions at any point … but in that case, I’ll get started with sort of
a demo of kind of begin working through everything we’ve already gone through but just with a
specific question in mind. So, let’s see now. So if I’m interested in finding some kind
of potential source reduction activity, I might want to look into for my facility. One of the nice things with this tool is it
can help you kind of narrow your focus and to see the facilities that might be most relevant
to what you’re interested in and kind of provide you with some sort of starting points for
maybe potential source reduction activities and other pollution prevention opportunities
that could be relevant to your facility. Again, this data is only including those that
report to TRI. So you might be from a small facility that
doesn’t have to report to TRI, but you might still be interested in reducing some of the
toxic chemicals that you manufacture or process or otherwise use. And looking at the facilities in this profile
might just give you some ideas, kind of provide a starting point for understanding what types
of opportunities are out there. So we’ll start. If I’m a facility in Region 3, for example,
we can select Region 3 from our selections panel. Now we can see all the different facilities
in Region 3, and at this point, if you’re following along, if you’ve only selected Region
3, that should narrow it down to 181 facilities that report about eighty million pounds of
releases. So just making sure if you’re following along
on your own that you’re at the same point that we are. Again, the only selection so far is Region
3. So we have Region 3. We can kind of drill into some more specific
information. So, for example, let’s go to waste managed
tab and just kind of see what are the waste quantities reported to TRI from facilities
in Region 3 for Food Manufacturing. So you can see here Meats is the largest subsector. It’s almost 80% of the waste managed in Region
3 over the time span we’ve included. If you looked at the map, it looks like a
lot of that’s coming from Virginia or facilities in Virginia. If we drill down into the meat subsector. We’re going to the six-digit NAICS code view,
and you can see about three-quarters of it is Poultry Processing. So there’s a lot of chicken processing facilities
… or maybe not … chicken and other poultry processing facilities in Region 3 that are
sort of driving the releases reported to TRI from this subsector. So if we want to look at releases instead,
cause those are the things that might be more pertinent to some kind of environmental impact,
we can see that things are a little bit different, and Poultry doesn’t have as quite big of a
hold. It looks like things in Pennsylvania and Virginia
are a little more close together, and we can kind of see the trend over time. It looks like in Region 3, the releases reported
by Meats subsector have, looks like, decreased over time. As I mentioned before for Meats, a lot of
that is because of the wastewater releases. So you can see service water discharges in
each year are pretty much the main source of TRI releases that are reported. If we want to look at the different chemicals
that might be pertinent to these facilities, we can just go to the chemicals tab. And as I mentioned before, nitrate compounds
is one of the big drivers, particularly for Meats. So you can see here nitrate compounds is by
far and away is sort of the big driver of the TRI releases. And again, it’s kind of inherent to the prophesy
that these facilities … there’s a lot of biological and organic content in the wastewater
just from the animal processing that occurs. So, as a result, a lot of nitrate compounds
are formed throughout the wastewater treatment process. So that’s kind of the reason why there’s a
lot of nitrate compounds. If your facility is interested in reducing
them, we can start to kind of look at different source reduction opportunities that might
have already been reported by other facilities that, perhaps, you can adapt at yours. So, if we select nitrate compounds, which
again you can do by clicking on it within one of the charts, you could select it by
using this filter. I guess one thing I didn’t mention is in the
top right of the black selection bar, there’s a little magnifying glass. You can always search that way. So if I type, “nitrate,” you can see it pops
up here. There’s eight different ways to get to stuff
in Qlik Sense. So plenty of ways to get there. So, at this point, if you’re following along,
we’re still in Region 3 in the Meats subsector, and we’ve selected nitrate compounds, specifically,
as the chemical. And, at this point, there are 24 facilities
within our selection that have about sixty million pounds of releases. So, at this point, if I’m interested in Meats
facilities, and I want to look at my nitrate compounds and see if there might be different
opportunities or strategies to reduce both, I can look at these facilities that have been
included in our selections and go to the source reduction activities tab. So this will show any facility that has reported
nitrate compounds, any Meats facility that has reported nitrate compounds, to Region
3. This will show you the source reduction activities
reported by those facilities. You can see in the KPI, Key Performance Indicator,
at the top, even though we have 24 facilities, only 8 of them have actually reported some
kind of source reduction activity. So even for the facilities included in the
TRI data, there’s still plenty that haven’t reported some kind of activity targeting source
reduction of nitrate compounds. And for facilities that are exempted from
TRI reporting, they may not have even thought to start addressing nitrate compounds. Even though we’re only looking at a small
subset of facilities, the activities reported by these facilities could apply to a much
larger universe of, in this case, meat processors, in this case in Region 3. But a meat processor in Region 3 might still
have a lot of the same environmental impact and processes as a facility in a different
region. So just something to keep in mind that even
though we’ve kind of narrowed in our focus here. The applicability of the different pollution
prevention opportunities … it still has a wide-range impact in terms of potential
adoption elsewhere. So we can see here, for nitrate compounds
reported by these meat facilities in Region 3, it looks like good operating practices
and process modifications are kind of the two main categories of source reduction activities
that have been reported to TRI. If we’re interested in one in particular,
let’s say, in this case, process modifications, we can use these radio buttons on the left
to select one. And so now we’ll look at only those facilities
that have reported process modifications. As I mentioned before, facilities can report
multiple activities. So, in this case, it looks like a few of these
facilities have also reported spill and leak prevention and good operating practices. So we can see here by the NAICS code, it looks
like a lot are from poultry processing, some from a few of these other subsectors with
very pleasant names. And, again, looking down here, we have kind
of a breakdown over time. You can see process modifications throughout
2005, 2015. There’s at least a couple reported each year. And this facility list on the right is showing
you all the facilities, the year they reported source reduction activity, what type it is. Again, we selected process modifications,
but there were a few other ones because of the multiple reporting options. And then there’s a link to the P2 report where
we could get more information. So how the TRI information is organized, if
you’re not familiar, is facilities can report which source reduction activities that they’ve
implemented based on these categories. And in some cases, they provide optional information
about additional detail associated with those. So a facility might report process modifications,
and there’s really not much more to it than that. In other cases, facilities might report additional
information kind of explaining more detail about what they’ve actually done. So we can select from some of these facilities
that have reported source reduction activities and see if we can find more information. I’ll select … it looks like this one here
has a lot of different reports, so that might be a good one to look at. So I’ll just go ahead and click on the P2
report link. So this is facility says it’s [00:44:32] 17557VCTRF. So it looks like it’s a Tyson poultry facility
in New Holland, Pennsylvania. Again, maybe we’re interested in nitrate compounds,
specifically. We can see what their source reduction, their
pollution prevention activities reported are for that chemical. And it looks like there’s some good examples
here. Facility had some kind of wastewater treatment
upgrade to improve removal of nitrate compounds. The piping and equipment in the process wastewater
treatment system were modified to optimize treatment of nitrate compounds. They’re recycling water to increase the nitrogen
removal efficiency. They’ve included a biological nutrient reduction
upgrade. So a lot of information here that … if your
facility is interested in reducing nitrate compounds, this is a way you could use this
tool to quickly drill in and find some examples from other facilities that might be similar
to yours and get some ideas for potential activities you could look into implementing
at your facility. So this is an example of how you can kind
of work through that. If you’re interested in quickly changing,
let’s say from Region 3 to Region 4, you can easily do that with the filters here.>>Lissa McCracken: TJ? This is Lissa. It’s about 2:50. I was thinking maybe at this point, and as
you were going on to Region 4, maybe we ask Vaughn to share a little bit about what they’re
doing in Tennessee. And then maybe, as you do some searching,
we can try to make the connection there or something.>>TJ Pepping: Yeah, that would be great.>>Lissa McCracken: Vaughn, you want to go
ahead and just talk a little bit about what you’re doing, and then we’ll see how TJ might
be able drill down, find some info. Vaughn, are you still with us? I know he was on. Okay, well, I guess, TJ, just go ahead…>>Vaughn Cassidy: Am I there? Am I there?>>TJ Pepping: We can hear you now.>>Lissa McCracken: Yeah, Vaughn. Okay, we can hear you now.>>Vaughn Cassidy: You have to unmute your
mic. I just figured that out. Okay. So, hi, I’m Vaughn Cassidy. I’m with the Tennessee Department of Environment
and Conservation with the Office of Sustainable Practices, and for the last two years, we’ve
been doing a P2 survey of, primarily, the Food Manufacturing sector in Tennessee, which
is about between 11 and 15% of our overall economy. We have some pretty big manufacturing operations,
like Unilever. If you eat a Klondike Bar in the US, it was
probably made in Covington, TN, more than likely. There’s a million of those bars made every
day at that facility. We also have some pretty small ones that handle
tea and coffee, like Reilly Foods, that are relatively small. They have five manufacturing products under
one roof. A lot of folks go to work there and don’t
have a clue what the guy next to him is doing. Anyway, we have those various sizes. What we found out was a lot of these facilities
… they’re not even pursuing ISO 14001 Certification, although they do have a good under roof ISO
14001 comparable EMS system. And sometimes the EMS system is just the person
you’re talking to. It really just kind of varies quite a bit. You guys still hear me?>>TJ Pepping: Mmm-hmm.>>Vaughn Cassidy: Okay, good. All right, great.>>Lissa McCracken: Yes.>>Vaughn Cassidy: So, I didn’t really know
… what do you all like for me to share with you me in relation to our database share that
we were looking at.>>Lissa McCracken: Well, I think, Vaughn,
one of the things is your all’s approach is you’re currently having some series of roundtables
or workshops.>>Vaughn Cassidy: Correct.>>Lissa McCracken: And you bring up different
topics there, and you’re having a lot of peer-to-peer exchange. But, I guess, one of the things is would there
be information in the database as far as topics, maybe, to bring … like you could find out
what some of these people are doing, and you all can, maybe, use topics for discussion
to drive a little bit of those roundtables.>>Vaughn Cassidy: Okay, well, one of the
things we’ve been doing … and I don’t think it would really relate to this exactly, but
I do have something else. But we’re doing a lot of energy assessments
through the Department of Energy, which is manned through Rutgers University, and our
local affiliates here are the Tennessee Tech University and the University of Memphis. And we also have quite a bit of chemicals
and other products that don’t have a readily available beneficial end use. We have a lot of land application, which is
sort of going away because the [inaudible 00:50:00] for that [inaudible 00:50:05] are
getting more and more difficult. We have a lot of food, animal feed incorporation
going. And we have a lot of folks who just don’t
know what to do with their material. So one of the things that would be interesting
is … let’s just take a for instance. There is a facility called Lucite International
that has a lot of acid. They have a tech grade 98% sulfuric acid that
I thought could be useful in some food facility and just wanted to look up if you could do
that. Cause you look up a certain type of chemical
that is being utilized in the process of a certain food manufacturer in your area, and
then you might be able to match up different waste materials. Does that make sense?>>TJ Pepping: Yeah. Do you have a chemical in mind?>>Vaughn Cassidy: How about … well, I’ve
got … well, tell you what, sulfuric acid.>>TJ Pepping: Okay. Yeah. So we can select sulfuric acid. So right now I’ve selected Tennessee and sulfuric
acid.>>Vaughn Cassidy: Okay.>>TJ Pepping: Looks like there’s just two
facilities that have reported to TRI for sulfuric acid.>>Vaughn Cassidy: All right.>>TJ Pepping: That doesn’t mean there aren’t
other Food Manufacturing facilities, but these are just the ones that happen to report to
TRI. It looks like there’s a tiny one over here. It’s Tate & Lyle facility.>>Vaughn Cassidy: Tate & Lyle.>>TJ Pepping: In Loudon. And then a bigger one here … at least in
terms of releases … a bigger one here near Memphis.>>Vaughn Cassidy: Okay, okay. Yeah.>>TJ Pepping: so those are two. If you have someone with some kind of sulfuric
acid byproducts that are interested in finding a downstream user for, these are two facilities
that might be worth looking into.>>Vaughn Cassidy: And as far as the TRI reporting,
there’s a couple of facilities that we work with that may not have .. they may not come
up to the threshold for TRI reporting. The one I mentioned was Reilly Foods. Can we see if Reilly Foods is available is
in the database?>>TJ Pepping: Yeah. So I’ll just go to the list of facilities
tab, Under the facility name, I can just click the magnifying glass to search.>>Vaughn Cassidy: R-E-I-L-L …>>TJ Pepping: R-E-I>>Vaughn Cassidy: Yeah, not Raleigh but Reilly
is an Irishman’s last name.>>TJ Pepping: Yeah, it doesn’t look like
it’s in there.>>Vaughn Cassidy: Okay.>>TJ Pepping: It just means that for whatever
reason not report to TRI>>Vaughn Cassidy: Okay. Let’s try … here’s a big one … McKee Foods,
another Irish name.>>TJ Pepping: Is it M-C?>>Vaughn Cassidy: M-C-K-E-E.>>TJ Pepping: Okay. Yeah, it doesn’t look like it’s in here, either.>>Vaughn Cassidy: Wow. I’m surprised.>>TJ Pepping: Yeah, it may be, if it’s a
large facility, then it just be because of the specific chemical threshold. There’s lots of nuances to the TRI data. There may be some kind of exemption that they’ve
met, so …>>Vaughn Cassidy: Okay.>>TJ Pepping: Again, just because it’s not
in here doesn’t mean that there’s not pollution prevention opportunities.>>Vaughn Cassidy: Okay.>>TJ Pepping: This is from the lens of TRI
data.>>Vaughn Cassidy: Okay. As far as animal waste goes, are you familiar
with the term offal? O-F-F-A-L?>>TJ Pepping: Yes, I’ve heard it before,
but …>>Vaughn Cassidy: I wonder if that’s listed?>>TJ Pepping: In the reporting?>>Vaughn Cassidy: Yes.>>TJ Pepping: I don’t think it would be.>>Vaughn Cassidy: Okay. It wouldn’t be a chemical release?>>TJ Pepping: Yeah.>>Vaughn Cassidy: It would be just a waste
product? It’s actually the nervous and connective tissue
of animals. I didn’t want to get too graphic, but that’s
what that term means.>>TJ Pepping: Yeah, so that specifically
wouldn’t be reported to TRI.>>Vaughn Cassidy: Okay.>>TJ Pepping: But that might be associated
with the nitrate compounds that are formed in the wastewater as a result of the biological
degradation of a lot of those different byproducts. So that might be something. Even though you couldn’t specifically target
that aspect of the waste from these meat processing facilities, the downstream impact, the nitrate
compounds that are formed, that’s one of the chemicals included in TRI reporting. So that’s sort of a proxy you could do for
that. Again, for meat facilities, nitrate compounds
is really the big driver of releases just because there’s so much biological content.>>Vaughn Cassidy: Okay. Would there happen to be a way … and I’m
not picking at you. I’m just thinking of things that I’ve found
useful recently. Would there be a way to find out who had their
own wastewater treatment facility there on site that would associated with their manufacturing
operation? Is there a way to incur that from this data,
I wonder?>>TJ Pepping: The data that we’ve included
in this tool, no, but there is information included in TRI reporting about transfers
to POTWs.>>Vaughn Cassidy: Okay.>>TJ Pepping: There’s no categories in terms
of whether the waste managed … one of the categories for waste managed is treatment,
this yellow here.>>Vaughn Cassidy: Okay.>>TJ Pepping: So some of the way that’s broken
up … they’re different … so this is looking at more of a high-level context for the data,
but some of the detailed data not included in this profile looks at things like transfers
to POTWs or whether it’s onsite treatment. So that’s one way. In the next iteration of this tool, perhaps
we can incorporate some more of that more detailed report information. In this case, it’s just showing treatment
as a whole, this yellow, but there is both an onsite and an offsite component to that
in terms of the reporting. And that’s one thing … if you go to the
facility tab, sorry, the P2 Reports. If you look at their submissions here, this
gives you the … in this case this facility just reported ammonia … you can see here
some of the detailed reporting information. For treatment, we’re only showing treatment
overall, but this is looking at the quantity offsite and onsite. In this case, they didn’t report any, but
this is an example of the information actually reported to TRI is much more detailed than
what we currently have in the application. It’s certainly possible in future iterations. If that’s of interest to folks, we could look
into different ways to incorporate some of that more detailed and nuanced information.>>Vaughn Cassidy: Well, one more drill down,
TJ, that we might be able to get at. I was going to ask about a few things there. General Mills in Murfreesboro, TN, they actually
have an anaerobic digester onsite, and I know I saw energy recovery. I was wondering if there’s a way to get at
who else may have an anaerobic digester. Probably wouldn’t be able to get that specific,
but you would …>>TJ Pepping: This dairy facility?>>Vaughn Cassidy: No, it would be the Pillsbury
operation there. Let’s see.>>TJ Pepping: Oh, okay.>>Vaughn Cassidy: Yeah.>>TJ Pepping: Yeah, so if we select that
facility, we can look and see what … it looks like they’re mostly reporting as treatment.>>Vaughn Cassidy: Yeah, I don’t see energy
recovery there. Interesting.>>TJ Pepping: Yeah. They’ve mostly reported as treatment over
the years. It looks like they last reported to TRI in
2012.>>Vaughn Cassidy: Okay.>>TJ Pepping: So, for whatever reason …>>Vaughn Cassidy: They put that in in 2014,
so that would explain that.>>TJ Pepping: Okay. So, maybe with different processes they’ve
put in over the years, perhaps they no longer meet the threshold for reporting to TRI, which
is … one of the nuances of TRI reporting is as facilities decrease their waste managed
and release quantities, they might fall out of TRI reporting because they no longer manage
or release enough. They’re no longer captured in the reporting,
but from one perspective, it’s a good cause it means they’re not … they might have switched
to an alternative chemical that is considered to be a safer alternative and isn’t included
in TRI reporting,. They may have just been using the same chemicals
but now are using smaller quantities so no longer meet the threshold. So plenty of reasons why a facility might
fall out of reporting. In some cases, it discloses that. In others, they’ve done something to kind
of get out of the universe of reporting.>>Vaughn Cassidy: Okay, if you don’t mind,
could I …>>Jeff Kohn: This is Jeff. Can I just back up a little bit here? There was one line of inquiry that I think
is really important here, which is you’re really curious about what one facility has
reported or what one facility has said to EPA in the past. And I think that’s a really important concept
that needs to be captured every time we’re looking at a facility. So, TJ, I was wondering if maybe you could
go over to Envirofacts, which is where the P2 tool is embedded, and do a multisystem
search for McKee’s in Tennessee, and try it again because that would include all of the
EPA systems. Are you going to do the Pillsbury one?>>TJ Pepping: Yeah.>>Jeff Kohn: Okay.>>Vaughn Cassidy: McKee Foods is a good one
because they’ve been there forever. General Mills has changed out the other operation,
and Unilever has only been in Covington for just a couple of years, so you may get a hit
here with General Mills. And we may not get much. I don’t know.>>TJ Pepping: Yeah, Murfreesboro, TN?>>Vaughn Cassidy: Yeah.>>TJ Pepping: Yes. You can go to … and, again, this Envirofacts
tool is linked, too, from this dashboard, so you can, through this P2 report link, you
can kind of work your way here. Mainly, it just has a lot more information
in terms of compliance status, data programs, a lot more than the TRI data included in the
tool we’ve developed.>>Jeff Kohn: This is a really important search
because this is what EPA perceives of this facility. And it’s potentially a P2 selling point to
say, “Okay, this is the broad picture of every system, public system,” I should say. There’s some internal systems. But every public system in EPA … this is
what EPA thinks of you, essentially, and the states, too. There’s usually some extra state information. Let us take a look at this and see how ways
we can deregulate you by using different chemicals, etc., etc. TJ, would you mind taking a look at the McKee’s? Just take a look and see what’s said for McKee’s
in Tennessee.>>TJ Pepping: Yeah. M-C-K …>>Vaughn Cassidy: And McKee would be oldest. They had the most time, but now they didn’t
report anything for TRI did they?>>Jeff Kohn: The thing about facility name
is that sometimes it’s reported by parent company. It’s not necessarily obvious, and so a lot
of times when I’m talking to people about a specific facility, we just use the map tool
in Qlik Sense to kind of narrow down, geographically, where it is.>>Vaughn Cassidy: Okay. McKee Foods is a … if anyone’s ever had
a Little Debbie product, they’re the ones that make that. That is definitely their name, McKee Foods,
McKee’s Baking Company. They have several different iterations, but
they’re a colossal facility. I think they employee about five thousand
people.>>Jeff Kohn: Wow. Sounds interesting. So there’s one in Arkansas. Is that the one you’re thinking about, or
is it Tennessee?>>Vaughn Cassidy: It is in Tennessee. It is in sort of the middle of East Tennessee. And they’re a monster, but it doesn’t look
as if they come up to the TRI threshold, which is really interesting.>>Jeff Kohn: Well, the bakeries … we haven’t
seen high percentages of bakeries reporting. They just don’t handle a ton of chemicals,
at least toxic chemicals as defined by TRI.>>Vaughn Cassidy: Well, I wonder if someone
like Unilever … they haven’t been around that long, but I wonder if Unilever … they
have a lot of refrigeration. They make a lot of ice cream. I would think they might be in there.>>TJ Pepping: Ice cream would be in Sugar
and Confectionary.>>Vaughn Cassidy: Right. I’m sorry I’ve been picking bad examples,
guys. I’m not trying to make you look bad.>>Jeff Kohn: No, not at all …>>TJ Pepping: Data visualization is … whatever
the data is, that’s what you have, and this is intended to be sort of a starting point
for a lot of these conversations. As we’ve gone through some of your questions
here, it just kind of indicates that there might be other tools at EPA that have the
type of information that would be more pertinent to those facilities, whereas, in other cases,
there might be facilities where the information in this tool has a lot of opportunities, a
lot of potential starting points for engaging in some kind of dialogue about what types
of processes, what types of pollution prevention practices might be relevant. Sometimes it’s also good to see what is not
available from a tool that kind of gives you a sense of the scope of the universe of what’s
included and the limitations, both the limitations and the capabilities of it.>>Vaughn Cassidy: Well, Sugars and Confectionery
… I guarantee you Mars chocolate, which I just saw give just a little flicker on the
map there for a second, they should have quite a bit in there. They are in Middle Tennessee, near Chattanooga.>>TJ Pepping: It looks like they do a lot
or they do all offsite disposal, nitrate compounds. It looks like just … yeah, so it looks they
… I would guess … though I would have to delve into the TRI data on Envirofacts
… but I would guess a lot of this is probably offsite, maybe POTW transfers of nitrate compounds.>>Vaughn Cassidy: That is correct. That is correct.>>Jeff Kohn: I don’t know if you know how
they use nitrate compounds. Is it the nitric acid cleaning of the equipment,
or is it for baking … ?>>Vaughn Cassidy: I think it’s an off product
of one of one of their treatment processes, I think.>>Jeff Kohn: Okay.>>TJ Pepping: Yeah, so we can see here … yeah,
so it’s produced as a byproduct. I think you’re probably right, Jeff. It’s probably they’re using nitric acid for
some kind of disinfection, and nitrate compounds are produced as a byproduct. That would be my guess. Again, what’s reported to TRI is kind of sometimes
limited in scope, especially in terms of how they actually use chemicals. You can get some kind of general sense. Here, what’s reported to TRI, is that it’s
produced as a byproduct, so … information.>>Lissa McCracken: It’s 3:10, so I just wanted
to see … and thank you, Vaughn. I really appreciate you. Maybe there wasn’t an answer to everything,
but I think the approach is what’s good and to find out what isn’t there and where to
find and try to go a different approach, so all that was very helpful. I really appreciate you stepping up and kind
of throwing Tennessee out there. Maybe you’ll feel a little more comfortable
going in and poking around in there, too.>>Vaughn Cassidy: Yeah, I’m definitely going
to now since I picked such bad examples for you. I apologize.>>Lissa McCracken: And if nothing, that was
very helpful to see where to go to if you’re not finding anything, as it’s making me think
Envirofacts would be a really good thing for us to think about as well because that seems
like more of a capture, too, to be looking at. Let’s just backup to general questions before
we do the final wrap up. Any questions for TJ or Jeff or?>>Chris Messemore: This is Chris Messemore
from Mississippi. I have a question that’s not really related
to anything that was presented today. We’re playing around with it on our end, and
we’re really enjoying it. Is there any way that we can open it up to
NAICS and SIC codes that aren’t in Food Manufacturing but just could be TRI related in our state?>>Jeff Kohn: Absolutely. So that’s sort of the next step. This was our experiment to try this one industry. I don’t think it’ll work to do every industry
in TRI cause then it would just be a big dotty mess. We’re trying to maybe develop a tool, sector
by sector, and I think the next sector we were thinking about working on was the Auto
sector and trying to map that out and see what it looks like. I don’t think it’ll be that hard, to be honest. We’ll probably use a lot of the same screens. We’ll just substitute the Food Manufacturing
with the Auto sector ones. But if there is a particular sector that you
want us to look at, we would be interested in hearing from you. Chris Messemore: In our state, we probably
aren’t going to have a tremendous amount of automotive manufacturers. We might have a bunch of different ones. Is there any way that we can just get all
the TRI filers on it?>>Jeff Kohn: Yeah, TJ is going to the TRI
National Analysis. That might be the better way of doing it. They’ve got a really nice-looking tool now. It’s not supercool Qlik Sense, but it’s still
got a lot. It’s still quite dynamic.>>TJ Pepping: Yeah, so kind of to build off
that for this year’s TRI National Analysis, which is put out every year by the TRI Program,
since Qlik Sense is new to EPA, we developed sort of a high level dashboard to just look
at some of the release information. So this doesn’t have a lot of the same detail
as in the profile we built for Food Manufacturing, but it does have all of the industries that
reported to TRI last year. And you can kind of see the top chemicals. So if you are interested in … you said Mississippi?>>Chris Messemore: Yeah.>>TJ Pepping: Yeah, so you can filter it
for Mississippi, and this first tab for chemicals gives you a sense of the top chemicals: manganese,
chromium. It’ll show you by air, water, land, and offsite,
kind of the different distributions. So, again, for water, for example, you can
see nitrate compounds is the big one here. If you wanted to look at specific industries,
here it looks like Chemicals is one of the big ones followed by Paper and Food. So this is fairly … I don’t want to say
basic application, but this is intended to be kind of just a high level summary because
the National Analysis is, again, intended to sort of a national report. Certainly in the future, if there’s a lot
of interest, as Jeff mentioned, either building additional tools like the Food Manufacturing
but specific to other subsectors, or just leveraging a lot of the data that EPA has
available in terms of other Clix applications, that’s something, I think, a lot of people
at EPA are talking about exploring. What are the different capabilities for these
Qlik Sense applications? Can you really provide a lot of this detailed
industry or facility specific information, whether it’s TRI releases or some of the other
programs at EPA? This is just an example of another Qlik Sense
application that’s out that can maybe give you a high level sense of, I guess, chemicals. It’ll drill down into the six-digit NAICS
codes. You can see it’s a lot of synthetic dye in
Pigment Manufacturing, and it’ll show you some of the top facilities with those releases. It has the same kind of facilities tab here. This Chemours Plant looks like it’s kind of
the big player, just an example.>>Chris Messemore: Would mind sending an
example to us?>>TJ Pepping: Yeah, I’ll include it in the
chat. Again, this is linked in this year’s TRI National
Analysis that you can get to from the TRI homepage on EPA. For this year, it’s just targeted at releases. Again, this is kind of a first iteration of
that, but as Qlik Sense has become … as EPA has started to use it more, we’ve just
kind of explored all the different capabilities and limitations and options and possibilities
with it. So this is just one example of tools that’ll
take you take you to that state facts sheet for Mississippi, in this case, so you can
see a … well, once it once. It’ll show you a facts sheet in terms of TRI
releases for Mississippi last year. Just another example of kind of the power
of all the different data analysis tools that EPA has available. Again, these are just in the context of TRI. There’s plenty of other similar programs at
EPA that might have other tools available, and especially as Qlik Sense starts to become
more integrated with all of EPA’s data visualizations, I think you’ll more of these tools across
other programs as well.>>Lissa McCracken: Okay, thanks, Chris. Any other questions for TJ before we close
this out?>>Jeff Kohn: I wanted to mention that I was
planning on doing a presentation on Envirofacts for the Triple Regional Roundtable up in Minneapolis,
but that’s another way of looking at all the facilities. It gets, actually, a little crazy. If you looked up a multisystem search in Envirofacts
for everything in Mississippi, it returns thousands and thousands of things. You have to be a little bit more directed
and say you’re looking at a particular industry. You’re looking in a particular … there’s
a series of factors that might reduce it down because … or say you’re just looking in
TRI. That’s an option, too, and maybe in the future
we could do a separate Envirofacts training. It’s just a much clunkier tool than Qlik Sense. This is much cleaner if you want to work with
Food Manufacturing.>>Lissa McCracken: Okay, so, I guess we’ll
work towards wrapping it up now. I do appreciate, TJ, you hosting the WebEx
session of this and walking through it with us, and Jeff for all your work in helping
to make this happen. I think it’s a tool that we just have to use
more and more to become more familiar. There’s a lot of good information there. I do want to remind people that we are going
to have this posted on the ESRC website. We’ll send out an email when it’s going to
be available. TJ mentioned there’s also a demo up on their
site, and we’ll include some resources. That’s a link we’ll make sure we get you quick
access to be able to get to that demo. The other thing is Region 3 has been working
on some P2 related resource links for Food Manufacturing, and we’re going to provide
some of those resources that they’ve pulled together on the page, along with this session
as well. So, hopefully, that’ll become a little bit
of a one-stop shop for everyone, and, as I said, we’ll send you an email when those are
posted. So just to kind of closing thoughts, Jeff,
let me throw it to you for any closing thoughts on this.>>Jeff Kohn: I don’t have a lot more to say. I think it went really well. My name and telephone number and email address
and TJ’s name and telephone number and email address are here, and I want to encourage
you to contact either of us. TJ was the developer. He knows the things backwards and forwards,
and he can answer all sorts of questions about Qlik Sense and things like that. I would consider myself more of a power user. I know how to use this tool pretty well. But I have taken a developer class, and I’ve
decided that this is not my future. So I will use the tool, and I will enjoy it,
but I’ll leave TJ to the development. So you can call and ask us, either of us,
questions, and I have TJ, actually, until April 10th, when the contract ends. But anytime in the next couple of weeks, feel
free to call him.>>Lissa McCracken: Okay, yes, that’s a good
point. The contract ends April 10th, so that will
be … if you have some questions, go ahead and try to get ahold of TJ and work through
that. But following that, Jeff will be a point of
contact, and you can certainly call us here at the ESRC. We’re not experts, either. We’re in the learning section, but we can
try to work through it together. Let me now … Pam with Region 4, any last
thoughts you want to share on the tool?>>Pam Swingle: No. No. Thanks so much, you guys, for doing this because
I think it was good. I hope folks got some good out of it because
I think it’s a very useful tool for us to look at in Region 4 for sure, and I’ll be
interested in seeing if Vaughn’s going to poke around in there and see what he gets
out of there with industries he’s been working with. So thank you.>>Vaughn Cassidy: Yes, Pam, I promise. I will.>>Lissa McCracken: Okay, and Mindy, Region
3?>>Mindy Osno: Yeah, hi, I just want to echo
what’s already been said that I just really appreciate that you have been providing this
to all of these people that really could use it, and I think it’s great to have an extra
tool in your toolbox. So I want to thank you again for this webinar. I thought it was great, and for also to have
it on your website and using it as a resource. So thanks again, everybody.>>Lissa McCracken: All right. Thank you very much. We’re happy to do it, and please let us know
if there’s other continuing types of webinar sessions, tool sessions, anything that you
come across and you think would be good for us to kind of bring up to share with everybody
and do some demos, we’re happy to help facilitate that. So that’s all for us and hope everyone has
a good afternoon. Bye-bye.

Tagged : # # # # # # #

Leave a Reply

Your email address will not be published. Required fields are marked *