{"action":"created","issue":{"url":"https://api.github.com/repos/open-austin/project-ideas/issues/73","repository_url":"https://api.github.com/repos/open-austin/project-ideas","labels_url":"https://api.github.com/repos/open-austin/project-ideas/issues/73/labels{/name}","comments_url":"https://api.github.com/repos/open-austin/project-ideas/issues/73/comments","events_url":"https://api.github.com/repos/open-austin/project-ideas/issues/73/events","html_url":"https://github.com/open-austin/project-ideas/issues/73","id":166222568,"number":73,"title":"Turn daily arrest data posted by Harris County into a real database","user":{"login":"safeandfree","id":18540383,"avatar_url":"https://avatars.githubusercontent.com/u/18540383?v=3","gravatar_id":"","url":"https://api.github.com/users/safeandfree","html_url":"https://github.com/safeandfree","followers_url":"https://api.github.com/users/safeandfree/followers","following_url":"https://api.github.com/users/safeandfree/following{/other_user}","gists_url":"https://api.github.com/users/safeandfree/gists{/gist_id}","starred_url":"https://api.github.com/users/safeandfree/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/safeandfree/subscriptions","organizations_url":"https://api.github.com/users/safeandfree/orgs","repos_url":"https://api.github.com/users/safeandfree/repos","events_url":"https://api.github.com/users/safeandfree/events{/privacy}","received_events_url":"https://api.github.com/users/safeandfree/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2016-07-19T00:23:10Z","updated_at":"2016-07-19T16:15:02Z","closed_at":null,"body":"\r\nI think this is easy, but it is over my head. :)\r\n\r\nThere is a daily data file posted in Houston here\r\nhttp://www.jims.hctx.net/jimshome/jimsreports/jims1058.txt\r\n\r\nThis is 24 hours of arrests. The file is replaced every day. We are trying to show that Harris County's jail is full of people they didn't have to arrest.\r\n\r\nWe pulled it and yesterday in Houston:\r\n·         A guy was arrested for a bad headlight, no other charge\r\n·         A guy was arrested for a stop sign violation, no other charge\r\n·         Eleven people were arrested for poss less than a gram, pg 1 and no other offense (keeping in mind, 1/3rd or more of these are likely to be bad field test victims)\r\n·         Two people were jailed for theft less than $50\r\n·         A woman jailed for a series of things that just look like “piling on” – unclean license plate (that’s a thing?), cardboard over a car window, no insurance\r\n·         Two guys were arrested for evading with no additional charge\r\n·         A guy was arrested for evading with a vehicle with no other charge\r\n \r\nThe list goes on. \r\n\r\nAnd now for the help I need.\r\n\r\nI want to automate a daily download of this dataset.\r\nI can create an automated task in Access that will grab a file from my desktop and load it to Access.\r\n\r\nThat's it. I just want to grab this file every day and not have to do it manually. I hope that's pretty simple. I would suggest including it in your data portal project but its Harris County data. So not local. It is really valuable for criminal justice research.\r\n\r\n### Links to any research/data available/articles\r\n\r\nLinks here.\r\n\r\n### What are the next steps (validation, research, coding, design)? \r\n\r\nAnswer here.\r\n\r\n### What help is needed at this time?\r\n\r\nAnswer here.\r\n"},"comment":{"url":"https://api.github.com/repos/open-austin/project-ideas/issues/comments/233685010","html_url":"https://github.com/open-austin/project-ideas/issues/73#issuecomment-233685010","issue_url":"https://api.github.com/repos/open-austin/project-ideas/issues/73","id":233685010,"user":{"login":"werdnanoslen","id":764090,"avatar_url":"https://avatars.githubusercontent.com/u/764090?v=3","gravatar_id":"","url":"https://api.github.com/users/werdnanoslen","html_url":"https://github.com/werdnanoslen","followers_url":"https://api.github.com/users/werdnanoslen/followers","following_url":"https://api.github.com/users/werdnanoslen/following{/other_user}","gists_url":"https://api.github.com/users/werdnanoslen/gists{/gist_id}","starred_url":"https://api.github.com/users/werdnanoslen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/werdnanoslen/subscriptions","organizations_url":"https://api.github.com/users/werdnanoslen/orgs","repos_url":"https://api.github.com/users/werdnanoslen/repos","events_url":"https://api.github.com/users/werdnanoslen/events{/privacy}","received_events_url":"https://api.github.com/users/werdnanoslen/received_events","type":"User","site_admin":false},"created_at":"2016-07-19T16:15:02Z","updated_at":"2016-07-19T16:15:02Z","body":"@colbywhite I think @safeandfree said they can load the files as-is into Access, since the it seems to be a database format delimited by semicolons and tabs.\n\n@safeandfree have you used Ruby before? What is the OS on the computer that you'd like the files to be downloaded to?"}}
{"actor":{"display_login":"werdnanoslen"}}