36444 Entity Published / External 30862 Puget Sound Recreational Shellfish Harvesting Survey - Model Intended Angler Behavior Data Set Data Table Puget Sound recreational shellfishing survey a10a_reason_spend_time_outdoors_rating varchar 20 No No Active Respondent harvests clams or oysters in Puget Sound for the reason of spending time outdoors given a rating system Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree a10b_reason_spend_time_with_family_rating varchar 20 No No Active Respondent harvests clams or oysters in Puget Sound for the reason of spending time with family given a rating system of 5 for strongly agree and 1 for strongly disagree Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree a10g_reason_provide_food_for_family_rating varchar 20 No No Active Respondent harvests clams or oysters in Puget Sound for the reason of providing food for self or family given a rating system of 5 for strongly agree and 1 for strongly disagree Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree a1_razor_clam_harvest varchar 30 No No Active Have you harvested RAZOR CLAMS in Washington in the last 12 months? Razor Clams Harvested, Razor Clams Not Harvested, Don't Know/Not Sure Razor Clams Harvested, Refused Response Razor Clams Harvesed a2b_days_harvesting_oysters int2 3 No No 0 Active Number of days in the last 12 months spent recreationally harvesting oysters in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal a2d_days_harvesting_shrimp int2 3 No No 0 Active Number of days in the last 12 months spent recreationally harvesting shrimp in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal a4_beach_most_used_access_type varchar 20 No No Active Type of access of the beach most used to recreationally harvest shellfish in the last 12 months Private beach, Public beach, Don't Know/Not Sure, Refused a5_beach_most_used varchar 60 No No Active Name of the beach most used to recreationally harvest shellfish in the last 12 months a10c_reason_spend_time_with_friends_or_others_rating varchar 20 No No Active Respondent harvests clams or oysters in Puget Sound for the reason of spending time with friends or others given a rating system of 5 for strongly agree and 1 for strongly disagree Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree a2c_days_harvesting_crab int2 3 No No 0 Active Number of days in the last 12 months spent recreationally harvesting crab in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal a2e_days_harvesting_other int2 3 No No 0 Active Number of days in the last 12 months spent recreationally harvesting other shellfish in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal a10d_reason_relax_rating varchar 20 No No Active Respondent harvests clams or oysters in Puget Sound for the reason of relaxing given a rating system of 5 for strongly agree and 1 for strongly disagree Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree a2a_days_harvesting_clams int2 3 No No 0 Active Number of days in the last 12 months spent recreationally harvesting clams (other than razor clams) in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal a2eoth_other_shellfish_harvested varchar 40 No No Active Other type of shellfish recreationally harvested in Puget Sound including the San Juan Islands, Strait of Juan de Fuca, and Hood Canal within the last 12 months a10e_reason_get_some_exercise_rating varchar 20 No No Active Respondent harvests clams or oysters in Puget Sound for the reason of getting some exercise given a rating system of 5 for strongly agree and 1 for strongly disagree Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree a3_name_of_city_near_beach_most_used varchar No No Active Name of city from a list of cities that is nearest the beach respondent uses most to harvest shellfish Anacortes, Bellingham, Blaine, Bremerton, Brinnon, Everett, Hoodsport, Langly, Mount Vernon, Olympia, Orcas, Port Angeles, Port Townsend, Poulsbo, Seattle, Sekiu, Shelton, Tacoma, Other (SPECIFY) a10f_reason_eat_self_caught_rating varchar 20 No No Active Respondent harvests clams or oysters in Puget Sound for the reason of eating something self caught given a rating system of 5 for strongly agree and 1 for strongly disagree Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree a2eot1_other_shellfish_harvested varchar 40 No No Active Other type of shellfish recreationally harvested in Puget Sound including the San Juan Islands, Strait of Juan de Fuca, and Hood Canal within the last 12 months a11_consume_clams_or_oyster_frequency varchar 30 No No Active Frequency respondent eats meals containing clams or oysters harvested from Puget Sound Almost Never, About Once Per Year, Two or Three Times Per Year, Four to Ten Times Per Year, More Than Ten Times Per Year a3oth_name_of_city_near_beach_most_used varchar No No Active Name of city not in list nearest beach respondent uses most to harvest shellfish PENROSE, SAMISH ISLAND, SAMISH ISLAND BEACH, TOLOMIE a2eot0_other_shellfish_harvested varchar 40 No No Active Other type of shellfish recreationally harvested in Puget Sound including the San Juan Islands, Strait of Juan de Fuca, and Hood Canal within the last 12 months a601_car_travel_beach_most_used varchar 25 No No Active Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by car Travelled by Car, Not Travelled by Car a602_boat_travel_beach_most_used varchar 25 No No Active Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by boat Travelled by Boat, Not Travelled by Boat a603_foot_travel_beach_most_used varchar 25 No No Active Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by foot Travelled by Foot, Not Travelled by Foot a6_1_miles_by_car_beach_most_used int4 16 No No 0 Active Number of one way miles travelled by car to most used beach recreationally harvesting shellfish in the last 12 months measured to nearest mile mi 1-300 a6_2_miles_by_boat_beach_most_used int4 16 No No 0 Active Number of one way miles travelled by boat (not including ferry) to most used beach recreationally harvesting shellfish in the last 12 months measured to nearest mile mi 1-22 a7_ferry_travel_beach_most_used varchar 30 No No Active Do you take a ferry as part of your trip to get to the beach you most often used? No, Yes a8_lodging_beach_most_used varchar 30 No No Active On the trip(s) you took to the beach you most often used, did you usually stay one or more nights in a house you own, a vacation rental, a hotel / motel, or a campground? No. This is usually a day trip, House Respondent Owns, Vacation Rental, Hotel Motel or B&B, Campground or Trailer Park, Family or Friend's Home, Other a8oth_other_lodging_most_used_type varchar 50 No No Active Other type of lodging used for one or more overnight stays at the most often used beach recreationally harvesting shellfish BOAT, CABIN, CAMPING IN WOODS, FAMILY OWNED HOUSE, FAMILY OWNED VACATION HOME, FAMILY OWNS, FRIEND OWNED, FRIENDS, FRIEND'S, FRIEND'S BEACH HOUSE, FRIEND'S CABIN, FRIEND'S HOME, FRIEND'S HOUSE, FRIEND'S PLACE, LIVE ABOARD A BOAT, NA, NATIONAL FOREST CABIN, PARENTS (IN-LAWS), PARENT'S HOME, PARENT'S HOUSE, PRIVATE PROPERTY-CAMPING, RELATIONS, RELATIVE, RELATIVE'S HOME, STAY ON BOAT, STAY W/ FRIENDS, STAY WITH MY SON a9_range_other_beaches_used varchar 100 No No Active Concatenated list of ranges of other beaches used nearby the most used beach to recreationally harvest shellfish in the last 12 months None, Within 10 Miles, Between 11 and 20 Miles, Between 21 and 30 Miles, More than 30 miles b1001_car_travel_last_overnight_trip varchar 25 No No Active Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by car or not Travelled by Car, Not Travelled by Car b1002_boat_travel_last_overnight_trip varchar 25 No No Active Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by boat or not Travelled by Boat, Not Travelled by Boat b1003_foot_travel_last_overnight_trip varchar 25 No No Active Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by foot or not Travelled by Foot, Not Travelled by Foot b10_1_miles_by_car_last_overnight_trip int4 16 No No 0 Active Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster overnight trip mi 0-80 b10_2_miles_by_boat_last_overnight_trip int4 16 No No 0 Active Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster overnight trip mi 1.0 b1101_target_steamer_clams_last_trip varchar 25 No No Active Indicates if steam clams (manila, littleneck, butter, cockle, softshell, macoma) were the target or harvested on last Puget Sound trip Steamer Clam Target, Steamer Clam Not Target b1102_target_geoduck_clams_last_trip varchar 25 No No Active Indicates if geoduck clams were the target or harvested on last Puget Sound trip Geoduck Clam Target, Geoduck Clam Not Target b1103_target_horse_clams_last_trip varchar 25 No No Active Indicates if horse clams were the target or harvested on last Puget Sound trip Horse Clam Target, Horse Clam Not Target b1104_target_oysters_last_trip varchar 20 No No Active Indicates if oysters were the target or harvested on last Puget Sound trip Oysters Target, Oysters Not Target b1105_target_other_last_trip varchar 20 No No Active Indicates if other type were the target or harvested on last Puget Sound trip Other Target, Other Not Target b11_1_number_kept_last_trip_steamer_clams int2 16 No No 0 Active Quantity of steam clams kept on last Puget Sound trip 0-120 b11_2_number_kept_last_trip_geoduck_clams int2 16 No No 0 Active Quantity of geoduck clams kept on last Puget Sound trip 0-20 b11_3_number_kept_last_trip_horse_clams int2 16 No No 0 Active Quantity of horse clams kept on last Puget Sound trip 0-14 b11_4_number_kept_last_trip_oysters int2 16 No No 0 Active Quantity of oysters kept on last Puget Sound trip 0-999 b11_5_number_kept_last_trip_other int2 16 No No 0 Active Quantity of other clams kept on last Puget Sound trip 1-240 b11oth_other_targetted_last_trip_type varchar 50 No No Active Other type targetted or harvested at last trip in Puget Sound BLUE MUSSLES AND BARNICKLE, BUTTER, BUTTER CLAMS, CLAMS, COCKLE, COCKLE, COCKLES, CRAB, CRAB DUNGENESS, LITTLE NECKS AND STEAMERS, LITTLE NECKS MANILA, MANILA, MUSSEL, MUSSELLS, MUSSELS, RED ROCK CRAB, REGISTERED WITH WSFW #42, SHRIMP, VARNISH CLAMS b12a1_money_spent_last_trip_land_vehicle int2 16 No No 0 Active Money spent on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar dol b12a2_number_people_last_trip_land_vehicle int2 16 No No 0 Active Number people covered on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar b12b1_money_spent_last_trip_water_vehicle int2 16 No No 0 Active Money spent on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar 0-100 b12b2_number_people_last_trip_water_vehicle int2 16 No No 0 Active Number people covered on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar 1-8 b12c1_money_spent_last_trip_parking_launch int2 16 No No 0 Active Money spent on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar 0-800 b12c2_number_people_last_trip_parking_launch int2 16 No No 0 Active Number people covered on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar 1-4 b12d1_money_spent_last_trip_ferry int2 16 No No 0 Active Money spent on last Puget Sound trip by self or household on ferry rounded to nearest dollar 0-150 b12d2_number_people_last_trip_ferry int2 16 No No 0 Active Number people covered on last Puget Sound trip by self or household on ferry rounded to nearest dollar 1-8 b12e1_money_spent_last_trip_other_transport int2 16 No No 0 Active Money spent on last Puget Sound trip by self or household on other transport rounded to nearest dollar 0-4 b12e2_number_people_last_trip_other_transport int2 16 No No 0 Active Number people covered on last Puget Sound trip by self or household on other transport rounded to nearest dollar 2 b12eoth_other_transport_last_trip_type varchar 40 No No Active Other transportation type on last Puget Sound trip b12f1_money_spent_last_trip_camping int2 16 No No 0 Active Money spent on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar 0-250 b12f2_number_people_last_trip_camping int2 16 No No 0 Active Number people covered on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar 0-5 b12g1_money_spent_last_trip_hotels int2 16 No No 0 Active Money spent on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar 0-150 b12g2_number_people_last_trip_hotels int2 16 No No 0 Active Number people covered on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar 3-4 b12h1_money_spent_last_trip_vaca_rental int2 16 No No 0 Active Money spent on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar 0-300 b12h2_number_people_last_trip_vaca_rental int2 16 No No 0 Active Number people covered on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar 2.0 b12i1_money_spent_last_trip_grocery int2 16 No No 0 Active Money spent on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar 0-1500 b12i2_number_people_last_trip_grocery int2 16 No No 0 Active Number people covered on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar 0-99 b12j1_money_spent_last_trip_restaurants_bars int2 16 No No 0 Active Money spent on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar 0-400 b12j2_number_people_last_trip_restaurants_bars int2 16 No No 0 Active Number people covered on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar 0-99 b12k1_money_spent_last_trip_other_lodging_food int2 16 No No 0 Active Money spent on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar 0-2000 b12k2_number_people_last_trip_other_lodging_food int2 16 No No 0 Active Number people covered on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar 1-10 b12koth_other_lodging_food_last_trip_type varchar 60 No No Active Other lodging or food type on last Puget Sound trip CABIN RENTAL, FRIEND'S HOUSE, GROCERIES, HARDWARE, NA b13_harvest_shellfish_next_12_months_likely_rating varchar 40 No No Active Likeliness surveyor will take a trip to Puget Sound to harvest shellfish Definitely Will Harvest Shellfish, Very Likely, Somewhat Likely, Very Unlikely, Definitely Will Not Harvest Shellfish b1_month_last_trip int2 16 No No 0 Active The month number of the last trip spent harvesting clams (not including razor clams) or oysters mon 1-12 b2_days_spent_last_trip int2 16 No No 0 Active The number of days (partial days count as full days and includes travel) spent on the last whole trip to the most recent Puget Sound beach to harvest clam (not razor clams) or oysters days 1-13 b3_days_spent_harvesting_last_trip int2 16 No No 0 Active The number of days (partial days count as full days and includes travel) spent harvesting clam (not razor clams) or oysters at the most recent Pugent Sound trip days 1-11 b4_hours_spent_harvesting_last_trip int2 16 No No 0 Active The number of hours (rounded to nearest hour) spent harvesting clams or oysters on most recent Puget Sound trip hr 1-30 b5_beach_access_type_last_trip varchar 20 No No Active Access type of the beach most recently used in the Puget Sound to harvest clams (not razor clams) or oysters Private Beach, Public Beach, Don't Know/Not Sure, Refused b6_beach_name_last_trip varchar 60 No No Active Name of most recent beach in Puget Sound to harvest clams (not razor clams) or oysters b701_car_travel_last_trip varchar 25 No No Active Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by car or not Travelled by Car, Not Travelled by Car b702_boat_travel_last_trip varchar 25 No No Active Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by boat or not Travelled by Boat, Not Travelled by Boat b703_foot_travel_last_trip varchar 25 No No Active Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by foot or not Travelled by Foot, Not Travelled by Foot b7_1_miles_by_car_last_trip int4 16 No No 0 Active Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster trip mi 1-250 b7_2_miles_by_boat_last_trip int4 16 No No 0 Active Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster trip mi 2016/01/15 00:00:00.000 b8_primary_purpose_clam_oyster varchar 40 No No Active Indicates if most recent Puget Sound clam (not razor clams) or oyster trip was to catch clam or oysters Clam or Oyster Primary Purpose, Clam or Oyster Not Primary Purpose b9_lodging_type_last_trip varchar 30 No No Active The type of lodging used one or more nights at most recent Puget Sound clam (not razor clams) or oyster trip None, House Self Owned, Vacation Rental, Hotel Motel or B&B, Campground or Trailer Park, Family or Friend's Home, Other b9oth_other_lodging_type_last_trip varchar 50 No No Active The type of lodging not available in list used one or more nights at most recent Puget Sound clam (not razor clams) or oyster trip c2a_quantity_harvest_trips_most_used_beach_open_all_season int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at most used beach assuming no biotoxin or pollution closures 0-75 c2b_quantity_nonharvest_trips_most_used_beach_open_all_season int2 16 No No 0 Active Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach assuming no biotoxin or pollution closures 0-80 c3_1a_quantity_harvest_trips_most_used_beach_closed_all_season int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season 0-75 c3_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season int2 16 No No 0 Active Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach that was closed all season 0-75 c3_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was closed all season 0-75 c3_additional_distance_to_nearby_fully_open_beach varchar 20 No No Active Additional distance to nearby beach that is fully open for questions in section C3 30 miles away, 20 miles away, 10 miles away, 5 miles away c3_period_of_closure varchar 15 No No Active Period of closure for questions in section C3 12 months, 3 months c3_species_closed_to_harvest varchar 20 No No Active Species that are closed to harvest for questions in section C3 Clams/Oysters, Razor Clams c3_type_of_closure varchar 15 No No Active Type of closure for questions in section C3 Biotoxin, Pollution c4_1a_quantity_harvest_trips_most_used_beach_closed_all_season int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season 0-75 c4_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season int2 16 No No 0 Active Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach that was closed all season 0-75 c4_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was closed all season 0-75 c4_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was open all season 0-98 c4_additional_distance_to_nearby_fully_open_beach varchar 20 No No Active Additional distance to nearby beach that is fully open for questions in section C4 30 miles away, 20 miles away, 10 miles away, 5 miles away c4_period_of_closure varchar 15 No No Active Period of closure for questions in section C4 12 months, 3 months c4_type_of_closure varchar 15 No No Active Type of closure for questions in section C4 Biotoxin, Pollution c53_quantity_harvest_trips_nearby_beach_while_most_used_fully_open int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open 0-98 c5_1a_quantity_harvest_trips_most_used_beach_closed_3_months int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 3 month closure 0-99 c5_1b_quantity_nonharvest_trips_most_used_beach_closed_3_months int2 16 No No 0 Active Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 3 month closure 0-50 c5_1c_quantity_harvest_trips_nearby_beach_most_used_closed_3_months int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during most used 3 month closure 0-75 c5_2a_quantity_harvest_trips_most_used_beach_during_open_9_months int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 3 month closure 0-98 c5_2c_quantity_harvest_trips_nearby_beach_during_most_used_open_9_months int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during other months of most used 3 month closure 0-98 c5_additional_distance_to_nearby_fully_open_beach varchar 20 No No Active Additional distance to nearby beach that is fully open for questions in section C5 30 miles away, 20 miles away, 10 miles away, 5 miles away c5_period_of_closure varchar 15 No No Active Period of closure for questions in section C5 12 months, 3 months c5_species_closed_to_harvest varchar 20 No No Active Species that are closed to harvest for questions in section C5 Clams/Oysters, Razor Clams c5_type_of_closure varchar 15 No No Active Type of closure for questions in section C5 Biotoxin, Pollution c63_quantity_harvest_trips_nearby_beach_while_most_used_fully_open int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open 0-36 c6_1a_quantity_harvest_trips_most_used_beach_closed_1_month int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 1 month closure 0-75 c6_1b_quantity_nonharvest_trips_most_used_beach_closed_1_ month int2 16 No No 0 Active Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 1 month closure 0-50 c6_1c_quantity_harvest_trips_nearby_beach_most_used_closed_1_month int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during most used 1 month closure 0-18 c6_2a_quantity_harvest_trips_most_used_beach_during_opened_11_months int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 1 month closure 0-80 c6_2b_quantity_nonharvest_trips_most_used_beach_during_opened_11_months int2 16 No No 0 Active Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during other months of 1 month closure 0-67 c6_additional_distance_to_nearby_fully_open_beach varchar 20 No No Active Additional distance to nearby beach that is fully open for questions in section C6 30 miles away, 20 miles away, 10 miles away, 5 miles away c6_period_of_closure varchar 15 No No Active Period of closure for questions in section C6 12 months, 3 months c6_species_closed_to_harvest varchar 20 No No Active Species that are closed to harvest for questions in section C6 Clams/Oysters, Razor Clams c6_type_of_closure varchar 15 No No Active Type of closure for questions in section C6 Biotoxin, Pollution call_length int2 16 No No 0 Active Length of call measured in minutes min 0-17 combo_2013 varchar 25 No No Active Indicates if respondent purchased combination license in 2013 Combination License, No Combination License, NA d1_birth_year int2 16 No No 0 Active Year of birth of respondent d2_sex_dim$record_type varchar 30 No No Active latitude record type or reason record is unavailable NA Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned d2_sex_dim$sex varchar 20 No No Active unspecified Any d2_sex_dim$sex_abbreviation bpchar 1 No No Active unspecified Any d2_sex_whid int2 16 No No 0 Active Warehouse identifier of gender of respondent per questionaire d3_education_level varchar 30 No No Active Education level of respondent Some High School, High School Graduate, Technical School, Some College, College Graduate or More d4a_household_adult_size int2 16 No No 0 Active Number of adults within household including self 1-6 d4b_household_child_size int2 16 No No 0 Active Number of children (under 18) within household 0-5 d5_household_income_range varchar 20 No No Active Best description of household total annual income before taxes Less than $20,000, $20,000-$39,999, $40,000-59,999, $60,000-$79,999, $80,000-$99,999, $100,000-$124,999, $125,000-$149,999, $150,000 or More d6_employment_hours varchar 20 No No Active Employment hours (nonworking includes homemakers, retired, or currently unemployed, part time equates to 35 hours or less, full time equates to more than 35 hours) Nonworking, Part-time, Full-time d7_hourly_wage_range varchar 20 No No Active Approximate personal hourly wage rate range $5.00-$9.99, $10.00-$14.99, $15.00-$19.99, $20.00-$29.99, $30.00-$39.99, $40.00-$49.99, $50.00-$59.99, $60.00-$74.99, $75.00 or More d8_1_no_time_off_work varchar 15 No No Active Indicates if respondent did not take time off to harvest shellfish No Time Off, Time Off d8_2_paid_time_off_work varchar 20 No No Active Indicates if respondent took paid time off (vacation, sick, etc.) to harvest shellfish Paid Time Off, Not Paid Time Off d8_3_unpaid_time_off_work varchar 20 No No Active Indicates if respondent took unpaid time off to harvest shellfish Unpaid Time Off, Not Unpaid Time Off d9_survey_comments varchar 1000 No No Active Additional comments from respondent final_mail_disposition varchar 30 No No 0 Active Final mail disposition Bad Address, Blank, Complete, Opt-Out, Refused/Didn't Shellfish final_mail_disposition_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 final_mail_disposition_date_dim$full_date timestamp No No Active full date value final_mail_disposition_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC final_mail_disposition_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December final_mail_disposition_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 final_mail_disposition_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned final_mail_disposition_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ final_mail_disposition_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day final_mail_disposition_date_whid int8 64 No No 0 Active Warehouse identifier for final mail disposition date initial_survey_packet_mailed_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 initial_survey_packet_mailed_date_dim$full_date timestamp No No Active full date value initial_survey_packet_mailed_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC initial_survey_packet_mailed_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December initial_survey_packet_mailed_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 initial_survey_packet_mailed_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned initial_survey_packet_mailed_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ initial_survey_packet_mailed_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day initial_survey_packet_mailed_date_whid int8 64 No No 0 Active Warehouse identifier for initial survey packet mailed date last_call_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 last_call_date_dim$full_date timestamp No No Active full date value last_call_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC last_call_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December last_call_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 last_call_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ last_call_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day last_call_date_whid int8 64 No No 0 Active Warehouse identifier for last call date last_call_phone_disposition varchar 50 No No Active Disposition of the last phone call ANSWERING MACHINE, BREAK OFF DURING SCREENER, BUSY, CHANGED NUMBER, CLAIMS PREVIOUS INTERVIEW, COMPLETED SURVEY, INITIAL (HARD) REFUSAL, NO ANSWER, NON-RESIDENTIAL NUMBER, NON-WORKING NUMBER, OTHER LANGUAGE BARRIER / HEARING PROBLEM, OTHER PHONE PROBLEM, OTHER PHONE PROBLEMS, QUALIFIED REFUSAL, SPANISH LANGUAGE BARRIER, SPECIFIED CALLBACK, TERMINATE INVITATION, TERMINATE Q2, UNSPECIFIED CALLBACK, WRONG NUMBER mail_comments varchar 20 No No Active Mail comments Remove from list, Was Forwarded master_id int2 16 No No 0 Active Shellfish survey master ID other_mail_disposition_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 other_mail_disposition_date_dim$full_date timestamp No No Active full date value other_mail_disposition_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC other_mail_disposition_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December other_mail_disposition_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 other_mail_disposition_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned other_mail_disposition_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ other_mail_disposition_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day other_mail_disposition_date_whid int8 64 No No 0 Active Warehouse identifier for other mail disposition date post_card_mailed_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 post_card_mailed_date_dim$full_date timestamp No No Active full date value post_card_mailed_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC post_card_mailed_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December post_card_mailed_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 post_card_mailed_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned post_card_mailed_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ post_card_mailed_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day post_card_mailed_date_whid int8 64 No No 0 Active Warehouse identifier for post card mailed date prenotice_letter_mailed_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 prenotice_letter_mailed_date_dim$full_date timestamp No No Active full date value prenotice_letter_mailed_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC prenotice_letter_mailed_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December prenotice_letter_mailed_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned prenotice_letter_mailed_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ prenotice_letter_mailed_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day prenotice_letter_mailed_date_whid int8 64 No No 0 Active Warehouse identifier for prenotice letter mailed date q1_taken_trips_harvesting_razor_clams varchar 25 No No Active Have you taken any trips where you harvested razor clams in Washington in the last 12 months? DON'T KNOW / NOT SURE, No, REFUSED, Yes q2_taken_trips_harvesting_oysters_clams varchar 25 No No Active Have you taken any trips where you harvested oysters or clams in Puget Sound in the last 12 months? DON'T KNOW / NOT SURE, No, REFUSED, Yes q4_miles_travel_to_harvest_beach int 25 No No Active Approximately how many one-way miles do you travel to get to the beach you most often use to harvest oysters or clams in Puget Sound? 1-350, Don't know/Not Sure, Less than one mile q5_harvest_shellfish_rating_next_12_mo varchar 40 No No Active During the next 12 months, how likely is it that you will take a trip where you harvest shellfish in Puget Sound? Definitely will harvest shellfish, Definitely will not harvest shellfish, Somewhat likely, Very likely, Very unlikely q6_respondent_birth_year int 10 No No Active In what year were you born? 1929-1995, Refused q7_respondent_income_range varchar 50 No No Active Im going to read you some income categories. For classification purposes only, please tell me which income category best describes your households total annual income before taxes in 2012. When I read your household income category, please stop me. Less than $20,000, More than $20,000 but less than $40,000, More than $40,000 but less than $60,000, More than $60,000 but less than $80,000, More than $80,000 but less than $100,000, More than $100,000 but less than $125,000, More than $125,000 but less than $150,000, More than $150,000, Refused residential_city varchar 80 No No Active Residential city residential_street varchar 150 No No Active Residential street address residential_zip varchar 10 No No Active Residential zip sample_birth_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 sample_birth_date_dim$full_date timestamp No No Active full date value sample_birth_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC sample_birth_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December sample_birth_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 sample_birth_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned sample_birth_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ sample_birth_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day sample_birth_date_whid int8 64 No No 0 Active Warehouse identifier for birthdate from sample sample_id int2 16 No No 0 Active Shellfish survey sample ID sample_sex_dim$record_type varchar 30 No No Active latitude record type or reason record is unavailable NA Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned sample_sex_dim$sex varchar 20 No No Active unspecified Any sample_sex_dim$sex_abbreviation bpchar 1 No No Active unspecified Any sample_sex_whid int2 16 No No 0 Active Warehouse identifier to gender from sample second_survey_packet_mailed_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 second_survey_packet_mailed_date_dim$full_date timestamp No No Active full date value second_survey_packet_mailed_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC second_survey_packet_mailed_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December second_survey_packet_mailed_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 second_survey_packet_mailed_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned second_survey_packet_mailed_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ second_survey_packet_mailed_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day second_survey_packet_mailed_date_whid int8 64 No No 0 Active Warehouse identifier for second survey packet mailed date shellfish_2013 varchar 25 No No Active Indicates if respondent purchased shellfish license in 2013 Shellfish License, No Shellfish License, NA survey_version int2 16 No No 0 Active Number of the survey version third_survey_packet_mailed_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 third_survey_packet_mailed_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC third_survey_packet_mailed_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December third_survey_packet_mailed_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 third_survey_packet_mailed_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned third_survey_packet_mailed_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ third_survey_packet_mailed_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day third_survey_packet_mailed_date_whid int8 64 No No 0 Active Warehouse identifier for third survey packet mailed date verified_address varchar 50 No No Active Respondent verified address RESPONDENT REFUSED TO PARTICIPATE IN MAIL SURVEY, YES, which_survey_completed int2 16 No No 0 Active Which survey number was completed q3_beach_access_harvesting_trip varchar 25 No No Active On your harvesting trips in Puget Sound, do you typically harvest oysters or clams from a public beach or a private beach? DON'T KNOW / NOT SURE, Private, Public, REFUSED c1_trip_months_list varchar 100 No No Active Concatenated list of month names in which surveyor takes trips to harvest clams or oysters in Puget Sound January, February, March, April, May, June, July, August, September, October, November, December c3_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was open all season 0-75 c5_2b_quantity_nonharvest_trips_most_used_beach_during_open_9_months int2 16 No No 0 Active Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during other months of 3 month closure 0-98 c4_species_closed_to_harvest varchar 20 No No Active Species that are closed to harvest for questions in section C4 Clams/Oysters, Razor Clams c6_2c_quantity_harvest_trips_nearby_beach_during_most_used_opened_11_months int2 16 No No 0 Active Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during other months of most used 1 month closure 0-20 last_call_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned third_survey_packet_mailed_date_dim$full_date timestamp No No Active full date value other_mail_disposition int2 16 No No 0 Active Other mail disposition prenotice_letter_mailed_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 gov.noaa.nmfs.inport:36444 Jeffrey Cowen 2017-01-25T13:22:12 SysAdmin InPortAdmin 2022-08-09T17:11:17 2017-02-13 Northwest Fisheries Science Center NWFSC 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov 1001 Public No 2017-02-13 1 Year 2018-02-13