AddressBase Premium Classification Codes

SQL statement to create a table containing the classification codes and descriptions for AddressBase Premium

DROP TABLE IF EXISTS abaseprem.classifications;
CREATE TABLE IF NOT EXISTS abaseprem.classifications(
  Concatenated VARCHAR(6) NOT NULL PRIMARY KEY,
  Class_Desc VARCHAR(119),
  Primary_Code VARCHAR(1),
  Secondary_Code VARCHAR(1),
  Tertiary_Code INTEGER,
  Quaternary_Code VARCHAR(2)
, Primary_Desc VARCHAR(28)
, Secondary_Desc VARCHAR(119)
, Tertiary_Desc VARCHAR(112)
, Quaternary_Desc VARCHAR(50)
);
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('C','Commercial','C','',NULL,'','Commercial','','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CA','Agricultural','C','A',NULL,'','Commercial','Agricultural','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CA01','Farm / Non-Residential Associated Building','C','A',01,'','Commercial','Agricultural','Farm / Non-Residential Associated Building','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CA02','Fishery','C','A',02,'','Commercial','Agricultural','Fishery','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CA02FF','Fish Farming','C','A',02,'FF','Commercial','Agricultural','Fishery','Fish Farming');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CA02FH','Fish Hatchery','C','A',02,'FH','Commercial','Agricultural','Fishery','Fish Hatchery');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CA02FP','Fish Processing','C','A',02,'FP','Commercial','Agricultural','Fishery','Fish Processing');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CA02OY','Oyster / Mussel Bed','C','A',02,'OY','Commercial','Agricultural','Fishery','Oyster / Mussel Bed');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CA03','Horticulture','C','A',03,'','Commercial','Agricultural','Horticulture','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CA03SH','Smallholding','C','A',03,'SH','Commercial','Agricultural','Horticulture','Smallholding');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CA03VY','Vineyard','C','A',03,'VY','Commercial','Agricultural','Horticulture','Vineyard');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CA03WB','Watercress Bed','C','A',03,'WB','Commercial','Agricultural','Horticulture','Watercress Bed');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CA04','Slaughter House / Abattoir','C','A',04,'','Commercial','Agricultural','Slaughter House / Abattoir','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CB','Ancillary Building','C','B',NULL,'','Commercial','Ancillary Building','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC','Community Services','C','C',NULL,'','Commercial','Community Services','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC02','Law Court','C','C',02,'','Commercial','Community Services','Law Court','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC03','Prison','C','C',03,'','Commercial','Community Services','Prison','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC03HD','HM Detention Centre','C','C',03,'HD','Commercial','Community Services','Prison','HM Detention Centre');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC03PR','HM Prison Service','C','C',03,'PR','Commercial','Community Services','Prison','HM Prison Service');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC03SC','Secure Residential Accommodation','C','C',03,'SC','Commercial','Community Services','Prison','Secure Residential Accommodation');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC04','Public / Village Hall / Other Community Facility','C','C',04,'','Commercial','Community Services','Public / Village Hall / Other Community Facility','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC04YR','Youth Recreational / Social Club','C','C',04,'YR','Commercial','Community Services','Public / Village Hall / Other Community Facility','Youth Recreational / Social Club');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC05','Public Convenience','C','C',05,'','Commercial','Community Services','Public Convenience','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC06','Cemetery / Crematorium / Graveyard. In Current Use.','C','C',06,'','Commercial','Community Services','Cemetery / Crematorium / Graveyard. In Current Use.','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC06CB','Columbarium','C','C',06,'CB','Commercial','Community Services','Cemetery / Crematorium / Graveyard. In Current Use.','Columbarium');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC06CR','Chapel Of Rest','C','C',06,'CR','Commercial','Community Services','Cemetery / Crematorium / Graveyard. In Current Use.','Chapel Of Rest');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC06CN','Crematorium','C','C',06,'CN','Commercial','Community Services','Cemetery / Crematorium / Graveyard. In Current Use.','Crematorium');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC06CY','Cemetery','C','C',06,'CY','Commercial','Community Services','Cemetery / Crematorium / Graveyard. In Current Use.','Cemetery');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC06MC','Military Cemetery','C','C',06,'MC','Commercial','Community Services','Cemetery / Crematorium / Graveyard. In Current Use.','Military Cemetery');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC06MY','Mortuary','C','C',06,'MY','Commercial','Community Services','Cemetery / Crematorium / Graveyard. In Current Use.','Mortuary');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC07','Church Hall / Religious Meeting Place / Hall','C','C',07,'','Commercial','Community Services','Church Hall / Religious Meeting Place / Hall','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC08','Community Service Centre / Office','C','C',08,'','Commercial','Community Services','Community Service Centre / Office','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC09','Public Household Waste Recycling Centre (HWRC)','C','C',09,'','Commercial','Community Services','Public Household Waste Recycling Centre (HWRC)','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC10','Recycling Site','C','C',10,'','Commercial','Community Services','Recycling Site','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC11','CCTV','C','C',11,'','Commercial','Community Services','CCTV','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CC12','Job Centre','C','C',12,'','Commercial','Community Services','Job Centre','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE','Education','C','E',NULL,'','Commercial','Education','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE01','College','C','E',01,'','Commercial','Education','College','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE01FE','Further Education','C','E',01,'FE','Commercial','Education','College','Further Education');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE01HE','Higher Education','C','E',01,'HE','Commercial','Education','College','Higher Education');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE02','Children�s Nursery / Cr�che','C','E',02,'','Commercial','Education','Children�s Nursery / Cr�che','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE03','Preparatory / First / Primary / Infant / Junior / Middle School','C','E',03,'','Commercial','Education','Preparatory / First / Primary / Infant / Junior / Middle School','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE03FS','First School','C','E',03,'FS','Commercial','Education','Preparatory / First / Primary / Infant / Junior / Middle School','First School');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE03IS','Infant School','C','E',03,'IS','Commercial','Education','Preparatory / First / Primary / Infant / Junior / Middle School','Infant School');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE03JS','Junior School','C','E',03,'JS','Commercial','Education','Preparatory / First / Primary / Infant / Junior / Middle School','Junior School');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE03MS','Middle School','C','E',03,'MS','Commercial','Education','Preparatory / First / Primary / Infant / Junior / Middle School','Middle School');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE03NP','Non State Primary / Preparatory School','C','E',03,'NP','Commercial','Education','Preparatory / First / Primary / Infant / Junior / Middle School','Non State Primary / Preparatory School');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE03PS','Primary School','C','E',03,'PS','Commercial','Education','Preparatory / First / Primary / Infant / Junior / Middle School','Primary School');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE04','Secondary / High School','C','E',04,'','Commercial','Education','Secondary / High School','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE04NS','Non State Secondary School','C','E',04,'NS','Commercial','Education','Secondary / High School','Non State Secondary School');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE04SS','Secondary School','C','E',04,'SS','Commercial','Education','Secondary / High School','Secondary School');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE05','University','C','E',05,'','Commercial','Education','University','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE06','Special Needs Establishment.','C','E',06,'','Commercial','Education','Special Needs Establishment.','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CE07','Other Educational Establishment','C','E',07,'','Commercial','Education','Other Educational Establishment','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CH','Hotel / Motel / Boarding / Guest House','C','H',NULL,'','Commercial','Hotel / Motel / Boarding / Guest House','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CH01','Boarding / Guest House / Bed And Breakfast / Youth Hostel','C','H',01,'','Commercial','Hotel / Motel / Boarding / Guest House','Boarding / Guest House / Bed And Breakfast / Youth Hostel','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CH01YH','Youth Hostel','C','H',01,'YH','Commercial','Hotel / Motel / Boarding / Guest House','Boarding / Guest House / Bed And Breakfast / Youth Hostel','Youth Hostel');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CH02','Holiday Let/Accomodation/Short-Term Let Other Than CH01','C','H',02,'','Commercial','Hotel / Motel / Boarding / Guest House','Holiday Let/Accomodation/Short-Term Let Other Than CH01','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CH03','Hotel/Motel','C','H',03,'','Commercial','Hotel / Motel / Boarding / Guest House','Hotel/Motel','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','C','I',NULL,'','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01','Factory/Manufacturing','C','I',01,'','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01AW','Aircraft Works','C','I',01,'AW','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Aircraft Works');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01BB','Boat Building','C','I',01,'BB','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Boat Building');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01BR','Brick Works','C','I',01,'BR','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Brick Works');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01BW','Brewery','C','I',01,'BW','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Brewery');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01CD','Cider Manufacture','C','I',01,'CD','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Cider Manufacture');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01CM','Chemical Works','C','I',01,'CM','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Chemical Works');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01CW','Cement Works','C','I',01,'CW','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Cement Works');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01DA','Dairy Processing','C','I',01,'DA','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Dairy Processing');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01DY','Distillery','C','I',01,'DY','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Distillery');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01FL','Flour Mill','C','I',01,'FL','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Flour Mill');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01FO','Food Processing','C','I',01,'FO','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Food Processing');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01GW','Glassworks','C','I',01,'GW','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Glassworks');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01MG','Manufacturing','C','I',01,'MG','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Manufacturing');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01OH','Oast House','C','I',01,'OH','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Oast House');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01OR','Oil Refining','C','I',01,'OR','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Oil Refining');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01PG','Pottery Manufacturing','C','I',01,'PG','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Pottery Manufacturing');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01PM','Paper Mill','C','I',01,'PM','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Paper Mill');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01PW','Printing Works','C','I',01,'PW','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Printing Works');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01YD','Shipyard','C','I',01,'YD','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Shipyard');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01SR','Sugar Refinery','C','I',01,'SR','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Sugar Refinery');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01SW','Steel Works','C','I',01,'SW','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Steel Works');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01TL','Timber Mill','C','I',01,'TL','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Timber Mill');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI01WN','Winery','C','I',01,'WN','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Factory/Manufacturing','Winery');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI02','Mineral / Ore Working / Quarry / Mine','C','I',02,'','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Mineral / Ore Working / Quarry / Mine','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI02MA','Mineral Mining / Active','C','I',02,'MA','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Mineral / Ore Working / Quarry / Mine','Mineral Mining / Active');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI02MD','Mineral Distribution / Storage','C','I',02,'MD','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Mineral / Ore Working / Quarry / Mine','Mineral Distribution / Storage');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI02MP','Mineral Processing','C','I',02,'MP','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Mineral / Ore Working / Quarry / Mine','Mineral Processing');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI02OA','Oil / Gas Extraction / Active','C','I',02,'OA','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Mineral / Ore Working / Quarry / Mine','Oil / Gas Extraction / Active');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI02QA','Mineral Quarrying / Open Extraction / Active','C','I',02,'QA','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Mineral / Ore Working / Quarry / Mine','Mineral Quarrying / Open Extraction / Active');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI03','Workshop / Light Industrial','C','I',03,'','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Workshop / Light Industrial','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI03GA','Servicing Garage','C','I',03,'GA','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Workshop / Light Industrial','Servicing Garage');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI04','Warehouse / Store / Storage Depot','C','I',04,'','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Warehouse / Store / Storage Depot','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI04CS','Crop Handling / Storage','C','I',04,'CS','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Warehouse / Store / Storage Depot','Crop Handling / Storage');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI04PL','Postal Sorting / Distribution','C','I',04,'PL','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Warehouse / Store / Storage Depot','Postal Sorting / Distribution');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI04SO','Solid Fuel Storage','C','I',04,'SO','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Warehouse / Store / Storage Depot','Solid Fuel Storage');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI04TS','Timber Storage','C','I',04,'TS','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Warehouse / Store / Storage Depot','Timber Storage');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI05','Wholesale Distribution','C','I',05,'','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Wholesale Distribution','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI05SF','Solid Fuel Distribution','C','I',05,'SF','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Wholesale Distribution','Solid Fuel Distribution');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI05TD','Timber Distribution','C','I',05,'TD','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Wholesale Distribution','Timber Distribution');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI06','Recycling Plant','C','I',06,'','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Recycling Plant','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI07','Incinerator / Waste Transfer Station','C','I',07,'','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Incinerator / Waste Transfer Station','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CI08','Maintenance Depot','C','I',08,'','Commercial','Industrial Applicable to manufacturing, engineering, maintenance, storage / wholesale distribution and extraction sites','Maintenance Depot','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL','Leisure - Applicable to recreational sites and enterprises','C','L',NULL,'','Commercial','Leisure - Applicable to recreational sites and enterprises','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL01','Amusements','C','L',01,'','Commercial','Leisure - Applicable to recreational sites and enterprises','Amusements','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL01LP','Leisure Pier','C','L',01,'LP','Commercial','Leisure - Applicable to recreational sites and enterprises','Amusements','Leisure Pier');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL02','Holiday / Campsite','C','L',02,'','Commercial','Leisure - Applicable to recreational sites and enterprises','Holiday / Campsite','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL02CG','Camping','C','L',02,'CG','Commercial','Leisure - Applicable to recreational sites and enterprises','Holiday / Campsite','Camping');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL02CV','Caravanning','C','L',02,'CV','Commercial','Leisure - Applicable to recreational sites and enterprises','Holiday / Campsite','Caravanning');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL02HA','Holiday Accommodation','C','L',02,'HA','Commercial','Leisure - Applicable to recreational sites and enterprises','Holiday / Campsite','Holiday Accommodation');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL02HO','Holiday Centre','C','L',02,'HO','Commercial','Leisure - Applicable to recreational sites and enterprises','Holiday / Campsite','Holiday Centre');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL02YC','Youth Organisation Camp','C','L',02,'YC','Commercial','Leisure - Applicable to recreational sites and enterprises','Holiday / Campsite','Youth Organisation Camp');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL03','Library','C','L',03,'','Commercial','Leisure - Applicable to recreational sites and enterprises','Library','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL03RR','Reading Room','C','L',03,'RR','Commercial','Leisure - Applicable to recreational sites and enterprises','Library','Reading Room');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL04','Museum / Gallery','C','L',04,'','Commercial','Leisure - Applicable to recreational sites and enterprises','Museum / Gallery','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL04AC','Art Centre / Gallery','C','L',04,'AC','Commercial','Leisure - Applicable to recreational sites and enterprises','Museum / Gallery','Art Centre / Gallery');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL04AM','Aviation Museum','C','L',04,'AM','Commercial','Leisure - Applicable to recreational sites and enterprises','Museum / Gallery','Aviation Museum');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL04HG','Heritage Centre','C','L',04,'HG','Commercial','Leisure - Applicable to recreational sites and enterprises','Museum / Gallery','Heritage Centre');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL04IM','Industrial Museum','C','L',04,'IM','Commercial','Leisure - Applicable to recreational sites and enterprises','Museum / Gallery','Industrial Museum');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL04MM','Military Museum','C','L',04,'MM','Commercial','Leisure - Applicable to recreational sites and enterprises','Museum / Gallery','Military Museum');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL04SM','Science Museum','C','L',04,'SM','Commercial','Leisure - Applicable to recreational sites and enterprises','Museum / Gallery','Science Museum');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL04TM','Transport Museum','C','L',04,'TM','Commercial','Leisure - Applicable to recreational sites and enterprises','Museum / Gallery','Transport Museum');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL04NM','Maritime Museum','C','L',04,'NM','Commercial','Leisure - Applicable to recreational sites and enterprises','Museum / Gallery','Maritime Museum');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06','Indoor / Outdoor Leisure / Sporting Activity / Centre','C','L',06,'','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06AH','Athletics Facility','C','L',06,'AH','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Athletics Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06BF','Bowls Facility','C','L',06,'BF','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Bowls Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06CK','Cricket Facility','C','L',06,'CK','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Cricket Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06CU','Curling Facility','C','L',06,'CU','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Curling Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06YF','Cycling Sports Facility','C','L',06,'YF','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Cycling Sports Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06DS','Diving / Swimming Facility','C','L',06,'DS','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Diving / Swimming Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06EQ','Equestrian Sports Facility','C','L',06,'EQ','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Equestrian Sports Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06FB','Football Facility','C','L',06,'FB','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Football Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06FI','Fishing / Angling Facility','C','L',06,'FI','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Fishing / Angling Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06GF','Golf Facility','C','L',06,'GF','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Golf Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06GL','Gliding Facility','C','L',06,'GL','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Gliding Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06GR','Greyhound Racing Facility','C','L',06,'GR','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Greyhound Racing Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06HF','Hockey Facility','C','L',06,'HF','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Hockey Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06HR','Horse Racing Facility','C','L',06,'HR','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Horse Racing Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06HV','Historic Vessel / Aircraft / Vehicle','C','L',06,'HV','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Historic Vessel / Aircraft / Vehicle');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06LS','Activity / Leisure / Sports Centre','C','L',06,'LS','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Activity / Leisure / Sports Centre');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06ME','Model Sports Facility','C','L',06,'ME','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Model Sports Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06MF','Motor Sports Facility','C','L',06,'MF','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Motor Sports Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06PF','Playing Field','C','L',06,'PF','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Playing Field');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06QS','Racquet Sports Facility','C','L',06,'QS','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Racquet Sports Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06RF','Rugby Facility','C','L',06,'RF','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Rugby Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06RG','Recreation Ground','C','L',06,'RG','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Recreation Ground');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06SI','Shinty Facility','C','L',06,'SI','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Shinty Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06SK','Skateboarding Facility','C','L',06,'SK','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Skateboarding Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06SX','Civilian Firing Facility','C','L',06,'SX','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Civilian Firing Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06TB','Tenpin Bowling Facility','C','L',06,'TB','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Tenpin Bowling Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06TN','Public Tennis Court','C','L',06,'TN','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Public Tennis Court');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06WA','Water Sports Facility','C','L',06,'WA','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Water Sports Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06WP','Winter Sports Facility','C','L',06,'WP','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Winter Sports Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL06WY','Wildlife Sports Facility','C','L',06,'WY','Commercial','Leisure - Applicable to recreational sites and enterprises','Indoor / Outdoor Leisure / Sporting Activity / Centre','Wildlife Sports Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL07','Bingo Hall / Cinema / Conference / Exhibition Centre / Theatre / Concert Hall','C','L',07,'','Commercial','Leisure - Applicable to recreational sites and enterprises','Bingo Hall / Cinema / Conference / Exhibition Centre / Theatre / Concert Hall','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL07TH','Theatre','C','L',07,'TH','Commercial','Leisure - Applicable to recreational sites and enterprises','Bingo Hall / Cinema / Conference / Exhibition Centre / Theatre / Concert Hall','Theatre');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL07CI','Cinema','C','L',07,'CI','Commercial','Leisure - Applicable to recreational sites and enterprises','Bingo Hall / Cinema / Conference / Exhibition Centre / Theatre / Concert Hall','Cinema');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL07EN','Entertainment Complex','C','L',07,'EN','Commercial','Leisure - Applicable to recreational sites and enterprises','Bingo Hall / Cinema / Conference / Exhibition Centre / Theatre / Concert Hall','Entertainment Complex');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL07EX','Conference / Exhibition Centre','C','L',07,'EX','Commercial','Leisure - Applicable to recreational sites and enterprises','Bingo Hall / Cinema / Conference / Exhibition Centre / Theatre / Concert Hall','Conference / Exhibition Centre');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL08','Zoo / Theme Park','C','L',08,'','Commercial','Leisure - Applicable to recreational sites and enterprises','Zoo / Theme Park','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL08AK','Amusement Park','C','L',08,'AK','Commercial','Leisure - Applicable to recreational sites and enterprises','Zoo / Theme Park','Amusement Park');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL08MX','Model Village Site','C','L',08,'MX','Commercial','Leisure - Applicable to recreational sites and enterprises','Zoo / Theme Park','Model Village Site');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL08WZ','Wildlife / Zoological Park','C','L',08,'WZ','Commercial','Leisure - Applicable to recreational sites and enterprises','Zoo / Theme Park','Wildlife / Zoological Park');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL08AQ','Aquatic Attraction','C','L',08,'AQ','Commercial','Leisure - Applicable to recreational sites and enterprises','Zoo / Theme Park','Aquatic Attraction');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL09','Beach Hut (Recreational, Non-Residential Use Only)','C','L',09,'','Commercial','Leisure - Applicable to recreational sites and enterprises','Beach Hut (Recreational, Non-Residential Use Only)','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL10','Licensed Private Members� Club','C','L',10,'','Commercial','Leisure - Applicable to recreational sites and enterprises','Licensed Private Members� Club','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL10RE','Recreational / Social Club','C','L',10,'RE','Commercial','Leisure - Applicable to recreational sites and enterprises','Licensed Private Members� Club','Recreational / Social Club');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL11','Arena / Stadium','C','L',11,'','Commercial','Leisure - Applicable to recreational sites and enterprises','Arena / Stadium','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL11SD','Stadium','C','L',11,'SD','Commercial','Leisure - Applicable to recreational sites and enterprises','Arena / Stadium','Stadium');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CL11SJ','Showground','C','L',11,'SJ','Commercial','Leisure - Applicable to recreational sites and enterprises','Arena / Stadium','Showground');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CM','Medical','C','M',NULL,'','Commercial','Medical','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CM01','Dentist','C','M',01,'','Commercial','Medical','Dentist','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CM02','General Practice Surgery / Clinic','C','M',02,'','Commercial','Medical','General Practice Surgery / Clinic','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CM02HL','Health Care Services','C','M',02,'HL','Commercial','Medical','General Practice Surgery / Clinic','Health Care Services');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CM02HC','Health Centre','C','M',02,'HC','Commercial','Medical','General Practice Surgery / Clinic','Health Centre');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CM03','Hospital / Hospice','C','M',03,'','Commercial','Medical','Hospital / Hospice','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CM03HI','Hospice','C','M',03,'HI','Commercial','Medical','Hospital / Hospice','Hospice');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CM03HP','Hospital','C','M',03,'HP','Commercial','Medical','Hospital / Hospice','Hospital');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CM04','Medical / Testing / Research Laboratory','C','M',04,'','Commercial','Medical','Medical / Testing / Research Laboratory','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CM05','Professional Medical Service','C','M',05,'','Commercial','Medical','Professional Medical Service','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CM05ZS','Assessment / Development Services','C','M',05,'ZS','Commercial','Medical','Professional Medical Service','Assessment / Development Services');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CN','Animal Centre','C','N',NULL,'','Commercial','Animal Centre','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CN01','Cattery / Kennel','C','N',01,'','Commercial','Animal Centre','Cattery / Kennel','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CN02','Animal Services','C','N',02,'','Commercial','Animal Centre','Animal Services','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CN02AX','Animal Quarantining','C','N',02,'AX','Commercial','Animal Centre','Animal Services','Animal Quarantining');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CN03','Equestrian','C','N',03,'','Commercial','Animal Centre','Equestrian','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CN03HB','Horse Racing / Breeding Stable','C','N',03,'HB','Commercial','Animal Centre','Equestrian','Horse Racing / Breeding Stable');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CN03SB','Commercial Stabling / Riding','C','N',03,'SB','Commercial','Animal Centre','Equestrian','Commercial Stabling / Riding');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CN04','Vet / Animal Medical Treatment','C','N',04,'','Commercial','Animal Centre','Vet / Animal Medical Treatment','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CN05','Animal / Bird / Marine Sanctuary','C','N',05,'','Commercial','Animal Centre','Animal / Bird / Marine Sanctuary','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CN05AN','Animal Sanctuary','C','N',05,'AN','Commercial','Animal Centre','Animal / Bird / Marine Sanctuary','Animal Sanctuary');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CN05MR','Marine Sanctuary','C','N',05,'MR','Commercial','Animal Centre','Animal / Bird / Marine Sanctuary','Marine Sanctuary');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CO','Office','C','O',NULL,'','Commercial','Office','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CO01','Office / Work Studio','C','O',01,'','Commercial','Office','Office / Work Studio','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CO01EM','Embassy /, High Commission / Consulate','C','O',01,'EM','Commercial','Office','Office / Work Studio','Embassy /, High Commission / Consulate');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CO01FM','Film Studio','C','O',01,'FM','Commercial','Office','Office / Work Studio','Film Studio');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CO01GV','Central Government Service','C','O',01,'GV','Commercial','Office','Office / Work Studio','Central Government Service');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CO01LG','Local Government Service','C','O',01,'LG','Commercial','Office','Office / Work Studio','Local Government Service');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CO02','Broadcasting (TV / Radio)','C','O',02,'','Commercial','Office','Broadcasting (TV / Radio)','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR','Retail','C','R',NULL,'','Commercial','Retail','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR01','Bank / Financial Service','C','R',01,'','Commercial','Retail','Bank / Financial Service','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR02','Retail Service Agent','C','R',02,'','Commercial','Retail','Retail Service Agent','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR02PO','Post Office','C','R',02,'PO','Commercial','Retail','Retail Service Agent','Post Office');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR04','Market (Indoor / Outdoor)','C','R',04,'','Commercial','Retail','Market (Indoor / Outdoor)','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR04FK','Fish Market','C','R',04,'FK','Commercial','Retail','Market (Indoor / Outdoor)','Fish Market');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR04FV','Fruit / Vegetable Market','C','R',04,'FV','Commercial','Retail','Market (Indoor / Outdoor)','Fruit / Vegetable Market');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR04LV','Livestock Market','C','R',04,'LV','Commercial','Retail','Market (Indoor / Outdoor)','Livestock Market');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR05','Petrol Filling Station','C','R',05,'','Commercial','Retail','Petrol Filling Station','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR06','Public House / Bar / Nightclub','C','R',06,'','Commercial','Retail','Public House / Bar / Nightclub','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR07','Restaurant / Cafeteria','C','R',07,'','Commercial','Retail','Restaurant / Cafeteria','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR08','Shop / Showroom','C','R',08,'','Commercial','Retail','Shop / Showroom','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR08GC','Garden Centre','C','R',08,'GC','Commercial','Retail','Shop / Showroom','Garden Centre');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR09','Other Licensed Premise / Vendor','C','R',09,'','Commercial','Retail','Other Licensed Premise / Vendor','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR10','Fast Food Outlet / Takeaway (Hot / Cold)','C','R',10,'','Commercial','Retail','Fast Food Outlet / Takeaway (Hot / Cold)','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CR11','Automated Teller Machine (ATM)','C','R',11,'','Commercial','Retail','Automated Teller Machine (ATM)','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CS','Storage Land','C','S',NULL,'','Commercial','Storage Land','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CS01','General Storage Land','C','S',01,'','Commercial','Storage Land','General Storage Land','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CS02','Builders� Yard','C','S',02,'','Commercial','Storage Land','Builders� Yard','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT','Transport','C','T',NULL,'','Commercial','Transport','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT01','Airfield / Airstrip / Airport / Air Transport Infrastructure Facility','C','T',01,'','Commercial','Transport','Airfield / Airstrip / Airport / Air Transport Infrastructure Facility','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT01AF','Airfield','C','T',01,'AF','Commercial','Transport','Airfield / Airstrip / Airport / Air Transport Infrastructure Facility','Airfield');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT01AY','Air Passenger Terminal','C','T',01,'AY','Commercial','Transport','Airfield / Airstrip / Airport / Air Transport Infrastructure Facility','Air Passenger Terminal');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT01AI','Air Transport Infrastructure Services','C','T',01,'AI','Commercial','Transport','Airfield / Airstrip / Airport / Air Transport Infrastructure Facility','Air Transport Infrastructure Services');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT01AP','Airport','C','T',01,'AP','Commercial','Transport','Airfield / Airstrip / Airport / Air Transport Infrastructure Facility','Airport');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT01HS','Helicopter Station','C','T',01,'HS','Commercial','Transport','Airfield / Airstrip / Airport / Air Transport Infrastructure Facility','Helicopter Station');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT01HT','Heliport / Helipad','C','T',01,'HT','Commercial','Transport','Airfield / Airstrip / Airport / Air Transport Infrastructure Facility','Heliport / Helipad');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT02','Bus Shelter','C','T',02,'','Commercial','Transport','Bus Shelter','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT03','Car / Coach / Commercial Vehicle / Taxi Parking / Park And Ride Site','C','T',03,'','Commercial','Transport','Car / Coach / Commercial Vehicle / Taxi Parking / Park And Ride Site','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT03PK','Public Park And Ride','C','T',03,'PK','Commercial','Transport','Car / Coach / Commercial Vehicle / Taxi Parking / Park And Ride Site','Public Park And Ride');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT03PP','Public Car Parking','C','T',03,'PP','Commercial','Transport','Car / Coach / Commercial Vehicle / Taxi Parking / Park And Ride Site','Public Car Parking');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT03PU','Public Coach Parking','C','T',03,'PU','Commercial','Transport','Car / Coach / Commercial Vehicle / Taxi Parking / Park And Ride Site','Public Coach Parking');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT03VP','Public Commercial Vehicle Parking','C','T',03,'VP','Commercial','Transport','Car / Coach / Commercial Vehicle / Taxi Parking / Park And Ride Site','Public Commercial Vehicle Parking');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT04','Goods Freight Handling / Terminal','C','T',04,'','Commercial','Transport','Goods Freight Handling / Terminal','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT04AE','Air Freight Terminal','C','T',04,'AE','Commercial','Transport','Goods Freight Handling / Terminal','Air Freight Terminal');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT04CF','Container Freight','C','T',04,'CF','Commercial','Transport','Goods Freight Handling / Terminal','Container Freight');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT04RH','Road Freight Transport','C','T',04,'RH','Commercial','Transport','Goods Freight Handling / Terminal','Road Freight Transport');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT04RT','Rail Freight Transport','C','T',04,'RT','Commercial','Transport','Goods Freight Handling / Terminal','Rail Freight Transport');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT05','Marina','C','T',05,'','Commercial','Transport','Marina','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT06','Mooring','C','T',06,'','Commercial','Transport','Mooring','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT07','Railway Asset','C','T',07,'','Commercial','Transport','Railway Asset','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT08','Station / Interchange / Terminal / Halt','C','T',08,'','Commercial','Transport','Station / Interchange / Terminal / Halt','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT08BC','Bus / Coach Station','C','T',08,'BC','Commercial','Transport','Station / Interchange / Terminal / Halt','Bus / Coach Station');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT08RS','Railway Station','C','T',08,'RS','Commercial','Transport','Station / Interchange / Terminal / Halt','Railway Station');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT08VH','Vehicular Rail Terminal','C','T',08,'VH','Commercial','Transport','Station / Interchange / Terminal / Halt','Vehicular Rail Terminal');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT09','Transport Track / Way','C','T',09,'','Commercial','Transport','Transport Track / Way','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT09CL','Cliff Railway','C','T',09,'CL','Commercial','Transport','Transport Track / Way','Cliff Railway');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT09CX','Chair Lift / Cable Car / Ski Tow','C','T',09,'CX','Commercial','Transport','Transport Track / Way','Chair Lift / Cable Car / Ski Tow');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT09MO','Monorail','C','T',09,'MO','Commercial','Transport','Transport Track / Way','Monorail');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT10','Vehicle Storage','C','T',10,'','Commercial','Transport','Vehicle Storage','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT10BG','Boat Storage','C','T',10,'BG','Commercial','Transport','Vehicle Storage','Boat Storage');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT10BU','Bus / Coach Depot','C','T',10,'BU','Commercial','Transport','Vehicle Storage','Bus / Coach Depot');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT11','Transport Related Infrastructure','C','T',11,'','Commercial','Transport','Transport Related Infrastructure','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT11AD','Aqueduct','C','T',11,'AD','Commercial','Transport','Transport Related Infrastructure','Aqueduct');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT11LK','Lock','C','T',11,'LK','Commercial','Transport','Transport Related Infrastructure','Lock');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT11WE','Weir','C','T',11,'WE','Commercial','Transport','Transport Related Infrastructure','Weir');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT11WG','Weighbridge / Load Gauge','C','T',11,'WG','Commercial','Transport','Transport Related Infrastructure','Weighbridge / Load Gauge');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT12','Overnight Lorry Park','C','T',12,'','Commercial','Transport','Overnight Lorry Park','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT13','Harbour / Port / Dock / Dockyard / Slipway / Landing Stage / Pier / Jetty / Pontoon / Terminal / Berthing / Quay','C','T',13,'','Commercial','Transport','Harbour / Port / Dock / Dockyard / Slipway / Landing Stage / Pier / Jetty / Pontoon / Terminal / Berthing / Quay','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT13FR','Passenger Ferry Terminal','C','T',13,'FR','Commercial','Transport','Harbour / Port / Dock / Dockyard / Slipway / Landing Stage / Pier / Jetty / Pontoon / Terminal / Berthing / Quay','Passenger Ferry Terminal');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT13NB','Non-Tanker Nautical Berthing','C','T',13,'NB','Commercial','Transport','Harbour / Port / Dock / Dockyard / Slipway / Landing Stage / Pier / Jetty / Pontoon / Terminal / Berthing / Quay','Non-Tanker Nautical Berthing');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT13NF','Nautical Refuelling Facility','C','T',13,'NF','Commercial','Transport','Harbour / Port / Dock / Dockyard / Slipway / Landing Stage / Pier / Jetty / Pontoon / Terminal / Berthing / Quay','Nautical Refuelling Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT13SA','Slipway','C','T',13,'SA','Commercial','Transport','Harbour / Port / Dock / Dockyard / Slipway / Landing Stage / Pier / Jetty / Pontoon / Terminal / Berthing / Quay','Slipway');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT13SP','Ship Passenger Terminal','C','T',13,'SP','Commercial','Transport','Harbour / Port / Dock / Dockyard / Slipway / Landing Stage / Pier / Jetty / Pontoon / Terminal / Berthing / Quay','Ship Passenger Terminal');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT13TK','Tanker Berthing','C','T',13,'TK','Commercial','Transport','Harbour / Port / Dock / Dockyard / Slipway / Landing Stage / Pier / Jetty / Pontoon / Terminal / Berthing / Quay','Tanker Berthing');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CT13VF','Vehicular Ferry Terminal','C','T',13,'VF','Commercial','Transport','Harbour / Port / Dock / Dockyard / Slipway / Landing Stage / Pier / Jetty / Pontoon / Terminal / Berthing / Quay','Vehicular Ferry Terminal');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU','Utility','C','U',NULL,'','Commercial','Utility','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU01','Electricity Sub-Station','C','U',01,'','Commercial','Utility','Electricity Sub-Station','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU02','Landfill','C','U',02,'','Commercial','Utility','Landfill','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU03','Power Station / Energy Production','C','U',03,'','Commercial','Utility','Power Station / Energy Production','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU03ED','Electricity Distribution Facility','C','U',03,'ED','Commercial','Utility','Power Station / Energy Production','Electricity Distribution Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU03EP','Electricity Production Facility','C','U',03,'EP','Commercial','Utility','Power Station / Energy Production','Electricity Production Facility');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU03WF','Wind Farm','C','U',03,'WF','Commercial','Utility','Power Station / Energy Production','Wind Farm');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU03WU','Wind Turbine','C','U',03,'WU','Commercial','Utility','Power Station / Energy Production','Wind Turbine');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU04','Pump House / Pumping Station / Water Tower','C','U',04,'','Commercial','Utility','Pump House / Pumping Station / Water Tower','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU04WC','Water Controlling / Pumping','C','U',04,'WC','Commercial','Utility','Pump House / Pumping Station / Water Tower','Water Controlling / Pumping');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU04WD','Water Distribution / Pumping','C','U',04,'WD','Commercial','Utility','Pump House / Pumping Station / Water Tower','Water Distribution / Pumping');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU04WM','Water Quality Monitoring','C','U',04,'WM','Commercial','Utility','Pump House / Pumping Station / Water Tower','Water Quality Monitoring');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU04WS','Water Storage','C','U',04,'WS','Commercial','Utility','Pump House / Pumping Station / Water Tower','Water Storage');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU04WW','Waste Water Distribution / Pumping','C','U',04,'WW','Commercial','Utility','Pump House / Pumping Station / Water Tower','Waste Water Distribution / Pumping');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU06','Telecommunication','C','U',06,'','Commercial','Utility','Telecommunication','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU06TE','Telecommunications Mast','C','U',06,'TE','Commercial','Utility','Telecommunication','Telecommunications Mast');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU06TX','Telephone Exchange','C','U',06,'TX','Commercial','Utility','Telecommunication','Telephone Exchange');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU07','Water / Waste Water / Sewage Treatment Works','C','U',07,'','Commercial','Utility','Water / Waste Water / Sewage Treatment Works','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU07WR','Waste Water Treatment','C','U',07,'WR','Commercial','Utility','Water / Waste Water / Sewage Treatment Works','Waste Water Treatment');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU07WT','Water Treatment','C','U',07,'WT','Commercial','Utility','Water / Waste Water / Sewage Treatment Works','Water Treatment');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU08','Gas / Oil Storage / Distribution','C','U',08,'','Commercial','Utility','Gas / Oil Storage / Distribution','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU08GG','Gas Governor','C','U',08,'GG','Commercial','Utility','Gas / Oil Storage / Distribution','Gas Governor');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU08GH','Gas Holder','C','U',08,'GH','Commercial','Utility','Gas / Oil Storage / Distribution','Gas Holder');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU08OT','Oil Terminal','C','U',08,'OT','Commercial','Utility','Gas / Oil Storage / Distribution','Oil Terminal');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU09','Other Utility Use','C','U',09,'','Commercial','Utility','Other Utility Use','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU09OV','Observatory','C','U',09,'OV','Commercial','Utility','Other Utility Use','Observatory');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU09RA','Radar Station','C','U',09,'RA','Commercial','Utility','Other Utility Use','Radar Station');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU09SE','Satellite Earth Station','C','U',09,'SE','Commercial','Utility','Other Utility Use','Satellite Earth Station');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU09CQ','Cable Terminal Station','C','U',09,'CQ','Commercial','Utility','Other Utility Use','Cable Terminal Station');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU10','Waste Management','C','U',10,'','Commercial','Utility','Waste Management','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU11','Telephone Box','C','U',11,'','Commercial','Utility','Telephone Box','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU11OP','Other Public Telephones','C','U',11,'OP','Commercial','Utility','Telephone Box','Other Public Telephones');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CU12','Dam','C','U',12,'','Commercial','Utility','Dam','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CX','Emergency / Rescue Service','C','X',NULL,'','Commercial','Emergency / Rescue Service','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CX01','Police / Transport Police / Station','C','X',01,'','Commercial','Emergency / Rescue Service','Police / Transport Police / Station','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CX01PT','Police Training','C','X',01,'PT','Commercial','Emergency / Rescue Service','Police / Transport Police / Station','Police Training');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CX02','Fire Station','C','X',02,'','Commercial','Emergency / Rescue Service','Fire Station','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CX02FT','Fire Service Training','C','X',02,'FT','Commercial','Emergency / Rescue Service','Fire Station','Fire Service Training');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CX03','Ambulance Station','C','X',03,'','Commercial','Emergency / Rescue Service','Ambulance Station','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CX03AA','Air Sea Rescue / Air Ambulance','C','X',03,'AA','Commercial','Emergency / Rescue Service','Ambulance Station','Air Sea Rescue / Air Ambulance');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CX04','Lifeboat Services / Station','C','X',04,'','Commercial','Emergency / Rescue Service','Lifeboat Services / Station','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CX05','Coastguard Rescue / Lookout / Station','C','X',05,'','Commercial','Emergency / Rescue Service','Coastguard Rescue / Lookout / Station','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CX06','Mountain Rescue Station','C','X',06,'','Commercial','Emergency / Rescue Service','Mountain Rescue Station','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CX07','Lighthouse','C','X',07,'','Commercial','Emergency / Rescue Service','Lighthouse','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CX08','Police Box / Kiosk','C','X',08,'','Commercial','Emergency / Rescue Service','Police Box / Kiosk','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CZ','Information','C','Z',NULL,'','Commercial','Information','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CZ01','Advertising Hoarding','C','Z',01,'','Commercial','Information','Advertising Hoarding','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CZ02','Tourist Information Signage','C','Z',02,'','Commercial','Information','Tourist Information Signage','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CZ02VI','Visitor Information','C','Z',02,'VI','Commercial','Information','Tourist Information Signage','Visitor Information');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('CZ03','Traffic Information Signage','C','Z',03,'','Commercial','Information','Traffic Information Signage','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('L','Land','L','',NULL,'','Land','','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LA','Agricultural - Applicable to land in farm ownership and not run as a separate business enterprise','L','A',NULL,'','Land','Agricultural - Applicable to land in farm ownership and not run as a separate business enterprise','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LA01','Grazing Land','L','A',01,'','Land','Agricultural - Applicable to land in farm ownership and not run as a separate business enterprise','Grazing Land','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LA02','Permanent Crop / Crop Rotation','L','A',02,'','Land','Agricultural - Applicable to land in farm ownership and not run as a separate business enterprise','Permanent Crop / Crop Rotation','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LA02OC','Orchard','L','A',02,'OC','Land','Agricultural - Applicable to land in farm ownership and not run as a separate business enterprise','Permanent Crop / Crop Rotation','Orchard');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LB','Ancillary Building','L','B',NULL,'','Land','Ancillary Building','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LB99AV','Aviary / Dovecot / Cage','L','B',99,'AV','Land','Ancillary Building','','Aviary / Dovecot / Cage');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LB99BD','Bandstand','L','B',99,'BD','Land','Ancillary Building','','Bandstand');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LB99PI','Pavilion / Changing Room','L','B',99,'PI','Land','Ancillary Building','','Pavilion / Changing Room');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LB99SV','Sports Viewing Structure','L','B',99,'SV','Land','Ancillary Building','','Sports Viewing Structure');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LC','Burial Ground','L','C',NULL,'','Land','Burial Ground','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LC01','Historic / Disused Cemetery / Graveyard','L','C',01,'','Land','Burial Ground','Historic / Disused Cemetery / Graveyard','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LD','Development','L','D',NULL,'','Land','Development','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LD01','Development Site','L','D',01,'','Land','Development','Development Site','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LD01CC','Commercial Construction Site','L','D',01,'CC','Land','Development','Development Site','Commercial Construction Site');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LD01CO','Community Construction Site','L','D',01,'CO','Land','Development','Development Site','Community Construction Site');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LD01RN','Residential Construction Site','L','D',01,'RN','Land','Development','Development Site','Residential Construction Site');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LD01TC','Transport Construction Site','L','D',01,'TC','Land','Development','Development Site','Transport Construction Site');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LF','Forestry','L','F',NULL,'','Land','Forestry','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LF02','Forest / Arboretum / Pinetum (Managed / Unmanaged)','L','F',02,'','Land','Forestry','Forest / Arboretum / Pinetum (Managed / Unmanaged)','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LF02AU','Arboretum','L','F',02,'AU','Land','Forestry','Forest / Arboretum / Pinetum (Managed / Unmanaged)','Arboretum');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LF03','Woodland','L','F',03,'','Land','Forestry','Woodland','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LL','Allotment','L','L',NULL,'','Land','Allotment','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LM','Amenity - Open areas not attracting visitors','L','M',NULL,'','Land','Amenity - Open areas not attracting visitors','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LM01','Landscaped Roundabout','L','M',01,'','Land','Amenity - Open areas not attracting visitors','Landscaped Roundabout','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LM02','Verge / Central Reservation','L','M',02,'','Land','Amenity - Open areas not attracting visitors','Verge / Central Reservation','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LM02NV','Natural Central Reservation','L','M',02,'NV','Land','Amenity - Open areas not attracting visitors','Verge / Central Reservation','Natural Central Reservation');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LM02VE','Natural Verge','L','M',02,'VE','Land','Amenity - Open areas not attracting visitors','Verge / Central Reservation','Natural Verge');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LM03','Maintained Amenity Land','L','M',03,'','Land','Amenity - Open areas not attracting visitors','Maintained Amenity Land','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LM04','Maintained Surfaced Area','L','M',04,'','Land','Amenity - Open areas not attracting visitors','Maintained Surfaced Area','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LM04MV','Made Central Reservation','L','M',04,'MV','Land','Amenity - Open areas not attracting visitors','Maintained Surfaced Area','Made Central Reservation');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LM04PV','Pavement','L','M',04,'PV','Land','Amenity - Open areas not attracting visitors','Maintained Surfaced Area','Pavement');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LO','Open Space','L','O',NULL,'','Land','Open Space','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LO01','Heath / Moorland','L','O',01,'','Land','Open Space','Heath / Moorland','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LP','Park','L','P',NULL,'','Land','Park','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LP01','Public Park / Garden','L','P',01,'','Land','Park','Public Park / Garden','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LP02','Public Open Space / Nature Reserve','L','P',02,'','Land','Park','Public Open Space / Nature Reserve','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LP03','Playground','L','P',03,'','Land','Park','Playground','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LP03PA','Play Area','L','P',03,'PA','Land','Park','Playground','Play Area');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LP03PD','Paddling Pool','L','P',03,'PD','Land','Park','Playground','Paddling Pool');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LP04','Private Park / Garden','L','P',04,'','Land','Park','Private Park / Garden','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LU','Unused Land','L','U',NULL,'','Land','Unused Land','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LU01','Vacant / Derelict Land','L','U',01,'','Land','Unused Land','Vacant / Derelict Land','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LW','Water','L','W',NULL,'','Land','Water','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LW01','Lake / Reservoir','L','W',01,'','Land','Water','Lake / Reservoir','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LW01BP','Balancing Pond','L','W',01,'BP','Land','Water','Lake / Reservoir','Balancing Pond');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LW01BV','Buried Reservoir','L','W',01,'BV','Land','Water','Lake / Reservoir','Buried Reservoir');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LW02','Named Pond','L','W',02,'','Land','Water','Named Pond','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LW02DE','Dew Pond','L','W',02,'DE','Land','Water','Named Pond','Dew Pond');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LW02DP','Decoy Pond','L','W',02,'DP','Land','Water','Named Pond','Decoy Pond');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LW02IW','Static Water','L','W',02,'IW','Land','Water','Named Pond','Static Water');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LW03','Waterway','L','W',03,'','Land','Water','Waterway','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LW03LR','Leats / Races','L','W',03,'LR','Land','Water','Waterway','Leats / Races');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('LW03DR','Drain','L','W',03,'DR','Land','Water','Waterway','Drain');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('M','Military','M','',NULL,'','Military','','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MA','Army','M','A',NULL,'','Military','Army','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MA99AR','Army Military Range','M','A',99,'AR','Military','Army','','Army Military Range');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MA99AS','Army Site','M','A',99,'AS','Military','Army','','Army Site');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MA99AT','Army Military Training','M','A',99,'AT','Military','Army','','Army Military Training');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MA99AG','Army Military Storage','M','A',99,'AG','Military','Army','','Army Military Storage');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MB','Ancillary Building','M','B',NULL,'','Military','Ancillary Building','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MB99TG','Military Target','M','B',99,'TG','Military','Ancillary Building','','Military Target');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MF','Air Force','M','F',NULL,'','Military','Air Force','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MF99UG','Air Force Military Storage','M','F',99,'UG','Military','Air Force','','Air Force Military Storage');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MF99UR','Air Force Military Range','M','F',99,'UR','Military','Air Force','','Air Force Military Range');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MF99US','Air Force Site','M','F',99,'US','Military','Air Force','','Air Force Site');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MF99UT','Air Force Military Training','M','F',99,'UT','Military','Air Force','','Air Force Military Training');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MG','Defence Estates','M','G',NULL,'','Military','Defence Estates','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MN','Navy','M','N',NULL,'','Military','Navy','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MN99VG','Naval Military Storage','M','N',99,'VG','Military','Navy','','Naval Military Storage');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MN99VR','Naval Military Range','M','N',99,'VR','Military','Navy','','Naval Military Range');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MN99VS','Naval Site','M','N',99,'VS','Military','Navy','','Naval Site');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('MN99VT','Naval Military Training','M','N',99,'VT','Military','Navy','','Naval Military Training');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('O','Other (Ordnance Survey Only)','O','',NULL,'','Other (Ordnance Survey Only)','','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OA','Aid To Navigation','O','A',NULL,'','Other (Ordnance Survey Only)','Aid To Navigation','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OA01','Aid To Aeronautical Navigation','O','A',01,'','Other (Ordnance Survey Only)','Aid To Navigation','Aid To Aeronautical Navigation','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OA01AL','Aeronautical Navigation Beacon / Light','O','A',01,'AL','Other (Ordnance Survey Only)','Aid To Navigation','Aid To Aeronautical Navigation','Aeronautical Navigation Beacon / Light');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OA01LL','Landing Light','O','A',01,'LL','Other (Ordnance Survey Only)','Aid To Navigation','Aid To Aeronautical Navigation','Landing Light');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OA01SQ','Signal Square','O','A',01,'SQ','Other (Ordnance Survey Only)','Aid To Navigation','Aid To Aeronautical Navigation','Signal Square');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OA01WK','Wind Sock / Wind Tee','O','A',01,'WK','Other (Ordnance Survey Only)','Aid To Navigation','Aid To Aeronautical Navigation','Wind Sock / Wind Tee');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OA02','Aid To Nautical Navigation','O','A',02,'','Other (Ordnance Survey Only)','Aid To Navigation','Aid To Nautical Navigation','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OA02DM','Daymark','O','A',02,'DM','Other (Ordnance Survey Only)','Aid To Navigation','Aid To Nautical Navigation','Daymark');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OA02FG','Fog Horn Warning','O','A',02,'FG','Other (Ordnance Survey Only)','Aid To Navigation','Aid To Nautical Navigation','Fog Horn Warning');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OA02NL','Nautical Navigation Beacon / Light','O','A',02,'NL','Other (Ordnance Survey Only)','Aid To Navigation','Aid To Nautical Navigation','Nautical Navigation Beacon / Light');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OA03','Aid To Road Navigation','O','A',03,'','Other (Ordnance Survey Only)','Aid To Navigation','Aid To Road Navigation','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OA03GP','Guide Post','O','A',03,'GP','Other (Ordnance Survey Only)','Aid To Navigation','Aid To Road Navigation','Guide Post');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OC','Coastal Protection / Flood Prevention','O','C',NULL,'','Other (Ordnance Survey Only)','Coastal Protection / Flood Prevention','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OC01','Boulder Wall / Sea Wall','O','C',01,'','Other (Ordnance Survey Only)','Coastal Protection / Flood Prevention','Boulder Wall / Sea Wall','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OC02','Flood Gate / Flood Sluice Gate / Flood Valve','O','C',02,'','Other (Ordnance Survey Only)','Coastal Protection / Flood Prevention','Flood Gate / Flood Sluice Gate / Flood Valve','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OC03','Groyne','O','C',03,'','Other (Ordnance Survey Only)','Coastal Protection / Flood Prevention','Groyne','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OC04','Rip-Rap','O','C',04,'','Other (Ordnance Survey Only)','Coastal Protection / Flood Prevention','Rip-Rap','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OE','Emergency Support','O','E',NULL,'','Other (Ordnance Survey Only)','Emergency Support','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OE01','Beach Office / First Aid Facility','O','E',01,'','Other (Ordnance Survey Only)','Emergency Support','Beach Office / First Aid Facility','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OE02','Emergency Telephone (Non Motorway)','O','E',02,'','Other (Ordnance Survey Only)','Emergency Support','Emergency Telephone (Non Motorway)','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OE03','Fire Alarm Structure / Fire Observation Tower / Fire Beater Facility','O','E',03,'','Other (Ordnance Survey Only)','Emergency Support','Fire Alarm Structure / Fire Observation Tower / Fire Beater Facility','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OE04','Emergency Equipment Point / Emergency Siren / Warning Flag','O','E',04,'','Other (Ordnance Survey Only)','Emergency Support','Emergency Equipment Point / Emergency Siren / Warning Flag','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OE05','Lifeguard Facility','O','E',05,'','Other (Ordnance Survey Only)','Emergency Support','Lifeguard Facility','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OE06','LIfe / Belt / Buoy / Float / Jacket / Safety Rope','O','E',06,'','Other (Ordnance Survey Only)','Emergency Support','LIfe / Belt / Buoy / Float / Jacket / Safety Rope','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OF','Street Furniture','O','F',NULL,'','Other (Ordnance Survey Only)','Street Furniture','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OG','Agricultural Support Objects','O','G',NULL,'','Other (Ordnance Survey Only)','Agricultural Support Objects','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OG01','Fish Ladder / Lock / Pen / Trap','O','G',01,'','Other (Ordnance Survey Only)','Agricultural Support Objects','Fish Ladder / Lock / Pen / Trap','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OG02','Livestock Pen / Dip','O','G',02,'','Other (Ordnance Survey Only)','Agricultural Support Objects','Livestock Pen / Dip','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OG03','Currick','O','G',03,'','Other (Ordnance Survey Only)','Agricultural Support Objects','Currick','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OG04','Slurry Bed / Pit','O','G',04,'','Other (Ordnance Survey Only)','Agricultural Support Objects','Slurry Bed / Pit','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OH','Historical Site / Object','O','H',NULL,'','Other (Ordnance Survey Only)','Historical Site / Object','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OH01','Historic Structure / Object','O','H',01,'','Other (Ordnance Survey Only)','Historical Site / Object','Historic Structure / Object','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI','Industrial Support','O','I',NULL,'','Other (Ordnance Survey Only)','Industrial Support','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI01','Adit / Incline / Level','O','I',01,'','Other (Ordnance Survey Only)','Industrial Support','Adit / Incline / Level','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI02','Caisson / Dry Dock / Grid','O','I',02,'','Other (Ordnance Survey Only)','Industrial Support','Caisson / Dry Dock / Grid','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI03','Channel / Conveyor / Conduit / Pipe','O','I',03,'','Other (Ordnance Survey Only)','Industrial Support','Channel / Conveyor / Conduit / Pipe','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI04','Chimney / Flue','O','I',04,'','Other (Ordnance Survey Only)','Industrial Support','Chimney / Flue','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI05','Crane / Hoist / Winch / Material Elevator','O','I',05,'','Other (Ordnance Survey Only)','Industrial Support','Crane / Hoist / Winch / Material Elevator','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI06','Flare Stack','O','I',06,'','Other (Ordnance Survey Only)','Industrial Support','Flare Stack','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI07','Hopper / Silo / Cistern / Tank','O','I',07,'','Other (Ordnance Survey Only)','Industrial Support','Hopper / Silo / Cistern / Tank','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI08','Grab / Skip / Other Industrial Waste Machinery / Discharging','O','I',08,'','Other (Ordnance Survey Only)','Industrial Support','Grab / Skip / Other Industrial Waste Machinery / Discharging','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI09','Kiln / Oven / Smelter','O','I',09,'','Other (Ordnance Survey Only)','Industrial Support','Kiln / Oven / Smelter','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI10','Manhole / Shaft','O','I',10,'','Other (Ordnance Survey Only)','Industrial Support','Manhole / Shaft','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI11','Industrial Overflow / Sluice / Valve / Valve Housing','O','I',11,'','Other (Ordnance Survey Only)','Industrial Support','Industrial Overflow / Sluice / Valve / Valve Housing','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI12','Cooling Tower','O','I',12,'','Other (Ordnance Survey Only)','Industrial Support','Cooling Tower','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI13','Solar Panel / Waterwheel','O','I',13,'','Other (Ordnance Survey Only)','Industrial Support','Solar Panel / Waterwheel','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI14','Telephone Pole / Post','O','I',14,'','Other (Ordnance Survey Only)','Industrial Support','Telephone Pole / Post','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OI15','Electricity Distribution Pole / Pylon','O','I',15,'','Other (Ordnance Survey Only)','Industrial Support','Electricity Distribution Pole / Pylon','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ON','Significant Natural Object','O','N',NULL,'','Other (Ordnance Survey Only)','Significant Natural Object','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ON01','Boundary / Significant / Historic Tree / Pollard','O','N',01,'','Other (Ordnance Survey Only)','Significant Natural Object','Boundary / Significant / Historic Tree / Pollard','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ON02','Boundary / Significant Rock / Boulder','O','N',02,'','Other (Ordnance Survey Only)','Significant Natural Object','Boundary / Significant Rock / Boulder','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ON03','Natural Hole (Blow / Shake / Swallow)','O','N',03,'','Other (Ordnance Survey Only)','Significant Natural Object','Natural Hole (Blow / Shake / Swallow)','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OO','Ornamental / Cultural Object','O','O',NULL,'','Other (Ordnance Survey Only)','Ornamental / Cultural Object','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OO02','Mausoleum / Tomb / Grave','O','O',02,'','Other (Ordnance Survey Only)','Ornamental / Cultural Object','Mausoleum / Tomb / Grave','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OO03','Simple Ornamental Object','O','O',03,'','Other (Ordnance Survey Only)','Ornamental / Cultural Object','Simple Ornamental Object','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OO04','Maze','O','O',04,'','Other (Ordnance Survey Only)','Ornamental / Cultural Object','Maze','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OP','Sport / Leisure Support','O','P',NULL,'','Other (Ordnance Survey Only)','Sport / Leisure Support','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OP01','Butt / Hide','O','P',01,'','Other (Ordnance Survey Only)','Sport / Leisure Support','Butt / Hide','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OP02','Gallop / Ride','O','P',02,'','Other (Ordnance Survey Only)','Sport / Leisure Support','Gallop / Ride','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OP03','Miniature Railway','O','P',03,'','Other (Ordnance Survey Only)','Sport / Leisure Support','Miniature Railway','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OR','Royal Mail Infrastructure','O','R',NULL,'','Other (Ordnance Survey Only)','Royal Mail Infrastructure','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OR01','Postal Box','O','R',01,'','Other (Ordnance Survey Only)','Royal Mail Infrastructure','Postal Box','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OR02','Postal Delivery Box / Pouch','O','R',02,'','Other (Ordnance Survey Only)','Royal Mail Infrastructure','Postal Delivery Box / Pouch','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OR03','PO Box','O','R',03,'','Other (Ordnance Survey Only)','Royal Mail Infrastructure','PO Box','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OR04','Additional Mail / Packet Addressee','O','R',04,'','Other (Ordnance Survey Only)','Royal Mail Infrastructure','Additional Mail / Packet Addressee','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OS','Scientific / Observation Support','O','S',NULL,'','Other (Ordnance Survey Only)','Scientific / Observation Support','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OS01','Meteorological Station / Equipment','O','S',01,'','Other (Ordnance Survey Only)','Scientific / Observation Support','Meteorological Station / Equipment','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OS02','Radar / Satellite Infrastructure','O','S',02,'','Other (Ordnance Survey Only)','Scientific / Observation Support','Radar / Satellite Infrastructure','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OS03','Telescope / Observation Infrastructure / Astronomy','O','S',03,'','Other (Ordnance Survey Only)','Scientific / Observation Support','Telescope / Observation Infrastructure / Astronomy','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT','Transport Support','O','T',NULL,'','Other (Ordnance Survey Only)','Transport Support','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT01','Cattle Grid / Ford','O','T',01,'','Other (Ordnance Survey Only)','Transport Support','Cattle Grid / Ford','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT02','Elevator / Escalator / Steps','O','T',02,'','Other (Ordnance Survey Only)','Transport Support','Elevator / Escalator / Steps','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT03','Footbridge / Walkway','O','T',03,'','Other (Ordnance Survey Only)','Transport Support','Footbridge / Walkway','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT04','Pole / Post / Bollard (Restricting Vehicular Access)','O','T',04,'','Other (Ordnance Survey Only)','Transport Support','Pole / Post / Bollard (Restricting Vehicular Access)','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT05','Subway / Underpass','O','T',05,'','Other (Ordnance Survey Only)','Transport Support','Subway / Underpass','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT06','Customs Inspection Facility','O','T',06,'','Other (Ordnance Survey Only)','Transport Support','Customs Inspection Facility','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT07','Lay-By','O','T',07,'','Other (Ordnance Survey Only)','Transport Support','Lay-By','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT08','Level Crossing','O','T',08,'','Other (Ordnance Survey Only)','Transport Support','Level Crossing','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT09','Mail Pick Up','O','T',09,'','Other (Ordnance Survey Only)','Transport Support','Mail Pick Up','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT10','Railway Pedestrian Crossing','O','T',10,'','Other (Ordnance Survey Only)','Transport Support','Railway Pedestrian Crossing','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT11','Railway Buffer','O','T',11,'','Other (Ordnance Survey Only)','Transport Support','Railway Buffer','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT12','Rail Drag','O','T',12,'','Other (Ordnance Survey Only)','Transport Support','Rail Drag','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT13','Rail Infrastructure Services','O','T',13,'','Other (Ordnance Survey Only)','Transport Support','Rail Infrastructure Services','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT14','Rail Kilometre Distance Marker','O','T',14,'','Other (Ordnance Survey Only)','Transport Support','Rail Kilometre Distance Marker','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT15','Railway Lighting','O','T',15,'','Other (Ordnance Survey Only)','Transport Support','Railway Lighting','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT16','Rail Mile Distance Marker','O','T',16,'','Other (Ordnance Survey Only)','Transport Support','Rail Mile Distance Marker','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT17','Railway Turntable','O','T',17,'','Other (Ordnance Survey Only)','Transport Support','Railway Turntable','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT18','Rail Weighbridge','O','T',18,'','Other (Ordnance Survey Only)','Transport Support','Rail Weighbridge','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT19','Rail Signalling','O','T',19,'','Other (Ordnance Survey Only)','Transport Support','Rail Signalling','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT20','Railway Traverse','O','T',20,'','Other (Ordnance Survey Only)','Transport Support','Railway Traverse','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT21','Goods Tramway','O','T',21,'','Other (Ordnance Survey Only)','Transport Support','Goods Tramway','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT22','Road Drag','O','T',22,'','Other (Ordnance Survey Only)','Transport Support','Road Drag','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT23','Vehicle Dip','O','T',23,'','Other (Ordnance Survey Only)','Transport Support','Vehicle Dip','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT24','Road Turntable','O','T',24,'','Other (Ordnance Survey Only)','Transport Support','Road Turntable','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT25','Road Mile Distance Marker','O','T',25,'','Other (Ordnance Survey Only)','Transport Support','Road Mile Distance Marker','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT26','Road Kilometre Distance Marker','O','T',26,'','Other (Ordnance Survey Only)','Transport Support','Road Kilometre Distance Marker','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OT27','Road Infrastructure Services','O','T',27,'','Other (Ordnance Survey Only)','Transport Support','Road Infrastructure Services','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OU','Unsupported Site','O','U',NULL,'','Other (Ordnance Survey Only)','Unsupported Site','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OU01','Cycle Parking Facility','O','U',01,'','Other (Ordnance Survey Only)','Unsupported Site','Cycle Parking Facility','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OU04','Picnic / Barbeque Site','O','U',04,'','Other (Ordnance Survey Only)','Unsupported Site','Picnic / Barbeque Site','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OU05','Travelling Persons Site','O','U',05,'','Other (Ordnance Survey Only)','Unsupported Site','Travelling Persons Site','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('OU08','Shelter (Not Including Bus Shelter)','O','U',08,'','Other (Ordnance Survey Only)','Unsupported Site','Shelter (Not Including Bus Shelter)','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('P','Parent Shell','P','',NULL,'','Parent Shell','','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('PP','Property Shell','P','P',NULL,'','Parent Shell','Property Shell','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('PS','Street Record','P','S',NULL,'','Parent Shell','Street Record','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('R','Residential','R','',NULL,'','Residential','','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RB','Ancillary Building','R','B',NULL,'','Residential','Ancillary Building','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RC','Car Park Space','R','C',NULL,'','Residential','Car Park Space','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RC01','Allocated Parking','R','C',01,'','Residential','Car Park Space','Allocated Parking','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RD','Dwelling','R','D',NULL,'','Residential','Dwelling','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RD01','Caravan','R','D',01,'','Residential','Dwelling','Caravan','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RD02','Detached','R','D',02,'','Residential','Dwelling','Detached','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RD03','Semi-Detached','R','D',03,'','Residential','Dwelling','Semi-Detached','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RD04','Terraced','R','D',04,'','Residential','Dwelling','Terraced','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RD06','Self Contained Flat (Includes Maisonette / Apartment)','R','D',06,'','Residential','Dwelling','Self Contained Flat (Includes Maisonette / Apartment)','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RD07','House Boat','R','D',07,'','Residential','Dwelling','House Boat','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RD08','Sheltered Accommodation','R','D',08,'','Residential','Dwelling','Sheltered Accommodation','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RD10','Privately Owned Holiday Caravan / Chalet','R','D',10,'','Residential','Dwelling','Privately Owned Holiday Caravan / Chalet','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RG','Garage','R','G',NULL,'','Residential','Garage','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RG02','Lock-Up Garage / Garage Court','R','G',02,'','Residential','Garage','Lock-Up Garage / Garage Court','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RH','House In Multiple Occupation','R','H',NULL,'','Residential','House In Multiple Occupation','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RH01','HMO Parent','R','H',01,'','Residential','House In Multiple Occupation','HMO Parent','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RH02','HMO Bedsit / Other Non Self Contained Accommodation','R','H',02,'','Residential','House In Multiple Occupation','HMO Bedsit / Other Non Self Contained Accommodation','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RH03','HMO Not Further Divided','R','H',03,'','Residential','House In Multiple Occupation','HMO Not Further Divided','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RI','Residential Institution','R','I',NULL,'','Residential','Residential Institution','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RI01','Care / Nursing Home','R','I',01,'','Residential','Residential Institution','Care / Nursing Home','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RI02','Communal Residence','R','I',02,'','Residential','Residential Institution','Communal Residence','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RI02NC','Non-Commercial Lodgings','R','I',02,'NC','Residential','Residential Institution','Communal Residence','Non-Commercial Lodgings');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RI02RC','Religious Community','R','I',02,'RC','Residential','Residential Institution','Communal Residence','Religious Community');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('RI03','Residential Education','R','I',03,'','Residential','Residential Institution','Residential Education','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('U','Unclassified','U','',NULL,'','Unclassified','','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('UC','Awaiting Classification','U','C',NULL,'','Unclassified','Awaiting Classification','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('UP','Pending Internal Investigation','U','P',NULL,'','Unclassified','Pending Internal Investigation','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('X','Dual Use','X','',NULL,'','Dual Use','','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('Z','Object of Interest','Z','',NULL,'','Object of Interest','','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZA','Archaeological Dig Site','Z','A',NULL,'','Object of Interest','Archaeological Dig Site','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZM','Monument','Z','M',NULL,'','Object of Interest','Monument','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZM01','Obelisk / Milestone / Standing Stone','Z','M',01,'','Object of Interest','Monument','Obelisk / Milestone / Standing Stone','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZM01OB','Obelisk','Z','M',01,'OB','Object of Interest','Monument','Obelisk / Milestone / Standing Stone','Obelisk');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZM01ST','Standing Stone','Z','M',01,'ST','Object of Interest','Monument','Obelisk / Milestone / Standing Stone','Standing Stone');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZM02','Memorial / Market Cross','Z','M',02,'','Object of Interest','Monument','Memorial / Market Cross','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZM03','Statue','Z','M',03,'','Object of Interest','Monument','Statue','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZM04','Castle / Historic Ruin','Z','M',04,'','Object of Interest','Monument','Castle / Historic Ruin','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZM05','Other Structure','Z','M',05,'','Object of Interest','Monument','Other Structure','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZM05BS','Boundary Stone','Z','M',05,'BS','Object of Interest','Monument','Other Structure','Boundary Stone');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZM05PN','Permanent Art Display / Sculpture','Z','M',05,'PN','Object of Interest','Monument','Other Structure','Permanent Art Display / Sculpture');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZM05CE','Cascade / Fountain','Z','M',05,'CE','Object of Interest','Monument','Other Structure','Cascade / Fountain');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZM05WI','Windmill (Inactive)','Z','M',05,'WI','Object of Interest','Monument','Other Structure','Windmill (Inactive)');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZS','Stately Home','Z','S',NULL,'','Object of Interest','Stately Home','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZU','Underground Feature','Z','U',NULL,'','Object of Interest','Underground Feature','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZU01','Cave','Z','U',01,'','Object of Interest','Underground Feature','Cave','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZU04','Pothole / Natural Hole','Z','U',04,'','Object of Interest','Underground Feature','Pothole / Natural Hole','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZV','Other Underground Feature','Z','V',NULL,'','Object of Interest','Other Underground Feature','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZV01','Cellar','Z','V',01,'','Object of Interest','Other Underground Feature','Cellar','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZV02','Disused Mine','Z','V',02,'','Object of Interest','Other Underground Feature','Disused Mine','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZV02MI','Mineral Mining / Inactive','Z','V',02,'MI','Object of Interest','Other Underground Feature','Disused Mine','Mineral Mining / Inactive');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZV02OI','Oil And / Gas Extraction/ Inactive','Z','V',02,'OI','Object of Interest','Other Underground Feature','Disused Mine','Oil And / Gas Extraction/ Inactive');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZV02QI','Mineral Quarrying And / Open Extraction / Inactive','Z','V',02,'QI','Object of Interest','Other Underground Feature','Disused Mine','Mineral Quarrying And / Open Extraction / Inactive');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZV03','Well / Spring','Z','V',03,'','Object of Interest','Other Underground Feature','Well / Spring','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZV03SG','Spring','Z','V',03,'SG','Object of Interest','Other Underground Feature','Well / Spring','Spring');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZV03WL','Well','Z','V',03,'WL','Object of Interest','Other Underground Feature','Well / Spring','Well');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW','Place Of Worship','Z','W',NULL,'','Object of Interest','Place Of Worship','','');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW99AB','Abbey','Z','W',99,'AB','Object of Interest','Place Of Worship','','Abbey');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW99CA','Cathedral','Z','W',99,'CA','Object of Interest','Place Of Worship','','Cathedral');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW99CH','Church','Z','W',99,'CH','Object of Interest','Place Of Worship','','Church');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW99CP','Chapel','Z','W',99,'CP','Object of Interest','Place Of Worship','','Chapel');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW99GU','Gurdwara','Z','W',99,'GU','Object of Interest','Place Of Worship','','Gurdwara');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW99KH','Kingdom Hall','Z','W',99,'KH','Object of Interest','Place Of Worship','','Kingdom Hall');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW99MQ','Mosque','Z','W',99,'MQ','Object of Interest','Place Of Worship','','Mosque');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW99MT','Minster','Z','W',99,'MT','Object of Interest','Place Of Worship','','Minster');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW99SU','Stupa','Z','W',99,'SU','Object of Interest','Place Of Worship','','Stupa');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW99SY','Synagogue','Z','W',99,'SY','Object of Interest','Place Of Worship','','Synagogue');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW99TP','Temple','Z','W',99,'TP','Object of Interest','Place Of Worship','','Temple');
INSERT INTO abaseprem.classifications(Concatenated,Class_Desc,Primary_Code,Secondary_Code,Tertiary_Code,Quaternary_Code,Primary_Desc,Secondary_Desc,Tertiary_Desc,Quaternary_Desc) VALUES ('ZW99LG','Lych Gate','Z','W',99,'LG','Object of Interest','Place Of Worship','','Lych Gate');



CREATE INDEX idx_concat_class ON abaseprem.classifications(Concatenated);
COMMIT;