Back to fileView metadata
Schema
Intermodal Freight Facilities Pipeline Terminals / intermodal-freight-facilities-pipeline-terminals / v1.0.0
Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.
Columns
34 columns
Features
1,401
Geometry
Point
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| OBJECTID | integer | No | 0 | — | — Range: 1 to 1401Length: — | Examples: 1031, 313, 225, 1256, 1233 Values: — |
| TERM_ID | string | No | 0 | — | — Range: —Length: 8 | Examples: 42079041, 17031015, 12057023, 48361130, 48297107 Values: — |
| IRS_ID | string | No | 0 | — | — Range: —Length: 29 | Examples: T-23-PA-1720, T-36-IL-3307, T-59-FL-2133, NA, T-74-TX-2747 Values: — |
| HIFLD_ID | string | No | 0 | — | — Range: —Length: 10 | Examples: ANLTK42018, ANLTK17008, ANLTK12070, ANLTK48254, ANLTK48193 Values: — |
| COMP_NAME | string | No | 0 | — | — Range: —Length: 49 | Examples: SUNOCO PARTNERS MARKETING & TERMINALS LP, MPLX LP, CITGO PETROLEUM CORPORATION, MARTIN RESOURCE MANAGEMENT CORPORATION, DIAMOND SHAMROCK Values: — |
| TERM_NAME | string | No | 0 | — | — Range: —Length: 53 | Examples: KINGSTON TERMINAL, MOUNT PROPSPECT TERMINAL, TAMPA TERMINAL, BEAUMONT NECHES TERMINAL, NA Values: — |
| ADDRESS | string | No | 0 | — | — Range: —Length: 74 | Examples: 60 S WYOMING AVENUE, 3231 BUSSE ROAD, 801 MCCLOSKEY BLVD, 1 GULF STATES ROAD, 301 LEROY STREET Values: — |
| CITY | string | No | 0 | — | — Range: —Length: 19 | Examples: EDWARDSVILLE, ARLINGTON HEIGHTS, TAMPA, BEAUMONT, THREE RIVERS Values: — |
| STATE | string | No | 0 | — | — Range: —Length: 2 | Examples: PA, IL, FL, TX, TX Values: — |
| STATE_FIPS | string | No | 0 | — | — Range: —Length: 2 | Examples: 42, 17, 12, 48, 48 Values: — |
| COUNTY | string | No | 0 | — | — Range: —Length: 20 | Examples: LUZERNE, COOK, HILLSBOROUGH, ORANGE, LIVE OAK Values: — |
| CNTY_FIPS | string | No | 0 | — | — Range: —Length: 3 | Examples: 079, 031, 057, 361, 297 Values: — |
| TRUCK | string | No | 0 | — | — Range: —Length: 1 | Examples: Y, Y, Y, Y, Y Values: N, Y, y |
| RAIL | string | No | 0 | — | — Range: —Length: 1 | Examples: N, N, N, Y, Y Values: N, Y |
| WATER | string | No | 0 | — | — Range: —Length: 1 | Examples: N, N, Y, Y, N Values: N, Y |
| CAPACITY | string | No | 0 | — | — Range: —Length: 8 | Examples: 140000, 390350, 828612, NA, 975000 Values: — |
| CRUDE_OIL | string | No | 0 | — | — Range: —Length: 2 | Examples: N, N, N, N, Y Values: N, NA, Y |
| REFINED | string | No | 0 | — | — Range: —Length: 2 | Examples: Y, N, Y, Y, Y Values: N, NA, Y |
| PET_CHEM | string | No | 0 | — | — Range: —Length: 2 | Examples: N, N, Y, Y, Y Values: N, NA, Y |
| NGL | string | No | 0 | — | — Range: —Length: 2 | Examples: Y, N, N, N, N Values: N, NA, Y |
| GASOLINE | string | No | 0 | — | — Range: —Length: 2 | Examples: Y, N, Y, N, N Values: N, NA, Y |
| DISTILLATE | string | No | 0 | — | — Range: —Length: 2 | Examples: N, N, Y, Y, Y Values: N, NA, Y |
| BIODIESEL | string | No | 0 | — | — Range: —Length: 2 | Examples: N, Y, N, N, NA Values: N, NA, Y |
| JETFUEL | string | No | 0 | — | — Range: —Length: 2 | Examples: N, N, N, Y, Y Values: N, NA, Y |
| ETHANOL | string | No | 0 | — | — Range: —Length: 2 | Examples: N, NA, N, N, NA Values: N, NA, Y |
| WEBSITE | string | No | 0 | — | — Range: —Length: 57 | Examples: https://rtk.rjifuture.org/, https://www.mplx.com/, https://www.citgo.com/, http://themartincompanies.com/, https://www.valero.com/ Values: — |
| string | No | 0 | — | — Range: —Length: 65 | Examples: https://www.google.com/maps/@41.2573,-75.9049,500m/data=!3m1!1e3, https://www.google.com/maps/@42.0279,-87.9554,500m/data=!3m1!1e3, https://www.google.com/maps/@27.9331,-82.4438,500m/data=!3m1!1e3, https://www.google.com/maps/@30.06,-94.0385,500m/data=!3m1!1e3, https://www.google.com/maps/@28.4581,-98.1887,500m/data=!3m1!1e3 Values: — | |
| BING | string | No | 0 | — | — Range: —Length: 52 | Examples: https://www.bing.com/maps/aerial?q=41.2573,-75.9049, https://www.bing.com/maps/aerial?q=42.0279,-87.9554, https://www.bing.com/maps/aerial?q=27.9331,-82.4438, https://www.bing.com/maps/aerial?q=30.06,-94.0385, https://www.bing.com/maps/aerial?q=28.4581,-98.1887 Values: — |
| ZOOMEARTH | string | No | 0 | — | — Range: —Length: 46 | Examples: https://zoom.earth/#view=41.2573,-75.9049,17z, https://zoom.earth/#view=42.0279,-87.9554,17z, https://zoom.earth/#view=27.9331,-82.4438,17z, https://zoom.earth/#view=30.06,-94.0385,17z, https://zoom.earth/#view=28.4581,-98.1887,17z Values: — |
| VAL_DATE | string | No | 0 | — | — Range: —Length: 9 | Examples: 2/20/2021, 2/20/2021, 2/20/2021, 2/20/2021, 2/20/2021 Values: 2/20/2021 |
| SOURCE | string | No | 0 | — | — Range: —Length: 66 | Examples: EIA,HIFLD,IRS,RIGHT-TO-KNOW NETWORK, EIA,HIFLD,IRS, EIA,HIFLD,IRS,COMPANY WEBSITE/ONLINE INFORMATION, EIA,HIFLD,COMPANY WEBSITE/ONLINE INFORMATION, HIFLD,IRS,COMPANY WEBSITE/ONLINE INFORMATION Values: COMPANY WEBSITE/ONLINE INFORMATION, EIA,HIFLD, EIA,HIFLD,COMPANY WEBSITE/ONLINE INFORMATION, EIA,HIFLD,IRS, EIA,HIFLD,IRS,COMPANY WEBSITE/ONLINE INFORMATION, EIA,HIFLD,IRS,RIGHT-TO-KNOW NETWORK, EIA,HIFLD,RIGHT-TO-KNOW NETWORK, HIFLD, HIFLD,COMPANY WEBSITE/ONLINE INFORMATION, HIFLD,COMPANY WEBSITE/ONLINE INFORMATION,RIGHT-TO-KNOW NETWORK, HIFLD,IRS, HIFLD,IRS,COMPANY WEBSITE/ONLINE INFORMATION, HIFLD,IRS,COMPANY WEBSITE/ONLINE INFORMATION,RIGHT-TO-KNOW NETWORK, HIFLD,IRS,RIGHT-TO-KNOW NETWORK, HIFLD,RIGHT-TO-KNOW NETWORK, RIGHT-TO-KNOW NETWORK |
| LATITUDE | float | No | 0 | — | — Range: 19.726 to 68.8428Length: — | Examples: 41.2573, 42.0279, 27.9331, 30.06, 28.4581 Values: — |
| LONGITUDE | float | No | 0 | — | — Range: -176.6438 to -68.7802Length: — | Examples: -75.9049, -87.9554, -82.4438, -94.0385, -98.1887 Values: — |
Invalid geometry count: 0
Columns hash: 405ca18af015659a6fd7a01b88692e20d2a77f48ad0eb8965a955e72dca3a71a