Bridge Ratings by US Government | Demographics and Population Studies

About this Dataset

Bridge Ratings

New York City bridge structure conditions and ratings.
Organization: City of New York
Last updated: 2020-11-10T17:00:44.397874
Tags: bridge, new-york, rating, type

Tables

Table 1

@usgov.city_of_new_york_bridge_ratings.table_1

90.62 KB
1582 rows
20 columns


CREATE TABLE table_1 (
  "bin" VARCHAR,
  "boro" VARCHAR,
  "feature_carried" VARCHAR,
  "feature_crossed" VARCHAR,
  "rail_road" VARCHAR,
  "bridge_type" VARCHAR,
  "other_owner" VARCHAR,
  "spans" BIGINT,
  "rating_source" VARCHAR,
  "inspection_date" TIMESTAMP,
  "general_recommendation" BIGINT,
  "current_rating" DOUBLE,
  "verbal_rating" VARCHAR,
  "deck_area_sq_ft" BIGINT,
  "replacement_cost" BIGINT,
  "x_coord_lat" DOUBLE,
  "y_coord_lon" DOUBLE,
  "cd" BIGINT,
  "cd2" DOUBLE,
  "cd3" DOUBLE
);