View In:   ArcGIS Online Map Viewer

Name: Public Shade Trees

Display Field: roadname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: a83a02bc2ee748eea1f5f3d24820d0e9

Copyright Text:

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: -7926133.7193
YMin: 5220931.660599999
XMax: -7918495.8113
YMax: 5226531.932800002
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: 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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• assetid ( modelName: assetid, nullable: true, editable: true, defaultValue: null, length: 25, alias: Tree ID, type: esriFieldTypeString )
• addrnum ( modelName: addrnum, nullable: true, editable: true, defaultValue: null, length: 25, alias: Closest Address Number, type: esriFieldTypeString )
• roadname ( modelName: roadname, nullable: true, editable: true, defaultValue: null, length: 75, alias: Closest Road Name, type: esriFieldTypeString , Coded Values: [ABERDEEN RD: ABERDEEN RD] , [ACADEMY ST: ACADEMY ST] , [ACORN PK: ACORN PK] , ...612 more... )
• commonname ( modelName: commonname, nullable: true, editable: true, defaultValue: null, length: 50, alias: Common Name, type: esriFieldTypeString , Coded Values: [Alaska-Cedar: Alaska-Cedar] , [Allegheny Chinkapin: Allegheny Chinkapin] , [Alligator Juniper: Alligator Juniper] , ...384 more... )
• genus ( modelName: genus, nullable: true, editable: true, defaultValue: null, length: 25, alias: Genus, type: esriFieldTypeString , Coded Values: [Abies: Abies] , [Acacia: Acacia] , [Acer: Acer] , ...117 more... )
• species ( modelName: species, nullable: true, editable: true, defaultValue: null, length: 25, alias: Species, type: esriFieldTypeString , Coded Values: [Abies: Abies] , [Acerifolia: Acerifolia] , [Actinophylla: Actinophylla] , ...281 more... )
• cultivar ( modelName: cultivar, nullable: true, editable: true, defaultValue: null, length: 50, alias: Cultivated Variety, type: esriFieldTypeString )
• dbh ( modelName: dbh, nullable: true, editable: true, defaultValue: null, alias: Diameter at Breast Height (Inches), type: esriFieldTypeDouble )
• height ( modelName: height, nullable: true, editable: true, defaultValue: null, alias: Height (ft), type: esriFieldTypeDouble )
• spacestatus ( modelName: spacestatus, nullable: true, editable: true, defaultValue: null, length: 25, alias: Tree Space Status, type: esriFieldTypeString , Coded Values: [Available: Available] , [Planted: Planted] , [Stump: Stump] , ...3 more... )
• spacematerial ( modelName: spacematerial, nullable: true, editable: true, defaultValue: null, length: 11, alias: Tree Space Material, type: esriFieldTypeString , Coded Values: [Bark: Bark] , [Brick: Brick] , [Grass: Grass] , ...6 more... )
• spacetype ( modelName: spacetype, nullable: true, editable: true, defaultValue: null, length: 25, alias: Tree Location Type, type: esriFieldTypeString , Coded Values: [Circle: Traffic circle] , [Curb: Curb] , [Island: Traffic island] , ...4 more... )
• installdate ( modelName: installdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Installation Date, type: esriFieldTypeDate )
• maintdate ( modelName: maintdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Maintenance Date, type: esriFieldTypeDate )
• removeddate ( modelName: removeddate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Removed, type: esriFieldTypeDate )
• overheadutilities ( modelName: overheadutilities, nullable: true, editable: true, defaultValue: null, length: 3, alias: Overhead Utilities (Y/N), type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• historicdistrict ( modelName: historicdistrict, nullable: true, editable: true, defaultValue: null, length: 50, alias: Historic District, type: esriFieldTypeString )
• floodzone ( modelName: floodzone, nullable: true, editable: true, defaultValue: null, length: 3, alias: 100yr Flood Zone (Y/N), type: esriFieldTypeString , Coded Values: [No: No] , [Yes: Yes] )
• notes ( modelName: notes, nullable: true, editable: true, defaultValue: null, length: 255, alias: Notes, type: esriFieldTypeString )
• ownedby ( modelName: ownedby, nullable: true, editable: true, defaultValue: null, length: 25, alias: Owned By, type: esriFieldTypeString )
• maintby ( modelName: maintby, nullable: true, editable: true, defaultValue: null, length: 25, alias: Maintained By, type: esriFieldTypeString , Coded Values: [Cemetery Staff: Cemetery Staff] , [Conservation Staff: Conservation Staff] , [Parks Staff: Parks Staff] , ...2 more... )
• stormwater ( modelName: stormwater, nullable: true, editable: true, defaultValue: null, alias: Stormwater Intercepted (gal/yr), type: esriFieldTypeDouble )
• energy ( modelName: energy, nullable: true, editable: true, defaultValue: null, alias: Energy Conserved (kWh/yr), type: esriFieldTypeDouble )
• pollutants ( modelName: pollutants, nullable: true, editable: true, defaultValue: null, alias: Air Pollutants Removed (lbs/yr), type: esriFieldTypeDouble )
• co2 ( modelName: co2, nullable: true, editable: true, defaultValue: null, alias: Carbon Dioxide Reduced (lbs/yr), type: esriFieldTypeDouble )
• propertyvalue ( modelName: propertyvalue, nullable: true, editable: true, defaultValue: null, alias: Increased Property Value ($), type: esriFieldTypeDouble )
• benefits ( modelName: benefits, nullable: true, editable: true, defaultValue: null, alias: Total Value of Benefits ($), type: esriFieldTypeDouble )
• spatialsource ( modelName: spatialsource, nullable: true, editable: true, defaultValue: null, length: 25, alias: Spatial Source, type: esriFieldTypeString , Coded Values: [CAD: CAD] , [Digitized: Digitized] , [Unknown: Unknown] , ...3 more... )
• spatialconfidence ( modelName: spatialconfidence, nullable: true, editable: true, defaultValue: null, length: 25, alias: Spatial Confidence, type: esriFieldTypeString , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] , ...1 more... )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 50, alias: Created By, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Created Date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 50, alias: Edited By, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Edited Date, type: esriFieldTypeDate )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )

Templates:

• Name: Public Shade Trees
  Description:
  Prototype:
  benefits: null
  historicdistrict: null
  installdate: null
  notes: null
  propertyvalue: null
  co2: null
  spatialsource: null
  floodzone: null
  commonname: null
  spacematerial: null
  ownedby: null
  height: null
  energy: null
  addrnum: null
  maintdate: null
  dbh: null
  stormwater: null
  pollutants: null
  removeddate: null
  overheadutilities: null
  spacetype: null
  cultivar: null
  genus: null
  species: null
  spatialconfidence: null
  assetid: null
  maintby: null
  spacestatus: null
  roadname: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• GIS.Tree_PestTreatment_tbl (0) -- Related To: Tree Pest Treatment (5)
• GIS.Tree_Inspection_tbl (1) -- Related To: Tree Inspections (3)
• GIS.Tree_Adoption_tbl (2) -- Related To: Adopt a Tree (2)
• GIS.TreeSpace_pt (3) -- Related To: Planting Space (1)

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

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 Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata