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

--

CREATE TABLE coordinates (

    coordinates_id integer NOT NULL,

    source_id integer NOT NULL,

    latitude_deg double precision NOT NULL,

    longitude_deg double precision NOT NULL,

    verbatimlatitude text,

    verbatimlongitude text,

    verbatimcoordinates text,

    footprintgeometry_dwc text,

    coordsaccuracy_m double precision

);

--

-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN coordinates.footprintgeometry_dwc IS '

DwC''s footprintWKT field. "A Well-Known Text (WKT) representation of the shape (footprint, geometry) that defines the Location" (http://rs.tdwg.org/dwc/terms/#footprintWKT).

';

--

-- Name: COLUMN coordinates.coordsaccuracy_m; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN coordinates.coordsaccuracy_m IS '

Accuracy of latitude/longitude or footprint geometry, in meters. This should generally be at least 1 m, which is the accuracy of the best GPSes.

';

--

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

--

CREATE TABLE cultivated_family_locations (

    family text NOT NULL,

    country text NOT NULL

);

--

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

--

COMMENT ON TABLE cultivated_family_locations IS '

from sftp://nimoy.nceas.ucsb.edu/home/bien/bien2_scripts/geoscrub/cultivated/cult_by_taxon/flag_by_taxa.inc

';

--

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

--

CREATE TABLE family_higher_plant_group (

    family text NOT NULL,

    higher_plant_group higher_plant_group

);

--

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

--

CREATE TABLE location (

    location_id integer NOT NULL,

    source_id integer NOT NULL,

    sourceaccessioncode text,

    plot_location_id integer NOT NULL,

    parent_id integer,

    authorlocationcode text,

    place_id integer,

    accesslevel accesslevel,

    accessconditions text,

    sublocationxposition_m double precision,

    sublocationyposition_m double precision,

    iscultivated boolean,

    authorzone text,

    authordatum text,

    authorlocation text,

    locationnarrative text,

    azimuth double precision,

    shape text,

    area_m2 double precision,

    standsize text,

    placementmethod text,

    permanence boolean,

    layoutnarrative text,

    elevation_m double precision,

    elevationaccuracy_m double precision,

    elevationrange_m double precision,

    verbatimelevation text,

    slopeaspect_deg double precision,

    minslopeaspect_deg double precision,

    maxslopeaspect_deg double precision,

    slopegradient_fraction double precision,

    minslopegradient_fraction double precision,

    maxslopegradient_fraction double precision,

    topoposition text,

    landform text,

    surficialdeposits text,

    rocktype text,

    submitter_surname text,

    submitter_givenname text,

    submitter_email text,

    notespublic boolean,

    notesmgt boolean,

    revisions boolean,

    dateentered date DEFAULT now(),

    locationrationalenarrative text,

    CONSTRAINT location_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (authorlocationcode IS NOT NULL)))

);

--

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

--

COMMENT ON TABLE location IS '

Equivalent to VegBank''s plot table.

`CREATE INDEX plot_source_id` runtime: 5 min ("295235 ms") @vegbiendev

';

--

-- Name: COLUMN location.plot_location_id; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN location.plot_location_id IS '

autopopulated

';

--

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

--

CREATE TABLE locationevent (

    locationevent_id integer NOT NULL,

    source_id integer NOT NULL,

    sourceaccessioncode text,

    accesslevel accesslevel,

    place_visit_id integer NOT NULL,

    parent_id integer,

    plot_id integer,

    location_id integer,

    project_id integer,

    stratum_id integer,

    authoreventcode text,

    previous_id integer,

    obsstartdate date,

    obsenddate date,

    dateaccuracy text,

    method_id integer,

    temperature_c double precision,

    precipitation_m double precision,

    autotaxoncover boolean,

    originaldata text,

    effortlevel text,

    floristicquality text,

    bryophytequality text,

    lichenquality text,

    locationeventnarrative text,

    landscapenarrative text,

    homogeneity text,

    phenologicaspect text,

    representativeness text,

    standmaturity text,

    successionalstatus text,

    basalarea double precision,

    hydrologicregime text,

    soilmoistureregime text,

    soildrainage text,

    watersalinity text,

    waterdepth_m double precision,

    shoredistance double precision,

    soildepth double precision,

    organicdepth double precision,

    soiltaxon_id integer,

    soiltaxonsrc text,

    percentbedrock double precision,

    percentrockgravel double precision,

    percentwood double precision,

    percentlitter double precision,

    percentbaresoil double precision,

    percentwater double precision,

    percentother double precision,

    nameother text,

    treeht double precision,

    shrubht double precision,

    fieldht double precision,

    nonvascularht double precision,

    submergedht double precision,

    treecover double precision,

    shrubcover double precision,

    fieldcover double precision,

    nonvascularcover double precision,

    floatingcover double precision,

    submergedcover double precision,

    dominantstratum text,

    growthform1type text,

    growthform2type text,

    growthform3type text,

    growthform1cover double precision,

    growthform2cover double precision,

    growthform3cover double precision,

    totalcover double precision,

    notespublic boolean,

    notesmgt boolean,

    revisions boolean,

    dateentered date DEFAULT now(),

    toptaxon1name text,

    toptaxon2name text,

    toptaxon3name text,

    toptaxon4name text,

    toptaxon5name text,

    numberoftaxa integer,

    CONSTRAINT locationevent_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (location_id IS NOT NULL)))

);

--

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

--

COMMENT ON TABLE locationevent IS '

Equivalent to VegBank''s observation table.

`VACUUM ANALYZE VERBOSE locationevent` runtime: 20 min ("1188590 ms") @vegbiendev

`CREATE INDEX locationevent_place_visit_id` runtime: 3 min ("179139 ms") @vegbiendev

`UPDATE locationevent SET place_visit_id = place_visit_id` runtime: >~1 h @vegbiendev

';

--

-- Name: COLUMN locationevent.place_visit_id; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN locationevent.place_visit_id IS '

autopopulated

';

--

-- Name: COLUMN locationevent.plot_id; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN locationevent.plot_id IS '

autopopulated

';

--

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

--

CREATE TABLE method (

    method_id integer NOT NULL,

    source_id integer NOT NULL,

    name text,

    description text,

    diameterheight_m double precision,

    mindiameter_m double precision,

    maxdiameter_m double precision,

    minheight_m double precision,

    maxheight_m double precision,

    observationtype text,

    observationmeasure text,

    covermethod_id integer,

    samplingfactor double precision DEFAULT 1 NOT NULL,

    coverbasis text,

    stemsamplemethod text,

    shape text,

    length_m double precision,

    width_m double precision,

    radius_m double precision,

    area_m2 double precision,

    samplearea_m2 double precision,

    subplotspacing_m double precision,

    subplotmethod_id integer,

    pointsperline integer,

    CONSTRAINT method_required_key CHECK ((((name IS NOT NULL) OR (description IS NOT NULL)) OR (observationmeasure IS NOT NULL)))

);

--

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

--

COMMENT ON TABLE method IS '

A method for sampling and aggregating plants. Replaces VegBank''s stratummethod and stratumtype tables.

Important: *All* length- or area-related measurements throughout VegBIEN must be converted to SI base units, e.g. cm -> m, ha -> m^2.**

';

--

-- Name: COLUMN method.source_id; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.source_id IS '

Use the source table (e.g. source.url) to store a link to the original plain text description.

';

--

-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.name IS '

A short name for the set of methods used. Although there is no existing standard, many names are widely used, and could be useful for finding plots with similar methodology.

';

--

-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.description IS '

Additional metadata helpful for understanding how the data were collected during the observation event.

';

--

-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.diameterheight_m IS '

The height in m at which the diameter is measured. e.g. 1.37 m for breast height (DBH).

';

--

-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.mindiameter_m IS '

Lower diameter limit in m for inclusion of a tree.

';

--

-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.maxdiameter_m IS '

Upper diameter limit in m for inclusion of a tree.

';

--

-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.minheight_m IS '

Lower height limit in m for inclusion of a tree.

';

--

-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.maxheight_m IS '

Upper height limit in m for inclusion of a tree.

';

--

-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.observationtype IS '

values: aggregate, individual, both

';

--

-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.observationmeasure IS '

e.g. count, cover, presence, points-intercepted, distance-intercepted

';

--

-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.samplingfactor IS '

Here, we could explicitly say that we are sampling a particular area by a different size representative sample area. Simply divide the number of plants connected to this record by this value to get the extrapolated (or interpolated) number of plants in the area in question. This explicitly notes a subsample or supersample.

';

--

-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.coverbasis IS '

Were cover values for the total taxon list collected from one contiguous area or dispersed subplots?

entire: Cover based on observation of an entire plot consisting of a single contiguous area of land. subplot-contiguous: Cover based on observation of a single contiguous area of land of less spatial extent than the entire plot.

subplot-regular: Cover based on observation of multiple subplots arranged in a regular pattern within the overall plot.

subplot-random: Cover based on observation of multiple randomly dispersed subplots within the overall plot.

subplot-haphazard: Cover based on observation of multiple subplots haphazardly arranged within the overall plot.

line-intercept: Cover based on length of line touching each species present.

point-intercept: Cover based on number of points for each species present.

';

--

-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.stemsamplemethod IS '

The method used to obtain basal area or tree stem data (e.g., full census, point quarter, random pairs, Bitterlich, other).

e.g.:

Full census

Point quarter

Random pairs

Bitterlich

Other

Subsample census

';

--

-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.shape IS '

e.g. square, rectangle, circle, line, point, other

';

--

-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.samplearea_m2 IS '

The total surface area used for cover estimates and for which a complete species list is provided. If subplots were used, this would be the total area of the subplots without interstitial space.

';

--

-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.subplotspacing_m IS '

Spacing in m between adjacent subplots, lines (line-intercept data), or points (point-intercept data).

';

--

-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.subplotmethod_id IS '

Method to use for each subplot/line/point, which will specify subplot size, line length, etc.

';

--

-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN method.pointsperline IS '

The number of points sampled on each line subplot for point-intercept data.

';

--

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

--

CREATE TABLE party (

    party_id integer NOT NULL,

    source_id integer NOT NULL,

    sourceaccessioncode text,

    fullname text,

    salutation text,

    givenname text,

    middlename text,

    surname text,

    suffix text,

    department text,

    organizationname text,

    currentname_id integer,

    contactinstructions text,

    email text,

    partytype text,

    partypublic boolean DEFAULT true,

    CONSTRAINT party_required_key CHECK (((organizationname IS NOT NULL) OR ((source_id <> party_id) AND ((fullname IS NOT NULL) OR (surname IS NOT NULL)))))

);

--

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

--

CREATE TABLE plantobservation (

    plantobservation_id integer NOT NULL,

    source_id integer NOT NULL,

    sourceaccessioncode text,

    aggregateoccurrence_id integer,

    overallheight_m double precision,

    overallheightaccuracy_m double precision,

    authorplantcode text,

    stemcount integer,

    reproductivecondition text,

    plant_id integer,

    CONSTRAINT plantobservation_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (aggregateoccurrence_id IS NOT NULL)))

);

--

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

--

COMMENT ON TABLE plantobservation IS '

Equivalent to VegBank''s stemcount table.

';

--

-- Name: COLUMN plantobservation.authorplantcode; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN plantobservation.authorplantcode IS '

The number of the organism within the data collection or event.

';

--

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

--

CREATE TABLE project (

    project_id integer NOT NULL,

    source_id integer NOT NULL,

    sourceaccessioncode text,

    projectname text,

    projectdescription text,

    startdate date,

    stopdate date,

    CONSTRAINT project_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (projectname IS NOT NULL)))

);

--

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

--

CREATE TABLE stratum (

    stratum_id integer NOT NULL,

    source_id integer NOT NULL,

    stratumname text NOT NULL,

    stratumheight double precision,

    stratumbase double precision,

    stratumcover double precision,

    area double precision,

    method_id integer

);

--

-- Name: plot.**; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW "plot.**" AS

 SELECT source.shortname AS datasource,

    COALESCE(geoscrub_output."acceptedCountry", place.country) AS country,

    COALESCE(geoscrub_output."acceptedStateProvince", place.stateprovince) AS state_province,

    COALESCE(geoscrub_output."acceptedCounty", place.county) AS county,

    location.locationnarrative AS locality,

        CASE

            WHEN (coordinates.latitude_deg IS NOT NULL) THEN coordinates.latitude_deg

            ELSE county_centroids."decimalLatitude"

        END AS latitude,

        CASE

            WHEN (coordinates.latitude_deg IS NOT NULL) THEN coordinates.longitude_deg

            ELSE county_centroids."decimalLongitude"

        END AS longitude,

        CASE

            WHEN (coordinates.latitude_deg IS NOT NULL) THEN coordinates.coordsaccuracy_m

            ELSE _km_to_m(county_centroids."*error_km")

        END AS coord_uncertainty_m,

        CASE

            WHEN (coordinates.latitude_deg IS NOT NULL) THEN 'source data'::coordinatesource

            WHEN (county_centroids."*row_num" IS NOT NULL) THEN 'georeferencing'::coordinatesource

            ELSE NULL::coordinatesource

        END AS georef_sources,

        CASE

            WHEN (coordinates.latitude_deg IS NOT NULL) THEN NULL::text

            WHEN (county_centroids."*row_num" IS NOT NULL) THEN 'county centroid'::text

            ELSE NULL::text

        END AS georef_protocol,

    (geoscrub_output.geovalid)::integer AS is_geovalid,

    ("newWorldCountries"."isNewWorld")::integer AS is_new_world,

    COALESCE(project.sourceaccessioncode, project.projectname) AS project_id,

    ARRAY( SELECT project_contributors(project.project_id) AS project_contributors) AS project_contributors,

    COALESCE(location.sourceaccessioncode, NULLIF(concat_ws('; '::text, COALESCE(parent_location.sourceaccessioncode, parent_location.authorlocationcode), location.authorlocationcode), ''::text)) AS location_id,

    COALESCE(parent_location.authorlocationcode, location.authorlocationcode) AS plot_name,

        CASE

            WHEN (parent_location.location_id IS NOT NULL) THEN location.authorlocationcode

            ELSE NULL::text

        END AS subplot,

    location.iscultivated AS is_location_cultivated,

    locationevent.locationevent_id,

    COALESCE(locationevent.obsstartdate, parent_event.obsstartdate) AS event_date,

    COALESCE(location.elevation_m, parent_location.elevation_m) AS elevation_m,

    COALESCE(location.slopeaspect_deg, parent_location.slopeaspect_deg) AS slope_aspect_deg,

    COALESCE(location.slopegradient_fraction, parent_location.slopegradient_fraction) AS slope_gradient_deg,

    _m2_to_ha(COALESCE(location.area_m2, parent_location.area_m2)) AS plot_area_ha,

    method.name AS sampling_protocol,

    COALESCE(locationevent.temperature_c, parent_event.temperature_c) AS temperature_c,

    COALESCE(locationevent.precipitation_m, parent_event.precipitation_m) AS precip_mm,

    stratum.stratumname AS stratum_name,

    COALESCE(locationevent__communities__array(locationevent.locationevent_id), locationevent__communities__array(parent_event.locationevent_id)) AS community_concept_name,

    COALESCE(locationevent__contributors__array(locationevent.locationevent_id), locationevent__contributors__array(parent_event.locationevent_id)) AS observation_contributors

   FROM (((((((((((((source

   JOIN location USING (source_id))

   LEFT JOIN locationevent USING (location_id))

   LEFT JOIN place USING (place_id))

   LEFT JOIN location parent_location ON ((parent_location.location_id = location.parent_id)))

   LEFT JOIN coordinates USING (coordinates_id))

   LEFT JOIN geoscrub.geoscrub_output ON ((((((ARRAY[geoscrub_output."decimalLatitude"] = ARRAY[coordinates.latitude_deg]) AND (ARRAY[geoscrub_output."decimalLongitude"] = ARRAY[coordinates.longitude_deg])) AND (ARRAY[geoscrub_output.country] = ARRAY[place.country])) AND (ARRAY[geoscrub_output."stateProvince"] = ARRAY[place.stateprovince])) AND (ARRAY[geoscrub_output.county] = ARRAY[place.county]))))

   LEFT JOIN "newWorld".iso_code_gadm ON ((iso_code_gadm."*GADM country" = COALESCE(geoscrub_output."acceptedCountry", place.country))))

   LEFT JOIN "newWorld"."newWorldCountries" ON (("newWorldCountries"."*isoCode" = iso_code_gadm."*2-digit iso code")))

   LEFT JOIN geoscrub.county_centroids ON ((((place.country = 'United States'::text) AND (county_centroids."stateProvince" = COALESCE(geoscrub_output."acceptedStateProvince", place.stateprovince))) AND (county_centroids.county = COALESCE(geoscrub_output."acceptedCounty", place.county)))))

   LEFT JOIN locationevent parent_event ON ((parent_event.locationevent_id = locationevent.parent_id)))

   LEFT JOIN project ON ((project.project_id = COALESCE(locationevent.project_id, parent_event.project_id))))

   LEFT JOIN stratum ON ((stratum.stratum_id = COALESCE(locationevent.stratum_id, parent_event.stratum_id))))

   LEFT JOIN method ON ((method.method_id = COALESCE(locationevent.method_id, parent_event.method_id))));

--

-- Name: COLUMN "plot.**".datasource; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".datasource IS '"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';

--

-- Name: COLUMN "plot.**".country; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".country 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 "plot.**".state_province; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".state_province IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"';

--

-- Name: COLUMN "plot.**".county; Type: COMMENT; Schema: public; Owner: -

--

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

--

-- Name: COLUMN "plot.**".locality; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".locality IS '"The specific description of the place"';

--

-- Name: COLUMN "plot.**".latitude; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".latitude IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';

--

-- Name: COLUMN "plot.**".longitude; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".longitude IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';

--

-- Name: COLUMN "plot.**".coord_uncertainty_m; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".coord_uncertainty_m 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 "plot.**".georef_sources; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".georef_sources 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 "plot.**".georef_protocol; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".georef_protocol IS '"A description or reference to the methods used to determine the spatial footprint, coordinates, and uncertainties"';

--

-- Name: COLUMN "plot.**".is_geovalid; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".is_geovalid IS 'whether the coordinates are within the boundary of the asserted named places';

--

-- Name: COLUMN "plot.**".is_new_world; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".is_new_world IS 'whether the country is in the Americas';

--

-- Name: COLUMN "plot.**".project_id; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".project_id IS 'http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;

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

--

-- Name: COLUMN "plot.**".project_contributors; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".project_contributors IS '"intersection entit[ies] used to ''link'' a party with a specific project wherein vegetation plots are described"';

--

-- Name: COLUMN "plot.**".location_id; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".location_id IS '"An identifier for the set of location information (data associated with dcterms:Location)"';

--

-- Name: COLUMN "plot.**".plot_name; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".plot_name IS '"Name or label for a plot"';

--

-- Name: COLUMN "plot.**".subplot; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".subplot IS 'http://location.authorlocationcode__@VegBIEN__.public@vegpath.org;

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

--

-- Name: COLUMN "plot.**".is_location_cultivated; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".is_location_cultivated 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 "plot.**".locationevent_id; Type: COMMENT; Schema: public; Owner: -

--

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

autogenerated ID for locationevent';

--

-- Name: COLUMN "plot.**".event_date; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".event_date 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 "plot.**".elevation_m; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".elevation_m IS 'the "elevation (altitude, usually above sea level), in meters"';

--

-- Name: COLUMN "plot.**".slope_aspect_deg; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".slope_aspect_deg IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';

--

-- Name: COLUMN "plot.**".slope_gradient_deg; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".slope_gradient_deg IS '"Representative inclination of slope in degrees"';

--

-- Name: COLUMN "plot.**".plot_area_ha; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".plot_area_ha IS '"Total area of the plot"';

--

-- Name: COLUMN "plot.**".sampling_protocol; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".sampling_protocol IS '"The name of, reference to, or description of the method or protocol used during an Event"';

--

-- Name: COLUMN "plot.**".temperature_c; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".temperature_c IS '"Temperature during observation [...] [in] Celsius"';

--

-- Name: COLUMN "plot.**".precip_mm; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".precip_mm IS '"Total annual precipitation, in mm"';

--

-- Name: COLUMN "plot.**".stratum_name; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".stratum_name IS '"Name associated with this stratum"';

--

-- Name: COLUMN "plot.**".community_concept_name; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".community_concept_name 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 "plot.**".observation_contributors; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN "plot.**".observation_contributors IS '"intersection[s] that link[] a party with a specific plot observation event"';

--

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

--

CREATE TABLE sourcelist (

    sourcelist_id integer NOT NULL,

    source_id integer NOT NULL,

    name text NOT NULL

);

--

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

--

CREATE TABLE specimenreplicate (

    specimenreplicate_id integer NOT NULL,

    source_id integer NOT NULL,

    sourceaccessioncode text,

    plantobservation_id integer,

    duplicate_institutions_sourcelist_id integer,

    collectioncode_dwc text,

    catalognumber_dwc text,

    collectionnumber text,

    description text,

    specimen_id integer,

    CONSTRAINT specimenreplicate_required_key CHECK ((((plantobservation_id IS NOT NULL) OR (sourceaccessioncode IS NOT NULL)) OR (catalognumber_dwc IS NOT NULL)))

);

--

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

--

COMMENT ON TABLE specimenreplicate IS '

A herbarium''s replicate of a specimen. Contains Darwin Core specimen data.

';

--

-- Name: COLUMN specimenreplicate.duplicate_institutions_sourcelist_id; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN specimenreplicate.duplicate_institutions_sourcelist_id IS '

The institution(s) (such as museums) that the specimenreplicate is from.

';

--

-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN specimenreplicate.collectioncode_dwc IS '

The code for the collection that the specimenreplicate is from.

';

--

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

--

CREATE TABLE taxondetermination (

    taxondetermination_id integer NOT NULL,

    taxonoccurrence_id integer NOT NULL,

    source_id integer NOT NULL,

    taxonverbatim_id integer NOT NULL,

    party_id integer,

    role role DEFAULT 'unknown'::role NOT NULL,

    determinationtype text,

    reference_id integer,

    isoriginal boolean,

    iscurrent__verbatim boolean,

    iscurrent boolean DEFAULT false NOT NULL,

    taxonfit text,

    taxonconfidence text,

    grouptype text,

    notes text,

    revisions boolean,

    determinationdate date

);

--

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

--

COMMENT ON TABLE taxondetermination IS '

Equivalent to VegBank''s taxoninterpretation table.

';

--

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

--

CREATE TABLE taxonoccurrence (

    taxonoccurrence_id integer NOT NULL,

    source_id integer NOT NULL,

    sourceaccessioncode text,

    locationevent_id integer,

    authortaxoncode text,

    collector_id integer,

    growthform growthform,

    iscultivated boolean,

    cultivatedbasis text,

    isnative boolean,

    CONSTRAINT taxonoccurrence_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (locationevent_id IS NOT NULL)))

);

--

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

--

COMMENT ON TABLE taxonoccurrence IS '

Equivalent to VegBank''s taxonobservation table.

';

--

-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonoccurrence.iscultivated IS '

cultivated or wild

';

--

-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonoccurrence.cultivatedbasis IS '

The reason why a taxonoccurrence was marked as cultivated (or not).

';

--

-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonoccurrence.isnative IS '

native or exotic

';

--

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

--

CREATE TABLE taxonverbatim (

    taxonverbatim_id integer NOT NULL,

    source_id integer NOT NULL,

    taxonlabel_id integer,

    verbatimrank text,

    taxonomicname text,

    taxonname text,

    author text,

    family text,

    genus text,

    specific_epithet text,

    subspecies text,

    morphospecies text,

    morphoname text,

    growthform growthform,

    description text,

    CONSTRAINT taxonverbatim_required_key CHECK (((taxonlabel_id IS NOT NULL) OR (morphoname IS NOT NULL)))

);

--

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

--

COMMENT ON TABLE taxonverbatim IS '

Component parts of the taxonlabel. Contains the datasource''s original taxonomic name components, as well as any parsed components produced by name resolution.

';

--

-- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonverbatim.verbatimrank IS '

The taxon''s verbatim level in the taxonomic hierarchy. Does not need to be in the taxonrank closed list.

';

--

-- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonverbatim.taxonomicname IS '

The full taxonomic name which uniquely identifies this taxon, including the author of that name. The family should be omitted if possible.

Equivalent to Darwin Core''s scientificName.

';

--

-- Name: COLUMN taxonverbatim.taxonname; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonverbatim.taxonname IS '

The taxonomic name without the author. The family should be omitted if possible.

';

--

-- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonverbatim.author IS '

The author of the taxonomic name.

Equivalent to Darwin Core''s scientificNameAuthorship.

';

--

-- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonverbatim.family IS '

The family of the taxonomic name. This is a cached field for easy querying; this should also be stored in taxonlabel at the appropriate rank.

';

--

-- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonverbatim.genus IS '

The genus portion of the taxonomic name. This is a cached field for easy querying; this should also be stored in taxonlabel at the appropriate rank.

';

--

-- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonverbatim.specific_epithet IS '

The specific epithet portion of the taxonomic name. This is a cached field for easy querying; this should also be stored in taxonlabel at the appropriate rank.

';

--

-- Name: COLUMN taxonverbatim.morphospecies; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonverbatim.morphospecies IS '

The morphospecies suffix.

';

--

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

--

CREATE VIEW view_full_occurrence_individual_view AS

 SELECT "plot.**".datasource,

    "plot.**".country,

    "plot.**".state_province,

    "plot.**".county,

    "plot.**".locality,

    "plot.**".latitude,

    "plot.**".longitude,

    "plot.**".coord_uncertainty_m,

    "plot.**".georef_sources,

    "plot.**".georef_protocol,

    "plot.**".is_geovalid,

    "plot.**".is_new_world,

    "plot.**".project_id,

    "plot.**".project_contributors,

    "plot.**".location_id,

    "plot.**".plot_name,

    "plot.**".subplot,

    "plot.**".is_location_cultivated,

    "plot.**".locationevent_id,

    "plot.**".event_date,

    "plot.**".elevation_m,

    "plot.**".slope_aspect_deg,

    "plot.**".slope_gradient_deg,

    "plot.**".plot_area_ha,

    "plot.**".sampling_protocol,

    "plot.**".temperature_c,

    "plot.**".precip_mm,

    "plot.**".stratum_name,

    "plot.**".community_concept_name,

    "plot.**".observation_contributors,

    sourcelist.name AS custodial_institution_codes,

    specimenreplicate.collectioncode_dwc AS collection_code,

    specimenreplicate.catalognumber_dwc AS catalog_number,

    specimenreplicate.sourceaccessioncode AS occurrence_id,

    collector.fullname AS recorded_by,

    plantobservation.authorplantcode AS record_number,

    COALESCE(aggregateoccurrence.collectiondate, "plot.**".event_date) AS date_collected,

    taxonverbatim.family AS verbatim_family,

    COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS verbatim_scientific_name,

    identifiedby.fullname AS identified_by,

    taxondetermination.determinationdate AS date_identified,

    taxondetermination.notes AS identification_remarks,

    taxon_scrub."*Name_matched_accepted_family" AS family_matched,

    taxon_scrub."*Name_matched" AS name_matched,

    taxon_scrub."*Name_matched_author" AS name_matched_author,

    family_higher_plant_group.higher_plant_group,

    taxon_scrub."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" AS taxonomic_status,

    taxon_scrub."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" AS scrubbed_family,

    taxon_scrub."[scrubbed_]genus__@DwC__@vegpath.org" AS scrubbed_genus,

    taxon_scrub."[scrubbed_]specificEpithet__@DwC__@vegpath.org" AS scrubbed_specific_epithet,

    ((taxon_scrub."[scrubbed_]genus__@DwC__@vegpath.org" || ' '::text) || taxon_scrub."[scrubbed_]specificEpithet__@DwC__@vegpath.org") AS scrubbed_species_binomial,

    taxon_scrub."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" AS scrubbed_taxon_name_no_author,

    taxon_scrub."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" AS scrubbed_author,

    taxon_scrub."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" AS scrubbed_taxon_name_with_author,

    taxon_scrub."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" AS scrubbed_species_binomial_with_morphospecies,

    taxonoccurrence.growthform AS growth_form,

    plantobservation.reproductivecondition AS reproductive_condition,

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

        CASE

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

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

            ELSE NULL::text

        END AS is_cultivated_basis,

    aggregateoccurrence.notes AS occurrence_remarks,

    _fraction_to_percent(aggregateoccurrence.cover_fraction) AS cover_percent,

    taxonoccurrence.sourceaccessioncode AS taxon_observation_id,

    taxonoccurrence.authortaxoncode AS taxon_name_usage_concept_author_code,

    aggregateoccurrence.sourceaccessioncode AS aggregate_organism_observation_id,

    plantobservation.sourceaccessioncode AS individual_organism_observation_id,

    plantobservation.authorplantcode AS individual_id,

    aggregateoccurrence.count AS individual_count,

    plantobservation.plantobservation_id

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

   LEFT JOIN taxonoccurrence ON ((taxonoccurrence.locationevent_id = "plot.**".locationevent_id)))

   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~(-Accepted_-)__@TNRS__@vegpath.org")))

   LEFT JOIN cultivated_family_locations ON (((cultivated_family_locations.family = taxon_scrub."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org") AND (cultivated_family_locations.country = "plot.**".country))));

--

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

--

COMMENT ON VIEW view_full_occurrence_individual_view IS '

after updating this:

SELECT view_full_occurrence_individual_view_modify()

add applicable columns to analytical_specimen, analytical_plot

materialize time: 22 h ("79217026.810 ms") @r14089 @vegbiendev

CREATE INDEX runtime:

1-column: 10 min - 1.5 h depending on the datatype and % populated

	(plot_area_ha: "10:45.92"; taxonomic_status: "1:28:16") @r14089 @vegbiendev

2-column: ~2 h ((datasource, scrubbed_species_binomial_with_morphospecies):

	"2:11:31") @r14089 @vegbiendev

';

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.datasource IS '"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.locality IS '"The specific description of the place"';

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.project_id IS 'http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;

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

--

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

--

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

--

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

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.plot_name IS '"Name or label for a plot"';

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.subplot IS 'http://location.authorlocationcode__@VegBIEN__.public@vegpath.org;

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

--

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

--

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

--

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

autogenerated ID for locationevent';

--

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

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.elevation_m IS 'the "elevation (altitude, usually above sea level), in meters"';

--

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

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.slope_gradient_deg IS '"Representative inclination of slope in degrees"';

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.plot_area_ha IS '"Total area of the plot"';

--

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

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.temperature_c IS '"Temperature during observation [...] [in] Celsius"';

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.precip_mm IS '"Total annual precipitation, in mm"';

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.stratum_name IS '"Name associated with this stratum"';

--

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

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.observation_contributors IS '"intersection[s] that link[] a party with a specific plot observation event"';

--

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

--

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

--

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

--

COMMENT ON COLUMN view_full_occurrence_individual_view.catalog_number IS '"An identifier (preferably unique) for the record within the data set or collection"';

--

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

--

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

--

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

--

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

--

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