View In:   ArcGIS Online Map Viewer

Name: Public Owned Trees

Display Field: STR_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: 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.

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

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 1777204.0120596455
YMin: 661253.0430705871
XMax: 1894864.4102192656
YMax: 828820.3049941325
Spatial Reference: 103130  (6551)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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

Type ID Field:

Fields:

• 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 )
• 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 )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• 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... )
• 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] , ...75 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: [2TB: Unknown dead hardwood] , [2TE: Unknown dead conifer] , [2TREE: Unlnown or other live tree] , ...303 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 )

Templates:

• Name: Public Owned Trees
  Description:
  Prototype:
  DRG_UNIQUEID: null
  CULTIVAR: null
  ADDR_COLS_KEY: null
  STR_SEG_UNIQ: null
  NEAR_PARCELID: null
  CRPD_PROP_ID: null
  STATUS: null
  NEXT_MAINTENANCE: null
  WO_NUMBER: null
  STR_SUF_DIR: null
  STR_TYPE: null
  STR_NAME: null
  STR_PRE_DIR: null
  HEIGHT: null
  SITE_CLASS: null
  ADDRESS: null
  ZIP: null
  DIAM_BREAST_HEIGHT: null
  MAINTENANCE: 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
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata