About this Dataset

Glacier Bay, Alaska Murrelet Survey External Waypoint File (KM I)

Deliverable KM_I is comprised of one CSV file per year. It contains the waypoint data recorded on external GPS devices in the course of murrelet surveys. They are intended to mark locations of exceptional events during the survey and serve as backup in case equipment failure forces the crew to record observations using the paper form process.

This data product has been compared against the formal quality criteria specified in the protocol package in effect at the time of data collection, found to be in complete compliance, and accepted by the program lead for public dissemination.

Deliverable KM_I is fully defined in the protocol document package available at NPS Data Store reference 2204691.
Organization: Department of the Interior
Last updated: 2023-08-24T03:56:17.426527
Tags: application-inventory-registry, brachyramphus, brachyramphus-brevirostris, brachyramphus-marmoratus, ecological-framework-biological-integrity-focal-species-or-communities-birds, kittlitzs-murrelet, marbled-murrelet, marbled-murrelets, murrelet, population, status, trend

Tables

KM I 2011

@usgov.doi_gov_glacier_bay_alaska_murrelet_survey_external_wa_acaab4d9.km_i_2011

20.89 KB
4 rows
33 columns


CREATE TABLE km_i_2011 (
  "type" VARCHAR,
  "waypoint_id" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "y_proj" DOUBLE,
  "x_proj" DOUBLE,
  "timestamp" VARCHAR,
  "display" BIGINT,
  "symbol" BIGINT,
  "unused1" BIGINT,
  "dist" BIGINT,
  "prox_index" BIGINT,
  "color" BIGINT,
  "altitude" BIGINT,
  "depth" BIGINT,
  "temp" BIGINT,
  "time" VARCHAR,
  "wpt_class" BIGINT,
  "sub_class" VARCHAR,
  "attrib" BIGINT,
  "link" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "address" VARCHAR,
  "facility" VARCHAR,
  "crossroad" VARCHAR,
  "unused2" BIGINT,
  "ete" BIGINT,
  "dtype" BIGINT,
  "model" VARCHAR,
  "filename" VARCHAR,
  "ltime" TIMESTAMP
);

KM I 2012

@usgov.doi_gov_glacier_bay_alaska_murrelet_survey_external_wa_acaab4d9.km_i_2012

43.72 KB
495 rows
33 columns


CREATE TABLE km_i_2012 (
  "type" VARCHAR,
  "waypoint_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "y_proj" DOUBLE,
  "x_proj" DOUBLE,
  "timestamp" VARCHAR,
  "display" BIGINT,
  "symbol" BIGINT,
  "unused1" BIGINT,
  "dist" BIGINT,
  "prox_index" BIGINT,
  "color" BIGINT,
  "altitude" BIGINT,
  "depth" BIGINT,
  "temp" BIGINT,
  "time" VARCHAR,
  "wpt_class" BIGINT,
  "sub_class" VARCHAR,
  "attrib" BIGINT,
  "link" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "address" VARCHAR,
  "facility" VARCHAR,
  "crossroad" VARCHAR,
  "unused2" BIGINT,
  "ete" BIGINT,
  "dtype" BIGINT,
  "model" VARCHAR,
  "filename" VARCHAR,
  "ltime" TIMESTAMP
);

KM I 2013

@usgov.doi_gov_glacier_bay_alaska_murrelet_survey_external_wa_acaab4d9.km_i_2013

18.83 KB
1 row
33 columns


CREATE TABLE km_i_2013 (
  "type" VARCHAR,
  "waypoint_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "y_proj" VARCHAR,
  "x_proj" VARCHAR,
  "timestamp" VARCHAR,
  "display" VARCHAR,
  "symbol" VARCHAR,
  "unused1" VARCHAR,
  "dist" VARCHAR,
  "prox_index" VARCHAR,
  "color" VARCHAR,
  "altitude" VARCHAR,
  "depth" VARCHAR,
  "temp" VARCHAR,
  "time" VARCHAR,
  "wpt_class" VARCHAR,
  "sub_class" VARCHAR,
  "attrib" VARCHAR,
  "link" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "address" VARCHAR,
  "facility" VARCHAR,
  "crossroad" VARCHAR,
  "unused2" VARCHAR,
  "ete" VARCHAR,
  "dtype" VARCHAR,
  "model" VARCHAR,
  "filename" VARCHAR,
  "ltime" VARCHAR
);

KM I 2014

@usgov.doi_gov_glacier_bay_alaska_murrelet_survey_external_wa_acaab4d9.km_i_2014

18.84 KB
1 row
33 columns


CREATE TABLE km_i_2014 (
  "type" VARCHAR,
  "waypoint_id" VARCHAR,
  "latitude" BIGINT,
  "longitude" BIGINT,
  "y_proj" VARCHAR,
  "x_proj" VARCHAR,
  "timestamp" VARCHAR,
  "display" VARCHAR,
  "symbol" VARCHAR,
  "unused1" VARCHAR,
  "dist" VARCHAR,
  "prox_index" VARCHAR,
  "color" VARCHAR,
  "altitude" VARCHAR,
  "depth" VARCHAR,
  "temp" VARCHAR,
  "time" VARCHAR,
  "wpt_class" VARCHAR,
  "sub_class" VARCHAR,
  "attrib" VARCHAR,
  "link" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "address" VARCHAR,
  "facility" VARCHAR,
  "crossroad" VARCHAR,
  "unused2" VARCHAR,
  "ete" VARCHAR,
  "dtype" VARCHAR,
  "model" VARCHAR,
  "filename" VARCHAR,
  "ltime" VARCHAR
);

KM I 2015

@usgov.doi_gov_glacier_bay_alaska_murrelet_survey_external_wa_acaab4d9.km_i_2015

18.84 KB
1 row
33 columns


CREATE TABLE km_i_2015 (
  "type" VARCHAR,
  "waypoint_id" VARCHAR,
  "latitude" BIGINT,
  "longitude" BIGINT,
  "y_proj" VARCHAR,
  "x_proj" VARCHAR,
  "timestamp" VARCHAR,
  "display" VARCHAR,
  "symbol" VARCHAR,
  "unused1" VARCHAR,
  "dist" VARCHAR,
  "prox_index" VARCHAR,
  "color" VARCHAR,
  "altitude" VARCHAR,
  "depth" VARCHAR,
  "temp" VARCHAR,
  "time" VARCHAR,
  "wpt_class" VARCHAR,
  "sub_class" VARCHAR,
  "attrib" VARCHAR,
  "link" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "address" VARCHAR,
  "facility" VARCHAR,
  "crossroad" VARCHAR,
  "unused2" VARCHAR,
  "ete" VARCHAR,
  "dtype" VARCHAR,
  "model" VARCHAR,
  "filename" VARCHAR,
  "ltime" VARCHAR
);

KM I 2016

@usgov.doi_gov_glacier_bay_alaska_murrelet_survey_external_wa_acaab4d9.km_i_2016

18.84 KB
1 row
33 columns


CREATE TABLE km_i_2016 (
  "type" VARCHAR,
  "waypoint_id" VARCHAR,
  "latitude" BIGINT,
  "longitude" BIGINT,
  "y_proj" VARCHAR,
  "x_proj" VARCHAR,
  "timestamp" VARCHAR,
  "display" VARCHAR,
  "symbol" VARCHAR,
  "unused1" VARCHAR,
  "dist" VARCHAR,
  "prox_index" VARCHAR,
  "color" VARCHAR,
  "altitude" VARCHAR,
  "depth" VARCHAR,
  "temp" VARCHAR,
  "time" VARCHAR,
  "wpt_class" VARCHAR,
  "sub_class" VARCHAR,
  "attrib" VARCHAR,
  "link" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "address" VARCHAR,
  "facility" VARCHAR,
  "crossroad" VARCHAR,
  "unused2" VARCHAR,
  "ete" VARCHAR,
  "dtype" VARCHAR,
  "model" VARCHAR,
  "filename" VARCHAR,
  "ltime" VARCHAR
);

KM I 2017

@usgov.doi_gov_glacier_bay_alaska_murrelet_survey_external_wa_acaab4d9.km_i_2017

18.84 KB
1 row
33 columns


CREATE TABLE km_i_2017 (
  "type" VARCHAR,
  "waypoint_id" VARCHAR,
  "latitude" BIGINT,
  "longitude" BIGINT,
  "y_proj" VARCHAR,
  "x_proj" VARCHAR,
  "timestamp" VARCHAR,
  "display" VARCHAR,
  "symbol" VARCHAR,
  "unused1" VARCHAR,
  "dist" VARCHAR,
  "prox_index" VARCHAR,
  "color" VARCHAR,
  "altitude" VARCHAR,
  "depth" VARCHAR,
  "temp" VARCHAR,
  "time" VARCHAR,
  "wpt_class" VARCHAR,
  "sub_class" VARCHAR,
  "attrib" VARCHAR,
  "link" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "address" VARCHAR,
  "facility" VARCHAR,
  "crossroad" VARCHAR,
  "unused2" VARCHAR,
  "ete" VARCHAR,
  "dtype" VARCHAR,
  "model" VARCHAR,
  "filename" VARCHAR,
  "ltime" VARCHAR
);

KM I 2018

@usgov.doi_gov_glacier_bay_alaska_murrelet_survey_external_wa_acaab4d9.km_i_2018

18.84 KB
1 row
33 columns


CREATE TABLE km_i_2018 (
  "type" VARCHAR,
  "waypoint_id" VARCHAR,
  "latitude" BIGINT,
  "longitude" BIGINT,
  "y_proj" VARCHAR,
  "x_proj" VARCHAR,
  "timestamp" VARCHAR,
  "display" VARCHAR,
  "symbol" VARCHAR,
  "unused1" VARCHAR,
  "dist" VARCHAR,
  "prox_index" VARCHAR,
  "color" VARCHAR,
  "altitude" VARCHAR,
  "depth" VARCHAR,
  "temp" VARCHAR,
  "time" VARCHAR,
  "wpt_class" VARCHAR,
  "sub_class" VARCHAR,
  "attrib" VARCHAR,
  "link" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "address" VARCHAR,
  "facility" VARCHAR,
  "crossroad" VARCHAR,
  "unused2" VARCHAR,
  "ete" VARCHAR,
  "dtype" VARCHAR,
  "model" VARCHAR,
  "filename" VARCHAR,
  "ltime" VARCHAR
);

KM I 2019

@usgov.doi_gov_glacier_bay_alaska_murrelet_survey_external_wa_acaab4d9.km_i_2019

18.84 KB
1 row
33 columns


CREATE TABLE km_i_2019 (
  "type" VARCHAR,
  "waypoint_id" VARCHAR,
  "latitude" BIGINT,
  "longitude" BIGINT,
  "y_proj" VARCHAR,
  "x_proj" VARCHAR,
  "timestamp" VARCHAR,
  "display" VARCHAR,
  "symbol" VARCHAR,
  "unused1" VARCHAR,
  "dist" VARCHAR,
  "prox_index" VARCHAR,
  "color" VARCHAR,
  "altitude" VARCHAR,
  "depth" VARCHAR,
  "temp" VARCHAR,
  "time" VARCHAR,
  "wpt_class" VARCHAR,
  "sub_class" VARCHAR,
  "attrib" VARCHAR,
  "link" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "address" VARCHAR,
  "facility" VARCHAR,
  "crossroad" VARCHAR,
  "unused2" VARCHAR,
  "ete" VARCHAR,
  "dtype" VARCHAR,
  "model" VARCHAR,
  "filename" VARCHAR,
  "ltime" VARCHAR
);