Layer: Sewer Pipe Type (ID:23)

View In: Map Viewer

Name: Sewer Pipe Type

Display Field: FWE_ID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

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":"uniqueValue","field1":"PIPETYPE","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":10},"value":"MAIN_G","label":"Gravity Main"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[38,115,0,255],"width":1},"value":"MAIN_F","label":"Forced Main"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[56,168,0,255],"width":0.4},"value":"LEACH","label":"Leach"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":0.5},"value":"LAT","label":"Lateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":10},"value":"OTHER","label":"Other"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[163,255,115,255],"width":8},"value":"CASE","label":"Casing"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[62,161,207,255],"toColor":[241,250,122,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[241,250,122,255],"toColor":[240,36,29,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"var pDia = DomainName($feature, 'DIA')\nvar pMat = $feature.MATERIAL\nvar lResult = \"\"\n\nif(IsEmpty(pDia) == False){\n lResult = pDia\n}\nif(IsEmpty(pMat) == False){\n lResult = lResult + pMat\n}\nreturn lResult","title":"lbl_ARCADE_PipeDiaMat"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":false,"repeatLabel":true,"repeatLabelDistance":300,"lineConnection":"none","multiPart":"labelPerPart","allowOverlapOfFeatureInterior":"avoid","stackLabel":false,"removeDuplicates":"all","removeDuplicatesDistance":150,"useCodedValues":true,"maxScale":0,"minScale":8000,"name":"Dia & Material","priority":14,"symbol":{"type":"esriTS","color":[38,115,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[233,255,190,255],"haloSize":1,"font":{"family":"Arial Narrow","size":10,"style":"normal","weight":"normal","decoration":"none"}}}]}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: PIPETYPE

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ASSETID (type: esriFieldTypeInteger, alias: Asset ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
ADMINID (type: esriFieldTypeString, alias: Admin ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
GENERATEID (type: esriFieldTypeInteger, alias: Generated ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
HYDMODELID (type: esriFieldTypeInteger, alias: Hydrological Model ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [FEDERAL: Federal Owned], [STATE: State Owned], [COUNTY: County Owned], ... 4 more ...)
OWNERDES (type: esriFieldTypeString, alias: Owner Description, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [UNK: Unknown], [POT: Potable], [SEW: Sewage], ... 5 more ...)
LIFECYCLE (type: esriFieldTypeString, alias: Lifecycle, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [UNK: Unknown], [ACT: Active], [PROP: Proposed], ... 3 more ...)
INSTALLDT (type: esriFieldTypeSmallInteger, alias: Install Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
SURVSTAT (type: esriFieldTypeString, alias: Survey Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [UNK: Unknown], [DGTZ: Digitized], [MPGPS: Mapping Grade GPS], ... 5 more ...)
SURVDATE (type: esriFieldTypeDate, alias: Survey Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
HYDMODEL (type: esriFieldTypeSmallInteger, alias: Hydrological Model, SQL Type: sqlTypeOther, nullable: true, editable: true)
LASTUPDATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LASTEDITOR (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
DIA (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.25: 1/4"], [0.375: 3/8"], ... 41 more ...)
MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [UNK: Unknown], [ACP: Asbestos Cement Pipe], [C900: C900 PVC], ... 29 more ...)
PIPETYPE (type: esriFieldTypeString, alias: Pipe Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [MAIN_F: Forced Main], [MAIN_G: Gravity Main], [LEACH: Leach], ... 4 more ...)
PIPECLASS (type: esriFieldTypeString, alias: Pipe Class, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [UNK: Unknown], [C150: Class 150], [C200: Class 200], ... 2 more ...)
PIPESHAPE (type: esriFieldTypeString, alias: Pipe Shape, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [UNK: Unknown], [CIRC: Circular], [ELIP: Elliptical], ... 9 more ...)
FEAT_FUNCTION (type: esriFieldTypeString, alias: Feature Function, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [TRANS: Transmission], [DIST: Distribution], [COLL: Collection])
LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [ONR: On Road], [OFFR: Off Road])
FUNLOC (type: esriFieldTypeString, alias: Function & Location, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
DIAMAT (type: esriFieldTypeString, alias: Diameter & Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ROUGHCOEFF (type: esriFieldTypeDouble, alias: Roughness Coefficient, SQL Type: sqlTypeOther, nullable: true, editable: true)
ELEV_START (type: esriFieldTypeDouble, alias: Elevation - Start of Pipe, SQL Type: sqlTypeOther, nullable: true, editable: true)
ELEV_END (type: esriFieldTypeDouble, alias: Elevation - End of Pipe, SQL Type: sqlTypeOther, nullable: true, editable: true)
FROMJUNCT (type: esriFieldTypeString, alias: From Junction, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TOJUNCT (type: esriFieldTypeString, alias: To Junction, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
FWE_ID (type: esriFieldTypeString, alias: FWE ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SLOPECALC (type: esriFieldTypeDouble, alias: Slope Calculated, SQL Type: sqlTypeOther, nullable: true, editable: true)
PIPE_LENGTH (type: esriFieldTypeDouble, alias: Pipe Length (GIS), SQL Type: sqlTypeOther, nullable: true, editable: true)
RECORD (type: esriFieldTypeString, alias: Record, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
RECLINK (type: esriFieldTypeString, alias: Record Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
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)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: true)

Types:

Field Name: OWNER
Inherited
Field Name: WATERTYPE
Inherited
Field Name: LIFECYCLE
Inherited
Field Name: SURVSTAT
Inherited
Field Name: ENABLED
Inherited
Field Name: DIA
Inherited
Field Name: MATERIAL
Inherited
Field Name: PIPETYPE
Inherited
Field Name: PIPECLASS
Inherited
Field Name: PIPESHAPE
Inherited
Field Name: FEAT_FUNCTION
Inherited
Field Name: LOCATION
Inherited

PIPESHAPE: CIRC
FEAT_FUNCTION: COLL
WATERTYPE: SEW
LIFECYCLE: ACT
ENABLED: 1
PIPETYPE: MAIN_G
LOCATION: ONR

Field Name: OWNER
Inherited
Field Name: WATERTYPE
Inherited
Field Name: LIFECYCLE
Inherited
Field Name: SURVSTAT
Inherited
Field Name: ENABLED
Inherited
Field Name: DIA
Inherited
Field Name: MATERIAL
Inherited
Field Name: PIPETYPE
Inherited
Field Name: PIPECLASS
Inherited
Field Name: PIPESHAPE
Inherited
Field Name: FEAT_FUNCTION
Inherited
Field Name: LOCATION
Inherited

PIPESHAPE: CIRC
FEAT_FUNCTION: COLL
WATERTYPE: SEW
LIFECYCLE: ACT
ENABLED: 1
PIPETYPE: MAIN_F
LOCATION: ONR

Field Name: OWNER
Inherited
Field Name: WATERTYPE
Inherited
Field Name: LIFECYCLE
Inherited
Field Name: SURVSTAT
Inherited
Field Name: ENABLED
Inherited
Field Name: DIA
Inherited
Field Name: MATERIAL
Inherited
Field Name: PIPETYPE
Inherited
Field Name: PIPECLASS
Inherited
Field Name: PIPESHAPE
Inherited
Field Name: FEAT_FUNCTION
Inherited
Field Name: LOCATION
Inherited

PIPESHAPE: CIRC
FEAT_FUNCTION: COLL
WATERTYPE: SEW
LIFECYCLE: ACT
ENABLED: 1
PIPETYPE: LEACH
LOCATION: ONR

Field Name: OWNER
Inherited
Field Name: WATERTYPE
Inherited
Field Name: LIFECYCLE
Inherited
Field Name: SURVSTAT
Inherited
Field Name: ENABLED
Inherited
Field Name: DIA
Inherited
Field Name: MATERIAL
Inherited
Field Name: PIPETYPE
Inherited
Field Name: PIPECLASS
Inherited
Field Name: PIPESHAPE
Inherited
Field Name: FEAT_FUNCTION
Inherited
Field Name: LOCATION
Inherited

PIPESHAPE: CIRC
FEAT_FUNCTION: COLL
WATERTYPE: SEW
LIFECYCLE: ACT
ENABLED: 1
PIPETYPE: LAT
LOCATION: ONR

Field Name: OWNER
Inherited
Field Name: WATERTYPE
Inherited
Field Name: LIFECYCLE
Inherited
Field Name: SURVSTAT
Inherited
Field Name: ENABLED
Inherited
Field Name: DIA
Inherited
Field Name: MATERIAL
Inherited
Field Name: PIPETYPE
Inherited
Field Name: PIPECLASS
Inherited
Field Name: PIPESHAPE
Inherited
Field Name: FEAT_FUNCTION
Inherited
Field Name: LOCATION
Inherited

PIPESHAPE: CIRC
FEAT_FUNCTION: COLL
WATERTYPE: SEW
LIFECYCLE: ACT
ENABLED: 1
PIPETYPE: OTHER
LOCATION: ONR

Field Name: OWNER
Inherited
Field Name: WATERTYPE
Inherited
Field Name: LIFECYCLE
Inherited
Field Name: SURVSTAT
Inherited
Field Name: ENABLED
Inherited
Field Name: DIA
Inherited
Field Name: MATERIAL
Inherited
Field Name: PIPETYPE
Inherited
Field Name: PIPECLASS
Inherited
Field Name: PIPESHAPE
Inherited
Field Name: FEAT_FUNCTION
Inherited
Field Name: LOCATION
Inherited

PIPESHAPE: CIRC
FEAT_FUNCTION: COLL
WATERTYPE: SEW
LIFECYCLE: ACT
ENABLED: 1
PIPETYPE: CASE
LOCATION: ONR

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/22/2023 3:20:06 PM

Schema Last Edit Date: 6/22/2023 3:20:06 PM

Data Last Edit Date: 6/22/2023 3:20:02 PM

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