#
Configuring Linked Datasets
A linked dataset contains complementary attributes that relate to a features from a map layer.
Users can select a feature from a standard map layer (the 'parent' dataset) and Pozi will fetch and display its associated records from the linked table (the 'child' dataset) based on an attribute that is shared between the two.
Use cases:
- properties
- owner details
- building and planning permits
- animal registrations
- associated land parcels
- intersecting planning zones and overlays
- assets
- inspections
- defects
- maintenance
- photos
- council wards
- representatives
- more...
#
Add Dataset
Add the source table for the child datasets to an existing QGIS project that has been configured for WFS (eg Child Datasets.qgs
).
- open project file in QGIS
- Layer > Add Layer > pick from file or database options
- pick source table
- Add
- Close
- Project > Properties > QGIS Server
WFS capabilities > Published
: tick on for each dataset- OK
- Project > Save (
Ctrl
+S
)
Only the child dataset needs to be configured. There is no configuration required for the parent dataset for it to support a child dataset.
#
Register Dataset
#
Obtain GetFeature URL
Construct a GetFeature
URL by combining the following:
- the project's Advertised URL (eg
https://local.pozi.com/iis/qgisserver?MAP=C:/Program%20Files%20(x86)/Pozi/userdata/local/property.qgs
) - WFS GetFeature request:
&service=WFS&version=1.1.0&request=GetFeature
- table:
&typename=
+ table name
Combine these three text strings to create a GetFeature
URL.
Example GetFeature
URL:
Test your URL by pasting it in your browser and check that you get a valid response that returns records from the source.
#
Submit Helpdesk Ticket
Email support@pozi.com with these details:
- subject: New child dataset
GetFeature
URL- name of new child dataset(eg
Bridge Defects
) - name of field in child dataset that contains the link attribute (eg
Asset_ID
) - name of existing parent layer as it appears in Pozi (eg
Bridges
) - name of field in parent layer that contains the link attribute (eg
AssetID
)
Within 24 hours, the child dataset will be configured and available in Pozi.
#
Troubleshooting
- in Pozi, click on a parent feature for which you know a child feature exists
- check that the layer is enabled for WFS. In QGIS, go to Project > Properties > QGIS Server > WFS Capabilities > your dataset > Published (tick on), then Save the project
- check that the names of the fields in the child and parent datasets that are used for the link are consistent with the names supplied with the child dataset's registration in Pozi
Use QGIS to determine whether the layer also causes its project file to load slowly. Observe the progress bar at the bottom to see if any layers are taking more than a fraction of a second to load in QGIS. If it appears that a layer is taking longer, check the source data. Also check how long it takes for QGIS to show the dataset's table view (Layer > Open Attribute Table). Check that any join fields are properly indexed.