no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
— | project:annemarie_schwarzenbach_photo_collection [2017/09/18 13:52] (current) – created lheiz | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ===== Photo Collection Annemarie Schwarzenbach ===== | ||
+ | |||
+ | Metadata comes in form of a csv file, the images are available in a zip, but they are also published on wikidata. Wikidata links are provided in the csv, though they were faulty and needed some correcting (url encoding, repalcing «/» with «-»). | ||
+ | Places or geocoordinates are not available in the csv, even though there is a column named «Ort» («places»), | ||
+ | |||
+ | ==== Project ==== | ||
+ | The Project was actually more of a side-project for some people in the rilke-jung correspondence network group during the openGLAM Hackathon in september 2017 at UNIL. | ||
+ | There is a [[http:// | ||
+ | The goal of the project was to geolocate as many images as possible, and test out different tools to visualize them on a map. | ||
+ | As mentioned above, the information in the column «Ort» in the csv is sparse. However, in the title oftentimes a placename is included, in the form «country, city, description». So the first step was to extract this information. This was done in // | ||
+ | After finishhing reconciling, | ||
+ | cell.recon.candidates[0].id | ||
+ | Getting the coordinates proved more diffcult than expected. The quick and dirty solution applied was to fetch the entire wikidata pages | ||
+ | " | ||
+ | then splitting at " | ||
+ | So we tried another aproach. Adding a column to the column with the reconciled places using this command | ||
+ | " | ||
+ | (where P625 are coordinates in wikidata), created a column with the correct coordinates. | ||
+ | |||
+ | When trying to visualize the images on a map, we ran into the problem that the wikidata links provided in the csv pointed to the entry for the image, not the acutal image itself. This could be resolved by searching and replacing File: with Special: | ||
+ | value.replace(" | ||
+ | |||
+ | Different tools were viewed and tested to display the 3500 images. | ||
+ | |||
+ | ==== Tools ==== | ||
+ | * Openrefine was used to clean the data, and to enrich it by reconciling with wikidata. | ||
+ | * Palladio allowed to show points on a map, and different styles of graphs. Links to the images on wikidata directly visualized on the map are not possible. There is a gallery view where the images can be displayes. Palladio projects need to be exported as a json, can not be included directly to publish. | ||
+ | * Viseyes seems to have problems with datasets of more than a few hundred entries. For smaller datasets, it provides a nice view with a map, a timeline and a «story» column. | ||
+ | |||
+ | ===== Data ===== | ||
+ | |||
+ | * https:// | ||
+ | |||
+ | ===== Team ===== | ||
+ | |||
+ | * Lena Heizmann | ||
+ | * Dominik Sievi | ||
+ | | ||
+ | {{tag> | ||