shellfish_survey_fact_conf
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36444 | Updated: August 9, 2022 | Published / External
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
CC ID: 378330
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number people covered on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar |
| Allowed Values: | 3-4 |
other_mail_disposition_date_dim$record_type
CC ID: 378331
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
b7_1_miles_by_car_last_trip
CC ID: 378332
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster trip |
| Unit of Measure: | mi |
| Allowed Values: | 1-250 |
final_mail_disposition_date_dim$month_name
CC ID: 378333
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
c6_period_of_closure
CC ID: 378334
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Period of closure for questions in section C6 |
| Allowed Values: | 12 months, 3 months |
last_call_date_dim$month_abbrev
CC ID: 378335
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
b702_boat_travel_last_trip
CC ID: 378336
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by boat or not |
| Allowed Values: | Travelled by Boat, Not Travelled by Boat |
sample_sex_whid
CC ID: 378337
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier to gender from sample |
a2b_days_harvesting_oysters
CC ID: 378338
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days in the last 12 months spent recreationally harvesting oysters in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
d6_employment_hours
CC ID: 378339
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Employment hours (nonworking includes homemakers, retired, or currently unemployed, part time equates to 35 hours or less, full time equates to more than 35 hours) |
| Allowed Values: | Nonworking, Part-time, Full-time |
d1_birth_year
CC ID: 378340
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Year of birth of respondent |
q3_beach_access_harvesting_trip
CC ID: 378341
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
On your harvesting trips in Puget Sound, do you typically harvest oysters or clams from a public beach or a private beach? |
| Allowed Values: | DON'T KNOW / NOT SURE, Private, Public, REFUSED |
a2c_days_harvesting_crab
CC ID: 378342
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days in the last 12 months spent recreationally harvesting crab in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
combo_2013
CC ID: 378343
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if respondent purchased combination license in 2013 |
| Allowed Values: | Combination License, No Combination License, NA |
last_call_date_dim$year
CC ID: 378344
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
final_mail_disposition_date_dim$day_of_month
CC ID: 378345
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
other_mail_disposition_date_dim$month_name
CC ID: 378346
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
survey_version
CC ID: 378347
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of the survey version |
c4_period_of_closure
CC ID: 378348
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Period of closure for questions in section C4 |
| Allowed Values: | 12 months, 3 months |
last_call_date_whid
CC ID: 378349
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for last call date |
c4_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season
CC ID: 378350
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach that was closed all season |
| Allowed Values: | 0-75 |
b10_2_miles_by_boat_last_overnight_trip
CC ID: 378351
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster overnight trip |
| Unit of Measure: | mi |
| Allowed Values: | 1.0 |
final_mail_disposition_date_dim$record_type
CC ID: 378352
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
b8_primary_purpose_clam_oyster
CC ID: 378353
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if most recent Puget Sound clam (not razor clams) or oyster trip was to catch clam or oysters |
| Allowed Values: | Clam or Oyster Primary Purpose, Clam or Oyster Not Primary Purpose |
c4_type_of_closure
CC ID: 378354
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Type of closure for questions in section C4 |
| Allowed Values: | Biotoxin, Pollution |
final_mail_disposition
CC ID: 378355
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Final mail disposition |
| Allowed Values: | Bad Address, Blank, Complete, Opt-Out, Refused/Didn't Shellfish |
b1103_target_horse_clams_last_trip
CC ID: 378356
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if horse clams were the target or harvested on last Puget Sound trip |
| Allowed Values: | Horse Clam Target, Horse Clam Not Target |
prenotice_letter_mailed_date_dim$month_abbrev
CC ID: 378357
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
a2e_days_harvesting_other
CC ID: 378358
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days in the last 12 months spent recreationally harvesting other shellfish in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
final_mail_disposition_date_dim$month_of_year
CC ID: 378359
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
final_mail_disposition_date_whid
CC ID: 378360
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for final mail disposition date |
post_card_mailed_date_whid
CC ID: 378361
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for post card mailed date |
initial_survey_packet_mailed_date_dim$full_date
CC ID: 378362
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
sample_sex_dim$sex
CC ID: 378363
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
residential_zip
CC ID: 378364
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Residential zip |
a10c_reason_spend_time_with_friends_or_others_rating
CC ID: 378365
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Respondent harvests clams or oysters in Puget Sound for the reason of spending time with friends or others given a rating system of 5 for strongly agree and 1 for strongly disagree |
| Allowed Values: | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
c5_2a_quantity_harvest_trips_most_used_beach_during_open_9_months
CC ID: 378366
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 3 month closure |
| Allowed Values: | 0-98 |
last_call_phone_disposition
CC ID: 378367
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Disposition of the last phone call |
| Allowed Values: | ANSWERING MACHINE, BREAK OFF DURING SCREENER, BUSY, CHANGED NUMBER, CLAIMS PREVIOUS INTERVIEW, COMPLETED SURVEY, INITIAL (HARD) REFUSAL, NO ANSWER, NON-RESIDENTIAL NUMBER, NON-WORKING NUMBER, OTHER LANGUAGE BARRIER / HEARING PROBLEM, OTHER PHONE PROBLEM, OTHER PHONE PROBLEMS, QUALIFIED REFUSAL, SPANISH LANGUAGE BARRIER, SPECIFIED CALLBACK, TERMINATE INVITATION, TERMINATE Q2, UNSPECIFIED CALLBACK, WRONG NUMBER |
b11_3_number_kept_last_trip_horse_clams
CC ID: 378368
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Quantity of horse clams kept on last Puget Sound trip |
| Allowed Values: | 0-14 |
residential_city
CC ID: 378369
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 80 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Residential city |
c2a_quantity_harvest_trips_most_used_beach_open_all_season
CC ID: 378370
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach assuming no biotoxin or pollution closures |
| Allowed Values: | 0-75 |
initial_survey_packet_mailed_date_whid
CC ID: 378371
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for initial survey packet mailed date |
a10a_reason_spend_time_outdoors_rating
CC ID: 378372
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Respondent harvests clams or oysters in Puget Sound for the reason of spending time outdoors given a rating system |
| Allowed Values: | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
b12f1_money_spent_last_trip_camping
CC ID: 378373
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Money spent on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar |
| Allowed Values: | 0-250 |
b12h1_money_spent_last_trip_vaca_rental
CC ID: 378374
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Money spent on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar |
| Allowed Values: | 0-300 |
last_call_date_dim$month_of_year
CC ID: 378375
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
b1101_target_steamer_clams_last_trip
CC ID: 378376
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if steam clams (manila, littleneck, butter, cockle, softshell, macoma) were the target or harvested on last Puget Sound trip |
| Allowed Values: | Steamer Clam Target, Steamer Clam Not Target |
c6_1a_quantity_harvest_trips_most_used_beach_closed_1_month
CC ID: 378377
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 1 month closure |
| Allowed Values: | 0-75 |
d7_hourly_wage_range
CC ID: 378378
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Approximate personal hourly wage rate range |
| Allowed Values: | $5.00-$9.99, $10.00-$14.99, $15.00-$19.99, $20.00-$29.99, $30.00-$39.99, $40.00-$49.99, $50.00-$59.99, $60.00-$74.99, $75.00 or More |
b12eoth_other_transport_last_trip_type
CC ID: 378379
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Other transportation type on last Puget Sound trip |
b12j2_number_people_last_trip_restaurants_bars
CC ID: 378380
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number people covered on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar |
| Allowed Values: | 0-99 |
second_survey_packet_mailed_date_dim$year
CC ID: 378381
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
a1_razor_clam_harvest
CC ID: 378382
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Have you harvested RAZOR CLAMS in Washington in the last 12 months? |
| Allowed Values: | Razor Clams Harvested, Razor Clams Not Harvested, Don't Know/Not Sure Razor Clams Harvested, Refused Response Razor Clams Harvesed |
final_mail_disposition_date_dim$full_date
CC ID: 378383
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
a9_range_other_beaches_used
CC ID: 378384
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Concatenated list of ranges of other beaches used nearby the most used beach to recreationally harvest shellfish in the last 12 months |
| Allowed Values: | None, Within 10 Miles, Between 11 and 20 Miles, Between 21 and 30 Miles, More than 30 miles |
a2d_days_harvesting_shrimp
CC ID: 378385
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days in the last 12 months spent recreationally harvesting shrimp in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
a6_2_miles_by_boat_beach_most_used
CC ID: 378386
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of one way miles travelled by boat (not including ferry) to most used beach recreationally harvesting shellfish in the last 12 months measured to nearest mile |
| Unit of Measure: | mi |
| Allowed Values: | 1-22 |
b12koth_other_lodging_food_last_trip_type
CC ID: 378387
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 60 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Other lodging or food type on last Puget Sound trip |
| Allowed Values: | CABIN RENTAL, FRIEND'S HOUSE, GROCERIES, HARDWARE, NA |
b1104_target_oysters_last_trip
CC ID: 378388
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if oysters were the target or harvested on last Puget Sound trip |
| Allowed Values: | Oysters Target, Oysters Not Target |
other_mail_disposition_date_dim$yyyymmdd
CC ID: 378389
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
b12k1_money_spent_last_trip_other_lodging_food
CC ID: 378390
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Money spent on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar |
| Allowed Values: | 0-2000 |
second_survey_packet_mailed_date_dim$month_abbrev
CC ID: 378391
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
sample_birth_date_dim$month_of_year
CC ID: 378392
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
b12f2_number_people_last_trip_camping
CC ID: 378393
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number people covered on last Puget Sound trip by self or household on campgrounds and trailer parks rounded to nearest dollar |
| Allowed Values: | 0-5 |
c6_2b_quantity_nonharvest_trips_most_used_beach_during_opened_11_months
CC ID: 378394
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during other months of 1 month closure |
| Allowed Values: | 0-67 |
prenotice_letter_mailed_date_dim$month_of_year
CC ID: 378395
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
b7_2_miles_by_boat_last_trip
CC ID: 378396
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of one way miles travelled by boat (not including ferry) to most used Pugent Sound clam (not razor clams) or oyster trip |
| Unit of Measure: | mi |
| Allowed Values: | 2016/01/15 00:00:00.000 |
c4_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season
CC ID: 378397
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was closed all season |
| Allowed Values: | 0-75 |
b12a1_money_spent_last_trip_land_vehicle
CC ID: 378398
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Money spent on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar |
| Unit of Measure: | dol |
sample_birth_date_dim$day_of_month
CC ID: 378399
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
c53_quantity_harvest_trips_nearby_beach_while_most_used_fully_open
CC ID: 378400
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open |
| Allowed Values: | 0-98 |
c5_type_of_closure
CC ID: 378401
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Type of closure for questions in section C5 |
| Allowed Values: | Biotoxin, Pollution |
a4_beach_most_used_access_type
CC ID: 378402
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Type of access of the beach most used to recreationally harvest shellfish in the last 12 months |
| Allowed Values: | Private beach, Public beach, Don't Know/Not Sure, Refused |
b1_month_last_trip
CC ID: 378403
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
The month number of the last trip spent harvesting clams (not including razor clams) or oysters |
| Unit of Measure: | mon |
| Allowed Values: | 1-12 |
c6_2a_quantity_harvest_trips_most_used_beach_during_opened_11_months
CC ID: 378404
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during other months of 1 month closure |
| Allowed Values: | 0-80 |
b12d1_money_spent_last_trip_ferry
CC ID: 378405
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Money spent on last Puget Sound trip by self or household on ferry rounded to nearest dollar |
| Allowed Values: | 0-150 |
initial_survey_packet_mailed_date_dim$month_name
CC ID: 378406
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
b703_foot_travel_last_trip
CC ID: 378407
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by foot or not |
| Allowed Values: | Travelled by Foot, Not Travelled by Foot |
a10b_reason_spend_time_with_family_rating
CC ID: 378408
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Respondent harvests clams or oysters in Puget Sound for the reason of spending time with family given a rating system of 5 for strongly agree and 1 for strongly disagree |
| Allowed Values: | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
b11oth_other_targetted_last_trip_type
CC ID: 378409
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Other type targetted or harvested at last trip in Puget Sound |
| Allowed Values: | BLUE MUSSLES AND BARNICKLE, BUTTER, BUTTER CLAMS, CLAMS, COCKLE, COCKLE, COCKLES, CRAB, CRAB DUNGENESS, LITTLE NECKS AND STEAMERS, LITTLE NECKS MANILA, MANILA, MUSSEL, MUSSELLS, MUSSELS, RED ROCK CRAB, REGISTERED WITH WSFW #42, SHRIMP, VARNISH CLAMS |
prenotice_letter_mailed_date_dim$month_name
CC ID: 378410
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
b1105_target_other_last_trip
CC ID: 378411
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if other type were the target or harvested on last Puget Sound trip |
| Allowed Values: | Other Target, Other Not Target |
which_survey_completed
CC ID: 378412
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Which survey number was completed |
b11_4_number_kept_last_trip_oysters
CC ID: 378413
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Quantity of oysters kept on last Puget Sound trip |
| Allowed Values: | 0-999 |
last_call_date_dim$month_name
CC ID: 378414
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
second_survey_packet_mailed_date_dim$month_of_year
CC ID: 378415
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
b13_harvest_shellfish_next_12_months_likely_rating
CC ID: 378416
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Likeliness surveyor will take a trip to Puget Sound to harvest shellfish |
| Allowed Values: | Definitely Will Harvest Shellfish, Very Likely, Somewhat Likely, Very Unlikely, Definitely Will Not Harvest Shellfish |
second_survey_packet_mailed_date_dim$yyyymmdd
CC ID: 378417
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
last_call_date_dim$yyyymmdd
CC ID: 378418
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
a10g_reason_provide_food_for_family_rating
CC ID: 378419
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Respondent harvests clams or oysters in Puget Sound for the reason of providing food for self or family given a rating system of 5 for strongly agree and 1 for strongly disagree |
| Allowed Values: | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
third_survey_packet_mailed_date_dim$month_name
CC ID: 378420
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
q5_harvest_shellfish_rating_next_12_mo
CC ID: 378421
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
During the next 12 months, how likely is it that you will take a trip where you harvest shellfish in Puget Sound? |
| Allowed Values: | Definitely will harvest shellfish, Definitely will not harvest shellfish, Somewhat likely, Very likely, Very unlikely |
a2eot1_other_shellfish_harvested
CC ID: 378422
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Other type of shellfish recreationally harvested in Puget Sound including the San Juan Islands, Strait of Juan de Fuca, and Hood Canal within the last 12 months |
c3_1b_quantity_nonharvest_trips_most_used_beach_closed_all_season
CC ID: 378423
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach that was closed all season |
| Allowed Values: | 0-75 |
b12b2_number_people_last_trip_water_vehicle
CC ID: 378424
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number people covered on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar |
| Allowed Values: | 1-8 |
prenotice_letter_mailed_date_dim$yyyymmdd
CC ID: 378425
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
sample_birth_date_dim$record_type
CC ID: 378426
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
q6_respondent_birth_year
CC ID: 378427
| Data Storage Type: | int |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
In what year were you born? |
| Allowed Values: | 1929-1995, Refused |
verified_address
CC ID: 378428
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Respondent verified address |
| Allowed Values: | RESPONDENT REFUSED TO PARTICIPATE IN MAIL SURVEY, YES, |
initial_survey_packet_mailed_date_dim$day_of_month
CC ID: 378429
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
other_mail_disposition_date_dim$month_abbrev
CC ID: 378430
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
a10f_reason_eat_self_caught_rating
CC ID: 378431
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Respondent harvests clams or oysters in Puget Sound for the reason of eating something self caught given a rating system of 5 for strongly agree and 1 for strongly disagree |
| Allowed Values: | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
third_survey_packet_mailed_date_dim$year
CC ID: 378432
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
d5_household_income_range
CC ID: 378433
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Best description of household total annual income before taxes |
| Allowed Values: | Less than $20,000, $20,000-$39,999, $40,000-59,999, $60,000-$79,999, $80,000-$99,999, $100,000-$124,999, $125,000-$149,999, $150,000 or More |
post_card_mailed_date_dim$full_date
CC ID: 378434
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
c6_additional_distance_to_nearby_fully_open_beach
CC ID: 378435
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Additional distance to nearby beach that is fully open for questions in section C6 |
| Allowed Values: | 30 miles away, 20 miles away, 10 miles away, 5 miles away |
post_card_mailed_date_dim$month_name
CC ID: 378436
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
third_survey_packet_mailed_date_dim$yyyymmdd
CC ID: 378437
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
b12e2_number_people_last_trip_other_transport
CC ID: 378438
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number people covered on last Puget Sound trip by self or household on other transport rounded to nearest dollar |
| Allowed Values: | 2 |
b4_hours_spent_harvesting_last_trip
CC ID: 378439
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
The number of hours (rounded to nearest hour) spent harvesting clams or oysters on most recent Puget Sound trip |
| Unit of Measure: | hr |
| Allowed Values: | 1-30 |
d4a_household_adult_size
CC ID: 378440
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of adults within household including self |
| Allowed Values: | 1-6 |
other_mail_disposition_date_dim$year
CC ID: 378441
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
c3_period_of_closure
CC ID: 378442
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Period of closure for questions in section C3 |
| Allowed Values: | 12 months, 3 months |
a5_beach_most_used
CC ID: 378443
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 60 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name of the beach most used to recreationally harvest shellfish in the last 12 months |
last_call_date_dim$record_type
CC ID: 378444
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
c6_2c_quantity_harvest_trips_nearby_beach_during_most_used_opened_11_months
CC ID: 378445
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during other months of most used 1 month closure |
| Allowed Values: | 0-20 |
c4_species_closed_to_harvest
CC ID: 378446
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species that are closed to harvest for questions in section C4 |
| Allowed Values: | Clams/Oysters, Razor Clams |
third_survey_packet_mailed_date_dim$full_date
CC ID: 378447
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
d2_sex_dim$sex_abbreviation
CC ID: 378448
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
mail_comments
CC ID: 378449
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Mail comments |
| Allowed Values: | Remove from list, Was Forwarded |
other_mail_disposition_date_dim$month_of_year
CC ID: 378450
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
b1002_boat_travel_last_overnight_trip
CC ID: 378451
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by boat or not |
| Allowed Values: | Travelled by Boat, Not Travelled by Boat |
third_survey_packet_mailed_date_dim$record_type
CC ID: 378452
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
a7_ferry_travel_beach_most_used
CC ID: 378453
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Do you take a ferry as part of your trip to get to the beach you most often used? |
| Allowed Values: | No, Yes |
c6_species_closed_to_harvest
CC ID: 378454
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species that are closed to harvest for questions in section C6 |
| Allowed Values: | Clams/Oysters, Razor Clams |
initial_survey_packet_mailed_date_dim$month_of_year
CC ID: 378455
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
c63_quantity_harvest_trips_nearby_beach_while_most_used_fully_open
CC ID: 378456
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach while most used open |
| Allowed Values: | 0-36 |
prenotice_letter_mailed_date_dim$year
CC ID: 378457
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
b12i2_number_people_last_trip_grocery
CC ID: 378458
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number people covered on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar |
| Allowed Values: | 0-99 |
initial_survey_packet_mailed_date_dim$record_type
CC ID: 378459
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
b1001_car_travel_last_overnight_trip
CC ID: 378460
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by car or not |
| Allowed Values: | Travelled by Car, Not Travelled by Car |
d3_education_level
CC ID: 378461
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Education level of respondent |
| Allowed Values: | Some High School, High School Graduate, Technical School, Some College, College Graduate or More |
b1003_foot_travel_last_overnight_trip
CC ID: 378462
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster overnight trip was by foot or not |
| Allowed Values: | Travelled by Foot, Not Travelled by Foot |
b12i1_money_spent_last_trip_grocery
CC ID: 378463
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Money spent on last Puget Sound trip by self or household on grocery and convvenience stores rounded to nearest dollar |
| Allowed Values: | 0-1500 |
prenotice_letter_mailed_date_dim$full_date
CC ID: 378464
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
call_length
CC ID: 378465
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Length of call measured in minutes |
| Unit of Measure: | min |
| Allowed Values: | 0-17 |
initial_survey_packet_mailed_date_dim$month_abbrev
CC ID: 378466
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
post_card_mailed_date_dim$year
CC ID: 378467
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
c5_1c_quantity_harvest_trips_nearby_beach_most_used_closed_3_months
CC ID: 378468
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during most used 3 month closure |
| Allowed Values: | 0-75 |
sample_birth_date_dim$full_date
CC ID: 378469
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
prenotice_letter_mailed_date_dim$record_type
CC ID: 378470
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
b11_1_number_kept_last_trip_steamer_clams
CC ID: 378471
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Quantity of steam clams kept on last Puget Sound trip |
| Allowed Values: | 0-120 |
b12h2_number_people_last_trip_vaca_rental
CC ID: 378472
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number people covered on last Puget Sound trip by self or household on vacation rental rounded to nearest dollar |
| Allowed Values: | 2.0 |
a2eot0_other_shellfish_harvested
CC ID: 378473
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Other type of shellfish recreationally harvested in Puget Sound including the San Juan Islands, Strait of Juan de Fuca, and Hood Canal within the last 12 months |
post_card_mailed_date_dim$record_type
CC ID: 378474
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
other_mail_disposition
CC ID: 378475
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Other mail disposition |
q1_taken_trips_harvesting_razor_clams
CC ID: 378476
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Have you taken any trips where you harvested razor clams in Washington in the last 12 months? |
| Allowed Values: | DON'T KNOW / NOT SURE, No, REFUSED, Yes |
sample_birth_date_dim$month_name
CC ID: 378477
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
sample_id
CC ID: 378478
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Shellfish survey sample ID |
a3oth_name_of_city_near_beach_most_used
CC ID: 378479
| Data Storage Type: | varchar |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name of city not in list nearest beach respondent uses most to harvest shellfish |
| Allowed Values: | PENROSE, SAMISH ISLAND, SAMISH ISLAND BEACH, TOLOMIE |
a11_consume_clams_or_oyster_frequency
CC ID: 378480
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Frequency respondent eats meals containing clams or oysters harvested from Puget Sound |
| Allowed Values: | Almost Never, About Once Per Year, Two or Three Times Per Year, Four to Ten Times Per Year, More Than Ten Times Per Year |
third_survey_packet_mailed_date_whid
CC ID: 378481
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for third survey packet mailed date |
other_mail_disposition_date_dim$day_of_month
CC ID: 378482
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
third_survey_packet_mailed_date_dim$month_of_year
CC ID: 378483
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
a8oth_other_lodging_most_used_type
CC ID: 378484
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Other type of lodging used for one or more overnight stays at the most often used beach recreationally harvesting shellfish |
| Allowed Values: | BOAT, CABIN, CAMPING IN WOODS, FAMILY OWNED HOUSE, FAMILY OWNED VACATION HOME, FAMILY OWNS, FRIEND OWNED, FRIENDS, FRIEND'S, FRIEND'S BEACH HOUSE, FRIEND'S CABIN, FRIEND'S HOME, FRIEND'S HOUSE, FRIEND'S PLACE, LIVE ABOARD A BOAT, NA, NATIONAL FOREST CABIN, PARENTS (IN-LAWS), PARENT'S HOME, PARENT'S HOUSE, PRIVATE PROPERTY-CAMPING, RELATIONS, RELATIVE, RELATIVE'S HOME, STAY ON BOAT, STAY W/ FRIENDS, STAY WITH MY SON |
final_mail_disposition_date_dim$month_abbrev
CC ID: 378485
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
c5_period_of_closure
CC ID: 378486
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Period of closure for questions in section C5 |
| Allowed Values: | 12 months, 3 months |
c3_species_closed_to_harvest
CC ID: 378487
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species that are closed to harvest for questions in section C3 |
| Allowed Values: | Clams/Oysters, Razor Clams |
post_card_mailed_date_dim$month_abbrev
CC ID: 378488
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
b11_2_number_kept_last_trip_geoduck_clams
CC ID: 378489
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Quantity of geoduck clams kept on last Puget Sound trip |
| Allowed Values: | 0-20 |
b11_5_number_kept_last_trip_other
CC ID: 378490
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Quantity of other clams kept on last Puget Sound trip |
| Allowed Values: | 1-240 |
c5_2c_quantity_harvest_trips_nearby_beach_during_most_used_open_9_months
CC ID: 378491
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during other months of most used 3 month closure |
| Allowed Values: | 0-98 |
d4b_household_child_size
CC ID: 378492
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of children (under 18) within household |
| Allowed Values: | 0-5 |
c3_1c_quantity_harvest_trips_nearby_beach_most_used_closed_all_season
CC ID: 378493
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was closed all season |
| Allowed Values: | 0-75 |
sample_birth_date_dim$year
CC ID: 378494
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
final_mail_disposition_date_dim$yyyymmdd
CC ID: 378495
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
last_call_date_dim$full_date
CC ID: 378496
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
prenotice_letter_mailed_date_dim$day_of_month
CC ID: 378497
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
sample_birth_date_whid
CC ID: 378498
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for birthdate from sample |
d2_sex_whid
CC ID: 378499
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier of gender of respondent per questionaire |
second_survey_packet_mailed_date_dim$record_type
CC ID: 378500
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
c5_2b_quantity_nonharvest_trips_most_used_beach_during_open_9_months
CC ID: 378501
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during other months of 3 month closure |
| Allowed Values: | 0-98 |
c3_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season
CC ID: 378502
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was open all season |
| Allowed Values: | 0-75 |
last_call_date_dim$day_of_month
CC ID: 378503
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
b701_car_travel_last_trip
CC ID: 378504
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if travel to most recent Pugent Sound clam (not razor clams) or oyster trip was by car or not |
| Allowed Values: | Travelled by Car, Not Travelled by Car |
c3_1a_quantity_harvest_trips_most_used_beach_closed_all_season
CC ID: 378505
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season |
| Allowed Values: | 0-75 |
a3_name_of_city_near_beach_most_used
CC ID: 378506
| Data Storage Type: | varchar |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name of city from a list of cities that is nearest the beach respondent uses most to harvest shellfish |
| Allowed Values: | Anacortes, Bellingham, Blaine, Bremerton, Brinnon, Everett, Hoodsport, Langly, Mount Vernon, Olympia, Orcas, Port Angeles, Port Townsend, Poulsbo, Seattle, Sekiu, Shelton, Tacoma, Other (SPECIFY) |
third_survey_packet_mailed_date_dim$month_abbrev
CC ID: 378507
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
c5_1a_quantity_harvest_trips_most_used_beach_closed_3_months
CC ID: 378508
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach during 3 month closure |
| Allowed Values: | 0-99 |
c6_1b_quantity_nonharvest_trips_most_used_beach_closed_1_ month
CC ID: 378509
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 1 month closure |
| Allowed Values: | 0-50 |
d8_2_paid_time_off_work
CC ID: 378510
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if respondent took paid time off (vacation, sick, etc.) to harvest shellfish |
| Allowed Values: | Paid Time Off, Not Paid Time Off |
b9oth_other_lodging_type_last_trip
CC ID: 378511
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The type of lodging not available in list used one or more nights at most recent Puget Sound clam (not razor clams) or oyster trip |
other_mail_disposition_date_dim$full_date
CC ID: 378512
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
second_survey_packet_mailed_date_dim$month_name
CC ID: 378513
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
initial_survey_packet_mailed_date_dim$yyyymmdd
CC ID: 378514
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
a603_foot_travel_beach_most_used
CC ID: 378515
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by foot |
| Allowed Values: | Travelled by Foot, Not Travelled by Foot |
second_survey_packet_mailed_date_dim$full_date
CC ID: 378516
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
c4_additional_distance_to_nearby_fully_open_beach
CC ID: 378517
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Additional distance to nearby beach that is fully open for questions in section C4 |
| Allowed Values: | 30 miles away, 20 miles away, 10 miles away, 5 miles away |
third_survey_packet_mailed_date_dim$day_of_month
CC ID: 378518
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
c6_type_of_closure
CC ID: 378519
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Type of closure for questions in section C6 |
| Allowed Values: | Biotoxin, Pollution |
b2_days_spent_last_trip
CC ID: 378520
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
The number of days (partial days count as full days and includes travel) spent on the last whole trip to the most recent Puget Sound beach to harvest clam (not razor clams) or oysters |
| Unit of Measure: | days |
| Allowed Values: | 1-13 |
a8_lodging_beach_most_used
CC ID: 378521
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
On the trip(s) you took to the beach you most often used, did you usually stay one or more nights in a house you own, a vacation rental, a hotel / motel, or a campground? |
| Allowed Values: | No. This is usually a day trip, House Respondent Owns, Vacation Rental, Hotel Motel or B&B, Campground or Trailer Park, Family or Friend's Home, Other |
master_id
CC ID: 378522
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Shellfish survey master ID |
b12c2_number_people_last_trip_parking_launch
CC ID: 378523
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number people covered on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar |
| Allowed Values: | 1-4 |
b1102_target_geoduck_clams_last_trip
CC ID: 378524
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if geoduck clams were the target or harvested on last Puget Sound trip |
| Allowed Values: | Geoduck Clam Target, Geoduck Clam Not Target |
second_survey_packet_mailed_date_dim$day_of_month
CC ID: 378525
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
a10e_reason_get_some_exercise_rating
CC ID: 378526
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Respondent harvests clams or oysters in Puget Sound for the reason of getting some exercise given a rating system of 5 for strongly agree and 1 for strongly disagree |
| Allowed Values: | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
c1_trip_months_list
CC ID: 378527
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Concatenated list of month names in which surveyor takes trips to harvest clams or oysters in Puget Sound |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
b10_1_miles_by_car_last_overnight_trip
CC ID: 378528
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of one way miles travelled by car to most recent Pugent Sound clam (not razor clams) or oyster overnight trip |
| Unit of Measure: | mi |
| Allowed Values: | 0-80 |
d8_1_no_time_off_work
CC ID: 378529
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if respondent did not take time off to harvest shellfish |
| Allowed Values: | No Time Off, Time Off |
residential_street
CC ID: 378530
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Residential street address |
c4_2_quantity_harvest_trips_nearby_beach_most_used_not_closed_all_season
CC ID: 378531
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach if most used was open all season |
| Allowed Values: | 0-98 |
prenotice_letter_mailed_date_whid
CC ID: 378532
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for prenotice letter mailed date |
post_card_mailed_date_dim$yyyymmdd
CC ID: 378533
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
c6_1c_quantity_harvest_trips_nearby_beach_most_used_closed_1_month
CC ID: 378534
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at a nearby fully open beach during most used 1 month closure |
| Allowed Values: | 0-18 |
final_mail_disposition_date_dim$year
CC ID: 378535
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
b12a2_number_people_last_trip_land_vehicle
CC ID: 378536
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number people covered on last Puget Sound trip by self or household on auto, truck, or RV fuel rounded to nearest dollar |
b3_days_spent_harvesting_last_trip
CC ID: 378537
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
The number of days (partial days count as full days and includes travel) spent harvesting clam (not razor clams) or oysters at the most recent Pugent Sound trip |
| Unit of Measure: | days |
| Allowed Values: | 1-11 |
sample_sex_dim$record_type
CC ID: 378538
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
latitude record type or reason record is unavailable |
| Unit of Measure: | NA |
| Allowed Values: | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
b12c1_money_spent_last_trip_parking_launch
CC ID: 378539
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Money spent on last Puget Sound trip by self or household on parking or boat launch rounded to nearest dollar |
| Allowed Values: | 0-800 |
a6_1_miles_by_car_beach_most_used
CC ID: 378540
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of one way miles travelled by car to most used beach recreationally harvesting shellfish in the last 12 months measured to nearest mile |
| Unit of Measure: | mi |
| Allowed Values: | 1-300 |
c2b_quantity_nonharvest_trips_most_used_beach_open_all_season
CC ID: 378541
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach assuming no biotoxin or pollution closures |
| Allowed Values: | 0-80 |
c5_additional_distance_to_nearby_fully_open_beach
CC ID: 378542
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Additional distance to nearby beach that is fully open for questions in section C5 |
| Allowed Values: | 30 miles away, 20 miles away, 10 miles away, 5 miles away |
b12e1_money_spent_last_trip_other_transport
CC ID: 378543
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Money spent on last Puget Sound trip by self or household on other transport rounded to nearest dollar |
| Allowed Values: | 0-4 |
sample_birth_date_dim$month_abbrev
CC ID: 378544
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
a601_car_travel_beach_most_used
CC ID: 378545
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by car |
| Allowed Values: | Travelled by Car, Not Travelled by Car |
a602_boat_travel_beach_most_used
CC ID: 378546
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if travel to most used beach to recreationally harvest shellfish in the last 12 month was by boat |
| Allowed Values: | Travelled by Boat, Not Travelled by Boat |
d2_sex_dim$sex
CC ID: 378547
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
b12j1_money_spent_last_trip_restaurants_bars
CC ID: 378548
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Money spent on last Puget Sound trip by self or household on restaurants and bars rounded to nearest dollar |
| Allowed Values: | 0-400 |
a2eoth_other_shellfish_harvested
CC ID: 378549
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Other type of shellfish recreationally harvested in Puget Sound including the San Juan Islands, Strait of Juan de Fuca, and Hood Canal within the last 12 months |
a2a_days_harvesting_clams
CC ID: 378550
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days in the last 12 months spent recreationally harvesting clams (other than razor clams) in Puget Sound including San Juan Islands, Strait of Juan de Fuca, and Hood Canal |
sample_birth_date_dim$yyyymmdd
CC ID: 378551
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
a10d_reason_relax_rating
CC ID: 378552
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Respondent harvests clams or oysters in Puget Sound for the reason of relaxing given a rating system of 5 for strongly agree and 1 for strongly disagree |
| Allowed Values: | Strongly Agree, Agree, Feel Neutral, Disagree, Strongly Disagree |
post_card_mailed_date_dim$day_of_month
CC ID: 378553
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
initial_survey_packet_mailed_date_dim$year
CC ID: 378554
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
d2_sex_dim$record_type
CC ID: 378555
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
latitude record type or reason record is unavailable |
| Unit of Measure: | NA |
| Allowed Values: | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
b12g1_money_spent_last_trip_hotels
CC ID: 378556
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Money spent on last Puget Sound trip by self or household on hotels, motels, and B&B rounded to nearest dollar |
| Allowed Values: | 0-150 |
b9_lodging_type_last_trip
CC ID: 378557
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The type of lodging used one or more nights at most recent Puget Sound clam (not razor clams) or oyster trip |
| Allowed Values: | None, House Self Owned, Vacation Rental, Hotel Motel or B&B, Campground or Trailer Park, Family or Friend's Home, Other |
other_mail_disposition_date_whid
CC ID: 378558
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for other mail disposition date |
b5_beach_access_type_last_trip
CC ID: 378559
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Access type of the beach most recently used in the Puget Sound to harvest clams (not razor clams) or oysters |
| Allowed Values: | Private Beach, Public Beach, Don't Know/Not Sure, Refused |
b12k2_number_people_last_trip_other_lodging_food
CC ID: 378560
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number people covered on last Puget Sound trip by self or household on other lodging or food rounded to nearest dollar |
| Allowed Values: | 1-10 |
c3_additional_distance_to_nearby_fully_open_beach
CC ID: 378561
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Additional distance to nearby beach that is fully open for questions in section C3 |
| Allowed Values: | 30 miles away, 20 miles away, 10 miles away, 5 miles away |
shellfish_2013
CC ID: 378562
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if respondent purchased shellfish license in 2013 |
| Allowed Values: | Shellfish License, No Shellfish License, NA |
post_card_mailed_date_dim$month_of_year
CC ID: 378563
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
c5_1b_quantity_nonharvest_trips_most_used_beach_closed_3_months
CC ID: 378564
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take that do not include harvesting clams or oysters in Puget Sound at most used beach during 3 month closure |
| Allowed Values: | 0-50 |
c3_type_of_closure
CC ID: 378565
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Type of closure for questions in section C3 |
| Allowed Values: | Biotoxin, Pollution |
second_survey_packet_mailed_date_whid
CC ID: 378566
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for second survey packet mailed date |
d8_3_unpaid_time_off_work
CC ID: 378567
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if respondent took unpaid time off to harvest shellfish |
| Allowed Values: | Unpaid Time Off, Not Unpaid Time Off |
sample_sex_dim$sex_abbreviation
CC ID: 378568
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Unit of Measure: | unspecified |
| Allowed Values: | Any |
c4_1a_quantity_harvest_trips_most_used_beach_closed_all_season
CC ID: 378569
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of trips might take to harvest clams or oysters in Puget Sound at most used beach that was closed all season |
| Allowed Values: | 0-75 |
q7_respondent_income_range
CC ID: 378570
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Im going to read you some income categories. For classification purposes only, please tell me which income category best describes your households total annual income before taxes in 2012. When I read your household income category, please stop me. |
| Allowed Values: | Less than $20,000, More than $20,000 but less than $40,000, More than $40,000 but less than $60,000, More than $60,000 but less than $80,000, More than $80,000 but less than $100,000, More than $100,000 but less than $125,000, More than $125,000 but less than $150,000, More than $150,000, Refused |
b6_beach_name_last_trip
CC ID: 378571
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 60 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name of most recent beach in Puget Sound to harvest clams (not razor clams) or oysters |
q4_miles_travel_to_harvest_beach
CC ID: 378572
| Data Storage Type: | int |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Approximately how many one-way miles do you travel to get to the beach you most often use to harvest oysters or clams in Puget Sound? |
| Allowed Values: | 1-350, Don't know/Not Sure, Less than one mile |
b12d2_number_people_last_trip_ferry
CC ID: 378573
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number people covered on last Puget Sound trip by self or household on ferry rounded to nearest dollar |
| Allowed Values: | 1-8 |
d9_survey_comments
CC ID: 378574
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 1000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Additional comments from respondent |
c5_species_closed_to_harvest
CC ID: 378575
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species that are closed to harvest for questions in section C5 |
| Allowed Values: | Clams/Oysters, Razor Clams |
b12b1_money_spent_last_trip_water_vehicle
CC ID: 378576
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Money spent on last Puget Sound trip by self or household on boat fuel rounded to nearest dollar |
| Allowed Values: | 0-100 |
q2_taken_trips_harvesting_oysters_clams
CC ID: 378577
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Have you taken any trips where you harvested oysters or clams in Puget Sound in the last 12 months? |
| Allowed Values: | DON'T KNOW / NOT SURE, No, REFUSED, Yes |
Catalog Details
| Catalog Item ID: | 36444 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:36444 |
| Metadata Record Created By: | Jeffrey W Cowen |
| Metadata Record Created: | 2017-01-25 13:22+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2017-02-13 |
| Owner Org: | NWFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2017-02-13 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2018-02-13 |