About this Dataset

ARCN/CAKN Landbirds Monitoring: Off-road Cumulative Data (2015 To 2024)

Cumulative off-road data for ARCN and CAKN for 2015-2024.
Organization: Department of the Interior
Last updated: 2025-07-03T12:55:10.964251
Tags: landbirds, passerines

Tables

Grids50m All

@usgov.doi_gov_arcn_cakn_landbirds_monitoring_off_road_cumula_3c93ab30.grids50m_all

10.31 MB
398304 rows
25 columns


CREATE TABLE grids50m_all (
  "sa" BIGINT,
  "d_rtset1" DOUBLE,
  "d_rtset2" DOUBLE,
  "d_rtset3" DOUBLE,
  "near_rtset1" BIGINT,
  "near_rtset2" BIGINT,
  "near_rtset3" BIGINT,
  "near_rtid1" BIGINT,
  "near_rtid2" BIGINT,
  "near_rtid3" BIGINT,
  "rtset1_intersect" VARCHAR,
  "rtset2_intersect" VARCHAR,
  "rtset3_intersect" VARCHAR,
  "pixelid" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE,
  "cellid" BIGINT,
  "d_rtset4" VARCHAR,
  "d_rtset5" VARCHAR,
  "near_rtset4" VARCHAR,
  "near_rtset5" VARCHAR,
  "near_rtid4" VARCHAR,
  "near_rtid5" VARCHAR,
  "rtset4_intersect" VARCHAR,
  "rtset5_intersect" VARCHAR
);

Offroad Observation Metadata

@usgov.doi_gov_arcn_cakn_landbirds_monitoring_off_road_cumula_3c93ab30.offroad_observation_metadata

4.69 KB
31 rows
3 columns


CREATE TABLE offroad_observation_metadata (
  "variable_name" VARCHAR,
  "description" VARCHAR,
  "type" VARCHAR
);

Offroad Survey Metadata

@usgov.doi_gov_arcn_cakn_landbirds_monitoring_off_road_cumula_3c93ab30.offroad_survey_metadata

3.92 KB
14 rows
3 columns


CREATE TABLE offroad_survey_metadata (
  "variable_name" VARCHAR,
  "description" VARCHAR,
  "type" VARCHAR
);

Surveys2015–2024

@usgov.doi_gov_arcn_cakn_landbirds_monitoring_off_road_cumula_3c93ab30.surveys2015_2024

81.03 KB
3436 rows
16 columns


CREATE TABLE surveys2015_2024 (
  "sa" BIGINT,
  "studyarea" VARCHAR,
  "year" BIGINT,
  "route" VARCHAR,
  "cell_dategps" VARCHAR,
  "cellobs" BIGINT,
  "juldate" BIGINT,
  "visit" BIGINT,
  "gps" VARCHAR,
  "effort" DOUBLE,
  "time000" DOUBLE,
  "timeadjcakn" DOUBLE,
  "observerid" BIGINT,
  "noise" VARCHAR,
  "rt_dategps" VARCHAR,
  "rtvisit" VARCHAR
);