{
 "culture": "en-US",
 "name": "",
 "guid": "",
 "catalogPath": "",
 "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.",
 "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>",
 "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.",
 "title": "UTILITIES.gisadmin.DeadEndHydrantFlushingReporting_VW",
 "tags": [
  "Dead End",
  "Hydrant",
  "Flushiung",
  "Utilities"
 ],
 "type": "",
 "typeKeywords": [],
 "thumbnail": "",
 "url": "",
 "minScale": 500000,
 "maxScale": 5000,
 "spatialReference": "",
 "accessInformation": "Sunrise GIS, Jon Stahl",
 "licenseInfo": "",
 "portalUrl": ""
}