Content Comparison

We need to make the Address Lookup tables mappable. To do this you will need to add another Task entry. In the tree, right click on the Build My Addresses from AddressBase Job you have just created and select New Task.

Select the Stored Procedure type and click OK.

Name

Enter a name for the task e.g. Make AstunLocationLookup Address Lookups mappable.

Connection Details

Select the iShare database from the list. Then select the Workflow radio button as this will limit the list of available Functions and then select the at_wkf_executecmd entry from the listlist (from v6.0.0 this is called wkf_executecmd under the -Workflow- Function filter).

Select the Parameter No 1. in the list and paste the following into the Edit parameter 'cmdtoexecute' box.

DROP INDEX IF EXISTS all_geom_idx;
CREATE INDEX all_geom_idx ON public."AstunLocationLookup" USING gist (wkb_geometry);
CREATE OR REPLACE VIEW public.vw_addressbase AS SELECT "UniqueId" as uniqueid,wkb_geometry,
"Name" as address, "Postcode" as postcode, "X" as x, "Y" as y FROM "AstunLocationLookup";

Image RemovedImage Added

Run the Task to make the Address Lookups mappable

...

Right click on the Task and select Run Make AstunLocationLookup Address Lookups mappable [or whatever you called the task]. Depending upon the size of your AddressBase database this may take a little while.