Laserfiche WebLink
Well Metadata txt <br /> CONUM - LLNL / PICME County Number <br /> GLOBALID - LLNL PICME Global ID (does not appear unique) <br /> - ---Type--=(-i—e-14un=ca-pat-,----i-n-dustrz-aa- -A-g r-rc a-lt u r a l,e t7c---)--F o r e rg---- <br /> n Key to tlkpWellTypes <br /> Source - Original data source <br /> Status - (Active, Inactive, Destroyed, Unknown} Foreign Key to <br /> tlkpWellStatus <br /> Street - Street address for well if known. May also be street <br /> address of well owner or purveyor <br /> if well address not known <br /> • City - City address for well if known May also be city addres <br /> s of well owner or purveyor if <br /> well address not known <br /> StateCode - Two letter abbreviation for each state. <br /> Zip - US Postal Service Zip Code. <br /> County - County where well is located. <br /> tblWells continued <br /> rNearestCrossStreet - Nearest cross street to well street addre <br /> ss if known <br /> SurveyRecID - Foreign Key to tblWellSurveys, Updated to be mos <br /> t accurate survey. <br /> Well0wnerID - Foreign Key to tblWellOwners. <br /> . TotalDepth - Total well depth from surface to bottom <br /> ' TotalScreenLength - Sum of total screen intervals <br /> DepthToUpperScreen -- Distance from ground level to first encou <br /> ntered screened interval <br /> • SanitarySealDepth - Depth of Sanitary Seal <br /> FlowRate -- Water produced by well and represented as gallons p <br /> er minute (GPM) <br /> - PeriodOfUse - Foreign Key to t1kpPeriods0fUse. <br /> DepthToWater - Depth to Static Drinking Water Aquifer <br /> Memo - Any additional or relevant information regarding the we <br /> 11 <br /> tblWellSurveys _ <br /> fields included in tblWellSurveys include <br /> • SurveyRecID - Primary Key , <br /> • WelllD - Well ID assigned by the State. FK to tblWells I <br /> TimeStamp - Date and Time of Survey <br /> SurveyMethod - FK to tlkpSurveyMethod. <br /> • Latitude - Latitude in decimal degrees <br /> • Longitude - Longitude in decimal degrees . ! <br /> . Datum - (i e . NAD27 , NAD83, WGS84 , etc } Datum used in determi <br /> I I <br /> Page ,2 <br /> rl I II <br /> , <br />