Project

General

Profile

« Previous | Next » 

Revision 4905

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/*/*/map.csv: Remapped latitude/longitude to decimalLatitude/Longitude because these fields almost always have units of decimal degrees

View differences:

inputs/XAL/Specimen/map.csv
32 32 
darwin:StateProvince,stateProvince,,
33 33 
darwin:County,county,,
34 34 
darwin:Locality,locality,,
35 
darwin:Longitude,verbatimLongitude,,
36 
darwin:Latitude,verbatimLatitude,,
35 
darwin:Longitude,decimalLongitude,,
36 
darwin:Latitude,decimalLatitude,,
37 37 
darwin:CoordinatePrecision,coordinatePrecision,,
38 38 
darwin:MinimumElevation,minimumElevationInMeters,,
39 39 
darwin:MaximumElevation,maximumElevationInMeters,,
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/2/_nullIf:[null=0,type=float]/value",
9 
darwin:Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
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",
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/XAL/Specimen/new_terms.csv
31 31 
darwin:StateProvince,stateProvince,,
32 32 
darwin:County,county,,
33 33 
darwin:Locality,locality,,
34 
darwin:Longitude,verbatimLongitude,,
35 
darwin:Latitude,verbatimLatitude,,
34 
darwin:Longitude,decimalLongitude,,
35 
darwin:Latitude,decimalLatitude,,
36 36 
darwin:CoordinatePrecision,coordinatePrecision,,
37 37 
darwin:MinimumElevation,minimumElevationInMeters,,
38 38 
darwin:MaximumElevation,maximumElevationInMeters,,
inputs/TEAM/VL/map.csv
14 14 
Comments,Comments,,
15 15 
Data Level,Data Level,,
16 16 
Sampling Unit Name,Sampling Unit Name,,
17 
Latitude,verbatimLatitude,,
18 
Longitude,verbatimLongitude,,
17 
Latitude,decimalLatitude,,
18 
Longitude,decimalLongitude,,
19 19 
Method,samplingProtocol,,
20 20 
Subplot Number,subplot,,
21 21 
1ha Plot X Coordinate,organismX,,
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/2/_nullIf:[null=0,type=float]/value",
8 
Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
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",
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/map.csv
14 14 
Comments,Comments,,
15 15 
Data Level,Data Level,,
16 16 
Sampling Unit Name,Sampling Unit Name,,
17 
Latitude,verbatimLatitude,,
18 
Longitude,verbatimLongitude,,
17 
Latitude,decimalLatitude,,
18 
Longitude,decimalLongitude,,
19 19 
Spatial Method,samplingProtocol,,
20 20 
Subplot Number,subplot,,
21 21 
1ha Plot X Coordinate,organismX,,
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/2/_nullIf:[null=0,type=float]/value",
8 
Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
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",
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/map.csv
2 2 
Site Name,projectName,,
3 3 
Name,plotName,,
4 4 
1ha Plot Coordinate,1ha Plot Coordinate,,
5 
Longitude,verbatimLongitude,,
6 
Latitude,verbatimLatitude,,
5 
Longitude,decimalLongitude,,
6 
Latitude,decimalLatitude,,
7 7 
CollectionDate,eventDate,,
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/2/_nullIf:[null=0,type=float]/value",
5 
Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
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",
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/map.csv
33 33 
StateProvince,stateProvince,,
34 34 
County,county,,
35 35 
Locality,locality,/_join/1,
36 
Longitude,verbatimLongitude,,
37 
Latitude,verbatimLatitude,,
36 
Longitude,decimalLongitude,,
37 
Latitude,decimalLatitude,,
38 38 
CoordinatePrecision,coordinatePrecision,,
39 39 
BoundingBox,footprintWKT,,
40 40 
MinimumElevation,minimumElevationInMeters,/_nullIf:[null=.]/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/2/_nullIf:[null=0,type=float]/value",
11 
Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
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",
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/CTFS/Plot/map.csv
3 3 
PlotID,locationID,,
4 4 
PlotName,plotName,,
5 5 
LocationName,locality,,
6 
Latitude,verbatimLatitude,,
7 
Longitude,verbatimLongitude,,
6 
Latitude,decimalLatitude,,
7 
Longitude,decimalLongitude,,
8 8 
Elevation,elevationInMeters,,"Assuming units are m based on the range of values [1] and the country the data is from (Panama). Not documented in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/CTFS/_src/ctfs-comments_worksheet.xls>.
9 9 

  		




  10
  10
  
    
[1] Using the following query:


  		












  

    
      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/2/_nullIf:[null=0,type=float]/value",


  		




  19
  
  
    
Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",


  		




  
  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",


  		




  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/NCU-NCSC/Specimen/map.csv
    
  





  9
  9
  
    
County,county,,


  		




  10
  10
  
    
Cultivated?,cultivated,,


  		




  11
  11
  
    
Elevation,verbatimElevation,,


  		




  12
  
  
    
Lat (-=S),verbatimLatitude,"/_replace:[""\?$""=]/value",


  		




  13
  
  
    
Long (-=W),verbatimLongitude,"/_replace:[""\?$""=]/value",


  		




  
  12
  
    
Lat (-=S),decimalLatitude,"/_replace:[""\?$""=]/value",


  		




  
  13
  
    
Long (-=W),decimalLongitude,"/_replace:[""\?$""=]/value",


  		




  14
  14
  
    
Accuracy,coordinateUncertaintyInMeters,,


  		




  15
  15
  
    
FIPS,FIPS,,FIPS county code


  		




  16
  16
  
    
Alt N/S,Alt N/S,,


  		












  

    
      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/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",


  		




  8
  
  
    
Long (-=W),"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",


  		




  
  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",


  		




  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/NCU-NCSC/Specimen/new_terms.csv
    
  





  3
  3
  
    
Barcode,catalogNumber,,


  		




  4
  4
  
    
Full Taxon Name,scientificName,,


  		




  5
  5
  
    
Collect Date,dateCollected,,


  		




  6
  
  
    
Lat (-=S),verbatimLatitude,"/_replace:[""\?$""=]/value",


  		




  7
  
  
    
Long (-=W),verbatimLongitude,"/_replace:[""\?$""=]/value",


  		




  
  6
  
    
Lat (-=S),decimalLatitude,"/_replace:[""\?$""=]/value",


  		




  
  7
  
    
Long (-=W),decimalLongitude,"/_replace:[""\?$""=]/value",


  		




  8
  8
  
    
Accuracy,coordinateUncertaintyInMeters,,


  		




  9
  9
  
    
Format,preparations,,


  		




  10
  10
  
    
Typology,typeStatus,,


  		












  

    
      inputs/MO/Specimen/map.csv
    
  





  23
  23
  
    
StateProvince,stateProvince,,


  		




  24
  24
  
    
County,county,,


  		




  25
  25
  
    
Locality,locality,,


  		




  26
  
  
    
longitude,verbatimLongitude,,


  		




  27
  
  
    
latitude,verbatimLatitude,,


  		




  
  26
  
    
longitude,decimalLongitude,,


  		




  
  27
  
    
latitude,decimalLatitude,,


  		




  28
  28
  
    
MinimumElevation,minimumElevationInMeters,,


  		




  29
  29
  
    
MaximumElevation,maximumElevationInMeters,,


  		




  30
  30
  
    
IndividualCount,individualCount,,


  		












  

    
      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/2/_nullIf:[null=0,type=float]/value",


  		




  8
  
  
    
longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",


  		




  
  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",


  		




  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_/map.csv
    
  





  8
  8
  
    
locationaccuracy,coordinateUncertaintyInMeters,,


  		




  9
  9
  
    
confidentialitystatus,confidentialitystatus,,


  		




  10
  10
  
    
confidentialityreason,confidentialityreason,,


  		




  11
  
  
    
latitude,verbatimLatitude,,


  		




  12
  
  
    
longitude,verbatimLongitude,,


  		




  
  11
  
    
latitude,decimalLatitude,,


  		




  
  12
  
    
longitude,decimalLongitude,,


  		




  13
  13
  
    
authore,authore,,


  		




  14
  14
  
    
authorn,authorn,,


  		




  15
  15
  
    
authorzone,authorzone,,


  		












  

    
      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/2/_nullIf:[null=0,type=float]/value",


  		




  13
  
  
    
longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",


  		




  
  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",


  		




  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",


  		












Also available in:  Unified diff