{"action":"created","issue":{"url":"https://api.github.com/repos/DemocracyClub/UK-Polling-Stations/issues/267","repository_url":"https://api.github.com/repos/DemocracyClub/UK-Polling-Stations","labels_url":"https://api.github.com/repos/DemocracyClub/UK-Polling-Stations/issues/267/labels{/name}","comments_url":"https://api.github.com/repos/DemocracyClub/UK-Polling-Stations/issues/267/comments","events_url":"https://api.github.com/repos/DemocracyClub/UK-Polling-Stations/issues/267/events","html_url":"https://github.com/DemocracyClub/UK-Polling-Stations/issues/267","id":154339048,"number":267,"title":"Crowdsource Polling Stations","user":{"login":"chris48s","id":6025893,"avatar_url":"https://avatars.githubusercontent.com/u/6025893?v=3","gravatar_id":"","url":"https://api.github.com/users/chris48s","html_url":"https://github.com/chris48s","followers_url":"https://api.github.com/users/chris48s/followers","following_url":"https://api.github.com/users/chris48s/following{/other_user}","gists_url":"https://api.github.com/users/chris48s/gists{/gist_id}","starred_url":"https://api.github.com/users/chris48s/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chris48s/subscriptions","organizations_url":"https://api.github.com/users/chris48s/orgs","repos_url":"https://api.github.com/users/chris48s/repos","events_url":"https://api.github.com/users/chris48s/events{/privacy}","received_events_url":"https://api.github.com/users/chris48s/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-11T20:46:21Z","updated_at":"2016-05-11T20:56:17Z","closed_at":null,"body":"Overview\r\n-----\r\n* Latest OS Boundary line contains polling district boundaries for all 325 councils in England - that's 31,825 boundaries.\r\n* Councils publish PDFs with their polling station addresses and district codes. e.g:\r\n\r\nhttp://www.adur-worthing.gov.uk/media/media,100300,en.pdf\r\n\r\nhttp://www.stalbans.gov.uk/Images/ldrsPollingStations_tcm15-40023.pdf\r\n\r\nhttp://www.derby.gov.uk/media/Derby_City_Council_Polling_Station_List_2016.pdf\r\n\r\nhttp://www.richmondshire.gov.uk/council-democracy/elections/divisions-wards-polling-district-and-polling-stations\r\n\r\n* We could use this to try and crowdsource full (or full-ish) coverage of England.\r\n\r\n\r\nAbsolute bare minimum viable product\r\n-----\r\n\r\n1. Write an import script for English Polling Districts file in latest Boundary Line. The polling stations shape file contains 31,825 polling districts - so that's the number of data points we would be looking to source. Non-trivial as shape file does not have GSS codes for councils - only names, so requires some faffing about! :(\r\n\r\n2. Devise a mechanism for people to provide data. Absolute bare minimum implementation would be to set up a google spreadsheet for people to enter data into. It should hold:\r\ncouncil name (pre-populated by us)\r\ncouncil ons/gss code (pre-populated by us)\r\npolling district id (pre-populated by us)\r\naddress (user fills in)\r\npostcode (user fills in)\r\nsource (user fills in/we provide if possible - we need this to ensure some basic level of data quality)\r\n\r\n3. Generate the seed data (fairly easy once 1 is done)\r\n\r\n4. Write an import script to take CSVs exported from google docs and bash them into the PollingStations model (+geocode if postcode present so we can do maps where possible)\r\n\r\n5. Work out how to extract new/latest data as its entered and import it.. perhaps the simplest way to manage this would be to set up ~325 seperate spreadsheets and then import each one as it is filled up rather than try to manage one huge 31,825 line spreadsheet - can we automate bulk-generating google spreadsheets from CSV templates? That way we could assign people a spreadsheet per council with a link to PDFs?\r\n\r\n6. Source as many links to council polling station PDFs as possible.\r\n\r\n7. Recruit army of data wombles.\r\n\r\n8. ???\r\n\r\n9. Profit"},"comment":{"url":"https://api.github.com/repos/DemocracyClub/UK-Polling-Stations/issues/comments/218587523","html_url":"https://github.com/DemocracyClub/UK-Polling-Stations/issues/267#issuecomment-218587523","issue_url":"https://api.github.com/repos/DemocracyClub/UK-Polling-Stations/issues/267","id":218587523,"user":{"login":"JoeMitchell","id":8096305,"avatar_url":"https://avatars.githubusercontent.com/u/8096305?v=3","gravatar_id":"","url":"https://api.github.com/users/JoeMitchell","html_url":"https://github.com/JoeMitchell","followers_url":"https://api.github.com/users/JoeMitchell/followers","following_url":"https://api.github.com/users/JoeMitchell/following{/other_user}","gists_url":"https://api.github.com/users/JoeMitchell/gists{/gist_id}","starred_url":"https://api.github.com/users/JoeMitchell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JoeMitchell/subscriptions","organizations_url":"https://api.github.com/users/JoeMitchell/orgs","repos_url":"https://api.github.com/users/JoeMitchell/repos","events_url":"https://api.github.com/users/JoeMitchell/events{/privacy}","received_events_url":"https://api.github.com/users/JoeMitchell/received_events","type":"User","site_admin":false},"created_at":"2016-05-11T20:56:17Z","updated_at":"2016-05-11T20:56:17Z","body":"\"a spreadsheet per council with a link to PDFs\" +!"}}