Revision 13688
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 4208 | 4208 |
|
| 4209 | 4209 |
|
| 4210 | 4210 |
-- |
| 4211 |
-- Name: COLUMN analytical_stem_view.`stateProvince@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4212 |
-- |
|
| 4213 |
|
|
| 4214 |
|
|
| 4215 |
|
|
| 4216 |
|
|
| 4217 |
-- |
|
| 4218 |
-- Name: COLUMN analytical_stem_view.`county@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4219 |
-- |
|
| 4220 |
|
|
| 4221 |
|
|
| 4222 |
|
|
| 4223 |
|
|
| 4224 |
-- |
|
| 4225 |
-- Name: COLUMN analytical_stem_view.`locality@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4226 |
-- |
|
| 4227 |
|
|
| 4228 |
|
|
| 4229 |
|
|
| 4230 |
|
|
| 4231 |
-- |
|
| 4232 |
-- Name: COLUMN analytical_stem_view.`decimalLatitude@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4233 |
-- |
|
| 4234 |
|
|
| 4235 |
|
|
| 4236 |
|
|
| 4237 |
|
|
| 4238 |
-- |
|
| 4239 |
-- Name: COLUMN analytical_stem_view.`decimalLongitude@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4240 |
-- |
|
| 4241 |
|
|
| 4242 |
|
|
| 4243 |
|
|
| 4244 |
|
|
| 4245 |
-- |
|
| 4246 |
-- Name: COLUMN analytical_stem_view.`coordinateUncertaintyInMeters@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4247 |
-- |
|
| 4248 |
|
|
| 4249 |
|
|
| 4250 |
|
|
| 4251 |
|
|
| 4252 |
-- |
|
| 4211 | 4253 |
-- Name: COLUMN analytical_stem_view.`coordinateSource_bien`; Type: COMMENT; Schema: public; Owner: - |
| 4212 | 4254 |
-- |
| 4213 | 4255 |
|
| ... | ... | |
| 4250 | 4292 |
|
| 4251 | 4293 |
|
| 4252 | 4294 |
-- |
| 4295 |
-- Name: COLUMN analytical_stem_view.`locationID@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4296 |
-- |
|
| 4297 |
|
|
| 4298 |
|
|
| 4299 |
|
|
| 4300 |
|
|
| 4301 |
-- |
|
| 4253 | 4302 |
-- Name: COLUMN analytical_stem_view.`subplot@SALVIAS@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
| 4254 | 4303 |
-- |
| 4255 | 4304 |
|
| ... | ... | |
| 4271 | 4320 |
|
| 4272 | 4321 |
|
| 4273 | 4322 |
-- |
| 4323 |
-- Name: COLUMN analytical_stem_view.`eventDate@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4324 |
-- |
|
| 4325 |
|
|
| 4326 |
|
|
| 4327 |
|
|
| 4328 |
|
|
| 4329 |
-- |
|
| 4274 | 4330 |
-- Name: COLUMN analytical_stem_view.`elevationInMeters`; Type: COMMENT; Schema: public; Owner: - |
| 4275 | 4331 |
-- |
| 4276 | 4332 |
|
| ... | ... | |
| 4285 | 4341 |
|
| 4286 | 4342 |
|
| 4287 | 4343 |
-- |
| 4344 |
-- Name: COLUMN analytical_stem_view.`samplingProtocol@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4345 |
-- |
|
| 4346 |
|
|
| 4347 |
|
|
| 4348 |
|
|
| 4349 |
|
|
| 4350 |
-- |
|
| 4288 | 4351 |
-- Name: COLUMN analytical_stem_view.`temperature_C`; Type: COMMENT; Schema: public; Owner: - |
| 4289 | 4352 |
-- |
| 4290 | 4353 |
|
| ... | ... | |
| 4341 | 4404 |
|
| 4342 | 4405 |
|
| 4343 | 4406 |
-- |
| 4407 |
-- Name: COLUMN analytical_stem_view.`occurrenceID@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4408 |
-- |
|
| 4409 |
|
|
| 4410 |
|
|
| 4411 |
|
|
| 4412 |
|
|
| 4413 |
-- |
|
| 4414 |
-- Name: COLUMN analytical_stem_view.`recordedBy@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4415 |
-- |
|
| 4416 |
|
|
| 4417 |
|
|
| 4418 |
|
|
| 4419 |
|
|
| 4420 |
-- |
|
| 4421 |
-- Name: COLUMN analytical_stem_view.`recordNumber@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4422 |
-- |
|
| 4423 |
|
|
| 4424 |
|
|
| 4425 |
|
|
| 4426 |
|
|
| 4427 |
-- |
|
| 4344 | 4428 |
-- Name: COLUMN analytical_stem_view.`dateCollected`; Type: COMMENT; Schema: public; Owner: - |
| 4345 | 4429 |
-- |
| 4346 | 4430 |
|
| ... | ... | |
| 4362 | 4446 |
|
| 4363 | 4447 |
|
| 4364 | 4448 |
-- |
| 4449 |
-- Name: COLUMN analytical_stem_view.`identifiedBy@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4450 |
-- |
|
| 4451 |
|
|
| 4452 |
|
|
| 4453 |
|
|
| 4454 |
|
|
| 4455 |
-- |
|
| 4456 |
-- Name: COLUMN analytical_stem_view.`dateIdentified@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4457 |
-- |
|
| 4458 |
|
|
| 4459 |
|
|
| 4460 |
|
|
| 4461 |
|
|
| 4462 |
-- |
|
| 4463 |
-- Name: COLUMN analytical_stem_view.`identificationRemarks@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4464 |
-- |
|
| 4465 |
|
|
| 4466 |
|
|
| 4467 |
|
|
| 4468 |
|
|
| 4469 |
-- |
|
| 4365 | 4470 |
-- Name: COLUMN analytical_stem_view.`Family_matched@TNRS@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
| 4366 | 4471 |
-- |
| 4367 | 4472 |
|
| ... | ... | |
| 4460 | 4565 |
|
| 4461 | 4566 |
|
| 4462 | 4567 |
-- |
| 4568 |
-- Name: COLUMN analytical_stem_view.`reproductiveCondition@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4569 |
-- |
|
| 4570 |
|
|
| 4571 |
|
|
| 4572 |
|
|
| 4573 |
|
|
| 4574 |
-- |
|
| 4463 | 4575 |
-- Name: COLUMN analytical_stem_view.threatened_bien; Type: COMMENT; Schema: public; Owner: - |
| 4464 | 4576 |
-- |
| 4465 | 4577 |
|
| ... | ... | |
| 4481 | 4593 |
|
| 4482 | 4594 |
|
| 4483 | 4595 |
-- |
| 4596 |
-- Name: COLUMN analytical_stem_view.`occurrenceRemarks@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4597 |
-- |
|
| 4598 |
|
|
| 4599 |
|
|
| 4600 |
|
|
| 4601 |
|
|
| 4602 |
-- |
|
| 4484 | 4603 |
-- Name: COLUMN analytical_stem_view.`diameterBreastHeight_cm`; Type: COMMENT; Schema: public; Owner: - |
| 4485 | 4604 |
-- |
| 4486 | 4605 |
|
| ... | ... | |
| 4551 | 4670 |
|
| 4552 | 4671 |
|
| 4553 | 4672 |
-- |
| 4673 |
-- Name: COLUMN analytical_stem_view.`individualCount@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4674 |
-- |
|
| 4675 |
|
|
| 4676 |
|
|
| 4677 |
|
|
| 4678 |
|
|
| 4679 |
-- |
|
| 4554 | 4680 |
-- Name: COLUMN analytical_stem_view.`stemCode@stemlocation@VegBank@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
| 4555 | 4681 |
-- |
| 4556 | 4682 |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: populated definitions of linked DwC terms from DwC data dictionary