COLORADO RIVER WATER ENTERING MEXICO A guide to the data in this folder ==================================================================== SUMMARY -------------------------------------------------------------------- Most Colorado River water enters Mexico as river flow at one gauge, the Northern International Boundary (NIB, station 09522000). A smaller share arrives through canals, drains and wasteways further downstream. This folder has the NIB record for 1950-2025, a constructed series that adds those smaller crossings wherever data exist, and IBWC's official yearly totals for 1960-2006. In ordinary years NIB carries about 85% of the water. In flood years it carries nearly all of it. The constructed series matches IBWC's totals for 2004-2006, the only years when every crossing has data. In other years the constructed series is close to NIB alone. 1. WHERE THE WATER CROSSES -------------------------------------------------------------------- The river reaches Mexico at the NIB gauge, just above Morelos Dam, where Mexico diverts most of it into its canals. Below that point seven smaller channels also carry water across the border, much of it farm drainage: 09531850 Cooper Wasteway 09531900 Wellton-Mohawk Main Outlet Drain Extension (MODE) No. 3 09532500 Eleven Mile Wasteway 09533000 Twenty-one Mile Wasteway 09534800 Sanchez Mejorada Canal (combined) 09531110 Diversion Channel, operating since October 6, 2004 09533300 Wellton-Mohawk Bypass Drain The Sanchez Mejorada figure is itself built by IBWC from four smaller gauges: East Main Canal Wasteway (09534500), West Main Canal Wasteway (09534300), Yuma Main Drain (09534000) and 242 Lateral (09534550). NIB plus these seven make up all Colorado River water entering Mexico. Each carries separate water, so adding them counts nothing twice. These are gross figures: they include drainage and say nothing about treaty credit, water used in Mexico, or water reaching the Gulf of California. 2. THREE YEARLY SERIES -------------------------------------------------------------------- IBWC reported total (1960-2006) The official figure for all Colorado River water entering Mexico, as printed in IBWC's yearly bulletins. IBWC stopped publishing these bulletins after 2006. For 1983 and earlier, IBWC's definition of the total may differ slightly from later years, so those years are flagged in the comparison file. NIB (1950-2025) The river at the border, from USGS. There are no missing days from 1950 to 2025. Constructed (1950-2025) NIB plus whichever of the seven smaller crossings have data on each day. Because the available crossings change over time, what this series includes also changes: 1950 to 1970 NIB only. 1971 to 2003 NIB plus West Main Canal Wasteway, which adds only a few million m3 per year. 2004 to 2006 NIB plus all seven crossings. Complete. 2007 to 2025 Mostly NIB, with small additions in years when some portal records exist. The exact crossings used each year, and how many days each one contributed, are listed in border_inflow_annual_comparison.csv. How they compare Year IBWC total NIB Constructed ---- ------------ ------------ ------------ 1970 1.95 billion 1.62 billion 1.62 billion (m3) 1984 19.33 billion 19.03 billion 19.04 billion 1990 2.07 billion 1.74 billion 1.74 billion 2004 2.087 billion 1.803 billion 2.090 billion 2005 2.126 billion 1.834 billion 2.127 billion 2006 2.027 billion 1.735 billion 2.027 billion In ordinary years NIB falls short of IBWC's total by about 0.2 to 0.4 billion m3, roughly 7 to 19 percent. That shortfall is the water from the smaller crossings. In flood years, such as 1980 and 1983 to 1986, NIB is 96 to 99 percent of the total. For 2004-2006, when every crossing has data, the constructed totals differ from IBWC's by 0.14%, 0.05% and 0.01%. Differences this small fit with rounding in the published daily values. Outside 2004-2006 the constructed series is missing most of the smaller crossings, so it runs about 0.3 billion m^3 per year below IBWC's total in ordinary years. It is best read as a lower bound. 3. NIB FILES -------------------------------------------------------------------- daily_discharge_m3s.csv daily_discharge_cfs.csv One row per day, one column per USGS station. The column 09522000 is NIB, as average daily flow in cubic meters per second or cubic feet per second. The same files also hold Yuma (09521000, 1904 to 1983) and the Southerly International Boundary (09522200, 1960 to 1986) for comparison. Those three gauges sit along the same river, so they are compared rather than added. daily_discharge_with_flags.csv The same daily values with USGS notes attached. The column approval_status shows whether a value is final ("Approved") or may still change ("Provisional"), and qualifier holds remarks such as estimated values. monthly_complete_volume_acre_ft.csv water_year_complete_volume_acre_ft.csv Monthly and water-year volumes in acre-feet, column 09522000. A value appears only when every day of the period is present. 09522000_daily_as_returned.csv The NIB record exactly as USGS supplied it. The yearly NIB totals in cubic meters are in border_inflow_annual_comparison.csv (described below), in the column nib_complete_volume_m3. 4. CONSTRUCTED FILES -------------------------------------------------------------------- estimated_colorado_inflow_to_mexico_daily.csv One row per day. The main columns: constructed_available_m3s The constructed daily flow, m3/s: NIB plus every smaller crossing with data that day. Filled whenever NIB has a value. strict_all_components_m3s The complete version, filled only on days when all eight crossings have data (January 1, 2004 to December 31, 2006). nib_proxy_m3s NIB on its own, for comparison. constructed_available_daily_volume_m3 strict_all_components_daily_volume_m3 The same two series as daily volumes in cubic meters. available_component_count How many of the eight crossings had data that day. missing_strict_components Station numbers of the crossings without data that day. nib_source Where the NIB value came from. USGS covers the whole record, so this reads "USGS 09522000" throughout. diversion_structural_zero True before October 6, 2004, when the Diversion Channel is set to zero because it did not yet exist. estimated_border_inflow_monthly.csv estimated_border_inflow_calendar_year.csv estimated_border_inflow_water_year.csv Totals for each month, calendar year and water year, in cubic meters. The column constructed_available_volume_m3 holds the constructed total and strict_all_components_volume_m3 the complete total. Each appears only when every day in the period has a value; the columns days_with_any_data, days_with_all_components and expected_days show how close each period came. border_inflow_annual_comparison.csv The main yearly table, one row per year from 1950 to 2026, with the three series side by side. The key columns are ibwc_reported_total_m3, nib_complete_volume_m3 and constructed_complete_volume_m3. The columns reported_minus_nib_m3 and reported_minus_constructed_m3 give the differences. The column constructed_definition states in words what went into each year, and constructed_component_day_counts gives the number of days each crossing contributed. border_inflow_annual_comparison.png The plot of the yearly table. The upper panel shows the three series; the lower panel shows how much the smaller crossings add on top of NIB each year. border_inflow_components_m3s.csv One row per day with a column for every crossing and for the four Sanchez Mejorada sub-gauges, in m3/s. These are the raw ingredients. border_inflow_effective_construction_m3s.csv The eight daily values actually added together. Sanchez Mejorada appears in one column: the combined IBWC figure when available, otherwise the sum of whichever sub-gauges have data. The two are never added on top of each other. border_inflow_method.json The construction rules in a structured form. ibwc/all_colorado_inflows_to_mexico_annual.csv IBWC's reported yearly totals, 1960-2006, in cubic meters, copied from annual_totals.csv. 5. UNITS AND CONVENTIONS -------------------------------------------------------------------- Flows are daily averages in cubic meters per second (m3/s) or cubic feet per second (cfs). One cfs equals 0.0283 m3/s. Volumes are in cubic meters (m3) or acre-feet; one acre-foot equals 1,233.5 m3. A day at 1 m3/s delivers 86,400 m3. Months are labeled by their first day. A water year runs October through September and is labeled by its starting date, so the row 1985-10-01 is water year 1986. A blank means no data. Blanks are not treated as zero, with one exception: the Diversion Channel before it opened in October 2004. A recorded zero is a real zero. 6. OTHER FILES IN THE FOLDER -------------------------------------------------------------------- The folder ibwc/bulletins/ holds the original IBWC bulletins for 1960-2006. The folder ibwc/portal/ holds newer daily records from IBWC's online portal for six of the smaller crossings; most have long gaps, and ibwc/portal/coverage_by_year.csv shows which years are present. The folder raw/ keeps the original USGS downloads. 7. SOURCES -------------------------------------------------------------------- USGS, Colorado River at NIB above Morelos Dam https://waterdata.usgs.gov/monitoring-location/USGS-09522000/ USGS water data service https://api.waterdata.usgs.gov/docs/ogcapi/ IBWC water data and bulletins https://www.ibwc.gov/water-data/ IBWC online data portal https://waterdata.ibwc.gov/AQWebportal/