{"action":"created","issue":{"url":"https://api.github.com/repos/OpenTechStrategies/smoke-alarm-portal/issues/66","labels_url":"https://api.github.com/repos/OpenTechStrategies/smoke-alarm-portal/issues/66/labels{/name}","comments_url":"https://api.github.com/repos/OpenTechStrategies/smoke-alarm-portal/issues/66/comments","events_url":"https://api.github.com/repos/OpenTechStrategies/smoke-alarm-portal/issues/66/events","html_url":"https://github.com/OpenTechStrategies/smoke-alarm-portal/issues/66","id":95136516,"number":66,"title":"False negative for St. Louis, MO with ZIP 63101.","user":{"login":"kfogel","id":401111,"avatar_url":"https://avatars.githubusercontent.com/u/401111?v=3","gravatar_id":"","url":"https://api.github.com/users/kfogel","html_url":"https://github.com/kfogel","followers_url":"https://api.github.com/users/kfogel/followers","following_url":"https://api.github.com/users/kfogel/following{/other_user}","gists_url":"https://api.github.com/users/kfogel/gists{/gist_id}","starred_url":"https://api.github.com/users/kfogel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kfogel/subscriptions","organizations_url":"https://api.github.com/users/kfogel/orgs","repos_url":"https://api.github.com/users/kfogel/repos","events_url":"https://api.github.com/users/kfogel/events{/privacy}","received_events_url":"https://api.github.com/users/kfogel/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/OpenTechStrategies/smoke-alarm-portal/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"kfogel","id":401111,"avatar_url":"https://avatars.githubusercontent.com/u/401111?v=3","gravatar_id":"","url":"https://api.github.com/users/kfogel","html_url":"https://github.com/kfogel","followers_url":"https://api.github.com/users/kfogel/followers","following_url":"https://api.github.com/users/kfogel/following{/other_user}","gists_url":"https://api.github.com/users/kfogel/gists{/gist_id}","starred_url":"https://api.github.com/users/kfogel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kfogel/subscriptions","organizations_url":"https://api.github.com/users/kfogel/orgs","repos_url":"https://api.github.com/users/kfogel/repos","events_url":"https://api.github.com/users/kfogel/events{/privacy}","received_events_url":"https://api.github.com/users/kfogel/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/OpenTechStrategies/smoke-alarm-portal/milestones/6","html_url":"https://github.com/OpenTechStrategies/smoke-alarm-portal/milestones/Emailing%20Demo","labels_url":"https://api.github.com/repos/OpenTechStrategies/smoke-alarm-portal/milestones/6/labels","id":1202994,"number":6,"title":"Emailing Demo","description":"By this demo, the client wants to be able to submit a request and have it send an email to the correct recipient (who will be in the demo).","creator":{"login":"cecilia-donnelly","id":1497818,"avatar_url":"https://avatars.githubusercontent.com/u/1497818?v=3","gravatar_id":"","url":"https://api.github.com/users/cecilia-donnelly","html_url":"https://github.com/cecilia-donnelly","followers_url":"https://api.github.com/users/cecilia-donnelly/followers","following_url":"https://api.github.com/users/cecilia-donnelly/following{/other_user}","gists_url":"https://api.github.com/users/cecilia-donnelly/gists{/gist_id}","starred_url":"https://api.github.com/users/cecilia-donnelly/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cecilia-donnelly/subscriptions","organizations_url":"https://api.github.com/users/cecilia-donnelly/orgs","repos_url":"https://api.github.com/users/cecilia-donnelly/repos","events_url":"https://api.github.com/users/cecilia-donnelly/events{/privacy}","received_events_url":"https://api.github.com/users/cecilia-donnelly/received_events","type":"User","site_admin":false},"open_issues":7,"closed_issues":2,"state":"open","created_at":"2015-07-10T20:09:59Z","updated_at":"2015-07-15T08:38:24Z","due_on":"2015-07-15T05:00:00Z","closed_at":null},"comments":1,"created_at":"2015-07-15T08:38:24Z","updated_at":"2015-07-15T08:54:11Z","closed_at":null,"body":"This is just like #65, except that it's a higher priority because St. Louis zip codes are *much* more likely to be used for the demo.  Whatever's going on here, we've got to figure it out.  My data was as in #65, except I used these field values in the obvious places:\r\n\r\n1234 Some Street\r\nSt. Louis\r\nMissouri\r\n63101"},"comment":{"url":"https://api.github.com/repos/OpenTechStrategies/smoke-alarm-portal/issues/comments/121534322","html_url":"https://github.com/OpenTechStrategies/smoke-alarm-portal/issues/66#issuecomment-121534322","issue_url":"https://api.github.com/repos/OpenTechStrategies/smoke-alarm-portal/issues/66","id":121534322,"user":{"login":"kfogel","id":401111,"avatar_url":"https://avatars.githubusercontent.com/u/401111?v=3","gravatar_id":"","url":"https://api.github.com/users/kfogel","html_url":"https://github.com/kfogel","followers_url":"https://api.github.com/users/kfogel/followers","following_url":"https://api.github.com/users/kfogel/following{/other_user}","gists_url":"https://api.github.com/users/kfogel/gists{/gist_id}","starred_url":"https://api.github.com/users/kfogel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kfogel/subscriptions","organizations_url":"https://api.github.com/users/kfogel/orgs","repos_url":"https://api.github.com/users/kfogel/repos","events_url":"https://api.github.com/users/kfogel/events{/privacy}","received_events_url":"https://api.github.com/users/kfogel/received_events","type":"User","site_admin":false},"created_at":"2015-07-15T08:54:11Z","updated_at":"2015-07-15T08:54:11Z","body":"Okay, I think I've got the answer to both this and issue #65.  For this issue it's a \"St Louis\" vs \"Saint Louis\" problem, and in issue #65 it's a capitalization problem (I'll comment over there).\r\n\r\nOn demo server:\r\n\r\n    smokealarm_development=> select zip, state, county from \"UsAddresses\" where zip like '63101';\r\n      zip  |  state   |    county\r\n    -------+----------+---------------\r\n     63101 | Missouri | St Louis City\r\n    (1 row)\r\n\r\n    smokealarm_development=> select state, county, region from \"SelectedCounties\" where county like 'St Louis City';\r\n     state | county | region\r\n    -------+--------+--------\r\n    (0 rows)\r\n    \r\n    smokealarm_development=> select state, county, region from \"SelectedCounties\" where county like 'Saint Louis City';\r\n      state   |      county      |      region\r\n    ----------+------------------+------------------\r\n     Missouri | Saint Louis City | Eastern Missouri\r\n    (1 row)\r\n\r\nYeah...\r\n\r\nOkay, need to think of the right fix now."}}