Project

General

Profile

« Previous | Next » 

Revision 3836

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/DwC1-DwC2.specimens.csv: Added source of custom NY staging table terms in nimoy.bien2_staging.nybg_raw

View differences:

inputs/NCU-NCSC/maps/VegBIEN.specimens.csv
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 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
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 
Collect Date,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/3,,http://rs.tdwg.org/dwc/terms/,44
9 
Collect Date,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/3,,http://rs.tdwg.org/dwc/terms/,44
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 
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
10 10 
Barcode,/location/locationevent/specimenreplicate/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",http://rs.tdwg.org/dwc/terms/,20
11 11 
SeriesName,/location/locationevent/specimenreplicate/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,http://rs.tdwg.org/dwc/terms/,12
12 12 
Cultivated?,"/location/locationevent/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value/_map:[Yes=cultivated,No=wild]/value",,http://rs.tdwg.org/dwc/terms/,30
mappings/for_review/DwC1-DwC2.specimens.csv
5 5 
monthIdentified,dateIdentified,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,54
6 6 
yearIdentified,dateIdentified,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,53
7 7 
dateIdentified,dateIdentified,,http://rs.tdwg.org/dwc/terms/,120
8 
identifiedDate,dateIdentified,,,
8 
identifiedDate,dateIdentified,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=bien2_staging&table=nybg_raw,21
9 9 
julianDay,day,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,15
10 10 
accessRights,dcterms:accessRights,Versions without namespace,http://rs.tdwg.org/dwc/terms/,5
11 11 
bibliographicCitation,dcterms:bibliographicCitation,Versions without namespace,http://rs.tdwg.org/dwc/terms/,6
......
21 21 
monthCollected,eventDate,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,10
22 22 
yearCollected,eventDate,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,9
23 23 
eventDate,eventDate,,http://rs.tdwg.org/dwc/terms/,44
24 
collectedDate,eventDate,,,
24 
collectedDate,eventDate,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=bien2_staging&table=nybg_raw,29
25 25 
timeOfDay,eventTime,,,
26 26 
notes,fieldNotes,,,
27 27 
boundingBox,footprintWKT,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,33
mappings/DwC-VegBIEN.specimens.csv
61 61 
yearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,9; 44
62 62 
EventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,44
63 63 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,44
64 
CollectedDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/3,,http://rs.tdwg.org/dwc/terms/,44
65 
collectedDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/3,,http://rs.tdwg.org/dwc/terms/,44
64 
CollectedDate,/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
65 
collectedDate,/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
66 66 
EventDate/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/,44
67 67 
eventDate/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/,44
68 68 
DayCollected,"/location/locationevent/obsstartdate/_*/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/,11; 44
......
73 73 
yearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,9; 44
74 74 
EventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,44
75 75 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,44
76 
CollectedDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/3,,http://rs.tdwg.org/dwc/terms/,44
77 
collectedDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/3,,http://rs.tdwg.org/dwc/terms/,44
76 
CollectedDate,/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
77 
collectedDate,/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
78 78 
CatalogNumber,/location/locationevent/specimenreplicate/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",http://rs.tdwg.org/dwc/terms/,20
79 79 
catalogNumber,/location/locationevent/specimenreplicate/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",http://rs.tdwg.org/dwc/terms/,20
80 80 
CollectionCode,/location/locationevent/specimenreplicate/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,http://rs.tdwg.org/dwc/terms/,12
......
121 121 
yearIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,53; 120
122 122 
DateIdentified,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,120
123 123 
dateIdentified,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,120
124 
IdentifiedDate,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,http://rs.tdwg.org/dwc/terms/,120
125 
identifiedDate,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,http://rs.tdwg.org/dwc/terms/,120
124 
IdentifiedDate,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/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/,21; 120
125 
identifiedDate,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/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/,21; 120
126 126 
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
127 127 
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
128 128 
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
mappings/DwC1-DwC2.specimens.csv
5 5 
monthIdentified,"dateIdentified/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,54
6 6 
yearIdentified,"dateIdentified/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,53
7 7 
dateIdentified,dateIdentified/_alt/2,,http://rs.tdwg.org/dwc/terms/,120
8 
identifiedDate,dateIdentified/_alt/3,,,
8 
identifiedDate,dateIdentified/_alt/3,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=bien2_staging&table=nybg_raw,21
9 9 
julianDay,day,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,15
10 10 
accessRights,dcterms:accessRights,Versions without namespace,http://rs.tdwg.org/dwc/terms/,5
11 11 
bibliographicCitation,dcterms:bibliographicCitation,Versions without namespace,http://rs.tdwg.org/dwc/terms/,6
......
21 21 
monthCollected,"eventDate/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,10
22 22 
yearCollected,"eventDate/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,9
23 23 
eventDate,eventDate/_alt/2,,http://rs.tdwg.org/dwc/terms/,44
24 
collectedDate,eventDate/_alt/3,,,
24 
collectedDate,eventDate/_alt/3,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=bien2_staging&table=nybg_raw,29
25 25 
timeOfDay,eventTime,,,
26 26 
notes,fieldNotes,,,
27 27 
boundingBox,footprintWKT,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,33
mappings/DwC.cs-VegBIEN.specimens.csv
30 30 
monthCollected,"/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
31 31 
yearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,9; 44
32 32 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,44
33 
collectedDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/3,,http://rs.tdwg.org/dwc/terms/,44
33 
collectedDate,/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
34 34 
eventDate/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/,44
35 35 
dayCollected,"/location/locationevent/obsstartdate/_*/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/,11; 44
36 36 
monthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/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
37 37 
yearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,9; 44
38 38 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,44
39 
collectedDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/3,,http://rs.tdwg.org/dwc/terms/,44
39 
collectedDate,/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
40 40 
catalogNumber,/location/locationevent/specimenreplicate/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",http://rs.tdwg.org/dwc/terms/,20
41 41 
collectionCode,/location/locationevent/specimenreplicate/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,http://rs.tdwg.org/dwc/terms/,12
42 42 
collectorNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,7; 22
......
60 60 
monthIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/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/,54; 120
61 61 
yearIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,53; 120
62 62 
dateIdentified,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,120
63 
identifiedDate,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,http://rs.tdwg.org/dwc/terms/,120
63 
identifiedDate,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/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/,21; 120
64 64 
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
65 65 
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
66 66 
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,Brad: Bob: does this look correct for VegBank?,http://rs.tdwg.org/dwc/terms/,119

Also available in: Unified diff