I think we’re going to go ahead and get started today. First welcome and thank you everyone for joining our webinar workshop today, from the National Pesticide Information Center. I’m Amy Hallman, I’m a pesticide specialists with NPIC and I’m here with Sean Ross the developer of the NPRO search tool. So before we get started I just need to cover a couple of logistics. If you’re calling in on the toll free number, please mute your line by hitting *6. If you’re listening today over your computer speakers, please know that we’ve placed mute on the computer microphones. We expect a lot of questions today, so when you have questions, type them into the chat box on your screen. And after a brief introductions and a couple of quick demonstrations, we’ll actually begin answering some of those questions. Today’s webinar will be recorded and posted on our website shortly. So if you have colleagues that want to view the demonstrations in the future, they’ll be able to do so so Today’s title is: NPRO: Search for registered pesticides like a PRO. I’d like to go a little bit over what is NPIC’s mission, what is NPRO and who is it for? Also where does the product data come from is important. Understanding where the data comes from will help us understand the limitation on some of the NPRO results. We’ll go over a couple examples of uses for NPRO. Then we’ll also go through actual demonstrations with the NPRO tool. So the National Pesticide Information Center, we are an objective information service, for pesticide questions and pesticide product questions. We run a toll-free phone service from 8 to Noon Pacific Time or 11 to 3 Eastern. We are funded through a cooperative agreement between the US EPA and Oregon State University. We answer about 11,000 to 12,000 injuries per year from diverse audiences, some professionals but mostly from the public. About ninety percent of our inquiries are from the public. Our specialists provide science-based information and they’re able to translate technical information, and in some cases literally translate bilingual information. We also are able to connect people with local resources if that’s necessary. Our website has over 700 pages in English and Spanish and it’s a pretty popular website. We get more than five million page views annually. We know that these are actual page views, as opposed to automated computer hits or robot hits. Our publications, also we try to use popular topics from our audience. So if there’s a new hot topic or a bunch of questions coming in that are similar, we might try to make podcasts or video, some kind of publication that reflect those questions from our callers. NPRO is NPICs New Product Research Online tool you can use NPRO to search for pesticide products, by using up to nine search fields at one time. You can also use NPRO when you have a product selected, to link directly to EPA’s Pesticide Chemical Search. This is really handy if you’re looking for active ingredient specific information, like science reviews or regulation information. Also you can use NPRO to look at federal label PDFs, and I do stress federal labels as opposed to state labels because we’re using EPA data, so they are federal. NPRO was designed for professionals and that’s partially because it does require some knowledge of EPA’s pesticide terminology. So sometimes the pest names or use sites may be something the general public isn’t very familiar with. If a professional is working with pesticides on a regular basis then it’s going to be a lot easier for them to use this tool. NPRO’s data comes from two main tools or databases, both from the EPA’s Office of Pesticide Programs. The Pesticide Product Information System is where the raw data comes from. This is the actual active ingredient or registration number. Then the label PDFs come from Pesticide Product Label System or PPLS. So because the data comes directly from these EPA datasets, there are a couple of limitations. NPRO isn’t actually going to verify any of that label information and we’re not going to edit any of the product data, it’s directly being recalled from those two tools. Also it’s only going to include federally registered pesticide products. So any of those PDFs are going to be federal products. If you’re using NPRO, there are many ways to search for products. Some of the simpler ways to search, an example might be, when you already have an EPA registration number chosen and you’d like more product information, you’d like to look at the label PDF maybe. Another example, if you have one or multiple active ingredients and you only want to research those products that have those active ingredients, you can search by that. You can get more complicated examples, maybe you’d like to research products that control a specific pest, but you’d also like them to be low in toxicity or have the signal word caution. You can search by those 2 terms and then if you’d like to further reduce the list of products that you’re looking at, you can refine your list by adding additional search criteria. So next I’m going to let Sean talk a little bit about some of the recent changes to NPRO. Hi folks, thanks for coming. As Amy mentioned, I am the developer behind this software. If you were here for the launch demo webinar of our previous version, then these are the things that have changed since then, I’ve added a few features to the system. It used to be that when you did a search, it searched through whatever was in all of the three tabs. Now that’s optional, there’s a button that lets your search only the open current tab. People were having problems where they’d leave information on another tab and forget that was there, and then wonder why they weren’t getting search results. You can now search for combinations of ingredients, requiring any ingredients or all ingredients. It used to be, for example, ingredients, use sites and pests use to be that it was always any of them. We added a “Clear Results” button, people were looking for that and then we added some lists of use site available. A few other things, some minor items there. Bug fixes mostly, little ones and a disclaimer. So I think with that Amy is going to get started showing you what’s going on. Okay, so NPRO is available, we have a fully functional version online. So if you’d like to use this URL to follow along, play around with is during the workshop today, you’re more than welcome to do that. If you have questions in the future you can contact our 800 number or emails us, and the specialist here at NPIC would be more than happy to walk you through using the NPRO tool. So here we have the homepage for the NPRO tool and across the top you can see that there are 3 tabs, for entering search criteria and then there’s an about NPRO tab. So that’s where the disclaimer and some of the other updated information is. Looking at the first tab, you can enter registration number, you can enter product name or registrant name. You can also select the second tab for active ingredients, pests or use sites. And the third tab we can look at product types, formulation, and signal word. For the first example, this is a very simple one, I have a product for which I already know the EPA registration number. So I’m going to enter the EPA registration number and then at the bottom I have two choices, I can either search this tab or search all tabs. Now for this example, because I haven’t entered anything else in the other tabs, they work the same. But I like to get into the habit of using “search all tabs”, some of you may prefer to use “search this tab”. So what we see is a list of total product with that federal EPA registration number. I’d only like to look at active products, so I can use the product legend filter, for active, cancelled, transferred, or restricted use products. By clicking on active, I see there are only 27 active products with that number. So again this is a very simple example, but I’d like to go into a little bit more detail to show you what you see for each product. So I’m going to click on that top product, 4-122, and we have a new tab open up in our web browser. This is great because you can use this URL at the top if you’d like to book mark it, save it for later, compared it to other products that you can bookmark, or if you want to copy/paste it into an email to send to someone. This is very helpful. Looking at this product page we see that the status for this product is active and the date it was active. Also who the registrant is, the signal word and formulation. Then also the ingredients field here, I love this field because it’s not just what the ingredients are, also it has a hover feature. So for example if I didn’t know what the active ingredient was, it was maybe a more chemical name. I might hover over that ingredient and I see a list of synonyms. So this hover feature allows me to look for more easily recognizable active ingredients and I can do that for each of these. Also if I wanted to select, actually click on one of these active ingredients, like carbaryl. What that would do is that’s how it takes me directly to EPA’s Pesticide Chemical Search. That’s where I can find active ingredient specific information, science reviews, or regulations. Also you can see there’s a pest field listed alphabetically here, a use sites field, and at the very bottom what type of pesticide is it. So not to forget, the label PDF button at the very top, when I select this button it also takes me to a new tab. This is linking directly to EPA’s website, you can see that in the URL. But it can be bookmarked, emailed and shared. What’s nice about this is that the other tab, the product tab and the NPRO search tab, they’re all still open so I can go back. And I can open multiple products to do a comparison at once, if I want to. Okay, now that this example is over I’m going to go ahead and clear all tabs on the right-hand side. That will make sure that incase I had something entered in another tab it’s now gone. What you see it that the results are still present at the bottom. Although it should not affect future searches, if you’d like you can also do “clear all results” button on the right-hand side. And then you are left with a blank slate. For our second example I’m going to research products that have a specific active ingredient. So I got to the active ingredient tab and I’m going to start typing in the work permethrin. You can see that as I start typing a list of possible matches pop up and this is a scroll bar option here. So there are many possible options to begin with, with the letters I’ve typed in. If you’d like to see this list in a format that is a little bit easier to view, instead of using the scroll bar, on the right hand-side you can click “see all ingredients”. So this is opened in a new tab, but our original search is still there. Were going to start the search over by typing in permethrin again. You can see that again we have a list of all those ingredients that contain those letters. At the bottom where it says “show entries”, by changing this to a higher number you’re less likely to accidentally chop off the last choices. So I usually select a high number so that way I can make sure that I can see the entire list of active ingredients that contain the word permethrin in them. Also they have PC codes and cast numbers listed. Going back to the NPRO tab, this search box for active ingredient, I typed in the word permethrin. But you can also type in the PC code or the cast number and it will do the search just the same. So once I have the active ingredient I would like to select, I can click it. If this was the only product I was looking for or the only active ingredient I was looking for, I could go ahead and do the search. But I want to do something a little bit more complicated, I want to look for products that have permethrin and pyriproxyfen. So I start typing pyriproxyfen, I select it. Then what’s important here, is the “any” and “all” tabs on the right hand side. The “any” tab, you would select this if you didn’t care if the product had permethrin or pyriproxyfen, it can have one or the other. If you want to make sure all of the results have both active ingredients, go ahead and select “all”. That’s what I’m doing for this example. Again I’m going to go ahead and search. I can see that there are 200 matching products, by filtering by active there are 100 active products. Again I could click on any of those and they would open in a new tab and I could compare products between those tabs. So I’m going to go ahead and clear all tabs, because I have a third example today. Clear the results as well. So for the last example I’m going to go ahead and add an extra layer. I want to look for products that control bedbugs, so I’m typing that in to the pest field. I’m going to select all of the options for bedbugs. This is where the “any” and “all” buttons come into play again. Remember if I select “all” then I’m restricting those products to have list each of those list sites. So instead I’m going to select “any” and make sure that any one of those pest would return a product. But I also want to make sure these products have a signal word of caution. So I’m going to the signal word tab, the drop down list on toxicity single word, I’m going to select caution. Then what I can do is search all tabs, because this time I know I have two search fields in different tabs. So there are quite a few products almost 10,000, if we’re looking at active products there’s over 1,300. So what I’m going to do here is I’m going to further limit the results, I’m going to refine it by adding in a dust formulation. So I only want to look at those products that control bedbugs, with a low toxicity signal word, and they’re dust products. When I refine that previous search by using the refine button, there only 158 active products. So these were just a few quick examples of how you might use NPRO. At this time I’d love to welcome questions. We don’t have any questions in the chat box, other than some people were having trouble with the apps link. We have a question from Kurt Plenty, he asked can we not search for a product
with 2 A.I.s? I just need clarification. You can search for 2 A.I.s, you can search for multiple A.I.s and you can require a matching product to have both or either. That’s what the “any” and “all” radio buttons do. So Amy’s doing an example right now with permethrin and pyriproxyfen. So when I type in permethrin and pyriproxyfen and I make sure that the “all” button is selected, the products that are returned at the bottom, the 100 active products, each one of those products has permethrin and pyriproxyfen. It may additionally have some other active ingredients, but I’m just going to select the first one. And we can see here that it’s .25% permethrin and .01% pyriproxyfen. So this product has both permethrin and pyriproxyfen. I hoped that helped answer the question. So let me just check the chat box here. What I was starting to say, a few people are having trouble with the link to the app itself. The NPRO needs to be uppercase in the link. So I sent that out in the chat box. But if you didn’t happen to see it, I will fix that so that the lowercase one will also goes there. There’s no reason to do that it just wasn’t that way. Carry Brennan asks, I’m a little confused about search this tab or search all tabs. Are you referring to tabs within the browser or tabs in NPRO? It’s the three tabs of NPRO itself, so you could put a product name in the registration number field tab, and then an active ingredient in the AI tab, then that way you can find products named something with X active ingredient. So that’s what those tabs are referring to, the tabs within the app. So that’s what that’s about. Keep the questions coming, we’ve got plenty of time if you guys want. We’re sorry about the audio, there’s just enough people on that it would be awkward to have everybody’s phone going off at once. So if you can type them in the chat box to that would be ideal if you have anymore. We have on from Jerry Baron, if you do a search in use site on crop group will it’s sort out products with specific crops that are members of the group? That’s a good question. So I’m wondering if you have a specific example that you could provide? I’m going to go to see all sites, I think that’s where this tabs really shines is when you’re looking at sites. So for example, I’m assuming the group is going to be called 14A or something like that. I don’t know if you can search by group. It might have to be it specific like strawberry. I believe that’s how you’ll have to search, instead of by group by actual site name. Then the groups are further designated based on tolerances and other similar things. We are at the mercy of the data that is provided to us, so it’s just the use sites that are listed in the PPIS system. We don’t have a way of grouping those, that I know of. They’re not grouped in the data it’s just a list. I hope that answers the question, I don’t think it does exactly what you’re looking for in that case. We do have another question from Ted, is your search capability available as a web service so other applications can make use of it? I haven’t officially published an API for it, but if you want to contact me we can talk about it. There’s nothing that’s actually locked down and thus we are public service so I’m happy to help with that. I have some queries that can be pulled out from behind the scenes that are accepting parameters and publishing search results as JSON objects. In a pretty standard way, so I’d be happy to talk to you about how to access that and what those what those capabilities are. So in theory people could use the back end, I just haven’t made any official, published, documented API. But it is pretty straightforward and I can help with that. Jerry, I’ll send you a note with my email in the chat box privately. We have another message. Sorry that was Ted asking about the search capability and I’ll send you my email. Chad Shultz, says thanks so much, does this system have tolerance information? No it does not, I think Amy mentioned when you get to an individual product with the A.I.s, you can click on the A.I. name and it will take you to Chem Search and I think there’s tolerance information in Chem Search. While Amy is checking that. Amy: I am wondering about that it would depend on what was in Chem Search. That stuff is all kept separately and we don’t make it part of the system. While she’s looking at that, I have another question, how often is the information updated? We update it approximately weekly that’s when the PPIS datasets are updated. Typically Tuesday or Wednesday is when that’s updated. To answer the previous question about tolerances, I went ahead and clicked on an active ingredient and linked directly to Chem Search. Under other resources on the EPA’s website is says tolerance information. So yes, you can get to it second-handley by going through Chem Search. Right, so it’s no specifically part of our system but we make it so that you can get there to some extent. Right and I think that has to do with the fact that tolerances are not often list on the product. Because that has to do with the breakdown in the field and other things as well. That’s something that if we could combine the two that would be great. This is meant to be interactive so if you have any questions, even about you to use a field, we would be happy to show how to use NPRO. Or if you had an example that you would like us to try to find a particular product or something like that we would be happy to do that. And obviously you can also call us at our 800 number that’s on our website as well, if you have further questions about it. I would like to mention again, that this is being recorded and it will be put up on our YouTube channel, as soon as I can get the recording converted and put up there, hopefully today or tomorrow. So if you had any trouble with the audio or anything like that, you’ll be able to view it again. We have another question, can you separate restricted use products from general use for one A.I.? So for that you’re going to get a lot of product back, it might be a little slow. For the active ingredient I’m trying to think of a restricted use, we can do methyl bromide. So select methyl bromide, search, restricted use. But yeah that shows you that these pinks are all restricted use products. And if you select one, it also shows that it’s a restricted use product, I apologize I’m going to make it larger. It shows it’s a restricted use product and it shows whether or not it’s active or cancelled in the product page. So I believe the way that it’s designed is that when you’re looking on the main screen at the result products at the bottom, the restricted use will show up whether or not this is an active or cancelled product. So you have to click on it to make sure if it’s active or cancelled. For only restricted use. She was looking for bifenthrin as an example. Oh and that’s going to be huge. There are a lot of bifenthrin products, so lets see what we can do. So I’m going to go ahead and clear this tab, make sure I got everything gone. So it’s looking for bifenthrin. I’m going to go ahead and search this tab. Okay I’m going to limit by restricted use. Okay so 196 restricted use bifenthrin products, again it doesn’t tell you whether or not these 196 are active or cancelled. You’d have to look at a specific product to see that, this is an active restricted use product that I just clicked on. You can see that status at the top and whether or not it’s restricted use. So I hope that is helpful for searching for products that are restricted use. We have two more questions that have come in, ones from Chad. Does this system provide section 18s or 24C registrations? I don’t remember if those are included in PPIS or not, if it’s in PPIS then it’s part of it. I’m not sure for those ingredients or for those products. I’d have to look, I’d have to double check out that. I’m sorry I don’t have the answer to that off the top of my head. Yeah we can check back with you after the webinar. Yes, Kathy we tend to get this question when we talk about this. Could NPRO include information on whether a pesticide product is conventional, a bio-pesticide, or USDA organic? Unfortunately not, especially the organic ones, those aren’t part of the dataset from PPIS. They aren’t stored as a product attribute. So with that said, what we’re going to be continually improving this. I know that that EPI Office of Pesticide Programs is working on a new data format for some of this stuff. They may be publishing additional things I’m not sure. But if that information becomes available in a dataset we will be able to use it and take advantage of that. We will be continually keeping an eye on those things and adding anything we can as stuff moves forward. So we would love to add some of those features. We always are open to suggestions for additional features if they’re possible, that’s how most of these new buttons and features got added. Sorry but those pieces of information aren’t available yet. Lets see, Peter says, can you search for a product name with keywords? For example can I type raid spider and see what products come up with those words in the product name? You can, but there’s a problem with that and that’s a lot of products don’t actually share the same name with their federal label. This is one of the limitation from NPRO only because of how pesticide products are named. If I were to type raid spider, it would look for products that have that in the name but only in the order in which you type them. So if you are looking for a product that says raid spider and you just type those words in, there are no products that have raid and spider in that order. But you could search for raid and then refine it for spider. Right so you could search for raid, I’ll do that. Search this tab, just for raid products. Okay so we have raid products. Then you would refine it by typing spider. Then select refine previous search. Again I think that’s just a limitation of the name the product. There doesn’t appear to be any federally labeled products with raid spider in the name. So a lot of times having the EPA registration number is very important if you’re looking for an individual product. Okay that’s it for questions right now, does anybody else have anything? Another one, are those EPA numbers usually found on consumer product labels? Always. There you go. Absolutely every product unless it’s a minimum risk pesticide. So unless it is exempt from registration, disinfectants that are registered disinfectants, herbicides, insecticides, they all have an EPA registration number on the label. Most of the time you’re looking for a number that has dashes, that’s the easiest way to describe it. But it has the words or letters EPA Reg number or EPA registration number and then those numbers and dashes. Sometimes there is only two numbers separated by a single dash, if there is a third number at the end that just means that it’s distributed by a different registrant. So it’s still the same as the federal label with the first two numbers, but that extra number might look a little different in a store to a consumer. But all products have them on the label. Sometimes we talk to people who a have a booklet that maybe came with their product and they lost the booklet. Sometimes the EPA registration numbers might be on that booklet they lost. But a lot of times it’s printed right on the bottle, sometimes on the back near the bottom or near the address for the company. There’s no standard, so it changes from product to product. And they’re often very small, very small print, hard to read. Anybody else? Well if nobody else has any questions then we can end. Thanks to everybody for participating, we can hang out for a couple minutes if people do you have any more questions. But thanks for participating, again this will be recorded and posted. Feel free to talk to us, I will follow up. Trisha asked a question, does this system lead you to an EPA project manager for a product? It does not, the product information in PPIS includes a project manager, I just haven’t included it in the result set. You’re honestly the first person that has ever ask for it. That is something l could included if there’s a demand for it. But it has the name and contact information. I know the publish that information and that it’s public but it’s kind of hard to get to. I felt little weird about putting people’s names and mailing addresses and phone numbers out on this without their permission. That’s why I didn’t do it. Isn’t it indirectly linked through ChemSearch? It may be in ChemSearch as well. Yeah you may be able to find that in ChemSearch, I’m not positive about that. But there is a contact in the product information database. Okay and Trisha said she’d like to see it included. That’s something that I’ll put on my list of stuff to add. Again we do like to hear about how people are using this and what they might find useful, and if it’s something we can accommodate without too much trouble I’ll definitely try to do it. So thanks for the feedback on that. I’ll follow up with the previous person that asked the question about the API, I’ll send you my email address here in just a second. Just remember that if you have questions you can email us if we’re not open, if you’d like to call our 800 number, 1-800-858-7378. You can call us during open hours and talk to a specialists and we might be able to walk you through an example that can help with your question. So please do contact us with questions. Okay I sent Ted a message with my email address in it, feel free to contact me about the API. Yeah I think that’s it on questions. I don’t think we missed anybody, if we did I apologize, I’m trying to keep a close eye on the chat box. Yep looks like we got everything so far. Yeah, thank you again. I see there are still several people listening in, if you had questions that weren’t answered today, definitely send us those questions and we’d be happy to help. We’re going to go ahead and end the webinar now, so thanks for attending everybody. Thank you.