Project

General

Profile

« Previous | Next » 

Revision 2184

Added by Aaron Marcuse-Kubitza over 12 years ago

Mapped some unmapped fields in DwC inputs

View differences:

inputs/U/maps/DwC.specimens.csv
13 13 
cf,IdentificationQualifier,
14 14 
Detby,IdentifiedBy,
15 15 
Detyy,YearIdentified,
16 
Gazetteer,,
17 
Newgazett,,
16 
Gazetteer,"VerbatimLocality/_merge/1/_label[label=""gazetteer""]/value/_merge/1",
17 
Newgazett,"VerbatimLocality/_merge/1/_label[label=""gazetteer""]/value/_merge/2",Only used in 1 row
18 18 
Majorarea,,
19 
Locnotes,VerbatimLocality,
19 
Locnotes,VerbatimLocality/_merge/2,
20 20 
Coorsyst,,
21 21 
Lat,DecimalLatitude,
22 22 
NS,,
inputs/U/maps/DwC.specimens.full.csv
16 16 
Notes,Notes
17 17 
Number,RecordNumber,
18 18 
Phenology,ReproductiveCondition,
19 
Locnotes,VerbatimLocality,
19 
Gazetteer,"VerbatimLocality/_merge/1/_label[label=""gazetteer""]/value/_merge/1",
20 
Newgazett,"VerbatimLocality/_merge/1/_label[label=""gazetteer""]/value/_merge/2",Only used in 1 row
21 
Locnotes,VerbatimLocality/_merge/2,
20 22 
Collyy,YearCollected,
21 23 
Detyy,YearIdentified,
22 24 
Alt,,What is this?
......
24 26 
Coorsyst,,
25 27 
DateInfo,,Not used
26 28 
EW,,
27 
Gazetteer,,
28 29 
Majorarea,,
29 30 
NS,,
30 
Newgazett,,
31 31 
Prefix,,Not used
32 32 
Suffix,,Not used
inputs/U/maps/VegBIEN.specimens.csv
1 1 
U[DwC],VegBIEN:/specimenreplicate,Comments,Order
2 2 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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,63
3 
Locnotes,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
3 
Gazetteer,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/1","Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
4 
Newgazett,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/2","Only used in 1 row; Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
5 
Locnotes,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
4 6 
Ecology,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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?",52
5 7 
Lat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_toDouble/value/_alt/1/_nullIf:[null=0,type=float]/value",,85
6 8 
Long,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_toDouble/value/_alt/1/_nullIf:[null=0,type=float]/value",,86
......
22 24 
Coorsyst,,** No input mapping for Coorsyst **
23 25 
DateInfo,,Not used
24 26 
EW,,** No input mapping for EW **
25 
Gazetteer,,** No input mapping for Gazetteer **
26 27 
Majorarea,,** No input mapping for Majorarea **
27 28 
NS,,** No input mapping for NS **
28 
Newgazett,,** No input mapping for Newgazett **
29 29 
Phenology,,** No non-empty join mapping for ReproductiveCondition **
30 30 
Prefix,,Not used
31 31 
Suffix,,Not used
inputs/NCU-NCSC/maps/DwC.specimens.csv
13 13 
Alt N/S,,
14 14 
Alt E/W,,
15 15 
Format,PreparationType,
16 
Typology,,
16 
Typology,typeStatus,
inputs/NCU-NCSC/maps/DwC.specimens.full.csv
13 13 
Elevation,VerbatimElevation,
14 14 
Cultivated?,"establishmentMeans/_map:[Yes=cultivated,No=wild]/value",
15 15 
Accession Number,occurrenceID,
16 
Typology,typeStatus,
16 17 
Alt E/W,,
17 18 
Alt N/S,,
18 19 
FIPS,,FIPS county code
19 
Typology,,
inputs/NCU-NCSC/maps/VegBIEN.specimens.csv
16 16 
Elevation,,** No non-empty join mapping for VerbatimElevation **
17 17 
FIPS,,FIPS county code
18 18 
Format,,** No non-empty join mapping for PreparationType **
19 
Typology,,** No input mapping for Typology **
19 
Typology,,** No non-empty join mapping for typeStatus **
inputs/MO/maps/DwC.specimens.csv
1 1 
MO[DwC],DwC:/list/,Comments
2 
convertednotes,,
2 
convertednotes,notes,
inputs/MO/maps/DwC.specimens.full.csv
27 27 
genus,genus
28 28 
latitude,latitude
29 29 
longitude,longitude
30 
notes,notes
30 
convertednotes,notes,
31 31 
species,species
32 
convertednotes,,
inputs/MO/maps/VegBIEN.specimens.csv
21 21 
Kingdom,"/*_id/taxonoccurrence/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,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142
22 22 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
23 23 
CollectionCode,/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
24 
notes,/description/_merge/1,,
24 
convertednotes,/description/_merge/1,,
25 25 
CatalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/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
26 26 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/1,,22
27 27 
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
......
29 29 
IndividualCount,,** No non-empty join mapping for IndividualCount **
30 30 
InstitutionCode,,** No non-empty join mapping for InstitutionCode **
31 31 
TypeStatus,,** No non-empty join mapping for TypeStatus **
32 
convertednotes,,** No input mapping for convertednotes **

Also available in: Unified diff