All Layers and Tables (Utility/Utility_Water

Layers:

Layer: Water Main (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Has Labels:

Can Modify Layer:

Can Scale Symbols:

Use Standardized Queries:

Supports Datum Transformation:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: true

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, length: 20 )
STATUS ( type: esriFieldTypeString, alias: Status of the Asset, length: 10 , Coded Values: [AB: Abandoned] , [AT: Active] , [VA: Vacated] , ...2 more... )
IMS_WM_SECTION ( type: esriFieldTypeSmallInteger, alias: Section of Pipe , Coded Values: [1: Section1] , [2: Section2] , [3: Section3] , ...5 more... )
INSTALLATIONDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
DIAMETER ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [1.5: 1 1/2"] , [1: 1"] , [0.5: 1/2"] , ...19 more... )
MATERIAL ( type: esriFieldTypeString, alias: Material, length: 10 , Coded Values: [AC: Asbestos Cement] , [CI: Cast Iron] , [CP: Copper] , ...9 more... )
PIPECLASS ( type: esriFieldTypeString, alias: Pipe Class, length: 10 , Coded Values: [CL150: Class 150] , [CL200: Class 200] , [CL250: Class 250] , ...14 more... )
INSTREET ( type: esriFieldTypeString, alias: In Street, length: 1 , Coded Values: [P: Parkway] , [S: Street] , [UNK: Unknown] )
WORK_ORDER_NUM ( type: esriFieldTypeString, alias: Work Order Number, length: 25 )
CONTRACT_NUM ( type: esriFieldTypeString, alias: Contract Number, length: 30 )
DRAWINGNUM ( type: esriFieldTypeString, alias: Drawing Number, length: 30 )
IMS_WM_SEGID ( type: esriFieldTypeInteger, alias: Street Centerline Segment ID )
IMS_WM_ONST ( type: esriFieldTypeString, alias: On Street, length: 100 )
IMS_WM_SV_AREA ( type: esriFieldTypeString, alias: Service Area, length: 10 , Coded Values: [CTPZ: Central Pressure Zone] , [CWPZ: Coldwater Pressure Zone] , [HSPZ: Honeysuckle Pressure Zone] , ...5 more... )
WATERTYPE ( type: esriFieldTypeString, alias: Water Type, length: 10 , Coded Values: [Potable: Potable Water] , [Raw: Raw Water] , [Reclaimed: Reclaimed Water] , ...5 more... )
OWNEDBY ( type: esriFieldTypeString, alias: Owned By, length: 10 , Coded Values: [ACRWSD: Allen County Regional Water and Sewer District] , [AQIN: AquaIndiana] , [ARMY: Army Corps of Engineers] , ...9 more... )
MAINTBY ( type: esriFieldTypeString, alias: Managed By, length: 5 , Coded Values: [ACRWS: Allen County Regional Water and Sewer District] , [AQIN: AquaIndiana] , [ARMY: Army Corps of Engineers] , ...9 more... )
Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
UNITID ( type: esriFieldTypeString, alias: UNITID, length: 20 )
UNITID2 ( type: esriFieldTypeString, alias: UNITID2, length: 20 )
MAINCOMP1 ( type: esriFieldTypeSmallInteger, alias: MAINCOMP1 )
MAINCOMP2 ( type: esriFieldTypeSmallInteger, alias: MAINCOMP2 )
COMPTYPE ( type: esriFieldTypeSmallInteger, alias: COMPTYPE )
COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY )
PARLINENO ( type: esriFieldTypeString, alias: PARLINENO, length: 2 )
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 )
NEARJUNCID ( type: esriFieldTypeString, alias: NEARJUNCID, length: 20 )
FARJUNCID ( type: esriFieldTypeString, alias: FARJUNCID, length: 20 )
UNITTYPE ( type: esriFieldTypeString, alias: UNITTYPE, length: 10 , Coded Values: [Potable: Potable Water] , [Raw: Raw Water] , [Reclaimed: Reclaimed Water] , ...5 more... )
SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 300 )
DEPTHTOPMAIN ( type: esriFieldTypeInteger, alias: Depth To Top of Main )
DEPTHMSRDDATE ( type: esriFieldTypeDate, alias: Depth Measured Date, length: 8 )
DEPTHMSRDBY ( type: esriFieldTypeString, alias: Depth Measured By, length: 50 )
DEPTHNOTES ( type: esriFieldTypeString, alias: Depth Notes, length: 300 )
Visibility ( type: esriFieldTypeString, alias: Visibility, length: 255 , Coded Values: [All: All] , [Internal: Internal] )
ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, length: 255 )
ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy m )
ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy m )
ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites , Range: [0, 99] )
ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
Data_Source ( type: esriFieldTypeString, alias: Data Source, length: 255 , Coded Values: [Aerial: Visually From an Aerial or Map] , [GPS: GPS] , [Survey: High-Accuracy Survey with Benchmark] , ...1 more... )
Date_Collected ( type: esriFieldTypeDate, alias: Date Collected, length: 8 )
Collected_By ( type: esriFieldTypeString, alias: Collected By, length: 255 , Coded Values: [CH2M: CH2MHILL] , [CSS: Construction Support Services] , [CUE: City Utilities Engineering] , ...13 more... )
QA_QC_By ( type: esriFieldTypeString, alias: QA QC By, length: 255 )
QA_QC_Date ( type: esriFieldTypeDate, alias: QA QC Date, length: 8 )
FSA_NUMBER ( type: esriFieldTypeString, alias: FSA Number, length: 20 )
Main_Type ( type: esriFieldTypeString, alias: Main Type, length: 10 , Coded Values: [FSA: Fire Service] , [ML: Mainline] , [SERV: Service] )
GPS_COLLECTION_LOCATION ( type: esriFieldTypeString, alias: GPS_COLLECTION_LOCATION, length: 2 , Coded Values: [AS: Asset] , [GR: Ground] )
ADDRKEY ( type: esriFieldTypeInteger, alias: ADDRKEY )
Transmission_System ( type: esriFieldTypeString, alias: Transmission System, length: 5 , Coded Values: [TR: Transmission] , [DI: Distribution] , [PR: Production] , ...1 more... )
Tap_Acceptable ( type: esriFieldTypeString, alias: Tap Acceptable, length: 5 , Coded Values: [YS: Yes] , [YC: Yes with CUE Approval] , [NO: No] )

Layer: Water Main Retired (2)