Project

General

Profile

« Previous | Next » 

Revision 5804

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

View differences:

inputs/test_taxonomic_names/_scrub/TNRS.sql
20 20 

  		




  21
  21
  
    
SET search_path = "TNRS", pg_catalog;


  		




  22
  22
  
    

  		




  
  23
  
    
--


  		




  
  24
  
    
-- Name: array_to_string(anyarray, text); Type: FUNCTION; Schema: TNRS; Owner: bien


  		




  
  25
  
    
--


  		




  
  26
  
    

  		




  
  27
  
    
CREATE FUNCTION array_to_string(anyarray, text) RETURNS text


  		




  
  28
  
    
    LANGUAGE sql IMMUTABLE STRICT


  		




  
  29
  
    
    AS $_$


  		




  
  30
  
    
SELECT pg_catalog.array_to_string($1, $2)


  		




  
  31
  
    
$_$;


  		




  
  32
  
    

  		




  
  33
  
    

  		




  
  34
  
    
ALTER FUNCTION "TNRS".array_to_string(anyarray, text) OWNER TO bien;


  		




  
  35
  
    

  		




  23
  36
  
    
SET default_tablespace = '';


  		




  24
  37
  
    

  		




  25
  38
  
    
SET default_with_oids = false;


  		




  ......




  85
  98
  
    
--


  		




  86
  99
  
    

  		




  87
  100
  
    
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;


  		




  88
  
  
    
2012-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


  		




  89
  
  
    
2012-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


  		




  90
  
  
    
2012-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


  		




  91
  
  
    
2012-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


  		




  92
  
  
    
2012-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


  		




  93
  
  
    
2012-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


  		




  94
  
  
    
2012-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


  		




  95
  
  
    
2012-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


  		




  96
  
  
    
2012-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


  		




  97
  
  
    
2012-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


  		




  98
  
  
    
2012-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


  		




  99
  
  
    
2012-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


  		




  100
  
  
    
2012-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


  		




  101
  
  
    
2012-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


  		




  102
  
  
    
2012-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


  		




  103
  
  
    
2012-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


  		




  104
  
  
    
2012-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


  		




  105
  
  
    
2012-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


  		




  106
  
  
    
2012-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


  		




  107
  
  
    
2012-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


  		




  108
  
  
    
2012-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


  		




  109
  
  
    
2012-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


  		




  110
  
  
    
2012-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


  		




  111
  
  
    
2012-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


  		




  112
  
  
    
2012-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


  		




  113
  
  
    
2012-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


  		




  
  101
  
    
2012-10-26 15:04:15.502163-07	0	Asteraceae 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	Asteraceae Bercht. & J. Presl	Accepted	Asteraceae	Bercht. & J. Presl	family	http://www.tropicos.org/Name/50307371	\N	Asteraceae	true	tropicos	 [Partial match] 	\N


  		




  
  102
  
    
2012-10-26 15:04:15.502163-07	8	Poaceae Poa annua var. annua	1	Poa annua var. annua	variety	1	\N	http://www.tropicos.org/Name/25517736	\N	\N	Poaceae	1	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


  		




  
  103
  
    
2012-10-26 15:04:15.502163-07	9	Poaceae Poa infirma Kunth	1	Poa infirma	species	1	Kunth	http://www.tropicos.org/Name/25514158	Kunth	1	Poaceae	1	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


  		




  
  104
  
    
2012-10-26 15:04:15.502163-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


  		




  
  105
  
    
2012-10-26 15:04:15.502163-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


  		




  
  106
  
    
2012-10-26 15:03:59.419728-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


  		




  
  107
  
    
2012-10-26 15:04:15.502163-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


  		




  
  108
  
    
2012-10-26 15:03:59.419728-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


  		




  
  109
  
    
2012-10-26 15:03:59.419728-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


  		




  
  110
  
    
2012-10-26 15:03:59.419728-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


  		




  
  111
  
    
2012-10-26 15:03:59.419728-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


  		




  
  112
  
    
2012-10-26 15:04:15.502163-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


  		




  
  113
  
    
2012-10-26 15:04:15.502163-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


  		




  
  114
  
    
2012-10-26 15:03:59.419728-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


  		




  
  115
  
    
2012-10-26 15:03:59.419728-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


  		




  
  116
  
    
2012-10-26 15:03:59.419728-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


  		




  
  117
  
    
2012-10-26 15:03:59.419728-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


  		




  
  118
  
    
2012-10-26 15:03:59.419728-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


  		




  
  119
  
    
2012-10-26 15:03:59.419728-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


  		




  
  120
  
    
2012-10-26 15:03:59.419728-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


  		




  
  121
  
    
2012-10-26 15:04:15.502163-07	7	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


  		




  
  122
  
    
2012-10-26 15:04:15.502163-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


  		




  
  123
  
    
2012-10-26 15:03:59.419728-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


  		




  
  124
  
    
2012-10-26 15:03:59.419728-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


  		




  
  125
  
    
2012-10-26 15:03:59.419728-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


  		




  
  126
  
    
2012-10-26 15:04:15.502163-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


  		




  114
  127
  
    
\.


  		




  115
  128
  
    

  		




  116
  129
  
    

  		




  ......




  126
  139
  
    
-- Name: tnrs_accepted_names; Type: INDEX; Schema: TNRS; Owner: bien; Tablespace: 


  		




  127
  140
  
    
--


  		




  128
  141
  
    

  		




  129
  
  
    
CREATE INDEX tnrs_accepted_names ON tnrs USING btree (((NOT ("Name_submitted" = ("Accepted_name" || COALESCE((' '::text || "Accepted_name_author"), ''::text))))), "Name_submitted");


  		




  
  142
  
    
CREATE INDEX tnrs_accepted_names ON tnrs USING btree (((NOT ("Name_submitted" = NULLIF(array_to_string(ARRAY[NULLIF("Accepted_name_family", 'Unknown'::text), "Accepted_name", "Accepted_name_author"], ' '::text), ''::text)))), "Name_submitted");


  		




  130
  143
  
    

  		




  131
  144
  
    
ALTER TABLE tnrs CLUSTER ON tnrs_accepted_names;


  		




  132
  145
  
    

  		












  

    
      inputs/test_taxonomic_names/_scrub/public.test_taxonomic_names.sql
    
  





  347
  347
  
    
ALTER FUNCTION "public.test_taxonomic_names"._has_taxonomic_name(rank taxonrank) OWNER TO bien;


  		




  348
  348
  
    

  		




  349
  349
  
    
--


  		




  
  350
  
    
-- Name: _taxon_family_require_std(text); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien


  		




  
  351
  
    
--


  		




  
  352
  
    

  		




  
  353
  
    
CREATE FUNCTION _taxon_family_require_std(family text) RETURNS text


  		




  
  354
  
    
    LANGUAGE sql IMMUTABLE STRICT


  		




  
  355
  
    
    AS $_$


  		




  
  356
  
    
SELECT (CASE WHEN $1 LIKE '%aceae' THEN $1 ELSE NULL END)


  		




  
  357
  
    
$_$;


  		




  
  358
  
    

  		




  
  359
  
    

  		




  
  360
  
    
ALTER FUNCTION "public.test_taxonomic_names"._taxon_family_require_std(family text) OWNER TO bien;


  		




  
  361
  
    

  		




  
  362
  
    
--


  		




  350
  363
  
    
-- Name: _taxonlabel_set_matched_label_id(integer, integer, double precision); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien


  		




  351
  364
  
    
--


  		




  352
  365
  
    

  		




  ......




  923
  936
  
    
    aggregateoccurrence_id integer NOT NULL,


  		




  924
  937
  
    
    creator_id integer NOT NULL,


  		




  925
  938
  
    
    sourceaccessioncode text,


  		




  926
  
  
    
    taxonoccurrence_id integer NOT NULL,


  		




  
  939
  
    
    taxonoccurrence_id integer,


  		




  927
  940
  
    
    collectiondate date,


  		




  928
  941
  
    
    cover_fraction double precision,


  		




  929
  942
  
    
    linecover_m double precision,


  		




  ......




  936
  949
  
    
    occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present'::occurrencestatus_dwc NOT NULL,


  		




  937
  950
  
    
    method_id integer,


  		




  938
  951
  
    
    notes text,


  		




  939
  
  
    
    accessioncode text


  		




  
  952
  
    
    accessioncode text,


  		




  
  953
  
    
    CONSTRAINT aggregateoccurrence_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (taxonoccurrence_id IS NOT NULL)))


  		




  940
  954
  
    
);


  		




  941
  955
  
    

  		




  942
  956
  
    

  		




  ......




  1485
  1499
  
    
    plantobservation_id integer NOT NULL,


  		




  1486
  1500
  
    
    creator_id integer NOT NULL,


  		




  1487
  1501
  
    
    sourceaccessioncode text,


  		




  1488
  
  
    
    aggregateoccurrence_id integer NOT NULL,


  		




  
  1502
  
    
    aggregateoccurrence_id integer,


  		




  1489
  1503
  
    
    overallheight_m double precision,


  		




  1490
  1504
  
    
    overallheightaccuracy_m double precision,


  		




  1491
  1505
  
    
    collectionnumber text,


  		




  1492
  1506
  
    
    stemcount integer,


  		




  1493
  1507
  
    
    plant_id integer,


  		




  1494
  
  
    
    accessioncode text


  		




  
  1508
  
    
    accessioncode text,


  		




  
  1509
  
    
    CONSTRAINT plantobservation_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (aggregateoccurrence_id IS NOT NULL)))


  		




  1495
  1510
  
    
);


  		




  1496
  1511
  
    

  		




  1497
  1512
  
    

  		




  ......




  1554
  1569
  
    

  		




  1555
  1570
  
    

  		




  1556
  1571
  
    
--


  		




  
  1572
  
    
-- Name: stemobservation; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: 


  		




  
  1573
  
    
--


  		




  
  1574
  
    

  		




  
  1575
  
    
CREATE TABLE stemobservation (


  		




  
  1576
  
    
    stemobservation_id integer NOT NULL,


  		




  
  1577
  
    
    creator_id integer NOT NULL,


  		




  
  1578
  
    
    sourceaccessioncode text,


  		




  
  1579
  
    
    plantobservation_id integer NOT NULL,


  		




  
  1580
  
    
    authorstemcode text,


  		




  
  1581
  
    
    tag text,


  		




  
  1582
  
    
    tags text,


  		




  
  1583
  
    
    xposition_m double precision,


  		




  
  1584
  
    
    yposition_m double precision,


  		




  
  1585
  
    
    diameterbreastheight_m double precision,


  		




  
  1586
  
    
    basaldiameter_m double precision,


  		




  
  1587
  
    
    diameteraccuracy_m double precision,


  		




  
  1588
  
    
    height_m double precision,


  		




  
  1589
  
    
    heightfirstbranch_m double precision,


  		




  
  1590
  
    
    heightaccuracy_m double precision,


  		




  
  1591
  
    
    health text,


  		




  
  1592
  
    
    age double precision,


  		




  
  1593
  
    
    accessioncode text


  		




  
  1594
  
    
);


  		




  
  1595
  
    

  		




  
  1596
  
    

  		




  
  1597
  
    
ALTER TABLE "public.test_taxonomic_names".stemobservation OWNER TO bien;


  		




  
  1598
  
    

  		




  
  1599
  
    
--


  		




  
  1600
  
    
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien


  		




  
  1601
  
    
--


  		




  
  1602
  
    

  		




  
  1603
  
    
COMMENT ON TABLE stemobservation IS 'Equivalent to VegBank''s stemlocation table.';


  		




  
  1604
  
    

  		




  
  1605
  
    

  		




  
  1606
  
    
--


  		




  
  1607
  
    
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien


  		




  
  1608
  
    
--


  		




  
  1609
  
    

  		




  
  1610
  
    
COMMENT ON COLUMN stemobservation.tags IS 'Stores all tags when multiple tags provided. Older tags go first.';


  		




  
  1611
  
    

  		




  
  1612
  
    

  		




  
  1613
  
    
--


  		




  1557
  1614
  
    
-- Name: taxondetermination; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: 


  		




  1558
  1615
  
    
--


  		




  1559
  1616
  
    

  		




  ......




  1603
  1660
  
    
    iscultivated boolean,


  		




  1604
  1661
  
    
    cultivatedbasis text,


  		




  1605
  1662
  
    
    isnative boolean,


  		




  1606
  
  
    
    accessioncode text


  		




  
  1663
  
    
    accessioncode text,


  		




  
  1664
  
    
    CONSTRAINT taxonoccurrence_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (locationevent_id IS NOT NULL)))


  		




  1607
  1665
  
    
);


  		




  1608
  1666
  
    

  		




  1609
  1667
  
    

  		




  ......




  1650
  1708
  
    
    author text,


  		




  1651
  1709
  
    
    family text,


  		




  1652
  1710
  
    
    genus text,


  		




  1653
  
  
    
    species text,


  		




  
  1711
  
    
    specific_epithet text,


  		




  1654
  1712
  
    
    morphospecies text,


  		




  1655
  1713
  
    
    description text


  		




  1656
  1714
  
    
);


  		




  ......




  1712
  1770
  
    

  		




  1713
  1771
  
    

  		




  1714
  1772
  
    
--


  		




  1715
  
  
    
-- Name: COLUMN taxonverbatim.species; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien


  		




  
  1773
  
    
-- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien


  		




  1716
  1774
  
    
--


  		




  1717
  1775
  
    

  		




  1718
  
  
    
COMMENT ON COLUMN taxonverbatim.species IS 'The species portion of the taxonomic name. This is a cached field for easy querying; this should also be stored in taxonlabel at the appropriate rank.';


  		




  
  1776
  
    
COMMENT ON COLUMN taxonverbatim.specific_epithet IS 'The specific epithet portion of the taxonomic name. This is a cached field for easy querying; this should also be stored in taxonlabel at the appropriate rank.';


  		




  1719
  1777
  
    

  		




  1720
  1778
  
    

  		




  1721
  1779
  
    
--


  		




  ......




  1730
  1788
  
    
--


  		




  1731
  1789
  
    

  		




  1732
  1790
  
    
CREATE VIEW analytical_db_view AS


  		




  1733
  
  
    
    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));


  		




  
  1791
  
    
    SELECT datasource.organizationname AS "institutionCode", accepted_taxonverbatim.family, accepted_taxonverbatim.genus, ((accepted_taxonverbatim.genus || ' '::text) || accepted_taxonverbatim.specific_epithet) AS "speciesBinomial", COALESCE(accepted_taxonverbatim.taxonomicname, accepted_taxonverbatim.binomial) AS "scientificName", accepted_taxonverbatim.author AS "scientificNameAuthorship", NULLIF(array_to_string(ARRAY[accepted_taxonverbatim.taxonomicname, parsed_taxonverbatim.morphospecies], ' '::text), ''::text) AS "scientificNameWithMorphospecies", placepath.country, placepath.stateprovince AS "stateProvince", placepath.county, taxonoccurrence.verbatimcollectorname AS "recordedBy", plantobservation.collectionnumber AS "recordNumber", NULLIF(array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], ' '::text), ''::text) AS "identifiedBy", aggregateoccurrence.collectiondate AS "dateCollected", location.sourceaccessioncode AS "plotName", functions._m2_to_ha(location.area_m2) AS "plotArea_ha", method.name AS "samplingProtocol", locationcoords.latitude_deg AS "decimalLatitude", locationcoords.longitude_deg AS "decimalLongitude", location.elevation_m AS "elevationInMeters", taxonoccurrence.iscultivated AS cultivated, taxonoccurrence.cultivatedbasis AS "cultivatedBasis", _fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent", taxonoccurrence.growthform AS "growthForm", stemobservation.tag, stemobservation.xposition_m AS "organismX_m", stemobservation.yposition_m AS "organismY_m", stemobservation.height_m FROM (((((((((((((((((((party datasource JOIN location ON ((location.creator_id = datasource.party_id))) 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 parsed_taxonlabel ON ((parsed_taxonlabel.taxonlabel_id = datasource_taxonlabel.matched_label_id))) LEFT JOIN taxonverbatim parsed_taxonverbatim ON ((parsed_taxonverbatim.taxonlabel_id = parsed_taxonlabel.taxonlabel_id))) JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id))) JOIN taxonverbatim accepted_taxonverbatim ON ((accepted_taxonverbatim.taxonlabel_id = accepted_taxonlabel.taxonlabel_id))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN stemobservation USING (plantobservation_id)) LEFT JOIN specimenreplicate USING (plantobservation_id)) WHERE (datasource.organizationname IS NOT NULL);


  		




  1734
  1792
  
    

  		




  1735
  1793
  
    

  		




  1736
  1794
  
    
ALTER TABLE "public.test_taxonomic_names".analytical_db_view OWNER TO bien;


  		




  ......




  3621
  3679
  
    

  		




  3622
  3680
  
    

  		




  3623
  3681
  
    
--


  		




  3624
  
  
    
-- Name: stemobservation; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: 


  		




  3625
  
  
    
--


  		




  3626
  
  
    

  		




  3627
  
  
    
CREATE TABLE stemobservation (


  		




  3628
  
  
    
    stemobservation_id integer NOT NULL,


  		




  3629
  
  
    
    creator_id integer NOT NULL,


  		




  3630
  
  
    
    sourceaccessioncode text,


  		




  3631
  
  
    
    plantobservation_id integer NOT NULL,


  		




  3632
  
  
    
    authorstemcode text,


  		




  3633
  
  
    
    tag text,


  		




  3634
  
  
    
    tags text,


  		




  3635
  
  
    
    xposition_m double precision,


  		




  3636
  
  
    
    yposition_m double precision,


  		




  3637
  
  
    
    diameterbreastheight_m double precision,


  		




  3638
  
  
    
    basaldiameter_m double precision,


  		




  3639
  
  
    
    diameteraccuracy_m double precision,


  		




  3640
  
  
    
    height_m double precision,


  		




  3641
  
  
    
    heightfirstbranch_m double precision,


  		




  3642
  
  
    
    heightaccuracy_m double precision,


  		




  3643
  
  
    
    health text,


  		




  3644
  
  
    
    age double precision,


  		




  3645
  
  
    
    accessioncode text


  		




  3646
  
  
    
);


  		




  3647
  
  
    

  		




  3648
  
  
    

  		




  3649
  
  
    
ALTER TABLE "public.test_taxonomic_names".stemobservation OWNER TO bien;


  		




  3650
  
  
    

  		




  3651
  
  
    
--


  		




  3652
  
  
    
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien


  		




  3653
  
  
    
--


  		




  3654
  
  
    

  		




  3655
  
  
    
COMMENT ON TABLE stemobservation IS 'Equivalent to VegBank''s stemlocation table.';


  		




  3656
  
  
    

  		




  3657
  
  
    

  		




  3658
  
  
    
--


  		




  3659
  
  
    
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien


  		




  3660
  
  
    
--


  		




  3661
  
  
    

  		




  3662
  
  
    
COMMENT ON COLUMN stemobservation.tags IS 'Stores all tags when multiple tags provided. Older tags go first.';


  		




  3663
  
  
    

  		




  3664
  
  
    

  		




  3665
  
  
    
--


  		




  3666
  3682
  
    
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien


  		




  3667
  3683
  
    
--


  		




  3668
  3684
  
    

  		




  ......




  5115
  5131
  
    
--


  		




  5116
  5132
  
    

  		




  5117
  5133
  
    
COPY taxondetermination (taxondetermination_id, taxonoccurrence_id, taxonverbatim_id, party_id, role, determinationtype, reference_id, isoriginal, iscurrent, taxonfit, taxonconfidence, grouptype, notes, notespublic, notesmgt, revisions, determinationdate, accessioncode) FROM stdin;


  		




  5118
  
  
    
1	2	3	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5119
  
  
    
2	2	8	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5120
  
  
    
3	2	13	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5121
  
  
    
4	2	18	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5122
  
  
    
5	2	23	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5123
  
  
    
6	2	30	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5124
  
  
    
8	2	38	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5125
  
  
    
10	2	48	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5126
  
  
    
14	2	68	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5127
  
  
    
16	2	80	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5128
  
  
    
18	2	90	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5129
  
  
    
19	2	93	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5130
  
  
    
20	2	100	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5131
  
  
    
21	2	103	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5132
  
  
    
22	2	108	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5133
  
  
    
23	2	113	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5134
  
  
    
25	2	125	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5135
  
  
    
27	2	131	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5136
  
  
    
28	2	132	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5137
  
  
    
29	2	133	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5138
  
  
    
30	2	134	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5139
  
  
    
31	2	135	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5140
  
  
    
32	2	136	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5141
  
  
    
33	2	137	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5142
  
  
    
34	2	138	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5143
  
  
    
35	2	139	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5144
  
  
    
36	2	140	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5145
  
  
    
37	2	141	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5146
  
  
    
38	2	142	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5147
  
  
    
39	2	143	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5148
  
  
    
40	2	144	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5149
  
  
    
41	2	145	\N	unknown	\N	\N	f	f	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5150
  5134
  
    
\.


  		




  5151
  5135
  
    

  		




  5152
  5136
  
    

  		




  ......




  5155
  5139
  
    
--


  		




  5156
  5140
  
    

  		




  5157
  5141
  
    
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;


  		




  5158
  
  
    
2	2	\N	\N	\N	2	\N	\N	\N	\N	family	Asteraceae	\N


  		




  
  5142
  
    
2	2	\N	\N	\N	2	\N	\N	\N	\N	\N	Asteraceae	\N


  		




  5159
  5143
  
    
4	1	\N	\N	\N	4	2	\N	\N	Asteraceae	family	\N	\N


  		




  5160
  
  
    
20	1	http://www.tropicos.org/Name/50307371	\N	Accepted	20	20	\N	4	\N	family	Asteraceae Bercht. & J. Presl	\N


  		




  5161
  
  
    
41	2	\N	\N	\N	41	\N	\N	\N	\N	genus	Poa	\N


  		




  5162
  
  
    
42	2	\N	\N	\N	42	\N	\N	\N	\N	family	Poaceae	\N


  		




  
  5144
  
    
20	1	http://www.tropicos.org/Name/50307371	\N	Accepted	20	20	\N	4	\N	family	Asteraceae Asteraceae Bercht. & J. Presl	\N


  		




  
  5145
  
    
41	2	\N	\N	\N	41	\N	\N	\N	\N	\N	Poa	\N


  		




  
  5146
  
    
42	2	\N	\N	\N	42	\N	\N	\N	\N	\N	Poaceae	\N


  		




  5163
  5147
  
    
44	1	\N	\N	\N	44	42	\N	\N	Poaceae	family	\N	\N


  		




  5164
  5148
  
    
46	1	\N	\N	\N	46	41	\N	44	Poa	genus	\N	\N


  		




  5165
  5149
  
    
48	1	\N	\N	\N	48	\N	\N	46	annua	species	\N	\N


  		




  5166
  
  
    
60	1	http://www.tropicos.org/Name/25509881	\N	Accepted	60	60	\N	48	\N	species	Poa annua L.	\N


  		




  5167
  
  
    
98	1	\N	\N	\N	98	\N	\N	48	annua	variety	\N	\N


  		




  5168
  
  
    
100	1	http://www.tropicos.org/Name/25517736	\N	Accepted	100	100	\N	98	\N	variety	Poa annua var. annua	\N


  		




  5169
  
  
    
128	1	\N	\N	\N	128	\N	\N	46	infirma	species	\N	\N


  		




  5170
  
  
    
140	1	http://www.tropicos.org/Name/25514158	\N	Accepted	140	140	\N	128	\N	species	Poa infirma Kunth	\N


  		




  5171
  
  
    
162	2	\N	\N	\N	162	\N	\N	\N	\N	family	Caryophyllaceae	\N


  		




  5172
  
  
    
164	1	\N	\N	\N	164	162	\N	\N	Caryophyllaceae	family	\N	\N


  		




  5173
  
  
    
180	1	http://www.tropicos.org/Name/42000077	\N	Accepted	180	180	\N	164	\N	family	Caryophyllaceae Juss.	\N


  		




  5174
  
  
    
200	1	\N	\N	\N	200	180	1	\N	\N	\N	Caryophyllaceae	\N


  		




  5175
  
  
    
202	2	\N	\N	\N	202	\N	\N	\N	\N	family	Compositae	\N


  		




  5176
  
  
    
204	1	\N	\N	\N	204	202	\N	\N	Compositae	family	\N	\N


  		




  5177
  
  
    
220	1	http://www.tropicos.org/Name/50255940	\N	Synonym	20	20	\N	204	\N	family	Compositae Giseke	\N


  		




  5178
  
  
    
240	1	\N	\N	\N	240	220	1	\N	\N	\N	Compositae	\N


  		




  5179
  
  
    
280	1	\N	\N	\N	280	220	1	\N	indet. sp.1	\N	Compositae indet. sp.1	\N


  		




  5180
  
  
    
282	2	\N	\N	\N	282	\N	\N	\N	\N	family	Fabaceae	\N


  		




  5181
  
  
    
284	1	\N	\N	\N	284	282	\N	\N	Fabaceae	family	\N	\N


  		




  5182
  
  
    
300	1	http://www.tropicos.org/Name/42000184	\N	Accepted	300	300	\N	284	\N	family	Fabaceae Lindl.	\N


  		




  5183
  
  
    
320	1	\N	\N	\N	320	300	1	\N	\N	\N	Fabaceae	\N


  		




  5184
  
  
    
360	1	\N	\N	\N	360	300	1	\N	Boyle#6500	\N	Fabaceae Boyle#6500	\N


  		




  5185
  
  
    
361	2	\N	\N	\N	361	\N	\N	\N	\N	genus	Inga	\N


  		




  5186
  
  
    
366	1	\N	\N	\N	366	361	\N	284	Inga	genus	\N	\N


  		




  5187
  
  
    
380	1	http://www.tropicos.org/Name/40031040	\N	Accepted	380	380	\N	366	\N	genus	Inga Mill.	\N


  		




  5188
  
  
    
400	1	\N	\N	\N	400	380	1	\N	"fuzzy leaf"	\N	Fabaceae Inga "fuzzy leaf"	\N


  		




  5189
  
  
    
440	1	\N	\N	\N	440	380	1	\N	sp.3	\N	Fabaceae Inga sp.3	\N


  		




  5190
  
  
    
480	1	\N	\N	\N	480	300	1	\N	unknown #2	\N	Fabaceae unknown #2	\N


  		




  5191
  
  
    
520	1	\N	\N	\N	520	380	1	\N	\N	\N	Inga	\N


  		




  5192
  
  
    
540	1	http://www.tropicos.org/Name/40012319	\N	Accepted	540	540	\N	46	\N	genus	Poa L.	\N


  		




  5193
  
  
    
560	1	\N	\N	\N	560	540	1	\N	\N	\N	Poa	\N


  		




  5194
  
  
    
600	1	\N	\N	\N	600	60	1	\N	\N	\N	Poa annua	\N


  		




  
  5150
  
    
58	1	\N	\N	\N	58	\N	\N	48	annua	variety	\N	\N


  		




  
  5151
  
    
60	1	http://www.tropicos.org/Name/25517736	\N	Accepted	60	60	\N	58	\N	variety	Poaceae Poa annua var. annua	\N


  		




  
  5152
  
    
88	1	\N	\N	\N	88	\N	\N	46	infirma	species	\N	\N


  		




  
  5153
  
    
100	1	http://www.tropicos.org/Name/25514158	\N	Accepted	100	100	\N	88	\N	species	Poaceae Poa infirma Kunth	\N


  		




  
  5154
  
    
122	2	\N	\N	\N	122	\N	\N	\N	\N	\N	Caryophyllaceae	\N


  		




  
  5155
  
    
124	1	\N	\N	\N	124	122	\N	\N	Caryophyllaceae	family	\N	\N


  		




  
  5156
  
    
140	1	http://www.tropicos.org/Name/42000077	\N	Accepted	140	140	\N	124	\N	family	Caryophyllaceae Caryophyllaceae Juss.	\N


  		




  
  5157
  
    
160	1	\N	\N	\N	160	140	1	\N	\N	\N	Caryophyllaceae	\N


  		




  
  5158
  
    
162	2	\N	\N	\N	162	\N	\N	\N	\N	\N	Compositae	\N


  		




  
  5159
  
    
164	1	\N	\N	\N	164	162	\N	\N	Compositae	family	\N	\N


  		




  
  5160
  
    
180	1	http://www.tropicos.org/Name/50255940	\N	Synonym	20	20	\N	164	\N	family	Compositae Giseke	\N


  		




  
  5161
  
    
200	1	\N	\N	\N	200	180	1	\N	\N	\N	Compositae	\N


  		




  
  5162
  
    
240	1	\N	\N	\N	240	180	1	\N	indet. sp.1	\N	Compositae indet. sp.1	\N


  		




  
  5163
  
    
242	2	\N	\N	\N	242	\N	\N	\N	\N	\N	Fabaceae	\N


  		




  
  5164
  
    
244	1	\N	\N	\N	244	242	\N	\N	Fabaceae	family	\N	\N


  		




  
  5165
  
    
260	1	http://www.tropicos.org/Name/42000184	\N	Accepted	260	260	\N	244	\N	family	Fabaceae Fabaceae Lindl.	\N


  		




  
  5166
  
    
280	1	\N	\N	\N	280	260	1	\N	\N	\N	Fabaceae	\N


  		




  
  5167
  
    
320	1	\N	\N	\N	320	260	1	\N	Boyle#6500	\N	Fabaceae Boyle#6500	\N


  		




  
  5168
  
    
321	2	\N	\N	\N	321	\N	\N	\N	\N	\N	Inga	\N


  		




  
  5169
  
    
326	1	\N	\N	\N	326	321	\N	244	Inga	genus	\N	\N


  		




  
  5170
  
    
340	1	http://www.tropicos.org/Name/40031040	\N	Accepted	340	340	\N	326	\N	genus	Fabaceae Inga Mill.	\N


  		




  
  5171
  
    
360	1	\N	\N	\N	360	340	1	\N	"fuzzy leaf"	\N	Fabaceae Inga "fuzzy leaf"	\N


  		




  
  5172
  
    
400	1	\N	\N	\N	400	340	1	\N	sp.3	\N	Fabaceae Inga sp.3	\N


  		




  
  5173
  
    
440	1	\N	\N	\N	440	260	1	\N	unknown #2	\N	Fabaceae unknown #2	\N


  		




  
  5174
  
    
480	1	\N	\N	\N	480	340	1	\N	\N	\N	Inga	\N


  		




  
  5175
  
    
500	1	http://www.tropicos.org/Name/40012319	\N	Accepted	500	500	\N	46	\N	genus	Poaceae Poa L.	\N


  		




  
  5176
  
    
520	1	\N	\N	\N	520	500	1	\N	\N	\N	Poa	\N


  		




  
  5177
  
    
540	1	http://www.tropicos.org/Name/25509881	\N	Accepted	540	540	\N	48	\N	species	Poaceae Poa annua L.	\N


  		




  
  5178
  
    
560	1	\N	\N	\N	560	540	1	\N	\N	\N	Poa annua	\N


  		




  
  5179
  
    
600	1	\N	\N	\N	600	540	1	\N	\N	\N	Poa annua L.	\N


  		




  5195
  5180
  
    
618	1	\N	\N	\N	618	\N	\N	48	lanuginosa	forma	\N	\N


  		




  5196
  
  
    
620	1	http://www.tropicos.org/Name/50267771	\N	Synonym	100	100	\N	618	\N	forma	Poa annua fo. lanuginosa Sennen	\N


  		




  
  5181
  
    
620	1	http://www.tropicos.org/Name/50267771	\N	Synonym	60	60	\N	618	\N	forma	Poaceae Poa annua fo. lanuginosa Sennen	\N


  		




  5197
  5182
  
    
640	1	\N	\N	\N	640	620	1	\N	\N	\N	Poa annua fo. lanuginosa	\N


  		




  5198
  
  
    
680	1	\N	\N	\N	680	540	1	\N	annua ssp. exilis	\N	Poa annua ssp. exilis	\N


  		




  
  5183
  
    
680	1	\N	\N	\N	680	500	1	\N	annua ssp. exilis	\N	Poa annua ssp. exilis	\N


  		




  5199
  5184
  
    
698	1	\N	\N	\N	698	\N	\N	48	exilis	subspecies	\N	\N


  		




  5200
  
  
    
700	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


  		




  
  5185
  
    
700	1	http://www.tropicos.org/Name/50063800	\N	Synonym	100	100	\N	698	\N	subspecies	Poaceae Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.	\N


  		




  5201
  5186
  
    
720	1	\N	\N	\N	720	700	1	\N	\N	\N	Poa annua subsp. exilis	\N


  		




  5202
  5187
  
    
738	1	\N	\N	\N	738	\N	\N	48	minima	subvariety	\N	\N


  		




  5203
  
  
    
740	1	http://www.tropicos.org/Name/50158097	\N	Accepted	740	740	\N	738	\N	subvariety	Poa annua subvar. minima (Schur) Asch. & Graebn.	\N


  		




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


  		




  5204
  5189
  
    
760	1	\N	\N	\N	760	740	1	\N	\N	\N	Poa annua subvar. minima	\N


  		




  5205
  5190
  
    
778	1	\N	\N	\N	778	\N	\N	48	eriolepis	variety	\N	\N


  		




  5206
  
  
    
780	1	http://www.tropicos.org/Name/50119145	\N	Synonym	60	60	\N	778	\N	variety	Poa annua var. eriolepis E. Desv.	\N


  		




  
  5191
  
    
780	1	http://www.tropicos.org/Name/50119145	\N	Synonym	540	540	\N	778	\N	variety	Poaceae Poa annua var. eriolepis E. Desv.	\N


  		




  5207
  5192
  
    
800	1	\N	\N	\N	800	780	1	\N	\N	\N	Poa annua var. eriolepis	\N


  		




  5208
  
  
    
820	1	http://www.tropicos.org/Name/42000357	\N	Accepted	820	820	\N	44	\N	family	Poaceae Barnhart	\N


  		




  
  5193
  
    
820	1	http://www.tropicos.org/Name/42000357	\N	Accepted	820	820	\N	44	\N	family	Poaceae Poaceae Barnhart	\N


  		




  5209
  5194
  
    
840	1	\N	\N	\N	840	820	1	\N	\N	\N	Poaceae	\N


  		




  5210
  
  
    
841	2	\N	\N	\N	841	\N	\N	\N	\N	genus	Silene	\N


  		




  5211
  
  
    
846	1	\N	\N	\N	846	841	\N	164	Silene	genus	\N	\N


  		




  5212
  
  
    
860	1	http://www.tropicos.org/Name/40000236	\N	Accepted	860	860	\N	846	\N	genus	Silene L.	\N


  		




  
  5195
  
    
841	2	\N	\N	\N	841	\N	\N	\N	\N	\N	Silene	\N


  		




  
  5196
  
    
846	1	\N	\N	\N	846	841	\N	124	Silene	genus	\N	\N


  		




  
  5197
  
    
860	1	http://www.tropicos.org/Name/40000236	\N	Accepted	860	860	\N	846	\N	genus	Caryophyllaceae Silene L.	\N


  		




  5213
  5198
  
    
880	1	\N	\N	\N	880	860	1	\N	\N	\N	Silene	\N


  		




  5214
  5199
  
    
888	1	\N	\N	\N	888	\N	\N	846	scouleri	species	\N	\N


  		




  5215
  5200
  
    
898	1	\N	\N	\N	898	\N	\N	888	pringlei	subspecies	\N	\N


  		




  5216
  
  
    
900	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


  		




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


  		




  5217
  5202
  
    
920	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


  		




  5218
  5203
  
    
960	1	\N	\N	\N	960	900	1	\N	var. grisea	\N	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	\N


  		




  5219
  5204
  
    
980	1	\N	\N	\N	980	\N	\N	\N	\N	\N	No suitable matches found.	\N


  		




  5220
  5205
  
    
1000	1	\N	\N	\N	1000	\N	\N	\N	\N	\N	Fam_indet. Boyle#6501	\N


  		




  5221
  
  
    
1043	54	1	\N	\N	1043	600	\N	\N	\N	\N	Poa annua	\N


  		




  5222
  
  
    
1046	54	2	\N	\N	1046	60	\N	\N	\N	\N	Poa annua L.	\N


  		




  
  5206
  
    
1043	54	1	\N	\N	1043	560	\N	\N	\N	\N	Poa annua	\N


  		




  
  5207
  
    
1046	54	2	\N	\N	1046	600	\N	\N	\N	\N	Poa annua L.	\N


  		




  5223
  5208
  
    
1049	54	3	\N	\N	1049	800	\N	\N	\N	\N	Poa annua var. eriolepis	\N


  		




  5224
  5209
  
    
1052	54	4	\N	\N	1052	720	\N	\N	\N	\N	Poa annua subsp. exilis	\N


  		




  5225
  5210
  
    
1055	54	5	\N	\N	1055	680	\N	\N	\N	\N	Poa annua ssp. exilis	\N


  		




  ......




  5227
  5212
  
    
1061	54	7	\N	\N	1061	640	\N	\N	\N	\N	Poa annua fo. lanuginosa	\N


  		




  5228
  5213
  
    
1064	54	8	\N	\N	1064	960	\N	\N	\N	\N	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	\N


  		




  5229
  5214
  
    
1067	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


  		




  5230
  
  
    
1070	54	10	\N	\N	1070	440	\N	\N	\N	\N	Fabaceae Inga sp.3	\N


  		




  5231
  
  
    
1073	54	11	\N	\N	1073	400	\N	\N	\N	\N	Fabaceae Inga "fuzzy leaf"	\N


  		




  5232
  
  
    
1076	54	12	\N	\N	1076	480	\N	\N	\N	\N	Fabaceae unknown #2	\N


  		




  5233
  
  
    
1079	54	13	\N	\N	1079	360	\N	\N	\N	\N	Fabaceae Boyle#6500	\N


  		




  
  5215
  
    
1070	54	10	\N	\N	1070	400	\N	\N	\N	\N	Fabaceae Inga sp.3	\N


  		




  
  5216
  
    
1073	54	11	\N	\N	1073	360	\N	\N	\N	\N	Fabaceae Inga "fuzzy leaf"	\N


  		




  
  5217
  
    
1076	54	12	\N	\N	1076	440	\N	\N	\N	\N	Fabaceae unknown #2	\N


  		




  
  5218
  
    
1079	54	13	\N	\N	1079	320	\N	\N	\N	\N	Fabaceae Boyle#6500	\N


  		




  5234
  5219
  
    
1082	54	14	\N	\N	1082	1000	\N	\N	\N	\N	Fam_indet. Boyle#6501	\N


  		




  5235
  
  
    
1085	54	15	\N	\N	1085	280	\N	\N	\N	\N	Compositae indet. sp.1	\N


  		




  
  5220
  
    
1085	54	15	\N	\N	1085	240	\N	\N	\N	\N	Compositae indet. sp.1	\N


  		




  5236
  5221
  
    
\.


  		




  5237
  5222
  
    

  		




  5238
  5223
  
    

  		




  ......




  5256
  5241
  
    
48	48	is included in


  		




  5257
  5242
  
    
48	46	is included in


  		




  5258
  5243
  
    
48	41	is included in


  		




  
  5244
  
    
58	58	is included in


  		




  
  5245
  
    
58	48	is included in


  		




  
  5246
  
    
58	46	is included in


  		




  
  5247
  
    
58	41	is included in


  		




  5259
  5248
  
    
60	60	is included in


  		




  
  5249
  
    
60	58	is included in


  		




  5260
  5250
  
    
60	48	is included in


  		




  5261
  5251
  
    
60	46	is included in


  		




  5262
  5252
  
    
60	41	is included in


  		




  5263
  
  
    
98	98	is included in


  		




  5264
  
  
    
98	48	is included in


  		




  5265
  
  
    
98	46	is included in


  		




  5266
  
  
    
98	41	is included in


  		




  
  5253
  
    
88	88	is included in


  		




  
  5254
  
    
88	46	is included in


  		




  
  5255
  
    
88	41	is included in


  		




  5267
  5256
  
    
100	100	is included in


  		




  5268
  
  
    
100	98	is included in


  		




  5269
  
  
    
100	48	is included in


  		




  
  5257
  
    
100	88	is included in


  		




  5270
  5258
  
    
100	46	is included in


  		




  5271
  5259
  
    
100	41	is included in


  		




  5272
  
  
    
128	128	is included in


  		




  5273
  
  
    
128	46	is included in


  		




  5274
  
  
    
128	41	is included in


  		




  
  5260
  
    
122	122	is included in


  		




  
  5261
  
    
124	124	is included in


  		




  
  5262
  
    
124	122	is included in


  		




  5275
  5263
  
    
140	140	is included in


  		




  5276
  
  
    
140	128	is included in


  		




  5277
  
  
    
140	46	is included in


  		




  5278
  
  
    
140	41	is included in


  		




  
  5264
  
    
140	124	is included in


  		




  
  5265
  
    
140	122	is included in


  		




  
  5266
  
    
160	160	is included in


  		




  
  5267
  
    
160	140	is included in


  		




  
  5268
  
    
160	124	is included in


  		




  
  5269
  
    
160	122	is included in


  		




  5279
  5270
  
    
162	162	is included in


  		




  5280
  5271
  
    
164	164	is included in


  		




  5281
  5272
  
    
164	162	is included in


  		




  5282
  5273
  
    
180	180	is included in


  		




  5283
  
  
    
180	164	is included in


  		




  5284
  
  
    
180	162	is included in


  		




  
  5274
  
    
180	20	is included in


  		




  
  5275
  
    
180	4	is included in


  		




  
  5276
  
    
180	2	is included in


  		




  5285
  5277
  
    
200	200	is included in


  		




  5286
  5278
  
    
200	180	is included in


  		




  5287
  
  
    
200	164	is included in


  		




  5288
  
  
    
200	162	is included in


  		




  5289
  
  
    
202	202	is included in


  		




  5290
  
  
    
204	204	is included in


  		




  5291
  
  
    
204	202	is included in


  		




  5292
  
  
    
220	220	is included in


  		




  5293
  
  
    
220	20	is included in


  		




  5294
  
  
    
220	4	is included in


  		




  5295
  
  
    
220	2	is included in


  		




  
  5279
  
    
200	20	is included in


  		




  
  5280
  
    
200	4	is included in


  		




  
  5281
  
    
200	2	is included in


  		




  5296
  5282
  
    
240	240	is included in


  		




  5297
  
  
    
240	220	is included in


  		




  
  5283
  
    
240	180	is included in


  		




  5298
  5284
  
    
240	20	is included in


  		




  5299
  5285
  
    
240	4	is included in


  		




  5300
  5286
  
    
240	2	is included in


  		




  
  5287
  
    
242	242	is included in


  		




  
  5288
  
    
244	244	is included in


  		




  
  5289
  
    
244	242	is included in


  		




  
  5290
  
    
260	260	is included in


  		




  
  5291
  
    
260	244	is included in


  		




  
  5292
  
    
260	242	is included in


  		




  5301
  5293
  
    
280	280	is included in


  		




  5302
  
  
    
280	220	is included in


  		




  5303
  
  
    
280	20	is included in


  		




  5304
  
  
    
280	4	is included in


  		




  5305
  
  
    
280	2	is included in


  		




  5306
  
  
    
282	282	is included in


  		




  5307
  
  
    
284	284	is included in


  		




  5308
  
  
    
284	282	is included in


  		




  5309
  
  
    
300	300	is included in


  		




  5310
  
  
    
300	284	is included in


  		




  5311
  
  
    
300	282	is included in


  		




  
  5294
  
    
280	260	is included in


  		




  
  5295
  
    
280	244	is included in


  		




  
  5296
  
    
280	242	is included in


  		




  5312
  5297
  
    
320	320	is included in


  		




  5313
  
  
    
320	300	is included in


  		




  5314
  
  
    
320	284	is included in


  		




  5315
  
  
    
320	282	is included in


  		




  
  5298
  
    
320	260	is included in


  		




  
  5299
  
    
320	244	is included in


  		




  
  5300
  
    
320	242	is included in


  		




  
  5301
  
    
321	321	is included in


  		




  
  5302
  
    
326	326	is included in


  		




  
  5303
  
    
326	321	is included in


  		




  
  5304
  
    
340	340	is included in


  		




  
  5305
  
    
340	326	is included in


  		




  
  5306
  
    
340	321	is included in


  		




  5316
  5307
  
    
360	360	is included in


  		




  5317
  
  
    
360	300	is included in


  		




  5318
  
  
    
360	284	is included in


  		




  5319
  
  
    
360	282	is included in


  		




  5320
  
  
    
361	361	is included in


  		




  5321
  
  
    
366	366	is included in


  		




  5322
  
  
    
366	361	is included in


  		




  5323
  
  
    
380	380	is included in


  		




  5324
  
  
    
380	366	is included in


  		




  5325
  
  
    
380	361	is included in


  		




  
  5308
  
    
360	340	is included in


  		




  
  5309
  
    
360	326	is included in


  		




  
  5310
  
    
360	321	is included in


  		




  5326
  5311
  
    
400	400	is included in


  		




  5327
  
  
    
400	380	is included in


  		




  5328
  
  
    
400	366	is included in


  		




  5329
  
  
    
400	361	is included in


  		




  
  5312
  
    
400	340	is included in


  		




  
  5313
  
    
400	326	is included in


  		




  
  5314
  
    
400	321	is included in


  		




  5330
  5315
  
    
440	440	is included in


  		




  5331
  
  
    
440	380	is included in


  		




  5332
  
  
    
440	366	is included in


  		




  5333
  
  
    
440	361	is included in


  		




  
  5316
  
    
440	260	is included in


  		




  
  5317
  
    
440	244	is included in


  		




  
  5318
  
    
440	242	is included in


  		




  5334
  5319
  
    
480	480	is included in


  		




  5335
  
  
    
480	300	is included in


  		




  5336
  
  
    
480	284	is included in


  		




  5337
  
  
    
480	282	is included in


  		




  
  5320
  
    
480	340	is included in


  		




  
  5321
  
    
480	326	is included in


  		




  
  5322
  
    
480	321	is included in


  		




  
  5323
  
    
500	500	is included in


  		




  
  5324
  
    
500	46	is included in


  		




  
  5325
  
    
500	41	is included in


  		




  5338
  5326
  
    
520	520	is included in


  		




  5339
  
  
    
520	380	is included in


  		




  5340
  
  
    
520	366	is included in


  		




  5341
  
  
    
520	361	is included in


  		




  
  5327
  
    
520	500	is included in


  		




  
  5328
  
    
520	46	is included in


  		




  
  5329
  
    
520	41	is included in


  		




  5342
  5330
  
    
540	540	is included in


  		




  
  5331
  
    
540	48	is included in


  		




  5343
  5332
  
    
540	46	is included in


  		




  5344
  5333
  
    
540	41	is included in


  		




  5345
  5334
  
    
560	560	is included in


  		




  5346
  5335
  
    
560	540	is included in


  		




  
  5336
  
    
560	48	is included in


  		




  5347
  5337
  
    
560	46	is included in


  		




  5348
  5338
  
    
560	41	is included in


  		




  5349
  5339
  
    
600	600	is included in


  		




  5350
  
  
    
600	60	is included in


  		




  
  5340
  
    
600	540	is included in


  		




  5351
  5341
  
    
600	48	is included in


  		




  5352
  5342
  
    
600	46	is included in


  		




  5353
  5343
  
    
600	41	is included in


  		




  ......




  5356
  5346
  
    
618	46	is included in


  		




  5357
  5347
  
    
618	41	is included in


  		




  5358
  5348
  
    
620	620	is included in


  		




  5359
  
  
    
620	100	is included in


  		




  5360
  
  
    
620	98	is included in


  		




  
  5349
  
    
620	60	is included in


  		




  
  5350
  
    
620	58	is included in


  		




  5361
  5351
  
    
620	48	is included in


  		




  5362
  5352
  
    
620	46	is included in


  		




  5363
  5353
  
    
620	41	is included in


  		




  5364
  5354
  
    
640	640	is included in


  		




  5365
  5355
  
    
640	620	is included in


  		




  5366
  
  
    
640	100	is included in


  		




  5367
  
  
    
640	98	is included in


  		




  
  5356
  
    
640	60	is included in


  		




  
  5357
  
    
640	58	is included in


  		




  5368
  5358
  
    
640	48	is included in


  		




  5369
  5359
  
    
640	46	is included in


  		




  5370
  5360
  
    
640	41	is included in


  		




  5371
  5361
  
    
680	680	is included in


  		




  5372
  
  
    
680	540	is included in


  		




  
  5362
  
    
680	500	is included in


  		




  5373
  5363
  
    
680	46	is included in


  		




  5374
  5364
  
    
680	41	is included in


  		




  5375
  5365
  
    
698	698	is included in


  		




  ......




  5377
  5367
  
    
698	46	is included in


  		




  5378
  5368
  
    
698	41	is included in


  		




  5379
  5369
  
    
700	700	is included in


  		




  5380
  
  
    
700	140	is included in


  		




  5381
  
  
    
700	128	is included in


  		




  
  5370
  
    
700	100	is included in


  		




  
  5371
  
    
700	88	is included in


  		




  5382
  5372
  
    
700	46	is included in


  		




  5383
  5373
  
    
700	41	is included in


  		




  5384
  5374
  
    
720	720	is included in


  		




  5385
  5375
  
    
720	700	is included in


  		




  5386
  
  
    
720	140	is included in


  		




  5387
  
  
    
720	128	is included in


  		




  
  5376
  
    
720	100	is included in


  		




  
  5377
  
    
720	88	is included in


  		




  5388
  5378
  
    
720	46	is included in


  		




  5389
  5379
  
    
720	41	is included in


  		




  5390
  5380
  
    
738	738	is included in


  		




  ......




  5407
  5397
  
    
778	46	is included in


  		




  5408
  5398
  
    
778	41	is included in


  		




  5409
  5399
  
    
780	780	is included in


  		




  5410
  
  
    
780	60	is included in


  		




  
  5400
  
    
780	540	is included in


  		




  5411
  5401
  
    
780	48	is included in


  		




  5412
  5402
  
    
780	46	is included in


  		




  5413
  5403
  
    
780	41	is included in


  		




  5414
  5404
  
    
800	800	is included in


  		




  5415
  5405
  
    
800	780	is included in


  		




  5416
  
  
    
800	60	is included in


  		




  
  5406
  
    
800	540	is included in


  		




  5417
  5407
  
    
800	48	is included in


  		




  5418
  5408
  
    
800	46	is included in


  		




  5419
  5409
  
    
800	41	is included in


  		




  ......




  5461
  5451
  
    
980	980	is included in


  		




  5462
  5452
  
    
1000	1000	is included in


  		




  5463
  5453
  
    
1043	1043	is included in


  		




  5464
  
  
    
1043	600	is included in


  		




  5465
  
  
    
1043	60	is included in


  		




  
  5454
  
    
1043	560	is included in


  		




  
  5455
  
    
1043	540	is included in


  		




  5466
  5456
  
    
1043	48	is included in


  		




  5467
  5457
  
    
1043	46	is included in


  		




  5468
  5458
  
    
1043	41	is included in


  		




  5469
  5459
  
    
1046	1046	is included in


  		




  5470
  
  
    
1046	60	is included in


  		




  
  5460
  
    
1046	600	is included in


  		




  
  5461
  
    
1046	540	is included in


  		




  5471
  5462
  
    
1046	48	is included in


  		




  5472
  5463
  
    
1046	46	is included in


  		




  5473
  5464
  
    
1046	41	is included in


  		




  5474
  5465
  
    
1049	1049	is included in


  		




  5475
  5466
  
    
1049	800	is included in


  		




  5476
  5467
  
    
1049	780	is included in


  		




  5477
  
  
    
1049	60	is included in


  		




  
  5468
  
    
1049	540	is included in


  		




  5478
  5469
  
    
1049	48	is included in


  		




  5479
  5470
  
    
1049	46	is included in


  		




  5480
  5471
  
    
1049	41	is included in


  		




  5481
  5472
  
    
1052	1052	is included in


  		




  5482
  5473
  
    
1052	720	is included in


  		




  5483
  5474
  
    
1052	700	is included in


  		




  5484
  
  
    
1052	140	is included in


  		




  5485
  
  
    
1052	128	is included in


  		




  
  5475
  
    
1052	100	is included in


  		




  
  5476
  
    
1052	88	is included in


  		




  5486
  5477
  
    
1052	46	is included in


  		




  5487
  5478
  
    
1052	41	is included in


  		




  5488
  5479
  
    
1055	1055	is included in


  		




  5489
  5480
  
    
1055	680	is included in


  		




  5490
  
  
    
1055	540	is included in


  		




  
  5481
  
    
1055	500	is included in


  		




  5491
  5482
  
    
1055	46	is included in


  		




  5492
  5483
  
    
1055	41	is included in


  		




  5493
  5484
  
    
1058	1058	is included in


  		




  ......




  5500
  5491
  
    
1061	1061	is included in


  		




  5501
  5492
  
    
1061	640	is included in


  		




  5502
  5493
  
    
1061	620	is included in


  		




  5503
  
  
    
1061	100	is included in


  		




  5504
  
  
    
1061	98	is included in


  		




  
  5494
  
    
1061	60	is included in


  		




  
  5495
  
    
1061	58	is included in


  		




  5505
  5496
  
    
1061	48	is included in


  		




  5506
  5497
  
    
1061	46	is included in


  		




  5507
  5498
  
    
1061	41	is included in


  		




  ......




  5520
  5511
  
    
1067	846	is included in


  		




  5521
  5512
  
    
1067	841	is included in


  		




  5522
  5513
  
    
1070	1070	is included in


  		




  5523
  
  
    
1070	440	is included in


  		




  5524
  
  
    
1070	380	is included in


  		




  5525
  
  
    
1070	366	is included in


  		




  5526
  
  
    
1070	361	is included in


  		




  
  5514
  
    
1070	400	is included in


  		




  
  5515
  
    
1070	340	is included in


  		




  
  5516
  
    
1070	326	is included in


  		




  
  5517
  
    
1070	321	is included in


  		




  5527
  5518
  
    
1073	1073	is included in


  		




  5528
  
  
    
1073	400	is included in


  		




  5529
  
  
    
1073	380	is included in


  		




  5530
  
  
    
1073	366	is included in


  		




  5531
  
  
    
1073	361	is included in


  		




  
  5519
  
    
1073	360	is included in


  		




  
  5520
  
    
1073	340	is included in


  		




  
  5521
  
    
1073	326	is included in


  		




  
  5522
  
    
1073	321	is included in


  		




  5532
  5523
  
    
1076	1076	is included in


  		




  5533
  
  
    
1076	480	is included in


  		




  5534
  
  
    
1076	300	is included in


  		




  5535
  
  
    
1076	284	is included in


  		




  5536
  
  
    
1076	282	is included in


  		




  
  5524
  
    
1076	440	is included in


  		




  
  5525
  
    
1076	260	is included in


  		




  
  5526
  
    
1076	244	is included in


  		




  
  5527
  
    
1076	242	is included in


  		




  5537
  5528
  
    
1079	1079	is included in


  		




  5538
  
  
    
1079	360	is included in


  		




  5539
  
  
    
1079	300	is included in


  		




  5540
  
  
    
1079	284	is included in


  		




  5541
  
  
    
1079	282	is included in


  		




  
  5529
  
    
1079	320	is included in


  		




  
  5530
  
    
1079	260	is included in


  		




  
  5531
  
    
1079	244	is included in


  		




  
  5532
  
    
1079	242	is included in


  		




  5542
  5533
  
    
1082	1082	is included in


  		




  5543
  5534
  
    
1082	1000	is included in


  		




  5544
  5535
  
    
1085	1085	is included in


  		




  5545
  
  
    
1085	280	is included in


  		




  5546
  
  
    
1085	220	is included in


  		




  
  5536
  
    
1085	240	is included in


  		




  
  5537
  
    
1085	180	is included in


  		




  5547
  5538
  
    
1085	20	is included in


  		




  5548
  5539
  
    
1085	4	is included in


  		




  5549
  5540
  
    
1085	2	is included in


  		




  ......




  5563
  5554
  
    
--


  		




  5564
  5555
  
    

  		




  5565
  5556
  
    
COPY taxonoccurrence (taxonoccurrence_id, creator_id, sourceaccessioncode, locationevent_id, authortaxoncode, verbatimcollectorname, growthform, iscultivated, cultivatedbasis, isnative, accessioncode) FROM stdin;


  		




  5566
  
  
    
2	1	\N	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5567
  5557
  
    
\.


  		




  5568
  5558
  
    

  		




  5569
  5559
  
    

  		




  ......




  5579
  5569
  
    
-- Data for Name: taxonverbatim; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien


  		




  5580
  5570
  
    
--


  		




  5581
  5571
  
    

  		




  5582
  
  
    
COPY taxonverbatim (taxonverbatim_id, taxonlabel_id, verbatimrank, taxonomicname, binomial, author, family, genus, species, morphospecies, description) FROM stdin;


  		




  
  5572
  
    
COPY taxonverbatim (taxonverbatim_id, taxonlabel_id, verbatimrank, taxonomicname, binomial, author, family, genus, specific_epithet, morphospecies, description) FROM stdin;


  		




  5583
  5573
  
    
1	4	family	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5584
  5574
  
    
3	20	family	\N	Asteraceae	Bercht. & J. Presl	Asteraceae	\N	\N	\N	\N


  		




  5585
  
  
    
6	48	species	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5586
  
  
    
7	44	species	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5587
  
  
    
8	60	species	\N	Poa annua	L.	Poaceae	\N	\N	\N	\N


  		




  5588
  
  
    
11	98	variety	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5589
  
  
    
13	100	variety	\N	Poa annua var. annua	\N	Poaceae	\N	\N	\N	\N


  		




  5590
  
  
    
16	128	species	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5591
  
  
    
18	140	species	\N	Poa infirma	Kunth	Poaceae	\N	\N	\N	\N


  		




  
  5575
  
    
6	58	variety	\N	\N	\N	\N	\N	\N	\N	\N


  		




  
  5576
  
    
7	44	variety	\N	\N	\N	\N	\N	\N	\N	\N


  		




  
  5577
  
    
8	60	variety	\N	Poa annua var. annua	\N	Poaceae	\N	\N	\N	\N


  		




  
  5578
  
    
11	88	species	\N	\N	\N	\N	\N	\N	\N	\N


  		




  
  5579
  
    
13	100	species	\N	Poa infirma	Kunth	Poaceae	\N	\N	\N	\N


  		




  
  5580
  
    
16	124	family	\N	\N	\N	\N	\N	\N	\N	\N


  		




  
  5581
  
    
18	140	family	\N	Caryophyllaceae	Juss.	Caryophyllaceae	\N	\N	\N	\N


  		




  
  5582
  
    
19	160	\N	\N	Caryophyllaceae	\N	Caryophyllaceae	\N	\N	\N	\N


  		




  5592
  5583
  
    
21	164	family	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5593
  
  
    
23	180	family	\N	Caryophyllaceae	Juss.	Caryophyllaceae	\N	\N	\N	\N


  		




  5594
  
  
    
24	200	\N	\N	Caryophyllaceae	\N	Caryophyllaceae	\N	\N	\N	\N


  		




  5595
  
  
    
26	204	family	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5596
  
  
    
29	240	\N	\N	Compositae	\N	Compositae	\N	\N	\N	\N


  		




  5597
  
  
    
30	220	family	\N	Compositae	Giseke	Compositae	\N	\N	\N	\N


  		




  5598
  
  
    
34	280	\N	\N	Compositae	\N	Compositae	\N	\N	indet. sp.1	\N


  		




  5599
  
  
    
36	284	family	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5600
  
  
    
38	300	family	\N	Fabaceae	Lindl.	Fabaceae	\N	\N	\N	\N


  		




  5601
  
  
    
39	320	\N	\N	Fabaceae	\N	Fabaceae	\N	\N	\N	\N


  		




  5602
  
  
    
44	360	\N	\N	Fabaceae	\N	Fabaceae	\N	\N	Boyle#6500	\N


  		




  5603
  
  
    
46	366	genus	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5604
  
  
    
48	380	genus	\N	Inga	Mill.	Fabaceae	\N	\N	\N	\N


  		




  5605
  
  
    
49	400	\N	\N	Inga	\N	Fabaceae	Inga	\N	"fuzzy leaf"	\N


  		




  5606
  
  
    
54	440	\N	\N	Inga	\N	Fabaceae	Inga	\N	sp.3	\N


  		




  5607
  
  
    
59	480	\N	\N	Fabaceae	\N	Fabaceae	\N	\N	unknown #2	\N


  		




  5608
  
  
    
64	520	\N	\N	Inga	\N	\N	Inga	\N	\N	\N


  		




  5609
  
  
    
66	46	genus	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5610
  
  
    
68	540	genus	\N	Poa	L.	Poaceae	\N	\N	\N	\N


  		




  5611
  
  
    
69	560	\N	\N	Poa	\N	\N	Poa	\N	\N	\N


  		




  5612
  
  
    
74	600	\N	\N	Poa annua	\N	\N	Poa	annua	\N	\N


  		




  
  5584
  
    
24	200	\N	\N	Compositae	\N	Compositae	\N	\N	\N	\N


  		




  
  5585
  
    
25	180	family	\N	Compositae	Giseke	Compositae	\N	\N	\N	\N


  		




  
  5586
  
    
29	240	\N	\N	Compositae	\N	Compositae	\N	\N	indet. sp.1	\N


  		




  
  5587
  
    
31	244	family	\N	\N	\N	\N	\N	\N	\N	\N


  		




  
  5588
  
    
33	260	family	\N	Fabaceae	Lindl.	Fabaceae	\N	\N	\N	\N


  		




  
  5589
  
    
34	280	\N	\N	Fabaceae	\N	Fabaceae	\N	\N	\N	\N


  		




  
  5590
  
    
39	320	\N	\N	Fabaceae	\N	Fabaceae	\N	\N	Boyle#6500	\N


  		




  
  5591
  
    
41	326	genus	\N	\N	\N	\N	\N	\N	\N	\N


  		




  
  5592
  
    
43	340	genus	\N	Inga	Mill.	Fabaceae	\N	\N	\N	\N


  		




  
  5593
  
    
44	360	\N	\N	Inga	\N	Fabaceae	Inga	\N	"fuzzy leaf"	\N


  		




  
  5594
  
    
49	400	\N	\N	Inga	\N	Fabaceae	Inga	\N	sp.3	\N


  		




  
  5595
  
    
54	440	\N	\N	Fabaceae	\N	Fabaceae	\N	\N	unknown #2	\N


  		




  
  5596
  
    
59	480	\N	\N	Inga	\N	\N	Inga	\N	\N	\N


  		




  
  5597
  
    
61	46	genus	\N	\N	\N	\N	\N	\N	\N	\N


  		




  
  5598
  
    
63	500	genus	\N	Poa	L.	Poaceae	\N	\N	\N	\N


  		




  
  5599
  
    
64	520	\N	\N	Poa	\N	\N	Poa	\N	\N	\N


  		




  
  5600
  
    
66	48	species	\N	\N	\N	\N	\N	\N	\N	\N


  		




  
  5601
  
    
68	540	species	\N	Poa annua	L.	Poaceae	\N	\N	\N	\N


  		




  
  5602
  
    
69	560	\N	\N	Poa annua	\N	\N	Poa	annua	\N	\N


  		




  
  5603
  
    
74	600	\N	\N	Poa annua	L.	\N	Poa	annua	\N	\N


  		




  5613
  5604
  
    
76	618	forma	\N	\N	\N	\N	\N	\N	\N	\N


  		




  5614
  5605
  
    
79	640	fo.	\N	Poa annua fo. lanuginosa	\N	\N	Poa	annua	\N	\N


  		




  5615
  5606
  
    
80	620	forma	\N	Poa annua fo. lanuginosa	Sennen	Poaceae	Poa	annua	\N	\N


  		




  ......




  6347
  6338
  
    

  		




  6348
  6339
  
    

  		




  6349
  6340
  
    
--


  		




  
  6341
  
    
-- Name: location_creator; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: 


  		




  
  6342
  
    
--


  		




  
  6343
  
    

  		




  
  6344
  
    
CREATE INDEX location_creator ON location USING btree (creator_id);


  		




  
  6345
  
    

  		




  
  6346
  
    

  		




  
  6347
  
    
--


  		




  
  6348
  
    
-- Name: location_parent; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: 


  		




  
  6349
  
    
--


  		




  
  6350
  
    

  		




  
  6351
  
    
CREATE INDEX location_parent ON location USING btree (parent_id);


  		




  
  6352
  
    

  		




  
  6353
  
    

  		




  
  6354
  
    
--


  		




  6350
  6355
  
    
-- Name: location_unique_within_creator_by_authorlocationcode; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: 


  		




  6351
  6356
  
    
--


  		




  6352
  6357
  
    

  		




  ......




  6606
  6611
  
    

  		




  6607
  6612
  
    

  		




  6608
  6613
  
    
--


  		




  
  6614
  
    
-- Name: stemobservation_plantobservation_id; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: 


  		




  
  6615
  
    
--


  		




  
  6616
  
    

  		




  
  6617
  
    
CREATE INDEX stemobservation_plantobservation_id ON stemobservation USING btree (plantobservation_id);


  		




  
  6618
  
    

  		




  
  6619
  
    

  		




  
  6620
  
    
--


  		




  6609
  6621
  
    
-- Name: stemobservation_unique_within_creator; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: 


  		




  6610
  6622
  
    
--


  		




  6611
  6623
  
    

  		












Also available in:  Unified diff