世界国家区域城市表以及数据.zip_世界各国的行政区划一览表资源-CSDN文库

共2个文件

sql：2个

世界国家区域数据

行政区域

世界区域sql

全球区域

4星 · 超过85%的资源需积分: 50 25 浏览量 2020-08-12 10:52:45 上传评论 3 收藏 107KB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

世界国家区域城市表以及数据.zip （2个子文件）

世界国家区域城市表以及数据

SELECT_t___FROM_bb_dev_t_bb_city_region_.sql 2.54MB

世界城市区域通用表.sql 2KB

INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (1, 0, '', 1, '中国', 0, 1, 1, '', '', '', '2014-05-05 12:00:03', '2014-05-05 12:00:03', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110000, 1, '1', 1, '北京', 0, 2, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110100, 110000, '1|110000', 1, '北京市', 0, 3, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110101, 110100, '1|110000|110100', 0, '东城区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110102, 110100, '1|110000|110100', 0, '西城区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110103, 110100, '1|110000|110100', 0, '崇文区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110104, 110100, '1|110000|110100', 0, '宣武区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110105, 110100, '1|110000|110100', 0, '朝阳区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110106, 110100, '1|110000|110100', 0, '丰台区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110107, 110100, '1|110000|110100', 0, '石景山区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110108, 110100, '1|110000|110100', 0, '海淀区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110109, 110100, '1|110000|110100', 0, '门头沟区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110111, 110100, '1|110000|110100', 0, '房山区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110112, 110100, '1|110000|110100', 0, '通州区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110113, 110100, '1|110000|110100', 0, '顺义区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110114, 110100, '1|110000|110100', 0, '昌平区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110115, 110100, '1|110000|110100', 0, '大兴区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110116, 110100, '1|110000|110100', 0, '怀柔区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110117, 110100, '1|110000|110100', 0, '平谷区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110118, 110100, '1|110000|110100', 0, '密云区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110119, 110100, '1|110000|110100', 0, '延庆区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110228, 110100, '1|110000|110100', 0, '密云县', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110229, 110100, '1|110000|110100', 0, '延庆县', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:32:24', ''); INSERT INTO bb_dev.t_bb_city_region (Fregion_id, Fp_region_id, Fcr_path, Fis_parent, Fcr_name, Fsort, Fregion_type, Fregion_status, Fregion_path, Foperator, Fremark, Fcreate_time, Fupdate_time, Fpostcode) VALUES (110230, 110100, '1|110000|110100', 0, '其它区', 0, 4, 1, '', '', '', '2014-05-05 12:02:05', '2014-05-05 12:3

评论收藏

内容反馈