Project

General

Profile

« Previous | Next » 

Revision 13728

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

View differences:

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