Move content tables from CARTO to the repo as CSV data files

[tomay]

CARTO now has a limit of 10 tables, we currently have 18, and in any case, we need to consider alternate approaches to using CARTO in this project.

A number of content tables are stored in CARTO, alongside the building data and building footprints. These could easily be stored as CSV files in the repository (and managed as shared files in Google Docs, if that's needed)

Citywide Scorecard

Table name: citywide_scorecard_data Last update 5 years ago, and the most recent entry is for 2016. Is this still relevant? There is an entry for this in seattle.json but I am not sure where it is used in the app

Links

Table name: links Definitely needed

FAQ

Table name: faq Definitely needed

Glossary

Table name: glossary Definitely needed

[tomay]

I think that the City Scorecard is no longer offered, but that is a guess at this point. I see a handful of references to a city_scorecard in the code, and city_scorecard.js in src/app/views/scorecards/charts but I don't see anything in the actual app (a button, or a link) where I can click and make a city scorecard.

[tomay]

Download data, then modify code to pull from CSV for the following:

• [x] Links
• [x] FAQ
• [x] Glossary

City Scorecard:

• [x] Download data and save to Drive, with the assumption that this is no longer needed. If necessary, delete references to this in the code

[tomay]

Links, FAQ and Glossary are now working in the application from CSVs served from src/data/

City Scorecard is no longer used.

I've saved copies of these content tables here: https://drive.google.com/drive/folders/15x9wCxh6X4hc18GCnsu2Tw4avdTLv79H?usp=drive_link

If the client wants to edit these in Drive, then we could create Sheets from them in this same location and share. The update process would be different, we'd then have to export to CSV, save to the repo, test and commit.

[tomay]

Latest code is running Links, FAQ and Glossary from CSV saved in /src/data/

Once this is updated to production at the end of this phase, it will be safe to delete those tables on CARTO, but not before