I worked part-time for the University of Michigan Herbarium designing a website for over 60000 specimen (birds, mammals, herbs and insects). I had to write python scripts to clean up their excel sheets, use BOX API to access their images, and Google Maps API to display maps.
Clean manually entered data in excel sheets and put them into one database, link to images on Box and create a website to access over 60000 specimen.
Year: 2016
Duration: 4 months
I created python scripts to clean manually entered excel sheets, linked to photos on Box using Box API, used Google Maps API to get latitude longitude of collection location and set up a new Drupal site to showcase their collection of 60000 specimens (mammals, herbs, insects and birds).
I've installed Drupal modules like google maps, search API, and faceted results.
For interactivity, I've added a sticky menu on the Michigan Geological Surveys page, faceted search results, horizontal scroll of images of highlighted specimens, back to top button, alphabetized browse by feature and full screen overlay view of images.
https://nsf-biomuseums.eeb.lsa.umich.edu/
I wrote documentation for maintenance of the site, as well as, provided scripts to be used for importing more content in the future.
