Characterization Of Human Uses And The Socioeconomic Dimensions, California North Coast MPA Baseline Study, 1992 To 2014 by US Government | Environmental and Climate Sciences

About this Dataset

Characterization Of Human Uses And The Socioeconomic Dimensions, California North Coast MPA Baseline Study, 1992 To 2014

The primary goal of this project was to inform long-term marine protected area (MPA) monitoring efforts by gathering up-to-date socioeconomic information to illustrate historical trends, establish a post MPA baseline, and assess initial changes since MPA implementation for the commercial fishing fleet in the North Coast region of California. To accomplish this goal our research team conducted extensive community outreach and engagement in the region and conducted in-person interviewed CPFV operators to gather post MPA baseline socioeconomic data and spatial fishing data for the year 2013. Additional to the interview data gathered, we summarized CPFV logbook data from 1992 to 2014 obtained from the California Department of Fish and Wildlife (CDFW) to explore historical economic trends and initial changes in North Coast fisheries. This data package include the CPFV logbook data from 1992-20142 provided by California Department of Fish and Wildlife summarized to the port and region level; select summarized survey data from CPFV operator interviews about their operations in the 2013 calendar year, and samples of the spatial data available on the post MPA (2013) fishing grounds at region-fishery and port-fishery scales.
Organization: State of California
Last updated: 2021-09-08T16:17:45.053044
Tags: 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, baseline, biota, california, california-ocean-protection-council, commercial-fishing, consumptive-uses, ecological-data, environmental, fisheries, human-uses-data, maps, marine-protected-area, monitoring, mpa, north-coast, oceans, recreational-fishing, socioeconomic

Tables

MPA Baseline Program Information - North Coast

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.mpa_baseline_program_information_north_coast

23.67 KB
11 rows
14 columns


CREATE TABLE mpa_baseline_program_information_north_coast (
  "nc_project_short_code" VARCHAR,
  "nc_project_title" VARCHAR,
  "consumptive" BIGINT,
  "nonconsumptive" BIGINT,
  "deep" BIGINT,
  "estuarinewetland" BIGINT,
  "kelpshallowrock" BIGINT,
  "middepthrock" BIGINT,
  "nearshorepelagic" BIGINT,
  "rockyintertidal" BIGINT,
  "softintertidal" BIGINT,
  "softsubtidal" BIGINT,
  "contextual" BIGINT,
  "sc_project_description" VARCHAR
);

MPA Baseline Program Information - North Coast - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.mpa_baseline_program_information_north_coast_metadata

4.51 KB
14 rows
2 columns


CREATE TABLE mpa_baseline_program_information_north_coast_metadata (
  "nc_mpa_baselineprograminformation_lookuptable_csv" VARCHAR,
  "lookup_containing_a_list_of_north_coast_sc_marine_prot_f4f7dfc5" VARCHAR
);

MPA Boundary Details - North Coast

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.mpa_boundary_details_north_coast

15.31 KB
91 rows
13 columns


CREATE TABLE mpa_boundary_details_north_coast (
  "mpa_name" VARCHAR,
  "mpa_designation" VARCHAR,
  "mpa_study_region" VARCHAR,
  "subsection" BIGINT,
  "pretext" VARCHAR,
  "coordinate" VARCHAR,
  "posttext" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "latddm" VARCHAR,
  "longddm" VARCHAR,
  "sortorder" BIGINT,
  "positionid" VARCHAR
);

MPA Boundary Details - North Coast - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.mpa_boundary_details_north_coast_metadata

4.71 KB
12 rows
2 columns


CREATE TABLE mpa_boundary_details_north_coast_metadata (
  "mpa_name" VARCHAR,
  "the_name_of_the_california_marine_protected_area_descr_043f4de7" VARCHAR
);

Commercial Fishing - Species Lookup Table

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_species_lookup_table

16.67 KB
398 rows
4 columns


CREATE TABLE commercial_fishing_species_lookup_table (
  "project_short_code" VARCHAR,
  "market_code" BIGINT,
  "species_common_name" VARCHAR,
  "name_scientific" VARCHAR
);

Commercial Fishing - Species Lookup Table - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_species_lookup_table_metadata

6.88 KB
11 rows
8 columns


CREATE TABLE commercial_fishing_species_lookup_table_metadata (
  "table_name_ca_state_port_groupings_table_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

Commercial Fishing - Summarized Survey Data 2013

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_summarized_survey_data_2013

6.06 KB
80 rows
6 columns


CREATE TABLE commercial_fishing_summarized_survey_data_2013 (
  "project_short_code" VARCHAR,
  "q_number" BIGINT,
  "question" VARCHAR,
  "fishery" VARCHAR,
  "summarized_data" VARCHAR,
  "sample_size" VARCHAR
);

Commercial Fishing - Summarized Survey Data 2013 - Metatadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_summarized_survey_data_2013_metatadata

9.63 KB
11 rows
12 columns


CREATE TABLE commercial_fishing_summarized_survey_data_2013_metatadata (
  "table_name_nc_comm_fisheries_summarized_survey_data_2013_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR
);

Commercial Fishing - Spatial Change Maps - Pre And Post MPA - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_spatial_change_maps_pre_and_post_mp_e2e304fb

2.27 KB
3 rows
1 column


CREATE TABLE commercial_fishing_spatial_change_maps_pre_and_post_mp_e2e304fb (
  "file_name_nc_comm_maps_2013_pdf" VARCHAR
);

Commercial Fishing - Fisheries Of Interest Port Summaries - 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_fisheries_of_interest_port_summarie_4409e351

23.71 KB
1242 rows
10 columns


CREATE TABLE commercial_fishing_fisheries_of_interest_port_summarie_4409e351 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port_group" VARCHAR,
  "fishery" VARCHAR,
  "gear" VARCHAR,
  "condition" VARCHAR,
  "count_of_fishermen" VARCHAR,
  "pounds" VARCHAR,
  "ex_vessel_revenue" VARCHAR,
  "average_price_lbs" VARCHAR
);

Commercial Fishing - Fisheries Of Interest Port Summaries - 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_fisheries_of_interest_port_summarie_c02520fc

15.06 KB
11 rows
20 columns


CREATE TABLE commercial_fishing_fisheries_of_interest_port_summarie_c02520fc (
  "n__name_nc_port_comm_fisheriesofinterest_summary_1992_2014" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR
);

Commercial Fishing - Fisheries Of Interest Regional Summary - 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_fisheries_of_interest_regional_summ_5795dffe

12.78 KB
207 rows
9 columns


CREATE TABLE commercial_fishing_fisheries_of_interest_regional_summ_5795dffe (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "fishery" VARCHAR,
  "gear" VARCHAR,
  "condition" VARCHAR,
  "count_of_fishermen" VARCHAR,
  "pounds" VARCHAR,
  "ex_vessel_revenue" VARCHAR,
  "average_price_lbs" VARCHAR
);

Commercial Fishing - Fisheries Of Interest Regional Summary - 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_fisheries_of_interest_regional_summ_1a061e91

13.8 KB
11 rows
18 columns


CREATE TABLE commercial_fishing_fisheries_of_interest_regional_summ_1a061e91 (
  "n__name_nc_region_comm_fisheriesofinterest_summary_1992_2014" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR
);

Commercial Fishing - All Fisheries Summary - 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_all_fisheries_summary_1992_2014

5.1 KB
23 rows
5 columns


CREATE TABLE commercial_fishing_all_fisheries_summary_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "count_of_fishermen" BIGINT,
  "ex_vessel_revenue" VARCHAR,
  "pounds" DOUBLE
);

Commercial Fishing - All Fisheries Summary - 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_all_fisheries_summary_1992_2014_metadata

8.05 KB
11 rows
10 columns


CREATE TABLE commercial_fishing_all_fisheries_summary_1992_2014_metadata (
  "table_name_nc_region_comm_summary_1992_2014_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

Landing Receipt Records - Count Of Fishermen 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.landing_receipt_records_count_of_fishermen_1992_2014

19.51 KB
5934 rows
7 columns


CREATE TABLE landing_receipt_records_count_of_fishermen_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "fishery_group" VARCHAR,
  "gear_group" VARCHAR,
  "condition_group" VARCHAR,
  "count_of_fishermen" VARCHAR,
  "display_in_data_viewer" VARCHAR
);

Landing Receipt Records - Count Of Fishermen 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.landing_receipt_records_count_of_fishermen_1992_2014_metadata

10.73 KB
11 rows
14 columns


CREATE TABLE landing_receipt_records_count_of_fishermen_1992_2014_metadata (
  "table_name_ca_state_comm_fishery_fishermen_count_1992_2014_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR
);

Landing Receipt Records - Count Of Fishermen By Port 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.landing_receipt_records_count_of_fishermen_by_port_1992_2014

6.13 KB
552 rows
4 columns


CREATE TABLE landing_receipt_records_count_of_fishermen_by_port_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port_group" VARCHAR,
  "count_of_fishermen" BIGINT
);

Landing Receipt Records - Count Of Fishermen By Port 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.landing_receipt_records_count_of_fishermen_by_port_199_1ded7545

6.94 KB
11 rows
8 columns


CREATE TABLE landing_receipt_records_count_of_fishermen_by_port_199_1ded7545 (
  "table_name_ca_state_comm_port_fishermen_count_1992_2014_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

Landing Receipt Records - Landings Data By Port 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.landing_receipt_records_landings_data_by_port_1992_2014

434.8 KB
35051 rows
10 columns


CREATE TABLE landing_receipt_records_landings_data_by_port_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port_group" VARCHAR,
  "fishery_group" VARCHAR,
  "gear_group" VARCHAR,
  "condition_group" VARCHAR,
  "pounds" VARCHAR,
  "ex_vessel_revenue" VARCHAR,
  "count_of_fishermen" VARCHAR,
  "display_in_data_viewer" VARCHAR
);

Landing Receipt Records - Landings Data By Port 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.landing_receipt_records_landings_by_port_1992_2014_metadata

14.7 KB
11 rows
20 columns


CREATE TABLE landing_receipt_records_landings_by_port_1992_2014_metadata (
  "n__name_ca_state_comm_port_fishery_landings_data_1992_2014" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR
);

CPFV Logbook Records - Fish Caught By Port 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_logbook_records_fish_caught_by_port_1992_2014

33.96 KB
6667 rows
5 columns


CREATE TABLE cpfv_logbook_records_fish_caught_by_port_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port_group" VARCHAR,
  "species" VARCHAR,
  "number_caught" VARCHAR
);

CPFV Logbook Records - Fish Caught By Port 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_logbook_records_fish_caught_by_port_1992_2014_metadata

7.95 KB
11 rows
10 columns


CREATE TABLE cpfv_logbook_records_fish_caught_by_port_1992_2014_metadata (
  "table_name_ca_state_cpfv_port_fish_kept_1992_2014_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

CPFV Logbook Records - Effort By Port 1995 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_logbook_records_effort_by_port_1995_2014

29.07 KB
2478 rows
7 columns


CREATE TABLE cpfv_logbook_records_effort_by_port_1995_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port_group" VARCHAR,
  "target_fishery" VARCHAR,
  "number_of_vessels" VARCHAR,
  "number_of_anglers" VARCHAR,
  "number_of_trips" VARCHAR
);

CPFV Logbook Records - Effort By Port 1995 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_logbook_records_effort_by_port_1995_2014_metadata

11.47 KB
31 rows
15 columns


CREATE TABLE cpfv_logbook_records_effort_by_port_1995_2014_metadata (
  "n__name_ca_state_cpfv_port_fishery_vessels_anglers_tri_d064e165" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR
);

CPFV Logbook Records - Number Of Vessels By Port 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_logbook_records_number_of_vessels_by_port_1992_2014

5.04 KB
493 rows
4 columns


CREATE TABLE cpfv_logbook_records_number_of_vessels_by_port_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port_group" VARCHAR,
  "number_of_vessels" VARCHAR
);

CPFV Logbook Records - Number Of Vessels By Port 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_logbook_records_number_of_vessels_by_port_1992_20_ca4c6dc3

7.55 KB
31 rows
9 columns


CREATE TABLE cpfv_logbook_records_number_of_vessels_by_port_1992_20_ca4c6dc3 (
  "table_name_ca_state_cpfv_port_vessel_count_1992_2014_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);

CPFV Logbook Records - Number Of Fish Kept Statewide 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_logbook_records_number_of_fish_kept_statewide_1992_2014

7.74 KB
585 rows
4 columns


CREATE TABLE cpfv_logbook_records_number_of_fish_kept_statewide_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "species" VARCHAR,
  "number_caught" BIGINT
);

CPFV Logbook Records - Number Of Fish Kept Statewide 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_logbook_records_number_of_fish_kept_statewide_199_bb52d456

6.92 KB
11 rows
8 columns


CREATE TABLE cpfv_logbook_records_number_of_fish_kept_statewide_199_bb52d456 (
  "table_name_ca_state_cpfv_state_fish_kept_1992_2014_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

California Fisheries Data Explorer - Gear Grouping

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.california_fisheries_data_explorer_gear_grouping

26.42 KB
4512 rows
10 columns


CREATE TABLE california_fisheries_data_explorer_gear_grouping (
  "project_short_code" VARCHAR,
  "species_code" BIGINT,
  "species_name" VARCHAR,
  "commercial_species_group" VARCHAR,
  "gear_code" BIGINT,
  "gear_description" VARCHAR,
  "gear_group" VARCHAR,
  "commercial_data_viewer" VARCHAR,
  "cpfv_species_group" VARCHAR,
  "cpfv_data_viewer" VARCHAR
);

California Fisheries Data Explorer - Gear Grouping - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.california_fisheries_data_explorer_gear_grouping_metadata

15.34 KB
11 rows
20 columns


CREATE TABLE california_fisheries_data_explorer_gear_grouping_metadata (
  "table_name_ca_state_fishery_gear_groupings_table_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR
);

California Fisheries Data Explorer - Species Lookup Table

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.california_fisheries_data_explorer_species_lookup_table

22.87 KB
398 rows
10 columns


CREATE TABLE california_fisheries_data_explorer_species_lookup_table (
  "project_short_code" VARCHAR,
  "market_code" BIGINT,
  "species_common_name" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR
);

California Fisheries Data Explorer - Species Lookup Table - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.california_fisheries_explorer_species_lookup_metadata

14.04 KB
11 rows
20 columns


CREATE TABLE california_fisheries_explorer_species_lookup_metadata (
  "table_name_ca_state_port_groupings_table_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR
);

California Fisheries Data Explorer - Port Grouping

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.california_fisheries_data_explorer_port_grouping

9.52 KB
102 rows
7 columns


CREATE TABLE california_fisheries_data_explorer_port_grouping (
  "project_short_code" VARCHAR,
  "port_name" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "port_group" VARCHAR,
  "california_region" VARCHAR,
  "port_code" BIGINT
);

California Fisheries Data Explorer - Port Grouping - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.california_fisheries_data_explorer_port_grouping_metadata

10.57 KB
11 rows
14 columns


CREATE TABLE california_fisheries_data_explorer_port_grouping_metadata (
  "n__name_ca_state_port_groupings_and_locations_lookup_table" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR
);

CPFV - Survey Data 2013

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_survey_data_2013

5.16 KB
21 rows
6 columns


CREATE TABLE cpfv_survey_data_2013 (
  "project_short_code" VARCHAR,
  "q_number" BIGINT,
  "question" VARCHAR,
  "region_port" VARCHAR,
  "summarized_data" VARCHAR,
  "sample_size" VARCHAR
);

CPFV - Survey Data 2013 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_survey_data_2013_metadata

9.41 KB
11 rows
12 columns


CREATE TABLE cpfv_survey_data_2013_metadata (
  "table_name_nc_cpfv_fisheries_summarized_survey_data_2013_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR
);

CPFV - Maps 2013 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_maps_2013_metadata

2.18 KB
3 rows
1 column


CREATE TABLE cpfv_maps_2013_metadata (
  "file_name_nc_comm_maps_2013_pdf" VARCHAR
);

CPFV - Number Of Fish Kept By Port

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_number_of_fish_kept_by_port

7.55 KB
791 rows
5 columns


CREATE TABLE cpfv_number_of_fish_kept_by_port (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port" VARCHAR,
  "species" VARCHAR,
  "number_kept" VARCHAR
);

CPFV - Number Of Fish Kept By Port - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_number_of_fish_kept_by_port_metadata

8 KB
11 rows
10 columns


CREATE TABLE cpfv_number_of_fish_kept_by_port_metadata (
  "table_name_nc_cpfv_port_fish_kept_1992_2014_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR
);

CPFV - Fishery Effort By Port 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_fishery_effort_by_port_1992_2014

10.76 KB
1332 rows
7 columns


CREATE TABLE cpfv_fishery_effort_by_port_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port" VARCHAR,
  "target_fishery" VARCHAR,
  "number_of_vessels" VARCHAR,
  "number_of_trips" VARCHAR,
  "number_of_anglers" VARCHAR
);

CPFV - Fishery Effort By Port 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_fishery_effort_by_port_1992_2014_metadata

12.57 KB
31 rows
17 columns


CREATE TABLE cpfv_fishery_effort_by_port_1992_2014_metadata (
  "n__name_nc_cpfv_port_fishery_vessels_anglers_trips_1992_2014" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR
);

CPFV - Total Effort By Port 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_total_effort_by_port_1992_2014

6.01 KB
111 rows
6 columns


CREATE TABLE cpfv_total_effort_by_port_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port" VARCHAR,
  "number_of_vessels" VARCHAR,
  "number_of_anglers" VARCHAR,
  "number_of_trips" VARCHAR
);

CPFV - Total Effort By Port 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_total_effort_by_port_1992_2014_metadata

11.19 KB
31 rows
15 columns


CREATE TABLE cpfv_total_effort_by_port_1992_2014_metadata (
  "table_name_nc_cpfv_port_vessels_anglers_trips_1992_2014_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR
);

CPFV - Number Of Fish Kept By Region

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_number_of_fish_kept_by_region

5.31 KB
300 rows
4 columns


CREATE TABLE cpfv_number_of_fish_kept_by_region (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "species" VARCHAR,
  "number_kept" BIGINT
);

CPFV - Number Of Fish Kept By Region - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_number_of_fish_kept_by_region_metadata

6.76 KB
11 rows
8 columns


CREATE TABLE cpfv_number_of_fish_kept_by_region_metadata (
  "table_name_nc_cpfv_region_fish_kept_1992_2014_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

CPFV - Fishery Effort By Region 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_fishery_effort_by_region_1992_2014

7.06 KB
276 rows
6 columns


CREATE TABLE cpfv_fishery_effort_by_region_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "target_fishery" VARCHAR,
  "number_of_vessels" BIGINT,
  "number_of_anglers" BIGINT,
  "number_of_trips" BIGINT
);

CPFV - Fishery Effort By Region 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_fishery_effort_by_region_1992_2014_metadata

11.35 KB
31 rows
15 columns


CREATE TABLE cpfv_fishery_effort_by_region_1992_2014_metadata (
  "n__name_nc_cpfv_region_fishery_vessels_anglers_trips_1992_2014" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR
);

CPFV - Total Effort By Region 1992 -2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_total_effort_by_region_1992_2014

4.87 KB
23 rows
5 columns


CREATE TABLE cpfv_total_effort_by_region_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "number_of_vessels" BIGINT,
  "number_of_trips" BIGINT,
  "number_of_anglers" BIGINT
);

CPFV - Total Effort By Region 1992 -2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_total_effort_by_region_1992_2014_metadata

9.96 KB
31 rows
13 columns


CREATE TABLE cpfv_total_effort_by_region_1992_2014_metadata (
  "table_name_nc_cpfv_port_vessels_anglers_trips_1992_2014_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR
);

CPFV - Port Grouping

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_port_grouping

6.01 KB
15 rows
7 columns


CREATE TABLE cpfv_port_grouping (
  "project_short_code" VARCHAR,
  "port_name" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "port_group" VARCHAR,
  "california_region" VARCHAR,
  "port_code" BIGINT
);

CPFV - Port Grouping - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_port_grouping_metadata

10.57 KB
11 rows
14 columns


CREATE TABLE cpfv_port_grouping_metadata (
  "table_name_nc_port_groupings_and_locations_lookup_table_csv" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR
);