Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Puget Sound recreational shellfishing survey

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
b12g2_number_people_last_trip_hotels
int2
Number people covered on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar
other_mail_disposition_date_dim$record_type
varchar
date, month, or year record or reason record is unavailable
b7_1_miles_by_car_last_trip
int4
Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster trip
final_mail_disposition_date_dim$month_name
varchar
text representation of month
c6_period_of_closure
varchar
Period of closure for questions in section C6
last_call_date_dim$month_abbrev
bpchar
three character representation of month in capital letters
b702_boat_travel_last_trip
varchar
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by boat or not
sample_sex_whid
int2
Warehouse identifier to gender from sample
a2b_days_harvesting_oysters
int2
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
d6_employment_hours
varchar
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)
d1_birth_year
int2
Year of birth of respondent
q3_beach_access_harvesting_trip
varchar
On your harvesting trips in Puget Sound, do you typically harvest oysters or clams from a public beach or a private beach?
a2c_days_harvesting_crab
int2
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
combo_2013
varchar
Indicates if respondent purchased combination license in 2013
last_call_date_dim$year
int4
numeric representation of year
final_mail_disposition_date_dim$day_of_month
int2
numeric representation of the day in month
other_mail_disposition_date_dim$month_name
varchar
text representation of month
survey_version
int2
Number of the survey version
c4_period_of_closure
varchar
Period of closure for questions in section C4
last_call_date_whid
int8
Warehouse identifier for last call date
c4_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season
int2
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
b10_2_miles_by_boat_last_overnight_trip
int4
Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster overnight trip
final_mail_disposition_date_dim$record_type
varchar
date, month, or year record or reason record is unavailable
b8_primary_purpose_clam_oyster
varchar
Indicates if most recent Puget Sound clam (not razor clams) or oyster trip was to catch clam or oysters
c4_type_of_closure
varchar
Type of closure for questions in section C4
final_mail_disposition
varchar
Final mail disposition
b1103_target_horse_clams_last_trip
varchar
Indicates if horse clams were the target or harvested on last Puget Sound trip
prenotice_letter_mailed_date_dim$month_abbrev
bpchar
three character representation of month in capital letters
a2e_days_harvesting_other
int2
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
final_mail_disposition_date_dim$month_of_year
int2
numeric representation of month of year
final_mail_disposition_date_whid
int8
Warehouse identifier for final mail disposition date
post_card_mailed_date_whid
int8
Warehouse identifier for post card mailed date
initial_survey_packet_mailed_date_dim$full_date
timestamp
full date value
sample_sex_dim$sex
varchar
residential_zip
varchar
Residential zip
a10c_reason_spend_time_with_friends_or_others_rating
varchar
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
c5_2a_quantity_harvest_trips_most_used_beach_during_open_9_months
int2
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 3 month closure
last_call_phone_disposition
varchar
Disposition of the last phone call
b11_3_number_kept_last_trip_horse_clams
int2
Quantity of horse clams kept on last Puget Sound trip
residential_city
varchar
Residential city
c2a_quantity_harvest_trips_most_used_beach_open_all_season
int2
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach assuming no biotoxin or pollution closures
initial_survey_packet_mailed_date_whid
int8
Warehouse identifier for initial survey packet mailed date
a10a_reason_spend_time_outdoors_rating
varchar
Respondent harvests clams or oysters in Puget Sound for the reason of spending time outdoors given a rating system
b12f1_money_spent_last_trip_camping
int2
Money spent on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar
b12h1_money_spent_last_trip_vaca_rental
int2
Money spent on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar
last_call_date_dim$month_of_year
int2
numeric representation of month of year
b1101_target_steamer_clams_last_trip
varchar
Indicates if steam clams (manila, littleneck, butter, cockle, softshell, macoma) were the target or harvested on last Puget Sound trip
c6_1a_quantity_harvest_trips_most_used_beach_closed_1_month
int2
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 1 month closure
d7_hourly_wage_range
varchar
Approximate personal hourly wage rate range
b12eoth_other_transport_last_trip_type
varchar
Other transportation type on last Puget Sound trip
b12j2_number_people_last_trip_restaurants_bars
int2
Number people covered on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar
second_survey_packet_mailed_date_dim$year
int4
numeric representation of year
a1_razor_clam_harvest
varchar
Have you harvested RAZOR CLAMS in Washington in the last 12 months?
final_mail_disposition_date_dim$full_date
timestamp
full date value
a9_range_other_beaches_used
varchar
Concatenated list of ranges of other beaches used nearby the most used beach to recreationally harvest shellfish in the last 12 months
a2d_days_harvesting_shrimp
int2
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
a6_2_miles_by_boat_beach_most_used
int4
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
b12koth_other_lodging_food_last_trip_type
varchar
Other lodging or food type on last Puget Sound trip
b1104_target_oysters_last_trip
varchar
Indicates if oysters were the target or harvested on last Puget Sound trip
other_mail_disposition_date_dim$yyyymmdd
bpchar
text representation of year month day
b12k1_money_spent_last_trip_other_lodging_food
int2
Money spent on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar
second_survey_packet_mailed_date_dim$month_abbrev
bpchar
three character representation of month in capital letters
sample_birth_date_dim$month_of_year
int2
numeric representation of month of year
b12f2_number_people_last_trip_camping
int2
Number people covered on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar
c6_2b_quantity_nonharvest_trips_most_used_beach_during_opened_11_months
int2
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
prenotice_letter_mailed_date_dim$month_of_year
int2
numeric representation of month of year
b7_2_miles_by_boat_last_trip
int4
Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster trip
c4_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season
int2
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
b12a1_money_spent_last_trip_land_vehicle
int2
Money spent on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar
sample_birth_date_dim$day_of_month
int2
numeric representation of the day in month
c53_quantity_harvest_trips_nearby_beach_while_most_used_fully_open
int2
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open
c5_type_of_closure
varchar
Type of closure for questions in section C5
a4_beach_most_used_access_type
varchar
Type of access of the beach most used to recreationally harvest shellfish in the last 12 months
b1_month_last_trip
int2
The month number of the last trip spent harvesting clams (not including razor clams) or oysters
c6_2a_quantity_harvest_trips_most_used_beach_during_opened_11_months
int2
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 1 month closure
b12d1_money_spent_last_trip_ferry
int2
Money spent on last Puget Sound trip by self or household on ferry rounded to nearest dollar
initial_survey_packet_mailed_date_dim$month_name
varchar
text representation of month
b703_foot_travel_last_trip
varchar
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by foot or not
a10b_reason_spend_time_with_family_rating
varchar
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
b11oth_other_targetted_last_trip_type
varchar
Other type targetted or harvested at last trip in Puget Sound
prenotice_letter_mailed_date_dim$month_name
varchar
text representation of month
b1105_target_other_last_trip
varchar
Indicates if other type were the target or harvested on last Puget Sound trip
which_survey_completed
int2
Which survey number was completed
b11_4_number_kept_last_trip_oysters
int2
Quantity of oysters kept on last Puget Sound trip
last_call_date_dim$month_name
varchar
text representation of month
second_survey_packet_mailed_date_dim$month_of_year
int2
numeric representation of month of year
b13_harvest_shellfish_next_12_months_likely_rating
varchar
Likeliness surveyor will take a trip to Puget Sound to harvest shellfish
second_survey_packet_mailed_date_dim$yyyymmdd
bpchar
text representation of year month day
last_call_date_dim$yyyymmdd
bpchar
text representation of year month day
a10g_reason_provide_food_for_family_rating
varchar
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
third_survey_packet_mailed_date_dim$month_name
varchar
text representation of month
q5_harvest_shellfish_rating_next_12_mo
varchar
During the next 12 months, how likely is it that you will take a trip where you harvest shellfish in Puget Sound?
a2eot1_other_shellfish_harvested
varchar
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
c3_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season
int2
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
b12b2_number_people_last_trip_water_vehicle
int2
Number people covered on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar
prenotice_letter_mailed_date_dim$yyyymmdd
bpchar
text representation of year month day
sample_birth_date_dim$record_type
varchar
date, month, or year record or reason record is unavailable
q6_respondent_birth_year
int
In what year were you born?
verified_address
varchar
Respondent verified address
initial_survey_packet_mailed_date_dim$day_of_month
int2
numeric representation of the day in month
other_mail_disposition_date_dim$month_abbrev
bpchar
three character representation of month in capital letters
a10f_reason_eat_self_caught_rating
varchar
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
third_survey_packet_mailed_date_dim$year
int4
numeric representation of year
d5_household_income_range
varchar
Best description of household total annual income before taxes
post_card_mailed_date_dim$full_date
timestamp
full date value
c6_additional_distance_to_nearby_fully_open_beach
varchar
Additional distance to nearby beach that is fully open for questions in section C6
post_card_mailed_date_dim$month_name
varchar
text representation of month
third_survey_packet_mailed_date_dim$yyyymmdd
bpchar
text representation of year month day
b12e2_number_people_last_trip_other_transport
int2
Number people covered on last Puget Sound trip by self or household on other transport rounded to nearest dollar
b4_hours_spent_harvesting_last_trip
int2
The number of hours (rounded to nearest hour) spent harvesting clams or oysters on most recent Puget Sound trip
d4a_household_adult_size
int2
Number of adults within household including self
other_mail_disposition_date_dim$year
int4
numeric representation of year
c3_period_of_closure
varchar
Period of closure for questions in section C3
a5_beach_most_used
varchar
Name of the beach most used to recreationally harvest shellfish in the last 12 months
last_call_date_dim$record_type
varchar
date, month, or year record or reason record is unavailable
c6_2c_quantity_harvest_trips_nearby_beach_during_most_used_opened_11_months
int2
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
c4_species_closed_to_harvest
varchar
Species that are closed to harvest for questions in section C4
third_survey_packet_mailed_date_dim$full_date
timestamp
full date value
d2_sex_dim$sex_abbreviation
bpchar
mail_comments
varchar
Mail comments
other_mail_disposition_date_dim$month_of_year
int2
numeric representation of month of year
b1002_boat_travel_last_overnight_trip
varchar
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by boat or not
third_survey_packet_mailed_date_dim$record_type
varchar
date, month, or year record or reason record is unavailable
a7_ferry_travel_beach_most_used
varchar
Do you take a ferry as part of your trip to get to the beach you most often used?
c6_species_closed_to_harvest
varchar
Species that are closed to harvest for questions in section C6
initial_survey_packet_mailed_date_dim$month_of_year
int2
numeric representation of month of year
c63_quantity_harvest_trips_nearby_beach_while_most_used_fully_open
int2
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open
prenotice_letter_mailed_date_dim$year
int4
numeric representation of year
b12i2_number_people_last_trip_grocery
int2
Number people covered on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar
initial_survey_packet_mailed_date_dim$record_type
varchar
date, month, or year record or reason record is unavailable
b1001_car_travel_last_overnight_trip
varchar
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by car or not
d3_education_level
varchar
Education level of respondent
b1003_foot_travel_last_overnight_trip
varchar
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by foot or not
b12i1_money_spent_last_trip_grocery
int2
Money spent on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar
prenotice_letter_mailed_date_dim$full_date
timestamp
full date value
call_length
int2
Length of call measured in minutes
initial_survey_packet_mailed_date_dim$month_abbrev
bpchar
three character representation of month in capital letters
post_card_mailed_date_dim$year
int4
numeric representation of year
c5_1c_quantity_harvest_trips_nearby_beach_most_used_closed_3_months
int2
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
sample_birth_date_dim$full_date
timestamp
full date value
prenotice_letter_mailed_date_dim$record_type
varchar
date, month, or year record or reason record is unavailable
b11_1_number_kept_last_trip_steamer_clams
int2
Quantity of steam clams kept on last Puget Sound trip
b12h2_number_people_last_trip_vaca_rental
int2
Number people covered on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar
a2eot0_other_shellfish_harvested
varchar
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
post_card_mailed_date_dim$record_type
varchar
date, month, or year record or reason record is unavailable
other_mail_disposition
int2
Other mail disposition
q1_taken_trips_harvesting_razor_clams
varchar
Have you taken any trips where you harvested razor clams in Washington in the last 12 months?
sample_birth_date_dim$month_name
varchar
text representation of month
sample_id
int2
Shellfish survey sample ID
a3oth_name_of_city_near_beach_most_used
varchar
Name of city not in list nearest beach respondent uses most to harvest shellfish
a11_consume_clams_or_oyster_frequency
varchar
Frequency respondent eats meals containing clams or oysters harvested from Puget Sound
third_survey_packet_mailed_date_whid
int8
Warehouse identifier for third survey packet mailed date
other_mail_disposition_date_dim$day_of_month
int2
numeric representation of the day in month
third_survey_packet_mailed_date_dim$month_of_year
int2
numeric representation of month of year
a8oth_other_lodging_most_used_type
varchar
Other type of lodging used for one or more overnight stays at the most often used beach recreationally harvesting shellfish
final_mail_disposition_date_dim$month_abbrev
bpchar
three character representation of month in capital letters
c5_period_of_closure
varchar
Period of closure for questions in section C5
c3_species_closed_to_harvest
varchar
Species that are closed to harvest for questions in section C3
post_card_mailed_date_dim$month_abbrev
bpchar
three character representation of month in capital letters
b11_2_number_kept_last_trip_geoduck_clams
int2
Quantity of geoduck clams kept on last Puget Sound trip
b11_5_number_kept_last_trip_other
int2
Quantity of other clams kept on last Puget Sound trip
c5_2c_quantity_harvest_trips_nearby_beach_during_most_used_open_9_months
int2
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
d4b_household_child_size
int2
Number of children (under 18) within household
c3_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season
int2
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
sample_birth_date_dim$year
int4
numeric representation of year
final_mail_disposition_date_dim$yyyymmdd
bpchar
text representation of year month day
last_call_date_dim$full_date
timestamp
full date value
prenotice_letter_mailed_date_dim$day_of_month
int2
numeric representation of the day in month
sample_birth_date_whid
int8
Warehouse identifier for birthdate from sample
d2_sex_whid
int2
Warehouse identifier of gender of respondent per questionaire
second_survey_packet_mailed_date_dim$record_type
varchar
date, month, or year record or reason record is unavailable
c5_2b_quantity_nonharvest_trips_most_used_beach_during_open_9_months
int2
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
c3_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season
int2
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
last_call_date_dim$day_of_month
int2
numeric representation of the day in month
b701_car_travel_last_trip
varchar
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by car or not
c3_1a_quantity_harvest_trips_most_used_beach_closed_all_season
int2
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season
a3_name_of_city_near_beach_most_used
varchar
Name of city from a list of cities that is nearest the beach respondent uses most to harvest shellfish
third_survey_packet_mailed_date_dim$month_abbrev
bpchar
three character representation of month in capital letters
c5_1a_quantity_harvest_trips_most_used_beach_closed_3_months
int2
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 3 month closure
c6_1b_quantity_nonharvest_trips_most_used_beach_closed_1_ month
int2
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 1 month closure
d8_2_paid_time_off_work
varchar
Indicates if respondent took paid time off (vacation, sick, etc.) to harvest shellfish
b9oth_other_lodging_type_last_trip
varchar
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
other_mail_disposition_date_dim$full_date
timestamp
full date value
second_survey_packet_mailed_date_dim$month_name
varchar
text representation of month
initial_survey_packet_mailed_date_dim$yyyymmdd
bpchar
text representation of year month day
a603_foot_travel_beach_most_used
varchar
Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by foot
second_survey_packet_mailed_date_dim$full_date
timestamp
full date value
c4_additional_distance_to_nearby_fully_open_beach
varchar
Additional distance to nearby beach that is fully open for questions in section C4
third_survey_packet_mailed_date_dim$day_of_month
int2
numeric representation of the day in month
c6_type_of_closure
varchar
Type of closure for questions in section C6
b2_days_spent_last_trip
int2
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
a8_lodging_beach_most_used
varchar
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?
master_id
int2
Shellfish survey master ID
b12c2_number_people_last_trip_parking_launch
int2
Number people covered on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar
b1102_target_geoduck_clams_last_trip
varchar
Indicates if geoduck clams were the target or harvested on last Puget Sound trip
second_survey_packet_mailed_date_dim$day_of_month
int2
numeric representation of the day in month
a10e_reason_get_some_exercise_rating
varchar
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
c1_trip_months_list
varchar
Concatenated list of month names in which surveyor takes trips to harvest clams or oysters in Puget Sound
b10_1_miles_by_car_last_overnight_trip
int4
Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster overnight trip
d8_1_no_time_off_work
varchar
Indicates if respondent did not take time off to harvest shellfish
residential_street
varchar
Residential street address
c4_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season
int2
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
prenotice_letter_mailed_date_whid
int8
Warehouse identifier for prenotice letter mailed date
post_card_mailed_date_dim$yyyymmdd
bpchar
text representation of year month day
c6_1c_quantity_harvest_trips_nearby_beach_most_used_closed_1_month
int2
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
final_mail_disposition_date_dim$year
int4
numeric representation of year
b12a2_number_people_last_trip_land_vehicle
int2
Number people covered on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar
b3_days_spent_harvesting_last_trip
int2
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
sample_sex_dim$record_type
varchar
latitude record type or reason record is unavailable
b12c1_money_spent_last_trip_parking_launch
int2
Money spent on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar
a6_1_miles_by_car_beach_most_used
int4
Number of one way miles travelled by car to most used beach recreationally harvesting shellfish in the last 12 months measured to nearest mile
c2b_quantity_nonharvest_trips_most_used_beach_open_all_season
int2
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
c5_additional_distance_to_nearby_fully_open_beach
varchar
Additional distance to nearby beach that is fully open for questions in section C5
b12e1_money_spent_last_trip_other_transport
int2
Money spent on last Puget Sound trip by self or household on other transport rounded to nearest dollar
sample_birth_date_dim$month_abbrev
bpchar
three character representation of month in capital letters
a601_car_travel_beach_most_used
varchar
Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by car
a602_boat_travel_beach_most_used
varchar
Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by boat
d2_sex_dim$sex
varchar
b12j1_money_spent_last_trip_restaurants_bars
int2
Money spent on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar
a2eoth_other_shellfish_harvested
varchar
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
a2a_days_harvesting_clams
int2
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
sample_birth_date_dim$yyyymmdd
bpchar
text representation of year month day
a10d_reason_relax_rating
varchar
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
post_card_mailed_date_dim$day_of_month
int2
numeric representation of the day in month
initial_survey_packet_mailed_date_dim$year
int4
numeric representation of year
d2_sex_dim$record_type
varchar
latitude record type or reason record is unavailable
b12g1_money_spent_last_trip_hotels
int2
Money spent on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar
b9_lodging_type_last_trip
varchar
The type of lodging used one or more nights at most recent Puget Sound clam (not razor clams) or oyster trip
other_mail_disposition_date_whid
int8
Warehouse identifier for other mail disposition date
b5_beach_access_type_last_trip
varchar
Access type of the beach most recently used in the Puget Sound to harvest clams (not razor clams) or oysters
b12k2_number_people_last_trip_other_lodging_food
int2
Number people covered on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar
c3_additional_distance_to_nearby_fully_open_beach
varchar
Additional distance to nearby beach that is fully open for questions in section C3
shellfish_2013
varchar
Indicates if respondent purchased shellfish license in 2013
post_card_mailed_date_dim$month_of_year
int2
numeric representation of month of year
c5_1b_quantity_nonharvest_trips_most_used_beach_closed_3_months
int2
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 3 month closure
c3_type_of_closure
varchar
Type of closure for questions in section C3
second_survey_packet_mailed_date_whid
int8
Warehouse identifier for second survey packet mailed date
d8_3_unpaid_time_off_work
varchar
Indicates if respondent took unpaid time off to harvest shellfish
sample_sex_dim$sex_abbreviation
bpchar
c4_1a_quantity_harvest_trips_most_used_beach_closed_all_season
int2
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season
q7_respondent_income_range
varchar
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.
b6_beach_name_last_trip
varchar
Name of most recent beach in Puget Sound to harvest clams (not razor clams) or oysters
q4_miles_travel_to_harvest_beach
int
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?
b12d2_number_people_last_trip_ferry
int2
Number people covered on last Puget Sound trip by self or household on ferry rounded to nearest dollar
d9_survey_comments
varchar
Additional comments from respondent
c5_species_closed_to_harvest
varchar
Species that are closed to harvest for questions in section C5
b12b1_money_spent_last_trip_water_vehicle
int2
Money spent on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar
q2_taken_trips_harvesting_oysters_clams
varchar
Have you taken any trips where you harvested oysters or clams in Puget Sound in the last 12 months?

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NWFSC) for inquiries on this record.

Item Identification

Title: shellfish_survey_fact_conf

Entity Information

Entity Type: Data Table
Description:

Puget Sound recreational shellfishing survey

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
b12g2_number_people_last_trip_hotels int2 Number people covered on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar
100
other_mail_disposition_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
b7_1_miles_by_car_last_trip int4 Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster trip
100
final_mail_disposition_date_dim$month_name varchar text representation of month
100
c6_period_of_closure varchar Period of closure for questions in section C6
100
last_call_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
b702_boat_travel_last_trip varchar Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by boat or not
100
sample_sex_whid int2 Warehouse identifier to gender from sample
100
a2b_days_harvesting_oysters int2 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
100
d6_employment_hours varchar 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)
100
d1_birth_year int2 Year of birth of respondent
100
q3_beach_access_harvesting_trip varchar On your harvesting trips in Puget Sound, do you typically harvest oysters or clams from a public beach or a private beach?
100
a2c_days_harvesting_crab int2 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
100
combo_2013 varchar Indicates if respondent purchased combination license in 2013
100
last_call_date_dim$year int4 numeric representation of year
100
final_mail_disposition_date_dim$day_of_month int2 numeric representation of the day in month
100
other_mail_disposition_date_dim$month_name varchar text representation of month
100
survey_version int2 Number of the survey version
100
c4_period_of_closure varchar Period of closure for questions in section C4
100
last_call_date_whid int8 Warehouse identifier for last call date
100
c4_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season int2 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
100
b10_2_miles_by_boat_last_overnight_trip int4 Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster overnight trip
100
final_mail_disposition_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
b8_primary_purpose_clam_oyster varchar Indicates if most recent Puget Sound clam (not razor clams) or oyster trip was to catch clam or oysters
100
c4_type_of_closure varchar Type of closure for questions in section C4
100
final_mail_disposition varchar Final mail disposition
100
b1103_target_horse_clams_last_trip varchar Indicates if horse clams were the target or harvested on last Puget Sound trip
100
prenotice_letter_mailed_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
a2e_days_harvesting_other int2 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
100
final_mail_disposition_date_dim$month_of_year int2 numeric representation of month of year
100
final_mail_disposition_date_whid int8 Warehouse identifier for final mail disposition date
100
post_card_mailed_date_whid int8 Warehouse identifier for post card mailed date
100
initial_survey_packet_mailed_date_dim$full_date timestamp full date value
67
sample_sex_dim$sex varchar
100
residential_zip varchar Residential zip
100
a10c_reason_spend_time_with_friends_or_others_rating varchar 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
100
c5_2a_quantity_harvest_trips_most_used_beach_during_open_9_months int2 Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 3 month closure
100
last_call_phone_disposition varchar Disposition of the last phone call
100
b11_3_number_kept_last_trip_horse_clams int2 Quantity of horse clams kept on last Puget Sound trip
100
residential_city varchar Residential city
100
c2a_quantity_harvest_trips_most_used_beach_open_all_season int2 Number of trips might take to harvest clams or oysters in Puget Sound at most used beach assuming no biotoxin or pollution closures
100
initial_survey_packet_mailed_date_whid int8 Warehouse identifier for initial survey packet mailed date
100
a10a_reason_spend_time_outdoors_rating varchar Respondent harvests clams or oysters in Puget Sound for the reason of spending time outdoors given a rating system
100
b12f1_money_spent_last_trip_camping int2 Money spent on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar
100
b12h1_money_spent_last_trip_vaca_rental int2 Money spent on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar
100
last_call_date_dim$month_of_year int2 numeric representation of month of year
100
b1101_target_steamer_clams_last_trip varchar Indicates if steam clams (manila, littleneck, butter, cockle, softshell, macoma) were the target or harvested on last Puget Sound trip
100
c6_1a_quantity_harvest_trips_most_used_beach_closed_1_month int2 Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 1 month closure
100
d7_hourly_wage_range varchar Approximate personal hourly wage rate range
100
b12eoth_other_transport_last_trip_type varchar Other transportation type on last Puget Sound trip
100
b12j2_number_people_last_trip_restaurants_bars int2 Number people covered on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar
100
second_survey_packet_mailed_date_dim$year int4 numeric representation of year
100
a1_razor_clam_harvest varchar Have you harvested RAZOR CLAMS in Washington in the last 12 months?
100
final_mail_disposition_date_dim$full_date timestamp full date value
100
a9_range_other_beaches_used varchar Concatenated list of ranges of other beaches used nearby the most used beach to recreationally harvest shellfish in the last 12 months
100
a2d_days_harvesting_shrimp int2 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
100
a6_2_miles_by_boat_beach_most_used int4 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
100
b12koth_other_lodging_food_last_trip_type varchar Other lodging or food type on last Puget Sound trip
100
b1104_target_oysters_last_trip varchar Indicates if oysters were the target or harvested on last Puget Sound trip
100
other_mail_disposition_date_dim$yyyymmdd bpchar text representation of year month day
100
b12k1_money_spent_last_trip_other_lodging_food int2 Money spent on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar
100
second_survey_packet_mailed_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
sample_birth_date_dim$month_of_year int2 numeric representation of month of year
100
b12f2_number_people_last_trip_camping int2 Number people covered on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar
100
c6_2b_quantity_nonharvest_trips_most_used_beach_during_opened_11_months int2 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
100
prenotice_letter_mailed_date_dim$month_of_year int2 numeric representation of month of year
100
b7_2_miles_by_boat_last_trip int4 Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster trip
100
c4_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season int2 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
100
b12a1_money_spent_last_trip_land_vehicle int2 Money spent on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar
100
sample_birth_date_dim$day_of_month int2 numeric representation of the day in month
100
c53_quantity_harvest_trips_nearby_beach_while_most_used_fully_open int2 Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open
100
c5_type_of_closure varchar Type of closure for questions in section C5
100
a4_beach_most_used_access_type varchar Type of access of the beach most used to recreationally harvest shellfish in the last 12 months
100
b1_month_last_trip int2 The month number of the last trip spent harvesting clams (not including razor clams) or oysters
100
c6_2a_quantity_harvest_trips_most_used_beach_during_opened_11_months int2 Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 1 month closure
100
b12d1_money_spent_last_trip_ferry int2 Money spent on last Puget Sound trip by self or household on ferry rounded to nearest dollar
100
initial_survey_packet_mailed_date_dim$month_name varchar text representation of month
100
b703_foot_travel_last_trip varchar Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by foot or not
100
a10b_reason_spend_time_with_family_rating varchar 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
100
b11oth_other_targetted_last_trip_type varchar Other type targetted or harvested at last trip in Puget Sound
100
prenotice_letter_mailed_date_dim$month_name varchar text representation of month
100
b1105_target_other_last_trip varchar Indicates if other type were the target or harvested on last Puget Sound trip
100
which_survey_completed int2 Which survey number was completed
100
b11_4_number_kept_last_trip_oysters int2 Quantity of oysters kept on last Puget Sound trip
100
last_call_date_dim$month_name varchar text representation of month
100
second_survey_packet_mailed_date_dim$month_of_year int2 numeric representation of month of year
100
b13_harvest_shellfish_next_12_months_likely_rating varchar Likeliness surveyor will take a trip to Puget Sound to harvest shellfish
100
second_survey_packet_mailed_date_dim$yyyymmdd bpchar text representation of year month day
100
last_call_date_dim$yyyymmdd bpchar text representation of year month day
100
a10g_reason_provide_food_for_family_rating varchar 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
100
third_survey_packet_mailed_date_dim$month_name varchar text representation of month
100
q5_harvest_shellfish_rating_next_12_mo varchar During the next 12 months, how likely is it that you will take a trip where you harvest shellfish in Puget Sound?
100
a2eot1_other_shellfish_harvested varchar 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
100
c3_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season int2 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
100
b12b2_number_people_last_trip_water_vehicle int2 Number people covered on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar
100
prenotice_letter_mailed_date_dim$yyyymmdd bpchar text representation of year month day
100
sample_birth_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
q6_respondent_birth_year int In what year were you born?
100
verified_address varchar Respondent verified address
100
initial_survey_packet_mailed_date_dim$day_of_month int2 numeric representation of the day in month
100
other_mail_disposition_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
a10f_reason_eat_self_caught_rating varchar 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
100
third_survey_packet_mailed_date_dim$year int4 numeric representation of year
100
d5_household_income_range varchar Best description of household total annual income before taxes
100
post_card_mailed_date_dim$full_date timestamp full date value
100
c6_additional_distance_to_nearby_fully_open_beach varchar Additional distance to nearby beach that is fully open for questions in section C6
100
post_card_mailed_date_dim$month_name varchar text representation of month
100
third_survey_packet_mailed_date_dim$yyyymmdd bpchar text representation of year month day
100
b12e2_number_people_last_trip_other_transport int2 Number people covered on last Puget Sound trip by self or household on other transport rounded to nearest dollar
100
b4_hours_spent_harvesting_last_trip int2 The number of hours (rounded to nearest hour) spent harvesting clams or oysters on most recent Puget Sound trip
100
d4a_household_adult_size int2 Number of adults within household including self
100
other_mail_disposition_date_dim$year int4 numeric representation of year
100
c3_period_of_closure varchar Period of closure for questions in section C3
100
a5_beach_most_used varchar Name of the beach most used to recreationally harvest shellfish in the last 12 months
100
last_call_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
c6_2c_quantity_harvest_trips_nearby_beach_during_most_used_opened_11_months int2 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
100
c4_species_closed_to_harvest varchar Species that are closed to harvest for questions in section C4
100
third_survey_packet_mailed_date_dim$full_date timestamp full date value
67
d2_sex_dim$sex_abbreviation bpchar
100
mail_comments varchar Mail comments
100
other_mail_disposition_date_dim$month_of_year int2 numeric representation of month of year
100
b1002_boat_travel_last_overnight_trip varchar Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by boat or not
100
third_survey_packet_mailed_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
a7_ferry_travel_beach_most_used varchar Do you take a ferry as part of your trip to get to the beach you most often used?
100
c6_species_closed_to_harvest varchar Species that are closed to harvest for questions in section C6
100
initial_survey_packet_mailed_date_dim$month_of_year int2 numeric representation of month of year
100
c63_quantity_harvest_trips_nearby_beach_while_most_used_fully_open int2 Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open
100
prenotice_letter_mailed_date_dim$year int4 numeric representation of year
100
b12i2_number_people_last_trip_grocery int2 Number people covered on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar
100
initial_survey_packet_mailed_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
b1001_car_travel_last_overnight_trip varchar Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by car or not
100
d3_education_level varchar Education level of respondent
100
b1003_foot_travel_last_overnight_trip varchar Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by foot or not
100
b12i1_money_spent_last_trip_grocery int2 Money spent on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar
100
prenotice_letter_mailed_date_dim$full_date timestamp full date value
100
call_length int2 Length of call measured in minutes
100
initial_survey_packet_mailed_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
post_card_mailed_date_dim$year int4 numeric representation of year
100
c5_1c_quantity_harvest_trips_nearby_beach_most_used_closed_3_months int2 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
100
sample_birth_date_dim$full_date timestamp full date value
100
prenotice_letter_mailed_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
b11_1_number_kept_last_trip_steamer_clams int2 Quantity of steam clams kept on last Puget Sound trip
100
b12h2_number_people_last_trip_vaca_rental int2 Number people covered on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar
100
a2eot0_other_shellfish_harvested varchar 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
100
post_card_mailed_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
other_mail_disposition int2 Other mail disposition
100
q1_taken_trips_harvesting_razor_clams varchar Have you taken any trips where you harvested razor clams in Washington in the last 12 months?
100
sample_birth_date_dim$month_name varchar text representation of month
100
sample_id int2 Shellfish survey sample ID
100
a3oth_name_of_city_near_beach_most_used varchar Name of city not in list nearest beach respondent uses most to harvest shellfish
100
a11_consume_clams_or_oyster_frequency varchar Frequency respondent eats meals containing clams or oysters harvested from Puget Sound
100
third_survey_packet_mailed_date_whid int8 Warehouse identifier for third survey packet mailed date
100
other_mail_disposition_date_dim$day_of_month int2 numeric representation of the day in month
100
third_survey_packet_mailed_date_dim$month_of_year int2 numeric representation of month of year
100
a8oth_other_lodging_most_used_type varchar Other type of lodging used for one or more overnight stays at the most often used beach recreationally harvesting shellfish
100
final_mail_disposition_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
c5_period_of_closure varchar Period of closure for questions in section C5
100
c3_species_closed_to_harvest varchar Species that are closed to harvest for questions in section C3
100
post_card_mailed_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
b11_2_number_kept_last_trip_geoduck_clams int2 Quantity of geoduck clams kept on last Puget Sound trip
100
b11_5_number_kept_last_trip_other int2 Quantity of other clams kept on last Puget Sound trip
100
c5_2c_quantity_harvest_trips_nearby_beach_during_most_used_open_9_months int2 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
100
d4b_household_child_size int2 Number of children (under 18) within household
100
c3_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season int2 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
100
sample_birth_date_dim$year int4 numeric representation of year
100
final_mail_disposition_date_dim$yyyymmdd bpchar text representation of year month day
100
last_call_date_dim$full_date timestamp full date value
100
prenotice_letter_mailed_date_dim$day_of_month int2 numeric representation of the day in month
100
sample_birth_date_whid int8 Warehouse identifier for birthdate from sample
100
d2_sex_whid int2 Warehouse identifier of gender of respondent per questionaire
100
second_survey_packet_mailed_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
c5_2b_quantity_nonharvest_trips_most_used_beach_during_open_9_months int2 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
100
c3_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season int2 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
100
last_call_date_dim$day_of_month int2 numeric representation of the day in month
100
b701_car_travel_last_trip varchar Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by car or not
100
c3_1a_quantity_harvest_trips_most_used_beach_closed_all_season int2 Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season
100
a3_name_of_city_near_beach_most_used varchar Name of city from a list of cities that is nearest the beach respondent uses most to harvest shellfish
100
third_survey_packet_mailed_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
c5_1a_quantity_harvest_trips_most_used_beach_closed_3_months int2 Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 3 month closure
100
c6_1b_quantity_nonharvest_trips_most_used_beach_closed_1_ month int2 Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 1 month closure
100
d8_2_paid_time_off_work varchar Indicates if respondent took paid time off (vacation, sick, etc.) to harvest shellfish
100
b9oth_other_lodging_type_last_trip varchar 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
100
other_mail_disposition_date_dim$full_date timestamp full date value
100
second_survey_packet_mailed_date_dim$month_name varchar text representation of month
100
initial_survey_packet_mailed_date_dim$yyyymmdd bpchar text representation of year month day
100
a603_foot_travel_beach_most_used varchar Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by foot
100
second_survey_packet_mailed_date_dim$full_date timestamp full date value
100
c4_additional_distance_to_nearby_fully_open_beach varchar Additional distance to nearby beach that is fully open for questions in section C4
100
third_survey_packet_mailed_date_dim$day_of_month int2 numeric representation of the day in month
100
c6_type_of_closure varchar Type of closure for questions in section C6
100
b2_days_spent_last_trip int2 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
100
a8_lodging_beach_most_used varchar 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?
100
master_id int2 Shellfish survey master ID
100
b12c2_number_people_last_trip_parking_launch int2 Number people covered on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar
100
b1102_target_geoduck_clams_last_trip varchar Indicates if geoduck clams were the target or harvested on last Puget Sound trip
100
second_survey_packet_mailed_date_dim$day_of_month int2 numeric representation of the day in month
100
a10e_reason_get_some_exercise_rating varchar 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
100
c1_trip_months_list varchar Concatenated list of month names in which surveyor takes trips to harvest clams or oysters in Puget Sound
100
b10_1_miles_by_car_last_overnight_trip int4 Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster overnight trip
100
d8_1_no_time_off_work varchar Indicates if respondent did not take time off to harvest shellfish
100
residential_street varchar Residential street address
100
c4_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season int2 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
100
prenotice_letter_mailed_date_whid int8 Warehouse identifier for prenotice letter mailed date
100
post_card_mailed_date_dim$yyyymmdd bpchar text representation of year month day
100
c6_1c_quantity_harvest_trips_nearby_beach_most_used_closed_1_month int2 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
100
final_mail_disposition_date_dim$year int4 numeric representation of year
100
b12a2_number_people_last_trip_land_vehicle int2 Number people covered on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar
100
b3_days_spent_harvesting_last_trip int2 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
100
sample_sex_dim$record_type varchar latitude record type or reason record is unavailable
100
b12c1_money_spent_last_trip_parking_launch int2 Money spent on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar
100
a6_1_miles_by_car_beach_most_used int4 Number of one way miles travelled by car to most used beach recreationally harvesting shellfish in the last 12 months measured to nearest mile
100
c2b_quantity_nonharvest_trips_most_used_beach_open_all_season int2 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
100
c5_additional_distance_to_nearby_fully_open_beach varchar Additional distance to nearby beach that is fully open for questions in section C5
100
b12e1_money_spent_last_trip_other_transport int2 Money spent on last Puget Sound trip by self or household on other transport rounded to nearest dollar
100
sample_birth_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
a601_car_travel_beach_most_used varchar Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by car
100
a602_boat_travel_beach_most_used varchar Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by boat
67
d2_sex_dim$sex varchar
100
b12j1_money_spent_last_trip_restaurants_bars int2 Money spent on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar
100
a2eoth_other_shellfish_harvested varchar 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
100
a2a_days_harvesting_clams int2 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
100
sample_birth_date_dim$yyyymmdd bpchar text representation of year month day
100
a10d_reason_relax_rating varchar 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
100
post_card_mailed_date_dim$day_of_month int2 numeric representation of the day in month
100
initial_survey_packet_mailed_date_dim$year int4 numeric representation of year
100
d2_sex_dim$record_type varchar latitude record type or reason record is unavailable
100
b12g1_money_spent_last_trip_hotels int2 Money spent on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar
100
b9_lodging_type_last_trip varchar The type of lodging used one or more nights at most recent Puget Sound clam (not razor clams) or oyster trip
100
other_mail_disposition_date_whid int8 Warehouse identifier for other mail disposition date
100
b5_beach_access_type_last_trip varchar Access type of the beach most recently used in the Puget Sound to harvest clams (not razor clams) or oysters
100
b12k2_number_people_last_trip_other_lodging_food int2 Number people covered on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar
100
c3_additional_distance_to_nearby_fully_open_beach varchar Additional distance to nearby beach that is fully open for questions in section C3
100
shellfish_2013 varchar Indicates if respondent purchased shellfish license in 2013
100
post_card_mailed_date_dim$month_of_year int2 numeric representation of month of year
100
c5_1b_quantity_nonharvest_trips_most_used_beach_closed_3_months int2 Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 3 month closure
100
c3_type_of_closure varchar Type of closure for questions in section C3
100
second_survey_packet_mailed_date_whid int8 Warehouse identifier for second survey packet mailed date
100
d8_3_unpaid_time_off_work varchar Indicates if respondent took unpaid time off to harvest shellfish
67
sample_sex_dim$sex_abbreviation bpchar
100
c4_1a_quantity_harvest_trips_most_used_beach_closed_all_season int2 Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season
100
q7_respondent_income_range varchar 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.
100
b6_beach_name_last_trip varchar Name of most recent beach in Puget Sound to harvest clams (not razor clams) or oysters
100
q4_miles_travel_to_harvest_beach int 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?
100
b12d2_number_people_last_trip_ferry int2 Number people covered on last Puget Sound trip by self or household on ferry rounded to nearest dollar
100
d9_survey_comments varchar Additional comments from respondent
100
c5_species_closed_to_harvest varchar Species that are closed to harvest for questions in section C5
100
b12b1_money_spent_last_trip_water_vehicle int2 Money spent on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar
100
q2_taken_trips_harvesting_oysters_clams varchar Have you taken any trips where you harvested oysters or clams in Puget Sound in the last 12 months?

Attribute Details

b12g2_number_people_last_trip_hotels

CC ID: 378330
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number people covered on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar

Allowed Values: 3-4

other_mail_disposition_date_dim$record_type

CC ID: 378331
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable

Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

b7_1_miles_by_car_last_trip

CC ID: 378332
Data Storage Type: int4
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster trip

Unit of Measure: mi
Allowed Values: 1-250

final_mail_disposition_date_dim$month_name

CC ID: 378333
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

c6_period_of_closure

CC ID: 378334
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Period of closure for questions in section C6

Allowed Values: 12 months, 3 months

last_call_date_dim$month_abbrev

CC ID: 378335
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

b702_boat_travel_last_trip

CC ID: 378336
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by boat or not

Allowed Values: Travelled by Boat, Not Travelled by Boat

sample_sex_whid

CC ID: 378337
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to gender from sample

a2b_days_harvesting_oysters

CC ID: 378338
Data Storage Type: int2
Max Length: 3
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

d6_employment_hours

CC ID: 378339
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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)

Allowed Values: Nonworking, Part-time, Full-time

d1_birth_year

CC ID: 378340
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Year of birth of respondent

q3_beach_access_harvesting_trip

CC ID: 378341
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

On your harvesting trips in Puget Sound, do you typically harvest oysters or clams from a public beach or a private beach?

Allowed Values: DON'T KNOW / NOT SURE, Private, Public, REFUSED

a2c_days_harvesting_crab

CC ID: 378342
Data Storage Type: int2
Max Length: 3
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

combo_2013

CC ID: 378343
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if respondent purchased combination license in 2013

Allowed Values: Combination License, No Combination License, NA

last_call_date_dim$year

CC ID: 378344
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

final_mail_disposition_date_dim$day_of_month

CC ID: 378345
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

Allowed Values: 1-31

other_mail_disposition_date_dim$month_name

CC ID: 378346
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

survey_version

CC ID: 378347
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of the survey version

c4_period_of_closure

CC ID: 378348
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Period of closure for questions in section C4

Allowed Values: 12 months, 3 months

last_call_date_whid

CC ID: 378349
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for last call date

c4_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season

CC ID: 378350
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-75

b10_2_miles_by_boat_last_overnight_trip

CC ID: 378351
Data Storage Type: int4
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster overnight trip

Unit of Measure: mi
Allowed Values: 1.0

final_mail_disposition_date_dim$record_type

CC ID: 378352
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable

Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

b8_primary_purpose_clam_oyster

CC ID: 378353
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Indicates if most recent Puget Sound clam (not razor clams) or oyster trip was to catch clam or oysters

Allowed Values: Clam or Oyster Primary Purpose, Clam or Oyster Not Primary Purpose

c4_type_of_closure

CC ID: 378354
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Type of closure for questions in section C4

Allowed Values: Biotoxin, Pollution

final_mail_disposition

CC ID: 378355
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Final mail disposition

Allowed Values: Bad Address, Blank, Complete, Opt-Out, Refused/Didn't Shellfish

b1103_target_horse_clams_last_trip

CC ID: 378356
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if horse clams were the target or harvested on last Puget Sound trip

Allowed Values: Horse Clam Target, Horse Clam Not Target

prenotice_letter_mailed_date_dim$month_abbrev

CC ID: 378357
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

a2e_days_harvesting_other

CC ID: 378358
Data Storage Type: int2
Max Length: 3
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

final_mail_disposition_date_dim$month_of_year

CC ID: 378359
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

Allowed Values: 1-12

final_mail_disposition_date_whid

CC ID: 378360
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for final mail disposition date

post_card_mailed_date_whid

CC ID: 378361
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for post card mailed date

initial_survey_packet_mailed_date_dim$full_date

CC ID: 378362
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

sample_sex_dim$sex

CC ID: 378363
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Unit of Measure: unspecified
Allowed Values: Any

residential_zip

CC ID: 378364
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Residential zip

a10c_reason_spend_time_with_friends_or_others_rating

CC ID: 378365
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree

c5_2a_quantity_harvest_trips_most_used_beach_during_open_9_months

CC ID: 378366
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 3 month closure

Allowed Values: 0-98

last_call_phone_disposition

CC ID: 378367
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Disposition of the last phone call

Allowed Values: 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

b11_3_number_kept_last_trip_horse_clams

CC ID: 378368
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Quantity of horse clams kept on last Puget Sound trip

Allowed Values: 0-14

residential_city

CC ID: 378369
Data Storage Type: varchar
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

Residential city

c2a_quantity_harvest_trips_most_used_beach_open_all_season

CC ID: 378370
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of trips might take to harvest clams or oysters in Puget Sound at most used beach assuming no biotoxin or pollution closures

Allowed Values: 0-75

initial_survey_packet_mailed_date_whid

CC ID: 378371
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for initial survey packet mailed date

a10a_reason_spend_time_outdoors_rating

CC ID: 378372
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Respondent harvests clams or oysters in Puget Sound for the reason of spending time outdoors given a rating system

Allowed Values: Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree

b12f1_money_spent_last_trip_camping

CC ID: 378373
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Money spent on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar

Allowed Values: 0-250

b12h1_money_spent_last_trip_vaca_rental

CC ID: 378374
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Money spent on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar

Allowed Values: 0-300

last_call_date_dim$month_of_year

CC ID: 378375
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

Allowed Values: 1-12

b1101_target_steamer_clams_last_trip

CC ID: 378376
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if steam clams (manila, littleneck, butter, cockle, softshell, macoma) were the target or harvested on last Puget Sound trip

Allowed Values: Steamer Clam Target, Steamer Clam Not Target

c6_1a_quantity_harvest_trips_most_used_beach_closed_1_month

CC ID: 378377
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 1 month closure

Allowed Values: 0-75

d7_hourly_wage_range

CC ID: 378378
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Approximate personal hourly wage rate range

Allowed Values: $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

b12eoth_other_transport_last_trip_type

CC ID: 378379
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Other transportation type on last Puget Sound trip

b12j2_number_people_last_trip_restaurants_bars

CC ID: 378380
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number people covered on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar

Allowed Values: 0-99

second_survey_packet_mailed_date_dim$year

CC ID: 378381
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

a1_razor_clam_harvest

CC ID: 378382
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Have you harvested RAZOR CLAMS in Washington in the last 12 months?

Allowed Values: Razor Clams Harvested, Razor Clams Not Harvested, Don't Know/Not Sure Razor Clams Harvested, Refused Response Razor Clams Harvesed

final_mail_disposition_date_dim$full_date

CC ID: 378383
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

a9_range_other_beaches_used

CC ID: 378384
Data Storage Type: varchar
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Concatenated list of ranges of other beaches used nearby the most used beach to recreationally harvest shellfish in the last 12 months

Allowed Values: None, Within 10 Miles, Between 11 and 20 Miles, Between 21 and 30 Miles, More than 30 miles

a2d_days_harvesting_shrimp

CC ID: 378385
Data Storage Type: int2
Max Length: 3
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

a6_2_miles_by_boat_beach_most_used

CC ID: 378386
Data Storage Type: int4
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Unit of Measure: mi
Allowed Values: 1-22

b12koth_other_lodging_food_last_trip_type

CC ID: 378387
Data Storage Type: varchar
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Other lodging or food type on last Puget Sound trip

Allowed Values: CABIN RENTAL, FRIEND'S HOUSE, GROCERIES, HARDWARE, NA

b1104_target_oysters_last_trip

CC ID: 378388
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Indicates if oysters were the target or harvested on last Puget Sound trip

Allowed Values: Oysters Target, Oysters Not Target

other_mail_disposition_date_dim$yyyymmdd

CC ID: 378389
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

b12k1_money_spent_last_trip_other_lodging_food

CC ID: 378390
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Money spent on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar

Allowed Values: 0-2000

second_survey_packet_mailed_date_dim$month_abbrev

CC ID: 378391
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

sample_birth_date_dim$month_of_year

CC ID: 378392
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

Allowed Values: 1-12

b12f2_number_people_last_trip_camping

CC ID: 378393
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number people covered on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar

Allowed Values: 0-5

c6_2b_quantity_nonharvest_trips_most_used_beach_during_opened_11_months

CC ID: 378394
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-67

prenotice_letter_mailed_date_dim$month_of_year

CC ID: 378395
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

Allowed Values: 1-12

b7_2_miles_by_boat_last_trip

CC ID: 378396
Data Storage Type: int4
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster trip

Unit of Measure: mi
Allowed Values: 2016/01/15 00:00:00.000

c4_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season

CC ID: 378397
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-75

b12a1_money_spent_last_trip_land_vehicle

CC ID: 378398
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Money spent on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar

Unit of Measure: dol

sample_birth_date_dim$day_of_month

CC ID: 378399
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

Allowed Values: 1-31

c53_quantity_harvest_trips_nearby_beach_while_most_used_fully_open

CC ID: 378400
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open

Allowed Values: 0-98

c5_type_of_closure

CC ID: 378401
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Type of closure for questions in section C5

Allowed Values: Biotoxin, Pollution

a4_beach_most_used_access_type

CC ID: 378402
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Type of access of the beach most used to recreationally harvest shellfish in the last 12 months

Allowed Values: Private beach, Public beach, Don't Know/Not Sure, Refused

b1_month_last_trip

CC ID: 378403
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

The month number of the last trip spent harvesting clams (not including razor clams) or oysters

Unit of Measure: mon
Allowed Values: 1-12

c6_2a_quantity_harvest_trips_most_used_beach_during_opened_11_months

CC ID: 378404
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 1 month closure

Allowed Values: 0-80

b12d1_money_spent_last_trip_ferry

CC ID: 378405
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Money spent on last Puget Sound trip by self or household on ferry rounded to nearest dollar

Allowed Values: 0-150

initial_survey_packet_mailed_date_dim$month_name

CC ID: 378406
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

b703_foot_travel_last_trip

CC ID: 378407
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by foot or not

Allowed Values: Travelled by Foot, Not Travelled by Foot

a10b_reason_spend_time_with_family_rating

CC ID: 378408
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree

b11oth_other_targetted_last_trip_type

CC ID: 378409
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Other type targetted or harvested at last trip in Puget Sound

Allowed Values: 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

prenotice_letter_mailed_date_dim$month_name

CC ID: 378410
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

b1105_target_other_last_trip

CC ID: 378411
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Indicates if other type were the target or harvested on last Puget Sound trip

Allowed Values: Other Target, Other Not Target

which_survey_completed

CC ID: 378412
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Which survey number was completed

b11_4_number_kept_last_trip_oysters

CC ID: 378413
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Quantity of oysters kept on last Puget Sound trip

Allowed Values: 0-999

last_call_date_dim$month_name

CC ID: 378414
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

second_survey_packet_mailed_date_dim$month_of_year

CC ID: 378415
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

Allowed Values: 1-12

b13_harvest_shellfish_next_12_months_likely_rating

CC ID: 378416
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Likeliness surveyor will take a trip to Puget Sound to harvest shellfish

Allowed Values: Definitely Will Harvest Shellfish, Very Likely, Somewhat Likely, Very Unlikely, Definitely Will Not Harvest Shellfish

second_survey_packet_mailed_date_dim$yyyymmdd

CC ID: 378417
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

last_call_date_dim$yyyymmdd

CC ID: 378418
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

a10g_reason_provide_food_for_family_rating

CC ID: 378419
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree

third_survey_packet_mailed_date_dim$month_name

CC ID: 378420
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

q5_harvest_shellfish_rating_next_12_mo

CC ID: 378421
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

During the next 12 months, how likely is it that you will take a trip where you harvest shellfish in Puget Sound?

Allowed Values: Definitely will harvest shellfish, Definitely will not harvest shellfish, Somewhat likely, Very likely, Very unlikely

a2eot1_other_shellfish_harvested

CC ID: 378422
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

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

c3_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season

CC ID: 378423
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-75

b12b2_number_people_last_trip_water_vehicle

CC ID: 378424
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number people covered on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar

Allowed Values: 1-8

prenotice_letter_mailed_date_dim$yyyymmdd

CC ID: 378425
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

sample_birth_date_dim$record_type

CC ID: 378426
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable

Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

q6_respondent_birth_year

CC ID: 378427
Data Storage Type: int
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

In what year were you born?

Allowed Values: 1929-1995, Refused

verified_address

CC ID: 378428
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Respondent verified address

Allowed Values: RESPONDENT REFUSED TO PARTICIPATE IN MAIL SURVEY, YES,

initial_survey_packet_mailed_date_dim$day_of_month

CC ID: 378429
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

Allowed Values: 1-31

other_mail_disposition_date_dim$month_abbrev

CC ID: 378430
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

a10f_reason_eat_self_caught_rating

CC ID: 378431
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree

third_survey_packet_mailed_date_dim$year

CC ID: 378432
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

d5_household_income_range

CC ID: 378433
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Best description of household total annual income before taxes

Allowed Values: 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

post_card_mailed_date_dim$full_date

CC ID: 378434
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

c6_additional_distance_to_nearby_fully_open_beach

CC ID: 378435
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Additional distance to nearby beach that is fully open for questions in section C6

Allowed Values: 30 miles away, 20 miles away, 10 miles away, 5 miles away

post_card_mailed_date_dim$month_name

CC ID: 378436
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

third_survey_packet_mailed_date_dim$yyyymmdd

CC ID: 378437
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

b12e2_number_people_last_trip_other_transport

CC ID: 378438
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number people covered on last Puget Sound trip by self or household on other transport rounded to nearest dollar

Allowed Values: 2

b4_hours_spent_harvesting_last_trip

CC ID: 378439
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

The number of hours (rounded to nearest hour) spent harvesting clams or oysters on most recent Puget Sound trip

Unit of Measure: hr
Allowed Values: 1-30

d4a_household_adult_size

CC ID: 378440
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of adults within household including self

Allowed Values: 1-6

other_mail_disposition_date_dim$year

CC ID: 378441
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

c3_period_of_closure

CC ID: 378442
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Period of closure for questions in section C3

Allowed Values: 12 months, 3 months

a5_beach_most_used

CC ID: 378443
Data Storage Type: varchar
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Name of the beach most used to recreationally harvest shellfish in the last 12 months

last_call_date_dim$record_type

CC ID: 378444
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable

Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

c6_2c_quantity_harvest_trips_nearby_beach_during_most_used_opened_11_months

CC ID: 378445
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-20

c4_species_closed_to_harvest

CC ID: 378446
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Species that are closed to harvest for questions in section C4

Allowed Values: Clams/Oysters, Razor Clams

third_survey_packet_mailed_date_dim$full_date

CC ID: 378447
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

d2_sex_dim$sex_abbreviation

CC ID: 378448
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Unit of Measure: unspecified
Allowed Values: Any

mail_comments

CC ID: 378449
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Mail comments

Allowed Values: Remove from list, Was Forwarded

other_mail_disposition_date_dim$month_of_year

CC ID: 378450
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

Allowed Values: 1-12

b1002_boat_travel_last_overnight_trip

CC ID: 378451
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by boat or not

Allowed Values: Travelled by Boat, Not Travelled by Boat

third_survey_packet_mailed_date_dim$record_type

CC ID: 378452
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable

Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

a7_ferry_travel_beach_most_used

CC ID: 378453
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Do you take a ferry as part of your trip to get to the beach you most often used?

Allowed Values: No, Yes

c6_species_closed_to_harvest

CC ID: 378454
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Species that are closed to harvest for questions in section C6

Allowed Values: Clams/Oysters, Razor Clams

initial_survey_packet_mailed_date_dim$month_of_year

CC ID: 378455
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

Allowed Values: 1-12

c63_quantity_harvest_trips_nearby_beach_while_most_used_fully_open

CC ID: 378456
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open

Allowed Values: 0-36

prenotice_letter_mailed_date_dim$year

CC ID: 378457
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

b12i2_number_people_last_trip_grocery

CC ID: 378458
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number people covered on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar

Allowed Values: 0-99

initial_survey_packet_mailed_date_dim$record_type

CC ID: 378459
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable

Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

b1001_car_travel_last_overnight_trip

CC ID: 378460
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by car or not

Allowed Values: Travelled by Car, Not Travelled by Car

d3_education_level

CC ID: 378461
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Education level of respondent

Allowed Values: Some High School, High School Graduate, Technical School, Some College, College Graduate or More

b1003_foot_travel_last_overnight_trip

CC ID: 378462
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by foot or not

Allowed Values: Travelled by Foot, Not Travelled by Foot

b12i1_money_spent_last_trip_grocery

CC ID: 378463
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Money spent on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar

Allowed Values: 0-1500

prenotice_letter_mailed_date_dim$full_date

CC ID: 378464
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

call_length

CC ID: 378465
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Length of call measured in minutes

Unit of Measure: min
Allowed Values: 0-17

initial_survey_packet_mailed_date_dim$month_abbrev

CC ID: 378466
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

post_card_mailed_date_dim$year

CC ID: 378467
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

c5_1c_quantity_harvest_trips_nearby_beach_most_used_closed_3_months

CC ID: 378468
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-75

sample_birth_date_dim$full_date

CC ID: 378469
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

prenotice_letter_mailed_date_dim$record_type

CC ID: 378470
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable

Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

b11_1_number_kept_last_trip_steamer_clams

CC ID: 378471
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Quantity of steam clams kept on last Puget Sound trip

Allowed Values: 0-120

b12h2_number_people_last_trip_vaca_rental

CC ID: 378472
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number people covered on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar

Allowed Values: 2.0

a2eot0_other_shellfish_harvested

CC ID: 378473
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

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

post_card_mailed_date_dim$record_type

CC ID: 378474
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable

Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

other_mail_disposition

CC ID: 378475
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Other mail disposition

q1_taken_trips_harvesting_razor_clams

CC ID: 378476
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Have you taken any trips where you harvested razor clams in Washington in the last 12 months?

Allowed Values: DON'T KNOW / NOT SURE, No, REFUSED, Yes

sample_birth_date_dim$month_name

CC ID: 378477
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

sample_id

CC ID: 378478
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Shellfish survey sample ID

a3oth_name_of_city_near_beach_most_used

CC ID: 378479
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Name of city not in list nearest beach respondent uses most to harvest shellfish

Allowed Values: PENROSE, SAMISH ISLAND, SAMISH ISLAND BEACH, TOLOMIE

a11_consume_clams_or_oyster_frequency

CC ID: 378480
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Frequency respondent eats meals containing clams or oysters harvested from Puget Sound

Allowed Values: Almost Never, About Once Per Year, Two or Three Times Per Year, Four to Ten Times Per Year, More Than Ten Times Per Year

third_survey_packet_mailed_date_whid

CC ID: 378481
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for third survey packet mailed date

other_mail_disposition_date_dim$day_of_month

CC ID: 378482
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

Allowed Values: 1-31

third_survey_packet_mailed_date_dim$month_of_year

CC ID: 378483
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

Allowed Values: 1-12

a8oth_other_lodging_most_used_type

CC ID: 378484
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Other type of lodging used for one or more overnight stays at the most often used beach recreationally harvesting shellfish

Allowed Values: 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

final_mail_disposition_date_dim$month_abbrev

CC ID: 378485
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

c5_period_of_closure

CC ID: 378486
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Period of closure for questions in section C5

Allowed Values: 12 months, 3 months

c3_species_closed_to_harvest

CC ID: 378487
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Species that are closed to harvest for questions in section C3

Allowed Values: Clams/Oysters, Razor Clams

post_card_mailed_date_dim$month_abbrev

CC ID: 378488
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

b11_2_number_kept_last_trip_geoduck_clams

CC ID: 378489
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Quantity of geoduck clams kept on last Puget Sound trip

Allowed Values: 0-20

b11_5_number_kept_last_trip_other

CC ID: 378490
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Quantity of other clams kept on last Puget Sound trip

Allowed Values: 1-240

c5_2c_quantity_harvest_trips_nearby_beach_during_most_used_open_9_months

CC ID: 378491
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-98

d4b_household_child_size

CC ID: 378492
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of children (under 18) within household

Allowed Values: 0-5

c3_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season

CC ID: 378493
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-75

sample_birth_date_dim$year

CC ID: 378494
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

final_mail_disposition_date_dim$yyyymmdd

CC ID: 378495
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

last_call_date_dim$full_date

CC ID: 378496
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

prenotice_letter_mailed_date_dim$day_of_month

CC ID: 378497
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

Allowed Values: 1-31

sample_birth_date_whid

CC ID: 378498
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for birthdate from sample

d2_sex_whid

CC ID: 378499
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier of gender of respondent per questionaire

second_survey_packet_mailed_date_dim$record_type

CC ID: 378500
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable

Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

c5_2b_quantity_nonharvest_trips_most_used_beach_during_open_9_months

CC ID: 378501
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-98

c3_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season

CC ID: 378502
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-75

last_call_date_dim$day_of_month

CC ID: 378503
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

Allowed Values: 1-31

b701_car_travel_last_trip

CC ID: 378504
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by car or not

Allowed Values: Travelled by Car, Not Travelled by Car

c3_1a_quantity_harvest_trips_most_used_beach_closed_all_season

CC ID: 378505
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season

Allowed Values: 0-75

a3_name_of_city_near_beach_most_used

CC ID: 378506
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Name of city from a list of cities that is nearest the beach respondent uses most to harvest shellfish

Allowed Values: Anacortes, Bellingham, Blaine, Bremerton, Brinnon, Everett, Hoodsport, Langly, Mount Vernon, Olympia, Orcas, Port Angeles, Port Townsend, Poulsbo, Seattle, Sekiu, Shelton, Tacoma, Other (SPECIFY)

third_survey_packet_mailed_date_dim$month_abbrev

CC ID: 378507
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

c5_1a_quantity_harvest_trips_most_used_beach_closed_3_months

CC ID: 378508
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 3 month closure

Allowed Values: 0-99

c6_1b_quantity_nonharvest_trips_most_used_beach_closed_1_ month

CC ID: 378509
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 1 month closure

Allowed Values: 0-50

d8_2_paid_time_off_work

CC ID: 378510
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Indicates if respondent took paid time off (vacation, sick, etc.) to harvest shellfish

Allowed Values: Paid Time Off, Not Paid Time Off

b9oth_other_lodging_type_last_trip

CC ID: 378511
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

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

other_mail_disposition_date_dim$full_date

CC ID: 378512
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

second_survey_packet_mailed_date_dim$month_name

CC ID: 378513
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

initial_survey_packet_mailed_date_dim$yyyymmdd

CC ID: 378514
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

a603_foot_travel_beach_most_used

CC ID: 378515
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by foot

Allowed Values: Travelled by Foot, Not Travelled by Foot

second_survey_packet_mailed_date_dim$full_date

CC ID: 378516
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

c4_additional_distance_to_nearby_fully_open_beach

CC ID: 378517
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Additional distance to nearby beach that is fully open for questions in section C4

Allowed Values: 30 miles away, 20 miles away, 10 miles away, 5 miles away

third_survey_packet_mailed_date_dim$day_of_month

CC ID: 378518
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

Allowed Values: 1-31

c6_type_of_closure

CC ID: 378519
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Type of closure for questions in section C6

Allowed Values: Biotoxin, Pollution

b2_days_spent_last_trip

CC ID: 378520
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Unit of Measure: days
Allowed Values: 1-13

a8_lodging_beach_most_used

CC ID: 378521
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

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?

Allowed Values: 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

master_id

CC ID: 378522
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Shellfish survey master ID

b12c2_number_people_last_trip_parking_launch

CC ID: 378523
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number people covered on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar

Allowed Values: 1-4

b1102_target_geoduck_clams_last_trip

CC ID: 378524
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if geoduck clams were the target or harvested on last Puget Sound trip

Allowed Values: Geoduck Clam Target, Geoduck Clam Not Target

second_survey_packet_mailed_date_dim$day_of_month

CC ID: 378525
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

Allowed Values: 1-31

a10e_reason_get_some_exercise_rating

CC ID: 378526
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree

c1_trip_months_list

CC ID: 378527
Data Storage Type: varchar
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Concatenated list of month names in which surveyor takes trips to harvest clams or oysters in Puget Sound

Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

b10_1_miles_by_car_last_overnight_trip

CC ID: 378528
Data Storage Type: int4
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster overnight trip

Unit of Measure: mi
Allowed Values: 0-80

d8_1_no_time_off_work

CC ID: 378529
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Indicates if respondent did not take time off to harvest shellfish

Allowed Values: No Time Off, Time Off

residential_street

CC ID: 378530
Data Storage Type: varchar
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Residential street address

c4_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season

CC ID: 378531
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-98

prenotice_letter_mailed_date_whid

CC ID: 378532
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for prenotice letter mailed date

post_card_mailed_date_dim$yyyymmdd

CC ID: 378533
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

c6_1c_quantity_harvest_trips_nearby_beach_most_used_closed_1_month

CC ID: 378534
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-18

final_mail_disposition_date_dim$year

CC ID: 378535
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

b12a2_number_people_last_trip_land_vehicle

CC ID: 378536
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number people covered on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar

b3_days_spent_harvesting_last_trip

CC ID: 378537
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Unit of Measure: days
Allowed Values: 1-11

sample_sex_dim$record_type

CC ID: 378538
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

latitude record type or reason record is unavailable

Unit of Measure: NA
Allowed Values: Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

b12c1_money_spent_last_trip_parking_launch

CC ID: 378539
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Money spent on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar

Allowed Values: 0-800

a6_1_miles_by_car_beach_most_used

CC ID: 378540
Data Storage Type: int4
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of one way miles travelled by car to most used beach recreationally harvesting shellfish in the last 12 months measured to nearest mile

Unit of Measure: mi
Allowed Values: 1-300

c2b_quantity_nonharvest_trips_most_used_beach_open_all_season

CC ID: 378541
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

Allowed Values: 0-80

c5_additional_distance_to_nearby_fully_open_beach

CC ID: 378542
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Additional distance to nearby beach that is fully open for questions in section C5

Allowed Values: 30 miles away, 20 miles away, 10 miles away, 5 miles away

b12e1_money_spent_last_trip_other_transport

CC ID: 378543
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Money spent on last Puget Sound trip by self or household on other transport rounded to nearest dollar

Allowed Values: 0-4

sample_birth_date_dim$month_abbrev

CC ID: 378544
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters

Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

a601_car_travel_beach_most_used

CC ID: 378545
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by car

Allowed Values: Travelled by Car, Not Travelled by Car

a602_boat_travel_beach_most_used

CC ID: 378546
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by boat

Allowed Values: Travelled by Boat, Not Travelled by Boat

d2_sex_dim$sex

CC ID: 378547
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Unit of Measure: unspecified
Allowed Values: Any

b12j1_money_spent_last_trip_restaurants_bars

CC ID: 378548
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Money spent on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar

Allowed Values: 0-400

a2eoth_other_shellfish_harvested

CC ID: 378549
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

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

a2a_days_harvesting_clams

CC ID: 378550
Data Storage Type: int2
Max Length: 3
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

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

sample_birth_date_dim$yyyymmdd

CC ID: 378551
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

a10d_reason_relax_rating

CC ID: 378552
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree

post_card_mailed_date_dim$day_of_month

CC ID: 378553
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month

Allowed Values: 1-31

initial_survey_packet_mailed_date_dim$year

CC ID: 378554
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year

Allowed Values: 1978+

d2_sex_dim$record_type

CC ID: 378555
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

latitude record type or reason record is unavailable

Unit of Measure: NA
Allowed Values: Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

b12g1_money_spent_last_trip_hotels

CC ID: 378556
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Money spent on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar

Allowed Values: 0-150

b9_lodging_type_last_trip

CC ID: 378557
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The type of lodging used one or more nights at most recent Puget Sound clam (not razor clams) or oyster trip

Allowed Values: None, House Self Owned, Vacation Rental, Hotel Motel or B&B, Campground or Trailer Park, Family or Friend's Home, Other

other_mail_disposition_date_whid

CC ID: 378558
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for other mail disposition date

b5_beach_access_type_last_trip

CC ID: 378559
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Access type of the beach most recently used in the Puget Sound to harvest clams (not razor clams) or oysters

Allowed Values: Private Beach, Public Beach, Don't Know/Not Sure, Refused

b12k2_number_people_last_trip_other_lodging_food

CC ID: 378560
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number people covered on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar

Allowed Values: 1-10

c3_additional_distance_to_nearby_fully_open_beach

CC ID: 378561
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Additional distance to nearby beach that is fully open for questions in section C3

Allowed Values: 30 miles away, 20 miles away, 10 miles away, 5 miles away

shellfish_2013

CC ID: 378562
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Indicates if respondent purchased shellfish license in 2013

Allowed Values: Shellfish License, No Shellfish License, NA

post_card_mailed_date_dim$month_of_year

CC ID: 378563
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year

Allowed Values: 1-12

c5_1b_quantity_nonharvest_trips_most_used_beach_closed_3_months

CC ID: 378564
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 3 month closure

Allowed Values: 0-50

c3_type_of_closure

CC ID: 378565
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Type of closure for questions in section C3

Allowed Values: Biotoxin, Pollution

second_survey_packet_mailed_date_whid

CC ID: 378566
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for second survey packet mailed date

d8_3_unpaid_time_off_work

CC ID: 378567
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Indicates if respondent took unpaid time off to harvest shellfish

Allowed Values: Unpaid Time Off, Not Unpaid Time Off

sample_sex_dim$sex_abbreviation

CC ID: 378568
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Unit of Measure: unspecified
Allowed Values: Any

c4_1a_quantity_harvest_trips_most_used_beach_closed_all_season

CC ID: 378569
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season

Allowed Values: 0-75

q7_respondent_income_range

CC ID: 378570
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

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.

Allowed Values: 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

b6_beach_name_last_trip

CC ID: 378571
Data Storage Type: varchar
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Name of most recent beach in Puget Sound to harvest clams (not razor clams) or oysters

q4_miles_travel_to_harvest_beach

CC ID: 378572
Data Storage Type: int
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

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?

Allowed Values: 1-350, Don't know/Not Sure, Less than one mile

b12d2_number_people_last_trip_ferry

CC ID: 378573
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Number people covered on last Puget Sound trip by self or household on ferry rounded to nearest dollar

Allowed Values: 1-8

d9_survey_comments

CC ID: 378574
Data Storage Type: varchar
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

Additional comments from respondent

c5_species_closed_to_harvest

CC ID: 378575
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Species that are closed to harvest for questions in section C5

Allowed Values: Clams/Oysters, Razor Clams

b12b1_money_spent_last_trip_water_vehicle

CC ID: 378576
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Money spent on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar

Allowed Values: 0-100

q2_taken_trips_harvesting_oysters_clams

CC ID: 378577
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Have you taken any trips where you harvested oysters or clams in Puget Sound in the last 12 months?

Allowed Values: DON'T KNOW / NOT SURE, No, REFUSED, Yes

Catalog Details

Catalog Item ID: 36444
GUID: gov.noaa.nmfs.inport:36444
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-25 13:22+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-02-13
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-02-13
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-02-13