Subversion Repositories Applications.referentiel

Rev

Rev 344 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
166 delphine 1
--1,71574,19287,71567,71576,51777,7579,74979,77216,10,11,17,128,127,129,162,189,74932,376,374,365,85795,100897,1150,1153,85823,101130,3073,3167,84866,100931,100964,101139,9520,82082,9519,9513,85993,100947,23605,23603,23604,74929,83587,83705,85791,85945,86363,100916,100946,100980,101004,101012,101029,101040,101050,101053,101061,101132,101135,101140,102735,102741,102745,102750,102751,102752,102760,102761,102762,102768,102770,102771,102778,102791
2
 
3
 
4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
5
 
6
--
7
-- Base de données: `referentiels`
8
--
9
 
10
-- --------------------------------------------------------
11
 
12
--
13
-- Structure de la table `bdnt`
14
--
15
 
16
CREATE TABLE IF NOT EXISTS `bdnt` (
17
  `num_nom` int(9) NOT NULL DEFAULT '0',
18
  `num_nom_retenu` varchar(9) DEFAULT NULL,
19
  `num_tax_sup` varchar(9) DEFAULT NULL,
20
  `rang` int(4) NOT NULL,
21
  `nom_sci` varchar(500) NOT NULL,
22
  `nom_supra_generique` varchar(100) DEFAULT NULL,
23
  `genre` varchar(100) DEFAULT NULL,
24
  `epithete_infra_generique` varchar(100) DEFAULT NULL,
25
  `epithete_sp` varchar(100) DEFAULT NULL,
26
  `type_epithete` varchar(100) DEFAULT NULL,
27
  `epithete_infra_sp` varchar(100) DEFAULT NULL,
28
  `cultivar_groupe` varchar(100) DEFAULT NULL,
29
  `cultivar` varchar(100) DEFAULT NULL,
30
  `nom_commercial` varchar(100) DEFAULT NULL,
31
  `auteur` varchar(100) DEFAULT NULL,
32
  `annee` varchar(4) DEFAULT NULL,
33
  `biblio_origine` varchar(500) DEFAULT NULL,
34
  `notes` text,
35
  `nom_addendum` varchar(500) DEFAULT NULL,
36
  `homonyme` varchar(1) DEFAULT NULL,
372 mathias 37
  `num_basionyme` varchar(9) DEFAULT NULL,
166 delphine 38
  `synonyme_proparte` varchar(100) DEFAULT NULL,
39
  `synonyme_douteux` varchar(1) DEFAULT NULL,
40
  `synonyme_mal_applique` varchar(1) DEFAULT NULL,
41
  `synonyme_orthographique` varchar(9) DEFAULT NULL,
42
  `hybride_parent_01` varchar(9) DEFAULT NULL,
43
  `hybride_parent_01_notes` text,
44
  `hybride_parent_02` varchar(9) DEFAULT NULL,
45
  `hybride_parent_02_notes` text,
46
  `nom_francais` varchar(500) DEFAULT NULL,
47
  `presence` varchar(100) DEFAULT NULL,
48
  `statut_origine` varchar(100) DEFAULT NULL,
49
  `statut_introduction` varchar(100) DEFAULT NULL,
50
  `statut_culture` varchar(100) DEFAULT NULL,
51
  `presence_Ga` varchar(10) DEFAULT NULL,
52
  `presence_Co` varchar(10) DEFAULT NULL,
53
  `exclure_taxref` int(1) DEFAULT NULL,
54
  `num_taxonomique` int(9) DEFAULT NULL,
55
  PRIMARY KEY (`num_nom`),
56
  KEY `nom_complet` (`nom_sci`(333)),
57
  KEY `nom_francais` (`nom_francais`(333))
58
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
59
 
60
--
61
-- Contenu de la table `bdnt`
62
--
63
 
372 mathias 64
INSERT INTO `bdnt` (`num_nom`, `num_nom_retenu`, `num_tax_sup`, `rang`, `nom_sci`, `nom_supra_generique`, `genre`, `epithete_infra_generique`, `epithete_sp`, `type_epithete`, `epithete_infra_sp`, `cultivar_groupe`, `cultivar`, `nom_commercial`, `auteur`, `annee`, `biblio_origine`, `notes`, `nom_addendum`, `homonyme`, `num_basionyme`, `synonyme_proparte`, `synonyme_douteux`, `synonyme_mal_applique`, `synonyme_orthographique`, `hybride_parent_01`, `hybride_parent_01_notes`, `hybride_parent_02`, `hybride_parent_02_notes`, `nom_francais`, `presence`, `statut_origine`, `statut_introduction`, `statut_culture`, `presence_Ga`, `presence_Co`, `exclure_taxref`, `num_taxonomique`) VALUES
166 delphine 65
(1, '71574', '', 290, 'Abacosa dumetorum', '', 'Abacosa', '', 'dumetorum', '', '', '', '', '', '(L.) Alef.', '1861', 'Bonplandia, 9 : 104', '', '', NULL, '71574', '', '', '', '', '74979', '', '77216', '', '', '', '', '', '', '', '', NULL, NULL),
66
(10, '10', '74929', 320, 'Abies alba subsp. alba', '', 'Abies', '', 'alba', 'subsp.', 'alba', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),
67
(11, '17', '', 320, 'Abies alba subsp. cephalonica', '', 'Abies', '', 'alba', 'subsp.', 'cephalonica', '', '', '', '(J.W.Loudon) K.Richt.', '1890', 'Pl. Eur., 1 : 5', '', '', NULL, '17', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
68
(17, '17', '85791', 290, 'Abies cephalonica', '', 'Abies', '', 'cephalonica', '', '', '', '', '', 'J.W.Loudon', '1838', 'Arboret. Frutic. Brit., 4 : 2325', '', '', NULL, '17', '', '', '', '', '', '', '', '', 'Sapin de Céphalonie', 'P', '', '', '', 'P', '', NULL, NULL),
69
(127, '127', '83587', 290, 'Acer davidii', '', 'Acer', '', 'davidii', '', '', '', '', '', 'Franch.', '1885', 'Nouv. Arch. Mus. Hist. Nat., sér. 3, 8 : 212', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', '', 'P', '', 9, NULL),
70
(128, '128', '127', 340, 'Acer davidii var. grosseri', '', 'Acer', '', 'davidii', 'var.', 'grosseri', '', '', '', '(Pax) P.C.DeJong & Oterdoom', '1994', 'in van Gelderen ; Maples of the World, 151', '', '', NULL, '129', '', '', '', '', '', '', '', '', 'Érable de Hers', 'P', '', '', '', 'P', '', 9, NULL),
71
(129, '128', '', 290, 'Acer grosseri', '', 'Acer', '', 'grosseri', '', '', '', '', '', 'Pax', '1902', 'in Engl. ; Pflanzenreich, IV-163, Aceraceae : 80', '', '', NULL, '129', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
72
(162, '189', '', 290, 'Acer fauriei', '', 'Acer', '', 'fauriei', '', '', '', '', '', 'H.Lév. & Vaniot', '1906', 'Bull. Soc. Bot. France, 53 : 590', '', '', NULL, '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
73
(189, '189', '74932', 320, 'Acer negundo subsp. negundo', '', 'Acer', '', 'negundo', 'subsp.', 'negundo', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', 'I', '', 'P', 'P', NULL, NULL),
74
(365, '365', '85795', 290, 'Achillea millefolium', '', 'Achillea', '', 'millefolium', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 899', '', '', NULL, '365', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
75
(374, '374', '365', 320, 'Achillea millefolium subsp. millefolium', '', 'Achillea', '', 'millefolium', 'subsp.', 'millefolium', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', 'Sourcils-de-Vénus', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
76
(376, '374', '', 320, 'Achillea millefolium subsp. setacea', '', 'Achillea', '', 'millefolium', 'subsp.', 'setacea', '', '', '', 'sensu P.Fourn.', '1939', 'Quatre Fl. Fr., 968', '', '', NULL, '', '', '1', '1', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
77
(1150, '1153', '', 290, 'Agrimonia odorata', '', 'Agrimonia', '', 'odorata', '', '', '', '', '', 'sensu auct.', '', '', '', '', NULL, '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
78
(1153, '1153', '85823', 290, 'Agrimonia procera', '', 'Agrimonia', '', 'procera', '', '', '', '', '', 'Wallr.', '1840', 'Linnaea, 14 : 573', '', '', NULL, '1153', '', '', '', '', '', '', '', '', 'Aigremoine élevée', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
79
(3073, '3167', '', 290, 'Allium maritimum', '', 'Allium', '', 'maritimum', '', '', '', '', '', 'sensu H.J.Coste', '1905', 'Fl. Fr., 3 : 337, fig. 3447', '', '', NULL, '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
80
(3167, '3167', '84866', 290, 'Allium roseum', '', 'Allium', '', 'roseum', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 296', '', '', NULL, '3167', '', '', '', '', '', '', '', '', 'Ail rose', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),
81
(7579, '7579', '74979', 320, 'Asplenium fontanum subsp. fontanum', '', 'Asplenium', '', 'fontanum', 'subsp.', 'fontanum', '', '', '', '', '', '', '', '', NULL, '51777', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', 1, NULL),
82
(9513, '9513', '85993', 290, 'Beta vulgaris', '', 'Beta', '', 'vulgaris', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 222', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),
83
(9519, '9519', '9513', 320, 'Beta vulgaris subsp. vulgaris', '', 'Beta', '', 'vulgaris', 'subsp.', 'vulgaris', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', 'Bette-épinard', 'P', '', '', '', 'P', 'P', NULL, NULL),
84
(9520, '82082', '', 340, 'Beta vulgaris (Altissima Gp)', '', 'Beta', '', 'vulgaris', '', '', 'Altissima', '', '', '', '', '', 'Betterave sucrière', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
85
(19287, '71574', '', 290, 'Cracca dumetorum', '', 'Cracca', '', 'dumetorum', '', '', '', '', '', '(L.) Opiz', '1852', 'Seznam, 34', '', '', NULL, '71574', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
86
(23603, '23603', '86363', 290, 'Elaeagnus macrophylla', '', 'Elaeagnus', '', 'macrophylla', '', '', '', '', '', 'Thunb.', '1784', 'Fl. Jap., 67', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', '', 'P', '', 1, NULL),
87
(23604, '23604', '86363', 290, 'Elaeagnus pungens', '', 'Elaeagnus', '', 'pungens', '', '', '', '', '', 'Thunb.', '1784', 'Fl. Jap., 68', '', '', NULL, '', '', '', '', '', '', '', '', '', 'Oléastre épineux', 'P', '', '', '', 'P', '', 1, NULL),
88
(23605, '23605', '', 290, 'Elaeagnus x submacrophylla ''Ebbingei''', '', 'Elaeagnus', '', 'x submacrophylla', '', '', '', 'Ebbingei', '', '', '', '', '', '', NULL, '', '', '', '', '', '23603', '', '23604', '', '', 'P', '', '', '', 'P', 'P', NULL, NULL),
89
(51777, '7579', '', 290, 'Polypodium fontanum', '', 'Polypodium', '', 'fontanum', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 1089', '', '', NULL, '51777', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, NULL),
90
(71567, '71574', '', 290, 'Vicia desertorum', '', 'Vicia', '', 'desertorum', '', '', '', '', '', 'Link', '1822', 'Enum. Hort. Berol. Alt., 2 : 238', '(err. orthographe ?)', '', NULL, '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
91
(71574, '71574', '83705', 290, 'Vicia dumetorum', '', 'Vicia', '', 'dumetorum', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 734', '', '', NULL, '71574', '', '', '', '', '', '', '', '', 'Tremblarète', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
92
(71576, '71574', '', 290, 'Vicia dumicola', '', 'Vicia', '', 'dumicola', '', '', '', '', '', 'Dulac', '1867', 'Fl. Hautes-Pyr., 288', '', 'nom. illeg. ', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
93
(74929, '74929', '85791', 290, 'Abies alba', '', 'Abies', '', 'alba', '', '', '', '', '', 'Mill.', '1768', 'Gard. Dict., éd. 8 : n°1', '', '', NULL, '', '', '', '', '', '', '', '', '', 'Sapin à feuilles d''If', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
94
(74932, '74932', '83587', 290, 'Acer negundo', '', 'Acer', '', 'negundo', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 1056', '', '', NULL, '74932', '', '', '', '', '', '', '', '', 'Érable Négondo', 'P', '', 'I', '', 'P', '', NULL, NULL),
95
(74979, '74979', '85945', 290, 'Asplenium fontanum', '', 'Asplenium', '', 'fontanum', '', '', '', '', '', '(L.) Bernh.', '1799', 'J. Bot. (Schrader), 1799 (1) : 314', '', '', NULL, '51777', '', '', '', '', '', '', '', '', 'Asplénium de Haller', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
96
(77216, '77216', '85945', 290, 'Asplenium majoricum', '', 'Asplenium', '', 'majoricum', '', '', '', '', '', 'Litard.', '1911', 'Bull. Acad. Int. Géogr. Bot., 20 : 28', '', '', NULL, '77216', '', '', '', '', '', '', '', '', '', 'A', '', '', '', 'A', 'A', 1, NULL),
97
(82082, '82082', '9519', 340, 'Beta vulgaris var. altissima', '', 'Beta', '', 'vulgaris', 'var.', 'altissima', '', '', '', 'Döll', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', '', 'P', '', NULL, NULL),
98
(83587, '83587', '101012', 220, 'Acer', '', 'Acer', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),
99
(83705, '83705', '100916', 220, 'Vicia', '', 'Vicia', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
100
(84866, '84866', '100931', 220, 'Allium', '', 'Allium', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', '', 'P', 'P', NULL, NULL),
101
(85791, '85791', '100946', 220, 'Abies', '', 'Abies', '', '', '', '', '', '', '', 'Hill', '1753', 'in Scott', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
102
(85795, '85795', '100897', 220, 'Achillea', '', 'Achillea', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),
103
(85823, '85823', '101130', 220, 'Agrimonia', '', 'Agrimonia', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
104
(85945, '85945', '100980', 220, 'Asplenium', '', 'Asplenium', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),
105
(85993, '85993', '100947', 220, 'Beta', '', 'Beta', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),
106
(86363, '86363', '101050', 220, 'Elaeagnus', '', 'Elaeagnus', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', 'I', '', 'P', 'P', NULL, NULL),
107
(100897, '100897', '102760', 180, 'Asteraceae', 'Asteraceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
108
(100916, '100916', '102745', 180, 'Fabaceae', 'Fabaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
109
(100931, '100931', '100964', 180, 'Amaryllidaceae', 'Amaryllidaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
110
(100946, '100946', '102778', 180, 'Pinaceae', 'Pinaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
111
(100947, '100947', '101040', 180, 'Amaranthaceae', 'Amaranthaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
112
(100964, '100964', '101139', 140, 'Asparagales', 'Asparagales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
113
(100980, '100980', '102791', 180, 'Aspleniaceae', 'Aspleniaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
114
(101004, '101004', '101135', 70, 'Dicotyledones Vraies', 'Dicotyledones Vraies', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
115
(101012, '101012', '102750', 180, 'Sapindaceae', 'Sapindaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
116
(101029, '101029', '101004', 70, 'Dicotyledones Vraies Superieures', 'Dicotyledones Vraies Superieures', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
117
(101040, '101040', '101029', 140, 'Caryophyllales', 'Caryophyllales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
118
(101050, '101050', '102741', 180, 'Elaeagnaceae', 'Elaeagnaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
119
(101053, '101053', '101029', 70, 'Rosidees', 'Rosidees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
120
(101061, '101061', '101053', 70, 'Fabidees', 'Fabidees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
121
(101135, '101135', '102768', 70, 'Angiospermes', 'Angiospermes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
122
(101132, '101132', '102768', 70, 'Gymnospermes', 'Gymnospermes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
123
(101139, '101139', '101135', 70, 'Monocotyledones', 'Monocotyledones', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
124
(101140, '101140', '0', 0, 'Chlorobiontes', 'Chlorobiontes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
125
(101130, '101130', '102741', 180, 'Rosaceae', 'Rosaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
126
(102735, '102735', '101140', 70, 'Plasmodesmophytes', 'Plasmodesmophytes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
127
(102741, '102741', '101061', 140, 'Rosales', 'Rosales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
128
(102745, '102745', '101061', 140, 'Fabales', 'Fabales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
129
(102750, '102750', '102751', 140, 'Sapindales', 'Sapindales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
130
(102751, '102751', '101053', 70, 'Malvidees', 'Malvidees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),
131
(102752, '102752', '101029', 70, 'Asteridees', 'Asteridees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),
132
(102760, '102760', '102761', 140, 'Asterales', 'Asterales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'A', NULL, NULL),
133
(102761, '102761', '102752', 70, 'Campanulidees', 'Campanulidees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', 'C', 'P', 'A', 9, NULL),
134
(102762, '102762', '102735', 70, 'Embryophytes', 'Embryophytes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'A', '', '', '', 'A', 'A', 1, NULL),
135
(102768, '102768', '102762', 70, 'Stromatophytes', 'Stromatophytes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'A', '', '', '', 'A', 'A', 1, NULL),
136
(102770, '102770', '101132', 70, 'Pinophytes', 'Pinophytes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
137
(102771, '102771', '101140', 70, 'Polypodiidae', 'Polypodiidae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
138
(102778, '102778', '102770', 140, 'Pinales', 'Pinales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),
139
(102791, '102791', '102771', 140, 'Polypodiales', 'Polypodiales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL);
140