Name: CutsDB

Display Field: DISPATCH_ID_SR_NO

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

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:

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: CUT_TYPE_OR_REPAIR_TYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Brick
  Label: Brick
  Description: N/A
  Symbol:
  
• Value: Concrete
  Label: Concrete
  Description: N/A
  Symbol:
  
• Value: Easement
  Label: Easement
  Description: N/A
  Symbol:
  
• Value: Gravel
  Label: Gravel
  Description: N/A
  Symbol:
  
• Value: Lawn
  Label: Lawn
  Description: N/A
  Symbol:
  
• Value: Pavement
  Label: Pavement
  Description: N/A
  Symbol:
  
• Value: Other
  Label: Other
  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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• DISPATCH_ID_SR_NO ( type: esriFieldTypeString, alias: DISPATCH_ID_SR_No., length: 50 )
• REPAIR_WO_NO_1 ( type: esriFieldTypeString, alias: REPAIR_WO_NO_1, length: 50 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 50 , Coded Values: [Open: Open] , [Hold: Hold] , [Closed: Closed] , ...4 more... )
• PROGRAM ( type: esriFieldTypeString, alias: PROGRAM, length: 50 , Coded Values: [Cuts: Cuts] , [Maintenance: Maintenance] , [WFPP: WFPP] , ...1 more... )
• LOCATION_1 ( type: esriFieldTypeString, alias: LOCATION, length: 255 )
• 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... )
• OPENED_DATE ( type: esriFieldTypeDate, alias: OPENED_DATE, length: 8 )
• CLOSED_DATE ( type: esriFieldTypeDate, alias: CLOSED_DATE, length: 8 )
• 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... )
• MADE_BY ( type: esriFieldTypeString, alias: MADE_BY, length: 50 , Coded Values: [Access Communications: Access Communications] , [SaskEnergy: SaskEnergy] , [SaskPower: SaskPower] , ...35 more... )
• UNREPORTED ( type: esriFieldTypeString, alias: UNREPORTED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• ORIGINATING_WO ( type: esriFieldTypeString, alias: ORIGINATING_WO, length: 50 )
• ORIGINATING_TASK ( type: esriFieldTypeString, alias: ORIGINATING_TASK, length: 50 )
• REPORTED_SIZE_IN_SQ_M ( type: esriFieldTypeDouble, alias: REPORTED_SIZE_in_SQ_M )
• 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... )
• 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... )
• REPAIR_METHOD ( type: esriFieldTypeString, alias: REPAIR_METHOD, length: 50 , Coded Values: [Concrete Replacement: Concrete Replacement] , [Concrete Patching: Concrete Patching] , [Bricks: Bricks] , ...10 more... )
• REPAIR_SIZE ( type: esriFieldTypeDouble, alias: REPAIR_SIZE )
• 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... )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• VEHICLE_CROSSING ( type: esriFieldTypeString, alias: VEHICLE_CROSSING, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• REPAIR_AREA_MARKED ( type: esriFieldTypeString, alias: REPAIR_AREA_MARKED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• SURVEYING_NEEDED ( type: esriFieldTypeString, alias: SURVEYING_NEEDED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• SURVEYED_DATE ( type: esriFieldTypeDate, alias: SURVEYED_DATE, length: 8 )
• LOCATED_DATE ( type: esriFieldTypeDate, alias: LOCATED_DATE, length: 8 )
• SAWCUT_DATE ( type: esriFieldTypeDate, alias: SAWCUT_DATE, length: 8 )
• MJ_B_REPLACE_NEEDED ( type: esriFieldTypeString, alias: MJ_B_REPLACE_NEEDED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• MUDJACKED_DATE ( type: esriFieldTypeDate, alias: MUDJACKED_DATE, length: 8 )
• REPLACE_AFTER_MJ ( type: esriFieldTypeString, alias: REPLACE_AFTER_MJ, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• EXCAVATED_DATE ( type: esriFieldTypeDate, alias: EXCAVATED_DATE, length: 8 )
• BASE_PREP_NEEDED ( type: esriFieldTypeString, alias: BASE_PREP_NEEDED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• BASE_PREP_DATE ( type: esriFieldTypeDate, alias: BASE_PREP_DATE, length: 8 )
• CBMH_REPAIR_NEEDED ( type: esriFieldTypeString, alias: CBMH_REPAIR_NEEDED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• CBMH_REPAIR_DATE ( type: esriFieldTypeDate, alias: CBMH_REPAIR_DATE, length: 8 )
• TREE_ROOT_TRIMMING ( type: esriFieldTypeString, alias: TREE_ROOT_TRIMMING, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• TREE_ROOT_TRIMMING_DATE ( type: esriFieldTypeDate, alias: TREE_ROOT_TRIMMING_DATE, length: 8 )
• FORMED_DATE ( type: esriFieldTypeDate, alias: FORMED_DATE, length: 8 )
• POURED_DATE ( type: esriFieldTypeDate, alias: POURED_DATE, length: 8 )
• STRIPPED_DATE ( type: esriFieldTypeDate, alias: STRIPPED_DATE, length: 8 )
• GUTTER_PATCH ( type: esriFieldTypeString, alias: GUTTER_PATCH, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• GUTTER_PATCH_DATE ( type: esriFieldTypeDate, alias: GUTTER_PATCH_DATE, length: 8 )
• BRICK_REPAIR ( type: esriFieldTypeString, alias: BRICK_REPAIR, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• BRICK_REPAIR_DATE ( type: esriFieldTypeDate, alias: BRICK_REPAIR_DATE, length: 8 )
• SOIL_SEED ( type: esriFieldTypeString, alias: SOIL_SEED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• SOIL_SEED_DATE ( type: esriFieldTypeDate, alias: SOIL_SEED_DATE, length: 8 )
• LANDSCAPE_EXTRAS ( type: esriFieldTypeString, alias: LANDSCAPE_EXTRAS, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• LANDSCAPE_EXTRAS_DATE ( type: esriFieldTypeDate, alias: LANDSCAPE_EXTRAS_DATE, length: 8 )
• LANDSCAPE_TRADES ( type: esriFieldTypeString, alias: LANDSCAPE_TRADES, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• LANDSCAPE_TRADES_DATE ( type: esriFieldTypeDate, alias: LANDSCAPE_TRADES_DATE, length: 8 )
• OILING_DATE ( type: esriFieldTypeDate, alias: OILING_DATE, length: 8 )
• ASPHALT_CAPPING_DATE ( type: esriFieldTypeDate, alias: ASPHALT_CAPPING_DATE, length: 8 )
• MG_KRETE_RESURFACING_DATE ( type: esriFieldTypeDate, alias: MG_KRETE_RESURFACING_DATE, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• READY_FOR_FORMING ( type: esriFieldTypeString, alias: Ready for Forming, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• DATE_LOCATES_SUBMITTED ( type: esriFieldTypeDate, alias: DATE_LOCATES_SUBMITTED, length: 8 )
• CONCRETE_PATCH_DATE ( type: esriFieldTypeDate, alias: CONCRETE_PATCH_DATE, length: 8 )
• GRINDING_DATE ( type: esriFieldTypeDate, alias: GRINDING_DATE, length: 8 )
• TARP_INSTALLED ( type: esriFieldTypeString, alias: TARP_INSTALLED, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• MAINTENANCE_ADDITION_SIZE__M2 ( type: esriFieldTypeDouble, alias: MAINTENANCE_ADDITION_SIZE__M2 )
• FORESTRY_SECTOR ( type: esriFieldTypeSmallInteger, alias: FORESTRY_SECTOR )
• WEEK_OF ( type: esriFieldTypeDate, alias: WEEK_OF, length: 8 )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, length: 50 )
• SERVICE_REQUEST ( type: esriFieldTypeString, alias: Service Request, length: 7 )
• CUT_RPT_SUBMIT_DATE ( type: esriFieldTypeDate, alias: CUT_RPT_SUBMIT_DATE, length: 8 )
• CREATEDATE ( type: esriFieldTypeDate, alias: CREATEDATE, length: 8 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• YC ( type: esriFieldTypeDouble, alias: YC )
• XC ( type: esriFieldTypeDouble, alias: XC )
• XC_1 ( type: esriFieldTypeDouble, alias: XC_1 )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y )
• 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... )
• CUTSIDNUM ( type: esriFieldTypeDouble, alias: CUTSIDNUM )
• CAPITAL_WORK ( type: esriFieldTypeString, alias: CAPITAL WORK, length: 50 , Coded Values: [N: No] , [Y: Yes] )
• HIGH_VOLTAGE ( type: esriFieldTypeString, alias: HIGH_VOLTAGE, length: 50 )
• LR_EXPIRE_DATE ( type: esriFieldTypeDate, alias: LR_EXPIRE_DATE, length: 8 )
• EXCAVATION_METHOD ( type: esriFieldTypeString, alias: Excavation Method, length: 50 , Coded Values: [Hydro Vacuum: Hydro Vacuum] , [Machine Digging: Machine Digging] , [None: None] )
• 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] )
• EXP_START_DATE ( type: esriFieldTypeDate, alias: Expected Start Date, length: 8 )

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata