Project

General

Profile

« Previous | Next » 

Revision 4530

Added by Aaron Marcuse-Kubitza over 12 years ago

inputs/TEAM/: Added VL

View differences:

inputs/TEAM/VL/src.csv
1 
TEAM[Veg+],Veg+,Comments
2 
ID,,
3 
SiteName,,
4 
1haPlotCode,,
5 
ObservationDate,,
6 
Family,,
7 
Genus,,
8 
SpecificEpithet,,
9 
Collectors,,
10 
dbh,,
11 
max_diam,,
12 
max_diam_pom,,
13 
ConditionCodes,,
14 
LocationCodes,,
15 
SamplingPeriod,,
16 
Comments,,
17 
SamplingUnitName,,
18 
Latitude,,
19 
Longitude,,
20 
Method,,
21 
Subplot,,
22 
X_1haPlot,,
23 
Y_1haPlot,,
24 
TreeNumber,,
25 
ProtocolVersion,,
26 
ResponsibleInstitution,,
27 
ProtocolLeadScientist,,
28 
ProtocolLeadScientistInstitution,,
inputs/TEAM/VL/map.csv
1 
TEAM[Veg+],Veg+,Comments
2 
SiteName,projectName,
3 
1haPlotCode,plotName,
4 
ObservationDate,eventDate,
5 
Collectors,recordedBy,
6 
max_diam,,
7 
max_diam_pom,,
8 
ConditionCodes,,
9 
LocationCodes,,
10 
SamplingPeriod,,
11 
Comments,,
12 
SamplingUnitName,,
13 
Method,samplingProtocol,
14 
X_1haPlot,organismX,
15 
Y_1haPlot,organismY,
16 
TreeNumber,tag,
17 
ProtocolVersion,,
18 
ResponsibleInstitution,,
19 
ProtocolLeadScientist,,
20 
ProtocolLeadScientistInstitution,,
inputs/TEAM/VL/map.full.csv
1 
TEAM[Veg+],Veg+,Comments
2 
DBH,DBH
3 
ObservationDate,eventDate,
4 
family,family
5 
genus,genus
6 
id,id
7 
latitude,latitude
8 
longitude,longitude
9 
X_1haPlot,organismX,
10 
Y_1haPlot,organismY,
11 
1haPlotCode,plotName,
12 
SiteName,projectName,
13 
Collectors,recordedBy,
14 
Method,samplingProtocol,
15 
specificEpithet,specificEpithet
16 
subplot,subplot
17 
TreeNumber,tag,
inputs/TEAM/VL/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/VL/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