Project

General

Profile

« Previous | Next » 

Revision 10563

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/NCU/Specimen/: translated single-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/NCU/Specimen/map.csv
26 26 
county,county,,
27 27 
FIPSStateCounty,*FIPSStateCounty,,
28 28 
CityLocality,verbatimLocality,/_alt/2,
29 
Cultivated,cultivated,"/_map:[0=,""-1""=true,*=*]/value","cultivated can only be true or NULL, not false"
29 
Cultivated,cultivated_verbatim,,
30 30 
Latitude1,decimalLatitude,,
31 31 
Longitude1,decimalLongitude,,
32 32 
Loc_AltN,verbatimLatitude,,
......
37 37 
LastAnnotationDateVerbatim,*LastAnnotationDateVerbatim,,
38 38 
LastAnnotationRemarks,*LastAnnotationRemarks,,
39 39 
lastAnnotationAgent,*lastAnnotationAgent,,
40 
cultivated,cultivated,,
inputs/NCU/Specimen/VegBIEN.csv
13 13 
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
14 14 
SpecimenPK,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
15 15 
firstCollectorRemarks,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists","Actually the collector's number, not remarks"
16 
Cultivated,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_first/1/_map:[0=,""-1""=true,*=*]/value","cultivated can only be true or NULL, not false"
16 
cultivated,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_first/1",
17 17 
VerbatimLocality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2/_alt/1,
18 18 
CityLocality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2/_alt/2,
19 19 
CollectionDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1,
......
35 35 
firstCollectorName,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
36 36 
SpecimenPK,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
37 37 
firstCollectorRemarks,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists","Actually the collector's number, not remarks"
38 
Cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_first/1/_map:[0=,""-1""=true,*=*]/value","cultivated can only be true or NULL, not false"
38 
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_first/1",
39 39 
SpecimenPK,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
40 40 
CurrentScientificNameWithAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1,
41 41 
CurrentScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1,
......
63 63 
BlockSpecificLocation,,** No join mapping for *BlockSpecificLocation **
64 64 
CollectionObjectID,,** No join mapping for *CollectionObjectID **
65 65 
CollectionObjectTypeID,,** No join mapping for *CollectionObjectTypeID **
66 
Cultivated,,** No join mapping for cultivated_verbatim **
66 67 
DerivedFromID,,** No join mapping for *DerivedFromID **
67 68 
EventRemarks,,** No join mapping for eventRemarks **
68 69 
FIPSStateCounty,,** No join mapping for *FIPSStateCounty **
inputs/NCU/Specimen/test.xml.ref
73 73 
                                    </plantobservation>
74 74 
                                </aggregateoccurrence>
75 75 
                                <collector_id><party><fullname>$firstCollectorName</fullname></party></collector_id>
76 
                                <iscultivated>
77 
                                    <_map>
78 
                                        <0></0>
79 
                                        <-1>true</-1>
80 
                                        <*>*</*>
81 
                                        <value>$Cultivated</value>
82 
                                    </_map>
83 
                                </iscultivated>
76 
                                <iscultivated>$cultivated</iscultivated>
84 77 
                                <sourceaccessioncode>$SpecimenPK</sourceaccessioncode>
85 78 
                                <taxondetermination>
86 79 
                                    <taxonverbatim_id>
inputs/NCU/Specimen/unmapped_terms.csv
9 9 
*BlockSpecificLocation
10 10 
eventRemarks
11 11 
*FIPSStateCounty
12 
cultivated_verbatim
12 13 
*LastAnnotationLabelTaxon
13 14 
*LastAnnotationDateVerbatim
14 15 
*LastAnnotationRemarks

Also available in: Unified diff