Name: Inspections
Display Field: inspecttype
Type: Table
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:
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: true)
- created_date (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- 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:
Relationships:
- Back_to_Trees (0) -- Related To: Trees (0)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/18/2024 7:04:18 PM
Schema Last Edit Date: 10/18/2024 7:04:18 PM
Data Last Edit Date: 10/18/2024 7:04:18 PM
Supported Operations:
Query
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