Revision 13692
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 4278 | 4278 |
|
| 4279 | 4279 |
|
| 4280 | 4280 |
-- |
| 4281 |
-- Name: COLUMN analytical_stem_view.`projectID@plotObservation@VegX@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4281 |
-- Name: COLUMN analytical_stem_view.`projectID@VegX.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4282 | 4282 |
-- |
| 4283 | 4283 |
|
| 4284 | 4284 |
|
| ... | ... | |
| 4299 | 4299 |
|
| 4300 | 4300 |
|
| 4301 | 4301 |
-- |
| 4302 |
-- Name: COLUMN analytical_stem_view.`plotName@plot@VegX@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4302 |
-- Name: COLUMN analytical_stem_view.`plotName@VegX.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4303 | 4303 |
-- |
| 4304 | 4304 |
|
| 4305 | 4305 |
|
| ... | ... | |
| 4341 | 4341 |
|
| 4342 | 4342 |
|
| 4343 | 4343 |
-- |
| 4344 |
-- Name: COLUMN analytical_stem_view.`slopeAspect@plot@VegX@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4344 |
-- Name: COLUMN analytical_stem_view.`slopeAspect@VegX.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4345 | 4345 |
-- |
| 4346 | 4346 |
|
| 4347 | 4347 |
|
| 4348 | 4348 |
|
| 4349 | 4349 |
|
| 4350 | 4350 |
-- |
| 4351 |
-- Name: COLUMN analytical_stem_view.`slopeGradient@plot@VegX@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4351 |
-- Name: COLUMN analytical_stem_view.`slopeGradient@VegX.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4352 | 4352 |
-- |
| 4353 | 4353 |
|
| 4354 | 4354 |
|
| ... | ... | |
| 4621 | 4621 |
|
| 4622 | 4622 |
|
| 4623 | 4623 |
-- |
| 4624 |
-- Name: COLUMN analytical_stem_view.`coverPercent@attribute.ordinal@VegX@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4624 |
-- Name: COLUMN analytical_stem_view.`coverPercent@VegX.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4625 | 4625 |
-- |
| 4626 | 4626 |
|
| 4627 | 4627 |
|
| ... | ... | |
| 4705 | 4705 |
|
| 4706 | 4706 |
|
| 4707 | 4707 |
-- |
| 4708 |
-- Name: COLUMN analytical_stem_view.`stemCode@stemlocation@VegBank@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4708 |
-- Name: COLUMN analytical_stem_view.`stemCode@VegBank.stemlocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4709 | 4709 |
-- |
| 4710 | 4710 |
|
| 4711 | 4711 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 6746 | 6746 |
"plot.**"."georeferenceProtocol_bien", |
| 6747 | 6747 |
"plot.**".geovalid_bien, |
| 6748 | 6748 |
"plot.**"."isNewWorld_bien", |
| 6749 |
"plot.**"."projectID" AS "projectID@plotObservation@VegX@vegpath.org",
|
|
| 6749 |
"plot.**"."projectID" AS "projectID@VegX.plotObservation@vegpath.org",
|
|
| 6750 | 6750 |
"plot.**".project_contributors, |
| 6751 | 6751 |
"plot.**"."locationID" AS "locationID@DwC@vegpath.org", |
| 6752 |
"plot.**"."locationName" AS "plotName@plot@VegX@vegpath.org",
|
|
| 6752 |
"plot.**"."locationName" AS "plotName@VegX.plot@vegpath.org",
|
|
| 6753 | 6753 |
"plot.**".subplot AS "subplot@SALVIAS@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 | 6757 |
"plot.**"."elevationInMeters", |
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect@plot@VegX@vegpath.org",
|
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient@plot@VegX@vegpath.org",
|
|
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect@VegX.plot@vegpath.org",
|
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient@VegX.plot@vegpath.org",
|
|
| 6760 | 6760 |
"plot.**"."plotArea_ha", |
| 6761 | 6761 |
"plot.**"."samplingProtocol" AS "samplingProtocol@DwC@vegpath.org", |
| 6762 | 6762 |
"plot.**"."temperature_C", |
| ... | ... | |
| 6799 | 6799 |
ELSE NULL::text |
| 6800 | 6800 |
END AS "cultivatedBasis_bien", |
| 6801 | 6801 |
aggregateoccurrence.notes AS "occurrenceRemarks@DwC@vegpath.org", |
| 6802 |
_fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent@attribute.ordinal@VegX@vegpath.org",
|
|
| 6802 |
_fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent@VegX.attribute.ordinal@vegpath.org",
|
|
| 6803 | 6803 |
_m_to_cm(stemobservation.diameterbreastheight_m) AS "diameterBreastHeight_cm", |
| 6804 | 6804 |
stemobservation.height_m, |
| 6805 | 6805 |
stemobservation.tag, |
| ... | ... | |
| 6811 | 6811 |
plantobservation.sourceaccessioncode AS "individualObservationID", |
| 6812 | 6812 |
plantobservation.authorplantcode AS "individualCode", |
| 6813 | 6813 |
aggregateoccurrence.count AS "individualCount@DwC@vegpath.org", |
| 6814 |
stemobservation.authorstemcode AS "stemCode@stemlocation@VegBank@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))) |
| ... | ... | |
| 6926 | 6926 |
|
| 6927 | 6927 |
|
| 6928 | 6928 |
-- |
| 6929 |
-- Name: COLUMN analytical_stem_view."projectID@plotObservation@VegX@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6929 |
-- Name: COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6930 | 6930 |
-- |
| 6931 | 6931 |
|
| 6932 |
COMMENT ON COLUMN analytical_stem_view."projectID@plotObservation@VegX@vegpath.org" IS '"A reference to a specific ''project''"';
|
|
| 6932 |
COMMENT ON COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org" IS '"A reference to a specific ''project''"';
|
|
| 6933 | 6933 |
|
| 6934 | 6934 |
|
| 6935 | 6935 |
-- |
| ... | ... | |
| 6947 | 6947 |
|
| 6948 | 6948 |
|
| 6949 | 6949 |
-- |
| 6950 |
-- Name: COLUMN analytical_stem_view."plotName@plot@VegX@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6950 |
-- Name: COLUMN analytical_stem_view."plotName@VegX.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6951 | 6951 |
-- |
| 6952 | 6952 |
|
| 6953 |
COMMENT ON COLUMN analytical_stem_view."plotName@plot@VegX@vegpath.org" IS '"Name or label for a plot"';
|
|
| 6953 |
COMMENT ON COLUMN analytical_stem_view."plotName@VegX.plot@vegpath.org" IS '"Name or label for a plot"';
|
|
| 6954 | 6954 |
|
| 6955 | 6955 |
|
| 6956 | 6956 |
-- |
| ... | ... | |
| 6989 | 6989 |
|
| 6990 | 6990 |
|
| 6991 | 6991 |
-- |
| 6992 |
-- Name: COLUMN analytical_stem_view."slopeAspect@plot@VegX@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6992 |
-- Name: COLUMN analytical_stem_view."slopeAspect@VegX.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6993 | 6993 |
-- |
| 6994 | 6994 |
|
| 6995 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect@plot@VegX@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';
|
|
| 6995 |
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)"';
|
|
| 6996 | 6996 |
|
| 6997 | 6997 |
|
| 6998 | 6998 |
-- |
| 6999 |
-- Name: COLUMN analytical_stem_view."slopeGradient@plot@VegX@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6999 |
-- Name: COLUMN analytical_stem_view."slopeGradient@VegX.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7000 | 7000 |
-- |
| 7001 | 7001 |
|
| 7002 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient@plot@VegX@vegpath.org" IS '"Representative inclination of slope in degrees"';
|
|
| 7002 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient@VegX.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
|
|
| 7003 | 7003 |
|
| 7004 | 7004 |
|
| 7005 | 7005 |
-- |
| ... | ... | |
| 7269 | 7269 |
|
| 7270 | 7270 |
|
| 7271 | 7271 |
-- |
| 7272 |
-- Name: COLUMN analytical_stem_view."coverPercent@attribute.ordinal@VegX@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7272 |
-- Name: COLUMN analytical_stem_view."coverPercent@VegX.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7273 | 7273 |
-- |
| 7274 | 7274 |
|
| 7275 |
COMMENT ON COLUMN analytical_stem_view."coverPercent@attribute.ordinal@VegX@vegpath.org" IS '"Average cover of the index in percent"';
|
|
| 7275 |
COMMENT ON COLUMN analytical_stem_view."coverPercent@VegX.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';
|
|
| 7276 | 7276 |
|
| 7277 | 7277 |
|
| 7278 | 7278 |
-- |
| ... | ... | |
| 7353 | 7353 |
|
| 7354 | 7354 |
|
| 7355 | 7355 |
-- |
| 7356 |
-- Name: COLUMN analytical_stem_view."stemCode@stemlocation@VegBank@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7356 |
-- Name: COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7357 | 7357 |
-- |
| 7358 | 7358 |
|
| 7359 |
COMMENT ON COLUMN analytical_stem_view."stemCode@stemlocation@VegBank@vegpath.org" IS '"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."';
|
|
| 7359 |
COMMENT ON COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org" IS '"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."';
|
|
| 7360 | 7360 |
|
| 7361 | 7361 |
|
| 7362 | 7362 |
-- |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 6746 | 6746 |
"plot.**"."georeferenceProtocol_bien", |
| 6747 | 6747 |
"plot.**".geovalid_bien, |
| 6748 | 6748 |
"plot.**"."isNewWorld_bien", |
| 6749 |
"plot.**"."projectID" AS "projectID@plotObservation@VegX@vegpath.org",
|
|
| 6749 |
"plot.**"."projectID" AS "projectID@VegX.plotObservation@vegpath.org",
|
|
| 6750 | 6750 |
"plot.**".project_contributors, |
| 6751 | 6751 |
"plot.**"."locationID" AS "locationID@DwC@vegpath.org", |
| 6752 |
"plot.**"."locationName" AS "plotName@plot@VegX@vegpath.org",
|
|
| 6752 |
"plot.**"."locationName" AS "plotName@VegX.plot@vegpath.org",
|
|
| 6753 | 6753 |
"plot.**".subplot AS "subplot@SALVIAS@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 | 6757 |
"plot.**"."elevationInMeters", |
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect@plot@VegX@vegpath.org",
|
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient@plot@VegX@vegpath.org",
|
|
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect@VegX.plot@vegpath.org",
|
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient@VegX.plot@vegpath.org",
|
|
| 6760 | 6760 |
"plot.**"."plotArea_ha", |
| 6761 | 6761 |
"plot.**"."samplingProtocol" AS "samplingProtocol@DwC@vegpath.org", |
| 6762 | 6762 |
"plot.**"."temperature_C", |
| ... | ... | |
| 6799 | 6799 |
ELSE NULL::text |
| 6800 | 6800 |
END AS "cultivatedBasis_bien", |
| 6801 | 6801 |
aggregateoccurrence.notes AS "occurrenceRemarks@DwC@vegpath.org", |
| 6802 |
_fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent@attribute.ordinal@VegX@vegpath.org",
|
|
| 6802 |
_fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent@VegX.attribute.ordinal@vegpath.org",
|
|
| 6803 | 6803 |
_m_to_cm(stemobservation.diameterbreastheight_m) AS "diameterBreastHeight_cm", |
| 6804 | 6804 |
stemobservation.height_m, |
| 6805 | 6805 |
stemobservation.tag, |
| ... | ... | |
| 6811 | 6811 |
plantobservation.sourceaccessioncode AS "individualObservationID", |
| 6812 | 6812 |
plantobservation.authorplantcode AS "individualCode", |
| 6813 | 6813 |
aggregateoccurrence.count AS "individualCount@DwC@vegpath.org", |
| 6814 |
stemobservation.authorstemcode AS "stemCode@stemlocation@VegBank@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))) |
| ... | ... | |
| 6926 | 6926 |
|
| 6927 | 6927 |
|
| 6928 | 6928 |
-- |
| 6929 |
-- Name: COLUMN analytical_stem_view."projectID@plotObservation@VegX@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6929 |
-- Name: COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6930 | 6930 |
-- |
| 6931 | 6931 |
|
| 6932 |
COMMENT ON COLUMN analytical_stem_view."projectID@plotObservation@VegX@vegpath.org" IS '"A reference to a specific ''project''"';
|
|
| 6932 |
COMMENT ON COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org" IS '"A reference to a specific ''project''"';
|
|
| 6933 | 6933 |
|
| 6934 | 6934 |
|
| 6935 | 6935 |
-- |
| ... | ... | |
| 6947 | 6947 |
|
| 6948 | 6948 |
|
| 6949 | 6949 |
-- |
| 6950 |
-- Name: COLUMN analytical_stem_view."plotName@plot@VegX@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6950 |
-- Name: COLUMN analytical_stem_view."plotName@VegX.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6951 | 6951 |
-- |
| 6952 | 6952 |
|
| 6953 |
COMMENT ON COLUMN analytical_stem_view."plotName@plot@VegX@vegpath.org" IS '"Name or label for a plot"';
|
|
| 6953 |
COMMENT ON COLUMN analytical_stem_view."plotName@VegX.plot@vegpath.org" IS '"Name or label for a plot"';
|
|
| 6954 | 6954 |
|
| 6955 | 6955 |
|
| 6956 | 6956 |
-- |
| ... | ... | |
| 6989 | 6989 |
|
| 6990 | 6990 |
|
| 6991 | 6991 |
-- |
| 6992 |
-- Name: COLUMN analytical_stem_view."slopeAspect@plot@VegX@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6992 |
-- Name: COLUMN analytical_stem_view."slopeAspect@VegX.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6993 | 6993 |
-- |
| 6994 | 6994 |
|
| 6995 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect@plot@VegX@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';
|
|
| 6995 |
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)"';
|
|
| 6996 | 6996 |
|
| 6997 | 6997 |
|
| 6998 | 6998 |
-- |
| 6999 |
-- Name: COLUMN analytical_stem_view."slopeGradient@plot@VegX@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6999 |
-- Name: COLUMN analytical_stem_view."slopeGradient@VegX.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7000 | 7000 |
-- |
| 7001 | 7001 |
|
| 7002 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient@plot@VegX@vegpath.org" IS '"Representative inclination of slope in degrees"';
|
|
| 7002 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient@VegX.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
|
|
| 7003 | 7003 |
|
| 7004 | 7004 |
|
| 7005 | 7005 |
-- |
| ... | ... | |
| 7269 | 7269 |
|
| 7270 | 7270 |
|
| 7271 | 7271 |
-- |
| 7272 |
-- Name: COLUMN analytical_stem_view."coverPercent@attribute.ordinal@VegX@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7272 |
-- Name: COLUMN analytical_stem_view."coverPercent@VegX.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7273 | 7273 |
-- |
| 7274 | 7274 |
|
| 7275 |
COMMENT ON COLUMN analytical_stem_view."coverPercent@attribute.ordinal@VegX@vegpath.org" IS '"Average cover of the index in percent"';
|
|
| 7275 |
COMMENT ON COLUMN analytical_stem_view."coverPercent@VegX.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';
|
|
| 7276 | 7276 |
|
| 7277 | 7277 |
|
| 7278 | 7278 |
-- |
| ... | ... | |
| 7353 | 7353 |
|
| 7354 | 7354 |
|
| 7355 | 7355 |
-- |
| 7356 |
-- Name: COLUMN analytical_stem_view."stemCode@stemlocation@VegBank@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7356 |
-- Name: COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7357 | 7357 |
-- |
| 7358 | 7358 |
|
| 7359 |
COMMENT ON COLUMN analytical_stem_view."stemCode@stemlocation@VegBank@vegpath.org" IS '"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."';
|
|
| 7359 |
COMMENT ON COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org" IS '"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."';
|
|
| 7360 | 7360 |
|
| 7361 | 7361 |
|
| 7362 | 7362 |
-- |
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: terms in normalized schemas: put the source name right next to the term name (instead of after the table name) so it's easy to find