Revision 4907
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 5 | 5 |
darwin:MaximumElevation,/location/elevation_m/_alt/2/_avg/max, |
| 6 | 6 |
darwin:MinimumElevation,/location/elevation_m/_alt/2/_avg/min, |
| 7 | 7 |
darwin:CoordinatePrecision,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/2, |
| 8 |
darwin:Latitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 9 |
darwin:Longitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 8 |
darwin:Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 9 |
darwin:Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 10 | 10 |
darwin:DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 11 | 11 |
darwin:MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 12 | 12 |
darwin:YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/TEAM/VL/VegBIEN.csv | ||
|---|---|---|
| 4 | 4 |
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 5 | 5 |
1ha Plot Number,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 6 | 6 |
Subplot Number,/location/authorlocationcode, |
| 7 |
Latitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 8 |
Longitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 7 |
Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 8 |
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 9 | 9 |
Method,/location/locationevent/*_id/method/name, |
| 10 | 10 |
Site Name,/location/locationevent/*_id/project/projectname, |
| 11 | 11 |
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 4 | 4 |
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 5 | 5 |
1ha Plot Number,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 6 | 6 |
Subplot Number,/location/authorlocationcode, |
| 7 |
Latitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 8 |
Longitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 7 |
Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 8 |
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 9 | 9 |
Spatial Method,/location/locationevent/*_id/method/name, |
| 10 | 10 |
Site Name,/location/locationevent/*_id/project/projectname, |
| 11 | 11 |
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| inputs/TEAM/TEAM_Sites/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
TEAM,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
Name,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1", |
| 3 | 3 |
Name,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 4 |
Latitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 5 |
Longitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 4 |
Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 5 |
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 6 | 6 |
Site Name,/location/locationevent/*_id/project/projectname, |
| 7 | 7 |
Name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
| 8 | 8 |
CollectionDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value, |
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 7 | 7 |
MinimumElevation,/location/elevation_m/_alt/2/_avg/min/_nullIf:[null=.]/value, |
| 8 | 8 |
CoordinatePrecision,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/2, |
| 9 | 9 |
BoundingBox,/location/locationcoords/footprintgeometry_dwc, |
| 10 |
Latitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 11 |
Longitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 10 |
Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 11 |
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 12 | 12 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 13 | 13 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 14 | 14 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/Madidi/Plot/VegBIEN.csv | ||
|---|---|---|
| 57 | 57 |
----- |
| 58 | 58 |
[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>" |
| 59 | 59 |
Topographical situation,/location/landform, |
| 60 |
Latitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 61 |
Longitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 60 |
Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 61 |
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 62 | 62 |
Latitude (DMS),/location/locationcoords/verbatimlatitude, |
| 63 | 63 |
Longitude (DMS),/location/locationcoords/verbatimlongitude, |
| 64 | 64 |
Expedition name,/location/locationevent/*_id/project/projectname,Consistent (globally unique) between PPM and PT data |
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 5 | 5 |
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/2", |
| 6 | 6 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else", |
| 7 | 7 |
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value", |
| 8 |
decimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 9 |
decimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 8 |
decimalLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 9 |
decimalLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 10 | 10 |
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value, |
| 11 | 11 |
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value, |
| 12 | 12 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber, |
| inputs/SALVIAS-CSV/Plot/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
elev_m,/location/elevation_m/_alt/1,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick. |
| 9 | 9 |
elev_max_m,/location/elevation_m/_alt/2/_avg/max, |
| 10 | 10 |
elev_min_m,/location/elevation_m/_alt/2/_avg/min, |
| 11 |
lat_decimal,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 12 |
long_decimal,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 11 |
lat_decimal,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 12 |
long_decimal,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 13 | 13 |
plot_methodology,/location/locationevent/*_id/method/name, |
| 14 | 14 |
project,/location/locationevent/*_id/project/projectname, |
| 15 | 15 |
plot_code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| inputs/CVS/Organism/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
CVS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
authorObsCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else", |
| 3 | 3 |
locationAccuracy-m,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1, |
| 4 |
publicLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 5 |
publicLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 4 |
publicLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 5 |
publicLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 6 | 6 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode", |
| 7 | 7 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
| 8 | 8 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
| inputs/REMIB/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
REMIB,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
accession_number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 3 | 3 |
acronym,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1", |
| 4 |
lat_deg,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 5 |
long_deg,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 4 |
lat_deg,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 5 |
long_deg,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 6 | 6 |
coll_day,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 7 | 7 |
coll_month,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 8 | 8 |
coll_year,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/CTFS/Plot/VegBIEN.csv | ||
|---|---|---|
| 15 | 15 |
ORDER BY ""Elevation""::real DESC |
| 16 | 16 |
-----" |
| 17 | 17 |
ShapeOfSite,/location/locationcoords/footprintgeometry_dwc, |
| 18 |
Latitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 19 |
Longitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 18 |
Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 19 |
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 20 | 20 |
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
| 21 | 21 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
| 22 | 22 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists", |
| inputs/FIA/Organism/VegBIEN.csv | ||
|---|---|---|
| 2 | 2 |
PlotCD,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists", |
| 3 | 3 |
PlotCD,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 4 | 4 |
PlotCD,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| 5 |
DecimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 6 |
DecimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 5 |
DecimalLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 6 |
DecimalLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 7 | 7 |
PlotCD,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
| 8 | 8 |
MeasDay,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 9 | 9 |
MeasMon,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| inputs/SALVIAS/plotMetadata/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
Elev,/location/elevation_m/_alt/1,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick. |
| 9 | 9 |
elev_max_m,/location/elevation_m/_alt/2/_avg/max, |
| 10 | 10 |
elev_min_m,/location/elevation_m/_alt/2/_avg/min, |
| 11 |
LatDec,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 12 |
LongDec,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 11 |
LatDec,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 12 |
LongDec,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 13 | 13 |
PlotMethod,/location/locationevent/*_id/method/name, |
| 14 | 14 |
project_id,/location/locationevent/*_id/project/sourceaccessioncode, |
| 15 | 15 |
SiteCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
U,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 3 | 3 |
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else", |
| 4 |
Lat,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 5 |
Long,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 4 |
Lat,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 5 |
Long,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 6 | 6 |
Colldd,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 7 | 7 |
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 8 | 8 |
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
MinimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,"Contains some verbatim values, including ranges and units" |
| 9 | 9 |
CoordinateUncertaintyInMeters,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1, |
| 10 | 10 |
BoundingBox,/location/locationcoords/footprintgeometry_dwc, |
| 11 |
DecimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 12 |
DecimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 11 |
DecimalLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 12 |
DecimalLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 13 | 13 |
VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date/_alt/0, |
| 14 | 14 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 15 | 15 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 4 | 4 |
CatalogNO,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else", |
| 5 | 5 |
MaximumElevationInMeter,/location/elevation_m/_alt/2/_avg/max, |
| 6 | 6 |
MinimumElevationInMeter,/location/elevation_m/_alt/2/_avg/min, |
| 7 |
VerbatimLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 8 |
VerbatimLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 7 |
VerbatimLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 8 |
VerbatimLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 9 | 9 |
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date, |
| 10 | 10 |
CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 11 | 11 |
CollectionCD,/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/NCU-NCSC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 4 | 4 |
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else", |
| 5 | 5 |
Elevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value", |
| 6 | 6 |
Accuracy,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1, |
| 7 |
Lat (-=S),"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
|
|
| 8 |
Long (-=W),"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
|
|
| 7 |
Lat (-=S),"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
|
| 8 |
Long (-=W),"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
|
| 9 | 9 |
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date, |
| 10 | 10 |
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 11 | 11 |
SeriesName,/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/SpeciesLink/Specimen/VegBIEN.csv | ||
|---|---|---|
| 19 | 19 |
dwc_terms_coordinateUncertaintyInMeters,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1, |
| 20 | 20 |
conceptual_darwin_2003_1_0_CoordinatePrecision,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/2, |
| 21 | 21 |
conceptual_darwin_2003_1_0_BoundingBox,/location/locationcoords/footprintgeometry_dwc, |
| 22 |
conceptual_darwin_2003_1_0_Latitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 23 |
dwc_geospatial_DecimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 24 |
dwc_terms_decimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 25 |
dwc_geospatial_VerbatimLatitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",Contains a mix of DMS and other verbatim coordinates
|
|
| 26 |
dwc_terms_verbatimLatitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 27 |
conceptual_darwin_2003_1_0_Longitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 28 |
dwc_geospatial_DecimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 29 |
dwc_terms_decimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 30 |
dwc_geospatial_VerbatimLongitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",Contains a mix of DMS and other verbatim coordinates
|
|
| 31 |
dwc_terms_verbatimLongitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 22 |
conceptual_darwin_2003_1_0_Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 23 |
dwc_geospatial_DecimalLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 24 |
dwc_terms_decimalLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 25 |
conceptual_darwin_2003_1_0_Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 26 |
dwc_geospatial_DecimalLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 27 |
dwc_terms_decimalLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 28 |
dwc_geospatial_VerbatimLatitude,/location/locationcoords/verbatimlatitude,Contains a mix of DMS and other verbatim coordinates
|
|
| 29 |
dwc_terms_verbatimLatitude,/location/locationcoords/verbatimlatitude,
|
|
| 30 |
dwc_geospatial_VerbatimLongitude,/location/locationcoords/verbatimlongitude,Contains a mix of DMS and other verbatim coordinates
|
|
| 31 |
dwc_terms_verbatimLongitude,/location/locationcoords/verbatimlongitude,
|
|
| 32 | 32 |
conceptual_darwin_2003_1_0_DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 33 | 33 |
conceptual_darwin_2003_1_0_MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 34 | 34 |
conceptual_darwin_2003_1_0_YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 70 | 70 |
</coordsaccuracy_deg> |
| 71 | 71 |
<footprintgeometry_dwc>$conceptual_darwin_2003_1_0_BoundingBox</footprintgeometry_dwc> |
| 72 | 72 |
<latitude_deg> |
| 73 |
<_alt> |
|
| 74 |
<1> |
|
| 75 |
<_nullIf> |
|
| 76 |
<null>0</null> |
|
| 77 |
<type>float</type> |
|
| 78 |
<value> |
|
| 79 |
<_alt> |
|
| 80 |
<0>$conceptual_darwin_2003_1_0_Latitude</0> |
|
| 81 |
<1>$dwc_geospatial_DecimalLatitude</1> |
|
| 82 |
<2>$dwc_terms_decimalLatitude</2> |
|
| 83 |
</_alt> |
|
| 84 |
</value> |
|
| 85 |
</_nullIf> |
|
| 86 |
</1> |
|
| 87 |
<2> |
|
| 88 |
<_nullIf> |
|
| 89 |
<null>0</null> |
|
| 90 |
<type>float</type> |
|
| 91 |
<value> |
|
| 92 |
<_alt> |
|
| 93 |
<0>$dwc_geospatial_VerbatimLatitude</0> |
|
| 94 |
<1>$dwc_terms_verbatimLatitude</1> |
|
| 95 |
</_alt> |
|
| 96 |
</value> |
|
| 97 |
</_nullIf> |
|
| 98 |
</2> |
|
| 99 |
</_alt> |
|
| 73 |
<_nullIf> |
|
| 74 |
<null>0</null> |
|
| 75 |
<type>float</type> |
|
| 76 |
<value> |
|
| 77 |
<_alt> |
|
| 78 |
<0>$conceptual_darwin_2003_1_0_Latitude</0> |
|
| 79 |
<1>$dwc_geospatial_DecimalLatitude</1> |
|
| 80 |
<2>$dwc_terms_decimalLatitude</2> |
|
| 81 |
</_alt> |
|
| 82 |
</value> |
|
| 83 |
</_nullIf> |
|
| 100 | 84 |
</latitude_deg> |
| 101 | 85 |
<longitude_deg> |
| 86 |
<_nullIf> |
|
| 87 |
<null>0</null> |
|
| 88 |
<type>float</type> |
|
| 89 |
<value> |
|
| 90 |
<_alt> |
|
| 91 |
<0>$conceptual_darwin_2003_1_0_Longitude</0> |
|
| 92 |
<1>$dwc_geospatial_DecimalLongitude</1> |
|
| 93 |
<2>$dwc_terms_decimalLongitude</2> |
|
| 94 |
</_alt> |
|
| 95 |
</value> |
|
| 96 |
</_nullIf> |
|
| 97 |
</longitude_deg> |
|
| 98 |
<verbatimlatitude> |
|
| 102 | 99 |
<_alt> |
| 103 |
<1> |
|
| 104 |
<_nullIf> |
|
| 105 |
<null>0</null> |
|
| 106 |
<type>float</type> |
|
| 107 |
<value> |
|
| 108 |
<_alt> |
|
| 109 |
<0>$conceptual_darwin_2003_1_0_Longitude</0> |
|
| 110 |
<1>$dwc_geospatial_DecimalLongitude</1> |
|
| 111 |
<2>$dwc_terms_decimalLongitude</2> |
|
| 112 |
</_alt> |
|
| 113 |
</value> |
|
| 114 |
</_nullIf> |
|
| 115 |
</1> |
|
| 116 |
<2> |
|
| 117 |
<_nullIf> |
|
| 118 |
<null>0</null> |
|
| 119 |
<type>float</type> |
|
| 120 |
<value> |
|
| 121 |
<_alt> |
|
| 122 |
<0>$dwc_geospatial_VerbatimLongitude</0> |
|
| 123 |
<1>$dwc_terms_verbatimLongitude</1> |
|
| 124 |
</_alt> |
|
| 125 |
</value> |
|
| 126 |
</_nullIf> |
|
| 127 |
</2> |
|
| 100 |
<0>$dwc_geospatial_VerbatimLatitude</0> |
|
| 101 |
<1>$dwc_terms_verbatimLatitude</1> |
|
| 128 | 102 |
</_alt> |
| 129 |
</longitude_deg> |
|
| 103 |
</verbatimlatitude> |
|
| 104 |
<verbatimlongitude> |
|
| 105 |
<_alt> |
|
| 106 |
<0>$dwc_geospatial_VerbatimLongitude</0> |
|
| 107 |
<1>$dwc_terms_verbatimLongitude</1> |
|
| 108 |
</_alt> |
|
| 109 |
</verbatimlongitude> |
|
| 130 | 110 |
</locationcoords> |
| 131 | 111 |
<locationevent> |
| 132 | 112 |
<taxonoccurrence> |
| inputs/MO/Specimen/VegBIEN.csv | ||
|---|---|---|
| 4 | 4 |
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else", |
| 5 | 5 |
MaximumElevation,/location/elevation_m/_alt/2/_avg/max, |
| 6 | 6 |
MinimumElevation,/location/elevation_m/_alt/2/_avg/min, |
| 7 |
latitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 8 |
longitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 7 |
latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 8 |
longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 9 | 9 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 10 | 10 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 11 | 11 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/VegBank/plot_/VegBIEN.csv | ||
|---|---|---|
| 9 | 9 |
landform,/location/landform, |
| 10 | 10 |
locationaccuracy,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1, |
| 11 | 11 |
shape,/location/locationcoords/footprintgeometry_dwc, |
| 12 |
latitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 13 |
longitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 12 |
latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 13 |
longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 14 | 14 |
authorplotcode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
| 15 | 15 |
plot_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
| 16 | 16 |
authorplotcode,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists", |
| inputs/QMOR/Specimen/VegBIEN.csv | ||
|---|---|---|
| 9 | 9 |
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min, |
| 10 | 10 |
coordinateUncertaintyInMeters,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1, |
| 11 | 11 |
footprintWKT,/location/locationcoords/footprintgeometry_dwc, |
| 12 |
decimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 13 |
decimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 12 |
decimalLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 13 |
decimalLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 14 | 14 |
verbatimLatitude,/location/locationcoords/verbatimlatitude, |
| 15 | 15 |
verbatimLongitude,/location/locationcoords/verbatimlongitude, |
| 16 | 16 |
samplingProtocol,/location/locationevent/*_id/method/name, |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 28 | 28 |
coordinateUncertaintyInMeters,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1, |
| 29 | 29 |
coordinatePrecision,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/2, |
| 30 | 30 |
footprintWKT,/location/locationcoords/footprintgeometry_dwc, |
| 31 |
decimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 32 |
verbatimLatitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 33 |
decimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 34 |
verbatimLongitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 31 |
decimalLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 32 |
decimalLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 35 | 33 |
latitude_DMS,/location/locationcoords/verbatimlatitude, |
| 34 |
verbatimLatitude,/location/locationcoords/verbatimlatitude, |
|
| 36 | 35 |
longitude_DMS,/location/locationcoords/verbatimlongitude, |
| 36 |
verbatimLongitude,/location/locationcoords/verbatimlongitude, |
|
| 37 | 37 |
samplingProtocol,/location/locationevent/*_id/method/name, |
| 38 | 38 |
projectName,/location/locationevent/*_id/project/projectname, |
| 39 | 39 |
projectID,/location/locationevent/*_id/project/sourceaccessioncode, |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 29 | 29 |
coordinatePrecision,//locationcoords/coordsaccuracy_deg, |
| 30 | 30 |
footprintWKT,//locationcoords/footprintgeometry_dwc, |
| 31 | 31 |
decimalLatitude,//locationcoords/latitude_deg, |
| 32 |
verbatimLatitude,//locationcoords/latitude_deg, |
|
| 33 | 32 |
decimalLongitude,//locationcoords/longitude_deg, |
| 34 |
verbatimLongitude,//locationcoords/longitude_deg, |
|
| 35 | 33 |
latitude_DMS,//locationcoords/verbatimlatitude, |
| 34 |
verbatimLatitude,//locationcoords/verbatimlatitude, |
|
| 36 | 35 |
longitude_DMS,//locationcoords/verbatimlongitude, |
| 36 |
verbatimLongitude,//locationcoords/verbatimlongitude, |
|
| 37 | 37 |
samplingProtocol,//method/name, |
| 38 | 38 |
projectName,//project/projectname, |
| 39 | 39 |
projectID,//project/sourceaccessioncode, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: Remapped verbatimLatitude/Longitude to locationcoords.verbatimlatitude/longitude because these fields now contain only non-decimal coordinates. This involves removing the _alt suffix on decimalLatitude/Longitude, which causes the VegBIEN.csvs to change.