System Category	Health
Source	Syndicated by Astun Data Services
Available since	2010
Organisation	Open

Introduction

NHS Choices provides public access to health service related information via the web. This includes name, address, postcode, location and URL information for individual services (pharmacies, opticians, hospitals, doctors and dentists). Furthermore the URLs returned from NHS Choices link to a host of additional information, for example, contact information and opening times.

The Astun Data Services (ADS) NHS Choices Downloader essentially acts as a central repository for the NHS Choices data for England. This links seamlessly with the iShare platform allowing NHS service information to be displayed on map layers.

Open

Why ADS?

There is a limit on the number of results returned from the NHS API (max 100 records per request, having 10 records per page)

• ADS requests all data for England once a day, so ADS is always in sync with NHS Data

• ‘One stop shop’ for all authorities using the iShare platform

Open

1. ADS Python script makes a call to the NHS API for data. Rather than creating a localised search and restricting the results the script asks for all data, returning all data for England.

2. The NHS API returns data in XML format, which is converted into a csv file.

3. The csv is then processed by the OGR2OGR program which converts the data into a suitable format and inserts the data into a PostGIS database (spatially enabled PostgreSQL). The .VRT file effectively acts as ‘style sheet’ for OGR2OGR’s import of the csv file (which file to import, coordinate system (lat, lng)..)

4. The MapServer Web Feature Service (WFS) retrieves data from PostGIS (as a result of iShare or 3rd party GIS software user requests) and provides an XML/ GML output.

5. iShare Maps and iShare GIS Studio administrators request the latest data from the MapServer WFS. The iShare Maps and iShare GIS Studio facilities allow the NHS Choices data to be displayed, as individual layers, on customer facing websites and internal intranet systems.

6. The NHS Choices data can be displayed using other 3rd party GIS software, such as Quantum GIS (QGIS) - see WFS Client Connection Examples for details.

Configuring the Workflow in Studio

The following steps outline how you can download the NHS England data and keep it up-to-date.

• Create a Workflow Connection to the WFS feed provided by the Astun Data Services (ADS)

• Create a Job to Refresh the NHS data

  • Create Task to download NHS CHoices data

  • Create Task to Create Table for Doctors and any other types of NHS data you wish to display. Our example uses Doctors but you may change this for any type you like. When using Standard Layers (OGC Layers) then it is much easier to first create individual tables to filter out the data before you create the Layer.

Configuring Standard Layers

All you need to do now is to Configure your individual NHS Choices Layers in Studio.