######Name_Name_Name_Name_Name_ADWR___55|_Longitude_|latitude__MTscreenBscreenDrillDDmp-elevm The header line above may be copied and pasted into your text data file. Please use this to see if your format is accurate and the data elements are in straight lines top to bottom. Often the header line can help identify if a data element has a truncated 55- in the ADWR 55 Registration Number, missing blank spaces after the top of screen value or some other imperfection. This will be noted as there are not straight lines for the data elements. When there is a format problem, you will find the elements are not in a staight line top to bottom. Find the ones out of place and evaluate the data element field lenght to see what may be amiss. Below is a key with the data elements in the header line identified above. Also there is information on the field length for the data element. If there are valid value or if a value must be captured in a reference table before use it will reference a reference table. The data elements and data records in the notepad or text file should line up under the header line. If it does not, check to see if there is an error in the data elements and record. Hopefully, the header line and the definitions for the data elements represented in the header line will help ensure accurate and complete text file submittals. Please remove the header line before transmitting the file to ADEQ or placement in the Uploaded File List table in the database. Let us know of any questions or suggestions for improvement. ###### = ADEQ Well number (field length 6 characters - left justified blanks spaces make up unpopulated character spaces) Name_Name_Name_Name_Name_ = Well Name aka Facility or common name of well. (well name)(field length 25 characters - left justified blanks spaces make up unpopulated character spaces) ADWR___55 = ADWR Number aka 55-xxxxxx ADWR registration number for the well. If unknown still after search use default value 55-NOCODE. (field length 9 characters - left justified blanks spaces make up unpopulated character spaces) |_Longitude_ = Longitude aka dddmmss.ssss Longitude of well using NAD 83 datum. (field length 12 characters - left justified blanks spaces make up unpopulated character spaces) |latitude__ = Latitude aka ddmmss.ssss Latitude of well using NAD 83 datum. (field length 11 characters - left justified blanks spaces make up unpopulated character spaces) M = Latitude/ Longitude Method aka Method used to determine lat/long location of well. * In AZWQDB see Generic Data main tab and REF_GEO_HORIZONTAL_COLLECTION (field length 1 characters - select a single character code) Tscreen = Top of Screened Interval aka In feet below reference measuring point aka measuring point.(field length 7 characters - left justified blanks spaces make up unpopulated character spaces) Bscreen = Bottom of Screened Interval aka In feet below reference measuring point aka measuring point. (field length 7 characters - left justified blanks spaces make up unpopulated character spaces) DrillDD = Drill Depth aka Total drilled depth of the borehole, in feet below ground surface. This may or may not be the same as the total depth of the well. (field length 7 characters - left justified blanks spaces make up unpopulated character spaces) mp-elev = = Reference Measuring Point evelation relative to sea level (field length 7 characters - left justified blanks spaces make up unpopulated character spaces) m = Method That elevation determined _ see Ref_Spatial_Method in reference table area or static web page reference tables (field length 1 characters - select a single character code)