Project

General

Profile

« Previous | Next » 

Revision 1834

Added by Aaron Marcuse-Kubitza over 12 years ago

VegX mappings: Map the authorlocationcode to plotName instead of plotUniqueIdentifier because it's a better fit

View differences:

inputs/SALVIAS-CSV/test/VegX.plots.xml.ref
67 67 
                <placeType>state</placeType>
68 68 
                <placeName>Loreto</placeName>
69 69 
            </location>
70 
            <plotUniqueIdentifier>ALP-11</plotUniqueIdentifier>
70 
            <plotName>ALP-11</plotName>
71 71 
        </plot>
72 72 
        <plot id="1">
73 73 
            <area>0.4</area>
......
89 89 
                <placeType>state</placeType>
90 90 
                <placeName>Loreto</placeName>
91 91 
            </location>
92 
            <plotUniqueIdentifier>ALP-12</plotUniqueIdentifier>
92 
            <plotName>ALP-12</plotName>
93 93 
        </plot>
94 94 
    </plots>
95 95 
    <parties>
inputs/SALVIAS-CSV/test/VegX.organisms.xml.ref
197 197 
        </plotObservation>
198 198 
    </plotObservations>
199 199 
    <plots>
200 
        <plot id="0"><plotUniqueIdentifier>ALP-11</plotUniqueIdentifier></plot>
201 
        <plot id="1"><plotUniqueIdentifier>1</plotUniqueIdentifier></plot>
202 
        <plot id="2"><plotUniqueIdentifier>ALP-11</plotUniqueIdentifier></plot>
203 
        <plot id="3"><plotUniqueIdentifier>4</plotUniqueIdentifier></plot>
200 
        <plot id="0"><plotName>ALP-11</plotName></plot>
201 
        <plot id="1"><plotName>1</plotName></plot>
202 
        <plot id="2"><plotName>ALP-11</plotName></plot>
203 
        <plot id="3"><plotName>4</plotName></plot>
204 204 
    </plots>
205 205 
    <individualOrganismObservations id="1">
206 206 
        <individualOrganismObservation>
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 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."
4 
plot_code,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
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,
7 7 
pol1,/*UniqueIdentifierID->/*s/plot/location[placeType=state]/placeName,Brad: No; pol1=stateProvince
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 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."
4 
plot_code,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"Brad: Same as plotCode, above"
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,
7 
subplot,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,
7 
subplot,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,
8 8 
individual_code,/simpleUserdefined[name=authorPlantCode]/value,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
9 9 
ind_id,,Brad: OMIT
10 10 
tag1,/*ID->/*s/individualOrganism/identificationLabel[@id=1]/_alt/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."
inputs/SALVIAS-CSV/maps/VegX.plots.full.csv
37 37 
plot_methodology,/simpleUserdefined[name=method]/*ID/method/name,
38 38 
precip_mm,/simpleUserdefined[name=precipitation]/value,
39 39 
temp_c,/temperature,
40 
plot_code,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
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 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."
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
20 20 
tag2,/*ID->/*s/individualOrganism/identificationLabel[@id=2]/_alt/1,"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 
stem_tag2,/*ID->/*s/individualOrganism/identificationLabel[@id=2]/_alt/2,Brad: see above
22 22 
census_date,/*ID->/*s/plotObservation/obsStartDate/_date/year,
23 
plot_code,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"Brad: Same as plotCode, above"
23 
plot_code,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"Brad: Same as plotCode, above"
24 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."
25 
subplot,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,
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,
28 28 
height_m,/height,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob
inputs/CTFS/maps/VegX.organisms.full.csv
84 84 
/*ID->/*s/plotObservation/obsStartDate,/*ID->/*s/plotObservation/obsStartDate
85 85 
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName
86 86 
/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name
87 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier
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 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
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 
/*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
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 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
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
inputs/CTFS/maps/VegBIEN.organisms.csv
21 21 
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,/*_id/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
22 22 
/*ID->/*s/plotObservation/obsEndDate,/*_id/locationevent/obsenddate,
23 23 
/*ID->/*s/plotObservation/obsStartDate,/*_id/locationevent/obsstartdate,
24 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent/parent_id/locationevent/authorlocationcode,
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 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,
27 27 
/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value,/*_id/locationevent/precipitation,
......
45 45 
/*ID->/*s/plotObservation/temperature,/*_id/locationevent/temperature,
46 46 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/*_id/locationevent/waterdepth/max/_units:[default=m,to=m,to=]/value",
47 47 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/*_id/locationevent/waterdepth/min/_units:[default=m,to=m,to=]/value",
48 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,
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 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,
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",
inputs/SALVIAS/test/VegX.plots.xml.ref
89 89 
                <placeType>country</placeType>
90 90 
                <placeName>Ecuador</placeName>
91 91 
            </location>
92 
            <plotUniqueIdentifier>ACHUPALL</plotUniqueIdentifier>
92 
            <plotName>ACHUPALL</plotName>
93 93 
        </plot>
94 94 
        <plot id="1">
95 95 
            <area>0.1</area>
......
106 106 
                <placeType>country</placeType>
107 107 
                <placeName>Germany</placeName>
108 108 
            </location>
109 
            <plotUniqueIdentifier>ALLACHER</plotUniqueIdentifier>
109 
            <plotName>ALLACHER</plotName>
110 110 
        </plot>
111 111 
    </plots>
112 112 
    <parties>
inputs/SALVIAS/test/VegX.organisms.xml.ref
187 187 
        </plotObservation>
188 188 
    </plotObservations>
189 189 
    <plots>
190 
        <plot id="0"><plotUniqueIdentifier>c2000-1</plotUniqueIdentifier></plot>
191 
        <plot id="1"><plotUniqueIdentifier>1</plotUniqueIdentifier></plot>
192 
        <plot id="2"><plotUniqueIdentifier>c2000-1</plotUniqueIdentifier></plot>
193 
        <plot id="3"><plotUniqueIdentifier>1</plotUniqueIdentifier></plot>
190 
        <plot id="0"><plotName>c2000-1</plotName></plot>
191 
        <plot id="1"><plotName>1</plotName></plot>
192 
        <plot id="2"><plotName>c2000-1</plotName></plot>
193 
        <plot id="3"><plotName>1</plotName></plot>
194 194 
    </plots>
195 195 
    <individualOrganismObservations id="1">
196 196 
        <individualOrganismObservation>
inputs/SALVIAS/maps/VegX.plots.csv
4 4 
AccessCode,,
5 5 
project_id,/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,
6 6 
PrimOwnerID,,
7 
SiteCode,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
7 
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)
8 8 
SiteName,,
9 9 
new_world,,
10 10 
MajorGeo,/*UniqueIdentifierID->/*s/plot/location[placeType=continent]/placeName,
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 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."
4 
PlotCode,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"Brad: Same as plotCode, above"
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,
7 7 
OrigRecordID,,
8 
Line,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,
8 
Line,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,
9 9 
Ind,/simpleUserdefined[name=authorPlantCode]/value,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
10 10 
ind_id,,Brad: OMIT
11 11 
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."
inputs/SALVIAS/maps/VegX.plots.full.csv
37 37 
PlotMethod,/simpleUserdefined[name=method]/*ID/method/name,
38 38 
Precip,/simpleUserdefined[name=precipitation]/value,
39 39 
Temp,/temperature,
40 
SiteCode,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
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 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."
42 42 
AccessCode,,
43 43 
ElevSource,,
inputs/SALVIAS/maps/VegX.organisms.full.csv
18 18 
SourceVoucher,/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/voucher/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
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 
PlotCode,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"Brad: Same as plotCode, above"
21 
PlotCode,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,"Brad: Same as plotCode, above"
22 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."
23 
Line,/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,
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
26 26 
x_position,/relativePlotPosition/relativeX,"Brad: Correct for VegBank. I'm not so sure for VegX. Let's ask Nick about this. These are important, fundamental values of many tree plots, and should be accommodated within VegX."
mappings/VegX-VegBIEN.plots.csv
21 21 
->/*s/communityDetermination[*ID]/*s/communityConcept/name,/commclass/commdetermination/*_id/commconcept/commdescription,
22 22 
/obsEndDate,/obsenddate,
23 23 
/obsStartDate,/obsstartdate,
24 
/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/parent_id/locationevent/authorlocationcode,
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 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,
27 27 
/simpleUserdefined[name=precipitation]/value,/precipitation,
......
45 45 
/temperature,/temperature,
46 46 
/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/waterdepth/max/_units:[default=m,to=m,to=]/value",
47 47 
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/waterdepth/min/_units:[default=m,to=m,to=]/value",
48 
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,
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 50 
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,
mappings/VegX-VegBIEN.organisms.csv
21 21 
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,/*_id/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
22 22 
/*ID->/*s/plotObservation/obsEndDate,/*_id/locationevent/obsenddate,
23 23 
/*ID->/*s/plotObservation/obsStartDate,/*_id/locationevent/obsstartdate,
24 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent/parent_id/locationevent/authorlocationcode,
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 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,
27 27 
/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value,/*_id/locationevent/precipitation,
......
45 45 
/*ID->/*s/plotObservation/temperature,/*_id/locationevent/temperature,
46 46 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,"/*_id/locationevent/waterdepth/max/_units:[default=m,to=m,to=]/value",
47 47 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,"/*_id/locationevent/waterdepth/min/_units:[default=m,to=m,to=]/value",
48 
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,
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 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,
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",
mappings/VegX.self.plots.csv
41 41 
/obsStartDate,/obsStartDate
42 42 
/partyWithRole/*ID->/parties/party/organizationName,/partyWithRole/*ID->/parties/party/organizationName
43 43 
/simpleUserdefined[name=method]/*ID/method/name,/simpleUserdefined[name=method]/*ID/method/name
44 
/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier
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 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
47 47 
/simpleUserdefined[name=precipitation]/value,/simpleUserdefined[name=precipitation]/value
48 48 
/temperature,/temperature
49 
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier
49 
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName
50 50 
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value,:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=sourceAccessionCode]/value
mappings/VegX.self.organisms.csv
81 81 
/*ID->/*s/plotObservation/obsStartDate,/*ID->/*s/plotObservation/obsStartDate
82 82 
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName
83 83 
/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name
84 
/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*ID->/*s/plotObservation/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier
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 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
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 
/*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
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 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
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
mappings/for_review/VegX-VegBIEN.plots.csv
21 21 
//*s/communityDetermination/*s/communityConcept/name,//commconcept/commdescription,
22 22 
/obsEndDate,/obsenddate,
23 23 
/obsStartDate,/obsstartdate,
24 
//plot/plotUniqueIdentifier,//locationevent/authorlocationcode,
24 
//plot/plotName,//locationevent/authorlocationcode,
25 25 
//party/organizationName,//party/organizationname/_alt/1,
26 26 
//plotObservation/simpleUserdefined[name=sourceAccessionCode]/value,//locationevent/sourceaccessioncode,
27 27 
/simpleUserdefined[name=precipitation]/value,/precipitation,
......
45 45 
/temperature,/temperature,
46 46 
//geospatial/maximumDepthInMeters,//waterdepth/max/_units/value,
47 47 
//geospatial/minimumDepthInMeters,//waterdepth/min/_units/value,
48 
//plot/plotUniqueIdentifier,/authorlocationcode,
48 
//plot/plotName,/authorlocationcode,
49 49 
//party/organizationName,//party/organizationname/_alt/1,
50 50 
/simpleUserdefined[name=sourceAccessionCode]/value,/sourceaccessioncode,
mappings/for_review/VegX-VegBIEN.organisms.csv
21 21 
//*s/communityDetermination/*s/communityConcept/name,//commconcept/commdescription,
22 22 
//plotObservation/obsEndDate,//locationevent/obsenddate,
23 23 
//plotObservation/obsStartDate,//locationevent/obsstartdate,
24 
//plot/plotUniqueIdentifier,//locationevent/authorlocationcode,
24 
//plot/plotName,//locationevent/authorlocationcode,
25 25 
//party/organizationName,//party/organizationname/_alt/1,
26 26 
//plotObservation/simpleUserdefined[name=sourceAccessionCode]/value,//locationevent/sourceaccessioncode,
27 27 
//plotObservation/simpleUserdefined[name=precipitation]/value,//locationevent/precipitation,
......
45 45 
//plotObservation/temperature,//locationevent/temperature,
46 46 
//geospatial/maximumDepthInMeters,//waterdepth/max/_units/value,
47 47 
//geospatial/minimumDepthInMeters,//waterdepth/min/_units/value,
48 
//plot/plotUniqueIdentifier,//locationevent/authorlocationcode,
48 
//plot/plotName,//locationevent/authorlocationcode,
49 49 
//party/organizationName,//party/organizationname/_alt/1,
50 50 
//plotObservation/simpleUserdefined[name=sourceAccessionCode]/value,//locationevent/sourceaccessioncode,
51 51 
//taxonNameUsageConcept/voucher,"/_if/{then/specimenreplicate,else/voucher/*_id/specimenreplicate}//catalognumber_dwc",

Also available in: Unified diff