1.26. How to connect a Lookup table to a vector layer

A Lookup table can be connected to an attribute field of a vector layer. While editing the layer you will be able to select the value for the attribute from a dropdown menu.

  1. Create a lookup table using key-value format (how to do it).

../../_images/create_lookup_table_en.png

Pic. 1.95. Creating lookup table

  1. Open the Edit dialog for the vector layer. In the Attributes tab press the downwards arrow in the field of the Lookup table column corresponding to the attribute you want to connect it to.

../../_images/lookup_table_field_en.png

Pic. 1.96. Lookup table field

  1. In the opened dialog select the lookup table.

../../_images/lookup_table_select_en.png

Pic. 1.97. Selecting lookup table

Press Save.

To delete a connected lookup table, click on the cross next to it in the corresponding field.

Note

See step by step tutorial in our video.

1.26.1. How to use a lookup table for layer editing in NextGIS Web

A lookup table connected to a layer can be used for editing the vector layer in the web application. To select an attribute value from the list, open the Feature table on a separate tab or on a Web Map.

Select the feature and press Edit.

../../_images/attr_table_edit_en.png

Pic. 1.98. Selecting feature to be edited

In the opened dialog the values included in the lookup table connected to the field will be available as a dropdown menu. Select the value and press Save.

../../_images/attr_table_lookup_dropdown_en.png

Pic. 1.99. Selecting attribute value from a lookup table

1.26.2. How to use a lookup table in QGIS

NextGIS Connect allows you to use lookup tables while editing layers in QGIS.

  1. Connect to the Web GIS in NextGIS Connect.

  2. Create WFS service for the layer.

  3. Open the attribute table of the layer. Enter the edit mode.

  4. Click on the field of the attribute that has a lookup table connected to it. Then click again on the arrow at the end of the field to open the dropdown menu.

../../_images/attr_table_qgis_lookup_en.png

Pic. 1.100. Selecting attribute value from a lookup table in QGIS