View In:   ArcGIS Online Map Viewer

Name: Sidewalk_Inspections_2024

Display Field: DEFECT

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

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: 613479.3072
YMin: 4588362.2487
XMax: 1277269.0029
YMax: 4864096.6265
Spatial Reference: 26917  (26917)  LatestVCSWkid(0)

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: Less than or equal to 7 days
  Label: Less than or equal to 7 days
  Description: N/A
  Symbol:
  
• Value: 8-14
  Label: 8 to 14 days
  Description: N/A
  Symbol:
  
• Value: More than 14 days
  Label: More than 14 days
  Description: N/A
  Symbol:
  
• Value: Grinding Complete
  Label: Grinding Complete
  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: 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 )
• ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDRESS2 )
• ADDRESS_CHANGE ( type: esriFieldTypeString, alias: ADDRESS_CONFIRM, 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: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• LAYOUT_DATE ( type: esriFieldTypeDate, alias: LAYOUT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAYOUT_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] )
• LAYOUT_COMMENTS ( type: esriFieldTypeString, alias: LAYOUT_COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LAYOUT_COMMENTS )
• GRINDING_DATE_CW ( type: esriFieldTypeDate, alias: GRINDING_DATE_CW, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GRINDING_DATE_CW )
• 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_INVOICED ( type: esriFieldTypeString, alias: GRINDING_INVOICED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GRINDING_INVOICED , Coded Values: [Y: Yes] , [N: No] )
• LAYOUT ( type: esriFieldTypeString, alias: Layout, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LAYOUT , Coded Values: [Inspected_not for repair: Inspected, not for repair] , [Inspected_already repaired: Inspected, already repaired] , [Marked for Repair: Marked for Repair] )
• LAYOUT_INSP_DATE ( type: esriFieldTypeDate, alias: LAYOUT_INSP_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAYOUT_INSP_DATE )
• DATE_REPAIRED ( type: esriFieldTypeDate, alias: DATE_REPAIRED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_REPAIRED )
• REPAIR_BY ( type: esriFieldTypeInteger, alias: REPAIRED_BY, editable: true, nullable: true, defaultValue: null, modelName: REPAIR_BY )
• 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 )
• 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] )
• GRINDING_DATE_CONTRACTOR ( type: esriFieldTypeDate, alias: GRINDING_DATE_CONTRACTOR, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GRINDING_DATE_CONTRACTOR )
• PROJ_FINISH_DATE_CW ( type: esriFieldTypeDate, alias: PROJ_FINISH_DATE_CW, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PROJ_FINISH_DATE_CW )
• ASSIGNED_TO_DATE ( type: esriFieldTypeDate, alias: ASSIGNED_TO_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSIGNED_TO_DATE )
• WO_COMPLETE_DATE ( type: esriFieldTypeDate, alias: WO_COMPLETE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WO_COMPLETE_DATE )
• 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 )

Templates:

• Name: Condition 15mm to 20mm
  Description:
  Prototype:
  CREATED_YEAR: null
  ADDRESS2: null
  GRINDING_DATE_CW: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  DEFECT: Condition 15mm to 20mm
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  WO_COMPLETE_DATE: null
  ASSIGNED_TO_DATE: null
  PROJ_FINISH_DATE_CW: null
  GRINDING_DATE_CONTRACTOR: null
  LAYOUT_DATE: null
  MARKED_FOR_GRINDING: null
  LAYOUT_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_INVOICED: null
  LAYOUT: null
  LAYOUT_INSP_DATE: null
  DATE_REPAIRED: null
  REPAIR_BY: null
  GRINDING_ASSIGNED_TO: Contractor
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Condition Over 20mm
  Description:
  Prototype:
  CREATED_YEAR: null
  ADDRESS2: null
  GRINDING_DATE_CW: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  DEFECT: Condition Over 20mm
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  WO_COMPLETE_DATE: null
  ASSIGNED_TO_DATE: null
  PROJ_FINISH_DATE_CW: null
  GRINDING_DATE_CONTRACTOR: null
  LAYOUT_DATE: null
  MARKED_FOR_GRINDING: null
  LAYOUT_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_INVOICED: null
  LAYOUT: null
  LAYOUT_INSP_DATE: null
  DATE_REPAIRED: null
  REPAIR_BY: null
  GRINDING_ASSIGNED_TO: Contractor
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Cracked Condition Major
  Description:
  Prototype:
  CREATED_YEAR: null
  ADDRESS2: null
  GRINDING_DATE_CW: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  DEFECT: Cracked Condition Major
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  WO_COMPLETE_DATE: null
  ASSIGNED_TO_DATE: null
  PROJ_FINISH_DATE_CW: null
  GRINDING_DATE_CONTRACTOR: null
  LAYOUT_DATE: null
  MARKED_FOR_GRINDING: null
  LAYOUT_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_INVOICED: null
  LAYOUT: null
  LAYOUT_INSP_DATE: null
  DATE_REPAIRED: null
  REPAIR_BY: null
  GRINDING_ASSIGNED_TO: Contractor
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Encroachment
  Description:
  Prototype:
  CREATED_YEAR: null
  ADDRESS2: null
  GRINDING_DATE_CW: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  DEFECT: Encroachment
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  WO_COMPLETE_DATE: null
  ASSIGNED_TO_DATE: null
  PROJ_FINISH_DATE_CW: null
  GRINDING_DATE_CONTRACTOR: null
  LAYOUT_DATE: null
  MARKED_FOR_GRINDING: null
  LAYOUT_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_INVOICED: null
  LAYOUT: null
  LAYOUT_INSP_DATE: null
  DATE_REPAIRED: null
  REPAIR_BY: null
  GRINDING_ASSIGNED_TO: Contractor
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Longitudinal Slope Condition
  Description:
  Prototype:
  CREATED_YEAR: null
  ADDRESS2: null
  GRINDING_DATE_CW: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  DEFECT: Longitudinal Slope Condition
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  WO_COMPLETE_DATE: null
  ASSIGNED_TO_DATE: null
  PROJ_FINISH_DATE_CW: null
  GRINDING_DATE_CONTRACTOR: null
  LAYOUT_DATE: null
  MARKED_FOR_GRINDING: null
  LAYOUT_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_INVOICED: null
  LAYOUT: null
  LAYOUT_INSP_DATE: null
  DATE_REPAIRED: null
  REPAIR_BY: null
  GRINDING_ASSIGNED_TO: Contractor
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: No Condition Found
  Description:
  Prototype:
  CREATED_YEAR: null
  ADDRESS2: null
  GRINDING_DATE_CW: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  DEFECT: No Condition Found
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  WO_COMPLETE_DATE: null
  ASSIGNED_TO_DATE: null
  PROJ_FINISH_DATE_CW: null
  GRINDING_DATE_CONTRACTOR: null
  LAYOUT_DATE: null
  MARKED_FOR_GRINDING: null
  LAYOUT_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_INVOICED: null
  LAYOUT: null
  LAYOUT_INSP_DATE: null
  DATE_REPAIRED: null
  REPAIR_BY: null
  GRINDING_ASSIGNED_TO: Contractor
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Reverse Slope Condition
  Description:
  Prototype:
  CREATED_YEAR: null
  ADDRESS2: null
  GRINDING_DATE_CW: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  DEFECT: Reverse Slope Condition
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  WO_COMPLETE_DATE: null
  ASSIGNED_TO_DATE: null
  PROJ_FINISH_DATE_CW: null
  GRINDING_DATE_CONTRACTOR: null
  LAYOUT_DATE: null
  MARKED_FOR_GRINDING: null
  LAYOUT_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_INVOICED: null
  LAYOUT: null
  LAYOUT_INSP_DATE: null
  DATE_REPAIRED: null
  REPAIR_BY: null
  GRINDING_ASSIGNED_TO: Contractor
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Sidewalk Edge Hazard
  Description:
  Prototype:
  CREATED_YEAR: null
  ADDRESS2: null
  GRINDING_DATE_CW: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  DEFECT: Sidewalk Edge Hazard
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  WO_COMPLETE_DATE: null
  ASSIGNED_TO_DATE: null
  PROJ_FINISH_DATE_CW: null
  GRINDING_DATE_CONTRACTOR: null
  LAYOUT_DATE: null
  MARKED_FOR_GRINDING: null
  LAYOUT_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_INVOICED: null
  LAYOUT: null
  LAYOUT_INSP_DATE: null
  DATE_REPAIRED: null
  REPAIR_BY: null
  GRINDING_ASSIGNED_TO: Contractor
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Surface Condition
  Description:
  Prototype:
  CREATED_YEAR: null
  ADDRESS2: null
  GRINDING_DATE_CW: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  DEFECT: Surface Condition
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  WO_COMPLETE_DATE: null
  ASSIGNED_TO_DATE: null
  PROJ_FINISH_DATE_CW: null
  GRINDING_DATE_CONTRACTOR: null
  LAYOUT_DATE: null
  MARKED_FOR_GRINDING: null
  LAYOUT_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_INVOICED: null
  LAYOUT: null
  LAYOUT_INSP_DATE: null
  DATE_REPAIRED: null
  REPAIR_BY: null
  GRINDING_ASSIGNED_TO: Contractor
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Utility Condition 20mm and Under
  Description:
  Prototype:
  CREATED_YEAR: null
  ADDRESS2: null
  GRINDING_DATE_CW: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  DEFECT: Utility Condition 20mm and Under
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  WO_COMPLETE_DATE: null
  ASSIGNED_TO_DATE: null
  PROJ_FINISH_DATE_CW: null
  GRINDING_DATE_CONTRACTOR: null
  LAYOUT_DATE: null
  MARKED_FOR_GRINDING: null
  LAYOUT_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_INVOICED: null
  LAYOUT: null
  LAYOUT_INSP_DATE: null
  DATE_REPAIRED: null
  REPAIR_BY: null
  GRINDING_ASSIGNED_TO: Contractor
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Utility Condition Over 20mm
  Description:
  Prototype:
  CREATED_YEAR: null
  ADDRESS2: null
  GRINDING_DATE_CW: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  DEFECT: Utility Condition Over 20mm
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  WO_COMPLETE_DATE: null
  ASSIGNED_TO_DATE: null
  PROJ_FINISH_DATE_CW: null
  GRINDING_DATE_CONTRACTOR: null
  LAYOUT_DATE: null
  MARKED_FOR_GRINDING: null
  LAYOUT_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_INVOICED: null
  LAYOUT: null
  LAYOUT_INSP_DATE: null
  DATE_REPAIRED: null
  REPAIR_BY: null
  GRINDING_ASSIGNED_TO: Contractor
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Vertical Hazard
  Description:
  Prototype:
  CREATED_YEAR: null
  ADDRESS2: null
  GRINDING_DATE_CW: null
  ASSETID_CW_SIDEWALK: null
  CREATED_BY: null
  DEFECT: Vertical Hazard
  BAYS: null
  ADDRESS: null
  ADDRESS_CHANGE: N
  NOTES: null
  WO_COMPLETE_DATE: null
  ASSIGNED_TO_DATE: null
  PROJ_FINISH_DATE_CW: null
  GRINDING_DATE_CONTRACTOR: null
  LAYOUT_DATE: null
  MARKED_FOR_GRINDING: null
  LAYOUT_COMMENTS: null
  GRINDING_COMPLETE: N
  CONTRACTOR_COMMENTS: null
  GRINDING_INVOICED: null
  LAYOUT: null
  LAYOUT_INSP_DATE: null
  DATE_REPAIRED: null
  REPAIR_BY: null
  GRINDING_ASSIGNED_TO: Contractor
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Update,Uploads,Editing

Sync Can Return Changes: false

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
• Creator Field: CREATED_USER
• Edit Date Field: LAST_EDITED_DATE
• Editor Field: LAST_EDITED_USER

Supports Query With Historic Moment: false

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