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: 2025-09-14T20:22:48.772054
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

21.39 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

44.77 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

19.29 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

19.29 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

19.29 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

19.29 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

19.29 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

19.29 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

19.29 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
);