{"action":"created","issue":{"url":"https://api.github.com/repos/agrc/ugs-db/issues/24","labels_url":"https://api.github.com/repos/agrc/ugs-db/issues/24/labels{/name}","comments_url":"https://api.github.com/repos/agrc/ugs-db/issues/24/comments","events_url":"https://api.github.com/repos/agrc/ugs-db/issues/24/events","html_url":"https://github.com/agrc/ugs-db/pull/24","id":102256615,"number":24,"title":"Normalize stationtype","user":{"login":"stdavis","id":1326248,"avatar_url":"https://avatars.githubusercontent.com/u/1326248?v=3","gravatar_id":"","url":"https://api.github.com/users/stdavis","html_url":"https://github.com/stdavis","followers_url":"https://api.github.com/users/stdavis/followers","following_url":"https://api.github.com/users/stdavis/following{/other_user}","gists_url":"https://api.github.com/users/stdavis/gists{/gist_id}","starred_url":"https://api.github.com/users/stdavis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stdavis/subscriptions","organizations_url":"https://api.github.com/users/stdavis/orgs","repos_url":"https://api.github.com/users/stdavis/repos","events_url":"https://api.github.com/users/stdavis/events{/privacy}","received_events_url":"https://api.github.com/users/stdavis/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-08-20T22:55:36Z","updated_at":"2015-08-21T22:04:26Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/agrc/ugs-db/pulls/24","html_url":"https://github.com/agrc/ugs-db/pull/24","diff_url":"https://github.com/agrc/ugs-db/pull/24.diff","patch_url":"https://github.com/agrc/ugs-db/pull/24.patch"},"body":"I believe that this closes #5 in addition to #12."},"comment":{"url":"https://api.github.com/repos/agrc/ugs-db/issues/comments/133576501","html_url":"https://github.com/agrc/ugs-db/pull/24#issuecomment-133576501","issue_url":"https://api.github.com/repos/agrc/ugs-db/issues/24","id":133576501,"user":{"login":"stdavis","id":1326248,"avatar_url":"https://avatars.githubusercontent.com/u/1326248?v=3","gravatar_id":"","url":"https://api.github.com/users/stdavis","html_url":"https://github.com/stdavis","followers_url":"https://api.github.com/users/stdavis/followers","following_url":"https://api.github.com/users/stdavis/following{/other_user}","gists_url":"https://api.github.com/users/stdavis/gists{/gist_id}","starred_url":"https://api.github.com/users/stdavis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stdavis/subscriptions","organizations_url":"https://api.github.com/users/stdavis/orgs","repos_url":"https://api.github.com/users/stdavis/repos","events_url":"https://api.github.com/users/stdavis/events{/privacy}","received_events_url":"https://api.github.com/users/stdavis/received_events","type":"User","site_admin":false},"created_at":"2015-08-21T22:04:26Z","updated_at":"2015-08-21T22:04:26Z","body":"We also may want to think about deleting `temp.sqlite3` in between loading each csv file. Mine is already up to 1GB after loading stations and three result files."}}