Project

General

Profile

« Previous | Next » 

Revision 4004

Added by Aaron Marcuse-Kubitza over 12 years ago

inputs/UNCC/maps/DwC.specimens.csv: herbarium: Fixed mapping to go to institutionCode instead of collectionCode

View differences:

inputs/UNCC/test/import.specimens.xml.ref
1 1 
Put template:
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 
        <authorlocationcode><_merge><2>$herbarium</2></_merge></authorlocationcode>
4 
        <authorlocationcode><_merge><1>$herbarium</1></_merge></authorlocationcode>
5 5 
        <locationdetermination>
6 6 
            <namedplace_id>
7 7 
                <_simplifyPath>
......
96 96 
                    </notes>
97 97 
                    <plantobservation>
98 98 
                        <specimenreplicate>
99 
                            <collectioncode_dwc><_alt><1>$herbarium</1></_alt></collectioncode_dwc>
100 99 
                            <collectionnumber><_alt><1>$collectno</1></_alt></collectionnumber>
100 
                            <institution_id><party><organizationname>$herbarium</organizationname></party></institution_id>
101 101 
                            <sourceaccessioncode>$accession</sourceaccessioncode>
102 102 
                        </specimenreplicate>
103 103 
                    </plantobservation>
......
206 206 
        <sourceaccessioncode>$accession</sourceaccessioncode>
207 207 
    </location>
208 208 
</VegBIEN>
209 
Inserted 21 new rows into database
209 
Inserted 22 new rows into database
inputs/UNCC/maps/DwC.specimens.csv
1 1 
UNCC[DwC],DwC,Comments
2 2 
accession,occurrenceID,
3 
herbarium,collectionCode,
3 
herbarium,institutionCode,
4 4 
usdaRank,taxonRank/_alt/1,
5 5 
infrarank,taxonRank/_alt/2,
6 6 
infraname,infraspecificEpithet,
inputs/UNCC/maps/DwC.specimens.full.csv
4 4 
collector2,Collector/_merge/3,
5 5 
collector3,Collector/_merge/4,
6 6 
sheetno,associatedMedia,?
7 
herbarium,collectionCode,
8 7 
collectno,collectorNumber,
9 8 
country,country
10 9 
county,county
......
21 20 
genus,genus
22 21 
habitat,habitat
23 22 
infraname,infraspecificEpithet,
23 
herbarium,institutionCode,
24 24 
locality,locality
25 25 
collmonth,monthCollected,
26 26 
accession,occurrenceID,
inputs/UNCC/maps/VegBIEN.specimens.csv
1 1 
UNCC[DwC],VegBIEN:,Comments
2 
herbarium,/location/authorlocationcode/_merge/2,
2 
herbarium,/location/authorlocationcode/_merge/1,
3 3 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
4 4 
state,"/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",
5 5 
country,"/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",
......
13 13 
campus,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/5/_label[label=""campus""]/value",
14 14 
loanto,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/6/_label[label=""loaned to""]/value",
15 15 
inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/7/_label[label=""in or out""]/value",
16 
herbarium,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
17 16 
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
17 
herbarium,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
18 18 
accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
19 19 
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values
20 20 
cultivated,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values

Also available in: Unified diff