{"action":"created","issue":{"url":"https://api.github.com/repos/ChicagoCityscape/website/issues/85","repository_url":"https://api.github.com/repos/ChicagoCityscape/website","labels_url":"https://api.github.com/repos/ChicagoCityscape/website/issues/85/labels{/name}","comments_url":"https://api.github.com/repos/ChicagoCityscape/website/issues/85/comments","events_url":"https://api.github.com/repos/ChicagoCityscape/website/issues/85/events","html_url":"https://github.com/ChicagoCityscape/website/issues/85","id":193011902,"number":85,"title":"Find building permits at sold Large Lots","user":{"login":"stevevance","id":1330459,"avatar_url":"https://avatars.githubusercontent.com/u/1330459?v=3","gravatar_id":"","url":"https://api.github.com/users/stevevance","html_url":"https://github.com/stevevance","followers_url":"https://api.github.com/users/stevevance/followers","following_url":"https://api.github.com/users/stevevance/following{/other_user}","gists_url":"https://api.github.com/users/stevevance/gists{/gist_id}","starred_url":"https://api.github.com/users/stevevance/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stevevance/subscriptions","organizations_url":"https://api.github.com/users/stevevance/orgs","repos_url":"https://api.github.com/users/stevevance/repos","events_url":"https://api.github.com/users/stevevance/events{/privacy}","received_events_url":"https://api.github.com/users/stevevance/received_events","type":"User","site_admin":false},"labels":[{"id":479308851,"url":"https://api.github.com/repos/ChicagoCityscape/website/labels/map","name":"map","color":"0052cc","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-12-02T01:44:40Z","updated_at":"2016-12-02T06:35:00Z","closed_at":null,"body":"Let's track if anyone is building on Large Lots. \r\n\r\n- [ ] I need to gather the data on which PINs have been sold to LL owners. That data is on [this DataMade Carto page](https://datamade.carto.com/tables/lots_with_status/public), and the `status` for sold parcels is `3`. \r\n- [ ] Update the generic map API to have a query that selects all building permits that intersect with these parcels, issued after a certain time\r\n\r\nLots were officially sold on January 30, 2015 for [Greater Englewood Area](https://www.largelots.org/status/pilot_1) and April 24th, 2015 for [East Garfield Park area](https://www.largelots.org/status/pilot_2)."},"comment":{"url":"https://api.github.com/repos/ChicagoCityscape/website/issues/comments/264384531","html_url":"https://github.com/ChicagoCityscape/website/issues/85#issuecomment-264384531","issue_url":"https://api.github.com/repos/ChicagoCityscape/website/issues/85","id":264384531,"user":{"login":"stevevance","id":1330459,"avatar_url":"https://avatars.githubusercontent.com/u/1330459?v=3","gravatar_id":"","url":"https://api.github.com/users/stevevance","html_url":"https://github.com/stevevance","followers_url":"https://api.github.com/users/stevevance/followers","following_url":"https://api.github.com/users/stevevance/following{/other_user}","gists_url":"https://api.github.com/users/stevevance/gists{/gist_id}","starred_url":"https://api.github.com/users/stevevance/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stevevance/subscriptions","organizations_url":"https://api.github.com/users/stevevance/orgs","repos_url":"https://api.github.com/users/stevevance/repos","events_url":"https://api.github.com/users/stevevance/events{/privacy}","received_events_url":"https://api.github.com/users/stevevance/received_events","type":"User","site_admin":false},"created_at":"2016-12-02T06:35:00Z","updated_at":"2016-12-02T06:35:00Z","body":"Address comparison query:\r\n\r\n````\r\nselect *, '{\r\n  \"type\": \"FeatureCollection\",\r\n  \"features\": [\r\n    {\r\n      \"type\": \"Feature\",\r\n      \"properties\": {},\r\n      \"geometry\":' || point || '},\r\n    {\r\n      \"type\": \"Feature\",\r\n      \"properties\": {},\r\n      \"geometry\": ' || polygon || '}\r\n  ]\r\n}' as feature_collection from (select permit_, l.pin14, \r\np.address as permit_address,\r\nl.address as parcel_address,\r\nST_asgeojson(p.geom) point, \r\nst_asgeojson(l.geom_4326) polygon\r\nfrom permits p  right join large_lots_status_120116 l on lower(replace(p.address, ' ', '' )) = l.address_slug\r\nand l.status = 3\r\nwhere issue_date > '2015-01-30') as foo\r\n````"}}
{"actor":{"display_login":"stevevance"}}