Revision 4467
Added by Aaron Marcuse-Kubitza over 12 years ago
inputs/SALVIAS/plotMetadata/map.csv | ||
---|---|---|
2 | 2 |
PlotID,locationID,"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 |
project_id,projectName,
|
|
5 |
project_id,projectID,
|
|
6 | 6 |
PrimOwnerID,, |
7 | 7 |
SiteCode,plotName,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
8 | 8 |
SiteName,, |
inputs/SALVIAS/plotMetadata/map.full.csv | ||
---|---|---|
28 | 28 |
SiteCode,plotName,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
29 | 29 |
soil_K,"potassium/_units:[default=""%"",to=]/value", |
30 | 30 |
Precip,precipitation, |
31 |
project_id,projectName,
|
|
31 |
project_id,projectID,
|
|
32 | 32 |
PlotMethod,samplingProtocol, |
33 | 33 |
sand_percent,"sand/_units:[default=""%"",to=]/value", |
34 | 34 |
silt_percent,"silt/_units:[default=""%"",to=]/value", |
inputs/SALVIAS/plotMetadata/VegBIEN.csv | ||
---|---|---|
18 | 18 |
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
19 | 19 |
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", |
20 | 20 |
PlotMethod,/location/locationevent/*_id/method/name, |
21 |
project_id,/location/locationevent/*_id/project/projectname,
|
|
21 |
project_id,/location/locationevent/*_id/project/sourceaccessioncode,
|
|
22 | 22 |
SiteCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
23 | 23 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata." |
24 | 24 |
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
inputs/SALVIAS/plotMetadata/test.xml.ref | ||
---|---|---|
144 | 144 |
</locationdetermination> |
145 | 145 |
<locationevent> |
146 | 146 |
<method_id><method><name>$PlotMethod</name></method></method_id> |
147 |
<project_id><project><projectname>$project_id</projectname></project></project_id>
|
|
147 |
<project_id><project><sourceaccessioncode>$project_id</sourceaccessioncode></project></project_id>
|
|
148 | 148 |
<commclass> |
149 | 149 |
<commdetermination> |
150 | 150 |
<commconcept_id> |
... | ... | |
280 | 280 |
<slopegradient>$slope_gradient</slopegradient> |
281 | 281 |
</location> |
282 | 282 |
</VegBIEN> |
283 |
Inserted 23 new rows into database |
|
283 |
Inserted 22 new rows into database |
Also available in: Unified diff
inputs/SALVIAS/plotMetadata/map.csv: Remapped project_id to project.sourceaccessioncode