← All datasets

# curated.streets_traffic_signal
Traffic signals (2,495 rows; category: Streets & traffic; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 2495/2495 | e.g.: 1593; 247; 121
- attrs->>'alias1' | string | 2495/63 | e.g.:  ; W Belt; Katy Fw
- attrs->>'alias2' | string | 2495/41 | e.g.:  ; HAWK; W Belt
- attrs->>'alias3' | string | 2495/8 | values:  ; ped crossing; 400' south of S. Klein Cir; Bellows; intersection flasher; curve warning; HOV Entrance; speed limit flasher
- attrs->>'APS' | string | 2495/2 | values: FALSE; TRUE
- attrs->>'asset_id' | string | 2495/2495 | e.g.: 2571; 2585; 1521
- attrs->>'cabinet_mo' | string | 2495/67 | e.g.: 332; ITS340; P
- attrs->>'cbd' | string | 2495/2 | values: FALSE; TRUE
- attrs->>'cdma' | string | 2495/2 | values: FALSE; TRUE
- attrs->>'controller' | string | 2495/23 | e.g.: 2070L; 2070LN; 2070
- attrs->>'council_id' | string | 2495/11 | values: I; G; C; D; A; H; B;  ; E; F; c
- attrs->>'create_dat' | number | 382/200 | e.g.: 1041573600000; 1045029600000; 1077256800000
- attrs->>'csr_block' | number | 2495/565 | e.g.: 1000; 600; 700
- attrs->>'csr_street' | string | 2495/779 | e.g.: Fannin; Bissonnet; Bellaire Bl
- attrs->>'directio_1' | string | 2495/5 | values:  ; N; W; S; E
- attrs->>'direction_' | string | 2495/55 | e.g.:  ; W; S
- attrs->>'direction1' | string | 2495/9 | values:  ; S; N; W; E; Dr; Rd; St; N.
- attrs->>'fiber' | string | 2495/2 | values: FALSE; TRUE
- attrs->>'first_stre' | string | 2495/539 | e.g.: I-610; Sam Houston; I-45
- attrs->>'HW_Interco' | string | 2495/2 | values: FALSE; TRUE
- attrs->>'icon_id' | number | 2495/2275 | e.g.: 1914; 2900; 1457
- attrs->>'In_CompleteCommunity' | string | 325/10 | values: Alief - Westwood; Third Ward; Near Northside; Acres Home; Gulfton; Magnolia Park - Manchester; Sunnyside; Second Ward; Kashmere Gardens; Fort Bend Houston
- attrs->>'inside_bel' | string | 2495/2 | values: TRUE; FALSE
- attrs->>'inside_loo' | string | 2495/2 | values: FALSE; TRUE
- attrs->>'interconne' | string | 2495/708 | e.g.:  ; 16022S; 10634S
- attrs->>'intersecti' | number | 2495/2217 | e.g.: 0; 16393; 15535
- attrs->>'keymap_are' | number | 2495/5 | values: 2; 3; 4; 1; 0
- attrs->>'keymap_blo' | string | 2495/27 | e.g.: Q; R; U
- attrs->>'keymap_pag' | number | 2495/67 | e.g.: 493; 492; 491
- attrs->>'Latitude' | number | 2495/2453 | e.g.: 29.93954353; 29.68901708; 29.81667837
- attrs->>'Longitude' | number | 2495/2453 | e.g.: -95.33171665; -95.46306951; -95.22865016
- attrs->>'map_zip' | number | 2495/100 | e.g.: 77002; 0; 77004
- attrs->>'master_con' | string | 2495/61 | e.g.:  ; 10033; 10067
- attrs->>'Meter_Addr' | string | 2495/284 | e.g.:  ; 7891 1/2 Katy Frwy; 1320 1/2
- attrs->>'Meter_Numb' | string | 2495/276 | e.g.:  ; 65594768; 1NI06633604210132
- attrs->>'Meter_Type' | string | 2495/1 | values:  
- attrs->>'Metro_Ligh' | string | 2495/2 | values: FALSE; TRUE
- attrs->>'operates_a' | string | 2495/5 | values: Intersection Control; Fire Station; RLCD; Flasher; Pedestrian Hybrid Beacon
- attrs->>'second_str' | string | 2495/635 | e.g.: Westheimer;  ; Main
- attrs->>'station' | string | 2495/14 | e.g.:  ; NSR; SSR
- attrs->>'status' | string | 2495/2 | values: Exists; Removed
- attrs->>'streetty_1' | string | 2495/13 | e.g.:  ; Dr; Rd
- attrs->>'streetty_2' | string | 2495/8 | values:  ; Blvd; Dr; Rd; Ln; Blvd.; Place; Pkwy
- attrs->>'streettype' | string | 2495/13 | e.g.:  ; Dr; Rd
- attrs->>'third_stre' | string | 2495/130 | e.g.:  ; Park Place; Victory
- attrs->>'turnon_dat' | null | 68/46 | e.g.: 1076652000000; 953359200000; 930204000000
- attrs->>'UPS' | string | 2495/2 | values: FALSE; TRUE
- attrs->>'WiMax' | string | 2495/2 | values: FALSE; TRUE
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.