Name: In Progress

Display Field: EMPLOYEENAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 250000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -773980.1678
YMin: 3211885.1619
XMax: 3322307.9816
YMax: 5767216.7089
Spatial Reference: 26913  (26913)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• EMPLOYEENAME ( type: esriFieldTypeString, alias: Employee Name, length: 100 )
• EMPLOYEE_BRANCH ( type: esriFieldTypeString, alias: Employee Branch, length: 255 , Coded Values: [Engineering Design Solutions: Engineering Design Solutions] , [Environmental Services: Environmental Services] , [Facilities Management Services: Facilities Management Services] , ...14 more... )
• EMPLOYEEPHONENUMBER ( type: esriFieldTypeString, alias: Employee Phone Number, length: 20 )
• EMPLOYEE_EMAIL ( type: esriFieldTypeString, alias: Employee Email, length: 25 )
• ADDRESS ( type: esriFieldTypeString, alias: Address for Locate Request, length: 100 )
• ADDITIONALINFO ( type: esriFieldTypeString, alias: Additional Information, length: 500 )
• WORKORDER ( type: esriFieldTypeString, alias: Workorder Number, length: 7 )
• WORKDETAILS ( type: esriFieldTypeString, alias: Work Details, length: 200 , Coded Values: [Regular Ticket (up to 1000 sq meters): Regular Ticket (up to 1000 sq meters)] , [Project (1000 sq meters to 60, 000 sq meters): Project (1000 sq meters to 60, 000 sq meters)] , [Large Project (60,000 sq meters to 800,000 sq meters): Large Project (60,000 sq meters to 800,000 sq meters)] , ...4 more... )
• PREVIOUSTICKETNUMBER ( type: esriFieldTypeString, alias: Previous Ticket Number, length: 25 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• WORKTYPE ( type: esriFieldTypeString, alias: Type of Work, length: 25 , Coded Values: [Groundwork: Groundwork] , [Landscaping: Landscaping] , [Poles/Holes: Poles/Holes] , ...3 more... )
• ACTIVITY ( type: esriFieldTypeString, alias: Activity, length: 50 , Coded Values: [Catch Basin: Catch Basin] , [Hydrant: Hydrant] , [Irrigation: Irrigation] , ...16 more... )
• EXCAVATION_METHOD ( type: esriFieldTypeString, alias: Excavation Method, length: 50 , Coded Values: [Hydro Vacuum: Hydro Vacuum] , [None: None] , [Saw Cut: Saw Cut] , ...4 more... )
• DEPTH_SIZE ( type: esriFieldTypeString, alias: Depth Size, length: 50 , Coded Values: [Less than 1 m: Less than 1 m] , [1 m to 3 m: 1 m to 3 m] , [Greater than 3 m: Greater than 3 m] )
• WORKING_ON ( type: esriFieldTypeString, alias: Working On, length: 50 , Coded Values: [Public Property Only: Public Property Only] , [Public and Private Property: Public and Private Property] )
• DIG_ALLEY ( type: esriFieldTypeString, alias: Dig in Alley, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_SITEMARKED ( type: esriFieldTypeString, alias: Is site/work area marked or staked?, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_CONTRACTTOMEET ( type: esriFieldTypeString, alias: Requesting locators meet on site?, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• EXP_START_DATE ( type: esriFieldTypeDate, alias: Expected Start Date, length: 8 )
• SR_FOR_FACILITIES ( type: esriFieldTypeString, alias: Service Request required for Facilities, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• SR_NUM_FACILITIES ( type: esriFieldTypeInteger, alias: SR Number for Facilities )
• SR_FOR_IRRIGATION ( type: esriFieldTypeString, alias: Service Request required for Irrigation (Parks), length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• SR_NUM_IRRIGATION ( type: esriFieldTypeInteger, alias: SR Number for Irrigation (Parks) )
• CREATE_DATE ( type: esriFieldTypeDate, alias: Request Created On, length: 8 )
• SASK_1ST_CALL ( type: esriFieldTypeString, alias: Sask 1st Confirmation Number, length: 50 )
• SASKPOWER_STATUS ( type: esriFieldTypeString, alias: SaskPower Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• SASKPOWER_COMPLETEDATE ( type: esriFieldTypeDate, alias: SaskPower Completed On, length: 8 )
• SASKENERGY_STATUS ( type: esriFieldTypeString, alias: SaskEnergy Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• SASKENERGY_COMPLETEDATE ( type: esriFieldTypeDate, alias: SaskEnergy Completed On, length: 8 )
• TRANSCANPIPE_STATUS ( type: esriFieldTypeString, alias: TransCanada Pipeline Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• TRANSCANPIPE_COMPLETEDATE ( type: esriFieldTypeDate, alias: TransCanada Pipeline Completed On, length: 8 )
• SASKTEL_STATUS ( type: esriFieldTypeString, alias: SaskTel Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• SASKTEL_COMPLETEDATE ( type: esriFieldTypeDate, alias: SaskTel Completed On, length: 8 )
• ACCESS_STATUS ( type: esriFieldTypeString, alias: Access Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• ACCESS_COMPLETEDATE ( type: esriFieldTypeDate, alias: Access Completed On, length: 8 )
• BHTEL_STATUS ( type: esriFieldTypeString, alias: BHTel Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• BHTEL_COMPLETEDATE ( type: esriFieldTypeDate, alias: BHTel Completed On, length: 8 )
• FACILITIES_STATUS ( type: esriFieldTypeString, alias: COR Facilities Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• FACILITIES_COMPLETEDATE ( type: esriFieldTypeDate, alias: COR Facilities Completed On, length: 8 )
• TRAFFIC_STATUS ( type: esriFieldTypeString, alias: COR Traffic Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• TRAFFIC_COMPLETEDATE ( type: esriFieldTypeDate, alias: COR Traffic Completed On, length: 8 )
• PARKS_STATUS ( type: esriFieldTypeString, alias: COR Parks Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• PARKS_COMPLETEDATE ( type: esriFieldTypeDate, alias: COR Parks Completed On, length: 8 )
• DEVSERV_STATUS ( type: esriFieldTypeString, alias: COR Infra Delivery Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• DEVSERV_COMPLETEDATE ( type: esriFieldTypeDate, alias: COR Infra Delivery Completed On, length: 8 )
• ENBRIDGE_STATUS ( type: esriFieldTypeString, alias: Enbridge Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• ENBRIDGE_COMPLETEDATE ( type: esriFieldTypeDate, alias: Enbridge Completed On, length: 8 )
• PLAINSMID_STATUS ( type: esriFieldTypeString, alias: Plains Midstream Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• PLAINSMID_COMPLETEDATE ( type: esriFieldTypeDate, alias: Plains Midstream Completed On, length: 8 )
• ROGERS_STATUS ( type: esriFieldTypeString, alias: Rogers Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• ROGERS_COMPLETEDATE ( type: esriFieldTypeDate, alias: Rogers Completed On, length: 8 )
• TELUS_STATUS ( type: esriFieldTypeString, alias: Telus Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• TELUS_COMPLETEDATE ( type: esriFieldTypeDate, alias: Telus Completed On, length: 8 )
• UOFR_STATUS ( type: esriFieldTypeString, alias: U of R Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• UOFR_COMPLETEDATE ( type: esriFieldTypeDate, alias: U of R Completed On, length: 8 )
• ZAYO_STATUS ( type: esriFieldTypeString, alias: Zayo Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• ZAYO_COMPLETEDATE ( type: esriFieldTypeDate, alias: Zayo Completed On, length: 8 )
• OTHER_UTIL_STATUS ( type: esriFieldTypeString, alias: Other Utility Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• OTHER_UTIL_COMPLETEDATE ( type: esriFieldTypeDate, alias: Other Utility Completed On, length: 8 )
• SASKENERGY_PERMIT_REQ ( type: esriFieldTypeString, alias: SaskEnergy Permit Required, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• SASKENERGY_PERMIT_NUMBER ( type: esriFieldTypeString, alias: SaskEnergy Permit Number, length: 25 )
• HIGH_VOLTAGE_PRESSURE ( type: esriFieldTypeString, alias: High Voltage/High Pressure, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• UTILITY_HIT ( type: esriFieldTypeString, alias: Utility Hit, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• ALL_LOCATES_COMPLETEDATE ( type: esriFieldTypeDate, alias: Locate Request Completed On, length: 8 )
• LOCATE_EXPIREDATE ( type: esriFieldTypeDate, alias: Locate Expires On, length: 8 )
• SR_EMAIL_SENT_CLIENT ( type: esriFieldTypeString, alias: OSR Email sent to Client, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• SR_INITIALS ( type: esriFieldTypeString, alias: OSR Initials, length: 3 )
• LOCATE_PROGRESS_STATUS ( type: esriFieldTypeString, alias: Dispatch Comments, length: 500 )
• CUTSIDNUM ( type: esriFieldTypeDouble, alias: Request Created On )
• RESUBMISSION_HIST ( type: esriFieldTypeString, alias: RESUBMISSION_HIST, length: 50 )
• SASK_1ST_CALL_DATE ( type: esriFieldTypeDate, alias: Sask 1st Confirmation Date, length: 8 )
• NEW_LOCATE_EMAIL ( type: esriFieldTypeString, alias: New Locate Email, length: 5 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• RP_INSP_GUID ( type: esriFieldTypeGUID, alias: RP_INSP_GUID, length: 38 )
• PUBLIC_PROPERTY_DETAILS ( type: esriFieldTypeString, alias: Public Property Details, length: 255 , Coded Values: [Road/Sidewalk: Road/Sidewalk] , [Green Space: Green Space] , [Public Building: Public Building] )
• LOCATE_AREA_REQUIRED ( type: esriFieldTypeString, alias: Required Locate Area with respect to Property, length: 255 , Coded Values: [in front of: in front of] , [behind: behind] , [beside: beside] )
• CROSS_STREET_INT ( type: esriFieldTypeString, alias: Nearest Cross Street or Intersection, length: 255 )

Relationships:

• LR_RESUB_HIST (2) -- Related To: LOCATE_RESUBMIT_HISTORY (8)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata