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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

-- Name: COLUMN `viewFullOccurrence_individual_view`.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

-- Name: COLUMN `viewFullOccurrence_individual_view`.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

--

--

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

--

--

-- Name: COLUMN `viewFullOccurrence_individual_view`.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

-- Name: COLUMN `viewFullOccurrence_individual_view`.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

-- Name: COLUMN `viewFullOccurrence_individual_view`.cultivated_bien; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN `viewFullOccurrence_individual_view`.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

-- Name: viewFullOccurrence_individual_view; Type: ACL; Schema: public; Owner: -

--

--

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

--

CREATE VIEW "viewFullOccurrence_individual_view" AS

 SELECT "plot.**"."datasource__@Brad__.identifier_examples@vegpath.org",

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

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

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

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

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

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

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

    "plot.**"."georeferenceSources__@DwC__@vegpath.org",

    "plot.**"."georeferenceProtocol__@DwC__@vegpath.org",

    "plot.**".geovalid_bien,

    "plot.**"."isNewWorld_bien",

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

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

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

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

    "plot.**"."subplot__@SALVIAS__.Plot_data@vegpath.org",

    "plot.**".location__cultivated__bien,

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

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

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

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

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

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

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

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

    "plot.**"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",

    "plot.**"."stratumName__@VegX__.stratum@vegpath.org",

    "plot.**"."communityConcept.name__@VegX__.communityDet@vegpath.org",

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

    sourcelist.name AS "[custodial_]institutionCode[s]__@DwC__@vegpath.org",

    specimenreplicate.collectioncode_dwc AS "collectionCode__@DwC__@vegpath.org",

    specimenreplicate.catalognumber_dwc AS "catalogNumber__@DwC__@vegpath.org",

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

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

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

    COALESCE(aggregateoccurrence.collectiondate, "plot.**"."eventDate__@DwC__@vegpath.org") AS "(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",

    taxonverbatim.family AS "[verbatim_]family__@DwC__@vegpath.org",

    COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS "[verbatim_]scientificName__@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."*Name_matched_accepted_family" AS "Family_matched__@TNRS__@vegpath.org",

    taxon_scrub."*Name_matched" AS "Name_matched__@TNRS__@vegpath.org",

    taxon_scrub."*Name_matched_author" AS "Name_matched_author__@TNRS__@vegpath.org",

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

    taxon_scrub."taxonomicStatus" AS "taxonomicStatus__@DwC__@vegpath.org",

    taxon_scrub.scrubbed_family,

    taxon_scrub.scrubbed_genus,

    taxon_scrub.scrubbed_specific_epithet,

    ((taxon_scrub.scrubbed_genus || ' '::text) || taxon_scrub.scrubbed_specific_epithet) AS scrubbed_species_binomial,

    taxon_scrub.scrubbed_taxon_name_no_author,

    taxon_scrub.scrubbed_author,

    taxon_scrub.scrubbed_taxon_name_with_author,

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

    taxonoccurrence.growthform AS "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",

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

    (((cultivated_family_locations.country IS NOT NULL) OR _or(taxonoccurrence.iscultivated, "plot.**".location__cultivated__bien)))::integer AS cultivated_bien,

        CASE

            WHEN (taxonoccurrence.iscultivated IS NOT NULL) THEN taxonoccurrence.cultivatedbasis

            WHEN ("plot.**".location__cultivated__bien IS NOT NULL) THEN NULL::text

            ELSE NULL::text

        END AS "cultivatedBasis_bien",

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

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

    taxonoccurrence.sourceaccessioncode AS "taxonObservation[.id]__@VegBank__@vegpath.org",

    taxonoccurrence.authortaxoncode AS "taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",

    aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservation.id__@VegX__@vegpath.org",

    plantobservation.sourceaccessioncode AS "individualOrganismObservation.id__@VegX__@vegpath.org",

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

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

    plantobservation.plantobservation_id AS "plantobservation.""_id__@VegBIEN__.public@vegpath.org"

   FROM ((((((((((((("plot.**"

   LEFT JOIN taxonoccurrence ON ((taxonoccurrence.locationevent_id = "plot.**"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org")))

   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 specimenreplicate USING (plantobservation_id))

   LEFT JOIN sourcelist ON ((sourcelist.sourcelist_id = specimenreplicate.duplicate_institutions_sourcelist_id)))

   LEFT JOIN taxondetermination ON (((taxondetermination.taxonoccurrence_id = taxonoccurrence.taxonoccurrence_id) AND taxondetermination.iscurrent)))

   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".taxon_scrub ON ((taxon_scrub."*Name_submitted" = taxonlabel.taxonomicname)))

   LEFT JOIN family_higher_plant_group ON ((family_higher_plant_group.family = taxon_scrub.scrubbed_family)))

   LEFT JOIN cultivated_family_locations ON (((cultivated_family_locations.family = taxon_scrub.scrubbed_family) AND (cultivated_family_locations.country = "plot.**"."country__@DwC__@vegpath.org"))));

--

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

--

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

--

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

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view".geovalid_bien; Type: COMMENT; Schema: public; Owner: -

--

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

--

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

--

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

--

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

--

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

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

--

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

autogenerated ID for locationevent';

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view"."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

--

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

--

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view"."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view"."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view"."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

--

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

--

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

--

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

--

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

--

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

--

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

--

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

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view"."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view".scrubbed_family; Type: COMMENT; Schema: public; Owner: -

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

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

a morphospecies is a custom species name assigned in the field by the collector (which does not validate to anything in TNRS)';

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_individual_view"."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 "viewFullOccurrence_individual_view"."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

--

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

--

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

--

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

--

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

--

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

--

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

autogenerated ID for plantobservation';

--

-- Name: viewFullOccurrence_individual_view; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE "viewFullOccurrence_individual_view" FROM PUBLIC;

REVOKE ALL ON TABLE "viewFullOccurrence_individual_view" FROM bien;

GRANT ALL ON TABLE "viewFullOccurrence_individual_view" TO bien;

GRANT SELECT ON TABLE "viewFullOccurrence_individual_view" TO bien_read;

--

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

--

CREATE VIEW "viewFullOccurrence_individual_view" AS

 SELECT "plot.**"."datasource__@Brad__.identifier_examples@vegpath.org",

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

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

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

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

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

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

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

    "plot.**"."georeferenceSources__@DwC__@vegpath.org",

    "plot.**"."georeferenceProtocol__@DwC__@vegpath.org",

    "plot.**".geovalid_bien,

    "plot.**"."isNewWorld_bien",

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

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

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

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

    "plot.**"."subplot__@SALVIAS__.Plot_data@vegpath.org",

    "plot.**".location__cultivated__bien,

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

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

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

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

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

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

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

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

    "plot.**"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",

    "plot.**"."stratumName__@VegX__.stratum@vegpath.org",

    "plot.**"."communityConcept.name__@VegX__.communityDet@vegpath.org",

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

    sourcelist.name AS "[custodial_]institutionCode[s]__@DwC__@vegpath.org",

    specimenreplicate.collectioncode_dwc AS "collectionCode__@DwC__@vegpath.org",

    specimenreplicate.catalognumber_dwc AS "catalogNumber__@DwC__@vegpath.org",

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

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

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

    COALESCE(aggregateoccurrence.collectiondate, "plot.**"."eventDate__@DwC__@vegpath.org") AS "(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",

    taxonverbatim.family AS "[verbatim_]family__@DwC__@vegpath.org",

    COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS "[verbatim_]scientificName__@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."*Name_matched_accepted_family" AS "Family_matched__@TNRS__@vegpath.org",

    taxon_scrub."*Name_matched" AS "Name_matched__@TNRS__@vegpath.org",

    taxon_scrub."*Name_matched_author" AS "Name_matched_author__@TNRS__@vegpath.org",

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

    taxon_scrub."taxonomicStatus" AS "taxonomicStatus__@DwC__@vegpath.org",

    taxon_scrub.scrubbed_family,

    taxon_scrub.scrubbed_genus,

    taxon_scrub.scrubbed_specific_epithet,

    ((taxon_scrub.scrubbed_genus || ' '::text) || taxon_scrub.scrubbed_specific_epithet) AS scrubbed_species_binomial,

    taxon_scrub.scrubbed_taxon_name_no_author,

    taxon_scrub.scrubbed_author,

    taxon_scrub.scrubbed_taxon_name_with_author,

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

    taxonoccurrence.growthform AS "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",

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

    (((cultivated_family_locations.country IS NOT NULL) OR _or(taxonoccurrence.iscultivated, "plot.**".location__cultivated__bien)))::integer AS cultivated_bien,

        CASE

            WHEN (taxonoccurrence.iscultivated IS NOT NULL) THEN taxonoccurrence.cultivatedbasis

            WHEN ("plot.**".location__cultivated__bien IS NOT NULL) THEN NULL::text

            ELSE NULL::text

        END AS "cultivatedBasis_bien",

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

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

    taxonoccurrence.sourceaccessioncode AS "taxonObservation[.id]__@VegBank__@vegpath.org",

    taxonoccurrence.authortaxoncode AS "taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",

    aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservation.id__@VegX__@vegpath.org",

    plantobservation.sourceaccessioncode AS "individualOrganismObservation.id__@VegX__@vegpath.org",

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

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

    plantobservation.plantobservation_id AS "plantobservation.""_id__@VegBIEN__.public@vegpath.org"

   FROM ((((((((((((("plot.**"

   LEFT JOIN taxonoccurrence ON ((taxonoccurrence.locationevent_id = "plot.**"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org")))

   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 specimenreplicate USING (plantobservation_id))

   LEFT JOIN sourcelist ON ((sourcelist.sourcelist_id = specimenreplicate.duplicate_institutions_sourcelist_id)))

   LEFT JOIN taxondetermination ON (((taxondetermination.taxonoccurrence_id = taxonoccurrence.taxonoccurrence_id) AND taxondetermination.iscurrent)))

   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".taxon_scrub ON ((taxon_scrub."*Name_submitted" = taxonlabel.taxonomicname)))

   LEFT JOIN family_higher_plant_group ON ((family_higher_plant_group.family = taxon_scrub.scrubbed_family)))

   LEFT JOIN cultivated_family_locations ON (((cultivated_family_locations.family = taxon_scrub.scrubbed_family) AND (cultivated_family_locations.country = "plot.**"."country__@DwC__@vegpath.org"))));

--

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

--

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

--

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

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view".geovalid_bien; Type: COMMENT; Schema: public; Owner: -

--

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

--

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

--

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

--

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

--

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

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

--

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

autogenerated ID for locationevent';

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view"."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

--

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

--

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view"."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view"."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "viewFullOccurrence_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 "viewFullOccurrence_individual_view"."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

--

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

--

COMMENT ON COLUMN "viewFullOccurrence_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"';

--