Vocabularies — browse and download

375 vocabularies available to browse. Please select one from the list below:

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).