-- Name: COLUMN analytical_stem.plantobservation_id; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_stem.taxonobservation_id; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.datasource; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.country; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.state_province; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.county; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.locality; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.latitude; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.longitude; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.coord_uncertainty_m; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.georef_sources; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.georef_protocol; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.is_geovalid; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.is_new_world; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.project_id; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.project_contributors; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.location_id; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.plot_name; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.subplot; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.is_location_cultivated; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.event_date; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.elevation_m; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.slope_aspect_deg; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.slope_gradient_deg; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.plot_area_ha; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.sampling_protocol; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.temperature_c; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.precip_mm; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.stratum_name; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.community_concept_name; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.observation_contributors; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.recorded_by; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.record_number; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.date_collected; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.verbatim_family; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.verbatim_scientific_name; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.identified_by; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.date_identified; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.identification_remarks; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.family_matched; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.name_matched; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.name_matched_author; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.scrubbed_family; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.scrubbed_species_binomial_with_morphospecies; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.scrubbed_author; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.growth_form; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.reproductive_condition; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.is_cultivated; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.is_cultivated_basis; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.occurrence_remarks; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.cover_percent; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.stem_dbh_cm; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.stem_height_m; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.tag; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.relative_x_m; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.relative_y_m; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.taxon_observation_id; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.taxon_name_usage_concept_author_code; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.aggregate_organism_observation_id; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.individual_organism_observation_id; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.individual_id; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.individual_count; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_plot.stem_code; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.datasource; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.country; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.state_province; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.county; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.locality; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.latitude; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.longitude; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.coord_uncertainty_m; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.georef_sources; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.georef_protocol; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.is_geovalid; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.is_new_world; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.is_location_cultivated; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.event_date; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.elevation_m; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.temperature_c; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.precip_mm; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.custodial_institution_codes; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.collection_code; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.catalog_number; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.occurrence_id; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.recorded_by; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.record_number; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.date_collected; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.verbatim_family; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.verbatim_scientific_name; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.identified_by; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.date_identified; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.identification_remarks; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.family_matched; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.name_matched; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.name_matched_author; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.scrubbed_family; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.scrubbed_author; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.growth_form; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.reproductive_condition; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.is_cultivated; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.is_cultivated_basis; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.occurrence_remarks; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.stem_dbh_cm; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.stem_height_m; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN analytical_specimen.tag; Type: COMMENT; Schema: public; Owner: -

--

--

COMMENT ON COLUMN view_full_occurrence_individual.datasource IS 'http://datasource__@Brad__.identifier_examples@vegpath.org;

"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';

COMMENT ON COLUMN view_full_occurrence_individual.country IS 'http://country__@DwC__@vegpath.org;

http://geoscrub.geoscrub_output.acceptedCountry__@VegBIEN__@vegpath.org;

COMMENT ON COLUMN view_full_occurrence_individual.state_province IS 'http://stateProvince__@DwC__@vegpath.org;

"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"';

COMMENT ON COLUMN view_full_occurrence_individual.county IS 'http://county__@DwC__@vegpath.org;

"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"';

COMMENT ON COLUMN view_full_occurrence_individual.locality IS 'http://locality__@DwC__@vegpath.org;

"The specific description of the place"';

COMMENT ON COLUMN view_full_occurrence_individual.latitude IS 'http://decimalLatitude__@DwC__@vegpath.org;

"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';

COMMENT ON COLUMN view_full_occurrence_individual.longitude IS 'http://decimalLongitude__@DwC__@vegpath.org;

"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';

COMMENT ON COLUMN view_full_occurrence_individual.coord_uncertainty_m IS 'http://coordinateUncertaintyInMeters__@DwC__@vegpath.org;

for a point observation, this is the fuzziness of the coordinates. for a plot (or other shape), this is the radius of the circle that circumscribes the entire plot, or the fuzziness, whichever is greater. note that the DwC definition is confusingly worded: it uses the ambiguous term Location, which sometimes refers to the asserted named place, but which they intended to refer to the plot or point.';

COMMENT ON COLUMN view_full_occurrence_individual.georef_sources IS 'http://georeferenceSources__@DwC__@vegpath.org;

"A list (concatenated and separated) of maps, gazetteers, or other resources used to georeference the Location, described specifically enough to allow anyone in the future to use the same resources"';

COMMENT ON COLUMN view_full_occurrence_individual.georef_protocol IS 'http://georeferenceProtocol__@DwC__@vegpath.org;

"A description or reference to the methods used to determine the spatial footprint, coordinates, and uncertainties"';

COMMENT ON COLUMN view_full_occurrence_individual.project_id IS 'http://projectID__@VegX__.plotObservation@vegpath.org;

http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;

COMMENT ON COLUMN view_full_occurrence_individual.project_contributors IS 'http://projectContributor[s]__@VegBank__@vegpath.org;

"intersection entit[ies] used to ''link'' a party with a specific project wherein vegetation plots are described"';

COMMENT ON COLUMN view_full_occurrence_individual.location_id IS 'http://locationID__@DwC__@vegpath.org;

"An identifier for the set of location information (data associated with dcterms:Location)"';

COMMENT ON COLUMN view_full_occurrence_individual.plot_name IS 'http://plotName__@VegX__.plot@vegpath.org;

"Name or label for a plot"';

COMMENT ON COLUMN view_full_occurrence_individual.subplot IS 'http://subplot__@SALVIAS__.Plot_data@vegpath.org;

http://location.authorlocationcode__@VegBIEN__.public@vegpath.org;

COMMENT ON COLUMN view_full_occurrence_individual.event_date IS 'http://eventDate__@DwC__@vegpath.org;

"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."';

COMMENT ON COLUMN view_full_occurrence_individual.elevation_m IS 'http://(-minimum-)ElevationInMeters__@DwC__@vegpath.org;

the "elevation (altitude, usually above sea level), in meters"';

COMMENT ON COLUMN view_full_occurrence_individual.slope_aspect_deg IS 'http://slopeAspect[_deg]__@VegX__.plot@vegpath.org;

"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';

COMMENT ON COLUMN view_full_occurrence_individual.slope_gradient_deg IS 'http://slopeGradient[_deg]__@VegX__.plot@vegpath.org;

"Representative inclination of slope in degrees"';

COMMENT ON COLUMN view_full_occurrence_individual.plot_area_ha IS 'http://plot.area[_ha]__@VegX__@vegpath.org;

"Total area of the plot"';

COMMENT ON COLUMN view_full_occurrence_individual.sampling_protocol IS 'http://samplingProtocol__@DwC__@vegpath.org;

"The name of, reference to, or description of the method or protocol used during an Event"';

COMMENT ON COLUMN view_full_occurrence_individual.temperature_c IS 'http://temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org;

"Temperature during observation [...] [in] Celsius"';

COMMENT ON COLUMN view_full_occurrence_individual.precip_mm IS 'http://precip_mm__@SALVIAS__.Plot_metadata@vegpath.org;

"Total annual precipitation, in mm"';

COMMENT ON COLUMN view_full_occurrence_individual.stratum_name IS 'http://stratumName__@VegX__.stratum@vegpath.org;

"Name associated with this stratum"';

COMMENT ON COLUMN view_full_occurrence_individual.community_concept_name IS 'http://communityConcept.name__@VegX__.communityDet@vegpath.org;

"A textual label for a community type. A community type is an abstract grouping of organisms that tend to co-occur on the landscape due to shared ecological requirements or preferences."';

COMMENT ON COLUMN view_full_occurrence_individual.observation_contributors IS 'http://observationContributor[s]__@VegBank__@vegpath.org;

"intersection[s] that link[] a party with a specific plot observation event"';

COMMENT ON COLUMN view_full_occurrence_individual.custodial_institution_codes IS 'http://[custodial_]institutionCode[s]__@DwC__@vegpath.org;

"The name[s] (or acronym[s]) in use by the institution[s] having custody of the object(s) or information referred to in the record"';

COMMENT ON COLUMN view_full_occurrence_individual.collection_code IS 'http://collectionCode__@DwC__@vegpath.org;

"The name, acronym, coden, or initialism identifying the collection or data set from which the record was derived"';

COMMENT ON COLUMN view_full_occurrence_individual.catalog_number IS 'http://catalogNumber__@DwC__@vegpath.org;

"An identifier (preferably unique) for the record within the data set or collection"';

COMMENT ON COLUMN view_full_occurrence_individual.occurrence_id IS 'http://occurrenceID__@DwC__@vegpath.org;

"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."';

COMMENT ON COLUMN view_full_occurrence_individual.recorded_by IS 'http://recordedBy__@DwC__@vegpath.org;

"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."';

COMMENT ON COLUMN view_full_occurrence_individual.record_number IS 'http://recordNumber__@DwC__@vegpath.org;

"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."';

COMMENT ON COLUMN view_full_occurrence_individual.date_collected IS 'http://(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org;

the "date-time (Common Era calendar) in a date-time period during which an organism or group of organisms was collected or observed"';

COMMENT ON COLUMN view_full_occurrence_individual.verbatim_family IS 'http://[verbatim_]family__@DwC__@vegpath.org;

"The full scientific name of the family in which the taxon is classified [*before* any TNRS scrubbing]"';

COMMENT ON COLUMN view_full_occurrence_individual.verbatim_scientific_name IS 'http://[verbatim_]scientificName__@DwC__@vegpath.org;

"The full scientific name [*before* any TNRS scrubbing], with authorship and date information if known. When forming part of an Identification, this should be the name in lowest level taxonomic rank that can be determined."';

COMMENT ON COLUMN view_full_occurrence_individual.identified_by IS 'http://identifiedBy__@DwC__@vegpath.org;

"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"';

COMMENT ON COLUMN view_full_occurrence_individual.date_identified IS 'http://dateIdentified__@DwC__@vegpath.org;

"The date on which the subject was identified as representing the Taxon"';

COMMENT ON COLUMN view_full_occurrence_individual.identification_remarks IS 'http://identificationRemarks__@DwC__@vegpath.org;

"Comments or notes about the Identification"';

COMMENT ON COLUMN view_full_occurrence_individual.family_matched IS 'http://Family_matched__@TNRS__@vegpath.org;

http://TNRS.taxon_scrub.matchedFamily__@VegBIEN__@vegpath.org;

COMMENT ON COLUMN view_full_occurrence_individual.name_matched IS 'http://Name_matched__@TNRS__@vegpath.org;

"Scientific name with the highest match score. May be an exact match or a fuzzy match."';

COMMENT ON COLUMN view_full_occurrence_individual.name_matched_author IS 'http://Name_matched_author__@TNRS__@vegpath.org;

"Standard authority for the matched name"';

COMMENT ON COLUMN view_full_occurrence_individual.higher_plant_group IS 'http://[higher_plant_group~]higherClassification__@DwC__@vegpath.org;

closed list derived from higher taxa';

COMMENT ON COLUMN view_full_occurrence_individual.taxonomic_status IS 'http://taxonomicStatus__@DwC__@vegpath.org;

"The status of the use of the scientificName as a label for a taxon. Requires taxonomic opinion to define the scope of a taxon. [...] Examples: "invalid", "misapplied", "homotypic synonym", "accepted"."';

COMMENT ON COLUMN view_full_occurrence_individual.scrubbed_species_binomial_with_morphospecies IS 'http://speciesBinomialWithMorphospecies__@VegCore__@vegpath.org;

http://TNRS.taxon_scrub.scrubbed_morphospecies_binomial__@VegBIEN__.public@vegpath.org;

COMMENT ON COLUMN view_full_occurrence_individual.growth_form IS 'http://[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org;

"Growth form"; "Closed pick list"';

COMMENT ON COLUMN view_full_occurrence_individual.reproductive_condition IS 'http://reproductiveCondition__@DwC__@vegpath.org;

"The reproductive condition of the biological individual(s) represented in the Occurrence. Recommended best practice is to use a controlled vocabulary."';

COMMENT ON COLUMN view_full_occurrence_individual.occurrence_remarks IS 'http://occurrenceRemarks__@DwC__@vegpath.org;

"Comments or notes about the Occurrence"';

COMMENT ON COLUMN view_full_occurrence_individual.cover_percent IS 'http://coverPercent__@VegX__.attribute.ordinal@vegpath.org;

"Average cover of the index in percent"';

COMMENT ON COLUMN view_full_occurrence_individual.taxon_observation_id IS 'http://taxonObservation[.id]__@VegBank__@vegpath.org;

"identifier assigned [by the datasource] to each unique observation of a taxon in a plot"';

COMMENT ON COLUMN view_full_occurrence_individual.taxon_name_usage_concept_author_code IS 'http://taxonNameUsageConcept.authorCode__@VegX__@vegpath.org;

"Verbat[i]m short code used by the author to signify the species at time of observation"';

COMMENT ON COLUMN view_full_occurrence_individual.aggregate_organism_observation_id IS 'http://aggregateOrganismObservation.id__@VegX__@vegpath.org;

the ID for "An observation applying to all occurrences of an organism based on an aggregation factor. It contains an AggregateValue, which is an assessment of the overall occurrence of an organism in a Plot (e.g. number of stems, percentage cover, total biomass, basal area)."';

COMMENT ON COLUMN view_full_occurrence_individual.individual_organism_observation_id IS 'http://individualOrganismObservation.id__@VegX__@vegpath.org;

the ID for "An observation applying to one occurrence of an organism (or part of an organism). It is a container for measurements made on the organism (e.g. diameter, height, crown dimensions, biomass, growth form, number of stems)."';

COMMENT ON COLUMN view_full_occurrence_individual.individual_id IS 'http://individualID__@DwC__@vegpath.org;

"An identifier for an individual or named group of individual organisms represented in the Occurrence"';

COMMENT ON COLUMN view_full_occurrence_individual.individual_count IS 'http://individualCount__@DwC__@vegpath.org;

"The number of individuals represented present at the time of the Occurrence"';

COMMENT ON COLUMN view_full_occurrence_individual.plantobservation_id IS 'http://plantobservation."_id__@VegBIEN__.public@vegpath.org;

VegBIEN-autogenerated identifier for the individual';

COMMENT ON COLUMN view_full_occurrence_individual.taxonobservation_id IS 'http://TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org;

VegBIEN-autogenerated "identifier assigned to each unique observation of a taxon in a plot"';

COMMENT ON COLUMN analytical_stem.datasource IS 'http://datasource__@Brad__.identifier_examples@vegpath.org;

"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';

COMMENT ON COLUMN analytical_stem.country IS 'http://country__@DwC__@vegpath.org;

http://geoscrub.geoscrub_output.acceptedCountry__@VegBIEN__@vegpath.org;

COMMENT ON COLUMN analytical_stem.state_province IS 'http://stateProvince__@DwC__@vegpath.org;

"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"';

COMMENT ON COLUMN analytical_stem.county IS 'http://county__@DwC__@vegpath.org;

"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"';

COMMENT ON COLUMN analytical_stem.locality IS 'http://locality__@DwC__@vegpath.org;

"The specific description of the place"';

COMMENT ON COLUMN analytical_stem.latitude IS 'http://decimalLatitude__@DwC__@vegpath.org;

"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';

COMMENT ON COLUMN analytical_stem.longitude IS 'http://decimalLongitude__@DwC__@vegpath.org;

"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';

COMMENT ON COLUMN analytical_stem.coord_uncertainty_m IS 'http://coordinateUncertaintyInMeters__@DwC__@vegpath.org;

for a point observation, this is the fuzziness of the coordinates. for a plot (or other shape), this is the radius of the circle that circumscribes the entire plot, or the fuzziness, whichever is greater. note that the DwC definition is confusingly worded: it uses the ambiguous term Location, which sometimes refers to the asserted named place, but which they intended to refer to the plot or point.';

COMMENT ON COLUMN analytical_stem.georef_sources IS 'http://georeferenceSources__@DwC__@vegpath.org;

"A list (concatenated and separated) of maps, gazetteers, or other resources used to georeference the Location, described specifically enough to allow anyone in the future to use the same resources"';

COMMENT ON COLUMN analytical_stem.georef_protocol IS 'http://georeferenceProtocol__@DwC__@vegpath.org;

"A description or reference to the methods used to determine the spatial footprint, coordinates, and uncertainties"';

COMMENT ON COLUMN analytical_stem.project_id IS 'http://projectID__@VegX__.plotObservation@vegpath.org;

http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;

COMMENT ON COLUMN analytical_stem.project_contributors IS 'http://projectContributor[s]__@VegBank__@vegpath.org;

"intersection entit[ies] used to ''link'' a party with a specific project wherein vegetation plots are described"';

COMMENT ON COLUMN analytical_stem.location_id IS 'http://locationID__@DwC__@vegpath.org;

"An identifier for the set of location information (data associated with dcterms:Location)"';

COMMENT ON COLUMN analytical_stem.plot_name IS 'http://plotName__@VegX__.plot@vegpath.org;

"Name or label for a plot"';

COMMENT ON COLUMN analytical_stem.subplot IS 'http://subplot__@SALVIAS__.Plot_data@vegpath.org;

http://location.authorlocationcode__@VegBIEN__.public@vegpath.org;