Name: Street Pavement Rating
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Street Pavement Rating

The Agency performs ongoing assessment of New York City streets. Ratings are based on a scale from 1 to 10, and results are grouped in the following categories:

Good (%) - ratings of 8 to 10
Fair (%) - ratings of 4 to 7 (except on local streets where a 7 is good)
Poor (%) - ratings of 1 to 3.
Inspectors rate street conditions throughout the five boroughs using the scale above.
Organization: City of New York
Last updated: 2022-11-11T08:42:04.360946
Tags: fair, good, pavement, poor, rating, street

Tables

Table 1

@usgov.city_of_new_york_street_pavement_rating_b6ef4.table_1

22.24 MB
132,535 rows
12 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "segmentid" BIGINT,
  "boroughcod" VARCHAR,
  "oftcode" VARCHAR,
  "onstreetna" VARCHAR,
  "fromstreet" VARCHAR,
  "tostreetna" VARCHAR,
  "wkt" VARCHAR,
  "manualrati" BIGINT,
  "ratinglaye" VARCHAR,
  "inspection" VARCHAR,
  "shape_stle" DOUBLE
);