NYCPlanning / labs-community-profiles

A site for exploring indicators, data, and information for NYC community districts
https://communityprofiles.planning.nyc.gov/
Other
52 stars 9 forks source link

Update MH CB 7 contact info and sync data in digital ocean and Carto #721

Open TylerMatteo opened 2 months ago

TylerMatteo commented 2 months ago

We received a request to update the contact email info for MH CB 7 MN07@cb.nyc.gov. This data is meant to be maintained by the code in the db-community-profiles repo but we do update manually now because that repo is not longer used for automations.

The emails for CBs shows up in two places in the CD Profiles app:

  1. In the email link, which gets the email address from the community_district_profiles_v202402 table in Carto

Image

  1. In the CB info CSV available for download

Image

That CSV is tracked in GH here - this file was originally intended to be built with automations but we'll have to just update it manually. That file is then uploaded to digital ocean, which is where the app downloads it from (cd_administrative.csv):

Image

Here are steps to complete that will update the contact info and make sure other recent changes are reflected in both the data coming from Carto and the downloadable CSV, while also keeping the db-community-profiles repo as something approaching a source of truth: