Contact Us

Use the form on the right to contact us.

You can edit the text in this area, and change where the contact form on the right submits to, by entering edit mode using the modes on the bottom right. 

           

123 Street Avenue, City Town, 99999

(123) 555-6789

email@address.com

 

You can set your address, phone number, email and site description in the settings tab.
Link to read me page with more information.

Are your Federal Leases Expiring?

WhiteStar Navigator

Are your Federal Leases Expiring?

Robert White

White_Robert+Company+Photo.jpg

Every month, the Bureau of Land Management publishes the LR2000 data.  These massive files are a compilation, by state, including legal descriptions, of leases, permits, contracts, grants, agreements, mineral patents, etc. issued by the BLM on federal actions affecting public lands of the United States.  I wanted to see what it would take to extract and map just the federal oil and gas leases expiring in 2018 in Wyoming and their associated working interests.

The raw data are in a “pipe delimited text” format probably dumped from an Oracle database.  These data have no header information, so I had to manually create header columns for each table by reformatting an included text file.  I then used FME Workbench from Safe Software to read the data and write PostgreSQL tables. 

After analyzing the data, and with some help from the BLM, I was able to construct a query based on BLM database action codes, disposition codes, and my desired timeline - January through December 2018.  Running this query against my PostgreSQL tables,  I was able to produce a results table of the desired records.  The query took about ten minutes or so to run on my Surface Pro laptop.

I then used an FME workspace I had developed over the course of a couple of weeks to extract and massage the legal descriptions and publish them directly to ArcGIS Online. Every raw data source provides PLSS legal descriptions in a slightly different format. We have written a sensible standard we hope others will follow. 

Once cleaned up (Meridian, Township and range formatted, quarter quarter and lot descriptions checked), I can then pass the  properly formatted legal description along to the WhiteStar Legal Mapper  (WhiteStarLegalMapper) transformer which uses a REST endpoint to  produce the polygon geometry.  The polygons are returned to the FME workspace which then publishes it directly to ArcGIS Online using my account.  Once published, I produced an Esri  StoryMap. 

image.png

You can see the 2800 statewide leases displayed on a map of Wyoming.  These data are real, live and unretouched - probably a business opportunity or two is lurking here.

Now that I have an FME workspace created, I can reuse it next month to examine a new batch of leases and make it a permanent part of my workflow.


WhiteStar Legal Mapper

For a flat fee, map to infinity.
Two week free trial

Save the date!

Join WhiteStar at the ESRI Petroleum GIS Conference
May 9-10, 2018 | Houston, TX
Booth #400