/trunk/schemas/public_.sql - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 13728

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: analytical_stem_view: applied data dictionary renamings, using the steps at wiki.vegpath.org/VegBIEN_schema_refactoring#apply-data-dictionary-renamings-to-database

         "plot.**"."decimalLatitude" AS "decimalLatitude__@DwC__@vegpath.org",
         "plot.**"."decimalLongitude" AS "decimalLongitude__@DwC__@vegpath.org",
         "plot.**"."coordinateUncertaintyInMeters" AS "coordinateUncertaintyInMeters__@DwC__@vegpath.org",
         "plot.**"."coordinateSource_bien",
         "plot.**"."georeferenceProtocol_bien",
         "plot.**"."coordinateSource_bien" AS "georeferenceSources__@DwC__@vegpath.org",
         "plot.**"."georeferenceProtocol_bien" AS "georeferenceProtocol__@DwC__@vegpath.org",
         "plot.**".geovalid_bien,
         "plot.**"."isNewWorld_bien",
         "plot.**"."projectID" AS "projectID__@VegX__.plotObservation@vegpath.org",
         "plot.**".project_contributors,
         "plot.**".project_contributors AS "projectContributor[s]__@VegBank__@vegpath.org",
         "plot.**"."locationID" AS "locationID__@DwC__@vegpath.org",
         "plot.**"."locationName" AS "plotName__@VegX__.plot@vegpath.org",
         "plot.**".subplot AS "subplot__@SALVIAS__@vegpath.org",
         "plot.**".subplot AS "subplot__@SALVIAS__.Plot_data@vegpath.org",
         "plot.**".location__cultivated__bien,
         "plot.**".locationevent__pkey AS "locationevent.locationevent_id__@VegBIEN__.public@vegpath.org",
         "plot.**"."eventDate" AS "eventDate__@DwC__@vegpath.org",
         "plot.**"."elevationInMeters",
         "plot.**"."slopeAspect" AS "slopeAspect__@VegX__.plot@vegpath.org",
         "plot.**"."slopeGradient" AS "slopeGradient__@VegX__.plot@vegpath.org",
         "plot.**"."plotArea_ha",
         "plot.**"."elevationInMeters" AS "(-minimum-)ElevationInMeters__@DwC__@vegpath.org",
         "plot.**"."slopeAspect" AS "slopeAspect[_deg]__@VegX__.plot@vegpath.org",
         "plot.**"."slopeGradient" AS "slopeGradient[_deg]__@VegX__.plot@vegpath.org",
         "plot.**"."plotArea_ha" AS "area[_ha]__@VegX__.plot@vegpath.org",
         "plot.**"."samplingProtocol" AS "samplingProtocol__@DwC__@vegpath.org",
         "plot.**"."temperature_C",
         "plot.**".precipitation_m,
         "plot.**".stratum__name,
         "plot.**".communities,
         "plot.**".plot__collectors,
         sourcelist.name AS "specimenHolderInstitutions",
         specimenreplicate.collectioncode_dwc AS collection,
         specimenreplicate.catalognumber_dwc AS "accessionNumber",
         "plot.**"."temperature_C" AS "temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",
         "plot.**".precipitation_m AS "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",
         "plot.**".stratum__name AS "stratumName__@VegX__.stratum@vegpath.org",
         "plot.**".communities AS "communityConcept.name__@VegX__.communityDet@vegpath.org",
         "plot.**".plot__collectors AS "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") AS "dateCollected",
         taxonverbatim.family AS family_verbatim,
         COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS "scientificName_verbatim",
         COALESCE(aggregateoccurrence.collectiondate, "plot.**"."eventDate") 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."matchedFamily" AS "Family_matched__@TNRS__@vegpath.org",
         taxon_scrub."matchedTaxonName" AS "taxonName_matched",
         taxon_scrub."matchedScientificNameAuthorship" AS "scientificNameAuthorship_matched",
         family_higher_plant_group.higher_plant_group AS "higherPlantGroup_bien",
         taxon_scrub."taxonomicStatus" AS taxonomic_status,
         taxon_scrub."matchedTaxonName" AS "Name_matched__@TNRS__@vegpath.org",
         taxon_scrub."matchedScientificNameAuthorship" 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_author,
         taxon_scrub.scrubbed_taxon_name_with_author,
         taxon_scrub.scrubbed_morphospecies_binomial AS "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org",
         taxonoccurrence.growthform AS "growthForm",
         taxonoccurrence.growthform AS "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",
         plantobservation.reproductivecondition AS "reproductiveCondition__@DwC__@vegpath.org",
         ((threatened_taxonlabel.taxonlabel_id IS NOT NULL))::integer AS threatened_bien,
         (((cultivated_family_locations.country IS NOT NULL) OR _or(taxonoccurrence.iscultivated, "plot.**".location__cultivated__bien)))::integer AS cultivated_bien,
-...
             END AS "cultivatedBasis_bien",
         aggregateoccurrence.notes AS "occurrenceRemarks__@DwC__@vegpath.org",
         _fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent__@VegX__.attribute.ordinal@vegpath.org",
         _m_to_cm(stemobservation.diameterbreastheight_m) AS "diameterBreastHeight_cm",
         stemobservation.height_m,
         stemobservation.tag,
         stemobservation.xposition_m AS "organismX_m",
         stemobservation.yposition_m AS "organismY_m",
         taxonoccurrence.sourceaccessioncode AS "taxonOccurrenceID",
         _m_to_cm(stemobservation.diameterbreastheight_m) AS "stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org",
         stemobservation.height_m AS "stemHeight[_m]__@VegBank__.stemCount@vegpath.org",
         stemobservation.tag AS "[tag=]identificationLabel__@VegX__.individual@vegpath.org",
         stemobservation.xposition_m AS "relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org",
         stemobservation.yposition_m AS "relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org",
         taxonoccurrence.sourceaccessioncode AS "taxonObservation[.id]__@VegBank__@vegpath.org",
         taxonoccurrence.authortaxoncode AS "authorTaxonCode",
         aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservationID",
         plantobservation.sourceaccessioncode AS "individualObservationID",
         plantobservation.authorplantcode AS "individualCode",
         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",
         stemobservation.authorstemcode AS "stemCode__@VegBank__.stemlocation@vegpath.org"
         stemobservation.authorstemcode AS "stemCode__@VegBank__.stemLocation@vegpath.org"
        FROM ((((((((((((((("plot.**"
        LEFT JOIN taxonoccurrence ON ((taxonoccurrence.locationevent_id = "plot.**".locationevent__pkey)))
        LEFT JOIN party collector ON ((collector.party_id = taxonoccurrence.collector_id)))
-...
     --
     -- Name: COLUMN analytical_stem_view."coordinateSource_bien"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."coordinateSource_bien" IS 'derived column';
     COMMENT ON COLUMN analytical_stem_view."georeferenceSources__@DwC__@vegpath.org" IS 'derived column';
     --
     -- Name: COLUMN analytical_stem_view."georeferenceProtocol_bien"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."georeferenceProtocol_bien" IS 'derived column';
     COMMENT ON COLUMN analytical_stem_view."georeferenceProtocol__@DwC__@vegpath.org" IS 'derived column';
     --
-...
     --
     -- Name: COLUMN analytical_stem_view.project_contributors; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view.project_contributors IS 'variant of VegBank term';
     COMMENT ON COLUMN analytical_stem_view."projectContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term';
     --
-...
     --
     -- Name: COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org;
     COMMENT ON COLUMN analytical_stem_view."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org;
     "Code for subplot, line, or any other subsample or subdivision of plot"';
-...
     --
     -- Name: COLUMN analytical_stem_view."elevationInMeters"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."elevationInMeters" IS 'variant of DwC term';
     COMMENT ON COLUMN analytical_stem_view."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'variant of DwC term';
     --
     -- Name: COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';
     COMMENT ON COLUMN analytical_stem_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 analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
     COMMENT ON COLUMN analytical_stem_view."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
     --
     -- Name: COLUMN analytical_stem_view."plotArea_ha"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."area[_ha]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."plotArea_ha" IS 'variant of VegX term';
     COMMENT ON COLUMN analytical_stem_view."area[_ha]__@VegX__.plot@vegpath.org" IS 'variant of VegX term';
     --
-...
     --
     -- Name: COLUMN analytical_stem_view."temperature_C"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."temperature_C" IS 'variant of VegX term';
     COMMENT ON COLUMN analytical_stem_view."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS 'variant of VegX term';
     --
     -- Name: COLUMN analytical_stem_view.precipitation_m; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view.precipitation_m IS 'variant of VegX term';
     COMMENT ON COLUMN analytical_stem_view."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS 'variant of VegX term';
     --
     -- Name: COLUMN analytical_stem_view.stratum__name; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view.stratum__name IS 'from VegX, renamed';
     COMMENT ON COLUMN analytical_stem_view."stratumName__@VegX__.stratum@vegpath.org" IS 'from VegX, renamed';
     --
     -- Name: COLUMN analytical_stem_view.communities; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view.communities IS 'variant of VegX term';
     COMMENT ON COLUMN analytical_stem_view."communityConcept.name__@VegX__.communityDet@vegpath.org" IS 'variant of VegX term';
     --
     -- Name: COLUMN analytical_stem_view.plot__collectors; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view.plot__collectors IS 'variant of VegBank term';
     COMMENT ON COLUMN analytical_stem_view."observationContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term';
     --
     -- Name: COLUMN analytical_stem_view."specimenHolderInstitutions"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."specimenHolderInstitutions" IS 'from DwC, renamed';
     COMMENT ON COLUMN analytical_stem_view."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS 'from DwC, renamed';
     --
     -- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view.collection IS 'from DwC, renamed';
     COMMENT ON COLUMN analytical_stem_view."collectionCode__@DwC__@vegpath.org" IS 'from DwC, renamed';
     --
     -- Name: COLUMN analytical_stem_view."accessionNumber"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."accessionNumber" IS 'variant of DwC term';
     COMMENT ON COLUMN analytical_stem_view."catalogNumber__@DwC__@vegpath.org" IS 'variant of DwC term';
     --
-...
     --
     -- Name: COLUMN analytical_stem_view."dateCollected"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."dateCollected" IS 'variant of DwC term';
     COMMENT ON COLUMN analytical_stem_view."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'variant of DwC term';
     --
     -- Name: COLUMN analytical_stem_view.family_verbatim; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view.family_verbatim IS 'variant of DwC term';
     COMMENT ON COLUMN analytical_stem_view."[verbatim_]family__@DwC__@vegpath.org" IS 'variant of DwC term';
     --
     -- Name: COLUMN analytical_stem_view."scientificName_verbatim"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."scientificName_verbatim" IS 'variant of DwC term';
     COMMENT ON COLUMN analytical_stem_view."[verbatim_]scientificName__@DwC__@vegpath.org" IS 'variant of DwC term';
     --
-...
     --
     -- Name: COLUMN analytical_stem_view."taxonName_matched"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."taxonName_matched" IS 'from TNRS, renamed';
     COMMENT ON COLUMN analytical_stem_view."Name_matched__@TNRS__@vegpath.org" IS 'from TNRS, renamed';
     --
     -- Name: COLUMN analytical_stem_view."scientificNameAuthorship_matched"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."scientificNameAuthorship_matched" IS 'from TNRS, renamed';
     COMMENT ON COLUMN analytical_stem_view."Name_matched_author__@TNRS__@vegpath.org" IS 'from TNRS, renamed';
     --
     -- Name: COLUMN analytical_stem_view."higherPlantGroup_bien"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."higherPlantGroup_bien" IS 'derived column';
     COMMENT ON COLUMN analytical_stem_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'derived column';
     --
     -- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view.taxonomic_status IS 'from DwC, renamed';
     COMMENT ON COLUMN analytical_stem_view."taxonomicStatus__@DwC__@vegpath.org" IS 'from DwC, renamed';
     --
-...
     --
     -- Name: COLUMN analytical_stem_view."growthForm"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."growthForm" IS 'from SALVIAS, renamed';
     COMMENT ON COLUMN analytical_stem_view."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS 'from SALVIAS, renamed';
     --
-...
     --
     -- Name: COLUMN analytical_stem_view."diameterBreastHeight_cm"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."diameterBreastHeight_cm" IS 'from SALVIAS, renamed';
     COMMENT ON COLUMN analytical_stem_view."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS 'from SALVIAS, renamed';
     --
     -- Name: COLUMN analytical_stem_view.height_m; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view.height_m IS 'variant of VegX term';
     COMMENT ON COLUMN analytical_stem_view."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS 'variant of VegX term';
     --
     -- Name: COLUMN analytical_stem_view.tag; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view.tag IS 'from VegX, renamed';
     COMMENT ON COLUMN analytical_stem_view."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS 'from VegX, renamed';
     --
     -- Name: COLUMN analytical_stem_view."organismX_m"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."organismX_m" IS 'variant of VegX term';
     COMMENT ON COLUMN analytical_stem_view."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS 'variant of VegX term';
     --
     -- Name: COLUMN analytical_stem_view."organismY_m"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."organismY_m" IS 'variant of VegX term';
     COMMENT ON COLUMN analytical_stem_view."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS 'variant of VegX term';
     --
     -- Name: COLUMN analytical_stem_view."taxonOccurrenceID"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."taxonOccurrenceID" IS 'from VegX, renamed';
     COMMENT ON COLUMN analytical_stem_view."taxonObservation[.id]__@VegBank__@vegpath.org" IS 'from VegX, renamed';
     --
-...
     --
     -- Name: COLUMN analytical_stem_view."aggregateOrganismObservationID"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."aggregateOrganismObservationID" IS 'from VegX, renamed';
     COMMENT ON COLUMN analytical_stem_view."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'from VegX, renamed';
     --
     -- Name: COLUMN analytical_stem_view."individualObservationID"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."individualObservationID" IS 'from VegX, renamed';
     COMMENT ON COLUMN analytical_stem_view."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'from VegX, renamed';
     --
     -- Name: COLUMN analytical_stem_view."individualCode"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."individualCode" IS 'from SALVIAS, renamed';
     COMMENT ON COLUMN analytical_stem_view."individualID__@DwC__@vegpath.org" IS 'from SALVIAS, renamed';
     --
-...
     --
     -- Name: COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     -- Name: COLUMN analytical_stem_view."stemCode__@VegBank__.stemLocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
     COMMENT ON COLUMN analytical_stem_view."stemCode__@VegBank__.stemLocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
     "Name or code applied to a specific stem in the plot. This is generally a numeric label to associate a field data entry with a stem in the database."';

Also available in: Unified diff

Project

General

Profile

Revision 13728

Added by Aaron Marcuse-Kubitza over 10 years ago