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

Max Scale: 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: -1.3628069281784356E7
YMin: 4610711.326269144
XMax: -1.3607446084914349E7
YMax: 4648270.954866297
Spatial Reference: 102100  (3857)

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] , ...18 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 DORDER 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] , ...4 more... )
• DURATION_MIN ( type: esriFieldTypeInteger, alias: DURATION_MIN )
• ELEVATION_FT ( type: esriFieldTypeDouble, alias: ELEVATION_FT )

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

  Iteminfo   Thumbnail   Metadata