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

About this Dataset

Streets Data -Historical Pavement Condition Index (PCI) Scores

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

Tables

Table 1

@usgov.city_of_san_francisco_streets_historical_pavement_cond_4a6adda0.table_1

14.66 MB
293986 rows
20 columns


CREATE TABLE table_1 (
  "cnn" BIGINT,
  "street_name" VARCHAR,
  "from_street" VARCHAR,
  "to_street" VARCHAR,
  "pci_score" BIGINT,
  "pci_change_date" VARCHAR,
  "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
);