20260210
16332700
1.0
FALSE
DeadEndHydrantFlushingReporting_VW
002
857708.104796
908900.382989
617206.164907
676539.552802
1
Projected
GCS_North_American_1983_HARN
Linear Unit: Foot_US (0.304801)
NAD_1983_HARN_StatePlane_Florida_East_FIPS_0901_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.8'><WKT>PROJCS["NAD_1983_HARN_StatePlane_Florida_East_FIPS_0901_Feet",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",656166.6666666665],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-81.0],PARAMETER["Scale_Factor",0.9999411764705882],PARAMETER["Latitude_Of_Origin",24.33333333333333],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2881]]</WKT><XOrigin>-17791300</XOrigin><YOrigin>-41645400</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2881</WKID><LatestWKID>2881</LatestWKID></ProjectedCoordinateSystem>
20261007
10512200
20261007
10512200
500000
5000
ItemDescription
Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362
DeadEndHydrantFlushingReporting_VW
1
-80.386236
-80.229278
26.193616
26.029634
This spatial view is used for reporting on Dead End Hydrant Flushing Activities. THe view uses the wHydrant layer and the DeadEndFlushing_History table.
Dead End
Hydrant
Flushiung
Utilities
<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>
Sunrise GIS, Jon Stahl
Feature Class
dataset
EPSG
8.9.3(9.0.0)
4370
Simple
FALSE
4370
FALSE
FALSE
DeadEndHydrantFlushingReporting_VW
Feature Class
4370
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
FACILITYID
FACILITYID
String
20
0
0
SHAPE
SHAPE
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
OWNEDBY
OWNEDBY
String
30
0
0
ADDRESS
ADDRESS
String
50
0
0
CITY
CITY
String
15
0
0
MANUFACTURER
MANUFACTURER
String
30
0
0
MODEL
MODEL
String
20
0
0
MODELYEAR
MODELYEAR
Integer
4
10
0
INSTALLDATE
INSTALLDATE
Date
8
0
0
DEAD_END_HYDRANT
DEAD_END_HYDRANT
String
10
0
0
FLUSH_DATE
FLUSH_DATE
Date
8
0
0
FLUSH_TIME
FLUSH_TIME
String
10
0
0
STATIC_PRESSURE
STATIC_PRESSURE
String
10
0
0
GAL_USED
GAL_USED
String
10
0
0
INITIAL_WATERQUALITY
INITIAL_WATERQUALITY
String
10
0
0
FINAL_WATERQUALITY
FINAL_WATERQUALITY
String
10
0
0
INITIAL_CHLORINE
INITIAL_CHLORINE
String
5
0
0
FINAL_CHLORINE
FINAL_CHLORINE
String
5
0
0
OPERATOR
OPERATOR
String
50
0
0
COMMENTS
COMMENTS
String
150
0
0
20261007