search

NYCPlanning / db-safegraph

SafeGraph ETL
4 stars 1 forks source link

DCP: special request for inflow table #79

Open daragoldberg opened 3 years ago

daragoldberg commented 3 years ago

Daily Inflow: NYC metropolitan region municipalities --> NYC counties

If possible, using a custom geography crosswalk file that we have built to recode NYC metro region Census Block Groups to municipalities, obtain a count where origin_cbg == regional municipality and destination_cbg == NYC county.

If not possible, for all regional cbgs not inclusive of NYC, obtain a daily count where origin_cbg == regional cbg and destination_cbg == NYC county. We can recode origin cbgs to metro region municipalities.

Thanks!!