Name: DWQ_Locate_Request

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 1128

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:

{"renderer":{"symbol":{"color":[0,178,255,48],"outline":{"color":[0,178,255,255],"style":"esriSLSSolid","type":"esriSLS","width":2},"style":"esriSFSSolid","type":"esriSFS"},"type":"simple","label":"DWQ Locate Request"},"transparency":0}

HasZ: false

HasM: false

Time Info:

Start Time Field: time_started
End Time Field: time_submitted
Track ID Field: null
Time Extent
[6/15/2021 12:30:14 PM UTC, 7/21/2021 11:33:54 AM UTC]

Time Reference: UTC
Time Interval: 0
Time Interval Units: esriTimeUnitsMilliseconds
Has Live Data: false
Export Options:

Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

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: 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)
• ticket_number (type: esriFieldTypeString, alias: Ticket Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ticket_date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ticket_status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [submitted: Submitted], [assigned: Assigned], [in_process: In Process], ... 6 more ...)
• location_add (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• location_detail (type: esriFieldTypeString, alias: Location Detail, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• req_type (type: esriFieldTypeString, alias: Request Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [normal: Normal locate request], [emr: Emergency locate request], [design: Design information request], ... 5 more ...)
• req_prev_ticket (type: esriFieldTypeString, alias: Previous Ticket Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• req_found_feature (type: esriFieldTypeString, alias: Unmarked Facility, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [pipe: Pipe], [manhole: Manhole], [other: Other])
• work_type (type: esriFieldTypeString, alias: Work type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• work_who (type: esriFieldTypeString, alias: Done for, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• work_date (type: esriFieldTypeDate, alias: Start date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• work_time (type: esriFieldTypeString, alias: Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• work_priority_level (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [HIGH: High], [NORM: Normal], [LOW: Low])
• work_ug_oh (type: esriFieldTypeString, alias: Underground/Overhead, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [U: Underground], [O: Overhead], [B: Both])
• work_blast (type: esriFieldTypeString, alias: Blasting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• work_emr (type: esriFieldTypeString, alias: Emergency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• work_duration (type: esriFieldTypeInteger, alias: Duration (days), SQL Type: sqlTypeOther, nullable: true, editable: true)
• work_depth (type: esriFieldTypeInteger, alias: Depth (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• work_notice (type: esriFieldTypeString, alias: Hours notice, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• req_CoName (type: esriFieldTypeString, alias: Company Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• req_CoType (type: esriFieldTypeString, alias: Company Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• req_add (type: esriFieldTypeString, alias: Company Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• req_phone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• req_city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• req_state (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AL: Alabama], [AK: Alaska], [AZ: Arizona], ... 48 more ...)
• req_zip (type: esriFieldTypeInteger, alias: Zip, SQL Type: sqlTypeOther, nullable: true, editable: true)
• req_email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• on_name (type: esriFieldTypeString, alias: Project Site Contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• on_phone (type: esriFieldTypeString, alias: Contact Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• time_started (type: esriFieldTypeDate, alias: time_started, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• time_submitted (type: esriFieldTypeDate, alias: time_submitted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• project_watershed (type: esriFieldTypeString, alias: Watershed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [BC: Boone Creek], [CR: Cane Run], [EH: East Hickman], ... 6 more ...)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• 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)
• req_Name (type: esriFieldTypeString, alias: Requestor Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• work_reason (type: esriFieldTypeString, alias: Emergency Justification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• final_dispo (type: esriFieldTypeString, alias: Final Outcome, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [submitted: Submitted], [assigned: Assigned], [in_process: In Process], ... 3 more ...)
• due_date (type: esriFieldTypeDate, alias: Date Due, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pend_reason (type: esriFieldTypeString, alias: Pending Reason, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [large_proj: Large Project], [more_info: More Information Needed], [other: Other])
• work_depth_reason (type: esriFieldTypeString, alias: Reason for 10+ ft depth, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

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

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/23/2021 11:09:36 AM

Schema Last Edit Date: 7/23/2021 11:09:36 AM

Data Last Edit Date: 7/23/2021 11:09:36 AM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat