1 / 33

Importing Production information from Ks. Geol Survey into Geographix well tables

Importing Production information from Ks. Geol Survey into Geographix well tables. Survey Website - Energy. Lease Production link. List of all leases in database (Top listed archive). Select save file. Note location of downloaded file. File downloading. File saved to desktop.

aspen-terrell
Download Presentation

Importing Production information from Ks. Geol Survey into Geographix well tables

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Importing Production information from Ks. Geol Survey into Geographix well tables

  2. Survey Website - Energy

  3. Lease Production link

  4. List of all leases in database(Top listed archive)

  5. Select save file

  6. Note location of downloaded file

  7. File downloading

  8. File saved to desktop

  9. Saved text file (CSV delimited)

  10. Extract zipped file

  11. Raw data file opened in Notepad

  12. Using Excel, open text file (Delimited CSV)

  13. Imported data in Excel

  14. The next step involves preparing the spreadsheet for import into ‘Geographix’ • Several columns need to be added now to facilitate importing later. Steps taken now will speed up the process for all counties imported. • Need to Add BH Flag , Principal Meridian, and a Status • Status will be used later in filters to handle data spotting • Turn on Autosort on Data submenu • Sort by product (oil, gas, NULL) • Sort by County • Copy resulting rows to new spreadsheet. • We will use the KGS LEASE_KID as the unique ID • We will also import lat/long data • Last column to complete hyperlink is URL

  15. Spreadsheet with added columnsshown in yellow fill

  16. Portion of spreadsheet with Lat/Long, Cumulative Production, Year of first production, URL, and Status

  17. Turning on Autofilter to sort by County and Product

  18. County and Product filtered

  19. Copy rows to new spreadsheet and save as CountyName_Product.xlsx

  20. Open Geographix and WellbaseSelect File, Import, Spreadsheet

  21. Open County Spreadsheet and select Add-Ins from Main Menu

  22. Select Location Congress from Upper Left Pulldown Menu. This shows which table you will be importing data into.

  23. Assign Fields to ID, BH Flag, Lat/LongTransfer data using Import Icon

  24. Select Tables to Process and Allow Updates of existing wells

  25. Assign Fields to ID, Status (KGSPROD)Transfer data using Import Icon

  26. Assign Fields to ID, and Document URLTransfer data using Import Icon

  27. Select Tables to Process and Allow Updates of existing wells

  28. After data import is completed for various tables. Next step is creating a Filter for KGSPROD status. Save filter then Create Wellbase Layer using KGSPROD filter

  29. Change well symbol for KGSPROD status from location circle to “+” (plus sign) in well symbol manager and update layer using filter.

  30. Open GeoAtlas and add layer to displayed map.

  31. Portion of Ellis County with Grid, Culture, and imported wells with hyperlinks

  32. Viewing data using hyperlink. • Select hyperlink layer as active layer. • Select area of interest with mouse, (click and drag) • Right click with mouse to select “View wells in Wellbase” • Select documents button at bottom left of window • Select hyperlink and view. • Browser window will open and display data from Active Ks Geological Survey Energy website.

  33. Thanks for coming for lunch today! • Anthony Ford Territory Manager – Mid Continent Denver Place, South Terrace 999 18th Street, Suite 650 Denver, CO. 80202 • Tim Lauer Consultant / GGX representative Wichita, KS. 67205 tlauer@cox.net

More Related