WaterPurveyor
(
type: esriFieldTypeString, alias: Water Purveyor, length: 8
, Coded Values:
[CTO: City of Thousand Oaks]
, [CWS: California Water Service]
, [CAL-AM: California American Water]
, ...1 more...
)
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