Project

General

Profile

« Previous | Next » 

Revision 4496

Added by Aaron Marcuse-Kubitza about 12 years ago

Added inputs/TEAM/

View differences:

inputs/TEAM/VT/src.csv
1 
TEAM[Veg+],Veg+,Comments
2 
ID,,
3 
ObservationDate,,
4 
Family,,
5 
Genus,,
6 
SpecificEpithet,,
7 
Collectors,,
8 
dbh,,
9 
dbh_pom,,
10 
dbh_new,,
11 
dbh_new_pom,,
12 
ConditionCodes,,
13 
SamplingPeriod,,
14 
Comments,,
15 
SamplingUnitName,,
16 
Latitude,,
17 
Longitude,,
18 
Method,,
19 
Subplot,,
20 
X_1haPlot,,
21 
Y_1haPlot,,
22 
TreeNumber,,
23 
SiteName,,
24 
1haPlotCode,,
25 
ProtocolVersion,,
26 
ResponsibleInstitution,,
27 
ProtocolLeadScientist,,
28 
ProtocolLeadScientistInstitution,,
inputs/TEAM/VT/map.csv
1 
TEAM[Veg+],Veg+,Comments
2 
ID,id,
3 
ObservationDate,eventDate,
4 
Collectors,recordedBy,
5 
dbh,DBH,
6 
dbh_pom,,
7 
dbh_new,,
8 
dbh_new_pom,,
9 
ConditionCodes,,
10 
SamplingPeriod,,
11 
Comments,,
12 
SamplingUnitName,,
13 
Method,samplingProtocol,
14 
X_1haPlot,organismX,
15 
Y_1haPlot,organismY,
16 
TreeNumber,tag,
17 
SiteName,projectName,
18 
1haPlotCode,plotName,
19 
ProtocolVersion,,
20 
ResponsibleInstitution,,
21 
ProtocolLeadScientist,,
22 
ProtocolLeadScientistInstitution,,
inputs/TEAM/VT/map.full.csv
1 
TEAM[Veg+],Veg+,Comments
2 
dbh,DBH,
3 
Family,Family
4 
Genus,Genus
5 
Latitude,Latitude
6 
Longitude,Longitude
7 
SpecificEpithet,SpecificEpithet
8 
Subplot,Subplot
9 
ObservationDate,eventDate,
10 
ID,id,
11 
X_1haPlot,organismX,
12 
Y_1haPlot,organismY,
13 
1haPlotCode,plotName,
14 
SiteName,projectName,
15 
Collectors,recordedBy,
16 
Method,samplingProtocol,
17 
TreeNumber,tag,
inputs/TEAM/VT/VegBIEN.csv
1 
TEAM[Veg+],VegBIEN:,Comments
2 
Subplot,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
3 
1haPlotCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
4 
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
5 
1haPlotCode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 
Subplot,/location/authorlocationcode,
7 
Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
8 
Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
9 
Method,/location/locationevent/*_id/method/name,
10 
SiteName,/location/locationevent/*_id/project/projectname,
11 
Subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
12 
1haPlotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
13 
ObservationDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
14 
ObservationDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
15 
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
16 
dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
17 
TreeNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
18 
X_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
19 
Y_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
20 
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
21 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
22 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
23 
Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
inputs/TEAM/VT/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <location id="-1">
4 
        <parent_id><location><authorlocationcode>$1haPlotCode</authorlocationcode></location></parent_id>
5 
        <authorlocationcode>$Subplot</authorlocationcode>
6 
        <locationdetermination>
7 
            <latitude>
8 
                <_nullIf>
9 
                    <null>0</null>
10 
                    <type>float</type>
11 
                    <value>$Latitude</value>
12 
                </_nullIf>
13 
            </latitude>
14 
            <longitude>
15 
                <_nullIf>
16 
                    <null>0</null>
17 
                    <type>float</type>
18 
                    <value>$Longitude</value>
19 
                </_nullIf>
20 
            </longitude>
21 
        </locationdetermination>
22 
        <locationevent>
23 
            <method_id><method><name>$Method</name></method></method_id>
24 
            <project_id><project><projectname>$SiteName</projectname></project></project_id>
25 
            <obsenddate><_date><date><_dateRangeEnd><value>$ObservationDate</value></_dateRangeEnd></date></_date></obsenddate>
26 
            <obsstartdate><_date><date><_dateRangeStart><value>$ObservationDate</value></_dateRangeStart></date></_date></obsstartdate>
27 
            <taxonoccurrence>
28 
                <aggregateoccurrence>
29 
                    <plantobservation>
30 
                        <specimenreplicate><sourceaccessioncode>$ID</sourceaccessioncode></specimenreplicate>
31 
                        <stemobservation>
32 
                            <diameterbreastheight>$dbh</diameterbreastheight>
33 
                            <stemtag>
34 
                                <iscurrent>true</iscurrent>
35 
                                <tag>$TreeNumber</tag>
36 
                            </stemtag>
37 
                            <xposition>$X_1haPlot</xposition>
38 
                            <yposition>$Y_1haPlot</yposition>
39 
                        </stemobservation>
40 
                    </plantobservation>
41 
                </aggregateoccurrence>
42 
                <taxondetermination>
43 
                    <plantconcept_id>
44 
                        <plantconcept>
45 
                            <plantname_id>
46 
                                <_simplifyPath>
47 
                                    <next>parent_id</next>
48 
                                    <path>
49 
                                        <plantname>
50 
                                            <rank>binomial</rank>
51 
                                            <parent_id>
52 
                                                <plantname>
53 
                                                    <rank>authority</rank>
54 
                                                    <parent_id>
55 
                                                        <plantname>
56 
                                                            <rank>subspecies</rank>
57 
                                                            <parent_id>
58 
                                                                <plantname>
59 
                                                                    <rank>species</rank>
60 
                                                                    <plantname>$SpecificEpithet</plantname>
61 
                                                                    <parent_id>
62 
                                                                        <plantname>
63 
                                                                            <rank>genus</rank>
64 
                                                                            <plantname>$Genus</plantname>
65 
                                                                            <parent_id>
66 
                                                                                <plantname>
67 
                                                                                    <rank>family</rank>
68 
                                                                                    <plantname>$Family</plantname>
69 
                                                                                </plantname>
70 
                                                                            </parent_id>
71 
                                                                        </plantname>
72 
                                                                    </parent_id>
73 
                                                                </plantname>
74 
                                                            </parent_id>
75 
                                                        </plantname>
76 
                                                    </parent_id>
77 
                                                </plantname>
78 
                                            </parent_id>
79 
                                        </plantname>
80 
                                    </path>
81 
                                </_simplifyPath>
82 
                            </plantname_id>
83 
                        </plantconcept>
84 
                    </plantconcept_id>
85 
                </taxondetermination>
86 
                <verbatimcollectorname>$Collectors</verbatimcollectorname>
87 
            </taxonoccurrence>
88 
        </locationevent>
89 
    </location>
90 
</VegBIEN>
91 
Inserted 23 new rows into database

Also available in: Unified diff