Layers:

Layer: City Tree (0)

Name: City Tree

Display Field: LOCATIONNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This point layer represents city owned trees throughout the City of Gillette. It identifies the type of tree, where it is located, the height, diameter number of trunks and the appraised value among other fields.

Service Item Id: af6cc932ae434eb7b55d6d7b2fb2f5f6

Copyright Text: City of Gillette, GIS Division, Forestry Division

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 541803.7657000003
YMin: 1353889.5679
XMax: 598729.2403999995
YMax: 1391006.3113
Spatial Reference: 102755  (3736)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: SubtypeCD
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Deciduous
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 112, 255, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 2
  Label: Evergreen
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [76, 230, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 3
  Label: Shrub Deciduous
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [197, 0, 255, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 4
  Label: Shrub Evergreen
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 170, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 0
  Label: Unidentified
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: false
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: true
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: SubtypeCD

Fields:
• SubtypeCD ( type: esriFieldTypeSmallInteger, alias: Subtype Code )
• SPECIES ( type: esriFieldTypeString, alias: Species, length: 30 )
• HEIGHT ( type: esriFieldTypeSmallInteger, alias: Height )
• DIAMETER ( type: esriFieldTypeSmallInteger, alias: Diameter )
• CANOPY ( type: esriFieldTypeSmallInteger, alias: Canopy Spread )
• TRUNKS ( type: esriFieldTypeSmallInteger, alias: Number of Trunks )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: Condition )
• RISK ( type: esriFieldTypeSmallInteger, alias: Risk )
• LOCATIONNAME ( type: esriFieldTypeString, alias: Location Name, length: 30 )
• GROWSPACE ( type: esriFieldTypeString, alias: Growth Space, length: 20 )
• IRRIGATION ( type: esriFieldTypeSmallInteger, alias: Irrigated )
• OCCASION ( type: esriFieldTypeString, alias: Special Occasion, length: 30 , Coded Values: [Arbor Day: Arbor Day] , [Heritage: Heritage] , [Memorial: Memorial] , ...2 more... )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 20 , Coded Values: [Wendy: Wendy Clements] , [Micaiah: Micaiah Huff] , [Janie: Janie Kuntz] , ...1 more... )
• PLANTED ( type: esriFieldTypeSmallInteger, alias: Year Planted )
• SOURCEDATE ( type: esriFieldTypeDate, alias: Source Date, length: 8 )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
• COMMENT ( type: esriFieldTypeString, alias: GIS Comment, length: 100 )
• LIFECYCLE ( type: esriFieldTypeString, alias: Lifecycle Status, length: 10 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 100 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SITEID ( type: esriFieldTypeSmallInteger, alias: Site ID Number )
• REMOVED ( type: esriFieldTypeString, alias: Month Removed, length: 20 )
• APPRAISE ( type: esriFieldTypeInteger, alias: Appraised Value )
• LOCAITONVALUE ( type: esriFieldTypeSmallInteger, alias: Location Value )
• LANDUSE ( type: esriFieldTypeString, alias: Land Use, length: 20 )
• ROTATION ( type: esriFieldTypeSmallInteger, alias: Rotation )
• COGID ( type: esriFieldTypeString, alias: City ID, length: 38 )
• ADMIN ( type: esriFieldTypeString, alias: Administration, length: 10 )
• CADblock ( type: esriFieldTypeString, alias: AutoCAD Block, length: 20 )
• CADlayer ( type: esriFieldTypeString, alias: AutoCAD Layer, length: 20 )
• SOURCETYPE ( type: esriFieldTypeString, alias: Source Type, length: 20 )
• SOURCEENTITY ( type: esriFieldTypeString, alias: Source Entity, length: 20 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CartoGroup ( type: esriFieldTypeString, alias: Community Map Group, length: 50 )
Types:
ID: 0
Name: Unidentified
Domains:
• ADMIN:
  Coded Values: [City: City of Gillette] , [County: Campbell County] , [Private: Private Party] , ...5 more...
• CONDITION:
  Coded Values: [100: Excellent] , [90: Good] , [60: Fair] , ...3 more...
• GROWSPACE:
  Coded Values: [Island: Island] , [Median: Median] , [Open: Open/Unrestricted] , ...4 more...
• IRRIGATION:
  Coded Values: [0: False] , [1: True]
• LANDUSE:
  Coded Values: [Boulevard: Boulevard] , [Business: Business] , [Municipal: Municipal] , ...4 more...
• LASTEDITOR:
  Inherited
• LIFECYCLE:
  Coded Values: [Active: Active] , [Proposed: Proposed] , [Possible: Possible] , ...3 more...
• OCCASION:
  Inherited
• RISK:
  Coded Values: [0: Unknown] , [1: None] , [2: Low] , ...3 more...
• ROTATION:
  Range: [0, 360]
• SOURCEENTITY:
  Coded Values: [CCGIS: Campbell County GIS] , [FEMA: Federal Emergency Management Agency] , [NHD: National Hydrology Dataset] , ...38 more...
• SOURCETYPE:
  Coded Values: [Record: Record Drawing] , [Aerial: Aerial photograph] , [Map: Mapping Grade GPS] , ...17 more...

---

ID: 1
Name: Deciduous
Domains:
• ADMIN:
  Coded Values: [City: City of Gillette] , [County: Campbell County] , [Private: Private Party] , ...5 more...
• CONDITION:
  Coded Values: [100: Excellent] , [90: Good] , [60: Fair] , ...3 more...
• GROWSPACE:
  Coded Values: [Island: Island] , [Median: Median] , [Open: Open/Unrestricted] , ...4 more...
• IRRIGATION:
  Coded Values: [0: False] , [1: True]
• LANDUSE:
  Coded Values: [Boulevard: Boulevard] , [Business: Business] , [Municipal: Municipal] , ...4 more...
• LASTEDITOR:
  Inherited
• LIFECYCLE:
  Coded Values: [Active: Active] , [Proposed: Proposed] , [Possible: Possible] , ...3 more...
• OCCASION:
  Inherited
• RISK:
  Coded Values: [0: Unknown] , [1: None] , [2: Low] , ...3 more...
• ROTATION:
  Range: [0, 360]
• SOURCEENTITY:
  Coded Values: [CCGIS: Campbell County GIS] , [FEMA: Federal Emergency Management Agency] , [NHD: National Hydrology Dataset] , ...38 more...
• SOURCETYPE:
  Coded Values: [Record: Record Drawing] , [Aerial: Aerial photograph] , [Map: Mapping Grade GPS] , ...17 more...
• SPECIES:
  Coded Values: [Apple: Apple] , [Apple Honeycrisp: Apple Honeycrisp] , [Apple Red Delicious: Apple Red Delicious] , ...123 more...

---

ID: 2
Name: Evergreen
Domains:
• ADMIN:
  Coded Values: [City: City of Gillette] , [County: Campbell County] , [Private: Private Party] , ...5 more...
• CONDITION:
  Coded Values: [100: Excellent] , [90: Good] , [60: Fair] , ...3 more...
• GROWSPACE:
  Coded Values: [Island: Island] , [Median: Median] , [Open: Open/Unrestricted] , ...4 more...
• IRRIGATION:
  Coded Values: [0: False] , [1: True]
• LANDUSE:
  Coded Values: [Boulevard: Boulevard] , [Business: Business] , [Municipal: Municipal] , ...4 more...
• LASTEDITOR:
  Inherited
• LIFECYCLE:
  Coded Values: [Active: Active] , [Proposed: Proposed] , [Possible: Possible] , ...3 more...
• OCCASION:
  Inherited
• RISK:
  Coded Values: [0: Unknown] , [1: None] , [2: Low] , ...3 more...
• ROTATION:
  Range: [0, 360]
• SOURCEENTITY:
  Coded Values: [CCGIS: Campbell County GIS] , [FEMA: Federal Emergency Management Agency] , [NHD: National Hydrology Dataset] , ...38 more...
• SOURCETYPE:
  Coded Values: [Record: Record Drawing] , [Aerial: Aerial photograph] , [Map: Mapping Grade GPS] , ...17 more...
• SPECIES:
  Coded Values: [Arborvitae: Arborvitae] , [Cedar: Cedar] , [Cedar Eastern Red: Cedar Eastern Red] , ...32 more...

---

ID: 3
Name: Shrub Deciduous
Domains:
• ADMIN:
  Coded Values: [City: City of Gillette] , [County: Campbell County] , [Private: Private Party] , ...5 more...
• CONDITION:
  Coded Values: [100: Excellent] , [90: Good] , [60: Fair] , ...3 more...
• GROWSPACE:
  Coded Values: [Island: Island] , [Median: Median] , [Open: Open/Unrestricted] , ...4 more...
• IRRIGATION:
  Coded Values: [0: False] , [1: True]
• LANDUSE:
  Coded Values: [Boulevard: Boulevard] , [Business: Business] , [Municipal: Municipal] , ...4 more...
• LASTEDITOR:
  Inherited
• LIFECYCLE:
  Coded Values: [Active: Active] , [Proposed: Proposed] , [Possible: Possible] , ...3 more...
• OCCASION:
  Inherited
• RISK:
  Coded Values: [0: Unknown] , [1: None] , [2: Low] , ...3 more...
• ROTATION:
  Range: [0, 360]
• SOURCEENTITY:
  Coded Values: [CCGIS: Campbell County GIS] , [FEMA: Federal Emergency Management Agency] , [NHD: National Hydrology Dataset] , ...38 more...
• SOURCETYPE:
  Coded Values: [Record: Record Drawing] , [Aerial: Aerial photograph] , [Map: Mapping Grade GPS] , ...17 more...
• SPECIES:
  Coded Values: [Barberry: Barberry] , [Barberry Japanese: Barberry Japanese] , [Barberry Rose Glow: Barberry Rose Glow] , ...43 more...

---

ID: 4
Name: Shrub Evergreen
Domains:
• ADMIN:
  Coded Values: [City: City of Gillette] , [County: Campbell County] , [Private: Private Party] , ...5 more...
• CONDITION:
  Coded Values: [100: Excellent] , [90: Good] , [60: Fair] , ...3 more...
• GROWSPACE:
  Coded Values: [Island: Island] , [Median: Median] , [Open: Open/Unrestricted] , ...4 more...
• IRRIGATION:
  Coded Values: [0: False] , [1: True]
• LANDUSE:
  Coded Values: [Boulevard: Boulevard] , [Business: Business] , [Municipal: Municipal] , ...4 more...
• LASTEDITOR:
  Inherited
• LIFECYCLE:
  Coded Values: [Active: Active] , [Proposed: Proposed] , [Possible: Possible] , ...3 more...
• OCCASION:
  Inherited
• RISK:
  Coded Values: [0: Unknown] , [1: None] , [2: Low] , ...3 more...
• ROTATION:
  Range: [0, 360]
• SOURCEENTITY:
  Coded Values: [CCGIS: Campbell County GIS] , [FEMA: Federal Emergency Management Agency] , [NHD: National Hydrology Dataset] , ...38 more...
• SOURCETYPE:
  Coded Values: [Record: Record Drawing] , [Aerial: Aerial photograph] , [Map: Mapping Grade GPS] , ...17 more...
• SPECIES:
  Coded Values: [Arborvitae: Arborvitae] , [Juniper: Juniper] , [Juniper Blue Chip: Juniper Blue Chip] , ...7 more...

---

Relationships:

• tasks... (0) -- Related To: SDE.DBO.veTask (2)
• defects... (1) -- Related To: SDE.DBO.veDefect (1)

Tables:

Table: SDE.DBO.veDefect (1)

Name: SDE.DBO.veDefect

Display Field: COGID

Type: Table

Geometry Type: N/A

Description: This standalone table relates the City ID to a Feature ID which shows the tree defect.

Service Item Id: af6cc932ae434eb7b55d6d7b2fb2f5f6

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• TREEDEFECT ( type: esriFieldTypeString, alias: Defect, length: 30 , Coded Values: [BasalDecay: Basal Decay] , [BranchBroken: Branch Broken] , [BranchTear: Branch Tear] , ...28 more... )
• DEFECTDATE ( type: esriFieldTypeDate, alias: Defect Date, length: 8 )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: Parent ID, length: 38 )
• COMMENT ( type: esriFieldTypeString, alias: GIS Comment, length: 100 )
• COGID ( type: esriFieldTypeString, alias: City ID, length: 38 )
• FeatureID ( type: esriFieldTypeString, alias: Feature ID, length: 38 )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 20 , Coded Values: [Wendy: Wendy Clements] , [Micaiah: Micaiah Huff] , [Janie: Janie Kuntz] , ...1 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• tree... (1) -- Related To: City Tree (0)

Table: SDE.DBO.veTask (2)

Name: SDE.DBO.veTask

Display Field: COGID

Type: Table

Geometry Type: N/A

Description: This standalone table relates the City ID to a Feature ID which shows the tree tasks assigned to a tree.

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• TREETASK ( type: esriFieldTypeString, alias: Task, length: 30 , Coded Values: [Claim: Claim] , [Plant: Plant] , [Prune: Prune] , ...15 more... )
• PRIORITY ( type: esriFieldTypeString, alias: Priority, length: 30 , Coded Values: [High: High] , [Immediate: Immediate] , [Standard: Standard] )
• TASKASSIGNED ( type: esriFieldTypeDate, alias: Date Task Assigned, length: 8 )
• TASKCOMPLETE ( type: esriFieldTypeDate, alias: Date Task Complete, length: 8 )
• PERSONNEL ( type: esriFieldTypeSmallInteger, alias: Number of Crew )
• WORKTIME ( type: esriFieldTypeDouble, alias: Work Time in Hours )
• TASKCOMPLETER ( type: esriFieldTypeString, alias: Task Complete By, length: 20 , Coded Values: [Chris: Chris Leatherman] , [Donna: Donna Moreau] , [Lee: Lee Pratt] , ...20 more... )
• INHOUSE ( type: esriFieldTypeSmallInteger, alias: Task Done In House , Coded Values: [0: False] , [1: True] )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: Parent ID, length: 38 )
• COMMENT ( type: esriFieldTypeString, alias: GIS Comment, length: 100 )
• COGID ( type: esriFieldTypeString, alias: City ID, length: 38 )
• FeatureID ( type: esriFieldTypeString, alias: Feature ID, length: 38 )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 20 , Coded Values: [Wendy: Wendy Clements] , [Micaiah: Micaiah Huff] , [Janie: Janie Kuntz] , ...1 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• tree... (0) -- Related To: City Tree (0)