If you are signed in to ArcGIS Online (i.e. you sign in via the Data Catalog app or the Data Explorer app is launched with a ?token=xxxxxx argument) you will see a View ArcGIS Online Item button displayed under the Data, Map, Time Series or Ranked Bar Chart tabs.
When clicked, the button takes you to the item in ArcGIS Online that contains the data for indicator you are viewing in the data explorer.
This button has been added in order to make it easy to obtain the endpoint of the ArcGIS feature layer containing an indicator from an InstantAtlas data catalog. There are a number of scenarios in which it might be useful to have the endpoint, one being that it enables the use of the data held in the data catalog in other third party systems, such as Microsoft Power BI for example.
Update to sharing/token behaviour
The Data Explorer has been updated so that when it is run in authorised mode (i.e. not shared with everyone) it will pass the token down to all of the feature services it uses. Furthermore, a public-shared Data Explorer will detect whether it needs a sign in for specific feature layers. If the data for the indicator searched for is stored in a feature layer that is protected, the user will be asked to sign in to ArcGIS Online in order to view the indicator in question.
March data available in system from 1 May and all affected reports updated.
Claimant count data updated on day of publication 19 May. Reports followed with all affected reports updated by 25 May.
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.
Version 2.0.1 adds powerful new filtering, user interface improvements and bug fixes.
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)
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
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.
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.
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.
The user can filter to the LSOAs in a particular district, for example Ipswich (District=Ipswich). The map automatically zooms to the filtered features.
Switching to the Data tab retains the filter and the table (and the data download) will contain only the LSOAs in Ipswich.
The modal windows in the data explorer have gained Apply, Clear and Cancel buttons to make them more user-friendly.
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.
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.
Fingertips data has been refreshed across a number of themes. We are aiming to include the Local Health dataset in the next month.
Apprenticeship data: Updated with 2018-19 data on 15 April.
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.
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.
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.
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
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
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
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.
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.
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
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
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.
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.