Revision 13728
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 4250 | 4250 |
|
| 4251 | 4251 |
|
| 4252 | 4252 |
-- |
| 4253 |
-- Name: COLUMN analytical_stem_view.`coordinateSource_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4253 |
-- Name: COLUMN analytical_stem_view.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4254 | 4254 |
-- |
| 4255 | 4255 |
|
| 4256 | 4256 |
|
| 4257 | 4257 |
|
| 4258 | 4258 |
|
| 4259 | 4259 |
-- |
| 4260 |
-- Name: COLUMN analytical_stem_view.`georeferenceProtocol_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4260 |
-- Name: COLUMN analytical_stem_view.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4261 | 4261 |
-- |
| 4262 | 4262 |
|
| 4263 | 4263 |
|
| ... | ... | |
| 4285 | 4285 |
|
| 4286 | 4286 |
|
| 4287 | 4287 |
-- |
| 4288 |
-- Name: COLUMN analytical_stem_view.project_contributors; Type: COMMENT; Schema: public; Owner: -
|
|
| 4288 |
-- Name: COLUMN analytical_stem_view.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4289 | 4289 |
-- |
| 4290 | 4290 |
|
| 4291 | 4291 |
|
| ... | ... | |
| 4306 | 4306 |
|
| 4307 | 4307 |
|
| 4308 | 4308 |
-- |
| 4309 |
-- Name: COLUMN analytical_stem_view.`subplot__@SALVIAS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4309 |
-- Name: COLUMN analytical_stem_view.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4310 | 4310 |
-- |
| 4311 | 4311 |
|
| 4312 | 4312 |
|
| ... | ... | |
| 4334 | 4334 |
|
| 4335 | 4335 |
|
| 4336 | 4336 |
-- |
| 4337 |
-- Name: COLUMN analytical_stem_view.`elevationInMeters`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4337 |
-- Name: COLUMN analytical_stem_view.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4338 | 4338 |
-- |
| 4339 | 4339 |
|
| 4340 | 4340 |
|
| 4341 | 4341 |
|
| 4342 | 4342 |
|
| 4343 | 4343 |
-- |
| 4344 |
-- Name: COLUMN analytical_stem_view.`slopeAspect__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4344 |
-- Name: COLUMN analytical_stem_view.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4345 | 4345 |
-- |
| 4346 | 4346 |
|
| 4347 | 4347 |
|
| 4348 | 4348 |
|
| 4349 | 4349 |
|
| 4350 | 4350 |
-- |
| 4351 |
-- Name: COLUMN analytical_stem_view.`slopeGradient__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4351 |
-- Name: COLUMN analytical_stem_view.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4352 | 4352 |
-- |
| 4353 | 4353 |
|
| 4354 | 4354 |
|
| 4355 | 4355 |
|
| 4356 | 4356 |
|
| 4357 | 4357 |
-- |
| 4358 |
-- Name: COLUMN analytical_stem_view.`plotArea_ha`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4358 |
-- Name: COLUMN analytical_stem_view.`area[_ha]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4359 | 4359 |
-- |
| 4360 | 4360 |
|
| 4361 | 4361 |
|
| ... | ... | |
| 4369 | 4369 |
|
| 4370 | 4370 |
|
| 4371 | 4371 |
-- |
| 4372 |
-- Name: COLUMN analytical_stem_view.`temperature_C`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4372 |
-- Name: COLUMN analytical_stem_view.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4373 | 4373 |
-- |
| 4374 | 4374 |
|
| 4375 | 4375 |
|
| 4376 | 4376 |
|
| 4377 | 4377 |
|
| 4378 | 4378 |
-- |
| 4379 |
-- Name: COLUMN analytical_stem_view.precipitation_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 4379 |
-- Name: COLUMN analytical_stem_view.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4380 | 4380 |
-- |
| 4381 | 4381 |
|
| 4382 | 4382 |
|
| 4383 | 4383 |
|
| 4384 | 4384 |
|
| 4385 | 4385 |
-- |
| 4386 |
-- Name: COLUMN analytical_stem_view.stratum__name; Type: COMMENT; Schema: public; Owner: -
|
|
| 4386 |
-- Name: COLUMN analytical_stem_view.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4387 | 4387 |
-- |
| 4388 | 4388 |
|
| 4389 | 4389 |
|
| 4390 | 4390 |
|
| 4391 | 4391 |
|
| 4392 | 4392 |
-- |
| 4393 |
-- Name: COLUMN analytical_stem_view.communities; Type: COMMENT; Schema: public; Owner: -
|
|
| 4393 |
-- Name: COLUMN analytical_stem_view.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4394 | 4394 |
-- |
| 4395 | 4395 |
|
| 4396 | 4396 |
|
| 4397 | 4397 |
|
| 4398 | 4398 |
|
| 4399 | 4399 |
-- |
| 4400 |
-- Name: COLUMN analytical_stem_view.plot__collectors; Type: COMMENT; Schema: public; Owner: -
|
|
| 4400 |
-- Name: COLUMN analytical_stem_view.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4401 | 4401 |
-- |
| 4402 | 4402 |
|
| 4403 | 4403 |
|
| 4404 | 4404 |
|
| 4405 | 4405 |
|
| 4406 | 4406 |
-- |
| 4407 |
-- Name: COLUMN analytical_stem_view.`specimenHolderInstitutions`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4407 |
-- Name: COLUMN analytical_stem_view.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4408 | 4408 |
-- |
| 4409 | 4409 |
|
| 4410 | 4410 |
|
| 4411 | 4411 |
|
| 4412 | 4412 |
|
| 4413 | 4413 |
-- |
| 4414 |
-- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: -
|
|
| 4414 |
-- Name: COLUMN analytical_stem_view.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4415 | 4415 |
-- |
| 4416 | 4416 |
|
| 4417 | 4417 |
|
| 4418 | 4418 |
|
| 4419 | 4419 |
|
| 4420 | 4420 |
-- |
| 4421 |
-- Name: COLUMN analytical_stem_view.`accessionNumber`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4421 |
-- Name: COLUMN analytical_stem_view.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4422 | 4422 |
-- |
| 4423 | 4423 |
|
| 4424 | 4424 |
|
| ... | ... | |
| 4446 | 4446 |
|
| 4447 | 4447 |
|
| 4448 | 4448 |
-- |
| 4449 |
-- Name: COLUMN analytical_stem_view.`dateCollected`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4449 |
-- Name: COLUMN analytical_stem_view.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4450 | 4450 |
-- |
| 4451 | 4451 |
|
| 4452 | 4452 |
|
| 4453 | 4453 |
|
| 4454 | 4454 |
|
| 4455 | 4455 |
-- |
| 4456 |
-- Name: COLUMN analytical_stem_view.family_verbatim; Type: COMMENT; Schema: public; Owner: -
|
|
| 4456 |
-- Name: COLUMN analytical_stem_view.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4457 | 4457 |
-- |
| 4458 | 4458 |
|
| 4459 | 4459 |
|
| 4460 | 4460 |
|
| 4461 | 4461 |
|
| 4462 | 4462 |
-- |
| 4463 |
-- Name: COLUMN analytical_stem_view.`scientificName_verbatim`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4463 |
-- Name: COLUMN analytical_stem_view.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4464 | 4464 |
-- |
| 4465 | 4465 |
|
| 4466 | 4466 |
|
| ... | ... | |
| 4495 | 4495 |
|
| 4496 | 4496 |
|
| 4497 | 4497 |
-- |
| 4498 |
-- Name: COLUMN analytical_stem_view.`taxonName_matched`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4498 |
-- Name: COLUMN analytical_stem_view.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4499 | 4499 |
-- |
| 4500 | 4500 |
|
| 4501 | 4501 |
|
| 4502 | 4502 |
|
| 4503 | 4503 |
|
| 4504 | 4504 |
-- |
| 4505 |
-- Name: COLUMN analytical_stem_view.`scientificNameAuthorship_matched`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4505 |
-- Name: COLUMN analytical_stem_view.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4506 | 4506 |
-- |
| 4507 | 4507 |
|
| 4508 | 4508 |
|
| 4509 | 4509 |
|
| 4510 | 4510 |
|
| 4511 | 4511 |
-- |
| 4512 |
-- Name: COLUMN analytical_stem_view.`higherPlantGroup_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4512 |
-- Name: COLUMN analytical_stem_view.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4513 | 4513 |
-- |
| 4514 | 4514 |
|
| 4515 | 4515 |
|
| 4516 | 4516 |
|
| 4517 | 4517 |
|
| 4518 | 4518 |
-- |
| 4519 |
-- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: -
|
|
| 4519 |
-- Name: COLUMN analytical_stem_view.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4520 | 4520 |
-- |
| 4521 | 4521 |
|
| 4522 | 4522 |
|
| ... | ... | |
| 4579 | 4579 |
|
| 4580 | 4580 |
|
| 4581 | 4581 |
-- |
| 4582 |
-- Name: COLUMN analytical_stem_view.`growthForm`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4582 |
-- Name: COLUMN analytical_stem_view.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4583 | 4583 |
-- |
| 4584 | 4584 |
|
| 4585 | 4585 |
|
| ... | ... | |
| 4628 | 4628 |
|
| 4629 | 4629 |
|
| 4630 | 4630 |
-- |
| 4631 |
-- Name: COLUMN analytical_stem_view.`diameterBreastHeight_cm`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4631 |
-- Name: COLUMN analytical_stem_view.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4632 | 4632 |
-- |
| 4633 | 4633 |
|
| 4634 | 4634 |
|
| 4635 | 4635 |
|
| 4636 | 4636 |
|
| 4637 | 4637 |
-- |
| 4638 |
-- Name: COLUMN analytical_stem_view.height_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 4638 |
-- Name: COLUMN analytical_stem_view.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4639 | 4639 |
-- |
| 4640 | 4640 |
|
| 4641 | 4641 |
|
| 4642 | 4642 |
|
| 4643 | 4643 |
|
| 4644 | 4644 |
-- |
| 4645 |
-- Name: COLUMN analytical_stem_view.tag; Type: COMMENT; Schema: public; Owner: -
|
|
| 4645 |
-- Name: COLUMN analytical_stem_view.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4646 | 4646 |
-- |
| 4647 | 4647 |
|
| 4648 | 4648 |
|
| 4649 | 4649 |
|
| 4650 | 4650 |
|
| 4651 | 4651 |
-- |
| 4652 |
-- Name: COLUMN analytical_stem_view.`organismX_m`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4652 |
-- Name: COLUMN analytical_stem_view.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4653 | 4653 |
-- |
| 4654 | 4654 |
|
| 4655 | 4655 |
|
| 4656 | 4656 |
|
| 4657 | 4657 |
|
| 4658 | 4658 |
-- |
| 4659 |
-- Name: COLUMN analytical_stem_view.`organismY_m`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4659 |
-- Name: COLUMN analytical_stem_view.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4660 | 4660 |
-- |
| 4661 | 4661 |
|
| 4662 | 4662 |
|
| 4663 | 4663 |
|
| 4664 | 4664 |
|
| 4665 | 4665 |
-- |
| 4666 |
-- Name: COLUMN analytical_stem_view.`taxonOccurrenceID`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4666 |
-- Name: COLUMN analytical_stem_view.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4667 | 4667 |
-- |
| 4668 | 4668 |
|
| 4669 | 4669 |
|
| ... | ... | |
| 4677 | 4677 |
|
| 4678 | 4678 |
|
| 4679 | 4679 |
-- |
| 4680 |
-- Name: COLUMN analytical_stem_view.`aggregateOrganismObservationID`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4680 |
-- Name: COLUMN analytical_stem_view.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4681 | 4681 |
-- |
| 4682 | 4682 |
|
| 4683 | 4683 |
|
| 4684 | 4684 |
|
| 4685 | 4685 |
|
| 4686 | 4686 |
-- |
| 4687 |
-- Name: COLUMN analytical_stem_view.`individualObservationID`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4687 |
-- Name: COLUMN analytical_stem_view.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4688 | 4688 |
-- |
| 4689 | 4689 |
|
| 4690 | 4690 |
|
| 4691 | 4691 |
|
| 4692 | 4692 |
|
| 4693 | 4693 |
-- |
| 4694 |
-- Name: COLUMN analytical_stem_view.`individualCode`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4694 |
-- Name: COLUMN analytical_stem_view.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4695 | 4695 |
-- |
| 4696 | 4696 |
|
| 4697 | 4697 |
|
| ... | ... | |
| 4705 | 4705 |
|
| 4706 | 4706 |
|
| 4707 | 4707 |
-- |
| 4708 |
-- Name: COLUMN analytical_stem_view.`stemCode__@VegBank__.stemlocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4708 |
-- Name: COLUMN analytical_stem_view.`stemCode__@VegBank__.stemLocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4709 | 4709 |
-- |
| 4710 | 4710 |
|
| 4711 | 4711 |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: applied data dictionary renamings, using the steps at wiki.vegpath.org/VegBIEN_schema_refactoring#apply-data-dictionary-renamings-to-database