Name: WM_POTHOLESTATUS
Display Field: WO_STATUS
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: 1248138.51132287
YMin: 183050.200751483
XMax: 1293151.14509699
YMax: 271525.414794102
Spatial Reference: 2926 (2926)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[47,147,116,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: true
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- WOKEY (type: esriFieldTypeInteger, alias: WOKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WO_STATUS (type: esriFieldTypeString, alias: WO_STATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- RESULTCD (type: esriFieldTypeString, alias: RESULTCD, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- RESULTDESC (type: esriFieldTypeString, alias: RESULTDESC, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
- LAST90DAYRPRD (type: esriFieldTypeDouble, alias: LAST90DAYRPRD, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BYDUEDT (type: esriFieldTypeDouble, alias: BYDUEDT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NOTPOTHOLE (type: esriFieldTypeString, alias: NOTPOTHOLE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- TOTALRPRD (type: esriFieldTypeDouble, alias: TOTALRPRD, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CURRENT_QTR (type: esriFieldTypeDouble, alias: CURRENT_QTR, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PREVIOUS_1QTR (type: esriFieldTypeDouble, alias: PREVIOUS_1QTR, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PREVIOUS_2QTR (type: esriFieldTypeDouble, alias: PREVIOUS_2QTR, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PREVIOUS_3QTR (type: esriFieldTypeDouble, alias: PREVIOUS_3QTR, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PREVIOUS_4QTR (type: esriFieldTypeDouble, alias: PREVIOUS_4QTR, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SOURCECD (type: esriFieldTypeString, alias: SOURCECD, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- MILESTONECD (type: esriFieldTypeString, alias: MILESTONECD, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- PROBLEMCD (type: esriFieldTypeString, alias: PROBLEMCD, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PRIORITYCD (type: esriFieldTypeString, alias: PRIORITYCD, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ASSIGNED (type: esriFieldTypeString, alias: ASSIGNED, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- ASSIGNEDDIV (type: esriFieldTypeString, alias: ASSIGNEDDIV, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
- ASSIGNEDLO (type: esriFieldTypeString, alias: ASSIGNEDLO, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- CREWCHIEF (type: esriFieldTypeString, alias: CREWCHIEF, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- CREWCHIEFDIV (type: esriFieldTypeString, alias: CREWCHIEFDIV, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
- INITDT (type: esriFieldTypeDate, alias: INITDT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- SCHEDSTARTDT (type: esriFieldTypeDate, alias: SCHEDSTARTDT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- DUEDT (type: esriFieldTypeDate, alias: DUEDT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- FLDSTARTDT (type: esriFieldTypeDate, alias: FLDSTARTDT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- FLDENDDT (type: esriFieldTypeDate, alias: FLDENDDT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- COMPDT (type: esriFieldTypeDate, alias: COMPDT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CITYSECTORCD (type: esriFieldTypeString, alias: CITYSECTORCD, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- NEIGHCD (type: esriFieldTypeString, alias: NEIGHCD, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ADDRDESC (type: esriFieldTypeString, alias: ADDRDESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ADDRTYPE (type: esriFieldTypeString, alias: ADDRTYPE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- ADDRKEY (type: esriFieldTypeDouble, alias: ADDRKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COMPKEY (type: esriFieldTypeDouble, alias: COMPKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAPLOCKEY (type: esriFieldTypeInteger, alias: MAPLOCKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SEGKEY (type: esriFieldTypeDouble, alias: SEGKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DISTANCE (type: esriFieldTypeDouble, alias: DISTANCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WORKORDERDETKEY (type: esriFieldTypeDouble, alias: WORKORDERDETKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WO_ADDBY (type: esriFieldTypeString, alias: WO_ADDBY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- WO_MODBY (type: esriFieldTypeString, alias: WO_MODBY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- WORKACTIVITYCD (type: esriFieldTypeString, alias: WORKACTIVITYCD, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- WORKACTIVITYDESC (type: esriFieldTypeString, alias: WORKACTIVITYDESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PRIMARYDISTRICTCD (type: esriFieldTypeString, alias: PRIMARYDISTRICTCD, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- SECONDARYDISTRICTCD (type: esriFieldTypeString, alias: SECONDARYDISTRICTCD, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PMSURFACE1 (type: esriFieldTypeString, alias: PMSURFACE1, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PMSURFDATE1 (type: esriFieldTypeDate, alias: PMSURFDATE1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- PVMTCONDINDX1 (type: esriFieldTypeDouble, alias: PVMTCONDINDX1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PMSURFACE2 (type: esriFieldTypeString, alias: PMSURFACE2, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PMSURFDATE2 (type: esriFieldTypeDate, alias: PMSURFDATE2, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- PVMTCONDINDX2 (type: esriFieldTypeDouble, alias: PVMTCONDINDX2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ARTCLASS (type: esriFieldTypeInteger, alias: ARTCLASS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SPEEDLIMIT (type: esriFieldTypeInteger, alias: SPEEDLIMIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SGNDBKROUTE (type: esriFieldTypeString, alias: SGNDBKROUTE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- SE_ANNO_CAD_DATA (type: esriFieldTypeBlob, alias: SE_ANNO_CAD_DATA, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: WM_POTHOLESTATUS
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/21/2025 12:07:34 PM
Schema Last Edit Date: 7/21/2025 12:07:34 PM
Data Last Edit Date: 7/21/2025 12:07:34 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat