This is a read only archive of pad.okfn.org. See the
shutdown announcement
for details.
open-data-london-2015
0Init
Intro Slides: https://docs.google.com/a/okfn.org/presentation/d/1FKr1f-uuCaZGuCL9EUCiyO4WoGzeGHWDDsK7mJ8NQEc/edit
This hackpad: bit.ly/oddldn2015
# WiFi
SSID: TOMspace
Key: openspace
#########################
# Attendees
Add your name, your skills.
Skills are: coder (language), designer, researcher,
- Ed Saperia www.facebook.com/edsaperia, www.twitter.com/edsaperia, Community Strategist, Lawful Good Human ᕕ(ᐛ)ᕗ
- Rufus Pollock (@rufuspollock) Engineer, Analyst (Storyteller?) - python, nodejs, ...
- Peter Hicks (@poggs) - coder/developer (Ruby on Rails, geospatial, PostgreSQL)
- Lora Armstrong (@umunairu). Skills- researcher? (scientist- geologist), very basic coding in Python & Matlab; want to learn to use big datasets. storyteller?
- Riyadh Al Balushi (@RiyadhBalushi) - Researcher (legal background)
- Sion Elis Williams (researcher) very basic data gathering/handling for making maps on Friends of the Earth's custom-built open-source tool , currently work on nature (@sequencefree)
- Ben Scott (@benjaminscott) - coder (Python, PHP, JS, Data Visualisation) - Natural History Museum
- Elliot Sefton-Nash (@istudyplanets) - planetary scientist, code (Matlab, Python), some geospatial stuff, planetary data (NASA/ESA archives)
- Alex Bennée (@stsquad) - Engineer/Coder (C, Python, PHP, JS, elisp)
- Adrián Blanco (@AdrianBlancoR) - Journalist, Storyteller, Data skills (Refine, Excel, viz tools...)
- Ivvet Modinou (@ivvetm) - storyteller / project ideas / public engagement with science / critical friend
- Paul Conneely - research/facilitator/ interested in data and insight. storyteller
- Krystina Shveda, storyteller/analyst/scout (@krystinashveda) data journalist
- Frank - coder (python)
- Sabrina Provenzani, investigative journalist, interested in data and new ways of storytelling - basic knowledge of data gathering and visualization
- Jonathan Baillie Strong (@jonbstrong) HTML/CSS, data viz, sound production
############################################
# Project Ideas
- Transport Data Project: Bicycle top routes, how long would they take on the bus or the tube. https://docs.google.com/document/d/1qBynyBR-9OQk3dBCsTsIxqKXOhzE-0_EWL_Ad-XAhoY/edit?usp=sharing
Mapping the bird population in Natura 2000 sites in the UK
# Resources
- http://datahub.io/
- http://data.nhm.ac.uk/ - access 2.7 million natural history specimens
- European Space Agency Planetary Science Archive: http://www.rssd.esa.int/index.php?project=PSA
- NASA Planetary Data System: http://pds.nasa.gov/
- https://www.tfl.gov.uk/info-for/open-data-users/
- https://datafeeds.networkrail.co.uk
- https://realtime.nationalrail.co.uk/OpenLDBWSRegistration
- Communities and Local Government Data Sources - http://opendatacommunities.org/
# Local Lunch Options
- Beigal shops salt beef & sandwiches £ right out the door then left, on the right side. Only the second one has bacon!
- Noodle King rice & noodles £ left out the door and on the left side
- Tas Firin turkish grill £ left out the door and on the right side
- Byron american diner ££ right out the door, past the lights and on the left side
- E2 Spice fried chicken & chips £ left out the door and on the left side
- Indigo contemporary indian ££ right out the door, past the lights and on the right side
- Maida indian/pan asian £ left out the door and on the right side
- Subway subs £ right out the door then left, on the left side
- Eat sandwiches & stuff £ right out the door, 5 mins walk
- Pret sandwiches £ right out the door, 5 mins walk
- Itsu sushi & noodles ££ right out the door, 5 mins walk
- Nandos grilled chicken ££ left out the door, 5 mins walk
- Sainsbury’s supermarket right out the door, past the lights and on the left side
# Project: Barclays Cycle Hire analysis
Email:
Peter Hicks (@poggs) - peter.hicks@poggs.co.uk
Project: Council Expenditure
Emails:
Elliot Sefton-Nash - elliotsn@gmail.com
Sabrina Provenzani provenzanisabrinalondon@gmai.com
This list of councils comprise the top 1/3rd of council expenditure in the UK: SEPTEMBER 2014
1 Birmingham - Elliot
2 Kent - Paul
3 Essex - Elliot
4 Lancashire - Paul
5 Surrey Paul
6 Hampshire - Sabrina
7 Hertfordshire - Elliot
8 Norfolk - Elliot
9 Leeds Paul
10 West Sussex - Elliot
11 Nottinghamshire
12 Liverpool Paul
13 Devon - Elliot
14 Manchester Paul
15 Derbyshire - Elliot
16 Staffordshire
17 Sheffield - Paul
18 Suffolk
19 Lincolnshire
20 Durham
21 Cornwall
22 Bradford - Elliot
23 Northamptonshire
24 Oxfordshire
25 Gloucestershire
26 Bristol Sabrina
Nottingham - Sabrina
Goals (?):
1. For each council, analyse spending reports to highlight the areas/suppliers of biggest expenditure.
- For 5 councils, download data for September 2014 and make a clean CSV.
2. Group suppliers into service type, e.g. travel, hospitality, training etc...
Google Spreadsheet to paste data into, feel free to add columns, but columns must be the same for each council.y
https://docs.google.com/spreadsheets/d/1tyLvRWrnY-c4TTTCTYPur39QOOZW7HJpOwxUujfKtoQ/edit?usp=sharing
EDIT: Google Spreadsheets can't handle this amount of data, each keep a local copy of our own spreadsheets, then combine at the end.
Consolidated spreadsheet for 13 councils, sorted descending by transaction amount:
https://dl.dropboxusercontent.com/u/12373080/council_expenditure/council_expense_data.xlsx
http://datos.gob.cl/datasets/ver/31132 Chilean Budget
http://datos.gob.cl/recursos/download/3904
Nature hackers
Ideas
Natura 2000 data for the UK - http://jncc.defra.gov.uk/protectedsites/SACselection/gis_data/data_download.asp
Greater London National Park project - http://www.greaterlondonnationalpark.org.uk/visit/maps/
Data for protected species in London http://legacy.london.gov.uk/mayor/environment/biodiversity/docs/protected_species_in_london.pdf
Sources
Greater London Authority boundary shapefiles - http://mapit.mysociety.org/area/2247.html
Ordnance Survey Cartographic Stylesheets (including Boundary-Line) https://www.ordnancesurvey.co.uk/resources/carto-design/cartographic-stylesheets.html
http://legacy.london.gov.uk/mayor/environment/biodiversity/docs/protected_species_in_london.pdf
http://www.benscott.co.uk/2014/02/22/open-data-day.html