View In:   ArcGIS Online Map Viewer

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)

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

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:   Field Groups   Contingent Values

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