add SQL to update timeseries table with location and booleans; no longer need separate subjob