ItemInfo

Item Information

snippet:	This spatial view is used for reporting on Dead End Hydrant Flushing Activities. THe view uses the wHydrant layer and the DeadEndFlushing_History table.
summary:	This spatial view is used for reporting on Dead End Hydrant Flushing Activities. THe view uses the wHydrant layer and the DeadEndFlushing_History table.
accessInformation:	Sunrise GIS, Jon Stahl
thumbnail:
maxScale:	5000
typeKeywords:	[]
description:	<DIV STYLE="text-align:Left;"><DIV><P><SPAN>CREATE VIEW DeadEndHydrantFlushingReporting_VW AS SELECT </SPAN></P><P><SPAN> A.OBJECTID, </SPAN></P><P><SPAN> A.FACILITYID, </SPAN></P><P><SPAN> A.SHAPE, </SPAN></P><P><SPAN> A.OWNEDBY, </SPAN></P><P><SPAN> A.ADDRESS, </SPAN></P><P><SPAN> A.CITY, </SPAN></P><P><SPAN> A.MANUFACTURER, </SPAN></P><P><SPAN> A.MODEL, </SPAN></P><P><SPAN> A.MODELYEAR, </SPAN></P><P><SPAN> A.INSTALLDATE, </SPAN></P><P><SPAN> A.DEAD_END_HYDRANT, </SPAN></P><P><SPAN> B.FLUSH_DATE, </SPAN></P><P><SPAN> B.FLUSH_TIME, </SPAN></P><P><SPAN> B.STATIC_PRESSURE, </SPAN></P><P><SPAN> B.GAL_USED, </SPAN></P><P><SPAN> B.INITIAL_WATERQUALITY, </SPAN></P><P><SPAN> B.FINAL_WATERQUALITY, </SPAN></P><P><SPAN> B.INITIAL_CHLORINE, </SPAN></P><P><SPAN> B.FINAL_CHLORINE, </SPAN></P><P><SPAN> B.OPERATOR, </SPAN></P><P><SPAN> B.COMMENTS</SPAN></P><P><SPAN>FROM </SPAN></P><P><SPAN> UTILITIES.GISADMIN.wHydrant AS A</SPAN></P><P><SPAN>LEFT JOIN </SPAN></P><P><SPAN> UTILITIES.GISADMIN.DeadEndFlushing_History_evw AS B </SPAN></P><P><SPAN>ON </SPAN></P><P><SPAN> A.FACILITYID = B.FACILITYID</SPAN></P><P><SPAN>WHERE </SPAN></P><P><SPAN> A.DEAD_END_HYDRANT = 'YES' </SPAN></P></DIV></DIV>
licenseInfo:
catalogPath:
title:	UTILITIES.gisadmin.DeadEndHydrantFlushingReporting_VW
type:
url:
tags:	["Dead End","Hydrant","Flushiung","Utilities"]
culture:	en-US
portalUrl:
name:
guid:
minScale:	500000
spatialReference: