{"disclaimer":"This record shows what TCEQ's public file reported when checked. Confirm delivery decisions against the official record and existing procedures.","facility":{"address":"305 SINGING OAKS","certificate_expiration_date":"2027-09-30","city":"SPRING BRANCH","county":"COMAL","dated_history_row_count":11,"facility_number":"87235","latest_status_counts":{"IN USE":1,"OUT OF USE":2},"multi_status_tank_count":2,"owner_name":"WAL-MART STORES TEXAS LLC","owner_name_variant_count":1,"owner_names":["WAL-MART STORES TEXAS LLC"],"registration_number":"RN107794497","regulated_entity_name":"WALMART SUPERCENTER 3056","review_required_tank_count":0,"source_row_count":11,"state":"TX","tank_count":3,"tanks":[{"candidate_statuses":["OUT OF USE"],"capacities_gallons":["1000"],"history":[{"capacity_gallons":"1000","expiration_date":"2027-09-30","product_type":"OTHER PETRO SUBST","source_row_id":"row-xnq4.mhv3~v493","status":"OUT OF USE","status_date":"2019-06-18"},{"capacity_gallons":"1000","expiration_date":"2027-09-30","product_type":"OTHER PETRO SUBST","source_row_id":"row-xb3a-i25a-rsvb","status":"IN USE","status_date":"2015-03-31"},{"capacity_gallons":"1000","expiration_date":"2027-09-30","product_type":"OTHER PETRO SUBST","source_row_id":"row-kpqu~sj42.krb9","status":"IN USE","status_date":"2015-01-15"}],"latest_status":"OUT OF USE","latest_status_date":"2019-06-18","multi_status_history":true,"product_types":["OTHER PETRO SUBST"],"review_required":false,"tank_number":"1"},{"candidate_statuses":["IN USE"],"capacities_gallons":["20000"],"history":[{"capacity_gallons":"20000","expiration_date":"2027-09-30","product_type":"GASOLINE","source_row_id":"row-e6yz~zrde_y4ax","status":"IN USE","status_date":"2015-03-31"},{"capacity_gallons":"20000","expiration_date":"2027-09-30","product_type":"GASOLINE","source_row_id":"row-brba_gpmh.hwqt","status":"IN USE","status_date":"2015-02-05"}],"latest_status":"IN USE","latest_status_date":"2015-03-31","multi_status_history":false,"product_types":["GASOLINE"],"review_required":false,"tank_number":"2"},{"candidate_statuses":["OUT OF USE"],"capacities_gallons":["20000"],"history":[{"capacity_gallons":"20000","expiration_date":"2027-09-30","product_type":"GASOLINE","source_row_id":"row-35x3_r6gc~24ki","status":"OUT OF USE","status_date":"2017-12-30"},{"capacity_gallons":"20000","expiration_date":"2027-09-30","product_type":"DIESEL","source_row_id":"row-2aua-b3hk~s5zy","status":"OUT OF USE","status_date":"2017-12-30"},{"capacity_gallons":"20000","expiration_date":"2027-09-30","product_type":"GASOLINE","source_row_id":"row-i5kf-5id4_s9fr","status":"IN USE","status_date":"2015-03-31"},{"capacity_gallons":"20000","expiration_date":"2027-09-30","product_type":"DIESEL","source_row_id":"row-gv3x.cxgn.usif","status":"IN USE","status_date":"2015-03-31"},{"capacity_gallons":"20000","expiration_date":"2027-09-30","product_type":"DIESEL","source_row_id":"row-wajh.enm5-dyqa","status":"IN USE","status_date":"2014-10-01"},{"capacity_gallons":"20000","expiration_date":"2027-09-30","product_type":"GASOLINE","source_row_id":"row-2e8b-2yhs_m3kd","status":"IN USE","status_date":"2014-10-01"}],"latest_status":"OUT OF USE","latest_status_date":"2017-12-30","multi_status_history":true,"product_types":["DIESEL","GASOLINE"],"review_required":false,"tank_number":"3"}],"zip_code":"78070","zip_extension":"6505"},"snapshot":{"canonical_sha256":"b106cddba0cb8568b117bdb92a27ba9d297c2ba4b7954f0b818998c6abda4d44","canonicalization_version":"1","cohort_size":250,"directory_selection_rule":"Every facility in the accepted snapshot. Latest tank status is resolved by dated source history; tied or undated latest records remain marked review required.","directory_size":16110,"distinct_facility_tank_count":43217,"multi_status_facility_count":1028,"multi_status_pair_count":1406,"resolved_multi_status_pair_count":1405,"retrieved_at_utc":"2026-09-15T19:02:34Z","selection_rule":"Facilities with at least one tank represented by more than one recorded status and no unresolved latest-date conflict; ordered by multi-status tank count, dated history row count, then numeric facility number.","source_last_updated_utc":"2026-09-15T13:03:39Z","source_url":"https://data.texas.gov/dataset/Texas-Commission-on-Environmental-Quality-Petroleu/jx8f-z4hu","total_facilities_in_snapshot":16110,"total_rows_in_snapshot":69240,"unresolved_latest_tank_status_count":1}}