View In:   ArcGIS Online Map Viewer

Name: Sidewalk Inspections

Display Field: DEFECT

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 654439.2894
YMin: 4853582.6279
XMax: 666955.5491
YMax: 4862973.5458
Spatial Reference: 26917  (26917)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [123, 64, 158, 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: 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 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• DEFECT ( type: esriFieldTypeString, alias: DEFECT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DEFECT , Coded Values: [Condition Over 20mm: Condition Over 20mm] , [Condition 15mm to 20mm: Condition 15mm to 20mm] , [Utility Condition Over 20mm: Utility Condition Over 20mm] , ...11 more... )
• BAYS ( type: esriFieldTypeString, alias: BAYS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BAYS )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDRESS )
• ADDRESS_CHANGE ( type: esriFieldTypeString, alias: ADDRESS_CHANGE, editable: true, nullable: true, length: 255, defaultValue: N, modelName: ADDRESS_CHANGE , Coded Values: [Y: Yes] , [N: No] )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOTES )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• MARKED_FOR_GRINDING ( type: esriFieldTypeString, alias: MARKED_FOR_GRINDING, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MARKED_FOR_GRINDING , Coded Values: [Y: Yes] , [N: No] )
• GRINDING_ASSIGNED_TO ( type: esriFieldTypeString, alias: GRINDING_ASSIGNED_TO, editable: true, nullable: true, length: 255, defaultValue: Contractor, modelName: GRINDING_ASSIGNED_TO , Coded Values: [Town of Ajax: Town of Ajax] , [Contractor: Contractor] )
• ASSIGNED_TO_DATE ( type: esriFieldTypeDate, alias: ASSIGNED_TO_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSIGNED_TO_DATE )
• STAFF_COMMENTS ( type: esriFieldTypeString, alias: STAFF_COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STAFF_COMMENTS )
• GRINDING_COMPLETE ( type: esriFieldTypeString, alias: GRINDING_COMPLETE, editable: true, nullable: true, length: 255, defaultValue: N, modelName: GRINDING_COMPLETE , Coded Values: [Y: Yes] , [N: No] )
• CONTRACTOR_COMMENTS ( type: esriFieldTypeString, alias: CONTRACTOR_COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONTRACTOR_COMMENTS )
• GRINDING_DATE_CONTRACTOR ( type: esriFieldTypeDate, alias: GRINDING_DATE_CONTRACTOR, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GRINDING_DATE_CONTRACTOR )
• WO_COMPLETE_DATE ( type: esriFieldTypeDate, alias: WO_COMPLETE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WO_COMPLETE_DATE )
• PROJ_FINISH_DATE_CW ( type: esriFieldTypeDate, alias: PROJ_FINISH_DATE_CW, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PROJ_FINISH_DATE_CW )
• ASSETID_CW ( type: esriFieldTypeString, alias: ASSETID_CW, editable: false, nullable: true, length: 255, defaultValue: null, modelName: ASSETID_CW )
• ASSETID_CW_SIDEWALK ( type: esriFieldTypeString, alias: ASSETID_CW_SIDEWALK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ASSETID_CW_SIDEWALK )
• CREATED_BY ( type: esriFieldTypeString, alias: CREATED_BY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CREATED_BY , Coded Values: [Staff: Staff] , [Student: Student] , [Contractor: Contractor] )
• CREATED_YEAR ( type: esriFieldTypeSmallInteger, alias: CREATED_YEAR, editable: true, nullable: true, defaultValue: null, modelName: CREATED_YEAR )
• CREATED_USER_ET ( type: esriFieldTypeString, alias: CREATED_USER_ET, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER_ET )
• CREATED_DATE_ET ( type: esriFieldTypeDate, alias: CREATED_DATE_ET, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE_ET )
• LAST_EDITED_USER_ET ( type: esriFieldTypeString, alias: LAST_EDITED_USER_ET, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER_ET )
• LAST_EDITED_DATE_ET ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE_ET, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE_ET )
• ITEM ( type: esriFieldTypeString, alias: ITEM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ITEM , Coded Values: [1.01 Sidewalk: 1.01 Sidewalk] , [1.03 Monolithic Sidewalk and Curb: 1.03 Monolithic Sidewalk and Curb] , [1.04 Walkway: 1.04 Walkway] , ...10 more... )
• MARKED_FOR_REPAIR ( type: esriFieldTypeString, alias: MARKED_FOR_REPAIR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MARKED_FOR_REPAIR , Coded Values: [Yes: Yes] , [No: No] )
• DATE_MARKED_OUT ( type: esriFieldTypeDate, alias: DATE_MARKED_OUT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_MARKED_OUT )
• REPAIRED ( type: esriFieldTypeString, alias: REPAIRED, editable: true, nullable: true, length: 255, defaultValue: No, modelName: REPAIRED , Coded Values: [Yes: Yes] , [No: No] )
• DATE_REPAIRED ( type: esriFieldTypeDate, alias: DATE_REPAIRED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_REPAIRED )
• REPAIRED_BY ( type: esriFieldTypeString, alias: REPAIRED_BY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REPAIRED_BY , Coded Values: [Serve Construction: Serve Construction] , [Other: Other] )
• REPAIR_NOTES ( type: esriFieldTypeString, alias: REPAIR_NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REPAIR_NOTES )
• CITYWORKS_WO_ID ( type: esriFieldTypeInteger, alias: CITYWORKS_WO_ID, editable: true, nullable: true, defaultValue: null, modelName: CITYWORKS_WO_ID )
• CITYWORKS_WO_NOTES ( type: esriFieldTypeString, alias: CITYWORKS_WO_NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CITYWORKS_WO_NOTES )
• CONTRACT_NO ( type: esriFieldTypeString, alias: CONTRACT_NO, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONTRACT_NO )
• REPAIR_YEAR ( type: esriFieldTypeSmallInteger, alias: REPAIR_YEAR, editable: true, nullable: true, defaultValue: null, modelName: REPAIR_YEAR )
• INSPECTION_AREA ( type: esriFieldTypeString, alias: INSPECTION_AREA, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTION_AREA )
• DEFECT_PRESENT ( type: esriFieldTypeString, alias: DEFECT_PRESENT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEFECT_PRESENT , Coded Values: [Yes: Yes] , [No: No] )
• UPDATED_DEFECT_DATE ( type: esriFieldTypeDate, alias: UPDATED_DEFECT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UPDATED_DEFECT_DATE )

Templates:

• Name: Sidewalk Inspections
  Description:
  Prototype:
  DEFECT_PRESENT: null
  UPDATED_DEFECT_DATE: null
  DEFECT: null
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  CREATED_USER: null
  CREATED_DATE: null
  LAST_EDITED_USER: null
  LAST_EDITED_DATE: null
  MARKED_FOR_GRINDING: null
  GRINDING_ASSIGNED_TO: Contractor
  ASSIGNED_TO_DATE: null
  STAFF_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_DATE_CONTRACTOR: null
  WO_COMPLETE_DATE: null
  PROJ_FINISH_DATE_CW: null
  INSPECTION_AREA: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  CREATED_YEAR: null
  REPAIR_YEAR: null
  CONTRACT_NO: null
  CITYWORKS_WO_NOTES: null
  CITYWORKS_WO_ID: null
  ITEM: null
  MARKED_FOR_REPAIR: null
  DATE_MARKED_OUT: null
  REPAIRED: No
  DATE_REPAIRED: null
  REPAIRED_BY: null
  REPAIR_NOTES: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Update,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: CREATED_DATE_ET
• Creator Field: CREATED_USER_ET
• Edit Date Field: LAST_EDITED_DATE_ET
• Editor Field: LAST_EDITED_USER_ET

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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