Revision 14460
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 4533 | 4533 |
|
| 4534 | 4534 |
|
| 4535 | 4535 |
-- |
| 4536 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 4536 |
-- Name: analytical_plot; Type: VIEW; Schema: public; Owner: -
|
|
| 4537 | 4537 |
-- |
| 4538 | 4538 |
|
| 4539 |
CREATE TABLE analytical_stem ( |
|
| 4540 |
`datasource__@Brad__.identifier_examples@vegpath.org` varchar(255) NOT NULL, |
|
| 4541 |
`country__@DwC__@vegpath.org` varchar(255), |
|
| 4542 |
`stateProvince__@DwC__@vegpath.org` varchar(255), |
|
| 4543 |
`county__@DwC__@vegpath.org` varchar(255), |
|
| 4544 |
`locality__@DwC__@vegpath.org` varchar(255), |
|
| 4545 |
`decimalLatitude__@DwC__@vegpath.org` double, |
|
| 4546 |
`decimalLongitude__@DwC__@vegpath.org` double, |
|
| 4547 |
`coordinateUncertaintyInMeters__@DwC__@vegpath.org` double, |
|
| 4548 |
`georeferenceSources__@DwC__@vegpath.org` coordinatesource, |
|
| 4549 |
`georeferenceProtocol__@DwC__@vegpath.org` varchar(255), |
|
| 4550 |
geovalid_bien int(11), |
|
| 4551 |
`isNewWorld_bien` int(11), |
|
| 4552 |
`projectID__@VegX__.plotObservation@vegpath.org` varchar(255), |
|
| 4553 |
`projectContributor[s]__@VegBank__@vegpath.org` varchar(255), |
|
| 4554 |
`locationID__@DwC__@vegpath.org` varchar(255) NOT NULL, |
|
| 4555 |
`plotName__@VegX__.plot@vegpath.org` varchar(255), |
|
| 4556 |
`subplot__@SALVIAS__.Plot_data@vegpath.org` varchar(255), |
|
| 4557 |
location__cultivated__bien int(1), |
|
| 4558 |
`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org` int(11), |
|
| 4559 |
`eventDate__@DwC__@vegpath.org` date, |
|
| 4560 |
`(-minimum-)ElevationInMeters__@DwC__@vegpath.org` double, |
|
| 4561 |
`slopeAspect[_deg]__@VegX__.plot@vegpath.org` double, |
|
| 4562 |
`slopeGradient[_deg]__@VegX__.plot@vegpath.org` double, |
|
| 4563 |
`plot.area[_ha]__@VegX__@vegpath.org` double, |
|
| 4564 |
`samplingProtocol__@DwC__@vegpath.org` varchar(255), |
|
| 4565 |
`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org` double, |
|
| 4566 |
`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org` double, |
|
| 4567 |
`stratumName__@VegX__.stratum@vegpath.org` varchar(255), |
|
| 4568 |
`communityConcept.name__@VegX__.communityDet@vegpath.org` varchar(255), |
|
| 4569 |
`observationContributor[s]__@VegBank__@vegpath.org` varchar(255), |
|
| 4570 |
`[custodial_]institutionCode[s]__@DwC__@vegpath.org` varchar(255), |
|
| 4571 |
`collectionCode__@DwC__@vegpath.org` varchar(255), |
|
| 4572 |
`catalogNumber__@DwC__@vegpath.org` varchar(255), |
|
| 4573 |
`occurrenceID__@DwC__@vegpath.org` varchar(255), |
|
| 4574 |
`recordedBy__@DwC__@vegpath.org` varchar(255), |
|
| 4575 |
`recordNumber__@DwC__@vegpath.org` varchar(255), |
|
| 4576 |
`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org` date, |
|
| 4577 |
`[verbatim_]family__@DwC__@vegpath.org` varchar(255), |
|
| 4578 |
`[verbatim_]scientificName__@DwC__@vegpath.org` varchar(255), |
|
| 4579 |
`identifiedBy__@DwC__@vegpath.org` varchar(255), |
|
| 4580 |
`dateIdentified__@DwC__@vegpath.org` date, |
|
| 4581 |
`identificationRemarks__@DwC__@vegpath.org` varchar(255), |
|
| 4582 |
`Family_matched__@TNRS__@vegpath.org` varchar(255), |
|
| 4583 |
`Name_matched__@TNRS__@vegpath.org` varchar(255), |
|
| 4584 |
`Name_matched_author__@TNRS__@vegpath.org` varchar(255), |
|
| 4585 |
`[higher_plant_group~]higherClassification__@DwC__@vegpath.org` higher_plant_group, |
|
| 4586 |
`taxonomicStatus__@DwC__@vegpath.org` varchar(255), |
|
| 4587 |
scrubbed_family varchar(255), |
|
| 4588 |
scrubbed_genus varchar(255), |
|
| 4589 |
scrubbed_specific_epithet varchar(255), |
|
| 4590 |
scrubbed_species_binomial varchar(255), |
|
| 4591 |
scrubbed_taxon_name_no_author varchar(255), |
|
| 4592 |
scrubbed_author varchar(255), |
|
| 4593 |
scrubbed_taxon_name_with_author varchar(255), |
|
| 4594 |
`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org` varchar(255), |
|
| 4595 |
`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org` growthform, |
|
| 4596 |
`reproductiveCondition__@DwC__@vegpath.org` varchar(255), |
|
| 4597 |
cultivated_bien int(11), |
|
| 4598 |
`cultivatedBasis_bien` varchar(255), |
|
| 4599 |
`occurrenceRemarks__@DwC__@vegpath.org` varchar(255), |
|
| 4600 |
`coverPercent__@VegX__.attribute.ordinal@vegpath.org` double, |
|
| 4601 |
`taxonObservation[.id]__@VegBank__@vegpath.org` varchar(255), |
|
| 4602 |
`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org` varchar(255), |
|
| 4603 |
`aggregateOrganismObservation.id__@VegX__@vegpath.org` varchar(255), |
|
| 4604 |
`individualOrganismObservation.id__@VegX__@vegpath.org` varchar(255), |
|
| 4605 |
`individualID__@DwC__@vegpath.org` varchar(255), |
|
| 4606 |
`individualCount__@DwC__@vegpath.org` int(11), |
|
| 4607 |
`plantobservation.``_id__@VegBIEN__.public@vegpath.org` int(11), |
|
| 4608 |
`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org` double, |
|
| 4609 |
`stemHeight[_m]__@VegBank__.stemCount@vegpath.org` double, |
|
| 4610 |
`[tag=]identificationLabel__@VegX__.individual@vegpath.org` varchar(255), |
|
| 4611 |
`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org` double, |
|
| 4612 |
`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org` double, |
|
| 4613 |
`stemCode__@VegBank__.stemLocation@vegpath.org` varchar(255), |
|
| 4614 |
`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org` int(11) NOT NULL |
|
| 4615 |
); |
|
| 4616 | 4539 |
|
| 4617 | 4540 |
|
| 4541 |
|
|
| 4618 | 4542 |
-- |
| 4619 |
-- Name: COLUMN analytical_stem.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4543 |
-- Name: COLUMN analytical_plot.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4620 | 4544 |
-- |
| 4621 | 4545 |
|
| 4622 | 4546 |
|
| 4623 | 4547 |
|
| 4624 | 4548 |
|
| 4625 | 4549 |
-- |
| 4626 |
-- Name: COLUMN analytical_stem.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4550 |
-- Name: COLUMN analytical_plot.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4627 | 4551 |
-- |
| 4628 | 4552 |
|
| 4629 | 4553 |
|
| 4630 | 4554 |
|
| 4631 | 4555 |
|
| 4632 | 4556 |
-- |
| 4633 |
-- Name: COLUMN analytical_stem.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4557 |
-- Name: COLUMN analytical_plot.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4634 | 4558 |
-- |
| 4635 | 4559 |
|
| 4636 | 4560 |
|
| 4637 | 4561 |
|
| 4638 | 4562 |
|
| 4639 | 4563 |
-- |
| 4640 |
-- Name: COLUMN analytical_stem.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4564 |
-- Name: COLUMN analytical_plot.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4641 | 4565 |
-- |
| 4642 | 4566 |
|
| 4643 | 4567 |
|
| 4644 | 4568 |
|
| 4645 | 4569 |
|
| 4646 | 4570 |
-- |
| 4647 |
-- Name: COLUMN analytical_stem.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4571 |
-- Name: COLUMN analytical_plot.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4648 | 4572 |
-- |
| 4649 | 4573 |
|
| 4650 | 4574 |
|
| 4651 | 4575 |
|
| 4652 | 4576 |
|
| 4653 | 4577 |
-- |
| 4654 |
-- Name: COLUMN analytical_stem.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4578 |
-- Name: COLUMN analytical_plot.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4655 | 4579 |
-- |
| 4656 | 4580 |
|
| 4657 | 4581 |
|
| 4658 | 4582 |
|
| 4659 | 4583 |
|
| 4660 | 4584 |
-- |
| 4661 |
-- Name: COLUMN analytical_stem.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4585 |
-- Name: COLUMN analytical_plot.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4662 | 4586 |
-- |
| 4663 | 4587 |
|
| 4664 | 4588 |
|
| 4665 | 4589 |
|
| 4666 | 4590 |
|
| 4667 | 4591 |
-- |
| 4668 |
-- Name: COLUMN analytical_stem.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4592 |
-- Name: COLUMN analytical_plot.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4669 | 4593 |
-- |
| 4670 | 4594 |
|
| 4671 | 4595 |
|
| 4672 | 4596 |
|
| 4673 | 4597 |
|
| 4674 | 4598 |
-- |
| 4675 |
-- Name: COLUMN analytical_stem.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4599 |
-- Name: COLUMN analytical_plot.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4676 | 4600 |
-- |
| 4677 | 4601 |
|
| 4678 | 4602 |
|
| 4679 | 4603 |
|
| 4680 | 4604 |
|
| 4681 | 4605 |
-- |
| 4682 |
-- Name: COLUMN analytical_stem.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4606 |
-- Name: COLUMN analytical_plot.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4683 | 4607 |
-- |
| 4684 | 4608 |
|
| 4685 | 4609 |
|
| 4686 | 4610 |
|
| 4687 | 4611 |
|
| 4688 | 4612 |
-- |
| 4689 |
-- Name: COLUMN analytical_stem.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 4613 |
-- Name: COLUMN analytical_plot.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 4690 | 4614 |
-- |
| 4691 | 4615 |
|
| 4692 | 4616 |
|
| 4693 | 4617 |
|
| 4694 | 4618 |
|
| 4695 | 4619 |
-- |
| 4696 |
-- Name: COLUMN analytical_stem.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4620 |
-- Name: COLUMN analytical_plot.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4697 | 4621 |
-- |
| 4698 | 4622 |
|
| 4699 | 4623 |
|
| 4700 | 4624 |
|
| 4701 | 4625 |
|
| 4702 | 4626 |
-- |
| 4703 |
-- Name: COLUMN analytical_stem.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4627 |
-- Name: COLUMN analytical_plot.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4704 | 4628 |
-- |
| 4705 | 4629 |
|
| 4706 | 4630 |
|
| 4707 | 4631 |
|
| 4708 | 4632 |
|
| 4709 | 4633 |
-- |
| 4710 |
-- Name: COLUMN analytical_stem.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4634 |
-- Name: COLUMN analytical_plot.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4711 | 4635 |
-- |
| 4712 | 4636 |
|
| 4713 | 4637 |
|
| 4714 | 4638 |
|
| 4715 | 4639 |
|
| 4716 | 4640 |
-- |
| 4717 |
-- Name: COLUMN analytical_stem.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4641 |
-- Name: COLUMN analytical_plot.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4718 | 4642 |
-- |
| 4719 | 4643 |
|
| 4720 | 4644 |
|
| 4721 | 4645 |
|
| 4722 | 4646 |
|
| 4723 | 4647 |
-- |
| 4724 |
-- Name: COLUMN analytical_stem.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4648 |
-- Name: COLUMN analytical_plot.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4725 | 4649 |
-- |
| 4726 | 4650 |
|
| 4727 | 4651 |
|
| 4728 | 4652 |
|
| 4729 | 4653 |
|
| 4730 | 4654 |
-- |
| 4731 |
-- Name: COLUMN analytical_stem.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4655 |
-- Name: COLUMN analytical_plot.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4732 | 4656 |
-- |
| 4733 | 4657 |
|
| 4734 | 4658 |
|
| 4735 | 4659 |
|
| 4736 | 4660 |
|
| 4737 | 4661 |
-- |
| 4738 |
-- Name: COLUMN analytical_stem.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 4662 |
-- Name: COLUMN analytical_plot.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 4739 | 4663 |
-- |
| 4740 | 4664 |
|
| 4741 | 4665 |
|
| 4742 | 4666 |
|
| 4743 | 4667 |
|
| 4744 | 4668 |
-- |
| 4745 |
-- Name: COLUMN analytical_stem.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4669 |
-- Name: COLUMN analytical_plot.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4746 | 4670 |
-- |
| 4747 | 4671 |
|
| 4748 | 4672 |
|
| 4749 | 4673 |
|
| 4750 | 4674 |
|
| 4751 | 4675 |
-- |
| 4752 |
-- Name: COLUMN analytical_stem.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4676 |
-- Name: COLUMN analytical_plot.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4753 | 4677 |
-- |
| 4754 | 4678 |
|
| 4755 | 4679 |
|
| 4756 | 4680 |
|
| 4757 | 4681 |
|
| 4758 | 4682 |
-- |
| 4759 |
-- Name: COLUMN analytical_stem.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4683 |
-- Name: COLUMN analytical_plot.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4760 | 4684 |
-- |
| 4761 | 4685 |
|
| 4762 | 4686 |
|
| 4763 | 4687 |
|
| 4764 | 4688 |
|
| 4765 | 4689 |
-- |
| 4766 |
-- Name: COLUMN analytical_stem.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4690 |
-- Name: COLUMN analytical_plot.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4767 | 4691 |
-- |
| 4768 | 4692 |
|
| 4769 | 4693 |
|
| 4770 | 4694 |
|
| 4771 | 4695 |
|
| 4772 | 4696 |
-- |
| 4773 |
-- Name: COLUMN analytical_stem.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4697 |
-- Name: COLUMN analytical_plot.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4774 | 4698 |
-- |
| 4775 | 4699 |
|
| 4776 | 4700 |
|
| 4777 | 4701 |
|
| 4778 | 4702 |
|
| 4779 | 4703 |
-- |
| 4780 |
-- Name: COLUMN analytical_stem.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4704 |
-- Name: COLUMN analytical_plot.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4781 | 4705 |
-- |
| 4782 | 4706 |
|
| 4783 | 4707 |
|
| 4784 | 4708 |
|
| 4785 | 4709 |
|
| 4786 | 4710 |
-- |
| 4787 |
-- Name: COLUMN analytical_stem.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4711 |
-- Name: COLUMN analytical_plot.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4788 | 4712 |
-- |
| 4789 | 4713 |
|
| 4790 | 4714 |
|
| 4791 | 4715 |
|
| 4792 | 4716 |
|
| 4793 | 4717 |
-- |
| 4794 |
-- Name: COLUMN analytical_stem.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4718 |
-- Name: COLUMN analytical_plot.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4795 | 4719 |
-- |
| 4796 | 4720 |
|
| 4797 | 4721 |
|
| 4798 | 4722 |
|
| 4799 | 4723 |
|
| 4800 | 4724 |
-- |
| 4801 |
-- Name: COLUMN analytical_stem.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4725 |
-- Name: COLUMN analytical_plot.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4802 | 4726 |
-- |
| 4803 | 4727 |
|
| 4804 | 4728 |
|
| 4805 | 4729 |
|
| 4806 | 4730 |
|
| 4807 | 4731 |
-- |
| 4808 |
-- Name: COLUMN analytical_stem.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4732 |
-- Name: COLUMN analytical_plot.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4809 | 4733 |
-- |
| 4810 | 4734 |
|
| 4811 | 4735 |
|
| 4812 | 4736 |
|
| 4813 | 4737 |
|
| 4814 | 4738 |
-- |
| 4815 |
-- Name: COLUMN analytical_stem.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4739 |
-- Name: COLUMN analytical_plot.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4816 | 4740 |
-- |
| 4817 | 4741 |
|
| 4818 | 4742 |
|
| 4819 | 4743 |
|
| 4820 | 4744 |
|
| 4821 | 4745 |
-- |
| 4822 |
-- Name: COLUMN analytical_stem.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4746 |
-- Name: COLUMN analytical_plot.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4823 | 4747 |
-- |
| 4824 | 4748 |
|
| 4825 | 4749 |
|
| 4826 | 4750 |
|
| 4827 | 4751 |
|
| 4828 | 4752 |
-- |
| 4829 |
-- Name: COLUMN analytical_stem.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4753 |
-- Name: COLUMN analytical_plot.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4830 | 4754 |
-- |
| 4831 | 4755 |
|
| 4832 | 4756 |
|
| 4833 | 4757 |
|
| 4834 | 4758 |
|
| 4835 | 4759 |
-- |
| 4836 |
-- Name: COLUMN analytical_stem.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4760 |
-- Name: COLUMN analytical_plot.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4837 | 4761 |
-- |
| 4838 | 4762 |
|
| 4839 | 4763 |
|
| 4840 | 4764 |
|
| 4841 | 4765 |
|
| 4842 | 4766 |
-- |
| 4843 |
-- Name: COLUMN analytical_stem.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4767 |
-- Name: COLUMN analytical_plot.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4844 | 4768 |
-- |
| 4845 | 4769 |
|
| 4846 | 4770 |
|
| 4847 | 4771 |
|
| 4848 | 4772 |
|
| 4849 | 4773 |
-- |
| 4850 |
-- Name: COLUMN analytical_stem.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4774 |
-- Name: COLUMN analytical_plot.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4851 | 4775 |
-- |
| 4852 | 4776 |
|
| 4853 | 4777 |
|
| 4854 | 4778 |
|
| 4855 | 4779 |
|
| 4856 | 4780 |
-- |
| 4857 |
-- Name: COLUMN analytical_stem.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4781 |
-- Name: COLUMN analytical_plot.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4858 | 4782 |
-- |
| 4859 | 4783 |
|
| 4860 | 4784 |
|
| 4861 | 4785 |
|
| 4862 | 4786 |
|
| 4863 | 4787 |
-- |
| 4864 |
-- Name: COLUMN analytical_stem.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4788 |
-- Name: COLUMN analytical_plot.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4865 | 4789 |
-- |
| 4866 | 4790 |
|
| 4867 | 4791 |
|
| 4868 | 4792 |
|
| 4869 | 4793 |
|
| 4870 | 4794 |
-- |
| 4871 |
-- Name: COLUMN analytical_stem.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4795 |
-- Name: COLUMN analytical_plot.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4872 | 4796 |
-- |
| 4873 | 4797 |
|
| 4874 | 4798 |
|
| 4875 | 4799 |
|
| 4876 | 4800 |
|
| 4877 | 4801 |
-- |
| 4878 |
-- Name: COLUMN analytical_stem.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4802 |
-- Name: COLUMN analytical_plot.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4879 | 4803 |
-- |
| 4880 | 4804 |
|
| 4881 | 4805 |
|
| 4882 | 4806 |
|
| 4883 | 4807 |
|
| 4884 | 4808 |
-- |
| 4885 |
-- Name: COLUMN analytical_stem.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4809 |
-- Name: COLUMN analytical_plot.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4886 | 4810 |
-- |
| 4887 | 4811 |
|
| 4888 | 4812 |
|
| 4889 | 4813 |
|
| 4890 | 4814 |
|
| 4891 | 4815 |
-- |
| 4892 |
-- Name: COLUMN analytical_stem.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4816 |
-- Name: COLUMN analytical_plot.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4893 | 4817 |
-- |
| 4894 | 4818 |
|
| 4895 | 4819 |
|
| 4896 | 4820 |
|
| 4897 | 4821 |
|
| 4898 | 4822 |
-- |
| 4899 |
-- Name: COLUMN analytical_stem.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4823 |
-- Name: COLUMN analytical_plot.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
|
|
| 4900 | 4824 |
-- |
| 4901 | 4825 |
|
| 4902 | 4826 |
|
| 4903 | 4827 |
|
| 4904 | 4828 |
|
| 4905 | 4829 |
-- |
| 4906 |
-- Name: COLUMN analytical_stem.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4830 |
-- Name: COLUMN analytical_plot.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 4907 | 4831 |
-- |
| 4908 | 4832 |
|
| 4909 | 4833 |
|
| 4910 | 4834 |
|
| 4911 | 4835 |
|
| 4912 | 4836 |
-- |
| 4913 |
-- Name: COLUMN analytical_stem.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4837 |
-- Name: COLUMN analytical_plot.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4914 | 4838 |
-- |
| 4915 | 4839 |
|
| 4916 | 4840 |
|
| 4917 | 4841 |
|
| 4918 | 4842 |
|
| 4919 | 4843 |
-- |
| 4920 |
-- Name: COLUMN analytical_stem.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4844 |
-- Name: COLUMN analytical_plot.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 4921 | 4845 |
-- |
| 4922 | 4846 |
|
| 4923 | 4847 |
|
| 4924 | 4848 |
|
| 4925 | 4849 |
|
| 4926 | 4850 |
-- |
| 4927 |
-- Name: COLUMN analytical_stem.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4851 |
-- Name: COLUMN analytical_plot.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 4928 | 4852 |
-- |
| 4929 | 4853 |
|
| 4930 | 4854 |
|
| 4931 | 4855 |
|
| 4932 | 4856 |
|
| 4933 | 4857 |
-- |
| 4934 |
-- Name: COLUMN analytical_stem.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4858 |
-- Name: COLUMN analytical_plot.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4935 | 4859 |
-- |
| 4936 | 4860 |
|
| 4937 | 4861 |
|
| 4938 | 4862 |
|
| 4939 | 4863 |
|
| 4940 | 4864 |
-- |
| 4941 |
-- Name: COLUMN analytical_stem.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4865 |
-- Name: COLUMN analytical_plot.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4942 | 4866 |
-- |
| 4943 | 4867 |
|
| 4944 | 4868 |
|
| 4945 | 4869 |
|
| 4946 | 4870 |
|
| 4947 | 4871 |
-- |
| 4948 |
-- Name: COLUMN analytical_stem.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
|
|
| 4872 |
-- Name: COLUMN analytical_plot.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 4949 | 4873 |
-- |
| 4950 | 4874 |
|
| 4951 | 4875 |
|
| 4952 | 4876 |
|
| 4953 | 4877 |
|
| 4954 | 4878 |
-- |
| 4955 |
-- Name: COLUMN analytical_stem.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 4879 |
-- Name: COLUMN analytical_plot.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4956 | 4880 |
-- |
| 4957 | 4881 |
|
| 4958 | 4882 |
|
| 4959 | 4883 |
|
| 4960 | 4884 |
|
| 4961 | 4885 |
-- |
| 4962 |
-- Name: COLUMN analytical_stem.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
|
|
| 4886 |
-- Name: COLUMN analytical_plot.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4963 | 4887 |
-- |
| 4964 | 4888 |
|
| 4965 | 4889 |
|
| 4966 | 4890 |
|
| 4967 | 4891 |
|
| 4968 | 4892 |
-- |
| 4969 |
-- Name: COLUMN analytical_stem.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
|
|
| 4893 |
-- Name: COLUMN analytical_plot.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4970 | 4894 |
-- |
| 4971 | 4895 |
|
| 4972 | 4896 |
|
| 4973 | 4897 |
|
| 4974 | 4898 |
|
| 4975 | 4899 |
-- |
| 4976 |
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 4900 |
-- Name: COLUMN analytical_plot.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4977 | 4901 |
-- |
| 4978 | 4902 |
|
| 4979 | 4903 |
|
| 4980 | 4904 |
|
| 4981 | 4905 |
|
| 4982 | 4906 |
-- |
| 4983 |
-- Name: COLUMN analytical_stem.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 4907 |
-- Name: COLUMN analytical_plot.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4984 | 4908 |
-- |
| 4985 | 4909 |
|
| 4986 | 4910 |
|
| 4987 | 4911 |
|
| 4988 | 4912 |
|
| 4989 | 4913 |
-- |
| 4990 |
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 4914 |
-- Name: COLUMN analytical_plot.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4991 | 4915 |
-- |
| 4992 | 4916 |
|
| 4993 | 4917 |
|
| 4994 | 4918 |
|
| 4995 | 4919 |
|
| 4996 | 4920 |
-- |
| 4997 |
-- Name: COLUMN analytical_stem.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4921 |
-- Name: COLUMN analytical_plot.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4998 | 4922 |
-- |
| 4999 | 4923 |
|
| 5000 | 4924 |
|
| 5001 | 4925 |
|
| 5002 | 4926 |
|
| 5003 | 4927 |
-- |
| 5004 |
-- Name: COLUMN analytical_stem.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4928 |
-- Name: COLUMN analytical_plot.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5005 | 4929 |
-- |
| 5006 | 4930 |
|
| 5007 | 4931 |
|
| 5008 | 4932 |
|
| 5009 | 4933 |
|
| 5010 | 4934 |
-- |
| 5011 |
-- Name: COLUMN analytical_stem.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4935 |
-- Name: COLUMN analytical_plot.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5012 | 4936 |
-- |
| 5013 | 4937 |
|
| 5014 | 4938 |
|
| 5015 | 4939 |
|
| 5016 | 4940 |
|
| 5017 | 4941 |
-- |
| 5018 |
-- Name: COLUMN analytical_stem.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 4942 |
-- Name: COLUMN analytical_plot.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5019 | 4943 |
-- |
| 5020 | 4944 |
|
| 5021 | 4945 |
|
| 5022 | 4946 |
|
| 5023 | 4947 |
|
| 5024 | 4948 |
-- |
| 5025 |
-- Name: COLUMN analytical_stem.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4949 |
-- Name: COLUMN analytical_plot.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5026 | 4950 |
-- |
| 5027 | 4951 |
|
| 5028 | 4952 |
|
| 5029 | 4953 |
|
| 5030 | 4954 |
|
| 5031 | 4955 |
-- |
| 5032 |
-- Name: COLUMN analytical_stem.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4956 |
-- Name: COLUMN analytical_plot.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5033 | 4957 |
-- |
| 5034 | 4958 |
|
| 5035 | 4959 |
|
| 5036 | 4960 |
|
| 5037 | 4961 |
|
| 5038 | 4962 |
-- |
| 5039 |
-- Name: COLUMN analytical_stem.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4963 |
-- Name: COLUMN analytical_plot.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5040 | 4964 |
-- |
| 5041 | 4965 |
|
| 5042 | 4966 |
|
| 5043 | 4967 |
|
| 5044 | 4968 |
|
| 5045 | 4969 |
-- |
| 5046 |
-- Name: COLUMN analytical_stem.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4970 |
-- Name: COLUMN analytical_plot.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5047 | 4971 |
-- |
| 5048 | 4972 |
|
| 5049 | 4973 |
|
| 5050 | 4974 |
|
| 5051 | 4975 |
|
| 5052 | 4976 |
-- |
| 5053 |
-- Name: COLUMN analytical_stem.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4977 |
-- Name: COLUMN analytical_plot.`stemCode__@VegBank__.stemLocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5054 | 4978 |
-- |
| 5055 | 4979 |
|
| 5056 | 4980 |
|
| 5057 | 4981 |
|
| 5058 | 4982 |
|
| 5059 | 4983 |
-- |
| 5060 |
-- Name: COLUMN analytical_stem.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4984 |
-- Name: analytical_specimen; Type: VIEW; Schema: public; Owner: -
|
|
| 5061 | 4985 |
-- |
| 5062 | 4986 |
|
| 5063 | 4987 |
|
| 5064 | 4988 |
|
| 5065 | 4989 |
|
| 5066 | 4990 |
-- |
| 5067 |
-- Name: COLUMN analytical_stem.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4991 |
-- Name: COLUMN analytical_specimen.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5068 | 4992 |
-- |
| 5069 | 4993 |
|
| 5070 | 4994 |
|
| 5071 | 4995 |
|
| 5072 | 4996 |
|
| 5073 | 4997 |
-- |
| 5074 |
-- Name: COLUMN analytical_stem.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4998 |
-- Name: COLUMN analytical_specimen.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5075 | 4999 |
-- |
| 5076 | 5000 |
|
| 5077 | 5001 |
|
| 5078 | 5002 |
|
| 5079 | 5003 |
|
| 5080 | 5004 |
-- |
| 5081 |
-- Name: COLUMN analytical_stem.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5005 |
-- Name: COLUMN analytical_specimen.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5082 | 5006 |
-- |
| 5083 | 5007 |
|
| 5084 | 5008 |
|
| 5085 | 5009 |
|
| 5086 | 5010 |
|
| 5087 | 5011 |
-- |
| 5088 |
-- Name: COLUMN analytical_stem.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5012 |
-- Name: COLUMN analytical_specimen.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5089 | 5013 |
-- |
| 5090 | 5014 |
|
| 5091 | 5015 |
|
| 5092 | 5016 |
|
| 5093 | 5017 |
|
| 5094 | 5018 |
-- |
| 5095 |
-- Name: COLUMN analytical_stem.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5019 |
-- Name: COLUMN analytical_specimen.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5096 | 5020 |
-- |
| 5097 | 5021 |
|
| 5098 | 5022 |
|
| 5099 | 5023 |
|
| 5100 | 5024 |
|
| 5101 | 5025 |
-- |
| 5102 |
-- Name: COLUMN analytical_stem.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5026 |
-- Name: COLUMN analytical_specimen.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5103 | 5027 |
-- |
| 5104 | 5028 |
|
| 5105 | 5029 |
|
| 5106 | 5030 |
|
| 5107 | 5031 |
|
| 5108 | 5032 |
-- |
| 5109 |
-- Name: COLUMN analytical_stem.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5033 |
-- Name: COLUMN analytical_specimen.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5110 | 5034 |
-- |
| 5111 | 5035 |
|
| 5112 | 5036 |
|
| 5113 | 5037 |
|
| 5114 | 5038 |
|
| 5115 | 5039 |
-- |
| 5116 |
-- Name: COLUMN analytical_stem.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5040 |
-- Name: COLUMN analytical_specimen.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5117 | 5041 |
-- |
| 5118 | 5042 |
|
| 5119 | 5043 |
|
| 5120 | 5044 |
|
| 5121 | 5045 |
|
| 5122 | 5046 |
-- |
| 5123 |
-- Name: COLUMN analytical_stem.`stemCode__@VegBank__.stemLocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5047 |
-- Name: COLUMN analytical_specimen.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5124 | 5048 |
-- |
| 5125 | 5049 |
|
| 5126 | 5050 |
|
| 5127 | 5051 |
|
| 5128 | 5052 |
|
| 5129 | 5053 |
-- |
| 5130 |
-- Name: COLUMN analytical_stem.`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5054 |
-- Name: COLUMN analytical_specimen.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5131 | 5055 |
-- |
| 5132 | 5056 |
|
| 5133 | 5057 |
|
| 5134 | 5058 |
|
| 5135 | 5059 |
|
| 5136 | 5060 |
-- |
| 5137 |
-- Name: analytical_plot; Type: VIEW; Schema: public; Owner: -
|
|
| 5061 |
-- Name: COLUMN analytical_specimen.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5138 | 5062 |
-- |
| 5139 | 5063 |
|
| 5140 | 5064 |
|
| 5141 | 5065 |
|
| 5142 | 5066 |
|
| 5143 | 5067 |
-- |
| 5144 |
-- Name: COLUMN analytical_plot.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5068 |
-- Name: COLUMN analytical_specimen.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5145 | 5069 |
-- |
| 5146 | 5070 |
|
| 5147 | 5071 |
|
| 5148 | 5072 |
|
| 5149 | 5073 |
|
| 5150 | 5074 |
-- |
| 5151 |
-- Name: COLUMN analytical_plot.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5075 |
-- Name: COLUMN analytical_specimen.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5152 | 5076 |
-- |
| 5153 | 5077 |
|
| 5154 | 5078 |
|
| 5155 | 5079 |
|
| 5156 | 5080 |
|
| 5157 | 5081 |
-- |
| 5158 |
-- Name: COLUMN analytical_plot.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5082 |
-- Name: COLUMN analytical_specimen.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5159 | 5083 |
-- |
| 5160 | 5084 |
|
| 5161 | 5085 |
|
| 5162 | 5086 |
|
| 5163 | 5087 |
|
| 5164 | 5088 |
-- |
| 5165 |
-- Name: COLUMN analytical_plot.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5089 |
-- Name: COLUMN analytical_specimen.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5166 | 5090 |
-- |
| 5167 | 5091 |
|
| 5168 | 5092 |
|
| 5169 | 5093 |
|
| 5170 | 5094 |
|
| 5171 | 5095 |
-- |
| 5172 |
-- Name: COLUMN analytical_plot.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5096 |
-- Name: COLUMN analytical_specimen.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5173 | 5097 |
-- |
| 5174 | 5098 |
|
| 5175 | 5099 |
|
| 5176 | 5100 |
|
| 5177 | 5101 |
|
| 5178 | 5102 |
-- |
| 5179 |
-- Name: COLUMN analytical_plot.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5103 |
-- Name: COLUMN analytical_specimen.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5180 | 5104 |
-- |
| 5181 | 5105 |
|
| 5182 | 5106 |
|
| 5183 | 5107 |
|
| 5184 | 5108 |
|
| 5185 | 5109 |
-- |
| 5186 |
-- Name: COLUMN analytical_plot.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5110 |
-- Name: COLUMN analytical_specimen.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5187 | 5111 |
-- |
| 5188 | 5112 |
|
| 5189 | 5113 |
|
| 5190 | 5114 |
|
| 5191 | 5115 |
|
| 5192 | 5116 |
-- |
| 5193 |
-- Name: COLUMN analytical_plot.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5117 |
-- Name: COLUMN analytical_specimen.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5194 | 5118 |
-- |
| 5195 | 5119 |
|
| 5196 | 5120 |
|
| 5197 | 5121 |
|
| 5198 | 5122 |
|
| 5199 | 5123 |
-- |
| 5200 |
-- Name: COLUMN analytical_plot.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5124 |
-- Name: COLUMN analytical_specimen.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5201 | 5125 |
-- |
| 5202 | 5126 |
|
| 5203 | 5127 |
|
| 5204 | 5128 |
|
| 5205 | 5129 |
|
| 5206 | 5130 |
-- |
| 5207 |
-- Name: COLUMN analytical_plot.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5131 |
-- Name: COLUMN analytical_specimen.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5208 | 5132 |
-- |
| 5209 | 5133 |
|
| 5210 | 5134 |
|
| 5211 | 5135 |
|
| 5212 | 5136 |
|
| 5213 | 5137 |
-- |
| 5214 |
-- Name: COLUMN analytical_plot.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5138 |
-- Name: COLUMN analytical_specimen.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5215 | 5139 |
-- |
| 5216 | 5140 |
|
| 5217 | 5141 |
|
| 5218 | 5142 |
|
| 5219 | 5143 |
|
| 5220 | 5144 |
-- |
| 5221 |
-- Name: COLUMN analytical_plot.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5145 |
-- Name: COLUMN analytical_specimen.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5222 | 5146 |
-- |
| 5223 | 5147 |
|
| 5224 | 5148 |
|
| 5225 | 5149 |
|
| 5226 | 5150 |
|
| 5227 | 5151 |
-- |
| 5228 |
-- Name: COLUMN analytical_plot.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5152 |
-- Name: COLUMN analytical_specimen.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5229 | 5153 |
-- |
| 5230 | 5154 |
|
| 5231 | 5155 |
|
| 5232 | 5156 |
|
| 5233 | 5157 |
|
| 5234 | 5158 |
-- |
| 5235 |
-- Name: COLUMN analytical_plot.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5159 |
-- Name: COLUMN analytical_specimen.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5236 | 5160 |
-- |
| 5237 | 5161 |
|
| 5238 | 5162 |
|
| 5239 | 5163 |
|
| 5240 | 5164 |
|
| 5241 | 5165 |
-- |
| 5242 |
-- Name: COLUMN analytical_plot.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5166 |
-- Name: COLUMN analytical_specimen.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5243 | 5167 |
-- |
| 5244 | 5168 |
|
| 5245 | 5169 |
|
| 5246 | 5170 |
|
| 5247 | 5171 |
|
| 5248 | 5172 |
-- |
| 5249 |
-- Name: COLUMN analytical_plot.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5173 |
-- Name: COLUMN analytical_specimen.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5250 | 5174 |
-- |
| 5251 | 5175 |
|
| 5252 | 5176 |
|
| 5253 | 5177 |
|
| 5254 | 5178 |
|
| 5255 | 5179 |
-- |
| 5256 |
-- Name: COLUMN analytical_plot.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5180 |
-- Name: COLUMN analytical_specimen.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5257 | 5181 |
-- |
| 5258 | 5182 |
|
| 5259 | 5183 |
|
| 5260 | 5184 |
|
| 5261 | 5185 |
|
| 5262 | 5186 |
-- |
| 5263 |
-- Name: COLUMN analytical_plot.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5187 |
-- Name: COLUMN analytical_specimen.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5264 | 5188 |
-- |
| 5265 | 5189 |
|
| 5266 | 5190 |
|
| 5267 | 5191 |
|
| 5268 | 5192 |
|
| 5269 | 5193 |
-- |
| 5270 |
-- Name: COLUMN analytical_plot.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5194 |
-- Name: COLUMN analytical_specimen.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5271 | 5195 |
-- |
| 5272 | 5196 |
|
| 5273 | 5197 |
|
| 5274 | 5198 |
|
| 5275 | 5199 |
|
| 5276 | 5200 |
-- |
| 5277 |
-- Name: COLUMN analytical_plot.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5201 |
-- Name: COLUMN analytical_specimen.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5278 | 5202 |
-- |
| 5279 | 5203 |
|
| 5280 | 5204 |
|
| 5281 | 5205 |
|
| 5282 | 5206 |
|
| 5283 | 5207 |
-- |
| 5284 |
-- Name: COLUMN analytical_plot.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5208 |
-- Name: COLUMN analytical_specimen.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5285 | 5209 |
-- |
| 5286 | 5210 |
|
| 5287 | 5211 |
|
| 5288 | 5212 |
|
| 5289 | 5213 |
|
| 5290 | 5214 |
-- |
| 5291 |
-- Name: COLUMN analytical_plot.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5215 |
-- Name: COLUMN analytical_specimen.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
|
|
| 5292 | 5216 |
-- |
| 5293 | 5217 |
|
| 5294 | 5218 |
|
| 5295 | 5219 |
|
| 5296 | 5220 |
|
| 5297 | 5221 |
-- |
| 5298 |
-- Name: COLUMN analytical_plot.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5222 |
-- Name: COLUMN analytical_specimen.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 5299 | 5223 |
-- |
| 5300 | 5224 |
|
| 5301 | 5225 |
|
| 5302 | 5226 |
|
| 5303 | 5227 |
|
| 5304 | 5228 |
-- |
| 5305 |
-- Name: COLUMN analytical_plot.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5229 |
-- Name: COLUMN analytical_specimen.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 5306 | 5230 |
-- |
| 5307 | 5231 |
|
| 5308 | 5232 |
|
| 5309 | 5233 |
|
| 5310 | 5234 |
|
| 5311 | 5235 |
-- |
| 5312 |
-- Name: COLUMN analytical_plot.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5236 |
-- Name: COLUMN analytical_specimen.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 5313 | 5237 |
-- |
| 5314 | 5238 |
|
| 5315 | 5239 |
|
| 5316 | 5240 |
|
| 5317 | 5241 |
|
| 5318 | 5242 |
-- |
| 5319 |
-- Name: COLUMN analytical_plot.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5243 |
-- Name: COLUMN analytical_specimen.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5320 | 5244 |
-- |
| 5321 | 5245 |
|
| 5322 | 5246 |
|
| 5323 | 5247 |
|
| 5324 | 5248 |
|
| 5325 | 5249 |
-- |
| 5326 |
-- Name: COLUMN analytical_plot.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5250 |
-- Name: COLUMN analytical_specimen.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5327 | 5251 |
-- |
| 5328 | 5252 |
|
| 5329 | 5253 |
|
| 5330 | 5254 |
|
| 5331 | 5255 |
|
| 5332 | 5256 |
-- |
| 5333 |
-- Name: COLUMN analytical_plot.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5257 |
-- Name: COLUMN analytical_specimen.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5334 | 5258 |
-- |
| 5335 | 5259 |
|
| 5336 | 5260 |
|
| 5337 | 5261 |
|
| 5338 | 5262 |
|
| 5339 | 5263 |
-- |
| 5340 |
-- Name: COLUMN analytical_plot.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5264 |
-- Name: COLUMN analytical_specimen.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5341 | 5265 |
-- |
| 5342 | 5266 |
|
| 5343 | 5267 |
|
| 5344 | 5268 |
|
| 5345 | 5269 |
|
| 5346 | 5270 |
-- |
| 5347 |
-- Name: COLUMN analytical_plot.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5271 |
-- Name: COLUMN analytical_specimen.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5348 | 5272 |
-- |
| 5349 | 5273 |
|
| 5350 | 5274 |
|
| 5351 | 5275 |
|
| 5352 | 5276 |
|
| 5353 | 5277 |
-- |
| 5354 |
-- Name: COLUMN analytical_plot.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5278 |
-- Name: COLUMN analytical_specimen.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5355 | 5279 |
-- |
| 5356 | 5280 |
|
| 5357 | 5281 |
|
| 5358 | 5282 |
|
| 5359 | 5283 |
|
| 5360 | 5284 |
-- |
| 5361 |
-- Name: COLUMN analytical_plot.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5285 |
-- Name: COLUMN analytical_specimen.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5362 | 5286 |
-- |
| 5363 | 5287 |
|
| 5364 | 5288 |
|
| 5365 | 5289 |
|
| 5366 | 5290 |
|
| 5367 | 5291 |
-- |
| 5368 |
-- Name: COLUMN analytical_plot.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5292 |
-- Name: COLUMN analytical_specimen.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5369 | 5293 |
-- |
| 5370 | 5294 |
|
| 5371 | 5295 |
|
| 5372 | 5296 |
|
| 5373 | 5297 |
|
| 5374 | 5298 |
-- |
| 5375 |
-- Name: COLUMN analytical_plot.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5299 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5376 | 5300 |
-- |
| 5377 | 5301 |
|
| 5302 |
CREATE TABLE analytical_stem ( |
|
| 5303 |
`datasource__@Brad__.identifier_examples@vegpath.org` varchar(255) NOT NULL, |
|
| 5304 |
`country__@DwC__@vegpath.org` varchar(255), |
|
| 5305 |
`stateProvince__@DwC__@vegpath.org` varchar(255), |
|
| 5306 |
`county__@DwC__@vegpath.org` varchar(255), |
|
| 5307 |
`locality__@DwC__@vegpath.org` varchar(255), |
|
| 5308 |
`decimalLatitude__@DwC__@vegpath.org` double, |
|
| 5309 |
`decimalLongitude__@DwC__@vegpath.org` double, |
|
| 5310 |
`coordinateUncertaintyInMeters__@DwC__@vegpath.org` double, |
|
| 5311 |
`georeferenceSources__@DwC__@vegpath.org` coordinatesource, |
|
| 5312 |
`georeferenceProtocol__@DwC__@vegpath.org` varchar(255), |
|
| 5313 |
geovalid_bien int(11), |
|
| 5314 |
`isNewWorld_bien` int(11), |
|
| 5315 |
`projectID__@VegX__.plotObservation@vegpath.org` varchar(255), |
|
| 5316 |
`projectContributor[s]__@VegBank__@vegpath.org` varchar(255), |
|
| 5317 |
`locationID__@DwC__@vegpath.org` varchar(255) NOT NULL, |
|
| 5318 |
`plotName__@VegX__.plot@vegpath.org` varchar(255), |
|
| 5319 |
`subplot__@SALVIAS__.Plot_data@vegpath.org` varchar(255), |
|
| 5320 |
location__cultivated__bien int(1), |
|
| 5321 |
`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org` int(11), |
|
| 5322 |
`eventDate__@DwC__@vegpath.org` date, |
|
| 5323 |
`(-minimum-)ElevationInMeters__@DwC__@vegpath.org` double, |
|
| 5324 |
`slopeAspect[_deg]__@VegX__.plot@vegpath.org` double, |
|
| 5325 |
`slopeGradient[_deg]__@VegX__.plot@vegpath.org` double, |
|
| 5326 |
`plot.area[_ha]__@VegX__@vegpath.org` double, |
|
| 5327 |
`samplingProtocol__@DwC__@vegpath.org` varchar(255), |
|
| 5328 |
`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org` double, |
|
| 5329 |
`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org` double, |
|
| 5330 |
`stratumName__@VegX__.stratum@vegpath.org` varchar(255), |
|
| 5331 |
`communityConcept.name__@VegX__.communityDet@vegpath.org` varchar(255), |
|
| 5332 |
`observationContributor[s]__@VegBank__@vegpath.org` varchar(255), |
|
| 5333 |
`[custodial_]institutionCode[s]__@DwC__@vegpath.org` varchar(255), |
|
| 5334 |
`collectionCode__@DwC__@vegpath.org` varchar(255), |
|
| 5335 |
`catalogNumber__@DwC__@vegpath.org` varchar(255), |
|
| 5336 |
`occurrenceID__@DwC__@vegpath.org` varchar(255), |
|
| 5337 |
`recordedBy__@DwC__@vegpath.org` varchar(255), |
|
| 5338 |
`recordNumber__@DwC__@vegpath.org` varchar(255), |
|
| 5339 |
`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org` date, |
|
| 5340 |
`[verbatim_]family__@DwC__@vegpath.org` varchar(255), |
|
| 5341 |
`[verbatim_]scientificName__@DwC__@vegpath.org` varchar(255), |
|
| 5342 |
`identifiedBy__@DwC__@vegpath.org` varchar(255), |
|
| 5343 |
`dateIdentified__@DwC__@vegpath.org` date, |
|
| 5344 |
`identificationRemarks__@DwC__@vegpath.org` varchar(255), |
|
| 5345 |
`Family_matched__@TNRS__@vegpath.org` varchar(255), |
|
| 5346 |
`Name_matched__@TNRS__@vegpath.org` varchar(255), |
|
| 5347 |
`Name_matched_author__@TNRS__@vegpath.org` varchar(255), |
|
| 5348 |
`[higher_plant_group~]higherClassification__@DwC__@vegpath.org` higher_plant_group, |
|
| 5349 |
`taxonomicStatus__@DwC__@vegpath.org` varchar(255), |
|
| 5350 |
scrubbed_family varchar(255), |
|
| 5351 |
scrubbed_genus varchar(255), |
|
| 5352 |
scrubbed_specific_epithet varchar(255), |
|
| 5353 |
scrubbed_species_binomial varchar(255), |
|
| 5354 |
scrubbed_taxon_name_no_author varchar(255), |
|
| 5355 |
scrubbed_author varchar(255), |
|
| 5356 |
scrubbed_taxon_name_with_author varchar(255), |
|
| 5357 |
`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org` varchar(255), |
|
| 5358 |
`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org` growthform, |
|
| 5359 |
`reproductiveCondition__@DwC__@vegpath.org` varchar(255), |
|
| 5360 |
cultivated_bien int(11), |
|
| 5361 |
`cultivatedBasis_bien` varchar(255), |
|
| 5362 |
`occurrenceRemarks__@DwC__@vegpath.org` varchar(255), |
|
| 5363 |
`coverPercent__@VegX__.attribute.ordinal@vegpath.org` double, |
|
| 5364 |
`taxonObservation[.id]__@VegBank__@vegpath.org` varchar(255), |
|
| 5365 |
`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org` varchar(255), |
|
| 5366 |
`aggregateOrganismObservation.id__@VegX__@vegpath.org` varchar(255), |
|
| 5367 |
`individualOrganismObservation.id__@VegX__@vegpath.org` varchar(255), |
|
| 5368 |
`individualID__@DwC__@vegpath.org` varchar(255), |
|
| 5369 |
`individualCount__@DwC__@vegpath.org` int(11), |
|
| 5370 |
`plantobservation.``_id__@VegBIEN__.public@vegpath.org` int(11), |
|
| 5371 |
`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org` double, |
|
| 5372 |
`stemHeight[_m]__@VegBank__.stemCount@vegpath.org` double, |
|
| 5373 |
`[tag=]identificationLabel__@VegX__.individual@vegpath.org` varchar(255), |
|
| 5374 |
`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org` double, |
|
| 5375 |
`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org` double, |
|
| 5376 |
`stemCode__@VegBank__.stemLocation@vegpath.org` varchar(255), |
|
| 5377 |
`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org` int(11) NOT NULL |
|
| 5378 |
); |
|
| 5378 | 5379 |
|
| 5379 | 5380 |
|
| 5380 |
|
|
| 5381 | 5381 |
-- |
| 5382 |
-- Name: COLUMN analytical_plot.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5382 |
-- Name: COLUMN analytical_stem.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5383 | 5383 |
-- |
| 5384 | 5384 |
|
| 5385 | 5385 |
|
| 5386 | 5386 |
|
| 5387 | 5387 |
|
| 5388 | 5388 |
-- |
| 5389 |
-- Name: COLUMN analytical_plot.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5389 |
-- Name: COLUMN analytical_stem.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5390 | 5390 |
-- |
| 5391 | 5391 |
|
| 5392 | 5392 |
|
| 5393 | 5393 |
|
| 5394 | 5394 |
|
| 5395 | 5395 |
-- |
| 5396 |
-- Name: COLUMN analytical_plot.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5396 |
-- Name: COLUMN analytical_stem.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5397 | 5397 |
-- |
| 5398 | 5398 |
|
| 5399 | 5399 |
|
| 5400 | 5400 |
|
| 5401 | 5401 |
|
| 5402 | 5402 |
-- |
| 5403 |
-- Name: COLUMN analytical_plot.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5403 |
-- Name: COLUMN analytical_stem.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5404 | 5404 |
-- |
| 5405 | 5405 |
|
| 5406 | 5406 |
|
| 5407 | 5407 |
|
| 5408 | 5408 |
|
| 5409 | 5409 |
-- |
| 5410 |
-- Name: COLUMN analytical_plot.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5410 |
-- Name: COLUMN analytical_stem.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5411 | 5411 |
-- |
| 5412 | 5412 |
|
| 5413 | 5413 |
|
| 5414 | 5414 |
|
| 5415 | 5415 |
|
| 5416 | 5416 |
-- |
| 5417 |
-- Name: COLUMN analytical_plot.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5417 |
-- Name: COLUMN analytical_stem.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5418 | 5418 |
-- |
| 5419 | 5419 |
|
| 5420 | 5420 |
|
| 5421 | 5421 |
|
| 5422 | 5422 |
|
| 5423 | 5423 |
-- |
| 5424 |
-- Name: COLUMN analytical_plot.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
|
|
| 5424 |
-- Name: COLUMN analytical_stem.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5425 | 5425 |
-- |
| 5426 | 5426 |
|
| 5427 | 5427 |
|
| 5428 | 5428 |
|
| 5429 | 5429 |
|
| 5430 | 5430 |
-- |
| 5431 |
-- Name: COLUMN analytical_plot.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 5431 |
-- Name: COLUMN analytical_stem.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5432 | 5432 |
-- |
| 5433 | 5433 |
|
| 5434 | 5434 |
|
| 5435 | 5435 |
|
| 5436 | 5436 |
|
| 5437 | 5437 |
-- |
| 5438 |
-- Name: COLUMN analytical_plot.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5438 |
-- Name: COLUMN analytical_stem.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5439 | 5439 |
-- |
| 5440 | 5440 |
|
| 5441 | 5441 |
|
| 5442 | 5442 |
|
| 5443 | 5443 |
|
| 5444 | 5444 |
-- |
| 5445 |
-- Name: COLUMN analytical_plot.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 5445 |
-- Name: COLUMN analytical_stem.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5446 | 5446 |
-- |
| 5447 | 5447 |
|
| 5448 | 5448 |
|
| 5449 | 5449 |
|
| 5450 | 5450 |
|
| 5451 | 5451 |
-- |
| 5452 |
-- Name: COLUMN analytical_plot.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 5452 |
-- Name: COLUMN analytical_stem.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5453 | 5453 |
-- |
| 5454 | 5454 |
|
| 5455 | 5455 |
|
| 5456 | 5456 |
|
| 5457 | 5457 |
|
| 5458 | 5458 |
-- |
| 5459 |
-- Name: COLUMN analytical_plot.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5459 |
-- Name: COLUMN analytical_stem.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5460 | 5460 |
-- |
| 5461 | 5461 |
|
| 5462 | 5462 |
|
| 5463 | 5463 |
|
| 5464 | 5464 |
|
| 5465 | 5465 |
-- |
| 5466 |
-- Name: COLUMN analytical_plot.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5466 |
-- Name: COLUMN analytical_stem.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5467 | 5467 |
-- |
| 5468 | 5468 |
|
| 5469 | 5469 |
|
| 5470 | 5470 |
|
| 5471 | 5471 |
|
| 5472 | 5472 |
-- |
| 5473 |
-- Name: COLUMN analytical_plot.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5473 |
-- Name: COLUMN analytical_stem.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5474 | 5474 |
-- |
| 5475 | 5475 |
|
| 5476 | 5476 |
|
| 5477 | 5477 |
|
| 5478 | 5478 |
|
| 5479 | 5479 |
-- |
| 5480 |
-- Name: COLUMN analytical_plot.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5480 |
-- Name: COLUMN analytical_stem.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5481 | 5481 |
-- |
| 5482 | 5482 |
|
| 5483 | 5483 |
|
| 5484 | 5484 |
|
| 5485 | 5485 |
|
| 5486 | 5486 |
-- |
| 5487 |
-- Name: COLUMN analytical_plot.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5487 |
-- Name: COLUMN analytical_stem.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5488 | 5488 |
-- |
| 5489 | 5489 |
|
| 5490 | 5490 |
|
| 5491 | 5491 |
|
| 5492 | 5492 |
|
| 5493 | 5493 |
-- |
| 5494 |
-- Name: COLUMN analytical_plot.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5494 |
-- Name: COLUMN analytical_stem.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5495 | 5495 |
-- |
| 5496 | 5496 |
|
| 5497 | 5497 |
|
| 5498 | 5498 |
|
| 5499 | 5499 |
|
| 5500 | 5500 |
-- |
| 5501 |
-- Name: COLUMN analytical_plot.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5501 |
-- Name: COLUMN analytical_stem.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5502 | 5502 |
-- |
| 5503 | 5503 |
|
| 5504 | 5504 |
|
| 5505 | 5505 |
|
| 5506 | 5506 |
|
| 5507 | 5507 |
-- |
| 5508 |
-- Name: COLUMN analytical_plot.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5508 |
-- Name: COLUMN analytical_stem.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5509 | 5509 |
-- |
| 5510 | 5510 |
|
| 5511 | 5511 |
|
| 5512 | 5512 |
|
| 5513 | 5513 |
|
| 5514 | 5514 |
-- |
| 5515 |
-- Name: COLUMN analytical_plot.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5515 |
-- Name: COLUMN analytical_stem.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5516 | 5516 |
-- |
| 5517 | 5517 |
|
| 5518 | 5518 |
|
| 5519 | 5519 |
|
| 5520 | 5520 |
|
| 5521 | 5521 |
-- |
| 5522 |
-- Name: COLUMN analytical_plot.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5522 |
-- Name: COLUMN analytical_stem.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5523 | 5523 |
-- |
| 5524 | 5524 |
|
| 5525 | 5525 |
|
| 5526 | 5526 |
|
| 5527 | 5527 |
|
| 5528 | 5528 |
-- |
| 5529 |
-- Name: COLUMN analytical_plot.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5529 |
-- Name: COLUMN analytical_stem.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5530 | 5530 |
-- |
| 5531 | 5531 |
|
| 5532 | 5532 |
|
| 5533 | 5533 |
|
| 5534 | 5534 |
|
| 5535 | 5535 |
-- |
| 5536 |
-- Name: COLUMN analytical_plot.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5536 |
-- Name: COLUMN analytical_stem.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5537 | 5537 |
-- |
| 5538 | 5538 |
|
| 5539 | 5539 |
|
| 5540 | 5540 |
|
| 5541 | 5541 |
|
| 5542 | 5542 |
-- |
| 5543 |
-- Name: COLUMN analytical_plot.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5543 |
-- Name: COLUMN analytical_stem.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5544 | 5544 |
-- |
| 5545 | 5545 |
|
| 5546 | 5546 |
|
| 5547 | 5547 |
|
| 5548 | 5548 |
|
| 5549 | 5549 |
-- |
| 5550 |
-- Name: COLUMN analytical_plot.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5550 |
-- Name: COLUMN analytical_stem.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5551 | 5551 |
-- |
| 5552 | 5552 |
|
| 5553 | 5553 |
|
| 5554 | 5554 |
|
| 5555 | 5555 |
|
| 5556 | 5556 |
-- |
| 5557 |
-- Name: COLUMN analytical_plot.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5557 |
-- Name: COLUMN analytical_stem.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5558 | 5558 |
-- |
| 5559 | 5559 |
|
| 5560 | 5560 |
|
| 5561 | 5561 |
|
| 5562 | 5562 |
|
| 5563 | 5563 |
-- |
| 5564 |
-- Name: COLUMN analytical_plot.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5564 |
-- Name: COLUMN analytical_stem.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5565 | 5565 |
-- |
| 5566 | 5566 |
|
| 5567 | 5567 |
|
| 5568 | 5568 |
|
| 5569 | 5569 |
|
| 5570 | 5570 |
-- |
| 5571 |
-- Name: COLUMN analytical_plot.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5571 |
-- Name: COLUMN analytical_stem.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5572 | 5572 |
-- |
| 5573 | 5573 |
|
| 5574 | 5574 |
|
| 5575 | 5575 |
|
| 5576 | 5576 |
|
| 5577 | 5577 |
-- |
| 5578 |
-- Name: COLUMN analytical_plot.`stemCode__@VegBank__.stemLocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5578 |
-- Name: COLUMN analytical_stem.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5579 | 5579 |
-- |
| 5580 | 5580 |
|
| 5581 | 5581 |
|
| 5582 | 5582 |
|
| 5583 | 5583 |
|
| 5584 | 5584 |
-- |
| 5585 |
-- Name: analytical_specimen; Type: VIEW; Schema: public; Owner: -
|
|
| 5585 |
-- Name: COLUMN analytical_stem.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5586 | 5586 |
-- |
| 5587 | 5587 |
|
| 5588 | 5588 |
|
| 5589 | 5589 |
|
| 5590 | 5590 |
|
| 5591 | 5591 |
-- |
| 5592 |
-- Name: COLUMN analytical_specimen.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5592 |
-- Name: COLUMN analytical_stem.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5593 | 5593 |
-- |
| 5594 | 5594 |
|
| 5595 | 5595 |
|
| 5596 | 5596 |
|
| 5597 | 5597 |
|
| 5598 | 5598 |
-- |
| 5599 |
-- Name: COLUMN analytical_specimen.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5599 |
-- Name: COLUMN analytical_stem.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5600 | 5600 |
-- |
| 5601 | 5601 |
|
| 5602 | 5602 |
|
| 5603 | 5603 |
|
| 5604 | 5604 |
|
| 5605 | 5605 |
-- |
| 5606 |
-- Name: COLUMN analytical_specimen.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5606 |
-- Name: COLUMN analytical_stem.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5607 | 5607 |
-- |
| 5608 | 5608 |
|
| 5609 | 5609 |
|
| 5610 | 5610 |
|
| 5611 | 5611 |
|
| 5612 | 5612 |
-- |
| 5613 |
-- Name: COLUMN analytical_specimen.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5613 |
-- Name: COLUMN analytical_stem.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5614 | 5614 |
-- |
| 5615 | 5615 |
|
| 5616 | 5616 |
|
| 5617 | 5617 |
|
| 5618 | 5618 |
|
| 5619 | 5619 |
-- |
| 5620 |
-- Name: COLUMN analytical_specimen.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5620 |
-- Name: COLUMN analytical_stem.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5621 | 5621 |
-- |
| 5622 | 5622 |
|
| 5623 | 5623 |
|
| 5624 | 5624 |
|
| 5625 | 5625 |
|
| 5626 | 5626 |
-- |
| 5627 |
-- Name: COLUMN analytical_specimen.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5627 |
-- Name: COLUMN analytical_stem.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5628 | 5628 |
-- |
| 5629 | 5629 |
|
| 5630 | 5630 |
|
| 5631 | 5631 |
|
| 5632 | 5632 |
|
| 5633 | 5633 |
-- |
| 5634 |
-- Name: COLUMN analytical_specimen.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5634 |
-- Name: COLUMN analytical_stem.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5635 | 5635 |
-- |
| 5636 | 5636 |
|
| 5637 | 5637 |
|
| 5638 | 5638 |
|
| 5639 | 5639 |
|
| 5640 | 5640 |
-- |
| 5641 |
-- Name: COLUMN analytical_specimen.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5641 |
-- Name: COLUMN analytical_stem.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5642 | 5642 |
-- |
| 5643 | 5643 |
|
| 5644 | 5644 |
|
| 5645 | 5645 |
|
| 5646 | 5646 |
|
| 5647 | 5647 |
-- |
| 5648 |
-- Name: COLUMN analytical_specimen.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5648 |
-- Name: COLUMN analytical_stem.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5649 | 5649 |
-- |
| 5650 | 5650 |
|
| 5651 | 5651 |
|
| 5652 | 5652 |
|
| 5653 | 5653 |
|
| 5654 | 5654 |
-- |
Also available in: Unified diff
schemas/public_.sql: validation views: use analytical_stem_view instead of analytical_stem because analytical_stem is no longer materialized (viewFullOccurrence_individual_view is materialized instead)