ERDDAP > tabledap > Data Access Form

Dataset Title:	Stratigraphy and ground ice content of borehole 77:2/8-3 on Amund Ringnes Island, Nunavut, Canada
Institution:	Geological Survey of Canada   (Dataset ID: Hodgson_1982_44779_20972)
Information:	Summary | License | FGDC | ISO 19115 | Metadata | Background | Files | Make a graph

 

Variable	Optional Constraint #1		Optional Constraint #2		Minimum	Maximum
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		77.9242	77.9242
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-96.66144	-96.66144
profile (Unique profile identifier)	!= =~ <= >= = < >		!= =~ <= >= = < >		"Hodgson_1982_44779..."	"Hodgson_1982_44779..."
surface_elevation (Ground surface elevation, m)	!= =~ <= >= = < >		!= =~ <= >= = < >		9.96921E36	9.96921E36
time (Date of measurement, UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		1977-08-02T00:00:00Z	1977-08-02T00:00:00Z
platform_name (Borehole or site name)	!= =~ <= >= = < >		!= =~ <= >= = < >		"44779.20972"	"44779.20972"
depth_below_ground_surface (m)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.175	1.2
top_of_interval (Depth to top of interval, m)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	1.0
bottom_of_interval (Depth to bottom of interval, m)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.35	1.4
sand (Sand content (by mass), percent)	!= =~ <= >= = < >		!= =~ <= >= = < >
silt (Silt content (by mass), percent)	!= =~ <= >= = < >		!= =~ <= >= = < >
clay (Clay content (by mass), percent)	!= =~ <= >= = < >		!= =~ <= >= = < >
gravel (percent)	!= =~ <= >= = < >		!= =~ <= >= = < >
excess_ice (Excess ice content, percent)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	1.0
ground_ice_class (Ground ice classification)	!= =~ <= >= = < >		!= =~ <= >= = < >		"Ice"	"Nf"
liquid_limit (Atterberg liquid limit, percent)	!= =~ <= >= = < >		!= =~ <= >= = < >
plastic_limit (percent)	!= =~ <= >= = < >		!= =~ <= >= = < >
soil_ph (Soil water pH)	!= =~ <= >= = < >		!= =~ <= >= = < >
materials (Material classification)	!= =~ <= >= = < >		!= =~ <= >= = < >		"Fines sand"	"Shale"
geo_unit (Geological Unit)	!= =~ <= >= = < >		!= =~ <= >= = < >		"Marine deposits - ..."	"Marine deposits - ..."

 

Server-side Functions

distinct()

orderBy orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" latitude longitude profile surface_elevation time platform_name depth_below_ground_surface top_of_interval bottom_of_interval sand silt clay gravel excess_ice ground_ice_class liquid_limit plastic_limit soil_ph materials geo_unit latitude longitude profile surface_elevation time platform_name depth_below_ground_surface top_of_interval bottom_of_interval sand silt clay gravel excess_ice ground_ice_class liquid_limit plastic_limit soil_ph materials geo_unit latitude longitude profile surface_elevation time platform_name depth_below_ground_surface top_of_interval bottom_of_interval sand silt clay gravel excess_ice ground_ice_class liquid_limit plastic_limit soil_ph materials geo_unit latitude longitude profile surface_elevation time platform_name depth_below_ground_surface top_of_interval bottom_of_interval sand silt clay gravel excess_ice ground_ice_class liquid_limit plastic_limit soil_ph materials geo_unit latitude longitude profile surface_elevation time platform_name depth_below_ground_surface top_of_interval bottom_of_interval sand silt clay gravel excess_ice ground_ice_class liquid_limit plastic_limit soil_ph materials geo_unit ")

File type: (more information) .asc - View OPeNDAP-style ISO-8859-1 comma-separated text. .csv - Download a ISO-8859-1 comma-separated text table (line 1: names; line 2: units; ISO 8601 times). .csvp - Download a ISO-8859-1 .csv file with line 1: name (units). Times are ISO 8601 strings. .csv0 - Download a ISO-8859-1 .csv file without column names or units. Times are ISO 8601 strings. .dataTable - A JSON file formatted for use with the Google Visualization client library (Google Charts). .das - View the dataset's metadata via an ISO-8859-1 OPeNDAP Dataset Attribute Structure (DAS). .dds - View the dataset's structure via an ISO-8859-1 OPeNDAP Dataset Descriptor Structure (DDS). .dods - OPeNDAP clients use this to download the data in the DODS binary format. .esriCsv - Download a ISO_8859_1 .csv file for ESRI's ArcGIS 9.x and below (separate date and time columns). .fgdc - View the dataset's UTF-8 FGDC .xml metadata. .geoJson - Download longitude,latitude,otherColumns data as a UTF-8 GeoJSON .json file. .graph - View a Make A Graph web page. .help - View a web page with a description of tabledap. .html - View an OPeNDAP-style HTML Data Access Form. .htmlTable - View a UTF-8 .html web page with the data in a table. Times are ISO 8601 strings. .iso19115 - View the dataset's ISO 19115-2/19139 UTF-8 .xml metadata. .itx - Download an ISO-8859-1 Igor Text File. Each response column becomes a wave. .json - View a table-like UTF-8 JSON file (missing value = 'null'; times are ISO 8601 strings). .jsonlCSV1 - View a UTF-8 JSON Lines CSV file with column names on line 1 (mv = 'null'; times are ISO 8601 strings). .jsonlCSV - View a UTF-8 JSON Lines CSV file without column names (mv = 'null'; times are ISO 8601 strings). .jsonlKVP - View a UTF-8 JSON Lines file with Key:Value pairs (missing value = 'null'; times are ISO 8601 strings). .mat - Download a MATLAB binary file. .nc - Download a flat, table-like, NetCDF-3 binary file with COARDS/CF/ACDD metadata. .ncHeader - View the UTF-8 header (the metadata) for the NetCDF-3 .nc file. .ncCF - Download a NetCDF-3 CF Discrete Sampling Geometries file (Contiguous Ragged Array). .ncCFHeader - View the UTF-8 header (the metadata) for the .ncCF file. .ncCFMA - Download a NetCDF-3 CF Discrete Sampling Geometries file (Multidimensional Array). .ncCFMAHeader - View the UTF-8 header (the metadata) for the .ncCFMA file. .nccsv - Download a NetCDF-3-like 7-bit ASCII NCCSV .csv file with COARDS/CF/ACDD metadata. .nccsvMetadata - View the dataset's metadata as the top half of a 7-bit ASCII NCCSV .csv file. .ncoJson - Download a UTF-8 NCO lvl=2 JSON file with COARDS/CF/ACDD metadata. .odvTxt - Download longitude,latitude,time,otherColumns as an ISO-8859-1 ODV Generic Spreadsheet File (.txt). .subset - View an HTML form which uses faceted search to simplify picking subsets of the data. .tsv - Download a ISO-8859-1 tab-separated text table (line 1: names; line 2: units; ISO 8601 times). .tsvp - Download a ISO-8859-1 .tsv file with line 1: name (units). Times are ISO 8601 strings. .tsv0 - Download a ISO-8859-1 .tsv file without column names or units. Times are ISO 8601 strings. .wav - Download a .wav audio file. All columns must be numeric and of the same type. .xhtml - View a UTF-8 XHTML (XML) file with the data in a table. Times are ISO 8601 strings. .kml - View a .kml file, suitable for Google Earth. .smallPdf - View a small .pdf image file with a graph or map. .pdf - View a standard, medium-sized .pdf image file with a graph or map. .largePdf - View a large .pdf image file with a graph or map. .smallPng - View a small .png image file with a graph or map. .png - View a standard, medium-sized .png image file with a graph or map. .largePng - View a large .png image file with a graph or map. .transparentPng - View a .png image file (just the data, without axes, landmask, or legend).

(Documentation / Bypass this form )
 
Submit (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 actual_range 77.9242, 77.9242;
    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 actual_range -96.66144, -96.66144;
    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 actual_range 9.96921e+36, 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.39328e+8, 2.39328e+8;
    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 1024;
    String _CoordinateAxisType "Height";
    Float32 actual_range 0.175, 1.2;
    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 1024;
    Float32 actual_range 0.0, 1.0;
    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 1024;
    Float32 actual_range 0.35, 1.4;
    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 4;
    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)";
    Float64 max_diameter_mm 2.0;
    Float64 min_diameter_mm 0.063;
    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 4;
    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)";
    Float64 max_diameter_mm 0.063;
    Float64 min_diameter_mm 0.004;
    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 4;
    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)";
    Float64 max_diameter_mm 0.004;
    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 4;
    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)";
    Float64 min_diameter_mm 2.0;
    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;
  }
  excess_ice {
    Int32 _ChunkSizes 4;
    Float32 actual_range 0.0, 1.0;
    String coordinates "depth_below_ground_surface bottom_of_interval top_of_interval time latitude longitude platform_name profile";
    String ioos_category "Ice Distribution";
    String long_name "Excess ice content";
    String standard_name "ice_volume_in_frozen_ground_in_excess_of_pore_volume_in_unfrozen_ground_expressed_as_fraction_of_frozen_ground_volume";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/ice_volume_in_frozen_ground_in_excess_of_pore_volume_in_unfrozen_ground_expressed_as_fraction_of_frozen_ground_volume";
    String units "percent";
    Float32 valid_min 0.0;
  }
  ground_ice_class {
    Int32 _ChunkSizes 1, 64;
    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 "Ground ice classification";
  }
  liquid_limit {
    Int32 _ChunkSizes 4;
    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 4;
    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;
  }
  soil_ph {
    Int32 _ChunkSizes 4;
    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 "Soil water pH";
    String standard_name "soil_water_ph";
    String standard_name_url "https://mmisw.org/ont/cf/parameter/soil_water_ph";
  }
  materials {
    Int32 _ChunkSizes 1, 64;
    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";
  }
  geo_unit {
    Int32 _ChunkSizes 1, 70;
    String ioos_category "Other";
    String long_name "Geological Unit";
  }
 }
  NC_GLOBAL {
    String _NCProperties "version=2,netcdf=4.7.3,hdf5=1.10.6";
    String acknowledgement "Willing and able assistance in an unpleasant climate was given by A.C. Liard and W .G. Green (Graham Island, 1974); R. O'Breham and W.R. Archer (Ellef Ringners and King Christian islands, 1976); C.N.D. Hotze! and W.R. Archer (Amund Ringnes, Cornwall, and King Christian islands, 1977). Aircraft support in 1976 and 1977 was provided by Polar Continental Shelf Project of the Department of Energy, Mines and Resources. The report was critically read by Dr. L.A. Dredge, who suggested a number of improvements and alternative interpretations. Result digitizing was supported by PermafrostNet Theme 1.";
    String cdm_altitude_proxy "depth_below_ground_surface";
    String cdm_data_type "Profile";
    String cdm_profile_variables "profile";
    String comments "The location of the borehole was given using the National Topographic System Grid Reference in the report, then repositioned manually to obtain GPS coordinates, so it should be considered approximate.";
    String contributor_email ",samuel.gagnon.1@gmail.com,,";
    String contributor_name "Douglas A. Hodgson, Samuel Gagnon, Mohammadhossein Gamshadzaei, Michel Paquette";
    String contributor_role "principalInvestigator,pointOfContact,distributor,distributor";
    Float64 contributor_url NaN;
    String Conventions "CF-1.6, ACDD-1.3";
    Float64 creator_email NaN;
    String creator_name "Geological Survey of Canada";
    String creator_type "institution";
    String creator_url "https://www.nrcan.gc.ca/science-and-data/research-centres-and-labs/geological-survey-canada/17100";
    String date_created "1982-01-01";
    String date_issued "2022-06-09";
    String date_modified "2022-06-09";
    Float64 Easternmost_Easting -96.66144;
    String environment_description "Edge of frost fissure trough 2/8-2";
    String featureType "Profile";
    Float64 geospatial_lat_max 77.9242;
    Float64 geospatial_lat_min 77.9242;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -96.66144;
    Float64 geospatial_lon_min -96.66144;
    String geospatial_lon_units "degrees_east";
    Float64 ground_slope_angle NaN;
    Float64 ground_slope_direction NaN;
    String history 
"2024-11-24T21:52:52Z (local files)
2024-11-24T21:52:52Z http://data.permafrostnet.ca/erddap/tabledap/Hodgson_1982_44779_20972.html";
    String infoUrl "https://doi.org/10.4095/109296";
    String institution "Geological Survey of Canada";
    String keywords "amund ringnes island, cryosols, ground ice, nunavut, permafrost, soils";
    String land_units "Ice wedge polygon";
    String license "https://open.canada.ca/en/open-government-licence-canada";
    String location "Amund Ringnes Island";
    String metadata_link "https://doi.org/10.4095/109296";
    Float64 Northernmost_Northing 77.9242;
    String observation_depth_max "1.4";
    String observation_depth_min "0";
    Float64 organic_matter_thickness NaN;
    Float64 overburden_thickness NaN;
    String permafrost_status "present";
    String platform "borehole";
    String platform_id "WSAI_77:2/8-3";
    Float64 platform_orientation NaN;
    String platform_pitch_fore_down "90";
    String processing_level "The data was retrieved from a digital version of the report \"Surficial Materials, southern Ellef Ringnes, King Christian and Adjacent Islands, District of Franklin (1982)\"; the data was retranscribed manually and some fields were uniformized across all boreholes (e.g., surface deposits, soil material). ";
    String project "Surficial Materials and Geomorphological Processes, Western Sverdrup and Adjacent Islands, District of Franklin";
    String project_id "GSC_WSAI_1982";
    String publisher_name "Geological Survey of Canada";
    String publisher_type "institution";
    String publisher_url "https://www.nrcan.gc.ca/science-and-data/research-centres-and-labs/geological-survey-canada/17100";
    String references "https://doi.org/10.4095/109296";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 77.9242;
    String standard_name_vocabulary "CF Standard Name Table v78";
    String summary "To quantify the ground volumes on Amund Ringnes Island NU, Canada), 100 boreholes were drilled to depths up to 3 meters from 1974 to 1977. This borehole was drilled on 1977-08-02 with a hand-held modified CRREL drill and is 1.4 m deep. The dataset describes active layer thickness, soil stratigraphy, volumetric ground ice content, and surface deposits. Volumetric ice content was determined with a combination of visual estimates and laboratory measurements. ";
    String surface_cover "unknown";
    String surficial_geology "marine";
    String time_coverage_end "1977-08-02T00:00:00Z";
    Float64 time_coverage_resolution NaN;
    String time_coverage_start "1977-08-02T00:00:00Z";
    String title "Stratigraphy and ground ice content of borehole 77:2/8-3 on Amund Ringnes Island, Nunavut, Canada";
    String vegetation_type "Not recorded";
    Float64 Westernmost_Easting -96.66144;
  }
}

 

---

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 Data Access Protocol (DAP) and its selection constraints.

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.

• (easy) You can get data by using the dataset's Data Access Form or Subset form. They make the URL for you.
• (easy) You can make a graph or map by using the dataset's Make A Graph form. It makes the URL for you.
• (not hard) You can bypass the forms and get the data or make a graph or map by generating the URL by hand or with a computer program or script.

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