View In:   ArcGIS Online Map Viewer

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
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:

Fields:

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

Templates:

• Name: Locate Request Form
  Description:
  Prototype:
  SR_FOR_IRRIGATION: N
  DIG_ALLEY: N
  DIG_CONTRACTTOMEET: N
  DIG_SITEMARKED: N
  SR_FOR_FACILITIES: N
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata