View In:   ArcGIS Online Map Viewer

Name: Columbus Trees

Display Field: STR_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This map layer shows the location of public-owned trees in Columbus. These trees are on public property such as parks, public grounds, and street right-of-way. The Columbus Recreation and Parks Department Urban Forestry program is responsible for the planting, inspection, pruning, and removal of these trees.</SPAN></P></DIV></DIV></DIV>

Copyright Text: City of Columbus, Recreation and Parks Department, Urban Forestry

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1777238.7870355546
YMin: 661253.0562956482
XMax: 1894864.3723219782
YMax: 827881.2489572316
Spatial Reference: 103130  (6551)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [47, 147, 38, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• SITE_CLASS ( type: esriFieldTypeSmallInteger, alias: SITE_CLASS, editable: true, nullable: true, defaultValue: null, modelName: SITE_CLASS , Coded Values: [1: Street] , [11: Street Island] , [12: Unimproved ROW] , ...6 more... )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRESS )
• ZIP ( type: esriFieldTypeString, alias: ZIP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ZIP )
• DIAM_BREAST_HEIGHT ( type: esriFieldTypeSmallInteger, alias: DBH, editable: true, nullable: true, defaultValue: null, modelName: DBH )
• MAINTENANCE ( type: esriFieldTypeString, alias: Last Maintenance, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINTENANCE , Coded Values: [1: Inspection] , [2: Planting] , [3: Pruning] , ...2 more... )
• DISORDERS ( type: esriFieldTypeString, alias: DISORDERS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DISORDERS , Coded Values: [1: Herbicide Damage] , [2: Insects] , [3: Disease] , ...4 more... )
• PLANTING_DATE ( type: esriFieldTypeDate, alias: PLANTING_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLANTING_DATE )
• INSPECTION_DATE ( type: esriFieldTypeDate, alias: INSPECTION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPECTION_DATE )
• RETIRED ( type: esriFieldTypeDate, alias: RETIRED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RETIRED )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMENTS )
• CONDITION1 ( type: esriFieldTypeSmallInteger, alias: CONDITION, editable: true, nullable: true, defaultValue: null, modelName: CONDITION1 , Coded Values: [0: Dead] , [1: Poor] , [2: Fair] , ...2 more... )
• PLANNING_AREA ( type: esriFieldTypeString, alias: Forestry Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PLANNING_AREA , Coded Values: [01: 01] , [02A: 02A] , [02B: 02B] , ...73 more... )
• PARK ( type: esriFieldTypeString, alias: Park Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PARK )
• PRIORITY1 ( type: esriFieldTypeSmallInteger, alias: PRIORITY, editable: true, nullable: true, defaultValue: null, modelName: PRIORITY1 , Coded Values: [-1: Tree Emergency] , [0: ASAP (<3 Weeks)] , [1: Priority 1 (<9 Months)] , ...2 more... )
• SP_CODE ( type: esriFieldTypeString, alias: SP_CODE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SP_CODE , Coded Values: [AIAL: Ailanthus (Tree of Heaven)] , [ALGL: Alder, European, Black] , [ALCO: Alder, Italian] , ...501 more... )
• LUCITYLINK ( type: esriFieldTypeInteger, alias: LUCITYLINK, editable: true, nullable: true, defaultValue: null, modelName: LUCITYLINK )
• TREE_ID ( type: esriFieldTypeString, alias: TREE_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TREE_ID )
• ADDR_NUM ( type: esriFieldTypeString, alias: Address Number, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ADDR_NUM )
• STR_PRE_DIR ( type: esriFieldTypeString, alias: Street Prefix Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STR_PRE_DIR )
• STR_NAME ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STR_NAME )
• STR_TYPE ( type: esriFieldTypeString, alias: Street Type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: STR_TYPE )
• STR_SUF_DIR ( type: esriFieldTypeString, alias: Street Suffix Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STR_SUF_DIR )
• HEIGHT ( type: esriFieldTypeSingle, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: HEIGHT )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• DRG_UNIQUEID ( type: esriFieldTypeString, alias: DRG Unique ID, editable: true, nullable: true, length: 18, defaultValue: null, modelName: DRG_UNIQUEID )
• CULTIVAR ( type: esriFieldTypeString, alias: Cultivar, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CULTIVAR )
• ADDR_COLS_KEY ( type: esriFieldTypeInteger, alias: ADDR_COLS_KEY, editable: true, nullable: true, defaultValue: null, modelName: ADDR_COLS_KEY )
• STR_SEG_UNIQ ( type: esriFieldTypeString, alias: STR_SEG_UNIQ, editable: true, nullable: true, length: 40, defaultValue: null, modelName: STR_SEG_UNIQ )
• NEAR_PARCELID ( type: esriFieldTypeString, alias: NEAR_PARCELID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEAR_PARCELID )
• CRPD_PROP_ID ( type: esriFieldTypeInteger, alias: CRPD_PROP_ID, editable: true, nullable: true, defaultValue: null, modelName: CRPD_PROP_ID )
• STATUS ( type: esriFieldTypeSmallInteger, alias: STATUS, editable: true, nullable: true, defaultValue: null, modelName: STATUS , Coded Values: [1: Vacant] , [11: Assigned] , [2: Active] , ...3 more... )
• NEXT_MAINTENANCE ( type: esriFieldTypeString, alias: NEXT_MAINTENANCE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: NEXT_MAINTENANCE , Coded Values: [1: Inspection] , [2: Planting] , [3: Pruning] , ...2 more... )
• WO_NUMBER ( type: esriFieldTypeString, alias: Work Order Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WO_NUMBER )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Columbus Trees
  Description:
  Prototype:
  WO_NUMBER: null
  SITE_CLASS: null
  ADDRESS: null
  ZIP: null
  DIAM_BREAST_HEIGHT: null
  MAINTENANCE: null
  DISORDERS: null
  PLANTING_DATE: null
  INSPECTION_DATE: null
  RETIRED: null
  COMMENTS: null
  CONDITION1: null
  PLANNING_AREA: null
  PARK: null
  PRIORITY1: null
  SP_CODE: null
  LUCITYLINK: null
  TREE_ID: null
  ADDR_NUM: null
  STR_PRE_DIR: null
  STR_NAME: null
  STR_TYPE: null
  STR_SUF_DIR: null
  HEIGHT: null
  NEXT_MAINTENANCE: null
  DRG_UNIQUEID: null
  CULTIVAR: null
  ADDR_COLS_KEY: null
  STR_SEG_UNIQ: null
  NEAR_PARCELID: null
  CRPD_PROP_ID: null
  STATUS: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Sync,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata