Revision 13834
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 4222 | 4222 |
|
| 4223 | 4223 |
|
| 4224 | 4224 |
-- |
| 4225 |
-- Name: COLUMN analytical_stem_view.datasource; Type: COMMENT; Schema: public; Owner: -
|
|
| 4225 |
-- Name: COLUMN analytical_stem_view.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4226 | 4226 |
-- |
| 4227 | 4227 |
|
| 4228 | 4228 |
|
| ... | ... | |
| 4383 | 4383 |
|
| 4384 | 4384 |
|
| 4385 | 4385 |
-- |
| 4386 |
-- Name: COLUMN analytical_stem_view.`area[_ha]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4386 |
-- Name: COLUMN analytical_stem_view.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4387 | 4387 |
-- |
| 4388 | 4388 |
|
| 4389 | 4389 |
|
| ... | ... | |
| 4698 | 4698 |
|
| 4699 | 4699 |
|
| 4700 | 4700 |
-- |
| 4701 |
-- Name: COLUMN analytical_stem_view.`authorTaxonCode`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4701 |
-- Name: COLUMN analytical_stem_view.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4702 | 4702 |
-- |
| 4703 | 4703 |
|
| 4704 | 4704 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 6793 | 6793 |
-- |
| 6794 | 6794 |
|
| 6795 | 6795 |
CREATE VIEW analytical_stem_view AS |
| 6796 |
SELECT "plot.**".datasource, |
|
| 6796 |
SELECT "plot.**".datasource AS "datasource__@Brad__.identifier_examples@vegpath.org",
|
|
| 6797 | 6797 |
"plot.**".country AS "country__@DwC__@vegpath.org", |
| 6798 | 6798 |
"plot.**"."stateProvince" AS "stateProvince__@DwC__@vegpath.org", |
| 6799 | 6799 |
"plot.**".county AS "county__@DwC__@vegpath.org", |
| ... | ... | |
| 6816 | 6816 |
"plot.**"."elevationInMeters" AS "(-minimum-)ElevationInMeters__@DwC__@vegpath.org", |
| 6817 | 6817 |
"plot.**"."slopeAspect" AS "slopeAspect[_deg]__@VegX__.plot@vegpath.org", |
| 6818 | 6818 |
"plot.**"."slopeGradient" AS "slopeGradient[_deg]__@VegX__.plot@vegpath.org", |
| 6819 |
"plot.**"."plotArea_ha" AS "area[_ha]__@VegX__.plot@vegpath.org",
|
|
| 6819 |
"plot.**"."plotArea_ha" AS "plot.area[_ha]__@VegX__@vegpath.org",
|
|
| 6820 | 6820 |
"plot.**"."samplingProtocol" AS "samplingProtocol__@DwC__@vegpath.org", |
| 6821 | 6821 |
"plot.**"."temperature_C" AS "temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org", |
| 6822 | 6822 |
"plot.**".precipitation_m AS "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org", |
| ... | ... | |
| 6865 | 6865 |
stemobservation.xposition_m AS "relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org", |
| 6866 | 6866 |
stemobservation.yposition_m AS "relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org", |
| 6867 | 6867 |
taxonoccurrence.sourceaccessioncode AS "taxonObservation[.id]__@VegBank__@vegpath.org", |
| 6868 |
taxonoccurrence.authortaxoncode AS "authorTaxonCode",
|
|
| 6868 |
taxonoccurrence.authortaxoncode AS "taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",
|
|
| 6869 | 6869 |
aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservation.id__@VegX__@vegpath.org", |
| 6870 | 6870 |
plantobservation.sourceaccessioncode AS "individualOrganismObservation.id__@VegX__@vegpath.org", |
| 6871 | 6871 |
plantobservation.authorplantcode AS "individualID__@DwC__@vegpath.org", |
| ... | ... | |
| 6901 | 6901 |
|
| 6902 | 6902 |
|
| 6903 | 6903 |
-- |
| 6904 |
-- Name: COLUMN analytical_stem_view.datasource; Type: COMMENT; Schema: public; Owner: -
|
|
| 6904 |
-- Name: COLUMN analytical_stem_view."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6905 | 6905 |
-- |
| 6906 | 6906 |
|
| 6907 |
COMMENT ON COLUMN analytical_stem_view.datasource IS 'variant of DwC term';
|
|
| 6907 |
COMMENT ON COLUMN analytical_stem_view."datasource__@Brad__.identifier_examples@vegpath.org" IS 'variant of DwC term';
|
|
| 6908 | 6908 |
|
| 6909 | 6909 |
|
| 6910 | 6910 |
-- |
| ... | ... | |
| 7066 | 7066 |
|
| 7067 | 7067 |
|
| 7068 | 7068 |
-- |
| 7069 |
-- Name: COLUMN analytical_stem_view."area[_ha]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7069 |
-- Name: COLUMN analytical_stem_view."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7070 | 7070 |
-- |
| 7071 | 7071 |
|
| 7072 |
COMMENT ON COLUMN analytical_stem_view."area[_ha]__@VegX__.plot@vegpath.org" IS 'variant of VegX term';
|
|
| 7072 |
COMMENT ON COLUMN analytical_stem_view."plot.area[_ha]__@VegX__@vegpath.org" IS 'variant of VegX term';
|
|
| 7073 | 7073 |
|
| 7074 | 7074 |
|
| 7075 | 7075 |
-- |
| ... | ... | |
| 7383 | 7383 |
|
| 7384 | 7384 |
|
| 7385 | 7385 |
-- |
| 7386 |
-- Name: COLUMN analytical_stem_view."authorTaxonCode"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7386 |
-- Name: COLUMN analytical_stem_view."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7387 | 7387 |
-- |
| 7388 | 7388 |
|
| 7389 |
COMMENT ON COLUMN analytical_stem_view."authorTaxonCode" IS 'variant of VegBank term';
|
|
| 7389 |
COMMENT ON COLUMN analytical_stem_view."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS 'variant of VegBank term';
|
|
| 7390 | 7390 |
|
| 7391 | 7391 |
|
| 7392 | 7392 |
-- |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 6793 | 6793 |
-- |
| 6794 | 6794 |
|
| 6795 | 6795 |
CREATE VIEW analytical_stem_view AS |
| 6796 |
SELECT "plot.**".datasource, |
|
| 6796 |
SELECT "plot.**".datasource AS "datasource__@Brad__.identifier_examples@vegpath.org",
|
|
| 6797 | 6797 |
"plot.**".country AS "country__@DwC__@vegpath.org", |
| 6798 | 6798 |
"plot.**"."stateProvince" AS "stateProvince__@DwC__@vegpath.org", |
| 6799 | 6799 |
"plot.**".county AS "county__@DwC__@vegpath.org", |
| ... | ... | |
| 6816 | 6816 |
"plot.**"."elevationInMeters" AS "(-minimum-)ElevationInMeters__@DwC__@vegpath.org", |
| 6817 | 6817 |
"plot.**"."slopeAspect" AS "slopeAspect[_deg]__@VegX__.plot@vegpath.org", |
| 6818 | 6818 |
"plot.**"."slopeGradient" AS "slopeGradient[_deg]__@VegX__.plot@vegpath.org", |
| 6819 |
"plot.**"."plotArea_ha" AS "area[_ha]__@VegX__.plot@vegpath.org",
|
|
| 6819 |
"plot.**"."plotArea_ha" AS "plot.area[_ha]__@VegX__@vegpath.org",
|
|
| 6820 | 6820 |
"plot.**"."samplingProtocol" AS "samplingProtocol__@DwC__@vegpath.org", |
| 6821 | 6821 |
"plot.**"."temperature_C" AS "temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org", |
| 6822 | 6822 |
"plot.**".precipitation_m AS "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org", |
| ... | ... | |
| 6865 | 6865 |
stemobservation.xposition_m AS "relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org", |
| 6866 | 6866 |
stemobservation.yposition_m AS "relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org", |
| 6867 | 6867 |
taxonoccurrence.sourceaccessioncode AS "taxonObservation[.id]__@VegBank__@vegpath.org", |
| 6868 |
taxonoccurrence.authortaxoncode AS "authorTaxonCode",
|
|
| 6868 |
taxonoccurrence.authortaxoncode AS "taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",
|
|
| 6869 | 6869 |
aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservation.id__@VegX__@vegpath.org", |
| 6870 | 6870 |
plantobservation.sourceaccessioncode AS "individualOrganismObservation.id__@VegX__@vegpath.org", |
| 6871 | 6871 |
plantobservation.authorplantcode AS "individualID__@DwC__@vegpath.org", |
| ... | ... | |
| 6901 | 6901 |
|
| 6902 | 6902 |
|
| 6903 | 6903 |
-- |
| 6904 |
-- Name: COLUMN analytical_stem_view.datasource; Type: COMMENT; Schema: public; Owner: -
|
|
| 6904 |
-- Name: COLUMN analytical_stem_view."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6905 | 6905 |
-- |
| 6906 | 6906 |
|
| 6907 |
COMMENT ON COLUMN analytical_stem_view.datasource IS 'variant of DwC term';
|
|
| 6907 |
COMMENT ON COLUMN analytical_stem_view."datasource__@Brad__.identifier_examples@vegpath.org" IS 'variant of DwC term';
|
|
| 6908 | 6908 |
|
| 6909 | 6909 |
|
| 6910 | 6910 |
-- |
| ... | ... | |
| 7066 | 7066 |
|
| 7067 | 7067 |
|
| 7068 | 7068 |
-- |
| 7069 |
-- Name: COLUMN analytical_stem_view."area[_ha]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7069 |
-- Name: COLUMN analytical_stem_view."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7070 | 7070 |
-- |
| 7071 | 7071 |
|
| 7072 |
COMMENT ON COLUMN analytical_stem_view."area[_ha]__@VegX__.plot@vegpath.org" IS 'variant of VegX term';
|
|
| 7072 |
COMMENT ON COLUMN analytical_stem_view."plot.area[_ha]__@VegX__@vegpath.org" IS 'variant of VegX term';
|
|
| 7073 | 7073 |
|
| 7074 | 7074 |
|
| 7075 | 7075 |
-- |
| ... | ... | |
| 7383 | 7383 |
|
| 7384 | 7384 |
|
| 7385 | 7385 |
-- |
| 7386 |
-- Name: COLUMN analytical_stem_view."authorTaxonCode"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7386 |
-- Name: COLUMN analytical_stem_view."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7387 | 7387 |
-- |
| 7388 | 7388 |
|
| 7389 |
COMMENT ON COLUMN analytical_stem_view."authorTaxonCode" IS 'variant of VegBank term';
|
|
| 7389 |
COMMENT ON COLUMN analytical_stem_view."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS 'variant of VegBank term';
|
|
| 7390 | 7390 |
|
| 7391 | 7391 |
|
| 7392 | 7392 |
-- |
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