{
  "fields": [{"id":"_id","type":"int"},{"id":"Column Heading","type":"text"},{"id":"Column Heading Description","type":"text"},{"id":"Units","type":"text"},{"id":"Method","type":"text"},{"id":"Reference","type":"text"}],
  "records": [
    [1,"This database is a digital compilation of the data presented in the Ontario Soil Baseline Survey. Full listing of reports associated with this data included below.",null,null,null,null],
    [2,"Data should be projected in Geographic coordinate system WGS84 (latitude, longitude). UTM coordinates and zones are provided for reference because they were in the reports.",null,null,null,null],
    [3,"SiteID is the KEY to connect the \"Sites\" data table to the \"HorizonsAll\" and/or \"HorizonAverages\" tables.",null,null,null,null],
    [4,null,null,null,null,null],
    [5,"Griffiths, M.A., Spires, T, and P. Barclay. 1984. Ontario Soil Baseline Survey. Analytical Data 1980-1981. Volume 1: Soil Baseline Program. Terrestrial effects program acidic precipitation in Ontario study (APIOS). Ontario Ministry of the Environment.",null,null,null,null],
    [6,"Griffiths, M.A., Spires, T, and P. Barclay. 1984. Ontario Soil Baseline Survey. Analytical Data 1980-1981. Volume 2: Analytical Data for Southern Ontario. Terrestrial effects program acidic precipitation in Ontario study (APIOS). Ontario Ministry of the Environment.",null,null,null,null],
    [7,"Griffiths, M.A., Spires, T, and P. Barclay. 1984. Ontario Soil Baseline Survey. Analytical Data 1980-1981. Volume 3: Analytical Data for Northern Ontario. Terrestrial effects program acidic precipitation in Ontario study (APIOS). Ontario Ministry of the Environment.",null,null,null,null],
    [8,"Griffiths, M.A., Spires, T, and P. Barclay. 1983. Ontario Soil Baseline Survey. Analytical Data 1980-1981. Volume 1: Soil Baseline Program. Terrestrial effects program acidic precipitation in Ontario study (APIOS). Ontario Ministry of the Environment.",null,null,null,null],
    [9,"Griffiths, M.A., Spires, T, and P. Barclay. 1983. Ontario Soil Baseline Survey. Analytical Data 1980-1981. Volume 2: Analytical Data for Southern Ontario. Terrestrial effects program acidic precipitation in Ontario study (APIOS). Ontario Ministry of the Environment.",null,null,null,null],
    [10,"Griffiths, M.A., Spires, T, and P. Barclay. 1983. Ontario Soil Baseline Survey. Analytical Data 1980-1981. Volume 3: Analytical Data for Northern Ontario. Terrestrial effects program acidic precipitation in Ontario study (APIOS). Ontario Ministry of the Environment.",null,null,null,null],
    [11,"Griffin, H.D. (ed.). 1983. Procedures manual terrestrial effects acidic precipitation in Ontario study (APIOS). APIOS Report No. 007/83. Technical Subcommittee, Terrestrial Effects Working Group. Ontario Ministry of the Environment.",null,null,null,null],
    [12,null,null,null,null,null],
    [13,"Sites","This data tab is a transcription directly from the site descriptions in the above-noted reports, with some corrections to coordinates for certain sites where errors we made (e.g., site in middle of Lake Huron)",null,null,null],
    [14,null,null,null,null,null],
    [15,"SiteID","Site Identifier",null,null,null],
    [16,"SiteName","Name of the sampling site",null,null,null],
    [17,"UTM_Zone","UTM Zone for easting and northing",null,null,null],
    [18,"Easting","UTM Easting coordinate",null,null,null],
    [19,"Northing","UTM Northing coordinate",null,null,null],
    [20,"Latitude_WGS84","Latitude in WGS 1984",null,null,null],
    [21,"Longitude_WGS84","Longitude in WGS 1984",null,null,null],
    [22,"Date","Date of Sampling",null,null,null],
    [23,"Series","Name of soil series",null,null,null],
    [24,"Classification","Soil Classification as the Canadian System of Soil Classification",null,null,null],
    [25,"Landform","Genral landform description",null,null,null],
    [26,"Parent_Material","General parent material description",null,null,null],
    [27,"Vegetation","General vegetation description",null,null,null],
    [28,"Slope","General slope description",null,null,null],
    [29,"Comments","Site or sampling comments",null,null,null],
    [30,"Field Abbreviation","Field Name",null,null,null],
    [31,null,null,null,null,null],
    [32,null,null,null,null,null],
    [33,"HorizonsAll","This data tab is a transcription directly from the data tables in the above-noted reports, with some corrections to coordinates for certain sites where errors we made (e.g., site in middle of Lake Huron)",null,null,null],
    [34,"Column Heading","Column Heading Description","Units","Method","Reference"],
    [35,"SiteID","Site Identifier",null,null,null],
    [36,"HorizonID","Horizon Identifier",null,null,null],
    [37,"Horizon_Number","Horizon Number",null,null,null],
    [38,"Sample_No","Sample Number",null,null,null],
    [39,"Horizon","Horizon Designation",null,null,null],
    [40,"Upper","Upper Depth","cm",null,null],
    [41,"Lower","Lower Depth","cm",null,null],
    [42,"Thickness","Horizon Thickness","cm",null,null],
    [43,"Colour","Soil Color",null,null,null],
    [44,"Sand","Sand Content","%","wet sieve/sedimentation and pipette analysis","Day, P.R. 1965. Particle fractionation and particle size analysis. Methods of Analysis. Part 1. C.A. Black et al. (eds.) Agronomy Monograph No. 9, Madison, Wisconsin: 545-567.\nGreen, A.J. 1978. Particle Size Analysis. Manual on Soil Sampling and methods of analysis. J.A. McKeague (ed.). Canada Soil Survey Committee on Methods of Analysis, Ottawa; 4-13."],
    [45,"Silt","Silt Content","%","wet sieve/sedimentation and pipette analysis",null],
    [46,"Clay","Clay Content ","%","wet sieve/sedimentation and pipette analysis",null],
    [47,"pH_H2O","Soil pH in water",null,"1:2 soil:solution ratio in distilled water","McKeague, J.A. 1978. Manual on soil sampling and methods of analysis. Canada Soil Survey Committee on Methods of Analysis, Ottawa; 66-68.\nHesse, P.R. 1971. Soil chemical analysis. John Murray Pub. Ltd. London; 19-36."],
    [48,"pH_CaCl2","Soil pH in calcium chloride",null,"1:2 soil:solution ratio in distilled 0.01m calcium chloride",null],
    [49,"Organic_C","Organic carbon content","%","Walkley-Black","Allison, L.E. 1965. Organic carbon. Methods of Analysis. Part 2. C.A. Black et al. (eds.) Agronomy Monograph No. 9, Madison, Wisconsin: 1367-1378.."],
    [50,"Total_Nitrogen","Total nitrogen content","mg/g","total Kjeldahl N","Ontario Ministry of the Environment. 1981. Outlines of analytical methods. Water quality section laboratory services branch. Pp. 246."],
    [51,"Extr_S","Extractable sulphur","ug/g","soluble S in distilled water, measured by ICP",null],
    [52,"Extr_SO4","Extractable sulphate","ug/g","soluble SO4 in distilled water, measured by ion chromatography","Ballantyne, A.K. 1978. Soluble salts. Manual on Soil Sampling and methods of analysis.  J.A. McKeague (ed.). Canada Soil Survey Committee on Methods of Analysis, Ottawa; 71."],
    [53,"Avail_P","Available phosphorus","ug/g","Na-bicarbonate extratant","Olsen, S.R. et al. 1954. Estimation of available phosphorus in soils by extraction sodium bicarbonate. USDA Circular No. 939, Washington, D.C.\nHesse, P.R. 1971. Soil chemical analysis. John Murray Pub. London; 255-300."],
    [54,"Total_P","Total phosphorus","ug/g","Na-bicarbonate extratant",null],
    [55,"Avail_Al","Available aluminium","ug/g","soluble aluminium in 0.01M CaCl2 extractant","Hoyt, P.B. and M. Nyborg. 1971. Toxic metals in acid soil: I. Estimation of plant available aluminium. Soil Sci. Soc. Amer. Proc. 35: 236-240.\nHoyt, P.B. and M.D. Webber. 1974. Rapid measurement of plant-available aluminium and manganese in acid Canadaian soils. Can. J. Soil Sci. 54: 53-61."],
    [56,"Ca","Exchangeable Calcium","ug/g","NaCl-exchangeable","Grove, J.H. et al. 1982. Determination of the charge character of selected acid soils. J. Soil. Sci. Soc. Amer. 46: 32-38.\nOsborne, W.E. 1978. Cation exchange capacity and exchangeable cations. Manual on Soil Sampling and methods of analysis. J.A. McKeague (ed.). Canada Soil Survey Committee on Methods of Analysis, Ottawa; 72-75."],
    [57,"Mg","Exchangeable Magnesium","ug/g","NaCl-exchangeable",null],
    [58,"K","Exchangeable Potassium","ug/g","NaCl-exchangeable",null],
    [59,"Al","Exchangeable Aluminium","ug/g","NaCl-exchangeable",null],
    [60,"CEC","Cation Exchange Capacity","me/100g","summation of Ca, Mg, K and Al cations","n/a"],
    [61,"Pyrophosphate_Fe","Pyrophosphate extractable iron","%","Na-pyrophosphate extractant","Bascomb, C.L. 1968. Distribution of pyrophosphate extractable iron and organic carbon in soils of various soil groups. J. Soil. Sci. 19: 251-268.\nMcKeague, J.A. 1978. Manual on soil sampling and methods of analysis. Canada Soil Survey Committee on Methods of Analysis, Ottawa; 104-105."],
    [62,"Pyrophosphate_Al","Pyrophosphate extractable aluminium","%","Na-pyrophosphate extractant",null],
    [63,"Pyrophosphate_Mn","Pyrophosphate extractable manganese","%","Na-pyrophosphate extractant",null],
    [64,"Dithionite_Fe","Dithionite extractable iron","%","Na-dithionite-citrate-bicarbonate extractant","Mehra, O.P. and M.L. Jackson. 1960. Iron oxide removal from soils and clays by a dithionite-citrate system buffered with sodium bicarbonate. Clays and Clay Minerals. 5: 317-317.\nMcKeague, J.A. and J.H. Day. 1966. Dithionite and oxalate-extractable Fe and Al as aids in differentiating various classes of soils. Can. J. Soil. Sci. 46: 13-22."],
    [65,"Dithionite_Al","Dithionite extractable aluminium","%","Na-dithionite-citrate-bicarbonate extractant",null],
    [66,"Dithionite_Mn","Dithionite extractable manganese","%","Na-dithionite-citrate-bicarbonate extractant",null],
    [67,"CaCO3","Calcium carbonate equivalent","%","reaction with HCl and CO2 measurement using volumetric calcimeter","Allison, L.E. and C.D. Moodie. 1965. Carbonates methods of soil analysis. Part 2. C.A. Black et al. (eds.) Agronomy Monograph No. 9, Madison, Wisconsin: 1388-1392.\nDriemanis, A. 1962. Quantitative gasometric determination of calcite and dolomite using Cittick apparatus. J. Sedimentary Petrology. 32(3): 520-529."],
    [68,"Zn","Trace metals - Zinc","ug/g","HNO3/HClO4-extractable","Bock, R. 1979. Decomposition methods in analytical chemistry. International Textbook Co. Ltd. London; 212-232.\nHesse, P.R. 1971. Soil chemical analysis. John Murray Pub. London; 371-374."],
    [69,"Cu","Trace metals - Copper","ug/g","HNO3/HClO4-extractable",null],
    [70,"Ni","Trace Metals - Nickel","ug/g","HNO3/HClO4-extractable",null],
    [71,"Pb","Trace Metals - Lead","ug/g","HNO3/HClO4-extractable",null],
    [72,null,null,null,null,null],
    [73,null,null,null,null,null],
    [74,null,null,null,null,null],
    [75,"HorizonAverages","This table is a simplified version of the data in the HorizonsAll table. ",null,null,null],
    [76,null,"The data was simplified by calculating the average values for the analytical data, since sampling was performed in duplicate.",null,null,null],
    [77,null,"This table therefore provides one analytical record per horizon, and would likely be preferred for mapping purposes.",null,null,null],
    [78,"Column Heading","Column Heading Description","Units","Method","Reference"],
    [79,"SiteID","Site Identifier",null,null,null],
    [80,"HorizonID","Horizon Identifier",null,null,null],
    [81,"Horizon","Horizon Designation",null,null,null],
    [82,"Upper","Upper Depth","cm",null,null],
    [83,"Lower","Lower Depth","cm",null,null],
    [84,"Thickness","Horizon Thickness","cm",null,null],
    [85,"Colour","Soil Color",null,null,null],
    [86,"Sand","Sand Content","%","wet sieve/sedimentation and pipette analysis","Day, P.R. 1965. Particle fractionation and particle size analysis. Methods of Analysis. Part 1. C.A. Black et al. (eds.) Agronomy Monograph No. 9, Madison, Wisconsin: 545-567.\nGreen, A.J. 1978. Particle Size Analysis. Manual on Soil Sampling and methods of analysis. J.A. McKeague (ed.). Canada Soil Survey Committee on Methods of Analysis, Ottawa; 4-13."],
    [87,"Silt","Silt Content","%","wet sieve/sedimentation and pipette analysis",null],
    [88,"Clay","Clay Content ","%","wet sieve/sedimentation and pipette analysis",null],
    [89,"pH_H2O","Soil pH in water",null,"1:2 soil:solution ratio in distilled water","McKeague, J.A. 1978. Manual on soil sampling and methods of analysis. Canada Soil Survey Committee on Methods of Analysis, Ottawa; 66-68.\nHesse, P.R. 1971. Soil chemical analysis. John Murray Pub. Ltd. London; 19-36."],
    [90,"pH_CaCl2","Soil pH in calcium chloride",null,"1:2 soil:solution ratio in distilled 0.01m calcium chloride",null],
    [91,"Organic_C","Organic carbon content","%","Walkley-Black","Allison, L.E. 1965. Organic carbon. Methods of Analysis. Part 2. C.A. Black et al. (eds.) Agronomy Monograph No. 9, Madison, Wisconsin: 1367-1378.."],
    [92,"Total_Nitrogen","Total nitrogen content","mg/g","total Kjeldahl N","Ontario Ministry of the Environment. 1981. Outlines of analytical methods. Water quality section laboratory services branch. Pp. 246."],
    [93,"Extr_S","Extractable sulphur","ug/g","soluble S in distilled water, measured by ICP",null],
    [94,"Extr_SO4","Extractable sulphate","ug/g","soluble SO4 in distilled water, measured by ion chromatography","Ballantyne, A.K. 1978. Soluble salts. Manual on Soil Sampling and methods of analysis.  J.A. McKeague (ed.). Canada Soil Survey Committee on Methods of Analysis, Ottawa; 71."],
    [95,"Avail_P","Available phosphorus","ug/g","Na-bicarbonate extratant","Olsen, S.R. et al. 1954. Estimation of available phosphorus in soils by extraction sodium bicarbonate. USDA Circular No. 939, Washington, D.C.\nHesse, P.R. 1971. Soil chemical analysis. John Murray Pub. London; 255-300."],
    [96,"Total_P","Total phosphorus","ug/g","Na-bicarbonate extratant",null],
    [97,"Avail_Al","Available aluminium","ug/g","soluble aluminium in 0.01M CaCl2 extractant","Hoyt, P.B. and M. Nyborg. 1971. Toxic metals in acid soil: I. Estimation of plant available aluminium. Soil Sci. Soc. Amer. Proc. 35: 236-240.\nHoyt, P.B. and M.D. Webber. 1974. Rapid measurement of plant-available aluminium and manganese in acid Canadaian soils. Can. J. Soil Sci. 54: 53-61."],
    [98,"Ca","Exchangeable Calcium","ug/g","NaCl-exchangeable","Grove, J.H. et al. 1982. Determination of the charge character of selected acid soils. J. Soil. Sci. Soc. Amer. 46: 32-38.\nOsborne, W.E. 1978. Cation exchange capacity and exchangeable cations. Manual on Soil Sampling and methods of analysis. J.A. McKeague (ed.). Canada Soil Survey Committee on Methods of Analysis, Ottawa; 72-75."],
    [99,"Mg","Exchangeable Magnesium","ug/g","NaCl-exchangeable",null],
    [100,"K","Exchangeable Potassium","ug/g","NaCl-exchangeable",null],
    [101,"Al","Exchangeable Aluminium","ug/g","NaCl-exchangeable",null],
    [102,"CEC","Cation Exchange Capacity","me/100g","summation of Ca, Mg, K and Al cations","n/a"],
    [103,"Pyrophosphate_Fe","Pyrophosphate extractable iron","%","Na-pyrophosphate extractant","Bascomb, C.L. 1968. Distribution of pyrophosphate extractable iron and organic carbon in soils of various soil groups. J. Soil. Sci. 19: 251-268.\nMcKeague, J.A. 1978. Manual on soil sampling and methods of analysis. Canada Soil Survey Committee on Methods of Analysis, Ottawa; 104-105."],
    [104,"Pyrophosphate_Al","Pyrophosphate extractable aluminium","%","Na-pyrophosphate extractant",null],
    [105,"Pyrophosphate_Mn","Pyrophosphate extractable manganese","%","Na-pyrophosphate extractant",null],
    [106,"Dithionite_Fe","Dithionite extractable iron","%","Na-dithionite-citrate-bicarbonate extractant","Mehra, O.P. and M.L. Jackson. 1960. Iron oxide removal from soils and clays by a dithionite-citrate system buffered with sodium bicarbonate. Clays and Clay Minerals. 5: 317-317.\nMcKeague, J.A. and J.H. Day. 1966. Dithionite and oxalate-extractable Fe and Al as aids in differentiating various classes of soils. Can. J. Soil. Sci. 46: 13-22."],
    [107,"Dithionite_Al","Dithionite extractable aluminium","%","Na-dithionite-citrate-bicarbonate extractant",null],
    [108,"Dithionite_Mn","Dithionite extractable manganese","%","Na-dithionite-citrate-bicarbonate extractant",null],
    [109,"CaCO3","Calcium carbonate equivalent","%","reaction with HCl and CO2 measurement using volumetric calcimeter","Allison, L.E. and C.D. Moodie. 1965. Carbonates methods of soil analysis. Part 2. C.A. Black et al. (eds.) Agronomy Monograph No. 9, Madison, Wisconsin: 1388-1392.\nDriemanis, A. 1962. Quantitative gasometric determination of calcite and dolomite using Cittick apparatus. J. Sedimentary Petrology. 32(3): 520-529."],
    [110,"Zn","Trace metals - Zinc","ug/g","HNO3/HClO4-extractable","Bock, R. 1979. Decomposition methods in analytical chemistry. International Textbook Co. Ltd. London; 212-232.\nHesse, P.R. 1971. Soil chemical analysis. John Murray Pub. London; 371-374."],
    [111,"Cu","Trace metals - Copper","ug/g","HNO3/HClO4-extractable",null],
    [112,"Ni","Trace Metals - Nickel","ug/g","HNO3/HClO4-extractable",null],
    [113,"Pb","Trace Metals - Lead","ug/g","HNO3/HClO4-extractable",null]
]}