create table HAT_AREA(
ID INTEGER not null,
AREAID VARCHAR2(50),
AREA VARCHAR2(60),
FATHER VARCHAR2(6)
)
INSERT INTO hat_area VALUES (1,'110101','东城区','110100');
INSERT INTO hat_area VALUES (2,'110102','西城区','110100');
INSERT INTO hat_area VALUES (3,'110103','崇文区','110100');
INSERT INTO hat_area VALUES (4,'110104','宣武区','110100');
INSERT INTO hat_area VALUES (5,'110105','朝阳区','110100');
INSERT INTO hat_area VALUES (6,'110106','丰台区','110100');
INSERT INTO hat_area VALUES (7,'110107','石景山区','110100');
INSERT INTO hat_area VALUES (8,'110108','海淀区','110100');
INSERT INTO hat_area VALUES (9,'110109','门头沟区','110100');
INSERT INTO hat_area VALUES (10,'110111','房山区','110100');
INSERT INTO hat_area VALUES (11,'110112','通州区','110100');
INSERT INTO hat_area VALUES (12,'110113','顺义区','110100');
INSERT INTO hat_area VALUES (13,'110114','昌平区','110100');
INSERT INTO hat_area VALUES (14,'110115','大兴区','110100');
INSERT INTO hat_area VALUES (15,'110116','怀柔区','110100');
INSERT INTO hat_area VALUES (16,'110117','平谷区','110100');
INSERT INTO hat_area VALUES (17,'110228','密云县','110200');
INSERT INTO hat_area VALUES (18,'110229','延庆县','110200');
INSERT INTO hat_area VALUES (19,'120101','和平区','120100');
INSERT INTO hat_area VALUES (20,'120102','河东区','120100');
INSERT INTO hat_area VALUES (21,'120103','河西区','120100');
INSERT INTO hat_area VALUES (22,'120104','南开区','120100');
INSERT INTO hat_area VALUES (23,'120105','河北区','120100');
INSERT INTO hat_area VALUES (24,'120106','红桥区','120100');
INSERT INTO hat_area VALUES (25,'120107','塘沽区','120100');
INSERT INTO hat_area VALUES (26,'120108','汉沽区','120100');
INSERT INTO hat_area VALUES (27,'120109','大港区','120100');
INSERT INTO hat_area VALUES (28,'120110','东丽区','120100');
INSERT INTO hat_area VALUES (29,'120111','西青区','120100');
INSERT INTO hat_area VALUES (30,'120112','津南区','120100');
INSERT INTO hat_area VALUES (31,'120113','北辰区','120100');
INSERT INTO hat_area VALUES (32,'120114','武清区','120100');
INSERT INTO hat_area VALUES (33,'120115','宝坻区','120100');
INSERT INTO hat_area VALUES (34,'120221','宁河县','120200');
INSERT INTO hat_area VALUES (35,'120223','静海县','120200');
INSERT INTO hat_area VALUES (36,'120225','蓟 县','120200');
INSERT INTO hat_area VALUES (37,'130101','市辖区','130100');
INSERT INTO hat_area VALUES (38,'130102','长安区','130100');
INSERT INTO hat_area VALUES (39,'130103','桥东区','130100');
INSERT INTO hat_area VALUES (40,'130104','桥西区','130100');
INSERT INTO hat_area VALUES (41,'130105','新华区','130100');
INSERT INTO hat_area VALUES (42,'130107','井陉矿区','130100');
INSERT INTO hat_area VALUES (43,'130108','裕华区','130100');
INSERT INTO hat_area VALUES (44,'130121','井陉县','130100');
INSERT INTO hat_area VALUES (45,'130123','正定县','130100');
INSERT INTO hat_area VALUES (46,'130124','栾城县','130100');
INSERT INTO hat_area VALUES (47,'130125','行唐县','130100');
INSERT INTO hat_area VALUES (48,'130126','灵寿县','130100');
INSERT INTO hat_area VALUES (49,'130127','高邑县','130100');
INSERT INTO hat_area VALUES (50,'130128','深泽县','130100');
INSERT INTO hat_area VALUES (51,'130129','赞皇县','130100');
INSERT INTO hat_area VALUES (52,'130130','无极县','130100');
INSERT INTO hat_area VALUES (53,'130131','平山县','130100');
INSERT INTO hat_area VALUES (54,'130132','元氏县','130100');
INSERT INTO hat_area VALUES (55,'130133','赵 县','130100');
INSERT INTO hat_area VALUES (56,'130181','辛集市','130100');
INSERT INTO hat_area VALUES (57,'130182','藁城市','130100');
INSERT INTO hat_area VALUES (58,'130183','晋州市','130100');
INSERT INTO hat_area VALUES (59,'130184','新乐市','130100');
INSERT INTO hat_area VALUES (60,'130185','鹿泉市','130100');
INSERT INTO hat_area VALUES (61,'130201','市辖区','130200');
INSERT INTO hat_area VALUES (62,'130202','路南区','130200');
INSERT INTO hat_area VALUES (63,'130203','路北区','130200');
INSERT INTO hat_area VALUES (64,'130204','古冶区','130200');
INSERT INTO hat_area VALUES (65,'130205','开平区','130200');
INSERT INTO hat_area VALUES (66,'130207','丰南区','130200');
INSERT INTO hat_area VALUES (67,'130208','丰润区','130200');
INSERT INTO hat_area VALUES (68,'130223','滦 县','130200');
INSERT INTO hat_area VALUES (69,'130224','滦南县','130200');
INSERT INTO hat_area VALUES (70,'130225','乐亭县','130200');
INSERT INTO hat_area VALUES (71,'130227','迁西县','130200');
INSERT INTO hat_area VALUES (72,'130229','玉田县','130200');
INSERT INTO hat_area VALUES (73,'130230','唐海县','130200');
INSERT INTO hat_area VALUES (74,'130281','遵化市','130200');
INSERT INTO hat_area VALUES (75,'130283','迁安市','130200');
INSERT INTO hat_area VALUES (76,'130301','市辖区','130300');
INSERT INTO hat_area VALUES (77,'130302','海港区','130300');
INSERT INTO hat_area VALUES (78,'130303','山海关区','130300');
INSERT INTO hat_area VALUES (79,'130304','北戴河区','130300');
INSERT INTO hat_area VALUES (80,'130321','青龙满族自治县','130300');
INSERT INTO hat_area VALUES (81,'130322','昌黎县','130300');
INSERT INTO hat_area VALUES (82,'130323','抚宁县','130300');
INSERT INTO hat_area VALUES (83,'130324','卢龙县','130300');
INSERT INTO hat_area VALUES (84,'130401','市辖区','130400');
INSERT INTO hat_area VALUES (85,'130402','邯山区','130400');
INSERT INTO hat_area VALUES (86,'130403','丛台区','130400');
INSERT INTO hat_area VALUES (87,'130404','复兴区','130400');
INSERT INTO hat_area VALUES (88,'130406','峰峰矿区','130400');
INSERT INTO hat_area VALUES (89,'130421','邯郸县','130400');
INSERT INTO hat_area VALUES (90,'130423','临漳县','130400');
INSERT INTO hat_area VALUES (91,'130424','成安县','130400');
INSERT INTO hat_area VALUES (92,'130425','大名县','130400');
INSERT INTO hat_area VALUES (93,'130426','涉 县','130400');
INSERT INTO hat_area VALUES (94,'130427','磁 县','130400');
INSERT INTO hat_area VALUES (95,'130428','肥乡县','130400');
INSERT INTO hat_area VALUES (96,'130429','永年县','130400');
INSERT INTO hat_area VALUES (97,'130430','邱 县','130400');
INSERT INTO hat_area VALUES (98,'130431','鸡泽县','130400');
INSERT INTO hat_area VALUES (99,'130432','广平县','130400');
INSERT INTO hat_area VALUES (100,'130433','馆陶县','130400');
INSERT INTO hat_area VALUES (101,'130434','魏 县','130400');
INSERT INTO hat_area VALUES (102,'130435','曲周县','130400');
INSERT INTO hat_area VALUES (103,'130481','武安市','130400');
INSERT INTO hat_area VALUES (104,'130501','市辖区','130500');
INSERT INTO hat_area VALUES (105,'130502','桥东区','130500');
INSERT INTO hat_area VALUES (106,'130503','桥西区','130500');
INSERT INTO hat_area VALUES (107,'130521','邢台县','130500');
INSERT INTO hat_area VALUES (108,'130522','临城县','130500');
INSERT INTO hat_area VALUES (109,'130523','内丘县','130500');
INSERT INTO hat_area VALUES (110,'130524','柏乡县','130500');
INSERT INTO hat_area VALUES (111,'130525','隆尧县','130500');
INSERT INTO hat_area VALUES (112,'130526','任 县','130500');
INSERT INTO hat_area VALUES (113,'130527','南和县','130500');
INSERT INTO hat_area VALUES (114,'130528','宁晋县','130500');
INSERT INTO hat_area VALUES (115,'130529','巨鹿县','130500');
INSERT INTO hat_area VALUES (116,'130530','新河县','130500');
INSERT INTO hat_area VALUES (117,'130531','广宗县','130500');
INSERT INTO hat_area VALUES (118,'130532','平乡县','130500');
INSERT INTO hat_area VALUES (119,'130533','威 县','130500');
INSERT INTO hat_area VALUES (120,'130534','清河县','130500');
INSERT INTO ha
