Project

General

Profile

« Previous | Next » 

Revision 10531

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/HVAA/Specimen/: translated multi-column filters to postprocessing derived columns, using the steps at wiki.vegpath.org/Adding_new-style_import_to_a_datasource#Translating-filters-to-postprocessing-derived-columns

View differences:

inputs/HVAA/Specimen/map.csv
32 32 
habitat,habitat,,
33 33 
fieldNotes,UNUSED#fieldNotes,,
34 34 
fieldNumber,collectorNumber,,
35 
occurrenceRemarks,occurrenceRemarks,/_merge/1,
36 
dynamicProperties,occurrenceRemarks,/_merge/2,Contains occurrenceRemarks data
35 
occurrenceRemarks,occurrenceRemarks_from_occurrenceRemarks,,
36 
dynamicProperties,occurrenceRemarks_from_dynamicProperties,,Contains occurrenceRemarks data
37 37 
associatedTaxa,associatedTaxa,,
38 38 
reproductiveCondition,reproductiveCondition,,
39 39 
establishmentMeans,establishmentMeans,,
......
71 71 
rightsHolder,dataOwners,,
72 72 
accessRights,accessRights,,
73 73 
symbiotaId,occurrenceID,,
74 
occurrenceRemarks,occurrenceRemarks,,
inputs/HVAA/Specimen/VegBIEN.csv
28 28 
month,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
29 29 
year,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
30 30 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
31 
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_merge/1,
32 
dynamicProperties,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_merge/2,Contains occurrenceRemarks data
31 
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1,
33 32 
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,
34 33 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,
35 34 
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
......
102 101 
basisOfRecord,,** No join mapping for basisOfRecord **
103 102 
coordinatePrecision,,** No non-empty join mapping for UNUSED#coordinatePrecision **
104 103 
disposition,,** No join mapping for disposition **
104 
dynamicProperties,,** No join mapping for occurrenceRemarks_from_dynamicProperties ** Contains occurrenceRemarks data
105 105 
endDayOfYear,,** No join mapping for endDayOfYear **
106 106 
fieldNotes,,** No non-empty join mapping for UNUSED#fieldNotes **
107 107 
geodeticDatum,,** No join mapping for geodeticDatum **
......
116 116 
lifeStage,,** No join mapping for lifeStage **
117 117 
modified,,** No join mapping for modified **
118 118 
municipality,,** No join mapping for municipality **
119 
occurrenceRemarks,,** No join mapping for occurrenceRemarks_from_occurrenceRemarks **
119 120 
otherCatalogNumbers,,** No join mapping for otherCatalogNumbers **
120 121 
ownerInstitutionCode,,** No join mapping for specimenOwner **
121 122 
preparations,,** No join mapping for preparations **
inputs/HVAA/Specimen/test.xml.ref
83 83 
                                        </_alt>
84 84 
                                    </collectiondate>
85 85 
                                    <count>$individualCount</count>
86 
                                    <notes>
87 
                                        <_merge>
88 
                                            <1>$occurrenceRemarks</1>
89 
                                            <2>$dynamicProperties</2>
90 
                                        </_merge>
91 
                                    </notes>
86 
                                    <notes>$occurrenceRemarks</notes>
92 87 
                                    <plantobservation>
93 88 
                                        <authorplantcode>
94 89 
                                            <_alt>
inputs/HVAA/Specimen/unmapped_terms.csv
8 8 
startDayOfYear
9 9 
endDayOfYear
10 10 
verbatimEventDate
11 
occurrenceRemarks_from_occurrenceRemarks
12 
occurrenceRemarks_from_dynamicProperties
11 13 
associatedTaxa
12 14 
lifeStage
13 15 
preparations

Also available in: Unified diff