...

Introduction

There a new service from GOV.UK called Get information about schools (GIAS), which replaces the EduBase service for educational professionals in England. The service supplies a register of educational establishments in England and Wales, maintained by the Department for Education. It provides information on establishments providing compulsory, higher and further education.

...

Why ADS?

• ADS requests all data for England once a day, so ADS is always in sync with GOV.UK
• ‘One stop shop’ for all authorities using the iShare platform

...

1. ADS Python script makes a call to the GIAS service 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 service 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 GIAS data to be displayed, as individual layers, on customer facing websites and internal intranet systems.
6. The GIAS 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 GIAS data and keep it up-to-date.

• Create a Workflow Connection to the EduBase WFS feed provided by the Astun Data Services (ADS)
• Create a Job to Refresh the EduBase data
  • Create Task to download EduBase data
  • Create Task to Create Table for Nursery Schools and any other types of School you wish to display. Our example uses Nursery Schools but you may change this for any type you like. If you wish to use the default Layer type (OGC Layers) then it is much easier to first create individual tables to filter out the data before you create the Layer.

Using Standard Layers

If you are using the Standard Layer type of OGC Layers then all you need to do now is to Configure your individual EduBase Layers in Studio.

Using Classic Layers

If you are using Classic Layers then you will first need to update your .MAP file to include these new EduBase layers. See Update .MAP file for EduBase Classic Layers  for details. Once the .MAP file has been updated you will be able to configure the EduBase Classic Layers via iShare Studio.