ProjectSidewalk / SidewalkWebpage

Project Sidewalk web page
http://projectsidewalk.org
MIT License
80 stars 23 forks source link

Import validations from ASSETS dataset into our dbs #3583

Open misaugstad opened 2 days ago

misaugstad commented 2 days ago
Brief description of problem/feature

As part of our upcoming ASSETS submission, @hoominchu, @kevinjtwu @JeremyFreiburger, and others validated thousands of labels (including their tags). We need to get these validations loaded into our db so that everyone can benefit from those contributions!

Potential solution(s)

Some steps that need to happen:

  1. Make sure that everyone who validated has an account created in every city where they validated so that we can credit their accounts with their contributions! Most (if not all) of these have already been created, because they were using admin tools on those servers to spot check.
  2. Get the final CSVs with the validations from @hoominchu. Sounds like there are a final few validations trickling in, so have to wait a little bit (won't have time to do this before I go to Europe next week anyway)
  3. Write a Python script to take in those CSVs, connect to the db, and make the updates in the same way that we do it in Scala when a validation is added through the new Validate page. And alternative could be to create an API endpoint that handles this stuff in Scala, and the Python script could instead use that API. I think that this is likely less error-prone, but also sounds more annoying to me :)