Created
March 8, 2016 08:33
-
-
Save TimJMartin/e1b75d1c7380f450c27f to your computer and use it in GitHub Desktop.
POI Classifications SQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--SQL to create POI Classifications Table | |
DROP TABLE IF EXISTS poi.classifications; | |
COMMIT; | |
CREATE TABLE IF NOT EXISTS poi.classifications( | |
CLASSIFCATION_CODE VARCHAR(8) NOT NULL PRIMARY KEY | |
,GROUP_ID VARCHAR(2) NOT NULL | |
,GROUP_DESCRIPTION VARCHAR(34) NOT NULL | |
,CATEGORY_ID VARCHAR(2) NOT NULL | |
,CATEGORY_DESCRIPTION VARCHAR(45) NOT NULL | |
,CLASS_CODE VARCHAR(4) NOT NULL | |
,CLASS_DESCRIPTION VARCHAR(64) NOT NULL | |
); | |
COMMIT; | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01010002','01','Accommodation, eating and drinking','01','Accommodation','0002','Camping, Caravanning, Mobile Homes, Holiday Parks and Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01010003','01','Accommodation, eating and drinking','01','Accommodation','0003','Bed and Breakfast and Backpacker Accommodation'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01010005','01','Accommodation, eating and drinking','01','Accommodation','0005','Hostels and Refuges For The Homeless'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01010006','01','Accommodation, eating and drinking','01','Accommodation','0006','Hotels, Motels, Country Houses and Inns'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01010007','01','Accommodation, eating and drinking','01','Accommodation','0007','Self Catering'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01010008','01','Accommodation, eating and drinking','01','Accommodation','0008','Timeshare'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01010009','01','Accommodation, eating and drinking','01','Accommodation','0009','Youth Accommodation'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01020012','01','Accommodation, eating and drinking','02','Eating and drinking','0012','Banqueting and Function Rooms'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01020013','01','Accommodation, eating and drinking','02','Eating and drinking','0013','Cafes, Snack Bars and Tea Rooms'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01020018','01','Accommodation, eating and drinking','02','Eating and drinking','0018','Fast Food and Takeaway Outlets'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01020019','01','Accommodation, eating and drinking','02','Eating and drinking','0019','Fast Food Delivery Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01020020','01','Accommodation, eating and drinking','02','Eating and drinking','0020','Fish and Chip Shops'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01020025','01','Accommodation, eating and drinking','02','Eating and drinking','0025','Internet Cafes'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01020034','01','Accommodation, eating and drinking','02','Eating and drinking','0034','Pubs, Bars and Inns'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('01020043','01','Accommodation, eating and drinking','02','Eating and drinking','0043','Restaurants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030044','02','Commercial services','03','Construction services','0044','Metalworkers Including Blacksmiths'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030045','02','Commercial services','03','Construction services','0045','Building Contractors'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030046','02','Commercial services','03','Construction services','0046','Construction Completion Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030047','02','Commercial services','03','Construction services','0047','Construction Plant'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030048','02','Commercial services','03','Construction services','0048','Cutting, Drilling and Welding Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030049','02','Commercial services','03','Construction services','0049','Demolition Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030050','02','Commercial services','03','Construction services','0050','Diving Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030051','02','Commercial services','03','Construction services','0051','Electrical Contractors'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030052','02','Commercial services','03','Construction services','0052','Gardening, Landscaping and Tree Surgery Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030053','02','Commercial services','03','Construction services','0053','Glaziers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030054','02','Commercial services','03','Construction services','0054','Painting and Decorating Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030055','02','Commercial services','03','Construction services','0055','Plasterers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030056','02','Commercial services','03','Construction services','0056','Plumbing and Heating Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030057','02','Commercial services','03','Construction services','0057','Pool and Court Construction'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030058','02','Commercial services','03','Construction services','0058','Restoration and Preservation Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030059','02','Commercial services','03','Construction services','0059','Road Construction Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030060','02','Commercial services','03','Construction services','0060','Roofing and Chimney Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02030779','02','Commercial services','03','Construction services','0779','Building and Component Suppliers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02040063','02','Commercial services','04','Consultancies','0063','Architectural and Building-Related Consultants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02040064','02','Commercial services','04','Consultancies','0064','Business-Related Consultants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02040065','02','Commercial services','04','Consultancies','0065','Computer Consultants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02040066','02','Commercial services','04','Consultancies','0066','Construction Service Consultants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02040067','02','Commercial services','04','Consultancies','0067','Feng Shui Consultants, Furnishers and Shop Fitters'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02040068','02','Commercial services','04','Consultancies','0068','Food Consultants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02040069','02','Commercial services','04','Consultancies','0069','Image Consultants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02040070','02','Commercial services','04','Consultancies','0070','Interpretation and Translation Consultants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02040071','02','Commercial services','04','Consultancies','0071','Security Consultants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02040072','02','Commercial services','04','Consultancies','0072','Telecommunications Consultants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02040074','02','Commercial services','04','Consultancies','0074','Traffic Management and Transport Related Consultants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02050075','02','Commercial services','05','Employment and career agencies','0075','Careers Offices and Armed Forces Recruitment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02050076','02','Commercial services','05','Employment and career agencies','0076','Domestic Staff and Home Help'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02050077','02','Commercial services','05','Employment and career agencies','0077','Driver Agencies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02050078','02','Commercial services','05','Employment and career agencies','0078','Employment Agencies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02050079','02','Commercial services','05','Employment and career agencies','0079','Modelling and Theatrical Agencies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02050081','02','Commercial services','05','Employment and career agencies','0081','Nursing Agencies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02060083','02','Commercial services','06','Engineering services','0083','Aviation Engineers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02060084','02','Commercial services','06','Engineering services','0084','Chemical Engineers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02060085','02','Commercial services','06','Engineering services','0085','Civil Engineers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02060086','02','Commercial services','06','Engineering services','0086','Electrical and Electronic Engineers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02060087','02','Commercial services','06','Engineering services','0087','Hydraulic Engineers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02060088','02','Commercial services','06','Engineering services','0088','Industrial Engineers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02060089','02','Commercial services','06','Engineering services','0089','Instrumentation Engineers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02060090','02','Commercial services','06','Engineering services','0090','Marine Engineers and Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02060091','02','Commercial services','06','Engineering services','0091','Mechanical Engineers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02060092','02','Commercial services','06','Engineering services','0092','Pneumatic Engineers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02060093','02','Commercial services','06','Engineering services','0093','Precision Engineers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02060094','02','Commercial services','06','Engineering services','0094','Structural Engineers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02070095','02','Commercial services','07','Contract services','0095','Agricultural Contractors'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02070096','02','Commercial services','07','Contract services','0096','Aircraft Charters'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02070098','02','Commercial services','07','Contract services','0098','Catering Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02070100','02','Commercial services','07','Contract services','0100','Contract Cleaning Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02070101','02','Commercial services','07','Contract services','0101','Display and Window Dressers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02070102','02','Commercial services','07','Contract services','0102','Drain and Sewage Clearance'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02070105','02','Commercial services','07','Contract services','0105','Linen Hire and Washroom Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02070107','02','Commercial services','07','Contract services','0107','Office Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02070108','02','Commercial services','07','Contract services','0108','Packers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02070109','02','Commercial services','07','Contract services','0109','Pest and Vermin Control'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080114','02','Commercial services','08','IT, advertising, marketing and media services','0114','Advertising Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080115','02','Commercial services','08','IT, advertising, marketing and media services','0115','Artists, Illustrators and Calligraphers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080116','02','Commercial services','08','IT, advertising, marketing and media services','0116','Computer Security'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080117','02','Commercial services','08','IT, advertising, marketing and media services','0117','Computer Systems Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080118','02','Commercial services','08','IT, advertising, marketing and media services','0118','Concert/Exhibition Organisers and Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080119','02','Commercial services','08','IT, advertising, marketing and media services','0119','Database Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080120','02','Commercial services','08','IT, advertising, marketing and media services','0120','Desktop Publishing Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080121','02','Commercial services','08','IT, advertising, marketing and media services','0121','Electronic and Internet Publishers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080122','02','Commercial services','08','IT, advertising, marketing and media services','0122','Film and Video Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080123','02','Commercial services','08','IT, advertising, marketing and media services','0123','General Computer Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080124','02','Commercial services','08','IT, advertising, marketing and media services','0124','Internet Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080125','02','Commercial services','08','IT, advertising, marketing and media services','0125','Literary Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080126','02','Commercial services','08','IT, advertising, marketing and media services','0126','Mailing and Other Information Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080127','02','Commercial services','08','IT, advertising, marketing and media services','0127','Marketing Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080128','02','Commercial services','08','IT, advertising, marketing and media services','0128','Plate Makers, Print Finishers and Type Setters'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080129','02','Commercial services','08','IT, advertising, marketing and media services','0129','Press and Journalism Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080130','02','Commercial services','08','IT, advertising, marketing and media services','0130','Printing and Photocopying Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080131','02','Commercial services','08','IT, advertising, marketing and media services','0131','Recording Studios and Record Companies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080133','02','Commercial services','08','IT, advertising, marketing and media services','0133','Telephone, Telex and Fax Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02080134','02','Commercial services','08','IT, advertising, marketing and media services','0134','Television and Radio Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090135','02','Commercial services','09','Legal and financial','0135','Accountants and Auditors'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090137','02','Commercial services','09','Legal and financial','0137','Auctioneers, Auction Rooms and Valuers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090138','02','Commercial services','09','Legal and financial','0138','Banks and Building Societies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090140','02','Commercial services','09','Legal and financial','0140','Currency Conversion and Money Transfers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090141','02','Commercial services','09','Legal and financial','0141','Cash Machines'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090142','02','Commercial services','09','Legal and financial','0142','Cheque Cashing'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090143','02','Commercial services','09','Legal and financial','0143','Company Registration and Trademarks'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090144','02','Commercial services','09','Legal and financial','0144','Copyright and Patent'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090145','02','Commercial services','09','Legal and financial','0145','Credit Reference Agencies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090146','02','Commercial services','09','Legal and financial','0146','Debt Collecting Agencies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090147','02','Commercial services','09','Legal and financial','0147','Financial Advice Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090148','02','Commercial services','09','Legal and financial','0148','Fundraising Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090149','02','Commercial services','09','Legal and financial','0149','Insurers and Support Activities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090150','02','Commercial services','09','Legal and financial','0150','Mortgage and Financial Lenders'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090151','02','Commercial services','09','Legal and financial','0151','Pawnbrokers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090154','02','Commercial services','09','Legal and financial','0154','Solicitors, Advocates and Notaries Public'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090773','02','Commercial services','09','Legal and financial','0773','Stocks, Shares and Unit Trusts'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090795','02','Commercial services','09','Legal and financial','0795','Commodity Dealers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090796','02','Commercial services','09','Legal and financial','0796','Franchise and Holding Company Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090811','02','Commercial services','09','Legal and financial','0811','PayPoint Locations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02090829','02','Commercial services','09','Legal and financial','0829','Pension and Fund Management'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100103','02','Commercial services','10','Personal, consumer and other services','0103','Hotel Booking Agencies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100112','02','Commercial services','10','Personal, consumer and other services','0112','Event Ticket Agents and Box Office'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100155','02','Commercial services','10','Personal, consumer and other services','0155','Astrologers, Clairvoyants and Palmists'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100156','02','Commercial services','10','Personal, consumer and other services','0156','Hair and Beauty Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100158','02','Commercial services','10','Personal, consumer and other services','0158','Cleaning Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100160','02','Commercial services','10','Personal, consumer and other services','0160','Customer Service Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100161','02','Commercial services','10','Personal, consumer and other services','0161','CV Writers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100162','02','Commercial services','10','Personal, consumer and other services','0162','Detective and Investigation Agencies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100165','02','Commercial services','10','Personal, consumer and other services','0165','Funeral and Associated Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100166','02','Commercial services','10','Personal, consumer and other services','0166','Historical Research'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100167','02','Commercial services','10','Personal, consumer and other services','0167','Headquarters, Administration and Central Offices'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100169','02','Commercial services','10','Personal, consumer and other services','0169','Introduction and Dating Agencies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100170','02','Commercial services','10','Personal, consumer and other services','0170','Lock, Key and Security Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100171','02','Commercial services','10','Personal, consumer and other services','0171','Message and Greeting Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100173','02','Commercial services','10','Personal, consumer and other services','0173','Motoring Organisations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100174','02','Commercial services','10','Personal, consumer and other services','0174','Party Organisers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100175','02','Commercial services','10','Personal, consumer and other services','0175','Personalisation'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100177','02','Commercial services','10','Personal, consumer and other services','0177','Photographic Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100179','02','Commercial services','10','Personal, consumer and other services','0179','Sports Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100180','02','Commercial services','10','Personal, consumer and other services','0180','Tattooing and Piercing Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100182','02','Commercial services','10','Personal, consumer and other services','0182','Trophies and Engraving Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100183','02','Commercial services','10','Personal, consumer and other services','0183','Vehicle Cleaning Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100185','02','Commercial services','10','Personal, consumer and other services','0185','Weather Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100186','02','Commercial services','10','Personal, consumer and other services','0186','Wedding Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100188','02','Commercial services','10','Personal, consumer and other services','0188','Window Cleaners'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100774','02','Commercial services','10','Personal, consumer and other services','0774','Musicians, Orchestras and Composers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100775','02','Commercial services','10','Personal, consumer and other services','0775','Sculptors, Wood Workers and Stone Masons'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100776','02','Commercial services','10','Personal, consumer and other services','0776','Tailoring and Clothing Alteration'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100777','02','Commercial services','10','Personal, consumer and other services','0777','Vehicle Breakdown and Recovery Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100818','02','Commercial services','10','Personal, consumer and other services','0818','Sewage Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100821','02','Commercial services','10','Personal, consumer and other services','0821','Spas'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100822','02','Commercial services','10','Personal, consumer and other services','0822','Slimming Clubs and Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100823','02','Commercial services','10','Personal, consumer and other services','0823','Adult Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02100826','02','Commercial services','10','Personal, consumer and other services','0826','Printing On Garments'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02110189','02','Commercial services','11','Property and development services','0189','Commercial Property Letting'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02110190','02','Commercial services','11','Property and development services','0190','Property Sales'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02110191','02','Commercial services','11','Property and development services','0191','Estate and Property Management'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02110192','02','Commercial services','11','Property and development services','0192','Property Letting'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02110194','02','Commercial services','11','Property and development services','0194','Property Development Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02110195','02','Commercial services','11','Property and development services','0195','Property Information Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02120196','02','Commercial services','12','Recycling services','0196','Recycling, Reclamation and Disposal'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02120198','02','Commercial services','12','Recycling services','0198','Rag Merchants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02120199','02','Commercial services','12','Recycling services','0199','Clearance and Salvage Dealers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02120200','02','Commercial services','12','Recycling services','0200','Scrap Metal Dealers and Breakers Yards'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02120202','02','Commercial services','12','Recycling services','0202','Waste Paper Merchants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02130204','02','Commercial services','13','Repair and servicing','0204','Building Repairs'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02130205','02','Commercial services','13','Repair and servicing','0205','Electrical Equipment Repair and Servicing'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02130206','02','Commercial services','13','Repair and servicing','0206','Household Repairs and Restoration'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02130207','02','Commercial services','13','Repair and servicing','0207','Industrial Repairs and Servicing'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02130209','02','Commercial services','13','Repair and servicing','0209','Service Industry Equipment Repairs'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02130210','02','Commercial services','13','Repair and servicing','0210','Sports and Leisure Equipment Repair'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02130211','02','Commercial services','13','Repair and servicing','0211','Tool Repairs'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02130212','02','Commercial services','13','Repair and servicing','0212','Vehicle Repair, Testing and Servicing'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02130793','02','Commercial services','13','Repair and servicing','0793','Shoe Repairs'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02140214','02','Commercial services','14','Research and design','0214','Design Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02140216','02','Commercial services','14','Research and design','0216','Research Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02140217','02','Commercial services','14','Research and design','0217','Testing and Analysis Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02150218','02','Commercial services','15','Transport, storage and delivery','0218','Airlines and Airline Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02150219','02','Commercial services','15','Transport, storage and delivery','0219','Animal Transportation'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02150221','02','Commercial services','15','Transport, storage and delivery','0221','Container and Storage'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02150222','02','Commercial services','15','Transport, storage and delivery','0222','Courier, Delivery and Messenger'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02150223','02','Commercial services','15','Transport, storage and delivery','0223','Distribution and Haulage'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02150224','02','Commercial services','15','Transport, storage and delivery','0224','Ferry and Cruise Companies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02150225','02','Commercial services','15','Transport, storage and delivery','0225','Import and Export Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02150227','02','Commercial services','15','Transport, storage and delivery','0227','Railway Related Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02150228','02','Commercial services','15','Transport, storage and delivery','0228','Removals and Shipping Agents'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02150230','02','Commercial services','15','Transport, storage and delivery','0230','Taxi Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02600097','02','Commercial services','60','Hire services','0097','Boat Hiring Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02600099','02','Commercial services','60','Hire services','0099','Construction and Tool Hire'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02600104','02','Commercial services','60','Hire services','0104','Leisure Equipment Hirings'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02600110','02','Commercial services','60','Hire services','0110','Renting and Leasing of Personal and Household Goods'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02600111','02','Commercial services','60','Hire services','0111','Sound, Light and Vision Service and Equipment Hire'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02600113','02','Commercial services','60','Hire services','0113','Vehicle Hire and Rental'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02600159','02','Commercial services','60','Hire services','0159','Clothing Hire'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('02600270','02','Commercial services','60','Hire services','0270','Bouncy Castles and Inflatables Hire'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03160231','03','Attractions','16','Botanical and zoological','0231','Aquaria and Sea Life Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03160232','03','Attractions','16','Botanical and zoological','0232','Bird Reserves, Collections and Sanctuaries'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03160233','03','Attractions','16','Botanical and zoological','0233','Butterfly Farms'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03160235','03','Attractions','16','Botanical and zoological','0235','Farm Based Attractions'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03160236','03','Attractions','16','Botanical and zoological','0236','Horticultural Attractions'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03160237','03','Attractions','16','Botanical and zoological','0237','Salmon Ladders'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03160239','03','Attractions','16','Botanical and zoological','0239','Zoos and Animal Collections'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03170240','03','Attractions','17','Historical and cultural','0240','Archaeological Sites'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03170241','03','Attractions','17','Historical and cultural','0241','Battlefields'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03170244','03','Attractions','17','Historical and cultural','0244','Historic Buildings Including Castles, Forts and Abbeys'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03170245','03','Attractions','17','Historical and cultural','0245','Historic and Ceremonial Structures'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03170246','03','Attractions','17','Historical and cultural','0246','Historical Ships'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03170248','03','Attractions','17','Historical and cultural','0248','Museums'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03170813','03','Attractions','17','Historical and cultural','0813','Art Galleries'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03180252','03','Attractions','18','Recreational','0252','Commons'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03180253','03','Attractions','18','Recreational','0253','Country and National Parks'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03180254','03','Attractions','18','Recreational','0254','Picnic Areas'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03180255','03','Attractions','18','Recreational','0255','Playgrounds'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03180814','03','Attractions','18','Recreational','0814','Municipal Parks and Gardens'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03190257','03','Attractions','19','Landscape features','0257','Designated Scenic Features'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03190259','03','Attractions','19','Landscape features','0259','Trigonometric Points'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03200263','03','Attractions','20','Tourism','0263','Laseria, Observatories and Planetaria'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03200264','03','Attractions','20','Tourism','0264','Model Villages'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03200265','03','Attractions','20','Tourism','0265','Railways (Heritage, Steam and Miniature)'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03200266','03','Attractions','20','Tourism','0266','Theme and Adventure Parks'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03200267','03','Attractions','20','Tourism','0267','Siteseeing, Tours, Viewing and Visitor Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03200268','03','Attractions','20','Tourism','0268','Information Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03200269','03','Attractions','20','Tourism','0269','Unspecified and Other Attractions'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03580803','03','Attractions','58','Bodies of water','0803','Ponds'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03580804','03','Attractions','58','Bodies of water','0804','Lakes and Waters'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03580805','03','Attractions','58','Bodies of water','0805','Lochs and Lochans'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03580806','03','Attractions','58','Bodies of water','0806','Tarns, Pools and Meres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03580807','03','Attractions','58','Bodies of water','0807','Reservoirs'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('03580808','03','Attractions','58','Bodies of water','0808','Settling, Balancing and Silt Ponds'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04210271','04','Sport and entertainment','21','Sport and entertainment support services','0271','Children''s Activity Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04210273','04','Sport and entertainment','21','Sport and entertainment support services','0273','Entertainment Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04210274','04','Sport and entertainment','21','Sport and entertainment support services','0274','Firework Related Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04210275','04','Sport and entertainment','21','Sport and entertainment support services','0275','Funfair Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04210276','04','Sport and entertainment','21','Sport and entertainment support services','0276','Mobile Discos'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04210820','04','Sport and entertainment','21','Sport and entertainment support services','0820','Motorsport Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04220277','04','Sport and entertainment','22','Gambling','0277','Amusement Parks and Arcades'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04220278','04','Sport and entertainment','22','Gambling','0278','Bingo Halls'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04220279','04','Sport and entertainment','22','Gambling','0279','Bookmakers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04220280','04','Sport and entertainment','22','Gambling','0280','Casinos'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04220281','04','Sport and entertainment','22','Gambling','0281','Pools Promoters'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04230282','04','Sport and entertainment','23','Outdoor pursuits','0282','Angling and Sports Fishing'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04230283','04','Sport and entertainment','23','Outdoor pursuits','0283','Combat, Laser and Paintball Games'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04230284','04','Sport and entertainment','23','Outdoor pursuits','0284','Hot Air Ballooning'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04230285','04','Sport and entertainment','23','Outdoor pursuits','0285','Parachuting and Bungee Jumping'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04230286','04','Sport and entertainment','23','Outdoor pursuits','0286','Paragliding and Hang Gliding'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04230287','04','Sport and entertainment','23','Outdoor pursuits','0287','Watersports'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04230321','04','Sport and entertainment','23','Outdoor pursuits','0321','Riding Schools, Livery Stables and Equestrian Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04230770','04','Sport and entertainment','23','Outdoor pursuits','0770','Outdoor Pursuit Organisers and Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240289','04','Sport and entertainment','24','Sports complex','0289','Athletics Facilities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240290','04','Sport and entertainment','24','Sports complex','0290','Bowling Facilities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240291','04','Sport and entertainment','24','Sports complex','0291','Climbing Facilities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240292','04','Sport and entertainment','24','Sports complex','0292','Golf Ranges, Courses, Clubs and Professionals'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240293','04','Sport and entertainment','24','Sports complex','0293','Gymnasiums, Sports Halls and Leisure Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240294','04','Sport and entertainment','24','Sports complex','0294','Ice Rinks'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240297','04','Sport and entertainment','24','Sports complex','0297','Motorsport Venues'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240298','04','Sport and entertainment','24','Sports complex','0298','Racecourses and Greyhound Tracks'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240299','04','Sport and entertainment','24','Sports complex','0299','Shooting Facilities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240300','04','Sport and entertainment','24','Sports complex','0300','Ski Infrastructure and Aerial Cableways'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240301','04','Sport and entertainment','24','Sports complex','0301','Snooker and Pool Halls'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240302','04','Sport and entertainment','24','Sports complex','0302','Sports Grounds, Stadia and Pitches'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240303','04','Sport and entertainment','24','Sports complex','0303','Squash Courts'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240304','04','Sport and entertainment','24','Sports complex','0304','Swimming Pools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240305','04','Sport and entertainment','24','Sports complex','0305','Tennis Facilities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04240306','04','Sport and entertainment','24','Sports complex','0306','Velodromes'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04250308','04','Sport and entertainment','25','Venues, stage and screen','0308','Cinemas'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04250311','04','Sport and entertainment','25','Venues, stage and screen','0311','Discos'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04250312','04','Sport and entertainment','25','Venues, stage and screen','0312','Nightclubs'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04250314','04','Sport and entertainment','25','Venues, stage and screen','0314','Social Clubs'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04250315','04','Sport and entertainment','25','Venues, stage and screen','0315','Theatres and Concert Halls'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04250762','04','Sport and entertainment','25','Venues, stage and screen','0762','Conference and Exhibition Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('04250825','04','Sport and entertainment','25','Venues, stage and screen','0825','Adult Venues'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05260316','05','Education and health','26','Animal welfare','0316','Animal Clipping and Grooming'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05260317','05','Education and health','26','Animal welfare','0317','Dog Training'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05260318','05','Education and health','26','Animal welfare','0318','Horse Training'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05260319','05','Education and health','26','Animal welfare','0319','Kennels and Catteries'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05260320','05','Education and health','26','Animal welfare','0320','Pet Cemeteries and Crematoria'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05260322','05','Education and health','26','Animal welfare','0322','Veterinarians and Animal Hospitals'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05260323','05','Education and health','26','Animal welfare','0323','Veterinary Pharmacies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05270324','05','Education and health','27','Education support services','0324','Education Authorities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05270325','05','Education and health','27','Education support services','0325','Education Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05270326','05','Education and health','27','Education support services','0326','Examination Boards'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05270799','05','Education and health','27','Education support services','0799','Playing For Success Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05270800','05','Education and health','27','Education support services','0800','Secure Units'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280330','05','Education and health','28','Health practitioners and establishments','0330','Alternative, Natural and Complementary'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280333','05','Education and health','28','Health practitioners and establishments','0333','Foot Related Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280335','05','Education and health','28','Health practitioners and establishments','0335','Dental Technicians'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280337','05','Education and health','28','Health practitioners and establishments','0337','Dieticians and Nutritionists'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280340','05','Education and health','28','Health practitioners and establishments','0340','Homeopaths'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280342','05','Education and health','28','Health practitioners and establishments','0342','Midwifery'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280344','05','Education and health','28','Health practitioners and establishments','0344','Optometrists and Opticians'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280345','05','Education and health','28','Health practitioners and establishments','0345','Physical Therapy'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280352','05','Education and health','28','Health practitioners and establishments','0352','Speech Therapists'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280354','05','Education and health','28','Health practitioners and establishments','0354','Surgeons and Cosmetic Surgeries'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280364','05','Education and health','28','Health practitioners and establishments','0364','Chemists and Pharmacies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280365','05','Education and health','28','Health practitioners and establishments','0365','Clinics and Health Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280367','05','Education and health','28','Health practitioners and establishments','0367','Dental and Medical Laboratories'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280368','05','Education and health','28','Health practitioners and establishments','0368','Dental Surgeries'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280369','05','Education and health','28','Health practitioners and establishments','0369','Doctors Surgeries'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280370','05','Education and health','28','Health practitioners and establishments','0370','Hospices'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280371','05','Education and health','28','Health practitioners and establishments','0371','Hospitals'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280372','05','Education and health','28','Health practitioners and establishments','0372','Mental Health Centres and Practitioners'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280373','05','Education and health','28','Health practitioners and establishments','0373','Nursing and Residential Care Homes'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280780','05','Education and health','28','Health practitioners and establishments','0780','Accident and Emergency Hospitals'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280809','05','Education and health','28','Health practitioners and establishments','0809','Parenting and Childcare Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280812','05','Education and health','28','Health practitioners and establishments','0812','Walk-In Centre'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05280815','05','Education and health','28','Health practitioners and establishments','0815','Day and Care Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05290106','05','Education and health','29','Health support services','0106','Medical Equipment Rental and Leasing'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05290356','05','Education and health','29','Health support services','0356','Ambulance and Medical Transportation Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05290357','05','Education and health','29','Health support services','0357','Blood Transfusion Service'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05290358','05','Education and health','29','Health support services','0358','Counselling and Advice Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05290359','05','Education and health','29','Health support services','0359','Health Authorities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05290361','05','Education and health','29','Health support services','0361','Medical Waste Disposal Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05290362','05','Education and health','29','Health support services','0362','Pregnancy Related Services and Help Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05290363','05','Education and health','29','Health support services','0363','X-Ray Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05310375','05','Education and health','31','Primary, secondary and tertiary education','0375','First, Primary and Infant Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05310376','05','Education and health','31','Primary, secondary and tertiary education','0376','Further Education Establishments'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05310377','05','Education and health','31','Primary, secondary and tertiary education','0377','Independent and Preparatory Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05310379','05','Education and health','31','Primary, secondary and tertiary education','0379','Broad Age Range and Secondary State Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05310380','05','Education and health','31','Primary, secondary and tertiary education','0380','Special Schools and Colleges'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05310381','05','Education and health','31','Primary, secondary and tertiary education','0381','Higher Education Establishments'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05310382','05','Education and health','31','Primary, secondary and tertiary education','0382','Unspecified and Other Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05310801','05','Education and health','31','Primary, secondary and tertiary education','0801','Pupil Referral Units'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320384','05','Education and health','32','Recreational and vocational education','0384','Ballet and Dance Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320385','05','Education and health','32','Recreational and vocational education','0385','Beauty and Hairdressing Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320388','05','Education and health','32','Recreational and vocational education','0388','Diving Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320389','05','Education and health','32','Recreational and vocational education','0389','Drama Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320390','05','Education and health','32','Recreational and vocational education','0390','Driving and Motorcycle Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320391','05','Education and health','32','Recreational and vocational education','0391','First Aid Training'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320392','05','Education and health','32','Recreational and vocational education','0392','Flying Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320394','05','Education and health','32','Recreational and vocational education','0394','Language Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320395','05','Education and health','32','Recreational and vocational education','0395','Martial Arts Instruction'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320396','05','Education and health','32','Recreational and vocational education','0396','Music Teachers and Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320397','05','Education and health','32','Recreational and vocational education','0397','Nursery Schools and Pre and After School Care'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320399','05','Education and health','32','Recreational and vocational education','0399','Sailing Schools'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320400','05','Education and health','32','Recreational and vocational education','0400','Sports and Fitness Coaching'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('05320403','05','Education and health','32','Recreational and vocational education','0403','Training Providers and Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330404','06','Public infrastructure','33','Central and local Government','0404','Armed Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330407','06','Public infrastructure','33','Central and local Government','0407','Coastal Safety'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330408','06','Public infrastructure','33','Central and local Government','0408','Consular Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330409','06','Public infrastructure','33','Central and local Government','0409','Courts, Court Services and Tribunals'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330411','06','Public infrastructure','33','Central and local Government','0411','Driving Test Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330412','06','Public infrastructure','33','Central and local Government','0412','Embassies and Consulates'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330414','06','Public infrastructure','33','Central and local Government','0414','Fire Brigade Stations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330415','06','Public infrastructure','33','Central and local Government','0415','Central Government'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330416','06','Public infrastructure','33','Central and local Government','0416','Local Government'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330417','06','Public infrastructure','33','Central and local Government','0417','Revenue and Customs Offices'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330418','06','Public infrastructure','33','Central and local Government','0418','Job Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330419','06','Public infrastructure','33','Central and local Government','0419','Members of Parliament and Members of European Parliament'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330422','06','Public infrastructure','33','Central and local Government','0422','Police Stations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330424','06','Public infrastructure','33','Central and local Government','0424','Prisons'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330425','06','Public infrastructure','33','Central and local Government','0425','Probation Offices and Police Support Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330426','06','Public infrastructure','33','Central and local Government','0426','Registrars Offices'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330429','06','Public infrastructure','33','Central and local Government','0429','Social Service Activities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330431','06','Public infrastructure','33','Central and local Government','0431','Tribunals'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06330830','06','Public infrastructure','33','Central and local Government','0830','Foreign Country Support Activities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340433','06','Public infrastructure','34','Infrastructure and facilities','0433','Electrical Features'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340435','06','Public infrastructure','34','Infrastructure and facilities','0435','Fire Safety Features'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340437','06','Public infrastructure','34','Infrastructure and facilities','0437','Gas Features'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340438','06','Public infrastructure','34','Infrastructure and facilities','0438','Meteorological Features'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340440','06','Public infrastructure','34','Infrastructure and facilities','0440','Refuse Disposal Facilities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340441','06','Public infrastructure','34','Infrastructure and facilities','0441','Waste Storage, Processing and Disposal'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340442','06','Public infrastructure','34','Infrastructure and facilities','0442','Telecommunications Companies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340443','06','Public infrastructure','34','Infrastructure and facilities','0443','Telecommunications Features'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340444','06','Public infrastructure','34','Infrastructure and facilities','0444','Utility Companies and Brokers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340453','06','Public infrastructure','34','Infrastructure and facilities','0453','Allotments'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340454','06','Public infrastructure','34','Infrastructure and facilities','0454','Cemeteries and Crematoria'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340455','06','Public infrastructure','34','Infrastructure and facilities','0455','Drinking Fountains and Water Points'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340456','06','Public infrastructure','34','Infrastructure and facilities','0456','Halls and Community Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340457','06','Public infrastructure','34','Infrastructure and facilities','0457','Letter Boxes'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340458','06','Public infrastructure','34','Infrastructure and facilities','0458','Libraries'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340459','06','Public infrastructure','34','Infrastructure and facilities','0459','Places of Worship'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340460','06','Public infrastructure','34','Infrastructure and facilities','0460','Public Telephones'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340461','06','Public infrastructure','34','Infrastructure and facilities','0461','Public Toilets'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340462','06','Public infrastructure','34','Infrastructure and facilities','0462','Recycling Centres'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06340802','06','Public infrastructure','34','Infrastructure and facilities','0802','WiFi Hotspots'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06350445','06','Public infrastructure','35','Organisations','0445','Animal Welfare Organisations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06350446','06','Public infrastructure','35','Organisations','0446','Fan Clubs and Associations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06350447','06','Public infrastructure','35','Organisations','0447','Sports Clubs and Associations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06350448','06','Public infrastructure','35','Organisations','0448','Institutes and Professional Organisations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06350449','06','Public infrastructure','35','Organisations','0449','Political Parties and Related Organisations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06350450','06','Public infrastructure','35','Organisations','0450','Religious Organisations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06350452','06','Public infrastructure','35','Organisations','0452','Youth Organisations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06350769','06','Public infrastructure','35','Organisations','0769','Community Networks and Projects'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06350816','06','Public infrastructure','35','Organisations','0816','Charitable Organisations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('06350817','06','Public infrastructure','35','Organisations','0817','Conservation Organisations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370464','07','Manufacturing and production','37','Consumer products','0464','Baby, Nursery and Playground Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370465','07','Manufacturing and production','37','Consumer products','0465','Beds and Bedding'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370466','07','Manufacturing and production','37','Consumer products','0466','Brushes'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370467','07','Manufacturing and production','37','Consumer products','0467','Candles'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370468','07','Manufacturing and production','37','Consumer products','0468','Canvas Goods'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370470','07','Manufacturing and production','37','Consumer products','0470','Carpets, Flooring, Rugs and Soft Furnishings'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370471','07','Manufacturing and production','37','Consumer products','0471','Medals, Trophies, Ceremonial and Religious Goods'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370472','07','Manufacturing and production','37','Consumer products','0472','China and Glassware'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370473','07','Manufacturing and production','37','Consumer products','0473','Clothing, Components and Accessories'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370474','07','Manufacturing and production','37','Consumer products','0474','Cookers and Stoves - Non Electrical'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370475','07','Manufacturing and production','37','Consumer products','0475','Cosmetics, Toiletries and Perfumes'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370476','07','Manufacturing and production','37','Consumer products','0476','Curtains and Blinds'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370477','07','Manufacturing and production','37','Consumer products','0477','Cutlery and Tableware'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370478','07','Manufacturing and production','37','Consumer products','0478','Disability and Mobility Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370479','07','Manufacturing and production','37','Consumer products','0479','Refrigeration and Freezing Appliances'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370480','07','Manufacturing and production','37','Consumer products','0480','Footwear'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370481','07','Manufacturing and production','37','Consumer products','0481','Furniture'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370482','07','Manufacturing and production','37','Consumer products','0482','Garden Goods'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370483','07','Manufacturing and production','37','Consumer products','0483','Giftware'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370485','07','Manufacturing and production','37','Consumer products','0485','Hobby, Sports and Pastime Products'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370486','07','Manufacturing and production','37','Consumer products','0486','Disposable Products'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370487','07','Manufacturing and production','37','Consumer products','0487','Jewellery, Gems, Clocks and Watches'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370488','07','Manufacturing and production','37','Consumer products','0488','Lampshades and Lighting'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370489','07','Manufacturing and production','37','Consumer products','0489','Leather Products'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370490','07','Manufacturing and production','37','Consumer products','0490','Lingerie and Hosiery'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370491','07','Manufacturing and production','37','Consumer products','0491','Luggage, Bags, Umbrellas and Travel Accessories'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370493','07','Manufacturing and production','37','Consumer products','0493','Musical Instruments'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370494','07','Manufacturing and production','37','Consumer products','0494','Photographic and Optical Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370495','07','Manufacturing and production','37','Consumer products','0495','Saunas and Sunbeds'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370497','07','Manufacturing and production','37','Consumer products','0497','Tents, Marquees and Camping Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370498','07','Manufacturing and production','37','Consumer products','0498','Tobacco Products'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370782','07','Manufacturing and production','37','Consumer products','0782','Fireplaces and Mantelpieces'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370785','07','Manufacturing and production','37','Consumer products','0785','Conservatories'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07370790','07','Manufacturing and production','37','Consumer products','0790','Bathroom Fixtures, Fittings and Sanitary Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07380500','07','Manufacturing and production','38','Extractive industries','0500','Coal Mining'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07380501','07','Manufacturing and production','38','Extractive industries','0501','Oil and Gas Extraction, Refinery and Product Manufacture'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07380502','07','Manufacturing and production','38','Extractive industries','0502','Ore Mining'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07380503','07','Manufacturing and production','38','Extractive industries','0503','Peat Extraction'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07380504','07','Manufacturing and production','38','Extractive industries','0504','Sand, Gravel and Clay Extraction and Merchants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07380506','07','Manufacturing and production','38','Extractive industries','0506','Stone Quarrying and Preparation'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07380507','07','Manufacturing and production','38','Extractive industries','0507','Unspecified Quarries or Mines'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390508','07','Manufacturing and production','39','Farming','0508','Animal Breeders (Not Horses)'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390509','07','Manufacturing and production','39','Farming','0509','Arable Farming'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390510','07','Manufacturing and production','39','Farming','0510','Bee Keepers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390511','07','Manufacturing and production','39','Farming','0511','Dairy Farming'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390512','07','Manufacturing and production','39','Farming','0512','Fish and Shellfish'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390513','07','Manufacturing and production','39','Farming','0513','Forestry'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390514','07','Manufacturing and production','39','Farming','0514','Fruit, Flower and Vegetable Growers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390515','07','Manufacturing and production','39','Farming','0515','Hoppers and Silos'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390516','07','Manufacturing and production','39','Farming','0516','Horse Breeders and Dealers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390517','07','Manufacturing and production','39','Farming','0517','Livestock Farming'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390518','07','Manufacturing and production','39','Farming','0518','Mixed or Unspecified Farming'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390520','07','Manufacturing and production','39','Farming','0520','Poultry Farming, Equipment and Supplies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07390521','07','Manufacturing and production','39','Farming','0521','Sheep Dips and Washes'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07400522','07','Manufacturing and production','40','Foodstuffs','0522','Alcoholic Drinks'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07400523','07','Manufacturing and production','40','Foodstuffs','0523','Animal Feeds, Pet Foods, Hay and Straw'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07400524','07','Manufacturing and production','40','Foodstuffs','0524','Baking and Confectionery'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07400525','07','Manufacturing and production','40','Foodstuffs','0525','Dairy Products'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07400526','07','Manufacturing and production','40','Foodstuffs','0526','Fish, Meat and Poultry Products'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07400528','07','Manufacturing and production','40','Foodstuffs','0528','Milling, Refining and Food Additives'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07400529','07','Manufacturing and production','40','Foodstuffs','0529','Non Alcoholic Drinks'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07400530','07','Manufacturing and production','40','Foodstuffs','0530','Catering and Non Specific Food Products'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07410531','07','Manufacturing and production','41','Industrial features','0531','Business Parks and Industrial Estates'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07410532','07','Manufacturing and production','41','Industrial features','0532','Chimneys'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07410533','07','Manufacturing and production','41','Industrial features','0533','Conveyors'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07410534','07','Manufacturing and production','41','Industrial features','0534','Energy Production'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07410535','07','Manufacturing and production','41','Industrial features','0535','Lighting Towers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07410536','07','Manufacturing and production','41','Industrial features','0536','Lime Kilns'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07410537','07','Manufacturing and production','41','Industrial features','0537','Oast Houses'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07410538','07','Manufacturing and production','41','Industrial features','0538','Pipelines'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07410539','07','Manufacturing and production','41','Industrial features','0539','Tanks (Generic)'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07410540','07','Manufacturing and production','41','Industrial features','0540','Travelling Cranes and Gantries'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07410542','07','Manufacturing and production','41','Industrial features','0542','Unspecified Works or Factories'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07410543','07','Manufacturing and production','41','Industrial features','0543','Water Pumping Stations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420544','07','Manufacturing and production','42','Industrial products','0544','Abrasive Products and Grinding Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420545','07','Manufacturing and production','42','Industrial products','0545','Adhesives and Sealants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420546','07','Manufacturing and production','42','Industrial products','0546','Aeroplanes'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420547','07','Manufacturing and production','42','Industrial products','0547','Agricultural Machinery and Goods'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420548','07','Manufacturing and production','42','Industrial products','0548','Air and Water Filtration'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420549','07','Manufacturing and production','42','Industrial products','0549','Arms and Ammunition'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420550','07','Manufacturing and production','42','Industrial products','0550','Bearing, Gear and Drive Elements'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420551','07','Manufacturing and production','42','Industrial products','0551','Beekeeping Supplies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420553','07','Manufacturing and production','42','Industrial products','0553','Bricks, Tiles, Clay and Ceramic Products'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420555','07','Manufacturing and production','42','Industrial products','0555','Cable, Wire and Fibre Optics'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420557','07','Manufacturing and production','42','Industrial products','0557','Colours, Chemicals and Water Softeners and Supplies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420558','07','Manufacturing and production','42','Industrial products','0558','Cleaning Equipment and Supplies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420562','07','Manufacturing and production','42','Industrial products','0562','Concrete Products'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420563','07','Manufacturing and production','42','Industrial products','0563','Cooling and Refrigeration'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420564','07','Manufacturing and production','42','Industrial products','0564','Electrical Components'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420565','07','Manufacturing and production','42','Industrial products','0565','Electrical Motors and Generators'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420566','07','Manufacturing and production','42','Industrial products','0566','Electrical Production and Manipulation Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420567','07','Manufacturing and production','42','Industrial products','0567','Electronic Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420568','07','Manufacturing and production','42','Industrial products','0568','Electronic Media'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420569','07','Manufacturing and production','42','Industrial products','0569','Engines'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420571','07','Manufacturing and production','42','Industrial products','0571','Fertilisers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420572','07','Manufacturing and production','42','Industrial products','0572','Food and Beverage Industry Machinery'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420573','07','Manufacturing and production','42','Industrial products','0573','General Construction Supplies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420574','07','Manufacturing and production','42','Industrial products','0574','General Purpose Machinery'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420575','07','Manufacturing and production','42','Industrial products','0575','Glass'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420576','07','Manufacturing and production','42','Industrial products','0576','Horticultural Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420577','07','Manufacturing and production','42','Industrial products','0577','Industrial Coatings and Finishings'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420579','07','Manufacturing and production','42','Industrial products','0579','Tools Including Machine Shops'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420580','07','Manufacturing and production','42','Industrial products','0580','Lifting and Handling Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420581','07','Manufacturing and production','42','Industrial products','0581','Lubricants and Lubricating Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420582','07','Manufacturing and production','42','Industrial products','0582','Marine Equipment Including Boats and Ships'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420583','07','Manufacturing and production','42','Industrial products','0583','Measurement and Inspection Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420584','07','Manufacturing and production','42','Industrial products','0584','Medical Equipment, Supplies and Pharmaceuticals'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420585','07','Manufacturing and production','42','Industrial products','0585','Metals Manufacturers, Fabricators and Stockholders'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420586','07','Manufacturing and production','42','Industrial products','0586','Moulds, Dies and Castings'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420588','07','Manufacturing and production','42','Industrial products','0588','Office and Shop Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420589','07','Manufacturing and production','42','Industrial products','0589','Ovens and Furnaces'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420590','07','Manufacturing and production','42','Industrial products','0590','Packaging'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420591','07','Manufacturing and production','42','Industrial products','0591','Paints, Varnishes and Lacquers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420594','07','Manufacturing and production','42','Industrial products','0594','Pesticides'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420598','07','Manufacturing and production','42','Industrial products','0598','Printing Related Machinery'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420599','07','Manufacturing and production','42','Industrial products','0599','Published Goods'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420600','07','Manufacturing and production','42','Industrial products','0600','Pumps and Compressors'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420601','07','Manufacturing and production','42','Industrial products','0601','Radar and Telecommunications Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420602','07','Manufacturing and production','42','Industrial products','0602','Road Maintenance Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420603','07','Manufacturing and production','42','Industrial products','0603','Ropes, Nets and Cordage'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420604','07','Manufacturing and production','42','Industrial products','0604','Rubber, Silicones and Plastics'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420605','07','Manufacturing and production','42','Industrial products','0605','Seals, Tapes, Taps and Valves'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420606','07','Manufacturing and production','42','Industrial products','0606','Signs'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420607','07','Manufacturing and production','42','Industrial products','0607','Special Purpose Machinery and Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420608','07','Manufacturing and production','42','Industrial products','0608','Textiles, Fabrics, Silk and Machinery'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420609','07','Manufacturing and production','42','Industrial products','0609','Stationery, Stamps, Tags and Labels'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420612','07','Manufacturing and production','42','Industrial products','0612','General Manufacturing'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420613','07','Manufacturing and production','42','Industrial products','0613','Vehicle Bodybuilders'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420614','07','Manufacturing and production','42','Industrial products','0614','Vehicle Components'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420615','07','Manufacturing and production','42','Industrial products','0615','Vehicles'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420616','07','Manufacturing and production','42','Industrial products','0616','Wood Products Including Charcoal, Paper, Card and Board'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420617','07','Manufacturing and production','42','Industrial products','0617','Workwear'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420765','07','Manufacturing and production','42','Industrial products','0765','Educational Equipment and Supplies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420767','07','Manufacturing and production','42','Industrial products','0767','Ice'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420781','07','Manufacturing and production','42','Industrial products','0781','Fences, Gates and Railings'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420783','07','Manufacturing and production','42','Industrial products','0783','Access Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420784','07','Manufacturing and production','42','Industrial products','0784','Car Ports and Steel Buildings'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420787','07','Manufacturing and production','42','Industrial products','0787','Waste Collection, Processing and Disposal Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420788','07','Manufacturing and production','42','Industrial products','0788','Glass Fibre Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('07420791','07','Manufacturing and production','42','Industrial products','0791','Shelving, Storage, Safes and Vaults'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09460656','09','Retail','46','Clothing and accessories','0656','Clothing'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09460657','09','Retail','46','Clothing and accessories','0657','Footwear'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09460659','09','Retail','46','Clothing and accessories','0659','Jewellery and Fashion Accessories'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09460660','09','Retail','46','Clothing and accessories','0660','Lingerie and Hosiery'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09460797','09','Retail','46','Clothing and accessories','0797','Baby and Nursery Equipment and Children''s Clothes'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470661','09','Retail','47','Food, drink and multi item retail','0661','Bakeries'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470662','09','Retail','47','Food, drink and multi item retail','0662','Butchers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470663','09','Retail','47','Food, drink and multi item retail','0663','Confectioners'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470665','09','Retail','47','Food, drink and multi item retail','0665','Delicatessens'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470666','09','Retail','47','Food, drink and multi item retail','0666','Fishmongers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470667','09','Retail','47','Food, drink and multi item retail','0667','Frozen Foods'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470668','09','Retail','47','Food, drink and multi item retail','0668','Green and New Age Goods'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470669','09','Retail','47','Food, drink and multi item retail','0669','Grocers, Farm Shops and Pick Your Own'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470670','09','Retail','47','Food, drink and multi item retail','0670','Herbs and Spices'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470671','09','Retail','47','Food, drink and multi item retail','0671','Alcoholic Drinks Including Off Licences and Wholesalers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470672','09','Retail','47','Food, drink and multi item retail','0672','Organic, Health, Gourmet and Kosher Foods'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470699','09','Retail','47','Food, drink and multi item retail','0699','Convenience Stores and Independent Supermarkets'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470703','09','Retail','47','Food, drink and multi item retail','0703','Livestock Markets'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470705','09','Retail','47','Food, drink and multi item retail','0705','Markets'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470768','09','Retail','47','Food, drink and multi item retail','0768','Cash and Carry'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470798','09','Retail','47','Food, drink and multi item retail','0798','Tea and Coffee Merchants'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09470819','09','Retail','47','Food, drink and multi item retail','0819','Supermarket Chains'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480674','09','Retail','48','Household, office, leisure and garden','0674','Books and Maps'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480675','09','Retail','48','Household, office, leisure and garden','0675','Carpets, Rugs, Soft Furnishings and Needlecraft'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480676','09','Retail','48','Household, office, leisure and garden','0676','China and Glassware'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480677','09','Retail','48','Household, office, leisure and garden','0677','Cosmetics, Toiletries, Perfumes and Hairdressing Supplies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480678','09','Retail','48','Household, office, leisure and garden','0678','Craft Supplies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480679','09','Retail','48','Household, office, leisure and garden','0679','Cycles and Accessories'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480680','09','Retail','48','Household, office, leisure and garden','0680','DIY and Home Improvement'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480682','09','Retail','48','Household, office, leisure and garden','0682','Furniture'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480683','09','Retail','48','Household, office, leisure and garden','0683','Garden Centres and Nurseries'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480684','09','Retail','48','Household, office, leisure and garden','0684','Garden Machinery and Furniture'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480685','09','Retail','48','Household, office, leisure and garden','0685','General Household Goods'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480686','09','Retail','48','Household, office, leisure and garden','0686','Hobby, Sports and Pastime Products'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480687','09','Retail','48','Household, office, leisure and garden','0687','Leather Goods, Luggage and Travel Accessories Including Handbags'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480688','09','Retail','48','Household, office, leisure and garden','0688','Lighting'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480689','09','Retail','48','Household, office, leisure and garden','0689','Music and Video'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480690','09','Retail','48','Household, office, leisure and garden','0690','Musical Instruments'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480691','09','Retail','48','Household, office, leisure and garden','0691','Pets, Supplies and Services'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480693','09','Retail','48','Household, office, leisure and garden','0693','Camping and Caravanning'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480694','09','Retail','48','Household, office, leisure and garden','0694','Travel Agencies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480700','09','Retail','48','Household, office, leisure and garden','0700','Department Stores'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480701','09','Retail','48','Household, office, leisure and garden','0701','Discount Stores'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480704','09','Retail','48','Household, office, leisure and garden','0704','Mail Order and Catalogue Stores'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480708','09','Retail','48','Household, office, leisure and garden','0708','Shopping Centres and Retail Parks'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480710','09','Retail','48','Household, office, leisure and garden','0710','Surplus Goods'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480712','09','Retail','48','Household, office, leisure and garden','0712','Art and Antiques'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480714','09','Retail','48','Household, office, leisure and garden','0714','Charity Shops'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480716','09','Retail','48','Household, office, leisure and garden','0716','Florists'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480717','09','Retail','48','Household, office, leisure and garden','0717','Gifts and Cards'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480718','09','Retail','48','Household, office, leisure and garden','0718','Party Goods and Novelties'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480719','09','Retail','48','Household, office, leisure and garden','0719','Secondhand Goods'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480720','09','Retail','48','Household, office, leisure and garden','0720','Computer Supplies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480721','09','Retail','48','Household, office, leisure and garden','0721','Domestic Appliances'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480722','09','Retail','48','Household, office, leisure and garden','0722','Electrical Goods and Components'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480724','09','Retail','48','Household, office, leisure and garden','0724','Photographic and Optical Equipment'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480725','09','Retail','48','Household, office, leisure and garden','0725','Stationery and Office Supplies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480726','09','Retail','48','Household, office, leisure and garden','0726','Telephones and Telephone Cards'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480763','09','Retail','48','Household, office, leisure and garden','0763','Post Offices'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480764','09','Retail','48','Household, office, leisure and garden','0764','Garages, Garden and Portable Buildings'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480766','09','Retail','48','Household, office, leisure and garden','0766','Fuel Distributors and Suppliers'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480824','09','Retail','48','Household, office, leisure and garden','0824','Adult Shops'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480827','09','Retail','48','Household, office, leisure and garden','0827','Comics Bookshops'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480828','09','Retail','48','Household, office, leisure and garden','0828','Computer Shops'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09480831','09','Retail','48','Household, office, leisure and garden','0831','Potteries'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09490695','09','Retail','49','Motoring','0695','New Vehicles'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09490696','09','Retail','49','Motoring','0696','Secondhand Vehicles'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09490697','09','Retail','49','Motoring','0697','Vehicle Auctions'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('09490698','09','Retail','49','Motoring','0698','Vehicle Parts and Accessories'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10530727','10','Transport','53','Air','0727','Aeronautical Features'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10530728','10','Transport','53','Air','0728','Airports and Landing Strips'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10530729','10','Transport','53','Air','0729','Helipads'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10540730','10','Transport','54','Road and rail','0730','Bridges'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10540733','10','Transport','54','Road and rail','0733','Cattle Grids'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10540734','10','Transport','54','Road and rail','0734','Fords and Level Crossings'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10540735','10','Transport','54','Road and rail','0735','Motorway Service Stations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10540736','10','Transport','54','Road and rail','0736','Parking'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10540737','10','Transport','54','Road and rail','0737','Petrol and Fuel Stations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10540739','10','Transport','54','Road and rail','0739','Roadside Telephone Boxes'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10540740','10','Transport','54','Road and rail','0740','Signalling Facilities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10540742','10','Transport','54','Road and rail','0742','Tunnels'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10540743','10','Transport','54','Road and rail','0743','Viaducts'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10540744','10','Transport','54','Road and rail','0744','Weighbridges'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10550746','10','Transport','55','Walking','0746','Finger Posts, Guide Posts and Cairns'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10550747','10','Transport','55','Walking','0747','Footbridges'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10550749','10','Transport','55','Walking','0749','Stepping Stones'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10550750','10','Transport','55','Walking','0750','Subways'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10560751','10','Transport','56','Water','0751','Aqueducts'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10560752','10','Transport','56','Water','0752','Locks'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10560753','10','Transport','56','Water','0753','Moorings and Unloading Facilities'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10560754','10','Transport','56','Water','0754','Rivers and Canal Organisations and Infrastructure'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10560755','10','Transport','56','Water','0755','Weirs, Sluices and Dams'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10560760','10','Transport','56','Water','0760','Ferries and Ferry Terminals'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10570731','10','Transport','57','Public transport, stations and infrastructure','0731','Bus and Coach Stations, Depots and Companies'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10570738','10','Transport','57','Public transport, stations and infrastructure','0738','Railway Stations, Junctions and Halts'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10570756','10','Transport','57','Public transport, stations and infrastructure','0756','Tram, Metro and Light Railway Stations and Stops'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10570758','10','Transport','57','Public transport, stations and infrastructure','0758','Taxi Ranks'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10570761','10','Transport','57','Public transport, stations and infrastructure','0761','Underground Network Stations'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10570794','10','Transport','57','Public transport, stations and infrastructure','0794','London Underground Entrances'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10590732','10','Transport','59','Bus transport','0732','Bus Stops'); | |
INSERT INTO poi.classifications(CLASSIFCATION_CODE,GROUP_ID,GROUP_DESCRIPTION,CATEGORY_ID,CATEGORY_DESCRIPTION,CLASS_CODE,CLASS_DESCRIPTION) VALUES ('10590759','10','Transport','59','Bus transport','0759','Hail and Ride Zones'); | |
COMMIT; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment