tb_area.sql

《全国政区数据表》 SQL文档

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130227', '迁西县', '1302', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130229', '玉田县', '1302', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130230', '唐海县', '1302', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130281', '遵化市', '1302', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130282', '丰南市', '1302', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130283', '迁安市', '1302', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1303', '秦皇岛', '13', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130301', '市辖区', '1303', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130302', '海港区', '1303', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130303', '山海关区', '1303', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130304', '北戴河区', '1303', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130321', '青龙满族自治县', '1303', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130322', '昌黎县', '1303', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130323', '抚宁县', '1303', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130324', '卢龙县', '1303', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1304', '邯郸', '13', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130401', '市辖区', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130402', '邯山区', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130403', '丛台区', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130404', '复兴区', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130406', '峰峰矿区', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130421', '邯郸县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130423', '临漳县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130424', '成安县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130425', '大名县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130426', '涉  县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130427', '磁  县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130428', '肥乡县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130429', '永年县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130430', '邱  县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130431', '鸡泽县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130432', '广平县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130433', '馆陶县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130434', '魏  县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130435', '曲周县', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130481', '武安市', '1304', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1305', '邢台', '13', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130501', '市辖区', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130502', '桥东区', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130503', '桥西区', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130521', '邢台县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130522', '临城县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130523', '内丘县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130524', '柏乡县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130525', '隆尧县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130526', '任  县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130527', '南和县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130528', '宁晋县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130529', '巨鹿县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130530', '新河县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130531', '广宗县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130532', '平乡县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130533', '威  县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130534', '清河县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130535', '临西县', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130581', '南宫市', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130582', '沙河市', '1305', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1306', '保定', '13', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130601', '市辖区', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130602', '新市区', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130603', '北市区', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130604', '南市区', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130621', '满城县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130622', '清苑县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130623', '涞水县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130624', '阜平县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130625', '徐水县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130626', '定兴县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130627', '唐  县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130628', '高阳县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130629', '容城县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130630', '涞源县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130631', '望都县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130632', '安新县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130633', '易  县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130634', '曲阳县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130635', '蠡  县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130636', '顺平县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130637', '博野县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130638', '雄  县', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130681', '涿州市', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130682', '定州市', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])