Layer: Dev_Pub___Safe_Drinking_Water_Voucher

View In: Map Viewer

Name: Dev_Pub___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:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Dev Pub - 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: false

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: 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.])
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)
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)
HouseholdMailingCounty (type: esriFieldTypeString, alias: Mailing County, SQL Type: sqlTypeOther, length: 50, 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])
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 home 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)
HousingUnitID (type: esriFieldTypeInteger, alias: Existing Housing Unit Id, SQL Type: sqlTypeOther, nullable: true, editable: true)
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)
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)
ScheduleTest (type: esriFieldTypeString, alias: To test your well water, a sample must be collected and taken to a lab. Would you like to schedule an appointment for a staff member to help with this?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes, I want to schedule an appointment for someone to collect my water sample and drop off at the lab], [no: No, I will collect and drop off the water sample myself])
PreferredSampleDays (type: esriFieldTypeString, alias: What day(s) of the week would you be available?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PreferredSampleTimes (type: esriFieldTypeString, alias: What window(s) of time work best for you?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
is_retest (type: esriFieldTypeString, alias: Is this a first-time test of your well water by OHA, or a follow up test?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [new: New or first-time well water test], [retest: Follow up or retest of well water])
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:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/22/2025 7:51:28 PM

Schema Last Edit Date: 7/22/2025 7:51:28 PM

Data Last Edit Date: 7/22/2025 7:51:28 PM

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

Layer: Dev_Pub___Safe_Drinking_Water_Voucher_Application (ID:0)