Project

General

Profile

« Previous | Next » 

Revision 1064

vegbien.sql: Moved locationevent method fields to plotmethod and method. Added comments to method/plotmethod fields, as provided by Michael Lee.

View differences:

vegbien.sql
853 853
    previous_id integer,
854 854
    dateaccuracy text,
855 855
    plotmethod_id integer,
856
    methodnarrative text,
857
    taxonoccurrencearea double precision,
858
    coverdispersion text,
859 856
    autotaxoncover boolean,
860
    stemsizelimit double precision,
861
    stemarea double precision,
862
    stemsamplemethod text,
863 857
    originaldata text,
864 858
    effortlevel text,
865
    locationvalidationlevel integer,
866 859
    floristicquality text,
867 860
    bryophytequality text,
868 861
    lichenquality text,
......
1041 1034
    observationmeasureunits text,
1042 1035
    taxonclassincluded text,
1043 1036
    taxonclassexcluded text,
1044
    covermethod_id integer
1037
    covermethod_id integer,
1038
    samplingfactor double precision DEFAULT 1 NOT NULL,
1039
    coverbasis text,
1040
    stemsamplemethod text
1045 1041
);
1046 1042

  
1047 1043

  
......
1053 1049

  
1054 1050

  
1055 1051
--
1052
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
1053
--
1054

  
1055
COMMENT ON COLUMN method.name IS 'A short name for the set of methods used. Although there is no existing standard, many names are widely used, and could be useful for finding plots with similar methodology.';
1056

  
1057

  
1058
--
1059
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
1060
--
1061

  
1062
COMMENT ON COLUMN method.description IS 'Additional metadata helpful for understanding how the data were collected during the observation event.';
1063

  
1064

  
1065
--
1056 1066
-- Name: COLUMN method.lengthunits; Type: COMMENT; Schema: public; Owner: -
1057 1067
--
1058 1068

  
1059
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. ha -> m^2.**';
1069
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.**';
1060 1070

  
1061 1071

  
1062 1072
--
1073
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: -
1074
--
1075

  
1076
COMMENT ON COLUMN method.mindiameter IS 'Lower diameter limit in lengthunits for inclusion of a tree.';
1077

  
1078

  
1079
--
1080
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: -
1081
--
1082

  
1083
COMMENT ON COLUMN method.minheight IS 'Lower height limit in lengthunits for inclusion of a tree.';
1084

  
1085

  
1086
--
1087
-- Name: COLUMN method.maxdiameter; Type: COMMENT; Schema: public; Owner: -
1088
--
1089

  
1090
COMMENT ON COLUMN method.maxdiameter IS 'Upper diameter limit in lengthunits for inclusion of a tree.';
1091

  
1092

  
1093
--
1094
-- Name: COLUMN method.maxheight; Type: COMMENT; Schema: public; Owner: -
1095
--
1096

  
1097
COMMENT ON COLUMN method.maxheight IS 'Upper height limit in lengthunits for inclusion of a tree.';
1098

  
1099

  
1100
--
1063 1101
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
1064 1102
--
1065 1103

  
......
1084 1122
-- Name: COLUMN method.taxonclassincluded; Type: COMMENT; Schema: public; Owner: -
1085 1123
--
1086 1124

  
1087
COMMENT ON COLUMN method.taxonclassincluded IS 'e.g. tree, shrub, liana, vine, herb, hemiepiphyte, epiphyte, grass, forb';
1125
COMMENT ON COLUMN method.taxonclassincluded IS 'e.g. tree, shrub, liana, vine, herb, hemiepiphyte, epiphyte, grass, forb, woody, non-woody, cultivated, non-cultivated (not planted), exotic, native, dominant, non-dominant, vascular, nonvascular';
1088 1126

  
1089 1127

  
1090 1128
--
1091 1129
-- Name: COLUMN method.taxonclassexcluded; Type: COMMENT; Schema: public; Owner: -
1092 1130
--
1093 1131

  
1094
COMMENT ON COLUMN method.taxonclassexcluded IS 'e.g. tree, shrub, liana, vine, herb, hemiepiphyte, epiphyte, grass, forb';
1132
COMMENT ON COLUMN method.taxonclassexcluded IS 'e.g. tree, shrub, liana, vine, herb, hemiepiphyte, epiphyte, grass, forb, woody, non-woody, cultivated, non-cultivated (not planted), exotic, native, dominant, non-dominant, vascular, nonvascular';
1095 1133

  
1096 1134

  
1097 1135
--
1136
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
1137
--
1138

  
1139
COMMENT ON COLUMN method.samplingfactor IS 'Here, we could explicitly say that we are sampling a particular area by a different size representative sample area. Simply divide the number of plants connected to this record by this value to get the extrapolated (or interpolated) number of plants in the area in question. This explicitly notes a subsample or supersample.';
1140

  
1141

  
1142
--
1143
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
1144
--
1145

  
1146
COMMENT ON COLUMN method.coverbasis IS 'Were cover values for the total taxon list collected from one contiguous area or dispersed subplots?
1147

  
1148
entire: Cover based on observation of an entire plot consisting of a single contiguous area of land. subplot-contiguous: Cover based on observation of a single contiguous area of land of less spatial extent than the entire plot.
1149

  
1150
subplot-regular: Cover based on observation of multiple subplots arranged in a regular pattern within the overall plot.
1151

  
1152
subplot-random: Cover based on observation of multiple randomly dispersed subplots within the overall plot.
1153

  
1154
subplot-haphazard: Cover based on observation of multiple subplots haphazardly arranged within the overall plot.
1155

  
1156
line-intercept: Cover based on length of line touching each species present.
1157

  
1158
point-intercept: Cover based on number of points for each species present.
1159
';
1160

  
1161

  
1162
--
1163
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
1164
--
1165

  
1166
COMMENT ON COLUMN method.stemsamplemethod IS 'The method used to obtain basal area or tree stem data (e.g., full census, point quarter, random pairs, Bitterlich, other).
1167

  
1168
e.g.:
1169
Full census
1170
Point quarter
1171
Random pairs
1172
Bitterlich
1173
Other
1174
Subsample census';
1175

  
1176

  
1177
--
1098 1178
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1099 1179
--
1100 1180

  
......
1658 1738
    length double precision,
1659 1739
    width double precision,
1660 1740
    radius double precision,
1661
    area double precision
1741
    area double precision,
1742
    samplearea double precision
1662 1743
);
1663 1744

  
1664 1745

  
......
1673 1754
-- Name: COLUMN plotmethod.name; Type: COMMENT; Schema: public; Owner: -
1674 1755
--
1675 1756

  
1676
COMMENT ON COLUMN plotmethod.name IS 'e.g. "1 ha treeplot". "0.1 ha transect", "line-intercept plot", "point centered quarter"';
1757
COMMENT ON COLUMN plotmethod.name IS 'A short name for the set of methods used for the plot. Although there is no existing standard, many names are widely used, and could be useful for finding plots with similar methodology.
1677 1758

  
1759
e.g. "1 ha treeplot", "0.1 ha transect", "line-intercept plot", "point centered quarter"';
1678 1760

  
1761

  
1679 1762
--
1763
-- Name: COLUMN plotmethod.description; Type: COMMENT; Schema: public; Owner: -
1764
--
1765

  
1766
COMMENT ON COLUMN plotmethod.description IS 'Additional metadata helpful for understanding how the data were collected during the observation event.';
1767

  
1768

  
1769
--
1680 1770
-- Name: COLUMN plotmethod.shape; Type: COMMENT; Schema: public; Owner: -
1681 1771
--
1682 1772

  
......
1684 1774

  
1685 1775

  
1686 1776
--
1777
-- Name: COLUMN plotmethod.length; Type: COMMENT; Schema: public; Owner: -
1778
--
1779

  
1780
COMMENT ON COLUMN plotmethod.length IS 'Units: lengthunits';
1781

  
1782

  
1783
--
1784
-- Name: COLUMN plotmethod.width; Type: COMMENT; Schema: public; Owner: -
1785
--
1786

  
1787
COMMENT ON COLUMN plotmethod.width IS 'Units: lengthunits';
1788

  
1789

  
1790
--
1791
-- Name: COLUMN plotmethod.radius; Type: COMMENT; Schema: public; Owner: -
1792
--
1793

  
1794
COMMENT ON COLUMN plotmethod.radius IS 'Units: lengthunits';
1795

  
1796

  
1797
--
1798
-- Name: COLUMN plotmethod.area; Type: COMMENT; Schema: public; Owner: -
1799
--
1800

  
1801
COMMENT ON COLUMN plotmethod.area IS 'Units: lengthunits^2';
1802

  
1803

  
1804
--
1805
-- Name: COLUMN plotmethod.samplearea; Type: COMMENT; Schema: public; Owner: -
1806
--
1807

  
1808
COMMENT ON COLUMN plotmethod.samplearea IS 'The total surface area used for cover estimates and for which a complete species list is provided. If subplots were used, this would be the total area of the subplots without interstitial space.
1809

  
1810
Units: lengthunits^2';
1811

  
1812

  
1813
--
1687 1814
-- Name: plotmethod_plotmethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1688 1815
--
1689 1816

  

Also available in: Unified diff