search

galterlibrary / digital-repository

DigitalHub - Institutional Repository for Galter Health Sciences
https://digitalhub.northwestern.edu/
5 stars 1 forks source link

Export Metadata Subfield Locations #804

Closed Meowcenary closed 3 years ago

Meowcenary commented 3 years ago

Export the Metadata subfield Locations

Meowcenary commented 3 years ago

I noticed this is an optional field so I'm going to run a query on DigitalHub to search for all the records that have ANY sort of location information. There seems to be three fields for this: latitude, longitude, and based_near. The based_near fields seems kind of ambiguous to me, but probably works for place as described by the IRDM documenation: "place (0-1) - free text, used to describe a geographical location."

Edit: I wrote a small script that's running now. It's going to read the desired values into a CSV which I'll copy down after meeting with Matt.

Meowcenary commented 3 years ago

Github does not support CSVs for upload, so I guess this will have to do for now. I'll check to see if the listed values qualify as "places" for the metadata and if so add that to the existing export work. There is thankfully no latitude/longitude coordinates so we do not have to worry about that at all.

Edit: Had to clean up the CSV so that ruby could read it easily. The cleaned data is below. D-d-d-double edit: Checked with Guillaume on this and we can just drop in the strings directly as this is free text. 

latitude,longitude,based_near,secondary_based_near
,,"Cambridge, Massachusetts, United States"
,,"San Francisco, California, United States"
,,"Austin, Texas, United States"
,,"Chicago, Illinois, United States"
,,'Boston, Massachusetts, United States', 'East Peoria, Illinois, United States'
,,"Indianapolis, Indiana, United States"
,,"Honolulu, Hawaii, United States"
,,"Portland, Oregon, United States"
,,"Dublin, Ohio, United States"
,,"Buffalo, New York, United States"
,,"Tucson, Arizona, United States"
,,"Austin, Texas, United States"
,,"Charleston, South Carolina, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Philadelphia, Pennsylvania, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Austin, Texas, United States"
,,"Cambridge, Massachusetts, United States"
,,"Chicago, Illinois, United States"
,,"Seattle, Washington, United States"
,,"Bethesda, Maryland, United States"
,,"Chicago, Illinois, United States"
,,"Orlando, Florida, United States"
,,"Jilin City, Jilin Sheng, China"
,,"Austin, Texas, United States"
,,"Toronto, Ontario, Canada"
,,"Portland, Oregon, United States"
,,"Toronto, Ontario, Canada"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Durham, North Carolina, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Bethesda, Maryland, United States"
,,"Charleston, South Carolina, United States"
,,"University Park, Illinois, United States"
,,"Austin, Texas, United States"
,,"Chicago, Illinois, United States"
,,"Dominican University, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Seattle, Washington, United States"
,,"Chicago, Illinois, United States"
,,"San Francisco, California, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Boston, Massachusetts, United States"
,,"Chicago, Illinois, United States"
,,"Atlanta, Georgia, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Atlanta, Georgia, United States"
,,"Chicago, Illinois, United States"
,,'Rockford, Illinois, United States', 'Bethesda, Maryland, United States'
,,"Cleveland, Ohio, United States"
,,"Atlanta, Georgia, United States"
,,"Porto, Porto, Portugal"
,,"Chicago, Illinois, United States"
,,"Rockford, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Northwestern Memorial Hospital, Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Indianapolis, Indiana, United States"
,,"Chicago, Illinois, United States"
,,"Brown University, Rhode Island, United States"
,,"Nashville, Tennessee, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Dublin, Leinster, Ireland"
,,"Prentice Women's Hospital"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Chicago, Illinois, United States"
,,"Los Angeles, California, United States"
,,"Los Angeles, California, United States"
,,"Los Angeles, California, United States"
,,"Los Angeles, California, United States"