Name: Bridge Ratings
Creator: US Government
License: https://www.usa.gov/government-works

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

92.79 kB
1,582 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  -- GENERAL RECOMMENDATION**,
  "current_rating" DOUBLE  -- Current Rating*,
  "verbal_rating" VARCHAR,
  "deck_area_sq_ft" BIGINT  -- DECK AREA (SQ FT),
  "replacement_cost" BIGINT,
  "x_coord_lat" DOUBLE  -- X - COORD (LAT),
  "y_coord_lon" DOUBLE  -- Y - COORD (LON),
  "cd" BIGINT,
  "cd2" DOUBLE,
  "cd3" DOUBLE
);