{"disclaimer":"This record shows what TCEQ's public file reported when checked. Confirm delivery decisions against the official record and existing procedures.","facility":{"address":"838 BANDERA RD","certificate_expiration_date":"2027-08-31","city":"SAN ANTONIO","county":"BEXAR","dated_history_row_count":14,"facility_number":"10910","latest_status_counts":{"IN USE":4},"multi_status_tank_count":0,"owner_name":"AJ 290 INVESTMENT LLC","owner_name_variant_count":1,"owner_names":["AJ 290 INVESTMENT LLC"],"registration_number":"RN100695980","regulated_entity_name":"PHILLIPS BANDERA","review_required_tank_count":0,"source_row_count":14,"state":"TX","tank_count":4,"tanks":[{"candidate_statuses":["IN USE"],"capacities_gallons":["10000"],"history":[{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":">E10","source_row_id":"row-wtqp.a9jy.fih9","status":"IN USE","status_date":"2026-03-30"},{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":"GASOLINE","source_row_id":"row-23j4_fvsv_b9yn","status":"IN USE","status_date":"2026-03-30"},{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":">E10","source_row_id":"row-ra7h_tk3h.r74j","status":"IN USE","status_date":"1984-01-01"},{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":"GASOLINE","source_row_id":"row-4fss.e5qq~7vm4","status":"IN USE","status_date":"1984-01-01"}],"latest_status":"IN USE","latest_status_date":"2026-03-30","multi_status_history":false,"product_types":[">E10","GASOLINE"],"review_required":false,"tank_number":"1"},{"candidate_statuses":["IN USE"],"capacities_gallons":["10000"],"history":[{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":">E10","source_row_id":"row-buis.3u9y_4fgn","status":"IN USE","status_date":"2026-03-30"},{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":"GASOLINE","source_row_id":"row-7u5r.bskm.xb67","status":"IN USE","status_date":"2026-03-30"},{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":">E10","source_row_id":"row-winc~avr2~gkrw","status":"IN USE","status_date":"1984-01-01"},{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":"GASOLINE","source_row_id":"row-pz8j.k4bm-8ifh","status":"IN USE","status_date":"1984-01-01"}],"latest_status":"IN USE","latest_status_date":"2026-03-30","multi_status_history":false,"product_types":[">E10","GASOLINE"],"review_required":false,"tank_number":"2"},{"candidate_statuses":["IN USE"],"capacities_gallons":["10000"],"history":[{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":"GASOLINE","source_row_id":"row-vbxm.gck3_2q9w","status":"IN USE","status_date":"2026-03-30"},{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":">E10","source_row_id":"row-b7ci~bv2e.rqq3","status":"IN USE","status_date":"2026-03-30"},{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":"GASOLINE","source_row_id":"row-eb75~838x-j8f6","status":"IN USE","status_date":"1984-01-01"},{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":">E10","source_row_id":"row-3q53~xszf~22rf","status":"IN USE","status_date":"1984-01-01"}],"latest_status":"IN USE","latest_status_date":"2026-03-30","multi_status_history":false,"product_types":[">E10","GASOLINE"],"review_required":false,"tank_number":"3"},{"candidate_statuses":["IN USE"],"capacities_gallons":["10000"],"history":[{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":"DIESEL","source_row_id":"row-t92z~sxde.9m67","status":"IN USE","status_date":"2026-03-30"},{"capacity_gallons":"10000","expiration_date":"2027-08-31","product_type":"DIESEL","source_row_id":"row-ib8f~dn6t-8cw5","status":"IN USE","status_date":"1984-01-01"}],"latest_status":"IN USE","latest_status_date":"2026-03-30","multi_status_history":false,"product_types":["DIESEL"],"review_required":false,"tank_number":"4"}],"zip_code":"78228","zip_extension":"5223"},"snapshot":{"canonical_sha256":"a1de72c1b28e31e1a68ba631aa47a31451aa979b8cac20aa59e35c737ca993cb","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":16001,"distinct_facility_tank_count":43007,"multi_status_facility_count":1044,"multi_status_pair_count":1431,"resolved_multi_status_pair_count":1430,"retrieved_at_utc":"2026-11-04T21:21:18Z","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-11-04T14:06:44Z","source_url":"https://data.texas.gov/dataset/Texas-Commission-on-Environmental-Quality-Petroleu/jx8f-z4hu","total_facilities_in_snapshot":16001,"total_rows_in_snapshot":69169,"unresolved_latest_tank_status_count":1}}