{"action":"created","issue":{"url":"https://api.github.com/repos/DCActionforChildren/dcaction/issues/170","labels_url":"https://api.github.com/repos/DCActionforChildren/dcaction/issues/170/labels{/name}","comments_url":"https://api.github.com/repos/DCActionforChildren/dcaction/issues/170/comments","events_url":"https://api.github.com/repos/DCActionforChildren/dcaction/issues/170/events","html_url":"https://github.com/DCActionforChildren/dcaction/issues/170","id":106154985,"number":170,"title":"Crosswalk and add updated medicaid data","user":{"login":"cmgiven","id":5375557,"avatar_url":"https://avatars.githubusercontent.com/u/5375557?v=3","gravatar_id":"","url":"https://api.github.com/users/cmgiven","html_url":"https://github.com/cmgiven","followers_url":"https://api.github.com/users/cmgiven/followers","following_url":"https://api.github.com/users/cmgiven/following{/other_user}","gists_url":"https://api.github.com/users/cmgiven/gists{/gist_id}","starred_url":"https://api.github.com/users/cmgiven/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cmgiven/subscriptions","organizations_url":"https://api.github.com/users/cmgiven/orgs","repos_url":"https://api.github.com/users/cmgiven/repos","events_url":"https://api.github.com/users/cmgiven/events{/privacy}","received_events_url":"https://api.github.com/users/cmgiven/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-09-12T12:49:51Z","updated_at":"2015-09-12T14:44:56Z","closed_at":null,"body":"Moving a discussion from the Hackpad/email here.\r\n\r\n@ayota:\r\n\r\n> Medicaid data has been converted to neighborhood level using this script, and is [available here](https://github.com/DCActionforChildren/dcaction/blob/gh-pages/data/scripts/cw_test/medicaid_nbhd.csv). I am not sure the crosswalk file is right for zip code to neighborhood cluster, so this may need to be redone with another crosswalk file.\r\n\r\n@shanab202:\r\n\r\n> Thanks Chris and a big thank you to Elaine too. We will take a look today and get back to you. First glance, the crosswalk put Medicaid enrollees in the 41-45. Will take a closer look.\r\n\r\n@timothywvance:\r\n\r\n> Just to clarify the zip to tract crosswalk methodology, have we been using the ratio of total addresses? That’s what it seems from the recent crosswalk numbers. If so, is there a methodological reason to use total address ratio rather than the residential address ratio (also included in the ziptract.csv) since our zip code indicators are all population based?\r\n>\r\n> Also, does the “Portion” value (column B) from the ziptract file indicate the proportion of the Tract that is in the respective neighborhood cluster? If so, it doesn’t look like this has been factored into the recent crosswalk calculations.\r\n>\r\n> I agree with Shana that we need to think about how to re-apportion the non-residential clusters (40-45) into the primary residential clusters that we include in the tool (1-39). I don’t think this will be too complicated though. How have we done this in the past?\r\n>\r\n> Let me know if I’m misunderstanding the crosswalk process.\r\n\r\nElaine, I think it's far more likely that you have answers for Tim's questions than I do. I'll just note that I don't know whether/how non-residential clusters might have been reapportioned previously, although perhaps @mjrich might?"},"comment":{"url":"https://api.github.com/repos/DCActionforChildren/dcaction/issues/comments/139778868","html_url":"https://github.com/DCActionforChildren/dcaction/issues/170#issuecomment-139778868","issue_url":"https://api.github.com/repos/DCActionforChildren/dcaction/issues/170","id":139778868,"user":{"login":"ayota","id":2133979,"avatar_url":"https://avatars.githubusercontent.com/u/2133979?v=3","gravatar_id":"","url":"https://api.github.com/users/ayota","html_url":"https://github.com/ayota","followers_url":"https://api.github.com/users/ayota/followers","following_url":"https://api.github.com/users/ayota/following{/other_user}","gists_url":"https://api.github.com/users/ayota/gists{/gist_id}","starred_url":"https://api.github.com/users/ayota/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ayota/subscriptions","organizations_url":"https://api.github.com/users/ayota/orgs","repos_url":"https://api.github.com/users/ayota/repos","events_url":"https://api.github.com/users/ayota/events{/privacy}","received_events_url":"https://api.github.com/users/ayota/received_events","type":"User","site_admin":false},"created_at":"2015-09-12T14:44:56Z","updated_at":"2015-09-12T14:44:56Z","body":"@timothywvance @shanab202 I used the total because I wasn't really clear which one to use; I can rerun with residential and that should fix things. \r\n\r\nAnd yes, the idea is the portion column is multiplied by whatever the zip code value is and then summed by neighborhood. Some spot checks showed the math was working correctly, but I will test some more to make sure things are getting converted correctly. Thanks everyone!"}}