Layers:

Layer: Locate Request Form (0)

Name: Locate Request Form

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_FOR_IRRIGATION ( type: esriFieldTypeString, alias: Service Request required for Irrigation (Parks), length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• SASKPOWER_STATUS ( type: esriFieldTypeString, alias: SaskPower Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• SASKENERGY_STATUS ( type: esriFieldTypeString, alias: SaskEnergy Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• TRANSCANPIPE_STATUS ( type: esriFieldTypeString, alias: TransCanada Pipeline Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• SASKTEL_STATUS ( type: esriFieldTypeString, alias: SaskTel Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• ACCESS_STATUS ( type: esriFieldTypeString, alias: Access Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• BHTEL_STATUS ( type: esriFieldTypeString, alias: BHTel Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• FACILITIES_STATUS ( type: esriFieldTypeString, alias: COR Facilities Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• TRAFFIC_STATUS ( type: esriFieldTypeString, alias: COR Traffic Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• PARKS_STATUS ( type: esriFieldTypeString, alias: COR Parks Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• DEVSERV_STATUS ( type: esriFieldTypeString, alias: COR Infra Delivery Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• ENBRIDGE_STATUS ( type: esriFieldTypeString, alias: Enbridge Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• PLAINSMID_STATUS ( type: esriFieldTypeString, alias: Plains Midstream Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• ROGERS_STATUS ( type: esriFieldTypeString, alias: Rogers Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• TELUS_STATUS ( type: esriFieldTypeString, alias: Telus Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• UOFR_STATUS ( type: esriFieldTypeString, alias: U of R Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• ZAYO_STATUS ( type: esriFieldTypeString, alias: Zayo Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• 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 (0) -- Related To: LOCATE_RESUBMIT_HISTORY (8)

Layer: New (1)

Name: New

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: CUTSIDNUM )
• 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 (1) -- Related To: LOCATE_RESUBMIT_HISTORY (8)

Layer: In Progress (2)

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)

Layer: Completed (3)

Name: Completed

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: CUTSIDNUM )
• 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 (3) -- Related To: LOCATE_RESUBMIT_HISTORY (8)

Layer: Expired (4)

Name: Expired

Display Field: EMPLOYEENAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: CUTSIDNUM )
• 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 (4) -- Related To: LOCATE_RESUBMIT_HISTORY (8)

Layer: Invalid Date (5)

Name: Invalid Date

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: CUTSIDNUM )
• 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 (5) -- Related To: LOCATE_RESUBMIT_HISTORY (8)

Layer: Historic (6)

Name: Historic

Display Field: EMPLOYEENAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: CUTSIDNUM )
• 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 (6) -- Related To: LOCATE_RESUBMIT_HISTORY (8)

Layer: Utility Hit (7)

Name: Utility Hit

Display Field: SASK_1ST_CALL

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: 532699.5108
YMin: 5584923.3899
XMax: 532699.5108
YMax: 5584923.3899
Spatial Reference: 26913  (26913)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [80, 41, 132, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SASK_1ST_CALL ( type: esriFieldTypeString, alias: Original Sask 1st Call Number, length: 50 )
• HIT_DATE_TIME ( type: esriFieldTypeDate, alias: HIT_DATE_TIME, length: 8 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 100 )
• UTILITY_HIT ( type: esriFieldTypeString, alias: UTILITY_HIT, length: 255 )
• DIVISION ( type: esriFieldTypeString, alias: DIVISION, length: 255 )
• DEPARTMENT ( type: esriFieldTypeString, alias: DEPARTMENT, length: 255 )
• CREW_LEAD ( type: esriFieldTypeString, alias: CREW_LEAD, length: 55 )
• TRUCK_NO ( type: esriFieldTypeString, alias: Truck Number, length: 25 )
• WORKORDER ( type: esriFieldTypeString, alias: Work Order Number, length: 7 )
• TASK_NO ( type: esriFieldTypeString, alias: Task Number, length: 25 )
• CALLED_SASK_1ST ( type: esriFieldTypeString, alias: CALLED_SASK_1ST, length: 5 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• CALL_DATETIME ( type: esriFieldTypeDate, alias: CALL_DATETIME, length: 8 )
• OSR_INITIALS ( type: esriFieldTypeString, alias: OSR_INITIALS, length: 3 )

Tables:

Table: LOCATE_RESUBMIT_HISTORY (8)

Name: LOCATE_RESUBMIT_HISTORY

Display Field: EMPLOYEENAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• EMPLOYEENAME ( type: esriFieldTypeString, alias: Employee Name, length: 100 )
• PREVIOUSTICKETNUMBER ( type: esriFieldTypeString, alias: Previous Ticket Number, length: 25 )
• WORKTYPE ( type: esriFieldTypeString, alias: Work Type, length: 25 , Coded Values: [Groundwork: Groundwork] , [Landscaping: Landscaping] , [Poles/Holes: Poles/Holes] , ...3 more... )
• DIG_ALLEY ( type: esriFieldTypeString, alias: Dig in Alley, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_SIDE ( type: esriFieldTypeString, alias: Dig in Side Yard, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_STREET ( type: esriFieldTypeString, alias: Dig in Street, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_SIDEWALK ( type: esriFieldTypeString, alias: Dig in Sidewalk, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_SITEMARKED ( type: esriFieldTypeString, alias: Dig in Site marked/staked, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_FRONTLOT ( type: esriFieldTypeString, alias: Dig in Front Lot, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_BACKLOT ( type: esriFieldTypeString, alias: Dig in Back Lot, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_CONTRACTTOMEET ( type: esriFieldTypeString, alias: Dig Contract to Meet, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_CALLWHENCOMPLETE ( type: esriFieldTypeString, alias: Call When Dig Complete, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• EXP_START_DATE ( type: esriFieldTypeDate, alias: Expected Start Date, length: 8 )
• ADDITIONALINFO ( type: esriFieldTypeString, alias: Additional Information, length: 500 )
• SR_FOR_FACILITIES ( type: esriFieldTypeString, alias: Service Request required for Facilities, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• SR_FOR_IRRIGATION ( type: esriFieldTypeString, alias: Service Request required for Irrigation (Parks), length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• EMPLOYEEPHONENUMBER ( type: esriFieldTypeString, alias: Employee Phone Number, length: 20 )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 100 )
• 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 )
• 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: Facilities Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• FACILITIES_COMPLETEDATE ( type: esriFieldTypeDate, alias: Facilities Completed On, length: 8 )
• TRAFFIC_STATUS ( type: esriFieldTypeString, alias: Traffic Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• TRAFFIC_COMPLETEDATE ( type: esriFieldTypeDate, alias: Traffic Completed On, length: 8 )
• PARKS_STATUS ( type: esriFieldTypeString, alias: Parks Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• PARKS_COMPLETEDATE ( type: esriFieldTypeDate, alias: Parks Completed On, length: 8 )
• DEVSERV_STATUS ( type: esriFieldTypeString, alias: Dev Services Status, length: 25 , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• DEVSERV_COMPLETEDATE ( type: esriFieldTypeDate, alias: Dev Services 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 )
• ALL_LOCATES_COMPLETEDATE ( type: esriFieldTypeDate, alias: Locate Request Completed On, length: 8 )
• FIRST_INT_STREET ( type: esriFieldTypeString, alias: First Intersecting Street, length: 100 )
• SECOND_INT_STREET ( type: esriFieldTypeString, alias: Second Intersecting Street, length: 100 )
• EMPLOYEE_EMAIL ( type: esriFieldTypeString, alias: Employee Email, length: 25 )
• 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... )
• UTILITY_HIT ( type: esriFieldTypeString, alias: Utility Hit, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• LOCATE_EXPIREDATE ( type: esriFieldTypeDate, alias: Locate Expires On, length: 8 )
• HIGH_VOLTAGE_PRESSURE ( type: esriFieldTypeString, alias: High Voltage/High Pressure, length: 1 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• 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: Locate Progress Status, length: 500 )
• 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 )
• WORKORDER ( type: esriFieldTypeString, alias: Workorder Number, length: 7 )
• 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 )
• CUTSIDNUM ( type: esriFieldTypeDouble, alias: CUTSIDNUM )
• CREATE_DATE ( type: esriFieldTypeDate, alias: Created On, length: 8 )
• DISPATCH_COMMENTS ( type: esriFieldTypeString, alias: Dispatch Comments, length: 50 )
• ORIGINATING_WO ( type: esriFieldTypeString, alias: ORIGINATING_WO, length: 50 )
• REPAIR_WO_NO_1 ( type: esriFieldTypeString, alias: REPAIR_WO_NO_1, length: 50 )
• 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] )
• ACTIVITY ( type: esriFieldTypeString, alias: ACTIVITY, length: 50 , Coded Values: [Catch Basin: Catch Basin] , [Hydrant: Hydrant] , [Irrigation: Irrigation] , ...16 more... )
• 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] )
• SR_PARKS ( type: esriFieldTypeString, alias: Service Request required for Parks, length: 50 , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• WORKDETAILS ( type: esriFieldTypeString, alias: WORKDETAILS, 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... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )

Relationships:

• LocateRequestForm (0) -- Related To: Locate Request Form (0)
• LocateRequestForm (1) -- Related To: New (1)
• LocateRequestForm (2) -- Related To: In Progress (2)
• LocateRequestForm (3) -- Related To: Completed (3)
• LocateRequestForm (4) -- Related To: Expired (4)
• LocateRequestForm (5) -- Related To: Invalid Date (5)
• LocateRequestForm (6) -- Related To: Historic (6)