Working with GeoGATE

  1. Home
  2. Docs
  3. Working with GeoGATE
  4. Layers Settings Page
  5. Related Data (Layer-Table Relations)

Related Data (Layer-Table Relations)

In GeoGATE, you can relate tables to layers; You cab do this by using at least one common field that is available in both the layer and the table to join data between them and showing the related data on map. This section, will guide you on relating Parcels layer with Parcels owners table; in this case each parcel will be related to one owner or more. Please refer to Connecting GeoGATE to Database section for more information about adding database tables to GeoGATE.

The screenshot below shows the relation between the attributes of layer and table in this example; Relating Parcels Owners table to Parcels Layer using ParcelNumber and BlockNumber fields.

Firstly, go to Parcels layer settings and go to Relationships tab.

Click on “Add Relationship” button.

Type a name for the relationship, and choose the table from the tables drop-down list (the list contains all the tables added in the data connections page, please refer to data connections section for further illustration about adding and configuring tables from databases)

Now, configure the fields that you will use for joining data from layer (Parcels layer) and related-table (Owners table); At least one field should be available at both layer and table in order to join data between them, in this example you will use two fields.

Add the first field: ParcelNumber.

Add the second field: BlockNumber.

Navigate to the map, and identify a certain parcel.

Click on the “Parcels Owners” blue-line that appeared after adding the relationship to explore owners of this parcel.

Related data can be exported to Excel table by clicking the Excel-icon.

Also, table data can be edited from map by using the edit, delete, and add data buttons.

You can configure table data-editing permissions (for users/roles) using permissions configuration settings (in the relationships configuration tab).

Was this article helpful to you? Yes No

How can we help?