-- Name: view_full_occurrence_individual_view_modify(boolean, anyelement); Type: FUNCTION; Schema: public; Owner: -

CREATE FUNCTION view_full_occurrence_individual_view_modify(repopulate boolean DEFAULT true, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void

	PERFORM util.rematerialize_view('"view_full_occurrence_individual"', '"view_full_occurrence_individual_view"', $$

ALTER TABLE "view_full_occurrence_individual" ADD COLUMN "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" serial PRIMARY KEY;

COMMENT ON COLUMN "view_full_occurrence_individual"."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" IS 'VegBIEN-autogenerated "identifier assigned to each unique observation of a taxon in a plot"';

GRANT SELECT ON TABLE "view_full_occurrence_individual" TO bien_read;

GRANT SELECT ON TABLE "view_full_occurrence_individual_view" TO bien_read;

ALTER TABLE "view_full_occurrence_individual" ALTER COLUMN "datasource__@Brad__.identifier_examples@vegpath.org" SET NOT NULL;

ALTER TABLE "view_full_occurrence_individual" ALTER COLUMN "locationID__@DwC__@vegpath.org" SET NOT NULL;

CREATE INDEX ON "view_full_occurrence_individual" ("datasource__@Brad__.identifier_examples@vegpath.org", "occurrenceID__@DwC__@vegpath.org");

CREATE INDEX ON "view_full_occurrence_individual" ("datasource__@Brad__.identifier_examples@vegpath.org", "[custodial_]institutionCode[s]__@DwC__@vegpath.org", "collectionCode__@DwC__@vegpath.org", "catalogNumber__@DwC__@vegpath.org");

CREATE INDEX ON "view_full_occurrence_individual" ("datasource__@Brad__.identifier_examples@vegpath.org", "projectID__@VegX__.plotObservation@vegpath.org", "locationID__@DwC__@vegpath.org", "eventDate__@DwC__@vegpath.org");

CREATE INDEX ON "view_full_occurrence_individual" ("speciesBinomialWithMorphospecies__@VegCore__@vegpath.org");

-- Name: view_full_occurrence_individual; Type: TABLE; Schema: public; Owner: -; Tablespace: 

CREATE TABLE view_full_occurrence_individual (

-- Name: TABLE view_full_occurrence_individual; Type: COMMENT; Schema: public; Owner: -

COMMENT ON TABLE view_full_occurrence_individual IS '

SELECT view_full_occurrence_individual_view_modify()

-- Name: COLUMN view_full_occurrence_individual."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."datasource__@Brad__.identifier_examples@vegpath.org" IS '"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';

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

COMMENT ON COLUMN view_full_occurrence_individual."country__@DwC__@vegpath.org" IS 'http://geoscrub.geoscrub_output.acceptedCountry__@VegBIEN__@vegpath.org;

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

COMMENT ON COLUMN view_full_occurrence_individual."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 view_full_occurrence_individual."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."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 view_full_occurrence_individual."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

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

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

COMMENT ON COLUMN view_full_occurrence_individual."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 view_full_occurrence_individual."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."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 view_full_occurrence_individual."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS '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.';

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

COMMENT ON COLUMN view_full_occurrence_individual."georeferenceSources__@DwC__@vegpath.org" IS '"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"';

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

COMMENT ON COLUMN view_full_occurrence_individual."georeferenceProtocol__@DwC__@vegpath.org" IS '"A description or reference to the methods used to determine the spatial footprint, coordinates, and uncertainties"';

-- Name: COLUMN view_full_occurrence_individual.geovalid_bien; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual.geovalid_bien IS 'whether the coordinates are within the boundary of the asserted named places';

-- Name: COLUMN view_full_occurrence_individual."isNewWorld_bien"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."isNewWorld_bien" IS 'whether the country is in the Americas';

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

COMMENT ON COLUMN view_full_occurrence_individual."projectID__@VegX__.plotObservation@vegpath.org" IS 'http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;

-- Name: COLUMN view_full_occurrence_individual."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."projectContributor[s]__@VegBank__@vegpath.org" IS '"intersection entit[ies] used to ''link'' a party with a specific project wherein vegetation plots are described"';

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

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

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

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

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

COMMENT ON COLUMN view_full_occurrence_individual."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'http://location.authorlocationcode__@VegBIEN__.public@vegpath.org;

-- Name: COLUMN view_full_occurrence_individual.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual.location__cultivated__bien IS 'whether the occurrence''s *location* was flagged as cultivated. note that this refers just to the cultivated status of the *location*; the occurrence may be cultivated even if the location isn''t.';

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

COMMENT ON COLUMN view_full_occurrence_individual."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'http://locationevent.locationevent_id__@VegBIEN__.public@vegpath.org;

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

COMMENT ON COLUMN view_full_occurrence_individual."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 view_full_occurrence_individual."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'the "elevation (altitude, usually above sea level), in meters"';

-- Name: COLUMN view_full_occurrence_individual."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."slopeAspect[_deg]__@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 view_full_occurrence_individual."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';

-- Name: COLUMN view_full_occurrence_individual."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."plot.area[_ha]__@VegX__@vegpath.org" IS '"Total area of the plot"';

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

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

-- Name: COLUMN view_full_occurrence_individual."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS '"Temperature during observation [...] [in] Celsius"';

-- Name: COLUMN view_full_occurrence_individual."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS '"Total annual precipitation, in mm"';

-- Name: COLUMN view_full_occurrence_individual."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."stratumName__@VegX__.stratum@vegpath.org" IS '"Name associated with this stratum"';

-- Name: COLUMN view_full_occurrence_individual."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."communityConcept.name__@VegX__.communityDet@vegpath.org" IS '"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."';

-- Name: COLUMN view_full_occurrence_individual."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."observationContributor[s]__@VegBank__@vegpath.org" IS '"intersection[s] that link[] a party with a specific plot observation event"';

-- Name: COLUMN view_full_occurrence_individual."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS '"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"';

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

COMMENT ON COLUMN view_full_occurrence_individual."collectionCode__@DwC__@vegpath.org" IS '"The name, acronym, coden, or initialism identifying the collection or data set from which the record was derived"';

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

COMMENT ON COLUMN view_full_occurrence_individual."catalogNumber__@DwC__@vegpath.org" IS '"An identifier (preferably unique) for the record within the data set or collection"';

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

COMMENT ON COLUMN view_full_occurrence_individual."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 view_full_occurrence_individual."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."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 view_full_occurrence_individual."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."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 view_full_occurrence_individual."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'the "date-time (Common Era calendar) in a date-time period during which an organism or group of organisms was collected or observed"';

-- Name: COLUMN view_full_occurrence_individual."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."[verbatim_]family__@DwC__@vegpath.org" IS '"The full scientific name of the family in which the taxon is classified [*before* any TNRS scrubbing]"';

-- Name: COLUMN view_full_occurrence_individual."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."[verbatim_]scientificName__@DwC__@vegpath.org" IS '"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."';

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

COMMENT ON COLUMN view_full_occurrence_individual."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 view_full_occurrence_individual."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

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

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

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

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

COMMENT ON COLUMN view_full_occurrence_individual."Family_matched__@TNRS__@vegpath.org" IS 'http://TNRS.taxon_scrub.matchedFamily__@VegBIEN__.public@vegpath.org;

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

COMMENT ON COLUMN view_full_occurrence_individual."Name_matched__@TNRS__@vegpath.org" IS '"Scientific name with the highest match score. May be an exact match or a fuzzy match."';

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

COMMENT ON COLUMN view_full_occurrence_individual."Name_matched_author__@TNRS__@vegpath.org" IS '"Standard authority for the matched name"';

-- Name: COLUMN view_full_occurrence_individual."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'closed list derived from higher taxa';

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

COMMENT ON COLUMN view_full_occurrence_individual."taxonomicStatus__@DwC__@vegpath.org" IS '"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"."';

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

COMMENT ON COLUMN view_full_occurrence_individual.scrubbed_family IS 'the family of the TNRS accepted or matched name';

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

COMMENT ON COLUMN view_full_occurrence_individual.scrubbed_genus IS 'the genus of the TNRS accepted or matched name';

-- Name: COLUMN view_full_occurrence_individual.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual.scrubbed_specific_epithet IS 'the specific epithet of the TNRS accepted or matched name';

-- Name: COLUMN view_full_occurrence_individual.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual.scrubbed_species_binomial IS 'the species binomial of the TNRS accepted or matched name';

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

COMMENT ON COLUMN view_full_occurrence_individual.scrubbed_taxon_name_no_author IS 'the taxon name without author of the TNRS accepted or matched name';

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

COMMENT ON COLUMN view_full_occurrence_individual.scrubbed_author IS 'the author of the TNRS accepted or matched name';

-- Name: COLUMN view_full_occurrence_individual.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual.scrubbed_taxon_name_with_author IS 'the taxon name with author of the TNRS accepted or matched name';

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

COMMENT ON COLUMN view_full_occurrence_individual."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS 'http://TNRS.taxon_scrub.scrubbed_morphospecies_binomial__@VegBIEN__.public@vegpath.org;

-- Name: COLUMN view_full_occurrence_individual."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS '"Growth form"; "Closed pick list"';

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

COMMENT ON COLUMN view_full_occurrence_individual."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 view_full_occurrence_individual.cultivated_bien; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual.cultivated_bien IS 'whether the occurrence was flagged as cultivated';

-- Name: COLUMN view_full_occurrence_individual."cultivatedBasis_bien"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."cultivatedBasis_bien" IS 'why the occurrence was flagged as cultivated';

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

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

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

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

-- Name: COLUMN view_full_occurrence_individual."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."taxonObservation[.id]__@VegBank__@vegpath.org" IS '"identifier assigned [by the datasource] to each unique observation of a taxon in a plot"';

-- Name: COLUMN view_full_occurrence_individual."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS '"Verbatum short code used by the author to signify the species at time of observation"';

-- Name: COLUMN view_full_occurrence_individual."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS '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)."';

-- Name: COLUMN view_full_occurrence_individual."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."individualOrganismObservation.id__@VegX__@vegpath.org" IS '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)."';

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

COMMENT ON COLUMN view_full_occurrence_individual."individualID__@DwC__@vegpath.org" IS '"An identifier for an individual or named group of individual organisms represented in the Occurrence"';

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

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

-- Name: COLUMN view_full_occurrence_individual."plantobservation.""_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

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

-- Name: COLUMN view_full_occurrence_individual."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" IS 'VegBIEN-autogenerated "identifier assigned to each unique observation of a taxon in a plot"';

 SELECT view_full_occurrence_individual."datasource__@Brad__.identifier_examples@vegpath.org",

    view_full_occurrence_individual."country__@DwC__@vegpath.org",

    view_full_occurrence_individual."stateProvince__@DwC__@vegpath.org",

    view_full_occurrence_individual."county__@DwC__@vegpath.org",

    view_full_occurrence_individual."locality__@DwC__@vegpath.org",

    view_full_occurrence_individual."decimalLatitude__@DwC__@vegpath.org",

    view_full_occurrence_individual."decimalLongitude__@DwC__@vegpath.org",

    view_full_occurrence_individual."coordinateUncertaintyInMeters__@DwC__@vegpath.org",

    view_full_occurrence_individual."georeferenceSources__@DwC__@vegpath.org",

    view_full_occurrence_individual."georeferenceProtocol__@DwC__@vegpath.org",

    view_full_occurrence_individual.geovalid_bien,

    view_full_occurrence_individual."isNewWorld_bien",

    view_full_occurrence_individual."projectID__@VegX__.plotObservation@vegpath.org",

    view_full_occurrence_individual."projectContributor[s]__@VegBank__@vegpath.org",

    view_full_occurrence_individual."locationID__@DwC__@vegpath.org",

    view_full_occurrence_individual."plotName__@VegX__.plot@vegpath.org",

    view_full_occurrence_individual."subplot__@SALVIAS__.Plot_data@vegpath.org",

    view_full_occurrence_individual.location__cultivated__bien,

    view_full_occurrence_individual."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org",

    view_full_occurrence_individual."eventDate__@DwC__@vegpath.org",

    view_full_occurrence_individual."(-minimum-)ElevationInMeters__@DwC__@vegpath.org",

    view_full_occurrence_individual."slopeAspect[_deg]__@VegX__.plot@vegpath.org",

    view_full_occurrence_individual."slopeGradient[_deg]__@VegX__.plot@vegpath.org",

    view_full_occurrence_individual."plot.area[_ha]__@VegX__@vegpath.org",

    view_full_occurrence_individual."samplingProtocol__@DwC__@vegpath.org",

    view_full_occurrence_individual."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",

    view_full_occurrence_individual."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",

    view_full_occurrence_individual."stratumName__@VegX__.stratum@vegpath.org",

    view_full_occurrence_individual."communityConcept.name__@VegX__.communityDet@vegpath.org",

    view_full_occurrence_individual."observationContributor[s]__@VegBank__@vegpath.org",

    view_full_occurrence_individual."[custodial_]institutionCode[s]__@DwC__@vegpath.org",

    view_full_occurrence_individual."collectionCode__@DwC__@vegpath.org",

    view_full_occurrence_individual."catalogNumber__@DwC__@vegpath.org",

    view_full_occurrence_individual."occurrenceID__@DwC__@vegpath.org",

    view_full_occurrence_individual."recordedBy__@DwC__@vegpath.org",

    view_full_occurrence_individual."recordNumber__@DwC__@vegpath.org",

    view_full_occurrence_individual."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",

    view_full_occurrence_individual."[verbatim_]family__@DwC__@vegpath.org",

    view_full_occurrence_individual."[verbatim_]scientificName__@DwC__@vegpath.org",

    view_full_occurrence_individual."identifiedBy__@DwC__@vegpath.org",

    view_full_occurrence_individual."dateIdentified__@DwC__@vegpath.org",

    view_full_occurrence_individual."identificationRemarks__@DwC__@vegpath.org",

    view_full_occurrence_individual."Family_matched__@TNRS__@vegpath.org",

    view_full_occurrence_individual."Name_matched__@TNRS__@vegpath.org",

    view_full_occurrence_individual."Name_matched_author__@TNRS__@vegpath.org",

    view_full_occurrence_individual."[higher_plant_group~]higherClassification__@DwC__@vegpath.org",

    view_full_occurrence_individual."taxonomicStatus__@DwC__@vegpath.org",

    view_full_occurrence_individual.scrubbed_family,

    view_full_occurrence_individual.scrubbed_genus,

    view_full_occurrence_individual.scrubbed_specific_epithet,

    view_full_occurrence_individual.scrubbed_species_binomial,

    view_full_occurrence_individual.scrubbed_taxon_name_no_author,

    view_full_occurrence_individual.scrubbed_author,

    view_full_occurrence_individual.scrubbed_taxon_name_with_author,

    view_full_occurrence_individual."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org",

    view_full_occurrence_individual."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",

    view_full_occurrence_individual."reproductiveCondition__@DwC__@vegpath.org",

    view_full_occurrence_individual.cultivated_bien,

    view_full_occurrence_individual."cultivatedBasis_bien",

    view_full_occurrence_individual."occurrenceRemarks__@DwC__@vegpath.org",

    view_full_occurrence_individual."coverPercent__@VegX__.attribute.ordinal@vegpath.org",

    view_full_occurrence_individual."taxonObservation[.id]__@VegBank__@vegpath.org",

    view_full_occurrence_individual."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",

    view_full_occurrence_individual."aggregateOrganismObservation.id__@VegX__@vegpath.org",

    view_full_occurrence_individual."individualOrganismObservation.id__@VegX__@vegpath.org",

    view_full_occurrence_individual."individualID__@DwC__@vegpath.org",

    view_full_occurrence_individual."individualCount__@DwC__@vegpath.org",

    view_full_occurrence_individual."plantobservation.""_id__@VegBIEN__.public@vegpath.org",

    view_full_occurrence_individual."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org",

   FROM (view_full_occurrence_individual

   LEFT JOIN stemobservation ON ((stemobservation.plantobservation_id = view_full_occurrence_individual."plantobservation.""_id__@VegBIEN__.public@vegpath.org")));

-- Name: view_full_occurrence_individual_view; Type: VIEW; Schema: public; Owner: -

CREATE VIEW view_full_occurrence_individual_view AS

-- Name: VIEW view_full_occurrence_individual_view; Type: COMMENT; Schema: public; Owner: -

COMMENT ON VIEW view_full_occurrence_individual_view IS '

SELECT view_full_occurrence_individual_view_modify()

-- Name: COLUMN view_full_occurrence_individual_view."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."datasource__@Brad__.identifier_examples@vegpath.org" IS '"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';

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

COMMENT ON COLUMN view_full_occurrence_individual_view."country__@DwC__@vegpath.org" IS 'http://geoscrub.geoscrub_output.acceptedCountry__@VegBIEN__@vegpath.org;

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

COMMENT ON COLUMN view_full_occurrence_individual_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 view_full_occurrence_individual_view."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_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 view_full_occurrence_individual_view."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

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

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

COMMENT ON COLUMN view_full_occurrence_individual_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 view_full_occurrence_individual_view."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_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 view_full_occurrence_individual_view."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS '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.';

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

COMMENT ON COLUMN view_full_occurrence_individual_view."georeferenceSources__@DwC__@vegpath.org" IS '"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"';

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

COMMENT ON COLUMN view_full_occurrence_individual_view."georeferenceProtocol__@DwC__@vegpath.org" IS '"A description or reference to the methods used to determine the spatial footprint, coordinates, and uncertainties"';

-- Name: COLUMN view_full_occurrence_individual_view.geovalid_bien; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view.geovalid_bien IS 'whether the coordinates are within the boundary of the asserted named places';

-- Name: COLUMN view_full_occurrence_individual_view."isNewWorld_bien"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."isNewWorld_bien" IS 'whether the country is in the Americas';

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

COMMENT ON COLUMN view_full_occurrence_individual_view."projectID__@VegX__.plotObservation@vegpath.org" IS 'http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;

-- Name: COLUMN view_full_occurrence_individual_view."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."projectContributor[s]__@VegBank__@vegpath.org" IS '"intersection entit[ies] used to ''link'' a party with a specific project wherein vegetation plots are described"';

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

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

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

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

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

COMMENT ON COLUMN view_full_occurrence_individual_view."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'http://location.authorlocationcode__@VegBIEN__.public@vegpath.org;

-- Name: COLUMN view_full_occurrence_individual_view.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view.location__cultivated__bien IS 'whether the occurrence''s *location* was flagged as cultivated. note that this refers just to the cultivated status of the *location*; the occurrence may be cultivated even if the location isn''t.';

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

COMMENT ON COLUMN view_full_occurrence_individual_view."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'http://locationevent.locationevent_id__@VegBIEN__.public@vegpath.org;

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

COMMENT ON COLUMN view_full_occurrence_individual_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 view_full_occurrence_individual_view."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'the "elevation (altitude, usually above sea level), in meters"';

-- Name: COLUMN view_full_occurrence_individual_view."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."slopeAspect[_deg]__@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 view_full_occurrence_individual_view."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';

-- Name: COLUMN view_full_occurrence_individual_view."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."plot.area[_ha]__@VegX__@vegpath.org" IS '"Total area of the plot"';

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

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

-- Name: COLUMN view_full_occurrence_individual_view."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS '"Temperature during observation [...] [in] Celsius"';

-- Name: COLUMN view_full_occurrence_individual_view."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS '"Total annual precipitation, in mm"';

-- Name: COLUMN view_full_occurrence_individual_view."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."stratumName__@VegX__.stratum@vegpath.org" IS '"Name associated with this stratum"';

-- Name: COLUMN view_full_occurrence_individual_view."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."communityConcept.name__@VegX__.communityDet@vegpath.org" IS '"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."';

-- Name: COLUMN view_full_occurrence_individual_view."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."observationContributor[s]__@VegBank__@vegpath.org" IS '"intersection[s] that link[] a party with a specific plot observation event"';

-- Name: COLUMN view_full_occurrence_individual_view."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS '"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"';

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

COMMENT ON COLUMN view_full_occurrence_individual_view."collectionCode__@DwC__@vegpath.org" IS '"The name, acronym, coden, or initialism identifying the collection or data set from which the record was derived"';

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

COMMENT ON COLUMN view_full_occurrence_individual_view."catalogNumber__@DwC__@vegpath.org" IS '"An identifier (preferably unique) for the record within the data set or collection"';

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

COMMENT ON COLUMN view_full_occurrence_individual_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 view_full_occurrence_individual_view."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_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 view_full_occurrence_individual_view."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_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 view_full_occurrence_individual_view."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'the "date-time (Common Era calendar) in a date-time period during which an organism or group of organisms was collected or observed"';

-- Name: COLUMN view_full_occurrence_individual_view."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."[verbatim_]family__@DwC__@vegpath.org" IS '"The full scientific name of the family in which the taxon is classified [*before* any TNRS scrubbing]"';

-- Name: COLUMN view_full_occurrence_individual_view."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."[verbatim_]scientificName__@DwC__@vegpath.org" IS '"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."';

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

COMMENT ON COLUMN view_full_occurrence_individual_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 view_full_occurrence_individual_view."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

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

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

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

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

COMMENT ON COLUMN view_full_occurrence_individual_view."Family_matched__@TNRS__@vegpath.org" IS 'http://TNRS.taxon_scrub.matchedFamily__@VegBIEN__.public@vegpath.org;

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

COMMENT ON COLUMN view_full_occurrence_individual_view."Name_matched__@TNRS__@vegpath.org" IS '"Scientific name with the highest match score. May be an exact match or a fuzzy match."';

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

COMMENT ON COLUMN view_full_occurrence_individual_view."Name_matched_author__@TNRS__@vegpath.org" IS '"Standard authority for the matched name"';

-- Name: COLUMN view_full_occurrence_individual_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'closed list derived from higher taxa';

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

COMMENT ON COLUMN view_full_occurrence_individual_view."taxonomicStatus__@DwC__@vegpath.org" IS '"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"."';

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

COMMENT ON COLUMN view_full_occurrence_individual_view.scrubbed_family IS 'the family of the TNRS accepted or matched name';

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

COMMENT ON COLUMN view_full_occurrence_individual_view.scrubbed_genus IS 'the genus of the TNRS accepted or matched name';

-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view.scrubbed_specific_epithet IS 'the specific epithet of the TNRS accepted or matched name';

-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view.scrubbed_species_binomial IS 'the species binomial of the TNRS accepted or matched name';

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

COMMENT ON COLUMN view_full_occurrence_individual_view.scrubbed_taxon_name_no_author IS 'the taxon name without author of the TNRS accepted or matched name';

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

COMMENT ON COLUMN view_full_occurrence_individual_view.scrubbed_author IS 'the author of the TNRS accepted or matched name';

-- Name: COLUMN view_full_occurrence_individual_view.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view.scrubbed_taxon_name_with_author IS 'the taxon name with author of the TNRS accepted or matched name';

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

COMMENT ON COLUMN view_full_occurrence_individual_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS 'http://TNRS.taxon_scrub.scrubbed_morphospecies_binomial__@VegBIEN__.public@vegpath.org;

-- Name: COLUMN view_full_occurrence_individual_view."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS '"Growth form"; "Closed pick list"';

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

COMMENT ON COLUMN view_full_occurrence_individual_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 view_full_occurrence_individual_view.cultivated_bien; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view.cultivated_bien IS 'whether the occurrence was flagged as cultivated';

-- Name: COLUMN view_full_occurrence_individual_view."cultivatedBasis_bien"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN view_full_occurrence_individual_view."cultivatedBasis_bien" IS 'why the occurrence was flagged as cultivated';

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

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