Subversion Repositories Applications.referentiel

--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

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--

-- Base de données: `referentiels`

--

-- --------------------------------------------------------

--

-- Structure de la table `bdnt`

--

CREATE TABLE IF NOT EXISTS `bdnt` (

  `num_nom` int(9) NOT NULL DEFAULT '0',

  `num_nom_retenu` varchar(9) DEFAULT NULL,

  `num_tax_sup` varchar(9) DEFAULT NULL,

  `rang` int(4) NOT NULL,

  `nom_sci` varchar(500) NOT NULL,

  `nom_supra_generique` varchar(100) DEFAULT NULL,

  `genre` varchar(100) DEFAULT NULL,

  `epithete_infra_generique` varchar(100) DEFAULT NULL,

  `epithete_sp` varchar(100) DEFAULT NULL,

  `type_epithete` varchar(100) DEFAULT NULL,

  `epithete_infra_sp` varchar(100) DEFAULT NULL,

  `cultivar_groupe` varchar(100) DEFAULT NULL,

  `cultivar` varchar(100) DEFAULT NULL,

  `nom_commercial` varchar(100) DEFAULT NULL,

  `auteur` varchar(100) DEFAULT NULL,

  `annee` varchar(4) DEFAULT NULL,

  `biblio_origine` varchar(500) DEFAULT NULL,

  `notes` text,

  `nom_addendum` varchar(500) DEFAULT NULL,

  `homonyme` varchar(1) DEFAULT NULL,

  `num_basionyme` varchar(9) DEFAULT NULL,

  `synonyme_proparte` varchar(100) DEFAULT NULL,

  `synonyme_douteux` varchar(1) DEFAULT NULL,

  `synonyme_mal_applique` varchar(1) DEFAULT NULL,

  `synonyme_orthographique` varchar(9) DEFAULT NULL,

  `hybride_parent_01` varchar(9) DEFAULT NULL,

  `hybride_parent_01_notes` text,

  `hybride_parent_02` varchar(9) DEFAULT NULL,

  `hybride_parent_02_notes` text,

  `nom_francais` varchar(500) DEFAULT NULL,

  `presence` varchar(100) DEFAULT NULL,

  `statut_origine` varchar(100) DEFAULT NULL,

  `statut_introduction` varchar(100) DEFAULT NULL,

  `statut_culture` varchar(100) DEFAULT NULL,

  `presence_Ga` varchar(10) DEFAULT NULL,

  `presence_Co` varchar(10) DEFAULT NULL,

  `exclure_taxref` int(1) DEFAULT NULL,

  `num_taxonomique` int(9) DEFAULT NULL,

  PRIMARY KEY (`num_nom`),

  KEY `nom_complet` (`nom_sci`(333)),

  KEY `nom_francais` (`nom_francais`(333))

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- Contenu de la table `bdnt`

--

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

(1, '71574', '', 290, 'Abacosa dumetorum', '', 'Abacosa', '', 'dumetorum', '', '', '', '', '', '(L.) Alef.', '1861', 'Bonplandia, 9 : 104', '', '', NULL, '71574', '', '', '', '', '74979', '', '77216', '', '', '', '', '', '', '', '', NULL, NULL),

(10, '10', '74929', 320, 'Abies alba subsp. alba', '', 'Abies', '', 'alba', 'subsp.', 'alba', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),

(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),

(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),

(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),

(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),

(129, '128', '', 290, 'Acer grosseri', '', 'Acer', '', 'grosseri', '', '', '', '', '', 'Pax', '1902', 'in Engl. ; Pflanzenreich, IV-163, Aceraceae : 80', '', '', NULL, '129', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(162, '189', '', 290, 'Acer fauriei', '', 'Acer', '', 'fauriei', '', '', '', '', '', 'H.Lév. & Vaniot', '1906', 'Bull. Soc. Bot. France, 53 : 590', '', '', NULL, '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),

(189, '189', '74932', 320, 'Acer negundo subsp. negundo', '', 'Acer', '', 'negundo', 'subsp.', 'negundo', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', 'I', '', 'P', 'P', NULL, NULL),

(365, '365', '85795', 290, 'Achillea millefolium', '', 'Achillea', '', 'millefolium', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 899', '', '', NULL, '365', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(374, '374', '365', 320, 'Achillea millefolium subsp. millefolium', '', 'Achillea', '', 'millefolium', 'subsp.', 'millefolium', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', 'Sourcils-de-Vénus', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(376, '374', '', 320, 'Achillea millefolium subsp. setacea', '', 'Achillea', '', 'millefolium', 'subsp.', 'setacea', '', '', '', 'sensu P.Fourn.', '1939', 'Quatre Fl. Fr., 968', '', '', NULL, '', '', '1', '1', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),

(1150, '1153', '', 290, 'Agrimonia odorata', '', 'Agrimonia', '', 'odorata', '', '', '', '', '', 'sensu auct.', '', '', '', '', NULL, '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),

(1153, '1153', '85823', 290, 'Agrimonia procera', '', 'Agrimonia', '', 'procera', '', '', '', '', '', 'Wallr.', '1840', 'Linnaea, 14 : 573', '', '', NULL, '1153', '', '', '', '', '', '', '', '', 'Aigremoine élevée', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(3073, '3167', '', 290, 'Allium maritimum', '', 'Allium', '', 'maritimum', '', '', '', '', '', 'sensu H.J.Coste', '1905', 'Fl. Fr., 3 : 337, fig. 3447', '', '', NULL, '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),

(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),

(7579, '7579', '74979', 320, 'Asplenium fontanum subsp. fontanum', '', 'Asplenium', '', 'fontanum', 'subsp.', 'fontanum', '', '', '', '', '', '', '', '', NULL, '51777', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', 1, NULL),

(9513, '9513', '85993', 290, 'Beta vulgaris', '', 'Beta', '', 'vulgaris', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 222', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),

(9519, '9519', '9513', 320, 'Beta vulgaris subsp. vulgaris', '', 'Beta', '', 'vulgaris', 'subsp.', 'vulgaris', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', 'Bette-épinard', 'P', '', '', '', 'P', 'P', NULL, NULL),

(9520, '82082', '', 340, 'Beta vulgaris (Altissima Gp)', '', 'Beta', '', 'vulgaris', '', '', 'Altissima', '', '', '', '', '', 'Betterave sucrière', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),

(19287, '71574', '', 290, 'Cracca dumetorum', '', 'Cracca', '', 'dumetorum', '', '', '', '', '', '(L.) Opiz', '1852', 'Seznam, 34', '', '', NULL, '71574', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),

(23603, '23603', '86363', 290, 'Elaeagnus macrophylla', '', 'Elaeagnus', '', 'macrophylla', '', '', '', '', '', 'Thunb.', '1784', 'Fl. Jap., 67', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', '', 'P', '', 1, NULL),

(23604, '23604', '86363', 290, 'Elaeagnus pungens', '', 'Elaeagnus', '', 'pungens', '', '', '', '', '', 'Thunb.', '1784', 'Fl. Jap., 68', '', '', NULL, '', '', '', '', '', '', '', '', '', 'Oléastre épineux', 'P', '', '', '', 'P', '', 1, NULL),

(23605, '23605', '', 290, 'Elaeagnus x submacrophylla ''Ebbingei''', '', 'Elaeagnus', '', 'x submacrophylla', '', '', '', 'Ebbingei', '', '', '', '', '', '', NULL, '', '', '', '', '', '23603', '', '23604', '', '', 'P', '', '', '', 'P', 'P', NULL, NULL),

(51777, '7579', '', 290, 'Polypodium fontanum', '', 'Polypodium', '', 'fontanum', '', '', '', '', '', 'L.', '1753', 'Sp. Pl., éd. 1 : 1089', '', '', NULL, '51777', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, NULL),

(71567, '71574', '', 290, 'Vicia desertorum', '', 'Vicia', '', 'desertorum', '', '', '', '', '', 'Link', '1822', 'Enum. Hort. Berol. Alt., 2 : 238', '(err. orthographe ?)', '', NULL, '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),

(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),

(71576, '71574', '', 290, 'Vicia dumicola', '', 'Vicia', '', 'dumicola', '', '', '', '', '', 'Dulac', '1867', 'Fl. Hautes-Pyr., 288', '', 'nom. illeg. ', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),

(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),

(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),

(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),

(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),

(82082, '82082', '9519', 340, 'Beta vulgaris var. altissima', '', 'Beta', '', 'vulgaris', 'var.', 'altissima', '', '', '', 'Döll', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', '', 'P', '', NULL, NULL),

(83587, '83587', '101012', 220, 'Acer', '', 'Acer', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),

(83705, '83705', '100916', 220, 'Vicia', '', 'Vicia', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(84866, '84866', '100931', 220, 'Allium', '', 'Allium', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', '', 'P', 'P', NULL, NULL),

(85791, '85791', '100946', 220, 'Abies', '', 'Abies', '', '', '', '', '', '', '', 'Hill', '1753', 'in Scott', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(85795, '85795', '100897', 220, 'Achillea', '', 'Achillea', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),

(85823, '85823', '101130', 220, 'Agrimonia', '', 'Agrimonia', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(85945, '85945', '100980', 220, 'Asplenium', '', 'Asplenium', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),

(85993, '85993', '100947', 220, 'Beta', '', 'Beta', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'P', NULL, NULL),

(86363, '86363', '101050', 220, 'Elaeagnus', '', 'Elaeagnus', '', '', '', '', '', '', '', 'L.', '1753', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', 'I', '', 'P', 'P', NULL, NULL),

(100897, '100897', '102760', 180, 'Asteraceae', 'Asteraceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(100916, '100916', '102745', 180, 'Fabaceae', 'Fabaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(100931, '100931', '100964', 180, 'Amaryllidaceae', 'Amaryllidaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(100946, '100946', '102778', 180, 'Pinaceae', 'Pinaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(100947, '100947', '101040', 180, 'Amaranthaceae', 'Amaranthaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(100964, '100964', '101139', 140, 'Asparagales', 'Asparagales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(100980, '100980', '102791', 180, 'Aspleniaceae', 'Aspleniaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(101004, '101004', '101135', 70, 'Dicotyledones Vraies', 'Dicotyledones Vraies', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(101012, '101012', '102750', 180, 'Sapindaceae', 'Sapindaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(101029, '101029', '101004', 70, 'Dicotyledones Vraies Superieures', 'Dicotyledones Vraies Superieures', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(101040, '101040', '101029', 140, 'Caryophyllales', 'Caryophyllales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(101050, '101050', '102741', 180, 'Elaeagnaceae', 'Elaeagnaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(101053, '101053', '101029', 70, 'Rosidees', 'Rosidees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(101061, '101061', '101053', 70, 'Fabidees', 'Fabidees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(101135, '101135', '102768', 70, 'Angiospermes', 'Angiospermes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(101132, '101132', '102768', 70, 'Gymnospermes', 'Gymnospermes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(101139, '101139', '101135', 70, 'Monocotyledones', 'Monocotyledones', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(101140, '101140', '0', 0, 'Chlorobiontes', 'Chlorobiontes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(101130, '101130', '102741', 180, 'Rosaceae', 'Rosaceae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(102735, '102735', '101140', 70, 'Plasmodesmophytes', 'Plasmodesmophytes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(102741, '102741', '101061', 140, 'Rosales', 'Rosales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(102745, '102745', '101061', 140, 'Fabales', 'Fabales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(102750, '102750', '102751', 140, 'Sapindales', 'Sapindales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(102751, '102751', '101053', 70, 'Malvidees', 'Malvidees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9, NULL),

(102752, '102752', '101029', 70, 'Asteridees', 'Asteridees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', '', NULL, NULL),

(102760, '102760', '102761', 140, 'Asterales', 'Asterales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', 'N', 'A', '', 'P', 'A', NULL, NULL),

(102761, '102761', '102752', 70, 'Campanulidees', 'Campanulidees', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'P', '', '', 'C', 'P', 'A', 9, NULL),

(102762, '102762', '102735', 70, 'Embryophytes', 'Embryophytes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'A', '', '', '', 'A', 'A', 1, NULL),

(102768, '102768', '102762', 70, 'Stromatophytes', 'Stromatophytes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', 'A', '', '', '', 'A', 'A', 1, NULL),

(102770, '102770', '101132', 70, 'Pinophytes', 'Pinophytes', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),

(102771, '102771', '101140', 70, 'Polypodiidae', 'Polypodiidae', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),

(102778, '102778', '102770', 140, 'Pinales', 'Pinales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL),

(102791, '102791', '102771', 140, 'Polypodiales', 'Polypodiales', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL);