About this Dataset

2018 Pavement Section Report

Additional pavement information drilled down from the street branch report. This includes pavement section data such as street surface type, functional classification, true area (in both feet and yards), length (in both feet and miles) and the section's Pavement Condition Index (PCI) rating. Please see the Bloomington project summary document for more detailed information regarding the PCI ratings.
Organization: City of Bloomington
Last updated: 2023-05-20T03:46:31.410908

Tables

Table 1

@usgov.city_of_bloomington_2018_pavement_section_report_fc5b9.table_1

125.28 kB
2,844 rows
12 columns

CREATE TABLE table_1 (
  "branch_id" VARCHAR,
  "name" VARCHAR,
  "section_id" VARCHAR,
  "from" VARCHAR,
  "to" VARCHAR,
  "surface_type" VARCHAR,
  "functional_class" VARCHAR,
  "true_area_ft2" BIGINT  -- True Area (Ft2),
  "true_area_yd2" DOUBLE  -- True Area (Yd2),
  "length_ft" DOUBLE  -- Length (Ft),
  "length_mi" DOUBLE  -- Length (Mi),
  "pci" BIGINT
);