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, 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:

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

Templates:

• Name: DC Tree Structure and Benefits
  Description:
  Prototype:
  GIS_ID: null
  NLCD_LAND_COVER: null
  ICODE: null
  STATUS: null
  TREE_ID: null
  SMD_ID: null
  ANC_ID: null
  ARBORIST: null
  OWNERSHIP: null
  DBH: null
  HEIGHT: null
  CROWN_HEIGHT: null
  CROWN_WIDTH: null
  CANOPY_COVER: null
  LEAF_AREA: null
  LEAF_BIOMASS: null
  LEAF_AREA_INDEX: null
  BASAL_AREA: null
  REPLACEMENT_VALUE: null
  CARBON_STORAGE: null
  CARBON_STORAGE_COST: null
  GROSS_CARBON_SEQUESTRATION: null
  GROSS_CARBON_SEQ_COST: null
  AVOIDED_RUNOFF: null
  AVOIDED_RUNOFF_COST: null
  POLLUTION_REMOVAL: null
  POLLUTION_REMOVAL_COST: null
  TOTAL_ANNUAL_BENEFITS: null
  CARBON_AVOIDED: null
  CARBON_AVOIDED_COST: null
  ENERGY_SAVINGS: null
  FOREST_PATCH_TYPE: null
  FOREST_PATCH_ID: null
  GENUS_NAME: null
  COMMON_NAME: null
  SCIENTIFIC_NAME: null
  WARD_ID: null
  DC_HPN_CODE: null
  TRACT_2010: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata