Project

General

Profile

« Previous | Next » 

Revision 4572

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/ARIZ/Specimen/map.csv: Omit FieldNumber because it is identical to CollectorNumber, so it does not need to be mapped

View differences:

inputs/ARIZ/Specimen/map.csv
1 1 
ARIZ[Veg+],Veg+,Comments
2 2 
CatalogNumber,CatalogNumber/_alt/2,Don't overwrite CatalogNumberNumeric
3 3 
CatalogNumberNumeric,CatalogNumber/_alt/1,
4 
FieldNumber,recordNumber,Usage inconsistent with DwC definition
4 
FieldNumber,OMIT,"Usage inconsistent with DwC definition: meaning is recordNumber. Identical to CollectorNumber [1], so does not need to be mapped.
5 

  		




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


  		




  5
  7
  
    
TimeCollected,TimeOfDay,


  		




  6
  8
  
    
VerbatimCollectingDate,dateCollected/_alt/0,


  		




  7
  9
  
    
HorizontalDatum,,Not used


  		












  

    
      inputs/ARIZ/Specimen/map.full.csv
    
  





  1
  1
  
    
ARIZ[Veg+],Veg+,Comments


  		




  2
  2
  
    
CatalogNumberNumeric,CatalogNumber/_alt/1,


  		




  3
  3
  
    
CatalogNumber,CatalogNumber/_alt/2,Don't overwrite CatalogNumberNumeric


  		




  
  4
  
    
FieldNumber,OMIT,"Usage inconsistent with DwC definition: meaning is recordNumber. Identical to CollectorNumber [1], so does not need to be mapped.


  		




  
  5
  
    

  		




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


  		




  4
  7
  
    
OtherCatalogNumbers,RelatedCatalogItem/_alt/1,


  		




  5
  8
  
    
RelatedCatalogedItems,RelatedCatalogItem/_alt/2,Used only when OtherCatalogNumbers is NULL


  		




  6
  9
  
    
ScientificNameAuthor,ScientificName/_alt/1,Contains the binomial in addition to the authority


  		




  ......




  42
  45
  
    
monthIdentified,monthIdentified


  		




  43
  46
  
    
order,order


  		




  44
  47
  
    
phylum,phylum


  		




  45
  
  
    
FieldNumber,recordNumber,Usage inconsistent with DwC definition


  		




  46
  48
  
    
remarks,remarks


  		




  47
  49
  
    
sex,sex


  		




  48
  50
  
    
species,species


  		












  

    
      inputs/ARIZ/Specimen/VegBIEN.csv
    
  





  27
  27
  
    
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,


  		




  28
  28
  
    
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,


  		




  29
  29
  
    
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,


  		




  30
  
  
    
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,Usage inconsistent with DwC definition


  		




  31
  30
  
    
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"


  		




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


  		




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


  		




  ......




  35
  34
  
    
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,


  		




  36
  35
  
    
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,


  		




  37
  36
  
    
collectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,


  		




  38
  
  
    
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,Usage inconsistent with DwC definition


  		




  39
  37
  
    
ScientificNameAuthor,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2/_alt/1,Contains the binomial in addition to the authority


  		




  40
  38
  
    
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2/_alt/2,


  		




  41
  39
  
    
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,


  		




  ......




  63
  61
  
    
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",


  		




  64
  62
  
    
locality,/location/locationnarrative/_merge/1,


  		




  65
  63
  
    
AgeClass,,** No join mapping for lifeStage ** 


  		




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


  		




  
  65
  
    

  		




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


  		




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


  		




  67
  68
  
    
GeorefMethod,,** No join mapping for georeferenceProtocol ** 


  		




  68
  69
  
    
LatLongComments,,** No join mapping for georeferenceRemarks ** 


  		












  

    
      inputs/ARIZ/Specimen/test.xml.ref
    
  





  216
  216
  
    
                    <count>$IndividualCount</count>


  		




  217
  217
  
    
                    <notes>$FieldNotes</notes>


  		




  218
  218
  
    
                    <plantobservation>


  		




  219
  
  
    
                        <collectionnumber>


  		




  220
  
  
    
                            <_alt>


  		




  221
  
  
    
                                <1>$CollectorNumber</1>


  		




  222
  
  
    
                                <2>$FieldNumber</2>


  		




  223
  
  
    
                            </_alt>


  		




  224
  
  
    
                        </collectionnumber>


  		




  
  219
  
    
                        <collectionnumber>$CollectorNumber</collectionnumber>


  		




  225
  220
  
    
                        <definedvalue fkey="tablerecord_id">


  		




  226
  221
  
    
                            <userdefined_id>


  		




  227
  222
  
    
                                <userdefined>


  		




  ......




  246
  241
  
    
                </aggregateoccurrence>


  		




  247
  242
  
    
                <authortaxoncode>


  		




  248
  243
  
    
                    <_alt>


  		




  249
  
  
    
                        <1>


  		




  250
  
  
    
                            <_alt>


  		




  251
  
  
    
                                <1>$CollectorNumber</1>


  		




  252
  
  
    
                                <2>$FieldNumber</2>


  		




  253
  
  
    
                            </_alt>


  		




  254
  
  
    
                        </1>


  		




  
  244
  
    
                        <1>$CollectorNumber</1>


  		




  255
  245
  
    
                        <2>


  		




  256
  246
  
    
                            <_alt>


  		




  257
  247
  
    
                                <1>$ScientificNameAuthor</1>


  		












Also available in:  Unified diff