Revision 1161
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 1049 | 1049 |
name text NOT NULL, |
| 1050 | 1050 |
description text, |
| 1051 | 1051 |
accessioncode text, |
| 1052 |
lengthunits text, |
|
| 1053 | 1052 |
diameterheight double precision, |
| 1054 | 1053 |
mindiameter double precision, |
| 1055 | 1054 |
maxdiameter double precision, |
| ... | ... | |
| 1057 | 1056 |
maxheight double precision, |
| 1058 | 1057 |
observationtype text, |
| 1059 | 1058 |
observationmeasure text, |
| 1060 |
observationmeasureunits text, |
|
| 1061 | 1059 |
covermethod_id integer, |
| 1062 | 1060 |
samplingfactor double precision DEFAULT 1 NOT NULL, |
| 1063 | 1061 |
coverbasis text, |
| ... | ... | |
| 1075 | 1073 |
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: - |
| 1076 | 1074 |
-- |
| 1077 | 1075 |
|
| 1078 |
COMMENT ON TABLE method IS 'A method for sampling and aggregating plants. Replaces VegBank''s stratummethod and stratumtype tables.';
|
|
| 1076 |
COMMENT ON TABLE method IS 'A method for sampling and aggregating plants. Replaces VegBank''s stratummethod and stratumtype tables. |
|
| 1079 | 1077 |
|
| 1078 |
Important: *All* length- or area-related measurements throughout VegBIEN must be converted to SI base units, e.g. cm -> m, ha -> m^2.**'; |
|
| 1080 | 1079 |
|
| 1080 |
|
|
| 1081 | 1081 |
-- |
| 1082 | 1082 |
-- Name: COLUMN method.reference_id; Type: COMMENT; Schema: public; Owner: - |
| 1083 | 1083 |
-- |
| ... | ... | |
| 1100 | 1100 |
|
| 1101 | 1101 |
|
| 1102 | 1102 |
-- |
| 1103 |
-- Name: COLUMN method.lengthunits; Type: COMMENT; Schema: public; Owner: - |
|
| 1104 |
-- |
|
| 1105 |
|
|
| 1106 |
COMMENT ON COLUMN method.lengthunits IS 'Units for *all* length- or area-related measurements, e.g. m. **Any measurements not in these units must be converted, e.g. cm -> m, ha -> m^2.**'; |
|
| 1107 |
|
|
| 1108 |
|
|
| 1109 |
-- |
|
| 1110 | 1103 |
-- Name: COLUMN method.diameterheight; Type: COMMENT; Schema: public; Owner: - |
| 1111 | 1104 |
-- |
| 1112 | 1105 |
|
| ... | ... | |
| 1156 | 1149 |
|
| 1157 | 1150 |
|
| 1158 | 1151 |
-- |
| 1159 |
-- Name: COLUMN method.observationmeasureunits; Type: COMMENT; Schema: public; Owner: - |
|
| 1160 |
-- |
|
| 1161 |
|
|
| 1162 |
COMMENT ON COLUMN method.observationmeasureunits IS 'e.g. percent, individual, cm, m'; |
|
| 1163 |
|
|
| 1164 |
|
|
| 1165 |
-- |
|
| 1166 | 1152 |
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: - |
| 1167 | 1153 |
-- |
| 1168 | 1154 |
|
Also available in: Unified diff
vegbien.sql: method: Removed lengthunits and instead require all length- or area-related measurements throughout VegBIEN to be converted to SI base units, e.g. cm -> m, ha -> m^2. Adjusted ERD to avoid some densely packed lines.