Project

General

Profile

« Previous | Next » 

Revision 7629

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/TEAM/V*/map.csv: Id: Remapped to individualObservationID

View differences:

inputs/TEAM/VL/map.csv
1 1 
TEAM,VegCore,Filter,Comments
2 
Id,dataProviderRecordID,,
2 
Id,individualObservationID,,
3 3 
Observation Date,eventDate,,
4 4 
Family,family,,
5 5 
Genus,genus,,
inputs/TEAM/VL/VegBIEN.csv
1 1 
TEAM,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
Id,"/_if[@name=""if specimen""]/cond/_exists",
3 2 
Subplot Number,"/location/_if[@name=""if subplot""]/cond/_exists",
4 3 
1ha Plot Number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
5 
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1",
6 
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",
7 4 
1ha Plot Number,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
8 5 
Subplot Number,/location/authorlocationcode,
6 
Id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
9 7 
Site Name,/location/locationevent/*_id/project/projectname,
10 8 
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
11 9 
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
......
16 14 
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_alt/2/_dateRangeStart/value",
17 15 
Observation Date,/location/locationevent/obsenddate/_alt/2/_dateRangeEnd/value,
18 16 
Observation Date,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value,
19 
Id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
20 
Id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
17 
Id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode/_first/1,
21 18 
Diameter at 1.3m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 7 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
22 19 
Tree Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag,
23 20 
1ha Plot X Coordinate,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,"""Point of intersection {in the X axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot X Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
24 21 
1ha Plot Y Coordinate,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,"""Point of intersection {in the Y axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot Y Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
25 22 
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
23 
Id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_if[@name=""if individual""]/cond/_exists",
26 24 
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
27 25 
Names of Collectors,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
28 26 
Id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
29 
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
27 
Id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else/_first/1",
30 28 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
31 29 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
32 30 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
inputs/TEAM/VL/test.xml.ref
32 32 
                            <taxonoccurrence>
33 33 
                                <aggregateoccurrence>
34 34 
                                    <plantobservation>
35 
                                        <specimenreplicate><sourceaccessioncode>$Id</sourceaccessioncode></specimenreplicate>
35 
                                        <sourceaccessioncode>$Id</sourceaccessioncode>
36 36 
                                        <stemobservation>
37 37 
                                            <diameterbreastheight_m><_cm_to_m><value>$Diameter at 1.3m</value></_cm_to_m></diameterbreastheight_m>
38 38 
                                            <tag>$Tree Number</tag>
......
166 166 
        </path>
167 167 
    </_setDefault>
168 168 
</VegBIEN>
169 
Inserted 32 new rows into database
169 
Inserted 30 new rows into database
inputs/TEAM/VT/map.csv
1 1 
TEAM,VegCore,Filter,Comments
2 
Id,dataProviderRecordID,,
2 
Id,individualObservationID,,
3 3 
Observation Date,eventDate,,
4 4 
Family,family,,
5 5 
Genus,genus,,
inputs/TEAM/VT/VegBIEN.csv
1 1 
TEAM,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
Id,"/_if[@name=""if specimen""]/cond/_exists",
3 2 
Subplot Number,"/location/_if[@name=""if subplot""]/cond/_exists",
4 3 
1ha Plot Number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
5 
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1",
6 
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",
7 4 
1ha Plot Number,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
8 5 
Subplot Number,/location/authorlocationcode,
6 
Id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
9 7 
Site Name,/location/locationevent/*_id/project/projectname,
10 8 
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
11 9 
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
......
16 14 
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_alt/2/_dateRangeStart/value",
17 15 
Observation Date,/location/locationevent/obsenddate/_alt/2/_dateRangeEnd/value,
18 16 
Observation Date,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value,
19 
Id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
20 
Id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
17 
Id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode/_first/1,
21 18 
Diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 7 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
22 19 
Tree Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag,
23 20 
1ha Plot X Coordinate,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,"""Point of intersection {in the X axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot X Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
24 21 
1ha Plot Y Coordinate,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,"""Point of intersection {in the Y axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot Y Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
25 22 
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
23 
Id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_if[@name=""if individual""]/cond/_exists",
26 24 
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
27 25 
Names of Collectors,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
28 26 
Id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
29 
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
27 
Id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else/_first/1",
30 28 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
31 29 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
32 30 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
inputs/TEAM/VT/test.xml.ref
32 32 
                            <taxonoccurrence>
33 33 
                                <aggregateoccurrence>
34 34 
                                    <plantobservation>
35 
                                        <specimenreplicate><sourceaccessioncode>$Id</sourceaccessioncode></specimenreplicate>
35 
                                        <sourceaccessioncode>$Id</sourceaccessioncode>
36 36 
                                        <stemobservation>
37 37 
                                            <diameterbreastheight_m><_cm_to_m><value>$Diameter</value></_cm_to_m></diameterbreastheight_m>
38 38 
                                            <tag>$Tree Number</tag>
......
166 166 
        </path>
167 167 
    </_setDefault>
168 168 
</VegBIEN>
169 
Inserted 30 new rows into database
169 
Inserted 28 new rows into database

Also available in: Unified diff