-- Name: remove_prefix(text, text, boolean, boolean); Type: FUNCTION; Schema: TNRS; Owner: bien

--

CREATE FUNCTION remove_prefix(prefix text, str text, require boolean DEFAULT true, case_sensitive boolean DEFAULT true) RETURNS text

    LANGUAGE sql IMMUTABLE

    AS $$

SELECT util.remove_prefix(prefix, str, require, case_sensitive)

$$;

ALTER FUNCTION "TNRS".remove_prefix(prefix text, str text, require boolean, case_sensitive boolean) OWNER TO bien;

--

-- Name: FUNCTION remove_prefix(prefix text, str text, require boolean, case_sensitive boolean); Type: COMMENT; Schema: TNRS; Owner: bien

--

COMMENT ON FUNCTION remove_prefix(prefix text, str text, require boolean, case_sensitive boolean) IS '

wrapper that prevents views from getting dropped when the util schema is reinstalled

';

--

	new."matched~Name[_no_author]___@TNRS__@vegpath.org" = NULL;

	new."Accepted_species[_binomial]__@TNRS__@vegpath.org" = NULL;

	new."matched~Name[_no_author]___@TNRS__@vegpath.org" = (SELECT NULLIF("*Name_matched", 'No suitable matches found.'::text) FROM (SELECT new.*) new);

	new."[matched_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT "matched~Name[_no_author]___@TNRS__@vegpath.org" || COALESCE((' '::text || "*Name_matched_author"), ''::text) FROM (SELECT new.*) new);

	new."Accepted_species[_binomial]__@TNRS__@vegpath.org" = (SELECT rtrim("*Accepted_name_species", ' '::text) FROM (SELECT new.*) new);

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

    ELSE "matched~Name[_no_author]___@TNRS__@vegpath.org"

    "Accepted_species[_binomial]__@TNRS__@vegpath.org" text,

    CONSTRAINT "Accepted_species[_binomial]__@TNRS__@vegpath.org" CHECK ((NOT ("Accepted_species[_binomial]__@TNRS__@vegpath.org" IS DISTINCT FROM rtrim("*Accepted_name_species", ' '::text)))),

    CONSTRAINT "[matched_]scientificName[_with_author]__@DwC__@vegpath.org" CHECK ((NOT ("[matched_]scientificName[_with_author]__@DwC__@vegpath.org" IS DISTINCT FROM ("matched~Name[_no_author]___@TNRS__@vegpath.org" || COALESCE((' '::text || "*Name_matched_author"), ''::text))))),

    ELSE "matched~Name[_no_author]___@TNRS__@vegpath.org"

    CONSTRAINT __accepted_infraspecific_label CHECK ((NOT (__accepted_infraspecific_label IS DISTINCT FROM ltrim(NULLIF(remove_prefix("*Accepted_name_species", "*Accepted_name", require := true, case_sensitive := false), ''::text), ' '::text)))),

to port derived column changes to vegbiendev:

SELECT util.derived_cols_export(''"TNRS".taxon_match'');

# run the returned SQL on vegbiendev

	-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")

SELECT util.recreate_view(''"TNRS".taxon_best_match'');

to add a new derived column:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''col''), $$

expr

$$));

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

SELECT util.recreate_view(''"TNRS".taxon_best_match'');

to remove a column:

SELECT util.recreate_view(''"TNRS".taxon_best_match'');

$ make schemas/remake

to move a derived column to the middle or to add a non-derived column:

SELECT util.recreate_view(''"TNRS".taxon_best_match'');

= "matched~Name[_no_author]___@TNRS__@vegpath.org" || COALESCE(('' ''::text || "*Name_matched_author"), ''''::text)

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[matched_]scientificName[_with_author]__@DwC__@vegpath.org'')::util.col, $$"matched~Name[_no_author]___@TNRS__@vegpath.org" || COALESCE(('' ''::text || "*Name_matched_author"), ''''::text)$$)::util.derived_col_def);

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

--

COMMENT ON COLUMN taxon_match."Accepted_species[_binomial]__@TNRS__@vegpath.org" IS '

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

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''Accepted_species[_binomial]__@TNRS__@vegpath.org'')::util.col, $$rtrim("*Accepted_name_species", '' ''::text)$$)::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("TNRS".remove_prefix("*Accepted_name_species", "*Accepted_name", require := true, case_sensitive := false), ''''::text), '' ''::text)

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''__accepted_infraspecific_label'')::util.col, $$ltrim(NULLIF("TNRS".remove_prefix("*Accepted_name_species", "*Accepted_name", require := true, case_sensitive := false), ''''::text), '' ''::text)$$)::util.derived_col_def);

    ELSE "matched~Name[_no_author]___@TNRS__@vegpath.org"

    ELSE "matched~Name[_no_author]___@TNRS__@vegpath.org"

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

    taxon_match."matched~Name[_no_author]___@TNRS__@vegpath.org",

    taxon_match."Accepted_family__@TNRS__@vegpath.org",

    taxon_match."Accepted_species[_binomial]__@TNRS__@vegpath.org",

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

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

    taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",

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

    taxon_best_match."matched~Name[_no_author]___@TNRS__@vegpath.org",

    taxon_best_match."Accepted_family__@TNRS__@vegpath.org",

    taxon_best_match."Accepted_species[_binomial]__@TNRS__@vegpath.org",

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

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

    taxon_best_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",

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

    "MatchedTaxon"."matched~Name[_no_author]___@TNRS__@vegpath.org",

    "MatchedTaxon"."Accepted_family__@TNRS__@vegpath.org",

    "MatchedTaxon"."Accepted_species[_binomial]__@TNRS__@vegpath.org",

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

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

    "MatchedTaxon"."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",

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

    "ValidMatchedTaxon"."matched~Name[_no_author]___@TNRS__@vegpath.org",

    "ValidMatchedTaxon"."Accepted_family__@TNRS__@vegpath.org",

    "ValidMatchedTaxon"."Accepted_species[_binomial]__@TNRS__@vegpath.org",

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

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

    "ValidMatchedTaxon"."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",

2014-07-26 21:26:21.824011-07	2014-07-26 21:26:21.824011-07	2014-07-26 21:26:21.824011-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~Name[_no_author]___@TNRS__@vegpath.org", "[matched_]scientificName[_with_author]__@DwC__@vegpath.org", matched_has_accepted, "Accepted_family__@TNRS__@vegpath.org", "Accepted_species[_binomial]__@TNRS__@vegpath.org", "__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_]taxonomicStatus__@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_]morphospecies[_binomial]__@Brad__.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-26 21:26:21.824011-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	Compositae	t	Compositae	\N	\N	\N	\N	Compositae indet. sp.1	\N	\N	\N	\N	Compositae	accepted	family	Compositae	\N	\N	\N	Compositae indet. sp.1	\N	\N	Compositae	\N	Compositae

2014-07-26 21:26:21.824011-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	Compositae	t	Compositae	\N	\N	\N	\N	Compositae indet. sp.1	\N	\N	\N	\N	Compositae	accepted	family	Compositae	\N	\N	\N	Compositae indet. sp.1	\N	\N	Compositae	\N	Compositae

2014-07-26 21:26:21.824011-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	Compositae Giseke	t	Asteraceae	\N	\N	\N	\N	Asteraceae indet. sp.1	\N	\N	\N	\N	Asteraceae Bercht. & J. Presl	accepted	family	Asteraceae	\N	\N	\N	Asteraceae indet. sp.1	\N	\N	Asteraceae	Bercht. & J. Presl	Asteraceae Bercht. & J. Presl

2014-07-26 21:26:21.824011-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	Fagaceae	t	Fagaceae	\N	\N	\N	\N	Fagaceae Boyle#6500	\N	\N	\N	\N	Fagaceae	accepted	family	Fagaceae	\N	\N	\N	Fagaceae Boyle#6500	\N	\N	Fagaceae	\N	Fagaceae

2014-07-26 21:26:21.824011-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	Fabaceae Lindl.	t	Fabaceae	\N	\N	\N	\N	Fabaceae Boyle#6500	\N	\N	\N	\N	Fabaceae Lindl.	accepted	family	Fabaceae	\N	\N	\N	Fabaceae Boyle#6500	\N	\N	Fabaceae	Lindl.	Fabaceae Lindl.

2014-07-26 21:26:21.824011-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	Fagaceae Dumort.	t	Fagaceae	\N	\N	\N	\N	Fagaceae Boyle#6500	\N	\N	\N	\N	Fagaceae Dumort.	accepted	family	Fagaceae	\N	\N	\N	Fagaceae Boyle#6500	\N	\N	Fagaceae	Dumort.	Fagaceae Dumort.

2014-07-26 21:26:21.824011-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	Ficaceae Bercht. & J. Presl	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	no opinion	family	Ficaceae	\N	\N	\N	Ficaceae Boyle#6500	\N	\N	Ficaceae	Bercht. & J. Presl	Ficaceae Bercht. & J. Presl

2014-07-26 21:26:21.824011-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	Fucaceae	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	no opinion	family	Fucaceae	\N	\N	\N	Fucaceae Boyle#6500	\N	\N	Fucaceae	\N	Fucaceae

2014-07-26 21:26:21.824011-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	Fabaceae	t	Fabaceae	\N	\N	\N	\N	Fabaceae Boyle#6500	\N	\N	\N	\N	Fabaceae	accepted	family	Fabaceae	\N	\N	\N	Fabaceae Boyle#6500	\N	\N	Fabaceae	\N	Fabaceae

2014-07-26 21:26:21.824011-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	Inga	t	Fabaceae	\N	\N	Inga	\N	Inga "fuzzy leaf"	\N	\N	\N	\N	Inga	accepted	genus	Fabaceae	Inga	\N	\N	Inga "fuzzy leaf"	\N	\N	Inga	\N	Inga

2014-07-26 21:26:21.824011-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	Inga Mill.	t	Fabaceae	\N	\N	Inga	\N	Inga "fuzzy leaf"	\N	\N	\N	\N	Inga Mill.	accepted	genus	Fabaceae	Inga	\N	\N	Inga "fuzzy leaf"	\N	\N	Inga	Mill.	Inga Mill.

2014-07-26 21:26:21.824011-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	Inga Scop.	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	illegitimate	genus	Fabaceae	Inga	\N	\N	Inga "fuzzy leaf"	\N	\N	Inga	Scop.	Inga Scop.

2014-07-26 21:26:21.824011-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	Inga	t	Fabaceae	\N	\N	Inga	\N	Inga sp.3	\N	\N	\N	\N	Inga	accepted	genus	Fabaceae	Inga	\N	\N	Inga sp.3	\N	\N	Inga	\N	Inga

2014-07-26 21:26:21.824011-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	Inga Mill.	t	Fabaceae	\N	\N	Inga	\N	Inga sp.3	\N	\N	\N	\N	Inga Mill.	accepted	genus	Fabaceae	Inga	\N	\N	Inga sp.3	\N	\N	Inga	Mill.	Inga Mill.

2014-07-26 21:26:21.824011-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	Inga Scop.	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	illegitimate	genus	Fabaceae	Inga	\N	\N	Inga sp.3	\N	\N	Inga	Scop.	Inga Scop.

2014-07-26 21:26:21.824011-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	Fagaceae	t	Fagaceae	\N	\N	\N	\N	Fagaceae unknown #2	\N	\N	\N	\N	Fagaceae	accepted	family	Fagaceae	\N	\N	\N	Fagaceae unknown #2	\N	\N	Fagaceae	\N	Fagaceae

2014-07-26 21:26:21.824011-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	Fabaceae Lindl.	t	Fabaceae	\N	\N	\N	\N	Fabaceae unknown #2	\N	\N	\N	\N	Fabaceae Lindl.	accepted	family	Fabaceae	\N	\N	\N	Fabaceae unknown #2	\N	\N	Fabaceae	Lindl.	Fabaceae Lindl.

2014-07-26 21:26:21.824011-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	Fagaceae Dumort.	t	Fagaceae	\N	\N	\N	\N	Fagaceae unknown #2	\N	\N	\N	\N	Fagaceae Dumort.	accepted	family	Fagaceae	\N	\N	\N	Fagaceae unknown #2	\N	\N	Fagaceae	Dumort.	Fagaceae Dumort.

2014-07-26 21:26:21.824011-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	Ficaceae Bercht. & J. Presl	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	no opinion	family	Ficaceae	\N	\N	\N	Ficaceae unknown #2	\N	\N	Ficaceae	Bercht. & J. Presl	Ficaceae Bercht. & J. Presl

2014-07-26 21:26:21.824011-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	Fucaceae	f	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	no opinion	family	Fucaceae	\N	\N	\N	Fucaceae unknown #2	\N	\N	Fucaceae	\N	Fucaceae

2014-07-26 21:26:21.824011-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	Fabaceae	t	Fabaceae	\N	\N	\N	\N	Fabaceae unknown #2	\N	\N	\N	\N	Fabaceae	accepted	family	Fabaceae	\N	\N	\N	Fabaceae unknown #2	\N	\N	Fabaceae	\N	Fabaceae

2014-07-26 21:26:21.824011-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	\N	\N	f	\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-26 21:26:21.824011-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	Poa annua L.	t	Poaceae	Poa annua	{Poa,annua}	Poa	annua	Poa annua	\N	\N	\N	\N	Poa annua L.	accepted	species	Poaceae	Poa	annua	Poa annua	Poa annua	\N	annua	Poa annua	L.	Poa annua L.

2014-07-26 21:26:21.824011-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	Poa annua Cham. & Schltdl.	t	Poaceae	Poa infirma	{Poa,infirma}	Poa	infirma	Poa infirma	\N	\N	\N	\N	Poa infirma Kunth	accepted	species	Poaceae	Poa	infirma	Poa infirma	Poa infirma	\N	infirma	Poa infirma	Kunth	Poa infirma Kunth

2014-07-26 21:26:21.824011-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	Poa annua L.	t	Poaceae	Poa annua	{Poa,annua}	Poa	annua	Poa annua	\N	\N	\N	\N	Poa annua L.	accepted	species	Poaceae	Poa	annua	Poa annua	Poa annua	\N	annua	Poa annua	L.	Poa annua L.

2014-07-26 21:26:21.824011-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	Poa annua Cham. & Schltdl.	t	Poaceae	Poa infirma	{Poa,infirma}	Poa	infirma	Poa infirma	\N	\N	\N	\N	Poa infirma Kunth	accepted	species	Poaceae	Poa	infirma	Poa infirma	Poa infirma	\N	infirma	Poa infirma	Kunth	Poa infirma Kunth

2014-07-26 21:26:21.824011-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	Poa annua fo. lanuginosa Sennen	t	Poaceae	Poa annua	{Poa,annua}	Poa	annua	Poa annua	\N	\N	\N	\N	Poa annua L.	accepted	species	Poaceae	Poa	annua	Poa annua	Poa annua	\N	annua	Poa annua	L.	Poa annua L.

2014-07-26 21:26:21.824011-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	Poa annua fo. lanuginosa Sennen	t	Poaceae	Poa annua	{Poa,annua}	Poa	annua	Poa annua	var. annua	{var.,annua}	var.	annua	Poa annua var. annua	accepted	variety	Poaceae	Poa	annua	Poa annua	Poa annua	var.	annua	Poa annua var. annua	\N	Poa annua var. annua

2014-07-26 21:26:21.824011-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	Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.	t	Poaceae	Poa infirma	{Poa,infirma}	Poa	infirma	Poa infirma	\N	\N	\N	\N	Poa infirma Kunth	accepted	species	Poaceae	Poa	infirma	Poa infirma	Poa infirma	\N	infirma	Poa infirma	Kunth	Poa infirma Kunth

2014-07-26 21:26:21.824011-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	Poa annua var. exilis Tomm. ex Freyn	t	Poaceae	Poa infirma	{Poa,infirma}	Poa	infirma	Poa infirma	\N	\N	\N	\N	Poa infirma Kunth	accepted	species	Poaceae	Poa	infirma	Poa infirma	Poa infirma	\N	infirma	Poa infirma	Kunth	Poa infirma Kunth

2014-07-26 21:26:21.824011-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	Poa annua subsp. exilis (Tomm. ex Freyn.) Asch. & Graebn.	t	Poaceae	Poa infirma	{Poa,infirma}	Poa	infirma	Poa infirma	\N	\N	\N	\N	Poa infirma Kunth	accepted	species	Poaceae	Poa	infirma	Poa infirma	Poa infirma	\N	infirma	Poa infirma	Kunth	Poa infirma Kunth

2014-07-26 21:26:21.824011-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	Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.	t	Poaceae	Poa infirma	{Poa,infirma}	Poa	infirma	Poa infirma	\N	\N	\N	\N	Poa infirma Kunth	accepted	species	Poaceae	Poa	infirma	Poa infirma	Poa infirma	\N	infirma	Poa infirma	Kunth	Poa infirma Kunth

2014-07-26 21:26:21.824011-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	Poa annua subvar. minima (Schur) Asch. & Graebn.	t	Poaceae	Poa annua	{Poa,annua}	Poa	annua	Poa annua	subvar. minima	{subvar.,minima}	subvar.	minima	Poa annua subvar. minima (Schur) Asch. & Graebn.	accepted	subvariety	Poaceae	Poa	annua	Poa annua	Poa annua	subvar.	annua	Poa annua subvar. minima	(Schur) Asch. & Graebn.	Poa annua subvar. minima (Schur) Asch. & Graebn.

2014-07-26 21:26:21.824011-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	Poa annua var. eriolepis ̉ۡ.Desv.	t	Poaceae	Poa annua	{Poa,annua}	Poa	annua	Poa annua	\N	\N	\N	\N	Poa annua L.	accepted	species	Poaceae	Poa	annua	Poa annua	Poa annua	\N	annua	Poa annua	L.	Poa annua L.

2014-07-26 21:26:21.824011-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	Poa annua var. eriolepis E. Desv.	t	Poaceae	Poa annua	{Poa,annua}	Poa	annua	Poa annua	\N	\N	\N	\N	Poa annua L.	accepted	species	Poaceae	Poa	annua	Poa annua	Poa annua	\N	annua	Poa annua	L.	Poa annua L.

2014-07-26 21:26:21.824011-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	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	t	Caryophyllaceae	Silene scouleri	{Silene,scouleri}	Silene	scouleri	Silene scouleri	subsp. pringlei	{subsp.,pringlei}	subsp.	pringlei	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	accepted	subsp.	Caryophyllaceae	Silene	scouleri	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-26 21:26:21.824011-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	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	t	Caryophyllaceae	Silene scouleri	{Silene,scouleri}	Silene	scouleri	Silene scouleri	subsp. pringlei	{subsp.,pringlei}	subsp.	pringlei	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	accepted	subspecies	Caryophyllaceae	Silene	scouleri	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-26 21:26:21.824011-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	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	t	Caryophyllaceae	Silene scouleri	{Silene,scouleri}	Silene	scouleri	Silene scouleri	ssp. pringlei	{ssp.,pringlei}	ssp.	pringlei	Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire	accepted	subspecies	Caryophyllaceae	Silene	scouleri	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-26 21:26:21.824011-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	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	t	Caryophyllaceae	Silene scouleri	{Silene,scouleri}	Silene	scouleri	Silene scouleri	subsp. pringlei	{subsp.,pringlei}	subsp.	pringlei	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	accepted	subsp.	Caryophyllaceae	Silene	scouleri	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-26 21:26:21.824011-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	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	t	Caryophyllaceae	Silene scouleri	{Silene,scouleri}	Silene	scouleri	Silene scouleri	subsp. pringlei	{subsp.,pringlei}	subsp.	pringlei	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	accepted	subspecies	Caryophyllaceae	Silene	scouleri	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-26 21:26:21.824011-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	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	t	Caryophyllaceae	Silene scouleri	{Silene,scouleri}	Silene	scouleri	Silene scouleri	ssp. pringlei	{ssp.,pringlei}	ssp.	pringlei	Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire	accepted	subspecies	Caryophyllaceae	Silene	scouleri	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-26 21:26:29 PDT)';

-- Name: analytical_stem_view_modify(boolean); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien

CREATE FUNCTION analytical_stem_view_modify(repopulate boolean DEFAULT true) RETURNS void

SELECT util.rematerialize_view('analytical_stem', 'analytical_stem_view', $$

$$, repopulate);

ALTER FUNCTION "public.test_taxonomic_names".analytical_stem_view_modify(repopulate boolean) OWNER TO bien;

-- Name: geoscrub_input_view_modify(boolean); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien

CREATE FUNCTION geoscrub_input_view_modify(repopulate boolean DEFAULT true) RETURNS void

    AS $_$

SELECT util.rematerialize_view('geoscrub_input', 'geoscrub_input_view', $$

$$, repopulate);

$_$;

ALTER FUNCTION "public.test_taxonomic_names".geoscrub_input_view_modify(repopulate boolean) OWNER TO bien;

-- Name: iucn_red_list_view_modify(boolean); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien

CREATE FUNCTION iucn_red_list_view_modify(repopulate boolean DEFAULT true) RETURNS void

    AS $_$

SELECT util.rematerialize_view('iucn_red_list', 'iucn_red_list_view', $$

$$, repopulate);

$_$;

ALTER FUNCTION "public.test_taxonomic_names".iucn_red_list_view_modify(repopulate boolean) OWNER TO bien;

-- Name: provider_count_view_modify(boolean); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien

CREATE FUNCTION provider_count_view_modify(repopulate boolean DEFAULT true) RETURNS void

    AS $_$

SELECT util.rematerialize_view('provider_count', 'provider_count_view', $$

$$, repopulate);

$_$;

ALTER FUNCTION "public.test_taxonomic_names".provider_count_view_modify(repopulate boolean) OWNER TO bien;

-- Name: taxon_trait_view_modify(boolean); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien

CREATE FUNCTION taxon_trait_view_modify(repopulate boolean DEFAULT true) RETURNS void

    AS $_$

SELECT util.rematerialize_view('taxon_trait', 'taxon_trait_view', $$

$$, repopulate);

$_$;

ALTER FUNCTION "public.test_taxonomic_names".taxon_trait_view_modify(repopulate boolean) OWNER TO bien;

    "plantobservation.""_id__@VegBIEN__.public@vegpath.org" integer,

    "stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" double precision,

    "stemHeight[_m]__@VegBank__.stemCount@vegpath.org" double precision,

    "[tag=]identificationLabel__@VegX__.individual@vegpath.org" text,

    "relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" double precision,

    "relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" double precision,

-- Name: COLUMN analytical_stem."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem."taxonObservation[.id]__@VegBank__@vegpath.org" IS '"identifier assigned [by the datasource] to each unique observation of a taxon in a plot"';

-- Name: COLUMN analytical_stem."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS '"Verbatum short code used by the author to signify the species at time of observation"';

-- Name: COLUMN analytical_stem."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to all occurrences of an organism based on an aggregation factor. It contains an AggregateValue, which is an assessment of the overall occurrence of an organism in a Plot (e.g. number of stems, percentage cover, total biomass, basal area)."';

-- Name: COLUMN analytical_stem."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to one occurrence of an organism (or part of an organism). It is a container for measurements made on the organism (e.g. diameter, height, crown dimensions, biomass, growth form, number of stems)."';

-- Name: COLUMN analytical_stem."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem."individualID__@DwC__@vegpath.org" IS '"An identifier for an individual or named group of individual organisms represented in the Occurrence"';

-- Name: COLUMN analytical_stem."individualCount__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem."individualCount__@DwC__@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';

-- Name: COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS '"Diameter at breast height of this stem (usually taken at 1.3 meters, but may vary)"';

-- Name: COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS '"The measured height of the stem in meters"';

-- Name: COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS '"A label that is associated with an individual (e.g. a numerical tree tag)"';

-- Name: COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The X-coordinate of the related item position in m. The user will enter the relative position of related item with respect to the plot origin (in meters) with the x-axis defined by the plot azimuth."';

-- Name: COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The Y-coordinate of the relatedSpatialItem position in m. The user will enter the relative position of relatedSpatialItems with respect to the plot origin (in meters) with the y-axis defined by the plot azimuth."';

-- Name: viewFullOccurrence_individual_view; Type: VIEW; Schema: public.test_taxonomic_names; Owner: bien

CREATE VIEW "viewFullOccurrence_individual_view" AS

    plantobservation.plantobservation_id AS "plantobservation.""_id__@VegBIEN__.public@vegpath.org"

   FROM ((((((((((((("plot.**"

ALTER TABLE "public.test_taxonomic_names"."viewFullOccurrence_individual_view" OWNER TO bien;

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org" IS '"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."country__@DwC__@vegpath.org" IS 'http://geoscrub.geoscrub_output.acceptedCountry__@VegBIEN__@vegpath.org;

"The name of the country or major administrative unit in which the Location occurs"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."stateProvince__@DwC__@vegpath.org" IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."county__@DwC__@vegpath.org" IS '"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."locality__@DwC__@vegpath.org" IS '"The specific description of the place"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."decimalLatitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."decimalLatitude__@DwC__@vegpath.org" IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."decimalLongitude__@DwC__@vegpath.org" IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS 'for a point observation, this is the fuzziness of the coordinates. for a plot (or other shape), this is the radius of the circle that circumscribes the entire plot, or the fuzziness, whichever is greater. note that the DwC definition is confusingly worded: it uses the ambiguous term Location, which sometimes refers to the asserted named place, but which they intended to refer to the plot or point.';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."georeferenceSources__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of maps, gazetteers, or other resources used to georeference the Location, described specifically enough to allow anyone in the future to use the same resources"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."georeferenceProtocol__@DwC__@vegpath.org" IS '"A description or reference to the methods used to determine the spatial footprint, coordinates, and uncertainties"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view".geovalid_bien; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view".geovalid_bien IS 'whether the coordinates are within the boundary of the asserted named places';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."isNewWorld_bien"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."isNewWorld_bien" IS 'whether the country is in the Americas';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."projectID__@VegX__.plotObservation@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."projectID__@VegX__.plotObservation@vegpath.org" IS 'http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;

"A reference to a specific ''project''"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."projectContributor[s]__@VegBank__@vegpath.org" IS '"intersection entit[ies] used to ''link'' a party with a specific project wherein vegetation plots are described"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."locationID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."locationID__@DwC__@vegpath.org" IS '"An identifier for the set of location information (data associated with dcterms:Location)"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."plotName__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."plotName__@VegX__.plot@vegpath.org" IS '"Name or label for a plot"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'http://location.authorlocationcode__@VegBIEN__.public@vegpath.org;

"Code for subplot, line, or any other subsample or subdivision of plot"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view".location__cultivated__bien; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view".location__cultivated__bien IS 'whether the occurrence''s *location* was flagged as cultivated. note that this refers just to the cultivated status of the *location*; the occurrence may be cultivated even if the location isn''t.';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'http://locationevent.locationevent_id__@VegBIEN__.public@vegpath.org;

autogenerated ID for locationevent';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."eventDate__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."eventDate__@DwC__@vegpath.org" IS '"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'the "elevation (altitude, usually above sea level), in meters"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."slopeAspect[_deg]__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."plot.area[_ha]__@VegX__@vegpath.org" IS '"Total area of the plot"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."samplingProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."samplingProtocol__@DwC__@vegpath.org" IS '"The name of, reference to, or description of the method or protocol used during an Event"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS '"Temperature during observation [...] [in] Celsius"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS '"Total annual precipitation, in mm"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."stratumName__@VegX__.stratum@vegpath.org" IS '"Name associated with this stratum"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."communityConcept.name__@VegX__.communityDet@vegpath.org" IS '"A textual label for a community type. A community type is an abstract grouping of organisms that tend to co-occur on the landscape due to shared ecological requirements or preferences."';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."observationContributor[s]__@VegBank__@vegpath.org" IS '"intersection[s] that link[] a party with a specific plot observation event"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS '"The name[s] (or acronym[s]) in use by the institution[s] having custody of the object(s) or information referred to in the record"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."collectionCode__@DwC__@vegpath.org" IS '"The name, acronym, coden, or initialism identifying the collection or data set from which the record was derived"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."catalogNumber__@DwC__@vegpath.org" IS '"An identifier (preferably unique) for the record within the data set or collection"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."occurrenceID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."occurrenceID__@DwC__@vegpath.org" IS '"An identifier for the Occurrence (as opposed to a particular digital record of the occurrence). In the absence of a persistent global unique identifier, construct one from a combination of identifiers in the record that will most closely make the occurrenceID globally unique."';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."recordedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."recordNumber__@DwC__@vegpath.org" IS '"An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector''s number."';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'the "date-time (Common Era calendar) in a date-time period during which an organism or group of organisms was collected or observed"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."[verbatim_]family__@DwC__@vegpath.org" IS '"The full scientific name of the family in which the taxon is classified [*before* any TNRS scrubbing]"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."[verbatim_]scientificName__@DwC__@vegpath.org" IS '"The full scientific name [*before* any TNRS scrubbing], with authorship and date information if known. When forming part of an Identification, this should be the name in lowest level taxonomic rank that can be determined."';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."identifiedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."identifiedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."dateIdentified__@DwC__@vegpath.org" IS '"The date on which the subject was identified as representing the Taxon"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."identificationRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."identificationRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Identification"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."Family_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."Family_matched__@TNRS__@vegpath.org" IS 'http://TNRS.taxon_scrub.matchedFamily__@VegBIEN__.public@vegpath.org;

"The closest matching family in the TNRS database to the family submitted"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."Name_matched__@TNRS__@vegpath.org" IS '"Scientific name with the highest match score. May be an exact match or a fuzzy match."';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."Name_matched_author__@TNRS__@vegpath.org" IS '"Standard authority for the matched name"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'closed list derived from higher taxa';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."taxonomicStatus__@DwC__@vegpath.org" IS '"The status of the use of the scientificName as a label for a taxon. Requires taxonomic opinion to define the scope of a taxon. [...] Examples: "invalid", "misapplied", "homotypic synonym", "accepted"."';

--

-- Name: COLUMN "viewFullOccurrence_individual_view".scrubbed_family; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view".scrubbed_family IS 'the family of the TNRS accepted or matched name';

--

-- Name: COLUMN "viewFullOccurrence_individual_view".scrubbed_genus; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view".scrubbed_genus IS 'the genus of the TNRS accepted or matched name';

--

-- Name: COLUMN "viewFullOccurrence_individual_view".scrubbed_specific_epithet; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view".scrubbed_specific_epithet IS 'the specific epithet of the TNRS accepted or matched name';

--

-- Name: COLUMN "viewFullOccurrence_individual_view".scrubbed_species_binomial; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view".scrubbed_species_binomial IS 'the species binomial of the TNRS accepted or matched name';

--

-- Name: COLUMN "viewFullOccurrence_individual_view".scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view".scrubbed_taxon_name_no_author IS 'the taxon name without author of the TNRS accepted or matched name';

--

-- Name: COLUMN "viewFullOccurrence_individual_view".scrubbed_author; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view".scrubbed_author IS 'the author of the TNRS accepted or matched name';

--

-- Name: COLUMN "viewFullOccurrence_individual_view".scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view".scrubbed_taxon_name_with_author IS 'the taxon name with author of the TNRS accepted or matched name';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS 'http://TNRS.taxon_scrub.scrubbed_morphospecies_binomial__@VegBIEN__.public@vegpath.org;

"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`";

a morphospecies is a custom species name assigned in the field by the collector (which does not validate to anything in TNRS)';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS '"Growth form"; "Closed pick list"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."reproductiveCondition__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."reproductiveCondition__@DwC__@vegpath.org" IS '"The reproductive condition of the biological individual(s) represented in the Occurrence. Recommended best practice is to use a controlled vocabulary."';

--

-- Name: COLUMN "viewFullOccurrence_individual_view".cultivated_bien; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view".cultivated_bien IS 'whether the occurrence was flagged as cultivated';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."cultivatedBasis_bien"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."cultivatedBasis_bien" IS 'why the occurrence was flagged as cultivated';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."occurrenceRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."occurrenceRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Occurrence"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."coverPercent__@VegX__.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."coverPercent__@VegX__.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."taxonObservation[.id]__@VegBank__@vegpath.org" IS '"identifier assigned [by the datasource] to each unique observation of a taxon in a plot"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS '"Verbatum short code used by the author to signify the species at time of observation"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to all occurrences of an organism based on an aggregation factor. It contains an AggregateValue, which is an assessment of the overall occurrence of an organism in a Plot (e.g. number of stems, percentage cover, total biomass, basal area)."';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to one occurrence of an organism (or part of an organism). It is a container for measurements made on the organism (e.g. diameter, height, crown dimensions, biomass, growth form, number of stems)."';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."individualID__@DwC__@vegpath.org" IS '"An identifier for an individual or named group of individual organisms represented in the Occurrence"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."individualCount__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."individualCount__@DwC__@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';

--

-- Name: COLUMN "viewFullOccurrence_individual_view"."plantobservation.""_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."plantobservation.""_id__@VegBIEN__.public@vegpath.org" IS 'http://plantobservation.plantobservation_id__@VegBIEN__.public@vegpath.org;

autogenerated ID for plantobservation';

--

-- Name: analytical_stem_view; Type: VIEW; Schema: public.test_taxonomic_names; Owner: bien

--

CREATE VIEW analytical_stem_view AS

 SELECT "viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org",

    "viewFullOccurrence_individual_view"."country__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."stateProvince__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."county__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."locality__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."decimalLatitude__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."decimalLongitude__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."coordinateUncertaintyInMeters__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."georeferenceSources__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."georeferenceProtocol__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view".geovalid_bien,

    "viewFullOccurrence_individual_view"."isNewWorld_bien",

    "viewFullOccurrence_individual_view"."projectID__@VegX__.plotObservation@vegpath.org",

    "viewFullOccurrence_individual_view"."projectContributor[s]__@VegBank__@vegpath.org",

    "viewFullOccurrence_individual_view"."locationID__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."plotName__@VegX__.plot@vegpath.org",

    "viewFullOccurrence_individual_view"."subplot__@SALVIAS__.Plot_data@vegpath.org",

    "viewFullOccurrence_individual_view".location__cultivated__bien,

    "viewFullOccurrence_individual_view"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org",

    "viewFullOccurrence_individual_view"."eventDate__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."(-minimum-)ElevationInMeters__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."slopeAspect[_deg]__@VegX__.plot@vegpath.org",

    "viewFullOccurrence_individual_view"."slopeGradient[_deg]__@VegX__.plot@vegpath.org",

    "viewFullOccurrence_individual_view"."plot.area[_ha]__@VegX__@vegpath.org",

    "viewFullOccurrence_individual_view"."samplingProtocol__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",

    "viewFullOccurrence_individual_view"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",

    "viewFullOccurrence_individual_view"."stratumName__@VegX__.stratum@vegpath.org",

    "viewFullOccurrence_individual_view"."communityConcept.name__@VegX__.communityDet@vegpath.org",

    "viewFullOccurrence_individual_view"."observationContributor[s]__@VegBank__@vegpath.org",

    "viewFullOccurrence_individual_view"."[custodial_]institutionCode[s]__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."collectionCode__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."catalogNumber__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."occurrenceID__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."recordedBy__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."recordNumber__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",

    "viewFullOccurrence_individual_view"."[verbatim_]family__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."[verbatim_]scientificName__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."identifiedBy__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."dateIdentified__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."identificationRemarks__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."Family_matched__@TNRS__@vegpath.org",

    "viewFullOccurrence_individual_view"."Name_matched__@TNRS__@vegpath.org",

    "viewFullOccurrence_individual_view"."Name_matched_author__@TNRS__@vegpath.org",

    "viewFullOccurrence_individual_view"."[higher_plant_group~]higherClassification__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."taxonomicStatus__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view".scrubbed_family,

    "viewFullOccurrence_individual_view".scrubbed_genus,

    "viewFullOccurrence_individual_view".scrubbed_specific_epithet,

    "viewFullOccurrence_individual_view".scrubbed_species_binomial,

    "viewFullOccurrence_individual_view".scrubbed_taxon_name_no_author,

    "viewFullOccurrence_individual_view".scrubbed_author,

    "viewFullOccurrence_individual_view".scrubbed_taxon_name_with_author,

    "viewFullOccurrence_individual_view"."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org",

    "viewFullOccurrence_individual_view"."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",

    "viewFullOccurrence_individual_view"."reproductiveCondition__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view".cultivated_bien,

    "viewFullOccurrence_individual_view"."cultivatedBasis_bien",

    "viewFullOccurrence_individual_view"."occurrenceRemarks__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."coverPercent__@VegX__.attribute.ordinal@vegpath.org",

    "viewFullOccurrence_individual_view"."taxonObservation[.id]__@VegBank__@vegpath.org",

    "viewFullOccurrence_individual_view"."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",

    "viewFullOccurrence_individual_view"."aggregateOrganismObservation.id__@VegX__@vegpath.org",

    "viewFullOccurrence_individual_view"."individualOrganismObservation.id__@VegX__@vegpath.org",

    "viewFullOccurrence_individual_view"."individualID__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."individualCount__@DwC__@vegpath.org",

    "viewFullOccurrence_individual_view"."plantobservation.""_id__@VegBIEN__.public@vegpath.org",

    _m_to_cm(stemobservation.diameterbreastheight_m) AS "stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org",

    stemobservation.height_m AS "stemHeight[_m]__@VegBank__.stemCount@vegpath.org",

    stemobservation.tag AS "[tag=]identificationLabel__@VegX__.individual@vegpath.org",

    stemobservation.xposition_m AS "relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org",

    stemobservation.yposition_m AS "relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org",

    stemobservation.authorstemcode AS "stemCode__@VegBank__.stemLocation@vegpath.org"

   FROM ("viewFullOccurrence_individual_view"

   LEFT JOIN stemobservation ON ((stemobservation.plantobservation_id = "viewFullOccurrence_individual_view"."plantobservation.""_id__@VegBIEN__.public@vegpath.org")));

-- Name: COLUMN analytical_stem_view."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem_view."taxonObservation[.id]__@VegBank__@vegpath.org" IS '"identifier assigned [by the datasource] to each unique observation of a taxon in a plot"';

-- Name: COLUMN analytical_stem_view."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem_view."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS '"Verbatum short code used by the author to signify the species at time of observation"';

-- Name: COLUMN analytical_stem_view."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem_view."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to all occurrences of an organism based on an aggregation factor. It contains an AggregateValue, which is an assessment of the overall occurrence of an organism in a Plot (e.g. number of stems, percentage cover, total biomass, basal area)."';

-- Name: COLUMN analytical_stem_view."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem_view."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to one occurrence of an organism (or part of an organism). It is a container for measurements made on the organism (e.g. diameter, height, crown dimensions, biomass, growth form, number of stems)."';

-- Name: COLUMN analytical_stem_view."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem_view."individualID__@DwC__@vegpath.org" IS '"An identifier for an individual or named group of individual organisms represented in the Occurrence"';

-- Name: COLUMN analytical_stem_view."individualCount__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem_view."individualCount__@DwC__@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';

-- Name: COLUMN analytical_stem_view."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem_view."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS '"Diameter at breast height of this stem (usually taken at 1.3 meters, but may vary)"';

-- Name: COLUMN analytical_stem_view."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem_view."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS '"The measured height of the stem in meters"';

-- Name: COLUMN analytical_stem_view."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem_view."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS '"A label that is associated with an individual (e.g. a numerical tree tag)"';

-- Name: COLUMN analytical_stem_view."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem_view."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The X-coordinate of the related item position in m. The user will enter the relative position of related item with respect to the plot origin (in meters) with the x-axis defined by the plot azimuth."';

-- Name: COLUMN analytical_stem_view."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

COMMENT ON COLUMN analytical_stem_view."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The Y-coordinate of the relatedSpatialItem position in m. The user will enter the relative position of relatedSpatialItems with respect to the plot origin (in meters) with the y-axis defined by the plot azimuth."';