Name: Trees

Display Field: Botanical

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This view joins the Trees feature class with the latest activity recorded in the TreeActivity table. This view is necessary to symbolize trees by the last activity performed on the tree as well as by the recommended maintenance required on the tree recorded in the last activity.</SPAN></P><P><SPAN>The join happens on the GlobalID for the tree = to the ParentGUID recorded in the TreeActivity. Note that a windows ROWNUM function is used in identifying the latest activity records partitioned (grouped by) the ParentGUID of the TreeActivity.</SPAN></P><P><SPAN>Note that this view will remain stable and active as long as the Trees and TreeActivity data is maintained. </SPAN></P><P><SPAN>This view will be consumed in the Trees Field Maps application as well as other AGOL and/or Portal applications developed to track tree work performed by the Landscape Division at the MSC.</SPAN></P><P><SPAN /></P><P STYLE="margin:1 1 1 20;"><SPAN>CREATE VIEW TreesLatestActivityView AS </SPAN></P><P STYLE="margin:1 1 1 20;"><SPAN>SELECT </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>T.id AS id , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>T.Botanical , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>T.Common , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>T.Property AS Zone , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>T.Side , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>T.ClosestAddress , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>T.ClosestAPN , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>T.OnStreet , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>T.Parkway_Ty , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>T.Trunks , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.OpDate , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.Operator , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.Activity , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.recmaint , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.DBH , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.Height AS Height , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.Crown AS Crown , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.Condition , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.Clearance , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.Observations , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.GlobalID , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.Status , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>TA.ParentGUID , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>T.Shape , </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>T.OBJECTID </SPAN></P><P STYLE="margin:1 1 1 20;"><SPAN>FROM </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>(SELECT </SPAN></P><P STYLE="margin:0 0 0 88;"><SPAN>a.* </SPAN></P><P STYLE="margin:0 0 0 40;"><SPAN>FROM </SPAN></P><P STYLE="margin:0 0 0 88;"><SPAN>(SELECT </SPAN></P><P STYLE="margin:0 0 0 136;"><SPAN>*, </SPAN></P><P STYLE="margin:0 0 0 136;"><SPAN>ROW_NUMBER() OVER (PARTITION BY ParentGUID ORDER BY OpDate DESC) ranked_order </SPAN></P><P STYLE="margin:0 0 0 88;"><SPAN>FROM </SPAN></P><P STYLE="margin:0 0 0 136;"><SPAN>toaks_sde.TOAKS_DATA_LOADER.TreeActivity_evw) a </SPAN></P><P STYLE="margin:0 0 0 136;"><SPAN>WHERE </SPAN></P><P STYLE="margin:0 0 0 184;"><SPAN>a.ranked_order = 1) </SPAN></P><P STYLE="margin:1 1 1 20;"><SPAN>AS TA </SPAN></P><P STYLE="margin:1 1 1 20;"><SPAN>JOIN toaks_sde.TOAKS_DATA_LOADER.Trees AS T ON T .GlobalID = TA.ParentGUID</SPAN></P><P><SPAN /></P></DIV></DIV></DIV>

Service Item Id: 8fe6aa54e5eb415da72590502dc23cf5

Copyright Text: Mary Anne Van Zuyle, GIS Analyst, City of Thousand Oaks

Default Visibility: true

MaxRecordCount: 2000

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: 6261799.017292798
YMin: 1873730.4611488134
XMax: 6324273.112816811
YMax: 1914428.842678398
Spatial Reference: 102645  (2229)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [56, 168, 0, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• id ( type: esriFieldTypeInteger, alias: id )
• Botanical ( type: esriFieldTypeString, alias: Botanical, length: 255 )
• Common ( type: esriFieldTypeString, alias: Common, length: 255 )
• Zone ( type: esriFieldTypeString, alias: Zone, length: 10 )
• Side ( type: esriFieldTypeString, alias: Side, length: 20 )
• ClosestAddress ( type: esriFieldTypeString, alias: ClosestAddress, length: 255 )
• ClosestAPN ( type: esriFieldTypeString, alias: ClosestAPN, length: 24 )
• OnStreet ( type: esriFieldTypeString, alias: OnStreet, length: 255 )
• Parkway_Ty ( type: esriFieldTypeString, alias: Parkway_Ty, length: 20 )
• Trunks ( type: esriFieldTypeDouble, alias: Trunks )
• OpDate ( type: esriFieldTypeDate, alias: OpDate, length: 8 )
• Operator ( type: esriFieldTypeString, alias: Operator, length: 50 )
• Activity ( type: esriFieldTypeString, alias: Activity, length: 50 )
• recmaint ( type: esriFieldTypeString, alias: recmaint, length: 50 )
• DBH ( type: esriFieldTypeSmallInteger, alias: DBH )
• Height ( type: esriFieldTypeString, alias: Height, length: 5 )
• Crown ( type: esriFieldTypeString, alias: Crown, length: 6 )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 20 )
• Clearance ( type: esriFieldTypeString, alias: Clearance, length: 255 )
• Observations ( type: esriFieldTypeString, alias: Observations, length: 255 )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• Status ( type: esriFieldTypeString, alias: Status, length: 32 )
• ParentGUID ( type: esriFieldTypeGUID, alias: ParentGUID, length: 38 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata