Name: Inspections

Display Field: inspecttype

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• inspecttype (type: esriFieldTypeString, alias: Inspection type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Tree: Tree], [Planting Space: Planting Space], [Tree and Planting Space: Tree and Planting Space], ... 3 more ...)
• inspectdate (type: esriFieldTypeDate, alias: Inspection date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [In Progress: In Progress], [Completed: Completed], [Paused: Paused], ... 1 more ...)
• treecondition (type: esriFieldTypeSmallInteger, alias: Tree condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Dead], [2: Poor], ... 3 more ...)
• spacecondition (type: esriFieldTypeSmallInteger, alias: Planting space condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Very Poor], [2: Poor], ... 3 more ...)
• sidewalkcondition (type: esriFieldTypeSmallInteger, alias: Sidewalk condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Very Poor], [2: Poor], ... 3 more ...)
• pests (type: esriFieldTypeString, alias: Evidence of pests, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• disease (type: esriFieldTypeString, alias: Evidence of disease, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• sidewalkdamage (type: esriFieldTypeString, alias: Sidewalk damage, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• notes (type: esriFieldTypeString, alias: Inspection notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• assetglobalid (type: esriFieldTypeGUID, alias: Tree GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• plantingareaglobalid (type: esriFieldTypeGUID, alias: Planting Area GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• plantingareacondition (type: esriFieldTypeSmallInteger, alias: Planting Area condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Very Poor], [2: Poor], ... 3 more ...)

Templates:

Name: Inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Trees (1) -- Related To: Trees (0)
• PlantingAreas (3) -- Related To: Planting Areas (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/15/2025 9:46:10 PM

Schema Last Edit Date: 11/25/2024 3:42:55 PM

Data Last Edit Date: 7/15/2025 9:46:10 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat