Update to Local Insight geographies and maintenance period

Featured

This November we are updating the geographic areas in Local Insight. In order to ensure this update goes smoothly, we will be limiting access to admin features on Local Insight for a short period of time. This upgrade to our geographic database will cause data for some of your custom areas to change. These changes will overall be very minor. The information in this blog details how, why and when these updates are happening.

Site Maintenance Period

This update is planned to commence on Thursday 15th November at 3pm and will finish on Monday 19th November at 2pm. During this period, you will still be able to access Local Insight, however, you will be limited to View Reports access. This means you will be able to view everything on the tool but will not be able to access any of the admin features which allow you to; create custom areas, request reports, upload services, upload data or manage your indicators. We will keep you updated throughout this process and make you aware when all is back to normal. Please do get in touch if you have any concerns or questions.

What will change?

Local Insight is built on the Census geographies: Middle Layer Super Output Areas (MSOA), Lower Layer Super Output Areas (LSOA) and Output Areas (OA). These are statistical geographies which were created for the Census in 2001 and then updated in 2011. Local Insight has historically used the 2001 Census geographies. This means that when you create custom areas and when you view data on the maps, you are viewing the 2001 boundaries. During this update, we will be upgrading to use the 2011 boundaries.

Not all boundaries changed during the 2011 update, in fact, only about 5% of areas nationally had any changes.

For more information on the background of Super Output Areas and the ways in which they changed; please see guidance from ONS and download their explanations.

Why are we doing this update now?

We didn’t move to the 2011 geographies straight away as until very recently data from a number of our key sources such as the Department of Work and Pensions (which update data very regularly) still published data at the 2001 area level.

During this time our data processes used weighted lookups from the old to new geographies in order to account for the 5% of areas that had changed. Take a look at our Knowledge Base for more information on our methodology.

We are guided by our users when it comes to the development priorities for Local Insight. 2011 area codes have been raised by a number of organisations, however, had not been voted as a number one priority. We understand as time progresses, that these updates become more pressing and we are excited to implement this update.

What does this mean for my custom areas and data?

Custom Areas

Will data change for my custom areas?

Those custom areas which contain OAs, LSOAs or MSOAs that changed in 2011 will be updated to reflect these changes. What this means is that you may see some very slight changes to the data for some of your custom areas.

How will I know which custom areas have been affected?

We are going to email the Local Insight lead of every organisation with a list of all the custom areas which have been updated. If you are unsure who the project lead for your organisation is, or would like to be included in this email, please get in touch on support@ocsi.co.uk.

Will my custom areas look different?

Some of your custom areas may look visually different after this update. This will depend on how your custom areas were created:

  • All custom areas which were created by; Drawing on a map, based on postcodes or created by the shape-file importer will not change visually.
  • Custom areas created by selecting standard areas may change visually if they contain any OAs, LSOAs, MSOAs  which were updated in 2011.

 

Custom Data

Custom datasets which you have uploaded yourselves may display differently and therefore may require re-uploading. We will send each Local Insight Group Admin a breakdown of the custom datasets affected and guidance for how to re-upload successfully.  

Public sites

As is standard, the public access Local Insight sites will reflect any changes made in your main group. Therefore, if you are keen to see how your custom data will be affected and make any adjustments before it is publicly shown, we suggest that you temporarily hide your custom datasets on the public site. This is entirely down to your discretion. If you cannot remember how to disable a dataset from being shown on the public site then check out this article on our Knowledge Base.

More information

If you have any questions on how this will affect your custom areas and data, please do get in touch on support@ocsi.co.uk or give us a call on 01273 810270.

Data updates in Local Insight

Plenty of data updates for you this month!

The below table is a snapshot of some of the key datasets which have been updated. To see a full breakdown of all datasets updated this month, see our Knowledge Base article containing a list of all the datasets available in Local Insight.

Updated indicators for Local Insight

Indicators on Source Reports Maps
Unemployment benefit, broken down by age, gender Department for Work and Pensions (DWP) Yes Yes
Jobs density (jobs as a percentage of the working age population) Business Register and Employment Survey (BRES) Yes Yes
Jobs, broken down by sector, public or private and contract type Business Register and Employment Survey (BRES) Yes Yes
Crime and offences, broken down by type Police UK (Police recorded crime figures) Yes Yes
House price, broken down by median and lower quartile House Price Statistics for Small Areas (HPSSAs) No Yes
Average house price, broken down by house type Land Registry Yes Yes
Number of property transactions, broken down by property type Land Registry Yes Yes

Current Indicators within Local Insight

To see a list of all of the current indicators available in Local Insight check out this Knowledge Base article containing a list of all the datasets available in Local Insight

Want to see more indicators within Local Insight?

We are always looking to add new indicators to Local Insight. So if you have any ideas of particular indicators you would like to see then let us know. Provided that the data is open data and published at small area level, so below Local Authority level, we will load the data in for you.

Get in touch!

If you have any questions about the data updates, please do not hesitate to get in touch with us on support@ocsi.co.uk or give us a call on 01273 810270.

Data updates in Local Insight

Updates for this month focus on unemployment indicators.

The below table is a snapshot of some of the key datasets which have been updated. To see a full breakdown of all datasets updated this month, see our Knowledge Base article containing a list of all the datasets available in Local Insight.

Updated indicators

Indicators on Source Reports Maps
Youth unemployment (18-24 receiving JSA or Universal Credit) Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit (JSA and Universal Credit) Department for Work and Pensions (DWP) Yes Yes
Jobseekers Allowance claimants, claiming for over 12 months Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit (JSA and Universal Credit), female Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit (JSA and Universal Credit), male Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit Department for Work and Pensions (DWP) Yes Yes
Older person unemployment (50+ receiving JSA or Universal Credit) Department for Work and Pensions (DWP) Yes Yes

Current Indicators within Local Insight

To see a list of all of the current indicators available in Local Insight check out this Knowledge Base article containing a list of all the datasets available in Local Insight

Want to see more indicators within Local Insight?

We are always looking to add new indicators to Local Insight. So if you have any ideas of particular indicators you would like to see then let us know. Provided that the data is open data and published at small area level, so below Local Authority level, we will load the data in for you.

Get in touch!

If you have any questions about the data updates, please do not hesitate to get in touch with us on support@ocsi.co.uk or give us a call on 01273 810270.

Data updates in Local Insight

Data updates this month include 1 new dataset and 113 updated!

The below table is a snapshot of some of the key datasets which have been updated. To see a full breakdown of all datasets updated this month, see our Knowledge Base article containing a list of all the datasets available in Local Insight.

Updated indicators

Indicators on Source Reports Maps
Unemployment benefit (JSA and Universal Credit) Department for Work and Pensions (DWP) Yes Yes
Attendance Allowance claimants Department for Work and Pensions (DWP) No Yes
Incapacity Benefit claimants Department for Work and Pensions (DWP) Some Yes
Pensioners in poverty (Pension Credit) Department for Work and Pensions (DWP) Yes Yes
Disability benefit (DLA) Department for Work and Pensions (DWP) Some Yes
Employment and Support Allowance claimants Department for Work and Pensions (DWP) No Yes
All VAT based local units Office for National Statistics (ONS) Yes Yes

 

New indicators

Indicator Source Reports Maps
Live births Office for National Statistics (ONS) No Yes

 

Current Indicators within Local Insight

To see a list of all of the current indicators available in Local Insight check out this Knowledge Base article containing a list of all the datasets available in Local Insight

Update your reports to fix data error

Please note, we would like to make users aware of an error with the data rate values for the following indicators:

  • All crimes (annual)
  • Violent crimes
  • Criminal damage
  • Burglaries
  • Robberies
  • Vehicle crimes

This error affects all reports generated between 9th April 2018 and 2nd August 2018. To regenerate the reports and amend the issue, simply request a new report for that custom area.

For advice on updating reports when new data is released, please see our article on Updating Your Reports. 

We take data quality and accuracy very seriously and apologise for any inconvenience caused. In order to prevent this type of issue from occurring in the future, we have added additional manual report checks when adding new or updated indicators in the tool. This is in addition to the comprehensive automated and manual testing we already run as part of the data import process. For more information on the full QA process for data added into the tool, please see our articles on The Quality Assurance Process For Data In Local Insight.

Want to see more indicators within Local Insight?

We are always looking to add new indicators to Local Insight. So if you have any ideas of particular indicators you would like to see then let us know. Provided that the data is open data and published at small area level, so below Local Authority level, we will load the data in for you.

Get in touch!

If you have any questions about the data updates, please do not hesitate to get in touch with us on support@ocsi.co.uk or give us a call on 01273 810270.

Data updates in Local Insight

We have a number of updates from the DWP, the DECC and the DfT, as well as two brand new indicators: Lower quartile and Median house price:

The indicators in the below table are now updated and live in Local Insight

Indicator Source Reports Maps
Jobseekers Allowance claimants, claiming for over 12 months Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit, broken down by JSA and Universal Credit (male/female) and age Department for Work and Pensions (DWP) Yes Yes
Households in Fuel Poverty Department for Energy and Climate Change Yes Yes
Travel time to nearest service by public transport/walk, broken down by service type Department for Transport (DfT) Yes Yes
Median house price House Price Statistics for Small Areas (HPSSAs): Office for National Statistics, HM Land Registry No Yes
Lower quartile house price House Price Statistics for Small Areas (HPSSAs): Office for National Statistics, HM Land Registry No Yes

 

Explore the new house price indicators in Local Insight 

To find the two new house price indicators in Local Insight click on the Group Admin tab and go onto the Manage Indicators page, search within the Unassigned theme for the full names of the indicators (see above). Then in order to view these new indicators on the map or dashboard you must add them to a theme and select them to be shown on the map. If you need a reminder of how to add new indicators to your maps and dashboards, check out this article in our Knowledge Base.

Current indicators within Local Insight

To see a list of all of the current indicators available in Local Insight check out this Knowledge Base article containing a list of all the datasets available in Local Insight

Want to see more indicators within Local Insight?

We are always looking to add new indicators to Local Insight. So if you have any ideas of particular indicators you would like to see then let us know. Provided that the data is open data and published at small area level, so below Local Authority level, we will load the data in for you.

Get in touch!

If you have any questions about the data updates, please do not hesitate to get in touch with us on support@ocsi.co.uk or give us a call on 01273 810270.

Take better screenshots in Local Insight with new Display Mode functionality

Visualising datasets on the maps in Local Insight overlaid with your custom areas and services is one of the core uses of the tool. We receive a lot of feedback that including images of the maps in reports, grant applications and presentations is a real benefit in being able to communicate a story with data.

To create these images, we always recommend that you use Snipping Tool (or Grab if you are a Mac user).

However, we are aware that it can sometimes be a fiddly and cumbersome task to get the image that you want – without including all the icons and site headers.

To help tackle this, we are excited to release new functionality that allows you to see your map full-screen, with all the screen furniture removed. This makes it far simpler to get that perfect screenshot, and you are able to see more of the maps at once – hoorah!

Who can use this functionality?

Any user of Local Insight, whether you are a View Reports User, Power User or Group Admin can benefit from the Display Mode functionality.

The DisplayMode functionality is also available on public sites (such as these ones from Wirral and Brighton & Hove).

ci - 4 as a jpeg

How does it work?

When you navigate to the Maps page, you will now see a Display button in the top right. Clicking on this will remove all screen furniture so that you can see the map in full.

Any area or service icons that you have loaded on the screen before pressing the Display button, will be shown when viewing in Display Mode.

You can still interact with the screen, so you can zoom in or zoom out and position the image exactly as you like.

From here, you can now take your screenshot, either using Print Screen or the Snipping Tool.

To return to view maps as normal, simply hit Escape on your keyboard.

It works when viewing data too

You can also use Display Mode when you view datasets on the map. Simply select a dataset from the Data icon and hit the Display button.

The legend will be displayed on the map in the top right-hand corner and all the remaining screen furniture will be removed.

Full guidance & feedback

For more information on using the Display Mode, please read through the Knowledge Base.

If you have any thoughts & feedback on this new functionality, we would love to hear it! Your feedback helps us improve Local Insight, to ensure that it’s meeting all your needs while keeping the tool intuitive and accessible by all.

You can get in touch with the Support Team on support@ocsi.co.uk or on 01273 810270.

Quarterly data updates from Land Registry and Department of Work and Pensions

Updated Indicators

We have updated a range of quarterly published indicators in Local Insight.  See the table below for a snapshot of the highlights or take a look at the full list of updated indicators on our Knowledge Base article.

Indicator Source Reports Maps
Average house price Land Registry Yes Yes
Number of property transactions Land Registry Yes Yes
Average house price for flats Land Registry Yes Yes
Older people social care benefit (Attendance Allowance) Department for Work and Pensions (DWP) Yes Yes
Attendance Allowance claimants, Higher Rate award Department for Work and Pensions (DWP) No Yes
Attendance Allowance claimants, Lower Rate award Department for Work and Pensions (DWP) No Yes
Attendance Allowance claimants aged 65-69 Department for Work and Pensions (DWP) No Yes

Quarterly Police UK updates

The crime indicators, published quarterly by Police UK, have been published a little later than usual this round. As a result, they will be updated in the next round of regular data updates which will be live in Local Insight mid month.

Current indicators within Local Insight

To see a list of all of the current indicators available in Local Insight check out this Knowledge Base article containing a list of all the datasets available in Local Insight

Want to see more indicators within Local Insight?

We are always looking to add new indicators to Local Insight. So if you have any ideas of particular indicators you would like to see then let us know. Provided that the data is open data and published at small area level, so below Local Authority level, we will load the data in for you.

Get in touch!

If you have any questions about the data updates, please do not hesitate to get in touch with us on support@ocsi.co.uk or give us a call on 01273 810270.

New functionality in Local Insight: Display a permanent boundary line

Local Insight provides you with data and maps for the whole of England, which is very handy when it comes to benchmarking and comparisons.  However, we also want users to be able to easily focus attention to their core service area. And this is where our latest functionality comes in!

You can now add a fixed standard boundary onto your Local Insight Group. This can be a Local Authority, a number of Local Authorities, a collection of MSOAs or a collection of LSOAs. This new functionality has been designed to enable you to customise your Local Insight group more and focus attention to your key service area.

The red line shows the Local Authority boundary of Hounslow which has been selected to be the permanent boundary on display. The black boundary line is a custom area.

The red line shows the Local Authority boundary of Hounslow which has been selected to be the permanent boundary on display. The black boundary line is a custom area.

How to add a fixed standard boundary?

All you need to do is email support@ocsi.co.uk and just let us know which standard area you would like to see. We will then add that boundary line onto your group.

What can you do with this new functionality?

With this new functionality you will be able to select a Local Authority, a number of Local Authorities, a collection of MSOAs or a collection of LSOAs to permanently overlay onto your map page as standard on your group. You will then be able to view a custom area on the map page simultaneously to this boundary line.

Please note: This change will affect all users across your organisation. Also, if you have a public access site, this boundary will be visible to those public users.

Individual users can then toggle this boundary line on and off when they are using Local Insight. To do this click on Settings and then click Hide the boundary. The toggling on and off of the boundary will not affect other users on the site.

The group boundary can be hidden by the individual user, which will not affect any other users on the site.

The group boundary can be hidden by the individual user, which will not affect any other users on the site.

Let us know

Any feedback on the process would be greatly appreciated. Do let us know at support if you have any questions.

ONS Population Estimate Revisions

ONS has made revisions to their mid-year population estimates for England and Wales from mid-2012 to mid-2016. For the vast majority of local authorities, these revisions have been very minor. However, for a small handful of authorities, the change is large enough to affect how decisions are made in the local area.

In order to take into account these changes, we have made revisions to all of the indicators in Local Insight which are derived from the ONS population estimates. This includes not just the population estimate figures themselves, but also any figure which uses the population estimates to calculate a rate e.g. Unemployment claimant count uses the working-age population from the ONS population estimates, combined with DWP data on counts of Universal Credit and Jobseekers Allowance claimants to calculate the unemployment rate. In total 196 of the 924 Indicators on Local Insight have been affected by the population revisions.

Click here for a full list of affected indicators.

Please note: there may be discrepancies between Local Authority and small area data

The revisions to the ONS population estimates have been released at Local Authority (LA) level only, with the population estimates for neighbourhood geographies (LSOAs, MSOAs, Output Areas etc.) still based on the unrevised estimates.

Revisions to the neighbourhood geographies are due to be published in Autumn 2018, but in the meantime, there will be inconsistencies between LA and MSOA/LSOA/Output Area data for the 196 indicators which are derived from ONS population estimates.

For example, the total population for all of the LSOAs in an LA will no longer add up to the total population of that LA as the LSOA data will be based on unrevised estimates and the LA data will be based on revised estimates. These inconsistencies could also potentially occur depending on whether your custom areas are built up from LSOA geographies or LA geographies.

Minimising the risk of misinterpretation

We have included health warnings for each of the affected indicators in the About the indicator pop-up and in the Introduction page of the report. These health warnings will remain in the metadata until the small area data is revised to be consistent with the LA data in Autumn 2018.

Out of 348 local authorities, only 28 have had their population estimate for mid-2016 revised by 1% or more; a minority of areas have seen notable changes to their overall population estimates. The population in one LA (Wandsworth) has been revised upwards by more than 5,000 people, while four LAs have been revised downwards by more than 5,000 people (Cambridge, Haringey, Oxford and Westminster).

Downward revisions have mostly resulted from higher emigration estimates for areas containing international students and lower immigration estimates for Inner London. For more details see ONS’ Revised population estimates for England and Wales: mid-2012 to mid-2016

Get in touch

If you require any further clarification, please don’t hesitate to get in touch with us at support@ocsi.co.uk or give us a call on 01273 810270.

Data Updates in Local Insight

A small number of updates this time, as there will be more coming at the end of the month.

Updated Indicators

Indicator Source Reports Maps
Youth unemployment (18-24 receiving JSA or Universal Credit) DWP Yes Yes
Claimant count age 50+ DWP Yes Yes
Unemployment benefit (JSA and Universal Credit) DWP Yes Yes
Jobseekers Allowance claimants, claiming for over 12 months DWP Yes Yes
Unemployment benefit (JSA and Universal Credit), female DWP Yes Yes
Unemployment benefit (JSA and Universal Credit), male DWP Yes Yes
Unemployment benefit DWP Yes Yes
National Insurance numbers issued to non-UK nationals DWP Yes Yes

ONS population estimate revisions

You may be aware that the ONS has revised their population estimates and published these at LA level. We are currently working on adding these revisions into Local Insight. There will be more information on this process and what it means for your data and areas over the next few weeks. We will mail out all users specifically about this.

Current indicators within Local Insight

To see a list of all of the current indicators available in Local Insight, check out this knowledge base article containing a list of all the datasets available in Local Insight

Want to see more indicators within Local Insight?

We are always looking to add new indicators to Local Insight. So if you have any ideas of particular indicators you would like to see then let us know. Provided that the data is open data and published at small area level, so below Local Authority level, we will load the data in for you.

Get in touch!

If you have any questions about the data updates, please do not hesitate to get in touch with us on support@ocsi.co.uk or give us a call on 01273 810270.