| 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 |
|
vegbien.sql: Moved locationevent method fields to plotmethod and method. Added comments to method/plotmethod fields, as provided by Michael Lee.