OpenJUMP, auto assign attribute

This post will present a new videotutorial for ArcheOS 5 (codename Theodoric), regarding the software OpenJUMP.

Like for this other article, also in this case I chose to use a real project, to show the potentialities of ArcheOS in different archaeological missions. The main objective of the work was the inspection of an high mountain area (more than 3000 meters above the sea level), in order to verify the possible presence of historical remains connected with the World War I. One of my specific needs to prepare the mission was the setting of a GIS system, updating a geological vector map of the whole province in which I was operating. Luckily this province (Trentino) is at the forefront (in Italy) for the distribution and use of geographical open data, so I had no problems in finding the base map I mentioned before; the main work has been the updating of the database, connected with the vector layer, in which I had to insert some additional informations that were stored in an external spreadsheet.

In short, what I did in OpenJUMP is:

1. Query the Area Of Interest (AOI) of my project in the vector base map, in order to visualize a numerical code that was connected with the additional data in the spreadsheet

2. Edit the database schema of the vector map to add two new fields for the additional informations

3. Check the spreadsheet to read the values connected to the numerical code of the vector map

4. Query the vector map to select all the regions with the numerical code of my AOI (which would share with it all the same additional informations)

5. Use the Auto Assign Attributes Tool to fill (for all the selected regions) the new empty database fields with the right values

6. Repeat the operations till all the vector map has been updated with the additional informations

This videotutorial shows the main operations. I hope it will be usefull for you. As usual I uploaded it also in the DADP wiki.

Have a nice day!