SELECT util.set_col_types(''"TNRS".tnrs_match'', ARRAY[

-- Name: taxon_name_is_safe(text); Type: FUNCTION; Schema: TNRS; Owner: bien

CREATE FUNCTION taxon_name_is_safe(taxon_name text) RETURNS boolean

    LANGUAGE sql IMMUTABLE

SELECT NOT ($1 = ANY("TNRS".unsafe_taxon_names()))

ALTER FUNCTION "TNRS".taxon_name_is_safe(taxon_name text) OWNER TO bien;

UPDATE "TNRS".tnrs_match SET "Name_submitted" = "Name_submitted"

VACUUM ANALYZE "TNRS".tnrs_match -- to remove previous rows

--

-- Name: unsafe_taxon_names(); Type: FUNCTION; Schema: TNRS; Owner: bien

--

CREATE FUNCTION unsafe_taxon_names() RETURNS text[]

    LANGUAGE sql IMMUTABLE

    AS $$

SELECT ARRAY[

]::text[]

$$;

ALTER FUNCTION "TNRS".unsafe_taxon_names() OWNER TO bien;

-- Name: tnrs_match; Type: TABLE; Schema: TNRS; Owner: bien; Tablespace: 

CREATE TABLE tnrs_match (

ALTER TABLE "TNRS".tnrs_match OWNER TO bien;

-- Name: TABLE tnrs_match; Type: COMMENT; Schema: TNRS; Owner: bien

COMMENT ON TABLE tnrs_match IS '

ALTER TABLE "TNRS".tnrs_match DISABLE TRIGGER tnrs_populate_fields; --speeds up update

UPDATE "TNRS".tnrs_match SET "col" = value;

ALTER TABLE "TNRS".tnrs_match ENABLE TRIGGER tnrs_populate_fields;

VACUUM ANALYZE "TNRS".tnrs_match --remove previous rows; runtime: 1.5 min ("92633 ms")

 SELECT s."*Name_matched.batch",

    s."concatenatedScientificName",

    s."matchedTaxonName",

    s."matchedTaxonRank",

    s."*Name_matched.Name_score",

    s."matchedScientificNameAuthorship",

    s."matchedScientificNameID",

    s."*Name_matched.Author_score",

    s."matchedFamilyConfidence_fraction",

    s."matchedFamily",

    s."matchedGenus",

    s."matchedGenusConfidence_fraction",

    s."matchedSpecificEpithet",

    s."matchedSpeciesConfidence_fraction",

    s."matchedInfraspecificEpithet",

    s."*Name_matched.Infraspecific_epithet_score",

    s."identificationQualifier",

    s."morphospeciesSuffix",

    s."taxonomicStatus",

    s.accepted_taxon_name_no_author,

    s.accepted_author,

    s.accepted_taxon_rank,

    s."acceptedScientificNameID",

    s.accepted_species_binomial,

    s.accepted_family,

    s."*Name_matched.Selected",

    s."*Name_matched.Source",

    s."*Name_matched.Warnings",

    s."*Name_matched.Accepted_name_lsid",

    s.taxon_scrub__is_valid_match,

    s.scrubbed_unique_taxon_name,

   FROM ( SELECT tnrs_match.batch AS "*Name_matched.batch",

            tnrs_match."Name_submitted" AS "concatenatedScientificName",

            tnrs_match."Name_matched" AS "matchedTaxonName",

            tnrs_match."Name_matched_rank" AS "matchedTaxonRank",

            tnrs_match."Name_score" AS "*Name_matched.Name_score",

            tnrs_match."Name_matched_author" AS "matchedScientificNameAuthorship",

            tnrs_match."Name_matched_url" AS "matchedScientificNameID",

            tnrs_match."Author_score" AS "*Name_matched.Author_score",

            tnrs_match."Family_score" AS "matchedFamilyConfidence_fraction",

            COALESCE(tnrs_match."Name_matched_accepted_family", tnrs_match."Accepted_name_family") AS "matchedFamily",

            tnrs_match."Genus_matched" AS "matchedGenus",

            tnrs_match."Genus_score" AS "matchedGenusConfidence_fraction",

            tnrs_match."Specific_epithet_matched" AS "matchedSpecificEpithet",

            tnrs_match."Specific_epithet_score" AS "matchedSpeciesConfidence_fraction",

            tnrs_match."Infraspecific_epithet_matched" AS "matchedInfraspecificEpithet",

            tnrs_match."Infraspecific_epithet_score" AS "*Name_matched.Infraspecific_epithet_score",

            tnrs_match."Annotations" AS "identificationQualifier",

            tnrs_match."Unmatched_terms" AS "morphospeciesSuffix",

            map_taxonomic_status(tnrs_match."Taxonomic_status", tnrs_match."Accepted_name") AS "taxonomicStatus",

            tnrs_match."Accepted_name" AS accepted_taxon_name_no_author,

            tnrs_match."Accepted_name_author" AS accepted_author,

            tnrs_match."Accepted_name_rank" AS accepted_taxon_rank,

            tnrs_match."Accepted_name_url" AS "acceptedScientificNameID",

            tnrs_match."Accepted_name_species" AS accepted_species_binomial,

            tnrs_match."Accepted_name_family" AS accepted_family,

            tnrs_match."Selected" AS "*Name_matched.Selected",

            tnrs_match."Source" AS "*Name_matched.Source",

            tnrs_match."Warnings" AS "*Name_matched.Warnings",

            tnrs_match."Accepted_name_lsid" AS "*Name_matched.Accepted_name_lsid",

            tnrs_match.is_valid_match AS taxon_scrub__is_valid_match,

            tnrs_match.scrubbed_unique_taxon_name

           FROM tnrs_match) s;

SELECT util.recreate_view(''"TNRS"."MatchedTaxon"'', $$

SELECT __

 SELECT "MatchedTaxon"."*Name_matched.batch",

    "MatchedTaxon"."concatenatedScientificName",

    "MatchedTaxon"."matchedTaxonName",

    "MatchedTaxon"."matchedTaxonRank",

    "MatchedTaxon"."*Name_matched.Name_score",

    "MatchedTaxon"."matchedScientificNameAuthorship",

    "MatchedTaxon"."matchedScientificNameID",

    "MatchedTaxon"."*Name_matched.Author_score",

    "MatchedTaxon"."matchedFamilyConfidence_fraction",

    "MatchedTaxon"."matchedFamily",

    "MatchedTaxon"."matchedGenus",

    "MatchedTaxon"."matchedGenusConfidence_fraction",

    "MatchedTaxon"."matchedSpecificEpithet",

    "MatchedTaxon"."matchedSpeciesConfidence_fraction",

    "MatchedTaxon"."matchedInfraspecificEpithet",

    "MatchedTaxon"."*Name_matched.Infraspecific_epithet_score",

    "MatchedTaxon"."identificationQualifier",

    "MatchedTaxon"."morphospeciesSuffix",

    "MatchedTaxon"."taxonomicStatus",

    "MatchedTaxon".accepted_taxon_name_no_author,

    "MatchedTaxon".accepted_author,

    "MatchedTaxon".accepted_taxon_rank,

    "MatchedTaxon"."acceptedScientificNameID",

    "MatchedTaxon".accepted_species_binomial,

    "MatchedTaxon".accepted_family,

    "MatchedTaxon"."*Name_matched.Selected",

    "MatchedTaxon"."*Name_matched.Source",

    "MatchedTaxon"."*Name_matched.Warnings",

    "MatchedTaxon"."*Name_matched.Accepted_name_lsid",

    "MatchedTaxon".taxon_scrub__is_valid_match,

    "MatchedTaxon".scrubbed_unique_taxon_name,

 SELECT tnrs_match."Name_submitted" AS scrubbed_unique_taxon_name,

    tnrs_match."Name_matched_rank" AS scrubbed_taxon_rank,

    COALESCE(tnrs_match."Name_matched_accepted_family", tnrs_match."Family_matched") AS scrubbed_family,

    tnrs_match."Genus_matched" AS scrubbed_genus,

    tnrs_match."Specific_epithet_matched" AS scrubbed_specific_epithet,

    tnrs_match."Infraspecific_rank" AS scrubbed_infraspecific_rank,

    tnrs_match."Infraspecific_epithet_matched" AS scrubbed_infraspecific_epithet,

    tnrs_match."Name_matched_author" AS scrubbed_author,

    tnrs_match."Name_matched" AS scrubbed_taxon_name_no_author,

    (tnrs_match."Name_matched" || COALESCE((' '::text || tnrs_match."Name_matched_author"), ''::text)) AS scrubbed_taxon_name_with_author

   FROM tnrs_match;

to modify:

SELECT util.recreate_view(''"TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*"'', $$

SELECT __

$$);

 SELECT "ValidMatchedTaxon".scrubbed_unique_taxon_name,

    "ValidMatchedTaxon"."*Name_matched.batch",

    "ValidMatchedTaxon"."concatenatedScientificName",

    "ValidMatchedTaxon"."matchedTaxonName",

    "ValidMatchedTaxon"."matchedTaxonRank",

    "ValidMatchedTaxon"."*Name_matched.Name_score",

    "ValidMatchedTaxon"."matchedScientificNameAuthorship",

    "ValidMatchedTaxon"."matchedScientificNameID",

    "ValidMatchedTaxon"."*Name_matched.Author_score",

    "ValidMatchedTaxon"."matchedFamilyConfidence_fraction",

    "ValidMatchedTaxon"."matchedFamily",

    "ValidMatchedTaxon"."matchedGenus",

    "ValidMatchedTaxon"."matchedGenusConfidence_fraction",

    "ValidMatchedTaxon"."matchedSpecificEpithet",

    "ValidMatchedTaxon"."matchedSpeciesConfidence_fraction",

    "ValidMatchedTaxon"."matchedInfraspecificEpithet",

    "ValidMatchedTaxon"."*Name_matched.Infraspecific_epithet_score",

    "ValidMatchedTaxon"."identificationQualifier",

    "ValidMatchedTaxon"."morphospeciesSuffix",

    "ValidMatchedTaxon"."taxonomicStatus",

    "ValidMatchedTaxon".accepted_taxon_name_no_author,

    "ValidMatchedTaxon".accepted_author,

    "ValidMatchedTaxon".accepted_taxon_rank,

    "ValidMatchedTaxon"."acceptedScientificNameID",

    "ValidMatchedTaxon".accepted_species_binomial,

    "ValidMatchedTaxon".accepted_family,

    "ValidMatchedTaxon"."*Name_matched.Selected",

    "ValidMatchedTaxon"."*Name_matched.Source",

    "ValidMatchedTaxon"."*Name_matched.Warnings",

    "ValidMatchedTaxon"."*Name_matched.Accepted_name_lsid",

    "ValidMatchedTaxon".taxon_scrub__is_valid_match,

    "ValidMatchedTaxon".accepted_morphospecies_binomial,

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank,

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_family,

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_genus,

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_specific_epithet,

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_rank,

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_epithet,

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_author,

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author,

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_with_author,

SELECT util.recreate_view(''"TNRS".taxon_scrub'', $$

SELECT __

2014-06-25 16:26:37.716529-07	2014-06-25 16:26:37.716529-07	2014-06-25 16:26:37.716529-07	\N

-- Data for Name: tnrs_match; Type: TABLE DATA; Schema: TNRS; Owner: bien

COPY tnrs_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) FROM stdin;

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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	true	tropicos	 	\N	t	Fabaceae Lindl.

2014-06-25 16:26:37.716529-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.

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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.

2014-06-25 16:26:37.716529-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.

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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.

2014-06-25 16:26:37.716529-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.

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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	true	tropicos	 	\N	t	Fabaceae Lindl.

2014-06-25 16:26:37.716529-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.

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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.

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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.

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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.

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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.

2014-06-25 16:26:37.716529-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.

2014-06-25 16:26:37.716529-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.

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

2014-06-25 16:26:37.716529-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

ALTER TABLE ONLY tnrs_match

CREATE INDEX "tnrs_Name_submitted_idx" ON tnrs_match USING btree ("Name_submitted");

CREATE INDEX tnrs__valid_match ON tnrs_match USING btree ("Name_submitted") WHERE is_valid_match;

CREATE TRIGGER tnrs__batch_begin BEFORE INSERT ON tnrs_match FOR EACH STATEMENT EXECUTE PROCEDURE tnrs__batch_begin();

CREATE TRIGGER tnrs__match_num__fill BEFORE INSERT ON tnrs_match FOR EACH ROW EXECUTE PROCEDURE tnrs__match_num__fill();

CREATE TRIGGER tnrs_populate_fields BEFORE INSERT OR UPDATE ON tnrs_match FOR EACH ROW EXECUTE PROCEDURE tnrs_populate_fields();

ALTER TABLE ONLY tnrs_match

-- Name: tnrs_match; Type: ACL; Schema: TNRS; Owner: bien

REVOKE ALL ON TABLE tnrs_match FROM PUBLIC;

REVOKE ALL ON TABLE tnrs_match FROM bien;

GRANT ALL ON TABLE tnrs_match TO bien;

GRANT SELECT ON TABLE tnrs_match TO bien_read;

COMMENT ON SCHEMA "public.test_taxonomic_names" IS 'Version: public (2014-6-25 16:26:50 PDT)';

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

--

CREATE FUNCTION analytical_stem_view_modify() RETURNS void

    LANGUAGE sql

    AS $_$

SELECT util.recreate($$

DROP TABLE IF EXISTS analytical_stem;

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

ALTER TABLE analytical_stem ADD COLUMN "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" serial PRIMARY KEY;

GRANT SELECT ON TABLE analytical_stem TO bien_read;

GRANT SELECT ON TABLE analytical_stem_view TO bien_read;

ALTER TABLE analytical_stem ALTER COLUMN "datasource__@Brad__.identifier_examples@vegpath.org" SET NOT NULL;

ALTER TABLE analytical_stem ALTER COLUMN "locationID__@DwC__@vegpath.org" SET NOT NULL;

CREATE INDEX ON analytical_stem ("datasource__@Brad__.identifier_examples@vegpath.org", "occurrenceID__@DwC__@vegpath.org");

CREATE INDEX ON analytical_stem ("datasource__@Brad__.identifier_examples@vegpath.org", "[custodial_]institutionCode[s]__@DwC__@vegpath.org", "collectionCode__@DwC__@vegpath.org", "catalogNumber__@DwC__@vegpath.org");

CREATE INDEX ON analytical_stem ("datasource__@Brad__.identifier_examples@vegpath.org", "projectID__@VegX__.plotObservation@vegpath.org", "locationID__@DwC__@vegpath.org", "eventDate__@DwC__@vegpath.org");

CREATE INDEX ON analytical_stem ("speciesBinomialWithMorphospecies__@VegCore__@vegpath.org");

$$);

$_$;

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

--

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

--

CREATE FUNCTION geoscrub_input_view_modify() RETURNS void

    LANGUAGE sql

    AS $$

DROP TABLE IF EXISTS geoscrub_input;

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

GRANT SELECT ON TABLE geoscrub_input TO bien_read;

GRANT SELECT ON TABLE geoscrub_input_view TO bien_read;

$$;

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

--

-- Name: lat_long_in_new_world(double precision, double precision); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien

--

CREATE FUNCTION lat_long_in_new_world(latitude_deg double precision, longitude_deg double precision) RETURNS boolean

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT util.lat_long_in_new_world($1, $2)

$_$;

ALTER FUNCTION "public.test_taxonomic_names".lat_long_in_new_world(latitude_deg double precision, longitude_deg double precision) OWNER TO bien;

--

-- Name: FUNCTION lat_long_in_new_world(latitude_deg double precision, longitude_deg double precision); Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON FUNCTION lat_long_in_new_world(latitude_deg double precision, longitude_deg double precision) IS '

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

';

--

-- Name: plot.**.modify(text, anyelement); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien

--

CREATE FUNCTION "plot.**.modify"(view_query text DEFAULT NULL::text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void

    LANGUAGE plpgsql

    AS $_$

/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime

changes of search_path (schema elements are bound at inline time rather than

runtime) */

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` to the current function */

BEGIN

	PERFORM util.use_schema(schema_anchor);

	PERFORM util.recreate_view('"plot.**"', $1);

END;

$_$;

ALTER FUNCTION "public.test_taxonomic_names"."plot.**.modify"(view_query text, schema_anchor anyelement) OWNER TO bien;

--

-- Name: FUNCTION "plot.**.modify"(view_query text, schema_anchor anyelement); Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON FUNCTION "plot.**.modify"(view_query text, schema_anchor anyelement) IS '

usage:

SELECT "plot.**.modify"($$

SELECT __

$$);

idempotent

';

--

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

--

CREATE FUNCTION provider_count_view_modify() RETURNS void

    LANGUAGE sql

    AS $$

DROP TABLE IF EXISTS provider_count;

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

GRANT SELECT ON TABLE provider_count TO bien_read;

GRANT SELECT ON TABLE provider_count TO public_;

GRANT SELECT ON TABLE provider_count_view TO bien_read;

GRANT SELECT ON TABLE provider_count_view TO public_;

ALTER TABLE provider_count ADD PRIMARY KEY (dataprovider, dataset);

$$;

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

--

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

CREATE FUNCTION taxon_trait_view_modify() RETURNS void

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

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

    "datasource__@Brad__.identifier_examples@vegpath.org" text NOT NULL,

    "country__@DwC__@vegpath.org" text,

    "stateProvince__@DwC__@vegpath.org" text,

    "county__@DwC__@vegpath.org" text,

    "locality__@DwC__@vegpath.org" text,

    "decimalLatitude__@DwC__@vegpath.org" double precision,

    "decimalLongitude__@DwC__@vegpath.org" double precision,

    "coordinateUncertaintyInMeters__@DwC__@vegpath.org" double precision,

    "georeferenceSources__@DwC__@vegpath.org" coordinatesource,

    "georeferenceProtocol__@DwC__@vegpath.org" text,

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

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

    "locationID__@DwC__@vegpath.org" text NOT NULL,

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

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

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

    "eventDate__@DwC__@vegpath.org" date,

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

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

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

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

    "samplingProtocol__@DwC__@vegpath.org" text,

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

    "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" double precision,

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

    "communityConcept.name__@VegX__.communityDet@vegpath.org" text[],

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

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

    "collectionCode__@DwC__@vegpath.org" text,

    "catalogNumber__@DwC__@vegpath.org" text,

    "occurrenceID__@DwC__@vegpath.org" text,

    "recordedBy__@DwC__@vegpath.org" text,

    "recordNumber__@DwC__@vegpath.org" text,

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

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

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

    "identifiedBy__@DwC__@vegpath.org" text,

    "dateIdentified__@DwC__@vegpath.org" date,

    "identificationRemarks__@DwC__@vegpath.org" text,

    "Family_matched__@TNRS__@vegpath.org" text,

    "Name_matched__@TNRS__@vegpath.org" text,

    "Name_matched_author__@TNRS__@vegpath.org" text,

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

    "taxonomicStatus__@DwC__@vegpath.org" text,

    "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" text,

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

    "reproductiveCondition__@DwC__@vegpath.org" text,

    "occurrenceRemarks__@DwC__@vegpath.org" text,

    "coverPercent__@VegX__.attribute.ordinal@vegpath.org" double precision,

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

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

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

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

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

    "individualID__@DwC__@vegpath.org" text,

    "individualCount__@DwC__@vegpath.org" integer,

    "stemCode__@VegBank__.stemLocation@vegpath.org" text,

    "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" integer NOT NULL

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

--

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

--

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

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

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

--

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

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

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

--

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

--

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

--

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

--

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

--

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

--

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

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

--

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

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."locationID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem.location__cultivated__bien; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem.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 analytical_stem."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

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

autogenerated ID for locationevent';

--

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

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

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

--

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

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

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

--

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

--

COMMENT ON COLUMN analytical_stem."[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 analytical_stem."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

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

--

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

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem."(-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 analytical_stem."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem."[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 analytical_stem."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem."[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 analytical_stem."identifiedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

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

--

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN analytical_stem."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 analytical_stem.scrubbed_family; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien

--

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

--

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

--

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

--

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

--