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, 


############################################
# 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


# 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.
    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