← All datasets

# curated.streets_pavement_rating
Pavement Condition Index (PCI 0-100) for 75k street segments (75,758 rows; category: Streets & traffic; geometry column `geom` (MultiLineString, EPSG:4326))
Notes: attrs->>'PCI' (0 = unrated/failed, 100 = perfect), attrs->>'FUNCTIONAL' road class, attrs->>'SectionLen' feet.
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 16692; 58487; 21849
- attrs->>'BegLocatio' | string | 5000/3285 | e.g.: Cul-De-Sac; High Star Dr; Crawford St
- attrs->>'EndLocatio' | string | 5000/3137 | e.g.: Cul-De-Sac; END; W Bellfort St
- attrs->>'FUNCTIONAL' | string | 5000/2 | values: R - Residential/Local; MaC - Major Collector (5)
- attrs->>'Lanes' | number | 5000/7 | values: 2; 4; 3; 6; 5; 7; 8
- attrs->>'PCI' | number | 5000/97 | e.g.: 77; 0; 75
- attrs->>'PCIDate' | null | 4818/355 | e.g.: 1675900800000; 1657497600000; 1675641600000
- attrs->>'RoadName' | string | 5000/2290 | e.g.: MEMORIAL DR; RICHMOND AVE; W BELLFORT ST
- attrs->>'RoadNumber' | string | 5000/2300 | e.g.: 0235; 0299; 0373
- attrs->>'SectionAre' | number | 5000/4987 | e.g.: 17331.35; 5609.91; 5769.72
- attrs->>'SectionID' | string | 5000/5000 | e.g.: 10080122; 10088205; 10145658
- attrs->>'SectionLen' | number | 5000/4762 | e.g.: 361.41; 317.7; 297.54
- attrs->>'SectionWid' | number | 5000/57 | e.g.: 24; 26; 25
- attrs->>'STREETNAME' | string | 5000/2300 | e.g.: MEMORIAL DR - 0235; RICHMOND AVE - 0299; W BELLFORT ST - 0373
- attrs->>'StreetSect' | string | 5000/5000 | e.g.:  ASHFORDCHA - 10012523;  RANDONRD - 10080930;  CROWNST - 10099226
- attrs->>'SURFACETYP' | string | 5000/3 | values: P - PCC; A - AC; G - GRAVEL
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.