search

CityOfLosAngeles / data-workflows-101

A workshop and training for data workflows that we use at the City.
Apache License 2.0
4 stars 9 forks source link

Generate google sheet with data #11

Open bryanblackford opened 6 years ago

bryanblackford commented 6 years ago

query database for CSV data. import data into google sheet.

sonhtet26 commented 6 years ago

@bryanblackford Will we be syncing multiple databases? In addition, what transformations will be made on the data before the google sheet is generated, and where will the google sheet be used?

bryanblackford commented 6 years ago

@sonhtet26 initially only 1 database (street sweeping data) but more maybe in the future. the data should be minimally cleaned up (extra whitespace, format date fields, etc). google sheet will be used internally.