Name: Safe_Drinking_Water_Voucher_Application

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":"Safe Drinking Water Voucher Application","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:

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)
• OHAVoucherId (type: esriFieldTypeGUID, alias: OHA Voucher Id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OHAApplicationId (type: esriFieldTypeGUID, alias: OHA Application Id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VoucherIdentifier (type: esriFieldTypeString, alias: Voucher Identifier, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• VoucherType (type: esriFieldTypeString, alias: Voucher Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• VoucherIssueDate (type: esriFieldTypeDate, alias: Voucher Iussue Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VoucherApplicationDate (type: esriFieldTypeDate, alias: Voucher Application Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ApplicationStatus (type: esriFieldTypeString, alias: Application Status, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• VoucherMaxValue (type: esriFieldTypeDouble, alias: Voucher Max Value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisclaimerYesNo (type: esriFieldTypeString, alias: I am requesting that OHA keep my name and address confidential to the extent permitted by law. OHA will use this information as necessary for voucher tracking and distribution., SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [yes: Yes, I am requesting that OHA keep my name and address confidential to the extent permitted by law.], [no: No, I am not requesting that OHA keep my name and address confidential.])
• WellTypeChoice (type: esriFieldTypeString, alias: Does your household use water from a private (domestic) well for things like drinking, cooking, and washing dishes?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [private: Yes, the well is private. I own or rent the property and use the well.], [public: No, I get water from a public water system. I pay a water bill.])
• LearnAbout (type: esriFieldTypeString, alias: How did you learn about OHA's free well testing?, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [New Media: I saw an online notice (web advertising, online newspaper, Facebook or other social media)], [Online Search: I did a search online], [Traditional Media: I heard a radio ad, saw a newspaper ad or saw a news article], ... 3 more ...)
• HouseholdID_PrimaryKey (type: esriFieldTypeGUID, alias: Household Id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ContactFirstName (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• ContactLastName (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• HouseholdMailingFullAddress (type: esriFieldTypeString, alias: Mailing Address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• HouseholdStreetMailingUnit (type: esriFieldTypeString, alias: Apartment, unit or suite number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• HouseholdMailingAddress (type: esriFieldTypeString, alias: Mailing Street, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• HouseholdMailingCity (type: esriFieldTypeString, alias: Mailing City, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• HouseholdMailingState (type: esriFieldTypeString, alias: Mailing State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• HouseholdMailingZip (type: esriFieldTypeString, alias: Mailing Zip Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• HouseholdMailing_x (type: esriFieldTypeDouble, alias: Mailing X Coordination, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HouseholdMailing_y (type: esriFieldTypeDouble, alias: Mailing Y Coordination, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MailHouseSame (type: esriFieldTypeString, alias: Are the mailing and home address the same?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• HouseholdStreetFullAddress (type: esriFieldTypeString, alias: Home Address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• HouseholdStreetAddressUnit (type: esriFieldTypeString, alias: Apartment, unit or suite number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• HouseholdStreetAddress (type: esriFieldTypeString, alias: Home Street, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• HouseholdStreetCity (type: esriFieldTypeString, alias: Home City, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• HouseholdStreetState (type: esriFieldTypeString, alias: Home State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• HouseholdStreetZip (type: esriFieldTypeString, alias: Home Zip Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• HouseholdCounty (type: esriFieldTypeString, alias: Home County, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• HouseholdStreet_x (type: esriFieldTypeDouble, alias: Home X Coordination, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HouseholdStreet_y (type: esriFieldTypeDouble, alias: Home Y Coordination, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HouseholdEmail (type: esriFieldTypeString, alias: Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HouseholdPhoneCell (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IsCell (type: esriFieldTypeString, alias: Is this phone number a cell phone?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• PreferredContactType (type: esriFieldTypeString, alias: Preferred method of contact, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• AgeUnder15 (type: esriFieldTypeInteger, alias: How many people in your household are age 15 and younger?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age16andUp (type: esriFieldTypeInteger, alias: How many people in your household are age 16 and older?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pregnant (type: esriFieldTypeString, alias: Is anyone in your household pregnant or may become pregnant?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• InfantsBelow2 (type: esriFieldTypeString, alias: Are there any babies or small children in your household age 2 or younger?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• RealDYesNo (type: esriFieldTypeString, alias: Would you like to tell us your race, ethnicity, language and ability levels?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• RaceEthnicity (type: esriFieldTypeString, alias: How do you identify your race, ethnicity, tribal affiliation, country of origin, or ancestry?, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• RaceEthnicityOther (type: esriFieldTypeString, alias: Enter Other, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• RaceEthnicityPrimary (type: esriFieldTypeString, alias: If you checked more than one category in the previous question, is there one you think of as your primary racial or ethnic identity? Please select the category or your response below., SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• RaceEthnicityPrimaryOther (type: esriFieldTypeString, alias: Enter Other, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Language (type: esriFieldTypeString, alias: What language or languages do you use at home?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [English Only: English Only], [Other: Other])
• LanguageOther (type: esriFieldTypeString, alias: Enter the other langauge spoken in the home, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LanguageCommunication (type: esriFieldTypeString, alias: In what language do you want us to communicate in person, on the phone, or virtually with you?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LanguageWritten (type: esriFieldTypeString, alias: In what language do you want us to write to you?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InterpreterNeeded (type: esriFieldTypeString, alias: Do you need or want an interpreter for us to communicate with you?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [don't know: Don't know], ... 1 more ...)
• InterpreterType (type: esriFieldTypeString, alias: If you need or want an interpreter, what type of interpreter is preferred?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Spoken language interpreter: Spoken language interpreter], [American Sign Language interpreter: American Sign Language interpreter], [Deaf interpreter for Deaf/Blind, additional barriers, or both: Deaf interpreter for Deaf/Blind, additional barriers, or both], ... 2 more ...)
• InterpreterTypeOther (type: esriFieldTypeString, alias: Other interpreter type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EnglishProficiency (type: esriFieldTypeString, alias: How well do you speak English?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Very well: Very well], [Well: Well], [Not well: Not well], ... 3 more ...)
• Hearing (type: esriFieldTypeString, alias: Are you deaf or do you have serious difficulty hearing?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [don't know: Don't know], ... 1 more ...)
• HearingOther (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Blind (type: esriFieldTypeString, alias: Are you blind or do you have serious difficulty seeing, even when wearing glasses?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [don't know: Don't know], ... 1 more ...)
• BlindOther (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Walk_Stairs (type: esriFieldTypeString, alias: Do you have serious difficulty walking or climbing stairs?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [don't know: Don't know], ... 1 more ...)
• Walk_StairsOther (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MentalDifficulties (type: esriFieldTypeString, alias: Because of a physical, mental or emotional condition, do you have serious difficulty concentrating, remembering, or making decisions?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [don't know: Don't know], ... 1 more ...)
• MentalDifficultiesOther (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Dressing_Bathing (type: esriFieldTypeString, alias: Do you have difficulty dressing or bathing?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [don't know: Don't know], ... 1 more ...)
• Dressing_BathingOther (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LearningDifficulties (type: esriFieldTypeString, alias: Do you have serious difficulty learning how to do things most people your age can learn?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [don't know: Don't know], ... 1 more ...)
• LearningDifficultiesOther (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CommDifficulties (type: esriFieldTypeString, alias: Using your usual (customary language), do you have serious difficulty communicating (for example understanding or being understood by others)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [don't know: Don't know], ... 1 more ...)
• CommDifficultiesOther (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ErrandDifficulties (type: esriFieldTypeString, alias: Because of a physical, mental or emotional condition, do you have difficulty doing errands alone such as visiting a doctor's office or shopping?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [don't know: Don't know], ... 1 more ...)
• ErrandDifficultiesOther (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BehaviorDifficulties (type: esriFieldTypeString, alias: Do you have serious difficulty with the following: mood, intense feelings, controlling your behavior, or experiencing delusions or hallucinations?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [don't know: Don't know], ... 1 more ...)
• BehaviorDifficultiesOther (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PrimaryKeyOHAWellID (type: esriFieldTypeString, alias: OHAWellId, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• WellType (type: esriFieldTypeString, alias: Well Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WellTag (type: esriFieldTypeString, alias: Well Tag, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WellLog (type: esriFieldTypeString, alias: Well Log Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SharedWell (type: esriFieldTypeString, alias: Does your household share a well with another property?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unsure: Unsure])
• HouseWellSame (type: esriFieldTypeString, alias: Are the mailing and well address the same?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• WellStreetFullAddress (type: esriFieldTypeString, alias: Well Address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• WellStreetAddress (type: esriFieldTypeString, alias: Well Street, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• WellStreetCity (type: esriFieldTypeString, alias: Well City, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• WellStreetState (type: esriFieldTypeString, alias: Well State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• WellStreetZip (type: esriFieldTypeString, alias: Well Zip Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• WellStreetCounty (type: esriFieldTypeString, alias: Well County, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WellStreetLatitude (type: esriFieldTypeDouble, alias: Well X Coordination, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WellStreetLongitude (type: esriFieldTypeDouble, alias: Well Y Coordination, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StudyAreaInOut (type: esriFieldTypeString, alias: In or Out of Study Area, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ConsentItems (type: esriFieldTypeString, alias: I agree, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CanvasserCode (type: esriFieldTypeString, alias: Enter Canvasser Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Existing_HouseholdId (type: esriFieldTypeString, alias: Existing Household Id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CanvasserName (type: esriFieldTypeString, alias: Canvasser Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• AcceptedServices (type: esriFieldTypeString, alias: Accepted Services, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Testing & Water: Testing & Water], [Testing Only: Testing Only], [Refused: Refused], ... 1 more ...)
• CanvasserContact (type: esriFieldTypeString, alias: Type of Contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Sample collected: Sample collected], [Not home: Not home], [Not accessible: Not accessible (no tresspassing, dog)], ... 8 more ...)
• canvasserComment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 250, 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)
• CommunicationType (type: esriFieldTypeString, alias: What language would you like us to use to communicate information about your well water?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [English: English], [Spanish: Spanish], [Other: Other])
• OtherCommunicationType (type: esriFieldTypeString, alias: Other language, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• InterestedApplicant (type: esriFieldTypeString, alias: Is there an interested voucher applicant at the current location?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [schedule: Schedule an Appointment])
• CanvassingAddress (type: esriFieldTypeString, alias: Canvassing Address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ContactType (type: esriFieldTypeString, alias: Type of Contact, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [Sample collected: Sample collected], [Not home 1st Attempt: Not home: 1st Attempt], [Not home 2nd Attempt: Not home: 2nd Attempt], ... 10 more ...)
• CanvassingStreet_x (type: esriFieldTypeDouble, alias: Well X Coordination, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CanvassingStreet_y (type: esriFieldTypeDouble, alias: Well Y Coordination, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HousingUnitID (type: esriFieldTypeInteger, alias: Existing Housing Unit Id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ReviewedByOREMgis (type: esriFieldTypeString, alias: Reviewed by OREM GIS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SampleDate (type: esriFieldTypeDate, alias: Date of Sample, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SampleTime (type: esriFieldTypeString, alias: Time of Sample, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true, Coded Values: [Morning [9am – 12pm]: Morning [9am – 12pm]], [Afternoon [12pm – 4pm]: Afternoon [12pm – 4pm]], [Evening [4pm – 8pm]: Evening [4pm – 8pm]])
• HousingUnitNewId (type: esriFieldTypeGUID, alias: Auto Generated UUID for a House Unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WellIdentifier (type: esriFieldTypeString, alias: Well Identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WellId (type: esriFieldTypeGUID, alias: Well Id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HouseholdMailingCounty (type: esriFieldTypeString, alias: Mailing County, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RentType (type: esriFieldTypeString, alias: Do you own or rent the current home that you live in?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Own: Own], [Rent: Rent], [Other: Other])
• OtherRentType (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 50, 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: 7/2/2025 9:42:20 PM

Schema Last Edit Date: 7/2/2025 9:42:20 PM

Data Last Edit Date: 7/2/2025 9:42:20 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat