Name: UFA.TREE_SWEETGUM_STUDY

Display Field: GENUS_NAME

Type: Table

Geometry Type: N/A

Description:

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
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 )
• PLANT_SEASON ( type: esriFieldTypeString, alias: PLANT_SEASON, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PLANT_SEASON , Coded Values: [FY 2011: FY 2011] , [FY 2012: FY 2012] , [FY 2013: FY 2013] , ...9 more... )
• PLANT_SPACE ( type: esriFieldTypeString, alias: PLANT_SPACE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PLANT_SPACE , Coded Values: [Tree box: Tree box] , [Planting strip: Planting strip] , [Planting strip w/bumpout: Planting strip w/bumpout] , ...2 more... )
• LID ( type: esriFieldTypeString, alias: LID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LID , Coded Values: [Tree located in LID: Tree located in LID] , [Root zone located in LID: Root zone located in LID] , [No access to LID: No access to LID] , ...1 more... )
• SIDEWALK ( type: esriFieldTypeInteger, alias: SIDEWALK, editable: true, nullable: true, defaultValue: null, modelName: SIDEWALK , Coded Values: [1: Yes] , [2: No] )
• PARKING_LANE ( type: esriFieldTypeInteger, alias: PARKING_LANE, editable: true, nullable: true, defaultValue: null, modelName: PARKING_LANE , Coded Values: [1: Yes] , [2: No] )
• TREE_FENCE ( type: esriFieldTypeInteger, alias: TREE_FENCE, editable: true, nullable: true, defaultValue: null, modelName: TREE_FENCE , Coded Values: [1: Yes] , [2: No] )
• RAISE_SURROUND ( type: esriFieldTypeInteger, alias: RAISE_SURROUND, editable: true, nullable: true, defaultValue: null, modelName: RAISE_SURROUND , Coded Values: [1: Yes] , [2: No] )
• RECENT_CONSTRUCTION ( type: esriFieldTypeInteger, alias: RECENT_CONSTRUCTION, editable: true, nullable: true, defaultValue: null, modelName: RECENT_CONSTRUCTION , Coded Values: [1: Yes] , [2: No] )
• TREE_STATUS ( type: esriFieldTypeString, alias: TREE_STATUS, editable: true, nullable: true, length: 25, defaultValue: Present, modelName: SPACER1 , Coded Values: [Present: Present] , [Absent: Absent] )
• ADDITIONAL_STEWARDSHIP ( type: esriFieldTypeInteger, alias: ADDITIONAL_STEWARDSHIP, editable: true, nullable: true, defaultValue: null, modelName: ADDITIONAL_STEWARDSHIP , Coded Values: [1: Yes] , [2: No] )
• SPACER2 ( type: esriFieldTypeString, alias: SPACER2, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SPACER2 )
• ROOT_FLARE_VISIBLE ( type: esriFieldTypeInteger, alias: ROOT_FLARE_VISIBLE, editable: true, nullable: true, defaultValue: null, modelName: ROOT_FLARE_VISIBLE , Coded Values: [1: Yes] , [2: No] )
• GROUND_COVER ( type: esriFieldTypeString, alias: GROUND_COVER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GROUND_COVER , Coded Values: [Turf: Turf] , [Mulch: Mulch] , [Plantings: Plantings] , ...1 more... )
• PHYSICAL_DAMAGE ( type: esriFieldTypeString, alias: PHYSICAL_DAMAGE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PHYSICAL_DAMAGE , Coded Values: [Severe: Severe] , [Moderate: Moderate] , [Minor: Minor] , ...1 more... )
• SPACER3 ( type: esriFieldTypeString, alias: SPACER3, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SPACER3 )
• SOIL_COMPACTION ( type: esriFieldTypeInteger, alias: SOIL_COMPACTION, editable: true, nullable: true, defaultValue: null, modelName: SOIL_COMPACTION , Coded Values: [1: Yes] , [2: No] )
• TREE_STRESS ( type: esriFieldTypeString, alias: TREE_STRESS, editable: true, nullable: true, length: 50, defaultValue: None, modelName: TREE_STRESS , Coded Values: [None: None] , [Dieback 10%-30%: Dieback 10%-30%] , [Dieback>30%: Dieback>30%] , ...3 more... )
• ENVIRO_STRESS ( type: esriFieldTypeString, alias: ENVIRO_STRESS, editable: true, nullable: true, length: 50, defaultValue: None, modelName: ENVIRO_STRESS , Coded Values: [None: None] , [Frost cracks: Frost cracks] , [Lightning strike: Lightning strike] , ...5 more... )
• SPACER4 ( type: esriFieldTypeString, alias: SPACER4, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SPACER4 )
• DEFOLIATION ( type: esriFieldTypeString, alias: DEFOLIATION, editable: true, nullable: true, length: 50, defaultValue: None, modelName: DEFOLIATION , Coded Values: [None: None] , [leaf miners>10%: leaf miners>10%] , [leaf miners>30%: leaf miners>30%] , ...3 more... )
• DISCOLOR_FOILIAGE ( type: esriFieldTypeString, alias: DISCOLOR_FOILIAGE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DISCOLOR_FOILIAGE , Coded Values: [None: None] , [Mottling: Mottling] , [Marginal scorching: Marginal scorching] , ...9 more... )
• ABNORMAL_FOILIAGE ( type: esriFieldTypeString, alias: ABNORMAL_FOILIAGE, editable: true, nullable: true, length: 50, defaultValue: None, modelName: ABNORMAL_FOILIAGE , Coded Values: [None: None] , [Witches broom: Witches broom] , [Other: Other] , ...1 more... )
• INSECT_SIGN_FOILIAGE ( type: esriFieldTypeString, alias: INSECT_SIGN_FOILIAGE, editable: true, nullable: true, length: 50, defaultValue: None, modelName: INSECT_SIGN_FOILIAGE , Coded Values: [None: None] , [Beetles feeding on foiliage: Beetles feeding on foiliage] , [Aphids: Aphids] , ...5 more... )
• FOILIAGE_AFFECTED ( type: esriFieldTypeString, alias: FOILIAGE_AFFECTED, editable: true, nullable: true, length: 30, defaultValue: None, modelName: FOILIAGE_AFFECTED , Coded Values: [None: None] , [10-30% crown affected: 10-30% crown affected] , [>30% crown affected: >30% crown affected] , ...1 more... )
• SPACER5 ( type: esriFieldTypeString, alias: SPACER5, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SPACER5 )
• INSECT_SIGN_BRANCHBOLE ( type: esriFieldTypeString, alias: INSECT_SIGN_BRANCHBOLE, editable: true, nullable: true, length: 30, defaultValue: None, modelName: INSECT_SIGN_BRANCHBOLE , Coded Values: [None: None] , [Frass: Frass] , [D-shaped exit holes: D-shaped exit holes] , ...5 more... )
• INSECT_PRESENCE ( type: esriFieldTypeString, alias: INSECT_PRESENCE, editable: true, nullable: true, length: 25, defaultValue: None, modelName: INSECT_PRESENCE , Coded Values: [None: None] , [Caterpillars: Caterpillars] , [Beetles: Beetles] , ...3 more... )
• DISEASE_SIGN ( type: esriFieldTypeString, alias: DISEASE_SIGN, editable: true, nullable: true, length: 30, defaultValue: None, modelName: DISEASE_SIGN , Coded Values: [None: None] , [Decay: Decay] , [Conks: Conks] , ...5 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• TREE_ID ( type: esriFieldTypeGUID, alias: TREE_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TREE_ID )
• FRUITING_BODY_PRESENT ( type: esriFieldTypeString, alias: FRUITING_BODY_PRESENT, editable: true, nullable: true, length: 50, defaultValue: None, modelName: FRUITING_BODY_PRESENT , Coded Values: [None: None] , [Ganoderma applanatum: Ganoderma applanatum] , [Ganaderma lucidum: Ganaderma lucidum] , ...9 more... )
• PROBLEM_LOCATION ( type: esriFieldTypeString, alias: PROBLEM_LOCATION, editable: true, nullable: true, length: 25, defaultValue: None, modelName: PROBLEM_LOCATION , Coded Values: [None: None] , [Branches: Branches] , [Bole: Bole] , ...1 more... )
• LOOSE_BARK ( type: esriFieldTypeString, alias: LOOSE_BARK, editable: true, nullable: true, length: 30, defaultValue: None, modelName: LOOSE_BARK , Coded Values: [None: None] , [Loose bark only: Loose bark only] , [Rhizomorphs present: Rhizomorphs present] , ...3 more... )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• TREE_CONDITION ( type: esriFieldTypeString, alias: TREE_CONDITION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TREE_CONDITION , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• CONDITION_DATE ( type: esriFieldTypeDate, alias: CONDITION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITION_DATE )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 150, defaultValue: null, modelName: NOTES )
• SCI_NM ( type: esriFieldTypeString, alias: SCI_NM, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SCI_NM , Coded Values: [Acer buergerianum: Acer buergerianum] , [Acer campestre: Acer campestre] , [Acer ginnala: Acer ginnala] , ...302 more... )
• CMMN_NM ( type: esriFieldTypeString, alias: CMMN_NM, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CMMN_NM , Coded Values: [Abrovitae: Abrovitae] , [Accolade elm: Accolade elm] , [Adirondack Crabapple: Adirondack Crabapple] , ...307 more... )
• GENUS_NAME ( type: esriFieldTypeString, alias: GENUS_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: GENUS_NAME , Coded Values: [Acer: Acer] , [Aescululs: Aescululs] , [Aesculus: Aesculus] , ...77 more... )

Templates:

• Name: UFA.TREE_SWEETGUM_STUDY
  Description:
  Prototype:
  CMMN_NM: null
  SCI_NM: null
  PLANT_SEASON: null
  PLANT_SPACE: null
  LID: null
  SIDEWALK: null
  PARKING_LANE: null
  TREE_FENCE: null
  RAISE_SURROUND: null
  RECENT_CONSTRUCTION: null
  TREE_STATUS: Present
  ADDITIONAL_STEWARDSHIP: null
  SPACER2: null
  ROOT_FLARE_VISIBLE: null
  GROUND_COVER: null
  PHYSICAL_DAMAGE: null
  SPACER3: null
  SOIL_COMPACTION: null
  TREE_STRESS: None
  ENVIRO_STRESS: None
  SPACER4: null
  DEFOLIATION: None
  DISCOLOR_FOILIAGE: null
  ABNORMAL_FOILIAGE: None
  INSECT_SIGN_FOILIAGE: None
  FOILIAGE_AFFECTED: None
  SPACER5: null
  INSECT_SIGN_BRANCHBOLE: None
  INSECT_PRESENCE: None
  DISEASE_SIGN: None
  GENUS_NAME: null
  TREE_ID: null
  FRUITING_BODY_PRESENT: None
  PROBLEM_LOCATION: None
  LOOSE_BARK: None
  NOTES: null
  CONDITION_DATE: null
  TREE_CONDITION: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• UFATrees (0) -- Related To: UFA Trees (1)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

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