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:
A script to fill all the tables correctly when creating a schema for a new city (actually finished this yesterday)
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
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.
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:
check_streets_for_imagery.pyscript and make the appropriate changes to the db, along with a variant that can be run directly on the test/prod dbsI 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.