Back to fileView metadata
Schema
NFHL / coastal-gages-1 / v1.0.0
Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.
Columns
29 columns
Features
693
Geometry
Point
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | Yes | 1 | — | — Range: —Length: — | Examples: — Values: — |
| OBJECTID | integer | No | 0 | — | — Range: 11 to 6251Length: — | Examples: 5390, 272, 6089, 6053, 881 Values: — |
| DFIRM_ID | string | No | 0 | — | — Range: —Length: 6 | Examples: 26103C, 26127C, 26159C, 55079C, 39043C Values: — |
| VERSION_ID | string | No | 0 | — | — Range: —Length: 7 | Examples: 2.4.3.0, 2.4.3.5, 2.4.3.0, 2.8.3.3, 2.3.2.3 Values: — |
| CSTGAGE_ID | string | No | 0 | — | — Range: —Length: 14 | Examples: 26103C_4, 26127C_7, 26159C_8, 55079C_4, 39043C_13 Values: — |
| CST_MDL_ID | string | Yes | 191 | — | — Range: —Length: 19 | Examples: 26139C_7, 26151C_2, 26017C_7, 26109C_7, 26109C_7 Values: — |
| GAGE_NM | string | No | 0 | — | — Range: —Length: 70 | Examples: Ontonagon, MI (9099044), Station 9087072, Sturgeon Bay, WI (9087072), Milwaukee, WI (9087057), KINGSVILLE, ON Values: — |
| AGENCY | string | No | 0 | — | — Range: —Length: 92 | Examples: NOAA, NOAA, NOAA, NOAA, Fisheries and Oceans, Canada Values: — |
| REC_INTVL | string | Yes | 438 | — | — Range: —Length: 7 | Examples: 1, 1, 1, 1, 1 Values: -9999, 1, 6, 61, Hourly, MONTHLY |
| TIME_UNIT | string | Yes | 425 | — | — Range: —Length: 7 | Examples: HOURS, HOURS, HOURS, HOURS, HOURS Values: HOURS, Hours, MINUTES, SECONDS, YEARS |
| START_PD | string | Yes | 21 | — | — Range: —Length: 10 | Examples: 1973-01-01, 1957-01-01, 1914-01-01, 1960-01-01, 1960-01-01 Values: — |
| START_TIME | string | Yes | 443 | — | — Range: —Length: 8 | Examples: 07:00, 06:00, 8/8/8888, 06:00, 24:00 Values: 0, 0000, 00:00, 06:00, 07:00, 0:00, 12:00 AM, 1800, 24:00, 6:00, 8/8/8888 |
| END_PD | string | No | 0 | — | — Range: —Length: 10 | Examples: 2009-01-01, 2009-12-31, 2009-12-31, 2009-12-31, 2011-03-01 Values: — |
| END_TIME | string | Yes | 489 | — | — Range: —Length: 8 | Examples: 00:00, 24:00, 12:00 AM, 00:00, 24:00 Values: 0, 00:00, 12:00 AM, 1700, 2300, 2356, 23:00, 23:59, 24:00 |
| GAGE_TYPE | string | No | 0 | — | — Range: —Length: 25 | Examples: Tide, Tide, Tide, Tide, Stage Values: NP, Stage, Tide, Wave Height, Wave Height and Direction, Wind Speed and Direction |
| V_DATUM | string | No | 0 | — | — Range: —Length: 17 | Examples: NAVD88, LOCAL TIDAL DATUM, NAVD88, NAVD88, LOCAL TIDAL DATUM Values: LOCAL TIDAL DATUM, MLLW, NAVD88, NP |
| DATUM_CONV | float | No | 0 | — | — Range: -9999 to 2.51Length: — | Examples: 0.0, -9999.0, 0.41, 0.5054, 0.2 Values: — |
| TIDE_TF | string | No | 0 | — | — Range: —Length: 1 | Examples: T, T, T, T, T Values: F, T, U |
| TIDE_EPOCH | string | Yes | 360 | — | — Range: —Length: 9 | Examples: 1983-2001, 1983-2001, 1983-2001, 1983-2001, 1983-2001 Values: 1900-2015, 1938-2015, 1960-2009, 1983-2001, 1995-2012, F, U |
| TIDE_VBM | string | Yes | 476 | — | — Range: —Length: 11 | Examples: 13186, 13046, 13227, 13220, 13199 Values: — |
| WVDIR_TF | string | No | 0 | — | — Range: —Length: 1 | Examples: F, F, F, F, F Values: F, T, U |
| WVSPEC_TF | string | No | 0 | — | — Range: —Length: 1 | Examples: F, F, F, F, F Values: F, T, U |
| WDSPD_TF | string | No | 0 | — | — Range: —Length: 1 | Examples: F, F, F, F, F Values: F, T, U |
| WDDIR_TF | string | No | 0 | — | — Range: —Length: 1 | Examples: F, F, F, F, F Values: F, T, U |
| WDSTN_HT | integer | No | 0 | — | — Range: -9999 to 91Length: — | Examples: -9999, -9999, -9999, -9999, -9999 Values: — |
| SOURCE_CIT | string | No | 0 | — | — Range: —Length: 15 | Examples: 26103C_STUDY4, 26127C_STUDY1, 26159C_STUDY1, 55079C_STUDY20, 39043C_STUDY2 Values: — |
| GFID | string | No | 0 | — | — Range: —Length: 36 | Examples: 3e52a32a-e137-414d-bd9d-76a01b22eab7, e6208396-4e40-4fd8-8ff3-3cb973e5f0ac, 610c6130-445f-4252-b913-59016758bcb5, ebf63982-9c8c-4f3a-9b78-efd281740356, 0245ea1f-f1cf-4896-845c-dcd7674d540c Values: — |
| GlobalID | string | No | 0 | — | — Range: —Length: 38 | Examples: {55280D49-285B-46B1-B86E-508E2D4E448C}, {31F2AB02-4B66-40F1-A40D-493E55C82304}, {8C10D374-6298-4945-ADB5-ECB58A039579}, {5DAEDF05-EBCC-4315-884D-28EA01706810}, {0598DE82-A770-4E03-B5DE-46FD274147A5} Values: — |
| id | integer | No | 0 | — | — Range: 11 to 6251Length: — | Examples: 5390, 272, 6089, 6053, 881 Values: — |
Invalid geometry count: 0
Columns hash: 652d735bd844c2a59534b7afcfc4afd9d46aef77959bae6e3c47cf29fa893999