Revision 7500
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/MT/Specimen/map.csv | ||
|---|---|---|
| 1 | 1 |
MT,VegCore,Filter,Comments |
| 2 |
id,occurrenceID,,
|
|
| 2 |
id,datasourceRecordID,,
|
|
| 3 | 3 |
establishmentMeans,establishmentMeans,, |
| 4 | 4 |
locality,locality,, |
| 5 | 5 |
language,language,, |
| inputs/MT/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
MT,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 |
id,"/_if[@name=""if specimen""]/cond/_exists", |
|
| 3 | 2 |
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1", |
| 4 | 3 |
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 5 | 4 |
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists", |
| ... | ... | |
| 7 | 6 |
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1", |
| 8 | 7 |
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2", |
| 9 | 8 |
rights,/location/accessconditions, |
| 10 |
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 11 | 9 |
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1, |
| 12 | 10 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 13 | 11 |
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name |
| inputs/TEAM/VL/map.csv | ||
|---|---|---|
| 1 | 1 |
TEAM,VegCore,Filter,Comments |
| 2 |
Id,occurrenceID,,
|
|
| 2 |
Id,datasourceRecordID,,
|
|
| 3 | 3 |
Observation Date,eventDate,, |
| 4 | 4 |
Family,family,, |
| 5 | 5 |
Genus,genus,, |
| inputs/TEAM/VL/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
TEAM,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 |
Id,"/_if[@name=""if specimen""]/cond/_exists", |
|
| 3 | 2 |
Subplot Number,"/location/_if[@name=""if subplot""]/cond/_exists", |
| 4 | 3 |
1ha Plot Number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1", |
| 5 | 4 |
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 6 | 5 |
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists", |
| 7 | 6 |
1ha Plot Number,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 8 | 7 |
Subplot Number,/location/authorlocationcode, |
| 9 |
Id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 10 | 8 |
Site Name,/location/locationevent/*_id/project/projectname, |
| 11 | 9 |
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists", |
| 12 | 10 |
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists", |
| inputs/TEAM/VT/map.csv | ||
|---|---|---|
| 1 | 1 |
TEAM,VegCore,Filter,Comments |
| 2 |
Id,occurrenceID,,
|
|
| 2 |
Id,datasourceRecordID,,
|
|
| 3 | 3 |
Observation Date,eventDate,, |
| 4 | 4 |
Family,family,, |
| 5 | 5 |
Genus,genus,, |
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
TEAM,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 |
Id,"/_if[@name=""if specimen""]/cond/_exists", |
|
| 3 | 2 |
Subplot Number,"/location/_if[@name=""if subplot""]/cond/_exists", |
| 4 | 3 |
1ha Plot Number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1", |
| 5 | 4 |
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 6 | 5 |
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists", |
| 7 | 6 |
1ha Plot Number,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 8 | 7 |
Subplot Number,/location/authorlocationcode, |
| 9 |
Id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 10 | 8 |
Site Name,/location/locationevent/*_id/project/projectname, |
| 11 | 9 |
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists", |
| 12 | 10 |
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists", |
| inputs/ACAD/Specimen/map.csv | ||
|---|---|---|
| 1 | 1 |
ACAD,VegCore,Filter,Comments |
| 2 |
id,occurrenceID,,
|
|
| 2 |
id,datasourceRecordID,,
|
|
| 3 | 3 |
basisOfRecord,basisOfRecord,, |
| 4 | 4 |
identifiedBy,identifiedBy,, |
| 5 | 5 |
collectionID,collectionID,, |
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
ACAD,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists", |
| 3 |
id,"/_if[@name=""if specimen""]/cond/_exists", |
|
| 4 | 3 |
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1", |
| 5 | 4 |
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 6 | 5 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists", |
| ... | ... | |
| 12 | 11 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else", |
| 13 | 12 |
rights,/location/accessconditions, |
| 14 | 13 |
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value", |
| 15 |
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 16 | 14 |
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 17 | 15 |
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1, |
| 18 | 16 |
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3, |
| inputs/WIN/Specimen/map.csv | ||
|---|---|---|
| 1 | 1 |
WIN,VegCore,Filter,Comments |
| 2 |
id,occurrenceID,,
|
|
| 2 |
id,datasourceRecordID,,
|
|
| 3 | 3 |
municipality,municipality,, |
| 4 | 4 |
verbatimLongitude,verbatimLongitude,, |
| 5 | 5 |
rightsHolder,rightsHolder,, |
| inputs/WIN/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
WIN,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists", |
| 3 |
id,"/_if[@name=""if specimen""]/cond/_exists", |
|
| 4 | 3 |
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1", |
| 5 | 4 |
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 6 | 5 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists", |
| ... | ... | |
| 13 | 12 |
rights,/location/accessconditions, |
| 14 | 13 |
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value", |
| 15 | 14 |
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min, |
| 16 |
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 17 | 15 |
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 18 | 16 |
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1, |
| 19 | 17 |
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3, |
| inputs/U/Specimen/map.csv | ||
|---|---|---|
| 1 | 1 |
U,VegCore,Filter,Comments |
| 2 |
ID,occurrenceID,,
|
|
| 2 |
ID,datasourceRecordID,,
|
|
| 3 | 3 |
Barcode,catalogNumber,, |
| 4 | 4 |
Collector,recordedBy,/_join/1, |
| 5 | 5 |
Prefix,UNUSED,, |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
U,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
Barcode,"/_if[@name=""if specimen""]/cond/_exists", |
| 3 |
ID,"/_if[@name=""if specimen""]/cond/_exists", |
|
| 4 | 3 |
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 5 | 4 |
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists", |
| 6 | 5 |
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists", |
| 7 | 6 |
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists", |
| 8 | 7 |
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else", |
| 9 |
ID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 10 | 8 |
Number,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 11 | 9 |
Gazetteer,"/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2/_join/1/_label[label=""gazetteer""]/value/_join/1", |
| 12 | 10 |
Newgazett,"/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2/_join/1/_label[label=""gazetteer""]/value/_join/2",Only used in 1 row |
| inputs/QFA/Specimen/map.csv | ||
|---|---|---|
| 1 | 1 |
QFA,VegCore,Filter,Comments |
| 2 |
id,occurrenceID,,
|
|
| 2 |
id,datasourceRecordID,,
|
|
| 3 | 3 |
rights,rights,, |
| 4 | 4 |
recordNumber,recordNumber,, |
| 5 | 5 |
family,family,, |
| inputs/QFA/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
QFA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists", |
| 3 |
id,"/_if[@name=""if specimen""]/cond/_exists", |
|
| 4 | 3 |
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1", |
| 5 | 4 |
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 6 | 5 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists", |
| ... | ... | |
| 12 | 11 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else", |
| 13 | 12 |
rights,/location/accessconditions, |
| 14 | 13 |
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value", |
| 15 |
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 16 | 14 |
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 17 | 15 |
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1, |
| 18 | 16 |
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3, |
| inputs/JBM/Specimen/map.csv | ||
|---|---|---|
| 1 | 1 |
JBM,VegCore,Filter,Comments |
| 2 |
id,occurrenceID,,
|
|
| 2 |
id,datasourceRecordID,,
|
|
| 3 | 3 |
minimumElevationInMeters,minimumElevationInMeters,, |
| 4 | 4 |
verbatimLatitude,verbatimLatitude,, |
| 5 | 5 |
modified,modified,, |
| inputs/JBM/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
JBM,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists", |
| 3 |
id,"/_if[@name=""if specimen""]/cond/_exists", |
|
| 4 | 3 |
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1", |
| 5 | 4 |
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 6 | 5 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists", |
| ... | ... | |
| 12 | 11 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else", |
| 13 | 12 |
rights,/location/accessconditions, |
| 14 | 13 |
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min, |
| 15 |
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 16 | 14 |
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 17 | 15 |
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1, |
| 18 | 16 |
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3, |
| inputs/UBC/Specimen/map.csv | ||
|---|---|---|
| 1 | 1 |
UBC,VegCore,Filter,Comments |
| 2 |
id,occurrenceID,,
|
|
| 2 |
id,datasourceRecordID,,
|
|
| 3 | 3 |
collectionCode,collectionCode,, |
| 4 | 4 |
identificationQualifier,identificationQualifier,, |
| 5 | 5 |
institutionID,institutionID,, |
| inputs/UBC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
UBC,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists", |
| 3 |
id,"/_if[@name=""if specimen""]/cond/_exists", |
|
| 4 | 3 |
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1", |
| 5 | 4 |
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 6 | 5 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists", |
| ... | ... | |
| 12 | 11 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else", |
| 13 | 12 |
rights,/location/accessconditions, |
| 14 | 13 |
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value", |
| 15 |
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 16 | 14 |
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 17 | 15 |
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1, |
| 18 | 16 |
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3, |
| inputs/HIBG/Specimen/map.csv | ||
|---|---|---|
| 1 | 1 |
HIBG,VegCore,Filter,Comments |
| 2 |
id,occurrenceID,,
|
|
| 2 |
id,datasourceRecordID,,
|
|
| 3 | 3 |
county,county,, |
| 4 | 4 |
dateIdentified,dateIdentified,, |
| 5 | 5 |
rightsHolder,rightsHolder,, |
| inputs/HIBG/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
HIBG,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists", |
| 3 |
id,"/_if[@name=""if specimen""]/cond/_exists", |
|
| 4 | 3 |
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1", |
| 5 | 4 |
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 6 | 5 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists", |
| ... | ... | |
| 12 | 11 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else", |
| 13 | 12 |
rights,/location/accessconditions, |
| 14 | 13 |
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value", |
| 15 |
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 16 | 14 |
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 17 | 15 |
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1, |
| 18 | 16 |
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3, |
| inputs/bien_web/observation/VegBIEN.csv | ||
|---|---|---|
| 50 | 50 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus, |
| 51 | 51 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 52 | 52 |
taxon,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname, |
| 53 |
traitName,/location/locationevent/taxonoccurrence/trait/name, |
|
| 54 |
traitValue,/location/locationevent/taxonoccurrence/trait/value, |
|
| 53 | 55 |
collectionNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then", |
| 54 | 56 |
latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 55 | 57 |
longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 59 | 61 |
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
| 60 | 62 |
country,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2, |
| 61 | 63 |
countyParish,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
| 64 |
isGeovalid,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_first/1, |
|
| 62 | 65 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
| 63 | 66 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
| 64 | 67 |
plotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists", |
| ... | ... | |
| 95 | 98 |
isCultivatedReason,,** No join mapping for cultivatedBasis ** |
| 96 | 99 |
isCultivatedReason_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 97 | 100 |
isCultivated_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 98 |
isGeovalid,,** No join mapping for isGeovalid ** |
|
| 99 | 101 |
isGeovalid_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 100 | 102 |
isNewWorld,,** No join mapping for isNewWorld ** |
| 101 | 103 |
isNewWorld_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 102 |
isValidLatLong,,** No join mapping for isValidLatLong **
|
|
| 104 |
isValidLatLong,,** No join mapping for latLongDomainValid **
|
|
| 103 | 105 |
isValidLatLong_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 104 | 106 |
localityDescription,,** No join mapping for *localityDescription ** |
| 105 | 107 |
observationID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| ... | ... | |
| 123 | 125 |
taxon_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 124 | 126 |
traitMethod,,** No join mapping for *traitMethod ** |
| 125 | 127 |
traitMethod_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 126 |
traitName,,** No join mapping for traitName ** |
|
| 127 | 128 |
traitName_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 128 | 129 |
traitUnit,,** No join mapping for *traitUnit ** |
| 129 | 130 |
traitUnit_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| 130 |
traitValue,,** No join mapping for traitValue ** |
|
| inputs/TRT/Specimen/map.csv | ||
|---|---|---|
| 1 | 1 |
TRT,VegCore,Filter,Comments |
| 2 |
id,occurrenceID,,
|
|
| 2 |
id,datasourceRecordID,,
|
|
| 3 | 3 |
maximumElevationInMeters,maximumElevationInMeters,, |
| 4 | 4 |
dateIdentified,dateIdentified,, |
| 5 | 5 |
specificEpithet,specificEpithet,, |
| inputs/TRT/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
TRT,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists", |
| 3 |
id,"/_if[@name=""if specimen""]/cond/_exists", |
|
| 4 | 3 |
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1", |
| 5 | 4 |
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 6 | 5 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists", |
| ... | ... | |
| 14 | 13 |
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value", |
| 15 | 14 |
maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max, |
| 16 | 15 |
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min, |
| 17 |
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 18 | 16 |
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 19 | 17 |
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1, |
| 20 | 18 |
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3, |
| inputs/TRTE/Specimen/map.csv | ||
|---|---|---|
| 1 | 1 |
TRTE,VegCore,Filter,Comments |
| 2 |
id,occurrenceID,,
|
|
| 2 |
id,datasourceRecordID,,
|
|
| 3 | 3 |
collectionCode,collectionCode,, |
| 4 | 4 |
genus,genus,, |
| 5 | 5 |
bibliographicCitation,bibliographicCitation,, |
| inputs/TRTE/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
TRTE,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists", |
| 3 |
id,"/_if[@name=""if specimen""]/cond/_exists", |
|
| 4 | 3 |
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname/_first/1", |
| 5 | 4 |
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1", |
| 6 | 5 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists", |
| ... | ... | |
| 12 | 11 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else", |
| 13 | 12 |
rights,/location/accessconditions, |
| 14 | 13 |
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value", |
| 15 |
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 16 | 14 |
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 17 | 15 |
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1, |
| 18 | 16 |
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3, |
Also available in: Unified diff
inputs/*/Specimen/map.csv: Remapped ID to datasourceRecordID