Back to fileView metadata
Schema
National Transit Map Routes / national-transit-map-routes / v1.0.0
Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.
Columns
18 columns
Features
68,994
Geometry
3D MultiLineString
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| ntd_id | string | No | 0 | — | — Range: —Length: 53 | Examples: 10055, 00008, 50066, 60048;60125, 70010 Values: — |
| feed_id | string | No | 0 | — | — Range: —Length: 55 | Examples: 10055_1, 00008_1, 50066_1, 60048;60125_1, 70010_1 Values: — |
| shape_id | string | No | 0 | — | — Range: —Length: 67 | Examples: 157682, 595557, 67100957, 931, 55824 Values: — |
| route_id | string | No | 0 | — | — Range: —Length: 108 | Examples: 15185, 190, 20, 803, 98 Values: — |
| agency_id | string | No | 0 | — | — Range: —Length: 42 | Examples: 2, TRIMET, , CM, 70010 Values: — |
| route_short_name | string | No | 0 | — | — Range: —Length: 33 | Examples: 212, , 20, 803, 98 Values: — |
| route_long_name | string | No | 0 | — | — Range: —Length: 92 | Examples: GRAND AVENUE, MAX Yellow Line, Madison, 803-Burnet/S Lamar, ANKENY EXPRESS Values: — |
| route_desc | string | No | 0 | — | — Range: —Length: 200 | Examples: , , , , Values: — |
| route_type | string | No | 0 | — | — Range: —Length: 2 | Examples: 3, 0, 3, 3, 3 Values: , 0, 1, 12, 2, 3, 4, 5, 6 |
| route_type_text | string | No | 0 | — | — Range: —Length: 28 | Examples: Bus, Tram, Streetcar, Light rail, Bus, Bus, Bus Values: , Bus, Cable car, Ferry, Gondola, Suspended cable car, Monorail, Rail, Subway, Metro, Tram, Streetcar, Light rail |
| route_url | string | No | 0 | — | — Range: —Length: 160 | Examples: , https://trimet.org/schedules/r190.htm, http://www.transitchicago.com/bus/20/, http://www.capmetro.org/current_schedules/pdf/803.pdf, Values: — |
| route_color | string | No | 0 | — | — Range: —Length: 6 | Examples: 000000, ffc52f, 99999c, 555555, 72cc85 Values: — |
| route_color_formatted | string | No | 0 | — | — Range: —Length: 15 | Examples: (0, 0, 0), (255, 197, 47), (153, 153, 156), (85, 85, 85), (114, 204, 133) Values: — |
| route_text_color | string | No | 0 | — | — Range: —Length: 6 | Examples: ffffff, 000000, ffffff, ffffff, ffffff Values: — |
| route_text_color_formatted | string | No | 0 | — | — Range: —Length: 15 | Examples: (255, 255, 255), (0, 0, 0), (255, 255, 255), (255, 255, 255), (255, 255, 255) Values: — |
| download_date | string | No | 0 | — | — Range: —Length: 10 | Examples: 2025-06-02, 2025-06-02, 2025-06-02, 2025-06-02, 2025-06-02 Values: 03-19-2025, 2025-06-02 |
| SHAPE_Length | float | No | 0 | — | — Range: 0.0003921734310035376 to 5.875687106666696Length: — | Examples: 0.06788437005438737, 0.0017068867629275314, 0.1545423266681644, 0.2399337915606949, 0.2729446946411199 Values: — |
Invalid geometry count: 0
Columns hash: c40759445e08bb751c765a16cc5bac57610a36ff1f91a3628dd3fce80b6f40c9