Project

General

Profile

« Previous | Next » 

Revision 1835

Added by Aaron Marcuse-Kubitza over 12 years ago

VegX mappings: Map locationevent.sourceaccessioncode to plotUniqueIdentifier since this field is no longer being used by authorlocationcode

View differences:

inputs/SALVIAS-CSV/test/VegX.plots.xml.ref
10 10 
                <methodID><method><name>1 ha, stems &gt;= 10 cm dbh</name></method></methodID>
11 11 
            </simpleUserdefined>
12 12 
            <partyWithRole><partyID>0</partyID></partyWithRole>
13 
            <simpleUserdefined>
14 
                <name>sourceAccessionCode</name>
15 
                <value>26102</value>
16 
            </simpleUserdefined>
17 13 
        </plotObservation>
18 14 
        <plotObservation id="1">
19 15 
            <projectID>1</projectID>
......
24 20 
                <methodID><method><name>1 ha, stems &gt;= 10 cm dbh</name></method></methodID>
25 21 
            </simpleUserdefined>
26 22 
            <partyWithRole><partyID>1</partyID></partyWithRole>
27 
            <simpleUserdefined>
28 
                <name>sourceAccessionCode</name>
29 
                <value>26103</value>
30 
            </simpleUserdefined>
31 23 
        </plotObservation>
32 24 
    </plotObservations>
33 25 
    <projects>
......
68 60 
                <placeName>Loreto</placeName>
69 61 
            </location>
70 62 
            <plotName>ALP-11</plotName>
63 
            <plotUniqueIdentifier>26102</plotUniqueIdentifier>
71 64 
        </plot>
72 65 
        <plot id="1">
73 66 
            <area>0.4</area>
......
90 83 
                <placeName>Loreto</placeName>
91 84 
            </location>
92 85 
            <plotName>ALP-12</plotName>
86 
            <plotUniqueIdentifier>26103</plotUniqueIdentifier>
93 87 
        </plot>
94 88 
    </plots>
95 89 
    <parties>
inputs/SALVIAS-CSV/test/VegX.organisms.xml.ref
173 173 
        <plotObservation id="1">
174 174 
            <plotUniqueIdentifierID>0</plotUniqueIdentifierID>
175 175 
            <partyWithRole><partyID>2</partyID></partyWithRole>
176 
            <simpleUserdefined>
177 
                <name>sourceAccessionCode</name>
178 
                <value>26102</value>
179 
            </simpleUserdefined>
180 176 
        </plotObservation>
181 177 
        <plotObservation id="2">
182 178 
            <obsStartDate>2001-01-01</obsStartDate>
......
190 186 
        <plotObservation id="3">
191 187 
            <plotUniqueIdentifierID>2</plotUniqueIdentifierID>
192 188 
            <partyWithRole><partyID>6</partyID></partyWithRole>
193 
            <simpleUserdefined>
194 
                <name>sourceAccessionCode</name>
195 
                <value>26102</value>
196 
            </simpleUserdefined>
197 189 
        </plotObservation>
198 190 
    </plotObservations>
199 191 
    <plots>
200 
        <plot id="0"><plotName>ALP-11</plotName></plot>
192 
        <plot id="0">
193 
            <plotName>ALP-11</plotName>
194 
            <plotUniqueIdentifier>26102</plotUniqueIdentifier>
195 
        </plot>
201 196 
        <plot id="1"><plotName>1</plotName></plot>
202 
        <plot id="2"><plotName>ALP-11</plotName></plot>
197 
        <plot id="2">
198 
            <plotName>ALP-11</plotName>
199 
            <plotUniqueIdentifier>26102</plotUniqueIdentifier>
200 
        </plot>
203 201 
        <plot id="3"><plotName>4</plotName></plot>
204 202 
    </plots>
205 203 
    <individualOrganismObservations id="1">
inputs/SALVIAS-CSV/maps/VegX.plots.csv
1 1 
SALVIAS-CSV,VegX:/*s/plotObservation,Comments
2 2 
project,/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,
3 
PLOT_ID,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
3 
PLOT_ID,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
4 4 
plot_code,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
5 5 
major_geo,/*UniqueIdentifierID->/*s/plot/location[placeType=continent]/placeName,
6 6 
country,/*UniqueIdentifierID->/*s/plot/location[placeType=country]/placeName,
inputs/SALVIAS-CSV/maps/VegX.organisms.csv
1 1 
SALVIAS-CSV,VegX:/*s/individualOrganismObservation,Comments
2 2 
OBSERVATION_ID,:[*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
3 
PLOT_ID,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
3 
PLOT_ID,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
4 4 
plot_code,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"Brad: Same as plotCode, above"
5 5 
census_no,/simpleUserdefined[name=censusNo]/value,"Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."
6 6 
census_date,/*ID->/*s/plotObservation/obsStartDate/_date/year,
inputs/SALVIAS-CSV/maps/VegX.plots.full.csv
38 38 
precip_mm,/simpleUserdefined[name=precipitation]/value,
39 39 
temp_c,/temperature,
40 40 
plot_code,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
41 
PLOT_ID,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
41 
PLOT_ID,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
42 42 
observation_type,,"Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
43 43 
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
inputs/SALVIAS-CSV/maps/VegX.organisms.full.csv
21 21 
stem_tag2,/*ID->/*s/individualOrganism/identificationLabel[@id=2]/_alt/2,Brad: see above
22 22 
census_date,/*ID->/*s/plotObservation/obsStartDate/_date/year,
23 23 
plot_code,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"Brad: Same as plotCode, above"
24 
PLOT_ID,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
24 
PLOT_ID,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
25 25 
subplot,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,
26 26 
basal_diam,/diameterBaseDistance[baseDistance/value=0]/diameter,
27 27 
stem_dbh,/diameterBaseDistance[baseDistance/value=1.37]/diameter,
inputs/CTFS/maps/VegX.organisms.full.csv
86 86 
/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name
87 87 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName
88 88 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName
89 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value
89 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier
90 90 
/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value,/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value
91 91 
/*ID->/*s/plotObservation/temperature,/*ID->/*s/plotObservation/temperature
92 92 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName
93 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value
93 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier
94 94 
/diameterBaseDistance[baseDistance/value=0]/diameter,/diameterBaseDistance[baseDistance/value=0]/diameter
95 95 
/diameterBaseDistance[baseDistance/value=1.37]/diameter,/diameterBaseDistance[baseDistance/value=1.37]/diameter
96 96 
/height,/height
inputs/CTFS/maps/VegBIEN.organisms.csv
23 23 
/*ID->/*s/plotObservation/obsStartDate,/*_id/locationevent/obsstartdate,
24 24 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,/*_id/locationevent/parent_id/locationevent/authorlocationcode,
25 25 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
26 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
26 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
27 27 
/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value,/*_id/locationevent/precipitation,
28 28 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,/*_id/locationevent/soilobs/acidity,
29 29 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,/*_id/locationevent/soilobs/basesaturation,
......
47 47 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/*_id/locationevent/waterdepth/min/_units:[default=m,to=m,to=]/value",
48 48 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,
49 49 
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
50 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
50 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
51 51 
/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/voucher,"/_if:[cond/_eq:[left=$../../../_ignore/voucherType,right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc",
52 52 
/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,"/_if:[cond/_eq:[left=$../../../_ignore/voucherType,right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1",
53 53 
"/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType",/_ignore/voucherType,
inputs/SALVIAS/test/VegX.plots.xml.ref
13 13 
                <value>2500.0</value>
14 14 
            </simpleUserdefined>
15 15 
            <partyWithRole><partyID>0</partyID></partyWithRole>
16 
            <simpleUserdefined>
17 
                <name>sourceAccessionCode</name>
18 
                <value>1</value>
19 
            </simpleUserdefined>
20 16 
        </plotObservation>
21 17 
        <plotObservation id="1">
22 18 
            <projectID>1</projectID>
......
31 27 
            </simpleUserdefined>
32 28 
            <temperature>7.4</temperature>
33 29 
            <partyWithRole><partyID>1</partyID></partyWithRole>
34 
            <simpleUserdefined>
35 
                <name>sourceAccessionCode</name>
36 
                <value>2</value>
37 
            </simpleUserdefined>
38 30 
        </plotObservation>
39 31 
    </plotObservations>
40 32 
    <communityDeterminations>
......
90 82 
                <placeName>Ecuador</placeName>
91 83 
            </location>
92 84 
            <plotName>ACHUPALL</plotName>
85 
            <plotUniqueIdentifier>1</plotUniqueIdentifier>
93 86 
        </plot>
94 87 
        <plot id="1">
95 88 
            <area>0.1</area>
......
107 100 
                <placeName>Germany</placeName>
108 101 
            </location>
109 102 
            <plotName>ALLACHER</plotName>
103 
            <plotUniqueIdentifier>2</plotUniqueIdentifier>
110 104 
        </plot>
111 105 
    </plots>
112 106 
    <parties>
inputs/SALVIAS/test/VegX.organisms.xml.ref
164 164 
        <plotObservation id="1">
165 165 
            <plotUniqueIdentifierID>0</plotUniqueIdentifierID>
166 166 
            <partyWithRole><partyID>1</partyID></partyWithRole>
167 
            <simpleUserdefined>
168 
                <name>sourceAccessionCode</name>
169 
                <value>295</value>
170 
            </simpleUserdefined>
171 167 
        </plotObservation>
172 168 
        <plotObservation id="2">
173 169 
            <simpleUserdefined>
......
180 176 
        <plotObservation id="3">
181 177 
            <plotUniqueIdentifierID>2</plotUniqueIdentifierID>
182 178 
            <partyWithRole><partyID>4</partyID></partyWithRole>
183 
            <simpleUserdefined>
184 
                <name>sourceAccessionCode</name>
185 
                <value>295</value>
186 
            </simpleUserdefined>
187 179 
        </plotObservation>
188 180 
    </plotObservations>
189 181 
    <plots>
190 
        <plot id="0"><plotName>c2000-1</plotName></plot>
182 
        <plot id="0">
183 
            <plotName>c2000-1</plotName>
184 
            <plotUniqueIdentifier>295</plotUniqueIdentifier>
185 
        </plot>
191 186 
        <plot id="1"><plotName>1</plotName></plot>
192 
        <plot id="2"><plotName>c2000-1</plotName></plot>
187 
        <plot id="2">
188 
            <plotName>c2000-1</plotName>
189 
            <plotUniqueIdentifier>295</plotUniqueIdentifier>
190 
        </plot>
193 191 
        <plot id="3"><plotName>1</plotName></plot>
194 192 
    </plots>
195 193 
    <individualOrganismObservations id="1">
inputs/SALVIAS/maps/VegX.plots.csv
1 1 
SALVIAS:plotMetadata,VegX:/*s/plotObservation,Comments
2 
PlotID,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
2 
PlotID,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
3 3 
orig_filename,,
4 4 
AccessCode,,
5 5 
project_id,/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,
inputs/SALVIAS/maps/VegX.organisms.csv
1 1 
SALVIAS:plotObservations,VegX:/*s/individualOrganismObservation,Comments
2 2 
PlotObsID,:[*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
3 
PlotID,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
3 
PlotID,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
4 4 
PlotCode,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"Brad: Same as plotCode, above"
5 5 
census_no,/simpleUserdefined[name=censusNo]/value,"Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."
6 6 
census_date,/simpleUserdefined[name=collectionDate]/value/_*/date,
inputs/SALVIAS/maps/VegX.plots.full.csv
38 38 
Precip,/simpleUserdefined[name=precipitation]/value,
39 39 
Temp,/temperature,
40 40 
SiteCode,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
41 
PlotID,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
41 
PlotID,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
42 42 
AccessCode,,
43 43 
ElevSource,,
44 44 
Habitat,,
inputs/SALVIAS/maps/VegX.organisms.full.csv
19 19 
tag1,/*ID->/*s/individualOrganism/identificationLabel[@id=1],"Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
20 20 
tag2,/*ID->/*s/individualOrganism/identificationLabel[@id=2],"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
21 21 
PlotCode,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"Brad: Same as plotCode, above"
22 
PlotID,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
22 
PlotID,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
23 23 
Line,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,
24 24 
temp_dbh,/diameterBaseDistance[baseDistance/value=1.37]/diameter,
25 25 
height_m,/height,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
mappings/VegX-VegBIEN.plots.csv
23 23 
/obsStartDate,/obsstartdate,
24 24 
/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,/parent_id/locationevent/authorlocationcode,
25 25 
/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
26 
/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
26 
/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
27 27 
/simpleUserdefined[name=precipitation]/value,/precipitation,
28 28 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,/soilobs/acidity,
29 29 
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,/soilobs/basesaturation,
......
47 47 
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/waterdepth/min/_units:[default=m,to=m,to=]/value",
48 48 
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,
49 49 
/partyWithRole/*ID->/parties/party/organizationName,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
50 
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
50 
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
mappings/VegX-VegBIEN.organisms.csv
23 23 
/*ID->/*s/plotObservation/obsStartDate,/*_id/locationevent/obsstartdate,
24 24 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,/*_id/locationevent/parent_id/locationevent/authorlocationcode,
25 25 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
26 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
26 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent/parent_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
27 27 
/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value,/*_id/locationevent/precipitation,
28 28 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,/*_id/locationevent/soilobs/acidity,
29 29 
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,/*_id/locationevent/soilobs/basesaturation,
......
47 47 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/*_id/locationevent/waterdepth/min/_units:[default=m,to=m,to=]/value",
48 48 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,
49 49 
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,
50 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
50 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
51 51 
/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/voucher,"/_if:[cond/_eq:[left=$../../../_ignore/voucherType,right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc",
52 52 
/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,"/_if:[cond/_eq:[left=$../../../_ignore/voucherType,right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1",
53 53 
"/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType",/_ignore/voucherType,
mappings/VegX.self.plots.csv
43 43 
/simpleUserdefined[name=method]/*ID/method/name,/simpleUserdefined[name=method]/*ID/method/name
44 44 
/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName
45 45 
/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName
46 
/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value
46 
/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier
47 47 
/simpleUserdefined[name=precipitation]/value,/simpleUserdefined[name=precipitation]/value
48 48 
/temperature,/temperature
49 49 
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName
50 
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value
50 
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier
mappings/VegX.self.organisms.csv
83 83 
/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name
84 84 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName
85 85 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName
86 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value
86 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier
87 87 
/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value,/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value
88 88 
/*ID->/*s/plotObservation/temperature,/*ID->/*s/plotObservation/temperature
89 89 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName
90 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value
90 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier
91 91 
/diameterBaseDistance[baseDistance/value=0]/diameter,/diameterBaseDistance[baseDistance/value=0]/diameter
92 92 
/diameterBaseDistance[baseDistance/value=1.37]/diameter,/diameterBaseDistance[baseDistance/value=1.37]/diameter
93 93 
/height,/height
mappings/for_review/VegX-VegBIEN.plots.csv
23 23 
/obsStartDate,/obsstartdate,
24 24 
//plot/plotName,//locationevent/authorlocationcode,
25 25 
//party/organizationName,//party/organizationname/_alt/1,
26 
//plotObservation/simpleUserdefined[name=sourceAccessionCode]/value,//locationevent/sourceaccessioncode,
26 
//plot/plotUniqueIdentifier,//locationevent/sourceaccessioncode,
27 27 
/simpleUserdefined[name=precipitation]/value,/precipitation,
28 28 
//*s/abioticObservation/simpleUserdefined[name=acidity]/value,//soilobs/acidity,
29 29 
//*s/abioticObservation/simpleUserdefined[name=base]/value,//soilobs/basesaturation,
......
47 47 
//geospatial/minimumDepthInMeters,//waterdepth/min/_units/value,
48 48 
//plot/plotName,/authorlocationcode,
49 49 
//party/organizationName,//party/organizationname/_alt/1,
50 
/simpleUserdefined[name=sourceAccessionCode]/value,/sourceaccessioncode,
50 
//plot/plotUniqueIdentifier,/sourceaccessioncode,
mappings/for_review/VegX-VegBIEN.organisms.csv
23 23 
//plotObservation/obsStartDate,//locationevent/obsstartdate,
24 24 
//plot/plotName,//locationevent/authorlocationcode,
25 25 
//party/organizationName,//party/organizationname/_alt/1,
26 
//plotObservation/simpleUserdefined[name=sourceAccessionCode]/value,//locationevent/sourceaccessioncode,
26 
//plot/plotUniqueIdentifier,//locationevent/sourceaccessioncode,
27 27 
//plotObservation/simpleUserdefined[name=precipitation]/value,//locationevent/precipitation,
28 28 
//*s/abioticObservation/simpleUserdefined[name=acidity]/value,//soilobs/acidity,
29 29 
//*s/abioticObservation/simpleUserdefined[name=base]/value,//soilobs/basesaturation,
......
47 47 
//geospatial/minimumDepthInMeters,//waterdepth/min/_units/value,
48 48 
//plot/plotName,//locationevent/authorlocationcode,
49 49 
//party/organizationName,//party/organizationname/_alt/1,
50 
//plotObservation/simpleUserdefined[name=sourceAccessionCode]/value,//locationevent/sourceaccessioncode,
50 
//plot/plotUniqueIdentifier,//locationevent/sourceaccessioncode,
51 51 
//taxonNameUsageConcept/voucher,"/_if/{then/specimenreplicate,else/voucher/*_id/specimenreplicate}//catalognumber_dwc",
52 52 
//party/organizationName,"/_if/{then/specimenreplicate,else/voucher/*_id/specimenreplicate}//datasource_id/party/organizationname/_alt/1",
53 53 
//*s/taxonDetermination[role=collector]/groupType,/_ignore/voucherType,

Also available in: Unified diff