Schwarz, G.E. and Alexander, R.B.
19950901
Soils
1.1
vector digital data
Reston, VA
U.S. Geological Survey
Soils
USSOILS is an Arc 7.0 coverage containing hydrology-relevant information for 10,498 map units covering the entire conterminous United States.
The coverage was compiled from individual State coverages contained in the October 1994 State Soil Geographic (STATSGO) Data Base produced on CD-ROM. The geo-dataset USSOILS.PAT relates (on the basis of a map unit
identifier) the 10,498 map units to 78,518 polygons. The scale of the geo-dataset is 1:250,000. The INFO attribute table USSOILS.MUID_ATTS contains selected variables from the STATSGO data set for 10,501 map units (an extra 3 map units are contained in the attribute table that are not in the geo-dataset - see the 'Procedures' section below), including: the map unit identifier, a 2-character state abbreviation, available water capacity of the soil, percent clay in the soil, the actual k-factor used in the water erosion component of the universal soil loss equation, the organic material in soil, soil permeability, cumulative thickness of all soil layers, hydrologic characteristics of the soil, quality of drainage, surface slope, liquid limit of the soil, share of a map unit having hydric soils, and the annual frequency of flooding. To facilitate mapping the attribute data, the narrative
section below contains instructions for transferring the information contained in the attribute table USSOILS.MUID_ATTS to the polygon attribute table USSOILS.PAT.
Keywords
STATSGO
United States
Soil
Water Capacity
Clay
Organic material
Permeability
Infiltration
Drainage
Hydric
Flood frequency
Slope
17,234 records in attribute table on 6-26-09.
The USSOILS coverage was originally compiled to support a national model of water quality. The model uses the soil characteristics contained in this coverage to mediate deliveries of nonpoint source pollution to stream and river segments in the RF1 data base. The National Resource Conservation Service (NRCS) recommends that any maps using NRCS STATSGO data show the source and date, and provide the following statement:
"STATSGO is designed to support regional, multistate, State, and river basin resource planning, management and monitoring."
Procedures_Used:
The individual State coverages are from the State Soil Geographic
(STATSGO) CD-ROM data base, issued by U.S. Department of Agriculture,
NRCS National Cartography and GIS Center, P.O. Box 6567, Fort Worth,
Texas 76115-0567, 1-800-672-5559 (U.S. Department of Agriculture, 1991).
The CD-ROM coverage for New Mexico was defective and was not used. A
corrected copy of the New Mexico coverage was obtained from Norman Bliss
of the EROS Data Center ((605) 594-6034). The STATSGO State-based
coverages were merged together into a national coverage using the Arc
MAPJOIN command. All nodes along merged boundaries were checked and
edited to remove any superfluous nodes created during the mapjoin
process, and to ensure arcs properly merged along and across State
boundaries. The joining process preserved all State boundaries.
To understand the procedures used to create the attribute table
USSOILS.MUID_ATTS, it helps to have an understanding of the STATSGO data
structure. The smallest spatial entity mapped within the STATSGO
dataset is called a map unit, of which there are 10,498 broken out into
78,518 polygons within the conterminous United States. Each map unit
consists of up to 21 components. Components are used to apportion
different characteristics of a map unit and do not represent a separate
spatial entity. To help understand this, consider a map unit that has
only two components. Suppose 30 percent of this map unit contains soil
of type A and the remaining 70 percent contains soil of type B. Thus,
component 1 of the map unit would have soil type A and component 2 would
have soil type B. The data base would record the soil type for each
component, along with the percentage of the map unit represented by each
component (in this example, 30 percent for component 1 and 70 percent
for component 2). The specific locations of soil types A and B are not
spatially defined in the data base.
Each component is further delineated into a maximum of 6 layers,
corresponding to distinct soil layers. Soil characteristics recorded
for a layer typically consist of a high and low value, which describes a
range for that characteristic within that layer. Included among the
characteristics of the soil layer is the thickness of the layer.
In developing the USSOILS.MUID_ATTS table, it is necessary to aggregate
the layer and component information up to the level of a map unit. To
aggregate layer information to the component level, we first construct a
simple average of the high and low values of a characteristic for each
layer. We then construct a weighted average across all layers of the
layer-specific characteristic averages, the weights being the thickness
of the layer relative to the total thickness of all layers. For
component-level information that is expressed as a range, we construct a
simple average of the high and low values defining the range. These
steps reduce layer-specific information and ranges of component-specific
information into a single datum of component-specific information for
each characteristic in the data base. Finally, to obtain map unit
information, we construct a weighted average across all components of
the component-specific information, the weights being the component
percentages given for the map unit.
Included in the Notes section below are the computer programs used to
construct the USSOILS.MUID_ATTS data base, along with an AML program for
transferring this information to the polygon attribute table
USSOILS.PAT. We ask the reader to refer to the documentation contained
in these programs to obtain detailed information on the methods used to
construct each data item. The following is a brief description of how
the programs were used.
The AMLs "layer_out.aml" and "comp_out.aml" were run using the UNIX
batch program "batch.prog" to write data from the STATSGO State INFO
layer and comp files into ascii files. The ascii files were read by the
SAS program "setussoils.sas" to aggregate data from the layer and
component level to the map unit level. If there is no information
available to determine a characteristic's value in a given map unit, the
characteristic is given the value -0.1 to indicate a missing value. The
program "setussoils.sas" creates an ascii, comma-delimited file and a
SAS file of the aggregated, map unit data containing information for
10,470 map units. The comma-delimited, ascii file is then read back
into ARC/INFO using the aml "ussoils_muid_atts.aml" to create the
attribute table USSOILS.MUID_ATTS. Note that there is a discrepancy
between the number of map units contained in the combined COMP and LAYER
files (10,470) and the number contained in the polygon attribute table
(PAT) USSOILS.PAT (10,498 broken out into 78,518 polygons). The
discrepancy arises because 3 map units in the COMP and LAYER files were
not included in the PAT (these are - VT029, UTWA1 (not in LAYER file
either), and NE165 (not in LAYER file either)), while 31 map units in
the PAT coverage were not in the COMP or LAYER files. The 31 map units
missing from the COMP and LAYER files are all "water" designated map
units for which the values of all items are missing. To assure that the
attribute table is complete, the program 'ussoils_muid_atts.aml' appends
the missing MUIDs from USSOILS.PAT to USSOILS.MUID_ATTS and sets the
attribute values (except for STATE) to missing. Thus, the total number
of map units contained in USSOILS.MUID_ATTS is 10,501 (10,470 + 31). We
made no attempts to correct the USSOILS.PAT file for the 3 missing map
units contained in the COMP and LAYER files and in the attribute table
USSOILS.MUID_ATTS.
To assist the user in mapping the attribute information, we include the
program 'ussoils_atts.aml' in the "Notes" section. This program relates
the attribute information for the 10,498 "mapped" map units (10,501 - 3)
to the 78,518 polygons contained in the polygon attribute table
USSOILS.PAT. This program may be run as an AML from the command line in
ARC by entering the command: &r ussoils_atts.
Revisions:
Process_Step
Process_Description
1.0 Original Version
1.1 Changed the documentation and coverages in accordance with
comments received from reviewers. Created the INFO file
USSOILS.MUID_ATTS containing the attribute information for
10,501 map units. Deleted this information from the polygon
attribute table USSOILS.PAT. Changed the programs and
documentation to reflect this change in file structure.
Reviews_Applied_to_Data:
Summary of review by Ken Lanfear, Network Info Products Coordinator,
Reston, VA, August 21, 1995.
Ken reviewed the metadata for the State Soil Geographic (STATSGO) Data
Base for the Conterminous United States, and the associated coverage,
ussoils.
He viewed the coverage on a computer screen to ensure arcs were present
for the 48 conterminous States and the District of Columbia (included in
Maryland). He selected several States by Mapping Unit ID (MUID) and
plotted polygons to check that the states were complete and that mapping
units plotted in the correct state. He also examined the polygon
attribute table, USSOILS.PAT, to note record counts and verify the
format. He spot checked one mapping unit (TX118) against the original
data (which was on line) and verified that the HYGRP and DRAIN items
were computed correctly.
He read the procedures included under supplementary information, and
concurs with the overall processing steps. However, time did not permit
him to check details of the coding.
Ken found one possible discrepancy: There are 10,499 (actually 10,498 if
we exclude the null map unit consisting of the "outer" polygon to the
coverage) unique MUID's in the USSOILS.PAT file, but only 10,470 in the
SOIL_ATTS file. He inquired where the 29 extra units came from?
Ken emphasized that the narrative portion should be modified to make it
clear that each mapping unit can be comprised of several polygons. This
caused him some confusion initially.
Ken had a suggestion for reducing the size of the coverage. Instead of
appending all the items of SOIL_ATTS to USSOILS.PAT, why not just rename
SOIL_ATTS to USSOILS.SOIL_ATTS ? This file would export with the
coverage. By copying to the .PAT, the values are repeated an average of
about 7.8 times. However, since the current form of ussoils is large but
workable, he made this suggestion optional.
Summary of review by Barb Ruddy, Hydrologist, Lakewood, CO, August 31,
1995.
Barb looked at the programs to make sure they made sense. She found the
programs to be well documented and the procedures to be appropriate for
aggregating the comp and layer information to a single map unit value.
She checked the values for the variable hygrp and found they were
comparable to the analysis that she and Bill Battaglin had done. She
also looked at how the data plotted nationally and it checked.
Barb's main concern was the inefficient storage of the attribute
information. Because each map unit is repeated multiple times in the PAT
file, she suggested that the attribute data could be more efficiently
stored in an info file.
Related_Spatial_and_Tabular_Data_Sets:
None
Other_References_Cited:
U.S. Department of Agriculture, National Resource Conservation Service,
National Soil Survey Center, 1991, "State Soil Geographic (STATSGO) Data
Base: Data use information," Miscellaneous Publication Number 1492, 110
p. (Revised July 1994.)
Notes:
The AMLs and SAS programs used to create USSOILS.MUID_ATTS and to
transfer the attribute information to the polygon attribute table
USSOILS.PAT are given below. Please refer to the documentation
contained in these programs for information on variable descriptions,
and computation methods.
1. The AML "layer_out.aml" used to unload selected items from the
individual STATSGO State layer files into a single ascii data set.
/*----------------------------------------------------------------------
/*
/* Command name: LAYER_OUT.AML
/* Language: AML
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
/* Purpose: Program outputs soil LAYER data for processing in SAS.
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
/* Comments:
/* 1. Item description:
/* LAYDEPH,LAYDEPL = layer depth high,low values
/* AWC = available water capacity (inches/inch)
/* CLAY = clay content of soil (% of soil < 2mm in size)
/* KFFACT = soil erodibility f-factor
/* OM = organic matter content (% by weight)
/* PERM = permeability rates (inches/hour)
/* LL = liquid limit of the soil (%moisture by weight)
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
/* History:
/* Author/Site, Date, Event
/* ------------------------------------------------------------
/* R. Alexander/G. Schwarz 04/18/95 CREATED
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
&sv STATEUP := [TRANSLATE [response 'ENTER STATE']]
&DATA arc info
ARC
/*
CALC $NM = 1
CALC $COMMA-SWITCH = -1
CALC $PRINTER-SIZE = 200
/*======================================================================
/*
SEL LAYER
OUTPUT /srv3/bsa/gschwarz/statsgo/LAYER.%STATEUP% INIT
PRINT MUID,SEQNUM,LAYDEPH,LAYDEPL,AWCH,~
AWCL,CLAYH,CLAYL,KFFACT,OMH,OML,~
PERMH,PERML,LLH,LLL
/*
Q STOP
&END
&RETURN
2. The AML "comp_out.aml" used to unload selected items from the
individual STATSGO State component files into a single ascii
data set.
/*----------------------------------------------------------------------
/*
/* Command name: COMP_OUT.AML
/* Language: AML
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
/* Purpose: Program outputs soil COMP data for processing in SAS.
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
/* Comments:
/* 1. Output data are averages of high and low values
/*
/* 2. Item description:
/* MUID = Mapunit identifier
/* SEQNUM = component identifier
/* COMPNAME = Name of the component
/* COMPKIND = Description of the kind of component
/* COMPPCT = Percent of mapunit represented by component
/* DRAINAGE = Drainage quality (1=well drained to 7=poorly drained)
/* HYDGRP = soil index variables (1=well drained to 4=poorly drained)
/* HYDRIC = hydric soil indicator (1 if hydric)
/* ANFLOOD = Annual flood frequency (1 = frequent (>50% chance)
/* 2 = occasional (5-50% chance), 3 = rare (<5% chance))
/* SLOPE = Slope of surface (percent)
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
/* History:
/* Author/Site, Date, Event
/* ------------------------------------------------------------
/* R. Alexander/G. Schwarz 04/18/95 CREATED
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
&sv STATEUP := [TRANSLATE [response 'ENTER STATE']]
/*
&DATA arc info
ARC
/*
CALC $NM = 1
CALC $COMMA-SWITCH = -1
CALC $PRINTER-SIZE = 200
/*======================================================================
/*
SEL COMP
CALC SLOPE = ( SLOPEL + SLOPEH ) / 2
/*
OUTPUT /srv3/bsa/gschwarz/statsgo/COMP.%STATEUP% INIT
PRINT MUID,SEQNUM,COMPNAME,COMPKIND,~
COMPPCT,DRAINAGE,HYDGRP,HYDRIC,~
SLOPE,ANFLOOD
/*
Q STOP
&END
&RETURN
3. The program "batch.prog" is used to run the AML's "layer_out.aml" and
"comp_out.aml" to create individual layer and comp files for each state.
The resulting state files will be read by the SAS program
"setussoils.sas."
#./bin/ksh
#################################################################
# PROGRAM : BATCH.PROG #
# DATE : 04/18/95 #
# PURPOSE : THIS PROGRAM PROCESSES STATSGO AML OUTPUT PROGRAMS#
# FOR EACH OF THE STATES. #
# THE PROGRAM CHANGES THE READ/WRITE ATTRIBUTES OF #
# THE STATSGO STATE DIRECTORIES AND #
# DIRECTS THE LOOP VALUES TO THE AML #
#################################################################
for state in al ar az ca co ct de fl ga ia id il in ks ky la ma md me mi \
mn mo ms mt nc nd ne nh nj nm nv ny oh ok or pa ri sc sd tn tx ut va vt \
wa wi wv wy; do
#chmod 755 /srv3/bsa/gschwarz/statsgo/data/$state/spatial/info/*
#chmod 755 /srv3/bsa/gschwarz/statsgo/data/$state/spatial/$state/*
cd /srv3/bsa/gschwarz/statsgo/data/$state/spatial
/gis2/esri70/arcexe70/programs/arc<<-::::
&r /srv3/bsa/gschwarz/statsgo/layer_out
$state
&r /srv3/bsa/gschwarz/statsgo/comp_out
$state
q
::::
done
4. The SAS program "setussoils.sas" used to read the ascii files created by
"layer_out.aml" and "comp_out.aml", perform averages of the data, merge
the information from the layer file into the component file, and aggregate
the component level information into a file having mapunit as the unit of
observation. The resulting "map unit" file is output as both an ascii,
comma-delimited file and a SAS file.
/* Program to read the conterminous state statsgo ascii info files,
comp.state and layer.state, and calculate summary statistics by muid.
The program prints an ascii file which is then passed back to info in
a latter step.
Program written by Greg Schwarz, 4/24/95.
The program uses the SAS macro language to perform iterative appends
to the main database. Two database files are created, an ascii file
ussoils.dat containing comma-delimited data, and a SAS dataset,
ussoils.ssd. To iteratively build the files, we use the mod option
of the file statement for the ascii file, and proc append for the SAS
file.
The program reads in the layer.state file (where state refers to the
state name and is updated as the program iterates through the do loop.
The variables taken from this file are:
muid character map unit identifier (first two characters are
the state abbreviation).
seqnum integer sequence number identifying the component
(there are up to 21 components in a map unit).
laydeph integer depth of lower boundary of the layer (in
inches). There are no more than 6 layers to a
component
laydepl integer depth of upper boundary of the layer (in
inches).
awch float high range of available water capacity (in
inches per inch) for the given
layer/component/mapunit.
awcl float low range of available water capacity (in
inches per inch).
clayh float high range of percent of soil consisting of
clay (in percent of material less than 2mm in
size).
clayl float low range of percent of soil consisting of
clay (in percent).
kffact float actual k factor used in universal soil loss
equation to calculate soil loss by water.
llh float high range of liquid limit of soil layer
(in percent moisture by weight).
lll float low range of liquid limit of soil layer
(in percent moisture by weight).
omh float high range of organic material in the soil
(in percent by weight).
oml float low range of organic material in the soil (in
percent by weight).
permh float high range of the permeability of the soil
(in inches per hour).
perml float low range of the permeability of the soil (in
inches per hour).
First, we compute the average of the high and low values for those
variables expressed as a range. We then average the varaiables over all
layers using the layer thickness (laydeph - laydepl) as weights. The
final summary layer file contains a single weighted value for each
component of each mapunit.
The program then reads in the component file comp.state for each
state. The variables read in are:
muid character the map unit identifier
seqnum integer the component number
compname character the name of the component (contains useful
information for tagging certain types of
components as explained below).
compkind character a one character code useful for tagging
certain types of components as explained below.
comppct integer the percent of the mapunit covered by the
particular component.
drainage character a two character code identifying the
quality of the drainage for the component.
The codes are E = excessive, SE = somewhat
excessive, W = well drained, MW = moderately
drained, SP = somewhat poorly drained,
P = poorly drained, and VP = very poorly
drained. These codes are converted into
numeric values and assigned to the variable
drain as follows: E = 1, SE = 2, W = 3,
MW = 4, SP = 5, P = 6 and VP = 7.
hydgrp character a three digit code identifying the
hydrologic characteristics of the soil. The
codes are defined in the Statsgo information
guide. We convert the character codes into
numeric codes according to Battaglin's methods.
The numeric codes are assigned to the variable
hygrp. The codes are A = 1, B = 2, C = 3, D,
A/D, B/D, and C/D = 4. Also, we subselect
areas and assign values for hygrp.
Miscellaneous areas (denoted by M in compkind)
and labeled as Dumps, and Gullied Land in
compname are assigned the hygrp = 2.5 if the
hydgrp value is missing. Areas denoted
as Pits, Rock Outcrops, Terrace Escarpments,
and Urban land with missing hydgrp are
assigned a hygrp of 4.
hydric character Hydric soil rating, Y = hydric, N = non-hydric.
slope float The slope of the component (in percent).
The value read in from the comp.state file
is an average of the high and low range values
stored in the INFO comp file for that state.
anflood character Frequency of annual flooding. Three classes,
frequent (FREQ) - greater than 50%,
occasional (OCCAS) 5-50% chance, and
rare (RARE) less than 5% chance.
The layer file and the comp file are merged together by muid and
seqnum. Water denoted components (from compname) are assigned missing
values for all characteristics except comppct. The numeric variables
are then averaged over all components within a mapunit using the
comppct as weights. The final file gives one observation per map
unit. Note that any remaining missing values are assigned the
value of -.1. */
libname dir '';
filename outfile '/srv3/bsa/gschwarz/statsgo/ussoils.dat' ;
/* Define the states for dynamically allocating files */
%let state1 = al ;
%let state2 = ar ;
%let state3 = az ;
%let state4 = ca ;
%let state5 = co ;
%let state6 = ct ;
%let state7 = de ;
%let state8 = fl ;
%let state9 = ga ;
%let state10 = ia ;
%let state11 = id ;
%let state12 = il ;
%let state13 = in ;
%let state14 = ks ;
%let state15 = ky ;
%let state16 = la ;
%let state17 = ma ;
%let state18 = md ;
%let state19 = me ;
%let state20 = mi ;
%let state21 = mn ;
%let state22 = mo ;
%let state23 = ms ;
%let state24 = mt ;
%let state25 = nc ;
%let state26 = nd ;
%let state27 = ne ;
%let state28 = nh ;
%let state29 = nj ;
%let state30 = nm ;
%let state31 = nv ;
%let state32 = ny ;
%let state33 = oh ;
%let state34 = ok ;
%let state35 = or ;
%let state36 = pa ;
%let state37 = ri ;
%let state38 = sc ;
%let state39 = sd ;
%let state40 = tn ;
%let state41 = tx ;
%let state42 = ut ;
%let state43 = va ;
%let state44 = vt ;
%let state45 = wa ;
%let state46 = wi ;
%let state47 = wv ;
%let state48 = wy ;
/* Begin the macro */
%macro loopy ;
/* Iterate over conterminous states */
%do iter = 1 %to 48 ;
option dquote ;
/* Dynamically define the layer and comp files for processing (by state) */
filename indatal "~/statsgo/layer.&&&state&iter" ;
filename indatac "~/statsgo/comp.&&&state&iter" ;
/* Read in the layer specific data for each state */
data one ;
infile indatal missover ;
input
muid $ 2-8
seqnum 10-11
laydeph 13-14
laydepl 16-17
awch 19-22
awcl 24-27
clayh 29-30
clayl 32-33
kffact 35-38
omh 40-43
oml 45-48
permh 50-54
perml 56-60
llh 62-64
lll 66-68
;
/* Compute the thickness of each layer and the thickness weighted
values of awc, clay, kffact, om, and perm. If a range is given for
a variable, then take the average of the range */
thick = laydeph - laydepl ;
awc = thick*(awch + awcl)/2 ;
clay = thick*(clayh + clayl)/2 ;
kffact = thick*kffact ;
om = thick*(omh + oml)/2 ;
perm = thick*(permh + perml)/2 ;
ll = thick*(llh+lll)/2 ;
/* m(varname) stores the thickness of layers in which missing values
for varname are encountered. This information is necessary to ensure
we normalize the weights correctly later in the program */
if awc = . then mawc = thick ;
else mawc = 0 ;
if clay = . then mclay = thick ;
else mclay = 0 ;
if kffact = . then mkffact = thick ;
else mkffact = 0 ;
if om = . then mom = thick ;
else mom = 0 ;
if perm = . then mperm = thick ;
else mperm = 0 ;
if ll = . then mll = thick ;
else mll = 0 ;
keep muid seqnum thick awc clay kffact om perm ll
mawc mclay mkffact mom mperm mll ;
proc sort ; by muid seqnum ;
/* Compute the sum of the thickness*varname over all layers.
Also accumulate the thickness of layers where varname is
missing */
proc means noprint ;
var thick awc clay kffact om perm ll
mawc mclay mkffact mom mperm mll ;
by muid seqnum ;
output out = layer sum = thick awc clay kffact om perm ll
mawc mclay mkffact mom mperm mll ;
/* Read in the state component files */
data comp ;
infile indatac missover ;
input
muid $ 2-7
seqnum 10-11
compname $ 13-42
compkind $ 44
comppct 46-48
drainage $ 50-54
hydgrp $ 62-64
hydric $ 66
slope 68-69
anflood $ 71-74 ;
proc sort; by muid seqnum ;
data comp ; merge comp layer ; by muid seqnum ;
/* Recode the hydgrp data to numeric values (see Battaglin) */
if hydgrp = 'A ' then hygrp = 1 ;
else if hydgrp = 'B ' then hygrp = 2 ;
else if hydgrp = 'C ' then hygrp = 3 ;
else if hydgrp = 'D ' then hygrp = 4 ;
else if hydgrp = 'A/D' then hygrp = 4 ;
else if hydgrp = 'B/D' then hygrp = 4 ;
else if hydgrp = 'C/D' then hygrp = 4 ;
else hygrp = . ;
/* Recode the drainage data to numeric values */
if drainage = 'A ' then drain = 4.0 ;
else if drainage = 'E ' then drain = 1.0 ;
else if drainage = 'E,MW ' then drain = 2.5 ;
else if drainage = 'E,P ' then drain = 3.5 ;
else if drainage = 'E,SE ' then drain = 1.5 ;
else if drainage = 'E,W ' then drain = 2.0 ;
else if drainage = 'MW ' then drain = 4.0 ;
else if drainage = 'MW,A ' then drain = 4.0 ;
else if drainage = 'MW,P ' then drain = 5.0 ;
else if drainage = 'MW,SE' then drain = 3.0 ;
else if drainage = 'MW,SP' then drain = 4.5 ;
else if drainage = 'MW,W ' then drain = 3.5 ;
else if drainage = 'P ' then drain = 6.0 ;
else if drainage = 'P,A ' then drain = 5.0 ;
else if drainage = 'P,SP ' then drain = 5.5 ;
else if drainage = 'P,VP ' then drain = 6.5 ;
else if drainage = 'PD,A ' then drain = 5.0 ;
else if drainage = 'SE ' then drain = 2.0 ;
else if drainage = 'SE,E ' then drain = 1.5 ;
else if drainage = 'SE,MW' then drain = 3.0 ;
else if drainage = 'SO ' then drain = 5.0 ;
else if drainage = 'SP ' then drain = 5.0 ;
else if drainage = 'SP,A ' then drain = 4.5 ;
else if drainage = 'SP,E ' then drain = 3.0 ;
else if drainage = 'SP,MW' then drain = 4.5 ;
else if drainage = 'SP,P ' then drain = 5.5 ;
else if drainage = 'SP,VP' then drain = 6.0 ;
else if drainage = 'SP,W ' then drain = 4.0 ;
else if drainage = 'SW ' then drain = 4.0 ;
else if drainage = 'VP ' then drain = 7.0 ;
else if drainage = 'VP,P ' then drain = 6.5 ;
else if drainage = 'VP,SP' then drain = 6.0 ;
else if drainage = 'W ' then drain = 3.0 ;
else if drainage = 'W,A ' then drain = 3.5 ;
else if drainage = 'W,E ' then drain = 2.5 ;
else if drainage = 'W,MW ' then drain = 3.5 ;
else if drainage = 'W,SE ' then drain = 2.5 ;
else if drainage = 'W,SP ' then drain = 4.0 ;
else if drainage = 'W,VP ' then drain = 5.0 ;
else if drainage = 'WD ' then drain = 3.0 ;
else drain = . ;
/* Recode the anflood data */
if anflood = 'FREQ' then afldfreq = 1 ;
else if anflood = 'OCCA' then afldfreq = 2 ;
else if anflood = 'RARE' then afldfreq = 3 ;
else if anflood = 'NONE' then afldfreq = 4 ;
else afldfreq = . ;
/* Recode the hydric data */
if hydric = 'Y' then ifhyd = 1 ;
else if hydric = 'N' then ifhyd = 0 ;
else ifhyd = . ;
/* Assign default values to components denoted as Miscellaneous areas */
if compkind = 'M' then do ;
if compname = 'BEACHES' then do ;
if drain = . then drain = 6 ;
end ;
if compname = 'COASTAL BEACHES' then drain = 6 ;
if compname = 'COASTAL DUNES' then clay = 1 ;
if compname = 'DUMPS' then do ;
if hygrp = . then hygrp = 4 ;
end ;
if compname = 'GULLIED LAND' then do ;
if hygrp = . then hygrp = 2.5 ;
end ;
if compname = 'LAVA FLOWS' then do ;
if clay = . then clay = 0 ;
end ;
if compname = 'PITS' then do ;
if clay = . then clay = .5 ;
if hygrp = . then hygrp = 2.5 ;
end ;
if compname = 'ROCK OUTCROP' then do ;
if hygrp = . then hygrp = 4 ;
end ;
if compname = 'TERRACE ESCARPMENTS' or
compname = 'URBAN LAND' or
compname = 'URBANLAND' then hygrp = 4 ;
end ;
/* Set numeric data to missing if the component is WATER */
if compname = 'WATER' then do ;
thick = . ;
awc = . ;
clay = . ;
kffact = . ;
om = . ;
perm = . ;
hygrp = . ;
drain = . ;
slope = . ;
ll = . ;
ifhyd = . ;
afldfreq = . ;
end ;
/* Compute the component weighted values, and normalize for thickness.
Set the variable to missing if thickness equals m(varname). Other-
wise, normalize the layer weights by dividing by the total non-
missing thickness of all the layers. */
if mawc = thick then awc = . ;
else awc = comppct*awc/(thick - mawc) ;
if mclay = thick then clay = . ;
else clay = comppct*clay/(thick - mclay) ;
if mkffact = thick then kffact = . ;
else kffact = comppct*kffact/(thick - mkffact) ;
if mom = thick then om = . ;
else om = comppct*om/(thick - mom) ;
if mperm = thick then perm = . ;
else perm = comppct*perm/(thick - mperm) ;
if mll = thick then ll = . ;
else ll = comppct*ll/(thick - mll) ;
thick = comppct*thick ;
hygrp = comppct*hygrp ;
drain = comppct*drain ;
slope = comppct*slope ;
ifhyd = comppct*ifhyd ;
afldfreq = comppct*afldfreq ;
/* m(varname) stores the component pct of components in which missing values
for varname are encountered. This information is necessary to ensure
we normalize the weights correctly later in the program */
if awc = . then mawc = comppct ;
else mawc = 0 ;
if clay = . then mclay = comppct ;
else mclay = 0 ;
if kffact = . then mkffact = comppct ;
else mkffact = 0 ;
if om = . then mom = comppct ;
else mom = 0 ;
if perm = . then mperm = comppct ;
else mperm = 0 ;
if ll = . then mll = comppct ;
else mll = 0 ;
if thick = . then mthick = comppct ;
else mthick = 0 ;
if hygrp = . then mhygrp = comppct ;
else mhygrp = 0 ;
if drain = . then mdrain = comppct ;
else mdrain = 0 ;
if slope = . then mslope = comppct ;
else mslope = 0 ;
if ifhyd = . then mifhyd = comppct ;
else mifhyd = 0 ;
if afldfreq = . then mafldf = comppct ;
else mafldf = 0 ;
keep muid seqnum comppct awc clay kffact om perm thick hygrp
drain slope ll ifhyd afldfreq
mawc mclay mkffact mom mperm mll mthick mhygrp mdrain
mslope mifhyd mafldf ;
/* Sum the comppct*varname over components
Accumulate the missing comppct for each varname */
proc means data = comp noprint ;
var comppct awc clay kffact om perm thick hygrp drain
slope ll ifhyd afldfreq
mawc mclay mkffact mom mperm mll mthick mhygrp mdrain
mslope mifhyd mafldf ;
by muid ;
output out = mapunit
sum = comppct awc clay kffact om perm thick hygrp drain
slope ll ifhyd afldfreq
mawc mclay mkffact mom mperm mll mthick mhygrp mdrain
mslope mifhyd mafldf ;
data mapunit ; set mapunit ;
/* Normalize the averaged data for comppct.
Set the variable to missing if comppct equals m(varname). Other-
wise, normalize the comppct weights by dividing by the total non-
missing comppct of all the components. */
if mawc = comppct then awc = . ;
else awc = awc / (comppct - mawc) ;
if mclay = comppct then clay = . ;
else clay = clay / (comppct - mclay) ;
if mkffact = comppct then kffact = . ;
else kffact = kffact / (comppct - mkffact) ;
if mom = comppct then om = . ;
else om = om / (comppct - mom) ;
if mperm = comppct then perm = . ;
else perm = perm / (comppct - mperm) ;
if mthick = comppct then thick = . ;
else thick = thick / (comppct - mthick) ;
if mhygrp = comppct then hygrp = . ;
else hygrp = hygrp / (comppct - mhygrp) ;
if mdrain = comppct then drain = . ;
else drain = drain / (comppct - mdrain) ;
if mslope = comppct then slope = . ;
else slope = slope / (comppct - mslope) ;
if mll = comppct then ll = . ;
else ll = ll / (comppct - mll) ;
if mifhyd = comppct then ifhyd = . ;
else ifhyd = ifhyd / (comppct - mifhyd) ;
if mafldf = comppct then afldfreq = . ;
else afldfreq = afldfreq / (comppct - mafldf) ;
/* Extract the state abbreviation from the muid */
state = substr(muid,1,2) ;
/* Set missing values to -.1 */
if awc = . then awc = -.1 ;
if clay = . then clay = -.1 ;
if kffact = . then kffact = -.1 ;
if om = . then om = -.1 ;
if perm = . then perm = -.1 ;
if thick = . then thick = -.1 ;
if hygrp = . then hygrp = -.1 ;
if drain = . then drain = -.1 ;
if slope = . then slope = -.1 ;
if ll = . then ll = -.1 ;
if ifhyd = . then ifhyd = -.1 ;
if afldfreq = . then afldfreq = -.1 ;
com = ',' ;
/* Append the state's map unit data to the ascii ussoils dataset */
file outfile mod ;
put
muid $ 1-7
com $ 8
state $ 9-10
com $ 11
awc 12-16 .2
com $ 17
clay 18-21 .1
com $ 22
kffact 23-27 .2
com $ 28
om 29-32 .1
com $ 33
perm 34-38 .2
com $ 39
thick 40-43 .1
com $ 44
hygrp 45-48 .1
com $ 49
drain 50-53 .1
com $ 54
slope 55-58 .1
com $ 59
ll 60-64 .1
com $ 65
ifhyd 66-69 .1
com $ 70
afldfreq 71-74 .1
;
drop _type_ _freq_ com mawc mclay mkffact mom mperm mll mthick
mhygrp mdrain mslope mifhyd mafldf ;
/* Append the state's map unit data to the SAS ussoils dataset */
proc append base = dir.ussoils data = mapunit ;
%end ;
%mend loopy ;
/* Execute the macro */
%loopy ;
5. The AML "ussoils_muid_atts.aml" used to read the ascii file
created by the SAS program and create the PAT
coverage "ussoils.muid_atts."
/*----------------------------------------------------------------------
/*
/* Command name: USSOILS_MUID_ATTS.AML
/* Language: AML
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
/* Purpose: Program creates the INFO attribute table USSOILS.MUID_ATTS
/* from the computed averages of STATSGO variables created by
/* the SAS program setussoils.sas.
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
/* Comments:
/* 1. Item description:
/* AWC = available water capacity (inches/inch)
/* CLAY = clay content of soil (% of soil < 2mm in size)
/* KFFACT = soil erodibility f-factor
/* OM = organic matter content (% by weight)
/* PERM = permeability rates (inches/hour)
/* THICK = total thickness of all sampled soil layers (inches)
/* HYGRP = soil index variables (1=well drained to 4=poorly drained)
/* DRAIN = soil index variable (1=well drained to 7=poorly drained)
/* SLOPE = average slope (%)
/* LL = liquid limit (percent moisture by weight)
/* IFHYDRIC = hydric soil indicator (1 if hydric)
/* AFLDFREQ = annual flood frequency (1 = frequent (>50% chance)
/* 2 = occasional (5-50% chance), 3 = rare (<5% chance))
/*
/* 2. Relate the USSOILS.PAT file to USSOILS.MUID_ATTS to determine map unit
/* identifiers for map units that are in USSOILS.PAT but not in
/* COMP or LAYER files, and thus not in USSOILS.MUID_ATTS. These
/* missing MUIDs are then written to a temporary file, where they are
/* summarized (to eliminate redundancies from multiple polygons in
/* USSOILS.PAT having the same MUIDs), and then added to
/* USSOILS.MUID_ATTS.
/*
/* 3. The missing MUIDs added into USSOILS.MUID_ATTS have no attribute
/* information. We reselect these MUIDs and assign missing values to
/* all the items, except for STATE. To fill in STATE, we create the
/* redefined item STID that consists of the first two characters of
/* MUID. We then move this value into the value for STATE.
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
/* History:
/* Author/Site, Date, Event
/* ------------------------------------------------------------
/* R. Alexander/G. Schwarz 04/24/95 CREATED
/* R. Alexander/G. Schwarz 09/08/95 Modified to create
/* USSOILS.MUID_ATTS only
/* and to include missing
/* MUIDs in the
/* USSOILS.MUID_ATTS file.
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
&DATA arc info
ARC
/*
CALC $NM = 1
CALC $COMMA-SWITCH = -1
CALC $PRINTER-SIZE = 200
/*======================================================================
/*
DEFINE USSOILS.MUID_ATTS
MUID,7,7,C
STATE,2,2,C
AWC,4,5,F,2
CLAY,4,4,F,1
KFFACT,4,5,F,2
OM,4,4,F,1
PERM,4,5,F,2
THICK,4,4,F,1
HYGRP,4,4,F,1
DRAIN,4,4,F,1
SLOPE,4,4,F,1
LL,4,5,F,1
IFHYDRIC,4,4,F,1
AFLDFREQ,4,4,F,1
/*
ADD FROM /srv3/bsa/gschwarz/statsgo/ussoils.dat
SEL USSOILS.MUID_ATTS
SORT MUID
/*
/* Create temporary file FILE1 to hold missing values.
/*
SEL USSOILS.MUID_ATTS
REDEFINE
1
STID
2
2
C
MODIFY FILE1
/*
/* Find missing MUIDs in USSOILS.PAT and put in FILE1
/*
SEL USSOILS.PAT
RELATE USSOILS.MUID_ATTS 1 MUID ORDER
RESEL MUID NE $1MUID
RESEL MUID NE ''
RELATE FILE1 2 MUID INIT
MOVE MUID TO $2MUID
SEL FILE1
SORT MUID
/*
/* Relate FILE1 to USSOILS.MUID_ATTS by MUID and do SUMMARY
/*
RELATE USSOILS.MUID_ATTS 1 MUID SUMMARY
/*
/* set all MUID not in COMP files with water designation to missing
/*
CALC $1AWC = -0.1
CALC $1CLAY = -0.1
CALC $1KFFACT = -0.1
CALC $1OM = -0.1
CALC $1PERM = -0.1
CALC $1THICK = -0.1
CALC $1HYGRP = -0.1
CALC $1DRAIN = -0.1
CALC $1SLOPE = -0.1
CALC $1LL = -0.1
CALC $1IFHYDRIC = -0.1
CALC $1AFLDFREQ = -0.1
MOVE STID TO $1STATE
/*
/* Delete the temporary file FILE1
/*
SEL FILE1
ERASE FILE1
Y
SEL USSOILS.MUID_ATTS
SORT MUID
/*
Q STOP
&END
DROPITEM USSOILS.MUID_ATTS USSOILS.MUID_ATTS STID
6. The AML 'ussoils_atts.aml' which may be used to transfer the attribute infor
contained in the attribute table USSOILS.MUID_ATTS to the polygon attribute tabl
USSOILS.PAT to permit mapping the attribute information.
/*----------------------------------------------------------------------
/*
/* Command name: USSOILS_ATTS.AML
/* Language: AML
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
/* Purpose: Program creates attribute information for the national
/* coverage USSOILS.PAT. The attribute information is taken from the
/* info file USSOILS.MUID_ATTS.
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
/* Comments:
/* 1. Item description:
/* AWC = available water capacity (inches/inch)
/* CLAY = clay content of soil (% of soil < 2mm in size)
/* KFFACT = soil erodibility f-factor
/* OM = organic matter content (% by weight)
/* PERM = permeability rates (inches/hour)
/* THICK = total thickness of all sampled soil layers (inches)
/* HYGRP = soil index variables (1=well drained to 4=poorly drained)
/* DRAIN = soil index variable (1=well drained to 7=poorly drained)
/* SLOPE = average slope (%)
/* LL = liquid limit (percent moisture by weight)
/* IFHYDRIC = hydric soil indicator (1 if hydric)
/* AFLDFREQ = annual flood frequency (1 = frequent (>50% chance)
/* 2 = occasional (5-50% chance), 3 = rare (<5% chance))
/*
/* 2. Items are ADDED to USSOILS.PAT, then we RELATE to USSOILS.MUID_ATTS
/* on the basis of MUID. Note that there are 3 MUIDS contained in
/* USSOILS.MUID_ATTS that are not in USSOILS.PAT.
/*
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
/* History:
/* Author/Site, Date, Event
/* ------------------------------------------------------------
/* R. Alexander/G. Schwarz 09/08/95 CREATED
/*::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
/*
ADDITEM USSOILS.PAT USSOILS.PAT STATE 2 2 C
ADDITEM USSOILS.PAT USSOILS.PAT AWC 4 5 F 2
ADDITEM USSOILS.PAT USSOILS.PAT CLAY 4 4 F 1
ADDITEM USSOILS.PAT USSOILS.PAT KFFACT 4 5 F 2
ADDITEM USSOILS.PAT USSOILS.PAT OM 4 4 F 1
ADDITEM USSOILS.PAT USSOILS.PAT PERM 4 5 F 2
ADDITEM USSOILS.PAT USSOILS.PAT THICK 4 4 F 1
ADDITEM USSOILS.PAT USSOILS.PAT HYGRP 4 4 F 1
ADDITEM USSOILS.PAT USSOILS.PAT DRAIN 4 4 F 1
ADDITEM USSOILS.PAT USSOILS.PAT SLOPE 4 4 F 1
ADDITEM USSOILS.PAT USSOILS.PAT LL 4 5 F 1
ADDITEM USSOILS.PAT USSOILS.PAT IFHYDRIC 4 4 F 1
ADDITEM USSOILS.PAT USSOILS.PAT AFLDFREQ 4 4 F 1
/*
&DATA arc info
ARC
/*
CALC $NM = 1
CALC $COMMA-SWITCH = -1
CALC $PRINTER-SIZE = 200
/*======================================================================
/*
SEL USSOILS.PAT
RELATE USSOILS.MUID_ATTS 1 MUID ORDER
MOVE $1STATE TO STATE
CALC AWC = $1AWC
CALC CLAY = $1CLAY
CALC KFFACT = $1KFFACT
CALC OM = $1OM
CALC PERM = $1PERM
CALC THICK = $1THICK
CALC HYGRP = $1HYGRP
CALC DRAIN = $1DRAIN
CALC SLOPE = $1SLOPE
CALC LL = $1LL
CALC IFHYDRIC = $1IFHYDRIC
CALC AFLDFREQ = $1AFLDFREQ
/*
Q STOP
&END
&RETURN
en
Unknown
2008
ground condition
None planned
-123.259807
-122.281551
42.837230
41.989302
4180972.214951
4437050.000000
129625.622285
431824.327758
None
State Soil Geographic (STATSGO) Data Base for the Conterminous United States
None
Conterminous U.S.
Jackson County
Medford
Ashland
Central Point
Rogue River
Shady Cove
Talent
Phoenix
Jacksonville
Gold Hill
Butte Falls
Bear Creek Valley
Access to this geospatial data set requires acceptance of Jackson County's GIS License Agreement.
None
GIS Analyst
mailing and physical address
10 S. Oakdale Ave., Room 302
Medford
OR
97501
USA
541-774-6028
541-774-6787
gis@jacksoncounty.org
8:00am - 5:00pm
Please contact thru email
To order data, please call or e-mail. Thanks
Jackson County GIS
Karim Naguib
See References
None
Unclassified
None
ESRI ArcCatalog 9.3.1.3000
U.S. Dept. of Agriculture, Soil Conservation Service, National Coop. Soil Survey
199410
State Soil Geographic (STATSGO) Data Base: U.S. Coverage by States ...
map
ARC/INFO 7.0 Coverage on CDROM
Feature Class
Access to this geospatial data set requires acceptance of Jackson County's License Agreement.
See Entity_Attribute_Information
See Explanation
Attribute accuracy is described, where present, with each
attribute defined in the Entity and Attribute Section.
Polygon topology present.
Not Applicable
Data 100% complete
Vector
Simple
FALSE
17234
TRUE
FALSE
coordinate pair
0.000328
0.000328
international feet
North American Datum of 1983
Geodetic Reference System 80
6378137.000000
298.257222
GCS_North_American_1983
NAD_1983_StatePlane_Oregon_South_FIPS_3602_Feet_Intl
Explicit elevation coordinate included with horizontal coordinates
1.000000
North American Vertical Datum of 1988
feet
Soils
Selected items of hydrologic relevance from the STATSGO Data Base
STATSGO Data Base ARC/INFO 7.0 Coverage CD-ROM, October 1994
Feature Class
17234
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
ESRI
Sequential unique whole numbers that are automatically generated.
Shape
Feature geometry.
ESRI
Positive real numbers
Coordinates defining the features.
Shape
Geometry
4
0
0
SYMBOL
Internal feature number
Computed
Sequential unique positive integer
SYMBOL
String
8
0
0
NAME
User-assigned feature number
User-defined
Integer
NAME
String
50
0
0
ASPECT
Mapunit Identification code - used to reference observations
STATSGO, October 1994
Character
ASPECT
String
3
0
0
LOSLOPE
2-character State abbreviation
Created from first two characters of muid in STATSGO data base
Character
LOSLOPE
SmallInteger
2
5
0
HISLOPE
Available water capacity (inches per inch)
Created from AWCH and AWCL in STATSGO (10/94) layer file - see narrative
Positive real numbers, missing value indicator = -0.1
HISLOPE
SmallInteger
2
5
0
NONIRR
Percent clay in soil (percent of material less than 2mm in size)
Created from clayh and clayl in STATSGO (10/94) layer file - see narrative
0 to 100, missing value indicator = -0.1
NONIRR
String
10
0
0
IRR
Actual k factor used in water erosion component of universal soil loss equation
Created from STATSGO (10/94) component file - see narrative.
Non-negative real, missing value indicator = -0.1
IRR
String
10
0
0
CLASS
Organic material in soil (in percent by weight)
Created from omh and oml of STATSGO (10/94) layer file - see narrative
0 to 100, missing value indicator = -0.1
CLASS
SmallInteger
2
5
0
NIAUM
Permeability of the soil (in inches per hour)
Created from permh and perml of STATSGO (10/94) layer file - see narrative
Non-negative real, missing value indicator = -0.1
NIAUM
SmallInteger
2
5
0
IAUM
Cumulative thickness of all soil layers (in inches)
Created from laydeph and laydepl of STATSGO (10/94) layer file - see narrative
Positive real, missing value indicator = -0.1
IAUM
SmallInteger
2
5
0
CFOOT
Hydrologic characteristics of soil
Created from hydgrp item of STATSGO (10/94) component file - see narrative
1-4:1=High infiltration,2=Mod infil,3=Slow infil,4=Very slow infil,-0.1=Miss
CFOOT
Single
4
6
1
TREE
Soil drainage
Created from drainage in STATSGO (10/94) component file - see narrative
1-7:1=excess,2=mod excess,3=well,4=mod well,5=mod poor,6=poor,7=v poor,-.1=miss
TREE
String
4
0
0
NONIRRCL
Surface slope (in percent)
Created from slopeh and slopel of STATSGO (10/94) component file - see narrative
0 to 100, missing value indicator = -0.1
NONIRRCL
SmallInteger
2
5
0
RECNO
Liquid limit of soil (in percent moisture by weight)
Created from llh and lll of STATSGO (10/94) layer file - see narrative
0 to 100, missing value indicator = -0.1
RECNO
Double
8
11
0
LIMITATION
Share of map unit components with hydric soils
Created from hydric of STATSGO (10/94) component file - see narrative
Share of map unit components with hydric soils
LIMITATION
String
20
0
0
TYPE
Annual flood frequency
Created from item anflood of STATSGO (10/94) component file - see narrative
1
Greater than 50%
Jackson County GIS Services
2
5% to 50%
Jackson County GIS Services
3
0% to 5%
Jackson County GIS Services
4
None
Jackson County GIS Services
TYPE
String
20
0
0
PRIMEFARM
PRIMEFARM
String
10
0
0
SHAPE.STArea()
SHAPE.STArea()
Double
0
0
0
SHAPE.STLength()
SHAPE.STLength()
Double
0
0
0
The attribute table, USSOILS.MUID_ATTS, contains the following items for
each map unit:
Label Type Description
muid character Map unit identifier (first two characters
are the state abbreviation).
state character 2-character State abbreviation.
awc float Available water capacity (in inches per
inch). Computed as a layer thickness
weighted average, across soil layers, of a
simple average of awch and awcl contained in
the STATSGO layer file. Missing value
.FALSE.
clay float Percent of soil consisting of clay (in
percent of material less than 2mm in size).
Computed as a layer thickness weighted
average, across soil layers, of a simple
average of clayh and clayl contained in the
STATSGO layer file. Missing value indicator
= -0.1.
kffact float Actual k factor used in universal soil loss
equation to calculate soil loss by water.
Computed as a layer thickness weighted
average, across soil layers, of the variable
kffact contained in the STATSGO layer file.
Missing value indicator = -0.1.
ll float Liquid limit of soil layer (in percent
moisture by weight). Computed as a layer
thickness weighted average, across soil
layers, of a simple average of llh and lll
contained in the STATSGO layer file.
Missing value indicator = -0.1.
om float Organic material in the soil (in percent by
weight). Computed as a layer thickness
weighted average, across soil layers, of a
simple average of omh and oml contained in
the STATSGO layer file. Missing value
.FALSE.
perm float Permeability of the soil (in inches per
hour). Computed as a layer thickness
weighted average, across soil layers, of a
simple average of permh and perml contained
in the STATSGO layer file. Missing value
.FALSE.
thick float Depth of soil layers (in inches). Computed
as the sum of the differences between
laydeph and laydepl for each soil layer in
the STATSGO layer file. Missing value
.FALSE.
hygrp float A code identifying the hydrologic
characteristics of the soil. The character
codes defined in the STATSGO component file
are converted into numeric codes according
to Bill Battaglin's methods (Battaglin,
written communication dated March 8, 1995).
The coding transformations are A = 1 (high
infiltration, deep soils, well drained to
excessively drained sands and gravels), B =
2 (moderate infiltration rates, deep and
moderately deep, moderately well and well
drained soils with moderately coarse
textures), C = 3 (slow infiltration rates,
soils with layers impeding downward movement
of water, or soils with moderately fine or
fine textures), D = 4 (very slow
infiltration rates, soils are clayey, have a
high water table, or are shallow to an
impervious layer), Mixture codes A/D, B/D,
and C/D are assigned the value 4. Also, we
subselect certain areas and assign values
for hygrp based on the area type.
Miscellaneous areas (denoted by M in
compkind) and labeled as Dumps, and Gullied
Land in compname are assigned the hygrp =
2.5 if the hydgrp value is missing. Areas
denoted as Pits, Rock Outcrops, Terrace
Escarpments, and Urban land with missing
hydgrp are assigned a hygrp of 4. See the
documentation of the SAS program
"setussoils.sas" for additional details.
The transformed data are averaged across
components using the component percentage as
weights. The missing value indicator is -
0.1.
drain float A code identifying the quality of soil
drainage. The two character code from the
STATSGO component file is converted to a
numeric value according to the following
translation: E = 1 (excessive), SE = 2
(somewhat excessive), W = 3 (well drained),
MW = 4 (moderately drained), SP = 5
(somewhat poorly drained), P = 6 (poorly
drained), and VP = 7 (very poorly drained).
The values are averaged across components
using the component percentage as weights.
The missing value indicator is -0.1.
slope float The slope of the map unit (in percent).
Slope values contained in the STATSGO
component file are averaged using the
component percentage as weights. The
missing value indicator is -0.1.
ifhydric float Share of map unit with hydric soils (1 =
entire map unit has hydric soils). Computed
by summing the component percentage for each
component designated as having hydric soils
according to the variable hydric in the
STATSGO component file. Missing value
.FALSE.
afldfreq float Annual flood frequency code. Flood
frequency designations contained in the
variable anflood in the STATSGO component
file are converted to numeric codes
according to the following translation: 1 =
greater than 50%, 2 = 5% to 50%, 3 = 0% to
5%, and 4 = no flood. Translated variables
are averaged across components using the
component percentage as weights. The
missing value indicator is -0.1.
Not Available
Most of Jackson County's GIS data is available for no charge when downloaded from the Internet. The web site is www.smartmap.org.
63.688
63.688
Shapefile
withheld
Shapefiles can be downloaded at no charge from this web site.
CD-ROM
ISO9660
Email digital data request to Contact Person.
Jackson County GIS
541-774-6028
541-774-6787
gis@jacksoncounty.org
8:00am - 5:00pm
To order data, please call or e-mail. Thanks
mailing and physical address
10 S. Oakdale Ave., Room 302
Medford
OR
97501
USA
JACKSON COUNTY OFFICE OF GEOGRAPHIC INFORMATION SYSTEM LICENSE AGREEMENT THIS AGREEMENT is made by and between Jackson County called 'Licensor' and the client identified on the form, hereinafter called 'Licensee.' The Licensor is the authorized owner of multi-purpose GIS data and the repository of Jackson County specific data, the ownership of which is retained by its originating agency. The Licensor is authorized to disseminate GIS data and to charge fees for this service. The Licensee wishes to secure the non-exclusive right to use the Jackson County GIS (JCGIS) data IN CONSIDERATION of the mutual covenants and conditions herein contained, the Licensor and Licensee agree as follows: 1. RIGHTS GRANTEDIn consideration of the fees set forth on the reverse the Licensor grants to the Licensee the non-exclusive and non-transferable right to use the licensed products and data identified on the reverse (hereinafter the 'licensed data') until such time as this Agreement is terminated pursuant to Section 6 hereof or otherwise expires. 1.1 License of Data and Hardcopy Map Products - The licensed data shall normally be furnished on magnetic tapes, disk or as hardcopy map products; provided, however, that if any other means of communication, delivery or storage shall be used, the terms and provisions of this agreement shall nevertheless apply thereto. 1.2 Delivery - The Licensor shall deliver the licensed data shown on the form through means of tapes, disk, printed materials, manuals, or other means of communication to the Licensee. All such data, tapes, disks, manuals, and printed materials furnishedby the Licensor shall be and remain the property of Jackson County; and the Licensee shall at its own expense return all the data and all means of communication to the Licensor when and if directed upon termination. 1.3 Restrictions on use - The licensed data are solely and exclusively for the internal use of the Licensee and not for the use by any other person or entity, including, but not limited to, any entity which is affiliated with the Licensee unless specifically included in the term Licensee. 1.4 Permitted Use a. Copies. The Licensee may copy licensed data only for backup purposes and not for use by any other person. b. Equipment. Licensed data may be used only on computer equipment owned or leased by the Licensee. c. Derived Products. Graphic displays and printed tabular listings derived from licensed data may be used in publications and presentations, providedthat credit is given to JCGIS as the custodian of the data and credit is also given to the original source of the data if other than the Licensor. 1.5 Prohibited Use a. Unauthorized Distribution. Any sale, distribution, loan, or offering for use of licensed digital data, in whole or in part, is prohibited without the approval of the Licensor. b. Reproduction of Products. The reproduction of hardcopy products, as provided by the Licensor, with the intent to sell for a profit is prohibited without the written consent of the Licensor. 2. ROYALTIES AND PAYMENTS 2.1 Payment Upon Delivery - Payment of License fees, as shown on the Licensor's Request for Data form, must be made upon delivery of the product. 2.2 Payable to the Office of GIS - The license fee shall be paid by check in US currency, made payable to '_____' 3. ASSIGNMENT3.1 No Assignment - This Agreement may not be assigned by the Licensee without the expressed written consent of the Licensor, in advance; the permitted assignee thereof shall have all the rights and remedies of the original Licensee insofar as the same are assignable. Assignment shall be only as a whole and not as a part, nor as to any part interest therein. 4. INDEMNIFICATION 4.1 Indemnification - Licensee agrees to hold Jackson County and all its employees, and agents harmless from any claim, suit, or proceeding arising out of the use of the licensed data in accordance with this Agreement, including indemnification Jackson County for reasonable expenses incurred in defending such claims. 5. WARRANTIES AND LIABILITIES 5.1 Warranties and Liabilities Neither the Licensor nor the owner(s) of these data make any warranty,expressed or implied, as to the use or appropriateness of use of the licensed data, and there are no warranties of merchantability or fitness for a particular purpose or use. The information contained in the licensed data is from publicly available sources, but no representation is made as to the accuracy or completeness thereof. The Licensor shall not be subject to liability for human errors, defect or failure of machines, or any material used in the connection with the machines, including, but not limited to, tapes, disks, punch cards and energy. The Licensor shall not be liable for any lost profits or consequential damages, or claims against the Licensee by Third parties. The liability of the Licensor for damages, regardless of the form of the action, shall not exceed the License fee paid for the licensed data.
Contact Jackson County GIS Services.
20100421
Jackson County GIS
541-774-6028
541-774-6787
gis@jacksoncounty.org
8:00am - 5:00pm
To order data, please call or e-mail. Thanks
mailing and physical address
10 S. Oakdale Ave., Room 302
Medford
OR
97501
USA
FGDC Content Standards for Digital Geospatial Metadata
FGDC-STD-001-1998
local time
None
Unclassified
None
en
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0055)http://water.usgs.gov/GIS/metadata/usgswrd/ussoils.text -->
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY><PRE>Metadata:
</PRE></BODY></HTML>
20260116
16452200
FALSE
20220523
18234700
20260120
14170600
Soils
002
4180972.214895
4437050.000000
129625.622375
431824.327756
1
Projected
GCS_North_American_1983
Linear Unit: Foot (0.304800)
NAD_1983_StatePlane_Oregon_South_FIPS_3602_Feet_Intl
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.5'><WKT>PROJCS["NAD_1983_StatePlane_Oregon_South_FIPS_3602_Feet_Intl",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",4921259.842519685],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-120.5],PARAMETER["Standard_Parallel_1",42.33333333333334],PARAMETER["Standard_Parallel_2",44.0],PARAMETER["Latitude_Of_Origin",41.66666666666666],UNIT["Foot",0.3048],AUTHORITY["EPSG",2270]]</WKT><XOrigin>-115243200</XOrigin><YOrigin>-97276400</YOrigin><XYScale>3048</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808398950131203</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2270</WKID><LatestWKID>2270</LatestWKID></ProjectedCoordinateSystem>
1.0
150000000
5000
FGDC
Version 6.2 (Build 9200) ; Esri ArcGIS 10.5.1.7333
Soils (NRCS)
4180972.214951
4437050
431824.327758
129625.622285
1
-123.259807
-122.281551
42.83723
41.989302
1
1
-123.259807
-122.281551
42.837230
41.989302
The USSOILS coverage was originally compiled to support a national model of water quality. The model uses the soil characteristics contained in this coverage to mediate deliveries of nonpoint source pollution to stream and river segments in the RF1 data base. The National Resource Conservation Service (NRCS) recommends that any maps using NRCS STATSGO data show the source and date, and provide the following statement: "STATSGO is designed to support regional, multistate, State, and river basin resource planning, management and monitoring."
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>USSOILS is an Arc 7.0 coverage containing hydrology-relevant information for 10,498 map units covering the entire conterminous United States. The coverage was compiled from individual State coverages contained in the October 1994 State Soil Geographic (STATSGO) Data Base produced on CD-ROM. The geo-dataset USSOILS.PAT relates (on the basis of a map unit identifier) the 10,498 map units to 78,518 polygons. The scale of the geo-dataset is 1:250,000. The INFO attribute table USSOILS.MUID_ATTS contains selected variables from the STATSGO data set for 10,501 map units (an extra 3 map units are contained in the attribute table that are not in the geo-dataset - see the 'Procedures' section below), including: the map unit identifier, a 2-character state abbreviation, available water capacity of the soil, percent clay in the soil, the actual k-factor used in the water erosion component of the universal soil loss equation, the organic material in soil, soil permeability, cumulative thickness of all soil layers, hydrologic characteristics of the soil, quality of drainage, surface slope, liquid limit of the soil, share of a map unit having hydric soils, and the annual frequency of flooding. To facilitate mapping the attribute data, the narrative section below contains instructions for transferring the information contained in the attribute table USSOILS.MUID_ATTS to the polygon attribute table USSOILS.PAT. Keywords STATSGO United States Soil Water Capacity Clay Organic material Permeability Infiltration Drainage Hydric Flood frequency Slope 17,234 records in attribute table on 6-26-09.</SPAN></P></DIV></DIV></DIV>
Soils
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>See the Jackson County Geographic Information Systems Data License of Limitations with respect to the sample data contained herein.</SPAN></P></DIV></DIV></DIV>
ISO 19115 Geographic Information - Metadata
DIS_ESRI1.0
dataset
002
withheld
63.688
Feature Class
Feature Class
NAD_1983_StatePlane_Oregon_South_FIPS_3602_Feet_Intl
EPSG
5.3(9.0.0)
17234
20260120
/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsK
CwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUFBQU
FBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBT/wAARCACFAMgDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9Jby1
NrMqW0jw/axJFjeSEcqWDgE4GNrcDH3vaqd/dCKx0aa2/wBF+0bLaPbgtGJFHTOQcBc4I6gdgQdP
W0mbTpHtoxLcQlZY0JxuKkEqD7gEfjWTJBGt34etI3E0CxbS6cDChHQ46DJiOPbdivx2Gtm/60PR
Y3T5Tcaf/adxzJKyi6i5KiMgAcdgBiT2y3rV+6t7jTp4Htbp/KkcRtDcEyrk5wQT8/OMcHA4bHDZ
zNK/0y2TYSn2y6S62A55UrJI2fQHbH6ZA/vYrS1y4lGoaVbQDErys4frtAUg8f7rMR7r0NVJe9b1
F0K2r3Qvo9JkjVo5PtaeYh4ZVWQK6k9wH2DjgkAjPWt+WJJ42jkXcjdRWffaUvkRmFGd4cnaGG58
sGOCeN25QwJ7jngml0u/eeaS3lLF0UNmRQr5/iVgOCV+Ukrwd644IJyesfd6DHSW91FG0Y2XtuRg
xzHa+P8Ae6N7ZA9zVQancWTbJUxH/D9rby2HtvG5GJ7DIPHOetbdIQGBBGQeoNSpd0OxSF/PH89x
ZyRxHoYz5rD/AHlUcf8AAd3vipJILfUkjlDscA7JYZCp56jIPsOD6VGNHtosm2BsnP8AFbYUfiv3
T+INU5J7qwlfEJHmH5isTPGW/vqFyw4xlTgE9G6kuyfw7gNtdQSb7DdySo0kUBS6QEBoSwUksvVc
FMEEcZycAGrkK3GlwpAkDXduihYzGyh1A4AIYgH6g/h3NbznvZredZ47acK8cMi4lglyRkHodw29
Mjv1wcQWT3OmRzQSXMEQjw5+0LhI1PA2sMAqSCMcFc9+Abav/kI0v7Ythy3nxr3eS3kRR9SVAH40
vk6drA83Za3oX5d+Fkx3xnn1rLvdcuotLub22ls7jyyIxHGrOA7YC/PkbuWXgAZ6ZBq1M4UrNcbY
5to8u+t4yVK9cN1wvPIJx3yD0XJbVAQxaRYQGS1uLRIvMd/LmQbPMViTs3LyMA7cHqBxnnFafw5J
p8BW0CyW6BQkCrsKhTleRzgHoE249G5Bkh1C/wBQeJQkFxbtvE9u9vtcgZUYJlK43dSN3TGOciWx
1kW1zJZzBZNnK/Z5RMygcFSo+c4OOdvfB6ZOl5rZ3FoRaLbC/tkmjv8AzGjn3Onl4MbDqpBYlXwc
E55BJIJO6tTRvm02KXtMWnA9A7F8fhuxUVz4hsrOIyTGaJOm6S3kQZ9MsAB+Jo8PXMdzpqCJspGz
oq91QMdgP/AdvPcYPOaznzNNtDRp1Q1hQIbaUDMkdzEUI7bnCH/x12H41fqOeCO5heKVQ8bgqynu
Kyi7O4zMkuJNLWeBAu5pRJEz9NskgDk+u1mJxxwV55JqBicRXagQIz+Y4dsiCfG0g/7JBYE9jzjk
mpo4Wv8AThZXbodQhUglv4sZUSY/usOoH94rnINVEvJraR0ntpRIgKybwHSaPsSQc5A43EY/vYyM
bpfeIui3bTZEvGIMs0oS42/xB2wgHrtJUZ443HGTWtWJb3EVy/2KRJ/ssqBo2kDAowIO0SDg9ipV
ieDzwKum1vISDFemYngrcouMeo2BeR198Y4zkZyXcCOykjtn1OR5BHbi4yGdsIvyJux2Hzbs+5Pe
iormKCyfTo3dQsDvcySykAYCMGcnoDukB/E0U3G+qVwNeual0u6h1kCN4lRjvgkbO5f9bu7EEr5p
wOMjv8pz0tVdRheW33RLuniYSxjOCSP4c9twyuf9qphKzt3GzI8OxpaPZx4wJ7PzoVHIjG/c4Gef
+WkY99vPSpc/8TZNzbnF/sDN1x9mZgo9huPH1Pc1ALhdPuYp4f3tmkBlQH5SInILbQeuzapx1w2O
wBmvcwaykqZZcLdeWgLGQKrRyMAO4EkZx1OMAE1s9W33RJu1j6vp0vnm+troWjrGRI7YwB68gj0y
MZO1eVxzrI6yorowdGGVZTkEeoqtq0T3GlXkUa7pHhdVUdyVIArCDtIpnKaXqMXhoXEct3ZFI3iV
7hz5JMeQPmTorLl9xJ3fLyAMY6621C1vWZbe5hnZQCwikDEA9M4rD1KJNc1m0iSeWNPIEqSwOUbY
2/dz7lYuPY+9W9L8Otpkkai8kuLaF2kiWYZkTK7du7ONnU4wOcc8c71OWSu9yVc2aKKK5SzPvLCT
9/JAVbzPmkgkHyyEAAYOQVOFAzyBjOM1n6FZqt35jTmcFfOieVf3kit91mbuVBK88gH/AGgB0FYL
yrYaWiE7b3ToiwQ8GVUGDj1DKPfBIzyK3i204kliywsRtL6BkmuQRI7MCk77cNtIOeg4BAOB04OH
pfwWXk2drBLOI18tFRl6KMEAuw3Y6HGcd+aj0SGK5hjuH82aeMlS8rsRvAwzKpOFPJBAAx8wquul
m8tFki2iWK4uMBjtBBmY8HBwQyq2cH7uO5pu19QKtpa3KWN/5cE9q8EhmgG0bvvEmNcZBUqqjuMs
euKkaW3m0uGbzIJEn/emyIDEyZy/lEHIfcTzzyR061PJHeogE0zRXrFSrLN+5lII+UZHynGe3Of4
qseHZIJLWQRIFMLCAvgBiFUbQxHUqDt+oOOtW5acwiqmmyfaJbW58qWW5Mp+07QZPIAUFScDDZbt
wB+VWI5YY9XWSCBts8jQNKGwpcAsSF7/AHCCfXp1Jq1pebiP7ZJ/rplAK/8APID+D6g5yeuc9MAD
OWHz9P0q38x4nEskDyxnDBxFKrMD65BIJqL3umM36iubiO0haWUkIvopYnJwAAOSSeMCsj7EdPUR
yNNBb/xSWhOxh/tLyU75ZTzySRxh8Vxo0UqyDUI3ZTlfNvS4B9cMxFRyL1Hclub+xmxHe7rKVfmX
z28oj/dcHB467W6HB64qK3DXwZ7S4FzDCVe3uGYMC3IdNw+8u3A3HJBJ5JHGujrKiujB0YZVlOQR
6ioJtQtreZYXmUSsQAg5IycAkDoM4GTxkj1oT6JAc/rZnhtpHjhms4mDOqNMpBlRWkGUwwCfJztY
Ek8jHNb2o3xsIVcIG3Nt3O21E4JyzYOBxjODyR9afPYQXNxBPIhaSHOz5iBzg8jODyoPOcEAirFD
mmloFjHtIf7QuVnMnnxqQWl2FEcgnaqA9VBO7POTjBOMArYoqG7gZcV1LaajDZyXAvXkG5gFCvEu
D8zY42kqQOhz3PONSs6OeOO+vbt5Ejt1SOEyOwC7lLZ56dXA+oI7VejlSaNXjdXRhkMpyCPrVSBG
Y0doLyawu1hkhmImiinAIZm3blUHryC3/A6oazaDSLGSK1ZoITFI9tgk/Z51UuuwdlIDZXO3ChcY
Yg62vFRpF0HIVGXazt0jBON59AudxPtUeryr9ltbqM+aqTxsoX5ldXPln6/K5Ix3A+laRk7piL9v
AlrbxQxjEcahFBOeAMCpKpaLn+x7HJyfIjyc5/hFXaxe4znLy1azup3t32zW/ltbxsMod29EQ+g3
M/ToGHpW5Y3P22yt7jbs82NZNuc4yM4zWfrGnxXd9aPK0qIwaLdFIUIfKsjHBwcFDjOeWHHJqJfD
AKiOS9uPIUbRFHIyhl9HBYg8f3Qo68dMbNxlFXeojYiuIpy4jlSQo21wjA7T6H0NSVkS+F7FwhTz
oZI12xyLMzNGPRdxIH4dKiGkarGAI9Z2IOiG3Df+PMzH8yf6VHLF7P7/AOmPU3Kx9dsRd3WnMNgl
8x41Mib1AKEtxxnITb9GP4Fte38Tt9p8qQQsFljjjO8KRxIDu+Yevyjo2OmDJqd1E8dpNDcwl1cy
RDl/M+VlOAvLY3Z49McZyHFOMtBblG3gtRcNb6nBbtcOdqTOo3N2UbjySccHJPYkkZKidNIWRItU
eQb/AJjPbGUbycEKYwvzZySOT1PHNNv7l9R0y3uWhgeIeaksqsx24JXKsAflOMnIIIxkYyapan9o
03So7G9jItW2oj2uWMZXkKmFzjap+8BjHLnNbJc2jEaNze3V/byI1s5iCnzIo4XBde/zSKvXpgAn
3HUUJlGnwXT2W5YIirQ7JpTtQbdzFdxDc7x0+UgbgQTjpdPvYdQs454P9U2QARjGDgj8wenHpxTx
ZW4uHnEEXnuu1pdg3EccE9ccD8hWany6WHa5j6Xey2M7peEOt1IrxToQVOVVQMjg5xnIA5J+UDk2
ZrcRSyQM/krJJ51tLjhJD1X8Tk9eQ7DtVr+zbOGx+ztCn2VCX2yfMAc7s8+/PtWZONHkhdJ72SJG
B4uLuRcj1AdsMPfBBoupO6A1Ib7dKsM6fZ7g/dQtkP7qe/fjg+oFWq5lNTMccsEiXGr2g2hWEJMw
4BGcKBnPIPy8YILHpetpUubO8E5lfTDCCJJuGwQ29QRyQF24bnOT8xqZU7agmNnudNDSFNQKoSWk
gtHDFj3OFBYepII9+9NupYLGezRViFo5EgiUkSM2c7yuMtzt99xHUkCk02a9v1uIcOltnyxJcom8
Do2Ao2n0wR8uDnJ+UXNO0Gz02Vpo0eW4b7087l3P0J6fQYFU7R0YDbvXBZW0lzJZXIt0G4yHYuR/
ulg34Yz7Vp1nabBHdKt/IoklkJeJ252IeF25+7lcE47k1o1lK2yGgoqvfJLJZyrAcSlcAg4Pvg9j
joexxRTjBS62C5l21nPbwm1EnnXdrMbmOSXjzVdm64GAcM68dDg45xVvSnZ5blkjljtnKyKsybCr
nO8AHnHAP1ZuT2w/C2pXmqa5cTyPvtjBhOBkLvPllscBiNzcYyGHoMdbWlS8W4sSGSxrNG8bqHRw
VZT0IPUVzCNLZyQaYz+YwmRiCOW2yI25f94NubsCj445HRXtybWDcqeZIzBEQnG5icDJ5wO5ODgA
nBrFn017LVLfVJmVWkuVEsaDcF3J5S4JwfvFc+uenyilT8/6YM1ND/5Aun/9e8f/AKCKvVQ0oG2j
exY7vsoVEY8F49o2sfyIz3Knp0q/Wct2NFHW+NIvHH3o4mkU+jKNyn8CAaJtYgtrxoJleEKu7znA
CH8c5x74xnjOSM2riBLq3lhkGY5FKMAccEYNZF6wvdFC3SgzQmI3IIxtAI8wj2K7+R1GaqNnowZt
01XVy21g204ODnB9Kw0j1CdTcW19PJa5ZVjCxb2wcbwxXBHHAPUYO7tT/D5FtNdQSh0uncykOAN2
QMnAJHXJ69+OnA4WTdwuQ+JZxZ3ljKkkis7bZo4m2lowCd2eg2k5weCM54BwyQXtgouNHhS9gmO6
RpBumGCcjJZScdAGOQcgkVrXGkxXGowXvmSxTxDb+7bCuvow/E/nWdpluiX9uI90Q3XTFY2IVtsu
xQR0IAbj02jsK0UlyoXUg0uJdTuXF1O23eZo7QxeVsfBDHqTkbgeGyCckA4qXSIf7T0m+s3cHyJm
tkcqGCsqgEgem7cdvTBx04qSdiNd84DMKSpEYlzvMpTG8ADkBZAD04XP8IB07bT4rW5uJ0LbpsZU
n5VwSePqWYn3JolKy+4EjmbSCWwj+zrcy2LooBlBEhQDA+fcMMAMZOMgchgvC3ba4d2MdtczTEDJ
FldRTj6nzfmX6AkfrV7WbaRpIZ4ombZkyPEcPgcjAwckZJH5dGaobuWPU9LQyBHkS4ijZk93UblP
UblYEYOcN1qubms7biKOr3MsUdvHJPqSvLMseJI4dqtyRnC/PwCdqEkkAHGalt7S1kuoYIpptUAJ
adLyXzAoOBkqx4YY6BeMnIBINNg0driygu2lubpnXe0EkzN5bFSCFBODjLAq+cjv619LZZZ52jV0
eAhdsK/NDjJJVT1GZH+XGQpTgGq05fd6AdJNptvOVJVoyqhQYZGjO0dBlSOPas9vDrzKsUt67WsS
hYIFXaBgcF+fnwQD26fXMcuvvFGVM9ozjAyocy59PI+9ntjd/hWh9jux8w1BzJ3Vok8v3wAA30+b
0znvj70N2PRlLTrKeBJYra4EUsBED+bvljb5VYEKWGzhugOPrgY07G5N3apIy7H5V1HO1gSGHvgg
1XTSBGzyJd3KzyHc8ocfNwB90jZ0AHC9qzk8zTnuY7m+u4UWRpFeG2Bj2t8xOdjY+YtnJ7dhih+/
s9Q2NPRvksEgP3rcmAg9cKcAkdsrhvxFXqx9IuWmvJMfvA6t5rqPl3q21Wz0y64OOwA9at6jKzp9
lhZhPMNu5M5jU9Wz24zj3xUSj7w1sNSa7vl862khhgP3PNiLlx/e4YYB7deMHvgFSS3kNntt4grz
AAJbx9QOgJA+6vv0op69P0ApaBYizlvQcb0ZYiFHGMb+PYeYVHsorYrn4r+7traNLa1ErvNIMuwC
yOWZiqnOQo+Y7iOijCtnjZu72CxjV7iVYkY7QW+hJ/IAknsASeBRNNyuCINTPly2MxH7qKfdI3ZQ
UdQT7ZYfTOegJqXUbZr3T7q3RtjSxNGGPYkEZp9zd29tD5lxNFFC2BukYBTnoMmqujqAlyY8/ZWl
zbjooTao+Uf3dwYjtzkcEUle1+wEP2hv9G1OP5UuFhilhYZIy2FwexBc5659q1qx5LeT7NqdivMj
+ZLbZ4J3DOc+okJ+gK/U6lvOl1bxTRnMcih1JGOCMiiXcESVmfKuo3MV1AXjuyI43YBkdAmdhH18
w8jHPXtWnVHU/wB2bSc/6uGcM/sCrJn8C4J9gaUd7Ay6qhFCqAqgYAAwAKpalpUeoFHwizx/cd13
AfkQQRk4IIIPQ8kG9RSTad0BgNe6haWVpBMUS7kDBmHP/LRUXBOcffU5IPToTUul6bdWupPPOA+9
Gy7Sh8EleEARQM4JbjkhOvOC/tru51m2P2fdaIeZA4GBlXz1yTuReMdB15rarWUrLTqKxmXMVpaa
il00siTsD+5jG8yZABO0AnjavT0Ga0IpFmjSRGDo4DKw6EHoayrTTrhTPGFW0R5neSVAPMmBdmGC
D8vykDJ55OMYBqyupWtsohjSYpF+7HlW8jKMcYBCkcYx+FTJX0Woy/XOXFu2nahCp4tDNu8sAnzF
ALIFx/ErZ+UclVGM7a2YNStriQRrLtmPIikBR8eu1sHHvijUdOi1KFY5cjY29SADg4I6EEHgkcg9
fXFEXyuzDcr6FcRy6aCrhmRmEzer5JY+2Sc47Z7Vzdzfy6ZrNzqdvbNN58u37MWCPKuxFDxg8OWK
pyOQEAxzkXE0uGK1u7hHcXayCEwiQ7HKyERhl4HzDaMfdAPAArqJEWVGR1DowIZWGQR6GteZQbe9
yd0ZSCXUrn7XbXVq8aAKgK+bsOPm+6wAbnrk8Y6c5gt9R+z6gzXt7KXy0KWyxHbnOdxAXIzt+UEk
kZwTkgakul2c2zfbRFkUIjBAGQDptI5GO2OlV57NLRBPJc3DwwHzFiJDc9gGI3EnOPvc5x0OKhST
0GUdTvtQF5ZJHMlrFI6u0YjDSlA6AqSTgZUsTgZAU4PcNUXurXModIriz3MUcyMIcbvl+TYDJxgn
5ipOcEdpWt7i8vZhJDaSyKsbssyl1X722MHsR8x3YJ+ccYxV43t5A4+0WOYj/HbS+YV+qkKf++Qx
9qq9lZJXAg0W2TT7vUbYfeMiT9BkqyKoPHvGwx2AHbFO8h7jUrpYpTBD8vnAD53bAwVP8IxwTzk5
xtIJMWo3kN9HusB9svovmgeJdyBv7pk+6AQMEZzg+4qKa3vNQupFLRRSwzAebEzRuse7IGQSHyvY
4APOOhpavV6AapEGl2kjLGEjQFiEHLH+pP5k0VRbRZRfiVLmTy9gG6WVpCrZOSqk7QSCOccYIA5N
FSuTrqGpbsdKt9PIaMM0m0JvkYsQB2HZRx0XA9qawE2tpx/x725znvvYYx/37P5ir1UdJzLFPct9
6eZ2BHQqDtQj2KqD+Jx1qLt3bGSwadaW0pkhtYYpD1dIwD+YqzRRUtt7jMjxFG8dqbyJxE0MUiyS
85SNl5Ix6MqNxzhTjmr2nyxy2ieVF5CJmMRAABNpKkDHGARVgkKCScAdSawPCTosVzBES0SsDGWB
BCAtEowf9mIHPfd+J1+KHoLqdBVHXP8AkC6h/wBe8n/oJq9VHXP+QLqH/XvJ/wCgmoj8SAvUUUVA
wooooAKpyWbwSPNattdjueJidj/T+6fcevINXKKadhFGGF7u5W5uImi8o/uYnIJU4wWOCRk5I9h9
TV6iihu4HJeJYZbQSahNHOwjbEskJXYbctgggsCCFLHuM884G3eluriytrUSRrPMwCyOG2rux0HH
UnpnA7ZBIzdkRZUZHUOjAhlYZBHoa5rXdMjsb3S7mMtIGuooRBORJGgLZ3KGBKsMDBBHQegxvFqp
aLFsaUHiS0utThs4mLmWMusg6Aj+EjqDgE8jHHuMxXl/EzxzSyAwmRFtYd4Xz33AB+eSAWGPpu5+
WuYtEjvbHT5hZPI4KwMbLbCqbiI/30hO5t3X5BlQ3PUE7Hh24TUrK2kuNThkmniTelpJgkgcKXBy
MckAbf4uvNaypxhqugr3LYEmkRYW6d7ph5s8Yge5G88kgLhlyeACcYGAOK1NNvlv7VZMr5g+WVBk
FHxypB5B56H1qO8VdL0m7e2URtHE8gPUlgpOTnqeOSetV7eGXSbq5SGzluLeYrKHjZNwfGGB3MP7
qnPqxrB2kr9R7GtVG6s51kluLOYRzOuDHIm6NiM4JAIOegznoB6CrNrcpdwLLGflOQQeoIOCD7gg
g/SpazTcWMzIdVmTAvLR7eRwPLRD5hc8/LwMBuM4yRjnPBwVp0U7rsBXv7oWNlPcEbvLQsFzjcQO
B+J4osLX7DY21tv8zyY1j3kY3YAGcVCR/aNwpB/0WBzn/ppIpx+SkH8QPTm9Q9FYAoooqBlHWudM
nA5ZgFVezsSAqn2Y4B9ieR1qnewzabqLX0aNPG5JdVGSoKqpAx67FIPYg5IByLesXMKWr27mJ5px
5ccMh++WOBkdcAnJx0GamluYtPhhE8xwSIw7jJY46nA9iSelbRbSWgiKx1qy1HaIJ1ZmzhW+UnHX
APX6jirN1breWs0DkhJUKMV64IxxVa/0qO8DOn7m5PSVeCSOmfXHb07VS0/W7q9URCzC3C5DGaQI
jEHDAEBskEEEY9wSCCVy396AepXtHiTU7WOaSL+1ftMvnYOGZNjlQMnO3BQge3qDjo6y5tOvLiT7
R9qW1uVXCCBcqfQSZ++B7BSMnGM8XrK5F5ZwXAXaJY1kCntkZxRN31QkTUUUVkUFU7DUVv5blUQg
QyGPdngkEgj2PGcehU98CSe+htriCGRirzZ2nHHGBye3LAfUgVl6Jm2vJo1IMdzLcznI5VllCcH0
II/EHnnjRR91tiublFVrvU7OwYC5u4LckZAlkC5H4ms3UfFFvbqi2YN/LIdq+R8y578jqRg8D9KS
hKWyC5t1yvjDffX+m6dE3zv5khAGdhK+Wr477S5bHfaT2JD4J7hkmk1aG4kkU5aJJ40hjQ8AFfMG
QcH74747U+DWLK1beul3US5BWaRUEY4IG12faBhjjBx8xx1reEXCV1qJu5Z1b7LZWUFi0qxQs2Zf
mHmbBli4753AZIGRkkYIyJtStmh3tFAZo5uGiQkYkzlHyOnPUj2PY1n3V08268jhH2OfbG6yhbgS
tuCrgIxAA553df4STUmh+XdzQy26xRLEoZz5skkzqVO0NvUNt7gnP3eKLNK4ii9ld3lwuyJLAmMS
XDyyb38s9pCfvZKE47KpU43caX/CQy3OpRQ2VsLi3LbGlLqA3I3MCCcbRk4Iy3bgE1DqNrb6vqjC
aG01FIMbYI5U85cEZyCOzdtwHsTSW9zNpb/Z4dJ82RRtt0DDekROcOwBVVyGA+Y52j3xTtJarX+v
MDZm02OWVnEksW//AFixSFQ+BgE45B4HIwTjByOKZ/ZSpzDc3ULd284ycemH3D8cZqoNddbf97Gi
Tsg8tt2UkbO1iO+0HBz/AHTmq/h25USSyvC8K3DMscrkDzNhIJcdnJ3t/ugDjGKy5ZpNsehZNxcm
+Fu12Q4OxXjgURl9u7YwLFidvPG0Y75xRTdJBuL5blhtle3E7j3lxge20RAe+e1FTJ2dho0rC1+w
2Ntbbt/kxrHuPfAAz+lWKz7vVHj1BbC3g865aEz5kfZGqggcnBOSTxgHoc44zSsUh0S9khbaJXto
fuLhp5AXDEf3m6Z/DNHK2rsDdorP0bVxq9rLceS1vGshRd5B3AAfNkcdyOCRweapz6vPeu8dgwWZ
cbFZN+7PRnGRsTGSMkM2OOmGXI72C5DOJ41bVondpopZY5Iy5CPGshUAjoMAde2WPPQv12dL6PTV
jOVedWcEY+TIidT6H94AR9fStCSWHQNMklmkd40Yu74BJLNk8D3auYu4Lm2u9RW1WMxaW8dygcnJ
BQ5QjoVACnHrGO+GXeHvO/b+v1Jeh21UL3SluSzxMIZGILZUlWIGA2AQQwHG4EHgdgKie6OpRWC/
PbrcZaQByrLtHMe4cht3Ydlf0qHSb68XTbZ50S4CIqzGN2aVGwAQVwckHryD14zwcVFx1RVxpsBE
C1zpi3YHR1mM7r9PMwQPYE1U09YrmZYLeeUXIZpWk+1OBs3YDhM7WLKVY8bctkjkA79tqFreMVgu
IpmAyVRwSPqO1Yk1rbWmtJb3EMc9tP8APGssYYIcheMjjDMB9JVHRa0jJu6e4jo6KoDT57ZsWl35
cJ/5ZTJ5gX/dOQR9CSBxgCqcl5Pau0X9pRFU+Xzbm0Zvm9C6sqE57AA9utZKN9mMm1yL57aRYjcS
EmEQBtpYEhiQ2RtI8vcD7Y4yCIbNrtJJdumSwO5KRNK0ZSFAABna5PJBbAHcA9M0+2uYIZvNlkv7
qXBCtJaSAKD1ACoB/M8dafBeNq0hEd0bVQMqkYVnYdzuIKkZOCFzg9TngaapWt+Yi5FDDp0LsWCj
78k0hALHuzH/ACB0GBWZbWwubmeSCVpmlY5uwu1UQn7qH+I4wMjgYz14MjTaXa3C+dc/a7tWwEZz
NIG9RGM4PX7qjAz2q0NXiYkrBdMq/eb7M42+nBAJ/wCAg++Kn3lsgKcotvk+ywxwQREk3QgBwTgY
jyOWbjkAg4xyTVnQ7p7y0eYyvNE0hETybdxUYBzt4+8GxjtiucnuBdLbaddXMWnWNtjLSyeXNOgy
qjawBHGOncgggjB6GG4eWFLextZbaFVCrNLHsVAAOAhw2fTgDjr63ONo2BE15Zacpa6uoLUEY3TT
Iv0GSfwrJurrSopAwe0u4MfLEs0e6Ju7IWYYB74IwQCByTWkLKKzcXV1cS3TxDCPMqkoTx8oVR8x
zjgZPQU/ybq7+aSd7Ne0UIUtj/aYg8/7uMc8ng1KduoFFNQ0y+tEjtYHuNhISK1jKmNvZhgJ353A
HsTUFxbTLc2r30MVxalmVY54xPMBtJwuFG3hcnl87cDJOasjSLaTWGUq0wSFSwuGMvUtjaWyQeDn
nHTjuLUmiwkKI5JoIw6v5aPlPlIYAKchRkfw4quaMXoGoy50rTdegt3kiEqQk+WUZoymOCvBBHIG
VPdRkZHGbrEdtpUsbzxRmGV1iiOAH27MeQhPqVBx/FlgBnGdd4Fa4la0nSO5UjzEJLKcj+JQeCR3
6/UVAbu7eWe3e1gvFVVMqxvjAbPyYbhiAMnJXIYcClFtddAK9jqLWNrqNzfIIykm5wpyxYop246c
KUA6dDn1JVOytJJrn7WLIyWBw0MUbqJQ2eQ6k7cLgAYOQPlIwKKtqCeqv8xanDah8WZNK+y+IZtL
S4a7hEEcCTbPKU4flip3HkDgDp0rQ8P/ABUn8b3Vxpa6fHYsluly0pkMqupaMbNuF4/eDJzyARxn
IKK92eFoqi6nLqvXozJSd7Haw+Wss+lKrfZ7SNZJCzZacnk7j7nJb1z9c6GixGLSrUM2+R0Ekjn+
J2+ZjjtkknHQZ4oor56e33fkbIh8SWwu9HmhYlVdowSOuN61n+G7g32q6pO6gGaK2dlHTmPOKKKq
P8KX9dUD3IvDpLaNoJJyTcS5J/3Zq2LR8avqEQGF2xSH3YhlJ/JF/Kiiip8Uv66iRYurNbrY25op
YzlJUxuXIweoI5HqP1ArnfEdxNbQud4kuLUM6Ssv3gI3lAYDj70KE4xnHaiilR1lZjZm3XiLVW0d
NTivPKDzeSYBEhAOCcgkZxx0OfrUnhDUpdbi8/zJLaRrqWB2iKjc6jJcrt2nPupP+0elFFds4xVO
TS2ZCepqXNrcXevDTpNRumg+zCcjEYyd+CCAoBB44ORjPHIITXtFtLDSZZYoh5ceHkiYBlkbP3iD
kbjnBYg5BIOeMFFcik+aKXkX3MHSviY4hMT6bENgUjyZNigEZxjB6V3Wm3n9oWEFzs8vzUDbc5xn
3ooroxdKFOziiYtsz/FmtTaDpDXcCJI6sBtkBxjB9D7VD4fv77xFpi3Ulwlqpd1228Y3fKxHViwx
x6fj6lFYcqVDntrcrqakWlWkMiyi3jacc+c6hpCfXceat0UVytt7lGXcx3C60pt5kjM1uciSPeBs
b2IPPmevbvnitoyteXkF3cN5lwLOOTcBgAyZJCjsBs46nnknAoorZP3GyepYtrKK4mvY23qIbghG
jkZGAZVdhlSCRuYnFVknWdEtoleCGG9Nu4WVt0g2E53DByWIJOSTg5PNFFNa3A1rSxhsRIIgw8xt
7s7s5Y4AySST0AH4UUUVg3fco//Z