20250728
16492700
1.0
FALSE
SDE.SDE.HydrantsJuly2025
002
Server=sql01; Service=sde:sqlserver:sql01; Database=SDE; User=sde; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Foot (0.304800)
NAD_1983_StatePlane_South_Carolina_FIPS_3900_Feet_Intl
<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/3.1.0'><WKT>PROJCS["NAD_1983_StatePlane_South_Carolina_FIPS_3900_Feet_Intl",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",2000000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-81.0],PARAMETER["Standard_Parallel_1",32.5],PARAMETER["Standard_Parallel_2",34.83333333333334],PARAMETER["Latitude_Of_Origin",31.83333333333333],UNIT["Foot",0.3048],AUTHORITY["EPSG",2273]]</WKT><XOrigin>-122907600</XOrigin><YOrigin>-92800700</YOrigin><XYScale>3048</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808398950131233</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2273</WKID><LatestWKID>2273</LatestWKID></ProjectedCoordinateSystem>
ExportFeatures All_Hydrants_2025 D:\Users\abrooks\AppData\Roaming\Esri\ArcGISPro\Favorites\sql01_SDE.sde\SDE.SDE.Fire\SDE.SDE.HydrantsJuly2025 # NOT_USE_ALIAS "STREET_NAME "STREET_NAME" true true false 36 Text 0 0,First,#,All_Hydrants_2025,STREET_NAME,0,36;GISID "MPW ID" true true false 4 Long 0 0,First,#,All_Hydrants_2025,GISID,-1,-1;HYD_ID "FD ID" true true false 255 Text 0 0,First,#,All_Hydrants_2025,HYD_ID,0,255;LOCATION_DESCRIPTION "LOCATION DESCRIPTION" true true false 255 Text 0 0,First,#,All_Hydrants_2025,LOCATION_DESCRIPTION,0,255;Last_Flow "Last Full Flow" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Last_Flow,-1,-1;TestStatus "Test Status" true true false 255 Text 0 0,First,#,All_Hydrants_2025,TestStatus,0,255;District "District" true true false 2 Short 0 0,First,#,All_Hydrants_2025,District,-1,-1;Restriction "Meter Restriction (in)" true true false 2 Short 0 0,First,#,All_Hydrants_2025,Restriction,-1,-1;Static "Static" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Static,-1,-1;Residual "Residual" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Residual,-1,-1;Flow "Flow" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Flow,-1,-1;Damage "Damage" true true false 255 Text 0 0,First,#,All_Hydrants_2025,Damage,0,255;FD_Comment "Comment" true true false 255 Text 0 0,First,#,All_Hydrants_2025,FD_Comment,0,255;DateFlowed "Date of Flow" true true false 8 Date 0 0,First,#,All_Hydrants_2025,DateFlowed,-1,-1;FlowedBy "Flowed By" true true false 40 Text 0 0,First,#,All_Hydrants_2025,FlowedBy,0,40;FlowHydrant "Flow Hydrant" true true false 15 Text 0 0,First,#,All_Hydrants_2025,FlowHydrant,0,15;Residual20 "Residual 20" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Residual20,-1,-1;Residual10 "Residual 10" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Residual10,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,All_Hydrants_2025,GlobalID,-1,-1;Town "In Town (Y/N)" true true false 10 Text 0 0,First,#,All_Hydrants_2025,Town,0,10;GPM "GPM" true true false 8 Double 0 0,First,#,All_Hydrants_2025,GPM,-1,-1;CreationDate "CreationDate" true true false 8 Date 0 0,First,#,All_Hydrants_2025,CreationDate,-1,-1;Creator "Creator" true true false 128 Text 0 0,First,#,All_Hydrants_2025,Creator,0,128;EditDate "EditDate" true true false 8 Date 0 0,First,#,All_Hydrants_2025,EditDate,-1,-1;Editor "Editor" true true false 128 Text 0 0,First,#,All_Hydrants_2025,Editor,0,128;MaintenanceStatus "Maintenance Status" true true false 255 Text 0 0,First,#,All_Hydrants_2025,MaintenanceStatus,0,255;MaintenanceCompletedDate "MaintenanceCompletedDate" true true false 8 Date 0 0,First,#,All_Hydrants_2025,MaintenanceCompletedDate,-1,-1;Static_2022 "2022 Static" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Static_2022,-1,-1;Residual_2022 "2022 Residual" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Residual_2022,-1,-1;Flow_2022 "2022 Float" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Flow_2022,-1,-1;Static_2023 "2023 Static" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Static_2023,-1,-1;Residual_2023 "2023 Residual" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Residual_2023,-1,-1;Flow_2023 "2023 Flow" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Flow_2023,-1,-1;Static_2024 "Static 2024" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Static_24,-1,-1;Residual_2024 "Residual 2024" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Residual_24,-1,-1;Flow_2024 "Flow 2024" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Flow_24,-1,-1;Static_2025 "2025 Static" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Static_2025,-1,-1;Residual_2025 "2025 Residual" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Residual_2025,-1,-1;Flow_2025 "2025 Flow" true true false 8 Double 0 0,First,#,All_Hydrants_2025,Flow_2025,-1,-1;CreationDate_1 "CreationDate" true true false 8 Date 0 0,First,#,All_Hydrants_2025,CreationDate_1,-1,-1;Creator_1 "Creator" true true false 128 Text 0 0,First,#,All_Hydrants_2025,Creator_1,0,128;EditDate_1 "EditDate" true true false 8 Date 0 0,First,#,All_Hydrants_2025,EditDate_1,-1,-1;Editor_1 "Editor" true true false 128 Text 0 0,First,#,All_Hydrants_2025,Editor_1,0,128;CreationDate_2 "CreationDate" false true false 8 Date 0 0,First,#,All_Hydrants_2025,CreationDate_2,-1,-1;Creator_2 "Creator" false true false 128 Text 0 0,First,#,All_Hydrants_2025,Creator_2,0,128;EditDate_2 "EditDate" false true false 8 Date 0 0,First,#,All_Hydrants_2025,EditDate_2,-1,-1;Editor_2 "Editor" false true false 128 Text 0 0,First,#,All_Hydrants_2025,Editor_2,0,128" #
CalculateField SDE.SDE.HydrantsJuly2025 Last_Flow "2025" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Static_2025 !Static! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Residual_2025 !Residual! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Flow_2025 !Flow! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Static_2025 !Static! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Static_2025 !Static! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Residual_2025 !Residual! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Flow_2025 !Flow! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Residual10 "((!Static! ** 0.54) / ((!Static! - !Residual!) ** 0.54)) * !GPM!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 GPM calc_gpm(!Flow!) "Python 3" "from math import pow
def calc_gpm(flow):
if flow in (None, ""):
return None
try:
f = float(flow)
except:
return None
if f < 0:
return None
return 174.6 * pow(f, 0.5)" Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Residual10 calc_value(!Static!, !Residual!, !GPM!) "Python 3" "def calc_value(static, residual, gpm):
if static is None or residual is None or gpm is None:
return None
denom = static - residual
if denom == 0:
return None
return (static**0.54) / (denom**0.54) * gpm" Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Residual10 calc_value(!Static!, !Residual!, !GPM!) "Python 3" "def calc_value(static, residual, gpm):
if static is None or residual is None or gpm is None:
return None
denom = static - residual
if denom == 0:
return None
return (static**0.54) / (denom**0.54) * gpm" Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Residual10 calc_value(!Static!, !Residual!, !GPM!) "Python 3" "def calc_value(static, residual, gpm):
if static is None or residual is None or gpm is None:
return None
denom = static - residual
if denom == 0:
return None
return (static**0.54) / (denom**0.54) * gpm" Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 GPM calc_gpm(!Flow!) "Python 3" "from math import pow
def calc_gpm(flow):
if flow in (None, ""):
return None
try:
f = float(flow)
except:
return None
if f < 0:
return None
return 174.6 * pow(f, 0.5)" Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Residual10 calc_value(!Static!, !Residual!, !GPM!) "Python 3" "def calc_value(static, residual, gpm):
if static is None or residual is None or gpm is None:
return None
denom = static - residual
if denom == 0:
return None
return (static**0.54) / (denom**0.54) * gpm" Text NO_ENFORCE_DOMAINS
CalculateField SDE.SDE.HydrantsJuly2025 Residual20 calc_flow20(!Static!, !Residual!, !GPM!) "Python 3" "def calc_flow20(static, residual, gpm):
if None in (static, residual, gpm):
return None
try:
num = (static - 20) ** 0.54
denom = (static - residual) ** 0.54
if denom == 0:
return None
return (num / denom) * gpm
except:
return None" Text NO_ENFORCE_DOMAINS
20250728
14570100
20250814
14523900
150000000
5000
ItemDescription
Esri ArcGIS 13.1.0.41833
Hydrants
Hydrants updated July 2025. Source data Mount Pleasant Waterworks.
Hydrants
MapServer
Enterprise Geodatabase Feature Class
dataset
EPSG
6.9(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
SDE.SDE.HydrantsJuly2025
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
STREET_NAME
STREET_NAME
String
36
0
0
GISID
MPW ID
Integer
4
10
0
HYD_ID
FD ID
String
255
0
0
LOCATION_DESCRIPTION
LOCATION DESCRIPTION
String
255
0
0
Last_Flow
Last Full Flow
Double
8
38
8
TestStatus
Test Status
String
255
0
0
District
District
SmallInteger
2
5
0
Restriction
Meter Restriction (in)
SmallInteger
2
5
0
Static
Static
Double
8
38
8
Residual
Residual
Double
8
38
8
Flow
Flow
Double
8
38
8
Damage
Damage
String
255
0
0
FD_Comment
Comment
String
255
0
0
DateFlowed
Date of Flow
Date
8
0
0
FlowedBy
Flowed By
String
40
0
0
FlowHydrant
Flow Hydrant
String
15
0
0
Residual20
Residual 20
Double
8
38
8
Residual10
Residual 10
Double
8
38
8
GlobalID
GlobalID
GlobalID
38
0
0
Town
In Town (Y/N)
String
10
0
0
GPM
GPM
Double
8
38
8
CreationDate
CreationDate
Date
8
0
0
Creator
Creator
String
128
0
0
EditDate
EditDate
Date
8
0
0
Editor
Editor
String
128
0
0
MaintenanceStatus
Maintenance Status
String
255
0
0
MaintenanceCompletedDate
MaintenanceCompletedDate
Date
8
0
0
Static_2022
2022 Static
Double
8
38
8
Residual_2022
2022 Residual
Double
8
38
8
Flow_2022
2022 Float
Double
8
38
8
Static_2023
2023 Static
Double
8
38
8
Residual_2023
2023 Residual
Double
8
38
8
Static_2024
Static 2024
Double
8
38
8
Residual_2024
Residual 2024
Double
8
38
8
Flow_2024
Flow 2024
Double
8
38
8
Static_2025
2025 Static
Double
8
38
8
Residual_2025
2025 Residual
Double
8
38
8
Flow_2025
2025 Flow
Double
8
38
8
Flow_2023
2023 Flow
Double
8
38
8
CreationDate_1
CreationDate
Date
8
0
0
Creator_1
Creator
String
128
0
0
EditDate_1
EditDate
Date
8
0
0
CreationDate_2
CreationDate
Date
8
0
0
Creator_2
Creator
String
128
0
0
EditDate_2
EditDate
Date
8
0
0
Editor_2
Editor
String
128
0
0
Editor_1
Editor
String
128
0
0
20250814
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigD//2Q==