NCU-NCSC,VegCore,Filter,Comments

Accession Number,occurrenceID,,

SeriesName,collectionCode,,

Barcode,catalogNumber,,

Full Taxon Name,taxonName,,

Collect Date,dateCollected,,

Country,country,,

State,stateProvince,,

County,county,,

Cultivated?,cultivated,,

Elevation,verbatimElevation,,

Lat (-=S),decimalLatitude,"/_replace:[""\?$""=]/value",

Long (-=W),decimalLongitude,"/_replace:[""\?$""=]/value",

Accuracy,coordinateUncertaintyInMeters,,

FIPS,*FIPS,,FIPS county code

Alt N/S,*Alt N/S,,

Alt E/W,*Alt E/W,,

Format,preparations,,

Typology,typeStatus,,

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>NCU-NCSC</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <authorlocationcode>

                            <_alt>

                                <1>$Accession Number</1>

                                <2>

                                    <_join>

                                        <2>$SeriesName</2>

                                        <3>$Barcode</3>

                                    </_join>

                                </2>

                            </_alt>

                        </authorlocationcode>

                        <elevation_m>

                            <_units>

                                <to>m</to>

                                <to></to>

                                <value>$Elevation</value>

                            </_units>

                        </elevation_m>

                        <locationevent>

                            <taxonoccurrence>

                                <aggregateoccurrence>

                                    <collectiondate>$Collect Date</collectiondate>

                                    <plantobservation>

                                        <specimenreplicate>

                                            <catalognumber_dwc>$Barcode</catalognumber_dwc>

                                            <collectioncode_dwc>$SeriesName</collectioncode_dwc>

                                            <sourceaccessioncode>$Accession Number</sourceaccessioncode>

                                        </specimenreplicate>

                                    </plantobservation>

                                </aggregateoccurrence>

                                <iscultivated>$Cultivated?</iscultivated>

                                <sourceaccessioncode>$Accession Number</sourceaccessioncode>

                                <taxondetermination>

                                    <taxonverbatim_id>

                                        <taxonverbatim>

                                            <taxonlabel_id>

                                                <taxonlabel>

                                                    <matched_label_id>

                                                        <taxonlabel>

                                                            <source_id><source><shortname>TNRS</shortname></source></source_id>

                                                            <taxonomicname>$Full Taxon Name</taxonomicname>

                                                        </taxonlabel>

                                                    </matched_label_id>

                                                    <taxonomicname>$Full Taxon Name</taxonomicname>

                                                </taxonlabel>

                                            </taxonlabel_id>

                                            <taxonname>$Full Taxon Name</taxonname>

                                        </taxonverbatim>

                                    </taxonverbatim_id>

                                </taxondetermination>

                            </taxonoccurrence>

                        </locationevent>

                        <locationplace>

                            <place_id>

                                <place>

                                    <coordinates_id>

                                        <coordinates>

                                            <coordsaccuracy_m><_noCV><value>$Accuracy</value></_noCV></coordsaccuracy_m>

                                            <latitude_deg>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>

                                                        <_replace>

                                                            <\?$></\?$>

                                                            <value>$Lat (-=S)</value>

                                                        </_replace>

                                                    </value>

                                                </_nullIf>

                                            </latitude_deg>

                                            <longitude_deg>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>

                                                        <_replace>

                                                            <\?$></\?$>

                                                            <value>$Long (-=W)</value>

                                                        </_replace>

                                                    </value>

                                                </_nullIf>

                                            </longitude_deg>

                                        </coordinates>

                                    </coordinates_id>

                                    <country>$Country</country>

                                    <county>$County</county>

                                    <matched_place_id>

                                        <place>

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

                                            <coordinates_id>

                                                <coordinates>

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

                                                    <latitude_deg>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>

                                                                <_replace>

                                                                    <\?$></\?$>

                                                                    <value>$Lat (-=S)</value>

                                                                </_replace>

                                                            </value>

                                                        </_nullIf>

                                                    </latitude_deg>

                                                    <longitude_deg>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>

                                                                <_replace>

                                                                    <\?$></\?$>

                                                                    <value>$Long (-=W)</value>

                                                                </_replace>

                                                            </value>

                                                        </_nullIf>

                                                    </longitude_deg>

                                                </coordinates>

                                            </coordinates_id>

                                            <country>$Country</country>

                                            <county>$County</county>

                                            <stateprovince>$State</stateprovince>

                                        </place>

                                    </matched_place_id>

                                    <stateprovince>$State</stateprovince>

                                </place>

                            </place_id>

                        </locationplace>

                        <verbatimelevation>$Elevation</verbatimelevation>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 29 new rows into database

NCU-NCSC,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Accession Number,"/_if[@name=""if specimen""]/cond/_exists",

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

Accession Number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",

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

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

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

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

Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",

Elevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",

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

Cultivated?,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_alt/2",

Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1,

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

SeriesName,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name

Accession Number,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcename/_if[@name=""if specimen""]/cond/_exists",

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

Accession Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

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

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

Cultivated?,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/2",

Accession Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,

Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1",

Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1",

Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1,

Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,

Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,

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

Accuracy,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value,

Lat (-=S),"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",

Long (-=W),"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",

Country,/location/locationplace/*_id/place/country,

County,/location/locationplace/*_id/place/county,

Lat (-=S),"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",""".,"" sorts it with other coordinates mappings"

Long (-=W),"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",""".,"" sorts it with other coordinates mappings"

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

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

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

State,/location/locationplace/*_id/place/stateprovince,

Elevation,/location/verbatimelevation,

Alt E/W,,** No join mapping for *Alt E/W ** 

Alt N/S,,** No join mapping for *Alt N/S ** 

FIPS,,** No join mapping for *FIPS ** FIPS county code

Format,,** No join mapping for preparations ** 

Typology,,** No join mapping for typeStatus ** 

Accession Number,occurrenceID,,

SeriesName,collectionCode,,

Barcode,catalogNumber,,

Full Taxon Name,taxonName,,

Collect Date,dateCollected,,

Lat (-=S),decimalLatitude,"/_replace:[""\?$""=]/value",

Long (-=W),decimalLongitude,"/_replace:[""\?$""=]/value",

Accuracy,coordinateUncertaintyInMeters,,

Format,preparations,,

Typology,typeStatus,,

!'Accession Number','SeriesName','Barcode','Full Taxon Name','Collect Date','Country','State','County','Cultivated?','Elevation','Lat (-=S)','Long (-=W)','Accuracy','FIPS','Alt N/S','Alt E/W','Format','Typology'

*FIPS

*Alt N/S

*Alt E/W

preparations

typeStatus

Accession Number,occurrenceID,,

Accuracy,coordinateUncertaintyInMeters,,

Barcode,catalogNumber,,

Collect Date,dateCollected,,

Format,preparations,,

Full Taxon Name,scientificName,,

Lat (-=S),verbatimLatitude,"/_replace:[""\?$""=]/value",

Long (-=W),verbatimLongitude,"/_replace:[""\?$""=]/value",

SeriesName,collectionCode,,

Typology,typeStatus,,

Alt E/W

Alt N/S

FIPS

preparations

typeStatus

NCU-NCSC,VegCore,Filter,Comments

:herbarium,referenceType,,

:specimen,sampleType,,

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>NCU-NCSC</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <source>

                        <shortname>NCU-NCSC</shortname>

                        <sampletype>specimen</sampletype>

                        <sourcetype>herbarium</sourcetype>

                    </source>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 0 new rows into database

NCU-NCSC,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

:specimen,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sampletype",

:herbarium,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",