Project: Processing Data

I am doing my project on the wells in Delaware County.  I have received my data from Dr. Mann in three separate Excel spreadsheets.  The first is general information: well number, owner name, owner address, city, zip, well depth, casing depth, depth to bedrock, monitoring, comments, the estimated top of the casing, the distance from a certain well, the coordinates, and the depth of the pilot test.  The second spreadsheet has information on the depth of water prior to pumping and at various stages in pumping.  There were three stages of pumping and net change in the water level was calculated after each step.  A change was also calculated after the pumping was completed, to measure the recovery.  The third spreadsheet showed the quality of the water data taken at various stages in the pumping.  The problem with this data is only about 25% of the wells had the quality of the water tested.  I don’t think I will be using the quality of water data for my project.

 I combined the first two spreadsheets and had to 99999 for any empty spaces.  I also shortened the titles and got rid of the format that Dr.  Mann had used.  I had to copy and pasted each column into notepad and then copy and paste again into Excel to get rid of the formatting.  Overall it wasn’t difficult, just took a little while to make sure the data was ready for ArcMap. 

The titles I used are as follows:

index number = Well#
Owner Name = Name
Owner Address = Address
City = City
Zip Code = Zip
Well Depth = WellDepth
Casing Depth = CasDepth
Depth to Bedrock = BedDepth
Monitoring Conduced = MonCon
Reported Water Quality Comments = RWQC
Estimated Top of Casing Elevation = ETCE
Approximate Distance from Well TW-5 = ADW_TW-5
UTM Easting = UTM_East
UTM Northing = UTM_North
Pilot Test Static Depth = PTSD
Water Depth (Prior to Pumping) 4/16-4/18/01 = WD_PP
Water Depth (End of First Pumping Stage) 4/24-4/25/01 = WD_P1
Net Water Level Change (End of First Pumping Stage) 4/24-4/25/01 = NWLC1
Water Depth (End of Second Pumping Stage) 5/5-5/6/01 = WD_P2
Net Water Level Change (End of Second Pumping Stage) 5/5-5/6/01 = NWLC2
Water Depth (End of Third Pumping Stage) 5/15-5/16/01 = WD_P3
Net Water Level Change (End of Third Pumping Stage) 5/15-5/16/01 = NWLC3
Water Depth (Recovery Monitoring) 6/11-6/15/01 = WD_RM
Net Water Level Change (Recovery Monitoring) 6/11-6/15/01 = NWLC4

Once I had the data ready, I saved as a database4 file and named the file MannData.  I opened up GIS and added the master shape.  I then added the MannData file.  I had to geocode addresses using my address locator I created for the midterm maps.  All but 8 addresses matched up.  I am currently working on “interactively” matching the addresses individually, at least this is how GIS put it.  I will try and get them all to match up, but if I can’t I will just use the ones that have.  I plan on making a general map of the wells adding other layers to correlate the location with Delaware County.  I also plan on doing bar type graphs to show a map of the well depth, casing depth, and depth to bedrock.  For my other 4 maps I plan on doing another bar type graph to show the net water level change after each pumping stage and the recovery.  That is all for now, I will updating soon.

Advertisement