WI DNR 2003.TXT
BE SURE TO READ THE SPECIAL NOTES SECTION AT THE BOTTOM OF THIS DOCUMENT BEFORE PROCEEDING.
gINT v. 5 Agency Reports:
Wisconsin Department of Natural Resources
(see http://www.dnr.state.wi.us/org/water/dwg/gw/Software.htm for specifications)
Soil Boring Log Information, Form 4400-122 and -122A, Rev. 7-98
Monitoring Well Construction, Form 4400-113A, Rev. 7-98
Monitoring Well Development, Form 4400-113B, Rev. 7-98
Well/Drillhole/Borehole Abandonment, Form 3300-5, Rev. 2/2000
Groundwater Monitoring Well Information Form, Form 4400-89, Rev. 7-98
Groundwater Monitoring Inventory Form, Form 3300-67, Rev. 8-95
================
REVISION HISTORY
================
18 March 2003:
1. Converted from gINT version 4 to version 5 format.
2. Performed numerous optimizations of the forms and database structure without unnecessarily breaking compatibility with previous database versions.
3. Revised the Abandonment form to meet the 2/2000 revision requirements. Some database structures were required to change here. Data input with previous versions of the database may not work completely.
4. Renamed the names of all reports so that previous version would not be overwritten.
5. Renamed the files from WI_DNR98.Gxx TO WI DNR 2003.Gxx.
*********************************
?? ???????? 2002:
1. Well Info, Well Depth was:
<<Format(<<POINT.Well_Bottom>>)>>,0.0)>>
Now:
<<Format(_
<<Calc(_
<<POINT.Well_Bottom>> + _
<<FirstData(<<CONSTRUCTION.Casing_Elev>>,_
<<CONSTRUCTION.Prot_Pipe_Elev>>,_
<<POINT.Elevation>>_
)>> - _
<<POINT.Elevation>>_
)>>,_
0.0_
)>>
*********************************
02 December 1999:
1. Made use of the new captioning capabilities of the program (see the update README.TXT file under version 4.16.073). This allowed narrower columns in Input with better labeling of the columns.
2. Renamed the lookup "WDNR_SURFUCE_SEAL" to "WDNR_SURFACE_SEAL" and changed the one reference to it in the CONSTRUCTION table, Surf_Seal field.
3. Changed the Description property for the fields "SMU_Quantity_x" (x=1 - 4) from:
Sealing Material Used x: No. Years, Sacks Sealant or Volume
to:
Sealing Material Used x: No. Yards, Sacks Sealant or Volume
4. Changes to the CONSTRUCTION table and the Well Construction form:
a. Received request to allow selection of multiple USCS classification near screen. Previously there was a field in the CONSTRUCTION table called "USC_Screen" that had the lookup "wdnr_usc_screen" associated with it that showed the available choices. Only one could be selected. We removed this field from the database and the lookup from the library and added the fields:
USCS_GP
USCS_GM
USCS_GC
USCS_GW
USCS_SW
USCS_SP
USCS_SM
USCS_SC
USCS_ML
USCS_MH
USCS_CL
USCS_CH
USCS_Bedrock
All are "Yes/No" fields (blank is the same as "No"). You can mark as many as desired.
b. Received request to use some of the "..._Other" fields as notes, not just to imply the "Other" option. This affected the following sections:
1. Protective Cover Material
Previously there was just the text field PCP_Matl. If data were supplied in this field, the "Other" check box was marked. If this field was blank, the "Steel" check box was marked. Now there are the fields PCP_Steel ("Yes/No") and PCP_Matl_Other (text). If PCP_Steel is given the value of "Y" then the "Steel" check box is marked, otherwise the "Other" check box is marked. The PCP_Matl_Other field merely prints in the space provided on the form and does not affect the check boxes. Therefore you can now mark the "Steel" check box and give additional information in the text portion.
2. Material between well casing and protective pipe
Previously there was just the text field Matl_btwn_WC_PP. If data were supplied in this field, the "Other" check box was marked. If this field was blank, the "Bentonite" check box was marked. Now there are the fields Matl_btwn_WC_PP_Bent ("Yes/No") and Matl_btwn_WC_PP_Other (text). If Matl_btwn_WC_PP_Bent is given the value of "Y" then the "Bentonite" check box is marked, otherwise the "Other" check box is marked. The Matl_btwn_WC_PP_Other field merely prints in the space provided on the form and does not affect the check boxes.
3. Backfill material
Previously there was just the text field Backfill_Below_Filter. If data were supplied in this field, the "Other" check box was marked. If this field was blank, the "None" check box was marked. Now there are the fields Backfill_Below_Filter_None ("Yes/No") and Backfill_Below_Filter_Other (text). If Backfill_Below_Filter_None is given the value of "Y" then the "None" check box is marked, otherwise the "Other" check box is marked. The Backfill_Below_Filter_Other field merely prints in the space provided on the form and does not affect the check boxes.
c. There was an error in the Fill Type![Symbol] property of the "Other" check box for the "6. Bentonite Seal" section. It was:
Tile!<<IIf(<<HasData(<<CONSTRUCTION.Bent_Seal_Other>>)>> And And (Not <<HasData(<<CONSTRUCTION.Bent_Seal>>)>>),x04)>>
The double "And And" is the problem. One of the "And"s was removed to correct it.
d. Some of these changes required changes to a part of the conversion program. If you had used a previous version of this database, will be adopting this version, and want to use the database conversion program, you must download the latest version of that program from our Web site (no charge).
*********************************
13 July 1999:
1. Added the Well Information and Inventory forms.
2. Updated the soil boring, well construction, and development forms to match the 7-98 revisions.
3. Replaced log blocks used in the soil boring form with private blocks.
4. Made significant changes to the database structure to match the WDNR desired database format.
5. Renamed the files from WI_DNR.Gxx TO WI_DNR98.Gxx.
6. Renamed the old forms with a suffix indicating year of revision, for example. WDNR_SBL became WDNR_SBL_98. In this way, your old files and forms will not be overwritten by this new version and you can continue to use the old forms and data.
7. Added the following new lookups:
WDNR_CASING_TYPE
WDNR_CONTACT_TYPE
WDNR_DATA_MAINTENANCE
WDNR_DRILLING_METHOD
WDNR_INV_CONTR_TYPE
WDNR_INV_DATA_SOURCE
WDNR_LOCATION_COOR
WDNR_MUNICIPALITY_TYPE
WDNR_SECTION
WDNR_WATER_BEARING_FORMATION
WDNR_WELL_STATUS
WDNR_WELL_USE
The previous lookups are still in the new files. If you have changed those lookups and want to keep them, mark the "Select Non-duplicated" option when merging (see the INSTALLATION PROCEDURE section below).
NOTE: Data input with previous database structures will not work completely with the new forms. You can continue to use the old forms. If you must get the old data over to the new structure, you must set up a correspondence file in Data Design:Correspondence File and then use Utilities:Convert Projects. These are capabilities that were added after the manual was printed. Documentation can be found the gINT update README.TXT file. Search for "correspondence" and "convert". Feel free to call technical support for additional assistance.
*************************************************
16 June 1998:
1. In the PROJECT table, added:
Elevation_Reference (with Lookup WDNR_ELEV_REFERENCE)
Location_Coordinates (with Lookup WDNR_LOCATION_COOR)
LGO_Location_Estimated
LGO_State_North
LGO_State_East
LGO_Lat_Deg
LGO_Lat_Min
LGO_Lat_Sec
LGO_Long_Deg
LGO_Long_Min
LGO_Long_Sec
Well_Info_Remarks
2. Added POINT.Well_Status (with Lookup WDNR_WELL_STATUS)
3. Moved Govt_Lot field from ABANDONMENT to CONSTRUCTION table
4. Added CONSTRUCTION.Enf_Stds_Apply
*************************************************
16 January 1998:
1. Added four fields to DEVELOPMENT table: Responsible_Name
Responsible_Firm
Responsible_Street
Responsible_City_State_Zip
These fields will print in the lower left corner of the WDNR_WELL_DEVELOP form (Facility Address or Owner/Responsible Party Address).
2. Used the above new fields on the WDNR_WELL_DEVELOP form. Previously these fields had the Developed By name and firm in them.
*************************************************
22 December 1997:
Corrected errors in WDNR_CONSTR
The Fill Type[!Symbol] Property for the "Local Grid Location":
"S" check box should read:
Tile!<<IIf(<<HasData(<<POINT.North>>)>> And (<<POINT.North>> < 0),x04)>>
"W" check box should read:
Tile!<<IIf(<<HasData(<<POINT.East>>)>> And (<<POINT.East>> < 0),x04)>>
Corrected errors in WDNR_ABANDON:
The Fill Type[!Symbol] Property for the "Construction Report Available?" No box should read:
Tile!<<IIf(<<ABANDONMENT.Constr_Report>> = "N",x04)>>
Previously it was:
Tile!<<IIf(Not <<ABANDONMENT.Constr_Report>> = "N",x04)>>
The "Not " was removed.
*************************************************
09 December 1997:
Corrected errors in WDNR_SBL_PG1:
The Fill Type[!Symbol] Property for the "Local Grid Location":
"S" check box should read:
Tile!<<IIf(<<HasData(<<POINT.North>>)>> And (<<POINT.North>> < 0),x04)>>
"W" check box should read:
Tile!<<IIf(<<HasData(<<POINT.East>>)>> And (<<POINT.East>> < 0),x04)>>
The <<HasData()>> condition was previously omitted causing the S and W check boxes to be marked when there were not local grid data.
Corrected errors in WDNR_ABANDON:
The Fill Type[!Symbol] Property for the four check boxes left of the "No" labels in section (4) (starts with Depth to Water) should read:
Tile!<<IIf(<<ABANDONMENT.Pump_Piping_Removed>> = "N",x04)>>
Tile!<<IIf(<<ABANDONMENT.Liner_Removed>> = "N",x04)>>
Tile!<<IIf(<<ABANDONMENT.Screen_Removed>> = "N",x04)>>
Tile!<<IIf(<<HasData(<<ABANDONMENT.Casing_Left_No_Explain>>)>>,x04)>>
There was a "Not" in the expressions within the IIf.
*********************************
30 November 1997: Corrected errors in WDNR_WELL_CONSTR report template
Fill property of check box for the Well Casing schedule 40 check box should read ..."40", not ..."4". For the schedule 80 check box, the Fill property should read ..."80", not "8".
*********************************
06 November 1997: Initial Upload in the Windows version.
*********************************
INCLUDED FILES:
WI DNR 2003.GLB
gINT library file containing:
Logs : WDNR SBL 1998 Soil Boring
Graphical Tables : WDNR WELL INFO 1998 Well Information
Graphical Text Docs: WDNR ABANDONMENT 2000 Abandonment
WDNR WELL CONSTR 1998 Well Construction
WDNR WELL DEVELOP 1998 Monitoring Well Development
WDNR INVENTORY 1995 Well Inventory
Library Tables : WDNR_COUNTIES Wisconsin Counties and WDNR County Codes
WDNR_WELL_TYPE Well types and codes
Lookups : WDNR_ANNULAR_SEAL_INSTALL Annular space seal installation
WDNR_BENTONITE_SEAL Bentonite seal type
WDNR_CASING_TYPE
WDNR_CONSTR_TYPE Well Construction Types
WDNR_CONTACT_TYPE Wisconsin DNR Primary and Other Contact Types (Inventory Table)
WDNR_DATA_MAINTENANCE
WDNR_DEVELOP_METHOD Well Development Method
WDNR_DRILL_FLUID Drilling fluid used
WDNR_DRILL_METH Drilling method used
WDNR_DRILLING_METHOD Wisconsin DNR Drilling Method
WDNR_ELEV_REFERENCE Elevation Reference - MSL (default) and Site
WDNR_FILL_QUANTITY_UNITS Materials Used to Fill Well/Drillhole quantity units
WDNR_FORMATION Formation Types
WDNR_HOLE_TYPE Hole Type
WDNR_INV_CONTR_TYPE Wisconsin DNR Construction Types used on Inventory form
WDNR_INV_DATA_SOURCE Wisconsin DNR Inventory Well Data Source
WDNR_LOCATION_COOR Wisconsin DNR Location Coordinates
WDNR_MUNICIPALITY_TYPE Wisconsin DNR Municipality Type on Inventory form
WDNR_RANGE_DIR Range Direction
WDNR_RELATIVE_LOC Location of Well Relative to Waste/Source
WDNR_SCREEN_TYPE Screen type
WDNR_SEAL_PLACEMENT Method of Placing Sealing Material
WDNR_SECTION Wisconsin DNR Quarter Section
WDNR_SECTOR State plane sector
WDNR_SURFACE_SEAL Surface seal
WDNR_WATER_BEARING_FORMATION
WDNR_WATER_CLARITY Water Clarity
WDNR_WELL_CASING Well casing
WDNR_WELL_STATUS Wisconsin DNR Well Status
WDNR_WELL_USE Wisconsin DNR Inventory Well use
WDNR_YES_NO Yes, No
WDNR_YES_NO_NA Yes, No, Not Applicable
WDNR_YES_NO_UNK Yes, No, Unknown
User System Data : WDNR Other Field Mark
WDNR Yes Field Mark
Sampler Symbols : CS Core Sample
CU Cuttings
GS Grab Sample
PS Piston Sampler
Discrete Graphics : SHADED_BOX Well Construction Shaded Box
WI DNR 2003.GDT
gINT project data template. You will clone this file to create new project files.
WI DNR 2003.GPJ
gINT project file containing four boreholes of example data. You can use this file to clarify any input procedure questions by looking at the way the data was entered in the Input application. You can also output these data using the four reports to see what the final output looks like.
WI DNR 2003.GSC
A gINT command script that will print examples of all the forms. See SPECIAL NOTES below.
*************************************************
INSTALLATION PROCEDURE:
Copy WI DNR 2003.GDT and WI DNR 2003.GSC to your gINT data template directory (usually C:\Program Files\GINT\DATATMPL or C:\Program Files\GINTW\DATATMPL).
Copy WI DNR 2003.GPJ to your gINT projects directory (usually C:\Program Files\GINT\PROJECTS or C:\Program Files\GINTW\PROJECTS).
Merge WI DNR 2003.GLB:
Bring up gINT.
Move to the Utilities application group and then to the Lib Merge/Copy application.
Mark "Merge From".
Specify the source library file as WI DNR 2003.GLB. Remember to specify the path or use the launch button (...) to select the file with a file dialog.
Check the selection and query options to best meet your needs. If you wish to merge all of the above, mark Select All and Never Query.
Move all of the tables from the Available Source Table column to the Tables to Merge/Copy column by clicking the >> button.
Click the Execute button.
*************************************************
SPECIAL NOTES:
1. The graphical table and the four graphical text document forms require the full gINT program. gINT Logs and logWRITER+ can only access the log. Contact gINT Software regarding upgrade information.
2. The firm information in some of the reports is taken from the company name, address, location, telephone, and fax information provided by you. These values can be modified in any screen in gINT with the Help:Company Information menu selection.
3. Some of the sampler symbols use new tile patterns. You may need to update your tile library from the SYMBOLS file on the web page.
4. To reduce input effort, we have placed data entry fields that are shared among the different tables into the PROJECT and BOREHOLE (POINT) tables. For example, the Govt_Lot field is used by the construction, abandonment, and inventory forms but is input only once in the POINT table. Notes at the bottom of the input screen when you are on fields will give this information, and other useful notes, where appropriate.
5. You can print out all the forms quickly using the example project provided by executing the WI DNR 2003.GSC script. Anywhere in the Output application group, select the File:Command Script:Execute Script menu item and then specify the WI DNR 2003.GSC file for the script. You will see this file if you click the browse button [...] right of the field.
6. We have not updated our conversion process to convert from gINT to WDNR database structure. There have been significant changes made to both structures since the introduction of our first conversion program. Also, version 5 has the ability of writing to the WDNR structure directly, without the aid of an external program. This requires a significant change in the work we had completed since this is an entirely new process. We would be happy to complete this process and make it available to our clients but first we would like to know that it would be used. So please let us know if you want this facility. Otherwise we will concentrate on issues that are in demand by our clients.
*************************************************