Project

General

Profile

« Previous | Next » 

Revision 1605

inputs/SpeciesLink/maps: Updated to use new TAPIR download

View differences:

inputs/SpeciesLink/test/import.specimens.out.ref
1
Inserted 23 new rows into database
1
Inserted 30 new rows into database
inputs/SpeciesLink/test/DwC.specimens.xml.ref
2 2
<DwC xmlns:dcterms="http://purl.org/dc/terms/">
3 3
    <list id="0">
4 4
        <institutionID>SpeciesLink</institutionID>
5
        <CatalogNumber>1354</CatalogNumber>
6
        <CollectionCode>JBRJ_RBdna</CollectionCode>
7
        <Country>Brasil</Country>
8
        <DateLastModified>2007-12-14 10:48:02</DateLastModified>
9
        <DecimalLatitude>0</DecimalLatitude>
10
        <DecimalLongitude>999.9</DecimalLongitude>
11
        <Family>ARACEAE</Family>
12
        <Genus>Anthurium</Genus>
13
        <GeodeticDatum>WGS84</GeodeticDatum>
14
        <GlobalUniqueIdentifier>103390849</GlobalUniqueIdentifier>
15
        <InstitutionCode>JBRJ</InstitutionCode>
5
        <BasisOfRecord>S</BasisOfRecord>
6
        <CatalogNumber>3142542</CatalogNumber>
7
        <CollectionCode>MOBOT_BR</CollectionCode>
8
        <Collector>S. Mori, B. Rabelo, H. Belo, J. Cardoso, D. Daly, R. Nonato &amp; M.R. dos Santos</Collector>
9
        <CollectorNumber>16135</CollectorNumber>
10
        <Continent>South America</Continent>
11
        <ContinentOcean>South America</ContinentOcean>
12
        <Country>Brazil</Country>
13
        <DateLastModified>2010-12-06 10:03:24</DateLastModified>
14
        <DecimalLatitude>0.17</DecimalLatitude>
15
        <DecimalLongitude>-51.62</DecimalLongitude>
16
        <Family>Orchidaceae</Family>
17
        <Genus>Aa</Genus>
18
        <GlobalUniqueIdentifier>7384116</GlobalUniqueIdentifier>
19
        <IdentifiedBy>R. Garcia,</IdentifiedBy>
20
        <InstitutionCode>MO</InstitutionCode>
16 21
        <Kingdom>Plantae</Kingdom>
17
        <Latitude>0</Latitude>
18
        <Longitude>999.9</Longitude>
19
        <ScientificName>Anthurium harrisii (Grah.) G. Don</ScientificName>
20
        <ScientificNameAuthor>(Grah.) G. Don</ScientificNameAuthor>
21
        <Species>harrisii</Species>
22
        <SpecificEpithet>harrisii</SpecificEpithet>
22
        <Latitude>0.17</Latitude>
23
        <Locality>Camaipi. Embrapa reserve and vicinity</Locality>
24
        <Longitude>-51.62</Longitude>
25
        <ScientificName>Aa</ScientificName>
26
        <ScientificNameAuthor>Rchb. f.</ScientificNameAuthor>
27
        <StateProvince>Amap&#225;</StateProvince>
28
        <basisOfRecord>S</basisOfRecord>
29
        <catalogNumber>3142542</catalogNumber>
30
        <collectionCode>MOBOT_BR</collectionCode>
31
        <collectionID>88</collectionID>
32
        <continent>South America</continent>
33
        <country>Brazil</country>
34
        <dcterms:modified>2010-12-06 10:03:24</dcterms:modified>
35
        <decimalLatitude>0.17</decimalLatitude>
36
        <decimalLongitude>-51.62</decimalLongitude>
37
        <family>Orchidaceae</family>
38
        <genus>Aa</genus>
39
        <identifiedBy>R. Garcia,</identifiedBy>
40
        <institutionCode>MO</institutionCode>
41
        <kingdom>Plantae</kingdom>
42
        <locality>Camaipi. Embrapa reserve and vicinity</locality>
43
        <recordNumber>16135</recordNumber>
44
        <recordedBy>S. Mori, B. Rabelo, H. Belo, J. Cardoso, D. Daly, R. Nonato &amp; M.R. dos Santos</recordedBy>
45
        <scientificName>Aa</scientificName>
46
        <scientificNameAuthorship>Rchb. f.</scientificNameAuthorship>
47
        <stateProvince>Amap&#225;</stateProvince>
23 48
    </list>
24 49
    <list id="1">
25 50
        <institutionID>SpeciesLink</institutionID>
26
        <CatalogNumber>1355</CatalogNumber>
27
        <CollectionCode>JBRJ_RBdna</CollectionCode>
28
        <Collector>Nadruz  M.</Collector>
29
        <CollectorNumber>1426</CollectorNumber>
30
        <Country>Brasil</Country>
31
        <County>Carapebus</County>
32
        <DateLastModified>2007-12-14 10:48:03</DateLastModified>
51
        <BasisOfRecord>S</BasisOfRecord>
52
        <CatalogNumber>2875816</CatalogNumber>
53
        <CollectionCode>MOBOT_BR</CollectionCode>
54
        <Collector>C.A. Cid, J. Ramos, C.D. Mota &amp; N. Rosas</Collector>
55
        <CollectorNumber>1882</CollectorNumber>
56
        <Continent>South America</Continent>
57
        <ContinentOcean>South America</ContinentOcean>
58
        <Country>Brazil</Country>
59
        <DateLastModified>2010-12-06 10:03:24</DateLastModified>
33 60
        <DecimalLatitude>0</DecimalLatitude>
34
        <DecimalLongitude>999.9</DecimalLongitude>
35
        <Family>ARACEAE</Family>
36
        <Genus>Anthurium</Genus>
37
        <GeodeticDatum>WGS84</GeodeticDatum>
38
        <GlobalUniqueIdentifier>103390850</GlobalUniqueIdentifier>
39
        <InstitutionCode>JBRJ</InstitutionCode>
61
        <DecimalLongitude>0</DecimalLongitude>
62
        <Family>Fabaceae</Family>
63
        <Genus>Abarema</Genus>
64
        <GlobalUniqueIdentifier>7384117</GlobalUniqueIdentifier>
65
        <IdentifiedBy>Barneby &amp; Grimes,</IdentifiedBy>
66
        <InstitutionCode>MO</InstitutionCode>
40 67
        <Kingdom>Plantae</Kingdom>
41 68
        <Latitude>0</Latitude>
42
        <Longitude>999.9</Longitude>
43
        <ScientificName>Anthurium harrisii (Grah.) G. Don</ScientificName>
44
        <ScientificNameAuthor>(Grah.) G. Don</ScientificNameAuthor>
45
        <Species>harrisii</Species>
46
        <SpecificEpithet>harrisii</SpecificEpithet>
47
        <StateProvince>Rio de Janeiro</StateProvince>
69
        <Locality>Munic&#237;pio de Oriximin&#225;, rio Trombetas, mar gem direita, Porto Trombetas, estrada da Minera&#231;ao rio Norte km 60, atr&#225;s da Mina de Bauxita. Mata alta de terra firme, solo argiloso.</Locality>
70
        <Longitude>0</Longitude>
71
        <ScientificName>Abarema</ScientificName>
72
        <ScientificNameAuthor>Pittier</ScientificNameAuthor>
73
        <StateProvince>Par&#225;</StateProvince>
74
        <basisOfRecord>S</basisOfRecord>
75
        <catalogNumber>2875816</catalogNumber>
76
        <collectionCode>MOBOT_BR</collectionCode>
77
        <collectionID>88</collectionID>
78
        <continent>South America</continent>
79
        <country>Brazil</country>
80
        <dcterms:modified>2010-12-06 10:03:24</dcterms:modified>
81
        <decimalLatitude>0</decimalLatitude>
82
        <decimalLongitude>0</decimalLongitude>
83
        <family>Fabaceae</family>
84
        <genus>Abarema</genus>
85
        <identifiedBy>Barneby &amp; Grimes,</identifiedBy>
86
        <institutionCode>MO</institutionCode>
87
        <kingdom>Plantae</kingdom>
88
        <locality>Munic&#237;pio de Oriximin&#225;, rio Trombetas, mar gem direita, Porto Trombetas, estrada da Minera&#231;ao rio Norte km 60, atr&#225;s da Mina de Bauxita. Mata alta de terra firme, solo argiloso.</locality>
89
        <recordNumber>1882</recordNumber>
90
        <recordedBy>C.A. Cid, J. Ramos, C.D. Mota &amp; N. Rosas</recordedBy>
91
        <scientificName>Abarema</scientificName>
92
        <scientificNameAuthorship>Pittier</scientificNameAuthorship>
93
        <stateProvince>Par&#225;</stateProvince>
48 94
    </list>
49 95
</DwC>
inputs/SpeciesLink/test/VegBIEN.specimens.xml.ref
10 10
                                <locationdetermination>
11 11
                                    <namedplace_id>
12 12
                                        <namedplace>
13
                                            <rank>country</rank>
14
                                            <placename>Brasil</placename>
13
                                            <rank>stateProvince</rank>
14
                                            <placename>Amap&#225;</placename>
15
                                            <parent_id>
16
                                                <namedplace>
17
                                                    <rank>country</rank>
18
                                                    <placename>Brazil</placename>
19
                                                    <parent_id>
20
                                                        <namedplace>
21
                                                            <rank>continent</rank>
22
                                                            <placename>South America</placename>
23
                                                        </namedplace>
24
                                                    </parent_id>
25
                                                </namedplace>
26
                                            </parent_id>
15 27
                                        </namedplace>
16 28
                                    </namedplace_id>
17
                                    <latitude/>
18
                                    <longitude>999.9</longitude>
29
                                    <latitude>0.17</latitude>
30
                                    <longitude>-51.62</longitude>
19 31
                                </locationdetermination>
20
                                <centerlatitude/>
21
                                <centerlongitude>999.9</centerlongitude>
32
                                <locationnarrative>Camaipi. Embrapa reserve and vicinity</locationnarrative>
33
                                <centerlatitude>0.17</centerlatitude>
34
                                <centerlongitude>-51.62</centerlongitude>
22 35
                            </location>
23 36
                        </location_id>
24 37
                    </locationevent>
25 38
                </locationevent_id>
26 39
                <taxondetermination>
27 40
                    <role>identifier</role>
41
                    <iscurrent>true</iscurrent>
42
                    <party_id>
43
                        <party>
44
                            <givenname>R.</givenname>
45
                            <middlename></middlename>
46
                            <surname>Garcia,</surname>
47
                        </party>
48
                    </party_id>
28 49
                    <isoriginal>true</isoriginal>
29
                    <iscurrent>true</iscurrent>
30 50
                    <plantconcept_id>
31 51
                        <plantconcept>
32 52
                            <plantname_id>
33 53
                                <plantname>
34 54
                                    <rank>binomial</rank>
35
                                    <plantname>Anthurium harrisii (Grah.) G. Don</plantname>
55
                                    <plantname>Aa</plantname>
36 56
                                    <parent_id>
37 57
                                        <plantname>
38 58
                                            <rank>authority</rank>
39
                                            <plantname>(Grah.) G. Don</plantname>
59
                                            <plantname>Rchb. f.</plantname>
40 60
                                            <parent_id>
41 61
                                                <plantname>
42
                                                    <rank>species</rank>
43
                                                    <plantname>harrisii</plantname>
62
                                                    <rank>genus</rank>
63
                                                    <plantname>Aa</plantname>
44 64
                                                    <parent_id>
45 65
                                                        <plantname>
46
                                                            <rank>genus</rank>
47
                                                            <plantname>Anthurium</plantname>
66
                                                            <rank>family</rank>
67
                                                            <plantname>Orchidaceae</plantname>
48 68
                                                            <parent_id>
49 69
                                                                <plantname>
50
                                                                    <rank>family</rank>
51
                                                                    <plantname>ARACEAE</plantname>
52
                                                                    <parent_id>
53
                                                                        <plantname>
54
                                                                            <rank>kingdom</rank>
55
                                                                            <plantname>Plantae</plantname>
56
                                                                        </plantname>
57
                                                                    </parent_id>
70
                                                                    <rank>kingdom</rank>
71
                                                                    <plantname>Plantae</plantname>
58 72
                                                                </plantname>
59 73
                                                            </parent_id>
60 74
                                                        </plantname>
......
68 82
                        </plantconcept>
69 83
                    </plantconcept_id>
70 84
                </taxondetermination>
85
                <verbatimcollectorname>S. Mori, B. Rabelo, H. Belo, J. Cardoso, D. Daly, R. Nonato &amp; M.R. dos Santos</verbatimcollectorname>
71 86
            </taxonoccurrence>
72 87
        </taxonoccurrence_id>
73
        <collectioncode_dwc>JBRJ_RBdna</collectioncode_dwc>
88
        <collectioncode_dwc>MOBOT_BR</collectioncode_dwc>
74 89
        <datasource_id><party><organizationname>SpeciesLink</organizationname></party></datasource_id>
75
        <catalognumber_dwc>1354</catalognumber_dwc>
76
        <sourceaccessioncode>103390849</sourceaccessioncode>
90
        <catalognumber_dwc>3142542</catalognumber_dwc>
91
        <sourceaccessioncode>7384116</sourceaccessioncode>
92
        <collectionnumber>16135</collectionnumber>
77 93
    </specimenreplicate>
78 94
    <specimenreplicate id="1">
79 95
        <taxonoccurrence_id>
......
85 101
                                <locationdetermination>
86 102
                                    <namedplace_id>
87 103
                                        <namedplace>
88
                                            <rank>county</rank>
89
                                            <placename>Carapebus</placename>
104
                                            <rank>stateProvince</rank>
105
                                            <placename>Par&#225;</placename>
90 106
                                            <parent_id>
91 107
                                                <namedplace>
92
                                                    <rank>stateProvince</rank>
93
                                                    <placename>Rio de Janeiro</placename>
108
                                                    <rank>country</rank>
109
                                                    <placename>Brazil</placename>
94 110
                                                    <parent_id>
95 111
                                                        <namedplace>
96
                                                            <rank>country</rank>
97
                                                            <placename>Brasil</placename>
112
                                                            <rank>continent</rank>
113
                                                            <placename>South America</placename>
98 114
                                                        </namedplace>
99 115
                                                    </parent_id>
100 116
                                                </namedplace>
......
102 118
                                        </namedplace>
103 119
                                    </namedplace_id>
104 120
                                    <latitude/>
105
                                    <longitude>999.9</longitude>
121
                                    <longitude/>
106 122
                                </locationdetermination>
123
                                <locationnarrative>Munic&#237;pio de Oriximin&#225;, rio Trombetas, mar gem direita, Porto Trombetas, estrada da Minera&#231;ao rio Norte km 60, atr&#225;s da Mina de Bauxita. Mata alta de terra firme, solo argiloso.</locationnarrative>
107 124
                                <centerlatitude/>
108
                                <centerlongitude>999.9</centerlongitude>
125
                                <centerlongitude/>
109 126
                            </location>
110 127
                        </location_id>
111 128
                    </locationevent>
112 129
                </locationevent_id>
113 130
                <taxondetermination>
114 131
                    <role>identifier</role>
132
                    <iscurrent>true</iscurrent>
133
                    <party_id>
134
                        <party>
135
                            <givenname>Barneby</givenname>
136
                            <middlename>&amp;</middlename>
137
                            <surname>Grimes,</surname>
138
                        </party>
139
                    </party_id>
115 140
                    <isoriginal>true</isoriginal>
116
                    <iscurrent>true</iscurrent>
117 141
                    <plantconcept_id>
118 142
                        <plantconcept>
119 143
                            <plantname_id>
120 144
                                <plantname>
121 145
                                    <rank>binomial</rank>
122
                                    <plantname>Anthurium harrisii (Grah.) G. Don</plantname>
146
                                    <plantname>Abarema</plantname>
123 147
                                    <parent_id>
124 148
                                        <plantname>
125 149
                                            <rank>authority</rank>
126
                                            <plantname>(Grah.) G. Don</plantname>
150
                                            <plantname>Pittier</plantname>
127 151
                                            <parent_id>
128 152
                                                <plantname>
129
                                                    <rank>species</rank>
130
                                                    <plantname>harrisii</plantname>
153
                                                    <rank>genus</rank>
154
                                                    <plantname>Abarema</plantname>
131 155
                                                    <parent_id>
132 156
                                                        <plantname>
133
                                                            <rank>genus</rank>
134
                                                            <plantname>Anthurium</plantname>
157
                                                            <rank>family</rank>
158
                                                            <plantname>Fabaceae</plantname>
135 159
                                                            <parent_id>
136 160
                                                                <plantname>
137
                                                                    <rank>family</rank>
138
                                                                    <plantname>ARACEAE</plantname>
139
                                                                    <parent_id>
140
                                                                        <plantname>
141
                                                                            <rank>kingdom</rank>
142
                                                                            <plantname>Plantae</plantname>
143
                                                                        </plantname>
144
                                                                    </parent_id>
161
                                                                    <rank>kingdom</rank>
162
                                                                    <plantname>Plantae</plantname>
145 163
                                                                </plantname>
146 164
                                                            </parent_id>
147 165
                                                        </plantname>
......
155 173
                        </plantconcept>
156 174
                    </plantconcept_id>
157 175
                </taxondetermination>
158
                <verbatimcollectorname>Nadruz  M.</verbatimcollectorname>
176
                <verbatimcollectorname>C.A. Cid, J. Ramos, C.D. Mota &amp; N. Rosas</verbatimcollectorname>
159 177
            </taxonoccurrence>
160 178
        </taxonoccurrence_id>
161
        <collectioncode_dwc>JBRJ_RBdna</collectioncode_dwc>
179
        <collectioncode_dwc>MOBOT_BR</collectioncode_dwc>
162 180
        <datasource_id><party><organizationname>SpeciesLink</organizationname></party></datasource_id>
163
        <catalognumber_dwc>1355</catalognumber_dwc>
164
        <sourceaccessioncode>103390850</sourceaccessioncode>
165
        <collectionnumber>1426</collectionnumber>
181
        <catalognumber_dwc>2875816</catalognumber_dwc>
182
        <sourceaccessioncode>7384117</sourceaccessioncode>
183
        <collectionnumber>1882</collectionnumber>
166 184
    </specimenreplicate>
167 185
</VegBIEN>
inputs/SpeciesLink/maps/src.specimens.csv
1
"SpeciesLink[DwC,dwcore,darwin1,curatorial,geospatial]","Original name"
2
"GlobalUniqueIdentifier","dwcoreGlobalUniqueIdentifier"
3
"DateLastModified","dwcoreDateLastModified"
4
"BasisOfRecord","dwcoreBasisOfRecord"
5
"InstitutionCode","dwcoreInstitutionCode"
6
"CollectionCode","dwcoreCollectionCode"
7
"CatalogNumber","dwcoreCatalogNumber"
8
"Remarks","dwcoreRemarks"
9
"ScientificName","dwcoreScientificName"
10
"Kingdom","dwcoreKingdom"
11
"Phylum","dwcorePhylum"
12
"Class","dwcoreClass"
13
"Order","dwcoreOrder"
14
"Family","dwcoreFamily"
15
"Genus","dwcoreGenus"
16
"SpecificEpithet","dwcoreSpecificEpithet"
17
"InfraspecificEpithet","dwcoreInfraspecificEpithet"
18
"AuthorYearOfScientificName","dwcoreAuthorYearOfScientificName"
19
"Continent","dwcoreContinent"
20
"Country","dwcoreCountry"
21
"StateProvince","dwcoreStateProvince"
22
"County","dwcoreCounty"
23
"Locality","dwcoreLocality"
24
"MinimumElevationInMeters","dwcoreMinimumElevationInMeters"
25
"MaximumElevationInMeters","dwcoreMaximumElevationInMeters"
26
"MinimumDepthInMeters","dwcoreMinimumDepthInMeters"
27
"MaximumDepthInMeters","dwcoreMaximumDepthInMeters"
28
"DayOfYear","dwcoreDayOfYear"
29
"Collector","dwcoreCollector"
30
"Sex","dwcoreSex"
31
"IdentifiedBy","curatorialIdentifiedBy"
32
"CollectorNumber","curatorialCollectorNumber"
33
"FieldNumber","curatorialFieldNumber"
34
"TypeStatus","curatorialTypeStatus"
35
"IndividualCount","curatorialIndividualCount"
36
"DecimalLatitude","geospatialDecimalLatitude"
37
"DecimalLongitude","geospatialDecimalLongitude"
38
"GeodeticDatum","geospatialGeodeticDatum"
39
"DateLastModified","darwin1DateLastModified"
40
"InstitutionCode","darwin1InstitutionCode"
41
"CollectionCode","darwin1CollectionCode"
42
"CatalogNumber","darwin1CatalogNumber"
43
"ScientificName","darwin1ScientificName"
44
"BasisOfRecord","darwin1BasisOfRecord"
45
"Kingdom","darwin1Kingdom"
46
"Phylum","darwin1Phylum"
47
"Class","darwin1Class"
48
"Order","darwin1Order"
49
"Family","darwin1Family"
50
"Genus","darwin1Genus"
51
"Species","darwin1Species"
52
"Subspecies","darwin1Subspecies"
53
"ScientificNameAuthor","darwin1ScientificNameAuthor"
54
"IdentifiedBy","darwin1IdentifiedBy"
55
"YearIdentified","darwin1YearIdentified"
56
"MonthIdentified","darwin1MonthIdentified"
57
"DayIdentified","darwin1DayIdentified"
58
"TypeStatus","darwin1TypeStatus"
59
"CollectorNumber","darwin1CollectorNumber"
60
"FieldNumber","darwin1FieldNumber"
61
"Collector","darwin1Collector"
62
"YearCollected","darwin1YearCollected"
63
"MonthCollected","darwin1MonthCollected"
64
"DayCollected","darwin1DayCollected"
65
"JulianDay","darwin1JulianDay"
66
"TimeOfDay","darwin1TimeOfDay"
67
"ContinentOcean","darwin1ContinentOcean"
68
"Country","darwin1Country"
69
"StateProvince","darwin1StateProvince"
70
"County","darwin1County"
71
"Locality","darwin1Locality"
72
"Longitude","darwin1Longitude"
73
"Latitude","darwin1Latitude"
74
"CoordinatePrecision","darwin1CoordinatePrecision"
75
"BoundingBox","darwin1BoundingBox"
76
"MinimumElevation","darwin1MinimumElevation"
77
"MaximumElevation","darwin1MaximumElevation"
78
"MinimumDepth","darwin1MinimumDepth"
79
"MaximumDepth","darwin1MaximumDepth"
80
"Sex","darwin1Sex"
81
"PreparationType","darwin1PreparationType"
82
"IndividualCount","darwin1IndividualCount"
83
"PreviousCatalogNumber","darwin1PreviousCatalogNumber"
84
"RelationshipType","darwin1RelationshipType"
85
"RelatedCatalogItem","darwin1RelatedCatalogItem"
86
"Notes","darwin1Notes"
1
"SpeciesLink[DwC,http__rs_tdwg_org_dwc_dwcore_,http__rs_tdwg_org_dwc_curatorial_,http__rs_tdwg_org_dwc_geospatial_,http__purl_org_,http__rs_tdwg_org_dwc_terms_,http__digir_net_schema_conceptual_darwin_2003_1_0_]","Original name"
2
"GlobalUniqueIdentifier","http__rs_tdwg_org_dwc_dwcore_GlobalUniqueIdentifier"
3
"DateLastModified","http__rs_tdwg_org_dwc_dwcore_DateLastModified"
4
"BasisOfRecord","http__rs_tdwg_org_dwc_dwcore_BasisOfRecord"
5
"InstitutionCode","http__rs_tdwg_org_dwc_dwcore_InstitutionCode"
6
"CollectionCode","http__rs_tdwg_org_dwc_dwcore_CollectionCode"
7
"CatalogNumber","http__rs_tdwg_org_dwc_dwcore_CatalogNumber"
8
"Remarks","http__rs_tdwg_org_dwc_dwcore_Remarks"
9
"ScientificName","http__rs_tdwg_org_dwc_dwcore_ScientificName"
10
"Kingdom","http__rs_tdwg_org_dwc_dwcore_Kingdom"
11
"Phylum","http__rs_tdwg_org_dwc_dwcore_Phylum"
12
"Class","http__rs_tdwg_org_dwc_dwcore_Class"
13
"Order","http__rs_tdwg_org_dwc_dwcore_Order"
14
"Family","http__rs_tdwg_org_dwc_dwcore_Family"
15
"Genus","http__rs_tdwg_org_dwc_dwcore_Genus"
16
"SpecificEpithet","http__rs_tdwg_org_dwc_dwcore_SpecificEpithet"
17
"InfraspecificEpithet","http__rs_tdwg_org_dwc_dwcore_InfraspecificEpithet"
18
"AuthorYearOfScientificName","http__rs_tdwg_org_dwc_dwcore_AuthorYearOfScientificName"
19
"Continent","http__rs_tdwg_org_dwc_dwcore_Continent"
20
"Country","http__rs_tdwg_org_dwc_dwcore_Country"
21
"StateProvince","http__rs_tdwg_org_dwc_dwcore_StateProvince"
22
"County","http__rs_tdwg_org_dwc_dwcore_County"
23
"Locality","http__rs_tdwg_org_dwc_dwcore_Locality"
24
"MinimumElevationInMeters","http__rs_tdwg_org_dwc_dwcore_MinimumElevationInMeters"
25
"MaximumElevationInMeters","http__rs_tdwg_org_dwc_dwcore_MaximumElevationInMeters"
26
"MinimumDepthInMeters","http__rs_tdwg_org_dwc_dwcore_MinimumDepthInMeters"
27
"MaximumDepthInMeters","http__rs_tdwg_org_dwc_dwcore_MaximumDepthInMeters"
28
"DayOfYear","http__rs_tdwg_org_dwc_dwcore_DayOfYear"
29
"Collector","http__rs_tdwg_org_dwc_dwcore_Collector"
30
"Sex","http__rs_tdwg_org_dwc_dwcore_Sex"
31
"IdentifiedBy","http__rs_tdwg_org_dwc_curatorial_IdentifiedBy"
32
"CollectorNumber","http__rs_tdwg_org_dwc_curatorial_CollectorNumber"
33
"FieldNumber","http__rs_tdwg_org_dwc_curatorial_FieldNumber"
34
"TypeStatus","http__rs_tdwg_org_dwc_curatorial_TypeStatus"
35
"IndividualCount","http__rs_tdwg_org_dwc_curatorial_IndividualCount"
36
"DecimalLatitude","http__rs_tdwg_org_dwc_geospatial_DecimalLatitude"
37
"DecimalLongitude","http__rs_tdwg_org_dwc_geospatial_DecimalLongitude"
38
"VerbatimLatitude","http__rs_tdwg_org_dwc_geospatial_VerbatimLatitude"
39
"VerbatimLongitude","http__rs_tdwg_org_dwc_geospatial_VerbatimLongitude"
40
"dc_terms_modified","http__purl_org_dc_terms_modified"
41
"collectionID","http__rs_tdwg_org_dwc_terms_collectionID"
42
"institutionCode","http__rs_tdwg_org_dwc_terms_institutionCode"
43
"collectionCode","http__rs_tdwg_org_dwc_terms_collectionCode"
44
"basisOfRecord","http__rs_tdwg_org_dwc_terms_basisOfRecord"
45
"identifiedBy","http__rs_tdwg_org_dwc_terms_identifiedBy"
46
"dateIdentified","http__rs_tdwg_org_dwc_terms_dateIdentified"
47
"typeStatus","http__rs_tdwg_org_dwc_terms_typeStatus"
48
"catalogNumber","http__rs_tdwg_org_dwc_terms_catalogNumber"
49
"occurrenceRemarks","http__rs_tdwg_org_dwc_terms_occurrenceRemarks"
50
"recordNumber","http__rs_tdwg_org_dwc_terms_recordNumber"
51
"recordedBy","http__rs_tdwg_org_dwc_terms_recordedBy"
52
"individualCount","http__rs_tdwg_org_dwc_terms_individualCount"
53
"sex","http__rs_tdwg_org_dwc_terms_sex"
54
"preparations","http__rs_tdwg_org_dwc_terms_preparations"
55
"otherCatalogNumbers","http__rs_tdwg_org_dwc_terms_otherCatalogNumbers"
56
"eventTime","http__rs_tdwg_org_dwc_terms_eventTime"
57
"startDayOfYear","http__rs_tdwg_org_dwc_terms_startDayOfYear"
58
"endDayOfYear","http__rs_tdwg_org_dwc_terms_endDayOfYear"
59
"year","http__rs_tdwg_org_dwc_terms_year"
60
"month","http__rs_tdwg_org_dwc_terms_month"
61
"day","http__rs_tdwg_org_dwc_terms_day"
62
"fieldNumber","http__rs_tdwg_org_dwc_terms_fieldNumber"
63
"continent","http__rs_tdwg_org_dwc_terms_continent"
64
"country","http__rs_tdwg_org_dwc_terms_country"
65
"stateProvince","http__rs_tdwg_org_dwc_terms_stateProvince"
66
"county","http__rs_tdwg_org_dwc_terms_county"
67
"locality","http__rs_tdwg_org_dwc_terms_locality"
68
"minimumElevationInMeters","http__rs_tdwg_org_dwc_terms_minimumElevationInMeters"
69
"maximumElevationInMeters","http__rs_tdwg_org_dwc_terms_maximumElevationInMeters"
70
"minimumDepthInMeters","http__rs_tdwg_org_dwc_terms_minimumDepthInMeters"
71
"maximumDepthInMeters","http__rs_tdwg_org_dwc_terms_maximumDepthInMeters"
72
"verbatimLatitude","http__rs_tdwg_org_dwc_terms_verbatimLatitude"
73
"verbatimLongitude","http__rs_tdwg_org_dwc_terms_verbatimLongitude"
74
"decimalLatitude","http__rs_tdwg_org_dwc_terms_decimalLatitude"
75
"decimalLongitude","http__rs_tdwg_org_dwc_terms_decimalLongitude"
76
"coordinateUncertaintyInMeters","http__rs_tdwg_org_dwc_terms_coordinateUncertaintyInMeters"
77
"scientificName","http__rs_tdwg_org_dwc_terms_scientificName"
78
"kingdom","http__rs_tdwg_org_dwc_terms_kingdom"
79
"phylum","http__rs_tdwg_org_dwc_terms_phylum"
80
"class","http__rs_tdwg_org_dwc_terms_class"
81
"order","http__rs_tdwg_org_dwc_terms_order"
82
"family","http__rs_tdwg_org_dwc_terms_family"
83
"genus","http__rs_tdwg_org_dwc_terms_genus"
84
"specificEpithet","http__rs_tdwg_org_dwc_terms_specificEpithet"
85
"infraspecificEpithet","http__rs_tdwg_org_dwc_terms_infraspecificEpithet"
86
"scientificNameAuthorship","http__rs_tdwg_org_dwc_terms_scientificNameAuthorship"
87
"DateLastModified","http__digir_net_schema_conceptual_darwin_2003_1_0_DateLastModified"
88
"InstitutionCode","http__digir_net_schema_conceptual_darwin_2003_1_0_InstitutionCode"
89
"CollectionCode","http__digir_net_schema_conceptual_darwin_2003_1_0_CollectionCode"
90
"CatalogNumber","http__digir_net_schema_conceptual_darwin_2003_1_0_CatalogNumber"
91
"ScientificName","http__digir_net_schema_conceptual_darwin_2003_1_0_ScientificName"
92
"BasisOfRecord","http__digir_net_schema_conceptual_darwin_2003_1_0_BasisOfRecord"
93
"Kingdom","http__digir_net_schema_conceptual_darwin_2003_1_0_Kingdom"
94
"Phylum","http__digir_net_schema_conceptual_darwin_2003_1_0_Phylum"
95
"Class","http__digir_net_schema_conceptual_darwin_2003_1_0_Class"
96
"Order","http__digir_net_schema_conceptual_darwin_2003_1_0_Order"
97
"Family","http__digir_net_schema_conceptual_darwin_2003_1_0_Family"
98
"Genus","http__digir_net_schema_conceptual_darwin_2003_1_0_Genus"
99
"Species","http__digir_net_schema_conceptual_darwin_2003_1_0_Species"
100
"Subspecies","http__digir_net_schema_conceptual_darwin_2003_1_0_Subspecies"
101
"ScientificNameAuthor","http__digir_net_schema_conceptual_darwin_2003_1_0_ScientificNameAuthor"
102
"IdentifiedBy","http__digir_net_schema_conceptual_darwin_2003_1_0_IdentifiedBy"
103
"YearIdentified","http__digir_net_schema_conceptual_darwin_2003_1_0_YearIdentified"
104
"MonthIdentified","http__digir_net_schema_conceptual_darwin_2003_1_0_MonthIdentified"
105
"DayIdentified","http__digir_net_schema_conceptual_darwin_2003_1_0_DayIdentified"
106
"TypeStatus","http__digir_net_schema_conceptual_darwin_2003_1_0_TypeStatus"
107
"CollectorNumber","http__digir_net_schema_conceptual_darwin_2003_1_0_CollectorNumber"
108
"FieldNumber","http__digir_net_schema_conceptual_darwin_2003_1_0_FieldNumber"
109
"Collector","http__digir_net_schema_conceptual_darwin_2003_1_0_Collector"
110
"YearCollected","http__digir_net_schema_conceptual_darwin_2003_1_0_YearCollected"
111
"MonthCollected","http__digir_net_schema_conceptual_darwin_2003_1_0_MonthCollected"
112
"DayCollected","http__digir_net_schema_conceptual_darwin_2003_1_0_DayCollected"
113
"JulianDay","http__digir_net_schema_conceptual_darwin_2003_1_0_JulianDay"
114
"TimeOfDay","http__digir_net_schema_conceptual_darwin_2003_1_0_TimeOfDay"
115
"ContinentOcean","http__digir_net_schema_conceptual_darwin_2003_1_0_ContinentOcean"
116
"Country","http__digir_net_schema_conceptual_darwin_2003_1_0_Country"
117
"StateProvince","http__digir_net_schema_conceptual_darwin_2003_1_0_StateProvince"
118
"County","http__digir_net_schema_conceptual_darwin_2003_1_0_County"
119
"Locality","http__digir_net_schema_conceptual_darwin_2003_1_0_Locality"
120
"Longitude","http__digir_net_schema_conceptual_darwin_2003_1_0_Longitude"
121
"Latitude","http__digir_net_schema_conceptual_darwin_2003_1_0_Latitude"
122
"CoordinatePrecision","http__digir_net_schema_conceptual_darwin_2003_1_0_CoordinatePrecision"
123
"BoundingBox","http__digir_net_schema_conceptual_darwin_2003_1_0_BoundingBox"
124
"MinimumElevation","http__digir_net_schema_conceptual_darwin_2003_1_0_MinimumElevation"
125
"MaximumElevation","http__digir_net_schema_conceptual_darwin_2003_1_0_MaximumElevation"
126
"MinimumDepth","http__digir_net_schema_conceptual_darwin_2003_1_0_MinimumDepth"
127
"MaximumDepth","http__digir_net_schema_conceptual_darwin_2003_1_0_MaximumDepth"
128
"Sex","http__digir_net_schema_conceptual_darwin_2003_1_0_Sex"
129
"PreparationType","http__digir_net_schema_conceptual_darwin_2003_1_0_PreparationType"
130
"IndividualCount","http__digir_net_schema_conceptual_darwin_2003_1_0_IndividualCount"
131
"PreviousCatalogNumber","http__digir_net_schema_conceptual_darwin_2003_1_0_PreviousCatalogNumber"
132
"RelationshipType","http__digir_net_schema_conceptual_darwin_2003_1_0_RelationshipType"
133
"RelatedCatalogItem","http__digir_net_schema_conceptual_darwin_2003_1_0_RelatedCatalogItem"
134
"Notes","http__digir_net_schema_conceptual_darwin_2003_1_0_Notes"
inputs/SpeciesLink/maps/DwC.specimens.csv
1
"SpeciesLink[DwC,dwcore,darwin1,curatorial,geospatial]","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments
1
"SpeciesLink[DwC,http__rs_tdwg_org_dwc_dwcore_,http__rs_tdwg_org_dwc_curatorial_,http__rs_tdwg_org_dwc_geospatial_,http__purl_org_,http__rs_tdwg_org_dwc_terms_,http__digir_net_schema_conceptual_darwin_2003_1_0_]","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments
2 2
AuthorYearOfScientificName,ScientificNameAuthor,
3 3
DayOfYear,JulianDay,
4
dc_terms_modified,dcterms:modified,
inputs/SpeciesLink/maps/DwC.specimens.full.csv
1
"SpeciesLink[DwC,dwcore,darwin1,curatorial,geospatial]","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments
1
"SpeciesLink[DwC,http__rs_tdwg_org_dwc_dwcore_,http__rs_tdwg_org_dwc_curatorial_,http__rs_tdwg_org_dwc_geospatial_,http__purl_org_,http__rs_tdwg_org_dwc_terms_,http__digir_net_schema_conceptual_darwin_2003_1_0_]","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments
2 2
BasisOfRecord,BasisOfRecord
3 3
BoundingBox,BoundingBox
4 4
CatalogNumber,CatalogNumber
......
19 19
Family,Family
20 20
FieldNumber,FieldNumber
21 21
Genus,Genus
22
GeodeticDatum,GeodeticDatum
23 22
GlobalUniqueIdentifier,GlobalUniqueIdentifier
24 23
IdentifiedBy,IdentifiedBy
25 24
IndividualCount,IndividualCount
......
59 58
Subspecies,Subspecies
60 59
TimeOfDay,TimeOfDay
61 60
TypeStatus,TypeStatus
61
VerbatimLatitude,VerbatimLatitude
62
VerbatimLongitude,VerbatimLongitude
62 63
YearCollected,YearCollected
63 64
YearIdentified,YearIdentified
65
basisOfRecord,basisOfRecord
66
catalogNumber,catalogNumber
67
class,class
68
collectionCode,collectionCode
69
collectionID,collectionID
70
continent,continent
71
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters
72
country,country
73
county,county
74
dateIdentified,dateIdentified
75
day,day
76
dc_terms_modified,dcterms:modified,
77
decimalLatitude,decimalLatitude
78
decimalLongitude,decimalLongitude
79
endDayOfYear,endDayOfYear
80
eventTime,eventTime
81
family,family
82
fieldNumber,fieldNumber
83
genus,genus
84
identifiedBy,identifiedBy
85
individualCount,individualCount
86
infraspecificEpithet,infraspecificEpithet
87
institutionCode,institutionCode
88
kingdom,kingdom
89
locality,locality
90
maximumDepthInMeters,maximumDepthInMeters
91
maximumElevationInMeters,maximumElevationInMeters
92
minimumDepthInMeters,minimumDepthInMeters
93
minimumElevationInMeters,minimumElevationInMeters
94
month,month
95
occurrenceRemarks,occurrenceRemarks
96
order,order
97
otherCatalogNumbers,otherCatalogNumbers
98
phylum,phylum
99
preparations,preparations
100
recordNumber,recordNumber
101
recordedBy,recordedBy
102
scientificName,scientificName
103
scientificNameAuthorship,scientificNameAuthorship
104
sex,sex
105
specificEpithet,specificEpithet
106
startDayOfYear,startDayOfYear
107
stateProvince,stateProvince
108
typeStatus,typeStatus
109
verbatimLatitude,verbatimLatitude
110
verbatimLongitude,verbatimLongitude
111
year,year
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
1
"SpeciesLink[DwC,dwcore,darwin1,curatorial,geospatial]",VegBIEN:/specimenreplicate,Comments,Order
1
"SpeciesLink[DwC,http__rs_tdwg_org_dwc_dwcore_,http__rs_tdwg_org_dwc_curatorial_,http__rs_tdwg_org_dwc_geospatial_,http__purl_org_,http__rs_tdwg_org_dwc_terms_,http__digir_net_schema_conceptual_darwin_2003_1_0_]",VegBIEN:/specimenreplicate,Comments,Order
2
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
2 3
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
3 4
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
4 5
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
6
county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
5 7
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
8
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
6 9
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63
10
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63
7 11
Continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59
8 12
ContinentOcean,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59
13
continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59
9 14
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
15
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
10 16
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}",,71
11 17
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}",,71
18
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}",,71
12 19
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
13 20
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
21
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
14 22
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
23
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
15 24
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
25
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
26
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
16 27
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
28
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
17 29
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
30
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
31
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
18 32
MaximumDepth,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75
19 33
MaximumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75
34
maximumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75
20 35
MinimumDepth,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74
21 36
MinimumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74
37
minimumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74
22 38
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
23 39
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
24 40
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
25 41
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
26 42
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
27 43
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
44
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
28 45
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
46
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
29 47
ScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134
48
scientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134
30 49
AuthorYearOfScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
31 50
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
51
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
32 52
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
33 53
Subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
54
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
34 55
Species,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
35 56
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
57
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
36 58
Genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147
59
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147
37 60
Family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146
61
family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146
38 62
Order,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145
63
order,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145
39 64
Class,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144
65
class,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144
40 66
Phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143
67
phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143
41 68
Kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142
69
kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142
42 70
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
71
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
43 72
CollectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
73
collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
44 74
Sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",26
75
sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",26
45 76
Notes,/description/_merge/1,,
46 77
Remarks,/description/_merge/2,,158
47 78
CatalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
79
catalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
48 80
GlobalUniqueIdentifier,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
49 81
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
82
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
83
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
50 84
FieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
85
fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
51 86
BasisOfRecord,,** No join mapping for BasisOfRecord ** 
52 87
DateLastModified,,** No join mapping for DateLastModified ** 
53 88
DayOfYear,,** No join mapping for JulianDay ** 
54
GeodeticDatum,,** No join mapping for GeodeticDatum ** 
55 89
IndividualCount,,** No join mapping for IndividualCount ** 
56 90
InstitutionCode,,** No join mapping for InstitutionCode ** 
57 91
JulianDay,,** No join mapping for JulianDay ** 
......
61 95
RelationshipType,,** No join mapping for RelationshipType ** 
62 96
TimeOfDay,,** No join mapping for TimeOfDay ** 
63 97
TypeStatus,,** No join mapping for TypeStatus ** 
98
basisOfRecord,,** No join mapping for basisOfRecord ** 
99
day,,** No join mapping for day ** 
100
dc_terms_modified,,** No join mapping for dcterms:modified ** 
101
endDayOfYear,,** No join mapping for endDayOfYear ** 
102
eventTime,,** No join mapping for eventTime ** 
103
individualCount,,** No join mapping for individualCount ** 
104
institutionCode,,** No join mapping for institutionCode ** 
105
month,,** No join mapping for month ** 
106
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 
107
otherCatalogNumbers,,** No join mapping for otherCatalogNumbers ** 
108
preparations,,** No join mapping for preparations ** 
109
startDayOfYear,,** No join mapping for startDayOfYear ** 
110
typeStatus,,** No join mapping for typeStatus ** 
111
year,,** No join mapping for year ** 

Also available in: Unified diff