{"action":"closed","issue":{"url":"https://api.github.com/repos/erdl/database/issues/11","repository_url":"https://api.github.com/repos/erdl/database","labels_url":"https://api.github.com/repos/erdl/database/issues/11/labels{/name}","comments_url":"https://api.github.com/repos/erdl/database/issues/11/comments","events_url":"https://api.github.com/repos/erdl/database/issues/11/events","html_url":"https://github.com/erdl/database/issues/11","id":355362896,"node_id":"MDU6SXNzdWUzNTUzNjI4OTY=","number":11,"title":"HST Timestamp incorrect in DHHL database","user":{"login":"kathrynparadis","id":30536250,"node_id":"MDQ6VXNlcjMwNTM2MjUw","avatar_url":"https://avatars0.githubusercontent.com/u/30536250?v=4","gravatar_id":"","url":"https://api.github.com/users/kathrynparadis","html_url":"https://github.com/kathrynparadis","followers_url":"https://api.github.com/users/kathrynparadis/followers","following_url":"https://api.github.com/users/kathrynparadis/following{/other_user}","gists_url":"https://api.github.com/users/kathrynparadis/gists{/gist_id}","starred_url":"https://api.github.com/users/kathrynparadis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kathrynparadis/subscriptions","organizations_url":"https://api.github.com/users/kathrynparadis/orgs","repos_url":"https://api.github.com/users/kathrynparadis/repos","events_url":"https://api.github.com/users/kathrynparadis/events{/privacy}","received_events_url":"https://api.github.com/users/kathrynparadis/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"kathrynparadis","id":30536250,"node_id":"MDQ6VXNlcjMwNTM2MjUw","avatar_url":"https://avatars0.githubusercontent.com/u/30536250?v=4","gravatar_id":"","url":"https://api.github.com/users/kathrynparadis","html_url":"https://github.com/kathrynparadis","followers_url":"https://api.github.com/users/kathrynparadis/followers","following_url":"https://api.github.com/users/kathrynparadis/following{/other_user}","gists_url":"https://api.github.com/users/kathrynparadis/gists{/gist_id}","starred_url":"https://api.github.com/users/kathrynparadis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kathrynparadis/subscriptions","organizations_url":"https://api.github.com/users/kathrynparadis/orgs","repos_url":"https://api.github.com/users/kathrynparadis/repos","events_url":"https://api.github.com/users/kathrynparadis/events{/privacy}","received_events_url":"https://api.github.com/users/kathrynparadis/received_events","type":"User","site_admin":false},"assignees":[{"login":"kathrynparadis","id":30536250,"node_id":"MDQ6VXNlcjMwNTM2MjUw","avatar_url":"https://avatars0.githubusercontent.com/u/30536250?v=4","gravatar_id":"","url":"https://api.github.com/users/kathrynparadis","html_url":"https://github.com/kathrynparadis","followers_url":"https://api.github.com/users/kathrynparadis/followers","following_url":"https://api.github.com/users/kathrynparadis/following{/other_user}","gists_url":"https://api.github.com/users/kathrynparadis/gists{/gist_id}","starred_url":"https://api.github.com/users/kathrynparadis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kathrynparadis/subscriptions","organizations_url":"https://api.github.com/users/kathrynparadis/orgs","repos_url":"https://api.github.com/users/kathrynparadis/repos","events_url":"https://api.github.com/users/kathrynparadis/events{/privacy}","received_events_url":"https://api.github.com/users/kathrynparadis/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2018-08-29T22:56:09Z","updated_at":"2018-11-02T01:13:30Z","closed_at":"2018-11-02T01:13:30Z","author_association":"MEMBER","body":"All of our Datetime_HST columns in the DHHL database (still need to check on the frogUHM database) are incorrect. \r\n\r\nThe hobo data gets converted to HST timezone by scrap-util when put into the database, but the egauge data does not (egauge comes in as UTC timezone). The Datetime_HST column was our first attempt to put all the timestamps into HST, however we did not consider at the time that hobo data was already in HST timezone. So this original version converted egauge data into HST timezone, but it also pushed the hobo timestamp 10 hours past HST timezone.\r\n\r\nFor the DHHL database, our new code for the Datetime_HST column is as follows (please note that we will have to create a new code for the FrogUHM database if it is also incorrect as 'kw' is the unit of multiple sensors, not just egauge):\r\n`CASE\r\n            WHEN ((reading.unit)::text = 'kw'::text) THEN (((reading.reading_timestamp - '10:00:00'::interval))::timestamp without time zone)::timestamp with time zone\r\n            WHEN ((reading.unit)::text <> 'kw'::text) THEN reading.reading_timestamp\r\n            ELSE NULL::timestamp with time zone\r\n        END AS \"Datetime_HST\"`"}}
{"actor":{"display_login":"kathrynparadis"}}