Name: Streets Data - Pavement Condition Index (PCI) Scores
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Streets Data - Pavement Condition Index (PCI) Scores

Pavement Condition Index (PCI) Scores by location.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:11.526093
Tags: condition, index, paving, pci, score, streets

Tables

Table 1

@usgov.city_of_san_francisco_streets_pavement_condition_index_397c84cf.table_1

2.13 MB
19314 rows
20 columns


CREATE TABLE table_1 (
  "cnn" BIGINT,
  "street_name" VARCHAR,
  "pci_score" BIGINT,
  "from_street" VARCHAR,
  "to_street" VARCHAR,
  "pci_change_date" TIMESTAMP,
  "treatment_or_survey" VARCHAR,
  "street_accepted_for_maintenance" VARCHAR,
  "functional_class" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "line" VARCHAR,
  "point" VARCHAR,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE
);