Toolbox

Join layer and table by field

Web GIS
A tool to combine data from two sources: spatial data from a Web GIS layer and tabular data. Resuit is vector layer. Joining can be done in two modes: one-to-one or one-to-many.
Demo
URL of your Web GIS, e.g. https://demo.nextgis.com and login/password if necessary
Resource ID of the layer in your Web GIS
Sign in to upload file
Data to be joined in CSV format
Name of the field in Web GIS layer which will be used for joining
Name of the field in CSV file which will be used for joining
One-to-many
Select join type

Docs

The tool combines data from a table and a layer using a given field. The tool involves the use of two different join types: one-to-one - finds the first matching element of the table and attaches its attributes; one-to-many - connects all elements of the table for which the given field matches, the geometry of the feature is duplicated for each element.

Inputs:

  • Web GIS URL - address of the Web GIS on NextGIS Web platform in the following format: https://example.nextgis.com;

  • Resource ID - numbers at the end of the source layer URL;

  • CSV file for join;

  • Key field in WebGIS layer - the name of the field in the Web GIS layer;

  • Target field in CSV - field name in the table;

  • Join type - select one-to-one or one-to-many.

Outputs:

  • layer in ESRI Shapefile format, which is in an archive (zip)

Usage example:

Try the tool in action

  1. Click on the Demo button above the tool form. The fields are filled in with demo values.

  2. Click on the Run button.

Related tools

Web GIS