← All datasets

# curated.transit_bus_route
METRO bus routes (127 rows; category: Transit & bikes; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 127/127 | e.g.: 118; 123; 8
- attrs->>'Color' | string | 127/5 | values: Blue; Green; ParkAndRide; Red; Orange
- attrs->>'created_da' | null | 68/33 | e.g.: 1681344000000; 1681257600000; 1449532800000
- attrs->>'created_us' | string | 127/7 | values:  ; JL83; sn01; km12; MB17; vw08; KM12
- attrs->>'Dest_1' | string | 127/43 | e.g.: Downtown; TMC TC; Downtown TC
- attrs->>'Dest_2' | string | 127/91 | e.g.: West Oaks Mall; Greenspoint TC; Hiram Clarke TC
- attrs->>'Dest_3' | string | 127/23 | e.g.:  ; Monroe PR; Westwood PR
- attrs->>'Id' | number | 127/2 | values: 0; 1
- attrs->>'last_edi_1' | number | 127/5 | values: 1681344000000; 1725840000000; 1686700800000; 1692316800000; 1681430400000
- attrs->>'last_edite' | string | 127/2 | values: JL83; MB17
- attrs->>'PageOrient' | string | 127/100 | e.g.: L; P; QZDoAKC8Zm
- attrs->>'RouteName' | string | 127/117 | e.g.: Northshore Express; W Little York; Richmond
- attrs->>'RouteNum' | number | 127/118 | e.g.: 82; 56; 60
- attrs->>'ServType' | string | 127/5 | values: Local; Park & Ride; Express; Shuttle; BRT
- attrs->>'Shape_STLe' | number | 127/127 | e.g.: 328269.472475; 59227.5184136; 338124.912319
- attrs->>'STATUS' | string | 127/2 | values: Active; Inactive
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.