Project

General

Profile

« Previous | Next » 

Revision 14463

schemas/public_.sql: removed no longer used analytical_stem. use analytical_stem_view or viewFullOccurrence_individual instead.

View differences:

trunk/schemas/vegbien.my.sql
5296 5296

  
5297 5297

  
5298 5298
--
5299
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: 
5300
--
5301

  
5302
CREATE TABLE analytical_stem (
5303
    `datasource__@Brad__.identifier_examples@vegpath.org` varchar(255) NOT NULL,
5304
    `country__@DwC__@vegpath.org` varchar(255),
5305
    `stateProvince__@DwC__@vegpath.org` varchar(255),
5306
    `county__@DwC__@vegpath.org` varchar(255),
5307
    `locality__@DwC__@vegpath.org` varchar(255),
5308
    `decimalLatitude__@DwC__@vegpath.org` double,
5309
    `decimalLongitude__@DwC__@vegpath.org` double,
5310
    `coordinateUncertaintyInMeters__@DwC__@vegpath.org` double,
5311
    `georeferenceSources__@DwC__@vegpath.org` coordinatesource,
5312
    `georeferenceProtocol__@DwC__@vegpath.org` varchar(255),
5313
    geovalid_bien int(11),
5314
    `isNewWorld_bien` int(11),
5315
    `projectID__@VegX__.plotObservation@vegpath.org` varchar(255),
5316
    `projectContributor[s]__@VegBank__@vegpath.org` varchar(255),
5317
    `locationID__@DwC__@vegpath.org` varchar(255) NOT NULL,
5318
    `plotName__@VegX__.plot@vegpath.org` varchar(255),
5319
    `subplot__@SALVIAS__.Plot_data@vegpath.org` varchar(255),
5320
    location__cultivated__bien int(1),
5321
    `locationevent.locationevent_id__@VegBIEN__.public@vegpath.org` int(11),
5322
    `eventDate__@DwC__@vegpath.org` date,
5323
    `(-minimum-)ElevationInMeters__@DwC__@vegpath.org` double,
5324
    `slopeAspect[_deg]__@VegX__.plot@vegpath.org` double,
5325
    `slopeGradient[_deg]__@VegX__.plot@vegpath.org` double,
5326
    `plot.area[_ha]__@VegX__@vegpath.org` double,
5327
    `samplingProtocol__@DwC__@vegpath.org` varchar(255),
5328
    `temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org` double,
5329
    `precip_mm__@SALVIAS__.Plot_metadata@vegpath.org` double,
5330
    `stratumName__@VegX__.stratum@vegpath.org` varchar(255),
5331
    `communityConcept.name__@VegX__.communityDet@vegpath.org` varchar(255),
5332
    `observationContributor[s]__@VegBank__@vegpath.org` varchar(255),
5333
    `[custodial_]institutionCode[s]__@DwC__@vegpath.org` varchar(255),
5334
    `collectionCode__@DwC__@vegpath.org` varchar(255),
5335
    `catalogNumber__@DwC__@vegpath.org` varchar(255),
5336
    `occurrenceID__@DwC__@vegpath.org` varchar(255),
5337
    `recordedBy__@DwC__@vegpath.org` varchar(255),
5338
    `recordNumber__@DwC__@vegpath.org` varchar(255),
5339
    `(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org` date,
5340
    `[verbatim_]family__@DwC__@vegpath.org` varchar(255),
5341
    `[verbatim_]scientificName__@DwC__@vegpath.org` varchar(255),
5342
    `identifiedBy__@DwC__@vegpath.org` varchar(255),
5343
    `dateIdentified__@DwC__@vegpath.org` date,
5344
    `identificationRemarks__@DwC__@vegpath.org` varchar(255),
5345
    `Family_matched__@TNRS__@vegpath.org` varchar(255),
5346
    `Name_matched__@TNRS__@vegpath.org` varchar(255),
5347
    `Name_matched_author__@TNRS__@vegpath.org` varchar(255),
5348
    `[higher_plant_group~]higherClassification__@DwC__@vegpath.org` higher_plant_group,
5349
    `taxonomicStatus__@DwC__@vegpath.org` varchar(255),
5350
    scrubbed_family varchar(255),
5351
    scrubbed_genus varchar(255),
5352
    scrubbed_specific_epithet varchar(255),
5353
    scrubbed_species_binomial varchar(255),
5354
    scrubbed_taxon_name_no_author varchar(255),
5355
    scrubbed_author varchar(255),
5356
    scrubbed_taxon_name_with_author varchar(255),
5357
    `speciesBinomialWithMorphospecies__@VegCore__@vegpath.org` varchar(255),
5358
    `[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org` growthform,
5359
    `reproductiveCondition__@DwC__@vegpath.org` varchar(255),
5360
    cultivated_bien int(11),
5361
    `cultivatedBasis_bien` varchar(255),
5362
    `occurrenceRemarks__@DwC__@vegpath.org` varchar(255),
5363
    `coverPercent__@VegX__.attribute.ordinal@vegpath.org` double,
5364
    `taxonObservation[.id]__@VegBank__@vegpath.org` varchar(255),
5365
    `taxonNameUsageConcept.authorCode__@VegX__@vegpath.org` varchar(255),
5366
    `aggregateOrganismObservation.id__@VegX__@vegpath.org` varchar(255),
5367
    `individualOrganismObservation.id__@VegX__@vegpath.org` varchar(255),
5368
    `individualID__@DwC__@vegpath.org` varchar(255),
5369
    `individualCount__@DwC__@vegpath.org` int(11),
5370
    `plantobservation.``_id__@VegBIEN__.public@vegpath.org` int(11),
5371
    `stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org` double,
5372
    `stemHeight[_m]__@VegBank__.stemCount@vegpath.org` double,
5373
    `[tag=]identificationLabel__@VegX__.individual@vegpath.org` varchar(255),
5374
    `relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org` double,
5375
    `relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org` double,
5376
    `stemCode__@VegBank__.stemLocation@vegpath.org` varchar(255),
5377
    `TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org` int(11) NOT NULL
5378
);
5379

  
5380

  
5381
--
5382
-- Name: COLUMN analytical_stem.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5383
--
5384

  
5385

  
5386

  
5387

  
5388
--
5389
-- Name: COLUMN analytical_stem.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5390
--
5391

  
5392

  
5393

  
5394

  
5395
--
5396
-- Name: COLUMN analytical_stem.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5397
--
5398

  
5399

  
5400

  
5401

  
5402
--
5403
-- Name: COLUMN analytical_stem.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5404
--
5405

  
5406

  
5407

  
5408

  
5409
--
5410
-- Name: COLUMN analytical_stem.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5411
--
5412

  
5413

  
5414

  
5415

  
5416
--
5417
-- Name: COLUMN analytical_stem.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5418
--
5419

  
5420

  
5421

  
5422

  
5423
--
5424
-- Name: COLUMN analytical_stem.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5425
--
5426

  
5427

  
5428

  
5429

  
5430
--
5431
-- Name: COLUMN analytical_stem.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5432
--
5433

  
5434

  
5435

  
5436

  
5437
--
5438
-- Name: COLUMN analytical_stem.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5439
--
5440

  
5441

  
5442

  
5443

  
5444
--
5445
-- Name: COLUMN analytical_stem.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5446
--
5447

  
5448

  
5449

  
5450

  
5451
--
5452
-- Name: COLUMN analytical_stem.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
5453
--
5454

  
5455

  
5456

  
5457

  
5458
--
5459
-- Name: COLUMN analytical_stem.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
5460
--
5461

  
5462

  
5463

  
5464

  
5465
--
5466
-- Name: COLUMN analytical_stem.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5467
--
5468

  
5469

  
5470

  
5471

  
5472
--
5473
-- Name: COLUMN analytical_stem.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5474
--
5475

  
5476

  
5477

  
5478

  
5479
--
5480
-- Name: COLUMN analytical_stem.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5481
--
5482

  
5483

  
5484

  
5485

  
5486
--
5487
-- Name: COLUMN analytical_stem.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5488
--
5489

  
5490

  
5491

  
5492

  
5493
--
5494
-- Name: COLUMN analytical_stem.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5495
--
5496

  
5497

  
5498

  
5499

  
5500
--
5501
-- Name: COLUMN analytical_stem.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
5502
--
5503

  
5504

  
5505

  
5506

  
5507
--
5508
-- Name: COLUMN analytical_stem.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5509
--
5510

  
5511

  
5512

  
5513

  
5514
--
5515
-- Name: COLUMN analytical_stem.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5516
--
5517

  
5518

  
5519

  
5520

  
5521
--
5522
-- Name: COLUMN analytical_stem.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5523
--
5524

  
5525

  
5526

  
5527

  
5528
--
5529
-- Name: COLUMN analytical_stem.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5530
--
5531

  
5532

  
5533

  
5534

  
5535
--
5536
-- Name: COLUMN analytical_stem.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5537
--
5538

  
5539

  
5540

  
5541

  
5542
--
5543
-- Name: COLUMN analytical_stem.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5544
--
5545

  
5546

  
5547

  
5548

  
5549
--
5550
-- Name: COLUMN analytical_stem.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5551
--
5552

  
5553

  
5554

  
5555

  
5556
--
5557
-- Name: COLUMN analytical_stem.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5558
--
5559

  
5560

  
5561

  
5562

  
5563
--
5564
-- Name: COLUMN analytical_stem.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5565
--
5566

  
5567

  
5568

  
5569

  
5570
--
5571
-- Name: COLUMN analytical_stem.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5572
--
5573

  
5574

  
5575

  
5576

  
5577
--
5578
-- Name: COLUMN analytical_stem.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5579
--
5580

  
5581

  
5582

  
5583

  
5584
--
5585
-- Name: COLUMN analytical_stem.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5586
--
5587

  
5588

  
5589

  
5590

  
5591
--
5592
-- Name: COLUMN analytical_stem.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5593
--
5594

  
5595

  
5596

  
5597

  
5598
--
5599
-- Name: COLUMN analytical_stem.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5600
--
5601

  
5602

  
5603

  
5604

  
5605
--
5606
-- Name: COLUMN analytical_stem.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5607
--
5608

  
5609

  
5610

  
5611

  
5612
--
5613
-- Name: COLUMN analytical_stem.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5614
--
5615

  
5616

  
5617

  
5618

  
5619
--
5620
-- Name: COLUMN analytical_stem.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5621
--
5622

  
5623

  
5624

  
5625

  
5626
--
5627
-- Name: COLUMN analytical_stem.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5628
--
5629

  
5630

  
5631

  
5632

  
5633
--
5634
-- Name: COLUMN analytical_stem.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5635
--
5636

  
5637

  
5638

  
5639

  
5640
--
5641
-- Name: COLUMN analytical_stem.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5642
--
5643

  
5644

  
5645

  
5646

  
5647
--
5648
-- Name: COLUMN analytical_stem.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5649
--
5650

  
5651

  
5652

  
5653

  
5654
--
5655
-- Name: COLUMN analytical_stem.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5656
--
5657

  
5658

  
5659

  
5660

  
5661
--
5662
-- Name: COLUMN analytical_stem.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5663
--
5664

  
5665

  
5666

  
5667

  
5668
--
5669
-- Name: COLUMN analytical_stem.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5670
--
5671

  
5672

  
5673

  
5674

  
5675
--
5676
-- Name: COLUMN analytical_stem.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5677
--
5678

  
5679

  
5680

  
5681

  
5682
--
5683
-- Name: COLUMN analytical_stem.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5684
--
5685

  
5686

  
5687

  
5688

  
5689
--
5690
-- Name: COLUMN analytical_stem.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5691
--
5692

  
5693

  
5694

  
5695

  
5696
--
5697
-- Name: COLUMN analytical_stem.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5698
--
5699

  
5700

  
5701

  
5702

  
5703
--
5704
-- Name: COLUMN analytical_stem.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5705
--
5706

  
5707

  
5708

  
5709

  
5710
--
5711
-- Name: COLUMN analytical_stem.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
5712
--
5713

  
5714

  
5715

  
5716

  
5717
--
5718
-- Name: COLUMN analytical_stem.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
5719
--
5720

  
5721

  
5722

  
5723

  
5724
--
5725
-- Name: COLUMN analytical_stem.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
5726
--
5727

  
5728

  
5729

  
5730

  
5731
--
5732
-- Name: COLUMN analytical_stem.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
5733
--
5734

  
5735

  
5736

  
5737

  
5738
--
5739
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
5740
--
5741

  
5742

  
5743

  
5744

  
5745
--
5746
-- Name: COLUMN analytical_stem.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
5747
--
5748

  
5749

  
5750

  
5751

  
5752
--
5753
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
5754
--
5755

  
5756

  
5757

  
5758

  
5759
--
5760
-- Name: COLUMN analytical_stem.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5761
--
5762

  
5763

  
5764

  
5765

  
5766
--
5767
-- Name: COLUMN analytical_stem.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5768
--
5769

  
5770

  
5771

  
5772

  
5773
--
5774
-- Name: COLUMN analytical_stem.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5775
--
5776

  
5777

  
5778

  
5779

  
5780
--
5781
-- Name: COLUMN analytical_stem.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
5782
--
5783

  
5784

  
5785

  
5786

  
5787
--
5788
-- Name: COLUMN analytical_stem.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
5789
--
5790

  
5791

  
5792

  
5793

  
5794
--
5795
-- Name: COLUMN analytical_stem.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5796
--
5797

  
5798

  
5799

  
5800

  
5801
--
5802
-- Name: COLUMN analytical_stem.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5803
--
5804

  
5805

  
5806

  
5807

  
5808
--
5809
-- Name: COLUMN analytical_stem.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5810
--
5811

  
5812

  
5813

  
5814

  
5815
--
5816
-- Name: COLUMN analytical_stem.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5817
--
5818

  
5819

  
5820

  
5821

  
5822
--
5823
-- Name: COLUMN analytical_stem.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5824
--
5825

  
5826

  
5827

  
5828

  
5829
--
5830
-- Name: COLUMN analytical_stem.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5831
--
5832

  
5833

  
5834

  
5835

  
5836
--
5837
-- Name: COLUMN analytical_stem.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5838
--
5839

  
5840

  
5841

  
5842

  
5843
--
5844
-- Name: COLUMN analytical_stem.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5845
--
5846

  
5847

  
5848

  
5849

  
5850
--
5851
-- Name: COLUMN analytical_stem.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5852
--
5853

  
5854

  
5855

  
5856

  
5857
--
5858
-- Name: COLUMN analytical_stem.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5859
--
5860

  
5861

  
5862

  
5863

  
5864
--
5865
-- Name: COLUMN analytical_stem.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5866
--
5867

  
5868

  
5869

  
5870

  
5871
--
5872
-- Name: COLUMN analytical_stem.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5873
--
5874

  
5875

  
5876

  
5877

  
5878
--
5879
-- Name: COLUMN analytical_stem.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5880
--
5881

  
5882

  
5883

  
5884

  
5885
--
5886
-- Name: COLUMN analytical_stem.`stemCode__@VegBank__.stemLocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5887
--
5888

  
5889

  
5890

  
5891

  
5892
--
5893
-- Name: COLUMN analytical_stem.`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5894
--
5895

  
5896

  
5897

  
5898

  
5899
--
5900
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE; Schema: public; Owner: -
5901
--
5902

  
5903

  
5904

  
5905

  
5906
--
5907
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
5908
--
5909

  
5910

  
5911

  
5912

  
5913
--
5914 5299
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
5915 5300
--
5916 5301

  
......
9428 8813

  
9429 8814

  
9430 8815
--
9431
-- Name: TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org; Type: DEFAULT; Schema: public; Owner: -
9432
--
9433

  
9434

  
9435

  
9436

  
9437
--
9438 8816
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
9439 8817
--
9440 8818

  
......
9851 9229

  
9852 9230

  
9853 9231
--
9854
-- Data for Name: analytical_stem; Type: TABLE DATA; Schema: public; Owner: -
9855
--
9856

  
9857

  
9858

  
9859
--
9860
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE SET; Schema: public; Owner: -
9861
--
9862

  
9863

  
9864

  
9865
--
9866 9232
-- Data for Name: classcontributor; Type: TABLE DATA; Schema: public; Owner: -
9867 9233
--
9868 9234

  
......
12529 11895

  
12530 11896

  
12531 11897
--
12532
-- Name: analytical_stem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
12533
--
12534

  
12535
ALTER TABLE analytical_stem
12536
    ADD CONSTRAINT analytical_stem_pkey PRIMARY KEY (`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`);
12537

  
12538

  
12539
--
12540 11898
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
12541 11899
--
12542 11900

  
......
13232 12590

  
13233 12591

  
13234 12592
--
13235
-- Name: analytical_stem_datasource__@Brad__.identifier_examples@ve_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
13236
--
13237

  
13238
CREATE INDEX `analytical_stem_datasource__@Brad__.identifier_examples@ve_idx1` ON analytical_stem  (`datasource__@Brad__.identifier_examples@vegpath.org`, `[custodial_]institutionCode[s]__@DwC__@vegpath.org`, `collectionCode__@DwC__@vegpath.org`, `catalogNumber__@DwC__@vegpath.org`);
13239

  
13240

  
13241
--
13242
-- Name: analytical_stem_datasource__@Brad__.identifier_examples@ve_idx2; Type: INDEX; Schema: public; Owner: -; Tablespace: 
13243
--
13244

  
13245
CREATE INDEX `analytical_stem_datasource__@Brad__.identifier_examples@ve_idx2` ON analytical_stem  (`datasource__@Brad__.identifier_examples@vegpath.org`, `projectID__@VegX__.plotObservation@vegpath.org`, `locationID__@DwC__@vegpath.org`, `eventDate__@DwC__@vegpath.org`);
13246

  
13247

  
13248
--
13249
-- Name: analytical_stem_datasource__@Brad__.identifier_examples@veg_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
13250
--
13251

  
13252
CREATE INDEX `analytical_stem_datasource__@Brad__.identifier_examples@veg_idx` ON analytical_stem  (`datasource__@Brad__.identifier_examples@vegpath.org`, `occurrenceID__@DwC__@vegpath.org`);
13253

  
13254

  
13255
--
13256
-- Name: analytical_stem_speciesBinomialWithMorphospecies__@VegCore__idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
13257
--
13258

  
13259
CREATE INDEX `analytical_stem_speciesBinomialWithMorphospecies__@VegCore__idx` ON analytical_stem  (`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`);
13260

  
13261

  
13262
--
13263 12593
-- Name: classcontributor_commclass_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
13264 12594
--
13265 12595

  
......
15672 15002

  
15673 15003

  
15674 15004
--
15675
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: -
15676
--
15677

  
15678

  
15679

  
15680

  
15681

  
15682

  
15683

  
15684
--
15685 15005
-- Name: classcontributor; Type: ACL; Schema: public; Owner: -
15686 15006
--
15687 15007

  
trunk/schemas/public_.sql
7860 7860

  
7861 7861

  
7862 7862
--
7863
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: 
7864
--
7865

  
7866
CREATE TABLE analytical_stem (
7867
    "datasource__@Brad__.identifier_examples@vegpath.org" text NOT NULL,
7868
    "country__@DwC__@vegpath.org" text,
7869
    "stateProvince__@DwC__@vegpath.org" text,
7870
    "county__@DwC__@vegpath.org" text,
7871
    "locality__@DwC__@vegpath.org" text,
7872
    "decimalLatitude__@DwC__@vegpath.org" double precision,
7873
    "decimalLongitude__@DwC__@vegpath.org" double precision,
7874
    "coordinateUncertaintyInMeters__@DwC__@vegpath.org" double precision,
7875
    "georeferenceSources__@DwC__@vegpath.org" coordinatesource,
7876
    "georeferenceProtocol__@DwC__@vegpath.org" text,
7877
    geovalid_bien integer,
7878
    "isNewWorld_bien" integer,
7879
    "projectID__@VegX__.plotObservation@vegpath.org" text,
7880
    "projectContributor[s]__@VegBank__@vegpath.org" text[],
7881
    "locationID__@DwC__@vegpath.org" text NOT NULL,
7882
    "plotName__@VegX__.plot@vegpath.org" text,
7883
    "subplot__@SALVIAS__.Plot_data@vegpath.org" text,
7884
    location__cultivated__bien boolean,
7885
    "locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" integer,
7886
    "eventDate__@DwC__@vegpath.org" date,
7887
    "(-minimum-)ElevationInMeters__@DwC__@vegpath.org" double precision,
7888
    "slopeAspect[_deg]__@VegX__.plot@vegpath.org" double precision,
7889
    "slopeGradient[_deg]__@VegX__.plot@vegpath.org" double precision,
7890
    "plot.area[_ha]__@VegX__@vegpath.org" double precision,
7891
    "samplingProtocol__@DwC__@vegpath.org" text,
7892
    "temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" double precision,
7893
    "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" double precision,
7894
    "stratumName__@VegX__.stratum@vegpath.org" text,
7895
    "communityConcept.name__@VegX__.communityDet@vegpath.org" text[],
7896
    "observationContributor[s]__@VegBank__@vegpath.org" text[],
7897
    "[custodial_]institutionCode[s]__@DwC__@vegpath.org" text,
7898
    "collectionCode__@DwC__@vegpath.org" text,
7899
    "catalogNumber__@DwC__@vegpath.org" text,
7900
    "occurrenceID__@DwC__@vegpath.org" text,
7901
    "recordedBy__@DwC__@vegpath.org" text,
7902
    "recordNumber__@DwC__@vegpath.org" text,
7903
    "(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" date,
7904
    "[verbatim_]family__@DwC__@vegpath.org" text,
7905
    "[verbatim_]scientificName__@DwC__@vegpath.org" text,
7906
    "identifiedBy__@DwC__@vegpath.org" text,
7907
    "dateIdentified__@DwC__@vegpath.org" date,
7908
    "identificationRemarks__@DwC__@vegpath.org" text,
7909
    "Family_matched__@TNRS__@vegpath.org" text,
7910
    "Name_matched__@TNRS__@vegpath.org" text,
7911
    "Name_matched_author__@TNRS__@vegpath.org" text,
7912
    "[higher_plant_group~]higherClassification__@DwC__@vegpath.org" higher_plant_group,
7913
    "taxonomicStatus__@DwC__@vegpath.org" text,
7914
    scrubbed_family text,
7915
    scrubbed_genus text,
7916
    scrubbed_specific_epithet text,
7917
    scrubbed_species_binomial text,
7918
    scrubbed_taxon_name_no_author text,
7919
    scrubbed_author text,
7920
    scrubbed_taxon_name_with_author text,
7921
    "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" text,
7922
    "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" growthform,
7923
    "reproductiveCondition__@DwC__@vegpath.org" text,
7924
    cultivated_bien integer,
7925
    "cultivatedBasis_bien" text,
7926
    "occurrenceRemarks__@DwC__@vegpath.org" text,
7927
    "coverPercent__@VegX__.attribute.ordinal@vegpath.org" double precision,
7928
    "taxonObservation[.id]__@VegBank__@vegpath.org" text,
7929
    "taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" text,
7930
    "aggregateOrganismObservation.id__@VegX__@vegpath.org" text,
7931
    "individualOrganismObservation.id__@VegX__@vegpath.org" text,
7932
    "individualID__@DwC__@vegpath.org" text,
7933
    "individualCount__@DwC__@vegpath.org" integer,
7934
    "plantobservation.""_id__@VegBIEN__.public@vegpath.org" integer,
7935
    "stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" double precision,
7936
    "stemHeight[_m]__@VegBank__.stemCount@vegpath.org" double precision,
7937
    "[tag=]identificationLabel__@VegX__.individual@vegpath.org" text,
7938
    "relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" double precision,
7939
    "relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" double precision,
7940
    "stemCode__@VegBank__.stemLocation@vegpath.org" text,
7941
    "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" integer NOT NULL
7942
);
7943

  
7944

  
7945
--
7946
-- Name: COLUMN analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
7947
--
7948

  
7949
COMMENT ON COLUMN analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org" IS '"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';
7950

  
7951

  
7952
--
7953
-- Name: COLUMN analytical_stem."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
7954
--
7955

  
7956
COMMENT ON COLUMN analytical_stem."country__@DwC__@vegpath.org" IS 'http://geoscrub.geoscrub_output.acceptedCountry__@VegBIEN__@vegpath.org;
7957
"The name of the country or major administrative unit in which the Location occurs"';
7958

  
7959

  
7960
--
7961
-- Name: COLUMN analytical_stem."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
7962
--
7963

  
7964
COMMENT ON COLUMN analytical_stem."stateProvince__@DwC__@vegpath.org" IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"';
7965

  
7966

  
7967
--
7968
-- Name: COLUMN analytical_stem."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
7969
--
7970

  
7971
COMMENT ON COLUMN analytical_stem."county__@DwC__@vegpath.org" IS '"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"';
7972

  
7973

  
7974
--
7975
-- Name: COLUMN analytical_stem."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
7976
--
7977

  
7978
COMMENT ON COLUMN analytical_stem."locality__@DwC__@vegpath.org" IS '"The specific description of the place"';
7979

  
7980

  
7981
--
7982
-- Name: COLUMN analytical_stem."decimalLatitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
7983
--
7984

  
7985
COMMENT ON COLUMN analytical_stem."decimalLatitude__@DwC__@vegpath.org" IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
7986

  
7987

  
7988
--
7989
-- Name: COLUMN analytical_stem."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
7990
--
7991

  
7992
COMMENT ON COLUMN analytical_stem."decimalLongitude__@DwC__@vegpath.org" IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
7993

  
7994

  
7995
--
7996
-- Name: COLUMN analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
7997
--
7998

  
7999
COMMENT ON COLUMN analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS 'for a point observation, this is the fuzziness of the coordinates. for a plot (or other shape), this is the radius of the circle that circumscribes the entire plot, or the fuzziness, whichever is greater. note that the DwC definition is confusingly worded: it uses the ambiguous term Location, which sometimes refers to the asserted named place, but which they intended to refer to the plot or point.';
8000

  
8001

  
8002
--
8003
-- Name: COLUMN analytical_stem."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8004
--
8005

  
8006
COMMENT ON COLUMN analytical_stem."georeferenceSources__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of maps, gazetteers, or other resources used to georeference the Location, described specifically enough to allow anyone in the future to use the same resources"';
8007

  
8008

  
8009
--
8010
-- Name: COLUMN analytical_stem."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8011
--
8012

  
8013
COMMENT ON COLUMN analytical_stem."georeferenceProtocol__@DwC__@vegpath.org" IS '"A description or reference to the methods used to determine the spatial footprint, coordinates, and uncertainties"';
8014

  
8015

  
8016
--
8017
-- Name: COLUMN analytical_stem.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
8018
--
8019

  
8020
COMMENT ON COLUMN analytical_stem.geovalid_bien IS 'whether the coordinates are within the boundary of the asserted named places';
8021

  
8022

  
8023
--
8024
-- Name: COLUMN analytical_stem."isNewWorld_bien"; Type: COMMENT; Schema: public; Owner: -
8025
--
8026

  
8027
COMMENT ON COLUMN analytical_stem."isNewWorld_bien" IS 'whether the country is in the Americas';
8028

  
8029

  
8030
--
8031
-- Name: COLUMN analytical_stem."projectID__@VegX__.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8032
--
8033

  
8034
COMMENT ON COLUMN analytical_stem."projectID__@VegX__.plotObservation@vegpath.org" IS 'http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;
8035
"A reference to a specific ''project''"';
8036

  
8037

  
8038
--
8039
-- Name: COLUMN analytical_stem."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8040
--
8041

  
8042
COMMENT ON COLUMN analytical_stem."projectContributor[s]__@VegBank__@vegpath.org" IS '"intersection entit[ies] used to ''link'' a party with a specific project wherein vegetation plots are described"';
8043

  
8044

  
8045
--
8046
-- Name: COLUMN analytical_stem."locationID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8047
--
8048

  
8049
COMMENT ON COLUMN analytical_stem."locationID__@DwC__@vegpath.org" IS '"An identifier for the set of location information (data associated with dcterms:Location)"';
8050

  
8051

  
8052
--
8053
-- Name: COLUMN analytical_stem."plotName__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8054
--
8055

  
8056
COMMENT ON COLUMN analytical_stem."plotName__@VegX__.plot@vegpath.org" IS '"Name or label for a plot"';
8057

  
8058

  
8059
--
8060
-- Name: COLUMN analytical_stem."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8061
--
8062

  
8063
COMMENT ON COLUMN analytical_stem."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'http://location.authorlocationcode__@VegBIEN__.public@vegpath.org;
8064
"Code for subplot, line, or any other subsample or subdivision of plot"';
8065

  
8066

  
8067
--
8068
-- Name: COLUMN analytical_stem.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
8069
--
8070

  
8071
COMMENT ON COLUMN analytical_stem.location__cultivated__bien IS 'whether the occurrence''s *location* was flagged as cultivated. note that this refers just to the cultivated status of the *location*; the occurrence may be cultivated even if the location isn''t.';
8072

  
8073

  
8074
--
8075
-- Name: COLUMN analytical_stem."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8076
--
8077

  
8078
COMMENT ON COLUMN analytical_stem."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'http://locationevent.locationevent_id__@VegBIEN__.public@vegpath.org;
8079
autogenerated ID for locationevent';
8080

  
8081

  
8082
--
8083
-- Name: COLUMN analytical_stem."eventDate__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8084
--
8085

  
8086
COMMENT ON COLUMN analytical_stem."eventDate__@DwC__@vegpath.org" IS '"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."';
8087

  
8088

  
8089
--
8090
-- Name: COLUMN analytical_stem."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8091
--
8092

  
8093
COMMENT ON COLUMN analytical_stem."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'the "elevation (altitude, usually above sea level), in meters"';
8094

  
8095

  
8096
--
8097
-- Name: COLUMN analytical_stem."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8098
--
8099

  
8100
COMMENT ON COLUMN analytical_stem."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)"';
8101

  
8102

  
8103
--
8104
-- Name: COLUMN analytical_stem."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8105
--
8106

  
8107
COMMENT ON COLUMN analytical_stem."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
8108

  
8109

  
8110
--
8111
-- Name: COLUMN analytical_stem."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8112
--
8113

  
8114
COMMENT ON COLUMN analytical_stem."plot.area[_ha]__@VegX__@vegpath.org" IS '"Total area of the plot"';
8115

  
8116

  
8117
--
8118
-- Name: COLUMN analytical_stem."samplingProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8119
--
8120

  
8121
COMMENT ON COLUMN analytical_stem."samplingProtocol__@DwC__@vegpath.org" IS '"The name of, reference to, or description of the method or protocol used during an Event"';
8122

  
8123

  
8124
--
8125
-- Name: COLUMN analytical_stem."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8126
--
8127

  
8128
COMMENT ON COLUMN analytical_stem."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS '"Temperature during observation [...] [in] Celsius"';
8129

  
8130

  
8131
--
8132
-- Name: COLUMN analytical_stem."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8133
--
8134

  
8135
COMMENT ON COLUMN analytical_stem."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS '"Total annual precipitation, in mm"';
8136

  
8137

  
8138
--
8139
-- Name: COLUMN analytical_stem."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8140
--
8141

  
8142
COMMENT ON COLUMN analytical_stem."stratumName__@VegX__.stratum@vegpath.org" IS '"Name associated with this stratum"';
8143

  
8144

  
8145
--
8146
-- Name: COLUMN analytical_stem."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8147
--
8148

  
8149
COMMENT ON COLUMN analytical_stem."communityConcept.name__@VegX__.communityDet@vegpath.org" IS '"A textual label for a community type. A community type is an abstract grouping of organisms that tend to co-occur on the landscape due to shared ecological requirements or preferences."';
8150

  
8151

  
8152
--
8153
-- Name: COLUMN analytical_stem."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8154
--
8155

  
8156
COMMENT ON COLUMN analytical_stem."observationContributor[s]__@VegBank__@vegpath.org" IS '"intersection[s] that link[] a party with a specific plot observation event"';
8157

  
8158

  
8159
--
8160
-- Name: COLUMN analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8161
--
8162

  
8163
COMMENT ON COLUMN analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS '"The name[s] (or acronym[s]) in use by the institution[s] having custody of the object(s) or information referred to in the record"';
8164

  
8165

  
8166
--
8167
-- Name: COLUMN analytical_stem."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8168
--
8169

  
8170
COMMENT ON COLUMN analytical_stem."collectionCode__@DwC__@vegpath.org" IS '"The name, acronym, coden, or initialism identifying the collection or data set from which the record was derived"';
8171

  
8172

  
8173
--
8174
-- Name: COLUMN analytical_stem."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8175
--
8176

  
8177
COMMENT ON COLUMN analytical_stem."catalogNumber__@DwC__@vegpath.org" IS '"An identifier (preferably unique) for the record within the data set or collection"';
8178

  
8179

  
8180
--
8181
-- Name: COLUMN analytical_stem."occurrenceID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8182
--
8183

  
8184
COMMENT ON COLUMN analytical_stem."occurrenceID__@DwC__@vegpath.org" IS '"An identifier for the Occurrence (as opposed to a particular digital record of the occurrence). In the absence of a persistent global unique identifier, construct one from a combination of identifiers in the record that will most closely make the occurrenceID globally unique."';
8185

  
8186

  
8187
--
8188
-- Name: COLUMN analytical_stem."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8189
--
8190

  
8191
COMMENT ON COLUMN analytical_stem."recordedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."';
8192

  
8193

  
8194
--
8195
-- Name: COLUMN analytical_stem."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8196
--
8197

  
8198
COMMENT ON COLUMN analytical_stem."recordNumber__@DwC__@vegpath.org" IS '"An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector''s number."';
8199

  
8200

  
8201
--
8202
-- Name: COLUMN analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8203
--
8204

  
8205
COMMENT ON COLUMN analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'the "date-time (Common Era calendar) in a date-time period during which an organism or group of organisms was collected or observed"';
8206

  
8207

  
8208
--
8209
-- Name: COLUMN analytical_stem."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8210
--
8211

  
8212
COMMENT ON COLUMN analytical_stem."[verbatim_]family__@DwC__@vegpath.org" IS '"The full scientific name of the family in which the taxon is classified [*before* any TNRS scrubbing]"';
8213

  
8214

  
8215
--
8216
-- Name: COLUMN analytical_stem."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8217
--
8218

  
8219
COMMENT ON COLUMN analytical_stem."[verbatim_]scientificName__@DwC__@vegpath.org" IS '"The full scientific name [*before* any TNRS scrubbing], with authorship and date information if known. When forming part of an Identification, this should be the name in lowest level taxonomic rank that can be determined."';
8220

  
8221

  
8222
--
8223
-- Name: COLUMN analytical_stem."identifiedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8224
--
8225

  
8226
COMMENT ON COLUMN analytical_stem."identifiedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"';
8227

  
8228

  
8229
--
8230
-- Name: COLUMN analytical_stem."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8231
--
8232

  
8233
COMMENT ON COLUMN analytical_stem."dateIdentified__@DwC__@vegpath.org" IS '"The date on which the subject was identified as representing the Taxon"';
8234

  
8235

  
8236
--
8237
-- Name: COLUMN analytical_stem."identificationRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8238
--
8239

  
8240
COMMENT ON COLUMN analytical_stem."identificationRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Identification"';
8241

  
8242

  
8243
--
8244
-- Name: COLUMN analytical_stem."Family_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8245
--
8246

  
8247
COMMENT ON COLUMN analytical_stem."Family_matched__@TNRS__@vegpath.org" IS 'http://TNRS.taxon_scrub.matchedFamily__@VegBIEN__.public@vegpath.org;
8248
"The closest matching family in the TNRS database to the family submitted"';
8249

  
8250

  
8251
--
8252
-- Name: COLUMN analytical_stem."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8253
--
8254

  
8255
COMMENT ON COLUMN analytical_stem."Name_matched__@TNRS__@vegpath.org" IS '"Scientific name with the highest match score. May be an exact match or a fuzzy match."';
8256

  
8257

  
8258
--
8259
-- Name: COLUMN analytical_stem."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8260
--
8261

  
8262
COMMENT ON COLUMN analytical_stem."Name_matched_author__@TNRS__@vegpath.org" IS '"Standard authority for the matched name"';
8263

  
8264

  
8265
--
8266
-- Name: COLUMN analytical_stem."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8267
--
8268

  
8269
COMMENT ON COLUMN analytical_stem."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'closed list derived from higher taxa';
8270

  
8271

  
8272
--
8273
-- Name: COLUMN analytical_stem."taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8274
--
8275

  
8276
COMMENT ON COLUMN analytical_stem."taxonomicStatus__@DwC__@vegpath.org" IS '"The status of the use of the scientificName as a label for a taxon. Requires taxonomic opinion to define the scope of a taxon. [...] Examples: "invalid", "misapplied", "homotypic synonym", "accepted"."';
8277

  
8278

  
8279
--
8280
-- Name: COLUMN analytical_stem.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
8281
--
8282

  
8283
COMMENT ON COLUMN analytical_stem.scrubbed_family IS 'the family of the TNRS accepted or matched name';
8284

  
8285

  
8286
--
8287
-- Name: COLUMN analytical_stem.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
8288
--
8289

  
8290
COMMENT ON COLUMN analytical_stem.scrubbed_genus IS 'the genus of the TNRS accepted or matched name';
8291

  
8292

  
8293
--
8294
-- Name: COLUMN analytical_stem.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
8295
--
8296

  
8297
COMMENT ON COLUMN analytical_stem.scrubbed_specific_epithet IS 'the specific epithet of the TNRS accepted or matched name';
8298

  
8299

  
8300
--
8301
-- Name: COLUMN analytical_stem.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
8302
--
8303

  
8304
COMMENT ON COLUMN analytical_stem.scrubbed_species_binomial IS 'the species binomial of the TNRS accepted or matched name';
8305

  
8306

  
8307
--
8308
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
8309
--
8310

  
8311
COMMENT ON COLUMN analytical_stem.scrubbed_taxon_name_no_author IS 'the taxon name without author of the TNRS accepted or matched name';
8312

  
8313

  
8314
--
8315
-- Name: COLUMN analytical_stem.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
8316
--
8317

  
8318
COMMENT ON COLUMN analytical_stem.scrubbed_author IS 'the author of the TNRS accepted or matched name';
8319

  
8320

  
8321
--
8322
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
8323
--
8324

  
8325
COMMENT ON COLUMN analytical_stem.scrubbed_taxon_name_with_author IS 'the taxon name with author of the TNRS accepted or matched name';
8326

  
8327

  
8328
--
8329
-- Name: COLUMN analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8330
--
8331

  
8332
COMMENT ON COLUMN analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS 'http://TNRS.taxon_scrub.scrubbed_morphospecies_binomial__@VegBIEN__.public@vegpath.org;
8333
"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`";
8334
a morphospecies is a custom species name assigned in the field by the collector (which does not validate to anything in TNRS)';
8335

  
8336

  
8337
--
8338
-- Name: COLUMN analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8339
--
8340

  
8341
COMMENT ON COLUMN analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS '"Growth form"; "Closed pick list"';
8342

  
8343

  
8344
--
8345
-- Name: COLUMN analytical_stem."reproductiveCondition__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8346
--
8347

  
8348
COMMENT ON COLUMN analytical_stem."reproductiveCondition__@DwC__@vegpath.org" IS '"The reproductive condition of the biological individual(s) represented in the Occurrence. Recommended best practice is to use a controlled vocabulary."';
8349

  
8350

  
8351
--
8352
-- Name: COLUMN analytical_stem.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
8353
--
8354

  
8355
COMMENT ON COLUMN analytical_stem.cultivated_bien IS 'whether the occurrence was flagged as cultivated';
8356

  
8357

  
8358
--
8359
-- Name: COLUMN analytical_stem."cultivatedBasis_bien"; Type: COMMENT; Schema: public; Owner: -
8360
--
8361

  
8362
COMMENT ON COLUMN analytical_stem."cultivatedBasis_bien" IS 'why the occurrence was flagged as cultivated';
8363

  
8364

  
8365
--
8366
-- Name: COLUMN analytical_stem."occurrenceRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8367
--
8368

  
8369
COMMENT ON COLUMN analytical_stem."occurrenceRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Occurrence"';
8370

  
8371

  
8372
--
8373
-- Name: COLUMN analytical_stem."coverPercent__@VegX__.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8374
--
8375

  
8376
COMMENT ON COLUMN analytical_stem."coverPercent__@VegX__.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';
8377

  
8378

  
8379
--
8380
-- Name: COLUMN analytical_stem."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8381
--
8382

  
8383
COMMENT ON COLUMN analytical_stem."taxonObservation[.id]__@VegBank__@vegpath.org" IS '"identifier assigned [by the datasource] to each unique observation of a taxon in a plot"';
8384

  
8385

  
8386
--
8387
-- Name: COLUMN analytical_stem."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8388
--
8389

  
8390
COMMENT ON COLUMN analytical_stem."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS '"Verbatum short code used by the author to signify the species at time of observation"';
8391

  
8392

  
8393
--
8394
-- Name: COLUMN analytical_stem."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8395
--
8396

  
8397
COMMENT ON COLUMN analytical_stem."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to all occurrences of an organism based on an aggregation factor. It contains an AggregateValue, which is an assessment of the overall occurrence of an organism in a Plot (e.g. number of stems, percentage cover, total biomass, basal area)."';
8398

  
8399

  
8400
--
8401
-- Name: COLUMN analytical_stem."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8402
--
8403

  
8404
COMMENT ON COLUMN analytical_stem."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to one occurrence of an organism (or part of an organism). It is a container for measurements made on the organism (e.g. diameter, height, crown dimensions, biomass, growth form, number of stems)."';
8405

  
8406

  
8407
--
8408
-- Name: COLUMN analytical_stem."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8409
--
8410

  
8411
COMMENT ON COLUMN analytical_stem."individualID__@DwC__@vegpath.org" IS '"An identifier for an individual or named group of individual organisms represented in the Occurrence"';
8412

  
8413

  
8414
--
8415
-- Name: COLUMN analytical_stem."individualCount__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8416
--
8417

  
8418
COMMENT ON COLUMN analytical_stem."individualCount__@DwC__@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';
8419

  
8420

  
8421
--
8422
-- Name: COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8423
--
8424

  
8425
COMMENT ON COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS '"Diameter at breast height of this stem (usually taken at 1.3 meters, but may vary)"';
8426

  
8427

  
8428
--
8429
-- Name: COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8430
--
8431

  
8432
COMMENT ON COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS '"The measured height of the stem in meters"';
8433

  
8434

  
8435
--
8436
-- Name: COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8437
--
8438

  
8439
COMMENT ON COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS '"A label that is associated with an individual (e.g. a numerical tree tag)"';
8440

  
8441

  
8442
--
8443
-- Name: COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8444
--
8445

  
8446
COMMENT ON COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The X-coordinate of the related item position in m. The user will enter the relative position of related item with respect to the plot origin (in meters) with the x-axis defined by the plot azimuth."';
8447

  
8448

  
8449
--
8450
-- Name: COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8451
--
8452

  
8453
COMMENT ON COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The Y-coordinate of the relatedSpatialItem position in m. The user will enter the relative position of relatedSpatialItems with respect to the plot origin (in meters) with the y-axis defined by the plot azimuth."';
8454

  
8455

  
8456
--
8457
-- Name: COLUMN analytical_stem."stemCode__@VegBank__.stemLocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8458
--
8459

  
8460
COMMENT ON COLUMN analytical_stem."stemCode__@VegBank__.stemLocation@vegpath.org" IS 'http://stemobservation.authorstemcode__@VegBIEN__.public@vegpath.org;
8461
"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."';
8462

  
8463

  
8464
--
8465
-- Name: COLUMN analytical_stem."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
8466
--
8467

  
8468
COMMENT ON COLUMN analytical_stem."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" IS 'VegBIEN-autogenerated "identifier assigned to each unique observation of a taxon in a plot"';
8469

  
8470

  
8471
--
8472
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE; Schema: public; Owner: -
8473
--
8474

  
8475
CREATE SEQUENCE "analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq"
8476
    START WITH 1
8477
    INCREMENT BY 1
8478
    NO MINVALUE
8479
    NO MAXVALUE
8480
    CACHE 1;
8481

  
8482

  
8483
--
8484
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
8485
--
8486

  
8487
ALTER SEQUENCE "analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq" OWNED BY analytical_stem."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org";
8488

  
8489

  
8490
--
8491 7863
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
8492 7864
--
8493 7865

  
......
13490 12862

  
13491 12863

  
13492 12864
--
13493
-- Name: TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org; Type: DEFAULT; Schema: public; Owner: -
13494
--
13495

  
13496
ALTER TABLE ONLY analytical_stem ALTER COLUMN "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" SET DEFAULT nextval('"analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq"'::regclass);
13497

  
13498

  
13499
--
13500 12865
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
13501 12866
--
13502 12867

  
......
13913 13278

  
13914 13279

  
13915 13280
--
13916
-- Data for Name: analytical_stem; Type: TABLE DATA; Schema: public; Owner: -
13917
--
13918

  
13919

  
13920

  
13921
--
13922
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE SET; Schema: public; Owner: -
13923
--
13924

  
13925

  
13926

  
13927
--
13928 13281
-- Data for Name: classcontributor; Type: TABLE DATA; Schema: public; Owner: -
13929 13282
--
13930 13283

  
......
16591 15944

  
16592 15945

  
16593 15946
--
16594
-- Name: analytical_stem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
16595
--
16596

  
16597
ALTER TABLE ONLY analytical_stem
16598
    ADD CONSTRAINT analytical_stem_pkey PRIMARY KEY ("TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org");
16599

  
16600

  
16601
--
16602 15947
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
16603 15948
--
16604 15949

  
......
17294 16639

  
17295 16640

  
17296 16641
--
17297
-- Name: analytical_stem_datasource__@Brad__.identifier_examples@ve_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
17298
--
17299

  
17300
CREATE INDEX "analytical_stem_datasource__@Brad__.identifier_examples@ve_idx1" ON analytical_stem USING btree ("datasource__@Brad__.identifier_examples@vegpath.org", "[custodial_]institutionCode[s]__@DwC__@vegpath.org", "collectionCode__@DwC__@vegpath.org", "catalogNumber__@DwC__@vegpath.org");
17301

  
17302

  
17303
--
17304
-- Name: analytical_stem_datasource__@Brad__.identifier_examples@ve_idx2; Type: INDEX; Schema: public; Owner: -; Tablespace: 
17305
--
17306

  
17307
CREATE INDEX "analytical_stem_datasource__@Brad__.identifier_examples@ve_idx2" ON analytical_stem USING btree ("datasource__@Brad__.identifier_examples@vegpath.org", "projectID__@VegX__.plotObservation@vegpath.org", "locationID__@DwC__@vegpath.org", "eventDate__@DwC__@vegpath.org");
17308

  
17309

  
17310
--
17311
-- Name: analytical_stem_datasource__@Brad__.identifier_examples@veg_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
17312
--
17313

  
17314
CREATE INDEX "analytical_stem_datasource__@Brad__.identifier_examples@veg_idx" ON analytical_stem USING btree ("datasource__@Brad__.identifier_examples@vegpath.org", "occurrenceID__@DwC__@vegpath.org");
17315

  
17316

  
17317
--
17318
-- Name: analytical_stem_speciesBinomialWithMorphospecies__@VegCore__idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
17319
--
17320

  
17321
CREATE INDEX "analytical_stem_speciesBinomialWithMorphospecies__@VegCore__idx" ON analytical_stem USING btree ("speciesBinomialWithMorphospecies__@VegCore__@vegpath.org");
17322

  
17323

  
17324
--
17325 16642
-- Name: classcontributor_commclass_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
17326 16643
--
17327 16644

  
......
19784 19101

  
19785 19102

  
19786 19103
--
19787
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: -
19788
--
19789

  
19790
REVOKE ALL ON TABLE analytical_stem FROM PUBLIC;
19791
REVOKE ALL ON TABLE analytical_stem FROM bien;
19792
GRANT ALL ON TABLE analytical_stem TO bien;
19793
GRANT SELECT ON TABLE analytical_stem TO bien_read;
19794

  
19795

  
19796
--
19797 19104
-- Name: classcontributor; Type: ACL; Schema: public; Owner: -
19798 19105
--
19799 19106

  
trunk/schemas/vegbien.sql
7860 7860

  
7861 7861

  
7862 7862
--
7863
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: 
7864
--
7865

  
7866
CREATE TABLE analytical_stem (
7867
    "datasource__@Brad__.identifier_examples@vegpath.org" text NOT NULL,
7868
    "country__@DwC__@vegpath.org" text,
7869
    "stateProvince__@DwC__@vegpath.org" text,
7870
    "county__@DwC__@vegpath.org" text,
7871
    "locality__@DwC__@vegpath.org" text,
7872
    "decimalLatitude__@DwC__@vegpath.org" double precision,
7873
    "decimalLongitude__@DwC__@vegpath.org" double precision,
7874
    "coordinateUncertaintyInMeters__@DwC__@vegpath.org" double precision,
7875
    "georeferenceSources__@DwC__@vegpath.org" coordinatesource,
7876
    "georeferenceProtocol__@DwC__@vegpath.org" text,
7877
    geovalid_bien integer,
7878
    "isNewWorld_bien" integer,
7879
    "projectID__@VegX__.plotObservation@vegpath.org" text,
7880
    "projectContributor[s]__@VegBank__@vegpath.org" text[],
7881
    "locationID__@DwC__@vegpath.org" text NOT NULL,
7882
    "plotName__@VegX__.plot@vegpath.org" text,
7883
    "subplot__@SALVIAS__.Plot_data@vegpath.org" text,
7884
    location__cultivated__bien boolean,
7885
    "locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" integer,
7886
    "eventDate__@DwC__@vegpath.org" date,
7887
    "(-minimum-)ElevationInMeters__@DwC__@vegpath.org" double precision,
7888
    "slopeAspect[_deg]__@VegX__.plot@vegpath.org" double precision,
7889
    "slopeGradient[_deg]__@VegX__.plot@vegpath.org" double precision,
7890
    "plot.area[_ha]__@VegX__@vegpath.org" double precision,
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff