Project

General

Profile

« Previous | Next » 

Revision 7519

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/ARIZ/Specimen/map.csv: CollectorNumber/FieldNumber: Use /_first to map these identical fields to the same location

View differences:

inputs/ARIZ/Specimen/map.csv
7 7 
CatalogNumber,catalogNumber,/_alt/2,Don't overwrite CatalogNumberNumeric
8 8 
CatalogNumberNumeric,catalogNumber,/_alt/1,
9 9 
Collector,recordedBy,,
10 
CollectorNumber,recordNumber,,
11 
FieldNumber,OMIT,,"Usage inconsistent with DwC definition: meaning is recordNumber. Identical to CollectorNumber [1], so does not need to be mapped.
12 

  		




  13
  
  
    
[1] The following query returns no rows: SELECT * FROM ""ARIZ"".""Specimen"" WHERE ""CollectorNumber"" IS DISTINCT FROM ""FieldNumber"""


  		




  
  10
  
    
CollectorNumber,recordNumber,/_first/1,


  		




  
  11
  
    
FieldNumber,recordNumber,/_first/2,Identical to CollectorNumber


  		




  14
  12
  
    
YearCollected,yearCollected,,


  		




  15
  13
  
    
MonthCollected,monthCollected,,


  		




  16
  14
  
    
DayCollected,dayCollected,,


  		












  

    
      inputs/ARIZ/Specimen/VegBIEN.csv
    
  





  15
  15
  
    
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else/_alt/2",Don't overwrite CatalogNumberNumeric


  		




  16
  16
  
    
MaximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,"Contains some verbatim values, including ranges and units"


  		




  17
  17
  
    
MinimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,"Contains some verbatim values, including ranges and units"


  		




  18
  
  
    
CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  19
  18
  
    
GlobalUniqueIdentifier,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  
  19
  
    
CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_first/1",


  		




  
  20
  
    
FieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_first/2",Identical to CollectorNumber


  		




  20
  21
  
    
Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,


  		




  21
  22
  
    
DayIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",


  		




  22
  23
  
    
MonthIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",


  		




  ......




  29
  30
  
    
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",


  		




  30
  31
  
    
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,


  		




  31
  32
  
    
FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,


  		




  32
  
  
    
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,


  		




  
  33
  
    
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_first/1,


  		




  
  34
  
    
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_first/2,Identical to CollectorNumber


  		




  33
  35
  
    
Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"


  		




  34
  36
  
    
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else/_alt/1",


  		




  35
  37
  
    
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else/_alt/2",Don't overwrite CatalogNumberNumeric


  		




  36
  38
  
    
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Column names are reversed; Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name


  		




  37
  
  
    
CollectorNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",


  		




  
  39
  
    
CollectorNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_first/1",


  		




  
  40
  
    
FieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_first/2",Identical to CollectorNumber


  		




  38
  41
  
    
GlobalUniqueIdentifier,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",


  		




  39
  42
  
    
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists/_alt/1",


  		




  40
  43
  
    
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists/_alt/2",Don't overwrite CatalogNumberNumeric


  		




  41
  44
  
    
CollectionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",Column names are reversed


  		




  42
  45
  
    
CollectionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",Column names are reversed


  		




  43
  46
  
    
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,


  		




  44
  
  
    
CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",


  		




  
  47
  
    
CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_first/1",


  		




  
  48
  
    
FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_first/2",Identical to CollectorNumber


  		




  45
  49
  
    
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",Contains the binomial in addition to the authority


  		




  46
  50
  
    
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",


  		




  47
  51
  
    
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,


  		




  48
  
  
    
CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  49
  52
  
    
GlobalUniqueIdentifier,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  
  53
  
    
CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_first/1",


  		




  
  54
  
    
FieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_first/2",Identical to CollectorNumber


  		




  50
  55
  
    
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,


  		




  51
  56
  
    
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,


  		




  52
  57
  
    
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",


  		




  ......




  75
  80
  
    
IdentificationModifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,


  		




  76
  81
  
    
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/1",


  		




  77
  82
  
    
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/2",Don't overwrite CatalogNumberNumeric


  		




  78
  
  
    
CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",


  		




  
  83
  
    
CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_first/1",


  		




  
  84
  
    
FieldNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_first/2",Identical to CollectorNumber


  		




  79
  85
  
    
MaximumDepthInMeters,/location/locationevent/waterdepth_m/_avg/max,


  		




  80
  86
  
    
MinimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/min,


  		




  81
  87
  
    
Locality,/location/locationnarrative/_merge/1,


  		




  ......




  95
  101
  
    
AgeClass,,** No join mapping for lifeStage ** 


  		




  96
  102
  
    
BasisOfRecord,,** No join mapping for basisOfRecord ** 


  		




  97
  103
  
    
DateLastModified,,** No join mapping for modified ** 


  		




  98
  
  
    
FieldNumber,,"** No non-empty join mapping for OMIT ** Usage inconsistent with DwC definition: meaning is recordNumber. Identical to CollectorNumber [1], so does not need to be mapped.


  		




  99
  
  
    

  		




  100
  
  
    
[1] The following query returns no rows: SELECT * FROM ""ARIZ"".""Specimen"" WHERE ""CollectorNumber"" IS DISTINCT FROM ""FieldNumber"""


  		




  101
  104
  
    
GenBankNum,,"** No join mapping for associatedSequences/_label[label=""GenBank""]/value ** "


  		




  102
  105
  
    
GeorefMethod,,** No join mapping for georeferenceProtocol ** 


  		




  103
  106
  
    
HigherGeography,,** No join mapping for higherGeography ** 


  		












Also available in:  Unified diff