-
Notifications
You must be signed in to change notification settings - Fork 25
/
insert_industry_One-dimensional.sql
5867 lines (3912 loc) · 419 KB
/
insert_industry_One-dimensional.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (1, 'A', '农、林、牧、渔业', null, 0, '本门类包括 01~05 大类');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (2, '01', '农业', 'A', 1, '指对各种农作物的种植');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (3, '011', '谷物种植', '01', 2, '指以收获籽实为主的农作物的种植,包括稻 谷、小麦、玉米等农作物的种植和作为饲料和工业原料的谷物的种植');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (4, '0111', '稻谷种植', '011', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (5, '0112', '小麦种植', '011', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (6, '0113', '玉米种植', '011', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (7, '0119', '其他谷物种植', '011', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (8, '012', '豆类、油料和薯类种植', '01', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (9, '0121', '豆类种植', '012', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (10, '0122', '油料种植', '012', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (11, '0123', '薯类种植', '012', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (12, '013', '棉、麻、糖、烟草种植', '01', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (13, '0131', '棉花种植', '013', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (14, '0132', '麻类种植', '013', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (15, '0133', '糖料种植', '013', 3, '指用于制糖的甘蔗和甜菜的种植');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (16, '0134', '烟草种植', '013', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (17, '014', '蔬菜、食用菌及园艺作物种植', '01', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (18, '0141', '蔬菜种植', '014', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (19, '0142', '食用菌种植', '014', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (20, '0143', '花卉种植', '014', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (21, '0149', '其他园艺作物种植', '014', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (22, '015', '水果种植', '01', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (23, '0151', '仁果类和核果类水果种植', '015', 3, '指苹果、梨、桃、杏、李子等水果种植');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (24, '0152', '葡萄种植', '015', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (25, '0153', '柑橘类种植', '015', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (26, '0154', '香蕉等亚热带水果种植', '015', 3, '指香蕉、菠萝、芒果等亚热带水果种植');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (27, '0159', '其他水果种植', '015', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (28, '016', '坚果、含油果、香料和饮料作物种植', '01', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (29, '0161', '坚果种植', '016', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (30, '0162', '含油果种植', '016', 3, '指椰子、橄榄、油棕榈等的种植');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (31, '0163', '香料作物种植', '016', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (32, '0164', '茶叶种植', '016', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (33, '0169', '其他饮料作物种植', '016', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (34, '017', '中药材种植', '01', 2, '指主要用于中药配制以及中成药加工的药材作物的种植');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (35, '0171', '中药材种植', '017', 3, '指主要用于中药配制以及中成药加工的各种中草药材作物的种植');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (36, '018', '草种植及割草', '01', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (37, '0181', '草种植', '018', 3, '指人工种植收获牧草');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (38, '0182', '天然草原割草', '018', 3, '指天然草原刈割收获牧草');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (39, '019', '其他农业', '01', 2, '指上述未列明的农作物种植');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (40, '0190', '其他农业', '019', 3, '指上述未列明的农作物种植');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (41, '02', '林业', 'A', 1, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (42, '021', '林木育种和育苗', '02', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (43, '0211', '林木育种', '021', 3, '指应用遗传学原理选育和繁殖林木新品种核心的栽植材料的林木遗传改良活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (44, '0212', '林木育苗', '021', 3, '指通过人为活动将种子、穗条或植物其他组织培育成苗木的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (45, '022', '造林和更新', '02', 2, '指在宜林荒山荒地荒沙、采伐迹地、火烧迹地、疏林地、灌木林地等一切可造林的土地上通过人工造林、人工更新、封山育林、飞播造林等方式培育和恢复森林的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (46, '0220', '造林和更新', '022', 3, '指在宜林荒山荒地荒沙、采伐迹地、火烧迹地、疏林地、灌木林地等一切可造林的土地上通过人工造林、人工更新、封山育林、飞播造林等方式培育和恢复森林的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (47, '023', '森林经营、管护和改培', '02', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (48, '0231', '森林经营和管护', '023', 3, '指为促进林木生长发育,在林木生长的不同时期进行的促进林木生长发育的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (49, '0232', '森林改培', '023', 3, '指为调整林分结构和树种组成,形成密度合理、物种丰富、功能完备的优质、高产、高效林而采取林分抚育、补植、补播等人工措施的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (50, '024', '木材和竹材采运', '02', 2, '指对林木和竹木的采伐,并将其运出山场至贮木场的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (51, '0241', '木材采运', '024', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (52, '0242', '竹材采运', '024', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (53, '025', '林产品采集', '02', 2, '指在天然林地和人工林地进行的各种林木产品和其他野生植物的采集等活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (54, '0251', '木竹材林产品采集', '025', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (55, '0252', '非木竹材林产品采集', '025', 3, '指在天然林地和人工林地进行的除木材、竹材产品外的其他各种林产品的采集活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (56, '03', '畜牧业', 'A', 1, '指为了获得各种畜禽产品而从事的动物饲养、捕捉活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (57, '031', '牲畜饲养', '03', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (58, '0311', '牛的饲养', '031', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (59, '0312', '马的饲养', '031', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (60, '0313', '猪的饲养', '031', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (61, '0314', '羊的饲养', '031', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (62, '0315', '骆驼饲养', '031', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (63, '0319', '其他牲畜饲养', '031', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (64, '032', '家禽饲养', '03', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (65, '0321', '鸡的饲养', '032', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (66, '0322', '鸭的饲养', '032', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (67, '0323', '鹅的饲养', '032', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (68, '0329', '其他家禽饲养', '032', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (69, '033', '狩猎和捕捉动物', '03', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (70, '0330', '狩猎和捕捉动物', '033', 3, '指对各种野生动物的捕捉以及与此相关的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (71, '039', '其他畜牧业', '03', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (72, '0390', '其他畜牧业', '039', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (73, '04', '渔业', 'A', 1, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (74, '041', '水产养殖', '04', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (75, '0411', '海水养殖', '041', 3, '指利用海水对各种水生动植物的养殖');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (76, '0412', '内陆养殖', '041', 3, '指在内陆水域进行的各种水生动植物的养殖');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (77, '042', '水产捕捞', '04', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (78, '0421', '海水捕捞', '042', 3, '指在海洋中对各种天然水生动植物的捕捞');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (79, '0422', '内陆捕捞', '042', 3, '指在内陆水域对各种天然水生动植物的捕捞');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (80, '05', '农、林、牧、渔专业及辅助性活动', 'A', 1, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (81, '051', '农业专业及辅助性活动', '05', 2, '指对农业生产活动进行的各种支持性服务,但不包括各种科学技术和专业技术服务');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (82, '0511', '种子种苗培育活动', '051', 3, '指为农业生产提供农业机械并配备操作人员的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (83, '0512', '农业机械活动', '051', 3, '指对农业生产灌溉系统的经营与管理');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (84, '0513', '灌溉活动', '051', 3, '指对各种农产品(包括天然橡胶、纺织纤维原料)进行脱水、凝固、去籽、净化、分类、晒干、剥皮、初烤、沤软或大批包装以提供初级市场的服务,以及其他农产品的初加工;其中棉花等纺织纤维原料加工指对棉纤维、短绒剥离后的棉籽以及棉花秸秆、铃壳等副产品的综合加工和利用活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (85, '0514', '农产品初加工活动', '051', 3, '指对各种农产品(包括天然橡胶、纺织纤维原料)进行脱水、凝固、打蜡、去籽、净化、分类、晒干、剥皮、初烤、沤软或大批包装以提供初级市场的服务,以及其他农产品的初加工;其中棉花等纺织纤维原料加工指对棉纤维、短绒剥离后的棉籽以及棉花秸秆、铃壳等副产品的综合加工和利用活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (86, '0515', '农作物病虫害防治活动', '051', 3, '指从事农作物重大病虫害防治等活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (87, '0519', '其他农业服务', '051', 3, '指防止病虫害的活动,以及其他未列明的农业服务');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (88, '052', '林业服务业', '05', 2, '指为林业生产服务的病虫害的防治、林地防火等各种辅助性活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (89, '0521', '林业有害生物防治服务', '052', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (90, '0522', '森林防火服务', '052', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (91, '0523', '林产品初级加工活动', '052', 3, '指对各种林产品进行去皮、打枝或去料、净化、初包装提供至贮木场或初级加工活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (92, '0529', '其他林业服务', '052', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (93, '053', '畜牧专业及辅助性活动', '05', 2, '指提供牲畜繁殖、圈舍清理、畜产品生产、初级加工、动物免疫接种、标识佩戴和动物诊疗等活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (94, '0531', '畜牧良种繁殖活动', '053', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (95, '0532', '畜禽粪污处理活动', '053', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (96, '0539', '其他畜牧专业及辅助性活动', '053', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (97, '054', '渔业专业及辅助性活动', '05', 2, '指对渔业生产提供的各种活动,包括鱼苗及鱼种场、水产良种场和水产增殖场等活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (98, '0541', '鱼苗及鱼种场活动', '054', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (99, '0549', '其他渔业专业及辅助性活动', '054', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (100, 'B', '采矿业', null, 0, '本类包括 06~12 大类,采矿业指对固体(如煤和矿物)、液体(如原油)或气体(如天然气)等自然产生的矿物的采掘;包括地下或地上采掘、矿井的运行,以及一般在矿址或矿址附近从事的旨在加工原材料的所有辅助性工作,例如碾磨、选矿和处理,均属本类活动;还包括使原料得以销售所需的准备工作;不包括水的蓄集、净化和分配,以及地质勘查、建筑工程活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (101, '06', '煤炭开采和洗选业', 'B', 1, '指对各种煤炭的开采、洗选、分级等生产活动;不包括煤制品的生产和煤炭勘探活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (102, '061', '烟煤和无烟煤开采洗选', '06', 2, '指对地下或露天烟煤、无烟煤的开采,以及对采出的烟煤、无烟煤及其他硬煤进行洗选、分级等提高质量的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (103, '0610', '烟煤和无烟煤开采洗选', '061', 3, '指对地下或露天烟煤、无烟煤的开采,以及对采出的烟煤、无烟煤及其他硬煤进行洗选、分级等提高质量的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (104, '062', '褐煤开采洗选', '06', 2, '指对褐煤--煤化程度较低的一种燃料的地下或露天开采,以及对采出的褐煤进行洗选、分级等提高质量的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (105, '0620', '褐煤开采洗选', '062', 3, '指对褐煤--煤化程度较低的一种燃料的地下或露天开采,以及对采出的褐煤进行洗选、分级等提高质量的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (106, '069', '其他煤炭采选', '06', 2, '指对生长在古生代地层中的含碳量低、灰分高的煤炭资源(如石煤、泥炭)的开采');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (107, '0690', '其他煤炭采选', '069', 3, '指对生长在古生代地层中的含碳量低、灰分高的煤炭资源(如石煤、泥炭)的开采');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (108, '07', '石油和天然气开采业', 'B', 1, '指在陆地或海洋,对天然原油、液态或气态天然气的开采,对煤矿瓦斯气(煤层气)的开采;为运输目的所进行的天然气液化和从天然气田气体中生产液化烃的活动,还包括对含沥青的页岩或油母页岩矿的开采,以及对焦油沙矿进行的同类作业');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (109, '071', '石油开采', '07', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (110, '0711', '陆地石油开采', '071', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (111, '0711', '海洋石油开采', '071', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (112, '072', '天然气开采', '07', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (113, '0721', '陆地天然气开采', '072', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (114, '0722', '海洋天然气及可燃冰开采', '072', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (115, '08', '黑色金属矿采选业', 'B', 1, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (116, '081', '铁矿采选', '08', 2, '指对铁矿石的采矿、选矿活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (117, '0810', '铁矿采选', '081', 3, '指对铁矿石的采矿、选矿活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (118, '082', '锰矿、铬矿采选', '08', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (119, '0820', '锰矿、铬矿采选', '082', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (120, '089', '其他黑色金属矿采选', '08', 2, '指对钒矿等钢铁工业黑色金属辅助原料矿的采矿、选矿活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (121, '0890', '其他黑色金属矿采选', '089', 3, '指对钒矿等钢铁工业黑色金属辅助原料矿的采矿、选矿活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (122, '09', '有色金属矿采选业', 'B', 1, '指对常用有色金属矿、贵金属矿,以及稀有稀土金属矿的开采、选矿活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (123, '091', '常用有色金属矿采选', '09', 2, '指对铜、铅锌、镍钴、锡、锑、铝、镁、汞、镉、铋等常用有色金属矿的采选');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (124, '0911', '铜矿采选', '091', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (125, '0912', '铅锌矿采选', '091', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (126, '0913', '镍钴矿采选', '091', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (127, '0914', '锡矿采选', '091', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (128, '0915', '锑矿采选', '091', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (129, '0916', '铝矿采选', '091', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (130, '0917', '镁矿采选', '091', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (131, '0919', '其他常用有色金属矿采选', '091', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (132, '092', '贵金属矿采选', '09', 2, '指对在地壳中含量极少的金、银和铂族元素(铂、铱、锇、钌、钯、铑)矿的采选');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (133, '0921', '金矿采选', '092', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (134, '0922', '银矿采选', '092', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (135, '0929', '其他贵金属矿采选', '092', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (136, '093', '稀有稀土金属矿采选', '09', 2, '指对在自然界中含量较小,分布稀散或难以从原料中提取,以及研究和使用较晚的金属矿开采、精选');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (137, '0931', '钨钼矿采选', '093', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (138, '0932', '稀土金属矿采选', '093', 3, '指镧系金属及与镧系金属性质相近的金属矿的采选');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (139, '0933', '放射性金属矿采选', '093', 3, '指对主要含钍和铀的矿石开采,以及对这类矿石的精选');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (140, '0939', '其他稀有金属矿采选', '093', 3, '指对稀有轻金属矿、稀有高熔点金属矿、稀散金属矿采选活动,以及其他稀有金属矿的采选');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (141, '10', '非金属矿采选业', 'B', 1, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (142, '101', '土砂石开采', '10', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (143, '1011', '石灰石、石膏开采', '101', 3, '指对石灰、石膏,以及石灰石助熔剂的开采');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (144, '1012', '建筑装饰用石开采', '101', 3, '指通常在采石场切制加工各种纪念碑及建筑用石料的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (145, '1013', '耐火土石开采', '101', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (146, '1019', '粘土及其他土砂石开采', '101', 3, '指用于建筑、陶瓷等方面的粘土开采,以及用于铺路和建筑材料的石料、石渣、砂的开采');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (147, '102', '化学矿开采', '10', 2, '指对化学矿和肥料矿物的开采');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (148, '1020', '化学矿开采', '102', 3, '指对化学矿和肥料矿物的开采');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (149, '103', '采盐', '10', 2, '指通过以海水(含沿海浅层地下卤水)为原料晒制,或以钻井汲取地下卤水,或注水溶解地下岩盐为原料,经真空蒸发干燥,以及从盐湖中采掘制成的以氯化钠为主要成分的盐产品的开采、粉碎和筛选');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (150, '1030', '采盐', '103', 3, '指通过以海水(含沿海浅层地下卤水)为原料晒制,或以钻井汲取地下卤水,或注水溶解地下岩盐为原料,经真空蒸发干燥,以及从盐湖中采掘制成的以氯化钠为主要成分的盐产品的开采、粉碎和筛选');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (151, '109', '石棉及其他非金属矿采选', '10', 2, '指对石棉、石墨、贵重宝石、金刚石、天然磨料及其他矿石的开采');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (152, '1091', '石棉、云母矿采选', '109', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (153, '1092', '石墨、滑石采选', '109', 3, '指对天然石墨、滑石的开采');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (154, '1093', '宝石、玉石采选', '109', 3, '指对贵重宝石、玉石、彩石的开采');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (155, '1099', '其他未列明非金属矿采选', '109', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (156, '11', '开采专业及辅助性活动', 'B', 1, '指为煤炭、石油和天然气等矿物开采提供的服务');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (157, '111', '煤炭开采和洗选辅助活动', '11', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (158, '1110', '煤炭开采和洗选辅助活动', '111', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (159, '112', '石油和天然气开采辅助活动', '11', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (160, '1120', '石油和天然气开采辅助活动', '112', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (161, '119', '其他开采辅助活动', '11', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (162, '1190', '其他开采辅助活动', '119', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (163, '12', '其他采矿业', 'B', 1, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (164, '120', '其他采矿业', '12', 2, '指对地热资源、矿泉水资源以及其他未列明的自然资源的开采,但不包括利用这些资源建立的热电厂和矿泉水厂的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (165, '1200', '其他采矿业', '120', 3, '指对地热资源、矿泉水资源以及其他未列明的自然资源的开采,但不包括利用这些资源建立的热电厂和矿泉水厂的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (166, 'C', '制造业', null, 0, '本门类包括 13~43 大类,指经物理变化或化学变化后成为新的产品,不论是动力机械制造或手工制作,也不论产品是批发销售或零售,均视为制造;建筑物中的各种制成品、零部件的生产应视为制造,但在建筑预制品工地,把主要部件组装成桥梁、仓库设备、铁路与高架公路、升降机与电梯、管道设备、喷水设备、暖气设备、通风设备与空调设备,照明与安装电线等组装活动,以及建筑物的装置,均列为建筑活动;本门类包括机电产品的再制造,指将废旧汽车零部件、工程机械、机床等进行专业化修复的批量化生产过程,再制造的产品达到与原有新产品相同的质量和性能');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (167, '13', '农副食品加工业', 'C', 1, '指直接以农、林、牧、渔业产品为原料进行的谷物磨制、饲料加工、植物油和制糖加工、屠宰及肉类加工、水产品加工,以及蔬菜、水果和坚果等食品的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (168, '131', '谷物磨制', '13', 2, '也称粮食加工,指将稻子、谷子、小麦、高粱等谷物去壳、碾磨及精加工的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (169, '1311', '稻谷加工', '131', 3, '指将稻谷去壳、碾磨成大米的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (170, '1312', '小麦加工', '131', 3, '指将小麦碾磨成小麦粉的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (171, '1313', '玉米加工', '131', 3, '指将玉米碾碎或碾磨成玉米碴或玉米粉的生产活动,不含以玉米为原料的饲料加工、淀粉及淀粉制品制造、酒精制造等');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (172, '1314', '杂粮加工', '131', 3, '指将谷子、高粱、绿豆、红小豆等小宗谷类、豆类作物进行清理去壳、碾磨,加工为成品粮的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (173, '1319', '其他谷物磨制', '131', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (174, '132', '饲料加工', '13', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (175, '1321', '宠物饲料加工', '132', 3, '指专门为合法饲养的猫、狗、鱼、鸟等小动物提供食物的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (176, '1329', '其他饲料加工', '132', 3, '指适用于农场、农户饲养牲畜、家禽的饲料生产加工,包括宠物食品的生产活动,也包括用屠宰下脚料加工生产的动物饲料,即动物源性饲料的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (177, '133', '植物油加工', '13', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (178, '1331', '食用植物油加工', '133', 3, '指用各种食用植物油料生产油脂,以及精制食用油的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (179, '1332', '非食用植物油加工', '133', 3, '指用各种非食用植物油料生产油脂的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (180, '134', '制糖业', '13', 2, '指以甘蔗、甜菜等为原料制作成品糖,以及以原糖或砂糖为原料精炼加工各种精制糖的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (181, '1340', '制糖业', '134', 3, '指以甘蔗、甜菜等为原料制作成品糖,以及以原糖或砂糖为原料精炼加工各种精制糖的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (182, '135', '屠宰及肉类加工', '13', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (183, '1351', '牲畜屠宰', '135', 3, '指对各种牲畜进行宰杀,以及鲜肉冷冻等保鲜活动,但不包括商业冷藏活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (184, '1352', '禽类屠宰', '135', 3, '指对各种禽类进行宰杀,以及鲜肉冷冻等保鲜活动,但不包括商业冷藏活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (185, '1353', '肉制品及副产品加工', '135', 3, '指主要以各种畜、禽肉为原料加工成熟肉制品,以及畜、禽副产品的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (186, '136', '水产品加工', '13', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (187, '1361', '水产品冷冻加工', '136', 3, '指为了保鲜,将海水、淡水养殖或捕捞的鱼类、虾类、甲壳类、贝类、藻类等水生动物或植物进行的冷冻加工,但不包括商业冷藏活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (188, '1362', '鱼糜制品及水产品干腌制加工', '136', 3, '指鱼糜制品制造,以及水产品的干制、腌制等加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (189, '1363', '水产饲料制造', '136', 3, '指用低值水产品及水产品加工废弃物(如鱼骨、内脏、虾壳)等为主要原料的饲料加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (190, '1364', '鱼油提取及制品制造', '136', 3, '指从鱼或鱼肝中提取油脂,并生产制品的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (191, '1369', '其他水产品加工', '136', 3, '指对水生动植物进行的其他加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (192, '137', '蔬菜、菌类、水果和坚果加工', '13', 2, '指用脱水、干制、冷藏、冷冻、腌制等方法,对蔬菜、水果、坚果的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (193, '1371', '蔬菜加工', '137', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (194, '1372', '食用菌加工', '137', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (195, '1373', '水果和坚果加工', '137', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (196, '139', '其他农副食品加工', '13', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (197, '1391', '淀粉及淀粉制品制造', '139', 3, '指用玉米、薯类、豆类及其他植物原料制作淀粉和淀粉制品的生产;还包括以淀粉为原料,经酶法或酸法转换得到的糖品生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (198, '1392', '豆制品制造', '139', 3, '指以大豆、小豆、绿豆、豌豆、蚕豆等豆类为主要原料,经加工制成食品的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (199, '1393', '蛋品加工', '139', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (200, '1399', '其他未列明农副食品加工', '139', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (201, '14', '食品制造业', 'C', 1, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (202, '141', '焙烤食品制造', '14', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (203, '1411', '糕点、面包制造', '141', 3, '指用米粉、面粉、豆粉为主要原料,配以辅料,经成型、油炸、烤制而成的各种食品生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (204, '1419', '饼干及其他焙烤食品制造', '141', 3, '指以面粉(或糯米粉)、糖和油脂为主要原料,配以奶制品、蛋制品等辅料,经成型、焙烤制成的各种饼干,以及用薯类、谷类、豆类等制作的各种易于保存、食用方便的焙烤食品生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (205, '142', '糖果、巧克力及蜜饯制造', '14', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (206, '1421', '糖果、巧克力制造', '142', 3, '糖果制造指以砂糖、葡萄糖浆或饴糖为主要原料,加入油脂、乳品、胶体、果仁、香料、食用色素等辅料制成甜味块状食品的生产活动;巧克力制造指以浆状、粉状或块状可可、可可脂、可可酱、砂糖、乳品等为主要原料加工制成巧克力及巧克力制品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (207, '1422', '蜜饯制作', '142', 3, '指以水果、坚果、果皮及植物的其他部分制作糖果蜜饯的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (208, '143', '方便食品制造', '14', 2, '指以米、面、杂粮等为主要原料加工制成,只需简单烹制即可作为主食,具有食用简便、携带方便,易于储藏等特点的食品制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (209, '1431', '米、面制品制造', '143', 3, '指以米、面、杂粮等为原料,经粗加工制成,未经烹制的各类米面制品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (210, '1432', '速冻食品制造', '143', 3, '指以米、面、杂粮等为主要原料,以肉类、蔬菜等为辅料,经加工制成各类烹制或未烹制的主食食品后,立即采用速冻工艺制成的,并可以在冻结条件下运输储存及销售的各类主食食品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (211, '1433', '方便面制造', '143', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (212, '1439', '方便面及其他方便食品制造', '143', 3, '指用米、面、杂粮等为主要原料加工制成的,可以直接食用或只需简单蒸煮即可作为主食的各种方便主食食品的生产活动,以及其他未列明的方便食品制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (213, '144', '乳制品制造', '14', 2, '指以生鲜牛(羊)乳及其制品为主要原料,经加工制成的液体乳及固体乳(乳粉、炼乳、乳脂肪、干酪等)制品的生产活动;不包括含乳饮料和植物蛋白饮料生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (214, '1441', '液体乳制造', '144', 3, '指以生鲜牛(羊)乳及其制品为主要原料,经加工制成的液体乳及固体乳(乳粉、炼乳、乳脂肪、干酪等)制品的生产活动;不包括含乳饮料和植物蛋白饮料生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (215, '1442', '乳粉制造', '144', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (216, '1449', '其他乳制品制造', '144', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (217, '145', '罐头食品制造', '14', 2, '指将符合要求的原料经处理、分选、修整、烹调(或不经烹调)、装罐、密封、杀菌、冷却(或无菌包装)等罐头生产工艺制成的,达到商业无菌要求,并可以在常温下储存的罐头食品的制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (218, '1451', '肉、禽类罐头制造', '145', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (219, '1452', '水产品罐头制造', '145', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (220, '1453', '蔬菜、水果罐头制造', '145', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (221, '1459', '其他罐头食品制造', '145', 3, '指婴幼儿辅助食品类罐头、米面食品类罐头(如八宝粥罐头等)及上述未列明的罐头食品制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (222, '146', '调味品、发酵制品制造', '14', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (223, '1461', '味精制造', '146', 3, '指以淀粉或糖蜜为原料,经微生物发酵、提取、精制等工序制成的,谷氨酸钠含量在80%及以上的鲜味剂的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (224, '1462', '酱油、食醋及类似制品制造', '146', 3, '指以大豆和(或)脱脂大豆,小麦和(或)麸皮为原料,经微生物发酵制成的各种酱油和酱类制品,以及以单独或混合使用各种含有淀粉、糖的物料或酒精,经微生物发酵酿制的酸性调味品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (225, '1469', '其他调味品、发酵制品制造', '146', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (226, '149', '其他食品制造', '14', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (227, '1491', '营养食品制造', '149', 3, '指主要适宜伤残者、老年人,含肉、鱼、水果、蔬菜、奶、麦精、钙等均质配料的营养食品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (228, '1492', '保健食品制造', '149', 3, '指标明具有特定保健功能的食品,适用于特定人群食用,具有调节机体功能,不以治疗为目的,对人体不产生急性、亚急性或慢性危害,以补充维生素、矿物质为目的的营养素补充等保健食品制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (229, '1493', '冷冻饮品及食用冰制造', '149', 3, '指以砂糖、乳制品、豆制品、蛋制品、油脂、果料和食用添加剂等经混合配制、加热杀菌、均质、老化、冻结(凝冻)而成的冷食饮品的制造,以及食用冰的制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (230, '1494', '盐加工', '149', 3, '指以原盐为原料,经过化卤、蒸发、洗涤、粉碎、干燥、脱水、筛分等工序,或在其中添加碘酸钾及调味品等加工制成盐产品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (231, '1495', '食品及饲料添加剂制造', '149', 3, '指增加或改善食品特色的化学品,以及补充动物饲料的营养成分和促进生长、防治疫病的制剂的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (232, '1499', '其他未列明食品制造', '149', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (233, '15', '酒、饮料和精制茶制造业', 'C', 1, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (234, '151', '酒的制造', '15', 2, '指酒精、白酒、啤酒及其专用麦芽、黄酒、葡萄酒、果酒、配制酒以及其他酒的生产');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (235, '1511', '酒精制造', '151', 3, '指用玉米、小麦、薯类等淀粉质原料或用糖蜜等含糖质原料,经蒸煮、糖化、发酵及蒸馏等工艺制成的酒精产品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (236, '1512', '白酒制造', '151', 3, '指以高粱等粮谷为主要原料,以大曲、小曲或麸曲及酒母等为糖化发酵剂,经蒸煮、糖化、发酵、蒸馏、陈酿、勾兑而制成的蒸馏酒产品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (237, '1513', '啤酒制造', '151', 3, '指以麦芽(包括特种麦芽)、水为主要原料,加啤酒花,经酵母发酵酿制而成,含二氧化碳、起泡、低酒精度的发酵酒产品(包括无醇啤酒,也称脱醇啤酒)的生产活动,以及啤酒专用原料麦芽的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (238, '1514', '黄酒制造', '151', 3, '指以稻米、黍米、黑米、小麦、玉米等为主要原料,加曲、酵母等糖化发酵剂发酵酿制而成的发酵酒产品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (239, '1515', '葡萄酒制造', '151', 3, '指以新鲜葡萄或葡萄汁为原料,经全部或部分发酵酿制而成,含有一定酒精度的发酵酒产品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (240, '1519', '其他酒制造', '151', 3, '指除葡萄酒以外的果酒、配制酒以及上述未列明的其他酒产品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (241, '152', '饮料制造', '15', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (242, '1521', '碳酸饮料制造', '152', 3, '指在一定条件下充入二氧化碳气的饮用品制造,其成品中二氧化碳气的含量(20℃时的体积倍数)不低于2.0倍');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (243, '1522', '瓶(罐)装饮用水制造', '152', 3, '指以地下矿泉水和符合生活饮用水卫生标准的水为水源加工制成的,密封于塑料瓶(罐)、玻璃瓶或其他容器中,不含任何添加剂,可直接饮用的水的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (244, '1523', '果菜汁及果菜汁饮料制造', '152', 3, '指以新鲜或冷藏水果和蔬菜为原料,经加工制得的果菜汁液制品生产活动,以及在果汁或浓缩果汁、蔬菜汁中加入水、糖液、酸味剂等,经调制而成的可直接饮用的饮品(果汁含量不低于10%)的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (245, '1524', '含乳饮料和植物蛋白饮料制造', '152', 3, '指以鲜乳或乳制品为原料(经发酵或未经发酵),加入水、糖液等调制而成的可直接饮用的含乳饮品的生产活动,以及以蛋白质含量较高的植物的果实、种子或核果类、坚果类的果仁等为原料,在其加工制得的浆液中加入水、糖液等调制而成的可直接饮用的植物蛋白饮品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (246, '1525', '固体饮料制造', '152', 3, '指以糖、食品添加剂、果汁或植物抽提物等为原料,加工制成粉末状、颗粒状或块状制品[其成品水分(质量分数)不高于5%]的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (247, '1529', '茶饮料及其他饮料制造', '152', 3, '指茶饮料、特殊用途饮料以及其他未列明的饮料制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (248, '153', '精制茶加工', '15', 2, '指对毛茶或半成品原料茶进行筛分、轧切、风选、干燥、匀堆、拼配等精制加工茶叶的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (249, '1530', '精制茶加工', '153', 3, '指对毛茶或半成品原料茶进行筛分、轧切、风选、干燥、匀堆、拼配等精制加工茶叶的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (250, '16', '烟草制品业', 'C', 1, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (251, '161', '烟叶复烤', '16', 2, '指在原烟(初烤)基础上进行第二次烟叶水分调整的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (252, '1610', '烟叶复烤', '161', 3, '指在原烟(初烤)基础上进行第二次烟叶水分调整的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (253, '162', '卷烟制造', '16', 2, '指各种卷烟生产,但不包括生产烟用滤嘴棒的纤维丝束原料的制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (254, '1620', '卷烟制造', '162', 3, '指各种卷烟生产,但不包括生产烟用滤嘴棒的纤维丝束原料的制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (255, '169', '其他烟草制品制造', '16', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (256, '1690', '其他烟草制品制造', '169', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (257, '17', '纺织业', 'C', 1, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (258, '171', '棉纺织及印染精加工', '17', 2, '指棉、棉型化纤(化纤短丝)纺织及印染精加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (259, '1711', '棉纺纱加工', '171', 3, '指以棉及棉型化学纤维为主要原料进行的纺纱加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (260, '1712', '棉织造加工', '171', 3, '指以棉纱、混纺纱、化学纤维纱为主要原料进行的机织物织造加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (261, '1713', '棉印染精加工', '171', 3, '指对非自产的棉和化学纤维织物进行漂白、染色、印花、轧光、起绒、缩水等工序的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (262, '172', '毛纺织及染整精加工', '17', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (263, '1721', '毛条和毛纱线加工', '172', 3, '指以毛及毛型化学纤维为原料进行梳条的加工,按毛纺工艺(精梳、粗梳、半精梳)进行纺纱的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (264, '1722', '毛织造加工', '172', 3, '指以毛及毛型化学纤维纱线为原料进行的机织物织造加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (265, '1723', '毛染整精加工', '172', 3, '指对非自产的毛织物进行漂白、染色、印花等工序的染整精加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (266, '173', '麻纺织及染整精加工', '17', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (267, '1731', '麻纤维纺前加工和纺纱', '173', 3, '指以苎麻、亚麻、大麻、黄麻、剑麻、罗布麻等为原料的纺前纤维加工和纺纱加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (268, '1732', '麻织造加工', '173', 3, '指以苎麻、亚麻、大麻、黄麻、剑麻、罗布麻纤维纱线等为主要原料的机织物织造加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (269, '1733', '麻染整精加工', '173', 3, '指对非自产的麻织物进行漂白、染色、印花等工序的染整精加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (270, '174', '丝绢纺织及印染精加工', '17', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (271, '1741', '缫丝加工', '174', 3, '指由蚕茧经过加工缫制成丝的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (272, '1742', '绢纺和丝织加工', '174', 3, '指以丝为主要原料进行的丝织物织造加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (273, '1743', '丝印染精加工', '174', 3, '指对非自产的丝织物进行漂白、染色、印花、轧光、起绒、缩水等工序的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (274, '175', '化纤织造及印染精加工', '17', 2, '指经纬双向或经向以化纤长丝(不包括化纤短纤)为主要原料生产的机织物');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (275, '1751', '化纤织造加工', '175', 3, '指以化纤长丝(含有色长丝)为主要原料生产的机织坯布、色织布');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (276, '1752', '化纤织物染整精加工', '175', 3, '指对化纤长丝坯布进行漂白、染色、印花、轧光、起绒、缩水等染整工序的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (277, '176', '针织或钩针编织物及其制品制造', '17', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (278, '1761', '针织或钩针编织物织造', '176', 3, '指采用经编、纬编、横编及钩针编工艺进行的针织物织造加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (279, '1762', '针织或钩针编织物印染精加工', '176', 3, '指对非自产的针织品进行漂白、染色、印花、轧光、起绒、缩水等工序的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (280, '1763', '针织或钩针编织品制造', '176', 3, '指除针织或钩针编织服装以外的其他针织品或钩针编织品的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (281, '177', '家用纺织制成品制造', '17', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (282, '1771', '床上用品制造', '177', 3, '指以棉、麻、丝、毛、化学纤维等纤维及纺织品为主要原料,加工制造床上用品(包括含有填充物的被子、睡袋、枕头等类产品)的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (283, '1772', '毛巾类制品制造', '177', 3, '指以棉、麻、丝及化学纤维等为主要原料,加工制造毛巾类产品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (284, '1773', '窗帘、布艺类产品制造', '177', 3, '指以棉、麻、丝、毛及化学纤维等为主要原料,加工制造窗帘、各种装饰罩(套)、靠垫、坐垫、贮物袋等生活用布艺产品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (285, '1779', '其他家用纺织制成品制造', '177', 3, '指以棉、麻、丝、毛及化学纤维等为主要原料,加工制造毛毯、桌布、台布、餐巾、擦布、洗碗巾等餐厨生活制品的其他家用纺织制成品生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (286, '178', '非家用纺织制成品制造', '17', 2, '也称产业用纺织制成品制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (287, '1781', '非织造布制造', '178', 3, '指定向或随机排列的纤维,通过摩擦、抱合或粘合,或者这些方法的组合而相互结合制成的片状物、纤网或絮垫的生产活动;所用纤维可以是天然纤维、化学纤维和无机纤维,也可以是短纤维、长丝或直接形成的纤维状物');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (288, '1782', '绳、索、缆制造', '178', 3, '指用天然纤维和化学纤维制造绳、索具、缆绳、合股线的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (289, '1783', '纺织带和帘子布制造', '178', 3, '指帘子布、复合材料用基布、输送带基布、传送带和胶管等增强材料的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (290, '1784', '篷、帆布制造', '178', 3, '指车用篷布、帐篷布、鞋用纺织材料、灯箱布等纺织材料的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (291, '1789', '其他非家用纺织制成品制造', '178', 3, '指革基布,过滤、防护用纺织品,工业用毡、呢,建筑用纺织品,交通运输用纺织品,包装用纺织品,文体用纺织品,绝缘隔热纺织品,农业用纺织品,渔业用纺织品,造纸用纺织品等其他产业用纺织制成品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (292, '18', '纺织服装、服饰业', 'C', 1, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (293, '181', '机织服装制造', '18', 2, '指以机织面料为主要原料,缝制各种男、女服装,以及儿童成衣的活动;包括非自产原料制作的服装,以及固定生产地点的服装制作活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (294, '1811', '运动机织服装制造', '181', 3, '指运动服、滑雪服、登山服、游泳衣等服装制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (295, '1819', '其他机织服装制造', '181', 3, '指除运动机织服装以外的其他机织服装制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (296, '182', '针织或钩针编织服装制造', '18', 2, '指以针织、钩针编织面料为主要原料,经裁剪后缝制各种男、女服装,以及儿童成衣的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (297, '1821', '运动休闲针织服装制造', '182', 3, '指针织 T 恤、针织休闲衫、针织运动类服装制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (298, '1829', '其他针织或钩针编织服装制造', '182', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (299, '183', '服饰制造', '18', 2, '指帽子、手套、围巾、领带、领结、手绢,以及袜子等服装饰品的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (300, '1830', '服饰制造', '183', 3, '指帽子、手套、围巾、领带、领结、手绢,以及袜子等服装饰品的加工');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (301, '19', '皮革、毛皮、羽毛及其制品和制鞋业', 'C', 1, '指除运动休闲针织服装以外其他针织或钩织编织服装制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (302, '191', '皮革鞣制加工', '19', 2, '指动物生皮经脱毛、鞣制等物理和化学方法加工,再经涂饰和整理,制成具有不易腐烂、柔韧、透气等性能的皮革生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (303, '1910', '皮革鞣制加工', '191', 3, '指动物生皮经脱毛、鞣制等物理和化学方法加工,再经涂饰和整理,制成具有不易腐烂、柔韧、透气等性能的皮革生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (304, '192', '皮革制品制造', '19', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (305, '1921', '皮革服装制造', '192', 3, '指全部或大部分用皮革、人造革、合成革为面料,制作各式服装的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (306, '1922', '皮箱、包(袋)制造', '192', 3, '指全部或大部分用皮革、人造革、合成革为材料,或者以塑料、纺织物为材料,制作各种用途的皮箱、皮包(袋),或其他材料的箱、包(袋)等的制作活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (307, '1923', '皮手套及皮装饰制品制造', '192', 3, '指全部或大部分用皮革、人造革、合成革为材料制成的皮手套、皮带,以及皮领带等皮装饰制品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (308, '1929', '其他皮革制品制造', '192', 3, '指全部或大部分用皮革、人造革、合成革为材料制成上述未列明的其他各种皮革制品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (309, '193', '毛皮鞣制及制品加工', '19', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (310, '1931', '毛皮鞣制加工', '193', 3, '指带毛动物生皮经鞣制等化学和物理方法处理后,保持其绒毛形态及特点的毛皮(又称裘皮)的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (311, '1932', '毛皮服装加工', '193', 3, '指用各种动物毛皮和人造毛皮为面料或里料,加工制作毛皮服装的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (312, '1939', '其他毛皮制品加工', '193', 3, '指用各种动物毛皮和人造毛皮为材料,加工制作上述类别未列明的其他各种用途毛皮制品的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (313, '194', '羽毛(绒)加工及制品制造', '19', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (314, '1941', '羽毛(绒)加工', '194', 3, '指对鹅、鸭等禽类羽毛进行加工成标准毛的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (315, '1942', '羽毛(绒)制品加工', '194', 3, '指用加工过的羽毛(绒)作为填充物制作各种用途的羽绒制品(如羽绒服装、羽绒寝具、羽绒睡袋等)的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (316, '195', '制鞋业', '19', 2, '指纺织面料鞋、皮鞋、塑料鞋、橡胶鞋及其他各种鞋的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (317, '1951', '纺织面料鞋制造', '195', 3, '指用各种纺织面料、木材、棕草等原料缝制、模压或编制各种鞋的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (318, '1952', '皮鞋制造', '195', 3, '指全部或大部分用皮革、人造革、合成革为面料,以橡胶、塑料或合成材料等为外底,按缝绱、胶粘、模压、注塑等工艺方法制作各种皮鞋的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (319, '1953', '塑料鞋制造', '195', 3, '指以聚氯乙烯、聚乙烯、聚氨酯和乙烯醋酸乙烯等树脂为原料生产发泡或不发泡的塑料鞋类制品的活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (320, '1954', '橡胶鞋制造', '195', 3, '指以橡胶作为鞋底、鞋帮的橡胶鞋及其橡胶鞋部件的生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (321, '1959', '其他制鞋业', '195', 3, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (322, '20', '木材加工和木、竹、藤、棕、草制品业', 'C', 1, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (323, '201', '木材加工', '20', 2, null);
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (324, '2011', '锯材加工', '201', 3, '指以原木为原料,利用锯木机械或手工工具将原木纵向锯成具有一定断面尺寸(宽、厚度)的木材加工生产活动,用防腐剂和其他物质浸渍木料或对木料进行化学处理的加工,以及地板毛料的制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (325, '2012', '木片加工', '201', 3, '指利用森林采伐、造材、加工等剩余物和定向培育的木材,经削(刨)片机加工成一定规格的产品生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (326, '2013', '单板加工', '201', 3, '指用于单板层积材(LVL)、纺织用木质层压板、电工层压木板和木质层积塑料等单位的生产;随着科技进步,装饰单板(厚度0.55mm以下的单板)发展很快,主要用于装饰贴面二次加工,如生产装饰贴面胶合板、实木复合地板、木质复合门窗、家具、楼梯、汽车内饰、木墙纸和踢脚线等');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (327, '2019', '其他木材加工', '201', 3, '指对木材进行干燥、防腐、改性、染色加工等活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (328, '202', '人造板制造', '20', 2, '指用木材及其剩余物、棉秆、甘蔗渣和芦苇等植物纤维为原料,加工成符合国家标准的胶合板、纤维板、刨花板、细木工板和木丝板等产品的生产活动,以及人造板二次加工装饰板的制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (329, '2021', '胶合板制造', '202', 3, '指具有一定规格的原木经旋(刨)切成单板,再经干燥、涂胶、组坯、热压而成的符合国家标准及供需双方协定标准的产品生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (330, '2022', '纤维板制造', '202', 3, '指用木材碎料(包括木片)、棉秆、甘蔗渣、芦苇等植物纤维作原料,经削片纤维分离,铺装成型,热压而成的产品生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (331, '2023', '刨花板制造', '202', 3, '指用木材碎料(包括木片)和其他植物纤维作原料,制成刨花,经干燥、施胶,铺装成型,热压而成的产品生产活动');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (332, '2029', '其他人造板制造', '202', 3, '包括非木质纤维、胶合木等其他各类人造板的制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)
values (333, '203', '木制品制造', '20', 2, '指以木材为原料加工成建筑用木料和木材组件、木容器、软木制品及其他木制品的生产活动,但不包括木质家具的制造');
insert into dim_industry (ID, INDUSTRY_ID, NAME, PARENT_ID, LEVEL_TYPE, DESCRIPTION)