shellfish_survey_fact_conf
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36444 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
full date value |
sample_sex_dim$sex
Data Storage Type: | varchar |
---|---|
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Unit of Measure: | unspecified |
Allowed Values: | Any |
residential_zip
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
full date value |
a9_range_other_beaches_used
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
full date value |
c6_additional_distance_to_nearby_fully_open_beach
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
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
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
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
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
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
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
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
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
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
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
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
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
full date value |
d2_sex_dim$sex_abbreviation
Data Storage Type: | bpchar |
---|---|
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Unit of Measure: | unspecified |
Allowed Values: | Any |
mail_comments
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
full date value |
call_length
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
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
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
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
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
full date value |
prenotice_letter_mailed_date_dim$record_type
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
full date value |
prenotice_letter_mailed_date_dim$day_of_month
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
full date value |
second_survey_packet_mailed_date_dim$month_name
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
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
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
Data Storage Type: | timestamp |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
full date value |
c4_additional_distance_to_nearby_fully_open_beach
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Data Storage Type: | varchar |
---|---|
Max Length: | 1000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Additional comments from respondent |
c5_species_closed_to_harvest
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
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
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 |