Schema

Historical Tsunami Observations / historical-tsunami-observations / v1.0.0

View metadata

Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.

Columns

50 columns

Features

32,614

Geometry

Point

Version

Search columns

Column	Type	Nullable	Nulls	Unique	Description	Examples / Values
geometry	geometry	No	0	—	— Range: —Length: —	Examples: — Values: —
ID	integer	No	0	—	— Range: 1 to 7975Length: —	Examples: 537, 5955, 7729, 7299, 872 Values: —
TSEVENT_ID	integer	No	0	—	— Range: 3 to 5484Length: —	Examples: 615, 2187, 1954, 2439, 904 Values: —
YEAR	integer	No	0	—	— Range: -1610 to 2005Length: —	Examples: 1815, 1989, 1964, 2004, 1861 Values: —
MONTH	float	Yes	39	—	— Range: 1 to 12Length: —	Examples: 8.0, 11.0, 12.0, 6.0, 10.0 Values: —
DAY	float	Yes	68	—	— Range: 1 to 31Length: —	Examples: 13.0, 15.0, 19.0, 22.0, 28.0 Values: —
DATE_STRING	string	No	0	—	— Range: —Length: 11	Examples: 1815/11/22, 1989/09/04, 1964/03/28, 2004/12/26, 1861/02/16 Values: —
ARR_DAY	float	Yes	3,746	—	— Range: 1 to 31Length: —	Examples: 8.0, 10.0, 10.0, 8.0, 12.0 Values: —
ARR_HOUR	float	Yes	3,783	—	— Range: 0 to 23Length: —	Examples: 4.0, 16.0, 21.0, 18.0, 18.0 Values: —
ARR_MIN	float	Yes	3,830	—	— Range: 0 to 59Length: —	Examples: 15.0, 42.0, 56.0, 5.0, 48.0 Values: —
TRAV_HOURS	float	Yes	3,809	—	— Range: 0 to 47Length: —	Examples: 1.0, 0.0, 4.0, 0.0, 1.0 Values: —
TRAV_MINS	float	Yes	3,851	—	— Range: 0 to 59Length: —	Examples: 24.0, 33.0, 10.0, 47.0, 12.0 Values: —
PERIOD	float	Yes	5,000	—	— Range: —Length: —	Examples: — Values: —
FIRST_MOTION	string	Yes	4,499	—	— Range: —Length: 1	Examples: F, R, R, R, R Values: F, R
LATITUDE	float	No	0	—	— Range: -63.3833 to 68.2Length: —	Examples: -8.5, 53.883, 60.009, 5.485, -0.05 Values: —
LONGITUDE	float	No	0	—	— Range: -177.361 to 179.302Length: —	Examples: 115.0, -166.533, -144.378, 95.228, 98.2667 Values: —
LOCATION_NAME	string	No	0	—	— Range: —Length: 35	Examples: BALI ISLAND, UNALASKA, DUTCH HARBOR, AK, WINGHAM ISLAND, AK, WEST COAST OF ACEH, SUMATRA, PALAU TELO, SUMATRA Values: —
AREA	string	Yes	943	—	— Range: —Length: 27	Examples: KAGOSHIMA, WA, CA, AK, BAY OF PLENTY Values: —
COUNTRY	string	No	0	—	— Range: —Length: 43	Examples: INDONESIA, USA, USA, INDONESIA, INDONESIA Values: —
REGION_CODE	integer	No	0	—	— Range: 30 to 89Length: —	Examples: 60, 87, 87, 60, 60 Values: —
RUNUP_HT	float	Yes	5,000	—	— Range: —Length: —	Examples: — Values: —
RUNUP_HT_RANK	integer	No	0	—	— Range: 1 to 5Length: —	Examples: 1, 1, 1, 5, 1 Values: —
RUNUP_HORIZ	float	Yes	5,000	—	— Range: —Length: —	Examples: — Values: —
TYPE_MEASUREMENT_ID	float	Yes	152	—	— Range: 1 to 7Length: —	Examples: 1.0, 1.0, 1.0, 2.0, 1.0 Values: —
TYPE_MEASUREMENT	string	Yes	152	—	— Range: —Length: 45	Examples: Eyewitness measurement, Eyewitness measurement, Eyewitness measurement, Tide-gauge measurement, Eyewitness measurement Values: Atmospheric pressure wave, Deep ocean gauge, Eyewitness measurement, Runup height, post-tsunami survey measurement, Seiche, Tide-gauge measurement, Water height, post-tsunami survey measurement
DAMAGE_MILLIONS_DOLLARS	float	Yes	4,930	—	— Range: 0.001 to 31.279Length: —	Examples: 0.002, 0.001, 0.005, 15.0, 0.005 Values: —
DAMAGE_AMOUNT_ORDER	float	Yes	4,049	—	— Range: 0 to 4Length: —	Examples: 1.0, 1.0, 2.0, 3.0, 1.0 Values: —
DAMAGE_DESCRIPTION	string	Yes	4,049	—	— Range: —Length: 30	Examples: Limited (<$1 million), Limited (<$1 million), Moderate (~$1 to $5 million), Severe (~>$5 to $24 million), Limited (<$1 million) Values: Extreme (~$25 million or more), Limited (<$1 million), Moderate (~$1 to $5 million), None, Severe (~>$5 to $24 million)
DEATHS	float	Yes	4,691	—	— Range: 1 to 36000Length: —	Examples: 20.0, 3.0, 4.0, 1.0, 9.0 Values: —
DEATHS_AMOUNT_ORDER	float	Yes	4,584	—	— Range: 1 to 4Length: —	Examples: 1.0, 1.0, 2.0, 1.0, 1.0 Values: —
DEATHS_DESCRIPTION	string	Yes	4,584	—	— Range: —Length: 32	Examples: Few (~1 to 50 people), Few (~1 to 50 people), Some (~51 to 100 people), Few (~1 to 50 people), Few (~1 to 50 people) Values: Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people), Very Many (~1001 or more people)
INJURIES	float	Yes	4,947	—	— Range: 1 to 1625Length: —	Examples: 31.0, 2.0, 32.0, 1.0, 100.0 Values: —
INJURIES_AMOUNT_ORDER	float	Yes	4,943	—	— Range: 1 to 4Length: —	Examples: 1.0, 1.0, 1.0, 1.0, 2.0 Values: —
INJURIES_DESCRIPTION	string	Yes	4,943	—	— Range: —Length: 32	Examples: Few (~1 to 50 people), Few (~1 to 50 people), Few (~1 to 50 people), Few (~1 to 50 people), Some (~51 to 100 people) Values: Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people), Very Many (~1001 or more people)
HOUSES_DESTROYED	float	Yes	4,839	—	— Range: 1 to 18000Length: —	Examples: 50.0, 6.0, 36.0, 490.0, 111.0 Values: —
HOUSES_AMOUNT_ORDER	float	Yes	4,587	—	— Range: 1 to 4Length: —	Examples: 3.0, 3.0, 1.0, 1.0, 1.0 Values: —
HOUSES_DESCRIPTION	string	Yes	4,587	—	— Range: —Length: 32	Examples: Many (~101 to 1000 houses), Many (~101 to 1000 houses), Few (~1 to 50 houses), Few (~1 to 50 houses), Few (~1 to 50 houses) Values: Few (~1 to 50 houses), Many (~101 to 1000 houses), Some (~51 to 100 houses), Very Many (~1001 or more houses)
HOUSES_DAMAGED	float	Yes	4,968	—	— Range: 1 to 2947Length: —	Examples: 1.0, 12.0, 49.0, 100.0, 50.0 Values: —
HOUSES_DAMAGED_AMOUNT_ORDER	float	Yes	4,885	—	— Range: 1 to 4Length: —	Examples: 2.0, 1.0, 1.0, 1.0, 3.0 Values: —
HOUSES_DAM_DESCRIPTION	string	Yes	4,885	—	— Range: —Length: 32	Examples: Some (~51 to 100 houses), Few (~1 to 50 houses), Few (~1 to 50 houses), Few (~1 to 50 houses), Many (~101 to 1000 houses) Values: Few (~1 to 50 houses), Many (~101 to 1000 houses), Some (~51 to 100 houses), Very Many (~1001 or more houses)
COMMENTS	string	Yes	1,424	—	— Range: —Length: 3998	Examples: Although Mayaguez [MMI VIII] was not affected by the brunt of the waves, Figure 12 shows the now familiar photo of a house uplifted by the tsunami that flooded ashore there. Figure 13 pictures a small house carried seaward by the powerful backwash and left stranded near the shore. The retreating torrent is often as formidable as the initial upsurge of the wave and filled with all manner of debris. About 23 minutes after the earthquake, seawater entered the lower floors of buildings near the waterfront and destroyed a few native huts along the beach (Reid and Taber, 1999a, ref #1078). Watermarks left on houses indicated runups to 1.5 meters above sea level. Debris made many streets impassable, impeding fire trucks and rescue efforts. More than 100 people perished. (reference #1492), Waves were observed at Hoh River, Washington when the water rose in mouth of river. Validity of this runup event is 0. (Ref #237) <P>The water rose in Grays Bay, and in the mouths of the Queet Quinault, Wishkah and Hoh Rivers (Reference #415)., <P><blockquote><i>Reference #414:</blockquote><i> <P>The pen stopped on the tide gauge at Ayukawa after the beginning of the earthquake, as a result of the strong oscillations. The record resumed 6 hours later. The record showed that the sea level was oscillating in a way typical of tsunamis. The mean period of oscillations was 20-25 minutes and the maximal amplitude was 5 cm. The assumed travel time of the tsunami to Ayukawa was 15 minutes., The maximal amplitude (range) of oscillations in level is 0.1 m and the travel time is 0:44 (Reference #414)., A strong surge in the bay affected the port buildings and loading docks. Values: —
DOUBTFUL	string	Yes	4,783	—	— Range: —Length: 1	Examples: ?, A, M, ?, M Values: ?, A, M
DIST_FROM_SOURCE	float	Yes	92	—	— Range: 0 to 19255Length: —	Examples: 138.0, 108.0, 18817.0, 43.0, 2.0 Values: —
EVENT_REGION_CODE	integer	No	0	—	— Range: 30 to 89Length: —	Examples: 60, 87, 87, 60, 60 Values: —
EVENT_REGION	string	No	0	—	— Range: —Length: 54	Examples: Indian Ocean (including W. Australia and W. Indonesia), Alaska (including Aleutian Islands), Alaska (including Aleutian Islands), Indian Ocean (including W. Australia and W. Indonesia), Indian Ocean (including W. Australia and W. Indonesia) Values: —
PRED_TRAV_HOURS	string	Yes	5,000	—	— Range: —Length: —	Examples: — Values: —
PRED_TRAV_MINS	string	Yes	5,000	—	— Range: —Length: —	Examples: — Values: —
URL	string	No	0	—	— Range: —Length: 98	Examples: http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=10&d=99,185,186,76,78&nd=display&EQ_0=537, http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=10&d=99,185,186,76,78&nd=display&EQ_0=5955, http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=10&d=99,185,186,76,78&nd=display&EQ_0=7729, http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=10&d=99,185,186,76,78&nd=display&EQ_0=7299, http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=10&d=99,185,186,76,78&nd=display&EQ_0=872 Values: —
TSEVENT_URL	string	No	0	—	— Range: —Length: 92	Examples: http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=9&d=99,91,95,93&nd=display&EQ_0=615, http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=9&d=99,91,95,93&nd=display&EQ_0=2187, http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=9&d=99,91,95,93&nd=display&EQ_0=1954, http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=9&d=99,91,95,93&nd=display&EQ_0=2439, http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=9&d=99,91,95,93&nd=display&EQ_0=904 Values: —
DRAWING_ORDER	float	No	0	—	— Range: -243.3833 to 68.2Length: —	Examples: -8.5, 53.883, 60.009, 5.485, -0.05 Values: —

Invalid geometry count: 0

Columns hash: ae98569ee7cc1aa5526dd43cbb0f2f8371f0aa1a2660734b0027d3ca0fe889d5