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: 14843ed2ccea445cbf5931681c3145bb

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: 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: SubtypeCD

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

---

ID: 2
Name: Evergreen
Domains:
• SPECIES:
  Coded Values: [Arborvitae: Arborvitae] , [Cedar: Cedar] , [Cedar Eastern Red: Cedar Eastern Red] , ...32 more...
• CONDITION:
  Coded Values: [100: Excellent] , [90: Good] , [60: Fair] , ...3 more...
• RISK:
  Coded Values: [0: Unknown] , [1: None] , [2: Low] , ...3 more...
• GROWSPACE:
  Coded Values: [Island: Island] , [Median: Median] , [Open: Open/Unrestricted] , ...4 more...
• IRRIGATION:
  Coded Values: [0: False] , [1: True]
• OCCASION:
  Inherited
• LASTEDITOR:
  Inherited
• LIFECYCLE:
  Coded Values: [Active: Active] , [Proposed: Proposed] , [Possible: Possible] , ...3 more...
• LANDUSE:
  Coded Values: [Boulevard: Boulevard] , [Business: Business] , [Municipal: Municipal] , ...4 more...
• ROTATION:
  Range: [0, 360]
• ADMIN:
  Coded Values: [City: City of Gillette] , [County: Campbell County] , [Private: Private Party] , ...5 more...
• SOURCETYPE:
  Coded Values: [Record: Record Drawing] , [Aerial: Aerial photograph] , [Map: Mapping Grade GPS] , ...17 more...
• SOURCEENTITY:
  Coded Values: [CCGIS: Campbell County GIS] , [FEMA: Federal Emergency Management Agency] , [NHD: National Hydrology Dataset] , ...38 more...
Templates:
• Name: Evergreen
  Description:
  Prototype:
  COGID: null
  ADMIN: City
  CADblock: VE-GENERIC
  COMMENT: null
  LANDUSE: null
  SOURCEENTITY: null
  SubtypeCD: 2
  SPECIES: null
  HEIGHT: null
  DIAMETER: null
  CANOPY: null
  TRUNKS: null
  CONDITION: null
  RISK: null
  LOCATIONNAME: null
  GROWSPACE: null
  IRRIGATION: null
  OCCASION: null
  LASTEDITOR: null
  PLANTED: null
  SOURCEDATE: null
  LASTUPDATE: null
  LIFECYCLE: Active
  CartoGroup: null
  ADDRESS: null
  SITEID: null
  REMOVED: null
  APPRAISE: null
  LOCAITONVALUE: null
  ROTATION: 0
  CADlayer: VE-TREE-EVER-PNTS-E
  SOURCETYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Shrub Deciduous
Domains:
• SPECIES:
  Coded Values: [Barberry: Barberry] , [Barberry Japanese: Barberry Japanese] , [Barberry Rose Glow: Barberry Rose Glow] , ...43 more...
• CONDITION:
  Coded Values: [100: Excellent] , [90: Good] , [60: Fair] , ...3 more...
• RISK:
  Coded Values: [0: Unknown] , [1: None] , [2: Low] , ...3 more...
• GROWSPACE:
  Coded Values: [Island: Island] , [Median: Median] , [Open: Open/Unrestricted] , ...4 more...
• IRRIGATION:
  Coded Values: [0: False] , [1: True]
• OCCASION:
  Inherited
• LASTEDITOR:
  Inherited
• LIFECYCLE:
  Coded Values: [Active: Active] , [Proposed: Proposed] , [Possible: Possible] , ...3 more...
• LANDUSE:
  Coded Values: [Boulevard: Boulevard] , [Business: Business] , [Municipal: Municipal] , ...4 more...
• ROTATION:
  Range: [0, 360]
• ADMIN:
  Coded Values: [City: City of Gillette] , [County: Campbell County] , [Private: Private Party] , ...5 more...
• SOURCETYPE:
  Coded Values: [Record: Record Drawing] , [Aerial: Aerial photograph] , [Map: Mapping Grade GPS] , ...17 more...
• SOURCEENTITY:
  Coded Values: [CCGIS: Campbell County GIS] , [FEMA: Federal Emergency Management Agency] , [NHD: National Hydrology Dataset] , ...38 more...
Templates:
• Name: Shrub Deciduous
  Description:
  Prototype:
  COGID: null
  ADMIN: City
  CADblock: VE-GENERIC
  COMMENT: null
  LANDUSE: null
  SOURCEENTITY: null
  SubtypeCD: 3
  SPECIES: null
  HEIGHT: null
  DIAMETER: null
  CANOPY: null
  TRUNKS: null
  CONDITION: null
  RISK: null
  LOCATIONNAME: null
  GROWSPACE: null
  IRRIGATION: null
  OCCASION: null
  LASTEDITOR: null
  PLANTED: null
  SOURCEDATE: null
  LASTUPDATE: null
  LIFECYCLE: Active
  CartoGroup: null
  ADDRESS: null
  SITEID: null
  REMOVED: null
  APPRAISE: null
  LOCAITONVALUE: null
  ROTATION: 0
  CADlayer: VE-TREE-SHRD-PNTS-E
  SOURCETYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Shrub Evergreen
Domains:
• SPECIES:
  Coded Values: [Arborvitae: Arborvitae] , [Juniper: Juniper] , [Juniper Blue Chip: Juniper Blue Chip] , ...7 more...
• CONDITION:
  Coded Values: [100: Excellent] , [90: Good] , [60: Fair] , ...3 more...
• RISK:
  Coded Values: [0: Unknown] , [1: None] , [2: Low] , ...3 more...
• GROWSPACE:
  Coded Values: [Island: Island] , [Median: Median] , [Open: Open/Unrestricted] , ...4 more...
• IRRIGATION:
  Coded Values: [0: False] , [1: True]
• OCCASION:
  Inherited
• LASTEDITOR:
  Inherited
• LIFECYCLE:
  Coded Values: [Active: Active] , [Proposed: Proposed] , [Possible: Possible] , ...3 more...
• LANDUSE:
  Coded Values: [Boulevard: Boulevard] , [Business: Business] , [Municipal: Municipal] , ...4 more...
• ROTATION:
  Range: [0, 360]
• ADMIN:
  Coded Values: [City: City of Gillette] , [County: Campbell County] , [Private: Private Party] , ...5 more...
• SOURCETYPE:
  Coded Values: [Record: Record Drawing] , [Aerial: Aerial photograph] , [Map: Mapping Grade GPS] , ...17 more...
• SOURCEENTITY:
  Coded Values: [CCGIS: Campbell County GIS] , [FEMA: Federal Emergency Management Agency] , [NHD: National Hydrology Dataset] , ...38 more...
Templates:
• Name: Shrub Evergreen
  Description:
  Prototype:
  COGID: null
  ADMIN: City
  CADblock: VE-GENERIC
  COMMENT: null
  LANDUSE: null
  SOURCEENTITY: null
  SubtypeCD: 4
  SPECIES: null
  HEIGHT: null
  DIAMETER: null
  CANOPY: null
  TRUNKS: null
  CONDITION: null
  RISK: null
  LOCATIONNAME: null
  GROWSPACE: null
  IRRIGATION: null
  OCCASION: null
  LASTEDITOR: null
  PLANTED: null
  SOURCEDATE: null
  LASTUPDATE: null
  LIFECYCLE: Active
  CartoGroup: null
  ADDRESS: null
  SITEID: null
  REMOVED: null
  APPRAISE: null
  LOCAITONVALUE: null
  ROTATION: 0
  CADlayer: VE-TREE-SHRE-PNTS-E
  SOURCETYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 0
Name: Unidentified
Domains:
• CONDITION:
  Coded Values: [100: Excellent] , [90: Good] , [60: Fair] , ...3 more...
• RISK:
  Coded Values: [0: Unknown] , [1: None] , [2: Low] , ...3 more...
• GROWSPACE:
  Coded Values: [Island: Island] , [Median: Median] , [Open: Open/Unrestricted] , ...4 more...
• IRRIGATION:
  Coded Values: [0: False] , [1: True]
• OCCASION:
  Inherited
• LASTEDITOR:
  Inherited
• LIFECYCLE:
  Coded Values: [Active: Active] , [Proposed: Proposed] , [Possible: Possible] , ...3 more...
• LANDUSE:
  Coded Values: [Boulevard: Boulevard] , [Business: Business] , [Municipal: Municipal] , ...4 more...
• ROTATION:
  Range: [0, 360]
• ADMIN:
  Coded Values: [City: City of Gillette] , [County: Campbell County] , [Private: Private Party] , ...5 more...
• SOURCETYPE:
  Coded Values: [Record: Record Drawing] , [Aerial: Aerial photograph] , [Map: Mapping Grade GPS] , ...17 more...
• SOURCEENTITY:
  Coded Values: [CCGIS: Campbell County GIS] , [FEMA: Federal Emergency Management Agency] , [NHD: National Hydrology Dataset] , ...38 more...
Templates:
• Name: Unidentified
  Description:
  Prototype:
  COGID: null
  ADMIN: City
  CADblock: VE-GENERIC
  COMMENT: null
  LANDUSE: null
  SubtypeCD: 0
  SOURCEENTITY: null
  SPECIES: Unidentified
  HEIGHT: null
  DIAMETER: null
  CANOPY: null
  TRUNKS: null
  CONDITION: null
  RISK: null
  LOCATIONNAME: null
  GROWSPACE: null
  IRRIGATION: null
  OCCASION: null
  LASTEDITOR: null
  PLANTED: null
  SOURCEDATE: null
  LASTUPDATE: null
  LIFECYCLE: Active
  CartoGroup: null
  ADDRESS: null
  SITEID: null
  REMOVED: null
  APPRAISE: null
  LOCAITONVALUE: null
  ROTATION: 0
  CADlayer: VE-TREE-____-PNTS-E
  SOURCETYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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.

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• TREEDEFECT ( type: esriFieldTypeString, alias: Defect, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TREEDEFECT , Coded Values: [BasalDecay: Basal Decay] , [BranchBroken: Branch Broken] , [BranchTear: Branch Tear] , ...28 more... )
• DEFECTDATE ( type: esriFieldTypeDate, alias: Defect Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DEFECTDATE )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: Parent ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GLOBALID )
• COMMENT ( type: esriFieldTypeString, alias: GIS Comment, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENT )
• COGID ( type: esriFieldTypeString, alias: City ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: COGID )
• FeatureID ( type: esriFieldTypeString, alias: Feature ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: FeatureID )
• 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: 20, defaultValue: null, modelName: LASTEDITOR , Coded Values: [Wendy: Wendy Clements] , [Micaiah: Micaiah Huff] , [Janie: Janie Kuntz] , ...1 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
Templates:
• Name: SDE.DBO.veDefect
  Description:
  Prototype:
  LASTEDITOR: null
  TREEDEFECT: null
  DEFECTDATE: null
  REL_GLOBALID: null
  COMMENT: null
  COGID: null
  FeatureID: null
  LASTUPDATE: null
  
  Drawing Tool: esriFeatureEditToolNone

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:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• TREETASK ( type: esriFieldTypeString, alias: Task, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TREETASK , Coded Values: [Claim: Claim] , [Plant: Plant] , [Prune: Prune] , ...15 more... )
• PRIORITY ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PRIORITY , Coded Values: [High: High] , [Immediate: Immediate] , [Standard: Standard] )
• TASKASSIGNED ( type: esriFieldTypeDate, alias: Date Task Assigned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TASKASSIGNED )
• TASKCOMPLETE ( type: esriFieldTypeDate, alias: Date Task Complete, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TASKCOMPLETE )
• PERSONNEL ( type: esriFieldTypeSmallInteger, alias: Number of Crew, editable: true, nullable: true, defaultValue: null, modelName: PERSONNEL )
• WORKTIME ( type: esriFieldTypeDouble, alias: Work Time in Hours, editable: true, nullable: true, defaultValue: null, modelName: WORKTIME )
• TASKCOMPLETER ( type: esriFieldTypeString, alias: Task Complete By, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TASKCOMPLETER , Coded Values: [Chris: Chris Leatherman] , [Donna: Donna Moreau] , [Lee: Lee Pratt] , ...20 more... )
• INHOUSE ( type: esriFieldTypeSmallInteger, alias: Task Done In House, editable: true, nullable: true, defaultValue: null, modelName: INHOUSE , Coded Values: [0: False] , [1: True] )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: Parent ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GLOBALID )
• COMMENT ( type: esriFieldTypeString, alias: GIS Comment, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENT )
• COGID ( type: esriFieldTypeString, alias: City ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: COGID )
• FeatureID ( type: esriFieldTypeString, alias: Feature ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: FeatureID )
• 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: 20, defaultValue: null, modelName: LASTEDITOR , Coded Values: [Wendy: Wendy Clements] , [Micaiah: Micaiah Huff] , [Janie: Janie Kuntz] , ...1 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
Templates:
• Name: SDE.DBO.veTask
  Description:
  Prototype:
  LASTEDITOR: null
  TREETASK: null
  PRIORITY: null
  TASKASSIGNED: null
  TASKCOMPLETE: null
  PERSONNEL: null
  WORKTIME: null
  TASKCOMPLETER: null
  INHOUSE: null
  REL_GLOBALID: null
  COMMENT: null
  COGID: null
  FeatureID: null
  LASTUPDATE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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