Project

General

Profile

« Previous | Next » 

Revision 4818

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/VegCore-VegBIEN.csv: verbatimElevation->elevation_m mapping: Translate units automatically (currently only works in row-based mode). Don't remove any "ca." prefix because this is a datasource-specific filter that does not apply to current datasources with verbatimElevation. Also map verbatimElevation to location.verbatimelevation.

View differences:

inputs/ACAD/Specimen/VegBIEN.csv
4 4 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
5 5 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/2",
6 6 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
7 
verbatimElevation,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value",
7 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
8 8 
decimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
9 9 
decimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
10 10 
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
......
40 40 
country,/location/locationplace/*_id/placepath/country,
41 41 
county,/location/locationplace/*_id/placepath/county,
42 42 
stateProvince,/location/locationplace/*_id/placepath/stateprovince,
43 
verbatimElevation,/location/verbatimelevation,
43 44 
basisOfRecord,,** No join mapping for basisOfRecord **
44 45 
bibliographicCitation,,** No join mapping for dcterms:bibliographicCitation **
45 46 
dynamicProperties,,** No join mapping for dynamicProperties **
inputs/ACAD/Specimen/test.xml.ref
22 22 
                    </_alt>
23 23 
                </authorlocationcode>
24 24 
                <elevation_m>
25 
                    <_replace>
26 
                        <\bca\.?></\bca\.?>
25 
                    <_units>
26 
                        <to>m</to>
27 
                        <to></to>
27 28 
                        <value>$verbatimElevation</value>
28 
                    </_replace>
29 
                    </_units>
29 30 
                </elevation_m>
30 31 
                <locationcoords>
31 32 
                    <latitude_deg>
......
122 123 
                        </placepath>
123 124 
                    </placepath_id>
124 125 
                </locationplace>
126 
                <verbatimelevation>$verbatimElevation</verbatimelevation>
125 127 
            </location>
126 128 
        </path>
127 129 
    </_simplifyPath>
inputs/NCU-NCSC/Specimen/VegBIEN.csv
2 2 
Accession Number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 3 
SeriesName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
4 4 
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
5 
Elevation,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value",
5 
Elevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
6 6 
Accuracy,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1,
7 7 
Lat (-=S),"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
8 8 
Long (-=W),"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
......
17 17 
Country,/location/locationplace/*_id/placepath/country,
18 18 
County,/location/locationplace/*_id/placepath/county,
19 19 
State,/location/locationplace/*_id/placepath/stateprovince,
20 
Elevation,/location/verbatimelevation,
20 21 
Alt E/W,,** No join mapping for Alt E/W **
21 22 
Alt N/S,,** No join mapping for Alt N/S **
22 23 
FIPS,,** No join mapping for FIPS ** FIPS county code
inputs/NCU-NCSC/Specimen/test.xml.ref
16 16 
                    </_alt>
17 17 
                </authorlocationcode>
18 18 
                <elevation_m>
19 
                    <_replace>
20 
                        <\bca\.?></\bca\.?>
19 
                    <_units>
20 
                        <to>m</to>
21 
                        <to></to>
21 22 
                        <value>$Elevation</value>
22 
                    </_replace>
23 
                    </_units>
23 24 
                </elevation_m>
24 25 
                <locationcoords>
25 26 
                    <coordsaccuracy_deg><_noCV><value>$Accuracy</value></_noCV></coordsaccuracy_deg>
......
74 75 
                        </placepath>
75 76 
                    </placepath_id>
76 77 
                </locationplace>
78 
                <verbatimelevation>$Elevation</verbatimelevation>
77 79 
            </location>
78 80 
        </path>
79 81 
    </_simplifyPath>
inputs/QMOR/Specimen/VegBIEN.csv
4 4 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
5 5 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/2",
6 6 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
7 
verbatimElevation,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value",
7 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
8 8 
maximumElevationInMeters,"/location/elevation_m/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
9 9 
minimumElevationInMeters,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
10 10 
minimumElevationInMeters,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
......
51 51 
country,/location/locationplace/*_id/placepath/country,
52 52 
county,/location/locationplace/*_id/placepath/county,
53 53 
stateProvince,/location/locationplace/*_id/placepath/stateprovince,
54 
verbatimElevation,/location/verbatimelevation,
54 55 
acceptedNameUsage,,** No join mapping for acceptedNameUsage **
55 56 
basisOfRecord,,** No join mapping for basisOfRecord **
56 57 
behavior,,** No join mapping for behavior **
inputs/QMOR/Specimen/test.xml.ref
24 24 
                <elevation_m>
25 25 
                    <_alt>
26 26 
                        <1>
27 
                            <_replace>
28 
                                <\bca\.?></\bca\.?>
27 
                            <_units>
28 
                                <to>m</to>
29 
                                <to></to>
29 30 
                                <value>$verbatimElevation</value>
30 
                            </_replace>
31 
                            </_units>
31 32 
                        </1>
32 33 
                        <2>
33 34 
                            <_avg>
......
238 239 
                        </placepath>
239 240 
                    </placepath_id>
240 241 
                </locationplace>
242 
                <verbatimelevation>$verbatimElevation</verbatimelevation>
241 243 
            </location>
242 244 
        </path>
243 245 
    </_simplifyPath>
mappings/VegCore-VegBIEN.csv
17 17 
plotArea_ha,/location/area_m2/_ha_to_m2/value,
18 18 
subplot,/location/authorlocationcode,
19 19 
elevationInMeters,/location/elevation_m/_alt/1,
20 
verbatimElevation,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value",
20 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
21 21 
verbatimElevation_m,/location/elevation_m/_alt/2/_avg/max/_rangeEnd/value,
22 22 
maximumElevationInMeters,"/location/elevation_m/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
23 23 
verbatimElevation_m,/location/elevation_m/_alt/2/_avg/min/_rangeStart/value,
......
179 179 
subplotID,/location/sourceaccessioncode,
180 180 
subplotX,/location/sublocationxposition_m,
181 181 
subplotY,/location/sublocationyposition_m,
182 
verbatimElevation,/location/verbatimelevation,
182 183 
verbatimElevation_m,/location/verbatimelevation,
mappings/for_review/VegCore-VegBIEN.csv
179 179 
subplotID,//location/sourceaccessioncode,
180 180 
subplotX,//location/sublocationxposition_m,
181 181 
subplotY,//location/sublocationyposition_m,
182 
verbatimElevation,//location/verbatimelevation,
182 183 
verbatimElevation_m,//location/verbatimelevation,

Also available in: Unified diff