Navigation:  Working with Your Data > Importing Data >

Wells

Print this Topic Previous page Return to chapter overview Next page

Visual MODFLOW Flex supports the following file types for well data.

 

Excel,*.XLS

 

To import wells, follow the steps below:

 

Right-click in the Data Explorer and select Import Data... from the pop-up menu.

Select Wells from the Data Type drop down list.

Click the [...] button and locate the source file.

Enter a Name and a Description for the imported data, and click [Next] to continue.

The next step allows you to preview the source data before importing, and choose a subset of the source data, e.g., a worksheet of an excel file. Select which Excel worksheet to import from the Select Worksheet drop-down list. Also, you can choose which row to import from using the From Row text field.

Visual MODFLOW Flex provides you with various options for importing wells, and associated well data. For example, you can choose to import well heads (Well ID, X, Y, Elevation, Bottom), or you can choose to import wells heads along with related screen locations, pumping schedules, or observation points

 

 

 

In the Select the type of wells to import frame, choose between Vertical and Deviated (Horizontal).

 

Next, specify how the vertical data is expressed in the source file. If the data is expressed with respect to a vertical reference datum, e.g., above mean sea level, then select Elevation. If the vertical data is expressed as a depth, e.g., distance from ground to the bottom of the well, then select Measured Depth.

 

Time Options: Time-varying data can be imported in Absolute (eg. calendar date 5/10/2015) or in Relative times (1 day, 30 days, 365 days, etc) where the value is relative to the start time defined in the Modeling Objectives).

 

Select the Well Heads Only option to import just the well heads, i.e., X-Y coordinates, elevation, and well depth for each well. Select the Well Heads with the Following Data option to import additional data for each well. Options include:

 

Screen ID Location: Import the screen locations for each well. Select the Pumping Schedule check box to also import related pumping schedules for each screen. This data could be used later to define pumping well boundary conditions.

 

Observation Points: Import observation points for each well. Select either Observed heads, Observed Concentrations, or both.

 

Well tops: Import the elevation (or measured depth) of points along the well path, where geologic formation (contact points) intersect with the well. This data could be used later to generate surface and horizon layers.

 

Note: For data requirements for each option please see the next step “Data Mapping”

 

Once you have selected which well data to import, click the [Next] button to proceed to the data mapping .

 

This step requires you to map the columns in the source data to the required target fields. The required fields will vary depending on the type of well data you selected in the previous step. The following sections describe the data mapping for each data type option:

 

Well Heads Only

 

For importing Well Heads only, you must map the following columns from the source data to the required target fields:

 

Well ID, X, Y, Elevation, Bottom

Well ID must be a unique value in the source data. If not, any rows containing duplicate Well IDs will not be imported.

 

 

 

Wells Heads with Screens

 

 

 

 

If this option is selected, you must first map the well heads under the Well Heads tab. Next, click on the Screens tab, and map the appropriate columns from the source data to the following target fields:

 

Screen ID

Screen Bottom Z (elevation of bottom of screen)

Screen Top Z (elevation of top of screen)

 

For each well in the source data, the Screen ID must be unique. Also, screens should not overlap within a single well. These requirements will be validated in the final step of the well import process.

 

If you selected the pumping schedule check box in the previous step, click the Pumping Schedule tab and then map the appropriate columns from the source field to the following target fields:

 

Pumping Start Date, in MM/DD/YYYY HH:MM:SS format, time is optional.

Pumping End Date, in MM/DD/YYYY HH:MM:SS format, time is optional.

Pumping Rate

 

Note: Please consider the following when importing a pumping schedule:

 

If time is not included in the source data (just the date), Visual MODFLOW Flex will automatically set the time to 12:00:00 pm.

Currently, Pumping Schedules can only be imported using absolute time. Please ensure that the date and time values in your source data are expressed in absolute time (MM/DD/YYYY HH:MM:SS) and not relative time (0-10 days, 10-20 days, etc..).

 

Well Heads with Observation Points

 

 

 

When this option is selected, you must first map the well heads under the Well Heads tab (described above). Next, click the Observation Points tab, and map the appropriate columns from the source data to the following target fields:

 

For Observed Heads:

Obs Point ID

Obs Point Z (Elevation)

Observed Head

Head Observation Date

 

For Observed Concentrations:

 

Obs Point ID

Obs Point Z (Elevation)

Chemical

Observed Concentration

Concentration Observation Date

 

The Obs. Point Z (Elevation) will determine in which model layer (cell) the observed head/concentration was measured; at the time when you view charts, VM Flex will find the calculated head value from the same cell, and then use this for comparing your observed value to what MODFLOW calculated. The same is true for Transport (MT3D) runs, but in this case it will take concentration from that cell, and compare to what you observed in the field.

 

Well Heads with Well Tops

 

 

When this option is selected, you must first map the well heads under the Well Heads tab (described above). Next, click on the Tops tab and map the appropriate columns from the source data to the following target fields:

 

Top Z, elevation (or measured depth) of formation

Top ID, formation name, e.g., Sand1, Sand2, Clay etc.

 

Please note, the well top data in the source file must be formatted as follows:

 

well ID

Top ID

Top X

Well1

Fill

6.5

Well1

Sand1

26

Well1

Clay

52

Well2

Fill

4

Well2

Sand1

17

Well2

Clay

94




 

 

Validation Step

 

The final step in the Well import process is data validation. Visual MODFLOW Flex will validate the mapped data, and highlights any rows that contain invalid data, e.g., null values, wrong assigned data type, duplicate rows etc.

 

 

 

 

Please see "Data Validation" section for more information on data validation.

 

Click the [Next] button to import the data. Once imported, a Wells data object will be added in the Data Explorer.

 

 


Page url: http://www.waterloohydrogeologic.com/help/vmod-flex/index.html?importwells.htm