Tables:

Table: Trees_inspections_5f7aa1c394824711a3c14cda9b859405 (0)

Name: Trees_inspections_5f7aa1c394824711a3c14cda9b859405

Display Field: null

Type: Table

Geometry Type: N/A

Description:

Service Item Id: de4becb842734d3fbd3027fa7c7ebd2b

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• inspecttype ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Inspection type, type: esriFieldTypeString , Coded Values: [Tree: Tree] , [Planting Space: Planting Space] , [Tree and Planting Space: Tree and Planting Space] , ...3 more... )
• inspectdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Inspection date, type: esriFieldTypeDate )
• status ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Status, type: esriFieldTypeString , Coded Values: [In Progress: In Progress] , [Completed: Completed] , [Paused: Paused] , ...1 more... )
• treecondition ( nullable: true, editable: true, defaultValue: null, alias: Tree condition, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Dead] , [2: Poor] , ...3 more... )
• spacecondition ( nullable: true, editable: true, defaultValue: null, alias: Planting space condition, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Very Poor] , [2: Poor] , ...3 more... )
• sidewalkcondition ( nullable: true, editable: true, defaultValue: null, alias: Sidewalk condition, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Very Poor] , [2: Poor] , ...3 more... )
• pests ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Evidence of pests, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• disease ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Evidence of disease, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• sidewalkdamage ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Sidewalk damage, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• notes ( nullable: true, editable: true, defaultValue: null, length: 4000, alias: Inspection notes, type: esriFieldTypeString )
• assetglobalid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: Tree GlobalID, type: esriFieldTypeGUID )
• plantingareaglobalid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: Planting Area GlobalID, type: esriFieldTypeGUID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: Created By, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Created On, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: Last Edited By, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Last Edited On, type: esriFieldTypeDate )
• assetid ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Tree identifier, type: esriFieldTypeString )
• fulladdr ( nullable: true, editable: true, defaultValue: null, length: 250, alias: Nearest address, type: esriFieldTypeString )
• district ( nullable: true, editable: true, defaultValue: null, length: 255, alias: District or neighborhood, type: esriFieldTypeString )
• municipality ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Municipality, type: esriFieldTypeString )
• family ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Family, type: esriFieldTypeString , Coded Values: [Adoxaceae: Adoxaceae] , [Altingiaceae: Altingiaceae] , [Anacardiaceae: Anacardiaceae] , ...43 more... )
• genus ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Genus, type: esriFieldTypeString , Coded Values: [Abies: Abies] , [Acer: Acer] , [Aesculus: Aesculus] , ...102 more... )
• species ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Species, type: esriFieldTypeString , Coded Values: [Abies: Abies] , [Acerifolia: Acerifolia] , [Actinophyllum: Actinophyllum] , ...256 more... )
• cultivar ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Cultivar, type: esriFieldTypeString , Coded Values: [Princeton: Princeton] , [Valley Forge: Valley Forge] )
• commonname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Common name, type: esriFieldTypeString , Coded Values: [Alaska Willow: Alaska Willow] , [Alaska-Cedar: Alaska-Cedar] , [Allegheny Chinkapin: Allegheny Chinkapin] , ...333 more... )
• diameter ( nullable: true, editable: true, defaultValue: null, alias: Diameter at breast height, type: esriFieldTypeDouble )
• height ( nullable: true, editable: true, defaultValue: null, alias: Height, type: esriFieldTypeDouble )
• height_units ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Height Units, type: esriFieldTypeString , Coded Values: [Feet: Feet] , [Meters: Meters] )
• installdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date planted, type: esriFieldTypeDate )
• treewires ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Tree wires present, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• treeguard ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Tree guard present, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• designation ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Special designation, type: esriFieldTypeString , Coded Values: [Memorial: Memorial] , [Dedication: Dedication] , [Heritage: Heritage] )
• overheadutilities ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Overhead utilities, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• warranty ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Warranty, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• warrantydate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Warranty date, type: esriFieldTypeDate )
• waterthroughdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Water through date, type: esriFieldTypeDate )
• treenotes ( nullable: true, editable: true, defaultValue: null, length: 4000, alias: Tree notes, type: esriFieldTypeString )
• retiredate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date retired, type: esriFieldTypeDate )
• spaceid ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Planting space identifier, type: esriFieldTypeString )
• spacestatus ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Planting space status, type: esriFieldTypeString , Coded Values: [Available: Available] , [Planted: Planted] , [Stump: Stump] , ...2 more... )
• spacetype ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Planting space type, type: esriFieldTypeString , Coded Values: [Bark: Bark] , [Brick: Brick] , [Grass: Grass] , ...6 more... )
• sitetype ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Site type, type: esriFieldTypeString , Coded Values: [Circle: Traffic circle] , [Curb: Curb] , [Island: Traffic island] , ...4 more... )
• spacewidth ( nullable: true, editable: true, defaultValue: null, alias: Planting space width, type: esriFieldTypeDouble )
• spacelength ( nullable: true, editable: true, defaultValue: null, alias: Planting space length, type: esriFieldTypeDouble )
• spacenotes ( nullable: true, editable: true, defaultValue: null, length: 4000, alias: Planting space notes, type: esriFieldTypeString )
• ownedby ( nullable: true, editable: true, defaultValue: null, alias: Owned by, type: esriFieldTypeSmallInteger , Coded Values: [0: Our Agency] , [1: Private] , [2: Other] )
• maintby ( nullable: true, editable: true, defaultValue: null, alias: Maintained by, type: esriFieldTypeSmallInteger , Coded Values: [0: Our Agency] , [1: Private] , [2: Other] )
• collectedby ( nullable: true, editable: true, defaultValue: null, alias: Collected by, type: esriFieldTypeSmallInteger , Coded Values: [0: Our Agency] , [1: Private] , [2: Other] )
• publicview ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Publicly Visibile, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• stormwater ( nullable: true, editable: true, defaultValue: null, alias: Stormwater intercepted, type: esriFieldTypeDouble )
• energy ( nullable: true, editable: true, defaultValue: null, alias: Energy conserved, type: esriFieldTypeDouble )
• pollutants ( nullable: true, editable: true, defaultValue: null, alias: Air pollutants removed, type: esriFieldTypeDouble )
• co2 ( nullable: true, editable: true, defaultValue: null, alias: Carbon dioxide reduced, type: esriFieldTypeDouble )
• propvalue ( nullable: true, editable: true, defaultValue: null, alias: Increased property value, type: esriFieldTypeDouble )
• benefits ( nullable: true, editable: true, defaultValue: null, alias: Total value of benefits, type: esriFieldTypeDouble )
• adoptionstatus ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Adoption Status, type: esriFieldTypeString , Coded Values: [Available: Available] , [Adopted: Adopted] )
• adoptedby ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Adopted By, type: esriFieldTypeString )
• adoptedon ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Adopted On, type: esriFieldTypeDate )
• nickname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Nickname, type: esriFieldTypeString )
• globalid_1685048711702 ( nullable: false, editable: false, defaultValue: null, length: 38, alias: Global ID, type: esriFieldTypeGlobalID )
• created_user_1685048711702 ( nullable: true, editable: false, defaultValue: null, length: 255, alias: Created By, type: esriFieldTypeString )
• created_date_1685048711702 ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Created On, type: esriFieldTypeDate )
• last_edited_user_1685048711702 ( nullable: true, editable: false, defaultValue: null, length: 255, alias: Last Edited By, type: esriFieldTypeString )
• last_edited_date_1685048711702 ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Last Edited On, type: esriFieldTypeDate )
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )