全国行政区划数据库.zip

INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110100, 110000, '北京市', '北京', 116.40529, 39.904987, 2, 1, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110101, 110100, '东城区', '东城', 116.418755, 39.917545, 3, 3, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110102, 110100, '西城区', '西城', 116.36679, 39.91531, 3, 15, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110105, 110100, '朝阳区', '朝阳', 116.48641, 39.92149, 3, 2, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110106, 110100, '丰台区', '丰台', 116.286964, 39.863644, 3, 6, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110107, 110100, '石景山区', '石景山', 116.19544, 39.9146, 3, 12, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110108, 110100, '海淀区', '海淀', 116.31032, 39.956074, 3, 7, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110109, 110100, '门头沟区', '门头沟', 116.10538, 39.937183, 3, 9, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110111, 110100, '房山区', '房山', 116.13916, 39.735535, 3, 5, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110112, 110100, '通州区', '通州', 116.6586, 39.902485, 3, 14, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110113, 110100, '顺义区', '顺义', 116.65353, 40.128937, 3, 13, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110114, 110100, '昌平区', '昌平', 116.23591, 40.218086, 3, 1, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110115, 110100, '大兴区', '大兴', 116.338036, 39.72891, 3, 4, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110116, 110100, '怀柔区', '怀柔', 116.63712, 40.324272, 3, 8, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110117, 110100, '平谷区', '平谷', 117.112335, 40.144783, 3, 11, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110228, 110100, '密云县', '密云', 116.84335, 40.37736, 3, 10, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(110229, 110100, '延庆县', '延庆', 115.98501, 40.465324, 3, 16, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120000, 0, '天津', '天津', 117.190186, 39.125595, 1, 2, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120100, 120000, '天津市', '天津', 117.190186, 39.125595, 2, 1, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120101, 120100, '和平区', '和平', 117.19591, 39.11833, 3, 7, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120102, 120100, '河东区', '河东', 117.22657, 39.122124, 3, 6, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120103, 120100, '河西区', '河西', 117.21754, 39.1019, 3, 8, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120104, 120100, '南开区', '南开', 117.16415, 39.120476, 3, 13, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120105, 120100, '河北区', '河北', 117.20157, 39.15663, 3, 5, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120106, 120100, '红桥区', '红桥', 117.1633, 39.175068, 3, 9, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120110, 120100, '东丽区', '东丽', 117.313965, 39.087765, 3, 4, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120111, 120100, '西青区', '西青', 117.012245, 39.139446, 3, 16, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120112, 120100, '津南区', '津南', 117.382545, 38.98958, 3, 11, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120113, 120100, '北辰区', '北辰', 117.13482, 39.225555, 3, 2, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120114, 120100, '武清区', '武清', 117.05796, 39.376926, 3, 15, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120115, 120100, '宝坻区', '宝坻', 117.30809, 39.716965, 3, 1, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120116, 120100, '滨海新区', '滨海', 117.654175, 39.032845, 3, 3, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120221, 120100, '宁河县', '宁河', 117.82828, 39.328884, 3, 14, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120223, 120100, '静海县', '静海', 116.9253, 38.935673, 3, 10, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(120225, 120100, '蓟县', '蓟县', 117.40745, 40.04534, 3, 12, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130000, 0, '河北省', '河北', 114.502464, 38.045475, 1, 3, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130100, 130000, '石家庄市', '石家庄', 114.502464, 38.045475, 2, 8, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130102, 130100, '长安区', '长安', 114.54815, 38.0475, 3, 1, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130103, 130100, '桥东区', '桥东', 114.50289, 38.040154, 3, 11, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130104, 130100, '桥西区', '桥西', 114.46293, 38.02838, 3, 12, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130105, 130100, '新华区', '新华', 114.46597, 38.067142, 3, 16, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130107, 130100, '井陉矿区', '井陉矿', 114.05818, 38.069748, 3, 4, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130108, 130100, '裕华区', '裕华', 114.53326, 38.027695, 3, 20, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130121, 130100, '井陉县', '井陉', 114.144485, 38.033615, 3, 5, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130123, 130100, '正定县', '正定', 114.569885, 38.147835, 3, 23, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130124, 130100, '栾城县', '栾城', 114.65428, 37.88691, 3, 8, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130125, 130100, '行唐县', '行唐', 114.552734, 38.437424, 3, 15, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130126, 130100, '灵寿县', '灵寿', 114.37946, 38.306545, 3, 7, 1); INSERT INTO AREA (ID,PARENT_ID,NAME,SHORT_NAME,LONGITUDE,LATITUDE,LEVEL,SORT,STATUS) VALUES(130127, 130100, '高邑县', '高邑', 114.6107, 37.605713