Friday, 14 October 2016

Soil triangle integration in a PostgreSQL based system for archaeological recording sheets

This is the second presentation we gave at ArcheoFOSS 2016. This time the topic is more related with geoarchaeology and regards geTTexture (the open source application we developed in order to speed up the sedimentation est).

Here below is the link to the original presentation, for the reader who wants to see it directly online:

www.museidironzone.it/openLibrary/html/gettexture/gettexture.html

For those who prefer to see it on youtube, I just uploaded it on our channel:



Like for last post, I report here below a short abstract, describing shortly each slide of the presentation:

SLIDE 1

Title and overview

SLIDE 2

Compiling the archaeological recording sheet is one of the most time-expensive operation during an archaeological project both doing it manually...

SLIDE 3

... or using a database.

SLIDE 4

Considering the Italian standards (ICCD, "Istituto Centrale per il Catalogo e la Documentazione"), often new archaeologists have difficulties in describing the composition of the archaeological layer.

SLIDE 5 and 6

SLIDE 7 and 8

No particular difficulties are detected in describing the artificial elements.

SLIDE 9 and 10

A little bit more complicated is considered to describe the organic and oranogenic elements.

SLIDE 11 and 12

The most difficult field is considered the geological one.

SLIDE 13

Geological materials are splitted into two categories: skeleton and fine earth

SLIDE 14 and 15

The skeleton is normally simpler to identify (both in the field and in the lab).

SLIDE 16 and 17

The fine earth is maybe the most complicated archaeological element to identify on the field, while specialist (geoarchaeologists) need to use specific equipement in the lab.

SLIDE 18

Fine earth definition on the field is foten carried on with anametric and sobjective methodology.

SLIDE 19

Like feel, ball and ribbon test

SLIDE 20

The sedimentation test gives more objective results with a minimum metric value.

SLIDE 21

Arc-Team used validated the use of sedimentation test also in emergency excavation (which have a stricter time-table respect other archaeological projects)

SLIDE 22

Thank to +Mattia Segata  (Arc-Team's geoarchaeologist at ATLAB), the basic methodology has been improved considering the Strokes' Law.

SLIDE 23

+Giuseppe Naponiello  (Arc-Team DataBase and WebGIS expert) improved a PostreSQL dabatase, developed on the Italian archaeological recording sheet. The Database is able to integrate the data coming from the sedimentation test.

SLIDE 24

Future integration are planned for basic analytical chemistry analyses on the field.

SLIDE 25

And for more specific laboratory analyses (e.g. Energy Disperive X-ray Spectrometry).

SLIDE 26

The DataBase can be easily integrated into a WebGIS

SLIDE 27

The slides is just a demonstration of the software (the code is taken from a prototype).

SLIDE 28

The slide is just an example of one of the videotutorial Arc-Team is producing to explain the sedimentation test and the use of geTTexture.

SLIDE 29

geTTexture will be one of the open source application for archaeology which Arc-Team is developing and that will compose the suite Arc-Tool.

SLIDE 30

Another extension of geTTexture Arc-Team is working on is related with colorimetry. The idea is to integrate a tool to record anametric analyses

SLIDE 31

or metric data coming from Open Hardware devices (e.g. Public Lab spectrometer)

SLIDE 32

Thak you for your attention

Have a nice day!
BlogItalia - La directory italiana dei blog Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.