ECAT - Externality Cost Estimates

ECAT - Externality Cost Estimates are the estimated costs of highway use externalities including noise, air pollution, crashes, and congestion, broken into various degrees of specificity. For each category of externality the estimates include both the total annual cost (in millions) as well as dollars per vehicle mile traveled, and can be filtered by state, highway functional system, vehicle type, urban and rural. Additionally, every figure has a low, mid, and high estimate that embodies the uncertainty in the parameters and methodology used to construct the estimates. These estimates are useful for any analysis involving the value of negative externalities of highway use, such as benefit-cost analysis or impact analysis of highway projects.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"datahub-transportation-gov/ecat-externality-cost-estimates-cjw6-nz52\".\"ecat_externality_cost_estimates\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.