In this series of articles we will take the RRC data from the SQL database and serve it via an OData REST API and show how we did it.
The series will consist of 3 parts:
- Part 1: Creating the OData REST API in Visual Studio using Entity Framework Core and C#
- Part 2: Setup Continuous Integration and Delivery for automated build and release pipelines to publish to Azure using Azure DevOps
- Part 3: Offering the API to the public via a secured Azure API Management gateway and developer portal
Sounds like a lot…I know, so if you want to fast forward to the end and start testing the API and the data just continue reading…you should be up and running in under 5 minutes.
Continue reading “TX RRC OData Feed – Intro”
Part 1: Well Locations
Last week I wrote a blog post talking about the TX RRC publishing data to the public that previously was only available via a paid subscription.
After downloading the different data sets and examining the various types of data and formats, I decided to take a closer look at the data that might prove to be useful to us and to our Productioneer clients.
It is not uncommon for location and depth data, as well as other well-header and meta data to be incomplete or non-existent during a software migration, after all this data might not be considered crucial for the daily gauge sheets. Especially in the case of Excel gauge sheets, where additional columns are a waste of “prime real estate” and might be considered as cluttering that particular production report.
It would be nice if we have a quick way to pull the Lat Long data in bulk to speed up the on-boarding process.
Continue reading “Visualizing the RRC Data in the Cloud”
In case your missed the announcement yesterday, The Railroad Commission of Texas (RRC) has released data sets on their website, below is the bulk of the email:
Continue reading “TX RRC Announces: Data Sets now available for free”
That’s what my client said to me: “I need my financial process as simple as pressing a button…”
She was joking, of course. But it really got my mind whirring. And then came one heck of a side project!
Continue reading “As simple as pressing a button…”
The accounting team at TPIC was spending too much time doing manual and repetitive tasks to close out the month and generate regular reporting packets for management. Having worked with us in the past, they asked us to streamline the process.
We promised them we’d make the process as fast and as simple as possible, joking that it would be as easy as pressing a button, and now it is!
A process that used to take days now only takes a few minutes, and all the manual labor has been reduced to a single button press, literally.
Continue reading “Cutting month-end closing times in half”