Vocabularies — details

DIC_MPA

Dictionary of Mineral Planning Authorities (MPAs) for the Britpits databank. This table replaces BGS.GPA and is based on the British Standard BS 6879:1999.

No. Column name Data type Notes
1 MPA_CODE Varchar(4) Primary key
2 MPA_NAME Varchar(100)  
3 COUNTRY_CODE Varchar(4)  
4 MPA_STATUS Char(1)  
5 LANGUAGE Char(1)  
6 FORMER_COUNTY_CODE Varchar(3)  
7 EPR_CODE Varchar(3)  
8 DATE_ENTERED Date  
9 DATE_UPDATED Date  


Sample data (rows 1 to 10 of 283)

MPA_CODE MPA_NAME COUNTRY_CODE MPA_STATUS LANGUAGE FORMER_COUNTY_CODE EPR_CODE DATE_ENTERED DATE_UPDATED
DOW  Down  NIR    NIR  29-FEB-00  18-JAN-08 
DUD  Dudley Metropolitan Borough Council  ENG  WMD  WMD  29-FEB-00  18-JAN-01 
CYM  Cymru  WLS      WLS  29-FEB-00   
DAL  Darlington Borough Council  ENG  DUR  NEA  29-FEB-00  18-JAN-01 
DNP  Dartmoor National Park  ENG  DEV  SWE  29-FEB-00   
DEN  Denbighshire County Council  WLS  CWD  WLS  29-FEB-00  08-DEC-06 
DER  Derby City Council  ENG  DBY  EMD  29-FEB-00  18-JAN-01 
DBY  Derbyshire County Council  ENG    EMD  29-FEB-00  18-JAN-01 
DRY  Londonderry  NIR  LDY  NIR  29-FEB-00  30-JAN-08 
DEV  Devon County Council  ENG    SWE  29-FEB-00  18-JAN-01