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 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 list.

...

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";
SELECT Populate_Geometry_Columns('public.vw_addressbase'::regclass);

Run the Task to make the Address Lookups mappable

...