Welsh Assembly Members (AMs)
...
Create a "Stored Procedure" Workflow Task. Select the wkf_create_table function from the Workflow filter and enter the information below.
| Name | Format Modern.gov AMs (moderngov_regional_spatial) |
|---|---|
| schemaname | public |
| tablename | moderngov_regional_spatial |
| selectstatement | See below |
...
- The SQL to create the spatial tables may need updating to take into account the following:
- Keywords such as Ward, which are used to split the parts of the description value, being spelt in Welsh
- BoundaryLine substitutes accented characters such as ô with their English equivalents (o for ô) so you might not get a match in the join condition without a bit of replacing
...