Page Comparison

...

• Right click on the Jobs entry you have just created to Refresh the EduBase Data in the tree and select New Task.
• Select Spatial Data Transformation as the task type and click OK.

...

Image Added

Task Name

Enter a Name for the task. In the above example we have chosen Download EduBase Data Update EduBase

Source Data

Here you need to select the WFS Workflow Connection you have just created.

Table

Here you need to select the correct table for the type of EduBase data that you wish to extract from EduBase. This is actually a layer name and the options are:

• • • all (All Services)

Output

In this instance will want to output to the PostgreSQL database so select then name of your Data Share database.

Table

Enter a name for the Table that you wish to create in the PostgreSQL database; we have chosen edubaseeducation.edubase as we want to create an education table in the education schema.

• Click Save to update the Studio with your changes.

...

• Right Click on the Task you have just created and select Run Task Download EduBase DataUpdate EduBase or whatever you have called it. This may take a little while but you should see a successful completion message when the download has finished. This will import the WFS feed into the specified table.

Table Structure

If you open pgAdmin and select the Datashare database you should see your new edubase table.  Have a look at the table structure to see which columns you might wish to use as part of your select statement when updating the .MAP file for EduBase. You may also wish to create separate Tasks to split the data into individual tables for each type of School e.g. Nursery, Primary, Secondary etc.

Versions 1 & 2	Version 2 only
The column phase_of_education_name can be used to split this data into the different phases of Education e.g. Primary, Secondary etc.	In Version 2 there are columns for open_date and close_date which may be useful as well as establishment_status, so you could use establishment_status = 'Open'
Image Modified	Image Modified