About this Dataset

Sidewalk Condition Assessment

The data includes the five condition categories, excellent, good, fair, poor and failed. The data reflects a sidewalk condition index score ranging from 0 to 11. The higher the value, the better the sidewalk condition. The data also includes the primary and secondary material type of the sidewalk. It also entails the 8 most common conditions and the value expressed numerically.
Organization: District of Columbia
Last updated: 2024-08-06T19:39:37.222838
Tags: dc, ddot, district-of-columbia, sidewalk-condition, sidewalks, washington-dc

Tables

Table 1

@usgov.district_of_columbia_sidewalk_condition_assessment.table_1

5.89 MB
68,611 rows
13 columns

CREATE TABLE table_1 (
  "id" VARCHAR,
  "ward" BIGINT,
  "primarymaterial" VARCHAR,
  "secondmaterial" VARCHAR,
  "sci" BIGINT,
  "sci_category" VARCHAR,
  "maintenancepriority" VARCHAR,
  "gis_id" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "globalid" VARCHAR,
  "objectid" BIGINT,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);