COMMENT ON TABLE tnrs IS 'tnrs_accepted_names sorts accepted names first (note that false sorts before true). Accepted names are defined as names that scrub to themselves.

Accepted names must be processed before any names that resolve to them, because the entry for the accepted name contains all the ranks parsed out but the resolved name of another entry contains just some ranks and the taxonomic name. Column-based import will do this automatically when the total # of rows is <= the partition_size (because _taxonconcept_set_matched_concept_id()''s accepted taxonconcept is created after the main taxonconcept), but TNRS has more rows than this so sorting is needed to ensure that all the accepted names are processed in the first partitions.';

COMMENT ON TYPE taxonrank IS 'From <http://www.tdwg.org/standards/117/download/>';

-- Name: _taxonconcept_set_matched_concept_id(integer, integer, double precision); Type: FUNCTION; Schema: public; Owner: bien

CREATE FUNCTION _taxonconcept_set_matched_concept_id(taxonconcept_id integer, matched_concept_id integer, matched_concept_fit_fraction double precision DEFAULT NULL::double precision) RETURNS integer

ALTER FUNCTION public._taxonconcept_set_matched_concept_id(taxonconcept_id integer, matched_concept_id integer, matched_concept_fit_fraction double precision) OWNER TO bien;

-- Name: _taxonconcept_set_parent_id(integer, integer); Type: FUNCTION; Schema: public; Owner: bien

--

CREATE FUNCTION _taxonconcept_set_parent_id(taxonconcept_id integer, parent_id integer) RETURNS integer

    LANGUAGE sql

    AS $_$

UPDATE taxonconcept SET parent_id = $2 WHERE taxonconcept_id = $1

RETURNING taxonconcept_id

$_$;

ALTER FUNCTION public._taxonconcept_set_parent_id(taxonconcept_id integer, parent_id integer) OWNER TO bien;

--

    AND place_id != new.place_id -- avoid infinite recursion

        -- Update accepted_concept_id on concepts that resolve to this concept

        UPDATE taxonconcept

        SET accepted_concept_id = new.accepted_concept_id

        WHERE matched_concept_id = new.taxonconcept_id

        AND taxonconcept_id != new.taxonconcept_id -- avoid infinite recursion

        ;

-- Name: taxonconcept_3_parent_id_avoid_self_ref(); Type: FUNCTION; Schema: public; Owner: bien

CREATE FUNCTION taxonconcept_3_parent_id_avoid_self_ref() RETURNS trigger

    new.parent_id = nullif(new.parent_id, new.taxonconcept_id);

    RETURN new;

END;

$$;

ALTER FUNCTION public.taxonconcept_3_parent_id_avoid_self_ref() OWNER TO bien;

SET default_tablespace = '';

SET default_with_oids = false;

--

-- Name: taxonconcept; Type: TABLE; Schema: public; Owner: bien; Tablespace: 

--

CREATE TABLE taxonconcept (

    taxonconcept_id integer NOT NULL,

    creator_id integer NOT NULL,

    sourceaccessioncode text,

    creationdate date,

    accepted_concept_id integer,

    matched_concept_id integer,

    matched_concept_fit_fraction double precision,

    parent_id integer,

    taxonepithet text,

    rank taxonrank,

    verbatimrank text,

    identifyingtaxonomicname text,

    taxonomicname text,

    author text,

    taxonomicnamewithauthor text,

    family text,

    genus text,

    species text,

    description text,

    accessioncode text,

    CONSTRAINT taxonconcept_matched_concept_fit_fraction_range CHECK (((matched_concept_fit_fraction >= (0)::double precision) AND (matched_concept_fit_fraction <= (1)::double precision))),

    CONSTRAINT taxonconcept_required_key CHECK (((((((sourceaccessioncode IS NOT NULL) OR (taxonepithet IS NOT NULL)) OR (identifyingtaxonomicname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR ((parent_id IS NOT NULL) AND ((creationdate IS NOT NULL) OR (author IS NOT NULL)))))

);

ALTER TABLE public.taxonconcept OWNER TO bien;

--

-- Name: TABLE taxonconcept; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON TABLE taxonconcept IS 'A taxon concept defined by an entity. Can be at any level in the taxonomic hierarchy. Can be either verbatim or accepted.

"A taxon (plural: taxa) is a group of one (or more) populations of organism(s), which a taxonomist adjudges to be a unit" (http://en.wikipedia.org/wiki/Taxon)

Note that taxonepithet stores only one rank (e.g. family) of the full taxonomic name. The higher-level ranks are stored in the taxon concept''s chain of parent_id ancestors.

To include a taxon name at a rank with no explicit column, create a parent taxonconcept for it and point to it using parent_id. To include multiple such names, chain the taxonconcepts together using parent_id. Note that lower-level taxa should point to higher-level taxa.

Equivalent to VegBank''s plantConcept and plantName tables, plus plantParent_ID and plantLevel from plantStatus.';

--

-- Name: COLUMN taxonconcept.creator_id; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.creator_id IS 'The entity that created the taxon concept. This is the concept reference for a taxon concept with an "according to", or the identifier''s name for a nominal concept.

Equivalent to "Name sec. x".';

--

-- Name: COLUMN taxonconcept.sourceaccessioncode; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.sourceaccessioncode IS 'The datasource''s identifier for the taxonconcept.';

--

-- Name: COLUMN taxonconcept.creationdate; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.creationdate IS 'The date the taxonconcept was created or defined. For a taxonconcept applied in a taxondetermination, this is the date the determination was made.';

--

-- Name: COLUMN taxonconcept.accepted_concept_id; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.accepted_concept_id IS 'The accepted synonym of the taxonconcept.';

--

-- Name: COLUMN taxonconcept.matched_concept_id; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.matched_concept_id IS 'The taxonconcept containing the closest match to this taxonconcept. taxonconcepts should be linked in a four-level hierarchy of datasource concept -> parsed concept -> matched concept -> accepted concept. A previously-accepted name''s concept should be further linked to the synonym that has replaced it.

To indicate a synonym between taxonconcepts of different sources, choose one taxonconcept to be authoritative and point the other taxonconcept to it using this field.

An accepted name should point to itself in this field. This will happen automatically by setting it to the special value 0.';

--

-- Name: COLUMN taxonconcept.matched_concept_fit_fraction; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.matched_concept_fit_fraction IS 'The closeness of fit of the matched_concept.';

--

-- Name: COLUMN taxonconcept.parent_id; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.parent_id IS 'The parent taxonconcept. Note that while a taxon *name* may have multiple parents, a taxon *concept* has only one, based on the creator''s opinion of where that taxonconcept goes in the taxonomic hierarchy.';

--

-- Name: COLUMN taxonconcept.taxonepithet; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.taxonepithet IS 'The epithet of the taxon within its parent taxon. This is the lowest-rank portion of this taxonconcept''s full taxonomic name, if it has one.

The morphospecies suffix goes in this field.';

--

-- Name: COLUMN taxonconcept.rank; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.rank IS 'The taxonconcept''s level in the taxonomic hierarchy, standardized to a closed list. Even if you specify a custom verbatimrank, you should also specify a closest-match rank from the taxonrank closed list.';

--

-- Name: COLUMN taxonconcept.verbatimrank; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.verbatimrank IS 'The taxonconcept''s verbatim level in the taxonomic hierarchy. Does not need to be in the taxonrank closed list.';

--

-- Name: COLUMN taxonconcept.identifyingtaxonomicname; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.identifyingtaxonomicname IS 'The taxonomic name that uniquely identifies this taxonconcept. If set, the other fields will not be used in duplicate elimination.';

--

-- Name: COLUMN taxonconcept.taxonomicname; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.taxonomicname IS 'The concatenated taxonomic name which uniquely identifies this taxon. Does not include the author of the name.

Equivalent to Darwin Core''s scientificName.';

--

-- Name: COLUMN taxonconcept.author; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.author IS 'The author of the taxonomic name.

Equivalent to Darwin Core''s scientificNameAuthorship.';

--

-- Name: COLUMN taxonconcept.taxonomicnamewithauthor; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.taxonomicnamewithauthor IS 'The concatenated taxonomic name which uniquely identifies this taxon, plus the author of that name.

Equivalent to Darwin Core''s scientificName + scientificNameAuthorship.

Equivalent to "Name sec. x".';

--

-- Name: COLUMN taxonconcept.family; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.family IS 'The family of the taxonomic name. This is a cached field for easy querying; the identifying version of this field is stored in the chain of parent_id ancestors.';

--

-- Name: COLUMN taxonconcept.genus; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.genus IS 'The genus portion of the taxonomic name. This is a cached field for easy querying; the identifying version of this field is stored in the chain of parent_id ancestors.';

--

-- Name: COLUMN taxonconcept.species; Type: COMMENT; Schema: public; Owner: bien

--

COMMENT ON COLUMN taxonconcept.species IS 'The species portion of the taxonomic name. This is a cached field for easy querying; the identifying version of this field is stored in the chain of parent_id ancestors.';

--

-- Name: taxonconcept_update_ancestors(taxonconcept, integer); Type: FUNCTION; Schema: public; Owner: bien

--

CREATE FUNCTION taxonconcept_update_ancestors(new taxonconcept, old_parent_id integer DEFAULT NULL::integer) RETURNS void

    LANGUAGE plpgsql

    AS $$

DECLARE

    -- Use matched_concept_id's ancestors instead if available

    parent_id_ taxonconcept.taxonconcept_id%TYPE := COALESCE(

        NULLIF(new.matched_concept_id, new.taxonconcept_id), new.parent_id);

BEGIN

    IF parent_id_ IS DISTINCT FROM old_parent_id THEN

        DECLARE

            -- These include the parent itself

            old_ancestors integer[] := (

                SELECT array_agg(ancestor_id) FROM taxonconcept_ancestor

                WHERE descendant_id = old_parent_id

            );

            new_ancestors integer[] := (

                SELECT array_agg(ancestor_id) FROM taxonconcept_ancestor

                WHERE descendant_id = parent_id_

            );

            descendant_id_ integer;

        BEGIN

            FOR descendant_id_ IN -- also includes self

                SELECT descendant_id

                FROM taxonconcept_ancestor

                WHERE ancestor_id = new.taxonconcept_id

            LOOP

                -- Delete old parent's ancestors

                DELETE FROM taxonconcept_ancestor

                WHERE descendant_id = descendant_id_

                AND ancestor_id = ANY (old_ancestors)

                ;

                -- Add new parent's ancestors

                INSERT INTO taxonconcept_ancestor

                (descendant_id, ancestor_id)

                SELECT descendant_id_, unnest(new_ancestors)

                ;

            END LOOP;

        END;

    /* Note: We don't need an ON DELETE trigger to update the descendants'

    ancestors when a node is deleted, because the

    taxonconcept_ancestor.ancestor_id foreign key is ON DELETE CASCADE. */

END;

$$;

ALTER FUNCTION public.taxonconcept_update_ancestors(new taxonconcept, old_parent_id integer) OWNER TO bien;

--

-- Name: taxonconcept_update_ancestors_on_insert(); Type: FUNCTION; Schema: public; Owner: bien

--

CREATE FUNCTION taxonconcept_update_ancestors_on_insert() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

BEGIN

    /* Add "ancestor" for this node. This is useful for queries, because you

    don't have to separately test if the leaf node is the one you're looking

    for, in addition to that leaf node's ancestors. */

    (descendant_id, ancestor_id)

    PERFORM taxonconcept_update_ancestors(new);

    RETURN new;

END;

$$;

ALTER FUNCTION public.taxonconcept_update_ancestors_on_insert() OWNER TO bien;

--

-- Name: taxonconcept_update_ancestors_on_update(); Type: FUNCTION; Schema: public; Owner: bien

--

CREATE FUNCTION taxonconcept_update_ancestors_on_update() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

BEGIN

    PERFORM taxonconcept_update_ancestors(new, COALESCE(

        NULLIF(old.matched_concept_id, old.taxonconcept_id), old.parent_id));

ALTER FUNCTION public.taxonconcept_update_ancestors_on_update() OWNER TO bien;

    addressstartdate date

    collectiondate date,

    dateentered date DEFAULT now(),

    determinationdate date,

    obsstartdate date,

    obsenddate date,

    dateentered date DEFAULT now(),

    fullname text,

    CONSTRAINT party_required_key CHECK (((organizationname IS NOT NULL) OR ((creator_id <> party_id) AND ((fullname IS NOT NULL) OR (surname IS NOT NULL)))))

    determinationdate date,

    SELECT datasource.organizationname AS "dataSourceName", accepted_taxonconcept.family, accepted_taxonconcept.genus, accepted_taxonconcept.species, COALESCE(accepted_taxonconcept.taxonomicnamewithauthor, accepted_taxonconcept.taxonomicname) AS taxon, accepted_taxonconcept.author AS "taxonAuthor", accepted_taxonconcept.taxonepithet AS "taxonMorphospecies", placepath.country, placepath.stateprovince AS "stateProvince", placepath.county AS "countyParish", taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS "collectionNumber", array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], ' '::text) AS "identifiedBy", aggregateoccurrence.collectiondate AS "observationDate", location.authorlocationcode AS "plotCode", functions._m2_to_ha(location.area_m2) AS "plotAreaHa", method.name AS "plotMethod", locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS "isCultivated", taxonoccurrence.cultivatedbasis AS "isCultivatedReason", _fraction_to_percent(aggregateoccurrence.cover_fraction) AS "pctCover" FROM ((((((((((((((location JOIN party datasource ON (((datasource.party_id = location.creator_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonconcept datasource_taxonconcept USING (taxonconcept_id)) JOIN taxonconcept accepted_taxonconcept ON ((accepted_taxonconcept.taxonconcept_id = datasource_taxonconcept.accepted_concept_id))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));

    classstartdate date,

    classstopdate date,

    correlationstart date NOT NULL,

    correlationstop date

    dateentered date DEFAULT now()

    startdate date NOT NULL,

    stopdate date,

    usagestart date,

    usagestop date

    graphicdate date,

    contributiondate date

    classstartdate date DEFAULT now() NOT NULL,

    classstopdate date,

    notedate date,

SELECT pg_catalog.setval('party_party_id_seq', 36, true);

    memberstart date DEFAULT now() NOT NULL,

    memberstop date

    startdate date,

    stopdate date,

    d_lastlocationaddeddate date,

    pubdate date,

    accessdate date,

    conferencedate date,

    revisiondate date NOT NULL

    descendant_id integer NOT NULL,

COMMENT ON TABLE taxonconcept_ancestor IS 'Stores the accepted ancestors of a taxonconcept. Auto-populated, so should not be manually modified.';

SELECT pg_catalog.setval('taxonconcept_taxonconcept_id_seq', 786, true);

    correlationstart date NOT NULL,

    correlationstop date

    startdate date,

    stopdate date,

    usagestart date,

    usagestop date

COPY locationevent (locationevent_id, creator_id, sourceaccessioncode, parent_id, location_id, project_id, authoreventcode, previous_id, obsstartdate, obsenddate, dateaccuracy, method_id, temperature_c, precipitation_m, autotaxoncover, originaldata, effortlevel, floristicquality, bryophytequality, lichenquality, locationeventnarrative, landscapenarrative, homogeneity, phenologicaspect, representativeness, standmaturity, successionalstatus, basalarea, hydrologicregime, soilmoistureregime, soildrainage, watersalinity, waterdepth_m, shoredistance, soildepth, organicdepth, soiltaxon_id, soiltaxonsrc, percentbedrock, percentrockgravel, percentwood, percentlitter, percentbaresoil, percentwater, percentother, nameother, treeht, shrubht, fieldht, nonvascularht, submergedht, treecover, shrubcover, fieldcover, nonvascularcover, floatingcover, submergedcover, dominantstratum, growthform1type, growthform2type, growthform3type, growthform1cover, growthform2cover, growthform3cover, totalcover, notespublic, notesmgt, revisions, dateentered, toptaxon1name, toptaxon2name, toptaxon3name, toptaxon4name, toptaxon5name, numberoftaxa, accessioncode) FROM stdin;

COPY party (party_id, creator_id, fullname, salutation, givenname, middlename, surname, organizationname, currentname_id, contactinstructions, email, partytype, partypublic, d_obscount, accessioncode) FROM stdin;

1	1	\N	\N	\N	\N	\N	TNRS	\N	\N	\N	\N	t	\N	\N

2	2	\N	\N	\N	\N	\N	NCBI	\N	\N	\N	\N	t	\N	\N

21	21	\N	\N	\N	\N	\N	test_taxonomic_names	\N	\N	\N	\N	t	\N	\N

COPY taxonconcept (taxonconcept_id, creator_id, sourceaccessioncode, creationdate, accepted_concept_id, matched_concept_id, matched_concept_fit_fraction, parent_id, taxonepithet, rank, verbatimrank, identifyingtaxonomicname, taxonomicname, author, taxonomicnamewithauthor, family, genus, species, description, accessioncode) FROM stdin;

19	2	\N	\N	\N	\N	\N	\N	Poaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N

18	1	http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN	\N	18	18	\N	6	\N	species	species	Poa annua L.	Poa annua	L.	\N	Poaceae	Poa	annua	\N	\N

55	1	\N	\N	\N	\N	\N	6	annua	variety	variety	\N	\N	\N	\N	\N	\N	\N	\N	\N

57	1	http://www.tropicos.org/Name/25517736	\N	57	57	\N	55	\N	variety	variety	Poa annua var. annua	Poa annua var. annua	\N	\N	Poaceae	Poa	annua	\N	\N

84	1	\N	\N	\N	\N	\N	4	infirma	species	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N

96	1	http://www.tropicos.org/Name/25514158;http://plants.usda.gov/java/profile?symbol=POIN30	\N	96	96	\N	84	\N	species	species	Poa infirma Kunth	Poa infirma	Kunth	\N	Poaceae	Poa	infirma	\N	\N

135	1	http://compositae.landcareresearch.co.nz/default.aspx;http://plants.usda.gov/java/nameSearch	\N	135	135	\N	\N	\N	family	family	Asteraceae	Asteraceae	\N	\N	\N	\N	\N	\N	\N

156	1	\N	\N	135	135	1	\N	Bercht. & J. Presl	\N	\N	Asteraceae Bercht. & J. Presl	Asteraceae	\N	\N	Asteraceae	\N	\N	\N	\N

158	1	\N	\N	\N	\N	\N	\N	Compositae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N

175	2	\N	\N	\N	\N	\N	\N	Asteraceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N

177	1	\N	\N	\N	175	\N	\N	Asteraceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N

174	1	http://www.tropicos.org/Name/50255940	\N	135	156	\N	158	\N	family	family	Compositae Giseke	Compositae	Giseke	\N	Compositae	\N	\N	\N	\N

195	1	\N	\N	135	174	1	\N	indet. sp.1	\N	\N	Compositae indet. sp.1	Compositae	\N	\N	Compositae	\N	\N	\N	\N

197	1	\N	\N	\N	\N	\N	\N	Fabaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N

214	2	\N	\N	\N	\N	\N	\N	Fabaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N

213	1	http://www.tropicos.org/Name/42000184	\N	213	213	\N	197	\N	family	family	Fabaceae Lindl.	Fabaceae	Lindl.	\N	Fabaceae	\N	\N	\N	\N

234	1	\N	\N	213	213	1	\N	Boyle#6500	\N	\N	Fabaceae Boyle#6500	Fabaceae	\N	\N	Fabaceae	\N	\N	\N	\N

238	1	\N	\N	\N	\N	\N	197	Inga	genus	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N

252	1	http://www.tropicos.org/Name/40031040	\N	252	252	\N	238	\N	genus	genus	Inga Mill.	Inga	Mill.	\N	Fabaceae	Inga	\N	\N	\N

273	1	\N	\N	252	252	1	\N	"fuzzy leaf"	\N	\N	Fabaceae Inga "fuzzy leaf"	Inga	\N	\N	Fabaceae	Inga	\N	\N	\N

312	1	\N	\N	252	252	1	\N	sp.3	\N	\N	Fabaceae Inga sp.3	Inga	\N	\N	Fabaceae	Inga	\N	\N	\N

351	1	\N	\N	213	213	1	\N	unknown #2	\N	\N	Fabaceae unknown #2	Fabaceae	\N	\N	Fabaceae	\N	\N	\N	\N

390	1	\N	\N	18	18	1	\N	\N	\N	\N	Poa annua	Poa annua	\N	\N	\N	Poa	annua	\N	\N

406	1	\N	\N	\N	\N	\N	6	lanuginosa	forma	forma	\N	\N	\N	\N	\N	\N	\N	\N	\N

408	1	http://www.tropicos.org/Name/50267771	\N	57	57	\N	406	\N	forma	forma	Poa annua fo. lanuginosa Sennen	Poa annua fo. lanuginosa	Sennen	\N	Poaceae	Poa	annua	\N	\N

429	1	\N	\N	57	408	1	\N	\N	\N	fo.	Poa annua fo. lanuginosa	Poa annua fo. lanuginosa	\N	\N	\N	Poa	annua	\N	\N

445	1	\N	\N	\N	\N	\N	6	exilis	subspecies	subspecies	\N	\N	\N	\N	\N	\N	\N	\N	\N

447	1	http://www.tropicos.org/Name/50063800	\N	96	96	\N	445	\N	subspecies	subspecies	Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.	Poa annua subsp. exilis	(Tomm. ex Freyn) Asch. & Graebn.	\N	Poaceae	Poa	annua	\N	\N

468	1	\N	\N	96	447	1	\N	\N	\N	subsp.	Poa annua ssp. exilis	Poa annua subsp. exilis	\N	\N	\N	Poa	annua	\N	\N

507	1	\N	\N	96	447	1	\N	\N	\N	subsp.	Poa annua subsp. exilis	Poa annua subsp. exilis	\N	\N	\N	Poa	annua	\N	\N

523	1	\N	\N	\N	\N	\N	6	minima	subvariety	subvariety	\N	\N	\N	\N	\N	\N	\N	\N	\N

525	1	http://www.tropicos.org/Name/50158097	\N	525	525	\N	523	\N	subvariety	subvariety	Poa annua subvar. minima (Schur) Asch. & Graebn.	Poa annua subvar. minima	(Schur) Asch. & Graebn.	\N	Poaceae	Poa	annua	\N	\N

546	1	\N	\N	525	525	1	\N	\N	\N	subvar.	Poa annua subvar. minima	Poa annua subvar. minima	\N	\N	\N	Poa	annua	\N	\N

562	1	\N	\N	\N	\N	\N	6	eriolepis	variety	variety	\N	\N	\N	\N	\N	\N	\N	\N	\N

564	1	http://www.tropicos.org/Name/50119145	\N	18	18	\N	562	\N	variety	variety	Poa annua var. eriolepis E. Desv.	Poa annua var. eriolepis	E. Desv.	\N	Poaceae	Poa	annua	\N	\N

585	1	\N	\N	18	564	1	\N	\N	\N	var.	Poa annua var. eriolepis	Poa annua var. eriolepis	\N	\N	\N	Poa	annua	\N	\N

587	1	\N	\N	\N	\N	\N	\N	Caryophyllaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N

589	1	\N	\N	\N	\N	\N	587	Silene	genus	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N

591	1	\N	\N	\N	\N	\N	589	scouleri	species	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N

601	1	\N	\N	\N	\N	\N	591	pringlei	subspecies	subspecies	\N	\N	\N	\N	\N	\N	\N	\N	\N

604	2	\N	\N	\N	\N	\N	\N	Caryophyllaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N

603	1	http://www.tropicos.org/Name/6303627	\N	603	603	\N	601	\N	subspecies	subspecies	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	\N	Caryophyllaceae	Silene	scouleri	\N	\N

624	1	\N	\N	603	603	1	\N	var. grisea	\N	subsp.	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei	\N	\N	\N	Silene	scouleri	\N	\N

663	1	\N	\N	603	603	1	\N	var. grisea	\N	subsp.	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei	\N	\N	\N	Silene	scouleri	\N	\N

681	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	No suitable matches found.	No suitable matches found.	\N	\N	\N	\N	\N	\N	\N

702	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	Fam_indet. Boyle#6501	No suitable matches found.	\N	\N	\N	\N	\N	\N	\N

744	21	1	\N	18	390	\N	\N	\N	\N	\N	\N	Poa annua	\N	\N	\N	\N	\N	\N	\N

747	21	2	\N	18	18	\N	\N	\N	\N	\N	\N	Poa annua L.	\N	\N	\N	\N	\N	\N	\N

750	21	3	\N	18	585	\N	\N	\N	\N	\N	\N	Poa annua var. eriolepis	\N	\N	\N	\N	\N	\N	\N

753	21	4	\N	96	507	\N	\N	\N	\N	\N	\N	Poa annua subsp. exilis	\N	\N	\N	\N	\N	\N	\N

756	21	5	\N	96	468	\N	\N	\N	\N	\N	\N	Poa annua ssp. exilis	\N	\N	\N	\N	\N	\N	\N

759	21	6	\N	525	546	\N	\N	\N	\N	\N	\N	Poa annua subvar. minima	\N	\N	\N	\N	\N	\N	\N

762	21	7	\N	57	429	\N	\N	\N	\N	\N	\N	Poa annua fo. lanuginosa	\N	\N	\N	\N	\N	\N	\N

765	21	8	\N	603	663	\N	\N	\N	\N	\N	\N	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	\N	\N	\N	\N	\N	\N	\N

768	21	9	\N	603	624	\N	\N	\N	\N	\N	\N	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	\N	\N	\N	\N	\N	\N	\N

771	21	10	\N	252	312	\N	\N	\N	\N	\N	\N	Fabaceae Inga sp.3	\N	\N	\N	\N	\N	\N	\N

774	21	11	\N	252	273	\N	\N	\N	\N	\N	\N	Fabaceae Inga "fuzzy leaf"	\N	\N	\N	\N	\N	\N	\N

777	21	12	\N	213	351	\N	\N	\N	\N	\N	\N	Fabaceae unknown #2	\N	\N	\N	\N	\N	\N	\N

780	21	13	\N	213	234	\N	\N	\N	\N	\N	\N	Fabaceae Boyle#6500	\N	\N	\N	\N	\N	\N	\N

783	21	14	\N	\N	702	\N	\N	\N	\N	\N	\N	Fam_indet. Boyle#6501	\N	\N	\N	\N	\N	\N	\N

786	21	15	\N	135	195	\N	\N	\N	\N	\N	\N	Compositae indet. sp.1	\N	\N	\N	\N	\N	\N	\N

COPY taxonconcept_ancestor (descendant_id, ancestor_id) FROM stdin;

4	4

6	6

6	4

18	18

18	6

18	4

19	19

55	55

55	6

55	4

55	2

57	57

57	55

57	6

57	4

57	2

84	84

84	4

84	2

96	96

96	84

96	4

96	2

135	135

156	156

156	135

158	158

174	174

175	175

177	177

177	175

174	156

174	135

195	195

195	174

195	156

195	135

197	197

213	213

213	197

214	214

234	234

234	213

234	197

238	238

238	197

252	252

252	238

252	197

273	273

273	252

273	238

273	197

312	312

312	252

312	238

312	197

351	351

351	213

351	197

390	390

390	18

390	6

390	4

390	2

406	406

406	6

406	4

406	2

408	408

408	57

408	55

408	6

408	4

408	2

429	429

429	408

429	57

429	55

429	6

429	4

429	2

445	445

445	6

445	4

445	2

447	447

447	96

447	84

447	4

447	2

468	468

468	447

468	96

468	84

468	4

468	2

507	507

507	447

507	96

507	84

507	4

507	2

523	523

523	6

523	4

523	2

525	525

525	523

525	6

525	4

525	2

546	546

546	525

546	523

546	6

546	4

546	2

562	562

562	6

562	4

562	2

564	564

564	18

564	6

564	4

564	2

585	585

585	564

585	18

585	6

585	4

585	2

587	587

589	589

589	587

591	591

591	589

591	587

601	601

601	591

601	589

601	587

603	603

603	601

603	591

603	589

603	587

604	604

624	624

624	603

624	601

624	591

624	589

624	587

663	663

663	603

663	601

663	591

663	589

663	587

681	681

702	702

744	744

744	390

744	18

744	6

744	4

744	2

747	747

747	18

747	6

747	4

747	2

750	750

750	585

750	564

750	18

750	6

750	4

750	2

753	753

753	507

753	447

753	96

753	84

753	4

753	2

756	756

756	468

756	447

756	96

756	84

756	4

756	2

759	759

759	546

759	525

759	523

759	6

759	4

759	2

762	762

762	429

762	408

762	57

762	55

762	6

762	4

762	2

765	765

765	663

765	603

765	601

765	591

765	589

765	587

768	768

768	624

768	603

768	601

768	591

768	589

768	587

771	771

771	312

771	252

771	238

771	197

774	774

774	273

774	252

774	238

774	197

777	777

777	351

777	213

777	197

780	780

780	234

780	213

780	197

783	783

783	702

786	786

786	195

786	174

786	156

786	135

2	2	57	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

3	2	96	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

4	2	135	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

5	2	174	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

6	2	213	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

7	2	252	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

11	2	408	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

12	2	447	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

14	2	525	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

15	2	564	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

16	2	603	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

18	2	681	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

20	2	744	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

21	2	747	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

22	2	750	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N

23	2	753	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N