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.
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.
