PermafrostNet PermafrostNet ERDDAP
Easier access to scientific data 		log in    
Brought to you by PermafrostNet, and The Digital Research Alliance of Canada    

ERDDAP > tabledap > Data Access Form ?

Dataset Title:  Aggregated borehole profiles Subscribe RSS
Institution:  Various institutions   (Dataset ID: all_geotech)
Information:  Summary ? | License ? | FGDC | ISO 19115 | Metadata | Background (external link) | Subset | Files | Make a graph
 
Variable ?   Optional
Constraint #1 ? 		Optional
Constraint #2 ? 		   Minimum ?
   or a List of Values ? 		   Maximum ?
 
 latitude (degrees_north) ?          59.88666    9.96921E36
  < slider >
 longitude (degrees_east) ?          -140.9982    9.96921E36
  < slider >
 profile (Unique profile identifier) ?          "017-01"    "TP5617"
 surface_elevation (Ground surface elevation, m) ?          -1.5    9.96921E36
 time (Date of measurement, UTC) ?          1970-11-09T12:00:00Z    2031-05-20T12:00:00Z
  < slider >
 platform_name (Borehole or site name) ?      
   - +  ?
 depth_below_ground_surface (m) ?          -0.2    9.96921E36
 top_of_interval (Depth to top of interval, m) ?          -0.4    9.96921E36
 bottom_of_interval (Depth to bottom of interval, m) ?          0.0    9.96921E36
 sand (Sand content (by mass), percent) ?          0.0    9.96921E36
 silt (Silt content (by mass), percent) ?          0.0    9.96921E36
 clay (Clay content (by mass), percent) ?          0.0    9.96921E36
 gravel (percent) ?          0.0    9.96921E36
 organic (percent) ?          5.85    9.96921E36
 excess_ice ?          0.0    100.0
 ground_ice_class ?      
   - +  ?
 liquid_limit (Atterberg liquid limit, percent) ?          0.0    9.96921E36
 plastic_limit (percent) ?          0.0    9.96921E36
 gravimetric_moisture (percent) ?          0.0    9.96921E36
 soil_ph ?          1.1    9.7
 materials (Material classification) ?      
   - +  ?
 materials_description ?          "\r\nwater up to 2.5m..."    "zone of thick hori..."
 bulk_density (Bulk density of soil, kg m-3) ?          1200.0    9.96921E36
 dry_density (kg m-3) ?          2097.0    9.96921E36
 publisher_name ?      
   - +  ?
 
Server-side Functions ?
 distinct() ?
? ("Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.Hover here to see a list of options. Click on an option to select it.")

File type: (more information)

(Documentation / Bypass this form ? )
 
(Please be patient. It may take a while to get the data.)


 

The Dataset Attribute Structure (.das) for this Dataset

Attributes {
 s {
  latitude {
    String _CoordinateAxisType "Lat";
    Float32 _FillValue NaN;
    Float32 actual_range 59.88666, 9.96921e+36;
    String axis "Y";
    String ioos_category "Location";
    String long_name "Latitude";
    String standard_name "latitude";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/latitude";
    String units "degrees_north";
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float32 _FillValue NaN;
    Float32 actual_range -140.9982, 9.96921e+36;
    String axis "X";
    String ioos_category "Location";
    String long_name "Longitude";
    String standard_name "longitude";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/longitude";
    String units "degrees_east";
  }
  profile {
    String cf_role "profile_id";
    String ioos_category "Identifier";
    String long_name "Unique profile identifier";
  }
  surface_elevation {
    Float32 _FillValue NaN;
    Float32 actual_range -1.5, 9.96921e+36;
    String ioos_category "Location";
    String long_name "Ground surface elevation";
    String standard_name "height_above_reference_ellipsoid";
    String units "m";
  }
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 2.7e+7, 1.9370448e+9;
    String axis "T";
    String calendar "standard";
    String ioos_category "Time";
    String long_name "Date of measurement";
    String standard_name "time";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/time";
    String time_origin "01-JAN-1970 00:00:00";
    String units "seconds since 1970-01-01T00:00:00Z";
  }
  platform_name {
    String ioos_category "Identifier";
    String long_name "Borehole or site name";
    String standard_name "platform_name";
  }
  depth_below_ground_surface {
    Int32 _ChunkSizes 512;
    String _CoordinateAxisType "Height";
    Float32 _FillValue NaN;
    Float32 actual_range -0.2, 9.96921e+36;
    String axis "Z";
    String bounds "depth_bounds";
    String ioos_category "Location";
    String long_name "Depth to midpoint of interval";
    String positive "down";
    String standard_name "depth";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/depth";
    String units "m";
  }
  top_of_interval {
    Int32 _ChunkSizes 512;
    Float32 _FillValue NaN;
    Float32 actual_range -0.4, 9.96921e+36;
    String ioos_category "Location";
    String long_name "Depth to top of interval";
    String positive "down";
    String standard_name "depth";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/depth";
    String units "m";
  }
  bottom_of_interval {
    Int32 _ChunkSizes 512;
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 9.96921e+36;
    String ioos_category "Location";
    String long_name "Depth to bottom of interval";
    String positive "down";
    String standard_name "depth";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/depth";
    String units "m";
  }
  sand {
    Int32 _ChunkSizes 10;
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 9.96921e+36;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Other";
    String long_name "Sand content (by mass)";
    String standard_name "mass_fraction_of_sand_in_soil";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/mass_fraction_of_sand_in_soil";
    String units "percent";
    Float32 valid_max 100.0;
    Float32 valid_min 0.0;
  }
  silt {
    Int32 _ChunkSizes 10;
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 9.96921e+36;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Other";
    String long_name "Silt content (by mass)";
    String standard_name "mass_fraction_of_silt_in_soil";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/mass_fraction_of_silt_in_soil";
    String units "percent";
    Float32 valid_max 100.0;
    Float32 valid_min 0.0;
  }
  clay {
    Int32 _ChunkSizes 10;
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 9.96921e+36;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Other";
    String long_name "Clay content (by mass)";
    String standard_name "mass_fraction_of_clay_in_soil";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/mass_fraction_of_clay_in_soil";
    String units "percent";
    Float32 valid_max 100.0;
    Float32 valid_min 0.0;
  }
  gravel {
    Int32 _ChunkSizes 10;
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 9.96921e+36;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Other";
    String long_name "Gravel content (by mass)";
    String standard_name "mass_fraction_of_gravel_in_soil";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/mass_fraction_of_gravel_in_soil";
    String units "percent";
    Float32 valid_max 100.0;
    Float32 valid_min 0.0;
  }
  organic {
    Int32 _ChunkSizes 10;
    Float32 _FillValue NaN;
    Float32 actual_range 5.85, 9.96921e+36;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Other";
    String long_name "Organic content (by mass)";
    String standard_name "mass_fraction_of_organic_matter_in_soil";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/mass_fraction_of_organic_matter_in_soil";
    String units "percent";
    Float32 valid_max 100.0;
    Float32 valid_min 0.0;
  }
  excess_ice {
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 100.0;
  }
  ground_ice_class {
  }
  liquid_limit {
    Int32 _ChunkSizes 10;
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 9.96921e+36;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Other";
    String long_name "Atterberg liquid limit";
    String units "percent";
    Float32 valid_max 100.0;
    Float32 valid_min 0.0;
  }
  plastic_limit {
    Int32 _ChunkSizes 10;
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 9.96921e+36;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Other";
    String long_name "Atterberg plastic limit";
    String units "percent";
    Float32 valid_max 100.0;
    Float32 valid_min 0.0;
  }
  gravimetric_moisture {
    Int32 _ChunkSizes 10;
    Float32 _FillValue NaN;
    Float32 actual_range 0.0, 9.96921e+36;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Other";
    String long_name "Gravimetric moisture content";
    String units "percent";
    Float32 valid_min 0.0;
  }
  soil_ph {
    Float32 _FillValue NaN;
    Float32 actual_range 1.1, 9.7;
  }
  materials {
    Int32 _ChunkSizes 10;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Other";
    String long_name "Material classification";
  }
  materials_description {
    Int32 _ChunkSizes 10;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Other";
    String long_name "Material description";
  }
  bulk_density {
    Int32 _ChunkSizes 10;
    Float32 _FillValue NaN;
    Float32 actual_range 1200.0, 9.96921e+36;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Other";
    String long_name "Bulk density of soil";
    String units "kg m-3";
    Float32 valid_min 0.0;
  }
  dry_density {
    Int32 _ChunkSizes 10;
    Float32 _FillValue NaN;
    Float32 actual_range 2097.0, 9.96921e+36;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Other";
    String long_name "Bulk density of dried soil";
    String units "kg m-3";
    Float32 valid_min 0.0;
  }
  publisher_name {
    String comment "Corresponds to ACDD global metadata variable (publisher_name) for associated dataset";
    String long_name "Name of original data publisher";
  }
 }
  NC_GLOBAL {
    String _NCProperties "version=2,netcdf=4.9.0,hdf5=1.12.2";
    String cdm_altitude_proxy "depth_below_ground_surface";
    String cdm_data_type "Profile";
    String cdm_profile_variables "profile";
    String Conventions "CF-1.6, ACDD-1.3";
    Float64 creator_institution NaN;
    Float64 Easternmost_Easting 9.96921e+36;
    String featureType "Profile";
    String geospatial_bounds "POINT(-139.43896484375 64.058837890625)";
    Float64 geospatial_lat_max 9.96921e+36;
    Float64 geospatial_lat_min 59.88666;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max 9.96921e+36;
    Float64 geospatial_lon_min -140.9982;
    String geospatial_lon_units "degrees_east";
    String history 
"2024-11-24T16:53:45Z (local files)
2024-11-24T16:53:45Z http://data.permafrostnet.ca/erddap/tabledap/all_geotech.html";
    String id "bh_ygs_85842_gint_1847_77";
    String infoUrl "https://data.permafrostnet.ca";
    String institution "Various institutions";
    String keywords "permafrost";
    String keywords_vocabulary "https://www.polardata.ca/pdcinput/public/keywordlibrary";
    String license 
"The data may be used and redistributed for free but is not intended
for legal use, since it may contain inaccuracies. Neither the data
Contributor, ERD, NOAA, nor the United States Government, nor any
of their employees or contractors, makes any warranty, express or
implied, including warranties of merchantability and fitness for a
particular purpose, or assumes any legal liability for the accuracy,
completeness, or usefulness, of this information.";
    Float64 Northernmost_Northing 9.96921e+36;
    String platform_name "GINT_1847-77-24";
    String project_id "11-1847";
    String publisher_email "ygs-surficial@yukon.ca";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 59.88666;
    String standard_name_vocabulary "CF Standard Name Table v78";
    String subsetVariables "platform_name,ground_ice_class,materials,publisher_name";
    String summary "An aggregation of all borehole profile data on this ERDDAP.";
    String time_coverage_end "2031-05-20T12:00:00Z";
    String time_coverage_start "1970-11-09T12:00:00Z";
    String title "Aggregated borehole profiles";
    Float64 Westernmost_Easting -140.9982;
  }
}

 

Using tabledap to Request Data and Graphs from Tabular Datasets

tabledap lets you request a data subset, a graph, or a map from a tabular dataset (for example, buoy data), via a specially formed URL. tabledap uses the OPeNDAP (external link) Data Access Protocol (DAP) (external link) and its selection constraints (external link).

The URL specifies what you want: the dataset, a description of the graph or the subset of the data, and the file type for the response.

Tabledap request URLs must be in the form
https://coastwatch.pfeg.noaa.gov/erddap/tabledap/datasetID.fileType{?query}
For example,
https://coastwatch.pfeg.noaa.gov/erddap/tabledap/pmelTaoDySst.htmlTable?longitude,latitude,time,station,wmo_platform_code,T_25&time>=2015-05-23T12:00:00Z&time<=2015-05-31T12:00:00Z
Thus, the query is often a comma-separated list of desired variable names, followed by a collection of constraints (e.g., variable<value), each preceded by '&' (which is interpreted as "AND").

For details, see the tabledap Documentation.


 
ERDDAP, Version 2.18
Disclaimers | Privacy Policy | Contact