← 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.: 247; 3202; 5917
- attrs->>'AVG_LANE_WIDTH' | number | 4948/2 | values: 12; 11
- attrs->>'BEGIN_' | string | 4968/2858 | e.g.: LOOP  ; SAM HOUSTON PKWY; BELLFORT ST
- attrs->>'CMD' | string | 4971/224 | e.g.: D ; B ; H 
- attrs->>'CREATED_DATE' | number | 5000/5000 | e.g.: 1432244570000; 1433815067000; 1434165939000
- attrs->>'CREATED_USER' | string | 5000/2 | values: Esri_Anonymous; E133407
- attrs->>'DEVICEID' | number | 1242/992 | e.g.: 8358; 5876; 5360
- attrs->>'DIRECTION' | string | 4933/8 | values: North/South                           ; East/West                             ; South                                 ; North                                 ; West                                  ; East                                  ; NE/SW                                 ; NW/SE                                 
- attrs->>'END_' | null | 4961/2892 | e.g.: LOOP  ; SAM HOUSTON PKWY; T C JESTER BLVD
- attrs->>'LAST_EDITED_DATE' | number | 5000/4947 | e.g.: 1444963146000; 1446091231000; 1446176218000
- attrs->>'LAST_EDITED_USER' | string | 5000/3 | values: Esri_Anonymous; TOD; E133407
- attrs->>'LENGTH' | null | 4993/4918 | e.g.: 4226.804349; 4623.861853; 367.650088
- attrs->>'LINKID' | string | 4992/4918 | e.g.: 451Q0008-451V0016; 410Y0004-410S0002; 532V0012-532R0001
- attrs->>'MEDIAN_TYPE' | null | 4998/4 | values: Raised; Undivided; Depressed; TWLT
- attrs->>'MEDIAN_WIDTH' | number | 4702/31 | e.g.: 12; 30; 0
- attrs->>'MM_CLASSIFICATION' | string | 4985/5 | values: Boulevard; Street; Avenue; Couplet; Local Street
- attrs->>'MTFP_CLASSIFICATION' | null | 4998/22 | e.g.: Thoroughfare; Principal Thoroughfare; Local
- attrs->>'NODE' | null | 1/1 | values: Railroad tracks
- attrs->>'NO_OF_LANES' | number | 4998/9 | values: 4; 2; 6; 3; 8; 5; 1; 7; 10
- attrs->>'POSTED_SPEED' | null | 4999/6 | values: 35; 40; 45; 50; 30; 55
- attrs->>'REASON' | string | 71/1 | values: <Null>
- attrs->>'STATUS' | string | 4904/2 | values: Current; <Null>
- attrs->>'STREETNAME' | string | 4993/330 | e.g.: WAYSIDE DR; GESSNER RD; TIDWELL RD
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.