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:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)
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:
IsSystemMaintained : True
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)
- a_have_you_answered_this_survey (type: esriFieldTypeString, alias: A. Have you answered this survey with a person with this button?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [_YES: Thank & end: YES: Thank & end], [NO: Go to B: NO: Go to B])
- b_are_you_willing_to_participat (type: esriFieldTypeString, alias: B. Are you willing to participate in the survey? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [YES: Go to C: YES: Go to C], [NO: Thank & end: NO: Thank & end])
- c_where_did_you_stay_last_night (type: esriFieldTypeString, alias: C. Where did you stay last night [DO NOT READ CATEGORIES], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [a. DECLINE TO ANSWER_: a. DECLINE TO ANSWER ], [b. OWN APARTMENT / HOUSE: b. OWN APARTMENT / HOUSE], [c. SOMEONE ELSE’S PLACE: c. SOMEONE ELSE’S PLACE], ... 10 more ...)
- if_m_is_chosen_indicate_probabl (type: esriFieldTypeString, alias: If M. is chosen indicate probable location:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- c1_do_you_have_access_to_a_perm (type: esriFieldTypeString, alias: C1. Do you have access to a permanent residence where you can safely stay as long as you want? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [a. Yes [THANK & END]: a. Yes [THANK & END]], [b. No (not permanent AND/OR not: b. No (not permanent AND/OR not safe) [BEGIN SURVEY]], [c. Don’t Know [BEGIN SURVEY]: c. Don’t Know [BEGIN SURVEY]], ... 1 more ...)
- survey_number (type: esriFieldTypeDouble, alias: Survey Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- time (type: esriFieldTypeString, alias: Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- interviewer (type: esriFieldTypeString, alias: Interviewer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contact_number (type: esriFieldTypeDouble, alias: Contact Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- please_choose_where_participant (type: esriFieldTypeString, alias: PLEASE CHOOSE WHERE PARTICIPANT STAYED LAST NIGHT (night of March 11th) select ONE location only:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [a. DECLINE TO ANSWER_: a. DECLINE TO ANSWER ], [b. OWN APARTMENT / HOUSE: b. OWN APARTMENT / HOUSE], [c. SOMEONE ELSE’S PLACE: c. SOMEONE ELSE’S PLACE], ... 10 more ...)
- _1_did_you_have_any_family_memb (type: esriFieldTypeString, alias: 1. Did you have any family members or anyone else who stayed with you last night? (on the night of March 11th) [Indicate survey # for partners. Check all that apply], SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- field_22 (type: esriFieldTypeString, alias: If Child/(ren)/Dependent(s), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- if_partner_enter_survey_number (type: esriFieldTypeString, alias: If partner, Enter Survey Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _2_how_old_are_you (type: esriFieldTypeString, alias: 2. How old are you?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Don't Know: Don't Know], [Decline to Answer: Decline to Answer], [18 under: 18 under], ... 4 more ...)
- age_year_born (type: esriFieldTypeString, alias: Age/ year born, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _3_how_old_were_you_the_first_t (type: esriFieldTypeString, alias: 3. How old were you the first time you experienced homelessness?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Age/ year: Age/ year], [Don't Know: Don't Know], [Decline to Answer: Decline to Answer])
- age_year (type: esriFieldTypeString, alias: Age/ year, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _4_in_total_for_how_much_time_h (type: esriFieldTypeString, alias: 4. In total, for how much time have you experienced homelessness over the PAST YEAR (the last 12 months)? [Does not need to be exact. Best estimate.], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Length_ Days| Weeks | Months: Length____ Days| Weeks | Months], [Don't Know: Don't Know], [Decline to Answer: Decline to Answer])
- length_days_weeks_months (type: esriFieldTypeString, alias: Length____ Days| Weeks | Months, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _5_have_you_stayed_in_a_homeles (type: esriFieldTypeString, alias: 5. Have you stayed in a homeless shelter in the past year? For example, (Prompt: give examples like Our Place, Rock Bay landing, Salvation Army). , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Don't Know: Don't Know], ... 1 more ...)
- _5b_is_there_a_reason_you_would (type: esriFieldTypeString, alias: 5b. Is there a reason you would not stay in a homeless shelter in the Greater Victoria area?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Don't Know: Don't Know], ... 1 more ...)
- if_yes_what_are_the_main_reason (type: esriFieldTypeString, alias: (IF YES) What are the main reasons?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- if_yes_what_are_the_main_reason_other (type: esriFieldTypeString, alias: Other - (IF YES) What are the main reasons?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- if_others_state_reason (type: esriFieldTypeString, alias: If Others: State reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _6_did_you_come_to_canada_as_an (type: esriFieldTypeString, alias: 6. Did you come to Canada as an immigrant, refugee or a refugee claimant (i.e. applied for refugee status after coming to Canada)? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes, Immgrant: Yes, Immgrant], [Yes, Refugee: Yes, Refugee], [Yes, Refugee Claim in Canada: Yes, Refugee Claim in Canada], ... 3 more ...)
- if_yes_how_long_have_you_been_i (type: esriFieldTypeString, alias: If YES: How long have you been in Canada?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [LENGTH: _ DAYS | WEEKS | MONTHS: LENGTH: ___________ DAYS | WEEKS | MONTHS | YEARS OR DATE: ______/_______/______ DAY / MONTH / YEAR], [Don't Know: Don't Know], [Decline to Answer: Decline to Answer])
- _length (type: esriFieldTypeString, alias: Length, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _7_how_long_have_you_been_in_gr (type: esriFieldTypeString, alias: 7. How long have you been in Greater Victoria?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [LENGTH: _ DAYS | WEEKS | MONTHS: LENGTH: ___________ DAYS | WEEKS | MONTHS | YEARS OR DATE: ______/_______/______ DAY / MONTH / YEAR], [Always been here: Always been here], [Don't Know: Don't Know], ... 1 more ...)
- length_ (type: esriFieldTypeString, alias: Length , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- where_did_you_live_before_you_c (type: esriFieldTypeString, alias: Where did you live before you came here?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CITY: _ | PROVINCE/TERRITORY/CO: CITY: ___________ | PROVINCE/TERRITORY/COUNTRY____________ ], [Decline to Answer: Decline to Answer])
- location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _7b_what_is_the_main_reason_you (type: esriFieldTypeString, alias: 7b. What is the main reason you came to Greater Victoria [Do not read categories; select one), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- _7b_what_is_the_main_reason_you_other (type: esriFieldTypeString, alias: Other - 7b. What is the main reason you came to Greater Victoria [Do not read categories; select one), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- if_other (type: esriFieldTypeString, alias: If other:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _8_do_you_identify_as_first_nat (type: esriFieldTypeString, alias: 8. Do you identify as First Nations (with or without status), Métis, or Inuit, or do you have North American Indigenous ancestry? [If yes, please specify], SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- _8b_what_indigenous_community_a (type: esriFieldTypeString, alias: 8b. What Indigenous community are you from?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [COMMUNITY/RESERVE NAME _: COMMUNITY/RESERVE NAME ________________________], [DON’T KNOW_: DON’T KNOW ], [DECLINE TO ANSWER: DECLINE TO ANSWER])
- communityreserve_name (type: esriFieldTypeString, alias: COMMUNITY/RESERVE NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _8c_are_you_currently_on_a_hous (type: esriFieldTypeString, alias: 8c. Are you currently on a housing waitlist in your on-reserve home community?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [NO, Don't Qualify: NO, Don't Qualify], ... 2 more ...)
- _8d_are_you_currently_on_a_hous (type: esriFieldTypeString, alias: 8d. Are you currently on a housing waitlist for urban Indigenous housing? [Example: M’akola Housing, Siem Lelum), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [NO, Don't Qualify: NO, Don't Qualify], ... 2 more ...)
- _8e_did_you_a_parent_or_grandpa (type: esriFieldTypeString, alias: 8e. Did you, a parent, or grandparent ever attend residential school? [If yes, please follow up to specify and check all that apply] , SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- _9_have_you_ever_served_in_the_ (type: esriFieldTypeString, alias: 9. Have you ever served in the Canadian Military or RCMP? , SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- _10_as_a_child_or_youth_were_yo (type: esriFieldTypeString, alias: 10. As a child or youth, were you ever in foster care or in a youth group home (Foster care, youth group home, youth agreement, etc.)? [Note: This question applies specifically to child welfare programs.], SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- _10b_approximately_how_long_aft (type: esriFieldTypeString, alias: 10b. Approximately how long after leaving foster care/group home did you become homeless?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [LENGTH _ DAYS / WEEKS / MONTHS: LENGTH _____ DAYS / WEEKS / MONTHS / YEARS ], [DON'T KNOW: DON'T KNOW], [DECLINE TO ANSWER: DECLINE TO ANSWER])
- length_days_weeks_months_years (type: esriFieldTypeString, alias: LENGTH _____ DAYS / WEEKS / MONTHS / YEARS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _10c_do_you_feel_that_child_pro (type: esriFieldTypeString, alias: 10c. Do you feel that Child Protection Services was helpful in transitioning you to independence after leaving foster care/group home?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [DON'T KNOW: DON'T KNOW], ... 1 more ...)
- illness (type: esriFieldTypeString, alias: ILLNESS OR MEDICAL CONDITION [e.g. diabetes, arthritis, TB, HIV], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [DON'T KNOW: DON'T KNOW], ... 1 more ...)
- physical_disability (type: esriFieldTypeString, alias: PHYSICAL DISABILITY [e.g. an issue with mobility, dexterity, or capacity], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [DON'T KNOW: DON'T KNOW], ... 1 more ...)
- learing_disability (type: esriFieldTypeString, alias: LEARNING DISABILITY OR COGNITIVE LIMITATIONS [e.g. ADHD, dyslexia, autism spectrum disorder, brain injury], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [DON'T KNOW: DON'T KNOW], ... 1 more ...)
- mental_issue (type: esriFieldTypeString, alias: MENTAL HEALTH ISSUE [e.g. depression, PTSD, bipolar disorder], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [DON'T KNOW: DON'T KNOW], ... 1 more ...)
- substance_issue (type: esriFieldTypeString, alias: SUBSTANCE USE ISSUE [e.g. alcohol, opiates, etc.], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [DON'T KNOW: DON'T KNOW], ... 1 more ...)
- _12_what_gender_do_you_identify (type: esriFieldTypeString, alias: 12. What gender do you identify with? [Show list or read list.], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [MAN: MAN], [WOMAN: WOMAN], [TWO-SPIRIT: TWO-SPIRIT], ... 6 more ...)
- not_listed (type: esriFieldTypeString, alias: NOT LISTED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _13_how_do_you_describe_your_se (type: esriFieldTypeString, alias: 13. How do you describe your sexual orientation, for example straight, gay, lesbian? [Show list or read list.], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [STRAIGHT/HETEROSEXUAL: STRAIGHT/HETEROSEXUAL], [GAY: GAY], [LESBIAN: LESBIAN], ... 10 more ...)
- field_73 (type: esriFieldTypeString, alias: NOT LISTED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _14a_what_happened_that_caused_ (type: esriFieldTypeString, alias: 14a. What happened that caused you to lose your housing most recently? [Do not read the options. Check all that apply. “Housing” does not include temporary arrangements (e.g., couch surfing) or shelter stays. Follow up for the reason if the respondent says “eviction” or that they “chose to leave”.], SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- _14a_what_happened_that_caused__other (type: esriFieldTypeString, alias: Other - 14a. What happened that caused you to lose your housing most recently? [Do not read the options. Check all that apply. “Housing” does not include temporary arrangements (e.g., couch surfing) or shelter stays. Follow up for the reason if the respondent says “eviction” or that they “chose to leave”.], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- if_answered_j_l_or_other (type: esriFieldTypeString, alias: IF ANSWERED J, L OR OTHER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _14b_how_long_ago_did_that_happ (type: esriFieldTypeString, alias: 14b. How long ago did that happen (that you lost your housing most recently)? (Best estimate), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [LENGTH _ DAYS | WEEKS | MONTHS: LENGTH ______________ DAYS | WEEKS | MONTHS | YEARS], [DON’T KNOW: DON’T KNOW], [DECLINE TO ANSWER: DECLINE TO ANSWER])
- field_77 (type: esriFieldTypeString, alias: LENGTH ______________ DAYS | WEEKS | MONTHS | YEARS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _15_what_are_your_sources_of_in (type: esriFieldTypeString, alias: 15. What are your sources of income? [Reminder that this survey is anonymous. Read list and check all that apply], SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- field_79 (type: esriFieldTypeString, alias: IF OTHER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _16_do_you_want_to_get_into_per (type: esriFieldTypeString, alias: 16. Do you want to get into permanent housing?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [DON'T KNOW: DON'T KNOW], ... 1 more ...)
- _17_what_challenges_or_problems (type: esriFieldTypeString, alias: 17. What challenges or problems have you experienced when trying to find housing? [Select all that apply], SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- field_82 (type: esriFieldTypeString, alias: IF OTHER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- _18_i_m_going_to_read_a_list_of (type: esriFieldTypeString, alias: 18. I’m going to read a list of services that you may or may not need. Let me know which of these apply to you. Do you have a need for services related to: [Read list and check all that apply], SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- _18_i_m_going_to_read_a_list_of_other (type: esriFieldTypeString, alias: Other - 18. I’m going to read a list of services that you may or may not need. Let me know which of these apply to you. Do you have a need for services related to: [Read list and check all that apply], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- if_other_ (type: esriFieldTypeString, alias: IF OTHER , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- notes (type: esriFieldTypeString, alias: NOTES:, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 1/1/2023 11:17:15 PM
Schema Last Edit Date: 12/30/2022 8:15:26 PM
Data Last Edit Date: 1/1/2023 11:17:15 PM
Supported Operations:
Add Features
Apply Edits
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat