The system encompasses 1296 soil profiles and 8235 horizons distributed in 58 of 67 counties in Florida. The data typically include profile characteristics (descriptions of the site, soil classification, etc.), a large number of laboratory parameters and a description of each horizon. Note: we are using the term ‘horizon’ here to refer to an individual layer in a specific profile and not to a generic horizon-type.

How to access the data:
I:   Select Search Criteria
Soil:   Select from soil names stored in the database to narrow down your search, or leave this field set to "Select" if you do not want to specify a soil name.

County:   Select from County names stored stored in the database to narrow down your search, or leave this field set to "Select" if you do not want to specify a County name.

Horizon:   Select from Horizon names stored in the database to narrow down your search, or leave this field set to "Select" if you do not want to specify a Horizon name.

Classification:   The Classifications drop down box contains soil descriptions that are part of soil data entries in the database. Chose from descriptions such as "acid" or "aeric" to narrow down your search, or leave this field set to "Select" if you do not want to specify a soil Classification.

Any Word:   Type a word in this text box to have it compared to all of the text data fields of the records in the database. For ease of use, this text box also finds partial matches. For example, "BAYVI" will find "BAYVI LOAMY SAND." If this field is left blank, it will simply not be used for searching the database at all.

Parameter: Min / Max   This drop down box has 105 entries, one for each numeric data field in the database. By selecting a parameter name and entering a max and min, you can narrow down your search. The "Show Limits" button will automatically fill in the Min and Max textboxes with the min and max values of that parameter in the database to let you know what range to search in. The search is based on parameter greater than or equal to Min, and less than or equal to Max. Therefore, if you want to find a single value for a single parameter, you can enter it as both Min and Max. WARNING: if the value in the database is 4.999 and you enter Min: 4.9, Max: 4.9, it will not be recoginized, so using a range is always recommended over entering the same number twice. You can also enter only a Min and leave the Max blank to get all records with a parameter value above or equal to the value you entered. You can also enter only a max to get all records with a parameter value below or equal to the value you entered. If both the Min and Max text boxes are left blank, this filed will simply not be used for searching the database at all. NOTE: If a record in the database is missing data for a particular data parameter, it will not be found at all when you search for that parameter, whether you specify that the parameter should be above or equal to a min value, below or equal to a max value, or even specify the entire range of the limits of the parameter.

Find:   Records matching ALL inputs (AND) / Records matching ANY inputs (OR).   Choosing "Records matching ALL inputs (AND)" will only return database records that match all of the search criteria entered in the fields above.  Choosing "Records matching ANY inputs (OR)" will return database records that match at least one of the criteria entered in the fields above.

The "Clear Selections" button just sets the user input fields back to their blank state for quick and convient form reset.

NOTE:   The world "ANY" is used three different ways on the search page.  (1) The first four data entry fields show "ANY" before the user makes a selection. This just means that if the user does not make a selection, that field can be "anything" when the database search is applied. In other words, it will not be used to narrow down the search at all.  (2) The fifth entry field is "ANY WORD." This means that the text which the user types in this datafield will be compared to all of the text fields in the database to see if "any" of them match.  (3) The second option of the Find drop down box is "Records matching ANY inputs (OR)." This controls how the search will br processed. "Records matching ANY inputs (OR)" means that if at least one of the criteria the user entered were matched, that record will be displayed. "Records matching ALL inputs (AND)" means that only if all of the criteria the user entered were matched, then that record will be displayed."



II:   Add Criteria to Search Query
"ADD Criteria"   This button will add the search criteria that the user entered in the search fields above to the large list box as an SQL string, and clear the search criteria fields above.

"Delete Selected Criteria"   This button allows the user to click on and then delete any criteria row from the large list box.

"Clear ALL Criteria"   This button clears ALL the criteria rows from the large list box.

Purpose:   Part II may seem like an unnecessary middle step, but it provides a way to build more complex search queries for the database. Using the ADD Criteria button, the user can enter soil names, county names, horizon names, classification key words, text words, and parameter limits over and over to build more complex searches. Without the Criteria list box, the user could only enter one criteria for each of these fields at most.



III:   Select Output Fields for Table Columns
Because there are 128 total data fields in this database, it would be impractical to make users choose which data fields should be displayed one at a time, they have been grouped into check boxes for the following meaningful catagories:

Latitude & Longitude
Albers projection X & Y coordinates

Pedon - HNAME, HDEPTH, HDESCRIP, BOOK_NUMBER, META_PAGE, TABLE_PAGE, ID, SOILNAME, CLASSIFICATION, CountyName, LOCATION, LANDFORM, SLOPE, DRAINAGE, VEGETATION, PARENT, DESCRIBED, DATE, COMMENT, GEOREFCOMMENT, GEOREFSOURCE, HYDRICSTATUS, HYDRICRATIONALE, MAXDEPTHSAND, MINDEPTHROCK, INDIRECTWATERTABLE, LAB_NUM, TOP_DEP, BOTT_DEP

Physical - SAND_VC, SAND_C,SAND_M, SAND_F, SAND_VF, TOT_SAND, TOT_SILT, TOT_CLAY, TEXT_C, SATHYD0, B_DEN_0, SATHYD1, B_DEN_1, SATHYD2, B_DEN_2, AVAIL_W

Engineering - MAXDRYDE, OPTMOIST, MAlt2pt0, MAltpt42, MAlt_pt074, MAltpt05, MAltpt02, MAltpt005,MAltpt002

Engineering - CACO3_EQ, PH_H2O, PH_CACL2, PH_KCL, ELECCOND, TOT_PHOS, ORG_C, KCL_AL, EXTR_CA, EXTR_MG, EXTR_NA, EXTR_K, TOT_BASE, EXTRACID, CEC_SUM, BASE_SAT, PYROCARB, PYROFE, PYROAL, C_D_FE, C_D_AL

Minerology - AASHO_C, SM_MIN, CH_MIN, VM_MIN, MI_MIN, HIV_MIN, KA_MIN, GI_MIN, QZ_MIN, CL_MIN, FL_MIN, SE_MIN, AM_MIN, DL_MIN

MoistureRelease - W_1by10, W_1by3, W_15BAR, W_3pt5_0, W_20_0, W_30_0, W_45_0, W_60_0, W_80_0, W_150_0, W_200_0, W_3pt5_1, W_20_1, W_30_1, W_45_1, W_60_1, W_80_1, W_100_1, W_150_1, W_200_1, W_345_1, W_15B_1A, W_15B_1B, W_3pt5_2, W_20_2, W_30_2, W_45_2, W_60_2, W_80_2, W_100_2, W_150_2, W_200_2, W_345_2, W_15B_2A, W_15B_2B

Please see protocols for a description of all of these parameters.

TABLE DISPLAY FORMAT:   (*) GRID View   ( ) Tab Separated   ( ) Comma Separated
There are three options for displaying the results table from your database search.

GRID View is selected by default and displays the results as a simple grid table.

Tab Separated displays the results in a text box with the columns separated by tabs. The purpose of this display mode is that the user can click inside the display text box, press Ctrl+A, Ctrl+C, open Excell, press Ctrl+V and have a copy of the search results in Excell. However, now that the webpage supports downloading the results as a .csv (comma separated value) file, which Excell can open, this display mode is less important.

Comma Separated displays the results in a text box with the columns separated by commas. The purpose of this display mode is that the user can click inside the display text box, press Ctrl+A, Ctrl+C, open Notepad, press Ctrl+V, Save As a .csv file and produce a data file Excell can easily read. However, now that the webpage supports downloading the results as a .csv (comma separated value) file, which Excell can open, this display mode is less important.

The "Search" button collects the SQL criteria rows in the large list box, and the output data fields from the check boxes to search the database and displays the resutls according to the TABLE DISPLAY FORMAT.  [NOTE: Because the selection criteria rows displayed in the large list box contain AND / OR from the FIND drop down box when they were added, and the Search button combines the criteria rows using the current AND / OR value from the FIND drop down box, it is possible to create more complex searches using both AND and OR conjunctions; however, this is not recommended because it is often confusing to the user.

NOTE:  Depending on the size of your monitor, you may need to scoll down see the results table after your search has been displayed.

The "Download Results " brings up a dialog box to Open or Save a .csv file of the last search results. If you select Open, the table should automatically open in Microsoft Excell, if it is installed. You can also save the .csv file to your computer. Many statistical programs also read .csv files.


"GIS Layers" on the side menu also gives you a ARC-IMS web-GIS application to view pre-defined characteristics (such as hydric soils)

If you find that you cannot retrieve specific data, please contact the webmaster .

Florida Soil Profile Data is distributed "AS IS."   This dataset is a product of the University of Florida, Soil and Water Science Department- Institute of Food and Agricultural Science (IFAS) with support from the Florida Department of Transportation. When using this data on maps or in digital applications, source credit should be stated as "Soil and Water Science Department , IFAS - Institute of Food and Agricultural Science, University of Florida"

The University of Florida, Soil and Water Science Department shall not be liable for any damages suffered as a result of using, modifying, contributing or distributing the materials.