-- clear derived cols so old values won't be used in calculations

	new."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" = NULL;

	new."[matched_]scientificName[_with_author]__@DwC__@vegpath.org" = NULL;

	new.matched_has_accepted = NULL;

	new."__accepted_{genus,specific_epithet}" = NULL;

	new."[accepted_]genus__@DwC__@vegpath.org" = NULL;

	new."[accepted_]specificEpithet__@DwC__@vegpath.org" = NULL;

	new.__accepted_infraspecific_label = NULL;

	new."__accepted_infraspecific_{rank,epithet}" = NULL;

	new."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = NULL;

	new."[accepted_]infraspecificEpithet__@DwC__@vegpath.org" = NULL;

	new."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" = NULL;

	new."[scrubbed_]taxonRank__@DwC__@vegpath.org" = NULL;

	new."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" = NULL;

	new."[scrubbed_]genus__@DwC__@vegpath.org" = NULL;

	new."[scrubbed_]specificEpithet__@DwC__@vegpath.org" = NULL;

	new."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" = NULL;

	new."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = NULL;

	new."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" = NULL;

	new."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" = NULL;

	new."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" = NULL;

	new."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" = NULL;

	new."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" = NULL;

	new."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = NULL;

	-- populate derived cols

	new."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT ("*Genus_matched" || ' '::text) || "*Specific_epithet_matched" FROM (SELECT new.*) new);

	new."[matched_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT "*Name_matched" || COALESCE((' '::text || "*Name_matched_author"), ''::text) FROM (SELECT new.*) new);

	new.matched_has_accepted = (SELECT "*Accepted_name" IS NOT NULL FROM (SELECT new.*) new);

	new."__accepted_{genus,specific_epithet}" = (SELECT regexp_split_to_array("*Accepted_name_species", ' '::text) FROM (SELECT new.*) new);

	new."[accepted_]genus__@DwC__@vegpath.org" = (SELECT "__accepted_{genus,specific_epithet}"[1] FROM (SELECT new.*) new);

	new."[accepted_]specificEpithet__@DwC__@vegpath.org" = (SELECT "__accepted_{genus,specific_epithet}"[2] FROM (SELECT new.*) new);

	new.__accepted_infraspecific_label = (SELECT ltrim(NULLIF(util.remove_prefix("*Accepted_name_species", "*Accepted_name", require := true), ''::text), ' '::text) FROM (SELECT new.*) new);

	new."__accepted_infraspecific_{rank,epithet}" = (SELECT regexp_split_to_array(__accepted_infraspecific_label, ' '::text) FROM (SELECT new.*) new);

	new."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = (SELECT "__accepted_infraspecific_{rank,epithet}"[1] FROM (SELECT new.*) new);

	new."[accepted_]infraspecificEpithet__@DwC__@vegpath.org" = (SELECT "__accepted_infraspecific_{rank,epithet}"[2] FROM (SELECT new.*) new);

	new."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT "*Accepted_name" || COALESCE((' '::text || "*Accepted_name_author"), ''::text) FROM (SELECT new.*) new);

	new."[scrubbed_]taxonRank__@DwC__@vegpath.org" = (SELECT CASE

    WHEN matched_has_accepted THEN "*Accepted_name_rank"

    ELSE "*Name_matched_rank"

END FROM (SELECT new.*) new);

	new."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT CASE

    WHEN matched_has_accepted THEN "*Accepted_name_family"

    ELSE "*Name_matched_accepted_family"

END FROM (SELECT new.*) new);

	new."[scrubbed_]genus__@DwC__@vegpath.org" = (SELECT CASE

    WHEN matched_has_accepted THEN "[accepted_]genus__@DwC__@vegpath.org"

    ELSE "*Genus_matched"

END FROM (SELECT new.*) new);

	new."[scrubbed_]specificEpithet__@DwC__@vegpath.org" = (SELECT CASE

    WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"

    ELSE "*Specific_epithet_matched"

END FROM (SELECT new.*) new);

	new."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT CASE

    WHEN matched_has_accepted THEN "*Accepted_name_species"

    ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org"

END FROM (SELECT new.*) new);

	new."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = (SELECT CASE

    WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"

    ELSE "*Infraspecific_rank"

END FROM (SELECT new.*) new);

	new."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" = (SELECT CASE

    WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"

    ELSE "*Infraspecific_epithet_matched"

END FROM (SELECT new.*) new);

	new."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT CASE

    WHEN matched_has_accepted THEN "*Accepted_name"

    ELSE "*Name_matched"

END FROM (SELECT new.*) new);

	new."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT CASE

    WHEN matched_has_accepted THEN "*Accepted_name_author"

    ELSE "*Name_matched_author"

END FROM (SELECT new.*) new);

	new."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT CASE

    WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org"

    ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org"

END FROM (SELECT new.*) new);

	new."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" = (SELECT "*Unmatched_terms" FROM (SELECT new.*) new);

	new."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = (SELECT CASE

    WHEN ("*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")

    WHEN ("*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")

    ELSE "*Accepted_name_species"

END FROM (SELECT new.*) new);

    "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" text,

    "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" text,

    "[scrubbed_]taxonRank__@DwC__@vegpath.org" text,

    "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" text,

    "[scrubbed_]genus__@DwC__@vegpath.org" text,

    "[scrubbed_]specificEpithet__@DwC__@vegpath.org" text,

    "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" text,

    "[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" text,

    "[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" text,

    "[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" text,

    "[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" text,

    "[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" text,

    CONSTRAINT "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" CHECK ((NOT ("[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS DISTINCT FROM

CASE

    WHEN ("*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")

    WHEN ("*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")

    ELSE "*Accepted_name_species"

END))),

    CONSTRAINT "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" CHECK ((NOT ("[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" IS DISTINCT FROM "*Unmatched_terms"))),

    CONSTRAINT "[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS DISTINCT FROM

CASE

    WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"

    ELSE "*Infraspecific_rank"

END))),

    CONSTRAINT "[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM

CASE

    WHEN matched_has_accepted THEN "*Accepted_name_author"

    ELSE "*Name_matched_author"

END))),

    CONSTRAINT "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM

CASE

    WHEN matched_has_accepted THEN "*Accepted_name_family"

    ELSE "*Name_matched_accepted_family"

END))),

    CONSTRAINT "[scrubbed_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]genus__@DwC__@vegpath.org" IS DISTINCT FROM

CASE

    WHEN matched_has_accepted THEN "[accepted_]genus__@DwC__@vegpath.org"

    ELSE "*Genus_matched"

END))),

    CONSTRAINT "[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM

CASE

    WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"

    ELSE "*Infraspecific_epithet_matched"

END))),

    CONSTRAINT "[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM

CASE

    WHEN matched_has_accepted THEN "*Accepted_name"

    ELSE "*Name_matched"

END))),

    CONSTRAINT "[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" IS DISTINCT FROM

CASE

    WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org"

    ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org"

END))),

    CONSTRAINT "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM

CASE

    WHEN matched_has_accepted THEN "*Accepted_name_species"

    ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org"

END))),

    CONSTRAINT "[scrubbed_]specificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]specificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM

CASE

    WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"

    ELSE "*Specific_epithet_matched"

END))),

    CONSTRAINT "[scrubbed_]taxonRank__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]taxonRank__@DwC__@vegpath.org" IS DISTINCT FROM

CASE

    WHEN matched_has_accepted THEN "*Accepted_name_rank"

    ELSE "*Name_matched_rank"

END))),

-- Name: COLUMN taxon_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON COLUMN taxon_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" IS '

= "*Unmatched_terms"

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org'')::util.col, $$"*Unmatched_terms"$$)::util.derived_col_def);

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

# rename column

# rename CHECK constraint

SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);

';

--

= ("*Genus_matched" || '' ''::text) || "*Specific_epithet_matched"

derived column

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$("*Genus_matched" || '' ''::text) || "*Specific_epithet_matched"$$)::util.derived_col_def);

= "*Name_matched" || COALESCE(('' ''::text || "*Name_matched_author"), ''''::text)

derived column

= "*Accepted_name" IS NOT NULL

derived column

= regexp_split_to_array("*Accepted_name_species", '' ''::text)

derived column

= "__accepted_{genus,specific_epithet}"[1]

derived column

= "__accepted_{genus,specific_epithet}"[2]

derived column

-- Name: COLUMN taxon_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON COLUMN taxon_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS '

= CASE

    WHEN ("*Accepted_name_rank" = ''family''::text) THEN concat_ws('' ''::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")

    WHEN ("*Accepted_name_rank" = ''genus''::text) THEN concat_ws('' ''::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")

    ELSE "*Accepted_name_species"

END

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col, $$CASE

    WHEN ("*Accepted_name_rank" = ''family''::text) THEN concat_ws('' ''::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")

    WHEN ("*Accepted_name_rank" = ''genus''::text) THEN concat_ws('' ''::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")

    ELSE "*Accepted_name_species"

END$$)::util.derived_col_def);

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

# rename column

# rename CHECK constraint

SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);

';

--

= ltrim(NULLIF(util.remove_prefix("*Accepted_name_species", "*Accepted_name", require := true), ''''::text), '' ''::text)

derived column

= regexp_split_to_array(__accepted_infraspecific_label, '' ''::text)

derived column

= "__accepted_infraspecific_{rank,epithet}"[1]

derived column

= "__accepted_infraspecific_{rank,epithet}"[2]

derived column

= "*Accepted_name" || COALESCE(('' ''::text || "*Accepted_name_author"), ''''::text)

derived column

-- Name: COLUMN taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON COLUMN taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org" IS '

= CASE

    WHEN matched_has_accepted THEN "*Accepted_name_rank"

    ELSE "*Name_matched_rank"

END

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]taxonRank__@DwC__@vegpath.org'')::util.col, $$CASE

    WHEN matched_has_accepted THEN "*Accepted_name_rank"

    ELSE "*Name_matched_rank"

END$$)::util.derived_col_def);

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

# rename column

# rename CHECK constraint

SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);

';

--

-- Name: COLUMN taxon_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON COLUMN taxon_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" IS '

= CASE

    WHEN matched_has_accepted THEN "*Accepted_name_family"

    ELSE "*Name_matched_accepted_family"

END

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE

    WHEN matched_has_accepted THEN "*Accepted_name_family"

    ELSE "*Name_matched_accepted_family"

END$$)::util.derived_col_def);

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

# rename column

# rename CHECK constraint

SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);

';

--

-- Name: COLUMN taxon_match."[scrubbed_]genus__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON COLUMN taxon_match."[scrubbed_]genus__@DwC__@vegpath.org" IS '

= CASE

    WHEN matched_has_accepted THEN "[accepted_]genus__@DwC__@vegpath.org"

    ELSE "*Genus_matched"

END

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]genus__@DwC__@vegpath.org'')::util.col, $$CASE

    WHEN matched_has_accepted THEN "[accepted_]genus__@DwC__@vegpath.org"

    ELSE "*Genus_matched"

END$$)::util.derived_col_def);

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

# rename column

# rename CHECK constraint

SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);

';

--

-- Name: COLUMN taxon_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON COLUMN taxon_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org" IS '

= CASE

    WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"

    ELSE "*Specific_epithet_matched"

END

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]specificEpithet__@DwC__@vegpath.org'')::util.col, $$CASE

    WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"

    ELSE "*Specific_epithet_matched"

END$$)::util.derived_col_def);

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

# rename column

# rename CHECK constraint

SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);

';

--

-- Name: COLUMN taxon_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON COLUMN taxon_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" IS '

= CASE

    WHEN matched_has_accepted THEN "*Accepted_name_species"

    ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org"

END

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE

    WHEN matched_has_accepted THEN "*Accepted_name_species"

    ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org"

END$$)::util.derived_col_def);

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

# rename column

# rename CHECK constraint

SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);

';

--

-- Name: COLUMN taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON COLUMN taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS '

= CASE

    WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"

    ELSE "*Infraspecific_rank"

END

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org'')::util.col, $$CASE

    WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"

    ELSE "*Infraspecific_rank"

END$$)::util.derived_col_def);

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

# rename column

# rename CHECK constraint

SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);

';

--

-- Name: COLUMN taxon_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON COLUMN taxon_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" IS '

= CASE

    WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"

    ELSE "*Infraspecific_epithet_matched"

END

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org'')::util.col, $$CASE

    WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"

    ELSE "*Infraspecific_epithet_matched"

END$$)::util.derived_col_def);

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

# rename column

# rename CHECK constraint

SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);

';

--

-- Name: COLUMN taxon_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON COLUMN taxon_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" IS '

= CASE

    WHEN matched_has_accepted THEN "*Accepted_name"

    ELSE "*Name_matched"

END

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE

    WHEN matched_has_accepted THEN "*Accepted_name"

    ELSE "*Name_matched"

END$$)::util.derived_col_def);

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

# rename column

# rename CHECK constraint

SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);

';

--

-- Name: COLUMN taxon_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON COLUMN taxon_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" IS '

= CASE

    WHEN matched_has_accepted THEN "*Accepted_name_author"

    ELSE "*Name_matched_author"

END

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE

    WHEN matched_has_accepted THEN "*Accepted_name_author"

    ELSE "*Name_matched_author"

END$$)::util.derived_col_def);

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

# rename column

# rename CHECK constraint

SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);

';

--

-- Name: COLUMN taxon_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON COLUMN taxon_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" IS '

= CASE

    WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org"

    ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org"

END

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org'')::util.col, $$CASE

    WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org"

    ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org"

END$$)::util.derived_col_def);

SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);

to rename:

# rename column

# rename CHECK constraint

SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);

';

--

    taxon_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",

    taxon_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",

    taxon_match.matched_has_accepted,

    taxon_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",

    taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org",

    taxon_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",

    taxon_match."[scrubbed_]genus__@DwC__@vegpath.org",

    taxon_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org",

    taxon_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",

    taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",

    taxon_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",

    taxon_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",

    taxon_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org",

    taxon_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org"

    taxon_best_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",

    taxon_best_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",

    taxon_best_match.matched_has_accepted,

    taxon_best_match."[scrubbed_]taxonRank__@DwC__@vegpath.org",

    taxon_best_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",

    taxon_best_match."[scrubbed_]genus__@DwC__@vegpath.org",

    taxon_best_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org",

    taxon_best_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",

    taxon_best_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",

    taxon_best_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",

    taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",

    taxon_best_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org",

    taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org",

    "MatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",

    "MatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",

    "MatchedTaxon".matched_has_accepted,

    "MatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org",

    "MatchedTaxon"."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",

    "MatchedTaxon"."[scrubbed_]genus__@DwC__@vegpath.org",

    "MatchedTaxon"."[scrubbed_]specificEpithet__@DwC__@vegpath.org",

    "MatchedTaxon"."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",

    "MatchedTaxon"."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",

    "MatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",

    "MatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",

    "MatchedTaxon"."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org",

    "MatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org",

    "ValidMatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",

    "ValidMatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",

    "ValidMatchedTaxon".matched_has_accepted,

    "ValidMatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org",

    "ValidMatchedTaxon"."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",

    "ValidMatchedTaxon"."[scrubbed_]genus__@DwC__@vegpath.org",

    "ValidMatchedTaxon"."[scrubbed_]specificEpithet__@DwC__@vegpath.org",

    "ValidMatchedTaxon"."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",

    "ValidMatchedTaxon"."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",

    "ValidMatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",

    "ValidMatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",

    "ValidMatchedTaxon"."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org",

    "ValidMatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org",

2014-07-22 03:05:20.316489-07	2014-07-22 03:05:20.316489-07	2014-07-22 03:05:20.316489-07	\N

COPY taxon_match (batch, match_num, "*Name_number", "*Name_submitted", "*Overall_score", "*Name_matched", "*Name_matched_rank", "*Name_score", "*Name_matched_author", "*Name_matched_url", "*Author_matched", "*Author_score", "*Family_matched", "*Family_score", "*Name_matched_accepted_family", "*Genus_matched", "*Genus_score", "*Specific_epithet_matched", "*Specific_epithet_score", "*Infraspecific_rank", "*Infraspecific_epithet_matched", "*Infraspecific_epithet_score", "*Infraspecific_rank_2", "*Infraspecific_epithet_2_matched", "*Infraspecific_epithet_2_score", "*Annotations", "*Unmatched_terms", "*Taxonomic_status", "*Accepted_name", "*Accepted_name_author", "*Accepted_name_rank", "*Accepted_name_url", "*Accepted_name_species", "*Accepted_name_family", "*Selected", "*Source", "*Warnings", "*Accepted_name_lsid", is_valid_match, scrubbed_unique_taxon_name, "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org", "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", "[matched_]scientificName[_with_author]__@DwC__@vegpath.org", matched_has_accepted, "__accepted_{genus,specific_epithet}", "[accepted_]genus__@DwC__@vegpath.org", "[accepted_]specificEpithet__@DwC__@vegpath.org", "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org", __accepted_infraspecific_label, "__accepted_infraspecific_{rank,epithet}", "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", "[accepted_]infraspecificEpithet__@DwC__@vegpath.org", "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org", "[scrubbed_]taxonRank__@DwC__@vegpath.org", "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[scrubbed_]genus__@DwC__@vegpath.org", "[scrubbed_]specificEpithet__@DwC__@vegpath.org", "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org", "[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", "[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", "[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", "[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", "[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org") FROM stdin;

2014-07-22 03:05:20.316489-07	0	0	Compositae indet. sp.1	0.900000000000000022	Compositae	family	1	\N	http://www.theplantlist.org/1.1/browse/A/Compositae/	\N	\N	Compositae	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	indet. sp.1	Accepted	Compositae	\N	family	http://www.theplantlist.org/1.1/browse/A/Compositae/	\N	\N	true	tpl	 [Ambiguous match] 	\N	t	Compositae	indet. sp.1	\N	Compositae	t	\N	\N	\N	indet. sp.1	\N	\N	\N	\N	Compositae	family	\N	\N	\N	\N	\N	\N	Compositae	\N	Compositae

2014-07-22 03:05:20.316489-07	1	0	Compositae indet. sp.1	0.900000000000000022	Compositae	family	1	\N	\N	\N	\N	Compositae	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	indet. sp.1	Accepted	Compositae	\N	family	\N	\N	\N	false	tpl	 [Ambiguous match] 	\N	t	Compositae	indet. sp.1	\N	Compositae	t	\N	\N	\N	indet. sp.1	\N	\N	\N	\N	Compositae	family	\N	\N	\N	\N	\N	\N	Compositae	\N	Compositae

2014-07-22 03:05:20.316489-07	2	0	Compositae indet. sp.1	0.900000000000000022	Compositae	family	1	Giseke	http://www.tropicos.org/Name/50255940	\N	\N	Compositae	1	Compositae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	indet. sp.1	Synonym	Asteraceae	Bercht. & J. Presl	family	http://www.tropicos.org/Name/50307371	\N	Asteraceae	false	tropicos	 	\N	t	Asteraceae Bercht. & J. Presl	indet. sp.1	\N	Compositae Giseke	t	\N	\N	\N	Asteraceae indet. sp.1	\N	\N	\N	\N	Asteraceae Bercht. & J. Presl	family	Asteraceae	\N	\N	\N	\N	\N	Asteraceae	Bercht. & J. Presl	Asteraceae Bercht. & J. Presl

2014-07-22 03:05:20.316489-07	3	1	Fabaceae Boyle#6500	0.839999999999999969	Fagaceae	family	0.939999999999999947	\N	;http://plants.usda.gov/java/nameSearch	\N	\N	Fagaceae	0.880000000000000004	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Boyle#6500	Accepted	Fagaceae	\N	family	;http://plants.usda.gov/java/nameSearch	\N	\N	true	tpl;usda	 	\N	f	Fagaceae	Boyle#6500	\N	Fagaceae	t	\N	\N	\N	Boyle#6500	\N	\N	\N	\N	Fagaceae	family	\N	\N	\N	\N	\N	\N	Fagaceae	\N	Fagaceae

2014-07-22 03:05:20.316489-07	4	1	Fabaceae Boyle#6500	0.900000000000000022	Fabaceae	family	1	Lindl.	http://www.tropicos.org/Name/42000184	\N	\N	Fabaceae	1	Fabaceae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Boyle#6500	Accepted	Fabaceae	Lindl.	family	http://www.tropicos.org/Name/42000184	\N	Fabaceae	false	tropicos	 	\N	t	Fabaceae Lindl.	Boyle#6500	\N	Fabaceae Lindl.	t	\N	\N	\N	Fabaceae Boyle#6500	\N	\N	\N	\N	Fabaceae Lindl.	family	Fabaceae	\N	\N	\N	\N	\N	Fabaceae	Lindl.	Fabaceae Lindl.

2014-07-22 03:05:20.316489-07	5	1	Fabaceae Boyle#6500	0.839999999999999969	Fagaceae	family	0.939999999999999947	Dumort.	http://www.tropicos.org/Name/42000062	\N	\N	Fagaceae	0.880000000000000004	Fagaceae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Boyle#6500	Accepted	Fagaceae	Dumort.	family	http://www.tropicos.org/Name/42000062	\N	Fagaceae	false	tropicos	 	\N	f	Fagaceae Dumort.	Boyle#6500	\N	Fagaceae Dumort.	t	\N	\N	\N	Fagaceae Boyle#6500	\N	\N	\N	\N	Fagaceae Dumort.	family	Fagaceae	\N	\N	\N	\N	\N	Fagaceae	Dumort.	Fagaceae Dumort.

2014-07-22 03:05:20.316489-07	6	1	Fabaceae Boyle#6500	0.67000000000000004	Ficaceae	family	0.770000000000000018	Bercht. & J. Presl	http://www.tropicos.org/Name/100353631	\N	\N	Ficaceae	0.75	Ficaceae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Boyle#6500	No opinion	\N	\N	\N	\N	\N	\N	false	tropicos	 	\N	f	Ficaceae Bercht. & J. Presl	Boyle#6500	\N	Ficaceae Bercht. & J. Presl	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	family	Ficaceae	\N	\N	\N	\N	\N	Ficaceae	Bercht. & J. Presl	Ficaceae Bercht. & J. Presl

2014-07-22 03:05:20.316489-07	7	1	Fabaceae Boyle#6500	0.67000000000000004	Fucaceae	family	0.770000000000000018	\N	http://www.tropicos.org/Name/100371040	\N	\N	Fucaceae	0.75	Fucaceae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Boyle#6500	No opinion	\N	\N	\N	\N	\N	\N	false	tropicos	 	\N	f	Fucaceae	Boyle#6500	\N	Fucaceae	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	family	Fucaceae	\N	\N	\N	\N	\N	Fucaceae	\N	Fucaceae

2014-07-22 03:05:20.316489-07	8	1	Fabaceae Boyle#6500	0.900000000000000022	Fabaceae	family	1	\N	http://plants.usda.gov/java/nameSearch	\N	\N	Fabaceae	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Boyle#6500	Accepted	Fabaceae	\N	family	http://plants.usda.gov/java/nameSearch	\N	\N	false	usda	 	\N	t	Fabaceae	Boyle#6500	\N	Fabaceae	t	\N	\N	\N	Boyle#6500	\N	\N	\N	\N	Fabaceae	family	\N	\N	\N	\N	\N	\N	Fabaceae	\N	Fabaceae

2014-07-22 03:05:20.316489-07	9	2	Fabaceae Inga "fuzzy leaf"	0.900000000000000022	Inga	genus	1	\N	http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA	\N	\N	Fabaceae	1	Fabaceae	Inga	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	"fuzzy leaf"	Accepted	Inga	\N	genus	http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA	\N	Fabaceae	true	tpl;usda	 	\N	t	Fabaceae Inga	"fuzzy leaf"	\N	Inga	t	\N	\N	\N	Inga "fuzzy leaf"	\N	\N	\N	\N	Inga	genus	Fabaceae	\N	\N	\N	\N	\N	Inga	\N	Inga

2014-07-22 03:05:20.316489-07	10	2	Fabaceae Inga "fuzzy leaf"	0.900000000000000022	Inga	genus	1	Mill.	http://www.tropicos.org/Name/40031040	\N	\N	Fabaceae	1	Fabaceae	Inga	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	"fuzzy leaf"	Accepted	Inga	Mill.	genus	http://www.tropicos.org/Name/40031040	\N	Fabaceae	false	tropicos	 	\N	t	Fabaceae Inga Mill.	"fuzzy leaf"	\N	Inga Mill.	t	\N	\N	\N	Inga "fuzzy leaf"	\N	\N	\N	\N	Inga Mill.	genus	Fabaceae	\N	\N	\N	\N	\N	Inga	Mill.	Inga Mill.

2014-07-22 03:05:20.316489-07	11	2	Fabaceae Inga "fuzzy leaf"	0.900000000000000022	Inga	genus	1	Scop.	http://www.tropicos.org/Name/50215121	\N	\N	Fabaceae	1	Fabaceae	Inga	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	"fuzzy leaf"	Illegitimate	\N	\N	\N	\N	\N	\N	false	tropicos	 	\N	t	Fabaceae Inga Scop.	"fuzzy leaf"	\N	Inga Scop.	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	genus	Fabaceae	Inga	\N	\N	\N	\N	Inga	Scop.	Inga Scop.

2014-07-22 03:05:20.316489-07	12	3	Fabaceae Inga sp.3	0.900000000000000022	Inga	genus	1	\N	http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA	\N	\N	Fabaceae	1	Fabaceae	Inga	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	sp.3	Accepted	Inga	\N	genus	http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA	\N	Fabaceae	true	tpl;usda	 	\N	t	Fabaceae Inga	sp.3	\N	Inga	t	\N	\N	\N	Inga sp.3	\N	\N	\N	\N	Inga	genus	Fabaceae	\N	\N	\N	\N	\N	Inga	\N	Inga

2014-07-22 03:05:20.316489-07	13	3	Fabaceae Inga sp.3	0.900000000000000022	Inga	genus	1	Mill.	http://www.tropicos.org/Name/40031040	\N	\N	Fabaceae	1	Fabaceae	Inga	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	sp.3	Accepted	Inga	Mill.	genus	http://www.tropicos.org/Name/40031040	\N	Fabaceae	false	tropicos	 	\N	t	Fabaceae Inga Mill.	sp.3	\N	Inga Mill.	t	\N	\N	\N	Inga sp.3	\N	\N	\N	\N	Inga Mill.	genus	Fabaceae	\N	\N	\N	\N	\N	Inga	Mill.	Inga Mill.

2014-07-22 03:05:20.316489-07	14	3	Fabaceae Inga sp.3	0.900000000000000022	Inga	genus	1	Scop.	http://www.tropicos.org/Name/50215121	\N	\N	Fabaceae	1	Fabaceae	Inga	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	sp.3	Illegitimate	\N	\N	\N	\N	\N	\N	false	tropicos	 	\N	t	Fabaceae Inga Scop.	sp.3	\N	Inga Scop.	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	genus	Fabaceae	Inga	\N	\N	\N	\N	Inga	Scop.	Inga Scop.

2014-07-22 03:05:20.316489-07	15	4	Fabaceae unknown #2	0.839999999999999969	Fagaceae	family	0.939999999999999947	\N	;http://plants.usda.gov/java/nameSearch	\N	\N	Fagaceae	0.880000000000000004	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	unknown #2	Accepted	Fagaceae	\N	family	;http://plants.usda.gov/java/nameSearch	\N	\N	true	tpl;usda	 	\N	f	Fagaceae	unknown #2	\N	Fagaceae	t	\N	\N	\N	unknown #2	\N	\N	\N	\N	Fagaceae	family	\N	\N	\N	\N	\N	\N	Fagaceae	\N	Fagaceae

2014-07-22 03:05:20.316489-07	16	4	Fabaceae unknown #2	0.900000000000000022	Fabaceae	family	1	Lindl.	http://www.tropicos.org/Name/42000184	\N	\N	Fabaceae	1	Fabaceae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	unknown #2	Accepted	Fabaceae	Lindl.	family	http://www.tropicos.org/Name/42000184	\N	Fabaceae	false	tropicos	 	\N	t	Fabaceae Lindl.	unknown #2	\N	Fabaceae Lindl.	t	\N	\N	\N	Fabaceae unknown #2	\N	\N	\N	\N	Fabaceae Lindl.	family	Fabaceae	\N	\N	\N	\N	\N	Fabaceae	Lindl.	Fabaceae Lindl.

2014-07-22 03:05:20.316489-07	17	4	Fabaceae unknown #2	0.839999999999999969	Fagaceae	family	0.939999999999999947	Dumort.	http://www.tropicos.org/Name/42000062	\N	\N	Fagaceae	0.880000000000000004	Fagaceae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	unknown #2	Accepted	Fagaceae	Dumort.	family	http://www.tropicos.org/Name/42000062	\N	Fagaceae	false	tropicos	 	\N	f	Fagaceae Dumort.	unknown #2	\N	Fagaceae Dumort.	t	\N	\N	\N	Fagaceae unknown #2	\N	\N	\N	\N	Fagaceae Dumort.	family	Fagaceae	\N	\N	\N	\N	\N	Fagaceae	Dumort.	Fagaceae Dumort.

2014-07-22 03:05:20.316489-07	18	4	Fabaceae unknown #2	0.67000000000000004	Ficaceae	family	0.770000000000000018	Bercht. & J. Presl	http://www.tropicos.org/Name/100353631	\N	\N	Ficaceae	0.75	Ficaceae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	unknown #2	No opinion	\N	\N	\N	\N	\N	\N	false	tropicos	 	\N	f	Ficaceae Bercht. & J. Presl	unknown #2	\N	Ficaceae Bercht. & J. Presl	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	family	Ficaceae	\N	\N	\N	\N	\N	Ficaceae	Bercht. & J. Presl	Ficaceae Bercht. & J. Presl

2014-07-22 03:05:20.316489-07	19	4	Fabaceae unknown #2	0.67000000000000004	Fucaceae	family	0.770000000000000018	\N	http://www.tropicos.org/Name/100371040	\N	\N	Fucaceae	0.75	Fucaceae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	unknown #2	No opinion	\N	\N	\N	\N	\N	\N	false	tropicos	 	\N	f	Fucaceae	unknown #2	\N	Fucaceae	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	family	Fucaceae	\N	\N	\N	\N	\N	Fucaceae	\N	Fucaceae

2014-07-22 03:05:20.316489-07	20	4	Fabaceae unknown #2	0.900000000000000022	Fabaceae	family	1	\N	http://plants.usda.gov/java/nameSearch	\N	\N	Fabaceae	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	unknown #2	Accepted	Fabaceae	\N	family	http://plants.usda.gov/java/nameSearch	\N	\N	false	usda	 	\N	t	Fabaceae	unknown #2	\N	Fabaceae	t	\N	\N	\N	unknown #2	\N	\N	\N	\N	Fabaceae	family	\N	\N	\N	\N	\N	\N	Fabaceae	\N	Fabaceae

2014-07-22 03:05:20.316489-07	21	5	Fam_indet. Boyle#6501	0	No suitable matches found.	\N	0	\N	\N	\N	0	\N	0	\N	\N	0	\N	0	\N	\N	0	\N	\N	0	\N	\N	\N	\N	\N	\N	\N	\N	\N	true	\N	 	\N	f	\N	\N	\N	No suitable matches found.	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	No suitable matches found.	\N	No suitable matches found.

2014-07-22 03:05:20.316489-07	22	6	Poa annua	1	Poa annua	species	1	L.	http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN	\N	\N	\N	\N	Poaceae	Poa	1	annua	1	\N	\N	\N	\N	\N	\N	\N	\N	Accepted	Poa annua	L.	species	http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN	Poa annua	Poaceae	true	tpl;tropicos;usda	 	\N	t	Poaceae Poa annua L.	\N	Poa annua	Poa annua L.	t	{Poa,annua}	Poa	annua	Poa annua	\N	\N	\N	\N	Poa annua L.	species	Poaceae	Poa	annua	Poa annua	\N	annua	Poa annua	L.	Poa annua L.

2014-07-22 03:05:20.316489-07	23	6	Poa annua	1	Poa annua	species	1	Cham. & Schltdl.	http://www.theplantlist.org/tpl1.1/record/kew-435195	\N	\N	\N	\N	Poaceae	Poa	1	annua	1	\N	\N	\N	\N	\N	\N	\N	\N	Synonym	Poa infirma	Kunth	species	http://www.theplantlist.org/tpl1.1/record/kew-436189	Poa infirma	Poaceae	false	tpl	 	\N	t	Poaceae Poa infirma Kunth	\N	Poa annua	Poa annua Cham. & Schltdl.	t	{Poa,infirma}	Poa	infirma	Poa infirma	\N	\N	\N	\N	Poa infirma Kunth	species	Poaceae	Poa	infirma	Poa infirma	\N	infirma	Poa infirma	Kunth	Poa infirma Kunth

2014-07-22 03:05:20.316489-07	24	7	Poa annua L.	1	Poa annua	species	1	L.	http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN	L.	1	\N	\N	Poaceae	Poa	1	annua	1	\N	\N	\N	\N	\N	\N	\N	\N	Accepted	Poa annua	L.	species	http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN	Poa annua	Poaceae	true	tpl;tropicos;usda	 	\N	t	Poaceae Poa annua L.	\N	Poa annua	Poa annua L.	t	{Poa,annua}	Poa	annua	Poa annua	\N	\N	\N	\N	Poa annua L.	species	Poaceae	Poa	annua	Poa annua	\N	annua	Poa annua	L.	Poa annua L.

2014-07-22 03:05:20.316489-07	25	7	Poa annua L.	0.800000000000000044	Poa annua	species	1	Cham. & Schltdl.	http://www.theplantlist.org/tpl1.1/record/kew-435195	Cham. & Schltdl.	0	\N	\N	Poaceae	Poa	1	annua	1	\N	\N	\N	\N	\N	\N	\N	\N	Synonym	Poa infirma	Kunth	species	http://www.theplantlist.org/tpl1.1/record/kew-436189	Poa infirma	Poaceae	false	tpl	 	\N	t	Poaceae Poa infirma Kunth	\N	Poa annua	Poa annua Cham. & Schltdl.	t	{Poa,infirma}	Poa	infirma	Poa infirma	\N	\N	\N	\N	Poa infirma Kunth	species	Poaceae	Poa	infirma	Poa infirma	\N	infirma	Poa infirma	Kunth	Poa infirma Kunth

2014-07-22 03:05:20.316489-07	26	8	Poa annua fo. lanuginosa	1	Poa annua fo. lanuginosa	fo.	1	Sennen	http://www.theplantlist.org/tpl1.1/record/tro-50267771	\N	\N	\N	\N	\N	Poa	1	annua	1	fo.	lanuginosa	1	\N	\N	\N	\N	\N	Synonym	Poa annua	L.	species	http://www.theplantlist.org/tpl1.1/record/kew-435194	Poa annua	Poaceae	true	tpl	 	\N	t	Poaceae Poa annua L.	\N	Poa annua	Poa annua fo. lanuginosa Sennen	t	{Poa,annua}	Poa	annua	Poa annua	\N	\N	\N	\N	Poa annua L.	species	Poaceae	Poa	annua	Poa annua	\N	annua	Poa annua	L.	Poa annua L.

2014-07-22 03:05:20.316489-07	27	8	Poa annua fo. lanuginosa	1	Poa annua fo. lanuginosa	forma	1	Sennen	http://www.tropicos.org/Name/50267771	\N	\N	\N	\N	Poaceae	Poa	1	annua	1	fo.	lanuginosa	1	\N	\N	\N	\N	\N	Synonym	Poa annua var. annua	\N	variety	http://www.tropicos.org/Name/25517736	Poa annua	Poaceae	false	tropicos	 	\N	t	Poaceae Poa annua var. annua	\N	Poa annua	Poa annua fo. lanuginosa Sennen	t	{Poa,annua}	Poa	annua	Poa annua	var. annua	{var.,annua}	var.	annua	Poa annua var. annua	variety	Poaceae	Poa	annua	Poa annua	var.	annua	Poa annua var. annua	\N	Poa annua var. annua

2014-07-22 03:05:20.316489-07	28	9	Poa annua ssp. exilis	1	Poa annua subsp. exilis	subspecies	1	(Tomm. ex Freyn) Asch. & Graebn.	http://www.tropicos.org/Name/50063800	\N	\N	\N	\N	Poaceae	Poa	1	annua	1	subsp.	exilis	1	\N	\N	\N	\N	\N	Synonym	Poa infirma	Kunth	species	http://www.tropicos.org/Name/25514158	Poa infirma	Poaceae	true	tropicos	 	\N	t	Poaceae Poa infirma Kunth	\N	Poa annua	Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.	t	{Poa,infirma}	Poa	infirma	Poa infirma	\N	\N	\N	\N	Poa infirma Kunth	species	Poaceae	Poa	infirma	Poa infirma	\N	infirma	Poa infirma	Kunth	Poa infirma Kunth

2014-07-22 03:05:20.316489-07	29	9	Poa annua ssp. exilis	0.959999999999999964	Poa annua var. exilis	variety	0.959999999999999964	Tomm. ex Freyn	http://www.tropicos.org/Name/25547854	\N	\N	\N	\N	Poaceae	Poa	1	annua	1	var.	exilis	0.699999999999999956	\N	\N	\N	\N	\N	Synonym	Poa infirma	Kunth	species	http://www.tropicos.org/Name/25514158	Poa infirma	Poaceae	false	tropicos	 	\N	t	Poaceae Poa infirma Kunth	\N	Poa annua	Poa annua var. exilis Tomm. ex Freyn	t	{Poa,infirma}	Poa	infirma	Poa infirma	\N	\N	\N	\N	Poa infirma Kunth	species	Poaceae	Poa	infirma	Poa infirma	\N	infirma	Poa infirma	Kunth	Poa infirma Kunth

2014-07-22 03:05:20.316489-07	30	10	Poa annua subsp. exilis	1	Poa annua subsp. exilis	subsp.	1	(Tomm. ex Freyn.) Asch. & Graebn.	http://www.theplantlist.org/tpl1.1/record/kew-435202	\N	\N	\N	\N	\N	Poa	1	annua	1	subsp.	exilis	1	\N	\N	\N	\N	\N	Synonym	Poa infirma	Kunth	species	http://www.theplantlist.org/tpl1.1/record/kew-436189	Poa infirma	Poaceae	true	tpl	 	\N	t	Poaceae Poa infirma Kunth	\N	Poa annua	Poa annua subsp. exilis (Tomm. ex Freyn.) Asch. & Graebn.	t	{Poa,infirma}	Poa	infirma	Poa infirma	\N	\N	\N	\N	Poa infirma Kunth	species	Poaceae	Poa	infirma	Poa infirma	\N	infirma	Poa infirma	Kunth	Poa infirma Kunth

2014-07-22 03:05:20.316489-07	31	10	Poa annua subsp. exilis	1	Poa annua subsp. exilis	subspecies	1	(Tomm. ex Freyn) Asch. & Graebn.	http://www.tropicos.org/Name/50063800	\N	\N	\N	\N	Poaceae	Poa	1	annua	1	subsp.	exilis	1	\N	\N	\N	\N	\N	Synonym	Poa infirma	Kunth	species	http://www.tropicos.org/Name/25514158	Poa infirma	Poaceae	false	tropicos	 	\N	t	Poaceae Poa infirma Kunth	\N	Poa annua	Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.	t	{Poa,infirma}	Poa	infirma	Poa infirma	\N	\N	\N	\N	Poa infirma Kunth	species	Poaceae	Poa	infirma	Poa infirma	\N	infirma	Poa infirma	Kunth	Poa infirma Kunth

2014-07-22 03:05:20.316489-07	32	11	Poa annua subvar. minima	1	Poa annua subvar. minima	subvariety	1	(Schur) Asch. & Graebn.	http://www.tropicos.org/Name/50158097	\N	\N	\N	\N	Poaceae	Poa	1	annua	1	subvar.	minima	1	\N	\N	\N	\N	\N	Accepted	Poa annua subvar. minima	(Schur) Asch. & Graebn.	subvariety	http://www.tropicos.org/Name/50158097	Poa annua	Poaceae	true	tropicos	 	\N	t	Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.	\N	Poa annua	Poa annua subvar. minima (Schur) Asch. & Graebn.	t	{Poa,annua}	Poa	annua	Poa annua	subvar. minima	{subvar.,minima}	subvar.	minima	Poa annua subvar. minima (Schur) Asch. & Graebn.	subvariety	Poaceae	Poa	annua	Poa annua	subvar.	annua	Poa annua subvar. minima	(Schur) Asch. & Graebn.	Poa annua subvar. minima (Schur) Asch. & Graebn.

2014-07-22 03:05:20.316489-07	33	12	Poa annua var. eriolepis	1	Poa annua var. eriolepis	var.	1	̉ۡ.Desv.	http://www.theplantlist.org/tpl1.1/record/kew-435206	\N	\N	\N	\N	\N	Poa	1	annua	1	var.	eriolepis	1	\N	\N	\N	\N	\N	Synonym	Poa annua	L.	species	http://www.theplantlist.org/tpl1.1/record/kew-435194	Poa annua	Poaceae	true	tpl	 	\N	t	Poaceae Poa annua L.	\N	Poa annua	Poa annua var. eriolepis ̉ۡ.Desv.	t	{Poa,annua}	Poa	annua	Poa annua	\N	\N	\N	\N	Poa annua L.	species	Poaceae	Poa	annua	Poa annua	\N	annua	Poa annua	L.	Poa annua L.

2014-07-22 03:05:20.316489-07	34	12	Poa annua var. eriolepis	1	Poa annua var. eriolepis	variety	1	E. Desv.	http://www.tropicos.org/Name/50119145	\N	\N	\N	\N	Poaceae	Poa	1	annua	1	var.	eriolepis	1	\N	\N	\N	\N	\N	Synonym	Poa annua	L.	species	http://www.tropicos.org/Name/25509881	Poa annua	Poaceae	false	tropicos	 	\N	t	Poaceae Poa annua L.	\N	Poa annua	Poa annua var. eriolepis E. Desv.	t	{Poa,annua}	Poa	annua	Poa annua	\N	\N	\N	\N	Poa annua L.	species	Poaceae	Poa	annua	Poa annua	\N	annua	Poa annua	L.	Poa annua L.

2014-07-22 03:05:20.316489-07	35	13	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	0.770000000000000018	Silene scouleri subsp. pringlei	subsp.	0.770000000000000018	(S. Watson) C.L. Hitchc. & Maguire	http://www.theplantlist.org/tpl1.1/record/tro-6303627	\N	\N	\N	\N	Caryophyllaceae	Silene	1	scouleri	1	subsp.	pringlei	1	\N	\N	\N	\N	var. grisea	Accepted	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	subsp.	http://www.theplantlist.org/tpl1.1/record/tro-6303627	Silene scouleri	Caryophyllaceae	true	tpl	 [Partial match] 	\N	t	Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	var. grisea	Silene scouleri	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	t	{Silene,scouleri}	Silene	scouleri	Silene scouleri	subsp. pringlei	{subsp.,pringlei}	subsp.	pringlei	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	subsp.	Caryophyllaceae	Silene	scouleri	Silene scouleri	subsp.	scouleri	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire

2014-07-22 03:05:20.316489-07	36	13	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	0.770000000000000018	Silene scouleri subsp. pringlei	subspecies	0.770000000000000018	(S. Watson) C.L. Hitchc. & Maguire	http://www.tropicos.org/Name/6303627	\N	\N	\N	\N	Caryophyllaceae	Silene	1	scouleri	1	subsp.	pringlei	1	\N	\N	\N	\N	var. grisea	Accepted	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	subspecies	http://www.tropicos.org/Name/6303627	Silene scouleri	Caryophyllaceae	false	tropicos	 [Partial match] 	\N	t	Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	var. grisea	Silene scouleri	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	t	{Silene,scouleri}	Silene	scouleri	Silene scouleri	subsp. pringlei	{subsp.,pringlei}	subsp.	pringlei	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	subspecies	Caryophyllaceae	Silene	scouleri	Silene scouleri	subsp.	scouleri	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire

2014-07-22 03:05:20.316489-07	37	13	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	0.770000000000000018	Silene scouleri subsp. pringlei	subspecies	0.770000000000000018	(S. Watson) C.L. Hitchc. & Maguire	http://plants.usda.gov/java/profile?symbol=SISCP	\N	\N	\N	\N	Caryophyllaceae	Silene	1	scouleri	1	subsp.	pringlei	1	\N	\N	\N	\N	var. grisea	Accepted	Silene scouleri ssp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	subspecies	http://plants.usda.gov/java/profile?symbol=SISCP	Silene scouleri	Caryophyllaceae	false	usda	 [Partial match] 	\N	t	Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire	var. grisea	Silene scouleri	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	t	{Silene,scouleri}	Silene	scouleri	Silene scouleri	ssp. pringlei	{ssp.,pringlei}	ssp.	pringlei	Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire	subspecies	Caryophyllaceae	Silene	scouleri	Silene scouleri	ssp.	scouleri	Silene scouleri ssp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire

2014-07-22 03:05:20.316489-07	38	14	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	0.770000000000000018	Silene scouleri subsp. pringlei	subsp.	0.770000000000000018	(S. Watson) C.L. Hitchc. & Maguire	http://www.theplantlist.org/tpl1.1/record/tro-6303627	\N	\N	\N	\N	Caryophyllaceae	Silene	1	scouleri	1	subsp.	pringlei	1	\N	\N	\N	\N	var. grisea	Accepted	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	subsp.	http://www.theplantlist.org/tpl1.1/record/tro-6303627	Silene scouleri	Caryophyllaceae	true	tpl	 [Partial match] 	\N	t	Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	var. grisea	Silene scouleri	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	t	{Silene,scouleri}	Silene	scouleri	Silene scouleri	subsp. pringlei	{subsp.,pringlei}	subsp.	pringlei	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	subsp.	Caryophyllaceae	Silene	scouleri	Silene scouleri	subsp.	scouleri	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire

2014-07-22 03:05:20.316489-07	39	14	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	0.770000000000000018	Silene scouleri subsp. pringlei	subspecies	0.770000000000000018	(S. Watson) C.L. Hitchc. & Maguire	http://www.tropicos.org/Name/6303627	\N	\N	\N	\N	Caryophyllaceae	Silene	1	scouleri	1	subsp.	pringlei	1	\N	\N	\N	\N	var. grisea	Accepted	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	subspecies	http://www.tropicos.org/Name/6303627	Silene scouleri	Caryophyllaceae	false	tropicos	 [Partial match] 	\N	t	Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	var. grisea	Silene scouleri	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	t	{Silene,scouleri}	Silene	scouleri	Silene scouleri	subsp. pringlei	{subsp.,pringlei}	subsp.	pringlei	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	subspecies	Caryophyllaceae	Silene	scouleri	Silene scouleri	subsp.	scouleri	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire

2014-07-22 03:05:20.316489-07	40	14	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	0.770000000000000018	Silene scouleri subsp. pringlei	subspecies	0.770000000000000018	(S. Watson) C.L. Hitchc. & Maguire	http://plants.usda.gov/java/profile?symbol=SISCP	\N	\N	\N	\N	Caryophyllaceae	Silene	1	scouleri	1	subsp.	pringlei	1	\N	\N	\N	\N	var. grisea	Accepted	Silene scouleri ssp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	subspecies	http://plants.usda.gov/java/profile?symbol=SISCP	Silene scouleri	Caryophyllaceae	false	usda	 [Partial match] 	\N	t	Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire	var. grisea	Silene scouleri	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	t	{Silene,scouleri}	Silene	scouleri	Silene scouleri	ssp. pringlei	{ssp.,pringlei}	ssp.	pringlei	Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire	subspecies	Caryophyllaceae	Silene	scouleri	Silene scouleri	ssp.	scouleri	Silene scouleri ssp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire

COMMENT ON SCHEMA "public.test_taxonomic_names" IS 'Version: public (2014-7-22 3:05:28 PDT)';

SELECT util.copy('analytical_stem_view'::regclass, 'analytical_stem');

SELECT util.copy('geoscrub_input_view'::regclass, 'geoscrub_input');

SELECT util.copy('provider_count_view'::regclass, 'provider_count');

SELECT util.copy('taxon_trait_view'::regclass, 'taxon_trait');

COPY analytical_stem ("datasource__@Brad__.identifier_examples@vegpath.org", "country__@DwC__@vegpath.org", "stateProvince__@DwC__@vegpath.org", "county__@DwC__@vegpath.org", "locality__@DwC__@vegpath.org", "decimalLatitude__@DwC__@vegpath.org", "decimalLongitude__@DwC__@vegpath.org", "coordinateUncertaintyInMeters__@DwC__@vegpath.org", "georeferenceSources__@DwC__@vegpath.org", "georeferenceProtocol__@DwC__@vegpath.org", geovalid_bien, "isNewWorld_bien", "projectID__@VegX__.plotObservation@vegpath.org", "projectContributor[s]__@VegBank__@vegpath.org", "locationID__@DwC__@vegpath.org", "plotName__@VegX__.plot@vegpath.org", "subplot__@SALVIAS__.Plot_data@vegpath.org", location__cultivated__bien, "locationevent.locationevent_id__@VegBIEN__.public@vegpath.org", "eventDate__@DwC__@vegpath.org", "(-minimum-)ElevationInMeters__@DwC__@vegpath.org", "slopeAspect[_deg]__@VegX__.plot@vegpath.org", "slopeGradient[_deg]__@VegX__.plot@vegpath.org", "plot.area[_ha]__@VegX__@vegpath.org", "samplingProtocol__@DwC__@vegpath.org", "temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org", "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org", "stratumName__@VegX__.stratum@vegpath.org", "communityConcept.name__@VegX__.communityDet@vegpath.org", "observationContributor[s]__@VegBank__@vegpath.org", "[custodial_]institutionCode[s]__@DwC__@vegpath.org", "collectionCode__@DwC__@vegpath.org", "catalogNumber__@DwC__@vegpath.org", "occurrenceID__@DwC__@vegpath.org", "recordedBy__@DwC__@vegpath.org", "recordNumber__@DwC__@vegpath.org", "(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org", "[verbatim_]family__@DwC__@vegpath.org", "[verbatim_]scientificName__@DwC__@vegpath.org", "identifiedBy__@DwC__@vegpath.org", "dateIdentified__@DwC__@vegpath.org", "identificationRemarks__@DwC__@vegpath.org", "Family_matched__@TNRS__@vegpath.org", "Name_matched__@TNRS__@vegpath.org", "Name_matched_author__@TNRS__@vegpath.org", "[higher_plant_group~]higherClassification__@DwC__@vegpath.org", "taxonomicStatus__@DwC__@vegpath.org", scrubbed_family, scrubbed_genus, scrubbed_specific_epithet, scrubbed_species_binomial, scrubbed_taxon_name_no_author, scrubbed_author, scrubbed_taxon_name_with_author, "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org", "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org", "reproductiveCondition__@DwC__@vegpath.org", cultivated_bien, "cultivatedBasis_bien", "occurrenceRemarks__@DwC__@vegpath.org", "coverPercent__@VegX__.attribute.ordinal@vegpath.org", "stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org", "stemHeight[_m]__@VegBank__.stemCount@vegpath.org", "[tag=]identificationLabel__@VegX__.individual@vegpath.org", "relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org", "relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org", "taxonObservation[.id]__@VegBank__@vegpath.org", "taxonNameUsageConcept.authorCode__@VegX__@vegpath.org", "aggregateOrganismObservation.id__@VegX__@vegpath.org", "individualOrganismObservation.id__@VegX__@vegpath.org", "individualID__@DwC__@vegpath.org", "individualCount__@DwC__@vegpath.org", "stemCode__@VegBank__.stemLocation@vegpath.org", "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org") FROM stdin;

1	\N	\N	TNRS	\N	aggregator	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	http://[TNRS_dev_server].iplantcollaborative.org/TNRSapp.html	\N	\N	\N	\N	\N	2014-07-22	\N	2014-07-22	\N	\N

2	\N	\N	test_taxonomic_names	\N	personal communication	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2014-07-22	\N	2014-07-22	\N	\N

INSERT INTO batch VALUES ('2014-07-22 03:05:20.316489-07', '2014-07-22 03:05:20.316489-07', '2014-07-22 03:05:20.316489-07', NULL);

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 0, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Compositae/', NULL, NULL, 'Compositae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Accepted', 'Compositae', NULL, 'family', 'http://www.theplantlist.org/1.1/browse/A/Compositae/', NULL, NULL, 'true', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae', 'indet. sp.1', NULL, 'Compositae', true, NULL, NULL, NULL, 'indet. sp.1', NULL, NULL, NULL, NULL, 'Compositae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', NULL, 'Compositae');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 1, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, NULL, NULL, NULL, NULL, 'Compositae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Accepted', 'Compositae', NULL, 'family', NULL, NULL, NULL, 'false', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae', 'indet. sp.1', NULL, 'Compositae', true, NULL, NULL, NULL, 'indet. sp.1', NULL, NULL, NULL, NULL, 'Compositae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', NULL, 'Compositae');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 2, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, 'Giseke', 'http://www.tropicos.org/Name/50255940', NULL, NULL, 'Compositae', 1, 'Compositae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Synonym', 'Asteraceae', 'Bercht. & J. Presl', 'family', 'http://www.tropicos.org/Name/50307371', NULL, 'Asteraceae', 'false', 'tropicos', ' ', NULL, true, 'Asteraceae Bercht. & J. Presl', 'indet. sp.1', NULL, 'Compositae Giseke', true, NULL, NULL, NULL, 'Asteraceae indet. sp.1', NULL, NULL, NULL, NULL, 'Asteraceae Bercht. & J. Presl', 'family', 'Asteraceae', NULL, NULL, NULL, NULL, NULL, 'Asteraceae', 'Bercht. & J. Presl', 'Asteraceae Bercht. & J. Presl');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 3, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', 'Boyle#6500', NULL, 'Fagaceae', true, NULL, NULL, NULL, 'Boyle#6500', NULL, NULL, NULL, NULL, 'Fagaceae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', NULL, 'Fagaceae');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 4, 1, 'Fabaceae Boyle#6500', 0.900000000000000022, 'Fabaceae', 'family', 1, 'Lindl.', 'http://www.tropicos.org/Name/42000184', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fabaceae', 'Lindl.', 'family', 'http://www.tropicos.org/Name/42000184', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', 'Boyle#6500', NULL, 'Fabaceae Lindl.', true, NULL, NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'family', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 5, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', 'Boyle#6500', NULL, 'Fagaceae Dumort.', true, NULL, NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'family', 'Fagaceae', NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 6, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Ficaceae', 'family', 0.770000000000000018, 'Bercht. & J. Presl', 'http://www.tropicos.org/Name/100353631', NULL, NULL, 'Ficaceae', 0.75, 'Ficaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Ficaceae Bercht. & J. Presl', 'Boyle#6500', NULL, 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Ficaceae', NULL, NULL, NULL, NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 7, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', 'Boyle#6500', NULL, 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Fucaceae', NULL, NULL, NULL, NULL, NULL, 'Fucaceae', NULL, 'Fucaceae');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 8, 1, 'Fabaceae Boyle#6500', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', 'Boyle#6500', NULL, 'Fabaceae', true, NULL, NULL, NULL, 'Boyle#6500', NULL, NULL, NULL, NULL, 'Fabaceae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', NULL, 'Fabaceae');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 9, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Accepted', 'Inga', NULL, 'genus', 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, 'Fabaceae', 'true', 'tpl;usda', ' ', NULL, true, 'Fabaceae Inga', '"fuzzy leaf"', NULL, 'Inga', true, NULL, NULL, NULL, 'Inga "fuzzy leaf"', NULL, NULL, NULL, NULL, 'Inga', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', NULL, 'Inga');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 10, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', '"fuzzy leaf"', NULL, 'Inga Mill.', true, NULL, NULL, NULL, 'Inga "fuzzy leaf"', NULL, NULL, NULL, NULL, 'Inga Mill.', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 11, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', '"fuzzy leaf"', NULL, 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'genus', 'Fabaceae', 'Inga', NULL, NULL, NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 12, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Accepted', 'Inga', NULL, 'genus', 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, 'Fabaceae', 'true', 'tpl;usda', ' ', NULL, true, 'Fabaceae Inga', 'sp.3', NULL, 'Inga', true, NULL, NULL, NULL, 'Inga sp.3', NULL, NULL, NULL, NULL, 'Inga', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', NULL, 'Inga');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 13, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', 'sp.3', NULL, 'Inga Mill.', true, NULL, NULL, NULL, 'Inga sp.3', NULL, NULL, NULL, NULL, 'Inga Mill.', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 14, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', 'sp.3', NULL, 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'genus', 'Fabaceae', 'Inga', NULL, NULL, NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 15, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', 'unknown #2', NULL, 'Fagaceae', true, NULL, NULL, NULL, 'unknown #2', NULL, NULL, NULL, NULL, 'Fagaceae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', NULL, 'Fagaceae');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 16, 4, 'Fabaceae unknown #2', 0.900000000000000022, 'Fabaceae', 'family', 1, 'Lindl.', 'http://www.tropicos.org/Name/42000184', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fabaceae', 'Lindl.', 'family', 'http://www.tropicos.org/Name/42000184', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', 'unknown #2', NULL, 'Fabaceae Lindl.', true, NULL, NULL, NULL, 'Fabaceae unknown #2', NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'family', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 17, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', 'unknown #2', NULL, 'Fagaceae Dumort.', true, NULL, NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'family', 'Fagaceae', NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 18, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Ficaceae', 'family', 0.770000000000000018, 'Bercht. & J. Presl', 'http://www.tropicos.org/Name/100353631', NULL, NULL, 'Ficaceae', 0.75, 'Ficaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Ficaceae Bercht. & J. Presl', 'unknown #2', NULL, 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Ficaceae', NULL, NULL, NULL, NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 19, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', 'unknown #2', NULL, 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Fucaceae', NULL, NULL, NULL, NULL, NULL, 'Fucaceae', NULL, 'Fucaceae');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 20, 4, 'Fabaceae unknown #2', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', 'unknown #2', NULL, 'Fabaceae', true, NULL, NULL, NULL, 'unknown #2', NULL, NULL, NULL, NULL, 'Fabaceae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', NULL, 'Fabaceae');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 21, 5, 'Fam_indet. Boyle#6501', 0, 'No suitable matches found.', NULL, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'true', NULL, ' ', NULL, false, NULL, NULL, NULL, 'No suitable matches found.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'No suitable matches found.', NULL, 'No suitable matches found.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 22, 6, 'Poa annua', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', 'Poa annua', 'Poaceae', 'true', 'tpl;tropicos;usda', ' ', NULL, true, 'Poaceae Poa annua L.', NULL, 'Poa annua', 'Poa annua L.', true, '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 23, 6, 'Poa annua', 1, 'Poa annua', 'species', 1, 'Cham. & Schltdl.', 'http://www.theplantlist.org/tpl1.1/record/kew-435195', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'false', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua Cham. & Schltdl.', true, '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 24, 7, 'Poa annua L.', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', 'L.', 1, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', 'Poa annua', 'Poaceae', 'true', 'tpl;tropicos;usda', ' ', NULL, true, 'Poaceae Poa annua L.', NULL, 'Poa annua', 'Poa annua L.', true, '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 25, 7, 'Poa annua L.', 0.800000000000000044, 'Poa annua', 'species', 1, 'Cham. & Schltdl.', 'http://www.theplantlist.org/tpl1.1/record/kew-435195', 'Cham. & Schltdl.', 0, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'false', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua Cham. & Schltdl.', true, '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 26, 8, 'Poa annua fo. lanuginosa', 1, 'Poa annua fo. lanuginosa', 'fo.', 1, 'Sennen', 'http://www.theplantlist.org/tpl1.1/record/tro-50267771', NULL, NULL, NULL, NULL, NULL, 'Poa', 1, 'annua', 1, 'fo.', 'lanuginosa', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194', 'Poa annua', 'Poaceae', 'true', 'tpl', ' ', NULL, true, 'Poaceae Poa annua L.', NULL, 'Poa annua', 'Poa annua fo. lanuginosa Sennen', true, '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 27, 8, 'Poa annua fo. lanuginosa', 1, 'Poa annua fo. lanuginosa', 'forma', 1, 'Sennen', 'http://www.tropicos.org/Name/50267771', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'fo.', 'lanuginosa', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua var. annua', NULL, 'variety', 'http://www.tropicos.org/Name/25517736', 'Poa annua', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua var. annua', NULL, 'Poa annua', 'Poa annua fo. lanuginosa Sennen', true, '{Poa,annua}', 'Poa', 'annua', 'Poa annua', 'var. annua', '{var.,annua}', 'var.', 'annua', 'Poa annua var. annua', 'variety', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'var.', 'annua', 'Poa annua var. annua', NULL, 'Poa annua var. annua');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 28, 9, 'Poa annua ssp. exilis', 1, 'Poa annua subsp. exilis', 'subspecies', 1, '(Tomm. ex Freyn) Asch. & Graebn.', 'http://www.tropicos.org/Name/50063800', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'true', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 29, 9, 'Poa annua ssp. exilis', 0.959999999999999964, 'Poa annua var. exilis', 'variety', 0.959999999999999964, 'Tomm. ex Freyn', 'http://www.tropicos.org/Name/25547854', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'exilis', 0.699999999999999956, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua var. exilis Tomm. ex Freyn', true, '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 30, 10, 'Poa annua subsp. exilis', 1, 'Poa annua subsp. exilis', 'subsp.', 1, '(Tomm. ex Freyn.) Asch. & Graebn.', 'http://www.theplantlist.org/tpl1.1/record/kew-435202', NULL, NULL, NULL, NULL, NULL, 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'true', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn.) Asch. & Graebn.', true, '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 31, 10, 'Poa annua subsp. exilis', 1, 'Poa annua subsp. exilis', 'subspecies', 1, '(Tomm. ex Freyn) Asch. & Graebn.', 'http://www.tropicos.org/Name/50063800', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 32, 11, 'Poa annua subvar. minima', 1, 'Poa annua subvar. minima', 'subvariety', 1, '(Schur) Asch. & Graebn.', 'http://www.tropicos.org/Name/50158097', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subvar.', 'minima', 1, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua subvar. minima', '(Schur) Asch. & Graebn.', 'subvariety', 'http://www.tropicos.org/Name/50158097', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.', NULL, 'Poa annua', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', true, '{Poa,annua}', 'Poa', 'annua', 'Poa annua', 'subvar. minima', '{subvar.,minima}', 'subvar.', 'minima', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', 'subvariety', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'subvar.', 'annua', 'Poa annua subvar. minima', '(Schur) Asch. & Graebn.', 'Poa annua subvar. minima (Schur) Asch. & Graebn.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 33, 12, 'Poa annua var. eriolepis', 1, 'Poa annua var. eriolepis', 'var.', 1, '̉ۡ.Desv.', 'http://www.theplantlist.org/tpl1.1/record/kew-435206', NULL, NULL, NULL, NULL, NULL, 'Poa', 1, 'annua', 1, 'var.', 'eriolepis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194', 'Poa annua', 'Poaceae', 'true', 'tpl', ' ', NULL, true, 'Poaceae Poa annua L.', NULL, 'Poa annua', 'Poa annua var. eriolepis ̉ۡ.Desv.', true, '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 34, 12, 'Poa annua var. eriolepis', 1, 'Poa annua var. eriolepis', 'variety', 1, 'E. Desv.', 'http://www.tropicos.org/Name/50119145', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'eriolepis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.tropicos.org/Name/25509881', 'Poa annua', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua L.', NULL, 'Poa annua', 'Poa annua var. eriolepis E. Desv.', true, '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 35, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subsp.', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', 'Silene scouleri', 'Caryophyllaceae', 'true', 'tpl', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 36, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'false', 'tropicos', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 37, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://plants.usda.gov/java/profile?symbol=SISCP', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://plants.usda.gov/java/profile?symbol=SISCP', 'Silene scouleri', 'Caryophyllaceae', 'false', 'usda', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'ssp. pringlei', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'ssp.', 'scouleri', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 38, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subsp.', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', 'Silene scouleri', 'Caryophyllaceae', 'true', 'tpl', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 39, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'false', 'tropicos', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');

INSERT INTO taxon_match VALUES ('2014-07-22 03:05:20.316489-07', 40, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://plants.usda.gov/java/profile?symbol=SISCP', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://plants.usda.gov/java/profile?symbol=SISCP', 'Silene scouleri', 'Caryophyllaceae', 'false', 'usda', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'ssp. pringlei', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'ssp.', 'scouleri', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire');

    "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" text,

    "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" text,