Name: Water Main Repairs FY2019 -FY2023

Display Field: Street_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 500000

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 3096682.46087338
YMin: 6841228.73683731
XMax: 3150365.9830993
YMax: 6915679.96391881
Spatial Reference: 102738 (2276)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[150,0,145,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"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:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Field1 (type: esriFieldTypeInteger, alias: Field1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WorkOrderId (type: esriFieldTypeInteger, alias: WorkOrderId, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Field3 (type: esriFieldTypeDouble, alias: Field3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Field4 (type: esriFieldTypeDouble, alias: Field4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Entity_Type (type: esriFieldTypeString, alias: Entity Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Priority (type: esriFieldTypeInteger, alias: Priority, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Submit_To (type: esriFieldTypeString, alias: Submit To, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Proj_Start_Date (type: esriFieldTypeString, alias: Proj Start Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Proj_Finish_Date (type: esriFieldTypeString, alias: Proj Finish Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Actual_Start (type: esriFieldTypeString, alias: Actual Start, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Actual_Finish (type: esriFieldTypeString, alias: Actual Finish, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Shop (type: esriFieldTypeString, alias: Shop, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Map_Page (type: esriFieldTypeString, alias: Map Page, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Tile_No (type: esriFieldTypeString, alias: Tile No, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Entity_Group (type: esriFieldTypeString, alias: Entity Group, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Initiated_By (type: esriFieldTypeString, alias: Initiated By, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Date_Initiated (type: esriFieldTypeString, alias: Date Initiated, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Date_Submit_To (type: esriFieldTypeString, alias: Date Submit To, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Completed_By (type: esriFieldTypeString, alias: Completed By, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Supervisor (type: esriFieldTypeString, alias: Supervisor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Update_Map (type: esriFieldTypeString, alias: Update Map, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Legal_Billable (type: esriFieldTypeString, alias: Legal Billable, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Contractor_Billable (type: esriFieldTypeInteger, alias: Contractor Billable, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Project (type: esriFieldTypeString, alias: Project, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Account (type: esriFieldTypeString, alias: Account, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Expense_Type (type: esriFieldTypeString, alias: Expense Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Stage (type: esriFieldTypeString, alias: Stage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Submit_To_Opened_By (type: esriFieldTypeString, alias: Submit To Opened By, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Requested_By (type: esriFieldTypeString, alias: Requested By, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Canceled (type: esriFieldTypeString, alias: Canceled, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Canceled_By (type: esriFieldTypeString, alias: Canceled By, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Cancel_Reason (type: esriFieldTypeString, alias: Cancel Reason, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Date_Canceled (type: esriFieldTypeString, alias: Date Canceled, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Closed_By (type: esriFieldTypeString, alias: Closed By, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Closed_Date (type: esriFieldTypeString, alias: Closed Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Date_Submit_To_Open (type: esriFieldTypeString, alias: Date Submit To Open, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Cycle_Interval_Number (type: esriFieldTypeInteger, alias: Cycle Interval Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cycle_From (type: esriFieldTypeString, alias: Cycle From, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Cycle_Type (type: esriFieldTypeString, alias: Cycle Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Cycle_Interval_Unit (type: esriFieldTypeString, alias: Cycle Interval Unit, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Total_Cost (type: esriFieldTypeDouble, alias: Total Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Labor_Cost (type: esriFieldTypeDouble, alias: Labor Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Material_Cost (type: esriFieldTypeDouble, alias: Material Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Equipment_Cost (type: esriFieldTypeDouble, alias: Equipment Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Permit_Cost (type: esriFieldTypeInteger, alias: Permit Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Parent_WO_ID (type: esriFieldTypeInteger, alias: Parent WO ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Instructions (type: esriFieldTypeString, alias: Instructions, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Inspection (type: esriFieldTypeString, alias: Inspection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Unattached (type: esriFieldTypeString, alias: Unattached, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Contract_WO_ID (type: esriFieldTypeString, alias: Contract WO ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Street_Name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Units_Accomplished (type: esriFieldTypeInteger, alias: Units Accomplished, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Units_Accomp__Description (type: esriFieldTypeString, alias: Units Accomp. Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Request_Ids (type: esriFieldTypeString, alias: Request Ids, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Custom_Category_ID (type: esriFieldTypeInteger, alias: Custom Category ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Resolution (type: esriFieldTypeString, alias: Resolution, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Domain_ (type: esriFieldTypeInteger, alias: Domain, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Is_Reactive (type: esriFieldTypeString, alias: Is Reactive, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Printed_On (type: esriFieldTypeString, alias: Printed On, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Contract_ID (type: esriFieldTypeString, alias: Contract ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Contractor (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Total_Assets (type: esriFieldTypeInteger, alias: Total Assets, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Next_Print_Date (type: esriFieldTypeString, alias: Next Print Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Init__Hour (type: esriFieldTypeInteger, alias: Init. Hour, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Init__Day_of_Week (type: esriFieldTypeString, alias: Init. Day of Week, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Init__Day_of_Month (type: esriFieldTypeInteger, alias: Init. Day of Month, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Init__Month (type: esriFieldTypeInteger, alias: Init. Month, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Init__Year (type: esriFieldTypeInteger, alias: Init. Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Init__App (type: esriFieldTypeString, alias: Init. App, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WO_Sid (type: esriFieldTypeInteger, alias: WO Sid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SR_Problem_Code (type: esriFieldTypeString, alias: SR Problem Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SR_Description (type: esriFieldTypeString, alias: SR Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SR_Initiated_By (type: esriFieldTypeString, alias: SR Initiated By, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SR_Date_Initiated (type: esriFieldTypeString, alias: SR Date Initiated, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SR_Submit_To (type: esriFieldTypeString, alias: SR Submit To, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SR_Date_Submit (type: esriFieldTypeString, alias: SR Date Submit, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SR_Closed_By (type: esriFieldTypeString, alias: SR Closed By, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SR_Date_Closed (type: esriFieldTypeString, alias: SR Date Closed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SR_Priority (type: esriFieldTypeInteger, alias: SR Priority, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SR_Status (type: esriFieldTypeString, alias: SR Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SR_Address (type: esriFieldTypeString, alias: SR Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Facility_Id (type: esriFieldTypeString, alias: Facility Id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Level_Id (type: esriFieldTypeString, alias: Level Id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: Water Main Repairs FY2019 -FY2023
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/16/2023 1:23:53 AM

Schema Last Edit Date: 11/16/2023 1:23:53 AM

Data Last Edit Date: 11/16/2023 1:23:53 AM

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