Project

General

Profile

« Previous | Next » 

Revision 4895

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/VegCore-VegBIEN.csv: Added empty mappings for special values (OMIT, etc.), so that they don't show up in **/unmapped_terms.csv. Note that the VegBIEN.csvs only change because the "No join mapping" errors change to "No non-empty join mapping".

View differences:

mappings/for_review/VegCore-VegBIEN.csv
185 185 
subplotY,//location/sublocationyposition_m,
186 186 
verbatimElevation,//location/verbatimelevation,
187 187 
verbatimElevation_m,//location/verbatimelevation,
188 
OMIT,,
189 
PRIVATE,,
190 
UNUSED,,
inputs/XAL/Specimen/VegBIEN.csv
46 46 
darwin:StateProvince,/location/locationplace/*_id/placepath/stateprovince,
47 47 
darwin:BasisOfRecord,,** No join mapping for basisOfRecord **
48 48 
darwin:DateLastModified,,** No join mapping for dcterms:modified **
49 
darwin:FieldNumber,,"** No join mapping for UNUSED ** `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines. This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber)."
49 
darwin:FieldNumber,,"** No non-empty join mapping for UNUSED ** `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines. This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber)."
50 50 
darwin:JulianDay,,** No join mapping for day **
51 51 
darwin:PreparationType,,** No join mapping for preparations **
52 52 
darwin:PreviousCatalogNumber,,** No join mapping for otherCatalogNumbers **
inputs/XAL/Specimen/unmapped_terms.csv
1 1 
dcterms:modified
2 2 
basisOfRecord
3 3 
typeStatus
4 
UNUSED
5 4 
day
6 5 
eventTime
7 6 
preparations
inputs/XAL/unmapped_terms.csv
1 
UNUSED
2 1 
basisOfRecord
3 2 
day
4 3 
dcterms:modified
inputs/NY/Specimen/VegBIEN.csv
53 53 
County,/location/locationplace/*_id/placepath/county,
54 54 
StateProvince,/location/locationplace/*_id/placepath/stateprovince,
55 55 
BasisOfRecord,,** No join mapping for basisOfRecord **
56 
CollectorNumber,,** No join mapping for UNUSED **
56 
CollectorNumber,,** No non-empty join mapping for UNUSED **
57 57 
DateLastModified,,** No join mapping for dcterms:modified **
58 58 
JulianDay,,** No join mapping for day **
59 59 
PreparationType,,** No join mapping for preparations **
......
62 62 
RelationshipType,,** No join mapping for relationshipOfResource **
63 63 
TimeOfDay,,** No join mapping for eventTime **
64 64 
TypeStatus,,** No join mapping for typeStatus **
65 
key,,** No join mapping for OMIT ** UniqueNYInternalRecordNumber is a better pkey
65 
key,,** No non-empty join mapping for OMIT ** UniqueNYInternalRecordNumber is a better pkey
inputs/NY/Specimen/unmapped_terms.csv
1 
OMIT
2 1 
dcterms:modified
3 2 
basisOfRecord
4 3 
typeStatus
5 
UNUSED
6 4 
day
7 5 
eventTime
8 6 
preparations
inputs/NY/unmapped_terms.csv
1 
OMIT
2 
UNUSED
3 1 
basisOfRecord
4 2 
day
5 3 
dcterms:modified
inputs/CVS/Organism/VegBIEN.csv
13 13 
county,/location/locationplace/*_id/placepath/county,
14 14 
state,/location/locationplace/*_id/placepath/stateprovince,
15 15 
confidentialityStatus,,** No join mapping for confidentialityStatus **
16 
realLatitude,,** No join mapping for PRIVATE **
17 
realLongitude,,** No join mapping for PRIVATE **
16 
realLatitude,,** No non-empty join mapping for PRIVATE **
17 
realLongitude,,** No non-empty join mapping for PRIVATE **
inputs/CVS/Organism/unmapped_terms.csv
1 
PRIVATE
2 
PRIVATE
3 1 
confidentialityStatus
inputs/CVS/unmapped_terms.csv
1 
PRIVATE
2 1 
confidentialityStatus
inputs/CTFS/Subplot/VegBIEN.csv
11 11 
StartY,/location/sublocationyposition_m,
12 12 
DimX,,** No join mapping for DimX **
13 13 
DimY,,** No join mapping for DimY **
14 
QuadratName,,** No join mapping for OMIT ** QuadratID is used for the same purpose
14 
QuadratName,,** No non-empty join mapping for OMIT ** QuadratID is used for the same purpose
inputs/CTFS/Subplot/unmapped_terms.csv
1 
OMIT
2 1 
DimX
3 2 
DimY
inputs/CTFS/TaxonOccurrence/VegBIEN.csv
19 19 
GenusID,,** No join mapping for GenusID **
20 20 
GenusReferenceID,,** No join mapping for GenusReferenceID **
21 21 
IDLevel,,** No join mapping for IDLevel **
22 
InfraSpecificLevel,,** No join mapping for UNUSED **
22 
InfraSpecificLevel,,** No non-empty join mapping for UNUSED **
23 23 
ReferenceID,,** No join mapping for ReferenceID **
24 24 
SpeciesAuthority,,** No join mapping for SpeciesAuthority **
25 25 
SpeciesCurrentTaxonFlag,,** No join mapping for SpeciesCurrentTaxonFlag **
inputs/CTFS/TaxonOccurrence/unmapped_terms.csv
6 6 
SubSpeciesObsoleteTaxonFlag
7 7 
SubSpeciesMnemonic
8 8 
SubSpeciesAuthority
9 
UNUSED
10 9 
SpeciesCurrentTaxonFlag
11 10 
SpeciesObsoleteTaxonFlag
12 11 
SpeciesReferenceID
inputs/CTFS/unmapped_terms.csv
11 11 
HOM
12 12 
IDLevel
13 13 
InfraSpecificLevel
14 
OMIT
15 14 
PrimaryStem
16 15 
ReferenceID
17 16 
ReferenceX
......
29 28 
SubSpeciesMnemonic
30 29 
SubSpeciesObsoleteTaxonFlag
31 30 
TreeID
32 
UNUSED
33 31 
row_num
inputs/U/Specimen/VegBIEN.csv
30 30 
Alt,,** No join mapping for Alt ** What is this?
31 31 
Alt2,,** No join mapping for Alt2 ** What is this?
32 32 
Coorsyst,,** No join mapping for Coorsyst **
33 
DateInfo,,** No join mapping for UNUSED **
33 
DateInfo,,** No non-empty join mapping for UNUSED **
34 34 
EW,,** No join mapping for EW **
35 35 
Majorarea,,** No join mapping for Majorarea **
36 36 
NS,,** No join mapping for NS **
37 37 
Phenology,,** No join mapping for reproductiveCondition **
38 
Prefix,,** No join mapping for UNUSED **
39 
Suffix,,** No join mapping for UNUSED **
38 
Prefix,,** No non-empty join mapping for UNUSED **
39 
Suffix,,** No non-empty join mapping for UNUSED **
inputs/U/Specimen/unmapped_terms.csv
1 
UNUSED
2 
UNUSED
3 
UNUSED
4 1 
Majorarea
5 2 
Coorsyst
6 3 
NS
inputs/U/unmapped_terms.csv
4 4 
EW
5 5 
Majorarea
6 6 
NS
7 
UNUSED
8 7 
reproductiveCondition
inputs/ARIZ/Specimen/VegBIEN.csv
58 58 
AgeClass,,** No join mapping for lifeStage **
59 59 
BasisOfRecord,,** No join mapping for basisOfRecord **
60 60 
DateLastModified,,** No join mapping for dcterms:modified **
61 
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.
61 
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.
62 62 

  		




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


  		




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


  		




  65
  65
  
    
GeorefMethod,,** No join mapping for georeferenceProtocol ** 


  		




  66
  66
  
    
HigherGeography,,** No join mapping for higherGeography ** 


  		




  67
  
  
    
HorizontalDatum,,** No join mapping for UNUSED ** 


  		




  
  67
  
    
HorizontalDatum,,** No non-empty join mapping for UNUSED ** 


  		




  68
  68
  
    
Island,,** No join mapping for island ** 


  		




  69
  69
  
    
IslandGroup,,** No join mapping for islandGroup ** 


  		




  70
  70
  
    
JulianDay,,** No join mapping for day ** 


  		




  ......




  74
  74
  
    
Preparations,,** No join mapping for preparations ** 


  		




  75
  75
  
    
RelatedCatalogedItems,,** No join mapping for relatedResourceID/_alt/2 ** Used only when OtherCatalogNumbers is NULL


  		




  76
  76
  
    
TimeCollected,,** No join mapping for eventTime ** 


  		




  77
  
  
    
Tissues,,** No join mapping for UNUSED ** 


  		




  
  77
  
    
Tissues,,** No non-empty join mapping for UNUSED ** 


  		




  78
  78
  
    
TypeStatus,,** No join mapping for typeStatus ** 


  		




  79
  79
  
    
VerbatimDepth,,** No join mapping for verbatimDepth ** 


  		




  80
  
  
    
VerbatimElevation,,** No join mapping for UNUSED ** 


  		




  81
  
  
    
VerbatimLatitude,,** No join mapping for UNUSED ** 


  		




  82
  
  
    
VerbatimLongitude,,** No join mapping for UNUSED ** 


  		




  
  80
  
    
VerbatimElevation,,** No non-empty join mapping for UNUSED ** 


  		




  
  81
  
    
VerbatimLatitude,,** No non-empty join mapping for UNUSED ** 


  		




  
  82
  
    
VerbatimLongitude,,** No non-empty join mapping for UNUSED ** 


  		












  

    
      inputs/ARIZ/Specimen/unmapped_terms.csv
    
  





  1
  1
  
    
dcterms:modified


  		




  2
  2
  
    
basisOfRecord


  		




  3
  
  
    
OMIT


  		




  4
  3
  
    
eventTime


  		




  5
  4
  
    
day


  		




  6
  5
  
    
higherGeography


  		




  7
  6
  
    
islandGroup


  		




  8
  7
  
    
island


  		




  9
  
  
    
UNUSED


  		




  10
  8
  
    
verbatimSRS


  		




  11
  
  
    
UNUSED


  		




  12
  
  
    
UNUSED


  		




  13
  9
  
    
georeferenceProtocol


  		




  14
  10
  
    
georeferenceRemarks


  		




  15
  
  
    
UNUSED


  		




  16
  11
  
    
verbatimDepth


  		




  17
  12
  
    
typeStatus


  		




  18
  13
  
    
preparations


  		




  19
  
  
    
UNUSED


  		




  20
  14
  
    
lifeStage


  		




  21
  15
  
    
associatedSequences


  		




  22
  16
  
    
relatedResourceID


  		












  

    
      inputs/ARIZ/unmapped_terms.csv
    
  





  1
  
  
    
OMIT


  		




  2
  
  
    
UNUSED


  		




  3
  1
  
    
associatedSequences


  		




  4
  2
  
    
basisOfRecord


  		




  5
  3
  
    
day


  		












  

    
      inputs/GBIF/Specimen/VegBIEN.csv
    
  





  34
  34
  
    
1,,** No join mapping for 1 ** 


  		




  35
  35
  
    
25,,** No join mapping for 25 ** 


  		




  36
  36
  
    
3,,** No join mapping for 3 ** 


  		




  37
  
  
    
DecimalLatitude,,"** No join mapping for OMIT ** Contains VerbatimLatitude cast to a low-resolution float, which created spurious repeating decimals"


  		




  38
  
  
    
DecimalLongitude,,"** No join mapping for OMIT ** Contains VerbatimLongitude cast to a low-resolution float, which created spurious repeating decimals"


  		




  
  37
  
    
DecimalLatitude,,"** No non-empty join mapping for OMIT ** Contains VerbatimLatitude cast to a low-resolution float, which created spurious repeating decimals"


  		




  
  38
  
    
DecimalLongitude,,"** No non-empty join mapping for OMIT ** Contains VerbatimLongitude cast to a low-resolution float, which created spurious repeating decimals"


  		




  39
  39
  
    
LastDateModified,,** No join mapping for dcterms:modified ** 


  		












  

    
      inputs/VegBank/plot_/VegBIEN.csv
    
  





  42
  42
  
    
dateentered,,** No join mapping for dateentered ** 


  		




  43
  43
  
    
dsgpoly,,** No join mapping for dsgpoly ** 


  		




  44
  44
  
    
elevationaccuracy,,** No join mapping for elevationaccuracy ** 


  		




  45
  
  
    
elevationrange,,** No join mapping for UNUSED ** 


  		




  
  45
  
    
elevationrange,,** No non-empty join mapping for UNUSED ** 


  		




  46
  46
  
    
emb_plot,,** No join mapping for emb_plot ** 


  		




  47
  47
  
    
layoutnarrative,,** No join mapping for layoutnarrative ** 


  		




  48
  48
  
    
notesmgt,,** No join mapping for notesmgt ** 


  		




  ......




  51
  51
  
    
placementmethod,,** No join mapping for placementmethod ** 


  		




  52
  52
  
    
plotrationalenarrative,,** No join mapping for plotrationalenarrative ** 


  		




  53
  53
  
    
quadrangle,,** No join mapping for quadrangle ** 


  		




  54
  
  
    
reallatitude,,** No join mapping for PRIVATE ** 


  		




  55
  
  
    
reallongitude,,** No join mapping for PRIVATE ** 


  		




  
  54
  
    
reallatitude,,** No non-empty join mapping for PRIVATE ** 


  		




  
  55
  
    
reallongitude,,** No non-empty join mapping for PRIVATE ** 


  		




  56
  56
  
    
reference_id,,** No join mapping for reference_id ** 


  		




  57
  57
  
    
revisions,,** No join mapping for revisions ** 


  		




  58
  58
  
    
rocktype,,** No join mapping for rocktype ** 


  		












  

    
      inputs/VegBank/plot_/unmapped_terms.csv
    
  





  1
  1
  
    
reference_id


  		




  2
  
  
    
PRIVATE


  		




  3
  
  
    
PRIVATE


  		




  4
  2
  
    
confidentialitystatus


  		




  5
  3
  
    
confidentialityreason


  		




  6
  4
  
    
authore


  		




  ......




  15
  13
  
    
permanence


  		




  16
  14
  
    
layoutnarrative


  		




  17
  15
  
    
elevationaccuracy


  		




  18
  
  
    
UNUSED


  		




  19
  16
  
    
topoposition


  		




  20
  17
  
    
surficialdeposits


  		




  21
  18
  
    
rocktype


  		












  

    
      inputs/VegBank/unmapped_terms.csv
    
  





  1
  1
  
    
Division


  		




  2
  2
  
    
Geographic Name


  		




  3
  
  
    
PRIVATE


  		




  4
  3
  
    
Subclass


  		




  5
  4
  
    
Subdivision


  		




  6
  5
  
    
Subkingdom


  		




  7
  6
  
    
Superdivision


  		




  8
  
  
    
UNUSED


  		




  9
  7
  
    
accessioncode


  		




  10
  8
  
    
authordatum


  		




  11
  9
  
    
authore


  		












  

    
      mappings/VegCore-VegBIEN.csv
    
  





  185
  185
  
    
subplotY,/location/sublocationyposition_m,


  		




  186
  186
  
    
verbatimElevation,/location/verbatimelevation,


  		




  187
  187
  
    
verbatimElevation_m,/location/verbatimelevation,


  		




  
  188
  
    
OMIT,,


  		




  
  189
  
    
PRIVATE,,


  		




  
  190
  
    
UNUSED,,


  		












Also available in:  Unified diff