to update the observation table, a couple fields still have bugs I need to work out