Manual ExploStat (updated at 1 december 2001)

 

Introduction

 

ExploStat contains tools for exploring spatial variability, ordinary Point Kriging, Irregular Block Kriging  and other deterministic interpolation methods. Furthermore there is a method for iterative optimizing sample plans. Its most important power is visualization of spatial data. For exploration of spatial data it offers linking the variogram and the histogram with points on the map. Selection tools are available to guide the user through large data sets. Plotting  transects of interpolated  surfaces creates the opportunity to evaluate the effect of interpolation parameters. An important feature is presentation and processing of drill core information. As a result ExploStat offers tools for mapping sediment layers from drill core data. ExploStat handles points, lines, polygons and raster data. It offers editing of spatial data with the mouse. In fact, it is a GIS program. The vector data are stored as a set of line segments, an arc-node structure is not yet used. Several ASCII formats are supported for vector and raster data. Attribute data are read from ASCII-CSV tables and DBASE IV tables. Just as the most well known GIS-programs ExploStat create project files where information is stored about data sets and location of data sets on the computer. A example data set and it’s associated project file is available on the website of ExploStat. The topics in this manual will be described in an order that is defined by the menu items and speed buttons of ExploStat.

 

 

OPEN

 

 

Tables: A new window appears with a menu bar. Four DBASE tables can be opened. ExploStat creates a database from these tables. The tables are related to each other by common attributes. This database represents drill core information. Each table contains a set of mandatory attributes and a set user defined attributes. The mandatory attributes are needed for linking the tables and building a database that represents properties of drill, sediment layer and  sediment sample objects. Table 1 contains the attributes of the drill location. The mandatory attributes are: Drill code (string), x,y and z coordinate (floating point). Table 3 contains the descriptions of sediment layers. The mandatory attributes are: Drill code,  number of layer, top of layer, bottom of layer and sediment description (string). Table 4 contains the location of the samples in the drill core: Drill code, analysecode, top of sample, bottom of sample are the mandatory attributes. The analysecode links table 4 with table 5. Table 5 contains the properties measured from the sample. Here the attribute analysecode is only mandatory. Table 2 is not yet implemented, it should contain the drill method in case of more then one method at a drill location. All mandatory attributes are listed in the window where the tables are loaded. Click on the attribute names to select a attribute. Select in the same order as the list indicates left of the table window. After selecting the mandatory attributes you can select additional attributes that will be showed when you query a drill location on the map. When all attributes are selected click on the OK button at the top of the window. The you can open the next table. Begin always with table 1. You have to open at least table 1 and table 3 to make the database active. After loading table 3 a legend have to be defined. Click on the first name of the list with legend items. After then you can assign a color to the selected item by clicking on a radio button left of a color. When ready click on the button cont. legend. To get information about the sediment samples table 4 and table 5 have to be loaded. All the information about the legend and the selected attributes is stored in the project file.

 

Point layer: Three ASCII formats of tables with x,y locations of point locations and their attributes can be loaded. First the well known CSV format where values are separated bij comma’s or other list separators (the names of the attributes are in the first row), secondly the GEO-EAS format coming from the first user friendly Kriging program with the same name, created in the eighties in California, thirdly the most simple format: only three columns with x,y and z (without a header). At the moment only one point layer can be loaded.

 

Line layer: Five line layers can be loaded. There are two ASCII formats supported: first the MOSS format, a format that is available in most of the GIS programs on the market, secondly a coordinate format that is created by a ARCVIEW-extension which is available at the ExploStat website.

 

Mask layer: This is a special case of a line layer. The mask plays a key role in spatial selection. The area within a mask polygon can be made active and works as a point in polygon operation. Histogram and variogram are created from the point locations which are activated by this operation.

 

Grid layer: One ASCII format is supported: the ESRI ASCII grid file format. Up to 30 grids can be loaded.

 

SAVE

 

 

Point layer: The active point layer is saved. The last plotted line layer is active.

 

Line layer: The active line layer is saved. The last plotted line layer is active.

 

Grid layer:  The active grid layer is saved. The last plotted grid layer is active.

 

 

DISPLAY

 

Create Legend: This is not a pure display function but is controls the presentation of the legend. It serves to modify an existing legend by choosing other colors for the legend items.

 

Size Drill Plot: The size of the rectangles that represents the drill core descriptions and the properties of sediment samples can be changed. The manual choice enable the user to define separately vertical and horizontal dimensions of the drill core rectangles.

 

INTERPOLATION

Three simple interpolation methods are available. With the interpolation results, spatial variability can be visualized. The Kriging interpolation is activated by a speed button, this is described later in the chapter about the speed bar.

 

Voronoi spread: This method assign a value to a gridcel coming from the nearest point location. The resulting surface is characterized by sudden changes of value. Plotting this surface on the screen of the map gives a good insight to spatial variability.

 

Inverse Distance weighting: This is a classical interpolation method where weighting factor is assigned to point locations in the neighborhood  of a gridcel. The value of this weighting factor depends on the distance between point location and the gridcel where interpolation takes place. The resulting surface is smoother then the Voronoi surface, but still it gets an impression of spatial variability.

 

COLORS

 

Color-palettes: Four standard palettes are available. i) Deep blue, ii) From Red to Yellow, iii) From yellow to red and iv) From orange to green.

 

Contrast colors: The value range of the data in the grid is classified into 8 pieces. Each class is assigned a different color. Because the colors are quite different the separation between classes is enhanced visible on the map.

 

Extremes active: If active is set (default) the upper en lower cell values will be plotted, otherwise not.

 

Stepped/Continuous  256 colors are used over the total range of values (continuous). If stepped is selected, only eight colors are used, each class in the legend is assigned a constant color.

 

SPEED BUTTONS

 

A series of speed buttons is available for query, zooming and to activate panels with analysis tools.

 

*     Open project File, after a project has been opened the speed button opens a line layer or the latest opened type of file.

      Save project file

*     Activates all functions of ExploStat. These additional functions are not described in this manual.

 

    Activates a panel with checkboxes that controls the display and calculations of drill cores and sediment sample properties.

 

          The panel with drill core properties shows several options to control the display of drill cores and sample properties. The upper left box shows the classified concentrations, class 4 means a high degree of pollution. In the lower right box two drill cores are displayed with mainly sandy sediments. At the right drill core sediment samples have been analyzed, the results are plotted at the right side of the sediment description. The attribute panel contains chemicals that were selected from table 5. The checkbox delete means removing a drill from the set by flagging it. In table 1 a column is available that contains the values one or zero. Zero means the drill is out, but the information about the drill is still in table 1. There are several options to calculate with attributes of the drill cores and properties of the samples. The results of each calculation (selection of values) are assigned to the current point layer. To inspect the results you can display the labels of the point layer or a histogram. In addition it is possible to create a experimental variogram and do some Kriging or other interpolation.

Radio button panel  Calc_attributes:

1)               Analysis: Concentrations of the chemical constituent selected in the attribute radio button panel are assigned to the point layer.

2)               Sediment: Thickness, Bottom or Top of a sediment layer is calculated. Select one or more  types of sediment from the panel Layers with the checkboxes.

3)               Quality: This function works on classified concentrations. After clicking on the radio button you have to choose from 5 class values. The radio button in the panel Calc Layers determines whether  Thickness, Bottom or Top of sample is selected and assigned to the point layer. This function works only if the numbers 0,1,2,3,4 are available in the selected column of table 5.

4)               Anal. Sedi: Only the chemical concentrations of samples in the checked layers (panel Layers) are selected and assigned to the point layer.

 

      Query mode: Properties of objects as tables and grid cells are displayed.

 

*      Digitize inside mask: This is an important function, when a vector layer is available (mask layer) with closed polygons the area within one or more polygons can be activated by digitizing inside a polygon. This enables selection of points and areas where analysis functions must be carried out.

      Zoom in: First push the mouse button on the upper right corner or the lower left corner of the area you want to zoom in. Drag the mouse until the size of the area of your interest is reached and then release the button.

      Zoom to previous zoom

*     Zoom out 2 times from location of mouse cursor

     Geographical Window Parameters: ExploStat supports vector and raster structures; therefore a cell size is always defined. Also when no grid layer is present. When a point layer or a vector layer is loaded the default number of cell columns is 500. The corresponding cell size is calculated based on the minimum bounding rectangle of the point or vector layer.

         

          You can change the Cell Size, the number of columns and rows will be recalculated. Existing grid layers will be deleted. New values for the extend of the geographical window can derived from the current zoom. Again existing grid layers are deleted. Thus before changing window parameters existing grid layers have to be saved, otherwise they will be lost.

 

 

     The panel with properties of grid layers will be activated.

         

          Only the existing grid layers will be shown, thus when ExploStat is running with by example three layers the panel looks like:

         

          The filename of the grid layer is at the left. The first column contains the value of the grid cell where the cursor resides. The second column shows the minimum of the value range that is colored on the map. The third column contains the maximum of the range. The user can enter different values to alter the range. After entering new values for a range of a grid layer click on Set Range to set the current range values for the clicked grid layer. Clicking on the name of the layer results in drawing the grid layer on the screen. The last clicked layer will be the active grid layer. This is important because all analysis or calculations concerning grid layers will be applied on the active grid layer. By example clicking on All Ranges will set the range of all existing grid layers to the range of the active grid layer.

          Profiles: Transects of the grid layers that are checked will be drawn along the North-South and West east directions along the sides of the ExploStat window. The location of the transects in the grid layer is determined by clicking on a grid cell. If more grid layers are plotted as transects it is important to assign the same range for all transects, otherwise comparison between the transects is impossible. If Cross is checked then the lines are plotted on the map where the transects are located.

          Clicking on  will extend the fields with the filenames over the three columns. This is useful when the name does not fit in the box. Furthermore when grid layers are created with interpolation, some parameters will be shown in the same box. Then more space will be necessary to show all information.

     Calculation with grid layers: Some simple point operations on two grid layers are available. Add, subtract, divide and multiply is possible.

         

    Sample Plans: Sample plans on a grid can be generated. The user can select distances between sample points or fill in another distance.

          In this example grid layer one and grid layer two are added. The result will stored in the next not used grid layer.

*  Line layers: The panel with line layers becomes visible. Up to 13 line layers are possible. Here the same rules as for grid layers. Operations are applied on the active line layer such as digitizing, editing or selecting.

     Digitize Line Layers: The most important line layer mask can be digitized from screen, starting with an empty layer. All other line layers have to be imported before digitizing is possible A digitized line segment is finished by double clicking. If a polygon is digitized stop just before the starting point and choose for close segment. So a mask layer can be created or lines can be added when a mask layer is already loaded.

          The mask is a special line layer, therefore it is yellow highlighted. As already explained by digitizing in mask, the mask layer contains a set of polygons that define sub areas that can be activated. Checking the Fill box means that the activated areas are filled with a red color.

     Edit Line Layers: Line segments can be deleted.

     Select Line Segment: For generating slopes (taluds) in a DTM line segments have to be selected as sources and borders of a slope (talud).

*      Point Layer: There is one point layer. Points locations can have a set of attributes read from file. For calculations with attribute values there always only one attribute active. A point layer can also be created from drill core descriptions (below: drill core descriptions).

     Histogram: A histogram is made from point locations inside activated areas (digitize inside mask). If no mask layer is available or checked all, point locations will be active. All active point locations are red highlighted. When clicking on a bar of the histogram the point locations will be deselected that have attribute values within the class of the histogram bar.

         

          The point locations on the map that are deselected turn to yellow. The open circles are in the not activated area. The statistical parameters above the histogram are calculated from the point locations in selection. You can also click on a point location on the map to deselect or select that specific location. To change the number of bars (classes) fill a number in the edit box and click on N Class.

     Variogram: The so called experimental variogram is calculated from the point locations that are in selection.

         

          In the example here the blue experimental variogram is calculated from all point locations within the activated area. After deselecting the five points near the left border of the diagram, a new experimental variogram is calculated and resulted in the red line. The number of lags and the width of the lag intervals can be changed. Clicking on New Scale does rescale for the last plotted variogram and only this one is replotted. Moving the cursor over the variogram area shows the number of point pairs for the lag where the cursor is. To fit the variogram click on Fit Vario, a new window appears: see below.

         

          The red experimental variogram is fitted. Default there is a spherical type. The nugget, sill and range can be fixed. The fit method assign weights to each lag based on the number of point pairs. Then the least squares criterium is calculated. The weights can be disabled but this is not recommended. The values for nugget, sill and range are used for the Kriging if the user wants. The user can also enter these values manual.  

 

 

          Lines between point pairs:

 

          To explore spatial variability you can click on the area below the experimental variogram. Moving the cursor along the vertical axis for a certain lag show the number of point pairs that exceed the level of semi variance that is shown in the edit box semiv>. These point pairs are shown by connecting the points with lines. In the example below for the first lag and the third lag values haven been clicked. The colored surface is a result from Voronoi Interpolation. The light blue areas are relative high values so there the spatial variability is higher then at other locations.

         

*     Kriging and optimizing sampling plans

 

     There are two types of Kriging possible: Ordinary Point Kriging (OPK) and Irregular Block Kriging (IBK). Furthermore on the same panel (see below) the sample plan optimizing can be enabled, because the optimization is based on minimizing of the IBK variance.  

         

          In this panel the default values for the variogram are displayed.  A model can be selected. Clicking on Set Values From Fitted Variogram will activate the parameters from the last fitted variogram. If the checkbox In Active Layer is checked  the results of the OPK will be stored in the active layer otherwise two new grid layers are created to store OPK values and OPK variance.  Clicking on the radio button Ir. Block will display the panel below.

         

 

 

          In this case the values of the last fitted variogram are enabled. Three progress bars are present to monitor the (sometimes it takes minutes) calculations. The size of the discretization is determined by the current grid cell size. If there are many cells in a block region the calculation of the within block variance is the most time consuming. Therefore the user is warned when there are more then 5000 discretizations, continue will cause long time for calculation. A solution is to increase the cell size with .

          Optimizing a sampling plan is started by clicking on the button Optimize Sampling Plan. The panel left appears to enter the parameters of the process of optimizing. Optimum value set the target IBK value. Start distance sets the distance between sampling points when the optimizing starts. Step size controls the amount of distance to decrease during optimizing. After the target IBK value is passed the step size is increased with a