{"action":"created","issue":{"url":"https://api.github.com/repos/WikiWatershed/model-my-watershed/issues/2548","repository_url":"https://api.github.com/repos/WikiWatershed/model-my-watershed","labels_url":"https://api.github.com/repos/WikiWatershed/model-my-watershed/issues/2548/labels{/name}","comments_url":"https://api.github.com/repos/WikiWatershed/model-my-watershed/issues/2548/comments","events_url":"https://api.github.com/repos/WikiWatershed/model-my-watershed/issues/2548/events","html_url":"https://github.com/WikiWatershed/model-my-watershed/pull/2548","id":279132479,"number":2548,"title":"Add NHDPlus Catchments to DB setup script","user":{"login":"arottersman","id":7633670,"avatar_url":"https://avatars3.githubusercontent.com/u/7633670?v=4","gravatar_id":"","url":"https://api.github.com/users/arottersman","html_url":"https://github.com/arottersman","followers_url":"https://api.github.com/users/arottersman/followers","following_url":"https://api.github.com/users/arottersman/following{/other_user}","gists_url":"https://api.github.com/users/arottersman/gists{/gist_id}","starred_url":"https://api.github.com/users/arottersman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arottersman/subscriptions","organizations_url":"https://api.github.com/users/arottersman/orgs","repos_url":"https://api.github.com/users/arottersman/repos","events_url":"https://api.github.com/users/arottersman/events{/privacy}","received_events_url":"https://api.github.com/users/arottersman/received_events","type":"User","site_admin":false},"labels":[{"id":194213367,"url":"https://api.github.com/repos/WikiWatershed/model-my-watershed/labels/in%20progress","name":"in progress","color":"ededed","default":false}],"state":"open","locked":false,"assignee":{"login":"rajadain","id":1430060,"avatar_url":"https://avatars1.githubusercontent.com/u/1430060?v=4","gravatar_id":"","url":"https://api.github.com/users/rajadain","html_url":"https://github.com/rajadain","followers_url":"https://api.github.com/users/rajadain/followers","following_url":"https://api.github.com/users/rajadain/following{/other_user}","gists_url":"https://api.github.com/users/rajadain/gists{/gist_id}","starred_url":"https://api.github.com/users/rajadain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rajadain/subscriptions","organizations_url":"https://api.github.com/users/rajadain/orgs","repos_url":"https://api.github.com/users/rajadain/repos","events_url":"https://api.github.com/users/rajadain/events{/privacy}","received_events_url":"https://api.github.com/users/rajadain/received_events","type":"User","site_admin":false},"assignees":[{"login":"rajadain","id":1430060,"avatar_url":"https://avatars1.githubusercontent.com/u/1430060?v=4","gravatar_id":"","url":"https://api.github.com/users/rajadain","html_url":"https://github.com/rajadain","followers_url":"https://api.github.com/users/rajadain/followers","following_url":"https://api.github.com/users/rajadain/following{/other_user}","gists_url":"https://api.github.com/users/rajadain/gists{/gist_id}","starred_url":"https://api.github.com/users/rajadain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rajadain/subscriptions","organizations_url":"https://api.github.com/users/rajadain/orgs","repos_url":"https://api.github.com/users/rajadain/repos","events_url":"https://api.github.com/users/rajadain/events{/privacy}","received_events_url":"https://api.github.com/users/rajadain/received_events","type":"User","site_admin":false}],"milestone":null,"comments":5,"created_at":"2017-12-04T20:12:25Z","updated_at":"2017-12-12T16:47:02Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/WikiWatershed/model-my-watershed/pulls/2548","html_url":"https://github.com/WikiWatershed/model-my-watershed/pull/2548","diff_url":"https://github.com/WikiWatershed/model-my-watershed/pull/2548.diff","patch_url":"https://github.com/WikiWatershed/model-my-watershed/pull/2548.patch"},"body":"## Overview\r\n\r\n  We received a dump of the NHDPlus catchment data\r\n  from stroud. We'll be using it to display catchment\r\n  boundaries in mapshed subbasin-mode.\r\n\r\n  The dump did not include a step to create the\r\n  table, so I created the table on my instance,\r\n  then created a new dump with it. ~I also dropped\r\n  two columns that we won't be using:\r\n `geom_catch_centroid`, and `geom_stream`~ (added these back in)\r\n\r\n  There are `2,647,454` rows. The `comid` column\r\n  relates to `nhdflowlines`, though there are no\r\n  catchments for flowlines of certain `fcodes`,\r\n  for example `ArtificialPath`s, `CanalDitch`s, etc,\r\n  (entries [here](https://nhd.usgs.gov/userGuide/Robohelpfiles/NHD_User_Guide/Feature_Catalog/Hydrography_Dataset/Complete_FCode_List.htm) that are described as having \"no\r\n  attributes\")\r\n\r\n\r\nConnects #2522\r\n\r\n### Demo\r\n\r\nA catchment with its flowline (red) associated by `comid` in wisconsin\r\n\r\n![screen shot 2017-12-06 at 1 17 41 pm](https://user-images.githubusercontent.com/7633670/33677782-e5fc7d86-da87-11e7-87d4-ebf72ac578a7.png)\r\n\r\n\r\n## Notes\r\nI added a new `setupdb.sh` flag `-c`. The existing `-q` flag is related (water **q**uality data exists at the catchment level), but I think it will someday be dropped in favor of the dynamically modeled results. \r\n\r\n## Testing Instructions\r\nLoad the table, then in the `dbshell`, confirm there are `2647454` rows.\r\n\r\n```sh\r\nvagrant ssh app -c 'cd /vagrant && ./scripts/aws/setupdb.sh -c'\r\n```\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/WikiWatershed/model-my-watershed/issues/comments/351111175","html_url":"https://github.com/WikiWatershed/model-my-watershed/pull/2548#issuecomment-351111175","issue_url":"https://api.github.com/repos/WikiWatershed/model-my-watershed/issues/2548","id":351111175,"user":{"login":"arottersman","id":7633670,"avatar_url":"https://avatars3.githubusercontent.com/u/7633670?v=4","gravatar_id":"","url":"https://api.github.com/users/arottersman","html_url":"https://github.com/arottersman","followers_url":"https://api.github.com/users/arottersman/followers","following_url":"https://api.github.com/users/arottersman/following{/other_user}","gists_url":"https://api.github.com/users/arottersman/gists{/gist_id}","starred_url":"https://api.github.com/users/arottersman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arottersman/subscriptions","organizations_url":"https://api.github.com/users/arottersman/orgs","repos_url":"https://api.github.com/users/arottersman/repos","events_url":"https://api.github.com/users/arottersman/events{/privacy}","received_events_url":"https://api.github.com/users/arottersman/received_events","type":"User","site_admin":false},"created_at":"2017-12-12T16:47:02Z","updated_at":"2017-12-12T16:47:02Z","author_association":"CONTRIBUTOR","body":"As a preliminary check, I've downloaded the s3 version and confirmed the checksum is the same as the one I uploaded. Moving onto verifying the file at other steps of the pipeline."}}
{"actor":{"display_login":"arottersman"}}