Layer: Water Mains (ID:53)

View In: Map Viewer

Name: Water Mains

Display Field: WMAIN_ID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Water Main Lines Drawn in or GPS collected by RCAP Solutions. Locations will serve as an asset inventory for the use of asset management program to monitor the condition and manage the replacement of assets. Furthermore, data may be used for recording operation and maintenance activity and improving system design.

Copyright Text: RCAP Solutions

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":2.5}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"(DomainName($feature, 'SIZE')) + '-' + $feature.MATERIAL","title":"Water_Main_Label_UPDATED2"},"labelPlacement":"esriServerLinePlacementCenterAlong","textLayout":"followFeature","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":2000,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[115,223,255,255],"haloSize":1,"font":{"family":"Arial","size":8,"style":"normal","weight":"bold","decoration":"none"}}}]}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
WMAIN_ID (type: esriFieldTypeString, alias: Water Main ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ACTIVE (type: esriFieldTypeString, alias: Active Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
INSTALLDATE (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MATERIAL (type: esriFieldTypeString, alias: Pipe Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [COP: Copper], [CAS: Cast Iron], ... 9 more ...)
SIZE (type: esriFieldTypeDouble, alias: Size - Diameter of Pipe (inches), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4"], [1: 1"], [2: 2"], ... 12 more ...)
SURFTYP (type: esriFieldTypeString, alias: Surface Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ASPHALT: Asphalt], [EARTHEN: Earthen], [GRAVEL: Gravel], ... 3 more ...)
SURFLOC (type: esriFieldTypeString, alias: Surface Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Alley: Alley], [Driveway: Driveway], [Easement / Right of Way: Easement / Right of Way], ... 10 more ...)
DEPTH (type: esriFieldTypeDouble, alias: Depth (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
LOCDESC (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
CRITICALMAIN (type: esriFieldTypeString, alias: Critical Main, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
LENGTH (type: esriFieldTypeDouble, alias: Length (Design Engineering), SQL Type: sqlTypeOther, nullable: true, editable: true)
TRANSMISS (type: esriFieldTypeString, alias: Transmission Line, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Potable: Potable Water], [Raw: Raw Water], [Reclaimed: Reclaimed Water], ... 4 more ...)
BREAKS_ON_MAIN (type: esriFieldTypeSmallInteger, alias: Number of Breaks, SQL Type: sqlTypeOther, nullable: true, editable: true)
OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [-1: Private], [-2: Other], ... 1 more ...)
MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Utility Owned], [0: Private / Customer])
INSPECTED (type: esriFieldTypeString, alias: Inspected, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
MAINTEN_REQ (type: esriFieldTypeString, alias: Maintenance Request, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
SYSTEM (type: esriFieldTypeString, alias: System, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Distribution: Distribution], [High Pressure: High Pressure], [Transmission: Transmission], ... 2 more ...)
ASSET_CATEGORY (type: esriFieldTypeString, alias: Asset Category, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Source: Source], [Pumping Facility: Pumping Facility], [Treatment: Treatment], ... 5 more ...)
ASSET_SUB_CATEGORY (type: esriFieldTypeString, alias: Asset Sub Category, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ASSESSMENT_TYPE (type: esriFieldTypeString, alias: Assessment Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Valued Opinion: Valued Opinion], [Level 1: Level 1], [Level 2: Level 2])
DATE_ASSESSED (type: esriFieldTypeDate, alias: Date Assessed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
RISK (type: esriFieldTypeSmallInteger, alias: Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
RISK_RANKING (type: esriFieldTypeSmallInteger, alias: Risk Ranking, SQL Type: sqlTypeOther, nullable: true, editable: true)
EXPECTED_USEFUL_LIFE (type: esriFieldTypeSmallInteger, alias: Expected Useful Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
REMAINING_USEFUL_LIFE (type: esriFieldTypeSingle, alias: Remaining Useful Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
REPLACEMENT_COST (type: esriFieldTypeSingle, alias: Replacement Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
UNIT_COST (type: esriFieldTypeSingle, alias: Unit Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
COF (type: esriFieldTypeSmallInteger, alias: Consequence of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
CF_ASSET_SIZE (type: esriFieldTypeString, alias: CF Asset Size, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Less than 4" = 1], [2: 4" = 2], [3: 6" = 3], ... 4 more ...)
CF_OVERALL_CUST_IMPACT (type: esriFieldTypeString, alias: CF Overall Customer Impact, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: 10% = 1], [2: 10-30% = 2], [3: 30-50% = 3], ... 4 more ...)
CF_SIGNIF_IMPORTANT_CUST (type: esriFieldTypeString, alias: CF Critical Customers, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Residential Only = 1], [2: School / Church = 2], [3: Downtown Businesses = 3], ... 4 more ...)
CF_PIPE_LOCATION (type: esriFieldTypeString, alias: CF Pipe Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Unpaved = 1], [2: Minor Local = 2], [3: Major Local = 3], ... 4 more ...)
CF_DEPTH (type: esriFieldTypeString, alias: CF Depth, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Less than 6ft = 1], [2: 6 to 10ft = 2], [3: 10 to 14ft = 3], ... 4 more ...)
CF_PROX_ENVIRO_SENS (type: esriFieldTypeString, alias: CF Proximity to Sensitive Environment, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: 150 LF or more = 1], [2: 100-150 LF = 2], [3: 75-100 LF = 3], ... 4 more ...)
POF (type: esriFieldTypeSmallInteger, alias: Probability of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
PF_ASSET_STATUS (type: esriFieldTypeString, alias: PF Asset Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Fully Functional = 1], [2: Operates with difficulty = 2], [3: Operates but unreliable = 3], ... 4 more ...)
PF_CONDITION (type: esriFieldTypeString, alias: PF Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Excellent / Very good = 1], [2: Good = 2], [3: Fair / Operable = 3], ... 4 more ...)
CONDITION_COMMENTS (type: esriFieldTypeString, alias: Condition Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
PF_MAINTENANCE_HISTORY (type: esriFieldTypeString, alias: PF Maintenance History, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [1: Recommended best practices regularly followed = 1], [2: Assets are adequately maintained = 2], [3: No maintenance history = 3], ... 4 more ...)
PF_CAPACITY (type: esriFieldTypeString, alias: PF Capacity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Excess capacity = 1], [2: Limited capacity concerns = 2], [3: Moderate concerns / Limited Fire Flow / Sewer Surcharges = 3], ... 4 more ...)
AGE_RANGE (type: esriFieldTypeString, alias: Age Range, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: 2010-Present], [2: 2009-1980], [3: 1979-1950], ... 2 more ...)
MODIFYUSER (type: esriFieldTypeString, alias: MODIFYUSER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
MODIFYDATE (type: esriFieldTypeDate, alias: MODIFYDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
CREATOR (type: esriFieldTypeString, alias: CREATOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
CREATEDATE (type: esriFieldTypeDate, alias: CREATEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
ESRIGNSS_POSITIONSOURCETYPE (type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 2 more ...)
ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [EOS Arrow 100: EOS Arrow 100], [BadElf Surveyor: BadElf Surveyor], [Other: Other], ... 2 more ...)
ESRIGNSS_LATITUDE (type: esriFieldTypeDouble, alias: GPS Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: GPS Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_ALTITUDE (type: esriFieldTypeDouble, alias: GPS Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_H_RMS (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_V_RMS (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_FIXDATETIME (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ESRIGNSS_FIXTYPE (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
ESRIGNSS_CORRECTIONAGE (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_STATIONID (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 1023])
ESRIGNSS_NUMSATS (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
ESRIGNSS_PDOP (type: esriFieldTypeDouble, alias: PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_HDOP (type: esriFieldTypeDouble, alias: HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_VDOP (type: esriFieldTypeDouble, alias: VDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_DIRECTION (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_SPEED (type: esriFieldTypeDouble, alias: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRISNSR_AZIMUTH (type: esriFieldTypeDouble, alias: Compass reading (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_H_RMS (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_V_RMS (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_POSITIONS (type: esriFieldTypeSmallInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_H_STDDEV (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
EXT_USER (type: esriFieldTypeString, alias: Engineer / Contractor Name for Project, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
AGENCY (type: esriFieldTypeString, alias: Agency for GIS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CONTACT (type: esriFieldTypeString, alias: Contact Name for GIS, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
ATT_SOURCE (type: esriFieldTypeString, alias: Attribute Information Source (Operator Name), SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
ATT_ISSUES (type: esriFieldTypeString, alias: Attribute Issues, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
XY_SOURCE (type: esriFieldTypeString, alias: GPS External Source Reference, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [AERIAL IMAGERY: KY1Z 12-INCH RESOLUTION: Aerial Imagery (12-INCH Meter Resolution)], [AERIAL IMAGERY: KY1Z 2-FOOT RESOLUTION: Aerial Imagery (2FT Resolution)], [AERIAL IMAGERY: KY1Z 6-INCH RESOLUTION: Aerial Imagery (6-INCH Resolution)], ... 6 more ...)
XY_ISSUES (type: esriFieldTypeString, alias: GPS Location Issues LIST HERE, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
POINT_X (type: esriFieldTypeDouble, alias: Calculated X - Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Y (type: esriFieldTypeDouble, alias: Calculated Y - Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Z (type: esriFieldTypeDouble, alias: Calculated Z - Surface Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
ELEV_SRC (type: esriFieldTypeString, alias: Elevation Source, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
SEQUENTIAL_ID (type: esriFieldTypeString, alias: Sequential ID to help with Asset ID purposes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

SIZE: 8
SURFTYP: ASPHALT
SURFLOC: Street / Road
TRANSMISS: No
WATERTYPE: Potable
OWNEDBY: 1
MAINTBY: 1
INSPECTED: No
MAINTEN_REQ: No
XY_SOURCE: GPS: MAPPING GRADE OBSERVATION
AGENCY: RCAP Solutions

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/28/2023 3:24:08 PM

Schema Last Edit Date: 8/22/2023 12:31:11 PM

Data Last Edit Date: 8/28/2023 3:24:08 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Attachments Add Features Update Features Delete Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat