Project

General

Profile

« Previous | Next » 

Revision 4951

Added by Aaron Marcuse-Kubitza over 12 years ago

inputs/UNCC/Specimen/map.csv: accession: Documented that it's globally unique, although occasionally duplicated

View differences:

inputs/UNCC/Specimen/map.csv
1 1 
UNCC,VegCore,Filter,Comments
2 
accession,occurrenceID,,
2 
accession,occurrenceID,,"Globally unique, although occasionally duplicated. [1]
3 

  		




  
  4
  
    
[1] Using the following query:


  		




  
  5
  
    
-----


  		




  
  6
  
    
SELECT herbarium, accession, count(*)


  		




  
  7
  
    
FROM ""UNCC"".""Specimen""


  		




  
  8
  
    
GROUP BY herbarium, accession


  		




  
  9
  
    
HAVING count(*) > 1


  		




  
  10
  
    
-----"


  		




  3
  11
  
    
herbarium,institutionCode,,


  		




  4
  12
  
    
family,family,,


  		




  5
  13
  
    
genus,genus,,


  		












  

    
      inputs/UNCC/Specimen/VegBIEN.csv
    
  





  1
  1
  
    
UNCC,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments


  		




  2
  
  
    
accession,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",


  		




  
  2
  
    
accession,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1","Globally unique, although occasionally duplicated. [1]


  		




  
  3
  
    

  		




  
  4
  
    
[1] Using the following query:


  		




  
  5
  
    
-----


  		




  
  6
  
    
SELECT herbarium, accession, count(*)


  		




  
  7
  
    
FROM ""UNCC"".""Specimen""


  		




  
  8
  
    
GROUP BY herbarium, accession


  		




  
  9
  
    
HAVING count(*) > 1


  		




  
  10
  
    
-----"


  		




  3
  11
  
    
herbarium,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1",


  		




  4
  12
  
    
collday,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",


  		




  5
  13
  
    
collmonth,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",


  		




  ......




  13
  21
  
    
inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/7/_label[label=""in or out""]/value",


  		




  14
  22
  
    
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,


  		




  15
  23
  
    
herbarium,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,


  		




  16
  
  
    
accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,


  		




  
  24
  
    
accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,"Globally unique, although occasionally duplicated. [1]


  		




  
  25
  
    

  		




  
  26
  
    
[1] Using the following query:


  		




  
  27
  
    
-----


  		




  
  28
  
    
SELECT herbarium, accession, count(*)


  		




  
  29
  
    
FROM ""UNCC"".""Specimen""


  		




  
  30
  
    
GROUP BY herbarium, accession


  		




  
  31
  
    
HAVING count(*) > 1


  		




  
  32
  
    
-----"


  		




  17
  33
  
    
collectno,/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/1,


  		




  18
  34
  
    
SciName,/location/locationevent/taxonoccurrence/authortaxoncode/_first/2/_first/3,


  		




  19
  35
  
    
cultivated,/location/locationevent/taxonoccurrence/iscultivated/_alt/1,Ignore other values


  		




  20
  
  
    
accession,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,


  		




  
  36
  
    
accession,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,"Globally unique, although occasionally duplicated. [1]


  		




  
  37
  
    

  		




  
  38
  
    
[1] Using the following query:


  		




  
  39
  
    
-----


  		




  
  40
  
    
SELECT herbarium, accession, count(*)


  		




  
  41
  
    
FROM ""UNCC"".""Specimen""


  		




  
  42
  
    
GROUP BY herbarium, accession


  		




  
  43
  
    
HAVING count(*) > 1


  		




  
  44
  
    
-----"


  		




  21
  45
  
    
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,


  		




  22
  46
  
    
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,


  		




  23
  47
  
    
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,


  		












  

    
      inputs/UNCC/Specimen/new_terms.csv
    
  





  1
  
  
    
accession,occurrenceID,,


  		




  
  1
  
    
accession,occurrenceID,,"Globally unique, although occasionally duplicated. [1]


  		




  
  2
  
    

  		




  
  3
  
    
[1] Using the following query:


  		




  
  4
  
    
-----


  		




  
  5
  
    
SELECT herbarium, accession, count(*)


  		




  
  6
  
    
FROM ""UNCC"".""Specimen""


  		




  
  7
  
    
GROUP BY herbarium, accession


  		




  
  8
  
    
HAVING count(*) > 1


  		




  
  9
  
    
-----"


  		




  2
  10
  
    
herbarium,institutionCode,,


  		




  3
  11
  
    
usdaRank,taxonRank,/_alt/1,


  		




  4
  12
  
    
infrarank,taxonRank,/_alt/2,


  		












Also available in:  Unified diff