Revision 3999
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/Madidi/test/import.plots.xml.ref | ||
|---|---|---|
| 2 | 2 |
<VegBIEN> |
| 3 | 3 |
<location id="-1"> |
| 4 | 4 |
<area>$Area</area> |
| 5 |
<authorlocationcode>$Inventory name</authorlocationcode>
|
|
| 5 |
<authorlocationcode><_alt><1>$Inventory name</1></_alt></authorlocationcode>
|
|
| 6 | 6 |
<elevation> |
| 7 | 7 |
<_alt> |
| 8 | 8 |
<1> |
| ... | ... | |
| 118 | 118 |
<sourceaccessioncode>$Expedition number</sourceaccessioncode> |
| 119 | 119 |
</project> |
| 120 | 120 |
</project_id> |
| 121 |
<authoreventcode>$Inventory name</authoreventcode> |
|
| 122 | 121 |
<commclass> |
| 123 | 122 |
<commdetermination> |
| 124 | 123 |
<commconcept_id> |
| inputs/Madidi/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 1 | 1 |
Madidi,VegBIEN:,Comments |
| 2 | 2 |
Area,/location/area, |
| 3 |
Inventory name,/location/authorlocationcode, |
|
| 3 |
Inventory name,/location/authorlocationcode/_alt/1,
|
|
| 4 | 4 |
Altitude,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
| 5 | 5 |
Minimum altitude,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| 6 | 6 |
Minimum altitude,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| ... | ... | |
| 12 | 12 |
Longitude (DMS),"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/2", |
| 13 | 13 |
Expedition name,/location/locationevent/*_id/project/projectname,Consistent (globally unique) between PPM and PT data |
| 14 | 14 |
Expedition number,/location/locationevent/*_id/project/sourceaccessioncode,Consistent (globally unique) between PPM and PT data |
| 15 |
Inventory name,/location/locationevent/authoreventcode, |
|
| 16 | 15 |
Vegetation type,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 17 | 16 |
Locality description,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,Often begins with the text in Vegetation type |
| 18 | 17 |
First evaluation,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value, |
| inputs/CVS/test/import.organisms.xml.ref | ||
|---|---|---|
| 1 | 1 |
Put template: |
| 2 | 2 |
<VegBIEN> |
| 3 | 3 |
<location id="-1"> |
| 4 |
<authorlocationcode>$authorObsCode</authorlocationcode>
|
|
| 4 |
<authorlocationcode><_alt><2>$authorObsCode</2></_alt></authorlocationcode>
|
|
| 5 | 5 |
<locationdetermination> |
| 6 | 6 |
<coordsaccuracy><_noCV><value><_alt><1>$locationAccuracy-m</1></_alt></value></_noCV></coordsaccuracy> |
| 7 | 7 |
<latitude> |
| inputs/CVS/maps/VegCSV.organisms.csv | ||
|---|---|---|
| 1 | 1 |
CVS,VegCSV[DwC],Comments |
| 2 |
authorObsCode,plotName,
|
|
| 2 |
authorObsCode,fieldNumber,
|
|
| 3 | 3 |
obsStartDate,plotEventStartDate/_*/date, |
| 4 | 4 |
realLatitude,decimalLatitude/_alt/1, |
| 5 | 5 |
realLongitude,decimalLongitude/_alt/1, |
| inputs/CVS/maps/VegCSV.organisms.full.csv | ||
|---|---|---|
| 6 | 6 |
publicLatitude,decimalLatitude/_alt/2, |
| 7 | 7 |
realLongitude,decimalLongitude/_alt/1, |
| 8 | 8 |
publicLongitude,decimalLongitude/_alt/2, |
| 9 |
authorObsCode,fieldNumber, |
|
| 9 | 10 |
obsStartDate,plotEventStartDate/_*/date, |
| 10 |
authorObsCode,plotName, |
|
| 11 | 11 |
currentTaxonName sec Weakley 2006,scientificName, |
| 12 | 12 |
state,stateProvince, |
| 13 | 13 |
confidentialityStatus,, |
| inputs/CVS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
CVS,VegBIEN:,Comments |
| 2 |
authorObsCode,/location/authorlocationcode, |
|
| 2 |
authorObsCode,/location/authorlocationcode/_alt/2,
|
|
| 3 | 3 |
locationAccuracy-m,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1, |
| 4 | 4 |
realLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/1", |
| 5 | 5 |
publicLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/2", |
| inputs/SALVIAS-CSV/test/import.plots.xml.ref | ||
|---|---|---|
| 2 | 2 |
<VegBIEN> |
| 3 | 3 |
<location id="-1"> |
| 4 | 4 |
<area>$plot_area_ha</area> |
| 5 |
<authorlocationcode>$plot_code</authorlocationcode>
|
|
| 5 |
<authorlocationcode><_alt><1>$plot_code</1></_alt></authorlocationcode>
|
|
| 6 | 6 |
<elevation> |
| 7 | 7 |
<_alt> |
| 8 | 8 |
<1> |
| ... | ... | |
| 152 | 152 |
<locationevent> |
| 153 | 153 |
<method_id><method><name>$plot_methodology</name></method></method_id> |
| 154 | 154 |
<project_id><project><projectname>$project</projectname></project></project_id> |
| 155 |
<authoreventcode>$plot_code</authoreventcode> |
|
| 156 | 155 |
<commclass> |
| 157 | 156 |
<commdetermination> |
| 158 | 157 |
<commconcept_id> |
| inputs/SALVIAS-CSV/test/import.organisms.xml.ref | ||
|---|---|---|
| 1 | 1 |
Put template: |
| 2 | 2 |
<VegBIEN> |
| 3 | 3 |
<location id="-1"> |
| 4 |
<authorlocationcode>$subplot</authorlocationcode>
|
|
| 4 |
<authorlocationcode><_alt><1>$subplot</1></_alt></authorlocationcode>
|
|
| 5 | 5 |
<locationevent> |
| 6 |
<authoreventcode>$subplot</authoreventcode> |
|
| 7 | 6 |
<obsstartdate><_date><date><_dateRangeStart><value><_date><year>$census_date</year></_date></value></_dateRangeStart></date></_date></obsstartdate> |
| 8 | 7 |
<taxonoccurrence> |
| 9 | 8 |
<aggregateoccurrence> |
| inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS-CSV,VegBIEN:,Comments |
| 2 | 2 |
plot_area_ha,/location/area,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed" |
| 3 |
plot_code,/location/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
|
| 3 |
plot_code,/location/authorlocationcode/_alt/1,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| 4 | 4 |
elev_m,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick. |
| 5 | 5 |
elev_max_m,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 6 | 6 |
elev_min_m,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| ... | ... | |
| 15 | 15 |
major_geo,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
| 16 | 16 |
plot_methodology,/location/locationevent/*_id/method/name, |
| 17 | 17 |
project,/location/locationevent/*_id/project/projectname, |
| 18 |
plot_code,/location/locationevent/authoreventcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
|
| 19 | 18 |
holdridge_life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 20 | 19 |
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 21 | 20 |
date_finish,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_*/date, |
| inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS-CSV,VegBIEN:,Comments |
| 2 |
subplot,/location/authorlocationcode, |
|
| 3 |
subplot,/location/locationevent/authoreventcode, |
|
| 2 |
subplot,/location/authorlocationcode/_alt/1, |
|
| 4 | 3 |
census_date,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_date/year, |
| 5 | 4 |
no_of_individuals,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this." |
| 6 | 5 |
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| inputs/SALVIAS/test/import.plots.xml.ref | ||
|---|---|---|
| 2 | 2 |
<VegBIEN> |
| 3 | 3 |
<location id="-1"> |
| 4 | 4 |
<area>$plot_area_ha</area> |
| 5 |
<authorlocationcode>$SiteCode</authorlocationcode>
|
|
| 5 |
<authorlocationcode><_alt><1>$SiteCode</1></_alt></authorlocationcode>
|
|
| 6 | 6 |
<elevation> |
| 7 | 7 |
<_alt> |
| 8 | 8 |
<1> |
| ... | ... | |
| 152 | 152 |
<locationevent> |
| 153 | 153 |
<method_id><method><name>$PlotMethod</name></method></method_id> |
| 154 | 154 |
<project_id><project><projectname>$project_id</projectname></project></project_id> |
| 155 |
<authoreventcode>$SiteCode</authoreventcode> |
|
| 156 | 155 |
<commclass> |
| 157 | 156 |
<commdetermination> |
| 158 | 157 |
<commconcept_id> |
| inputs/SALVIAS/test/import.organisms.xml.ref | ||
|---|---|---|
| 1 | 1 |
Put template: |
| 2 | 2 |
<VegBIEN> |
| 3 | 3 |
<location id="-1"> |
| 4 |
<authorlocationcode>$Line</authorlocationcode>
|
|
| 4 |
<authorlocationcode><_alt><1>$Line</1></_alt></authorlocationcode>
|
|
| 5 | 5 |
<locationevent> |
| 6 |
<authoreventcode>$Line</authoreventcode> |
|
| 7 | 6 |
<taxonoccurrence> |
| 8 | 7 |
<aggregateoccurrence> |
| 9 | 8 |
<collectiondate><_date><date><_dateRangeStart><value><_date><date>$census_date</date></_date></value></_dateRangeStart></date></_date></collectiondate> |
| inputs/SALVIAS/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS,VegBIEN:,Comments |
| 2 | 2 |
plot_area_ha,/location/area,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed" |
| 3 |
SiteCode,/location/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
|
| 3 |
SiteCode,/location/authorlocationcode/_alt/1,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| 4 | 4 |
Elev,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick. |
| 5 | 5 |
elev_max_m,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 6 | 6 |
elev_min_m,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| ... | ... | |
| 15 | 15 |
MajorGeo,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
| 16 | 16 |
PlotMethod,/location/locationevent/*_id/method/name, |
| 17 | 17 |
project_id,/location/locationevent/*_id/project/projectname, |
| 18 |
SiteCode,/location/locationevent/authoreventcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
|
| 19 | 18 |
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 20 | 19 |
life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 21 | 20 |
date_finish,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_*/date, |
| inputs/SALVIAS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS,VegBIEN:,Comments |
| 2 |
Line,/location/authorlocationcode, |
|
| 3 |
Line,/location/locationevent/authoreventcode, |
|
| 2 |
Line,/location/authorlocationcode/_alt/1, |
|
| 4 | 3 |
census_date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_*/date, |
| 5 | 4 |
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this." |
| 6 | 5 |
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| mappings/VegCSV.self.plots.csv | ||
|---|---|---|
| 32 | 32 |
eventDate,eventDate |
| 33 | 33 |
family,family |
| 34 | 34 |
fieldNotes,fieldNotes |
| 35 |
fieldNumber,fieldNumber |
|
| 35 | 36 |
footprintWKT,footprintWKT |
| 36 | 37 |
genus,genus |
| 37 | 38 |
growthForm,growthForm |
| mappings/VegCSV.self.organisms.csv | ||
|---|---|---|
| 32 | 32 |
eventDate,eventDate |
| 33 | 33 |
family,family |
| 34 | 34 |
fieldNotes,fieldNotes |
| 35 |
fieldNumber,fieldNumber |
|
| 35 | 36 |
footprintWKT,footprintWKT |
| 36 | 37 |
genus,genus |
| 37 | 38 |
growthForm,growthForm |
| mappings/VegCSV-VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
VegCSV[DwC],VegBIEN:,Comments |
| 2 | 2 |
plotArea,/location/area, |
| 3 |
plotName,/location/authorlocationcode, |
|
| 3 |
plotName,/location/authorlocationcode/_alt/1, |
|
| 4 |
fieldNumber,/location/authorlocationcode/_alt/2, |
|
| 4 | 5 |
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
| 5 | 6 |
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 6 | 7 |
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| ... | ... | |
| 19 | 20 |
samplingProtocol,/location/locationevent/*_id/method/name, |
| 20 | 21 |
projectName,/location/locationevent/*_id/project/projectname, |
| 21 | 22 |
projectID,/location/locationevent/*_id/project/sourceaccessioncode, |
| 22 |
plotName,/location/locationevent/authoreventcode,
|
|
| 23 |
fieldNumber,/location/locationevent/authoreventcode,
|
|
| 23 | 24 |
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 24 | 25 |
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 25 | 26 |
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value, |
| mappings/VegCSV.self.specimens.csv | ||
|---|---|---|
| 32 | 32 |
eventDate,eventDate |
| 33 | 33 |
family,family |
| 34 | 34 |
fieldNotes,fieldNotes |
| 35 |
fieldNumber,fieldNumber |
|
| 35 | 36 |
footprintWKT,footprintWKT |
| 36 | 37 |
genus,genus |
| 37 | 38 |
growthForm,growthForm |
| mappings/for_review/VegCSV-VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
VegCSV[DwC],VegBIEN:,Comments |
| 2 | 2 |
plotArea,//location/area, |
| 3 | 3 |
plotName,//location/authorlocationcode, |
| 4 |
fieldNumber,//location/authorlocationcode, |
|
| 4 | 5 |
verbatimElevation,//location/elevation, |
| 5 | 6 |
maximumElevationInMeters,//location/elevation, |
| 6 | 7 |
minimumElevationInMeters,//location/elevation, |
| ... | ... | |
| 19 | 20 |
samplingProtocol,//method/name, |
| 20 | 21 |
projectName,//project/projectname, |
| 21 | 22 |
projectID,//project/sourceaccessioncode, |
| 22 |
plotName,//locationevent/authoreventcode,
|
|
| 23 |
fieldNumber,//locationevent/authoreventcode,
|
|
| 23 | 24 |
communityID,//*/commname, |
| 24 | 25 |
communityName,//commconcept/commdescription, |
| 25 | 26 |
plotEventEndDate,//locationevent/obsenddate/_*/date, |
| mappings/VegCSV.self.stems.csv | ||
|---|---|---|
| 32 | 32 |
eventDate,eventDate |
| 33 | 33 |
family,family |
| 34 | 34 |
fieldNotes,fieldNotes |
| 35 |
fieldNumber,fieldNumber |
|
| 35 | 36 |
footprintWKT,footprintWKT |
| 36 | 37 |
genus,genus |
| 37 | 38 |
growthForm,growthForm |
Also available in: Unified diff
mappings/VegCSV-VegBIEN.specimens.csv: plotName: Removed authoreventcode mapping because plotName relates to the plot, not the plot event. (The locationevent is scoped by the location when the authoreventcode is not specified, so duplicate elimination will still occur correctly.) Instead map only authoreventcode-related fields (currently CVS's authorObsCode) to authoreventcode, via DwC's (confusingly-named) fieldNumber ("An identifier given to the event in the field").