/*
SQLyog Ultimate v12.3.1 (64 bit)
MySQL - 5.6.32-log : Database - openzufang
*********************************************************************
*/




CREATE DATABASE /*!32312 IF NOT EXISTS*/`openzufang` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;

USE `openzufang`;

/*Table structure for table `areas` */


CREATE TABLE `areas` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cityCode` varchar(50) DEFAULT NULL COMMENT '市代码',
  `areasName` varchar(100) DEFAULT NULL COMMENT '区县名称',
  `areasCode` varchar(50) DEFAULT NULL COMMENT '区县代码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='区县';

/*Data for the table `areas` */
INSERT INTO `areas` VALUES (1,'110100','东城区','110101'),(2,'110100','西城区','110102'),(3,'110100','崇文区','110103'),(4,'110100','宣武区','110104'),(5,'110100','朝阳区','110105'),(6,'110100','丰台区','110106'),(7,'110100','石景山区','110107'),(8,'110100','海淀区','110108'),(9,'110100','门头沟区','110109'),(10,'110100','房山区','110111'),(11,'110100','通州区','110112'),(12,'110100','顺义区','110113'),(13,'110100','昌平区','110114'),(14,'110100','大兴区','110115'),(15,'110100','怀柔区','110116'),(16,'110100','平谷区','110117'),(17,'110100','密云县','110228'),(18,'110100','延庆县','110229'),(19,'120100','和平区','120101'),(20,'120100','河东区','120102'),(21,'120100','河西区','120103'),(22,'120100','南开区','120104'),(23,'120100','河北区','120105'),(24,'120100','红桥区','120106'),(25,'120100','塘沽区','120107'),(26,'120100','汉沽区','120108'),(27,'120100','大港区','120109'),(28,'120100','东丽区','120110'),(29,'120100','西青区','120111'),(30,'120100','津南区','120112'),(31,'120100','北辰区','120113'),(32,'120100','武清区','120114'),(33,'120100','宝坻区','120115'),(34,'120100','宁河县','120221'),(35,'120100','静海县','120223'),(36,'120100','蓟　县','120225'),(38,'130100','长安区','130102'),(39,'130100','桥东区','130103'),(40,'130100','桥西区','130104'),(41,'130100','新华区','130105'),(42,'130100','井陉矿区','130107'),(43,'130100','裕华区','130108'),(44,'130100','井陉县','130121'),(45,'130100','正定县','130123'),(46,'130100','栾城县','130124'),(47,'130100','行唐县','130125'),(48,'130100','灵寿县','130126'),(49,'130100','高邑县','130127'),(50,'130100','深泽县','130128'),(51,'130100','赞皇县','130129'),(52,'130100','无极县','130130'),(53,'130100','平山县','130131'),(54,'130100','元氏县','130132'),(55,'130100','赵　县','130133'),(56,'130100','辛集市','130181'),(57,'130100','藁城市','130182'),(58,'130100','晋州市','130183'),(59,'130100','新乐市','130184'),(60,'130100','鹿泉市','130185'),(62,'130200','路南区','130202'),(63,'130200','路北区','130203'),(64,'130200','古冶区','130204'),(65,'130200','开平区','130205'),(66,'130200','丰南区','130207'),(67,'130200','丰润区','130208'),(68,'130200','滦　县','130223'),(69,'130200','滦南县','130224'),(70,'130200','乐亭县','130225'),(71,'130200','迁西县','130227'),(72,'130200','玉田县','130229'),(73,'130200','唐海县','130230'),(74,'130200','遵化市','130281'),(75,'130200','迁安市','130283'),(77,'130300','海港区','130302'),(78,'130300','山海关区','130303'),(79,'130300','北戴河区','130304'),(80,'130300','青龙满族自治县','130321'),(81,'130300','昌黎县','130322'),(82,'130300','抚宁县','130323'),(83,'130300','卢龙县','130324'),(85,'130400','邯山区','130402'),(86,'130400','丛台区','130403'),(87,'130400','复兴区','130404'),(88,'130400','峰峰矿区','130406'),(89,'130400','邯郸县','130421'),(90,'130400','临漳县','130423'),(91,'130400','成安县','130424'),(92,'130400','大名县','130425'),(93,'130400','涉　县','130426'),(94,'130400','磁　县','130427'),(95,'130400','肥乡县','130428'),(96,'130400','永年县','130429'),(97,'130400','邱　县','130430'),(98,'130400','鸡泽县','130431'),(99,'130400','广平县','130432'),(100,'130400','馆陶县','130433'),(101,'130400','魏　县','130434'),(102,'130400','曲周县','130435'),(103,'130400','武安市','130481'),(105,'130500','桥东区','130502'),(106,'130500','桥西区','130503'),(107,'130500','邢台县','130521'),(108,'130500','临城县','130522'),(109,'130500','内丘县','130523'),(110,'130500','柏乡县','130524'),(111,'130500','隆尧县','130525'),(112,'130500','任　县','130526'),(113,'130500','南和县','130527'),(114,'130500','宁晋县','130528'),(115,'130500','巨鹿县','130529'),(116,'130500','新河县','130530'),(117,'130500','广宗县','130531'),(118,'130500','平乡县','130532'),(119,'130500','威　县','130533'),(120,'130500','清河县','130534'),(121,'130500','临西县','130535'),(122,'130500','南宫市','130581'),(123,'130500','沙河市','130582'),(125,'130600','新市区','130602'),(126,'130600','北市区','130603'),(127,'130600','南市区','130604'),(128,'130600','满城县','130621'),(129,'130600','清苑县','130622'),(130,'130600','涞水县','130623'),(131,'130600','阜平县','130624'),(132,'130600','徐水县','130625'),(133,'130600','定兴县','130626'),(134,'130600','唐　县','130627'),(135,'130600','高阳县','130628'),(136,'130600','容城县','130629'),(137,'130600','涞源县','130630'),(138,'130600','望都县','130631'),(139,'130600','安新县','130632'),(140,'130600','易　县','130633'),(141,'130600','曲阳县','130634'),(142,'130600','蠡　县','130635'),(143,'130600','顺平县','130636'),(144,'130600','博野县','130637'),(145,'130600','雄　县','130638'),(146,'130600','涿州市','130681'),(147,'130600','定州市','130682'),(148,'130600','安国市','130683'),(149,'130600','高碑店市','130684'),(151,'130700','桥东区','130702'),(152,'130700','桥西区','130703'),(153,'130700','宣化区','130705'),(154,'130700','下花园区','130706'),(155,'130700','宣化县','130721'),(156,'130700','张北县','130722'),(157,'130700','康保县','130723'),(158,'130700','沽源县','130724'),(159,'130700','尚义县','130725'),(160,'130700','蔚　县','130726'),(161,'130700','阳原县','130727'),(162,'130700','怀安县','130728'),(163,'130700','万全县','130729'),(164,'130700','怀来县','130730'),(165,'130700','涿鹿县','130731'),(166,'130700','赤城县','130732'),(167,'130700','崇礼县','130733'),(169,'130800','双桥区','130802'),(170,'130800','双滦区','130803'),(171,'130800','鹰手营子矿区','130804'),(172,'130800','承德县','130821'),(173,'130800','兴隆县','130822'),(174,'130800','平泉县','130823'),(175,'130800','滦平县','130824'),(176,'130800','隆化县','130825'),(177,'130800','丰宁满族自治县','130826'),(178,'130800','宽城满族自治县','130827'),(179,'130800','围场满族蒙古族自治县','130828'),(181,'130900','新华区','130902'),(182,'130900','运河区','130903'),(183,'130900','沧　县','130921'),(184,'130900','青　县','130922'),(185,'130900','东光县','130923'),(186,'130900','海兴县','130924'),(187,'130900','盐山县','130925'),(188,'130900','肃宁县','130926'),(189,'130900','南皮县','130927'),(190,'130900','吴桥县','130928'),(191,'130900','献　县','130929'),(192,'130900','孟村回族自治县','130930'),(193,'130900','泊头市','130981'),(194,'130900','任丘市','130982'),(195,'130900','黄骅市','130983'),(196,'130900','河间市','130984'),(198,'131000','安次区','131002'),(199,'131000','广阳区','131003'),(200,'131000','固安县','131022'),(201,'131000','永清县','131023'),(202,'131000','香河县','131024'),(203,'131000','大城县','131025'),(204,'131000','文安县','131026'),(205,'131000','大厂回族自治县','131028'),(206,'131000','霸州市','131081'),(207,'131000','三河市','131082'),(209,'131100','桃城区','131102'),(210,'131100','枣强县','131121'),(211,'131100','武邑县','131122'),(212,'131100','武强县','131123'),(213,'131100','饶阳县','131124'),(214,'131100','安平县','131125'),(215,'131100','故城县','131126'),(216,'131100','景　县','131127'),(217,'131100','阜城县','131128'),(218,'131100','冀州市','131181'),(219,'131100','深州市','131182'),(221,'140100','小店区','140105'),(222,'140100','迎泽区','140106'),(223,'140100','杏花岭区','140107'),(224,'140100','尖草坪区','140108'),(225,'140100','万柏林区','140109'),(226,'140100','晋源区','140110'),(227,'140100','清徐县','140121'),(228,'140100','阳曲县','140122'),(229,'140100','娄烦县','140123'),(230,'140100','古交市','140181'),(232,'140200','城　区','140202'),(233,'140200','矿　区','140203'),(234,'140200','南郊区','140211'),(235,'140200','新荣区','140212'),(236,'140200','阳高县','140221'),(237,'140200','天镇县','140222'),(238,'140200','广灵县','140223'),(239,'140200','灵丘县','140224'),(240,'140200','浑源县','140225'),(241,'140200','左云县','140226'),(242,'140200','大同县','140227'),(244,'140300','城　区','140302'),(245,'140300','矿　区','140303'),(246,'140300','郊　区','140311'),(247,'140300','平定县','140321'),(248,'140300','盂　县','140322'),(250,'140400','城　区','140402'),(251,'140400','郊　区','140411'),(252,'140400','长治县','140421'),(253,'140400','襄垣县','140423'),(254,'140400','屯留县','140424'),(255,'140400','平顺县','140425'),(256,'140400','黎城县','140426'),(257,'140400','壶关县','140427'),(258,'140400','长子县','140428'),(259,'140400','武乡县','140429'),(260,'140400','沁　县','140430'),(261,'140400','沁源县','140431'),(262,'140400','潞城市','140481'),(264,'140500','城　区','140502'),(265,'140500','沁水县','140521'),(266,'140500','阳城县','140522'),(267,'140500','陵川县','140524'),(268,'140500','泽州县','140525'),(269,'140500','高平市','140581'),(271,'140600','朔城区','140602'),(272,'140600','平鲁区','140603'),(273,'140600','山阴县','140621'),(274,'140600','应　县','140622'),(275,'140600','右玉县','140623'),(276,'140600','怀仁县','140624'),(278,'140700','榆次区','140702'),(279,'140700','榆社县','140721'),(280,'140700','左权县','140722'),(281,'140700','和顺县','140723'),(282,'140700','昔阳县','140724'),(283,'140700','寿阳县','140725'),(284,'140700','太谷县','140726'),(285,'140700','祁　县','140727'),(286,'140700','平遥县','140728'),(287,'140700','灵石县','140729'),(288,'140700','介休市','140781'),(290,'140800','盐湖区','140802'),(291,'140800','临猗县','140821'),(292,'140800','万荣县','140822'),(293,'140800','闻喜县','140823'),(294,'140800','稷山县','140824'),(295,'140800','新绛县','140825'),(296,'140800','绛　县','140826'),(297,'140800','垣曲县','140827'),(298,'140800','夏　县','140828'),(299,'140800','平陆县','140829'),(300,'140800','芮城县','140830'),(301,'140800','永济市','140881'),(302,'140800','河津市','140882'),(304,'140900','忻府区','140902'),(305,'140900','定襄县','140921'),(306,'140900','五台县','140922'),(307,'140900','代　县','140923'),(308,'140900','繁峙县','140924'),(309,'140900','宁武县','140925'),(310,'140900','静乐县','140926'),(311,'140900','神池县','140927'),(312,'140900','五寨县','140928'),(313,'140900','岢岚县','140929'),(314,'140900','河曲县','140930'),(315,'140900','保德县','140931'),(316,'140900','偏关县','140932'),(317,'140900','原平市','140981'),(319,'141000','尧都区','141002'),(320,'141000','曲沃县','141021'),(321,'141000','翼城县','141022'),(322,'141000','襄汾县','141023'),(323,'141000','洪洞县','141024'),(324,'141000','古　县','141025'),(325,'141000','安泽县','141026'),(326,'141000','浮山县','141027'),(327,'141000','吉　县','141028'),(328,'141000','乡宁县','141029'),(329,'141000','大宁县','141030'),(330,'141000','隰　县','141031'),(331,'141000','永和县','141032'),(332,'141000','蒲　县','141033'),(333,'141000','汾西县','141034'),(334,'141000','侯马市','141081'),(335,'141000','霍州市','141082'),(337,'141100','离石区','141102'),(338,'141100','文水县','141121'),(339,'141100','交城县','141122'),(340,'141100','兴　县','141123'),(341,'141100','临　县','141124'),(342,'141100','柳林县','141125'),(343,'141100','石楼县','141126'),(344,'141100','岚　县','141127'),(345,'141100','方山县','141128'),(346,'141100','中阳县','141129'),(347,'141100','交口县','141130'),(348,'141100','孝义市','141181'),(349,'141100','汾阳市','141182'),(351,'150100','新城区','150102'),(352,'150100','回民区','150103'),(353,'150100','玉泉区','150104'),(354,'150100','赛罕区','150105'),(355,'150100','土默特左旗','150121'),(356,'150100','托克托县','150122'),(357,'150100','和林格尔县','150123'),(358,'150100','清水河县','150124'),(359,'150100','武川县','150125'),(361,'150200','东河区','150202'),(362,'150200','昆都仑区','150203'),(363,'150200','青山区','150204'),(364,'150200','石拐区','150205'),(365,'150200','白云矿区','150206'),(366,'150200','九原区','150207'),(367,'150200','土默特右旗','150221'),(368,'150200','固阳县','150222'),(369,'150200','达尔罕茂明安联合旗','150223'),(371,'150300','海勃湾区','150302'),(372,'150300','海南区','150303'),(373,'150300','乌达区','150304'),(375,'150400','红山区','150402'),(376,'150400','元宝山区','150403'),(377,'150400','松山区','150404'),(378,'150400','阿鲁科尔沁旗','150421'),(379,'150400','巴林左旗','150422'),(380,'150400','巴林右旗','150423'),(381,'150400','林西县','150424'),(382,'150400','克什克腾旗','150425'),(383,'150400','翁牛特旗','150426'),(384,'150400','喀喇沁旗','150428'),(385,'150400','宁城县','150429'),(386,'150400','敖汉旗','150430'),(388,'150500','科尔沁区','150502'),(389,'150500','科尔沁左翼中旗','150521'),(390,'150500','科尔沁左翼后旗','150522'),(391,'150500','开鲁县','150523'),(392,'150500','库伦旗','150524'),(393,'150500','奈曼旗','150525'),(394,'150500','扎鲁特旗','150526'),(395,'150500','霍林郭勒市','150581'),(396,'150600','东胜区','150602'),(397,'150600','达拉特旗','150621'),(398,'150600','准格尔旗','150622'),(399,'150600','鄂托克前旗','150623'),(400,'150600','鄂托克旗','150624'),(401,'150600','杭锦旗','150625'),(402,'150600','乌审旗','150626'),(403,'150600','伊金霍洛旗','150627'),(405,'150700','海拉尔区','150702'),(406,'150700','阿荣旗','150721'),(407,'150700','莫力达瓦达斡尔族自治旗','150722'),(408,'150700','鄂伦春自治旗','150723'),(409,'150700','鄂温克族自治旗','150724'),(410,'150700','陈巴尔虎旗','150725'),(411,'150700','新巴尔虎左旗','150726'),(412,'150700','新巴尔虎右旗','150727'),(413,'150700','满洲里市','150781'),(414,'150700','牙克石市','150782'),(415,'150700','扎兰屯市','150783'),(416,'150700','额尔古纳市','150784'),(417,'150700','根河市','150785'),(419,'150800','临河区','150802'),(420,'150800','五原县','150821'),(421,'150800','磴口县','150822'),(422,'150800','乌拉特前旗','150823'),(423,'150800','乌拉特中旗','150824'),(424,'150800','乌拉特后旗','150825'),(425,'150800','杭锦后旗','150826'),(427,'150900','集宁区','150902'),(428,'150900','卓资县','150921'),(429,'150900','化德县','150922'),(430,'150900','商都县','150923'),(431,'150900','兴和县','150924'),(432,'150900','凉城县','150925'),(433,'150900','察哈尔右翼前旗','150926'),(434,'150900','察哈尔右翼中旗','150927'),(435,'150900','察哈尔右翼后旗','150928'),(436,'150900','四子王旗','150929'),(437,'150900','丰镇市','150981'),(438,'152200','乌兰浩特市','152201'),(439,'152200','阿尔山市','152202'),(440,'152200','科尔沁右翼前旗','152221'),(441,'152200','科尔沁右翼中旗','152222'),(442,'152200','扎赉特旗','152223'),(443,'152200','突泉县','152224'),(444,'152500','二连浩特市','152501'),(445,'152500','锡林浩特市','152502'),(446,'152500','阿巴嘎旗','152522'),(447,'152500','苏尼特左旗','152523'),(448,'152500','苏尼特右旗','152524'),(449,'152500','东乌珠穆沁旗','152525'),(450,'152500','西乌珠穆沁旗','152526'),(451,'152500','太仆寺旗','152527'),(452,'152500','镶黄旗','152528'),(453,'152500','正镶白旗','152529'),(454,'152500','正蓝旗','152530'),(455,'152500','多伦县','152531'),(456,'152900','阿拉善左旗','152921'),(457,'152900','阿拉善右旗','152922'),(458,'152900','额济纳旗','152923'),(460,'210100','和平区','210102'),(461,'210100','沈河区','210103'),(462,'210100','大东区','210104'),(463,'210100','皇姑区','210105'),(464,'210100','铁西区','210106'),(465,'210100','苏家屯区','210111'),(466,'210100','东陵区','210112'),(467,'210100','新城子区','210113'),(468,'210100','于洪区','210114'),(469,'210100','辽中县','210122'),(470,'210100','康平县','210123'),(471,'210100','法库县','210124'),(472,'210100','新民市','210181'),(474,'210200','中山区','210202'),(475,'210200','西岗区','210203'),(476,'210200','沙河口区','210204'),(477,'210200','甘井子区','210211'),(478,'210200','旅顺口区','210212'),(479,'210200','金州区','210213'),(480,'210200','长海县','210224'),(481,'210200','瓦房店市','210281'),(482,'210200','普兰店市','210282'),(483,'210200','庄河市','210283'),(485,'210300','铁东区','210302'),(486,'210300','铁西区','210303'),(487,'210300','立山区','210304'),(488,'210300','千山区','210311'),(489,'210300','台安县','210321'),(490,'210300','岫岩满族自治县','210323'),(491,'210300','海城市','210381'),(493,'210400','新抚区','210402'),(494,'210400','东洲区','210403'),(495,'210400','望花区','210404'),(496,'210400','顺城区','210411'),(497,'210400','抚顺县','210421'),(498,'210400','新宾满族自治县','210422'),(499,'210400','清原满族自治县','210423'),(501,'210500','平山区','210502'),(502,'210500','溪湖区','210503'),(503,'210500','明山区','210504'),(504,'210500','南芬区','210505'),(505,'210500','本溪满族自治县','210521'),(506,'210500','桓仁满族自治县','210522'),(508,'210600','元宝区','210602'),(509,'210600','振兴区','210603'),(510,'210600','振安区','210604'),(511,'210600','宽甸满族自治县','210624'),(512,'210600','东港市','210681'),(513,'210600','凤城市','210682'),(515,'210700','古塔区','210702'),(516,'210700','凌河区','210703'),(517,'210700','太和区','210711'),(518,'210700','黑山县','210726'),(519,'210700','义　县','210727'),(520,'210700','凌海市','210781'),(521,'210700','北镇市','210782'),(523,'210800','站前区','210802'),(524,'210800','西市区','210803'),(525,'210800','鲅鱼圈区','210804'),(526,'210800','老边区','210811'),(527,'210800','盖州市','210881'),(528,'210800','大石桥市','210882'),(530,'210900','海州区','210902'),(531,'210900','新邱区','210903'),(532,'210900','太平区','210904'),(533,'210900','清河门区','210905'),(534,'210900','细河区','210911'),(535,'210900','阜新蒙古族自治县','210921'),(536,'210900','彰武县','210922'),(538,'211000','白塔区','211002'),(539,'211000','文圣区','211003'),(540,'211000','宏伟区','211004'),(541,'211000','弓长岭区','211005'),(542,'211000','太子河区','211011'),(543,'211000','辽阳县','211021'),(544,'211000','灯塔市','211081'),(546,'211100','双台子区','211102'),(547,'211100','兴隆台区','211103'),(548,'211100','大洼县','211121'),(549,'211100','盘山县','211122'),(551,'211200','银州区','211202'),(552,'211200','清河区','211204'),(553,'211200','铁岭县','211221'),(554,'211200','西丰县','211223'),(555,'211200','昌图县','211224'),(556,'211200','调兵山市','211281'),(557,'211200','开原市','211282'),(559,'211300','双塔区','211302'),(560,'211300','龙城区','211303'),(561,'211300','朝阳县','211321'),(562,'211300','建平县','211322'),(563,'211300','喀喇沁左翼蒙古族自治县','211324'),(564,'211300','北票市','211381'),(565,'211300','凌源市','211382'),(567,'211400','连山区','211402'),(568,'211400','龙港区','211403'),(569,'211400','南票区','211404'),(570,'211400','绥中县','211421'),(571,'211400','建昌县','211422'),(572,'211400','兴城市','211481'),(574,'220100','南关区','220102'),(575,'220100','宽城区','220103'),(576,'220100','朝阳区','220104'),(577,'220100','二道区','220105'),(578,'220100','绿园区','220106'),(579,'220100','双阳区','220112'),(580,'220100','农安县','220122'),(581,'220100','九台市','220181'),(582,'220100','榆树市','220182'),(583,'220100','德惠市','220183'),(585,'220200','昌邑区','220202'),(586,'220200','龙潭区','220203'),(587,'220200','船营区','220204'),(588,'220200','丰满区','220211'),(589,'220200','永吉县','220221'),(590,'220200','蛟河市','220281'),(591,'220200','桦甸市','220282'),(592,'220200','舒兰市','220283'),(593,'220200','磐石市','220284'),(595,'220300','铁西区','220302'),(596,'220300','铁东区','220303'),(597,'220300','梨树县','220322'),(598,'220300','伊通满族自治县','220323'),(599,'220300','公主岭市','220381'),(600,'220300','双辽市','220382'),(602,'220400','龙山区','220402'),(603,'220400','西安区','220403'),(604,'220400','东丰县','220421'),(605,'220400','东辽县','220422'),(607,'220500','东昌区','220502'),(608,'220500','二道江区','220503'),(609,'220500','通化县','220521'),(610,'220500','辉南县','220523'),(611,'220500','柳河县','220524'),(612,'220500','梅河口市','220581'),(613,'220500','集安市','220582'),(615,'220600','八道江区','220602'),(616,'220600','抚松县','220621'),(617,'220600','靖宇县','220622'),(618,'220600','长白朝鲜族自治县','220623'),(619,'220600','江源区','220625'),(620,'220600','临江市','220681'),(622,'220700','宁江区','220702'),(623,'220700','前郭尔罗斯蒙古族自治县','220721'),(624,'220700','长岭县','220722'),(625,'220700','乾安县','220723'),(626,'220700','扶余县','220724'),(628,'220800','洮北区','220802'),(629,'220800','镇赉县','220821'),(630,'220800','通榆县','220822'),(631,'220800','洮南市','220881'),(632,'220800','大安市','220882'),(633,'222400','延吉市','222401'),(634,'222400','图们市','222402'),(635,'222400','敦化市','222403'),(636,'222400','珲春市','222404'),(637,'222400','龙井市','222405'),(638,'222400','和龙市','222406'),(639,'222400','汪清县','222424'),(640,'222400','安图县','222426'),(642,'230100','道里区','230102'),(643,'230100','南岗区','230103'),(644,'230100','道外区','230104'),(645,'230100','香坊区','230106'),(646,'230100','动力区','230107'),(647,'230100','平房区','230108'),(648,'230100','松北区','230109'),(649,'230100','呼兰区','230111'),(650,'230100','依兰县','230123'),(651,'230100','方正县','230124'),(652,'230100','宾　县','230125'),(653,'230100','巴彦县','230126'),(654,'230100','木兰县','230127'),(655,'230100','通河县','230128'),(656,'230100','延寿县','230129'),(657,'230100','阿城市','230181'),(658,'230100','双城市','230182'),(659,'230100','尚志市','230183'),(660,'230100','五常市','230184'),(662,'230200','龙沙区','230202'),(663,'230200','建华区','230203'),(664,'230200','铁锋区','230204'),(665,'230200','昂昂溪区','230205'),(666,'230200','富拉尔基区','230206'),(667,'230200','碾子山区','230207'),(668,'230200','梅里斯达斡尔族区','230208'),(669,'230200','龙江县','230221'),(670,'230200','依安县','230223'),(671,'230200','泰来县','230224'),(672,'230200','甘南县','230225'),(673,'230200','富裕县','230227'),(674,'230200','克山县','230229'),(675,'230200','克东县','230230'),(676,'230200','拜泉县','230231'),(677,'230200','讷河市','230281'),(679,'230300','鸡冠区','230302'),(680,'230300','恒山区','230303'),(681,'230300','滴道区','230304'),(682,'230300','梨树区','230305'),(683,'230300','城子河区','230306'),(684,'230300','麻山区','230307'),(685,'230300','鸡东县','230321'),(686,'230300','虎林市','230381'),(687,'230300','密山市','230382'),(689,'230400','向阳区','230402'),(690,'230400','工农区','230403'),(691,'230400','南山区','230404'),(692,'230400','兴安区','230405'),(693,'230400','东山区','230406'),(694,'230400','兴山区','230407'),(695,'230400','萝北县','230421'),(696,'230400','绥滨县','230422'),(698,'230500','尖山区','230502'),(699,'230500','岭东区','230503'),(700,'230500','四方台区','230505'),(701,'230500','宝山区','230506'),(702,'230500','集贤县','230521'),(703,'230500','友谊县','230522'),(704,'230500','宝清县','230523'),(705,'230500','饶河县','230524'),(707,'230600','萨尔图区','230602'),(708,'230600','龙凤区','230603'),(709,'230600','让胡路区','230604'),(710,'230600','红岗区','230605'),(711,'230600','大同区','230606'),(712,'230600','肇州县','230621'),(713,'230600','肇源县','230622'),(714,'230600','林甸县','230623'),(715,'230600','杜尔伯特蒙古族自治县','230624'),(717,'230700','伊春区','230702'),(718,'230700','南岔区','230703'),(719,'230700','友好区','230704'),(720,'230700','西林区','230705'),(721,'230700','翠峦区','230706'),(722,'230700','新青区','230707'),(723,'230700','美溪区','230708'),(724,'230700','金山屯区','230709'),(725,'230700','五营区','230710'),(726,'230700','乌马河区','230711'),(727,'230700','汤旺河区','230712'),(728,'230700','带岭区','230713'),(729,'230700','乌伊岭区','230714'),(730,'230700','红星区','230715'),(731,'230700','上甘岭区','230716'),(732,'230700','嘉荫县','230722'),(733,'230700','铁力市','230781'),(735,'230800','永红区','230802'),(736,'230800','向阳区','230803'),(737,'230800','前进区','230804'),(738,'230800','东风区','230805'),(739,'230800','郊　区','230811'),(740,'230800','桦南县','230822'),(741,'230800','桦川县','230826'),(742,'230800','汤原县','230828'),(743,'230800','抚远县','230833'),(744,'230800','同江市','230881'),(745,'230800','富锦市','230882'),(747,'230900','新兴区','230902'),(748,'230900','桃山区','230903'),(749,'230900','茄子河区','230904'),(750,'230900','勃利县','230921'),(752,'231000','东安区','231002'),(753,'231000','阳明区','231003'),(754,'231000','爱民区','231004'),(755,'231000','西安区','231005'),(756,'231000','东宁县','231024'),(757,'231000','林口县','231025'),(758,'231000','绥芬河市','231081'),(759,'231000','海林市','231083'),(760,'231000','宁安市','231084'),(761,'231000','穆棱市','231085'),(763,'231100','爱辉区','231102'),(764,'231100','嫩江县','231121'),(765,'231100','逊克县','231123'),(766,'231100','孙吴县','231124'),(767,'231100','北安市','231181'),(768,'231100','五大连池市','231182'),(770,'231200','北林区','231202'),(771,'231200','望奎县','231221'),(772,'231200','兰西县','231222'),(773,'231200','青冈县','231223'),(774,'231200','庆安县','231224'),(775,'231200','明水县','231225'),(776,'231200','绥棱县','231226'),(777,'231200','安达市','231281'),(778,'231200','肇东市','231282'),(779,'231200','海伦市','231283'),(780,'232700','呼玛县','232721'),(781,'232700','塔河县','232722'),(782,'232700','漠河县','232723'),(783,'310100','黄浦区','310101'),(784,'310100','卢湾区','310103'),(785,'310100','徐汇区','310104'),(786,'310100','长宁区','310105'),(787,'310100','静安区','310106'),(788,'310100','普陀区','310107'),(789,'310100','闸北区','310108'),(790,'310100','虹口区','310109'),(791,'310100','杨浦区','310110'),(792,'310100','闵行区','310112'),(793,'310100','宝山区','310113'),(794,'310100','嘉定区','310114'),(795,'310100','浦东新区','310115'),(796,'310100','金山区','310116'),(797,'310100','松江区','310117'),(798,'310100','青浦区','310118'),(799,'310100','南汇区','310119'),(800,'310100','奉贤区','310120'),(801,'310100','崇明县','310230'),(803,'320100','玄武区','320102'),(804,'320100','白下区','320103'),(805,'320100','秦淮区','320104'),(806,'320100','建邺区','320105'),(807,'320100','鼓楼区','320106'),(808,'320100','下关区','320107'),(809,'320100','浦口区','320111'),(810,'320100','栖霞区','320113'),(811,'320100','雨花台区','320114'),(812,'320100','江宁区','320115'),(813,'320100','六合区','320116'),(814,'320100','溧水县','320124'),(815,'320100','高淳县','320125'),(817,'320200','崇安区','320202'),(818,'320200','南长区','320203'),(819,'320200','北塘区','320204'),(820,'320200','锡山区','320205'),(821,'320200','惠山区','320206'),(822,'320200','滨湖区','320211'),(823,'320200','江阴市','320281'),(824,'320200','宜兴市','320282'),(826,'320300','鼓楼区','320302'),(827,'320300','云龙区','320303'),(828,'320300','九里区','320304'),(829,'320300','贾汪区','320305'),(830,'320300','泉山区','320311'),(831,'320300','丰　县','320321'),(832,'320300','沛　县','320322'),(833,'320300','铜山县','320323'),(834,'320300','睢宁县','320324'),(835,'320300','新沂市','320381'),(836,'320300','邳州市','320382'),(838,'320400','天宁区','320402'),(839,'320400','钟楼区','320404'),(840,'320400','戚墅堰区','320405'),(841,'320400','新北区','320411'),(842,'320400','武进区','320412'),(843,'320400','溧阳市','320481'),(844,'320400','金坛市','320482'),(846,'320500','沧浪区','320502'),(847,'320500','平江区','320503'),(848,'320500','金阊区','320504'),(849,'320500','虎丘区','320505'),(850,'320500','吴中区','320506'),(851,'320500','相城区','320507'),(852,'320500','常熟市','320581'),(853,'320500','张家港市','320582'),(854,'320500','昆山市','320583'),(855,'320500','吴江市','320584'),(856,'320500','太仓市','320585'),(858,'320600','崇川区','320602'),(859,'320600','港闸区','320611'),(860,'320600','海安县','320621'),(861,'320600','如东县','320623'),(862,'320600','启东市','320681'),(863,'320600','如皋市','320682'),(864,'320600','通州区','320683'),(865,'320600','海门市','320684'),(867,'320700','连云区','320703'),(868,'320700','新浦区','320705'),(869,'320700','海州区','320706'),(870,'320700','赣榆县','320721'),(871,'320700','东海县','320722'),(872,'320700','灌云县','320723'),(873,'320700','灌南县','320724'),(875,'320800','清河区','320802'),(876,'320800','楚州区','320803'),(877,'320800','淮阴区','320804'),(878,'320800','清浦区','320811'),(879,'320800','涟水县','320826'),(880,'320800','洪泽县','320829'),(881,'320800','盱眙县','320830'),(882,'320800','金湖县','320831'),(884,'320900','亭湖区','320902'),(885,'320900','盐都区','320903'),(886,'320900','响水县','320921'),(887,'320900','滨海县','320922'),(888,'320900','阜宁县','320923'),(889,'320900','射阳县','320924'),(890,'320900','建湖县','320925'),(891,'320900','东台市','320981'),(892,'320900','大丰市','320982'),(894,'321000','广陵区','321002'),(895,'321000','邗江区','321003'),(896,'321000','郊　区','321011'),(897,'321000','宝应县','321023'),(898,'321000','仪征市','321081'),(899,'321000','高邮市','321084'),(900,'321000','江都市','321088'),(902,'321100','京口区','321102'),(903,'321100','润州区','321111'),(904,'321100','丹徒区','321112'),(905,'321100','丹阳市','321181'),(906,'321100','扬中市','321182'),(907,'321100','句容市','321183'),(909,'321200','海陵区','321202'),(910,'321200','高港区','321203'),(911,'321200','兴化市','321281'),(912,'321200','靖江市','321282'),(913,'321200','泰兴市','321283'),(914,'321200','姜堰市','321284'),(916,'321300','宿城区','321302'),(917,'321300','宿豫区','321311'),(918,'321300','沭阳县','321322'),(919,'321300','泗阳县','321323'),(920,'321300','泗洪县','321324'),(922,'330100','上城区','330102'),(923,'330100','下城区','330103'),(924,'330100','江干区','330104'),(925,'330100','拱墅区','330105'),(926,'330100','西湖区','330106'),(927,'330100','滨江区','330108'),(928,'330100','萧山区','330109'),(929,'330100','余杭区','330110'),(930,'330100','桐庐县','330122'),(931,'330100','淳安县','330127'),(932,'330100','建德市','330182'),(933,'330100','富阳市','330183'),(934,'330100','临安市','330185'),(936,'330200','海曙区','330203'),(937,'330200','江东区','330204'),(938,'330200','江北区','330205'),(939,'330200','北仑区','330206'),(940,'330200','镇海区','330211'),(941,'330200','鄞州区','330212'),(942,'330200','象山县','330225'),(943,'330200','宁海县','330226'),(944,'330200','余姚市','330281'),(945,'330200','慈溪市','330282'),(946,'330200','奉化市','330283'),(948,'330300','鹿城区','330302'),(949,'330300','龙湾区','330303'),(950,'330300','瓯海区','330304'),(951,'330300','洞头县','330322'),(952,'330300','永嘉县','330324'),(953,'330300','平阳县','330326'),(954,'330300','苍南县','330327'),(955,'330300','文成县','330328'),(956,'330300','泰顺县','330329'),(957,'330300','瑞安市','330381'),(958,'330300','乐清市','330382'),(960,'330400','秀城区','330402'),(961,'330400','秀洲区','330411'),(962,'330400','嘉善县','330421'),(963,'330400','海盐县','330424'),(964,'330400','海宁市','330481'),(965,'330400','平湖市','330482'),(966,'330400','桐乡市','330483'),(968,'330500','吴兴区','330502'),(969,'330500','南浔区','330503'),(970,'330500','德清县','330521'),(971,'330500','长兴县','330522'),(972,'330500','安吉县','330523'),(974,'330600','越城区','330602'),(975,'330600','绍兴县','330621'),(976,'330600','新昌县','330624'),(977,'330600','诸暨市','330681'),(978,'330600','上虞市','330682'),(979,'330600','嵊州市','330683'),(981,'330700','婺城区','330702'),(982,'330700','金东区','330703'),(983,'330700','武义县','330723'),(984,'330700','浦江县','330726'),(985,'330700','磐安县','330727'),(986,'330700','兰溪市','330781'),(987,'330700','义乌市','330782'),(988,'330700','东阳市','330783'),(989,'330700','永康市','330784'),(991,'330800','柯城区','330802'),(992,'330800','衢江区','330803'),(993,'330800','常山县','330822'),(994,'330800','开化县','330824'),(995,'330800','龙游县','330825'),(996,'330800','江山市','330881'),(998,'330900','定海区','330902'),(999,'330900','普陀区','330903'),(1000,'330900','岱山县','330921'),(1001,'330900','嵊泗县','330922'),(1003,'331000','椒江区','331002'),(1004,'331000','黄岩区','331003'),(1005,'331000','路桥区','331004'),(1006,'331000','玉环县','331021'),(1007,'331000','三门县','331022'),(1008,'331000','天台县','331023'),(1009,'331000','仙居县','331024'),(1010,'331000','温岭市','331081'),(1011,'331000','临海市','331082'),(1013,'331100','莲都区','331102'),(1014,'331100','青田县','331121'),(1015,'331100','缙云县','331122'),(1016,'331100','遂昌县','331123'),(1017,'331100','松阳县','331124'),(1018,'331100','云和县','331125'),(1019,'331100','庆元县','331126'),(1020,'331100','景宁畲族自治县','331127'),(1021,'331100','龙泉市','331181'),(1023,'340100','瑶海区','340102'),(1024,'340100','庐阳区','340103'),(1025,'340100','蜀山区','340104'),(1026,'340100','包河区','340111'),(1027,'340100','长丰县','340121'),(1028,'340100','肥东县','340122'),(1029,'340100','肥西县','340123'),(1031,'340200','镜湖区','340202'),(1032,'340200','马塘区','340203'),(1033,'340200','新芜区','340204'),(1034,'340200','鸠江区','340205'),(1035,'340200','芜湖县','340221'),(1036,'340200','繁昌县','340222'),(1037,'340200','南陵县','340223'),(1039,'340300','龙子湖区','340302'),(1040,'340300','蚌山区','340303'),(1041,'340300','禹会区','340304'),(1042,'340300','淮上区','340311'),(1043,'340300','怀远县','340321'),(1044,'340300','五河县','340322'),(1045,'340300','固镇县','340323'),(1047,'340400','大通区','340402'),(1048,'340400','田家庵区','340403'),(1049,'340400','谢家集区','340404'),(1050,'340400','八公山区','340405'),(1051,'340400','潘集区','340406'),(1052,'340400','凤台县','340421'),(1054,'340500','金家庄区','340502'),(1055,'340500','花山区','340503'),(1056,'340500','雨山区','340504'),(1057,'340500','当涂县','340521'),(1059,'340600','杜集区','340602'),(1060,'340600','相山区','340603'),(1061,'340600','烈山区','340604'),(1062,'340600','濉溪县','340621'),(1064,'340700','铜官山区','340702'),(1065,'340700','狮子山区','340703'),(1066,'340700','郊　区','340711'),(1067,'340700','铜陵县','340721'),(1069,'340800','迎江区','340802'),(1070,'340800','大观区','340803'),(1071,'340800','郊　区','340811'),(1072,'340800','怀宁县','340822'),(1073,'340800','枞阳县','340823'),(1074,'340800','潜山县','340824'),(1075,'340800','太湖县','340825'),(1076,'340800','宿松县','340826'),(1077,'340800','望江县','340827'),(1078,'340800','岳西县','340828'),(1079,'340800','桐城市','340881'),(1081,'341000','屯溪区','341002'),(1082,'341000','黄山区','341003'),(1083,'341000','徽州区','341004'),(1084,'341000','歙　县','341021'),(1085,'341000','休宁县','341022'),(1086,'341000','黟　县','341023'),(1087,'341000','祁门县','341024'),(1089,'341100','琅琊区','341102'),(1090,'341100','南谯区','341103'),(1091,'341100','来安县','341122'),(1092,'341100','全椒县','341124'),(1093,'341100','定远县','341125'),(1094,'341100','凤阳县','341126'),(1095,'341100','天长市','341181'),(1096,'341100','明光市','341182'),(1098,'341200','颍州区','341202'),(1099,'341200','颍东区','341203'),(1100,'341200','颍泉区','341204'),(1101,'341200','临泉县','341221'),(1102,'341200','太和县','341222'),(1103,'341200','阜南县','341225'),(1104,'341200','颍上县','341226'),(1105,'341200','界首市','341282'),(1107,'341300','埇桥区','341302'),(1108,'341300','砀山县','341321'),(1109,'341300','萧　县','341322'),(1110,'341300','灵璧县','341323'),(1111,'341300','泗　县','341324'),(1113,'341400','居巢区','341402'),(1114,'341400','庐江县','341421'),(1115,'341400','无为县','341422'),(1116,'341400','含山县','341423'),(1117,'341400','和　县','341424'),(1119,'341500','金安区','341502'),(1120,'341500','裕安区','341503'),(1121,'341500','寿　县','341521'),(1122,'341500','霍邱县','341522'),(1123,'341500','舒城县','341523'),(1124,'341500','金寨县','341524'),(1125,'341500','霍山县','341525'),(1127,'341600','谯城区','341602'),(1128,'341600','涡阳县','341621'),(1129,'341600','蒙城县','341622'),(1130,'341600','利辛县','341623'),(1132,'341700','贵池区','341702'),(1133,'341700','东至县','341721'),(1134,'341700','石台县','341722'),(1135,'341700','青阳县','341723'),(1137,'341800','宣州区','341802'),(1138,'341800','郎溪县','341821'),(1139,'341800','广德县','341822'),(1140,'341800','泾　县','341823'),(1141,'341800','绩溪县','341824'),(1142,'341800','旌德县','341825'),(1143,'341800','宁国市','341881'),(1145,'350100','鼓楼区','350102'),(1146,'350100','台江区','350103'),(1147,'350100','仓山区','350104'),(1148,'350100','马尾区','350105'),(1149,'350100','晋安区','350111'),(1150,'350100','闽侯县','350121'),(1151,'350100','连江县','350122'),(1152,'350100','罗源县','350123'),(1153,'350100','闽清县','350124'),(1154,'350100','永泰县','350125'),(1155,'350100','平潭县','350128'),(1156,'350100','福清市','350181'),(1157,'350100','长乐市','350182'),(1159,'350200','思明区','350203'),(1160,'350200','海沧区','350205'),(1161,'350200','湖里区','350206'),(1162,'350200','集美区','350211'),(1163,'350200','同安区','350212'),(1164,'350200','翔安区','350213'),(1166,'350300','城厢区','350302'),(1167,'350300','涵江区','350303'),(1168,'350300','荔城区','350304'),(1169,'350300','秀屿区','350305'),(1170,'350300','仙游县','350322'),(1172,'350400','梅列区','350402'),(1173,'350400','三元区','350403'),(1174,'350400','明溪县','350421'),(1175,'350400','清流县','350423'),(1176,'350400','宁化县','350424'),(1177,'350400','大田县','350425'),(1178,'350400','尤溪县','350426'),(1179,'350400','沙　县','350427'),(1180,'350400','将乐县','350428'),(1181,'350400','泰宁县','350429'),(1182,'350400','建宁县','350430'),(1183,'350400','永安市','350481'),(1185,'350500','鲤城区','350502'),(1186,'350500','丰泽区','350503'),(1187,'350500','洛江区','350504'),(1188,'350500','泉港区','350505'),(1189,'350500','惠安县','350521'),(1190,'350500','安溪县','350524'),(1191,'350500','永春县','350525'),(1192,'350500','德化县','350526'),(1193,'350500','金门县','350527'),(1194,'350500','石狮市','350581'),(1195,'350500','晋江市','350582'),(1196,'350500','南安市','350583'),(1198,'350600','芗城区','350602'),(1199,'350600','龙文区','350603'),(1200,'350600','云霄县','350622'),(1201,'350600','漳浦县','350623'),(1202,'350600','诏安县','350624'),(1203,'350600','长泰县','350625'),(1204,'350600','东山县','350626'),(1205,'350600','南靖县','350627'),(1206,'350600','平和县','350628'),(1207,'350600','华安县','350629'),(1208,'350600','龙海市','350681'),(1210,'350700','延平区','350702'),(1211,'350700','顺昌县','350721'),(1212,'350700','浦城县','350722'),(1213,'350700','光泽县','350723'),(1214,'350700','松溪县','350724'),(1215,'350700','政和县','350725'),(1216,'350700','邵武市','350781'),(1217,'350700','武夷山市','350782'),(1218,'350700','建瓯市','350783'),(1219,'350700','建阳市','350784'),(1221,'350800','新罗区','350802'),(1222,'350800','长汀县','350821'),(1223,'350800','永定县','350822'),(1224,'350800','上杭县','350823'),(1225,'350800','武平县','350824'),(1226,'350800','连城县','350825'),(1227,'350800','漳平市','350881'),(1229,'350900','蕉城区','350902'),(1230,'350900','霞浦县','350921'),(1231,'350900','古田县','350922'),(1232,'350900','屏南县','350923'),(1233,'350900','寿宁县','350924'),(1234,'350900','周宁县','350925'),(1235,'350900','柘荣县','350926'),(1236,'350900','福安市','350981'),(1237,'350900','福鼎市','350982'),(1239,'360100','东湖区','360102'),(1240,'360100','西湖区','360103'),(1241,'360100','青云谱区','360104'),(1242,'360100','湾里区','360105'),(1243,'360100','青山湖区','360111'),(1244,'360100','南昌县','360121'),(1245,'360100','新建县','360122'),(1246,'360100','安义县','360123'),(1247,'360100','进贤县','360124'),(1249,'360200','昌江区','360202'),(1250,'360200','珠山区','360203'),(1251,'360200','浮梁县','360222'),(1252,'360200','乐平市','360281'),(1254,'360300','安源区','360302'),(1255,'360300','湘东区','360313'),(1256,'360300','莲花县','360321'),(1257,'360300','上栗县','360322'),(1258,'360300','芦溪县','360323'),(1260,'360400','庐山区','360402'),(1261,'360400','浔阳区','360403'),(1262,'360400','九江县','360421'),(1263,'360400','武宁县','360423'),(1264,'360400','修水县','360424'),(1265,'360400','永修县','360425'),(1266,'360400','德安县','360426'),(1267,'360400','星子县','360427'),(1268,'360400','都昌县','360428'),(1269,'360400','湖口县','360429'),(1270,'360400','彭泽县','360430'),(1271,'360400','瑞昌市','360481'),(1273,'360500','渝水区','360502'),(1274,'360500','分宜县','360521'),(1276,'360600','月湖区','360602'),(1277,'360600','余江县','360622'),(1278,'360600','贵溪市','360681'),(1280,'360700','章贡区','360702'),(1281,'360700','赣　县','360721'),(1282,'360700','信丰县','360722'),(1283,'360700','大余县','360723'),(1284,'360700','上犹县','360724'),(1285,'360700','崇义县','360725'),(1286,'360700','安远县','360726'),(1287,'360700','龙南县','360727'),(1288,'360700','定南县','360728'),(1289,'360700','全南县','360729'),(1290,'360700','宁都县','360730'),(1291,'360700','于都县','360731'),(1292,'360700','兴国县','360732'),(1293,'360700','会昌县','360733'),(1294,'360700','寻乌县','360734'),(1295,'360700','石城县','360735'),(1296,'360700','瑞金市','360781'),(1297,'360700','南康区','360782'),(1299,'360800','吉州区','360802'),(1300,'360800','青原区','360803'),(1301,'360800','吉安县','360821'),(1302,'360800','吉水县','360822'),(1303,'360800','峡江县','360823'),(1304,'360800','新干县','360824'),(1305,'360800','永丰县','360825'),(1306,'360800','泰和县','360826'),(1307,'360800','遂川县','360827'),(1308,'360800','万安县','360828'),(1309,'360800','安福县','360829'),(1310,'360800','永新县','360830'),(1311,'360800','井冈山市','360881'),(1313,'360900','袁州区','360902'),(1314,'360900','奉新县','360921'),(1315,'360900','万载县','360922'),(1316,'360900','上高县','360923'),(1317,'360900','宜丰县','360924'),(1318,'360900','靖安县','360925'),(1319,'360900','铜鼓县','360926'),(1320,'360900','丰城市','360981'),(1321,'360900','樟树市','360982'),(1322,'360900','高安市','360983'),(1324,'361000','临川区','361002'),(1325,'361000','南城县','361021'),(1326,'361000','黎川县','361022'),(1327,'361000','南丰县','361023'),(1328,'361000','崇仁县','361024'),(1329,'361000','乐安县','361025'),(1330,'361000','宜黄县','361026'),(1331,'361000','金溪县','361027'),(1332,'361000','资溪县','361028'),(1333,'361000','东乡县','361029'),(1334,'361000','广昌县','361030'),(1336,'361100','信州区','361102'),(1337,'361100','上饶县','361121'),(1338,'361100','广丰县','361122'),(1339,'361100','玉山县','361123'),(1340,'361100','铅山县','361124'),(1341,'361100','横峰县','361125'),(1342,'361100','弋阳县','361126'),(1343,'361100','余干县','361127'),(1344,'361100','鄱阳县','361128'),(1345,'361100','万年县','361129'),(1346,'361100','婺源县','361130'),(1347,'361100','德兴市','361181'),(1349,'370100','历下区','370102'),(1350,'370100','市中区','370103'),(1351,'370100','槐荫区','370104'),(1352,'370100','天桥区','370105'),(1353,'370100','历城区','370112'),(1354,'370100','长清区','370113'),(1355,'370100','平阴县','370124'),(1356,'370100','济阳县','370125'),(1357,'370100','商河县','370126'),(1358,'370100','章丘市','370181'),(1360,'370200','市南区','370202'),(1361,'370200','市北区','370203'),(1362,'370200','四方区','370205'),(1363,'370200','黄岛区','370211'),(1364,'370200','崂山区','370212'),(1365,'370200','李沧区','370213'),(1366,'370200','城阳区','370214'),(1367,'370200','胶州市','370281'),(1368,'370200','即墨市','370282'),(1369,'370200','平度市','370283'),(1370,'370200','胶南市','370284'),(1371,'370200','莱西市','370285'),(1373,'370300','淄川区','370302'),(1374,'370300','张店区','370303'),(1375,'370300','博山区','370304'),(1376,'370300','临淄区','370305'),(1377,'370300','周村区','370306'),(1378,'370300','桓台县','370321'),(1379,'370300','高青县','370322'),(1380,'370300','沂源县','370323'),(1382,'370400','市中区','370402'),(1383,'370400','薛城区','370403'),(1384,'370400','峄城区','370404'),(1385,'370400','台儿庄区','370405'),(1386,'370400','山亭区','370406'),(1387,'370400','滕州市','370481'),(1389,'370500','东营区','370502'),(1390,'370500','河口区','370503'),(1391,'370500','垦利县','370521'),(1392,'370500','利津县','370522'),(1393,'370500','广饶县','370523'),(1395,'370600','芝罘区','370602'),(1396,'370600','福山区','370611'),(1397,'370600','牟平区','370612'),(1398,'370600','莱山区','370613'),(1399,'370600','长岛县','370634'),(1400,'370600','龙口市','370681'),(1401,'370600','莱阳市','370682'),(1402,'370600','莱州市','370683'),(1403,'370600','蓬莱市','370684'),(1404,'370600','招远市','370685'),(1405,'370600','栖霞市','370686'),(1406,'370600','海阳市','370687'),(1408,'370700','潍城区','370702'),(1409,'370700','寒亭区','370703'),(1410,'370700','坊子区','370704'),(1411,'370700','奎文区','370705'),(1412,'370700','临朐县','370724'),(1413,'370700','昌乐县','370725'),(1414,'370700','青州市','370781'),(1415,'370700','诸城市','370782'),(1416,'370700','寿光市','370783'),(1417,'370700','安丘市','370784'),(1418,'370700','高密市','370785'),(1419,'370700','昌邑市','370786'),(1421,'370800','市中区','370802'),(1422,'370800','任城区','370811'),(1423,'370800','微山县','370826'),(1424,'370800','鱼台县','370827'),(1425,'370800','金乡县','370828'),(1426,'370800','嘉祥县','370829'),(1427,'370800','汶上县','370830'),(1428,'370800','泗水县','370831'),(1429,'370800','梁山县','370832'),(1430,'370800','曲阜市','370881'),(1431,'370800','兖州市','370882'),(1432,'370800','邹城市','370883'),(1434,'370900','泰山区','370902'),(1435,'370900','岱岳区','370903'),(1436,'370900','宁阳县','370921'),(1437,'370900','东平县','370923'),(1438,'370900','新泰市','370982'),(1439,'370900','肥城市','370983'),(1441,'371000','环翠区','371002'),(1442,'371000','文登市','371081'),(1443,'371000','荣成市','371082'),(1444,'371000','乳山市','371083'),(1446,'371100','东港区','371102'),(1447,'371100','岚山区','371103'),(1448,'371100','五莲县','371121'),(1449,'371100','莒　县','371122'),(1451,'371200','莱城区','371202'),(1452,'371200','钢城区','371203'),(1454,'371300','兰山区','371302'),(1455,'371300','罗庄区','371311'),(1456,'371300','河东区','371312'),(1457,'371300','沂南县','371321'),(1458,'371300','郯城县','371322'),(1459,'371300','沂水县','371323'),(1460,'371300','苍山县','371324'),(1461,'371300','费　县','371325'),(1462,'371300','平邑县','371326'),(1463,'371300','莒南县','371327'),(1464,'371300','蒙阴县','371328'),(1465,'371300','临沭县','371329'),(1467,'371400','德城区','371402'),(1468,'371400','陵　县','371421'),(1469,'371400','宁津县','371422'),(1470,'371400','庆云县','371423'),(1471,'371400','临邑县','371424'),(1472,'371400','齐河县','371425'),(1473,'371400','平原县','371426'),(1474,'371400','夏津县','371427'),(1475,'371400','武城县','371428'),(1476,'371400','乐陵市','371481'),(1477,'371400','禹城市','371482'),(1479,'371500','东昌府区','371502'),(1480,'371500','阳谷县','371521'),(1481,'371500','莘　县','371522'),(1482,'371500','茌平县','371523'),(1483,'371500','东阿县','371524'),(1484,'371500','冠　县','371525'),(1485,'371500','高唐县','371526'),(1486,'371500','临清市','371581'),(1488,'371600','滨城区','371602'),(1489,'371600','惠民县','371621'),(1490,'371600','阳信县','371622'),(1491,'371600','无棣县','371623'),(1492,'371600','沾化县','371624'),(1493,'371600','博兴县','371625'),(1494,'371600','邹平县','371626'),(1496,'371700','牡丹区','371702'),(1497,'371700','曹　县','371721'),(1498,'371700','单　县','371722'),(1499,'371700','成武县','371723'),(1500,'371700','巨野县','371724'),(1501,'371700','郓城县','371725'),(1502,'371700','鄄城县','371726'),(1503,'371700','定陶县','371727'),(1504,'371700','东明县','371728'),(1506,'410100','中原区','410102'),(1507,'410100','二七区','410103'),(1508,'410100','管城回族区','410104'),(1509,'410100','金水区','410105'),(1510,'410100','上街区','410106'),(1511,'410100','邙山区','410108'),(1512,'410100','中牟县','410122'),(1513,'410100','巩义市','410181'),(1514,'410100','荥阳市','410182'),(1515,'410100','新密市','410183'),(1516,'410100','新郑市','410184'),(1517,'410100','登封市','410185'),(1519,'410200','龙亭区','410202'),(1520,'410200','顺河回族区','410203'),(1521,'410200','鼓楼区','410204'),(1522,'410200','南关区','410205'),(1523,'410200','郊　区','410211'),(1524,'410200','杞　县','410221'),(1525,'410200','通许县','410222'),(1526,'410200','尉氏县','410223'),(1527,'410200','开封县','410224'),(1528,'410200','兰考县','410225'),(1530,'410300','老城区','410302'),(1531,'410300','西工区','410303'),(1532,'410300','廛河回族区','410304'),(1533,'410300','涧西区','410305'),(1534,'410300','吉利区','410306'),(1535,'410300','洛龙区','410307'),(1536,'410300','孟津县','410322'),(1537,'410300','新安县','410323'),(1538,'410300','栾川县','410324'),(1539,'410300','嵩　县','410325'),(1540,'410300','汝阳县','410326'),(1541,'410300','宜阳县','410327'),(1542,'410300','洛宁县','410328'),(1543,'410300','伊川县','410329'),(1544,'410300','偃师市','410381'),(1546,'410400','新华区','410402'),(1547,'410400','卫东区','410403'),(1548,'410400','石龙区','410404'),(1549,'410400','湛河区','410411'),(1550,'410400','宝丰县','410421'),(1551,'410400','叶　县','410422'),(1552,'410400','鲁山县','410423'),(1553,'410400','郏　县','410425'),(1554,'410400','舞钢市','410481'),(1555,'410400','汝州市','410482'),(1557,'410500','文峰区','410502'),(1558,'410500','北关区','410503'),(1559,'410500','殷都区','410505'),(1560,'410500','龙安区','410506'),(1561,'410500','安阳县','410522'),(1562,'410500','汤阴县','410523'),(1563,'410500','滑　县','410526'),(1564,'410500','内黄县','410527'),(1565,'410500','林州市','410581'),(1567,'410600','鹤山区','410602'),(1568,'410600','山城区','410603'),(1569,'410600','淇滨区','410611'),(1570,'410600','浚　县','410621'),(1571,'410600','淇　县','410622'),(1573,'410700','红旗区','410702'),(1574,'410700','卫滨区','410703'),(1575,'410700','凤泉区','410704'),(1576,'410700','牧野区','410711'),(1577,'410700','新乡县','410721'),(1578,'410700','获嘉县','410724'),(1579,'410700','原阳县','410725'),(1580,'410700','延津县','410726'),(1581,'410700','封丘县','410727'),(1582,'410700','长垣县','410728'),(1583,'410700','卫辉市','410781'),(1584,'410700','辉县市','410782'),(1586,'410800','解放区','410802'),(1587,'410800','中站区','410803'),(1588,'410800','马村区','410804'),(1589,'410800','山阳区','410811'),(1590,'410800','修武县','410821'),(1591,'410800','博爱县','410822'),(1592,'410800','武陟县','410823'),(1593,'410800','温　县','410825'),(1595,'410800','沁阳市','410882'),(1596,'410800','孟州市','410883'),(1598,'410900','华龙区','410902'),(1599,'410900','清丰县','410922'),(1600,'410900','南乐县','410923'),(1601,'410900','范　县','410926'),(1602,'410900','台前县','410927'),(1603,'410900','濮阳县','410928'),(1605,'411000','魏都区','411002'),(1606,'411000','许昌县','411023'),(1607,'411000','鄢陵县','411024'),(1608,'411000','襄城县','411025'),(1609,'411000','禹州市','411081'),(1610,'411000','长葛市','411082'),(1612,'411100','源汇区','411102'),(1613,'411100','郾城区','411103'),(1614,'411100','召陵区','411104'),(1615,'411100','舞阳县','411121'),(1616,'411100','临颍县','411122'),(1618,'411200','湖滨区','411202'),(1619,'411200','渑池县','411221'),(1620,'411200','陕　县','411222'),(1621,'411200','卢氏县','411224'),(1622,'411200','义马市','411281'),(1623,'411200','灵宝市','411282'),(1625,'411300','宛城区','411302'),(1626,'411300','卧龙区','411303'),(1627,'411300','南召县','411321'),(1628,'411300','方城县','411322'),(1629,'411300','西峡县','411323'),(1630,'411300','镇平县','411324'),(1631,'411300','内乡县','411325'),(1632,'411300','淅川县','411326'),(1633,'411300','社旗县','411327'),(1634,'411300','唐河县','411328'),(1635,'411300','新野县','411329'),(1636,'411300','桐柏县','411330'),(1637,'411300','邓州市','411381'),(1639,'411400','梁园区','411402'),(1640,'411400','睢阳区','411403'),(1641,'411400','民权县','411421'),(1642,'411400','睢　县','411422'),(1643,'411400','宁陵县','411423'),(1644,'411400','柘城县','411424'),(1645,'411400','虞城县','411425'),(1646,'411400','夏邑县','411426'),(1647,'411400','永城市','411481'),(1649,'411500','浉河区','411502'),(1650,'411500','平桥区','411503'),(1651,'411500','罗山县','411521'),(1652,'411500','光山县','411522'),(1653,'411500','新　县','411523'),(1654,'411500','商城县','411524'),(1655,'411500','固始县','411525'),(1656,'411500','潢川县','411526'),(1657,'411500','淮滨县','411527'),(1658,'411500','息　县','411528'),(1660,'411600','川汇区','411602'),(1661,'411600','扶沟县','411621'),(1662,'411600','西华县','411622'),(1663,'411600','商水县','411623'),(1664,'411600','沈丘县','411624'),(1665,'411600','郸城县','411625'),(1666,'411600','淮阳县','411626'),(1667,'411600','太康县','411627'),(1668,'411600','鹿邑县','411628'),(1669,'411600','项城市','411681'),(1671,'411700','驿城区','411702'),(1672,'411700','西平县','411721'),(1673,'411700','上蔡县','411722'),(1674,'411700','平舆县','411723'),(1675,'411700','正阳县','411724'),(1676,'411700','确山县','411725'),(1677,'411700','泌阳县','411726'),(1678,'411700','汝南县','411727'),(1679,'411700','遂平县','411728'),(1680,'411700','新蔡县','411729'),(1682,'420100','江岸区','420102'),(1683,'420100','江汉区','420103'),(1684,'420100','硚口区','420104'),(1685,'420100','汉阳区','420105'),(1686,'420100','武昌区','420106'),(1687,'420100','青山区','420107'),(1688,'420100','洪山区','420111'),(1689,'420100','东西湖区','420112'),(1690,'420100','汉南区','420113'),(1691,'420100','蔡甸区','420114'),(1692,'420100','江夏区','420115'),(1693,'420100','黄陂区','420116'),(1694,'420100','新洲区','420117'),(1696,'420200','黄石港区','420202'),(1697,'420200','西塞山区','420203'),(1698,'420200','下陆区','420204'),(1699,'420200','铁山区','420205'),(1700,'420200','阳新县','420222'),(1701,'420200','大冶市','420281'),(1703,'420300','茅箭区','420302'),(1704,'420300','张湾区','420303'),(1705,'420300','郧　县','420321'),(1706,'420300','郧西县','420322'),(1707,'420300','竹山县','420323'),(1708,'420300','竹溪县','420324'),(1709,'420300','房　县','420325'),(1710,'420300','丹江口市','420381'),(1712,'420500','西陵区','420502'),(1713,'420500','伍家岗区','420503'),(1714,'420500','点军区','420504'),(1715,'420500','猇亭区','420505'),(1716,'420500','夷陵区','420506'),(1717,'420500','远安县','420525'),(1718,'420500','兴山县','420526'),(1719,'420500','秭归县','420527'),(1720,'420500','长阳土家族自治县','420528'),(1721,'420500','五峰土家族自治县','420529'),(1722,'420500','宜都市','420581'),(1723,'420500','当阳市','420582'),(1724,'420500','枝江市','420583'),(1726,'420600','襄城区','420602'),(1727,'420600','樊城区','420606'),(1728,'420600','襄阳区','420607'),(1729,'420600','南漳县','420624'),(1730,'420600','谷城县','420625'),(1731,'420600','保康县','420626'),(1732,'420600','老河口市','420682'),(1733,'420600','枣阳市','420683'),(1734,'420600','宜城市','420684'),(1736,'420700','梁子湖区','420702'),(1737,'420700','华容区','420703'),(1738,'420700','鄂城区','420704'),(1740,'420800','东宝区','420802'),(1741,'420800','掇刀区','420804'),(1742,'420800','京山县','420821'),(1743,'420800','沙洋县','420822'),(1744,'420800','钟祥市','420881'),(1746,'420900','孝南区','420902'),(1747,'420900','孝昌县','420921'),(1748,'420900','大悟县','420922'),(1749,'420900','云梦县','420923'),(1750,'420900','应城市','420981'),(1751,'420900','安陆市','420982'),(1752,'420900','汉川市','420984'),(1754,'421000','沙市区','421002'),(1755,'421000','荆州区','421003'),(1756,'421000','公安县','421022'),(1757,'421000','监利县','421023'),(1758,'421000','江陵县','421024'),(1759,'421000','石首市','421081'),(1760,'421000','洪湖市','421083'),(1761,'421000','松滋市','421087'),(1763,'421100','黄州区','421102'),(1764,'421100','团风县','421121'),(1765,'421100','红安县','421122'),(1766,'421100','罗田县','421123'),(1767,'421100','英山县','421124'),(1768,'421100','浠水县','421125'),(1769,'421100','蕲春县','421126'),(1770,'421100','黄梅县','421127'),(1771,'421100','麻城市','421181'),(1772,'421100','武穴市','421182'),(1774,'421200','咸安区','421202'),(1775,'421200','嘉鱼县','421221'),(1776,'421200','通城县','421222'),(1777,'421200','崇阳县','421223'),(1778,'421200','通山县','421224'),(1779,'421200','赤壁市','421281'),(1781,'421300','曾都区','421302'),(1782,'421300','广水市','421381'),(1783,'422800','恩施市','422801'),(1784,'422800','利川市','422802'),(1785,'422800','建始县','422822'),(1786,'422800','巴东县','422823'),(1787,'422800','宣恩县','422825'),(1788,'422800','咸丰县','422826'),(1789,'422800','来凤县','422827'),(1790,'422800','鹤峰县','422828'),(1791,'429000','仙桃','429004'),(1792,'429100','潜江','429101'),(1793,'429200','天门','429201'),(1794,'429300','神农架','429301'),(1796,'430100','芙蓉区','430102'),(1797,'430100','天心区','430103'),(1798,'430100','岳麓区','430104'),(1799,'430100','开福区','430105'),(1800,'430100','雨花区','430111'),(1801,'430100','长沙县','430121'),(1802,'430100','望城县','430122'),(1803,'430100','宁乡县','430124'),(1804,'430100','浏阳市','430181'),(1806,'430200','荷塘区','430202'),(1807,'430200','芦淞区','430203'),(1808,'430200','石峰区','430204'),(1809,'430200','天元区','430211'),(1810,'430200','株洲县','430221'),(1811,'430200','攸　县','430223'),(1812,'430200','茶陵县','430224'),(1813,'430200','炎陵县','430225'),(1814,'430200','醴陵市','430281'),(1816,'430300','雨湖区','430302'),(1817,'430300','岳塘区','430304'),(1818,'430300','湘潭县','430321'),(1819,'430300','湘乡市','430381'),(1820,'430300','韶山市','430382'),(1822,'430400','珠晖区','430405'),(1823,'430400','雁峰区','430406'),(1824,'430400','石鼓区','430407'),(1825,'430400','蒸湘区','430408'),(1826,'430400','南岳区','430412'),(1827,'430400','衡阳县','430421'),(1828,'430400','衡南县','430422'),(1829,'430400','衡山县','430423'),(1830,'430400','衡东县','430424'),(1831,'430400','祁东县','430426'),(1832,'430400','耒阳市','430481'),(1833,'430400','常宁市','430482'),(1835,'430500','双清区','430502'),(1836,'430500','大祥区','430503'),(1837,'430500','北塔区','430511'),(1838,'430500','邵东县','430521'),(1839,'430500','新邵县','430522'),(1840,'430500','邵阳县','430523'),(1841,'430500','隆回县','430524'),(1842,'430500','洞口县','430525'),(1843,'430500','绥宁县','430527'),(1844,'430500','新宁县','430528'),(1845,'430500','城步苗族自治县','430529'),(1846,'430500','武冈市','430581'),(1848,'430600','岳阳楼区','430602'),(1849,'430600','云溪区','430603'),(1850,'430600','君山区','430611'),(1851,'430600','岳阳县','430621'),(1852,'430600','华容县','430623'),(1853,'430600','湘阴县','430624'),(1854,'430600','平江县','430626'),(1855,'430600','汨罗市','430681'),(1856,'430600','临湘市','430682'),(1858,'430700','武陵区','430702'),(1859,'430700','鼎城区','430703'),(1860,'430700','安乡县','430721'),(1861,'430700','汉寿县','430722'),(1862,'430700','澧　县','430723'),(1863,'430700','临澧县','430724'),(1864,'430700','桃源县','430725'),(1865,'430700','石门县','430726'),(1866,'430700','津市市','430781'),(1868,'430800','永定区','430802'),(1869,'430800','武陵源区','430811'),(1870,'430800','慈利县','430821'),(1871,'430800','桑植县','430822'),(1873,'430900','资阳区','430902'),(1874,'430900','赫山区','430903'),(1875,'430900','南　县','430921'),(1876,'430900','桃江县','430922'),(1877,'430900','安化县','430923'),(1878,'430900','沅江市','430981'),(1880,'431000','北湖区','431002'),(1881,'431000','苏仙区','431003'),(1882,'431000','桂阳县','431021'),(1883,'431000','宜章县','431022'),(1884,'431000','永兴县','431023'),(1885,'431000','嘉禾县','431024'),(1886,'431000','临武县','431025'),(1887,'431000','汝城县','431026'),(1888,'431000','桂东县','431027'),(1889,'431000','安仁县','431028'),(1890,'431000','资兴市','431081'),(1892,'431100','芝山区','431102'),(1893,'431100','冷水滩区','431103'),(1894,'431100','祁阳县','431121'),(1895,'431100','东安县','431122'),(1896,'431100','双牌县','431123'),(1897,'431100','道　县','431124'),(1898,'431100','江永县','431125'),(1899,'431100','宁远县','431126'),(1900,'431100','蓝山县','431127'),(1901,'431100','新田县','431128'),(1902,'431100','江华瑶族自治县','431129'),(1904,'431200','鹤城区','431202'),(1905,'431200','中方县','431221'),(1906,'431200','沅陵县','431222'),(1907,'431200','辰溪县','431223'),(1908,'431200','溆浦县','431224'),(1909,'431200','会同县','431225'),(1910,'431200','麻阳苗族自治县','431226'),(1911,'431200','新晃侗族自治县','431227'),(1912,'431200','芷江侗族自治县','431228'),(1913,'431200','靖州苗族侗族自治县','431229'),(1914,'431200','通道侗族自治县','431230'),(1915,'431200','洪江市','431281'),(1917,'431300','娄星区','431302'),(1918,'431300','双峰县','431321'),(1919,'431300','新化县','431322'),(1920,'431300','冷水江市','431381'),(1921,'431300','涟源市','431382'),(1922,'433100','吉首市','433101'),(1923,'433100','泸溪县','433122'),(1924,'433100','凤凰县','433123'),(1925,'433100','花垣县','433124'),(1926,'433100','保靖县','433125'),(1927,'433100','古丈县','433126'),(1928,'433100','永顺县','433127'),(1929,'433100','龙山县','433130'),(1931,'440100','东山区','440102'),(1932,'440100','荔湾区','440103'),(1933,'440100','越秀区','440104'),(1934,'440100','海珠区','440105'),(1935,'440100','天河区','440106'),(1936,'440100','芳村区','440107'),(1937,'440100','白云区','440111'),(1938,'440100','黄埔区','440112'),(1939,'440100','番禺区','440113'),(1940,'440100','花都区','440114'),(1941,'440100','增城市','440183'),(1942,'440100','从化市','440184'),(1944,'440200','武江区','440203'),(1945,'440200','浈江区','440204'),(1946,'440200','曲江区','440205'),(1947,'440200','始兴县','440222'),(1948,'440200','仁化县','440224'),(1949,'440200','翁源县','440229'),(1950,'440200','乳源瑶族自治县','440232'),(1951,'440200','新丰县','440233'),(1952,'440200','乐昌市','440281'),(1953,'440200','南雄市','440282'),(1955,'440300','罗湖区','440303'),(1956,'440300','福田区','440304'),(1957,'440300','南山区','440305'),(1958,'440300','宝安区','440306'),(1959,'440300','龙岗区','440307'),(1960,'440300','盐田区','440308'),(1962,'440400','香洲区','440402'),(1963,'440400','斗门区','440403'),(1964,'440400','金湾区','440404'),(1966,'440500','龙湖区','440507'),(1967,'440500','金平区','440511'),(1968,'440500','濠江区','440512'),(1969,'440500','潮阳区','440513'),(1970,'440500','潮南区','440514'),(1971,'440500','澄海区','440515'),(1972,'440500','南澳县','440523'),(1974,'440600','禅城区','440604'),(1975,'440600','南海区','440605'),(1976,'440600','顺德区','440606'),(1977,'440600','三水区','440607'),(1978,'440600','高明区','440608'),(1980,'440700','蓬江区','440703'),(1981,'440700','江海区','440704'),(1982,'440700','新会区','440705'),(1983,'440700','台山市','440781'),(1984,'440700','开平市','440783'),(1985,'440700','鹤山市','440784'),(1986,'440700','恩平市','440785'),(1988,'440800','赤坎区','440802'),(1989,'440800','霞山区','440803'),(1990,'440800','坡头区','440804'),(1991,'440800','麻章区','440811'),(1992,'440800','遂溪县','440823'),(1993,'440800','徐闻县','440825'),(1994,'440800','廉江市','440881'),(1995,'440800','雷州市','440882'),(1996,'440800','吴川市','440883'),(1998,'440900','茂南区','440902'),(1999,'440900','茂港区','440903'),(2000,'440900','电白县','440923'),(2001,'440900','高州市','440981'),(2002,'440900','化州市','440982'),(2003,'440900','信宜市','440983'),(2005,'441200','端州区','441202'),(2006,'441200','鼎湖区','441203'),(2007,'441200','广宁县','441223'),(2008,'441200','怀集县','441224'),(2009,'441200','封开县','441225'),(2010,'441200','德庆县','441226'),(2011,'441200','高要市','441283'),(2012,'441200','四会市','441284'),(2014,'441300','惠城区','441302'),(2015,'441300','惠阳区','441303'),(2016,'441300','博罗县','441322'),(2017,'441300','惠东县','441323'),(2018,'441300','龙门县','441324'),(2020,'441400','梅江区','441402'),(2021,'441400','梅　县','441421'),(2022,'441400','大埔县','441422'),(2023,'441400','丰顺县','441423'),(2024,'441400','五华县','441424'),(2025,'441400','平远县','441426'),(2026,'441400','蕉岭县','441427'),(2027,'441400','兴宁市','441481'),(2029,'441500','城　区','441502'),(2030,'441500','海丰县','441521'),(2031,'441500','陆河县','441523'),(2032,'441500','陆丰市','441581'),(2034,'441600','源城区','441602'),(2035,'441600','紫金县','441621'),(2036,'441600','龙川县','441622'),(2037,'441600','连平县','441623'),(2038,'441600','和平县','441624'),(2039,'441600','东源县','441625'),(2041,'441700','江城区','441702'),(2042,'441700','阳西县','441721'),(2043,'441700','阳东县','441723'),(2044,'441700','阳春市','441781'),(2046,'441800','清城区','441802'),(2047,'441800','佛冈县','441821'),(2048,'441800','阳山县','441823'),(2049,'441800','连山壮族瑶族自治县','441825'),(2050,'441800','连南瑶族自治县','441826'),(2051,'441800','清新县','441827'),(2052,'441800','英德市','441881'),(2053,'441800','连州市','441882'),(2055,'445100','湘桥区','445102'),(2056,'445100','潮安县','445121'),(2057,'445100','饶平县','445122'),(2059,'445200','榕城区','445202'),(2060,'445200','揭东县','445221'),(2061,'445200','揭西县','445222'),(2062,'445200','惠来县','445224'),(2063,'445200','普宁市','445281'),(2065,'445300','云城区','445302'),(2066,'445300','新兴县','445321'),(2067,'445300','郁南县','445322'),(2068,'445300','云安县','445323'),(2069,'445300','罗定市','445381'),(2071,'450100','兴宁区','450102'),(2072,'450100','青秀区','450103'),(2073,'450100','江南区','450105'),(2074,'450100','西乡塘区','450107'),(2075,'450100','良庆区','450108'),(2076,'450100','邕宁区','450109'),(2077,'450100','武鸣县','450122'),(2078,'450100','隆安县','450123'),(2079,'450100','马山县','450124'),(2080,'450100','上林县','450125'),(2081,'450100','宾阳县','450126'),(2082,'450100','横　县','450127'),(2084,'450200','城中区','450202'),(2085,'450200','鱼峰区','450203'),(2086,'450200','柳南区','450204'),(2087,'450200','柳北区','450205'),(2088,'450200','柳江县','450221'),(2089,'450200','柳城县','450222'),(2090,'450200','鹿寨县','450223'),(2091,'450200','融安县','450224'),(2092,'450200','融水苗族自治县','450225'),(2093,'450200','三江侗族自治县','450226'),(2095,'450300','秀峰区','450302'),(2096,'450300','叠彩区','450303'),(2097,'450300','象山区','450304'),(2098,'450300','七星区','450305'),(2099,'450300','雁山区','450311'),(2100,'450300','阳朔县','450321'),(2101,'450300','临桂县','450322'),(2102,'450300','灵川县','450323'),(2103,'450300','全州县','450324'),(2104,'450300','兴安县','450325'),(2105,'450300','永福县','450326'),(2106,'450300','灌阳县','450327'),(2107,'450300','龙胜各族自治县','450328'),(2108,'450300','资源县','450329'),(2109,'450300','平乐县','450330'),(2110,'450300','荔蒲县','450331'),(2111,'450300','恭城瑶族自治县','450332'),(2113,'450400','万秀区','450403'),(2114,'450400','蝶山区','450404'),(2115,'450400','长洲区','450405'),(2116,'450400','苍梧县','450421'),(2117,'450400','藤　县','450422'),(2118,'450400','蒙山县','450423'),(2119,'450400','岑溪市','450481'),(2121,'450500','海城区','450502'),(2122,'450500','银海区','450503'),(2123,'450500','铁山港区','450512'),(2124,'450500','合浦县','450521'),(2126,'450600','港口区','450602'),(2127,'450600','防城区','450603'),(2128,'450600','上思县','450621'),(2129,'450600','东兴市','450681'),(2131,'450700','钦南区','450702'),(2132,'450700','钦北区','450703'),(2133,'450700','灵山县','450721'),(2134,'450700','浦北县','450722'),(2136,'450800','港北区','450802'),(2137,'450800','港南区','450803'),(2138,'450800','覃塘区','450804'),(2139,'450800','平南县','450821'),(2140,'450800','桂平市','450881'),(2142,'450900','玉州区','450902'),(2143,'450900','容　县','450921'),(2144,'450900','陆川县','450922'),(2145,'450900','博白县','450923'),(2146,'450900','兴业县','450924'),(2147,'450900','北流市','450981'),(2149,'451000','右江区','451002'),(2150,'451000','田阳县','451021'),(2151,'451000','田东县','451022'),(2152,'451000','平果县','451023'),(2153,'451000','德保县','451024'),(2154,'451000','靖西县','451025'),(2155,'451000','那坡县','451026'),(2156,'451000','凌云县','451027'),(2157,'451000','乐业县','451028'),(2158,'451000','田林县','451029'),(2159,'451000','西林县','451030'),(2160,'451000','隆林各族自治县','451031'),(2162,'451100','八步区','451102'),(2163,'451100','昭平县','451121'),(2164,'451100','钟山县','451122'),(2165,'451100','富川瑶族自治县','451123'),(2167,'451200','金城江区','451202'),(2168,'451200','南丹县','451221'),(2169,'451200','天峨县','451222'),(2170,'451200','凤山县','451223'),(2171,'451200','东兰县','451224'),(2172,'451200','罗城仫佬族自治县','451225'),(2173,'451200','环江毛南族自治县','451226'),(2174,'451200','巴马瑶族自治县','451227'),(2175,'451200','都安瑶族自治县','451228'),(2176,'451200','大化瑶族自治县','451229'),(2177,'451200','宜州市','451281'),(2179,'451300','兴宾区','451302'),(2180,'451300','忻城县','451321'),(2181,'451300','象州县','451322'),(2182,'451300','武宣县','451323'),(2183,'451300','金秀瑶族自治县','451324'),(2184,'451300','合山市','451381'),(2186,'451400','江洲区','451402'),(2187,'451400','扶绥县','451421'),(2188,'451400','宁明县','451422'),(2189,'451400','龙州县','451423'),(2190,'451400','大新县','451424'),(2191,'451400','天等县','451425'),(2192,'451400','凭祥市','451481'),(2194,'460100','秀英区','460105'),(2195,'460100','龙华区','460106'),(2196,'460100','琼山区','460107'),(2197,'460100','美兰区','460108'),(2199,'469000','五指山市','469001'),(2200,'469000','琼海市','469002'),(2201,'469000','儋州市','469003'),(2202,'469000','文昌市','469005'),(2203,'469000','万宁市','469006'),(2204,'469000','东方市','469007'),(2205,'469000','定安县','469025'),(2206,'469000','屯昌县','469026'),(2207,'469000','澄迈县','469027'),(2208,'469000','临高县','469028'),(2209,'469000','白沙黎族自治县','469030'),(2210,'469000','昌江黎族自治县','469031'),(2211,'469000','乐东黎族自治县','469033'),(2212,'469000','陵水黎族自治县','469034'),(2213,'469000','保亭黎族苗族自治县','469035'),(2214,'469000','琼中黎族苗族自治县','469036'),(2215,'460200','西沙群岛','469037'),(2216,'460200','南沙群岛','469038'),(2217,'469000','中沙群岛的岛礁及其海域','469039'),(2218,'500100','万州区','500101'),(2219,'500100','涪陵区','500102'),(2220,'500100','渝中区','500103'),(2221,'500100','大渡口区','500104'),(2222,'500100','江北区','500105'),(2223,'500100','沙坪坝区','500106'),(2224,'500100','九龙坡区','500107'),(2225,'500100','南岸区','500108'),(2226,'500100','北碚区','500109'),(2227,'500100','万盛区','500110'),(2228,'500100','双桥区','500111'),(2229,'500100','渝北区','500112'),(2230,'500100','巴南区','500113'),(2231,'500100','黔江区','500114'),(2232,'500100','长寿区','500115'),(2233,'500100','綦江区','500222'),(2234,'500100','潼南县','500223'),(2235,'500100','铜梁县','500224'),(2236,'500100','大足县','500225'),(2237,'500100','荣昌县','500226'),(2238,'500100','璧山县','500227'),(2239,'500100','梁平县','500228'),(2240,'500100','城口县','500229'),(2241,'500100','丰都县','500230'),(2242,'500100','垫江县','500231'),(2243,'500100','武隆县','500232'),(2244,'500100','忠　县','500233'),(2245,'500100','开　县','500234'),(2246,'500100','云阳县','500235'),(2247,'500100','奉节县','500236'),(2248,'500100','巫山县','500237'),(2249,'500100','巫溪县','500238'),(2250,'500100','石柱土家族自治县','500240'),(2251,'500100','秀山土家族苗族自治县','500241'),(2252,'500100','酉阳土家族苗族自治县','500242'),(2253,'500100','彭水苗族土家族自治县','500243'),(2254,'500100','江津区','500381'),(2255,'500100','合川区','500382'),(2256,'500100','永川区','500383'),(2257,'500100','南川区','500384'),(2259,'510100','锦江区','510104'),(2260,'510100','青羊区','510105'),(2261,'510100','金牛区','510106'),(2262,'510100','武侯区','510107'),(2263,'510100','成华区','510108'),(2264,'510100','龙泉驿区','510112'),(2265,'510100','青白江区','510113'),(2266,'510100','新都区','510114'),(2267,'510100','温江县','510115'),(2268,'510100','金堂县','510121'),(2269,'510100','双流县','510122'),(2270,'510100','郫　县','510124'),(2271,'510100','大邑县','510129'),(2272,'510100','蒲江县','510131'),(2273,'510100','新津县','510132'),(2274,'510100','都江堰市','510181'),(2275,'510100','彭州市','510182'),(2276,'510100','邛崃市','510183'),(2277,'510100','崇州市','510184'),(2279,'510300','自流井区','510302'),(2280,'510300','贡井区','510303'),(2281,'510300','大安区','510304'),(2282,'510300','沿滩区','510311'),(2283,'510300','荣　县','510321'),(2284,'510300','富顺县','510322'),(2286,'510400','东　区','510402'),(2287,'510400','西　区','510403'),(2288,'510400','仁和区','510411'),(2289,'510400','米易县','510421'),(2290,'510400','盐边县','510422'),(2292,'510500','江阳区','510502'),(2293,'510500','纳溪区','510503'),(2294,'510500','龙马潭区','510504'),(2295,'510500','泸　县','510521'),(2296,'510500','合江县','510522'),(2297,'510500','叙永县','510524'),(2298,'510500','古蔺县','510525'),(2300,'510600','旌阳区','510603'),(2301,'510600','中江县','510623'),(2302,'510600','罗江县','510626'),(2303,'510600','广汉市','510681'),(2304,'510600','什邡市','510682'),(2305,'510600','绵竹市','510683'),(2307,'510700','涪城区','510703'),(2308,'510700','游仙区','510704'),(2309,'510700','三台县','510722'),(2310,'510700','盐亭县','510723'),(2311,'510700','安　县','510724'),(2312,'510700','梓潼县','510725'),(2313,'510700','北川羌族自治县','510726'),(2314,'510700','平武县','510727'),(2315,'510700','江油市','510781'),(2317,'510800','市中区','510802'),(2318,'510800','元坝区','510811'),(2319,'510800','朝天区','510812'),(2320,'510800','旺苍县','510821'),(2321,'510800','青川县','510822'),(2322,'510800','剑阁县','510823'),(2323,'510800','苍溪县','510824'),(2325,'510900','船山区','510903'),(2326,'510900','安居区','510904'),(2327,'510900','蓬溪县','510921'),(2328,'510900','射洪县','510922'),(2329,'510900','大英县','510923'),(2331,'511000','市中区','511002'),(2332,'511000','东兴区','511011'),(2333,'511000','威远县','511024'),(2334,'511000','资中县','511025'),(2335,'511000','隆昌县','511028'),(2337,'511100','市中区','511102'),(2338,'511100','沙湾区','511111'),(2339,'511100','五通桥区','511112'),(2340,'511100','金口河区','511113'),(2341,'511100','犍为县','511123'),(2342,'511100','井研县','511124'),(2343,'511100','夹江县','511126'),(2344,'511100','沐川县','511129'),(2345,'511100','峨边彝族自治县','511132'),(2346,'511100','马边彝族自治县','511133'),(2347,'511100','峨眉山市','511181'),(2349,'511300','顺庆区','511302'),(2350,'511300','高坪区','511303'),(2351,'511300','嘉陵区','511304'),(2352,'511300','南部县','511321'),(2353,'511300','营山县','511322'),(2354,'511300','蓬安县','511323'),(2355,'511300','仪陇县','511324'),(2356,'511300','西充县','511325'),(2357,'511300','阆中市','511381'),(2359,'511400','东坡区','511402'),(2360,'511400','仁寿县','511421'),(2361,'511400','彭山县','511422'),(2362,'511400','洪雅县','511423'),(2363,'511400','丹棱县','511424'),(2364,'511400','青神县','511425'),(2366,'511500','翠屏区','511502'),(2367,'511500','宜宾县','511521'),(2368,'511500','南溪县','511522'),(2369,'511500','江安县','511523'),(2370,'511500','长宁县','511524'),(2371,'511500','高　县','511525'),(2372,'511500','珙　县','511526'),(2373,'511500','筠连县','511527'),(2374,'511500','兴文县','511528'),(2375,'511500','屏山县','511529'),(2377,'511600','广安区','511602'),(2378,'511600','岳池县','511621'),(2379,'511600','武胜县','511622'),(2380,'511600','邻水县','511623'),(2381,'511600','华蓥市','511681'),(2383,'511700','通川区','511702'),(2384,'511700','达　县','511721'),(2385,'511700','宣汉县','511722'),(2386,'511700','开江县','511723'),(2387,'511700','大竹县','511724'),(2388,'511700','渠　县','511725'),(2389,'511700','万源市','511781'),(2391,'511800','雨城区','511802'),(2392,'511800','名山县','511821'),(2393,'511800','荥经县','511822'),(2394,'511800','汉源县','511823'),(2395,'511800','石棉县','511824'),(2396,'511800','天全县','511825'),(2397,'511800','芦山县','511826'),(2398,'511800','宝兴县','511827'),(2400,'511900','巴州区','511902'),(2401,'511900','通江县','511921'),(2402,'511900','南江县','511922'),(2403,'511900','平昌县','511923'),(2405,'512000','雁江区','512002'),(2406,'512000','安岳县','512021'),(2407,'512000','乐至县','512022'),(2408,'512000','简阳市','512081'),(2409,'513200','汶川县','513221'),(2410,'513200','理　县','513222'),(2411,'513200','茂　县','513223'),(2412,'513200','松潘县','513224'),(2413,'513200','九寨沟县','513225'),(2414,'513200','金川县','513226'),(2415,'513200','小金县','513227'),(2416,'513200','黑水县','513228'),(2417,'513200','马尔康县','513229'),(2418,'513200','壤塘县','513230'),(2419,'513200','阿坝县','513231'),(2420,'513200','若尔盖县','513232'),(2421,'513200','红原县','513233'),(2422,'513300','康定县','513321'),(2423,'513300','泸定县','513322'),(2424,'513300','丹巴县','513323'),(2425,'513300','九龙县','513324'),(2426,'513300','雅江县','513325'),(2427,'513300','道孚县','513326'),(2428,'513300','炉霍县','513327'),(2429,'513300','甘孜县','513328'),(2430,'513300','新龙县','513329'),(2431,'513300','德格县','513330'),(2432,'513300','白玉县','513331'),(2433,'513300','石渠县','513332'),(2434,'513300','色达县','513333'),(2435,'513300','理塘县','513334'),(2436,'513300','巴塘县','513335'),(2437,'513300','乡城县','513336'),(2438,'513300','稻城县','513337'),(2439,'513300','得荣县','513338'),(2440,'513400','西昌市','513401'),(2441,'513400','木里藏族自治县','513422'),(2442,'513400','盐源县','513423'),(2443,'513400','德昌县','513424'),(2444,'513400','会理县','513425'),(2445,'513400','会东县','513426'),(2446,'513400','宁南县','513427'),(2447,'513400','普格县','513428'),(2448,'513400','布拖县','513429'),(2449,'513400','金阳县','513430'),(2450,'513400','昭觉县','513431'),(2451,'513400','喜德县','513432'),(2452,'513400','冕宁县','513433'),(2453,'513400','越西县','513434'),(2454,'513400','甘洛县','513435'),(2455,'513400','美姑县','513436'),(2456,'513400','雷波县','513437'),(2458,'520100','南明区','520102'),(2459,'520100','云岩区','520103'),(2460,'520100','花溪区','520111'),(2461,'520100','乌当区','520112'),(2462,'520100','白云区','520113'),(2463,'520100','小河区','520114'),(2464,'520100','开阳县','520121'),(2465,'520100','息烽县','520122'),(2466,'520100','修文县','520123'),(2467,'520100','清镇市','520181'),(2468,'520200','钟山区','520201'),(2469,'520200','六枝特区','520203'),(2470,'520200','水城县','520221'),(2471,'520200','盘　县','520222'),(2473,'520300','红花岗区','520302'),(2474,'520300','汇川区','520303'),(2475,'520300','遵义县','520321'),(2476,'520300','桐梓县','520322'),(2477,'520300','绥阳县','520323'),(2478,'520300','正安县','520324'),(2479,'520300','道真仡佬族苗族自治县','520325'),(2480,'520300','务川仡佬族苗族自治县','520326'),(2481,'520300','凤冈县','520327'),(2482,'520300','湄潭县','520328'),(2483,'520300','余庆县','520329'),(2484,'520300','习水县','520330'),(2485,'520300','赤水市','520381'),(2486,'520300','仁怀市','520382'),(2488,'520400','西秀区','520402'),(2489,'520400','平坝县','520421'),(2490,'520400','普定县','520422'),(2491,'520400','镇宁布依族苗族自治县','520423'),(2492,'520400','关岭布依族苗族自治县','520424'),(2493,'520400','紫云苗族布依族自治县','520425'),(2494,'522200','铜仁市','522201'),(2495,'522200','江口县','522222'),(2496,'522200','玉屏侗族自治县','522223'),(2497,'522200','石阡县','522224'),(2498,'522200','思南县','522225'),(2499,'522200','印江土家族苗族自治县','522226'),(2500,'522200','德江县','522227'),(2501,'522200','沿河土家族自治县','522228'),(2502,'522200','松桃苗族自治县','522229'),(2503,'522200','万山特区','522230'),(2504,'522300','兴义市','522301'),(2505,'522300','兴仁县','522322'),(2506,'522300','普安县','522323'),(2507,'522300','晴隆县','522324'),(2508,'522300','贞丰县','522325'),(2509,'522300','望谟县','522326'),(2510,'522300','册亨县','522327'),(2511,'522300','安龙县','522328'),(2512,'522400','毕节市','522401'),(2513,'522400','大方县','522422'),(2514,'522400','黔西县','522423'),(2515,'522400','金沙县','522424'),(2516,'522400','织金县','522425'),(2517,'522400','纳雍县','522426'),(2518,'522400','威宁彝族回族苗族自治县','522427'),(2519,'522400','赫章县','522428'),(2520,'522600','凯里市','522601'),(2521,'522600','黄平县','522622'),(2522,'522600','施秉县','522623'),(2523,'522600','三穗县','522624'),(2524,'522600','镇远县','522625'),(2525,'522600','岑巩县','522626'),(2526,'522600','天柱县','522627'),(2527,'522600','锦屏县','522628'),(2528,'522600','剑河县','522629'),(2529,'522600','台江县','522630'),(2530,'522600','黎平县','522631'),(2531,'522600','榕江县','522632'),(2532,'522600','从江县','522633'),(2533,'522600','雷山县','522634'),(2534,'522600','麻江县','522635'),(2535,'522600','丹寨县','522636'),(2536,'522700','都匀市','522701'),(2537,'522700','福泉市','522702'),(2538,'522700','荔波县','522722'),(2539,'522700','贵定县','522723'),(2540,'522700','瓮安县','522725'),(2541,'522700','独山县','522726'),(2542,'522700','平塘县','522727'),(2543,'522700','罗甸县','522728'),(2544,'522700','长顺县','522729'),(2545,'522700','龙里县','522730'),(2546,'522700','惠水县','522731'),(2547,'522700','三都水族自治县','522732'),(2549,'530100','五华区','530102'),(2550,'530100','盘龙区','530103'),(2551,'530100','官渡区','530111'),(2552,'530100','西山区','530112'),(2553,'530100','东川区','530113'),(2554,'530100','呈贡县','530121'),(2555,'530100','晋宁县','530122'),(2556,'530100','富民县','530124'),(2557,'530100','宜良县','530125'),(2558,'530100','石林彝族自治县','530126'),(2559,'530100','嵩明县','530127'),(2560,'530100','禄劝彝族苗族自治县','530128'),(2561,'530100','寻甸回族彝族自治县','530129'),(2562,'530100','安宁市','530181'),(2564,'530300','麒麟区','530302'),(2565,'530300','马龙县','530321'),(2566,'530300','陆良县','530322'),(2567,'530300','师宗县','530323'),(2568,'530300','罗平县','530324'),(2569,'530300','富源县','530325'),(2570,'530300','会泽县','530326'),(2571,'530300','沾益县','530328'),(2572,'530300','宣威市','530381'),(2574,'530400','红塔区','530402'),(2575,'530400','江川县','530421'),(2576,'530400','澄江县','530422'),(2577,'530400','通海县','530423'),(2578,'530400','华宁县','530424'),(2579,'530400','易门县','530425'),(2580,'530400','峨山彝族自治县','530426'),(2581,'530400','新平彝族傣族自治县','530427'),(2582,'530400','元江哈尼族彝族傣族自治县','530428'),(2584,'530500','隆阳区','530502'),(2585,'530500','施甸县','530521'),(2586,'530500','腾冲县','530522'),(2587,'530500','龙陵县','530523'),(2588,'530500','昌宁县','530524'),(2590,'530600','昭阳区','530602'),(2591,'530600','鲁甸县','530621'),(2592,'530600','巧家县','530622'),(2593,'530600','盐津县','530623'),(2594,'530600','大关县','530624'),(2595,'530600','永善县','530625'),(2596,'530600','绥江县','530626'),(2597,'530600','镇雄县','530627'),(2598,'530600','彝良县','530628'),(2599,'530600','威信县','530629'),(2600,'530600','水富县','530630'),(2602,'530700','古城区','530702'),(2603,'530700','玉龙纳西族自治县','530721'),(2604,'530700','永胜县','530722'),(2605,'530700','华坪县','530723'),(2606,'530700','宁蒗彝族自治县','530724'),(2608,'530800','思茅区','530802'),(2609,'530800','宁洱哈尼族彝族自治县','530821'),(2610,'530800','墨江哈尼族自治县','530822'),(2611,'530800','景东彝族自治县','530823'),(2612,'530800','景谷傣族彝族自治县','530824'),(2613,'530800','镇沅彝族哈尼族拉祜族自治县','530825'),(2614,'530800','江城哈尼族彝族自治县','530826'),(2615,'530800','孟连傣族拉祜族佤族自治县','530827'),(2616,'530800','澜沧拉祜族自治县','530828'),(2617,'530800','西盟佤族自治县','530829'),(2619,'530900','临翔区','530902'),(2620,'530900','凤庆县','530921'),(2621,'530900','云　县','530922'),(2622,'530900','永德县','530923'),(2623,'530900','镇康县','530924'),(2624,'530900','双江拉祜族佤族布朗族傣族自治县','530925'),(2625,'530900','耿马傣族佤族自治县','530926'),(2626,'530900','沧源佤族自治县','530927'),(2627,'532300','楚雄市','532301'),(2628,'532300','双柏县','532322'),(2629,'532300','牟定县','532323'),(2630,'532300','南华县','532324'),(2631,'532300','姚安县','532325'),(2632,'532300','大姚县','532326'),(2633,'532300','永仁县','532327'),(2634,'532300','元谋县','532328'),(2635,'532300','武定县','532329'),(2636,'532300','禄丰县','532331'),(2637,'532500','个旧市','532501'),(2638,'532500','开远市','532502'),(2639,'532500','蒙自县','532522'),(2640,'532500','屏边苗族自治县','532523'),(2641,'532500','建水县','532524'),(2642,'532500','石屏县','532525'),(2643,'532500','弥勒市','532526'),(2644,'532500','泸西县','532527'),(2645,'532500','元阳县','532528'),(2646,'532500','红河县','532529'),(2647,'532500','金平苗族瑶族傣族自治县','532530'),(2648,'532500','绿春县','532531'),(2649,'532500','河口瑶族自治县','532532'),(2650,'532600','文山县','532621'),(2651,'532600','砚山县','532622'),(2652,'532600','西畴县','532623'),(2653,'532600','麻栗坡县','532624'),(2654,'532600','马关县','532625'),(2655,'532600','丘北县','532626'),(2656,'532600','广南县','532627'),(2657,'532600','富宁县','532628'),(2658,'532800','景洪市','532801'),(2659,'532800','勐海县','532822'),(2660,'532800','勐腊县','532823'),(2661,'532900','大理市','532901'),(2662,'532900','漾濞彝族自治县','532922'),(2663,'532900','祥云县','532923'),(2664,'532900','宾川县','532924'),(2665,'532900','弥渡县','532925'),(2666,'532900','南涧彝族自治县','532926'),(2667,'532900','巍山彝族回族自治县','532927'),(2668,'532900','永平县','532928'),(2669,'532900','云龙县','532929'),(2670,'532900','洱源县','532930'),(2671,'532900','剑川县','532931'),(2672,'532900','鹤庆县','532932'),(2673,'533100','瑞丽市','533102'),(2674,'533100','潞西市','533103'),(2675,'533100','梁河县','533122'),(2676,'533100','盈江县','533123'),(2677,'533100','陇川县','533124'),(2678,'533300','泸水县','533321'),(2679,'533300','福贡县','533323'),(2680,'533300','贡山独龙族怒族自治县','533324'),(2681,'533300','兰坪白族普米族自治县','533325'),(2682,'533400','香格里拉县','533421'),(2683,'533400','德钦县','533422'),(2684,'533400','维西傈僳族自治县','533423'),(2686,'540100','城关区','540102'),(2687,'540100','林周县','540121'),(2688,'540100','当雄县','540122'),(2689,'540100','尼木县','540123'),(2690,'540100','曲水县','540124'),(2691,'540100','堆龙德庆县','540125'),(2692,'540100','达孜县','540126'),(2693,'540100','墨竹工卡县','540127'),(2694,'542100','昌都县','542121'),(2695,'542100','江达县','542122'),(2696,'542100','贡觉县','542123'),(2697,'542100','类乌齐县','542124'),(2698,'542100','丁青县','542125'),(2699,'542100','察雅县','542126'),(2700,'542100','八宿县','542127'),(2701,'542100','左贡县','542128'),(2702,'542100','芒康县','542129'),(2703,'542100','洛隆县','542132'),(2704,'542100','边坝县','542133'),(2705,'542200','乃东县','542221'),(2706,'542200','扎囊县','542222'),(2707,'542200','贡嘎县','542223'),(2708,'542200','桑日县','542224'),(2709,'542200','琼结县','542225'),(2710,'542200','曲松县','542226'),(2711,'542200','措美县','542227'),(2712,'542200','洛扎县','542228'),(2713,'542200','加查县','542229'),(2714,'542200','隆子县','542231'),(2715,'542200','错那县','542232'),(2716,'542200','浪卡子县','542233'),(2717,'542300','日喀则市','542301'),(2718,'542300','南木林县','542322'),(2719,'542300','江孜县','542323'),(2720,'542300','定日县','542324'),(2721,'542300','萨迦县','542325'),(2722,'542300','拉孜县','542326'),(2723,'542300','昂仁县','542327'),(2724,'542300','谢通门县','542328'),(2725,'542300','白朗县','542329'),(2726,'542300','仁布县','542330'),(2727,'542300','康马县','542331'),(2728,'542300','定结县','542332'),(2729,'542300','仲巴县','542333'),(2730,'542300','亚东县','542334'),(2731,'542300','吉隆县','542335'),(2732,'542300','聂拉木县','542336'),(2733,'542300','萨嘎县','542337'),(2734,'542300','岗巴县','542338'),(2735,'542400','那曲县','542421'),(2736,'542400','嘉黎县','542422'),(2737,'542400','比如县','542423'),(2738,'542400','聂荣县','542424'),(2739,'542400','安多县','542425'),(2740,'542400','申扎县','542426'),(2741,'542400','索　县','542427'),(2742,'542400','班戈县','542428'),(2743,'542400','巴青县','542429'),(2744,'542400','尼玛县','542430'),(2745,'542500','普兰县','542521'),(2746,'542500','札达县','542522'),(2747,'542500','噶尔县','542523'),(2748,'542500','日土县','542524'),(2749,'542500','革吉县','542525'),(2750,'542500','改则县','542526'),(2751,'542500','措勤县','542527'),(2752,'542600','林芝县','542621'),(2753,'542600','工布江达县','542622'),(2754,'542600','米林县','542623'),(2755,'542600','墨脱县','542624'),(2756,'542600','波密县','542625'),(2757,'542600','察隅县','542626'),(2758,'542600','朗　县','542627'),(2760,'610100','新城区','610102'),(2761,'610100','碑林区','610103'),(2762,'610100','莲湖区','610104'),(2763,'610100','灞桥区','610111'),(2764,'610100','未央区','610112'),(2765,'610100','雁塔区','610113'),(2766,'610100','阎良区','610114'),(2767,'610100','临潼区','610115'),(2768,'610100','长安区','610116'),(2769,'610100','蓝田县','610122'),(2770,'610100','周至县','610124'),(2771,'610100','户　县','610125'),(2772,'610100','高陵县','610126'),(2774,'610200','王益区','610202'),(2775,'610200','印台区','610203'),(2776,'610200','耀州区','610204'),(2777,'610200','宜君县','610222'),(2779,'610300','渭滨区','610302'),(2780,'610300','金台区','610303'),(2781,'610300','陈仓区','610304'),(2782,'610300','凤翔县','610322'),(2783,'610300','岐山县','610323'),(2784,'610300','扶风县','610324'),(2785,'610300','眉　县','610326'),(2786,'610300','陇　县','610327'),(2787,'610300','千阳县','610328'),(2788,'610300','麟游县','610329'),(2789,'610300','凤　县','610330'),(2790,'610300','太白县','610331'),(2792,'610400','秦都区','610402'),(2793,'610400','杨凌区','610403'),(2794,'610400','渭城区','610404'),(2795,'610400','三原县','610422'),(2796,'610400','泾阳县','610423'),(2797,'610400','乾　县','610424'),(2798,'610400','礼泉县','610425'),(2799,'610400','永寿县','610426'),(2800,'610400','彬　县','610427'),(2801,'610400','长武县','610428'),(2802,'610400','旬邑县','610429'),(2803,'610400','淳化县','610430'),(2804,'610400','武功县','610431'),(2805,'610400','兴平市','610481'),(2807,'610500','临渭区','610502'),(2808,'610500','华　县','610521'),(2809,'610500','潼关县','610522'),(2810,'610500','大荔县','610523'),(2811,'610500','合阳县','610524'),(2812,'610500','澄城县','610525'),(2813,'610500','蒲城县','610526'),(2814,'610500','白水县','610527'),(2815,'610500','富平县','610528'),(2816,'610500','韩城市','610581'),(2817,'610500','华阴市','610582'),(2819,'610600','宝塔区','610602'),(2820,'610600','延长县','610621'),(2821,'610600','延川县','610622'),(2822,'610600','子长县','610623'),(2823,'610600','安塞县','610624'),(2824,'610600','志丹县','610625'),(2825,'610600','吴起县','610626'),(2826,'610600','甘泉县','610627'),(2827,'610600','富　县','610628'),(2828,'610600','洛川县','610629'),(2829,'610600','宜川县','610630'),(2830,'610600','黄龙县','610631'),(2831,'610600','黄陵县','610632'),(2833,'610700','汉台区','610702'),(2834,'610700','南郑县','610721'),(2835,'610700','城固县','610722'),(2836,'610700','洋　县','610723'),(2837,'610700','西乡县','610724'),(2838,'610700','勉　县','610725'),(2839,'610700','宁强县','610726'),(2840,'610700','略阳县','610727'),(2841,'610700','镇巴县','610728'),(2842,'610700','留坝县','610729'),(2843,'610700','佛坪县','610730'),(2845,'610800','榆阳区','610802'),(2846,'610800','神木县','610821'),(2847,'610800','府谷县','610822'),(2848,'610800','横山县','610823'),(2849,'610800','靖边县','610824'),(2850,'610800','定边县','610825'),(2851,'610800','绥德县','610826'),(2852,'610800','米脂县','610827'),(2853,'610800','佳　县','610828'),(2854,'610800','吴堡县','610829'),(2855,'610800','清涧县','610830'),(2856,'610800','子洲县','610831'),(2858,'610900','汉滨区','610902'),(2859,'610900','汉阴县','610921'),(2860,'610900','石泉县','610922'),(2861,'610900','宁陕县','610923'),(2862,'610900','紫阳县','610924'),(2863,'610900','岚皋县','610925'),(2864,'610900','平利县','610926'),(2865,'610900','镇坪县','610927'),(2866,'610900','旬阳县','610928'),(2867,'610900','白河县','610929'),(2869,'611000','商州区','611002'),(2870,'611000','洛南县','611021'),(2871,'611000','丹凤县','611022'),(2872,'611000','商南县','611023'),(2873,'611000','山阳县','611024'),(2874,'611000','镇安县','611025'),(2875,'611000','柞水县','611026'),(2877,'620100','城关区','620102'),(2878,'620100','七里河区','620103'),(2879,'620100','西固区','620104'),(2880,'620100','安宁区','620105'),(2881,'620100','红古区','620111'),(2882,'620100','永登县','620121'),(2883,'620100','皋兰县','620122'),(2884,'620100','榆中县','620123'),(2887,'620300','金川区','620302'),(2888,'620300','永昌县','620321'),(2890,'620400','白银区','620402'),(2891,'620400','平川区','620403'),(2892,'620400','靖远县','620421'),(2893,'620400','会宁县','620422'),(2894,'620400','景泰县','620423'),(2896,'620500','秦城区','620502'),(2897,'620500','北道区','620503'),(2898,'620500','清水县','620521'),(2899,'620500','秦安县','620522'),(2900,'620500','甘谷县','620523'),(2901,'620500','武山县','620524'),(2902,'620500','张家川回族自治县','620525'),(2904,'620600','凉州区','620602'),(2905,'620600','民勤县','620621'),(2906,'620600','古浪县','620622'),(2907,'620600','天祝藏族自治县','620623'),(2909,'620700','甘州区','620702'),(2910,'620700','肃南裕固族自治县','620721'),(2911,'620700','民乐县','620722'),(2912,'620700','临泽县','620723'),(2913,'620700','高台县','620724'),(2914,'620700','山丹县','620725'),(2916,'620800','崆峒区','620802'),(2917,'620800','泾川县','620821'),(2918,'620800','灵台县','620822'),(2919,'620800','崇信县','620823'),(2920,'620800','华亭县','620824'),(2921,'620800','庄浪县','620825'),(2922,'620800','静宁县','620826'),(2924,'620900','肃州区','620902'),(2925,'620900','金塔县','620921'),(2926,'620900','安西县','620922'),(2927,'620900','肃北蒙古族自治县','620923'),(2928,'620900','阿克塞哈萨克族自治县','620924'),(2929,'620900','玉门市','620981'),(2930,'620900','敦煌市','620982'),(2932,'621000','西峰区','621002'),(2933,'621000','庆城县','621021'),(2934,'621000','环　县','621022'),(2935,'621000','华池县','621023'),(2936,'621000','合水县','621024'),(2937,'621000','正宁县','621025'),(2938,'621000','宁　县','621026'),(2939,'621000','镇原县','621027'),(2941,'621100','安定区','621102'),(2942,'621100','通渭县','621121'),(2943,'621100','陇西县','621122'),(2944,'621100','渭源县','621123'),(2945,'621100','临洮县','621124'),(2946,'621100','漳　县','621125'),(2947,'621100','岷　县','621126'),(2949,'621200','武都区','621202'),(2950,'621200','成　县','621221'),(2951,'621200','文　县','621222'),(2952,'621200','宕昌县','621223'),(2953,'621200','康　县','621224'),(2954,'621200','西和县','621225'),(2955,'621200','礼　县','621226'),(2956,'621200','徽　县','621227'),(2957,'621200','两当县','621228'),(2958,'622900','临夏市','622901'),(2959,'622900','临夏县','622921'),(2960,'622900','康乐县','622922'),(2961,'622900','永靖县','622923'),(2962,'622900','广河县','622924'),(2963,'622900','和政县','622925'),(2964,'622900','东乡族自治县','622926'),(2965,'622900','积石山保安族东乡族撒拉族自治县','622927'),(2966,'623000','合作市','623001'),(2967,'623000','临潭县','623021'),(2968,'623000','卓尼县','623022'),(2969,'623000','舟曲县','623023'),(2970,'623000','迭部县','623024'),(2971,'623000','玛曲县','623025'),(2972,'623000','碌曲县','623026'),(2973,'623000','夏河县','623027'),(2975,'630100','城东区','630102'),(2976,'630100','城中区','630103'),(2977,'630100','城西区','630104'),(2978,'630100','城北区','630105'),(2979,'630100','大通回族土族自治县','630121'),(2980,'630100','湟中县','630122'),(2981,'630100','湟源县','630123'),(2982,'632100','平安县','632121'),(2983,'632100','民和回族土族自治县','632122'),(2984,'632100','乐都县','632123'),(2985,'632100','互助土族自治县','632126'),(2986,'632100','化隆回族自治县','632127'),(2987,'632100','循化撒拉族自治县','632128'),(2988,'632200','门源回族自治县','632221'),(2989,'632200','祁连县','632222'),(2990,'632200','海晏县','632223'),(2991,'632200','刚察县','632224'),(2992,'632300','同仁县','632321'),(2993,'632300','尖扎县','632322'),(2994,'632300','泽库县','632323'),(2995,'632300','河南蒙古族自治县','632324'),(2996,'632500','共和县','632521'),(2997,'632500','同德县','632522'),(2998,'632500','贵德县','632523'),(2999,'632500','兴海县','632524'),(3000,'632500','贵南县','632525'),(3001,'632600','玛沁县','632621'),(3002,'632600','班玛县','632622'),(3003,'632600','甘德县','632623'),(3004,'632600','达日县','632624'),(3005,'632600','久治县','632625'),(3006,'632600','玛多县','632626'),(3007,'632700','玉树县','632721'),(3008,'632700','杂多县','632722'),(3009,'632700','称多县','632723'),(3010,'632700','治多县','632724'),(3011,'632700','囊谦县','632725'),(3012,'632700','曲麻莱县','632726'),(3013,'632800','格尔木市','632801'),(3014,'632800','德令哈市','632802'),(3015,'632800','乌兰县','632821'),(3016,'632800','都兰县','632822'),(3017,'632800','天峻县','632823'),(3019,'640100','兴庆区','640104'),(3020,'640100','西夏区','640105'),(3021,'640100','金凤区','640106'),(3022,'640100','永宁县','640121'),(3023,'640100','贺兰县','640122'),(3024,'640100','灵武市','640181'),(3026,'640200','大武口区','640202'),(3027,'640200','惠农区','640205'),(3028,'640200','平罗县','640221'),(3030,'640300','利通区','640302'),(3031,'640300','盐池县','640323'),(3032,'640300','同心县','640324'),(3033,'640300','青铜峡市','640381'),(3035,'640400','原州区','640402'),(3036,'640400','西吉县','640422'),(3037,'640400','隆德县','640423'),(3038,'640400','泾源县','640424'),(3039,'640400','彭阳县','640425'),(3041,'640500','沙坡头区','640502'),(3042,'640500','中宁县','640521'),(3043,'640500','海原县','640522'),(3045,'650100','天山区','650102'),(3046,'650100','沙依巴克区','650103'),(3047,'650100','新市区','650104'),(3048,'650100','水磨沟区','650105'),(3049,'650100','头屯河区','650106'),(3050,'650100','达坂城区','650107'),(3051,'650100','东山区','650108'),(3052,'650100','乌鲁木齐县','650121'),(3054,'650200','独山子区','650202'),(3055,'650200','克拉玛依区','650203'),(3056,'650200','白碱滩区','650204'),(3057,'650200','乌尔禾区','650205'),(3058,'652100','吐鲁番市','652101'),(3059,'652100','鄯善县','652122'),(3060,'652100','托克逊县','652123'),(3061,'652200','哈密市','652201'),(3062,'652200','巴里坤哈萨克自治县','652222'),(3063,'652200','伊吾县','652223'),(3064,'652300','昌吉市','652301'),(3065,'652300','阜康市','652302'),(3066,'652300','米泉市','652303'),(3067,'652300','呼图壁县','652323'),(3068,'652300','玛纳斯县','652324'),(3069,'652300','奇台县','652325'),(3070,'652300','吉木萨尔县','652327'),(3071,'652300','木垒哈萨克自治县','652328'),(3072,'652700','博乐市','652701'),(3073,'652700','精河县','652722'),(3074,'652700','温泉县','652723'),(3075,'652800','库尔勒市','652801'),(3076,'652800','轮台县','652822'),(3077,'652800','尉犁县','652823'),(3078,'652800','若羌县','652824'),(3079,'652800','且末县','652825'),(3080,'652800','焉耆回族自治县','652826'),(3081,'652800','和静县','652827'),(3082,'652800','和硕县','652828'),(3083,'652800','博湖县','652829'),(3084,'652900','阿克苏市','652901'),(3085,'652900','温宿县','652922'),(3086,'652900','库车县','652923'),(3087,'652900','沙雅县','652924'),(3088,'652900','新和县','652925'),(3089,'652900','拜城县','652926'),(3090,'652900','乌什县','652927'),(3091,'652900','阿瓦提县','652928'),(3092,'652900','柯坪县','652929'),(3093,'653000','阿图什市','653001'),(3094,'653000','阿克陶县','653022'),(3095,'653000','阿合奇县','653023'),(3096,'653000','乌恰县','653024'),(3097,'653100','喀什市','653101'),(3098,'653100','疏附县','653121'),(3099,'653100','疏勒县','653122'),(3100,'653100','英吉沙县','653123'),(3101,'653100','泽普县','653124'),(3102,'653100','莎车县','653125'),(3103,'653100','叶城县','653126'),(3104,'653100','麦盖提县','653127'),(3105,'653100','岳普湖县','653128'),(3106,'653100','伽师县','653129'),(3107,'653100','巴楚县','653130'),(3108,'653100','塔什库尔干塔吉克自治县','653131'),(3109,'653200','和田市','653201'),(3110,'653200','和田县','653221'),(3111,'653200','墨玉县','653222'),(3112,'653200','皮山县','653223'),(3113,'653200','洛浦县','653224'),(3114,'653200','策勒县','653225'),(3115,'653200','于田县','653226'),(3116,'653200','民丰县','653227'),(3117,'654000','伊宁市','654002'),(3118,'654000','奎屯市','654003'),(3119,'654000','伊宁县','654021'),(3120,'654000','察布查尔锡伯自治县','654022'),(3121,'654000','霍城县','654023'),(3122,'654000','巩留县','654024'),(3123,'654000','新源县','654025'),(3124,'654000','昭苏县','654026'),(3125,'654000','特克斯县','654027'),(3126,'654000','尼勒克县','654028'),(3127,'654200','塔城市','654201'),(3128,'654200','乌苏市','654202'),(3129,'654200','额敏县','654221'),(3130,'654200','沙湾县','654223'),(3131,'654200','托里县','654224'),(3132,'654200','裕民县','654225'),(3133,'654200','和布克赛尔蒙古自治县','654226'),(3134,'654300','阿勒泰市','654301'),(3135,'654300','布尔津县','654321'),(3136,'654300','富蕴县','654322'),(3137,'654300','福海县','654323'),(3138,'654300','哈巴河县','654324'),(3139,'654300','青河县','654325'),(3140,'654300','吉木乃县','654326'),(3141,'654400','石河子市','654401'),(3142,'654500','阿拉尔市','654501'),(3143,'654600','图木舒克市','654601'),(3144,'654700','五家渠市','654701'),(3145,'441900','东莞市','441901'),(3146,'442000','中山市','442001'),(3147,'460200','三亚市','460201'),(3148,'620200','嘉峪关市','620201'),(3149,'360100','昌北国家经济技术开发区','360127'),(3150,'360100','红谷滩新区','360125'),(3151,'360100','经济技术开发区','360126'),(3152,'120100','滨海新区','120116'),(3153,'340800','宜秀区','340804'),(3154,'340200','弋江区','340206'),(3155,'340200','三山区','340207'),(3156,'620500','秦州区','620504'),(3157,'620500','麦积区','620505'),(3158,'440100','南沙区','440185'),(3159,'440100','萝岗区','440186'),(3160,'130300','开发区','130305'),(3161,'410200','禹王台区','410206'),(3162,'410200','金明区','410207'),(3164,'410100','高新区','410186'),(3165,'210100','沈北新区','210115'),(3166,'650100','兵团','650123'),(3167,'330400','南湖区','330484'),(3177,'410100','惠济区','410109'),(3178,'431100','零陵区','431104'),(3180,'500300','北部新区','500116'),(3181,'232700','加格达奇区','232724'),(3182,'232700','新林区','232725'),(3183,'220600','浑江区','220684'),(3184,'130600','蠡县','130686'),(3185,'130400','高开区','130436'),(3186,'410800','高新区','410885'),(3187,'410300','伊滨区','410385'),(3188,'410900','经济开发区','410930'),(3189,'340100','北城新区','340130'),(3190,'340100','滨湖新区','340131'),(3191,'340100','高新开发区','340132'),(3192,'340100','经济技术开发区','340133'),(3193,'340100','居巢区','340134'),(3194,'340100','龙岗开发区','340135'),(3195,'340100','庐江县','340136'),(3196,'340100','新站综合开发试验区','340137'),(3197,'340100','政务新区','340138'),(3198,'341500','叶集试验区','341527'),(3199,'340500','含山县','340523'),(3200,'340500','和县','340524'),(3201,'340200','无为县','340210'),(3202,'330600','柯桥区','330685'),(3203,'321200','高新区','321206'),(3204,'350200','杏林区','350215'),(3205,'360700','赣州市区','360704'),(3206,'360400','庐山市','360483'),(3207,'360100','高新技术开发区','360128'),(3208,'360100','桑海经济开发区','360130'),(3209,'440800','开发区','440813'),(3210,'421300','随县','421383'),(3211,'530300','曲靖市','530383'),(3212,'522400','毕节地区','522403'),(3213,'520100','观山湖区','520116'),(3214,'510100','成都市区','510186'),(3215,'510800','利州区','510814'),(3216,'620900','瓜州县','620927'),(3217,'632800','大柴旦行委','632830'),(3218,'632800','茫崖行委','632831'),(3219,'632800','冷湖行委','632832'),(3220,'150400','元宝山区平庄','150434'),(3221,'150600','康巴什新区','150604'),(3222,'650100','米东区','650110'),(3223,'640300','红寺堡区','640304'),(3224,'410100','郑东新区','410111'),(3225,'411800','济源市','411801'),(3226,'230100','阿城区','230185'),(3240,'360400','共青城','360484'),(3241,'810100','香港岛','810101'),(3242,'810100','新界半岛','810102'),(3243,'810100','九龙','810103'),(3244,'820100','澳门半岛','820101'),(3245,'820100','氹仔','820102'),(3246,'820100','路环','820103');

/*Table structure for table `asyncreport` */


CREATE TABLE `asyncreport` (
  `receipt` varchar(128) NOT NULL,
  `deviceid` varchar(128) NOT NULL,
  `method` varchar(128) NOT NULL,
  `nodeid` int(9) NOT NULL,
  `objid` int(11) DEFAULT NULL,
  `value` varchar(1024) DEFAULT NULL,
  `createtime` datetime NOT NULL,
  PRIMARY KEY (`receipt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `asyncreport` */

/*Table structure for table `city` */


CREATE TABLE `city` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `provinceCode` varchar(50) DEFAULT NULL COMMENT '省代码',
  `cityName` varchar(100) DEFAULT NULL COMMENT '市名称',
  `cityCode` varchar(50) DEFAULT NULL COMMENT '市代码',
  `firstPinyin` varchar(20) DEFAULT NULL COMMENT '市名称拼音首字母',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='城市';

/*Data for the table `city` */
INSERT INTO `city` VALUES (1,'110000','北京市','110100','b'),(3,'120000','天津市','120100','t'),(5,'130000','石家庄市','130100','s'),(6,'130000','唐山市','130200','t'),(7,'130000','秦皇岛市','130300','q'),(8,'130000','邯郸市','130400','h'),(9,'130000','邢台市','130500','x'),(10,'130000','保定市','130600','b'),(11,'130000','张家口市','130700','z'),(12,'130000','承德市','130800','c'),(13,'130000','沧州市','130900','c'),(14,'130000','廊坊市','131000','l'),(15,'130000','衡水市','131100','h'),(16,'140000','太原市','140100','t'),(17,'140000','大同市','140200','d'),(18,'140000','阳泉市','140300','y'),(19,'140000','长治市','140400','c'),(20,'140000','晋城市','140500','j'),(21,'140000','朔州市','140600','s'),(22,'140000','晋中市','140700','j'),(23,'140000','运城市','140800','y'),(24,'140000','忻州市','140900','x'),(25,'140000','临汾市','141000','l'),(26,'140000','吕梁市','141100','l'),(27,'150000','呼和浩特市','150100','h'),(28,'150000','包头市','150200','b'),(29,'150000','乌海市','150300','w'),(30,'150000','赤峰市','150400','c'),(31,'150000','通辽市','150500','t'),(32,'150000','鄂尔多斯市','150600','e'),(33,'150000','呼伦贝尔市','150700','h'),(34,'150000','巴彦淖尔市','150800','b'),(35,'150000','乌兰察布市','150900','w'),(36,'150000','兴安盟','152200','x'),(37,'150000','锡林郭勒盟','152500','x'),(38,'150000','阿拉善盟','152900','a'),(39,'210000','沈阳市','210100','s'),(40,'210000','大连市','210200','d'),(41,'210000','鞍山市','210300','a'),(42,'210000','抚顺市','210400','f'),(43,'210000','本溪市','210500','b'),(44,'210000','丹东市','210600','d'),(45,'210000','锦州市','210700','j'),(46,'210000','营口市','210800','y'),(47,'210000','阜新市','210900','f'),(48,'210000','辽阳市','211000','l'),(49,'210000','盘锦市','211100','p'),(50,'210000','铁岭市','211200','t'),(51,'210000','朝阳市','211300','c'),(52,'210000','葫芦岛市','211400','h'),(53,'220000','长春市','220100','c'),(54,'220000','吉林市','220200','j'),(55,'220000','四平市','220300','s'),(56,'220000','辽源市','220400','l'),(57,'220000','通化市','220500','t'),(58,'220000','白山市','220600','b'),(59,'220000','松原市','220700','s'),(60,'220000','白城市','220800','b'),(61,'220000','延边朝鲜族自治州','222400','y'),(62,'230000','哈尔滨市','230100','h'),(63,'230000','齐齐哈尔市','230200','q'),(64,'230000','鸡西市','230300','j'),(65,'230000','鹤岗市','230400','h'),(66,'230000','双鸭山市','230500','s'),(67,'230000','大庆市','230600','d'),(68,'230000','伊春市','230700','y'),(69,'230000','佳木斯市','230800','j'),(70,'230000','七台河市','230900','q'),(71,'230000','牡丹江市','231000','m'),(72,'230000','黑河市','231100','h'),(73,'230000','绥化市','231200','s'),(74,'230000','大兴安岭地区','232700','d'),(75,'310000','上海市','310100','s'),(77,'320000','南京市','320100','n'),(78,'320000','无锡市','320200','w'),(79,'320000','徐州市','320300','x'),(80,'320000','常州市','320400','c'),(81,'320000','苏州市','320500','s'),(82,'320000','南通市','320600','n'),(83,'320000','连云港市','320700','l'),(84,'320000','淮安市','320800','h'),(85,'320000','盐城市','320900','y'),(86,'320000','扬州市','321000','y'),(87,'320000','镇江市','321100','z'),(88,'320000','泰州市','321200','t'),(89,'320000','宿迁市','321300','s'),(90,'330000','杭州市','330100','h'),(91,'330000','宁波市','330200','n'),(92,'330000','温州市','330300','w'),(93,'330000','嘉兴市','330400','j'),(94,'330000','湖州市','330500','h'),(95,'330000','绍兴市','330600','s'),(96,'330000','金华市','330700','j'),(97,'330000','衢州市','330800','z'),(98,'330000','舟山市','330900','z'),(99,'330000','台州市','331000','t'),(100,'330000','丽水市','331100','l'),(101,'340000','合肥市','340100','h'),(102,'340000','芜湖市','340200','w'),(103,'340000','蚌埠市','340300','b'),(104,'340000','淮南市','340400','h'),(105,'340000','马鞍山市','340500','m'),(106,'340000','淮北市','340600','h'),(107,'340000','铜陵市','340700','t'),(108,'340000','安庆市','340800','a'),(109,'340000','黄山市','341000','h'),(110,'340000','滁州市','341100','c'),(111,'340000','阜阳市','341200','f'),(112,'340000','宿州市','341300','s'),(113,'340000','巢湖市','341400','c'),(114,'340000','六安市','341500','l'),(115,'340000','亳州市','341600','z'),(116,'340000','池州市','341700','c'),(117,'340000','宣城市','341800','x'),(118,'350000','福州市','350100','f'),(119,'350000','厦门市','350200','x'),(120,'350000','莆田市','350300','p'),(121,'350000','三明市','350400','s'),(122,'350000','泉州市','350500','q'),(123,'350000','漳州市','350600','z'),(124,'350000','南平市','350700','n'),(125,'350000','龙岩市','350800','l'),(126,'350000','宁德市','350900','n'),(127,'360000','南昌市','360100','n'),(128,'360000','景德镇市','360200','j'),(129,'360000','萍乡市','360300','p'),(130,'360000','九江市','360400','j'),(131,'360000','新余市','360500','x'),(132,'360000','鹰潭市','360600','y'),(133,'360000','赣州市','360700','g'),(134,'360000','吉安市','360800','j'),(135,'360000','宜春市','360900','y'),(136,'360000','抚州市','361000','f'),(137,'360000','上饶市','361100','s'),(138,'370000','济南市','370100','j'),(139,'370000','青岛市','370200','q'),(140,'370000','淄博市','370300','z'),(141,'370000','枣庄市','370400','z'),(142,'370000','东营市','370500','d'),(143,'370000','烟台市','370600','y'),(144,'370000','潍坊市','370700','w'),(145,'370000','济宁市','370800','j'),(146,'370000','泰安市','370900','t'),(147,'370000','威海市','371000','w'),(148,'370000','日照市','371100','r'),(149,'370000','莱芜市','371200','l'),(150,'370000','临沂市','371300','l'),(151,'370000','德州市','371400','d'),(152,'370000','聊城市','371500','l'),(153,'370000','滨州市','371600','b'),(154,'370000','菏泽市','371700','h'),(155,'410000','郑州市','410100','z'),(156,'410000','开封市','410200','k'),(157,'410000','洛阳市','410300','l'),(158,'410000','平顶山市','410400','p'),(159,'410000','安阳市','410500','a'),(160,'410000','鹤壁市','410600','h'),(161,'410000','新乡市','410700','x'),(162,'410000','焦作市','410800','j'),(163,'410000','濮阳市','410900','z'),(164,'410000','许昌市','411000','x'),(165,'410000','漯河市','411100','z'),(166,'410000','三门峡市','411200','s'),(167,'410000','南阳市','411300','n'),(168,'410000','商丘市','411400','s'),(169,'410000','信阳市','411500','x'),(170,'410000','周口市','411600','z'),(171,'410000','驻马店市','411700','z'),(172,'420000','武汉市','420100','w'),(173,'420000','黄石市','420200','h'),(174,'420000','十堰市','420300','s'),(175,'420000','宜昌市','420500','y'),(176,'420000','襄樊市','420600','x'),(177,'420000','鄂州市','420700','e'),(178,'420000','荆门市','420800','j'),(179,'420000','孝感市','420900','x'),(180,'420000','荆州市','421000','j'),(181,'420000','黄冈市','421100','h'),(182,'420000','咸宁市','421200','x'),(183,'420000','随州市','421300','s'),(184,'420000','恩施土家族苗族自治州','422800','e'),(185,'420000','省直辖行政单位','429000','s'),(186,'430000','长沙市','430100','c'),(187,'430000','株洲市','430200','z'),(188,'430000','湘潭市','430300','x'),(189,'430000','衡阳市','430400','h'),(190,'430000','邵阳市','430500','s'),(191,'430000','岳阳市','430600','y'),(192,'430000','常德市','430700','c'),(193,'430000','张家界市','430800','z'),(194,'430000','益阳市','430900','y'),(195,'430000','郴州市','431000','c'),(196,'430000','永州市','431100','y'),(197,'430000','怀化市','431200','h'),(198,'430000','娄底市','431300','l'),(199,'430000','湘西土家族苗族自治州','433100','x'),(200,'440000','广州市','440100','g'),(201,'440000','韶关市','440200','s'),(202,'440000','深圳市','440300','s'),(203,'440000','珠海市','440400','z'),(204,'440000','汕头市','440500','s'),(205,'440000','佛山市','440600','f'),(206,'440000','江门市','440700','j'),(207,'440000','湛江市','440800','z'),(208,'440000','茂名市','440900','m'),(209,'440000','肇庆市','441200','z'),(210,'440000','惠州市','441300','h'),(211,'440000','梅州市','441400','m'),(212,'440000','汕尾市','441500','s'),(213,'440000','河源市','441600','h'),(214,'440000','阳江市','441700','y'),(215,'440000','清远市','441800','q'),(216,'440000','东莞市','441900','d'),(217,'440000','中山市','442000','z'),(218,'440000','潮州市','445100','c'),(219,'440000','揭阳市','445200','j'),(220,'440000','云浮市','445300','y'),(221,'450000','南宁市','450100','n'),(222,'450000','柳州市','450200','l'),(223,'450000','桂林市','450300','g'),(224,'450000','梧州市','450400','w'),(225,'450000','北海市','450500','b'),(226,'450000','防城港市','450600','f'),(227,'450000','钦州市','450700','q'),(228,'450000','贵港市','450800','g'),(229,'450000','玉林市','450900','y'),(230,'450000','百色市','451000','b'),(231,'450000','贺州市','451100','h'),(232,'450000','河池市','451200','h'),(233,'450000','来宾市','451300','l'),(234,'450000','崇左市','451400','c'),(235,'460000','海口市','460100','h'),(236,'460000','三亚市','460200','s'),(237,'460000','省直辖县级行政单位','469000','s'),(238,'500000','重庆市','500100','z'),(241,'510000','成都市','510100','c'),(242,'510000','自贡市','510300','z'),(243,'510000','攀枝花市','510400','p'),(244,'510000','泸州市','510500','z'),(245,'510000','德阳市','510600','d'),(246,'510000','绵阳市','510700','m'),(247,'510000','广元市','510800','g'),(248,'510000','遂宁市','510900','s'),(249,'510000','内江市','511000','n'),(250,'510000','乐山市','511100','l'),(251,'510000','南充市','511300','n'),(252,'510000','眉山市','511400','m'),(253,'510000','宜宾市','511500','y'),(254,'510000','广安市','511600','g'),(255,'510000','达州市','511700','d'),(256,'510000','雅安市','511800','y'),(257,'510000','巴中市','511900','b'),(258,'510000','资阳市','512000','z'),(259,'510000','阿坝藏族羌族自治州','513200','a'),(260,'510000','甘孜藏族自治州','513300','g'),(261,'510000','凉山彝族自治州','513400','l'),(262,'520000','贵阳市','520100','g'),(263,'520000','六盘水市','520200','l'),(264,'520000','遵义市','520300','z'),(265,'520000','安顺市','520400','a'),(266,'520000','铜仁地区','522200','t'),(267,'520000','黔西南布依族苗族自治州','522300','q'),(268,'520000','毕节地区','522400','b'),(269,'520000','黔东南苗族侗族自治州','522600','q'),(270,'520000','黔南布依族苗族自治州','522700','q'),(271,'530000','昆明市','530100','k'),(272,'530000','曲靖市','530300','q'),(273,'530000','玉溪市','530400','y'),(274,'530000','保山市','530500','b'),(275,'530000','昭通市','530600','z'),(276,'530000','丽江市','530700','l'),(277,'530000','普洱市','530800','p'),(278,'530000','临沧市','530900','l'),(279,'530000','楚雄彝族自治州','532300','c'),(280,'530000','红河哈尼族彝族自治州','532500','h'),(281,'530000','文山壮族苗族自治州','532600','w'),(282,'530000','西双版纳傣族自治州','532800','x'),(283,'530000','大理白族自治州','532900','d'),(284,'530000','德宏傣族景颇族自治州','533100','d'),(285,'530000','怒江傈僳族自治州','533300','n'),(286,'530000','迪庆藏族自治州','533400','d'),(287,'540000','拉萨市','540100','l'),(288,'540000','昌都地区','542100','c'),(289,'540000','山南地区','542200','s'),(290,'540000','日喀则地区','542300','r'),(291,'540000','那曲地区','542400','n'),(292,'540000','阿里地区','542500','a'),(293,'540000','林芝地区','542600','l'),(294,'610000','西安市','610100','x'),(295,'610000','铜川市','610200','t'),(296,'610000','宝鸡市','610300','b'),(297,'610000','咸阳市','610400','x'),(298,'610000','渭南市','610500','w'),(299,'610000','延安市','610600','y'),(300,'610000','汉中市','610700','h'),(301,'610000','榆林市','610800','y'),(302,'610000','安康市','610900','a'),(303,'610000','商洛市','611000','s'),(304,'620000','兰州市','620100','l'),(305,'620000','嘉峪关市','620200','j'),(306,'620000','金昌市','620300','j'),(307,'620000','白银市','620400','b'),(308,'620000','天水市','620500','t'),(309,'620000','武威市','620600','w'),(310,'620000','张掖市','620700','z'),(311,'620000','平凉市','620800','p'),(312,'620000','酒泉市','620900','j'),(313,'620000','庆阳市','621000','q'),(314,'620000','定西市','621100','d'),(315,'620000','陇南市','621200','l'),(316,'620000','临夏回族自治州','622900','l'),(317,'620000','甘南藏族自治州','623000','g'),(318,'630000','西宁市','630100','x'),(319,'630000','海东市','632100','h'),(320,'630000','海北藏族自治州','632200','h'),(321,'630000','黄南藏族自治州','632300','h'),(322,'630000','海南藏族自治州','632500','h'),(323,'630000','果洛藏族自治州','632600','g'),(324,'630000','玉树藏族自治州','632700','y'),(325,'630000','海西蒙古族藏族自治州','632800','h'),(326,'640000','银川市','640100','y'),(327,'640000','石嘴山市','640200','s'),(328,'640000','吴忠市','640300','w'),(329,'640000','固原市','640400','g'),(330,'640000','中卫市','640500','z'),(331,'650000','乌鲁木齐市','650100','w'),(332,'650000','克拉玛依市','650200','k'),(333,'650000','吐鲁番地区','652100','t'),(334,'650000','哈密地区','652200','h'),(335,'650000','昌吉回族自治州','652300','c'),(336,'650000','博尔塔拉蒙古自治州','652700','b'),(337,'650000','巴音郭楞蒙古自治州','652800','b'),(338,'650000','阿克苏地区','652900','a'),(339,'650000','克孜勒苏柯尔克孜自治州','653000','k'),(340,'650000','喀什地区','653100','k'),(341,'650000','和田地区','653200','h'),(342,'650000','伊犁哈萨克自治州','654000','y'),(343,'650000','塔城地区','654200','t'),(344,'650000','阿勒泰地区','654300','a'),(346,'410000','济源市','411800','j'),(347,'650000','石河子市','654400','s'),(348,'650000','阿拉尔市','654500','a'),(349,'650000','图木舒克市','654600','t'),(350,'650000','五家渠市','654700','w'),(351,'420000','天门','429200','t'),(352,'420000','神农架','429300','s'),(353,'420000','潜江','429100','q'),(354,'810000','香港','810100','x'),(355,'820000','澳门','820100','a');

/*Table structure for table `commuLog` */


CREATE TABLE `commuLog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `commuText` varchar(5000) NOT NULL COMMENT '通讯内容',
  `inputDate` datetime DEFAULT NULL COMMENT '上报时间',
  `personId` bigint(20) NOT NULL COMMENT '用户id',
  `deviceId` bigint(20) DEFAULT NULL COMMENT '设备id',
  `type1` int(8) DEFAULT NULL COMMENT '操作类型：1,打开设备2,关闭设备3,修改密码4,设置密码失效5,修改临时密码6,设置临时密码失效7,修改用户密码8,设置用户密码失效9,设置密码10,设置卡用户11,删除用户',
  `type2` int(8) DEFAULT NULL COMMENT '结果类型：0，失败；1，成功',
  `operatepersonid` int(9) DEFAULT NULL COMMENT '操作者id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='通讯记录';

/*Data for the table `customer` */

/*Table structure for table `dataprivilegegrant` */


CREATE TABLE `dataprivilegegrant` (
  `dataprivilegegrantid` int(9) NOT NULL AUTO_INCREMENT,
  `personid` int(9) NOT NULL COMMENT '被授权的二级管理员id',
  `districtid` int(9) NOT NULL COMMENT '被授权的小区id',
  `createtime` datetime NOT NULL,
  `status` int(9) NOT NULL COMMENT '1:正常 9：删除',
  `deletetime` datetime DEFAULT NULL,
  PRIMARY KEY (`dataprivilegegrantid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*Data for the table `device` */

/*Table structure for table `deviceBatteryLog` */


CREATE TABLE `deviceBatteryLog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personId` bigint(20) NOT NULL COMMENT '用户id',
  `deviceId` bigint(20) DEFAULT NULL COMMENT '设备id',
  `battery` int(11) NOT NULL COMMENT '电量',
  `inputDate` datetime DEFAULT NULL COMMENT '上报时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='电量历史记录';

/*Data for the table `deviceBatteryLog` */

/*Table structure for table `deviceDegreesHourLog` */


CREATE TABLE `deviceDegreesHourLog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personId` bigint(20) NOT NULL COMMENT '用户id',
  `degrees` float(15,2) NOT NULL COMMENT '电表度数',
  `inputDate` datetime DEFAULT NULL COMMENT '上报时间',
  `hour` int(11) DEFAULT NULL COMMENT '时间 2016052501',
  `deviceId` bigint(20) NOT NULL COMMENT '设备id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='电表度数时报表';

/*Data for the table `deviceDegreesHourLog` */

/*Table structure for table `deviceDegreesLog` */


CREATE TABLE `deviceDegreesLog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personId` bigint(20) NOT NULL COMMENT '用户id',
  `degrees` float(15,2) NOT NULL COMMENT '电表度数',
  `inputDate` datetime DEFAULT NULL COMMENT '上报时间',
  `deviceId` bigint(20) NOT NULL COMMENT '设备id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='电表度数变更表';

/*Data for the table `deviceDegreesLog` */

/*Table structure for table `district` */


CREATE TABLE `district` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personId` bigint(20) DEFAULT NULL COMMENT '用户id',
  `provinceCode` varchar(100) DEFAULT NULL COMMENT '省份',
  `cityCode` varchar(100) DEFAULT NULL COMMENT '城市',
  `areasCode` varchar(100) DEFAULT NULL COMMENT '区县',
  `provinceName` varchar(100) DEFAULT NULL COMMENT '省份名称',
  `cityName` varchar(100) DEFAULT NULL COMMENT '城市名称',
  `areasName` varchar(100) DEFAULT NULL COMMENT '区县名称',
  `districtImg` varchar(1000) DEFAULT NULL COMMENT '图片',
  `districtName` varchar(100) DEFAULT NULL COMMENT '小区名称',
  `address` varchar(2000) DEFAULT NULL COMMENT '地址',
  `roomCount` int(11) DEFAULT NULL COMMENT '房间数量',
  `managerCount` int(11) DEFAULT NULL COMMENT '管理员数量',
  `price` int(11) DEFAULT '0' COMMENT '电价 以分为单位',
  `waterprice` int(9) DEFAULT NULL,
  `hotwaterprice` int(9) DEFAULT NULL,
  `hotwaterfee` int(9) DEFAULT NULL,
  `shareAmount` int(11) DEFAULT '0' COMMENT '均摊费用 以分为单位',
  `autofee` int(11) DEFAULT '0',
  `remark` longtext COMMENT '备注',
  `inputDate` datetime DEFAULT NULL COMMENT '插入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='小区';

/*Data for the table `district` */
INSERT INTO `district` VALUES (1,1,'','','',NULL,NULL,NULL,'no-cell.jpg','default','',0,0,0,0,0,NULL,0,0,'',now());

/*Table structure for table `districtpaymentsetting` */


CREATE TABLE `districtpaymentsetting` (
  `districtpaymentsettingid` int(9) NOT NULL AUTO_INCREMENT,
  `districtid` int(9) DEFAULT NULL,
  `autofee` int(9) DEFAULT '0',
  `wexinpayappid` varchar(128) COLLATE utf8_bin DEFAULT NULL,
  `wexinpaymchid` varchar(128) COLLATE utf8_bin DEFAULT NULL,
  `wexinpayapikey` varchar(128) COLLATE utf8_bin DEFAULT NULL,
  `wexinpayappname` varchar(128) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`districtpaymentsettingid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `doorlockpasswordruledtl` */

/*Table structure for table `gateway` */


CREATE TABLE `gateway` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ptGatewayid` varchar(100) DEFAULT NULL COMMENT '平台网关id',
  `gatewayName` varchar(100) DEFAULT NULL COMMENT '网关名称',
  `managerId` bigint(20) DEFAULT NULL COMMENT '管理员id',
  `districtId` bigint(20) DEFAULT NULL COMMENT '小区id',
  `personId` bigint(20) DEFAULT NULL COMMENT '用户id',
  `signalFlag` int(11) DEFAULT NULL COMMENT '信号强度 0 在线；1 离线',
  `inputDate` datetime DEFAULT NULL COMMENT '插入时间',
  `devicetype` varchar(32) DEFAULT NULL COMMENT '网关类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='网关';

/*Data for the table `gateway` */

/*Table structure for table `lastTimeLog` */


CREATE TABLE `lastTimeLog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `lastId` bigint(100) DEFAULT NULL COMMENT '最后一次id',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='最后一次推送时间';

/*Data for the table `lastTimeLog` */

insert  into `lastTimeLog`(`id`,`lastId`) values (1,1);

/*Data for the table `manager` */

/*Table structure for table `openDeviceLog` */


CREATE TABLE `openDeviceLog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `inputDate` datetime DEFAULT NULL COMMENT '开门时间',
  `operateName` varchar(100) DEFAULT NULL COMMENT '开门人',
  `result` varchar(100) DEFAULT NULL COMMENT '结果 1 成功；0 失败',
  `personId` bigint(20) NOT NULL COMMENT '用户id',
  `districtId` bigint(20) DEFAULT NULL,
  `deviceId` bigint(20) DEFAULT NULL COMMENT '设备id',
  `type` varchar(40) DEFAULT NULL COMMENT '操作类型',
  `type2` int(8) DEFAULT NULL COMMENT '1:用户开门；2:临时密码开门；3:用户密码开门，密码编号%s；4:网络开门；5:设备关闭；6:自定义',
  `msg1` varchar(100) DEFAULT NULL,
  `operatepersonid` int(9) DEFAULT NULL COMMENT '操作者id',
  `securityPartitionId` bigint(20) DEFAULT NULL,
  `deviceType` int(9) DEFAULT NULL,
  `gatewayName` varchar(32) DEFAULT NULL,
  `gatewayId` varchar(32) DEFAULT NULL,
  `deviceName` varchar(64) DEFAULT NULL,
  `remark` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='开锁记录';

/*Data for the table `openDeviceLog` */

/*Table structure for table `operateLog` */


CREATE TABLE `operateLog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `operateType` int(11) NOT NULL COMMENT '日志类型 0系统登录；1添加小区；2删除小区；3修改小区；4 添加管理员；5 修改管理员；6 删除管理员；7 添加房间；8 修改房间；9 删除房间；10 授权用户；11 删除授权；12 同步设备；13 房间绑定设备；14 房间解除设备；15 电池电量低；16 设备离线；17 设备被拆卸；18 网关离线',
  `title` varchar(5000) DEFAULT NULL COMMENT '标题',
  `operateName` varchar(100) DEFAULT NULL COMMENT '操作人',
  `personId` bigint(20) DEFAULT NULL COMMENT '用户id',
  `ip` varchar(100) DEFAULT NULL COMMENT 'ip',
  `inputDate` datetime DEFAULT NULL COMMENT '操作时间',
  `businessId` bigint(20) DEFAULT NULL COMMENT '业务id',
  `msg1` varchar(1000) DEFAULT NULL COMMENT '存小区、房间等国际化所需信息',
  `msg2` varchar(1000) DEFAULT NULL,
  `msg3` varchar(1000) DEFAULT NULL,
  `operatepersonid` int(9) DEFAULT NULL COMMENT '操作者id',
  `districtId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='系统日志';

/*Table structure for table `powerPriceLog` */


CREATE TABLE `powerPriceLog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `month` int(11) NOT NULL COMMENT '月份，201401',
  `preMonthDegrees` float(15,2) DEFAULT NULL COMMENT '上个月度数',
  `currentDegrees` float(15,2) DEFAULT NULL COMMENT '当前度数',
  `monthDegrees` float(15,2) DEFAULT NULL COMMENT '本月用电量',
  `baseDegrees` float(15,2) DEFAULT NULL COMMENT '电表底数',
  `sumDegrees` float(15,2) DEFAULT NULL COMMENT '合计用电量',
  `price` int(11) DEFAULT NULL COMMENT '电价 以分为单位',
  `shareAmount` int(11) DEFAULT '0' COMMENT '均摊费用 以分为单位',
  `sumAmount` int(11) DEFAULT NULL COMMENT '本月电费合计 以分为单位',
  `inputDate` datetime DEFAULT NULL COMMENT '插入时间',
  `personId` bigint(20) DEFAULT NULL COMMENT '用户id',
  `deviceId` bigint(20) DEFAULT NULL COMMENT '设备id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='电价日志表';

/*Data for the table `powerPriceLog` */

/*Table structure for table `province` */


CREATE TABLE `province` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `provinceName` varchar(100) DEFAULT NULL COMMENT '省份名称',
  `provinceCode` varchar(50) DEFAULT NULL COMMENT '省份代码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='省份';

/*Data for the table `province` */
INSERT INTO `province` VALUES (1,'北京市','110000'),(2,'天津市','120000'),(3,'河北省','130000'),(4,'山西省','140000'),(5,'内蒙古自治区','150000'),(6,'辽宁省','210000'),(7,'吉林省','220000'),(8,'黑龙江省','230000'),(9,'上海市','310000'),(10,'江苏省','320000'),(11,'浙江省','330000'),(12,'安徽省','340000'),(13,'福建省','350000'),(14,'江西省','360000'),(15,'山东省','370000'),(16,'河南省','410000'),(17,'湖北省','420000'),(18,'湖南省','430000'),(19,'广东省','440000'),(20,'广西壮族自治区','450000'),(21,'海南省','460000'),(22,'重庆市','500000'),(23,'四川省','510000'),(24,'贵州省','520000'),(25,'云南省','530000'),(26,'西藏自治区','540000'),(27,'陕西省','610000'),(28,'甘肃省','620000'),(29,'青海省','630000'),(30,'宁夏回族自治区','640000'),(31,'新疆维吾尔自治区','650000'),(32,'台湾省','710000'),(33,'香港特别行政区','810000'),(34,'澳门特别行政区','820000');

/*Table structure for table `room` */


CREATE TABLE `room` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personId` bigint(20) NOT NULL COMMENT '用户id',
  `districtId` bigint(20) DEFAULT NULL COMMENT '小区id',
  `roomType` int(11) DEFAULT NULL COMMENT '房间类型 1 一居室；2 两居室；3 三居室',
  `roomName` varchar(100) DEFAULT NULL COMMENT '房间名称',
  `roomImg` varchar(1000) DEFAULT NULL COMMENT '图片',
  `rentfee` int(11) DEFAULT '0',
  `balance` int(11) DEFAULT '0',
  `arrearage` int(11) DEFAULT '0',
  `build` varchar(20) DEFAULT NULL COMMENT '栋',
  `unit` varchar(20) DEFAULT NULL COMMENT '单元',
  `floor` varchar(20) DEFAULT NULL COMMENT '楼',
  `grantFlag` int(11) DEFAULT NULL COMMENT '是否已授权 1 已授权；0 未授权',
  `grantUserName` varchar(100) DEFAULT NULL COMMENT '授权用户名',
  `grantRealName` varchar(100) DEFAULT NULL COMMENT '授权租客名称',
  `grantBeginDate` datetime DEFAULT NULL COMMENT '授权开始时间',
  `grantEndDate` datetime DEFAULT NULL COMMENT '授权结束时间',
  `remark` longtext COMMENT '备注',
  `inputDate` datetime DEFAULT NULL COMMENT '插入时间',
  `third_roomAddress` varchar(2048) DEFAULT NULL,
  `typeinpersonid` int(9) NOT NULL COMMENT '建立房间的管理员id',
  PRIMARY KEY (`id`),
  KEY `FK_fk_room_district` (`districtId`),
  CONSTRAINT `FK_fk_room_district` FOREIGN KEY (`districtId`) REFERENCES `district` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='房间';

/*Data for the table `room` */


CREATE TABLE `roomdevicedetail` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `roomid` int(20) NOT NULL,
  `dvcid` int(20) NOT NULL,
  `personaccount` varchar(128) COLLATE utf8_bin NOT NULL,
  `usercode` int(9) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Table structure for table `roomfee` */


CREATE TABLE `roomfee` (
  `roomfeeid` int(9) NOT NULL AUTO_INCREMENT,
  `roomid` int(9) NOT NULL,
  `month` int(9) NOT NULL,
  `electricitypremonthdegree` float(15,2) DEFAULT NULL,
  `electricitycurrentdegrees` float(15,2) DEFAULT NULL,
  `electricityprice` int(9) DEFAULT NULL,
  `electricityfee` int(9) NOT NULL,
  `waterpremonthdegree` float(15,2) DEFAULT NULL,
  `watercurrentdegrees` float(15,2) DEFAULT NULL,
  `waterprice` int(9) DEFAULT NULL,
  `waterfee` int(9) NOT NULL,
  `hotwaterpremonthdegree` float(15,2) DEFAULT NULL,
  `hotwatercurrentdegrees` float(15,2) DEFAULT NULL,
  `hotwaterprice` int(9) DEFAULT NULL,
  `hotwaterfee` int(9) NOT NULL,
  `pooledfee` int(9) NOT NULL,
  `rentfee` int(9) NOT NULL DEFAULT '0',
  `totalamount` int(9) NOT NULL,
  `status` int(9) NOT NULL DEFAULT '0',
  PRIMARY KEY (`roomfeeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `roomfee` */

/*Table structure for table `roomprivilege` */


CREATE TABLE `roomprivilege` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `countrycode` varchar(8) COLLATE utf8_bin DEFAULT NULL,
  `roomId` int(9) NOT NULL,
  `typeinpersonid` int(9) DEFAULT NULL,
  `grantUserName` varchar(128) COLLATE utf8_bin NOT NULL,
  `grantRealName` varchar(128) COLLATE utf8_bin NOT NULL,
  `remark` varchar(512) COLLATE utf8_bin DEFAULT NULL,
  `inputDate` datetime DEFAULT NULL,
  `grantBeginDate` datetime NOT NULL,
  `grantEndDate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `roomprivilege` */

/*Table structure for table `securitypartition` */


CREATE TABLE `securitypartition` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `partitionId` int(9) NOT NULL,
  `partitionName` varchar(128) NOT NULL,
  `armStatus` int(9) NOT NULL DEFAULT '0',
  `warningStatus` int(9) NOT NULL DEFAULT '0',
  `personId` bigint(20) NOT NULL,
  `districtId` bigint(20) NOT NULL,
  `roomId` bigint(20) DEFAULT NULL,
  `managerId` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

/*Data for the table `securitypartition` */

/*Table structure for table `smshistory` */


CREATE TABLE `smshistory` (
  `smshistoryid` int(9) NOT NULL AUTO_INCREMENT,
  `countrycode` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '86',
  `phonenumber` varchar(64) COLLATE utf8_bin NOT NULL,
  `personId` bigint(20) NOT NULL COMMENT '用户id',
  `districtId` bigint(20) DEFAULT NULL COMMENT '小区id',
  `districtName` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '小区名称',
  `roomName` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '房间名称',
  `build` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '栋',
  `unit` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '单元',
  `floor` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '楼',
  `message` varchar(512) COLLATE utf8_bin NOT NULL,
  `status` int(9) NOT NULL DEFAULT '1',
  `createtime` datetime NOT NULL,
  `sendtime` datetime DEFAULT NULL,
  PRIMARY KEY (`smshistoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `smshistory` */

/*Table structure for table `systemparameter` */


CREATE TABLE `systemparameter` (
  `strkey` varchar(32) COLLATE utf8_bin NOT NULL,
  `strvalue` varchar(1024) COLLATE utf8_bin DEFAULT NULL,
  `intvalue` int(9) DEFAULT NULL,
  PRIMARY KEY (`strkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `systemparameter` */

/*Table structure for table `tb_sequence` */


CREATE TABLE `tb_sequence` (
  `name` varchar(50) NOT NULL,
  `current_value` int(11) NOT NULL,
  `_increment` int(11) NOT NULL DEFAULT '1',
  `increment` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `tb_sequence` */

insert  into `tb_sequence`(`name`,`current_value`,`_increment`,`increment`) values ('districtManager',1,1,1);

/*Table structure for table `third_cardinfo` */


CREATE TABLE `third_cardinfo` (
  `customerid` int(9) NOT NULL,
  `type` int(11) NOT NULL,
  `name` varchar(256) COLLATE utf8_bin DEFAULT NULL,
  `certNo` varchar(256) COLLATE utf8_bin DEFAULT NULL,
  `data` varchar(2048) COLLATE utf8_bin DEFAULT NULL,
  `remark` varchar(512) COLLATE utf8_bin DEFAULT NULL,
  `inputDate` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`customerid`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `third_cardinfo` */

/*Table structure for table `third_send` */


CREATE TABLE `third_send` (
  `id` varchar(128) COLLATE utf8_bin NOT NULL,
  `type` int(11) DEFAULT NULL,
  `operate` int(11) DEFAULT NULL,
  `name` varchar(256) COLLATE utf8_bin DEFAULT NULL,
  `certNo` varchar(256) COLLATE utf8_bin DEFAULT NULL,
  `roomID` varchar(256) COLLATE utf8_bin DEFAULT NULL,
  `roomAddress` varchar(512) COLLATE utf8_bin DEFAULT NULL,
  `beginDate` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `endDate` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `data` varchar(2048) COLLATE utf8_bin DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `third_send` */

/*Table structure for table `transaction` */


CREATE TABLE `transaction` (
  `transactionid` int(9) NOT NULL AUTO_INCREMENT,
  `roomid` int(9) NOT NULL,
  `transactiontype` int(9) NOT NULL,
  `description` varchar(256) COLLATE utf8_bin NOT NULL,
  `amount` int(9) NOT NULL,
  `prebalance` int(9) DEFAULT NULL,
  `postbalance` int(9) DEFAULT NULL,
  `status` int(9) NOT NULL,
  `createtime` datetime NOT NULL,
  `finishtime` datetime DEFAULT NULL,
  `tptransactionid` varchar(256) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`transactionid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `transaction` */


CREATE TABLE `fingerprint` (
    `fingerprintid` INT(9) NOT NULL AUTO_INCREMENT,
     `name` VARCHAR(64) NOT NULL,
      `fingerprint` VARCHAR(16384) NOT NULL,
       `customerid` INT(9) NOT NULL,
        `createtime` DATETIME NOT NULL,
         PRIMARY KEY (`fingerprintid`)
                           )ENGINE=InnoDB DEFAULT CHARSET=utf8;

alter table gateway add UNIQUE(ptGatewayid);

alter table roomprivilege add column granttype varchar(512);


CREATE TABLE IF NOT EXISTS `customerdistrict` (
  `customerdistrictid` int(11) NOT NULL AUTO_INCREMENT,
  `customerid` int(11) NOT NULL DEFAULT '0',
  `districtid` int(11) NOT NULL DEFAULT '0',
  `createtime` datetime NOT NULL,
  `deletetime` datetime DEFAULT NULL,
  `status` int(9) NOT NULL COMMENT '1:正常 9：删除',
  PRIMARY KEY (`customerdistrictid`),
  KEY `customerid` (`customerid`)
) ENGINE=InnoDB AUTO_INCREMENT=1606 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

alter table room add index districtid(`districtid`);
alter table fingerprint add index customerid(`customerid`);

CREATE EVENT `st_delete_deviceBatteryLog`
	ON SCHEDULE
		EVERY 1 DAY STARTS '2007-07-20 03:00:00'
	ON COMPLETION NOT PRESERVE
	ENABLE
	COMMENT ''
	DO DELETE FROM deviceBatteryLog WHERE inputdate < SUBDATE(CURDATE(),INTERVAL 6 MONTH);
	
CREATE EVENT `st_delete_deviceDegreesHourLog`
	ON SCHEDULE
		EVERY 1 DAY STARTS '2007-07-20 03:00:00'
	ON COMPLETION NOT PRESERVE
	ENABLE
	COMMENT ''
	DO DELETE FROM deviceDegreesHourLog WHERE inputdate < SUBDATE(CURDATE(),INTERVAL 6 MONTH);	
	
CREATE EVENT `st_delete_deviceDegreesLog`
	ON SCHEDULE
		EVERY 1 DAY STARTS '2007-07-20 03:00:00'
	ON COMPLETION NOT PRESERVE
	ENABLE
	COMMENT ''
	DO DELETE FROM deviceDegreesLog WHERE inputdate < SUBDATE(CURDATE(),INTERVAL 6 MONTH);	


CREATE EVENT `st_delete_openDeviceLog`
	ON SCHEDULE
		EVERY 1 DAY STARTS '2007-07-20 03:00:00'
	ON COMPLETION NOT PRESERVE
	ENABLE
	COMMENT ''
	DO DELETE FROM openDeviceLog WHERE inputdate < SUBDATE(CURDATE(),INTERVAL 6 MONTH);
	
CREATE EVENT `st_delete_operateLog`
	ON SCHEDULE
		EVERY 1 DAY STARTS '2007-07-20 03:00:00'
	ON COMPLETION NOT PRESERVE
	ENABLE
	COMMENT ''
	DO DELETE FROM operateLog WHERE inputdate < SUBDATE(CURDATE(),INTERVAL 6 MONTH);
	
