Name: MasterGIS.DBO.CITYTREEINSPECTION

Display Field: Hindrance

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: d38bf781abe84b2ebffa26ffcee12617

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• INSPECTIONDATE ( type: esriFieldTypeDate, alias: LAST INSPECTED, length: 8 )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Hindrance ( type: esriFieldTypeString, alias: Hindrance to Tree, length: 50 , Coded Values: [POWERLINE: POWERLINE] , [BUILDING: BUILDING] , [HYDRANT: HYDRANT] , ...1 more... )
• DBH ( type: esriFieldTypeString, alias: Diameter At Breast Height, length: 50 , Coded Values: [DBH < 3: DBH < 3] , [DBH 3 - 6: DBH 3 - 6] , [DBH 7 - 12: DBH 7 - 12] , ...6 more... )
• Tip_Dieback ( type: esriFieldTypeDouble, alias: Tip Dieback (deduct up to .5 point) )
• TotalCrownCon ( type: esriFieldTypeDouble, alias: TotalCrownCon )
• CrownCondDrpDwn ( type: esriFieldTypeString, alias: Crown Condition List, length: 50 , Coded Values: [BETWEEN 0 - 1: BETWEEN 0 - 1] , [BETWEEN 1 - 2: BETWEEN 1 - 2] , [BETWEEN 2 - 3: BETWEEN 2 - 3] , ...1 more... )
• ExpsdDecayedWood ( type: esriFieldTypeDouble, alias: Exposed/Decayed Wood (Deduct .25pt min) )
• SproutsSuckers ( type: esriFieldTypeDouble, alias: Sprouts/Suckers (Deduct up to .5pts) )
• IncldbranchUnions ( type: esriFieldTypeDouble, alias: Included Branch Unions (up to .5pts) )
• StemCondTotal ( type: esriFieldTypeDouble, alias: Stem Condition Total )
• Diseased ( type: esriFieldTypeString, alias: Diseased, length: 50 , Coded Values: [YES: YES] , [NO: NO] )
• TreeDefects ( type: esriFieldTypeString, alias: Tree Defects, length: 50 , Coded Values: [INCLUDED BARK: INCLUDED BARK] , [CO-DOMINANT LEADERS: CO-DOMINANT LEADERS] , [TIP DIE-BACK: TIP DIE-BACK] , ...7 more... )
• ProposedMaint ( type: esriFieldTypeString, alias: Proposed Maintenance, length: 50 , Coded Values: [PRUNING: PRUNING] , [DESEASE TREATMENT: DISEASE TREATMENT] , [REMOVAL: REMOVAL] )
• MaintTaken ( type: esriFieldTypeString, alias: Maintenance Taken, length: 50 , Coded Values: [PRUNING: PRUNING] , [DISEASE TREATMENT: DISEASE TREATMENT] , [REMOVED: REMOVED] , ...2 more... )
• MaintDate ( type: esriFieldTypeDate, alias: MaintDate, length: 8 )
• Field_Notes ( type: esriFieldTypeString, alias: Field Notes, length: 500 )
• Office_Notes ( type: esriFieldTypeString, alias: Office Notes, length: 250 )
• StagHead2 ( type: esriFieldTypeDouble, alias: Stagheading Deduct up to 1pt )
• Symmetry2 ( type: esriFieldTypeDouble, alias: Symmetry deduct up to 1pt )
• LCR2 ( type: esriFieldTypeDouble, alias: Live Crown Ratio Deduct up to 2pts )
• CambrialInteg2 ( type: esriFieldTypeDouble, alias: Cambrial Integrety Deduct up to 3pts )
• StemCracks2 ( type: esriFieldTypeDouble, alias: Stem Cracks Deduct up to 2pts )
• StemConditionDropDown ( type: esriFieldTypeString, alias: Stem Condition, length: 50 , Coded Values: [BETWEEN 0 - 1: BETWEEN 0 - 1] , [BETWEEN 1 - 2: BETWEEN 1 - 2] , [BETWEEN 2 - 3: BETWEEN 2 - 3] , ...1 more... )
• Defects1 ( type: esriFieldTypeString, alias: Defects1, length: 50 , Coded Values: [INCLUDED BARK: INCLUDED BARK] , [CO-DOMINANT LEADERS: CO-DOMINANT LEADERS] , [TIP DIE-BACK: TIP DIE-BACK] , ...7 more... )
• Defects2 ( type: esriFieldTypeString, alias: Defects2, length: 50 , Coded Values: [INCLUDED BARK: INCLUDED BARK] , [CO-DOMINANT LEADERS: CO-DOMINANT LEADERS] , [TIP DIE-BACK: TIP DIE-BACK] , ...7 more... )
• Defects3 ( type: esriFieldTypeString, alias: Defects3, length: 50 , Coded Values: [INCLUDED BARK: INCLUDED BARK] , [CO-DOMINANT LEADERS: CO-DOMINANT LEADERS] , [TIP DIE-BACK: TIP DIE-BACK] , ...7 more... )
• CrownWdth ( type: esriFieldTypeDouble, alias: Crown Width (ft) )

Relationships:

• City_Trees (0) -- Related To: Tree (0)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata