Layers:

Layer: Trees (5)

Name: Trees

Display Field: DUBUQUE.Trees.TREE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Trees

Service Item Id: e399f58c82af457dacf58f4a279e0f4b

Copyright Text:

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: 5646796.328224942
YMin: 3622597.4201731086
XMax: 5692117.452149436
YMax: 3677341.6128498465
Spatial Reference: 102675  (3417)  VCSWkid(5703)  LatestVCSWkid(5703)



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: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: false
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: false
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• TARGET_FID ( type: esriFieldTypeInteger, alias: TARGET_FID, editable: true, nullable: true, defaultValue: null, modelName: TARGET_FID )
• FACILITYID ( type: esriFieldTypeString, alias: Tag Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITYID )
• TREE_NAME ( type: esriFieldTypeString, alias: Common Tree Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NAME , Coded Values: [Free M: Freemanii maple] , [Blk M: Black maple] , [NM: Norway maple] , ...98 more... )
• GENUS ( type: esriFieldTypeString, alias: Tree Genus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GENUS )
• SPECIES ( type: esriFieldTypeString, alias: Tree Species, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SPECIES )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter (in), editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• HEIGHT ( type: esriFieldTypeDouble, alias: Height (ft), editable: true, nullable: true, defaultValue: null, modelName: HEIGHT )
• WIRES ( type: esriFieldTypeString, alias: Wires Present, editable: true, nullable: true, length: 5, defaultValue: No, modelName: WIRES , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONDITION , Coded Values: [G: Good] , [F: Fair] , [P: Poor] , ...2 more... )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] , ...1 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] , ...1 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• Location ( type: esriFieldTypeString, alias: ParkName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Comments )
• LocationOn ( type: esriFieldTypeString, alias: Location On (Street Name), editable: true, nullable: true, length: 100, defaultValue: null, modelName: LocationOn , Coded Values: [ABACA CT: ABACA CT] , [ABBEY WOOD CT: ABBEY WOOD CT] , [ABBOTT ST: ABBOTT ST] , ...1213 more... )
• LocationAt ( type: esriFieldTypeString, alias: Location At (House Number), editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocationAt )
• DataSource ( type: esriFieldTypeString, alias: Data Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DataSource , Coded Values: [Park Documents: Parks Documents] , [Parks Staff: Parks Staff] , [Engineering Staff: Engineering Staff] , ...5 more... )
• PlotNum ( type: esriFieldTypeString, alias: PlotNum, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PlotNum )
• LawnWidth ( type: esriFieldTypeDouble, alias: Lawn Width, editable: true, nullable: true, defaultValue: null, modelName: LawnWidth )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• TreeID ( type: esriFieldTypeDouble, alias: TreeID, editable: true, nullable: true, defaultValue: null, modelName: TreeID )
• TreeStatus ( type: esriFieldTypeString, alias: Tree Status, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TreeStatus , Coded Values: [Planted: Planted] , [Proposed: Proposed] , [Stump: Stump] , ...2 more... )
• TreeType ( type: esriFieldTypeSmallInteger, alias: Tree Type, editable: true, nullable: true, defaultValue: 0, modelName: TreeType )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• RootballSize ( type: esriFieldTypeSmallInteger, alias: Rootball Size (ft), editable: true, nullable: true, defaultValue: null, modelName: RootballSize )
• StormwaterDiverted ( type: esriFieldTypeInteger, alias: Stormwater Diverted (gal), editable: true, nullable: true, defaultValue: null, modelName: StormwaterDiverted )
• EnergySaved ( type: esriFieldTypeInteger, alias: Energy Saved (kWh), editable: true, nullable: true, defaultValue: null, modelName: EnergySaved )
• AirPollutantsRemoved ( type: esriFieldTypeInteger, alias: Air Pollutants Removed (lbs), editable: true, nullable: true, defaultValue: null, modelName: AirPollutantsRemoved )
• CO2Reduced ( type: esriFieldTypeInteger, alias: CO2 Reduced (lbs), editable: true, nullable: true, defaultValue: null, modelName: CO2Reduced )
• PropertyValueIncrease ( type: esriFieldTypeInteger, alias: Property Value Increase ($), editable: true, nullable: true, defaultValue: null, modelName: PropertyValueIncrease )
• Cultivar ( type: esriFieldTypeString, alias: Cultivar, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Cultivar )
• Variety ( type: esriFieldTypeString, alias: Variety, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Variety )
• TreeWires ( type: esriFieldTypeString, alias: Tree Wires Present?, editable: true, nullable: true, length: 10, defaultValue: No, modelName: TreeWires , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• TreeGuard ( type: esriFieldTypeString, alias: Tree Guard Present?, editable: true, nullable: true, length: 10, defaultValue: No, modelName: TreeGuard , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• PublicView ( type: esriFieldTypeString, alias: Public VIew?, editable: true, nullable: true, length: 10, defaultValue: Yes, modelName: PublicView , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• Warranty ( type: esriFieldTypeString, alias: Warranty?, editable: true, nullable: true, length: 10, defaultValue: No, modelName: Warranty , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate )
• SiteType ( type: esriFieldTypeString, alias: Site Type, editable: true, nullable: true, length: 50, defaultValue: Grass, modelName: SiteType , Coded Values: [Bark: Bark] , [Brick: Brick] , [Grass: Grass] , ...6 more... )
• ProjectTree ( type: esriFieldTypeString, alias: Branching Out Project Tree?, editable: true, nullable: true, length: 10, defaultValue: No, modelName: HeritageTree , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• OverheadWires ( type: esriFieldTypeString, alias: OverheadWires, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OverheadWires , Coded Values: [Yes: Yes] , [No: No] , [YesP: Yes and is interfering with lines or equipment] )
• CurbSidewalkDistance ( type: esriFieldTypeSmallInteger, alias: CurbSidewalkDistance, editable: true, nullable: true, defaultValue: null, modelName: CurbSidewalkDistance , Coded Values: [6: > 5 feet] , [2: < 3 feet] , [34: 3-4 feet] , ...1 more... )
• StreetLamp ( type: esriFieldTypeString, alias: StreetLamp, editable: true, nullable: true, length: 5, defaultValue: null, modelName: StreetLamp , Coded Values: [Yes: Yes] , [No: No] , [YesL: Yes and is presently causing a lighting problem] )
• Traffic ( type: esriFieldTypeString, alias: Traffic, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Traffic , Coded Values: [Yes: Yes] , [No: No] , [YesT: Yes and is causing a traffic problem] )
Templates:
• Name: Trees
  Description:
  Prototype:
  StreetLamp: null
  TARGET_FID: null
  FACILITYID: null
  TREE_NAME: null
  GENUS: null
  SPECIES: null
  DIAMETER: null
  HEIGHT: null
  WIRES: null
  INSTALLDATE: null
  CONDITION: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  Location: null
  Comments: null
  LocationOn: null
  LocationAt: null
  DataSource: null
  PlotNum: null
  LawnWidth: null
  Traffic: null
  CurbSidewalkDistance: null
  OverheadWires: null
  ProjectTree: null
  SiteType: Grass
  TreeID: null
  TreeStatus: null
  TreeType: 0
  InspectionDate: null
  RootballSize: null
  StormwaterDiverted: null
  EnergySaved: null
  AirPollutantsRemoved: null
  CO2Reduced: null
  PropertyValueIncrease: null
  Cultivar: null
  Variety: null
  TreeWires: null
  TreeGuard: null
  PublicView: Yes
  Warranty: null
  WarrantyDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• DUBUQUE.Activities (0) -- Related To: Activities (2)

Layer: Activities (2)

Name: Activities

Display Field: StaffName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: e399f58c82af457dacf58f4a279e0f4b

Copyright Text:

Default Visibility: false

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: 5654341.2708121985
YMin: 3622597.4201731086
XMax: 5692117.452149436
YMax: 3677341.6128498465
Spatial Reference: 102675  (3417)  VCSWkid(5703)  LatestVCSWkid(5703)



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: 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
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 ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: description )
• status ( type: esriFieldTypeInteger, alias: Status, editable: true, nullable: false, defaultValue: null, modelName: status , Coded Values: [0: Unassigned] , [1: Assigned] , [2: In Progress] , ...4 more... )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: notes )
• priority ( type: esriFieldTypeInteger, alias: Priority, editable: true, nullable: false, defaultValue: null, modelName: priority )
• assignmenttype ( type: esriFieldTypeGUID, alias: Assignment Type, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: assignmenttype )
• workorderid ( type: esriFieldTypeString, alias: Work Order ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: workorderid )
• duedate ( type: esriFieldTypeDate, alias: Due Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: duedate )
• workerid ( type: esriFieldTypeGUID, alias: Worker ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: workerid )
• location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: false, length: 255, defaultValue: null, modelName: location )
• declinedcomment ( type: esriFieldTypeString, alias: Declined Comment, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: declinedcomment )
• assigneddate ( type: esriFieldTypeDate, alias: Assigned on Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: assigneddate )
• inprogressdate ( type: esriFieldTypeDate, alias: In Progress Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inprogressdate )
• completeddate ( type: esriFieldTypeDate, alias: Completed on Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: completeddate )
• declineddate ( type: esriFieldTypeDate, alias: Declined on Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: declineddate )
• pauseddate ( type: esriFieldTypeDate, alias: Paused on Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: pauseddate )
• dispatcherid ( type: esriFieldTypeGUID, alias: Dispatcher ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: dispatcherid )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Editor )
• treeglobalid ( type: esriFieldTypeGUID, alias: Tree Global ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: treeglobalid )
• TreeAssignment ( type: esriFieldTypeString, alias: Assignment Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TreeAssignment , Coded Values: [Removal: Tree Removal] , [Prune: Pruning & Canopy Reduction] , [Debris: Debris Removal] , ...13 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• InjectionAmount ( type: esriFieldTypeDouble, alias: Injection Amount (mL), editable: true, nullable: true, defaultValue: null, modelName: InjectionAmount )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Comments )
• StaffName ( type: esriFieldTypeString, alias: Staff Performing Work, editable: true, nullable: true, length: 100, defaultValue: null, modelName: StaffName , Coded Values: [Wegmann: Robert Wegmann] , [Liska: Barb Liska] , [Bahl: Jayme Bahl] , ...1 more... )
• ParentID ( type: esriFieldTypeInteger, alias: ParentID, editable: true, nullable: true, defaultValue: null, modelName: ParentID )
Templates:
• Name: Activities
  Description:
  Prototype:
  StaffName: null
  description: null
  status: 0
  notes: null
  priority: 0
  assignmenttype: {00000000-0000-0000-0000-000000000000}
  workorderid: null
  duedate: null
  workerid: null
  location:
  declinedcomment: null
  assigneddate: null
  inprogressdate: null
  completeddate: null
  declineddate: null
  pauseddate: null
  dispatcherid: null
  CreationDate: null
  Creator: null
  EditDate: null
  Editor: null
  treeglobalid: null
  TreeAssignment: null
  ParentID: null
  Comments: null
  InjectionAmount: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• DUBUQUE.Trees (0) -- Related To: Trees (5)