Project

General

Profile

« Previous | Next » 

Revision 7014

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/NVS/Plot/map.csv: Corrected Plot ID mapping to go to subplotID instead of locationID, because each subplot gets its own ID in this field

View differences:

inputs/NVS/Plot/map.csv
12 12 
Physiography,landform,,
13 13 
Placement,*Placement,,
14 14 
Permanence,*Permanence,,
15 
Plot ID,locationID,,
15 
Plot ID,subplotID,,
inputs/NVS/Plot/VegBIEN.csv
1 1 
NVS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
Plot ID,"/location/_if[@name=""if subplot""]/cond/_exists",
2 3 
Sub Plot,"/location/_if[@name=""if subplot""]/cond/_exists",
3 4 
Plot,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
4 
Plot ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
5 
Plot ID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
6 5 
Plot,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
7 
Plot ID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
8 6 
Area,/location/area_m2,Area Units is always m
9 7 
Sub Plot,/location/authorlocationcode,
10 8 
Altitude,/location/elevation_m/_alt/1,Altitude Units is always m
11 9 
Physiography,/location/landform,
10 
Plot ID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
12 11 
Sub Plot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
12 
Plot ID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/1",
13 13 
Sub Plot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/2",
14 14 
Plot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
15 
Plot ID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/1",
15 16 
Sub Plot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/2",
16 
Plot ID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then",
17 17 
Plot,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
18 
Plot ID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
19 18 
Slope,/location/slopeaspect_deg/_alt/1/_compass/value,
20 
Plot ID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
19 
Plot ID,/location/sourceaccessioncode,
21 20 
Sub Plot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
22 
Plot ID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
23 21 
Sub Plot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
24 22 
Altitude Units,,** No join mapping for *Altitude Units **
25 23 
Area Units,,** No join mapping for *Area Units **
inputs/NVS/Plot/test.xml.ref
7 7 
                <next>parent_id</next>
8 8 
                <path>
9 9 
                    <location>
10 
                        <parent_id>
11 
                            <location>
12 
                                <authorlocationcode>$Plot</authorlocationcode>
13 
                                <sourceaccessioncode>$Plot ID</sourceaccessioncode>
14 
                            </location>
15 
                        </parent_id>
10 
                        <parent_id><location><authorlocationcode>$Plot</authorlocationcode></location></parent_id>
16 11 
                        <area_m2>$Area</area_m2>
17 12 
                        <authorlocationcode>$Sub Plot</authorlocationcode>
18 13 
                        <elevation_m>$Altitude</elevation_m>
19 14 
                        <landform>$Physiography</landform>
20 15 
                        <slopeaspect_deg><_compass><value>$Slope</value></_compass></slopeaspect_deg>
21 
                        <sourceaccessioncode>
22 
                            <_join>
23 
                                <1>$Plot ID</1>
24 
                                <2>$Sub Plot</2>
25 
                            </_join>
26 
                        </sourceaccessioncode>
16 
                        <sourceaccessioncode>$Plot ID</sourceaccessioncode>
27 17 
                    </location>
28 18 
                </path>
29 19 
            </_simplifyPath>
30 20 
        </path>
31 21 
    </_setDefault>
32 22 
</VegBIEN>
33 
Inserted 3 new rows into database
23 
Inserted 5 new rows into database

Also available in: Unified diff