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:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)
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:
Start Time Field: survey_start_time
End Time Field: survey_end_time
Track ID Field: null
Time Extent[8/16/2022 2:57:19 PM UTC, 9/14/2022 4:33:57 PM UTC]
Time Reference: UTC
Time Interval: 0
Time Interval Units: esriTimeUnitsMilliseconds
Has Live Data: false
Export Options:
Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies
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)
- 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:
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/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