 So, I'm going to go ahead and slowly get started. Number one, I want to welcome everyone to this webinar. Welcome to our NHR members and the AFR colleagues. Before we begin, I would like to acknowledge that this webinar is being moderated on the traditional lands of the Mikasuki and Seminole people and their ancestors and I pay my respects to elders both past and present. I will start again by saying welcome my name is Robin Bauer Kilgo and I'm the co-chair of the NHR working group. I want to welcome both our NHR members and our AFR colleagues and today's webinar is part of a quarterly meetup that we have started scheduling with NHR members and when this topic was introduced to us. We wanted to make sure to extend the invitation over to the AFR folks as well, just because we thought it was going to be useful. So we obviously work with Elena that you can see hopefully on the screen, who is our contact up at AIC and FAIC. She's going to be running the Q&A portion at the conclusion of this webinar. And this webinar today is going to be all about Georgia's natural cultural and historical organizations disaster planning process and how a directory was created on how to reuse for people to basically contact each other when it comes to emergencies and disaster response. Our speakers today are Christine Wiseman she is head of digital services at the Atlanta University Center Robert W. Woodruff Library. She's a founding member of the Atlanta Area Heritage Emergency Response Network and a member of NHR. And Cliff Landis is the digital initiatives librarian at the Atlanta University Center Robert W. Woodruff Library. His research interests include linked open data, arrival technologies, digitization, metadata, and the co-evolution of humanity and technology. This webinar is going to be about 45 minutes long and then we will have a Q&A period at the end. So I'm going to go ahead and turn off my camera and my mic and hand controls over to Cliff and Christine. And if anyone has any issues with the tech, please go ahead and put it in the chat box. And if you have a question during the presentation, please put it in the Q&A box and we will keep track of both as we go along. So we'll see you at the end of the presentation and thanks. Thanks Robin and Elena. We really appreciate the invitation to come and talk to you today. Good afternoon everyone. I'm Cliff Landis. Hey everyone, it's great to be here. Thanks to AIC and AFR and I am Christine Wiseman. Together we're going to be presenting on a project we've been working on for the past couple of years called GANCH. Rhymes with Ranch. So to briefly introduce the project design, the goal of this one-year project was to create a publicly editable directory of Georgia's natural, cultural, and historical organizations in WikiData, allowing for quick retrieval of location and contact information for disaster response available via a website. And as Robin said, Cliff and I are both with the Atlanta University Center, Robert W. Woodruff Library that we're both working respectively from our homes at the moment. I am Assistant Director of Digital Services and we are the lead organization for this project. Our library is a consortium library so we like consortial projects. We serve four institutions, HBCUs all located in Atlanta, Clark Atlanta University, the Interdenominational Theological Center, Morehouse College, and Spelling College. And I'd like to say a huge thank you to Lyrasys for funding this project through a Lyrasys Catalyst Grant. The Lyrasys grant funded several positions or a position for our graduates as Assistant Allison Smith pictured here on the slide, and also our web developer Matthew Stevens. Additional team members Jessica Lemming and Alex Dade from our Digital Services Department chipped in on the project as well. We couldn't have done this without our partners, we had partner organizations throughout Georgia and the Southeast both both professional organizations and governmental. Some of our partners provided assistance to provide assistance to NCH organizations impacted by disasters, including Hera and Cher. We also provided membership lists, help without reach, and are helping with sustainability of the project. So before Cliff presents on the technical aspects of the project and the workflow I'd like to provide some context about cultural heritage disaster planning in our state. In Georgia we are modeled after the federal planning structure, and we are organized into 14 emergency support functions or ESFs. National or natural excuse me natural cultural and historic organizations or NCH organizations are located under ESF 11, which is coordinated by the Department of Agriculture and the Department of Natural Resources. Under these primary agencies, there are support agencies and you can see in the tiny script there that provides support functions under the state plan. And you can see that the Georgia Archives, the Georgia Historical Society, the Heritage Emergency Response Alliance, and Savannah Heritage Emergency Response are all included in the plan. This was added as of 2015, which at the time was a huge accomplishment that we got introduced into the plan. Since then we've worked really hard to cultivate relationships within the primary and the support agencies within the ESF 11 because of course in a disaster they have many other responsibilities to deal with. We have a particularly good relationship with the lead planner from the Department of Agriculture, Vanessa Sims. She has really taken a strong interest in NCH organizations has really helped to raise our profile within the state planning ecosystem. So now I'm going to talk a little bit about our AFR networks in Georgia. HERA is the Heritage Emergency Response Alliance we were established in 2007 after the AFR forum that was held in Atlanta, right after Katrina. I happen to be one of the founding members of HERA and the current co-chair along with Tina Situ who may be on this I'm not sure. And our members are, we have individuals, we have conservators, preservation professionals, librarians, curators, archivists, and first responders. Generally we have a little over 100 members on our listserv and our network has really grown from an Atlanta area network to really having members from around the state. We have a steering committee and a directory of members that we call on and we can deploy when needed to aid other institutions. Of course our primary purpose is to help other cultural organizations if they're impacted by disaster and to that end we have participated in statewide drills and exercises along with GMA Homeland Security. We have educational programs, webinars like this. We try to do a webinar at least every once a year, usually around May and the spring. Or and we've had you know course in person training as well. Over the past few years we've really evolved into working with the state to coordinate response and recovery statewide through ESF 11. Share is our sister organization in Savannah. Share was formed in 2010 after another AFR forum. Share has institutional members. They cover just one county. HERA is like, depending on how you count it, we have like 15 counties in Metro Atlanta. Share's members include museums, archives, libraries, cultural historic sites, art galleries, parks, houses of worship and first responders and emergency managers. One of Share's great accomplishments recently was they actually worked with Chatham County Emergency Management to map 80 cultural heritage institutions into their web EOC as critical facilities. And that kind of in a way led to this project that we're talking about today. So two other initiatives I wanted to bring up that many of you probably have already heard about, but we have two other initiatives underway of course the GANCH project, which is what we're going to talk about today. And also we're working with AIC to the Georgia Heritage Responders Training Program. So that's been coordinated by AIC and Elena as part of an NEH grant. The goal is to train a statewide response team similar to the, you know, NHR teams. This project is in the process of training 40 people from around the state with a combination of online instruction, culminated by a two-day hands-on training session in Savannah. That was supposed to be in April, but of course it had to be postponed due to the pandemic. We're hoping to have that in fall. In the meantime, we've held meet and greets, and we are planning some virtual tabletop exercises next month. So why do we need this tool? So, and all of these projects and initiatives around the state would really benefit by having some sort of statewide database of all of the universe of cultural heritage organizations. Natural disasters are impacting our state in an alarming rate. In the past few years, we've dealt with flooding, rainfall, tornadoes, multiple hurricanes and tropical storms. And of course, as all of you know, 2020 was the most active hurricane season on record with 30 named storms. Georgia is one of the, is the largest geographic state, east of the Mississippi with 159 counties. We have extensive and diverse natural and cultural historic sites that preserve and document the unique history of our state. So it'd be a great benefit to have a comprehensive list of institutions for disaster purposes. Now we have that. So we started out this project in 2019 and at that point we were contacted by FEMA. As they were preparing for Hurricane Dorian and they asked us to share what coordinates that we had at that time for institutions and we really mainly, as you can see from this map, we mainly had the coordinates of institutions from Savannah. So even before the project right in the beginning of the project, before we really got started there was already a need for this and some of the data was already being used. So in the past, how would we find these organizations well we would basically look for directory information and it's out there but it's scattered into different data sets, none of which are publicly editable. So we did a video coded or particularly up to date. So we started with the Georgia historic historical records advisory councils, historic and cultural organizations directly which would have been around for at least a decade, but really was had become fairly out of date. And the Georgia historical societies directory of affiliate organizations, and the Georgia Association of museums and galleries directory. And the list of Georgia public libraries, and several other directories which we eventually estimated at over 1500 organizational records combined. So there'd be some overlap among these directories but we really didn't know how much until we got more into the into the project. So as Christine was saying we had all these data sets, but we really needed a place to combine them all and to deduplicate them because we knew that there would be some duplicates across the databases. So we've mentioned a little bit about linked open data and wiki data several times so in case you're not already familiar with these terms. Let me give you a brief explanation of what linked open data and wiki data actually are. So linked open data is a way of publishing machine readable facts online, linking them together, and then giving them an open license for all of the data, allowing for access and reuse, hence the term open in linked open data. You'll also sometimes hear linked data, and without that open in the middle of it, it can often refer to closed and proprietary databases, like something at Google or Facebook. So wiki data is a free and open knowledge graph that acts as a central storage place for the structured data of wikimedia sister projects like Wikipedia. So basically it's a big database of facts with the ability to link those facts together. And this was actually a perfect fit for the in CH organizations directory and location information that we wanted to gather and map for Georgia. So when designing the project and writing the grant proposal, we focused on several principles. So wiki data provides a flexible structure to represent many relationships and repeatable fields, so that records are easily enhanced with additional data. Facts in wiki data can be done manually by anyone, allowing for decentralized updates. So there's no need for an institution or individual owner to grant access to the data for regular updates, thus removing bottlenecks to keeping the information up to date. The data represented in wiki data are provided with an open license, as I said, so to honor this we didn't reuse any copy writeable content from any of our source data sets, things like collection descriptions. Reference links were included for each statement providing sourced information for verification, and this also helps to provide a direction for future updates. So we completed using free software guaranteeing broad access and free implementation. And we made an effort to provide a model for other states by documenting and presenting on all the processes that we used. We also wanted to design the project to provide a graduate assistant paid internship to give an up and coming information professional practical experience working with link open data, and we're very lucky to have Allison join the team. So now I'll go over how we went from the design principles to the actual workflow for collecting verifying and uploading the data. And to give you a little backstory, the idea for this project actually started in 2018 when I attended the Georgia Archives Institute. GAI is an annual two week crash course and archival practice. And since I was trained as librarian, I had lots of gaps in my knowledge of archives so I really wanted to attend. So after I was able to attend and meeting so many cool archivists there. I wanted to see a map of all of the archives in Georgia, but after looking around I realized that there wasn't anything available out there. So I started looking for directories of cultural heritage organizations in Georgia, and I came across that crack historical and cultural organizations directory that Christine had mentioned before. And I had the latest web scrape of that data in that directory and I cleaned it up and then enhanced it with geocoordinates and county information. And then I uploaded it to wiki data. So when I mentioned this test upload to Christine she explained that she had already worked on that same directory, while she worked at the Georgia Archives, and that the data set really needed to be brought up to date and so she suggested that we apply for a grant and here we are. We had the in place we had to choose what kind of metadata elements we wanted to include and how to rank them in terms of priority. So required metadata elements included the organization's name and any aliases that it had a brief description of the organization and what type of organization it was like a library archive State Park Historical Society etc. We also required the street address city counties state country and geographic coordinate location information. If the organization no longer existed we also required the record of the date the organization dissolve so that we could exclude it from our search results and that way, you know, even though we're putting it into wiki data we're saying that's closed so that we can say you don't need to look for this organization in a disaster. We tried to capture contact information like phone number website and some sort of generic organizational email address. And when we had time we also gathered the start and end dates for the organization, any organizational relationships like if it's an academic library that houses a distinct archives we tried to describe those separately and then describe the relationship between them. We also gathered Facebook ID and Twitter username when they were available is these are often used during disasters to describe the status of an organization and its collections, and to be perfectly clear. Not all of the organizations had all of these fields available. So for example, many historical societies that are smaller and little counties like my home county of Lowndes County. And they don't necessarily have a physical location because in a lot of times, they're run by volunteer organizations with maybe only a PO box and a phone number. So we did the best that we could with the information that we had. Also during our focus group sessions with heritage emergency responders. There were requests for some meta metadata elements that we just couldn't accommodate. We ended up out of scope for this project, and they're out of scope either because the information doesn't fit into wiki data like collection descriptions, or because the information is private like cell phone numbers for organization administrators, or because it was a security risk like hazardous materials or formats. When we first started planning the project, we searched for all of the glam organizations in Georgia that had coordinate location information recorded in wiki data, which only pulled up 40 organizations. Now look at that map of Georgia very closely and look at the next slide in comparison. At that time if you search by glance in the United States you got even more results in Georgia. And this has to do with a little bit of the messiness around how information was tagged in wiki data. And that was the type of data that we were planning on updating and cleaning up to make uniform across the state. So we also did this project to find smaller hidden institutions, such as the Georgia rural telephone museum located in Leslie Georgia. Even though there is an entry for this museum in Wikipedia, we didn't have the information in any of our partners data sets. So one of the more rewarding parts of this project was discovering and including these lesser known institutions, and adding them to the data set for disaster relief. So as you can see from this map, we made quite a lot of progress over the course of the grant. So we widen our search out beyond just glam institutions to try and get as many relevant NCH organizations as possible. So as of November 11 in 2020, our big search for the entire state returns over 1900 institutions, and I checked it this morning and I think it now returns over 2100 institutions, as well as individual things like statues, you know famous public statues and stuff. The search includes things like historic districts that don't necessarily have contact information so that emergency responders can cast as wide a net as possible when doing helicopter flyovers following following a disaster. And beyond the maps we also make the data available in table format, as will show being able to export the contact information and table format helps emergency responders reach out to these NCH organizations to see if they need the data before and after disaster strikes. So the free software that we used for the project includes open refine GitHub and Visual Studio code. We chose to use Visual Studio code to save and manage the data and CSV spreadsheet tables. Since Microsoft Excel tends to force formatting particularly around dates, which VS code does not so it made things a little bit easier. So we started the process by scraping websites, gathering lists from our partners and creating spreadsheets of these NCH organizations. We then used free website tools like geo code and things like that, in order to enrich the organizational data with additional metadata like coordinate location and county. We loaded each spreadsheet into open refine and began matching up the organizations to their records in wiki data if those records already existed. Then we reconciled our fields against wiki data schema inside of open refine. So we have our data dictionary available on our GitHub site if you're curious about how we mapped the spreadsheets to wiki data schema. And next we created references for each link data triple. So for every single fact, which is sometimes called a triple, since it's a subject object and predicate. So for every single fact that we uploaded to wiki data we supplied three values the fact itself, the reference URL and the retrieval date. So by citing our sources with snapshots and timestamps, we're giving folks in the future the ability to trace and update each fact as things change over time. So this allows us to track organizations that have dissolved like I mentioned before which allows us to exclude them from our search results. We captured the reference link using Internet archives way back machine to unique fact to unique things happened when we captured this information over the course of a year. The sites went down after we captured the information. And then we also captured a lot of COVID-19 information while we were processing through these sites. So by using Internet archives way back machine to take snapshots of web pages where we found each fact, we're able to basically show evidence of our claims in wiki data. And then the last part is that we uploaded the information to wiki data, and we did so using open refine. So this slide shows the Aragon Historical Society, which we added as part of our testing phase. So after the data is uploaded to wiki data we perform quality control on each entry to verify that things are correct, and especially the coordinate location information which can be a little bit tricky. Sometimes getting that coordinate location data is hard because, you know, sometimes listed as being like at a crossroads or it might just be in the center of a property rather listing the actual location of the cultural heritage materials. So we did our best to try and put the marker right on top of the building, because after disaster street signs and other way finding markers are often damaged and destroyed so we tried to get as close to the actual object itself as we could. So a little bit about the website outreach and sustainability. So we knocked up our website for testing and feedback to ensure that it met with emergency responders needs. Here you can see our initial homepage wireframe and mock flow. Now wiki data can occasionally run slowly or be temporarily unavailable. So to prevent any outages during a disaster, our web developer Matthew Stevens designed the site to actually store the query results locally in the website. So the queries are refreshed nightly to keep the information on the website up to date with any changes that happened in Wikipedia overnight. So we have three main query types, Georgia as a whole individual Georgia counties and the eight GEMA regions that the Georgia emergency management and Homeland Security Agency uses to divide the state. The result page displays both a map and a table of the directory information for the NCH organizations in that area. Here you can see the results for GEMA region one, which combined several counties. So we recognize that the website may be used on mobile devices after disaster as cultural heritage first responders will probably be on the field. So I tried to make sure to give the website a responsive design with my particularly favorite feature a table that converts from single cell format on that converts over to single cell format on mobile devices to prevent users from having to scroll left and right on the table if they're not on a desktop device. We also provide users with instructions on how to export the tabular data directly from wiki data to a CSV file, and that way it can be imported into other systems like web EOC the emergency operation command software. So we're getting a lot of help from our partner organizations to get the word out about the project, not only the member institutions but not only to their member institutions but also more broadly to similar organizations and other states. So we emphasize that the partner organizations are the foundation of this entire project. They're the ones who will both be doing the disaster response and getting the help to their member institutions so that they're. So they are both the partners and the stakeholders in the making in making sure that this project is functional and sustainable without them, this project just would not exist. Now that we're at the end of the grant. We've worked with our state level partner organizations to begin the handoff for long term maintenance and sustainability. Sarah, Sharon Jima have integrated the final project into their disaster response workflows Galileo our statewide virtual library is graciously hosting the actual website and Galileo and the Georgia Public Library Services Archival Services and digital initiatives office, which is our statewide digital initiative will perform the annual updates and so we built an e-mailer into the website so that folks at Galileo and GPLS can send out reminder emails once a year to any NCH organizations whose emails we have. And this way we can request any updates to their contact information. If information has changed the edits can be can be made directly in wiki data, but if we send out these annual reminder notices and the email bounces back. That allows us to look at the organization to see if it's already dissolves. We created a self submission form on the website so that organizations can let us know if their directory information has changed. This is also very helpful to identify new NCH organizations that arise over time. So if you're from Georgia and you see the organization is missing from any of our source data sets. Just let us know via the form and we'll make sure to make, we'll make sure that your organization is included in wiki data. I think we got everybody but you never know. And also to make sure that everything associated with the project is free transparent, adaptable and reproducible. We created to GitHub repositories, which include everything associated with the project. An example of this is our workflow manual shown here, which basically walks you step by step through the entire process that we developed. And with that I'll pass it back over to Christine. Oh, thanks, Cliff. I was reading the questions. Shouldn't do that. Thank you, Cliff. I'm going to talk now about things to consider if you decide to undertake a similar project in your state, and also some things that we learned and some additional uses for the data set and the impact of the project. So things to consider. We came up we discovered that there's a lot of duplicates and name variations probably not too surprising. Some organizations change their names or have aliases that create duplicates. So pay close attention to the names and sometimes do a deeper dive into the history of an organization. As we discovered name variations we recorded them in the key data. We also found that due to the sum of the data sets being outdated many organizations were no longer in existence. The process to verify dissolved organizations to determine the dates included reaching out to the context looking at newspaper articles looking at trip advisor and the Georgia registry. These are some of the most aware of organizations that might have been started in your state so the organizations that began in Georgia that have since relocated, and then there's national organizations whose main offices might be in your state. We still captured these records. So let's look out for expired domains. These are domains that may have expired and been purchased by another organization. Be careful because we found that in some cases these domains were purchased by organizations designed for explicit adult content. That we don't want in our database. What we discovered was the challenge of trying to map real world messiness to the much cleaner data model of wiki data. This challenge this challenge was not only trying to map map it but also trying to reach consensus with the wiki data community on how this should be handled. So what we mean by this is municipalities include towns villages and cities. The P 131 field in wiki data is the field for administrative territorial entities. This field is broad and can cover municipalities counties and states. Remember wiki data is an international tool. So in the documentation for P 131 it recommends that you only list the single most local administrative entity since the field is supposed to be both transitive and hierarchical and cascade upwards like you see on the left of the slide. In Georgia, the borders of municipalities and counties were drawn independently and about 10% of municipalities in Georgia are in more than one county. So they aren't transitive. This means that for our project we can't rely on wiki data is cascading hierarchy to be correct when it comes to searching for organizations by county. We reached out to the community or cliff did I should say to try to find a solution to this challenge but after several proposals and lots of discussion no consensus was reached. So for this project we explicitly decided that municipality county and state we're all in the P 131 field with the hopes that consensus on a solution can be reached in the future. And we figured it's better to have too much information than too little. Another thing we came across as we were reminded in the course of this project that Georgia has a rich but sometimes uncomfortable history. Georgia was the 13th colony and was also part of the Confederacy. The most challenging history is reflected in organizations and their records about the Confederacy slavery Jim Crow civil rights, sacred lands, etc. They're all part of our state's history. These, their organizations in Georgia that celebrate those that defended the practice of slavery, and there are also organizations who celebrate those that sought to abolish it. The project was completed at the same time that the protests were taking place against systemic police violence and racism. Yet no matter how we personally feel about parts of our history, we endeavor to record it all fairly and equally. No record should be erased because we're uncomfortable. And in fact our discomfort should push us into further discourse about what this, what these records and organizations mean to the state then and now. If you're interested in learning more about Georgia's history. This database has can be used for tourism. So you can run a query for places to visit based on city county or region. This image here shows glam institutions in to cap county where where I live in clip lives. The use we stumbled upon was related to visitor counts to public libraries in the state. Since the annual visitor counts from 2015 through 2017 for all of the library systems were already in wiki data we are able to get a little help from the community to graph those counts in another query. Here they are displayed as a line graph. It's a little hard to see because it's small. Type in this URL to see it in action for yourself. And to us it's interesting to have this information out there and readily accessible with no barriers to update enhance and enrich the data. So really any publicly available and verifiable fact can be added to wiki data so feel free to explore. So looking back at this project we feel like we accomplished a lot. We have over like 1900 cliff said what 2100 organizations now in the database and a single location. The website for emergency responders to identify organizations in affected areas. We developed this project to be open source and reusable, and we have a plan for sustainability so the data and the website continue to be useful over time. So we had our first in the field test this year in September with the landfall of hurricane Sally. In anticipation of heavy rainfall and flooding members of Harris sent out emails to 330 organizations that we pulled from the database from Gima regions 1347. Unfortunately, none of the emailed organizations requested assistance or had damage following the storms, but here I did receive thanks for reaching out. We didn't get a 9% bounce rate where emails cannot be delivered which actually isn't is pretty good considering we didn't test the emails before the project. We did discover though that not all organizations have email addresses on their website. So now we know that we're not reaching everyone in these areas, but it is a good way to at least get the word out and quickly that emergency assistance is available. We're also through outreach efforts. We're hoping that institutions at least give us one emergency email. But we found that a lot of institutions have taken emails off their website and they have those forms instead. And for more cute disasters like a tornado emergency responders can reach out to organizations on a county by county basis, using the table of all available contact methods and this includes email the phone number Facebook, Twitter handles and website forms. So we are following up with the organizations whose emails bounce to see if they're still active, and to see if they can provide an up to date email address for emergency purposes. The timing around when to send these emails can be tricky due to how quickly and dramatically weather forecasts can change. This is a timeline that Tina see to and I developed as part of our documentation. So it turned out hurricane Sally ended up not to be as damaging to Georgia as predicted, then a few weeks later another storm and I think it was delta was initially predicted to just be have minor impacts in Georgia but then it quickly increased in severity and we actually had widespread power outages in North Georgia tornadoes and lots of trees down. We ended up not sending emails out in advance of that storm. And then we developed this we updated this timeline so it really is a judgment call to balance between when you're sending out too many emails to where folks stop paying attention versus not enough. So we do have this timeline and generally, we start monitoring the storms very closely when it's five days from landfall, and then we begin to send. We usually send the email blast out to targeted areas about three days before the storm hits. We have we have developed canned email templates. So it's pretty quick to pull the information out of the database. You have to do a little bit of massaging of the data. And then we can update the emails and send them out from we send them out from the Hera Gmail account. So it's a work in progress but having the databases a critical part of this response. So I know that we covered a lot today, but I'm very happy to say that in the end, I got my wish that the initial idea was created from so here you can see a map of all of the archives in Georgia. And a link to this map available at the bottom of the slide. As I said before, you know, if you know of any organizations in Georgia that we missed. You can either fill out the self submission form on the Gantt website, or even go to wiki data and add it in yourself. And with that, I think we moved a little quickly. And so we'd like to thank you all for your time and attention today and we are happy to start taking questions. I'm going to pull up the questions here. Okay, so our first question is from Tara Kennedy, and it is how much cooperation did you need to get from the SF 11 slash female leadership in order to accomplish this project. I can take that one clip. Thanks Tara. Well, we had really great cooperation, both from the state. Jima ESF 11 folks and from Lori Foley and FEMA I mean Lori's been a great cheerleader for this project she was on our advisor committee she attended a lot of the meetings, and she's done a lot to help get the word out about this project. And same with our state level folks I mentioned that in one of my slides we've just really been lucky to develop such a good relationship with our ESF 11 coordinator. In the state and she is also an amazing cheerleader for the project and has made a lot of connections with us and is going to help us get the data imported into the state. That's that's the next step. And I think that was really just building relation while having Lori is great, you know we've worked with Lori for years so that was a huge advantage and then just the years it took to build relationships in the state. And eventually you find that person that really is aligned with us and it just takes time to find those people but they're out there for sure. And then Carl Stewart asked, how did you select partners. Yes, anyone and everyone. Christine you can take this one. Yeah, we were not selective but we really wanted to. You know reach all the institutions so we just reached out to all of the umbrella organizations that we could think of that we knew about in turn that. You know involve cultural heritage organizations so we see them organizations archives libraries. We want to get one area that we, we didn't really have time for is all of the local governments and that is a whole nother realm in itself. We got some of those folks included but we did start to look at the clerk of courts list I believe Cliff but I think we just had to table that so we could maybe do a phase two at some point there's always more to add. Do emergency managers access this data through the public facing website or do they have a different method of accessing the data. They access it through the public facing website. The way that we have it set up is that the publicly facing website gives you sort of a brief view, sort of slicing and dicing based on whether you want to see an emergency response region or individual counties or state as a whole. But that's actually the reason that we built that export instructions into the website so that folks could export the data for their own use in any way that they want. There really isn't any sort of back end to the website other than to edit and adjust the queries themselves that end up in the different sorts of displays. Okay. Could you talk more about getting state library to host website. Yeah, they actually volunteered, which was great, like Christine and I were really blessed through this whole project because when we pulled everyone together for the first few meetings ever, you know, we were met with like 99% enthusiasm from everybody. And so when we said hey, is there any sort of organization at a state level who'd be willing and Galileo, you know, volunteer, we were very happy with that because that way, you know, we work at an individual library and we're working with all of these partners but we didn't want to necessarily place the onus on our library we were looking for something state level to do the hosting, and we were very lucky that Galileo volunteered. Thank you. Looks like we have few more here. Is there a way to hide levels of data behind some sort of password protection. There is not. There is not that's the the wiki data platform is specific to publicly available information. And so for example, you know, a lot of organizations have individual folks email addresses. So we made a point that we would only include publicly visible email addresses if they were publicly visible on that organization's website so somebody's name. You know, like john dot dough at organization.org is published on that organization's website, we'd be willing to include it but we didn't include anything that was private or had personally identifiable information otherwise, just because we're basically reusing publicly visible material. So in the case of you know when I was talking about the metadata fields in the case of those things like cell phone numbers for administrators formats and those sorts of things. We've been trying to encourage folks as we go around to get in touch with their EOC emergency operations folks locally, as well as at the state level to say hey, these types of materials. The information like cell phone numbers and formats would be very helpful for the actual emergency responders, but there's just not room for it and wiki data because it's not built for that sort of secure information. Thank you. So is it possible to find quote closed glam closed glam. I don't know what that means. Is it a closed institution, maybe, or something with like closed stacks like, or private organization. Carl, if you're able to clarify your question in the chat box, you can go about it that way but I'll move on to as he has another question right below. I have two other states planning to follow you. He is with Colorado cultural and historical resources CHR and is running a proposal around for money with Colorado Boulder to do preliminary information collection research. Nice. We haven't heard anyone tell us yet that they're following our model we've had we've had interest but we haven't heard anyone say hey, we're following the ganch model in our state or our region. But we hope somebody will. Yeah, feel free to raise your hand now and volunteer to follow the model. And he was referring to discovered. Oh sorry. This disobey. Oh, thank you. Yeah, so because the data sets that were that we received were all, you know, out of date nothing can stay up to date except for something you produce today. That's why we did that quality control check and when we ran across dissolved organizations, we did include them in the data set so they're in wiki data now. But we also included the date that they dissolved, along with information about when that date was like you know if it was 2016 we tried to find some sort of newspaper article or, you know, a tweet or something else that indicated this was when it dissolved. And that way we have some sort of record that the organization had dissolved. What we did is we wrote into our scripts for great for our ganch website, all those queries. If you look at the code itself you'll actually see that it, it excludes any dissolved organizations. And so that way if, if Hera like looks on our ganch website, they will not see any organizations that are already closed in order to save time when it comes to responding after disaster. And so that's how we sort of navigated that is that yes we recorded that the organization existed yes we recorded the date that it was open and closed, but we're excluding it from our disaster response website to just save time. Okay. Many organizations have more than one location for the holdings. How did you manage that in the database. Excellent question. I'm very curious to hear about this because I know I've run into that problem to have multiple addresses and all sorts of craziness. Yeah, so the best example I can think of is the Georgia technical college system TCSOG and technical college system of Georgia. Where any, you know, they did a lot of mergers over the last decade and so like, I think in South Georgia it's like wire grass community or wire grass technical college has like five different campuses. And so this is actually a funny story is that we had the data set and so we're like, okay, here, all of these technical colleges that each have anywhere from two to, you know, seven different branches. So what we did is we actually looked at every single branch and tried to find where the location of the library was for those technical college campuses, even if it was like in one building. We tried to find some sort of record somewhere that the library was in that building. And so as you look at like the technical colleges. In the data set you'll see that like the the Vavasta campus and the Eccles campus and the Brooks campus will each have their own record for those libraries because we're trying to pin down each and every one of them so we listed them as separate institutions. And then we said that their parent organization is that technical college system. So, you know, each of these different campus libraries will all be under the parent organization of wire grass technical college. I hope that makes sense. Yes, okay. Any possibility of a guide for the rest of us to follow for other states. Yes. So, if you actually I will go back. So if you just search for the word ganch on Google, if you do like ganch linked data or something like that, you will find links to the project GitHub repositories which are down at the bottom of this slide. And the one that says ganch data actually has this workflow manual that we show here on the slide. And so that'll actually walk you through the whole process of how we took, you know, gathered the data, cleaned it up, ingested into open refine reconciled it and uploaded it. So, we also have a GitHub repository at the bottom for the website so if you want to show that to your web developers that'll show them how our website is built. We kept them separate because they're basically two separate things one is the actual source data set, and the other is the website. Thank you. Is ESF 11 involved with both response and recovery. I guess I could take that one clip. Yes, they are in that. The idea was to make the Hera and share the other cultural heritage organization sort of independent and be available as resources so the ideas if emergency responders happen upon a cultural organization that has damaged and they can refer them to us and if we do our own outreach before and after disaster then we can coordinate with them if they if those institutions need resources beyond what we can provide so we work very collaboratively with them in both response and recovery. I would say Hera and share more involved in in pre disaster actions sending out the emails which is the purpose of this database before disaster occurs, and then we work through ESF 11 to coordinate calls and we have done pre landfall calls to make sure that we have the resources they need before the disaster and then we also coordinate calls afterwards to assess damage for situational awareness and those sorts of things so I guess you know they are involved in really all aspects. Okay. And then we are not thinking so this is I think referring back to Colorado again we are not thinking of including natural resources. Can you discuss, you can you discuss your choosing to include those. I can, I can answer that one too. Because of the way ESF 11 is structured in Georgia. The lead organization is our Department of Natural Resources, which is over parks, and also over historic preservation so I don't know how if it's structured and differently. It's in states, but parks have a lot of historic sites in Georgia and they also have collections and exhibits of a lot of the park so we did include natural resources and of course historic structures and buildings which are all also under natural resources in terms of the state planning structure and the organization of how of the state. That makes sense. So I'll chime in that you know the question is often raised about archaeological resources, and that's actually something that we didn't include on purpose, because a lot of times, you know you have to protect the coordinate location data for archaeological resources to prevent poaching, or anybody coming in and messing with the site or doing any sort of damage, and there are separate archaeological resources databases in the state of Georgia run by I think also parks. But we chose not to include those because a they're not exactly organizations which this generally focused around organizations, although the breadth did, you know, sort of expand over time. So we considered that to be secure data and we didn't want to pose any additional risk by including those in wiki data. Glenda Anderson asked, we have been building relationships with our federal state and local emergency management entities for more than 10 years in Georgia. So we're going to be building relationships with our federal state and local emergency management entities for more than 10 years in Georgia. So we're going to be building relationships with our federal state and local emergency management entities for more than 10 years in Georgia. We have our number one cheerleaders on the GANCH project so she's she's very involved with Sharon we've been very lucky that she's done a lot of that face to face relationship building. I think that's a lot of it from all levels like building those relationships and trying to get like, so people know about you because I know whenever I go to places and I'm a contract registrar so I'll go to places and help people with emergency services and they'll sometimes say like well the fire department doesn't talk to us and I'm like well you gotta get on your agenda and like go and like meet them and be like hey fire department what's going on and like building those relationships will help everyone as they build all these types of projects for sure. Olivia Permanis, she's from Texas Sierra asked, what size was your grant and did it cover all the costs of this project. Yeah, I can answer that. Hey Olivia. Our grant was actually quite small. And what was it $16,000. Yeah it was less than $20,000. It was a very bare boned grant but we are grateful to have it. Cliff, all of his time was pretty much free. He did it as part of work. So I think if we actually would have costed this out and done an actual grant to cover all the costs it would have been quite a bit more, but the grant primarily covered our graduate student program of the travel and a computer so we made it we wanted to make it small because we knew we'd have a better chance of getting it funded and our institution was supporting cliffs time on it. I don't know if they ended up knowing how much time he spent on it. Oops but no but it was a great project and we got great support but we ended up actually devoting to other department members, a little bit to the project so definitely it did take longer than we thought so it did take more staff time than we had planned so I would say if you're going to write a grant definitely we could talk to you about budgeting for time. I think now that we've done it we have a better sense of how long it took it was going to take because at that point it was all just a pilot, and we really didn't know. I will tell you that the contract developer time for Matthew Stevens was not nearly enough. We contracted for I think like 20 you know 40 hours or something like just not enough time like assume that the web development piece of things is going to take a lot more time and also plan in money for presentations and travel and speaking and stuff. We were kind of in the silverest of linings and and I don't want to be dismissive, but COVID-19 actually was a good thing for us because all of a sudden everything went online and so we didn't have to worry about getting the word out because we could just sit in front of our computers and get the word out so as grim and unfortunate as the last year has been the timing actually worked out for us to be able to get the word out more than if we you know just didn't have any travel budget written into the grant. Right and thank you for mentioning that because Matthew Stevens did donate quite a bit of time to the project which was very kind of him. It looks like California is also working on a similar data compilation and seeking funding. They proposed data would be hosted on state site with password and grant funding requests in process with Cal OES and FEMA. There are more questions here. We encourage anybody who's interested and has more questions for Cliff and Christine to reach out to them with, you know, more inquiries, but we don't want to take up any more of their precious time that they've gifted us with today. So thank you so much, Cliff and Christine. We really appreciate you sharing this project with us. And I think this is super interesting and beneficial. Thank you. Thanks everyone.