Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 5 Next »

The Councillor data from the Modern.gov needs to have the geometry columns populated before it can be used by iShare. This is done via a Stored Procedure Task. In the tree, right click on the Update Modern.gov Data Job you have just created and select New Task.

Select the Stored Procedure type and click OK.

Task Details

Enter the following:

Task Name

Enter a Name for the task e.g. Modern.gov Councillors Geometry

Connection

Select the Data Share database from the list.

Function

First select the Astun radio button as this will limit the list of available functions and then select the at_wkf_executecmd function from the list.

Parameters

Click on Parameter 1. cmdtoexecute and in the Edit parameter 'cmdtoexecute' box enter the following:

Example
SELECT Populate_Geometry_Columns('public.moderngov_spatial'::regclass);

E.g.

Now click the Run button  to run the Task to populate the geometry.

  • No labels