Project

General

Profile

« Previous | Next » 

Revision 4514

Added by Aaron Marcuse-Kubitza over 12 years ago

inputs/VegBank/: Added plot_/

View differences:

inputs/VegBank/import_order.txt
1 
plot_
inputs/VegBank/plot_/src.csv
1 
VegBank[Veg+],Veg+,Comments
2 
plot_id,,
3 
authorplotcode,,
4 
reference_id,,
5 
parent_id,,
6 
reallatitude,,
7 
reallongitude,,
8 
locationaccuracy,,
9 
confidentialitystatus,,
10 
confidentialityreason,,
11 
latitude,,
12 
longitude,,
13 
authore,,
14 
authorn,,
15 
authorzone,,
16 
authordatum,,
17 
authorlocation,,
18 
locationnarrative,,
19 
azimuth,,
20 
dsgpoly,,
21 
shape,,
22 
area,,
23 
standsize,,
24 
placementmethod,,
25 
permanence,,
26 
layoutnarrative,,
27 
elevation,,
28 
elevationaccuracy,,
29 
elevationrange,,
30 
slopeaspect,,
31 
minslopeaspect,,
32 
maxslopeaspect,,
33 
slopegradient,,
34 
minslopegradient,,
35 
maxslopegradient,,
36 
topoposition,,
37 
landform,,
38 
surficialdeposits,,
39 
rocktype,,
40 
stateprovince,,
41 
country,,
42 
submitter_surname,,
43 
submitter_givenname,,
44 
submitter_email,,
45 
notespublic,,
46 
notesmgt,,
47 
revisions,,
48 
dateentered,,
49 
emb_plot,,
50 
plotrationalenarrative,,
51 
accessioncode,,
52 
continent,,
53 
area|country|territory,,
54 
region|state|province,,
55 
county,,
56 
quadrangle,,
57 
Geographic Name,,
58 
row_num,,
inputs/VegBank/plot_/header.csv
1 
plot_id,authorplotcode,reference_id,parent_id,reallatitude,reallongitude,locationaccuracy,confidentialitystatus,confidentialityreason,latitude,longitude,authore,authorn,authorzone,authordatum,authorlocation,locationnarrative,azimuth,dsgpoly,shape,area,standsize,placementmethod,permanence,layoutnarrative,elevation,elevationaccuracy,elevationrange,slopeaspect,minslopeaspect,maxslopeaspect,slopegradient,minslopegradient,maxslopegradient,topoposition,landform,surficialdeposits,rocktype,stateprovince,country,submitter_surname,submitter_givenname,submitter_email,notespublic,notesmgt,revisions,dateentered,emb_plot,plotrationalenarrative,accessioncode,continent,area|country|territory,region|state|province,county,quadrangle,Geographic Name,row_num
inputs/VegBank/plot_/map.csv
1 
VegBank[Veg+],Veg+,Comments
2 
plot_id,plotID,
3 
authorplotcode,plotName,
4 
reference_id,,
5 
parent_id,parentPlotID,
6 
reallatitude,,
7 
reallongitude,,
8 
locationaccuracy,coordinateUncertaintyInMeters,
9 
confidentialitystatus,,
10 
confidentialityreason,,
11 
authore,,
12 
authorn,,
13 
authorzone,,
14 
authordatum,,
15 
authorlocation,,
16 
azimuth,,
17 
dsgpoly,,
18 
shape,footprintWKT,
19 
area,plotArea,
20 
standsize,,
21 
placementmethod,,
22 
permanence,,
23 
layoutnarrative,,
24 
elevationaccuracy,,
25 
elevationrange,,
26 
slopeaspect,slopeAspect/_alt/1,
27 
minslopeaspect,slopeAspect/_alt/2/_avg/min,
28 
maxslopeaspect,slopeAspect/_alt/2/_avg/max,
29 
slopegradient,slopeGradient/_alt/1,
30 
minslopegradient,slopeGradient/_alt/2/_avg/min,
31 
maxslopegradient,slopeGradient/_alt/2/_avg/max,
32 
topoposition,,
33 
surficialdeposits,,
34 
rocktype,,
35 
submitter_surname,,
36 
submitter_givenname,,
37 
submitter_email,,
38 
notespublic,,
39 
notesmgt,,
40 
revisions,,
41 
dateentered,,
42 
emb_plot,,
43 
plotrationalenarrative,,
44 
accessioncode,,
45 
area|country|territory,country,
46 
region|state|province,stateProvince,
47 
quadrangle,,
48 
Geographic Name,,
49 
row_num,,
inputs/VegBank/plot_/map.full.csv
1 
VegBank[Veg+],Veg+,Comments
2 
Elevation,Elevation
3 
continent,continent
4 
locationaccuracy,coordinateUncertaintyInMeters,
5 
area|country|territory,country,
6 
country,country
7 
county,county
8 
shape,footprintWKT,
9 
landform,landform
10 
latitude,latitude
11 
locationNarrative,locationNarrative
12 
longitude,longitude
13 
parent_id,parentPlotID,
14 
area,plotArea,
15 
plot_id,plotID,
16 
authorplotcode,plotName,
17 
slopeaspect,slopeAspect/_alt/1,
18 
maxslopeaspect,slopeAspect/_alt/2/_avg/max,
19 
minslopeaspect,slopeAspect/_alt/2/_avg/min,
20 
slopegradient,slopeGradient/_alt/1,
21 
maxslopegradient,slopeGradient/_alt/2/_avg/max,
22 
minslopegradient,slopeGradient/_alt/2/_avg/min,
23 
region|state|province,stateProvince,
24 
stateProvince,stateProvince
inputs/VegBank/plot_/VegBIEN.csv
1 
VegBank[Veg+],VegBIEN:,Comments
2 
authorplotcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
3 
plot_id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
4 
plot_id,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
5 
authorplotcode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 
plot_id,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
7 
area,/location/area,
8 
Elevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
9 
landform,/location/landform,
10 
locationaccuracy,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
11 
shape,/location/locationdetermination/footprintgeometry_dwc,
12 
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
13 
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
14 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
15 
region|state|province,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
16 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
17 
area|country|territory,"/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",
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 
continent,"/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 
authorplotcode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
21 
plot_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
22 
locationNarrative,/location/locationnarrative/_merge/1,
23 
slopeaspect,/location/slopeaspect/_compass/value/_alt/1,
24 
maxslopeaspect,/location/slopeaspect/_compass/value/_alt/2/_avg/max,
25 
minslopeaspect,/location/slopeaspect/_compass/value/_alt/2/_avg/min,
26 
slopegradient,/location/slopegradient/_alt/1,
27 
maxslopegradient,/location/slopegradient/_alt/2/_avg/max,
28 
minslopegradient,/location/slopegradient/_alt/2/_avg/min,
29 
parent_id,,** No join mapping for parentPlotID **
inputs/VegBank/plot_/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <location id="-1">
4 
        <authorlocationcode>$authorplotcode</authorlocationcode>
5 
        <sourceaccessioncode>$plot_id</sourceaccessioncode>
6 
        <area>$area</area>
7 
        <elevation>
8 
            <_replace>
9 
                <\bca\.?></\bca\.?>
10 
                <value>$elevation</value>
11 
            </_replace>
12 
        </elevation>
13 
        <landform>$landform</landform>
14 
        <locationdetermination>
15 
            <coordsaccuracy><_noCV><value>$locationaccuracy</value></_noCV></coordsaccuracy>
16 
            <footprintgeometry_dwc>$shape</footprintgeometry_dwc>
17 
            <latitude>
18 
                <_nullIf>
19 
                    <null>0</null>
20 
                    <type>float</type>
21 
                    <value>$latitude</value>
22 
                </_nullIf>
23 
            </latitude>
24 
            <longitude>
25 
                <_nullIf>
26 
                    <null>0</null>
27 
                    <type>float</type>
28 
                    <value>$longitude</value>
29 
                </_nullIf>
30 
            </longitude>
31 
            <namedplace_id>
32 
                <_simplifyPath>
33 
                    <next>parent_id/namedplace</next>
34 
                    <require>placename</require>
35 
                    <path>
36 
                        <namedplace>
37 
                            <rank>county</rank>
38 
                            <placename>$county</placename>
39 
                            <parent_id>
40 
                                <namedplace>
41 
                                    <rank>stateProvince</rank>
42 
                                    <placename>
43 
                                        <_alt>
44 
                                            <0>$region|state|province</0>
45 
                                            <1>$stateprovince</1>
46 
                                        </_alt>
47 
                                    </placename>
48 
                                    <parent_id>
49 
                                        <namedplace>
50 
                                            <rank>country</rank>
51 
                                            <placename>
52 
                                                <_alt>
53 
                                                    <0>$area|country|territory</0>
54 
                                                    <1>$country</1>
55 
                                                </_alt>
56 
                                            </placename>
57 
                                            <parent_id>
58 
                                                <namedplace>
59 
                                                    <rank>continent</rank>
60 
                                                    <placename>$continent</placename>
61 
                                                </namedplace>
62 
                                            </parent_id>
63 
                                        </namedplace>
64 
                                    </parent_id>
65 
                                </namedplace>
66 
                            </parent_id>
67 
                        </namedplace>
68 
                    </path>
69 
                </_simplifyPath>
70 
            </namedplace_id>
71 
        </locationdetermination>
72 
        <locationnarrative>$locationnarrative</locationnarrative>
73 
        <slopeaspect>
74 
            <_compass>
75 
                <value>
76 
                    <_alt>
77 
                        <1>$slopeaspect</1>
78 
                        <2>
79 
                            <_avg>
80 
                                <max>$maxslopeaspect</max>
81 
                                <min>$minslopeaspect</min>
82 
                            </_avg>
83 
                        </2>
84 
                    </_alt>
85 
                </value>
86 
            </_compass>
87 
        </slopeaspect>
88 
        <slopegradient>
89 
            <_alt>
90 
                <1>$slopegradient</1>
91 
                <2>
92 
                    <_avg>
93 
                        <max>$maxslopegradient</max>
94 
                        <min>$minslopegradient</min>
95 
                    </_avg>
96 
                </2>
97 
            </_alt>
98 
        </slopegradient>
99 
    </location>
100 
</VegBIEN>
101 
Inserted 7 new rows into database

Also available in: Unified diff