Revision 13728
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/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 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 6742 | 6742 |
"plot.**"."decimalLatitude" AS "decimalLatitude__@DwC__@vegpath.org", |
| 6743 | 6743 |
"plot.**"."decimalLongitude" AS "decimalLongitude__@DwC__@vegpath.org", |
| 6744 | 6744 |
"plot.**"."coordinateUncertaintyInMeters" AS "coordinateUncertaintyInMeters__@DwC__@vegpath.org", |
| 6745 |
"plot.**"."coordinateSource_bien", |
|
| 6746 |
"plot.**"."georeferenceProtocol_bien", |
|
| 6745 |
"plot.**"."coordinateSource_bien" AS "georeferenceSources__@DwC__@vegpath.org",
|
|
| 6746 |
"plot.**"."georeferenceProtocol_bien" AS "georeferenceProtocol__@DwC__@vegpath.org",
|
|
| 6747 | 6747 |
"plot.**".geovalid_bien, |
| 6748 | 6748 |
"plot.**"."isNewWorld_bien", |
| 6749 | 6749 |
"plot.**"."projectID" AS "projectID__@VegX__.plotObservation@vegpath.org", |
| 6750 |
"plot.**".project_contributors, |
|
| 6750 |
"plot.**".project_contributors AS "projectContributor[s]__@VegBank__@vegpath.org",
|
|
| 6751 | 6751 |
"plot.**"."locationID" AS "locationID__@DwC__@vegpath.org", |
| 6752 | 6752 |
"plot.**"."locationName" AS "plotName__@VegX__.plot@vegpath.org", |
| 6753 |
"plot.**".subplot AS "subplot__@SALVIAS__@vegpath.org", |
|
| 6753 |
"plot.**".subplot AS "subplot__@SALVIAS__.Plot_data@vegpath.org",
|
|
| 6754 | 6754 |
"plot.**".location__cultivated__bien, |
| 6755 | 6755 |
"plot.**".locationevent__pkey AS "locationevent.locationevent_id__@VegBIEN__.public@vegpath.org", |
| 6756 | 6756 |
"plot.**"."eventDate" AS "eventDate__@DwC__@vegpath.org", |
| 6757 |
"plot.**"."elevationInMeters", |
|
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect__@VegX__.plot@vegpath.org", |
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient__@VegX__.plot@vegpath.org", |
|
| 6760 |
"plot.**"."plotArea_ha", |
|
| 6757 |
"plot.**"."elevationInMeters" AS "(-minimum-)ElevationInMeters__@DwC__@vegpath.org",
|
|
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect[_deg]__@VegX__.plot@vegpath.org",
|
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient[_deg]__@VegX__.plot@vegpath.org",
|
|
| 6760 |
"plot.**"."plotArea_ha" AS "area[_ha]__@VegX__.plot@vegpath.org",
|
|
| 6761 | 6761 |
"plot.**"."samplingProtocol" AS "samplingProtocol__@DwC__@vegpath.org", |
| 6762 |
"plot.**"."temperature_C", |
|
| 6763 |
"plot.**".precipitation_m, |
|
| 6764 |
"plot.**".stratum__name, |
|
| 6765 |
"plot.**".communities, |
|
| 6766 |
"plot.**".plot__collectors, |
|
| 6767 |
sourcelist.name AS "specimenHolderInstitutions",
|
|
| 6768 |
specimenreplicate.collectioncode_dwc AS collection,
|
|
| 6769 |
specimenreplicate.catalognumber_dwc AS "accessionNumber",
|
|
| 6762 |
"plot.**"."temperature_C" AS "temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",
|
|
| 6763 |
"plot.**".precipitation_m AS "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",
|
|
| 6764 |
"plot.**".stratum__name AS "stratumName__@VegX__.stratum@vegpath.org",
|
|
| 6765 |
"plot.**".communities AS "communityConcept.name__@VegX__.communityDet@vegpath.org",
|
|
| 6766 |
"plot.**".plot__collectors AS "observationContributor[s]__@VegBank__@vegpath.org",
|
|
| 6767 |
sourcelist.name AS "[custodial_]institutionCode[s]__@DwC__@vegpath.org",
|
|
| 6768 |
specimenreplicate.collectioncode_dwc AS "collectionCode__@DwC__@vegpath.org",
|
|
| 6769 |
specimenreplicate.catalognumber_dwc AS "catalogNumber__@DwC__@vegpath.org",
|
|
| 6770 | 6770 |
specimenreplicate.sourceaccessioncode AS "occurrenceID__@DwC__@vegpath.org", |
| 6771 | 6771 |
collector.fullname AS "recordedBy__@DwC__@vegpath.org", |
| 6772 | 6772 |
plantobservation.authorplantcode AS "recordNumber__@DwC__@vegpath.org", |
| 6773 |
COALESCE(aggregateoccurrence.collectiondate, "plot.**"."eventDate") AS "dateCollected",
|
|
| 6774 |
taxonverbatim.family AS family_verbatim,
|
|
| 6775 |
COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS "scientificName_verbatim",
|
|
| 6773 |
COALESCE(aggregateoccurrence.collectiondate, "plot.**"."eventDate") AS "(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",
|
|
| 6774 |
taxonverbatim.family AS "[verbatim_]family__@DwC__@vegpath.org",
|
|
| 6775 |
COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS "[verbatim_]scientificName__@DwC__@vegpath.org",
|
|
| 6776 | 6776 |
identifiedby.fullname AS "identifiedBy__@DwC__@vegpath.org", |
| 6777 | 6777 |
taxondetermination.determinationdate AS "dateIdentified__@DwC__@vegpath.org", |
| 6778 | 6778 |
taxondetermination.notes AS "identificationRemarks__@DwC__@vegpath.org", |
| 6779 | 6779 |
taxon_scrub."matchedFamily" AS "Family_matched__@TNRS__@vegpath.org", |
| 6780 |
taxon_scrub."matchedTaxonName" AS "taxonName_matched",
|
|
| 6781 |
taxon_scrub."matchedScientificNameAuthorship" AS "scientificNameAuthorship_matched",
|
|
| 6782 |
family_higher_plant_group.higher_plant_group AS "higherPlantGroup_bien",
|
|
| 6783 |
taxon_scrub."taxonomicStatus" AS taxonomic_status,
|
|
| 6780 |
taxon_scrub."matchedTaxonName" AS "Name_matched__@TNRS__@vegpath.org",
|
|
| 6781 |
taxon_scrub."matchedScientificNameAuthorship" AS "Name_matched_author__@TNRS__@vegpath.org",
|
|
| 6782 |
family_higher_plant_group.higher_plant_group AS "[higher_plant_group~]higherClassification__@DwC__@vegpath.org",
|
|
| 6783 |
taxon_scrub."taxonomicStatus" AS "taxonomicStatus__@DwC__@vegpath.org",
|
|
| 6784 | 6784 |
taxon_scrub.scrubbed_family, |
| 6785 | 6785 |
taxon_scrub.scrubbed_genus, |
| 6786 | 6786 |
taxon_scrub.scrubbed_specific_epithet, |
| ... | ... | |
| 6789 | 6789 |
taxon_scrub.scrubbed_author, |
| 6790 | 6790 |
taxon_scrub.scrubbed_taxon_name_with_author, |
| 6791 | 6791 |
taxon_scrub.scrubbed_morphospecies_binomial AS "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org", |
| 6792 |
taxonoccurrence.growthform AS "growthForm",
|
|
| 6792 |
taxonoccurrence.growthform AS "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",
|
|
| 6793 | 6793 |
plantobservation.reproductivecondition AS "reproductiveCondition__@DwC__@vegpath.org", |
| 6794 | 6794 |
((threatened_taxonlabel.taxonlabel_id IS NOT NULL))::integer AS threatened_bien, |
| 6795 | 6795 |
(((cultivated_family_locations.country IS NOT NULL) OR _or(taxonoccurrence.iscultivated, "plot.**".location__cultivated__bien)))::integer AS cultivated_bien, |
| ... | ... | |
| 6800 | 6800 |
END AS "cultivatedBasis_bien", |
| 6801 | 6801 |
aggregateoccurrence.notes AS "occurrenceRemarks__@DwC__@vegpath.org", |
| 6802 | 6802 |
_fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent__@VegX__.attribute.ordinal@vegpath.org", |
| 6803 |
_m_to_cm(stemobservation.diameterbreastheight_m) AS "diameterBreastHeight_cm",
|
|
| 6804 |
stemobservation.height_m, |
|
| 6805 |
stemobservation.tag, |
|
| 6806 |
stemobservation.xposition_m AS "organismX_m",
|
|
| 6807 |
stemobservation.yposition_m AS "organismY_m",
|
|
| 6808 |
taxonoccurrence.sourceaccessioncode AS "taxonOccurrenceID",
|
|
| 6803 |
_m_to_cm(stemobservation.diameterbreastheight_m) AS "stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org",
|
|
| 6804 |
stemobservation.height_m AS "stemHeight[_m]__@VegBank__.stemCount@vegpath.org",
|
|
| 6805 |
stemobservation.tag AS "[tag=]identificationLabel__@VegX__.individual@vegpath.org",
|
|
| 6806 |
stemobservation.xposition_m AS "relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org",
|
|
| 6807 |
stemobservation.yposition_m AS "relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org",
|
|
| 6808 |
taxonoccurrence.sourceaccessioncode AS "taxonObservation[.id]__@VegBank__@vegpath.org",
|
|
| 6809 | 6809 |
taxonoccurrence.authortaxoncode AS "authorTaxonCode", |
| 6810 |
aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservationID",
|
|
| 6811 |
plantobservation.sourceaccessioncode AS "individualObservationID",
|
|
| 6812 |
plantobservation.authorplantcode AS "individualCode",
|
|
| 6810 |
aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservation.id__@VegX__@vegpath.org",
|
|
| 6811 |
plantobservation.sourceaccessioncode AS "individualOrganismObservation.id__@VegX__@vegpath.org",
|
|
| 6812 |
plantobservation.authorplantcode AS "individualID__@DwC__@vegpath.org",
|
|
| 6813 | 6813 |
aggregateoccurrence.count AS "individualCount__@DwC__@vegpath.org", |
| 6814 |
stemobservation.authorstemcode AS "stemCode__@VegBank__.stemlocation@vegpath.org"
|
|
| 6814 |
stemobservation.authorstemcode AS "stemCode__@VegBank__.stemLocation@vegpath.org"
|
|
| 6815 | 6815 |
FROM ((((((((((((((("plot.**"
|
| 6816 | 6816 |
LEFT JOIN taxonoccurrence ON ((taxonoccurrence.locationevent_id = "plot.**".locationevent__pkey))) |
| 6817 | 6817 |
LEFT JOIN party collector ON ((collector.party_id = taxonoccurrence.collector_id))) |
| ... | ... | |
| 6899 | 6899 |
|
| 6900 | 6900 |
|
| 6901 | 6901 |
-- |
| 6902 |
-- Name: COLUMN analytical_stem_view."coordinateSource_bien"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6902 |
-- Name: COLUMN analytical_stem_view."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6903 | 6903 |
-- |
| 6904 | 6904 |
|
| 6905 |
COMMENT ON COLUMN analytical_stem_view."coordinateSource_bien" IS 'derived column';
|
|
| 6905 |
COMMENT ON COLUMN analytical_stem_view."georeferenceSources__@DwC__@vegpath.org" IS 'derived column';
|
|
| 6906 | 6906 |
|
| 6907 | 6907 |
|
| 6908 | 6908 |
-- |
| 6909 |
-- Name: COLUMN analytical_stem_view."georeferenceProtocol_bien"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6909 |
-- Name: COLUMN analytical_stem_view."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6910 | 6910 |
-- |
| 6911 | 6911 |
|
| 6912 |
COMMENT ON COLUMN analytical_stem_view."georeferenceProtocol_bien" IS 'derived column';
|
|
| 6912 |
COMMENT ON COLUMN analytical_stem_view."georeferenceProtocol__@DwC__@vegpath.org" IS 'derived column';
|
|
| 6913 | 6913 |
|
| 6914 | 6914 |
|
| 6915 | 6915 |
-- |
| ... | ... | |
| 6935 | 6935 |
|
| 6936 | 6936 |
|
| 6937 | 6937 |
-- |
| 6938 |
-- Name: COLUMN analytical_stem_view.project_contributors; Type: COMMENT; Schema: public; Owner: -
|
|
| 6938 |
-- Name: COLUMN analytical_stem_view."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6939 | 6939 |
-- |
| 6940 | 6940 |
|
| 6941 |
COMMENT ON COLUMN analytical_stem_view.project_contributors IS 'variant of VegBank term';
|
|
| 6941 |
COMMENT ON COLUMN analytical_stem_view."projectContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term';
|
|
| 6942 | 6942 |
|
| 6943 | 6943 |
|
| 6944 | 6944 |
-- |
| ... | ... | |
| 6956 | 6956 |
|
| 6957 | 6957 |
|
| 6958 | 6958 |
-- |
| 6959 |
-- Name: COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 6959 |
-- Name: COLUMN analytical_stem_view."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6960 | 6960 |
-- |
| 6961 | 6961 |
|
| 6962 |
COMMENT ON COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org; |
|
| 6962 |
COMMENT ON COLUMN analytical_stem_view."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org;
|
|
| 6963 | 6963 |
"Code for subplot, line, or any other subsample or subdivision of plot"'; |
| 6964 | 6964 |
|
| 6965 | 6965 |
|
| ... | ... | |
| 6986 | 6986 |
|
| 6987 | 6987 |
|
| 6988 | 6988 |
-- |
| 6989 |
-- Name: COLUMN analytical_stem_view."elevationInMeters"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6989 |
-- Name: COLUMN analytical_stem_view."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6990 | 6990 |
-- |
| 6991 | 6991 |
|
| 6992 |
COMMENT ON COLUMN analytical_stem_view."elevationInMeters" IS 'variant of DwC term';
|
|
| 6992 |
COMMENT ON COLUMN analytical_stem_view."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 6993 | 6993 |
|
| 6994 | 6994 |
|
| 6995 | 6995 |
-- |
| 6996 |
-- Name: COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 6996 |
-- Name: COLUMN analytical_stem_view."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6997 | 6997 |
-- |
| 6998 | 6998 |
|
| 6999 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"'; |
|
| 6999 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect[_deg]__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';
|
|
| 7000 | 7000 |
|
| 7001 | 7001 |
|
| 7002 | 7002 |
-- |
| 7003 |
-- Name: COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 7003 |
-- Name: COLUMN analytical_stem_view."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7004 | 7004 |
-- |
| 7005 | 7005 |
|
| 7006 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"'; |
|
| 7006 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
|
|
| 7007 | 7007 |
|
| 7008 | 7008 |
|
| 7009 | 7009 |
-- |
| 7010 |
-- Name: COLUMN analytical_stem_view."plotArea_ha"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7010 |
-- Name: COLUMN analytical_stem_view."area[_ha]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7011 | 7011 |
-- |
| 7012 | 7012 |
|
| 7013 |
COMMENT ON COLUMN analytical_stem_view."plotArea_ha" IS 'variant of VegX term';
|
|
| 7013 |
COMMENT ON COLUMN analytical_stem_view."area[_ha]__@VegX__.plot@vegpath.org" IS 'variant of VegX term';
|
|
| 7014 | 7014 |
|
| 7015 | 7015 |
|
| 7016 | 7016 |
-- |
| ... | ... | |
| 7021 | 7021 |
|
| 7022 | 7022 |
|
| 7023 | 7023 |
-- |
| 7024 |
-- Name: COLUMN analytical_stem_view."temperature_C"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7024 |
-- Name: COLUMN analytical_stem_view."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7025 | 7025 |
-- |
| 7026 | 7026 |
|
| 7027 |
COMMENT ON COLUMN analytical_stem_view."temperature_C" IS 'variant of VegX term';
|
|
| 7027 |
COMMENT ON COLUMN analytical_stem_view."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS 'variant of VegX term';
|
|
| 7028 | 7028 |
|
| 7029 | 7029 |
|
| 7030 | 7030 |
-- |
| 7031 |
-- Name: COLUMN analytical_stem_view.precipitation_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 7031 |
-- Name: COLUMN analytical_stem_view."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7032 | 7032 |
-- |
| 7033 | 7033 |
|
| 7034 |
COMMENT ON COLUMN analytical_stem_view.precipitation_m IS 'variant of VegX term';
|
|
| 7034 |
COMMENT ON COLUMN analytical_stem_view."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS 'variant of VegX term';
|
|
| 7035 | 7035 |
|
| 7036 | 7036 |
|
| 7037 | 7037 |
-- |
| 7038 |
-- Name: COLUMN analytical_stem_view.stratum__name; Type: COMMENT; Schema: public; Owner: -
|
|
| 7038 |
-- Name: COLUMN analytical_stem_view."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7039 | 7039 |
-- |
| 7040 | 7040 |
|
| 7041 |
COMMENT ON COLUMN analytical_stem_view.stratum__name IS 'from VegX, renamed';
|
|
| 7041 |
COMMENT ON COLUMN analytical_stem_view."stratumName__@VegX__.stratum@vegpath.org" IS 'from VegX, renamed';
|
|
| 7042 | 7042 |
|
| 7043 | 7043 |
|
| 7044 | 7044 |
-- |
| 7045 |
-- Name: COLUMN analytical_stem_view.communities; Type: COMMENT; Schema: public; Owner: -
|
|
| 7045 |
-- Name: COLUMN analytical_stem_view."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7046 | 7046 |
-- |
| 7047 | 7047 |
|
| 7048 |
COMMENT ON COLUMN analytical_stem_view.communities IS 'variant of VegX term';
|
|
| 7048 |
COMMENT ON COLUMN analytical_stem_view."communityConcept.name__@VegX__.communityDet@vegpath.org" IS 'variant of VegX term';
|
|
| 7049 | 7049 |
|
| 7050 | 7050 |
|
| 7051 | 7051 |
-- |
| 7052 |
-- Name: COLUMN analytical_stem_view.plot__collectors; Type: COMMENT; Schema: public; Owner: -
|
|
| 7052 |
-- Name: COLUMN analytical_stem_view."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7053 | 7053 |
-- |
| 7054 | 7054 |
|
| 7055 |
COMMENT ON COLUMN analytical_stem_view.plot__collectors IS 'variant of VegBank term';
|
|
| 7055 |
COMMENT ON COLUMN analytical_stem_view."observationContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term';
|
|
| 7056 | 7056 |
|
| 7057 | 7057 |
|
| 7058 | 7058 |
-- |
| 7059 |
-- Name: COLUMN analytical_stem_view."specimenHolderInstitutions"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7059 |
-- Name: COLUMN analytical_stem_view."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7060 | 7060 |
-- |
| 7061 | 7061 |
|
| 7062 |
COMMENT ON COLUMN analytical_stem_view."specimenHolderInstitutions" IS 'from DwC, renamed';
|
|
| 7062 |
COMMENT ON COLUMN analytical_stem_view."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS 'from DwC, renamed';
|
|
| 7063 | 7063 |
|
| 7064 | 7064 |
|
| 7065 | 7065 |
-- |
| 7066 |
-- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: -
|
|
| 7066 |
-- Name: COLUMN analytical_stem_view."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7067 | 7067 |
-- |
| 7068 | 7068 |
|
| 7069 |
COMMENT ON COLUMN analytical_stem_view.collection IS 'from DwC, renamed';
|
|
| 7069 |
COMMENT ON COLUMN analytical_stem_view."collectionCode__@DwC__@vegpath.org" IS 'from DwC, renamed';
|
|
| 7070 | 7070 |
|
| 7071 | 7071 |
|
| 7072 | 7072 |
-- |
| 7073 |
-- Name: COLUMN analytical_stem_view."accessionNumber"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7073 |
-- Name: COLUMN analytical_stem_view."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7074 | 7074 |
-- |
| 7075 | 7075 |
|
| 7076 |
COMMENT ON COLUMN analytical_stem_view."accessionNumber" IS 'variant of DwC term';
|
|
| 7076 |
COMMENT ON COLUMN analytical_stem_view."catalogNumber__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 7077 | 7077 |
|
| 7078 | 7078 |
|
| 7079 | 7079 |
-- |
| ... | ... | |
| 7098 | 7098 |
|
| 7099 | 7099 |
|
| 7100 | 7100 |
-- |
| 7101 |
-- Name: COLUMN analytical_stem_view."dateCollected"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7101 |
-- Name: COLUMN analytical_stem_view."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7102 | 7102 |
-- |
| 7103 | 7103 |
|
| 7104 |
COMMENT ON COLUMN analytical_stem_view."dateCollected" IS 'variant of DwC term';
|
|
| 7104 |
COMMENT ON COLUMN analytical_stem_view."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'variant of DwC term';
|
|
| 7105 | 7105 |
|
| 7106 | 7106 |
|
| 7107 | 7107 |
-- |
| 7108 |
-- Name: COLUMN analytical_stem_view.family_verbatim; Type: COMMENT; Schema: public; Owner: -
|
|
| 7108 |
-- Name: COLUMN analytical_stem_view."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7109 | 7109 |
-- |
| 7110 | 7110 |
|
| 7111 |
COMMENT ON COLUMN analytical_stem_view.family_verbatim IS 'variant of DwC term';
|
|
| 7111 |
COMMENT ON COLUMN analytical_stem_view."[verbatim_]family__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 7112 | 7112 |
|
| 7113 | 7113 |
|
| 7114 | 7114 |
-- |
| 7115 |
-- Name: COLUMN analytical_stem_view."scientificName_verbatim"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7115 |
-- Name: COLUMN analytical_stem_view."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7116 | 7116 |
-- |
| 7117 | 7117 |
|
| 7118 |
COMMENT ON COLUMN analytical_stem_view."scientificName_verbatim" IS 'variant of DwC term';
|
|
| 7118 |
COMMENT ON COLUMN analytical_stem_view."[verbatim_]scientificName__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 7119 | 7119 |
|
| 7120 | 7120 |
|
| 7121 | 7121 |
-- |
| ... | ... | |
| 7148 | 7148 |
|
| 7149 | 7149 |
|
| 7150 | 7150 |
-- |
| 7151 |
-- Name: COLUMN analytical_stem_view."taxonName_matched"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7151 |
-- Name: COLUMN analytical_stem_view."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7152 | 7152 |
-- |
| 7153 | 7153 |
|
| 7154 |
COMMENT ON COLUMN analytical_stem_view."taxonName_matched" IS 'from TNRS, renamed';
|
|
| 7154 |
COMMENT ON COLUMN analytical_stem_view."Name_matched__@TNRS__@vegpath.org" IS 'from TNRS, renamed';
|
|
| 7155 | 7155 |
|
| 7156 | 7156 |
|
| 7157 | 7157 |
-- |
| 7158 |
-- Name: COLUMN analytical_stem_view."scientificNameAuthorship_matched"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7158 |
-- Name: COLUMN analytical_stem_view."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7159 | 7159 |
-- |
| 7160 | 7160 |
|
| 7161 |
COMMENT ON COLUMN analytical_stem_view."scientificNameAuthorship_matched" IS 'from TNRS, renamed';
|
|
| 7161 |
COMMENT ON COLUMN analytical_stem_view."Name_matched_author__@TNRS__@vegpath.org" IS 'from TNRS, renamed';
|
|
| 7162 | 7162 |
|
| 7163 | 7163 |
|
| 7164 | 7164 |
-- |
| 7165 |
-- Name: COLUMN analytical_stem_view."higherPlantGroup_bien"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7165 |
-- Name: COLUMN analytical_stem_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7166 | 7166 |
-- |
| 7167 | 7167 |
|
| 7168 |
COMMENT ON COLUMN analytical_stem_view."higherPlantGroup_bien" IS 'derived column';
|
|
| 7168 |
COMMENT ON COLUMN analytical_stem_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'derived column';
|
|
| 7169 | 7169 |
|
| 7170 | 7170 |
|
| 7171 | 7171 |
-- |
| 7172 |
-- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: -
|
|
| 7172 |
-- Name: COLUMN analytical_stem_view."taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7173 | 7173 |
-- |
| 7174 | 7174 |
|
| 7175 |
COMMENT ON COLUMN analytical_stem_view.taxonomic_status IS 'from DwC, renamed';
|
|
| 7175 |
COMMENT ON COLUMN analytical_stem_view."taxonomicStatus__@DwC__@vegpath.org" IS 'from DwC, renamed';
|
|
| 7176 | 7176 |
|
| 7177 | 7177 |
|
| 7178 | 7178 |
-- |
| ... | ... | |
| 7233 | 7233 |
|
| 7234 | 7234 |
|
| 7235 | 7235 |
-- |
| 7236 |
-- Name: COLUMN analytical_stem_view."growthForm"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7236 |
-- Name: COLUMN analytical_stem_view."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7237 | 7237 |
-- |
| 7238 | 7238 |
|
| 7239 |
COMMENT ON COLUMN analytical_stem_view."growthForm" IS 'from SALVIAS, renamed';
|
|
| 7239 |
COMMENT ON COLUMN analytical_stem_view."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS 'from SALVIAS, renamed';
|
|
| 7240 | 7240 |
|
| 7241 | 7241 |
|
| 7242 | 7242 |
-- |
| ... | ... | |
| 7282 | 7282 |
|
| 7283 | 7283 |
|
| 7284 | 7284 |
-- |
| 7285 |
-- Name: COLUMN analytical_stem_view."diameterBreastHeight_cm"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7285 |
-- Name: COLUMN analytical_stem_view."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7286 | 7286 |
-- |
| 7287 | 7287 |
|
| 7288 |
COMMENT ON COLUMN analytical_stem_view."diameterBreastHeight_cm" IS 'from SALVIAS, renamed';
|
|
| 7288 |
COMMENT ON COLUMN analytical_stem_view."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS 'from SALVIAS, renamed';
|
|
| 7289 | 7289 |
|
| 7290 | 7290 |
|
| 7291 | 7291 |
-- |
| 7292 |
-- Name: COLUMN analytical_stem_view.height_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 7292 |
-- Name: COLUMN analytical_stem_view."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7293 | 7293 |
-- |
| 7294 | 7294 |
|
| 7295 |
COMMENT ON COLUMN analytical_stem_view.height_m IS 'variant of VegX term';
|
|
| 7295 |
COMMENT ON COLUMN analytical_stem_view."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS 'variant of VegX term';
|
|
| 7296 | 7296 |
|
| 7297 | 7297 |
|
| 7298 | 7298 |
-- |
| 7299 |
-- Name: COLUMN analytical_stem_view.tag; Type: COMMENT; Schema: public; Owner: -
|
|
| 7299 |
-- Name: COLUMN analytical_stem_view."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7300 | 7300 |
-- |
| 7301 | 7301 |
|
| 7302 |
COMMENT ON COLUMN analytical_stem_view.tag IS 'from VegX, renamed';
|
|
| 7302 |
COMMENT ON COLUMN analytical_stem_view."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS 'from VegX, renamed';
|
|
| 7303 | 7303 |
|
| 7304 | 7304 |
|
| 7305 | 7305 |
-- |
| 7306 |
-- Name: COLUMN analytical_stem_view."organismX_m"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7306 |
-- Name: COLUMN analytical_stem_view."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7307 | 7307 |
-- |
| 7308 | 7308 |
|
| 7309 |
COMMENT ON COLUMN analytical_stem_view."organismX_m" IS 'variant of VegX term';
|
|
| 7309 |
COMMENT ON COLUMN analytical_stem_view."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS 'variant of VegX term';
|
|
| 7310 | 7310 |
|
| 7311 | 7311 |
|
| 7312 | 7312 |
-- |
| 7313 |
-- Name: COLUMN analytical_stem_view."organismY_m"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7313 |
-- Name: COLUMN analytical_stem_view."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7314 | 7314 |
-- |
| 7315 | 7315 |
|
| 7316 |
COMMENT ON COLUMN analytical_stem_view."organismY_m" IS 'variant of VegX term';
|
|
| 7316 |
COMMENT ON COLUMN analytical_stem_view."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS 'variant of VegX term';
|
|
| 7317 | 7317 |
|
| 7318 | 7318 |
|
| 7319 | 7319 |
-- |
| 7320 |
-- Name: COLUMN analytical_stem_view."taxonOccurrenceID"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7320 |
-- Name: COLUMN analytical_stem_view."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7321 | 7321 |
-- |
| 7322 | 7322 |
|
| 7323 |
COMMENT ON COLUMN analytical_stem_view."taxonOccurrenceID" IS 'from VegX, renamed';
|
|
| 7323 |
COMMENT ON COLUMN analytical_stem_view."taxonObservation[.id]__@VegBank__@vegpath.org" IS 'from VegX, renamed';
|
|
| 7324 | 7324 |
|
| 7325 | 7325 |
|
| 7326 | 7326 |
-- |
| ... | ... | |
| 7331 | 7331 |
|
| 7332 | 7332 |
|
| 7333 | 7333 |
-- |
| 7334 |
-- Name: COLUMN analytical_stem_view."aggregateOrganismObservationID"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7334 |
-- Name: COLUMN analytical_stem_view."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7335 | 7335 |
-- |
| 7336 | 7336 |
|
| 7337 |
COMMENT ON COLUMN analytical_stem_view."aggregateOrganismObservationID" IS 'from VegX, renamed';
|
|
| 7337 |
COMMENT ON COLUMN analytical_stem_view."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'from VegX, renamed';
|
|
| 7338 | 7338 |
|
| 7339 | 7339 |
|
| 7340 | 7340 |
-- |
| 7341 |
-- Name: COLUMN analytical_stem_view."individualObservationID"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7341 |
-- Name: COLUMN analytical_stem_view."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7342 | 7342 |
-- |
| 7343 | 7343 |
|
| 7344 |
COMMENT ON COLUMN analytical_stem_view."individualObservationID" IS 'from VegX, renamed';
|
|
| 7344 |
COMMENT ON COLUMN analytical_stem_view."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'from VegX, renamed';
|
|
| 7345 | 7345 |
|
| 7346 | 7346 |
|
| 7347 | 7347 |
-- |
| 7348 |
-- Name: COLUMN analytical_stem_view."individualCode"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7348 |
-- Name: COLUMN analytical_stem_view."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7349 | 7349 |
-- |
| 7350 | 7350 |
|
| 7351 |
COMMENT ON COLUMN analytical_stem_view."individualCode" IS 'from SALVIAS, renamed';
|
|
| 7351 |
COMMENT ON COLUMN analytical_stem_view."individualID__@DwC__@vegpath.org" IS 'from SALVIAS, renamed';
|
|
| 7352 | 7352 |
|
| 7353 | 7353 |
|
| 7354 | 7354 |
-- |
| ... | ... | |
| 7359 | 7359 |
|
| 7360 | 7360 |
|
| 7361 | 7361 |
-- |
| 7362 |
-- Name: COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7362 |
-- Name: COLUMN analytical_stem_view."stemCode__@VegBank__.stemLocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7363 | 7363 |
-- |
| 7364 | 7364 |
|
| 7365 |
COMMENT ON COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
|
|
| 7365 |
COMMENT ON COLUMN analytical_stem_view."stemCode__@VegBank__.stemLocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
|
|
| 7366 | 7366 |
"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."'; |
| 7367 | 7367 |
|
| 7368 | 7368 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 6742 | 6742 |
"plot.**"."decimalLatitude" AS "decimalLatitude__@DwC__@vegpath.org", |
| 6743 | 6743 |
"plot.**"."decimalLongitude" AS "decimalLongitude__@DwC__@vegpath.org", |
| 6744 | 6744 |
"plot.**"."coordinateUncertaintyInMeters" AS "coordinateUncertaintyInMeters__@DwC__@vegpath.org", |
| 6745 |
"plot.**"."coordinateSource_bien", |
|
| 6746 |
"plot.**"."georeferenceProtocol_bien", |
|
| 6745 |
"plot.**"."coordinateSource_bien" AS "georeferenceSources__@DwC__@vegpath.org",
|
|
| 6746 |
"plot.**"."georeferenceProtocol_bien" AS "georeferenceProtocol__@DwC__@vegpath.org",
|
|
| 6747 | 6747 |
"plot.**".geovalid_bien, |
| 6748 | 6748 |
"plot.**"."isNewWorld_bien", |
| 6749 | 6749 |
"plot.**"."projectID" AS "projectID__@VegX__.plotObservation@vegpath.org", |
| 6750 |
"plot.**".project_contributors, |
|
| 6750 |
"plot.**".project_contributors AS "projectContributor[s]__@VegBank__@vegpath.org",
|
|
| 6751 | 6751 |
"plot.**"."locationID" AS "locationID__@DwC__@vegpath.org", |
| 6752 | 6752 |
"plot.**"."locationName" AS "plotName__@VegX__.plot@vegpath.org", |
| 6753 |
"plot.**".subplot AS "subplot__@SALVIAS__@vegpath.org", |
|
| 6753 |
"plot.**".subplot AS "subplot__@SALVIAS__.Plot_data@vegpath.org",
|
|
| 6754 | 6754 |
"plot.**".location__cultivated__bien, |
| 6755 | 6755 |
"plot.**".locationevent__pkey AS "locationevent.locationevent_id__@VegBIEN__.public@vegpath.org", |
| 6756 | 6756 |
"plot.**"."eventDate" AS "eventDate__@DwC__@vegpath.org", |
| 6757 |
"plot.**"."elevationInMeters", |
|
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect__@VegX__.plot@vegpath.org", |
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient__@VegX__.plot@vegpath.org", |
|
| 6760 |
"plot.**"."plotArea_ha", |
|
| 6757 |
"plot.**"."elevationInMeters" AS "(-minimum-)ElevationInMeters__@DwC__@vegpath.org",
|
|
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect[_deg]__@VegX__.plot@vegpath.org",
|
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient[_deg]__@VegX__.plot@vegpath.org",
|
|
| 6760 |
"plot.**"."plotArea_ha" AS "area[_ha]__@VegX__.plot@vegpath.org",
|
|
| 6761 | 6761 |
"plot.**"."samplingProtocol" AS "samplingProtocol__@DwC__@vegpath.org", |
| 6762 |
"plot.**"."temperature_C", |
|
| 6763 |
"plot.**".precipitation_m, |
|
| 6764 |
"plot.**".stratum__name, |
|
| 6765 |
"plot.**".communities, |
|
| 6766 |
"plot.**".plot__collectors, |
|
| 6767 |
sourcelist.name AS "specimenHolderInstitutions",
|
|
| 6768 |
specimenreplicate.collectioncode_dwc AS collection,
|
|
| 6769 |
specimenreplicate.catalognumber_dwc AS "accessionNumber",
|
|
| 6762 |
"plot.**"."temperature_C" AS "temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",
|
|
| 6763 |
"plot.**".precipitation_m AS "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",
|
|
| 6764 |
"plot.**".stratum__name AS "stratumName__@VegX__.stratum@vegpath.org",
|
|
| 6765 |
"plot.**".communities AS "communityConcept.name__@VegX__.communityDet@vegpath.org",
|
|
| 6766 |
"plot.**".plot__collectors AS "observationContributor[s]__@VegBank__@vegpath.org",
|
|
| 6767 |
sourcelist.name AS "[custodial_]institutionCode[s]__@DwC__@vegpath.org",
|
|
| 6768 |
specimenreplicate.collectioncode_dwc AS "collectionCode__@DwC__@vegpath.org",
|
|
| 6769 |
specimenreplicate.catalognumber_dwc AS "catalogNumber__@DwC__@vegpath.org",
|
|
| 6770 | 6770 |
specimenreplicate.sourceaccessioncode AS "occurrenceID__@DwC__@vegpath.org", |
| 6771 | 6771 |
collector.fullname AS "recordedBy__@DwC__@vegpath.org", |
| 6772 | 6772 |
plantobservation.authorplantcode AS "recordNumber__@DwC__@vegpath.org", |
| 6773 |
COALESCE(aggregateoccurrence.collectiondate, "plot.**"."eventDate") AS "dateCollected",
|
|
| 6774 |
taxonverbatim.family AS family_verbatim,
|
|
| 6775 |
COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS "scientificName_verbatim",
|
|
| 6773 |
COALESCE(aggregateoccurrence.collectiondate, "plot.**"."eventDate") AS "(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",
|
|
| 6774 |
taxonverbatim.family AS "[verbatim_]family__@DwC__@vegpath.org",
|
|
| 6775 |
COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS "[verbatim_]scientificName__@DwC__@vegpath.org",
|
|
| 6776 | 6776 |
identifiedby.fullname AS "identifiedBy__@DwC__@vegpath.org", |
| 6777 | 6777 |
taxondetermination.determinationdate AS "dateIdentified__@DwC__@vegpath.org", |
| 6778 | 6778 |
taxondetermination.notes AS "identificationRemarks__@DwC__@vegpath.org", |
| 6779 | 6779 |
taxon_scrub."matchedFamily" AS "Family_matched__@TNRS__@vegpath.org", |
| 6780 |
taxon_scrub."matchedTaxonName" AS "taxonName_matched",
|
|
| 6781 |
taxon_scrub."matchedScientificNameAuthorship" AS "scientificNameAuthorship_matched",
|
|
| 6782 |
family_higher_plant_group.higher_plant_group AS "higherPlantGroup_bien",
|
|
| 6783 |
taxon_scrub."taxonomicStatus" AS taxonomic_status,
|
|
| 6780 |
taxon_scrub."matchedTaxonName" AS "Name_matched__@TNRS__@vegpath.org",
|
|
| 6781 |
taxon_scrub."matchedScientificNameAuthorship" AS "Name_matched_author__@TNRS__@vegpath.org",
|
|
| 6782 |
family_higher_plant_group.higher_plant_group AS "[higher_plant_group~]higherClassification__@DwC__@vegpath.org",
|
|
| 6783 |
taxon_scrub."taxonomicStatus" AS "taxonomicStatus__@DwC__@vegpath.org",
|
|
| 6784 | 6784 |
taxon_scrub.scrubbed_family, |
| 6785 | 6785 |
taxon_scrub.scrubbed_genus, |
| 6786 | 6786 |
taxon_scrub.scrubbed_specific_epithet, |
| ... | ... | |
| 6789 | 6789 |
taxon_scrub.scrubbed_author, |
| 6790 | 6790 |
taxon_scrub.scrubbed_taxon_name_with_author, |
| 6791 | 6791 |
taxon_scrub.scrubbed_morphospecies_binomial AS "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org", |
| 6792 |
taxonoccurrence.growthform AS "growthForm",
|
|
| 6792 |
taxonoccurrence.growthform AS "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",
|
|
| 6793 | 6793 |
plantobservation.reproductivecondition AS "reproductiveCondition__@DwC__@vegpath.org", |
| 6794 | 6794 |
((threatened_taxonlabel.taxonlabel_id IS NOT NULL))::integer AS threatened_bien, |
| 6795 | 6795 |
(((cultivated_family_locations.country IS NOT NULL) OR _or(taxonoccurrence.iscultivated, "plot.**".location__cultivated__bien)))::integer AS cultivated_bien, |
| ... | ... | |
| 6800 | 6800 |
END AS "cultivatedBasis_bien", |
| 6801 | 6801 |
aggregateoccurrence.notes AS "occurrenceRemarks__@DwC__@vegpath.org", |
| 6802 | 6802 |
_fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent__@VegX__.attribute.ordinal@vegpath.org", |
| 6803 |
_m_to_cm(stemobservation.diameterbreastheight_m) AS "diameterBreastHeight_cm",
|
|
| 6804 |
stemobservation.height_m, |
|
| 6805 |
stemobservation.tag, |
|
| 6806 |
stemobservation.xposition_m AS "organismX_m",
|
|
| 6807 |
stemobservation.yposition_m AS "organismY_m",
|
|
| 6808 |
taxonoccurrence.sourceaccessioncode AS "taxonOccurrenceID",
|
|
| 6803 |
_m_to_cm(stemobservation.diameterbreastheight_m) AS "stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org",
|
|
| 6804 |
stemobservation.height_m AS "stemHeight[_m]__@VegBank__.stemCount@vegpath.org",
|
|
| 6805 |
stemobservation.tag AS "[tag=]identificationLabel__@VegX__.individual@vegpath.org",
|
|
| 6806 |
stemobservation.xposition_m AS "relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org",
|
|
| 6807 |
stemobservation.yposition_m AS "relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org",
|
|
| 6808 |
taxonoccurrence.sourceaccessioncode AS "taxonObservation[.id]__@VegBank__@vegpath.org",
|
|
| 6809 | 6809 |
taxonoccurrence.authortaxoncode AS "authorTaxonCode", |
| 6810 |
aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservationID",
|
|
| 6811 |
plantobservation.sourceaccessioncode AS "individualObservationID",
|
|
| 6812 |
plantobservation.authorplantcode AS "individualCode",
|
|
| 6810 |
aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservation.id__@VegX__@vegpath.org",
|
|
| 6811 |
plantobservation.sourceaccessioncode AS "individualOrganismObservation.id__@VegX__@vegpath.org",
|
|
| 6812 |
plantobservation.authorplantcode AS "individualID__@DwC__@vegpath.org",
|
|
| 6813 | 6813 |
aggregateoccurrence.count AS "individualCount__@DwC__@vegpath.org", |
| 6814 |
stemobservation.authorstemcode AS "stemCode__@VegBank__.stemlocation@vegpath.org"
|
|
| 6814 |
stemobservation.authorstemcode AS "stemCode__@VegBank__.stemLocation@vegpath.org"
|
|
| 6815 | 6815 |
FROM ((((((((((((((("plot.**"
|
| 6816 | 6816 |
LEFT JOIN taxonoccurrence ON ((taxonoccurrence.locationevent_id = "plot.**".locationevent__pkey))) |
| 6817 | 6817 |
LEFT JOIN party collector ON ((collector.party_id = taxonoccurrence.collector_id))) |
| ... | ... | |
| 6899 | 6899 |
|
| 6900 | 6900 |
|
| 6901 | 6901 |
-- |
| 6902 |
-- Name: COLUMN analytical_stem_view."coordinateSource_bien"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6902 |
-- Name: COLUMN analytical_stem_view."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6903 | 6903 |
-- |
| 6904 | 6904 |
|
| 6905 |
COMMENT ON COLUMN analytical_stem_view."coordinateSource_bien" IS 'derived column';
|
|
| 6905 |
COMMENT ON COLUMN analytical_stem_view."georeferenceSources__@DwC__@vegpath.org" IS 'derived column';
|
|
| 6906 | 6906 |
|
| 6907 | 6907 |
|
| 6908 | 6908 |
-- |
| 6909 |
-- Name: COLUMN analytical_stem_view."georeferenceProtocol_bien"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6909 |
-- Name: COLUMN analytical_stem_view."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6910 | 6910 |
-- |
| 6911 | 6911 |
|
| 6912 |
COMMENT ON COLUMN analytical_stem_view."georeferenceProtocol_bien" IS 'derived column';
|
|
| 6912 |
COMMENT ON COLUMN analytical_stem_view."georeferenceProtocol__@DwC__@vegpath.org" IS 'derived column';
|
|
| 6913 | 6913 |
|
| 6914 | 6914 |
|
| 6915 | 6915 |
-- |
| ... | ... | |
| 6935 | 6935 |
|
| 6936 | 6936 |
|
| 6937 | 6937 |
-- |
| 6938 |
-- Name: COLUMN analytical_stem_view.project_contributors; Type: COMMENT; Schema: public; Owner: -
|
|
| 6938 |
-- Name: COLUMN analytical_stem_view."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6939 | 6939 |
-- |
| 6940 | 6940 |
|
| 6941 |
COMMENT ON COLUMN analytical_stem_view.project_contributors IS 'variant of VegBank term';
|
|
| 6941 |
COMMENT ON COLUMN analytical_stem_view."projectContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term';
|
|
| 6942 | 6942 |
|
| 6943 | 6943 |
|
| 6944 | 6944 |
-- |
| ... | ... | |
| 6956 | 6956 |
|
| 6957 | 6957 |
|
| 6958 | 6958 |
-- |
| 6959 |
-- Name: COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 6959 |
-- Name: COLUMN analytical_stem_view."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6960 | 6960 |
-- |
| 6961 | 6961 |
|
| 6962 |
COMMENT ON COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org; |
|
| 6962 |
COMMENT ON COLUMN analytical_stem_view."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org;
|
|
| 6963 | 6963 |
"Code for subplot, line, or any other subsample or subdivision of plot"'; |
| 6964 | 6964 |
|
| 6965 | 6965 |
|
| ... | ... | |
| 6986 | 6986 |
|
| 6987 | 6987 |
|
| 6988 | 6988 |
-- |
| 6989 |
-- Name: COLUMN analytical_stem_view."elevationInMeters"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6989 |
-- Name: COLUMN analytical_stem_view."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6990 | 6990 |
-- |
| 6991 | 6991 |
|
| 6992 |
COMMENT ON COLUMN analytical_stem_view."elevationInMeters" IS 'variant of DwC term';
|
|
| 6992 |
COMMENT ON COLUMN analytical_stem_view."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 6993 | 6993 |
|
| 6994 | 6994 |
|
| 6995 | 6995 |
-- |
| 6996 |
-- Name: COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 6996 |
-- Name: COLUMN analytical_stem_view."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6997 | 6997 |
-- |
| 6998 | 6998 |
|
| 6999 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"'; |
|
| 6999 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect[_deg]__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';
|
|
| 7000 | 7000 |
|
| 7001 | 7001 |
|
| 7002 | 7002 |
-- |
| 7003 |
-- Name: COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 7003 |
-- Name: COLUMN analytical_stem_view."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7004 | 7004 |
-- |
| 7005 | 7005 |
|
| 7006 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"'; |
|
| 7006 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
|
|
| 7007 | 7007 |
|
| 7008 | 7008 |
|
| 7009 | 7009 |
-- |
| 7010 |
-- Name: COLUMN analytical_stem_view."plotArea_ha"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7010 |
-- Name: COLUMN analytical_stem_view."area[_ha]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7011 | 7011 |
-- |
| 7012 | 7012 |
|
| 7013 |
COMMENT ON COLUMN analytical_stem_view."plotArea_ha" IS 'variant of VegX term';
|
|
| 7013 |
COMMENT ON COLUMN analytical_stem_view."area[_ha]__@VegX__.plot@vegpath.org" IS 'variant of VegX term';
|
|
| 7014 | 7014 |
|
| 7015 | 7015 |
|
| 7016 | 7016 |
-- |
| ... | ... | |
| 7021 | 7021 |
|
| 7022 | 7022 |
|
| 7023 | 7023 |
-- |
| 7024 |
-- Name: COLUMN analytical_stem_view."temperature_C"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7024 |
-- Name: COLUMN analytical_stem_view."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7025 | 7025 |
-- |
| 7026 | 7026 |
|
| 7027 |
COMMENT ON COLUMN analytical_stem_view."temperature_C" IS 'variant of VegX term';
|
|
| 7027 |
COMMENT ON COLUMN analytical_stem_view."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS 'variant of VegX term';
|
|
| 7028 | 7028 |
|
| 7029 | 7029 |
|
| 7030 | 7030 |
-- |
| 7031 |
-- Name: COLUMN analytical_stem_view.precipitation_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 7031 |
-- Name: COLUMN analytical_stem_view."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7032 | 7032 |
-- |
| 7033 | 7033 |
|
| 7034 |
COMMENT ON COLUMN analytical_stem_view.precipitation_m IS 'variant of VegX term';
|
|
| 7034 |
COMMENT ON COLUMN analytical_stem_view."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS 'variant of VegX term';
|
|
| 7035 | 7035 |
|
| 7036 | 7036 |
|
| 7037 | 7037 |
-- |
| 7038 |
-- Name: COLUMN analytical_stem_view.stratum__name; Type: COMMENT; Schema: public; Owner: -
|
|
| 7038 |
-- Name: COLUMN analytical_stem_view."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7039 | 7039 |
-- |
| 7040 | 7040 |
|
| 7041 |
COMMENT ON COLUMN analytical_stem_view.stratum__name IS 'from VegX, renamed';
|
|
| 7041 |
COMMENT ON COLUMN analytical_stem_view."stratumName__@VegX__.stratum@vegpath.org" IS 'from VegX, renamed';
|
|
| 7042 | 7042 |
|
| 7043 | 7043 |
|
| 7044 | 7044 |
-- |
| 7045 |
-- Name: COLUMN analytical_stem_view.communities; Type: COMMENT; Schema: public; Owner: -
|
|
| 7045 |
-- Name: COLUMN analytical_stem_view."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7046 | 7046 |
-- |
| 7047 | 7047 |
|
| 7048 |
COMMENT ON COLUMN analytical_stem_view.communities IS 'variant of VegX term';
|
|
| 7048 |
COMMENT ON COLUMN analytical_stem_view."communityConcept.name__@VegX__.communityDet@vegpath.org" IS 'variant of VegX term';
|
|
| 7049 | 7049 |
|
| 7050 | 7050 |
|
| 7051 | 7051 |
-- |
| 7052 |
-- Name: COLUMN analytical_stem_view.plot__collectors; Type: COMMENT; Schema: public; Owner: -
|
|
| 7052 |
-- Name: COLUMN analytical_stem_view."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7053 | 7053 |
-- |
| 7054 | 7054 |
|
| 7055 |
COMMENT ON COLUMN analytical_stem_view.plot__collectors IS 'variant of VegBank term';
|
|
| 7055 |
COMMENT ON COLUMN analytical_stem_view."observationContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term';
|
|
| 7056 | 7056 |
|
| 7057 | 7057 |
|
| 7058 | 7058 |
-- |
| 7059 |
-- Name: COLUMN analytical_stem_view."specimenHolderInstitutions"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7059 |
-- Name: COLUMN analytical_stem_view."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7060 | 7060 |
-- |
| 7061 | 7061 |
|
| 7062 |
COMMENT ON COLUMN analytical_stem_view."specimenHolderInstitutions" IS 'from DwC, renamed';
|
|
| 7062 |
COMMENT ON COLUMN analytical_stem_view."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS 'from DwC, renamed';
|
|
| 7063 | 7063 |
|
| 7064 | 7064 |
|
| 7065 | 7065 |
-- |
| 7066 |
-- Name: COLUMN analytical_stem_view.collection; Type: COMMENT; Schema: public; Owner: -
|
|
| 7066 |
-- Name: COLUMN analytical_stem_view."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7067 | 7067 |
-- |
| 7068 | 7068 |
|
| 7069 |
COMMENT ON COLUMN analytical_stem_view.collection IS 'from DwC, renamed';
|
|
| 7069 |
COMMENT ON COLUMN analytical_stem_view."collectionCode__@DwC__@vegpath.org" IS 'from DwC, renamed';
|
|
| 7070 | 7070 |
|
| 7071 | 7071 |
|
| 7072 | 7072 |
-- |
| 7073 |
-- Name: COLUMN analytical_stem_view."accessionNumber"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7073 |
-- Name: COLUMN analytical_stem_view."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7074 | 7074 |
-- |
| 7075 | 7075 |
|
| 7076 |
COMMENT ON COLUMN analytical_stem_view."accessionNumber" IS 'variant of DwC term';
|
|
| 7076 |
COMMENT ON COLUMN analytical_stem_view."catalogNumber__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 7077 | 7077 |
|
| 7078 | 7078 |
|
| 7079 | 7079 |
-- |
| ... | ... | |
| 7098 | 7098 |
|
| 7099 | 7099 |
|
| 7100 | 7100 |
-- |
| 7101 |
-- Name: COLUMN analytical_stem_view."dateCollected"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7101 |
-- Name: COLUMN analytical_stem_view."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7102 | 7102 |
-- |
| 7103 | 7103 |
|
| 7104 |
COMMENT ON COLUMN analytical_stem_view."dateCollected" IS 'variant of DwC term';
|
|
| 7104 |
COMMENT ON COLUMN analytical_stem_view."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'variant of DwC term';
|
|
| 7105 | 7105 |
|
| 7106 | 7106 |
|
| 7107 | 7107 |
-- |
| 7108 |
-- Name: COLUMN analytical_stem_view.family_verbatim; Type: COMMENT; Schema: public; Owner: -
|
|
| 7108 |
-- Name: COLUMN analytical_stem_view."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7109 | 7109 |
-- |
| 7110 | 7110 |
|
| 7111 |
COMMENT ON COLUMN analytical_stem_view.family_verbatim IS 'variant of DwC term';
|
|
| 7111 |
COMMENT ON COLUMN analytical_stem_view."[verbatim_]family__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 7112 | 7112 |
|
| 7113 | 7113 |
|
| 7114 | 7114 |
-- |
| 7115 |
-- Name: COLUMN analytical_stem_view."scientificName_verbatim"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7115 |
-- Name: COLUMN analytical_stem_view."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7116 | 7116 |
-- |
| 7117 | 7117 |
|
| 7118 |
COMMENT ON COLUMN analytical_stem_view."scientificName_verbatim" IS 'variant of DwC term';
|
|
| 7118 |
COMMENT ON COLUMN analytical_stem_view."[verbatim_]scientificName__@DwC__@vegpath.org" IS 'variant of DwC term';
|
|
| 7119 | 7119 |
|
| 7120 | 7120 |
|
| 7121 | 7121 |
-- |
| ... | ... | |
| 7148 | 7148 |
|
| 7149 | 7149 |
|
| 7150 | 7150 |
-- |
| 7151 |
-- Name: COLUMN analytical_stem_view."taxonName_matched"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7151 |
-- Name: COLUMN analytical_stem_view."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7152 | 7152 |
-- |
| 7153 | 7153 |
|
| 7154 |
COMMENT ON COLUMN analytical_stem_view."taxonName_matched" IS 'from TNRS, renamed';
|
|
| 7154 |
COMMENT ON COLUMN analytical_stem_view."Name_matched__@TNRS__@vegpath.org" IS 'from TNRS, renamed';
|
|
| 7155 | 7155 |
|
| 7156 | 7156 |
|
| 7157 | 7157 |
-- |
| 7158 |
-- Name: COLUMN analytical_stem_view."scientificNameAuthorship_matched"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7158 |
-- Name: COLUMN analytical_stem_view."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7159 | 7159 |
-- |
| 7160 | 7160 |
|
| 7161 |
COMMENT ON COLUMN analytical_stem_view."scientificNameAuthorship_matched" IS 'from TNRS, renamed';
|
|
| 7161 |
COMMENT ON COLUMN analytical_stem_view."Name_matched_author__@TNRS__@vegpath.org" IS 'from TNRS, renamed';
|
|
| 7162 | 7162 |
|
| 7163 | 7163 |
|
| 7164 | 7164 |
-- |
| 7165 |
-- Name: COLUMN analytical_stem_view."higherPlantGroup_bien"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7165 |
-- Name: COLUMN analytical_stem_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7166 | 7166 |
-- |
| 7167 | 7167 |
|
| 7168 |
COMMENT ON COLUMN analytical_stem_view."higherPlantGroup_bien" IS 'derived column';
|
|
| 7168 |
COMMENT ON COLUMN analytical_stem_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'derived column';
|
|
| 7169 | 7169 |
|
| 7170 | 7170 |
|
| 7171 | 7171 |
-- |
| 7172 |
-- Name: COLUMN analytical_stem_view.taxonomic_status; Type: COMMENT; Schema: public; Owner: -
|
|
| 7172 |
-- Name: COLUMN analytical_stem_view."taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7173 | 7173 |
-- |
| 7174 | 7174 |
|
| 7175 |
COMMENT ON COLUMN analytical_stem_view.taxonomic_status IS 'from DwC, renamed';
|
|
| 7175 |
COMMENT ON COLUMN analytical_stem_view."taxonomicStatus__@DwC__@vegpath.org" IS 'from DwC, renamed';
|
|
| 7176 | 7176 |
|
| 7177 | 7177 |
|
| 7178 | 7178 |
-- |
| ... | ... | |
| 7233 | 7233 |
|
| 7234 | 7234 |
|
| 7235 | 7235 |
-- |
| 7236 |
-- Name: COLUMN analytical_stem_view."growthForm"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7236 |
-- Name: COLUMN analytical_stem_view."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7237 | 7237 |
-- |
| 7238 | 7238 |
|
| 7239 |
COMMENT ON COLUMN analytical_stem_view."growthForm" IS 'from SALVIAS, renamed';
|
|
| 7239 |
COMMENT ON COLUMN analytical_stem_view."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS 'from SALVIAS, renamed';
|
|
| 7240 | 7240 |
|
| 7241 | 7241 |
|
| 7242 | 7242 |
-- |
| ... | ... | |
| 7282 | 7282 |
|
| 7283 | 7283 |
|
| 7284 | 7284 |
-- |
| 7285 |
-- Name: COLUMN analytical_stem_view."diameterBreastHeight_cm"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7285 |
-- Name: COLUMN analytical_stem_view."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7286 | 7286 |
-- |
| 7287 | 7287 |
|
| 7288 |
COMMENT ON COLUMN analytical_stem_view."diameterBreastHeight_cm" IS 'from SALVIAS, renamed';
|
|
| 7288 |
COMMENT ON COLUMN analytical_stem_view."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS 'from SALVIAS, renamed';
|
|
| 7289 | 7289 |
|
| 7290 | 7290 |
|
| 7291 | 7291 |
-- |
| 7292 |
-- Name: COLUMN analytical_stem_view.height_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 7292 |
-- Name: COLUMN analytical_stem_view."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7293 | 7293 |
-- |
| 7294 | 7294 |
|
| 7295 |
COMMENT ON COLUMN analytical_stem_view.height_m IS 'variant of VegX term';
|
|
| 7295 |
COMMENT ON COLUMN analytical_stem_view."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS 'variant of VegX term';
|
|
| 7296 | 7296 |
|
| 7297 | 7297 |
|
| 7298 | 7298 |
-- |
| 7299 |
-- Name: COLUMN analytical_stem_view.tag; Type: COMMENT; Schema: public; Owner: -
|
|
| 7299 |
-- Name: COLUMN analytical_stem_view."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7300 | 7300 |
-- |
| 7301 | 7301 |
|
| 7302 |
COMMENT ON COLUMN analytical_stem_view.tag IS 'from VegX, renamed';
|
|
| 7302 |
COMMENT ON COLUMN analytical_stem_view."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS 'from VegX, renamed';
|
|
| 7303 | 7303 |
|
| 7304 | 7304 |
|
| 7305 | 7305 |
-- |
| 7306 |
-- Name: COLUMN analytical_stem_view."organismX_m"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7306 |
-- Name: COLUMN analytical_stem_view."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7307 | 7307 |
-- |
| 7308 | 7308 |
|
| 7309 |
COMMENT ON COLUMN analytical_stem_view."organismX_m" IS 'variant of VegX term';
|
|
| 7309 |
COMMENT ON COLUMN analytical_stem_view."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS 'variant of VegX term';
|
|
| 7310 | 7310 |
|
| 7311 | 7311 |
|
| 7312 | 7312 |
-- |
| 7313 |
-- Name: COLUMN analytical_stem_view."organismY_m"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7313 |
-- Name: COLUMN analytical_stem_view."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7314 | 7314 |
-- |
| 7315 | 7315 |
|
| 7316 |
COMMENT ON COLUMN analytical_stem_view."organismY_m" IS 'variant of VegX term';
|
|
| 7316 |
COMMENT ON COLUMN analytical_stem_view."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS 'variant of VegX term';
|
|
| 7317 | 7317 |
|
| 7318 | 7318 |
|
| 7319 | 7319 |
-- |
| 7320 |
-- Name: COLUMN analytical_stem_view."taxonOccurrenceID"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7320 |
-- Name: COLUMN analytical_stem_view."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7321 | 7321 |
-- |
| 7322 | 7322 |
|
| 7323 |
COMMENT ON COLUMN analytical_stem_view."taxonOccurrenceID" IS 'from VegX, renamed';
|
|
| 7323 |
COMMENT ON COLUMN analytical_stem_view."taxonObservation[.id]__@VegBank__@vegpath.org" IS 'from VegX, renamed';
|
|
| 7324 | 7324 |
|
| 7325 | 7325 |
|
| 7326 | 7326 |
-- |
| ... | ... | |
| 7331 | 7331 |
|
| 7332 | 7332 |
|
| 7333 | 7333 |
-- |
| 7334 |
-- Name: COLUMN analytical_stem_view."aggregateOrganismObservationID"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7334 |
-- Name: COLUMN analytical_stem_view."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7335 | 7335 |
-- |
| 7336 | 7336 |
|
| 7337 |
COMMENT ON COLUMN analytical_stem_view."aggregateOrganismObservationID" IS 'from VegX, renamed';
|
|
| 7337 |
COMMENT ON COLUMN analytical_stem_view."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'from VegX, renamed';
|
|
| 7338 | 7338 |
|
| 7339 | 7339 |
|
| 7340 | 7340 |
-- |
| 7341 |
-- Name: COLUMN analytical_stem_view."individualObservationID"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7341 |
-- Name: COLUMN analytical_stem_view."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7342 | 7342 |
-- |
| 7343 | 7343 |
|
| 7344 |
COMMENT ON COLUMN analytical_stem_view."individualObservationID" IS 'from VegX, renamed';
|
|
| 7344 |
COMMENT ON COLUMN analytical_stem_view."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'from VegX, renamed';
|
|
| 7345 | 7345 |
|
| 7346 | 7346 |
|
| 7347 | 7347 |
-- |
| 7348 |
-- Name: COLUMN analytical_stem_view."individualCode"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7348 |
-- Name: COLUMN analytical_stem_view."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7349 | 7349 |
-- |
| 7350 | 7350 |
|
| 7351 |
COMMENT ON COLUMN analytical_stem_view."individualCode" IS 'from SALVIAS, renamed';
|
|
| 7351 |
COMMENT ON COLUMN analytical_stem_view."individualID__@DwC__@vegpath.org" IS 'from SALVIAS, renamed';
|
|
| 7352 | 7352 |
|
| 7353 | 7353 |
|
| 7354 | 7354 |
-- |
| ... | ... | |
| 7359 | 7359 |
|
| 7360 | 7360 |
|
| 7361 | 7361 |
-- |
| 7362 |
-- Name: COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7362 |
-- Name: COLUMN analytical_stem_view."stemCode__@VegBank__.stemLocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7363 | 7363 |
-- |
| 7364 | 7364 |
|
| 7365 |
COMMENT ON COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
|
|
| 7365 |
COMMENT ON COLUMN analytical_stem_view."stemCode__@VegBank__.stemLocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
|
|
| 7366 | 7366 |
"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."'; |
| 7367 | 7367 |
|
| 7368 | 7368 |
|
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