Project

General

Profile

« Previous | Next » 

Revision 4517

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/VegBank/: Added observation_/

View differences:

inputs/VegBank/import_order.txt
1 
plot_
1 
plot_
2 
observation_
inputs/VegBank/observation_/create.sql
1 
SELECT *
2 
FROM observation
3 
LEFT JOIN soilobs USING (observation_id)
inputs/VegBank/observation_/src.csv
1 
VegBank[Veg+],Veg+,Comments
2 
observation_id,,
3 
previousobs_id,,
4 
plot_id,,
5 
project_id,,
6 
authorobscode,,
7 
dateaccuracy,,
8 
covermethod_id,,
9 
coverdispersion,,
10 
autotaxoncover,,
11 
stratummethod_id,,
12 
methodnarrative,,
13 
taxonobservationarea,,
14 
stemsizelimit,,
15 
stemobservationarea,,
16 
stemsamplemethod,,
17 
originaldata,,
18 
effortlevel,,
19 
plotvalidationlevel,,
20 
floristicquality,,
21 
bryophytequality,,
22 
lichenquality,,
23 
observationnarrative,,
24 
landscapenarrative,,
25 
homogeneity,,
26 
phenologicaspect,,
27 
representativeness,,
28 
standmaturity,,
29 
successionalstatus,,
30 
basalarea,,
31 
hydrologicregime,,
32 
soilmoistureregime,,
33 
soildrainage,,
34 
watersalinity,,
35 
waterdepth,,
36 
shoredistance,,
37 
soildepth,,
38 
organicdepth,,
39 
soiltaxon_id,,
40 
soiltaxonsrc,,
41 
percentbedrock,,
42 
percentrockgravel,,
43 
percentwood,,
44 
percentlitter,,
45 
percentbaresoil,,
46 
percentwater,,
47 
percentother,,
48 
nameother,,
49 
treeht,,
50 
shrubht,,
51 
fieldht,,
52 
nonvascularht,,
53 
submergedht,,
54 
treecover,,
55 
shrubcover,,
56 
fieldcover,,
57 
nonvascularcover,,
58 
floatingcover,,
59 
submergedcover,,
60 
dominantstratum,,
61 
growthform1type,,
62 
growthform2type,,
63 
growthform3type,,
64 
growthform1cover,,
65 
growthform2cover,,
66 
growthform3cover,,
67 
totalcover,,
68 
notespublic,,
69 
notesmgt,,
70 
revisions,,
71 
obsstartdate,,
72 
obsenddate,,
73 
dateentered,,
74 
emb_observation,,
75 
interp_orig_ci_id,,
76 
interp_orig_cc_id,,
77 
interp_orig_sciname,,
78 
interp_orig_code,,
79 
interp_orig_party_id,,
80 
interp_orig_partyname,,
81 
interp_current_ci_id,,
82 
interp_current_cc_id,,
83 
interp_current_sciname,,
84 
interp_current_code,,
85 
interp_current_party_id,,
86 
interp_current_partyname,,
87 
interp_bestfit_ci_id,,
88 
interp_bestfit_cc_id,,
89 
interp_bestfit_sciname,,
90 
interp_bestfit_code,,
91 
interp_bestfit_party_id,,
92 
interp_bestfit_partyname,,
93 
toptaxon1name,,
94 
toptaxon2name,,
95 
toptaxon3name,,
96 
toptaxon4name,,
97 
toptaxon5name,,
98 
numberoftaxa,,
99 
accessioncode,,
100 
soilobs_id,,
101 
soilhorizon,,
102 
soildepthtop,,
103 
soildepthbottom,,
104 
soilcolor,,
105 
soilorganic,,
106 
soiltexture,,
107 
soilsand,,
108 
soilsilt,,
109 
soilclay,,
110 
soilcoarse,,
111 
soilph,,
112 
exchangecapacity,,
113 
basesaturation,,
114 
soildescription,,
115 
emb_soilobs,,
116 
row_num,,
inputs/VegBank/observation_/header.csv
1 
observation_id,previousobs_id,plot_id,project_id,authorobscode,dateaccuracy,covermethod_id,coverdispersion,autotaxoncover,stratummethod_id,methodnarrative,taxonobservationarea,stemsizelimit,stemobservationarea,stemsamplemethod,originaldata,effortlevel,plotvalidationlevel,floristicquality,bryophytequality,lichenquality,observationnarrative,landscapenarrative,homogeneity,phenologicaspect,representativeness,standmaturity,successionalstatus,basalarea,hydrologicregime,soilmoistureregime,soildrainage,watersalinity,waterdepth,shoredistance,soildepth,organicdepth,soiltaxon_id,soiltaxonsrc,percentbedrock,percentrockgravel,percentwood,percentlitter,percentbaresoil,percentwater,percentother,nameother,treeht,shrubht,fieldht,nonvascularht,submergedht,treecover,shrubcover,fieldcover,nonvascularcover,floatingcover,submergedcover,dominantstratum,growthform1type,growthform2type,growthform3type,growthform1cover,growthform2cover,growthform3cover,totalcover,notespublic,notesmgt,revisions,obsstartdate,obsenddate,dateentered,emb_observation,interp_orig_ci_id,interp_orig_cc_id,interp_orig_sciname,interp_orig_code,interp_orig_party_id,interp_orig_partyname,interp_current_ci_id,interp_current_cc_id,interp_current_sciname,interp_current_code,interp_current_party_id,interp_current_partyname,interp_bestfit_ci_id,interp_bestfit_cc_id,interp_bestfit_sciname,interp_bestfit_code,interp_bestfit_party_id,interp_bestfit_partyname,toptaxon1name,toptaxon2name,toptaxon3name,toptaxon4name,toptaxon5name,numberoftaxa,accessioncode,soilobs_id,soilhorizon,soildepthtop,soildepthbottom,soilcolor,soilorganic,soiltexture,soilsand,soilsilt,soilclay,soilcoarse,soilph,exchangecapacity,basesaturation,soildescription,emb_soilobs,row_num
inputs/VegBank/observation_/map.csv
1 
VegBank[Veg+],Veg+,Comments
2 
observation_id,eventID,
3 
previousobs_id,,
4 
dateaccuracy,,
5 
covermethod_id,,
6 
coverdispersion,,
7 
autotaxoncover,,
8 
stratummethod_id,,
9 
methodnarrative,samplingProtocol,
10 
taxonobservationarea,,
11 
stemsizelimit,,
12 
stemobservationarea,,
13 
stemsamplemethod,,
14 
originaldata,,
15 
effortlevel,,
16 
plotvalidationlevel,,
17 
floristicquality,,
18 
bryophytequality,,
19 
lichenquality,,
20 
observationnarrative,,
21 
landscapenarrative,,
22 
homogeneity,,
23 
phenologicaspect,,
24 
representativeness,,
25 
standmaturity,,
26 
successionalstatus,,
27 
basalarea,,
28 
hydrologicregime,,
29 
soilmoistureregime,,
30 
soildrainage,,
31 
watersalinity,,
32 
waterdepth,,
33 
shoredistance,,
34 
soildepth,,
35 
organicdepth,,
36 
soiltaxon_id,,
37 
soiltaxonsrc,,
38 
percentbedrock,,
39 
percentrockgravel,,
40 
percentwood,,
41 
percentlitter,,
42 
percentbaresoil,,
43 
percentwater,,
44 
percentother,,
45 
nameother,,
46 
treeht,,
47 
shrubht,,
48 
fieldht,,
49 
nonvascularht,,
50 
submergedht,,
51 
treecover,,
52 
shrubcover,,
53 
fieldcover,,
54 
nonvascularcover,,
55 
floatingcover,,
56 
submergedcover,,
57 
dominantstratum,,
58 
growthform1type,,
59 
growthform2type,,
60 
growthform3type,,
61 
growthform1cover,,
62 
growthform2cover,,
63 
growthform3cover,,
64 
totalcover,,
65 
notespublic,,
66 
notesmgt,,
67 
revisions,,
68 
obsstartdate,startDate,
69 
obsenddate,endDate,
70 
dateentered,,
71 
emb_observation,,
72 
interp_orig_ci_id,,
73 
interp_orig_cc_id,,
74 
interp_orig_sciname,,
75 
interp_orig_code,,
76 
interp_orig_party_id,,
77 
interp_orig_partyname,,
78 
interp_current_ci_id,,
79 
interp_current_cc_id,,
80 
interp_current_sciname,,
81 
interp_current_code,,
82 
interp_current_party_id,,
83 
interp_current_partyname,,
84 
interp_bestfit_ci_id,,
85 
interp_bestfit_cc_id,,
86 
interp_bestfit_sciname,,
87 
interp_bestfit_code,,
88 
interp_bestfit_party_id,,
89 
interp_bestfit_partyname,,
90 
toptaxon1name,,
91 
toptaxon2name,,
92 
toptaxon3name,,
93 
toptaxon4name,,
94 
toptaxon5name,,
95 
numberoftaxa,,
96 
accessioncode,,
97 
soilobs_id,,
98 
soilhorizon,,
99 
soildepthtop,,
100 
soildepthbottom,,
101 
soilcolor,,
102 
soilorganic,organic,
103 
soiltexture,texture,
104 
soilsand,sand,
105 
soilsilt,silt,
106 
soilclay,clay,
107 
soilcoarse,,
108 
soilph,ph,
109 
exchangecapacity,cationExchangeCapacity,
110 
soildescription,,
111 
emb_soilobs,,
112 
row_num,,
inputs/VegBank/observation_/map.full.csv
1 
VegBank[Veg+],Veg+,Comments
2 
authorObsCode,authorObsCode
3 
baseSaturation,baseSaturation
4 
exchangecapacity,cationExchangeCapacity,
5 
soilclay,clay,
6 
obsenddate,endDate,
7 
observation_id,eventID,
8 
soilorganic,organic,
9 
soilph,ph,
10 
plotID,plotID
11 
projectID,projectID
12 
methodnarrative,samplingProtocol,
13 
soilsand,sand,
14 
soilsilt,silt,
15 
obsstartdate,startDate,
16 
soiltexture,texture,
inputs/VegBank/observation_/VegBIEN.csv
1 
VegBank[Veg+],VegBIEN:,Comments
2 
plotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
3 
authorObsCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else",
4 
plotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
5 
plotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
6 
methodnarrative,/location/locationevent/*_id/method/name,
7 
projectID,/location/locationevent/*_id/project/sourceaccessioncode,
8 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
9 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
10 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1",
11 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2",
12 
plotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
13 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
14 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
15 
obsenddate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
16 
obsstartdate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
17 
baseSaturation,/location/locationevent/soilobs/basesaturation,
18 
exchangecapacity,/location/locationevent/soilobs/cationexchangecapacity,
19 
soilclay,/location/locationevent/soilobs/clay,
20 
soilorganic,/location/locationevent/soilobs/organic,
21 
soilph,/location/locationevent/soilobs/ph,
22 
soilsand,/location/locationevent/soilobs/sand,
23 
soilsilt,/location/locationevent/soilobs/silt,
24 
soiltexture,/location/locationevent/soilobs/texture,
inputs/VegBank/observation_/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <location id="-1">
4 
        <sourceaccessioncode>$plot_id</sourceaccessioncode>
5 
        <locationevent>
6 
            <method_id><method><name>$methodnarrative</name></method></method_id>
7 
            <project_id><project><sourceaccessioncode>$project_id</sourceaccessioncode></project></project_id>
8 
            <authoreventcode>$authorobscode</authoreventcode>
9 
            <sourceaccessioncode>$observation_id</sourceaccessioncode>
10 
            <obsenddate><_date><date><_dateRangeEnd><value>$obsenddate</value></_dateRangeEnd></date></_date></obsenddate>
11 
            <obsstartdate><_date><date><_dateRangeStart><value>$obsstartdate</value></_dateRangeStart></date></_date></obsstartdate>
12 
            <soilobs>
13 
                <basesaturation>$basesaturation</basesaturation>
14 
                <cationexchangecapacity>$exchangecapacity</cationexchangecapacity>
15 
                <clay>$soilclay</clay>
16 
                <organic>$soilorganic</organic>
17 
                <ph>$soilph</ph>
18 
                <sand>$soilsand</sand>
19 
                <silt>$soilsilt</silt>
20 
                <texture>$soiltexture</texture>
21 
            </soilobs>
22 
        </locationevent>
23 
    </location>
24 
</VegBIEN>
25 
Inserted 9 new rows into database

Also available in: Unified diff