Revision 13843
Added by Aaron Marcuse-Kubitza over 10 years ago
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 |
|
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