Export a county permit table and sort by operator

Shale Navigator brings US shale plays, drilling permits, lease offers, pipelines and mineral-rights information into one mapping workspace. To export a permit summary table for a county and sort by operator, begin with the county boundary and permits layer, not a company filter. That keeps records tied to the geography being reviewed and makes the company list easier to audit. It is useful when a land team needs a repeatable view of activity across neighbouring counties.

Australian energy investors and land professionals may use this US-focused view to assess an unfamiliar operating footprint. Australian firms listed on the ASX can hold US shale exposure, while local advisers compare opportunities across the Permian, Eagle Ford or Marcellus. A sorted table turns scattered permit records into a manageable shortlist, but it remains a research aid rather than a complete inventory of leases, mineral ownership or viable drilling locations.

A drilling permit is not the same thing as a lease. A permit can show that an application has been filed or approved; a separate lease-offer or mineral-rights layer may describe the land actually being sought. County boundaries also sit within state permitting systems, so read the table alongside relevant state rules and record dates. Treat the export as a screening tool and verify priority claims in official records before making an investment or land decision.

A practical workflow uses the map to narrow the search, the table to organise records and a spreadsheet to reconcile the export. This fits everyday habits in Australian offices: teams in Sydney, Melbourne and Brisbane often work in Excel or Google Sheets, and many prefer opening a downloaded file on a laptop rather than relying entirely on a browser grid. Keep the county, filters, export date and operator list together so a colleague can reproduce the result.

Choose the county and permit layer

Search for the county within its state rather than relying on the name alone. Names such as Washington, Jackson and Franklin occur across several US states, and the wrong boundary can add permits from another jurisdiction. Once selected, check the map for excluded areas, disconnected parcels or visible gaps in coverage.

Switch on the drilling-permits layer and frame the map around the county. Play boundaries can help a first-time user understand the geology, but they should not replace the administrative boundary for a county permit summary. If several permit categories are available, select the category required by your review and record that choice.

Use the map to spot clusters of activity, then open the table view for the selected area. The table supplies exportable detail while the map preserves spatial context. Avoid starting with a broad state or play if that will silently include counties outside the intended search.

Confirm the table contents

Before exporting, confirm that the table represents permits rather than lease offers, available mineral rights or general property data. Each layer answers a different question, and combining them without a clear purpose can produce a misleading count. For a permit-focused review, keep the operating footprint and property context on the map, but export the permit records alone.

Open the permit summary and review its columns. Useful fields commonly include operator or applicant, permit or application number, status, filing date, location and acreage. Retain the identifier and location fields; a name-only export is difficult to verify when two counties contain similarly named companies.

Apply status and date filters before downloading. An export of current applications may exclude historic permits that explain an operator’s established position, while an all-time export can be too broad for a weekly review. Name the file with the county, state, layer and export date so later versions are not confused.

Export the table and sort by operator

Choose a spreadsheet-ready CSV export for the working file. In the table view, select the Operator column and choose ascending order if its header supports sorting, adding permit date as a secondary sort where available. Export after sorting, then repeat the sort in Excel or Google Sheets to confirm the download retained the order.

In the spreadsheet, select only the Operator column, choose Data, Sort and A to Z, and select the option that the list has headers. Use the permit identifier as a stable secondary key. Check for blank or inconsistent company labels: “Acme Oil LLC”, “Acme Operating” and “Acme Holdings” may be connected, but they can also represent distinct registrants.

Preserve the source label and add a separate normalised-company column instead of overwriting the original. If the source gives only an applicant or permittee, verify the operator relationship before relabelling that column. This keeps the alphabetical list useful without turning an uncertain match into a supposedly definitive one.

Check and document the results

Compare the exported row count with the table shown on the map, then scan for duplicate permit identifiers, missing dates and unexpected operator labels. Keep an untouched copy of the original download, because permit records change, and perform cleaning in a separate working file. Record the source timestamp with the evidence.

Translate presentation without altering source fields. One acre is 0.404686 hectare, and a US month/day/year date should be read as day/month/year in an Australian report. If values are in US dollars, apply a dated exchange rate before comparing them with an Australian budget or portfolio exposure. Keep state and county names as issued.

Check what each status means in the source jurisdiction. “Approved” or “issued” can refer to different administrative stages, and a permit does not confirm that a well was drilled. Flag any inferred operator name for verification against the permit document.

If the export will support a client note, the first-person version checklist can help review the voice of an accompanying operator summary and check that its claims remain grounded in the table. Keep the data extract, map snapshot and written explanation linked, so readers can move from a company count to the underlying records without guesswork.

Use the export within Australian teams

This workflow does not replace Australian or US legal advice. A US drilling permit is governed by relevant state and local rules, not the petroleum legislation of Queensland, Western Australia or New South Wales. Mineral rights, surface ownership and access rights can sit with different parties. If an acquisition involves a foreign person, obtain advice under the Foreign Acquisitions and Takeovers Act and Australia’s foreign investment framework before committing capital.

For land due diligence, distinguish the export from a title search. An operator’s permit may cover a well location without proving ownership of the mineral estate, while a surface lease may grant access without granting drilling rights. Australian advisers should involve US title and land specialists to check title chains, easements and lease terms.

Treat personal information carefully when adding landowner details to a working file. The Australian Privacy Principles and the Privacy Act 1988 may apply when a covered organisation handles personal information in Australia, even if the underlying permit is a US public record. Collect only what the task requires, restrict circulation and follow the organisation’s retention rules.

Make the county review repeatable

Turn the first export into a baseline. Store it in a folder named for the county and state, with map filters, table settings and export date recorded in a short methodology note. At the next review, refresh the same filters and compare permit totals, new filings and operator changes. A consistent method is more valuable than a sophisticated but inconsistent spreadsheet.

For a larger review, use the operator-sorted table as the grouping layer, then return to the map for each significant company or county cluster. This keeps the summary focused on operators without losing location evidence. Subscription options extend the available data and features beyond a trial, so test the workflow with a small area before scaling to a multi-county mandate.

Create a free seven-day account with Shale Navigator, choose a county that matters to your pipeline and produce the first operator-sorted permit summary for your next team review. The resulting table gives Australian advisers a consistent, shareable starting point for checking US drilling activity.