Project

General

Profile

« Previous | Next » 

Revision 4060

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/VegCSV-VegBIEN.specimens.csv: catalogNumber: Added location.authorlocationcode mapping for mergability with DwC

View differences:

inputs/SALVIAS-CSV/test/import.organisms.xml.ref
1 1 
Put template:
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 
        <authorlocationcode>$subplot</authorlocationcode>
4 
        <authorlocationcode>
5 
            <_alt>
6 
                <1>$subplot</1>
7 
                <3>
8 
                    <_if name="if indirect voucher">
9 
                        <else>
10 
                            <_alt>
11 
                                <1>$coll_number</1>
12 
                                <2>$voucher_string</2>
13 
                            </_alt>
14 
                        </else>
15 
                    </_if>
16 
                </3>
17 
            </_alt>
18 
        </authorlocationcode>
5 19 
        <locationevent>
6 20 
            <obsstartdate><_date><date><_dateRangeStart><value>$census_date</value></_dateRangeStart></date></_date></obsstartdate>
7 21 
            <taxonoccurrence>
inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv
1 1 
SALVIAS-CSV,VegBIEN:,Comments
2 2 
subplot,/location/authorlocationcode/_alt/1,
3 
coll_number,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/1",Brad: Incorrect. Map instead as for voucher_string
4 
voucher_string,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
3 5 
census_date,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
4 6 
-----
5 7 
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count
inputs/SALVIAS/test/import.organisms.xml.ref
1 1 
Put template:
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 
        <authorlocationcode>$Line</authorlocationcode>
4 
        <authorlocationcode>
5 
            <_alt>
6 
                <1>$Line</1>
7 
                <3>
8 
                    <_if name="if indirect voucher">
9 
                        <else>
10 
                            <_alt>
11 
                                <1>$coll_number</1>
12 
                                <2>$SourceVoucher</2>
13 
                            </_alt>
14 
                        </else>
15 
                    </_if>
16 
                </3>
17 
            </_alt>
18 
        </authorlocationcode>
5 19 
        <locationevent>
6 20 
            <obsenddate><_date><date><_dateRangeEnd><value>$census_date</value></_dateRangeEnd></date></_date></obsenddate>
7 21 
            <obsstartdate><_date><date><_dateRangeStart><value>$census_date</value></_dateRangeStart></date></_date></obsstartdate>
inputs/SALVIAS/maps/VegBIEN.organisms.csv
1 1 
SALVIAS,VegBIEN:,Comments
2 2 
Line,/location/authorlocationcode/_alt/1,
3 
coll_number,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/1",Brad: Incorrect. Map instead as for voucher_string
4 
SourceVoucher,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
3 5 
census_date,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
4 6 
-----
5 7 
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count
mappings/VegCSV-VegBIEN.specimens.csv
2 2 
plotArea,/location/area,
3 3 
plotName,/location/authorlocationcode/_alt/1,
4 4 
fieldNumber,/location/authorlocationcode/_alt/2,
5 
catalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
5 6 
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
6 7 
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
7 8 
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
mappings/for_review/VegCSV-VegBIEN.specimens.csv
2 2 
plotArea,//location/area,
3 3 
plotName,//location/authorlocationcode,
4 4 
fieldNumber,//location/authorlocationcode,
5 
catalogNumber,"//location/authorlocationcode/_if[@name=""if indirect voucher""]/else",
5 6 
verbatimElevation,//location/elevation,
6 7 
maximumElevationInMeters,//location/elevation,
7 8 
minimumElevationInMeters,//location/elevation,

Also available in: Unified diff