search

NYC-Parks / consolidation_crowds_data_Archive

Consolidation of Social Distancing Data Consolidation
1 stars 0 forks source link

Need to add borough to webmerc_centroids sheet #5

Closed SVisovsky-NYCDPR closed 4 years ago

SVisovsky-NYCDPR commented 4 years ago

Because we're not using a unique ID in the questions on the google form, but we do have borough in the combined sheet, I need to add borough (full name, not abbreviation) to the webmerc_centroids sheet. Any problems with that?

Not having this means things like St. Mary's Park (Brooklyn) gets confused with St. Mary's Park (Bronx) in Tableau because currently they're only joining on name. I can add it myself, but I don't want to mess up what @GeoDan87 is doing without advanced notice.

GeoDan87 commented 4 years ago

@SVisovsky-NYCDPR that should be fine! Thanks for the heads up!

GeoDan87 commented 4 years ago

@GeoDan87 need to add this in the python scripts and in the SQL table.

SVisovsky-NYCDPR commented 4 years ago

Should I add it to the google sheet or will that break things?

GeoDan87 commented 4 years ago

It should be okay

SVisovsky-NYCDPR commented 4 years ago

Done.