One of our biggest requests has been the ability to export data from our database to use in other software for further analysis. Fortunately, WellDatabase handles this in a very simple way. Below is a quick guide on how to export data from WellDatabase.
Creating Your Search
Our first step is to filter data down to get the dataset you are after. For our example, we will search all of the Yates wells in Andrews County, Texas. To make things easy, here is a link to the saved search.
The table view shows that we have 422 wells returned for this particular search. We are under the 10,000 limit, so we can now export. For this example we will be exporting the entire dataset, but you can also select individual wells to export by simply clicking the checkbox next to the wells you are interested in and then clicking the Export Wells button. Again, we are exporting the entire dataset, so we will just go straight to clicking the Export Wells button without selecting any wells.
This brings up the Export Wells screen where we have our export options.
We can quickly see the confirmation of the number of wells we were expecting to be exported. The format defaults to PDF, but Excel, CSV, and Shape File are also available. Below that we have the column list. The columns to export defaults to API, Latitude, & Longitude, but users can easily add columns to the list by simply clicking in the column field and choosing the column you want from the dropdown.
If you want to bypass the column selection and have every column exported, you can check the box under Include All Columns. Once you have all the columns you are interested in and the format chosen, click Export. For our example, we have chosen API, Well Name, Latitude, Longitude, CUM Oil, CUM Gas, and CUM Water. Below are the files exported from this example:
We have worked to make WellDatabase a world class data management and analysis tool, but there will always be situations where it is necessary to export the data into separate systems for a variety of reasons. At WellDatabase, we are more than happy to empower our customers with the ability to export the data to use how they see fit.
Larger dataset exports coming soon.
If you’re not already a WellDatabase user, sign up here and start using the map today.
As always, feel free to contact us at firstname.lastname@example.org with any questions or comments.