Project

General

Profile

« Previous | Next » 

Revision 7875

inputs/NCU/Specimen/map.csv: cultivated: Map false (0) to NULL because cultivated can only be true or NULL, not false

View differences:

inputs/NCU/Specimen/map.csv
25 25
county,county,,
26 26
FIPSStateCounty,*FIPSStateCounty,,
27 27
CityLocality,verbatimLocality,/_alt/2,
28
Cultivated,cultivated,"/_nullIf:[null=""-1""]/value",
28
Cultivated,cultivated,"/_map:[0=,""-1""=true,*=*]/value","cultivated can only be true or NULL, not false"
29 29
Latitude1,decimalLatitude,,
30 30
Longitude1,decimalLongitude,,
31 31
Loc_AltN,verbatimLatitude,,
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/_alt/2/_nullIf:[null=""-1""]/value",
16
Cultivated,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_alt/2/_map:[0=,""-1""=true,*=*]/value","cultivated can only be true or NULL, not false"
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/_alt/2/_nullIf:[null=""-1""]/value",
38
Cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/2/_map:[0=,""-1""=true,*=*]/value","cultivated can only be true or NULL, not false"
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,
inputs/NCU/Specimen/test.xml.ref
74 74
                                </aggregateoccurrence>
75 75
                                <collector_id><party><fullname>$firstCollectorName</fullname></party></collector_id>
76 76
                                <iscultivated>
77
                                    <_nullIf>
78
                                        <null>-1</null>
77
                                    <_map>
78
                                        <0></0>
79
                                        <-1>true</-1>
80
                                        <*>*</*>
79 81
                                        <value>$Cultivated</value>
80
                                    </_nullIf>
82
                                    </_map>
81 83
                                </iscultivated>
82 84
                                <sourceaccessioncode>$SpecimenPK</sourceaccessioncode>
83 85
                                <taxondetermination>

Also available in: Unified diff