Combine your data with spatial join
access_time 5 MIN | fiber_manual_record INTERMEDIATE | label TRAINING, DATA, ADVANCED, 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.
This will bring you to the start screen of our Join App.
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.
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).
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.