User:1920wr/sandbox

Call details

 * Date: 2019-10-22
 * Topic: Finding GLAMs: Reconciling and Adding Institutions to Wikidata using OpenRefine
 * Presenters: Hilary Thorsen, Wikimedian in Residence, Linked Data for Projection project

Presentation materials

 * Recording
 * Slides

Demo of reconciling a spreadsheet of data about institutions and adding it to Wikidata using OpenRefine

 * Slides - starting at Slide 16
 * Today using OpenRefine for reconciliation and uploading to Wikidata
 * Wikidata editing with OpenRefine
 * OpenRefine Google Group
 * OpenRefine User manual
 * Not focusing on data cleaning today, just reconciliation against Wikidata schema, and uploading
 * Original dataset of Metropolitan New York Library Council members, can download CSV at bottom
 * Data prep
 * Instance of - for a library that was of more than one type, added a second Instance of field
 * Address fields (street address, city, state, zip) were concatenated into a single field
 * Phone numbers and emails came from the official websites of the institutions
 * Reconciling
 * Drop-down next to a column to Reconcile, against Wikidata
 * Better luck reconciling against “No particular type”
 * If you have additional properties to help with a match, you can include those as well
 * Can select to auto-match if high confidence.
 * Then manually match suggested - you can hover over the blue link to pull up a mini info-box to see if it’s the right match (shows description, and image if available)
 * You can search for a match in case there are alternative spellings or typos
 * Tell it to “create new item” for GLAM records you’re creating
 * No need to reconcile free text (address, website, phone number, email, reference link, etc.)
 * Continue column by column to match
 * [OpenRefine can undo/redo, which is handy if you make mistakes]
 * Schema
 * Extensions, Wikidata, Edit Wikidata Schema
 * Type or drag reconciled columns to the appropriate place to build the schema
 * Add references, then you can copy and paste references to save time
 * If you have a larger set of fields that you don’t want to upload, you can just ignore the fields when building the schema
 * Look at the Issues tab to review any problems -- you’ll always be warned that you’re creating new items
 * Look at the Preview tab to be sure things look correct before uploading
 * When adding values (and references) to existing items,
 * Uploading
 * “Upload to Wikidata”, and you’ll need to log in with your Wikidata account (must be an autoconfirmed user first)
 * Add Edit Summary and click Upload Edits!
 * Review results!
 * Submitting for Bot Review
 * Request permission on Requests for permissions/Bot
 * Adding Open Street Maps (OSM) entries to Wikidata?
 * See also: Wikidata:OpenStreetMap
 * Tools:
 * EdwardBetts GitHub - osm-wikidata
 * osm wikidata matcher