...
- 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.
Task Name
Enter a Name for the task. In the above example we have chosen Download EduBase Data - Doctors
Source Data
Here you need to select the WFS Workflow Connection you have just created.
...
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)
- dentists
- doctors
- hospitals
- opticians
- pharmacies
We have chosen doctors in our example.
| Info |
|---|
Note: If there is no drop down selection then it is possible that you are missing the errorconfig.xml file from your Studio\config folder. |
...
Enter a name for the Table that you wish to create in the PostgreSQL database; we have chosen uk_doctorsedubase.
- Click Save to update the Studio with your changes.
...
If you open pgAdmin and select the Datashare database you should see your new NHS Choices edubase table. The table structure will be as follows:
The column phase_of_education_name can be used to split this data into the different phases of Education e.g. Primary, Secondary etc.
