Name: Active Main Leaks

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Water Utilities Department managed feature dataset. Updated regularly through ArcGIS Desktop software. Maintains data integrity with RTK GPS and asset management program. Should you need this for a project please contact the water utilities department. Feature for planning and development.

Service Item Id: f41f86a942334c7ab10a3620aa478d2f

Copyright Text: Metadata written by Water Engineering Assistant TEspinoza. Updated December 30, 2024.

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 140000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 6440580.51102531
YMin: 1842630.7596103996
XMax: 6493359.340178728
YMax: 1938798.813336894
Spatial Reference: 102642  (2226)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 20 )
• STREETNUM ( type: esriFieldTypeString, alias: STREETNUM, length: 10 )
• STREET ( type: esriFieldTypeString, alias: STREET, length: 50 , Coded Values: [A ST: A ST] , [ABBEY CT: ABBEY CT] , [ABRUZZINI CT: ABRUZZINI CT] , ...1418 more... )
• CROSS_ST ( type: esriFieldTypeString, alias: CROSS STREET, length: 50 , Coded Values: [A ST: A ST] , [ABBEY CT: ABBEY CT] , [ABRUZZINI CT: ABRUZZINI CT] , ...1418 more... )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 20 , Coded Values: [AC: AC] , [C900: C900] , [C900 F: C900 F] , ...19 more... )
• MAINSIZE ( type: esriFieldTypeDouble, alias: MAIN DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...18 more... )
• MAINSTATUS ( type: esriFieldTypeString, alias: MAIN STATUS, length: 20 )
• LEAKTYPE ( type: esriFieldTypeString, alias: LEAK TYPE, length: 30 , Coded Values: [BIG HOLE: BIG HOLE] , [CRACK AROUND DIAMETER: CRACK AROUND DIAMETER] , [MOVED AT JOINT: MOVED AT JOINT] , ...5 more... )
• LEAKCAUSE ( type: esriFieldTypeString, alias: LEAK CAUSE, length: 50 , Coded Values: [Contractor: Contractor] , [Corrosion: Corrosion] , [Ground Movement: Ground Movement] , ...3 more... )
• EQRELATED ( type: esriFieldTypeString, alias: EQ RELATED, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• REPAIRTYPE ( type: esriFieldTypeString, alias: REPAIR TYPE, length: 30 , Coded Values: [Abandon: Abandon] , [Collar: Collar] , [Liner: Liner] , ...9 more... )
• MAININSTALLYEAR ( type: esriFieldTypeSmallInteger, alias: MAIN INSTALL YEAR , Range: [1850, 2099] )
• LEAKREPORTEDDATE ( type: esriFieldTypeDate, alias: LEAK REPORTED DATE, length: 8 )
• LEAKREPAIRDDATE ( type: esriFieldTypeDate, alias: LEAK REPAIR DATE, length: 8 )
• MAINFACILITYID ( type: esriFieldTypeString, alias: MAIN FACILITYID, length: 20 )
• TASKID ( type: esriFieldTypeSmallInteger, alias: TASK ID )
• LOCDESC ( type: esriFieldTypeString, alias: LOCDESC, length: 50 )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 100 )
• WONUM_OLDLEAKDB ( type: esriFieldTypeString, alias: WONUM_OLDLEAKDB, length: 20 )
• LEAKID_OLD ( type: esriFieldTypeDouble, alias: LEAK ID OLD )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ASSETTYPE ( type: esriFieldTypeString, alias: ASSETTYPE, length: 20 , Coded Values: [1: Air Valve] , [2: Blow Off] , [3: Hydrant] , ...5 more... )
• LEAKID ( type: esriFieldTypeString, alias: LEAKID, length: 15 )
• WORK_ORDERID ( type: esriFieldTypeString, alias: WORK ORDER ID, length: 20 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• LeakYear ( type: esriFieldTypeSmallInteger, alias: LeakYear , Range: [1850, 2099] )
• DEPTHTOPPIPE ( type: esriFieldTypeDouble, alias: DEPTH TOP OF PIPE )
• PRESSURE_ZONE ( type: esriFieldTypeString, alias: PRESSURE ZONE, length: 30 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...5 more... )
• DURATION_MIN ( type: esriFieldTypeInteger, alias: DURATION_MIN )
• ELEVATION_FT ( type: esriFieldTypeDouble, alias: ELEVATION_FT )
• Water_System_Name ( type: esriFieldTypeString, alias: Water System Name, length: 40 )
• PWSID ( type: esriFieldTypeString, alias: PWSID, length: 30 )
• Failure_Discovery_Time ( type: esriFieldTypeDate, alias: Failure Discovery Time, length: 8 )
• Leak_Stopped_Pre_Repair ( type: esriFieldTypeDate, alias: Leak Stopped Pre Repair, length: 8 )
• Repair_Initiation_Time ( type: esriFieldTypeDate, alias: Repair Initiation Time, length: 8 )
• Repair_Completion_Time ( type: esriFieldTypeDate, alias: Repair Completion Time, length: 8 )
• Calculated_Loss_Gallons ( type: esriFieldTypeInteger, alias: Calculated Loss Gallons )
• Estimated_Loss_Gallons ( type: esriFieldTypeInteger, alias: Estimated Loss Gallons )
• Leak_Duration_Hours ( type: esriFieldTypeDouble, alias: Leak Duration Hours )
• Pipe_Age_Years ( type: esriFieldTypeDouble, alias: Pipe Age Years )
• Failure_Severity_Mode ( type: esriFieldTypeString, alias: Failure Severity Mode, length: 40 , Coded Values: [Catastrophic: Catastrophic] , [Major: Major] , [Minor: Minor] )
• Pressure_Envelope ( type: esriFieldTypeString, alias: Pressure Envelope, length: 12 )
• Location_Latitude ( type: esriFieldTypeDouble, alias: Location Latitude )
• Location_Longitude ( type: esriFieldTypeDouble, alias: Location Longitude )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata