{"action":"created","issue":{"url":"https://api.github.com/repos/impactlab/caltrack-betatest/issues/9","repository_url":"https://api.github.com/repos/impactlab/caltrack-betatest","labels_url":"https://api.github.com/repos/impactlab/caltrack-betatest/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/impactlab/caltrack-betatest/issues/9/comments","events_url":"https://api.github.com/repos/impactlab/caltrack-betatest/issues/9/events","html_url":"https://github.com/impactlab/caltrack-betatest/issues/9","id":177294056,"number":9,"title":"Should we have separate project tables for electric and gas?","user":{"login":"houghb","id":12754861,"avatar_url":"https://avatars.githubusercontent.com/u/12754861?v=3","gravatar_id":"","url":"https://api.github.com/users/houghb","html_url":"https://github.com/houghb","followers_url":"https://api.github.com/users/houghb/followers","following_url":"https://api.github.com/users/houghb/following{/other_user}","gists_url":"https://api.github.com/users/houghb/gists{/gist_id}","starred_url":"https://api.github.com/users/houghb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/houghb/subscriptions","organizations_url":"https://api.github.com/users/houghb/orgs","repos_url":"https://api.github.com/users/houghb/repos","events_url":"https://api.github.com/users/houghb/events{/privacy}","received_events_url":"https://api.github.com/users/houghb/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-09-15T21:25:48Z","updated_at":"2016-09-21T14:29:53Z","closed_at":null,"body":"For the deduplication requirement we need to use either `Electric Service ID` or `Gas Service ID` as the key to group duplicates.  Whichever we choose, there are many rows where the opposite ID is empty (homes where there is either only electric service but no gas, or only gas but no electric) leading to many projects are merged into a single row. There are also many rows with multiple values of the opposite ID (for example, for a single `Electric Service ID` there can be multiple `Gas Service ID`s associated with it). Both of these lead to problems later if we need to associate a project with usage data.\r\n\r\nShould we create two project tables (\"electric_project_table\" and \"gas_project_table\") to address this issue, and thus add an additional file to the Prepared Data Summary Statistics?"},"comment":{"url":"https://api.github.com/repos/impactlab/caltrack-betatest/issues/comments/248629825","html_url":"https://github.com/impactlab/caltrack-betatest/issues/9#issuecomment-248629825","issue_url":"https://api.github.com/repos/impactlab/caltrack-betatest/issues/9","id":248629825,"user":{"login":"houghb","id":12754861,"avatar_url":"https://avatars.githubusercontent.com/u/12754861?v=3","gravatar_id":"","url":"https://api.github.com/users/houghb","html_url":"https://github.com/houghb","followers_url":"https://api.github.com/users/houghb/followers","following_url":"https://api.github.com/users/houghb/following{/other_user}","gists_url":"https://api.github.com/users/houghb/gists{/gist_id}","starred_url":"https://api.github.com/users/houghb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/houghb/subscriptions","organizations_url":"https://api.github.com/users/houghb/orgs","repos_url":"https://api.github.com/users/houghb/repos","events_url":"https://api.github.com/users/houghb/events{/privacy}","received_events_url":"https://api.github.com/users/houghb/received_events","type":"User","site_admin":false},"created_at":"2016-09-21T14:29:53Z","updated_at":"2016-09-21T14:29:53Z","body":"@matthewgee I probably won't have a chance to redo this to split the table into separate electric/gas lists (and adjust the rest of our cleaning/integration pipeline accordingly) before tomorrows meeting.  The solution I came up with (adding SPID to the projects table) worked well for us and has the added benefit of cleaning out projects for which we don't have cross reference information.  If you decide to make separate electric/gas tables we can see how the different approaches compare."}}
{"actor":{"display_login":"houghb"}}