Revision 13843
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 3772 | 3772 |
|
| 3773 | 3773 |
|
| 3774 | 3774 |
-- |
| 3775 |
-- Name: COLUMN analytical_stem.`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3776 |
-- |
|
| 3777 |
|
|
| 3778 |
|
|
| 3779 |
|
|
| 3780 |
|
|
| 3781 |
-- |
|
| 3775 | 3782 |
-- Name: 2013-10-18.Brian_Enquist.Canadensys; Type: VIEW; Schema: public; Owner: - |
| 3776 | 3783 |
-- |
| 3777 | 3784 |
|
| ... | ... | |
| 3908 | 3915 |
|
| 3909 | 3916 |
|
| 3910 | 3917 |
-- |
| 3918 |
-- Name: COLUMN analytical_plot.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3919 |
-- |
|
| 3920 |
|
|
| 3921 |
|
|
| 3922 |
|
|
| 3923 |
|
|
| 3924 |
-- |
|
| 3925 |
-- Name: COLUMN analytical_plot.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3926 |
-- |
|
| 3927 |
|
|
| 3928 |
|
|
| 3929 |
|
|
| 3930 |
|
|
| 3931 |
-- |
|
| 3932 |
-- Name: COLUMN analytical_plot.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3933 |
-- |
|
| 3934 |
|
|
| 3935 |
|
|
| 3936 |
|
|
| 3937 |
|
|
| 3938 |
-- |
|
| 3939 |
-- Name: COLUMN analytical_plot.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3940 |
-- |
|
| 3941 |
|
|
| 3942 |
|
|
| 3943 |
|
|
| 3944 |
|
|
| 3945 |
-- |
|
| 3946 |
-- Name: COLUMN analytical_plot.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3947 |
-- |
|
| 3948 |
|
|
| 3949 |
|
|
| 3950 |
|
|
| 3951 |
|
|
| 3952 |
-- |
|
| 3953 |
-- Name: COLUMN analytical_plot.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3954 |
-- |
|
| 3955 |
|
|
| 3956 |
|
|
| 3957 |
|
|
| 3958 |
|
|
| 3959 |
-- |
|
| 3960 |
-- Name: COLUMN analytical_plot.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3961 |
-- |
|
| 3962 |
|
|
| 3963 |
|
|
| 3964 |
|
|
| 3965 |
|
|
| 3966 |
-- |
|
| 3967 |
-- Name: COLUMN analytical_plot.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3968 |
-- |
|
| 3969 |
|
|
| 3970 |
|
|
| 3971 |
|
|
| 3972 |
|
|
| 3973 |
-- |
|
| 3974 |
-- Name: COLUMN analytical_plot.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3975 |
-- |
|
| 3976 |
|
|
| 3977 |
|
|
| 3978 |
|
|
| 3979 |
|
|
| 3980 |
-- |
|
| 3981 |
-- Name: COLUMN analytical_plot.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3982 |
-- |
|
| 3983 |
|
|
| 3984 |
|
|
| 3985 |
|
|
| 3986 |
|
|
| 3987 |
-- |
|
| 3988 |
-- Name: COLUMN analytical_plot.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 3989 |
-- |
|
| 3990 |
|
|
| 3991 |
|
|
| 3992 |
|
|
| 3993 |
|
|
| 3994 |
-- |
|
| 3995 |
-- Name: COLUMN analytical_plot.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 3996 |
-- |
|
| 3997 |
|
|
| 3998 |
|
|
| 3999 |
|
|
| 4000 |
|
|
| 4001 |
-- |
|
| 4002 |
-- Name: COLUMN analytical_plot.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4003 |
-- |
|
| 4004 |
|
|
| 4005 |
|
|
| 4006 |
|
|
| 4007 |
|
|
| 4008 |
-- |
|
| 4009 |
-- Name: COLUMN analytical_plot.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4010 |
-- |
|
| 4011 |
|
|
| 4012 |
|
|
| 4013 |
|
|
| 4014 |
|
|
| 4015 |
-- |
|
| 4016 |
-- Name: COLUMN analytical_plot.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4017 |
-- |
|
| 4018 |
|
|
| 4019 |
|
|
| 4020 |
|
|
| 4021 |
|
|
| 4022 |
-- |
|
| 4023 |
-- Name: COLUMN analytical_plot.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4024 |
-- |
|
| 4025 |
|
|
| 4026 |
|
|
| 4027 |
|
|
| 4028 |
|
|
| 4029 |
-- |
|
| 4030 |
-- Name: COLUMN analytical_plot.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4031 |
-- |
|
| 4032 |
|
|
| 4033 |
|
|
| 4034 |
|
|
| 4035 |
|
|
| 4036 |
-- |
|
| 4037 |
-- Name: COLUMN analytical_plot.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4038 |
-- |
|
| 4039 |
|
|
| 4040 |
|
|
| 4041 |
|
|
| 4042 |
|
|
| 4043 |
-- |
|
| 4044 |
-- Name: COLUMN analytical_plot.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4045 |
-- |
|
| 4046 |
|
|
| 4047 |
|
|
| 4048 |
|
|
| 4049 |
|
|
| 4050 |
-- |
|
| 4051 |
-- Name: COLUMN analytical_plot.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4052 |
-- |
|
| 4053 |
|
|
| 4054 |
|
|
| 4055 |
|
|
| 4056 |
|
|
| 4057 |
-- |
|
| 4058 |
-- Name: COLUMN analytical_plot.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4059 |
-- |
|
| 4060 |
|
|
| 4061 |
|
|
| 4062 |
|
|
| 4063 |
|
|
| 4064 |
-- |
|
| 4065 |
-- Name: COLUMN analytical_plot.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4066 |
-- |
|
| 4067 |
|
|
| 4068 |
|
|
| 4069 |
|
|
| 4070 |
|
|
| 4071 |
-- |
|
| 4072 |
-- Name: COLUMN analytical_plot.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4073 |
-- |
|
| 4074 |
|
|
| 4075 |
|
|
| 4076 |
|
|
| 4077 |
|
|
| 4078 |
-- |
|
| 4079 |
-- Name: COLUMN analytical_plot.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4080 |
-- |
|
| 4081 |
|
|
| 4082 |
|
|
| 4083 |
|
|
| 4084 |
|
|
| 4085 |
-- |
|
| 4086 |
-- Name: COLUMN analytical_plot.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4087 |
-- |
|
| 4088 |
|
|
| 4089 |
|
|
| 4090 |
|
|
| 4091 |
|
|
| 4092 |
-- |
|
| 4093 |
-- Name: COLUMN analytical_plot.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4094 |
-- |
|
| 4095 |
|
|
| 4096 |
|
|
| 4097 |
|
|
| 4098 |
|
|
| 4099 |
-- |
|
| 4100 |
-- Name: COLUMN analytical_plot.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4101 |
-- |
|
| 4102 |
|
|
| 4103 |
|
|
| 4104 |
|
|
| 4105 |
|
|
| 4106 |
-- |
|
| 4107 |
-- Name: COLUMN analytical_plot.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4108 |
-- |
|
| 4109 |
|
|
| 4110 |
|
|
| 4111 |
|
|
| 4112 |
|
|
| 4113 |
-- |
|
| 4114 |
-- Name: COLUMN analytical_plot.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4115 |
-- |
|
| 4116 |
|
|
| 4117 |
|
|
| 4118 |
|
|
| 4119 |
|
|
| 4120 |
-- |
|
| 4121 |
-- Name: COLUMN analytical_plot.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4122 |
-- |
|
| 4123 |
|
|
| 4124 |
|
|
| 4125 |
|
|
| 4126 |
|
|
| 4127 |
-- |
|
| 4128 |
-- Name: COLUMN analytical_plot.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4129 |
-- |
|
| 4130 |
|
|
| 4131 |
|
|
| 4132 |
|
|
| 4133 |
|
|
| 4134 |
-- |
|
| 4135 |
-- Name: COLUMN analytical_plot.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4136 |
-- |
|
| 4137 |
|
|
| 4138 |
|
|
| 4139 |
|
|
| 4140 |
|
|
| 4141 |
-- |
|
| 4142 |
-- Name: COLUMN analytical_plot.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4143 |
-- |
|
| 4144 |
|
|
| 4145 |
|
|
| 4146 |
|
|
| 4147 |
|
|
| 4148 |
-- |
|
| 4149 |
-- Name: COLUMN analytical_plot.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4150 |
-- |
|
| 4151 |
|
|
| 4152 |
|
|
| 4153 |
|
|
| 4154 |
|
|
| 4155 |
-- |
|
| 4156 |
-- Name: COLUMN analytical_plot.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4157 |
-- |
|
| 4158 |
|
|
| 4159 |
|
|
| 4160 |
|
|
| 4161 |
|
|
| 4162 |
-- |
|
| 4163 |
-- Name: COLUMN analytical_plot.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4164 |
-- |
|
| 4165 |
|
|
| 4166 |
|
|
| 4167 |
|
|
| 4168 |
|
|
| 4169 |
-- |
|
| 4170 |
-- Name: COLUMN analytical_plot.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4171 |
-- |
|
| 4172 |
|
|
| 4173 |
|
|
| 4174 |
|
|
| 4175 |
|
|
| 4176 |
-- |
|
| 4177 |
-- Name: COLUMN analytical_plot.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4178 |
-- |
|
| 4179 |
|
|
| 4180 |
|
|
| 4181 |
|
|
| 4182 |
|
|
| 4183 |
-- |
|
| 4184 |
-- Name: COLUMN analytical_plot.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4185 |
-- |
|
| 4186 |
|
|
| 4187 |
|
|
| 4188 |
|
|
| 4189 |
|
|
| 4190 |
-- |
|
| 4191 |
-- Name: COLUMN analytical_plot.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4192 |
-- |
|
| 4193 |
|
|
| 4194 |
|
|
| 4195 |
|
|
| 4196 |
|
|
| 4197 |
-- |
|
| 4198 |
-- Name: COLUMN analytical_plot.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 4199 |
-- |
|
| 4200 |
|
|
| 4201 |
|
|
| 4202 |
|
|
| 4203 |
|
|
| 4204 |
-- |
|
| 4205 |
-- Name: COLUMN analytical_plot.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 4206 |
-- |
|
| 4207 |
|
|
| 4208 |
|
|
| 4209 |
|
|
| 4210 |
|
|
| 4211 |
-- |
|
| 4212 |
-- Name: COLUMN analytical_plot.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4213 |
-- |
|
| 4214 |
|
|
| 4215 |
|
|
| 4216 |
|
|
| 4217 |
|
|
| 4218 |
-- |
|
| 4219 |
-- Name: COLUMN analytical_plot.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4220 |
-- |
|
| 4221 |
|
|
| 4222 |
|
|
| 4223 |
|
|
| 4224 |
|
|
| 4225 |
-- |
|
| 4226 |
-- Name: COLUMN analytical_plot.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4227 |
-- |
|
| 4228 |
|
|
| 4229 |
|
|
| 4230 |
|
|
| 4231 |
|
|
| 4232 |
-- |
|
| 4233 |
-- Name: COLUMN analytical_plot.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4234 |
-- |
|
| 4235 |
|
|
| 4236 |
|
|
| 4237 |
|
|
| 4238 |
|
|
| 4239 |
-- |
|
| 4240 |
-- Name: COLUMN analytical_plot.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4241 |
-- |
|
| 4242 |
|
|
| 4243 |
|
|
| 4244 |
|
|
| 4245 |
|
|
| 4246 |
-- |
|
| 4247 |
-- Name: COLUMN analytical_plot.cultivated_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4248 |
-- |
|
| 4249 |
|
|
| 4250 |
|
|
| 4251 |
|
|
| 4252 |
|
|
| 4253 |
-- |
|
| 4254 |
-- Name: COLUMN analytical_plot.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4255 |
-- |
|
| 4256 |
|
|
| 4257 |
|
|
| 4258 |
|
|
| 4259 |
|
|
| 4260 |
-- |
|
| 4261 |
-- Name: COLUMN analytical_plot.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4262 |
-- |
|
| 4263 |
|
|
| 4264 |
|
|
| 4265 |
|
|
| 4266 |
|
|
| 4267 |
-- |
|
| 4268 |
-- Name: COLUMN analytical_plot.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4269 |
-- |
|
| 4270 |
|
|
| 4271 |
|
|
| 4272 |
|
|
| 4273 |
|
|
| 4274 |
-- |
|
| 4275 |
-- Name: COLUMN analytical_plot.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4276 |
-- |
|
| 4277 |
|
|
| 4278 |
|
|
| 4279 |
|
|
| 4280 |
|
|
| 4281 |
-- |
|
| 4282 |
-- Name: COLUMN analytical_plot.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4283 |
-- |
|
| 4284 |
|
|
| 4285 |
|
|
| 4286 |
|
|
| 4287 |
|
|
| 4288 |
-- |
|
| 4289 |
-- Name: COLUMN analytical_plot.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4290 |
-- |
|
| 4291 |
|
|
| 4292 |
|
|
| 4293 |
|
|
| 4294 |
|
|
| 4295 |
-- |
|
| 4296 |
-- Name: COLUMN analytical_plot.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4297 |
-- |
|
| 4298 |
|
|
| 4299 |
|
|
| 4300 |
|
|
| 4301 |
|
|
| 4302 |
-- |
|
| 4303 |
-- Name: COLUMN analytical_plot.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4304 |
-- |
|
| 4305 |
|
|
| 4306 |
|
|
| 4307 |
|
|
| 4308 |
|
|
| 4309 |
-- |
|
| 4310 |
-- Name: COLUMN analytical_plot.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4311 |
-- |
|
| 4312 |
|
|
| 4313 |
|
|
| 4314 |
|
|
| 4315 |
|
|
| 4316 |
-- |
|
| 4317 |
-- Name: COLUMN analytical_plot.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4318 |
-- |
|
| 4319 |
|
|
| 4320 |
|
|
| 4321 |
|
|
| 4322 |
|
|
| 4323 |
-- |
|
| 4324 |
-- Name: COLUMN analytical_plot.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4325 |
-- |
|
| 4326 |
|
|
| 4327 |
|
|
| 4328 |
|
|
| 4329 |
|
|
| 4330 |
-- |
|
| 4331 |
-- Name: COLUMN analytical_plot.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4332 |
-- |
|
| 4333 |
|
|
| 4334 |
|
|
| 4335 |
|
|
| 4336 |
|
|
| 4337 |
-- |
|
| 4338 |
-- Name: COLUMN analytical_plot.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4339 |
-- |
|
| 4340 |
|
|
| 4341 |
|
|
| 4342 |
|
|
| 4343 |
|
|
| 4344 |
-- |
|
| 4345 |
-- Name: COLUMN analytical_plot.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4346 |
-- |
|
| 4347 |
|
|
| 4348 |
|
|
| 4349 |
|
|
| 4350 |
|
|
| 4351 |
-- |
|
| 4352 |
-- Name: COLUMN analytical_plot.`stemCode__@VegBank__.stemLocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4353 |
-- |
|
| 4354 |
|
|
| 4355 |
|
|
| 4356 |
|
|
| 4357 |
|
|
| 4358 |
-- |
|
| 3911 | 4359 |
-- Name: analytical_specimen; Type: VIEW; Schema: public; Owner: - |
| 3912 | 4360 |
-- |
| 3913 | 4361 |
|
| ... | ... | |
| 3915 | 4363 |
|
| 3916 | 4364 |
|
| 3917 | 4365 |
-- |
| 4366 |
-- Name: COLUMN analytical_specimen.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4367 |
-- |
|
| 4368 |
|
|
| 4369 |
|
|
| 4370 |
|
|
| 4371 |
|
|
| 4372 |
-- |
|
| 4373 |
-- Name: COLUMN analytical_specimen.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4374 |
-- |
|
| 4375 |
|
|
| 4376 |
|
|
| 4377 |
|
|
| 4378 |
|
|
| 4379 |
-- |
|
| 4380 |
-- Name: COLUMN analytical_specimen.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4381 |
-- |
|
| 4382 |
|
|
| 4383 |
|
|
| 4384 |
|
|
| 4385 |
|
|
| 4386 |
-- |
|
| 4387 |
-- Name: COLUMN analytical_specimen.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4388 |
-- |
|
| 4389 |
|
|
| 4390 |
|
|
| 4391 |
|
|
| 4392 |
|
|
| 4393 |
-- |
|
| 4394 |
-- Name: COLUMN analytical_specimen.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4395 |
-- |
|
| 4396 |
|
|
| 4397 |
|
|
| 4398 |
|
|
| 4399 |
|
|
| 4400 |
-- |
|
| 4401 |
-- Name: COLUMN analytical_specimen.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4402 |
-- |
|
| 4403 |
|
|
| 4404 |
|
|
| 4405 |
|
|
| 4406 |
|
|
| 4407 |
-- |
|
| 4408 |
-- Name: COLUMN analytical_specimen.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4409 |
-- |
|
| 4410 |
|
|
| 4411 |
|
|
| 4412 |
|
|
| 4413 |
|
|
| 4414 |
-- |
|
| 4415 |
-- Name: COLUMN analytical_specimen.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4416 |
-- |
|
| 4417 |
|
|
| 4418 |
|
|
| 4419 |
|
|
| 4420 |
|
|
| 4421 |
-- |
|
| 4422 |
-- Name: COLUMN analytical_specimen.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4423 |
-- |
|
| 4424 |
|
|
| 4425 |
|
|
| 4426 |
|
|
| 4427 |
|
|
| 4428 |
-- |
|
| 4429 |
-- Name: COLUMN analytical_specimen.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4430 |
-- |
|
| 4431 |
|
|
| 4432 |
|
|
| 4433 |
|
|
| 4434 |
|
|
| 4435 |
-- |
|
| 4436 |
-- Name: COLUMN analytical_specimen.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4437 |
-- |
|
| 4438 |
|
|
| 4439 |
|
|
| 4440 |
|
|
| 4441 |
|
|
| 4442 |
-- |
|
| 4443 |
-- Name: COLUMN analytical_specimen.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4444 |
-- |
|
| 4445 |
|
|
| 4446 |
|
|
| 4447 |
|
|
| 4448 |
|
|
| 4449 |
-- |
|
| 4450 |
-- Name: COLUMN analytical_specimen.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4451 |
-- |
|
| 4452 |
|
|
| 4453 |
|
|
| 4454 |
|
|
| 4455 |
|
|
| 4456 |
-- |
|
| 4457 |
-- Name: COLUMN analytical_specimen.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4458 |
-- |
|
| 4459 |
|
|
| 4460 |
|
|
| 4461 |
|
|
| 4462 |
|
|
| 4463 |
-- |
|
| 4464 |
-- Name: COLUMN analytical_specimen.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4465 |
-- |
|
| 4466 |
|
|
| 4467 |
|
|
| 4468 |
|
|
| 4469 |
|
|
| 4470 |
-- |
|
| 4471 |
-- Name: COLUMN analytical_specimen.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4472 |
-- |
|
| 4473 |
|
|
| 4474 |
|
|
| 4475 |
|
|
| 4476 |
|
|
| 4477 |
-- |
|
| 4478 |
-- Name: COLUMN analytical_specimen.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4479 |
-- |
|
| 4480 |
|
|
| 4481 |
|
|
| 4482 |
|
|
| 4483 |
|
|
| 4484 |
-- |
|
| 4485 |
-- Name: COLUMN analytical_specimen.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4486 |
-- |
|
| 4487 |
|
|
| 4488 |
|
|
| 4489 |
|
|
| 4490 |
|
|
| 4491 |
-- |
|
| 4492 |
-- Name: COLUMN analytical_specimen.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4493 |
-- |
|
| 4494 |
|
|
| 4495 |
|
|
| 4496 |
|
|
| 4497 |
|
|
| 4498 |
-- |
|
| 4499 |
-- Name: COLUMN analytical_specimen.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4500 |
-- |
|
| 4501 |
|
|
| 4502 |
|
|
| 4503 |
|
|
| 4504 |
|
|
| 4505 |
-- |
|
| 4506 |
-- Name: COLUMN analytical_specimen.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4507 |
-- |
|
| 4508 |
|
|
| 4509 |
|
|
| 4510 |
|
|
| 4511 |
|
|
| 4512 |
-- |
|
| 4513 |
-- Name: COLUMN analytical_specimen.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4514 |
-- |
|
| 4515 |
|
|
| 4516 |
|
|
| 4517 |
|
|
| 4518 |
|
|
| 4519 |
-- |
|
| 4520 |
-- Name: COLUMN analytical_specimen.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4521 |
-- |
|
| 4522 |
|
|
| 4523 |
|
|
| 4524 |
|
|
| 4525 |
|
|
| 4526 |
-- |
|
| 4527 |
-- Name: COLUMN analytical_specimen.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4528 |
-- |
|
| 4529 |
|
|
| 4530 |
|
|
| 4531 |
|
|
| 4532 |
|
|
| 4533 |
-- |
|
| 4534 |
-- Name: COLUMN analytical_specimen.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4535 |
-- |
|
| 4536 |
|
|
| 4537 |
|
|
| 4538 |
|
|
| 4539 |
|
|
| 4540 |
-- |
|
| 4541 |
-- Name: COLUMN analytical_specimen.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4542 |
-- |
|
| 4543 |
|
|
| 4544 |
|
|
| 4545 |
|
|
| 4546 |
|
|
| 4547 |
-- |
|
| 4548 |
-- Name: COLUMN analytical_specimen.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4549 |
-- |
|
| 4550 |
|
|
| 4551 |
|
|
| 4552 |
|
|
| 4553 |
|
|
| 4554 |
-- |
|
| 4555 |
-- Name: COLUMN analytical_specimen.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4556 |
-- |
|
| 4557 |
|
|
| 4558 |
|
|
| 4559 |
|
|
| 4560 |
|
|
| 4561 |
-- |
|
| 4562 |
-- Name: COLUMN analytical_specimen.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4563 |
-- |
|
| 4564 |
|
|
| 4565 |
|
|
| 4566 |
|
|
| 4567 |
|
|
| 4568 |
-- |
|
| 4569 |
-- Name: COLUMN analytical_specimen.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4570 |
-- |
|
| 4571 |
|
|
| 4572 |
|
|
| 4573 |
|
|
| 4574 |
|
|
| 4575 |
-- |
|
| 4576 |
-- Name: COLUMN analytical_specimen.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4577 |
-- |
|
| 4578 |
|
|
| 4579 |
|
|
| 4580 |
|
|
| 4581 |
|
|
| 4582 |
-- |
|
| 4583 |
-- Name: COLUMN analytical_specimen.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4584 |
-- |
|
| 4585 |
|
|
| 4586 |
|
|
| 4587 |
|
|
| 4588 |
|
|
| 4589 |
-- |
|
| 4590 |
-- Name: COLUMN analytical_specimen.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 4591 |
-- |
|
| 4592 |
|
|
| 4593 |
|
|
| 4594 |
|
|
| 4595 |
|
|
| 4596 |
-- |
|
| 4597 |
-- Name: COLUMN analytical_specimen.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 4598 |
-- |
|
| 4599 |
|
|
| 4600 |
|
|
| 4601 |
|
|
| 4602 |
|
|
| 4603 |
-- |
|
| 4604 |
-- Name: COLUMN analytical_specimen.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4605 |
-- |
|
| 4606 |
|
|
| 4607 |
|
|
| 4608 |
|
|
| 4609 |
|
|
| 4610 |
-- |
|
| 4611 |
-- Name: COLUMN analytical_specimen.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 4612 |
-- |
|
| 4613 |
|
|
| 4614 |
|
|
| 4615 |
|
|
| 4616 |
|
|
| 4617 |
-- |
|
| 4618 |
-- Name: COLUMN analytical_specimen.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4619 |
-- |
|
| 4620 |
|
|
| 4621 |
|
|
| 4622 |
|
|
| 4623 |
|
|
| 4624 |
-- |
|
| 4625 |
-- Name: COLUMN analytical_specimen.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4626 |
-- |
|
| 4627 |
|
|
| 4628 |
|
|
| 4629 |
|
|
| 4630 |
|
|
| 4631 |
-- |
|
| 4632 |
-- Name: COLUMN analytical_specimen.cultivated_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 4633 |
-- |
|
| 4634 |
|
|
| 4635 |
|
|
| 4636 |
|
|
| 4637 |
|
|
| 4638 |
-- |
|
| 4639 |
-- Name: COLUMN analytical_specimen.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 4640 |
-- |
|
| 4641 |
|
|
| 4642 |
|
|
| 4643 |
|
|
| 4644 |
|
|
| 4645 |
-- |
|
| 4646 |
-- Name: COLUMN analytical_specimen.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4647 |
-- |
|
| 4648 |
|
|
| 4649 |
|
|
| 4650 |
|
|
| 4651 |
|
|
| 4652 |
-- |
|
| 4653 |
-- Name: COLUMN analytical_specimen.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4654 |
-- |
|
| 4655 |
|
|
| 4656 |
|
|
| 4657 |
|
|
| 4658 |
|
|
| 4659 |
-- |
|
| 4660 |
-- Name: COLUMN analytical_specimen.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4661 |
-- |
|
| 4662 |
|
|
| 4663 |
|
|
| 4664 |
|
|
| 4665 |
|
|
| 4666 |
-- |
|
| 4667 |
-- Name: COLUMN analytical_specimen.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4668 |
-- |
|
| 4669 |
|
|
| 4670 |
|
|
| 4671 |
|
|
| 4672 |
|
|
| 4673 |
-- |
|
| 3918 | 4674 |
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 3919 | 4675 |
-- |
| 3920 | 4676 |
|
| ... | ... | |
| 4464 | 5220 |
|
| 4465 | 5221 |
|
| 4466 | 5222 |
-- |
| 5223 |
-- Name: COLUMN `plot.**`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5224 |
-- |
|
| 5225 |
|
|
| 5226 |
|
|
| 5227 |
|
|
| 5228 |
|
|
| 5229 |
-- |
|
| 5230 |
-- Name: COLUMN `plot.**`.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5231 |
-- |
|
| 5232 |
|
|
| 5233 |
|
|
| 5234 |
|
|
| 5235 |
|
|
| 5236 |
-- |
|
| 5237 |
-- Name: COLUMN `plot.**`.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5238 |
-- |
|
| 5239 |
|
|
| 5240 |
|
|
| 5241 |
|
|
| 5242 |
|
|
| 5243 |
-- |
|
| 5244 |
-- Name: COLUMN `plot.**`.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5245 |
-- |
|
| 5246 |
|
|
| 5247 |
|
|
| 5248 |
|
|
| 5249 |
|
|
| 5250 |
-- |
|
| 5251 |
-- Name: COLUMN `plot.**`.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5252 |
-- |
|
| 5253 |
|
|
| 5254 |
|
|
| 5255 |
|
|
| 5256 |
|
|
| 5257 |
-- |
|
| 5258 |
-- Name: COLUMN `plot.**`.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5259 |
-- |
|
| 5260 |
|
|
| 5261 |
|
|
| 5262 |
|
|
| 5263 |
|
|
| 5264 |
-- |
|
| 5265 |
-- Name: COLUMN `plot.**`.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5266 |
-- |
|
| 5267 |
|
|
| 5268 |
|
|
| 5269 |
|
|
| 5270 |
|
|
| 5271 |
-- |
|
| 5272 |
-- Name: COLUMN `plot.**`.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5273 |
-- |
|
| 5274 |
|
|
| 5275 |
|
|
| 5276 |
|
|
| 5277 |
|
|
| 5278 |
-- |
|
| 5279 |
-- Name: COLUMN `plot.**`.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5280 |
-- |
|
| 5281 |
|
|
| 5282 |
|
|
| 5283 |
|
|
| 5284 |
|
|
| 5285 |
-- |
|
| 5286 |
-- Name: COLUMN `plot.**`.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5287 |
-- |
|
| 5288 |
|
|
| 5289 |
|
|
| 5290 |
|
|
| 5291 |
|
|
| 5292 |
-- |
|
| 5293 |
-- Name: COLUMN `plot.**`.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 5294 |
-- |
|
| 5295 |
|
|
| 5296 |
|
|
| 5297 |
|
|
| 5298 |
|
|
| 5299 |
-- |
|
| 5300 |
-- Name: COLUMN `plot.**`.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 5301 |
-- |
|
| 5302 |
|
|
| 5303 |
|
|
| 5304 |
|
|
| 5305 |
|
|
| 5306 |
-- |
|
| 5307 |
-- Name: COLUMN `plot.**`.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5308 |
-- |
|
| 5309 |
|
|
| 5310 |
|
|
| 5311 |
|
|
| 5312 |
|
|
| 5313 |
-- |
|
| 5314 |
-- Name: COLUMN `plot.**`.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5315 |
-- |
|
| 5316 |
|
|
| 5317 |
|
|
| 5318 |
|
|
| 5319 |
|
|
| 5320 |
-- |
|
| 5321 |
-- Name: COLUMN `plot.**`.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5322 |
-- |
|
| 5323 |
|
|
| 5324 |
|
|
| 5325 |
|
|
| 5326 |
|
|
| 5327 |
-- |
|
| 5328 |
-- Name: COLUMN `plot.**`.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5329 |
-- |
|
| 5330 |
|
|
| 5331 |
|
|
| 5332 |
|
|
| 5333 |
|
|
| 5334 |
-- |
|
| 5335 |
-- Name: COLUMN `plot.**`.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5336 |
-- |
|
| 5337 |
|
|
| 5338 |
|
|
| 5339 |
|
|
| 5340 |
|
|
| 5341 |
-- |
|
| 5342 |
-- Name: COLUMN `plot.**`.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
|
| 5343 |
-- |
|
| 5344 |
|
|
| 5345 |
|
|
| 5346 |
|
|
| 5347 |
|
|
| 5348 |
-- |
|
| 5349 |
-- Name: COLUMN `plot.**`.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5350 |
-- |
|
| 5351 |
|
|
| 5352 |
|
|
| 5353 |
|
|
| 5354 |
|
|
| 5355 |
-- |
|
| 5356 |
-- Name: COLUMN `plot.**`.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5357 |
-- |
|
| 5358 |
|
|
| 5359 |
|
|
| 5360 |
|
|
| 5361 |
|
|
| 5362 |
-- |
|
| 5363 |
-- Name: COLUMN `plot.**`.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5364 |
-- |
|
| 5365 |
|
|
| 5366 |
|
|
| 5367 |
|
|
| 5368 |
|
|
| 5369 |
-- |
|
| 5370 |
-- Name: COLUMN `plot.**`.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5371 |
-- |
|
| 5372 |
|
|
| 5373 |
|
|
| 5374 |
|
|
| 5375 |
|
|
| 5376 |
-- |
|
| 5377 |
-- Name: COLUMN `plot.**`.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5378 |
-- |
|
| 5379 |
|
|
| 5380 |
|
|
| 5381 |
|
|
| 5382 |
|
|
| 5383 |
-- |
|
| 5384 |
-- Name: COLUMN `plot.**`.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5385 |
-- |
|
| 5386 |
|
|
| 5387 |
|
|
| 5388 |
|
|
| 5389 |
|
|
| 5390 |
-- |
|
| 5391 |
-- Name: COLUMN `plot.**`.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5392 |
-- |
|
| 5393 |
|
|
| 5394 |
|
|
| 5395 |
|
|
| 5396 |
|
|
| 5397 |
-- |
|
| 5398 |
-- Name: COLUMN `plot.**`.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5399 |
-- |
|
| 5400 |
|
|
| 5401 |
|
|
| 5402 |
|
|
| 5403 |
|
|
| 5404 |
-- |
|
| 5405 |
-- Name: COLUMN `plot.**`.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5406 |
-- |
|
| 5407 |
|
|
| 5408 |
|
|
| 5409 |
|
|
| 5410 |
|
|
| 5411 |
-- |
|
| 5412 |
-- Name: COLUMN `plot.**`.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5413 |
-- |
|
| 5414 |
|
|
| 5415 |
|
|
| 5416 |
|
|
| 5417 |
|
|
| 5418 |
-- |
|
| 5419 |
-- Name: COLUMN `plot.**`.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5420 |
-- |
|
| 5421 |
|
|
| 5422 |
|
|
| 5423 |
|
|
| 5424 |
|
|
| 5425 |
-- |
|
| 5426 |
-- Name: COLUMN `plot.**`.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 5427 |
-- |
|
| 5428 |
|
|
| 5429 |
|
|
| 5430 |
|
|
| 5431 |
|
|
| 5432 |
-- |
|
| 4467 | 5433 |
-- Name: sourcelist; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 4468 | 5434 |
-- |
| 4469 | 5435 |
|
| ... | ... | |
| 5291 | 6257 |
|
| 5292 | 6258 |
|
| 5293 | 6259 |
-- |
| 6260 |
-- Name: COLUMN collected_dates.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 6261 |
-- |
|
| 6262 |
|
|
| 6263 |
|
|
| 6264 |
|
|
| 6265 |
|
|
| 6266 |
-- |
|
| 5294 | 6267 |
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 5295 | 6268 |
-- |
| 5296 | 6269 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 5457 | 5457 |
-- Name: COLUMN analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5458 | 5458 |
-- |
| 5459 | 5459 |
|
| 5460 |
COMMENT ON COLUMN analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org" IS 'variant of DwC term';
|
|
| 5460 |
COMMENT ON COLUMN analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org" IS '"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';
|
|
| 5461 | 5461 |
|
| 5462 | 5462 |
|
| 5463 | 5463 |
-- |
| 5464 | 5464 |
-- Name: COLUMN analytical_stem."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5465 | 5465 |
-- |
| 5466 | 5466 |
|
| 5467 |
COMMENT ON COLUMN analytical_stem."country__@DwC__@vegpath.org" IS 'geoscrub.geoscrub_output.acceptedCountry@VegBIEN@vegpath.org;
|
|
| 5467 |
COMMENT ON COLUMN analytical_stem."country__@DwC__@vegpath.org" IS 'http://geoscrub.geoscrub_output.acceptedCountry__@VegBIEN__@vegpath.org;
|
|
| 5468 | 5468 |
"The name of the country or major administrative unit in which the Location occurs"'; |
| 5469 | 5469 |
|
| 5470 | 5470 |
|
| ... | ... | |
| 5507 | 5507 |
-- Name: COLUMN analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5508 | 5508 |
-- |
| 5509 | 5509 |
|
| 5510 |
COMMENT ON COLUMN analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS '"The horizontal distance (in meters) from the given decimalLatitude and decimalLongitude describing the smallest circle containing the whole of the Location"';
|
|
| 5510 |
COMMENT ON COLUMN analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS 'for a point observation, this is the fuzziness of the coordinates. for a plot (or other shape), this is the radius of the circle that circumscribes the entire plot, or the fuzziness, whichever is greater. note that the DwC definition is confusingly worded: it uses the ambiguous term Location, which sometimes refers to the asserted named place, but which they intended to refer to the plot or point.';
|
|
| 5511 | 5511 |
|
| 5512 | 5512 |
|
| 5513 | 5513 |
-- |
| 5514 | 5514 |
-- Name: COLUMN analytical_stem."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5515 | 5515 |
-- |
| 5516 | 5516 |
|
| 5517 |
COMMENT ON COLUMN analytical_stem."georeferenceSources__@DwC__@vegpath.org" IS 'derived column';
|
|
| 5517 |
COMMENT ON COLUMN analytical_stem."georeferenceSources__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of maps, gazetteers, or other resources used to georeference the Location, described specifically enough to allow anyone in the future to use the same resources"';
|
|
| 5518 | 5518 |
|
| 5519 | 5519 |
|
| 5520 | 5520 |
-- |
| 5521 | 5521 |
-- Name: COLUMN analytical_stem."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5522 | 5522 |
-- |
| 5523 | 5523 |
|
| 5524 |
COMMENT ON COLUMN analytical_stem."georeferenceProtocol__@DwC__@vegpath.org" IS 'derived column';
|
|
| 5524 |
COMMENT ON COLUMN analytical_stem."georeferenceProtocol__@DwC__@vegpath.org" IS '"A description or reference to the methods used to determine the spatial footprint, coordinates, and uncertainties"';
|
|
| 5525 | 5525 |
|
| 5526 | 5526 |
|
| 5527 | 5527 |
-- |
| 5528 | 5528 |
-- Name: COLUMN analytical_stem.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
| 5529 | 5529 |
-- |
| 5530 | 5530 |
|
| 5531 |
COMMENT ON COLUMN analytical_stem.geovalid_bien IS 'derived column';
|
|
| 5531 |
COMMENT ON COLUMN analytical_stem.geovalid_bien IS 'whether the coordinates are within the boundary of the asserted named places';
|
|
| 5532 | 5532 |
|
| 5533 | 5533 |
|
| 5534 | 5534 |
-- |
| 5535 | 5535 |
-- Name: COLUMN analytical_stem."isNewWorld_bien"; Type: COMMENT; Schema: public; Owner: - |
| 5536 | 5536 |
-- |
| 5537 | 5537 |
|
| 5538 |
COMMENT ON COLUMN analytical_stem."isNewWorld_bien" IS 'derived column';
|
|
| 5538 |
COMMENT ON COLUMN analytical_stem."isNewWorld_bien" IS 'whether the country is in the Americas';
|
|
| 5539 | 5539 |
|
| 5540 | 5540 |
|
| 5541 | 5541 |
-- |
| 5542 | 5542 |
-- Name: COLUMN analytical_stem."projectID__@VegX__.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5543 | 5543 |
-- |
| 5544 | 5544 |
|
| 5545 |
COMMENT ON COLUMN analytical_stem."projectID__@VegX__.plotObservation@vegpath.org" IS 'project.sourceaccessioncode@VegBIEN.public@vegpath.org;
|
|
| 5545 |
COMMENT ON COLUMN analytical_stem."projectID__@VegX__.plotObservation@vegpath.org" IS 'http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;
|
|
| 5546 | 5546 |
"A reference to a specific ''project''"'; |
| 5547 | 5547 |
|
| 5548 | 5548 |
|
| ... | ... | |
| 5550 | 5550 |
-- Name: COLUMN analytical_stem."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5551 | 5551 |
-- |
| 5552 | 5552 |
|
| 5553 |
COMMENT ON COLUMN analytical_stem."projectContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term';
|
|
| 5553 |
COMMENT ON COLUMN analytical_stem."projectContributor[s]__@VegBank__@vegpath.org" IS '"intersection entit[ies] used to ''link'' a party with a specific project wherein vegetation plots are described"';
|
|
| 5554 | 5554 |
|
| 5555 | 5555 |
|
| 5556 | 5556 |
-- |
| ... | ... | |
| 5571 | 5571 |
-- Name: COLUMN analytical_stem."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5572 | 5572 |
-- |
| 5573 | 5573 |
|
| 5574 |
COMMENT ON COLUMN analytical_stem."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org;
|
|
| 5574 |
COMMENT ON COLUMN analytical_stem."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'http://location.authorlocationcode__@VegBIEN__.public@vegpath.org;
|
|
| 5575 | 5575 |
"Code for subplot, line, or any other subsample or subdivision of plot"'; |
| 5576 | 5576 |
|
| 5577 | 5577 |
|
| ... | ... | |
| 5579 | 5579 |
-- Name: COLUMN analytical_stem.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
| 5580 | 5580 |
-- |
| 5581 | 5581 |
|
| 5582 |
COMMENT ON COLUMN analytical_stem.location__cultivated__bien IS 'variant of DwC term';
|
|
| 5582 |
COMMENT ON COLUMN analytical_stem.location__cultivated__bien IS 'whether the occurrence''s *location* was flagged as cultivated. note that this refers just to the cultivated status of the *location*; the occurrence may be cultivated even if the location isn''t.';
|
|
| 5583 | 5583 |
|
| 5584 | 5584 |
|
| 5585 | 5585 |
-- |
| 5586 | 5586 |
-- Name: COLUMN analytical_stem."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5587 | 5587 |
-- |
| 5588 | 5588 |
|
| 5589 |
COMMENT ON COLUMN analytical_stem."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'locationevent.locationevent_id@VegBIEN.public@vegpath.org;
|
|
| 5589 |
COMMENT ON COLUMN analytical_stem."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'http://locationevent.locationevent_id__@VegBIEN__.public@vegpath.org;
|
|
| 5590 | 5590 |
autogenerated ID for locationevent'; |
| 5591 | 5591 |
|
| 5592 | 5592 |
|
| ... | ... | |
| 5601 | 5601 |
-- Name: COLUMN analytical_stem."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5602 | 5602 |
-- |
| 5603 | 5603 |
|
| 5604 |
COMMENT ON COLUMN analytical_stem."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 5604 |
COMMENT ON COLUMN analytical_stem."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'the "elevation (altitude, usually above sea level), in meters"';
|
|
| 5605 | 5605 |
|
| 5606 | 5606 |
|
| 5607 | 5607 |
-- |
| ... | ... | |
| 5622 | 5622 |
-- Name: COLUMN analytical_stem."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5623 | 5623 |
-- |
| 5624 | 5624 |
|
| 5625 |
COMMENT ON COLUMN analytical_stem."plot.area[_ha]__@VegX__@vegpath.org" IS 'variant of VegX term';
|
|
| 5625 |
COMMENT ON COLUMN analytical_stem."plot.area[_ha]__@VegX__@vegpath.org" IS '"Total area of the plot"';
|
|
| 5626 | 5626 |
|
| 5627 | 5627 |
|
| 5628 | 5628 |
-- |
| ... | ... | |
| 5636 | 5636 |
-- Name: COLUMN analytical_stem."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5637 | 5637 |
-- |
| 5638 | 5638 |
|
| 5639 |
COMMENT ON COLUMN analytical_stem."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS 'variant of VegX term';
|
|
| 5639 |
COMMENT ON COLUMN analytical_stem."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS '"Temperature during observation [...] [in] Celsius"';
|
|
| 5640 | 5640 |
|
| 5641 | 5641 |
|
| 5642 | 5642 |
-- |
| 5643 | 5643 |
-- Name: COLUMN analytical_stem."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5644 | 5644 |
-- |
| 5645 | 5645 |
|
| 5646 |
COMMENT ON COLUMN analytical_stem."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS 'variant of VegX term';
|
|
| 5646 |
COMMENT ON COLUMN analytical_stem."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS '"Total annual precipitation, in mm"';
|
|
| 5647 | 5647 |
|
| 5648 | 5648 |
|
| 5649 | 5649 |
-- |
| 5650 | 5650 |
-- Name: COLUMN analytical_stem."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5651 | 5651 |
-- |
| 5652 | 5652 |
|
| 5653 |
COMMENT ON COLUMN analytical_stem."stratumName__@VegX__.stratum@vegpath.org" IS 'from VegX, renamed';
|
|
| 5653 |
COMMENT ON COLUMN analytical_stem."stratumName__@VegX__.stratum@vegpath.org" IS '"Name associated with this stratum"';
|
|
| 5654 | 5654 |
|
| 5655 | 5655 |
|
| 5656 | 5656 |
-- |
| 5657 | 5657 |
-- Name: COLUMN analytical_stem."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5658 | 5658 |
-- |
| 5659 | 5659 |
|
| 5660 |
COMMENT ON COLUMN analytical_stem."communityConcept.name__@VegX__.communityDet@vegpath.org" IS 'variant of VegX term';
|
|
| 5660 |
COMMENT ON COLUMN analytical_stem."communityConcept.name__@VegX__.communityDet@vegpath.org" IS '"A textual label for a community type. A community type is an abstract grouping of organisms that tend to co-occur on the landscape due to shared ecological requirements or preferences."';
|
|
| 5661 | 5661 |
|
| 5662 | 5662 |
|
| 5663 | 5663 |
-- |
| 5664 | 5664 |
-- Name: COLUMN analytical_stem."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5665 | 5665 |
-- |
| 5666 | 5666 |
|
| 5667 |
COMMENT ON COLUMN analytical_stem."observationContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term';
|
|
| 5667 |
COMMENT ON COLUMN analytical_stem."observationContributor[s]__@VegBank__@vegpath.org" IS '"intersection[s] that link[] a party with a specific plot observation event"';
|
|
| 5668 | 5668 |
|
| 5669 | 5669 |
|
| 5670 | 5670 |
-- |
| 5671 | 5671 |
-- Name: COLUMN analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5672 | 5672 |
-- |
| 5673 | 5673 |
|
| 5674 |
COMMENT ON COLUMN analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS 'from DwC, renamed';
|
|
| 5674 |
COMMENT ON COLUMN analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS '"The name[s] (or acronym[s]) in use by the institution[s] having custody of the object(s) or information referred to in the record"';
|
|
| 5675 | 5675 |
|
| 5676 | 5676 |
|
| 5677 | 5677 |
-- |
| 5678 | 5678 |
-- Name: COLUMN analytical_stem."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5679 | 5679 |
-- |
| 5680 | 5680 |
|
| 5681 |
COMMENT ON COLUMN analytical_stem."collectionCode__@DwC__@vegpath.org" IS 'from DwC, renamed';
|
|
| 5681 |
COMMENT ON COLUMN analytical_stem."collectionCode__@DwC__@vegpath.org" IS '"The name, acronym, coden, or initialism identifying the collection or data set from which the record was derived"';
|
|
| 5682 | 5682 |
|
| 5683 | 5683 |
|
| 5684 | 5684 |
-- |
| 5685 | 5685 |
-- Name: COLUMN analytical_stem."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5686 | 5686 |
-- |
| 5687 | 5687 |
|
| 5688 |
COMMENT ON COLUMN analytical_stem."catalogNumber__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 5688 |
COMMENT ON COLUMN analytical_stem."catalogNumber__@DwC__@vegpath.org" IS '"An identifier (preferably unique) for the record within the data set or collection"';
|
|
| 5689 | 5689 |
|
| 5690 | 5690 |
|
| 5691 | 5691 |
-- |
| ... | ... | |
| 5713 | 5713 |
-- Name: COLUMN analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5714 | 5714 |
-- |
| 5715 | 5715 |
|
| 5716 |
COMMENT ON COLUMN analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'variant of DwC term';
|
|
| 5716 |
COMMENT ON COLUMN analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'the "date-time (Common Era calendar) in a date-time period during which an organism or group of organisms was collected or observed"';
|
|
| 5717 | 5717 |
|
| 5718 | 5718 |
|
| 5719 | 5719 |
-- |
| 5720 | 5720 |
-- Name: COLUMN analytical_stem."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5721 | 5721 |
-- |
| 5722 | 5722 |
|
| 5723 |
COMMENT ON COLUMN analytical_stem."[verbatim_]family__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 5723 |
COMMENT ON COLUMN analytical_stem."[verbatim_]family__@DwC__@vegpath.org" IS '"The full scientific name of the family in which the taxon is classified [*before* any TNRS scrubbing]"';
|
|
| 5724 | 5724 |
|
| 5725 | 5725 |
|
| 5726 | 5726 |
-- |
| 5727 | 5727 |
-- Name: COLUMN analytical_stem."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5728 | 5728 |
-- |
| 5729 | 5729 |
|
| 5730 |
COMMENT ON COLUMN analytical_stem."[verbatim_]scientificName__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 5730 |
COMMENT ON COLUMN analytical_stem."[verbatim_]scientificName__@DwC__@vegpath.org" IS '"The full scientific name [*before* any TNRS scrubbing], with authorship and date information if known. When forming part of an Identification, this should be the name in lowest level taxonomic rank that can be determined."';
|
|
| 5731 | 5731 |
|
| 5732 | 5732 |
|
| 5733 | 5733 |
-- |
| ... | ... | |
| 5755 | 5755 |
-- Name: COLUMN analytical_stem."Family_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5756 | 5756 |
-- |
| 5757 | 5757 |
|
| 5758 |
COMMENT ON COLUMN analytical_stem."Family_matched__@TNRS__@vegpath.org" IS 'TNRS.taxon_scrub.matchedFamily@VegBIEN.public@vegpath.org;
|
|
| 5758 |
COMMENT ON COLUMN analytical_stem."Family_matched__@TNRS__@vegpath.org" IS 'http://TNRS.taxon_scrub.matchedFamily__@VegBIEN__.public@vegpath.org;
|
|
| 5759 | 5759 |
"The closest matching family in the TNRS database to the family submitted"'; |
| 5760 | 5760 |
|
| 5761 | 5761 |
|
| ... | ... | |
| 5763 | 5763 |
-- Name: COLUMN analytical_stem."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5764 | 5764 |
-- |
| 5765 | 5765 |
|
| 5766 |
COMMENT ON COLUMN analytical_stem."Name_matched__@TNRS__@vegpath.org" IS 'from TNRS, renamed';
|
|
| 5766 |
COMMENT ON COLUMN analytical_stem."Name_matched__@TNRS__@vegpath.org" IS '"Scientific name with the highest match score. May be an exact match or a fuzzy match."';
|
|
| 5767 | 5767 |
|
| 5768 | 5768 |
|
| 5769 | 5769 |
-- |
| 5770 | 5770 |
-- Name: COLUMN analytical_stem."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5771 | 5771 |
-- |
| 5772 | 5772 |
|
| 5773 |
COMMENT ON COLUMN analytical_stem."Name_matched_author__@TNRS__@vegpath.org" IS 'from TNRS, renamed';
|
|
| 5773 |
COMMENT ON COLUMN analytical_stem."Name_matched_author__@TNRS__@vegpath.org" IS '"Standard authority for the matched name"';
|
|
| 5774 | 5774 |
|
| 5775 | 5775 |
|
| 5776 | 5776 |
-- |
| 5777 | 5777 |
-- Name: COLUMN analytical_stem."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5778 | 5778 |
-- |
| 5779 | 5779 |
|
| 5780 |
COMMENT ON COLUMN analytical_stem."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'derived column';
|
|
| 5780 |
COMMENT ON COLUMN analytical_stem."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'closed list derived from higher taxa';
|
|
| 5781 | 5781 |
|
| 5782 | 5782 |
|
| 5783 | 5783 |
-- |
| 5784 | 5784 |
-- Name: COLUMN analytical_stem."taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5785 | 5785 |
-- |
| 5786 | 5786 |
|
| 5787 |
COMMENT ON COLUMN analytical_stem."taxonomicStatus__@DwC__@vegpath.org" IS 'from DwC, renamed';
|
|
| 5787 |
COMMENT ON COLUMN analytical_stem."taxonomicStatus__@DwC__@vegpath.org" IS '"The status of the use of the scientificName as a label for a taxon. Requires taxonomic opinion to define the scope of a taxon. [...] Examples: "invalid", "misapplied", "homotypic synonym", "accepted"."';
|
|
| 5788 | 5788 |
|
| 5789 | 5789 |
|
| 5790 | 5790 |
-- |
| 5791 | 5791 |
-- Name: COLUMN analytical_stem.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
| 5792 | 5792 |
-- |
| 5793 | 5793 |
|
| 5794 |
COMMENT ON COLUMN analytical_stem.scrubbed_family IS 'variant of TNRS term';
|
|
| 5794 |
COMMENT ON COLUMN analytical_stem.scrubbed_family IS 'the family of the TNRS accepted or matched name';
|
|
| 5795 | 5795 |
|
| 5796 | 5796 |
|
| 5797 | 5797 |
-- |
| 5798 | 5798 |
-- Name: COLUMN analytical_stem.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
| 5799 | 5799 |
-- |
| 5800 | 5800 |
|
| 5801 |
COMMENT ON COLUMN analytical_stem.scrubbed_genus IS 'variant of TNRS term';
|
|
| 5801 |
COMMENT ON COLUMN analytical_stem.scrubbed_genus IS 'the genus of the TNRS accepted or matched name';
|
|
| 5802 | 5802 |
|
| 5803 | 5803 |
|
| 5804 | 5804 |
-- |
| 5805 | 5805 |
-- Name: COLUMN analytical_stem.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: - |
| 5806 | 5806 |
-- |
| 5807 | 5807 |
|
| 5808 |
COMMENT ON COLUMN analytical_stem.scrubbed_specific_epithet IS 'variant of TNRS term';
|
|
| 5808 |
COMMENT ON COLUMN analytical_stem.scrubbed_specific_epithet IS 'the specific epithet of the TNRS accepted or matched name';
|
|
| 5809 | 5809 |
|
| 5810 | 5810 |
|
| 5811 | 5811 |
-- |
| 5812 | 5812 |
-- Name: COLUMN analytical_stem.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: - |
| 5813 | 5813 |
-- |
| 5814 | 5814 |
|
| 5815 |
COMMENT ON COLUMN analytical_stem.scrubbed_species_binomial IS 'variant of TNRS term';
|
|
| 5815 |
COMMENT ON COLUMN analytical_stem.scrubbed_species_binomial IS 'the species binomial of the TNRS accepted or matched name';
|
|
| 5816 | 5816 |
|
| 5817 | 5817 |
|
| 5818 | 5818 |
-- |
| 5819 | 5819 |
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
| 5820 | 5820 |
-- |
| 5821 | 5821 |
|
| 5822 |
COMMENT ON COLUMN analytical_stem.scrubbed_taxon_name_no_author IS 'variant of TNRS term';
|
|
| 5822 |
COMMENT ON COLUMN analytical_stem.scrubbed_taxon_name_no_author IS 'the taxon name without author of the TNRS accepted or matched name';
|
|
| 5823 | 5823 |
|
| 5824 | 5824 |
|
| 5825 | 5825 |
-- |
| 5826 | 5826 |
-- Name: COLUMN analytical_stem.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
| 5827 | 5827 |
-- |
| 5828 | 5828 |
|
| 5829 |
COMMENT ON COLUMN analytical_stem.scrubbed_author IS 'variant of TNRS term';
|
|
| 5829 |
COMMENT ON COLUMN analytical_stem.scrubbed_author IS 'the author of the TNRS accepted or matched name';
|
|
| 5830 | 5830 |
|
| 5831 | 5831 |
|
| 5832 | 5832 |
-- |
| 5833 | 5833 |
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: - |
| 5834 | 5834 |
-- |
| 5835 | 5835 |
|
| 5836 |
COMMENT ON COLUMN analytical_stem.scrubbed_taxon_name_with_author IS 'variant of TNRS term';
|
|
| 5836 |
COMMENT ON COLUMN analytical_stem.scrubbed_taxon_name_with_author IS 'the taxon name with author of the TNRS accepted or matched name';
|
|
| 5837 | 5837 |
|
| 5838 | 5838 |
|
| 5839 | 5839 |
-- |
| 5840 | 5840 |
-- Name: COLUMN analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5841 | 5841 |
-- |
| 5842 | 5842 |
|
| 5843 |
COMMENT ON COLUMN analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS 'TNRS.taxon_scrub.scrubbed_morphospecies_binomial@VegBIEN.public@vegpath.org; |
|
| 5844 |
"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`"'; |
|
| 5843 |
COMMENT ON COLUMN analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS 'http://TNRS.taxon_scrub.scrubbed_morphospecies_binomial__@VegBIEN__.public@vegpath.org; |
|
| 5844 |
"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`"; |
|
| 5845 |
a morphospecies is a custom species name assigned in the field by the collector (which does not validate to anything in TNRS)'; |
|
| 5845 | 5846 |
|
| 5846 | 5847 |
|
| 5847 | 5848 |
-- |
| 5848 | 5849 |
-- Name: COLUMN analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5849 | 5850 |
-- |
| 5850 | 5851 |
|
| 5851 |
COMMENT ON COLUMN analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS 'from SALVIAS, renamed';
|
|
| 5852 |
COMMENT ON COLUMN analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS '"Growth form"; "Closed pick list"';
|
|
| 5852 | 5853 |
|
| 5853 | 5854 |
|
| 5854 | 5855 |
-- |
| ... | ... | |
| 5862 | 5863 |
-- Name: COLUMN analytical_stem.threatened_bien; Type: COMMENT; Schema: public; Owner: - |
| 5863 | 5864 |
-- |
| 5864 | 5865 |
|
| 5865 |
COMMENT ON COLUMN analytical_stem.threatened_bien IS 'derived column';
|
|
| 5866 |
COMMENT ON COLUMN analytical_stem.threatened_bien IS 'whether the taxon is on the IUCN Red List of Threatened Species';
|
|
| 5866 | 5867 |
|
| 5867 | 5868 |
|
| 5868 | 5869 |
-- |
| 5869 | 5870 |
-- Name: COLUMN analytical_stem.cultivated_bien; Type: COMMENT; Schema: public; Owner: - |
| 5870 | 5871 |
-- |
| 5871 | 5872 |
|
| 5872 |
COMMENT ON COLUMN analytical_stem.cultivated_bien IS 'variant of DwC term';
|
|
| 5873 |
COMMENT ON COLUMN analytical_stem.cultivated_bien IS 'whether the occurrence was flagged as cultivated';
|
|
| 5873 | 5874 |
|
| 5874 | 5875 |
|
| 5875 | 5876 |
-- |
| 5876 | 5877 |
-- Name: COLUMN analytical_stem."cultivatedBasis_bien"; Type: COMMENT; Schema: public; Owner: - |
| 5877 | 5878 |
-- |
| 5878 | 5879 |
|
| 5879 |
COMMENT ON COLUMN analytical_stem."cultivatedBasis_bien" IS 'derived column';
|
|
| 5880 |
COMMENT ON COLUMN analytical_stem."cultivatedBasis_bien" IS 'why the occurrence was flagged as cultivated';
|
|
| 5880 | 5881 |
|
| 5881 | 5882 |
|
| 5882 | 5883 |
-- |
| ... | ... | |
| 5897 | 5898 |
-- Name: COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5898 | 5899 |
-- |
| 5899 | 5900 |
|
| 5900 |
COMMENT ON COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS 'from SALVIAS, renamed';
|
|
| 5901 |
COMMENT ON COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS '"Diameter at breast height of this stem (usually taken at 1.3 meters, but may vary)"';
|
|
| 5901 | 5902 |
|
| 5902 | 5903 |
|
| 5903 | 5904 |
-- |
| 5904 | 5905 |
-- Name: COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5905 | 5906 |
-- |
| 5906 | 5907 |
|
| 5907 |
COMMENT ON COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS 'variant of VegX term';
|
|
| 5908 |
COMMENT ON COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS '"The measured height of the stem in meters"';
|
|
| 5908 | 5909 |
|
| 5909 | 5910 |
|
| 5910 | 5911 |
-- |
| 5911 | 5912 |
-- Name: COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5912 | 5913 |
-- |
| 5913 | 5914 |
|
| 5914 |
COMMENT ON COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS 'from VegX, renamed';
|
|
| 5915 |
COMMENT ON COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS '"A label that is associated with an individual (e.g. a numerical tree tag)"';
|
|
| 5915 | 5916 |
|
| 5916 | 5917 |
|
| 5917 | 5918 |
-- |
| 5918 | 5919 |
-- Name: COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5919 | 5920 |
-- |
| 5920 | 5921 |
|
| 5921 |
COMMENT ON COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS 'variant of VegX term';
|
|
| 5922 |
COMMENT ON COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The X-coordinate of the related item position in m. The user will enter the relative position of related item with respect to the plot origin (in meters) with the x-axis defined by the plot azimuth."';
|
|
| 5922 | 5923 |
|
| 5923 | 5924 |
|
| 5924 | 5925 |
-- |
| 5925 | 5926 |
-- Name: COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5926 | 5927 |
-- |
| 5927 | 5928 |
|
| 5928 |
COMMENT ON COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS 'variant of VegX term';
|
|
| 5929 |
COMMENT ON COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The Y-coordinate of the relatedSpatialItem position in m. The user will enter the relative position of relatedSpatialItems with respect to the plot origin (in meters) with the y-axis defined by the plot azimuth."';
|
|
| 5929 | 5930 |
|
| 5930 | 5931 |
|
| 5931 | 5932 |
-- |
| 5932 | 5933 |
-- Name: COLUMN analytical_stem."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5933 | 5934 |
-- |
| 5934 | 5935 |
|
| 5935 |
COMMENT ON COLUMN analytical_stem."taxonObservation[.id]__@VegBank__@vegpath.org" IS 'from VegX, renamed';
|
|
| 5936 |
COMMENT ON COLUMN analytical_stem."taxonObservation[.id]__@VegBank__@vegpath.org" IS '"identifier assigned [by the datasource] to each unique observation of a taxon in a plot"';
|
|
| 5936 | 5937 |
|
| 5937 | 5938 |
|
| 5938 | 5939 |
-- |
| 5939 | 5940 |
-- Name: COLUMN analytical_stem."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5940 | 5941 |
-- |
| 5941 | 5942 |
|
| 5942 |
COMMENT ON COLUMN analytical_stem."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS 'variant of VegBank term';
|
|
| 5943 |
COMMENT ON COLUMN analytical_stem."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS '"Verbatum short code used by the author to signify the species at time of observation"';
|
|
| 5943 | 5944 |
|
| 5944 | 5945 |
|
| 5945 | 5946 |
-- |
| 5946 | 5947 |
-- Name: COLUMN analytical_stem."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5947 | 5948 |
-- |
| 5948 | 5949 |
|
| 5949 |
COMMENT ON COLUMN analytical_stem."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'from VegX, renamed';
|
|
| 5950 |
COMMENT ON COLUMN analytical_stem."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to all occurrences of an organism based on an aggregation factor. It contains an AggregateValue, which is an assessment of the overall occurrence of an organism in a Plot (e.g. number of stems, percentage cover, total biomass, basal area)."';
|
|
| 5950 | 5951 |
|
| 5951 | 5952 |
|
| 5952 | 5953 |
-- |
| 5953 | 5954 |
-- Name: COLUMN analytical_stem."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5954 | 5955 |
-- |
| 5955 | 5956 |
|
| 5956 |
COMMENT ON COLUMN analytical_stem."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'from VegX, renamed';
|
|
| 5957 |
COMMENT ON COLUMN analytical_stem."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to one occurrence of an organism (or part of an organism). It is a container for measurements made on the organism (e.g. diameter, height, crown dimensions, biomass, growth form, number of stems)."';
|
|
| 5957 | 5958 |
|
| 5958 | 5959 |
|
| 5959 | 5960 |
-- |
| 5960 | 5961 |
-- Name: COLUMN analytical_stem."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5961 | 5962 |
-- |
| 5962 | 5963 |
|
| 5963 |
COMMENT ON COLUMN analytical_stem."individualID__@DwC__@vegpath.org" IS 'from SALVIAS, renamed';
|
|
| 5964 |
COMMENT ON COLUMN analytical_stem."individualID__@DwC__@vegpath.org" IS '"An identifier for an individual or named group of individual organisms represented in the Occurrence"';
|
|
| 5964 | 5965 |
|
| 5965 | 5966 |
|
| 5966 | 5967 |
-- |
| ... | ... | |
| 5974 | 5975 |
-- Name: COLUMN analytical_stem."stemCode__@VegBank__.stemLocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
| 5975 | 5976 |
-- |
| 5976 | 5977 |
|
| 5977 |
COMMENT ON COLUMN analytical_stem."stemCode__@VegBank__.stemLocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
|
|
| 5978 |
COMMENT ON COLUMN analytical_stem."stemCode__@VegBank__.stemLocation@vegpath.org" IS 'http://stemobservation.authorstemcode__@VegBIEN__.public@vegpath.org;
|
|
| 5978 | 5979 |
"Name or code applied to a specific stem in the plot. This is generally a numeric label to associate a field data entry with a stem in the database."'; |
| 5979 | 5980 |
|
| 5980 | 5981 |
|
| 5981 | 5982 |
-- |
| 5983 |
-- Name: COLUMN analytical_stem."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5984 |
-- |
|
| 5985 |
|
|
| 5986 |
COMMENT ON COLUMN analytical_stem."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" IS 'VegBIEN-autogenerated "identifier assigned to each unique observation of a taxon in a plot"'; |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view and related views: updated COMMENTs from data dictionary spreadsheet, using the steps at wiki.vegpath.org/VegBIEN_schema_refactoring#copy-data-dictionary-definitions-to-database