Vocabularies — details

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.

No. Column name Data type Notes
1 BASE_COLOUR_CODE Varchar(2) Primary key
2 COL_QUALIFIER_CODE Varchar(2)  
3 SHADE_CODE Char(1)  
4 MEDIAN_MUNSELL_HUE_CODE Numeric(22)  
5 MEDIAN_MUNSELL_BASE_COL_CODE Varchar(2)  
6 MEDIAN_MUNSELL_VALUE_CODE Numeric(22)  
7 MEDIAN_MUNSELL_CHROMA_CODE Numeric(22)  
8 STATUS Char(1)  
9 DATE_ENTERED Date  
10 DATE_UPDATED Date  


Sample data (rows 1 to 20 of 121)

BASE_COLOUR_CODE COL_QUALIFIER_CODE SHADE_CODE MEDIAN_MUNSELL_HUE_CODE MEDIAN_MUNSELL_BASE_COL_CODE MEDIAN_MUNSELL_VALUE_CODE MEDIAN_MUNSELL_CHROMA_CODE STATUS DATE_ENTERED DATE_UPDATED
OR  10  YR  18-OCT-01   
OR  10  YR  18-OCT-01   
GY  OL  18-OCT-01   
GY  OR  YR  18-OCT-01   
GY  PK  YR  18-OCT-01   
GY  RE  10  18-OCT-01   
GY  RE  2.5  YR  18-OCT-01   
GY  RE  10  18-OCT-01   
GY  YE  18-OCT-01   
OL  18-OCT-01   
OL  10  18-OCT-01   
OL  18-OCT-01   
BK  18-OCT-01   
BK  BL  10  2.5  18-OCT-01   
BK  BR  YR  18-OCT-01   
BK  GR  10  2.5  18-OCT-01   
BK  OL  18-OCT-01   
BK  RE  10  2.5  18-OCT-01   
BL  18-OCT-01   
BL  18-OCT-01