DIC_ADD_COLLTITLE
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.
No. |
Column name |
Data type |
Notes |
1 |
CODE |
Varchar(20) |
Primary key
|
2 |
DESCRIPTION |
Varchar(40) |
|
3 |
TRANSLATION |
Varchar(40) |
|
4 |
STATUS |
Char(1) |
|
5 |
APPN_CODE |
Varchar(6) |
|
6 |
DATE_ENTERED |
Date |
|
7 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 18 of 18)
CODE |
DESCRIPTION |
TRANSLATION |
STATUS |
APPN_CODE |
DATE_ENTERED |
DATE_UPDATED |
DGSM |
DGSM Model or Dataset |
DGSM Model or Dataset |
C |
DGSM |
23-FEB-04 |
29-NOV-05 |
BGS-GeoIDS |
BGS Data Holding |
BGS Data Holding |
C |
GEOIDS |
23-FEB-04 |
29-NOV-05 |
External |
External Data Holding |
External Data Holding |
C |
|
23-FEB-04 |
|
Gazetteer |
Place Name Gazetteer |
Place Name Gazetteer |
C |
|
23-FEB-04 |
|
Thesaurus |
Subject Keyword Thesaurus |
Subject Keyword Thesaurus |
C |
|
23-FEB-04 |
|
OML |
Ocean Margin Link Dataset |
Ocean Margin Link Dataset |
C |
OML |
09-AUG-04 |
29-NOV-05 |
Map_NewSeries |
Map New Series, New Meridian County (Sco |
Map New Series, New Meridian County (Sco |
C |
MAPS |
13-SEP-04 |
29-NOV-05 |
Map_OldCtyBnd |
Map Old County boundaries |
Map Old County boundaries |
C |
MAPS |
13-SEP-04 |
29-NOV-05 |
Map_NewCtyBnd |
Map New County boundaries |
Map New County boundaries |
C |
MAPS |
13-SEP-04 |
29-NOV-05 |
Map_Cty |
Map County |
Map County |
C |
MAPS |
13-SEP-04 |
29-NOV-05 |
Map_NGR |
Map National Grid |
Map National Grid |
C |
MAPS |
13-SEP-04 |
29-NOV-05 |
FieldSlip_NewSeries |
Field Slip New Series, New Meridian Coun |
Field Slip New Series, New Meridian Coun |
C |
MAPS |
13-SEP-04 |
29-NOV-05 |
FieldSlip_OldCtyBnd |
Field Slip Old County boundaries |
Field Slip Old County boundaries |
C |
MAPS |
13-SEP-04 |
29-NOV-05 |
FieldSlip_NewCtyBnd |
Field Slip New County boundaries |
Field Slip New County boundaries |
C |
MAPS |
13-SEP-04 |
29-NOV-05 |
FieldSlip_Cty |
Field Slip County |
Field Slip County |
C |
MAPS |
04-OCT-04 |
29-NOV-05 |
FieldSlip_NGR |
Field Slip National Grid |
Field Slip National Grid |
C |
MAPS |
04-OCT-04 |
29-NOV-05 |
Map_Unknown |
Map unknown series |
Map unknown series |
C |
MAPS |
04-OCT-04 |
29-NOV-05 |
FieldSlip_Unknown |
Field Slip unknown series |
Field Slip unknown series |
C |
MAPS |
04-OCT-04 |
29-NOV-05 |