NOTE: A CD HAS BEEN PREPARED THAT HAS THE DIGITAL SOILS DATA AND OTHER DATA FOR SE MASS. SEND AND EMAIL FOR MORE INFORMATION.

NOTE: All information contained within this document is advance information, subject to change. Please contact Jim Turenne if you need more information: 401-822-8830 or jimturenne@gmail.com.

Soil Attribute Join Table for Southeastern Mass/GIS Digital Soil Data

Introduction
Directions
Making soil intpertetive maps
Using the Hot Link script
Explanations of Soil Join Table Fields

Introduction:

The barnsoil.dbf and norfsoil.dbf files contain soil attribute information designed to provide interpretive maps for digitized soil surveys for SE Mass. The database files contain a common field called "MAPUNIT" which can be joined to the "Stateleg" field of the soil attribute table. The joining of the two tables allows the user to produce soil interpretive maps showing various soil properties such as hydric soil areas, suitability for on-site septic systems and hydrologic groups. The following explains the procedure for joining the two tables along with descriptions on each field for creating the interpretive maps.

To use the files contained in this program extract the zip file into a directory of your choice, remember to keep track of where you download and extract your files (it's good practice to develop a file naming structure).

Directions:

As of July 2001 digital soil survey information is available for Barnstable, Norfolk, and Suffolk Counties. There are two ways of getting the digital soil information for use with a GIS program. One source is from the USDA Soil Survey Geographic (SSURGO) Database (see: http://nesoil.com/gis/ssurgoinstructions.html for directions how to download from the clearinghouse site). Another way is to get digital soil data is from Mass/GIS (I recommend getting it from this source so you will be able to use with other data from Massachusetts). Soil data from Mass/GIS is available by USGS Quadrangle and is projected in Massachusetts State Plane, NAD 83 coordinates, go to: http://www.state.ma.us/mgis/soi.htm for the soil data layer description.

Mass/GIS Digital Soil Data:
There are two soil layers available for download from Mass/GIS - Soil Features and Spot Features (read the datalayer description completely). The soil features are the soil polygons (soil map) and soil attribute information. The spot features layer has the ad-hoc spot symbols placed on the soil maps. These spot symbols show the location of various features such as wet spots, marshes, and bedrock outcrops the soil mapper identified in the field during the production of the maps. The spot symbols were used in areas that were too small (less than 5-8 acres) to delineate at the scale of mapping. It is important to download both features. If you want the entire County in an Arc/View shape file contact me at 508-295-5151 x2.

After downloading both features for the quadrangle, extract the EXE files into a directory.
You should get a number of Arc/View files (*.shp, *.dbf, *.shx, etc.) in your directory for each layer.

Using the join table (extract the join table and associated files into a directory):

1. With Arc/View running and a "View"open click the "Add Theme" button and navigate to the folder you extracted the soil shape file to, click the shape file with the "p" after the feature name such as SOI170p1.shp.

2. Make the soil theme active (click on the theme name in the view's table of content - it should have a raised appearance) and open the attribute table by clicking the button.

3. Minimize the view window and go to the document types window (see figure below). Click the "Tables" document type then select the "Add" button. Under the "List Files of Type" dropdown menu, select "dbase" and navigate to the folder you put the join table files into. Click the join table for the County you are working in (Norfolk/Suffolk are in norfsoil.dbf, Barnstable County is in barnsoil.dbf) to open it.

4. Click the "Mapunit" field of the barnsoil.dbf or norfsoil.dbf table FIRST, then click the "Stateleg" field of the soil attribute table (Attributes of Soi##.shp). Now click the "Join Table" button. This should join the soil.dbf table to the soil attribute table (you should see the fields from the soil.dbf table added to the Attribute of Soi##.shp table).

5. Open the "view" document type window and try creating a theme map.

Making soil intpertetive maps:

Double click the SOIXXp1.shp file to open the legend editor. In the "Legend Type" box select "Unique Value", in the "Values Field" navigate to the field you want to create as shown below (explanations of each field is provided below):

You may want to edit the symbols to suit your needs. Some fields such as "Onsew" for onsite sewage maps have a legend file (*.avl) created (not yet available) click the load button and navigate to the onsew.avl file.

Using the Hot Link script:

The Link_URL.ave script included allows you use Arc/View's "Hot Link" button to link the soil polygons to the map unit descriptions found in the published soil surveys via the Internet. To use this feature you must have your computer connected to the Internet. The join table has a field called "URL" that provides the URL to the map unit description. To use this feature, follow these instructions:

1. Go to the "Documents Type" window and click the "Scripts" button.
2. Click "New" to open a blank script (Script 1).
3. Click the "Load Text File" button and navigate to the Link_URL.ave script to load it.
4. click the "Compile" Script button then the "Run" button. The program will open your explorer window, just ignore this and go back to Arc/View. If you are familiar with using Arc/View’s script feature you can change the name of the script to suit your needs, the default script will be called Script1 or some other number depending on how many other scripts you have loaded.
5. Go back to the "View" screen and make the SOIxxp1.shp file active. Open the "Theme-Properties" menu and scroll to the "Hot Link" menu. In the "Field" box choose "URL", in the "Predefined Action" box choose "Link to User Script", under the "Script" navigate to your Link_URL.ave script (most likely called Script1), click OK.
6. Notice the "Hot Link" button is now active. To use the Hotlink feature click the "Hot Link" button then click on a soil polygon. If everything works your browser should load a map unit description of the soil polygon. If it does not work call or email the Plymouth County Soil Survey Office (401-822-8830) for more information.

Explanations of Soil Join Table Fields:

NOTE: UNC means the field is not classified refer to map unit description for more information. Some of the field names may be different depending on which version you have.

ESWT = Estimated Depth to Seasonal High Watertable (Click for more information)

MAPUNIT
UNITNAME
DESCRIPT: Quick soil description
ONSEW: Onsite Sewage Disposal
HYDRIC: Hydric Soils
AGRIC: Agricultural Interpretation
GEOLOGIC (Soil Parent Material)
HYDGRP: Hydrologic Groups
URL
SURFTEX: Surface Texture
FROST: Frost Action
DRAINAGE: Soil Drainage Class
HYDRICYN: Hydric soil, yes or no
CORCON and CORSTEEL: Risk of corrosion, steel and concrete
CAPCLAS and SUBCLAS: Capability Class and Subclass

The soil join table (barnsoil.dbf, norfsoil.dbf) contains numerous fields for creating interpretive maps, Some of the fields were developed for specific interpretations in SE Massachusetts, others were taken from the soil interpretation tables from the published soil surveys. The following is an explanation of each field in order of appearance:

MAPUNIT: This field contains the alpha and or alphnumeric map unit symbol used to join with the STATELEG filed of the soil attribute table. The numbers are the soil map units used on our state-wide soil legend.

UNITNAME: This field has the soil map unit name from the published soil survey .

GENDESC: Quick general soil description:

This field lists a brief description of the soil map unit, grouping properties such as depth to watertable, drainage, and other features. The following table describes the fields and provides some information about development potential/limitations:

ONSEW: Onsite Sewage Disposal

This rating is designed to show soil ability to deliver household sewage effluent into the soil under the State (Massachusetts) Environmental Code Title V: Minimum Requirements for the Subsurface Disposal of Sanitary Sewage (310 CMR 15.00). The interpretive groups are developed to provide general site characteristics for soil requirements.

This information is intended for general planning purposes only and is not, in any way, intended to replace or supercede an on-site investigation. On-site investigations for siting septic systems by certified soil evaluators are required by Title V.

These classes are designed for the installation of new septic systems for new single-family residences and do not apply to large systems or commercial/industrial systems. These classes are only designed for the soils mapped in Southeastern Massachusetts.

The general requirements relating to soil suitability for onsite sewage disposal systems in Massachusetts are;

• Four feet of naturally occurring (C-horizon) pervious material with percolation rates less than 30 minutes per inch.

• The minimum vertical separation distance of the bottom of the crushed stone underlying the soil absorption system above the seasonal high ground-water level is four feet in soils with a recorded perc rate of more than 2 min/inch and five feet in soils with less than 2 minute/inch perc rates.

Based on this criteria, the onsite sewage disposal classes were developed by grouping soil properties such as depth to seasonal high watertable, permeability, depth to bedrock, type of parent material, and drainage class together. The following table lists the onsite sewage disposal classes (A through I), a brief description of the class, and the relation to the Massachusetts Title V code for siting onsite septic disposal systems within this type of soil.

Dual classes may be assigned to soil complexes (soil map units consisting of two or more soil types) such as A/B for map unit 478B-Plymouth-Poquonock complex. The first class (A) is the rating for the Plymouth soil component and the second (B) is the rating for Poquonock soils. Complexes that have the same rating are not assigned dual classes (example: map unit 480 Plymouth-Carver complex, both are class A units). For more information about the soil complex read the soil map unit description (use the hot-link feature to access the description).

HYDRIC: Hydric Soils

This theme map shows hydric and non-hydric soil areas. Hydric soils are soils that are saturated, flooded, or ponded long enough during the growing season to develop anaerobic conditions in the upper part. Hydric soils are generally associated with wetlands and are subject to protection under State and Federal laws. Remember; all soil map units may contain inclusions of hydric and non hydric soils, onsite determination is required to delineate wetlands!! Most published soil surveys are mapped at a scale of 1:20,000 to 1:25,000 with minimum delineation's of 5-8 acres in size.

AGRIC: Agricultural Interpretation:

This theme map groups soil map units into a farmland classification scheme developed by the USDA-NRCS.

GEOLOGIC (Soil Parent Material):

This theme map groups soil map units according to the parent material (geologic sediments ) the soil formed in. Types of parent material (referred to as the substratum) in Massachusetts soils are broken down into two major categories; glacial deposits and post-glacial deposits. Glacial deposits are mostly of Pleistocene age, and post-glacial deposits are Holocene age. This field may be used for title V soil evaluations (office review of site - page 1 of the log form) in areas where surficial geology maps are not available.

Geology of Plymouth County  | Geology of Barnstable County

HYDGRP: Hydrologic Groups

This theme map shows the classification of soil map units according to their hydrologic soil groups.

A hydrologic group is a group of soils having similar runoff potential under similar storm and land cover conditions. Soil properties that influence runoff potential are those that influence the minimum rate of infiltration for a bare soil after prolonged wetting and when not frozen. These properties are depth to a seasonally high water table, intake rate and permeability after prolonged wetting, and depth to a very slowly permeable layer. The influence of ground cover is treated independently.

Classes

The soils in the United States are placed into four groups, A, B, C, and D. In the definitions of the classes, infiltration rate is the rate at which water enters the soil at the surface, and is controlled by the surface conditions. Transmission rate is the rate at which water moves in the soil and is controlled by soil properties..

Definitions of the classes are as follows:

A. (Low runoff potential). The soils have a high infiltration rate even when thoroughly wetted. They chiefly consist of deep, well drained to excessively drained sands or gravels. They have a high rate of water transmission.

B. The soils have a moderate infiltration rate when thoroughly wetted. They chiefly are moderately deep to deep, moderately well drained to well drained soils that have moderately fine to moderately coarse textures. They have a moderate rate of water transmission.

C. The soils have a slow infiltration rate when thoroughly wetted. They chiefly have a layer that impedes downward movement of water or have moderately fine to fine texture. They have a slow rate of water transmission.

D. (High runoff potential). The soils have a very slow infiltration rate when thoroughly wetted. They chiefly consist of clay soils that have a high swelling potential, soils that have a permanent high water table, soils that have a claypan or clay layer at or near the surface, and shallow soils over nearly impervious material. They have a very slow rate of water transmission.

1. Dual classes such as B/A/C are assigned to soil map unit complexes such as unit 490C: Barnstable-Plymouth-Nantucket complex, rolling. This map unit consists of 3 components -Barnstable soils (hydro group B), Plymouth soils (hydro group A), and Nantucket soils (hydro group C). Refer to the soil map unit description for more information. Bedrock controlled areas are also grouped with dual classes for the Hollis soil series which has a dual group of C/D. The C is used if the underlying bedrock is fractured, D is used if the rock is not fractured.

URL:

This field contains the Internet URL used to link the map unit polygon with the soil map unit description. See the directions above on using the Link_URL script to link the polygons.

SURFTEX:

This field provides the USDA soil texture class of the surface soil horizon. The letters are abbreviations for each soil texture class such as FSL for fine sandy loam.

FROSTACT:

This field lists the potential frost action of the soil. Frost action is the likelihood of upward or lateral expansion of the soil caused by the formation of segregated ice lenses (frost heave) and the subsequent collapse of the soil and loss of strength on thawing. Frost action occurs when moisture moves into the freezing zone of the soil. Temperature, texture, density, permeability, content of organic matter, and depth to the water table are the most important factors considered in evaluating the potential for frost action. It is assumed that the soil is not insulated by vegetation or snow and is not artificially drained. Silty and highly structured clayey soils that have a high water table in winter are the most susceptible to frost action. Well drained, very gravelly, or very sandy soils are the least susceptible. Frost heave and low soil strength during thawing cause damage mainly to pavements and other rigid structures.

DRAINAGE:

This field provides the USDA soil drainage class. The following is a description of each drainage class:

Drainage class (natural): Refers to the frequency and duration of periods of saturation or partial saturation during soil formation, as opposed to altered drainage, which is commonly the result of artificial drainage or irrigation but may be caused by the sudden deepening of channels or the blocking of drainage outlets. Seven classes of natural soil drainage are recognized:

• ED - Excessively drained: Water is removed from the soil very rapidly. Excessively drained soils are commonly very coarse textured, rocky, or shallow. Some are steep. All are free of the mottling related to wetness.
  SWED - Somewhat excessively drained: Water is removed from the soil rapidly. Many somewhat excessively drained soils are sandy and rapidly pervious. Some are shallow. Some are so steep that much of the water they receive is lost as runoff. All are free of the mottling related to wetness.
  MW - Moderately well drained: Water is removed from the soil somewhat slowly during some periods. Moderately well drained soils are wet for only a short time during the growing season, but periodically they are wet long enough that most mesophytic crops are affected. They commonly have a slowly pervious layer within or directly below the solum, or periodically receive high rainfall, or both.
  PD - Poorly drained: Water is removed so slowly that the soil is saturated periodically during the growing season or remains wet for long periods. Free water is commonly at or near the surface for long enough during the growing season that most mesophytic crops cannot be grown unless the soil is artificially drained. The soil is not continuously saturated in layers directly below plow depth. Poor drainage results from a high water table, a slowly pervious layer within the profile, seepage, nearly continuous rainfall, or a combination of these.
  VP - Very poorly drained: Water is removed from the soil so slowly that free water remains at or on the surface during most of the growing season. Unless the soil is artificially drained, most mesophytic crops cannot be grown. Very poorly drained soils are commonly level or depressed and are frequently ponded. Yet, where rainfall is high and nearly continuous, they can have moderate or high slope gradients.

HYDRICYN:

This field lists weather the soil map unit is hydric or not hydric, see the field HYDRIC above for more information. Y means the soil is hydric, N means it is not hydric. Remember; all soil map units may contain inclusions of hydric and non hydric soils, onsite determination is required to delineate wetlands!! Most published soil surveys are mapped at a scale of 1:20,000 to 1:25,000 with minimum delineation's of 5-8 acres in size.

CORCON and CORSTEEL:

This field lists the soils risk of corrosion of concrete (CORCON) and Steel (CORSTEEL).

Risk of corrosion pertains to potential soil-induced electrochemical or chemical action that dissolves or weakens uncoated steel or concrete. The rate of corrosion of uncoated steel is related to such factors as soil moisture, particle-size distribution, acidity, and electrical conductivity of the soil. The rate of corrosion of concrete is based mainly on the sulfate and sodium content, texture, moisture content, and acidity of the soil. Special site examination and design may be needed if the combination of factors creates a severe corrosion environment. The steel in installations that intersect soil boundaries or soil layers is more susceptible to corrosion than steel in installations that are entirely within one kind of soil or within one soil layer. For uncoated steel, the risk of corrosion, expressed as low, moderate, or high, is based on soil drainage class, total acidity, electrical resistivity near field capacity, and electrical conductivity of the saturation extract. For concrete, the risk of corrosion is also expressed as low, moderate, or high . It is based on soil texture, acidity, and amount of sulfates in the saturation extract.

CAPCLAS and SUBCLAS:

This field provides the Land Capability Classification. Land capability classification shows, in a general way, the suitability of soils for most kinds of field crops. Crops that require special management are excluded. The soils are grouped according to their limitations for field crops, the risk of damage if they are used for crops, and the way they respond to management. The criteria used in grouping the soils do not include major and generally expensive landforming that would change slope, depth, or other characteristics of the soils, nor do they include possible but unlikely major reclamation projects. Capability classification is not a substitute for interpretations designed to show suitability and limitations of groups of soils for rangeland, for woodland, and for engineering purposes. In the capability system, soils are generally grouped at three levels: capability class, subclass, and unit. Only class and subclass are used in this survey. These levels are defined in the following paragraphs.

SUBCLAS: Capability subclasses are soil groups within one class. They are designated by adding a small letter, e, w, s, or c, to the class numeral, for example, IIe. The letter e shows that the main limitation is risk of erosion unless close-growing plant cover is maintained; w shows that water in or on the soil interferes with plant growth or cultivation (in some soils the wetness can be partly corrected by artificial drainage); s shows that the soil is limited mainly because it is shallow, droughty, or stony; and c, used in only some parts of the United States, shows that the chief limitation is climate that is very cold or very dry.In class I there are no subclasses because the soils of this class have few limitations. Class V contains only the subclasses indicated by w, s, or c because the soils in class V are subject to little or no erosion. They have other limitations that restrict their use to pasture, rangeland, woodland, wildlife habitat, or recreation. Capability units are soil groups within a subclass. The soils in a capability unit are enough alike to be suited to the same crops and pasture plants, to require similar management, and to have similar productivity. Capability units are generally designated by adding an Arabic numeral to the subclass symbol, for example, IIe-4 or IIIe-6.

CONTACT JIM TURENNE at 401-822-8830 if you have any questions, comments, or would like other fields added to the table.

Back to Home Page