Project

General

Profile

« Previous | Next » 

Revision 3838

mappings/DwC1-DwC2.specimens.csv: Added source of datasources' custom terms

View differences:

inputs/MT/maps/VegBIEN.specimens.csv
6 6
institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/,11
7 7
establishmentMeans,"/location/locationevent/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/,30
8 8
establishmentMeans,"/location/locationevent/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/,30
9
id,/location/locationevent/specimenreplicate/sourceaccessioncode,"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",http://rs.tdwg.org/dwc/terms/,19
9
id,/location/locationevent/specimenreplicate/sourceaccessioncode,"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","ACAD, MT, QMOR, U; http://rs.tdwg.org/dwc/terms/",19
10 10
genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,http://rs.tdwg.org/dwc/terms/,147
11 11
family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,http://rs.tdwg.org/dwc/terms/,146
12 12
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/,68
13
id,/location/sourceaccessioncode/_alt/1,"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",http://rs.tdwg.org/dwc/terms/,19
13
id,/location/sourceaccessioncode/_alt/1,"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","ACAD, MT, QMOR, U; http://rs.tdwg.org/dwc/terms/",19
14 14
institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/,11
15 15
collectionCode,/location/sourceaccessioncode/_alt/2/_merge/2,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/,12
16 16
basisOfRecord,,** No non-empty join mapping for basisOfRecord ** 
inputs/UNCC/maps/VegBIEN.specimens.csv
1 1
UNCC[DwC],VegBIEN:,Comments,Source,Order
2 2
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/,66
3
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/,65
3
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,"NCU-NCSC, REMIB, UNCC; http://rs.tdwg.org/dwc/terms/",65
4 4
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,http://rs.tdwg.org/dwc/terms/,63
5 5
collday,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,11; 44
6 6
collmonth,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,10; 44
inputs/ACAD/maps/VegBIEN.specimens.csv
12 12
recordNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/,22
13 13
collectionID,/location/locationevent/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/,9
14 14
institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/,11
15
id,/location/locationevent/specimenreplicate/sourceaccessioncode,"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",http://rs.tdwg.org/dwc/terms/,19
15
id,/location/locationevent/specimenreplicate/sourceaccessioncode,"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","ACAD, MT, QMOR, U; http://rs.tdwg.org/dwc/terms/",19
16 16
dateIdentified,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,120
17 17
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,Brad: Bob: does this look correct for VegBank?,http://rs.tdwg.org/dwc/terms/,119
18 18
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,Brad: Bob: does this look correct for VegBank?,http://rs.tdwg.org/dwc/terms/,119
......
30 30
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/,23
31 31
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/,68
32 32
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",http://rs.tdwg.org/dwc/terms/,52
33
id,/location/sourceaccessioncode/_alt/1,"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",http://rs.tdwg.org/dwc/terms/,19
33
id,/location/sourceaccessioncode/_alt/1,"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","ACAD, MT, QMOR, U; http://rs.tdwg.org/dwc/terms/",19
34 34
institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/,11
35 35
collectionCode,/location/sourceaccessioncode/_alt/2/_merge/2,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/,12
36 36
catalogNumber,/location/sourceaccessioncode/_alt/2/_merge/3,"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",http://rs.tdwg.org/dwc/terms/,20
inputs/REMIB/maps/VegBIEN.specimens.csv
2 2
lat_deg,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
3 3
long_deg,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
4 4
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/,66
5
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/,65
5
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,"NCU-NCSC, REMIB, UNCC; http://rs.tdwg.org/dwc/terms/",65
6 6
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,http://rs.tdwg.org/dwc/terms/,63
7 7
coll_day,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,11; 44
8 8
coll_month,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,10; 44
inputs/NCU-NCSC/maps/VegBIEN.specimens.csv
3 3
Lat (-=S),"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,34; 81
4 4
Long (-=W),"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 82
5 5
County,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/,66
6
State,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/,65
6
State,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,"NCU-NCSC, REMIB, UNCC; http://rs.tdwg.org/dwc/terms/",65
7 7
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,http://rs.tdwg.org/dwc/terms/,63
8 8
Collect Date,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/3,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=bien2_staging&table=nybg_raw; http://rs.tdwg.org/dwc/terms/,29; 44
9 9
Collect Date,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/3,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=bien2_staging&table=nybg_raw; http://rs.tdwg.org/dwc/terms/,29; 44
inputs/QMOR/maps/VegBIEN.specimens.csv
21 21
collectionID,/location/locationevent/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/,9
22 22
sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/,26
23 23
institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/,11
24
id,/location/locationevent/specimenreplicate/sourceaccessioncode,"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",http://rs.tdwg.org/dwc/terms/,19
24
id,/location/locationevent/specimenreplicate/sourceaccessioncode,"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","ACAD, MT, QMOR, U; http://rs.tdwg.org/dwc/terms/",19
25 25
dateIdentified,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,120
26 26
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,Brad: Bob: does this look correct for VegBank?,http://rs.tdwg.org/dwc/terms/,119
27 27
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,Brad: Bob: does this look correct for VegBank?,http://rs.tdwg.org/dwc/terms/,119
......
39 39
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/,23
40 40
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/,68
41 41
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",http://rs.tdwg.org/dwc/terms/,52
42
id,/location/sourceaccessioncode/_alt/1,"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",http://rs.tdwg.org/dwc/terms/,19
42
id,/location/sourceaccessioncode/_alt/1,"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","ACAD, MT, QMOR, U; http://rs.tdwg.org/dwc/terms/",19
43 43
institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/,11
44 44
collectionCode,/location/sourceaccessioncode/_alt/2/_merge/2,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/,12
45 45
catalogNumber,/location/sourceaccessioncode/_alt/2/_merge/3,"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",http://rs.tdwg.org/dwc/terms/,20
mappings/for_review/DwC1-DwC2.specimens.csv
31 31
minimumDepth,minimumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,39
32 32
minimumElevation,minimumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,37
33 33
globalUniqueIdentifier,occurrenceID,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd,0
34
id,occurrenceID,,,
35
preparation,preparations,,,
34
id,occurrenceID,,"ACAD, MT, QMOR, U",
35
preparation,preparations,,REMIB,
36 36
preparationType,preparations,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,42
37 37
previousCatalogNumber,previousIdentifications,?,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,44
38 38
collectorNumber,recordNumber,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,7
......
42 42
relationshipType,relationshipOfResource,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,45
43 43
scientificNameAuthor,scientificNameAuthorship,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,50
44 44
species,specificEpithet,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,12
45
state,stateProvince,,,
45
state,stateProvince,,"NCU-NCSC, REMIB, UNCC",
46 46
remarks,taxonRemarks,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,65
47 47
latitude,verbatimLatitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,34
48 48
longitude,verbatimLongitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,33
mappings/DwC-VegBIEN.specimens.csv
41 41
verbatimLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
42 42
County,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/,66
43 43
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/,66
44
State,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/,65
44
State,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,"NCU-NCSC, REMIB, UNCC; http://rs.tdwg.org/dwc/terms/",65
45 45
StateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/,65
46
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/,65
46
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,"NCU-NCSC, REMIB, UNCC; http://rs.tdwg.org/dwc/terms/",65
47 47
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/,65
48 48
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,http://rs.tdwg.org/dwc/terms/,63
49 49
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,http://rs.tdwg.org/dwc/terms/,63
......
106 106
EstablishmentMeans,"/location/locationevent/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/,30
107 107
establishmentMeans,"/location/locationevent/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/,30
108 108
GlobalUniqueIdentifier,/location/locationevent/specimenreplicate/sourceaccessioncode,"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",http://rs.tdwg.org/dwc/tdwg_dw_core.xsd; http://rs.tdwg.org/dwc/terms/,0; 19
109
Id,/location/locationevent/specimenreplicate/sourceaccessioncode,"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",http://rs.tdwg.org/dwc/terms/,19
109
Id,/location/locationevent/specimenreplicate/sourceaccessioncode,"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","ACAD, MT, QMOR, U; http://rs.tdwg.org/dwc/terms/",19
110 110
OccurrenceID,/location/locationevent/specimenreplicate/sourceaccessioncode,"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",http://rs.tdwg.org/dwc/terms/,19
111 111
globalUniqueIdentifier,/location/locationevent/specimenreplicate/sourceaccessioncode,"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",http://rs.tdwg.org/dwc/tdwg_dw_core.xsd; http://rs.tdwg.org/dwc/terms/,0; 19
112
id,/location/locationevent/specimenreplicate/sourceaccessioncode,"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",http://rs.tdwg.org/dwc/terms/,19
112
id,/location/locationevent/specimenreplicate/sourceaccessioncode,"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","ACAD, MT, QMOR, U; http://rs.tdwg.org/dwc/terms/",19
113 113
occurrenceID,/location/locationevent/specimenreplicate/sourceaccessioncode,"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",http://rs.tdwg.org/dwc/terms/,19
114 114
DateIdentified/_alt,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,http://rs.tdwg.org/dwc/terms/,120
115 115
dateIdentified/_alt,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,http://rs.tdwg.org/dwc/terms/,120
......
174 174
Habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",http://rs.tdwg.org/dwc/terms/,52
175 175
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",http://rs.tdwg.org/dwc/terms/,52
176 176
GlobalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,"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",http://rs.tdwg.org/dwc/tdwg_dw_core.xsd; http://rs.tdwg.org/dwc/terms/,0; 19
177
Id,/location/sourceaccessioncode/_alt/1,"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",http://rs.tdwg.org/dwc/terms/,19
177
Id,/location/sourceaccessioncode/_alt/1,"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","ACAD, MT, QMOR, U; http://rs.tdwg.org/dwc/terms/",19
178 178
OccurrenceID,/location/sourceaccessioncode/_alt/1,"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",http://rs.tdwg.org/dwc/terms/,19
179 179
globalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,"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",http://rs.tdwg.org/dwc/tdwg_dw_core.xsd; http://rs.tdwg.org/dwc/terms/,0; 19
180
id,/location/sourceaccessioncode/_alt/1,"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",http://rs.tdwg.org/dwc/terms/,19
180
id,/location/sourceaccessioncode/_alt/1,"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","ACAD, MT, QMOR, U; http://rs.tdwg.org/dwc/terms/",19
181 181
occurrenceID,/location/sourceaccessioncode/_alt/1,"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",http://rs.tdwg.org/dwc/terms/,19
182 182
InstitutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/,11
183 183
institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/,11
......
441 441
parentNameUsage,,,http://rs.tdwg.org/dwc/terms/,136
442 442
parentNameUsageID,,,http://rs.tdwg.org/dwc/terms/,129
443 443
pointRadiusSpatialFit,,,http://rs.tdwg.org/dwc/terms/,90
444
preparation,,** No non-empty join mapping for preparations ** ,,
444
preparation,,** No non-empty join mapping for preparations ** ,REMIB,
445 445
preparationType,,** No non-empty join mapping for preparations ** ,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,42
446 446
preparations,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/,32
447 447
previousCatalogNumber,,** No non-empty join mapping for previousIdentifications ** ?,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,44
mappings/DwC1-DwC2.specimens.csv
31 31
minimumDepth,minimumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,39
32 32
minimumElevation,minimumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,37
33 33
globalUniqueIdentifier,occurrenceID,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd,0
34
id,occurrenceID,,,
35
preparation,preparations,,,
34
id,occurrenceID,,"ACAD, MT, QMOR, U",
35
preparation,preparations,,REMIB,
36 36
preparationType,preparations,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,42
37 37
previousCatalogNumber,previousIdentifications,?,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,44
38 38
collectorNumber,recordNumber/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,7
......
42 42
relationshipType,relationshipOfResource,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,45
43 43
scientificNameAuthor,scientificNameAuthorship,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,50
44 44
species,specificEpithet,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,12
45
state,stateProvince,,,
45
state,stateProvince,,"NCU-NCSC, REMIB, UNCC",
46 46
remarks,taxonRemarks,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,65
47 47
latitude,verbatimLatitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,34
48 48
longitude,verbatimLongitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,33
mappings/DwC.cs-VegBIEN.specimens.csv
20 20
longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 82
21 21
verbatimLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
22 22
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/,66
23
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/,65
23
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,"NCU-NCSC, REMIB, UNCC; http://rs.tdwg.org/dwc/terms/",65
24 24
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/,65
25 25
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,http://rs.tdwg.org/dwc/terms/,63
26 26
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",Brad: OMIT,http://rs.tdwg.org/dwc/terms/,59
......
53 53
establishmentMeans,"/location/locationevent/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/,30
54 54
establishmentMeans,"/location/locationevent/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/,30
55 55
globalUniqueIdentifier,/location/locationevent/specimenreplicate/sourceaccessioncode,"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",http://rs.tdwg.org/dwc/tdwg_dw_core.xsd; http://rs.tdwg.org/dwc/terms/,0; 19
56
id,/location/locationevent/specimenreplicate/sourceaccessioncode,"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",http://rs.tdwg.org/dwc/terms/,19
56
id,/location/locationevent/specimenreplicate/sourceaccessioncode,"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","ACAD, MT, QMOR, U; http://rs.tdwg.org/dwc/terms/",19
57 57
occurrenceID,/location/locationevent/specimenreplicate/sourceaccessioncode,"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",http://rs.tdwg.org/dwc/terms/,19
58 58
dateIdentified/_alt,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,http://rs.tdwg.org/dwc/terms/,120
59 59
dayIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,55; 120
......
87 87
verbatimLocality,/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",http://rs.tdwg.org/dwc/terms/,69
88 88
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",http://rs.tdwg.org/dwc/terms/,52
89 89
globalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,"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",http://rs.tdwg.org/dwc/tdwg_dw_core.xsd; http://rs.tdwg.org/dwc/terms/,0; 19
90
id,/location/sourceaccessioncode/_alt/1,"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",http://rs.tdwg.org/dwc/terms/,19
90
id,/location/sourceaccessioncode/_alt/1,"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","ACAD, MT, QMOR, U; http://rs.tdwg.org/dwc/terms/",19
91 91
occurrenceID,/location/sourceaccessioncode/_alt/1,"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",http://rs.tdwg.org/dwc/terms/,19
92 92
institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/,11
93 93
collectionCode,/location/sourceaccessioncode/_alt/2/_merge/2,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/,12
......
200 200
parentNameUsage,,,http://rs.tdwg.org/dwc/terms/,136
201 201
parentNameUsageID,,,http://rs.tdwg.org/dwc/terms/,129
202 202
pointRadiusSpatialFit,,,http://rs.tdwg.org/dwc/terms/,90
203
preparation,,** No non-empty join mapping for preparations ** ,,
203
preparation,,** No non-empty join mapping for preparations ** ,REMIB,
204 204
preparationType,,** No non-empty join mapping for preparations ** ,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,42
205 205
preparations,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/,32
206 206
previousCatalogNumber,,** No non-empty join mapping for previousIdentifications ** ?,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,44

Also available in: Unified diff