use and move SCA sql scripts from sharepoint/carto to repo build process - Githubissues

NYCPlanning / db-knownprojects

KPDB: A compilation of prospective residential development projects from various sources, with rough projections of new unit counts

https://nycplanning.github.io/db-knownprojects

0 stars 0 forks source link

use and move SCA sql scripts from sharepoint/carto to repo build process #399

Closed damonmcc closed 1 year ago

damonmcc commented 1 year ago

motivations

after building KPDB, we must run SQL scripts to aggregate data for SCA (School Construction Authority)
aside from urgent need to produce outputs, we'd like to move this step into the KPDB build process
Capital Planning's OneNote doc with details
Data Egnineering's Sharepoint folder with SCA sql scripts

todos

[x] use existing scripts and process to produce outputs
- [x] upload KPDB outputs to carto (Max)
- [x] run script 5a (Max)
- [x] run script 5c (Finn)
- [x] run script 5d (Damon)
[x] Add scripts to KPDB repo
[x] review and share outputs
[x] scope work of moving this step into the KPDB build process