...
- Right click on the Job entry you have 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 Create Nursery Schools
...
Table
Enter a name for the Table table that you wish to create in the PostgreSQL database; we have chosen education.nurseries as we want to create a nurseries table in the education schema.
...
Creates a new field capacity_numeric as an integer based on the text field school_capacity. This means that we can filter using mathematical operators on this in iShare GIS.
| Code Block |
|---|
(statutory_low_age || '-' || statutory_high_age || ' yrs') as admissions |
...
This will return data up to 5km from the surrey county boundary line.
| Code Block |
|---|
where t.phase_of_education_name = 'Nursery' and t.establishment_status = 'Open' |
...
Although we have created the Workflow Task to create the Nursery table nurseries table we need to actually Run the task to import the data.
- Right Click on the Task you have just created and select Run Task Create Nursery Schools or whatever you have called it. This may take a little while but you should see a successful completion message when the download table has finished. This will import the data for Nursery Schools into the specified table.been created.
Now you can repeat the above steps to create Tasks for each of the different Types of Schools you wish to display in iShare.