Revision 13655
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 4250 | 4250 |
|
| 4251 | 4251 |
|
| 4252 | 4252 |
-- |
| 4253 |
-- Name: COLUMN analytical_stem_view.`coordinateSource_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4254 |
-- |
|
| 4255 |
|
|
| 4256 |
|
|
| 4257 |
|
|
| 4258 |
|
|
| 4259 |
-- |
|
| 4260 |
-- Name: COLUMN analytical_stem_view.`georeferenceProtocol_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4261 |
-- |
|
| 4262 |
|
|
| 4263 |
|
|
| 4264 |
|
|
| 4265 |
|
|
| 4266 |
-- |
|
| 4267 |
-- Name: COLUMN analytical_stem_view.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4268 |
-- |
|
| 4269 |
|
|
| 4270 |
|
|
| 4271 |
|
|
| 4272 |
|
|
| 4273 |
-- |
|
| 4274 |
-- Name: COLUMN analytical_stem_view.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4275 |
-- |
|
| 4276 |
|
|
| 4277 |
|
|
| 4278 |
|
|
| 4279 |
|
|
| 4280 |
-- |
|
| 4281 |
-- Name: COLUMN analytical_stem_view.`projectID`; Type: COMMENT; Schema: public; Owner: - |
|
| 4282 |
-- |
|
| 4283 |
|
|
| 4284 |
|
|
| 4285 |
|
|
| 4286 |
|
|
| 4287 |
-- |
|
| 4288 |
-- Name: COLUMN analytical_stem_view.project_contributors; Type: COMMENT; Schema: public; Owner: - |
|
| 4289 |
-- |
|
| 4290 |
|
|
| 4291 |
|
|
| 4292 |
|
|
| 4293 |
|
|
| 4294 |
-- |
|
| 4253 | 4295 |
-- Name: COLUMN analytical_stem_view.`locationID`; Type: COMMENT; Schema: public; Owner: - |
| 4254 | 4296 |
-- |
| 4255 | 4297 |
|
| ... | ... | |
| 4264 | 4306 |
|
| 4265 | 4307 |
|
| 4266 | 4308 |
-- |
| 4309 |
-- Name: COLUMN analytical_stem_view.subplot; Type: COMMENT; Schema: public; Owner: - |
|
| 4310 |
-- |
|
| 4311 |
|
|
| 4312 |
|
|
| 4313 |
|
|
| 4314 |
|
|
| 4315 |
-- |
|
| 4316 |
-- Name: COLUMN analytical_stem_view.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4317 |
-- |
|
| 4318 |
|
|
| 4319 |
|
|
| 4320 |
|
|
| 4321 |
|
|
| 4322 |
-- |
|
| 4323 |
-- Name: COLUMN analytical_stem_view.locationevent__pkey; Type: COMMENT; Schema: public; Owner: - |
|
| 4324 |
-- |
|
| 4325 |
|
|
| 4326 |
|
|
| 4327 |
|
|
| 4328 |
|
|
| 4329 |
-- |
|
| 4267 | 4330 |
-- Name: COLUMN analytical_stem_view.`eventDate`; Type: COMMENT; Schema: public; Owner: - |
| 4268 | 4331 |
-- |
| 4269 | 4332 |
|
| ... | ... | |
| 4278 | 4341 |
|
| 4279 | 4342 |
|
| 4280 | 4343 |
-- |
| 4344 |
-- Name: COLUMN analytical_stem_view.`slopeAspect`; Type: COMMENT; Schema: public; Owner: - |
|
| 4345 |
-- |
|
| 4346 |
|
|
| 4347 |
|
|
| 4348 |
|
|
| 4349 |
|
|
| 4350 |
-- |
|
| 4351 |
-- Name: COLUMN analytical_stem_view.`slopeGradient`; Type: COMMENT; Schema: public; Owner: - |
|
| 4352 |
-- |
|
| 4353 |
|
|
| 4354 |
|
|
| 4355 |
|
|
| 4356 |
|
|
| 4357 |
-- |
|
| 4358 |
-- Name: COLUMN analytical_stem_view.`plotArea_ha`; Type: COMMENT; Schema: public; Owner: - |
|
| 4359 |
-- |
|
| 4360 |
|
|
| 4361 |
|
|
| 4362 |
|
|
| 4363 |
|
|
| 4364 |
-- |
|
| 4281 | 4365 |
-- Name: COLUMN analytical_stem_view.`samplingProtocol`; Type: COMMENT; Schema: public; Owner: - |
| 4282 | 4366 |
-- |
| 4283 | 4367 |
|
| ... | ... | |
| 4285 | 4369 |
|
| 4286 | 4370 |
|
| 4287 | 4371 |
-- |
| 4372 |
-- Name: COLUMN analytical_stem_view.`temperature_C`; Type: COMMENT; Schema: public; Owner: - |
|
| 4373 |
-- |
|
| 4374 |
|
|
| 4375 |
|
|
| 4376 |
|
|
| 4377 |
|
|
| 4378 |
-- |
|
| 4379 |
-- Name: COLUMN analytical_stem_view.precipitation_m; Type: COMMENT; Schema: public; Owner: - |
|
| 4380 |
-- |
|
| 4381 |
|
|
| 4382 |
|
|
| 4383 |
|
|
| 4384 |
|
|
| 4385 |
-- |
|
| 4386 |
-- Name: COLUMN analytical_stem_view.stratum__name; Type: COMMENT; Schema: public; Owner: - |
|
| 4387 |
-- |
|
| 4388 |
|
|
| 4389 |
|
|
| 4390 |
|
|
| 4391 |
|
|
| 4392 |
-- |
|
| 4393 |
-- Name: COLUMN analytical_stem_view.communities; Type: COMMENT; Schema: public; Owner: - |
|
| 4394 |
-- |
|
| 4395 |
|
|
| 4396 |
|
|
| 4397 |
|
|
| 4398 |
|
|
| 4399 |
-- |
|
| 4400 |
-- Name: COLUMN analytical_stem_view.plot__collectors; Type: COMMENT; Schema: public; Owner: - |
|
| 4401 |
-- |
|
| 4402 |
|
|
| 4403 |
|
|
| 4404 |
|
|
| 4405 |
|
|
| 4406 |
-- |
|
| 4407 |
-- Name: COLUMN analytical_stem_view.`specimenHolderInstitutions`; Type: COMMENT; Schema: public; Owner: - |
|
| 4408 |
-- |
|
| 4409 |
|
|
| 4410 |
|
|
| 4411 |
|
|
| 4412 |
|
|
| 4413 |
-- |
|
| 4288 | 4414 |
-- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: - |
| 4289 | 4415 |
-- |
| 4290 | 4416 |
|
| ... | ... | |
| 4292 | 4418 |
|
| 4293 | 4419 |
|
| 4294 | 4420 |
-- |
| 4421 |
-- Name: COLUMN analytical_stem_view.`accessionNumber`; Type: COMMENT; Schema: public; Owner: - |
|
| 4422 |
-- |
|
| 4423 |
|
|
| 4424 |
|
|
| 4425 |
|
|
| 4426 |
|
|
| 4427 |
-- |
|
| 4295 | 4428 |
-- Name: COLUMN analytical_stem_view.`occurrenceID`; Type: COMMENT; Schema: public; Owner: - |
| 4296 | 4429 |
-- |
| 4297 | 4430 |
|
| ... | ... | |
| 4355 | 4488 |
|
| 4356 | 4489 |
|
| 4357 | 4490 |
-- |
| 4491 |
-- Name: COLUMN analytical_stem_view.family_matched; Type: COMMENT; Schema: public; Owner: - |
|
| 4492 |
-- |
|
| 4493 |
|
|
| 4494 |
|
|
| 4495 |
|
|
| 4496 |
|
|
| 4497 |
-- |
|
| 4498 |
-- Name: COLUMN analytical_stem_view.`taxonName_matched`; Type: COMMENT; Schema: public; Owner: - |
|
| 4499 |
-- |
|
| 4500 |
|
|
| 4501 |
|
|
| 4502 |
|
|
| 4503 |
|
|
| 4504 |
-- |
|
| 4505 |
-- Name: COLUMN analytical_stem_view.`scientificNameAuthorship_matched`; Type: COMMENT; Schema: public; Owner: - |
|
| 4506 |
-- |
|
| 4507 |
|
|
| 4508 |
|
|
| 4509 |
|
|
| 4510 |
|
|
| 4511 |
-- |
|
| 4512 |
-- Name: COLUMN analytical_stem_view.`higherPlantGroup_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4513 |
-- |
|
| 4514 |
|
|
| 4515 |
|
|
| 4516 |
|
|
| 4517 |
|
|
| 4518 |
-- |
|
| 4358 | 4519 |
-- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: - |
| 4359 | 4520 |
-- |
| 4360 | 4521 |
|
| ... | ... | |
| 4362 | 4523 |
|
| 4363 | 4524 |
|
| 4364 | 4525 |
-- |
| 4526 |
-- Name: COLUMN analytical_stem_view.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 4527 |
-- |
|
| 4528 |
|
|
| 4529 |
|
|
| 4530 |
|
|
| 4531 |
|
|
| 4532 |
-- |
|
| 4533 |
-- Name: COLUMN analytical_stem_view.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 4534 |
-- |
|
| 4535 |
|
|
| 4536 |
|
|
| 4537 |
|
|
| 4538 |
|
|
| 4539 |
-- |
|
| 4540 |
-- Name: COLUMN analytical_stem_view.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: - |
|
| 4541 |
-- |
|
| 4542 |
|
|
| 4543 |
|
|
| 4544 |
|
|
| 4545 |
|
|
| 4546 |
-- |
|
| 4547 |
-- Name: COLUMN analytical_stem_view.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: - |
|
| 4548 |
-- |
|
| 4549 |
|
|
| 4550 |
|
|
| 4551 |
|
|
| 4552 |
|
|
| 4553 |
-- |
|
| 4554 |
-- Name: COLUMN analytical_stem_view.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4555 |
-- |
|
| 4556 |
|
|
| 4557 |
|
|
| 4558 |
|
|
| 4559 |
|
|
| 4560 |
-- |
|
| 4561 |
-- Name: COLUMN analytical_stem_view.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4562 |
-- |
|
| 4563 |
|
|
| 4564 |
|
|
| 4565 |
|
|
| 4566 |
|
|
| 4567 |
-- |
|
| 4568 |
-- Name: COLUMN analytical_stem_view.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4569 |
-- |
|
| 4570 |
|
|
| 4571 |
|
|
| 4572 |
|
|
| 4573 |
|
|
| 4574 |
-- |
|
| 4575 |
-- Name: COLUMN analytical_stem_view.scrubbed_morphospecies_binomial; Type: COMMENT; Schema: public; Owner: - |
|
| 4576 |
-- |
|
| 4577 |
|
|
| 4578 |
|
|
| 4579 |
|
|
| 4580 |
|
|
| 4581 |
-- |
|
| 4582 |
-- Name: COLUMN analytical_stem_view.`growthForm`; Type: COMMENT; Schema: public; Owner: - |
|
| 4583 |
-- |
|
| 4584 |
|
|
| 4585 |
|
|
| 4586 |
|
|
| 4587 |
|
|
| 4588 |
-- |
|
| 4365 | 4589 |
-- Name: COLUMN analytical_stem_view.`reproductiveCondition`; Type: COMMENT; Schema: public; Owner: - |
| 4366 | 4590 |
-- |
| 4367 | 4591 |
|
| ... | ... | |
| 4369 | 4593 |
|
| 4370 | 4594 |
|
| 4371 | 4595 |
-- |
| 4596 |
-- Name: COLUMN analytical_stem_view.threatened_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4597 |
-- |
|
| 4598 |
|
|
| 4599 |
|
|
| 4600 |
|
|
| 4601 |
|
|
| 4602 |
-- |
|
| 4603 |
-- Name: COLUMN analytical_stem_view.cultivated_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4604 |
-- |
|
| 4605 |
|
|
| 4606 |
|
|
| 4607 |
|
|
| 4608 |
|
|
| 4609 |
-- |
|
| 4610 |
-- Name: COLUMN analytical_stem_view.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4611 |
-- |
|
| 4612 |
|
|
| 4613 |
|
|
| 4614 |
|
|
| 4615 |
|
|
| 4616 |
-- |
|
| 4372 | 4617 |
-- Name: COLUMN analytical_stem_view.`occurrenceRemarks`; Type: COMMENT; Schema: public; Owner: - |
| 4373 | 4618 |
-- |
| 4374 | 4619 |
|
| ... | ... | |
| 4376 | 4621 |
|
| 4377 | 4622 |
|
| 4378 | 4623 |
-- |
| 4624 |
-- Name: COLUMN analytical_stem_view.`coverPercent`; Type: COMMENT; Schema: public; Owner: - |
|
| 4625 |
-- |
|
| 4626 |
|
|
| 4627 |
|
|
| 4628 |
|
|
| 4629 |
|
|
| 4630 |
-- |
|
| 4631 |
-- Name: COLUMN analytical_stem_view.`diameterBreastHeight_cm`; Type: COMMENT; Schema: public; Owner: - |
|
| 4632 |
-- |
|
| 4633 |
|
|
| 4634 |
|
|
| 4635 |
|
|
| 4636 |
|
|
| 4637 |
-- |
|
| 4638 |
-- Name: COLUMN analytical_stem_view.height_m; Type: COMMENT; Schema: public; Owner: - |
|
| 4639 |
-- |
|
| 4640 |
|
|
| 4641 |
|
|
| 4642 |
|
|
| 4643 |
|
|
| 4644 |
-- |
|
| 4645 |
-- Name: COLUMN analytical_stem_view.tag; Type: COMMENT; Schema: public; Owner: - |
|
| 4646 |
-- |
|
| 4647 |
|
|
| 4648 |
|
|
| 4649 |
|
|
| 4650 |
|
|
| 4651 |
-- |
|
| 4652 |
-- Name: COLUMN analytical_stem_view.`organismX_m`; Type: COMMENT; Schema: public; Owner: - |
|
| 4653 |
-- |
|
| 4654 |
|
|
| 4655 |
|
|
| 4656 |
|
|
| 4657 |
|
|
| 4658 |
-- |
|
| 4659 |
-- Name: COLUMN analytical_stem_view.`organismY_m`; Type: COMMENT; Schema: public; Owner: - |
|
| 4660 |
-- |
|
| 4661 |
|
|
| 4662 |
|
|
| 4663 |
|
|
| 4664 |
|
|
| 4665 |
-- |
|
| 4666 |
-- Name: COLUMN analytical_stem_view.`taxonOccurrenceID`; Type: COMMENT; Schema: public; Owner: - |
|
| 4667 |
-- |
|
| 4668 |
|
|
| 4669 |
|
|
| 4670 |
|
|
| 4671 |
|
|
| 4672 |
-- |
|
| 4673 |
-- Name: COLUMN analytical_stem_view.`authorTaxonCode`; Type: COMMENT; Schema: public; Owner: - |
|
| 4674 |
-- |
|
| 4675 |
|
|
| 4676 |
|
|
| 4677 |
|
|
| 4678 |
|
|
| 4679 |
-- |
|
| 4680 |
-- Name: COLUMN analytical_stem_view.`aggregateOrganismObservationID`; Type: COMMENT; Schema: public; Owner: - |
|
| 4681 |
-- |
|
| 4682 |
|
|
| 4683 |
|
|
| 4684 |
|
|
| 4685 |
|
|
| 4686 |
-- |
|
| 4687 |
-- Name: COLUMN analytical_stem_view.`individualObservationID`; Type: COMMENT; Schema: public; Owner: - |
|
| 4688 |
-- |
|
| 4689 |
|
|
| 4690 |
|
|
| 4691 |
|
|
| 4692 |
|
|
| 4693 |
-- |
|
| 4694 |
-- Name: COLUMN analytical_stem_view.`individualCode`; Type: COMMENT; Schema: public; Owner: - |
|
| 4695 |
-- |
|
| 4696 |
|
|
| 4697 |
|
|
| 4698 |
|
|
| 4699 |
|
|
| 4700 |
-- |
|
| 4701 |
-- Name: COLUMN analytical_stem_view.`individualCount`; Type: COMMENT; Schema: public; Owner: - |
|
| 4702 |
-- |
|
| 4703 |
|
|
| 4704 |
|
|
| 4705 |
|
|
| 4706 |
|
|
| 4707 |
-- |
|
| 4708 |
-- Name: COLUMN analytical_stem_view.`authorStemCode`; Type: COMMENT; Schema: public; Owner: - |
|
| 4709 |
-- |
|
| 4710 |
|
|
| 4711 |
|
|
| 4712 |
|
|
| 4713 |
|
|
| 4714 |
-- |
|
| 4379 | 4715 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 4380 | 4716 |
-- |
| 4381 | 4717 |
|
| trunk/schemas/public_.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 |
|
| trunk/schemas/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