最新全国行政区划编码 sql（3级，2016-08-09 统计局发布）

prompt PL/SQL Developer import file prompt Created on 2016年11月23日 by Administrator set feedback off set define off prompt Creating SYS_AREA... create table SYS_AREA ( code VARCHAR2(20) not null, parent_code VARCHAR2(20), name VARCHAR2(64), province VARCHAR2(64), city VARCHAR2(64), district VARCHAR2(64), full_name VARCHAR2(128) ) tablespace XXX pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K next 8K minextents 1 maxextents unlimited ); comment on table SYS_AREA is '行政区划--全国省市县三级'; comment on column SYS_AREA.code is '行政区划编码'; comment on column SYS_AREA.parent_code is '父级行政区划编码'; comment on column SYS_AREA.name is '名称'; comment on column SYS_AREA.province is '省'; comment on column SYS_AREA.city is '市'; comment on column SYS_AREA.district is '县'; comment on column SYS_AREA.full_name is '全称'; prompt Disabling triggers for SYS_AREA... alter table SYS_AREA disable all triggers; prompt Deleting SYS_AREA... delete from SYS_AREA; commit; prompt Loading SYS_AREA... insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540236', '540200', '萨嘎县', '西藏自治区', '日喀则市', '萨嘎县', '西藏自治区日喀则市萨嘎县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540237', '540200', '岗巴县', '西藏自治区', '日喀则市', '岗巴县', '西藏自治区日喀则市岗巴县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540300', '540000', '昌都市', '西藏自治区', '昌都市', null, '西藏自治区昌都市'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540302', '540300', '卡若区', '西藏自治区', '昌都市', '卡若区', '西藏自治区昌都市卡若区'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540321', '540300', '江达县', '西藏自治区', '昌都市', '江达县', '西藏自治区昌都市江达县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540322', '540300', '贡觉县', '西藏自治区', '昌都市', '贡觉县', '西藏自治区昌都市贡觉县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540323', '540300', '类乌齐县', '西藏自治区', '昌都市', '类乌齐县', '西藏自治区昌都市类乌齐县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540324', '540300', '丁青县', '西藏自治区', '昌都市', '丁青县', '西藏自治区昌都市丁青县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540325', '540300', '察雅县', '西藏自治区', '昌都市', '察雅县', '西藏自治区昌都市察雅县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540326', '540300', '八宿县', '西藏自治区', '昌都市', '八宿县', '西藏自治区昌都市八宿县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540327', '540300', '左贡县', '西藏自治区', '昌都市', '左贡县', '西藏自治区昌都市左贡县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540328', '540300', '芒康县', '西藏自治区', '昌都市', '芒康县', '西藏自治区昌都市芒康县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540329', '540300', '洛隆县', '西藏自治区', '昌都市', '洛隆县', '西藏自治区昌都市洛隆县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540330', '540300', '边坝县', '西藏自治区', '昌都市', '边坝县', '西藏自治区昌都市边坝县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540400', '540000', '林芝市', '西藏自治区', '林芝市', null, '西藏自治区林芝市'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540402', '540400', '巴宜区', '西藏自治区', '林芝市', '巴宜区', '西藏自治区林芝市巴宜区'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540421', '540400', '工布江达县', '西藏自治区', '林芝市', '工布江达县', '西藏自治区林芝市工布江达县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540422', '540400', '米林县', '西藏自治区', '林芝市', '米林县', '西藏自治区林芝市米林县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540423', '540400', '墨脱县', '西藏自治区', '林芝市', '墨脱县', '西藏自治区林芝市墨脱县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540424', '540400', '波密县', '西藏自治区', '林芝市', '波密县', '西藏自治区林芝市波密县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540425', '540400', '察隅县', '西藏自治区', '林芝市', '察隅县', '西藏自治区林芝市察隅县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('540426', '540400', '朗县', '西藏自治区', '林芝市', '朗县', '西藏自治区林芝市朗县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('542200', '540000', '山南地区', '西藏自治区', '山南地区', null, '西藏自治区山南地区'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('542221', '542200', '乃东县', '西藏自治区', '山南地区', '乃东县', '西藏自治区山南地区乃东县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('542222', '542200', '扎囊县', '西藏自治区', '山南地区', '扎囊县', '西藏自治区山南地区扎囊县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('542223', '542200', '贡嘎县', '西藏自治区', '山南地区', '贡嘎县', '西藏自治区山南地区贡嘎县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('542224', '542200', '桑日县', '西藏自治区', '山南地区', '桑日县', '西藏自治区山南地区桑日县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('542225', '542200', '琼结县', '西藏自治区', '山南地区', '琼结县', '西藏自治区山南地区琼结县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('542226', '542200', '曲松县', '西藏自治区', '山南地区', '曲松县', '西藏自治区山南地区曲松县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('542227', '542200', '措美县', '西藏自治区', '山南地区', '措美县', '西藏自治区山南地区措美县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('542228', '542200', '洛扎县', '西藏自治区', '山南地区', '洛扎县', '西藏自治区山南地区洛扎县'); insert into SYS_AREA (code, parent_code, name, province, city, district, full_name) values ('542229', '542200', '加查县', '西藏自治区', '山南地区', '加查县', '西藏自治区山南地区加查县'); insert into SYS_AREA (code, parent_code, name, p