Name: Utah_Lake_Survey_Results

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Respondent (type: esriFieldTypeInteger, alias: Respondent, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Language (type: esriFieldTypeString, alias: Language, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Date_responded (type: esriFieldTypeDate, alias: Date responded, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Distribution_method (type: esriFieldTypeString, alias: Distribution method, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Reached_end (type: esriFieldTypeInteger, alias: Reached end, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Completion_time__seconds_ (type: esriFieldTypeInteger, alias: Completion time (seconds), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Browser (type: esriFieldTypeString, alias: Browser, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Operating_system (type: esriFieldTypeString, alias: Operating system, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• IP (type: esriFieldTypeString, alias: IP, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Location__via_IP_ (type: esriFieldTypeString, alias: Location (via IP), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Referring_sites (type: esriFieldTypeString, alias: Referring sites, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Score (type: esriFieldTypeInteger, alias: Score, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Score__ (type: esriFieldTypeInteger, alias: Score %, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• tid (type: esriFieldTypeInteger, alias: tid, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• att_8 (type: esriFieldTypeString, alias: att_8, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F1__How_familiar_are_you_with_U (type: esriFieldTypeString, alias: 1. How familiar are you with Utah Lake?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F2__How_often_do_you_visit_Utah (type: esriFieldTypeString, alias: 2. How often do you visit Utah Lake?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F3_1__Utah_Lake_is_important_to (type: esriFieldTypeString, alias: 3.1. Utah Lake is important to me., SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true, Coded Values: [1: Strongly Disagree], [2: Disagree], [3: Neutral], ... 3 more ...)
• F3_2__I_appreciate_Utah_Lake_as (type: esriFieldTypeString, alias: 3.2. I appreciate Utah Lake as a visual resource., SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F3_3__I_spend_time_recreating_o (type: esriFieldTypeString, alias: 3.3. I spend time recreating on or around Utah Lake., SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F3_4__Utah_Lake_improves_the_qu (type: esriFieldTypeString, alias: 3.4. Utah Lake improves the quality of life for local communities., SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F3_5__It_is_important_for_the_e (type: esriFieldTypeString, alias: 3.5. It is important for the environment (wildlife and water resources)., SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F4_1__Thriving_ecosystems (type: esriFieldTypeString, alias: 4.1. Thriving ecosystems, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F4_2__World_class_recreational_ (type: esriFieldTypeString, alias: 4.2. World class recreational opportunities, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F4_3__Vibrant_communities (type: esriFieldTypeString, alias: 4.3. Vibrant communities, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F5__Are_there_any_themes_for_go (type: esriFieldTypeString, alias: 5. Are there any themes for goals and objectives missing from the current framework, focusing on thriving ecosystems, world class recreational opportunities, and vibrant communities?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_1__Negative_public_perceptio (type: esriFieldTypeString, alias: 6.1. Negative public perception, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_2__Lack_of_engagement_with_a (type: esriFieldTypeString, alias: 6.2. Lack of engagement with adjacent communities, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_3__Lack_of_funding (type: esriFieldTypeString, alias: 6.3. Lack of funding, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_4__Frequent_harmful_algal_bl (type: esriFieldTypeString, alias: 6.4. Frequent harmful algal blooms (HABs), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_5__Lack_of_developed_access_ (type: esriFieldTypeString, alias: 6.5. Lack of developed access points, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_6__Nutrients_and_other_pollu (type: esriFieldTypeString, alias: 6.6. Nutrients and other pollutant inputs from wastewater and stormwater, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_7__Fluctuations_in_lake_leve (type: esriFieldTypeString, alias: 6.7. Fluctuations in lake level, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_8__Dangerous_lake_conditions (type: esriFieldTypeString, alias: 6.8. Dangerous lake conditions (e.g., large waves) because the lake is large and shallow, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_9__The_lake_s_food_web_has_b (type: esriFieldTypeString, alias: 6.9. The lake’s food web has been severely modified and is largely comprised of non-native species, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_10__Development_pressure (type: esriFieldTypeString, alias: 6.10. Development pressure, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_11__Lack_of_coordination_amo (type: esriFieldTypeString, alias: 6.11. Lack of coordination among entities, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_12__Constrained_by_water_rig (type: esriFieldTypeString, alias: 6.12. Constrained by water rights, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_13__Other (type: esriFieldTypeString, alias: 6.13. Other, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F6_13__Other__please_specify (type: esriFieldTypeString, alias: 6.13. Other, please specify, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F7_1__Elevated_nutrient_concent (type: esriFieldTypeString, alias: 7.1. Elevated nutrient concentrations, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F7_2__Invasive_fish__e_g___carp (type: esriFieldTypeString, alias: 7.2. Invasive fish (e.g., carp), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F7_3__Invasive_vegetation__e_g_ (type: esriFieldTypeString, alias: 7.3. Invasive vegetation (e.g., Phragmites), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F7_4__Turbid_water__low_water_c (type: esriFieldTypeString, alias: 7.4. Turbid water (low water clarity), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F7_5__Other (type: esriFieldTypeString, alias: 7.5. Other, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F7_5__Other__please_specify (type: esriFieldTypeString, alias: 7.5. Other, please specify, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F8_1__Improved_water_quality_co (type: esriFieldTypeString, alias: 8.1. Improved water quality conditions, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F8_2__An_increase_in_recreation (type: esriFieldTypeString, alias: 8.2. An increase in recreational access points, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F8_3__An_increase_in_recreation (type: esriFieldTypeString, alias: 8.3. An increase in recreational equipment rentals and concessions at access points, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F8_4__Increased_and_improved_tr (type: esriFieldTypeString, alias: 8.4. Increased and improved transportation connections between adjacent communities/‌municipalities and lake access points, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F8_5__Other (type: esriFieldTypeString, alias: 8.5. Other, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F8_5__Other__please_specify (type: esriFieldTypeString, alias: 8.5. Other, please specify, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F9_1__Limited_transportation_an (type: esriFieldTypeString, alias: 9.1. Limited transportation and transit options connecting municipalities to the lake, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F9_2__Lack_of_awareness_of_the_ (type: esriFieldTypeString, alias: 9.2. Lack of awareness of the current recreational, cultural, and community activities and environmental values of Utah Lake, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F9_3__Lack_of_public_lakefront_ (type: esriFieldTypeString, alias: 9.3. Lack of public lakefront amenities: facilities (e.g., access points, boat ramps, bathrooms), attractions (e.g., beaches, trails, businesses), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F9_4__Other (type: esriFieldTypeString, alias: 9.4. Other, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F9_4__Other__please_specify (type: esriFieldTypeString, alias: 9.4. Other, please specify, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F10_1__Reducing_nutrient_loadin (type: esriFieldTypeString, alias: 10.1. Reducing nutrient loading, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F10_2__Reducing_harmful_algal_b (type: esriFieldTypeString, alias: 10.2. Reducing harmful algal blooms, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F10_3__Increasing_recreational_ (type: esriFieldTypeString, alias: 10.3. Increasing recreational visitation, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F10_4__Improving_water_clarity (type: esriFieldTypeString, alias: 10.4. Improving water clarity, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F10_5__Restoring_the_ecosystem (type: esriFieldTypeString, alias: 10.5. Restoring the ecosystem, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F10_6__Improving_public_percept (type: esriFieldTypeString, alias: 10.6. Improving public perception of Utah Lake, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F10_7__Increasing_recreational_ (type: esriFieldTypeString, alias: 10.7. Increasing recreational amenities and facilities, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F10_8__Increasing_and_improving (type: esriFieldTypeString, alias: 10.8. Increasing and improving transportation connections to Utah Lake, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F10_9__Increasing_the_number_an (type: esriFieldTypeString, alias: 10.9. Increasing the number and types of community events centered around Utah Lake, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F10_10__Other (type: esriFieldTypeString, alias: 10.10. Other, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F10_11__Unsure (type: esriFieldTypeString, alias: 10.11. Unsure, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F11__Is_there_anything_else_tha (type: esriFieldTypeString, alias: 11. Is there anything else that could be done to improve your perception of Utah Lake?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F12__What_else_could_be_done_to (type: esriFieldTypeString, alias: 12. What else could be done to improve your perception of Utah Lake?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F13__What_county_is_your_primar (type: esriFieldTypeString, alias: 13. What county is your primary residence within Utah?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F14__Which_of_the_following_bes (type: esriFieldTypeString, alias: 14. Which of the following best describes your age?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F15__What_is_the_highest_degree (type: esriFieldTypeString, alias: 15. What is the highest degree or level of school you have completed?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F16__What_is_your_annual_househ (type: esriFieldTypeString, alias: 16. What is your annual household income?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F17__How_many_children_are_you_ (type: esriFieldTypeString, alias: 17. How many children are you parent or guardian for that live in your household (aged 17 or younger only)?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F18__What_is_your_current_emplo (type: esriFieldTypeString, alias: 18. What is your current employment status?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F18__What_is_your_current_emp_1 (type: esriFieldTypeString, alias: 18. What is your current employment status? - other, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/7/2023 2:11:04 PM

Schema Last Edit Date: 7/7/2023 2:11:04 PM

Data Last Edit Date: 7/6/2023 1:42:01 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat