← 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.: 12533; 36112; 59672
- attrs->>'AssetID' | number | 5000/5000 | e.g.: 106383; 140554; 135084
- 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.: 106383; 140554; 135084
- attrs->>'Image' | string | 5000/4969 | e.g.: 160112_DTS5_1~F2500~C1_export.jpg; 160112_DTS5_1~F755~C1_export.jpg; 160201_DTS5_1~F1306~C1_export.jpg
- attrs->>'RoadClass' | string | 5000/2 | values: LOCAL; MAJOR
- attrs->>'Street_Name' | string | 5000/1909 | e.g.: Richmond Ave; Main St; Dairy Ashford Rd
- attrs->>'Width' | number | 5000/8 | values: 4; 3; 5; 6; 2; 8; 7; 10
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.