Kittlitz's And Marbled Murrelet Survey Cumulative Corrected Observations (KM E)
Department of the Interior
@usgov.doi_gov_kittlitzs_and_marbled_murrelet_survey_cumulati_1f2ee085
Department of the Interior
@usgov.doi_gov_kittlitzs_and_marbled_murrelet_survey_cumulati_1f2ee085
CREATE TABLE km_d_2024_corrections (
"transect" VARCHAR,
"start_record" VARCHAR,
"start_date" VARCHAR,
"start_time" VARCHAR,
"end_record" VARCHAR,
"end_date" VARCHAR,
"end_time" VARCHAR,
"action_performed" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE sean_km_e_2011_2024 (
"transect_id" BIGINT,
"date_local" TIMESTAMP,
"time_local" VARCHAR,
"vessel" VARCHAR,
"recorder" VARCHAR,
"observer_1" VARCHAR,
"observer_2" VARCHAR,
"beaufort" BIGINT,
"weather_code" BIGINT,
"visibility" BIGINT,
"latitude_wgs84" DOUBLE,
"longitude_wgs84" DOUBLE,
"utm8_easting" DOUBLE,
"utm8_northing" BIGINT,
"speed" DOUBLE,
"bearing" DOUBLE,
"angle" BIGINT,
"distance" BIGINT,
"behavior" VARCHAR,
"group_size" BIGINT,
"species" VARCHAR,
"on_transect" BOOLEAN,
"protocol_id" VARCHAR,
"gps_status" DOUBLE,
"satellites" DOUBLE,
"hdop" DOUBLE,
"track_length" DOUBLE,
"data_quality" BIGINT,
"data_quality_comment" VARCHAR,
"observed_by" VARCHAR,
"comments" VARCHAR,
"time_stamp" VARCHAR,
"userid" VARCHAR,
"submission_number" BIGINT
);
Anyone who has the link will be able to view this.