Well constructor’s reports now available on CD-ROM
The Wisconsin Geological and Natural History Survey is now selling well constructor’s reports (WCRs)
by county on CD-ROM. The CD-ROMs contain scanned images of the currently available original paper copies, most dating from 1936 through 1989,
which number approximately 350,000.
What are well constructor's reports?
In addition to the images and the database, each CD contains a map of Wisconsin showing counties and Educational Series 44, Understanding Wisconsin township, range, and section descriptions. Both are in PDF format and can be viewed with Adobe Acrobat.
Try before you buy!
The sample files have been compressed into one zipped file; you will need special software to unzip the files. Many computers come with such software; if yours does not, you can find many freeware varieties on the Internet. For example, visit the Web site <http://www.zip995.com>.
Save (do not choose the “open file” option) the zipped file to your computer,
and then unzip it with your chosen software.
Scanned images take up a great deal of computer memory. It is not practical to put them in the same database as the location information, because then the database would run much too slowly (if at all). Therefore, the images are separate from the database, and a large number of CDs are needed to cover the state.
The basic location information (county, township, range, section, and quarter sections) was entered into a simple database so that you may search for WCRs by location. The structure of this database is included on the CD in the file structure.pdf. The database and the images are linked by the alpha-numeric name of the image (field name IMAGE_NO) composed of a two-character abbreviation for the county and a number that is unique within a given county, for example, CO619.tif.
To search, import the database (for example, for Columbia County the file name is COLUMBIA.dbf within the folder WcrData) into your software package (Exel, Access, or Paradox). You can sort the entire database by township, range, section, and quarter section, and scroll to the location you are interested in, or you can search for a specific township, range, section, and quarter section. You will need to print out (or write down) the image numbers (shown in the field named IMAGE_NO) for the locations of interest to you. Exit the database and open the folder WcrImages, sort the images by name (if necessary), and then look for the image numbers that you found in the database. Please note that the image numbers will be in ASCII order, which is not quite the same as numerical order. Numbers will be listed in the order: 1, 10, 100, 1000, then 1001, 1002 through 1009, then 101, 1010, etc. Just think of it as sorting the leftmost digits first, then moving to the next digit to the right. If a WCR has more than one page, the following pages have the same file name as the first page, except that it will have _x added to the file name before the extension, x representing the page number. For example, page 2 of the file CO1025.tif would be named CO1025_2.tif.
Please be aware that some WCRs were submitted without a location, or with only a partial location; therefore, some WCRs have some or all of the location fields blank. In addition, locations as reported on many WCRs may be in error. If you are searching for a WCR and cannot find it in the correct section, you may wish to search for it first in the surrounding sections, and then in the records at the beginning of the township that do not list a section. (WCRs that listed multiple sections were data entered with the section field blank.) If you have an owner’s name, then it may also be worth checking the records that are missing the township and/or range information.
Updated March 22, 2012