...
at_wkf_geopivot_sum takes the following parameters:
| 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. |
Create a Stored Procedure Task in Studio and select the Function at_wkf_geopivot_sum.
...
at_wkf_geopivot_count takes the following parameters:
| 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. |
| output_table | character varying | The table to create with the counted and pivoted data, if it exists it will be dropped first. |
Create a Stored Procedure Task in Studio and select the Function at_wkf_geopivot_count.
...
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 another Stored Procedure Task, selecting the Workflow radio button and then select the at_wkf_executecmd entry from the list.
Click on Parameter 1. cmdtexecute cmdtoexecute and enter the following.
...