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/_alt/1",Ignore other values
|
|
39 |
cultivated,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_alt/2/_alt/1/_map:[*=true]/value","For our purposes, anything non-NULL should be assumed to be cultivated"
|
40 |
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)"
|
41 |
41 |
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
|
42 |
42 |
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3,
|
... | ... | |
76 |
76 |
collector2,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/3,
|
77 |
77 |
collector3,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/4,
|
78 |
78 |
collectno,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
|
79 |
|
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/2/_alt/1",Ignore other values
|
|
79 |
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/2/_alt/1/_map:[*=true]/value","For our purposes, anything non-NULL should be assumed to be cultivated"
|
80 |
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)"
|
81 |
81 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/1",
|
82 |
82 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/2",
|
inputs/UNCC/Specimen/map.csv: cultivated: assume anything non-NULL to be cultivated, so that we err on the side of excluding possibly-cultivated specimens