Course:ARST 556L/LIBR 514L Metadata Topics/Metadata Processing/Town FNS OpenRefine Project
[Project Title] | |
---|---|
[Student Name] | |
Semester: | |
Instructor: | |
Metadata Topic(s) | |
Summary
This project was a metadata processing exercise on behalf of the First Nations Summit. The FNS provided me with a sample dataset (Excel spreadsheet
Purpose/Goal
The goal of this project was twofold: to clean the provided dataset according to the instructions provided using OpenRefine as a proof-of-concept that others, like future students, could perform similar work in the future, and to write a tutorial/report of which operations I performed to accomplish this.
I was successful: I addressed every stated field need using OpenRefine functionality, returned a cleaned dataset, and wrote a comprehensive report detailing which actions I performed for which fields and broke down data of concern.
Lessons Learned
I learned more about how to use OpenRefine to accomplish specific transformations to data. Specifically, I learned more about how to use different expression/programming languages like General Refine Expression Language, Python, and Regular Expressions to accomplish these goals. Having used OpenRefine software before this project and taking an introductory Python Programming course while taking this class, I felt I was well-equipped for this project at the outset. However, one thing that might have helped is more discussion with the person who gave me this data and gotten to know more about the context that the data was generated within.
Metadata Network
[Please add your project to the class-wide navigation box linked below. Find where your project should go in the table below and note the name of the row and which column number it will be. For example, for the Class Wiki, it's in the Metadata Topics table, in the Design row, and it's in the third column.
In a new tab, go to the table's page and click "Wikitext." Every box in the table has its own row, delineated by an | or !. Find the row title in the source editor - the line it's on is the equivalent of the first column. Navigate to the line that corresponds with the column where your project should go and add a link to your project on that line. For example, without the spaces between the link and the square brackets and with double square brackets on each end instead of singular:
[Course:ARST_556L/LIBR_514L/Metadata_Design/Class_Wiki|Class_Wiki]
The above link includes "|Class_Wiki" at the end of the link as the display text for the link.]
Topic | Subtopic | Student Projects | Subtopic | Student Projects | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Types | Administrative | Preservation | ||||||||||
Technical | ||||||||||||
Descriptive | ||||||||||||
Use | ||||||||||||
Vocabularies* | See Metadata Options Table (below) | |||||||||||
Design | Class_Wiki | |||||||||||
Collection | ||||||||||||
Processing | Town_FNS_OpenRefine_Project |
Types of Options | Option | Student Projects | Suboption | Student Projects | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Applications | OHMS | ||||||||||
Oxygen XML Editor | |||||||||||
Saxon | |||||||||||
Voyager | |||||||||||
Controlled Vocabularies* | AAT | ||||||||||
CONA | |||||||||||
Homosaurus | |||||||||||
IA | |||||||||||
LCDGT | |||||||||||
LCGFT | |||||||||||
LCNAF | |||||||||||
LCSH | |||||||||||
TGN | |||||||||||
ULAN | |||||||||||
VGMS_Visual_Style | |||||||||||
VIAF | |||||||||||
Identifiers | DOI | ||||||||||
ISBN | |||||||||||
ISNI | |||||||||||
LCCN | |||||||||||
ORCID | |||||||||||
Languages | SPARQL | ||||||||||
SQL | |||||||||||
XML | DTD | ||||||||||
XQuery | |||||||||||
XSLT | |||||||||||
Platforms | Fedora | ||||||||||
Resources | BIBCO | ||||||||||
CONSER | |||||||||||
NACO | |||||||||||
PCC-LOC | |||||||||||
SACO | |||||||||||
Schemas | BIBFRAME | ||||||||||
DCMI | |||||||||||
FRBR | |||||||||||
JATS | |||||||||||
MARC | |||||||||||
MODS | |||||||||||
XSD | |||||||||||
Standards | AACR2 | ||||||||||
EAC-CPF | |||||||||||
EAD | |||||||||||
METS | |||||||||||
MIME | |||||||||||
OpenURL | |||||||||||
PREMIS | |||||||||||
RDA | |||||||||||
RDF | |||||||||||
VRA Core | |||||||||||
Systems | DDI | ||||||||||
Hyacinth | |||||||||||
LibraryWorld | |||||||||||
OAI-PMH | |||||||||||
OCLC Connexion | |||||||||||
RIMS | |||||||||||
Worldox | |||||||||||
Other | Linked Data | ||||||||||
PubMed |