Back to fileView metadata
Schema
Principal Ports / Principal Ports / v1.0.0
Schema from principal-ports.parquet, gcs-hifld-next-datasets-prod, v1.0.0.
The principal port file contains USACE port codes, geographic location, names, and commodity tonnage summaries (total tons, domestic, foreign, imports and exports) for principal USACE ports for CY 2022.
Columns
14 columns
Features
150
Geometry
MultiPolygon
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| OBJECTID | integer | No | 0 | — | — Range: 1 to 150Length: — | Examples: 115, 63, 34, 108, 8 Values: — |
| RANK | integer | No | 0 | — | — Range: 1 to 150Length: — | Examples: 12, 59, 41, 86, 132 Values: — |
| PORT | integer | No | 0 | — | — Range: 77 to 7711Length: — | Examples: 2032, 1910, 2420, 2316, 2224 Values: — |
| TYPE | string | No | 0 | — | — Range: —Length: 11 | Examples: Coastal, Coastal, Coastal, Internal, Coastal Values: Coastal, Great Lakes, Internal |
| PORTNAME | string | No | 0 | — | — Range: —Length: 32 | Examples: Mobile, AL, Greater Lafourche Port, LA, Brownsville, TX, Massac-Metropolis Port, IL, Terrebonne Parish Port, LA Values: — |
| TOTAL | integer | No | 0 | — | — Range: 1009336 to 309531236Length: — | Examples: 52180346, 7594087, 11260429, 3484483, 1559384 Values: — |
| DOMESTIC | integer | No | 0 | — | — Range: 0 to 109130807Length: — | Examples: 15730883, 7527397, 3501086, 3484483, 1559384 Values: — |
| FOREIGN_ | integer | No | 0 | — | — Range: 0 to 229019431Length: — | Examples: 36449463, 66690, 7759343, 0, 0 Values: — |
| IMPORTS | integer | No | 0 | — | — Range: 0 to 74145286Length: — | Examples: 18938466, 66690, 6647633, 0, 0 Values: — |
| EXPORTS | integer | No | 0 | — | — Range: 0 to 167712322Length: — | Examples: 17510997, 0, 1111710, 0, 0 Values: — |
| Shape__Are | float | No | 0 | — | — Range: 1023000.796875 to 60158714687.0625Length: — | Examples: 632369175.7285156, 2760276493.84375, 1203577792.4277344, 1022587329.296875, 7129086082.197266 Values: — |
| Shape__Len | float | No | 0 | — | — Range: 6092.590442106682 to 1534937.0653612716Length: — | Examples: 257853.34370788294, 285874.35037090164, 294948.08974683465, 144816.28143385868, 397608.7397187454 Values: — |
| id | integer | No | 0 | — | — Range: 1 to 150Length: — | Examples: 115, 63, 34, 108, 8 Values: — |
Quality checks: Failed
Invalid geometry count: 15
Columns hash: 99ac0b2a7a21c14c13e475fa2464d2ee0104dca62361f36deaeaa17f63a81aab