# Nightly TCEQ compliance sync preventing fuel drops at non-compliant Texas stores

> TCEQ delivery certificates commonly expire at month-end, turning 5,500+ Texas stores into a last-day compliance fire drill. We connected the Texas Open Data Portal to Gravitate so every site's delivery-certificate date updates nightly. One refresh surfaced 100 expired tanks before the next day's deliveries, avoiding up to $1M in potential fine exposure in a single day.

Client: Mid-Market Fuel Carrier
Published: 2026-10-01
Services: software-development, software-development/systems-integration, ai-automation, ai-automation/data-pipeline-engineering
Results: $1M Potential exposure avoided in one day; 100 Expired tanks caught before delivery; 5,500+ Stores checked nightly
Stack: Texas Open Data Portal, TCEQ delivery certificate data, Gravitate TMS

## The problem

A mid-market fuel carrier delivers to 5,500+ open convenience stores in Texas, each with its own fuel-delivery authorization status. For underground storage tanks receiving motor fuel, Texas requires a valid, current TCEQ delivery certificate. A carrier that drops fuel without one can face administrative enforcement. That is not a recordkeeping problem. It is a dispatch decision with real financial exposure.

The work peaked at the end of every month. Delivery certificates commonly expire on the last day, so dispatch and operations managers had one concentrated day to monitor TCEQ data, find changed certificate dates, and update stores in Gravitate one at a time. At 5,500+ locations, that was a monthly fire drill. A certificate could expire between checks, leaving a load headed for a site that should not receive it.

## What we built

We connected the Texas Open Data Portal's TCEQ delivery-certificate dataset to Gravitate, the carrier's transportation management system. The portal publishes certificate expiration dates and other basic information for facilities with active delivery certificates.

Each night, the integration retrieves the current dataset, matches TCEQ facility records to the carrier's stores, and writes updated delivery-compliance dates back to Gravitate. Dispatch works from current status in the system where loads are planned and released. No exports. No spreadsheet reconciliation. No separate compliance queue for someone to remember.

The job is deliberately narrow: keep the authoritative certificate dates current before the next day's deliveries. When a site's status changes, the TMS has the date needed to prevent an unapproved drop before a driver is sent there.

## Results

All 5,500+ open Texas stores now have their TCEQ delivery-compliance dates refreshed nightly in Gravitate. The month-end rush is gone. Instead of reconciling thousands of stores against the public dataset on the day certificates expire, dispatch starts each day with current dates in the TMS.

One nightly refresh surfaced 100 tanks with expired delivery certificates before the next day's loads were released. Had the carrier delivered to those tanks the following day, it could have faced fines of $10,000 per incident, up to $1 million in potential exposure. The integration made the exception visible in time for dispatch to stop those drops.

Texas calls this a delivery prohibition. The TCEQ requires a valid, current delivery certificate for applicable UST fuel deliveries and holds common carriers responsible for unlawful deliveries. Automating the status check gives the carrier a practical control at the point where it matters: before fuel leaves for a store that is not cleared to receive it.
