About this Dataset

Spatial And Economic Human Uses, California South Coast MPA Baseline Study, 1992 To 2012

This study addresses the South Coast MPA Baseline Program objectives by describing human use patterns across the study region and establishing initial data points for long-term tracking of conditions and trends in the South Coast. This study is also a part of a three-part study conducted by Point 97 to provide baseline estimates of the quantity, spatial distribution, and economic value of human uses—specifically human use in three specific sectors: coastal recreation, commercial fishing, and commercial passenger fishing vessels in the South Coast region.
The South Coast (SC) region coastal recreation survey was launched in May of 2012. In an effort to capture seasonal variations in coastal use, we collected data on the respondent’s most recent coastal trip, and deployed the survey in four survey “waves” over a one-year period. Data collection was completed in March 2013, and the data were then subsequently analyzed and synthesized. In the survey, respondents were asked to recount details of their coastal visitation trips over the previous 12 months and of their last trip, including information about the number of trips taken, participation in recreational activities, the location of activities, and expenditures made. This data package include the raw survey data and a sample PDF map of the spatial data collected.
Organization: State of California
Last updated: 2021-09-08T16:18:12.031804
Tags: 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, baseline, biota, california, california-ocean-protection-council, commercial-fishing, commercial-fishing-passenger-vessels, cpfv, ecological-data, environmental, human-use-data, maps, marine-protected-area, monitoring, mpa, ocean-recreation, oceans, recreational-fishing, south-coast

Tables

Coastal Recreation - Answer Key Lookup Table

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.coastal_recreation_answer_key_lookup_table

10.22 kB
848 rows
3 columns

CREATE TABLE coastal_recreation_answer_key_lookup_table (
  "table_name" VARCHAR,
  "south_coast_coastal_recreation_raw_survey_data" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2
);

Coastal Recreation - Question Lookup Table

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.coastal_recreation_question_lookup_table

13.74 kB
439 rows
2 columns

CREATE TABLE coastal_recreation_question_lookup_table (
  "table_name" VARCHAR,
  "south_coast_coastal_recreation_raw_survey_data" VARCHAR
);

Coastal Recreation - Raw Survey Data

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.coastal_recreation_raw_survey_data

1.01 MB
4,492 rows
434 columns

CREATE TABLE coastal_recreation_raw_survey_data (
  "wave" VARCHAR,
  "caseid_alt" BIGINT,
  "caseid" BIGINT,
  "weight1" VARCHAR,
  "weight2" DOUBLE,
  "tm_start" TIMESTAMP,
  "tm_finish" TIMESTAMP,
  "duration" BIGINT,
  "offpanel" BIGINT,
  "screener1" VARCHAR,
  "screener2" VARCHAR,
  "q1" VARCHAR,
  "q2a" VARCHAR,
  "q2b" VARCHAR,
  "q3a" VARCHAR,
  "q3b" VARCHAR,
  "q3c" VARCHAR,
  "q3d" VARCHAR,
  "q3e" VARCHAR,
  "q3f" VARCHAR,
  "q3g" VARCHAR,
  "q3h" VARCHAR,
  "q3i" VARCHAR,
  "q3j" VARCHAR,
  "q3k" VARCHAR,
  "q3l" VARCHAR,
  "q3m" VARCHAR,
  "q3n" VARCHAR,
  "q3o" VARCHAR,
  "q3p" VARCHAR,
  "q3q" VARCHAR,
  "q3r" VARCHAR,
  "q3s" VARCHAR,
  "q3t" VARCHAR,
  "q3u" VARCHAR,
  "q3v" VARCHAR,
  "q3w" VARCHAR,
  "q3x" VARCHAR,
  "q3y" VARCHAR,
  "q3z" VARCHAR,
  "q3aa" VARCHAR,
  "q3bb" VARCHAR,
  "q3cc" VARCHAR,
  "q3dd" VARCHAR,
  "q3_ref" VARCHAR,
  "q3dd_other" VARCHAR,
  "sum_of_q4_minus_q2b" VARCHAR,
  "q4_1" VARCHAR,
  "q4_2" VARCHAR,
  "q4_3" VARCHAR,
  "q4_4" VARCHAR,
  "q4_5" VARCHAR,
  "q4a" VARCHAR,
  "q5" VARCHAR,
  "q6" VARCHAR,
  "q6a_all" VARCHAR,
  "q6a_1" VARCHAR,
  "q6a_2" VARCHAR,
  "q6a_3" VARCHAR,
  "q6a_other" VARCHAR,
  "q7" VARCHAR,
  "q8_1" VARCHAR,
  "q8_2" VARCHAR,
  "q8_3" VARCHAR,
  "q8_4" VARCHAR,
  "q8_5" VARCHAR,
  "q8_6" VARCHAR,
  "q8_7" VARCHAR,
  "q8_ref" VARCHAR,
  "q8_other" VARCHAR,
  "q9" VARCHAR,
  "q9_other" VARCHAR,
  "q10" VARCHAR,
  "q11" VARCHAR,
  "q12" VARCHAR,
  "q11_q12_ca_res" VARCHAR  -- Q11-Q12, CA Res,
  "q13a" VARCHAR,
  "q13b" VARCHAR,
  "q13c" VARCHAR,
  "q13d" VARCHAR,
  "q13e" VARCHAR,
  "q13f" VARCHAR,
  "q13g" VARCHAR,
  "q13h" VARCHAR,
  "q13i" VARCHAR,
  "q13j" VARCHAR,
  "q13k" VARCHAR,
  "q13l" VARCHAR,
  "q13m" VARCHAR,
  "q13n" VARCHAR,
  "q13o" VARCHAR,
  "q13p" VARCHAR,
  "q13q" VARCHAR,
  "q13r" VARCHAR,
  "q13s" VARCHAR,
  "q13t" VARCHAR,
  "q13u" VARCHAR,
  "q13v" VARCHAR,
  "q13w" VARCHAR,
  "q13x" VARCHAR
);

Commercial Fishing - Port Landings 1992-2012

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.commercial_fishing_port_landings_1992_2012

56.38 kB
2,511 rows
11 columns

CREATE TABLE commercial_fishing_port_landings_1992_2012 (
  "year" DOUBLE,
  "port" VARCHAR,
  "fishery" VARCHAR,
  "gear" VARCHAR,
  "condition" VARCHAR,
  "fishery_of_interest" VARCHAR,
  "pounds" VARCHAR,
  "revenue" VARCHAR,
  "average_price" VARCHAR,
  "n__of_fishermen" DOUBLE  -- # Of Fishermen,
  "count_of_landings" VARCHAR
);

Commercial Fishing- Region Landings 1992-2012

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.commercial_fishing_region_landings_1992_2012

21.68 kB
358 rows
11 columns

CREATE TABLE commercial_fishing_region_landings_1992_2012 (
  "year" DOUBLE,
  "region" VARCHAR,
  "fishery" VARCHAR,
  "gear" VARCHAR,
  "condition" VARCHAR,
  "fishery_of_interest" VARCHAR,
  "pounds" VARCHAR,
  "revenue" VARCHAR,
  "average_price" VARCHAR,
  "n__of_fishermen" DOUBLE  -- # Of Fishermen,
  "count_of_landings" VARCHAR
);

Commercial Fishing- Summarized Survey Data 2012

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.commercial_fishing_summarized_survey_data_2012

5.77 kB
125 rows
5 columns

CREATE TABLE commercial_fishing_summarized_survey_data_2012 (
  "q_number" BIGINT,
  "question" VARCHAR,
  "fishery" VARCHAR,
  "summarized_data" DOUBLE,
  "sample_size" VARCHAR
);

Commercial Fishing- Summarized Survey Data 2012 - Lookup Table

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.commercial_fishing_summarized_survey_data_2012_lookup_table

3.65 kB
10 rows
2 columns

CREATE TABLE commercial_fishing_summarized_survey_data_2012_lookup_table (
  "table_name" VARCHAR,
  "sc_commercial_fisheries_summarized_survey_data" VARCHAR
);

CPFV - Logbook Data 2000-2012

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.cpfv_logbook_data_2000_2012

34.13 kB
6,545 rows
6 columns

CREATE TABLE cpfv_logbook_data_2000_2012 (
  "species_name" VARCHAR,
  "year" BIGINT,
  "species_group" VARCHAR,
  "number_of_fish_kept" DOUBLE,
  "port_name" VARCHAR,
  "port_group" VARCHAR
);

CPFV - Logbook Data 2000-2012 - Lookup Table

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.cpfv_logbook_data_2000_2012_lookup_table

3.12 kB
11 rows
2 columns

CREATE TABLE cpfv_logbook_data_2000_2012_lookup_table (
  "table_name" VARCHAR,
  "sc_cpfv_catch_logbook_data_2000_2012_lookup_table" VARCHAR
);

CPFV - Trip Targets Logbook Data 2000-2012

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.cpfv_trip_targets_logbook_data_2000_2012

21.74 kB
2,921 rows
15 columns

CREATE TABLE cpfv_trip_targets_logbook_data_2000_2012 (
  "year" BIGINT,
  "port" BIGINT,
  "port_group" VARCHAR,
  "count_of_trips" BIGINT,
  "target_tuna" BIGINT,
  "target_sharks" BIGINT,
  "target_rockfishes" BIGINT,
  "target_lingcod" BIGINT,
  "target_salmon" BIGINT,
  "target_striped_bass" BIGINT,
  "target_sturgeon" BIGINT,
  "target_potluck" BIGINT,
  "target_misc_coastal" BIGINT,
  "target_misc_offshore" BIGINT,
  "not_specified" BIGINT
);

CPFV - Trip Targets Logbook Data 2000-2012 - Lookup Table

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.cpfv_trip_targets_logbook_data_2000_2012_lookup_table

3.48 kB
20 rows
2 columns

CREATE TABLE cpfv_trip_targets_logbook_data_2000_2012_lookup_table (
  "table_name" VARCHAR,
  "sc_cpfv_trip_targets_logbook_data_2000_2012_lookup_table" VARCHAR
);

CPFV - Vessel And Angler Logbook Data 200-2012

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.cpfv_vessel_and_angler_logbook_data_200_2012

7.7 kB
156 rows
6 columns

CREATE TABLE cpfv_vessel_and_angler_logbook_data_200_2012 (
  "year" BIGINT,
  "port_name" VARCHAR,
  "number_of_vessels" BIGINT,
  "number_of_vessel_trips" BIGINT,
  "number_of_angler_days" BIGINT  -- Number Of Angler - Days,
  "port_group" VARCHAR
);

CPFV - Vessel And Angler Logbook Data 200-2012 - Lookup Table

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.cpfv_vessel_and_angler_logbook_data_200_2012_lookup_table

3.38 kB
11 rows
2 columns

CREATE TABLE cpfv_vessel_and_angler_logbook_data_200_2012_lookup_table (
  "table_name" VARCHAR,
  "sc_cpfv_vessel_and_angler_logbook_data_2000_2012_lookup_table" VARCHAR
);

MPA Baseline Program Information - South Coast - Metadata

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.mpa_baseline_program_information_south_coast_metadata

4.55 kB
13 rows
2 columns

CREATE TABLE mpa_baseline_program_information_south_coast_metadata (
  "sc_mpa_baselineprograminformation_lookuptable_csv" VARCHAR,
  "lookup_containing_a_list_of_south_coast_sc_marine_prot_fadf387a" VARCHAR  -- Lookup Table Containing A List Of South Coast (SC) Marine Protected Area (MPA) Baseline Program Projects And Associated Information
);

MPA Boundary Details - South Coast

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.mpa_boundary_details_south_coast

23.47 kB
204 rows
14 columns

CREATE TABLE mpa_boundary_details_south_coast (
  "coordinate" VARCHAR,
  "lat_ddm" VARCHAR,
  "lat" DOUBLE,
  "long_ddm" VARCHAR,
  "long" DOUBLE,
  "mpa_name" VARCHAR,
  "mpa_designation" VARCHAR,
  "mpa_study_region" VARCHAR,
  "number_of_records" BIGINT,
  "position_id" VARCHAR,
  "post_text" VARCHAR,
  "pre_text" VARCHAR,
  "sort_order" BIGINT,
  "sub_section" BIGINT
);

MPA Boundary Details - South Coast - Metadata

@usgov.ca_gov_spatial_and_economic_human_uses_california_sout_a2fbf16f.mpa_boundary_details_south_coast_metadata

5.21 kB
13 rows
2 columns

CREATE TABLE mpa_boundary_details_south_coast_metadata (
  "sc_mpa_boundaryinformation_lookuptable_csv" VARCHAR,
  "lookup_containing_a_list_of_south_coast_sc_marine_prot_4102ddf0" VARCHAR  -- Lookup Table Containing A List Of South Coast (SC) Marine Protected Area (MPA) Boundary Coordinates. The Boundary Coordinates In This Table Were Provided By Paulo Serpa, California Department Of Fish And Wildlife.
);