Hack the City 3 – the Summer 2014 Challenge

We’re back this summer for the third instalment of Hack the City. Join us at the Showroom Cinema on 16 Aug 2014 for a day of open data wrangling, urban and civic hacking and to develop your service prototypes and startup concepts.

As before, we are supporting the Open Data Challenge Series which offers a chance to win £40k equity-free funding for (on this occasion) your housing-related open data startup. So, while any urban or civic project is welcome at Hack the City, this time we’re especially excited to explore how data can can help private or social tenants better understand their housing options.

Continue reading

Data for Neighbourhoods and Regeneration

There is a huge amount of data (raw and statistical summaries), across a vast range  of themes relevant for Hack the City, that are catalogued on the Data for Neighbourhoods and Regeneration website (http://data4nr.net).

Data is organised in the following top-level themes, each with their own sub-themes:

  • Population
  • Derivation & Income
  • Employment
  • Economy & Enterprise
  • Education & Skills
  • Health & Disability
  • Crime & Community
  • Environment
  • Access & Transport
  • Geographies & Benchmarking

Dataset records are collated from different sources, including data.gov.uk, Land registry, Office of National Statistics, The Places database, Department for Work and Pensions and many more. Many of these are only collected every few years, but there is a handy Recently Added section that gives an idea of current figures.

Local Information Systems are provided by geographical region.  National Indicator Sets, announced as part of the 2007 Comprehensive Spending Review to monitor local progress, are also linked in the following themes:

The website is an official commission and catalogue of the Department of Communities & Local Government, developed by Oxford Consultants for Social Inclusion (OCSI).

Education Datasets and Resources

Education is one of the featured themes of the second Hack the City.  Hacks to help parents with any of the following are eligible for the Open Data Challenge Series, and a stab at £5k to £50k in development prizes:

  1. Finding or expressing a preference for a school
  2. Choosing a subject or other learning priorities
  3. Engaging with their children’s learning

To help, the ODI and Nesta have compiled a great suite of datasets.  These are summarised below to give an idea of the scope of data available.

The full list, including individual download links, are on this Google spreadsheet.  Most of them are provided with some handy context information.  The spreadsheet also has some a bunch of ideas for inspiration on apps and hacks that could be prototyped.

Thanks to Chris Hopkinson for trawling the list and compiling a comprehensive archive of the core education data. You can download the 350Mb of recent datasets from Dropbox. We’ll have these available on a local filestore for Hack the City to avoid download congestion on the day. We’re also planning to get them into the Gangplank platform, so you should also be able to review the data schemas across the suite more easily.

Schools performance datasets School performance data at all key stages. Data covers: school performance, characteristics and spend per pupil data and for academies, their latest set of financial accounts. Entry level qualifications and attainment datasets available here too
Location of educational establishments Grid referenced location of educational establishments Source: Department for Education and Skills (DfES), ONS Access to Services Team Publisher: Neighbourhood Statistics Geographies: Grid Reference Geographic coverage: England Time coverage: 2003, 2005 Type of data: Administrative data Notes: The information presented here provides details on primary and middle deemed primary Local Education Authority maintained schools in England.
Pupil Absence in Schools in England This Statistical First Release reports on absence in primary and secondary schools, city technology colleges and academies.
Admission Appeals for Maintained Primary and Secondary Schools in England This SFR provides information about appeals lodged by parents during the academic year against non-admission of their children to their preferred school. It includes all appeals lodged during the academic year across all year groups. Figures are provided at both national and local authority level.
Destinations of Key Stage 4 and Key Stage 5 pupils Education destination measures will show the percentage of students progressing to further learning in a school, further education or 6th form college, apprenticeship or higher education institution a year after they have left school or college.
Qualification success rates for school sixth forms: 2011 to 2012 This statistical first release provides experimental statistics on qualification success rates (QSRs) for state-funded school and academy sixth forms in England. QSRs measure the proportion of academic and vocational learning aims, for 16- to 19-year-olds, that are started, finished and completed successfully. This is the first release on QSRs and it is the first year that national figures for QSRs have been published. QSRs are provided for learning aims at levels 1, 2, 3 and ‘4 or higher’ that were completed in the 2011 to 2012 academic year.
Permanent and fixed period exclusions from schools in England: 2011 to 2012 academic year This statistical first release (SFR) provides information about exclusions from schools and exclusion appeals in England during 2011 to 2012
Secondary School Applications and Offers in England Information about secondary school applications and offers received by parents on National Offer Day as provided by local authorities.
School Capacity: Information on the number of places and the number of pupils in maintained Primary and Secondary schools and Academies
Special Educational Needs in England Provides information on the incidence and placement of pupils with SEN together with analyses on the characteristics of pupils by their stage of SEN
OPSN data on school performance at KS4 (GCSE). Focuses on quality of teaching in secondary schools across England detailing improvemnets in schools, subject entries, subject attainment. Also includes a link to a report summarising findings and patterns
Edubase EduBase is a register of educational establishments in England and Wales, maintained by the Department for Education. It provides information on establishments providing compulsory, higher and further education. EduBase offers a number of different services allowing you full access to the data, please contact our service desk for further information. Services range from infrequent or frequent access to data extracts, to the provision of specific tailor made datasets.
Attainment by Pupil Characteristics Attainment at all key stages, by Pupil Characteristics (specifically gender, ethnicity, eligibility for free school meals (FSM), special educational needs (SEN) and English as a first language)
National Curriculum Assessments at Key Stage 2 in England Provides provisional information on the achievements of eligible pupils (typically 11 year olds) in the National Curriculum assessments at Key Stage 2 and 3 (KS2 and KS3). At KS2, assessments are based on tests and teacher assessments. At KS3, there are only teacher assessments as formal tests have been abolished.
Income and expenditure in local authority maintained schools in England: 2011-12 A national summary of schools’ income and expenditure for the financial year 2011 to 2012, utilising the full range of data schools provide to the Department for Education in their consistent financial reporting returns.
GCSE and Equivalent Results, England Provides the earliest information on the overall achievements of young people in GCSE and equivalent examinations.
A level and other level 3 results in England: academic year 2012 to 2013 (provisional) This release provides advanced level results (A level and other level 3 results) of young people (aged 16 to 19) in England.
Participation in education, training and employment by 16- to 18-year-olds in England, end 2012 This Statistical First Release (SFR) provides provisional end 2012 estimates
of participation in education, training and employment and those who are not
in education, employment or training (NEET) for 16, 17 and 18 year olds in
England. It also updates the end 2011 estimates from SFR 12/2012 published
in February 2013.
Youth Cohort Study & Longitudinal Study of Young People in England Statistics based on survey responses to YCS and LSYPE and brings together data about the family environment, attitudes to school, risky behaviours, engagement, attainment and post-16 participation. This publication reports on the same group of young people annually until age 19. The current group is now 19 and will be reported on in July 2011. A new study has not yet been commissioned and no publication is scheduled for 2012.
Open Street Map Full open street map datasets
Daily pollutant levels Maximum pollutant levels recorded for the 24 period Source: UK National Air Quality Information Archive Publisher: UK Air Quality Archive Geographies: Site Geographic coverage: England Time coverage: 2008 Type of data: Administrative data
Road transport energy consumption at regional and local authority level Consumption statistics for fuels used in road transport at regional and local levels are available below. In March 2008, this dataset gained National Statistics status. This applies to all data from 2005 onwards. Please note that the 2002, 2003 and 2004 datasets are still classed as experimental statistics.
Traffic, Speeds and Congestion
Independent school inspections and outcomes Publication of the results of the independent school inspections and outcomes including regulation compliance.
Source agency: Office for Standards in Education, Children’s Services and Skills
Index of Deprivation 2004 – Income Deprivation Affecting Children ID 2004 Income Deprivation Affecting Children supplementary index (number of children in households in receipt of means tested low income benefits) Source: Office of the Deputy Prime Minister (ODPM): ID 2004 Publisher: Communities and Local Government (CLG) Geographies: Lower Layer Super Output Area (LSOA) Geographic coverage: England Time coverage: 2004 (using 2001 data) Type of data: Administrative data (with statistical transformations applied)
Income Deprivation Affecting Children Index 2007 The Index of Multiple Deprivation, which was produced at LSOA level in 2007 and 2004, combines seven distinct domains of deprivation together to give an overall impression of the level of deprivation experienced by an area. The Living Environment domain combines 4 indicators to give an overall score for the level of deprivation in the quality of the local environment. The indicators used in the latest update of this domain are; – Social and private housing in poor condition – Houses without central heating – Air quality – Road traffic accidents involving injury to pedestrians and cyclists More information about this domain can be found in Chapter 2, Section 8 of the English Indices of Deprivation 2007 Report.
Cycle routes A digital geographical description of the cycle path network that is used in the Transport Direct cycle journey planner. The data describes the cycle route geometry and a variety of cycling features on cycle paths and roads, such as the presence of cycle lanes and toucan crossings. The road data is referenced to the Ordnance Survey digital road network and doesn’t include road geometry. The data is free and is made available under the Open Government Licence. The data will be refreshed every few months, taking account of feedback from users and local authorities.
Special Educational Needs, Children in Care: Pupil Absence, exclusions and SEN Numbers of children looked after for at least twelve months, and general information about their education, including whether they have Special Educational Needs (SEN) whether have been absent for at least 25 days or whether facing permanent exclusions
Truancy: Penalty notices, fast-track, parenting contracts & parenting orders Download records of penalty notices, parenting orders and parenting contracts issued by LAs, as well as details of cases entering the fast track to attendance case management process. This data is published annually.
PE and Sport Survey The PE and Sport Survey is in its seventh year and consists of a census of all schools and FE colleges in England, measuring levels of participation in PE and out of hours sport.
Pupil / Teacher Ratio Pupil teacher ratios for maintained primary and secondary schools
PISA The Programme for International Student Assessment (PISA) is a survey of the educational achievement of 15-year-olds organised by the Organisation for Economic Co-operation and Development (OECD). A total of 65 countries participated in PISA 2009.
School Workforce in England (including pupil: teacher ratios and pupil: adult ratios) January 2010 Information on the School Workforce in England. It combines information on teacher numbers and vacancies, sickness absence and ethnicity with information on support staff, pupil: teacher ratios (PTR) and pupil: adult ratios (PAR).

 

After the Hack

Earlier this month we welcomed hackday veterans and newcomers to the first Hack the City. Of course, it wasn’t about breaking into City Hall’s computer systems – it was about helping people find out about and engage with their city through the public data that’s available to them.

Some came to experiment with open data, others to knock together a civic hack, and a few to prototype a data-driven startup concept with a view to entering the Open Data Institute’s Challenge Series programme.

Before we get into where the different hack projects are a few weeks on, it’s worth remembering that hackdays aren’t just about the hacks on the day. Conversations that start on the day can lead to some great contributions and collaborations that continue or are realised only after the event. Some of those we’d love to see taken forward that started at Hack the City include:

The breadth of organisations getting involved on the day was great – the Open Data Institute and Nesta, the Home Office, as well as community organisations and commercial enterprises of varying scale.

That gave us a great mix of talent and interests in the room, including citizens, policy advisors, data owners, designers, entrepreneurs, marketers, journalists as well as software developers to turn ideas into reality.

In all, nearly 30 folk gathered to progress half a dozen hack projects, chosen from over a couple of dozen ideas to improve urban and civic experiences using open data that were put forward at the start of the day.

Thanks to everyone who came along or supported to make Hack the City a success.  If it has inspired you to get involved or you want to find out more about open data in your local area, you’re welcome to join us at future Open Data Sheffield meetups. They’re usually in the evenings on the third Monday of the month, but keep updated for the latest by following @opensheffield on Twitter.

Hack the City was produced by MundoJumbo for Open Data Sheffield, in partnership with the Open Data Institute and Nesta  as part of the Open Data Challenge Series.  You can find out more about Series’ Crime and Justice Creation and Innovation Weekend on 12-13 October from this piece by Simon Whitehouse, the first Series Lead.

On the next page is a rundown of the first Hack the City projects, including where to find out more about them or get involved. For blow-by-blow happenings of the day check this Storify.

Final Presentations and Awards

Video streaming by Ustream

Congratulations to all the teams who participated.

Huge thanks to our prize sponsors for some great booty – Make Do, Microsoft, MundoJumbo and Pimoroni.

You can find more footage from the opening presentations and the prizes on the Hack the City UStream channel.

Hope you have a great weekend!

 

Project: Don’t Park Here!

Andy Giggal is combining police crime data with parking data to produce a map of car parks with a high risk of car crime. This can potentially be used to develop an app or service and could also be used to by insurance services to inform their customers of safer places to park (and offer lower insurance premiums for those that follow the advice).

If you’d like to find out more about this project you can get in touch with Andy through the comments section below.

Sample display of car parks in areas of high recent crime activity.

Project: Gangplank Datashare

Daniel and Ian of Team Gangplank a test-project which aims to create a way for local authorities to import and play with their open data (and other peoples) without having to resort to using proprietary (and costly) software.

If you have any suggestions or would like to get in touch with the team, you can do so via Twitter (or leave a comment below).

Project: Get Around (Little Kelham)

 

Joe Dreimann describing the Little Kelham project started at Hack the City. The project aims to develop better ways to help people find their daily routes (transport, cycling or walking). The project will continue after Hack the City and will be meeting in Sheffield over the coming months. If you’d like more information, get in touch (especially if you’re Stubbs).

 

Project: Neighbourhood Crime Feedback

Team Joe are an impressive bunch of students from Sheffield Hallam University, they are Joe Fletcher (of the `Team Joe’ title), Ste Prescott, Jonny Booker and Tom Widdowson. Their project uses the Police open data API and they hope to get an iOS built today and a Windows phone version built tomorrow.

If you’d like to find out more about their project you can contact Ste or Tom via Twitter or on Github.