View In:   ArcGIS Online Map Viewer

Name: Tree_SD

Display Field: common_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset includes point features for all public trees within the City of San Diego. The data is compiled from the City's records and includes details necessary for associating maintenance work with each tree. Tree locations are periodically updated to reflect the most current information from recent maintenance activities and arboricultural assessments. Users are encouraged to contact the City of San Diego's Street Division if discrepancies are found between dataset attributes and physical observations.

Service Item Id: 0e33167a4f9a4b9e9be7495aaf9b4764

Copyright Text: This layer was created and is maintained by the City of San Diego's Transportation Department. Data sources include SanGIS, city records, aerial imagery, and field surveys. The data was processed and managed using ArcGIS software from Esri.

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

Extent:

XMin: 6244823.026306465
YMin: 1778262.4349297285
XMax: 6352761.970861226
YMax: 1985039.1722940654
Spatial Reference: 102646  (2230)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [64, 102, 160, 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:

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: true
Supports Query With LOD Spatial Reference: true
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:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• gisid ( modelName: GISID, nullable: true, editable: true, defaultValue: null, length: 15, alias: GIS ID, type: esriFieldTypeString )
• sapid ( modelName: SAPID, nullable: true, editable: true, defaultValue: null, length: 20, alias: SAP ID, type: esriFieldTypeString )
• eqpid ( modelName: EQPID, nullable: true, editable: true, defaultValue: null, alias: Equipment ID, type: esriFieldTypeDouble )
• common_name ( modelName: SPECIES, nullable: true, editable: true, defaultValue: null, length: 30, alias: Common Name, type: esriFieldTypeString )
• cdcode ( modelName: CDCODE, nullable: true, editable: true, defaultValue: null, alias: CDCODE, type: esriFieldTypeSmallInteger , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• code ( modelName: CODE, nullable: true, editable: true, defaultValue: null, alias: CODE, type: esriFieldTypeSmallInteger , Coded Values: [1: NORTHERN] , [3: SOUTHERN] )
• location ( modelName: LOCATION, nullable: true, editable: true, defaultValue: null, length: 150, alias: LOCATION, type: esriFieldTypeString )
• condition ( modelName: CONDITION, nullable: true, editable: true, defaultValue: null, length: 20, alias: CONDITION, type: esriFieldTypeString , Coded Values: [1: GOOD] , [2: FAIR] , [3: POOR] , ...1 more... )
• stem_type ( modelName: STEM_TYPE, nullable: true, editable: true, defaultValue: null, length: 20, alias: STEM_TYPE, type: esriFieldTypeString )
• protection ( modelName: PROTECTION, nullable: true, editable: true, defaultValue: null, alias: PROTECTION, type: esriFieldTypeSmallInteger , Coded Values: [0: NONE] , [1: LANDMARK] , [2: HERITAGE] , ...2 more... )
• inspctdate ( modelName: INSPCTDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: INSPCTDATE, type: esriFieldTypeDate )
• where_installed ( modelName: WHRINSTALL, nullable: true, editable: true, defaultValue: null, length: 40, alias: WHERE_INSTALLED, type: esriFieldTypeString )
• cpcode ( modelName: CommPlan, nullable: true, editable: true, defaultValue: null, alias: CPCODE, type: esriFieldTypeSmallInteger , Coded Values: [1: Balboa Park] , [2: Barrio Logan] , [13: Black Mountain Ranch] , ...55 more... )
• landmark ( modelName: LANDMARK, nullable: true, editable: true, defaultValue: null, length: 8, alias: LANDMARK, type: esriFieldTypeString , Coded Values: [Y: YES] , [N: NO] , [U: UNKNOWN] )
• heritage ( modelName: HERITAGE, nullable: true, editable: true, defaultValue: null, length: 8, alias: HERITAGE, type: esriFieldTypeString , Coded Values: [Y: YES] , [N: NO] , [U: UNKNOWN] )
• parkway ( modelName: PARKWAY, nullable: true, editable: true, defaultValue: null, length: 8, alias: PARKWAY, type: esriFieldTypeString , Coded Values: [Y: YES] , [N: NO] , [U: UNKNOWN] )
• preservation ( modelName: PRESERVATION, nullable: true, editable: true, defaultValue: null, length: 8, alias: PRESERVATION, type: esriFieldTypeString , Coded Values: [Y: YES] , [N: NO] , [U: UNKNOWN] )
• iamfloc ( modelName: IAMFLOC, nullable: true, editable: true, defaultValue: null, length: 30, alias: IAMFLOC, type: esriFieldTypeString )
• sapobjnr ( modelName: SAPOBJNR, nullable: true, editable: true, defaultValue: null, length: 22, alias: SAPOBJNR, type: esriFieldTypeString )
• mapng_stat_cd ( modelName: MAPNG_STAT_CD, nullable: true, editable: true, defaultValue: AB, length: 2, alias: MAPNG_STAT_CD, type: esriFieldTypeString , Coded Values: [AB: AS BUILT] , [AN: ABANDONED] , [OP: OPERATIONAL] , ...2 more... )
• loc_desc ( modelName: LOC_DESC, nullable: true, editable: true, defaultValue: null, length: 100, alias: LOC_DESC, type: esriFieldTypeString )
• inst_yr ( modelName: INST_YR, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: INST_YR, type: esriFieldTypeDate )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• dbh_in ( modelName: DBH_IN, nullable: true, editable: true, defaultValue: null, alias: DBH_IN, type: esriFieldTypeSmallInteger )
• height_ft ( modelName: HEIGHT_FT, nullable: true, editable: true, defaultValue: null, alias: HEIGHT_FT, type: esriFieldTypeSmallInteger )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• storm_id ( modelName: STORM_ID, nullable: true, editable: true, defaultValue: null, alias: STORM_ID, type: esriFieldTypeSmallInteger , Coded Values: [1: Storm Area 1] , [2: Storm Area 2] , [3: Storm Area 3] , ...10 more... )
• maint ( modelName: MAINT, nullable: true, editable: true, defaultValue: null, length: 1, alias: Maintained By, type: esriFieldTypeString , Coded Values: [1: CITY OF SAN DIEGO, STREET DIV] , [2: CITY OF SAN DIEGO, PARK & REC] , [3: CITY OF SAN DIEGO, METRO WASTEWATER] , ...18 more... )
• species_name ( modelName: species_name, nullable: true, editable: true, defaultValue: null, length: 50, alias: Biological Species, type: esriFieldTypeString )
• clearance ( modelName: clearance, nullable: true, editable: true, defaultValue: null, length: 25, alias: Clearance, type: esriFieldTypeString )
• oh_util ( modelName: oh_util, nullable: true, editable: true, defaultValue: null, length: 3, alias: Overhead Utilities, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] , [NA: NA] )
• space_cond ( modelName: space_cond, nullable: true, editable: true, defaultValue: null, length: 30, alias: Space Condition, type: esriFieldTypeString )
• space_size ( modelName: space_size, nullable: true, editable: true, defaultValue: null, alias: Space Size, type: esriFieldTypeSmallInteger )
• side ( modelName: side, nullable: true, editable: true, defaultValue: null, length: 10, alias: SIDE, type: esriFieldTypeString )
• nbhd ( modelName: nbhd, nullable: true, editable: true, defaultValue: null, length: 30, alias: Neighborhood, type: esriFieldTypeString )
• prime_defect ( modelName: prime_defect, nullable: true, editable: true, defaultValue: null, length: 35, alias: Prime Defect, type: esriFieldTypeString )
• sec_defect ( modelName: sec_defect, nullable: true, editable: true, defaultValue: null, length: 35, alias: Secondary Defect, type: esriFieldTypeString )
• pest_patho ( modelName: pest_patho, nullable: true, editable: true, defaultValue: null, length: 3, alias: Pests and Pathogens, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] , [NA: NA] )
• on_str ( modelName: on_str, nullable: true, editable: true, defaultValue: null, length: 35, alias: On Street, type: esriFieldTypeString )
• x ( modelName: x, nullable: true, editable: true, defaultValue: null, alias: X, type: esriFieldTypeDouble )
• y ( modelName: y, nullable: true, editable: true, defaultValue: null, alias: Y, type: esriFieldTypeDouble )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )

Templates:

• Name: Tree_SD
  Description:
  Prototype:
  code: null
  nbhd: null
  species_name: null
  latitude: null
  inspctdate: null
  space_size: null
  protection: null
  iamfloc: null
  prime_defect: null
  pest_patho: null
  cdcode: null
  preservation: null
  cpcode: null
  sapobjnr: null
  oh_util: null
  clearance: null
  last_edited_date: null
  eqpid: null
  common_name: null
  landmark: null
  loc_desc: null
  inst_yr: null
  longitude: null
  dbh_in: null
  height_ft: null
  side: null
  created_user: null
  heritage: null
  storm_id: null
  gisid: null
  last_edited_user: null
  condition: null
  on_str: null
  maint: null
  space_cond: null
  mapng_stat_cd: AB
  x: null
  y: null
  location: null
  sec_defect: null
  created_date: null
  stem_type: null
  parkway: null
  where_installed: null
  sapid: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata