Revision 14442
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 4787 | 4787 |
|
| 4788 | 4788 |
|
| 4789 | 4789 |
-- |
| 4790 |
-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 4790 |
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 4791 | 4791 |
-- |
| 4792 | 4792 |
|
| 4793 |
CREATE TABLE coordinates (
|
|
| 4794 |
coordinates_id int(11) NOT NULL,
|
|
| 4793 |
CREATE TABLE stemobservation (
|
|
| 4794 |
stemobservation_id int(11) NOT NULL,
|
|
| 4795 | 4795 |
source_id int(11) NOT NULL, |
| 4796 |
latitude_deg double NOT NULL, |
|
| 4797 |
longitude_deg double NOT NULL, |
|
| 4798 |
verbatimlatitude varchar(255), |
|
| 4799 |
verbatimlongitude varchar(255), |
|
| 4800 |
verbatimcoordinates varchar(255), |
|
| 4801 |
footprintgeometry_dwc varchar(255), |
|
| 4802 |
coordsaccuracy_m double |
|
| 4796 |
sourceaccessioncode varchar(255), |
|
| 4797 |
plantobservation_id int(11) NOT NULL, |
|
| 4798 |
authorstemcode varchar(255), |
|
| 4799 |
tag varchar(255), |
|
| 4800 |
tags varchar(255), |
|
| 4801 |
xposition_m double, |
|
| 4802 |
yposition_m double, |
|
| 4803 |
diameterbreastheight_m double, |
|
| 4804 |
basaldiameter_m double, |
|
| 4805 |
diameteraccuracy_m double, |
|
| 4806 |
height_m double, |
|
| 4807 |
heightfirstbranch_m double, |
|
| 4808 |
heightaccuracy_m double, |
|
| 4809 |
health varchar(255), |
|
| 4810 |
age double |
|
| 4803 | 4811 |
); |
| 4804 | 4812 |
|
| 4805 | 4813 |
|
| 4806 | 4814 |
-- |
| 4807 |
-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 4815 |
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
|
|
| 4808 | 4816 |
-- |
| 4809 | 4817 |
|
| 4810 | 4818 |
|
| 4811 | 4819 |
|
| 4812 | 4820 |
|
| 4813 | 4821 |
-- |
| 4814 |
-- Name: COLUMN coordinates.coordsaccuracy_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 4822 |
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public; Owner: -
|
|
| 4815 | 4823 |
-- |
| 4816 | 4824 |
|
| 4817 | 4825 |
|
| 4818 | 4826 |
|
| 4819 | 4827 |
|
| 4820 | 4828 |
-- |
| 4821 |
-- Name: cultivated_family_locations; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 4829 |
-- Name: viewFullOccurrence_individual; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 4822 | 4830 |
-- |
| 4823 | 4831 |
|
| 4824 |
CREATE TABLE cultivated_family_locations ( |
|
| 4825 |
family varchar(255) NOT NULL, |
|
| 4826 |
country varchar(255) NOT NULL |
|
| 4832 |
CREATE TABLE `viewFullOccurrence_individual` ( |
|
| 4833 |
`datasource__@Brad__.identifier_examples@vegpath.org` varchar(255) NOT NULL, |
|
| 4834 |
`country__@DwC__@vegpath.org` varchar(255), |
|
| 4835 |
`stateProvince__@DwC__@vegpath.org` varchar(255), |
|
| 4836 |
`county__@DwC__@vegpath.org` varchar(255), |
|
| 4837 |
`locality__@DwC__@vegpath.org` varchar(255), |
|
| 4838 |
`decimalLatitude__@DwC__@vegpath.org` double, |
|
| 4839 |
`decimalLongitude__@DwC__@vegpath.org` double, |
|
| 4840 |
`coordinateUncertaintyInMeters__@DwC__@vegpath.org` double, |
|
| 4841 |
`georeferenceSources__@DwC__@vegpath.org` coordinatesource, |
|
| 4842 |
`georeferenceProtocol__@DwC__@vegpath.org` varchar(255), |
|
| 4843 |
geovalid_bien int(11), |
|
| 4844 |
`isNewWorld_bien` int(11), |
|
| 4845 |
`projectID__@VegX__.plotObservation@vegpath.org` varchar(255), |
|
| 4846 |
`projectContributor[s]__@VegBank__@vegpath.org` varchar(255), |
|
| 4847 |
`locationID__@DwC__@vegpath.org` varchar(255) NOT NULL, |
|
| 4848 |
`plotName__@VegX__.plot@vegpath.org` varchar(255), |
|
| 4849 |
`subplot__@SALVIAS__.Plot_data@vegpath.org` varchar(255), |
|
| 4850 |
location__cultivated__bien int(1), |
|
| 4851 |
`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org` int(11), |
|
| 4852 |
`eventDate__@DwC__@vegpath.org` date, |
|
| 4853 |
`(-minimum-)ElevationInMeters__@DwC__@vegpath.org` double, |
|
| 4854 |
`slopeAspect[_deg]__@VegX__.plot@vegpath.org` double, |
|
| 4855 |
`slopeGradient[_deg]__@VegX__.plot@vegpath.org` double, |
|
| 4856 |
`plot.area[_ha]__@VegX__@vegpath.org` double, |
|
| 4857 |
`samplingProtocol__@DwC__@vegpath.org` varchar(255), |
|
| 4858 |
`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org` double, |
|
| 4859 |
`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org` double, |
|
| 4860 |
`stratumName__@VegX__.stratum@vegpath.org` varchar(255), |
|
| 4861 |
`communityConcept.name__@VegX__.communityDet@vegpath.org` varchar(255), |
|
| 4862 |
`observationContributor[s]__@VegBank__@vegpath.org` varchar(255), |
|
| 4863 |
`[custodial_]institutionCode[s]__@DwC__@vegpath.org` varchar(255), |
|
| 4864 |
`collectionCode__@DwC__@vegpath.org` varchar(255), |
|
| 4865 |
`catalogNumber__@DwC__@vegpath.org` varchar(255), |
|
| 4866 |
`occurrenceID__@DwC__@vegpath.org` varchar(255), |
|
| 4867 |
`recordedBy__@DwC__@vegpath.org` varchar(255), |
|
| 4868 |
`recordNumber__@DwC__@vegpath.org` varchar(255), |
|
| 4869 |
`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org` date, |
|
| 4870 |
`[verbatim_]family__@DwC__@vegpath.org` varchar(255), |
|
| 4871 |
`[verbatim_]scientificName__@DwC__@vegpath.org` varchar(255), |
|
| 4872 |
`identifiedBy__@DwC__@vegpath.org` varchar(255), |
|
| 4873 |
`dateIdentified__@DwC__@vegpath.org` date, |
|
| 4874 |
`identificationRemarks__@DwC__@vegpath.org` varchar(255), |
|
| 4875 |
`Family_matched__@TNRS__@vegpath.org` varchar(255), |
|
| 4876 |
`Name_matched__@TNRS__@vegpath.org` varchar(255), |
|
| 4877 |
`Name_matched_author__@TNRS__@vegpath.org` varchar(255), |
|
| 4878 |
`[higher_plant_group~]higherClassification__@DwC__@vegpath.org` higher_plant_group, |
|
| 4879 |
`taxonomicStatus__@DwC__@vegpath.org` varchar(255), |
|
| 4880 |
scrubbed_family varchar(255), |
|
| 4881 |
scrubbed_genus varchar(255), |
|
| 4882 |
scrubbed_specific_epithet varchar(255), |
|
| 4883 |
scrubbed_species_binomial varchar(255), |
|
| 4884 |
scrubbed_taxon_name_no_author varchar(255), |
|
| 4885 |
scrubbed_author varchar(255), |
|
| 4886 |
scrubbed_taxon_name_with_author varchar(255), |
|
| 4887 |
`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org` varchar(255), |
|
| 4888 |
`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org` growthform, |
|
| 4889 |
`reproductiveCondition__@DwC__@vegpath.org` varchar(255), |
|
| 4890 |
cultivated_bien int(11), |
|
| 4891 |
`cultivatedBasis_bien` varchar(255), |
|
| 4892 |
`occurrenceRemarks__@DwC__@vegpath.org` varchar(255), |
|
| 4893 |
`coverPercent__@VegX__.attribute.ordinal@vegpath.org` double, |
|
| 4894 |
`taxonObservation[.id]__@VegBank__@vegpath.org` varchar(255), |
|
| 4895 |
`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org` varchar(255), |
|
| 4896 |
`aggregateOrganismObservation.id__@VegX__@vegpath.org` varchar(255), |
|
| 4897 |
`individualOrganismObservation.id__@VegX__@vegpath.org` varchar(255), |
|
| 4898 |
`individualID__@DwC__@vegpath.org` varchar(255), |
|
| 4899 |
`individualCount__@DwC__@vegpath.org` int(11), |
|
| 4900 |
`plantobservation.``_id__@VegBIEN__.public@vegpath.org` int(11), |
|
| 4901 |
`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org` int(11) NOT NULL |
|
| 4827 | 4902 |
); |
| 4828 | 4903 |
|
| 4829 | 4904 |
|
| 4830 | 4905 |
-- |
| 4831 |
-- Name: TABLE cultivated_family_locations; Type: COMMENT; Schema: public; Owner: -
|
|
| 4906 |
-- Name: COLUMN `viewFullOccurrence_individual`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4832 | 4907 |
-- |
| 4833 | 4908 |
|
| 4834 | 4909 |
|
| 4835 | 4910 |
|
| 4836 | 4911 |
|
| 4837 | 4912 |
-- |
| 4838 |
-- Name: family_higher_plant_group; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 4913 |
-- Name: COLUMN `viewFullOccurrence_individual`.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4839 | 4914 |
-- |
| 4840 | 4915 |
|
| 4841 |
CREATE TABLE family_higher_plant_group ( |
|
| 4842 |
family varchar(255) NOT NULL, |
|
| 4843 |
higher_plant_group varchar(255) |
|
| 4844 |
); |
|
| 4845 | 4916 |
|
| 4846 | 4917 |
|
| 4847 |
-- |
|
| 4848 |
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 4849 |
-- |
|
| 4850 | 4918 |
|
| 4851 |
CREATE TABLE location ( |
|
| 4852 |
location_id int(11) NOT NULL, |
|
| 4853 |
source_id int(11) NOT NULL, |
|
| 4854 |
sourceaccessioncode varchar(255), |
|
| 4855 |
plot_location_id int(11) NOT NULL, |
|
| 4856 |
parent_id int(11), |
|
| 4857 |
authorlocationcode varchar(255), |
|
| 4858 |
place_id int(11), |
|
| 4859 |
accesslevel varchar(255), |
|
| 4860 |
accessconditions varchar(255), |
|
| 4861 |
sublocationxposition_m double, |
|
| 4862 |
sublocationyposition_m double, |
|
| 4863 |
iscultivated int(1), |
|
| 4864 |
authorzone varchar(255), |
|
| 4865 |
authordatum varchar(255), |
|
| 4866 |
authorlocation varchar(255), |
|
| 4867 |
locationnarrative varchar(255), |
|
| 4868 |
azimuth double, |
|
| 4869 |
shape varchar(255), |
|
| 4870 |
area_m2 double, |
|
| 4871 |
standsize varchar(255), |
|
| 4872 |
placementmethod varchar(255), |
|
| 4873 |
permanence int(1), |
|
| 4874 |
layoutnarrative varchar(255), |
|
| 4875 |
elevation_m double, |
|
| 4876 |
elevationaccuracy_m double, |
|
| 4877 |
elevationrange_m double, |
|
| 4878 |
verbatimelevation varchar(255), |
|
| 4879 |
slopeaspect_deg double, |
|
| 4880 |
minslopeaspect_deg double, |
|
| 4881 |
maxslopeaspect_deg double, |
|
| 4882 |
slopegradient_fraction double, |
|
| 4883 |
minslopegradient_fraction double, |
|
| 4884 |
maxslopegradient_fraction double, |
|
| 4885 |
topoposition varchar(255), |
|
| 4886 |
landform varchar(255), |
|
| 4887 |
surficialdeposits varchar(255), |
|
| 4888 |
rocktype varchar(255), |
|
| 4889 |
submitter_surname varchar(255), |
|
| 4890 |
submitter_givenname varchar(255), |
|
| 4891 |
submitter_email varchar(255), |
|
| 4892 |
notespublic int(1), |
|
| 4893 |
notesmgt int(1), |
|
| 4894 |
revisions int(1), |
|
| 4895 |
dateentered date , |
|
| 4896 |
locationrationalenarrative varchar(255) |
|
| 4897 |
); |
|
| 4898 |
|
|
| 4899 |
|
|
| 4900 | 4919 |
-- |
| 4901 |
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
|
|
| 4920 |
-- Name: COLUMN `viewFullOccurrence_individual`.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4902 | 4921 |
-- |
| 4903 | 4922 |
|
| 4904 | 4923 |
|
| 4905 | 4924 |
|
| 4906 | 4925 |
|
| 4907 | 4926 |
-- |
| 4908 |
-- Name: COLUMN location.plot_location_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 4927 |
-- Name: COLUMN `viewFullOccurrence_individual`.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4909 | 4928 |
-- |
| 4910 | 4929 |
|
| 4911 | 4930 |
|
| 4912 | 4931 |
|
| 4913 | 4932 |
|
| 4914 | 4933 |
-- |
| 4915 |
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 4934 |
-- Name: COLUMN `viewFullOccurrence_individual`.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4916 | 4935 |
-- |
| 4917 | 4936 |
|
| 4918 |
CREATE TABLE locationevent ( |
|
| 4919 |
locationevent_id int(11) NOT NULL, |
|
| 4920 |
source_id int(11) NOT NULL, |
|
| 4921 |
sourceaccessioncode varchar(255), |
|
| 4922 |
accesslevel varchar(255), |
|
| 4923 |
place_visit_id int(11) NOT NULL, |
|
| 4924 |
parent_id int(11), |
|
| 4925 |
plot_id int(11), |
|
| 4926 |
location_id int(11), |
|
| 4927 |
project_id int(11), |
|
| 4928 |
stratum_id int(11), |
|
| 4929 |
authoreventcode varchar(255), |
|
| 4930 |
previous_id int(11), |
|
| 4931 |
obsstartdate date, |
|
| 4932 |
obsenddate date, |
|
| 4933 |
dateaccuracy varchar(255), |
|
| 4934 |
method_id int(11), |
|
| 4935 |
temperature_c double, |
|
| 4936 |
precipitation_m double, |
|
| 4937 |
autotaxoncover int(1), |
|
| 4938 |
originaldata varchar(255), |
|
| 4939 |
effortlevel varchar(255), |
|
| 4940 |
floristicquality varchar(255), |
|
| 4941 |
bryophytequality varchar(255), |
|
| 4942 |
lichenquality varchar(255), |
|
| 4943 |
locationeventnarrative varchar(255), |
|
| 4944 |
landscapenarrative varchar(255), |
|
| 4945 |
homogeneity varchar(255), |
|
| 4946 |
phenologicaspect varchar(255), |
|
| 4947 |
representativeness varchar(255), |
|
| 4948 |
standmaturity varchar(255), |
|
| 4949 |
successionalstatus varchar(255), |
|
| 4950 |
basalarea double, |
|
| 4951 |
hydrologicregime varchar(255), |
|
| 4952 |
soilmoistureregime varchar(255), |
|
| 4953 |
soildrainage varchar(255), |
|
| 4954 |
watersalinity varchar(255), |
|
| 4955 |
waterdepth_m double, |
|
| 4956 |
shoredistance double, |
|
| 4957 |
soildepth double, |
|
| 4958 |
organicdepth double, |
|
| 4959 |
soiltaxon_id int(11), |
|
| 4960 |
soiltaxonsrc varchar(255), |
|
| 4961 |
percentbedrock double, |
|
| 4962 |
percentrockgravel double, |
|
| 4963 |
percentwood double, |
|
| 4964 |
percentlitter double, |
|
| 4965 |
percentbaresoil double, |
|
| 4966 |
percentwater double, |
|
| 4967 |
percentother double, |
|
| 4968 |
nameother varchar(255), |
|
| 4969 |
treeht double, |
|
| 4970 |
shrubht double, |
|
| 4971 |
fieldht double, |
|
| 4972 |
nonvascularht double, |
|
| 4973 |
submergedht double, |
|
| 4974 |
treecover double, |
|
| 4975 |
shrubcover double, |
|
| 4976 |
fieldcover double, |
|
| 4977 |
nonvascularcover double, |
|
| 4978 |
floatingcover double, |
|
| 4979 |
submergedcover double, |
|
| 4980 |
dominantstratum varchar(255), |
|
| 4981 |
growthform1type varchar(255), |
|
| 4982 |
growthform2type varchar(255), |
|
| 4983 |
growthform3type varchar(255), |
|
| 4984 |
growthform1cover double, |
|
| 4985 |
growthform2cover double, |
|
| 4986 |
growthform3cover double, |
|
| 4987 |
totalcover double, |
|
| 4988 |
notespublic int(1), |
|
| 4989 |
notesmgt int(1), |
|
| 4990 |
revisions int(1), |
|
| 4991 |
dateentered date , |
|
| 4992 |
toptaxon1name varchar(255), |
|
| 4993 |
toptaxon2name varchar(255), |
|
| 4994 |
toptaxon3name varchar(255), |
|
| 4995 |
toptaxon4name varchar(255), |
|
| 4996 |
toptaxon5name varchar(255), |
|
| 4997 |
numberoftaxa int(11) |
|
| 4998 |
); |
|
| 4999 | 4937 |
|
| 5000 | 4938 |
|
| 4939 |
|
|
| 5001 | 4940 |
-- |
| 5002 |
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
|
|
| 4941 |
-- Name: COLUMN `viewFullOccurrence_individual`.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5003 | 4942 |
-- |
| 5004 | 4943 |
|
| 5005 | 4944 |
|
| 5006 | 4945 |
|
| 5007 | 4946 |
|
| 5008 | 4947 |
-- |
| 5009 |
-- Name: COLUMN locationevent.place_visit_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 4948 |
-- Name: COLUMN `viewFullOccurrence_individual`.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5010 | 4949 |
-- |
| 5011 | 4950 |
|
| 5012 | 4951 |
|
| 5013 | 4952 |
|
| 5014 | 4953 |
|
| 5015 | 4954 |
-- |
| 5016 |
-- Name: COLUMN locationevent.plot_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 4955 |
-- Name: COLUMN `viewFullOccurrence_individual`.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5017 | 4956 |
-- |
| 5018 | 4957 |
|
| 5019 | 4958 |
|
| 5020 | 4959 |
|
| 5021 | 4960 |
|
| 5022 | 4961 |
-- |
| 5023 |
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 4962 |
-- Name: COLUMN `viewFullOccurrence_individual`.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5024 | 4963 |
-- |
| 5025 | 4964 |
|
| 5026 |
CREATE TABLE method ( |
|
| 5027 |
method_id int(11) NOT NULL, |
|
| 5028 |
source_id int(11) NOT NULL, |
|
| 5029 |
name varchar(255), |
|
| 5030 |
description varchar(255), |
|
| 5031 |
diameterheight_m double, |
|
| 5032 |
mindiameter_m double, |
|
| 5033 |
maxdiameter_m double, |
|
| 5034 |
minheight_m double, |
|
| 5035 |
maxheight_m double, |
|
| 5036 |
observationtype varchar(255), |
|
| 5037 |
observationmeasure varchar(255), |
|
| 5038 |
covermethod_id int(11), |
|
| 5039 |
samplingfactor double DEFAULT 1 NOT NULL, |
|
| 5040 |
coverbasis varchar(255), |
|
| 5041 |
stemsamplemethod varchar(255), |
|
| 5042 |
shape varchar(255), |
|
| 5043 |
length_m double, |
|
| 5044 |
width_m double, |
|
| 5045 |
radius_m double, |
|
| 5046 |
area_m2 double, |
|
| 5047 |
samplearea_m2 double, |
|
| 5048 |
subplotspacing_m double, |
|
| 5049 |
subplotmethod_id int(11), |
|
| 5050 |
pointsperline int(11) |
|
| 5051 |
); |
|
| 5052 | 4965 |
|
| 5053 | 4966 |
|
| 4967 |
|
|
| 5054 | 4968 |
-- |
| 5055 |
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
|
|
| 4969 |
-- Name: COLUMN `viewFullOccurrence_individual`.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5056 | 4970 |
-- |
| 5057 | 4971 |
|
| 5058 | 4972 |
|
| 5059 | 4973 |
|
| 5060 | 4974 |
|
| 5061 | 4975 |
-- |
| 5062 |
-- Name: COLUMN method.source_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 4976 |
-- Name: COLUMN `viewFullOccurrence_individual`.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5063 | 4977 |
-- |
| 5064 | 4978 |
|
| 5065 | 4979 |
|
| 5066 | 4980 |
|
| 5067 | 4981 |
|
| 5068 | 4982 |
-- |
| 5069 |
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
|
|
| 4983 |
-- Name: COLUMN `viewFullOccurrence_individual`.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5070 | 4984 |
-- |
| 5071 | 4985 |
|
| 5072 | 4986 |
|
| 5073 | 4987 |
|
| 5074 | 4988 |
|
| 5075 | 4989 |
-- |
| 5076 |
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
|
|
| 4990 |
-- Name: COLUMN `viewFullOccurrence_individual`.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5077 | 4991 |
-- |
| 5078 | 4992 |
|
| 5079 | 4993 |
|
| 5080 | 4994 |
|
| 5081 | 4995 |
|
| 5082 | 4996 |
-- |
| 5083 |
-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 4997 |
-- Name: COLUMN `viewFullOccurrence_individual`.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5084 | 4998 |
-- |
| 5085 | 4999 |
|
| 5086 | 5000 |
|
| 5087 | 5001 |
|
| 5088 | 5002 |
|
| 5089 | 5003 |
-- |
| 5090 |
-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5004 |
-- Name: COLUMN `viewFullOccurrence_individual`.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5091 | 5005 |
-- |
| 5092 | 5006 |
|
| 5093 | 5007 |
|
| 5094 | 5008 |
|
| 5095 | 5009 |
|
| 5096 | 5010 |
-- |
| 5097 |
-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5011 |
-- Name: COLUMN `viewFullOccurrence_individual`.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5098 | 5012 |
-- |
| 5099 | 5013 |
|
| 5100 | 5014 |
|
| 5101 | 5015 |
|
| 5102 | 5016 |
|
| 5103 | 5017 |
-- |
| 5104 |
-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5018 |
-- Name: COLUMN `viewFullOccurrence_individual`.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5105 | 5019 |
-- |
| 5106 | 5020 |
|
| 5107 | 5021 |
|
| 5108 | 5022 |
|
| 5109 | 5023 |
|
| 5110 | 5024 |
-- |
| 5111 |
-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5025 |
-- Name: COLUMN `viewFullOccurrence_individual`.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5112 | 5026 |
-- |
| 5113 | 5027 |
|
| 5114 | 5028 |
|
| 5115 | 5029 |
|
| 5116 | 5030 |
|
| 5117 | 5031 |
-- |
| 5118 |
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
|
|
| 5032 |
-- Name: COLUMN `viewFullOccurrence_individual`.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5119 | 5033 |
-- |
| 5120 | 5034 |
|
| 5121 | 5035 |
|
| 5122 | 5036 |
|
| 5123 | 5037 |
|
| 5124 | 5038 |
-- |
| 5125 |
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
|
|
| 5039 |
-- Name: COLUMN `viewFullOccurrence_individual`.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5126 | 5040 |
-- |
| 5127 | 5041 |
|
| 5128 | 5042 |
|
| 5129 | 5043 |
|
| 5130 | 5044 |
|
| 5131 | 5045 |
-- |
| 5132 |
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
|
|
| 5046 |
-- Name: COLUMN `viewFullOccurrence_individual`.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5133 | 5047 |
-- |
| 5134 | 5048 |
|
| 5135 | 5049 |
|
| 5136 | 5050 |
|
| 5137 | 5051 |
|
| 5138 | 5052 |
-- |
| 5139 |
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
|
|
| 5053 |
-- Name: COLUMN `viewFullOccurrence_individual`.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5140 | 5054 |
-- |
| 5141 | 5055 |
|
| 5142 | 5056 |
|
| 5143 | 5057 |
|
| 5144 | 5058 |
|
| 5145 | 5059 |
-- |
| 5146 |
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
|
|
| 5060 |
-- Name: COLUMN `viewFullOccurrence_individual`.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5147 | 5061 |
-- |
| 5148 | 5062 |
|
| 5149 | 5063 |
|
| 5150 | 5064 |
|
| 5151 | 5065 |
|
| 5152 | 5066 |
-- |
| 5153 |
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
|
|
| 5067 |
-- Name: COLUMN `viewFullOccurrence_individual`.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5154 | 5068 |
-- |
| 5155 | 5069 |
|
| 5156 | 5070 |
|
| 5157 | 5071 |
|
| 5158 | 5072 |
|
| 5159 | 5073 |
-- |
| 5160 |
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
|
|
| 5074 |
-- Name: COLUMN `viewFullOccurrence_individual`.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5161 | 5075 |
-- |
| 5162 | 5076 |
|
| 5163 | 5077 |
|
| 5164 | 5078 |
|
| 5165 | 5079 |
|
| 5166 | 5080 |
-- |
| 5167 |
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 5081 |
-- Name: COLUMN `viewFullOccurrence_individual`.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5168 | 5082 |
-- |
| 5169 | 5083 |
|
| 5170 | 5084 |
|
| 5171 | 5085 |
|
| 5172 | 5086 |
|
| 5173 | 5087 |
-- |
| 5174 |
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 5088 |
-- Name: COLUMN `viewFullOccurrence_individual`.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5175 | 5089 |
-- |
| 5176 | 5090 |
|
| 5177 | 5091 |
|
| 5178 | 5092 |
|
| 5179 | 5093 |
|
| 5180 | 5094 |
-- |
| 5181 |
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
|
|
| 5095 |
-- Name: COLUMN `viewFullOccurrence_individual`.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5182 | 5096 |
-- |
| 5183 | 5097 |
|
| 5184 | 5098 |
|
| 5185 | 5099 |
|
| 5186 | 5100 |
|
| 5187 | 5101 |
-- |
| 5188 |
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5102 |
-- Name: COLUMN `viewFullOccurrence_individual`.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5189 | 5103 |
-- |
| 5190 | 5104 |
|
| 5191 |
CREATE TABLE party ( |
|
| 5192 |
party_id int(11) NOT NULL, |
|
| 5193 |
source_id int(11) NOT NULL, |
|
| 5194 |
sourceaccessioncode varchar(255), |
|
| 5195 |
fullname varchar(255), |
|
| 5196 |
salutation varchar(255), |
|
| 5197 |
givenname varchar(255), |
|
| 5198 |
middlename varchar(255), |
|
| 5199 |
surname varchar(255), |
|
| 5200 |
suffix varchar(255), |
|
| 5201 |
department varchar(255), |
|
| 5202 |
organizationname varchar(255), |
|
| 5203 |
currentname_id int(11), |
|
| 5204 |
contactinstructions varchar(255), |
|
| 5205 |
email varchar(255), |
|
| 5206 |
partytype varchar(255), |
|
| 5207 |
partypublic int(1) DEFAULT true |
|
| 5208 |
); |
|
| 5209 | 5105 |
|
| 5210 | 5106 |
|
| 5211 |
-- |
|
| 5212 |
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 5213 |
-- |
|
| 5214 | 5107 |
|
| 5215 |
CREATE TABLE plantobservation ( |
|
| 5216 |
plantobservation_id int(11) NOT NULL, |
|
| 5217 |
source_id int(11) NOT NULL, |
|
| 5218 |
sourceaccessioncode varchar(255), |
|
| 5219 |
aggregateoccurrence_id int(11), |
|
| 5220 |
overallheight_m double, |
|
| 5221 |
overallheightaccuracy_m double, |
|
| 5222 |
authorplantcode varchar(255), |
|
| 5223 |
stemcount int(11), |
|
| 5224 |
reproductivecondition varchar(255), |
|
| 5225 |
plant_id int(11) |
|
| 5226 |
); |
|
| 5227 |
|
|
| 5228 |
|
|
| 5229 | 5108 |
-- |
| 5230 |
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
|
|
| 5109 |
-- Name: COLUMN `viewFullOccurrence_individual`.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5231 | 5110 |
-- |
| 5232 | 5111 |
|
| 5233 | 5112 |
|
| 5234 | 5113 |
|
| 5235 | 5114 |
|
| 5236 | 5115 |
-- |
| 5237 |
-- Name: COLUMN plantobservation.authorplantcode; Type: COMMENT; Schema: public; Owner: -
|
|
| 5116 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5238 | 5117 |
-- |
| 5239 | 5118 |
|
| 5240 | 5119 |
|
| 5241 | 5120 |
|
| 5242 | 5121 |
|
| 5243 | 5122 |
-- |
| 5244 |
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5123 |
-- Name: COLUMN `viewFullOccurrence_individual`.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5245 | 5124 |
-- |
| 5246 | 5125 |
|
| 5247 |
CREATE TABLE project ( |
|
| 5248 |
project_id int(11) NOT NULL, |
|
| 5249 |
source_id int(11) NOT NULL, |
|
| 5250 |
sourceaccessioncode varchar(255), |
|
| 5251 |
projectname varchar(255), |
|
| 5252 |
projectdescription varchar(255), |
|
| 5253 |
startdate date, |
|
| 5254 |
stopdate date |
|
| 5255 |
); |
|
| 5256 | 5126 |
|
| 5257 | 5127 |
|
| 5258 |
-- |
|
| 5259 |
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 5260 |
-- |
|
| 5261 | 5128 |
|
| 5262 |
CREATE TABLE stratum ( |
|
| 5263 |
stratum_id int(11) NOT NULL, |
|
| 5264 |
source_id int(11) NOT NULL, |
|
| 5265 |
stratumname varchar(255) NOT NULL, |
|
| 5266 |
stratumheight double, |
|
| 5267 |
stratumbase double, |
|
| 5268 |
stratumcover double, |
|
| 5269 |
area double, |
|
| 5270 |
method_id int(11) |
|
| 5271 |
); |
|
| 5272 |
|
|
| 5273 |
|
|
| 5274 | 5129 |
-- |
| 5275 |
-- Name: plot.**; Type: VIEW; Schema: public; Owner: -
|
|
| 5130 |
-- Name: COLUMN `viewFullOccurrence_individual`.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5276 | 5131 |
-- |
| 5277 | 5132 |
|
| 5278 | 5133 |
|
| 5279 | 5134 |
|
| 5280 | 5135 |
|
| 5281 | 5136 |
-- |
| 5282 |
-- Name: COLUMN `plot.**`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5137 |
-- Name: COLUMN `viewFullOccurrence_individual`.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5283 | 5138 |
-- |
| 5284 | 5139 |
|
| 5285 | 5140 |
|
| 5286 | 5141 |
|
| 5287 | 5142 |
|
| 5288 | 5143 |
-- |
| 5289 |
-- Name: COLUMN `plot.**`.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5144 |
-- Name: COLUMN `viewFullOccurrence_individual`.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5290 | 5145 |
-- |
| 5291 | 5146 |
|
| 5292 | 5147 |
|
| 5293 | 5148 |
|
| 5294 | 5149 |
|
| 5295 | 5150 |
-- |
| 5296 |
-- Name: COLUMN `plot.**`.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5151 |
-- Name: COLUMN `viewFullOccurrence_individual`.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5297 | 5152 |
-- |
| 5298 | 5153 |
|
| 5299 | 5154 |
|
| 5300 | 5155 |
|
| 5301 | 5156 |
|
| 5302 | 5157 |
-- |
| 5303 |
-- Name: COLUMN `plot.**`.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5158 |
-- Name: COLUMN `viewFullOccurrence_individual`.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5304 | 5159 |
-- |
| 5305 | 5160 |
|
| 5306 | 5161 |
|
| 5307 | 5162 |
|
| 5308 | 5163 |
|
| 5309 | 5164 |
-- |
| 5310 |
-- Name: COLUMN `plot.**`.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5165 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5311 | 5166 |
-- |
| 5312 | 5167 |
|
| 5313 | 5168 |
|
| 5314 | 5169 |
|
| 5315 | 5170 |
|
| 5316 | 5171 |
-- |
| 5317 |
-- Name: COLUMN `plot.**`.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5172 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5318 | 5173 |
-- |
| 5319 | 5174 |
|
| 5320 | 5175 |
|
| 5321 | 5176 |
|
| 5322 | 5177 |
|
| 5323 | 5178 |
-- |
| 5324 |
-- Name: COLUMN `plot.**`.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5179 |
-- Name: COLUMN `viewFullOccurrence_individual`.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5325 | 5180 |
-- |
| 5326 | 5181 |
|
| 5327 | 5182 |
|
| 5328 | 5183 |
|
| 5329 | 5184 |
|
| 5330 | 5185 |
-- |
| 5331 |
-- Name: COLUMN `plot.**`.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5186 |
-- Name: COLUMN `viewFullOccurrence_individual`.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5332 | 5187 |
-- |
| 5333 | 5188 |
|
| 5334 | 5189 |
|
| 5335 | 5190 |
|
| 5336 | 5191 |
|
| 5337 | 5192 |
-- |
| 5338 |
-- Name: COLUMN `plot.**`.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5193 |
-- Name: COLUMN `viewFullOccurrence_individual`.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5339 | 5194 |
-- |
| 5340 | 5195 |
|
| 5341 | 5196 |
|
| 5342 | 5197 |
|
| 5343 | 5198 |
|
| 5344 | 5199 |
-- |
| 5345 |
-- Name: COLUMN `plot.**`.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5200 |
-- Name: COLUMN `viewFullOccurrence_individual`.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5346 | 5201 |
-- |
| 5347 | 5202 |
|
| 5348 | 5203 |
|
| 5349 | 5204 |
|
| 5350 | 5205 |
|
| 5351 | 5206 |
-- |
| 5352 |
-- Name: COLUMN `plot.**`.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5207 |
-- Name: COLUMN `viewFullOccurrence_individual`.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5353 | 5208 |
-- |
| 5354 | 5209 |
|
| 5355 | 5210 |
|
| 5356 | 5211 |
|
| 5357 | 5212 |
|
| 5358 | 5213 |
-- |
| 5359 |
-- Name: COLUMN `plot.**`.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5214 |
-- Name: COLUMN `viewFullOccurrence_individual`.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5360 | 5215 |
-- |
| 5361 | 5216 |
|
| 5362 | 5217 |
|
| 5363 | 5218 |
|
| 5364 | 5219 |
|
| 5365 | 5220 |
-- |
| 5366 |
-- Name: COLUMN `plot.**`.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5221 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5367 | 5222 |
-- |
| 5368 | 5223 |
|
| 5369 | 5224 |
|
| 5370 | 5225 |
|
| 5371 | 5226 |
|
| 5372 | 5227 |
-- |
| 5373 |
-- Name: COLUMN `plot.**`.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5228 |
-- Name: COLUMN `viewFullOccurrence_individual`.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5374 | 5229 |
-- |
| 5375 | 5230 |
|
| 5376 | 5231 |
|
| 5377 | 5232 |
|
| 5378 | 5233 |
|
| 5379 | 5234 |
-- |
| 5380 |
-- Name: COLUMN `plot.**`.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5235 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
|
|
| 5381 | 5236 |
-- |
| 5382 | 5237 |
|
| 5383 | 5238 |
|
| 5384 | 5239 |
|
| 5385 | 5240 |
|
| 5386 | 5241 |
-- |
| 5387 |
-- Name: COLUMN `plot.**`.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5242 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 5388 | 5243 |
-- |
| 5389 | 5244 |
|
| 5390 | 5245 |
|
| 5391 | 5246 |
|
| 5392 | 5247 |
|
| 5393 | 5248 |
-- |
| 5394 |
-- Name: COLUMN `plot.**`.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5249 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
|
|
| 5395 | 5250 |
-- |
| 5396 | 5251 |
|
| 5397 | 5252 |
|
| 5398 | 5253 |
|
| 5399 | 5254 |
|
| 5400 | 5255 |
-- |
| 5401 |
-- Name: COLUMN `plot.**`.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5256 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
|
|
| 5402 | 5257 |
-- |
| 5403 | 5258 |
|
| 5404 | 5259 |
|
| 5405 | 5260 |
|
| 5406 | 5261 |
|
| 5407 | 5262 |
-- |
| 5408 |
-- Name: COLUMN `plot.**`.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5263 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 5409 | 5264 |
-- |
| 5410 | 5265 |
|
| 5411 | 5266 |
|
| 5412 | 5267 |
|
| 5413 | 5268 |
|
| 5414 | 5269 |
-- |
| 5415 |
-- Name: COLUMN `plot.**`.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5270 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 5416 | 5271 |
-- |
| 5417 | 5272 |
|
| 5418 | 5273 |
|
| 5419 | 5274 |
|
| 5420 | 5275 |
|
| 5421 | 5276 |
-- |
| 5422 |
-- Name: COLUMN `plot.**`.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5277 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 5423 | 5278 |
-- |
| 5424 | 5279 |
|
| 5425 | 5280 |
|
| 5426 | 5281 |
|
| 5427 | 5282 |
|
| 5428 | 5283 |
-- |
| 5429 |
-- Name: COLUMN `plot.**`.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5284 |
-- Name: COLUMN `viewFullOccurrence_individual`.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5430 | 5285 |
-- |
| 5431 | 5286 |
|
| 5432 | 5287 |
|
| 5433 | 5288 |
|
| 5434 | 5289 |
|
| 5435 | 5290 |
-- |
| 5436 |
-- Name: COLUMN `plot.**`.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5291 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5437 | 5292 |
-- |
| 5438 | 5293 |
|
| 5439 | 5294 |
|
| 5440 | 5295 |
|
| 5441 | 5296 |
|
| 5442 | 5297 |
-- |
| 5443 |
-- Name: COLUMN `plot.**`.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5298 |
-- Name: COLUMN `viewFullOccurrence_individual`.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5444 | 5299 |
-- |
| 5445 | 5300 |
|
| 5446 | 5301 |
|
| 5447 | 5302 |
|
| 5448 | 5303 |
|
| 5449 | 5304 |
-- |
| 5450 |
-- Name: COLUMN `plot.**`.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5305 |
-- Name: COLUMN `viewFullOccurrence_individual`.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5451 | 5306 |
-- |
| 5452 | 5307 |
|
| 5453 | 5308 |
|
| 5454 | 5309 |
|
| 5455 | 5310 |
|
| 5456 | 5311 |
-- |
| 5457 |
-- Name: COLUMN `plot.**`.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5312 |
-- Name: COLUMN `viewFullOccurrence_individual`.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5458 | 5313 |
-- |
| 5459 | 5314 |
|
| 5460 | 5315 |
|
| 5461 | 5316 |
|
| 5462 | 5317 |
|
| 5463 | 5318 |
-- |
| 5464 |
-- Name: COLUMN `plot.**`.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5319 |
-- Name: COLUMN `viewFullOccurrence_individual`.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5465 | 5320 |
-- |
| 5466 | 5321 |
|
| 5467 | 5322 |
|
| 5468 | 5323 |
|
| 5469 | 5324 |
|
| 5470 | 5325 |
-- |
| 5471 |
-- Name: COLUMN `plot.**`.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5326 |
-- Name: COLUMN `viewFullOccurrence_individual`.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5472 | 5327 |
-- |
| 5473 | 5328 |
|
| 5474 | 5329 |
|
| 5475 | 5330 |
|
| 5476 | 5331 |
|
| 5477 | 5332 |
-- |
| 5478 |
-- Name: COLUMN `plot.**`.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5333 |
-- Name: COLUMN `viewFullOccurrence_individual`.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5479 | 5334 |
-- |
| 5480 | 5335 |
|
| 5481 | 5336 |
|
| 5482 | 5337 |
|
| 5483 | 5338 |
|
| 5484 | 5339 |
-- |
| 5485 |
-- Name: COLUMN `plot.**`.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5340 |
-- Name: COLUMN `viewFullOccurrence_individual`.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5486 | 5341 |
-- |
| 5487 | 5342 |
|
| 5488 | 5343 |
|
| 5489 | 5344 |
|
| 5490 | 5345 |
|
| 5491 | 5346 |
-- |
| 5492 |
-- Name: sourcelist; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5347 |
-- Name: COLUMN `viewFullOccurrence_individual`.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5493 | 5348 |
-- |
| 5494 | 5349 |
|
| 5495 |
CREATE TABLE sourcelist ( |
|
| 5496 |
sourcelist_id int(11) NOT NULL, |
|
| 5497 |
source_id int(11) NOT NULL, |
|
| 5498 |
name varchar(255) NOT NULL |
|
| 5499 |
); |
|
| 5500 | 5350 |
|
| 5501 | 5351 |
|
| 5502 |
-- |
|
| 5503 |
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 5504 |
-- |
|
| 5505 | 5352 |
|
| 5506 |
CREATE TABLE specimenreplicate ( |
|
| 5507 |
specimenreplicate_id int(11) NOT NULL, |
|
| 5508 |
source_id int(11) NOT NULL, |
|
| 5509 |
sourceaccessioncode varchar(255), |
|
| 5510 |
plantobservation_id int(11), |
|
| 5511 |
duplicate_institutions_sourcelist_id int(11), |
|
| 5512 |
collectioncode_dwc varchar(255), |
|
| 5513 |
catalognumber_dwc varchar(255), |
|
| 5514 |
collectionnumber varchar(255), |
|
| 5515 |
description varchar(255), |
|
| 5516 |
specimen_id int(11) |
|
| 5517 |
); |
|
| 5518 |
|
|
| 5519 |
|
|
| 5520 | 5353 |
-- |
| 5521 |
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
|
|
| 5354 |
-- Name: COLUMN `viewFullOccurrence_individual`.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5522 | 5355 |
-- |
| 5523 | 5356 |
|
| 5524 | 5357 |
|
| 5525 | 5358 |
|
| 5526 | 5359 |
|
| 5527 | 5360 |
-- |
| 5528 |
-- Name: COLUMN specimenreplicate.duplicate_institutions_sourcelist_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 5361 |
-- Name: COLUMN `viewFullOccurrence_individual`.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5529 | 5362 |
-- |
| 5530 | 5363 |
|
| 5531 | 5364 |
|
| 5532 | 5365 |
|
| 5533 | 5366 |
|
| 5534 | 5367 |
-- |
| 5535 |
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 5368 |
-- Name: COLUMN `viewFullOccurrence_individual`.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5536 | 5369 |
-- |
| 5537 | 5370 |
|
| 5538 | 5371 |
|
| 5539 | 5372 |
|
| 5540 | 5373 |
|
| 5541 | 5374 |
-- |
| 5542 |
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5375 |
-- Name: COLUMN `viewFullOccurrence_individual`.`plantobservation.``_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5543 | 5376 |
-- |
| 5544 | 5377 |
|
| 5545 |
CREATE TABLE stemobservation ( |
|
| 5546 |
stemobservation_id int(11) NOT NULL, |
|
| 5547 |
source_id int(11) NOT NULL, |
|
| 5548 |
sourceaccessioncode varchar(255), |
|
| 5549 |
plantobservation_id int(11) NOT NULL, |
|
| 5550 |
authorstemcode varchar(255), |
|
| 5551 |
tag varchar(255), |
|
| 5552 |
tags varchar(255), |
|
| 5553 |
xposition_m double, |
|
| 5554 |
yposition_m double, |
|
| 5555 |
diameterbreastheight_m double, |
|
| 5556 |
basaldiameter_m double, |
|
| 5557 |
diameteraccuracy_m double, |
|
| 5558 |
height_m double, |
|
| 5559 |
heightfirstbranch_m double, |
|
| 5560 |
heightaccuracy_m double, |
|
| 5561 |
health varchar(255), |
|
| 5562 |
age double |
|
| 5563 |
); |
|
| 5564 | 5378 |
|
| 5565 | 5379 |
|
| 5380 |
|
|
| 5566 | 5381 |
-- |
| 5567 |
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
|
|
| 5382 |
-- Name: COLUMN `viewFullOccurrence_individual`.`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5568 | 5383 |
-- |
| 5569 | 5384 |
|
| 5570 | 5385 |
|
| 5571 | 5386 |
|
| 5572 | 5387 |
|
| 5573 | 5388 |
-- |
| 5574 |
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public; Owner: -
|
|
| 5389 |
-- Name: analytical_stem_view; Type: VIEW; Schema: public; Owner: -
|
|
| 5575 | 5390 |
-- |
| 5576 | 5391 |
|
| 5577 | 5392 |
|
| 5578 | 5393 |
|
| 5579 | 5394 |
|
| 5580 | 5395 |
-- |
| 5581 |
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5396 |
-- Name: VIEW analytical_stem_view; Type: COMMENT; Schema: public; Owner: -
|
|
| 5582 | 5397 |
-- |
| 5583 | 5398 |
|
| 5584 |
CREATE TABLE taxondetermination ( |
|
| 5585 |
taxondetermination_id int(11) NOT NULL, |
|
| 5586 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 5587 |
source_id int(11) NOT NULL, |
|
| 5588 |
taxonverbatim_id int(11) NOT NULL, |
|
| 5589 |
party_id int(11), |
|
| 5590 |
role varchar(255) DEFAULT 'unknown' NOT NULL, |
|
| 5591 |
determinationtype varchar(255), |
|
| 5592 |
reference_id int(11), |
|
| 5593 |
isoriginal int(1), |
|
| 5594 |
iscurrent__verbatim int(1), |
|
| 5595 |
iscurrent int(1) DEFAULT false NOT NULL, |
|
| 5596 |
taxonfit varchar(255), |
|
| 5597 |
taxonconfidence varchar(255), |
|
| 5598 |
grouptype varchar(255), |
|
| 5599 |
notes varchar(255), |
|
| 5600 |
revisions int(1), |
|
| 5601 |
determinationdate date |
|
| 5602 |
); |
|
| 5603 | 5399 |
|
| 5604 | 5400 |
|
| 5401 |
|
|
| 5605 | 5402 |
-- |
| 5606 |
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
|
|
| 5403 |
-- Name: COLUMN analytical_stem_view.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5607 | 5404 |
-- |
| 5608 | 5405 |
|
| 5609 | 5406 |
|
| 5610 | 5407 |
|
| 5611 | 5408 |
|
| 5612 | 5409 |
-- |
| 5613 |
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5410 |
-- Name: COLUMN analytical_stem_view.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5614 | 5411 |
-- |
| 5615 | 5412 |
|
| 5616 |
CREATE TABLE taxonoccurrence ( |
|
| 5617 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 5618 |
source_id int(11) NOT NULL, |
|
| 5619 |
sourceaccessioncode varchar(255), |
|
| 5620 |
locationevent_id int(11), |
|
| 5621 |
authortaxoncode varchar(255), |
|
| 5622 |
collector_id int(11), |
|
| 5623 |
growthform varchar(255), |
|
| 5624 |
iscultivated int(1), |
|
| 5625 |
cultivatedbasis varchar(255), |
|
| 5626 |
isnative int(1) |
|
| 5627 |
); |
|
| 5628 | 5413 |
|
| 5629 | 5414 |
|
| 5415 |
|
|
| 5630 | 5416 |
-- |
| 5631 |
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
|
|
| 5417 |
-- Name: COLUMN analytical_stem_view.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5632 | 5418 |
-- |
| 5633 | 5419 |
|
| 5634 | 5420 |
|
| 5635 | 5421 |
|
| 5636 | 5422 |
|
| 5637 | 5423 |
-- |
| 5638 |
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
|
|
| 5424 |
-- Name: COLUMN analytical_stem_view.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5639 | 5425 |
-- |
| 5640 | 5426 |
|
| 5641 | 5427 |
|
| 5642 | 5428 |
|
| 5643 | 5429 |
|
| 5644 | 5430 |
-- |
| 5645 |
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
|
|
| 5431 |
-- Name: COLUMN analytical_stem_view.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5646 | 5432 |
-- |
| 5647 | 5433 |
|
| 5648 | 5434 |
|
| 5649 | 5435 |
|
| 5650 | 5436 |
|
| 5651 | 5437 |
-- |
| 5652 |
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
|
|
| 5438 |
-- Name: COLUMN analytical_stem_view.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5653 | 5439 |
-- |
| 5654 | 5440 |
|
| 5655 | 5441 |
|
| 5656 | 5442 |
|
| 5657 | 5443 |
|
| 5658 | 5444 |
-- |
| 5659 |
-- Name: taxonverbatim; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 5445 |
-- Name: COLUMN analytical_stem_view.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5660 | 5446 |
-- |
| 5661 | 5447 |
|
| 5662 |
CREATE TABLE taxonverbatim ( |
|
| 5663 |
taxonverbatim_id int(11) NOT NULL, |
|
| 5664 |
source_id int(11) NOT NULL, |
|
| 5665 |
taxonlabel_id int(11), |
|
| 5666 |
verbatimrank varchar(255), |
|
| 5667 |
taxonomicname varchar(255), |
|
| 5668 |
taxonname varchar(255), |
|
| 5669 |
author varchar(255), |
|
| 5670 |
family varchar(255), |
|
| 5671 |
genus varchar(255), |
|
| 5672 |
specific_epithet varchar(255), |
|
| 5673 |
subspecies varchar(255), |
|
| 5674 |
morphospecies varchar(255), |
|
| 5675 |
morphoname varchar(255), |
|
| 5676 |
growthform varchar(255), |
|
| 5677 |
description varchar(255) |
|
| 5678 |
); |
|
| 5679 | 5448 |
|
| 5680 | 5449 |
|
| 5450 |
|
|
| 5681 | 5451 |
-- |
| 5682 |
-- Name: TABLE taxonverbatim; Type: COMMENT; Schema: public; Owner: -
|
|
| 5452 |
-- Name: COLUMN analytical_stem_view.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5683 | 5453 |
-- |
| 5684 | 5454 |
|
| 5685 | 5455 |
|
| 5686 | 5456 |
|
| 5687 | 5457 |
|
| 5688 | 5458 |
-- |
| 5689 |
-- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public; Owner: -
|
|
| 5459 |
-- Name: COLUMN analytical_stem_view.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5690 | 5460 |
-- |
| 5691 | 5461 |
|
| 5692 | 5462 |
|
| 5693 | 5463 |
|
| 5694 | 5464 |
|
| 5695 | 5465 |
-- |
| 5696 |
-- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public; Owner: -
|
|
| 5466 |
-- Name: COLUMN analytical_stem_view.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5697 | 5467 |
-- |
| 5698 | 5468 |
|
| 5699 | 5469 |
|
| 5700 | 5470 |
|
| 5701 | 5471 |
|
| 5702 | 5472 |
-- |
| 5703 |
-- Name: COLUMN taxonverbatim.taxonname; Type: COMMENT; Schema: public; Owner: -
|
|
| 5473 |
-- Name: COLUMN analytical_stem_view.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5704 | 5474 |
-- |
| 5705 | 5475 |
|
| 5706 | 5476 |
|
| 5707 | 5477 |
|
| 5708 | 5478 |
|
| 5709 | 5479 |
-- |
| 5710 |
-- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public; Owner: -
|
|
| 5480 |
-- Name: COLUMN analytical_stem_view.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5711 | 5481 |
-- |
| 5712 | 5482 |
|
| 5713 | 5483 |
|
| 5714 | 5484 |
|
| 5715 | 5485 |
|
| 5716 | 5486 |
-- |
| 5717 |
-- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public; Owner: -
|
|
| 5487 |
-- Name: COLUMN analytical_stem_view.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5718 | 5488 |
-- |
| 5719 | 5489 |
|
| 5720 | 5490 |
|
| 5721 | 5491 |
|
| 5722 | 5492 |
|
| 5723 | 5493 |
-- |
| 5724 |
-- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 5494 |
-- Name: COLUMN analytical_stem_view.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5725 | 5495 |
-- |
| 5726 | 5496 |
|
| 5727 | 5497 |
|
| 5728 | 5498 |
|
| 5729 | 5499 |
|
| 5730 | 5500 |
-- |
| 5731 |
-- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public; Owner: -
|
|
| 5501 |
-- Name: COLUMN analytical_stem_view.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5732 | 5502 |
-- |
| 5733 | 5503 |
|
| 5734 | 5504 |
|
| 5735 | 5505 |
|
| 5736 | 5506 |
|
| 5737 | 5507 |
-- |
| 5738 |
-- Name: COLUMN taxonverbatim.morphospecies; Type: COMMENT; Schema: public; Owner: -
|
|
| 5508 |
-- Name: COLUMN analytical_stem_view.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5739 | 5509 |
-- |
| 5740 | 5510 |
|
| 5741 | 5511 |
|
| 5742 | 5512 |
|
| 5743 | 5513 |
|
| 5744 | 5514 |
-- |
| 5745 |
-- Name: viewFullOccurrence_individual_view; Type: VIEW; Schema: public; Owner: -
|
|
| 5515 |
-- Name: COLUMN analytical_stem_view.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5746 | 5516 |
-- |
| 5747 | 5517 |
|
| 5748 | 5518 |
|
| 5749 | 5519 |
|
| 5750 | 5520 |
|
| 5751 | 5521 |
-- |
| 5752 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5522 |
-- Name: COLUMN analytical_stem_view.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5753 | 5523 |
-- |
| 5754 | 5524 |
|
| 5755 | 5525 |
|
| 5756 | 5526 |
|
| 5757 | 5527 |
|
| 5758 | 5528 |
-- |
| 5759 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5529 |
-- Name: COLUMN analytical_stem_view.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5760 | 5530 |
-- |
| 5761 | 5531 |
|
| 5762 | 5532 |
|
| 5763 | 5533 |
|
| 5764 | 5534 |
|
| 5765 | 5535 |
-- |
| 5766 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5536 |
-- Name: COLUMN analytical_stem_view.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5767 | 5537 |
-- |
| 5768 | 5538 |
|
| 5769 | 5539 |
|
| 5770 | 5540 |
|
| 5771 | 5541 |
|
| 5772 | 5542 |
-- |
| 5773 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5543 |
-- Name: COLUMN analytical_stem_view.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5774 | 5544 |
-- |
| 5775 | 5545 |
|
| 5776 | 5546 |
|
| 5777 | 5547 |
|
| 5778 | 5548 |
|
| 5779 | 5549 |
-- |
| 5780 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5550 |
-- Name: COLUMN analytical_stem_view.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5781 | 5551 |
-- |
| 5782 | 5552 |
|
| 5783 | 5553 |
|
| 5784 | 5554 |
|
| 5785 | 5555 |
|
| 5786 | 5556 |
-- |
| 5787 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5557 |
-- Name: COLUMN analytical_stem_view.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5788 | 5558 |
-- |
| 5789 | 5559 |
|
| 5790 | 5560 |
|
| 5791 | 5561 |
|
| 5792 | 5562 |
|
| 5793 | 5563 |
-- |
| 5794 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5564 |
-- Name: COLUMN analytical_stem_view.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5795 | 5565 |
-- |
| 5796 | 5566 |
|
| 5797 | 5567 |
|
| 5798 | 5568 |
|
| 5799 | 5569 |
|
| 5800 | 5570 |
-- |
| 5801 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5571 |
-- Name: COLUMN analytical_stem_view.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5802 | 5572 |
-- |
| 5803 | 5573 |
|
| 5804 | 5574 |
|
| 5805 | 5575 |
|
| 5806 | 5576 |
|
| 5807 | 5577 |
-- |
| 5808 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5578 |
-- Name: COLUMN analytical_stem_view.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5809 | 5579 |
-- |
| 5810 | 5580 |
|
| 5811 | 5581 |
|
| 5812 | 5582 |
|
| 5813 | 5583 |
|
| 5814 | 5584 |
-- |
| 5815 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5585 |
-- Name: COLUMN analytical_stem_view.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5816 | 5586 |
-- |
| 5817 | 5587 |
|
| 5818 | 5588 |
|
| 5819 | 5589 |
|
| 5820 | 5590 |
|
| 5821 | 5591 |
-- |
| 5822 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5592 |
-- Name: COLUMN analytical_stem_view.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5823 | 5593 |
-- |
| 5824 | 5594 |
|
| 5825 | 5595 |
|
| 5826 | 5596 |
|
| 5827 | 5597 |
|
| 5828 | 5598 |
-- |
| 5829 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5599 |
-- Name: COLUMN analytical_stem_view.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5830 | 5600 |
-- |
| 5831 | 5601 |
|
| 5832 | 5602 |
|
| 5833 | 5603 |
|
| 5834 | 5604 |
|
| 5835 | 5605 |
-- |
| 5836 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5606 |
-- Name: COLUMN analytical_stem_view.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5837 | 5607 |
-- |
| 5838 | 5608 |
|
| 5839 | 5609 |
|
| 5840 | 5610 |
|
| 5841 | 5611 |
|
| 5842 | 5612 |
-- |
| 5843 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5613 |
-- Name: COLUMN analytical_stem_view.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5844 | 5614 |
-- |
| 5845 | 5615 |
|
| 5846 | 5616 |
|
| 5847 | 5617 |
|
| 5848 | 5618 |
|
| 5849 | 5619 |
-- |
| 5850 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5620 |
-- Name: COLUMN analytical_stem_view.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5851 | 5621 |
-- |
| 5852 | 5622 |
|
| 5853 | 5623 |
|
| 5854 | 5624 |
|
| 5855 | 5625 |
|
| 5856 | 5626 |
-- |
| 5857 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5627 |
-- Name: COLUMN analytical_stem_view.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5858 | 5628 |
-- |
| 5859 | 5629 |
|
| 5860 | 5630 |
|
| 5861 | 5631 |
|
| 5862 | 5632 |
|
| 5863 | 5633 |
-- |
| 5864 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5634 |
-- Name: COLUMN analytical_stem_view.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5865 | 5635 |
-- |
| 5866 | 5636 |
|
| 5867 | 5637 |
|
| 5868 | 5638 |
|
| 5869 | 5639 |
|
| 5870 | 5640 |
-- |
| 5871 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 5641 |
-- Name: COLUMN analytical_stem_view.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5872 | 5642 |
-- |
| 5873 | 5643 |
|
| 5874 | 5644 |
|
| 5875 | 5645 |
|
| 5876 | 5646 |
|
| 5877 | 5647 |
-- |
| 5878 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5648 |
-- Name: COLUMN analytical_stem_view.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5879 | 5649 |
-- |
| 5880 | 5650 |
|
| 5881 | 5651 |
|
| 5882 | 5652 |
|
| 5883 | 5653 |
|
| 5884 | 5654 |
-- |
| 5885 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5655 |
-- Name: COLUMN analytical_stem_view.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5886 | 5656 |
-- |
| 5887 | 5657 |
|
| 5888 | 5658 |
|
| 5889 | 5659 |
|
| 5890 | 5660 |
|
| 5891 | 5661 |
-- |
| 5892 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5662 |
-- Name: COLUMN analytical_stem_view.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5893 | 5663 |
-- |
| 5894 | 5664 |
|
| 5895 | 5665 |
|
| 5896 | 5666 |
|
| 5897 | 5667 |
|
| 5898 | 5668 |
-- |
| 5899 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5669 |
-- Name: COLUMN analytical_stem_view.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5900 | 5670 |
-- |
| 5901 | 5671 |
|
| 5902 | 5672 |
|
| 5903 | 5673 |
|
| 5904 | 5674 |
|
| 5905 | 5675 |
-- |
| 5906 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5676 |
-- Name: COLUMN analytical_stem_view.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5907 | 5677 |
-- |
| 5908 | 5678 |
|
| 5909 | 5679 |
|
| 5910 | 5680 |
|
| 5911 | 5681 |
|
| 5912 | 5682 |
-- |
| 5913 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5683 |
-- Name: COLUMN analytical_stem_view.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5914 | 5684 |
-- |
| 5915 | 5685 |
|
| 5916 | 5686 |
|
| 5917 | 5687 |
|
| 5918 | 5688 |
|
| 5919 | 5689 |
-- |
| 5920 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5690 |
-- Name: COLUMN analytical_stem_view.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5921 | 5691 |
-- |
| 5922 | 5692 |
|
| 5923 | 5693 |
|
| 5924 | 5694 |
|
| 5925 | 5695 |
|
| 5926 | 5696 |
-- |
| 5927 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5697 |
-- Name: COLUMN analytical_stem_view.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5928 | 5698 |
-- |
| 5929 | 5699 |
|
| 5930 | 5700 |
|
| 5931 | 5701 |
|
| 5932 | 5702 |
|
| 5933 | 5703 |
-- |
| 5934 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5704 |
-- Name: COLUMN analytical_stem_view.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5935 | 5705 |
-- |
| 5936 | 5706 |
|
| 5937 | 5707 |
|
| 5938 | 5708 |
|
| 5939 | 5709 |
|
| 5940 | 5710 |
-- |
| 5941 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5711 |
-- Name: COLUMN analytical_stem_view.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5942 | 5712 |
-- |
| 5943 | 5713 |
|
| 5944 | 5714 |
|
| 5945 | 5715 |
|
| 5946 | 5716 |
|
| 5947 | 5717 |
-- |
| 5948 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5718 |
-- Name: COLUMN analytical_stem_view.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5949 | 5719 |
-- |
| 5950 | 5720 |
|
| 5951 | 5721 |
|
| 5952 | 5722 |
|
| 5953 | 5723 |
|
| 5954 | 5724 |
-- |
| 5955 |
-- Name: COLUMN `viewFullOccurrence_individual_view`.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5725 |
-- Name: COLUMN analytical_stem_view.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 5956 | 5726 |
-- |
| 5957 | 5727 |
|
| 5958 | 5728 |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: use new materialized viewFullOccurrence_individual