资讯详情

mysql 统计市县的数量

现在需要统计浙江省各市县大东北烧烤的数量(注:数据仅用于演示demo使用,实际调查考证为主),要求先统计各县区数量,在总结统计各县区数量。

来吧,话不多,开始吧。

先来一个行政区划表:

/*  Navicat Premium Data Transfer   Source Server         : localhost_3306  Source Server Type    : MySQL  Source Server Version : 50636  Source Host           : localhost:3306  Source Schema         : test3   Target Server Type    : MySQL  Target Server Version : 50636  File Encoding         : 65001   Date: 02/06/2022 10:39:23 */  SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0;  -- ---------------------------- -- Table structure for obj_ad -- ---------------------------- DROP TABLE IF EXISTS `obj_ad`; CREATE TABLE `obj_ad`  (   `AD_CODE` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 行政区划代码,   `AD_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 行政区划名称,   `UP_ADCD` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上级行政区划编码',   `UP_ADCD_KFQ` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 包括开发区上级区划编码,   `AD_LEV` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 行政区划级别,   `IS_KFQ` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 是否为开发区,   `ADCD` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 行政区划编码,   PRIMARY KEY (`AD_CODE`) USING BTREE,   UNIQUE INDEX `IX_ADCD`(`ADCD`) USING BTREE,   INDEX `IX_UP_ADCD`(`UP_ADCD`) USING BTREE,   INDEX `IX_AD_NAME`(`AD_NAME`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 行政区划清单 ROW_FORMAT = Compact;  -- ---------------------------- -- Records of obj_ad -- ---------------------------- INSERT INTO `obj_ad` VALUES ('00154f85-6d10-4674-9f09-ee55c1785d3f', 善琏镇, '330503', NULL, '3', '0', '330503103'); INSERT INTO `obj_ad` VALUES ('002feeeb-dcf4-4d80-9f9a-004550bd3e4f', 黄南乡, '330324', NULL, '3', '0', '330324220'); INSERT INTO `obj_ad` VALUES ('0065698f-5cba-4340-b531-1f7c6a0da013', 曲溪街, '330304', NULL, '3', '0', '330304008'); INSERT INTO `obj_ad` VALUES ('009a3781-e93c-4f8f-9fab-ce94480c78e5', 白云街, '330802', NULL, '3', '0', '330802009'); INSERT INTO `obj_ad` VALUES ('009c32d2-8eab-452e-a2e2-1cbf3e456cbd', 县本级, '330411', NULL, '3', '0', '330411000'); INSERT INTO `obj_ad` VALUES ('00fc59d5-7055-4013-895d-a77b49b4c841', 道墟镇, '330604', NULL, '3', '0', '330604100'); INSERT INTO `obj_ad` VALUES ('010ea9b3-0e45-4073-b7a4-e0e0ba8d3c7c', 茅洋乡, '330225', NULL, '3', '0', '330225011'); INSERT INTO `obj_ad` VALUES ('012aa7d2-b254-4ddf-af17-80e3cb8dd04a', 前进街道, '330193', NULL, '3', '0', '330193011'); INSERT INTO `obj_ad` VALUES ('01728bf9-aae8-4220-ad69-a622e3c1d77f', 展茅街, '330903', NULL, '3', '0', '330903005'); INSERT INTO `obj_ad` VALUES ('017bc5f7-f86e-4f01-a7d6-59847cbd1a4a', 游埠镇, '330781', NULL, '3', '0', '330781102'); INSERT INTO `obj_ad` VALUES ('01997299-bcbf-43b3-ba8b-6eb6946f9530', 岭南乡, '330682', NULL, '3', '0', '330682200'); INSERT INTO `obj_ad` VALUES ('01a4d116-135b-4b76-893e-662e5a22abbe', 北山镇, '331121', NULL, '3', '0', '331121107'); INSERT INTO `obj_ad` VALUES ('01afe30d-64d4-4ca3-9413-bded47325377', 永昌街, '330781', NULL, '3', '0', '330781004'); INSERT INTO `obj_ad` VALUES ('01bf0f16-43e2-405b-a2d6-8d09c2593d8e', 凤川街, '330122', NULL, '3', '0', '330122005'); INSERT INTO `obj_ad` VALUES ('01c5b717-fa83-4811-ba62-d974f69f0d12', 清波街 '330102', NULL, '3', '0', '330102001'); INSERT INTO `obj_ad` VALUES ('01ceb83c-3f97-4a6e-a857-0774959e2e9a', 括苍镇, '331082', NULL, '3', '0', '331082107'); INSERT INTO `obj_ad` VALUES ('01fbc32d-061d-4b0a-ac5d-f858ba4d150f', 陈宅镇, '330681', NULL, '3', '0', '330681125'); INSERT INTO `obj_ad` VALUES ('024b155a-2900-4fa8-9e09-787038ed60a0', '荆谷乡', '330381', NULL, '3', '0', '330381201'); INSERT INTO `obj_ad` VALUES ('024c630f-8c94-49f9-baaf-3fd54b699041', 石柱镇, '330784', NULL, '3', '0', '330784105'); INSERT INTO `obj_ad` VALUES ('027df948-fce3-4640-aac4-cbe01e61c4f6', 绿色产业集聚区, '3308', NULL, '2', '0', '330884'); INSERT INTO `obj_ad` VALUES ('027f3c7f-3b31-456a-821c-61535398d5ab', 城西街道, '330782', NULL, '3', '0', '330782006'); INSERT INTO `obj_ad` VALUES ('02c05f14-f411-4ac5-8a84-6e39293c3024', 开发区, '330781', NULL, '3', '0', '330781210'); INSERT INTO `obj_ad` VALUES ('02ff3897-1b06-4cbe-930e-36c6dab777d5', 仙岩镇, '330304', NULL, '3', '0', '330304110'); INSERT INTO `obj_ad` VALUES ('0372151f-248b-465a-803e-094defdb9b72', 齐贤街, '330603', NULL, '3', '0', '330603005'); INSERT INTO `obj_ad` VALUES ('03b31bf6-db5e-46ef-8dac-b15dd045969d', 海宁市, '3304', NULL, '2', '0', '330481'); INSERT INTO `obj_ad` VALUES ('03b49f29-c490-418c-93da-08f6b5379006', 招宝山街, '330211', NULL, '3', '0', '330211006'); INSERT INTO `obj_ad` VALUES ('03b5b765-8077-42bb-aff0-444071e3eaad', 长塘镇, '330682', NULL, '3', '0','330682101');
INSERT INTO `obj_ad` VALUES ('03bccb11-a64b-4e9d-9dd0-2bf7c7e20cb2', '丽水市', '33', NULL, '1', '0', '3311');
INSERT INTO `obj_ad` VALUES ('03c24628-21aa-4212-8e19-475c4b46a1a5', '龙港市', '3303', NULL, '2', '0', '330383');
INSERT INTO `obj_ad` VALUES ('03e9a23a-fb39-4fe2-93eb-510de5390ad8', '县本级', '330328', NULL, '3', '0', '330328000');
INSERT INTO `obj_ad` VALUES ('03f8c7e1-b792-4514-a60f-71007f0884c0', '新明街道', '330204', NULL, '3', '0', '330204008');
INSERT INTO `obj_ad` VALUES ('04596f13-7586-4f9b-ab93-1c34f081be77', '南塘镇', '330382', NULL, '3', '0', '330382122');
INSERT INTO `obj_ad` VALUES ('04631f78-9315-4a2a-bd6a-1f8273f761fb', '许村镇', '330481', NULL, '3', '0', '330481101');
INSERT INTO `obj_ad` VALUES ('048c5098-96f3-4414-92bf-0c7ce2dd9532', '飞云街道', '330381', NULL, '3', '0', '330381014');
INSERT INTO `obj_ad` VALUES ('0491f491-58ab-4a2e-9eb6-3206583dafb6', '松源镇', '331126', NULL, '3', '0', '331126100');
INSERT INTO `obj_ad` VALUES ('04c23d0d-83bd-4df4-baac-e338a16f8231', '凤林镇', '330881', NULL, '3', '0', '330881118');
INSERT INTO `obj_ad` VALUES ('04d42e0a-8afb-4f38-9249-42558c4a4aaa', '前进街道', '330109', NULL, '3', '0', '330109011');
INSERT INTO `obj_ad` VALUES ('04d5b5e4-2019-4c18-babc-a6e4e7602d7b', '石笕乡', '331122', NULL, '3', '0', '331122212');
INSERT INTO `obj_ad` VALUES ('04d9ef15-5fb1-4947-842f-99ad2f18130b', '县本级', '330682', NULL, '3', '0', '330682000');
INSERT INTO `obj_ad` VALUES ('04f55ed7-fc5d-4cbc-94bd-002bed4cd313', '信安街道', '330885', NULL, '3', '0', '330885002');
INSERT INTO `obj_ad` VALUES ('05187c7d-68ca-4625-a2f5-1e44214d6993', '彭埠镇', '330104', NULL, '3', '0', '330104102');
INSERT INTO `obj_ad` VALUES ('0522f961-169c-42ce-b71d-57e8025d050e', '柳市镇', '330382', NULL, '3', '0', '330382114');
INSERT INTO `obj_ad` VALUES ('0544425f-4c67-4ec7-bd54-b91d11210825', '石淙镇', '330503', NULL, '3', '0', '330503108');
INSERT INTO `obj_ad` VALUES ('0554c21a-6ae8-4863-8b58-54fbefbfa2fb', '跶石乡', '331181', NULL, '3', '0', '331181201');
INSERT INTO `obj_ad` VALUES ('0558d54c-2eb8-492c-886b-bc4285d64f59', '十里丰农场', '330803', NULL, '3', '0', '330803222');
INSERT INTO `obj_ad` VALUES ('0584a8fa-5f91-40c4-86b8-1c220fc72860', '平阳县', '3303', NULL, '2', '0', '330326');
INSERT INTO `obj_ad` VALUES ('0593c123-062c-4ab9-b92c-eb4cbe0968ea', '河山镇', '330483', NULL, '3', '0', '330483104');
INSERT INTO `obj_ad` VALUES ('05b08701-a0d7-4d89-b6b0-738de62020a4', '曹宅镇', '330703', NULL, '3', '0', '330703103');
INSERT INTO `obj_ad` VALUES ('05b44b86-0050-4642-9235-fb788b21b1c5', '大源镇', '330183', NULL, '3', '0', '330183117');
INSERT INTO `obj_ad` VALUES ('05c9d3be-e3a2-437a-a168-b9dffc4aa132', '檀溪镇', '330726', NULL, '3', '0', '330726106');
INSERT INTO `obj_ad` VALUES ('05cd167c-8818-4a59-b573-e79f51a0b8ae', '温泉度假区', '330723', NULL, '3', '0', '330723207');
INSERT INTO `obj_ad` VALUES ('05d50a52-d9ed-47cd-8021-6cf1ce225a73', '怀溪镇', '330326', NULL, '3', '0', '330326122');
INSERT INTO `obj_ad` VALUES ('05d681c8-98b5-4bb7-9a67-c5f72ede2db1', '郭溪镇', '330304', NULL, '3', '0', '330304105');
INSERT INTO `obj_ad` VALUES ('05dc0850-67a8-4e6c-9033-9d6763ee7bf4', '西坞街道', '330213', NULL, '3', '0', '330213004');
INSERT INTO `obj_ad` VALUES ('05e4dcf9-2ea9-4c1f-8895-367d330b2458', '表山乡', '330324', NULL, '3', '0', '330324212');
INSERT INTO `obj_ad` VALUES ('05f75af2-e61e-4797-a246-372d16be667f', '三都镇', '330182', NULL, '3', '0', '330182108');
INSERT INTO `obj_ad` VALUES ('05fe4bba-7917-403b-876c-f39a055cba1e', '米市巷街道', '330105', NULL, '3', '0', '330105001');
INSERT INTO `obj_ad` VALUES ('05fe75b9-ec85-4c87-b7ca-11fa83b7155a', '白泉镇', '330902', NULL, '3', '0', '330902104');
INSERT INTO `obj_ad` VALUES ('063fcefa-a13a-4c83-87fc-c2056ad25b38', '李家巷镇', '330522', NULL, '3', '0', '330522102');
INSERT INTO `obj_ad` VALUES ('064ce284-f3d6-4a06-8ef6-5202bd216a80', '儒岙镇', '330624', NULL, '3', '0', '330624110');
INSERT INTO `obj_ad` VALUES ('06da4ff3-dcfb-4263-8ad0-5d137bbe294d', '徐岙乡', '330324', NULL, '3', '0', '330324201');
INSERT INTO `obj_ad` VALUES ('06e1dabc-be1a-435f-93bc-2008a73c295e', '虞北海涂', '330682', NULL, '3', '0', '330682204');
INSERT INTO `obj_ad` VALUES ('06e4c3b3-2397-4a35-9d51-c78f08a9eaf8', '岭北镇', '330681', NULL, '3', '0', '330681121');
INSERT INTO `obj_ad` VALUES ('06e9afb8-dabb-49db-80d0-4616a5c7c5fa', '海溪乡', '331121', NULL, '3', '0', '331121204');
INSERT INTO `obj_ad` VALUES ('07217364-0a7a-4217-ad4d-44e1dbb7d392', '遂昌县', '3311', NULL, '2', '0', '331123');
INSERT INTO `obj_ad` VALUES ('0726acef-625e-45cd-a2e3-f5e6d186f671', '潘火管委会', '330212', NULL, '3', '0', '330212201');
INSERT INTO `obj_ad` VALUES ('07599723-1eb3-43ca-ac17-8294d324b9c2', '五乡镇', '330212', NULL, '3', '0', '330212105');
INSERT INTO `obj_ad` VALUES ('07668420-cd2f-4af3-8ffb-c1721cdcdea0', '椒江农场', '331002', NULL, '3', '0', '331002009');
INSERT INTO `obj_ad` VALUES ('076c7ff3-f752-4857-ac74-93e96ba26cc2', '鸠坑乡', '330127', NULL, '3', '0', '330127211');
INSERT INTO `obj_ad` VALUES ('079c6c30-1443-46b0-8805-d2e636a17900', '暨阳街道', '330681', NULL, '3', '0', '330681001');
INSERT INTO `obj_ad` VALUES ('07a84500-e5d5-4469-8f67-da8622f45ede', '郭巨街道', '330206', NULL, '3', '0', '330206010');
INSERT INTO `obj_ad` VALUES ('07ad3d15-5ad8-4d60-8bc5-00c1f4c57157', '梁湖镇', '330682', NULL, '3', '0', '330682108');
INSERT INTO `obj_ad` VALUES ('07f7a1f3-de23-43a9-9999-55f8f97d12d7', '钱清街道', '330603', NULL, '3', '0', '330603009');
INSERT INTO `obj_ad` VALUES ('08156b08-8578-4ef7-9d4d-e9eff3a83bf1', '洋埠镇', '330704', NULL, '3', '0', '330704108');
INSERT INTO `obj_ad` VALUES ('082e68a6-ab5f-4bad-8930-41bc0b1d32f2', '县本级', '330681', NULL, '3', '0', '330681000');
INSERT INTO `obj_ad` VALUES ('083acbe7-2e3d-4a48-9f25-4aae14862003', '碧山镇', '330381', NULL, '3', '0', '330381121');
INSERT INTO `obj_ad` VALUES ('083f5759-fff4-4b2f-a46b-31ec44db4bcd', '荷地镇', '331126', NULL, '3', '0', '331126104');
INSERT INTO `obj_ad` VALUES ('085ba68d-71f5-4ae8-87eb-a4069eb5625d', '云和镇', '331125', NULL, '3', '0', '331125100');
INSERT INTO `obj_ad` VALUES ('088c0f9e-250b-4c19-9a86-726f6912a59f', '里山镇', '330183', NULL, '3', '0', '330183108');
INSERT INTO `obj_ad` VALUES ('08d7a24a-3619-471d-b69d-0835a7a092c1', '大畈乡', '330726', NULL, '3', '0', '330726200');
INSERT INTO `obj_ad` VALUES ('08de64b8-12a5-447b-844a-8792660a2e5b', '莪山畲族乡', '330122', NULL, '3', '0', '330122201');
INSERT INTO `obj_ad` VALUES ('08f28ed3-7849-4749-9563-048cba889b7e', '县本级', '330825', NULL, '3', '0', '330825000');
INSERT INTO `obj_ad` VALUES ('091ef9b0-2cd5-4bae-b09a-287c8e4f43db', '拱宸桥街道', '330105', NULL, '3', '0', '330105005');
INSERT INTO `obj_ad` VALUES ('0931b818-fe26-48b9-9e0c-1e154e14fae9', '螺洋街道', '331004', NULL, '3', '0', '331004004');
INSERT INTO `obj_ad` VALUES ('093cb2a6-98d8-438a-8af1-8eaa9244c9c5', '县本级', '330903', NULL, '3', '0', '330903000');
INSERT INTO `obj_ad` VALUES ('096d667b-4975-416e-9a3b-e5e8102ad595', '岛石镇', '330112', NULL, '3', '0', '330112113');
INSERT INTO `obj_ad` VALUES ('09d8089b-8ffa-4f7f-a240-2592f5c9f5e6', '马金镇', '330824', NULL, '3', '0', '330824116');
INSERT INTO `obj_ad` VALUES ('09dfbc1d-9138-496c-8fa5-f982b7cc5268', '云坛乡', '331125', NULL, '3', '0', '331125203');
INSERT INTO `obj_ad` VALUES ('09e286b6-d88f-48b8-bc11-069a7c848651', '梅山乡', '330206', NULL, '3', '0', '330206201');
INSERT INTO `obj_ad` VALUES ('09e4adb3-a08c-4a5d-ac1b-b42556f2be11', '北城街道', '331003', NULL, '3', '0', '331003004');
INSERT INTO `obj_ad` VALUES ('09fda0bd-c75c-4770-a07c-10c7b9816a96', '咸祥镇', '330212', NULL, '3', '0', '330212101');
INSERT INTO `obj_ad` VALUES ('0a19a713-9511-4116-9fea-0d3ed8404565', '瓜沥镇', '330109', NULL, '3', '0', '330109113');
INSERT INTO `obj_ad` VALUES ('0a618974-5049-4416-b9d1-5deea9c7b924', '上望街道', '330381', NULL, '3', '0', '330381005');
INSERT INTO `obj_ad` VALUES ('0a7d7fdc-6a12-43be-8e5d-7c0c9c9a5ca7', '沙头镇', '330324', NULL, '3', '0', '330324111');
INSERT INTO `obj_ad` VALUES ('0a80997b-3894-482b-bca4-8e02f29d4cb5', '福全街道', '330603', NULL, '3', '0', '330603006');
INSERT INTO `obj_ad` VALUES ('0abe24ff-dece-448f-8288-908ae070a32f', '朗霞街道', '330281', NULL, '3', '0', '330281006');
INSERT INTO `obj_ad` VALUES ('0add7fe6-9fc7-498e-b468-a76380a561df', '武义县', '3307', NULL, '2', '0', '330723');
INSERT INTO `obj_ad` VALUES ('0af39957-8860-46ba-aa04-ed995e87223b', '茶山街道', '330304', NULL, '3', '0', '330304004');
INSERT INTO `obj_ad` VALUES ('0b1c5bbd-c9e2-4c6e-943b-fd2b9cffc4e0', '县本级', '330327', NULL, '3', '0', '330327000');
INSERT INTO `obj_ad` VALUES ('0b6851dc-3e76-4980-bb70-6840e7c95fef', '西溪镇', '330784', NULL, '3', '0', '330784111');
INSERT INTO `obj_ad` VALUES ('0b931d98-f247-4271-9bea-7092ea07716b', '硖石街道', '330481', NULL, '3', '0', '330481001');
INSERT INTO `obj_ad` VALUES ('0bab277c-6c72-42bd-a8b0-43087d15389b', '石碶街道', '330203', NULL, '3', '0', '330203009');
INSERT INTO `obj_ad` VALUES ('0bf69f39-84c4-4cef-8e92-31f42541771c', '泽国镇', '331081', NULL, '3', '0', '331081100');
INSERT INTO `obj_ad` VALUES ('0c01ac05-e8ee-4d04-9c43-9171cbfb79e3', '白杨街道', '330191', NULL, '3', '0', '330191009');
INSERT INTO `obj_ad` VALUES ('0c07b72b-cf03-4639-a119-cb19a94f0e5b', '瑶琳镇', '330122', NULL, '3', '0', '330122110');
INSERT INTO `obj_ad` VALUES ('0c0a1c97-722f-40c2-961d-c978d07543ce', '江北区', '3302', NULL, '2', '0', '330205');
INSERT INTO `obj_ad` VALUES ('0c2e10cf-abb1-4f88-aa5a-d4600ad26ba6', '驿亭镇', '330682', NULL, '3', '0', '330682109');
INSERT INTO `obj_ad` VALUES ('0c3b1aa1-491f-49ab-a515-a2a90094a518', '龙洋乡', '331123', NULL, '3', '0', '331123207');
INSERT INTO `obj_ad` VALUES ('0c5efdb5-d378-447b-af37-bd4b4d24cc3c', '掌起镇', '330282', NULL, '3', '0', '330282016');
INSERT INTO `obj_ad` VALUES ('0cb2321d-e708-4fe8-9450-ec05c89bb460', '瑶溪街道', '330303', NULL, '3', '0', '330303007');
INSERT INTO `obj_ad` VALUES ('0cd21d05-13cd-41fd-8736-40bed0bc9869', '苍南县', '3303', NULL, '2', '0', '330327');
INSERT INTO `obj_ad` VALUES ('0cf713ce-bc16-4b3d-8deb-f2dcc88c419a', '段塘街道', '330203', NULL, '3', '0', '330203007');
INSERT INTO `obj_ad` VALUES ('0d150c1b-212b-496b-b670-bda871a121ec', '三墩镇', '330106', NULL, '3', '0', '330106109');
INSERT INTO `obj_ad` VALUES ('0d308e20-b4ed-4b49-b02c-bf4cea5f4bfd', '中洲镇', '330127', NULL, '3', '0', '330127109');
INSERT INTO `obj_ad` VALUES ('0d4e5a7c-dd68-4604-8cf7-746ea2546891', '龙南乡', '331181', NULL, '3', '0', '331181207');
INSERT INTO `obj_ad` VALUES ('0d4ee725-19d5-4926-917c-c7b1fb8dddf9', '王村口镇', '331123', NULL, '3', '0', '331123107');
INSERT INTO `obj_ad` VALUES ('0d5082b7-b4f4-4d33-ba3b-12cbac4edb52', '山口镇', '331121', NULL, '3', '0', '331121108');
INSERT INTO `obj_ad` VALUES ('0d94b5de-25fe-478c-861c-e9bda6ed080b', '章镇镇', '330604', NULL, '3', '0', '330604104');
INSERT INTO `obj_ad` VALUES ('0dd7622e-49da-4f54-84be-1d7087717389', '源东乡', '330703', NULL, '3', '0', '330703200');
INSERT INTO `obj_ad` VALUES ('0e362c10-9861-4110-941d-e351db46a379', '后溪镇', '330803', NULL, '3', '0', '330803111');
INSERT INTO `obj_ad` VALUES ('0e6b4e76-508a-4765-a2ed-2148442e8ec8', '渤海镇', '331127', NULL, '3', '0', '331127101');
INSERT INTO `obj_ad` VALUES ('0e6f1b02-1bce-4c5f-ab8a-3dca5bbdc90d', '东海农场', '330902', NULL, '3', '0', '330902166');
INSERT INTO `obj_ad` VALUES ('0ebef1f8-a683-43ae-8db7-7acc951d5fd4', '上林乡', '330328', NULL, '3', '0', '330328221');
INSERT INTO `obj_ad` VALUES ('0edacc68-eb86-4dd6-bed5-194f2c18250b', '大唐镇', '330681', NULL, '3', '0', '330681101');
INSERT INTO `obj_ad` VALUES ('0ee0ed81-f217-441b-90f6-61a8498c7de9', '桃源街道', '330226', NULL, '3', '0', '330226002');
INSERT INTO `obj_ad` VALUES ('0ee44af5-5ce4-46af-ad7f-ef149214620d', '辉埠镇', '330822', NULL, '3', '0', '330822113');
INSERT INTO `obj_ad` VALUES ('0f468661-6686-432f-98ff-aa62982fe72c', '澄潭街道', '330624', NULL, '3', '0', '330624004');
INSERT INTO `obj_ad` VALUES ('0f4ed7f2-f7e9-48fe-8365-b75432d45418', '长河街道', '330108', NULL, '3', '0', '330108002');
INSERT INTO `obj_ad` VALUES ('0f607288-c6b0-449c-8e9e-489ca92a0f57', '顺泰乡', '330381', NULL, '3', '0', '330381203');
INSERT INTO `obj_ad` VALUES ('0f6424c2-8075-4e74-b056-c1e1bde680d3', '岩头镇', '330726', NULL, '3', '0', '330726105');
INSERT INTO `obj_ad` VALUES ('0f960882-f258-4a10-bc06-cc70dfa0c743', '西屏街道', '331124', NULL, '3', '0', '331124100');
INSERT INTO `obj_ad` VALUES ('0f9b5b27-fdda-4a1a-92c8-6d1e1f134956', '梅屿乡', '330381', NULL, '3', '0', '330381202');
INSERT INTO `obj_ad` VALUES ('0fadf032-f4b0-4125-be3a-ff53705255d0', '万全镇', '330326', NULL, '3', '0', '330326117');
INSERT INTO `obj_ad` VALUES ('0fd0139a-7172-4c91-9a12-228519aa0acd', '宁益乡', '330381', NULL, '3', '0', '330381217');
INSERT INTO `obj_ad` VALUES ('1017fd53-3f0b-4340-9a3c-45bc9c264284', '梓桐镇', '330127', NULL, '3', '0', '330127107');
INSERT INTO `obj_ad` VALUES ('105c278b-e79f-48a2-994d-9a402472cb88', '县工业园区', '330327', NULL, '3', '0', '330327310');
INSERT INTO `obj_ad` VALUES ('105de638-c45f-4efe-9adb-4dd9c4e60dbd', '乾西乡', '330702', NULL, '3', '0', '330702201');
INSERT INTO `obj_ad` VALUES ('107c7e15-f889-44b2-87ab-3958a5ba2ad4', '龟湖镇', '330329', NULL, '3', '0', '330329112');
INSERT INTO `obj_ad` VALUES ('10951786-9402-4bbe-92a9-cfce218770e4', '县本级', '330602', NULL, '3', '0', '330602000');
INSERT INTO `obj_ad` VALUES ('1096b520-4419-4dcc-8df4-5805ec9aabfe', '泉溪镇', '330723', NULL, '3', '0', '330723103');
INSERT INTO `obj_ad` VALUES ('10cb1753-c28f-4480-bd1b-934764c49feb', '壶镇镇', '331122', NULL, '3', '0', '331122101');
INSERT INTO `obj_ad` VALUES ('10eb3cf4-fc71-4fd5-bb47-950b55929eb0', '住建局', '330225', NULL, '3', '0', '330225021');
INSERT INTO `obj_ad` VALUES ('10fd3909-4535-4f07-9cd0-c00ac75d422b', '澉浦镇', '330424', NULL, '3', '0', '330424105');
INSERT INTO `obj_ad` VALUES ('1110361c-877d-4e0a-9195-b91069e4d260', '普陀山镇', '330903', NULL, '3', '0', '330903106');
INSERT INTO `obj_ad` VALUES ('111314dc-2a04-4ee2-a142-a6d3aee17677', '南雁镇', '330326', NULL, '3', '0', '330326109');
INSERT INTO `obj_ad` VALUES ('11158475-857d-45f6-a192-a90325461e3d', '湖雾镇', '330382', NULL, '3', '0', '330382121');
INSERT INTO `obj_ad` VALUES ('11293675-706c-4608-8cf7-fd2431cd4a87', '磐石镇', '330382', NULL, '3', '0', '330382118');
INSERT INTO `obj_ad` VALUES ('113121ba-a410-453a-931b-88e62d23cbe7', '仙华街道', '330726', NULL, '3', '0', '330726002');
INSERT INTO `obj_ad` VALUES ('11589108-5c98-4b04-95ee-e58c95d99fbd', '平湖市', '3304', NULL, '2', '0', '330482');
INSERT INTO `obj_ad` VALUES ('1167adec-6bdc-4def-93af-5b015dd62f7e', '下渚湖街道', '330521', NULL, '3', '0', '330521004');
INSERT INTO `obj_ad` VALUES ('11afc25c-0da8-4631-ae11-b956f49acbd3', '鉴湖街道', '330602', NULL, '3', '0', '330602011');
INSERT INTO `obj_ad` VALUES ('11bd2b40-40c5-46a4-94a7-6d50df8bcf6d', '越溪乡', '330226', NULL, '3', '0', '330226202');
INSERT INTO `obj_ad` VALUES ('11c784ab-6b7b-44b9-a936-08e3611b4579', '樟台乡', '330328', NULL, '3', '0', '330328200');
INSERT INTO `obj_ad` VALUES ('11cbd974-c776-4819-86e0-369ac367855c', '草塔镇', '330681', NULL, '3', '0', '330681113');
INSERT INTO `obj_ad` VALUES ('11e0f4b7-c300-4d9d-9e6a-2d326130319c', '新城街道', '330411', NULL, '3', '0', '330411002');
INSERT INTO `obj_ad` VALUES ('11f4f9af-c2f8-4daa-87c7-507d4c2454e0', '峃口乡', '330328', NULL, '3', '0', '330328214');
INSERT INTO `obj_ad` VALUES ('11f8d389-3c14-4fa0-90b9-5c95372d41a6', '丽岙街道', '330304', NULL, '3', '0', '330304011');
INSERT INTO `obj_ad` VALUES ('122d9957-d8f1-4b83-ad51-d776d4fa0bbb', '梧田街道', '330304', NULL, '3', '0', '330304002');
INSERT INTO `obj_ad` VALUES ('12334a84-987d-4b6e-ac69-bda73f3a26be', '龙门镇', '330111', NULL, '3', '0', '330111112');
INSERT INTO `obj_ad` VALUES ('12354f53-0d5d-40a7-946e-55c46d6db366', '白鹤街道', '330204', NULL, '3', '0', '330204004');
INSERT INTO `obj_ad` VALUES ('1239d2eb-3634-465a-90be-78f9a9f86dd1', '东港街道', '330803', NULL, '3', '0', '330803221');
INSERT INTO `obj_ad` VALUES ('1244e6d9-dbe1-4fc5-8d6e-c1e0a01902ea', '八都镇', '331181', NULL, '3', '0', '331181100');
INSERT INTO `obj_ad` VALUES ('12a2bc7b-7532-4c7b-94b5-7416f53e676c', '水文局', '33', NULL, '1', '0', '3313');
INSERT INTO `obj_ad` VALUES ('12a33b7a-e978-45c5-9cad-25d2d5dc53b3', '康桥街道', '330105', NULL, '3', '0', '330105010');
INSERT INTO `obj_ad` VALUES ('1313f418-d78d-41d9-bf35-8e48245583f8', '富岙乡', '330328', NULL, '3', '0', '330328210');
INSERT INTO `obj_ad` VALUES ('13158f6f-5443-4ee5-b853-5bd441cf41d3', '长白乡', '330902', NULL, '3', '0', '330902200');
INSERT INTO `obj_ad` VALUES ('131819b8-ff6c-4f02-87ab-ab83ac0bf12a', '金炉乡', '330328', NULL, '3', '0', '330328201');
INSERT INTO `obj_ad` VALUES ('13720252-4162-472e-a5e2-2b41ecf678fd', '左口乡', '330127', NULL, '3', '0', '330127203');
INSERT INTO `obj_ad` VALUES ('13ad4ec1-c51a-466d-8ccd-5cbde327b7d7', '横峰街道', '331081', NULL, '3', '0', '331081005');
INSERT INTO `obj_ad` VALUES ('1408b144-3651-421e-bcbe-c919c8313724', '丁桥镇', '330481', NULL, '3', '0', '330481106');
INSERT INTO `obj_ad` VALUES ('1419950e-a910-4d06-a5e1-100eca8110db', '西旸镇', '330329', NULL, '3', '0', '330329113');
INSERT INTO `obj_ad` VALUES ('14249d4b-91da-4762-8ab2-2a8b18115362', '百江镇', '330122', NULL, '3', '0', '330122112');
INSERT INTO `obj_ad` VALUES ('1451c0eb-3637-433c-aa53-4e3b90877452', '横山镇', '330825', NULL, '3', '0', '330825110');
INSERT INTO `obj_ad` VALUES ('14607c10-325b-41a6-85f0-d31ed68cc1cb', '三门县', '3310', NULL, '2', '0', '331022');
INSERT INTO `obj_ad` VALUES ('1467884a-9c24-4dc1-8eef-f2a117ed3387', '孔浦街道', '330205', NULL, '3', '0', '330205003');
INSERT INTO `obj_ad` VALUES ('147393a4-197a-4edd-8957-95b9584ab5e8', '南浔区', '3305', NULL, '2', '0', '330503');
INSERT INTO `obj_ad` VALUES ('1492afaf-245c-4d4e-8689-c5983dbb5525', '县本级', '330303', NULL, '3', '0', '330303000');
INSERT INTO `obj_ad` VALUES ('14aebc42-5493-459b-8c36-ac6381634e9e', '西岙乡', '330324', NULL, '3', '0', '330324209');
INSERT INTO `obj_ad` VALUES ('14b0ee73-de8c-43d3-88f9-48c96451cb37', '望松街道', '331124', NULL, '3', '0', '331124200');
INSERT INTO `obj_ad` VALUES ('14ffca63-4d50-4df9-a04f-e03a536b7029', '椒江区', '3310', NULL, '2', '0', '331002');
INSERT INTO `obj_ad` VALUES ('1549289d-f54f-4b87-a6a5-33e72d850679', '张村乡', '331126', NULL, '3', '0', '331126204');
INSERT INTO `obj_ad` VALUES ('15670a14-aeb5-4c6e-bd12-75c9f74e5252', '雅溪镇', '331102', NULL, '3', '0', '331102104');
INSERT INTO `obj_ad` VALUES ('1589967B-6BCF-44B4-9A8D-2ED552AA95A5', '小将镇', '330624', NULL, '3', '0', '330624113');
INSERT INTO `obj_ad` VALUES ('15abc8fe-a161-4d7a-92b6-71ab679607c4', '笕桥镇', '330104', NULL, '3', '0', '330104103');
INSERT INTO `obj_ad` VALUES ('15b2c306-7e70-4d8d-8b44-90f3267d2699', '举水乡', '331126', NULL, '3', '0', '331126206');
INSERT INTO `obj_ad` VALUES ('163d2740-9070-48c1-bfbd-5ad92657b8e3', '大同镇', '330182', NULL, '3', '0', '330182112');
INSERT INTO `obj_ad` VALUES ('165bcf9f-6f4d-4367-b531-d7b48f2ce505', '大堰镇', '330213', NULL, '3', '0', '330213107');
INSERT INTO `obj_ad` VALUES ('165d8fc7-e26d-4b1b-919f-350ab4dc14db', '菱湖镇', '330503', NULL, '3', '0', '330503105');
INSERT INTO `obj_ad` VALUES ('167928c0-7b2e-4a1b-a5c7-3521bafc8fe2', '三江街道', '330683', NULL, '3', '0', '330683002');
INSERT INTO `obj_ad` VALUES ('16839821-524f-43e2-8253-49709711b1a6', '萧王庙街道', '330213', NULL, '3', '0', '330213005');
INSERT INTO `obj_ad` VALUES ('16be7af2-8384-4963-bad0-a6579ccb7e46', '北仑区', '3302', NULL, '2', '0', '330206');
INSERT INTO `obj_ad` VALUES ('16fe368c-922d-4e04-a6f0-ee8a293169f4', '星海街道', '330371', NULL, '3', '0', '330371011');
INSERT INTO `obj_ad` VALUES ('1710721e-4351-4b1f-bb8d-b5b666462198', '芳村镇', '330822', NULL, '3', '0', '330822114');
INSERT INTO `obj_ad` VALUES ('1711b441-3a82-4d4a-a5d3-17db985872c3', '店口镇', '330681', NULL, '3', '0', '330681104');
INSERT INTO `obj_ad` VALUES ('172f6fc8-630c-438f-b47a-9306ea51a39b', '高禹镇', '330523', NULL, '3', '0', '330523109');
INSERT INTO `obj_ad` VALUES ('176c2ed1-6457-47b5-9564-1722eca0d30d', '妙高街道', '331123', NULL, '3', '0', '331123001');
INSERT INTO `obj_ad` VALUES ('176f0cef-3aae-47e1-9171-65bc733ca00a', '周巷镇', '330282', NULL, '3', '0', '330282017');
INSERT INTO `obj_ad` VALUES ('178bc18d-139d-408e-ae41-00e904ecbb65', '岩坦镇', '330324', NULL, '3', '0', '330324110');
INSERT INTO `obj_ad` VALUES ('1825bcbc-a62c-4150-87b8-4af837c22de9', '县本级', '331124', NULL, '3', '0', '331124000');
INSERT INTO `obj_ad` VALUES ('182c6e9b-3697-4531-a207-59d8dd4c6c62', '百步镇', '330424', NULL, '3', '0', '330424102');
INSERT INTO `obj_ad` VALUES ('184e0324-bedd-40b5-b9c5-c5ac382e940f', '大岚镇', '330281', NULL, '3', '0', '330281115');
INSERT INTO `obj_ad` VALUES ('18592e48-eb50-4909-9ef9-a3c48cf00670', '云龙镇', '330212', NULL, '3', '0', '330212108');
INSERT INTO `obj_ad` VALUES ('1883fd1f-3348-4e19-b58e-47acc043f076', '梁弄镇', '330281', NULL, '3', '0', '330281114');
INSERT INTO `obj_ad` VALUES ('1884fb52-6845-4d25-88cc-51dce3356ad1', '康山街道', '330502', NULL, '3', '0', '330502007');
INSERT INTO `obj_ad` VALUES ('18a84eb2-3bc6-4c96-be71-2d12d21d2456', '鹤城街道', '331121', NULL, '3', '0', '331121001');
INSERT INTO `obj_ad` VALUES ('190d2430-7da2-4f73-bf5e-a5e717cdd1d4', '蒲州街道', '330303', NULL, '3', '0', '330303002');
INSERT INTO `obj_ad` VALUES ('190d8c9a-2f8e-4c2b-8d67-963ef6ce418c', '船寮镇', '331121', NULL, '3', '0', '331121104');
INSERT INTO `obj_ad` VALUES ('19249314-44f5-4d6a-bd2e-202429b674c5', '受降镇', '330183', NULL, '3', '0', '330183114');
INSERT INTO `obj_ad` VALUES ('1958c98a-5b15-4a55-9c9f-03a69fecf55b', '定塘镇', '330225', NULL, '3', '0', '330225004');
INSERT INTO `obj_ad` VALUES ('1964aef0-8453-4196-b2b1-25cecdce9c60', '虎山街道', '330881', NULL, '3', '0', '330881002');
INSERT INTO `obj_ad` VALUES ('197cc64a-8909-4089-be51-fdfccda7f5e3', '平田乡', '331003', NULL, '3', '0', '331003205');
INSERT INTO `obj_ad` VALUES ('19e114e8-904e-4ddd-b9ac-4d91bf2268b6', '水文局', '3313', NULL, '2', '0', '331301');
INSERT INTO `obj_ad` VALUES ('1a3fb544-9484-44dd-9411-9f2aa9e502c7', '坛石镇', '330881', NULL, '3', '0', '330881105');
INSERT INTO `obj_ad` VALUES ('1aae9863-ea7e-411e-8d92-04d8e97917d8', '枫树岭镇', '330127', NULL, '3', '0', '330127111');
INSERT INTO `obj_ad` VALUES ('1ab85b84-8fd0-40c1-a5e8-f84af8601891', '黄家埠镇', '330281', NULL, '3', '0', '330281101');
INSERT INTO `obj_ad` VALUES ('1ac46957-e8e7-47ab-9b1e-9ac85f5bc7fb', '县本级', '330290', NULL, '3', '0', '330290000');
INSERT INTO `obj_ad` VALUES ('1acf9087-a69d-4ea9-9780-0840c8977cbe', '霞浦街道', '330206', NULL, '3', '0', '330206005');
INSERT INTO `obj_ad` VALUES ('1b122331-526d-46fa-9b5f-ead04ced9427', '西畈乡', '331123', NULL, '3', '0', '331123209');
INSERT INTO `obj_ad` VALUES ('1b7cf3d4-7d58-42a3-8011-9aaa9e15bbbd', '紫港街道', '330822', NULL, '3', '0', '330822002');
INSERT INTO `obj_ad` VALUES ('1b8ee0c8-595e-4d58-9961-db3780c9d56b', '竹里畲族乡', '330329', NULL, '3', '0', '330329204');
INSERT INTO `obj_ad` VALUES ('1b9ff06f-7a99-49e4-b7e1-ca704ca745f0', '石浦镇', '330225', NULL, '3', '0', '330225101');
INSERT INTO `obj_ad` VALUES ('1bb42a10-ad2e-4c6a-a98d-62815f859b86', '竹垟乡', '331181', NULL, '3', '0', '331181209');
INSERT INTO `obj_ad` VALUES ('1bc2bcf0-df7b-46fa-9bb5-4e5a05b1a483', '陶堰街道', '330602', NULL, '3', '0', '330602016');
INSERT INTO `obj_ad` VALUES ('1bfcb9e7-192a-49a3-8c88-55b89ffcd168', '白石街道办事处', '330382', NULL, '3', '0', '330382006');
INSERT INTO `obj_ad` VALUES ('1c03b416-02a4-45be-af5a-2faa866dd771', '龙泉市', '3311', NULL, '2', '0', '331181');
INSERT INTO `obj_ad` VALUES ('1c2df473-e94d-4eca-b019-175490031086', '莘塍镇', '330381', NULL, '3', '0', '330381109');
INSERT INTO `obj_ad` VALUES ('1c3cecd7-aaf0-44d6-a038-f0ae1c85d65c', '县本级', '330782', NULL, '3', '0', '330782000');
INSERT INTO `obj_ad` VALUES ('1c4397e9-2a16-4da4-8664-7fe6b6f92e1a', '大溪边乡', '330824', NULL, '3', '0', '330824218');
INSERT INTO `obj_ad` VALUES ('1c454d20-a59b-489e-9b88-d892cd3ba6c3', '中墩乡', '330327', NULL, '3', '0', '330327214');
INSERT INTO `obj_ad` VALUES ('1c5bb00b-c79a-4a99-9f73-01e30cbf958a', '三江街道', '330324', NULL, '3', '0', '330324006');
INSERT INTO `obj_ad` VALUES ('1c61acfc-e8b9-402d-9fcc-a793f9ff2065', '下寮乡', '330324', NULL, '3', '0', '330324225');
INSERT INTO `obj_ad` VALUES ('1c830671-1273-4479-ae26-776059b44378', '湫山乡', '331024', NULL, '3', '0', '331024202');
INSERT INTO `obj_ad` VALUES ('1c8d600c-6f3e-42ac-ba49-f07734658705', '百丈街道', '330204', NULL, '3', '0', '330204001');
INSERT INTO `obj_ad` VALUES ('1c8eefb4-0745-4c1f-9d69-6cb4f8da3daa', '左溪镇', '331126', NULL, '3', '0', '331126105');
INSERT INTO `obj_ad` VALUES ('1c948d3f-4b88-433b-bd29-c44ff62e7736', '仕阳镇', '330329', NULL, '3', '0', '330329107');
INSERT INTO `obj_ad` VALUES ('1cd5edee-1de8-4b50-b927-c756986687d9', '澥浦镇', '330211', NULL, '3', '0', '330211100');
INSERT INTO `obj_ad` VALUES ('1ce80c76-1aff-4832-ab12-2b05fa54952b', '富春江镇', '330122', NULL, '3', '0', '330122101');
INSERT INTO `obj_ad` VALUES ('1d524ae9-b583-41a3-8482-77b27a3e182d', '临平街道', '330110', NULL, '3', '0', '330110001');
INSERT INTO `obj_ad` VALUES ('1d6edefa-b75d-439f-bad1-093b3088e9d8', '石门镇', '330483', NULL, '3', '0', '330483103');
INSERT INTO `obj_ad` VALUES ('1d8fcdc3-931e-4aa4-a813-2a8fbc17d14c', '鹤溪街道办事处', '331127', NULL, '3', '0', '331127002');
INSERT INTO `obj_ad` VALUES ('1db8ccef-7397-4a6a-989e-73acc0fba87c', '水心街道', '330302', NULL, '3', '0', '330302015');
INSERT INTO `obj_ad` VALUES ('1dbef366-9387-4fea-91bb-7dd0e0b26d87', '板桥畲族乡', '331124', NULL, '3', '0', '331124212');
INSERT INTO `obj_ad` VALUES ('1dc6eeca-a193-4b3e-af20-2d1ea027b316', '杭州湾工业园区', '330682', NULL, '3', '0', '330682203');
INSERT INTO `obj_ad` VALUES ('1ddd692c-5508-445b-8351-a1e03ac17d78', '东坑镇', '331127', NULL, '3', '0', '331127102');
INSERT INTO `obj_ad` VALUES ('1e01f266-e9de-47bb-9ebd-1889e834df94', '湖南镇', '330803', NULL, '3', '0', '330803113');
INSERT INTO `obj_ad` VALUES ('1e12aacb-ee47-43bc-9a30-5893dcb54d8c', '霓屿街道', '330305', NULL, '3', '0', '330305005');
INSERT INTO `obj_ad` VALUES ('1e1e88ac-bd24-4e0e-beb1-a315b45bbfe1', '集仕港镇', '330212', NULL, '3', '0', '330212115');
INSERT INTO `obj_ad` VALUES ('1e45b739-f88d-4e65-a3f5-ac17f829994b', '瞻岐镇', '330212', NULL, '3', '0', '330212100');
INSERT INTO `obj_ad` VALUES ('1edf9606-a30f-455d-9dd2-81726ae798b3', '福溪街道', '331023', NULL, '3', '0', '331023003');
INSERT INTO `obj_ad` VALUES ('1ef465f9-1b33-42c9-833c-5d7f6039af34', '裘村镇', '330213', NULL, '3', '0', '330213106');
INSERT INTO `obj_ad` VALUES ('1ef50c67-ddcd-4c8c-be60-07a9e65411ad', '天成乡', '330382', NULL, '3', '0', '330382208');
INSERT INTO `obj_ad` VALUES ('1f02be77-f7ae-498b-8b97-523abf1023a0', '航头镇', '330182', NULL, '3', '0', '330182110');
INSERT INTO `obj_ad` VALUES ('1f0a2b95-36c9-4b1f-ad87-02d31f3cefc9', '黄源乡', '331125', NULL, '3', '0', '331125207');
INSERT INTO `obj_ad` VALUES ('1f376587-26f5-478a-8fc3-f19d35aa6949', '大洋镇', '331122', NULL, '3', '0', '331122105');
INSERT INTO `obj_ad` VALUES ('1f3e6b28-ca90-496f-b927-2a6a11566a3a', '月湖街道', '330203', NULL, '3', '0', '330203004');
INSERT INTO `obj_ad` VALUES ('1f6339c9-d10d-4680-ac62-15492d3ac02e', '奉化区', '3302', NULL, '2', '0', '330213');
INSERT INTO `obj_ad` VALUES ('1f6e816a-85ba-4d3b-bd3e-1335d78dc479', '蕺山街道', '330602', NULL, '3', '0', '330602003');
INSERT INTO `obj_ad` VALUES ('1f7927cd-7a38-45bd-9e7c-5305e2aa2b83', '跃龙街道', '330226', NULL, '3', '0', '330226001');
INSERT INTO `obj_ad` VALUES ('1f853665-5ac9-4d53-a8ec-a93801f0303c', '孝源街道', '330523', NULL, '3', '0', '330523004');
INSERT INTO `obj_ad` VALUES ('1fc32ed9-01c9-4b83-a9f9-351559a5e9c9', '巨屿镇', '330328', NULL, '3', '0', '330328106');
INSERT INTO `obj_ad` VALUES ('1fd76eaf-8d82-4625-a771-f1b91277f1f0', '头陀镇', '331003', NULL, '3', '0', '331003103');
INSERT INTO `obj_ad` VALUES ('1fd8611c-e00b-4e96-abf7-40a1b1a1d8d4', '常绿镇', '330111', NULL, '3', '0', '330111109');
INSERT INTO `obj_ad` VALUES ('1ff2c994-370a-4f85-ab0f-4f0525725b6b', '县本级', '330726', NULL, '3', '0', '330726000');
INSERT INTO `obj_ad` VALUES ('1ffd1d15-6e90-4049-a2c1-d9cdf00a5221', '天河街道', '330371', NULL, '3', '0', '330371009');
INSERT INTO `obj_ad` VALUES ('201b2830-a36c-4fcb-953a-cdc934be67b7', '村头镇', '330824', NULL, '3', '0', '330824113');
INSERT INTO `obj_ad` VALUES ('20577d0c-44b6-4b30-9768-672294b37796', '舞阳街道', '330521', NULL, '3', '0', '330521106');
INSERT INTO `obj_ad` VALUES ('20AC3352-7520-434A-83B9-A5BC86745CCD', '谷来镇', '330683', NULL, '3', '0', '330683112');
INSERT INTO `obj_ad` VALUES ('20e13dd6-13ec-4839-936e-fabcc826d500', '浬浦镇', '330681', NULL, '3', '0', '330681122');
INSERT INTO `obj_ad` VALUES ('21270f43-6221-4dd7-9a06-dd4a665cc9bc', '煤山镇', '330522', NULL, '3', '0', '330522112');
INSERT INTO `obj_ad` VALUES ('214ee227-9086-42e9-beba-c95d376ca829', '合村乡', '330122', NULL, '3', '0', '330122210');
INSERT INTO `obj_ad` VALUES ('216f3df5-4490-4112-b1e9-9ec82ce1360e', '泗洲头镇', '330225', NULL, '3', '0', '330225014');
INSERT INTO `obj_ad` VALUES ('2181d7aa-0e63-48ec-9cc9-30cfef3d7982', '大溪镇', '331081', NULL, '3', '0', '331081101');
INSERT INTO `obj_ad` VALUES ('2188cad7-2986-4d5c-a9aa-e0e5ba09fd08', '柳城畲族镇', '330723', NULL, '3', '0', '330723100');
INSERT INTO `obj_ad` VALUES ('218e79ef-c33e-4ad1-9410-a13d20f1b98f', '浒山街道', '330282', NULL, '3', '0', '330282008');
INSERT INTO `obj_ad` VALUES ('219883fa-1a40-42ca-ae34-490c34a0b8e2', '桃渚镇', '331082', NULL, '3', '0', '331082114');
INSERT INTO `obj_ad` VALUES ('219992c1-1be3-4983-be19-412cba231b55', '浙东局', '33', NULL, '1', '0', '3314');
INSERT INTO `obj_ad` VALUES ('21a70a06-b1f0-443d-b029-46eb1c214f4e', '西塘镇', '330421', NULL, '3', '0', '330421103');
INSERT INTO `obj_ad` VALUES ('21cff2c1-e43b-400c-990a-b5a2e0b0b100', '安昌街道', '330603', NULL, '3', '0', '330603007');
INSERT INTO `obj_ad` VALUES ('2213f3ea-1696-4d5f-8997-6ce0f5ad2e4b', '嘉北街道', '330411', NULL, '3', '0', '330411003');
INSERT INTO `obj_ad` VALUES ('2276a26d-31db-424d-ba3b-5283b0533e11', '牟山镇', '330281', NULL, '3', '0', '330281016');
INSERT INTO `obj_ad` VALUES ('22867f9b-741d-4cbe-85d5-9adab204e1f5', '新安镇', '330521', NULL, '3', '0', '330521114');
INSERT INTO `obj_ad` VALUES ('22a3bc60-c676-42b7-8482-b798ea5a3f1a', '瓯南街道', '331121', NULL, '3', '0', '331121002');
INSERT INTO `obj_ad` VALUES ('22f5f45f-f94b-43a4-85ed-38eaaabfcb91', '潘桥街道', '330304', NULL, '3', '0', '330304010');
INSERT INTO `obj_ad` VALUES ('23309744-5553-4cc1-9eb8-b84cd3308544', '贤庠镇', '330225', NULL, '3', '0', '330225104');
INSERT INTO `obj_ad` VALUES ('234cf701-7618-48c3-b579-608d72356494', '新桥镇', '330225', NULL, '3', '0', '330225019');
INSERT INTO `obj_ad` VALUES ('237003dd-dd66-4f13-ac22-2abbd7710f53', '杨汛桥街道', '330603', NULL, '3', '0', '330603011');
INSERT INTO `obj_ad` VALUES ('239bd5ef-1535-442b-8e14-76916040981a', '濮院镇', '330483', NULL, '3', '0', '330483101');
INSERT INTO `obj_ad` VALUES ('23bee294-c0c3-4e7a-8ce3-77c84fdab256', '灵隐街道', '330106', NULL, '3', '0', '330106012');
INSERT INTO `obj_ad` VALUES ('23c17a98-5f4c-48ae-be95-f75734fff318', '大榭街道', '330206', NULL, '3', '0', '330206001');
INSERT INTO `obj_ad` VALUES ('23f4dcca-68f6-4749-bc14-715187a7cc37', '柏社乡', '330781', NULL, '3', '0', '330781209');
INSERT INTO `obj_ad` VALUES ('240693c4-2f7c-4437-9c27-6bab6c9b0b93', '隆宫乡', '331126', NULL, '3', '0', '331126205');
INSERT INTO `obj_ad` VALUES ('2419e3fd-9bdb-46fb-b480-c72de9eb3f1f', '余杭区', '3301', NULL, '2', '0', '330110');
INSERT INTO `obj_ad` VALUES ('241ede0f-0452-4efe-95f6-cdaf9a1da3e8', '马鞍街道', '330603', NULL, '3', '0', '330603010');
INSERT INTO `obj_ad` VALUES ('2454aa2c-5283-49ad-a0d1-f45b080cb7bc', '新湾街道', '330109', NULL, '3', '0', '330109009');
INSERT INTO `obj_ad` VALUES ('245793e8-d523-49da-ad26-ec936c2c9a03', '县本级', '330122', NULL, '3', '0', '330122000');
INSERT INTO `obj_ad` VALUES ('24801a00-7593-4996-9681-7e9469657641', '龙西乡', '330382', NULL, '3', '0', '330382211');
INSERT INTO `obj_ad` VALUES ('24a51736-2431-43d7-8da4-6fd6972b20aa', '闲林镇', '330110', NULL, '3', '0', '330110106');
INSERT INTO `obj_ad` VALUES ('24b5f22d-6e0f-4c02-b71f-7287500c5e68', '东洲街道', '330111', NULL, '3', '0', '330111005');
INSERT INTO `obj_ad` VALUES ('24e8f5f5-14a3-4e37-b75b-4f35408374e6', '胡陈乡', '330226', NULL, '3', '0', '330226200');
INSERT INTO `obj_ad` VALUES ('24ef9aea-22e6-4c33-b5b2-553f29be647b', '盘峰乡', '330727', NULL, '3', '0', '330727206');
INSERT INTO `obj_ad` VALUES ('2509044e-104c-42bd-b871-8a33deb2b85b', '大岙乡', '330324', NULL, '3', '0', '330324206');
INSERT INTO `obj_ad` VALUES ('253ea72b-6bca-4bbb-b270-27703361e99a', '北界镇', '331123', NULL, '3', '0', '331123103');
INSERT INTO `obj_ad` VALUES ('254fdc20-1789-4204-b796-39aa29a79a34', '詹家镇', '330825', NULL, '3', '0', '330825106');
INSERT INTO `obj_ad` VALUES ('25bd0f6c-17bf-4652-a5c7-0f0e20bac917', '谷来镇', '330683', NULL, '3', '0', '330683106');
INSERT INTO `obj_ad` VALUES ('262e5f02-e474-44c2-8a3c-bbb7831aae81', '南滨街道', '330381', NULL, '3', '0', '330381011');
INSERT INTO `obj_ad` VALUES ('262f7d8d-cd2a-4530-b60d-0bcdae123fd9', '前仓镇', '330784', NULL, '3', '0', '330784106');
INSERT INTO `obj_ad` VALUES ('266f9fab-b8de-4965-b31b-b06cc14c57b6', '腾垟乡', '330327', NULL, '3', '0', '330327211');
INSERT INTO `obj_ad` VALUES ('2673ea01-be94-48e1-bfe2-e21f332ac89d', '江干区', '3301', NULL, '2', '0', '330104');
INSERT INTO `obj_ad` VALUES ('269b2f6b-d331-459f-a013-034b6de74143', '天水街道', '330103', NULL, '3', '0', '330103003');
INSERT INTO `obj_ad` VALUES ('269e1146-c452-411f-8d0d-4e3af75372d5', '尖山新区', '330481', NULL, '3', '0', '330481400');
INSERT INTO `obj_ad` VALUES ('26f8505f-18f1-4e30-b346-c15051b1cbfd', '崇头镇', '331125', NULL, '3', '0', '331125105');
INSERT INTO `obj_ad` VALUES ('272be872-6969-407f-97f5-eb36394cbe19', '三合镇', '331023', NULL, '3', '0', '331023107');
INSERT INTO `obj_ad` VALUES ('2739ff24-266e-4836-befa-a63a270de96c', '大战乡', '331024', NULL, '3', '0', '331024209');
INSERT INTO `obj_ad` VALUES ('2742b8dd-4f7b-4dfb-9768-e1939e7dd7ae', '二界岭乡', '330522', NULL, '3', '0', '330522201');
INSERT INTO `obj_ad` VALUES ('276436a1-41ee-4377-994f-613f3829b6c3', '德清县', '3305', NULL, '2', '0', '330521');
INSERT INTO `obj_ad` VALUES ('278015e8-dda6-4b2f-bf3a-74c61bdac8a6', '金川街道', '330822', NULL, '3', '0', '330822003');
INSERT INTO `obj_ad` VALUES ('27908d58-a52c-46fb-b930-31daa544f725', '梅城镇', '330182', NULL, '3', '0', '330182104');
INSERT INTO `obj_ad` VALUES ('27DAE553-16C2-4CBF-9A0F-133E8CBCF1F7', '金庭镇', '330683', NULL, '3', '0', '330683113');
INSERT INTO `obj_ad` VALUES ('27fd65dd-3087-47c6-b4b9-51db7e48dcde', '杨林镇', '330824', NULL, '3', '0', '330824107');
INSERT INTO `obj_ad` VALUES ('280869d1-bc13-4ac1-a0d3-bbab584d508f', '王家井镇', '330681', NULL, '3', '0', '330681114');
INSERT INTO `obj_ad` VALUES ('281fe784-787f-4933-ba6a-91282944788c', '胥口镇', '330183', NULL, '3', '0', '330183116');
INSERT INTO `obj_ad` VALUES ('28589ba3-f05e-4c7e-8450-bb42f21fcb31', '县本级', '331004', NULL, '3', '0', '331004000');
INSERT INTO `obj_ad` VALUES ('286c0db4-caca-463a-94bc-d06966060627', '乐成街道办事处', '330382', NULL, '3', '0', '330382002');
INSERT INTO `obj_ad` VALUES ('2882b981-75eb-49ec-9dfb-e3b800119c36', '凤凰街道', '330502', NULL, '3', '0', '330502006');
INSERT INTO `obj_ad` VALUES ('28a532d0-17c0-4abc-b463-b75c94b87640', '蚂蚁岛乡', '330903', NULL, '3', '0', '330903200');
INSERT INTO `obj_ad` VALUES ('28c52322-da36-43db-9ebb-35dc941cf4bf', '青溪新城管委会', '330127', NULL, '3', '0', '330127217');
INSERT INTO `obj_ad` VALUES ('28ff3dfe-eb67-4b5f-9620-bd9bd05a189e', '桥头胡街道', '330226', NULL, '3', '0', '330226004');
INSERT INTO `obj_ad` VALUES ('292f5b8d-316a-4c70-9630-0d046a3e904c', '西周镇', '330225', NULL, '3', '0', '330225016');
INSERT INTO `obj_ad` VALUES ('293dd738-c5cf-4216-a001-28d0aab510cd', '东源镇', '331121', NULL, '3', '0', '331121102');
INSERT INTO `obj_ad` VALUES ('29475a80-5083-4826-a16a-0a5f58a0aacc', '巧英乡', '330624', NULL, '3', '0', '330624206');
INSERT INTO `obj_ad` VALUES ('294d06e0-a8ed-4413-b4e4-71e90d68c252', '湖墅街道', '330105', NULL, '3', '0', '330105002');
INSERT INTO `obj_ad` VALUES ('295634a9-3af0-48d4-acc4-b6064b0cc741', '三都乡', '331124', NULL, '3', '0', '331124203');
INSERT INTO `obj_ad` VALUES ('29585111-c6ac-4351-8f9a-0c492fc98a8a', '萧王庙街道', '330283', NULL, '3', '0', '330283011');
INSERT INTO `obj_ad` VALUES ('299a936a-44a7-408f-9eeb-74b55ed57f5d', '长安镇', '330481', NULL, '3', '0', '330481103');
INSERT INTO `obj_ad` VALUES ('29ab18cf-f728-46be-a30f-f49681e2e6ba', '公阳乡', '330328', NULL, '3', '0', '330328228');
INSERT INTO `obj_ad` VALUES ('2a18ecc4-ad83-4e8a-b903-59bfdedd7532', '秀洲区', '3304', NULL, '2', '0', '330411');
INSERT INTO `obj_ad` VALUES ('2a1dd9a5-ac6c-4a28-96ca-0dab82c22511', '瓶窑镇', '330110', NULL, '3', '0', '330110110');
INSERT INTO `obj_ad` VALUES ('2a6b2fc1-ef1e-4a40-ba40-8d38bc308634', '干窑镇', '330421', NULL, '3', '0', '330421105');
INSERT INTO `obj_ad` VALUES ('2a6f9cab-22f4-4f50-853d-3ed1b432d661', '举村乡', '330803', NULL, '3', '0', '330803213');
INSERT INTO `obj_ad` VALUES ('2a728fe6-47e7-434d-ac42-b374790a97f5', '戴村镇', '330109', NULL, '3', '0', '330109102');
INSERT INTO `obj_ad` VALUES ('2a8885e0-f4e5-4c27-9c0a-a5e1fa492afa', '新兴镇', '331124', NULL, '3', '0', '331124105');
INSERT INTO `obj_ad` VALUES ('2a962382-8ea1-456b-a2f4-e8dd33b08a06', '三七市镇', '330281', NULL, '3', '0', '330281110');
INSERT INTO `obj_ad` VALUES ('2a96a4dc-53e3-4979-bc86-310ec21a808c', '白石镇', '330382', NULL, '3', '0', '330382113');
INSERT INTO `obj_ad` VALUES ('2a9ae3e9-bfba-4cad-8a49-f52dc9c0fa89', '县本级', '330103', NULL, '3', '0', '330103000');
INSERT INTO `obj_ad` VALUES ('2ab7cbb2-e080-42d1-b97a-7b6ee3bbfaba', '行政区域4', '330702', NULL, '3', '0', '330702210');
INSERT INTO `obj_ad` VALUES ('2ad3351c-2fd4-4e8b-9660-6e019d93937f', '县本级', '331122', NULL, '3', '0', '331122000');
INSERT INTO `obj_ad` VALUES ('2b146e4f-8827-40d7-b4de-d4b546c6b10d', '梅渚镇', '330624', NULL, '3', '0', '330624102');
INSERT INTO `obj_ad` VALUES ('2b199019-08ec-4254-ad10-3365f7a796aa', '浮石街道', '330803', NULL, '3', '0', '330803002');
INSERT INTO `obj_ad` VALUES ('2b4237a0-57fe-4a59-8df3-ff5a3c4917a5', '开发区', '3307', NULL, '2', '0', '330704');
INSERT INTO `obj_ad` VALUES ('2b4b70a2-a401-4ae2-ad6b-08e64e80da3e', '党湾镇', '330109', NULL, '3', '0', '330109120');
INSERT INTO `obj_ad` VALUES ('2b642bae-2308-488d-95f4-4dbbd5025456', '陆埠水库', '330281', NULL, '3', '0', '330281302');
INSERT INTO `obj_ad` VALUES ('2b772673-4fa7-42d1-b346-169a9fe5655e', '屏门乡', '330127', NULL, '3', '0', '330127205');
INSERT INTO `obj_ad` VALUES ('2baedf23-28e2-4f97-8a7c-3ab93c5fea70', '南湖区', '3304', NULL, '2', '0', '330402');
INSERT INTO `obj_ad` VALUES ('2bc025d3-8ed4-4b97-985e-2e5c7c774b09', '东陈乡', '330225', NULL, '3', '0', '330225005');
INSERT INTO `obj_ad` VALUES ('2BC358A0-4319-4ABA-BF38-A2033172824C', '石璜镇', '330683', NULL, '3', '0', '330683111');
INSERT INTO `obj_ad` VALUES ('2bcec9bf-0e97-4a10-8c07-abc700738ff9', '金村乡', '330824', NULL, '3', '0', '330824219');
INSERT INTO `obj_ad` VALUES ('2be5999e-1bb3-48d4-9322-495f8cd10bd1', '昌国街道', '330902', NULL, '3', '0', '330902002');
INSERT INTO `obj_ad` VALUES ('2c20f4e3-8e62-4106-8611-d83f00eef968', '黄避岙乡', '330225', NULL, '3', '0', '330225202');
INSERT INTO `obj_ad` VALUES ('2c2bbe2f-8b1c-4890-acbd-40fccc4c9f20', '云和县', '3311', NULL, '2', '0', '331125');
INSERT INTO `obj_ad` VALUES ('2c487332-8ba4-4dce-9704-43f443549e86', '丁兰街道', '330104', NULL, '3', '0', '330104013');
INSERT INTO `obj_ad` VALUES ('2c734666-aea0-41cd-9e4e-f23beb0dfba7', '新浦镇', '330282', NULL, '3', '0', '330282015');
INSERT INTO `obj_ad` VALUES ('2c888dc4-21a5-490e-9392-f9ea05d4e8f8', '李家镇', '330182', NULL, '3', '0', '330182113');
INSERT INTO `obj_ad` VALUES ('2c8a69ee-74b4-47c4-8b4c-eda14157e4ae', '春江街道', '330111', NULL, '3', '0', '330111002');
INSERT INTO `obj_ad` VALUES ('2ca56c79-df24-45e4-8df0-a67d7749282f', '横店镇', '330783', NULL, '3', '0', '330783123');
INSERT INTO `obj_ad` VALUES ('2cac1ada-0d98-4e98-98d0-aa3d75887f8c', '黄坛镇', '330226', NULL, '3', '0', '330226006');
INSERT INTO `obj_ad` VALUES ('2cc560a2-442a-4f12-8be1-269eaa1474a5', '临山镇', '330281', NULL, '3', '0', '330281100');
INSERT INTO `obj_ad` VALUES ('2ccecf32-04d9-46c9-adde-fce68b3cee22', '东瓯街道', '330324', NULL, '3', '0', '330324005');
INSERT INTO `obj_ad` VALUES ('2cd7196c-32a3-4db8-a3d7-7be76facd7b0', '剡湖街道', '330683', NULL, '3', '0', '330683001');
INSERT INTO `obj_ad` VALUES ('2d15fb85-aa5e-44fc-bdef-5bd025c22b33', '永安乡', '330381', NULL, '3', '0', '330381207');
INSERT INTO `obj_ad` VALUES ('2d2c1441-29b6-4e2e-af90-491d2eb3b83e', '雷甸镇', '330521', NULL, '3', '0', '330521110');
INSERT INTO `obj_ad` VALUES ('2d69203b-b89b-4a60-a14f-ed1b9b9cc32b', '县本级', '330421', NULL, '3', '0', '330421000');
INSERT INTO `obj_ad` VALUES ('2d810e2a-985d-485b-9bae-4c69b1a86383', '陆埠镇', '330281', NULL, '3', '0', '330281013');
INSERT INTO `obj_ad` VALUES ('2d865c37-607d-4935-a6f7-7f24e4d29f95', '毛垟乡', '331127', NULL, '3', '0', '331127215');
INSERT INTO `obj_ad` VALUES ('2d9f9ce7-0ac8-45ac-9e58-407edaa51181', '仰义乡', '330302', NULL, '3', '0', '330302203');
INSERT INTO `obj_ad` VALUES ('2e297e24-0b69-4308-98b3-a9698177cf7c', '金竹镇', '331123', NULL, '3', '0', '331123104');
INSERT INTO `obj_ad` VALUES ('2e37a05b-beef-4949-80a6-305115711993', '解放街道', '330902', NULL, '3', '0', '330902001');
INSERT INTO `obj_ad` VALUES ('2e94975d-03cc-4577-b4d7-088bc4b09d0c', '爵溪街道', '330225', NULL, '3', '0', '330225003');
INSERT INTO `obj_ad` VALUES ('2e997f59-0c64-48f6-9565-777b56504f77', '康山街道', '330524', NULL, '3', '0', '330524007');
INSERT INTO `obj_ad` VALUES ('2ea6d672-94e5-4c3d-aed2-f6b35daabfdb', '西湾乡', '330326', NULL, '3', '0', '330326202');
INSERT INTO `obj_ad` VALUES ('2ebb53d8-da91-4758-8765-a873add661ee', '官路镇', '331024', NULL, '3', '0', '331024105');
INSERT INTO `obj_ad` VALUES ('2f1a35fe-c182-41e8-b38e-0d3d9a274f9c', '东栅街道', '330402', NULL, '3', '0', '330402013');
INSERT INTO `obj_ad` VALUES ('2f1e51a9-20ed-486b-87d7-45642ff52da5', '青石镇', '330822', NULL, '3', '0', '330822109');
INSERT INTO `obj_ad` VALUES ('2f1eded8-30e9-4457-8d59-aed45f684b80', '开发区', '330726', NULL, '3', '0', '330726205');
INSERT INTO `obj_ad` VALUES ('2f82e22b-5cd1-4874-9a0a-96146a9f2d72', '怀溪乡', '330326', NULL, '3', '0', '330326213');
INSERT INTO `obj_ad` VALUES ('2f986a9a-b439-497f-855a-95f355afb4b9', '丈亭镇', '330281', NULL, '3', '0', '330281109');
INSERT INTO `obj_ad` VALUES ('2fb8ab88-a0c6-48a3-9be5-6c1784043281', '乌牛镇', '330324', NULL, '3', '0', '330324103');
INSERT INTO `obj_ad` VALUES ('300301c6-bb2a-4e81-bceb-bf448e096395', '庄市街道', '330211', NULL, '3', '0', '330211007');
INSERT INTO `obj_ad` VALUES ('30069f90-16d9-455e-977b-b54a0ff9c5df', '湖塘街道', '330603', NULL, '3', '0', '330603004');
INSERT INTO `obj_ad` VALUES ('30273bb8-d547-45c1-bc66-8b76f294d2db', '海洋产业集聚区管理委员会', '3309', NULL, '2', '0', '330924');
INSERT INTO `obj_ad` VALUES ('305baac7-8f93-4fa1-90c3-41407f1a2a4e', '双林镇', '330503', NULL, '3', '0', '330503101');
INSERT INTO `obj_ad` VALUES ('30650433-e0dc-4c16-896d-3b069dd939c6', '雉城街道', '330522', NULL, '3', '0', '330522100');
INSERT INTO `obj_ad` VALUES ('3091afbb-d2f9-49ca-bc4e-92ad7196c830', '四季青街道', '330104', NULL, '3', '0', '330104008');
INSERT INTO `obj_ad` VALUES ('309409d9-0d1b-4632-a05f-d37711b1e7ff', '姜家山乡', '330802', NULL, '3', '0', '330802213');
INSERT INTO `obj_ad` VALUES ('30af22d7-d5e6-48fd-a16e-76af7617c87a', '新浦镇', '330282', NULL, '3', '0', '330282112');
INSERT INTO `obj_ad` VALUES ('30b0a4c6-0bf9-4de0-933f-cc156a4d7669', '大田街道', '331082', NULL, '3', '0', '331082004');
INSERT INTO `obj_ad` VALUES ('30e039dc-7604-46da-80a1-1143f346f357', '浮云街道', '331125', NULL, '3', '0', '331125001');
INSERT INTO `obj_ad` VALUES ('310dc827-07d8-4204-8888-70abea9cd6f2', '县本级', '331021', NULL, '3', '0', '331021000');
INSERT INTO `obj_ad` VALUES ('310e99af-b769-49d7-b261-0ccab99d6c17', '长丰开发建设指挥部', '330212', NULL, '3', '0', '330212003');
INSERT INTO `obj_ad` VALUES ('3129aab5-c270-42c5-904c-2684ca5e35e6', '桐君街道', '330122', NULL, '3', '0', '330122003');
INSERT INTO `obj_ad` VALUES ('3139224e-a68e-46e5-bce5-032011e5d36f', '东洲街道', '330183', NULL, '3', '0', '330183005');
INSERT INTO `obj_ad` VALUES ('31510deb-79cd-408d-a917-474bba441411', '小将镇', '330624', NULL, '3', '0', '330624107');
INSERT INTO `obj_ad` VALUES ('316c10e8-2512-4b74-96c9-3db9a3c37e47', '龙泉街道', '330502', NULL, '3', '0', '330502005');
INSERT INTO `obj_ad` VALUES ('316de931-175a-4288-a8cd-4e371947845f', '楚门镇', '331083', NULL, '3', '0', '331083102');
INSERT INTO `obj_ad` VALUES ('31b54bdd-5891-48a7-8e34-2c59d2c05841', '新城管委会', '3309', NULL, '2', '0', '330923');
INSERT INTO `obj_ad` VALUES ('31c1b6b6-f7b3-43e2-9149-c8857096013a', '富山乡', '331003', NULL, '3', '0', '331003202');
INSERT INTO `obj_ad` VALUES ('31cba068-94c2-4628-bda9-9420fa05d14b', '查田镇', '331181', NULL, '3', '0', '331181103');
INSERT INTO `obj_ad` VALUES ('320f9eba-b3fb-4cd1-9169-c4ea429df1ad', '义蓬街道', '330193', NULL, '3', '0', '330193007');
INSERT INTO `obj_ad` VALUES ('32120187-4223-4ef4-afbe-e60132eb4563', '斗门街道', '330602', NULL, '3', '0', '330602012');
INSERT INTO `obj_ad` VALUES ('322e0e78-2eea-4b73-9a6d-d33e4bf12b05', '南明山街道办事处', '331102', NULL, '3', '0', '331102008');
INSERT INTO `obj_ad` VALUES ('322f6489-f17e-4042-9d80-fd079cba3f68', '南湖街道', '330402', NULL, '3', '0', '330402010');
INSERT INTO `obj_ad` VALUES ('32356a88-fbe8-4797-b6ba-06f3aca30427', '应村乡', '331123', NULL, '3', '0', '331123202');
INSERT INTO `obj_ad` VALUES ('324473c3-87a8-4a03-b142-17fb4231c1b7', '仙岩镇', '330683', NULL, '3', '0', '330683107');
INSERT INTO `obj_ad` VALUES ('324acd90-1e97-44eb-9abe-fc73a38c6221', '庙下乡', '330825', NULL, '3', '0', '330825203');
INSERT INTO `obj_ad` VALUES ('32508208-ae14-493a-8c54-875d2c7e2840', '龙湖镇', '330381', NULL, '3', '0', '330381123');
INSERT INTO `obj_ad` VALUES ('325e17a6-af35-42c1-9a49-8edde9bac501', '炎亭镇', '330327', NULL, '3', '0', '330327123');
INSERT INTO `obj_ad` VALUES ('325e316e-2c36-44ed-881e-626a3bdd1e8b', '白岘乡', '330522', NULL, '3', '0', '330522204');
INSERT INTO `obj_ad` VALUES ('32728d10-f864-42fa-9151-04c6130bd5d4', '章村镇', '330523', NULL, '3', '0', '330523107');
INSERT INTO `obj_ad` VALUES ('32e42253-9f26-469a-a8ce-4b022b9d72a9', '蒲岐镇', '330382', NULL, '3', '0', '330382124');
INSERT INTO `obj_ad` VALUES ('32ea6b01-e45d-46b5-b361-b957f29e3a92', '冷水镇', '330727', NULL, '3', '0', '330727108');
INSERT INTO `obj_ad` VALUES ('32ed0fd9-0d99-400d-90bd-d18796df411c', '水头镇', '330326', NULL, '3', '0', '330326102');
INSERT INTO `obj_ad` VALUES ('3319268a-85b3-46eb-9656-24c1c5285fa3', '西城街道', '331003', NULL, '3', '0', '331003003');
INSERT INTO `obj_ad` VALUES ('3321ff9a-c862-442f-9f0f-c4a238cde181', '笕桥街道', '330104', NULL, '3', '0', '330104012');
INSERT INTO `obj_ad` VALUES ('336ebd97-9fa5-4ca5-9396-f2f4a1dc5358', '始丰街道', '331023', NULL, '3', '0', '331023002');
INSERT INTO `obj_ad` VALUES ('33b6c098-cad8-4668-8f29-fefc7321642f', '富岭街道办事处', '331102', NULL, '3', '0', '331102006');
INSERT INTO `obj_ad` VALUES ('33c75125-11ba-47e3-8591-db625a5c05c8', '西门街道', '330203', NULL, '3', '0', '330203003');
INSERT INTO `obj_ad` VALUES ('33da48b7-1180-49b6-9c43-9dd72b39d4e2', '翁垟街道办事处', '330382', NULL, '3', '0', '330382005');
INSERT INTO `obj_ad` VALUES ('33f45003-d53c-4c6c-be48-7d2f12029ddc', '独山港镇', '330482', NULL, '3', '0', '330482108');
INSERT INTO `obj_ad` VALUES ('3418985e-684a-4486-9e8a-5d6098e92d7c', '尖山镇', '330727', NULL, '3', '0', '330727102');
INSERT INTO `obj_ad` VALUES ('34287d8b-25b6-4491-befa-1030a64c9520', '宁绍管理处', '3312', NULL, '2', '0', '331203');
INSERT INTO `obj_ad` VALUES ('345272df-578f-4f70-84db-1e83fcdca44c', '永中街道', '330303', NULL, '3', '0', '330303001');
INSERT INTO `obj_ad` VALUES ('346903db-48f7-4027-a966-2f3d9ab97ae2', '新碧街道办事处', '331122', NULL, '3', '0', '331122002');
INSERT INTO `obj_ad` VALUES ('34706db9-8a44-40f2-bc6e-3e5e6ec75ff4', '岭底乡', '330382', NULL, '3', '0', '330382212');
INSERT INTO `obj_ad` VALUES ('34ccf4fb-886f-4be1-9224-2c1e53c11ebe', '廿里镇', '330803', NULL, '3', '0', '330803112');
INSERT INTO `obj_ad` VALUES ('34e3c1be-d1c1-4856-ba4f-7a57107e1af0', '长虹乡', '330824', NULL, '3', '0', '330824205');
INSERT INTO `obj_ad` VALUES ('34e86e50-8a15-41d6-86a1-23a3f9b4a6e2', '妙西镇', '330502', NULL, '3', '0', '330502102');
INSERT INTO `obj_ad` VALUES ('34f0a7c5-b403-4620-b617-2f63aeaed3c5', '县本级', '330322', NULL, '3', '0', '330322000');
INSERT INTO `obj_ad` VALUES ('352eab2f-fb6d-49d7-89f5-93f7e3730961', '富文乡', '330127', NULL, '3', '0', '330127202');
INSERT INTO `obj_ad` VALUES ('3561aacc-0321-4a4f-9c63-d8488036da31', '余杭镇', '330110', NULL, '3', '0', '330110108');
INSERT INTO `obj_ad` VALUES ('35744948-7b71-4de0-8f61-5216851a42ad', '银湖街道', '330183', NULL, '3', '0', '330183113');
INSERT INTO `obj_ad` VALUES ('35949766-5bcf-451a-8e28-580e6e11ebb1', '后宅街道', '330782', NULL, '3', '0', '330782005');
INSERT INTO `obj_ad` VALUES ('35a3cc86-ab7b-48c0-bb24-b375971b7061', '高楼乡', '330381', NULL, '3', '0', '330381214');
INSERT INTO `obj_ad` VALUES ('35ac4dd3-ca3f-4001-b5c3-3c3edbe6edd6', '上张乡', '331024', NULL, '3', '0', '331024205');
INSERT INTO `obj_ad` VALUES ('35ae40a1-7714-429f-baf4-2cd5ef8b5826', '华舍街道', '330603', NULL, '3', '0', '330603003');
INSERT INTO `obj_ad` VALUES ('35bfcacd-f7b5-4d93-8462-e4e703316e24', '桥头镇', '330324', NULL, '3', '0', '330324102');
INSERT INTO `obj_ad` VALUES ('35ccf51b-8db9-42dc-9ca7-9a7faf13335c', '南郊街道', '330302', NULL, '3', '0', '330302031');
INSERT INTO `obj_ad` VALUES ('36537978-9803-43db-8cb1-3cd0429a1f4e', '前吴乡', '330726', NULL, '3', '0', '330726202');
INSERT INTO `obj_ad` VALUES ('3675afbf-2c16-429a-9048-f277ed15018e', '小港街道', '330206', NULL, '3', '0', '330206003');
INSERT INTO `obj_ad` VALUES ('36885fe3-a971-47c3-b811-c84a253d29a3', '金星乡', '330328', NULL, '3', '0', '330328223');
INSERT INTO `obj_ad` VALUES ('36b5aeed-cdcb-4b5d-9e91-0e37747f2ed5', '场口镇', '330111', NULL, '3', '0', '330111110');
INSERT INTO `obj_ad` VALUES ('36dec564-f1f1-4bec-bd58-15a0b24aa536', '莲都区', '3311', NULL, '2', '0', '331102');
INSERT INTO `obj_ad` VALUES ('36e31112-aa3d-4532-b2af-802c9e11eb19', '吕山乡', '330522', NULL, '3', '0', '330522202');
INSERT INTO `obj_ad` VALUES ('370c9f13-ed4e-4fde-8e0a-ff355ff37233', '嵊州市', '3306', NULL, '2', '0', '330683');
INSERT INTO `obj_ad` VALUES ('37136eef-eb29-4baa-84de-67a43afa95d0', '大田乡', '330723', NULL, '3', '0', '330723200');
INSERT INTO `obj_ad` VALUES ('372c1569-76b4-4884-b5e2-69bf46d5a1c5', '浒山街道', '330282', NULL, '3', '0', '330282004');
INSERT INTO `obj_ad` VALUES ('373dcdb2-f6fe-4d42-9c4e-90276cb0bd92', '彭溪镇', '330329', NULL, '3', '0', '330329105');
INSERT INTO `obj_ad` VALUES ('374a86a5-8391-4e7a-8e84-7d1dd5418ff7', '丹西街道', '330225', NULL, '3', '0', '330225002');
INSERT INTO `obj_ad` VALUES ('37647601-7da6-455a-8325-1cec58467b2f', '葛山乡', '331127', NULL, '3', '0', '331127211');
INSERT INTO `obj_ad` VALUES ('37747e1f-5932-4570-8a31-b4b1cdacc527', '古市镇', '331124', NULL, '3', '0', '331124101');
INSERT INTO `obj_ad` VALUES ('377a1ab4-d2e1-4672-801f-81f0b0adf2a8', '剑池街道', '331181', NULL, '3', '0', '331181003');
INSERT INTO `obj_ad` VALUES ('377b1b26-ff52-497e-9800-a5a255d1293a', '傅村镇', '330703', NULL, '3', '0', '330703102');
INSERT INTO `obj_ad` VALUES ('37e7ed2a-69b9-4e14-ab4b-632bcb7d2306', '梅山街道', '330206', NULL, '3', '0', '330206009');
INSERT INTO `obj_ad` VALUES ('3807344b-835d-4f04-a215-221f4f011359', '丁宅乡', '330604', NULL, '3', '0', '330604202');
INSERT INTO `obj_ad` VALUES ('3811c4bf-47f1-4894-a764-0807eac0b337', '新丰镇', '330402', NULL, '3', '0', '330402103');
INSERT INTO `obj_ad` VALUES ('38636115-9301-4fbc-85f9-b809082ed299', '南宋镇', '330327', NULL, '3', '0', '330327126');
INSERT INTO `obj_ad` VALUES ('3889f9d4-718d-4e87-af9d-84df635d15c6', '中马街道', '330205', NULL, '3', '0', '330205001');
INSERT INTO `obj_ad` VALUES ('388af2e9-29e5-4d5e-aeea-6627a2571baf', '白峰镇', '330206', NULL, '3', '0', '330206105');
INSERT INTO `obj_ad` VALUES ('38a1c183-4a25-405b-b858-6018730ff2ad', '百官街道', '330682', NULL, '3', '0', '330682001');
INSERT INTO `obj_ad` VALUES ('38baaa91-bae5-40dd-ad0c-8ae1e83ad306', '云湖乡', '330328', NULL, '3', '0', '330328211');
INSERT INTO `obj_ad` VALUES ('38c30e2f-1a74-4b22-be5e-e0898f24d395', '画溪街道', '330522', NULL, '3', '0', '330522002');
INSERT INTO `obj_ad` VALUES ('38cfbcda-fb2a-4488-bd21-ef184ab172f5', '景山街道', '330304', NULL, '3', '0', '330304001');
INSERT INTO `obj_ad` VALUES ('38d3689b-5f63-4743-9029-d7e36b1fdb82', '广陈镇', '330482', NULL, '3', '0', '330482106');
INSERT INTO `obj_ad` VALUES ('38dc54bd-16b9-49af-b2b2-d39f29d39b35', '半山街道', '330105', NULL, '3', '0', '330105011');
INSERT INTO `obj_ad` VALUES ('3914c109-1185-443c-8708-68882ef4263f', '县本级', '331081', NULL, '3', '0', '331081000');
INSERT INTO `obj_ad` VALUES ('3925E629-3D9F-4526-B9B9-547E1EEFE088', '大唐街道', '330681', NULL, '3', '0', '330681005');
INSERT INTO `obj_ad` VALUES ('394a4bda-1306-4a70-97a5-ad330a84f731', '顺溪镇', '330326', NULL, '3', '0', '330326108');
INSERT INTO `obj_ad` VALUES ('395336a1-65ef-4429-b07d-366f5f5849cd', '新处乡', '331124', NULL, '3', '0', '331124210');
INSERT INTO `obj_ad` VALUES ('397c604d-ac08-42b2-9c5b-54b709cfd5c9', '白沙街道', '330205', NULL, '3', '0', '330205002');
INSERT INTO `obj_ad` VALUES ('39842f31-193a-4b05-b472-2aca7cbc4599', '县本级', '330502', NULL, '3', '0', '330502000');
INSERT INTO `obj_ad` VALUES ('39871181-f986-4587-ae55-375a4434ae44', '县本级', '330127', NULL, '3', '0', '330127000');
INSERT INTO `obj_ad` VALUES ('39c164fc-3cee-4118-a5a8-6870f0db9471', '德清经济开发区', '330521', NULL, '3', '0', '330521203');
INSERT INTO `obj_ad` VALUES ('39c2ea76-8c71-4264-8462-3c00660efc77', '沙门镇', '331083', NULL, '3', '0', '331083105');
INSERT INTO `obj_ad` VALUES ('39d4175e-860e-4b02-a69a-c2d764117ed6', '鹤城镇', '331121', NULL, '3', '0', '331121100');
INSERT INTO `obj_ad` VALUES ('39e2f285-570f-4283-8c10-258456c28ca4', '百丈漈镇', '330328', NULL, '3', '0', '330328101');
INSERT INTO `obj_ad` VALUES ('39e699c4-8e6f-408d-85be-cd17567da93c', '县本级', '331082', NULL, '3', '0', '331082000');
INSERT INTO `obj_ad` VALUES ('3a226e9e-3f2a-4c86-a8e1-2de05f53ffe1', '岙底乡', '330302', NULL, '3', '0', '330302206');
INSERT INTO `obj_ad` VALUES ('3a2af51a-0f89-40f5-93ff-854b56e51d22', '市本级', '3305', NULL, '2', '0', '330501');
INSERT INTO `obj_ad` VALUES ('3a4175bf-613f-4887-909e-5b6e57809973', '盖北镇', '330604', NULL, '3', '0', '330604112');
INSERT INTO `obj_ad` VALUES ('3a490018-f238-4613-a6f5-98d8ceb52b9e', '义乌市', '3307', NULL, '2', '0', '330782');
INSERT INTO `obj_ad` VALUES ('3a600db8-69c3-4731-a619-54501f510069', '平水镇', '330603', NULL, '3', '0', '330603105');
INSERT INTO `obj_ad` VALUES ('3ab1dd4b-a5b1-469e-98de-4e28a0db81c1', '莘畈乡', '330702', NULL, '3', '0', '330702208');
INSERT INTO `obj_ad` VALUES ('3ae7ed29-95dc-4fbe-9a6f-3755db8048a6', '浦亭乡', '330327', NULL, '3', '0', '330327209');
INSERT INTO `obj_ad` VALUES ('3afd9c76-32a1-4543-8f7e-1ef930cb3c73', '胜山镇', '330282', NULL, '3', '0', '330282113');
INSERT INTO `obj_ad` VALUES ('3b19cb58-a19b-4a65-9767-e5918b5fca11', '柯桥区', '3306', NULL, '2', '0', '330621');
INSERT INTO `obj_ad` VALUES ('3b22d243-1bb0-4d37-9184-bed3beb55128', '方溪乡', '331122', NULL, '3', '0', '331122211');
INSERT INTO `obj_ad` VALUES ('3b5fef74-864b-4d47-b93c-daa42ad4e280', '马岙镇', '330902', NULL, '3', '0', '330902106');
INSERT INTO `obj_ad` VALUES ('3b7b6bb5-8233-42ae-a279-c8ed6abe9930', '蒋村街道', '330106', NULL, '3', '0', '330106011');
INSERT INTO `obj_ad` VALUES ('3b818e64-fd0c-4d8b-bb48-8903816fdc8d', '濛洲街道', '331126', NULL, '3', '0', '331126002');
INSERT INTO `obj_ad` VALUES ('3ba2d02c-1d7c-481a-b09f-cdcf259d2ea1', '社阳乡', '330825', NULL, '3', '0', '330825209');
INSERT INTO `obj_ad` VALUES ('3bac2488-9196-4a59-9fdd-e6c1e8d1096f', '郭溪街道', '330304', NULL, '3', '0', '330304009');
INSERT INTO `obj_ad` VALUES ('3bcaad9b-2437-44a1-8a32-2bf1a7fd4400', '峰源乡', '331102', NULL, '3', '0', '331102202');
INSERT INTO `obj_ad` VALUES ('3bcaf2e5-63b6-4cc8-988e-b695bb5f10a2', '塔石乡', '330702', NULL, '3', '0', '330702206');
INSERT INTO `obj_ad` VALUES ('3be1930e-fb56-4832-af93-7d896e2a346d', '竹口镇', '331126', NULL, '3', '0', '331126102');
INSERT INTO `obj_ad` VALUES ('3c0f433a-e317-4536-99d2-bd754bd0d90d', '市本级', '3302', NULL, '2', '0', '330201');
INSERT INTO `obj_ad` VALUES ('3c163f3d-cf19-44f9-a5da-b6e2d33e455f', '浦南街道', '330726', NULL, '3', '0', '330726001');
INSERT INTO `obj_ad` VALUES ('3c3316a3-d510-4f80-bab6-8b2603858714', '五马街道', '330302', NULL, '3', '0', '330302006');
INSERT INTO `obj_ad` VALUES ('3c3cad1d-c54a-4ee0-af79-d4849ea7e887', '梁辉水库', '330281', NULL, '3', '0', '330281303');
INSERT INTO `obj_ad` VALUES ('3c66e56e-5dea-45f9-aaed-8c8a29a365c5', '兰巨乡', '331181', NULL, '3', '0', '331181200');
INSERT INTO `obj_ad` VALUES ('3c94fb9b-32cd-4fb8-b0c6-5f4d923524a0', '鹿亭乡', '330281', NULL, '3', '0', '330281014');
INSERT INTO `obj_ad` VALUES ('3cb05d71-a790-49c0-ae82-c62ab87cd034', '临安区', '3301', NULL, '2', '0', '330112');
INSERT INTO `obj_ad` VALUES ('3cdfa1d3-c900-4116-aeed-327bd9b50f16', '坦头镇', '331023', NULL, '3', '0', '331023106');
INSERT INTO `obj_ad` VALUES ('3ceca227-dec2-48a5-81d7-f719323ca0b4', '富盛镇', '330621', NULL, '3', '0', '330621112');
INSERT INTO `obj_ad` VALUES ('3cefef36-d597-4fbd-8064-e2b5fbf6d8b1', '临岐镇', '330127', NULL, '3', '0', '330127103');
INSERT INTO `obj_ad` VALUES ('3cf85622-9427-486b-b6d3-6ba45d84ad69', '四山乡', '331126', NULL, '3', '0', '331126212');
INSERT INTO `obj_ad` VALUES ('3d34feaf-e44d-483d-831e-a1a52ca7f508', '桐君街道', '330122', NULL, '3', '0', '330122001');
INSERT INTO `obj_ad` VALUES ('3d38c6a0-328c-4456-bb53-fdedb31e72e8', '滨江街道', '330302', NULL, '3', '0', '330302024

标签: xs618b4nal2传感器xs618b1pbl2传感器a160贴片三极管d260s01传感器202a交流电流变送器

锐单商城拥有海量元器件数据手册IC替代型号,打造 电子元器件IC百科大全!

锐单商城 - 一站式电子元器件采购平台