{"action":"created","issue":{"url":"https://api.github.com/repos/socrata/opendatanetwork.com/issues/272","repository_url":"https://api.github.com/repos/socrata/opendatanetwork.com","labels_url":"https://api.github.com/repos/socrata/opendatanetwork.com/issues/272/labels{/name}","comments_url":"https://api.github.com/repos/socrata/opendatanetwork.com/issues/272/comments","events_url":"https://api.github.com/repos/socrata/opendatanetwork.com/issues/272/events","html_url":"https://github.com/socrata/opendatanetwork.com/issues/272","id":136484509,"number":272,"title":"+ generate pipe to data: public safety seeded w/ crime summary stats","user":{"login":"zang0","id":1051776,"avatar_url":"https://avatars.githubusercontent.com/u/1051776?v=3","gravatar_id":"","url":"https://api.github.com/users/zang0","html_url":"https://github.com/zang0","followers_url":"https://api.github.com/users/zang0/followers","following_url":"https://api.github.com/users/zang0/following{/other_user}","gists_url":"https://api.github.com/users/zang0/gists{/gist_id}","starred_url":"https://api.github.com/users/zang0/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zang0/subscriptions","organizations_url":"https://api.github.com/users/zang0/orgs","repos_url":"https://api.github.com/users/zang0/repos","events_url":"https://api.github.com/users/zang0/events{/privacy}","received_events_url":"https://api.github.com/users/zang0/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/socrata/opendatanetwork.com/labels/high%20priority","name":"high priority","color":"009800"}],"state":"open","locked":false,"assignee":{"login":"chrismetcalf","id":19971,"avatar_url":"https://avatars.githubusercontent.com/u/19971?v=3","gravatar_id":"","url":"https://api.github.com/users/chrismetcalf","html_url":"https://github.com/chrismetcalf","followers_url":"https://api.github.com/users/chrismetcalf/followers","following_url":"https://api.github.com/users/chrismetcalf/following{/other_user}","gists_url":"https://api.github.com/users/chrismetcalf/gists{/gist_id}","starred_url":"https://api.github.com/users/chrismetcalf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chrismetcalf/subscriptions","organizations_url":"https://api.github.com/users/chrismetcalf/orgs","repos_url":"https://api.github.com/users/chrismetcalf/repos","events_url":"https://api.github.com/users/chrismetcalf/events{/privacy}","received_events_url":"https://api.github.com/users/chrismetcalf/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/socrata/opendatanetwork.com/milestones/8","html_url":"https://github.com/socrata/opendatanetwork.com/milestones/v.data.2","labels_url":"https://api.github.com/repos/socrata/opendatanetwork.com/milestones/8/labels","id":1576370,"number":8,"title":"v.data.2","description":"Next data centric milestone to be completed after v.data.1","creator":{"login":"zang0","id":1051776,"avatar_url":"https://avatars.githubusercontent.com/u/1051776?v=3","gravatar_id":"","url":"https://api.github.com/users/zang0","html_url":"https://github.com/zang0","followers_url":"https://api.github.com/users/zang0/followers","following_url":"https://api.github.com/users/zang0/following{/other_user}","gists_url":"https://api.github.com/users/zang0/gists{/gist_id}","starred_url":"https://api.github.com/users/zang0/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zang0/subscriptions","organizations_url":"https://api.github.com/users/zang0/orgs","repos_url":"https://api.github.com/users/zang0/repos","events_url":"https://api.github.com/users/zang0/events{/privacy}","received_events_url":"https://api.github.com/users/zang0/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":67,"state":"open","created_at":"2016-02-10T19:55:47Z","updated_at":"2016-03-03T17:22:44Z","due_on":null,"closed_at":null},"comments":14,"created_at":"2016-02-25T19:23:06Z","updated_at":"2016-03-03T17:42:53Z","closed_at":null,"body":"high level:\r\n\r\nintro moto based summary crime stats into a new tab called public safety w/ sub category crime. End result will look something like this: http://www.opendatanetwork.com/region/1600000US5363000/Seattle_WA/earnings/median_earnings/2013\r\n\r\nwhere drop downs in the map are by crime type, and summary timeline stats are total crimes.\r\n\r\nreqs:\r\n\r\n1. user should be able to see a crime map + charts and toggle by type of crime, i.e. assault. \r\n2. user should be able to compare cities (rolled up geo regions will happen post take 1) for which we have crime data (suggested comparison autosuggest is constrained to appropriate datasets)\r\n3. summary stats will be broken down by month going back 36 months\r\n4. crime data needs to be per capita normalized (# incidents / 10K population) - take (#crimes/#people)*10000. Per capita normalization should use our most recent measured data (2013)\r\n5. charts should include timeline data where take 1 includes the sum across all crime types. Take 2 we'll tackle an in chart toggle across all individual crime types\r\n6. for queries corresponding to region/sub-topic, we'll use the data set expansion query terms: crime, police, arrest, warrant\r\n \r\ndetails:\r\n\r\n_1. pipeline\r\n\r\n_1.1 access every agency\r\n\r\nwe need the pipeline to access this data set:\r\n\r\nhttps://moto.data.socrata.com/dataset/Agencies-NBE/fax2-dw8p\r\n\r\nwhich lists all agencies. \r\n\r\n_1.2 access itemized agency data\r\n\r\nfor every agency, the process then needs to access individual detailed crime states for an agency,\r\n\r\n examples:\r\n\r\nhttps://moto.data.socrata.com/dataset/King-County-Sheriff-s-Office/4h35-4mtu\r\nhttps://moto.data.socrata.com/dataset/Washington-DC/2vfk-6rp4\r\n\r\n_1.3 resolve USCensusIds for each place\r\n\r\nwe then need to walk through and resolve to our uscensusid's using this data set: https://odn.data.socrata.com/view/p5cc-m8dh\r\n\r\nlets try a fuzzy name match + geo radius constraint\r\n\r\n_1.4 rollup by month and crime type\r\n\r\nwe'd then generate a list of summary stats (monthly totals in each of the categories under the incident_type_primary column going back in time 36 months from current including only complete months)\r\n\r\n_2. wire in data set\r\n\r\n_3. test"},"comment":{"url":"https://api.github.com/repos/socrata/opendatanetwork.com/issues/comments/191880448","html_url":"https://github.com/socrata/opendatanetwork.com/issues/272#issuecomment-191880448","issue_url":"https://api.github.com/repos/socrata/opendatanetwork.com/issues/272","id":191880448,"user":{"login":"chrismetcalf","id":19971,"avatar_url":"https://avatars.githubusercontent.com/u/19971?v=3","gravatar_id":"","url":"https://api.github.com/users/chrismetcalf","html_url":"https://github.com/chrismetcalf","followers_url":"https://api.github.com/users/chrismetcalf/followers","following_url":"https://api.github.com/users/chrismetcalf/following{/other_user}","gists_url":"https://api.github.com/users/chrismetcalf/gists{/gist_id}","starred_url":"https://api.github.com/users/chrismetcalf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chrismetcalf/subscriptions","organizations_url":"https://api.github.com/users/chrismetcalf/orgs","repos_url":"https://api.github.com/users/chrismetcalf/repos","events_url":"https://api.github.com/users/chrismetcalf/events{/privacy}","received_events_url":"https://api.github.com/users/chrismetcalf/received_events","type":"User","site_admin":false},"created_at":"2016-03-03T17:42:53Z","updated_at":"2016-03-03T17:42:53Z","body":"https://odn.data.socrata.com/dataset/National-Police-Department-Crime-Rates-by-Month-Ye/tt5s-y5fc\r\n\r\nPolice only data!"}}