← All datasets

# curated.streets_traffic_calming_device
Neighborhood traffic calming devices (speed humps etc.) (8,431 rows; category: Streets & traffic; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 18589; 3542; 3226
- attrs->>'Angle' | number | 2468/277 | e.g.: 0; 90; 88
- attrs->>'Comments' | string | 276/53 | e.g.: Developed for HC PCT2 Partnership Opportunity; Privately Funded; Developed for HC PCT 2 Grant Oppertunity
- attrs->>'CouncilDistrict' | string | 4995/13 | e.g.: H; G; B
- attrs->>'CushionCount' | null | 1087/5 | values: 3; 2; 1; 4; 5
- attrs->>'DateInstalled' | string | 2944/229 | e.g.:  ; 02/08/2024; 09/13/2022
- attrs->>'DateRepaired' | null | 8/7 | values: 1657000800000; 1658210400000; 1657692000000; 1644991200000; 1680847200000; 1488348000000; 1548655200000
- attrs->>'DeviceStatus' | string | 4999/8 | values: Existing; Proposed; HCPCT4Partnership; HCPCT2Partnership; Remove/Replace; Not Qualified; Remove; Removed
- attrs->>'DeviceType' | null | 4999/11 | values: Speed Cushion; Speed Hump; Speed cushion; speed cushion; Speed CUshion; Speed Cuchion; Speed Cushion ; Speed Control; Traffic Circle; Median; Median Island
- attrs->>'FACILITYID' | null | 3969/3967 | e.g.: 6796; 5144; 3226
- attrs->>'MATERIAL' | null | 4954/9 | values: Asphalt; Rubber; asphalt; Aspahlt; Asphalt ; Ashalt; Aaphalt; Concrete;  Asphalt
- attrs->>'Phase' | number | 470/6 | values: 1; 2; 3; 4; 6; 5
- attrs->>'ProjectID' | null | 4819/402 | e.g.:  ; 7337-23; 7128-21
- attrs->>'StreetName' | null | 4649/1873 | e.g.:  ; Cochran; Wycliffe
- attrs->>'StreetNo' | null | 2762/1116 | e.g.:  ; 12107; 6718
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.