material

PK autoincrementing unique identifier for materials

FK self referencing to record when a material is a subset of another e.g. Wickow Granite is a subset of Leinster Granite

The common name for the material e.g. Connemara marble

Whether or not the material is public (will appear on website)

Alternative name(s) for materials.

FK. Link to dic_material_type

Specific rock type or mineral name

Colour or colour range of the stone

Variation of colour

FK. Link to dic_grain_crystal_size

Where the material is usually used.

General description, discussion of the material. Public formatted version which appears on the website.

Notes, not public for internal use only

FK. Id of the international commission on stratigraphy age name

Geological age verbatim e.g. local age name

Geological group name

Geological formation name

Geological member name

Lithostratigraphy, originally as reported on google sheets

Link to dictionary of lithostratigraphy from GSI

Code from the British Geological Survey Lexicon of named stratigraphic units https://www.bgs.ac.uk/technologies/the-bgs-lexicon-of-named-rock-units/

Notes about the stratigraphy

Country material originates from

Link to dic_county for county of origin

Presence or absence in Eurlithos database (EN 12440)

Whether this material should be submitted to Eurolithos

URL for Northern Irish Natural Stone Database (stonedatabase.com)

ID for Scottish Building Stone Database. Find the ID for stones in the URL. Quarry ID is visible in tables.

Geological Heritage Code

Data orginally entered by

Date of original entry

Person who made the latest modification

Date of latest modification

Autogenerated Tag for materials, used to link to references and photos. Created by taking the common name and removing all special characters/punctuation, replacing spaces with underscores.