Name: Distribution Mains

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 500000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 352420.943749994
YMin: 2847460.370625
XMax: 404998.239999995
YMax: 2901487.27124999
Spatial Reference: 102686 (2249)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[190,255,232,255],"width":0.7},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• FACILITYID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MUNCIPALITY (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [LUDLOW: Ludlow], [WESTFIELD: Westfield], [SOUTHWICK: Southwick], ... 7 more ...)
• STREETNAME (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ABBE AV: ABBE AV], [ABBOTT ST: ABBOTT ST], [ABERDALE DR: ABERDALE DR], ... 2099 more ...)
• INSTALLYEAR (type: esriFieldTypeInteger, alias: Installed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SERVICEZONE (type: esriFieldTypeString, alias: ServiceZone, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [SPRING: Springfield], [LUDLOW: Ludlow], [WESTFIELD: Westfield], ... 8 more ...)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: LIFECYCLESTATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• DATASOURCE (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [FIELD: Field], [GPS: GPS], [AERIAL: Aerial Mapping], ... 7 more ...)
• DIAMETERMAIN (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1.25: 1 1/4"], [1.5: 1 1/2"], [4: 4 inch], ... 17 more ...)
• MATERIALMAIN (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [DI: Ductile Iron], [CI: Cast Iron], [LJ_CONC: LJ Concrete], ... 8 more ...)
• LININGTYPE (type: esriFieldTypeString, alias: Lining, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [CEMENT: Cement], [EPOXY: Epoxy], [NONE: None], ... 1 more ...)
• GROUNDSURFACETYPE (type: esriFieldTypeString, alias: Ground Surface Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Concrete: Concrete], [Earth: Earth], ... 1 more ...)
• PIPECLASS (type: esriFieldTypeString, alias: Pipe/Pressure Class, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [50: 50], [51: 51], [52: 52], ... 5 more ...)
• NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• REFERENCE_DOC (type: esriFieldTypeString, alias: REFERENCE_DOC, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• GISOBJID (type: esriFieldTypeInteger, alias: InforID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutOfServiceDate (type: esriFieldTypeDate, alias: Out of Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Subtype (type: esriFieldTypeString, alias: Subtype, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [ABANDONED: Abandoned], [DISTMAIN: Distribution Main], [RAWWATER: Raw Water Main], ... 2 more ...)
• OutOfService (type: esriFieldTypeString, alias: Out of Service, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [true: Out of Service], [false: In Service])
• InstallDate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EDITOR (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [SR: SR], [BK: BK], [MR: MR], ... 7 more ...)
• Ownership (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [SWSC: SWSC], [MWRA: MWRA], [PRIVATE: PRIVATE], ... 8 more ...)
• MainName (type: esriFieldTypeString, alias: Main Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Start_X (type: esriFieldTypeDouble, alias: Start_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Start_Y (type: esriFieldTypeDouble, alias: Start_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• End_X (type: esriFieldTypeDouble, alias: End_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• End_Y (type: esriFieldTypeDouble, alias: End_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Encased (type: esriFieldTypeString, alias: Polyethylene Encasement, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Distribution Mains
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• DATASOURCE: PLAN
• MATERIALMAIN: DI

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/19/2017 6:49:03 PM

Schema Last Edit Date: 5/19/2017 6:49:03 PM

Data Last Edit Date: 5/19/2017 6:49:03 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat