Name: INSP_TREE

Display Field: REPORTING_YEAR

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

HasZ: false

HasM: false

Time Info:

Start Time Field: INSPECTION_DATE
End Time Field: null
Track ID Field: null
Time Extent:
[2005/09/30 04:00:00 UTC, 2020/05/14 21:42:39 UTC]

Time Reference:
Time Zone: Eastern Standard Time
Respects Daylight Saving: true

Time Interval: 2
Time Interval Units: esriTimeUnitsMonths
Has Live Data: false
Export Options:
Use Time: true
Time Data Cumulative: false
Time Offset: 0 (esriTimeUnitsYears)

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• INSP_TREE_ID ( type: esriFieldTypeGUID, alias: INSP_TREE_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: INSP_TREE_ID )
• REPORTING_YEAR ( type: esriFieldTypeString, alias: REPORTING_YEAR, editable: true, nullable: true, length: 4, defaultValue: null, modelName: REPORTING_YEAR )
• MDE_COMMENTS ( type: esriFieldTypeString, alias: MDE_COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GEN_COMMENTS )
• ADTNL_COMMENTS ( type: esriFieldTypeString, alias: ADTNL_COMMENTS, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ADTNL_COMMENTS )
• TREE_INFO_ID ( type: esriFieldTypeGUID, alias: TREE_INFO_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TREE_INFO_ID )
• TREE_INSPECTION_ID ( type: esriFieldTypeGUID, alias: TREE_INSPECTION_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TREE_INSPECTION_ID )
• INSPECTION_DATE ( type: esriFieldTypeDate, alias: INSPECTION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPECTION_DATE )
• INSPECTED_BY ( type: esriFieldTypeString, alias: INSPECTED_BY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTED_BY )
• INV_SPECIES_THREAT_HIGH ( type: esriFieldTypeString, alias: INV_SPECIES_THREAT_HIGH, editable: true, nullable: true, length: 200, defaultValue: null, modelName: INV_SPECIES_THREAT_HIGH , Coded Values: [Thistle (Cirsium spp.): Thistle (Cirsium spp.)] , [Autumn Olive (Elaeagnus umbellata): Autumn Olive (Elaeagnus umbellata)] , [Mile-A-Minute (Polygonum perfoliatum): Mile-A-Minute (Polygonum perfoliatum)] , ...31 more... )
• INV_SPECIES_THREAT_MED ( type: esriFieldTypeString, alias: INV_SPECIES_THREAT_MED, editable: true, nullable: true, length: 200, defaultValue: null, modelName: INV_SPECIES_THREAT_MED , Coded Values: [Thistle (Cirsium spp.): Thistle (Cirsium spp.)] , [Autumn Olive (Elaeagnus umbellata): Autumn Olive (Elaeagnus umbellata)] , [Mile-A-Minute (Polygonum perfoliatum): Mile-A-Minute (Polygonum perfoliatum)] , ...31 more... )
• INV_SPECIES_THREAT_LOW ( type: esriFieldTypeString, alias: INV_SPECIES_THREAT_LOW, editable: true, nullable: true, length: 200, defaultValue: null, modelName: INV_SPECIES_THREAT_LOW , Coded Values: [Thistle (Cirsium spp.): Thistle (Cirsium spp.)] , [Autumn Olive (Elaeagnus umbellata): Autumn Olive (Elaeagnus umbellata)] , [Mile-A-Minute (Polygonum perfoliatum): Mile-A-Minute (Polygonum perfoliatum)] , ...31 more... )
• LIVE_TREES_COUNT ( type: esriFieldTypeSmallInteger, alias: LIVE_TREES_COUNT, editable: true, nullable: true, defaultValue: null, modelName: LIVE_TREES_COUNT )
• INSPECTION_STATUS ( type: esriFieldTypeString, alias: INSPECTION_STATUS, editable: true, nullable: false, length: 10, defaultValue: null, modelName: INSPECTION_STATUS , Coded Values: [True: True] , [False: False] )
• LIVE_TREES_LT_2INDBH ( type: esriFieldTypeSmallInteger, alias: LIVE_TREES_LT_2INDBH, editable: true, nullable: true, defaultValue: null, modelName: LIVE_TREES_LT_2INDBH )
• LIVE_TREES_GT_2INDBH ( type: esriFieldTypeSmallInteger, alias: LIVE_TREES_GT_2INDBH, editable: true, nullable: true, defaultValue: null, modelName: LIVE_TREES_GT_2INDBH )
• MAINT_REQUIRED ( type: esriFieldTypeString, alias: MAINT_REQUIRED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAINT_REQUIRED , Coded Values: [True: True] , [False: False] )
• MAINT_REQUIRED_COMMENT ( type: esriFieldTypeString, alias: MAINT_REQUIRED_COMMENT, editable: true, nullable: true, length: 500, defaultValue: null, modelName: MAINT_REQUIRED_COMMENT )
• MAINT_PERFORMED ( type: esriFieldTypeString, alias: MAINT_PERFORMED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAINT_PERFORMED , Coded Values: [True: True] , [False: False] )
• MAINT_PERFORMED_COMMENT ( type: esriFieldTypeString, alias: MAINT_PERFORMED_COMMENT, editable: true, nullable: true, length: 500, defaultValue: null, modelName: MAINT_PERFORMED_COMMENT )
• CROWN_CONDITION ( type: esriFieldTypeString, alias: CROWN_CONDITION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CROWN_CONDITION , Coded Values: [Moderate Defoliation: Moderate Defoliation] , [Premature Leaf Fall: Premature Leaf Fall] , [Leaves Wilted: Leaves Wilted] , ...5 more... )
• EVIDENCE_PESTS ( type: esriFieldTypeString, alias: EVIDENCE_PESTS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EVIDENCE_PESTS , Coded Values: [Gypsy Moth: Gypsy Moth] , [Scale: Scale] , [None Present: None Present] , ...9 more... )
• EVIDENCE_DISEASE ( type: esriFieldTypeString, alias: EVIDENCE_DISEASE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EVIDENCE_DISEASE , Coded Values: [Leaf Spot: Leaf Spot] , [Decline: Decline] , [Bleeding Canker: Bleeding Canker] , ...9 more... )
• EVIDENCE_ANIMAL ( type: esriFieldTypeString, alias: EVIDENCE_ANIMAL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EVIDENCE_ANIMAL , Coded Values: [Rabbits: Rabbits] , [Voles: Voles] , [Other: Other] , ...2 more... )
• EVIDENCE_HUMAN ( type: esriFieldTypeString, alias: EVIDENCE_HUMAN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EVIDENCE_HUMAN , Coded Values: [Mowing Damage: Mowing Damage] , [Herbicide Damage: Herbicide Damage] , [None Present: None Present] , ...1 more... )
• SHELTER_CONDITION ( type: esriFieldTypeString, alias: SHELTER_CONDITION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SHELTER_CONDITION , Coded Values: [Shelters Good: Shelters Good] , [Shelters Damaged: Shelters Damaged] , [Shelters Lose: Shelters Lose] , ...1 more... )
• MORTALITY_PATTERN ( type: esriFieldTypeString, alias: MORTALITY_PATTERN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MORTALITY_PATTERN , Coded Values: [Yes - Location Specific: Yes - Location Specific] , [Yes - Species Specific: Yes - Species Specific] , [No: No] )
• TREE_GROWTH ( type: esriFieldTypeString, alias: TREE_GROWTH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TREE_GROWTH , Coded Values: [Stunted Growth: Stunted Growth] , [Re-Sprouting: Re-Sprouting] , [Normal Tree Growth: Normal Tree Growth] )
• SURVIVAL_RATE ( type: esriFieldTypeDouble, alias: SURVIVAL_RATE, editable: true, nullable: true, defaultValue: null, modelName: SURVIVAL_RATE )
• DEAD_TREE_COUNT ( type: esriFieldTypeSmallInteger, alias: DEAD_TREE_COUNT, editable: true, nullable: true, defaultValue: null, modelName: DEAD_TREE_COUNT )
• INSPECTION_NOTES ( type: esriFieldTypeString, alias: INSPECTION_NOTES, editable: true, nullable: true, length: 500, defaultValue: null, modelName: INSPECTION_NOTES )
• MISSING_TREE_COUNT ( type: esriFieldTypeSmallInteger, alias: MISSING_TREE_COUNT, editable: true, nullable: true, defaultValue: null, modelName: MISSING_TREE_COUNT )
• TREES_DELTA ( type: esriFieldTypeSmallInteger, alias: TREES_DELTA, editable: true, nullable: true, defaultValue: null, modelName: TREES_DELTA )
• ACRES_PASS ( type: esriFieldTypeDouble, alias: ACRES_PASS, editable: true, nullable: true, defaultValue: null, modelName: ACRES_PASS )
• ACRES_FAIL ( type: esriFieldTypeDouble, alias: ACRES_FAIL, editable: true, nullable: true, defaultValue: null, modelName: ACRES_FAIL )
• ACRES_DELTA ( type: esriFieldTypeDouble, alias: ACRES_DELTA, editable: true, nullable: true, defaultValue: null, modelName: ACRES_DELTA )
• ABIOTIC_DAMAGE ( type: esriFieldTypeString, alias: ABIOTIC_DAMAGE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ABIOTIC_DAMAGE , Coded Values: [Leaves Curled: Leaves Curled] , [Leaves Chlorotic: Leaves Chlorotic] , [None Present: None Present] , ...2 more... )
• DBH ( type: esriFieldTypeDouble, alias: DBH, editable: true, nullable: true, defaultValue: null, modelName: DBH )
• EQUIPMENT_CONDITION ( type: esriFieldTypeString, alias: EQUIPMENT_CONDITION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EQUIPMENT_CONDITION , Coded Values: [Missing Mower Guard: Missing Mower Guard] , [Missing or Damaged Stakes: Missing or Damaged Stakes] , [Missing Bark Protector: Missing Bark Protector] , ...2 more... )
• TREE_CONDITION ( type: esriFieldTypeString, alias: TREE_CONDITION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TREE_CONDITION , Coded Values: [Major Defoliation: Major Defoliation] , [Good: Good] , [Major Damage To Trunk: Major Damage To Trunk] , ...2 more... )
• TREE_AREA_ID ( type: esriFieldTypeGUID, alias: TREE_AREA_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TREE_AREA_ID )
• PLANTING_STRATEGY ( type: esriFieldTypeString, alias: PLANTING_STRATEGY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PLANTING_STRATEGY , Coded Values: [Reforestation: Reforestation] , [Tree Canopy Expansion Over Turf Grass: Tree Canopy Expansion Over Turf Grass] , [Tree Canopy Over Impervious: Tree Canopy Over Impervious] , ...1 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: INSP_TREE
  Description:
  Prototype:
  PLANTING_STRATEGY: null
  TREE_AREA_ID: null
  INSP_TREE_ID: null
  REPORTING_YEAR: null
  MDE_COMMENTS: null
  ADTNL_COMMENTS: null
  TREE_INFO_ID: null
  TREE_INSPECTION_ID: null
  INSPECTION_DATE: null
  INSPECTED_BY: null
  INV_SPECIES_THREAT_HIGH: null
  INV_SPECIES_THREAT_MED: null
  INV_SPECIES_THREAT_LOW: null
  LIVE_TREES_COUNT: null
  INSPECTION_STATUS:
  LIVE_TREES_LT_2INDBH: null
  LIVE_TREES_GT_2INDBH: null
  MAINT_REQUIRED: null
  MAINT_REQUIRED_COMMENT: null
  MAINT_PERFORMED: null
  MAINT_PERFORMED_COMMENT: null
  CROWN_CONDITION: null
  EVIDENCE_PESTS: null
  EVIDENCE_DISEASE: null
  EVIDENCE_ANIMAL: null
  EVIDENCE_HUMAN: null
  SHELTER_CONDITION: null
  MORTALITY_PATTERN: null
  TREE_GROWTH: null
  SURVIVAL_RATE: null
  DEAD_TREE_COUNT: null
  INSPECTION_NOTES: null
  MISSING_TREE_COUNT: null
  TREES_DELTA: null
  ACRES_PASS: null
  ACRES_FAIL: null
  ACRES_DELTA: null
  ABIOTIC_DAMAGE: null
  DBH: null
  EQUIPMENT_CONDITION: null
  TREE_CONDITION: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• NPDES.TREE_AREAS (1) -- Related To: TREE_AREAS (1)

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