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.
| No. |
Column name |
Data type |
Notes |
| 1 |
KEYPHRASE_ID |
Numeric(22) |
Primary key
|
| 2 |
KEYPHRASE_DESC |
Varchar(100) |
|
| 3 |
SCOPE_NOTES |
Varchar(200) |
|
| 4 |
STATUS |
Varchar(6) |
|
| 5 |
DATA_SOURCE |
Varchar(20) |
|
| 6 |
DATE_ENTERED |
Date |
|
| 7 |
DATE_UPDATED |
Date |
|
| 8 |
DICS_DEFINITION |
Varchar(2000) |
|
| 9 |
DICS_TRANSLATION |
Varchar(100) |
|
Sample data (rows 1 to 20 of 6014)
| KEYPHRASE_ID |
KEYPHRASE_DESC |
SCOPE_NOTES |
STATUS |
DATA_SOURCE |
DATE_ENTERED |
DATE_UPDATED |
DICS_DEFINITION |
DICS_TRANSLATION |
| 854 |
Cliffs |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 855 |
Climate change |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 844 |
Clay minerals |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 845 |
Clay pits |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 846 |
Clay soils |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 847 |
Clays |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 848 |
Claystone |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 849 |
Clean coal technology |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 850 |
Cleat |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 851 |
Cleavage |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 852 |
Cleavage banding |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 853 |
Cleavage plane |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 872 |
Coal constituents |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 873 |
Coal consumption |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 874 |
Coal conversion |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 875 |
Coal cutters |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 876 |
Coal deposits |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 877 |
Coal dust |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 878 |
Coal exploration |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
| 879 |
Coal fields |
|
ACTIVE |
AMF |
12-OCT-01 |
|
|
|
