CR 2008-11 - Illinois State Water Survey
Contents
1. aan 17 Appendix B ISWS Sediment Core Database User s Manual 25 Appendix C ISWS Sediment Core Database Data Dictionary i 43 Appendix D ISWS Sediment Core Database Relationship Diagram ccccseeeeeeeeeeeeees 49 List of Figures Fisur Lt Mapindexorsediment core locations a da aaa 4 Figure 2 Location of eight sediment cores collected near Beardstown IL Map 1 5 Figure 3 Location of nine sediment cores collected from Rice Lake State Fish and Wildlife Area Figure 4 Location of 28 sediment cores collected near Lower Peoria Lake Map 3 7 Figure 5 Location of 15 sediment cores collected from Upper Peoria Lake between Peoria and Chulicotne IL Map Discs ire dents 8 Figure 6 Location of 24 sediment cores collected between Chillicothe and Lacon IL ND NS 9 Figure 7 Location of 18 sediment cores collected between Lacon and Hennepin IL MIDO a O NE 10 Figure S Sediment Core alter SPUN tea 13 List of Tables Table 1 Data Collection Efforts Included in the ISWS Sediment Core Database 11 Table 2 Total Number of Results by Categoriae 16 Table 3 Total Number of Results by Subcategory aaa akan 16 Vi Database Development to Support Sediment Characterization of the Middle Illinois River by James A Slowikowski Brad D Larson and Amy M Russell Center for Watershed Science Introduction Excessive sedi2. 3 3 Drive Tube Assembly 18 Illinois State Water Survey Center for Watershed Science VC SOP No 1 Origination Date 2 02 Version 1 4 9 1 2008 Page 2 of 6 STANDARD OPERATING PROCEDURE FOR THE COLLECTION OF SEDIMENT CORES USING THE ROSSFELDER P 3C VIBROCORE 4 0 Preparation of Sampling Equipment 4 1 4 2 Vibrocore The vibrocore 1s a self contained watertight unit that requires very little preparation before sampling All electrical wires and connections should be checked for wear or damage Hardware used in the rigging and clamps should also be inspected During the first coring operation and then periodically throughout the day each leg of the three phase power supply should be checked to ensure equal voltage and amperage draw across all three legs to ensure that the vibrocore is operating properly Drive Tube Assembly The drive tube assembly consists of three parts the drive or core tube the core tube liner which 1s extruded High Density Polyethylene HDPE and the core or cutter nose Integral to the core nose 1s a core catcher made from 0 010 foot stainless steel This piece extends into the core tube and is cut into a series of radial biased fins If the collected sediment core 1s drawn out of the core tube during extraction these fingers will fold inward and inhibit loss of sample material Preparation for the drive tube assembly varies according to whether the intended use of the collected sediment core
3. attain maximum percent recovery and maintain stratigraphic integrity of the sample Once the boat has been successfully anchored with the proper scope to all anchors the DGPS should be initialized The sampler 1s then hoisted and all shackles and cabling should be visually checked to ensure the proper attitude of the sample Water depth is then determined using a graduated range pole equipped with a 6 inch foot to help define the water sediment interface If water depths are too great to use a range pole a calibrated sounding line or fathometer is used depending on water depth and velocities Water depth is then entered onto the coring log sheet The vibrocore is then lowered using the hoist and is allowed to penetrate the sediment under its own weight until the drive tube has sufficiently penetrated the sediments to minimize disturbance to 21 Illinois State Water Survey Center for Watershed Science VC SOP No 1 Origination Date 2 02 Version 1 4 9 1 2008 Page 5 of 6 STANDARD OPERATING PROCEDURE FOR THE COLLECTION OF SEDIMENT CORES USING THE ROSSFELDER P 3C VIBROCORE the surficial sediments during start up or the point of refusal is reached If the water 1s sufficiently shallow the deck crew can manually orient the vibrocore to ensure the correct vertical orientation The corer is then switched on and 1s allowed to penetrate the sediments until 1t becomes apparent that penetration has ceased or the corer has penetrated the length
4. selected Toggling back and forth between the two alters the Categories Sub Categories and Analytes options available as well as the actual results The Location list box is not affected by the Numeric Nonnumeric selection Not selecting an option in any of the list boxes means that no filter of that type is applied and by default all of the numeric results in the database are listed at the bottom of the screen Selecting any combination of the four list boxes Location Categories Sub Categories and Analytes will filter the results accordingly Numeric results also can be filtered by the use of the gt and lt boxes Either one or both of the boxes can be filled in to filter the results A subset of available fields is displayed in the results list on the screen To view all fields the data will need to be exported most likely to Excel using the Export button see the section titled Exporting Data for more information Geographic location can be filtered by selecting one of the predefined locations listed on the form Each core in the database has been assigned a location value Where a core was collected can be viewed on a map by clicking the Core ID hyperlink from the listing at the bottom of the screen Alternatively the section of this User s Manual titled GIS Integration describes in detail how to view the core locations using GIS software Selecting a specific a
5. References Demissie M and N G Bhowmik 1986 Peoria Lake Sediment Investigation Illinois State Water Survey Contract Report 371 Champaign IL Illinois State Water Plan Task Force 1987 Illinois River Basin Action Plan Special Report No 11 Illinois Division of Water Resources Illinois Department of Transportation Springfield IL State of Illinois 1997 Integrated Management Plan for the Illinois River Watershed Technical Report of the Illinois River Strategy Team Lt Governor Bob Kustra Chairman Springfield IL 16 Appendix A Standard Operating Procedures for the Collection of Sediment Cores Using the Rossfelder P 3c Vibrocore 17 1 0 2 0 3 0 Illinois State Water Survey Center for Watershed Science VC SOP No 1 Origination Date 2 02 Version 1 4 9 1 2008 Page 1 of 6 STANDARD OPERATING PROCEDURE FOR THE COLLECTION OF SEDIMENT CORES USING THE ROSSFELDER P 3C VIBROCORE Scope and Application 1 1 These procedures are used in the collection of sediment cores to ensure that all samples are representative of in situ conditions for that location and to maintain the stratigraphic integrity of collected samples Method Summary 2 1 The vibrocoring system employed by the Illinois State Water Survey ISWS 1s a model P 3c manufactured by Rossfelder Corporation of Poway California The vibrocoring unit is submersible weighs approximately 150 pounds and is powered by a three phase 240 volt 60 Hz g
6. appropriate storage of subsamples It is important that the plan of study for chemical analysis be clearly defined as constituents have specific requirements for holding times temperature and material in which the sample 1s stored Requirements for the storage and manipulation of sediment samples can be found in such reference materials as United States Environmental Protection Agency document EPA 823 B 01 002 and the 2000 ASTM Standards on Environmental Sampling Vol 11 05 23 Appendix B ISWS Sediment Core Database User s Manual 25 ISWS Sediment Core Database User s Manual September 1 2008 Illinois State WATER Survey 1895 ILLINOIS DEPARTMENT OF NATURAL RESOURCES 26 gt ILLINOIS Installation To install the database simply copy the installation folder containing all of the database components from the source DVD to the user s hard drive The installation folder should contain the following files Score images mi readme doc TA users manual pdf ih vibracore mdb These files must remain in the same folder for the database to function properly After copying the installation folder to a local hard drive the user must refer to the file named readme doc for detailed instructions on properly configuring the security settings of the database This file also addresses some common problems encountered during installation and describes the software required to operate the da
7. in this document in the GIS Integration section Documents Menu The documents menu gives access to a selection of documentation items Illinois State ISWS Sediment Core Database version 9 1 05 _ Documents Abbreviations Documents Analytes Documents Data Dictionary _ Documents Table Relationships m Documents Users Manual pdi Survey 11925 __ Retum to Main Menu 33 Documents Abbreviations This database generated report lists all of the abbreviations used in the database results The abbreviations are summarized by testing lab the field in the results table containing the abbreviation and the specific analyte being described if applicable For users interested in those analytes with descriptive results it may be useful to first print out this report for use as a reference Documents Analytes This database generated report lists all of the analytes in the database grouped by category and subcategory allowing a user to quickly locate the analytical results available for categories or subcategories of interest The testing lab is noted in parentheses Also each analyte is identified as being either numeric or descriptive nonnumeric Analytes Organized by Category and Subcategory A A nm N Numeric Result D DesriptveReuit Category Inorganic Subcategory Agronomic Calcium Saturation Brookside N Hydrogen Saturation Brookside N Magnesium Saturation Brookside N pH
8. previous sampling should be removed using a stiff brush manufactured with inert materials The core catcher should also be inspected and any residue remaining from previous sampling should be removed with a stiff brush and the catcher rinsed in native water The core nose should then be washed in a similar manner as previously described for the liners The core nose and catcher are first washed with Ecolab Microtox laboratory soap and subsequently rinsed with native water The cutter nose and core catcher should then be rinsed with 10 percent nitric acid and then thoroughly rinsed with native water 5 0 Deployment 5 1 Pontoon Boat Vibrocoring operations are conducted from an 18 foot 6 inch pontoon boat Coring operations occur through an opening in the deck or moon pool located approximately midship To facilitate the deployment of the vibrocore an electric 20 6 0 Illinois State Water Survey Center for Watershed Science VC SOP No 1 Origination Date 2 02 Version 1 4 9 1 2008 Page 4 of 6 STANDARD OPERATING PROCEDURE FOR THE COLLECTION OF SEDIMENT CORES DZ sje USING THE ROSSFELDER P 3C VIBROCORE winch and 16 foot deck mounted tetrapod tower are used The tetrapod as well as all cabling and electrical hookups is assembled prior to launching Generally sampling occurs at predetermined locations Station 1s maintained through the use of a three point anchoring system Position 1s determined using a Differen
9. 1s to supply subsamples for geotechnical information or for chemical analysis 4 2 1 Core Tube The core tube or drive tube requires little or no preparation before sampling since it never contacts the sample The core tube only supplies the structural integrity necessary for coring operations The pre drilled holes for attaching the core nose should be periodically inspected for wear or damage to ensure a proper fit with little or no play to avoid the rivets being cut by the core tube during operation 4 2 2 HDPE Liner 4 2 2 1 Subsampling for Geotechnical Data When sampling 1s being conducted for geotechnical samples the only preparation for the liner is to check its overall dimension to ensure a proper fit in the core tube If any fugitive tube materials are observed where the tube was cut during production these can be removed easily with a pocketknife or razor knife 4 2 2 2 Subsampling for Chemical Analysis When a sample 1s to be collected for chemical analysis a more thorough preparation of the liner is required The liner should be checked to be sure that the length allows for proper assembly of the core tube to the 19 Illinois State Water Survey Center for Watershed Science VC SOP No 1 Origination Date 2 02 Version 1 4 9 1 2008 Page 3 of 6 STANDARD OPERATING PROCEDURE FOR THE COLLECTION OF SEDIMENT CORES USING THE ROSSFELDER P 3C VIBROCORE vibrocore head Any frayed liner material left from the factory cut shou
10. A rr nja val act ts ae ah i x r 4 a ie 1 Wasil LAP Pl Fe et hi Apr CRI LI e ME a alta U u Ta Al hie CON lak smi ae o E att LT A 1 bee eden IE Er ii ra h 1 E a i a ER EEE A ARTE A a TR i PRE GE i A x i E Ai ih ai EP dp i I RR ia bik L art M E mu a E a Le et a ik bi A es Le fim A EL h AT F f j m Apt ae dla pa E P a m 7 Pe aaa eS HE rat i p i a ILE MET Ud sj E LAA i A ni A Ap 1 ini A a AA i imperi tai CE e A js aa NACRE L i 4 lt AA aK M AN ee a j AE E E H i j 1 i Y A ILLINOIS p TT ey es ir eS ee a im p i 1 NEEE OX oo e EA EA E a Ea i ia ali i A gt i a de i z i Dai PE i ME Es RX a 4 Pr A E IAE AT RE e LOTS PT TEE rene SRE Fu J E la ILLINOIS Mif i SAA IAN TESTS AS a Biel aa a LL di ar ee Y LH ie ee b i ont ae ee KV Illinois State ROSE ES me og E TR Y i A pal J Lj Fa Mo miao de a eos t LITRI ajo E CELTES a P DIATRIE LL FETTE A ML LIE Does te KE Au l s L HOT d ni Di ae AN E L im ar mia 1 3 n NAT a La i i ts mE LE ki A i i J j y A af i ia d E 3 Bi Mi i ma a Fy E vit i L 7 E L j ii gd Es 4H f 1 i 3 ci a i om cia ie be BR CE bof Ss ona zazu ki Do minirali Figure 4 Location of 28 sediment cores collected near Lower Peoria Lak
11. Brookside M pH TESTAMERICA CHICAGO N Potassium Saturation Brookside N Sodium Saturation Brookside N Total Exchangeable Cations Brookside N Subcategory Extractable Metal Aluminum Extractable Brookside N Arsenic DTPA Brookside N Arsenic TELP TESTAMERICA CHICAGO M Barium TCLP TESTAMERICA CHICAGO N Beryllium TCLP TESTAMERICA CHICAGO N Boron Extractable Brookside N Cadmium DTPA Brookside N Cadmium TELF TESTAMERICA CHICAGO N Calcium Extractable Brookside N Chromium DTPA Brookside N Chromium TCLP TESTAMERICA CHICAGO N Copper TELP TESTAMERICA CHICAGO N Copper Extractable Brookside N Iron Extractable Brookside M Lead DTPA Brookside M Lead TCLP TESTAMERICA CHICAGO N Documents Data Dictionary This option opens a copy of the Data Dictionary which is stored as an internal database report This technical document lists all of the fields in the database and describes the type of information stored in each field This information would be particularly useful when reviewing data exported from the database as every data field is included in many of the export functions Documents Table Relationships This option opens a copy of the Table Relationships diagram which is stored as an internal database report This technical document diagrams what tables make up the database and how they are related to each other This information is provided as background informatio
12. Contract Report 2008 11 Database Development to Support Sediment Characterization of the Middle Illinois River James A Slowikowski Brad D Larson and Amy M Russell Center for Watershed Science Prepared for the Illinois Conservation Foundation m Illinois State Water Survey Institute of Natural Resource Sustainability University of Illinois at Urbana Champaign Champaign Illinois I Database Development to Support Sediment Characterization of the Middle Illinois River by James A Slowikowski Brad D Larson and Amy M Russell Center for Watershed Science Illinois State Water Survey Champaign IL Prepared for the Illinois Conservation Foundation September 2008 I ILLINOIS Any opinions findings and conclusions or recommendations expressed in this publication are those of the authors and do not necessarily reflect the views of the Illinois Conservation Foundation Abstract Over the past 20 years a significant effort has been made to further the goal of restoring or naturalizing the Illinois River Central to this effort has been the development of strategies designed to address the excessive sedimentation that continues to occur today in the Illinois River and associated backwater lakes When addressing accumulated sediments dredging has been the most common recommendation as a means of achieving depth diversity necessary to provide adequate habitats for desired a
13. F ct 185 4068134605 88 55825967 UTM 16 d 16 Lower Peon Lake 01 04 Dice 185 4069134605 Da 20020007 UTM 16 5 16 Lower Peona Lake OF ct O4 OF Oct 04 185 4068134605 Ba 5525867 UTM 16 6 16 Lower Penia Lake 0 Cic1 0d 0f 31 04 145 4069134605 49 55823961 UTM 16 T 16 Lower Penna Lake O7 Oct 04 ar c 185 4068134005 89 55825967 UTM 16 16 Lower Fenna Lake 0r ic1 04 Of Jeli 185 4069134605 B9 5582396 UTM 16 3 16 Lower Peona Lake 07 Qc1 04 OF Oct 04 185 4069134605 DO 55825967 UTM 16 10 16 Lower Peden Lake Orcii Of ct dd 185 4069134605 49 5582396 UTM 16 11 16 Lower Peona Lake Of Oct 04 OF Oct 04 185 4069134605 B9 55825967 UTM 16 In cases where all of the exported columns are not required the Data Dictionary Documents Data Dictionary should be consulted to determine which fields might appropriately be deleted from the exported dataset The exported dataset s rows are ordered by core ID and sample ID Exporting Data Crosstab This option formats the results into a matrix of samples and analyte results and can be found on the Results Export in Crosstab Format screen There is a row in the exported dataset for each sample and the columns of the exported dataset consist of six sample specific fields and five fields for each analyte included The six sample specific fields are as follows Core ID Date Location Upper Lower Sample type The following five fields are included for every analyte Flag Lab Qualifier Result v
14. John Bandy and was made possible through an agreement between the State of Illinois and Dynegy Midwest Generation Inc This project as well as earlier projects that were responsible for many of the vibrocore samples previously collected has truly been a collaborative effort involving researchers and staff from the Illinois State Water Survey ISWS Illinois State Geological Survey ISGS Illinois Sustainable Technology Center ISTC formerly WMRC and the Department of Natural Resources and Environmental Sciences at the University of Illinois at Urbana Champaign UIUC Dr John Marlin ISTC serves as project manager of an integrated sediment reuse project of which this project was a part In addition Dr Marlin was project manager for several of the earlier efforts for which the sediment cores were originally collected Dr Marlin assisted with the post processing of many of the sediment cores and provided assistance with quality control efforts Dr Robert Darmody UIUC Department of Natural Resources and Environmental Sciences generously made available those data pertaining to the physical and agronomic properties of collected sediment samples and graciously supported the reformatting effort involving these data Dr Darmody has long been a proponent of the beneficial reuse of sediments and an asset to the success achieved to date Vibrocoring efforts at the ISWS have benefited from his experience and advice Richard Cahill ISGS made available al
15. Table project_ID key Automatically generated number 100 Name of the project under which cores were collected end Date Time The date that collection of sediment cores began The date that collection of sediment cores ended client Text Agency funding the project for which sediment cores were collected 44 Cores Table Field name Type size Description _ Primary key Unique ID number generated by ISWS I ndecdegree Double 8 Latitude of the core location in decimal degrees NAD83 Longitude of the core location in decimal degrees NAD83 coordinate_sys Text 50 Coordinate system originally used at the time of the sediment core collection depthwater Double 8 Depth of the water at the sampling location ft depthcored So A Depth to which the core tube penetrated the sediment ft corecapped Double 8 Length of the core ft time Date Time 8 Time of the sediment core collection Core ID number used by the funding agency log_comments Text 254 Comments noted in the field during sediment core collection Date Time Date of the sediment core collection crew Text 20 Initials of the individuals involved in the collection of cores analysis Text 10 Indicates whether core is planned to be sampled for chemical or geotechnical analyses There are different project_ID Long Integer Foreign key linking to the Projects Table Project ID number water body Text 100 General n
16. ains longitude X data the ndecdegree field contains latitude Y data These latitude and longitude values are in the North America Datum 1983 NAD83 Display XY Data table containing and coordinate data can be added to the map as a layer Choose a table from the map or browse for another table Specity the fields for the and coordinates wdecdegree ndecdegree This should allow the coordinates to be plotted on the screen as an events layer This dynamic display of XY data saved only in the ArcMap document itself can be permanently saved as a shapefile a common GIS data format by right clicking the cores Events layer and selecting Data then Export Data 41 Layers ha l Copy x Remove Open Attribute Table Joins and Relates lt amp Zoom To Layer f Visible Scale Range d Paj Use Symbol Levels a Selection Label Features 2 Convert Features to Graphics Convert Symbology to Representation Save As Layer File Export Bata Properties View Metadata Display Source Selection With either format events layer or shapefile core locations can be identified labeled or combined with additional GIS data layers e g rivers counties roads that have been obtained elsewhere Contact Information For questions regarding the collection of sediment cores or the data contained in this database please
17. alue or Result_nonnumeric for descriptive results Units For example a user may make the following selections on the Results Export in Crosstab Format screen Cores 185 Labs ISWS Peoria Analytes none selected Data Type Numeric 38 In this case the database will report that the exported file contains 26 columns Those 26 columns would include core ID date location upper lower sample type Percent Moisture dry basis flag Percent Moisture dry basis lab Percent Moisture dry basis qualifier Percent Moisture dry basis result value Percent Moisture dry basis units Percent Moisture wet basis flag Percent Moisture wet basis lab Percent Moisture wet basis qualifier Percent Moisture wet basis result_value Percent Moisture wet basis units Unit Weight Dry flag Unit Weight Dry lab Unit Weight Dry qualifier Unit Weight Dry result_value Unit Weight Dry units Unit Weight Total flag Unit Weight Total lab Unit Weight Total qualifier Unit Weight Total result_value Unit Weight Total units The number of rows in the exported file will depend on how many subsamples of Core 185 were analyzed at the ISWS Peoria laboratory The database is limited to the export of 255 columns of data at a time The form requires a user to specify some combination of cores labs and analytes that result in an export file with 255 columns or less Multiple exports may be requ
18. ame of body of water where all cores that day were collected original_N Text 50 For coordinate systems other than decimal degrees the y coordinate of the core location as recorded in the field original W Text 50 For coordinate systems other than decimal degrees the x coordinate of the core location as recorded in the field 25 The gage closest to the location of core collection the preparation procedures for the core tube liner depending on the type of analyses planned gages used most often are operated by the USGS or the USACOE gage value Text 10 The water surface elevation as reported by the nearest gage notes Text 50 Any piece of significant information concerning the core added in the office during data entry Specific name of body of water where each core was collected according to USGS 7 5 min quadrangles A river name and an approximate river mile grouping 5 mile intervals for those cores collected in main channels 45 Samples Table Type sample _ID Text Integer lab sample ID Text Foreign key linking to the Cores Table Core ID number Classification of the sample type discrete segment composite or whole core composite Primary key Unique sample ID constructed from concatenating core _ID upper lower amp sample _ type Upper boundary of sample position in sediment core as measured below sediment surface cm Lower boundary of sample position in sediment core as measure
19. contact Jim Slowikowski 217 244 3820 slow uiuc edu For questions regarding the operation of the database please contact Brad Larson or Amy Russell 217 333 0785 217 333 3889 bradl uiuc edu russell uiuc edu 42 Appendix C ISWS Sediment Core Database Data Dictionary 43 The following relational database tables contain data and information describing the sediment cores e Projects Table e Cores Table e Samples Table e Results Table e Analyses Table The remaining tables contain information used to generate reports or present additional information in the database interface e Abbreviations Table e Photos Table e Version tracking Table e Crosstab_columns_nonnumeric Table e Crosstab columns numeric Table The data dictionary documents all of the fields found in the database tables The data dictionary itself contains four columns field name type size and description The field name is the actual name of the field as it is found in the database table Type defines what type of data can be stored in the field The meaning of the value found in the size column depends on the type of data stored in that field For text fields size indicates the maximum number of characters that the field can hold and for numeric and date fields size indicates how many bytes of storage are used The description column provides a brief overview of the information stored in the field Projects
20. ctual testing A whole core composite 1s a sample that 1s developed by thoroughly mixing material from evenly spaced intervals for the entire length of the core Composites generally were developed using 2 cm of material taken every 20 cm A segment composite is a sample developed using the same compositing strategy 2 cm of material every 20 cm but only from some defined segment of the sediment core Segment composites generally are used for one of two reasons The first is a quality assurance procedure in which the core may be divided arbitrarily into some fraction of the total core length and composites are developed for each fraction or segment At the same time a whole core composite 1s developed using material from the other side of the core Results then can be compared among segments and against the whole core composite The second scenario where segment composites are used 14 are those situations in which there 1s a well defined contact face and sediment characteristics are visibly different in different segments of the core Regardless of how the samples were developed every sample delivered to a laboratory for analyses 1s a unique record in this table Results Results contained in this database have been classified as either numeric or nonnumeric The results table contains this information as well as reporting units detection limits when applicable and the name of the lab providing results along with any qualifiers or flags that s
21. d below sediment surface cm Comments about how the core was subsampled or composited ISWS assigned ID number used when subsampling or compositing the core Lab supplied ID number used when analyzing the sample Results Table Field name sample_ID Text 15 Primary key component amp Foreign key linking to the Samples Table The ID number of the sample being tested analysis_name Text 255 Primary key component amp Foreign key component linking to the Analyses Table The name of the analyte being tested Text 255 Primary key component amp Foreign key component linking to the Analyses Table The name of the lab that conducted the test result_value Numerical test result units The units of the given test result qualifier Text Any lab supplied qualifying notes see abbreviations table for explanation flag Text Any lab supplied warning flags see abbreviations table for explanation 5 0 0 reporting_limit The level at which an analyte can be definitively detected analysis_date Date Time The date the analysis was completed result_nonnumeric 55 Nonnumerical test result 5 10 15 2 25 255 50 255 method_detection_limit The level at which there is 99 confidence that a given analyte is present sometimes the analyte can be detected but at an estimated value result_comments 2 1 1 2 2 5 Any lab supplied notes regarding the processing of the result Specifies whether the record contains a numer
22. e Map 3 En e i bi aa ss PE i s a ISWS Cores O Z y NATURAL RESOURCES Survey 1895 Illinois State Figure 5 Location of 15 sediment cores collected from Upper Peoria Lake between Peoria and Chillicothe IL Map 4 OSA Illinois State o WATER Survey 1895 ISWS Cores Figure 6 Location of 24 sediment cores collected between Chillicothe and Lacon IL Map 5 Miles Illinois State ISWS Cores ILLINOIS Survey 1895 Figure 7 Location of 18 sediment cores collected between Lacon and Hennepin IL Map 6 10 Table 1 Data Collection Efforts Included in the ISWS Sediment Core Database a Cores A samples ia results 952 Lower Peoria Lake O AAA mer Pena ake 3 23 2006 3 23 2006 Illinois River 331 4235 Babb s Slough Meadow Lake Sawyer Slough Wightman Lake 5 8 2006 5 9 2006 Illinois River 5650 Babb s Slough Goose Lake Marshall Co Meadow Lake Sawyer Slough Wightman Lake 5 17 2006 5 17 2006 Illinois River 285 4096 Billsbach Lake Meridian Lake Senachwine Lake 5 25 2006 5 25 2006 Illinois River 366 4409 Beebe Lake Backwater Big Lake Goose Lake Fulton Co Miserable Lake Rice Lake 10 25 2006 10 25 2006 Illinois River 9 259 3340 Illinois River Main Channel Lower Peoria Lake 3 29 2007 3 29 2007 Illinois River 279 3362 Chain Lake Grape Island side channel Meyer Pond Muscooten Bay Stewart Lake Wood S
23. elds is displayed in the results list on the screen To view all fields the data will need to be exported most likely to Excel using the Export button see the section titled Exporting Data for more information linos River 160 165 hnos River 160 165 nos Rarer 160 165 Tinos Raver 165 120 kisa Ever 165 170 nos ver 165 170 lings Ester 165170 nos Fever 165 170 21 Musa a A Results By Core Number Results Export in Crosstab Format The third option for retrieving results is the Crosstab Export This form allows results to be exported in a matrix format with samples in rows and analytes along with a few other results specific fields in columns Microsoft Access cannot generate a dataset that contains more than 255 columns As such the user must select a combination of query parameters Cores Labs Analytes and Data Type that will generate a dataset with less than 255 columns The number of columns for any given combination of query parameters is displayed for the user and updated with every change in selection Once an acceptable combination of query parameters has been selected the user can then click the Export button see the section titled Exporting Data for more information 30 illinois River 160 165 illinois Rives 160 165 linia River 160 105 illinois River 163 170 Ninos Aver 163 170 illinois River 165 170 1 4 Tetrmohlorobeniena 1 4 Trichlorobentere The actual results can be
24. ending on the intended uses or analyses The cores as collected are capped labeled and sealed There is limited chance to reorder the core stratigraphy when the core tube has been properly cut and capped so there 1s no requirement that the core remain upright In addition while being transported on the boat the core tubes are placed within storage tubes constructed of schedule 40 PVC equipped with end caps Since the tubes are completely enclosed there is no chance for distortion of the core due to flexing of the sample When core retrieval is at or near 100 percent core sample weights can approach 100 pounds Care should be taken when handling samples to avoid injury and to avoid flexing of the core sample to minimize any disturbance to the sample Since cores commonly approach 10 feet in length a vehicle capable of transporting this size material must be available 22 Illinois State Water Survey Center for Watershed Science VC SOP No 1 Origination Date 2 02 Version 1 4 9 1 2008 Page 6 of 6 STANDARD OPERATING PROCEDURE FOR THE COLLECTION OF SEDIMENT CORES USING THE ROSSFELDER P 3C VIBROCORE Core samples by the nature of the collection technique have limited exposure to atmospheric oxygen and possible oxidation of selected chemical constituents If temperature is an important consideration it may become necessary for samples to be immediately transported to a cold storage facility or subsampling may be required on site with
25. enerator The P 3c has a working depth of 4000 feet Sediment penetration is achieved through a method known as vibro percussive in which the unit delivers 16 24 Kilonewtons kN 1 kN 225 lbs of force and a vibration frequency of 3450 vibrations per minute to the core tube Coring is made possible by both the percussive force of the corer as well as the fact that the sediment particles surrounding the drive tube are liquefied by the vibrational forces along the tube The corer is lowered into the sediment until the point of refusal The unit is then engaged and coring proceeds until penetration ceases or the entire length of the drive tube is reached Penetration depths and recovery rates depend on many factors such as water content of the sediment particle size and shape compaction density and calcification Therefore the best results will always be obtained in unconsolidated water saturated heterogeneous sediments There are no core sites that are exactly the same thus predicting correct penetration depths cannot be done Typical lake sediments loams or sand and gravel generally allow for complete penetration Deposits of large cobble non hydrated clay lenses greater than foot in thickness or the occurrence of large woody debris may inhibit coring Currently the ISWS vibrocore is configured so that cores are approximately nine feet long when recovery is 100 percent Equipment 3 1 Pontoon Boat 3 2 Rossfelder P 3c Vibrocore
26. fe has been found superior to other methods of splitting the tube since there 1s no kerf eliminating the chance for materials to be introduced to the core sample Once the core is split the polymer line is pulled through the length of the core The jig is then rolled onto the hinged side and allowed to fall open resulting in one half of the core tube being cradled in either half of the jig with the core contents exposed Figure 8 At this time the core is measured photographed videoed and described Once these tasks are accomplished the selected core intervals are marked generally into 2 centimeter cm segments using a stainless steel sample knife and a tee square After all subsample intervals have been delineated the core is sliced across the short axis using stainless steel trowels that have been modified such that the blade shape is equivalent to the cross section of one half of a core liner Segments are then lifted from the liner and placed into appropriate sample containers 12 Figure 8 Sediment core after splitting A primary reason to include in the database the 11 data collection efforts listed in Table 1 was the standardization of methodologies used to develop subsamples and laboratories performing the analyses All cores for which information 1s included were processed in the same manner with the bulk of the laboratory chemical analyses performed at the same labs using consistent methodologies across all cores It should be no
27. hed The vibrocore 1s then extracted from the sediments with an electric winch Once the vibrocore has been brought back to the deck the High Density Polyethylene HDPE liner containing the sample 1s removed from the steel drive tube capped and placed within a Polyvinyl Chloride PVC transport tube to eliminate the chance of the liner being flexed and the sediments being disturbed Penetration depths and recovery rates depend on many factors such as water content of the sediment particle size and shape compaction density and calcification Regardless the best results will always be obtained in unconsolidated water saturated sediments that are poorly sorted detailed description of the procedures used for collecting long sediment cores using the vibrocore can be found in Standard Operating Procedures for the Collection of Sediment Cores Using the Rossfelder P 3c Vibrocore Appendix A In general cores were processed the day after they were collected During processing a core 1s placed in a jig made from schedule 80 PVC The PVC pipe has been split in half lengthwise and 1s hinged on one side Once laid in the jig the core 1s seated and the end caps are cut using a stainless steel razor knife across the short axis of the tube and even with the edges of the jig A polymer line 1s then inserted into the split core liner at the bottom end on the core The jig is then closed and the long axis of the core is split with the razor knife A razor kni
28. hould be noted by the user Analyses The analyses table describes the analyses to which the sample was subjected as well as the name of the laboratory or agency performing the analysis and the methods followed Additionally all analyses are divided into one of three categories inorganic organic and physical to allow for easier searching of the results The analyses are further broken down into one of 16 subcategories to allow users to further refine their search Database Navigation The ISWS Sediment Core Database 1s a Microsoft Access product It consists of customized forms that allow the user to search and retrieve results in three different ways browse maps of the core locations and view photos of the split cores The database was developed so that a user does not need a working knowledge of Access The interface allows users to retrieve results without having to write their own queries A detailed user s manual is provided in Appendix B Summary This project allowed for the collection and analysis of samples taken from 42 sediment cores as well as the compilation of results for another 61 sediment cores collected previously These cores were collected over a relatively large reach of the Illinois River extending from the Beardstown area in the south to Senachwine Lake below Hennepin IL All cores were analyzed for a broad range of chemical physical and agronomic properties The second deliverable associated with this project
29. ic or nonnumeric result 46 Analyses Table Field name Type Size Description analysis name Text 255 Primary key component Name of the chemical or property being analyzed 50 analyte_abbreviation Tet so i Analyte abbreviation used by the testing laboratory Primary key component The laboratory where the analysis was conducted 50 A subcategory classification for the given analyte Abbreviations Table Field name Type size Description oo lab Text 50 The lab which generated the abbreviation field Text 255 Name of field in the results table where the abbreviation is used analyte Text 255 When applicable the specific analyte utilizing the abbreviation Photos Table Fieldname Type Size Description Primary key The name of the image core_ID Integer 2 Foreign key linking to the Cores Table The ID number of the core Version_tracking Table Feld name Version Date used to identify the version of the database Change Change made to content or structure of the database Crosstab_columns_nonnumeric Table Type Size Description FidName Fields used to construct a nonnumeric crosstab query Crosstab_columns_numeric Table Field name Type sie Description FidName Fields used to construct a numeric crosstab query 47 Appendix D ISWS Sediment Core Database Relationship Diagram 49 yu Uorpajap poyga JUBLUNULUCU sai aep
30. ions One way to find core data for a specific location would be to select the Results option from the main menu then select Results By Location and or Analyte and filter the results using the Location list box shown below Every core in the database is assigned a location value A list of all of these locations is displayed on the Results By Location and or Analyte screen Selecting one of the location values on this screen limits the results displayed to only those cores from that area Beebe Lake Big Lake Billsbach Lake Another option to find core data by location would be to use the Images Core Location Maps option The screen displayed when using this option allows the user to select a core from a list In this list an assigned location based on common map features is provided as well as a reach value The reach values are an approximate river mile grouping for those cores obtained along the Illinois River date location reach Lower Peoria Lake Illinois River 160 165 4 Ower Peoria Lake nois River 160 165 FF 10 7 2004 Lower Peoria Lake Illinois River 160 165 10 7 2004 Lower Peoria Lake Illinois River 165 170 10 7 2004 Lower Peoria Lake Illinois River 165 170 10 7 2004 Lower Peoria Lake Illinois River 165 170 Once a core is selected from the list a map image will appear on the screen This map image displays the selected core in the center of the image as a red sta
31. ired to retrieve all of the data desired The exported dataset rows are ordered by core ID and sample ID 39 GIS Integration The latitude and longitude coordinates for each core are stored in the Cores table This data can be loaded into Geographic Information Systems GIS software to plot the core locations The instructions that follow use ArcMap 9 2 to demonstrate this process After starting ArcMap and opening a new map document add data by selecting the menu option of File and then Add Data In the dialog box that appears navigate to the location of the vibracore mdb file and double click the filename to show the contents Select cores from the tables listed as shown below and click Add Add Data ES abbreviations Switchboard Items tbl_documentation Giltbl_field _properties 2 Crosstab_Columns_nonnumeric EE version_Tracking 2 Crosstab_Columns_numeric Mame cores Add Show of type Datasets and Layers lyr x Cancel Once the cores table has loaded into ArcMap right click on it and select Display XY Data 40 ES Layers m Cu GIsdatalvibracoreltemplwibracore mdb Open Joins and Relates H Remove Data fa Geocode Addresses 7 Display Route Events wea Display Y Data Properties In the dialog box that appears identify which fields in the database represent X and Y values For the cores table the wdecdegree field cont
32. l inorganic chemistry and radiological data derived from his research on sediments resulting from those cores included in the database and generously supported the reformatting efforts necessary for inclusion into the database In addition Mr Cahill has been an active participant in the ISWS vibrocoring efforts including the collection of sediment cores in the field ISWS vibrocoring efforts have benefited from both his professional experience as well as his time on the river All individuals previously mentioned also graciously invested their time in developing the design of the user interface and the beta testing of the final product The U S Army Corps of Engineers USACE provided funding for the collection and analyses for 16 of the cores that have been included in the database Project manager for that effort was Marshall Plumley USACE Rock Island District Other organizations that provided funding for the collection and analyses of sediment cores contained in the database included the City of East Peoria Fon du Lac Park District Office of Lt Governor Pat Quinn and the ISTC Kip Stevenson and Mike Smith of the ISWS provided essential contributions to the vibrocoring efforts Without their willingness to invest the extra effort often associated with fieldwork much of the information contained in the database would not exist In addition to his field efforts Mike Smith along with Josh Stevens and Joy Miller also with the ISWS assisted in
33. ld be removed The liner is then washed with Ecolab Microtox or an equivalent and then rinsed with deionized water Next the tube 1s rinsed with a 10 percent solution of nitric acid and then thoroughly rinsed once again with deionized water After drying the tube 1s capped at both ends and the caps are taped in place Tubes will remain capped throughout transportation and shall be uncapped only prior to being loaded into the core tube for coring operations 4 2 3 Core Nose 4 2 3 1 Subsampling for Geotechnical Data The core nose 1s machined from a solid piece of 303 grade stainless steel There 1s very little preparation required for the core nose when sampling for geotechnical purposes The core nose should be inspected for wear or damage especially to the cutting edge Any dirt or sediments left on the core nose from previous sampling should be removed using a stiff brush with nylon or other inert material bristles The core catcher should also be inspected and any residue remaining from previous sampling should be removed with a stiff brush and the core catcher rinsed in native water 4 2 3 2 Subsampling for Chemical Analysis When samples are being collected for chemical analysis the preparation of the core nose requires additional cleaning beyond what 1s necessary when sampling for geotechnical analysis The core nose should be inspected for wear or damage especially to the cutting edge Any dirt or sediments left on the core nose from
34. lough 4 11 2007 4 11 2007 Illinois River 255 3399 Fisher Slough Goose Lake Marshall Co Goose Lake Woodford Co Mud Lake Pothole Lake Sawmill Lake Weis Lake 5 23 2007 5 23 2007 Illinois River 8 273 2963 Upper Peoria Lake 8 9 2007 8 9 2007 Illinois River 249 2862 Upper Peoria Lake Lower Peoria Lake Wesley Slough Note One of the cores was not subsampled and submitted for analyses Sediment Core Methods All sediment cores included in the database were collected using the Illinois State Water Survey s vibrocore The vibrocoring system employed by the ISWS is a model P 3c manufactured by Rossfelder Corporation of Poway California The vibrocoring unit 1s submersible weighs approximately 150 pounds and is powered by a three phase 240 volt 60 11 Hz generator The P 3c has a working depth of 4000 feet Sediment penetration is achieved through a method known as vibro percussive in which the unit delivers 16 24 Kilonewtons 1 kN 225 lbs of force and a vibration frequency of 3450 vibrations per minute to the core tube Coring 1s made possible by both the percussive force of the corer as well as the fact that the sediment particles surrounding the drive tube are liquefied by the vibrational forces along the tube The corer 1s lowered into the sediment until the point of refusal The unit 1s then engaged and coring proceeds until penetration ceases or the entire length of the drive tube is reac
35. mentation has long been recognized as causing significant impairments to the aesthetic ecological and economic functions of the Illinois River The Illinois River Action Plan ranked soil erosion and excessive sedimentation as the foremost ecological issues concerning the Illinois River Illinois State Water Plan Task Force 1987 Demissie and Bhowmik 1986 proposed several management options including the creation of artificial islands to manage sediments and sedimentation in the Illinois River The Integrated Management Plan for the Illinois River State of Illinois 1997 specifically called for the beneficial use of sediments through three different options and for the implementation of backwater lake and side channel sediment management measures Today researchers land managers and public interest groups are still grappling with how best to fund and implement the various strategies that have been proposed to date A significant impediment to the planning process has been the limited amount of information on the physical and chemical composition of sediments found in the Illinois River and 1ts associated backwaters Information on the chemical composition of these sediments 1s critical to both the planning and permitting associated with any restoration effort Physical properties determine the uses that are best suited for sediments from a particular area of interest For example plans for artificial islands elevated floodplains and tops
36. n and is generally not required to utilize the database 34 Documents User s Manual This option opens a copy of the User s Manual this document which is stored as a pdf file in the same directory as the vibracore mdb file Searching for Data Keep in mind when searching for results that there are two types of results numeric and nonnumeric or descriptive Since the two types of results are displayed somewhat differently only one type is displayed at a time The Numeric data type is usually selected by default as the majority of results are numeric If a specific analyte is being sought and the user is uncertain whether the results will be numeric or nonnumeric click on the Documents Analytes menu option to view a report that lists all of the analytes in the database grouped by category and subcategory and identifies whether results for a given analyte are numeric or descriptive nonnumeric If no specific analyte is being sought the user must toggle back and forth between the Numeric Nonnumeric options to view and export all possible results Searches for data will typically be driven by either the desire for data from a specific location or data concerning a specific analyte or category of analytes Guidance on effectively locating data using either strategy is provided in the following two sections Search by Location This database offers a couple of options to help find results from specific locat
37. nally the Results Export in Crosstab Format option can be used to extract results based on multiple analyte combinations see the section titled Exporting Data Exporting Data Only a limited subset of the results is actually displayed on any given Results screen For access to the complete set of data fields the results must be exported from the database into some other file format typically a format compatible with Excel or some other spreadsheet program Whenever an Export button is clicked the full version of records currently displayed on the screen will be exported to a format selected by the user The formats available for export can vary depending on the software loaded on the user s computer Exporting Data Full Listing This option is found on both the Results By Analyte and or Location screen and the Results By Core Number screen The fields 57 in total from five database tables will form the column headings of the exported dataset see Documents Table Relationships and Documents Data Dictionary for more information on the fields There will be a distinct row in the exported dataset for each result value that is exported 37 A a C D t vjecisproject o projectname chem start end corescore ID ndecde i 2 15 Lower Fee Lake I wiecdegree boordinate_syal GF Qct 04 Q7 Cct 08 185 4069134605 3055823007 UTM 16 3 16 Lower Peona Lake OF ct O4 O
38. nalyte with numeric result values will cause the results to be graphed as well It should be noted that results for a single analyte may be composed of values that have been recorded in more than one unit of measure All result values stored in this database have been stored exactly as they were received from the testing laboratory As such the user must exercise caution when interpreting the values displayed on any graph generated by the database A detailed listing of all of the units used in a particular graph can be determined by examining the data listing near the bottom of the screen Also some analytes use abbreviations to describe the results The Abbreviations button located immediately under the graph on the right hand side of the screen explains these abbreviations There is also a report available at Documents Abbreviations that lists all of the abbreviations used in the database Results By Core Number This second option on the Results Menu allows the user to select one or more cores from a list and view all of the corresponding results Results are either numeric or nonnumeric and they are listed separately One of the Numeric Nonnumeric radio button options will always be selected Once specific cores have been selected a single core multiple cores using the Ctrl key or a range of cores using the Shift key the Submit button must then be clicked to retrieve the results A subset of 29 available fi
39. of the drive tube If the vibrocore has not penetrated the entire length of the drive tube when progress ceases the cored depth 1s determined by sounding the top of the vibrohead adding 1 2 feet to the sounded depth to allow for the vibrocore itself and subtracting this value from the water depth The resultant cored depth 1s then entered onto the coring log sheet Core Retrieval When retrieving the core the hoist is re engaged and the core is hoisted to the deck The core should be hoisted high enough to allow the moonpool to be covered and the core tube 1s then lowered nose down onto the deck The core tube 1s then removed from the clamp on the vibrocore head and the head 1s lowered to the deck The four rivets that fasten the core nose to the core tube are removed with the core remaining upright The core tube 1s then hoisted off the liner again with the core remaining upright and the drive tube 1s lowered to the deck Any supernatant water remaining in the core tube 1s then siphoned off and the liner is removed at the top of the sediment and capped A sample identification number date orientation top and sampling time are written on the cap The core can now be laid down on the deck the core nose removed and the bottom end capped The position of the core can now be taken from the DGPS unit and entered onto the core log sheet Core Transport and Storage Requirements for transportation and storage of collected cores will vary dep
40. oil amendments all require that sediments possess certain physical properties such as appropriate grain size In addition information on physical properties such as moisture content and unit weight allow for effective and efficient plaming including the proper selection and sizing of available dredge technologies To date this information has been limited and the data collected have not been readily available to researchers and land managers This project along with several related efforts has sought to gather a sufficient number of sediment cores to adequately characterize sediments from those areas of the Illinois River where restoration activities are most likely to occur within the foreseeable future This project also provided funding for five additional days of vibrocoring and the subsequent analyses of the collected cores The second deliverable associated with this project was the development of a Microsoft Access database containing field information documentation and analytical results for all cores collected under these related efforts This database includes a user interface which provides easy access to information regardless of the user s familiarity with databases The database currently contains complete information for the 102 sediment cores that were collected and analyzed through these related efforts Acknowledgements Funding for this project was provided by the Illinois Conservation Foundation under the direction of Mr
41. processing collected sediment cores as well as with reformatting and developing data included in the database Study Area All sediment cores collected for this project as well as all cores currently contained in the Illinois State Water Survey ISWS sediment core database were collected from the middle Illinois River or associated backwater lakes This area can generally be described as that reach of the river between LaGrange Lock and Dam River Mile 80 2 and Hennepin IL River Mile 207 5 The greatest concentration of cores collected to date occurred in Peoria Lakes An index map showing the location of all cores included in this project can be found in Figure 1 and higher resolution maps for selected areas are shown in Figures 2 7 Table 1 lists the 11 data collection efforts that contributed to the database The first six projects listed in Table 1 were separate research efforts that shared many of the same objectives as this project The collection processing and analyses of the sediment cores for the last five listings in Table 1 10 25 06 8 9 07 were funded through this project BUREAU HEN HENRY MERCER GALESBURG Map WOODFORD WARREN PEORIA PEORIA a CANTON FULTON BEARDSTOWN 24 Miles Legend ISWS Cores Rivers Illinois State os WATER a Lakes ILLINOIS Municipalities Survey ies a BADEEA Counties Figure 1 Map index of sediment core location
42. quatic species and maintain connectivity between backwater lakes and the main stem of the Illinois River A significant impediment to the planning process has been the limited amount of information on the physical and chemical composition of sediments found in the Illinois River and 1ts associated backwaters In addition data collected to date have not been readily available to researchers and land managers This report describes the methodologies used in initial efforts to collect and analyze sediment cores to characterize the sediments of the middle Illinois River and describes a database and user interface developed to facilitate the dissemination of these data This database contains information on the chemical and physical properties of sediments collected from 102 deep sediment cores In addition to more than 37 000 analytical and descriptive results information describing the time location and physical attributes of each sediment core 1s available in the database along with more than 700 photographs of split sediment cores 111 Table of Contents IMITOGUENOM AAA A A l ACKNOWIEGECIMENIS sata AAA 2 SUVA liebe lali 3 sediment Core Metodo cea 11 Database Descriptor i ne tte S ip 13 Database Destinia 14 Database Noviglio alia 15 JE A LIFE nata a ti s o i gd S ad dij 15 oi je va e m e e e e rev 16 Appendix A Standard Operating Procedures for the Collection of Sediment Cores Using the Rossfelder P 3c Vibrocore
43. r Any other cores in the vicinity are displayed as smaller black stars arl Once a Core ID or group of Core ID s has been identified as being from an area of interest the Results By Core Number option can be used to find all of the results for the specific core s in question Also the Results Export in Crosstab Format option can be used to extract results based on core numbers see the section titled Exporting Data Search by Analyte When searching for results of a certain analyte type or category check the Documents Analytes menu option see the section in this manual titled Documents Analytes for additional information This report lists every analyte found in the database broken down by category and subcategory with the testing lab noted in parentheses lt also denotes whether the analyte yields a numeric result or a descriptive nonnumeric result Users can 36 also determine if they need to search using a category subcategory value or if they need to search using individual analytes Either way the Results By Location and or Analyte option can be used to obtain actual results This screen allows a user to limit the results to category subcategory values or to a single analyte Agronomic Descriptive Engineering Extractable Metal 1 1 Biphenyl 1 2 4 5 Tetrachlorobenzene 1 2 4 Trichlorobenzene 1 2 Dichlorobenzene 1 3 Dichlorobenzene 1 4 Dichlorobenzene Additio
44. s p E 1 Ca gt A is mb Eli Miles Illinois State O ISWS Cores ILLINOIS Survey 1895 Figure 2 Location of eight sediment cores collected near Beardstown IL Map 1 ee 5 Miles Illinois State ISWS Cores WATER i LLLINGIS Survey 1895 uo RESOURCE Figure 3 Location of nine sediment cores collected from Rice Lake State Fish and Wildlife Area Map 2 aT L SR a ia A i a si ui ni he de CE a ha NC rt Fl ta i 7 i A A i Cat L gt j 1 x Kk i aa si x amp ci pa j F 1 a ap a m E Te N F E 4 de d a 1 u gt x ha PR s 1 4 I a P a e 1 DE KOE a gia E A arke ja 1 i E ue Le 1 r PL Der Y E e rd ta A it ie gt i m Piss eevee y h i Para ata on pl b i L ri y L ka in 4 Kadi 7 i sf gt a villi ie di i LT Pet 5 dai LE T N Y eee Fa EE in sAN VE Fe a lau J i 1 E o ni fia PRI i gt ke a DR EE RE PE x ee i Fa 1 iar e M Le 4 Tonk rr es ore me Be Sy EE a ir uo rd A LM ii a sh p i Y LI oka El e pr E a A Y a La Tac A Le i li di pi Dit eta RS RARES sa LM e RA SE OR TE re RISI i BE Pi et Y 1 ka eo nl ta Tas en ve i T ai i a te pes i CA mi ru A es ie Ee Kath ane be EV es 3 GE NOJ ITI uo la pe yA S ta A 7 L i vl a L ISWS Cores ar Ces j Le 7 a TI X 1 Pre 4 i ri 2 a k i Ps 7 e y e Eu VC RA LA AS
45. sisAjeu UONEIO sajou anjenabeb abeb ysoueau M RulbLio N GUIDI Apo sagem ar pafod SPAGO MII 007 DE sunt aseqeeg 2109 Jugu pos 104 sdiysuonejsu 50
46. stomized interface detailed explanation of each field in these tables is provided in Appendix C The following paragraphs describe the general purpose of the five main tables Projects The projects table is used to store basic information regarding each data collection effort Information stored includes the name assigned to the project by the ISWS principal investigator and dates of data collection Cores The cores table stores information describing the time location and physical conditions of each sediment core collected Each core 1s a unique record in this table Samples This table contains information on how a sediment core was subsampled or composited and delivered to the various laboratories Samples and or subsamples extracted from a core are described by the depth in centimeters that defines the upper and lower boundaries of the segment submitted for analysis as measured from the sediment surface in situ water sediment interface Most samples are taken using the material from one half or side of a sediment core An important exception 1s samples for unit weight percent moisture analysis Samples taken for these analyses use the material from both sides of a split core so that total volume of the sample 1s defined Each sample in the samples table was categorized as either discrete whole core composite or segment composite A discrete sample 1s one in which all material for a given interval generally 2 cm 1s used in a
47. tabase To ensure full functionality the user must have Microsoft Access 2002 2003 or 2007 To open the database double click on the vibracore mdb file Navigation Upon opening the database the user will be presented with four menu options The first three options lead to other menus and the last option Exit Database will simply close the entire database The screen presented below is what the user will see upon opening the database examples in this document all use Access 2007 litinols State ISWS Sediment Core Database his 91 08 m Results Images Survey OSS ILLINOIS Documents FT Exit Database 27 Results Menu The Results Menu offers access to three different forms Each form allows the user to query the data and retrieve results in a different way Minos State ISWS Sediment Core Database vernon 911 08 Survey MT ILLINOIS Results By Location and or Analyte _ Results By Core Number _ Results Export in Crosstab Format Return to Main Menu Results By Location and or Analyte This first option allows the user to interactively filter the results via a combination of location and analyte choices y gt E a __ MAE Lower Perra Laie DONE Migi amp Les See EA Results in the database are either numeric or nonnumeric and are listed somewhat differently One of the Numeric Nonnumeric radio buttons on the form will always be
48. ted however that there are certain parameters for which information may have been determined from multiple sources Because methodologies timelines and core intervals may differ the corresponding results may vary It is strongly recommended that database users read all included documentation Differences in methods units reporting limits and other variables may impact how this information should be used or interpreted Database Description The ISWS Sediment Core Database 1s a relational database that stores information on core locations subsampling of cores analyses performed and results A user s manual for the 13 database interface is provided Appendix B as well as a data dictionary Appendix C and a relationship diagram Appendix D All information in the database describing the collection and processing of cores was contributed by ISWS staff The database contains analytical and descriptive results from the following six laboratories Activation Laboratories of Ontario Canada Brookside Laboratories ISGS Geochemistry Section ISWS Sediment Lab Peoria TestAmerica Laboratories Inc and UIUC Pedological Lab Participating laboratories provided results as well as information describing the analytical methods used Database Design The relational database structure consists of five tables that fully describe the sediment cores The database uses additional tables to generate reports and present more information in the cu
49. tially Corrected Global Positioning System DGPS Rossfelder P 3c Vibrocore The vibrocore is powered by a three phase 240 volt 60 Hz generator located on deck All connections between the generator and the vibrocore are screw type Impulse amp watertight connectors Deployment of the corer uses an electric hoist set up with a double line rated for a maximum hoist of 6000 pounds All shackles pulleys or other points of attachment are secured with clevis pins or seizing wire Drive Tube Assembly The core tube 1s a 10 foot section of 3 5 inch industrial pipe size IPS schedule 5 black iron pipe having an outside diameter of 4 0 inches a wall thickness of 0 083 inches and an inside diameter of 3 834 inches The core tube is equipped with a cutter nose fabricated from 303 stainless steel and includes a 303 stainless steel core catcher to help ensure retention of the sample The core tube and core nose incorporate a custom extruded HDPE liner with a wall thickness of 0 07 inches This facilitates the removal and transportation of collected cores and allows collected cores to be used for chemical analysis The core tube 1s attached to the vibrocore head using an offset block clamp incorporated into the vibrocore head The core nose 1s fixed to the drive tube using four rivets located at the quarter points of the drive tube Sampling 6 1 6 1 1 Vibrocoring Coring Cores should be collected with a vibrocore using the following procedures to
50. viewed only after they have been exported the formats available for export can vary depending on the software present on the user s computer Images Menu This menu allows access to the two types of images associated with the database core photos and location maps ISWS Sediment Core Database jverzion 2209 _ Return to Main Menu 31 Images Core Photos The Core Photos option allows the user to access individual photos taken of core segments Photo images are contained in a folder that was copied when the database was initially installed Simply selecting a core will display all of the relevant photos for that core on the screen Either clicking on the individual photo or selecting a photo from the list box will trigger a larger version of that photo to be displayed il Select a core bom the lst of cones ri order lo display de ae prali J Secta proto from the lat oFohotos or ik pf i iia palo io njeni larger rem of the proto Images Location Maps The Core Location Maps option allows users to view detailed maps that display the location of each core Simply selecting a core will display the relevant map on the screen with the selected core highlighted in the center of the map 32 dde 10 7 2004 3 rer 4 VESES gt D 3 a boj A IN Although the maps should give the user a basic understanding of where a given core was obtained instructions for more in depth GIS interaction are provided later
51. was the development of an Access database containing data for 103 deep sediment cores collected for 11 data collection efforts The ISWS Sediment Core Database contains information describing these cores including nearly 700 photos of split cores One hundred and two sediment cores were subsampled or composited into a total of 2 950 samples These samples were analyzed and generated more than 37 000 individual results with a total of more than 30 000 numeric values and nearly 7 000 descriptive results The categories and subcategories of these results are presented in Tables 2 and 3 respectively 15 Table 2 Total Number of Results by Category Number of Category results Inorganic 13 421 Organic 10 295 Physical 13 679 37 395 Table 3 Total Number of Results by Subcategory Number of Subcategory results Agronomic 2 418 Descriptive 6 368 Engineering 3 388 Extractable Metal 4 359 General Inorganic 101 Grain Size 3 907 Oxygen Demand 16 PAHS 1 824 PCB 707 Pesticides 2 206 Phenol 1 386 Semivolatile Organic 4 113 Total Metal 6 329 Total Nutrient Inorganic 114 Total Nutrient Organic 59 Total Radionuclide 100 37 395 In addition to results the database provides support documentation including location maps and methods information for all cores All information contained in the database 1s readily accessible through a custom designed user interface that provides a menu driven alternative to the user developing specific queries
Download Pdf Manuals
Related Search