{ "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": ""
}