View on GitHub

Oak Ridges Moraine Groundwater Program - Database Manual

ORMGP Database Manual

Section 3.4.7 Adding New Data - Methods

Entry of Data into Database - Manual Spreadsheet

In cases where no software is available to enable data entry or to assemble data into a format that can be easily managed by the ORMGP, the provided Microsoft Excel worksheets can be used as a base in order to structure data to facilitate importing into the database. There are six worksheets available:

An example Microsoft Excel worksheet, providing the required, recommended and/or optional fields necessary for incorporating different types/levels of data into the ORMGP database is available. The file also contains three reference sheets - GEOLOGY_MATERIAL, PARAMETER_NAME and UNIT_NAME - which provide lists of acceptable geologic materials, parameters and units, for use in the GEOLOGY, LAB_DATA and FIELD_DATA worksheets (see the MATERIAL_1, MATERIAL_2, MATERIAL_3, MATERIAL_4, PARAMETER and UNIT fields, below).

The spreadsheet is found here.

For these worksheets the location name (LOC_NAME) and/or interval name (INT_NAME) are being used as the key field by which data (e.g. LAB_DATA or FIELD_DATA) can be linked or related to a particular spatial location within the ORMGP study area. Refer to the following figure for the required relationships between the worksheets.

Figure 3.4.7.1 Spreadsheet relationships for manual data
entryFigure 3.4.7.1 Spreadsheet relations for manual data entry.

The primary worksheet, Worksheet A - LOCATION, should be populated for all data submitted; each of the subsequent worksheets (i.e. (B) through (F)) are populated (and related to worksheet (A)) if there is the appropriate data available. This is summarized on the attached figure. Two numeric fields - LOC_ID and INT_ID - are for existing locations in the ‘Master ORMGP Database’ (ORMDB) and should only be populated if provided by the ORMGP group (e.g. if the consultant provides the “Location worksheet” in advance of the others in order to obtain a LOC_ID and or INT_ID).. A new worksheet set should be used for each data set submittal by consultants or partners. The data fields found in each worksheet are described, in detail, within the next section.

Data Fields

The individual worksheets (LOCATION, BOREHOLE, GEOLOGY, SCREEN_AND_SOIL, LAB_DATA and FIELD_DATA) comprise a number of data fields - most of these should be populated, if possible, based upon data availability and location type. The description for each follows in alphabetical order.

ANALYSIS_DATE
BOTTOM
BOTTOM_DEPTH
COMMENT
COORD_COMMENT
COORD_QA_COMMENT
COORD_QA_METHOD
DATA_SOURCE
DATE
DIAMETER
DIAMETER_OUOM
DRILL_METHOD
DRILL_START_DATE
DRILL_STOP_DATE
GEOL_BOTTOM
GEOL_DESCRIPTION
GEOL_TOP
GROUND_ELEV
INT_ID
INT_NAME
INT_NAME_ALT1
INTERVAL_TYPE
LAB_ID
LAB_SAMPLE_ID
LOC_ADDRESS
LOC_AREA
LOC_COORD_X
LOC_COORD_Y
LOC_ID
LOC_NAME
LOC_NAME_ALT1
LOC_ORIGINAL_NAME
LOC_STATUS
LOC_STUDY
MAT_COLOUR
MATERIAL_1
MATERIAL_2
MATERIAL_3
MATERIAL_4
NAME
PARAMETER
SAMPLE_DATE
SAMPLE_NAME
SCREEN_MATERIAL
SCREEN_SLOT
SCREEN_STICKUP
SOIL_BLOW_COUNT
SOIL_MOISTURE
SOIL_RECOVERY
TOP
UNIT
VALUE
VALUE_MDL
VALUE_QUALIFIER
VALUE_UNCERTAINTY

Last Modified: 2022-04-04