← All datasets

# curated.streets_sidewalk
Sidewalk inventory (68,965 rows; category: Streets & traffic; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 15352; 13655; 62279
- attrs->>'AssetID' | number | 5000/5000 | e.g.: 6920; 12671; 149773
- attrs->>'Comments' | string | 5000/2 | values:  ; VEGETATION
- attrs->>'Condition' | string | 5000/6 | values: FAIR; GOOD; Good; POOR; Fair; Poor
- attrs->>'FacilityID' | string | 5000/5000 | e.g.: 6920; 12671; 149773
- attrs->>'Image' | string | 5000/4980 | e.g.: 160117_DTS6_6~F3919~C1_export.jpg; 160220_DTS4_3~F2879~C1_export.jpg; 160117_DTS6_7~F1326~C1_export.jpg
- attrs->>'RoadClass' | string | 5000/2 | values: LOCAL; MAJOR
- attrs->>'Street_Name' | string | 5000/2303 | e.g.: Richmond Ave; Martin Luther King Blvd; Yale St
- attrs->>'Width' | number | 5000/10 | values: 4; 3; 5; 6; 2; 8; 7; 10; 9; 1
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.