Combine your data with spatial join

Combine your data with spatial join

When you have multiple datasets you can join these datasets together. The process of joining 2 datasets together is done with the Join App. To open the Join App, click on the ‘options’ button behind one of the datasets you want to join. This will give you the ‘Join dataset’ option.

Perform Spatial Join - Join Dataset

This will bring you to the start screen of our Join App.

Perform Spatial Join - Spatial Join Selection

The second method to join datasets is a spatial join. This method joins two datasets based on corresponding locations. This can be useful if you have a set with geocoded addresses and want to join these addresses with areas like age groups from our demographics dataset. In such a case, the addresses will be enriched with the data of the area it intersects with.

In the following step you have to select which datasets you want to join.

Perform Spatial Join - Merge Datasets

Did you know…

The dataset that is chosen on the right side will get ‘merge_’ in front of its data columns. If you want to save yourself some work, just select the dataset with the most columns on the right side.

When you have chosen the right datasets click ‘NEXT STEP’. In this window you can select all the columns you want to use in your new dataset. Remember to choose the geometry of the correct dataset. So if we want to create a new map with points, we select the_geom column of the dataset on the left (data_sample_managers). If we want a map with areas, we select the_geom column of the dataset on the right (postcode_nederland).

Perform Spatial Join - Column Selection

After this you only need to give it a name and run the join. After completion, the app will create a new dataset. This way you will not lose the original datasets that you used for this data join.