Name: Tree Maintenance RT

Display Field: NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 4ac2afa2bd1f4e75afcd583f59c88e57

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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

Feature Draw Order:

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: 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: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

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 )
• DateMaintained ( type: esriFieldTypeDate, alias: Date Maintained, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateMaintained )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MaintainedBy )
• NAME ( type: esriFieldTypeString, alias: Common Tree Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NAME , Coded Values: [Alaska Willow: Alaska Willow] , [Alaska-Cedar: Alaska-Cedar] , [Allegheny Chinkapin: Allegheny Chinkapin] , ...328 more... )
• GENUS ( type: esriFieldTypeString, alias: Tree Genus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GENUS , Coded Values: [Abies: Abies] , [Acacia: Acacia] , [Acer: Acer] , ...99 more... )
• SPECIES ( type: esriFieldTypeString, alias: Tree Species, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SPECIES , Coded Values: [Abies: Abies] , [Actinophylla: Actinophylla] , [Agrifolia: Agrifolia] , ...252 more... )
• TREEAGE ( type: esriFieldTypeSmallInteger, alias: Age, editable: true, nullable: true, defaultValue: null, modelName: TREEAGE )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• HEIGHT ( type: esriFieldTypeDouble, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: HEIGHT )
• TRUNKHEIGHT ( type: esriFieldTypeDouble, alias: Trunk Height, editable: true, nullable: true, defaultValue: null, modelName: TRUNKHEIGHT )
• TRUNKDIAM ( type: esriFieldTypeDouble, alias: Trunk Diameter, editable: true, nullable: true, defaultValue: null, modelName: TRUNKDIAM )
• CANOPYSHP ( type: esriFieldTypeString, alias: Shape of Canopy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CANOPYSHP , Coded Values: [Cone: Cone] , [Cylindrical: Cylindrical] , [Sphere: Sphere] , ...2 more... )
• WIRES ( type: esriFieldTypeString, alias: Wires Present, editable: true, nullable: true, length: 5, defaultValue: null, modelName: WIRES , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: OWNEDBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: null, modelName: MAINTBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• GENERALSIZE ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 16, defaultValue: null, modelName: GENERALSIZE , Coded Values: [Small: Small] , [Medium: Medium] , [Large: Large] )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LinkedFiles ( type: esriFieldTypeString, alias: Linked Files, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: LinkedFiles )
• RelatedGlobalID ( type: esriFieldTypeGUID, alias: Related Global ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelatedGlobalID )
• Pruning ( type: esriFieldTypeString, alias: Pruning, editable: true, nullable: true, length: 255, defaultValue: No, modelName: Pruning , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SuckerRemoval ( type: esriFieldTypeString, alias: SuckerRemoval, editable: true, nullable: true, length: 255, defaultValue: No, modelName: SuckerRemoval , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DeadwoodRemoval ( type: esriFieldTypeString, alias: DeadwoodRemoval, editable: true, nullable: true, length: 255, defaultValue: No, modelName: DeadwoodRemoval , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• StructuralTraining ( type: esriFieldTypeString, alias: Structural Training, editable: true, nullable: true, length: 255, defaultValue: No, modelName: StructuralTraining , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• PestInspectionAndTreatment ( type: esriFieldTypeString, alias: Pest Inspection and Treatment, editable: true, nullable: true, length: 255, defaultValue: No, modelName: PestInspectionAndTreatment , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• IrrigationAdjustments ( type: esriFieldTypeString, alias: Irrigation Adjustments, editable: true, nullable: true, length: 255, defaultValue: No, modelName: IrrigationAdjustments , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• MulchWork ( type: esriFieldTypeString, alias: Mulch Work, editable: true, nullable: true, length: 255, defaultValue: No, modelName: MulchWork , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• GeneralConditionAssessments ( type: esriFieldTypeString, alias: General Condition Assessments, editable: true, nullable: true, length: 255, defaultValue: No, modelName: GeneralConditionAssessments , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )

Templates:

• Name: Tree Maintenance RT
  Description:
  Prototype:
  MulchWork: No
  GeneralConditionAssessments: No
  DateMaintained: null
  MaintainedBy: null
  NAME: null
  GENUS: null
  SPECIES: null
  TREEAGE: null
  DIAMETER: null
  HEIGHT: null
  TRUNKHEIGHT: null
  TRUNKDIAM: null
  CANOPYSHP: null
  WIRES: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  GENERALSIZE: null
  FACILITYID: null
  INSTALLDATE: null
  LinkedFiles: null
  RelatedGlobalID: null
  Pruning: No
  SuckerRemoval: No
  DeadwoodRemoval: No
  StructuralTraining: No
  PestInspectionAndTreatment: No
  IrrigationAdjustments: No
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.Trees (0) -- Related To: Trees (44)

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

Sync Can Return Changes: false

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

Child Resources:

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