NCCN Fish Assemblages Monitoring Data Package, 1994-2011
Department of the Interior
@usgov.doi_gov_nccn_fish_assemblages_monitoring_data_package_1994_2011
Department of the Interior
@usgov.doi_gov_nccn_fish_assemblages_monitoring_data_package_1994_2011
CREATE TABLE nccn_fishassemblages_eventssnorkel (
"park_code" VARCHAR,
"location_code" VARCHAR,
"location_name" VARCHAR,
"start_date" TIMESTAMP,
"survey_type" VARCHAR,
"replicate_num" BIGINT,
"rm_start" DOUBLE,
"rm_end" DOUBLE,
"survey_extent" VARCHAR,
"reach_completed" VARCHAR,
"outside_reach" VARCHAR,
"km_surveyed" DOUBLE,
"km_source" VARCHAR,
"start_time" VARCHAR,
"end_time" VARCHAR,
"water_temp_c" DOUBLE,
"water_obs_time" VARCHAR,
"flow_est" VARCHAR,
"flow_cfs" DOUBLE,
"visibility" VARCHAR,
"is_excluded" VARCHAR,
"river_section" VARCHAR,
"species_code" VARCHAR,
"scientific_name" VARCHAR,
"common_name" VARCHAR,
"tsn" DOUBLE,
"accepted_scientific_name" VARCHAR,
"accepted_tsn" DOUBLE,
"taxon_rank" VARCHAR,
"size_class" VARCHAR,
"tally" BIGINT,
"n_hatchery" BIGINT,
"n_wild" BIGINT,
"n_unknown" BIGINT,
"fry_present" VARCHAR
);
CREATE TABLE nccn_fishassemblages_locations (
"park_code" VARCHAR,
"location_code" VARCHAR,
"location_name" VARCHAR,
"location_type" VARCHAR,
"location_status" VARCHAR,
"upstream_rm" DOUBLE,
"downstream_rm" DOUBLE,
"park_region" VARCHAR,
"watercourse_name" VARCHAR,
"utm_east" BIGINT,
"utm_north" BIGINT,
"utm_zone" VARCHAR,
"utm_datum" VARCHAR,
"decimal_latitude" DOUBLE,
"decimal_longitude" DOUBLE,
"decimal_degrees_datum" VARCHAR
);
Anyone who has the link will be able to view this.