Revision 13690
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 6746 | 6746 |
"plot.**"."georeferenceProtocol_bien", |
| 6747 | 6747 |
"plot.**".geovalid_bien, |
| 6748 | 6748 |
"plot.**"."isNewWorld_bien", |
| 6749 |
"plot.**"."projectID" AS "projectID@VegX@vegpath.org", |
|
| 6749 |
"plot.**"."projectID" AS "projectID@plotObservation@VegX@vegpath.org",
|
|
| 6750 | 6750 |
"plot.**".project_contributors, |
| 6751 | 6751 |
"plot.**"."locationID" AS "locationID@DwC@vegpath.org", |
| 6752 |
"plot.**"."locationName" AS "plotName@VegX@vegpath.org", |
|
| 6752 |
"plot.**"."locationName" AS "plotName@plot@VegX@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@VegX@vegpath.org", |
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient@VegX@vegpath.org", |
|
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect@plot@VegX@vegpath.org",
|
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient@plot@VegX@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@VegX@vegpath.org", |
|
| 6802 |
_fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent@attribute.ordinal@VegX@vegpath.org",
|
|
| 6803 | 6803 |
_m_to_cm(stemobservation.diameterbreastheight_m) AS "diameterBreastHeight_cm", |
| 6804 | 6804 |
stemobservation.height_m, |
| 6805 | 6805 |
stemobservation.tag, |
| ... | ... | |
| 6926 | 6926 |
|
| 6927 | 6927 |
|
| 6928 | 6928 |
-- |
| 6929 |
-- Name: COLUMN analytical_stem_view."projectID@VegX@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 6929 |
-- Name: COLUMN analytical_stem_view."projectID@plotObservation@VegX@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6930 | 6930 |
-- |
| 6931 | 6931 |
|
| 6932 |
COMMENT ON COLUMN analytical_stem_view."projectID@VegX@vegpath.org" IS '"A reference to a specific ''project''"'; |
|
| 6932 |
COMMENT ON COLUMN analytical_stem_view."projectID@plotObservation@VegX@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: - |
|
| 6951 |
-- |
|
| 6952 |
|
|
| 6953 |
COMMENT ON COLUMN analytical_stem_view."plotName@plot@VegX@vegpath.org" IS '"Name or label for a plot"'; |
|
| 6954 |
|
|
| 6955 |
|
|
| 6956 |
-- |
|
| 6950 | 6957 |
-- Name: COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 6951 | 6958 |
-- |
| 6952 | 6959 |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: VegX terms: referenced to the specific table/subpath that they are in