# US Bridge Condition & Scour Risk Monitor — FHWA NBI (`malonestar/fhwa-nbi-bridge-risk-monitor`) Actor

Screen 620,000+ US bridges from the FHWA National Bridge Inventory by state, condition (Poor/Fair/Good) and scour-critical status. Composite 0-100 risk score from condition, scour, overdue inspections, and traffic. For engineers, insurers, infrastructure investors, and journalists.

- **URL**: https://apify.com/malonestar/fhwa-nbi-bridge-risk-monitor.md
- **Developed by:** [Kyle Maloney](https://apify.com/malonestar) (community)
- **Categories:** Agents, Developer tools, Lead generation
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

from $4.40 / 1,000 results

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.
Since this Actor supports Apify Store discounts, the price gets lower the higher subscription plan you have.

Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event

## What's an Apify Actor?

Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.
Actors are written with capital "A".

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.
The best way to integrate Actors is as follows.

In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js/docs.md):

```bash
npm install apify-client
```

In Python projects, use official [Python client library](https://docs.apify.com/api/client/python/docs.md):

```bash
pip install apify-client
```

In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md):

````bash
# MacOS / Linux
curl -fsSL https://apify.com/install-cli.sh | bash
# Windows
irm https://apify.com/install-cli.ps1 | iex
```bash

In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/integrations/mcp.md).

If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md).

For usage examples, see the [API](#api) section below.

For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).


# README

## US Bridge Condition & Scour Risk Monitor — FHWA NBI

Screen the **FHWA National Bridge Inventory (NBI)** — 620,000+ US highway bridges —
by state, overall condition (**Poor / Fair / Good**), and **scour-critical** status,
and get back a normalized record per bridge with a **composite 0–100 risk score**.

Data comes straight from the official **NTAD (National Transportation Atlas
Database) ArcGIS service** published by the US DOT — no API key, no scraping
fragile HTML. Over **41,000 US bridges are currently rated in Poor condition**;
this actor finds them, ranks them, and flags why.

### What the risk score adds (the transform)

Raw NBI dumps give you 100+ cryptic coded columns. This actor turns each bridge
into a decision-ready row:

- **`risk_score` (0–100)** = condition weight (Poor ≫ Fair ≫ Good) ×
  scour-critical factor (item 113 codes 0–3 boost) × inspection-overdue factor
  (months since last inspection vs. the designated interval) × log-scaled
  traffic exposure (ADT). Higher = riskier. The worst possible combination
  (Poor + scour failure + 2× past inspection + 100k ADT) scores 100.
- **`risk_flags[]`** — machine-readable: `poor_condition`, `scour_critical`,
  `inspection_overdue`, `posted_or_closed`, `closed`, `fracture_critical`,
  `high_traffic_poor`, `scour_unknown`, `no_inspection_on_record`.
- **Decoded fields** — condition letters → labels, owner code → agency name,
  MMYY inspection dates → ISO `YYYY-MM`, state FIPS → postal code.

### Who uses this

- **Bridge engineering & inspection firms** — build target lists of Poor /
  scour-critical / overdue bridges by state or county for business development.
- **Infrastructure investors & muni-bond analysts** — screen the bridge stock
  behind an issuer or geography before pricing risk.
- **P&C and infrastructure insurers** — exposure screening around portfolios.
- **DOT contractors** — find rehab candidates before RFPs drop.
- **Journalists & researchers** — "how many Poor, load-posted, high-traffic
  bridges are in my state?" answered in one run.

### Example input

```json
{
  "states": ["CO"],
  "conditions": ["P"],
  "scourCriticalOnly": false,
  "minADT": 1000,
  "minRiskScore": 25,
  "maxResults": 500
}
````

States accept postal codes (`"CO"`), full names (`"Colorado"`), or FIPS
(`"08"`). Leave `states` and `conditions` empty to scan the national inventory
(bounded by `maxResults`). Empty input never fails — it runs a bounded default.

### Output fields

One record per bridge: `structure_number`, `state`, `state_fips`,
`county_code`, `facility_carried`, `features_desc`, `location`, `condition`,
`condition_code`, `deck_cond`, `superstructure_cond`, `substructure_cond`,
`culvert_cond`, `lowest_rating`, `scour_critical`, `scour_critical_flag`,
`last_inspection_date` (ISO `YYYY-MM`), `months_since_inspection`,
`inspection_frequency_months`, `inspection_overdue`, `adt`, `adt_year`,
`year_built`, `owner_code`, `owner`, `open_closed_posted_code`,
`posted_or_closed`, `fracture_critical`, `risk_score`, `risk_flags`, `lat`,
`lon`, `source_url`.

### Use as an MCP tool

This actor is callable by AI agents (Claude, Cursor, etc.) via
**mcp.apify.com** — the input and output schemas are fully described at field
level, so an agent can ask for "scour-critical Poor bridges in Texas over
10,000 ADT" and chain the scored rows into reports, maps, or alerts.

### FAQ

**How many bridges are in poor condition in the US?**
41,000+ structures carry an overall FHWA condition rating of Poor. Run this
actor with `"conditions": ["P"]` and no state filter for the national list.

**What does scour critical mean for a bridge?**
Scour — streambed erosion around foundations — is the leading cause of US
bridge failures. NBI item 113 codes 0–3 mean the foundations are rated
unstable or have failed; set `"scourCriticalOnly": true` to get only those.

**How do I find bridges with overdue inspections?**
Every row includes `inspection_overdue`, comparing months since the last
routine inspection (item 90) against the designated interval (item 91).
Filter the dataset on that flag or set `minRiskScore` to surface the worst.

**Where does the data come from and how fresh is it?**
The US DOT NTAD National Bridge Inventory ArcGIS service — the official
annual FHWA NBI submission published by the Bureau of Transportation
Statistics. It is keyless, public, and updated on FHWA's release cycle.

**Is this a load rating or engineering assessment?**
No. The risk score is a screening heuristic over official FHWA data —
prioritize with it, then verify against the underlying record (`source_url`
returns the full raw NBI row for each bridge).

### Pricing

Pay per result: each returned bridge record is one billable event. Empty
result sets cost only the actor start. Use `maxResults`, state, and condition
filters to keep runs exactly as large as you need.

# Actor input Schema

## `states` (type: `array`):

US states to scan. Accepts postal codes ('CO'), full names ('Colorado'), or 2-digit FIPS codes ('08'). Leave empty to scan the national inventory (bounded by Max results).

## `conditions` (type: `array`):

FHWA overall bridge condition ratings to include: 'P' = Poor, 'F' = Fair, 'G' = Good (words like 'Poor' also work). Leave empty to include all conditions.

## `scourCriticalOnly` (type: `boolean`):

If true, only return scour-critical bridges (NBI item 113 codes 0-3: foundations rated unstable or failed for calculated scour).

## `minADT` (type: `integer`):

Only include bridges carrying at least this average daily traffic (filters server-side on ADT\_029). Leave empty for no traffic floor.

## `minRiskScore` (type: `integer`):

Only output bridges whose composite risk score (0-100) is at or above this value. Applied client-side after scoring.

## `maxResults` (type: `integer`):

Maximum number of bridges to return — a safety bound for cost control. Each returned bridge is one billable result.

## Actor input object example

```json
{
  "states": [
    "CO"
  ],
  "conditions": [
    "P"
  ],
  "scourCriticalOnly": false,
  "maxResults": 500
}
```

# Actor output Schema

## `results` (type: `string`):

The default dataset of scored bridge records.

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {
    "states": [
        "CO"
    ],
    "conditions": [
        "P"
    ],
    "maxResults": 500
};

// Run the Actor and wait for it to finish
const run = await client.actor("malonestar/fhwa-nbi-bridge-risk-monitor").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {
    "states": ["CO"],
    "conditions": ["P"],
    "maxResults": 500,
}

# Run the Actor and wait for it to finish
run = client.actor("malonestar/fhwa-nbi-bridge-risk-monitor").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{
  "states": [
    "CO"
  ],
  "conditions": [
    "P"
  ],
  "maxResults": 500
}' |
apify call malonestar/fhwa-nbi-bridge-risk-monitor --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "command": "npx",
            "args": [
                "mcp-remote",
                "https://mcp.apify.com/?tools=malonestar/fhwa-nbi-bridge-risk-monitor",
                "--header",
                "Authorization: Bearer <YOUR_API_TOKEN>"
            ]
        }
    }
}

```

## OpenAPI specification

```json
{
    "openapi": "3.0.1",
    "info": {
        "title": "US Bridge Condition & Scour Risk Monitor — FHWA NBI",
        "description": "Screen 620,000+ US bridges from the FHWA National Bridge Inventory by state, condition (Poor/Fair/Good) and scour-critical status. Composite 0-100 risk score from condition, scour, overdue inspections, and traffic. For engineers, insurers, infrastructure investors, and journalists.",
        "version": "1.0",
        "x-build-id": "6XwIpzF5ijhfhTlr9"
    },
    "servers": [
        {
            "url": "https://api.apify.com/v2"
        }
    ],
    "paths": {
        "/acts/malonestar~fhwa-nbi-bridge-risk-monitor/run-sync-get-dataset-items": {
            "post": {
                "operationId": "run-sync-get-dataset-items-malonestar-fhwa-nbi-bridge-risk-monitor",
                "x-openai-isConsequential": false,
                "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.",
                "tags": [
                    "Run Actor"
                ],
                "requestBody": {
                    "required": true,
                    "content": {
                        "application/json": {
                            "schema": {
                                "$ref": "#/components/schemas/inputSchema"
                            }
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "token",
                        "in": "query",
                        "required": true,
                        "schema": {
                            "type": "string"
                        },
                        "description": "Enter your Apify token here"
                    }
                ],
                "responses": {
                    "200": {
                        "description": "OK"
                    }
                }
            }
        },
        "/acts/malonestar~fhwa-nbi-bridge-risk-monitor/runs": {
            "post": {
                "operationId": "runs-sync-malonestar-fhwa-nbi-bridge-risk-monitor",
                "x-openai-isConsequential": false,
                "summary": "Executes an Actor and returns information about the initiated run in response.",
                "tags": [
                    "Run Actor"
                ],
                "requestBody": {
                    "required": true,
                    "content": {
                        "application/json": {
                            "schema": {
                                "$ref": "#/components/schemas/inputSchema"
                            }
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "token",
                        "in": "query",
                        "required": true,
                        "schema": {
                            "type": "string"
                        },
                        "description": "Enter your Apify token here"
                    }
                ],
                "responses": {
                    "200": {
                        "description": "OK",
                        "content": {
                            "application/json": {
                                "schema": {
                                    "$ref": "#/components/schemas/runsResponseSchema"
                                }
                            }
                        }
                    }
                }
            }
        },
        "/acts/malonestar~fhwa-nbi-bridge-risk-monitor/run-sync": {
            "post": {
                "operationId": "run-sync-malonestar-fhwa-nbi-bridge-risk-monitor",
                "x-openai-isConsequential": false,
                "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.",
                "tags": [
                    "Run Actor"
                ],
                "requestBody": {
                    "required": true,
                    "content": {
                        "application/json": {
                            "schema": {
                                "$ref": "#/components/schemas/inputSchema"
                            }
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "token",
                        "in": "query",
                        "required": true,
                        "schema": {
                            "type": "string"
                        },
                        "description": "Enter your Apify token here"
                    }
                ],
                "responses": {
                    "200": {
                        "description": "OK"
                    }
                }
            }
        }
    },
    "components": {
        "schemas": {
            "inputSchema": {
                "type": "object",
                "properties": {
                    "states": {
                        "title": "States",
                        "type": "array",
                        "description": "US states to scan. Accepts postal codes ('CO'), full names ('Colorado'), or 2-digit FIPS codes ('08'). Leave empty to scan the national inventory (bounded by Max results).",
                        "items": {
                            "type": "string"
                        }
                    },
                    "conditions": {
                        "title": "Bridge conditions",
                        "type": "array",
                        "description": "FHWA overall bridge condition ratings to include: 'P' = Poor, 'F' = Fair, 'G' = Good (words like 'Poor' also work). Leave empty to include all conditions.",
                        "items": {
                            "type": "string"
                        }
                    },
                    "scourCriticalOnly": {
                        "title": "Scour-critical only",
                        "type": "boolean",
                        "description": "If true, only return scour-critical bridges (NBI item 113 codes 0-3: foundations rated unstable or failed for calculated scour).",
                        "default": false
                    },
                    "minADT": {
                        "title": "Minimum daily traffic (ADT)",
                        "minimum": 0,
                        "type": "integer",
                        "description": "Only include bridges carrying at least this average daily traffic (filters server-side on ADT_029). Leave empty for no traffic floor."
                    },
                    "minRiskScore": {
                        "title": "Minimum risk score",
                        "minimum": 0,
                        "maximum": 100,
                        "type": "integer",
                        "description": "Only output bridges whose composite risk score (0-100) is at or above this value. Applied client-side after scoring."
                    },
                    "maxResults": {
                        "title": "Max results",
                        "minimum": 1,
                        "maximum": 50000,
                        "type": "integer",
                        "description": "Maximum number of bridges to return — a safety bound for cost control. Each returned bridge is one billable result.",
                        "default": 500
                    }
                }
            },
            "runsResponseSchema": {
                "type": "object",
                "properties": {
                    "data": {
                        "type": "object",
                        "properties": {
                            "id": {
                                "type": "string"
                            },
                            "actId": {
                                "type": "string"
                            },
                            "userId": {
                                "type": "string"
                            },
                            "startedAt": {
                                "type": "string",
                                "format": "date-time",
                                "example": "2025-01-08T00:00:00.000Z"
                            },
                            "finishedAt": {
                                "type": "string",
                                "format": "date-time",
                                "example": "2025-01-08T00:00:00.000Z"
                            },
                            "status": {
                                "type": "string",
                                "example": "READY"
                            },
                            "meta": {
                                "type": "object",
                                "properties": {
                                    "origin": {
                                        "type": "string",
                                        "example": "API"
                                    },
                                    "userAgent": {
                                        "type": "string"
                                    }
                                }
                            },
                            "stats": {
                                "type": "object",
                                "properties": {
                                    "inputBodyLen": {
                                        "type": "integer",
                                        "example": 2000
                                    },
                                    "rebootCount": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "restartCount": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "resurrectCount": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "computeUnits": {
                                        "type": "integer",
                                        "example": 0
                                    }
                                }
                            },
                            "options": {
                                "type": "object",
                                "properties": {
                                    "build": {
                                        "type": "string",
                                        "example": "latest"
                                    },
                                    "timeoutSecs": {
                                        "type": "integer",
                                        "example": 300
                                    },
                                    "memoryMbytes": {
                                        "type": "integer",
                                        "example": 1024
                                    },
                                    "diskMbytes": {
                                        "type": "integer",
                                        "example": 2048
                                    }
                                }
                            },
                            "buildId": {
                                "type": "string"
                            },
                            "defaultKeyValueStoreId": {
                                "type": "string"
                            },
                            "defaultDatasetId": {
                                "type": "string"
                            },
                            "defaultRequestQueueId": {
                                "type": "string"
                            },
                            "buildNumber": {
                                "type": "string",
                                "example": "1.0.0"
                            },
                            "containerUrl": {
                                "type": "string"
                            },
                            "usage": {
                                "type": "object",
                                "properties": {
                                    "ACTOR_COMPUTE_UNITS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_WRITES": {
                                        "type": "integer",
                                        "example": 1
                                    },
                                    "KEY_VALUE_STORE_LISTS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_INTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_EXTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_SERPS": {
                                        "type": "integer",
                                        "example": 0
                                    }
                                }
                            },
                            "usageTotalUsd": {
                                "type": "number",
                                "example": 0.00005
                            },
                            "usageUsd": {
                                "type": "object",
                                "properties": {
                                    "ACTOR_COMPUTE_UNITS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_WRITES": {
                                        "type": "number",
                                        "example": 0.00005
                                    },
                                    "KEY_VALUE_STORE_LISTS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_INTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_EXTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_SERPS": {
                                        "type": "integer",
                                        "example": 0
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}
```