Project

General

Profile

« Previous | Next » 

Revision 1112

vegbien.sql: Added method.diameterheight to store DBH height

View differences:

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