Project

General

Profile

« Previous | Next » 

Revision 4467

inputs/SALVIAS/plotMetadata/map.csv: Remapped project_id to project.sourceaccessioncode

View differences:

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