Data updates

Featured

Community Insight is updated every month with new data. To see a list of all the datasets in Community Insight check out this article on our Help Centre

Here you can find archived links to previous data updates:

Community Insight England Community Insight Scotland
Community Insight Wales
2021-Sep 2021-Sep 2021-Sep
2021-August 2021-August 2021-August
2021-July 2021-July 2021-July
2021-June 2021-June 2021-June
2020-May 2020-May 2020-May
2021-Apr 2021-Apr 2021-Apr
2021-Mar 2021-Mar 2021-Mar
2021-Feb 2021-Feb 2021-Feb
2021-Jan 2021-Jan 2021-Jan
2020-Nov 2020-Nov 2020-Nov
2020-Oct 2020-Oct 2020-Oct

Driving a prosperous recovery

Writing in the Financial Times, Henrietta Moore, founder and director of The Institute for Global Prosperity (IGP) at University College London spoke on the need to “build back better” based on a more nuanced vision of prosperity, rooted in local communities.

Referring to a four-year project by the IGP to create a prosperity index for east London, she wrote that “Instead of measures of growth, productivity and income, the index identified 15 headline indicators that reflected the lived experience of prosperity for people in these places. It established that “human infrastructure” — public transport, affordable or free childcare, social care and low or no-cost digital services — was what made lives liveable and laid the foundations for a prosperous life.[1]

Indicators in the index were selected based on a citizen-scientist led research project, and included good quality and secure jobs, household security and affordability, sense of community and healthy, safe and secure neighbourhoods. The project re-iterated that high-level indicators like GDP and productivity are entirely abstract from what it feels like to live a prosperous life, in a distinct place.

The social housing sector is looking to the long-term recovery from Covid-19, and could benefit from measuring its own success against such individual and community based indicators. What makes for prosperity will look different in the communities of East London who were a focus of the IGP study, in comparison to a rural community in North Wales.

In practice this means thinking strategically all the way down to the neighbourhood level, which allows social housing organisations to make targeted interventions. Many of Community Insights indicators relate to the 15 themes identified by the IGP.

Good and Secure Jobs

One of the themes that came through the IGP research was the importance of good jobs in peoples experience of prosperity. One indicator on Community Insight is Universal Credit Claimants – In Employment.(latest data from June 2021). The colours on the map show % of working age people receiving Universal Credit around the study sites the IGP chose in East London.

Specific down to a LSOA level (refers to Lower Layer Super Output Areas – typically about 650 households), it’s clear that a high proportion of local people of working age are in receipt of universal credit, in this part of East London.

Healthy, safe and secure neighbourhoods

The map looks different when we look at another IGP theme, healthy, safe and secure neighbourhoods. One of the sub categories was access to open and green space, and the indicator from Community Insight below is AHAH Green Space (active) with the colours on the map showing distance to Green spaces (km)

For a social housing organisation which is looking to build back better with a focus on prosperity for residents, these data sets can play a role in informing targeted interventions. In the case of access to green space, its clear that specific neighbourhoods have diminished access. Working with and through local residents, solutions might include building green spaces into new developments or turning marginal sites into pocket parks.

Global goals made local

The IGP report references the UN Sustainable Development Goals (SDGs) role in moving away from conventional abstract measures of prosperity like GDP. This is a radically different vision of prosperity to the orthodox understanding of prosperity as material wealth that dominated global policymaking throughout the 20th century”.[2]

Whilst the SDGs are global in ambition, many play out at a local level and in individual lives. Whilst its hard to see how Gross Domestic Product means much in our everyday lived experience, goals such as ‘Gender equality’ are experienced through employment outcomes, public transport and access to affordable childcare.

With this in mind, its no surprise that social housing organisations are accessing ESG funding to deliver against the SDGs and other frameworks. Rooted in specific places, social housing organisations as anchor institutions are well placed to deliver people-centred prosperity through affordable housing, placemaking and community investment.

For investors serious about meaningful impact, rather than abstract metrics on an accounting ledger, social housing can be a force for good as a locally based actor in people’s lives.  A good score in an ESG framework needs to be visible in individual peoples and communities’ lives, otherwise it risks being as abstract as GDP.

The role of Community Insight

Our Community Insight tool built for targeted decision making, utilising over 1000 indicators all the way down to the LSOA level. When coupled with theory of change on how to leverage social value, health and wellbeing, it can be a powerful tool to drive the sort of community level prosperity outlined in the IGP’s report.

Social housing organisations that can demonstrate how they are meeting global goals in local places stand out as serious about people centred prosperity. As a tool, Community Insight (alongside resident engagement) provides the sort of data to direct community investment where it can leverage the most impact.

[1]https://www.ft.com/content/fb900edd-9849-4bc1-a9e8-a4a4cf459677

[2] https://static1.squarespace.com/static/5a0c05169f07f51c64a336a2/t/5d03c62b56b1ce0001bf6266/1560528440423/LPI_Report_single_140619_update.pdf

 

It’s now easier to create stock groups based on postcodes in Community Insight

You can now create stock group areas based on postcodes where you don’t have stock.

Previously, you could only create stock groups based on your stock’s postcodes. We’ve expanded this feature to allow you to create stock group areas based on any postcode regardless of whether there is stock within it or not. 

The 3 main improvements are…

1) You can now create stock groups based on any postcode, not just postcodes in your stock list.

2) You can see the boundary line around your stock group area so that it is clear where data for that area derives from.

3) Your postcodes are validated on import so you can be sure they are accurate.

Create stock group areas based on any postcode

Previously you could only create stock group areas using postcodes that were already uploaded in your group’s stock list. Hence why they are called stock groups, as they were areas based on where you have stock. This limited the areas that you could create.

Now you can create stock group areas based on any postcode. For example, create an area where you are planning on adding stock and view data for that community.

See the boundary line around your stock group areas

Whereas previously, stock group areas created using this method displayed as stock icons on the map, now the areas display with clear boundary lines around the constituent regions covered, alongside any stock icons to represent the stock you have in that area. 

Data is still created for these areas in the same way, more on that below, but now you can see a more accurate depiction of the area you have created on the map. 

The image on the left shows how postcode stock groups previously displayed on the map. The image on the right shows how the same stock group area now displays on the map.

How Community Insight calculates data for stock group areas based on postcodes

Community Insight identifies all the Output Areas (OAs) covered by the uploaded postcodes and then calculates the data based on those component OAs. Community Insight then apportions data for that collection of OAs and their value is the value for your stock group areas.

Not sure what Output Areas are? 

Output Areas (OA) are standard areas that were primarily created for the publication of the Census. They are fairly homogeneous in terms of population size – ranging from 40 to 250 households. The number of postcodes per OA is always changing as new postcodes are added. There are roughly 11 postcodes per OA and no single postcode will cover multiple OAs.

Please note: Your existing stock group areas created using postcodes have been updated to display in the new format with a boundary line around the areas covered. 

Some historic stock group areas created, based on stock postcodes, may no longer show anything on the map. This will be the case if you updated your accounts’s stock list and in the process removed the stock postcodes used to create that stock group area. If you want to recreate these historic stock groups, we can support you to do this – please email support@ocsi.co.uk.

Going forward this issue will no longer happen as the stock feature has been decoupled from the postcode area feature. Therefore, any stock groups created based on postcodes will remain static, allowing you to see data for them regardless of the stock you have in that area.

Postcodes validated on import

When creating stock group areas based on postcodes you can either paste in a list of postcodes or upload a CSV.

In both methods, Community Insight checks the postcodes to ensure that they are valid. If there are invalid postcodes (e.g typos, postcodes from other countries), you will see an error message detailing the rows that have invalid postcodes. You can then go back edit those postcodes and reupload.

Reminder of how to create stock group areas…

To create a stock group area you must have Power User or Group Admin access.

Read our Help Centre for more support on creating stock groups in Community Insight.

Get in touch!

If you have any questions or feedback then get in touch with us on support@ocsi.co.uk or call us 01273 810270.

The implications of Census 2021 data on Community Insight

Although the census 2021 is complete, the ONS won’t be publishing outputs until March 2022 at the earliest. But when the data’s finally released, here’s what you can expect to see on Community Insight.

The first census release is likely to cover data on the total population at Local Authority level. This will then be followed by data on the major themes of the census, such as ethnicity, qualifications, economic activity, and general health. Following this we will see the release some of the small area data outputs – LSOA and MSOA.

The final release is likely to include datasets that cut across different themes. For example, you may be able look at datasets on age and homeownership or ethnicity and health in relationship to each other. Included too in this final release will be origin and destination data – an examination of travel to work patterns and migration patterns.

New Developments

The ONS is planning to develop a dissemination tool, which will allow users to create bespoke tables that cut across different sensor table themes. Users will be able to ask bespoke questions of the census, pertinent to their exact needs and combinations of data required, resulting in bespoke data tables for analysis. This is an exciting development which we hope to see applied to Community Insight.

New Geographies

Changes in Output Area geography:

  • Roughly 5% of Output Area (OAs) boundaries will change (2.5% changed in 2011)
  • Some LSOA and MSOA definitions will also change
  • All revised OAs will nestle into a stable hierarchy of Lower and Middle layer SOAs

As part of the Census 2021 update, the ONS are planning to make some changes to the Output Area geographies, with potentially up to 5% of all Output Area boundaries changing. This will have knock on effects for the LSOA and MSOA boundaries, as all areas will continue to nestle within larger boundaries. This is critical to Community Insight as Output Area boundaries are the building blocks for all the stock groups created by users.

There are three main circumstances where a change in OA boundaries may occur:

  1. Where the population has changed dramatically – a defining principle for OAs is that they are comparable in size and composition.
  2. To align Output Area boundaries more closely with the latest ward and parish boundaries to facilitate better data at these levels – so that fewer wards and parishes are based on ‘best-fit’ geographies.
  3. Where OAs are split by Local Authority boundary changes that have occurred since the 2011 Census, ensuring that they are aligned to the changed Local Authority boundaries as of 2022.

The pandemic may have resulted in unexpected changes to population as many people are not currently residing within what may have been their normal place of residence. For example, it’s estimated that a large number of people that are normally resident within the UK are currently living abroad, particularly foreign students and migrant workers, meaning we may see more changes in population patterns than were observed in the last census.

Impact on Community Insight functionality

To ensure that we are ready to load census data into Community Insight and that all the data in the system is based on the most up-to-date and relevant geographies, we propose to update Community Insight to run on Census 2021 OA/LSOA and MSOA geographies in advance of when the data for the Census 2021 is released at this geographical level. We will need to convert all stock groups built from component areas that have changed, so that they will be based on the new OA/LSOA/MSOA building blocks.

We will also need to ensure that we can continue to read in data for both new and old geographies, to support our users who hold their own data for old geographies, as well as for any data suppliers who are still publishing their data for old geographical boundaries. Where data is published for old geographies, we will convert it to the new geographies on the site.

Moving to the new Output Area boundaries will have some implications for users. Those stock groups which contain OAs, LSOAs or MSOAs that change in 2021 will be updated to reflect these changes. Users may therefore see some slight changes to the data for some of their stock groups.

For those stock group areas created by standard area, users may see some changes to the way the boundaries on the map are displayed. Where change occurs, we will make sure that we notify any affected users of their custom area changes.

There will also be some minor changes to the thematic maps, with small changes to MSOA and LSOA boundaries. Because the number of areas will change, some areas may see a change in quintile rank where they were previously ranked on the margin of two quintile bands. However, this will be a small change that will only affect a handful of areas.

We will need to convert all older data to the new geographies and all new data published for old geographies, to align with the new boundaries, so there will be some small differences from the published data for data released for the old boundaries.

Lastly, any custom datasets users have uploaded may display differently and therefore may require re-uploading.

Data Changes

The census 2021 will also bring updates to much of the data within Community Insight. This will see our largest single update to data we have ever managed as we expect to update up to 356 census indicators.

The new census population figures will have knock on effects for the Mid-Year population Estimates. As in 2011, the Mid Year Estimates will be revised to ensure they are aligned with the population base as counted in Census 2021 – this re-alignment will also affect the historical population estimates between Census 2011 and Census 2021. This will affect not only the population indicators themselves, but also any indicator which used population estimates as a denominator, with at least 275 indicators potentially affected.

New Data Opportunities and Discussions

As well as updates to existing indicators, there are likely to be new sources of interesting data from the census.

For example, there are new questions relating to sexual orientation and gender identity which will enable analysis of the size and socio-demographic characteristics of the LGBTQI+ communities in different local neighbourhoods.

ONS are also planning to develop a new flexible dissemination system for creating tables. This will make it easier to create bespoke tables which cut across multiple census themes, such as identifying areas with high concentrations of young adults with both low skills and high unemployment.

The new dissemination tool will also mean that the cross tabular data will be made available much earlier than it was last time around, when cross theme tables were some of the last outputs to be released. We will engage with users closer to the time of release as to what sort of cross theme data users would like to see in Community Insight.

Another potentially exciting development is the possibility of linking census data with key administrative data at record level to produce multi-variate small area measures of interest.

The ONS consultation events so far indicate that they are having discussions with the Valuation Office Agency about producing a more sophisticated overcrowding measure that considers room size. They are also in discussion with HMRC and DWP about producing a robust small area household and personal income measure.

If you’re interested in finding out more about Community Insight, get in touch with Lara Phelps for a demo and free trial.

Office Christmas closure

OCSI will be closed from Monday 21 December to Friday 1 January inclusive.

We will not be able to respond to any Community Insight support requests during this time. We will answer emails when the office re-opens Monday 4 January.

We hope you have a lovely break over the festive period!

Download all the data in Community Insight at MSOA level

We have extended the All Data Download feature so that you can now download all the data (more than 1000 datasets) in Community Insight at MSOA level as well as at LSOA level. 

We hope that access to the raw data at both LSOA and MSOA level will make further analysis even easier. 

How to download the data 

Both the MSOA and the LSOA data downloads are accessible as CSV files on the Reports tab. The files will be updated on a quarterly basis, so that you always have the latest data at your fingertips. We will send an email notification to all users every time the files are updated.

What does the file contain?

Data download for all LSOAs in England – This file contains data for all the indicators in Community Insight at LSOA level, as well as the associated metadata (e.g. name, description, date, source). 

Data download for all MSOAs in England – This file contains data for all the indicators in Community Insight at MSOA level, as well as the associated metadata (e.g. name, description, date, source). 

How to find the MSOAs you care about

Column E indicates the Local Authority each MSOA resides in. You can filter this column to show only the MSOAs for a selected Local Authority / number of Local Authorities. This will make the file more manageable. 

Further analysis

The All Data Download makes further analysis easier outside of Community Insight. For example, anybody within your organisation could very quickly and easily:

  • Use Excel or other visualisation tools to produce your own charts and tables for use in your analysis.
  • Identify which (if any) of your LSOAs/MSOAs are in the 10% most deprived nationally for the index of multiple deprivation.

Or you could delve even further into the data, using the Rank command in Excel for benchmarking or using conditional formatting to see whether the areas you care about score relatively high or low compared to other areas. 

Download data for other geographies  

To download data for your stock groups in Community Insight you can build a custom dashboard and export the data.

Full guidance and feedback

For more information on using the All Data Download, please read through the Help Centre.

If you have any thoughts and feedback on this new addition then get in touch on support@ocsi.co.uk. We’d love to hear how you are going to use the All Data Download and if there is anything we can do to make the process of accessing and analysing data any easier.

Time series data for unemployment benefit in Community Insight

Explore how unemployment changed during the COVID-19 pandemic and lockdown with times series data in Community Insight. 

The Department for Work and Pensions publishes Unemployment benefit (JSA and Universal credit) every month. In turn, we update the data in Community Insight to show the latest monthly snapshot. 

Given the dramatic changes to unemployment and the effects that it may have on your communities, we have added in the previous 3 months unemployment benefit data as individual indicators, so that you can see the month-on-month change for your areas. These datasets can be displayed on the map and downloaded for your stock groups.

Alongside the usual monthly updates for Unemployment (June 2020), we have added 3 historical time-points for the indicator Unemployment benefit (JSA and Universal credit):

  • March 2020
  • April 2020
  • May 2020

How to view this data on Community Insight

The map

  1. Click on the Data button
  2. Search Unemployment using the search bar
  3. You will see the most recent Unemployment benefit (JSA and Universal credit) indicator for the month of June 2020 and the 3 historic timepoints listed beneath

Click on image to see full size

Download the data for all 4 timepoints for your stock groups

  1. Click on the Data button
  2. Search Unemployment using the search bar
  3. You will see the most recent Unemployment benefit (JSA and Universal credit) indicator for the month of June 2020 and the 3 historic timepoints listed beneath
  4. Select the first time point
  5. Click on the Info button
  6. Click Data for your areas (this will open up a popup with data for your stock groups)
  7. Click Download this dataset in CSV format
  8. Repeat this process for the other 3 timepoints 

Click on image to see full size

Please note in the Data for your areas popup the table of data has two columns. The first column shows the percentage figure, the second column shows the count data. When you export the data to a CSV, only the percentage figure is exported. Adding the count data to the export is one of our development priorities and will be coming soon. 

On the Dashboard

You can only view the latest time point for Unemployment benefit (JSA and Universal credit) on the dashboard

In the reports 

This data has not been added to the reports. The reports do however already contain a chart that shows how Unemployment benefit (JSA and Universal credit) has changed since 2004 (page 10).

Figure: Unemployment benefit (Jobseekers Allowance/Universal Credit) claimants Source: Department for Work and Pensions

Figure: Unemployment benefit (Jobseekers Allowance/Universal Credit) claimants
Source: Department for Work and Pensions

Would you like to see more time series data in Community Insight?

We are looking at options to include more time series data within Community Insight. Please email support@ocsi.co.uk with any suggestions for what would be useful and to register interest in taking part in future user research on this topic. 

Removed Monthly Change in Unemployment Indicator

We have removed the indicator Monthly Change in Unemployment. The new indicators for Unemployment benefit (JSA and Universal credit) for the last four months supersede this indicator. For those groups who had it assigned to a theme, it will no longer be available. 

Further reading

If you are interested in how COVID-19 has affected employment and the economy more broadly, take a look at some of our recent analysis: 

How to upload non-numerical survey data to Community Insight

Community Insight offers a number of ways to add your own organisational data into the system. The Upload your data functionality allows you to import datasets that display on the maps in the same way as the standard datasets that we include in the tool for you.

You can use this functionality to upload some non-numerical results of surveys that you run with tenants with a little bit of data reformatting.

This guide will run you through the process of uploading your data in this way.

You will need to be a Group Admin to upload your own data to Community Insight.

A choropleth map displaying percentage data on current smokers

 

1. Is your data suitable for uploading in this way?

You will first need to determine whether the data you want to upload is suitable for the Upload your data tool. 

The dataset must have:

  1. Geographic data: When uploading survey data, you will most likely want to use postcodes
  2. Binary data: The survey question must have only two possible responses.

Suitable:

As part of an annual residents survey, you collected respondents’ postcodes and asked ‘are you a current smoker?’

  1. In this case, you have suitable geographic data for every respondent (their postcode)
  2. The respondent can only answer ‘yes’ or ‘no’ to this question, so it is suitable to upload into Community Insight.

Not suitable:

As part of an annual residents survey, you collected respondents’ postcodes and asked ‘what is your ethnic group?’

  1. In this case, you have suitable geographic data for every respondent (their postcode)
  2. The respondent could give a wide range of answers to this question and so it is not suitable to load in as the tool cannot import categorical data.

If you are unsure whether your dataset can be imported in this way, please get in touch at support@ocsi.co.uk and we can talk it through with you.

2. Set up your metadata

Go to:

  • Group Admin
  • Manage your data
  • New dataset

General guidance for setting up metadata can be found in the Help Centre.

When setting up the metadata for survey responses, take note of the following points:

  • Description: Make it clear that the data has come from survey responses. You may want to include details on the question that was asked and the sample size
  • Percentage suffix: When you import the data into the tool it will display as a percentage. Make sure you add the percentage sign to the Suffix box when asked
  • Decimal points: Depending on what you are uploading, you may want to include one or two decimal places
  • Aggregation method: You will be asked ‘how should we create data for higher areas from your uploaded data?’ You must select Averaging here
  • Suppression: If you are uploading postcode level data that is potentially sensitive, you can select a suppression threshold (Please see the Help Centre for more information on suppression).

3. Format your data

When it comes to importing your data, you can do this by uploading a CSV file or through copying and pasting values.

In each case, you will need to ensure that you have two columns of data correctly formatted in an Excel document. 

  • Geographic data: In one column, you will need a postcode (or other geographic code) in each row. 
  • Binary, numerical data: In another column, you will need your survey responses in numerical format.

4. How to turn your survey data into numerical data

Let’s go back to the earlier example of asking ‘Are you a current smoker?’ Each respondent would have answered ‘Yes’ or ‘No’.

In order to import the data into Community Insight, you need to turn this into numerical data. To do this, all the respondents that answered ‘No’ should have the value of 0 and all the respondents that answered ‘Yes’ should have the value of 100.

Shows three columns in an Excel spreadsheet displaying survey data, numerical data and postcodes

Tip: You can bulk change all your responses to numerical data using the Find and Replace functionality in Excel.

  • Find all instances of ‘Yes’ and replace all with 100
  • Find all instance of ‘No’ and replace all with 0

Screenshot showing the Find and Replace all functionality in Excel

Alternatively, you could also use an IF statement to do this. This may be a better option if your survey results are denoted by single letters (eg. ‘Y’ and ‘N’) as you may end up replacing some of your postcode data using a simple ‘Find and Replace all’.

5. Import data

You can now import your data into Community Insight. At this stage, it doesn’t matter if you have more columns than you need – you will be able to filter these later.

If your spreadsheet includes formulae (eg. if you have used an IF statement), you must save the file as a CSV file, rather than Excel, before importing.

Follow the on-screen instructions to import your data. Further guidance is available in the Help Centre:

6. Add dataset to your maps and dashboard

Now that your data has been imported, you can add it to your Map and default dashboard using the Manage Indicators functionality.

The data will be displayed on your maps and dashboard as percentage figures.

Improvements to Community Insight to help save you time

We are excited to introduce two new improvements that enable you to:

  • Search for indicators on the map more easily
  • Identify your areas with ease using MSOA names 

Search for indicators on the map more easily

Community Insight has over 1000 indicators. With so much data available, being able to find what you are looking for quickly is important.

We have added a search bar to the Data dropdown on the Map page so that you can hone in on what you are interested in, in far fewer clicks.

Data search bar

How to use

  1. Click on the Data button to open the menu of themes and their indicators 
  2. The search bar is at the top. Type in any text and the indicators that contain that string of text will be displayed under their theme heading
  3. Click on an indicator name to view it on the map
  4. To show the full menu of indicators again, delete the text in the search bar 

Please note: Not all indicators within Community Insight are shown within the Data menu by default. There are over 1000 datasets in Community Insight and the Group Admin user(s) select which ones are shown. If a user searches for an indicator that is available in Community Insight but not assigned to a theme then nothing will come up in the search.

 

Identify your areas with ease using MSOA names 

MSOAs are an integral geography in Community Insight. You can view indicators on the map at MSOA level and you can create stock groups out of MSOAs. However, MSOA codes are not easily recognisable – they are made up of two parts: The parent Local Authority and a string of numbers. For example, Westminster 018. 

Meaningful Names

The House of Commons Library has created a set of meaningful names for MSOAs (also available on an interactive map). We have added these names into Community Insight to make it easier for you to find the areas you are interested in. As part of this, we have also changed the LSOA names to incorporate the name of the parent MSOA to help you have a better idea of where the LSOA is located.

 

Previous MSOA code New MSOA names 
Westminster 018 Strand, St James & Mayfair – Westminster 018
Westminster 019 Knightsbridge, Belgravia & Hyde Park – Westminster 019
Westminster 020 Central Westminster – Westminster 020


Where can you see these new names?

The names can be found in two places on Community Insight: 

  • When hovering over areas on the map
  • When creating stock groups out of MSOA or LSOA areas

 

When hovering over areas on the map

  1. Choose an indicator from the Data button and select to display it on the map 
  2. Zoom in to view the data at either MSOA or LSOA level (the Info popup will inform you at which level you are viewing the data)
  3. Minimise the Info popup, and then hover over the areas on the map
  4. In the top right hand corner will be a small box that displays the MSOA/LSOA area name and the value for that area

MSOA hover

 

When creating stock groups out of MSOA or LSOA areas

In Community Insight, you can create stock group areas made up of MSOAs and LSOAs. The new names will now display in the stock group creation popup. 

  1. Click Group Admin Manage stock groups
    1. Click Add stock group
    2. Select Area Type Based on standard area
  2. Select to browse the list of MSOAs or LSOAs

MSOA names

Please note: Only Group Admin and Power Users can create stock groups in Community Insight.

If you are unfamiliar with the terms LSOA and MSOA, these are statistical geographies created for the Census. Read more about them in our blog: LSOAs, LEPs and lookups : A beginner’s guide to statistical geographies.

Get in touch!

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

Add additional information to your stock data

We have made some major improvements to the Stock feature on Community Insight so that you can now add additional information to your properties and view that on the maps page.


blog 1

The enhanced functionality allows you to add more information to Community Insight so that you can see information for individual properties. Coupled with the socio-economic data available within the system and the locally held datasets you can add in, this improved functionality contributes to making Community Insight a one-stop shop for local information. 

 

The developments focus on:

  • Enhancing the Stock functionality to allow you to add additional information to your individual properties
  • Improving the error feedback and the importing process so that you have a more streamlined experience
  • Improving the speed so the maps page loads quicker

 

This blog is here to give you a rundown of all the changes including:

  • What’s new?
  • What has been improved?
  • Potential use case

For step-by-step guidance, please read through the Manage Stock section on the Help Centre.

What’s new in Community Insight?

Previously, you could upload your stock properties, categorise them into a maximum of 30 types and then view those properties on the map. Now, along with assigning a stock type you can also add individual information for each property, which can then be displayed on the map.

Adding metadata is optional and completely customisable. To add metadata to your properties you can input information in the 5 columns to the right of the postcode and stock type columns.

Please note: If you use the Organisations feature then your metadata goes in the 5 columns after that Organisations column.

blog 2

Below is an example of how metadata will display on the map once uploaded.

blog 3

For step-by-step guidance, please read through the Manage Stock section on the Help Centre.

What has been improved?

Removed copy and paste option

Previously, you could upload your stock by either copying and pasting or uploading a CSV. We have removed the copy and paste option. Removing this option allowed us to focus on improving the error feedback and speeding up the upload process.

 

Better error feedback

We have improved the error feedback you receive when uploading stock so that any formatting issues can easily be identified and rectified. This should make uploading stock a smoother & less confusing process.

 

Improved site performance

We have focused on speeding up the time it takes for the stock to load on the map. This is something which has been raised by users in the past and is an issue for those organisations who have very large property portfolios. This work means that you can now upload more information about your properties without seeing a significant drop in the performance of the site.

Potential use case

Understanding the areas you work in

Use Community Insight to combine the data you have on your properties with the socio-economic context of an area, to get a better understanding of your tenants and their needs. 

 

Upload your stock with the added metadata 

Now that you can add information to individual properties, you will need to upload your latest stock. 

For step-by-step guidance, please read through the Manage Stock section on the Help Centre.

 

The enhanced functionality allows you to add additional information to individual properties, which will then be displayed on the map when an icon is clicked on. The information you add is entirely up to you. For example, you could add any of the following:

  • Number of bedrooms in a property 
  • Number of occupants in a property
  • Council Tax Band 
  • Repairs due
  • Smart meter 

 

The example below demonstrates the kind of information you could upload and how it must be formatted.

blog 4

Download your property data for an area 

In Community Insight you can create stock groups, these are areas which can be standard areas or more bespoke areas created by you. Once you have successfully uploaded your stock data with the additional information, Community Insight will match the stock to your stock groups thereby allowing you to see the stock you have in an area. You can also download the list of stock in an area

To do this go onto the maps and select to view an area on the map, then click on the i icon next to the area name, this will open up a popup detailing more information about that stock group with the option to “Download list of stock”.

blog 5

blog 6

Visualise your property data on Community Insight 

Once you have successfully uploaded your stock data, you can view this on the map by clicking on individual stock icons. This allows you to visualise your property information in a more accessible way.

You can use the Display Mode to enter full screen and then take a screenshot of the maps to add into presentations.

Overlay socio-economic data alongside your property data

Layer the property data you have uploaded with the standard socio-economic datasets in Community Insight so that you can see the housing provision alongside the needs of an area.

blog 7

Feedback

We are always looking for more feedback and would also love to hear how you are using the improved Stock functionality, so please do get in touch with us on support@ocsi.co.uk

Identify areas with higher proportions of people from at-risk groups

Hi all

We hope you, your loved ones and your colleagues are keeping as well and safe as possible at the moment. 

We have had a few requests for guidance on which datasets within Community Insight could be used to help inform responses to COVID-19 through identifying areas with higher proportions of people from at-risk groups.

Our Research Team has produced a list of datasets that may be useful covering:

  •  at-risk groups: including older people, underlying health conditions and benefit claimants for health and disability 
  • groups requiring additional support: including single-person households, households with no cars and prevalence of dementia
  • economic factors: (key workers and vulnerable sectors). 

These are all available in Community Insight England and can be used immediately. We have also made these available as a mini data download at MSOA level for England .  Please share with anybody that might find it useful.

There are also two new indicators available in Community Insight that could be useful:

  • Households on Universal Credit – Limited Capability for Work Entitlement: This captures those who are receiving Universal Credit due to poor physical or mental health. Universal Credit is increasingly replacing legacy work-limiting illness related benefits including Employment and Support Allowance and Incapacity Benefit so it provides a more comprehensive measure of those out of work due to poor health and disability.
  •  Personal Independence Payment (PIP), respiratory disease claimants: This measures those who are receiving additional financial help to manage conditions associated with respiratory diseases including asthma, chronic obstructive pulmonary disease, bronchiectasis, cystic fibrosis, pulmonary fibrosis, pneumoconiosis, heart and lung transplants and various lung diseases and diseases of the upper and lower respiratory tract.

For a reminder on how to add indicators to your Maps, please see Customise themes and indicators. You can select which indicators appear on the Dashboard from within the dashboard itself using the  Build a custom dashboard functionality.

Many of you must be under enormous amounts of pressure at the moment. Please let us know via support@ocsi.co.uk  if there is any additional support we can give you during this time and we will do our very best to help.