ItemInfo

Item Information

snippet:	This spatial view is used to show the hydrants that have been inspected by the City's ISO contractors. It uses the wHydrant layer and the HydrantISOContractor table.
summary:	This spatial view is used to show the hydrants that have been inspected by the City's ISO contractors. It uses the wHydrant layer and the HydrantISOContractor table.
accessInformation:	Sunrise GIS, Jon Stahl
thumbnail:
maxScale:	5000
typeKeywords:	[]
description:	<DIV STYLE="text-align:Left;"><DIV><P><SPAN>CREATE VIEW HydrantContractorISOResults_VW AS SELECT W.OBJECTID, W.FACILITYID, W.SHAPE, H.HydrantID, W.City ,H.InspectDate, H.Make, H.Model, H.MainValveSize, H.Year, H.Address, H.CrossStreet, </SPAN></P><P><SPAN>H.FLOWPHR, H.Static, H.Residual, H.PSI, H.Flow,H.GalFlowed, H.IDTag, H.Ref, H.Notes, H.ISOYear, H.Contractor</SPAN></P><P><SPAN>FROM GISADMIN.wHydrant AS W</SPAN></P><P><SPAN>INNER JOIN GISADMIN.HydrantISOCOntractor_evw AS H ON W.FACILITYID = H.HydrantID</SPAN></P></DIV></DIV>
licenseInfo:
catalogPath:
title:	UTILITIES.gisadmin.HydrantContractorISOResults_VW
type:
url:
tags:	["Hydrant","water","ISO","Contractor"]
culture:	en-US
portalUrl:
name:
guid:
minScale:	50000
spatialReference: