{"action":"created","issue":{"url":"https://api.github.com/repos/18F/doi-extractives-data/issues/1618","repository_url":"https://api.github.com/repos/18F/doi-extractives-data","labels_url":"https://api.github.com/repos/18F/doi-extractives-data/issues/1618/labels{/name}","comments_url":"https://api.github.com/repos/18F/doi-extractives-data/issues/1618/comments","events_url":"https://api.github.com/repos/18F/doi-extractives-data/issues/1618/events","html_url":"https://github.com/18F/doi-extractives-data/issues/1618","id":166144164,"number":1618,"title":"Images or data-driven viz on AML page","user":{"login":"meiqimichelle","id":4827522,"avatar_url":"https://avatars.githubusercontent.com/u/4827522?v=3","gravatar_id":"","url":"https://api.github.com/users/meiqimichelle","html_url":"https://github.com/meiqimichelle","followers_url":"https://api.github.com/users/meiqimichelle/followers","following_url":"https://api.github.com/users/meiqimichelle/following{/other_user}","gists_url":"https://api.github.com/users/meiqimichelle/gists{/gist_id}","starred_url":"https://api.github.com/users/meiqimichelle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/meiqimichelle/subscriptions","organizations_url":"https://api.github.com/users/meiqimichelle/orgs","repos_url":"https://api.github.com/users/meiqimichelle/repos","events_url":"https://api.github.com/users/meiqimichelle/events{/privacy}","received_events_url":"https://api.github.com/users/meiqimichelle/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/18F/doi-extractives-data/labels/workflow:in-sprint","name":"workflow:in-sprint","color":"5319e7"}],"state":"open","locked":false,"assignee":{"login":"shawnbot","id":113896,"avatar_url":"https://avatars.githubusercontent.com/u/113896?v=3","gravatar_id":"","url":"https://api.github.com/users/shawnbot","html_url":"https://github.com/shawnbot","followers_url":"https://api.github.com/users/shawnbot/followers","following_url":"https://api.github.com/users/shawnbot/following{/other_user}","gists_url":"https://api.github.com/users/shawnbot/gists{/gist_id}","starred_url":"https://api.github.com/users/shawnbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shawnbot/subscriptions","organizations_url":"https://api.github.com/users/shawnbot/orgs","repos_url":"https://api.github.com/users/shawnbot/repos","events_url":"https://api.github.com/users/shawnbot/events{/privacy}","received_events_url":"https://api.github.com/users/shawnbot/received_events","type":"User","site_admin":false},"assignees":[{"login":"shawnbot","id":113896,"avatar_url":"https://avatars.githubusercontent.com/u/113896?v=3","gravatar_id":"","url":"https://api.github.com/users/shawnbot","html_url":"https://github.com/shawnbot","followers_url":"https://api.github.com/users/shawnbot/followers","following_url":"https://api.github.com/users/shawnbot/following{/other_user}","gists_url":"https://api.github.com/users/shawnbot/gists{/gist_id}","starred_url":"https://api.github.com/users/shawnbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shawnbot/subscriptions","organizations_url":"https://api.github.com/users/shawnbot/orgs","repos_url":"https://api.github.com/users/shawnbot/repos","events_url":"https://api.github.com/users/shawnbot/events{/privacy}","received_events_url":"https://api.github.com/users/shawnbot/received_events","type":"User","site_admin":false},{"login":"coreycaitlin","id":1450354,"avatar_url":"https://avatars.githubusercontent.com/u/1450354?v=3","gravatar_id":"","url":"https://api.github.com/users/coreycaitlin","html_url":"https://github.com/coreycaitlin","followers_url":"https://api.github.com/users/coreycaitlin/followers","following_url":"https://api.github.com/users/coreycaitlin/following{/other_user}","gists_url":"https://api.github.com/users/coreycaitlin/gists{/gist_id}","starred_url":"https://api.github.com/users/coreycaitlin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coreycaitlin/subscriptions","organizations_url":"https://api.github.com/users/coreycaitlin/orgs","repos_url":"https://api.github.com/users/coreycaitlin/repos","events_url":"https://api.github.com/users/coreycaitlin/events{/privacy}","received_events_url":"https://api.github.com/users/coreycaitlin/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/18F/doi-extractives-data/milestones/45","html_url":"https://github.com/18F/doi-extractives-data/milestones/Sprint-EmergencyEmpanadas","labels_url":"https://api.github.com/repos/18F/doi-extractives-data/milestones/45/labels","id":1886205,"number":45,"title":"Sprint-EmergencyEmpanadas","description":"","creator":{"login":"meiqimichelle","id":4827522,"avatar_url":"https://avatars.githubusercontent.com/u/4827522?v=3","gravatar_id":"","url":"https://api.github.com/users/meiqimichelle","html_url":"https://github.com/meiqimichelle","followers_url":"https://api.github.com/users/meiqimichelle/followers","following_url":"https://api.github.com/users/meiqimichelle/following{/other_user}","gists_url":"https://api.github.com/users/meiqimichelle/gists{/gist_id}","starred_url":"https://api.github.com/users/meiqimichelle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/meiqimichelle/subscriptions","organizations_url":"https://api.github.com/users/meiqimichelle/orgs","repos_url":"https://api.github.com/users/meiqimichelle/repos","events_url":"https://api.github.com/users/meiqimichelle/events{/privacy}","received_events_url":"https://api.github.com/users/meiqimichelle/received_events","type":"User","site_admin":false},"open_issues":34,"closed_issues":6,"state":"open","created_at":"2016-07-15T17:22:18Z","updated_at":"2016-07-20T17:33:09Z","due_on":"2016-07-29T07:00:00Z","closed_at":null},"comments":4,"created_at":"2016-07-18T17:10:14Z","updated_at":"2016-07-20T19:12:29Z","closed_at":null,"body":"We have the content for the AML viz tracked in #1571. It needs graphics. We should decide whether these are images or if some should be interactive.\r\n\r\n1) States with unfunded abandoned mine areas today\r\n_This might not be the latest image, there is a little confusion around getting the interactive mockup pdfs to work properly._\r\n<img width=\"397\" alt=\"screenshot 2016-07-19 16 36 34\" src=\"https://cloud.githubusercontent.com/assets/4827522/16970253/8b4dcc00-4dcf-11e6-88c1-a4473ed5a61b.png\">\r\n\r\n2) States where funded reclamation of mine areas is in progress\r\n_This might not be the latest image, there is a little confusion around getting the interactive mockup pdfs to work properly._\r\n<img width=\"381\" alt=\"screenshot 2016-07-19 16 41 31\" src=\"https://cloud.githubusercontent.com/assets/4827522/16970283/b6b7f2da-4dcf-11e6-8eb9-b19a7876796a.png\">\r\n\r\n3) States with reclaimed mine areas funded by the AML program\r\n_Still looking for this image, there is a little confusion around getting the interactive mockup pdfs to work properly._\r\n\r\n4) AML funding and spending\r\n<img width=\"896\" alt=\"screenshot 2016-07-19 16 32 03\" src=\"https://cloud.githubusercontent.com/assets/4827522/16970091/7f1b67ae-4dce-11e6-8614-9c508b21e929.png\">\r\n\r\n5) Annual fees received\r\n<img width=\"907\" alt=\"screenshot 2016-07-19 16 33 38\" src=\"https://cloud.githubusercontent.com/assets/4827522/16970102/918bfa0c-4dce-11e6-9879-6639aaa7524c.png\">\r\n\r\n6) Growth of the fund over time\r\n<img width=\"914\" alt=\"screenshot 2016-07-19 16 34 06\" src=\"https://cloud.githubusercontent.com/assets/4827522/16970114/ad12786e-4dce-11e6-8237-f8f8581ffbae.png\">\r\n\r\n7) Allocation of unappropriated balance\r\n<img width=\"689\" alt=\"screenshot 2016-07-19 16 34 54\" src=\"https://cloud.githubusercontent.com/assets/4827522/16970122/c1967ea2-4dce-11e6-9466-7d28896cc61e.png\">\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/18F/doi-extractives-data/issues/comments/234051300","html_url":"https://github.com/18F/doi-extractives-data/issues/1618#issuecomment-234051300","issue_url":"https://api.github.com/repos/18F/doi-extractives-data/issues/1618","id":234051300,"user":{"login":"avarnum","id":20306455,"avatar_url":"https://avatars.githubusercontent.com/u/20306455?v=3","gravatar_id":"","url":"https://api.github.com/users/avarnum","html_url":"https://github.com/avarnum","followers_url":"https://api.github.com/users/avarnum/followers","following_url":"https://api.github.com/users/avarnum/following{/other_user}","gists_url":"https://api.github.com/users/avarnum/gists{/gist_id}","starred_url":"https://api.github.com/users/avarnum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/avarnum/subscriptions","organizations_url":"https://api.github.com/users/avarnum/orgs","repos_url":"https://api.github.com/users/avarnum/repos","events_url":"https://api.github.com/users/avarnum/events{/privacy}","received_events_url":"https://api.github.com/users/avarnum/received_events","type":"User","site_admin":false},"created_at":"2016-07-20T19:12:29Z","updated_at":"2016-07-20T19:12:29Z","body":"Hi @meiqimichelle.  Spoke to Luke to confirm. \r\n\r\nThe data-book I sent over included this website for the location maps: https://amlis.osmre.gov/Default.aspx \r\n\r\nYou need to go to Query--> Advanced-->other reports (Excel sheet). that has all the location data there. \r\n\r\nYou then need to filter the results so you can get a group of Unreclaimed Mines (those not started or those started by not finished) and Reclaimed Mines (those finished). To do this, you need to filter as follows: \r\n\r\nReclaimed Mines: completed needs to be greater than 0, with funded at 0 and unfunded at 0 (you can do this with ANY of the columns--units, costs, acres--within the same category--completed/funded/unfunded)\r\n\r\nUnreclaimed Mines: the SUM of those not started and those started but not finished\r\nfor those that haven't been started yet, filter so that unfunded is greater than 0, and funded and completed are 0\r\nfor those that are in progress, unfunded and completed could be any value, but funded needed to be greater than 0\r\n\r\nI know that's a complicated set of instructions, so I'm happy to set up a call for you if it's easier. \r\n\r\n-Andrew"}}
{"actor":{"display_login":"avarnum"}}