A sortable list & map of women in open access/source/scholarship: https://fyoaw.vickysteeves.com
A list of women leaders in openness! This website contains a searchable, sortable list of women who do work in the field of openness: open access, open science, open scholarship, open source code, open data, open education resources -- anything open. There is also a map available for folks who would like to look for women leaders nearest them -- the hope is that this map makes planning conferences, workshops, and events more convenient. The data comes from April Hathcock's Google Doc and merge requests to this repository.
You can view this website locally once you've cloned this repository by just double clicking the
index.html file and navigating around. However, you won't be able to see the map this way. I used Python to start up a local server to see the map along with the rest of the website. You can download Python for free here.
Here's how to get started via the command line:
Open up an Internet browser, and go to
localhost:8000. You should now be able to see and interact with the website, including the map, locally!
To start, I grab data from April Hathcock's Google Doc which contains a crowd-sourced list of women who work in openness, and throw it into a separate Google sheet. Google Sheets provides some basic functionality I use to get the right data in the right columns, such as splitting columns on different values (Data > Split text to columns), such as commas. There is some manual clean up required after this to make sure everything fits into the 3 desired columns (at this point), 'Name', 'Twitter Handles', and 'Affiliation'.
When that's finished, I download the data as a
.csv file. I then start up OpenRefine to geocode people based on their institutional affiliation. I used the steps from OpenRefine's Geocoding wiki to do so, specifically the "Fetching" and "Parsing" functions.
Basically, in OpenRefine, I click the dropdown menu from the "Affiliation" column, and select Edit Column > Add Column by Fetching URLs. In the text box, I input the formula:
http://maps.google.com/maps/api/geocode/json?sensor=false&address=" + escape(value, "url"). I name the new column to be created "geo" or something of that ilk, and hit ok. Depending on how much data is there (I don't do the whole spreadsheet everytime, just incremementally as new data comes in), it could take a while. It's also subject to Google Maps rate limiting, so if you have a ton of data, it will take a long while.
After it's finished, there's a new column called "geo" with a ton of JSON. Select Edit Column > Add Column based on This Column and input this formula in the text box:
with(value.parseJson().results.geometry.location, pair, pair.lat +", " + pair.lng). I name the new column "latlog" since it'll contain both values, separated by a comma. This will generate a new column with just the lat/long values.
Once that's finished, you can Edit Column > Split Into Several Columns, and then accept the defaults (it splits on a comma). I then have two columns, latlong and latlong(1). I rename those to "lat" and "long" and delete the "geo" and "latlong" columns that still exist. The only remaining columns I have at that point are 'Name', 'Twitter Handles', 'Affiliation', 'Lat', and 'Long'. I export that as a
.csv and put it into
I built the website using Bootstrap, the open source toolkit for developing with HTML, CSS, and JS. I modified the Flat theme from Bootswatch for the website's look. All customizations are available in
The code to render the searchable, sortable table on the home page was adapted from 'CSV to HTML table' by Derek Eder, available here: https://github.com/derekeder/csv-to-html-table. I also modified the CSS , found in
I am also using the JQuery, which leaflet and other libraries depend on. I am just using the default, found in the
js/leaflet/ file folder, which was downloaded as is from the website. The actual script to build the map is at the bottom
map.html and also here:
In this case, I am using the same
.csv file to build the searchable table on the home page and the map by including all the data there. This script loops through the CSV, looks for any information that would go in the popup (row = Name, row = Twitter Handle, row=Affiliation) and places the marker on the map based on the lat (row) and long (row) on the sheet.
I am also using GitLab for version control, building the site (using the native Continuous Integration), and serving the website. To do this via GitLab, I need to add a
.gitlab-ci.yml file to my repository (here), which looks like this:
This builds the website in two stages: test and deploy. During the "test" phase, GitLab deploys a script
checkcsv.py (found here in the repo) to basically check I didn't mess up the CSV when I updated it. If that passes, then it'll go onto the "deploy" phase. This actually builds and serves the website to the public.
If you'd like to contribute, that would be amazing! I will try my best to be on top of merge requests and issues. If you aren't comfortable with coding or git, you can email me (vicky dot steeves at nyu dot edu) changes you'd like to see and I will open an issue for you or, if it's quick enough, make the change and give you attribution on this README.
Pease follow the Contributor Covenant in all your interactions with the project. If you would like to contribute to this project by modifying/adding to the code or data, please feel free to follow the standard GitLab workflow:
git clone https://gitlab.com/<USERNAME>/Women-Leaders-Openness.git
git remote add upstream https://@gitlab.com:VickySteeves/Women-Leaders-Openness.git
git checkout -b my-feature-branch-name
git add <FILE-NAMES>
git commit -m "A descriptive commit message"
git fetch upstream
git merge upstream/master
git push origin my-feature-branch-name
Before you start coding, open an issue so that the community can discuss your change to ensure it is in line with the goals of the project and not being worked on by someone else. This allows for discussion and fine tuning of your feature and results in a more succent and focused additions.
Merge Requests are eventually merged into the codebase. Please ensure they are:
If your code is untested, log heavy, or incomplete, you can use GitLab's Work In Progress (WIP) feature on your merge request so others know it is still being tested and shouldn't be considered for merging yet. This way we can still give you feedback or help finalize the feature even if it's not ready for prime time.
That's it! Thanks for your contribution!
You are welcome to email me at vicky dot steeves at nyu dot edu if you have questions or concerns, or raise an issue on this repository and I will do my best to respond quickly!