ItemInfo

Item Information

snippet:	This is a sparial view that shows the results of ISO activities performed by Sunrise Utilities. Each hydrant recieves an annual ISO inspeciton. The view used the whydrant layer and the HydrantISO table. This spatial view replaces HydrantISOReporting. Updated June 2026. JS
summary:	This is a sparial view that shows the results of ISO activities performed by Sunrise Utilities. Each hydrant recieves an annual ISO inspeciton. The view used the whydrant layer and the HydrantISO table. This spatial view replaces HydrantISOReporting. Updated June 2026. JS
accessInformation:	Sunrise GIS, Jon Stahl
thumbnail:
maxScale:	5000
typeKeywords:	[]
description:	<DIV STYLE="text-align:Left;"><DIV><P><SPAN>CREATE VIEW bbb AS SELECT B.OBJECTID, A.FACILITYID, A.SHAPE, A.OWNEDBY, A.ADDRESS, A.CITY, A.MANUFACTURER, A.MODEL, A.MODELYEAR, A.INSTALLDATE, B.BLUEHYDRANTMARKER, B.CAP_MISSING,</SPAN></P><P><SPAN>B.GREASED, B.PAINT, B.CHAINS, B.STEM_CONDITION, B.FLUSH_DATE, B.FLUSH_TIME, B.STATIC_PRESSURE, B.GAL_USED, B.DISTANCE_FLUSHED, B.WATER_CONDITION, B.MAINTBY</SPAN></P><P><SPAN>FROM UTILITIES.GISADMIN.wHydrant AS A</SPAN></P><P><SPAN>RIGHT OUTER JOIN UTILITIES.GISADMIN.HydrantISO_evw AS B on A.FACILITYID = B.FACILITYID</SPAN></P></DIV></DIV>
licenseInfo:
catalogPath:
title:	UTILITIES.gisadmin.HydrantISOSunriseReporting1
type:
url:
tags:	["Hydrant","ISO"]
culture:	en-US
portalUrl:
name:
guid:
minScale:	500000
spatialReference: