API PUBL 4731-2003 pdf download.Light Non-Aqueous Phase Liquid (LNAPL) Parameters Database Version 2.0 Users Guide.
The LNAPL Parameters Database is a collection of information about samples that have had their capillary parameters determined, as well as other physical parameters measured. Capillary properties are critical in multiphase calculations, and those results have very high sensitivity to these properties. Capillary properties are sparsely documented in technical literature, and the documentation that exists is generally for other fields of study. Thus, they are not as applicable to environmental release conditions. There are significant property differences between the environmental samples in the subject database and those found in the historic literature. The purpose of this manual is not to discuss these differences, but rather document the construction and content of the API LNAPL parameters database. The data (samples) contained in this database come from a number of different sources and sites (refineries, fuel storage facilities, military bases, etc.); information now in the public domain. The data that have been included in this database were not collected for the purpose of populating a database of useful parameters. The samples were collected to answer site- specific questions and to aid in the mitigation and remediation of site-specific problems. Given this diverse sample background, it is not surprising that the range of tests performed on each sample and the testing procedures used during the tests differ in many cases. Nevertheless, this is currently the most complete set of laboratory measurements of samples whose properties have been analyzed for the purpose of understanding LNAPL remediation in near-surface aquifers. The database contains the following types of information: • Sample capillary parameters and the raw data from which they were derived. This information is available for nearly all samples in the database. • Petrophysical data including density (bulk/grain), porosity, permeability, conductivity, water and hydrocarbon saturations, etc. Typically, if the full raw grain size distribution is available, then all of the summary parameters are also available. For some samples, only summary data is available, while others have no data available. • Fluid properties (viscosity, density, interfacial tensions). Typically, fluid properties samples are not taken from the same samples where rock properties are measured. Fluid properties samples are provided as a form of site characterization, rather than for direct comparison with other samples within the site. In many cases, the process of measuring one set of sample properties (grain size) makes the sample useless for measuring other properties (e.g., porosity). In general, the collection of measurements attributed to a single sample is obtained from slices of a single core not separated by more than 6 vertical inches from the slice where the sample capillarity was determined. 1.2 Getting Started The first step is to open the database in Microsoft Access™. Locate the database file LNAPL_db_2000.mdb and then double click the left mouse button on the file. After opening the database, your screen should look like the screen in Figure 1.
Figure 2 shows the Query Forms screen. At the top of the form are 5 buttons that provide access to the basic parameter queries. At the bottom of the screen are 2 buttons that provide access to raw data for individual samples. For now, we will concentrate on the basic parameter queries and results; raw data queries/results will be discussed later. All of the basic parameter query screens look similar to each other, and provide output in the same formats. The only difference between the 5 queries is how the data are selected for display. We will use Query by Permeability Range for our examples, and discussion of the various types of query results and displays. Select any query options by clicking (left mouse) on the desired button.