Revision 1112
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 930 | 930 |
description text, |
| 931 | 931 |
accessioncode text, |
| 932 | 932 |
lengthunits text, |
| 933 |
diameterheight double precision, |
|
| 933 | 934 |
mindiameter double precision, |
| 935 |
maxdiameter double precision, |
|
| 934 | 936 |
minheight double precision, |
| 935 |
maxdiameter double precision, |
|
| 936 | 937 |
maxheight double precision, |
| 937 | 938 |
observationtype text, |
| 938 | 939 |
observationmeasure text, |
| ... | ... | |
| 986 | 987 |
|
| 987 | 988 |
|
| 988 | 989 |
-- |
| 989 |
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: -
|
|
| 990 |
-- Name: COLUMN method.diameterheight; Type: COMMENT; Schema: public; Owner: -
|
|
| 990 | 991 |
-- |
| 991 | 992 |
|
| 992 | 993 |
|
| 993 | 994 |
|
| 994 | 995 |
|
| 995 | 996 |
-- |
| 996 |
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: -
|
|
| 997 |
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: -
|
|
| 997 | 998 |
-- |
| 998 | 999 |
|
| 999 | 1000 |
|
| ... | ... | |
| 1007 | 1008 |
|
| 1008 | 1009 |
|
| 1009 | 1010 |
-- |
| 1011 |
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: - |
|
| 1012 |
-- |
|
| 1013 |
|
|
| 1014 |
|
|
| 1015 |
|
|
| 1016 |
|
|
| 1017 |
-- |
|
| 1010 | 1018 |
-- Name: COLUMN method.maxheight; Type: COMMENT; Schema: public; Owner: - |
| 1011 | 1019 |
-- |
| 1012 | 1020 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1094 | 1094 |
description text, |
| 1095 | 1095 |
accessioncode text, |
| 1096 | 1096 |
lengthunits text, |
| 1097 |
diameterheight double precision, |
|
| 1097 | 1098 |
mindiameter double precision, |
| 1099 |
maxdiameter double precision, |
|
| 1098 | 1100 |
minheight double precision, |
| 1099 |
maxdiameter double precision, |
|
| 1100 | 1101 |
maxheight double precision, |
| 1101 | 1102 |
observationtype text, |
| 1102 | 1103 |
observationmeasure text, |
| ... | ... | |
| 1150 | 1151 |
|
| 1151 | 1152 |
|
| 1152 | 1153 |
-- |
| 1153 |
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: -
|
|
| 1154 |
-- Name: COLUMN method.diameterheight; Type: COMMENT; Schema: public; Owner: -
|
|
| 1154 | 1155 |
-- |
| 1155 | 1156 |
|
| 1156 |
COMMENT ON COLUMN method.mindiameter IS 'Lower diameter limit in lengthunits for inclusion of a tree.';
|
|
| 1157 |
COMMENT ON COLUMN method.diameterheight IS 'The height in lengthunits at which the diameter is measured. e.g. 1.37 m for breast height (DBH).';
|
|
| 1157 | 1158 |
|
| 1158 | 1159 |
|
| 1159 | 1160 |
-- |
| 1160 |
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: -
|
|
| 1161 |
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: -
|
|
| 1161 | 1162 |
-- |
| 1162 | 1163 |
|
| 1163 |
COMMENT ON COLUMN method.minheight IS 'Lower height limit in lengthunits for inclusion of a tree.';
|
|
| 1164 |
COMMENT ON COLUMN method.mindiameter IS 'Lower diameter limit in lengthunits for inclusion of a tree.';
|
|
| 1164 | 1165 |
|
| 1165 | 1166 |
|
| 1166 | 1167 |
-- |
| ... | ... | |
| 1171 | 1172 |
|
| 1172 | 1173 |
|
| 1173 | 1174 |
-- |
| 1175 |
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: - |
|
| 1176 |
-- |
|
| 1177 |
|
|
| 1178 |
COMMENT ON COLUMN method.minheight IS 'Lower height limit in lengthunits for inclusion of a tree.'; |
|
| 1179 |
|
|
| 1180 |
|
|
| 1181 |
-- |
|
| 1174 | 1182 |
-- Name: COLUMN method.maxheight; Type: COMMENT; Schema: public; Owner: - |
| 1175 | 1183 |
-- |
| 1176 | 1184 |
|
Also available in: Unified diff
vegbien.sql: Added method.diameterheight to store DBH height