APPENDIX G DATABASE FIELD DESCRIPTIONS Well Data Table List of Fields (One record allowed per State Well Number) Field Field Type Database Name 1. State Well Number Integer state_well_nu 2. FIPS County Code Small Integer county_code 3. Basin Small Integer basin 4. Zone Small Integer zone 5. Region Number Small Integer region_number 6. Previous Well Number Character(8) previous_well_nu 7. Latitude Integer latitude 8. Longitude Integer longitude 9. Owner Character(22) owner_1 10. Owner Character(22) owner_2 11. Driller Character(20) driller_1 12. Driller Character(20) driller_2 13. Accuracy of Coordinates Character(1) source_of_coords 14. Aquifer Code Character(8) aquifer_code 15. Aquifer ID #1 Small Integer aquifer_id1 16. Aquifer ID #2 Small Integer aquifer_id2 17. Aquifer ID #3 Small Integer aquifer_id3 18. Elevation of LSD Small Integer elev_of_lsd 19. Method of Elevation Measurement Character(1) meth_of_meas_elev 20. Users Code Economics Integer user_code_econ 21. Date Drilled Character(8) date_drilled 22. Well Type Character(1) well_type 23. Well Depth Small Integer well_depth 24. Source of Depth Measurement Character(1) source_of_depth 25. Type of Lift Character(1) type_of_lift 26. Type of Power Character(1) type_of_power 27. Horsepower Character(7) horsepower 28. Primary Water Use Character(1) primary_water_use 29. Secondary Water Use Character(1) second_water_use 30. Teriary Water Use Character(1) tertia_water_use 31. Water Levels Available (C,H,M,R,N) Character(1) water_level_avail 32. Water Quality Available (Y or N) Character(1) water_qual_avail 33. Well Logs Available Character(6) well_logs_avail 34. Other Data Available Character(5) other_data_avail 35. Date Collected or Updated Character(8) date_coll_or_updat 36. Reporting Agency Character(2) reporting_agency 37. Well Schedule in TWDB Files(Y or N) Character(1) well_sched_in_file 38. Construction Method Character(1) construct_method 39. Completion Character(1) completion 40. Casing Material Character(1) casing_material 41. Screen Material Character(1) screen_material 42. Lithological Log Type Character(2) lith_log_type 43. Lithology Interpreter Initials Character(3) lith_int_by 44. Lithology Interpretation Date Date lith_date G1 Well Remarks Table List of Fields (maximum 10 records allowed per State Well Number) Field Field Type Database Name 1. State Well Number Integer state_well_number 2. Order Number Small Integer group_number 3. Remarks - 1 Character(35) remarks_1 4. Remarks - 2 Character(35) remarks_2 G2 Casing Table List of Fields (Maximum 19 records allowed per State Well Number) Field Field Type Database Name 1. State Well Number Integer state_well_number 2. Order Number (down from top) Small Integer group_number 3. Casing/Screen/Open Hole indicator Character(1) c_s_o_indicator 4. Diameter of C,S or O Small Integer diameter_csg_scn 5. Top Depth of interval Small Integer top_depth 6. Bottom Depth of interval Small Integer bottom_depth G3 Water Level Table List of Fields (Unlimited number of records allowed per State Well Number) Field Field Type Database Name 1. State Well Number Integer state_well_number 2. Publishable/Nonpublishable (P or N) Character(1) pn_well_visit_mark 3. Depth From LSD Decimal(6,2) depth_from_lsd 4. Month Small Integer mm_date 5. Day Small Integer dd_date 6. Year Small Integer yy_date 7. Measurement Number Character(2) measurement_number 8. Measuring Agency Character(2) measuring_agency 9. Method of Measurement Character(1) method_of_meas 10. Remark Character(2) remark G4 Water Quality Table List of Fields (Unlimited number of records allowed per State Well Number) Field Field Type Database Name 1. State Well Number Integer state_well_number 2. Month Small Integer mm_date 3. Day Small Integer dd_date 4. Year Small Integer yydate 5. Sample Number Character(1) sample_number 6. Sample Time Character(4) sample_time 7. Temperature Celcius Character(2) temp_centigrade 8. Top of Sampled Interval Small Integer top_s_interval 9. Bottom of Sampled Interval Small Integer bottom_s_interval 10. Sampled Aquifer Code Character(8) samp_int_aqcode 11. Collection Remarks Character(30) collection_remarks 12. Reliability Remark Character(2) reliability_rem 13. Collecting Agency Character(2) collecting_agency 14. Lab Code Character(2) lab_code 15. Balanced/Unbalanced Analysis (B/U) Character(1) bu_wqanalysis 16. Silica Flag (< or >) Character(1) q00955_flag 17. Silica MGL Decimal(8,2) q00955_silica_mgl 18. Calcium Flag Character(1) q00910_flag 19. Calcium MGL Decimal(8,2) q00910_calcium_mgl 20. Magnesium Flag Character(1) q00920_flag 21. Magnesium MGL Decimal(8,2) q00920_magnes_mgl 22. Sodium Flag Character(1) q00929_flag 23. Sodium MGL Decimal(8,2) q00929_sodium_mgl 24. Potassium Flag Character(1) q00937_flag 25. Potassium MGL Decimal(8,2) q00937_potass_mgl 26. Strontium Flag Character(1) q01080_flag 27. Strontium MGL Decimal(8,2) q01080_strontium 28. Carbonate MGL Decimal(8,2) q00445_carb_mgl 29. Bicarbonate MGL Decimal(8,2) q00440_bicarb_mgl 30. Sulfate Flag Character(1) q00945_flag 31. Sulfate MGL Decimal(8,2) q00945_sulfate_mgl 32. Chloride Flag Character(1) q00940_flag 33. Chloride MGL Decimal(8,2) q00940_chloride_mg 34. Fluoride Flag Character(1) q00951_flag 35. Fluoride MGL Decimal(8,2) q00951_fluoride_mg 36. Nitrate Flag Character(1) q71850_flag 37. Nitrate MGL Decimal(8,2) q71850_nitrate_mgl 38. Ph Flag Character(1) q00403_flag 39. Ph Decimal(4,2) q00403_ph 40. Total Dissolved Solids Integer q70301_tds 41. Phenol Alkalinity Decimal(8,2) q00415_phen_alk 42. Total Alkalinity Decimal(8,2) q00410_total_alk 43. Total Hardness Integer q00900_tot_hardnes 44. Percent Sodium Small Integer q00932_percent_na 45. SAR Decimal(8,2) q00931_sar 46. RSC Decimal(8,2) q71860_rsc 47. Specific Conductance Flag Character(1) q00095_flag 48. Specific Conductance Integer q00095_spec_cond G5 Infrequent Constituent Table List of Fields (Unlimited number of records allowed per State Well Number) Field Field Type Database Name 1. State Well Number Integer state_well_number 2. Month Small Integer mm_date 3. Day Small Integer dd_date 4. Year Small Integer yy_date 5. Sample Number Character(1) sample_number 6. Storet Code Character(5) storet_code 7. Flag ( > or < ) Character(1) flag 8. Constituent Value Character(13) const_val 9. Confidence (plus or minus) Decimal(4,1) plus_minus G6 County Codes Table List of Fields Field Field Type Database Name 1. Old County Code (1 thru 254) Small Integer old_code 2. FIPS County Code (1 thru 507) Small Integer county_code 3. County Name (Upper Case) Character(15) county_name 4. County Name (Upper & Lower Case) Character(15) county_name2 5. Region Number Small Integer region G7 Basin Codes Table List of Fields Field Field Type Database Name 1. Basin Code Small Integer basin_code 2. Basin Name Character(26) basin_name G8 Aquifer List Table List of Fields Field Field Type Database Name 1. Aquifer Code Character(8) aquifer_code 2. Aquifer Name Character(70) aquifer_name G9 Storet Codes Table List of Fields Field Field Type Database Name 1. Storet Code Character(5) storet_code 2. Constituent Name Character(8) constit_name 3. Long Description Character(50) long_description 4. Short Description Character(8) short_description 5. Units of Measure Character(4) units_of_measure G10