Layer: COB_AC_Unit_Request (ID:0)

View In: Map Viewer

Name: COB_AC_Unit_Request

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":"COB AC Unit Request","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

Time Info:

[8/16/2022 2:57:19 PM UTC, 9/14/2022 4:33:57 PM UTC]

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)
org_type (type: esriFieldTypeString, alias: 1. Please select what kind of organization you belong to:, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [Local_Government: Local Government], [County_Government: County Government], [State_Government: State Government], ... 6 more ...)
org_other (type: esriFieldTypeString, alias: Enter your other organization type:, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
organization (type: esriFieldTypeString, alias: organization, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
org_name (type: esriFieldTypeString, alias: 2. Name of organization requesting AC unit:, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
org_poc (type: esriFieldTypeString, alias: 3. Name of organizational point of contact:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
org_phone (type: esriFieldTypeString, alias: 4. Phone number for organization point of contact:, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
org_phone_ext (type: esriFieldTypeInteger, alias: Extension number:, SQL Type: sqlTypeOther, nullable: true, editable: true)
org_email (type: esriFieldTypeString, alias: 5. Email for organization point of contact:, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
individual_name (type: esriFieldTypeString, alias: 6. Name of individual applying for AC unit:, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
individual_phone (type: esriFieldTypeString, alias: 7. Phone Number of individual applying for AC unit:, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
individual_email (type: esriFieldTypeString, alias: 8. Email of individual applying for AC unit:, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
individual_birth_year (type: esriFieldTypeInteger, alias: individual_birth_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
select_preferred (type: esriFieldTypeString, alias: 10. Who does the individual prefer be contacted for coordinating AC Unit delivery and/or installation?, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [Individual: Contact the Individal], [Organization_Applying: Contact the Organization Applying on behalf of the Applicant], [Case_Manager: Contact a Case Manager for the Applicant], ... 1 more ...)
cm_name (type: esriFieldTypeString, alias: Name of case manager:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
cm_phone (type: esriFieldTypeString, alias: Phone number of case manager:, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
cm_phone_ext_yn (type: esriFieldTypeString, alias: Does this phone number have an extension number?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
cm_phone_ext (type: esriFieldTypeInteger, alias: Extension number:, SQL Type: sqlTypeOther, nullable: true, editable: true)
cm_email (type: esriFieldTypeString, alias: Email of case manager:, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
proxy_relationship (type: esriFieldTypeString, alias: Proxy's relationship to individual:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
proxy_name (type: esriFieldTypeString, alias: Proxy's name:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
proxy_phone (type: esriFieldTypeString, alias: Proxy's phone:, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
proxy_phone_ext_yn (type: esriFieldTypeString, alias: Does this phone number have an extension number?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
proxy_phone_ext (type: esriFieldTypeInteger, alias: Extension number:, SQL Type: sqlTypeOther, nullable: true, editable: true)
proxy_email (type: esriFieldTypeString, alias: Proxy's email:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
individual_id (type: esriFieldTypeString, alias: individual_id, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
cco_enrolled (type: esriFieldTypeString, alias: 12. Is the individual enrolled in a Coordinating Care Organization (CCO)?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
cco (type: esriFieldTypeString, alias: Individual's CCO:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [AllCare_CCO: AllCare CCO], [Cascade_Health_Alliance: Cascade Health Alliance], [Columbia_Pacific_CCO: Columbia Pacific CCO], ... 12 more ...)
individual_language (type: esriFieldTypeString, alias: 13. Individual's preferred language:, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
select_65 (type: esriFieldTypeString, alias: Is the individual 65 years of age or older?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
select_child (type: esriFieldTypeString, alias: Is the individual a medically fragile child?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
select_disability (type: esriFieldTypeString, alias: Does the individual have a disability or chronic condition/illness that makes them vulnerable to heat-related illness?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
cm_social (type: esriFieldTypeString, alias: During a heat event is the individual unable to leave one's residence or unable to access a cooling center?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
select_eligible (type: esriFieldTypeString, alias: Is the individual eligible for Medicaid or Medicare?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
select_conditons (type: esriFieldTypeString, alias: select_conditons, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
congregate (type: esriFieldTypeString, alias: Does the individual live in a congregate care setting?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
central_air (type: esriFieldTypeString, alias: Does the individual have air conditioning in their residence?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
central_air_working (type: esriFieldTypeString, alias: Is air conditioning working and accessible in the room the individual occupies?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
ac_note (type: esriFieldTypeString, alias: The AC unit will weigh approximately 50-55 lbs. and will be delivered in an approximately 3-foot-tall box. Given the size & weight of the product…, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assistance (type: esriFieldTypeString, alias: 16. Does the individual require assistance moving the product into their residence or installing it?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
assistance_note (type: esriFieldTypeString, alias: This unit only needs to have a small opening (up to 6 inches) in a window for ventilation. A drip pan is not included but anything can be used to capture the water that drains out of the unit., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
window_type (type: esriFieldTypeString, alias: 17. Which window type does the individual have?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [sliding: Sliding Window], [tilted: Tilting Window], [other: Other Window Type])
window_desc (type: esriFieldTypeString, alias: Brief description of the window, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
titled_note (type: esriFieldTypeString, alias: This unit can be used in a tilting window but will require the individual to cover the opening of the window with cardboard, wood, or plastic sheeting., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
tiltled_assistance (type: esriFieldTypeString, alias: Will the individual require assistance covering the opening of their window?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
org_assistance (type: esriFieldTypeString, alias: Will the organization listed in question 2 or case manager listed in question 10 be able to provide installation assistance?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
shipping_delivery (type: esriFieldTypeString, alias: 18. How would the individual like the unit delivered?, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [home: Direct Shipment to the Applicants Home], [proxy: Direct Shipment to the Applicants Proxy for Installation Support], [cbo: Direct shipment to partner organization, case manager, or government office for installation support], ... 1 more ...)
shipping_other (type: esriFieldTypeString, alias: Method of delivery being requested:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
delivery_address (type: esriFieldTypeString, alias: 19. Address for AC unit delivery:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
delivery_address_line1 (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
delivery_address_line2 (type: esriFieldTypeString, alias: Address Line 2 (Suite, Room or Building Number), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
delivery_city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
delivery_state (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
delivery_zipcode (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
delivery_county (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
x (type: esriFieldTypeDouble, alias: x, SQL Type: sqlTypeOther, nullable: true, editable: true)
y (type: esriFieldTypeDouble, alias: y, SQL Type: sqlTypeOther, nullable: true, editable: true)
reciept_name (type: esriFieldTypeString, alias: 20. Name of individual/organization who will be receiving the AC Unit:, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
receipt_email (type: esriFieldTypeString, alias: 21. Email of individual/organization who will be receiving the AC Unit:, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
receipt_phone (type: esriFieldTypeString, alias: 22. Phone of individual/organization who will be receiving the AC Unit:, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
receipt_phone_ext_yn (type: esriFieldTypeString, alias: Does this phone number have an extension number?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know], ... 1 more ...)
receipt_phone_ext (type: esriFieldTypeInteger, alias: Extension number:, SQL Type: sqlTypeOther, nullable: true, editable: true)
rdcc_date_of_review (type: esriFieldTypeDate, alias: 23. Date of RDCC Review, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
rdcc_initials (type: esriFieldTypeString, alias: 24. RDCC staff initials, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
eligibility (type: esriFieldTypeString, alias: 25. Eligibility Determination:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [not_eligible: Not Eligible], [eligible_ready: Eligible and Ready for Shipment], [eligible_delay: Eligible and Delay for Shipment], ... 3 more ...)
status (type: esriFieldTypeString, alias: 26. Application Status:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [not_eligible: Not Eligible – CBO/Applicant Notified], [referred: Referred to Logistics for Shipping], [shipped: Shipped], ... 1 more ...)
notes (type: esriFieldTypeString, alias: 27. Notes and Comments:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
survey_start_time (type: esriFieldTypeDate, alias: survey_start_time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
survey_end_time (type: esriFieldTypeDate, alias: survey_end_time, 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)
org_phone_ext_yn (type: esriFieldTypeString, alias: Does this phone number have an extension number?, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know])
fire_county (type: esriFieldTypeString, alias: fire_county, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
air_filter (type: esriFieldTypeString, alias: Would you like to be contacteded for a possible air filter device?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: I Don't Know])
score_65plus (type: esriFieldTypeDouble, alias: score_65plus, SQL Type: sqlTypeOther, nullable: true, editable: true)
score_child (type: esriFieldTypeDouble, alias: score_child, SQL Type: sqlTypeOther, nullable: true, editable: true)
score_heat_vulnerable (type: esriFieldTypeDouble, alias: score_heat_vulnerable, SQL Type: sqlTypeOther, nullable: true, editable: true)
score_homebound (type: esriFieldTypeDouble, alias: score_homebound, SQL Type: sqlTypeOther, nullable: true, editable: true)
score_eligible_mm (type: esriFieldTypeDouble, alias: score_eligible_mm, SQL Type: sqlTypeOther, nullable: true, editable: true)
score_respiratory (type: esriFieldTypeDouble, alias: score_respiratory, SQL Type: sqlTypeOther, nullable: true, editable: true)
score_cardiovascular (type: esriFieldTypeDouble, alias: score_cardiovascular, SQL Type: sqlTypeOther, nullable: true, editable: true)
score_diabetes (type: esriFieldTypeDouble, alias: score_diabetes, SQL Type: sqlTypeOther, nullable: true, editable: true)
score_hypertension (type: esriFieldTypeDouble, alias: score_hypertension, SQL Type: sqlTypeOther, nullable: true, editable: true)
score_obesity (type: esriFieldTypeDouble, alias: score_obesity, SQL Type: sqlTypeOther, nullable: true, editable: true)
score_congregate (type: esriFieldTypeDouble, alias: score_congregate, SQL Type: sqlTypeOther, nullable: true, editable: true)
score_ac_available (type: esriFieldTypeDouble, alias: score_ac_available, SQL Type: sqlTypeOther, nullable: true, editable: true)
num_heat_events (type: esriFieldTypeInteger, alias: num_heat_events, SQL Type: sqlTypeOther, nullable: true, editable: true)
score_heat_events (type: esriFieldTypeDouble, alias: score_heat_events, SQL Type: sqlTypeOther, nullable: true, editable: true)
total_score (type: esriFieldTypeDouble, alias: total_score, SQL Type: sqlTypeOther, nullable: true, editable: true)
rural_frontier (type: esriFieldTypeString, alias: rural_frontier, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/17/2025 8:26:05 PM

Schema Last Edit Date: 7/17/2025 8:26:05 PM

Data Last Edit Date: 7/17/2025 8:26:05 PM

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