Name: Fire_Incidents_DN8
Display Field:
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: true
Views
Description:
Copyright Text:
Min. Scale: 2311163
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -13076084.8753823
YMin: 3834484.1177256
XMax: -12926366.3941568
YMax: 3955726.15326318
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"authoringInfo":{},"type":"uniqueValue","valueExpression":"var currentTime = Now();\n// var beforeResponseStarted = Boolean($feature[\"Response_Started_Date\"] > currentTime);\nvar responseStartedIsNull = Boolean(isEmpty($feature[\"Response_Started_Date\"]));\nvar responseStarted = Boolean($feature[\"Response_Started_Date\"] < currentTime && !responseStartedIsNull);\nvar sinceResponseStarted = DateDiff(currentTime, $feature[\"Response_Started_Date\"], \"minute\");\n// var assignedIsNull = Boolean(isEmpty($feature[\"Assigned_Date\"]));\n// var assigned = Boolean($feature[\"Assigned_Date\"] < currentTime && !assignedIsNull);\n// var enrouteIsNull = Boolean(isEmpty($feature[\"Enroute_Date\"]));\n// var enroute = Boolean($feature[\"Enroute_Date\"] < currentTime && !enrouteIsNull);\n// var onSceneIsNull = Boolean(isEmpty($feature[\"Arrived_At_Scene_Date\"]));\n// var onScene = Boolean($feature[\"Arrived_At_Scene_Date\"] < currentTime && !onSceneIsNull);\nvar clearedIsNull = Boolean(isEmpty($feature[\"Call_Cleared_Date\"]));\nvar cleared = Boolean($feature[\"Call_Cleared_Date\"] < currentTime && !clearedIsNull);\n\n// Cancel incident if just left open\nvar cancellationThreshold\n\nvar stage = \"\";\n\nif (!responseStarted) { stage = \"Future\" }\n// else if (responseStartedIsNull) { stage = \"Cleared\" }\nelse if (responseStarted) { \n stage = \"Active\";\n // stage = \"Dispatching\"; \n // // Some incidents never reach reach certain stages, so fall back to prior if next stage timestamp is null\n // if (assigned) { \n // stage = \"Turning Out\";\n // if (enroute) { \n // stage = \"Enroute\";\n // if (onScene) { \n // stage = \"On Scene\"; \n // }\n // }\n // }\n}\n// Now, regardless of what stages the incident may have gone through, check if it has been cleared\nif (cleared) { \n stage = \"Cleared\";\n // if (assignedIsNull || enrouteIsNull || onSceneIsNull) { status = cancelled }\n}\n// If an incident is open for more than 24 hours, consider it cleared\nif (clearedIsNull && sinceResponseStarted/60 > 24) { stage = \"Cleared\" }\n\n// Generate unique values\nif (currentTime < Date(\"2019-06-06 00:10:00\")) {\n var ranNum = Floor(Random()*6);\n Console(ranNum);\n stage = When (\n ranNum == 0, \"Future\",\n ranNum == 1, \"Active\",\n // ranNum == 1, \"Dispatching\",\n // ranNum == 2, \"Turning Out\",\n // ranNum == 3, \"Enroute\",\n // ranNum == 4, \"On Scene\",\n ranNum == 5, \"Cleared\",\n \"Future\"\n );\n}\n\nreturn $feature[\"Incident_Type\"] + \" - \" + stage\n","valueExpressionTitle":"Incident Type and Status","uniqueValueInfos":[{"value":"Fire - Active","symbol":{"color":[206,48,23,255],"size":11.25,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[165,39,17,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Fire - Active"},{"value":"Fire - Cleared","symbol":{"color":[206,48,23,185],"size":2.25,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[165,39,17,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Fire - Cleared"},{"value":"Medical - Active","symbol":{"color":[0,113,182,255],"size":11.25,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,98,163,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Medical - Active"},{"value":"Medical - Cleared","symbol":{"color":[0,113,182,183],"size":2.25,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,98,163,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Medical - Cleared"},{"value":"Other - Active","symbol":{"color":[217,191,43,255],"size":11.25,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[189,167,38,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Other - Active"},{"value":"Other - Cleared","symbol":{"color":[217,191,43,183],"size":2.25,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[189,167,38,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Other - Cleared"}]},"transparency":0}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: ObjectId
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- ID (type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeInteger, nullable: false, editable: true)
- Master_Incident_Number (type: esriFieldTypeString, alias: Master_Incident_Number, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Incident_Date (type: esriFieldTypeDate, alias: Incident_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
- Incident_Date_Str (type: esriFieldTypeString, alias: Incident_Date_Str, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Year (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- Month (type: esriFieldTypeString, alias: Month, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Month_Num (type: esriFieldTypeInteger, alias: Month_Num, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- DOW (type: esriFieldTypeString, alias: DOW, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- DOW_Num (type: esriFieldTypeInteger, alias: DOW_Num, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- Hour_PT (type: esriFieldTypeInteger, alias: Hour_PT, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- Jurisdiction (type: esriFieldTypeString, alias: Jurisdiction, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Division (type: esriFieldTypeString, alias: Division, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Battalion (type: esriFieldTypeString, alias: Battalion, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Station (type: esriFieldTypeInteger, alias: Station, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- Incident_Type (type: esriFieldTypeString, alias: Incident_Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Color1 (type: esriFieldTypeString, alias: Color1, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Color2 (type: esriFieldTypeString, alias: Color2, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Problem (type: esriFieldTypeString, alias: Problem, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Cancel_Reason (type: esriFieldTypeString, alias: Cancel_Reason, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Priority_Number (type: esriFieldTypeInteger, alias: Priority_Number, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- Priority_Description (type: esriFieldTypeString, alias: Priority_Description, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Location_Name (type: esriFieldTypeString, alias: Location_Name, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Apartment (type: esriFieldTypeString, alias: Apartment, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Postal_Code (type: esriFieldTypeString, alias: Postal_Code, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Location_Type (type: esriFieldTypeString, alias: Location_Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- Radio_Name (type: esriFieldTypeString, alias: Radio_Name, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- Phone_Picked_Up_Date (type: esriFieldTypeDate, alias: Phone_Picked_Up_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
- Call_Closed_Date (type: esriFieldTypeDate, alias: Call_Closed_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
- Response_Started_Date (type: esriFieldTypeDate, alias: Response_Started_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
- Assigned_Date (type: esriFieldTypeDate, alias: Assigned_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
- Dispatch_Time_Sec (type: esriFieldTypeInteger, alias: Dispatch_Time_Sec, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- Enroute_Date (type: esriFieldTypeDate, alias: Enroute_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
- Turnout_Time_Sec (type: esriFieldTypeInteger, alias: Turnout_Time_Sec, SQL Type: sqlTypeInteger, nullable: true, editable: true)
- Arrived_At_Scene_Date (type: esriFieldTypeDate, alias: Arrived_At_Scene_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
- Response_Travel_Time (type: esriFieldTypeDouble, alias: Response_Travel_Time, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- Call_To_Arrival_Time (type: esriFieldTypeDouble, alias: Call_To_Arrival_Time, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- Response_Started_To_Arrival_Tim (type: esriFieldTypeDouble, alias: Response_Started_To_Arrival_Time, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- Call_Cleared_Date (type: esriFieldTypeDate, alias: Call_Cleared_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
- Time_On_Scene (type: esriFieldTypeDouble, alias: Time_On_Scene, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- Time_Incident_Open (type: esriFieldTypeDouble, alias: Time_Incident_Open, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
- Color3 (type: esriFieldTypeString, alias: Color3, SQL Type: sqlTypeOther, length: 256, 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: 12/20/2023 2:21:18 PM
Schema Last Edit Date: 12/20/2023 2:21:18 PM
Data Last Edit Date: 12/20/2023 2:20:34 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat