← 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.: 2585; 15352; 2275
- attrs->>'Angle' | number | 2491/266 | e.g.: 0; 90; 88
- attrs->>'Comments' | string | 273/48 | e.g.: Developed for HC PCT2 Partnership Opportunity; Developed for HC PCT 2 Grant Oppertunity; Privately Funded
- attrs->>'CouncilDistrict' | string | 4995/13 | e.g.: H; B; G
- attrs->>'CushionCount' | null | 1054/5 | values: 2; 3; 1; 4; 5
- attrs->>'DateInstalled' | string | 2966/228 | e.g.:  ; 10/12/2021; 02/08/2024
- attrs->>'DateRepaired' | null | 8/7 | values: 1644991200000; 1658210400000; 1657692000000; 1548655200000; 1680847200000; 1710482400000; 1488348000000
- attrs->>'DeviceStatus' | string | 4999/8 | values: Existing; Proposed; HCPCT4Partnership; HCPCT2Partnership; Remove/Replace; Not Qualified; Remove; Removed
- attrs->>'DeviceType' | null | 4998/11 | values: Speed Cushion; Speed Hump; Speed cushion; speed cushion; Speed CUshion; Speed Cuchion; Traffic Circle; Speed Control; Median; Speed Cushion ; Speed Cushiojn
- attrs->>'FACILITYID' | null | 3993/3990 | e.g.: 6796; 2834; 3093
- attrs->>'MATERIAL' | null | 4959/7 | values: Asphalt; Rubber; asphalt; Aspahlt; Asphalt ; Rubber ;  Asphalt
- attrs->>'Phase' | number | 470/6 | values: 2; 1; 3; 4; 5; 6
- attrs->>'ProjectID' | null | 4815/398 | e.g.:  ; 6521-15; 7337-23
- attrs->>'StreetName' | null | 4657/1883 | e.g.:  ; Bauman; Dewalt
- attrs->>'StreetNo' | null | 2786/1125 | e.g.:  ; 2515; 4011
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.