COMMENT ON COLUMN analytical_stem_view."country@DwC@vegpath.org" IS 'geoscrub.geoscrub_output.acceptedCountry@VegBIEN@vegpath.org;

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

COMMENT ON COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org" IS 'project.sourceaccessioncode@VegBIEN.public@vegpath.org;

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

COMMENT ON COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org;

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

COMMENT ON COLUMN analytical_stem_view."locationevent.locationevent_id@VegBIEN.public@vegpath.org" IS 'locationevent.locationevent_id@VegBIEN.public@vegpath.org;

autogenerated ID for locationevent';

COMMENT ON COLUMN analytical_stem_view."Family_matched@TNRS@vegpath.org" IS 'TNRS.taxon_scrub.matchedFamily@VegBIEN.public@vegpath.org;

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

COMMENT ON COLUMN analytical_stem_view."speciesBinomialWithMorphospecies@VegCore@vegpath.org" IS 'TNRS.taxon_scrub.scrubbed_morphospecies_binomial@VegBIEN.public@vegpath.org;

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

COMMENT ON COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;

"Name or code applied to a specific stem in the plot. This is generally a numeric label to associate a field data entry with a stem in the database."';