Revision 1063
Added by Aaron Marcuse-Kubitza almost 13 years ago
| inputs/SALVIAS/test/VegBIEN.plots.xml.ref | ||
|---|---|---|
| 28 | 28 |
</locationdetermination> |
| 29 | 29 |
</location> |
| 30 | 30 |
</location_id> |
| 31 |
<plotmethod_id><plotmethod><name>0.1 ha transect, stems >= 2.5 cm dbh</name></plotmethod></plotmethod_id> |
|
| 31 | 32 |
<project_id><project><projectname>1</projectname></project></project_id> |
| 32 | 33 |
<commclass> |
| 33 | 34 |
<commdetermination> |
| ... | ... | |
| 48 | 49 |
</userdefined_id> |
| 49 | 50 |
<definedvalue>2500.0</definedvalue> |
| 50 | 51 |
</definedvalue> |
| 51 |
<methodnarrative>0.1 ha transect, stems >= 2.5 cm dbh</methodnarrative> |
|
| 52 | 52 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
| 53 | 53 |
<authoreventcode>1</authoreventcode> |
| 54 | 54 |
</locationevent> |
| ... | ... | |
| 80 | 80 |
</locationdetermination> |
| 81 | 81 |
</location> |
| 82 | 82 |
</location_id> |
| 83 |
<plotmethod_id><plotmethod><name>0.1 ha transect, stems >= 2.5 cm dbh</name></plotmethod></plotmethod_id> |
|
| 83 | 84 |
<project_id><project><projectname>1</projectname></project></project_id> |
| 84 | 85 |
<commclass> |
| 85 | 86 |
<commdetermination> |
| ... | ... | |
| 109 | 110 |
</userdefined_id> |
| 110 | 111 |
<definedvalue>7.4</definedvalue> |
| 111 | 112 |
</definedvalue> |
| 112 |
<methodnarrative>0.1 ha transect, stems >= 2.5 cm dbh</methodnarrative> |
|
| 113 | 113 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
| 114 | 114 |
<authoreventcode>2</authoreventcode> |
| 115 | 115 |
</locationevent> |
| inputs/SALVIAS/test/import.plots.out.ref | ||
|---|---|---|
| 1 |
Inserted 31 new rows into database |
|
| 1 |
Inserted 33 new rows into database |
|
| inputs/SALVIAS/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 13 | 13 |
slope_gradient,/*_id/location/slopegradient, |
| 14 | 14 |
elev_max_m,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| 15 | 15 |
elev_min_m,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
| 16 |
PlotMethod,/*_id/plotmethod/name, |
|
| 16 | 17 |
project_id,/*_id/project/projectname, |
| 17 | 18 |
life_zone_code,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 18 | 19 |
life_zone,/commclass/commdetermination/*_id/commconcept/commdescription, |
| 19 | 20 |
Precip,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]]:[@fkey=tableRecord_ID]/definedvalue", |
| 20 | 21 |
Temp,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=temperatureC]]:[@fkey=tableRecord_ID]/definedvalue", |
| 21 |
PlotMethod,/methodnarrative, |
|
| 22 | 22 |
date_finish,/obsenddate/_*/date, |
| 23 | 23 |
date_start,/obsstartdate/_*/date, |
| 24 | 24 |
soil_acidity,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilAcidity]]:[@fkey=tableRecord_ID]/definedvalue", |
| inputs/SALVIAS-CSV/test/VegBIEN.plots.xml.ref | ||
|---|---|---|
| 37 | 37 |
<locationnarrative>pre-Holocene; clay</locationnarrative> |
| 38 | 38 |
</location> |
| 39 | 39 |
</location_id> |
| 40 |
<plotmethod_id><plotmethod><name>1 ha, stems >= 10 cm dbh</name></plotmethod></plotmethod_id> |
|
| 40 | 41 |
<project_id><project><projectname>RAINFOR - 1 ha Peru</projectname></project></project_id> |
| 41 |
<methodnarrative>1 ha, stems >= 10 cm dbh</methodnarrative> |
|
| 42 | 42 |
<obsstartdate>1990-11-16</obsstartdate> |
| 43 | 43 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
| 44 | 44 |
<authoreventcode>26102</authoreventcode> |
| ... | ... | |
| 80 | 80 |
<locationnarrative>pre-Holocene; white and brown sand</locationnarrative> |
| 81 | 81 |
</location> |
| 82 | 82 |
</location_id> |
| 83 |
<plotmethod_id><plotmethod><name>1 ha, stems >= 10 cm dbh</name></plotmethod></plotmethod_id> |
|
| 83 | 84 |
<project_id><project><projectname>RAINFOR - 1 ha Peru</projectname></project></project_id> |
| 84 |
<methodnarrative>1 ha, stems >= 10 cm dbh</methodnarrative> |
|
| 85 | 85 |
<obsstartdate>1990-11-16</obsstartdate> |
| 86 | 86 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
| 87 | 87 |
<authoreventcode>26103</authoreventcode> |
| inputs/SALVIAS-CSV/test/import.plots.out.ref | ||
|---|---|---|
| 1 |
Inserted 18 new rows into database |
|
| 1 |
Inserted 20 new rows into database |
|
| inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 13 | 13 |
slope_gradient,/*_id/location/slopegradient, |
| 14 | 14 |
elev_max_m,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| 15 | 15 |
elev_min_m,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
| 16 |
plot_methodology,/*_id/plotmethod/name, |
|
| 16 | 17 |
project,/*_id/project/projectname, |
| 17 | 18 |
holdridge_life_zone,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 18 | 19 |
life_zone_code,/commclass/commdetermination/*_id/commconcept/commdescription, |
| 19 | 20 |
precip_mm,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]]:[@fkey=tableRecord_ID]/definedvalue", |
| 20 | 21 |
temp_c,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=temperatureC]]:[@fkey=tableRecord_ID]/definedvalue", |
| 21 |
plot_methodology,/methodnarrative, |
|
| 22 | 22 |
date_finish,/obsenddate/_*/date, |
| 23 | 23 |
date_start,/obsstartdate/_*/date, |
| 24 | 24 |
soil_acidity,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilAcidity]]:[@fkey=tableRecord_ID]/definedvalue", |
| mappings/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 16 | 16 |
/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/location/slopegradient, |
| 17 | 17 |
/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| 18 | 18 |
/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
| 19 |
/simpleUserdefined[name=plotMethodology]/value,/*_id/plotmethod/name, |
|
| 19 | 20 |
/*ID->/*s/project/title,/*_id/project/projectname, |
| 20 | 21 |
->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 21 | 22 |
->/*s/communityDetermination[*ID]/*s/communityConcept/name,/commclass/commdetermination/*_id/commconcept/commdescription, |
| 22 | 23 |
/simpleUserdefined[name=precipMm]/value,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]]:[@fkey=tableRecord_ID]/definedvalue", |
| 23 | 24 |
/temperature,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=temperatureC]]:[@fkey=tableRecord_ID]/definedvalue", |
| 24 |
/simpleUserdefined[name=plotMethodology]/value,/methodnarrative, |
|
| 25 | 25 |
/obsEndDate,/obsenddate, |
| 26 | 26 |
/obsEndDate/_*/date,/obsenddate/_*/date, |
| 27 | 27 |
/obsStartDate,/obsstartdate, |
| mappings/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 16 | 16 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/locationevent/*_id/location/slopegradient, |
| 17 | 17 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| 18 | 18 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
| 19 |
/*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value,/*_id/locationevent/*_id/plotmethod/name, |
|
| 19 | 20 |
/*ID->/*s/plotObservation/*ID->/*s/project/title,/*_id/locationevent/*_id/project/projectname, |
| 20 | 21 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 21 | 22 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,/*_id/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 22 | 23 |
/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value,"/*_id/locationevent/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]]:[@fkey=tableRecord_ID]/definedvalue", |
| 23 | 24 |
/*ID->/*s/plotObservation/temperature,"/*_id/locationevent/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=temperatureC]]:[@fkey=tableRecord_ID]/definedvalue", |
| 24 |
/*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value,/*_id/locationevent/methodnarrative, |
|
| 25 | 25 |
/*ID->/*s/plotObservation/obsEndDate,/*_id/locationevent/obsenddate, |
| 26 | 26 |
/*ID->/*s/plotObservation/obsEndDate/_*/date,/*_id/locationevent/obsenddate/_*/date, |
| 27 | 27 |
/*ID->/*s/plotObservation/obsStartDate,/*_id/locationevent/obsstartdate, |
| mappings/for_review/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 16 | 16 |
//plot/slopeGradient,//location/slopegradient, |
| 17 | 17 |
//geospatial/maximumElevationInMeters,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| 18 | 18 |
//geospatial/minimumElevationInMeters,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
| 19 |
/simpleUserdefined[name=plotMethodology]/value,//plotmethod/name, |
|
| 19 | 20 |
//project/title,//project/projectname, |
| 20 | 21 |
//*s/communityDetermination/*s/communityConcept/commonName,//*/commname, |
| 21 | 22 |
//*s/communityDetermination/*s/communityConcept/name,//commconcept/commdescription, |
| 22 | 23 |
/simpleUserdefined[name=precipMm]/value,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]]/definedvalue", |
| 23 | 24 |
/temperature,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=temperatureC]]/definedvalue", |
| 24 |
/simpleUserdefined[name=plotMethodology]/value,/methodnarrative, |
|
| 25 | 25 |
/obsEndDate,/obsenddate, |
| 26 | 26 |
/obsEndDate/_*/date,/obsenddate/_*/date, |
| 27 | 27 |
/obsStartDate,/obsstartdate, |
| mappings/for_review/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 16 | 16 |
//plot/slopeGradient,//location/slopegradient, |
| 17 | 17 |
//geospatial/maximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| 18 | 18 |
//geospatial/minimumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
| 19 |
//plotObservation/simpleUserdefined[name=plotMethodology]/value,//plotmethod/name, |
|
| 19 | 20 |
//project/title,//project/projectname, |
| 20 | 21 |
//*s/communityDetermination/*s/communityConcept/commonName,//*/commname, |
| 21 | 22 |
//*s/communityDetermination/*s/communityConcept/name,//commconcept/commdescription, |
| 22 | 23 |
//plotObservation/simpleUserdefined[name=precipMm]/value,"//locationevent/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]]/definedvalue", |
| 23 | 24 |
//plotObservation/temperature,"//locationevent/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=temperatureC]]/definedvalue", |
| 24 |
//plotObservation/simpleUserdefined[name=plotMethodology]/value,//locationevent/methodnarrative, |
|
| 25 | 25 |
//plotObservation/obsEndDate,//locationevent/obsenddate, |
| 26 | 26 |
//plotObservation/obsEndDate/_*/date,//locationevent/obsenddate/_*/date, |
| 27 | 27 |
//plotObservation/obsStartDate,//locationevent/obsstartdate, |
Also available in: Unified diff
VegX-VegBIEN mapping: Mapped locationevent.methodnarrative to new plotmethod table