/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 5742

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/test_taxonomic_names/_scrub/public.test_taxonomic_names.sql, TNRS.sql: Regenerated with schema and mappings changes

     --
     CREATE TABLE tnrs (
         "Time_submitted" timestamp with time zone,
         "Name_number" text,
         "Name_submitted" text NOT NULL,
         "Overall_score" text,
-...
     -- Data for Name: tnrs; Type: TABLE DATA; Schema: TNRS; Owner: bien
     --
     COPY tnrs ("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") FROM stdin;
 	Poa annua L.	1	Poa annua	species	1	L.	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.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN	Poa annua	Poaceae	true	tropicos;usda	\N	\N
 	Poa annua var. annua	1	Poa annua var. annua	variety	1	\N	http://www.tropicos.org/Name/25517736	\N	\N	\N	\N	Poaceae	Poa	1	annua	1	var.	annua	1	\N	\N	\N	\N	\N	Accepted	Poa annua var. annua	\N	variety	http://www.tropicos.org/Name/25517736	Poa annua	Poaceae	true	tropicos	\N	\N
 	Poa infirma Kunth	1	Poa infirma	species	1	Kunth	http://www.tropicos.org/Name/25514158;http://plants.usda.gov/java/profile?symbol=POIN30	Kunth	1	\N	\N	Poaceae	Poa	1	infirma	1	\N	\N	\N	\N	\N	\N	\N	\N	Accepted	Poa infirma	Kunth	species	http://www.tropicos.org/Name/25514158;http://plants.usda.gov/java/profile?symbol=POIN30	Poa infirma	Poaceae	true	tropicos;usda	\N	\N
 	Asteraceae Bercht. & J. Presl	0.4	Asteraceae	family	0.5	\N	http://compositae.landcareresearch.co.nz/default.aspx;http://plants.usda.gov/java/nameSearch	\N	\N	Asteraceae	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Bercht. & J. Presl	Accepted	Asteraceae	\N	family	http://compositae.landcareresearch.co.nz/default.aspx;http://plants.usda.gov/java/nameSearch	\N	\N	true	gcc;usda	[Partial match]	\N
 	Compositae indet. sp.1	0.9	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	true	tropicos	\N	\N
 	Fabaceae Boyle#6500	0.9	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	\N
 	Fabaceae Inga "fuzzy leaf"	0.9	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	true	tropicos	\N	\N
 	Fabaceae Inga sp.3	0.9	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	true	tropicos	\N	\N
 	Fabaceae unknown #2	0.9	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	\N
 	Poa annua	1	Poa annua	species	1	L.	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.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN	Poa annua	Poaceae	true	tropicos;usda	\N	\N
 	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	true	tropicos	\N	\N
 	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	\N
 	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	true	tropicos	\N	\N
 	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	\N
 	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	true	tropicos	\N	\N
 	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	0.77	Silene scouleri subsp. pringlei	subspecies	0.77	(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	true	tropicos	[Partial match]	\N
 	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	0.77	Silene scouleri subsp. pringlei	subspecies	0.77	(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	true	tropicos	[Partial match]	\N
 	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	\N
 	No suitable matches found.	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	\N
     COPY tnrs ("Time_submitted", "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") FROM stdin;
 -10-23 11:03:17.984436-07	0	Asteraceae Bercht. & J. Presl	0.4	Asteraceae	family	0.5	Bercht. & J. Presl	http://www.tropicos.org/Name/50307371	\N	\N	Asteraceae	1	Asteraceae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Bercht. & J. Presl	Accepted	Asteraceae	Bercht. & J. Presl	family	http://www.tropicos.org/Name/50307371	\N	Asteraceae	true	tropicos	[Partial match]	\N
 -10-23 11:03:00.057419-07	7	Poa annua L.	1	Poa annua	species	1	L.	http://www.tropicos.org/Name/25509881	L.	1	\N	\N	Poaceae	Poa	1	annua	1	\N	\N	\N	\N	\N	\N	\N	\N	Accepted	Poa annua	L.	species	http://www.tropicos.org/Name/25509881	Poa annua	Poaceae	true	tropicos	\N	\N
 -10-23 11:03:17.984436-07	7	Poa annua var. annua	1	Poa annua var. annua	variety	1	\N	http://www.tropicos.org/Name/25517736	\N	\N	\N	\N	Poaceae	Poa	1	annua	1	var.	annua	1	\N	\N	\N	\N	\N	Accepted	Poa annua var. annua	\N	variety	http://www.tropicos.org/Name/25517736	Poa annua	Poaceae	true	tropicos	\N	\N
 -10-23 11:03:17.984436-07	8	Poa infirma Kunth	1	Poa infirma	species	1	Kunth	http://www.tropicos.org/Name/25514158	Kunth	1	\N	\N	Poaceae	Poa	1	infirma	1	\N	\N	\N	\N	\N	\N	\N	\N	Accepted	Poa infirma	Kunth	species	http://www.tropicos.org/Name/25514158	Poa infirma	Poaceae	true	tropicos	\N	\N
 -10-23 11:03:17.984436-07	1	Caryophyllaceae	1	Caryophyllaceae	family	1	Juss.	http://www.tropicos.org/Name/42000077	\N	\N	Caryophyllaceae	1	Caryophyllaceae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Accepted	Caryophyllaceae	Juss.	family	http://www.tropicos.org/Name/42000077	\N	Caryophyllaceae	true	tropicos	\N	\N
 -10-23 11:03:17.984436-07	2	Compositae	1	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	\N	Synonym	Asteraceae	Bercht. & J. Presl	family	http://www.tropicos.org/Name/50307371	\N	Asteraceae	true	tropicos	\N	\N
 -10-23 11:03:00.057419-07	0	Compositae indet. sp.1	0.9	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	true	tropicos	\N	\N
 -10-23 11:03:17.984436-07	3	Fabaceae	1	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	\N	Accepted	Fabaceae	Lindl.	family	http://www.tropicos.org/Name/42000184	\N	Fabaceae	true	tropicos	\N	\N
 -10-23 11:03:00.057419-07	1	Fabaceae Boyle#6500	0.9	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	\N
 -10-23 11:03:00.057419-07	2	Fabaceae Inga "fuzzy leaf"	0.9	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	true	tropicos	\N	\N
 -10-23 11:03:00.057419-07	3	Fabaceae Inga sp.3	0.9	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	true	tropicos	\N	\N
 -10-23 11:03:00.057419-07	4	Fabaceae unknown #2	0.9	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	\N
 -10-23 11:03:17.984436-07	4	Inga	1	Inga	genus	1	Mill.	http://www.tropicos.org/Name/40031040	\N	\N	\N	\N	Fabaceae	Inga	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Accepted	Inga	Mill.	genus	http://www.tropicos.org/Name/40031040	\N	Fabaceae	true	tropicos	\N	\N
 -10-23 11:03:17.984436-07	6	Poa	1	Poa	genus	1	L.	http://www.tropicos.org/Name/40012319	\N	\N	\N	\N	Poaceae	Poa	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Accepted	Poa	L.	genus	http://www.tropicos.org/Name/40012319	\N	Poaceae	true	tropicos	\N	\N
 -10-23 11:03:00.057419-07	6	Poa annua	1	Poa annua	species	1	L.	http://www.tropicos.org/Name/25509881	\N	\N	\N	\N	Poaceae	Poa	1	annua	1	\N	\N	\N	\N	\N	\N	\N	\N	Accepted	Poa annua	L.	species	http://www.tropicos.org/Name/25509881	Poa annua	Poaceae	true	tropicos	\N	\N
 -10-23 11:03:00.057419-07	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	true	tropicos	\N	\N
 -10-23 11:03:00.057419-07	9	Poa annua ssp. exilis	0.4	Poa	genus	0.4	L.	http://www.tropicos.org/Name/40012319	\N	\N	\N	\N	Poaceae	Poa	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	annua ssp. exilis	Accepted	Poa	L.	genus	http://www.tropicos.org/Name/40012319	\N	Poaceae	true	tropicos	[Partial match]	\N
 -10-23 11:03:00.057419-07	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	true	tropicos	\N	\N
 -10-23 11:03:00.057419-07	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	\N
 -10-23 11:03:00.057419-07	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	true	tropicos	\N	\N
 -10-23 11:03:17.984436-07	9	Poaceae	1	Poaceae	family	1	Barnhart	http://www.tropicos.org/Name/42000357	\N	\N	Poaceae	1	Poaceae	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Accepted	Poaceae	Barnhart	family	http://www.tropicos.org/Name/42000357	\N	Poaceae	true	tropicos	\N	\N
 -10-23 11:03:17.984436-07	10	Silene	1	Silene	genus	1	L.	http://www.tropicos.org/Name/40000236	\N	\N	\N	\N	Caryophyllaceae	Silene	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Accepted	Silene	L.	genus	http://www.tropicos.org/Name/40000236	\N	Caryophyllaceae	true	tropicos	\N	\N
 -10-23 11:03:00.057419-07	13	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	0.77	Silene scouleri subsp. pringlei	subspecies	0.77	(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	true	tropicos	[Partial match]	\N
 -10-23 11:03:00.057419-07	14	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	0.77	Silene scouleri subsp. pringlei	subspecies	0.77	(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	true	tropicos	[Partial match]	\N
 -10-23 11:03:00.057419-07	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	\N
 -10-23 11:03:17.984436-07	5	No suitable matches found.	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	\N
     \.

     ALTER FUNCTION "public.test_taxonomic_names"._fraction_to_percent(value double precision) OWNER TO bien;
     --
     -- Name: _has_taxonomic_name(taxonrank); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien
     --
     CREATE FUNCTION _has_taxonomic_name(rank taxonrank) RETURNS boolean
         LANGUAGE sql IMMUTABLE STRICT
         AS $_$
     SELECT $1 >= 'family'
     $_$;
     ALTER FUNCTION "public.test_taxonomic_names"._has_taxonomic_name(rank taxonrank) OWNER TO bien;
     --
     -- Name: _taxonlabel_set_matched_label_id(integer, integer, double precision); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien
     --
-...
     ALTER FUNCTION "public.test_taxonomic_names"._taxonlabel_set_parent_id(taxonlabel_id integer, parent_id integer) OWNER TO bien;
     --
     -- Name: _taxonomic_name_is_epithet(taxonrank); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien
     --
     CREATE FUNCTION _taxonomic_name_is_epithet(rank taxonrank) RETURNS boolean
         LANGUAGE sql IMMUTABLE STRICT
         AS $_$
     SELECT $1 <= 'genus'
     $_$;
     ALTER FUNCTION "public.test_taxonomic_names"._taxonomic_name_is_epithet(rank taxonrank) OWNER TO bien;
     --
     -- Name: make_analytical_db(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien
     --
-...
     ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_1_matched_label_min_fit() OWNER TO bien;
     --
     -- Name: taxonlabel_2_set_canon_label_id(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien
     -- Name: taxonlabel_2_set_canon_label_id_on_insert(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien
     --
     CREATE FUNCTION taxonlabel_2_set_canon_label_id() RETURNS trigger
     CREATE FUNCTION taxonlabel_2_set_canon_label_id_on_insert() RETURNS trigger
         LANGUAGE plpgsql
         AS $$
     BEGIN
         IF new.matched_label_id IS NOT NULL THEN
             IF new.matched_label_id = new.taxonlabel_id THEN -- self-reference
         new.canon_label_id = new.taxonlabel_id; -- make self-reference
         RETURN new;
     END;
     $$;
     ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_2_set_canon_label_id_on_insert() OWNER TO bien;
     --
     -- Name: taxonlabel_2_set_canon_label_id_on_update(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien
     --
     CREATE FUNCTION taxonlabel_2_set_canon_label_id_on_update() RETURNS trigger
         LANGUAGE plpgsql
         AS $$
     BEGIN
         IF new.matched_label_id IS DISTINCT FROM old.matched_label_id THEN
             IF new.matched_label_id IS NOT NULL THEN
                 IF new.matched_label_id = new.taxonlabel_id THEN -- self-reference
                     new.canon_label_id = new.taxonlabel_id; -- make self-reference
                 ELSE -- propagate from matched label
                     new.canon_label_id = (
                         SELECT canon_label_id
                         FROM taxonlabel
                         WHERE taxonlabel_id = new.matched_label_id
                     );
                 END IF;
                 -- Update canon_label_id on labels that resolve to this label
                 UPDATE taxonlabel
                 SET canon_label_id = new.canon_label_id
                 WHERE matched_label_id = new.taxonlabel_id
                 AND taxonlabel_id != new.taxonlabel_id -- avoid infinite recursion
+                ;
             ELSE -- no matched taxonlabel
                 new.canon_label_id = new.taxonlabel_id; -- make self-reference
             ELSE -- propagate from matched label
                 new.canon_label_id = (
                     SELECT canon_label_id
                     FROM taxonlabel
                     WHERE taxonlabel_id = new.matched_label_id
                 );
             END IF;
             -- Update canon_label_id on labels that resolve to this label
             UPDATE taxonlabel
             SET canon_label_id = new.canon_label_id
             WHERE matched_label_id = new.taxonlabel_id
             AND taxonlabel_id != new.taxonlabel_id -- avoid infinite recursion
+            ;
         ELSE -- no matched taxonlabel
             new.canon_label_id = new.taxonlabel_id; -- make self-reference
         END IF;
         RETURN new;
     END;
     $$;
     ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_2_set_canon_label_id() OWNER TO bien;
     ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_2_set_canon_label_id_on_update() OWNER TO bien;
     --
     -- Name: taxonlabel_3_parent_id_avoid_self_ref(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien
-...
     --
     CREATE VIEW analytical_db_view AS
         SELECT datasource.organizationname AS "dataSourceName", taxonverbatim.family, taxonverbatim.genus, taxonverbatim.species, COALESCE(taxonverbatim.taxonomicname, taxonverbatim.binomial) AS taxon, taxonverbatim.author AS "taxonAuthor", taxonverbatim.morphospecies AS "taxonMorphospecies", placepath.country, placepath.stateprovince AS "stateProvince", placepath.county AS "countyParish", taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS "collectionNumber", array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], ' '::text) AS "identifiedBy", aggregateoccurrence.collectiondate AS "observationDate", location.authorlocationcode AS "plotCode", functions._m2_to_ha(location.area_m2) AS "plotAreaHa", method.name AS "plotMethod", locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS "isCultivated", taxonoccurrence.cultivatedbasis AS "isCultivatedReason", _fraction_to_percent(aggregateoccurrence.cover_fraction) AS "pctCover" FROM (((((((((((((((location JOIN party datasource ON (((datasource.party_id = location.creator_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonverbatim ON ((taxonverbatim.taxonlabel_id = taxondetermination.taxonverbatim_id))) JOIN taxonlabel datasource_taxonlabel USING (taxonlabel_id)) JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
         SELECT datasource.organizationname AS "dataSourceName", taxonverbatim.family, taxonverbatim.genus, taxonverbatim.species, COALESCE(taxonverbatim.taxonomicname, taxonverbatim.binomial) AS taxon, taxonverbatim.author AS "taxonAuthor", taxonverbatim.morphospecies AS "taxonMorphospecies", placepath.country, placepath.stateprovince AS "stateProvince", placepath.county AS "countyParish", taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS "collectionNumber", array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], ' '::text) AS "identifiedBy", aggregateoccurrence.collectiondate AS "observationDate", location.authorlocationcode AS "plotCode", functions._m2_to_ha(location.area_m2) AS "plotAreaHa", method.name AS "plotMethod", locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS "isCultivated", taxonoccurrence.cultivatedbasis AS "isCultivatedReason", _fraction_to_percent(aggregateoccurrence.cover_fraction) AS "pctCover" FROM (((((((((((((((location JOIN party datasource ON (((datasource.party_id = location.creator_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonverbatim USING (taxonverbatim_id)) JOIN taxonlabel datasource_taxonlabel USING (taxonlabel_id)) JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
     ALTER TABLE "public.test_taxonomic_names".analytical_db_view OWNER TO bien;
-...
     -- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien
     --
     SELECT pg_catalog.setval('location_location_id_seq', 68, true);
     SELECT pg_catalog.setval('location_location_id_seq', 82, true);
     --
-...
     -- Name: locationevent_locationevent_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien
     --
     SELECT pg_catalog.setval('locationevent_locationevent_id_seq', 68, true);
     SELECT pg_catalog.setval('locationevent_locationevent_id_seq', 82, true);
     --
-...
     -- Name: party_party_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien
     --
     SELECT pg_catalog.setval('party_party_id_seq', 36, true);
     SELECT pg_catalog.setval('party_party_id_seq', 69, true);
     --
-...
     -- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien
     --
     SELECT pg_catalog.setval('taxondetermination_taxondetermination_id_seq', 34, true);
     SELECT pg_catalog.setval('taxondetermination_taxondetermination_id_seq', 41, true);
     --
-...
     -- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien
     --
     SELECT pg_catalog.setval('taxonlabel_taxonlabel_id_seq', 786, true);
     SELECT pg_catalog.setval('taxonlabel_taxonlabel_id_seq', 1085, true);
     --
-...
     -- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien
     --
     SELECT pg_catalog.setval('taxonoccurrence_taxonoccurrence_id_seq', 68, true);
     SELECT pg_catalog.setval('taxonoccurrence_taxonoccurrence_id_seq', 82, true);
     --
-...
     -- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien
     --
     SELECT pg_catalog.setval('taxonverbatim_taxonverbatim_id_seq', 110, true);
     SELECT pg_catalog.setval('taxonverbatim_taxonverbatim_id_seq', 145, true);
     --
-...
     COPY party (party_id, creator_id, fullname, salutation, givenname, middlename, surname, organizationname, currentname_id, contactinstructions, email, partytype, partypublic, d_obscount, accessioncode) FROM stdin;
 	1	\N	\N	\N	\N	\N	TNRS	\N	\N	\N	\N	t	\N	\N
 	2	\N	\N	\N	\N	\N	NCBI	\N	\N	\N	\N	t	\N	\N
 	21	\N	\N	\N	\N	\N	test_taxonomic_names	\N	\N	\N	\N	t	\N	\N
 	54	\N	\N	\N	\N	\N	test_taxonomic_names	\N	\N	\N	\N	t	\N	\N
     \.
-...
 	2	8	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	13	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	18	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	25	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	28	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	33	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	55	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	60	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	23	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	30	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	38	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	48	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	68	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	75	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	78	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	80	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	90	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	96	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	97	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	98	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	99	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	100	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	101	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	102	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	103	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	104	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	105	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	106	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	107	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	108	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	109	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	110	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	93	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	100	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	103	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	108	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	113	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	125	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	131	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	132	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	133	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	134	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	135	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	136	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	137	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	138	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	139	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	140	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	141	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	142	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	143	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	144	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
 	2	145	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N
     \.
-...
     --
     COPY taxonlabel (taxonlabel_id, creator_id, sourceaccessioncode, creationdate, taxonstatus, canon_label_id, matched_label_id, matched_label_fit_fraction, parent_id, taxonepithet, rank, taxonomicname, accessioncode) FROM stdin;
 	1	\N	\N	\N	2	\N	\N	\N	Poaceae	family	\N	\N
 	1	\N	\N	\N	4	\N	\N	2	Poa	genus	\N	\N
 	1	\N	\N	\N	6	\N	\N	4	annua	species	\N	\N
 	2	\N	\N	\N	19	\N	\N	\N	Poaceae	family	\N	\N
 	1	http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN	\N	Accepted	18	18	\N	6	\N	species	Poa annua L.	\N
 	1	\N	\N	\N	55	\N	\N	6	annua	variety	\N	\N
 	1	http://www.tropicos.org/Name/25517736	\N	Accepted	57	57	\N	55	\N	variety	Poa annua var. annua	\N
 	1	\N	\N	\N	84	\N	\N	4	infirma	species	\N	\N
 	1	http://www.tropicos.org/Name/25514158;http://plants.usda.gov/java/profile?symbol=POIN30	\N	Accepted	96	96	\N	84	\N	species	Poa infirma Kunth	\N
 	1	http://compositae.landcareresearch.co.nz/default.aspx;http://plants.usda.gov/java/nameSearch	\N	Accepted	135	135	\N	\N	\N	family	Asteraceae	\N
 	1	\N	\N	\N	135	135	1	\N	Bercht. & J. Presl	\N	Asteraceae Bercht. & J. Presl	\N
 	1	\N	\N	\N	158	\N	\N	\N	Compositae	family	\N	\N
 	2	\N	\N	\N	175	\N	\N	\N	Asteraceae	family	\N	\N
 	1	\N	\N	\N	175	175	\N	\N	Asteraceae	family	\N	\N
 	1	http://www.tropicos.org/Name/50255940	\N	Synonym	135	156	\N	158	\N	family	Compositae Giseke	\N
 	1	\N	\N	\N	135	174	1	\N	indet. sp.1	\N	Compositae indet. sp.1	\N
 	1	\N	\N	\N	197	\N	\N	\N	Fabaceae	family	\N	\N
 	2	\N	\N	\N	214	\N	\N	\N	Fabaceae	family	\N	\N
 	1	http://www.tropicos.org/Name/42000184	\N	Accepted	213	213	\N	197	\N	family	Fabaceae Lindl.	\N
 	1	\N	\N	\N	213	213	1	\N	Boyle#6500	\N	Fabaceae Boyle#6500	\N
 	1	\N	\N	\N	238	\N	\N	197	Inga	genus	\N	\N
 	1	http://www.tropicos.org/Name/40031040	\N	Accepted	252	252	\N	238	\N	genus	Inga Mill.	\N
 	1	\N	\N	\N	252	252	1	\N	"fuzzy leaf"	\N	Fabaceae Inga "fuzzy leaf"	\N
 	1	\N	\N	\N	252	252	1	\N	sp.3	\N	Fabaceae Inga sp.3	\N
 	1	\N	\N	\N	213	213	1	\N	unknown #2	\N	Fabaceae unknown #2	\N
 	1	\N	\N	\N	18	18	1	\N	\N	\N	Poa annua	\N
 	1	\N	\N	\N	406	\N	\N	6	lanuginosa	forma	\N	\N
 	1	http://www.tropicos.org/Name/50267771	\N	Synonym	57	57	\N	406	\N	forma	Poa annua fo. lanuginosa Sennen	\N
 	1	\N	\N	\N	57	408	1	\N	\N	\N	Poa annua fo. lanuginosa	\N
 	1	\N	\N	\N	445	\N	\N	6	exilis	subspecies	\N	\N
 	1	http://www.tropicos.org/Name/50063800	\N	Synonym	96	96	\N	445	\N	subspecies	Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.	\N
 	1	\N	\N	\N	96	447	1	\N	\N	\N	Poa annua ssp. exilis	\N
 	1	\N	\N	\N	96	447	1	\N	\N	\N	Poa annua subsp. exilis	\N
 	1	\N	\N	\N	523	\N	\N	6	minima	subvariety	\N	\N
 	1	http://www.tropicos.org/Name/50158097	\N	Accepted	525	525	\N	523	\N	subvariety	Poa annua subvar. minima (Schur) Asch. & Graebn.	\N
 	1	\N	\N	\N	525	525	1	\N	\N	\N	Poa annua subvar. minima	\N
 	1	\N	\N	\N	562	\N	\N	6	eriolepis	variety	\N	\N
 	1	http://www.tropicos.org/Name/50119145	\N	Synonym	18	18	\N	562	\N	variety	Poa annua var. eriolepis E. Desv.	\N
 	1	\N	\N	\N	18	564	1	\N	\N	\N	Poa annua var. eriolepis	\N
 	1	\N	\N	\N	587	\N	\N	\N	Caryophyllaceae	family	\N	\N
 	1	\N	\N	\N	589	\N	\N	587	Silene	genus	\N	\N
 	1	\N	\N	\N	591	\N	\N	589	scouleri	species	\N	\N
 	1	\N	\N	\N	601	\N	\N	591	pringlei	subspecies	\N	\N
 	2	\N	\N	\N	604	\N	\N	\N	Caryophyllaceae	family	\N	\N
 	1	http://www.tropicos.org/Name/6303627	\N	Accepted	603	603	\N	601	\N	subspecies	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	\N
 	1	\N	\N	\N	603	603	1	\N	var. grisea	\N	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	\N
 	1	\N	\N	\N	603	603	1	\N	var. grisea	\N	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	\N
 	1	\N	\N	\N	681	\N	\N	\N	\N	\N	No suitable matches found.	\N
 	1	\N	\N	\N	702	\N	\N	\N	\N	\N	Fam_indet. Boyle#6501	\N
 	21	1	\N	\N	18	390	\N	\N	\N	\N	Poa annua	\N
 	21	2	\N	\N	18	18	\N	\N	\N	\N	Poa annua L.	\N
 	21	3	\N	\N	18	585	\N	\N	\N	\N	Poa annua var. eriolepis	\N
 	21	4	\N	\N	96	507	\N	\N	\N	\N	Poa annua subsp. exilis	\N
 	21	5	\N	\N	96	468	\N	\N	\N	\N	Poa annua ssp. exilis	\N
 	21	6	\N	\N	525	546	\N	\N	\N	\N	Poa annua subvar. minima	\N
 	21	7	\N	\N	57	429	\N	\N	\N	\N	Poa annua fo. lanuginosa	\N
 	21	8	\N	\N	603	663	\N	\N	\N	\N	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	\N
 	21	9	\N	\N	603	624	\N	\N	\N	\N	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	\N
 	21	10	\N	\N	252	312	\N	\N	\N	\N	Fabaceae Inga sp.3	\N
 	21	11	\N	\N	252	273	\N	\N	\N	\N	Fabaceae Inga "fuzzy leaf"	\N
 	21	12	\N	\N	213	351	\N	\N	\N	\N	Fabaceae unknown #2	\N
 	21	13	\N	\N	213	234	\N	\N	\N	\N	Fabaceae Boyle#6500	\N
 	21	14	\N	\N	702	702	\N	\N	\N	\N	Fam_indet. Boyle#6501	\N
 	21	15	\N	\N	135	195	\N	\N	\N	\N	Compositae indet. sp.1	\N
 	2	\N	\N	\N	2	\N	\N	\N	\N	family	Asteraceae	\N
 	1	\N	\N	\N	4	2	\N	\N	Asteraceae	family	\N	\N
 	1	http://www.tropicos.org/Name/50307371	\N	Accepted	20	20	\N	4	\N	family	Asteraceae Bercht. & J. Presl	\N
 	2	\N	\N	\N	41	\N	\N	\N	\N	genus	Poa	\N
 	2	\N	\N	\N	42	\N	\N	\N	\N	family	Poaceae	\N
 	1	\N	\N	\N	44	42	\N	\N	Poaceae	family	\N	\N
 	1	\N	\N	\N	46	41	\N	44	Poa	genus	\N	\N
 	1	\N	\N	\N	48	\N	\N	46	annua	species	\N	\N
 	1	http://www.tropicos.org/Name/25509881	\N	Accepted	60	60	\N	48	\N	species	Poa annua L.	\N
 	1	\N	\N	\N	98	\N	\N	48	annua	variety	\N	\N
 	1	http://www.tropicos.org/Name/25517736	\N	Accepted	100	100	\N	98	\N	variety	Poa annua var. annua	\N
 	1	\N	\N	\N	128	\N	\N	46	infirma	species	\N	\N
 	1	http://www.tropicos.org/Name/25514158	\N	Accepted	140	140	\N	128	\N	species	Poa infirma Kunth	\N
 	2	\N	\N	\N	162	\N	\N	\N	\N	family	Caryophyllaceae	\N
 	1	\N	\N	\N	164	162	\N	\N	Caryophyllaceae	family	\N	\N
 	1	http://www.tropicos.org/Name/42000077	\N	Accepted	180	180	\N	164	\N	family	Caryophyllaceae Juss.	\N
 	1	\N	\N	\N	200	180	1	\N	\N	\N	Caryophyllaceae	\N
 	2	\N	\N	\N	202	\N	\N	\N	\N	family	Compositae	\N
 	1	\N	\N	\N	204	202	\N	\N	Compositae	family	\N	\N
 	1	http://www.tropicos.org/Name/50255940	\N	Synonym	20	20	\N	204	\N	family	Compositae Giseke	\N
 	1	\N	\N	\N	240	220	1	\N	\N	\N	Compositae	\N
 	1	\N	\N	\N	280	220	1	\N	indet. sp.1	\N	Compositae indet. sp.1	\N
 	2	\N	\N	\N	282	\N	\N	\N	\N	family	Fabaceae	\N
 	1	\N	\N	\N	284	282	\N	\N	Fabaceae	family	\N	\N
 	1	http://www.tropicos.org/Name/42000184	\N	Accepted	300	300	\N	284	\N	family	Fabaceae Lindl.	\N
 	1	\N	\N	\N	320	300	1	\N	\N	\N	Fabaceae	\N
 	1	\N	\N	\N	360	300	1	\N	Boyle#6500	\N	Fabaceae Boyle#6500	\N
 	2	\N	\N	\N	361	\N	\N	\N	\N	genus	Inga	\N
 	1	\N	\N	\N	366	361	\N	284	Inga	genus	\N	\N
 	1	http://www.tropicos.org/Name/40031040	\N	Accepted	380	380	\N	366	\N	genus	Inga Mill.	\N
 	1	\N	\N	\N	400	380	1	\N	"fuzzy leaf"	\N	Fabaceae Inga "fuzzy leaf"	\N
 	1	\N	\N	\N	440	380	1	\N	sp.3	\N	Fabaceae Inga sp.3	\N
 	1	\N	\N	\N	480	300	1	\N	unknown #2	\N	Fabaceae unknown #2	\N
 	1	\N	\N	\N	520	380	1	\N	\N	\N	Inga	\N
 	1	http://www.tropicos.org/Name/40012319	\N	Accepted	540	540	\N	46	\N	genus	Poa L.	\N
 	1	\N	\N	\N	560	540	1	\N	\N	\N	Poa	\N
 	1	\N	\N	\N	600	60	1	\N	\N	\N	Poa annua	\N
 	1	\N	\N	\N	618	\N	\N	48	lanuginosa	forma	\N	\N
 	1	http://www.tropicos.org/Name/50267771	\N	Synonym	100	100	\N	618	\N	forma	Poa annua fo. lanuginosa Sennen	\N
 	1	\N	\N	\N	640	620	1	\N	\N	\N	Poa annua fo. lanuginosa	\N
 	1	\N	\N	\N	680	540	1	\N	annua ssp. exilis	\N	Poa annua ssp. exilis	\N
 	1	\N	\N	\N	698	\N	\N	48	exilis	subspecies	\N	\N
 	1	http://www.tropicos.org/Name/50063800	\N	Synonym	140	140	\N	698	\N	subspecies	Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.	\N
 	1	\N	\N	\N	720	700	1	\N	\N	\N	Poa annua subsp. exilis	\N
 	1	\N	\N	\N	738	\N	\N	48	minima	subvariety	\N	\N
 	1	http://www.tropicos.org/Name/50158097	\N	Accepted	740	740	\N	738	\N	subvariety	Poa annua subvar. minima (Schur) Asch. & Graebn.	\N
 	1	\N	\N	\N	760	740	1	\N	\N	\N	Poa annua subvar. minima	\N
 	1	\N	\N	\N	778	\N	\N	48	eriolepis	variety	\N	\N
 	1	http://www.tropicos.org/Name/50119145	\N	Synonym	60	60	\N	778	\N	variety	Poa annua var. eriolepis E. Desv.	\N
 	1	\N	\N	\N	800	780	1	\N	\N	\N	Poa annua var. eriolepis	\N
 	1	http://www.tropicos.org/Name/42000357	\N	Accepted	820	820	\N	44	\N	family	Poaceae Barnhart	\N
 	1	\N	\N	\N	840	820	1	\N	\N	\N	Poaceae	\N
 	2	\N	\N	\N	841	\N	\N	\N	\N	genus	Silene	\N
 	1	\N	\N	\N	846	841	\N	164	Silene	genus	\N	\N
 	1	http://www.tropicos.org/Name/40000236	\N	Accepted	860	860	\N	846	\N	genus	Silene L.	\N
 	1	\N	\N	\N	880	860	1	\N	\N	\N	Silene	\N
 	1	\N	\N	\N	888	\N	\N	846	scouleri	species	\N	\N
 	1	\N	\N	\N	898	\N	\N	888	pringlei	subspecies	\N	\N
 	1	http://www.tropicos.org/Name/6303627	\N	Accepted	900	900	\N	898	\N	subspecies	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	\N
 	1	\N	\N	\N	920	900	1	\N	var. grisea	\N	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	\N
 	1	\N	\N	\N	960	900	1	\N	var. grisea	\N	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	\N
 	1	\N	\N	\N	980	\N	\N	\N	\N	\N	No suitable matches found.	\N
 	1	\N	\N	\N	1000	\N	\N	\N	\N	\N	Fam_indet. Boyle#6501	\N
 	54	1	\N	\N	1043	600	\N	\N	\N	\N	Poa annua	\N
 	54	2	\N	\N	1046	60	\N	\N	\N	\N	Poa annua L.	\N
 	54	3	\N	\N	1049	800	\N	\N	\N	\N	Poa annua var. eriolepis	\N
 	54	4	\N	\N	1052	720	\N	\N	\N	\N	Poa annua subsp. exilis	\N
 	54	5	\N	\N	1055	680	\N	\N	\N	\N	Poa annua ssp. exilis	\N
 	54	6	\N	\N	1058	760	\N	\N	\N	\N	Poa annua subvar. minima	\N
 	54	7	\N	\N	1061	640	\N	\N	\N	\N	Poa annua fo. lanuginosa	\N
 	54	8	\N	\N	1064	960	\N	\N	\N	\N	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	\N
 	54	9	\N	\N	1067	920	\N	\N	\N	\N	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	\N
 	54	10	\N	\N	1070	440	\N	\N	\N	\N	Fabaceae Inga sp.3	\N
 	54	11	\N	\N	1073	400	\N	\N	\N	\N	Fabaceae Inga "fuzzy leaf"	\N
 	54	12	\N	\N	1076	480	\N	\N	\N	\N	Fabaceae unknown #2	\N
 	54	13	\N	\N	1079	360	\N	\N	\N	\N	Fabaceae Boyle#6500	\N
 	54	14	\N	\N	1082	1000	\N	\N	\N	\N	Fam_indet. Boyle#6501	\N
 	54	15	\N	\N	1085	280	\N	\N	\N	\N	Compositae indet. sp.1	\N
     \.
-...
 	2	is included in
 	4	is included in
 	2	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	18	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	19	is included in
 	55	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	57	is included in
 	55	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	84	is included in
 	4	is included in
 	2	is included in
 	96	is included in
 	84	is included in
 	4	is included in
 	2	is included in
 	135	is included in
 	156	is included in
 	135	is included in
 	158	is included in
 	174	is included in
 	175	is included in
 	177	is included in
 	175	is included in
 	156	is included in
 	135	is included in
 	195	is included in
 	174	is included in
 	156	is included in
 	135	is included in
 	197	is included in
 	213	is included in
 	197	is included in
 	214	is included in
 	234	is included in
 	213	is included in
 	197	is included in
 	238	is included in
 	197	is included in
 	252	is included in
 	238	is included in
 	197	is included in
 	273	is included in
 	252	is included in
 	238	is included in
 	197	is included in
 	312	is included in
 	252	is included in
 	238	is included in
 	197	is included in
 	351	is included in
 	213	is included in
 	197	is included in
 	390	is included in
 	18	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	406	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	408	is included in
 	57	is included in
 	55	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	429	is included in
 	408	is included in
 	57	is included in
 	55	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	445	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	447	is included in
 	96	is included in
 	84	is included in
 	4	is included in
 	2	is included in
 	468	is included in
 	447	is included in
 	96	is included in
 	84	is included in
 	4	is included in
 	2	is included in
 	507	is included in
 	447	is included in
 	96	is included in
 	84	is included in
 	4	is included in
 	2	is included in
 	523	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	525	is included in
 	523	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	546	is included in
 	525	is included in
 	523	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	562	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	564	is included in
 	18	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	585	is included in
 	564	is included in
 	18	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	587	is included in
 	589	is included in
 	587	is included in
 	591	is included in
 	589	is included in
 	587	is included in
 	601	is included in
 	591	is included in
 	589	is included in
 	587	is included in
 	603	is included in
 	601	is included in
 	591	is included in
 	589	is included in
 	587	is included in
 	604	is included in
 	624	is included in
 	603	is included in
 	601	is included in
 	591	is included in
 	589	is included in
 	587	is included in
 	663	is included in
 	603	is included in
 	601	is included in
 	591	is included in
 	589	is included in
 	587	is included in
 	681	is included in
 	702	is included in
 	744	is included in
 	390	is included in
 	18	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	747	is included in
 	18	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	750	is included in
 	585	is included in
 	564	is included in
 	18	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	753	is included in
 	507	is included in
 	447	is included in
 	96	is included in
 	84	is included in
 	4	is included in
 	2	is included in
 	756	is included in
 	468	is included in
 	447	is included in
 	96	is included in
 	84	is included in
 	4	is included in
 	2	is included in
 	759	is included in
 	546	is included in
 	525	is included in
 	523	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	762	is included in
 	429	is included in
 	408	is included in
 	57	is included in
 	55	is included in
 	6	is included in
 	4	is included in
 	2	is included in
 	765	is included in
 	663	is included in
 	603	is included in
 	601	is included in
 	591	is included in
 	589	is included in
 	587	is included in
 	768	is included in
 	624	is included in
 	603	is included in
 	601	is included in
 	591	is included in
 	589	is included in
 	587	is included in
 	771	is included in
 	312	is included in
 	252	is included in
 	238	is included in
 	197	is included in
 	774	is included in
 	273	is included in
 	252	is included in
 	238	is included in
 	197	is included in
 	777	is included in
 	351	is included in
 	213	is included in
 	197	is included in
 	20	is included in
 	4	is included in
 	2	is included in
 	41	is included in
 	42	is included in
 	44	is included in
 	42	is included in
 	46	is included in
 	41	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	60	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	98	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	100	is included in
 	98	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	128	is included in
 	46	is included in
 	41	is included in
 	140	is included in
 	128	is included in
 	46	is included in
 	41	is included in
 	162	is included in
 	164	is included in
 	162	is included in
 	180	is included in
 	164	is included in
 	162	is included in
 	200	is included in
 	180	is included in
 	164	is included in
 	162	is included in
 	202	is included in
 	204	is included in
 	202	is included in
 	220	is included in
 	20	is included in
 	4	is included in
 	2	is included in
 	240	is included in
 	220	is included in
 	20	is included in
 	4	is included in
 	2	is included in
 	280	is included in
 	220	is included in
 	20	is included in
 	4	is included in
 	2	is included in
 	282	is included in
 	284	is included in
 	282	is included in
 	300	is included in
 	284	is included in
 	282	is included in
 	320	is included in
 	300	is included in
 	284	is included in
 	282	is included in
 	360	is included in
 	300	is included in
 	284	is included in
 	282	is included in
 	361	is included in
 	366	is included in
 	361	is included in
 	380	is included in
 	366	is included in
 	361	is included in
 	400	is included in
 	380	is included in
 	366	is included in
 	361	is included in
 	440	is included in
 	380	is included in
 	366	is included in
 	361	is included in
 	480	is included in
 	300	is included in
 	284	is included in
 	282	is included in
 	520	is included in
 	380	is included in
 	366	is included in
 	361	is included in
 	540	is included in
 	46	is included in
 	41	is included in
 	560	is included in
 	540	is included in
 	46	is included in
 	41	is included in
 	600	is included in
 	60	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	618	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	620	is included in
 	100	is included in
 	98	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	640	is included in
 	620	is included in
 	100	is included in
 	98	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	680	is included in
 	540	is included in
 	46	is included in
 	41	is included in
 	698	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	700	is included in
 	140	is included in
 	128	is included in
 	46	is included in
 	41	is included in
 	720	is included in
 	700	is included in
 	140	is included in
 	128	is included in
 	46	is included in
 	41	is included in
 	738	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	740	is included in
 	738	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	760	is included in
 	740	is included in
 	738	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	778	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	780	is included in
 	234	is included in
 	213	is included in
 	197	is included in
 	783	is included in
 	702	is included in
 	786	is included in
 	195	is included in
 	174	is included in
 	156	is included in
 	135	is included in
 	60	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	800	is included in
 	780	is included in
 	60	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	820	is included in
 	44	is included in
 	42	is included in
 	840	is included in
 	820	is included in
 	44	is included in
 	42	is included in
 	841	is included in
 	846	is included in
 	841	is included in
 	860	is included in
 	846	is included in
 	841	is included in
 	880	is included in
 	860	is included in
 	846	is included in
 	841	is included in
 	888	is included in
 	846	is included in
 	841	is included in
 	898	is included in
 	888	is included in
 	846	is included in
 	841	is included in
 	900	is included in
 	898	is included in
 	888	is included in
 	846	is included in
 	841	is included in
 	920	is included in
 	900	is included in
 	898	is included in
 	888	is included in
 	846	is included in
 	841	is included in
 	960	is included in
 	900	is included in
 	898	is included in
 	888	is included in
 	846	is included in
 	841	is included in
 	980	is included in
 	1000	is included in
 	1043	is included in
 	600	is included in
 	60	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	1046	is included in
 	60	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	1049	is included in
 	800	is included in
 	780	is included in
 	60	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	1052	is included in
 	720	is included in
 	700	is included in
 	140	is included in
 	128	is included in
 	46	is included in
 	41	is included in
 	1055	is included in
 	680	is included in
 	540	is included in
 	46	is included in
 	41	is included in
 	1058	is included in
 	760	is included in
 	740	is included in
 	738	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	1061	is included in
 	640	is included in
 	620	is included in
 	100	is included in
 	98	is included in
 	48	is included in
 	46	is included in
 	41	is included in
 	1064	is included in
 	960	is included in
 	900	is included in
 	898	is included in
 	888	is included in
 	846	is included in
 	841	is included in
 	1067	is included in
 	920	is included in
 	900	is included in
 	898	is included in
 	888	is included in
 	846	is included in
 	841	is included in
 	1070	is included in
 	440	is included in
 	380	is included in
 	366	is included in
 	361	is included in
 	1073	is included in
 	400	is included in
 	380	is included in
 	366	is included in
 	361	is included in
 	1076	is included in
 	480	is included in
 	300	is included in
 	284	is included in
 	282	is included in
 	1079	is included in
 	360	is included in
 	300	is included in
 	284	is included in
 	282	is included in
 	1082	is included in
 	1000	is included in
 	1085	is included in
 	280	is included in
 	220	is included in
 	20	is included in
 	4	is included in
 	2	is included in
     \.
-...
     --
     COPY taxonverbatim (taxonverbatim_id, taxonlabel_id, verbatimrank, taxonomicname, binomial, author, family, genus, species, morphospecies, description) FROM stdin;
 	6	species	\N	\N	\N	\N	\N	\N	\N	\N
 	2	species	\N	\N	\N	\N	\N	\N	\N	\N
 	18	species	\N	Poa annua	L.	Poaceae	\N	\N	\N	\N
 	55	variety	\N	\N	\N	\N	\N	\N	\N	\N
 	57	variety	\N	Poa annua var. annua	\N	Poaceae	\N	\N	\N	\N
 	84	species	\N	\N	\N	\N	\N	\N	\N	\N
 	96	species	\N	Poa infirma	Kunth	Poaceae	\N	\N	\N	\N
 	135	family	\N	Asteraceae	\N	\N	\N	\N	\N	\N
 	156	\N	\N	Asteraceae	\N	Asteraceae	\N	\N	Bercht. & J. Presl	\N
 	158	family	\N	\N	\N	\N	\N	\N	\N	\N
 	177	family	\N	\N	\N	\N	\N	\N	\N	\N
 	195	\N	\N	Compositae	\N	Compositae	\N	\N	indet. sp.1	\N
 	174	family	\N	Compositae	Giseke	Compositae	\N	\N	\N	\N
 	197	family	\N	\N	\N	\N	\N	\N	\N	\N
 	213	family	\N	Fabaceae	Lindl.	Fabaceae	\N	\N	\N	\N
 	234	\N	\N	Fabaceae	\N	Fabaceae	\N	\N	Boyle#6500	\N
 	238	genus	\N	\N	\N	\N	\N	\N	\N	\N
 	252	genus	\N	Inga	Mill.	Fabaceae	\N	\N	\N	\N
 	273	\N	\N	Inga	\N	Fabaceae	Inga	\N	"fuzzy leaf"	\N
 	312	\N	\N	Inga	\N	Fabaceae	Inga	\N	sp.3	\N
 	351	\N	\N	Fabaceae	\N	Fabaceae	\N	\N	unknown #2	\N
 	390	\N	\N	Poa annua	\N	\N	Poa	annua	\N	\N
 	406	forma	\N	\N	\N	\N	\N	\N	\N	\N
 	429	fo.	\N	Poa annua fo. lanuginosa	\N	\N	Poa	annua	\N	\N
 	408	forma	\N	Poa annua fo. lanuginosa	Sennen	Poaceae	Poa	annua	\N	\N
 	445	subspecies	\N	\N	\N	\N	\N	\N	\N	\N
 	468	subsp.	\N	Poa annua subsp. exilis	\N	\N	Poa	annua	\N	\N
 	447	subspecies	\N	Poa annua subsp. exilis	(Tomm. ex Freyn) Asch. & Graebn.	Poaceae	Poa	annua	\N	\N
 	507	subsp.	\N	Poa annua subsp. exilis	\N	\N	Poa	annua	\N	\N
 	523	subvariety	\N	\N	\N	\N	\N	\N	\N	\N
 	525	subvariety	\N	Poa annua subvar. minima	(Schur) Asch. & Graebn.	Poaceae	\N	\N	\N	\N
 	546	subvar.	\N	Poa annua subvar. minima	\N	\N	Poa	annua	\N	\N
 	562	variety	\N	\N	\N	\N	\N	\N	\N	\N
 	585	var.	\N	Poa annua var. eriolepis	\N	\N	Poa	annua	\N	\N
 	564	variety	\N	Poa annua var. eriolepis	E. Desv.	Poaceae	Poa	annua	\N	\N
 	601	subspecies	\N	\N	\N	\N	\N	\N	\N	\N
 	587	subspecies	\N	\N	\N	\N	\N	\N	\N	\N
 	603	subspecies	\N	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	Caryophyllaceae	\N	\N	\N	\N
 	624	subsp.	\N	Silene scouleri subsp. pringlei	\N	\N	Silene	scouleri	var. grisea	\N
 	663	subsp.	\N	Silene scouleri subsp. pringlei	\N	\N	Silene	scouleri	var. grisea	\N
 	702	\N	\N	No suitable matches found.	\N	\N	\N	\N	\N	\N
 	681	\N	\N	No suitable matches found.	\N	\N	\N	\N	\N	\N
 	744	\N	\N	Poa annua	\N	\N	\N	\N	\N	\N
 	747	\N	\N	Poa annua L.	\N	\N	\N	\N	\N	\N
 	750	\N	\N	Poa annua var. eriolepis	\N	\N	\N	\N	\N	\N
 	753	\N	\N	Poa annua subsp. exilis	\N	\N	\N	\N	\N	\N
 	756	\N	\N	Poa annua ssp. exilis	\N	\N	\N	\N	\N	\N
 	759	\N	\N	Poa annua subvar. minima	\N	\N	\N	\N	\N	\N
 	762	\N	\N	Poa annua fo. lanuginosa	\N	\N	\N	\N	\N	\N
 	765	\N	\N	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	\N	\N	\N	\N	\N	\N
 	768	\N	\N	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	\N	\N	\N	\N	\N	\N
 	771	\N	\N	Fabaceae Inga sp.3	\N	\N	\N	\N	\N	\N
 	774	\N	\N	Fabaceae Inga "fuzzy leaf"	\N	\N	\N	\N	\N	\N
 	777	\N	\N	Fabaceae unknown #2	\N	\N	\N	\N	\N	\N
 	780	\N	\N	Fabaceae Boyle#6500	\N	\N	\N	\N	\N	\N
 	783	\N	\N	Fam_indet. Boyle#6501	\N	\N	\N	\N	\N	\N
 	786	\N	\N	Compositae indet. sp.1	\N	\N	\N	\N	\N	\N
 	4	family	\N	\N	\N	\N	\N	\N	\N	\N
 	20	family	\N	Asteraceae	Bercht. & J. Presl	Asteraceae	\N	\N	\N	\N
 	48	species	\N	\N	\N	\N	\N	\N	\N	\N
 	44	species	\N	\N	\N	\N	\N	\N	\N	\N
 	60	species	\N	Poa annua	L.	Poaceae	\N	\N	\N	\N
 	98	variety	\N	\N	\N	\N	\N	\N	\N	\N
 	100	variety	\N	Poa annua var. annua	\N	Poaceae	\N	\N	\N	\N
 	128	species	\N	\N	\N	\N	\N	\N	\N	\N
 	140	species	\N	Poa infirma	Kunth	Poaceae	\N	\N	\N	\N
 	164	family	\N	\N	\N	\N	\N	\N	\N	\N
 	180	family	\N	Caryophyllaceae	Juss.	Caryophyllaceae	\N	\N	\N	\N
 	200	\N	\N	Caryophyllaceae	\N	Caryophyllaceae	\N	\N	\N	\N
 	204	family	\N	\N	\N	\N	\N	\N	\N	\N
 	240	\N	\N	Compositae	\N	Compositae	\N	\N	\N	\N
 	220	family	\N	Compositae	Giseke	Compositae	\N	\N	\N	\N
 	280	\N	\N	Compositae	\N	Compositae	\N	\N	indet. sp.1	\N
 	284	family	\N	\N	\N	\N	\N	\N	\N	\N
 	300	family	\N	Fabaceae	Lindl.	Fabaceae	\N	\N	\N	\N
 	320	\N	\N	Fabaceae	\N	Fabaceae	\N	\N	\N	\N
 	360	\N	\N	Fabaceae	\N	Fabaceae	\N	\N	Boyle#6500	\N
 	366	genus	\N	\N	\N	\N	\N	\N	\N	\N
 	380	genus	\N	Inga	Mill.	Fabaceae	\N	\N	\N	\N
 	400	\N	\N	Inga	\N	Fabaceae	Inga	\N	"fuzzy leaf"	\N
 	440	\N	\N	Inga	\N	Fabaceae	Inga	\N	sp.3	\N
 	480	\N	\N	Fabaceae	\N	Fabaceae	\N	\N	unknown #2	\N
 	520	\N	\N	Inga	\N	\N	Inga	\N	\N	\N
 	46	genus	\N	\N	\N	\N	\N	\N	\N	\N
 	540	genus	\N	Poa	L.	Poaceae	\N	\N	\N	\N
 	560	\N	\N	Poa	\N	\N	Poa	\N	\N	\N
 	600	\N	\N	Poa annua	\N	\N	Poa	annua	\N	\N
 	618	forma	\N	\N	\N	\N	\N	\N	\N	\N
 	640	fo.	\N	Poa annua fo. lanuginosa	\N	\N	Poa	annua	\N	\N
 	620	forma	\N	Poa annua fo. lanuginosa	Sennen	Poaceae	Poa	annua	\N	\N
 	680	\N	\N	Poa	\N	\N	Poa	\N	annua ssp. exilis	\N
 	698	subspecies	\N	\N	\N	\N	\N	\N	\N	\N
 	720	subsp.	\N	Poa annua subsp. exilis	\N	\N	Poa	annua	\N	\N
 	700	subspecies	\N	Poa annua subsp. exilis	(Tomm. ex Freyn) Asch. & Graebn.	Poaceae	Poa	annua	\N	\N
 	738	subvariety	\N	\N	\N	\N	\N	\N	\N	\N
 	740	subvariety	\N	Poa annua subvar. minima	(Schur) Asch. & Graebn.	Poaceae	\N	\N	\N	\N
 	760	subvar.	\N	Poa annua subvar. minima	\N	\N	Poa	annua	\N	\N
 	778	variety	\N	\N	\N	\N	\N	\N	\N	\N
 	800	var.	\N	Poa annua var. eriolepis	\N	\N	Poa	annua	\N	\N
 	780	variety	\N	Poa annua var. eriolepis	E. Desv.	Poaceae	Poa	annua	\N	\N
 	820	family	\N	Poaceae	Barnhart	Poaceae	\N	\N	\N	\N
 	840	\N	\N	Poaceae	\N	Poaceae	\N	\N	\N	\N
 	846	genus	\N	\N	\N	\N	\N	\N	\N	\N
 	860	genus	\N	Silene	L.	Caryophyllaceae	\N	\N	\N	\N
 	880	\N	\N	Silene	\N	\N	Silene	\N	\N	\N
 	898	subspecies	\N	\N	\N	\N	\N	\N	\N	\N
 	900	subspecies	\N	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	Caryophyllaceae	\N	\N	\N	\N
 	920	subsp.	\N	Silene scouleri subsp. pringlei	\N	\N	Silene	scouleri	var. grisea	\N
 	960	subsp.	\N	Silene scouleri subsp. pringlei	\N	\N	Silene	scouleri	var. grisea	\N
 	1000	\N	\N	No suitable matches found.	\N	\N	\N	\N	\N	\N
 	980	\N	\N	No suitable matches found.	\N	\N	\N	\N	\N	\N
 	1043	\N	\N	Poa annua	\N	\N	\N	\N	\N	\N
 	1046	\N	\N	Poa annua L.	\N	\N	\N	\N	\N	\N
 	1049	\N	\N	Poa annua var. eriolepis	\N	\N	\N	\N	\N	\N
 	1052	\N	\N	Poa annua subsp. exilis	\N	\N	\N	\N	\N	\N
 	1055	\N	\N	Poa annua ssp. exilis	\N	\N	\N	\N	\N	\N
 	1058	\N	\N	Poa annua subvar. minima	\N	\N	\N	\N	\N	\N
 	1061	\N	\N	Poa annua fo. lanuginosa	\N	\N	\N	\N	\N	\N
 	1064	\N	\N	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	\N	\N	\N	\N	\N	\N
 	1067	\N	\N	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	\N	\N	\N	\N	\N	\N
 	1070	\N	\N	Fabaceae Inga sp.3	\N	\N	\N	\N	\N	\N
 	1073	\N	\N	Fabaceae Inga "fuzzy leaf"	\N	\N	\N	\N	\N	\N
 	1076	\N	\N	Fabaceae unknown #2	\N	\N	\N	\N	\N	\N
 	1079	\N	\N	Fabaceae Boyle#6500	\N	\N	\N	\N	\N	\N
 	1082	\N	\N	Fam_indet. Boyle#6501	\N	\N	\N	\N	\N	\N
 	1085	\N	\N	Compositae indet. sp.1	\N	\N	\N	\N	\N	\N
     \.
-...
     --
     -- Name: taxonlabel_2_set_canon_label_id; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien
     -- Name: taxonlabel_2_set_canon_label_id_on_insert; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien
     --
     CREATE TRIGGER taxonlabel_2_set_canon_label_id BEFORE INSERT OR UPDATE ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_2_set_canon_label_id();
     CREATE TRIGGER taxonlabel_2_set_canon_label_id_on_insert BEFORE INSERT ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_2_set_canon_label_id_on_insert();
     --
     -- Name: taxonlabel_2_set_canon_label_id_on_update; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien
     --
     CREATE TRIGGER taxonlabel_2_set_canon_label_id_on_update BEFORE UPDATE ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_2_set_canon_label_id_on_update();
     --
     -- Name: taxonlabel_3_parent_id_avoid_self_ref; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien
     --

Also available in: Unified diff

Project

General

Profile

Revision 5742

Added by Aaron Marcuse-Kubitza about 12 years ago