Project

General

Profile

« Previous | Next » 

Revision 4382

Added by Aaron Marcuse-Kubitza almost 12 years ago

mappings/Veg+-VegCore.csv: Remapped CTFS QuadratID to subplot rather than subplotID, because it's only unique within the parent plot, not globally unique, in CTFS

View differences:

inputs/CTFS/StemObservation/VegBIEN.csv
1 1 
CTFS[Veg+],VegBIEN:,Comments
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/1",
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1",
3 3 
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
4 4 
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
5 5 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
6 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/1",
6 
QuadratID,/location/authorlocationcode/_first/1,
7 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1",
7 8 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
8 9 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode",
9 10 
MeasureID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
......
19 20 
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
20 21 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
21 22 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
22 
QuadratID,/location/sourceaccessioncode,
inputs/CTFS/StemObservation/test.xml.ref
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 4 
        <parent_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></parent_id>
5 
        <authorlocationcode>$QuadratID</authorlocationcode>
5 6 
        <locationevent>
6 7 
            <parent_id><locationevent><sourceaccessioncode>$CensusID</sourceaccessioncode></locationevent></parent_id>
7 8 
            <taxonoccurrence>
......
74 75 
                </taxondetermination>
75 76 
            </taxonoccurrence>
76 77 
        </locationevent>
77 
        <sourceaccessioncode>$QuadratID</sourceaccessioncode>
78 78 
    </location>
79 79 
</VegBIEN>
80 80 
Inserted 16 new rows into database
inputs/CTFS/Subplot/VegBIEN.csv
1 1 
CTFS[Veg+],VegBIEN:,Comments
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/1",
3 
QuadratName,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1",
3 
QuadratName,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/2",
4 4 
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
5 5 
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
6 6 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
7 
QuadratName,/location/authorlocationcode,
8 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/1",
9 
QuadratName,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
10 
QuadratID,/location/sourceaccessioncode,
7 
QuadratID,/location/authorlocationcode/_first/1,
8 
QuadratName,/location/authorlocationcode/_first/2,
9 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1",
10 
QuadratName,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/2",
11 11 
StartX,/location/sublocationxposition,
12 12 
StartY,/location/sublocationyposition,
inputs/CTFS/Subplot/test.xml.ref
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 4 
        <parent_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></parent_id>
5 
        <authorlocationcode>$QuadratName</authorlocationcode>
6 
        <sourceaccessioncode>$QuadratID</sourceaccessioncode>
5 
        <authorlocationcode>$QuadratID</authorlocationcode>
7 6 
        <sublocationxposition>$StartX</sublocationxposition>
8 7 
        <sublocationyposition>$StartY</sublocationyposition>
9 8 
    </location>
10 9 
</VegBIEN>
11 
Inserted 3 new rows into database
10 
Inserted 5 new rows into database
inputs/CTFS/SubplotObservation/VegBIEN.csv
1 1 
CTFS[Veg+],VegBIEN:,Comments
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/1",
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1",
3 3 
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
4 4 
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
5 5 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
6 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/1",
6 
QuadratID,/location/authorlocationcode/_first/1,
7 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1",
7 8 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
8 9 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode",
9 
QuadratID,/location/sourceaccessioncode,
inputs/CTFS/SubplotObservation/test.xml.ref
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 4 
        <parent_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></parent_id>
5 
        <authorlocationcode>$QuadratID</authorlocationcode>
5 6 
        <locationevent><parent_id><locationevent><sourceaccessioncode>$CensusID</sourceaccessioncode></locationevent></parent_id></locationevent>
6 
        <sourceaccessioncode>$QuadratID</sourceaccessioncode>
7 7 
    </location>
8 8 
</VegBIEN>
9 
Inserted 5 new rows into database
9 
Inserted 6 new rows into database
mappings/Veg+-VegBIEN.csv
1 1 
Veg+,VegBIEN:,Comments
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/1",
3 2 
SubplotID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/1",
4 3 
subplotID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/1",
5 
QuadratName,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
6 4 
Subplot,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
7 5 
subplot,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
6 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1",
7 
QuadratName,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/2",
8 8 
PlotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
9 9 
plotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
10 10 
LocationID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
......
45 45 
PlotArea,/location/area,
46 46 
SizeOfSite,/location/area,
47 47 
plotArea,/location/area,
48 
QuadratName,/location/authorlocationcode,
49 48 
Subplot,/location/authorlocationcode,
50 49 
subplot,/location/authorlocationcode,
50 
QuadratID,/location/authorlocationcode/_first/1,
51 
QuadratName,/location/authorlocationcode/_first/2,
51 52 
Elevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
52 53 
VerbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
53 54 
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
......
113 114 
projectName,/location/locationevent/*_id/project/projectname,
114 115 
ProjectID,/location/locationevent/*_id/project/sourceaccessioncode,
115 116 
projectID,/location/locationevent/*_id/project/sourceaccessioncode,
116 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/1",
117 117 
SubplotID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/1",
118 118 
subplotID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/1",
119 
QuadratName,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
120 119 
Subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
121 120 
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
121 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1",
122 
QuadratName,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/2",
122 123 
AuthorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
123 124 
FieldNumber,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
124 125 
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
......
460 461 
slopeAspect,/location/slopeaspect/_compass/value,
461 462 
SlopeGradient,/location/slopegradient,
462 463 
slopeGradient,/location/slopegradient,
463 
QuadratID,/location/sourceaccessioncode,
464 464 
SubplotID,/location/sourceaccessioncode,
465 465 
subplotID,/location/sourceaccessioncode,
466 466 
StartX,/location/sublocationxposition,
mappings/Veg+.cs-VegBIEN.csv
1 1 
Veg+,VegBIEN:,Comments
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/1",
3 2 
subplotID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/1",
4 
QuadratName,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
5 3 
subplot,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
4 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1",
5 
QuadratName,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/2",
6 6 
plotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
7 7 
locationID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
8 8 
plotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
......
24 24 
plotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
25 25 
SizeOfSite,/location/area,
26 26 
plotArea,/location/area,
27 
QuadratName,/location/authorlocationcode,
28 27 
subplot,/location/authorlocationcode,
28 
QuadratID,/location/authorlocationcode/_first/1,
29 
QuadratName,/location/authorlocationcode/_first/2,
29 30 
Elevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
30 31 
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
31 32 
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
......
60 61 
samplingProtocol,/location/locationevent/*_id/method/name,
61 62 
projectName,/location/locationevent/*_id/project/projectname,
62 63 
projectID,/location/locationevent/*_id/project/sourceaccessioncode,
63 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/1",
64 64 
subplotID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/1",
65 
QuadratName,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
66 65 
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
66 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1",
67 
QuadratName,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/2",
67 68 
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
68 69 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
69 70 
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
......
238 239 
plotNotes,/location/notespublic,
239 240 
slopeAspect,/location/slopeaspect/_compass/value,
240 241 
slopeGradient,/location/slopegradient,
241 
QuadratID,/location/sourceaccessioncode,
242 242 
subplotID,/location/sourceaccessioncode,
243 243 
StartX,/location/sublocationxposition,
244 244 
subplotX,/location/sublocationxposition,
mappings/for_review/Veg+-VegCore.csv
70 70 
plotEventStartDate,startDate,
71 71 
state,stateProvince,
72 72 
stem_id,stemID,
73 
QuadratID,subplot,
73 74 
QuadratName,subplot,
74 
QuadratID,subplotID,
75 75 
StartX,subplotX,
76 76 
StartY,subplotY,
77 77 
stemTag,tag,
mappings/Veg+-VegCore.to_self.csv
71 71 
plotEventStartDate,startDate,
72 72 
state,stateProvince,
73 73 
stem_id,stemID,
74 
QuadratName,subplot,
75 
QuadratID,subplotID,
74 
QuadratID,subplot/_first/1,
75 
QuadratName,subplot/_first/2,
76 76 
StartX,subplotX,
77 77 
StartY,subplotY,
78 78 
stemTag,tag,
mappings/Veg+-VegCore.csv
70 70 
plotEventStartDate,startDate,
71 71 
state,stateProvince,
72 72 
stem_id,stemID,
73 
QuadratName,subplot,
74 
QuadratID,subplotID,
73 
QuadratID,subplot/_first/1,
74 
QuadratName,subplot/_first/2,
75 75 
StartX,subplotX,
76 76 
StartY,subplotY,
77 77 
stemTag,tag,

Also available in: Unified diff