{ "culture": "en-US", "name": "", "guid": "", "catalogPath": "", "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.", "description": "

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>

H.FLOWPHR, H.Static, H.Residual, H.PSI, H.Flow,H.GalFlowed, H.IDTag, H.Ref, H.Notes, H.ISOYear, H.Contractor<\/SPAN><\/P>

FROM GISADMIN.wHydrant AS W<\/SPAN><\/P>

INNER JOIN GISADMIN.HydrantISOCOntractor_evw AS H ON W.FACILITYID = H.HydrantID<\/SPAN><\/P><\/DIV><\/DIV>", "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.", "title": "UTILITIES.gisadmin.HydrantContractorISOResults_VW", "tags": [ "Hydrant", "water", "ISO", "Contractor" ], "type": "", "typeKeywords": [], "thumbnail": "", "url": "", "minScale": 50000, "maxScale": 5000, "spatialReference": "", "accessInformation": "Sunrise GIS, Jon Stahl", "licenseInfo": "", "portalUrl": "" }