Dataset: Sea Forecast And Waves Classification

About this Dataset

Sea Forecast And Waves Classification

Context

Sea Forecast and Waves Classification for Florianópolis beaches

Content

Sea forecast is represented by files day_forecast.csv, hour_forecast.csv and tide.csv. Contains sea metrics like swell direction and height, wind speed and direction, period, and others. Beach.csv and spot.csv represents a local register. Sea_condition_fact.csv contain some classifications of spot, ready for a supervised learning algorithms. And facts files contains a result of a naive bayes algorithm, with the probabilities for each characteristics, texture os sea, wave size (or wave height) and wave shape.

Acknowledgements

Marin, Giovani; Fernandes, Anita; Parreira, Wemerson (2020), “Sea Forecast and Waves Classification for Florianópolis beaches”, Mendeley Data, V1, doi: 10.17632/9w3cznz3nv.1

Tables

Beach

@kaggle.saurabhshahane_sea_forecast_and_waves_classification.beach

5.31 KB
7 rows
7 columns


CREATE TABLE beach (
  "idbeach" BIGINT,
  "name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Day Forecast

@kaggle.saurabhshahane_sea_forecast_and_waves_classification.day_forecast

18.15 KB
820 rows
11 columns


CREATE TABLE day_forecast (
  "iddayforecast" BIGINT,
  "date" TIMESTAMP,
  "sunrise" VARCHAR,
  "sunset" VARCHAR,
  "moonset" VARCHAR,
  "moonrise" VARCHAR,
  "moon_phase" VARCHAR,
  "moon_illumination" BIGINT,
  "maxtemp" BIGINT,
  "mintemp" BIGINT,
  "idbeach" BIGINT
);

Fact Shape

@kaggle.saurabhshahane_sea_forecast_and_waves_classification.fact_shape

55.62 KB
503 rows
14 columns


CREATE TABLE fact_shape (
  "id" BIGINT,
  "wind_direction" VARCHAR,
  "spot" VARCHAR,
  "wind_speed" VARCHAR,
  "fact_shape" VARCHAR,
  "date" TIMESTAMP,
  "description" VARCHAR,
  "wide_probability" DOUBLE,
  "barrel_probability" DOUBLE,
  "closing_probability" DOUBLE,
  "lineup_probability" DOUBLE,
  "period" DOUBLE,
  "swell_direction" VARCHAR,
  "swell_size" VARCHAR
);

Fact Size

@kaggle.saurabhshahane_sea_forecast_and_waves_classification.fact_size

48.74 KB
503 rows
15 columns


CREATE TABLE fact_size (
  "id" BIGINT,
  "wind_direction" VARCHAR,
  "spot" VARCHAR,
  "wind_speed" VARCHAR,
  "fact_size" VARCHAR,
  "date" TIMESTAMP,
  "description" VARCHAR,
  "flat_probability" DOUBLE,
  "small_probability" DOUBLE,
  "medium_probability" DOUBLE,
  "big_probability" DOUBLE,
  "biggest_probability" DOUBLE,
  "period" DOUBLE,
  "swell_direction" VARCHAR,
  "swell_size" VARCHAR
);

Fact Texture

@kaggle.saurabhshahane_sea_forecast_and_waves_classification.fact_texture

28.33 KB
504 rows
11 columns


CREATE TABLE fact_texture (
  "id" BIGINT,
  "wind_direction" VARCHAR,
  "spot" VARCHAR,
  "wind_speed" VARCHAR,
  "fact_texture" VARCHAR,
  "date" TIMESTAMP,
  "description" VARCHAR,
  "flat_probability" DOUBLE,
  "frizzy_probability" DOUBLE,
  "stirred_probability" DOUBLE,
  "restless_probability" DOUBLE
);

Hour Forecast

@kaggle.saurabhshahane_sea_forecast_and_waves_classification.hour_forecast

178.66 KB
19680 rows
20 columns


CREATE TABLE hour_forecast (
  "idhourforecast" BIGINT,
  "iddayforecast" BIGINT,
  "time" BIGINT,
  "temperature" BIGINT,
  "windspeed" BIGINT,
  "winddirdegree" BIGINT,
  "preciptation" DOUBLE,
  "humidity" BIGINT,
  "pressure" BIGINT,
  "cloundover" BIGINT,
  "heatindex" BIGINT,
  "dewpoint" BIGINT,
  "windchill" BIGINT,
  "windgust" BIGINT,
  "feelslike" BIGINT,
  "sigheight" DOUBLE,
  "swellheight" DOUBLE,
  "swelldir" BIGINT,
  "period" DOUBLE,
  "watertemp" BIGINT
);

Sea Condition Fact

@kaggle.saurabhshahane_sea_forecast_and_waves_classification.sea_condition_fact

13.94 KB
554 rows
8 columns


CREATE TABLE sea_condition_fact (
  "idseaconditionfact" BIGINT,
  "bulk" BIGINT,
  "texture" BIGINT,
  "shape" BIGINT,
  "uniformity" BIGINT,
  "score" BIGINT,
  "date" TIMESTAMP,
  "idspot" BIGINT
);

Spot

@kaggle.saurabhshahane_sea_forecast_and_waves_classification.spot

4.33 KB
10 rows
5 columns


CREATE TABLE spot (
  "idspot" BIGINT,
  "name" VARCHAR,
  "spot_dir_degree" DOUBLE,
  "sand_size" BIGINT,
  "idbeach" BIGINT
);

Tide

@kaggle.saurabhshahane_sea_forecast_and_waves_classification.tide

36.8 KB
3420 rows
5 columns


CREATE TABLE tide (
  "idtide" BIGINT,
  "iddayforecast" BIGINT,
  "time" TIMESTAMP,
  "height" DOUBLE,
  "type" VARCHAR
);