Project

General

Profile

« Previous | Next » 

Revision 4373

Added by Aaron Marcuse-Kubitza about 12 years ago

mappings/Veg+-VegCore.csv: Mapped speciesInvID

View differences:

inputs/CTFS/TaxonOccurrence/map.csv
3 3 
GenusID,,
4 4 
SpeciesID,,
5 5 
SubSpeciesID,,
6 
SpeciesInvID,,
7 6 
SubSpeciesCurrentTaxonFlag,,
8 7 
SubSpeciesObsoleteTaxonFlag,,
9 8 
SubSpeciesMnemonic,,
inputs/CTFS/TaxonOccurrence/map.full.csv
3 3 
Family,Family
4 4 
Genus,Genus
5 5 
PlotID,PlotID
6 
SpeciesInvID,SpeciesInvID
6 7 
SpeciesName,SpeciesName
7 8 
SubSpeciesName,SubSpeciesName
inputs/CTFS/TaxonOccurrence/VegBIEN.csv
4 4 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
5 5 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
6 6 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode",
7 
SpeciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
7 8 
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
8 9 
SpeciesName,"/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",
9 10 
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",
inputs/CTFS/TaxonOccurrence/test.xml.ref
5 5 
        <locationevent>
6 6 
            <sourceaccessioncode>$CensusID</sourceaccessioncode>
7 7 
            <taxonoccurrence>
8 
                <sourceaccessioncode>$SpeciesInvID</sourceaccessioncode>
8 9 
                <taxondetermination>
9 10 
                    <plantconcept_id>
10 11 
                        <plantconcept>
......
54 55 
        </locationevent>
55 56 
    </location>
56 57 
</VegBIEN>
57 
Inserted 14 new rows into database
58 
Inserted 15 new rows into database
mappings/Veg+-VegBIEN.csv
330 330 
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
331 331 
EstablishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
332 332 
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
333 
SpeciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
333 334 
TaxonOccurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
335 
speciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
334 336 
taxonOccurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
335 337 
IndividualID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2,
336 338 
individualID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2,
mappings/Veg+.cs-VegBIEN.csv
172 172 
verbatimGrowthForm,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
173 173 
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
174 174 
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
175 
speciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
175 176 
taxonOccurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
176 177 
individualID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2,
177 178 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
mappings/for_review/Veg+-VegCore.csv
75 75 
StartX,subplotX,
76 76 
StartY,subplotY,
77 77 
stemTag,tag,
78 
speciesInvID,taxonOccurrenceID,
78 79 
remarks,taxonRemarks,
79 80 
Elevation,verbatimElevation,
80 81 
habit,verbatimGrowthForm,
mappings/Veg+-VegCore.to_self.csv
76 76 
StartX,subplotX,
77 77 
StartY,subplotY,
78 78 
stemTag,tag,
79 
speciesInvID,taxonOccurrenceID,
79 80 
remarks,taxonRemarks,
80 81 
Elevation,verbatimElevation,
81 82 
latitude,verbatimLatitude,
mappings/Veg+.self.csv
137 137 
SlopeGradient,SlopeGradient
138 138 
Sodium,Sodium
139 139 
Species,Species
140 
SpeciesInvID,SpeciesInvID
140 141 
SpeciesName,SpeciesName
141 142 
SpecificEpithet,SpecificEpithet
142 143 
StartDate,StartDate
......
309 310 
slopeGradient,slopeGradient
310 311 
sodium,sodium
311 312 
species,species
313 
speciesInvID,speciesInvID
312 314 
speciesName,speciesName
313 315 
specificEpithet,specificEpithet
314 316 
startDate,startDate
mappings/Veg+-VegCore.csv
75 75 
StartX,subplotX,
76 76 
StartY,subplotY,
77 77 
stemTag,tag,
78 
speciesInvID,taxonOccurrenceID,
78 79 
remarks,taxonRemarks,
79 80 
Elevation,verbatimElevation,
80 81 
habit,verbatimGrowthForm,

Also available in: Unified diff