READ MORE - Texas RRC Data Design

North Dakota
API
FileNo
OriginalOperator
OriginalWellName
CurrentOperator
CurrentWellName
FieldName
CountyName
Township
Range
Section
QQ
Footages
Hole_Type
LATITUDE
LONGITUDE
FirstSpudDate
MeasuredTD
KBElev
DFElev
GRElev
GLElev
TY-BCHR
TY-BCHN
K-P
K-PJRS
K-PES
K-NB
K-GH
K-M
K-N
K-IK
J-S
J-R
T-S
PM-MK
PM-OP
PM-EBA
PM-BC
PN-T
M-EBS
M-BS
M-KL
M-MDUN
M-MD
M-MDR
PROD_STRING | GOVERNMENT_STRING_ID
??
PDEN_OPER_HIST|BUSINESS_ASSOCIATE
PDEN|CURRENT_OPERATOR
WELL|WELL_NAME
FIELD|FIELD_NAME
PDEN_AREA|COUNTY
WELL|SPUD_DATE
M-MDLS
M-MDFA
M-MDFY
M-MDSA
M-MDTI
M-MDLP
MD-B
D-DV
D-TF
D-BB
D-DP
D-SR
D-DB
D-PE
D-W
S-I
S-CL
O-G
O-ST
O-RR
O-WR
O-WI
O-BI
CO-D
PC
LogsOnFile
IPTDateOilWaterGas
Wellbore
Latitude
Longitude
WellType
WellStatus
CTB
https://www.dmr.nd.gov/OaGIMSSub/viewer.htm?well=%2723312%27
https://www.dmr.nd.gov/oilgas/FeeServices/wfiles/23/W23312.pdf
Scout Ticket
https://www.dmr.nd.gov/oilgas/feeservices/getscoutticket.asp
See page 4
See next page
Example URLs captured
https://www.dmr.nd.gov/oilgas/feeservices/dlogs/23/23312/23312-AA.tif
https://www.dmr.nd.gov/oilgas/feeservices/dlogs/23/23312/23312-AIG-CND-CAL.las
https://www.dmr.nd.gov/oilgas/feeservices/dlogs/23/23312/23312-AIG-CND-CAL.tif
https://www.dmr.nd.gov/oilgas/feeservices/dlogs/23/23312/23312-CAL.tif
May be able to digest/import LAS files someday, if desired?
Order and Case Index
Production Data
Not scraped
separate table - multiple rows
https://www.dmr.nd.gov/oilgas/feeservices/performancecurve.asp?ID=W2E112C4D23312
URL Only
https://www.dmr.nd.gov/oilgas/feeservices/declinecurve/declinecurve.asp?Type=well&Value=23312|BAKKEN
URL Only
Survey Data
https://www.dmr.nd.gov/oilgas/feeservices/getsurveydata.asp?ID=6D7B4C1423312
Not a link, just blue color text
North Dakota Scraped Fields
NDIC File No
API No
CTB No
Well Type
Well Status
Status Date
Wellbore type
Location
Footages
Latitude
Longitude
Current Operator
Current Well Name
Elevation(s)
Total Depth
Field
Spud Date(s)
Casing String(s)
NDIC File No
API No
County
CTB No
Well Type
Well Status
Status Date
Wellbore type
Location
Footages
Latitude
Longitude
Current Operator
Original Operator
Current Well Name
Original Well Name
Elevation(s)
Total Depth
Field
Field Link
Spud Date(s)
Image Logs
Formation Tops
Casing String(s)
Digital or Image Log(s) available [URLS]
https://www.dmr.nd.gov/oilgas/FeeServices/
wfiles/23/W[NDIC File No].pdf
https://www.dmr.nd.gov/OaGIMSSub/
viewer.htm?well=%27[NDIC File No]%27
Cores and Samples
??
API No
Type
Top
Bottom
Formation
Casing String(s)
NDIC File No
API No
County
CTB No
Well Type
Well Status
Status Date
Wellbore type
Location
Footages
Latitude
Longitude
Current Operator
Original Operator
Current Well Name
Original Well Name
Elevation(s)
Total Depth
Field
Field Link
Spud Date(s)
Image Logs
Formation Tops
Casing String(s)
Completion Data
Pool
Perfs
Comp
Status
Date
Spacing
API No
Pool
Perfs
Comp Dt
Status
Status Dt
Spacing
Cumulative Production Data
Pool
Cum Oil
MCF Gas
Cum Water
API No
Pool
Cum Oil
Cum MCF Gas
Cum Water
Javascript Links
Production Test Data
IP Test Date
Pool
IP Oil
IP MCF
IP Water
API No
IP Test Date
Pool
IP Oil
IP MCF
IP Water
DST
Recovery
NDIC File No
API No
CTB No
Well Type
Well Status
Status Date
Wellbore type
Location
Footages
Latitude
Longitude
Current Operator
Current Well Name
Elevation(s)
Total Depth
Field
Spud Date(s)
Pool
Date
Days
BBLS Oil
Runs
BBLS Water
MCF Prod
MCF Sold
Vent/Flare
NDIC File No
API No
Pool
Date
Days
BBLS Oil
Runs
BBLS Water
MCF Prod
MCF Sold
Vent/Flare
API No
File No
Leg
MD
Inc
Azimuth
TVD
Ft NS
NS
Ft EW
EW
Lat
Long
https://www.dmr.nd.gov/oilgas/feeservices/
getsurveydata.asp?ID=6D7B4C14[NDIC File No]
https://www.dmr.nd.gov/oilgas/feeservices/
performancecurve.asp?ID=W2E112C4D[NDIC File No]
https://www.dmr.nd.gov/oilgas/feeservices/declinecurve/
declinecurve.asp?Type=well&Value=[NDIC File No]|BAKKEN
Louisiana
http://sonlite.dnr.state.la.us/sundown/cart_prod/cart_con_orgad?p_orgid=5055
Well Permits (2000 - 2013)
http://sonlite.dnr.state.la.us/sundown/cart_prod/cart_con_allpmtwels2
http://sonlite.dnr.state.la.us/sundown/cart_prod/cart_con_wellinfo2?p_wsn=225732
Organization Name
http://sonlite.dnr.state.la.us/sundown/cart_prod/cart_con_orgad?p_orgid=5055
Well Information
http://sonlite.dnr.state.la.us/sundown/cart_prod/cart_con_wellinfo2?p_wsn=225732
Repeating rows possible
Cnt
Parish Name
Status
Well Serial
Well Name
Well Num
Permit Date
Org ID
Location
Field
Field Name
Meas Depth
Cnt
Parish Name
Status
Well Serial
Well Name
Well Num
Permit Date
Org ID
Location
Field
Field Name
Meas Depth
Org ID
Name
Oper Type
Addr1
Addr2
Add Type
City, State Zip
ATTN Name
Contact Name
Phone Num
Phone Type
Officer Name
Title
??
SERIAL
WELL NAME
WELL NUM
ORG ID
FIELD
PARISH
PROD TYPE
SEC
TWN
RGE
EFFECTIVE DATE
API NUM
SERIAL
WELL NAME
WELL NUM
ORG ID
FIELD
PARISH
PROD TYPE
SEC
TWN
RGE
EFFECTIVE DATE
API NUM
PRMT DATE
SPUD DATE
STAT DATE
ST CD
SERIAL
PRMT DATE
SPUD DATE
STAT DATE
ST CD
Surface Longitude
Surface Latitude
Lambert X
Lambert Y
Ground Elevation
Zone
Datum
SERIAL
Surface Longitude
Surface Latitude
Lambert X
Lambert Y
Ground Elevation
Zone
Datum
WELL SURFACE COORDINATES
UTMX 83
UTMY 83
LONGITUDE 83
LATITUDE 83
WELL SURFACE COORDINATES
UTMX 83
UTMY 83
LONGITUDE 83
LATITUDE 83
BOTTOM HOLE COORD
EFFECTIVE DATE
END DATE
PLUGBACK TOTAL DEPTH
TRUE VERTICAL DEPTH
MEASURED DEPTH
LAT DEG
LAT MIN
LAT SEC
LONG DEG
LONG MIN
LONG SEC
COORDINATE SOURCE
LAMBERT X
LAMBERT Y
ZONE
COORDINATE SYSTEM
SERIAL
EFFECTIVE DATE
END DATE
PLUGBACK TOTAL DEPTH
TRUE VERTICAL DEPTH
MEASURED DEPTH
LAT DEG
LAT MIN
LAT SEC
LONG DEG
LONG MIN
LONG SEC
COORDINATE SOURCE
LAMBERT X
LAMBERT Y
ZONE
COORDINATE SYSTEM
WELL HISTORY
SERIAL
WELL NAME
WELL NUM
ORG ID
FIELD
ST CD
PT
WELL CLASS
EFF DATE
END DATE
STAT DATE
SERIAL
WELL NAME
WELL NUM
ORG ID
FIELD
ST CD
PT
WELL CLASS
EFF DATE
END DATE
STAT DATE
SCOUT INFO
REPORT DATE
WELL STATUS
MEASURED DEPTH
TRUE VERT DEPTH
DETAIL
SERIAL
REPORT DATE
WELL STATUS
MEASURED DEPTH
TRUE VERT DEPTH
DETAIL
PERFORATIONS
SERIAL NUM
COMPLETION DATE
UPPER PERF
LOWER PERF
SANDS
RESERVOIR
SERIAL
COMPLETION DATE
UPPER PERF
LOWER PERF
SANDS
RESERVOIR
WELL TESTS
RPT TYP
TEST DATE
RPT DATE
OIL POT
COND
GAS DEL
WATER
BSW%
FLOW PRES
SHUTIN PRES
CHOKE
UPPER PERF
LOWER PERF
BOT HOLE PRES
SERIAL
RPT TYP
TEST DATE
RPT DATE
OIL POT
COND
GAS DEL
WATER
BSW%
FLOW PRES
SHUTIN PRES
CHOKE
UPPER PERF
LOWER PERF
BOT HOLE PRES
WELL ALLOWABLES
EFFECTIVE DATE
END DATE
LUW CODE
LUW TYPE CODE
ALLOWABLE
ESTIMATED POTENTIAL
CURRENT ALLOWABLE TYPE
SERIAL
EFFECTIVE DATE
END DATE
LUW CODE
LUW TYPE CODE
ALLOWABLE
ESTIMATED POTENTIAL
CURRENT ALLOWABLE TYPE
LEASE\UNIT\WELL PROD
RPT DATE
LUW CODE
STORAGE FAC
DOC USE
WELL CNT
OPENING STK
OIL PROD(BBL)
GAS PROD(MCF)
DISPOSITION
CLOSING STK
PARISH
SERIAL
RPT DATE
LUW CODE
STORAGE FAC
DOC USE
WELL CNT
OPENING STK
OIL PROD(BBL)
GAS PROD(MCF)
DISPOSITION
CLOSING STK
PARISH
CASING
COMPLETION DATE
CASING SIZE
WELLBORE SIZE
CASING WEIGHT
UPPER SET DEPTH
LOWER SET DEPTH
CEMENT SACKS
TEST PRESSURE
HOURS UNDER PRESSURE
TEST DATE
CASING PULLED
CREATION PROCESS
SERIAL
COMPLETION DATE
CASING SIZE
WELLBORE SIZE
CASING WEIGHT
UPPER SET DEPTH
LOWER SET DEPTH
CEMENT SACKS
TEST PRESSURE
HOURS UNDER PRESSURE
TEST DATE
CASING PULLED
CREATION PROCESS
PLUG AND ABANDON
P and A DATE
LOCATION TYPE
CASING CUT TYPE
CASING CUT DEPTH
MUD WEIGHT LEFT
COMMENTS
SERIAL
P and A DATE
LOCATION TYPE
CASING CUT TYPE
CASING CUT DEPTH
MUD WEIGHT LEFT
COMMENTS
PLUGS
PLUG TYPE
UPPER PLUG DEPTH
LOWER PLUG DEPTH
SACKS OF CEMENT
SLURRY WEIGHT
SERIAL
PLUG TYPE
UPPER PLUG DEPTH
LOWER PLUG DEPTH
SACKS OF CEMENT
SLURRY WEIGHT
TUBING AND PACKERS
COMPLETION DATE
TUBING SIZE
TUBING LOWER DEPTH
TUBING UPPER DEPTH
PACKER DEPTH
SERIAL
COMPLETION DATE
TUBING SIZE
TUBING LOWER DEPTH
TUBING UPPER DEPTH
PACKER DEPTH
WORK PERMITS
REFERENCE NUMBER
APPLICATION DATE
EXPIRATION DATE
WORK PERMIT TYPE
WORK PERMIT STATUS
WORK PERMIT STATUS_DATE
TOTAL DEPTH
WORK_PERFORMED
DOCUMENTATION RECEIPT DATE
TEST SAND
WORK DESCRIPTION
SERIAL
REFERENCE NUMBER
APPLICATION DATE
EXPIRATION DATE
WORK PERMIT TYPE
WORK PERMIT STATUS
WORK PERMIT STATUS_DATE
TOTAL DEPTH
WORK_PERFORMED
DOCUMENTATION RECEIPT DATE
TEST SAND
WORK DESCRIPTION
Texas
http://webapps2.rrc.state.tx.us/EWA/ewaMain.do
http://webapps2.rrc.state.tx.us/EWA/wellboreQueryAction.do
http://rrcsearch.neubus.com/esdrrc/api.php?function=GetImage&api_
no=00131618&rrcActionMan=H4sIA
AAAAAAAAL1SW0-DMBT-NfhCQtoChT
2ch8qqM9lAB_MS4kO3NRsJCiksasKPt
8VMdzMme_Cp53zn9p3vtMMIgdthhI
FcKLVgi7aoXqcLtczRM_T4m5yLum6Io
8NO04pWOu27s2ksl4VIZxCwyBV_YN
p0jfkmy3JeKXm3kerjq5-zrHTUgxfZrqtl
VkWiLDXgg5LtRr1mVSqFWqw1FAI6o
pE3fZSpVePUQomXe1FupGY3gKd-KM
IoCA_K8D-wb7asKWzLbsVKqh2WJ1fC
566U_zbGLAu4I4BR54LfeYA6XwNUAw
ddyJnClFI0cihbUZR_yLIsmroUH-Ofgl6
i-pQ0-IhdvjPIQAdbIv1fAzwwXxaZlfVD
QNRFbMhoNhp1McWh8XwgiKJeSuNS
GLJ7Ht8m08wikT1y7NSxeZqxjJtwANZ-mTUiIQgMQ8BGnq-7xnb3bE9uJuxO
JtN7ClPk9k04qk9YTG75hMemxnjcWT
yfHg0DwXqBdSltO8d7HkhxDwa6XqL
hA9JMry8iblFBsfqHKq4f3m8d_lPTHSV90DAAA
http://gis2.rrc.state.tx.us/public/startit.htm?api=00131618&rrcActionMan=H4sIAAAAAAAAAL1SW0-DMBT-NfhCQtoChT2ch8qqM9lAB_MS4kO3NRsJCiksasKPt8VMdzMme_Cp53zn9p3vtMMIgdthh
IFcKLVgi7aoXqcLtczRM_T4m5yLum6Io8NO04pWOu27s2ksl4VIZxCwyBV_YNp0jfkmy3JeKXm3kerjq5-zrHTUgxfZrqtlVkWiLDXgg5LtRr1mVSqFWqw1FAI6opE3fZSpVePUQomXe1FupGY3gKd-KMIoCA_
K8D-wb7asKWzLbsVKqh2WJ1fC566U_zbGLAu4I4BR54LfeYA6XwNUAwddyJnClFI0cihbUZR_yLIsmroUH-Ofgl6i-pQ0-IhdvjPIQAdbIv1fAzwwXxaZlfVDQNRFbMhoNhp1McWh8XwgiKJeSuNSGLJ7Ht8m
08wikT1y7NSxeZqxjJtwAN-Z-mTUiIQgMQ8BGnq-7xnb3bE9uJuxOJtN7ClPk9k04qk9YTG75hMemxnjcWTyfHg0DwXqBdSltO8d7HkhxDwa6XqLhA9JMry8iblFBsfqHKq4f3m8d_lPTHS-V90DAAA
grab urls
http://webapps2.rrc.state.tx.us/EWA/drillingPermitsQueryAction.do?pager.pageSize=100&pager.offset=700&methodToCall=search&searchArgs.paramValue=|1004=001|1005=beginsWith|1008=b
eginsWith|1012=beginsWith|1015=beginsWith&rrcActionMan=H4sIAAAAAAAAAL1Qu27DMAz8mnQUJLoOsnAwinbuI2gGI4NiE44A2TIoGW0BfXxpFwVSp2u7kcfD8e6y0RohG23Q3DA3VZNcGJ4bb
mt9xAV_o5MdxwhKziomm0ildzXFTVHttDAAN_Bwf6hkLOaxZee9G7pH4t6l-DQRf3zJqjYI6RZ7SufQ7sOd9V6AEpnSxMM-vJDl5izQDvWVmzou14q7qEbLtn-1fqLFpGhqbeahxBN1bogHl2YdEfqxG1jtl_z
VR_N_-eN37i2OtiO-yPdrGeZYr3mzWTQZUELnAgGgzNJKLhGKvBX0WuKv-_wEvX-e_FwCAAA
Repeating rows possible
http://webapps2.rrc.state.tx.us/EWA/drillingPermitDetailAction.do?methodToCall=searchByUniversalDocNo&universalDocNo=279267&rrcActionMan=H4sIAAAAAAAAAL1Qu27DMAz8mnQUJDpO
vXAwinbuI2gGI4NiE44A-QFKRltAH1_aRYHU6dpuvOPheMdktEZIRhs0N8x1WUc39M81N5U-4sK_0cmOYwAlaxWijaTiu5rCJisLLQrADTzcH0oZs3ls2Hnv-vaRuHMxPE3EH1-2qhlEtMWO4nlo9sOd9V6IHJ
nixP1-eCHL9VmoAvVVmios25LboEbLtnu1fqIlpHhqbeYhxxO1rg8HF2cfMfqBDazwpX510fxf__Dde4ejbYkv-v36DHOs1ro5LBYJUEqnDAEgT1u8FZAjZGkn_LXJX3_0E-yP28xeAgA
Wellbore Results
Well Type
Field Number
Current Operator Number
Operator Status
API No.
District
Lease No.
Lease Name
Well No.
Field Name
Operator Name
County
On Schedule
API Depth
API No.
District
Lease No.
Lease Name
Well No.
Field Name
Operator Name
County
On Schedule
API Depth
Tracking No.
Status
Packet Type
API No.
Drilling Permit No.
Well No.
Submit Date
Operator No.
Operator Name
Lease No.
Lease Name
Tracking No
Type Of Completion
Completion or Recompletion Date
Purpose Of Filing
Well Type
Wellbore Profile
Field No
Received Date
Posted Date
Internal Completion Date
W3 File Date
Plug Date
Form W-1
Status #
API #
Operator
Issued
Filed
Lease Name
Well #
District
County
Filing Purpose
Wellbore Profiles
Status
Well Status Code
Spud Date
Drilling Completed
Surface Casing Date
Field Name
Completed Well Type
Completed Date
Validated Date
Filing Purpose
Wellbore Profiles
Lease Name
Well #
SWR
Total Depth
Distance from Nearest Town
Direction from Nearest Town
Nearest Town
Surface Location Type
Section
Block
Survey
Abstract #
Perpendiculars
Distance
Direction
Distance
Direction
Permit Restrictions
Code
Description
W-1 Permits
API NO.
Dist.
Lease Name
Well Number
Permitted Operator
County
Status Date
Status Number
Wellbore Profiles
Filing Purpose
Amend
Total Depth
Status
??
API NO.
Dist.
Lease Name
Well #
Operator Name
Operator Number
County
Submitted Status Date
Approved Status Date
Status #
Wellbore Profile
Filing Purpose
Amend
Total Depth
Current Queue
Year
Fields
District
Field Name
Field #
Completion Depth
Lease Name
Well #
Well Type
Acres
Distance to nearest well
Distance to nearest Lease Line
SWR
Pooled/Unitized
Perpendiculars
Distance
Direction
Distance
Direction
Colorado
http://cogcc.state.co.us/Infosys/lgd/approved.cfm?STATEWIDE
No 05 in URL
http://cogcc.state.co.us/cogis/
FacilityDetail.asp?facid=00109776&TYPE=WELL
http://cogcc.state.co.us/cogis/IncidentSearch2.asp?facid=04512640
http://dnrwebmapgdev.state.co.us/mg2012app/?ogw='04512640'
http://ogccweblink.state.co.us/results.aspx?id=04512640
http://cogcc.state.co.us/schematic/045/0451264000.gif
http://cogcc.state.co.us/Orders/dirindex.cfm?Field=47525
Approved Permits
Received
Posted
Approved Date
Permit Type
Operator Name
API Number
Operator Contact
Contact Phone
Well Name
Well Number
Obective Formation
Proposed TD
Well Location
Field Name
Received
Posted
Approved Date
Permit Type
Operator Name
API Number
Operator Contact
Contact Phone
Well Name
Well Number
Obective Formation
Proposed TD
Well Location
Field Name
Surface Location Data
API #
Well Name/No
Operator
Status Date
Federal or State Lease #:
County
Location
Field
Elevation
Planned Location
Lat/Long
Lat/Long Source
API
Well Name No
Operator
Status Date
Federal Lease #
County
Location
Field
Elevation
Planned Location
Lat Lng
Lat Lng Source
Wellbore Permit
Sidetrack
Status
Status Date
Wellbore Permit
Permit
Expiration Date
Prop Depth/Form
Surface Mineral Owner Same
Mineral Owner
Surface Owner
API
Sidetrack #
Status
Status Date
Spud Date
Spud Date is
Wellbore Permit
Permit #
Expiration Date
Prop Depth/Form
Surface Mineral Owner Same
Mineral Owner
Surface Owner
Well Production [Oil]
Year
Month
Formation
Sidetrack
Well Status
Days Prod
Product
API
Year
Month
Formation
Sidetrack
Well Status
Days Prod
Product
BOM
Produced
Sold
Adj.
EOM
Gravity
BOM
Produced
Sold
Adj
EOM
Gravity
Water Disp. Code
Water Tbg.
Water Csg.
Water Prod
Water Tbg
Water Csg
Well Production [Gas]
Year
Month
Formation
Sidetrack
Well Status
Days Prod
Product
API
Year
Month
Formation
Sidetrack
Well Status
Days Prod
Product
Prod
Flared
Used
Shrinkage
Sold
BTU
Prod
Flared
Used
Shrinkage
Sold
BTU
Water Disp. Code
Water Tbg.
Water Csg.
Water Disp Code
Gas Tbg
Gas Csg
[URLS]
http://cogcc.state.co.us/Orders/dirindex.cfm?Field=47525
Formation and Spacing
Formation and Spacing
API
Sidetrack #
Formation and Spacing
http://cogcc.state.co.us/schematic/045/0451264000.gif
http://ogccweblink.state.co.us/results.aspx?id=04512640
http://dnrwebmapgdev.state.co.us/mg2012app/?ogw='04512640'
Wellbore Completed
Completion Date
Measured TD
Measured PB depth
True Vertical TD
True Vertical PB depth
Log Types(??)
API
Sidetrack #
Completion Date
Measured TD
Measured PB Depth
True Vertical TD
True Vertical PB Depth
Top PZ Location
Bottom Hole Location
Footage
Footages
Wellbore Completed Casing/Cement
Casing
Cement
API
Sidetrack #
Casing
Cement
http://cogcc.state.co.us/cogis/IncidentSearch2.asp?facid=04512640
Oklahoma
W47 PROD
API_COUNTY
API_NUMBER
S
WELL_NAME
WELL_NO
OPER_NO
OPERATOR
ME
SECTION
TWP
RAN
Q4
Q3
Q2
Q1
LATITUDE
LONGITUDE
OTC_COUNTY
OTC_LEASE_NO
OTC_SUB_NO
OTC_MERGE
POOL_NO
CODE
FORMATION
OFB
ALLOWABLE_CLASS
ALLOWABLE_TYPE
PURCH_NO
PURCHASER
YEAR
JAN
OIL
GAS
FEB
OIL
GAS
MAR
OIL
GAS
APR
OIL
GAS
MAY
OIL
GAS
JUN
OIL
GAS
JUL
OIL
GAS
AUG
OIL
GAS
SEP
OIL
GAS
OCT
OIL
GAS
NOV
OIL
GAS
DEC
OIL
GAS
W27 BASE
API_COUNTY
API_NUMBER
WELL_NAME
WELL_NO
OPERATOR_NAME
OPER_NO
STATUS
WELL_CLASS
OPERSTATUS
COUNTY_CODE
MERIDIAN
SEC_TION
TOWNSHIP
RAN_GE
QUARTER1
QUARTER2
QUARTER3
QUARTER4
FEET_NS
DIRECT_NS
FEET_EW
DIRECT_EW
LATITUDE
LONGITUDE
G_ELEVATION
D_ELEVATION
COMPLETION_DATE
DEPTH
MODIFYDATE
W97 OPER
OPER_NO
OFFICE_IND
PLUGGER_NO
CO_NAME
CLOSED
OPERATOR_IND
PURCHASER_IND
PLUGGER_IND
ATTN_NAME
STREET
POBOX
CITY
STATE
ZIP1
ZIP2
PHONE
W17 MDLIM
API-COUNTY
API-NUMBER
API-AMEND
BATCH-ID-DATE
BATCH-NUMBER
OTC-OCC-NUMBER
OTC-OCC-SUFFIX
APPROVED-DATE
REJECT-DATE
INTENT-TYPE
REASON-AMEND
BOTTOM-HOLE-TYPE
TOP-COUNTY-NUMBER
TOP-CM
TOP-TOWNSHIP
TOP-RANGE
TOP-SECTION
ALT-BATCH-ID-DATE
ALT-BATCH-NUMBER
TOP-QTR4
TOP-QTR3
TOP-QTR2
TOP-QTR1
TOP-S-N
TOP-FEET-S-N
TOP-E-W
TOP-FEET-E-W
TOP-FEET-LEASE
LEASE-NAME
WELL-NMBR
R-A-NAME
R-A-ADDRESS
R-A-ADDRESS2
R-A-CITY
R-A-STATE
R-A-ZIP
S-O-NAME
S-O-ADDRESS
S-O-ADDRESS2
S-O-CITY
S-O-STATE
S-O-ZIP
S-O-COPIES
BLM-IND
F-WATER-IND
S-WATER-IND
PROPOSED-SPUD-DATE
FORMATION1
FORMATION-DEPTH1
FORMATION2
FORMATION-DEPTH2
FORMATION3
FORMATION-DEPTH3
FORMATION4
FORMATION-DEPTH4
FORMATION5
FORMATION-DEPTH5
FORMATION6
FORMATION-DEPTH6
FORMATION7
FORMATION-DEPTH7
FORMATION8
FORMATION-DEPTH8
FORMATION9
FORMATION-DEPTH9
FORMATION10
FORMATION-DEPTH10
SPACING-1
SPACING-2
SPACING-3
SPACING-4
SPACING-5
SPACING-6
PENDING-CD-1
PENDING-CD-2
LOCATION-EXCEPTION-1
LOCATION-EXCEPTION-2
INCREASED-DENSITY-1
INCREASED-DENSITY-2
TOTAL-DEPTH
GROUND-ELEVATION
DEPTH-TWBF
CASING-DEPTH
ALT-CASING-IND
SPECIAL-ORDER1
SPECIAL-ORDER2
SPECIAL-ORDER3
SPECIAL-ORDER4
SPECIAL-ORDER5
CEMENT-CIRC-IND
CEMENT-CIRC-FROM
CEMENT-CIRC-TO
PIT-ON-IND
PIT-OFF-IND
PIT-CLOSED-IND
PIT-SITE-CNTY
OFF-SITE-CM
OFF-SITE-TOWNSHIP
OFF-SITE-RANGE
OFF-SITE-SECTION
OFF-SITE-QTR3
OFF-SITE-QTR2
OFF-SITE-QTR1
ONE-LAND-APPL-IND
APPL-PERMIT-YY
APPL-PERMIT-NBR
MUD-WATER-IND
MUD-OIL-IND
MUD-GAS-IND
MAX-PPM
AVG-PPM
GRND-WTR-6-IND
HYD-SENS-AREA-IND
CAT-OF-PIT1
CAT-OF-PIT2
CAT-OF-PIT3
PIT-LINER1
PIT-LINER2
EVAP-DEWTR-IND
SOLID-PIT-IND
ANNULAR-INJ-IND
NON-COMM-LAND-IND
COMM-PIT-IND
COMM-PIT-CNTY
COMM-PIT-CM
COMM-PIT-TOWNSHIP
COMM-PIT-RANGE
COMM-PIT-SECTION
COMM-PIT-PERMIT-NO
COMM-SOIL-IND
COMM-SOIL-CNTY
COMM-SOIL-CM
COMM-SOIL-TOWNSHIP
COMM-SOIL-RANGE
COMM-SOIL-SECTION
COMM-SOIL-PERMIT-NO
OTHER-METHOD
BOTTOM-HOLE-CNT
BOTTOM-COUNTY-NUMBER1
BOTTOM-CM1
BOTTOM-TOWNSHIP1
BOTTOM-RANGE1
BOTTOM-SECTION1
BOTTOM-QTR41
BOTTOM-QTR31
BOTTOM-QTR21
BOTTOM-QTR11
BOTTOM-S-N1
BOTTOM-FEET-S-N1
BOTTOM-E-W1
BOTTOM-FEET-E-W1
BOTTOM-HOLE-DEVIATE1
BOTTOM-HOLE-RAD-OF-TURN1
BOTTOM-HOLE-DIRECTION1
BOTTOM-HOLE-LENGTH1
BOTTOM-HOLE-DEPTH1
BOTTOM-HOLE-VERT-DEPTH1
BOTTOM-FEET-LEASE1
BOTTOM-COUNTY-NUMBER2
BOTTOM-CM2
BOTTOM-TOWNSHIP2
BOTTOM-RANGE2
BOTTOM-SECTION2
BOTTOM-QTR42
BOTTOM-QTR32
BOTTOM-QTR22
BOTTOM-QTR12
BOTTOM-S-N2
BOTTOM-FEET-S-N2
BOTTOM-E-W2
BOTTOM-FEET-E-W2
BOTTOM-HOLE-DEVIATE2
BOTTOM-HOLE-RAD-OF-TURN2
BOTTOM-HOLE-DIRECTION2
BOTTOM-HOLE-LENGTH2
BOTTOM-HOLE-DEPTH2
BOTTOM-HOLE-VERT-DEPTH2
BOTTOM-FEET-LEASE2
BOTTOM-COUNTY-NUMBER3
BOTTOM-CM3
BOTTOM-TOWNSHIP3
BOTTOM-RANGE3
BOTTOM-SECTION3
BOTTOM-QTR43
BOTTOM-QTR33
BOTTOM-QTR23
BOTTOM-QTR13
BOTTOM-S-N3
BOTTOM-FEET-S-N3
BOTTOM-E-W3
BOTTOM-FEET-E-W3
BOTTOM-HOLE-DEVIATE3
BOTTOM-HOLE-RAD-OF-TURN3
BOTTOM-HOLE-DIRECTION3
BOTTOM-HOLE-LENGTH3
BOTTOM-HOLE-DEPTH3
BOTTOM-HOLE-VERT-DEPTH3
BOTTOM-FEET-LEASE3
BOTTOM-COUNTY-NUMBER4
BOTTOM-CM4
BOTTOM-TOWNSHIP4
BOTTOM-RANGE4
BOTTOM-SECTION4
BOTTOM-QTR44
BOTTOM-QTR34
BOTTOM-QTR24
BOTTOM-QTR14
BOTTOM-S-N4
BOTTOM-FEET-S-N4
BOTTOM-E-W4
BOTTOM-FEET-E-W4
BOTTOM-HOLE-DEVIATE4
BOTTOM-HOLE-RAD-OF-TURN
BOTTOM-HOLE-DIRECTION4
BOTTOM-HOLE-LENGTH4
BOTTOM-HOLE-DEPTH4
BOTTOM-HOLE-VERT-DEPTH4
BOTTOM-FEET-LEASE4
CANC-IND
CANC-DATE
EXP-DATE
USER-ID1
TERM-ID1
TRANS-ID1
TRANS-DATE1
USER-ID2
TERM-ID2
TRANS-ID2
TRANS-DATE2
USER-ID3
TERM-ID3
TRANS-ID3
TRANS-DATE3
EXTENSION-IND
CANC-OPER-IND
SPECIAL-ORDER-IND
SPECIAL-ORDER-REJ-IND
DUP-API-IND
RE-PERMIT-ISSUED-IND
REENTRY-IND
R4C-COUNTER
WDMS-MSTR-REC-MISS-IND
FROM-RE-TO-API-IND
STAT-REJ-IND
APPROVE-DATE-IND
OPER-CANCEL-IND
OPERATOR-TYPEB
REJECTION-REASON1
REJECTION-REASON2
REJECTION-REASON3
REJECTION-REASON4
REJECTION-REASON5
REJECTION-REASON6
REJECTION-REASON7
REJECTION-REASON8
REJECTION-REASON9
REJECTION-REASON10
REJECTION-REASON11
REJECTION-REASON12
REJECTION-REASON13
REJECTION-REASON14
REJECTION-REASON15
REJECTION-REASON16
REJECTION-REASON17
REJECTION-REASON18
REJECTION-REASON19
REJECTION-REASON20
OTHER-REJECT-REASONS
OTHER-PIT-IND
WATER-WELL-IND
R1A-SURETY-FILED-IND
R1B-SURETY-EXP-IND
R1B-SURETY-EXP-DATE
R1B-SURETY-TYPE
R1C-SURETY-CONT-ORD-IND
R4A1-CASING-FEET
R4A2-ALT-CASING-PGM-IND
R4A3-ALT-CASING-AFF-IND
R4A4-REQ-FEET
R4A4-CURR-FEET
R4B-LESS-IND
R4B-MORE-IND
R4B-FEET-N-S
R4B-N-S
R4B-FEET-E-W
R4B-E-W
R4C-ORDER-NUMBER1
R4C-FORMATION1
R4C1-SQUARE1
R4C2-RECT-PATTERN1
R4C2-RECT-DIRECTION1
R4C3-RECT-SLOT1
R4C3-RECT-PRIOR-IND1
R4C3-RECT-SLOT-DIR1
R4C-ORDER-NUMBER2
R4C-FORMATION2
R4C1-SQUARE2
R4C2-RECT-PATTERN2
R4C2-RECT-DIRECTION2
R4C3-RECT-SLOT2
R4C3-RECT-PRIOR-IND2
R4C3-RECT-SLOT-DIR2
R4C-ORDER-NUMBER3
R4C-FORMATION3
R4C1-SQUARE3
R4C2-RECT-PATTERN3
R4C2-RECT-DIRECTION3
R4C3-RECT-SLOT3
R4C3-RECT-PRIOR-IND3
R4C3-RECT-SLOT-DIR3
R4C-ORDER-NUMBER4
R4C-FORMATION4
R4C1-SQUARE4
R4C2-RECT-PATTERN4
R4C2-RECT-DIRECTION4
R4C3-RECT-SLOT4
R4C3-RECT-PRIOR-IND4
R4C3-RECT-SLOT-DIR4
R4C-ORDER-NUMBER5
R4C-FORMATION5
R4C1-SQUARE5
R4C2-RECT-PATTERN5
R4C2-RECT-DIRECTION5
R4C3-RECT-SLOT5
R4C3-RECT-PRIOR-IND5
R4C3-RECT-SLOT-DIR5
R4C-ORDER-NUMBER6
R4C-FORMATION6
R4C1-SQUARE6
R4C2-RECT-PATTERN6
R4C2-RECT-DIRECTION6
R4C3-RECT-SLOT6
R4C3-RECT-PRIOR-IND6
R4C3-RECT-SLOT-DIR6
R4D1-SURF-EXCT-LOC-IND
R4D2-BOT-EXCEPT-LOC-IND
4E-APP1
4E-APP2
4E-CD-NUMBER-1
4E-CD-NUMBER-2
4E-HEARING-DATE-1
4E-HEARING-DATE-2
4F-LE-EXCEPT-ORDER
4F-LE-EXCEPT-NAME
4F-ID-EXCEPT-ORDER
4F-ID-EXCEPT-NAME
4G-INCR-DEN-EXP-DATE
4G-LOC-EXCEPT-EXP-DATE
4H-OUTLINE-IND
5-SPEC-ORD-VIOL-IND
5-SPEC-ORD-VIOL1
5-SPEC-ORD-VIOL2
5-SPEC-ORD-VIOL3
5-SPEC-ORD-VIOL4
5-SPEC-ORD-VIOL5
OFF-SITE-DIST
OFF-SITE-CNTY
OFF-SITE-NBR
WELLHEAD-PROT-IND
TER-DEPT-IND
BED-AQUIFER-IND
OTHER-HSA-IND
NON-HSA-IND
PIT-FORMATION
DEEP-SCA-IND
YIELD-GT-50-IND
CBL-REQ-IND
SOIL-LINER-REQ-IND
GEOM-LINER-REQ-IND
LINER-20MIL-IND
LINER-30MIL-IND
RECY-USE-IND
RECY-USE-CNTY
RECY-USE-CM
RECY-USE-TOWNSHIP
RECY-USE-RANGE
RECY-USE-SECTION
RECY-USE-PERMIT-NO
Kansas
http://maps.kgs.ku.edu/oilgas/index.cfm?extenttype=well&extentvalue=1001186907
http://chasm.kgs.ku.edu/apex/qualified.well_page.DisplayWell?f_kid=1001186907
http://www.kgs.ku.edu/PRS/ACO/W/31S14/262834.pdf
(sourced directly from page and there may be other links)
Can be saved to a file
Production reported by lease, not API
http://www.kgs.ku.edu/Magellan/Field/lease.html
http://chasm.kgs.ku.edu/apex/oil.ogl5.SelectLeases?f_c=1
http://chasm.kgs.ku.edu/apex/oil.ogl5.FileSave?f_url=+COUNTY_CODE+=+1+AND++STATE_CODE=15
Downloadable reports built dynamically
http://www.kgslibrary.com/library/survey_page.cfm?kid=1001186907
KID
API_NUMBER
API_NUM_NODASH
LEASE
WELL
FIELD
LATITUDE
LONGITUDE
LONG_LAT_SOURCE
TOWNSHIP
TWN_DIR
RANGE
RANGE_DIR
SECTION
SPOT
FEET_NORTH
FEET_EAST
FOOT_REF
ORIG_OPERATOR
CURR_OPERATOR
ELEVATION
ELEV_REF
DEPTH
PRODUCE_FORM
PERMIT
SPUD
COMPLETION
PLUGGING
MODIFIED
OIL_KID
GAS_KID
KCC_DOCKET
STATUS
STATUS2
COMMENTS
Leases
Lease
T-R-S
KS Dept. of Revenue
Lease Code
API Number (many?)
Operator
Oil
Gas
Cumulative production
Producing zone
Field
http://www.kgs.ku.edu/Magellan/Field/lease.html
Well Data
API
KID
Lease
Well
Original operator
Current operator
Field
Location
Longitude
Latitude
County
Permit Date
Spud Date
Completion Date
Plugging Date
Well Type
Status
Total Depth
Elevation
Producing Formation
IP Oil (bbl)
IP Water (bbl)
IP GAS (MCF)
KCC Docket No.
Cutting Data
Box Number
Starting Depth
Ending Depth
http://maps.kgs.ku.edu/oilgas/index.cfm?
extenttype=well&extentvalue=1001186907
http://www.kgs.ku.edu/PRS/ACO/W/31S14/262834.pdf
(sourced directly from page + other URLs)
Lease database
LEASE_KID
LEASE
DOR_CODE
OPERATOR
TOWNSHIP
TWN_DIR
RANGE
RANGE_DIR
SECTION
SPOT
LATITUDE
LONGITUDE
PRODUCES
PRODUCTION
YEAR_START
YEAR_STOP
Lease Production
LEASE_KID
LEASE
DOR_CODE
API_NUMBER
FIELD
PRODUCING_ZONE
OPERATOR
TOWNSHIP
TWN_DIR
RANGE
RANGE_DIR
SECTION
SPOT
LATITUDE
LONGITUDE
MONTH-YEAR
PRODUCT
WELLS
PRODUCTION
One month per row
Wireline Log Header
Logger
Tool
Operator on log
Top: 0; Bottom
Log Date
BHT
Gamma Ray
Spontaneous Potental
Holdings at
http://www.kgs.ku.edu/PRS/Scans/
Elog3/E/23S18/284232.zip
Cores
Barcode
Facility
Aisle
Column
Row
Top
Bottom
Core Type
Comments
Tops Data
Formation
Top
Base
Source
Updated