Project

General

Profile

« Previous | Next » 

Revision 14419

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: added viewFullOccurrence_{CVS,VegBank,NCU} for Bob

View differences:

trunk/schemas/vegbien.my.sql
8321 8321 

  		




  8322
  8322
  
    

  		




  8323
  8323
  
    
--


  		




  
  8324
  
    
-- Name: viewFullOccurrence_CVS; Type: VIEW; Schema: public; Owner: -


  		




  
  8325
  
    
--


  		




  
  8326
  
    

  		




  
  8327
  
    

  		




  
  8328
  
    

  		




  
  8329
  
    

  		




  
  8330
  
    
--


  		




  
  8331
  
    
-- Name: viewFullOccurrence_NCU; Type: VIEW; Schema: public; Owner: -


  		




  
  8332
  
    
--


  		




  
  8333
  
    

  		




  
  8334
  
    

  		




  
  8335
  
    

  		




  
  8336
  
    

  		




  
  8337
  
    
--


  		




  
  8338
  
    
-- Name: viewFullOccurrence_VegBank; Type: VIEW; Schema: public; Owner: -


  		




  
  8339
  
    
--


  		




  
  8340
  
    

  		




  
  8341
  
    

  		




  
  8342
  
    

  		




  
  8343
  
    

  		




  
  8344
  
    
--


  		




  8324
  8345
  
    
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  8325
  8346
  
    
--


  		




  8326
  8347
  
    

  		




  ......




  15730
  15751
  
    

  		




  15731
  15752
  
    

  		




  15732
  15753
  
    
--


  		




  
  15754
  
    
-- Name: viewFullOccurrence_CVS; Type: ACL; Schema: public; Owner: -


  		




  
  15755
  
    
--


  		




  
  15756
  
    

  		




  
  15757
  
    

  		




  
  15758
  
    

  		




  
  15759
  
    

  		




  
  15760
  
    

  		




  
  15761
  
    

  		




  
  15762
  
    

  		




  
  15763
  
    
--


  		




  
  15764
  
    
-- Name: viewFullOccurrence_NCU; Type: ACL; Schema: public; Owner: -


  		




  
  15765
  
    
--


  		




  
  15766
  
    

  		




  
  15767
  
    

  		




  
  15768
  
    

  		




  
  15769
  
    

  		




  
  15770
  
    

  		




  
  15771
  
    

  		




  
  15772
  
    

  		




  
  15773
  
    
--


  		




  
  15774
  
    
-- Name: viewFullOccurrence_VegBank; Type: ACL; Schema: public; Owner: -


  		




  
  15775
  
    
--


  		




  
  15776
  
    

  		




  
  15777
  
    

  		




  
  15778
  
    

  		




  
  15779
  
    

  		




  
  15780
  
    

  		




  
  15781
  
    

  		




  
  15782
  
    

  		




  
  15783
  
    
--


  		




  15733
  15784
  
    
-- Name: voucher; Type: ACL; Schema: public; Owner: -


  		




  15734
  15785
  
    
--


  		




  15735
  15786
  
    

  		












  

    
      trunk/schemas/public_.sql
    
  





  11696
  11696
  
    

  		




  11697
  11697
  
    

  		




  11698
  11698
  
    
--


  		




  
  11699
  
    
-- Name: viewFullOccurrence_CVS; Type: VIEW; Schema: public; Owner: -


  		




  
  11700
  
    
--


  		




  
  11701
  
    

  		




  
  11702
  
    
CREATE VIEW "viewFullOccurrence_CVS" AS


  		




  
  11703
  
    
 SELECT "viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org",


  		




  
  11704
  
    
    "viewFullOccurrence_individual_view"."country__@DwC__@vegpath.org",


  		




  
  11705
  
    
    "viewFullOccurrence_individual_view"."stateProvince__@DwC__@vegpath.org",


  		




  
  11706
  
    
    "viewFullOccurrence_individual_view"."county__@DwC__@vegpath.org",


  		




  
  11707
  
    
    "viewFullOccurrence_individual_view"."locality__@DwC__@vegpath.org",


  		




  
  11708
  
    
    "viewFullOccurrence_individual_view"."decimalLatitude__@DwC__@vegpath.org",


  		




  
  11709
  
    
    "viewFullOccurrence_individual_view"."decimalLongitude__@DwC__@vegpath.org",


  		




  
  11710
  
    
    "viewFullOccurrence_individual_view"."coordinateUncertaintyInMeters__@DwC__@vegpath.org",


  		




  
  11711
  
    
    "viewFullOccurrence_individual_view"."georeferenceSources__@DwC__@vegpath.org",


  		




  
  11712
  
    
    "viewFullOccurrence_individual_view"."georeferenceProtocol__@DwC__@vegpath.org",


  		




  
  11713
  
    
    "viewFullOccurrence_individual_view".geovalid_bien,


  		




  
  11714
  
    
    "viewFullOccurrence_individual_view"."isNewWorld_bien",


  		




  
  11715
  
    
    "viewFullOccurrence_individual_view"."projectID__@VegX__.plotObservation@vegpath.org",


  		




  
  11716
  
    
    "viewFullOccurrence_individual_view"."projectContributor[s]__@VegBank__@vegpath.org",


  		




  
  11717
  
    
    "viewFullOccurrence_individual_view"."locationID__@DwC__@vegpath.org",


  		




  
  11718
  
    
    "viewFullOccurrence_individual_view"."plotName__@VegX__.plot@vegpath.org",


  		




  
  11719
  
    
    "viewFullOccurrence_individual_view"."subplot__@SALVIAS__.Plot_data@vegpath.org",


  		




  
  11720
  
    
    "viewFullOccurrence_individual_view".location__cultivated__bien,


  		




  
  11721
  
    
    "viewFullOccurrence_individual_view"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org",


  		




  
  11722
  
    
    "viewFullOccurrence_individual_view"."eventDate__@DwC__@vegpath.org",


  		




  
  11723
  
    
    "viewFullOccurrence_individual_view"."(-minimum-)ElevationInMeters__@DwC__@vegpath.org",


  		




  
  11724
  
    
    "viewFullOccurrence_individual_view"."slopeAspect[_deg]__@VegX__.plot@vegpath.org",


  		




  
  11725
  
    
    "viewFullOccurrence_individual_view"."slopeGradient[_deg]__@VegX__.plot@vegpath.org",


  		




  
  11726
  
    
    "viewFullOccurrence_individual_view"."plot.area[_ha]__@VegX__@vegpath.org",


  		




  
  11727
  
    
    "viewFullOccurrence_individual_view"."samplingProtocol__@DwC__@vegpath.org",


  		




  
  11728
  
    
    "viewFullOccurrence_individual_view"."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",


  		




  
  11729
  
    
    "viewFullOccurrence_individual_view"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",


  		




  
  11730
  
    
    "viewFullOccurrence_individual_view"."stratumName__@VegX__.stratum@vegpath.org",


  		




  
  11731
  
    
    "viewFullOccurrence_individual_view"."communityConcept.name__@VegX__.communityDet@vegpath.org",


  		




  
  11732
  
    
    "viewFullOccurrence_individual_view"."observationContributor[s]__@VegBank__@vegpath.org",


  		




  
  11733
  
    
    "viewFullOccurrence_individual_view"."[custodial_]institutionCode[s]__@DwC__@vegpath.org",


  		




  
  11734
  
    
    "viewFullOccurrence_individual_view"."collectionCode__@DwC__@vegpath.org",


  		




  
  11735
  
    
    "viewFullOccurrence_individual_view"."catalogNumber__@DwC__@vegpath.org",


  		




  
  11736
  
    
    "viewFullOccurrence_individual_view"."occurrenceID__@DwC__@vegpath.org",


  		




  
  11737
  
    
    "viewFullOccurrence_individual_view"."recordedBy__@DwC__@vegpath.org",


  		




  
  11738
  
    
    "viewFullOccurrence_individual_view"."recordNumber__@DwC__@vegpath.org",


  		




  
  11739
  
    
    "viewFullOccurrence_individual_view"."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",


  		




  
  11740
  
    
    "viewFullOccurrence_individual_view"."[verbatim_]family__@DwC__@vegpath.org",


  		




  
  11741
  
    
    "viewFullOccurrence_individual_view"."[verbatim_]scientificName__@DwC__@vegpath.org",


  		




  
  11742
  
    
    "viewFullOccurrence_individual_view"."identifiedBy__@DwC__@vegpath.org",


  		




  
  11743
  
    
    "viewFullOccurrence_individual_view"."dateIdentified__@DwC__@vegpath.org",


  		




  
  11744
  
    
    "viewFullOccurrence_individual_view"."identificationRemarks__@DwC__@vegpath.org",


  		




  
  11745
  
    
    "viewFullOccurrence_individual_view"."Family_matched__@TNRS__@vegpath.org",


  		




  
  11746
  
    
    "viewFullOccurrence_individual_view"."Name_matched__@TNRS__@vegpath.org",


  		




  
  11747
  
    
    "viewFullOccurrence_individual_view"."Name_matched_author__@TNRS__@vegpath.org",


  		




  
  11748
  
    
    "viewFullOccurrence_individual_view"."[higher_plant_group~]higherClassification__@DwC__@vegpath.org",


  		




  
  11749
  
    
    "viewFullOccurrence_individual_view"."taxonomicStatus__@DwC__@vegpath.org",


  		




  
  11750
  
    
    "viewFullOccurrence_individual_view".scrubbed_family,


  		




  
  11751
  
    
    "viewFullOccurrence_individual_view".scrubbed_genus,


  		




  
  11752
  
    
    "viewFullOccurrence_individual_view".scrubbed_specific_epithet,


  		




  
  11753
  
    
    "viewFullOccurrence_individual_view".scrubbed_species_binomial,


  		




  
  11754
  
    
    "viewFullOccurrence_individual_view".scrubbed_taxon_name_no_author,


  		




  
  11755
  
    
    "viewFullOccurrence_individual_view".scrubbed_author,


  		




  
  11756
  
    
    "viewFullOccurrence_individual_view".scrubbed_taxon_name_with_author,


  		




  
  11757
  
    
    "viewFullOccurrence_individual_view"."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org",


  		




  
  11758
  
    
    "viewFullOccurrence_individual_view"."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",


  		




  
  11759
  
    
    "viewFullOccurrence_individual_view"."reproductiveCondition__@DwC__@vegpath.org",


  		




  
  11760
  
    
    "viewFullOccurrence_individual_view".cultivated_bien,


  		




  
  11761
  
    
    "viewFullOccurrence_individual_view"."cultivatedBasis_bien",


  		




  
  11762
  
    
    "viewFullOccurrence_individual_view"."occurrenceRemarks__@DwC__@vegpath.org",


  		




  
  11763
  
    
    "viewFullOccurrence_individual_view"."coverPercent__@VegX__.attribute.ordinal@vegpath.org",


  		




  
  11764
  
    
    "viewFullOccurrence_individual_view"."taxonObservation[.id]__@VegBank__@vegpath.org",


  		




  
  11765
  
    
    "viewFullOccurrence_individual_view"."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",


  		




  
  11766
  
    
    "viewFullOccurrence_individual_view"."aggregateOrganismObservation.id__@VegX__@vegpath.org",


  		




  
  11767
  
    
    "viewFullOccurrence_individual_view"."individualOrganismObservation.id__@VegX__@vegpath.org",


  		




  
  11768
  
    
    "viewFullOccurrence_individual_view"."individualID__@DwC__@vegpath.org",


  		




  
  11769
  
    
    "viewFullOccurrence_individual_view"."individualCount__@DwC__@vegpath.org",


  		




  
  11770
  
    
    "viewFullOccurrence_individual_view"."plantobservation.""_id__@VegBIEN__.public@vegpath.org"


  		




  
  11771
  
    
   FROM "viewFullOccurrence_individual_view"


  		




  
  11772
  
    
  WHERE ("viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org" = 'CVS'::text);


  		




  
  11773
  
    

  		




  
  11774
  
    

  		




  
  11775
  
    
--


  		




  
  11776
  
    
-- Name: viewFullOccurrence_NCU; Type: VIEW; Schema: public; Owner: -


  		




  
  11777
  
    
--


  		




  
  11778
  
    

  		




  
  11779
  
    
CREATE VIEW "viewFullOccurrence_NCU" AS


  		




  
  11780
  
    
 SELECT "viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org",


  		




  
  11781
  
    
    "viewFullOccurrence_individual_view"."country__@DwC__@vegpath.org",


  		




  
  11782
  
    
    "viewFullOccurrence_individual_view"."stateProvince__@DwC__@vegpath.org",


  		




  
  11783
  
    
    "viewFullOccurrence_individual_view"."county__@DwC__@vegpath.org",


  		




  
  11784
  
    
    "viewFullOccurrence_individual_view"."locality__@DwC__@vegpath.org",


  		




  
  11785
  
    
    "viewFullOccurrence_individual_view"."decimalLatitude__@DwC__@vegpath.org",


  		




  
  11786
  
    
    "viewFullOccurrence_individual_view"."decimalLongitude__@DwC__@vegpath.org",


  		




  
  11787
  
    
    "viewFullOccurrence_individual_view"."coordinateUncertaintyInMeters__@DwC__@vegpath.org",


  		




  
  11788
  
    
    "viewFullOccurrence_individual_view"."georeferenceSources__@DwC__@vegpath.org",


  		




  
  11789
  
    
    "viewFullOccurrence_individual_view"."georeferenceProtocol__@DwC__@vegpath.org",


  		




  
  11790
  
    
    "viewFullOccurrence_individual_view".geovalid_bien,


  		




  
  11791
  
    
    "viewFullOccurrence_individual_view"."isNewWorld_bien",


  		




  
  11792
  
    
    "viewFullOccurrence_individual_view"."projectID__@VegX__.plotObservation@vegpath.org",


  		




  
  11793
  
    
    "viewFullOccurrence_individual_view"."projectContributor[s]__@VegBank__@vegpath.org",


  		




  
  11794
  
    
    "viewFullOccurrence_individual_view"."locationID__@DwC__@vegpath.org",


  		




  
  11795
  
    
    "viewFullOccurrence_individual_view"."plotName__@VegX__.plot@vegpath.org",


  		




  
  11796
  
    
    "viewFullOccurrence_individual_view"."subplot__@SALVIAS__.Plot_data@vegpath.org",


  		




  
  11797
  
    
    "viewFullOccurrence_individual_view".location__cultivated__bien,


  		




  
  11798
  
    
    "viewFullOccurrence_individual_view"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org",


  		




  
  11799
  
    
    "viewFullOccurrence_individual_view"."eventDate__@DwC__@vegpath.org",


  		




  
  11800
  
    
    "viewFullOccurrence_individual_view"."(-minimum-)ElevationInMeters__@DwC__@vegpath.org",


  		




  
  11801
  
    
    "viewFullOccurrence_individual_view"."slopeAspect[_deg]__@VegX__.plot@vegpath.org",


  		




  
  11802
  
    
    "viewFullOccurrence_individual_view"."slopeGradient[_deg]__@VegX__.plot@vegpath.org",


  		




  
  11803
  
    
    "viewFullOccurrence_individual_view"."plot.area[_ha]__@VegX__@vegpath.org",


  		




  
  11804
  
    
    "viewFullOccurrence_individual_view"."samplingProtocol__@DwC__@vegpath.org",


  		




  
  11805
  
    
    "viewFullOccurrence_individual_view"."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",


  		




  
  11806
  
    
    "viewFullOccurrence_individual_view"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",


  		




  
  11807
  
    
    "viewFullOccurrence_individual_view"."stratumName__@VegX__.stratum@vegpath.org",


  		




  
  11808
  
    
    "viewFullOccurrence_individual_view"."communityConcept.name__@VegX__.communityDet@vegpath.org",


  		




  
  11809
  
    
    "viewFullOccurrence_individual_view"."observationContributor[s]__@VegBank__@vegpath.org",


  		




  
  11810
  
    
    "viewFullOccurrence_individual_view"."[custodial_]institutionCode[s]__@DwC__@vegpath.org",


  		




  
  11811
  
    
    "viewFullOccurrence_individual_view"."collectionCode__@DwC__@vegpath.org",


  		




  
  11812
  
    
    "viewFullOccurrence_individual_view"."catalogNumber__@DwC__@vegpath.org",


  		




  
  11813
  
    
    "viewFullOccurrence_individual_view"."occurrenceID__@DwC__@vegpath.org",


  		




  
  11814
  
    
    "viewFullOccurrence_individual_view"."recordedBy__@DwC__@vegpath.org",


  		




  
  11815
  
    
    "viewFullOccurrence_individual_view"."recordNumber__@DwC__@vegpath.org",


  		




  
  11816
  
    
    "viewFullOccurrence_individual_view"."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",


  		




  
  11817
  
    
    "viewFullOccurrence_individual_view"."[verbatim_]family__@DwC__@vegpath.org",


  		




  
  11818
  
    
    "viewFullOccurrence_individual_view"."[verbatim_]scientificName__@DwC__@vegpath.org",


  		




  
  11819
  
    
    "viewFullOccurrence_individual_view"."identifiedBy__@DwC__@vegpath.org",


  		




  
  11820
  
    
    "viewFullOccurrence_individual_view"."dateIdentified__@DwC__@vegpath.org",


  		




  
  11821
  
    
    "viewFullOccurrence_individual_view"."identificationRemarks__@DwC__@vegpath.org",


  		




  
  11822
  
    
    "viewFullOccurrence_individual_view"."Family_matched__@TNRS__@vegpath.org",


  		




  
  11823
  
    
    "viewFullOccurrence_individual_view"."Name_matched__@TNRS__@vegpath.org",


  		




  
  11824
  
    
    "viewFullOccurrence_individual_view"."Name_matched_author__@TNRS__@vegpath.org",


  		




  
  11825
  
    
    "viewFullOccurrence_individual_view"."[higher_plant_group~]higherClassification__@DwC__@vegpath.org",


  		




  
  11826
  
    
    "viewFullOccurrence_individual_view"."taxonomicStatus__@DwC__@vegpath.org",


  		




  
  11827
  
    
    "viewFullOccurrence_individual_view".scrubbed_family,


  		




  
  11828
  
    
    "viewFullOccurrence_individual_view".scrubbed_genus,


  		




  
  11829
  
    
    "viewFullOccurrence_individual_view".scrubbed_specific_epithet,


  		




  
  11830
  
    
    "viewFullOccurrence_individual_view".scrubbed_species_binomial,


  		




  
  11831
  
    
    "viewFullOccurrence_individual_view".scrubbed_taxon_name_no_author,


  		




  
  11832
  
    
    "viewFullOccurrence_individual_view".scrubbed_author,


  		




  
  11833
  
    
    "viewFullOccurrence_individual_view".scrubbed_taxon_name_with_author,


  		




  
  11834
  
    
    "viewFullOccurrence_individual_view"."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org",


  		




  
  11835
  
    
    "viewFullOccurrence_individual_view"."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",


  		




  
  11836
  
    
    "viewFullOccurrence_individual_view"."reproductiveCondition__@DwC__@vegpath.org",


  		




  
  11837
  
    
    "viewFullOccurrence_individual_view".cultivated_bien,


  		




  
  11838
  
    
    "viewFullOccurrence_individual_view"."cultivatedBasis_bien",


  		




  
  11839
  
    
    "viewFullOccurrence_individual_view"."occurrenceRemarks__@DwC__@vegpath.org",


  		




  
  11840
  
    
    "viewFullOccurrence_individual_view"."coverPercent__@VegX__.attribute.ordinal@vegpath.org",


  		




  
  11841
  
    
    "viewFullOccurrence_individual_view"."taxonObservation[.id]__@VegBank__@vegpath.org",


  		




  
  11842
  
    
    "viewFullOccurrence_individual_view"."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",


  		




  
  11843
  
    
    "viewFullOccurrence_individual_view"."aggregateOrganismObservation.id__@VegX__@vegpath.org",


  		




  
  11844
  
    
    "viewFullOccurrence_individual_view"."individualOrganismObservation.id__@VegX__@vegpath.org",


  		




  
  11845
  
    
    "viewFullOccurrence_individual_view"."individualID__@DwC__@vegpath.org",


  		




  
  11846
  
    
    "viewFullOccurrence_individual_view"."individualCount__@DwC__@vegpath.org",


  		




  
  11847
  
    
    "viewFullOccurrence_individual_view"."plantobservation.""_id__@VegBIEN__.public@vegpath.org"


  		




  
  11848
  
    
   FROM "viewFullOccurrence_individual_view"


  		




  
  11849
  
    
  WHERE ("viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org" = 'NCU'::text);


  		




  
  11850
  
    

  		




  
  11851
  
    

  		




  
  11852
  
    
--


  		




  
  11853
  
    
-- Name: viewFullOccurrence_VegBank; Type: VIEW; Schema: public; Owner: -


  		




  
  11854
  
    
--


  		




  
  11855
  
    

  		




  
  11856
  
    
CREATE VIEW "viewFullOccurrence_VegBank" AS


  		




  
  11857
  
    
 SELECT "viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org",


  		




  
  11858
  
    
    "viewFullOccurrence_individual_view"."country__@DwC__@vegpath.org",


  		




  
  11859
  
    
    "viewFullOccurrence_individual_view"."stateProvince__@DwC__@vegpath.org",


  		




  
  11860
  
    
    "viewFullOccurrence_individual_view"."county__@DwC__@vegpath.org",


  		




  
  11861
  
    
    "viewFullOccurrence_individual_view"."locality__@DwC__@vegpath.org",


  		




  
  11862
  
    
    "viewFullOccurrence_individual_view"."decimalLatitude__@DwC__@vegpath.org",


  		




  
  11863
  
    
    "viewFullOccurrence_individual_view"."decimalLongitude__@DwC__@vegpath.org",


  		




  
  11864
  
    
    "viewFullOccurrence_individual_view"."coordinateUncertaintyInMeters__@DwC__@vegpath.org",


  		




  
  11865
  
    
    "viewFullOccurrence_individual_view"."georeferenceSources__@DwC__@vegpath.org",


  		




  
  11866
  
    
    "viewFullOccurrence_individual_view"."georeferenceProtocol__@DwC__@vegpath.org",


  		




  
  11867
  
    
    "viewFullOccurrence_individual_view".geovalid_bien,


  		




  
  11868
  
    
    "viewFullOccurrence_individual_view"."isNewWorld_bien",


  		




  
  11869
  
    
    "viewFullOccurrence_individual_view"."projectID__@VegX__.plotObservation@vegpath.org",


  		




  
  11870
  
    
    "viewFullOccurrence_individual_view"."projectContributor[s]__@VegBank__@vegpath.org",


  		




  
  11871
  
    
    "viewFullOccurrence_individual_view"."locationID__@DwC__@vegpath.org",


  		




  
  11872
  
    
    "viewFullOccurrence_individual_view"."plotName__@VegX__.plot@vegpath.org",


  		




  
  11873
  
    
    "viewFullOccurrence_individual_view"."subplot__@SALVIAS__.Plot_data@vegpath.org",


  		




  
  11874
  
    
    "viewFullOccurrence_individual_view".location__cultivated__bien,


  		




  
  11875
  
    
    "viewFullOccurrence_individual_view"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org",


  		




  
  11876
  
    
    "viewFullOccurrence_individual_view"."eventDate__@DwC__@vegpath.org",


  		




  
  11877
  
    
    "viewFullOccurrence_individual_view"."(-minimum-)ElevationInMeters__@DwC__@vegpath.org",


  		




  
  11878
  
    
    "viewFullOccurrence_individual_view"."slopeAspect[_deg]__@VegX__.plot@vegpath.org",


  		




  
  11879
  
    
    "viewFullOccurrence_individual_view"."slopeGradient[_deg]__@VegX__.plot@vegpath.org",


  		




  
  11880
  
    
    "viewFullOccurrence_individual_view"."plot.area[_ha]__@VegX__@vegpath.org",


  		




  
  11881
  
    
    "viewFullOccurrence_individual_view"."samplingProtocol__@DwC__@vegpath.org",


  		




  
  11882
  
    
    "viewFullOccurrence_individual_view"."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",


  		




  
  11883
  
    
    "viewFullOccurrence_individual_view"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",


  		




  
  11884
  
    
    "viewFullOccurrence_individual_view"."stratumName__@VegX__.stratum@vegpath.org",


  		




  
  11885
  
    
    "viewFullOccurrence_individual_view"."communityConcept.name__@VegX__.communityDet@vegpath.org",


  		




  
  11886
  
    
    "viewFullOccurrence_individual_view"."observationContributor[s]__@VegBank__@vegpath.org",


  		




  
  11887
  
    
    "viewFullOccurrence_individual_view"."[custodial_]institutionCode[s]__@DwC__@vegpath.org",


  		




  
  11888
  
    
    "viewFullOccurrence_individual_view"."collectionCode__@DwC__@vegpath.org",


  		




  
  11889
  
    
    "viewFullOccurrence_individual_view"."catalogNumber__@DwC__@vegpath.org",


  		




  
  11890
  
    
    "viewFullOccurrence_individual_view"."occurrenceID__@DwC__@vegpath.org",


  		




  
  11891
  
    
    "viewFullOccurrence_individual_view"."recordedBy__@DwC__@vegpath.org",


  		




  
  11892
  
    
    "viewFullOccurrence_individual_view"."recordNumber__@DwC__@vegpath.org",


  		




  
  11893
  
    
    "viewFullOccurrence_individual_view"."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",


  		




  
  11894
  
    
    "viewFullOccurrence_individual_view"."[verbatim_]family__@DwC__@vegpath.org",


  		




  
  11895
  
    
    "viewFullOccurrence_individual_view"."[verbatim_]scientificName__@DwC__@vegpath.org",


  		




  
  11896
  
    
    "viewFullOccurrence_individual_view"."identifiedBy__@DwC__@vegpath.org",


  		




  
  11897
  
    
    "viewFullOccurrence_individual_view"."dateIdentified__@DwC__@vegpath.org",


  		




  
  11898
  
    
    "viewFullOccurrence_individual_view"."identificationRemarks__@DwC__@vegpath.org",


  		




  
  11899
  
    
    "viewFullOccurrence_individual_view"."Family_matched__@TNRS__@vegpath.org",


  		




  
  11900
  
    
    "viewFullOccurrence_individual_view"."Name_matched__@TNRS__@vegpath.org",


  		




  
  11901
  
    
    "viewFullOccurrence_individual_view"."Name_matched_author__@TNRS__@vegpath.org",


  		




  
  11902
  
    
    "viewFullOccurrence_individual_view"."[higher_plant_group~]higherClassification__@DwC__@vegpath.org",


  		




  
  11903
  
    
    "viewFullOccurrence_individual_view"."taxonomicStatus__@DwC__@vegpath.org",


  		




  
  11904
  
    
    "viewFullOccurrence_individual_view".scrubbed_family,


  		




  
  11905
  
    
    "viewFullOccurrence_individual_view".scrubbed_genus,


  		




  
  11906
  
    
    "viewFullOccurrence_individual_view".scrubbed_specific_epithet,


  		




  
  11907
  
    
    "viewFullOccurrence_individual_view".scrubbed_species_binomial,


  		




  
  11908
  
    
    "viewFullOccurrence_individual_view".scrubbed_taxon_name_no_author,


  		




  
  11909
  
    
    "viewFullOccurrence_individual_view".scrubbed_author,


  		




  
  11910
  
    
    "viewFullOccurrence_individual_view".scrubbed_taxon_name_with_author,


  		




  
  11911
  
    
    "viewFullOccurrence_individual_view"."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org",


  		




  
  11912
  
    
    "viewFullOccurrence_individual_view"."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",


  		




  
  11913
  
    
    "viewFullOccurrence_individual_view"."reproductiveCondition__@DwC__@vegpath.org",


  		




  
  11914
  
    
    "viewFullOccurrence_individual_view".cultivated_bien,


  		




  
  11915
  
    
    "viewFullOccurrence_individual_view"."cultivatedBasis_bien",


  		




  
  11916
  
    
    "viewFullOccurrence_individual_view"."occurrenceRemarks__@DwC__@vegpath.org",


  		




  
  11917
  
    
    "viewFullOccurrence_individual_view"."coverPercent__@VegX__.attribute.ordinal@vegpath.org",


  		




  
  11918
  
    
    "viewFullOccurrence_individual_view"."taxonObservation[.id]__@VegBank__@vegpath.org",


  		




  
  11919
  
    
    "viewFullOccurrence_individual_view"."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",


  		




  
  11920
  
    
    "viewFullOccurrence_individual_view"."aggregateOrganismObservation.id__@VegX__@vegpath.org",


  		




  
  11921
  
    
    "viewFullOccurrence_individual_view"."individualOrganismObservation.id__@VegX__@vegpath.org",


  		




  
  11922
  
    
    "viewFullOccurrence_individual_view"."individualID__@DwC__@vegpath.org",


  		




  
  11923
  
    
    "viewFullOccurrence_individual_view"."individualCount__@DwC__@vegpath.org",


  		




  
  11924
  
    
    "viewFullOccurrence_individual_view"."plantobservation.""_id__@VegBIEN__.public@vegpath.org"


  		




  
  11925
  
    
   FROM "viewFullOccurrence_individual_view"


  		




  
  11926
  
    
  WHERE ("viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org" = 'VegBank'::text);


  		




  
  11927
  
    

  		




  
  11928
  
    

  		




  
  11929
  
    
--


  		




  11699
  11930
  
    
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  11700
  11931
  
    
--


  		




  11701
  11932
  
    

  		




  ......




  19597
  19828
  
    

  		




  19598
  19829
  
    

  		




  19599
  19830
  
    
--


  		




  
  19831
  
    
-- Name: viewFullOccurrence_CVS; Type: ACL; Schema: public; Owner: -


  		




  
  19832
  
    
--


  		




  
  19833
  
    

  		




  
  19834
  
    
REVOKE ALL ON TABLE "viewFullOccurrence_CVS" FROM PUBLIC;


  		




  
  19835
  
    
REVOKE ALL ON TABLE "viewFullOccurrence_CVS" FROM bien;


  		




  
  19836
  
    
GRANT ALL ON TABLE "viewFullOccurrence_CVS" TO bien;


  		




  
  19837
  
    
GRANT SELECT ON TABLE "viewFullOccurrence_CVS" TO bien_read;


  		




  
  19838
  
    

  		




  
  19839
  
    

  		




  
  19840
  
    
--


  		




  
  19841
  
    
-- Name: viewFullOccurrence_NCU; Type: ACL; Schema: public; Owner: -


  		




  
  19842
  
    
--


  		




  
  19843
  
    

  		




  
  19844
  
    
REVOKE ALL ON TABLE "viewFullOccurrence_NCU" FROM PUBLIC;


  		




  
  19845
  
    
REVOKE ALL ON TABLE "viewFullOccurrence_NCU" FROM bien;


  		




  
  19846
  
    
GRANT ALL ON TABLE "viewFullOccurrence_NCU" TO bien;


  		




  
  19847
  
    
GRANT SELECT ON TABLE "viewFullOccurrence_NCU" TO bien_read;


  		




  
  19848
  
    

  		




  
  19849
  
    

  		




  
  19850
  
    
--


  		




  
  19851
  
    
-- Name: viewFullOccurrence_VegBank; Type: ACL; Schema: public; Owner: -


  		




  
  19852
  
    
--


  		




  
  19853
  
    

  		




  
  19854
  
    
REVOKE ALL ON TABLE "viewFullOccurrence_VegBank" FROM PUBLIC;


  		




  
  19855
  
    
REVOKE ALL ON TABLE "viewFullOccurrence_VegBank" FROM bien;


  		




  
  19856
  
    
GRANT ALL ON TABLE "viewFullOccurrence_VegBank" TO bien;


  		




  
  19857
  
    
GRANT SELECT ON TABLE "viewFullOccurrence_VegBank" TO bien_read;


  		




  
  19858
  
    

  		




  
  19859
  
    

  		




  
  19860
  
    
--


  		




  19600
  19861
  
    
-- Name: voucher; Type: ACL; Schema: public; Owner: -


  		




  19601
  19862
  
    
--


  		




  19602
  19863
  
    

  		












  

    
      trunk/schemas/vegbien.sql
    
  





  11696
  11696
  
    

  		




  11697
  11697
  
    

  		




  11698
  11698
  
    
--


  		




  
  11699
  
    
-- Name: viewFullOccurrence_CVS; Type: VIEW; Schema: public; Owner: -


  		




  
  11700
  
    
--


  		




  
  11701
  
    

  		




  
  11702
  
    
CREATE VIEW "viewFullOccurrence_CVS" AS


  		




  
  11703
  
    
 SELECT "viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org",


  		




  
  11704
  
    
    "viewFullOccurrence_individual_view"."country__@DwC__@vegpath.org",


  		




  
  11705
  
    
    "viewFullOccurrence_individual_view"."stateProvince__@DwC__@vegpath.org",


  		




  
  11706
  
    
    "viewFullOccurrence_individual_view"."county__@DwC__@vegpath.org",


  		




  
  11707
  
    
    "viewFullOccurrence_individual_view"."locality__@DwC__@vegpath.org",


  		




  
  11708
  
    
    "viewFullOccurrence_individual_view"."decimalLatitude__@DwC__@vegpath.org",


  		




  
  11709
  
    
    "viewFullOccurrence_individual_view"."decimalLongitude__@DwC__@vegpath.org",


  		




  
  11710
  
    
    "viewFullOccurrence_individual_view"."coordinateUncertaintyInMeters__@DwC__@vegpath.org",


  		




  
  11711
  
    
    "viewFullOccurrence_individual_view"."georeferenceSources__@DwC__@vegpath.org",


  		




  
  11712
  
    
    "viewFullOccurrence_individual_view"."georeferenceProtocol__@DwC__@vegpath.org",


  		




  
  11713
  
    
    "viewFullOccurrence_individual_view".geovalid_bien,


  		




  
  11714
  
    
    "viewFullOccurrence_individual_view"."isNewWorld_bien",


  		




  
  11715
  
    
    "viewFullOccurrence_individual_view"."projectID__@VegX__.plotObservation@vegpath.org",


  		




  
  11716
  
    
    "viewFullOccurrence_individual_view"."projectContributor[s]__@VegBank__@vegpath.org",


  		




  
  11717
  
    
    "viewFullOccurrence_individual_view"."locationID__@DwC__@vegpath.org",


  		




  
  11718
  
    
    "viewFullOccurrence_individual_view"."plotName__@VegX__.plot@vegpath.org",


  		




  
  11719
  
    
    "viewFullOccurrence_individual_view"."subplot__@SALVIAS__.Plot_data@vegpath.org",


  		




  
  11720
  
    
    "viewFullOccurrence_individual_view".location__cultivated__bien,


  		




  
  11721
  
    
    "viewFullOccurrence_individual_view"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org",


  		




  
  11722
  
    
    "viewFullOccurrence_individual_view"."eventDate__@DwC__@vegpath.org",


  		




  
  11723
  
    
    "viewFullOccurrence_individual_view"."(-minimum-)ElevationInMeters__@DwC__@vegpath.org",


  		




  
  11724
  
    
    "viewFullOccurrence_individual_view"."slopeAspect[_deg]__@VegX__.plot@vegpath.org",


  		




  
  11725
  
    
    "viewFullOccurrence_individual_view"."slopeGradient[_deg]__@VegX__.plot@vegpath.org",


  		




  
  11726
  
    
    "viewFullOccurrence_individual_view"."plot.area[_ha]__@VegX__@vegpath.org",


  		




  
  11727
  
    
    "viewFullOccurrence_individual_view"."samplingProtocol__@DwC__@vegpath.org",


  		




  
  11728
  
    
    "viewFullOccurrence_individual_view"."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",


  		




  
  11729
  
    
    "viewFullOccurrence_individual_view"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",


  		




  
  11730
  
    
    "viewFullOccurrence_individual_view"."stratumName__@VegX__.stratum@vegpath.org",


  		




  
  11731
  
    
    "viewFullOccurrence_individual_view"."communityConcept.name__@VegX__.communityDet@vegpath.org",


  		




  
  11732
  
    
    "viewFullOccurrence_individual_view"."observationContributor[s]__@VegBank__@vegpath.org",


  		




  
  11733
  
    
    "viewFullOccurrence_individual_view"."[custodial_]institutionCode[s]__@DwC__@vegpath.org",


  		




  
  11734
  
    
    "viewFullOccurrence_individual_view"."collectionCode__@DwC__@vegpath.org",


  		




  
  11735
  
    
    "viewFullOccurrence_individual_view"."catalogNumber__@DwC__@vegpath.org",


  		




  
  11736
  
    
    "viewFullOccurrence_individual_view"."occurrenceID__@DwC__@vegpath.org",


  		




  
  11737
  
    
    "viewFullOccurrence_individual_view"."recordedBy__@DwC__@vegpath.org",


  		




  
  11738
  
    
    "viewFullOccurrence_individual_view"."recordNumber__@DwC__@vegpath.org",


  		




  
  11739
  
    
    "viewFullOccurrence_individual_view"."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",


  		




  
  11740
  
    
    "viewFullOccurrence_individual_view"."[verbatim_]family__@DwC__@vegpath.org",


  		




  
  11741
  
    
    "viewFullOccurrence_individual_view"."[verbatim_]scientificName__@DwC__@vegpath.org",


  		




  
  11742
  
    
    "viewFullOccurrence_individual_view"."identifiedBy__@DwC__@vegpath.org",


  		




  
  11743
  
    
    "viewFullOccurrence_individual_view"."dateIdentified__@DwC__@vegpath.org",


  		




  
  11744
  
    
    "viewFullOccurrence_individual_view"."identificationRemarks__@DwC__@vegpath.org",


  		




  
  11745
  
    
    "viewFullOccurrence_individual_view"."Family_matched__@TNRS__@vegpath.org",


  		




  
  11746
  
    
    "viewFullOccurrence_individual_view"."Name_matched__@TNRS__@vegpath.org",


  		




  
  11747
  
    
    "viewFullOccurrence_individual_view"."Name_matched_author__@TNRS__@vegpath.org",


  		




  
  11748
  
    
    "viewFullOccurrence_individual_view"."[higher_plant_group~]higherClassification__@DwC__@vegpath.org",


  		




  
  11749
  
    
    "viewFullOccurrence_individual_view"."taxonomicStatus__@DwC__@vegpath.org",


  		




  
  11750
  
    
    "viewFullOccurrence_individual_view".scrubbed_family,


  		




  
  11751
  
    
    "viewFullOccurrence_individual_view".scrubbed_genus,


  		




  
  11752
  
    
    "viewFullOccurrence_individual_view".scrubbed_specific_epithet,


  		




  
  11753
  
    
    "viewFullOccurrence_individual_view".scrubbed_species_binomial,


  		




  
  11754
  
    
    "viewFullOccurrence_individual_view".scrubbed_taxon_name_no_author,


  		




  
  11755
  
    
    "viewFullOccurrence_individual_view".scrubbed_author,


  		




  
  11756
  
    
    "viewFullOccurrence_individual_view".scrubbed_taxon_name_with_author,


  		




  
  11757
  
    
    "viewFullOccurrence_individual_view"."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org",


  		




  
  11758
  
    
    "viewFullOccurrence_individual_view"."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",


  		




  
  11759
  
    
    "viewFullOccurrence_individual_view"."reproductiveCondition__@DwC__@vegpath.org",


  		




  
  11760
  
    
    "viewFullOccurrence_individual_view".cultivated_bien,


  		




  
  11761
  
    
    "viewFullOccurrence_individual_view"."cultivatedBasis_bien",


  		




  
  11762
  
    
    "viewFullOccurrence_individual_view"."occurrenceRemarks__@DwC__@vegpath.org",


  		




  
  11763
  
    
    "viewFullOccurrence_individual_view"."coverPercent__@VegX__.attribute.ordinal@vegpath.org",


  		




  
  11764
  
    
    "viewFullOccurrence_individual_view"."taxonObservation[.id]__@VegBank__@vegpath.org",


  		




  
  11765
  
    
    "viewFullOccurrence_individual_view"."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",


  		




  
  11766
  
    
    "viewFullOccurrence_individual_view"."aggregateOrganismObservation.id__@VegX__@vegpath.org",


  		




  
  11767
  
    
    "viewFullOccurrence_individual_view"."individualOrganismObservation.id__@VegX__@vegpath.org",


  		




  
  11768
  
    
    "viewFullOccurrence_individual_view"."individualID__@DwC__@vegpath.org",


  		




  
  11769
  
    
    "viewFullOccurrence_individual_view"."individualCount__@DwC__@vegpath.org",


  		




  
  11770
  
    
    "viewFullOccurrence_individual_view"."plantobservation.""_id__@VegBIEN__.public@vegpath.org"


  		




  
  11771
  
    
   FROM "viewFullOccurrence_individual_view"


  		




  
  11772
  
    
  WHERE ("viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org" = 'CVS'::text);


  		




  
  11773
  
    

  		




  
  11774
  
    

  		




  
  11775
  
    
--


  		




  
  11776
  
    
-- Name: viewFullOccurrence_NCU; Type: VIEW; Schema: public; Owner: -


  		




  
  11777
  
    
--


  		




  
  11778
  
    

  		




  
  11779
  
    
CREATE VIEW "viewFullOccurrence_NCU" AS


  		




  
  11780
  
    
 SELECT "viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org",


  		




  
  11781
  
    
    "viewFullOccurrence_individual_view"."country__@DwC__@vegpath.org",


  		




  
  11782
  
    
    "viewFullOccurrence_individual_view"."stateProvince__@DwC__@vegpath.org",


  		




  
  11783
  
    
    "viewFullOccurrence_individual_view"."county__@DwC__@vegpath.org",


  		




  
  11784
  
    
    "viewFullOccurrence_individual_view"."locality__@DwC__@vegpath.org",


  		




  
  11785
  
    
    "viewFullOccurrence_individual_view"."decimalLatitude__@DwC__@vegpath.org",


  		




  
  11786
  
    
    "viewFullOccurrence_individual_view"."decimalLongitude__@DwC__@vegpath.org",


  		




  
  11787
  
    
    "viewFullOccurrence_individual_view"."coordinateUncertaintyInMeters__@DwC__@vegpath.org",


  		




  
  11788
  
    
    "viewFullOccurrence_individual_view"."georeferenceSources__@DwC__@vegpath.org",


  		




  
  11789
  
    
    "viewFullOccurrence_individual_view"."georeferenceProtocol__@DwC__@vegpath.org",


  		




  
  11790
  
    
    "viewFullOccurrence_individual_view".geovalid_bien,


  		




  
  11791
  
    
    "viewFullOccurrence_individual_view"."isNewWorld_bien",


  		




  
  11792
  
    
    "viewFullOccurrence_individual_view"."projectID__@VegX__.plotObservation@vegpath.org",


  		




  
  11793
  
    
    "viewFullOccurrence_individual_view"."projectContributor[s]__@VegBank__@vegpath.org",


  		




  
  11794
  
    
    "viewFullOccurrence_individual_view"."locationID__@DwC__@vegpath.org",


  		




  
  11795
  
    
    "viewFullOccurrence_individual_view"."plotName__@VegX__.plot@vegpath.org",


  		




  
  11796
  
    
    "viewFullOccurrence_individual_view"."subplot__@SALVIAS__.Plot_data@vegpath.org",


  		




  
  11797
  
    
    "viewFullOccurrence_individual_view".location__cultivated__bien,


  		




  
  11798
  
    
    "viewFullOccurrence_individual_view"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org",


  		




  
  11799
  
    
    "viewFullOccurrence_individual_view"."eventDate__@DwC__@vegpath.org",


  		




  
  11800
  
    
    "viewFullOccurrence_individual_view"."(-minimum-)ElevationInMeters__@DwC__@vegpath.org",


  		




  
  11801
  
    
    "viewFullOccurrence_individual_view"."slopeAspect[_deg]__@VegX__.plot@vegpath.org",


  		




  
  11802
  
    
    "viewFullOccurrence_individual_view"."slopeGradient[_deg]__@VegX__.plot@vegpath.org",


  		




  
  11803
  
    
    "viewFullOccurrence_individual_view"."plot.area[_ha]__@VegX__@vegpath.org",


  		




  
  11804
  
    
    "viewFullOccurrence_individual_view"."samplingProtocol__@DwC__@vegpath.org",


  		




  
  11805
  
    
    "viewFullOccurrence_individual_view"."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",


  		




  
  11806
  
    
    "viewFullOccurrence_individual_view"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",


  		




  
  11807
  
    
    "viewFullOccurrence_individual_view"."stratumName__@VegX__.stratum@vegpath.org",


  		




  
  11808
  
    
    "viewFullOccurrence_individual_view"."communityConcept.name__@VegX__.communityDet@vegpath.org",


  		




  
  11809
  
    
    "viewFullOccurrence_individual_view"."observationContributor[s]__@VegBank__@vegpath.org",


  		




  
  11810
  
    
    "viewFullOccurrence_individual_view"."[custodial_]institutionCode[s]__@DwC__@vegpath.org",


  		




  
  11811
  
    
    "viewFullOccurrence_individual_view"."collectionCode__@DwC__@vegpath.org",


  		




  
  11812
  
    
    "viewFullOccurrence_individual_view"."catalogNumber__@DwC__@vegpath.org",


  		




  
  11813
  
    
    "viewFullOccurrence_individual_view"."occurrenceID__@DwC__@vegpath.org",


  		




  
  11814
  
    
    "viewFullOccurrence_individual_view"."recordedBy__@DwC__@vegpath.org",


  		




  
  11815
  
    
    "viewFullOccurrence_individual_view"."recordNumber__@DwC__@vegpath.org",


  		




  
  11816
  
    
    "viewFullOccurrence_individual_view"."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",


  		




  
  11817
  
    
    "viewFullOccurrence_individual_view"."[verbatim_]family__@DwC__@vegpath.org",


  		




  
  11818
  
    
    "viewFullOccurrence_individual_view"."[verbatim_]scientificName__@DwC__@vegpath.org",


  		




  
  11819
  
    
    "viewFullOccurrence_individual_view"."identifiedBy__@DwC__@vegpath.org",


  		




  
  11820
  
    
    "viewFullOccurrence_individual_view"."dateIdentified__@DwC__@vegpath.org",


  		




  
  11821
  
    
    "viewFullOccurrence_individual_view"."identificationRemarks__@DwC__@vegpath.org",


  		




  
  11822
  
    
    "viewFullOccurrence_individual_view"."Family_matched__@TNRS__@vegpath.org",


  		




  
  11823
  
    
    "viewFullOccurrence_individual_view"."Name_matched__@TNRS__@vegpath.org",


  		




  
  11824
  
    
    "viewFullOccurrence_individual_view"."Name_matched_author__@TNRS__@vegpath.org",


  		




  
  11825
  
    
    "viewFullOccurrence_individual_view"."[higher_plant_group~]higherClassification__@DwC__@vegpath.org",


  		




  
  11826
  
    
    "viewFullOccurrence_individual_view"."taxonomicStatus__@DwC__@vegpath.org",


  		




  
  11827
  
    
    "viewFullOccurrence_individual_view".scrubbed_family,


  		




  
  11828
  
    
    "viewFullOccurrence_individual_view".scrubbed_genus,


  		




  
  11829
  
    
    "viewFullOccurrence_individual_view".scrubbed_specific_epithet,


  		




  
  11830
  
    
    "viewFullOccurrence_individual_view".scrubbed_species_binomial,


  		




  
  11831
  
    
    "viewFullOccurrence_individual_view".scrubbed_taxon_name_no_author,


  		




  
  11832
  
    
    "viewFullOccurrence_individual_view".scrubbed_author,


  		




  
  11833
  
    
    "viewFullOccurrence_individual_view".scrubbed_taxon_name_with_author,


  		




  
  11834
  
    
    "viewFullOccurrence_individual_view"."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org",


  		




  
  11835
  
    
    "viewFullOccurrence_individual_view"."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",


  		




  
  11836
  
    
    "viewFullOccurrence_individual_view"."reproductiveCondition__@DwC__@vegpath.org",


  		




  
  11837
  
    
    "viewFullOccurrence_individual_view".cultivated_bien,


  		




  
  11838
  
    
    "viewFullOccurrence_individual_view"."cultivatedBasis_bien",


  		




  
  11839
  
    
    "viewFullOccurrence_individual_view"."occurrenceRemarks__@DwC__@vegpath.org",


  		




  
  11840
  
    
    "viewFullOccurrence_individual_view"."coverPercent__@VegX__.attribute.ordinal@vegpath.org",


  		




  
  11841
  
    
    "viewFullOccurrence_individual_view"."taxonObservation[.id]__@VegBank__@vegpath.org",


  		




  
  11842
  
    
    "viewFullOccurrence_individual_view"."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",


  		




  
  11843
  
    
    "viewFullOccurrence_individual_view"."aggregateOrganismObservation.id__@VegX__@vegpath.org",


  		




  
  11844
  
    
    "viewFullOccurrence_individual_view"."individualOrganismObservation.id__@VegX__@vegpath.org",


  		




  
  11845
  
    
    "viewFullOccurrence_individual_view"."individualID__@DwC__@vegpath.org",


  		




  
  11846
  
    
    "viewFullOccurrence_individual_view"."individualCount__@DwC__@vegpath.org",


  		




  
  11847
  
    
    "viewFullOccurrence_individual_view"."plantobservation.""_id__@VegBIEN__.public@vegpath.org"


  		




  
  11848
  
    
   FROM "viewFullOccurrence_individual_view"


  		




  
  11849
  
    
  WHERE ("viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org" = 'NCU'::text);


  		




  
  11850
  
    

  		




  
  11851
  
    

  		




  
  11852
  
    
--


  		




  
  11853
  
    
-- Name: viewFullOccurrence_VegBank; Type: VIEW; Schema: public; Owner: -


  		




  
  11854
  
    
--


  		




  
  11855
  
    

  		




  
  11856
  
    
CREATE VIEW "viewFullOccurrence_VegBank" AS


  		




  
  11857
  
    
 SELECT "viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org",


  		




  
  11858
  
    
    "viewFullOccurrence_individual_view"."country__@DwC__@vegpath.org",


  		




  
  11859
  
    
    "viewFullOccurrence_individual_view"."stateProvince__@DwC__@vegpath.org",


  		




  
  11860
  
    
    "viewFullOccurrence_individual_view"."county__@DwC__@vegpath.org",


  		




  
  11861
  
    
    "viewFullOccurrence_individual_view"."locality__@DwC__@vegpath.org",


  		




  
  11862
  
    
    "viewFullOccurrence_individual_view"."decimalLatitude__@DwC__@vegpath.org",


  		




  
  11863
  
    
    "viewFullOccurrence_individual_view"."decimalLongitude__@DwC__@vegpath.org",


  		




  
  11864
  
    
    "viewFullOccurrence_individual_view"."coordinateUncertaintyInMeters__@DwC__@vegpath.org",


  		




  
  11865
  
    
    "viewFullOccurrence_individual_view"."georeferenceSources__@DwC__@vegpath.org",


  		




  
  11866
  
    
    "viewFullOccurrence_individual_view"."georeferenceProtocol__@DwC__@vegpath.org",


  		




  
  11867
  
    
    "viewFullOccurrence_individual_view".geovalid_bien,


  		




  
  11868
  
    
    "viewFullOccurrence_individual_view"."isNewWorld_bien",


  		




  
  11869
  
    
    "viewFullOccurrence_individual_view"."projectID__@VegX__.plotObservation@vegpath.org",


  		




  
  11870
  
    
    "viewFullOccurrence_individual_view"."projectContributor[s]__@VegBank__@vegpath.org",


  		




  
  11871
  
    
    "viewFullOccurrence_individual_view"."locationID__@DwC__@vegpath.org",


  		




  
  11872
  
    
    "viewFullOccurrence_individual_view"."plotName__@VegX__.plot@vegpath.org",


  		




  
  11873
  
    
    "viewFullOccurrence_individual_view"."subplot__@SALVIAS__.Plot_data@vegpath.org",


  		




  
  11874
  
    
    "viewFullOccurrence_individual_view".location__cultivated__bien,


  		




  
  11875
  
    
    "viewFullOccurrence_individual_view"."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org",


  		




  
  11876
  
    
    "viewFullOccurrence_individual_view"."eventDate__@DwC__@vegpath.org",


  		




  
  11877
  
    
    "viewFullOccurrence_individual_view"."(-minimum-)ElevationInMeters__@DwC__@vegpath.org",


  		




  
  11878
  
    
    "viewFullOccurrence_individual_view"."slopeAspect[_deg]__@VegX__.plot@vegpath.org",


  		




  
  11879
  
    
    "viewFullOccurrence_individual_view"."slopeGradient[_deg]__@VegX__.plot@vegpath.org",


  		




  
  11880
  
    
    "viewFullOccurrence_individual_view"."plot.area[_ha]__@VegX__@vegpath.org",


  		




  
  11881
  
    
    "viewFullOccurrence_individual_view"."samplingProtocol__@DwC__@vegpath.org",


  		




  
  11882
  
    
    "viewFullOccurrence_individual_view"."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",


  		




  
  11883
  
    
    "viewFullOccurrence_individual_view"."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",


  		




  
  11884
  
    
    "viewFullOccurrence_individual_view"."stratumName__@VegX__.stratum@vegpath.org",


  		




  
  11885
  
    
    "viewFullOccurrence_individual_view"."communityConcept.name__@VegX__.communityDet@vegpath.org",


  		




  
  11886
  
    
    "viewFullOccurrence_individual_view"."observationContributor[s]__@VegBank__@vegpath.org",


  		




  
  11887
  
    
    "viewFullOccurrence_individual_view"."[custodial_]institutionCode[s]__@DwC__@vegpath.org",


  		




  
  11888
  
    
    "viewFullOccurrence_individual_view"."collectionCode__@DwC__@vegpath.org",


  		




  
  11889
  
    
    "viewFullOccurrence_individual_view"."catalogNumber__@DwC__@vegpath.org",


  		




  
  11890
  
    
    "viewFullOccurrence_individual_view"."occurrenceID__@DwC__@vegpath.org",


  		




  
  11891
  
    
    "viewFullOccurrence_individual_view"."recordedBy__@DwC__@vegpath.org",


  		




  
  11892
  
    
    "viewFullOccurrence_individual_view"."recordNumber__@DwC__@vegpath.org",


  		




  
  11893
  
    
    "viewFullOccurrence_individual_view"."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",


  		




  
  11894
  
    
    "viewFullOccurrence_individual_view"."[verbatim_]family__@DwC__@vegpath.org",


  		




  
  11895
  
    
    "viewFullOccurrence_individual_view"."[verbatim_]scientificName__@DwC__@vegpath.org",


  		




  
  11896
  
    
    "viewFullOccurrence_individual_view"."identifiedBy__@DwC__@vegpath.org",


  		




  
  11897
  
    
    "viewFullOccurrence_individual_view"."dateIdentified__@DwC__@vegpath.org",


  		




  
  11898
  
    
    "viewFullOccurrence_individual_view"."identificationRemarks__@DwC__@vegpath.org",


  		




  
  11899
  
    
    "viewFullOccurrence_individual_view"."Family_matched__@TNRS__@vegpath.org",


  		




  
  11900
  
    
    "viewFullOccurrence_individual_view"."Name_matched__@TNRS__@vegpath.org",


  		




  
  11901
  
    
    "viewFullOccurrence_individual_view"."Name_matched_author__@TNRS__@vegpath.org",


  		




  
  11902
  
    
    "viewFullOccurrence_individual_view"."[higher_plant_group~]higherClassification__@DwC__@vegpath.org",


  		




  
  11903
  
    
    "viewFullOccurrence_individual_view"."taxonomicStatus__@DwC__@vegpath.org",


  		




  
  11904
  
    
    "viewFullOccurrence_individual_view".scrubbed_family,


  		




  
  11905
  
    
    "viewFullOccurrence_individual_view".scrubbed_genus,


  		




  
  11906
  
    
    "viewFullOccurrence_individual_view".scrubbed_specific_epithet,


  		




  
  11907
  
    
    "viewFullOccurrence_individual_view".scrubbed_species_binomial,


  		




  
  11908
  
    
    "viewFullOccurrence_individual_view".scrubbed_taxon_name_no_author,


  		




  
  11909
  
    
    "viewFullOccurrence_individual_view".scrubbed_author,


  		




  
  11910
  
    
    "viewFullOccurrence_individual_view".scrubbed_taxon_name_with_author,


  		




  
  11911
  
    
    "viewFullOccurrence_individual_view"."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org",


  		




  
  11912
  
    
    "viewFullOccurrence_individual_view"."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",


  		




  
  11913
  
    
    "viewFullOccurrence_individual_view"."reproductiveCondition__@DwC__@vegpath.org",


  		




  
  11914
  
    
    "viewFullOccurrence_individual_view".cultivated_bien,


  		




  
  11915
  
    
    "viewFullOccurrence_individual_view"."cultivatedBasis_bien",


  		




  
  11916
  
    
    "viewFullOccurrence_individual_view"."occurrenceRemarks__@DwC__@vegpath.org",


  		




  
  11917
  
    
    "viewFullOccurrence_individual_view"."coverPercent__@VegX__.attribute.ordinal@vegpath.org",


  		




  
  11918
  
    
    "viewFullOccurrence_individual_view"."taxonObservation[.id]__@VegBank__@vegpath.org",


  		




  
  11919
  
    
    "viewFullOccurrence_individual_view"."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",


  		




  
  11920
  
    
    "viewFullOccurrence_individual_view"."aggregateOrganismObservation.id__@VegX__@vegpath.org",


  		




  
  11921
  
    
    "viewFullOccurrence_individual_view"."individualOrganismObservation.id__@VegX__@vegpath.org",


  		




  
  11922
  
    
    "viewFullOccurrence_individual_view"."individualID__@DwC__@vegpath.org",


  		




  
  11923
  
    
    "viewFullOccurrence_individual_view"."individualCount__@DwC__@vegpath.org",


  		




  
  11924
  
    
    "viewFullOccurrence_individual_view"."plantobservation.""_id__@VegBIEN__.public@vegpath.org"


  		




  
  11925
  
    
   FROM "viewFullOccurrence_individual_view"


  		




  
  11926
  
    
  WHERE ("viewFullOccurrence_individual_view"."datasource__@Brad__.identifier_examples@vegpath.org" = 'VegBank'::text);


  		




  
  11927
  
    

  		




  
  11928
  
    

  		




  
  11929
  
    
--


  		




  11699
  11930
  
    
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 


  		




  11700
  11931
  
    
--


  		




  11701
  11932
  
    

  		




  ......




  19597
  19828
  
    

  		




  19598
  19829
  
    

  		




  19599
  19830
  
    
--


  		




  
  19831
  
    
-- Name: viewFullOccurrence_CVS; Type: ACL; Schema: public; Owner: -


  		




  
  19832
  
    
--


  		




  
  19833
  
    

  		




  
  19834
  
    
REVOKE ALL ON TABLE "viewFullOccurrence_CVS" FROM PUBLIC;


  		




  
  19835
  
    
REVOKE ALL ON TABLE "viewFullOccurrence_CVS" FROM bien;


  		




  
  19836
  
    
GRANT ALL ON TABLE "viewFullOccurrence_CVS" TO bien;


  		




  
  19837
  
    
GRANT SELECT ON TABLE "viewFullOccurrence_CVS" TO bien_read;


  		




  
  19838
  
    

  		




  
  19839
  
    

  		




  
  19840
  
    
--


  		




  
  19841
  
    
-- Name: viewFullOccurrence_NCU; Type: ACL; Schema: public; Owner: -


  		




  
  19842
  
    
--


  		




  
  19843
  
    

  		




  
  19844
  
    
REVOKE ALL ON TABLE "viewFullOccurrence_NCU" FROM PUBLIC;


  		




  
  19845
  
    
REVOKE ALL ON TABLE "viewFullOccurrence_NCU" FROM bien;


  		




  
  19846
  
    
GRANT ALL ON TABLE "viewFullOccurrence_NCU" TO bien;


  		




  
  19847
  
    
GRANT SELECT ON TABLE "viewFullOccurrence_NCU" TO bien_read;


  		




  
  19848
  
    

  		




  
  19849
  
    

  		




  
  19850
  
    
--


  		




  
  19851
  
    
-- Name: viewFullOccurrence_VegBank; Type: ACL; Schema: public; Owner: -


  		




  
  19852
  
    
--


  		




  
  19853
  
    

  		




  
  19854
  
    
REVOKE ALL ON TABLE "viewFullOccurrence_VegBank" FROM PUBLIC;


  		




  
  19855
  
    
REVOKE ALL ON TABLE "viewFullOccurrence_VegBank" FROM bien;


  		




  
  19856
  
    
GRANT ALL ON TABLE "viewFullOccurrence_VegBank" TO bien;


  		




  
  19857
  
    
GRANT SELECT ON TABLE "viewFullOccurrence_VegBank" TO bien_read;


  		




  
  19858
  
    

  		




  
  19859
  
    

  		




  
  19860
  
    
--


  		




  19600
  19861
  
    
-- Name: voucher; Type: ACL; Schema: public; Owner: -


  		




  19601
  19862
  
    
--


  		




  19602
  19863
  
    

  		












Also available in:  Unified diff