Name: Trees_inspections

Display Field: inspecttype

Type: Table

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: true

Sources

Description: AttributeJoin

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• 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], ... 2 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)
• globalid (type: esriFieldTypeGUID, 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)
• assetid (type: esriFieldTypeString, alias: Tree identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• fulladdr (type: esriFieldTypeString, alias: Nearest address, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• district (type: esriFieldTypeString, alias: District or neighborhood, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• commonname (type: esriFieldTypeString, alias: Common name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Alaska Willow: Alaska Willow], [Alaska-Cedar: Alaska-Cedar], [Allegheny Chinkapin: Allegheny Chinkapin], ... 328 more ...)
• genus (type: esriFieldTypeString, alias: Genus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Abies: Abies], [Acacia: Acacia], [Acer: Acer], ... 99 more ...)
• species (type: esriFieldTypeString, alias: Species, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Abies: Abies], [Actinophylla: Actinophylla], [Agrifolia: Agrifolia], ... 252 more ...)
• diameter (type: esriFieldTypeDouble, alias: Diameter at breast height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• height (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: Date planted, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• treewires (type: esriFieldTypeString, alias: Tree wires present, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• treeguard (type: esriFieldTypeString, alias: Tree guard present, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• heritage (type: esriFieldTypeString, alias: Heritage tree, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• overheadutilities (type: esriFieldTypeString, alias: Overhead utilities, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• warranty (type: esriFieldTypeString, alias: Warranty, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• warrantydate (type: esriFieldTypeDate, alias: Warranty date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• waterthroughdate (type: esriFieldTypeDate, alias: Water through date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• treenotes (type: esriFieldTypeString, alias: Tree notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• retiredate (type: esriFieldTypeDate, alias: Date retired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• spaceid (type: esriFieldTypeString, alias: Planting space identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• spacestatus (type: esriFieldTypeString, alias: Planting space status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Available: Available], [Planted: Planted], [Stump: Stump], ... 2 more ...)
• spacetype (type: esriFieldTypeString, alias: Planting space type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bark: Bark], [Brick: Brick], [Grass: Grass], ... 6 more ...)
• sitetype (type: esriFieldTypeString, alias: Site type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Circle: Traffic circle], [Curb: Curb], [Island: Traffic island], ... 4 more ...)
• spacewidth (type: esriFieldTypeDouble, alias: Planting space width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spacelength (type: esriFieldTypeDouble, alias: Planting space length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spacenotes (type: esriFieldTypeString, alias: Planting space notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• collectedby (type: esriFieldTypeSmallInteger, alias: Collected by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• publicview (type: esriFieldTypeString, alias: Publicly Visibile, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• globalid_1631127313954 (type: esriFieldTypeGUID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user_1631127313954 (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date_1631127313954 (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user_1631127313954 (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date_1631127313954 (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• stormwater (type: esriFieldTypeDouble, alias: Stormwater intercepted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• energy (type: esriFieldTypeDouble, alias: Energy conserved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pollutants (type: esriFieldTypeDouble, alias: Air pollutants removed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• co2 (type: esriFieldTypeDouble, alias: Carbon dioxide reduced, SQL Type: sqlTypeOther, nullable: true, editable: true)
• propvalue (type: esriFieldTypeDouble, alias: Increased property value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• benefits (type: esriFieldTypeDouble, alias: Total value of benefits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/8/2023 3:33:20 AM

Schema Last Edit Date: 11/8/2023 3:33:20 AM

Data Last Edit Date: 11/8/2023 3:33:20 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat