Data Dictionary Download

Dicionario de datos

Columna Tipo Etiqueta Descrición
WCRNUMBER text WCR Number

Well Completion Report Number assinged by Online System for Well Completion Reports (OSWCR)
LEGACYLOGNUMBER text Legacy Log Number

Legacy DWR log number
REGIONOFFICE text Region Office

DWR region office
COUNTYNAME text County Name

County where the well is located
LOCALPERMITAGENCY text Local Permit Agency

Local regulatory authority over well construction, alteration, and destruction
PERMITDATE text Permit Date

Well permit date
PERMITNUMBER text Permit Number

Well permit number
OWNERASSIGNEDWELLNUMBER text Owner Assigned Well Number

Owner assigned well number
WELLLOCATION text Well Location

Address where the well is located
CITY text City

City, town or subdivision where the well is located, or the community nearest to the location of the well
PLANNEDUSEFORMERUSE text Planned Use/Former Use

Planned well use, or former well use
DRILLERNAME text Driller Name

Driller name
DRILLERLICENSENUMBER text Driller License Number

C-57 driller license number
RECORDTYPE text Record Type

Record type (New, Modification, Destruction)
DECIMALLATITUDE numeric Decimal Latitude

Decimal latitude, converted from text to number
DECIMALLONGITUDE numeric Decimal Longitude

Decimal longitude, converted from text to number
METHODOFDETERMINATIONLL text Method of Determination LL

Method used to determine horizontal coordinates
LLACCURACY text Lat/Long Accuracy

Accuracy of horizontal coordinates
HORIZONTALDATUM text Horizontal Datum

Datum of horizontal coordinates
GROUNDSURFACEELEVATION text Ground Surface Elevation

Ground surface elevation
ELEVATIONACCURACY text Elevation Accuracy

Accuracy of elevation
ELEVATIONDETERMINATIONMETHOD text Elevation Determination Method

Method used to determine elevation
VERTICALDATUM text Vertical Datum

Datum of vertical coordinate/elevation
TOWNSHIP text Township

Public Land Survey System township which well is located in
RANGE text Range

Public Land Survey System range which well is located in
SECTION text Section

Public Land Survey System section which well is located in
BASELINEMERIDIAN text Baseline Meridian

Public Land Survey System meridian baseline which well is located in
APN text APN

Assessor's parcel number which well is located on
DATEWORKENDED timestamp Date Work Ended

Date on which work on well ended, converted from text to date
WORKFLOWSTATUS text Workflow Status

Well Completion Report OSWCR record status
RECEIVEDDATE timestamp Received Date

Date on which Well Completion Report was received
TOTALDRILLDEPTH text Total Drill Depth

Total drill depth
TOTALCOMPLETEDDEPTH numeric Total Completed Depth

Depth to which well was completed, converted from text to number
TOPOFPERFORATEDINTERVAL text Top of Perforated Interval

Top of perforated interval (depth)
BOTTOMOFPERFORATEDINTERVAL text Bottom of Perforated Interval

Bottom of perforated interval (depth)
CASINGDIAMETER text Casing Diameter

Diameter of the well casing
DRILLINGMETHOD text Drilling Method

Drilling method
FLUID text Fluid

Drilling fluid
STATICWATERLEVEL text Static Water Level

Depth of Static Water Level after the well was built (casing and screen have been installed), the well was developed and the water level was stabilized prior to the pump test.
TOTALDRAWDOWN text Total Draw Down

Total Drawdown. The depth to water at the end of the pump test is the “pumping level”. The difference in depth between the static level and pumping level is the “drawdown”
TESTTYPE text Test Type

Test type (with pump or by airlift)
PUMPTESTLENGTH text Pump Test Length

Test length (hours)
WELLYIELD text Well Yield

Estimated Yield. This may or may not represent the well’s long-term yield, but it gives an indication. The yield is the maximum rate at which the water can be discharged from the well and sustained for the period of time stated on the WCR form.
WELLYIELDUNITOFMEASURE text Well Yield Unit of Measure

Well Yield Unit of Measure
OTHEROBSERVATIONS text Other Observations

Other Observations noted on Well Completion Report

Additional Information

Field Value
Última actualización 11 de agosto de 2023
Created 11 de agosto de 2023
Format CSV