Name: SITREP_Reporting_Status_(View)

Display Field: STATE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -19942592.2395
YMin: 2023978.7442
XMax: 20012842.9634
YMax: 11536684.7491
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":null,"valueExpression":"var latestDate = $feature[\"SITREP_DATE\"]\r\n\r\nif (latestDate == null) {\r\n return \"\"\r\n} else if (DateDiff(now(), latestDate, \"hours\") < 24) {\r\n return \"Current\"\r\n} else if (DateDiff(now(), latestDate, \"hours\") >= 24 && DateDiff(now(), latestDate, \"hours\") < 48) {\r\n return \">24 Hours Overdue\"\r\n} else if (DateDiff(now(), latestDate, \"hours\") > 48 && DateDiff(now(), latestDate, \"days\") <= 7) {\r\n return \">48 Hours Overdue\"\r\n} else {\r\n return \"No Recent Reporting\"\r\n}","valueExpressionTitle":"Reporting Status","uniqueValueInfos":[{"value":"Current","symbol":{"color":[76,230,0,139],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"Current"},{"value":">24 Hours Overdue","symbol":{"color":[230,230,0,139],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":">24 Hours Overdue"},{"value":">48 Hours Overdue","symbol":{"color":[230,0,0,139],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":">48 Hours Overdue"},{"value":"No Recent Reporting","symbol":{"color":[153,153,153,139],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"No Recent Reporting"}]},"transparency":20}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• STATE_NAME (type: esriFieldTypeString, alias: State Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WING_ABBR (type: esriFieldTypeString, alias: Wing Abbreviation, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• STATE_FIPS (type: esriFieldTypeString, alias: State FIPS, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• SQ_MILES (type: esriFieldTypeDouble, alias: SQ Miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• REGION (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WING (type: esriFieldTypeString, alias: Wing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REGION_ABBR (type: esriFieldTypeString, alias: Region Abbreviation, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
• 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)
• SITREP_GUID (type: esriFieldTypeGUID, alias: SITREP GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• SITREP_WING (type: esriFieldTypeString, alias: SITREP Wing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AR: Arkansas], [AZ: Arizona], [CO: Colorado], ... 50 more ...)
• SITREP_DATE (type: esriFieldTypeDate, alias: SITREP Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SITREP_IC (type: esriFieldTypeString, alias: IC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SITREP_IC_Rank (type: esriFieldTypeString, alias: IC Rank, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [2d Lt: 2d Lt], [1st Lt: 1st Lt], [Capt: Capt], ... 5 more ...)
• SITREP_IC_Email (type: esriFieldTypeString, alias: IC Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SITREP_IC_Phone (type: esriFieldTypeString, alias: IC Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SITREP_IC_Next (type: esriFieldTypeString, alias: Next IC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SITREP_IC_Next_Rank (type: esriFieldTypeString, alias: Next IC Rank, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [2d Lt: 2d Lt], [1st Lt: 1st Lt], [Capt: Capt], ... 5 more ...)
• SITREP_IC_Next_Email (type: esriFieldTypeString, alias: Next IC Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SITREP_IC_Next_Phone (type: esriFieldTypeString, alias: Next IC Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SITREP_Mission_Current (type: esriFieldTypeString, alias: Current Narrative, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PERSONNEL_Last24_EOC (type: esriFieldTypeSmallInteger, alias: Personnel - EOC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Last24_POD (type: esriFieldTypeSmallInteger, alias: Personnel - POD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Last24_CallCntr (type: esriFieldTypeSmallInteger, alias: Personnel - Call Center, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Last24_Other (type: esriFieldTypeSmallInteger, alias: Personnel - Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Last24_Aircrew (type: esriFieldTypeSmallInteger, alias: Personnel - Aircrew, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Last24_Ground (type: esriFieldTypeSmallInteger, alias: Personnel - Ground Transport, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Last24_Staff (type: esriFieldTypeSmallInteger, alias: Personnel - Staff, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONNEL_Info (type: esriFieldTypeString, alias: Personnel - Other Info, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RESOURCE_Aircraft_Next24 (type: esriFieldTypeSmallInteger, alias: Aircraft Next 24, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESOURCE_Aircraft_Next48 (type: esriFieldTypeSmallInteger, alias: Aircraft Next 48, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESOURCE_Aircraft_Next72 (type: esriFieldTypeSmallInteger, alias: Aircraft Next 72, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESOURCE_Ground_Next24 (type: esriFieldTypeSmallInteger, alias: Ground Crews Next 24, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESOURCE_Ground_Next48 (type: esriFieldTypeSmallInteger, alias: Ground Crews Next 48, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESOURCE_Ground_Next72 (type: esriFieldTypeSmallInteger, alias: Ground Crews Next 72, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESOURCE_Other_Next24 (type: esriFieldTypeString, alias: Other Next 24, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RESOURCE_Other_Next48 (type: esriFieldTypeString, alias: Other Next 48, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RESOURCE_Other_Next72 (type: esriFieldTypeString, alias: Other Next 72, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AIRCRAFT_Flown (type: esriFieldTypeSmallInteger, alias: Aircraft Flown, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AIRCRAFT_Sorties (type: esriFieldTypeSmallInteger, alias: Aircraft Sorties, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AIRCRAFT_Hours (type: esriFieldTypeSmallInteger, alias: Aircraft Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GROUND_Vehicles (type: esriFieldTypeSmallInteger, alias: Ground Vehicles Utilized, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GROUND_Sorties (type: esriFieldTypeSmallInteger, alias: Ground Sorties, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SITREP_DELIVERABLES (type: esriFieldTypeString, alias: Deliverables Reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SITREP_ACTIVITY (type: esriFieldTypeString, alias: Activities Reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SITREP_ISSUES (type: esriFieldTypeString, alias: Issues Reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SITREP_IC_Tomorrow (type: esriFieldTypeString, alias: Same IC Y/N, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• GlobalID_1617393308535 (type: esriFieldTypeGUID, alias: GlobalID_1617393308535, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate_1617393308535 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1617393308535 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1617393308535 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1617393308535 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/7/2021 2:25:14 PM

Schema Last Edit Date: 4/7/2021 2:25:14 PM

Data Last Edit Date: 4/7/2021 2:25:14 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat