Page Comparison

...

Spatial Merge tool contains 5 fieldssections:

...

Image Added

1. Here you can select a master layer. The master layer is a main layer. All columns from this layer table will be copied to newly createdcreated output table.
2. Here you can set a detail layer. The detail layer will take part in comparison process and selected data from this layer table will be used and placed in the newly created output table.
3. In this field you can select one of the spatial comparison methods.
   Image RemovedImage Added
4. In the Columns to append from detail layer field you can select which data from the detail layer should be placed in the Output table.
5. Here you can enter the Output table name and Repository in which the new table should be created. If the entered table name already exist the spatial merge operation will be disrupted.

How to use Spatial Merge tool

To explain how this tool works and how to use it we will use 2 layers: Windmills and District BoroughTourist symbol and National Parks. Both these tables are part of Ordnance Survey Strategi dataset and are available for free from OS website under OS OpenData licence.

• Windmills – Tourist symbol – this layer stores information about windmillstourist attractions. This is how it looks in database:

Image RemovedImage Added

The WindmillsTourist symbol layer table contains 5 8 columns:

1. CODE
2. LEGEND
3. AMENDED
4. NAME
5. USAGE
6. OWNER
7. ORIENT
8. MI_PRINX

• District Borough – National Parks – this layer stores names and details of United Kingdom districtsnational parks.

Image RemovedImage Added

In this example we will use Spatial Merge tool to create a table with all information from the Windmills layer Tourist symbol layer extended by additional column which will store a name of District Borough National Park in which the windmill is located.

Image RemovedImage Added

We click on the Spatial Merge tool icon.

Image RemovedImage Added

In the Spatial Merge tool window we’ve set everything to create a new table. You can find a detailed description below.

Image Removed

...

Image Added

1. Tourist symbol – because we want to copy all data from the Windmills layer Tourist symbol layer table to newly created output table we set it as master layer.
2. District Borough National Parks – this layer stores the district borough namesNational Park names. We set is as detail layer.
3. Because we know that all windmills are some tourist symbols are located inside District boroughsNational Parks records we’ve selected which intersect with master record comparison method.
4. We want to add a column which will store a name of District BoroughNational Park. We know that the names are stored in NAME column so we check it.
5. SM_Tourist_windmillsSymbol – this is a name of the Output table.

Everything When everything is set, we can click OK button to confirm all settings and move to the next step. Save Spatial Merge Layer window will appear. Please set a name and select the location for the new layer. To start the operation please click the OK button.

Image Removed

In this case Spatial Merge operation took around 10 seconds. The operation time depends on the layers size and amount of stored data.

Image Added

When the operation is finished – newly created layer is automatically added to the currently opened map.

Image RemovedImage Added

This is how the newly created SMwindmillsNew SM Tourist symbol layer table looks in Table tab:

Image RemovedImage Added

As you see the table stores the data and the location of all records from Windmills tableTourist symbol table. Please also notice that the NAME column name from the District BoroughNational Parks is changed to NAME2. That happened because the Windmills table Tourist symbol table already contained a NAME column and Earthlight is automatically updating new columns names if it detects an already existing one.