The US-RSE Map
This repository contains static files and workflows to generate the US-RSE map.
How does it work?
Latest
We currently ask participants that fill out the form to provide a city, town location if they want to anonymously be included in the map. To minimize needing to use the geolocate API, we still write coordinates to the locations data file. You should not manually update this file as it is done by a script (see below).
June 2020 and Earlier
The map locations are derived from the US-RSE official roster, meaning that the institutions or companies are exported. In the first implementation, institutions were associated with a location by way of the locations lookup and then had matched latitude and longitude coordinates from the (now renamed) locations institutions data.
1. How do I update the map?
You don't! The automated workflow does. The workflow under .github/workflows/update-map.yml handles this for you. To add yourself (if you haven't yet) you can fill out the institution field under the join form.
2. How do update locations?
The locations lookup used to need monthly updating, but we don't use it anymore. Look at older versions of this file under the repository version control to see how this worked.
3. How do we run tests?
Tests are run in a separate workflow at .github/workflows/main.yml. Since a contribution will come down to updating the list of locations, we ensure that the fields and types are represented correctly.
Google Sheet Issues
The script scripts/update_map.py downloads a static export of a Google Sheet, which should be updating to generate a list of locations (cities and states) for generation here. This sheet that is labeled "Locations export for website." The cells are supposed to automatically update since they have been pre-populated with formulas, but in practice it often doesn't automatically populate from the first, despite the formula being there. When this happens:
- You'll see a PR here that is empty. You should close and delete the branch
- You should open up the sheet, and click and drag down the last cell that is populated with a city/state to populate a new chunk of rows, up until the number of entries we have in the first (private) sheet with full informaiton.
- You should glance over the new names and look for spelling errors, or any other formatting issues. You can then go back to the first sheet to fix names. Other than spelling, we always need to change "CA" to "California" because most CA entries will show up somewhere in Canada.
- Once the sheet looks good, you can click the "Actions" tab here to re-run the job.
The pull request should open again, with changes that time, and then you can approve or close and delete and branch and continue tweaking the sheet and running the action until it looks good.
How could it be improved?
For the long term, it might be less error prone to somehow use the Sheets API instead of the interface, or to debug why the sheet doesn't auto-populate with correct data as it should.
