IA National Data Service – May 2020 Data Update

Crime

March data available in system from 1 May and all affected reports updated.

Claimant count

Claimant count data updated on day of publication 19 May. Reports followed with all affected reports updated by 25 May.

Population estimates

Provisional Population Estimates for large areas for 2019 were released on 6 May. Generally we avoid provisional data to avoid changing numbers. This was an unusual step on behalf of ONS as part of measures to support the COVID-19 response. We made the data available on the 13 May and updated the affected reports by 15 May. The metadata denoted the provisional nature of the figures. ONS released the final version of the figures on 24 June. The only change from the provisional data was additional data for Northern Ireland so the English National Data Service data was unaffected beyond an update to the metadata.

IA Data Explorer – 17 June 2020 Release Notes

The latest version of InstantAtlas Data Explorer (version 2.0.1) is now available at https://hub.instantatlas.com/.

Version 2.0.1 adds powerful new filtering, user interface improvements and bug fixes.

Enhancements

  • New functionality to filter features in the active geography using one or more fields in the feature layer. This allows you to filter to the features contained in a larger area (see example given below)
  • Modal windows now have Apply, Clear and Cancel buttons
  • Search now launches when user clicks a Go button or hits Enter
  • Adjustments to size of modal windows and mobile layout
  • Title and description removed from the list when viewing the Metadata tab (as these are already displayed at the top of the page)

Bug fixes

  • Search not accepting a space in the search term
  • Search launching too quickly when typing a term
  • Filter screen showing incorrect content when the data explorer was set to be filtered to a single root theme in the data catalog (Root Theme ID setting)
  • Modal window display in Internet Explorer 11

New filtering

Setup

A new configuration setting (Field Filters) has been added that allows the owner of the app to supply a comma-delimited list of filter fields that will be displayed in the data explorer.

Display

The list of field filters is displayed when the user clicks the Filter Settings button in the data explorer. If multiple filter fields have been defined, these will be shown in a drop down menu. If only a single filter field has been defined, this will be shown as text. If a field filter contains the same value for all of the features in the active geography, that field will automatically be hidden from the user.

IA Data Explorer field filters

The end user can select a field to filter the features displayed in the active tab. In the Map tab, the map will automatically zoom to the bounding box of the filtered features. The filter is retained when switching between tabs. In the Time Series tab, the Limit Features button/checkbox will automatically disappear if the number of filtered features is less than 10. The user has the option to perform further filtering to select specific features within the field filter by clicking the Features button.

For example, the Map tab is showing Lower Super Output Areas (LSOAs) for Suffolk County.

IA Data Explorer map showing LSOAs

The user can filter to the LSOAs in a particular district, for example Ipswich (District=Ipswich). The map automatically zooms to the filtered features.

IA Data Explorer filtered map

Switching to the Data tab retains the filter and the table (and the data download) will contain only the LSOAs in Ipswich.

IA Data Explorer filtered data tab

Modal windows

The modal windows in the data explorer have gained Apply, Clear and Cancel buttons to make them more user-friendly.

IA Data Explorer modal window

IA National Data Service – April 2020 Data Update

Claimant Count

Claimant Counts for March 2020 with Feb 2020 revision: Released 21 April. On system 21 April. Reports updated.

Annual Population Survey

Annual Population Survey for Jan-19 to Dec-19: Released 21 April. On system 22 April. Reports updated.

Crime

February data released at start of month, March 2020 data released at end of month. March data available in system from 1 May. Reports updated.

Health

Fingertips data has been refreshed across a number of themes. We are aiming to include the Local Health dataset in the next month.

Apprenticeships

Apprenticeship data: Updated with 2018-19 data on 15 April.

Population Estimates

We added the number and percentage of over 70s on 30 March as this is a key COVID response age grouping.

Public Health Outcomes Framework:

The PHOF dataset was updated on 24 Feb with the February data. A change to the processing has led to a number of indicators being reorded. A number of indicators have now been deprecated. These are available in the system but will no longer be updated. We have adjusted the indicator names to include the term DEPRECATED. If you have used these indicators in your reports we advise amending your reports to use the new indicators that will continue to be updated.

Wards

Following discussion with affected customers we are in the process of updating Wards (and other geographies) to the latest boundaries. As there can be a significant delay between new boundaries being released and data being made available for them we will be calculating where possible estimated values for the new areas based on the best fit of smaller geographies. The metadata for affected data will be amended to reflect that the source may be a mixture of published and derived values.

IA Data Explorer – 27 April 2020 Release Notes

The latest version of InstantAtlas Data Explorer (version 2.0.0) is now available at https://hub.instantatlas.com/.

Version 2.0.0 extends the functionality of the data explorer for searching and visualising data in an InstantAtlas data catalog still further by adding powerful charting capabilities and a new redesigned user interface.

Enhancements

  • Improved interface with tabs to switch between metadata, table, map, time series and ranked bar chart
  • New charts to visualize indicator data – time series and distribution/ranking
  • Options to view time series as line, bar or stacked bar chart
  • Improved mapping functionality – within the app rather than as a separate app – version 4 of JavaScript API replaces version 3
  • Full control over which features and dates are displayed in the charts and tables
  • Improved admin/author control over which functionality is available to end users (via ArcGIS Online configure app)
  • Options to view tabular data in “standard” or “flat” format
  • Improvements to download of data

Bug fixes

  • Fixes for bugs when using Internet Explorer 11
  • Fix for commas in area names breaking data downloads
  • Other minor bug fixes

Improved user interface

The data explorer has been updated so that all data visualisation options are integrated within the app. Once an indicator has been selected in the data explorer, a series of tabs provide access to the different views:

  • Metadata: view a description and the full set of metadata for the selected indicator
  • Table: view the selected indicator for all available features and dates, and download as a CSV file
  • Map: view the selected indicator as a thematic map with different classifications available including shaded areas and proportional circles
  • Time Series: view the time series for the selected indicator using a line, bar or stacked bar chart that can be downloaded
  • Ranked Bar Chart: view a bar chart ranking the features for the selected indicator

Controls

Each view can be customised by the end user via a series of controls located at the top of the tab. These controls are hidden by default but can be displayed by clicking the  cog wheel icon.

  • Select geography menu: use this menu to select from the list of available geographies
  • Select dates: use these menus to select the range of dates you would like to view data for
  • Filter features: use this button to access the list of features belonging to the active geography and use the checkboxes to make your selection. Click X to apply the selection.
  • Table format: choose between Standard and Flat formats for the data
  • Download: download the data as a CSV file that can be opened in another package such as MS Excel for further analysis.

Table

The table by default will show data for all dates available for the selected indicator, for all of the features in the active geography. The end-user can filter the features and change the date range using the controls above the table. The table can be scrolled if there are too many features/dates to show on the screen. The download button will download the table as a CSV file; only the data showing in the table when the button is clicked will be downloaded.

IA Data Explorer Data tab

Map

The map will show data for a single date for the selected indicator, for all of the features in the active geography. The end user can change the geography, select a different available date for the indicator and change the map classification. The map is interactive and can be dragged and zoomed. There are a number of options available from the map area:

  • Home: return to the default map extent
  • Export: export the map as an image or a PDF – there are various options to change the layout, or add a title and other text
  • Basemap: change the basemap for the thematic map
  • Search: type in the search box to search for a feature in the active geography or a place in the map area

IA Data Explorer Map tab

Time Series

The chart will by default show data for all dates for the selected indicator, for up to 10 features in the active geography. The end user can change the date range and filter the features using the controls above the table. They may also click the checkbox to remove the 10 feature limit, although this may create a messy chart depending on the number of features in the active geography. There is a menu to change the type of chart:

  • Line: a separate line is shown for each feature
  • Bar: a separate bar is shown for each feature
  • Stacked bar: one bar is shown for each date and features are stacked

IA Data Explorer Time Series tab - line chart
IA Data Explorer Time Series tab - bar chart
IA Data Explorer Time Series tab - stacked bar chart

Ranked Bar Chart

The ranked bar chart shows the data for a single date for the selected indicator, with a bar for each feature in the active geography. The end user can change the selected geography, date, filter the features or download the chart as an image.

IA Data Explorer Ranked Bar Chart tab

Metadata

The metadata tab displays the description and the full set of metadata for the selected indicator. This can be download as a CSV file using the download button.

IA Data Explorer Metadata tab

IA Data Catalog – 20 April 2020 Release Notes

The latest version of InstantAtlas Data Catalog (version 2.1.0) is now available at https://hub.instantatlas.com/.

Enhancements:

  • Improved update process for indicators supplied by the InstantAtlas National Data Service but referenced in a customer-managed catalog/master table.
  • Improved (more fine-grained) error checking in the Inspector tool
  • New “Repair” functionality in the Inspector tool to allow repair of common errors
  • Minor UI updates

Bug fixes:

  • Fixes for issues in the Manager tool that prevented update of InstantAtlas National Data Service indicators and/or caused duplicate indicators and themes in the customer-managed table.