Name: Detroit_Unsheltered_Census_Next_Day_Interview_Jan_2025
Display Field: objectid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: true
Views
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":{"description":"Survey Data Locations","label":"Detroit Unsheltered Census Next-Day Interview Jan 2025","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: false
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: sqlTypeGUID, length: 38, nullable: false, editable: false)
- interviewer (type: esriFieldTypeString, alias: Interviewer:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Wednesday_night (type: esriFieldTypeString, alias: 1. Did anyone else already ask you about where you stayed on Wednesday night?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- Wednesday_sleep (type: esriFieldTypeString, alias: 2. Where did you sleep Wednesday night?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [unsheltered: Unsheltered], [sheltered: Sheltered])
- Unsheltered_locations (type: esriFieldTypeString, alias: Unsheltered Locations:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [street_sidewalk: Street/Sidewalk], [park_park: Park], [abandoned_building: Abandoned Building], ... 6 more ...)
- other_location_specify (type: esriFieldTypeString, alias: If selected other location, please specify?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Sheltered_locations (type: esriFieldTypeString, alias: Sheltered Locations:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [emergency_shelter: Emergency Shelter], [transitional_housing: Transitional Housing], [hotel_motel: Hotel/motel], ... 4 more ...)
- other_location_specify1 (type: esriFieldTypeString, alias: If selected other location, please specify?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- household (type: esriFieldTypeString, alias: 3. Including yourself or how many adults and children are there in the household, who were sleeping in the same location with you Wednesday night?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [none: None], [adults_children: Yes, Adults (Age 18 and older) and/or Children (Age 17 and younger)])
- adults_num (type: esriFieldTypeInteger, alias: How many adults (Age 18 and older)?, SQL Type: sqlTypeOther, nullable: true, editable: true)
- children_num (type: esriFieldTypeInteger, alias: How many children (Age 17 and younger)?, SQL Type: sqlTypeOther, nullable: true, editable: true)
- person1_first_main (type: esriFieldTypeString, alias: Person 1 First Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- person1_last_main (type: esriFieldTypeString, alias: Person 1 Last Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- person1_nickname_main (type: esriFieldTypeString, alias: Person 1 Nickname/Initials:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- person1_donotKnow_refused (type: esriFieldTypeString, alias: Person 1 response:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [donotKnow: Don't Know], [refused: Refused])
- person2_first_main (type: esriFieldTypeString, alias: Person 2 First Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- person2_last_main (type: esriFieldTypeString, alias: Person 2 Last Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- person2_nickname_main (type: esriFieldTypeString, alias: Person 2 Nickname/Initials:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- person2_donotKnow_refused (type: esriFieldTypeString, alias: Person 2 response:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [donotKnow: Don't Know], [refused: Refused])
- person3_first_main (type: esriFieldTypeString, alias: Person 3 First Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- person3_last_main (type: esriFieldTypeString, alias: Person 3 Last Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- person3_nickname_main (type: esriFieldTypeString, alias: Person 3 Nickname/Initials:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- person3_donotKnow_refused (type: esriFieldTypeString, alias: Person 3 response:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [donotKnow: Don't Know], [refused: Refused])
- person2_relationship (type: esriFieldTypeString, alias: Person 2 is:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [child: Child], [spouse_partner: Spouse/Partner], [other_relative: Other Relative], ... 1 more ...)
- person2_unrelated (type: esriFieldTypeString, alias: If selected unrelated, please specify?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- person3_relationship (type: esriFieldTypeString, alias: Person 3 is:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [child: Child], [spouse_partner: Spouse/Partner], [other_relative: Other Relative], ... 1 more ...)
- person3_unrelated (type: esriFieldTypeString, alias: If selected unrelated, please specify?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- gender (type: esriFieldTypeString, alias: 6. How would you (main respondent) and (person 2 – 3) describe your gender identity (select all that apply)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- person2_gender (type: esriFieldTypeString, alias: Person 2 gender:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- person3_gender (type: esriFieldTypeString, alias: Person 3 gender:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- date_birth (type: esriFieldTypeDate, alias: 7. What is your date of birth (main Respondent)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- year_birth (type: esriFieldTypeString, alias: If unable to get day and month, what is the year?, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- guess_birth_year (type: esriFieldTypeString, alias: If unable to get any information, select one of following:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [under_18: Under 18], [18_24: 18-24], [25_34: 25 -34], ... 7 more ...)
- date_birth_person2 (type: esriFieldTypeDate, alias: What is person 2 date of birth?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- year_birth_person2 (type: esriFieldTypeString, alias: If unable to get day and month, what is the year?, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- guess_birth_year_person2 (type: esriFieldTypeString, alias: If unable to get any information, select one of following:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [under_18: Under 18], [18_24: 18-24], [25_34: 25 -34], ... 7 more ...)
- date_birth_person3 (type: esriFieldTypeDate, alias: What is person 3 date of birth?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- year_birth_person3 (type: esriFieldTypeString, alias: If unable to get day and month, what is the year?, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- guess_birth_year_person3 (type: esriFieldTypeString, alias: If unable to get any information, select one of following:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [under_18: Under 18], [18_24: 18-24], [25_34: 25 -34], ... 7 more ...)
- race_ethnicities (type: esriFieldTypeString, alias: 8. What race(s)/ethnicities do you (and person 2 – 3) identify as?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- race_other (type: esriFieldTypeString, alias: If selected other, please specify?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- race_ethnicities_person2 (type: esriFieldTypeString, alias: What race(s)/ethnicities is person 2 identify as?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- race_other_person2 (type: esriFieldTypeString, alias: If selected other, please specify?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- race_ethnicities_person3 (type: esriFieldTypeString, alias: What race(s)/ethnicities is person 3 identify as?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- race_other_person3 (type: esriFieldTypeString, alias: If selected other, please specify?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- been_homeless (type: esriFieldTypeString, alias: 9. Is this the first time you've (and person 2 – 3) been homeless?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Do_not_know: Don't Know], ... 1 more ...)
- been_homeless_person2 (type: esriFieldTypeString, alias: Is this the first time person 2 has been homeless?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Do_not_know: Don't Know], ... 1 more ...)
- been_homeless_person3 (type: esriFieldTypeString, alias: Is this the first time person 3 has been homeless?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Do_not_know: Don't Know], ... 1 more ...)
- duration_homeless (type: esriFieldTypeString, alias: 10. How long have you (and person 2 – 3) been homeless this time?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0_3_months: 0 to 3 months], [4_6_months: 4 to 6 months], [7_11_months: 7 to 11 months], ... 3 more ...)
- duration_homeless_person2 (type: esriFieldTypeString, alias: How long has person 2 been homeless this time?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0_3_months: 0 to 3 months], [4_6_months: 4 to 6 months], [7_11_months: 7 to 11 months], ... 3 more ...)
- duration_homeless_person3 (type: esriFieldTypeString, alias: How long has person 3 been homeless this time?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0_3_months: 0 to 3 months], [4_6_months: 4 to 6 months], [7_11_months: 7 to 11 months], ... 3 more ...)
- total_months (type: esriFieldTypeString, alias: 11. How many total months have you been on the streets or in shelter over the past 3 years?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0_3_months: 0 to 3 months], [4_6_months: 4 to 6 months], [7_11_months: 7 to 11 months], ... 3 more ...)
- total_months_person2 (type: esriFieldTypeString, alias: How many total months has person 2 been on the streets or in shelter over the past 3 years?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0_3_months: 0 to 3 months], [4_6_months: 4 to 6 months], [7_11_months: 7 to 11 months], ... 3 more ...)
- total_months_person3 (type: esriFieldTypeString, alias: How many total months has person 3 been on the streets or in shelter over the past 3 years?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0_3_months: 0 to 3 months], [4_6_months: 4 to 6 months], [7_11_months: 7 to 11 months], ... 3 more ...)
- separate_times (type: esriFieldTypeString, alias: 12. Including this time, how many separate times have you (or person 2 – 3) stayed on the streets or in shelters in the past 3 years (since January 2021)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Fewer_than4: Fewer than 4], [4_or_more: 4 or more times], [Do_not_know: Don't Know], ... 1 more ...)
- separate_times_person2 (type: esriFieldTypeString, alias: Including this time, how many separate times has person 2 stayed on the streets or in shelters in the past 3 years (since January 2021)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Fewer_than4: Fewer than 4], [4_or_more: 4 or more times], [Do_not_know: Don't Know], ... 1 more ...)
- separate_times_person3 (type: esriFieldTypeString, alias: Including this time, how many separate times has person 3 stayed on the streets or in shelters in the past 3 years (since January 2021)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Fewer_than4: Fewer than 4], [4_or_more: 4 or more times], [Do_not_know: Don't Know], ... 1 more ...)
- Military_Veteran (type: esriFieldTypeString, alias: 13. Are you (or is person 2 – 3) a US Military Veteran? (served in the US Armed Forces OR been called into active duty as a member of the National Guard or as a Reservist), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Do_not_know: Don't Know], ... 1 more ...)
- Military_Veteran_person2 (type: esriFieldTypeString, alias: Is person 2 a US Military Veteran? (served in the US Armed Forces OR been called into active duty as a member of the National Guard or as a Reservist), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Do_not_know: Don't Know], ... 1 more ...)
- Military_Veteran_person3 (type: esriFieldTypeString, alias: Is person 3 a US Military Veteran? (served in the US Armed Forces OR been called into active duty as a member of the National Guard or as a Reservist), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Do_not_know: Don't Know], ... 1 more ...)
- services_org (type: esriFieldTypeString, alias: 14. Are you currently receiving services from any organization or any outreach workers?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Do_not_know: Don't Know], ... 1 more ...)
- name_org (type: esriFieldTypeString, alias: If so, do you know their name or organization?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- services_org_person2 (type: esriFieldTypeString, alias: Is person 2 currently receiving services from any organization or any outreach workers?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Do_not_know: Don't Know], ... 1 more ...)
- name_org_person2 (type: esriFieldTypeString, alias: If so, do you know their name or organization?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- services_org_person3 (type: esriFieldTypeString, alias: Is person 3 currently receiving services from any organization or any outreach workers?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Do_not_know: Don't Know], ... 1 more ...)
- name_org_person3 (type: esriFieldTypeString, alias: If so, do you know their name or organization?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- other_org (type: esriFieldTypeString, alias: 15. Are you okay with the information you gave being shared with other organizations for the purposes of coordinating services and housing? ["Not sure" if person did not answer] , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not_sure: Not sure])
- other_org_person2 (type: esriFieldTypeString, alias: Is person 2 okay with the information you gave being shared with other organizations for the purposes of coordinating services and housing? ["Not sure" if person did not answer] , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not_sure: Not sure])
- other_org_person3 (type: esriFieldTypeString, alias: Is person 3 okay with the information you gave being shared with other organizations for the purposes of coordinating services and housing? "[Not sure" if person did not answer], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not_sure: Not sure])
- easy_find (type: esriFieldTypeString, alias: 16. On a regular day, where is it easiest to find you, and what time of day is easiest to do so?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- phone_email (type: esriFieldTypeString, alias: 17. Is there a phone number and/or email where someone can get in touch with you or leave you a message?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- note (type: esriFieldTypeString, alias: 18. NOTES, SQL Type: sqlTypeOther, length: 3000, nullable: true, editable: true)
- 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)
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/31/2025 2:19:28 PM
Schema Last Edit Date: 1/31/2025 2:01:59 PM
Data Last Edit Date: 1/31/2025 2:19:28 PM
Supported Operations:
Add Features
Apply Edits
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat