Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add more automation to deploying new cities, adding/hiding neighborhoods, etc #3748

Closed
misaugstad opened this issue Nov 21, 2024 · 0 comments · Fixed by #3751
Closed

Add more automation to deploying new cities, adding/hiding neighborhoods, etc #3748

misaugstad opened this issue Nov 21, 2024 · 0 comments · Fixed by #3751

Comments

@misaugstad
Copy link
Member

Brief description of problem/feature

When it comes to deploying new cities and managing the addition/removal of areas of the city, there's quite a bit that can be more automated. I have solid documentation on these processes in pages like this and this. After the manual steps using QGIS, the new city setup process mostly involves copying/pasting SQL queries, changing a few parameters, and then double checking that I didn't make a mistake with my copying/pasting. I think that this could be sped up (and take less mental energy) by automating with a few bash scripts. Here's what I'm thinking:

  1. A script to fill all the tables correctly when creating a schema for a new city (actually finished this yesterday)
  2. A script to take the output from our check_streets_for_imagery.py script and make the appropriate changes to the db, along with a variant that can be run directly on the test/prod dbs
  3. A script to show/hide a set of neighborhoods, along with a variant that can be run directly on the test/prod servers

I updated the documentation in the adding a new city wiki page while I created the script for (1) yesterday, and the page is about 20% shorter now! That was by far the most complicated script, and the other two should be much quicker/easier to make.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: done / on test servers
1 participant