Revision 14338
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 3285 | 3285 |
`cultivatedBasis_bien` varchar(255), |
| 3286 | 3286 |
`occurrenceRemarks__@DwC__@vegpath.org` varchar(255), |
| 3287 | 3287 |
`coverPercent__@VegX__.attribute.ordinal@vegpath.org` double, |
| 3288 |
`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org` double, |
|
| 3289 |
`stemHeight[_m]__@VegBank__.stemCount@vegpath.org` double, |
|
| 3290 |
`[tag=]identificationLabel__@VegX__.individual@vegpath.org` varchar(255), |
|
| 3291 |
`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org` double, |
|
| 3292 |
`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org` double, |
|
| 3293 | 3288 |
`taxonObservation[.id]__@VegBank__@vegpath.org` varchar(255), |
| 3294 | 3289 |
`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org` varchar(255), |
| 3295 | 3290 |
`aggregateOrganismObservation.id__@VegX__@vegpath.org` varchar(255), |
| 3296 | 3291 |
`individualOrganismObservation.id__@VegX__@vegpath.org` varchar(255), |
| 3297 | 3292 |
`individualID__@DwC__@vegpath.org` varchar(255), |
| 3298 | 3293 |
`individualCount__@DwC__@vegpath.org` int(11), |
| 3294 |
`plantobservation.``_id__@VegBIEN__.public@vegpath.org` int(11), |
|
| 3295 |
`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org` double, |
|
| 3296 |
`stemHeight[_m]__@VegBank__.stemCount@vegpath.org` double, |
|
| 3297 |
`[tag=]identificationLabel__@VegX__.individual@vegpath.org` varchar(255), |
|
| 3298 |
`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org` double, |
|
| 3299 |
`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org` double, |
|
| 3299 | 3300 |
`stemCode__@VegBank__.stemLocation@vegpath.org` varchar(255), |
| 3300 | 3301 |
`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org` int(11) NOT NULL |
| 3301 | 3302 |
); |
| ... | ... | |
| 3729 | 3730 |
|
| 3730 | 3731 |
|
| 3731 | 3732 |
-- |
| 3732 |
-- Name: COLUMN analytical_stem.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3733 |
-- Name: COLUMN analytical_stem.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3733 | 3734 |
-- |
| 3734 | 3735 |
|
| 3735 | 3736 |
|
| 3736 | 3737 |
|
| 3737 | 3738 |
|
| 3738 | 3739 |
-- |
| 3739 |
-- Name: COLUMN analytical_stem.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3740 |
-- Name: COLUMN analytical_stem.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3740 | 3741 |
-- |
| 3741 | 3742 |
|
| 3742 | 3743 |
|
| 3743 | 3744 |
|
| 3744 | 3745 |
|
| 3745 | 3746 |
-- |
| 3746 |
-- Name: COLUMN analytical_stem.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3747 |
-- Name: COLUMN analytical_stem.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3747 | 3748 |
-- |
| 3748 | 3749 |
|
| 3749 | 3750 |
|
| 3750 | 3751 |
|
| 3751 | 3752 |
|
| 3752 | 3753 |
-- |
| 3753 |
-- Name: COLUMN analytical_stem.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3754 |
-- Name: COLUMN analytical_stem.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3754 | 3755 |
-- |
| 3755 | 3756 |
|
| 3756 | 3757 |
|
| 3757 | 3758 |
|
| 3758 | 3759 |
|
| 3759 | 3760 |
-- |
| 3760 |
-- Name: COLUMN analytical_stem.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3761 |
-- Name: COLUMN analytical_stem.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3761 | 3762 |
-- |
| 3762 | 3763 |
|
| 3763 | 3764 |
|
| 3764 | 3765 |
|
| 3765 | 3766 |
|
| 3766 | 3767 |
-- |
| 3767 |
-- Name: COLUMN analytical_stem.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3768 |
-- Name: COLUMN analytical_stem.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3768 | 3769 |
-- |
| 3769 | 3770 |
|
| 3770 | 3771 |
|
| 3771 | 3772 |
|
| 3772 | 3773 |
|
| 3773 | 3774 |
-- |
| 3774 |
-- Name: COLUMN analytical_stem.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3775 |
-- Name: COLUMN analytical_stem.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3775 | 3776 |
-- |
| 3776 | 3777 |
|
| 3777 | 3778 |
|
| 3778 | 3779 |
|
| 3779 | 3780 |
|
| 3780 | 3781 |
-- |
| 3781 |
-- Name: COLUMN analytical_stem.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3782 |
-- Name: COLUMN analytical_stem.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3782 | 3783 |
-- |
| 3783 | 3784 |
|
| 3784 | 3785 |
|
| 3785 | 3786 |
|
| 3786 | 3787 |
|
| 3787 | 3788 |
-- |
| 3788 |
-- Name: COLUMN analytical_stem.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3789 |
-- Name: COLUMN analytical_stem.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3789 | 3790 |
-- |
| 3790 | 3791 |
|
| 3791 | 3792 |
|
| 3792 | 3793 |
|
| 3793 | 3794 |
|
| 3794 | 3795 |
-- |
| 3795 |
-- Name: COLUMN analytical_stem.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3796 |
-- Name: COLUMN analytical_stem.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3796 | 3797 |
-- |
| 3797 | 3798 |
|
| 3798 | 3799 |
|
| 3799 | 3800 |
|
| 3800 | 3801 |
|
| 3801 | 3802 |
-- |
| 3802 |
-- Name: COLUMN analytical_stem.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3803 |
-- Name: COLUMN analytical_stem.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3803 | 3804 |
-- |
| 3804 | 3805 |
|
| 3805 | 3806 |
|
| ... | ... | |
| 5734 | 5735 |
|
| 5735 | 5736 |
|
| 5736 | 5737 |
-- |
| 5738 |
-- Name: viewFullOccurrence_individual_view; Type: VIEW; Schema: public; Owner: - |
|
| 5739 |
-- |
|
| 5740 |
|
|
| 5741 |
|
|
| 5742 |
|
|
| 5743 |
|
|
| 5744 |
-- |
|
| 5745 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5746 |
-- |
|
| 5747 |
|
|
| 5748 |
|
|
| 5749 |
|
|
| 5750 |
|
|
| 5751 |
-- |
|
| 5752 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5753 |
-- |
|
| 5754 |
|
|
| 5755 |
|
|
| 5756 |
|
|
| 5757 |
|
|
| 5758 |
-- |
|
| 5759 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5760 |
-- |
|
| 5761 |
|
|
| 5762 |
|
|
| 5763 |
|
|
| 5764 |
|
|
| 5765 |
-- |
|
| 5766 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5767 |
-- |
|
| 5768 |
|
|
| 5769 |
|
|
| 5770 |
|
|
| 5771 |
|
|
| 5772 |
-- |
|
| 5773 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5774 |
-- |
|
| 5775 |
|
|
| 5776 |
|
|
| 5777 |
|
|
| 5778 |
|
|
| 5779 |
-- |
|
| 5780 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5781 |
-- |
|
| 5782 |
|
|
| 5783 |
|
|
| 5784 |
|
|
| 5785 |
|
|
| 5786 |
-- |
|
| 5787 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5788 |
-- |
|
| 5789 |
|
|
| 5790 |
|
|
| 5791 |
|
|
| 5792 |
|
|
| 5793 |
-- |
|
| 5794 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5795 |
-- |
|
| 5796 |
|
|
| 5797 |
|
|
| 5798 |
|
|
| 5799 |
|
|
| 5800 |
-- |
|
| 5801 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5802 |
-- |
|
| 5803 |
|
|
| 5804 |
|
|
| 5805 |
|
|
| 5806 |
|
|
| 5807 |
-- |
|
| 5808 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5809 |
-- |
|
| 5810 |
|
|
| 5811 |
|
|
| 5812 |
|
|
| 5813 |
|
|
| 5814 |
-- |
|
| 5815 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 5816 |
-- |
|
| 5817 |
|
|
| 5818 |
|
|
| 5819 |
|
|
| 5820 |
|
|
| 5821 |
-- |
|
| 5822 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 5823 |
-- |
|
| 5824 |
|
|
| 5825 |
|
|
| 5826 |
|
|
| 5827 |
|
|
| 5828 |
-- |
|
| 5829 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5830 |
-- |
|
| 5831 |
|
|
| 5832 |
|
|
| 5833 |
|
|
| 5834 |
|
|
| 5835 |
-- |
|
| 5836 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5837 |
-- |
|
| 5838 |
|
|
| 5839 |
|
|
| 5840 |
|
|
| 5841 |
|
|
| 5842 |
-- |
|
| 5843 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5844 |
-- |
|
| 5845 |
|
|
| 5846 |
|
|
| 5847 |
|
|
| 5848 |
|
|
| 5849 |
-- |
|
| 5850 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5851 |
-- |
|
| 5852 |
|
|
| 5853 |
|
|
| 5854 |
|
|
| 5855 |
|
|
| 5856 |
-- |
|
| 5857 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5858 |
-- |
|
| 5859 |
|
|
| 5860 |
|
|
| 5861 |
|
|
| 5862 |
|
|
| 5863 |
-- |
|
| 5864 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
|
| 5865 |
-- |
|
| 5866 |
|
|
| 5867 |
|
|
| 5868 |
|
|
| 5869 |
|
|
| 5870 |
-- |
|
| 5871 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5872 |
-- |
|
| 5873 |
|
|
| 5874 |
|
|
| 5875 |
|
|
| 5876 |
|
|
| 5877 |
-- |
|
| 5878 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5879 |
-- |
|
| 5880 |
|
|
| 5881 |
|
|
| 5882 |
|
|
| 5883 |
|
|
| 5884 |
-- |
|
| 5885 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5886 |
-- |
|
| 5887 |
|
|
| 5888 |
|
|
| 5889 |
|
|
| 5890 |
|
|
| 5891 |
-- |
|
| 5892 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5893 |
-- |
|
| 5894 |
|
|
| 5895 |
|
|
| 5896 |
|
|
| 5897 |
|
|
| 5898 |
-- |
|
| 5899 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5900 |
-- |
|
| 5901 |
|
|
| 5902 |
|
|
| 5903 |
|
|
| 5904 |
|
|
| 5905 |
-- |
|
| 5906 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5907 |
-- |
|
| 5908 |
|
|
| 5909 |
|
|
| 5910 |
|
|
| 5911 |
|
|
| 5912 |
-- |
|
| 5913 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5914 |
-- |
|
| 5915 |
|
|
| 5916 |
|
|
| 5917 |
|
|
| 5918 |
|
|
| 5919 |
-- |
|
| 5920 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5921 |
-- |
|
| 5922 |
|
|
| 5923 |
|
|
| 5924 |
|
|
| 5925 |
|
|
| 5926 |
-- |
|
| 5927 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5928 |
-- |
|
| 5929 |
|
|
| 5930 |
|
|
| 5931 |
|
|
| 5932 |
|
|
| 5933 |
-- |
|
| 5934 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5935 |
-- |
|
| 5936 |
|
|
| 5937 |
|
|
| 5938 |
|
|
| 5939 |
|
|
| 5940 |
-- |
|
| 5941 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5942 |
-- |
|
| 5943 |
|
|
| 5944 |
|
|
| 5945 |
|
|
| 5946 |
|
|
| 5947 |
-- |
|
| 5948 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5949 |
-- |
|
| 5950 |
|
|
| 5951 |
|
|
| 5952 |
|
|
| 5953 |
|
|
| 5954 |
-- |
|
| 5955 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5956 |
-- |
|
| 5957 |
|
|
| 5958 |
|
|
| 5959 |
|
|
| 5960 |
|
|
| 5961 |
-- |
|
| 5962 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5963 |
-- |
|
| 5964 |
|
|
| 5965 |
|
|
| 5966 |
|
|
| 5967 |
|
|
| 5968 |
-- |
|
| 5969 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5970 |
-- |
|
| 5971 |
|
|
| 5972 |
|
|
| 5973 |
|
|
| 5974 |
|
|
| 5975 |
-- |
|
| 5976 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5977 |
-- |
|
| 5978 |
|
|
| 5979 |
|
|
| 5980 |
|
|
| 5981 |
|
|
| 5982 |
-- |
|
| 5983 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5984 |
-- |
|
| 5985 |
|
|
| 5986 |
|
|
| 5987 |
|
|
| 5988 |
|
|
| 5989 |
-- |
|
| 5990 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5991 |
-- |
|
| 5992 |
|
|
| 5993 |
|
|
| 5994 |
|
|
| 5995 |
|
|
| 5996 |
-- |
|
| 5997 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5998 |
-- |
|
| 5999 |
|
|
| 6000 |
|
|
| 6001 |
|
|
| 6002 |
|
|
| 6003 |
-- |
|
| 6004 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6005 |
-- |
|
| 6006 |
|
|
| 6007 |
|
|
| 6008 |
|
|
| 6009 |
|
|
| 6010 |
-- |
|
| 6011 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6012 |
-- |
|
| 6013 |
|
|
| 6014 |
|
|
| 6015 |
|
|
| 6016 |
|
|
| 6017 |
-- |
|
| 6018 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6019 |
-- |
|
| 6020 |
|
|
| 6021 |
|
|
| 6022 |
|
|
| 6023 |
|
|
| 6024 |
-- |
|
| 6025 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6026 |
-- |
|
| 6027 |
|
|
| 6028 |
|
|
| 6029 |
|
|
| 6030 |
|
|
| 6031 |
-- |
|
| 6032 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6033 |
-- |
|
| 6034 |
|
|
| 6035 |
|
|
| 6036 |
|
|
| 6037 |
|
|
| 6038 |
-- |
|
| 6039 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6040 |
-- |
|
| 6041 |
|
|
| 6042 |
|
|
| 6043 |
|
|
| 6044 |
|
|
| 6045 |
-- |
|
| 6046 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6047 |
-- |
|
| 6048 |
|
|
| 6049 |
|
|
| 6050 |
|
|
| 6051 |
|
|
| 6052 |
-- |
|
| 6053 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6054 |
-- |
|
| 6055 |
|
|
| 6056 |
|
|
| 6057 |
|
|
| 6058 |
|
|
| 6059 |
-- |
|
| 6060 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6061 |
-- |
|
| 6062 |
|
|
| 6063 |
|
|
| 6064 |
|
|
| 6065 |
|
|
| 6066 |
-- |
|
| 6067 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6068 |
-- |
|
| 6069 |
|
|
| 6070 |
|
|
| 6071 |
|
|
| 6072 |
|
|
| 6073 |
-- |
|
| 6074 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 6075 |
-- |
|
| 6076 |
|
|
| 6077 |
|
|
| 6078 |
|
|
| 6079 |
|
|
| 6080 |
-- |
|
| 6081 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 6082 |
-- |
|
| 6083 |
|
|
| 6084 |
|
|
| 6085 |
|
|
| 6086 |
|
|
| 6087 |
-- |
|
| 6088 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: - |
|
| 6089 |
-- |
|
| 6090 |
|
|
| 6091 |
|
|
| 6092 |
|
|
| 6093 |
|
|
| 6094 |
-- |
|
| 6095 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: - |
|
| 6096 |
-- |
|
| 6097 |
|
|
| 6098 |
|
|
| 6099 |
|
|
| 6100 |
|
|
| 6101 |
-- |
|
| 6102 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 6103 |
-- |
|
| 6104 |
|
|
| 6105 |
|
|
| 6106 |
|
|
| 6107 |
|
|
| 6108 |
-- |
|
| 6109 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 6110 |
-- |
|
| 6111 |
|
|
| 6112 |
|
|
| 6113 |
|
|
| 6114 |
|
|
| 6115 |
-- |
|
| 6116 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: - |
|
| 6117 |
-- |
|
| 6118 |
|
|
| 6119 |
|
|
| 6120 |
|
|
| 6121 |
|
|
| 6122 |
-- |
|
| 6123 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6124 |
-- |
|
| 6125 |
|
|
| 6126 |
|
|
| 6127 |
|
|
| 6128 |
|
|
| 6129 |
-- |
|
| 6130 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6131 |
-- |
|
| 6132 |
|
|
| 6133 |
|
|
| 6134 |
|
|
| 6135 |
|
|
| 6136 |
-- |
|
| 6137 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6138 |
-- |
|
| 6139 |
|
|
| 6140 |
|
|
| 6141 |
|
|
| 6142 |
|
|
| 6143 |
-- |
|
| 6144 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.cultivated_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 6145 |
-- |
|
| 6146 |
|
|
| 6147 |
|
|
| 6148 |
|
|
| 6149 |
|
|
| 6150 |
-- |
|
| 6151 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 6152 |
-- |
|
| 6153 |
|
|
| 6154 |
|
|
| 6155 |
|
|
| 6156 |
|
|
| 6157 |
-- |
|
| 6158 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6159 |
-- |
|
| 6160 |
|
|
| 6161 |
|
|
| 6162 |
|
|
| 6163 |
|
|
| 6164 |
-- |
|
| 6165 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6166 |
-- |
|
| 6167 |
|
|
| 6168 |
|
|
| 6169 |
|
|
| 6170 |
|
|
| 6171 |
-- |
|
| 6172 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6173 |
-- |
|
| 6174 |
|
|
| 6175 |
|
|
| 6176 |
|
|
| 6177 |
|
|
| 6178 |
-- |
|
| 6179 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6180 |
-- |
|
| 6181 |
|
|
| 6182 |
|
|
| 6183 |
|
|
| 6184 |
|
|
| 6185 |
-- |
|
| 6186 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6187 |
-- |
|
| 6188 |
|
|
| 6189 |
|
|
| 6190 |
|
|
| 6191 |
|
|
| 6192 |
-- |
|
| 6193 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6194 |
-- |
|
| 6195 |
|
|
| 6196 |
|
|
| 6197 |
|
|
| 6198 |
|
|
| 6199 |
-- |
|
| 6200 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6201 |
-- |
|
| 6202 |
|
|
| 6203 |
|
|
| 6204 |
|
|
| 6205 |
|
|
| 6206 |
-- |
|
| 6207 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6208 |
-- |
|
| 6209 |
|
|
| 6210 |
|
|
| 6211 |
|
|
| 6212 |
|
|
| 6213 |
-- |
|
| 6214 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`plantobservation.``_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6215 |
-- |
|
| 6216 |
|
|
| 6217 |
|
|
| 6218 |
|
|
| 6219 |
|
|
| 6220 |
-- |
|
| 5737 | 6221 |
-- Name: analytical_stem_view; Type: VIEW; Schema: public; Owner: - |
| 5738 | 6222 |
-- |
| 5739 | 6223 |
|
| ... | ... | |
| 6175 | 6659 |
|
| 6176 | 6660 |
|
| 6177 | 6661 |
-- |
| 6178 |
-- Name: COLUMN analytical_stem_view.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6662 |
-- Name: COLUMN analytical_stem_view.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6179 | 6663 |
-- |
| 6180 | 6664 |
|
| 6181 | 6665 |
|
| 6182 | 6666 |
|
| 6183 | 6667 |
|
| 6184 | 6668 |
-- |
| 6185 |
-- Name: COLUMN analytical_stem_view.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6669 |
-- Name: COLUMN analytical_stem_view.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6186 | 6670 |
-- |
| 6187 | 6671 |
|
| 6188 | 6672 |
|
| 6189 | 6673 |
|
| 6190 | 6674 |
|
| 6191 | 6675 |
-- |
| 6192 |
-- Name: COLUMN analytical_stem_view.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6676 |
-- Name: COLUMN analytical_stem_view.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6193 | 6677 |
-- |
| 6194 | 6678 |
|
| 6195 | 6679 |
|
| 6196 | 6680 |
|
| 6197 | 6681 |
|
| 6198 | 6682 |
-- |
| 6199 |
-- Name: COLUMN analytical_stem_view.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6683 |
-- Name: COLUMN analytical_stem_view.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6200 | 6684 |
-- |
| 6201 | 6685 |
|
| 6202 | 6686 |
|
| 6203 | 6687 |
|
| 6204 | 6688 |
|
| 6205 | 6689 |
-- |
| 6206 |
-- Name: COLUMN analytical_stem_view.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6690 |
-- Name: COLUMN analytical_stem_view.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6207 | 6691 |
-- |
| 6208 | 6692 |
|
| 6209 | 6693 |
|
| 6210 | 6694 |
|
| 6211 | 6695 |
|
| 6212 | 6696 |
-- |
| 6213 |
-- Name: COLUMN analytical_stem_view.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6697 |
-- Name: COLUMN analytical_stem_view.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6214 | 6698 |
-- |
| 6215 | 6699 |
|
| 6216 | 6700 |
|
| 6217 | 6701 |
|
| 6218 | 6702 |
|
| 6219 | 6703 |
-- |
| 6220 |
-- Name: COLUMN analytical_stem_view.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6704 |
-- Name: COLUMN analytical_stem_view.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6221 | 6705 |
-- |
| 6222 | 6706 |
|
| 6223 | 6707 |
|
| 6224 | 6708 |
|
| 6225 | 6709 |
|
| 6226 | 6710 |
-- |
| 6227 |
-- Name: COLUMN analytical_stem_view.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6711 |
-- Name: COLUMN analytical_stem_view.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6228 | 6712 |
-- |
| 6229 | 6713 |
|
| 6230 | 6714 |
|
| 6231 | 6715 |
|
| 6232 | 6716 |
|
| 6233 | 6717 |
-- |
| 6234 |
-- Name: COLUMN analytical_stem_view.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6718 |
-- Name: COLUMN analytical_stem_view.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6235 | 6719 |
-- |
| 6236 | 6720 |
|
| 6237 | 6721 |
|
| 6238 | 6722 |
|
| 6239 | 6723 |
|
| 6240 | 6724 |
-- |
| 6241 |
-- Name: COLUMN analytical_stem_view.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6725 |
-- Name: COLUMN analytical_stem_view.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6242 | 6726 |
-- |
| 6243 | 6727 |
|
| 6244 | 6728 |
|
| 6245 | 6729 |
|
| 6246 | 6730 |
|
| 6247 | 6731 |
-- |
| 6248 |
-- Name: COLUMN analytical_stem_view.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6732 |
-- Name: COLUMN analytical_stem_view.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 6249 | 6733 |
-- |
| 6250 | 6734 |
|
| 6251 | 6735 |
|
| ... | ... | |
| 7844 | 8328 |
|
| 7845 | 8329 |
|
| 7846 | 8330 |
-- |
| 7847 |
-- Name: viewFullOccurrence_individual_view; Type: VIEW; Schema: public; Owner: - |
|
| 7848 |
-- |
|
| 7849 |
|
|
| 7850 |
|
|
| 7851 |
|
|
| 7852 |
|
|
| 7853 |
-- |
|
| 7854 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7855 |
-- |
|
| 7856 |
|
|
| 7857 |
|
|
| 7858 |
|
|
| 7859 |
|
|
| 7860 |
-- |
|
| 7861 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7862 |
-- |
|
| 7863 |
|
|
| 7864 |
|
|
| 7865 |
|
|
| 7866 |
|
|
| 7867 |
-- |
|
| 7868 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7869 |
-- |
|
| 7870 |
|
|
| 7871 |
|
|
| 7872 |
|
|
| 7873 |
|
|
| 7874 |
-- |
|
| 7875 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7876 |
-- |
|
| 7877 |
|
|
| 7878 |
|
|
| 7879 |
|
|
| 7880 |
|
|
| 7881 |
-- |
|
| 7882 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7883 |
-- |
|
| 7884 |
|
|
| 7885 |
|
|
| 7886 |
|
|
| 7887 |
|
|
| 7888 |
-- |
|
| 7889 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7890 |
-- |
|
| 7891 |
|
|
| 7892 |
|
|
| 7893 |
|
|
| 7894 |
|
|
| 7895 |
-- |
|
| 7896 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7897 |
-- |
|
| 7898 |
|
|
| 7899 |
|
|
| 7900 |
|
|
| 7901 |
|
|
| 7902 |
-- |
|
| 7903 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7904 |
-- |
|
| 7905 |
|
|
| 7906 |
|
|
| 7907 |
|
|
| 7908 |
|
|
| 7909 |
-- |
|
| 7910 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7911 |
-- |
|
| 7912 |
|
|
| 7913 |
|
|
| 7914 |
|
|
| 7915 |
|
|
| 7916 |
-- |
|
| 7917 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7918 |
-- |
|
| 7919 |
|
|
| 7920 |
|
|
| 7921 |
|
|
| 7922 |
|
|
| 7923 |
-- |
|
| 7924 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 7925 |
-- |
|
| 7926 |
|
|
| 7927 |
|
|
| 7928 |
|
|
| 7929 |
|
|
| 7930 |
-- |
|
| 7931 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 7932 |
-- |
|
| 7933 |
|
|
| 7934 |
|
|
| 7935 |
|
|
| 7936 |
|
|
| 7937 |
-- |
|
| 7938 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7939 |
-- |
|
| 7940 |
|
|
| 7941 |
|
|
| 7942 |
|
|
| 7943 |
|
|
| 7944 |
-- |
|
| 7945 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7946 |
-- |
|
| 7947 |
|
|
| 7948 |
|
|
| 7949 |
|
|
| 7950 |
|
|
| 7951 |
-- |
|
| 7952 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7953 |
-- |
|
| 7954 |
|
|
| 7955 |
|
|
| 7956 |
|
|
| 7957 |
|
|
| 7958 |
-- |
|
| 7959 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7960 |
-- |
|
| 7961 |
|
|
| 7962 |
|
|
| 7963 |
|
|
| 7964 |
|
|
| 7965 |
-- |
|
| 7966 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7967 |
-- |
|
| 7968 |
|
|
| 7969 |
|
|
| 7970 |
|
|
| 7971 |
|
|
| 7972 |
-- |
|
| 7973 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
|
| 7974 |
-- |
|
| 7975 |
|
|
| 7976 |
|
|
| 7977 |
|
|
| 7978 |
|
|
| 7979 |
-- |
|
| 7980 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7981 |
-- |
|
| 7982 |
|
|
| 7983 |
|
|
| 7984 |
|
|
| 7985 |
|
|
| 7986 |
-- |
|
| 7987 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7988 |
-- |
|
| 7989 |
|
|
| 7990 |
|
|
| 7991 |
|
|
| 7992 |
|
|
| 7993 |
-- |
|
| 7994 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 7995 |
-- |
|
| 7996 |
|
|
| 7997 |
|
|
| 7998 |
|
|
| 7999 |
|
|
| 8000 |
-- |
|
| 8001 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8002 |
-- |
|
| 8003 |
|
|
| 8004 |
|
|
| 8005 |
|
|
| 8006 |
|
|
| 8007 |
-- |
|
| 8008 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8009 |
-- |
|
| 8010 |
|
|
| 8011 |
|
|
| 8012 |
|
|
| 8013 |
|
|
| 8014 |
-- |
|
| 8015 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8016 |
-- |
|
| 8017 |
|
|
| 8018 |
|
|
| 8019 |
|
|
| 8020 |
|
|
| 8021 |
-- |
|
| 8022 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8023 |
-- |
|
| 8024 |
|
|
| 8025 |
|
|
| 8026 |
|
|
| 8027 |
|
|
| 8028 |
-- |
|
| 8029 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8030 |
-- |
|
| 8031 |
|
|
| 8032 |
|
|
| 8033 |
|
|
| 8034 |
|
|
| 8035 |
-- |
|
| 8036 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8037 |
-- |
|
| 8038 |
|
|
| 8039 |
|
|
| 8040 |
|
|
| 8041 |
|
|
| 8042 |
-- |
|
| 8043 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8044 |
-- |
|
| 8045 |
|
|
| 8046 |
|
|
| 8047 |
|
|
| 8048 |
|
|
| 8049 |
-- |
|
| 8050 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8051 |
-- |
|
| 8052 |
|
|
| 8053 |
|
|
| 8054 |
|
|
| 8055 |
|
|
| 8056 |
-- |
|
| 8057 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8058 |
-- |
|
| 8059 |
|
|
| 8060 |
|
|
| 8061 |
|
|
| 8062 |
|
|
| 8063 |
-- |
|
| 8064 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8065 |
-- |
|
| 8066 |
|
|
| 8067 |
|
|
| 8068 |
|
|
| 8069 |
|
|
| 8070 |
-- |
|
| 8071 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8072 |
-- |
|
| 8073 |
|
|
| 8074 |
|
|
| 8075 |
|
|
| 8076 |
|
|
| 8077 |
-- |
|
| 8078 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8079 |
-- |
|
| 8080 |
|
|
| 8081 |
|
|
| 8082 |
|
|
| 8083 |
|
|
| 8084 |
-- |
|
| 8085 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8086 |
-- |
|
| 8087 |
|
|
| 8088 |
|
|
| 8089 |
|
|
| 8090 |
|
|
| 8091 |
-- |
|
| 8092 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8093 |
-- |
|
| 8094 |
|
|
| 8095 |
|
|
| 8096 |
|
|
| 8097 |
|
|
| 8098 |
-- |
|
| 8099 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8100 |
-- |
|
| 8101 |
|
|
| 8102 |
|
|
| 8103 |
|
|
| 8104 |
|
|
| 8105 |
-- |
|
| 8106 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8107 |
-- |
|
| 8108 |
|
|
| 8109 |
|
|
| 8110 |
|
|
| 8111 |
|
|
| 8112 |
-- |
|
| 8113 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8114 |
-- |
|
| 8115 |
|
|
| 8116 |
|
|
| 8117 |
|
|
| 8118 |
|
|
| 8119 |
-- |
|
| 8120 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8121 |
-- |
|
| 8122 |
|
|
| 8123 |
|
|
| 8124 |
|
|
| 8125 |
|
|
| 8126 |
-- |
|
| 8127 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8128 |
-- |
|
| 8129 |
|
|
| 8130 |
|
|
| 8131 |
|
|
| 8132 |
|
|
| 8133 |
-- |
|
| 8134 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8135 |
-- |
|
| 8136 |
|
|
| 8137 |
|
|
| 8138 |
|
|
| 8139 |
|
|
| 8140 |
-- |
|
| 8141 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8142 |
-- |
|
| 8143 |
|
|
| 8144 |
|
|
| 8145 |
|
|
| 8146 |
|
|
| 8147 |
-- |
|
| 8148 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8149 |
-- |
|
| 8150 |
|
|
| 8151 |
|
|
| 8152 |
|
|
| 8153 |
|
|
| 8154 |
-- |
|
| 8155 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8156 |
-- |
|
| 8157 |
|
|
| 8158 |
|
|
| 8159 |
|
|
| 8160 |
|
|
| 8161 |
-- |
|
| 8162 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8163 |
-- |
|
| 8164 |
|
|
| 8165 |
|
|
| 8166 |
|
|
| 8167 |
|
|
| 8168 |
-- |
|
| 8169 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8170 |
-- |
|
| 8171 |
|
|
| 8172 |
|
|
| 8173 |
|
|
| 8174 |
|
|
| 8175 |
-- |
|
| 8176 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8177 |
-- |
|
| 8178 |
|
|
| 8179 |
|
|
| 8180 |
|
|
| 8181 |
|
|
| 8182 |
-- |
|
| 8183 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 8184 |
-- |
|
| 8185 |
|
|
| 8186 |
|
|
| 8187 |
|
|
| 8188 |
|
|
| 8189 |
-- |
|
| 8190 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 8191 |
-- |
|
| 8192 |
|
|
| 8193 |
|
|
| 8194 |
|
|
| 8195 |
|
|
| 8196 |
-- |
|
| 8197 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: - |
|
| 8198 |
-- |
|
| 8199 |
|
|
| 8200 |
|
|
| 8201 |
|
|
| 8202 |
|
|
| 8203 |
-- |
|
| 8204 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: - |
|
| 8205 |
-- |
|
| 8206 |
|
|
| 8207 |
|
|
| 8208 |
|
|
| 8209 |
|
|
| 8210 |
-- |
|
| 8211 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 8212 |
-- |
|
| 8213 |
|
|
| 8214 |
|
|
| 8215 |
|
|
| 8216 |
|
|
| 8217 |
-- |
|
| 8218 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 8219 |
-- |
|
| 8220 |
|
|
| 8221 |
|
|
| 8222 |
|
|
| 8223 |
|
|
| 8224 |
-- |
|
| 8225 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: - |
|
| 8226 |
-- |
|
| 8227 |
|
|
| 8228 |
|
|
| 8229 |
|
|
| 8230 |
|
|
| 8231 |
-- |
|
| 8232 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8233 |
-- |
|
| 8234 |
|
|
| 8235 |
|
|
| 8236 |
|
|
| 8237 |
|
|
| 8238 |
-- |
|
| 8239 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8240 |
-- |
|
| 8241 |
|
|
| 8242 |
|
|
| 8243 |
|
|
| 8244 |
|
|
| 8245 |
-- |
|
| 8246 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8247 |
-- |
|
| 8248 |
|
|
| 8249 |
|
|
| 8250 |
|
|
| 8251 |
|
|
| 8252 |
-- |
|
| 8253 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.cultivated_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 8254 |
-- |
|
| 8255 |
|
|
| 8256 |
|
|
| 8257 |
|
|
| 8258 |
|
|
| 8259 |
-- |
|
| 8260 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 8261 |
-- |
|
| 8262 |
|
|
| 8263 |
|
|
| 8264 |
|
|
| 8265 |
|
|
| 8266 |
-- |
|
| 8267 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8268 |
-- |
|
| 8269 |
|
|
| 8270 |
|
|
| 8271 |
|
|
| 8272 |
|
|
| 8273 |
-- |
|
| 8274 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8275 |
-- |
|
| 8276 |
|
|
| 8277 |
|
|
| 8278 |
|
|
| 8279 |
|
|
| 8280 |
-- |
|
| 8281 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8282 |
-- |
|
| 8283 |
|
|
| 8284 |
|
|
| 8285 |
|
|
| 8286 |
|
|
| 8287 |
-- |
|
| 8288 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8289 |
-- |
|
| 8290 |
|
|
| 8291 |
|
|
| 8292 |
|
|
| 8293 |
|
|
| 8294 |
-- |
|
| 8295 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8296 |
-- |
|
| 8297 |
|
|
| 8298 |
|
|
| 8299 |
|
|
| 8300 |
|
|
| 8301 |
-- |
|
| 8302 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8303 |
-- |
|
| 8304 |
|
|
| 8305 |
|
|
| 8306 |
|
|
| 8307 |
|
|
| 8308 |
-- |
|
| 8309 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8310 |
-- |
|
| 8311 |
|
|
| 8312 |
|
|
| 8313 |
|
|
| 8314 |
|
|
| 8315 |
-- |
|
| 8316 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8317 |
-- |
|
| 8318 |
|
|
| 8319 |
|
|
| 8320 |
|
|
| 8321 |
|
|
| 8322 |
-- |
|
| 8323 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`plantobservation.``_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8324 |
-- |
|
| 8325 |
|
|
| 8326 |
|
|
| 8327 |
|
|
| 8328 |
|
|
| 8329 |
-- |
|
| 8330 | 8331 |
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 8331 | 8332 |
-- |
| 8332 | 8333 |
|
| ... | ... | |
| 15151 | 15152 |
|
| 15152 | 15153 |
|
| 15153 | 15154 |
-- |
| 15155 |
-- Name: viewFullOccurrence_individual_view; Type: ACL; Schema: public; Owner: - |
|
| 15156 |
-- |
|
| 15157 |
|
|
| 15158 |
|
|
| 15159 |
|
|
| 15160 |
|
|
| 15161 |
|
|
| 15162 |
|
|
| 15163 |
|
|
| 15164 |
-- |
|
| 15154 | 15165 |
-- Name: analytical_stem_view; Type: ACL; Schema: public; Owner: - |
| 15155 | 15166 |
-- |
| 15156 | 15167 |
|
| ... | ... | |
| 15726 | 15737 |
|
| 15727 | 15738 |
|
| 15728 | 15739 |
-- |
| 15729 |
-- Name: viewFullOccurrence_individual_view; Type: ACL; Schema: public; Owner: - |
|
| 15730 |
-- |
|
| 15731 |
|
|
| 15732 |
|
|
| 15733 |
|
|
| 15734 |
|
|
| 15735 |
|
|
| 15736 |
|
|
| 15737 |
|
|
| 15738 |
-- |
|
| 15739 | 15740 |
-- Name: voucher; Type: ACL; Schema: public; Owner: - |
| 15740 | 15741 |
-- |
| 15741 | 15742 |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: use viewFullOccurrence_individual_view to avoid duplicated code between the views. this moves the stem-related columns to the end of the view.