Layer: survey (ID:0)

View In: Map Viewer

Name: survey

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"label":"Survey Point","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
will_this_work (type: esriFieldTypeString, alias: Will this work?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: yes], [no: no], [maybe: maybe])
_1_how_long_has_your_farm_to_sc (type: esriFieldTypeString, alias: 1. How long has your Farm to School (F2S) program been active in your county?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Less than 1 year: Less than 1 year], [1-3 years: 1-3 years], [4-7 years: 4-7 years], ... 2 more ...)
_2_what_are_the_main_components (type: esriFieldTypeString, alias: 2. What are the main components of your F2S program? (Select all that apply), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_2_what_are_the_main_comp_other (type: esriFieldTypeString, alias: Other (please specify) - 2. What are the main components of your F2S program? (Select all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
_3_what_are_the_primary_goals_o (type: esriFieldTypeString, alias: 3. What are the primary goals of your Farm to School program? (Drag the following options and rank), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true, Coded Values: [Supporting_local_farmers: Supporting local farmers], [Providing_students_with_fresh_h: Providing students with fresh, healthy food], [Enhancing_nutrition_education: Enhancing nutrition education], ... 2 more ...)
if_you_would_like_to_add_a_resp (type: esriFieldTypeString, alias: If you would like to add a response for "other" for the question above, please specify here., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_4_does_your_district_have_a_de (type: esriFieldTypeString, alias: 4. Does your district have a designated person that leads integrated food, farm and nutrition programs (e.g. farm to school)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes a specific champion or cham: Yes a specific champion or champions (e.g. teacher, food services coordinator etc.)], [Yes a farm2school coordinator (: Yes a farm2school coordinator (e.g. paid staff or VISTA)], [Yes other partnership _ name/ti: Yes other partnership ________ name/title], ... 1 more ...)
_5_can_you_briefly_describe_how (type: esriFieldTypeString, alias: 5. Can you briefly describe how your Farm to School program works in your county?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_6_what_are_the_greatest_barrie (type: esriFieldTypeString, alias: 6. What are the greatest barriers preventing the F2S program from being more effective in your county? (Drag the following options and rank), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true, Coded Values: [Funding: Funding], [Logistics_(e.g._delivery_storag: Logistics (e.g., delivery, storage, transportation)], [Production_(e.g._availability_s: Production (e.g., availability, seasonality)], ... 5 more ...)
field_67 (type: esriFieldTypeString, alias: If you would like to add a response for "other" for the question above, please specify here., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_7_can_you_describe_any_specifi (type: esriFieldTypeString, alias: 7. Can you describe any specific challenges you've faced while running the F2S program?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_8_for_the_upcoming_school_year (type: esriFieldTypeString, alias: 8. For the upcoming school year, do you anticipate your purchases of local food will:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Increase: Increase], [Decrease: Decrease], [Stay the same: Stay the same], ... 2 more ...)
_8_for_the_upcoming_schoo_other (type: esriFieldTypeString, alias: Other (please specify) - 8. For the upcoming school year, do you anticipate your purchases of local food will:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
_9_over_the_past_year_did_a_sch (type: esriFieldTypeString, alias: 9. Over the past year, did a school in your district obtain local food from any of the following sources? (Select all that apply), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_10_how_do_you_typically_identi (type: esriFieldTypeString, alias: 10. How do you typically identify the needs for local food and place orders? (Select all that apply), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_10_how_do_you_typically__other (type: esriFieldTypeString, alias: Other (please specify) - 10. How do you typically identify the needs for local food and place orders? (Select all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
_11_how_do_you_ensure_transpare (type: esriFieldTypeString, alias: 11. How do you ensure transparency and compliance with procurement regulations? (Select all that apply), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_12_what_specific_changes_or_im (type: esriFieldTypeString, alias: 12. What specific changes or improvements would make your ordering process more efficient?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_13_does_your_workload_or_exist (type: esriFieldTypeString, alias: 13. Does your workload or existing staffing capacity allow you to work with farmers or aggregators to develop production plans?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unsure: Unsure])
_14_how_many_months_in_advance (type: esriFieldTypeString, alias: 14. How many months in advance could you predict your orders from local WV producers? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [12 months: 12 months], [9 months: 9 months], [6 months: 6 months], ... 4 more ...)
_15_could_you_describe_your_cur (type: esriFieldTypeString, alias: 15. Describe your current ordering timeline (all foods). How many months or weeks in advance do you plan your food orders? , SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_16_what_could_the_state_county (type: esriFieldTypeString, alias: 16. What could the state, county commission, or school board do to better support your Farm to School ordering process at the local level?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_17_how_often_do_you_place_orde (type: esriFieldTypeString, alias: 17. How often do you place orders for local foods?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Daily: Daily], [Weekly: Weekly], [Monthly: Monthly], ... 2 more ...)
_18_how_far_in_advance_do_you_p (type: esriFieldTypeString, alias: 18. How far in advance do you place orders to ensure local food is available?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Same day: Same day], [1-3 days in advance: 1-3 days in advance], [1 week in advance: 1 week in advance], ... 3 more ...)
_18_how_far_in_advance_do_other (type: esriFieldTypeString, alias: Other (please specify) - 18. How far in advance do you place orders to ensure local food is available?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
_19_how_are_local_food_deliveri (type: esriFieldTypeString, alias: 19. How are local food deliveries currently handled? (Select all that apply), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_19_how_are_local_food_de_other (type: esriFieldTypeString, alias: Other (please specify) - 19. How are local food deliveries currently handled? (Select all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
_20_what_logistical_challenges (type: esriFieldTypeString, alias: 20. What logistical challenges do you face in the delivery or receipt of local food products? (Drag the following options and rank), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true, Coded Values: [Inconsistent_delivery_schedules: Inconsistent delivery schedules], [Lack_of_refrigerated_transport_: Lack of refrigerated transport or storage], [Long_distances_between_supplier: Long distances between suppliers and schools], ... 3 more ...)
field_68 (type: esriFieldTypeString, alias: If you would like to add a response for "other" for the question above, please specify here., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_21_would_a_centralized_deliver (type: esriFieldTypeString, alias: 21. Would a centralized delivery system for local food procurement improve your ability to source local foods?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes, significantly: Yes, significantly], [Yes, somewhat: Yes, somewhat], [No, we already have a system in: No, we already have a system in place], ... 1 more ...)
_22_do_you_currently_track_your (type: esriFieldTypeString, alias: 22. Do you currently track your local food purchases?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes, manually (e.g., spreadshee: Yes, manually (e.g., spreadsheets, paper)], [Yes, via software: Yes, via software], [No, we do not track purchases: No, we do not track purchases], ... 1 more ...)
_22_do_you_currently_trac_other (type: esriFieldTypeString, alias: Other (please specify) - 22. Do you currently track your local food purchases?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
if_yes_what_tools_or_software_d (type: esriFieldTypeString, alias: If yes, What tools or software do you use to track F2S purchases?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
if_yes_how_effective_is_your_cu (type: esriFieldTypeString, alias: If yes, how effective is your current tracking system in providing accurate and timely data?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Very effective: Very effective], [Somewhat effective: Somewhat effective], [Not effective: Not effective], ... 1 more ...)
if_not_or_if_you_are_unhappy_wi (type: esriFieldTypeString, alias: 23. Would you be interested in using a free online system that helps track and report F2S purchases?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Maybe: Maybe])
_23_what_features_would_help_im (type: esriFieldTypeString, alias: 24. What would help improve your ability to track local food purchases? (Drag the following options and rank), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true, Coded Values: [Automated_tracking_systems_inte: Automated tracking systems integrated with existing procurement tools], [An_online_platform_for_managing: An online platform for managing and tracking purchases], [More_staff_support_to_handle_pu: More staff support to handle purchase tracking], ... 3 more ...)
field_69 (type: esriFieldTypeString, alias: If you would like to add a response for "other" for the question above, please specify here., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_24_how_do_you_interact_with_ki (type: esriFieldTypeString, alias: 25. How do you interact with kitchen staff and management regarding local food procurement?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Centralized process involving c: Centralized process involving county-wide coordination], [Each school handles procurement: Each school handles procurement individually], [A mix of both centralized and s: A mix of both centralized and school-specific processes])
_25_how_many_elementary_schools (type: esriFieldTypeDouble, alias: 26. How many elementary schools in your district are participating in local WV food purchasing at least once a month? , SQL Type: sqlTypeOther, nullable: true, editable: true)
_26_how_many_elementary_schools (type: esriFieldTypeDouble, alias: 27. How many elementary schools in your district are participating in local WV food purchasing in the last year? (Including schools counted in previous question), SQL Type: sqlTypeOther, nullable: true, editable: true)
_27_how_many_middle_schools_in (type: esriFieldTypeDouble, alias: 28. How many middle schools in your district are participating in local WV food purchasing at least once a month?, SQL Type: sqlTypeOther, nullable: true, editable: true)
_28_how_many_middle_schools_in (type: esriFieldTypeDouble, alias: 29. How many middle schools in your district are participating in local WV food purchasing in the last year? (Including schools counted in previous question), SQL Type: sqlTypeOther, nullable: true, editable: true)
_29_how_many_high_schools_in_yo (type: esriFieldTypeDouble, alias: 30. How many high schools in your district are currently participating in local WV food purchasing at least once a month?, SQL Type: sqlTypeOther, nullable: true, editable: true)
_30_how_many_high_schools_in_yo (type: esriFieldTypeDouble, alias: 31. How many high schools in your district are currently participating in local WV food purchasing in the last year? (Including schools counted in previous question), SQL Type: sqlTypeOther, nullable: true, editable: true)
_31_school_kitchens_in_my_distr (type: esriFieldTypeString, alias: 32. School kitchens in my district are adequate for use in accommodating local food purchases and/or processing?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Strongly disagree: Strongly disagree], [Disagree: Disagree], [I'm not sure: I'm not sure], ... 2 more ...)
_32_are_there_any_best_practice (type: esriFieldTypeString, alias: 33. Are there any best practices or success stories from specific schools that could be shared with other districts?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_33_what_strategies_do_you_use (type: esriFieldTypeString, alias: 34. What strategies do you use to overcome procurement barriers in your F2S program? (Select all that apply), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_33_what_strategies_do_yo_other (type: esriFieldTypeString, alias: Other (please specify) - 34. What strategies do you use to overcome procurement barriers in your F2S program? (Select all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
_34_can_you_share_any_specific (type: esriFieldTypeString, alias: 35. Can you share any specific success stories or best practices that have worked well for incorporating local foods into your schools?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_35_what_types_of_local_wv_prod (type: esriFieldTypeString, alias: 36. What types of local WV products would you like to purchase more of in the future? (Drag the following options and rank), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true, Coded Values: [Fresh_vegetables_and_fruits: Fresh vegetables and fruits], [Dairy_products: Dairy products], [Meat_and_poultry: Meat and poultry], ... 3 more ...)
_36_would_you_be_interested_in (type: esriFieldTypeString, alias: 37. Would you be interested in engaging in a planning process to develop an online tool to streamline local food procurement (e.g., ordering, communication with vendors, tracking) be helpful for your program?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes, very much so: Yes, very much so], [Yes, perhaps: Yes, perhaps], [No, I do not have the capacity: No, I do not have the capacity], ... 1 more ...)
_37_what_features_would_you_fin (type: esriFieldTypeString, alias: 38. What features would you find most useful in an online tool for local food procurement? (Drag the following options and rank) , SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true, Coded Values: [A_directory_of_local_producers_: A directory of local producers and available products], [Status_of_available_or_soon_to_: Status of available or soon to be available products from local producers], [Online_ordering_and_payment_sys: Online ordering and payment systems], ... 4 more ...)
field_70 (type: esriFieldTypeString, alias: If you would like to add a response for "other" for the question above, please specify here., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_38_what_are_the_main_barriers (type: esriFieldTypeString, alias: 39. What are the main barriers to using an online tool for local food procurement? (Select all that apply), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_38_what_are_the_main_bar_other (type: esriFieldTypeString, alias: Other (please specify) - 39. What are the main barriers to using an online tool for local food procurement? (Select all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
_39_what_additional_support_wou (type: esriFieldTypeString, alias: 40. What additional support would be needed to successfully implement an online tool for your Farm to School program? (Select all that apply), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_39_what_additional_suppo_other (type: esriFieldTypeString, alias: Other (please specify) - 40. What additional support would be needed to successfully implement an online tool for your Farm to School program? (Select all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
_40_what_forms_of_support_would (type: esriFieldTypeString, alias: 41. What forms of support would help your Farm to School procurement program succeed? (Drag the following options and rank), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true, Coded Values: [Increased_federal_state_or_coun: Increased federal, state or county funding for local food procurement], [Simplified_regulatory_and_compl: Simplified regulatory and compliance processes], [Training_for_nutrition_director: Training for nutrition directors, kitchen staff, and procurement officers], ... 3 more ...)
field_71 (type: esriFieldTypeString, alias: If you would like to add a response for "other" for the question above, please specify here., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_41_are_you_interested_in_parti (type: esriFieldTypeString, alias: 42. Are you interested in participating in a process of increasing communication and training between farmers and nutrition assistance directors, through workshops, conferences or other working group meetings in the coming years? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
_42_which_of_the_following_woul (type: esriFieldTypeString, alias: 43. Which of the following would MOTIVATE you to start, continue, or increase serving locally grown food at your school? (Select all that apply), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
_42_which_of_the_followin_other (type: esriFieldTypeString, alias: Other (please specify) - 43. Which of the following would MOTIVATE you to start, continue, or increase serving locally grown food at your school? (Select all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
_4_does_your_district_hav_other (type: esriFieldTypeString, alias: Yes, Other Partnership - 4. Does your district have a designated person that leads integrated food, farm and nutrition programs (e.g. farm to school)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
if_you_selected_other_partnersh (type: esriFieldTypeString, alias: If you selected "other partnership", please name that partnership below, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
select_your_county (type: esriFieldTypeString, alias: Select Your County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/14/2025 2:14:23 PM

Schema Last Edit Date: 2/7/2025 2:53:39 PM

Data Last Edit Date: 2/14/2025 2:14:23 PM

Supported Operations: Add Features Apply Edits Generate Renderer Validate SQL Get Estimates ConvertFormat