36 |
36 |
HAVING count(*) > 1
|
37 |
37 |
-----"
|
38 |
38 |
collectno,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
|
39 |
|
cultivated,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_alt/2",Ignore other values
|
|
39 |
cultivated,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_alt/2/_alt/1",Ignore other values
|
|
40 |
campus,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_alt/2/_alt/2/_map:[*=true]/value","""this refers to occurrence on the UNCC campus, but I do not know the meaning of the codes. Presumably C = cultivated"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/723/UNCC-validate_rkp_bb_rkp.xlsx#Campus)"
|
40 |
41 |
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
|
41 |
42 |
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3,
|
42 |
43 |
collday,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
... | ... | |
75 |
76 |
collector2,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/3,
|
76 |
77 |
collector3,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/4,
|
77 |
78 |
collectno,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
|
78 |
|
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/2",Ignore other values
|
|
79 |
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/2/_alt/1",Ignore other values
|
|
80 |
campus,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/2/_alt/2/_map:[*=true]/value","""this refers to occurrence on the UNCC campus, but I do not know the meaning of the codes. Presumably C = cultivated"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/723/UNCC-validate_rkp_bb_rkp.xlsx#Campus)"
|
79 |
81 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/1",
|
80 |
82 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/2",
|
81 |
83 |
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",
|
... | ... | |
120 |
122 |
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
|
121 |
123 |
state,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
|
122 |
124 |
state,/location/locationplace/*_id/place/stateprovince,
|
123 |
|
campus,,"** No join mapping for *campus ** ""this refers to occurrence on the UNCC campus, but I do not know the meaning of the codes. Presumably C = cultivated"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/723/UNCC-validate_rkp_bb_rkp.xlsx#Campus)"
|
124 |
125 |
filler,,"** No join mapping for *filler ** Where used, same as family"
|
125 |
126 |
flower,,** No join mapping for *flower **
|
126 |
127 |
fruit,,** No join mapping for *fruit **
|
inputs/UNCC/Specimen/map.csv: campus: Mapped to cultivated, interpreting non-NULL values as true