`plantobservation.``_id__@VegBIEN__.public@vegpath.org` int(11),

    `stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org` double,

    `stemHeight[_m]__@VegBank__.stemCount@vegpath.org` double,

    `[tag=]identificationLabel__@VegX__.individual@vegpath.org` varchar(255),

    `relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org` double,

    `relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org` double,

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

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

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

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

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

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

-- Name: COLUMN analytical_stem.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN analytical_stem.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN analytical_stem.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN analytical_stem.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN analytical_stem.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- 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: COLUMN analytical_stem_view.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

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

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

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

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

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

-- Name: COLUMN analytical_stem_view.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN analytical_stem_view.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN analytical_stem_view.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN analytical_stem_view.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

-- Name: COLUMN analytical_stem_view.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -

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

--

--

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

    "stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" double precision,

    "stemHeight[_m]__@VegBank__.stemCount@vegpath.org" double precision,

    "[tag=]identificationLabel__@VegX__.individual@vegpath.org" text,

    "relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" double precision,

    "relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" double precision,

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

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

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

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

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

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

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

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

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

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

-- Name: COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS '"Diameter at breast height of this stem (usually taken at 1.3 meters, but may vary)"';

-- Name: COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS '"The measured height of the stem in meters"';

-- Name: COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS '"A label that is associated with an individual (e.g. a numerical tree tag)"';

-- Name: COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The X-coordinate of the related item position in m. The user will enter the relative position of related item with respect to the plot origin (in meters) with the x-axis defined by the plot azimuth."';

-- Name: COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -

COMMENT ON COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The Y-coordinate of the relatedSpatialItem position in m. The user will enter the relative position of relatedSpatialItems with respect to the plot origin (in meters) with the y-axis defined by the plot azimuth."';

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

CREATE VIEW "viewFullOccurrence_individual_view" AS

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

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

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