Name: Cuts Last Inspections

Display Field: GIS.RoadwaysCutsDB_2_1.DISPATCH_ID_SR_NO

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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: 509720.0187
YMin: 5554738.6682
XMax: 574380.3604
YMax: 5598459.6735
Spatial Reference: 26913  (26913)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Inspected within 2 weeks
  Label: Inspected within 2 weeks
  Description: N/A
  Symbol:
  
• Value: Inspected within 3-4 weeks
  Label: Inspected within 3-4 weeks
  Description: N/A
  Symbol:
  
• Value: Inspected over 4 weeks
  Label: Inspected over 4 weeks
  Description: N/A
  Symbol:
  
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:

• GIS.RoadwaysCutsDB_2_1.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GIS.RoadwaysCutsDB_2_1.DISPATCH_ID_SR_NO ( type: esriFieldTypeString, alias: DISPATCH_ID_SR_No., length: 50 )
• GIS.RoadwaysCutsDB_2_1.STATUS ( type: esriFieldTypeString, alias: STATUS, length: 50 , Coded Values: [Open: Open] , [Hold: Hold] , [Closed: Closed] , ...4 more... )
• GIS.RoadwaysCutsDB_2_1.PROGRAM ( type: esriFieldTypeString, alias: PROGRAM, length: 50 , Coded Values: [Cuts: Cuts] , [Maintenance: Maintenance] , [WFPP: WFPP] , ...1 more... )
• GIS.RoadwaysCutsDB_2_1.LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 255 , Coded Values: [In The Alley: In The Alley] , [In Front Of: In Front Of] , [Adjacent To: Adjacent To] , ...7 more... )
• GIS.RoadwaysCutsDB_2_1.OPENED_DATE ( type: esriFieldTypeDate, alias: OPENED_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.CLOSED_DATE ( type: esriFieldTypeDate, alias: CLOSED_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.CUT_TYPE_OR_REPAIR_TYPE ( type: esriFieldTypeString, alias: CUT_TYPE_OR REPAIR_TYPE, length: 50 , Coded Values: [Brick: Brick] , [Pavement: Pavement] , [Lawn: Lawn] , ...4 more... )
• GIS.RoadwaysCutsDB_2_1.MADE_BY ( type: esriFieldTypeString, alias: MADE_BY, length: 50 , Coded Values: [Access Communications: Access Communications] , [SaskEnergy: SaskEnergy] , [SaskPower: SaskPower] , ...35 more... )
• GIS.RoadwaysCutsDB_2_1.UNREPORTED ( type: esriFieldTypeString, alias: UNREPORTED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.ORIGINATING_WO ( type: esriFieldTypeString, alias: ORIGINATING_WO, length: 50 )
• GIS.RoadwaysCutsDB_2_1.ORIGINATING_TASK ( type: esriFieldTypeString, alias: ORIGINATING_TASK, length: 50 )
• GIS.RoadwaysCutsDB_2_1.REPORTED_SIZE_IN_SQ_M ( type: esriFieldTypeDouble, alias: REPORTED_SIZE_in_SQ_M )
• GIS.RoadwaysCutsDB_2_1.ITEMS_IN_WORK_AREA ( type: esriFieldTypeString, alias: ITEMS_IN_WORK_AREA, length: 50 , Coded Values: [Catch Basin: Catch Basin] , [Cleanout: Cleanout] , [Coldmix: Coldmix] , ...7 more... )
• GIS.RoadwaysCutsDB_2_1.ITEMS_IN_WORK_AREA_2 ( type: esriFieldTypeString, alias: ITEMS_IN_WORK_AREA_2, length: 50 , Coded Values: [Catch Basin: Catch Basin] , [Cleanout: Cleanout] , [Coldmix: Coldmix] , ...7 more... )
• GIS.RoadwaysCutsDB_2_1.REPAIR_METHOD ( type: esriFieldTypeString, alias: REPAIR_METHOD, length: 50 , Coded Values: [Concrete Replacement: Concrete Replacement] , [Concrete Patching: Concrete Patching] , [Bricks: Bricks] , ...10 more... )
• GIS.RoadwaysCutsDB_2_1.REPAIR_SIZE ( type: esriFieldTypeDouble, alias: REPAIR_SIZE )
• GIS.RoadwaysCutsDB_2_1.COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• GIS.RoadwaysCutsDB_2_1.VEHICLE_CROSSING ( type: esriFieldTypeString, alias: VEHICLE_CROSSING, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.REPAIR_AREA_MARKED ( type: esriFieldTypeString, alias: REPAIR_AREA_MARKED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.LOCATED_DATE ( type: esriFieldTypeDate, alias: LOCATED_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.SAWCUT_DATE ( type: esriFieldTypeDate, alias: SAWCUT_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.MJ_B_REPLACE_NEEDED ( type: esriFieldTypeString, alias: MJ_B_REPLACE_NEEDED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.MUDJACKED_DATE ( type: esriFieldTypeDate, alias: MUDJACKED_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.REPLACE_AFTER_MJ ( type: esriFieldTypeString, alias: REPLACE_AFTER_MJ, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.EXCAVATED_DATE ( type: esriFieldTypeDate, alias: EXCAVATED_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.BASE_PREP_NEEDED ( type: esriFieldTypeString, alias: BASE_PREP_NEEDED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.BASE_PREP_DATE ( type: esriFieldTypeDate, alias: BASE_PREP_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.CBMH_REPAIR_NEEDED ( type: esriFieldTypeString, alias: CBMH_REPAIR_NEEDED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.CBMH_REPAIR_DATE ( type: esriFieldTypeDate, alias: CBMH_REPAIR_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.TREE_ROOT_TRIMMING ( type: esriFieldTypeString, alias: TREE_ROOT_TRIMMING, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.TREE_ROOT_TRIMMING_DATE ( type: esriFieldTypeDate, alias: TREE_ROOT_TRIMMING_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.FORMED_DATE ( type: esriFieldTypeDate, alias: FORMED_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.POURED_DATE ( type: esriFieldTypeDate, alias: POURED_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.STRIPPED_DATE ( type: esriFieldTypeDate, alias: STRIPPED_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.GUTTER_PATCH ( type: esriFieldTypeString, alias: GUTTER_PATCH, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.GUTTER_PATCH_DATE ( type: esriFieldTypeDate, alias: GUTTER_PATCH_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.BRICK_REPAIR ( type: esriFieldTypeString, alias: BRICK_REPAIR, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.BRICK_REPAIR_DATE ( type: esriFieldTypeDate, alias: BRICK_REPAIR_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.SOIL_SEED ( type: esriFieldTypeString, alias: SOIL_SEED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.SOIL_SEED_DATE ( type: esriFieldTypeDate, alias: SOIL_SEED_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.LANDSCAPE_EXTRAS ( type: esriFieldTypeString, alias: LANDSCAPE_EXTRAS, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.LANDSCAPE_EXTRAS_DATE ( type: esriFieldTypeDate, alias: LANDSCAPE_EXTRAS_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.LANDSCAPE_TRADES ( type: esriFieldTypeString, alias: LANDSCAPE_TRADES, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.LANDSCAPE_TRADES_DATE ( type: esriFieldTypeDate, alias: LANDSCAPE_TRADES_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.OILING_DATE ( type: esriFieldTypeDate, alias: OILING_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.ASPHALT_CAPPING_DATE ( type: esriFieldTypeDate, alias: ASPHALT_CAPPING_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.SURVEYING_NEEDED ( type: esriFieldTypeString, alias: SURVEYING_NEEDED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.SURVEYED_DATE ( type: esriFieldTypeDate, alias: SURVEYED_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.MG_KRETE_RESURFACING_DATE ( type: esriFieldTypeDate, alias: MG_KRETE_RESURFACING_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• GIS.RoadwaysCutsDB_2_1.SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• GIS.RoadwaysCutsDB_2_1.LOCATION_1 ( type: esriFieldTypeString, alias: LOCATION, length: 255 )
• GIS.RoadwaysCutsDB_2_1.REPAIR_CREW ( type: esriFieldTypeString, alias: REPAIR_CREW, length: 50 , Coded Values: [Sawcutting Crew 1: Sawcutting - Crew 1] , [Sawcutting Crew 2: Sawcutting - Crew 2] , [Sawcutting Crew 3 (Spare): Sawcutting - Crew 3 (Spare)] , ...39 more... )
• GIS.RoadwaysCutsDB_2_1.LOCATION_12 ( type: esriFieldTypeString, alias: LOCATION_12, length: 50 )
• GIS.RoadwaysCutsDB_2_1.REPAIR_WO_NO_1 ( type: esriFieldTypeString, alias: REPAIR_WO_NO_1, length: 50 )
• GIS.RoadwaysCutsDB_2_1.READY_FOR_FORMING ( type: esriFieldTypeString, alias: Ready for Forming, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.DATE_LOCATES_SUBMITTED ( type: esriFieldTypeDate, alias: DATE_LOCATES_SUBMITTED, length: 8 )
• GIS.RoadwaysCutsDB_2_1.CONCRETE_PATCH_DATE ( type: esriFieldTypeDate, alias: CONCRETE_PATCH_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.GRINDING_DATE ( type: esriFieldTypeDate, alias: GRINDING_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.TARP_INSTALLED ( type: esriFieldTypeString, alias: TARP_INSTALLED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.MAINTENANCE_ADDITION_SIZE__M2 ( type: esriFieldTypeDouble, alias: MAINTENANCE_ADDITION_SIZE__M2 )
• GIS.RoadwaysCutsDB_2_1.FORESTRY_SECTOR ( type: esriFieldTypeSmallInteger, alias: FORESTRY_SECTOR )
• GIS.RoadwaysCutsDB_2_1.WEEK_OF ( type: esriFieldTypeDate, alias: WEEK_OF, length: 8 )
• GIS.RoadwaysCutsDB_2_1.DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, length: 50 )
• GIS.RoadwaysCutsDB_2_1.SERVICE_REQUEST ( type: esriFieldTypeString, alias: Service Request, length: 7 )
• GIS.RoadwaysCutsDB_2_1.CUT_RPT_SUBMIT_DATE ( type: esriFieldTypeDate, alias: CUT_RPT_SUBMIT_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.CREATEDATE ( type: esriFieldTypeDate, alias: CREATEDATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• GIS.RoadwaysCutsDB_2_1.CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• GIS.RoadwaysCutsDB_2_1.LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• GIS.RoadwaysCutsDB_2_1.YC ( type: esriFieldTypeDouble, alias: YC )
• GIS.RoadwaysCutsDB_2_1.XC ( type: esriFieldTypeDouble, alias: XC )
• GIS.RoadwaysCutsDB_2_1.XC_1 ( type: esriFieldTypeDouble, alias: XC_1 )
• GIS.RoadwaysCutsDB_2_1.POINT_X ( type: esriFieldTypeDouble, alias: POINT_X )
• GIS.RoadwaysCutsDB_2_1.POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y )
• GIS.RoadwaysCutsDB_2_1.LOCATE_TYPE ( type: esriFieldTypeString, alias: Locate Type, length: 50 , 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... )
• GIS.RoadwaysCutsDB_2_1.CUTSIDNUM ( type: esriFieldTypeDouble, alias: CUTSIDNUM )
• GIS.RoadwaysCutsDB_2_1.CAPITAL_WORK ( type: esriFieldTypeString, alias: CAPITAL WORK, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GIS.RoadwaysCutsDB_2_1.HIGH_VOLTAGE ( type: esriFieldTypeString, alias: GIS.RoadwaysCutsDB_2_1.HIGH_VOLTAGE, length: 50 )
• GIS.RoadwaysCutsDB_2_1.LR_EXPIRE_DATE ( type: esriFieldTypeDate, alias: GIS.RoadwaysCutsDB_2_1.LR_EXPIRE_DATE, length: 8 )
• GIS.CUTS_INSPEC_V.INS_ID ( type: esriFieldTypeInteger, alias: INS_ID )
• GIS.CUTS_INSPEC_V.DATEINSECTION ( type: esriFieldTypeDate, alias: DATEINSECTION, length: 8 )
• GIS.RoadwaysCutsDB_2_1.EXCAVATION_METHOD ( type: esriFieldTypeString, alias: Excavation Method, length: 50 , Coded Values: [Hydro Vacuum: Hydro Vacuum] , [Machine Digging: Machine Digging] , [None: None] )
• GIS.RoadwaysCutsDB_2_1.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] )
• GIS.RoadwaysCutsDB_2_1.EXP_START_DATE ( type: esriFieldTypeDate, alias: Expected Start Date, length: 8 )
• GIS.RoadwaysCutsDB_2_1.ACTIVELEAK_GUID ( type: esriFieldTypeGUID, alias: ACTIVELEAK_GUID, length: 38 )

Relationships:

• Cuts_Inspections (1) -- Related To: Cuts_Inspections (2)

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

  Iteminfo   Thumbnail   Metadata