Name: NPDES.INSP_TREE

Display Field: REPORTING_YEAR

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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

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 )
• INSP_TREE_ID ( type: esriFieldTypeGUID , alias: INSP_TREE_ID , editable: true , nullable: true , length: 38 )
• REPORTING_YEAR ( type: esriFieldTypeString , alias: REPORTING_YEAR , editable: true , nullable: true , length: 4 )
• MDE_COMMENTS ( type: esriFieldTypeString , alias: MDE_COMMENTS , editable: true , nullable: true , length: 255 )
• ADTNL_COMMENTS ( type: esriFieldTypeString , alias: ADTNL_COMMENTS , editable: true , nullable: true , length: 1073741822 )
• TREE_INFO_ID ( type: esriFieldTypeGUID , alias: TREE_INFO_ID , editable: true , nullable: true , length: 38 )
• TREE_INSPECTION_ID ( type: esriFieldTypeGUID , alias: TREE_INSPECTION_ID , editable: true , nullable: true , length: 38 )
• INSPECTION_DATE ( type: esriFieldTypeDate , alias: INSPECTION_DATE , editable: true , nullable: true , length: 8 )
• INSPECTED_BY ( type: esriFieldTypeString , alias: INSPECTED_BY , editable: true , nullable: true , length: 50 )
• INV_SPECIES_THREAT_HIGH ( type: esriFieldTypeString , alias: INV_SPECIES_THREAT_HIGH , editable: true , nullable: true , length: 200 , 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 , 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 , 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 )
• INSPECTION_STATUS ( type: esriFieldTypeString , alias: INSPECTION_STATUS , editable: true , nullable: false , length: 10 , Coded Values: [True: True] , [False: False] )
• LIVE_TREES_LT_2INDBH ( type: esriFieldTypeSmallInteger , alias: LIVE_TREES_LT_2INDBH , editable: true , nullable: true )
• LIVE_TREES_GT_2INDBH ( type: esriFieldTypeSmallInteger , alias: LIVE_TREES_GT_2INDBH , editable: true , nullable: true )
• MAINT_REQUIRED ( type: esriFieldTypeString , alias: MAINT_REQUIRED , editable: true , nullable: true , length: 10 , Coded Values: [True: True] , [False: False] )
• MAINT_REQUIRED_COMMENT ( type: esriFieldTypeString , alias: MAINT_REQUIRED_COMMENT , editable: true , nullable: true , length: 500 )
• MAINT_PERFORMED ( type: esriFieldTypeString , alias: MAINT_PERFORMED , editable: true , nullable: true , length: 10 , Coded Values: [True: True] , [False: False] )
• MAINT_PERFORMED_COMMENT ( type: esriFieldTypeString , alias: MAINT_PERFORMED_COMMENT , editable: true , nullable: true , length: 500 )
• CROWN_CONDITION ( type: esriFieldTypeString , alias: CROWN_CONDITION , editable: true , nullable: true , length: 50 , 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 , 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 , 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 , Coded Values: [Rabbits: Rabbits] , [Voles: Voles] , [Other: Other] , ...2 more... )
• EVIDENCE_HUMAN ( type: esriFieldTypeString , alias: EVIDENCE_HUMAN , editable: true , nullable: true , length: 50 , 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 , 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 , 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 , 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 )
• DEAD_TREE_COUNT ( type: esriFieldTypeSmallInteger , alias: DEAD_TREE_COUNT , editable: true , nullable: true )
• INSPECTION_NOTES ( type: esriFieldTypeString , alias: INSPECTION_NOTES , editable: true , nullable: true , length: 500 )
• MISSING_TREE_COUNT ( type: esriFieldTypeSmallInteger , alias: MISSING_TREE_COUNT , editable: true , nullable: true )
• TREES_DELTA ( type: esriFieldTypeSmallInteger , alias: TREES_DELTA , editable: true , nullable: true )
• ACRES_PASS ( type: esriFieldTypeDouble , alias: ACRES_PASS , editable: true , nullable: true )
• ACRES_FAIL ( type: esriFieldTypeDouble , alias: ACRES_FAIL , editable: true , nullable: true )
• ACRES_DELTA ( type: esriFieldTypeDouble , alias: ACRES_DELTA , editable: true , nullable: true )
• ABIOTIC_DAMAGE ( type: esriFieldTypeString , alias: ABIOTIC_DAMAGE , editable: true , nullable: true , length: 30 , 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 )
• EQUIPMENT_CONDITION ( type: esriFieldTypeString , alias: EQUIPMENT_CONDITION , editable: true , nullable: true , length: 50 , 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 , 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 )
• GLOBALID ( type: esriFieldTypeGlobalID , alias: GLOBALID , editable: false , nullable: false , length: 38 )
• PLANTING_STRATEGY ( type: esriFieldTypeString , alias: PLANTING_STRATEGY , editable: true , nullable: true , length: 50 , 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... )

Templates:

• Name: NPDES.INSP_TREE
  Description:
  Prototype:
  TREE_AREA_ID: null
  PLANTING_STRATEGY: 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: Create,Query,Update,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 Related Records   Apply Edits   Add Features   Update Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata