Name: DC Tree Structure and Benefits

Display Field: GENUS_NAME

Type: Table

Geometry Type: N/A

Description: DC 2022 LiDAR was used and processed using the “Extract Trees using Cluster Analysis” script which is included as part of Esri’s 3D Basemap solution. All LiDAR-derived trees within 2 meters of a Urban Forestry Division tree were removed as being duplicates.Tree diameter (DBH, in inches) was estimated for the LiDAR-derived trees from calculated tree height (in feet) based on the equation: DBH = 0.4003*height - 1.9557. This equation was derived from a statistical analysis of a detailed park inventory tree data set and has an R^2 = 0.7418.Extreme outliers were also modified, with any DBH larger than 80 inches being converted to a DBH of 80 inches.The combined data set was processed using the USDA Forest Service i-Tree eco software, where structure and environmental benefits were estimated.

Copyright Text: District Department of Transportation

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: false
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: true
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: null

Fields:

• NLCD_LAND_COVER ( type: esriFieldTypeString, alias: Landcover Category (FIA Stratus), length: 90 )
• ICODE ( type: esriFieldTypeString, alias: iCode Tree Species identification code, length: 255 )
• STATUS ( type: esriFieldTypeString, alias: Tree Status, length: 10 )
• TREE_ID ( type: esriFieldTypeInteger, alias: Tree Identifier )
• SMD_ID ( type: esriFieldTypeString, alias: Single Member District Identifier, length: 16 )
• ANC_ID ( type: esriFieldTypeString, alias: Advisory Neighborhood Commission Identifier, length: 254 )
• ARBORIST ( type: esriFieldTypeString, alias: Arborist, length: 50 )
• OWNERSHIP ( type: esriFieldTypeString, alias: Ownership, length: 255 )
• DBH ( type: esriFieldTypeDouble, alias: DBH (in) )
• HEIGHT ( type: esriFieldTypeDouble, alias: Height (ft) )
• CROWN_HEIGHT ( type: esriFieldTypeDouble, alias: Crown Height (ft) )
• CROWN_WIDTH ( type: esriFieldTypeDouble, alias: Crown Width (ft) )
• CANOPY_COVER ( type: esriFieldTypeDouble, alias: Canopy Cover (ft²) )
• LEAF_AREA ( type: esriFieldTypeDouble, alias: Leaf Area (ft²) )
• LEAF_BIOMASS ( type: esriFieldTypeDouble, alias: Leaf Biomass (lb) )
• LEAF_AREA_INDEX ( type: esriFieldTypeDouble, alias: Leaf Area Index )
• BASAL_AREA ( type: esriFieldTypeDouble, alias: Basal Area (ft²) )
• REPLACEMENT_VALUE ( type: esriFieldTypeDouble, alias: Replacement Value ($) )
• CARBON_STORAGE ( type: esriFieldTypeDouble, alias: Carbon Storage (lb) )
• CARBON_STORAGE_COST ( type: esriFieldTypeDouble, alias: Carbon Storage ($) )
• GROSS_CARBON_SEQUESTRATION ( type: esriFieldTypeDouble, alias: Gross Carbon Sequestration (lb/yr) )
• GROSS_CARBON_SEQ_COST ( type: esriFieldTypeDouble, alias: Gross Carbon Sequestration ($/yr) )
• AVOIDED_RUNOFF ( type: esriFieldTypeDouble, alias: Avoided Runoff (ft^3/yr) )
• AVOIDED_RUNOFF_COST ( type: esriFieldTypeDouble, alias: Avoided Runoff ($/yr) )
• POLLUTION_REMOVAL ( type: esriFieldTypeDouble, alias: Pollution Removal (oz/yr) )
• POLLUTION_REMOVAL_COST ( type: esriFieldTypeDouble, alias: Pollution Removal ($/yr) )
• TOTAL_ANNUAL_BENEFITS ( type: esriFieldTypeDouble, alias: Total Annual Benefits ($/yr) )
• CARBON_AVOIDED ( type: esriFieldTypeDouble, alias: Carbon Avoided (lb/yr) )
• CARBON_AVOIDED_COST ( type: esriFieldTypeDouble, alias: Carbon Avoided ($/yr) )
• ENERGY_SAVINGS ( type: esriFieldTypeDouble, alias: Energy Savings ($/yr) )
• FOREST_PATCH_TYPE ( type: esriFieldTypeString, alias: Forest_Patch_Type, length: 256 )
• FOREST_PATCH_ID ( type: esriFieldTypeInteger, alias: Forest_Patch_Id )
• GENUS_NAME ( type: esriFieldTypeString, alias: Genus Name, length: 255 )
• COMMON_NAME ( type: esriFieldTypeString, alias: Common Name, length: 255 )
• SCIENTIFIC_NAME ( type: esriFieldTypeString, alias: Scientific Name, length: 255 )
• WARD_ID ( type: esriFieldTypeString, alias: Ward Identifier, length: 15 )
• DC_HPN_CODE ( type: esriFieldTypeString, alias: DC Health Planning Neighborhoods Code, length: 3 )
• TRACT_2010 ( type: esriFieldTypeString, alias: Census Tract ID (2010), length: 80 )
• GIS_ID ( type: esriFieldTypeString, alias: GIS Identifier, length: 255 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• DCGIS.StreetTreeLidarPt (0) -- Related To: DC Trees (11)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata