View In:   ArcGIS Online Map Viewer

Name: GISTrans.GISPUB.RCTreeInventory

Display Field: CommonName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 250000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: -1.0377488850529527E7
YMin: 5605913.371078437
XMax: -1.0350815265568817E7
YMax: 5641689.134631718
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 53, 128, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
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

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• HeightUnit ( type: esriFieldTypeString, alias: Height Units, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HeightUnit , Coded Values: [Feet: Feet] , [Meters: Meters] )
• created_user ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 254, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Created On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, editable: false, nullable: true, length: 254, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Project ( type: esriFieldTypeString, alias: Project, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Project , Coded Values: [1st Half Winter 2025: 1st Half Winter 2025] , [2025 Tree Removals RFB: 2025 Tree Removals RFB ] , [2nd Half Winter 2025: 2nd Half Winter 2025] , ...21 more... )
• TreeCondition ( type: esriFieldTypeString, alias: Tree Condition, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TreeCondition , Coded Values: [Planting Site: Planting Site] , [Dead: Dead] , [Stump: Stump] , ...6 more... )
• Recommendation ( type: esriFieldTypeString, alias: Recommendation, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Recommendation , Coded Values: [Available: Available] , [Planted: Planted] , [Remove: Remove] , ...6 more... )
• TreeStatus ( type: esriFieldTypeString, alias: Tree Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TreeStatus , Coded Values: [Inspected: Inspected] , [Submitted: Submitted] , [Scheduled: Scheduled] , ...2 more... )
• Cost ( type: esriFieldTypeDouble, alias: Cost, editable: true, nullable: true, defaultValue: null, modelName: Cost )
• Invoice ( type: esriFieldTypeString, alias: Invoice, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Invoice )
• DateCollected ( type: esriFieldTypeDate, alias: Date Collected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateCollected )
• ResidentTreating ( type: esriFieldTypeString, alias: Resident Treating, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ResidentTreating , Coded Values: [No: No] , [Yes: Yes] )
• LastTreatment ( type: esriFieldTypeString, alias: Last Treatment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LastTreatment )
• TreeCount ( type: esriFieldTypeInteger, alias: Tree Count, editable: true, nullable: true, defaultValue: null, modelName: TreeCount )
• AssetId ( type: esriFieldTypeString, alias: Tree Identifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetId )
• FullAddr ( type: esriFieldTypeString, alias: Nearest Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FullAddr )
• District ( type: esriFieldTypeString, alias: District or Neighborhood, editable: true, nullable: true, length: 254, defaultValue: null, modelName: District )
• Municipality ( type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Municipality )
• Family ( type: esriFieldTypeString, alias: Family, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Family , Coded Values: [Adoxaceae: Adoxaceae] , [Altingiaceae: Altingiaceae] , [Anacardiaceae: Anacardiaceae] , ...43 more... )
• Genus ( type: esriFieldTypeString, alias: Genus, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Genus , Coded Values: [Abies: Abies] , [Acer: Acer] , [Aesculus: Aesculus] , ...102 more... )
• Cultivar ( type: esriFieldTypeString, alias: Cultivar, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Cultivar , Coded Values: [Princeton: Princeton] , [Valley Forge: Valley Forge] )
• CommonName ( type: esriFieldTypeString, alias: Common Name, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CommonName , Coded Values: [American Elm: American Elm] , [Balsam Poplar: Balsam Poplar] , [Basswood: Basswood] , ...83 more... )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter at breast height, editable: true, nullable: true, defaultValue: null, modelName: Diameter )
• Height ( type: esriFieldTypeDouble, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: Height )
• InstallDate ( type: esriFieldTypeDate, alias: Date planted, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• TreeWires ( type: esriFieldTypeString, alias: Tree Wires, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TreeWires , Coded Values: [Yes: Yes] , [No: No] )
• TreeGuard ( type: esriFieldTypeString, alias: Tree Guard, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TreeGuard , Coded Values: [Yes: Yes] , [No: No] )
• Designation ( type: esriFieldTypeString, alias: Special designation, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Designation , Coded Values: [Memorial: Memorial] , [Dedication: Dedication] , [Heritage: Heritage] )
• OverheadUtilities ( type: esriFieldTypeString, alias: Overhead Utilities, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OverheadUtilities , Coded Values: [Yes: Yes] , [No: No] )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Warranty , Coded Values: [Yes: Yes] , [No: No] )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate )
• WaterThroughDate ( type: esriFieldTypeDate, alias: Water Through Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WaterThroughDate )
• TreeNotes ( type: esriFieldTypeString, alias: Tree Notes, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: TreeNotes )
• RetireDate ( type: esriFieldTypeDate, alias: Retire Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RetireDate )
• SpaceId ( type: esriFieldTypeString, alias: Planting space identifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SpaceId )
• SpaceStatus ( type: esriFieldTypeString, alias: Planting space status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SpaceStatus , Coded Values: [Available: Available] , [Planted: Planted] , [Stump: Stump] , ...2 more... )
• SpaceType ( type: esriFieldTypeString, alias: Planting space type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SpaceType , Coded Values: [Bark: Bark] , [Brick: Brick] , [Grass: Grass] , ...6 more... )
• SiteType ( type: esriFieldTypeString, alias: Site Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SiteType , Coded Values: [Boulevard: Boulevard] , [Circle: Traffic circle] , [Island: Traffic island] , ...5 more... )
• SpaceWidth ( type: esriFieldTypeDouble, alias: Planting space width, editable: true, nullable: true, defaultValue: null, modelName: SpaceWidth )
• SpaceLength ( type: esriFieldTypeDouble, alias: Planting space length, editable: true, nullable: true, defaultValue: null, modelName: SpaceLength )
• SpaceNotes ( type: esriFieldTypeString, alias: Planting space notes, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: SpaceNotes )
• PublicView ( type: esriFieldTypeString, alias: Publicly Visibile, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PublicView , Coded Values: [Yes: Yes] , [No: No] )
• Stormwater ( type: esriFieldTypeDouble, alias: Stormwater intercepted, editable: true, nullable: true, defaultValue: null, modelName: Stormwater )
• Energy ( type: esriFieldTypeDouble, alias: Energy conserved, editable: true, nullable: true, defaultValue: null, modelName: Energy )
• Pollutants ( type: esriFieldTypeDouble, alias: Air pollutants removed, editable: true, nullable: true, defaultValue: null, modelName: Pollutants )
• CO2 ( type: esriFieldTypeDouble, alias: Carbon dioxide reduced, editable: true, nullable: true, defaultValue: null, modelName: CO2 )
• PropValue ( type: esriFieldTypeDouble, alias: Increased property value, editable: true, nullable: true, defaultValue: null, modelName: PropValue )
• Benefits ( type: esriFieldTypeDouble, alias: Total value of benefits, editable: true, nullable: true, defaultValue: null, modelName: Benefits )
• AdoptionStatus ( type: esriFieldTypeString, alias: Adoption Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AdoptionStatus , Coded Values: [Available: Available] , [Adopted: Adopted] )
• AdoptedBy ( type: esriFieldTypeString, alias: Adopted By, editable: true, nullable: true, length: 254, defaultValue: null, modelName: AdoptedBy )
• AdoptedOn ( type: esriFieldTypeDate, alias: Adopted On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AdoptedOn )
• Nickname ( type: esriFieldTypeString, alias: Nickname, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Nickname )
• AssetNumber ( type: esriFieldTypeInteger, alias: Tree identifier number, editable: true, nullable: true, defaultValue: null, modelName: AssetNumbe )
• OwnedBy ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: OwnedBy , Coded Values: [0: Public Works] , [1: Parks & Recreation] , [2: Municipal] , ...3 more... )
• MaintBy ( type: esriFieldTypeSmallInteger, alias: Maintained by, editable: true, nullable: true, defaultValue: null, modelName: MaintBy , Coded Values: [0: Public Works] , [1: Parks & Recreation] , [2: Municipal] , ...3 more... )
• CollectedBy ( type: esriFieldTypeSmallInteger, alias: Collected By, editable: true, nullable: true, defaultValue: null, modelName: CollectedBy , Coded Values: [0: Public Works] , [1: Parks & Recreation] , [2: Municipal] , ...2 more... )
• Department ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Department , Coded Values: [CO: Communications] , [CR: Corrections] , [AS: County Assessors] , ...22 more... )
• Species ( type: esriFieldTypeString, alias: Tree Species, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Species )
• FeatureUniqueID ( type: esriFieldTypeString, alias: FeatureUniqueID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FeatureUniqueID )
• ReadyForAW ( type: esriFieldTypeString, alias: ReadyForAW, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ReadyForAW , Coded Values: [Yes: Yes] , [No: No] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PlantsCode ( type: esriFieldTypeString, alias: PlantsCode, editable: true, nullable: true, length: 7, defaultValue: null, modelName: PlantsCode , Coded Values: [ABBA: Abies balsamea (Balsam Fir)] , [JUVI: Juniperus virginiana (Eastern Redcedar)] , [LALA: Larix laricina (Tamarack)] , ...114 more... )

Templates:

• Name: GISTrans.GISPUB.RCTreeInventory
  Description:
  Prototype:
  PlantsCode: null
  HeightUnit: null
  ReadyForAW: null
  FeatureUniqueID: null
  Species: null
  Department: null
  Project: null
  TreeCondition: null
  Recommendation: null
  TreeStatus: null
  Cost: null
  Invoice: null
  DateCollected: null
  ResidentTreating: null
  LastTreatment: null
  TreeCount: null
  AssetId: null
  FullAddr: null
  District: null
  Municipality: null
  Family: null
  Genus: null
  Cultivar: null
  CommonName: null
  Diameter: null
  Height: null
  InstallDate: null
  TreeWires: null
  TreeGuard: null
  Designation: null
  OverheadUtilities: null
  Warranty: null
  WarrantyDate: null
  WaterThroughDate: null
  TreeNotes: null
  RetireDate: null
  SpaceId: null
  SpaceStatus: null
  SpaceType: null
  SiteType: null
  SpaceWidth: null
  SpaceLength: null
  SpaceNotes: null
  PublicView: null
  Stormwater: null
  Energy: null
  Pollutants: null
  CO2: null
  PropValue: null
  Benefits: null
  AdoptionStatus: null
  AdoptedBy: null
  AdoptedOn: null
  Nickname: null
  AssetNumber: null
  OwnedBy: null
  MaintBy: null
  CollectedBy: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• RCTreeInventory_ATTACH (0) -- Related To: GISTrans.GISPUB.RCTreeInventory_ATTACH (1)
• RCTreeInventory_Inspections (1) -- Related To: GISTrans.GISPUB.RCTreeInventory_Inspections (2)
• RCTreeInventory_Maintenance (2) -- Related To: GISTrans.GISPUB.RCTreeInventory_Maintenance (4)

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

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

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata