Revision 14672
Added by Aaron Marcuse-Kubitza about 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 4323 | 4323 |
|
| 4324 | 4324 |
|
| 4325 | 4325 |
-- |
| 4326 |
-- Name: COLUMN analytical_stem.plantobservation_id; Type: COMMENT; Schema: public; Owner: - |
|
| 4327 |
-- |
|
| 4328 |
|
|
| 4329 |
|
|
| 4330 |
|
|
| 4331 |
|
|
| 4332 |
-- |
|
| 4333 |
-- Name: COLUMN analytical_stem.taxonobservation_id; Type: COMMENT; Schema: public; Owner: - |
|
| 4334 |
-- |
|
| 4335 |
|
|
| 4336 |
|
|
| 4337 |
|
|
| 4338 |
|
|
| 4339 |
-- |
|
| 4326 | 4340 |
-- Name: COLUMN analytical_stem.stem_dbh_cm; Type: COMMENT; Schema: public; Owner: - |
| 4327 | 4341 |
-- |
| 4328 | 4342 |
|
| ... | ... | |
| 4561 | 4575 |
|
| 4562 | 4576 |
|
| 4563 | 4577 |
-- |
| 4578 |
-- Name: COLUMN analytical_plot.datasource; Type: COMMENT; Schema: public; Owner: - |
|
| 4579 |
-- |
|
| 4580 |
|
|
| 4581 |
|
|
| 4582 |
|
|
| 4583 |
|
|
| 4584 |
-- |
|
| 4585 |
-- Name: COLUMN analytical_plot.country; Type: COMMENT; Schema: public; Owner: - |
|
| 4586 |
-- |
|
| 4587 |
|
|
| 4588 |
|
|
| 4589 |
|
|
| 4590 |
|
|
| 4591 |
-- |
|
| 4592 |
-- Name: COLUMN analytical_plot.state_province; Type: COMMENT; Schema: public; Owner: - |
|
| 4593 |
-- |
|
| 4594 |
|
|
| 4595 |
|
|
| 4596 |
|
|
| 4597 |
|
|
| 4598 |
-- |
|
| 4599 |
-- Name: COLUMN analytical_plot.county; Type: COMMENT; Schema: public; Owner: - |
|
| 4600 |
-- |
|
| 4601 |
|
|
| 4602 |
|
|
| 4603 |
|
|
| 4604 |
|
|
| 4605 |
-- |
|
| 4606 |
-- Name: COLUMN analytical_plot.locality; Type: COMMENT; Schema: public; Owner: - |
|
| 4607 |
-- |
|
| 4608 |
|
|
| 4609 |
|
|
| 4610 |
|
|
| 4611 |
|
|
| 4612 |
-- |
|
| 4613 |
-- Name: COLUMN analytical_plot.latitude; Type: COMMENT; Schema: public; Owner: - |
|
| 4614 |
-- |
|
| 4615 |
|
|
| 4616 |
|
|
| 4617 |
|
|
| 4618 |
|
|
| 4619 |
-- |
|
| 4620 |
-- Name: COLUMN analytical_plot.longitude; Type: COMMENT; Schema: public; Owner: - |
|
| 4621 |
-- |
|
| 4622 |
|
|
| 4623 |
|
|
| 4624 |
|
|
| 4625 |
|
|
| 4626 |
-- |
|
| 4627 |
-- Name: COLUMN analytical_plot.coord_uncertainty_m; Type: COMMENT; Schema: public; Owner: - |
|
| 4628 |
-- |
|
| 4629 |
|
|
| 4630 |
|
|
| 4631 |
|
|
| 4632 |
|
|
| 4633 |
-- |
|
| 4634 |
-- Name: COLUMN analytical_plot.georef_sources; Type: COMMENT; Schema: public; Owner: - |
|
| 4635 |
-- |
|
| 4636 |
|
|
| 4637 |
|
|
| 4638 |
|
|
| 4639 |
|
|
| 4640 |
-- |
|
| 4641 |
-- Name: COLUMN analytical_plot.georef_protocol; Type: COMMENT; Schema: public; Owner: - |
|
| 4642 |
-- |
|
| 4643 |
|
|
| 4644 |
|
|
| 4645 |
|
|
| 4646 |
|
|
| 4647 |
-- |
|
| 4648 |
-- Name: COLUMN analytical_plot.is_geovalid; Type: COMMENT; Schema: public; Owner: - |
|
| 4649 |
-- |
|
| 4650 |
|
|
| 4651 |
|
|
| 4652 |
|
|
| 4653 |
|
|
| 4654 |
-- |
|
| 4655 |
-- Name: COLUMN analytical_plot.is_new_world; Type: COMMENT; Schema: public; Owner: - |
|
| 4656 |
-- |
|
| 4657 |
|
|
| 4658 |
|
|
| 4659 |
|
|
| 4660 |
|
|
| 4661 |
-- |
|
| 4662 |
-- Name: COLUMN analytical_plot.project_id; Type: COMMENT; Schema: public; Owner: - |
|
| 4663 |
-- |
|
| 4664 |
|
|
| 4665 |
|
|
| 4666 |
|
|
| 4667 |
|
|
| 4668 |
-- |
|
| 4669 |
-- Name: COLUMN analytical_plot.project_contributors; Type: COMMENT; Schema: public; Owner: - |
|
| 4670 |
-- |
|
| 4671 |
|
|
| 4672 |
|
|
| 4673 |
|
|
| 4674 |
|
|
| 4675 |
-- |
|
| 4676 |
-- Name: COLUMN analytical_plot.location_id; Type: COMMENT; Schema: public; Owner: - |
|
| 4677 |
-- |
|
| 4678 |
|
|
| 4679 |
|
|
| 4680 |
|
|
| 4681 |
|
|
| 4682 |
-- |
|
| 4683 |
-- Name: COLUMN analytical_plot.plot_name; Type: COMMENT; Schema: public; Owner: - |
|
| 4684 |
-- |
|
| 4685 |
|
|
| 4686 |
|
|
| 4687 |
|
|
| 4688 |
|
|
| 4689 |
-- |
|
| 4690 |
-- Name: COLUMN analytical_plot.subplot; Type: COMMENT; Schema: public; Owner: - |
|
| 4691 |
-- |
|
| 4692 |
|
|
| 4693 |
|
|
| 4694 |
|
|
| 4695 |
|
|
| 4696 |
-- |
|
| 4697 |
-- Name: COLUMN analytical_plot.is_location_cultivated; Type: COMMENT; Schema: public; Owner: - |
|
| 4698 |
-- |
|
| 4699 |
|
|
| 4700 |
|
|
| 4701 |
|
|
| 4702 |
|
|
| 4703 |
-- |
|
| 4704 |
-- Name: COLUMN analytical_plot.event_date; Type: COMMENT; Schema: public; Owner: - |
|
| 4705 |
-- |
|
| 4706 |
|
|
| 4707 |
|
|
| 4708 |
|
|
| 4709 |
|
|
| 4710 |
-- |
|
| 4711 |
-- Name: COLUMN analytical_plot.elevation_m; Type: COMMENT; Schema: public; Owner: - |
|
| 4712 |
-- |
|
| 4713 |
|
|
| 4714 |
|
|
| 4715 |
|
|
| 4716 |
|
|
| 4717 |
-- |
|
| 4718 |
-- Name: COLUMN analytical_plot.slope_aspect_deg; Type: COMMENT; Schema: public; Owner: - |
|
| 4719 |
-- |
|
| 4720 |
|
|
| 4721 |
|
|
| 4722 |
|
|
| 4723 |
|
|
| 4724 |
-- |
|
| 4725 |
-- Name: COLUMN analytical_plot.slope_gradient_deg; Type: COMMENT; Schema: public; Owner: - |
|
| 4726 |
-- |
|
| 4727 |
|
|
| 4728 |
|
|
| 4729 |
|
|
| 4730 |
|
|
| 4731 |
-- |
|
| 4732 |
-- Name: COLUMN analytical_plot.plot_area_ha; Type: COMMENT; Schema: public; Owner: - |
|
| 4733 |
-- |
|
| 4734 |
|
|
| 4735 |
|
|
| 4736 |
|
|
| 4737 |
|
|
| 4738 |
-- |
|
| 4739 |
-- Name: COLUMN analytical_plot.sampling_protocol; Type: COMMENT; Schema: public; Owner: - |
|
| 4740 |
-- |
|
| 4741 |
|
|
| 4742 |
|
|
| 4743 |
|
|
| 4744 |
|
|
| 4745 |
-- |
|
| 4746 |
-- Name: COLUMN analytical_plot.temperature_c; Type: COMMENT; Schema: public; Owner: - |
|
| 4747 |
-- |
|
| 4748 |
|
|
| 4749 |
|
|
| 4750 |
|
|
| 4751 |
|
|
| 4752 |
-- |
|
| 4753 |
-- Name: COLUMN analytical_plot.precip_mm; Type: COMMENT; Schema: public; Owner: - |
|
| 4754 |
-- |
|
| 4755 |
|
|
| 4756 |
|
|
| 4757 |
|
|
| 4758 |
|
|
| 4759 |
-- |
|
| 4760 |
-- Name: COLUMN analytical_plot.stratum_name; Type: COMMENT; Schema: public; Owner: - |
|
| 4761 |
-- |
|
| 4762 |
|
|
| 4763 |
|
|
| 4764 |
|
|
| 4765 |
|
|
| 4766 |
-- |
|
| 4767 |
-- Name: COLUMN analytical_plot.community_concept_name; Type: COMMENT; Schema: public; Owner: - |
|
| 4768 |
-- |
|
| 4769 |
|
|
| 4770 |
|
|
| 4771 |
|
|
| 4772 |
|
|
| 4773 |
-- |
|
| 4774 |
-- Name: COLUMN analytical_plot.observation_contributors; Type: COMMENT; Schema: public; Owner: - |
|
| 4775 |
-- |
|
| 4776 |
|
|
| 4777 |
|
|
| 4778 |
|
|
| 4779 |
|
|
| 4780 |
-- |
|
| 4781 |
-- Name: COLUMN analytical_plot.recorded_by; Type: COMMENT; Schema: public; Owner: - |
|
| 4782 |
-- |
|
| 4783 |
|
|
| 4784 |
|
|
| 4785 |
|
|
| 4786 |
|
|
| 4787 |
-- |
|
| 4788 |
-- Name: COLUMN analytical_plot.record_number; Type: COMMENT; Schema: public; Owner: - |
|
| 4789 |
-- |
|
| 4790 |
|
|
| 4791 |
|
|
| 4792 |
|
|
| 4793 |
|
|
| 4794 |
-- |
|
| 4795 |
-- Name: COLUMN analytical_plot.date_collected; Type: COMMENT; Schema: public; Owner: - |
|
| 4796 |
-- |
|
| 4797 |
|
|
| 4798 |
|
|
| 4799 |
|
|
| 4800 |
|
|
| 4801 |
-- |
|
| 4802 |
-- Name: COLUMN analytical_plot.verbatim_family; Type: COMMENT; Schema: public; Owner: - |
|
| 4803 |
-- |
|
| 4804 |
|
|
| 4805 |
|
|
| 4806 |
|
|
| 4807 |
|
|
| 4808 |
-- |
|
| 4809 |
-- Name: COLUMN analytical_plot.verbatim_scientific_name; Type: COMMENT; Schema: public; Owner: - |
|
| 4810 |
-- |
|
| 4811 |
|
|
| 4812 |
|
|
| 4813 |
|
|
| 4814 |
|
|
| 4815 |
-- |
|
| 4816 |
-- Name: COLUMN analytical_plot.identified_by; Type: COMMENT; Schema: public; Owner: - |
|
| 4817 |
-- |
|
| 4818 |
|
|
| 4819 |
|
|
| 4820 |
|
|
| 4821 |
|
|
| 4822 |
-- |
|
| 4823 |
-- Name: COLUMN analytical_plot.date_identified; Type: COMMENT; Schema: public; Owner: - |
|
| 4824 |
-- |
|
| 4825 |
|
|
| 4826 |
|
|
| 4827 |
|
|
| 4828 |
|
|
| 4829 |
-- |
|
| 4830 |
-- Name: COLUMN analytical_plot.identification_remarks; Type: COMMENT; Schema: public; Owner: - |
|
| 4831 |
-- |
|
| 4832 |
|
|
| 4833 |
|
|
| 4834 |
|
|
| 4835 |
|
|
| 4836 |
-- |
|
| 4837 |
-- Name: COLUMN analytical_plot.family_matched; Type: COMMENT; Schema: public; Owner: - |
|
| 4838 |
-- |
|
| 4839 |
|
|
| 4840 |
|
|
| 4841 |
|
|
| 4842 |
|
|
| 4843 |
-- |
|
| 4844 |
-- Name: COLUMN analytical_plot.name_matched; Type: COMMENT; Schema: public; Owner: - |
|
| 4845 |
-- |
|
| 4846 |
|
|
| 4847 |
|
|
| 4848 |
|
|
| 4849 |
|
|
| 4850 |
-- |
|
| 4851 |
-- Name: COLUMN analytical_plot.name_matched_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4852 |
-- |
|
| 4853 |
|
|
| 4854 |
|
|
| 4855 |
|
|
| 4856 |
|
|
| 4857 |
-- |
|
| 4858 |
-- Name: COLUMN analytical_plot.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 4859 |
-- |
|
| 4860 |
|
|
| 4861 |
|
|
| 4862 |
|
|
| 4863 |
|
|
| 4864 |
-- |
|
| 4865 |
-- Name: COLUMN analytical_plot.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 4866 |
-- |
|
| 4867 |
|
|
| 4868 |
|
|
| 4869 |
|
|
| 4870 |
|
|
| 4871 |
-- |
|
| 4872 |
-- Name: COLUMN analytical_plot.scrubbed_species_binomial_with_morphospecies; Type: COMMENT; Schema: public; Owner: - |
|
| 4873 |
-- |
|
| 4874 |
|
|
| 4875 |
|
|
| 4876 |
|
|
| 4877 |
|
|
| 4878 |
-- |
|
| 4879 |
-- Name: COLUMN analytical_plot.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4880 |
-- |
|
| 4881 |
|
|
| 4882 |
|
|
| 4883 |
|
|
| 4884 |
|
|
| 4885 |
-- |
|
| 4886 |
-- Name: COLUMN analytical_plot.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4887 |
-- |
|
| 4888 |
|
|
| 4889 |
|
|
| 4890 |
|
|
| 4891 |
|
|
| 4892 |
-- |
|
| 4893 |
-- Name: COLUMN analytical_plot.growth_form; Type: COMMENT; Schema: public; Owner: - |
|
| 4894 |
-- |
|
| 4895 |
|
|
| 4896 |
|
|
| 4897 |
|
|
| 4898 |
|
|
| 4899 |
-- |
|
| 4900 |
-- Name: COLUMN analytical_plot.reproductive_condition; Type: COMMENT; Schema: public; Owner: - |
|
| 4901 |
-- |
|
| 4902 |
|
|
| 4903 |
|
|
| 4904 |
|
|
| 4905 |
|
|
| 4906 |
-- |
|
| 4907 |
-- Name: COLUMN analytical_plot.is_cultivated; Type: COMMENT; Schema: public; Owner: - |
|
| 4908 |
-- |
|
| 4909 |
|
|
| 4910 |
|
|
| 4911 |
|
|
| 4912 |
|
|
| 4913 |
-- |
|
| 4914 |
-- Name: COLUMN analytical_plot.is_cultivated_basis; Type: COMMENT; Schema: public; Owner: - |
|
| 4915 |
-- |
|
| 4916 |
|
|
| 4917 |
|
|
| 4918 |
|
|
| 4919 |
|
|
| 4920 |
-- |
|
| 4921 |
-- Name: COLUMN analytical_plot.occurrence_remarks; Type: COMMENT; Schema: public; Owner: - |
|
| 4922 |
-- |
|
| 4923 |
|
|
| 4924 |
|
|
| 4925 |
|
|
| 4926 |
|
|
| 4927 |
-- |
|
| 4928 |
-- Name: COLUMN analytical_plot.cover_percent; Type: COMMENT; Schema: public; Owner: - |
|
| 4929 |
-- |
|
| 4930 |
|
|
| 4931 |
|
|
| 4932 |
|
|
| 4933 |
|
|
| 4934 |
-- |
|
| 4935 |
-- Name: COLUMN analytical_plot.stem_dbh_cm; Type: COMMENT; Schema: public; Owner: - |
|
| 4936 |
-- |
|
| 4937 |
|
|
| 4938 |
|
|
| 4939 |
|
|
| 4940 |
|
|
| 4941 |
-- |
|
| 4942 |
-- Name: COLUMN analytical_plot.stem_height_m; Type: COMMENT; Schema: public; Owner: - |
|
| 4943 |
-- |
|
| 4944 |
|
|
| 4945 |
|
|
| 4946 |
|
|
| 4947 |
|
|
| 4948 |
-- |
|
| 4949 |
-- Name: COLUMN analytical_plot.tag; Type: COMMENT; Schema: public; Owner: - |
|
| 4950 |
-- |
|
| 4951 |
|
|
| 4952 |
|
|
| 4953 |
|
|
| 4954 |
|
|
| 4955 |
-- |
|
| 4956 |
-- Name: COLUMN analytical_plot.relative_x_m; Type: COMMENT; Schema: public; Owner: - |
|
| 4957 |
-- |
|
| 4958 |
|
|
| 4959 |
|
|
| 4960 |
|
|
| 4961 |
|
|
| 4962 |
-- |
|
| 4963 |
-- Name: COLUMN analytical_plot.relative_y_m; Type: COMMENT; Schema: public; Owner: - |
|
| 4964 |
-- |
|
| 4965 |
|
|
| 4966 |
|
|
| 4967 |
|
|
| 4968 |
|
|
| 4969 |
-- |
|
| 4970 |
-- Name: COLUMN analytical_plot.taxon_observation_id; Type: COMMENT; Schema: public; Owner: - |
|
| 4971 |
-- |
|
| 4972 |
|
|
| 4973 |
|
|
| 4974 |
|
|
| 4975 |
|
|
| 4976 |
-- |
|
| 4977 |
-- Name: COLUMN analytical_plot.taxon_name_usage_concept_author_code; Type: COMMENT; Schema: public; Owner: - |
|
| 4978 |
-- |
|
| 4979 |
|
|
| 4980 |
|
|
| 4981 |
|
|
| 4982 |
|
|
| 4983 |
-- |
|
| 4984 |
-- Name: COLUMN analytical_plot.aggregate_organism_observation_id; Type: COMMENT; Schema: public; Owner: - |
|
| 4985 |
-- |
|
| 4986 |
|
|
| 4987 |
|
|
| 4988 |
|
|
| 4989 |
|
|
| 4990 |
-- |
|
| 4991 |
-- Name: COLUMN analytical_plot.individual_organism_observation_id; Type: COMMENT; Schema: public; Owner: - |
|
| 4992 |
-- |
|
| 4993 |
|
|
| 4994 |
|
|
| 4995 |
|
|
| 4996 |
|
|
| 4997 |
-- |
|
| 4998 |
-- Name: COLUMN analytical_plot.individual_id; Type: COMMENT; Schema: public; Owner: - |
|
| 4999 |
-- |
|
| 5000 |
|
|
| 5001 |
|
|
| 5002 |
|
|
| 5003 |
|
|
| 5004 |
-- |
|
| 5005 |
-- Name: COLUMN analytical_plot.individual_count; Type: COMMENT; Schema: public; Owner: - |
|
| 5006 |
-- |
|
| 5007 |
|
|
| 5008 |
|
|
| 5009 |
|
|
| 5010 |
|
|
| 5011 |
-- |
|
| 5012 |
-- Name: COLUMN analytical_plot.stem_code; Type: COMMENT; Schema: public; Owner: - |
|
| 5013 |
-- |
|
| 5014 |
|
|
| 5015 |
|
|
| 5016 |
|
|
| 5017 |
|
|
| 5018 |
-- |
|
| 4564 | 5019 |
-- Name: analytical_specimen; Type: VIEW; Schema: public; Owner: - |
| 4565 | 5020 |
-- |
| 4566 | 5021 |
|
| ... | ... | |
| 4568 | 5023 |
|
| 4569 | 5024 |
|
| 4570 | 5025 |
-- |
| 5026 |
-- Name: COLUMN analytical_specimen.datasource; Type: COMMENT; Schema: public; Owner: - |
|
| 5027 |
-- |
|
| 5028 |
|
|
| 5029 |
|
|
| 5030 |
|
|
| 5031 |
|
|
| 5032 |
-- |
|
| 5033 |
-- Name: COLUMN analytical_specimen.country; Type: COMMENT; Schema: public; Owner: - |
|
| 5034 |
-- |
|
| 5035 |
|
|
| 5036 |
|
|
| 5037 |
|
|
| 5038 |
|
|
| 5039 |
-- |
|
| 5040 |
-- Name: COLUMN analytical_specimen.state_province; Type: COMMENT; Schema: public; Owner: - |
|
| 5041 |
-- |
|
| 5042 |
|
|
| 5043 |
|
|
| 5044 |
|
|
| 5045 |
|
|
| 5046 |
-- |
|
| 5047 |
-- Name: COLUMN analytical_specimen.county; Type: COMMENT; Schema: public; Owner: - |
|
| 5048 |
-- |
|
| 5049 |
|
|
| 5050 |
|
|
| 5051 |
|
|
| 5052 |
|
|
| 5053 |
-- |
|
| 5054 |
-- Name: COLUMN analytical_specimen.locality; Type: COMMENT; Schema: public; Owner: - |
|
| 5055 |
-- |
|
| 5056 |
|
|
| 5057 |
|
|
| 5058 |
|
|
| 5059 |
|
|
| 5060 |
-- |
|
| 5061 |
-- Name: COLUMN analytical_specimen.latitude; Type: COMMENT; Schema: public; Owner: - |
|
| 5062 |
-- |
|
| 5063 |
|
|
| 5064 |
|
|
| 5065 |
|
|
| 5066 |
|
|
| 5067 |
-- |
|
| 5068 |
-- Name: COLUMN analytical_specimen.longitude; Type: COMMENT; Schema: public; Owner: - |
|
| 5069 |
-- |
|
| 5070 |
|
|
| 5071 |
|
|
| 5072 |
|
|
| 5073 |
|
|
| 5074 |
-- |
|
| 5075 |
-- Name: COLUMN analytical_specimen.coord_uncertainty_m; Type: COMMENT; Schema: public; Owner: - |
|
| 5076 |
-- |
|
| 5077 |
|
|
| 5078 |
|
|
| 5079 |
|
|
| 5080 |
|
|
| 5081 |
-- |
|
| 5082 |
-- Name: COLUMN analytical_specimen.georef_sources; Type: COMMENT; Schema: public; Owner: - |
|
| 5083 |
-- |
|
| 5084 |
|
|
| 5085 |
|
|
| 5086 |
|
|
| 5087 |
|
|
| 5088 |
-- |
|
| 5089 |
-- Name: COLUMN analytical_specimen.georef_protocol; Type: COMMENT; Schema: public; Owner: - |
|
| 5090 |
-- |
|
| 5091 |
|
|
| 5092 |
|
|
| 5093 |
|
|
| 5094 |
|
|
| 5095 |
-- |
|
| 5096 |
-- Name: COLUMN analytical_specimen.is_geovalid; Type: COMMENT; Schema: public; Owner: - |
|
| 5097 |
-- |
|
| 5098 |
|
|
| 5099 |
|
|
| 5100 |
|
|
| 5101 |
|
|
| 5102 |
-- |
|
| 5103 |
-- Name: COLUMN analytical_specimen.is_new_world; Type: COMMENT; Schema: public; Owner: - |
|
| 5104 |
-- |
|
| 5105 |
|
|
| 5106 |
|
|
| 5107 |
|
|
| 5108 |
|
|
| 5109 |
-- |
|
| 5110 |
-- Name: COLUMN analytical_specimen.is_location_cultivated; Type: COMMENT; Schema: public; Owner: - |
|
| 5111 |
-- |
|
| 5112 |
|
|
| 5113 |
|
|
| 5114 |
|
|
| 5115 |
|
|
| 5116 |
-- |
|
| 5117 |
-- Name: COLUMN analytical_specimen.event_date; Type: COMMENT; Schema: public; Owner: - |
|
| 5118 |
-- |
|
| 5119 |
|
|
| 5120 |
|
|
| 5121 |
|
|
| 5122 |
|
|
| 5123 |
-- |
|
| 5124 |
-- Name: COLUMN analytical_specimen.elevation_m; Type: COMMENT; Schema: public; Owner: - |
|
| 5125 |
-- |
|
| 5126 |
|
|
| 5127 |
|
|
| 5128 |
|
|
| 5129 |
|
|
| 5130 |
-- |
|
| 5131 |
-- Name: COLUMN analytical_specimen.temperature_c; Type: COMMENT; Schema: public; Owner: - |
|
| 5132 |
-- |
|
| 5133 |
|
|
| 5134 |
|
|
| 5135 |
|
|
| 5136 |
|
|
| 5137 |
-- |
|
| 5138 |
-- Name: COLUMN analytical_specimen.precip_mm; Type: COMMENT; Schema: public; Owner: - |
|
| 5139 |
-- |
|
| 5140 |
|
|
| 5141 |
|
|
| 5142 |
|
|
| 5143 |
|
|
| 5144 |
-- |
|
| 5145 |
-- Name: COLUMN analytical_specimen.custodial_institution_codes; Type: COMMENT; Schema: public; Owner: - |
|
| 5146 |
-- |
|
| 5147 |
|
|
| 5148 |
|
|
| 5149 |
|
|
| 5150 |
|
|
| 5151 |
-- |
|
| 5152 |
-- Name: COLUMN analytical_specimen.collection_code; Type: COMMENT; Schema: public; Owner: - |
|
| 5153 |
-- |
|
| 5154 |
|
|
| 5155 |
|
|
| 5156 |
|
|
| 5157 |
|
|
| 5158 |
-- |
|
| 5159 |
-- Name: COLUMN analytical_specimen.catalog_number; Type: COMMENT; Schema: public; Owner: - |
|
| 5160 |
-- |
|
| 5161 |
|
|
| 5162 |
|
|
| 5163 |
|
|
| 5164 |
|
|
| 5165 |
-- |
|
| 5166 |
-- Name: COLUMN analytical_specimen.occurrence_id; Type: COMMENT; Schema: public; Owner: - |
|
| 5167 |
-- |
|
| 5168 |
|
|
| 5169 |
|
|
| 5170 |
|
|
| 5171 |
|
|
| 5172 |
-- |
|
| 5173 |
-- Name: COLUMN analytical_specimen.recorded_by; Type: COMMENT; Schema: public; Owner: - |
|
| 5174 |
-- |
|
| 5175 |
|
|
| 5176 |
|
|
| 5177 |
|
|
| 5178 |
|
|
| 5179 |
-- |
|
| 5180 |
-- Name: COLUMN analytical_specimen.record_number; Type: COMMENT; Schema: public; Owner: - |
|
| 5181 |
-- |
|
| 5182 |
|
|
| 5183 |
|
|
| 5184 |
|
|
| 5185 |
|
|
| 5186 |
-- |
|
| 5187 |
-- Name: COLUMN analytical_specimen.date_collected; Type: COMMENT; Schema: public; Owner: - |
|
| 5188 |
-- |
|
| 5189 |
|
|
| 5190 |
|
|
| 5191 |
|
|
| 5192 |
|
|
| 5193 |
-- |
|
| 5194 |
-- Name: COLUMN analytical_specimen.verbatim_family; Type: COMMENT; Schema: public; Owner: - |
|
| 5195 |
-- |
|
| 5196 |
|
|
| 5197 |
|
|
| 5198 |
|
|
| 5199 |
|
|
| 5200 |
-- |
|
| 5201 |
-- Name: COLUMN analytical_specimen.verbatim_scientific_name; Type: COMMENT; Schema: public; Owner: - |
|
| 5202 |
-- |
|
| 5203 |
|
|
| 5204 |
|
|
| 5205 |
|
|
| 5206 |
|
|
| 5207 |
-- |
|
| 5208 |
-- Name: COLUMN analytical_specimen.identified_by; Type: COMMENT; Schema: public; Owner: - |
|
| 5209 |
-- |
|
| 5210 |
|
|
| 5211 |
|
|
| 5212 |
|
|
| 5213 |
|
|
| 5214 |
-- |
|
| 5215 |
-- Name: COLUMN analytical_specimen.date_identified; Type: COMMENT; Schema: public; Owner: - |
|
| 5216 |
-- |
|
| 5217 |
|
|
| 5218 |
|
|
| 5219 |
|
|
| 5220 |
|
|
| 5221 |
-- |
|
| 5222 |
-- Name: COLUMN analytical_specimen.identification_remarks; Type: COMMENT; Schema: public; Owner: - |
|
| 5223 |
-- |
|
| 5224 |
|
|
| 5225 |
|
|
| 5226 |
|
|
| 5227 |
|
|
| 5228 |
-- |
|
| 5229 |
-- Name: COLUMN analytical_specimen.family_matched; Type: COMMENT; Schema: public; Owner: - |
|
| 5230 |
-- |
|
| 5231 |
|
|
| 5232 |
|
|
| 5233 |
|
|
| 5234 |
|
|
| 5235 |
-- |
|
| 5236 |
-- Name: COLUMN analytical_specimen.name_matched; Type: COMMENT; Schema: public; Owner: - |
|
| 5237 |
-- |
|
| 5238 |
|
|
| 5239 |
|
|
| 5240 |
|
|
| 5241 |
|
|
| 5242 |
-- |
|
| 5243 |
-- Name: COLUMN analytical_specimen.name_matched_author; Type: COMMENT; Schema: public; Owner: - |
|
| 5244 |
-- |
|
| 5245 |
|
|
| 5246 |
|
|
| 5247 |
|
|
| 5248 |
|
|
| 5249 |
-- |
|
| 5250 |
-- Name: COLUMN analytical_specimen.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 5251 |
-- |
|
| 5252 |
|
|
| 5253 |
|
|
| 5254 |
|
|
| 5255 |
|
|
| 5256 |
-- |
|
| 5257 |
-- Name: COLUMN analytical_specimen.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 5258 |
-- |
|
| 5259 |
|
|
| 5260 |
|
|
| 5261 |
|
|
| 5262 |
|
|
| 5263 |
-- |
|
| 5264 |
-- Name: COLUMN analytical_specimen.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 5265 |
-- |
|
| 5266 |
|
|
| 5267 |
|
|
| 5268 |
|
|
| 5269 |
|
|
| 5270 |
-- |
|
| 5271 |
-- Name: COLUMN analytical_specimen.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 5272 |
-- |
|
| 5273 |
|
|
| 5274 |
|
|
| 5275 |
|
|
| 5276 |
|
|
| 5277 |
-- |
|
| 5278 |
-- Name: COLUMN analytical_specimen.growth_form; Type: COMMENT; Schema: public; Owner: - |
|
| 5279 |
-- |
|
| 5280 |
|
|
| 5281 |
|
|
| 5282 |
|
|
| 5283 |
|
|
| 5284 |
-- |
|
| 5285 |
-- Name: COLUMN analytical_specimen.reproductive_condition; Type: COMMENT; Schema: public; Owner: - |
|
| 5286 |
-- |
|
| 5287 |
|
|
| 5288 |
|
|
| 5289 |
|
|
| 5290 |
|
|
| 5291 |
-- |
|
| 5292 |
-- Name: COLUMN analytical_specimen.is_cultivated; Type: COMMENT; Schema: public; Owner: - |
|
| 5293 |
-- |
|
| 5294 |
|
|
| 5295 |
|
|
| 5296 |
|
|
| 5297 |
|
|
| 5298 |
-- |
|
| 5299 |
-- Name: COLUMN analytical_specimen.is_cultivated_basis; Type: COMMENT; Schema: public; Owner: - |
|
| 5300 |
-- |
|
| 5301 |
|
|
| 5302 |
|
|
| 5303 |
|
|
| 5304 |
|
|
| 5305 |
-- |
|
| 5306 |
-- Name: COLUMN analytical_specimen.occurrence_remarks; Type: COMMENT; Schema: public; Owner: - |
|
| 5307 |
-- |
|
| 5308 |
|
|
| 5309 |
|
|
| 5310 |
|
|
| 5311 |
|
|
| 5312 |
-- |
|
| 5313 |
-- Name: COLUMN analytical_specimen.stem_dbh_cm; Type: COMMENT; Schema: public; Owner: - |
|
| 5314 |
-- |
|
| 5315 |
|
|
| 5316 |
|
|
| 5317 |
|
|
| 5318 |
|
|
| 5319 |
-- |
|
| 5320 |
-- Name: COLUMN analytical_specimen.stem_height_m; Type: COMMENT; Schema: public; Owner: - |
|
| 5321 |
-- |
|
| 5322 |
|
|
| 5323 |
|
|
| 5324 |
|
|
| 5325 |
|
|
| 5326 |
-- |
|
| 5327 |
-- Name: COLUMN analytical_specimen.tag; Type: COMMENT; Schema: public; Owner: - |
|
| 5328 |
-- |
|
| 5329 |
|
|
| 5330 |
|
|
| 5331 |
|
|
| 5332 |
|
|
| 5333 |
-- |
|
| 4571 | 5334 |
-- Name: analytical_stem_GBIF; Type: VIEW; Schema: public; Owner: - |
| 4572 | 5335 |
-- |
| 4573 | 5336 |
|
Also available in: Unified diff
bugfix: schemas/public_.sql: view_full_occurrence_individual_view and related views: synced to data dictionary spreadsheet, which adds back the links to the definitions (which used to be part of the column name itself)