Project

General

Profile

« Previous | Next » 

Revision 4573

Added by Aaron Marcuse-Kubitza about 12 years ago

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

View differences:

inputs/NY/Specimen/map.csv
1 1 
NY[Veg+],Veg+,Comments
2 2 
key,,Not used because UniqueNYInternalRecordNumber is a better pkey
3 
CollectorNumber,OMIT,"Not used [1], so does not need to be mapped.
4 

  		




  
  5
  
    
[1] The following query returns no rows: SELECT * FROM ""NY"".""Specimen"" WHERE ""CollectorNumber"" IS NOT NULL"


  		




  3
  6
  
    
FieldNumber,recordNumber,Usage inconsistent with DwC definition


  		




  4
  7
  
    
Locality,Locality/_merge/1,


  		




  5
  8
  
    
MinimumElevation,MinimumElevation/_nullIf:[null=.]/value,


  		












  

    
      inputs/NY/Specimen/map.full.csv
    
  





  5
  5
  
    
MinimumElevation,MinimumElevation/_nullIf:[null=.]/value,


  		




  6
  6
  
    
Notes,Notes/_merge/1,


  		




  7
  7
  
    
PlantFungusDescription,"Notes/_merge/2/_label[label=""plant fungus""]/value",


  		




  
  8
  
    
CollectorNumber,OMIT,"Not used [1], so does not need to be mapped.


  		




  
  9
  
    

  		




  
  10
  
    
[1] The following query returns no rows: SELECT * FROM ""NY"".""Specimen"" WHERE ""CollectorNumber"" IS NOT NULL"


  		




  8
  11
  
    
boundingBox,boundingBox


  		




  9
  12
  
    
catalogNumber,catalogNumber


  		




  10
  13
  
    
class,class


  		




  11
  14
  
    
collectionCode,collectionCode


  		




  12
  15
  
    
collector,collector


  		




  13
  
  
    
collectorNumber,collectorNumber


  		




  14
  16
  
    
continentOcean,continentOcean


  		




  15
  17
  
    
coordinatePrecision,coordinatePrecision


  		




  16
  18
  
    
country,country


  		












  

    
      inputs/NY/Specimen/VegBIEN.csv
    
  





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


  		




  23
  23
  
    
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/1,


  		




  24
  24
  
    
PlantFungusDescription,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/2/_label[label=""plant fungus""]/value",


  		




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


  		




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


  		




  27
  26
  
    
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"


  		




  28
  27
  
    
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",


  		




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


  		




  30
  29
  
    
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,


  		




  31
  30
  
    
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,


  		




  32
  
  
    
collectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,


  		




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


  		




  34
  32
  
    
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,


  		




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


  		




  ......




  56
  54
  
    
Substrate,"/location/locationnarrative/_merge/1/_merge/2/_label[label=""substrate""]/value",


  		




  57
  55
  
    
Vegetation,"/location/locationnarrative/_merge/1/_merge/3/_label[label=""vegetation""]/value",


  		




  58
  56
  
    
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"


  		




  
  57
  
    
CollectorNumber,,"** No join mapping for OMIT ** Not used [1], so does not need to be mapped.


  		




  
  58
  
    

  		




  
  59
  
    
[1] The following query returns no rows: SELECT * FROM ""NY"".""Specimen"" WHERE ""CollectorNumber"" IS NOT NULL"


  		












  

    
      inputs/NY/Specimen/test.xml.ref
    
  





  199
  199
  
    
                        </_merge>


  		




  200
  200
  
    
                    </notes>


  		




  201
  201
  
    
                    <plantobservation>


  		




  202
  
  
    
                        <collectionnumber>


  		




  203
  
  
    
                            <_alt>


  		




  204
  
  
    
                                <1>$CollectorNumber</1>


  		




  205
  
  
    
                                <2>$FieldNumber</2>


  		




  206
  
  
    
                            </_alt>


  		




  207
  
  
    
                        </collectionnumber>


  		




  
  202
  
    
                        <collectionnumber>$FieldNumber</collectionnumber>


  		




  208
  203
  
    
                        <definedvalue fkey="tablerecord_id">


  		




  209
  204
  
    
                            <userdefined_id>


  		




  210
  205
  
    
                                <userdefined>


  		




  ......




  224
  219
  
    
                </aggregateoccurrence>


  		




  225
  220
  
    
                <authortaxoncode>


  		




  226
  221
  
    
                    <_alt>


  		




  227
  
  
    
                        <1>


  		




  228
  
  
    
                            <_alt>


  		




  229
  
  
    
                                <1>$CollectorNumber</1>


  		




  230
  
  
    
                                <2>$FieldNumber</2>


  		




  231
  
  
    
                            </_alt>


  		




  232
  
  
    
                        </1>


  		




  
  222
  
    
                        <1>$FieldNumber</1>


  		




  233
  223
  
    
                        <2>$ScientificName</2>


  		




  234
  224
  
    
                    </_alt>


  		




  235
  225
  
    
                </authortaxoncode>


  		












Also available in:  Unified diff