Department of Transportation federal obligations in Hawaii

DOT awards tagged to Hawaii

Department of Transportation as awarding agency, Hawaii as place-of-performance: 817 records summing to $2,427,859,803.02. A Department of Transportation award coded outside HI is out. An award in Hawaii from a different awarding agency is out even if the topic sounds related. Hawaii (HI) is a distinct place-of-performance key. California and Alaska DOT rows are other cells. Place of performance is HI, not a Pacific theater.

Eight hundred seventeen awards is a thin-to-mid DOT island file: fewer rows than a typical mainland formula book, more than a handful of oversized Energy awards. Unique recipients are unpublished. Do not read 817 as 817 unique lane-miles, unique contractors, or named Interstates. The overlay Department of Transportation in Hawaii is the both-keys table. Hawaii federal spending is the all-agency state hub. Department of Transportation is the agency book without an HI filter. All spending ties lists other joins.

Oahu-versus-neighbor-island folklore is not a packet split. A mode split (aviation versus highway) is unpublished. Correlation is not causation: Hawaii did not “cause” $2,427,859,803.02 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 069 × HI only.

Not a harbor, runway, or H-1 census

$2,427,859,803.02 does not measure lane-miles, unique contractors, or named Interstates. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 069 and an HI place-of-performance tag.

Do not treat 817 awards as a census of lane-miles, unique contractors, or named Interstates. Parent hubs are supposed to be larger than this pair. If Hawaii federal spending or Department of Transportation matched $2,427,859,803.02 and 817, the join would be pointless. Use the overlay when both keys must stay on. California and Alaska DOT joins are other pairs, not addends.

Hawaii is not a Pacific rollup

Place of performance HI is a geography tag on the award, not a metro list and not a commuting zone. Hawaii (HI) is a distinct place-of-performance key. California and Alaska DOT rows are other cells. Place of performance is HI, not a Pacific theater. Recipient address can differ from that state tag.

Oahu-versus-neighbor-island folklore is not a packet split. A mode split (aviation versus highway) is unpublished. This packet does not split $2,427,859,803.02 by city, county, or named facility. 817 awards stay statewide. A county table would be a different extract.

Thin-to-mid DOT island file, still obligations

Even a thick or thin file records obligations, not necessarily outlays. $2,427,859,803.02 can include amounts that pay on a later schedule. Citing it as cash already sent in Hawaii confuses two concepts. Deobligations and upward adjustments both move the total.

Hawaii’s own budget is a different ledger. Mixing it with the 817-award USAspending file leaves this series. No fiscal year is published in this packet, so this page does not invent one. Keep the obligation label on $2,427,859,803.02.

Citing DOT in Hawaii

Cite USAspending.gov: Department of Transportation (agency 069) obligated $2,427,859,803.02 on 817 awards coded to Hawaii. Name both sides. Keep “obligations.” Do not relabel the total as lane-miles, unique contractors, or named Interstates.

Prefer Department of Transportation in Hawaii if the overlay has refreshed after an ingest. Hawaii federal spending still includes every other awarding agency tagged to HI. Department of Transportation is the 069 parent without the HI filter. All spending ties indexes other pairs. Do not add those parents into $2,427,859,803.02.

A usable footnote names Department of Transportation, Hawaii, $2,427,859,803.02, and 817. The compact headline $2.43 billion is that same dollar total rounded. It is not a second extract. The implied mean near $2.97 million is $2,427,859,803.02 divided by 817. Means are not medians. USAspending.gov remains the originating system.

Questions

How much has the Department of Transportation obligated in Hawaii?

USAspending.gov records $2,427,859,803.02 across 817 awards with awarding agency 069 and a Hawaii tag. That is an obligation join, not an outlay and not a count of lane-miles, unique contractors, or named Interstates. Department of Transportation in Hawaii is the live overlay for this pair. Keep both keys when quoting $2,427,859,803.02.

Is $2,427,859,803.02 a measure of lane-miles, unique contractors, or named Interstates?

No. The packet publishes $2,427,859,803.02 and 817 awards for agency 069 inside HI coding. Those other series are unpublished here. Unique recipients are unpublished. Quote the dollar total and the award count together. Obligations are not outlays.

Why does this DOT file have 817 awards?

That is the award-record count for 069 × HI. Combined with $2,427,859,803.02, the average is about $2.97 million. Modifications and repeat instruments add rows. 817 is not unique lane-miles, unique contractors, or named Interstates. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Transportation in Hawaii is the overlay. Hawaii federal spending and Department of Transportation are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $2,427,859,803.02. USAspending.gov is the source. Obligations are not outlays.