For police teams the neighbourhood_teams (point) dataset must be joined to the neighbourhood_boundaries (polygon) dataset before you can use the data.
...
Task Details
Enter the following:
Task Name
Enter a Name for the task e.g. Join Teams and Boundaries
Connection
Select the Data Share database from the list.
Stored Procedure
First select the Astun radio button as this will limit the list of available stored procedures and then select the at_sys_create_table entry from the list.
Parameters
Click on Parameter 1. tablename and enter police_neighb_teams in the Edit parameter 'tablename' box e.g.
...
Code Block | ||||
---|---|---|---|---|
| ||||
select a.ogc_fid, a.name, a.rank, a.id, b.name as neighbourhood, b.forcename, b.wkb_geometry from neighbourhood_teams a, neighbourhood_boundaries b where st_within(a.qkb_geometry, b.wkb_geometry) |
e.g.
Now click the Run button to run the Task to create the police_neighb_teams table.