"plot.**".country AS "country__@DwC__@vegpath.org", 

    "plot.**"."stateProvince" AS "stateProvince__@DwC__@vegpath.org", 

    "plot.**".county AS "county__@DwC__@vegpath.org", 

    "plot.**".locality AS "locality__@DwC__@vegpath.org", 

    "plot.**"."decimalLatitude" AS "decimalLatitude__@DwC__@vegpath.org", 

    "plot.**"."decimalLongitude" AS "decimalLongitude__@DwC__@vegpath.org", 

    "plot.**"."coordinateUncertaintyInMeters" AS "coordinateUncertaintyInMeters__@DwC__@vegpath.org", 

    "plot.**"."projectID" AS "projectID__@VegX__.plotObservation@vegpath.org", 

    "plot.**"."locationID" AS "locationID__@DwC__@vegpath.org", 

    "plot.**"."locationName" AS "plotName__@VegX__.plot@vegpath.org", 

    "plot.**".subplot AS "subplot__@SALVIAS__@vegpath.org", 

    "plot.**".locationevent__pkey AS "locationevent.locationevent_id__@VegBIEN__.public@vegpath.org", 

    "plot.**"."eventDate" AS "eventDate__@DwC__@vegpath.org", 

    "plot.**"."slopeAspect" AS "slopeAspect__@VegX__.plot@vegpath.org", 

    "plot.**"."slopeGradient" AS "slopeGradient__@VegX__.plot@vegpath.org", 

    "plot.**"."samplingProtocol" AS "samplingProtocol__@DwC__@vegpath.org", 

    specimenreplicate.sourceaccessioncode AS "occurrenceID__@DwC__@vegpath.org", 

    collector.fullname AS "recordedBy__@DwC__@vegpath.org", 

    plantobservation.authorplantcode AS "recordNumber__@DwC__@vegpath.org", 

    identifiedby.fullname AS "identifiedBy__@DwC__@vegpath.org", 

    taxondetermination.determinationdate AS "dateIdentified__@DwC__@vegpath.org", 

    taxondetermination.notes AS "identificationRemarks__@DwC__@vegpath.org", 

    taxon_scrub."matchedFamily" AS "Family_matched__@TNRS__@vegpath.org", 

    taxon_scrub.scrubbed_morphospecies_binomial AS "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org", 

    plantobservation.reproductivecondition AS "reproductiveCondition__@DwC__@vegpath.org", 

    aggregateoccurrence.notes AS "occurrenceRemarks__@DwC__@vegpath.org", 

    _fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent__@VegX__.attribute.ordinal@vegpath.org", 

    aggregateoccurrence.count AS "individualCount__@DwC__@vegpath.org", 

    stemobservation.authorstemcode AS "stemCode__@VegBank__.stemlocation@vegpath.org"

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

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

-- Name: COLUMN analytical_stem_view."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."stateProvince__@DwC__@vegpath.org" IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"';

-- Name: COLUMN analytical_stem_view."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."county__@DwC__@vegpath.org" IS '"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"';

-- Name: COLUMN analytical_stem_view."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

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

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

COMMENT ON COLUMN analytical_stem_view."decimalLatitude__@DwC__@vegpath.org" IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';

-- Name: COLUMN analytical_stem_view."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."decimalLongitude__@DwC__@vegpath.org" IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';

-- Name: COLUMN analytical_stem_view."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS '"The horizontal distance (in meters) from the given decimalLatitude and decimalLongitude describing the smallest circle containing the whole of the Location"';

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

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

-- Name: COLUMN analytical_stem_view."locationID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

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

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

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

-- Name: COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

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

-- Name: COLUMN analytical_stem_view."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

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

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

COMMENT ON COLUMN analytical_stem_view."eventDate__@DwC__@vegpath.org" IS '"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."';

-- Name: COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';

-- Name: COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';

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

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

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

COMMENT ON COLUMN analytical_stem_view."occurrenceID__@DwC__@vegpath.org" IS '"An identifier for the Occurrence (as opposed to a particular digital record of the occurrence). In the absence of a persistent global unique identifier, construct one from a combination of identifiers in the record that will most closely make the occurrenceID globally unique."';

-- Name: COLUMN analytical_stem_view."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."recordedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."';

-- Name: COLUMN analytical_stem_view."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."recordNumber__@DwC__@vegpath.org" IS '"An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector''s number."';

-- Name: COLUMN analytical_stem_view."identifiedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."identifiedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"';

-- Name: COLUMN analytical_stem_view."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

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

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

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

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

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

-- Name: COLUMN analytical_stem_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

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

-- Name: COLUMN analytical_stem_view."reproductiveCondition__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."reproductiveCondition__@DwC__@vegpath.org" IS '"The reproductive condition of the biological individual(s) represented in the Occurrence. Recommended best practice is to use a controlled vocabulary."';

-- Name: COLUMN analytical_stem_view."occurrenceRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Occurrence"';

-- Name: COLUMN analytical_stem_view."coverPercent__@VegX__.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."coverPercent__@VegX__.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';

-- Name: COLUMN analytical_stem_view."individualCount__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem_view."individualCount__@DwC__@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';

-- Name: COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

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