Project

General

Profile

« Previous | Next » 

Revision 4080

Added by Aaron Marcuse-Kubitza over 12 years ago

inputs/SpeciesLink/maps/DwC.specimens.csv: Remapped fieldNumber to recordNumber because term usage was inconsistent with DwC definition. Datasources often confuse this term, because it seems like the collection number, but is actually the author code for the event (VegBank's authorObsCode).

View differences:

inputs/SpeciesLink/test/import.specimens.xml.ref
274 274 
            </namedplace_id>
275 275 
        </locationdetermination>
276 276 
        <locationevent>
277 
            <authoreventcode>
278 
                <_alt>
279 
                    <0>$dwc_curatorial_FieldNumber</0>
280 
                    <1>$conceptual_darwin_2003_1_0_FieldNumber</1>
281 
                    <2>$dwc_terms_fieldNumber</2>
282 
                </_alt>
283 
            </authoreventcode>
284 277 
            <obsenddate>
285 278 
                <_date>
286 279 
                    <date>
......
395 388 
                                        <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
396 389 
                                    </_alt>
397 390 
                                </1>
398 
                                <2>$dwc_terms_recordNumber</2>
391 
                                <2>
392 
                                    <_alt>
393 
                                        <1>$dwc_terms_recordNumber</1>
394 
                                        <2>
395 
                                            <_alt>
396 
                                                <0>$dwc_curatorial_FieldNumber</0>
397 
                                                <1>$conceptual_darwin_2003_1_0_FieldNumber</1>
398 
                                                <2>$dwc_terms_fieldNumber</2>
399 
                                            </_alt>
400 
                                        </2>
401 
                                    </_alt>
402 
                                </2>
399 403 
                            </_alt>
400 404 
                        </collectionnumber>
401 405 
                        <definedvalue fkey="tablerecord_id">
......
458 462 
                                        <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
459 463 
                                    </_alt>
460 464 
                                </1>
461 
                                <2>$dwc_terms_recordNumber</2>
465 
                                <2>
466 
                                    <_alt>
467 
                                        <1>$dwc_terms_recordNumber</1>
468 
                                        <2>
469 
                                            <_alt>
470 
                                                <0>$dwc_curatorial_FieldNumber</0>
471 
                                                <1>$conceptual_darwin_2003_1_0_FieldNumber</1>
472 
                                                <2>$dwc_terms_fieldNumber</2>
473 
                                            </_alt>
474 
                                        </2>
475 
                                    </_alt>
476 
                                </2>
462 477 
                            </_alt>
463 478 
                        </1>
464 479 
                        <2>
inputs/SpeciesLink/maps/DwC.specimens.csv
3 3 
ScientificNameAuthor,ScientificNameAuthor,`union` would otherwise remove this input name because it's been mapped to (renamed) above
4 4 
DayOfYear,JulianDay,
5 5 
JulianDay,JulianDay,`union` would otherwise remove this input name because it's been mapped to (renamed) above
6 
FieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
7 
-----
8 
SELECT count(*) FROM ""SpeciesLink"".specimens
9 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
10 
-----"
11 
recordNumber,recordNumber/_alt/1,`union` would otherwise remove this input name because it's been mapped to (renamed) above
12 
fieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
13 
-----
14 
SELECT count(*) FROM ""SpeciesLink"".specimens
15 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
16 
-----"
6 17 
dc_terms_modified,dcterms:modified,
inputs/SpeciesLink/maps/DwC.specimens.full.csv
17 17 
DecimalLatitude,DecimalLatitude
18 18 
DecimalLongitude,DecimalLongitude
19 19 
Family,Family
20 
FieldNumber,FieldNumber
21 20 
Genus,Genus
22 21 
GlobalUniqueIdentifier,GlobalUniqueIdentifier
23 22 
IdentifiedBy,IdentifiedBy
......
79 78 
endDayOfYear,endDayOfYear
80 79 
eventTime,eventTime
81 80 
family,family
82 
fieldNumber,fieldNumber
83 81 
genus,genus
84 82 
identifiedBy,identifiedBy
85 83 
individualCount,individualCount
......
97 95 
otherCatalogNumbers,otherCatalogNumbers
98 96 
phylum,phylum
99 97 
preparations,preparations
100 
recordNumber,recordNumber
98 
recordNumber,recordNumber/_alt/1,`union` would otherwise remove this input name because it's been mapped to (renamed) above
99 
FieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
100 
-----
101 
SELECT count(*) FROM ""SpeciesLink"".specimens
102 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
103 
-----"
104 
fieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
105 
-----
106 
SELECT count(*) FROM ""SpeciesLink"".specimens
107 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
108 
-----"
101 109 
recordedBy,recordedBy
102 110 
scientificName,scientificName
103 111 
scientificNameAuthorship,scientificNameAuthorship
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
44 44 
Continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
45 45 
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
46 46 
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
47 
FieldNumber,/location/locationevent/authoreventcode,
48 
fieldNumber,/location/locationevent/authoreventcode,
49 47 
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
50 48 
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
51 49 
YearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
......
59 57 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
60 58 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
61 59 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
62 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,
60 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2/_alt/1,`union` would otherwise remove this input name because it's been mapped to (renamed) above
61 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
62 
-----
63 
SELECT count(*) FROM ""SpeciesLink"".specimens
64 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
65 
-----"
66 
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
67 
-----
68 
SELECT count(*) FROM ""SpeciesLink"".specimens
69 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
70 
-----"
63 71 
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"
64 72 
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"
65 73 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
......
71 79 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
72 80 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
73 81 
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
74 
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,
82 
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2/_alt/1,`union` would otherwise remove this input name because it's been mapped to (renamed) above
83 
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
84 
-----
85 
SELECT count(*) FROM ""SpeciesLink"".specimens
86 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
87 
-----"
88 
fieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
89 
-----
90 
SELECT count(*) FROM ""SpeciesLink"".specimens
91 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
92 
-----"
75 93 
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2,
76 94 
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2,
77 95 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,

Also available in: Unified diff