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

Fig. 58. 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_2.png

Fig. 59. Lookup table field#

  1. In the opened dialog select the lookup table.

../../_images/lookup_table_select_en_2.png

Fig. 60. 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.

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

Fig. 61. 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

Fig. 62. Selecting attribute value from a lookup table#

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

Fig. 63. Selecting attribute value from a lookup table in QGIS#