Pacific Island Network Molokai Landbird Surveys Dataset 2021
Department of the Interior
@usgov.doi_gov_pacific_island_network_molokai_landbird_surveys_2021
Department of the Interior
@usgov.doi_gov_pacific_island_network_molokai_landbird_surveys_2021
CREATE TABLE tbl_stations (
"station_id" VARCHAR,
"transect_id" VARCHAR,
"station" VARCHAR,
"lat_final" DOUBLE,
"lat_dir" VARCHAR,
"long_final" DOUBLE,
"long_dir" VARCHAR,
"geo_datum" VARCHAR,
"updated_date" TIMESTAMP,
"updated_by" VARCHAR,
"updated_notes" VARCHAR
);
CREATE TABLE tbl_sites (
"site_id" VARCHAR,
"unit_code" VARCHAR,
"site_name" VARCHAR
);
CREATE TABLE tbl_observations (
"observation_id" VARCHAR,
"event_id" VARCHAR,
"species_id" VARCHAR
);
CREATE TABLE tbl_events (
"event_id" VARCHAR,
"station_id" VARCHAR,
"protocol_name" VARCHAR,
"start_date" TIMESTAMP,
"start_time" VARCHAR,
"end_time" VARCHAR,
"repeat_sample" BIGINT,
"habitat_date" VARCHAR,
"event_notes" VARCHAR,
"entered_by" VARCHAR,
"entered_date" TIMESTAMP,
"updated_by" VARCHAR,
"updated_date" TIMESTAMP,
"verified" BIGINT,
"verified_by" VARCHAR,
"verified_date" TIMESTAMP,
"certified" BIGINT,
"certified_by" VARCHAR,
"certified_date" TIMESTAMP,
"qa_notes" VARCHAR
);
CREATE TABLE tbl_contacts (
"contact_id" VARCHAR,
"last_name" VARCHAR,
"first_name" VARCHAR,
"middle_init" VARCHAR,
"obs_code" VARCHAR,
"organization" VARCHAR,
"position_title" VARCHAR,
"address_type" VARCHAR,
"address" VARCHAR,
"address2" VARCHAR,
"city" VARCHAR,
"state_code" VARCHAR,
"zip_code" DOUBLE,
"country" VARCHAR,
"email_address" VARCHAR,
"work_phone" VARCHAR,
"work_extension" VARCHAR,
"contact_notes" VARCHAR
);
CREATE TABLE tbl_detections (
"detection_id" VARCHAR,
"observation_id" VARCHAR,
"distance" DOUBLE,
"detection" BIGINT
);
CREATE TABLE tbl_locations (
"location_id" VARCHAR,
"site_id" VARCHAR,
"island" VARCHAR,
"loc_name" VARCHAR
);
CREATE TABLE tbl_habitat (
"habitat_id" VARCHAR,
"event_id" VARCHAR,
"canopy_cover" VARCHAR,
"canopy_height" VARCHAR,
"canopy_comp" VARCHAR,
"understory_comp" VARCHAR,
"noted_canopy_spp_common" VARCHAR,
"noted_canopy_spp_scientific" VARCHAR
);
CREATE TABLE xref_event_contacts (
"event_id" VARCHAR,
"contact_id" VARCHAR,
"contact_role" VARCHAR
);
CREATE TABLE tbl_species_alternate_names (
"species_id" VARCHAR,
"alternate_name" VARCHAR,
"alternate_type" VARCHAR,
"updated_date" TIMESTAMP,
"update_by" VARCHAR,
"update_notes" VARCHAR
);
CREATE TABLE tlu_species (
"species_id" VARCHAR,
"family" VARCHAR,
"scientific_name" VARCHAR,
"common_name" VARCHAR,
"species_code" VARCHAR,
"source" VARCHAR,
"te_status" VARCHAR,
"habitat" VARCHAR,
"bna_account" VARCHAR,
"tsn" DOUBLE
);
CREATE TABLE tbl_event_details (
"event_details_id" VARCHAR,
"event_id" VARCHAR,
"cloud" BIGINT,
"rain" BIGINT,
"wind" BIGINT,
"gust" BIGINT,
"p1" BIGINT,
"p2" BIGINT,
"p3" BIGINT,
"p4" BIGINT,
"p5" BIGINT,
"p6" BIGINT,
"p7" BIGINT,
"p8" BIGINT,
"p9" BIGINT,
"p10" BIGINT
);
CREATE TABLE tbl_transects (
"transect_id" VARCHAR,
"location_id" VARCHAR,
"core_area" VARCHAR,
"transect_type" VARCHAR,
"transect" VARCHAR,
"updated_date" TIMESTAMP,
"updated_by" VARCHAR,
"updated_notes" VARCHAR
);
Anyone who has the link will be able to view this.