Project

General

Profile

« Previous | Next » 

Revision 14441

schemas/public_.sql: added viewFullOccurrence_individual by running viewFullOccurrence_individual_view_modify()

View differences:

trunk/schemas/vegbien.my.sql
8349 8349

  
8350 8350

  
8351 8351
--
8352
-- Name: viewFullOccurrence_individual; Type: TABLE; Schema: public; Owner: -; Tablespace: 
8353
--
8354

  
8355
CREATE TABLE `viewFullOccurrence_individual` (
8356
    `datasource__@Brad__.identifier_examples@vegpath.org` varchar(255) NOT NULL,
8357
    `country__@DwC__@vegpath.org` varchar(255),
8358
    `stateProvince__@DwC__@vegpath.org` varchar(255),
8359
    `county__@DwC__@vegpath.org` varchar(255),
8360
    `locality__@DwC__@vegpath.org` varchar(255),
8361
    `decimalLatitude__@DwC__@vegpath.org` double,
8362
    `decimalLongitude__@DwC__@vegpath.org` double,
8363
    `coordinateUncertaintyInMeters__@DwC__@vegpath.org` double,
8364
    `georeferenceSources__@DwC__@vegpath.org` coordinatesource,
8365
    `georeferenceProtocol__@DwC__@vegpath.org` varchar(255),
8366
    geovalid_bien int(11),
8367
    `isNewWorld_bien` int(11),
8368
    `projectID__@VegX__.plotObservation@vegpath.org` varchar(255),
8369
    `projectContributor[s]__@VegBank__@vegpath.org` varchar(255),
8370
    `locationID__@DwC__@vegpath.org` varchar(255) NOT NULL,
8371
    `plotName__@VegX__.plot@vegpath.org` varchar(255),
8372
    `subplot__@SALVIAS__.Plot_data@vegpath.org` varchar(255),
8373
    location__cultivated__bien int(1),
8374
    `locationevent.locationevent_id__@VegBIEN__.public@vegpath.org` int(11),
8375
    `eventDate__@DwC__@vegpath.org` date,
8376
    `(-minimum-)ElevationInMeters__@DwC__@vegpath.org` double,
8377
    `slopeAspect[_deg]__@VegX__.plot@vegpath.org` double,
8378
    `slopeGradient[_deg]__@VegX__.plot@vegpath.org` double,
8379
    `plot.area[_ha]__@VegX__@vegpath.org` double,
8380
    `samplingProtocol__@DwC__@vegpath.org` varchar(255),
8381
    `temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org` double,
8382
    `precip_mm__@SALVIAS__.Plot_metadata@vegpath.org` double,
8383
    `stratumName__@VegX__.stratum@vegpath.org` varchar(255),
8384
    `communityConcept.name__@VegX__.communityDet@vegpath.org` varchar(255),
8385
    `observationContributor[s]__@VegBank__@vegpath.org` varchar(255),
8386
    `[custodial_]institutionCode[s]__@DwC__@vegpath.org` varchar(255),
8387
    `collectionCode__@DwC__@vegpath.org` varchar(255),
8388
    `catalogNumber__@DwC__@vegpath.org` varchar(255),
8389
    `occurrenceID__@DwC__@vegpath.org` varchar(255),
8390
    `recordedBy__@DwC__@vegpath.org` varchar(255),
8391
    `recordNumber__@DwC__@vegpath.org` varchar(255),
8392
    `(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org` date,
8393
    `[verbatim_]family__@DwC__@vegpath.org` varchar(255),
8394
    `[verbatim_]scientificName__@DwC__@vegpath.org` varchar(255),
8395
    `identifiedBy__@DwC__@vegpath.org` varchar(255),
8396
    `dateIdentified__@DwC__@vegpath.org` date,
8397
    `identificationRemarks__@DwC__@vegpath.org` varchar(255),
8398
    `Family_matched__@TNRS__@vegpath.org` varchar(255),
8399
    `Name_matched__@TNRS__@vegpath.org` varchar(255),
8400
    `Name_matched_author__@TNRS__@vegpath.org` varchar(255),
8401
    `[higher_plant_group~]higherClassification__@DwC__@vegpath.org` higher_plant_group,
8402
    `taxonomicStatus__@DwC__@vegpath.org` varchar(255),
8403
    scrubbed_family varchar(255),
8404
    scrubbed_genus varchar(255),
8405
    scrubbed_specific_epithet varchar(255),
8406
    scrubbed_species_binomial varchar(255),
8407
    scrubbed_taxon_name_no_author varchar(255),
8408
    scrubbed_author varchar(255),
8409
    scrubbed_taxon_name_with_author varchar(255),
8410
    `speciesBinomialWithMorphospecies__@VegCore__@vegpath.org` varchar(255),
8411
    `[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org` growthform,
8412
    `reproductiveCondition__@DwC__@vegpath.org` varchar(255),
8413
    cultivated_bien int(11),
8414
    `cultivatedBasis_bien` varchar(255),
8415
    `occurrenceRemarks__@DwC__@vegpath.org` varchar(255),
8416
    `coverPercent__@VegX__.attribute.ordinal@vegpath.org` double,
8417
    `taxonObservation[.id]__@VegBank__@vegpath.org` varchar(255),
8418
    `taxonNameUsageConcept.authorCode__@VegX__@vegpath.org` varchar(255),
8419
    `aggregateOrganismObservation.id__@VegX__@vegpath.org` varchar(255),
8420
    `individualOrganismObservation.id__@VegX__@vegpath.org` varchar(255),
8421
    `individualID__@DwC__@vegpath.org` varchar(255),
8422
    `individualCount__@DwC__@vegpath.org` int(11),
8423
    `plantobservation.``_id__@VegBIEN__.public@vegpath.org` int(11),
8424
    `TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org` int(11) NOT NULL
8425
);
8426

  
8427

  
8428
--
8429
-- Name: COLUMN `viewFullOccurrence_individual`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8430
--
8431

  
8432

  
8433

  
8434

  
8435
--
8436
-- Name: COLUMN `viewFullOccurrence_individual`.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8437
--
8438

  
8439

  
8440

  
8441

  
8442
--
8443
-- Name: COLUMN `viewFullOccurrence_individual`.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8444
--
8445

  
8446

  
8447

  
8448

  
8449
--
8450
-- Name: COLUMN `viewFullOccurrence_individual`.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8451
--
8452

  
8453

  
8454

  
8455

  
8456
--
8457
-- Name: COLUMN `viewFullOccurrence_individual`.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8458
--
8459

  
8460

  
8461

  
8462

  
8463
--
8464
-- Name: COLUMN `viewFullOccurrence_individual`.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8465
--
8466

  
8467

  
8468

  
8469

  
8470
--
8471
-- Name: COLUMN `viewFullOccurrence_individual`.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8472
--
8473

  
8474

  
8475

  
8476

  
8477
--
8478
-- Name: COLUMN `viewFullOccurrence_individual`.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8479
--
8480

  
8481

  
8482

  
8483

  
8484
--
8485
-- Name: COLUMN `viewFullOccurrence_individual`.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8486
--
8487

  
8488

  
8489

  
8490

  
8491
--
8492
-- Name: COLUMN `viewFullOccurrence_individual`.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8493
--
8494

  
8495

  
8496

  
8497

  
8498
--
8499
-- Name: COLUMN `viewFullOccurrence_individual`.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
8500
--
8501

  
8502

  
8503

  
8504

  
8505
--
8506
-- Name: COLUMN `viewFullOccurrence_individual`.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
8507
--
8508

  
8509

  
8510

  
8511

  
8512
--
8513
-- Name: COLUMN `viewFullOccurrence_individual`.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8514
--
8515

  
8516

  
8517

  
8518

  
8519
--
8520
-- Name: COLUMN `viewFullOccurrence_individual`.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8521
--
8522

  
8523

  
8524

  
8525

  
8526
--
8527
-- Name: COLUMN `viewFullOccurrence_individual`.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8528
--
8529

  
8530

  
8531

  
8532

  
8533
--
8534
-- Name: COLUMN `viewFullOccurrence_individual`.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8535
--
8536

  
8537

  
8538

  
8539

  
8540
--
8541
-- Name: COLUMN `viewFullOccurrence_individual`.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8542
--
8543

  
8544

  
8545

  
8546

  
8547
--
8548
-- Name: COLUMN `viewFullOccurrence_individual`.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
8549
--
8550

  
8551

  
8552

  
8553

  
8554
--
8555
-- Name: COLUMN `viewFullOccurrence_individual`.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8556
--
8557

  
8558

  
8559

  
8560

  
8561
--
8562
-- Name: COLUMN `viewFullOccurrence_individual`.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8563
--
8564

  
8565

  
8566

  
8567

  
8568
--
8569
-- Name: COLUMN `viewFullOccurrence_individual`.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8570
--
8571

  
8572

  
8573

  
8574

  
8575
--
8576
-- Name: COLUMN `viewFullOccurrence_individual`.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8577
--
8578

  
8579

  
8580

  
8581

  
8582
--
8583
-- Name: COLUMN `viewFullOccurrence_individual`.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8584
--
8585

  
8586

  
8587

  
8588

  
8589
--
8590
-- Name: COLUMN `viewFullOccurrence_individual`.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8591
--
8592

  
8593

  
8594

  
8595

  
8596
--
8597
-- Name: COLUMN `viewFullOccurrence_individual`.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8598
--
8599

  
8600

  
8601

  
8602

  
8603
--
8604
-- Name: COLUMN `viewFullOccurrence_individual`.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8605
--
8606

  
8607

  
8608

  
8609

  
8610
--
8611
-- Name: COLUMN `viewFullOccurrence_individual`.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8612
--
8613

  
8614

  
8615

  
8616

  
8617
--
8618
-- Name: COLUMN `viewFullOccurrence_individual`.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8619
--
8620

  
8621

  
8622

  
8623

  
8624
--
8625
-- Name: COLUMN `viewFullOccurrence_individual`.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8626
--
8627

  
8628

  
8629

  
8630

  
8631
--
8632
-- Name: COLUMN `viewFullOccurrence_individual`.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8633
--
8634

  
8635

  
8636

  
8637

  
8638
--
8639
-- Name: COLUMN `viewFullOccurrence_individual`.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8640
--
8641

  
8642

  
8643

  
8644

  
8645
--
8646
-- Name: COLUMN `viewFullOccurrence_individual`.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8647
--
8648

  
8649

  
8650

  
8651

  
8652
--
8653
-- Name: COLUMN `viewFullOccurrence_individual`.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8654
--
8655

  
8656

  
8657

  
8658

  
8659
--
8660
-- Name: COLUMN `viewFullOccurrence_individual`.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8661
--
8662

  
8663

  
8664

  
8665

  
8666
--
8667
-- Name: COLUMN `viewFullOccurrence_individual`.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8668
--
8669

  
8670

  
8671

  
8672

  
8673
--
8674
-- Name: COLUMN `viewFullOccurrence_individual`.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8675
--
8676

  
8677

  
8678

  
8679

  
8680
--
8681
-- Name: COLUMN `viewFullOccurrence_individual`.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8682
--
8683

  
8684

  
8685

  
8686

  
8687
--
8688
-- Name: COLUMN `viewFullOccurrence_individual`.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8689
--
8690

  
8691

  
8692

  
8693

  
8694
--
8695
-- Name: COLUMN `viewFullOccurrence_individual`.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8696
--
8697

  
8698

  
8699

  
8700

  
8701
--
8702
-- Name: COLUMN `viewFullOccurrence_individual`.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8703
--
8704

  
8705

  
8706

  
8707

  
8708
--
8709
-- Name: COLUMN `viewFullOccurrence_individual`.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8710
--
8711

  
8712

  
8713

  
8714

  
8715
--
8716
-- Name: COLUMN `viewFullOccurrence_individual`.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8717
--
8718

  
8719

  
8720

  
8721

  
8722
--
8723
-- Name: COLUMN `viewFullOccurrence_individual`.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8724
--
8725

  
8726

  
8727

  
8728

  
8729
--
8730
-- Name: COLUMN `viewFullOccurrence_individual`.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8731
--
8732

  
8733

  
8734

  
8735

  
8736
--
8737
-- Name: COLUMN `viewFullOccurrence_individual`.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8738
--
8739

  
8740

  
8741

  
8742

  
8743
--
8744
-- Name: COLUMN `viewFullOccurrence_individual`.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8745
--
8746

  
8747

  
8748

  
8749

  
8750
--
8751
-- Name: COLUMN `viewFullOccurrence_individual`.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8752
--
8753

  
8754

  
8755

  
8756

  
8757
--
8758
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
8759
--
8760

  
8761

  
8762

  
8763

  
8764
--
8765
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
8766
--
8767

  
8768

  
8769

  
8770

  
8771
--
8772
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
8773
--
8774

  
8775

  
8776

  
8777

  
8778
--
8779
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
8780
--
8781

  
8782

  
8783

  
8784

  
8785
--
8786
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
8787
--
8788

  
8789

  
8790

  
8791

  
8792
--
8793
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
8794
--
8795

  
8796

  
8797

  
8798

  
8799
--
8800
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
8801
--
8802

  
8803

  
8804

  
8805

  
8806
--
8807
-- Name: COLUMN `viewFullOccurrence_individual`.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8808
--
8809

  
8810

  
8811

  
8812

  
8813
--
8814
-- Name: COLUMN `viewFullOccurrence_individual`.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8815
--
8816

  
8817

  
8818

  
8819

  
8820
--
8821
-- Name: COLUMN `viewFullOccurrence_individual`.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8822
--
8823

  
8824

  
8825

  
8826

  
8827
--
8828
-- Name: COLUMN `viewFullOccurrence_individual`.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
8829
--
8830

  
8831

  
8832

  
8833

  
8834
--
8835
-- Name: COLUMN `viewFullOccurrence_individual`.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
8836
--
8837

  
8838

  
8839

  
8840

  
8841
--
8842
-- Name: COLUMN `viewFullOccurrence_individual`.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8843
--
8844

  
8845

  
8846

  
8847

  
8848
--
8849
-- Name: COLUMN `viewFullOccurrence_individual`.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8850
--
8851

  
8852

  
8853

  
8854

  
8855
--
8856
-- Name: COLUMN `viewFullOccurrence_individual`.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8857
--
8858

  
8859

  
8860

  
8861

  
8862
--
8863
-- Name: COLUMN `viewFullOccurrence_individual`.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8864
--
8865

  
8866

  
8867

  
8868

  
8869
--
8870
-- Name: COLUMN `viewFullOccurrence_individual`.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8871
--
8872

  
8873

  
8874

  
8875

  
8876
--
8877
-- Name: COLUMN `viewFullOccurrence_individual`.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8878
--
8879

  
8880

  
8881

  
8882

  
8883
--
8884
-- Name: COLUMN `viewFullOccurrence_individual`.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8885
--
8886

  
8887

  
8888

  
8889

  
8890
--
8891
-- Name: COLUMN `viewFullOccurrence_individual`.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8892
--
8893

  
8894

  
8895

  
8896

  
8897
--
8898
-- Name: COLUMN `viewFullOccurrence_individual`.`plantobservation.``_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8899
--
8900

  
8901

  
8902

  
8903

  
8904
--
8905
-- Name: COLUMN `viewFullOccurrence_individual`.`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
8906
--
8907

  
8908

  
8909

  
8910

  
8911
--
8912
-- Name: viewFullOccurrence_individual_TAXONOBSERVATION_ID__@VegBank_seq; Type: SEQUENCE; Schema: public; Owner: -
8913
--
8914

  
8915

  
8916

  
8917

  
8918
--
8919
-- Name: viewFullOccurrence_individual_TAXONOBSERVATION_ID__@VegBank_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
8920
--
8921

  
8922

  
8923

  
8924

  
8925
--
8352 8926
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
8353 8927
--
8354 8928

  
......
9218 9792

  
9219 9793

  
9220 9794
--
9795
-- Name: TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org; Type: DEFAULT; Schema: public; Owner: -
9796
--
9797

  
9798

  
9799

  
9800

  
9801
--
9221 9802
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
9222 9803
--
9223 9804

  
......
11601 12182

  
11602 12183

  
11603 12184
--
12185
-- Data for Name: viewFullOccurrence_individual; Type: TABLE DATA; Schema: public; Owner: -
12186
--
12187

  
12188

  
12189

  
12190
--
12191
-- Name: viewFullOccurrence_individual_TAXONOBSERVATION_ID__@VegBank_seq; Type: SEQUENCE SET; Schema: public; Owner: -
12192
--
12193

  
12194

  
12195

  
12196
--
11604 12197
-- Data for Name: voucher; Type: TABLE DATA; Schema: public; Owner: -
11605 12198
--
11606 12199

  
......
12531 13124

  
12532 13125

  
12533 13126
--
13127
-- Name: viewFullOccurrence_individual_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
13128
--
13129

  
13130
ALTER TABLE `viewFullOccurrence_individual`
13131
    ADD CONSTRAINT `viewFullOccurrence_individual_pkey` PRIMARY KEY (`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`);
13132

  
13133

  
13134
--
12534 13135
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
12535 13136
--
12536 13137

  
......
13674 14275

  
13675 14276

  
13676 14277
--
14278
-- Name: viewFullOccurrence_individual_datasource__@Brad__.identifi_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
14279
--
14280

  
14281
CREATE INDEX `viewFullOccurrence_individual_datasource__@Brad__.identifi_idx1` ON `viewFullOccurrence_individual`  (`datasource__@Brad__.identifier_examples@vegpath.org`, `[custodial_]institutionCode[s]__@DwC__@vegpath.org`, `collectionCode__@DwC__@vegpath.org`, `catalogNumber__@DwC__@vegpath.org`);
14282

  
14283

  
14284
--
14285
-- Name: viewFullOccurrence_individual_datasource__@Brad__.identifi_idx2; Type: INDEX; Schema: public; Owner: -; Tablespace: 
14286
--
14287

  
14288
CREATE INDEX `viewFullOccurrence_individual_datasource__@Brad__.identifi_idx2` ON `viewFullOccurrence_individual`  (`datasource__@Brad__.identifier_examples@vegpath.org`, `projectID__@VegX__.plotObservation@vegpath.org`, `locationID__@DwC__@vegpath.org`, `eventDate__@DwC__@vegpath.org`);
14289

  
14290

  
14291
--
14292
-- Name: viewFullOccurrence_individual_datasource__@Brad__.identifie_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
14293
--
14294

  
14295
CREATE INDEX `viewFullOccurrence_individual_datasource__@Brad__.identifie_idx` ON `viewFullOccurrence_individual`  (`datasource__@Brad__.identifier_examples@vegpath.org`, `occurrenceID__@DwC__@vegpath.org`);
14296

  
14297

  
14298
--
14299
-- Name: viewFullOccurrence_individual_speciesBinomialWithMorphospec_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
14300
--
14301

  
14302
CREATE INDEX `viewFullOccurrence_individual_speciesBinomialWithMorphospec_idx` ON `viewFullOccurrence_individual`  (`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`);
14303

  
14304

  
14305
--
13677 14306
-- Name: voucher_specimenreplicate_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
13678 14307
--
13679 14308

  
......
15788 16417

  
15789 16418

  
15790 16419
--
16420
-- Name: viewFullOccurrence_individual; Type: ACL; Schema: public; Owner: -
16421
--
16422

  
16423

  
16424

  
16425

  
16426

  
16427

  
16428

  
16429
--
15791 16430
-- Name: voucher; Type: ACL; Schema: public; Owner: -
15792 16431
--
15793 16432

  
trunk/schemas/public_.sql
11952 11952

  
11953 11953

  
11954 11954
--
11955
-- Name: viewFullOccurrence_individual; Type: TABLE; Schema: public; Owner: -; Tablespace: 
11956
--
11957

  
11958
CREATE TABLE "viewFullOccurrence_individual" (
11959
    "datasource__@Brad__.identifier_examples@vegpath.org" text NOT NULL,
11960
    "country__@DwC__@vegpath.org" text,
11961
    "stateProvince__@DwC__@vegpath.org" text,
11962
    "county__@DwC__@vegpath.org" text,
11963
    "locality__@DwC__@vegpath.org" text,
11964
    "decimalLatitude__@DwC__@vegpath.org" double precision,
11965
    "decimalLongitude__@DwC__@vegpath.org" double precision,
11966
    "coordinateUncertaintyInMeters__@DwC__@vegpath.org" double precision,
11967
    "georeferenceSources__@DwC__@vegpath.org" coordinatesource,
11968
    "georeferenceProtocol__@DwC__@vegpath.org" text,
11969
    geovalid_bien integer,
11970
    "isNewWorld_bien" integer,
11971
    "projectID__@VegX__.plotObservation@vegpath.org" text,
11972
    "projectContributor[s]__@VegBank__@vegpath.org" text[],
11973
    "locationID__@DwC__@vegpath.org" text NOT NULL,
11974
    "plotName__@VegX__.plot@vegpath.org" text,
11975
    "subplot__@SALVIAS__.Plot_data@vegpath.org" text,
11976
    location__cultivated__bien boolean,
11977
    "locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" integer,
11978
    "eventDate__@DwC__@vegpath.org" date,
11979
    "(-minimum-)ElevationInMeters__@DwC__@vegpath.org" double precision,
11980
    "slopeAspect[_deg]__@VegX__.plot@vegpath.org" double precision,
11981
    "slopeGradient[_deg]__@VegX__.plot@vegpath.org" double precision,
11982
    "plot.area[_ha]__@VegX__@vegpath.org" double precision,
11983
    "samplingProtocol__@DwC__@vegpath.org" text,
11984
    "temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" double precision,
11985
    "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" double precision,
11986
    "stratumName__@VegX__.stratum@vegpath.org" text,
11987
    "communityConcept.name__@VegX__.communityDet@vegpath.org" text[],
11988
    "observationContributor[s]__@VegBank__@vegpath.org" text[],
11989
    "[custodial_]institutionCode[s]__@DwC__@vegpath.org" text,
11990
    "collectionCode__@DwC__@vegpath.org" text,
11991
    "catalogNumber__@DwC__@vegpath.org" text,
11992
    "occurrenceID__@DwC__@vegpath.org" text,
11993
    "recordedBy__@DwC__@vegpath.org" text,
11994
    "recordNumber__@DwC__@vegpath.org" text,
11995
    "(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" date,
11996
    "[verbatim_]family__@DwC__@vegpath.org" text,
11997
    "[verbatim_]scientificName__@DwC__@vegpath.org" text,
11998
    "identifiedBy__@DwC__@vegpath.org" text,
11999
    "dateIdentified__@DwC__@vegpath.org" date,
12000
    "identificationRemarks__@DwC__@vegpath.org" text,
12001
    "Family_matched__@TNRS__@vegpath.org" text,
12002
    "Name_matched__@TNRS__@vegpath.org" text,
12003
    "Name_matched_author__@TNRS__@vegpath.org" text,
12004
    "[higher_plant_group~]higherClassification__@DwC__@vegpath.org" higher_plant_group,
12005
    "taxonomicStatus__@DwC__@vegpath.org" text,
12006
    scrubbed_family text,
12007
    scrubbed_genus text,
12008
    scrubbed_specific_epithet text,
12009
    scrubbed_species_binomial text,
12010
    scrubbed_taxon_name_no_author text,
12011
    scrubbed_author text,
12012
    scrubbed_taxon_name_with_author text,
12013
    "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" text,
12014
    "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" growthform,
12015
    "reproductiveCondition__@DwC__@vegpath.org" text,
12016
    cultivated_bien integer,
12017
    "cultivatedBasis_bien" text,
12018
    "occurrenceRemarks__@DwC__@vegpath.org" text,
12019
    "coverPercent__@VegX__.attribute.ordinal@vegpath.org" double precision,
12020
    "taxonObservation[.id]__@VegBank__@vegpath.org" text,
12021
    "taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" text,
12022
    "aggregateOrganismObservation.id__@VegX__@vegpath.org" text,
12023
    "individualOrganismObservation.id__@VegX__@vegpath.org" text,
12024
    "individualID__@DwC__@vegpath.org" text,
12025
    "individualCount__@DwC__@vegpath.org" integer,
12026
    "plantobservation.""_id__@VegBIEN__.public@vegpath.org" integer,
12027
    "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" integer NOT NULL
12028
);
12029

  
12030

  
12031
--
12032
-- Name: COLUMN "viewFullOccurrence_individual"."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12033
--
12034

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

  
12037

  
12038
--
12039
-- Name: COLUMN "viewFullOccurrence_individual"."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12040
--
12041

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

  
12045

  
12046
--
12047
-- Name: COLUMN "viewFullOccurrence_individual"."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12048
--
12049

  
12050
COMMENT ON COLUMN "viewFullOccurrence_individual"."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"';
12051

  
12052

  
12053
--
12054
-- Name: COLUMN "viewFullOccurrence_individual"."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12055
--
12056

  
12057
COMMENT ON COLUMN "viewFullOccurrence_individual"."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"';
12058

  
12059

  
12060
--
12061
-- Name: COLUMN "viewFullOccurrence_individual"."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12062
--
12063

  
12064
COMMENT ON COLUMN "viewFullOccurrence_individual"."locality__@DwC__@vegpath.org" IS '"The specific description of the place"';
12065

  
12066

  
12067
--
12068
-- Name: COLUMN "viewFullOccurrence_individual"."decimalLatitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12069
--
12070

  
12071
COMMENT ON COLUMN "viewFullOccurrence_individual"."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"';
12072

  
12073

  
12074
--
12075
-- Name: COLUMN "viewFullOccurrence_individual"."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12076
--
12077

  
12078
COMMENT ON COLUMN "viewFullOccurrence_individual"."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"';
12079

  
12080

  
12081
--
12082
-- Name: COLUMN "viewFullOccurrence_individual"."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12083
--
12084

  
12085
COMMENT ON COLUMN "viewFullOccurrence_individual"."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.';
12086

  
12087

  
12088
--
12089
-- Name: COLUMN "viewFullOccurrence_individual"."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12090
--
12091

  
12092
COMMENT ON COLUMN "viewFullOccurrence_individual"."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"';
12093

  
12094

  
12095
--
12096
-- Name: COLUMN "viewFullOccurrence_individual"."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12097
--
12098

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

  
12101

  
12102
--
12103
-- Name: COLUMN "viewFullOccurrence_individual".geovalid_bien; Type: COMMENT; Schema: public; Owner: -
12104
--
12105

  
12106
COMMENT ON COLUMN "viewFullOccurrence_individual".geovalid_bien IS 'whether the coordinates are within the boundary of the asserted named places';
12107

  
12108

  
12109
--
12110
-- Name: COLUMN "viewFullOccurrence_individual"."isNewWorld_bien"; Type: COMMENT; Schema: public; Owner: -
12111
--
12112

  
12113
COMMENT ON COLUMN "viewFullOccurrence_individual"."isNewWorld_bien" IS 'whether the country is in the Americas';
12114

  
12115

  
12116
--
12117
-- Name: COLUMN "viewFullOccurrence_individual"."projectID__@VegX__.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12118
--
12119

  
12120
COMMENT ON COLUMN "viewFullOccurrence_individual"."projectID__@VegX__.plotObservation@vegpath.org" IS 'http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;
12121
"A reference to a specific ''project''"';
12122

  
12123

  
12124
--
12125
-- Name: COLUMN "viewFullOccurrence_individual"."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12126
--
12127

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

  
12130

  
12131
--
12132
-- Name: COLUMN "viewFullOccurrence_individual"."locationID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12133
--
12134

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

  
12137

  
12138
--
12139
-- Name: COLUMN "viewFullOccurrence_individual"."plotName__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12140
--
12141

  
12142
COMMENT ON COLUMN "viewFullOccurrence_individual"."plotName__@VegX__.plot@vegpath.org" IS '"Name or label for a plot"';
12143

  
12144

  
12145
--
12146
-- Name: COLUMN "viewFullOccurrence_individual"."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12147
--
12148

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

  
12152

  
12153
--
12154
-- Name: COLUMN "viewFullOccurrence_individual".location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
12155
--
12156

  
12157
COMMENT ON COLUMN "viewFullOccurrence_individual".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.';
12158

  
12159

  
12160
--
12161
-- Name: COLUMN "viewFullOccurrence_individual"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12162
--
12163

  
12164
COMMENT ON COLUMN "viewFullOccurrence_individual"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'http://locationevent.locationevent_id__@VegBIEN__.public@vegpath.org;
12165
autogenerated ID for locationevent';
12166

  
12167

  
12168
--
12169
-- Name: COLUMN "viewFullOccurrence_individual"."eventDate__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12170
--
12171

  
12172
COMMENT ON COLUMN "viewFullOccurrence_individual"."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."';
12173

  
12174

  
12175
--
12176
-- Name: COLUMN "viewFullOccurrence_individual"."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12177
--
12178

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

  
12181

  
12182
--
12183
-- Name: COLUMN "viewFullOccurrence_individual"."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12184
--
12185

  
12186
COMMENT ON COLUMN "viewFullOccurrence_individual"."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)"';
12187

  
12188

  
12189
--
12190
-- Name: COLUMN "viewFullOccurrence_individual"."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12191
--
12192

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

  
12195

  
12196
--
12197
-- Name: COLUMN "viewFullOccurrence_individual"."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12198
--
12199

  
12200
COMMENT ON COLUMN "viewFullOccurrence_individual"."plot.area[_ha]__@VegX__@vegpath.org" IS '"Total area of the plot"';
12201

  
12202

  
12203
--
12204
-- Name: COLUMN "viewFullOccurrence_individual"."samplingProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12205
--
12206

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

  
12209

  
12210
--
12211
-- Name: COLUMN "viewFullOccurrence_individual"."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12212
--
12213

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

  
12216

  
12217
--
12218
-- Name: COLUMN "viewFullOccurrence_individual"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12219
--
12220

  
12221
COMMENT ON COLUMN "viewFullOccurrence_individual"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS '"Total annual precipitation, in mm"';
12222

  
12223

  
12224
--
12225
-- Name: COLUMN "viewFullOccurrence_individual"."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12226
--
12227

  
12228
COMMENT ON COLUMN "viewFullOccurrence_individual"."stratumName__@VegX__.stratum@vegpath.org" IS '"Name associated with this stratum"';
12229

  
12230

  
12231
--
12232
-- Name: COLUMN "viewFullOccurrence_individual"."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12233
--
12234

  
12235
COMMENT ON COLUMN "viewFullOccurrence_individual"."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."';
12236

  
12237

  
12238
--
12239
-- Name: COLUMN "viewFullOccurrence_individual"."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12240
--
12241

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

  
12244

  
12245
--
12246
-- Name: COLUMN "viewFullOccurrence_individual"."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12247
--
12248

  
12249
COMMENT ON COLUMN "viewFullOccurrence_individual"."[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"';
12250

  
12251

  
12252
--
12253
-- Name: COLUMN "viewFullOccurrence_individual"."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12254
--
12255

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

  
12258

  
12259
--
12260
-- Name: COLUMN "viewFullOccurrence_individual"."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12261
--
12262

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

  
12265

  
12266
--
12267
-- Name: COLUMN "viewFullOccurrence_individual"."occurrenceID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12268
--
12269

  
12270
COMMENT ON COLUMN "viewFullOccurrence_individual"."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."';
12271

  
12272

  
12273
--
12274
-- Name: COLUMN "viewFullOccurrence_individual"."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12275
--
12276

  
12277
COMMENT ON COLUMN "viewFullOccurrence_individual"."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."';
12278

  
12279

  
12280
--
12281
-- Name: COLUMN "viewFullOccurrence_individual"."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12282
--
12283

  
12284
COMMENT ON COLUMN "viewFullOccurrence_individual"."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."';
12285

  
12286

  
12287
--
12288
-- Name: COLUMN "viewFullOccurrence_individual"."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12289
--
12290

  
12291
COMMENT ON COLUMN "viewFullOccurrence_individual"."(-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"';
12292

  
12293

  
12294
--
12295
-- Name: COLUMN "viewFullOccurrence_individual"."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12296
--
12297

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

  
12300

  
12301
--
12302
-- Name: COLUMN "viewFullOccurrence_individual"."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12303
--
12304

  
12305
COMMENT ON COLUMN "viewFullOccurrence_individual"."[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."';
12306

  
12307

  
12308
--
12309
-- Name: COLUMN "viewFullOccurrence_individual"."identifiedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12310
--
12311

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

  
12314

  
12315
--
12316
-- Name: COLUMN "viewFullOccurrence_individual"."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12317
--
12318

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

  
12321

  
12322
--
12323
-- Name: COLUMN "viewFullOccurrence_individual"."identificationRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12324
--
12325

  
12326
COMMENT ON COLUMN "viewFullOccurrence_individual"."identificationRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Identification"';
12327

  
12328

  
12329
--
12330
-- Name: COLUMN "viewFullOccurrence_individual"."Family_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12331
--
12332

  
12333
COMMENT ON COLUMN "viewFullOccurrence_individual"."Family_matched__@TNRS__@vegpath.org" IS 'http://TNRS.taxon_scrub.matchedFamily__@VegBIEN__.public@vegpath.org;
12334
"The closest matching family in the TNRS database to the family submitted"';
12335

  
12336

  
12337
--
12338
-- Name: COLUMN "viewFullOccurrence_individual"."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12339
--
12340

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

  
12343

  
12344
--
12345
-- Name: COLUMN "viewFullOccurrence_individual"."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12346
--
12347

  
12348
COMMENT ON COLUMN "viewFullOccurrence_individual"."Name_matched_author__@TNRS__@vegpath.org" IS '"Standard authority for the matched name"';
12349

  
12350

  
12351
--
12352
-- Name: COLUMN "viewFullOccurrence_individual"."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12353
--
12354

  
12355
COMMENT ON COLUMN "viewFullOccurrence_individual"."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'closed list derived from higher taxa';
12356

  
12357

  
12358
--
12359
-- Name: COLUMN "viewFullOccurrence_individual"."taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12360
--
12361

  
12362
COMMENT ON COLUMN "viewFullOccurrence_individual"."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"."';
12363

  
12364

  
12365
--
12366
-- Name: COLUMN "viewFullOccurrence_individual".scrubbed_family; Type: COMMENT; Schema: public; Owner: -
12367
--
12368

  
12369
COMMENT ON COLUMN "viewFullOccurrence_individual".scrubbed_family IS 'the family of the TNRS accepted or matched name';
12370

  
12371

  
12372
--
12373
-- Name: COLUMN "viewFullOccurrence_individual".scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
12374
--
12375

  
12376
COMMENT ON COLUMN "viewFullOccurrence_individual".scrubbed_genus IS 'the genus of the TNRS accepted or matched name';
12377

  
12378

  
12379
--
12380
-- Name: COLUMN "viewFullOccurrence_individual".scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
12381
--
12382

  
12383
COMMENT ON COLUMN "viewFullOccurrence_individual".scrubbed_specific_epithet IS 'the specific epithet of the TNRS accepted or matched name';
12384

  
12385

  
12386
--
12387
-- Name: COLUMN "viewFullOccurrence_individual".scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
12388
--
12389

  
12390
COMMENT ON COLUMN "viewFullOccurrence_individual".scrubbed_species_binomial IS 'the species binomial of the TNRS accepted or matched name';
12391

  
12392

  
12393
--
12394
-- Name: COLUMN "viewFullOccurrence_individual".scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
12395
--
12396

  
12397
COMMENT ON COLUMN "viewFullOccurrence_individual".scrubbed_taxon_name_no_author IS 'the taxon name without author of the TNRS accepted or matched name';
12398

  
12399

  
12400
--
12401
-- Name: COLUMN "viewFullOccurrence_individual".scrubbed_author; Type: COMMENT; Schema: public; Owner: -
12402
--
12403

  
12404
COMMENT ON COLUMN "viewFullOccurrence_individual".scrubbed_author IS 'the author of the TNRS accepted or matched name';
12405

  
12406

  
12407
--
12408
-- Name: COLUMN "viewFullOccurrence_individual".scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
12409
--
12410

  
12411
COMMENT ON COLUMN "viewFullOccurrence_individual".scrubbed_taxon_name_with_author IS 'the taxon name with author of the TNRS accepted or matched name';
12412

  
12413

  
12414
--
12415
-- Name: COLUMN "viewFullOccurrence_individual"."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12416
--
12417

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

  
12422

  
12423
--
12424
-- Name: COLUMN "viewFullOccurrence_individual"."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12425
--
12426

  
12427
COMMENT ON COLUMN "viewFullOccurrence_individual"."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS '"Growth form"; "Closed pick list"';
12428

  
12429

  
12430
--
12431
-- Name: COLUMN "viewFullOccurrence_individual"."reproductiveCondition__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12432
--
12433

  
12434
COMMENT ON COLUMN "viewFullOccurrence_individual"."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."';
12435

  
12436

  
12437
--
12438
-- Name: COLUMN "viewFullOccurrence_individual".cultivated_bien; Type: COMMENT; Schema: public; Owner: -
12439
--
12440

  
12441
COMMENT ON COLUMN "viewFullOccurrence_individual".cultivated_bien IS 'whether the occurrence was flagged as cultivated';
12442

  
12443

  
12444
--
12445
-- Name: COLUMN "viewFullOccurrence_individual"."cultivatedBasis_bien"; Type: COMMENT; Schema: public; Owner: -
12446
--
12447

  
12448
COMMENT ON COLUMN "viewFullOccurrence_individual"."cultivatedBasis_bien" IS 'why the occurrence was flagged as cultivated';
12449

  
12450

  
12451
--
12452
-- Name: COLUMN "viewFullOccurrence_individual"."occurrenceRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12453
--
12454

  
12455
COMMENT ON COLUMN "viewFullOccurrence_individual"."occurrenceRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Occurrence"';
12456

  
12457

  
12458
--
12459
-- Name: COLUMN "viewFullOccurrence_individual"."coverPercent__@VegX__.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12460
--
12461

  
12462
COMMENT ON COLUMN "viewFullOccurrence_individual"."coverPercent__@VegX__.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';
12463

  
12464

  
12465
--
12466
-- Name: COLUMN "viewFullOccurrence_individual"."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12467
--
12468

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

  
12471

  
12472
--
12473
-- Name: COLUMN "viewFullOccurrence_individual"."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12474
--
12475

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

  
12478

  
12479
--
12480
-- Name: COLUMN "viewFullOccurrence_individual"."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12481
--
12482

  
12483
COMMENT ON COLUMN "viewFullOccurrence_individual"."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)."';
12484

  
12485

  
12486
--
12487
-- Name: COLUMN "viewFullOccurrence_individual"."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12488
--
12489

  
12490
COMMENT ON COLUMN "viewFullOccurrence_individual"."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)."';
12491

  
12492

  
12493
--
12494
-- Name: COLUMN "viewFullOccurrence_individual"."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12495
--
12496

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

  
12499

  
12500
--
12501
-- Name: COLUMN "viewFullOccurrence_individual"."individualCount__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12502
--
12503

  
12504
COMMENT ON COLUMN "viewFullOccurrence_individual"."individualCount__@DwC__@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';
12505

  
12506

  
12507
--
12508
-- Name: COLUMN "viewFullOccurrence_individual"."plantobservation.""_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12509
--
12510

  
12511
COMMENT ON COLUMN "viewFullOccurrence_individual"."plantobservation.""_id__@VegBIEN__.public@vegpath.org" IS 'http://plantobservation.plantobservation_id__@VegBIEN__.public@vegpath.org;
12512
autogenerated ID for plantobservation';
12513

  
12514

  
12515
--
12516
-- Name: COLUMN "viewFullOccurrence_individual"."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12517
--
12518

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

  
12521

  
12522
--
12523
-- Name: viewFullOccurrence_individual_TAXONOBSERVATION_ID__@VegBank_seq; Type: SEQUENCE; Schema: public; Owner: -
12524
--
12525

  
12526
CREATE SEQUENCE "viewFullOccurrence_individual_TAXONOBSERVATION_ID__@VegBank_seq"
12527
    START WITH 1
12528
    INCREMENT BY 1
12529
    NO MINVALUE
12530
    NO MAXVALUE
12531
    CACHE 1;
12532

  
12533

  
12534
--
12535
-- Name: viewFullOccurrence_individual_TAXONOBSERVATION_ID__@VegBank_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
12536
--
12537

  
12538
ALTER SEQUENCE "viewFullOccurrence_individual_TAXONOBSERVATION_ID__@VegBank_seq" OWNED BY "viewFullOccurrence_individual"."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org";
12539

  
12540

  
12541
--
11955 12542
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
11956 12543
--
11957 12544

  
......
13263 13850

  
13264 13851

  
13265 13852
--
13853
-- Name: TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org; Type: DEFAULT; Schema: public; Owner: -
13854
--
13855

  
13856
ALTER TABLE ONLY "viewFullOccurrence_individual" ALTER COLUMN "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" SET DEFAULT nextval('"viewFullOccurrence_individual_TAXONOBSERVATION_ID__@VegBank_seq"'::regclass);
13857

  
13858

  
13859
--
13266 13860
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
13267 13861
--
13268 13862

  
......
15646 16240

  
15647 16241

  
15648 16242
--
16243
-- Data for Name: viewFullOccurrence_individual; Type: TABLE DATA; Schema: public; Owner: -
16244
--
16245

  
16246

  
16247

  
16248
--
16249
-- Name: viewFullOccurrence_individual_TAXONOBSERVATION_ID__@VegBank_seq; Type: SEQUENCE SET; Schema: public; Owner: -
16250
--
16251

  
16252

  
16253

  
16254
--
15649 16255
-- Data for Name: voucher; Type: TABLE DATA; Schema: public; Owner: -
15650 16256
--
15651 16257

  
......
16576 17182

  
16577 17183

  
16578 17184
--
17185
-- Name: viewFullOccurrence_individual_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
17186
--
17187

  
17188
ALTER TABLE ONLY "viewFullOccurrence_individual"
17189
    ADD CONSTRAINT "viewFullOccurrence_individual_pkey" PRIMARY KEY ("TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org");
17190

  
17191

  
17192
--
16579 17193
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
16580 17194
--
16581 17195

  
......
17719 18333

  
17720 18334

  
17721 18335
--
18336
-- Name: viewFullOccurrence_individual_datasource__@Brad__.identifi_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
18337
--
18338

  
18339
CREATE INDEX "viewFullOccurrence_individual_datasource__@Brad__.identifi_idx1" ON "viewFullOccurrence_individual" USING btree ("datasource__@Brad__.identifier_examples@vegpath.org", "[custodial_]institutionCode[s]__@DwC__@vegpath.org", "collectionCode__@DwC__@vegpath.org", "catalogNumber__@DwC__@vegpath.org");
18340

  
18341

  
18342
--
18343
-- Name: viewFullOccurrence_individual_datasource__@Brad__.identifi_idx2; Type: INDEX; Schema: public; Owner: -; Tablespace: 
18344
--
18345

  
18346
CREATE INDEX "viewFullOccurrence_individual_datasource__@Brad__.identifi_idx2" ON "viewFullOccurrence_individual" USING btree ("datasource__@Brad__.identifier_examples@vegpath.org", "projectID__@VegX__.plotObservation@vegpath.org", "locationID__@DwC__@vegpath.org", "eventDate__@DwC__@vegpath.org");
18347

  
18348

  
18349
--
18350
-- Name: viewFullOccurrence_individual_datasource__@Brad__.identifie_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
18351
--
18352

  
18353
CREATE INDEX "viewFullOccurrence_individual_datasource__@Brad__.identifie_idx" ON "viewFullOccurrence_individual" USING btree ("datasource__@Brad__.identifier_examples@vegpath.org", "occurrenceID__@DwC__@vegpath.org");
18354

  
18355

  
18356
--
18357
-- Name: viewFullOccurrence_individual_speciesBinomialWithMorphospec_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
18358
--
18359

  
18360
CREATE INDEX "viewFullOccurrence_individual_speciesBinomialWithMorphospec_idx" ON "viewFullOccurrence_individual" USING btree ("speciesBinomialWithMorphospecies__@VegCore__@vegpath.org");
18361

  
18362

  
18363
--
17722 18364
-- Name: voucher_specimenreplicate_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
17723 18365
--
17724 18366

  
......
19883 20525

  
19884 20526

  
19885 20527
--
20528
-- Name: viewFullOccurrence_individual; Type: ACL; Schema: public; Owner: -
20529
--
20530

  
20531
REVOKE ALL ON TABLE "viewFullOccurrence_individual" FROM PUBLIC;
20532
REVOKE ALL ON TABLE "viewFullOccurrence_individual" FROM bien;
20533
GRANT ALL ON TABLE "viewFullOccurrence_individual" TO bien;
20534
GRANT SELECT ON TABLE "viewFullOccurrence_individual" TO bien_read;
20535

  
20536

  
20537
--
19886 20538
-- Name: voucher; Type: ACL; Schema: public; Owner: -
19887 20539
--
19888 20540

  
trunk/schemas/vegbien.sql
11952 11952

  
11953 11953

  
11954 11954
--
11955
-- Name: viewFullOccurrence_individual; Type: TABLE; Schema: public; Owner: -; Tablespace: 
11956
--
11957

  
11958
CREATE TABLE "viewFullOccurrence_individual" (
11959
    "datasource__@Brad__.identifier_examples@vegpath.org" text NOT NULL,
11960
    "country__@DwC__@vegpath.org" text,
11961
    "stateProvince__@DwC__@vegpath.org" text,
11962
    "county__@DwC__@vegpath.org" text,
11963
    "locality__@DwC__@vegpath.org" text,
11964
    "decimalLatitude__@DwC__@vegpath.org" double precision,
11965
    "decimalLongitude__@DwC__@vegpath.org" double precision,
11966
    "coordinateUncertaintyInMeters__@DwC__@vegpath.org" double precision,
11967
    "georeferenceSources__@DwC__@vegpath.org" coordinatesource,
11968
    "georeferenceProtocol__@DwC__@vegpath.org" text,
11969
    geovalid_bien integer,
11970
    "isNewWorld_bien" integer,
11971
    "projectID__@VegX__.plotObservation@vegpath.org" text,
11972
    "projectContributor[s]__@VegBank__@vegpath.org" text[],
11973
    "locationID__@DwC__@vegpath.org" text NOT NULL,
11974
    "plotName__@VegX__.plot@vegpath.org" text,
11975
    "subplot__@SALVIAS__.Plot_data@vegpath.org" text,
11976
    location__cultivated__bien boolean,
11977
    "locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" integer,
11978
    "eventDate__@DwC__@vegpath.org" date,
11979
    "(-minimum-)ElevationInMeters__@DwC__@vegpath.org" double precision,
11980
    "slopeAspect[_deg]__@VegX__.plot@vegpath.org" double precision,
11981
    "slopeGradient[_deg]__@VegX__.plot@vegpath.org" double precision,
11982
    "plot.area[_ha]__@VegX__@vegpath.org" double precision,
11983
    "samplingProtocol__@DwC__@vegpath.org" text,
11984
    "temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" double precision,
11985
    "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" double precision,
11986
    "stratumName__@VegX__.stratum@vegpath.org" text,
11987
    "communityConcept.name__@VegX__.communityDet@vegpath.org" text[],
11988
    "observationContributor[s]__@VegBank__@vegpath.org" text[],
11989
    "[custodial_]institutionCode[s]__@DwC__@vegpath.org" text,
11990
    "collectionCode__@DwC__@vegpath.org" text,
11991
    "catalogNumber__@DwC__@vegpath.org" text,
11992
    "occurrenceID__@DwC__@vegpath.org" text,
11993
    "recordedBy__@DwC__@vegpath.org" text,
11994
    "recordNumber__@DwC__@vegpath.org" text,
11995
    "(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" date,
11996
    "[verbatim_]family__@DwC__@vegpath.org" text,
11997
    "[verbatim_]scientificName__@DwC__@vegpath.org" text,
11998
    "identifiedBy__@DwC__@vegpath.org" text,
11999
    "dateIdentified__@DwC__@vegpath.org" date,
12000
    "identificationRemarks__@DwC__@vegpath.org" text,
12001
    "Family_matched__@TNRS__@vegpath.org" text,
12002
    "Name_matched__@TNRS__@vegpath.org" text,
12003
    "Name_matched_author__@TNRS__@vegpath.org" text,
12004
    "[higher_plant_group~]higherClassification__@DwC__@vegpath.org" higher_plant_group,
12005
    "taxonomicStatus__@DwC__@vegpath.org" text,
12006
    scrubbed_family text,
12007
    scrubbed_genus text,
12008
    scrubbed_specific_epithet text,
12009
    scrubbed_species_binomial text,
12010
    scrubbed_taxon_name_no_author text,
12011
    scrubbed_author text,
12012
    scrubbed_taxon_name_with_author text,
12013
    "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" text,
12014
    "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" growthform,
12015
    "reproductiveCondition__@DwC__@vegpath.org" text,
12016
    cultivated_bien integer,
12017
    "cultivatedBasis_bien" text,
12018
    "occurrenceRemarks__@DwC__@vegpath.org" text,
12019
    "coverPercent__@VegX__.attribute.ordinal@vegpath.org" double precision,
12020
    "taxonObservation[.id]__@VegBank__@vegpath.org" text,
12021
    "taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" text,
12022
    "aggregateOrganismObservation.id__@VegX__@vegpath.org" text,
12023
    "individualOrganismObservation.id__@VegX__@vegpath.org" text,
12024
    "individualID__@DwC__@vegpath.org" text,
12025
    "individualCount__@DwC__@vegpath.org" integer,
12026
    "plantobservation.""_id__@VegBIEN__.public@vegpath.org" integer,
12027
    "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" integer NOT NULL
12028
);
12029

  
12030

  
12031
--
12032
-- Name: COLUMN "viewFullOccurrence_individual"."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12033
--
12034

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

  
12037

  
12038
--
12039
-- Name: COLUMN "viewFullOccurrence_individual"."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12040
--
12041

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

  
12045

  
12046
--
12047
-- Name: COLUMN "viewFullOccurrence_individual"."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12048
--
12049

  
12050
COMMENT ON COLUMN "viewFullOccurrence_individual"."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"';
12051

  
12052

  
12053
--
12054
-- Name: COLUMN "viewFullOccurrence_individual"."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12055
--
12056

  
12057
COMMENT ON COLUMN "viewFullOccurrence_individual"."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"';
12058

  
12059

  
12060
--
12061
-- Name: COLUMN "viewFullOccurrence_individual"."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
12062
--
12063

  
12064
COMMENT ON COLUMN "viewFullOccurrence_individual"."locality__@DwC__@vegpath.org" IS '"The specific description of the place"';
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff