Name: Citizen_Service_Requests

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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: -12482001.917
YMin: 0
XMax: 0
YMax: 5097155.172
Spatial Reference: 102100 (3857)
Vertical Spatial Reference: 115700 (115700)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"CALC_Status","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,255,255],"width":1}},"value":"OPEN","label":"OPEN"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[56,168,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,255,255],"width":1}},"value":"CLOSED","label":"CLOSED"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,220,212,255],"toColor":[252,220,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,183,255],"toColor":[182,252,183,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,182,252,255],"toColor":[184,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,251,255],"toColor":[187,252,251,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,229,255],"toColor":[252,179,229,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,246,179,255],"toColor":[252,246,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,218,252,255],"toColor":[204,218,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[222,252,212,255],"toColor":[222,252,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,185,255],"toColor":[252,179,185,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[231,202,252,255],"toColor":[231,202,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,235,255],"toColor":[252,215,235,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,225,187,255],"toColor":[252,225,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[224,252,184,255],"toColor":[224,252,184,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: CALC_Status

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ProblemCode (type: esriFieldTypeString, alias: Problem Code, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DateTimeInit (type: esriFieldTypeDate, alias: Date Initiated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Priority (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• ReqCategory (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• SubmitTo (type: esriFieldTypeString, alias: Submit To, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DispatchTo (type: esriFieldTypeString, alias: Dispatch To, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• ProbAddress (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• ProbCity (type: esriFieldTypeString, alias: Incident City, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• ProbState (type: esriFieldTypeString, alias: Incident State, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• ProbZip (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• ProbDistrict (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• ProbLandmark (type: esriFieldTypeString, alias: Landmark, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Shop (type: esriFieldTypeString, alias: Shop, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• MapPage (type: esriFieldTypeString, alias: Map Page, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• TileNo (type: esriFieldTypeString, alias: Tile No, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• WorkOrderId (type: esriFieldTypeString, alias: WO ID, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• LaborCost (type: esriFieldTypeDouble, alias: Labor Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InitiatedBy (type: esriFieldTypeString, alias: Initiated By, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DateSubmitTo (type: esriFieldTypeDate, alias: Date Submit To, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateDispatchTo (type: esriFieldTypeDate, alias: Date Dispatch To, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ClosedBy (type: esriFieldTypeString, alias: Closed By, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DateTimeClosed (type: esriFieldTypeDate, alias: Date Time Closed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PrjCompleteDate (type: esriFieldTypeDate, alias: Prj Complete Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• FieldInvtDone (type: esriFieldTypeString, alias: Field Invt Done, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DateInvtDone (type: esriFieldTypeDate, alias: Date Invt Done, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Excursion (type: esriFieldTypeString, alias: Excursion, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• WoNeeded (type: esriFieldTypeString, alias: WO Needed, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• SubmitToOpenBy (type: esriFieldTypeString, alias: Submit To Open By, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DateSubmitToOpen (type: esriFieldTypeDate, alias: Date Submit To Open, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DispatchOpenBy (type: esriFieldTypeString, alias: Dispatch To Open By, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DateDispatchOpen (type: esriFieldTypeDate, alias: Date Dispatch To Open, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ProjectName (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Details (type: esriFieldTypeString, alias: Details, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Cancel (type: esriFieldTypeString, alias: Cancel, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• CancelledBy (type: esriFieldTypeString, alias: Canceled By, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DateCancelled (type: esriFieldTypeDate, alias: Date Canceled, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CancelReason (type: esriFieldTypeString, alias: Cancel Reason, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• OtherSystemId (type: esriFieldTypeString, alias: Other System ID, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• OtherSystemStatus (type: esriFieldTypeString, alias: Other System Status, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• OtherSystemCode (type: esriFieldTypeString, alias: Other System Code, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• OtherSystemDesc (type: esriFieldTypeString, alias: Other System Desc, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• OtherSystemDesc2 (type: esriFieldTypeString, alias: Other System Desc 2, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• ProbAddType (type: esriFieldTypeString, alias: Address Type, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• StreetName (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• ReqCustFieldCatId (type: esriFieldTypeInteger, alias: Custom Category ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Resolution (type: esriFieldTypeString, alias: Resolution, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DomainId (type: esriFieldTypeInteger, alias: Domain, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InitiatedByApp (type: esriFieldTypeString, alias: Init App, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text1 (type: esriFieldTypeString, alias: Text 1, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text2 (type: esriFieldTypeString, alias: Text 2, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text3 (type: esriFieldTypeString, alias: Text 3, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text4 (type: esriFieldTypeString, alias: Text 4, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text5 (type: esriFieldTypeString, alias: Text 5, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text6 (type: esriFieldTypeString, alias: Text 6, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text7 (type: esriFieldTypeString, alias: Text 7, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text8 (type: esriFieldTypeString, alias: Text 8, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text9 (type: esriFieldTypeString, alias: Text 9, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text10 (type: esriFieldTypeString, alias: Text 10, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text11 (type: esriFieldTypeString, alias: Text 11, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text12 (type: esriFieldTypeString, alias: Text 12, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text13 (type: esriFieldTypeString, alias: Text 13, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text14 (type: esriFieldTypeString, alias: Text 14, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text15 (type: esriFieldTypeString, alias: Text 15, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text16 (type: esriFieldTypeString, alias: Text 16, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text17 (type: esriFieldTypeString, alias: Text 17, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text18 (type: esriFieldTypeString, alias: Text 18, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text19 (type: esriFieldTypeString, alias: Text 19, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Text20 (type: esriFieldTypeString, alias: Text 20, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Num1 (type: esriFieldTypeDouble, alias: Num 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Num2 (type: esriFieldTypeDouble, alias: Num 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Num3 (type: esriFieldTypeDouble, alias: Num 3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Num4 (type: esriFieldTypeDouble, alias: Num 4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Num5 (type: esriFieldTypeDouble, alias: Num 5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Date1 (type: esriFieldTypeDate, alias: Date 1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Date2 (type: esriFieldTypeDate, alias: Date 2, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Date3 (type: esriFieldTypeDate, alias: Date 3, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Date4 (type: esriFieldTypeDate, alias: Date 4, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Date5 (type: esriFieldTypeDate, alias: Date 5, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SRX (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SRY (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SRZ (type: esriFieldTypeDouble, alias: Z, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• InspectionId (type: esriFieldTypeInteger, alias: Inspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hour (type: esriFieldTypeInteger, alias: Init. Hour, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DayOfWeek (type: esriFieldTypeString, alias: Init. Day of Week, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DayOfMonth (type: esriFieldTypeInteger, alias: Init. Day of Month, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Month (type: esriFieldTypeInteger, alias: Init. Month, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Year (type: esriFieldTypeInteger, alias: Init. Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumOfCalls (type: esriFieldTypeInteger, alias: Num. Calls, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Facility_Id (type: esriFieldTypeString, alias: Facility Id, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Level_Id (type: esriFieldTypeString, alias: Level Id, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• CALC_SubmitTo (type: esriFieldTypeString, alias: CALC_SubmitTo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CALC_Status (type: esriFieldTypeString, alias: CALC_Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CALC_AverageDaysToClose (type: esriFieldTypeInteger, alias: CALC_AverageDaysToClose, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: OPEN
Name: OPEN
Domains:

Templates:

Name: OPEN
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• CALC_Status: OPEN

---

ID: CLOSED
Name: CLOSED
Domains:

Templates:

Name: CLOSED
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• CALC_Status: CLOSED

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/4/2023 1:53:05 AM

Schema Last Edit Date: 3/4/2023 1:53:05 AM

Data Last Edit Date: 3/4/2023 1:53:05 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat