211 vocabularies available to browse. Please select one from the list below:
This table provides expansions of the location and elevation accuracy codes used in the Well Data table (WELL_DATA). A primary key constraint has been included.
A table within the BOREHOLE GEOLOGY databank that holds the approved comments for attaching to logs in BOREHOLE_GEOLOGY table.
Table containing NGR coordinates of the SW and NE corner of Ordnance Survey 1:10K sheet areas.
Table listing BGS 1:10,000 map numbers. Field intended to list map names not populated.
Spatial coordinates of 1:250,000 geological maps identified by map name
Spatial link table holding overlap of 1:10,000 maps for England, Wales and Scotland.
Spatial. Coordinates of 1:50,000 geological maps for England, Wales and Scotland, on sheet number.
A dictionary of abundance, for use in varous situations
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.
A process (or result of a process) leading to modification of the fabric, composition or other physical or chemical property of a pre-existing rock or sediment.
Dictionary containing the approximate facing directions recorded in the field, to assist subsequent accurate determination of facing direction by stereonet.
Dictionary containing the approximate vergence direction, in the horizontal plane, recorded in the field.
This Xref. Table cross references the XML ?Geographical Extent? Elements: National, Regional, and PostCode to BGS Areal Extent Type Codes in the Areal Extent Type Dictionary.
Codes describing the nature of the base of beds in a borehole, eg. Fault, Unconformity. Subset of DIC_BASE_BED.
Codes describing the nature of the base of beds in a borehole, eg. Fault, Unconformity.
A dictionary of Colours - used as base colour in BGS Full Colour dictionary.
Purpose - 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. Content - Types of sedimentary bedding surface at which the orientation of that surface are commonly measured or calculated and also standard values where the type of bedding was not entered (not recorded), not available (can not be recorded) or not applicable.
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.
Names and Codes of all BGS sites (and Swindon). Used by staff movements diary
Nature of interface or transition between mapped geological units (to be used only where the boundary is observed).
This table is a dictionary. It holds translations for the category codes which all the best practice documents fall into.
This table goes with the Best Practice suite of tables (originally started by John Howcroft). It is intended to link to BGS.BP_IDENTIFIER.
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
Metadata dictionary of written character sets. An implementation and extension of ISO codelist B.5.10 MD_CharacterSetCode
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.
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.
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).
A dictionary of colour strengths (saturation levels) applied to full colour descriptions eg: Brilliant Blue; Moderate Red etc.
Saleable commodity produced by Mine or Quarry (Dictionary)
Dictionary of types of data confidentiality. Old confidentiality dictionary used by BGS tables, been rationalised into an ISO version.
Dictionary of country names, including all ISO 3166 codes
Spatial. Coordinates of County series geological maps for England and Wales (all logical sheets).
Dictionary of horizontal coordinate systems, mostly sourced from EPSG database. Data from the normalised EPSG database is summarised and joined to populate this table. The table should be updated as new versions of the EPSG database are released.
Dictionary of vertical coordinate systems, mostly sourced from EPSG database and FGDC. Data from the normalised EPSG database is summarised and joined to populate this table. The table should be updated as new versions of the EPSG database are released.
A Dictionary for the types of storage for derived data. Egs: Oracle table, Access table, ASCII text etc.
A dictionary of valid Date Accuracies used to describe Dataset start/end dates of capture (see DIC_DATE_STATUS)
A dictionary of valid Date Statuses for beginning/ending of Dataset data capture
A dictionary listing various formats that a dataset to be delivered could have.
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.
A dictionary of rock density, compactness, strength and hardness terms.
Dictionary describing method used to determine dip of an inclined surface
Defines the values for describing the profile shape of the doline (vertical section).
Defines the values for describing the type of doline and how it was formed.
This is a list 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.
Dictionary table constraining the values entered into the DATE_KNOWN_TYPE field in the new BGS.BOREHOLE table.
Dictionary of substances that cannot be decomposed by chemical reaction into simpler substances.
Index of mineral commodities and their end uses.
Dictionary of Economic Planning Regions (EPRs) for the Britpits databank.
A Dictionary of Formats for exported data. Egs: GIF, JPEG, VRML etc. Note Formats are categorised into `types`. (see DIC_EXPORT_TYPE).
A Dictionary of types of export data. Egs: Binary digital Image file; Conventional photograph etc.
Dictionary containing the sense of displacement across fault or shear zones. (Descriptions of different fault types).
Dictionary of the shape of fold in profile view, based on the intelimb angle.
The class of fossiliferous band shown on the map, eg marine band, coral band.
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.
Dictionary of generalized dip of a surface based on estimation or inference.
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.
Dictionary to constrain age types used in DIC_GEOCHRON. E.g. definite; interpolated; approximate.
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.
Dictionary to constrain ranks of geochronological intervals used in DIC_GEOCHRON. E.g. Eon; Era; Period; Epoch; Age.
Dictionary to constrain geochronological schemes used in GEOCHRON_JOIN. E.g. BGS approved geochronology; British onshore Quaternary chronostratigraphy; British offshore Quaternary chronostratigraphy.
Contains a listing of Geosaurus descriptors at heirarchy levels 1 and 2. Descriptors at levels 3 and 4 are selectively included. The terms in this table represent the high-level subjects/terms only.
A Dictionary of GLOS file types in the broadest sense. Egs: TIN, ReadMe, Project, GRID etc.
See associated LOIS table description.
Table describing type of primary planar igneous structure.
Dictionary table for borehole databases - borehole inclination
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.
This 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.
Point observation associated with landform eg summit of drumlin. Is always linked spatially to a landform, not recorded separately.
Dictionary for the method of calculating lat/long values from British National Grid coordinates
Dictionary of attributes indicating the direction of movement, elongation or crystal growth indicated by secondary lineations.
Dictionary table containing codes and descriptions of the rank of lithostratigraphical units.
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.
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.
A dictionary of metre exactness. It can be used for recording precision and/or accuracy.
Metadata dictionary of metadata collection titles. Provides values for ISO metadata element no. 371 collectiveTitle.
Metadata dictionary to describe the confidence or uncertainty in data, interpretations, modelling assumptions etc.
Dictionary table used to constrain the values entered into the DATA_MANAGEMENT field in the new BGS.BOREHOLE table.
A dictionary of mineral working sites where minerals are stored, loaded, produced, unloaded or transported.
Dictionary of the types of major areal structural elements. E.g. Sedimentary basin, sub-basin, high, block, shelf, inversion dome, marginal magnetic anomaly
A Dictionary of Model types. Egs: Geological Surface(s), Block(s) Model, Fluid Flow etc.
Table assigning unique codes to different types (as opposed to styles) of landslide movement; for example, rotational slide versus planar slide.
Dictionary of Mineral Planning Authorities (MPAs) for the Britpits databank. This table replaces BGS.GPA and is based on the British Standard BS 6879:1999.
Dictionary table containing codes for use of mineral sites past and present, e.g. active, historic, landfill.
A dictionary of Munsell Base Colours and their associated ordinal position on the Munsell Colour `sphere`/`disc`.
A X-reference table mapping Munsell Base Colours (eg YR for YellowRed) to BGS Base Colours (Yellow, Red in the example quoted).
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
Dictionary of codes detailing the operating system that the storage medium of digital map was written. Relates to the DIGMAPGB Index.
Dictionary of the types of palaeogeological terranes. E.g. Microplate, microcontinent, continent.
This table 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.
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).
The class of planar structure, eg, bedding, crenulation cleavage.
Dictionary of the types of plate boundaries. E.g. Spreading centre, subduction zone, transform margin
Dictionary table containing valid priorities for the software error reporting system (from very high to very low).
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.
Profile descriptions and codes, as used by the staff movements diary
Dictionary table containing a listing of quarry products. (e.g Agricultural Fertilisers, building stone, concrete blocks, dry stone walling etc.)
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.
Part of version 3 of the BGS Rock Classification Scheme. This dictionary holds codes for the amount of single lithologies that make up a composite lithology.
Dictionary table used to validate field RCS_STATUS in the table Dic_Rock_NameV3. This validation was previously controlled by a check constraint. This now removed.
The entire version 3 of the BGS Rock Classification Scheme. This table is populated directly from the 3 supplying tables (BGS.ROCK_NAME_V3, BGS.ROCK_COMPOSITE and BGS.DIC_ROCK_DUMMY). All entries in these supplying tables are also held in BGS.DIC_ROCK_ALL. NOTE: no user has anything other than SELECT access to BGS.DIC_ROCK_ALL - its contents are entirely controlled by triggers on the supplying tables.
Dictionary for the source tables of entries in version 3 of the BGS Rock Classification Scheme
A Dictionary of Child/Parent relationships in the Rock Classification Scheme.
Part of version 3 of the BGS Rock Classification Scheme. This table contains hierarchy of the RCS
Part of version 3 of the BGS Rock Classification Scheme. This table holds the code (e.g. IBSDSS) and description (e.g. interbedded sandstones and siltstones with mudstone lenses in the sandstone) of the composite.
A Dictionary of Hierarchical codes for use within the Rock Classification Scheme
Part of version 3 of the BGS Rock Classification Scheme. This table contains codes for the types of hierarchy within the RCS
Part of version 3 of the BGS Rock Classification Scheme. The main part of the RCS - it contains only single lithologies
A table to hold the entirety of the RCS codes (from DIC_ROCK_SIGMA) together with an indication of whether those codes have been used or not on DigMap.There is no insert or delete permissions on this table. These functions are controlled via a trigger on DIC_ROCK_ALL and a procedure RCS_POPULATE_SIGMA_P1 Carto staff (via TONYM) have update permission on the DigMap fields (i.e. USED_ON_1M, USED_ON_625K, USED_ON_250K, USED_ON_100K, USED_ON_50K, USED_ON_25K, USED_ON_10K)
The quality of the scan. This will be constrained to 'Good', 'Bad' or 'Not Entered' with a default of 'Not Entered'.
The quality of the original paper copy. This will be constrained to 'Good', 'Bad' or 'Not Entered' with a default of 'Not Entered'.
Way in which Section data has been recorded: Polygons, Polylines, or mixture of both.
Types of Section in terms of their Origin. Eg: Cartographic (Map Marginalia), Seismic Survey etc.
Dictionary that identifies the source used to obtain the seismic data.
Dictionary containing indicators for onshore, offshore and transition zone seismic surveys.
A dictionary of shades (from dark to light) as applied to full colur descriptions eg Dark Blue etc.
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.
Dictionary describing the side of a line or surface, denoted by a compass octant, eg N, SW.
Dictionary which identifies the collection seismic data belongs to, for example C for Coal Authority or B for BGS.
Dictionary which identifies whether digital data are available and if seismic data were received in digital format or if it was scanned or vectorised.
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)
Dictionary identifying processing, such as filtered or migrated stacks.
This dictionary identifies the room where the seismic is stored.
A Dictionary of Modules of Software products. Eg: Vulcan - Envisage etc. Where no Modular breakdown exists a single `dummy` record of code `GE` for General will be created to facilitate links.
This dictionary contains codes used to qualitatively describe the abundance of suspended solids in a sample of water
Type of secondary (tectonic or metamorphic) foliation (?planar fabric?).
Dictionary which lists different tray sizes (small, large etc.) in the NDGC tray store.
Dictionary which lists tray types (cardboard or wooden box etc.) in the NDGC tray store.
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.
Dictionary of vegetation; plant life of a region; ground cover life forms,structure or any other specific botanical or geographic characteristics. To be ratified by DMG(mln, 07/04/2008).
Dictionary of vein morphologies in the surface of measurement, eg planar, en echelon, conjugate.
Dictionary of qualitative vertical extents, used to describe the vertical extent of geological information in a map, section, dataset, model etc.
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
Inferred direction of superposition of stratiform deposits.
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).
A 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).
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).
Dictionary containing the text for workflow sections (e.g. DGSM, SIGMA) URL links.
Information about mineral workings encountered by a borehole.
Information about water strikes in a borehole.
This dictionary table contains the valid XML attribute texts (for NGDF profile), coded by Metadata Guidelines ID and an entry no.
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.
Dictionary table constraining the values entered into the XYSOURCE (source of spatial coordinates) field in the new BGS.BOREHOLE table.
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.
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
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.
This table holds details of the lexicon child and parent code mappings and is part of a system used to export parts of the BGS Lexicon for external publication on the Internet.
Provides expansions of the hydrocarbon quantities-found codes used in the SSD hydrocarbonds test results table.
Dictionary table for (reference points) REFPT codes.
This table provides expansions of the data source codes used in the Surface Depths table. In version 2 a primary key has been added.Table.
Provides expansions of the hydrocarbon well status codes used in the SSD hydrocarbon test table.
Provides expansions of the hydrocarbon substance codes used in the Stratigraphic Surfaces Database (SSD) hydrocarbons test results table.
This table provides expansions of the surface identifcation codes used in the surface depths table. In version 2 a primary key constraint has been added.
This table provides expansions of the surface type codes used in the Surface Depths table. In version 2 a primary key constraint has been added.Table.
This table provides expansions of the well drilling purpose codes used in the Well Data Table (WELL_DATA). A primary key constraint has been included.
A lookup dictionary which expands the CODE field in WORLD_GAZETTEER. Data are derived from the Digital Chart of the World (DCW).