Revision 13655
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 6845 | 6845 |
-- Name: COLUMN analytical_stem_view.datasource; Type: COMMENT; Schema: public; Owner: - |
| 6846 | 6846 |
-- |
| 6847 | 6847 |
|
| 6848 |
COMMENT ON COLUMN analytical_stem_view.datasource IS 'where this database got the data; the proximate data provider';
|
|
| 6848 |
COMMENT ON COLUMN analytical_stem_view.datasource IS 'variant of DwC term';
|
|
| 6849 | 6849 |
|
| 6850 | 6850 |
|
| 6851 | 6851 |
-- |
| ... | ... | |
| 6898 | 6898 |
|
| 6899 | 6899 |
|
| 6900 | 6900 |
-- |
| 6901 |
-- Name: COLUMN analytical_stem_view."coordinateSource_bien"; Type: COMMENT; Schema: public; Owner: - |
|
| 6902 |
-- |
|
| 6903 |
|
|
| 6904 |
COMMENT ON COLUMN analytical_stem_view."coordinateSource_bien" IS 'derived column'; |
|
| 6905 |
|
|
| 6906 |
|
|
| 6907 |
-- |
|
| 6908 |
-- Name: COLUMN analytical_stem_view."georeferenceProtocol_bien"; Type: COMMENT; Schema: public; Owner: - |
|
| 6909 |
-- |
|
| 6910 |
|
|
| 6911 |
COMMENT ON COLUMN analytical_stem_view."georeferenceProtocol_bien" IS 'derived column'; |
|
| 6912 |
|
|
| 6913 |
|
|
| 6914 |
-- |
|
| 6915 |
-- Name: COLUMN analytical_stem_view.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 6916 |
-- |
|
| 6917 |
|
|
| 6918 |
COMMENT ON COLUMN analytical_stem_view.geovalid_bien IS 'derived column'; |
|
| 6919 |
|
|
| 6920 |
|
|
| 6921 |
-- |
|
| 6922 |
-- Name: COLUMN analytical_stem_view."isNewWorld_bien"; Type: COMMENT; Schema: public; Owner: - |
|
| 6923 |
-- |
|
| 6924 |
|
|
| 6925 |
COMMENT ON COLUMN analytical_stem_view."isNewWorld_bien" IS 'derived column'; |
|
| 6926 |
|
|
| 6927 |
|
|
| 6928 |
-- |
|
| 6929 |
-- Name: COLUMN analytical_stem_view."projectID"; Type: COMMENT; Schema: public; Owner: - |
|
| 6930 |
-- |
|
| 6931 |
|
|
| 6932 |
COMMENT ON COLUMN analytical_stem_view."projectID" IS 'from VegX'; |
|
| 6933 |
|
|
| 6934 |
|
|
| 6935 |
-- |
|
| 6936 |
-- Name: COLUMN analytical_stem_view.project_contributors; Type: COMMENT; Schema: public; Owner: - |
|
| 6937 |
-- |
|
| 6938 |
|
|
| 6939 |
COMMENT ON COLUMN analytical_stem_view.project_contributors IS 'variant of VegBank term'; |
|
| 6940 |
|
|
| 6941 |
|
|
| 6942 |
-- |
|
| 6901 | 6943 |
-- Name: COLUMN analytical_stem_view."locationID"; Type: COMMENT; Schema: public; Owner: - |
| 6902 | 6944 |
-- |
| 6903 | 6945 |
|
| ... | ... | |
| 6912 | 6954 |
|
| 6913 | 6955 |
|
| 6914 | 6956 |
-- |
| 6957 |
-- Name: COLUMN analytical_stem_view.subplot; Type: COMMENT; Schema: public; Owner: - |
|
| 6958 |
-- |
|
| 6959 |
|
|
| 6960 |
COMMENT ON COLUMN analytical_stem_view.subplot IS 'from SALVIAS'; |
|
| 6961 |
|
|
| 6962 |
|
|
| 6963 |
-- |
|
| 6964 |
-- Name: COLUMN analytical_stem_view.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
|
| 6965 |
-- |
|
| 6966 |
|
|
| 6967 |
COMMENT ON COLUMN analytical_stem_view.location__cultivated__bien IS 'variant of DwC term'; |
|
| 6968 |
|
|
| 6969 |
|
|
| 6970 |
-- |
|
| 6971 |
-- Name: COLUMN analytical_stem_view.locationevent__pkey; Type: COMMENT; Schema: public; Owner: - |
|
| 6972 |
-- |
|
| 6973 |
|
|
| 6974 |
COMMENT ON COLUMN analytical_stem_view.locationevent__pkey IS 'VegBIEN-internal'; |
|
| 6975 |
|
|
| 6976 |
|
|
| 6977 |
-- |
|
| 6915 | 6978 |
-- Name: COLUMN analytical_stem_view."eventDate"; Type: COMMENT; Schema: public; Owner: - |
| 6916 | 6979 |
-- |
| 6917 | 6980 |
|
| ... | ... | |
| 6926 | 6989 |
|
| 6927 | 6990 |
|
| 6928 | 6991 |
-- |
| 6992 |
-- Name: COLUMN analytical_stem_view."slopeAspect"; Type: COMMENT; Schema: public; Owner: - |
|
| 6993 |
-- |
|
| 6994 |
|
|
| 6995 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect" IS 'from VegX'; |
|
| 6996 |
|
|
| 6997 |
|
|
| 6998 |
-- |
|
| 6999 |
-- Name: COLUMN analytical_stem_view."slopeGradient"; Type: COMMENT; Schema: public; Owner: - |
|
| 7000 |
-- |
|
| 7001 |
|
|
| 7002 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient" IS 'from VegX'; |
|
| 7003 |
|
|
| 7004 |
|
|
| 7005 |
-- |
|
| 7006 |
-- Name: COLUMN analytical_stem_view."plotArea_ha"; Type: COMMENT; Schema: public; Owner: - |
|
| 7007 |
-- |
|
| 7008 |
|
|
| 7009 |
COMMENT ON COLUMN analytical_stem_view."plotArea_ha" IS 'variant of VegX term'; |
|
| 7010 |
|
|
| 7011 |
|
|
| 7012 |
-- |
|
| 6929 | 7013 |
-- Name: COLUMN analytical_stem_view."samplingProtocol"; Type: COMMENT; Schema: public; Owner: - |
| 6930 | 7014 |
-- |
| 6931 | 7015 |
|
| ... | ... | |
| 6933 | 7017 |
|
| 6934 | 7018 |
|
| 6935 | 7019 |
-- |
| 7020 |
-- Name: COLUMN analytical_stem_view."temperature_C"; Type: COMMENT; Schema: public; Owner: - |
|
| 7021 |
-- |
|
| 7022 |
|
|
| 7023 |
COMMENT ON COLUMN analytical_stem_view."temperature_C" IS 'variant of VegX term'; |
|
| 7024 |
|
|
| 7025 |
|
|
| 7026 |
-- |
|
| 7027 |
-- Name: COLUMN analytical_stem_view.precipitation_m; Type: COMMENT; Schema: public; Owner: - |
|
| 7028 |
-- |
|
| 7029 |
|
|
| 7030 |
COMMENT ON COLUMN analytical_stem_view.precipitation_m IS 'variant of VegX term'; |
|
| 7031 |
|
|
| 7032 |
|
|
| 7033 |
-- |
|
| 7034 |
-- Name: COLUMN analytical_stem_view.stratum__name; Type: COMMENT; Schema: public; Owner: - |
|
| 7035 |
-- |
|
| 7036 |
|
|
| 7037 |
COMMENT ON COLUMN analytical_stem_view.stratum__name IS 'from VegX, renamed'; |
|
| 7038 |
|
|
| 7039 |
|
|
| 7040 |
-- |
|
| 7041 |
-- Name: COLUMN analytical_stem_view.communities; Type: COMMENT; Schema: public; Owner: - |
|
| 7042 |
-- |
|
| 7043 |
|
|
| 7044 |
COMMENT ON COLUMN analytical_stem_view.communities IS 'variant of VegX term'; |
|
| 7045 |
|
|
| 7046 |
|
|
| 7047 |
-- |
|
| 7048 |
-- Name: COLUMN analytical_stem_view.plot__collectors; Type: COMMENT; Schema: public; Owner: - |
|
| 7049 |
-- |
|
| 7050 |
|
|
| 7051 |
COMMENT ON COLUMN analytical_stem_view.plot__collectors IS 'variant of VegBank term'; |
|
| 7052 |
|
|
| 7053 |
|
|
| 7054 |
-- |
|
| 7055 |
-- Name: COLUMN analytical_stem_view."specimenHolderInstitutions"; Type: COMMENT; Schema: public; Owner: - |
|
| 7056 |
-- |
|
| 7057 |
|
|
| 7058 |
COMMENT ON COLUMN analytical_stem_view."specimenHolderInstitutions" IS 'from DwC, renamed'; |
|
| 7059 |
|
|
| 7060 |
|
|
| 7061 |
-- |
|
| 6936 | 7062 |
-- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: - |
| 6937 | 7063 |
-- |
| 6938 | 7064 |
|
| ... | ... | |
| 6940 | 7066 |
|
| 6941 | 7067 |
|
| 6942 | 7068 |
-- |
| 7069 |
-- Name: COLUMN analytical_stem_view."accessionNumber"; Type: COMMENT; Schema: public; Owner: - |
|
| 7070 |
-- |
|
| 7071 |
|
|
| 7072 |
COMMENT ON COLUMN analytical_stem_view."accessionNumber" IS 'variant of DwC term'; |
|
| 7073 |
|
|
| 7074 |
|
|
| 7075 |
-- |
|
| 6943 | 7076 |
-- Name: COLUMN analytical_stem_view."occurrenceID"; Type: COMMENT; Schema: public; Owner: - |
| 6944 | 7077 |
-- |
| 6945 | 7078 |
|
| ... | ... | |
| 7003 | 7136 |
|
| 7004 | 7137 |
|
| 7005 | 7138 |
-- |
| 7139 |
-- Name: COLUMN analytical_stem_view.family_matched; Type: COMMENT; Schema: public; Owner: - |
|
| 7140 |
-- |
|
| 7141 |
|
|
| 7142 |
COMMENT ON COLUMN analytical_stem_view.family_matched IS 'from TNRS, renamed'; |
|
| 7143 |
|
|
| 7144 |
|
|
| 7145 |
-- |
|
| 7146 |
-- Name: COLUMN analytical_stem_view."taxonName_matched"; Type: COMMENT; Schema: public; Owner: - |
|
| 7147 |
-- |
|
| 7148 |
|
|
| 7149 |
COMMENT ON COLUMN analytical_stem_view."taxonName_matched" IS 'from TNRS, renamed'; |
|
| 7150 |
|
|
| 7151 |
|
|
| 7152 |
-- |
|
| 7153 |
-- Name: COLUMN analytical_stem_view."scientificNameAuthorship_matched"; Type: COMMENT; Schema: public; Owner: - |
|
| 7154 |
-- |
|
| 7155 |
|
|
| 7156 |
COMMENT ON COLUMN analytical_stem_view."scientificNameAuthorship_matched" IS 'from TNRS, renamed'; |
|
| 7157 |
|
|
| 7158 |
|
|
| 7159 |
-- |
|
| 7160 |
-- Name: COLUMN analytical_stem_view."higherPlantGroup_bien"; Type: COMMENT; Schema: public; Owner: - |
|
| 7161 |
-- |
|
| 7162 |
|
|
| 7163 |
COMMENT ON COLUMN analytical_stem_view."higherPlantGroup_bien" IS 'derived column'; |
|
| 7164 |
|
|
| 7165 |
|
|
| 7166 |
-- |
|
| 7006 | 7167 |
-- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: - |
| 7007 | 7168 |
-- |
| 7008 | 7169 |
|
| ... | ... | |
| 7010 | 7171 |
|
| 7011 | 7172 |
|
| 7012 | 7173 |
-- |
| 7174 |
-- Name: COLUMN analytical_stem_view.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 7175 |
-- |
|
| 7176 |
|
|
| 7177 |
COMMENT ON COLUMN analytical_stem_view.scrubbed_family IS 'variant of TNRS term'; |
|
| 7178 |
|
|
| 7179 |
|
|
| 7180 |
-- |
|
| 7181 |
-- Name: COLUMN analytical_stem_view.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 7182 |
-- |
|
| 7183 |
|
|
| 7184 |
COMMENT ON COLUMN analytical_stem_view.scrubbed_genus IS 'variant of TNRS term'; |
|
| 7185 |
|
|
| 7186 |
|
|
| 7187 |
-- |
|
| 7188 |
-- Name: COLUMN analytical_stem_view.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: - |
|
| 7189 |
-- |
|
| 7190 |
|
|
| 7191 |
COMMENT ON COLUMN analytical_stem_view.scrubbed_specific_epithet IS 'variant of TNRS term'; |
|
| 7192 |
|
|
| 7193 |
|
|
| 7194 |
-- |
|
| 7195 |
-- Name: COLUMN analytical_stem_view.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: - |
|
| 7196 |
-- |
|
| 7197 |
|
|
| 7198 |
COMMENT ON COLUMN analytical_stem_view.scrubbed_species_binomial IS 'variant of TNRS term'; |
|
| 7199 |
|
|
| 7200 |
|
|
| 7201 |
-- |
|
| 7202 |
-- Name: COLUMN analytical_stem_view.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 7203 |
-- |
|
| 7204 |
|
|
| 7205 |
COMMENT ON COLUMN analytical_stem_view.scrubbed_taxon_name_no_author IS 'variant of TNRS term'; |
|
| 7206 |
|
|
| 7207 |
|
|
| 7208 |
-- |
|
| 7209 |
-- Name: COLUMN analytical_stem_view.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 7210 |
-- |
|
| 7211 |
|
|
| 7212 |
COMMENT ON COLUMN analytical_stem_view.scrubbed_author IS 'variant of TNRS term'; |
|
| 7213 |
|
|
| 7214 |
|
|
| 7215 |
-- |
|
| 7216 |
-- Name: COLUMN analytical_stem_view.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: - |
|
| 7217 |
-- |
|
| 7218 |
|
|
| 7219 |
COMMENT ON COLUMN analytical_stem_view.scrubbed_taxon_name_with_author IS 'variant of TNRS term'; |
|
| 7220 |
|
|
| 7221 |
|
|
| 7222 |
-- |
|
| 7223 |
-- Name: COLUMN analytical_stem_view.scrubbed_morphospecies_binomial; Type: COMMENT; Schema: public; Owner: - |
|
| 7224 |
-- |
|
| 7225 |
|
|
| 7226 |
COMMENT ON COLUMN analytical_stem_view.scrubbed_morphospecies_binomial IS 'derived column'; |
|
| 7227 |
|
|
| 7228 |
|
|
| 7229 |
-- |
|
| 7230 |
-- Name: COLUMN analytical_stem_view."growthForm"; Type: COMMENT; Schema: public; Owner: - |
|
| 7231 |
-- |
|
| 7232 |
|
|
| 7233 |
COMMENT ON COLUMN analytical_stem_view."growthForm" IS 'from SALVIAS, renamed'; |
|
| 7234 |
|
|
| 7235 |
|
|
| 7236 |
-- |
|
| 7013 | 7237 |
-- Name: COLUMN analytical_stem_view."reproductiveCondition"; Type: COMMENT; Schema: public; Owner: - |
| 7014 | 7238 |
-- |
| 7015 | 7239 |
|
| ... | ... | |
| 7017 | 7241 |
|
| 7018 | 7242 |
|
| 7019 | 7243 |
-- |
| 7244 |
-- Name: COLUMN analytical_stem_view.threatened_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 7245 |
-- |
|
| 7246 |
|
|
| 7247 |
COMMENT ON COLUMN analytical_stem_view.threatened_bien IS 'derived column'; |
|
| 7248 |
|
|
| 7249 |
|
|
| 7250 |
-- |
|
| 7251 |
-- Name: COLUMN analytical_stem_view.cultivated_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 7252 |
-- |
|
| 7253 |
|
|
| 7254 |
COMMENT ON COLUMN analytical_stem_view.cultivated_bien IS 'variant of DwC term'; |
|
| 7255 |
|
|
| 7256 |
|
|
| 7257 |
-- |
|
| 7258 |
-- Name: COLUMN analytical_stem_view."cultivatedBasis_bien"; Type: COMMENT; Schema: public; Owner: - |
|
| 7259 |
-- |
|
| 7260 |
|
|
| 7261 |
COMMENT ON COLUMN analytical_stem_view."cultivatedBasis_bien" IS 'derived column'; |
|
| 7262 |
|
|
| 7263 |
|
|
| 7264 |
-- |
|
| 7020 | 7265 |
-- Name: COLUMN analytical_stem_view."occurrenceRemarks"; Type: COMMENT; Schema: public; Owner: - |
| 7021 | 7266 |
-- |
| 7022 | 7267 |
|
| ... | ... | |
| 7024 | 7269 |
|
| 7025 | 7270 |
|
| 7026 | 7271 |
-- |
| 7272 |
-- Name: COLUMN analytical_stem_view."coverPercent"; Type: COMMENT; Schema: public; Owner: - |
|
| 7273 |
-- |
|
| 7274 |
|
|
| 7275 |
COMMENT ON COLUMN analytical_stem_view."coverPercent" IS 'from VegX'; |
|
| 7276 |
|
|
| 7277 |
|
|
| 7278 |
-- |
|
| 7279 |
-- Name: COLUMN analytical_stem_view."diameterBreastHeight_cm"; Type: COMMENT; Schema: public; Owner: - |
|
| 7280 |
-- |
|
| 7281 |
|
|
| 7282 |
COMMENT ON COLUMN analytical_stem_view."diameterBreastHeight_cm" IS 'from SALVIAS, renamed'; |
|
| 7283 |
|
|
| 7284 |
|
|
| 7285 |
-- |
|
| 7286 |
-- Name: COLUMN analytical_stem_view.height_m; Type: COMMENT; Schema: public; Owner: - |
|
| 7287 |
-- |
|
| 7288 |
|
|
| 7289 |
COMMENT ON COLUMN analytical_stem_view.height_m IS 'variant of VegX term'; |
|
| 7290 |
|
|
| 7291 |
|
|
| 7292 |
-- |
|
| 7293 |
-- Name: COLUMN analytical_stem_view.tag; Type: COMMENT; Schema: public; Owner: - |
|
| 7294 |
-- |
|
| 7295 |
|
|
| 7296 |
COMMENT ON COLUMN analytical_stem_view.tag IS 'from VegX, renamed'; |
|
| 7297 |
|
|
| 7298 |
|
|
| 7299 |
-- |
|
| 7300 |
-- Name: COLUMN analytical_stem_view."organismX_m"; Type: COMMENT; Schema: public; Owner: - |
|
| 7301 |
-- |
|
| 7302 |
|
|
| 7303 |
COMMENT ON COLUMN analytical_stem_view."organismX_m" IS 'variant of VegX term'; |
|
| 7304 |
|
|
| 7305 |
|
|
| 7306 |
-- |
|
| 7307 |
-- Name: COLUMN analytical_stem_view."organismY_m"; Type: COMMENT; Schema: public; Owner: - |
|
| 7308 |
-- |
|
| 7309 |
|
|
| 7310 |
COMMENT ON COLUMN analytical_stem_view."organismY_m" IS 'variant of VegX term'; |
|
| 7311 |
|
|
| 7312 |
|
|
| 7313 |
-- |
|
| 7314 |
-- Name: COLUMN analytical_stem_view."taxonOccurrenceID"; Type: COMMENT; Schema: public; Owner: - |
|
| 7315 |
-- |
|
| 7316 |
|
|
| 7317 |
COMMENT ON COLUMN analytical_stem_view."taxonOccurrenceID" IS 'from VegX, renamed'; |
|
| 7318 |
|
|
| 7319 |
|
|
| 7320 |
-- |
|
| 7321 |
-- Name: COLUMN analytical_stem_view."authorTaxonCode"; Type: COMMENT; Schema: public; Owner: - |
|
| 7322 |
-- |
|
| 7323 |
|
|
| 7324 |
COMMENT ON COLUMN analytical_stem_view."authorTaxonCode" IS 'variant of VegBank term'; |
|
| 7325 |
|
|
| 7326 |
|
|
| 7327 |
-- |
|
| 7328 |
-- Name: COLUMN analytical_stem_view."aggregateOrganismObservationID"; Type: COMMENT; Schema: public; Owner: - |
|
| 7329 |
-- |
|
| 7330 |
|
|
| 7331 |
COMMENT ON COLUMN analytical_stem_view."aggregateOrganismObservationID" IS 'from VegX, renamed'; |
|
| 7332 |
|
|
| 7333 |
|
|
| 7334 |
-- |
|
| 7335 |
-- Name: COLUMN analytical_stem_view."individualObservationID"; Type: COMMENT; Schema: public; Owner: - |
|
| 7336 |
-- |
|
| 7337 |
|
|
| 7338 |
COMMENT ON COLUMN analytical_stem_view."individualObservationID" IS 'from VegX, renamed'; |
|
| 7339 |
|
|
| 7340 |
|
|
| 7341 |
-- |
|
| 7342 |
-- Name: COLUMN analytical_stem_view."individualCode"; Type: COMMENT; Schema: public; Owner: - |
|
| 7343 |
-- |
|
| 7344 |
|
|
| 7345 |
COMMENT ON COLUMN analytical_stem_view."individualCode" IS 'from SALVIAS, renamed'; |
|
| 7346 |
|
|
| 7347 |
|
|
| 7348 |
-- |
|
| 7349 |
-- Name: COLUMN analytical_stem_view."individualCount"; Type: COMMENT; Schema: public; Owner: - |
|
| 7350 |
-- |
|
| 7351 |
|
|
| 7352 |
COMMENT ON COLUMN analytical_stem_view."individualCount" IS 'from DwC'; |
|
| 7353 |
|
|
| 7354 |
|
|
| 7355 |
-- |
|
| 7356 |
-- Name: COLUMN analytical_stem_view."authorStemCode"; Type: COMMENT; Schema: public; Owner: - |
|
| 7357 |
-- |
|
| 7358 |
|
|
| 7359 |
COMMENT ON COLUMN analytical_stem_view."authorStemCode" IS 'from VegBank, renamed'; |
|
| 7360 |
|
|
| 7361 |
|
|
| 7362 |
-- |
|
| 7027 | 7363 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 7028 | 7364 |
-- |
| 7029 | 7365 |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: indicated provenance of the rest of the terms