Back to fileView metadata
Schema
Intermodal Passenger Connectivity Database (IPCD) / intermodal-passenger-connectivity-database-ipcd / v1.0.0
Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.
Columns
53 columns
Features
15,488
Geometry
Point
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| X | float | No | 0 | — | — Range: -176.64603 to -66.98504Length: — | Examples: -87.7636, -76.6522, -73.9766, -74.9585, -74.16489 Values: — |
| Y | float | No | 0 | — | — Range: 19.72026 to 71.28545Length: — | Examples: 41.97114, 39.3684, 40.7883, 40.0393, 40.73428 Values: — |
| FAC_ID | string | No | 0 | — | — Range: —Length: 10 | Examples: IL6063003, MD2120902, NY1002401, NJ0807502, NJ0710201 Values: — |
| POINT_ID | integer | No | 0 | — | — Range: 1 to 4300Length: — | Examples: 158, 3106, 4200, 3995, 261 Values: — |
| NEAR_ID_1 | float | Yes | 4,556 | — | — Range: 9 to 19038Length: — | Examples: 4131.0, 2313.0, 351.0, 4647.0, 195.0 Values: — |
| NEAR_ID_2 | float | Yes | 4,942 | — | — Range: 68 to 18397Length: — | Examples: 7509.0, 8338.0, 7723.0, 17682.0, 17147.0 Values: — |
| NEAR_ID_3 | float | Yes | 4,989 | — | — Range: 4130 to 8683Length: — | Examples: 4130.0, 7732.0, 8359.0, 8683.0, 4132.0 Values: — |
| AIR_CODE | string | Yes | 4,467 | — | — Range: —Length: 3 | Examples: CLE, IPL, GSO, MLS, JLN Values: — |
| AIR_CODE2 | string | Yes | 4,928 | — | — Range: —Length: 4 | Examples: 16A, 6R7, 51Z, AK81, AK5 Values: — |
| AMTRAKCODE | string | Yes | 4,331 | — | — Range: —Length: 3 | Examples: DUL, RVM, BUR, BAT, EMY Values: — |
| FERRY_CODE | string | Yes | 4,811 | — | — Range: —Length: 3 | Examples: 180, 81, 294, 147, 274 Values: — |
| RAIL_ID | string | Yes | 3,880 | — | — Range: —Length: 4 | Examples: 1090, 2483, 387, 1483, 94 Values: — |
| BIKE_ID | string | Yes | 4,404 | — | — Range: —Length: 27 | Examples: B32035, 84, hub_2118, 124, bcycle_greenbikeslc_3181 Values: — |
| DATE_UPDTE | string | No | 0 | — | — Range: —Length: 25 | Examples: 2016-04-16T00:00:00+00:00, 2016-04-16T00:00:00+00:00, 2016-04-16T00:00:00+00:00, 2016-04-16T00:00:00+00:00, 2016-04-16T00:00:00+00:00 Values: 2016-04-16T00:00:00+00:00, 2016-05-30T00:00:00+00:00, 2016-07-05T00:00:00+00:00, 2016-08-17T00:00:00+00:00, 2016-09-14T00:00:00+00:00, 2016-09-16T00:00:00+00:00, 2016-09-18T00:00:00+00:00, 2016-09-19T00:00:00+00:00, 2016-09-20T00:00:00+00:00, 2016-10-04T00:00:00+00:00, 2017-08-18T00:00:00+00:00, 2018-07-01T00:00:00+00:00, 2019-08-12T00:00:00+00:00, 2019-11-04T00:00:00+00:00, 2020-08-20T00:00:00+00:00, 2021-07-21T08:56:07+00:00, 2021-08-08T00:00:00+00:00, 2022-02-15T00:00:00+00:00, 2022-08-07T00:00:00+00:00 |
| ADDRESS | string | Yes | 390 | — | — Range: —Length: 63 | Examples: 711 Des Plaines Ave, 650 Airport Dr, 4917 N Milwaukee Ave, Canal St & Poydras St, 6402 N Central Values: — |
| CITY | string | No | 0 | — | — Range: —Length: 37 | Examples: Chicago, Mt Washington, New York, Riverside, Newark Values: — |
| STATE | string | No | 0 | — | — Range: —Length: 2 | Examples: IL, MD, NY, NJ, NJ Values: — |
| ZIPCODE | string | No | 0 | — | — Range: —Length: 5 | Examples: 60630, 21209, 10024, 8075, 7102 Values: — |
| METRO_AREA | string | Yes | 517 | — | — Range: —Length: 45 | Examples: Merced CA, Chicago-Naperville-Elgin IL-IN-WI, Phoenix-Mesa-Scottsdale AZ, Hilo HI, Stockton-Lodi CA Values: — |
| FAC_NAME | string | Yes | 365 | — | — Range: —Length: 63 | Examples: Rockridge (Oakland), Baypointe, Hempstead Transit Center, San Jose Diridon, Union Station Values: — |
| LONGITUDE | float | No | 0 | — | — Range: -176.64603 to -66.98504Length: — | Examples: -87.7636, -76.6522, -73.9766, -74.9585, -74.16489 Values: — |
| LATITUDE | float | No | 0 | — | — Range: 19.72026 to 71.28545Length: — | Examples: 41.97114, 39.3684, 40.7883, 40.0393, 40.73428 Values: — |
| POINT_LON | float | No | 0 | — | — Range: -176.64603 to -66.98504Length: — | Examples: -87.763, -76.6522, -73.9766, -74.9585, -74.164596 Values: — |
| POINT_LAT | float | No | 0 | — | — Range: 19.72026 to 71.28545Length: — | Examples: 41.97047, 39.3684, 40.7883, 40.0393, 40.734452 Values: — |
| FAC_TYPE | integer | No | 0 | — | — Range: 1 to 12Length: — | Examples: 11, 8, 9, 8, 10 Values: — |
| FERRY_T | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 3, 0, 0, 0 Values: — |
| FERRY_I | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 3, 3, 0, 3, 0 Values: — |
| BUS_T | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| BUS_I | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 0, 0, 0, 1 Values: — |
| BUS_CODE_S | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| BUS_SUPP | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 3, 0, 0, 0 Values: — |
| RAIL_I | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 0, 0, 0, 1 Values: — |
| RAIL_C | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 1, 0, 0, 0, 1 Values: — |
| RAIL_H | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 1, 0, 1, 0, 1 Values: — |
| RAIL_LIGHT | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 1, 0, 1, 1 Values: — |
| AIR_SERVE | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| BIKE_SHARE | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 3, 2, 0, 0 Values: — |
| BIKE_SYS_ID | integer | No | 0 | — | — Range: 0 to 153Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| BIKE_SYS | string | Yes | 4,399 | — | — Range: —Length: 81 | Examples: Citi Bike, Citi Bike, Capital Bikeshare, Bay Area BikeShare (became Ford GoBike 06/28/2017 then became Bay Wheels 06/2019), Divvy Values: — |
| WEBSITE | string | Yes | 2,666 | — | — Range: —Length: 141 | Examples: metrarail.com/metra/en/home/maps_schedules/metra_system_map/md-w/station.BIGTIMBER.html, www.mta.info/nyct/service/index.html, www.sdmts.com/Trolley/TrolleyStationInfo.asp, www.alamosacounty.org/depts/Airport/index.html, metrarail.com/metra/en/home/maps_schedules/metra_system_map/md-w/station.MONTCLARE.html Values: — |
| NOTES | string | Yes | 610 | — | — Range: —Length: 337 | Examples: Served by NJ Transit commuter trains and NJ Transit buses., No scheduled ground transportation., Served by Porter Stage Lines, Served by MUNI light rail, Served by MUNI bus and light rail and Samtrans Bus; near connection with Caltrain commuter rail Values: — |
| SOURCE | string | Yes | 676 | — | — Range: —Length: 187 | Examples: FTA/NTD Database and tripplanner.transit.511.org/mtc/XSLT_TRIP_REQUEST2?language=en, www.mbta.com/, www.amtrakcalififornia.com; www.yarts.com, FTA/NTD Database and tripplanner.transit.511.org/mtc/XSLT_TRIP_REQUEST2?language=en, metrarail.com and www.pacebus.com Values: — |
| I_SERVICE | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 1 Values: — |
| T_SERVICE | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| CBSA_CODE | float | Yes | 517 | — | — Range: 10460 to 49740Length: — | Examples: 32900.0, 16980.0, 38060.0, 25900.0, 44700.0 Values: — |
| CBSA_TYPE | integer | No | 0 | — | — Range: 0 to 2Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| MODES_SERV | integer | No | 0 | — | — Range: 1 to 4Length: — | Examples: 2, 2, 2, 2, 2 Values: — |
| MODE_BUS | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| MODE_AIR | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| MODE_RAIL | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| MODE_FERRY | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| MODE_BIKE | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
Invalid geometry count: 0
Columns hash: 87d143a3b0855088b3586d7799174e8b10172996a97b0cc6d445a350ac762b8b