About this Dataset

Bridge Conditions, NYS Department Of Transportation

New York State inspectors assess all of the bridges every two years including a bridge’s individual parts. Bridges are analyzed for their capacity to carry vehicular loads. Inspectors are required to evaluate, assign a condition score, and document the condition of up to 47 structural elements, including rating 25 components of each span of a bridge, in addition to general components common to all bridges. The NYSDOT condition rating scale ranges from 1 to 7, with 7 being in new condition and a rating of 5 or greater considered as good conditionBridges that cannot safely carry heavy vehicles, such as some tractor trailers, are posted with weight limits. Based upon inspection and load capacity analysis, any bridge deemed unsafe gets closed.
Organization: State of New York
Last updated: 2020-11-12T04:00:37.468631
Tags: bridge, bridge-condition, structures

Tables

Table 1

@usgov.state_of_new_york_bridge_conditions_nys_department_of__ba67c366.table_1

680.02 kB
17,532 rows
11 columns

CREATE TABLE table_1 (
  "region" BIGINT,
  "county" VARCHAR,
  "municipality" VARCHAR,
  "bin" VARCHAR,
  "location" VARCHAR,
  "feature_carried" VARCHAR,
  "feature_crossed" VARCHAR,
  "owner" VARCHAR,
  "year_built_or_replaced" BIGINT,
  "date_of_last_inspection" TIMESTAMP,
  "poor_status" VARCHAR
);