Name: Contractor Work Orders

Display Field: STREET_DISPLAY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: -124805072.830103
YMin: -81922741.1045354
XMax: 129398239.496769
YMax: 51189707.7572832
Spatial Reference: 102739 (2277)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[79,104,158,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• WORK_ORDER_ID (type: esriFieldTypeString, alias: WORK ORDER ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CREATED_BY (type: esriFieldTypeString, alias: CREATED BY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CREATED_DATE (type: esriFieldTypeDate, alias: CREATED DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MODIFIED_DATE (type: esriFieldTypeDate, alias: MODIFIED DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PARENT_WO (type: esriFieldTypeString, alias: PARENT WO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Parent_WO_FIELD (type: esriFieldTypeString, alias: PARENT WO - FIELD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WORK_AUTHORIZATION_NUMBER (type: esriFieldTypeInteger, alias: WORK AUTHORIZATION NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSIGNED_CONTRACTOR (type: esriFieldTypeString, alias: ASSIGNED CONTRACTOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ASSIGNED_TO (type: esriFieldTypeString, alias: ASSIGNED TO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GIS_ID (type: esriFieldTypeString, alias: GIS ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FOLLOW_UP_INSTRUCTIONS (type: esriFieldTypeString, alias: FOLLOW-UP INSTRUCTIONS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FROM_STREET (type: esriFieldTypeString, alias: FROM STREET, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TO_STREET (type: esriFieldTypeString, alias: TO STREET, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STREET_DISPLAY_NAME (type: esriFieldTypeString, alias: STREET DISPLAY NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AREA (type: esriFieldTypeString, alias: AREA, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CENTERLINE_MILES (type: esriFieldTypeDouble, alias: CENTERLINE MILES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WORK_ORDER_STATUS (type: esriFieldTypeString, alias: WORK ORDER STATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ATD_ISSUED_DATE (type: esriFieldTypeDate, alias: ATD ISSUED DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONTRACTOR_SUBMITTED_DATE (type: esriFieldTypeDate, alias: CONTRACTOR SUBMITTED DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONTRACTOR_SUBMITTED_BY (type: esriFieldTypeString, alias: CONTRACTOR SUBMITTED BY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COUNT_ATTACHMENTS (type: esriFieldTypeInteger, alias: COUNT ATTACHMENTS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNT_COMMENTS (type: esriFieldTypeInteger, alias: COUNT COMMENTS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNT_INSPECTIONS (type: esriFieldTypeInteger, alias: COUNT INSPECTIONS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNT_WORK_LOG (type: esriFieldTypeInteger, alias: COUNT WORK LOG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WORK_STATUS (type: esriFieldTypeString, alias: WORK STATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PRIMARY_PARENT_WO (type: esriFieldTypeString, alias: PRIMARY PARENT WO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RECORDID (type: esriFieldTypeString, alias: RECORD ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GIS_QA (type: esriFieldTypeString, alias: GIS QA, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WORK_GROUPS (type: esriFieldTypeString, alias: WORK GROUPS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• INSTRUCTION_COMMENTS (type: esriFieldTypeString, alias: INSTRUCTION COMMENTS, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• INSTRUCTIONS_COMMENTS (type: esriFieldTypeString, alias: INSTRUCTIONS COMMENTS, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• STREET_SEGMENT_IDS (type: esriFieldTypeString, alias: STREET SEGMENT IDS, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• id (type: esriFieldTypeString, alias: ID, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)

Templates:

Name: Contractor Work Orders
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/18/2025 7:05:41 AM

Schema Last Edit Date: 7/1/2025 7:07:09 AM

Data Last Edit Date: 7/18/2025 7:05:41 AM

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