We are continuing to develop the technology behind Organon Data and provide more ways to make OCC data more accessible. What could be better than having the data delivered to your inbox on a daily basis? We currently offer a daily report, free of charge, delivered in excel format each morning showing the previous day’s activity according to the Oklahoma Corporation Commission. The report shows all regulatory applications, protests, orders and well intents reported by the commission. It allows for quick filtering, pivoting, and mapping of the activity. There is also a link for each record that allows you to view the actual document on file with the state. Please email adam@OrganonData.com for a sample of the report, or request to be added to the distribution.
I remember, when I was younger, riding in a car and randomly seeing groups of people standing around with one of them peering through what looked like a telescope. I thought to myself, “these people are just standing around not doing anything.” I later figured out, it was a group of surveyors and learned what it was they were doing. I didn't know at the time, but the type of data they were collecting would have a huge impact on my career.
I have always had a deep seeded fascination with the concept of cartography and maps. Fast forward to my adult career in the oil and gas industry. As I walked the halls of Sandridge Energy, maps lined the walls, plotters were consistently running, and employees would have several maps tucked under their arms. While working in a technical support position, I stopped and tried to decipher a map on the wall. It was just colors and lines and didn’t make any sense to me. I set out on mission to better understand what these maps meant. During the process of understanding, I learned about the term Geographic Information System (GIS). In very simple terms, it’s the concept of taking flat data and adding a spatial component (location). This is where my career took a turn and a world of possibilities appeared before me. I was very fortunate to be able to spend part of my day at work learning GIS while also providing a technical support function. Geoprocessing, data management, and python coding were some of the behind the scenes tasks I was learning all the while I never created an actually map. I was given an opportunity to move into a land analyst position and literally within minutes of starting on my first day, I heard the words which would resonate over the years, “Let’s see it on a map.” I successfully created my first map and was off on a journey of mapping that exposed a passion founded by the fascination of cartography.
Over the course of several years, I made hundreds of maps and with the focus of the company on the Midcon play, specifically Oklahoma, Oklahoma corporation commission (OCC) data was critical to the maps. Poolings, spacings, increased densities, location exceptions, and well intents were screen scrapped weekly, sometimes daily to ensure we were showing the most recent data. This process was cumbersome and inefficient, but it needed to be done. When designing the technology behind Organon Data, I knew I wanted to use my experiences of data collection in the past as motivation to design a system that would easily integrate with enterprise GIS environments, as well as allow for smaller companies to easily convert the data into shp files for mapping.
For companies without an enterprise GIS environment, we offer an online mapping tool to view the regulatory and well spatial data. The interface allows for searching, zooming to features, and selections of the two datasets while seeing the results in a webviewer or tabular model. If you have ArcMap or QGIS, the data in our well and regulatory query export tool is normalized by CASENUM, and SEC-TWN-RNG (STR), meaning each STR has its own record. This makes joining to a section layer easier. Also, starting this year, we are offering shpfiles for weekly applications. Navigate to http://organondata.com/shpfiles , you will see a historic list of shpfiles. The files are all applications filed for the week ending in the date of the file.For enterprise systems, we offer access to Open RESTful services that allow you to consume the regulatory and well data in a format compatible with GIS servers, ArcGIS Online, and other interfaces such as GeoServer. The cached tiles of the services are update nightly, so you know the data you are representing in your web interfaces, or GIS Servers is update to date. I believe Organon Data is the only company offering access to OCC data in this format. Navigate to http://organondata.com/arcgis/rest/ to see the list of available REST services.
I have had the privilege of working with some industry innovators, as well as some young guns looking to reinvent the industry and the most common phrase I hear within the two group and everyone in between is “Let’s see it on a map!’
We offer custom mapping solutions for a fee using our data and client provided data. If you have a request, please send an email to email@example.com.
Organon Data was started by asking the age old question, "How can this be done better?" After spending several years of screen scraping and paying outrageous costs for licensing, I wanted an alternative for the current solutions for accessing Oklahoma Corporation Commission (OCC) data. Having spent a lot of time working with the regulatory and well data for industry analysis and mapping, it was always frustrating to not have an easy way to get the data into our systems. Sometimes, I would spend more time on the ETL (extract, transform, load) process than the actual analysis. Knowing this was very inefficient, I started brainstorming ways to improve the process. Having studied computer science, I knew there was technology to replace the need to hand key all of the data on a daily basis. Now all we need is data. Thankfully, the OCC provides scanned pdf copies of all regulatory and most well files. The OCC’s website does not allow for searching attributes such as applicant, application type, section, twn, rng, or county, although this data is in the pdfs. Since pdf is a very common file format and these files contain valuable information that cannot be data mined easily, a lot of companies offer Optical Character Recognition (OCR) tools to extract the text. Companies such as Google and Adobe have developed OCR tools with a very high level of accuracy on the text recognition. I tested several of the available tools and found the one I thought worked the best with the OCC’s format. I started writing the algorithms to capture the files from the OCC and processing them. This was still a just hobby, but I realized that I really may be onto something. I started organizing the extracted text into a relational database and the number of records appeared to be growing exponentially in size. I decided to purchase a server and to increase the effort I was putting into this project. I also reached out to my brother to see about turning this into a business. We decided to team up and sell the service of accessing the data I had been processing. Organon Data was built and we were one our way to providing an answer to my initial question. Having experienced the frustration of not being able to easily access the data and get it into the systems of company I was working for, I wanted to put a focus on developing a website that allows for easy access to the data. We set out and did just that. Our site allows for users to search the regulatory and well datasets given a variety of search parameters and easily export the result sets to a csv file which can be opened in Excel. Next we wanted to allow the users to visualize the data in relation to other filings and well spots. We developed a mapping interface that allows users to search for regulatory, or wells records. We are continuing to develop new services to access the data. For instance, we are working on developing a reporting service that will allow us to email out report subscriptions. Currently we have a Daily Activity Report available for subscription. Please email Contact@OrganonData.com if you’d like to be added to the subscription.
We do not limit the number of records you can export and there is no need to screen scrape as we try to provide the easiest methods possible to access the data. Also, we are not hand keying the data, so we do not feel we need to charge for each of those keystrokes and we have minimized the amount of human error that comes with hand keying the data. We hope you find our site and data as valuable and useful as we do. Please feel free to use the site free of charge while we continue to develop it. We welcome and encourage feedback in order to ensure our product provides value to you and your company, please send feedback to Contact@OrganonData.com.