Project

General

Profile

« Previous | Next » 

Revision 1441

Added by Aaron Marcuse-Kubitza almost 13 years ago

Renamed inputs/NYBG to inputs/NY to match herbarium code

View differences:

inputs/NYBG/test/VegX.specimens.xml.ref
1 
<?xml version="1.0" ?>
2 
<VegX>
3 
    <individualOrganismObservations>
4 
        <individualOrganismObservation id="0">
5 
            <individualOrganismID>0</individualOrganismID>
6 
            <plotObservationID>0</plotObservationID>
7 
            <simpleUserdefined>
8 
                <name>habitat</name>
9 
                <value>Floodplain forest</value>
10 
            </simpleUserdefined>
11 
            <simpleUserdefined>
12 
                <name>plantFungusDescription</name>
13 
                <value>with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</value>
14 
            </simpleUserdefined>
15 
        </individualOrganismObservation>
16 
        <individualOrganismObservation id="1">
17 
            <individualOrganismID>1</individualOrganismID>
18 
            <plotObservationID>1</plotObservationID>
19 
        </individualOrganismObservation>
20 
    </individualOrganismObservations>
21 
    <individualOrganisms>
22 
        <individualOrganism id="0">
23 
            <taxonNameUsageConceptsID>0</taxonNameUsageConceptsID>
24 
        </individualOrganism>
25 
        <individualOrganism id="1">
26 
            <taxonNameUsageConceptsID>1</taxonNameUsageConceptsID>
27 
        </individualOrganism>
28 
    </individualOrganisms>
29 
    <taxonNameUsageConcepts>
30 
        <taxonNameUsageConcept id="0">
31 
            <partyWithRole>
32 
                <partyID>0</partyID>
33 
            </partyWithRole>
34 
            <authorCode>9877</authorCode>
35 
            <voucher>816590</voucher>
36 
        </taxonNameUsageConcept>
37 
        <taxonNameUsageConcept id="1">
38 
            <partyWithRole>
39 
                <partyID>2</partyID>
40 
            </partyWithRole>
41 
            <authorCode>545</authorCode>
42 
            <voucher>220541</voucher>
43 
        </taxonNameUsageConcept>
44 
    </taxonNameUsageConcepts>
45 
    <parties>
46 
        <party id="0">
47 
            <organizationName>NY Herbarium</organizationName>
48 
        </party>
49 
        <party id="1">
50 
            <individualName>
51 
                <givenName>R. B.</givenName>
52 
                <surName>Foster</surName>
53 
            </individualName>
54 
        </party>
55 
        <party id="2">
56 
            <organizationName>NY Herbarium</organizationName>
57 
        </party>
58 
        <party id="3">
59 
            <individualName>
60 
                <givenName>J. B.</givenName>
61 
                <surName>Walker</surName>
62 
            </individualName>
63 
        </party>
64 
    </parties>
65 
    <taxonDeterminations>
66 
        <taxonDetermination>
67 
            <taxonNameUsageConceptID>0</taxonNameUsageConceptID>
68 
            <partyWithRole>
69 
                <role>identifier</role>
70 
            </partyWithRole>
71 
            <taxonRelationshipAssertions>
72 
                <taxonRelationshipAssertion>
73 
                    <assertion>
74 
                        <taxonNameID>0</taxonNameID>
75 
                    </assertion>
76 
                </taxonRelationshipAssertion>
77 
                <taxonRelationshipAssertion>
78 
                    <assertion>
79 
                        <taxonConceptID>0</taxonConceptID>
80 
                    </assertion>
81 
                </taxonRelationshipAssertion>
82 
                <taxonRelationshipAssertion>
83 
                    <assertion>
84 
                        <taxonConceptID>1</taxonConceptID>
85 
                    </assertion>
86 
                </taxonRelationshipAssertion>
87 
                <taxonRelationshipAssertion>
88 
                    <assertion>
89 
                        <taxonConceptID>2</taxonConceptID>
90 
                    </assertion>
91 
                </taxonRelationshipAssertion>
92 
                <taxonRelationshipAssertion>
93 
                    <assertion>
94 
                        <taxonConceptID>3</taxonConceptID>
95 
                    </assertion>
96 
                </taxonRelationshipAssertion>
97 
                <taxonRelationshipAssertion>
98 
                    <assertion>
99 
                        <taxonConceptID>4</taxonConceptID>
100 
                    </assertion>
101 
                </taxonRelationshipAssertion>
102 
                <taxonRelationshipAssertion>
103 
                    <assertion>
104 
                        <taxonConceptID>5</taxonConceptID>
105 
                    </assertion>
106 
                </taxonRelationshipAssertion>
107 
            </taxonRelationshipAssertions>
108 
        </taxonDetermination>
109 
        <taxonDetermination>
110 
            <taxonNameUsageConceptID>0</taxonNameUsageConceptID>
111 
            <partyWithRole>
112 
                <role>collector</role>
113 
                <partyID>1</partyID>
114 
            </partyWithRole>
115 
        </taxonDetermination>
116 
        <taxonDetermination>
117 
            <taxonNameUsageConceptID>1</taxonNameUsageConceptID>
118 
            <partyWithRole>
119 
                <role>identifier</role>
120 
            </partyWithRole>
121 
            <taxonRelationshipAssertions>
122 
                <taxonRelationshipAssertion>
123 
                    <assertion>
124 
                        <taxonNameID>1</taxonNameID>
125 
                    </assertion>
126 
                </taxonRelationshipAssertion>
127 
                <taxonRelationshipAssertion>
128 
                    <assertion>
129 
                        <taxonConceptID>6</taxonConceptID>
130 
                    </assertion>
131 
                </taxonRelationshipAssertion>
132 
                <taxonRelationshipAssertion>
133 
                    <assertion>
134 
                        <taxonConceptID>7</taxonConceptID>
135 
                    </assertion>
136 
                </taxonRelationshipAssertion>
137 
                <taxonRelationshipAssertion>
138 
                    <assertion>
139 
                        <taxonConceptID>8</taxonConceptID>
140 
                    </assertion>
141 
                </taxonRelationshipAssertion>
142 
            </taxonRelationshipAssertions>
143 
        </taxonDetermination>
144 
        <taxonDetermination>
145 
            <taxonNameUsageConceptID>1</taxonNameUsageConceptID>
146 
            <partyWithRole>
147 
                <role>collector</role>
148 
                <partyID>3</partyID>
149 
            </partyWithRole>
150 
        </taxonDetermination>
151 
    </taxonDeterminations>
152 
    <taxonNames>
153 
        <taxonName id="0">
154 
            <Simple>Cariniana estrellensis (Raddi) Kuntze</Simple>
155 
        </taxonName>
156 
        <taxonName id="1">
157 
            <Simple>Scrophulariaceae</Simple>
158 
        </taxonName>
159 
    </taxonNames>
160 
    <taxonConcepts>
161 
        <taxonConcept id="0">
162 
            <Rank code="reg"/>
163 
            <Name>Plantae</Name>
164 
        </taxonConcept>
165 
        <taxonConcept id="1">
166 
            <Rank code="phyl_div"/>
167 
            <Name>Magnoliophyta (flowering plants)</Name>
168 
        </taxonConcept>
169 
        <taxonConcept id="2">
170 
            <Rank code="fam"/>
171 
            <Name>Lecythidaceae</Name>
172 
        </taxonConcept>
173 
        <taxonConcept id="3">
174 
            <Rank code="gen"/>
175 
            <Name>Cariniana</Name>
176 
        </taxonConcept>
177 
        <taxonConcept id="4">
178 
            <Rank code="sp"/>
179 
            <Name>estrellensis</Name>
180 
        </taxonConcept>
181 
        <taxonConcept id="5">
182 
            <Rank code="auth"/>
183 
            <Name>(Raddi) Kuntze</Name>
184 
        </taxonConcept>
185 
        <taxonConcept id="6">
186 
            <Rank code="reg"/>
187 
            <Name>Plantae</Name>
188 
        </taxonConcept>
189 
        <taxonConcept id="7">
190 
            <Rank code="phyl_div"/>
191 
            <Name>Magnoliophyta (flowering plants)</Name>
192 
        </taxonConcept>
193 
        <taxonConcept id="8">
194 
            <Rank code="fam"/>
195 
            <Name>Scrophulariaceae</Name>
196 
        </taxonConcept>
197 
    </taxonConcepts>
198 
    <plotObservations>
199 
        <plotObservation id="0">
200 
            <obsStartDate>1984-08-20</obsStartDate>
201 
            <plotUniqueIdentifierID>0</plotUniqueIdentifierID>
202 
        </plotObservation>
203 
        <plotObservation id="1">
204 
            <obsStartDate>1994-01-17</obsStartDate>
205 
            <plotUniqueIdentifierID>1</plotUniqueIdentifierID>
206 
        </plotObservation>
207 
    </plotObservations>
208 
    <plots>
209 
        <plot id="0">
210 
            <country>Peru</country>
211 
            <state>Madre de Dios</state>
212 
            <county>Man&#250;</county>
213 
            <simpleUserdefined>
214 
                <name>locality</name>
215 
                <value>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station</value>
216 
            </simpleUserdefined>
217 
            <geospatial>
218 
                <DecimalLongitude>-71.40000000</DecimalLongitude>
219 
                <DecimalLatitude>-11.80000000</DecimalLatitude>
220 
                <minimumElevationInMeters>350</minimumElevationInMeters>
221 
                <maximumElevationInMeters>350</maximumElevationInMeters>
222 
            </geospatial>
223 
        </plot>
224 
        <plot id="1">
225 
            <country>Belize</country>
226 
            <state>Belize District</state>
227 
            <simpleUserdefined>
228 
                <name>locality</name>
229 
                <value>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</value>
230 
            </simpleUserdefined>
231 
            <geospatial>
232 
                <DecimalLongitude>-88.50000000</DecimalLongitude>
233 
                <DecimalLatitude>17.40000000</DecimalLatitude>
234 
                <minimumElevationInMeters>15</minimumElevationInMeters>
235 
                <maximumElevationInMeters>15</maximumElevationInMeters>
236 
            </geospatial>
237 
        </plot>
238 
    </plots>
239 
</VegX>
inputs/NYBG/test/DwC.specimens.xml.ref
1 
<?xml version="1.0" ?>
2 
<DwC xmlns:dcterms="http://purl.org/dc/terms/">
3 
    <list id="0">
4 
        <institutionID>NYBG</institutionID>
5 
        <BasisOfRecord>S</BasisOfRecord>
6 
        <CatalogNumber>00682023</CatalogNumber>
7 
        <CollectionCode>Herbarium</CollectionCode>
8 
        <Collector>R. B. Foster</Collector>
9 
        <ContinentOcean>South America</ContinentOcean>
10 
        <Country>Peru</Country>
11 
        <County>Man&#250;</County>
12 
        <DateLastModified>2005-2-22T14:47:32.000EST</DateLastModified>
13 
        <DayCollected>20</DayCollected>
14 
        <Family>Lecythidaceae</Family>
15 
        <FieldNumber>9877</FieldNumber>
16 
        <Genus>Cariniana</Genus>
17 
        <Habitat>Floodplain forest</Habitat>
18 
        <InstitutionCode>NY</InstitutionCode>
19 
        <JulianDay>233</JulianDay>
20 
        <Kingdom>Plantae</Kingdom>
21 
        <Latitude>-11.80</Latitude>
22 
        <Locality>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station</Locality>
23 
        <Longitude>-71.40</Longitude>
24 
        <MaximumElevation>350</MaximumElevation>
25 
        <MinimumElevation>350</MinimumElevation>
26 
        <MonthCollected>8</MonthCollected>
27 
        <Notes>plant fungus: with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</Notes>
28 
        <Phylum>Magnoliophyta (flowering plants)</Phylum>
29 
        <ScientificName>Cariniana estrellensis (Raddi) Kuntze</ScientificName>
30 
        <ScientificNameAuthor>(Raddi) Kuntze</ScientificNameAuthor>
31 
        <Species>estrellensis</Species>
32 
        <StateProvince>Madre de Dios</StateProvince>
33 
        <YearCollected>1984</YearCollected>
34 
        <occurrenceID>816590</occurrenceID>
35 
    </list>
36 
    <list id="1">
37 
        <institutionID>NYBG</institutionID>
38 
        <BasisOfRecord>S</BasisOfRecord>
39 
        <CatalogNumber>200996</CatalogNumber>
40 
        <CollectionCode>Herbarium</CollectionCode>
41 
        <Collector>J. B. Walker</Collector>
42 
        <ContinentOcean>Central America</ContinentOcean>
43 
        <Country>Belize</Country>
44 
        <DateLastModified>2004-1-13T00:00EST</DateLastModified>
45 
        <DayCollected>17</DayCollected>
46 
        <Family>Scrophulariaceae</Family>
47 
        <FieldNumber>545</FieldNumber>
48 
        <InstitutionCode>NY</InstitutionCode>
49 
        <JulianDay>17</JulianDay>
50 
        <Kingdom>Plantae</Kingdom>
51 
        <Latitude>17.40</Latitude>
52 
        <Locality>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</Locality>
53 
        <Longitude>-88.50</Longitude>
54 
        <MaximumElevation>15</MaximumElevation>
55 
        <MinimumElevation>15</MinimumElevation>
56 
        <MonthCollected>1</MonthCollected>
57 
        <Phylum>Magnoliophyta (flowering plants)</Phylum>
58 
        <ScientificName>Scrophulariaceae</ScientificName>
59 
        <StateProvince>Belize District</StateProvince>
60 
        <YearCollected>1994</YearCollected>
61 
        <occurrenceID>220541</occurrenceID>
62 
    </list>
63 
</DwC>
inputs/NYBG/test/VegBIEN.specimens.xml.ref
1 
<?xml version="1.0" ?>
2 
<VegBIEN>
3 
    <specimenreplicate id="0">
4 
        <taxonoccurrence_id>
5 
            <taxonoccurrence>
6 
                <locationevent_id>
7 
                    <locationevent>
8 
                        <location_id>
9 
                            <location>
10 
                                <locationdetermination>
11 
                                    <namedplace_id>
12 
                                        <namedplace>
13 
                                            <rank>county</rank>
14 
                                            <placename>Man&#250;</placename>
15 
                                            <parent_id>
16 
                                                <namedplace>
17 
                                                    <rank>stateProvince</rank>
18 
                                                    <placename>Madre de Dios</placename>
19 
                                                    <parent_id>
20 
                                                        <namedplace>
21 
                                                            <rank>country</rank>
22 
                                                            <placename>Peru</placename>
23 
                                                        </namedplace>
24 
                                                    </parent_id>
25 
                                                </namedplace>
26 
                                            </parent_id>
27 
                                        </namedplace>
28 
                                    </namedplace_id>
29 
                                    <latitude>-11.80</latitude>
30 
                                    <longitude>-71.40</longitude>
31 
                                </locationdetermination>
32 
                                <locationnarrative>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station; habitat: Floodplain forest</locationnarrative>
33 
                                <elevation>350.0</elevation>
34 
                                <elevationrange>0.0</elevationrange>
35 
                                <centerlatitude>-11.80</centerlatitude>
36 
                                <centerlongitude>-71.40</centerlongitude>
37 
                            </location>
38 
                        </location_id>
39 
                        <obsstartdate>1984-08-20</obsstartdate>
40 
                        <obsenddate/>
41 
                    </locationevent>
42 
                </locationevent_id>
43 
                <taxondetermination>
44 
                    <role>identifier</role>
45 
                    <isoriginal>true</isoriginal>
46 
                    <iscurrent>true</iscurrent>
47 
                    <plantconcept_id>
48 
                        <plantconcept>
49 
                            <plantname_id>
50 
                                <plantname>
51 
                                    <rank>binomial</rank>
52 
                                    <plantname>Cariniana estrellensis (Raddi) Kuntze</plantname>
53 
                                    <parent_id>
54 
                                        <plantname>
55 
                                            <rank>authority</rank>
56 
                                            <plantname>(Raddi) Kuntze</plantname>
57 
                                            <parent_id>
58 
                                                <plantname>
59 
                                                    <rank>species</rank>
60 
                                                    <plantname>estrellensis</plantname>
61 
                                                    <parent_id>
62 
                                                        <plantname>
63 
                                                            <rank>genus</rank>
64 
                                                            <plantname>Cariniana</plantname>
65 
                                                            <parent_id>
66 
                                                                <plantname>
67 
                                                                    <rank>family</rank>
68 
                                                                    <plantname>Lecythidaceae</plantname>
69 
                                                                    <parent_id>
70 
                                                                        <plantname>
71 
                                                                            <rank>subkingdom</rank>
72 
                                                                            <plantname>Magnoliophyta (flowering plants)</plantname>
73 
                                                                            <parent_id>
74 
                                                                                <plantname>
75 
                                                                                    <rank>kingdom</rank>
76 
                                                                                    <plantname>Plantae</plantname>
77 
                                                                                </plantname>
78 
                                                                            </parent_id>
79 
                                                                        </plantname>
80 
                                                                    </parent_id>
81 
                                                                </plantname>
82 
                                                            </parent_id>
83 
                                                        </plantname>
84 
                                                    </parent_id>
85 
                                                </plantname>
86 
                                            </parent_id>
87 
                                        </plantname>
88 
                                    </parent_id>
89 
                                </plantname>
90 
                            </plantname_id>
91 
                        </plantconcept>
92 
                    </plantconcept_id>
93 
                </taxondetermination>
94 
                <verbatimcollectorname>R. B. Foster</verbatimcollectorname>
95 
            </taxonoccurrence>
96 
        </taxonoccurrence_id>
97 
        <collectioncode_dwc>Herbarium</collectioncode_dwc>
98 
        <description>plant fungus: with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</description>
99 
        <datasource_id><party><organizationname>NYBG</organizationname></party></datasource_id>
100 
        <catalognumber_dwc>00682023</catalognumber_dwc>
101 
        <sourceaccessioncode>816590</sourceaccessioncode>
102 
        <collectionnumber>9877</collectionnumber>
103 
    </specimenreplicate>
104 
    <specimenreplicate id="1">
105 
        <taxonoccurrence_id>
106 
            <taxonoccurrence>
107 
                <locationevent_id>
108 
                    <locationevent>
109 
                        <location_id>
110 
                            <location>
111 
                                <locationdetermination>
112 
                                    <namedplace_id>
113 
                                        <namedplace>
114 
                                            <rank>stateProvince</rank>
115 
                                            <placename>Belize District</placename>
116 
                                            <parent_id>
117 
                                                <namedplace>
118 
                                                    <rank>country</rank>
119 
                                                    <placename>Belize</placename>
120 
                                                </namedplace>
121 
                                            </parent_id>
122 
                                        </namedplace>
123 
                                    </namedplace_id>
124 
                                    <latitude>17.40</latitude>
125 
                                    <longitude>-88.50</longitude>
126 
                                </locationdetermination>
127 
                                <locationnarrative>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</locationnarrative>
128 
                                <elevation>15.0</elevation>
129 
                                <elevationrange>0.0</elevationrange>
130 
                                <centerlatitude>17.40</centerlatitude>
131 
                                <centerlongitude>-88.50</centerlongitude>
132 
                            </location>
133 
                        </location_id>
134 
                        <obsstartdate>1994-01-17</obsstartdate>
135 
                        <obsenddate/>
136 
                    </locationevent>
137 
                </locationevent_id>
138 
                <taxondetermination>
139 
                    <role>identifier</role>
140 
                    <isoriginal>true</isoriginal>
141 
                    <iscurrent>true</iscurrent>
142 
                    <plantconcept_id>
143 
                        <plantconcept>
144 
                            <plantname_id>
145 
                                <plantname>
146 
                                    <rank>binomial</rank>
147 
                                    <plantname>Scrophulariaceae</plantname>
148 
                                    <parent_id>
149 
                                        <plantname>
150 
                                            <rank>family</rank>
151 
                                            <plantname>Scrophulariaceae</plantname>
152 
                                            <parent_id>
153 
                                                <plantname>
154 
                                                    <rank>subkingdom</rank>
155 
                                                    <plantname>Magnoliophyta (flowering plants)</plantname>
156 
                                                    <parent_id>
157 
                                                        <plantname>
158 
                                                            <rank>kingdom</rank>
159 
                                                            <plantname>Plantae</plantname>
160 
                                                        </plantname>
161 
                                                    </parent_id>
162 
                                                </plantname>
163 
                                            </parent_id>
164 
                                        </plantname>
165 
                                    </parent_id>
166 
                                </plantname>
167 
                            </plantname_id>
168 
                        </plantconcept>
169 
                    </plantconcept_id>
170 
                </taxondetermination>
171 
                <verbatimcollectorname>J. B. Walker</verbatimcollectorname>
172 
            </taxonoccurrence>
173 
        </taxonoccurrence_id>
174 
        <collectioncode_dwc>Herbarium</collectioncode_dwc>
175 
        <datasource_id><party><organizationname>NYBG</organizationname></party></datasource_id>
176 
        <catalognumber_dwc>200996</catalognumber_dwc>
177 
        <sourceaccessioncode>220541</sourceaccessioncode>
178 
        <collectionnumber>545</collectionnumber>
179 
    </specimenreplicate>
180 
</VegBIEN>
inputs/NYBG/test/import.specimens.out.ref
1 
Inserted 29 new rows into database
inputs/NYBG/maps/DwC.specimens.csv
1 
"NYBG[DwC]","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/","Comments"
2 
"key",,
3 
"Locality","Locality/_merge/1",
4 
"MinimumElevation","MinimumElevation/_nullIf:[null=.]/value",
5 
"Notes","Notes/_merge/1",
6 
"PlantFungusDescription","Notes/_merge/2/_label[label=""plant fungus""]/value",
7 
"Substrate","Locality/_merge/2/_label[label=""substrate""]/value",
8 
"Vegetation","Locality/_merge/3/_label[label=""vegetation""]/value",
9 
"UniqueNYInternalRecordNumber","occurrenceID",
inputs/NYBG/maps/DwC.specimens.full.csv
1 
NYBG[DwC],"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments
2 
AcceptedNameUsage,AcceptedNameUsage
3 
AcceptedNameUsageID,AcceptedNameUsageID
4 
AssociatedMedia,AssociatedMedia
5 
AssociatedOccurrences,AssociatedOccurrences
6 
AssociatedReferences,AssociatedReferences
7 
AssociatedSequences,AssociatedSequences
8 
AssociatedTaxa,AssociatedTaxa
9 
BasisOfRecord,BasisOfRecord
10 
Bed,Bed
11 
Behavior,Behavior
12 
BoundingBox,BoundingBox
13 
CatalogNumber,CatalogNumber
14 
Class,Class
15 
CollectedDate,CollectedDate
16 
CollectionCode,CollectionCode
17 
CollectionID,CollectionID
18 
Collector,Collector
19 
CollectorNumber,CollectorNumber
20 
Continent,Continent
21 
ContinentOcean,ContinentOcean
22 
CoordinatePrecision,CoordinatePrecision
23 
CoordinateUncertaintyInMeters,CoordinateUncertaintyInMeters
24 
Country,Country
25 
CountryCode,CountryCode
26 
County,County
27 
DataGeneralizations,DataGeneralizations
28 
DatasetID,DatasetID
29 
DatasetName,DatasetName
30 
DateIdentified,DateIdentified
31 
DateLastModified,DateLastModified
32 
Day,Day
33 
DayCollected,DayCollected
34 
DayIdentified,DayIdentified
35 
Dcterms:accessRights,Dcterms:accessRights
36 
Dcterms:bibliographicCitation,Dcterms:bibliographicCitation
37 
Dcterms:language,Dcterms:language
38 
Dcterms:modified,Dcterms:modified
39 
Dcterms:references,Dcterms:references
40 
Dcterms:rights,Dcterms:rights
41 
Dcterms:rightsHolder,Dcterms:rightsHolder
42 
Dcterms:type,Dcterms:type
43 
DecimalLatitude,DecimalLatitude
44 
DecimalLongitude,DecimalLongitude
45 
Disposition,Disposition
46 
DynamicProperties,DynamicProperties
47 
EarliestAgeOrLowestStage,EarliestAgeOrLowestStage
48 
EarliestEonOrLowestEonothem,EarliestEonOrLowestEonothem
49 
EarliestEpochOrLowestSeries,EarliestEpochOrLowestSeries
50 
EarliestEraOrLowestErathem,EarliestEraOrLowestErathem
51 
EarliestPeriodOrLowestSystem,EarliestPeriodOrLowestSystem
52 
EndDayOfYear,EndDayOfYear
53 
EstablishmentMeans,EstablishmentMeans
54 
EventDate,EventDate
55 
EventID,EventID
56 
EventRemarks,EventRemarks
57 
EventTime,EventTime
58 
Family,Family
59 
FieldNotes,FieldNotes
60 
FieldNumber,FieldNumber
61 
FootprintSRS,FootprintSRS
62 
FootprintSpatialFit,FootprintSpatialFit
63 
FootprintWKT,FootprintWKT
64 
Formation,Formation
65 
Genus,Genus
66 
GeodeticDatum,GeodeticDatum
67 
GeologicalContextID,GeologicalContextID
68 
GeoreferenceProtocol,GeoreferenceProtocol
69 
GeoreferenceRemarks,GeoreferenceRemarks
70 
GeoreferenceSources,GeoreferenceSources
71 
GeoreferenceVerificationStatus,GeoreferenceVerificationStatus
72 
GeoreferencedBy,GeoreferencedBy
73 
GeoreferencedDate,GeoreferencedDate
74 
GlobalUniqueIdentifier,GlobalUniqueIdentifier
75 
Group,Group
76 
Habitat,Habitat
77 
HigherClassification,HigherClassification
78 
HigherGeography,HigherGeography
79 
HigherGeographyID,HigherGeographyID
80 
HighestBiostratigraphicZone,HighestBiostratigraphicZone
81 
IdentificationID,IdentificationID
82 
IdentificationQualifier,IdentificationQualifier
83 
IdentificationReferences,IdentificationReferences
84 
IdentificationRemarks,IdentificationRemarks
85 
IdentificationVerificationStatus,IdentificationVerificationStatus
86 
IdentifiedBy,IdentifiedBy
87 
IdentifiedDate,IdentifiedDate
88 
IndividualCount,IndividualCount
89 
IndividualID,IndividualID
90 
InformationWithheld,InformationWithheld
91 
InfraspecificEpithet,InfraspecificEpithet
92 
InstitutionCode,InstitutionCode
93 
InstitutionID,InstitutionID
94 
Island,Island
95 
IslandGroup,IslandGroup
96 
JulianDay,JulianDay
97 
Kingdom,Kingdom
98 
LatestAgeOrHighestStage,LatestAgeOrHighestStage
99 
LatestEonOrHighestEonothem,LatestEonOrHighestEonothem
100 
LatestEpochOrHighestSeries,LatestEpochOrHighestSeries
101 
LatestEraOrHighestErathem,LatestEraOrHighestErathem
102 
LatestPeriodOrHighestSystem,LatestPeriodOrHighestSystem
103 
Latitude,Latitude
104 
LifeStage,LifeStage
105 
LithostratigraphicTerms,LithostratigraphicTerms
106 
Locality,Locality/_merge/1,
107 
Substrate,"Locality/_merge/2/_label[label=""substrate""]/value",
108 
Vegetation,"Locality/_merge/3/_label[label=""vegetation""]/value",
109 
LocationAccordingTo,LocationAccordingTo
110 
LocationID,LocationID
111 
LocationRemarks,LocationRemarks
112 
Longitude,Longitude
113 
LowestBiostratigraphicZone,LowestBiostratigraphicZone
114 
MaximumDepth,MaximumDepth
115 
MaximumDepthInMeters,MaximumDepthInMeters
116 
MaximumDistanceAboveSurfaceInMeters,MaximumDistanceAboveSurfaceInMeters
117 
MaximumElevation,MaximumElevation
118 
MaximumElevationInMeters,MaximumElevationInMeters
119 
MeasurementAccuracy,MeasurementAccuracy
120 
MeasurementDeterminedBy,MeasurementDeterminedBy
121 
MeasurementDeterminedDate,MeasurementDeterminedDate
122 
MeasurementID,MeasurementID
123 
MeasurementMethod,MeasurementMethod
124 
MeasurementRemarks,MeasurementRemarks
125 
MeasurementType,MeasurementType
126 
MeasurementUnit,MeasurementUnit
127 
MeasurementValue,MeasurementValue
128 
Member,Member
129 
MinimumDepth,MinimumDepth
130 
MinimumDepthInMeters,MinimumDepthInMeters
131 
MinimumDistanceAboveSurfaceInMeters,MinimumDistanceAboveSurfaceInMeters
132 
MinimumElevation,MinimumElevation/_nullIf:[null=.]/value,
133 
MinimumElevationInMeters,MinimumElevationInMeters
134 
Month,Month
135 
MonthCollected,MonthCollected
136 
MonthIdentified,MonthIdentified
137 
Municipality,Municipality
138 
NameAccordingTo,NameAccordingTo
139 
NameAccordingToID,NameAccordingToID
140 
NamePublishedIn,NamePublishedIn
141 
NamePublishedInID,NamePublishedInID
142 
NamePublishedInYear,NamePublishedInYear
143 
NomenclaturalCode,NomenclaturalCode
144 
NomenclaturalStatus,NomenclaturalStatus
145 
Notes,Notes/_merge/1,
146 
PlantFungusDescription,"Notes/_merge/2/_label[label=""plant fungus""]/value",
147 
OccurrenceID,OccurrenceID
148 
OccurrenceRemarks,OccurrenceRemarks
149 
OccurrenceStatus,OccurrenceStatus
150 
Order,Order
151 
OriginalNameUsage,OriginalNameUsage
152 
OriginalNameUsageID,OriginalNameUsageID
153 
OtherCatalogNumbers,OtherCatalogNumbers
154 
OwnerInstitutionCode,OwnerInstitutionCode
155 
ParentNameUsage,ParentNameUsage
156 
ParentNameUsageID,ParentNameUsageID
157 
Phylum,Phylum
158 
PointRadiusSpatialFit,PointRadiusSpatialFit
159 
PreparationType,PreparationType
160 
Preparations,Preparations
161 
PreviousCatalogNumber,PreviousCatalogNumber
162 
PreviousIdentifications,PreviousIdentifications
163 
RecordNumber,RecordNumber
164 
RecordedBy,RecordedBy
165 
RelatedCatalogItem,RelatedCatalogItem
166 
RelatedResourceID,RelatedResourceID
167 
RelationshipAccordingTo,RelationshipAccordingTo
168 
RelationshipEstablishedDate,RelationshipEstablishedDate
169 
RelationshipOfResource,RelationshipOfResource
170 
RelationshipRemarks,RelationshipRemarks
171 
RelationshipType,RelationshipType
172 
Remarks,Remarks
173 
ReproductiveCondition,ReproductiveCondition
174 
ResourceID,ResourceID
175 
ResourceRelationshipID,ResourceRelationshipID
176 
SamplingEffort,SamplingEffort
177 
SamplingProtocol,SamplingProtocol
178 
ScientificName,ScientificName
179 
ScientificNameAuthor,ScientificNameAuthor
180 
ScientificNameAuthorship,ScientificNameAuthorship
181 
ScientificNameID,ScientificNameID
182 
Sex,Sex
183 
Species,Species
184 
SpecificEpithet,SpecificEpithet
185 
StartDayOfYear,StartDayOfYear
186 
StateProvince,StateProvince
187 
Subgenus,Subgenus
188 
Subspecies,Subspecies
189 
TaxonConceptID,TaxonConceptID
190 
TaxonID,TaxonID
191 
TaxonRank,TaxonRank
192 
TaxonRemarks,TaxonRemarks
193 
TaxonomicStatus,TaxonomicStatus
194 
TimeOfDay,TimeOfDay
195 
TypeStatus,TypeStatus
196 
VerbatimCoordinateSystem,VerbatimCoordinateSystem
197 
VerbatimCoordinates,VerbatimCoordinates
198 
VerbatimDepth,VerbatimDepth
199 
VerbatimElevation,VerbatimElevation
200 
VerbatimEventDate,VerbatimEventDate
201 
VerbatimLatitude,VerbatimLatitude
202 
VerbatimLocality,VerbatimLocality
203 
VerbatimLongitude,VerbatimLongitude
204 
VerbatimSRS,VerbatimSRS
205 
VerbatimTaxonRank,VerbatimTaxonRank
206 
VernacularName,VernacularName
207 
WaterBody,WaterBody
208 
Year,Year
209 
YearCollected,YearCollected
210 
YearIdentified,YearIdentified
211 
acceptedNameUsage,acceptedNameUsage
212 
acceptedNameUsageID,acceptedNameUsageID
213 
associatedMedia,associatedMedia
214 
associatedOccurrences,associatedOccurrences
215 
associatedReferences,associatedReferences
216 
associatedSequences,associatedSequences
217 
associatedTaxa,associatedTaxa
218 
basisOfRecord,basisOfRecord
219 
bed,bed
220 
behavior,behavior
221 
catalogNumber,catalogNumber
222 
class,class
223 
collectionCode,collectionCode
224 
collectionID,collectionID
225 
continent,continent
226 
coordinatePrecision,coordinatePrecision
227 
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters
228 
country,country
229 
countryCode,countryCode
230 
county,county
231 
dataGeneralizations,dataGeneralizations
232 
datasetID,datasetID
233 
datasetName,datasetName
234 
dateIdentified,dateIdentified
235 
dateIdentified/_alt,dateIdentified/_alt
236 
day,day
237 
dcterms:accessRights,dcterms:accessRights
238 
dcterms:bibliographicCitation,dcterms:bibliographicCitation
239 
dcterms:language,dcterms:language
240 
dcterms:modified,dcterms:modified
241 
dcterms:references,dcterms:references
242 
dcterms:rights,dcterms:rights
243 
dcterms:rightsHolder,dcterms:rightsHolder
244 
dcterms:type,dcterms:type
245 
decimalLatitude,decimalLatitude
246 
decimalLongitude,decimalLongitude
247 
disposition,disposition
248 
dynamicProperties,dynamicProperties
249 
earliestAgeOrLowestStage,earliestAgeOrLowestStage
250 
earliestEonOrLowestEonothem,earliestEonOrLowestEonothem
251 
earliestEpochOrLowestSeries,earliestEpochOrLowestSeries
252 
earliestEraOrLowestErathem,earliestEraOrLowestErathem
253 
earliestPeriodOrLowestSystem,earliestPeriodOrLowestSystem
254 
endDayOfYear,endDayOfYear
255 
establishmentMeans,establishmentMeans
256 
eventDate,eventDate
257 
eventDate/_alt,eventDate/_alt
258 
eventID,eventID
259 
eventRemarks,eventRemarks
260 
eventTime,eventTime
261 
family,family
262 
fieldNotes,fieldNotes
263 
fieldNumber,fieldNumber
264 
footprintSRS,footprintSRS
265 
footprintSpatialFit,footprintSpatialFit
266 
footprintWKT,footprintWKT
267 
formation,formation
268 
genus,genus
269 
geodeticDatum,geodeticDatum
270 
geologicalContextID,geologicalContextID
271 
georeferenceProtocol,georeferenceProtocol
272 
georeferenceRemarks,georeferenceRemarks
273 
georeferenceSources,georeferenceSources
274 
georeferenceVerificationStatus,georeferenceVerificationStatus
275 
georeferencedBy,georeferencedBy
276 
georeferencedDate,georeferencedDate
277 
group,group
278 
habitat,habitat
279 
higherClassification,higherClassification
280 
higherGeography,higherGeography
281 
higherGeographyID,higherGeographyID
282 
highestBiostratigraphicZone,highestBiostratigraphicZone
283 
identificationID,identificationID
284 
identificationQualifier,identificationQualifier
285 
identificationReferences,identificationReferences
286 
identificationRemarks,identificationRemarks
287 
identificationVerificationStatus,identificationVerificationStatus
288 
identifiedBy,identifiedBy
289 
individualCount,individualCount
290 
individualID,individualID
291 
informationWithheld,informationWithheld
292 
infraspecificEpithet,infraspecificEpithet
293 
institutionCode,institutionCode
294 
institutionID,institutionID
295 
island,island
296 
islandGroup,islandGroup
297 
kingdom,kingdom
298 
latestAgeOrHighestStage,latestAgeOrHighestStage
299 
latestEonOrHighestEonothem,latestEonOrHighestEonothem
300 
latestEpochOrHighestSeries,latestEpochOrHighestSeries
301 
latestEraOrHighestErathem,latestEraOrHighestErathem
302 
latestPeriodOrHighestSystem,latestPeriodOrHighestSystem
303 
lifeStage,lifeStage
304 
lithostratigraphicTerms,lithostratigraphicTerms
305 
locality,locality
306 
locationAccordingTo,locationAccordingTo
307 
locationID,locationID
308 
locationRemarks,locationRemarks
309 
lowestBiostratigraphicZone,lowestBiostratigraphicZone
310 
maximumDepthInMeters,maximumDepthInMeters
311 
maximumDistanceAboveSurfaceInMeters,maximumDistanceAboveSurfaceInMeters
312 
maximumElevationInMeters,maximumElevationInMeters
313 
measurementAccuracy,measurementAccuracy
314 
measurementDeterminedBy,measurementDeterminedBy
315 
measurementDeterminedDate,measurementDeterminedDate
316 
measurementID,measurementID
317 
measurementMethod,measurementMethod
318 
measurementRemarks,measurementRemarks
319 
measurementType,measurementType
320 
measurementUnit,measurementUnit
321 
measurementValue,measurementValue
322 
member,member
323 
minimumDepthInMeters,minimumDepthInMeters
324 
minimumDistanceAboveSurfaceInMeters,minimumDistanceAboveSurfaceInMeters
325 
minimumElevationInMeters,minimumElevationInMeters
326 
month,month
327 
municipality,municipality
328 
nameAccordingTo,nameAccordingTo
329 
nameAccordingToID,nameAccordingToID
330 
namePublishedIn,namePublishedIn
331 
namePublishedInID,namePublishedInID
332 
namePublishedInYear,namePublishedInYear
333 
nomenclaturalCode,nomenclaturalCode
334 
nomenclaturalStatus,nomenclaturalStatus
335 
UniqueNYInternalRecordNumber,occurrenceID,
336 
occurrenceID,occurrenceID
337 
occurrenceRemarks,occurrenceRemarks
338 
occurrenceStatus,occurrenceStatus
339 
order,order
340 
originalNameUsage,originalNameUsage
341 
originalNameUsageID,originalNameUsageID
342 
otherCatalogNumbers,otherCatalogNumbers
343 
ownerInstitutionCode,ownerInstitutionCode
344 
parentNameUsage,parentNameUsage
345 
parentNameUsageID,parentNameUsageID
346 
phylum,phylum
347 
pointRadiusSpatialFit,pointRadiusSpatialFit
348 
preparations,preparations
349 
previousIdentifications,previousIdentifications
350 
recordNumber,recordNumber
351 
recordedBy,recordedBy
352 
relatedResourceID,relatedResourceID
353 
relationshipAccordingTo,relationshipAccordingTo
354 
relationshipEstablishedDate,relationshipEstablishedDate
355 
relationshipOfResource,relationshipOfResource
356 
relationshipRemarks,relationshipRemarks
357 
reproductiveCondition,reproductiveCondition
358 
resourceID,resourceID
359 
resourceRelationshipID,resourceRelationshipID
360 
samplingEffort,samplingEffort
361 
samplingProtocol,samplingProtocol
362 
scientificName,scientificName
363 
scientificNameAuthorship,scientificNameAuthorship
364 
scientificNameID,scientificNameID
365 
sex,sex
366 
specificEpithet,specificEpithet
367 
startDayOfYear,startDayOfYear
368 
stateProvince,stateProvince
369 
subgenus,subgenus
370 
taxonConceptID,taxonConceptID
371 
taxonID,taxonID
372 
taxonRank,taxonRank
373 
taxonRemarks,taxonRemarks
374 
taxonomicStatus,taxonomicStatus
375 
typeStatus,typeStatus
376 
verbatimCoordinateSystem,verbatimCoordinateSystem
377 
verbatimCoordinates,verbatimCoordinates
378 
verbatimDepth,verbatimDepth
379 
verbatimElevation,verbatimElevation
380 
verbatimEventDate,verbatimEventDate
381 
verbatimLatitude,verbatimLatitude
382 
verbatimLocality,verbatimLocality
383 
verbatimLongitude,verbatimLongitude
384 
verbatimSRS,verbatimSRS
385 
verbatimTaxonRank,verbatimTaxonRank
386 
vernacularName,vernacularName
387 
waterBody,waterBody
388 
year,year
389 
key,,
inputs/NYBG/maps/VegBIEN.specimens.csv
1 
NYBG[DwC],VegBIEN:/specimenreplicate,Comments,Order
2 
CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3 
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
4 
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
5 
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
6 
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
7 
FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
8 
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
9 
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
10 
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
11 
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
12 
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
13 
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
14 
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
15 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
16 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1/_merge/1,,68
17 
Substrate,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1/_merge/2/_label[label=""substrate""]/value",,68
18 
Vegetation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1/_merge/3/_label[label=""vegetation""]/value",,68
19 
VerbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
20 
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
21 
Habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
22 
habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
23 
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
24 
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
25 
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}/_nullIf:[null=.]/value",,71
26 
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
27 
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
28 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
29 
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
30 
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
31 
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
32 
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
33 
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
34 
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
35 
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
36 
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
37 
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
38 
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
39 
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
40 
MaximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
41 
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
42 
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
43 
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
44 
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
45 
EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44
46 
eventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
47 
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
48 
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
49 
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
50 
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
51 
CollectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
52 
DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120
53 
dateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
54 
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
55 
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
56 
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
57 
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
58 
IdentifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120
59 
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
60 
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
61 
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
62 
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
63 
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
64 
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
65 
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
66 
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
67 
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
68 
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
69 
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
70 
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
71 
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
72 
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
73 
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
74 
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
75 
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
76 
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
77 
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
78 
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
79 
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
80 
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
81 
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
82 
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
83 
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
84 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
85 
RecordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
86 
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
87 
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
88 
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
89 
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
90 
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
91 
FieldNotes,/description/_merge/1,,
92 
fieldNotes,/description/_merge/1,,
93 
Notes,/description/_merge/1/_merge/1,,
94 
PlantFungusDescription,"/description/_merge/1/_merge/2/_label[label=""plant fungus""]/value",,
95 
Remarks,/description/_merge/2,,158
96 
TaxonRemarks,/description/_merge/2,,158
97 
taxonRemarks,/description/_merge/2,,158
98 
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
99 
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
100 
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
101 
OccurrenceID,":[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
102 
UniqueNYInternalRecordNumber,":[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
103 
occurrenceID,":[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
104 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
105 
RecordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
106 
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
107 
CollectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
108 
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
109 
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
110 
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
111 
InstitutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
112 
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
113 
AcceptedNameUsage,,,135
114 
AcceptedNameUsageID,,,128
115 
AssociatedMedia,,,36
116 
AssociatedOccurrences,,,38
117 
AssociatedReferences,,,37
118 
AssociatedSequences,,,39
119 
AssociatedTaxa,,,40
120 
BasisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
121 
Bed,,,117
122 
Behavior,,,29
123 
Continent,,Brad: OMIT,59
124 
ContinentOcean,,Brad: OMIT,59
125 
CountryCode,,,64
126 
DataGeneralizations,,,17
127 
DatasetID,,,10
128 
DatasetName,,,13
129 
DateLastModified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source.",1
130 
Day,,Brad: OMIT,50
131 
Dcterms:accessRights,,,5
132 
Dcterms:bibliographicCitation,,,6
133 
Dcterms:language,,,2
134 
Dcterms:modified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source.",1
135 
Dcterms:references,,,7
136 
Dcterms:rights,,,3
137 
Dcterms:rightsHolder,,,4
138 
Dcterms:type,,,0
139 
Disposition,,,33
140 
DynamicProperties,,,18
141 
EarliestAgeOrLowestStage,,,109
142 
EarliestEonOrLowestEonothem,,,101
143 
EarliestEpochOrLowestSeries,,,107
144 
EarliestEraOrLowestErathem,,,103
145 
EarliestPeriodOrLowestSystem,,,105
146 
EndDayOfYear,,,47
147 
EstablishmentMeans,,,30
148 
EventID,,,41
149 
EventRemarks,,,55
150 
EventTime,,Brad: OMIT,45
151 
FootprintSRS,,,92
152 
FootprintSpatialFit,,,93
153 
Formation,,,115
154 
GeodeticDatum,,,87
155 
GeologicalContextID,,,100
156 
GeoreferenceProtocol,,,96
157 
GeoreferenceRemarks,,,99
158 
GeoreferenceSources,,,97
159 
GeoreferenceVerificationStatus,,,98
160 
GeoreferencedBy,,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
161 
GeoreferencedDate,,,95
162 
Group,,,114
163 
HigherClassification,,,141
164 
HigherGeography,,,58
165 
HigherGeographyID,,,57
166 
HighestBiostratigraphicZone,,,112
167 
IdentificationID,,,118
168 
IdentificationQualifier,,,124
169 
IdentificationReferences,,,121
170 
IdentificationRemarks,,,123
171 
IdentificationVerificationStatus,,,122
172 
IndividualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
173 
IndividualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
174 
InformationWithheld,,,16
175 
InstitutionCode,,,
176 
Island,,,62
177 
IslandGroup,,,61
178 
JulianDay,,Brad: OMIT,50
179 
LatestAgeOrHighestStage,,,110
180 
LatestEonOrHighestEonothem,,,102
181 
LatestEpochOrHighestSeries,,,108
182 
LatestEraOrHighestErathem,,,104
183 
LatestPeriodOrHighestSystem,,,106
184 
LifeStage,,,27
185 
LithostratigraphicTerms,,,113
186 
LocationAccordingTo,,,78
187 
LocationID,,,56
188 
LocationRemarks,,,79
189 
LowestBiostratigraphicZone,,,111
190 
MaximumDistanceAboveSurfaceInMeters,,,77
191 
MeasurementAccuracy,,,169
192 
MeasurementDeterminedBy,,,172
193 
MeasurementDeterminedDate,,,171
194 
MeasurementID,,,166
195 
MeasurementMethod,,,173
196 
MeasurementRemarks,,,174
197 
MeasurementType,,,167
198 
MeasurementUnit,,,170
199 
MeasurementValue,,,168
200 
Member,,,116
201 
MinimumDistanceAboveSurfaceInMeters,,,76
202 
Month,,,49
203 
Municipality,,,67
204 
NameAccordingTo,,,138
205 
NameAccordingToID,,,131
206 
NamePublishedIn,,,139
207 
NamePublishedInID,,,132
208 
NamePublishedInYear,,,140
209 
NomenclaturalCode,,,155
210 
NomenclaturalStatus,,,157
211 
OccurrenceRemarks,,,21
212 
OccurrenceStatus,,,31
213 
OriginalNameUsage,,,137
214 
OriginalNameUsageID,,,130
215 
OtherCatalogNumbers,,,34
216 
OwnerInstitutionCode,,,14
217 
ParentNameUsage,,,136
218 
ParentNameUsageID,,,129
219 
PointRadiusSpatialFit,,,90
220 
PreparationType,,Brad: OMIT,32
221 
Preparations,,Brad: OMIT,32
222 
PreviousCatalogNumber,,?; Brad: OMIT,35
223 
PreviousIdentifications,,Brad: OMIT,35
224 
RelatedCatalogItem,,Brad: OMIT,161
225 
RelatedResourceID,,Brad: OMIT,161
226 
RelationshipAccordingTo,,,163
227 
RelationshipEstablishedDate,,,164
228 
RelationshipOfResource,,Brad: OMIT,162
229 
RelationshipRemarks,,,165
230 
RelationshipType,,Brad: OMIT,162
231 
ReproductiveCondition,,,28
232 
ResourceID,,,160
233 
ResourceRelationshipID,,,159
234 
SamplingEffort,,,43
235 
SamplingProtocol,,,42
236 
ScientificNameID,,,127
237 
StartDayOfYear,,,46
238 
Subgenus,,,148
239 
TaxonConceptID,,,133
240 
TaxonID,,,126
241 
TaxonRank,,,151
242 
TaxonomicStatus,,,156
243 
TimeOfDay,,Brad: OMIT,45
244 
TypeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125
245 
VerbatimCoordinateSystem,,,83
246 
VerbatimCoordinates,,,80
247 
VerbatimDepth,,,73
248 
VerbatimElevation,,,70
249 
VerbatimEventDate,,,51
250 
VerbatimSRS,,,84
251 
VerbatimTaxonRank,,,152
252 
VernacularName,,,154
253 
WaterBody,,,60
254 
Year,,,48
255 
acceptedNameUsage,,,135
256 
acceptedNameUsageID,,,128
257 
associatedMedia,,,36
258 
associatedOccurrences,,,38
259 
associatedReferences,,,37
260 
associatedSequences,,,39
261 
associatedTaxa,,,40
262 
basisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
263 
bed,,,117
264 
behavior,,,29
265 
continent,,Brad: OMIT,59
266 
countryCode,,,64
267 
dataGeneralizations,,,17
268 
datasetID,,,10
269 
datasetName,,,13
270 
day,,Brad: OMIT,50
271 
dcterms:accessRights,,,5
272 
dcterms:bibliographicCitation,,,6
273 
dcterms:language,,,2
274 
dcterms:modified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source.",1
275 
dcterms:references,,,7
276 
dcterms:rights,,,3
277 
dcterms:rightsHolder,,,4
278 
dcterms:type,,,0
279 
disposition,,,33
280 
dynamicProperties,,,18
281 
earliestAgeOrLowestStage,,,109
282 
earliestEonOrLowestEonothem,,,101
283 
earliestEpochOrLowestSeries,,,107
284 
earliestEraOrLowestErathem,,,103
285 
earliestPeriodOrLowestSystem,,,105
286 
endDayOfYear,,,47
287 
establishmentMeans,,,30
288 
eventID,,,41
289 
eventRemarks,,,55
290 
eventTime,,Brad: OMIT,45
291 
footprintSRS,,,92
292 
footprintSpatialFit,,,93
293 
formation,,,115
294 
geodeticDatum,,,87
295 
geologicalContextID,,,100
296 
georeferenceProtocol,,,96
297 
georeferenceRemarks,,,99
298 
georeferenceSources,,,97
299 
georeferenceVerificationStatus,,,98
300 
georeferencedBy,,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
301 
georeferencedDate,,,95
302 
group,,,114
303 
higherClassification,,,141
304 
higherGeography,,,58
305 
higherGeographyID,,,57
306 
highestBiostratigraphicZone,,,112
307 
identificationID,,,118
308 
identificationQualifier,,,124
309 
identificationReferences,,,121
310 
identificationRemarks,,,123
311 
identificationVerificationStatus,,,122
312 
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
313 
individualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
314 
informationWithheld,,,16
315 
institutionCode,,,
316 
island,,,62
317 
islandGroup,,,61
318 
key,,
319 
latestAgeOrHighestStage,,,110
320 
latestEonOrHighestEonothem,,,102
321 
latestEpochOrHighestSeries,,,108
322 
latestEraOrHighestErathem,,,104
323 
latestPeriodOrHighestSystem,,,106
324 
lifeStage,,,27
325 
lithostratigraphicTerms,,,113
326 
locationAccordingTo,,,78
327 
locationID,,,56
328 
locationRemarks,,,79
329 
lowestBiostratigraphicZone,,,111
330 
maximumDistanceAboveSurfaceInMeters,,,77
331 
measurementAccuracy,,,169
332 
measurementDeterminedBy,,,172
333 
measurementDeterminedDate,,,171
334 
measurementID,,,166
335 
measurementMethod,,,173
336 
measurementRemarks,,,174
337 
measurementType,,,167
338 
measurementUnit,,,170
339 
measurementValue,,,168
340 
member,,,116
341 
minimumDistanceAboveSurfaceInMeters,,,76
342 
month,,,49
343 
municipality,,,67
344 
nameAccordingTo,,,138
345 
nameAccordingToID,,,131
346 
namePublishedIn,,,139
347 
namePublishedInID,,,132
348 
namePublishedInYear,,,140
349 
nomenclaturalCode,,,155
350 
nomenclaturalStatus,,,157
351 
occurrenceRemarks,,,21
352 
occurrenceStatus,,,31
353 
originalNameUsage,,,137
354 
originalNameUsageID,,,130
355 
otherCatalogNumbers,,,34
356 
ownerInstitutionCode,,,14
357 
parentNameUsage,,,136
358 
parentNameUsageID,,,129
359 
pointRadiusSpatialFit,,,90
360 
preparations,,Brad: OMIT,32
361 
previousIdentifications,,Brad: OMIT,35
362 
relatedResourceID,,Brad: OMIT,161
363 
relationshipAccordingTo,,,163
364 
relationshipEstablishedDate,,,164
365 
relationshipOfResource,,Brad: OMIT,162
366 
relationshipRemarks,,,165
367 
reproductiveCondition,,,28
368 
resourceID,,,160
369 
resourceRelationshipID,,,159
370 
samplingEffort,,,43
371 
samplingProtocol,,,42
372 
scientificNameID,,,127
373 
startDayOfYear,,,46
374 
subgenus,,,148
375 
taxonConceptID,,,133
376 
taxonID,,,126
377 
taxonRank,,,151
378 
taxonomicStatus,,,156
379 
typeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125
380 
verbatimCoordinateSystem,,,83
381 
verbatimCoordinates,,,80
382 
verbatimDepth,,,73
383 
verbatimElevation,,,70
384 
verbatimEventDate,,,51
385 
verbatimSRS,,,84
386 
verbatimTaxonRank,,,152
387 
vernacularName,,,154
388 
waterBody,,,60
389 
year,,,48
inputs/NYBG/verify/specimens.ref.sql
1 
SELECT '# specimen replicates' AS ___;
2 
SELECT count(*) AS count FROM nybg_raw;
3 

  		




  4
  
  
    
SELECT '# families' AS ___;


  		




  5
  
  
    
SELECT count(DISTINCT Family) AS count FROM nybg_raw;


  		




  6
  
  
    

  		




  7
  
  
    
SELECT '# genera' AS ___;


  		




  8
  
  
    
SELECT count(DISTINCT Genus) AS count FROM nybg_raw;


  		




  9
  
  
    

  		




  10
  
  
    
SELECT '# species' AS ___;


  		




  11
  
  
    
SELECT count(DISTINCT Genus, Species) AS count FROM nybg_raw;


  		




  12
  
  
    

  		




  13
  
  
    
SELECT '# binomials' AS ___;


  		




  14
  
  
    
SELECT count(DISTINCT ScientificName) AS count FROM nybg_raw;


  		




  15
  
  
    

  		




  16
  
  
    
SELECT 'collection codes' AS ___;


  		




  17
  
  
    
SELECT DISTINCT CollectionCode AS collectioncode_dwc FROM nybg_raw;


  		




  18
  
  
    

  		




  19
  
  
    
SELECT '# catalog numbers' AS ___;


  		




  20
  
  
    
SELECT count(DISTINCT CatalogNumber) AS count FROM nybg_raw;


  		




  21
  
  
    

  		




  22
  
  
    
SELECT 'duplicate catalog numbers' AS ___;


  		




  23
  
  
    
SELECT CatalogNumber AS catalognumber_dwc, count(*) AS count


  		




  24
  
  
    
FROM nybg_raw


  		




  25
  
  
    
GROUP BY CatalogNumber


  		




  26
  
  
    
HAVING count > 1


  		




  27
  
  
    
;


  		




  28
  
  
    

  		




  29
  
  
    
SELECT '# counties' AS ___;


  		




  30
  
  
    
SELECT count(DISTINCT Country, StateProvince, County) AS count FROM nybg_raw;


  		




  31
  
  
    

  		




  32
  
  
    
/*


  		




  33
  
  
    
SELECT COUNT(*) as totalRecords, COUNT(DISTINCT CatalogNumber) as uniqueCatalogNumbers


  		




  34
  
  
    
FROM nybg_raw;


  		




  35
  
  
    

  		




  36
  
  
    
SELECT CatalogNumber, COUNT(*) AS records


  		




  37
  
  
    
FROM nybg_raw


  		




  38
  
  
    
GROUP BY CatalogNumber


  		




  39
  
  
    
HAVING records>1;


  		




  40
  
  
    

  		




  41
  
  
    
SELECT b.CatalogNumber, DateLastModified, ScientificName, Collector, FieldNumber, 


  		




  42
  
  
    
CollectedDate


  		




  43
  
  
    
FROM nybg_raw AS a JOIN (


  		




  44
  
  
    
SELECT CatalogNumber, COUNT(*) AS records


  		




  45
  
  
    
FROM nybg_raw


  		




  46
  
  
    
WHERE CatalogNumber IS NOT NULL


  		




  47
  
  
    
GROUP BY CatalogNumber


  		




  48
  
  
    
HAVING records>1


  		




  49
  
  
    
) AS b


  		




  50
  
  
    
ON a.CatalogNumber=b.CatalogNumber


  		




  51
  
  
    
ORDER BY b.CatalogNumber ASC, DateLastModified DESC;


  		




  52
  
  
    

  		




  53
  
  
    
SELECT DateLastModified, ScientificName, Collector, FieldNumber, 


  		




  54
  
  
    
CollectedDate


  		




  55
  
  
    
FROM nybg_raw 


  		




  56
  
  
    
WHERE CatalogNumber IS NULL


  		




  57
  
  
    
ORDER BY CatalogNumber ASC, DateLastModified DESC


  		




  58
  
  
    
LIMIT 12;


  		




  59
  
  
    

  		




  60
  
  
    
SELECT 


  		




  61
  
  
    
(


  		




  62
  
  
    
SELECT COUNT(*)


  		




  63
  
  
    
FROM nybg_raw


  		




  64
  
  
    
WHERE Latitude IS NOT NULL


  		




  65
  
  
    
) AS allLats,


  		




  66
  
  
    
(


  		




  67
  
  
    
SELECT COUNT(*)


  		




  68
  
  
    
FROM nybg_raw


  		




  69
  
  
    
WHERE Latitude REGEXP '^(-|\\+){0,1}([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$'


  		




  70
  
  
    
) AS decimalLats,


  		




  71
  
  
    
(


  		




  72
  
  
    
SELECT COUNT(*)


  		




  73
  
  
    
FROM nybg_raw


  		




  74
  
  
    
WHERE Longitude IS NOT NULL


  		




  75
  
  
    
) AS allLongs,


  		




  76
  
  
    
(


  		




  77
  
  
    
SELECT COUNT(*)


  		




  78
  
  
    
FROM nybg_raw


  		




  79
  
  
    
WHERE Longitude REGEXP '^(-|\\+){0,1}([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$'


  		




  80
  
  
    
) AS decimalLongs;


  		




  81
  
  
    

  		




  82
  
  
    
SELECT Latitude, Longitude 


  		




  83
  
  
    
FROM nybg_raw


  		




  84
  
  
    
WHERE  Latitude IS NOT NULL AND  Longitude IS NOT NULL


  		




  85
  
  
    
LIMIT 10;


  		




  86
  
  
    

  		




  87
  
  
    
SELECT 


  		




  88
  
  
    
(


  		




  89
  
  
    
SELECT COUNT(*)


  		




  90
  
  
    
FROM nybg_raw


  		




  91
  
  
    
WHERE Latitude>90 OR Latitude<-90


  		




  92
  
  
    
) AS badLats,


  		




  93
  
  
    
(


  		




  94
  
  
    
SELECT COUNT(*)


  		




  95
  
  
    
FROM nybg_raw


  		




  96
  
  
    
WHERE Longitude>180 OR Longitude<-180


  		




  97
  
  
    
) AS badLongs;


  		




  98
  
  
    

  		




  99
  
  
    
SELECT DayCollected, MonthCollected, YearCollected 


  		




  100
  
  
    
FROM nybg_raw


  		




  101
  
  
    
WHERE DayCollected IS NOT NULL OR MonthCollected IS NOT NULL OR YearCollected IS NOT NULL


  		




  102
  
  
    
LIMIT 10;


  		




  103
  
  
    

  		




  104
  
  
    
SELECT


  		




  105
  
  
    
(


  		




  106
  
  
    
SELECT COUNT(*)


  		




  107
  
  
    
FROM nybg_raw


  		




  108
  
  
    
WHERE NOT(DayCollected REGEXP '^-?[0-9]+$')


  		




  109
  
  
    
OR NOT(MonthCollected REGEXP '^-?[0-9]+$')


  		




  110
  
  
    
OR NOT(YearCollected REGEXP '^-?[0-9]+$')


  		




  111
  
  
    
) AS badDateCollected,


  		




  112
  
  
    
(


  		




  113
  
  
    
SELECT COUNT(*)


  		




  114
  
  
    
FROM nybg_raw


  		




  115
  
  
    
WHERE NOT(DayIdentified REGEXP '^-?[0-9]+$')


  		




  116
  
  
    
OR NOT(MonthIdentified REGEXP '^-?[0-9]+$')


  		




  117
  
  
    
OR NOT(YearIdentified REGEXP '^-?[0-9]+$')


  		




  118
  
  
    
) AS badDateIdentified;


  		




  119
  
  
    

  		




  120
  
  
    
SELECT Locality


  		




  121
  
  
    
FROM nybg_raw


  		




  122
  
  
    
WHERE Locality IS NOT NULL


  		




  123
  
  
    
LIMIT 10;


  		




  124
  
  
    

  		




  125
  
  
    
SELECT PlantFungusDescription


  		




  126
  
  
    
FROM nybg_raw


  		




  127
  
  
    
WHERE PlantFungusDescription IS NOT NULL


  		




  128
  
  
    
LIMIT 10;


  		




  129
  
  
    

  		




  130
  
  
    
SELECT Habitat, Vegetation


  		




  131
  
  
    
FROM nybg_raw


  		




  132
  
  
    
WHERE Habitat IS NOT NULL OR Vegetation IS NOT NULL


  		




  133
  
  
    
LIMIT 10;


  		




  134
  
  
    
*/


  		












  

    
      inputs/NYBG/verify/specimens.ref
    
  





  1
  
  
    
___


  		




  2
  
  
    
# specimen replicates


  		




  3
  
  
    
count


  		




  4
  
  
    
328040


  		




  5
  
  
    
___


  		




  6
  
  
    
# families


  		




  7
  
  
    
count


  		




  8
  
  
    
741


  		




  9
  
  
    
___


  		




  10
  
  
    
# genera


  		




  11
  
  
    
count


  		




  12
  
  
    
6381


  		




  13
  
  
    
___


  		




  14
  
  
    
# species


  		




  15
  
  
    
count


  		




  16
  
  
    
40145


  		




  17
  
  
    
___


  		




  18
  
  
    
# binomials


  		




  19
  
  
    
count


  		




  20
  
  
    
46282


  		




  21
  
  
    
___


  		




  22
  
  
    
collection codes


  		




  23
  
  
    
collectioncode_dwc


  		




  24
  
  
    
Herbarium


  		




  25
  
  
    
___


  		




  26
  
  
    
# catalog numbers


  		




  27
  
  
    
count


  		




  28
  
  
    
327637


  		




  29
  
  
    
___


  		




  30
  
  
    
duplicate catalog numbers


  		




  31
  
  
    
catalognumber_dwc	count


  		








... This diff was truncated because it exceeds the maximum size that can be displayed.



Also available in:  Unified diff