Project

General

Profile

« Previous | Next » 

Revision 915

Added by Aaron Marcuse-Kubitza almost 13 years ago

DwC mappings: Corrected mappings for CollectorNumber, individualID, recordNumber, and fieldNumber

View differences:

inputs/NYBG/test/DwC.specimens.xml.ref
14 14 
        <specificEpithet>estrellensis</specificEpithet>
15 15 
        <scientificNameAuthorship>(Raddi) Kuntze</scientificNameAuthorship>
16 16 
        <fieldNumber>9877</fieldNumber>
17 
        <georeferencedBy>R. B. Foster</georeferencedBy>
17 
        <recordedBy>R. B. Foster</recordedBy>
18 18 
        <eventDate>1984-08-20</eventDate>
19 19 
        <day>233</day>
20 20 
        <continent>South America</continent>
......
41 41 
        <phylum>Magnoliophyta (flowering plants)</phylum>
42 42 
        <family>Scrophulariaceae</family>
43 43 
        <fieldNumber>545</fieldNumber>
44 
        <georeferencedBy>J. B. Walker</georeferencedBy>
44 
        <recordedBy>J. B. Walker</recordedBy>
45 45 
        <eventDate>1994-01-17</eventDate>
46 46 
        <day>17</day>
47 47 
        <continent>Central America</continent>
inputs/NYBG/test/VegBIEN.specimens.xml.ref
151 151 
        </taxonoccurrence_id>
152 152 
        <reference_id><reference/></reference_id>
153 153 
        <sourceaccessioncode>816590</sourceaccessioncode>
154 
        <catalognumber_dwc>9877</catalognumber_dwc>
154 
        <catalognumber_dwc>00682023</catalognumber_dwc>
155 
        <collectionnumber>9877</collectionnumber>
155 156 
        <verbatimcollectorname>R. B. Foster</verbatimcollectorname>
156 157 
        <museum_id><party><organizationname>NY Herbarium</organizationname></party></museum_id>
157 158 
        <collectioncode_dwc>Herbarium</collectioncode_dwc>
......
237 238 
        </taxonoccurrence_id>
238 239 
        <reference_id><reference/></reference_id>
239 240 
        <sourceaccessioncode>220541</sourceaccessioncode>
240 
        <catalognumber_dwc>545</catalognumber_dwc>
241 
        <catalognumber_dwc>200996</catalognumber_dwc>
242 
        <collectionnumber>545</collectionnumber>
241 243 
        <verbatimcollectorname>J. B. Walker</verbatimcollectorname>
242 244 
        <museum_id><party><organizationname>NY Herbarium</organizationname></party></museum_id>
243 245 
        <collectioncode_dwc>Herbarium</collectioncode_dwc>
inputs/NYBG/maps/DwC.specimens.csv
21 21 
"DayIdentified","dateIdentified/_alt/2/_date/day",
22 22 
"IdentifiedDate","dateIdentified/_alt/1/_*/date",
23 23 
"TypeStatus","typeStatus",
24 
"CollectorNumber","individualID","?"
24 
"CollectorNumber","recordNumber",
25 25 
"FieldNumber","fieldNumber",
26 
"Collector","georeferencedBy","?"
26 
"Collector","recordedBy",
27 27 
"YearCollected","eventDate/_alt/2/_date/year",
28 28 
"MonthCollected","eventDate/_alt/2/_date/month",
29 29 
"DayCollected","eventDate/_alt/2/_date/day",
......
34 34 
"Country","country",
35 35 
"StateProvince","stateProvince",
36 36 
"County","county",
37 
"Locality","verbatimLocality","or locality?"
38 
"Longitude","verbatimLongitude","or decimalLongitude?"
39 
"Latitude","verbatimLatitude","or decimalLatitude?"
37 
"Locality","verbatimLocality",
38 
"Longitude","verbatimLongitude",
39 
"Latitude","verbatimLatitude",
40 40 
"CoordinatePrecision","coordinatePrecision",
41 41 
"BoundingBox",,
42 42 
"MinimumElevation","minimumElevationInMeters",
inputs/NYBG/maps/VegBIEN.specimens.csv
3 3 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
4 4 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
5 5 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
6 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/*_id/namedplace/placedescription/_alt/2,"or locality?; Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
7 
Latitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/reallatitude/_alt/2,or decimalLatitude?,81
8 
Longitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/reallongitude/_alt/2,or decimalLongitude?,82
6 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/*_id/namedplace/placedescription/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
7 
Latitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/reallatitude/_alt/2,,81
8 
Longitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/reallongitude/_alt/2,,82
9 9 
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
10 10 
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
11 11 
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/day,,44
......
33 33 
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
34 34 
Notes,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=notes]]:[@fkey=tableRecord_ID]/definedvalue","Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes",54
35 35 
UniqueNYInternalRecordNumber,"/{:[*_id/reference]/sourceaccessioncode,*_id/taxonoccurrence/aggregateoccurrence/*_id/plantobservation/authorplantcode}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
36 
FieldNumber,:[*_id/reference]/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
37 
CollectorNumber,:[*_id/reference]/collectornumber_dwc,"?; Brad: OMIT; db-specific element, not relevant to VB/VX",24
38 
Collector,:[*_id/reference]/verbatimcollectorname,?; Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
36 
CatalogNumber,:[*_id/reference]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
37 
CollectorNumber,:[*_id/reference]/collectionnumber/_alt/1,,22
38 
FieldNumber,:[*_id/reference]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
39 
Collector,:[*_id/reference]/verbatimcollectorname,,23
39 40 
InstitutionCode,:[*_id/reference]/{museum_id/party/organizationname/_name/first},,11
40 41 
CollectionCode,":[*_id/reference]/{museum_id/party/organizationname/_name/last,collectioncode_dwc}",Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
41 42 
BasisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
42 43 
BoundingBox,,
43 
CatalogNumber,,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
44 44 
CollectedDate,,** No join mapping for eventDate/_alt/1 **
45 45 
ContinentOcean,,Brad: OMIT,59
46 46 
DateLastModified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source.",1
mappings/for_review/DwC-VegBIEN.specimens.csv
39 39 
infraspecificEpithet,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname",,150
40 40 
fieldNotes,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=notes]]/definedvalue","Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes",54
41 41 
occurrenceID,"/{/sourceaccessioncode,*_id/taxonoccurrence/aggregateoccurrence/*_id/plantobservation/authorplantcode}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
42 
fieldNumber,/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
43 
individualID,/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
44 
georeferencedBy,/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
42 
catalogNumber,/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
43 
recordNumber,/collectionnumber/_alt/1,,22
44 
collectionID,/collectionnumber/_alt/2,,9
45 
fieldNumber,/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
46 
recordedBy,/verbatimcollectorname,,23
45 47 
institutionCode,/{museum_id/party/organizationname/_name/first},,11
46 48 
collectionCode,"/{museum_id/party/organizationname/_name/last,collectioncode_dwc}",Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
47 49 
acceptedNameUsage,,,135
......
54 56 
basisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
55 57 
bed,,,117
56 58 
behavior,,,29
57 
catalogNumber,,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
58 
collectionID,,,9
59 59 
continent,,Brad: OMIT,59
60 60 
coordinateUncertaintyInMeters,,,88
61 61 
countryCode,,,64
......
93 93 
georeferenceRemarks,,,99
94 94 
georeferenceSources,,,97
95 95 
georeferenceVerificationStatus,,,98
96 
georeferencedBy,,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
96 97 
georeferencedDate,,,95
97 98 
group,,,114
98 99 
higherClassification,,,141
......
105 106 
identificationRemarks,,,123
106 107 
identificationVerificationStatus,,,122
107 108 
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
109 
individualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
108 110 
informationWithheld,,,16
109 111 
institutionID,,,8
110 112 
island,,,62
......
152 154 
pointRadiusSpatialFit,,,90
153 155 
preparations,,Brad: OMIT,32
154 156 
previousIdentifications,,Brad: OMIT,35
155 
recordNumber,,,22
156 
recordedBy,,,23
157 157 
relatedResourceID,,Brad: OMIT,161
158 158 
relationshipAccordingTo,,,163
159 159 
relationshipEstablishedDate,,,164
mappings/DwC-VegBIEN.specimens.csv
39 39 
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
40 40 
fieldNotes,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=notes]]:[@fkey=tableRecord_ID]/definedvalue","Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes",54
41 41 
occurrenceID,"/{:[*_id/reference]/sourceaccessioncode,*_id/taxonoccurrence/aggregateoccurrence/*_id/plantobservation/authorplantcode}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
42 
fieldNumber,:[*_id/reference]/catalognumber_dwc,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
43 
individualID,:[*_id/reference]/collectornumber_dwc,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
44 
georeferencedBy,:[*_id/reference]/verbatimcollectorname,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
42 
catalogNumber,:[*_id/reference]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
43 
recordNumber,:[*_id/reference]/collectionnumber/_alt/1,,22
44 
collectionID,:[*_id/reference]/collectionnumber/_alt/2,,9
45 
fieldNumber,:[*_id/reference]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
46 
recordedBy,:[*_id/reference]/verbatimcollectorname,,23
45 47 
institutionCode,:[*_id/reference]/{museum_id/party/organizationname/_name/first},,11
46 48 
collectionCode,":[*_id/reference]/{museum_id/party/organizationname/_name/last,collectioncode_dwc}",Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
47 49 
acceptedNameUsage,,,135
......
54 56 
basisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
55 57 
bed,,,117
56 58 
behavior,,,29
57 
catalogNumber,,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
58 
collectionID,,,9
59 59 
continent,,Brad: OMIT,59
60 60 
coordinateUncertaintyInMeters,,,88
61 61 
countryCode,,,64
......
93 93 
georeferenceRemarks,,,99
94 94 
georeferenceSources,,,97
95 95 
georeferenceVerificationStatus,,,98
96 
georeferencedBy,,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
96 97 
georeferencedDate,,,95
97 98 
group,,,114
98 99 
higherClassification,,,141
......
105 106 
identificationRemarks,,,123
106 107 
identificationVerificationStatus,,,122
107 108 
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
109 
individualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
108 110 
informationWithheld,,,16
109 111 
institutionID,,,8
110 112 
island,,,62
......
152 154 
pointRadiusSpatialFit,,,90
153 155 
preparations,,Brad: OMIT,32
154 156 
previousIdentifications,,Brad: OMIT,35
155 
recordNumber,,,22
156 
recordedBy,,,23
157 157 
relatedResourceID,,Brad: OMIT,161
158 158 
relationshipAccordingTo,,,163
159 159 
relationshipEstablishedDate,,,164

Also available in: Unified diff