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 20 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 |
| B |
5 |
6 |
2 |
BL |
|
|
|
PA |
GY |
BL |
L |
C |
18-OCT-01 |
|
| B |
5 |
7 |
1 |
GY |
BL |
|
L |
|
GY |
BL |
L |
C |
18-OCT-01 |
|
| YR |
2.5 |
7 |
4 |
BR |
RE |
|
L |
|
GY |
RE |
L |
C |
18-OCT-01 |
|
| YR |
2.5 |
7 |
6 |
RE |
|
|
L |
|
OR |
BR |
L |
C |
18-OCT-01 |
|
| YR |
2.5 |
7 |
7 |
RE |
|
|
L |
|
OR |
BR |
L |
C |
18-OCT-01 |
|
| YR |
2.5 |
8 |
1 |
WH |
|
|
|
|
GY |
RE |
L |
C |
18-OCT-01 |
|
| YR |
2.5 |
8 |
2 |
WH |
PK |
|
|
|
GY |
RE |
L |
C |
18-OCT-01 |
|
| YR |
2.5 |
8 |
3 |
PK |
|
|
|
|
GY |
RE |
L |
C |
18-OCT-01 |
|
| YR |
2.5 |
8 |
4 |
PK |
|
|
|
|
GY |
RE |
L |
C |
18-OCT-01 |
|
| B |
5 |
4 |
1 |
GY |
BL |
|
D |
|
GY |
BL |
D |
C |
18-OCT-01 |
|
| B |
5 |
5 |
1 |
GY |
BL |
|
M |
|
GY |
BL |
M |
C |
18-OCT-01 |
|
| B |
5 |
5 |
6 |
BL |
|
|
|
MO |
BL |
. |
M |
C |
18-OCT-01 |
|
| N |
0 |
0 |
0 |
BK |
|
|
|
|
BK |
. |
. |
C |
18-OCT-01 |
|
| N |
0 |
2 |
0 |
BK |
GY |
|
|
|
GY |
. |
D |
C |
18-OCT-01 |
|
| N |
0 |
2.5 |
0 |
BK |
|
|
|
|
GY |
. |
D |
C |
18-OCT-01 |
|
| N |
0 |
3 |
0 |
GY |
|
|
D |
VE |
GY |
. |
D |
C |
18-OCT-01 |
|
| N |
0 |
4 |
0 |
GY |
|
|
D |
|
GY |
. |
M |
C |
18-OCT-01 |
|
| N |
0 |
5 |
0 |
GY |
|
|
M |
|
GY |
. |
M |
C |
18-OCT-01 |
|
| N |
0 |
6 |
0 |
GY |
|
|
L |
|
GY |
. |
L |
C |
18-OCT-01 |
|
| N |
0 |
7 |
0 |
GY |
|
|
L |
|
GY |
. |
L |
C |
18-OCT-01 |
|
