Revision 10395
Added by Aaron Marcuse-Kubitza almost 11 years ago
public.test_taxonomic_names.sql | ||
---|---|---|
21 | 21 |
-- Name: SCHEMA "public.test_taxonomic_names"; Type: COMMENT; Schema: -; Owner: bien |
22 | 22 |
-- |
23 | 23 |
|
24 |
COMMENT ON SCHEMA "public.test_taxonomic_names" IS 'Version: public (2013-6-20 7:56:11 PDT)';
|
|
24 |
COMMENT ON SCHEMA "public.test_taxonomic_names" IS 'Version: public (2013-7-24 15:11:57 PDT)';
|
|
25 | 25 |
|
26 | 26 |
|
27 | 27 |
SET search_path = "public.test_taxonomic_names", pg_catalog; |
... | ... | |
2694 | 2694 |
-- |
2695 | 2695 |
|
2696 | 2696 |
CREATE VIEW analytical_stem_view AS |
2697 |
SELECT source.shortname AS datasource, sourcelist.name AS "institutionCode", specimenreplicate.collectioncode_dwc AS "collectionCode", specimenreplicate.catalognumber_dwc AS "catalogNumber", specimenreplicate.sourceaccessioncode AS "occurrenceID", canon_place.country, canon_place.stateprovince AS "stateProvince", datasource_place.county, location.locationnarrative AS locality, CASE WHEN (coordinates.latitude_deg IS NOT NULL) THEN coordinates.latitude_deg ELSE county_centroids.latitude END AS "decimalLatitude", CASE WHEN (coordinates.latitude_deg IS NOT NULL) THEN coordinates.longitude_deg ELSE county_centroids.longitude END AS "decimalLongitude", CASE WHEN (coordinates.latitude_deg IS NOT NULL) THEN coordinates.coordsaccuracy_m ELSE _km_to_m(county_centroids.error_km) END AS "coordinateUncertaintyInMeters", CASE WHEN (coordinates.latitude_deg IS NOT NULL) THEN 'source data'::coordinatesource WHEN (county_centroids.row_num IS NOT NULL) THEN 'georeferencing'::coordinatesource ELSE NULL::coordinatesource END AS "coordinateSource_bien", CASE WHEN (coordinates.latitude_deg IS NOT NULL) THEN NULL::text WHEN (county_centroids.row_num IS NOT NULL) THEN 'county centroid'::text ELSE NULL::text END AS "georeferenceProtocol_bien", (canon_place.geovalid)::integer AS geovalid_bien, ("newWorldCountries"."isNewWorld")::integer AS "isNewWorld_bien", COALESCE(project.sourceaccessioncode, project.projectname) AS "projectID", COALESCE(location.sourceaccessioncode, NULLIF(pg_catalog.concat_ws('; '::text, COALESCE(parent_location.sourceaccessioncode, parent_location.authorlocationcode), location.authorlocationcode), ''::text)) AS "locationID", COALESCE(parent_location.authorlocationcode, location.authorlocationcode) AS "locationName", CASE WHEN (parent_location.location_id IS NOT NULL) THEN location.authorlocationcode ELSE NULL::text END AS subplot, plantobservation.authorplantcode AS "individualCode", COALESCE(location.elevation_m, parent_location.elevation_m) AS "elevationInMeters", _m2_to_ha(COALESCE(location.area_m2, parent_location.area_m2)) AS "plotArea_ha", method.name AS "samplingProtocol", COALESCE(locationevent.temperature_c, parent_event.temperature_c) AS "temperature_C", COALESCE(locationevent.precipitation_m, parent_event.precipitation_m) AS precipitation_m, collector.fullname AS "recordedBy", plantobservation.authorplantcode AS "recordNumber", COALESCE(locationevent.obsstartdate, parent_event.obsstartdate, aggregateoccurrence.collectiondate) AS "dateCollected", taxonverbatim.family AS family_verbatim, COALESCE(taxonverbatim.taxonomicname, NULLIF(pg_catalog.concat_ws(' '::text, taxonverbatim.taxonname, taxonverbatim.author), ''::text), taxonlabel.taxonomicname) AS "scientificName_verbatim", identifiedby.fullname AS "identifiedBy", taxondetermination.determinationdate AS "dateIdentified", taxondetermination.notes AS "identificationRemarks", "ScrubbedTaxon"."matchedFamily" AS family_matched, "ScrubbedTaxon"."matchedTaxonName" AS "taxonName_matched", "ScrubbedTaxon"."matchedScientificNameAuthorship" AS "scientificNameAuthorship_matched", family_higher_plant_group.higher_plant_group AS "higherPlantGroup_bien", "ScrubbedTaxon"."acceptedFamily" AS family, "ScrubbedTaxon"."acceptedGenus" AS genus, COALESCE(COALESCE(NULLIF(pg_catalog.concat_ws(' '::text, COALESCE("ScrubbedTaxon"."acceptedGenus", "ScrubbedTaxon"."acceptedFamily"), "ScrubbedTaxon"."acceptedSpecificEpithet", "ScrubbedTaxon"."morphospeciesSuffix"), ''::text), "ScrubbedTaxon"."acceptedTaxonName"), COALESCE(NULLIF(pg_catalog.concat_ws(' '::text, COALESCE("ScrubbedTaxon"."matchedGenus", "ScrubbedTaxon"."matchedFamily"), "ScrubbedTaxon"."matchedSpecificEpithet", "ScrubbedTaxon"."morphospeciesSuffix"), ''::text), "ScrubbedTaxon"."matchedTaxonName"), "ScrubbedTaxon"."concatenatedScientificName") AS "speciesBinomialWithMorphospecies", "ScrubbedTaxon"."acceptedTaxonName" AS "taxonName", "ScrubbedTaxon"."acceptedScientificNameAuthorship" AS "scientificNameAuthorship", taxonoccurrence.growthform AS "growthForm", plantobservation.reproductivecondition AS "reproductiveCondition", ((threatened_taxonlabel.taxonlabel_id IS NOT NULL))::integer AS threatened_bien, (((cultivated_family_locations.country IS NOT NULL) OR _or(taxonoccurrence.iscultivated, location.iscultivated)))::integer AS cultivated_bien, CASE WHEN (taxonoccurrence.iscultivated IS NOT NULL) THEN taxonoccurrence.cultivatedbasis WHEN (location.iscultivated IS NOT NULL) THEN NULL::text ELSE NULL::text END AS "cultivatedBasis_bien", aggregateoccurrence.notes AS "occurrenceRemarks", _fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent", _m_to_cm(stemobservation.diameterbreastheight_m) AS "diameterBreastHeight_cm", stemobservation.height_m, stemobservation.tag, stemobservation.xposition_m AS "organismX_m", stemobservation.yposition_m AS "organismY_m", taxonoccurrence.sourceaccessioncode AS "taxonOccurrenceID", taxonoccurrence.authortaxoncode AS "authorTaxonCode", plantobservation.sourceaccessioncode AS "individualObservationID", stemobservation.authorstemcode AS "authorStemCode" FROM ((((((((((((((((((((((((((((source JOIN location USING (source_id)) LEFT JOIN locationevent USING (location_id)) LEFT JOIN location parent_location ON ((parent_location.location_id = location.parent_id))) LEFT JOIN locationplace ON ((locationplace.location_id = COALESCE(parent_location.location_id, location.location_id)))) LEFT JOIN place datasource_place USING (place_id)) LEFT JOIN place canon_place ON ((canon_place.place_id = datasource_place.canon_place_id))) LEFT JOIN coordinates ON ((coordinates.coordinates_id = canon_place.coordinates_id))) LEFT JOIN "newWorld".iso_code_gadm ON ((iso_code_gadm."GADM country" = canon_place.country))) LEFT JOIN "newWorld"."newWorldCountries" ON (("newWorldCountries"."isoCode" = iso_code_gadm."2-digit iso code"))) LEFT JOIN geoscrub.county_centroids ON ((((canon_place.country = 'United States'::text) AND (county_centroids.state = canon_place.stateprovince)) AND (county_centroids.county = canon_place.county)))) LEFT JOIN taxonoccurrence USING (locationevent_id)) LEFT JOIN locationevent parent_event ON ((parent_event.locationevent_id = locationevent.parent_id))) LEFT JOIN project ON ((project.project_id = COALESCE(locationevent.project_id, parent_event.project_id)))) LEFT JOIN method ON ((method.method_id = COALESCE(locationevent.method_id, parent_event.method_id)))) LEFT JOIN party collector ON ((collector.party_id = taxonoccurrence.collector_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)) LEFT JOIN sourcelist ON ((sourcelist.sourcelist_id = specimenreplicate.institution_id))) LEFT JOIN taxondetermination ON (((taxondetermination.taxonoccurrence_id = taxonoccurrence.taxonoccurrence_id) AND taxondetermination.is_datasource_current))) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) LEFT JOIN taxonverbatim USING (taxonverbatim_id)) LEFT JOIN taxonlabel USING (taxonlabel_id)) LEFT JOIN "TNRS"."ScrubbedTaxon" ON (("ScrubbedTaxon"."concatenatedScientificName" = taxonlabel.taxonomicname))) LEFT JOIN family_higher_plant_group ON ((family_higher_plant_group.family = "ScrubbedTaxon"."acceptedFamily"))) LEFT JOIN cultivated_family_locations ON (((cultivated_family_locations.family = "ScrubbedTaxon"."acceptedFamily") AND (cultivated_family_locations.country = canon_place.country)))) LEFT JOIN threatened_taxonlabel USING (taxonlabel_id)) ORDER BY source.shortname;
|
|
2697 |
SELECT source.shortname AS datasource, sourcelist.name AS "institutionCode", specimenreplicate.collectioncode_dwc AS "collectionCode", specimenreplicate.catalognumber_dwc AS "catalogNumber", specimenreplicate.sourceaccessioncode AS "occurrenceID", canon_place.country, canon_place.stateprovince AS "stateProvince", datasource_place.county, location.locationnarrative AS locality, CASE WHEN (coordinates.latitude_deg IS NOT NULL) THEN coordinates.latitude_deg ELSE county_centroids.latitude END AS "decimalLatitude", CASE WHEN (coordinates.latitude_deg IS NOT NULL) THEN coordinates.longitude_deg ELSE county_centroids.longitude END AS "decimalLongitude", CASE WHEN (coordinates.latitude_deg IS NOT NULL) THEN coordinates.coordsaccuracy_m ELSE _km_to_m(county_centroids.error_km) END AS "coordinateUncertaintyInMeters", CASE WHEN (coordinates.latitude_deg IS NOT NULL) THEN 'source data'::coordinatesource WHEN (county_centroids.row_num IS NOT NULL) THEN 'georeferencing'::coordinatesource ELSE NULL::coordinatesource END AS "coordinateSource_bien", CASE WHEN (coordinates.latitude_deg IS NOT NULL) THEN NULL::text WHEN (county_centroids.row_num IS NOT NULL) THEN 'county centroid'::text ELSE NULL::text END AS "georeferenceProtocol_bien", (canon_place.geovalid)::integer AS geovalid_bien, ("newWorldCountries"."isNewWorld")::integer AS "isNewWorld_bien", COALESCE(project.sourceaccessioncode, project.projectname) AS "projectID", COALESCE(location.sourceaccessioncode, NULLIF(pg_catalog.concat_ws('; '::text, COALESCE(parent_location.sourceaccessioncode, parent_location.authorlocationcode), location.authorlocationcode), ''::text)) AS "locationID", COALESCE(parent_location.authorlocationcode, location.authorlocationcode) AS "locationName", CASE WHEN (parent_location.location_id IS NOT NULL) THEN location.authorlocationcode ELSE NULL::text END AS subplot, plantobservation.authorplantcode AS "individualCode", COALESCE(location.elevation_m, parent_location.elevation_m) AS "elevationInMeters", _m2_to_ha(COALESCE(location.area_m2, parent_location.area_m2)) AS "plotArea_ha", method.name AS "samplingProtocol", COALESCE(locationevent.temperature_c, parent_event.temperature_c) AS "temperature_C", COALESCE(locationevent.precipitation_m, parent_event.precipitation_m) AS precipitation_m, collector.fullname AS "recordedBy", plantobservation.authorplantcode AS "recordNumber", COALESCE(locationevent.obsstartdate, parent_event.obsstartdate, aggregateoccurrence.collectiondate) AS "dateCollected", taxonverbatim.family AS family_verbatim, COALESCE(taxonverbatim.taxonomicname, NULLIF(pg_catalog.concat_ws(' '::text, taxonverbatim.taxonname, taxonverbatim.author), ''::text), taxonlabel.taxonomicname) AS "scientificName_verbatim", identifiedby.fullname AS "identifiedBy", taxondetermination.determinationdate AS "dateIdentified", taxondetermination.notes AS "identificationRemarks", "ScrubbedTaxon"."matchedFamily" AS family_matched, "ScrubbedTaxon"."matchedTaxonName" AS "taxonName_matched", "ScrubbedTaxon"."matchedScientificNameAuthorship" AS "scientificNameAuthorship_matched", family_higher_plant_group.higher_plant_group AS "higherPlantGroup_bien", "ScrubbedTaxon"."acceptedFamily" AS family, "ScrubbedTaxon"."acceptedGenus" AS genus, COALESCE(COALESCE(NULLIF(pg_catalog.concat_ws(' '::text, COALESCE("ScrubbedTaxon"."acceptedGenus", "ScrubbedTaxon"."acceptedFamily"), "ScrubbedTaxon"."acceptedSpecificEpithet", "ScrubbedTaxon"."morphospeciesSuffix"), ''::text), "ScrubbedTaxon"."acceptedTaxonName"), COALESCE(NULLIF(pg_catalog.concat_ws(' '::text, COALESCE("ScrubbedTaxon"."matchedGenus", "ScrubbedTaxon"."matchedFamily"), "ScrubbedTaxon"."matchedSpecificEpithet", "ScrubbedTaxon"."morphospeciesSuffix"), ''::text), "ScrubbedTaxon"."matchedTaxonName"), "ScrubbedTaxon"."concatenatedScientificName") AS "speciesBinomialWithMorphospecies", "ScrubbedTaxon"."acceptedTaxonName" AS "taxonName", "ScrubbedTaxon"."acceptedScientificNameAuthorship" AS "scientificNameAuthorship", taxonoccurrence.growthform AS "growthForm", plantobservation.reproductivecondition AS "reproductiveCondition", ((threatened_taxonlabel.taxonlabel_id IS NOT NULL))::integer AS threatened_bien, (((cultivated_family_locations.country IS NOT NULL) OR _or(taxonoccurrence.iscultivated, location.iscultivated)))::integer AS cultivated_bien, CASE WHEN (taxonoccurrence.iscultivated IS NOT NULL) THEN taxonoccurrence.cultivatedbasis WHEN (location.iscultivated IS NOT NULL) THEN NULL::text ELSE NULL::text END AS "cultivatedBasis_bien", aggregateoccurrence.notes AS "occurrenceRemarks", _fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent", _m_to_cm(stemobservation.diameterbreastheight_m) AS "diameterBreastHeight_cm", stemobservation.height_m, stemobservation.tag, stemobservation.xposition_m AS "organismX_m", stemobservation.yposition_m AS "organismY_m", taxonoccurrence.sourceaccessioncode AS "taxonOccurrenceID", taxonoccurrence.authortaxoncode AS "authorTaxonCode", plantobservation.sourceaccessioncode AS "individualObservationID", stemobservation.authorstemcode AS "authorStemCode" FROM ((((((((((((((((((((((((((((source JOIN location USING (source_id)) LEFT JOIN locationevent USING (location_id)) LEFT JOIN location parent_location ON ((parent_location.location_id = location.parent_id))) LEFT JOIN locationplace ON ((locationplace.location_id = COALESCE(parent_location.location_id, location.location_id)))) LEFT JOIN place datasource_place USING (place_id)) LEFT JOIN place canon_place ON ((canon_place.place_id = datasource_place.canon_place_id))) LEFT JOIN coordinates ON ((coordinates.coordinates_id = canon_place.coordinates_id))) LEFT JOIN "newWorld".iso_code_gadm ON ((iso_code_gadm."*GADM country" = canon_place.country))) LEFT JOIN "newWorld"."newWorldCountries" ON (("newWorldCountries"."*isoCode" = iso_code_gadm."*2-digit iso code"))) LEFT JOIN geoscrub.county_centroids ON ((((canon_place.country = 'United States'::text) AND (county_centroids.state = canon_place.stateprovince)) AND (county_centroids.county = canon_place.county)))) LEFT JOIN taxonoccurrence USING (locationevent_id)) LEFT JOIN locationevent parent_event ON ((parent_event.locationevent_id = locationevent.parent_id))) LEFT JOIN project ON ((project.project_id = COALESCE(locationevent.project_id, parent_event.project_id)))) LEFT JOIN method ON ((method.method_id = COALESCE(locationevent.method_id, parent_event.method_id)))) LEFT JOIN party collector ON ((collector.party_id = taxonoccurrence.collector_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)) LEFT JOIN sourcelist ON ((sourcelist.sourcelist_id = specimenreplicate.institution_id))) LEFT JOIN taxondetermination ON (((taxondetermination.taxonoccurrence_id = taxonoccurrence.taxonoccurrence_id) AND taxondetermination.is_datasource_current))) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) LEFT JOIN taxonverbatim USING (taxonverbatim_id)) LEFT JOIN taxonlabel USING (taxonlabel_id)) LEFT JOIN "TNRS"."ScrubbedTaxon" ON (("ScrubbedTaxon"."concatenatedScientificName" = taxonlabel.taxonomicname))) LEFT JOIN family_higher_plant_group ON ((family_higher_plant_group.family = "ScrubbedTaxon"."acceptedFamily"))) LEFT JOIN cultivated_family_locations ON (((cultivated_family_locations.family = "ScrubbedTaxon"."acceptedFamily") AND (cultivated_family_locations.country = canon_place.country)))) LEFT JOIN threatened_taxonlabel USING (taxonlabel_id)) ORDER BY source.shortname;
|
|
2698 | 2698 |
|
2699 | 2699 |
|
2700 | 2700 |
ALTER TABLE "public.test_taxonomic_names".analytical_stem_view OWNER TO bien; |
... | ... | |
3351 | 3351 |
-- |
3352 | 3352 |
|
3353 | 3353 |
CREATE VIEW geoscrub_input_new AS |
3354 |
SELECT geoscrub_input.country, geoscrub_input."stateProvince", geoscrub_input.county, geoscrub_input."decimalLatitude", geoscrub_input."decimalLongitude" FROM (geoscrub_input LEFT JOIN geoscrub.geoscrub_output ON ((((((geoscrub_output.decimallatitude = geoscrub_input."decimalLatitude") AND (geoscrub_output.decimallongitude = geoscrub_input."decimalLongitude")) AND (geoscrub_output.country = geoscrub_input.country)) AND (geoscrub_output.stateprovince = geoscrub_input."stateProvince")) AND (geoscrub_output.county = geoscrub_input.county)))) WHERE (geoscrub_output.row_num IS NULL);
|
|
3354 |
SELECT geoscrub_input.country, geoscrub_input."stateProvince", geoscrub_input.county, geoscrub_input."decimalLatitude", geoscrub_input."decimalLongitude" FROM (geoscrub_input LEFT JOIN geoscrub.geoscrub_output ON ((((((geoscrub_output."decimalLatitude" = geoscrub_input."decimalLatitude") AND (geoscrub_output."decimalLongitude" = geoscrub_input."decimalLongitude")) AND (geoscrub_output.country = geoscrub_input.country)) AND (geoscrub_output."stateProvince" = geoscrub_input."stateProvince")) AND (geoscrub_output.county = geoscrub_input.county)))) WHERE (geoscrub_output."*row_num" IS NULL);
|
|
3355 | 3355 |
|
3356 | 3356 |
|
3357 | 3357 |
ALTER TABLE "public.test_taxonomic_names".geoscrub_input_new OWNER TO bien; |
... | ... | |
4353 | 4353 |
-- Name: source_source_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien |
4354 | 4354 |
-- |
4355 | 4355 |
|
4356 |
SELECT pg_catalog.setval('source_source_id_seq', 75, true);
|
|
4356 |
SELECT pg_catalog.setval('source_source_id_seq', 77, true);
|
|
4357 | 4357 |
|
4358 | 4358 |
|
4359 | 4359 |
-- |
... | ... | |
5993 | 5993 |
-- |
5994 | 5994 |
|
5995 | 5995 |
COPY source (source_id, matched_source_id, parent_id, shortname, citation, sourcetype, accesslevel, accessconditions, observationtype, title, titlesuperior, volume, issue, pagerange, totalpages, publisher, publicationplace, isbn, edition, numberofvolumes, chapternumber, reportnumber, communicationtype, degree, url, doi, additionalinfo, pubdate, accessdate, conferencedate) FROM stdin; |
5996 |
1 \N \N test_taxonomic_names \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N |
|
5996 |
1 \N \N TNRS \N aggregator \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N |
|
5997 |
2 \N \N test_taxonomic_names \N personal communication \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N |
|
5997 | 5998 |
\. |
5998 | 5999 |
|
5999 | 6000 |
|
... | ... | |
6098 | 6099 |
-- |
6099 | 6100 |
|
6100 | 6101 |
COPY taxonlabel (taxonlabel_id, source_id, sourceaccessioncode, taxonstatus, canon_label_id, matched_label_id, parent_id, taxonepithet, rank, taxonomicname) FROM stdin; |
6101 |
2 1 1 \N 2 \N \N \N \N Poa annua
|
|
6102 |
4 1 2 \N 4 \N \N \N \N Poa annua L.
|
|
6103 |
6 1 3 \N 6 \N \N \N \N Poa annua var. eriolepis
|
|
6104 |
8 1 4 \N 8 \N \N \N \N Poa annua subsp. exilis
|
|
6105 |
10 1 5 \N 10 \N \N \N \N Poa annua ssp. exilis
|
|
6106 |
12 1 6 \N 12 \N \N \N \N Poa annua subvar. minima
|
|
6107 |
14 1 7 \N 14 \N \N \N \N Poa annua fo. lanuginosa
|
|
6108 |
16 1 8 \N 16 \N \N \N \N Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire
|
|
6109 |
18 1 9 \N 18 \N \N \N \N Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire
|
|
6110 |
20 1 10 \N 20 \N \N \N \N Fabaceae Inga sp.3
|
|
6111 |
22 1 11 \N 22 \N \N \N \N Fabaceae Inga "fuzzy leaf"
|
|
6112 |
24 1 12 \N 24 \N \N \N \N Fabaceae unknown #2
|
|
6113 |
26 1 13 \N 26 \N \N \N \N Fabaceae Boyle#6500
|
|
6114 |
28 1 14 \N 28 \N \N \N \N Fam_indet. Boyle#6501
|
|
6115 |
30 1 15 \N 30 \N \N \N \N Compositae indet. sp.1
|
|
6102 |
2 2 1 \N 2 \N \N \N \N Poa annua
|
|
6103 |
4 2 2 \N 4 \N \N \N \N Poa annua L.
|
|
6104 |
6 2 3 \N 6 \N \N \N \N Poa annua var. eriolepis
|
|
6105 |
8 2 4 \N 8 \N \N \N \N Poa annua subsp. exilis
|
|
6106 |
10 2 5 \N 10 \N \N \N \N Poa annua ssp. exilis
|
|
6107 |
12 2 6 \N 12 \N \N \N \N Poa annua subvar. minima
|
|
6108 |
14 2 7 \N 14 \N \N \N \N Poa annua fo. lanuginosa
|
|
6109 |
16 2 8 \N 16 \N \N \N \N Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire
|
|
6110 |
18 2 9 \N 18 \N \N \N \N Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire
|
|
6111 |
20 2 10 \N 20 \N \N \N \N Fabaceae Inga sp.3
|
|
6112 |
22 2 11 \N 22 \N \N \N \N Fabaceae Inga "fuzzy leaf"
|
|
6113 |
24 2 12 \N 24 \N \N \N \N Fabaceae unknown #2
|
|
6114 |
26 2 13 \N 26 \N \N \N \N Fabaceae Boyle#6500
|
|
6115 |
28 2 14 \N 28 \N \N \N \N Fam_indet. Boyle#6501
|
|
6116 |
30 2 15 \N 30 \N \N \N \N Compositae indet. sp.1
|
|
6116 | 6117 |
\. |
6117 | 6118 |
|
6118 | 6119 |
|
... | ... | |
6168 | 6169 |
-- |
6169 | 6170 |
|
6170 | 6171 |
COPY taxonverbatim (taxonverbatim_id, source_id, taxonlabel_id, verbatimrank, taxonomicname, taxonname, author, family, genus, specific_epithet, morphospecies, morphoname, growthform, description) FROM stdin; |
6171 |
2 1 2 \N \N Poa annua \N \N \N \N \N \N \N \N
|
|
6172 |
4 1 4 \N \N Poa annua L. \N \N \N \N \N \N \N \N
|
|
6173 |
6 1 6 \N \N Poa annua var. eriolepis \N \N \N \N \N \N \N \N
|
|
6174 |
8 1 8 \N \N Poa annua subsp. exilis \N \N \N \N \N \N \N \N
|
|
6175 |
10 1 10 \N \N Poa annua ssp. exilis \N \N \N \N \N \N \N \N
|
|
6176 |
12 1 12 \N \N Poa annua subvar. minima \N \N \N \N \N \N \N \N
|
|
6177 |
14 1 14 \N \N Poa annua fo. lanuginosa \N \N \N \N \N \N \N \N
|
|
6178 |
16 1 16 \N \N Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire \N \N \N \N \N \N \N \N
|
|
6179 |
18 1 18 \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 \N \N
|
|
6180 |
20 1 20 \N \N Fabaceae Inga sp.3 \N \N \N \N \N \N \N \N
|
|
6181 |
22 1 22 \N \N Fabaceae Inga "fuzzy leaf" \N \N \N \N \N \N \N \N
|
|
6182 |
24 1 24 \N \N Fabaceae unknown #2 \N \N \N \N \N \N \N \N
|
|
6183 |
26 1 26 \N \N Fabaceae Boyle#6500 \N \N \N \N \N \N \N \N
|
|
6184 |
28 1 28 \N \N Fam_indet. Boyle#6501 \N \N \N \N \N \N \N \N
|
|
6185 |
30 1 30 \N \N Compositae indet. sp.1 \N \N \N \N \N \N \N \N
|
|
6172 |
2 2 2 \N \N Poa annua \N \N \N \N \N \N \N \N
|
|
6173 |
4 2 4 \N \N Poa annua L. \N \N \N \N \N \N \N \N
|
|
6174 |
6 2 6 \N \N Poa annua var. eriolepis \N \N \N \N \N \N \N \N
|
|
6175 |
8 2 8 \N \N Poa annua subsp. exilis \N \N \N \N \N \N \N \N
|
|
6176 |
10 2 10 \N \N Poa annua ssp. exilis \N \N \N \N \N \N \N \N
|
|
6177 |
12 2 12 \N \N Poa annua subvar. minima \N \N \N \N \N \N \N \N
|
|
6178 |
14 2 14 \N \N Poa annua fo. lanuginosa \N \N \N \N \N \N \N \N
|
|
6179 |
16 2 16 \N \N Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire \N \N \N \N \N \N \N \N
|
|
6180 |
18 2 18 \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 \N \N
|
|
6181 |
20 2 20 \N \N Fabaceae Inga sp.3 \N \N \N \N \N \N \N \N
|
|
6182 |
22 2 22 \N \N Fabaceae Inga "fuzzy leaf" \N \N \N \N \N \N \N \N
|
|
6183 |
24 2 24 \N \N Fabaceae unknown #2 \N \N \N \N \N \N \N \N
|
|
6184 |
26 2 26 \N \N Fabaceae Boyle#6500 \N \N \N \N \N \N \N \N
|
|
6185 |
28 2 28 \N \N Fam_indet. Boyle#6501 \N \N \N \N \N \N \N \N
|
|
6186 |
30 2 30 \N \N Compositae indet. sp.1 \N \N \N \N \N \N \N \N
|
|
6186 | 6187 |
\. |
6187 | 6188 |
|
6188 | 6189 |
|
Also available in: Unified diff
reran inputs/test_taxonomic_names/test_scrub, which generates the public.test_taxonomic_names sample schema