Project

General

Profile

« Previous | Next » 

Revision 10530

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/SpeciesLink/: switched to new-style import, using the steps at wiki.vegpath.org/Adding_new-style_import_to_a_datasource

View differences:

inputs/SpeciesLink/Specimen/postprocess.sql
1 1 
SELECT util.search_path_append('util');
2 2 

  		




  3
  
  
    
SELECT create_if_not_exists($$CREATE INDEX "Specimen.acronym" ON $$||:table_str||$$ ("dwc_terms_institutionCode")$$);


  		




  
  3
  
    
SELECT create_if_not_exists($$CREATE INDEX "Specimen.acronym" ON $$||:table_str||$$ ("specimenHolderInstitutions")$$);


  		




  4
  4
  
    

  		




  5
  5
  
    
-- Remove institutions that we have direct data for


  		




  6
  6
  
    
DELETE FROM :table


  		




  7
  
  
    
WHERE "dwc_terms_institutionCode" IN (


  		




  
  7
  
    
WHERE "specimenHolderInstitutions" IN (


  		




  8
  8
  
    
      'MO'


  		




  9
  9
  
    
    , 'NY'


  		




  10
  10
  
    
)


  		




  ......




  18
  18
  
    
;


  		




  19
  19
  
    

  		




  20
  20
  
    
SELECT mk_derived_col((:table_str, 'collectorNumber'),


  		




  21
  
  
    
$$_alt("dwc_terms_recordNumber", "dwc_terms_fieldNumber")$$)


  		




  
  21
  
    
$$_alt("collectorNumber_from_recordNumber", "collectorNumber_from_fieldNumber")$$)


  		




  22
  22
  
    
; -- runtime: 3 min ("Time: 177696.140 ms") @starscream


  		












  

    
      inputs/SpeciesLink/Specimen/run
    
  





  
  1
  
    
#!/bin/bash -e


  		




  
  2
  
    
. "$(dirname "${BASH_SOURCE[0]}")"/../table.run


  		




  0
  3
  
    

  		












  

    
      inputs/SpeciesLink/Specimen/map.csv
    
  





  133
  133
  
    
conceptual_darwin_2003_1_0_RelationshipType,relationshipOfResource,,


  		




  134
  134
  
    
conceptual_darwin_2003_1_0_RelatedCatalogItem,relatedResourceID,,


  		




  135
  135
  
    
conceptual_darwin_2003_1_0_Notes,DUPLICATE#of:occurrenceRemarks#2003_Notes,,exact duplicate


  		




  136
  
  
    
collectorNumber,collectorNumber,,


  		












  

    
      inputs/SpeciesLink/Specimen/test.xml.ref
    
  





  9
  9
  
    
                    <location>


  		




  10
  10
  
    
                        <authorlocationcode>


  		




  11
  11
  
    
                            <_alt>


  		




  12
  
  
    
                                <1>$dwc_dwcore_GlobalUniqueIdentifier</1>


  		




  
  12
  
    
                                <1>$occurrenceID</1>


  		




  13
  13
  
    
                                <2>


  		




  14
  14
  
    
                                    <_join>


  		




  15
  
  
    
                                        <1>$dwc_terms_institutionCode</1>


  		




  
  15
  
    
                                        <1>$specimenHolderInstitutions</1>


  		




  16
  16
  
    
                                        <2>


  		




  17
  17
  
    
                                            <_join>


  		




  18
  
  
    
                                                <1>$dwc_terms_collectionCode</1>


  		




  19
  
  
    
                                                <2>$dwc_terms_collectionID</2>


  		




  
  18
  
    
                                                <1>$collection</1>


  		




  
  19
  
    
                                                <2>$collectionURL</2>


  		




  20
  20
  
    
                                            </_join>


  		




  21
  21
  
    
                                        </2>


  		




  22
  
  
    
                                        <3>$dwc_terms_catalogNumber</3>


  		




  
  22
  
    
                                        <3>$accessionNumber</3>


  		




  23
  23
  
    
                                    </_join>


  		




  24
  24
  
    
                                </2>


  		




  25
  25
  
    
                            </_alt>


  		




  26
  26
  
    
                        </authorlocationcode>


  		




  27
  27
  
    
                        <elevation_m>


  		




  28
  28
  
    
                            <_avg>


  		




  29
  
  
    
                                <1>$dwc_terms_minimumElevationInMeters</1>


  		




  30
  
  
    
                                <2>$dwc_terms_maximumElevationInMeters</2>


  		




  
  29
  
    
                                <1>$minimumElevationInMeters</1>


  		




  
  30
  
    
                                <2>$maximumElevationInMeters</2>


  		




  31
  31
  
    
                            </_avg>


  		




  32
  32
  
    
                        </elevation_m>


  		




  33
  
  
    
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$dwc_terms_locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>


  		




  
  33
  
    
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>


  		




  34
  34
  
    
                        <locationevent>


  		




  35
  35
  
    
                            <taxonoccurrence>


  		




  36
  36
  
    
                                <aggregateoccurrence>


  		




  ......




  40
  40
  
    
                                                <_nullIf>


  		




  41
  41
  
    
                                                    <null>0</null>


  		




  42
  42
  
    
                                                    <type>float</type>


  		




  43
  
  
    
                                                    <value>$dwc_terms_day</value>


  		




  
  43
  
    
                                                    <value>$dayCollected</value>


  		




  44
  44
  
    
                                                </_nullIf>


  		




  45
  45
  
    
                                            </day>


  		




  46
  46
  
    
                                            <month>


  		




  47
  47
  
    
                                                <_nullIf>


  		




  48
  48
  
    
                                                    <null>0</null>


  		




  49
  49
  
    
                                                    <type>float</type>


  		




  50
  
  
    
                                                    <value>$dwc_terms_month</value>


  		




  
  50
  
    
                                                    <value>$monthCollected</value>


  		




  51
  51
  
    
                                                </_nullIf>


  		




  52
  52
  
    
                                            </month>


  		




  53
  53
  
    
                                            <year>


  		




  54
  54
  
    
                                                <_nullIf>


  		




  55
  55
  
    
                                                    <null>0</null>


  		




  56
  56
  
    
                                                    <type>float</type>


  		




  57
  
  
    
                                                    <value>$dwc_terms_year</value>


  		




  
  57
  
    
                                                    <value>$yearCollected</value>


  		




  58
  58
  
    
                                                </_nullIf>


  		




  59
  59
  
    
                                            </year>


  		




  60
  60
  
    
                                        </_date>


  		




  61
  61
  
    
                                    </collectiondate>


  		




  62
  
  
    
                                    <count>$dwc_terms_individualCount</count>


  		




  63
  
  
    
                                    <notes>$dwc_terms_occurrenceRemarks</notes>


  		




  
  62
  
    
                                    <count>$individualCount</count>


  		




  
  63
  
    
                                    <notes>$occurrenceRemarks</notes>


  		




  64
  64
  
    
                                    <plantobservation>


  		




  65
  65
  
    
                                        <authorplantcode>$collectorNumber</authorplantcode>


  		




  66
  66
  
    
                                        <definedvalue fkey="tablerecord_id">


  		




  ......




  70
  70
  
    
                                                    <userdefinedname>sex</userdefinedname>


  		




  71
  71
  
    
                                                </userdefined>


  		




  72
  72
  
    
                                            </userdefined_id>


  		




  73
  
  
    
                                            <definedvalue>$dwc_terms_sex</definedvalue>


  		




  
  73
  
    
                                            <definedvalue>$sex</definedvalue>


  		




  74
  74
  
    
                                        </definedvalue>


  		




  75
  75
  
    
                                        <specimenreplicate>


  		




  76
  
  
    
                                            <catalognumber_dwc>$dwc_terms_catalogNumber</catalognumber_dwc>


  		




  
  76
  
    
                                            <catalognumber_dwc>$accessionNumber</catalognumber_dwc>


  		




  77
  77
  
    
                                            <collectioncode_dwc>


  		




  78
  78
  
    
                                                <_alt>


  		




  79
  
  
    
                                                    <1>$dwc_terms_collectionCode</1>


  		




  80
  
  
    
                                                    <2>$dwc_terms_collectionID</2>


  		




  
  79
  
    
                                                    <1>$collection</1>


  		




  
  80
  
    
                                                    <2>$collectionURL</2>


  		




  81
  81
  
    
                                                </_alt>


  		




  82
  82
  
    
                                            </collectioncode_dwc>


  		




  83
  83
  
    
                                            <collectionnumber>$collectorNumber</collectionnumber>


  		




  84
  84
  
    
                                            <institution_id>


  		




  85
  85
  
    
                                                <sourcelist>


  		




  86
  
  
    
                                                    <name>$dwc_terms_institutionCode</name>


  		




  
  86
  
    
                                                    <name>$specimenHolderInstitutions</name>


  		




  87
  87
  
    
                                                    <sourcename>


  		




  88
  88
  
    
                                                        <name>


  		




  89
  89
  
    
                                                            <_split>


  		




  90
  90
  
    
                                                                <separator>[,;] *</separator>


  		




  91
  
  
    
                                                                <value>$dwc_terms_institutionCode</value>


  		




  
  91
  
    
                                                                <value>$specimenHolderInstitutions</value>


  		




  92
  92
  
    
                                                            </_split>


  		




  93
  93
  
    
                                                        </name>


  		




  94
  94
  
    
                                                    </sourcename>


  		




  95
  95
  
    
                                                </sourcelist>


  		




  96
  96
  
    
                                            </institution_id>


  		




  97
  
  
    
                                            <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>


  		




  
  97
  
    
                                            <sourceaccessioncode>$occurrenceID</sourceaccessioncode>


  		




  98
  98
  
    
                                        </specimenreplicate>


  		




  99
  99
  
    
                                    </plantobservation>


  		




  100
  100
  
    
                                </aggregateoccurrence>


  		




  101
  
  
    
                                <collector_id><party><fullname>$dwc_terms_recordedBy</fullname></party></collector_id>


  		




  102
  
  
    
                                <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>


  		




  
  101
  
    
                                <collector_id><party><fullname>$recordedBy</fullname></party></collector_id>


  		




  
  102
  
    
                                <sourceaccessioncode>$occurrenceID</sourceaccessioncode>


  		




  103
  103
  
    
                                <taxondetermination>


  		




  104
  
  
    
                                    <party_id><party><fullname>$dwc_terms_identifiedBy</fullname></party></party_id>


  		




  
  104
  
    
                                    <party_id><party><fullname>$identifiedBy</fullname></party></party_id>


  		




  105
  105
  
    
                                    <taxonverbatim_id>


  		




  106
  106
  
    
                                        <taxonverbatim>


  		




  107
  107
  
    
                                            <taxonlabel_id>


  		




  ......




  120
  120
  
    
                                                                                    <parent_id>


  		




  121
  121
  
    
                                                                                        <taxonlabel>


  		




  122
  122
  
    
                                                                                            <rank>subspecies</rank>


  		




  123
  
  
    
                                                                                            <taxonepithet>$conceptual_darwin_2003_1_0_Subspecies</taxonepithet>


  		




  
  123
  
    
                                                                                            <taxonepithet>$subspecies</taxonepithet>


  		




  124
  124
  
    
                                                                                            <parent_id>


  		




  125
  125
  
    
                                                                                                <taxonlabel>


  		




  126
  126
  
    
                                                                                                    <rank>species</rank>


  		




  127
  
  
    
                                                                                                    <taxonepithet>$dwc_terms_specificEpithet</taxonepithet>


  		




  
  127
  
    
                                                                                                    <taxonepithet>$specificEpithet</taxonepithet>


  		




  128
  128
  
    
                                                                                                    <parent_id>


  		




  129
  129
  
    
                                                                                                        <taxonlabel>


  		




  130
  130
  
    
                                                                                                            <rank>genus</rank>


  		




  131
  
  
    
                                                                                                            <taxonepithet>$dwc_terms_genus</taxonepithet>


  		




  
  131
  
    
                                                                                                            <taxonepithet>$genus</taxonepithet>


  		




  132
  132
  
    
                                                                                                            <parent_id>


  		




  133
  133
  
    
                                                                                                                <taxonlabel>


  		




  134
  134
  
    
                                                                                                                    <rank>family</rank>


  		




  135
  
  
    
                                                                                                                    <taxonepithet>$dwc_terms_family</taxonepithet>


  		




  
  135
  
    
                                                                                                                    <taxonepithet>$family</taxonepithet>


  		




  136
  136
  
    
                                                                                                                    <parent_id>


  		




  137
  137
  
    
                                                                                                                        <taxonlabel>


  		




  138
  138
  
    
                                                                                                                            <rank>order</rank>


  		




  139
  
  
    
                                                                                                                            <taxonepithet>$dwc_terms_order</taxonepithet>


  		




  
  139
  
    
                                                                                                                            <taxonepithet>$order</taxonepithet>


  		




  140
  140
  
    
                                                                                                                            <parent_id>


  		




  141
  141
  
    
                                                                                                                                <taxonlabel>


  		




  142
  142
  
    
                                                                                                                                    <rank>class</rank>


  		




  143
  
  
    
                                                                                                                                    <taxonepithet>$dwc_terms_class</taxonepithet>


  		




  
  143
  
    
                                                                                                                                    <taxonepithet>$class</taxonepithet>


  		




  144
  144
  
    
                                                                                                                                    <parent_id>


  		




  145
  145
  
    
                                                                                                                                        <taxonlabel>


  		




  146
  146
  
    
                                                                                                                                            <rank>phylum</rank>


  		




  147
  
  
    
                                                                                                                                            <taxonepithet>$dwc_terms_phylum</taxonepithet>


  		




  
  147
  
    
                                                                                                                                            <taxonepithet>$phylum</taxonepithet>


  		




  148
  148
  
    
                                                                                                                                            <parent_id>


  		




  149
  149
  
    
                                                                                                                                                <taxonlabel>


  		




  150
  150
  
    
                                                                                                                                                    <rank>kingdom</rank>


  		




  151
  
  
    
                                                                                                                                                    <taxonepithet>$dwc_terms_kingdom</taxonepithet>


  		




  
  151
  
    
                                                                                                                                                    <taxonepithet>$kingdom</taxonepithet>


  		




  152
  152
  
    
                                                                                                                                                </taxonlabel>


  		




  153
  153
  
    
                                                                                                                                            </parent_id>


  		




  154
  154
  
    
                                                                                                                                        </taxonlabel>


  		




  ......




  171
  171
  
    
                                                                    </parent_id>


  		




  172
  172
  
    
                                                                </taxonlabel>


  		




  173
  173
  
    
                                                            </parent_id>


  		




  174
  
  
    
                                                            <taxonepithet>$dwc_terms_infraspecificEpithet</taxonepithet>


  		




  
  174
  
    
                                                            <taxonepithet>$infraspecificEpithet</taxonepithet>


  		




  175
  175
  
    
                                                        </taxonlabel>


  		




  176
  176
  
    
                                                    </parent_id>


  		




  177
  177
  
    
                                                    <taxonomicname>


  		




  178
  178
  
    
                                                        <_merge_prefix>


  		




  179
  
  
    
                                                            <prefix><_taxon_family_require_std><family>$dwc_terms_family</family></_taxon_family_require_std></prefix>


  		




  
  179
  
    
                                                            <prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix>


  		




  180
  180
  
    
                                                            <value>


  		




  181
  181
  
    
                                                                <_alt>


  		




  182
  
  
    
                                                                    <1>$dwc_terms_scientificName</1>


  		




  
  182
  
    
                                                                    <1>$scientificName</1>


  		




  183
  183
  
    
                                                                    <2>


  		




  184
  184
  
    
                                                                        <_join_words>


  		




  185
  185
  
    
                                                                            <1>


  		




  186
  186
  
    
                                                                                <_join_words>


  		




  187
  
  
    
                                                                                    <2><_filter_genus><value>$dwc_terms_genus</value></_filter_genus></2>


  		




  188
  
  
    
                                                                                    <3>$dwc_terms_specificEpithet</3>


  		




  189
  
  
    
                                                                                    <4>$conceptual_darwin_2003_1_0_Subspecies</4>


  		




  190
  
  
    
                                                                                    <5>$dwc_terms_infraspecificEpithet</5>


  		




  
  187
  
    
                                                                                    <2><_filter_genus><value>$genus</value></_filter_genus></2>


  		




  
  188
  
    
                                                                                    <3>$specificEpithet</3>


  		




  
  189
  
    
                                                                                    <4>$subspecies</4>


  		




  
  190
  
    
                                                                                    <5>$infraspecificEpithet</5>


  		




  191
  191
  
    
                                                                                </_join_words>


  		




  192
  192
  
    
                                                                            </1>


  		




  193
  
  
    
                                                                            <2>$dwc_terms_scientificNameAuthorship</2>


  		




  
  193
  
    
                                                                            <2>$scientificNameAuthorship</2>


  		




  194
  194
  
    
                                                                        </_join_words>


  		




  195
  195
  
    
                                                                    </2>


  		




  196
  196
  
    
                                                                </_alt>


  		




  ......




  199
  199
  
    
                                                    </taxonomicname>


  		




  200
  200
  
    
                                                </taxonlabel>


  		




  201
  201
  
    
                                            </taxonlabel_id>


  		




  202
  
  
    
                                            <author>$dwc_terms_scientificNameAuthorship</author>


  		




  203
  
  
    
                                            <family>$dwc_terms_family</family>


  		




  204
  
  
    
                                            <genus>$dwc_terms_genus</genus>


  		




  205
  
  
    
                                            <specific_epithet>$dwc_terms_specificEpithet</specific_epithet>


  		




  206
  
  
    
                                            <taxonomicname>$dwc_terms_scientificName</taxonomicname>


  		




  
  202
  
    
                                            <author>$scientificNameAuthorship</author>


  		




  
  203
  
    
                                            <family>$family</family>


  		




  
  204
  
    
                                            <genus>$genus</genus>


  		




  
  205
  
    
                                            <specific_epithet>$specificEpithet</specific_epithet>


  		




  
  206
  
    
                                            <taxonomicname>$scientificName</taxonomicname>


  		




  207
  207
  
    
                                        </taxonverbatim>


  		




  208
  208
  
    
                                    </taxonverbatim_id>


  		




  209
  209
  
    
                                    <determinationdate>


  		




  210
  210
  
    
                                        <_alt>


  		




  211
  
  
    
                                            <1><_dateRangeStart><value>$dwc_terms_dateIdentified</value></_dateRangeStart></1>


  		




  
  211
  
    
                                            <1><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></1>


  		




  212
  212
  
    
                                            <2>


  		




  213
  213
  
    
                                                <_date>


  		




  214
  214
  
    
                                                    <day>


  		




  215
  215
  
    
                                                        <_nullIf>


  		




  216
  216
  
    
                                                            <null>0</null>


  		




  217
  217
  
    
                                                            <type>float</type>


  		




  218
  
  
    
                                                            <value>$conceptual_darwin_2003_1_0_DayIdentified</value>


  		




  
  218
  
    
                                                            <value>$dayIdentified</value>


  		




  219
  219
  
    
                                                        </_nullIf>


  		




  220
  220
  
    
                                                    </day>


  		




  221
  221
  
    
                                                    <month>


  		




  222
  222
  
    
                                                        <_nullIf>


  		




  223
  223
  
    
                                                            <null>0</null>


  		




  224
  224
  
    
                                                            <type>float</type>


  		




  225
  
  
    
                                                            <value>$conceptual_darwin_2003_1_0_MonthIdentified</value>


  		




  
  225
  
    
                                                            <value>$monthIdentified</value>


  		




  226
  226
  
    
                                                        </_nullIf>


  		




  227
  227
  
    
                                                    </month>


  		




  228
  228
  
    
                                                    <year>


  		




  229
  229
  
    
                                                        <_nullIf>


  		




  230
  230
  
    
                                                            <null>0</null>


  		




  231
  231
  
    
                                                            <type>float</type>


  		




  232
  
  
    
                                                            <value>$conceptual_darwin_2003_1_0_YearIdentified</value>


  		




  
  232
  
    
                                                            <value>$yearIdentified</value>


  		




  233
  233
  
    
                                                        </_nullIf>


  		




  234
  234
  
    
                                                    </year>


  		




  235
  235
  
    
                                                </_date>


  		




  ......




  240
  240
  
    
                            </taxonoccurrence>


  		




  241
  241
  
    
                            <waterdepth_m>


  		




  242
  242
  
    
                                <_avg>


  		




  243
  
  
    
                                    <1>$dwc_terms_minimumDepthInMeters</1>


  		




  244
  
  
    
                                    <2>$dwc_terms_maximumDepthInMeters</2>


  		




  
  243
  
    
                                    <1>$minimumDepthInMeters</1>


  		




  
  244
  
    
                                    <2>$maximumDepthInMeters</2>


  		




  245
  245
  
    
                                </_avg>


  		




  246
  246
  
    
                            </waterdepth_m>


  		




  247
  247
  
    
                        </locationevent>


  		




  248
  
  
    
                        <locationnarrative>$dwc_terms_locality</locationnarrative>


  		




  
  248
  
    
                        <locationnarrative>$locality</locationnarrative>


  		




  249
  249
  
    
                        <locationplace>


  		




  250
  250
  
    
                            <place_id>


  		




  251
  251
  
    
                                <place>


  		




  252
  252
  
    
                                    <coordinates_id>


  		




  253
  253
  
    
                                        <coordinates>


  		




  254
  
  
    
                                            <coordsaccuracy_m><_noCV><value>$dwc_terms_coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>


  		




  
  254
  
    
                                            <coordsaccuracy_m><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>


  		




  255
  255
  
    
                                            <latitude_deg>


  		




  256
  256
  
    
                                                <_nullIf>


  		




  257
  257
  
    
                                                    <null>0</null>


  		




  258
  258
  
    
                                                    <type>float</type>


  		




  259
  
  
    
                                                    <value>$dwc_terms_decimalLatitude</value>


  		




  
  259
  
    
                                                    <value>$decimalLatitude</value>


  		




  260
  260
  
    
                                                </_nullIf>


  		




  261
  261
  
    
                                            </latitude_deg>


  		




  262
  262
  
    
                                            <longitude_deg>


  		




  263
  263
  
    
                                                <_nullIf>


  		




  264
  264
  
    
                                                    <null>0</null>


  		




  265
  265
  
    
                                                    <type>float</type>


  		




  266
  
  
    
                                                    <value>$dwc_terms_decimalLongitude</value>


  		




  
  266
  
    
                                                    <value>$decimalLongitude</value>


  		




  267
  267
  
    
                                                </_nullIf>


  		




  268
  268
  
    
                                            </longitude_deg>


  		




  269
  
  
    
                                            <verbatimlatitude>$dwc_terms_verbatimLatitude</verbatimlatitude>


  		




  270
  
  
    
                                            <verbatimlongitude>$dwc_terms_verbatimLongitude</verbatimlongitude>


  		




  
  269
  
    
                                            <verbatimlatitude>$verbatimLatitude</verbatimlatitude>


  		




  
  270
  
    
                                            <verbatimlongitude>$verbatimLongitude</verbatimlongitude>


  		




  271
  271
  
    
                                        </coordinates>


  		




  272
  272
  
    
                                    </coordinates_id>


  		




  273
  
  
    
                                    <continent>$dwc_terms_continent</continent>


  		




  274
  
  
    
                                    <country>$dwc_terms_country</country>


  		




  275
  
  
    
                                    <county>$dwc_terms_county</county>


  		




  
  273
  
    
                                    <continent>$continent</continent>


  		




  
  274
  
    
                                    <country>$country</country>


  		




  
  275
  
    
                                    <county>$county</county>


  		




  276
  276
  
    
                                    <matched_place_id>


  		




  277
  277
  
    
                                        <place>


  		




  278
  278
  
    
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>


  		




  ......




  283
  283
  
    
                                                        <_nullIf>


  		




  284
  284
  
    
                                                            <null>0</null>


  		




  285
  285
  
    
                                                            <type>float</type>


  		




  286
  
  
    
                                                            <value>$dwc_terms_decimalLatitude</value>


  		




  
  286
  
    
                                                            <value>$decimalLatitude</value>


  		




  287
  287
  
    
                                                        </_nullIf>


  		




  288
  288
  
    
                                                    </latitude_deg>


  		




  289
  289
  
    
                                                    <longitude_deg>


  		




  290
  290
  
    
                                                        <_nullIf>


  		




  291
  291
  
    
                                                            <null>0</null>


  		




  292
  292
  
    
                                                            <type>float</type>


  		




  293
  
  
    
                                                            <value>$dwc_terms_decimalLongitude</value>


  		




  
  293
  
    
                                                            <value>$decimalLongitude</value>


  		




  294
  294
  
    
                                                        </_nullIf>


  		




  295
  295
  
    
                                                    </longitude_deg>


  		




  296
  296
  
    
                                                </coordinates>


  		




  297
  297
  
    
                                            </coordinates_id>


  		




  298
  
  
    
                                            <country>$dwc_terms_country</country>


  		




  299
  
  
    
                                            <county>$dwc_terms_county</county>


  		




  300
  
  
    
                                            <stateprovince>$dwc_terms_stateProvince</stateprovince>


  		




  
  298
  
    
                                            <country>$country</country>


  		




  
  299
  
    
                                            <county>$county</county>


  		




  
  300
  
    
                                            <stateprovince>$stateProvince</stateprovince>


  		




  301
  301
  
    
                                        </place>


  		




  302
  302
  
    
                                    </matched_place_id>


  		




  303
  
  
    
                                    <stateprovince>$dwc_terms_stateProvince</stateprovince>


  		




  
  303
  
    
                                    <stateprovince>$stateProvince</stateprovince>


  		




  304
  304
  
    
                                </place>


  		




  305
  305
  
    
                            </place_id>


  		




  306
  306
  
    
                        </locationplace>


  		












  

    
      inputs/SpeciesLink/Specimen/VegBIEN.csv
    
  





  1
  
  
    
SpeciesLink,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments


  		




  2
  
  
    
dwc_dwcore_GlobalUniqueIdentifier,"/_if[@name=""if specimen""]/cond/_exists",


  		




  3
  
  
    
dwc_terms_catalogNumber,"/_if[@name=""if specimen""]/cond/_exists",


  		




  4
  
  
    
dwc_terms_institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1",


  		




  5
  
  
    
dwc_dwcore_GlobalUniqueIdentifier,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1",


  		




  6
  
  
    
dwc_terms_catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists",


  		




  7
  
  
    
dwc_dwcore_GlobalUniqueIdentifier,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",


  		




  8
  
  
    
dwc_terms_catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",


  		




  9
  
  
    
dwc_terms_institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/2",


  		




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


  		




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


  		




  12
  
  
    
dwc_terms_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",


  		




  13
  
  
    
dwc_terms_minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/1,


  		




  14
  
  
    
dwc_terms_maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/2,


  		




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


  		




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


  		




  17
  
  
    
dwc_terms_locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,


  		




  18
  
  
    
dwc_terms_dateIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value",


  		




  19
  
  
    
conceptual_darwin_2003_1_0_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",


  		




  20
  
  
    
conceptual_darwin_2003_1_0_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",


  		




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


  		




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


  		




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


  		




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


  		




  25
  
  
    
dwc_terms_individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,


  		




  26
  
  
    
dwc_terms_occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1,


  		




  27
  
  
    
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,


  		




  28
  
  
    
dwc_terms_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"


  		




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


  		




  30
  
  
    
dwc_terms_collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/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


  		




  31
  
  
    
dwc_terms_collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,


  		




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


  		




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


  		




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


  		




  35
  
  
    
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_first/2",


  		




  36
  
  
    
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_first/2/_split:[separator=""[,;] *""]/value",


  		




  37
  
  
    
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,


  		




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


  		




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


  		




  40
  
  
    
dwc_terms_recordedBy,/location/locationevent/taxonoccurrence/collector_id/party/fullname,


  		




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


  		




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


  		




  43
  
  
    
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,


  		




  44
  
  
    
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,


  		




  45
  
  
    
conceptual_darwin_2003_1_0_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",


  		




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


  		




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


  		




  48
  
  
    
dwc_terms_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",


  		




  49
  
  
    
dwc_terms_order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=order]/taxonepithet",


  		




  50
  
  
    
dwc_terms_class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=class]/taxonepithet",


  		




  51
  
  
    
dwc_terms_phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet",


  		




  52
  
  
    
dwc_terms_kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet",


  		




  53
  
  
    
dwc_terms_infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,


  		




  54
  
  
    
dwc_terms_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family,


  		




  55
  
  
    
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1,


  		




  56
  
  
    
dwc_terms_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_filter_genus/value,


  		




  57
  
  
    
dwc_terms_specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,


  		




  58
  
  
    
conceptual_darwin_2003_1_0_Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/4,


  		




  59
  
  
    
dwc_terms_infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",


  		




  60
  
  
    
dwc_terms_infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,


  		




  61
  
  
    
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2,


  		




  62
  
  
    
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,


  		




  63
  
  
    
dwc_terms_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,


  		




  64
  
  
    
dwc_terms_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,


  		




  65
  
  
    
dwc_terms_specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,


  		




  66
  
  
    
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname,


  		




  67
  
  
    
dwc_terms_dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value,


  		




  68
  
  
    
conceptual_darwin_2003_1_0_DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",


  		




  69
  
  
    
conceptual_darwin_2003_1_0_MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",


  		




  70
  
  
    
conceptual_darwin_2003_1_0_YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",


  		




  71
  
  
    
dwc_terms_catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",


  		




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


  		




  73
  
  
    
dwc_terms_minimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/1,


  		




  74
  
  
    
dwc_terms_maximumDepthInMeters,/location/locationevent/waterdepth_m/_avg/2,


  		




  75
  
  
    
dwc_terms_locality,/location/locationnarrative/_merge/1,


  		




  76
  
  
    
dwc_terms_coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value,


  		




  77
  
  
    
dwc_terms_decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",


  		




  78
  
  
    
dwc_terms_decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",


  		




  79
  
  
    
dwc_terms_verbatimLatitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,Contains a mix of DMS and other verbatim coordinates


  		




  80
  
  
    
dwc_terms_verbatimLongitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,Contains a mix of DMS and other verbatim coordinates


  		




  81
  
  
    
dwc_terms_continent,/location/locationplace/*_id/place/continent,


  		




  82
  
  
    
dwc_terms_country,/location/locationplace/*_id/place/country,


  		




  83
  
  
    
dwc_terms_county,/location/locationplace/*_id/place/county,


  		




  84
  
  
    
dwc_terms_decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"


  		




  85
  
  
    
dwc_terms_decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"


  		




  86
  
  
    
dwc_terms_country,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2,


  		




  87
  
  
    
dwc_terms_county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,


  		




  88
  
  
    
dwc_terms_stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,


  		




  89
  
  
    
dwc_terms_stateProvince,/location/locationplace/*_id/place/stateprovince,


  		




  90
  
  
    
conceptual_darwin_2003_1_0_BasisOfRecord,,** No non-empty join mapping for DUPLICATE#of:basisOfRecord#2003_BasisOfRecord ** assumed duplicate because Darwin Core term is synonym


  		




  91
  
  
    
conceptual_darwin_2003_1_0_BoundingBox,,** No non-empty join mapping for UNUSED#2003_BoundingBox ** 


  		




  92
  
  
    
conceptual_darwin_2003_1_0_CatalogNumber,,** No non-empty join mapping for DUPLICATE#of:catalogNumber#2003_CatalogNumber ** assumed duplicate because Darwin Core term is synonym


  		




  93
  
  
    
conceptual_darwin_2003_1_0_Class,,** No non-empty join mapping for DUPLICATE#of:class#2003_Class ** assumed duplicate because Darwin Core term is synonym


  		




  94
  
  
    
conceptual_darwin_2003_1_0_CollectionCode,,** No non-empty join mapping for DUPLICATE#of:collectionCode#2003_CollectionCode ** assumed duplicate because Darwin Core term is synonym


  		




  95
  
  
    
conceptual_darwin_2003_1_0_Collector,,** No non-empty join mapping for DUPLICATE#of:recordedBy#2003_Collector ** assumed duplicate because Darwin Core term is synonym


  		




  96
  
  
    
conceptual_darwin_2003_1_0_CollectorNumber,,** No non-empty join mapping for DUPLICATE#of:recordNumber#2003_CollectorNumber ** exact duplicate


  		




  97
  
  
    
conceptual_darwin_2003_1_0_ContinentOcean,,** No non-empty join mapping for DUPLICATE#of:continent#2003_ContinentOcean ** assumed duplicate because Darwin Core term is synonym


  		




  98
  
  
    
conceptual_darwin_2003_1_0_CoordinatePrecision,,** No non-empty join mapping for DUPLICATE#of:coordinateUncertaintyInM#2003_CoordinatePrecision ** exact duplicate


  		




  99
  
  
    
conceptual_darwin_2003_1_0_Country,,** No non-empty join mapping for DUPLICATE#of:country#2003_Country ** assumed duplicate because Darwin Core term is synonym


  		




  100
  
  
    
conceptual_darwin_2003_1_0_County,,** No non-empty join mapping for DUPLICATE#of:county#2003_County ** assumed duplicate because Darwin Core term is synonym


  		




  101
  
  
    
conceptual_darwin_2003_1_0_DateLastModified,,** No non-empty join mapping for DUPLICATE#of:modified#2003_DateLastModified ** assumed duplicate because Darwin Core term is synonym


  		




  102
  
  
    
conceptual_darwin_2003_1_0_DayCollected,,** No non-empty join mapping for DUPLICATE#of:day#2003_DayCollected ** assumed duplicate because Darwin Core term is synonym


  		




  103
  
  
    
conceptual_darwin_2003_1_0_Family,,** No non-empty join mapping for DUPLICATE#of:family#2003_Family ** assumed duplicate because Darwin Core term is synonym


  		




  104
  
  
    
conceptual_darwin_2003_1_0_FieldNumber,,** No non-empty join mapping for DUPLICATE#of:fieldNumber#2003_FieldNumber ** exact duplicate


  		




  105
  
  
    
conceptual_darwin_2003_1_0_Genus,,** No non-empty join mapping for DUPLICATE#of:genus#2003_Genus ** assumed duplicate because Darwin Core term is synonym


  		




  106
  
  
    
conceptual_darwin_2003_1_0_IdentifiedBy,,** No non-empty join mapping for DUPLICATE#of:identifiedBy#2003_IdentifiedBy ** assumed duplicate because Darwin Core term is synonym


  		




  107
  
  
    
conceptual_darwin_2003_1_0_IndividualCount,,** No non-empty join mapping for DUPLICATE#of:individualCount#2003_IndividualCount ** assumed duplicate because Darwin Core term is synonym


  		




  108
  
  
    
conceptual_darwin_2003_1_0_InstitutionCode,,** No non-empty join mapping for DUPLICATE#of:institutionCode#2003_InstitutionCode ** assumed duplicate because Darwin Core term is synonym


  		




  109
  
  
    
conceptual_darwin_2003_1_0_JulianDay,,** No non-empty join mapping for UNUSED#2003_JulianDay ** 


  		




  110
  
  
    
conceptual_darwin_2003_1_0_Kingdom,,** No non-empty join mapping for DUPLICATE#of:kingdom#2003_Kingdom ** assumed duplicate because Darwin Core term is synonym


  		




  111
  
  
    
conceptual_darwin_2003_1_0_Latitude,,** No non-empty join mapping for DUPLICATE#of:decimalLatitude#2003_Latitude ** assumed duplicate because Darwin Core term is synonym


  		




  112
  
  
    
conceptual_darwin_2003_1_0_Locality,,** No non-empty join mapping for DUPLICATE#of:locality#2003_Locality ** assumed duplicate because Darwin Core term is synonym


  		




  113
  
  
    
conceptual_darwin_2003_1_0_Longitude,,** No non-empty join mapping for DUPLICATE#of:decimalLongitude#2003_Longitude ** assumed duplicate because Darwin Core term is synonym


  		




  114
  
  
    
conceptual_darwin_2003_1_0_MaximumDepth,,** No non-empty join mapping for DUPLICATE#of:maximumDepthInMeters#2003_MaximumDepth ** assumed duplicate because Darwin Core term is synonym


  		




  115
  
  
    
conceptual_darwin_2003_1_0_MaximumElevation,,** No non-empty join mapping for DUPLICATE#of:maximumElevationInMeters#2003_MaximumElevation ** assumed duplicate because Darwin Core term is synonym


  		




  116
  
  
    
conceptual_darwin_2003_1_0_MinimumDepth,,** No non-empty join mapping for DUPLICATE#of:minimumDepthInMeters#2003_MinimumDepth ** assumed duplicate because Darwin Core term is synonym


  		




  117
  
  
    
conceptual_darwin_2003_1_0_MinimumElevation,,** No non-empty join mapping for DUPLICATE#of:minimumElevationInMeters#2003_MinimumElevation ** assumed duplicate because Darwin Core term is synonym


  		




  118
  
  
    
conceptual_darwin_2003_1_0_MonthCollected,,** No non-empty join mapping for DUPLICATE#of:month#2003_MonthCollected ** assumed duplicate because Darwin Core term is synonym


  		




  119
  
  
    
conceptual_darwin_2003_1_0_Notes,,** No non-empty join mapping for DUPLICATE#of:occurrenceRemarks#2003_Notes ** exact duplicate


  		




  120
  
  
    
conceptual_darwin_2003_1_0_Order,,** No non-empty join mapping for DUPLICATE#of:order#2003_Order ** assumed duplicate because Darwin Core term is synonym


  		




  121
  
  
    
conceptual_darwin_2003_1_0_Phylum,,** No non-empty join mapping for DUPLICATE#of:phylum#2003_Phylum ** assumed duplicate because Darwin Core term is synonym


  		




  122
  
  
    
conceptual_darwin_2003_1_0_PreparationType,,** No non-empty join mapping for DUPLICATE#of:preparations#2003_PreparationType ** assumed duplicate because Darwin Core term is synonym


  		




  123
  
  
    
conceptual_darwin_2003_1_0_PreviousCatalogNumber,,** No non-empty join mapping for DUPLICATE#of:otherCatalogNumbers#2003_PreviousCatalogNumber ** assumed duplicate because Darwin Core term is synonym


  		




  124
  
  
    
conceptual_darwin_2003_1_0_RelatedCatalogItem,,** No join mapping for relatedResourceID ** 


  		




  125
  
  
    
conceptual_darwin_2003_1_0_RelationshipType,,** No join mapping for relationshipOfResource ** 


  		




  126
  
  
    
conceptual_darwin_2003_1_0_ScientificName,,** No non-empty join mapping for DUPLICATE#of:scientificName#2003_ScientificName ** assumed duplicate because Darwin Core term is synonym


  		




  127
  
  
    
conceptual_darwin_2003_1_0_ScientificNameAuthor,,** No non-empty join mapping for DUPLICATE#of:scientificNameAuthorship#2003_ScientificNameAuthor ** exact duplicate


  		




  128
  
  
    
conceptual_darwin_2003_1_0_Sex,,** No non-empty join mapping for DUPLICATE#of:sex#2003_Sex ** assumed duplicate because Darwin Core term is synonym


  		




  129
  
  
    
conceptual_darwin_2003_1_0_Species,,** No non-empty join mapping for DUPLICATE#of:specificEpithet#2003_Species ** assumed duplicate because Darwin Core term is synonym


  		




  130
  
  
    
conceptual_darwin_2003_1_0_StateProvince,,** No non-empty join mapping for DUPLICATE#of:stateProvince#2003_StateProvince ** assumed duplicate because Darwin Core term is synonym


  		




  131
  
  
    
conceptual_darwin_2003_1_0_TimeOfDay,,** No non-empty join mapping for DUPLICATE#of:eventTime#2003_TimeOfDay ** assumed duplicate because Darwin Core term is synonym


  		




  132
  
  
    
conceptual_darwin_2003_1_0_TypeStatus,,** No non-empty join mapping for DUPLICATE#of:typeStatus#2003_TypeStatus ** assumed duplicate because Darwin Core term is synonym


  		




  133
  
  
    
conceptual_darwin_2003_1_0_YearCollected,,** No non-empty join mapping for DUPLICATE#of:year#2003_YearCollected ** assumed duplicate because Darwin Core term is synonym


  		




  134
  
  
    
dwc_curatorial_CollectorNumber,,** No non-empty join mapping for DUPLICATE#of:recordNumber#dwc_curatorial_CollectorNumber ** exact duplicate


  		




  135
  
  
    
dwc_curatorial_FieldNumber,,** No non-empty join mapping for DUPLICATE#of:fieldNumber#dwc_curatorial_FieldNumber ** exact duplicate


  		




  136
  
  
    
dwc_curatorial_IdentifiedBy,,** No non-empty join mapping for DUPLICATE#of:identifiedBy#dwc_curatorial_IdentifiedBy ** assumed duplicate because Darwin Core term is synonym


  		




  137
  
  
    
dwc_curatorial_IndividualCount,,** No non-empty join mapping for DUPLICATE#of:individualCount#dwc_curatorial_IndividualCount ** assumed duplicate because Darwin Core term is synonym


  		




  138
  
  
    
dwc_curatorial_TypeStatus,,** No non-empty join mapping for DUPLICATE#of:typeStatus#dwc_curatorial_TypeStatus ** assumed duplicate because Darwin Core term is synonym


  		




  139
  
  
    
dwc_dwcore_AuthorYearOfScientificName,,** No non-empty join mapping for DUPLICATE#of:scientificNameAuthor#dwcore_AuthorYearOfScientific ** exact duplicate


  		




  140
  
  
    
dwc_dwcore_BasisOfRecord,,** No non-empty join mapping for DUPLICATE#of:basisOfRecord#dwcore_BasisOfRecord ** assumed duplicate because Darwin Core term is synonym


  		




  141
  
  
    
dwc_dwcore_CatalogNumber,,** No non-empty join mapping for DUPLICATE#of:catalogNumber#dwcore_CatalogNumber ** assumed duplicate because Darwin Core term is synonym


  		




  142
  
  
    
dwc_dwcore_Class,,** No non-empty join mapping for DUPLICATE#of:class#dwcore_Class ** assumed duplicate because Darwin Core term is synonym


  		




  143
  
  
    
dwc_dwcore_CollectionCode,,** No non-empty join mapping for DUPLICATE#of:collectionCode#dwcore_CollectionCode ** assumed duplicate because Darwin Core term is synonym


  		




  144
  
  
    
dwc_dwcore_Collector,,** No non-empty join mapping for DUPLICATE#of:recordedBy#dwcore_Collector ** assumed duplicate because Darwin Core term is synonym


  		




  145
  
  
    
dwc_dwcore_Continent,,** No non-empty join mapping for DUPLICATE#of:continent#dwcore_Continent ** assumed duplicate because Darwin Core term is synonym


  		




  146
  
  
    
dwc_dwcore_Country,,** No non-empty join mapping for DUPLICATE#of:country#dwcore_Country ** assumed duplicate because Darwin Core term is synonym


  		




  147
  
  
    
dwc_dwcore_County,,** No non-empty join mapping for DUPLICATE#of:county#dwcore_County ** assumed duplicate because Darwin Core term is synonym


  		




  148
  
  
    
dwc_dwcore_DateLastModified,,** No non-empty join mapping for DUPLICATE#of:modified#dwcore_DateLastModified ** assumed duplicate because Darwin Core term is synonym


  		




  149
  
  
    
dwc_dwcore_DayOfYear,,** No non-empty join mapping for UNUSED#dwcore_DayOfYear ** 


  		




  150
  
  
    
dwc_dwcore_Family,,** No non-empty join mapping for DUPLICATE#of:family#dwcore_Family ** assumed duplicate because Darwin Core term is synonym


  		




  151
  
  
    
dwc_dwcore_Genus,,** No non-empty join mapping for DUPLICATE#of:genus#dwcore_Genus ** assumed duplicate because Darwin Core term is synonym


  		




  152
  
  
    
dwc_dwcore_InfraspecificEpithet,,** No non-empty join mapping for DUPLICATE#of:infraspecificEpithet#dwcore_InfraspecificEpithet ** assumed duplicate because Darwin Core term is synonym


  		




  153
  
  
    
dwc_dwcore_InstitutionCode,,** No non-empty join mapping for DUPLICATE#of:institutionCode#dwcore_InstitutionCode ** assumed duplicate because Darwin Core term is synonym


  		




  154
  
  
    
dwc_dwcore_Kingdom,,** No non-empty join mapping for DUPLICATE#of:kingdom#dwcore_Kingdom ** assumed duplicate because Darwin Core term is synonym


  		




  155
  
  
    
dwc_dwcore_Locality,,** No non-empty join mapping for DUPLICATE#of:locality#dwcore_Locality ** assumed duplicate because Darwin Core term is synonym


  		




  156
  
  
    
dwc_dwcore_MaximumDepthInMeters,,** No non-empty join mapping for DUPLICATE#of:maximumDepthInMeters#dwcore_MaximumDepthInMeters ** assumed duplicate because Darwin Core term is synonym


  		




  157
  
  
    
dwc_dwcore_MaximumElevationInMeters,,** No non-empty join mapping for DUPLICATE#of:maximumElevationInM#dwcore_MaximumElevationInM ** assumed duplicate because Darwin Core term is synonym


  		




  158
  
  
    
dwc_dwcore_MinimumDepthInMeters,,** No non-empty join mapping for DUPLICATE#of:minimumDepthInMeters#dwcore_MinimumDepthInMeters ** assumed duplicate because Darwin Core term is synonym


  		




  159
  
  
    
dwc_dwcore_MinimumElevationInMeters,,** No non-empty join mapping for DUPLICATE#of:minimumElevationInM#dwcore_MinimumElevationInM ** assumed duplicate because Darwin Core term is synonym


  		




  160
  
  
    
dwc_dwcore_Order,,** No non-empty join mapping for DUPLICATE#of:order#dwcore_Order ** assumed duplicate because Darwin Core term is synonym


  		




  161
  
  
    
dwc_dwcore_Phylum,,** No non-empty join mapping for DUPLICATE#of:phylum#dwcore_Phylum ** assumed duplicate because Darwin Core term is synonym


  		




  162
  
  
    
dwc_dwcore_Remarks,,** No non-empty join mapping for DUPLICATE#of:occurrenceRemarks#dwcore_Remarks ** exact duplicate


  		




  163
  
  
    
dwc_dwcore_ScientificName,,** No non-empty join mapping for DUPLICATE#of:scientificName#dwcore_ScientificName ** assumed duplicate because Darwin Core term is synonym


  		




  164
  
  
    
dwc_dwcore_Sex,,** No non-empty join mapping for DUPLICATE#of:sex#dwcore_Sex ** assumed duplicate because Darwin Core term is synonym


  		




  165
  
  
    
dwc_dwcore_SpecificEpithet,,** No non-empty join mapping for DUPLICATE#of:specificEpithet#dwcore_SpecificEpithet ** assumed duplicate because Darwin Core term is synonym


  		




  166
  
  
    
dwc_dwcore_StateProvince,,** No non-empty join mapping for DUPLICATE#of:stateProvince#dwcore_StateProvince ** assumed duplicate because Darwin Core term is synonym


  		




  167
  
  
    
dwc_geospatial_DecimalLatitude,,** No non-empty join mapping for DUPLICATE#of:decimalLatitude#dwc_geospatial_DecimalLatitude ** assumed duplicate because Darwin Core term is synonym


  		




  168
  
  
    
dwc_geospatial_DecimalLongitude,,** No non-empty join mapping for DUPLICATE#of:decimalLongitude#dwc_geospatial_DecimalLongitude ** assumed duplicate because Darwin Core term is synonym


  		




  169
  
  
    
dwc_geospatial_VerbatimLatitude,,** No non-empty join mapping for DUPLICATE#of:verbatimLatitude#dwc_geospatial_VerbatimLatitude ** exact duplicate


  		




  170
  
  
    
dwc_geospatial_VerbatimLongitude,,** No non-empty join mapping for DUPLICATE#of:verbatimLongitude#dwc_geospatial_VerbatimLongitude ** exact duplicate


  		




  171
  
  
    
dwc_terms_basisOfRecord,,** No join mapping for basisOfRecord ** 


  		




  172
  
  
    
dwc_terms_endDayOfYear,,** No non-empty join mapping for UNUSED#dwc_terms_endDayOfYear ** 


  		




  173
  
  
    
dwc_terms_eventTime,,** No join mapping for eventTime ** 


  		




  174
  
  
    
dwc_terms_fieldNumber,,"** No join mapping for collectorNumber_from_fieldNumber ** Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."


  		




  175
  
  
    
dwc_terms_otherCatalogNumbers,,** No join mapping for otherCatalogNumbers ** 


  		




  176
  
  
    
dwc_terms_preparations,,** No join mapping for preparations ** 


  		




  177
  
  
    
dwc_terms_recordNumber,,** No join mapping for collectorNumber_from_recordNumber ** 


  		




  178
  
  
    
dwc_terms_startDayOfYear,,** No non-empty join mapping for UNUSED#dwc_terms_startDayOfYear ** 


  		




  179
  
  
    
dwc_terms_typeStatus,,** No join mapping for typeStatus ** 


  		




  180
  
  
    
http__purl_org_dc_terms_modified,,** No join mapping for modified ** 


  		




  181
  
  
    
row_num,,** No join mapping for *row_num ** 


  		




  
  1
  
    
link ../../../mappings/VegCore-VegBIEN.csv


  		




  182
  2
  
    

  		












  

    
      inputs/SpeciesLink/run
    
  





  
  1
  
    
#!/bin/bash -e


  		




  
  2
  
    
. "$(dirname "${BASH_SOURCE[0]}")"/../../lib/runscripts/datasrc_dir.run


  		




  0
  3
  
    

  		












Also available in:  Unified diff