Layer: LOCATION_maximo_sr

View In: Map Viewer

Name: LOCATION_maximo_sr_centroid

Display Field: ROWSTAMP

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This layer depicts the locations of Service Requests in the City’s computerized maintenance management system, Maximo. The layer contains attributes about the issue reported, ticket assignment, status, and dates. It is intended to facilitate users of the Maximo application in conducting queries, analysis, and map generation in ArcGIS. The layer is generated by reading the list of service requests in the system and then obtaining a location from the GIS features each work order is associated with inside the Maximo application. When a service request is associated with a line or polygon feature, the location is the centroid of that feature. When a service request is associated with more than one feature, the location is derived from the first feature it finds in the following order (Work Order specific feature class, Asset, Location, Service Address). This layer does not contain a record for service requests that are not associated with a GIS feature in Maximo.

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[75,158,82,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"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:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ROWSTAMP (type: esriFieldTypeString, alias: ROWSTAMP, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
MXTICKETID (type: esriFieldTypeString, alias: MXTICKETID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
MXCLASS (type: esriFieldTypeString, alias: MXCLASS, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
MXORGID (type: esriFieldTypeString, alias: MXORGID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DESCRIPTION (type: esriFieldTypeString, alias: DESCRIPTION, SQL Type: sqlTypeOther, length: 280, nullable: true, editable: true)
STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
WORKGROUP (type: esriFieldTypeString, alias: WORKGROUP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
INTERNALPRIORITY (type: esriFieldTypeDouble, alias: INTERNALPRIORITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
REPORTDATE (type: esriFieldTypeDate, alias: REPORTDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUPERVISOR (type: esriFieldTypeString, alias: SUPERVISOR, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
REPORTEDBY (type: esriFieldTypeString, alias: REPORTEDBY, SQL Type: sqlTypeOther, length: 62, nullable: true, editable: true)
REPORTEDBYPHONE (type: esriFieldTypeString, alias: REPORTEDBYPHONE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
MXSITEID (type: esriFieldTypeString, alias: MXSITEID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PLUSSFEATURECLASS (type: esriFieldTypeString, alias: PLUSSFEATURECLASS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
MXASSETNUM (type: esriFieldTypeString, alias: MXASSETNUM, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
ASSET_DESCRIPTION (type: esriFieldTypeString, alias: ASSET_DESCRIPTION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
MXLOCATION (type: esriFieldTypeString, alias: MXLOCATION, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
LOCATION_DESCRIPTION (type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
MXADDRESSCODE (type: esriFieldTypeString, alias: MXADDRESSCODE, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
ADDRESS_DESCRIPTION (type: esriFieldTypeString, alias: ADDRESS_DESCRIPTION, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
CSR311NUMBER (type: esriFieldTypeString, alias: CSR311NUMBER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
HISTORYFLAG (type: esriFieldTypeSmallInteger, alias: HISTORYFLAG, SQL Type: sqlTypeOther, nullable: true, editable: true)
CHANGEBY (type: esriFieldTypeString, alias: CHANGEBY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
CHANGEDATE (type: esriFieldTypeDate, alias: CHANGEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CLASSIFICATIONID (type: esriFieldTypeString, alias: CLASSIFICATIONID, SQL Type: sqlTypeOther, length: 192, nullable: true, editable: true)
POINT_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/18/2025 6:50:43 AM

Schema Last Edit Date: 7/18/2025 6:50:43 AM

Data Last Edit Date: 7/18/2025 6:50:43 AM

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

Layer: LOCATION_maximo_sr_centroid (ID:0)