Revision 13728
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 6742 | 6742 |
"plot.**"."decimalLatitude" AS "decimalLatitude__@DwC__@vegpath.org", |
| 6743 | 6743 |
"plot.**"."decimalLongitude" AS "decimalLongitude__@DwC__@vegpath.org", |
| 6744 | 6744 |
"plot.**"."coordinateUncertaintyInMeters" AS "coordinateUncertaintyInMeters__@DwC__@vegpath.org", |
| 6745 |
"plot.**"."coordinateSource_bien", |
|
| 6746 |
"plot.**"."georeferenceProtocol_bien", |
|
| 6745 |
"plot.**"."coordinateSource_bien" AS "georeferenceSources__@DwC__@vegpath.org",
|
|
| 6746 |
"plot.**"."georeferenceProtocol_bien" AS "georeferenceProtocol__@DwC__@vegpath.org",
|
|
| 6747 | 6747 |
"plot.**".geovalid_bien, |
| 6748 | 6748 |
"plot.**"."isNewWorld_bien", |
| 6749 | 6749 |
"plot.**"."projectID" AS "projectID__@VegX__.plotObservation@vegpath.org", |
| 6750 |
"plot.**".project_contributors, |
|
| 6750 |
"plot.**".project_contributors AS "projectContributor[s]__@VegBank__@vegpath.org",
|
|
| 6751 | 6751 |
"plot.**"."locationID" AS "locationID__@DwC__@vegpath.org", |
| 6752 | 6752 |
"plot.**"."locationName" AS "plotName__@VegX__.plot@vegpath.org", |
| 6753 |
"plot.**".subplot AS "subplot__@SALVIAS__@vegpath.org", |
|
| 6753 |
"plot.**".subplot AS "subplot__@SALVIAS__.Plot_data@vegpath.org",
|
|
| 6754 | 6754 |
"plot.**".location__cultivated__bien, |
| 6755 | 6755 |
"plot.**".locationevent__pkey AS "locationevent.locationevent_id__@VegBIEN__.public@vegpath.org", |
| 6756 | 6756 |
"plot.**"."eventDate" AS "eventDate__@DwC__@vegpath.org", |
| 6757 |
"plot.**"."elevationInMeters", |
|
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect__@VegX__.plot@vegpath.org", |
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient__@VegX__.plot@vegpath.org", |
|
| 6760 |
"plot.**"."plotArea_ha", |
|
| 6757 |
"plot.**"."elevationInMeters" AS "(-minimum-)ElevationInMeters__@DwC__@vegpath.org",
|
|
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect[_deg]__@VegX__.plot@vegpath.org",
|
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient[_deg]__@VegX__.plot@vegpath.org",
|
|
| 6760 |
"plot.**"."plotArea_ha" AS "area[_ha]__@VegX__.plot@vegpath.org",
|
|
| 6761 | 6761 |
"plot.**"."samplingProtocol" AS "samplingProtocol__@DwC__@vegpath.org", |
| 6762 |
"plot.**"."temperature_C", |
|
| 6763 |
"plot.**".precipitation_m, |
|
| 6764 |
"plot.**".stratum__name, |
|
| 6765 |
"plot.**".communities, |
|
| 6766 |
"plot.**".plot__collectors, |
|
| 6767 |
sourcelist.name AS "specimenHolderInstitutions",
|
|
| 6768 |
specimenreplicate.collectioncode_dwc AS collection,
|
|
| 6769 |
specimenreplicate.catalognumber_dwc AS "accessionNumber",
|
|
| 6762 |
"plot.**"."temperature_C" AS "temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",
|
|
| 6763 |
"plot.**".precipitation_m AS "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",
|
|
| 6764 |
"plot.**".stratum__name AS "stratumName__@VegX__.stratum@vegpath.org",
|
|
| 6765 |
"plot.**".communities AS "communityConcept.name__@VegX__.communityDet@vegpath.org",
|
|
| 6766 |
"plot.**".plot__collectors AS "observationContributor[s]__@VegBank__@vegpath.org",
|
|
| 6767 |
sourcelist.name AS "[custodial_]institutionCode[s]__@DwC__@vegpath.org",
|
|
| 6768 |
specimenreplicate.collectioncode_dwc AS "collectionCode__@DwC__@vegpath.org",
|
|
| 6769 |
specimenreplicate.catalognumber_dwc AS "catalogNumber__@DwC__@vegpath.org",
|
|
| 6770 | 6770 |
specimenreplicate.sourceaccessioncode AS "occurrenceID__@DwC__@vegpath.org", |
| 6771 | 6771 |
collector.fullname AS "recordedBy__@DwC__@vegpath.org", |
| 6772 | 6772 |
plantobservation.authorplantcode AS "recordNumber__@DwC__@vegpath.org", |
| 6773 |
COALESCE(aggregateoccurrence.collectiondate, "plot.**"."eventDate") AS "dateCollected",
|
|
| 6774 |
taxonverbatim.family AS family_verbatim,
|
|
| 6775 |
COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS "scientificName_verbatim",
|
|
| 6773 |
COALESCE(aggregateoccurrence.collectiondate, "plot.**"."eventDate") AS "(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",
|
|
| 6774 |
taxonverbatim.family AS "[verbatim_]family__@DwC__@vegpath.org",
|
|
| 6775 |
COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS "[verbatim_]scientificName__@DwC__@vegpath.org",
|
|
| 6776 | 6776 |
identifiedby.fullname AS "identifiedBy__@DwC__@vegpath.org", |
| 6777 | 6777 |
taxondetermination.determinationdate AS "dateIdentified__@DwC__@vegpath.org", |
| 6778 | 6778 |
taxondetermination.notes AS "identificationRemarks__@DwC__@vegpath.org", |
| 6779 | 6779 |
taxon_scrub."matchedFamily" AS "Family_matched__@TNRS__@vegpath.org", |
| 6780 |
taxon_scrub."matchedTaxonName" AS "taxonName_matched",
|
|
| 6781 |
taxon_scrub."matchedScientificNameAuthorship" AS "scientificNameAuthorship_matched",
|
|
| 6782 |
family_higher_plant_group.higher_plant_group AS "higherPlantGroup_bien",
|
|
| 6783 |
taxon_scrub."taxonomicStatus" AS taxonomic_status,
|
|
| 6780 |
taxon_scrub."matchedTaxonName" AS "Name_matched__@TNRS__@vegpath.org",
|
|
| 6781 |
taxon_scrub."matchedScientificNameAuthorship" AS "Name_matched_author__@TNRS__@vegpath.org",
|
|
| 6782 |
family_higher_plant_group.higher_plant_group AS "[higher_plant_group~]higherClassification__@DwC__@vegpath.org",
|
|
| 6783 |
taxon_scrub."taxonomicStatus" AS "taxonomicStatus__@DwC__@vegpath.org",
|
|
| 6784 | 6784 |
taxon_scrub.scrubbed_family, |
| 6785 | 6785 |
taxon_scrub.scrubbed_genus, |
| 6786 | 6786 |
taxon_scrub.scrubbed_specific_epithet, |
| ... | ... | |
| 6789 | 6789 |
taxon_scrub.scrubbed_author, |
| 6790 | 6790 |
taxon_scrub.scrubbed_taxon_name_with_author, |
| 6791 | 6791 |
taxon_scrub.scrubbed_morphospecies_binomial AS "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org", |
| 6792 |
taxonoccurrence.growthform AS "growthForm",
|
|
| 6792 |
taxonoccurrence.growthform AS "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",
|
|
| 6793 | 6793 |
plantobservation.reproductivecondition AS "reproductiveCondition__@DwC__@vegpath.org", |
| 6794 | 6794 |
((threatened_taxonlabel.taxonlabel_id IS NOT NULL))::integer AS threatened_bien, |
| 6795 | 6795 |
(((cultivated_family_locations.country IS NOT NULL) OR _or(taxonoccurrence.iscultivated, "plot.**".location__cultivated__bien)))::integer AS cultivated_bien, |
| ... | ... | |
| 6800 | 6800 |
END AS "cultivatedBasis_bien", |
| 6801 | 6801 |
aggregateoccurrence.notes AS "occurrenceRemarks__@DwC__@vegpath.org", |
| 6802 | 6802 |
_fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent__@VegX__.attribute.ordinal@vegpath.org", |
| 6803 |
_m_to_cm(stemobservation.diameterbreastheight_m) AS "diameterBreastHeight_cm",
|
|
| 6804 |
stemobservation.height_m, |
|
| 6805 |
stemobservation.tag, |
|
| 6806 |
stemobservation.xposition_m AS "organismX_m",
|
|
| 6807 |
stemobservation.yposition_m AS "organismY_m",
|
|
| 6808 |
taxonoccurrence.sourceaccessioncode AS "taxonOccurrenceID",
|
|
| 6803 |
_m_to_cm(stemobservation.diameterbreastheight_m) AS "stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org",
|
|
| 6804 |
stemobservation.height_m AS "stemHeight[_m]__@VegBank__.stemCount@vegpath.org",
|
|
| 6805 |
stemobservation.tag AS "[tag=]identificationLabel__@VegX__.individual@vegpath.org",
|
|
| 6806 |
stemobservation.xposition_m AS "relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org",
|
|
| 6807 |
stemobservation.yposition_m AS "relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org",
|
|
| 6808 |
taxonoccurrence.sourceaccessioncode AS "taxonObservation[.id]__@VegBank__@vegpath.org",
|
|
| 6809 | 6809 |
taxonoccurrence.authortaxoncode AS "authorTaxonCode", |
| 6810 |
aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservationID",
|
|
| 6811 |
plantobservation.sourceaccessioncode AS "individualObservationID",
|
|
| 6812 |
plantobservation.authorplantcode AS "individualCode",
|
|
| 6810 |
aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservation.id__@VegX__@vegpath.org",
|
|
| 6811 |
plantobservation.sourceaccessioncode AS "individualOrganismObservation.id__@VegX__@vegpath.org",
|
|
| 6812 |
plantobservation.authorplantcode AS "individualID__@DwC__@vegpath.org",
|
|
| 6813 | 6813 |
aggregateoccurrence.count AS "individualCount__@DwC__@vegpath.org", |
| 6814 |
stemobservation.authorstemcode AS "stemCode__@VegBank__.stemlocation@vegpath.org"
|
|
| 6814 |
stemobservation.authorstemcode AS "stemCode__@VegBank__.stemLocation@vegpath.org"
|
|
| 6815 | 6815 |
FROM ((((((((((((((("plot.**"
|
| 6816 | 6816 |
LEFT JOIN taxonoccurrence ON ((taxonoccurrence.locationevent_id = "plot.**".locationevent__pkey))) |
| 6817 | 6817 |
LEFT JOIN party collector ON ((collector.party_id = taxonoccurrence.collector_id))) |
| ... | ... | |
| 6899 | 6899 |
|
| 6900 | 6900 |
|
| 6901 | 6901 |
-- |
| 6902 |
-- Name: COLUMN analytical_stem_view."coordinateSource_bien"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6902 |
-- Name: COLUMN analytical_stem_view."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6903 | 6903 |
-- |
| 6904 | 6904 |
|
| 6905 |
COMMENT ON COLUMN analytical_stem_view."coordinateSource_bien" IS 'derived column';
|
|
| 6905 |
COMMENT ON COLUMN analytical_stem_view."georeferenceSources__@DwC__@vegpath.org" IS 'derived column';
|
|
| 6906 | 6906 |
|
| 6907 | 6907 |
|
| 6908 | 6908 |
-- |
| 6909 |
-- Name: COLUMN analytical_stem_view."georeferenceProtocol_bien"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6909 |
-- Name: COLUMN analytical_stem_view."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6910 | 6910 |
-- |
| 6911 | 6911 |
|
| 6912 |
COMMENT ON COLUMN analytical_stem_view."georeferenceProtocol_bien" IS 'derived column';
|
|
| 6912 |
COMMENT ON COLUMN analytical_stem_view."georeferenceProtocol__@DwC__@vegpath.org" IS 'derived column';
|
|
| 6913 | 6913 |
|
| 6914 | 6914 |
|
| 6915 | 6915 |
-- |
| ... | ... | |
| 6935 | 6935 |
|
| 6936 | 6936 |
|
| 6937 | 6937 |
-- |
| 6938 |
-- Name: COLUMN analytical_stem_view.project_contributors; Type: COMMENT; Schema: public; Owner: -
|
|
| 6938 |
-- Name: COLUMN analytical_stem_view."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6939 | 6939 |
-- |
| 6940 | 6940 |
|
| 6941 |
COMMENT ON COLUMN analytical_stem_view.project_contributors IS 'variant of VegBank term';
|
|
| 6941 |
COMMENT ON COLUMN analytical_stem_view."projectContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term';
|
|
| 6942 | 6942 |
|
| 6943 | 6943 |
|
| 6944 | 6944 |
-- |
| ... | ... | |
| 6956 | 6956 |
|
| 6957 | 6957 |
|
| 6958 | 6958 |
-- |
| 6959 |
-- Name: COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 6959 |
-- Name: COLUMN analytical_stem_view."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6960 | 6960 |
-- |
| 6961 | 6961 |
|
| 6962 |
COMMENT ON COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org; |
|
| 6962 |
COMMENT ON COLUMN analytical_stem_view."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org;
|
|
| 6963 | 6963 |
"Code for subplot, line, or any other subsample or subdivision of plot"'; |
| 6964 | 6964 |
|
| 6965 | 6965 |
|
| ... | ... | |
| 6986 | 6986 |
|
| 6987 | 6987 |
|
| 6988 | 6988 |
-- |
| 6989 |
-- Name: COLUMN analytical_stem_view."elevationInMeters"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6989 |
-- Name: COLUMN analytical_stem_view."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6990 | 6990 |
-- |
| 6991 | 6991 |
|
| 6992 |
COMMENT ON COLUMN analytical_stem_view."elevationInMeters" IS 'variant of DwC term';
|
|
| 6992 |
COMMENT ON COLUMN analytical_stem_view."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 6993 | 6993 |
|
| 6994 | 6994 |
|
| 6995 | 6995 |
-- |
| 6996 |
-- Name: COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 6996 |
-- Name: COLUMN analytical_stem_view."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6997 | 6997 |
-- |
| 6998 | 6998 |
|
| 6999 |
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)"'; |
|
| 6999 |
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)"';
|
|
| 7000 | 7000 |
|
| 7001 | 7001 |
|
| 7002 | 7002 |
-- |
| 7003 |
-- Name: COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 7003 |
-- Name: COLUMN analytical_stem_view."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7004 | 7004 |
-- |
| 7005 | 7005 |
|
| 7006 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"'; |
|
| 7006 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
|
|
| 7007 | 7007 |
|
| 7008 | 7008 |
|
| 7009 | 7009 |
-- |
| 7010 |
-- Name: COLUMN analytical_stem_view."plotArea_ha"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7010 |
-- Name: COLUMN analytical_stem_view."area[_ha]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7011 | 7011 |
-- |
| 7012 | 7012 |
|
| 7013 |
COMMENT ON COLUMN analytical_stem_view."plotArea_ha" IS 'variant of VegX term';
|
|
| 7013 |
COMMENT ON COLUMN analytical_stem_view."area[_ha]__@VegX__.plot@vegpath.org" IS 'variant of VegX term';
|
|
| 7014 | 7014 |
|
| 7015 | 7015 |
|
| 7016 | 7016 |
-- |
| ... | ... | |
| 7021 | 7021 |
|
| 7022 | 7022 |
|
| 7023 | 7023 |
-- |
| 7024 |
-- Name: COLUMN analytical_stem_view."temperature_C"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7024 |
-- Name: COLUMN analytical_stem_view."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7025 | 7025 |
-- |
| 7026 | 7026 |
|
| 7027 |
COMMENT ON COLUMN analytical_stem_view."temperature_C" IS 'variant of VegX term';
|
|
| 7027 |
COMMENT ON COLUMN analytical_stem_view."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS 'variant of VegX term';
|
|
| 7028 | 7028 |
|
| 7029 | 7029 |
|
| 7030 | 7030 |
-- |
| 7031 |
-- Name: COLUMN analytical_stem_view.precipitation_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 7031 |
-- Name: COLUMN analytical_stem_view."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7032 | 7032 |
-- |
| 7033 | 7033 |
|
| 7034 |
COMMENT ON COLUMN analytical_stem_view.precipitation_m IS 'variant of VegX term';
|
|
| 7034 |
COMMENT ON COLUMN analytical_stem_view."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS 'variant of VegX term';
|
|
| 7035 | 7035 |
|
| 7036 | 7036 |
|
| 7037 | 7037 |
-- |
| 7038 |
-- Name: COLUMN analytical_stem_view.stratum__name; Type: COMMENT; Schema: public; Owner: -
|
|
| 7038 |
-- Name: COLUMN analytical_stem_view."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7039 | 7039 |
-- |
| 7040 | 7040 |
|
| 7041 |
COMMENT ON COLUMN analytical_stem_view.stratum__name IS 'from VegX, renamed';
|
|
| 7041 |
COMMENT ON COLUMN analytical_stem_view."stratumName__@VegX__.stratum@vegpath.org" IS 'from VegX, renamed';
|
|
| 7042 | 7042 |
|
| 7043 | 7043 |
|
| 7044 | 7044 |
-- |
| 7045 |
-- Name: COLUMN analytical_stem_view.communities; Type: COMMENT; Schema: public; Owner: -
|
|
| 7045 |
-- Name: COLUMN analytical_stem_view."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7046 | 7046 |
-- |
| 7047 | 7047 |
|
| 7048 |
COMMENT ON COLUMN analytical_stem_view.communities IS 'variant of VegX term';
|
|
| 7048 |
COMMENT ON COLUMN analytical_stem_view."communityConcept.name__@VegX__.communityDet@vegpath.org" IS 'variant of VegX term';
|
|
| 7049 | 7049 |
|
| 7050 | 7050 |
|
| 7051 | 7051 |
-- |
| 7052 |
-- Name: COLUMN analytical_stem_view.plot__collectors; Type: COMMENT; Schema: public; Owner: -
|
|
| 7052 |
-- Name: COLUMN analytical_stem_view."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7053 | 7053 |
-- |
| 7054 | 7054 |
|
| 7055 |
COMMENT ON COLUMN analytical_stem_view.plot__collectors IS 'variant of VegBank term';
|
|
| 7055 |
COMMENT ON COLUMN analytical_stem_view."observationContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term';
|
|
| 7056 | 7056 |
|
| 7057 | 7057 |
|
| 7058 | 7058 |
-- |
| 7059 |
-- Name: COLUMN analytical_stem_view."specimenHolderInstitutions"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7059 |
-- Name: COLUMN analytical_stem_view."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7060 | 7060 |
-- |
| 7061 | 7061 |
|
| 7062 |
COMMENT ON COLUMN analytical_stem_view."specimenHolderInstitutions" IS 'from DwC, renamed';
|
|
| 7062 |
COMMENT ON COLUMN analytical_stem_view."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS 'from DwC, renamed';
|
|
| 7063 | 7063 |
|
| 7064 | 7064 |
|
| 7065 | 7065 |
-- |
| 7066 |
-- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: -
|
|
| 7066 |
-- Name: COLUMN analytical_stem_view."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7067 | 7067 |
-- |
| 7068 | 7068 |
|
| 7069 |
COMMENT ON COLUMN analytical_stem_view.collection IS 'from DwC, renamed';
|
|
| 7069 |
COMMENT ON COLUMN analytical_stem_view."collectionCode__@DwC__@vegpath.org" IS 'from DwC, renamed';
|
|
| 7070 | 7070 |
|
| 7071 | 7071 |
|
| 7072 | 7072 |
-- |
| 7073 |
-- Name: COLUMN analytical_stem_view."accessionNumber"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7073 |
-- Name: COLUMN analytical_stem_view."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7074 | 7074 |
-- |
| 7075 | 7075 |
|
| 7076 |
COMMENT ON COLUMN analytical_stem_view."accessionNumber" IS 'variant of DwC term';
|
|
| 7076 |
COMMENT ON COLUMN analytical_stem_view."catalogNumber__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 7077 | 7077 |
|
| 7078 | 7078 |
|
| 7079 | 7079 |
-- |
| ... | ... | |
| 7098 | 7098 |
|
| 7099 | 7099 |
|
| 7100 | 7100 |
-- |
| 7101 |
-- Name: COLUMN analytical_stem_view."dateCollected"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7101 |
-- Name: COLUMN analytical_stem_view."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7102 | 7102 |
-- |
| 7103 | 7103 |
|
| 7104 |
COMMENT ON COLUMN analytical_stem_view."dateCollected" IS 'variant of DwC term';
|
|
| 7104 |
COMMENT ON COLUMN analytical_stem_view."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'variant of DwC term';
|
|
| 7105 | 7105 |
|
| 7106 | 7106 |
|
| 7107 | 7107 |
-- |
| 7108 |
-- Name: COLUMN analytical_stem_view.family_verbatim; Type: COMMENT; Schema: public; Owner: -
|
|
| 7108 |
-- Name: COLUMN analytical_stem_view."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7109 | 7109 |
-- |
| 7110 | 7110 |
|
| 7111 |
COMMENT ON COLUMN analytical_stem_view.family_verbatim IS 'variant of DwC term';
|
|
| 7111 |
COMMENT ON COLUMN analytical_stem_view."[verbatim_]family__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 7112 | 7112 |
|
| 7113 | 7113 |
|
| 7114 | 7114 |
-- |
| 7115 |
-- Name: COLUMN analytical_stem_view."scientificName_verbatim"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7115 |
-- Name: COLUMN analytical_stem_view."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7116 | 7116 |
-- |
| 7117 | 7117 |
|
| 7118 |
COMMENT ON COLUMN analytical_stem_view."scientificName_verbatim" IS 'variant of DwC term';
|
|
| 7118 |
COMMENT ON COLUMN analytical_stem_view."[verbatim_]scientificName__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 7119 | 7119 |
|
| 7120 | 7120 |
|
| 7121 | 7121 |
-- |
| ... | ... | |
| 7148 | 7148 |
|
| 7149 | 7149 |
|
| 7150 | 7150 |
-- |
| 7151 |
-- Name: COLUMN analytical_stem_view."taxonName_matched"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7151 |
-- Name: COLUMN analytical_stem_view."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7152 | 7152 |
-- |
| 7153 | 7153 |
|
| 7154 |
COMMENT ON COLUMN analytical_stem_view."taxonName_matched" IS 'from TNRS, renamed';
|
|
| 7154 |
COMMENT ON COLUMN analytical_stem_view."Name_matched__@TNRS__@vegpath.org" IS 'from TNRS, renamed';
|
|
| 7155 | 7155 |
|
| 7156 | 7156 |
|
| 7157 | 7157 |
-- |
| 7158 |
-- Name: COLUMN analytical_stem_view."scientificNameAuthorship_matched"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7158 |
-- Name: COLUMN analytical_stem_view."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7159 | 7159 |
-- |
| 7160 | 7160 |
|
| 7161 |
COMMENT ON COLUMN analytical_stem_view."scientificNameAuthorship_matched" IS 'from TNRS, renamed';
|
|
| 7161 |
COMMENT ON COLUMN analytical_stem_view."Name_matched_author__@TNRS__@vegpath.org" IS 'from TNRS, renamed';
|
|
| 7162 | 7162 |
|
| 7163 | 7163 |
|
| 7164 | 7164 |
-- |
| 7165 |
-- Name: COLUMN analytical_stem_view."higherPlantGroup_bien"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7165 |
-- Name: COLUMN analytical_stem_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7166 | 7166 |
-- |
| 7167 | 7167 |
|
| 7168 |
COMMENT ON COLUMN analytical_stem_view."higherPlantGroup_bien" IS 'derived column';
|
|
| 7168 |
COMMENT ON COLUMN analytical_stem_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'derived column';
|
|
| 7169 | 7169 |
|
| 7170 | 7170 |
|
| 7171 | 7171 |
-- |
| 7172 |
-- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: -
|
|
| 7172 |
-- Name: COLUMN analytical_stem_view."taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7173 | 7173 |
-- |
| 7174 | 7174 |
|
| 7175 |
COMMENT ON COLUMN analytical_stem_view.taxonomic_status IS 'from DwC, renamed';
|
|
| 7175 |
COMMENT ON COLUMN analytical_stem_view."taxonomicStatus__@DwC__@vegpath.org" IS 'from DwC, renamed';
|
|
| 7176 | 7176 |
|
| 7177 | 7177 |
|
| 7178 | 7178 |
-- |
| ... | ... | |
| 7233 | 7233 |
|
| 7234 | 7234 |
|
| 7235 | 7235 |
-- |
| 7236 |
-- Name: COLUMN analytical_stem_view."growthForm"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7236 |
-- Name: COLUMN analytical_stem_view."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7237 | 7237 |
-- |
| 7238 | 7238 |
|
| 7239 |
COMMENT ON COLUMN analytical_stem_view."growthForm" IS 'from SALVIAS, renamed';
|
|
| 7239 |
COMMENT ON COLUMN analytical_stem_view."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS 'from SALVIAS, renamed';
|
|
| 7240 | 7240 |
|
| 7241 | 7241 |
|
| 7242 | 7242 |
-- |
| ... | ... | |
| 7282 | 7282 |
|
| 7283 | 7283 |
|
| 7284 | 7284 |
-- |
| 7285 |
-- Name: COLUMN analytical_stem_view."diameterBreastHeight_cm"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7285 |
-- Name: COLUMN analytical_stem_view."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7286 | 7286 |
-- |
| 7287 | 7287 |
|
| 7288 |
COMMENT ON COLUMN analytical_stem_view."diameterBreastHeight_cm" IS 'from SALVIAS, renamed';
|
|
| 7288 |
COMMENT ON COLUMN analytical_stem_view."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS 'from SALVIAS, renamed';
|
|
| 7289 | 7289 |
|
| 7290 | 7290 |
|
| 7291 | 7291 |
-- |
| 7292 |
-- Name: COLUMN analytical_stem_view.height_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 7292 |
-- Name: COLUMN analytical_stem_view."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7293 | 7293 |
-- |
| 7294 | 7294 |
|
| 7295 |
COMMENT ON COLUMN analytical_stem_view.height_m IS 'variant of VegX term';
|
|
| 7295 |
COMMENT ON COLUMN analytical_stem_view."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS 'variant of VegX term';
|
|
| 7296 | 7296 |
|
| 7297 | 7297 |
|
| 7298 | 7298 |
-- |
| 7299 |
-- Name: COLUMN analytical_stem_view.tag; Type: COMMENT; Schema: public; Owner: -
|
|
| 7299 |
-- Name: COLUMN analytical_stem_view."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7300 | 7300 |
-- |
| 7301 | 7301 |
|
| 7302 |
COMMENT ON COLUMN analytical_stem_view.tag IS 'from VegX, renamed';
|
|
| 7302 |
COMMENT ON COLUMN analytical_stem_view."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS 'from VegX, renamed';
|
|
| 7303 | 7303 |
|
| 7304 | 7304 |
|
| 7305 | 7305 |
-- |
| 7306 |
-- Name: COLUMN analytical_stem_view."organismX_m"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7306 |
-- Name: COLUMN analytical_stem_view."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7307 | 7307 |
-- |
| 7308 | 7308 |
|
| 7309 |
COMMENT ON COLUMN analytical_stem_view."organismX_m" IS 'variant of VegX term';
|
|
| 7309 |
COMMENT ON COLUMN analytical_stem_view."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS 'variant of VegX term';
|
|
| 7310 | 7310 |
|
| 7311 | 7311 |
|
| 7312 | 7312 |
-- |
| 7313 |
-- Name: COLUMN analytical_stem_view."organismY_m"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7313 |
-- Name: COLUMN analytical_stem_view."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7314 | 7314 |
-- |
| 7315 | 7315 |
|
| 7316 |
COMMENT ON COLUMN analytical_stem_view."organismY_m" IS 'variant of VegX term';
|
|
| 7316 |
COMMENT ON COLUMN analytical_stem_view."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS 'variant of VegX term';
|
|
| 7317 | 7317 |
|
| 7318 | 7318 |
|
| 7319 | 7319 |
-- |
| 7320 |
-- Name: COLUMN analytical_stem_view."taxonOccurrenceID"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7320 |
-- Name: COLUMN analytical_stem_view."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7321 | 7321 |
-- |
| 7322 | 7322 |
|
| 7323 |
COMMENT ON COLUMN analytical_stem_view."taxonOccurrenceID" IS 'from VegX, renamed';
|
|
| 7323 |
COMMENT ON COLUMN analytical_stem_view."taxonObservation[.id]__@VegBank__@vegpath.org" IS 'from VegX, renamed';
|
|
| 7324 | 7324 |
|
| 7325 | 7325 |
|
| 7326 | 7326 |
-- |
| ... | ... | |
| 7331 | 7331 |
|
| 7332 | 7332 |
|
| 7333 | 7333 |
-- |
| 7334 |
-- Name: COLUMN analytical_stem_view."aggregateOrganismObservationID"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7334 |
-- Name: COLUMN analytical_stem_view."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7335 | 7335 |
-- |
| 7336 | 7336 |
|
| 7337 |
COMMENT ON COLUMN analytical_stem_view."aggregateOrganismObservationID" IS 'from VegX, renamed';
|
|
| 7337 |
COMMENT ON COLUMN analytical_stem_view."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'from VegX, renamed';
|
|
| 7338 | 7338 |
|
| 7339 | 7339 |
|
| 7340 | 7340 |
-- |
| 7341 |
-- Name: COLUMN analytical_stem_view."individualObservationID"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7341 |
-- Name: COLUMN analytical_stem_view."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7342 | 7342 |
-- |
| 7343 | 7343 |
|
| 7344 |
COMMENT ON COLUMN analytical_stem_view."individualObservationID" IS 'from VegX, renamed';
|
|
| 7344 |
COMMENT ON COLUMN analytical_stem_view."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'from VegX, renamed';
|
|
| 7345 | 7345 |
|
| 7346 | 7346 |
|
| 7347 | 7347 |
-- |
| 7348 |
-- Name: COLUMN analytical_stem_view."individualCode"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7348 |
-- Name: COLUMN analytical_stem_view."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7349 | 7349 |
-- |
| 7350 | 7350 |
|
| 7351 |
COMMENT ON COLUMN analytical_stem_view."individualCode" IS 'from SALVIAS, renamed';
|
|
| 7351 |
COMMENT ON COLUMN analytical_stem_view."individualID__@DwC__@vegpath.org" IS 'from SALVIAS, renamed';
|
|
| 7352 | 7352 |
|
| 7353 | 7353 |
|
| 7354 | 7354 |
-- |
| ... | ... | |
| 7359 | 7359 |
|
| 7360 | 7360 |
|
| 7361 | 7361 |
-- |
| 7362 |
-- Name: COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7362 |
-- Name: COLUMN analytical_stem_view."stemCode__@VegBank__.stemLocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7363 | 7363 |
-- |
| 7364 | 7364 |
|
| 7365 |
COMMENT ON COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
|
|
| 7365 |
COMMENT ON COLUMN analytical_stem_view."stemCode__@VegBank__.stemLocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
|
|
| 7366 | 7366 |
"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."'; |
| 7367 | 7367 |
|
| 7368 | 7368 |
|
Also available in: Unified diff
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