<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Lillian Curanzy on Medium]]></title>
        <description><![CDATA[Stories by Lillian Curanzy on Medium]]></description>
        <link>https://medium.com/@lc63?source=rss-38c2d5666c72------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/2*6CfYxvQqFWEktCI782xXSQ.jpeg</url>
            <title>Stories by Lillian Curanzy on Medium</title>
            <link>https://medium.com/@lc63?source=rss-38c2d5666c72------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 23:48:05 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@lc63/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Opening Rural Library Data: Applying Coursework to the Field]]></title>
            <link>https://medium.com/open-data-literacy/opening-rural-library-data-applying-coursework-to-the-field-3137ce64c187?source=rss-38c2d5666c72------2</link>
            <guid isPermaLink="false">https://medium.com/p/3137ce64c187</guid>
            <category><![CDATA[open-data]]></category>
            <category><![CDATA[public-libraries]]></category>
            <category><![CDATA[data-curation]]></category>
            <dc:creator><![CDATA[Lillian Curanzy]]></dc:creator>
            <pubDate>Wed, 04 Sep 2019 17:49:04 GMT</pubDate>
            <atom:updated>2019-09-04T17:49:04.835Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NTJRGwODFfXQ_y2UA2Bv2Q.png" /><figcaption>Snake River, Clarkston, WA</figcaption></figure><p>Asotin County Library (ACL) has introduced an open data initiative that will provide public access to civic data collected by local government agencies. Library staff members are well suited to provide open data support to their communities by working as <a href="https://www.urisa.org/clientuploads/directory/Documents/Journal/Vol28_final.pdf">civic infomediaries</a>. Despite the natural relationship between open data and public libraries, it remains uncommon for libraries to openly publish their own data. The scarcity of open library data can be attributed to demands on staff time, a perceived lack of data usage by external groups, or an overestimation of the skills required to process and publish data. This post discusses the methods, tools, and standards used to prepare and openly publish library data.</p><p>Libraries collect and use data for a variety of purposes. Circulation, holdings, and bibliographic data describe resources — physical and subject characteristics, location, authorship, and use history. Libraries collect data around programming and other services that track desired audience, program themes, and attendance. Operational data include financial reports, salaries, funding, and facilities information. These domains inform various internal activities like budget planning, collection development, staffing, and service offerings. However, there are definite applications for each of these domains across multiple user groups.</p><p>I was able to utilize the methods and tools covered in the data curation curriculum at the University of Washington iSchool to complete an internship with ACL and Open Data Literacy (ODL) over the summer. Two significant goals of the internship were to publish Asotin County Library data to Washington State’s open data portal, data.wa.gov, and to create documentation that will streamline the publication process of future open publishing in Asotin County — both by the library and other agency partners.</p><p>­­­­­</p><p>A terminal project in the data curation curricula at the iSchool asked students to design the curation protocol for a data repository. We practiced weighing, defining, and assigning various metadata elements from several well-used schemas. This gave us insight into how proper metadata use promotes data sharing. Furthermore, the understanding of why repositories require certain elements to be filled out by data providers guided the development of a metadata template.</p><p>In order to make the data preparation and publication process easier for future contributions, it made sense to create a template for metadata creation that is broadly designed for use with Socrata repository software. A principal objective of the metadata template is that it can be used by library staff to publish prepare and publish data from other civic agencies.</p><p>In addition to the record-level description and dataset metadata, it also captures context and preserves primary data. When filled out prior to data ingest, this template supplies the data partner with complete and accurate documentation which will facilitate discovery and reuse. It also serves as a record for the dataset owner of what data has been uploaded to the portal and what it takes to replicate the process.</p><p>While thorough metadata is essential for data sharing, financial concerns can limit how much staff time is devoted to documentation. Economic sustainability was taken into account when designing the template. A cost analysis is included in the requested information for each dataset. The value of a dataset can be appraised by considering its impact and likelihood of reuse. Administrators can leverage this value and cost estimate to inform their organization’s open data plan.</p><p>The next goal, publishing datasets to the state data portal, required some preliminary steps including the selection of datasets to publish. Data privacy and other ethical considerations — significant aspects of Fundamentals of Data Curation — were instrumental in shaping the kind of data that was ultimately published. The question of data demand and the likelihood of reuse also factored into data selection.</p><p>In order to predict potential data reuse, I drafted comprehensive use cases related to multiple stakeholders. A use case is a question answered or problem solved through access to the dataset at hand. Informed by case studies and personal experiences, these use cases were among the most advantageous steps in the data preparation process. This practice was emphasized in the cumulative final project of Advanced Data Curation. Not only do they work to justify open publishing by illustrating how the data could be used by external stakeholders, but they can also guide data collection and retrieval.</p><p>Once the data were selected, based on use cases and <a href="https://data.seattle.gov/Community/Checkouts-by-Title/tmmm-ytt6">open library data precedent</a>, they needed to be transformed from how they were exported from the library’s database to conform to tidy data expectations. Version control was a vital component at this stage of the project. The original spreadsheet as it was exported from the database is saved in the template, but also in separate files on the computer and in a dedicated web-based repository for the project. <a href="http://openrefine.org/">OpenRefine</a>, an open source tool for working with tabular data, was integral in transforming the data while simultaneously logging those changes in a manner that will aid future automation.</p><p><a href="https://vita.had.co.nz/papers/tidy-data.pdf">Tidy data</a> concepts were covered broadly in Advanced Data Curation. When data is clearly formatted, it can be shared and analyzed most effectively. Therefore, tidy data standards were applied to the public library datasets that were chosen to be published. This project allowed me to implement proper data formatting standards, but it also gave me cause to investigate the Resource Description and Access (RDA) and Library of Congress rules that govern how bibliographic data is stored.</p><p>Through this project, I learned that, other than having a knowledge of data best practices, the skills needed to prepare and publish open data are widely possessed by library staff. We work with databases and information organization daily. However, the courses I completed at the iSchool instructed me in the importance of complete documentation, tidy data standards, version control, and preservation activities.</p><p>Moving forward, a few challenges remain. Further automation in the form of adaptable Python scripts will allow datasets to be easily formatted. The API provided by the library’s catalog software can be used to routinely retrieve data. These steps toward automation will require knowledge of systems and coding but once these protocols are in place, demands on staff time will decrease. Despite increasingly effective automation, it’s clear from my experience with ODL and coursework that human intervention remains the most integral part of successful data curation and sharing.</p><p>Moving forward, a few challenges remain. Further automation in the form of adaptable Python scripts will allow datasets to be easily formatted. The API provided by the library’s catalog software can be used to routinely retrieve data. These steps toward automation will require knowledge of systems and coding but once these protocols are in place, demands on staff time will decrease. Despite increasingly effective automation, it’s clear from my experience with ODL and coursework that human intervention remains the most integral part of successful data curation and sharing.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3137ce64c187" width="1" height="1" alt=""><hr><p><a href="https://medium.com/open-data-literacy/opening-rural-library-data-applying-coursework-to-the-field-3137ce64c187">Opening Rural Library Data: Applying Coursework to the Field</a> was originally published in <a href="https://medium.com/open-data-literacy">Open Data Literacy</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What’s Not There]]></title>
            <link>https://medium.com/open-data-literacy/whats-not-there-c058a933e1bf?source=rss-38c2d5666c72------2</link>
            <guid isPermaLink="false">https://medium.com/p/c058a933e1bf</guid>
            <category><![CDATA[libraries]]></category>
            <category><![CDATA[open-data]]></category>
            <dc:creator><![CDATA[Lillian Curanzy]]></dc:creator>
            <pubDate>Tue, 09 Jul 2019 07:15:27 GMT</pubDate>
            <atom:updated>2019-07-30T20:00:43.678Z</atom:updated>
            <content:encoded><![CDATA[<h4>A case for public missing item reports</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/562/1*8vIQYBsX_I6G-PZA3ijwEQ.png" /></figure><p>In libraries, as in any retail environment, items regularly go missing. Typically, a “missing item” is one that the catalog says is not checked-out but isn’t found in its proper place on the shelf. Libraries have various policies to address missing items. The organization whose data was used to craft this analysis uses the following policy: An item’s status in the catalog is changed to “missing” and stays as such for 7 months. After this time, the item is deleted. Some items with a missing status are misshelved, others deliberately evade check-out, and quite a few just seem to disappear. While the unique circumstances that result in each missing item are often difficult to establish, tracking missing item data — and publishing it openly — can benefit libraries in numerous ways.</p><p><strong>Internal staff<br></strong>Missing item reports are one part of a comprehensive collection maintenance plan. When this report is performed on a regular basis and coupled with shelf searching, the integrated library system (ILS) more closely represents the physical collection — benefiting users and staff alike.</p><p>Furthermore, apparent trends among missing item types or subjects may indicate necessary changes to circulation or collection management policies. Some potential changes may include more secure storage for non-book materials or a policy that removes barriers for user groups.</p><p><strong><em>Use Case<br></em></strong><em>A rural library notices that a disproportionate and growing number of materials found on the missing item list belong to certain sensitive subjects. Administration decides to remove barcodes from YA books on these topics. This new policy may not reduce the number of items that go missing, but the change is largely celebrated as an attempt to increase access and mutual trust.</em></p><p><strong>Library consortia<br></strong>Staff and users from consortial libraries often don’t have the ability to readily verify the other’s physical collection; nor are they responsible for updating the holdings based on these collections. Therefore, member institutions rely on shared ILS’ or online public access catalog (OPAC) searching to communicate holdings for resource sharing purposes.</p><p>Collection development can also be impacted by the shared knowledge of missing items, especially if mirrored or complementary collections is a consortial goal. Purchasing and policy creation efforts can be streamlined by referencing missing item lists from member libraries.</p><p><strong><em>Use Case<br></em></strong><em>A purchase request comes through for an item that is already in the collection but has gone missing. It is also missing at another member library. Publicly accessible missing item reports are used to establish the items that are missing from multiple libraries. Now, instead of replacing every missing item, each library is responsible for only replacing a few items, saving money across the consortium by creating cooperative collections. It also saves time to compare lists, rather than search OPACs for missing items reactionarily.</em></p><p><strong>State library<br></strong>When public libraries publish missing item reports openly, a central body can analyze the lists to discover trends in item characteristics that may drive theft or misshelving.</p><p>For instance, are non-book materials with high replacement costs going missing more often than other items? Is there a relationship between item size and missing status? Do branches with more staff members or a particular security system encounter fewer missing items? How does the number of overall volunteer hours affect the missing item count?</p><p><strong><em>Use Case<br></em></strong><em>The State Library is able to access openly published public library data from the state portal at any time. As a central agency, it has an interest in understanding trends in library data on the state level. By analyzing missing item data taken from multiple libraries, the State Library is able to establish recommendations for collection maintenance procedures and simple staff activities that will decrease the number of items with a missing status.</em></p><p><strong>Library users and the larger community<br></strong>Missing item lists that are available to the community can help small public libraries, and those without alarm gates, to deter deliberate and unintended theft. Missing item reports can be compared with lost item reports to discover trends that emphasize needs at the community level, like gaps in public services or limited access to community programs.</p><p>Donations can be incredibly important to a library’s collection development. Making a missing item list accessible to the public may result in more deliberate, impactful donations to libraries by community members.</p><p><strong><em>Use Case</em></strong><em><br>A library user is reorganizing their home library and wants to donate some books to their local library. They are encouraged to check the missing item list located on the branch’s website to see if any titles on the list are among those weeded from their home collection. By referencing the list of missing library items, the well-meaning community member knows their donation follows the library’s selection policy, already has a record in the catalog, and saves the library money by deferring replacement costs</em>.</p><p><strong>More uses for missing item data<br></strong>In order for missing item data to be more informative and beneficial to libraries and their communities, certain item attributes need to be analyzed. The primary purposes of the missing item reports I’ve examined in the past are to convey the information needed to locate the item in its assigned place on the shelf and to graduate disappeared items to deleted status. However, by adding a few columns — and applying customary columns in new ways — this standard report is an impactful tool to prevent and replace missing items.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PQFCR1hyBVcS_62QdLT-oQ.png" /><figcaption>Figure 1. Shows item size by color and total item record count by circle diameter.</figcaption></figure><p>While working in a library certainly acquaints staff to the collection, it isn’t possible for everyone to be familiar with each item’s physicality. Therefore, the inclusion of item size and page count columns gives shelf-searchers a broad idea of how much space the item occupies, increasing the chances that it will be found. Additionally, as demonstrated in Figure 1, trends in item size can be used to inform storage and security procedures for vulnerable items. In this analysis, those items are under 15 cm.</p><p>A call number is used to communicate where an item can be found on the shelf and is a common variable in missing item reports. Based on the type of call number, it can also be used to broadly analyze genre and other item characteristics. Figure 2 shows an analysis of items grouped together with the Dewey Decimal Classification system; fiction items are also present. It’s possible that these categories could be further refined by exploring call number subjects in more detail.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ddq8aIUtNdO8k5KbZjRhxw.png" /><figcaption>Figure 2. Represents how many items belonging to demographically aligned shelving locations are listed among missing items. The median replacement cost of each item in the location is also displayed.</figcaption></figure><p>Analyses like these are most relevant to libraries with similar service areas and user demographics. They are also a resource to organizations that frequently lend to each other but may not share a catalog. These libraries will benefit from understanding how their collections are shaped by missing items. Nevertheless, after a missing item report is optimized to capture the most useful characteristics about the materials that got away, its the simple step of making it accessible to the public that may have the strongest impact on the community.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c058a933e1bf" width="1" height="1" alt=""><hr><p><a href="https://medium.com/open-data-literacy/whats-not-there-c058a933e1bf">What’s Not There</a> was originally published in <a href="https://medium.com/open-data-literacy">Open Data Literacy</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Persuading the Gatekeepers]]></title>
            <link>https://medium.com/open-data-literacy/persuading-the-gatekeepers-caaadaf90c1e?source=rss-38c2d5666c72------2</link>
            <guid isPermaLink="false">https://medium.com/p/caaadaf90c1e</guid>
            <category><![CDATA[open-data]]></category>
            <category><![CDATA[public-libraries]]></category>
            <category><![CDATA[data-literacy]]></category>
            <category><![CDATA[government]]></category>
            <dc:creator><![CDATA[Lillian Curanzy]]></dc:creator>
            <pubDate>Tue, 30 Apr 2019 18:49:44 GMT</pubDate>
            <atom:updated>2019-05-17T18:53:05.532Z</atom:updated>
            <content:encoded><![CDATA[<h4>A top-down approach to launching an open government data initiative</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/533/1*ikherbaC3Nc3Orn_r7Fuug.png" /><figcaption>The data is public, but some gatekeepers aren’t motivated to publish it openly — yet.</figcaption></figure><p>The Asotin County Library (ACL), located in the southeast corner of Washington State, is leading an open government data initiative. In addition to its geographic superlatives, Asotin County is the smallest jurisdiction in the state to launch such a project. At the county level, Asotin’s estimated population is just under 22,500 people (OFM, 2017), about half the size of the next smallest municipality in Washington that is openly publishing civic data. While this scale may seem approachable in terms of data quantity, rural areas often have less access to resources. Therefore, attempting an open data initiative in a small community is extremely valuable and deceptively complex. In this post, I will discuss some early challenges we encountered and common concerns voiced by Asotin County’s local officials.</p><h3><strong>Education and Advocacy</strong></h3><p>Representatives of the Washington State Library presented to government project partners in November of 2018. In March, the initiative’s organizers offered a <a href="http://data-equity.org/">Data Equity for Main Street</a> course to introduce open data concepts to local officials. Next, semi-formal interviews of department heads were conducted to gauge concern and understanding of open civic data. When I joined the project in April, we expected to have access to local data and begin the publishing process — it hasn’t progressed quite how we anticipated.</p><p>The first step was to reach out to a list of department heads who had attended ACL’s open data literacy course, expressed interest in the project, or both. My intention was to establish my existence for the purposes of dataset delivery; but as these initial emails graduated to introductory phone calls, it was clear that what began as a data curation project had swiftly become a carefully navigated campaign to build relationships, educate the wardens of local civic data, and advocate for data sharing.</p><h3><strong>Communicating Public Interest</strong></h3><p>A significant struggle that was articulated in interviews with partners was how to justify publishing data that the public presumably has no interest in using.<strong> </strong>In her discussion of government transparency, Moore (2018) theorized that transparency equates to “filing information in a virtual space to which the public have been permitted access” (p. 421). This understanding of transparency doesn’t mandate usage quotas, neither does open government data publishing. Thus, is it fair to claim that beyond prioritizing publication progression, use projections should have no bearing on whether or not data is published openly?</p><p>A common method of measuring public interest in civic data is to audit public records requests and analyze them by subject. This practice reveals trends in information seeking that often correlate to events — arrests, accidents, ballot measures — that pique public interest. It’s natural to assume that if a limited number of public records requests are produced for certain information, then public interest is proportionately limited. However, we must consider the sizable effort disparity between filing an official public records request and the few keystrokes needed to access data from an open data portal.</p><h3><strong>Context is Reality</strong></h3><p>Not all data is complimentary. Data can be neutral, shocking, and interpretable. It’s easy to understand why government leaders are inclined to interpret data before public release. If read without context, crime and incident statistics may depict a region as a high crime area. By publishing the pre-summary data used to calculate those crime statistics, the public has access to the big picture and is able to conclude that the region’s higher-than-average incidents of theft are concentrated in a large commercial-retail zone, not residential neighborhoods.</p><p>However, is the risk of misinterpretation a justified cause for restricting access to aggregated data? Or, is the threat of misinterpretation minimized by providing as much original context as possible?</p><h3><strong>Trust is a Two-Way Street</strong></h3><p>It’s understood that publishing data in a way that facilitates exportation, reuse, and sharing will raise questions of data integrity. If just anyone has access to a copy of the budget spreadsheet, couldn’t they manipulate values and misrepresent the City’s finances? While there are conflicting accounts that government transparency truly boosts perceived trustworthiness, making the data available that drives civic decision-making will provide a pathway to increased community engagement.</p><p>As government leaders are entrusted and enabled by their communities to capture and report accurate data, so should these government leaders trust their community members to accurately interpret and use public data.</p><h3><strong>Start Slow, Check-in Often</strong></h3><p>In the week following these introductory meetings, I sent debriefing notes to each interviewee. These notes expressed our gratitude for their time and support, reiterated the purpose of the open data project, and confirmed our interest in attaining any datasets that were discussed in the interviews as possible starting points.</p><p>I recognize that our data partners will determine the pace at which this project progresses. So far, I’ve focused primarily on meeting officials who serve on the city-level. Now that our purposes are clear, my next steps are to expand our relationship-building campaign to include the unincorporated areas of Asotin County while maintaining frequent contact with city officials.</p><p><strong>References</strong><br>Moore, Sarah. (2018). Towards a sociology of institutional transparency: openness, deception and the problem of public trust. <em>Sociology,</em> 52(2), 416–430. <a href="https://doi.org/10.1177/0038038516686530">https://doi.org/10.1177/0038038516686530</a></p><p>State of Washington, OFM (Office of Financial Management), Forecasting &amp; Research Division. (2017). 2018 population trends. Retrieved from <a href="https://www.ofm.wa.gov/sites/default/files/public/dataresearch/pop/april1/ofm_april1_poptrends.pdf">https://www.ofm.wa.gov/sites/default/files/public/dataresearch/pop/april1/ofm_april1_poptrends.pdf</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=caaadaf90c1e" width="1" height="1" alt=""><hr><p><a href="https://medium.com/open-data-literacy/persuading-the-gatekeepers-caaadaf90c1e">Persuading the Gatekeepers</a> was originally published in <a href="https://medium.com/open-data-literacy">Open Data Literacy</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>