Name: Service_Request_v411

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Service Request - March Edition 2023","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• House_Number (type: esriFieldTypeString, alias: House Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Unit (type: esriFieldTypeString, alias: Unit (A, B, Suite, Shop), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Township (type: esriFieldTypeString, alias: Township, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Initial_Call (type: esriFieldTypeDate, alias: Initial Call, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Customer_Name (type: esriFieldTypeString, alias: Customer / Project Description, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PhoneNumber1 (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• Comments1 (type: esriFieldTypeString, alias: Customer Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Assignment_Status (type: esriFieldTypeString, alias: Choose a status for your assignment:, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Assigned: Assigned], [Canceled: Canceled], [Completed: Completed], ... 3 more ...)
• Priority (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [STD: Standard], [PRIO: Priority])
• Gas_Required_Date (type: esriFieldTypeDate, alias: Gas Required Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Office (type: esriFieldTypeString, alias: Office, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Strasburg_Office: Strasburg Office], [Mentor_Office: Mentor Office], [Lancaster_Office: Lancaster Office])
• Department (type: esriFieldTypeString, alias: Choose a department:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Work_Required (type: esriFieldTypeString, alias: Choose a type of work:, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• office_worker (type: esriFieldTypeString, alias: Assign people to work on tasks, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PaperworkATTACH (type: esriFieldTypeString, alias: Please provide your project Egnyte Link., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• System_Number (type: esriFieldTypeString, alias: System Number, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [NEO_9: NEO_9 New Bedford], [NEO_10: NEO_10 West Wooster], [NEO_12: NEO_12 Summitville Tile], ... 309 more ...)
• MAOP (type: esriFieldTypeString, alias: MAOP System Pressure, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: 0], [0.5: 0.5], [5: 5], ... 25 more ...)
• MLXWORKORDERID (type: esriFieldTypeString, alias: Existing MLX Tie-in WO, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Tie_in_Pipe_Size (type: esriFieldTypeString, alias: Tie-in Size, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: 0], [0.25: 0.25], [0.5: 0.5], ... 10 more ...)
• Tie_in_Pipe_Material (type: esriFieldTypeString, alias: Tie-in Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bare Steel: Bare Steel], [Coated Steel: Coated Steel], [Plastic PE: Plastic PE], ... 8 more ...)
• newbusinesstype (type: esriFieldTypeString, alias: How will you use this new business request?, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true, Coded Values: [Proposed_Project: Engineering MLX Request], [No_MLX: Infill Customer Request], [MLX_Required: Customer Waiting on MLX Extension])
• Contact_Made (type: esriFieldTypeDate, alias: Provide a date for the sales callback:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Spoken_to_Customer (type: esriFieldTypeString, alias: Did you speak directly with the customer?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Callback_Options (type: esriFieldTypeString, alias: Callback_Options, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Sales_Notes (type: esriFieldTypeString, alias: Provide additional callback information., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Schd_Site_Visit (type: esriFieldTypeDate, alias: Schedule a site visit appointment with customer:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Distance_for_MLX (type: esriFieldTypeString, alias: Distance for Existing MLX Tie-in, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Building_Status (type: esriFieldTypeString, alias: Building Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Existing: Existing], [Not Started: Not Started], [Foundation: Foundation], ... 4 more ...)
• Well_Gas (type: esriFieldTypeString, alias: 3-Way Valve / Well Gas, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Questionaire_Engineering_Services (type: esriFieldTypeString, alias: Does this require engineering?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• To_Engineering (type: esriFieldTypeDate, alias: Assign work to engineering:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Project_Designed (type: esriFieldTypeDate, alias: Project Designed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Design_Specifications (type: esriFieldTypeString, alias: Design Specifications, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• EstimatedCost (type: esriFieldTypeInteger, alias: Estimated Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROPOSED_2_INCH (type: esriFieldTypeInteger, alias: 2" Pipe, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROPOSED_4_INCH (type: esriFieldTypeInteger, alias: 4" Pipe, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROPOSED_6_INCH (type: esriFieldTypeInteger, alias: 6" Pipe, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Questionaire_MLXCIAC (type: esriFieldTypeString, alias: Requires a pre-installation payment?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Questionaire_MLXCIAC_Cost (type: esriFieldTypeDouble, alias: Provide a CIAC Cost $0.00, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Questionaire_MLXCIAC_Prepaid (type: esriFieldTypeString, alias: Has the CIAC been Pre-paid?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Tax_Code (type: esriFieldTypeString, alias: Tax Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GL_Code (type: esriFieldTypeString, alias: GL Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• fiscalyr1 (type: esriFieldTypeDate, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Questionaire_preliminary_Approval (type: esriFieldTypeString, alias: Requires Preliminary Approval?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Questionaire_CIAC (type: esriFieldTypeString, alias: Requires a pre-installation payment, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CIAC_Cost (type: esriFieldTypeDouble, alias: Provide a CIAC Cost $0.00, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CIAC_Prepaid (type: esriFieldTypeString, alias: CIAC Pre-paid?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Built_Manifold (type: esriFieldTypeString, alias: Is a manifold build or manifold pre-order requried?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Questionaire_Require_Permit (type: esriFieldTypeString, alias: Do you need a permit?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Permit_Sent (type: esriFieldTypeDate, alias: Permit Sent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Permit_Recvd (type: esriFieldTypeDate, alias: Permit Received, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Questionaire_Require_OUPS (type: esriFieldTypeString, alias: Does OUPS need contacted?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• OUPS_Called (type: esriFieldTypeDate, alias: OUPS Called, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Questionaire_ROW (type: esriFieldTypeString, alias: Do you need a private right-of-way, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ROW_Sent (type: esriFieldTypeDate, alias: ROW Sent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ROW_Recvd (type: esriFieldTypeDate, alias: ROW Received, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Private_right_of_way (type: esriFieldTypeString, alias: Private_right_of_way, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Meter_Rate_Base (type: esriFieldTypeString, alias: Meter Rate Base, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [SGS: SGS], [GS1: GS1], [GS2: GS2], ... 2 more ...)
• PA_Sent (type: esriFieldTypeDate, alias: PA Sent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PA_Recvd (type: esriFieldTypeDate, alias: PA Received, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• App_Sent_to_Cust (type: esriFieldTypeDate, alias: Sent Customer Application, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Cust_App_Recvd (type: esriFieldTypeDate, alias: Received Customer Application, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• App_Approved (type: esriFieldTypeDate, alias: Final Approval, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• App_to_Processing (type: esriFieldTypeDate, alias: CSR Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CIAC_Received (type: esriFieldTypeString, alias: CIAC Payment Received?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• WORKORDERID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• InstallationID (type: esriFieldTypeString, alias: InstallationID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• To_Operations (type: esriFieldTypeDate, alias: Operations Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• To_Construction (type: esriFieldTypeDate, alias: Construction Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Ordered_Meterset (type: esriFieldTypeDate, alias: Ordered Meter Set, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MS_Built_Recvd (type: esriFieldTypeDate, alias: MS Built / Received, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MS_to_Construction (type: esriFieldTypeString, alias: MS to Construction Department? (Yes / No), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• To_Construction1 (type: esriFieldTypeDate, alias: To Construction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LS_SS (type: esriFieldTypeString, alias: LS / SS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [LS: LS], [SS: SS])
• Bore_Required (type: esriFieldTypeString, alias: Bore Required, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Proposed_Length (type: esriFieldTypeInteger, alias: Estimated Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Proposed_Size (type: esriFieldTypeDouble, alias: Proposed Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Installer (type: esriFieldTypeString, alias: Installer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Northeast Ohio Natural Gas: Northeast Ohio Natural Gas], [Buckeye Pipeline: Buckeye Pipeline], [Yoder Trenching: Yoder Trenching], ... 7 more ...)
• SLO_Mailed_Pickup (type: esriFieldTypeDate, alias: SLO_Mailed_Pickup, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Material_Pickup (type: esriFieldTypeDate, alias: Material_Pickup, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Schd_SL_Start (type: esriFieldTypeDate, alias: Scheduled Start Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SL_Start_Date (type: esriFieldTypeDate, alias: Actual Start Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Construction_Notes (type: esriFieldTypeString, alias: Construction Notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• SL_Finished_Date (type: esriFieldTypeDate, alias: Construction Finished Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Paperwork_QA (type: esriFieldTypeString, alias: As-built QA, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• QA_Correction_Sent (type: esriFieldTypeDate, alias: Sent As-built Revision, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• QA_Correction_Complete (type: esriFieldTypeString, alias: Corrected As-built, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• QC_Date (type: esriFieldTypeDate, alias: Review As-built on, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Require_UTI_Services (type: esriFieldTypeString, alias: Send to UTI, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• To_UTI (type: esriFieldTypeDate, alias: Sent on, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Mapped_Questionnaire (type: esriFieldTypeString, alias: Requesting an as-built drawing in mapping, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• GPS_Questionnaire (type: esriFieldTypeString, alias: Request a field survey, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Mapped_Date (type: esriFieldTypeDate, alias: Mapped Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GPS_Completed (type: esriFieldTypeDate, alias: GPS Completed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• mapped_edited_user (type: esriFieldTypeString, alias: Mapped edited user, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• mapped_edited_date (type: esriFieldTypeDate, alias: mapped edited date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gps_edited_user (type: esriFieldTypeString, alias: gps edited user, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• gps_edited_date (type: esriFieldTypeDate, alias: gps edited date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GIS_QC (type: esriFieldTypeString, alias: GIS Final Review, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/30/2023 6:34:07 AM

Schema Last Edit Date: 8/30/2023 6:34:07 AM

Data Last Edit Date: 8/30/2023 6:34:07 AM

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