...
| Parameter | Type | Description |
|---|---|---|
| geometry_table | character varying | The table of polygons to use for the data aggregation, all the columns in this table will be replicated in the output table. |
| geometry_id_column | character varying | A column in geometry_table that uniquely identifies the records. |
| data_table | character varying | The table containing records with point geometry and category. |
| category_column | character varying | The column in data_table to be used to categorize the data. |
| value_column | character varying | The column in data_table containing the values to be summed. |
| output_table | character varying | The table to create with the summed and pivoted data, if it exists it will be dropped first. |
These parameters should be listed in comma-delimited form in Studio Create a Stored Procedure Task in Studio and select each parameter in turn to enter the values in the Edit parameter area e.g.
If successful, the following is returned:
...
Your final table must contain a unique identifier, of data type SERIAL. This is generally called “ogc_fid”. If not already present, this can be added using a Studio Workflow Stored Procedure Task that calls the function at_sys_add_column e.g.
This stored procedure takes the following parameters as shown in the above screenshot:
...