CREATE TABLE newarea(
citycode VARCHAR(200),
cityname VARCHAR(200),
pidcode VARCHAR(200),
simplename VARCHAR(200),
citylevel INT(4),
areacode VARCHAR(200),
postcode VARCHAR(200),
py VARCHAR(200),
Longitude DECIMAL(16,12),
Latitude DECIMAL(16,12)
)ENGINE = INNODB DEFAULT CHARSET =utf8;
INSERT INTO newarea(citycode,cityname,pidcode,simplename,citylevel,areacode,postcode,py)VALUES
('110000','北京','100000','北京','1','','','Beijing'),
('110100','北京市','110000','北京','2','010','100000','Beijing'),
('110101','东城区','110100','东城','3','010','100010','Dongcheng'),
('110102','西城区','110100','西城','3','010','100032','Xicheng'),
('110105','朝阳区','110100','朝阳','3','010','100020','Chaoyang'),
('110106','丰台区','110100','丰台','3','010','100071','Fengtai'),
('110107','石景山区','110100','石景山','3','010','100043','Shijingshan'),
('110108','海淀区','110100','海淀','3','010','100089','Haidian'),
('110109','门头沟区','110100','门头沟','3','010','102300','Mentougou'),
('110111','房山区','110100','房山','3','010','102488','Fangshan'),
('110112','通州区','110100','通州','3','010','101149','Tongzhou'),
('110113','顺义区','110100','顺义','3','010','101300','Shunyi'),
('110114','昌平区','110100','昌平','3','010','102200','Changping'),
('110115','大兴区','110100','大兴','3','010','102600','Daxing'),
('110116','怀柔区','110100','怀柔','3','010','101400','Huairou'),
('110117','平谷区','110100','平谷','3','010','101200','Pinggu'),
('110228','密云县','110100','密云','3','010','101500','Miyun'),
('110229','延庆县','110100','延庆','3','010','102100','Yanqing'),
('120000','天津','100000','天津','1','','','Tianjin'),
('120100','天津市','120000','天津','2','022','300000','Tianjin'),
('120101','和平区','120100','和平','3','022','300041','Heping'),
('120102','河东区','120100','河东','3','022','300171','Hedong'),
('120103','河西区','120100','河西','3','022','300202','Hexi'),
('120104','南开区','120100','南开','3','022','300110','Nankai'),
('120105','河北区','120100','河北','3','022','300143','Hebei'),
('120106','红桥区','120100','红桥','3','022','300131','Hongqiao'),
('120110','东丽区','120100','东丽','3','022','300300','Dongli'),
('120111','西青区','120100','西青','3','022','300380','Xiqing'),
('120112','津南区','120100','津南','3','022','300350','Jinnan'),
('120113','北辰区','120100','北辰','3','022','300400','Beichen'),
('120114','武清区','120100','武清','3','022','301700','Wuqing'),
('120115','宝坻区','120100','宝坻','3','022','301800','Baodi'),
('120116','滨海新区','120100','滨海新区','3','022','300451','Binhaixinqu'),
('120221','宁河县','120100','宁河','3','022','301500','Ninghe'),
('120223','静海县','120100','静海','3','022','301600','Jinghai'),
('120225','蓟县','120100','蓟县','3','022','301900','Jixian'),
('130000','河北省','100000','河北','1','','','Hebei'),
('130100','石家庄市','130000','石家庄','2','0311','050011','Shijiazhuang'),
('130102','长安区','130100','长安','3','0311','050011','Changan'),
('130104','桥西区','130100','桥西','3','0311','050091','Qiaoxi'),
('130105','新华区','130100','新华','3','0311','050051','Xinhua'),
('130107','井陉矿区','130100','井陉矿区','3','0311','050100','Jingxingkuangqu'),
('130108','裕华区','130100','裕华','3','0311','050031','Yuhua'),
('130109','藁城区','130100','藁城','3','0311','052160','Gaocheng'),
('130110','鹿泉区','130100','鹿泉','3','0311','050200','Luquan'),
('130111','栾城区','130100','栾城','3','0311','051430','Luancheng'),
('130121','井陉县','130100','井陉','3','0311','050300','Jingxing'),
('130123','正定县','130100','正定','3','0311','050800','Zhengding'),
('130125','行唐县','130100','行唐','3','0311','050600','Xingtang'),
('130126','灵寿县','130100','灵寿','3','0311','050500','Lingshou'),
('130127','高邑县','130100','高邑','3','0311','051330','Gaoyi'),
('130128','深泽县','130100','深泽','3','0311','052560','Shenze'),
('130129','赞皇县','130100','赞皇','3','0311','051230','Zanhuang'),
('130130','无极县','130100','无极','3','0311','052460','Wuji'),
('130131','平山县','130100','平山','3','0311','050400','Pingshan'),
('130132','元氏县','130100','元氏','3','0311','051130','Yuanshi'),
('130133','赵县','130100','赵县','3','0311','051530','Zhaoxian'),
('130181','辛集市','130100','辛集','3','0311','052360','Xinji'),
('130183','晋州市','130100','晋州','3','0311','052260','Jinzhou'),
('130184','新乐市','130100','新乐','3','0311','050700','Xinle'),
('130200','唐山市','130000','唐山','2','0315','063000','Tangshan'),
('130202','路南区','130200','路南','3','0315','063000','Lunan'),
('130203','路北区','130200','路北','3','0315','063000','Lubei'),
('130204','古冶区','130200','古冶','3','0315','063100','Guye'),
('130205','开平区','130200','开平','3','0315','063021','Kaiping'),
('130207','丰南区','130200','丰南','3','0315','063300','Fengnan'),
('130208','丰润区','130200','丰润','3','0315','064000','Fengrun'),
('130209','曹妃甸区','130200','曹妃甸','3','0315','063200','Caofeidian'),
('130223','滦县','130200','滦县','3','0315','063700','Luanxian'),
('130224','滦南县','130200','滦南','3','0315','063500','Luannan'),
('130225','乐亭县','130200','乐亭','3','0315','063600','Laoting'),
('130227','迁西县','130200','迁西','3','0315','064300','Qianxi'),
('130229','玉田县','130200','玉田','3','0315','064100','Yutian'),
('130281','遵化市','130200','遵化','3','0315','064200','Zunhua'),
('130283','迁安市','130200','迁安','3','0315','064400','Qianan'),
('130300','秦皇岛市','130000','秦皇岛','2','0335','066000','Qinhuangdao'),
('130302','海港区','130300','海港','3','0335','066000','Haigang'),
('130303','山海关区','130300','山海关','3','0335','066200','Shanhaiguan'),
('130304','北戴河区','130300','北戴河','3','0335','066100','Beidaihe'),
('130321','青龙满族自治县','130300','青龙','3','0335','066500','Qinglong'),
('130322','昌黎县','130300','昌黎','3','0335','066600','Changli'),
('130323','抚宁县','130300','抚宁','3','0335','066300','Funing'),
('130324','卢龙县','130300','卢龙','3','0335','066400','Lulong'),
('130400','邯郸市','130000','邯郸','2','0310','056002','Handan'),
('130402','邯山区','130400','邯山','3','0310','056001','Hanshan'),
('130403','丛台区','130400','丛台','3','0310','056002','Congtai'),
('130404','复兴区','130400','复兴','3','0310','056003','Fuxing'),
('130406','峰峰矿区','130400','峰峰矿区','3','0310','056200','Fengfengkuangqu'),
('130421','邯郸县','130400','邯郸','3','0310','056101','Handan'),
('130423','临漳县','130400','临漳','3','0310','056600','Linzhang'),
('130424','成安县','130400','成安','3','0310','056700','Chengan'),
('130425','大名县','130400','大名','3','0310','056900','Daming'),
('130426','涉县','130400','涉县','3','0310','056400','Shexian'),
('130427','磁县','130400','磁县','3','0310','056500','Cixian'),
('130428','肥乡县','130400','肥乡','3','0310','057550','Feixiang'),
('130429','永年县','130400','永年','3','0310','057150','Yongnian'),
('130430','邱县','130400','邱县','3','0310','057450','Qiuxian'),
('130431','鸡泽县','130400','鸡泽','3','0310','057350','Jize'),
('130432','广平县','130400','广平','3','0310','057650','Guangping'),
('130433','馆陶县','130400','馆陶','3','0310','057750','Guantao'),
('130434','魏县','130400','魏县','3','0310','056800','Weixian'),
('130435','曲周县','130400','曲周','3','0310','057250','Quzhou'),
('130481','武安市','130400','武安','3','0310','056300','Wuan'),
('130500','邢台市','130000','邢台','2','0319','054001','Xingtai'),
('130502','桥东区','130500','桥东','3','0319','054001','Qiaodong'),
('130503','桥西区','130500','桥西','3','0319','054000','Qiaoxi'),
('130521','邢台县','130500','邢台','3','0319','054001','Xingtai'),
('130522','临城县','130500','临城','3','0319','054300','Lincheng'),
('130523','内丘县','130500','内丘','3','0319','054200','Neiqiu'),
('130524','柏乡县','130500','柏乡','3','0319','055450','Baixiang'),
('130525','隆尧县','130500','隆尧','3','0319','055350','Longyao'),
('130526','任县','130500','任县','3','0319','055150','Renxian'),
('130527'