Name: MasterGIS.DBO.CITYTREEINSPECTION

Display Field: Hindrance

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 6aa89326238f4718b62901485c8cacfb

Copyright Text:

Default Visibility: false

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: true
Supports Returning Query Extent: true
Supports Query With Distance: true
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• INSPECTIONDATE ( type: esriFieldTypeDate, alias: LAST INSPECTED, editable: true, nullable: false, length: 8, defaultValue: null, modelName: INSPECTIONDATE )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Hindrance ( type: esriFieldTypeString, alias: Hindrance to Tree, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Hindrance , Coded Values: [POWERLINE: POWERLINE] , [BUILDING: BUILDING] , [HYDRANT: HYDRANT] , ...1 more... )
• DBH ( type: esriFieldTypeString, alias: Diameter At Breast Height, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DBH , 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), editable: true, nullable: true, defaultValue: null, modelName: Tip_Dieback )
• TotalCrownCon ( type: esriFieldTypeDouble, alias: TotalCrownCon, editable: true, nullable: true, defaultValue: null, modelName: TotalCrownCon )
• CrownCondDrpDwn ( type: esriFieldTypeString, alias: Crown Condition List, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CrownCondDrpDwn , 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), editable: true, nullable: true, defaultValue: null, modelName: ExpsdDecayedWood )
• SproutsSuckers ( type: esriFieldTypeDouble, alias: Sprouts/Suckers (Deduct up to .5pts), editable: true, nullable: true, defaultValue: null, modelName: SproutsSuckers )
• IncldbranchUnions ( type: esriFieldTypeDouble, alias: Included Branch Unions (up to .5pts), editable: true, nullable: true, defaultValue: null, modelName: IncldbranchUnions )
• StemCondTotal ( type: esriFieldTypeDouble, alias: Stem Condition Total, editable: true, nullable: true, defaultValue: null, modelName: StemCondTotal )
• Diseased ( type: esriFieldTypeString, alias: Diseased, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Diseased , Coded Values: [YES: YES] , [NO: NO] )
• TreeDefects ( type: esriFieldTypeString, alias: Tree Defects, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TreeDefects , 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProposedMaint , Coded Values: [PRUNING: PRUNING] , [DESEASE TREATMENT: DISEASE TREATMENT] , [REMOVAL: REMOVAL] )
• MaintTaken ( type: esriFieldTypeString, alias: Maintenance Taken, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintTaken , Coded Values: [PRUNING: PRUNING] , [DISEASE TREATMENT: DISEASE TREATMENT] , [REMOVED: REMOVED] , ...2 more... )
• MaintDate ( type: esriFieldTypeDate, alias: MaintDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MaintDate )
• Field_Notes ( type: esriFieldTypeString, alias: Field Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Field_Notes )
• Office_Notes ( type: esriFieldTypeString, alias: Office Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Office_Notes )
• StagHead2 ( type: esriFieldTypeDouble, alias: Stagheading Deduct up to 1pt, editable: true, nullable: true, defaultValue: null, modelName: StagHead2 )
• Symmetry2 ( type: esriFieldTypeDouble, alias: Symmetry deduct up to 1pt, editable: true, nullable: true, defaultValue: null, modelName: Symmetry2 )
• LCR2 ( type: esriFieldTypeDouble, alias: Live Crown Ratio Deduct up to 2pts, editable: true, nullable: true, defaultValue: null, modelName: LCR2 )
• CambrialInteg2 ( type: esriFieldTypeDouble, alias: Cambrial Integrety Deduct up to 3pts, editable: true, nullable: true, defaultValue: null, modelName: CambrialInteg2 )
• StemCracks2 ( type: esriFieldTypeDouble, alias: Stem Cracks Deduct up to 2pts, editable: true, nullable: true, defaultValue: null, modelName: StemCracks2 )
• StemConditionDropDown ( type: esriFieldTypeString, alias: Stem Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StemConditionDropDown , 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defects1 , 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defects2 , 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defects3 , 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), editable: true, nullable: true, defaultValue: null, modelName: CrownWdth )

Templates:

• Name: MasterGIS.DBO.CITYTREEINSPECTION
  Description:
  Prototype:
  Defects3: null
  Defects2: null
  INSPECTIONDATE: -2209161600000
  GUID: null
  CrownWdth: null
  Hindrance: null
  DBH: null
  Tip_Dieback: null
  TotalCrownCon: null
  CrownCondDrpDwn: null
  ExpsdDecayedWood: null
  SproutsSuckers: null
  IncldbranchUnions: null
  StemCondTotal: null
  Diseased: null
  TreeDefects: null
  ProposedMaint: null
  MaintTaken: null
  MaintDate: null
  Field_Notes: null
  Office_Notes: null
  StagHead2: null
  Symmetry2: null
  LCR2: null
  CambrialInteg2: null
  StemCracks2: null
  StemConditionDropDown: null
  Defects1: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata