MonthIdentified,monthIdentified,,

DayIdentified,dayIdentified,,

TypeStatus,TypeStatus,,

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

FieldNumber,recordNumber,,Usage inconsistent with DwC definition

Collector,recordedBy,,

Country,country,,

StateProvince,stateProvince,,

County,county,,

Longitude,verbatimLongitude,,

Latitude,verbatimLatitude,,

CoordinatePrecision,coordinatePrecision,,

PreviousCatalogNumber,otherCatalogNumbers,,

RelationshipType,relationshipOfResource,,

RelatedCatalogItem,relatedResourceID,,

Habitat,habitat,,

UniqueNYInternalRecordNumber,occurrenceID,,

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

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

IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,

FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,Usage inconsistent with DwC definition

Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"

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

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

MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

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

BasisOfRecord,,** No join mapping for BasisOfRecord ** 

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

DateLastModified,,** No join mapping for dcterms:modified ** 

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

                            </collectiondate>

                            <count>$IndividualCount</count>

                            <notes>

                                    <1>$Notes</1>

                                    <2>

                                        <_label>

                                            <value>$PlantFungusDescription</value>

                                        </_label>

                                    </2>

                            </notes>

                            <plantobservation>

                                <collectionnumber>$FieldNumber</collectionnumber>

                <locationnarrative>

                    <_merge>

                        <1>

                                <1>$Locality</1>

                                <2>

                                    <_label>

                                        <value>$Vegetation</value>

                                    </_label>

                                </3>

                        </1>

                        <3>

                            <_label>

infraname,infraspecificEpithet,,

SciName,scientificName,,

authors,scientificNameAuthorship,,

collectno,recordNumber,,

collmonth,monthCollected,,

collday,dayCollected,,

country,country,,

state,stateProvince,,

county,county,,

leaves,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

flower,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

fruit,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

root,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

locality,locality,,

habitat,habitat,,

sheetno,associatedMedia,,?

cultivated,cultivated,,Ignore other values

filler,filler,,"Where used, same as family"

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

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

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

collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,

herbarium,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,

accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",

genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",

family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",

locality,/location/locationnarrative/_merge/1,

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

filler,,"** No join mapping for filler ** Where used, same as family"

                                </_date>

                            </collectiondate>

                            <notes>

                                    <1>$comment1</1>

                                    <2>$comment2</2>

                                    <3>$comment3</3>

                                            <value>$inorout</value>

                                        </_label>

                                    </7>

                            </notes>

                            <plantobservation>

                                <collectionnumber>$collectno</collectionnumber>

                            </plantconcept_id>

                        </taxondetermination>

                        <verbatimcollectorname>

                                <1>$collector</1>

                                <2>$collector1</2>

                                <3>$collector2</3>

                                <4>$collector3</4>

                        </verbatimcollectorname>

                    </taxonoccurrence>

                </locationevent>

U,VegCore,Filter,Comments

ID,occurrenceID,,

Barcode,catalogNumber,,

Prefix,Prefix,,Not used

Number,recordNumber,,

Suffix,Suffix,,Not used

Colldd,dayCollected,,

Collmm,monthCollected,,

Collyy,yearCollected,,

cf,identificationQualifier,,

Detby,identifiedBy,,

Detyy,yearIdentified,,

Majorarea,Majorarea,,

Country,country,,

Coorsyst,Coorsyst,,

Lat,decimalLatitude,,

NS,NS,,

Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",

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

cf,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,

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

Ecology,"/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?"

Alt,,** No join mapping for Alt ** What is this?

Alt2,,** No join mapping for Alt2 ** What is this?

                            <taxonfit>$cf</taxonfit>

                        </taxondetermination>

                        <verbatimcollectorname>

                                <1>$Collector</1>

                                <2>$Addcoll</2>

                        </verbatimcollectorname>

                    </taxonoccurrence>

                </locationevent>

                <locationnarrative>

                    <_merge>

                        <2>

                                <1>

                                    <_label>

                                        <label>gazetteer</label>

                                        <value>

                                                <1>$Gazetteer</1>

                                                <2>$Newgazett</2>

                                        </value>

                                    </_label>

                                </1>

                                <2>$Locnotes</2>

                        </2>

                        <3>

                            <_label>