Load historical data into BigQuery

[mimming]

Load up the historical data, currently living in that big file in Google Cloud Storage

• define the schema
• Scrub the data
  • unify timestamps
  • environment
    • accelerometer -> camera
    • temperature (without accelerometer) -> computer
  • weather
    • this one is pretty clean
• Check the schemas into here (in case we need to recreate tables later)
• Get it into BigQuery

[mimming]

A lot of it is up at https://bigquery.cloud.google.com/dataset/panoptes-survey:unit_sensors

but, the schema of the old data does not match the new data, and about 200k of the weather records didn't load.

I'll take another swing at getting all the data loaded, and into the same schema (so we can do big aggregate queries across all the data)