全国省市数据.txt

ajax地区选择列表

INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110000,'北京市','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110100,'市辖区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110101,'东城区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110102,'西城区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110103,'崇文区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110104,'宣武区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110105,'朝阳区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110106,'丰台区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110107,'石景山区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110108,'海淀区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110109,'门头沟区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110111,'房山区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110112,'通州区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110113,'顺义区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110114,'昌平区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110115,'大兴区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110116,'怀柔区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110117,'平谷区','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110200,'县','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110228,'密云县','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (110229,'延庆县','010')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120000,'天津市','022')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120100,'市辖区','022')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120101,'和平区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120102,'河东区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120103,'河西区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120104,'南开区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120105,'河北区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120106,'红桥区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120107,'塘沽区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120108,'汉沽区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120109,'大港区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120110,'东丽区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120111,'西青区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120112,'津南区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120113,'北辰区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120114,'武清区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120115,'宝坻区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120200,'县','022')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120221,'宁河县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120223,'静海县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (120225,'蓟　县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130000,'河北省',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130100,'石家庄市','311')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130101,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130102,'长安区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130103,'桥东区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130104,'桥西区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130105,'新华区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130107,'井陉矿区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130108,'裕华区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130121,'井陉县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130123,'正定县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130124,'栾城县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130125,'行唐县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130126,'灵寿县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130127,'高邑县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130128,'深泽县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130129,'赞皇县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130130,'无极县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130131,'平山县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130132,'元氏县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130133,'赵　县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130181,'辛集市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130182,'藁城市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130183,'晋州市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130184,'新乐市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130185,'鹿泉市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130200,'唐山市','315')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130201,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130202,'路南区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130203,'路北区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130204,'古冶区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130205,'开平区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130207,'丰南区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130208,'丰润区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130223,'滦　县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130224,'滦南县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130225,'乐亭县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130227,'迁西县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130229,'玉田县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130230,'唐海县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130281,'遵化市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130283,'迁安市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130300,'秦皇岛市','335')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130301,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130302,'海港区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130303,'山海关区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130304,'北戴河区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130321,'青龙满族自治县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130322,'昌黎县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130323,'抚宁县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130324,'卢龙县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130400,'邯郸市','310')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130401,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130402,'邯山区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130403,'丛台区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130404,'复兴区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130406,'峰峰矿区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130421,'邯郸县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130423,'临漳县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130424,'成安县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130425,'大名县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130426,'涉　县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130427,'磁　县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130428,'肥乡县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130429,'永年县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130430,'邱　县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130431,'鸡泽县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130432,'广平县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130433,'馆陶县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130434,'魏　县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130435,'曲周县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130481,'武安市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130500,'邢台市','319')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130501,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130502,'桥东区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130503,'桥西区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130521,'邢台县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130522,'临城县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130523,'内丘县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130524,'柏乡县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130525,'隆尧县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130526,'任　县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130527,'南和县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130528,'宁晋县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130529,'巨鹿县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130530,'新河县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130531,'广宗县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130532,'平乡县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130533,'威　县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130534,'清河县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130535,'临西县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130581,'南宫市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130582,'沙河市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130600,'保定市','312')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130601,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130602,'新市区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130603,'北市区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130604,'南市区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130621,'满城县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130622,'清苑县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130623,'涞水县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130624,'阜平县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130625,'徐水县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130626,'定兴县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (130627,'唐　县',NULL)