Vocabularies — details

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

No. Column name Data type Notes
1 MUNSELL_BASE_COLOUR_CODE Varchar(2) Primary key
2 MUNSELL_HUE_CODE Numeric(22)  
3 MUNSELL_VALUE_CODE Numeric(22)  
4 MUNSELL_CHROMA_CODE Numeric(22)  
5 ROCK_SOIL_BASE_COLOUR_CODE Varchar(2)  
6 ROCK_SOIL_COL_QUALIFIER_CODE Varchar(2)  
7 ROCK_SOIL_COL_QUALIFIER_CODE_2 Varchar(2)  
8 ROCK_SOIL_SHADE_CODE Char(1)  
9 ROCK_SOIL_COL_STRENGTH_CODE Varchar(2)  
10 BGS_BASE_COLOUR_CODE Varchar(2)  
11 BGS_COL_QUALIFIER_CODE Varchar(2)  
12 BGS_SHADE_CODE Char(1)  
13 STATUS Char(1)  
14 DATE_ENTERED Date  
15 DATE_UPDATED Date  


Sample data (rows 1 to 10 of 429)

MUNSELL_BASE_COLOUR_CODE MUNSELL_HUE_CODE MUNSELL_VALUE_CODE MUNSELL_CHROMA_CODE ROCK_SOIL_BASE_COLOUR_CODE ROCK_SOIL_COL_QUALIFIER_CODE ROCK_SOIL_COL_QUALIFIER_CODE_2 ROCK_SOIL_SHADE_CODE ROCK_SOIL_COL_STRENGTH_CODE BGS_BASE_COLOUR_CODE BGS_COL_QUALIFIER_CODE BGS_SHADE_CODE STATUS DATE_ENTERED DATE_UPDATED
BL        PA  GY  BL  18-OCT-01   
GY  BL      GY  BL  18-OCT-01   
YR  2.5  BR  RE      GY  RE  18-OCT-01   
YR  2.5  RE        OR  BR  18-OCT-01   
YR  2.5  RE        OR  BR  18-OCT-01   
YR  2.5  WH          GY  RE  18-OCT-01   
YR  2.5  WH  PK        GY  RE  18-OCT-01   
YR  2.5  PK          GY  RE  18-OCT-01   
YR  2.5  PK          GY  RE  18-OCT-01   
GY  BL      GY  BL  18-OCT-01