Name: SpousePartner_Information

Display Field: objectid

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: 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)
• SPFirstNameInitial (type: esriFieldTypeString, alias: 2. What is the first initial of your first name?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 24 more ...)
• SPLastNameInitial (type: esriFieldTypeString, alias: 3. What is the first initial of your last name?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 24 more ...)
• SPSingleGender (type: esriFieldTypeString, alias: 4. What is your gender?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Woman: Woman (Girl if child)], [Man: Man (Boy if child)], [CulturallySpecific: Culturally Specific Identity (e.g., Two-Spirit)], ... 7 more ...)
• SPMultiGender (type: esriFieldTypeString, alias: 4a. If 'More than one gender', what genders?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPGender (type: esriFieldTypeString, alias: SP GenderAnswer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPAge (type: esriFieldTypeInteger, alias: 5. How old are you?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPminr_groupAns (type: esriFieldTypeString, alias: SPminr_groupAns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPya_groupAns (type: esriFieldTypeString, alias: SPya_groupAns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPadlt2534_groupAns (type: esriFieldTypeString, alias: SPadlt2534_groupAns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPadlt3544_groupAns (type: esriFieldTypeString, alias: SPadlt3544_groupAns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPadlt4554_groupAns (type: esriFieldTypeString, alias: SPadlt4554_groupAns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPadlt5564_groupAns (type: esriFieldTypeString, alias: SPadlt5564_groupAns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPadlt65_groupAns (type: esriFieldTypeString, alias: SPadlt65_groupAns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPage_groupAns (type: esriFieldTypeString, alias: Age Group, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPSingleRace (type: esriFieldTypeString, alias: 6. What is your race/ethnicity?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NativeAmerican: American Indian, Alaska Native, or Indigenous], [Asian: Asian or Asian American], [Black: Black, African American, or African], ... 7 more ...)
• SPMultiRace (type: esriFieldTypeString, alias: 6a. If 'More than once race/ethnicity', select all races/ethnicities the individual identifies with., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPRaceAnswer (type: esriFieldTypeString, alias: Spouse/Partner Race Answer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPStateBorn (type: esriFieldTypeString, alias: 7. In which state were you born?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AL: Alabama], [AK: Alaska], [AZ: Arizona], ... 50 more ...)
• SPCountry (type: esriFieldTypeString, alias: 7a. In what country were you born?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [MX: MX (Mexico)], [CAN: CAN (Canada)], [Other: Other])
• SPOtherCountry (type: esriFieldTypeString, alias: 7b. What 'Other' country?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPCountryCalc (type: esriFieldTypeString, alias: SPCountryCalc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPCountryBorn (type: esriFieldTypeString, alias: SPCountryBorn, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPHomelessCity (type: esriFieldTypeString, alias: 8. In what city/community did you first become homeless?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Adelanto: Adelanto], [AppleValley: Apple Valley], [Barstow: Barstow], ... 35 more ...)
• SPHomelessFirstTime (type: esriFieldTypeString, alias: 9. Did you become homeless for the first time during the past 12 months?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [ClientRefused: Client refused], ... 1 more ...)
• SPHomelessYearOrMore (type: esriFieldTypeString, alias: 10. Have you been living in a shelter and/or on the streets, in abandoned buildings, or in a vehicle for the past year or more?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [ClientRefused: Client refused], ... 1 more ...)
• SPHomelessThreeYearsOrMore (type: esriFieldTypeString, alias: 11. Have you been living in a shelter and/or on the streets, in abandoned buildings, or in a vehicle at least *4* separate times during the last 3 years including now?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [ClientRefused: Client refused], ... 1 more ...)
• SPCombineHomelessTime (type: esriFieldTypeString, alias: 11a. Was the combined length of time 12 months or more?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [ClientRefused: Client refused], ... 1 more ...)
• SPArmedForces (type: esriFieldTypeString, alias: 12. Have you served in the United States Armed Forces?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [ClientRefused: Client refused], ... 1 more ...)
• SPNationalGuard (type: esriFieldTypeString, alias: 12a. Were you ever 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], [ClientRefused: Client refused], ... 1 more ...)
• SPDisabilityFactors (type: esriFieldTypeString, alias: 13. Do you have any of the following disabilities or disorders that make it difficult for you or seriously limits your ability to live independently?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPHIV (type: esriFieldTypeString, alias: 14. Have you been diagnosed with AIDS or have tested positive for HIV?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [ClientRefused: Client refused], ... 1 more ...)
• SPChronicHealth (type: esriFieldTypeString, alias: 15. Has a doctor or other medical professional ever told you that you have a chronic health condition that is life-threatening such as heart, lung, liver, kidney or cancerous disease?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [ClientRefused: Client refused], ... 1 more ...)
• SPClientPhone (type: esriFieldTypeString, alias: Would you like to provide a phone number so a team member can contact and locate you to provide assistance and services for your need(s)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPClientEmail (type: esriFieldTypeString, alias: Would you like to provide an email address so a team member can contact and locate you to provide assistance and services for your need(s)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPDomesticViolence (type: esriFieldTypeString, alias: 16. Are you currently experiencing homelessness because you are fleeing domestic violence, dating violence, sexual assault or stalking?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [ClientRefused: Client refused], ... 1 more ...)
• SPIncarcerated12Mos (type: esriFieldTypeString, alias: 17. Have you been incarcerated during the last 12 months?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [ClientRefused: Client refused], ... 1 more ...)
• SPProbationParole12Mos (type: esriFieldTypeString, alias: 17a. Were you released on parole or probation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Parole: Parole], [Probation: Probation], [No: No], ... 2 more ...)
• SPIncome (type: esriFieldTypeString, alias: 18. How much is your monthly income?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [noIncome: No Income], [1to250: $1 to $250], [251to500: $251 to $500], ... 2 more ...)
• SPFosterCare (type: esriFieldTypeString, alias: 19. Have you ever been in foster care?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [ClientRefused: Client refused], ... 1 more ...)
• SPSenior (type: esriFieldTypeString, alias: SPSenior, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPHasDisability (type: esriFieldTypeString, alias: SPHasDisability, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPUniqueID (type: esriFieldTypeString, alias: SPUniqueID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPChronicHomeless (type: esriFieldTypeString, alias: SPChronicHomeless, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPPhysicalDisability (type: esriFieldTypeString, alias: SPPhysicalDisability, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPDevelopmentalDisability (type: esriFieldTypeString, alias: SPDevelopmentalDisability, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPMentalDisability (type: esriFieldTypeString, alias: SPMentalDisability, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPSubstanceDisability (type: esriFieldTypeString, alias: SPSubstanceDisability, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPTargetPopulation (type: esriFieldTypeString, alias: SPTargetPopulation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)

Relationships:

• _2025_DRAFT_PITC_Survey_SpousePartner_Information (2) -- Related To: _2025_DRAFT_PITC_Survey (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/12/2024 6:26:33 PM

Schema Last Edit Date: 12/12/2024 6:26:33 PM

Data Last Edit Date: 12/12/2024 6:26:33 PM

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