tb_area.sql

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

VALUES 
  ('130683', '安国市', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130684', '高碑店市', '1306', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1307', '张家口', '13', 0, 2, NULL)
GO

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

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

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

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130705', '宣化区', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130706', '下花园区', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130721', '宣化县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130722', '张北县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130723', '康保县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130724', '沽源县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130725', '尚义县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130726', '蔚  县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130727', '阳原县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130728', '怀安县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130729', '万全县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130730', '怀来县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130731', '涿鹿县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130732', '赤城县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130733', '崇礼县', '1307', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1308', '承德', '13', 0, 2, NULL)
GO

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

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130802', '双桥区', '1308', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130803', '双滦区', '1308', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130804', '鹰手营子矿区', '1308', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130821', '承德县', '1308', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130822', '兴隆县', '1308', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130823', '平泉县', '1308', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130824', '滦平县', '1308', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130825', '隆化县', '1308', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130826', '丰宁满族自治县', '1308', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130827', '宽城满族自治县', '1308', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130828', '围场满族蒙古族自治县', '1308', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1309', '沧州', '13', 0, 2, NULL)
GO

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

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130902', '新华区', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130903', '运河区', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130921', '沧  县', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130922', '青  县', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130923', '东光县', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130924', '海兴县', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130925', '盐山县', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130926', '肃宁县', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130927', '南皮县', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130928', '吴桥县', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130929', '献  县', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130930', '孟村回族自治县', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130981', '泊头市', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130982', '任丘市', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130983', '黄骅市', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('130984', '河间市', '1309', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1310', '廊坊', '13', 0, 2, NULL)
GO

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

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131002', '安次区', '1310', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131003', '廊坊市广阳区', '1310', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131022', '固安县', '1310', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131023', '永清县', '1310', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131024', '香河县', '1310', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131025', '大城县', '1310', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131026', '文安县', '1310', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131028', '大厂回族自治县', '1310', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131081', '霸州市', '1310', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131082', '三河市', '1310', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1311', '衡水', '13', 0, 2, NULL)
GO

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

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131102', '桃城区', '1311', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131121', '枣强县', '1311', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131122', '武邑县', '1311', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131123', '武强县', '1311', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131124', '饶阳县', '1311', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131125', '安平县', '1311', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131126', '故城县', '1311', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131127', '景  县', '1311', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131128', '阜城县', '1311', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131181', '冀州市', '1311', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('131182', '深州市', '1311', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('14', '山西', '0001', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('1401', '太原', '14', 1, 2, NULL)
GO

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

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140105', '小店区', '1401', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140106', '迎泽区', '1401', 0, 2, NULL)
GO

INSERT INTO [TB_Area] ([AreaCode], [AreaName], [ParentAreaCode], [Root], [Zone], [NavigateURL])
VALUES 
  ('140107', '杏花岭区', '1401', 0, 2, NULL)