IA National Data Service – Census 2021 – UK Armed Forces Veterans Topic

Last updated: 17th of January 2023

The National Data Service has been updated with the data from the UK armed forces veterans topic summary from Census 2021.

This adds around 30 new indicators to the service, with data available at the geographies it has been published for by ONS:

  • Country
  • Region
  • Upper Tier Local Authority
  • Lower Tier Local Authority

These new indictors are all located under the Population, Veterans theme.

For customers with a managed Data Observatory website, the data are displayed in the following places:

1) Population Map Explorer (updated 14th Jan 2023)

2) Data Explorer (updated 14th Jan 2023)

3) Upper and lower tier local authority Population reports (updated 17th Jan 2023)

We aim to add the data from the remaining topic summaries (phase 1) by the end of the January, and update our reports with these new indicators.

IA National Data Service – Census 2021 – Demography and Migration Topic

Last updated: 21st of December 2022

The National Data Service has been updated with the data from the Demography and migration topic summary from Census 2021.

This adds nearly 1,500 new indicators to the service, with data available at the geographies it has been published for by ONS:

  • Country
  • Region
  • Upper Tier Local Authority
  • Lower Tier Local Authority
  • Middle Layer Super Output Area
  • Lower Layer Super Output Area

To display the LSOA level data we have added a new core geography to the National Data Service called LSOA 2021.

Although ONS did not publish data at ward level, where possible we have generated values at this level by aggregating values from OA area using a population weighted centroids best fit method.

These new indictors are all located under the Population theme, and organised into subthemes that reflect the census table that they were sourced from. We have retained the structure the data were published in, and have also retained the name of the census table in the theme names and indicator names. This is helpful for users that are familiar with the way the census data is organised and/or the names of the tables.

Under each top level theme in the National Data Service, the old data from Census 2011 have been moved into a subtheme labeled Census 2011, to avoid confusion with the 2021 data.

For customers with a managed Data Observatory website, the data are displayed in the following places:

1) Population Map Explorer (updated 6th Dec 2022)

Map explorer with census 2021 data

2) Data Explorer (updated 6th Dec 2022)

Data explorer with census 2021 data

3) Upper and lower tier local authority Population reports (updated 7th and 9th Dec 2022)

Report with Census 2021 data from Demography and migration topic

In January we will be adding data for the further topic summaries that have been released by ONS and updating our ward level reports in addition to the reports at local authority level.

IA National Data Service – October 2022 Update

Education

Pupil characteristics data was updated on 18th of October. Fixes were applied on 27th of October.

Crime

August 2022 monthly and 12 monthly rolling average data were uploaded on 8th of October.

Economy & Employment

Claimant Count (September 2022) was updated on 11th of October.

People in Universal Credit (September 2022) was updated on 15th of October.

BRES data was updated on 15th of October.

Annual Population Survey data was updated on 16th of October. Minor fixes were applied on 19th of October.

Deprivation

Children in low income families data was updated on 13th of October. Fixes were applied on 22nd of November.

IA National Data Service – September 2022 Update

Housing

Household dwelling data was updated on 5th of September.

House prices data was updated on 27th of September.

Education

Pupil characteristics – first language data was updated on 29th of September.

Crime

July 2022 monthly and 12 monthly rolling average data were uploaded on 8th of September.

Economy & Employment

Claimant Count (August 2022) was updated on 13th of September.

People in Universal Credit (August 2022) was updated on 14th of September.

IA National Data Service – August 2022 Update

Crime

June 2022 monthly and 12 monthly rolling average data were uploaded on 5th of August.

Economy & Employment

The Apprenticeships dataset was updated on 5th of August.

Claimant Count (July 2022) was updated on 16th of August.

People in Universal Credit (July 2022) was updated on 17th of August.

Environment

The Emissions dataset was updated on the 10th of August. The figures for carbon dioxide were updated and new figures included for methane and nitrous oxide.

Annual Population Survey

The data for Apr 2021- Mar 2022 was added on 16th of August (out of cycle).

IA National Data Service – July 2022 Update

Population

Census 2021 headline data added – read more here.

Crime

May 2022 monthly and 12 monthly rolling average data were uploaded.

Economy & Employment

Claimant Count (June 2022) was updated.

People in Universal Credit (June 2022) was updated.

Environment

The Waste dataset was updated on the 12th of July.

Housing

The Household Projections dataset was updated on the 15th of July.

The House Prices dataset was updated on 23th of July.

Children and Young People

The Absences dataset was updated on the 29th of July.

IA National Data Service – Census 2021 first results

The first results of Census 2021 were added to the National Data Service on 4th July 2022 and are now available for viewing.

This brand new set of around 140 indicators can be found in the the Population theme, under a Census 2021 subtheme. This dataset combines the first release results for 2021 – available at local authority, region and country level for England and Wales – with the closest equivalent data selected from NOMIS for 2011, 2001 and 1991 to show change over time in the headline data. The population estimates are broken down by sex, broad age group and 5-year age groups.

Note that there may be some differences to the basis on how the values were generated. Note also that this first release data for 2021 gives figures rounded to the nearest 100 – later release will be unrounded and can be expected to show some differences to these figures.

For customers with a managed Data Observatory website, the data are displayed in the following places:

1) Population reports for top and lower tier local authorities (updated 7th July 2022)

NDS report with Census 2021 data

2) Population Map Explorer (updated 4th July 2022)

Map Explorer with Census 2021 data

3) Data Explorer (updated 4th July 2022)

Data Explorer with Census 2021 data

We will add further data from Census 2021 to the National Data Service once these have been released. You can read the release plans from ONS for the data here.

IA National Data Service – June 2022 Update

Crime

April 2022 monthly and 12 monthly rolling average data were uploaded.

Economy & Employment

Claimant Count (May 2022) was updated.

People in Universal Credit (May 2022) was updated.

Deprivation

The Fuel Poverty dataset was updated on the 9th of June.

Environment

The Electricity and Gas consumption dataset was updated 9th of June.

IA Report Builder 2.4.0 – 30 June 2022 Release Notes

Overview

In version 2.4.0 of Report Builder we have continued to improve the behaviour of the chart widgets, following an upgrade of the charting library in the 2.3.0 update. We have also made changes to how Report Builder works with ArcGIS Enterprise as the data, storage and authentication platform instead of ArcGIS Online.

New features

Ability to add fixed lines and zones to bar and line charts

Bar and Line charts can now show fixed lines or zones additionally to the displayed indicator(s). You can add up to 4 lines and up to 4 zones to the chart. Each line has it’s own fixed value, label, colour, width and style. For each zone, the start and end value, label, colour and opacity can be defined. Lines and zones can be added to either the x or the y axis allowing for a wide rage of use cases.

Ability to add Mean and/or Median lines to bar charts

You can chose to display the mean and/or median line either superimposed over or behind the bars of your bar chart. The label, line style and colour can be adjusted.

Export/print options for web map widgets

The simple version of exporting a web map widget is by enabling the Export Snapshot Button which will appear at the bottom right of the map. It takes a simple screenshot of the map widget and saves it to your browser’s downloads folder.

The more advanced Print Button allows the user to print the web map into different file formats, providing a range of options for size and layout.

Both these export options are mutually exclusive, meaning the Export Snapshot Button will only show if the Print Button setting is toggled off. Please note that the Print Button is not available for 3D maps.

Improved support for using data in ArcGIS Enterprise

Report Builder already supported the use of ArcGIS Server services where these services have been referenced in ArcGIS Online to make them easier to access and discover. In this update however, we have taken further steps to make it possible to use ArcGIS Enterprise as the data, storage and authentication platform instead of ArcGIS Online.

If you are hosting your own data catalog, and this is the data source for a report, the catalog table (master table) can include URLs to services from ArcGIS Enterprise and Report Builder will request and handle the authentication to these services appropriately. If the items are (semi)private you will be prompted to sign in to see the data in the report, whether you are editing the report or viewing it as an end user. An example of this is shown below.

Report Builder Enterprise Sign In

Failure to sign in as a user with sufficient privileges will mean that any widgets in the report containing private data will not load.

Currently, the data catalog master table itself must be hosted in ArcGIS Online, but this is a step towards alternative deployments where the data catalog as well as the data services are hosted in ArcGIS Enterprise.

If you are interested in using Report Builder with data hosted in ArcGIS Enterprise we would like to know, so please get in touch with your Esri UK account manager.

Series Type of Pie Charts simplified

The setting Series Type for Pie Charts has been removed as it caused confusion. The rules now are:

  • include all areas = true => one “pie” per indicator and each segment corresponds to a feature
  • include all areas = false => one “pie” per feature (i.e. if you use show comparisons = true) and each segment corresponds to an indicator

Further enhancements

  • You can now use the Configure App button within ArcGIS Online to open the edit version of the report.
  • There is now an option to open the metadata pop-up when selecting indicators for text widgets.
  • It is now possible to configure if comparison bars are displayed at the right of all other bars or included in the core feature bar sorting.

Key bug fixes

  • Bar charts showing counts per value for a lower level comparison geography (for example the deprivation charts in our standard National Data Service reports) no longer show the x-axis labels in random order.
  • Bar charts showing one indicator for all areas can again display comparison values as horizontal lines.
  • It is again possible to create a pie chart showing only one percentage indicator value and filling the remaining pie to 100%.
  • Metadata pop-ups in the data selection dialogs as well as in the table now hide empty fields.
  • Time Series Table: Metadata icons are no longer hidden when group-rows-by-indicator is active.
  • Charts are no longer cut off at the bottom if Title Position is set to title-bar.
  • Width and Height settings of widgets are now rounded to full numbers when resizing the widget by dragging the handlers.
  • All infographic widgets now have setting to enable and disable comparison features.
  • Indicator search option within the widget’s Data & Settings dialog is working reliably even for indicators with special characters or multiple whitespaces in the indicator name.

We hope you will enjoy this new release of Report Builder!

If you have any questions relating to this release please contact Esri UK Technical Support. Customers outside of the UK and Ireland please email support@instantatlas.com.

IA National Data Service – May 2022 Update

Crime

March 2022 monthly and 12 monthly rolling average data were uploaded on the 12th of April.

Economy & Employment

Claimant Count (April2022) was last updated on the 17th of May.

People in Universal Credit data for April 2022 is now available on the Data Catalog. The latest release was published on AGOL on the 19th of May.