Vocabularies — browse and download — British Geological Survey (BGS)

BH_GEOLOGY_COMMENT

A dictionary table within the BOREHOLE GEOLOGY database that holds the approved comments for attaching to logs in BOREHOLE_GEOLOGY table.

CURATOR_DIC

Dictionary table for CURATOR codes, eg code for NGRC.

DIC_10K_COORD

Dictionary table containing NGR coordinates of the SW and NE corner of Ordnance Survey 1:10K sheet areas.

DIC_10K_MAP_AREA

Dictionary table listing BGS 1:10,000 map numbers. Field intended to list map names not populated.

DIC_250K_COORD

Dictionary of BGS 1:250,000 named map sheets and their 8 spatial coordinates (SWN, SWE, SEE, SEN etc.).

DIC_50K_10K_COORD

Dictionary table holding overlap of 1:10,000 maps for England, Wales and Scotland.

DIC_50K_COORD

Dictionary of 1:50,000 geological map sheets for England, Wales and Scotland (identified by sheet number) and their 8 spatial coordinates (SWN, SWE, SEE, SEN etc.).

DIC_ABUNDANCE

Dictionary of abundance, for use in various situations

DIC_ACCN_COMP

Dictionary of Company names that have donated Borehole Accessions to BGS. The data in this dictionary is derived from legacy KW & MH Accession tables (BH_ACCNS & LSR). The table is used in the view ACCN_COMBINED_DIC_COMP_V to constrain company columns in the BGS.BH_ACCN).

DIC_ACS_COLLECTION

A dictionary of BGS Collections (e.g. "Boreholes", "Site Investigations"). Friendly Name: BGS Collections Dictionary.

DIC_ACS_DOCTYPE

A dictionary of Accession Documentation Types. Friendly Name: Documentation Types.

DIC_ACS_PROJECT

A dictionary of projects associated with accessions.They may be internal or external and may not be assignable to a BGS project code.It could be the BGS project or a generic project (e.g. for "Vale of York project") where the project encompasses several BGS projects. It may also be an external project.Friendly Name: Accession Project Dictionary

DIC_ACS_TYPE

Dictionary of Types of Accession. E.g. "Loan", "Transfer of Ownership". Friendly Name: Accession Type Dictionary

DIC_ADD_COLLTITLE

A dictionary table of metadata collection titles. Provides values for ISO metadata element no. 371 collective title. This object is a copy of the dictionary in the DGSM schema and is now obsolete; the BGS table DIC_MET_COLLECTION should be used instead.

DIC_ADD_GEOGNAME

Existing Dictionary table in DGSM - the only change is there is a single field PK. The use of this dictionary is a temporary expedient until a geographic thesaurus is in place.

DIC_ALTERATION

Dictionary table for processes (or results of processes) leading to modification of the fabric, composition, or other physical or chemical property of a pre-existing rock or sediment.

DIC_APPROX_FACING

Dictionary containing the approximate facing directions recorded in the field, to assist subsequent accurate determination of facing direction by stereonet.

DIC_APPROX_VERGENCE

Dictionary containing the approximate vergence direction, in the horizontal plane, recorded in the field.

DIC_AXIAL_PLANE_ATT

Dictionary of fold axis, expressed as a plunge and azimuth

DIC_BASE_BED

Dictionary of Base of Bed codes: for use in downhole borehole databases.

DIC_BASE_COLOUR

Dictionary of Colours - this is used for base colours in BGS Full Colour Dictionary.

DIC_BEDDING_TYPE

Dictionary table to describe the type of primary sedimentary bedding where dip and dip azimuth are measured at a single point as part of geological survey. The type recorded will enable selection for display on a map, plotting on a stereonet or symbolisation on a map, as in the BGS digital geological mapping system.

DIC_BED_SURFACE_STRUCT

A dictionary of bed surface structures, eg. ripples, dessication cracks.

DIC_BGS_FULL_COLOUR

A dictionary of BGS standard full colour descriptors such as [Red, Pinkish, Light], [Blue, Purplish, Dark] etc. Each description is broken down into 3 fields: Base Colour (eg Red), Colour Qualifier (eg Pinkish), and Shade (eg Light). Each colour must have a Munsell full code associated with it and this is termed the `Median` munsell code since it points to a `median` where a BGS colour can cover many Munsell definitions.

DIC_BGS_SITE

Dictionary table listing Names and Codes of all BGS sites (and Swindon). Used by staff movements diary

DIC_BORE_MAT_TYPE

Dictionary table listing core material types and their short codes.

DIC_BOUNDARY_CHARACTER

Dictionary table describing the different natures of interface or transition between mapped geological units (to be used only where the boundary is observed).

DIC_BOUNDARY_RELATIONSHIP

Dictionary of terms classifying the relationship between units separated by a "unit boundary"';

DIC_BPD_CATEGORY

This table is a dictionary. It holds translations for the category codes which all the best practice documents fall into.

DIC_BP_BGS_ACTIVITY

This dictionary table belongs to the Best Practice suite of tables (originally started by John Howcroft). It is intended to link to BGS.BP_IDENTIFIER.

DIC_BS812_LITHOLOGY

Dictionary of British Standard 812 simple rock lithology names and their BS812 short codes.

DIC_BUILDING_DAMAGE

Dictionary of building damage as a result of ground movement directly associated with a Karst Geohazard feature(s).

DIC_BUSINESS_ACTIVITY

Hierarchical dictionary of types of business activities within BGS e.g. scientific, administrative. Can be used to classify the usage of database objects and applications.

DIC_CAVITY_TYPE

BGS Dictionary Table to hold various cavity types

DIC_CERTAINTY

Dictionary of the levels of certainty pertaining to an observed or interpreted geological feature shown on a geological map. GSD Notes: Dictionary very minimalist at present to meet immediate need. "Inferred" could be expanded later to specify various types or methods of inference

DIC_CHARACTERSET

Metadata dictionary of written character sets. An implementation and extension of ISO codelist B.5.10 MD_CharacterSetCode

DIC_CMD_BIOTURBATION

Dictionary of bioturbation for use with samples in the Coastal and Marine Database

DIC_CMD_DEPTH_SOURCE

dictionary of equipment types which are used for measuring water depth.

DIC_CMD_GEOPHYS_EQUIP

Dictionary table containing the controlled vocabulary for geophysical equipment. Maybe this should be a sub/superset of the BODC dictionaries.

DIC_CMD_H2S_ODOUR

Dictionary of the detection of H2S (hydrogen sulphide) odour for use with samples in the Coastal and Marine Database.

DIC_CMD_JOINTING

Dictionary of jointing for use with samples in the Coastal and Marine Database, based on the Bieniawski Geomechanics Classification.

DIC_CMD_MB_COVERAGE

This dictionary contains the terms for the description of the density of coverage of the data collected. Examples: FULL where there is complete data coverage for the whole polygon area, CORRIDOR where the data has been collected on a regular pattern within the polygon.

DIC_CMD_MB_DATATYPE

This dictionary contains the different types of data associated with a multibeam dataset

DIC_CMD_MUD_HARDNESS

Dictionary of mud hardness for use with samples in the Coastal and Marine Database.

DIC_CMD_MUD_PLASTICITY

Dictionary of mud plasticity for use with samples in the Coastal and Marine Database.

DIC_CMD_NAV_EQUIP

Dictionary table containing the controlled vocabulary for the navigation equipment. Maybe this should be a sub/superset of the BODC dictionaries.

DIC_CMD_ORGANISATION

Dictionary table containing the controlled vocabulary for organisations associated with a cruise, specifically the client and the contractor. There is a very high cost of maintaining them and deciding which entry should be used - just look at the number of different names "BP" has had. This system is an attempt to meet the needs of CMD by the use of abbreviations.

DIC_CMD_PAPER_FORM_TYPE

Dictionary table giving simple categorisation of BGS-held Coastal and Marine Data Sheets by their paper form and content (information). Includes SHEET_ORDER, which is the order of preference for the retrieval (display) of the Data Sheets for a given location.

DIC_CMD_PROPERTY_SOURCE

Dictionary of source of properties (the data domain) for the Coastal and Marine Database e.g. sample data may be PSA (Partical Size Analysis), GEOL (Geological) or GTCH (Geotechnical).

DIC_CMD_PROPERTY_TYPE

Dictionary of property types and the range of values permissable for their use in the Coastal and Marine Database.

DIC_CMD_SAMP_METHOD

Dictionary table containing codes and translations for the sampling equipment used to collect data and samples.

DIC_CMD_SAMP_SUCCESS

Dictionary table containing the controlled vocbaulary for the success of a sampling activity.

DIC_CMD_SHIP

Dictionary table containing the controlled vocabulary for ships. It will be populated from the existing dictionary PMGG.DICTIONARIES (where TYPE=?SHIP?) but the data will need subsequent cleaning. The BGS standard for dictionaries includes a Translation field and a Description field. The translation being a shortish name (for use in drop-down boxes) and description being a full definition. In this case, Description seems unnecessary.

DIC_CMD_SITE_SVY_EQUIP

Dictionary of equipment types for use with site surveys in the Coastal and Marine database.

DIC_CMD_SITE_SVY_TYPE

Dictionary of site survey types for use with site surveys in the Coastal and Marine Database.

DIC_CODE_STAT

Dictionary table containing dictionary code status descriptions, eg. Current.

DIC_COLOUR_QUALIFIER

A dictionary of qualifiers as applied to Base colours eg Reddish. The codes used here must be the same as their equivalents in Base Colour dictionary ie Red and Reddish; Blue and Bluish are same in code form in both tables.

DIC_COLOUR_RELATIONSHIP

A dictionary describing the relationships between colours as applied to a Borehole section property list where more than one colour property is entered. Egs: Laminations, lenses etc. (Note the close similarities with Sedimentary (micro) structures).

DIC_COLOUR_STRENGTH

A dictionary of colour strengths (saturation levels) applied to full colour descriptions eg: Brilliant Blue; Moderate Red etc.

DIC_COL_ORIG

Dictionary of the colour systems used for the columns COLOUR1 and COLOUR2 in LOIS_BOREHOLE_LITHOLOGYV2 . The column is referenced by and used to constrain COL_ORIGIN column in LOIS_BOREHOLE_LITHOLOGY_V2

DIC_COMMODITY

Dictionary of saleable commodities (eg. barytes) produced by mines and quarries.

DIC_CONF

Dictionary of types of data confidentiality. Old confidentiality dictionary used by BGS tables, been rationalised into an ISO version.

DIC_CORE_CHARACTER_DETER

Dictionary that gives codes to identify control samples used to monitor the quality of geochemical data from the G-BASE project.

DIC_COUNTRY

Dictionary of country names, including all ISO 3166 codes

DIC_COUNTY_COORD

Dictionary table containing coordinates of County series geological maps for England and Wales (all logical sheets).

DIC_COUNTY_COORDS_SC

Dictionary table containing coordinates of County series geological maps for Scotland (all logical sheets).

DIC_CRS_HORIZ_CS

Dictionary of horizontal coordinate systems, mostly sourced from EPSG database. Data from the normalised EPSG database is summarised and joined when populating this table. The table should be updated as new versions of the EPSG database are released.

DIC_CRS_VERT_CS

Dictionary of vertical coordinate systems, mostly sourced from EPSG database and FGDC. Data from the normalised EPSG database is summarised and joined when populating this table. The table should be updated as new versions of the EPSG database are released.

DIC_DATAFILE_STORAGE_TYPE

Dictionary for the types of storage for derived data. Egs: Oracle table, Access table, ASCII text etc.

DIC_DATETIME_RELPOS

Dictionary table of date comparison operators - before, after, equals.

DIC_DATE_ACCURACY

A dictionary of valid Date Accuracies used to describe Dataset start/end dates of capture (see DIC_DATE_STATUS)

DIC_DATE_STATUS

A dictionary of valid Date Statuses for beginning/ending of Dataset data capture

DIC_DATING_METHOD

Dictionary table listing codes used for analytical methods used for chronometric age determination.

DIC_DEFORMATION_EPISODE

Dictionary of the stages of deformation episodes during which a structure could be formed.

DIC_DELIVERY_FORMAT

A dictionary listing various formats that a dataset to be delivered could have.

DIC_DEM_HEIGHT_ORIGIN

This is a dictionary to describe the source DEM for the estimate for the DEM at this borehole location; for example CEH, OS or Nextmap.

DIC_DENS_COMP_STR

A dictionary of rock density, compactness, strength and hardness terms.

DIC_DENS_COMP_STR_5930

A dictionary of rock density/compaction/strength using the BS5930 scheme.

DIC_DEPN_MODE

Dictionary of depositional modes

DIC_DIP_METHOD

Dictionary describing method used to determine dip of an inclined surface

DIC_DOLINE_PLAN_SHAPE

Dictionary table which defines the terms for describing the shape of dolines when viewed from above.

DIC_DOLINE_PROFILE

Dictionary table which defines the terms for describing the profile shape of the doline (vertical section).

DIC_DOLINE_SUBSIDENCE_TYP

Dictionary table which defines the terms for describing the type of subsidence that has caused the doline.

DIC_DOLINE_TYPE

Dictionary table which defines the terms for describing the type of doline and how it was formed.

DIC_DTA_REF_MATERIAL

Dictionary of International Reference Materials (Primary Reference Materials) frequently submitted with every batch of samples (soils, sediments and rocks) submitted for chemical analysis. They are an essential part of the quality control procedure and can be used to determine the accuracy and precision of the analyses.

DIC_EDAT

Dictionary table constraining the values entered into the DATE_KNOWN_TYPE field in the new BGS.BOREHOLE table.

DIC_ELEMENT

Dictionary of substances that cannot be decomposed by chemical reaction into simpler substances.

DIC_END_USE

Dictionary for the end uses (eg brick manufacture) of various mineral commodities (eg clays, shales, fireclays and sand).

DIC_EPR

Dictionary of Economic Planning Regions (EPRs) for the Britpits database.

DIC_EQUIPMENT_TYPE

Dictionary of BGS drilling equipment types that can be booked out.

DIC_EXPORT_FORMAT

A Dictionary of Formats for exported data. Egs: GIF, JPEG, VRML etc. Note Formats are categorised into `types`. (see DIC_EXPORT_TYPE).

DIC_EXPORT_TYPE

A Dictionary of types of export data. Egs: Binary digital Image file; Conventional photograph etc.

DIC_FAULT_DISPL

Dictionary containing the sense of displacement across fault or shear zones. (Descriptions of different fault types).

DIC_FEATURE_TYPE

Dictionary table of geological feature types. Part of the GSD, SIGMA suite of corporate dictionaries requested. Yet to be approved (MLN, 3-06-08).

DIC_FOLDAXIS_VERGNCE_TYPE

Dictionary describing nature of fold axis direction changes, eg. right-handed, left-handed.

DIC_FOLD_CLASS

Dictionary table to hold fold classes.

DIC_FOLD_SHAPE

Dictionary of the shape of fold in profile view, based on the intelimb angle.

DIC_FOLD_TYPE

Dictionary of fold types and associated codes; eg minor anticline = MAC.

DIC_FORMAL_CODE

Dictionary table with codes and descriptions for some types of entry into tables.

DIC_FORMER_COUNTY

Dictionary of Former County information for the Britpits database.

DIC_FORMLINE

Dictionary of formlines used in geological feature mapping. Most represent changes in slope between adjacent slope facets.

DIC_FOSSL_BAND_T

Dictionary table of the class of fossiliferous band shown on the map, eg marine band, coral band.

DIC_GAZ_ALL_FEATNAME

This dictionary is a materialized view unioning all Gazetteer feature layers.

DIC_GENERIC_FILE_EXTENSION

Dictionary of file extensions of generic type, as related to files defined in the table MODEL_LOB_STORE_FILE. Egs: Drawing exchange file, Datafile, ESRI Shapefile etc.

DIC_GEN_DIP

Dictionary of generalized dip of a surface based on estimation or inference.

DIC_GEOCHRON

Dictionary table holding codes, names and radiometric ages of geochronological intervals that can be used in BGS databases. It is this table that acts as the domain constraint on corporate data tables.

DIC_GEOCHRON_AGE_TYPE

Dictionary to constrain age types used in DIC_GEOCHRON. E.g. definite; interpolated; approximate.

DIC_GEOCHRON_INTERIM

Dictionary table which is an "interim" version of DIC_GEOCHRON. This table holds all the entries in DIC_GEOCHRON plus some deprecated entries (old codes that should no longer be used). This is so that data tables that still use deprecated codes will continue to function. This is the table that data tables still using deprecated geochronological codes should reference. Table structure the same as DIC_GEOCHRON.

DIC_GEOCHRON_RANK

Dictionary to constrain ranks of geochronological intervals used in DIC_GEOCHRON. E.g. Eon; Era; Period; Epoch; Age.

DIC_GEOCHRON_SCHEME

Dictionary to constrain geochronological schemes used in GEOCHRON_JOIN. E.g. BGS approved geochronology; British onshore Quaternary chronostratigraphy; British offshore Quaternary chronostratigraphy.

DIC_GEOPHYSICS_LOG

Dictionary table containing codes for geophysical log types, eg DIL = dual induction log.

DIC_GEOP_METHOD

Dictionary of geophysical methods - used to constrain GEOP_ACTIVITY table.

DIC_GEOP_PUBLICATION

Dictionary of type of publications - used to constrain GEOP_PUBLICATION table.

DIC_GEOP_RECORD_MEDIUM

Dictionary of types of geophysical survey records - used to constrain GEOP_RECORD table.

DIC_GEOP_SURVEY_CLASS

Dictionary of types of geophysical survey, eg. aeromagnetic, gravity.

DIC_GEOP_SURVEY_OBJECTIVE

Dictionary of geophysical survey objectives - used to constrain GEOP_SURVEY table.

DIC_GEOP_SURV_VISIBILITY

Dictionary of geophysical survey visibilities (eg commercial-in-confidence, public) used to constrain GEOP_SURVEY table.

DIC_GEOP_TECHNIQUE

Dictionary of geophysical techniques - used to constrain GEOP_ACTIVITY table.

DIC_GLOS_FILETYPE

A Dictionary of GLOS (Geoscience Large Object Store) file types in the broadest sense. Eg: Log File, Software Configuration, Spreadsheet.

DIC_GRAIN_SHAPE

A dictionary of grain shapes.

DIC_GRAIN_SHAPE_5930

A dictionary of grain shape using the BS5930 shape scheme.

DIC_GRAIN_SHAPE_BGS

A dictionary of grain shape using the BGS RCS shape scheme.

DIC_GRAIN_SIZE

A dictionary of grain sizes.

DIC_GRAIN_SIZE_5930

A dictionary of grain size using the BS5930 scheme.

DIC_GRAIN_SIZE_BGS

Dictionary of grain size using the BGS RCS modified Wentworth scheme.

DIC_GRAIN_SIZE_UW

Dictionary of Udden-Wentworth grain-size classification scheme (Wentworth, 1922).

DIC_GRAIN_SORT

A dictionary of various grades of grain sorting.

DIC_GRAIN_SORT_BGS

Dictionary of various grades of grain sorting using the BGS RCS sorting scheme.

DIC_GTCH_CBRG_COND

Geotechnical Database Dictionary Table - CBR Condition.

DIC_GTCH_CBRG_METH

Geotechnical Database Dictionary Table - CBR Method

DIC_GTCH_CHLK_DEN

Geotechnical Database Dictionary Table - Chalk Density.

DIC_GTCH_CHLK_FLINTS

Geotechnical Database Dictionary Table - Chalk Flint Content

DIC_GTCH_CHLK_GRAD

Geotechnical Database Dictionary Table - Chalk Grade

DIC_GTCH_CMPG_TYPE

Geotechnical Database Dictionary Table - Compaction Type

DIC_GTCH_CNMT_TEST_TYPE

Geotechnical Database Dictionary Table - Contaminant Test Type

DIC_GTCH_CNMT_TYPE

Geotechnical Database Dictionary Table - Contaminant type

DIC_GTCH_CONG_COND

Geotechnical Database Dictionary Table - Consolidation condition

DIC_GTCH_CONG_TYPE

Geotechnical Database Dictionary Table - Consolidation type

DIC_GTCH_CVT

Geotechnical Database Dictionary Table - CV type

DIC_GTCH_DATE_ACCURACY

Geotechnical Database Dictionary Table - Date accuracy

DIC_GTCH_DISCONTINUITY

Geotechnical Database Dictionary Table - Discontinuity

DIC_GTCH_DISC_TERM

Geotechnical Database Dictionary Table - Discontiniuty termination

DIC_GTCH_DISC_TYPE

Geotechnical Database Dictionary Table - Discontinuity type

DIC_GTCH_DRILLING_METHOD

Geotechnical Database Dictionary Table - Drilling method

DIC_GTCH_FEATURES

Geotechnical Database Dictionary Table - Features

DIC_GTCH_HOLE_LOCM

Geotechnical Database Dictionary Table - Hole location method

DIC_GTCH_IPRM_TYPE

Geotechnical Database Dictionary Table - Insitu permeability method

DIC_GTCH_IRES_TYPE

Geotechnical Database Dictionary Table - Insitu resistivity method

DIC_GTCH_ISPT_TYPE

Geotechnical Database Dictionary Table - Insitu Standard Penetration Test type

DIC_GTCH_PLTF

Geotechnical Database Dictionary Table - Point load type

DIC_GTCH_PRTD_TYPE

Geotechnical Database Dictionary Table - Pressuremeter type

DIC_GTCH_PTST_COND

Geotechnical Database Dictionary Table - Lab permeability test sample condition

DIC_GTCH_RWL_ACCURACY

Geotechnical Database Dictionary Table - Resting water level accuracy

DIC_GTCH_SAMP_TYPE

Geotechnical Database Dictionary Table - Sample type

DIC_GTCH_SHBG_TYPE

Geotechnical Database Dictionary Table - Shear box type

DIC_GTCH_STCN_TYPE

Geotechnical Database Dictionary Table - Static cone type

DIC_GTCH_SUCT_METH

Geotechnical Database Dictionary Table - Suction method

DIC_GTCH_TRIG_COND

Geotechnical Database Dictionary Table - Triaxial sample condition

DIC_GTCH_TRIG_TYPE

Geotechnical Database Dictionary Table - Triaxial type

DIC_GTCH_TRIX_MODE

Geotechnical Database Dictionary Table - Triaxial mode of failure

DIC_HCL

Dictionary of codes used to denote the reaction of a particular lithological unit when Hydrochloric acid is applied. Used for the coding of LOIS boreholes.

DIC_HCL_REACTION

Dictionary of codes for the reaction of a particular lithological unit when Hydrochloric acid is applied. Used for the coding of LOIS boreholes.

DIC_HYDROCARB_TYPE

Dictionary of the types of hydrocarbon. E.g. Gas, oil, condensate

DIC_IGN_PLANAR

Dictionary describing type of primary planar igneous structure.

DIC_INCL

Dictionary table for borehole databases - borehole inclination

DIC_INTERNAL_STRUCTURE

Dictionary of internal bed structures. It is used in constructing the view DIC_PROPERTY_TYPE_V1, which in turn is used by the GeoEntry borehole geology data entry application.

DIC_KEYPHRASE

This dictionary is the central table of the BGS geoscience thesaurus. It contains approximately 6000 descriptor terms for concepts in the geoscience and related subjects. Some entries have scope notes to further explain the term. The original source of the data was the Australian Mineral Foundation's thesaurus of geoscience; some terms have been added or updated to suit BGS needs and the content will continue to be updated as required. Related tables hold the synonyms to descriptor terms, hierarchical relationships, conceptual (?see also?) relationships and lapsed (deprecated) term replacements.

DIC_LANDFRM_OBS_PT

Dictionary describing point observations associated with landform eg summit of drumlin.It is always linked spatially to a landform, not recorded separately.

DIC_LANDFRM_TYPE

Dictionary of various types of landform, eg kettlehole, roche moutonee.

DIC_LATLONG_ORIGIN

Dictionary for the method of calculating lat/long values from British National Grid coordinates

DIC_LINEAR_BEDROCK

Dictionary of geology extents that require representation as a linear object on maps, at the scale of representation .

DIC_LINEAR_SUPERFICIAL

Dictionary of geology extents that require representation as a linear object on maps, at the scale of representation .

DIC_LIN_IGN_STRUCT

Dictionary of terms classifying the feature forming a primary (i.e. 'non-tectonic') lineation. Expanded from DIC_SOLE_STRUCTURE and DIC_BED_SURFACE_STRUCT.

DIC_LIN_MOVEMENT_SENSE

Dictionary of attributes indicating the direction of movement, elongation or crystal growth indicated by secondary lineations.

DIC_LIN_SED_STRUCT

Dictionary of terms classifying the feature forming a primary (i.e. non-tectonic) lineation. Expanded from DIC_SOLE_STRUCTURE and DIC.BED_SURFACE_STRUCT E.g. "Flute", "Groove", "Primary Current Lineation".

DIC_LITHOSTRAT_RANK

Dictionary table containing codes and descriptions of the rank of lithostratigraphical units.

DIC_LITHOSTRAT_STRATOTYPE

Dictionary table containing varieties of stratotype that may be used in defining a named rock unit.

DIC_LS_CAUSE

Dictionary table denoting the possible cause of a landslide - for example it could have been an adverse slope angle or structural features (natural) or excavation of material from the bottom of the slope (artificial).

DIC_LS_CAUSE_NATURE

Dictionary table denoting whether a landslide was caused by natural processes (eg high rainfall) or by man-made activity (eg excavation).

DIC_LS_DAMAGE_CLASS

Dictionary table giving codes for the extent of damage caused by a landslide

DIC_LS_DATA_SOURCE

Dictionary table with codes recording who reported the landslide e.g. media, company, university, government agency, individual.

DIC_LS_DIRECTION

Dictionary table with codes denoting the direction of bedding planes or joints in relation to the slope.

DIC_LS_DOM_SOURCE_MAT

Dictionary table with codes denoting dominant constituents of material making up the landslide - for example: debris (mainly gravel or pebbles), earth (dominantly clay) etc..

DIC_LS_ESTIMATED_AGE

Dictionary table containing codes for the estimated age of a landslide.

DIC_LS_H2O

Dictionary table for hydrology of slope and landslide - codes for water content of landslide material.

DIC_LS_IMAGE_TYPE

Dictionary table which refers to the type of image used to record the landslide, e.g. air photo, satellite image, field drawing.

DIC_LS_LANDUSE

Dictionary of land use types of the areas on and around the slope where landslides have occurred.

DIC_LS_NGR_PROVENANCE

Dictionary with descriptions of how the national grid reference of the landslide was measured - e.g. by GPS or from a map.

DIC_LS_RELATIVE_POSITION

Dictionary table with codes denoting the position on the slope surrounding the landslide where most damage occurred e.g. at the side or at the foot of the landslide.

DIC_LS_SPACING

Dictionary of distances between discontinuities - anything between 0.2m and 2.0m .

DIC_LS_STABILITY_DEGREE

Dictionary table with descriptions of the stability of the landslide, recorded at the time of visit by BGS geologist.

DIC_LS_STABILITY_DEV

Dictionary for the condition of a landslide's features, e.g. fresh, advanced or eroded.

DIC_MAN_MDE_AR_T

Dictionary table describing different types of man-made areas, eg. worked ground, infilled ground.

DIC_MAPPING_STAT

Dictionary table with codes for mapping status (stage in preparation), eg. pending. Used for DIGMAPGB Index.

DIC_MAP_SCALE

Dictionary table of common mapping scales.

DIC_MAP_SERIES

Dictionary table with codes for OS and BGS map series, eg. OS National grid 1km square = 'NG1k'.

DIC_MAP_THEME

Dictionary table containing a list of possible Geological Themes for a BGS Map (eg Bedrock or Superficial Geology).

DIC_META_BUS_RULE_CAT

"Dictionary of business rule categories for BGS databases. This dictionary is used in the Technical Metadata system to indicate the a rule category (s) of the businnes rules defined against database objects (designs) predominantly within the oracle system.

DIC_META_GLOSSARY

Dictionary table of terms available to applications as Glossary Entries. This is designed for use within the Technical Metadata application but could be adopted for use in other applications.

DIC_METRE_EXACTNESS

A dictionary of metre exactness. It can be used for recording precision and/or accuracy.

DIC_MET_ACCESSUSE_RESTRIC

Discovery Metadata dictionary of types of limitations placed upon the access or use of a resource. An implementation and extension of ISO codelist B.5.24 MD_RestrictionCode.

DIC_MET_BUSINESS_VAL

Metadata dictionary to describe the importance of a resource to the business in terms of business recovery.

DIC_MET_COLLECTION

Metadata dictionary of metadata collection titles. Provides values for ISO metadata element no. 371 collectiveTitle.

DIC_MET_CONFIDENTIALITY

Metadata dictionary of codes to describe confidentiality of a resource. An implementation and extension of ISO codelist B.5.11 MD_ClassificationCode.

DIC_MET_CONTACTROLE

Discovery Metadata dictionary of functions performed by a responsible party. An implementation and extension of ISO codelist B.5.5 CI_RoleCode.

DIC_MET_DATACONFIDENCE

Metadata dictionary to describe the confidence or uncertainty in data, interpretations, modelling assumptions etc.

DIC_MET_DATA_ASSOCIATION

Metadata dictionary of types of association between resources. An implementation and extension of ISO codelist B.5.7 DS_AssociationTypeCode.

DIC_MET_DATE_EVENT

Discovery Metadata dictionary of types of reference date events. An implementation and extension of ISO codelist B.5.2 CI_DateTypeCode.

DIC_MET_DIG_FORMAT

Metadata dictionary of digital data formats. An implementation and extension of ISO codelist B.5.26 MD_SpatialRepresentationTypeCode.

DIC_MET_INSPIRE_THEME

Dictionary table of INSPIRE spatial data themes from the GEMET Thesaurus. Not an exhaustive list, only the concepts that might be needed within BGS. Taken from http://www.eionet.europa.eu/gemet/inspire_themes?langcode=en. Citation title for this keyword collection=INSPIRE Spatial Data Themes

DIC_MET_MAINTFREQ

Discovery Metadata dictionary of frequency of update of resources. An implementation and extension of ISO codelist B.5.18 MD_MaintenanceFrequencyCode.

DIC_MET_ONLINEFUNCTION

Metadata dictionary of types of function provided by an online resource. An implementation and extension of ISO codelist B.5.3 CI_OnLineFunctionCode.

DIC_MET_PRCESSSTEP_TYPE

Metadata dictionary of types of process steps used in geological modelling and data processing. Provides controlled values for ISO element number 87 LI_ProcessStep.description.

DIC_MET_PRESFORMAT

Metadata dictionary of formats in which a resource can be represented. An implementation and extension of ISO codelist B.5.4 CI_PresentationFormCode.

DIC_MET_PROGSTATUS

Metadata dictionary of status of a resource or progress of a review. An implementation and extension of ISO codelist B.5.23 MD_ProgressCode.

DIC_MET_QUALITY_MEAS

Metadata dictionary of types of quality assessments that can be applied to a data or model resource. Provides controlled values for ISO element number 100 DQ_Element.nameOfMeasure and the sub classes of ISO element DQ_Element.

DIC_MET_SPATIAL_REP_TYPE

Metadata dictionary of spatial representation types. An implementation and extension of ISO codelist B.5.26 MD_SpatialRepresentationTypeCode.

DIC_MET_TOPICCATCD

Metadata dictionary of high level thematic classification that can be applied to a resource. Contains values from ISO codelist B.5.27 MD_TopicCategoryCode.

DIC_MGM_COMPONENT

Geomagnetic component dictionary.

DIC_MGM_INSTRUMENT_TYPE

Geomagnetic instrument dictionary.

DIC_MGM_OBSERVATORY

Geomagnetic observatory dictionary.

DIC_MGM_RECORDING_METHOD

Methods of recording magnetogram dictionary.

DIC_MGT

Dictionary table used to constrain the values entered into the DATA_MANAGEMENT field in the new BGS.BOREHOLE table.

DIC_MINERAL

Dictionary of minerals and allocated codes; eg biotite - BITE.

DIC_MINE_DATA_SOURCE

Dictionary of data sources for Mine Entrances database (BGS.MINE_ENTRANCE).

DIC_MINE_ENTRANCE_TYPE

Dictionary of different mine entrance types for Mine Entrances database (BGS.MINE_ENTRANCE).

DIC_MIN_SITE_TYPE

A dictionary of mineral working sites where minerals are stored, loaded, produced, unloaded or transported.

DIC_MJR_AREL_STR_TYPE

Dictionary of the types of major areal structural elements. E.g. Sedimentary basin, sub-basin, block, igneous centre.

DIC_MJR_LIN_STR_TYPE

Dictionary of the types of major linear structural elements, eg. fault, anticline.

DIC_MODELLING_SWARE_PRODUCT

A Dictionary of Software products and an indication of dimensions worked in (2 or 3 D).

DIC_MODEL_TYPE

A Dictionary of Model types. Egs: Geological Surface(s), Block(s) Model, Fluid Flow etc.

DIC_MOVEMENT_STYLE

Dictionary table assigning unique codes to different styles (as opposed to types) of landslide movement.

DIC_MOVEMENT_TYPE

Dictionary table assigning unique codes to different types (as opposed to styles) of landslide movement.

DIC_MPA

Dictionary of Mineral Planning Authorities (MPAs) for the Britpits database. This table replaces BGS.GPA and is based on the British Standard BS 6879:1999.

DIC_MQ_PIT_STATUS

Dictionary table containing codes for use of mineral sites past and present, e.g. active, landfill.

DIC_MQ_STONE_ASSESSMENT

Dictionary of building stone assessment types used to indicate the type of assessment carried out on samples in the Britrocks database.

DIC_MUNSELL_BASE_COLOUR

A dictionary of Munsell Base Colours and their associated ordinal position on the Munsell Colour `sphere`/`disc`.

DIC_MUNSELL_BGS_BASE_COL

A X-reference dictionary table mapping Munsell Base Colours (eg YR for YellowRed) to BGS Base Colours (Yellow, Red in the example quoted).

DIC_MUNSELL_COLOUR

A dictionary of Munsell Colours as they appear in the universal Munsell Colour chart. Each colour is defined by a 4 primary fields:Base Colour, Hue, (these 2 combined give you a position on the Munsell Colour).

DIC_MUNSELL_COLOUR_ALL

Dictionary of colour classification using the Munsell coding system created by Albert H Munsell in 1905, adopted by the USDA (United States Department of Agriculture) as the official colour system for soil research and by the GSA (Geological Society of America) as the official colour system for rock colour.

DIC_NCP_ANALYSIS_SOURCE

Dictionary table for the source of the sample analysis record.

DIC_NCP_PROPERTY

Dictionary of properties determinded during coal analysis, does not and should not contain geochemical properties that already exist in the geochemistry database table MTA_DOM_ANALYTE.

DIC_NCP_SAMPLE_PREP_TYPE

Dictionary of preparation methods which are used in the analysis of coal samples.

DIC_NSD_BUILDING_MATERIAL

Dictionary of the broad classification of material used in a built site. Used by Building stones database.

DIC_NSD_BUILDING_STATUS

Dictionary of listed building designation codes. Used by the Building stones database.

DIC_NSD_EVENT_TYPE

Dictionary of the types of building work undertaken on a built site within a given range of dates of the related building event. Used by the Building stones database.

DIC_NSD_HISTORICAL_ERA

Dictionary of historical eras defined for the purpose of defining the building periods of built sites. Used by the Building stones database

DIC_NSD_REFERENCE_SCHEME

Dictionary of a list of the external classification schemes and the URL path which can be used when combined with the external reference code in the bs_reference_code table. Used by the Building stones database. Used by the Building stones database.

DIC_NSD_SITE_TYPE

Dictionary of detailed classifications of the type of built site.e.g. church, wall etc

DIC_NSD_STONE_AREA_USAGE

Dictionary of the estimates of the significance of the use of a stone in the area concerned. Used by Building stones database

DIC_OLD_ONE_INCH_COORD

Dictionary table listing One-inch sheets and their spatial coordinates (eg, SWE, SWN etc).

DIC_OPERATING_SYSTEM

A Dictionary of Operating Systems under which modelling products can run, eg. Microsoft Windows 2000.

DIC_ORG_CON

Dictionary of codes for the organic content of a particular lithological unit. Used for the coding of LOIS boreholes.

DIC_OS

Dictionary of codes detailing the operating system that the storage medium of digital map was written. Relates to the DIGMAPGB Index.

DIC_PALAEOCURRENT_REL

Dictionary of terms describing the direction of palaeocurrent flow relative to a linear sedimentary structure measurement. The terms are described as relative to the plunge of the lineation measurement e.g. "down plunge". Parameter is needed to assist correction of palaeocurrent measurement for tectonic dip.

DIC_PALGEOL_TER_TYPE

Dictionary of the types of palaeogeological terranes. E.g. Microplate, microcontinent, continent.

DIC_PAL_FOSSIL_COMMENT

Dictionary table which defines comments on fossil occurrences that can be used in the Borehole Geology properties table BH_GEOLOGY_PROPERTY. It is used (along with other dictionaries) in the Oracle view DIC_PROPERTY_TYPE_V1 which assembles the list of property types and values offered to the user by the GeoEntry borehole log coding application.

DIC_PAL_IDENT_COMMENT

Dictionary of comments on identifications, used by Palaeosaurus. E.g. NOTE = note in sample tray; ILLEG = written ident illegible.

DIC_PAL_ITEM_TYPE

Dictionary of palaeontological item types which can be logged as a sample (or part of a sample), used by Palaeosaurus. E.g. HS = hand specimen, this is probably the most common item type in palaeosaurus.

DIC_PAL_LOCATOR_METHOD

Dictionary of the methods used to describe a location, used by Palaeosaurus. E.g. BG1 = British National Grid, estimated in the field; LL = Latitude/Longitude.

DIC_PAL_STRAT_QUALIFIER

Dictionary of qualifiers on stratigraphical assignments, used by Palaeosaurus. E.g. U = upper; M = middle; L = lower.

DIC_PAL_TAXON

A dictionary of fossil groups. NB 1: This has different design to the first Palaeosaurus version. NB 2: This will need to be replaced eventually with a hierarchical lexicon of fossil taxonomy (of which this table could form the heart).

DIC_PAL_TYPE_STATUS

Dictionary of types of 'Type Status' a specimen could be assigned, used by Palaeosaurus. E.g. H = Designated as holotype; UT = Undifferentiated type.

DIC_PLANR_STRU_T

Dictionary of the class of planar structure, eg, bedding, crenulation cleavage.

DIC_PLATE_BOUND_TYPE

Dictionary of the types of plate boundaries. E.g. Spreading centre, subduction zone, transform margin.

DIC_PLN_RECORD_TYPE

A dictionary of plan types, e.g. mine plan, cross section, abandonment plan etc.

DIC_PLN_SERIES

A dictionary of plan series codes.

DIC_PM_ASSIGND_GEOL_NAME_BASIS

Dictionary that contains terms to denote the basis on which a geological name has been assigned to a geological sample for use in the BritRocks database. Dictionary that contains terms to denote the basis on which a geological name has been assigned to a geological sample for use in the BritRocks database.

DIC_PRB_DATA_SOURCE

Dictionary of original source of information for the PropBase database.

DIC_PRB_MEAS_TYPE

Dictionary of measurement type for the PropBase database.

DIC_PRIORITY

Dictionary table containing valid priorities for the software error reporting system (from very high to very low).

DIC_PRODUCT_FILE_EXTENSION

Dictionary table containing file extensions for files in the table MODEL_LOB_STORE_FILE, which are product specific. Eg: EarthVision has extns: 2GRPT=2D Grid data points; 2GRD=2D Grid data defined as Origin + Offsets.

DIC_PROFILE

Dictionary of profile descriptions (eg. staff based at Cardiff) and associated codes, as used by the staff movements diary.

DIC_PROPERTY_TYPE

Dictionary which provides constraints on the property table, eg. grain shape, grain size, chronostratigraphy.

DIC_QUARRY_PRODUCT

Dictionary table containing a listing of quarry products. (e.g Agricultural Fertilisers, building stone, concrete blocks, dry stone walling etc.)

DIC_QUARTER

Dictionary; used as a foreign key constraint to control values input to the field QUARTER - meaning, the National Grid Quarter Sheet quadrant. This input was previously validated via trigger checks - these being removed as bad practice.

DIC_RCS1_MAP_RCS2

Dictionary table listing rocks and rock products in parts 1 and 2 of the BGS Rock Classification Scheme, eg. dolerite, brick.

DIC_RCS_AMOUNT

Dictionary table which holds codes for the amount of single lithologies that make up a composite lithology. Part of version 3 of the BGS Rock Classification Scheme.

DIC_RCS_STATUS

Dictionary table used to validate field RCS_STATUS in the table DIC_ROCK_NAMEV3. This validation was previously controlled by a check constraint - this is now removed.

DIC_REFERENCE_TYPE

Dictionary table containing descriptions of reference types and their codes.

DIC_ROCK_ALL

Dictionary table based on the entire version 3 of the BGS Rock Classification Scheme and is populated directly from the 3 supplying tables (BGS.ROCK_NAME_V3, BGS.ROCK_COMPOSITE and BGS.DIC_ROCK_DUMMY). It contains both the base rock names and addditional codes required for specific application, eg. composite names for use on digital geological maps. It is formally approved as the official source of ALL database codes to be used in BGS corporate databases and MUST be followed.

DIC_ROCK_ALL_SOURCE

Dictionary for the source tables of entries in version 3 of the BGS Rock Classification Scheme

DIC_ROCK_CLASS

Dictionary of Child/Parent relationships in the Rock Classification Scheme.

DIC_ROCK_CLASSV3

Dictionary table containing the hierarchy of the RCS. Part of version 3 of the BGS Rock Classification Scheme.

DIC_ROCK_COMPOSITE

Dictionary table that holds the code (e.g. IBSDSS) and description (e.g. interbedded sandstones and siltstones with mudstone lenses in the sandstone) of the composite. Part of version 3 of the BGS Rock Classification Scheme.

DIC_ROCK_HIERARCHY

A Dictionary of Hierarchical codes for use within the Rock Classification Scheme

DIC_ROCK_HIERARCHYV3

Dictionary table which is part of version 3 of the BGS Rock Classification Scheme. This table contains codes for the types of hierarchy within the RCS.

DIC_ROCK_NAMEV3

Dictionary table which is part of version 3 of the BGS Rock Classification Scheme. The main part of the RCS - it contains only single lithologies.

DIC_SCAN_QUALITY

Dictionary describing the quality of the scan. This will be constrained to 'Good', 'Bad' or 'Not Entered' with a default of 'Not Entered'.

DIC_SCAN_SOURCE_QUALITY

Dictionary describing the quality of the original paper copy to be scanned. This will be constrained to 'Good', 'Bad' or 'Not Entered' with a default of 'Not Entered'.

DIC_SDO_GTYPE

Domain containing all Codified values for the Geometry of the Spatial Object. A Spatial Object may be a Line, Point or Polygon and may have 2 or 3 dimensions.

DIC_SECONDARY_DISC

Dictionary of discontinuities within rocks caused by secondary geological processes, eg faults.

DIC_SECONDARY_LIN

Dictionary of Linear structures formed within rocks or on discontinuity surfaces by secondary geological process.

DIC_SECTION_GEOMETRY

Dictionary table describing the way in which Section data has been recorded, ie. Polygons, Polylines, or a mixture of both.

DIC_SECTION_SOURCE

Dictionary table describing types of Section in terms of their Origin, eg. geological map, seismic survey, modelling.

DIC_SEC_COMPONENT_TYPE

Dictionary of codified value for the Type of Component in a Section e.g. :- Sketch, Drawing, Photograph, Diagram, Report, Fair Drawn Diagram, Field Sketch.

DIC_SEC_TYPE

Domain containing all Section Types.

DIC_SED_STRUCT

See Associated LOIS dictionary table for description.

DIC_SEISMIC_SRC

Dictionary that identifies the source used to obtain the seismic data; eg. airgun or dynamite.

DIC_SEISMIC_STRAT

Dictionary of codes with which to indicate reasons for missing descriptions for stratigraphy, for example 'Not Applicable'.

DIC_SEIS_SURVEY_TYPE

Dictionary containing indicators to identify if a seismic survey is 2D or 3D.

DIC_SEIS_SURVEY_ZONE

Dictionary containing indicators for onshore, offshore and transition zone seismic surveys.

DIC_SHADE

A dictionary of shades (from dark to light) as applied to full colur descriptions eg Dark Blue etc.

DIC_SHEET

Dictionary table containing the sheet numbers and names of BGS 1:50K (formerly 1-inch) geological sheets. This is an important dictionary and validation tool, referenced by various databases, including the Lexicon.

DIC_SIDE

Dictionary describing the side of a line or surface, denoted by a compass octant, eg N, SW.

DIC_SINK_FLOW

Dictionary with codes for different types of fluid flow into a sinkhole, eg. intermittent, flood.

DIC_SINK_MORPHOLOGY

Dictionary with codes for different types of sinkhole, eg. compound sink, single sink.

DIC_SINK_SIZE

Dictionary with codes for the size of a sink, ranging from 'trickle' to 'large river'.

DIC_SLI_COLLECTION

Dictionary which identifies the collection seismic data belongs to, for example C for Coal Authority or B for BGS.

DIC_SLI_DATA_FRMT

Dictionary which identifies whether digital data are available and if seismic data were received in digital format or if it was scanned or vectorised.

DIC_SLI_LINE_PART

Dictionary used where a seismic line is divided into more than one part and each part is labelled separately (e.g. BP-79A, B, C or I,II, III etc)

DIC_SLI_OPERATOR

Dictionary cotaining codes which identify the operator seismic data belongs to, for example SHL for Shell.

DIC_SLI_PROCESS

Dictionary identifying processing, such as filtered or migrated stacks.

DIC_SLI_STORE

Dictionary which identifies the area where seismic data is stored.

DIC_SLOPE_PROFILE

Dictionary assigning unique codes to different types/styles of slopes, eg. concave versus convex.

DIC_SOLE_STRUCTURE

Dictionary table listing and expanding the codes for different types of sole structure, eg. flute casts, flame structures.

DIC_SPRING_CHARACTER

Dictionary of spring character (eg. diffuse) used to generate entries in the database GH_SPRING_VERSION2

DIC_SPRING_FLOW

Dictionary of spring flow types (eg. constant, fluctuating) used to generate entries in the database GH_SPRING_VERSION2.

DIC_SPRING_MAP_FEATURE

Dictionary of map annotation used to generate entires in the database GH_SPRING_VERSION2, eg. rises, issues.

DIC_SPRING_SITUATION

Dictionary of spring situation types used to generate entries in the database GH_SPRING_VERSION2; eg. open surface, submerged.

DIC_SPRING_SIZE

Dictionary of the source document/map/sensing types used to generate the entries in the databases GH_SPRING_VERSION2, also to be used for VERSION2 editions of BGS.SINKHOLE should it be called DIC-SPRING_SINK_SIZE

DIC_SPRING_USES

Dictionary of spring water uses (eg. agricultural), used to generate entries in the database GH_SPRING_VERSION2.

DIC_SPRING_WATER_TYPE

Dictionary of spring water type (eg. saline, fresh), used to generate entries in the database GH_SPRING_VERSION2.

DIC_SSD_DATA_SOURCE

A dictionary containing various sources from which data is collected/acquired for use in the Stratigraphic Surfaces Database (SSD).

DIC_SSD_SURFACE_TYPE

A dictionary of types of geological surfaces that can be recorded for use in the Stratigraphic Surfaces Database (SSD). E.g. Silicized Zone, Faulted, Terminal Depth, Dyke.

DIC_SSD_WELL_PURPOSE

A dictionary containing the purpose of wells for use in the Stratigraphic Surfaces Database (SSD). E.g. Hydrocarbon exploration, Mineral exploration.

DIC_STAGE_EQV_01

Dictionary of equivalent chronostratigraphic stages, eg Volgian.

DIC_STAGE_EQV_02

Dictionary of equivalent chronostratigraphic stages, eg. Tithonian.

DIC_STANDARDS_BODY

Dictionary of standards bodies, eg. British Standards Institute (BSI).

DIC_STRUC_FACE

Dictionary describing trend of structures, eg. sideways.

DIC_SUBSIDENCE_CAUSE

Dictionary describing the cause of subsidence, eg. mining subsidence, landslip.

DIC_SURFACE_REPRESENTN_TYPE

Dictionary of types of surface representation, eg: cross section, geological map polygon.

DIC_SURFACE_TYPE

Dictionary table containing a hierarchical classification of Geological Surfaces, used in the DGSM Model database to describe surfaces which have been modelled, eg. Conformable Stratigraphic Boundary, Fault, Igneous Contact Boundary.

DIC_SURF_MAPPING

Dictionary of the surfaces or discontinuities on which a geological feature is mapped eg. ground surface, rockhead.

DIC_SUSPENDED_SOLIDS

Dictionary containing codes used to qualitatively describe the abundance of suspended solids in a sample of water.

DIC_TAX_TAXON_CLASS

Dictionary of broad taxonomic groupings into which fossils might be grouped. Each entry more or less equates to what might be used as a chapter heading in a palaeontology text book. Analogous to DIC_LXN_UNIT_CLASS in the Lexicon of Named Rock Units. Note that 'class' here is used to mean a broad classification, and is not meant to imply that all the groupings used are defined at the 'class level' of the taxonomic hierarchy. Examples: Aves, Bivalvia, Brachiopoda.

DIC_TAX_TAXON_RANK

Dictionary of fossil taxonomic ranks. Analogous to DIC_LXN_UNIT_RANK in the Lexicon of Named Rock Units.

DIC_TECTONIC_EVENT_AGE

Dictionary describing periods of tectonic activity, eg: Cimmerian, Variscan, Laxfordian.

DIC_TECT_FOLIATION

Dictionary of types of secondary (tectonic or metamorphic) foliation, layering or cleavage.

DIC_TRAY_SIZE

Dictionary which lists different tray sizes (small, large etc.) in the NDGC tray store.

DIC_TRAY_TYPE

Dictionary which lists tray types (cardboard or wooden box etc.) in the NDGC tray store.

DIC_UKWM_BKTABLE_TYPE

Dictionary which indicates if the table is a UK minerals summary table or one of the wms tables. the table_type column is used for ordering the tables in the drop down list on the data entry opening form.

DIC_UKWM_CLASS_SCHEME

Dictionary of International commodity classification scheme.

DIC_UKWM_COMMODITY

Dictionary of the substance, whose statistic we record.

DIC_UKWM_COMMODITY_TYPE

Dictionary of the type of the commodity . can be either production/consumption only, trade only, or trade+production/consumption

DIC_UKWM_STAT_MEASURE

Dictionary of unit measures in which a statistic is held in the World Mineral Statistic database. This should only be used for the World minerals statictic database.

DIC_UKWM_STAT_SOURCE

Dictionary of the organisation that the statistic originates from.

DIC_UKWM_STAT_TYPE

Dictionary of import,export,production,consumption etc. the table_type is included since retrievals for a given table require us to limit the rows returned from the mineral statistics table to just statistic_type_id those relevant for that table

DIC_UNIT_OF_MEASURE

Dictionary of measurement units used for a specific property; e.g. metres, centimetres, inches, chains, fathoms, kilograms, tons, pints, quarts, gallons, litres, square metres, cubic metres.

DIC_UPDATE_FREQUENCY

Dictionary of valid Frequencies of Update of Datasets, eg. hourly, daily, weekly.

DIC_VEGETABLE_MATTER

Dictionary table renamed from DIC_VEGETATION to ratify with DMG(mln,07/04/08). Dictionary of matter produced by plants or growing in the manner of a plant.

DIC_VEGETATION

Dictionary of vegetation; plant life of a region; ground cover life forms,structure or any other specific botanical or geographic characteristics, eg. scrubs, trees, pasture. To be ratified by DMG(mln, 07/04/2008).

DIC_VEIN_FORM

Dictionary of vein morphologies in the surface of measurement, eg planar, en echelon, conjugate.

DIC_VEIN_NAME

Dictionary of named veins shown on a geological map.

DIC_VERTICAL_SCOPE

Dictionary of qualitative vertical extents, used to describe the vertical extent of geological information in a map, section, dataset, model etc.

DIC_VST_DETMAND

Dictionary of Determinands - e.g. LOI450, plastic limit, Cu. Langmuir and Freundlich KDs (for each element) should be included here as separate determinands. Note that if a determinand has to be quoted in a number of units then each determinand/units combination will have a separate entry in this dictionary

DIC_VST_DETMAND_QUAL

Dictionary of determinand qualifiers i.e. equals, greater than, less than.

DIC_WAYUP

Dictionary describing inferred direction of superposition of stratiform deposits, eg. overturned.

DIC_WF_LINK_CATEGORY

Dictionary of categories within the 3DMS (ex. DGSM) WorkFlow, used to logically group items within the workflow. Used as datasource for intranet based 3DMS WorkFlow application (http://bgsintranet/projects/dgsm/building.html).

DIC_WF_SECTION

Dictionary of project (e.g. DGSM, SIGMA etc.) workflow Actions (title, description, type and status). Action to be taken as part of completion of a `Workflow Stage`, may contain one or more `WorkFlow Action Resource Group` (DIC_WF_SUBSECTION).

DIC_WF_SUBSECTION

Dictionary table of project (e.g. DGSM, SIGMA etc.) workflow Action Resource Groups (title and status) Logical grouping of resources to aid in completion of a `Workflow Action` (DIC_WF_SECTION).

DIC_WF_URL_TEXT

Dictionary containing the text for workflow sections (e.g. DGSM, SIGMA) URL links.

DIC_WOBE

Dictionary containing information about mineral workings encountered by a borehole.

DIC_WSTK

Dictionary containing information about water strikes in a borehole. Eg. artesian flow, perched water table.

DIC_XML_ATTRIBUTE_TEXTS

This dictionary table contains the valid XML attribute texts (for NGDF profile), coded by Metadata Guidelines ID and an entry no.

DIC_XML_TO_DM_DICXREF

Dictionary table.This Xref table cross references Dic XML Attribute Texts to the appropriate BGS Discovery Metadata Dictionary codes. It maps BGS codes to the equivalent XML Attribute texts.Note that an XML attribute text/value can have many equivalent BGS codes.Lack of an entry, resulting in no mapping across from BGS Dictionary to XML attribute text will result in data being IGNORED when the extraction program is run. This table is critical in the picking up of XML atrribute text values from Discovery Metadata dictionary values/codes.

DIC_XYSOURCE

Dictionary table constraining the values entered into the XYSOURCE (source of spatial coordinates) field in the new BGS.BOREHOLE table.

DIC_XY_SOURCE

Dictionary of XY coordinate sources, eg. OS maps, GPS.

DIC_XY_SYSTEM

Dictionary of XY coordinate systems. These should be the values in the EPSG system. This dictionary is likely to be replaced by a fuller corporate system based on the EPSG system with additions.

DIC_YOUNGFACE_EVIDN

Dictionary describing features used as evidence in defining young surfaces in individual sedimentary structures, eg. ripple marks, burrows, load structures.

DIC_Z_SYSTEM

Dictionary of Z coordinate systems. These should be the values in the EPSG system. This dictionary is likely to be replaced by a fuller corporate system based on the EPSG system with additions

LEXICON_ONE2ONE

This table holds details of BGS's lexicon child codes and is part of a system that is used to export parts of the BGS Lexicon for external publication on the Internet.

LEXICON_ONE2ONE_PARENTCODE

This table is part of a system that's used to export parts of the Lexicon to the SQL server for external publication on the Internet.

REFTYPE_DIC

Dictionary table for (reference points) REFPT codes.

WORLD_GAZETTEER_DIC

Dictionary table which expands the CODE field in WORLD_GAZETTEER. Data are derived from the Digital Chart of the World (DCW).