← All datasets

# curated.streets_speed_limit
Posted speed limits by segment (9,361 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.: 8742; 3542; 247
- attrs->>'AVG_LANE_WIDTH' | number | 4938/2 | values: 12; 11
- attrs->>'BEGIN_' | string | 4963/2830 | e.g.: LOOP  ; SAM HOUSTON PKWY; BRAESWOOD BLVD
- attrs->>'CMD' | string | 4961/227 | e.g.: D ; E ; B 
- attrs->>'CREATED_DATE' | number | 5000/5000 | e.g.: 1437085531000; 1433815067000; 1431395087000
- attrs->>'CREATED_USER' | string | 5000/2 | values: Esri_Anonymous; E133407
- attrs->>'DEVICEID' | number | 1290/1029 | e.g.: 8358; 5876; 7822
- attrs->>'DIRECTION' | string | 4927/8 | values: North/South                           ; East/West                             ; South                                 ; North                                 ; East                                  ; West                                  ; NE/SW                                 ; NW/SE                                 
- attrs->>'END_' | null | 4959/2850 | e.g.: SAM HOUSTON PKWY; LOOP  ; T C JESTER BLVD
- attrs->>'LAST_EDITED_DATE' | number | 5000/4947 | e.g.: 1446176216000; 1446154892000; 1444963315000
- attrs->>'LAST_EDITED_USER' | string | 5000/3 | values: Esri_Anonymous; TOD; E133407
- attrs->>'LENGTH' | null | 4994/4920 | e.g.: 61.876616; 10562.372037; 248.97626
- attrs->>'LINKID' | string | 4989/4915 | e.g.: 451G0057-451G0056; 575V0027-575V0051; 338S0027-338R0006
- attrs->>'MEDIAN_TYPE' | null | 4998/4 | values: Raised; Undivided; TWLT; Depressed
- attrs->>'MEDIAN_WIDTH' | number | 4725/33 | e.g.: 12; 30; 0
- attrs->>'MM_CLASSIFICATION' | null | 4985/5 | values: Boulevard; Street; Avenue; Couplet; Local Street
- attrs->>'MTFP_CLASSIFICATION' | null | 4998/23 | e.g.: Thoroughfare; Principal Thoroughfare; Local
- attrs->>'NODE' | string | 1/1 | values: Railroad tracks
- attrs->>'NO_OF_LANES' | null | 4998/9 | values: 4; 2; 6; 3; 8; 5; 1; 7; 10
- attrs->>'POSTED_SPEED' | null | 4999/6 | values: 35; 40; 45; 50; 55; 30
- attrs->>'PROPOSED_SPEED' | null | 2/1 | values: 0
- attrs->>'REASON' | null | 74/1 | values: <Null>
- attrs->>'STATUS' | string | 4894/2 | values: Current; <Null>
- attrs->>'STREETNAME' | null | 4994/329 | e.g.: WAYSIDE DR; BELLFORT ST; TIDWELL RD
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.