Layer: Mains (ID:3)

View In: Map Viewer

Name: Mains

Display Field: assetNum

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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","valueExpression":"IF ($feature.ownedby == 1)\n Return \"County Main\";\nELSE IF ($feature.ownedby == 2)\n Return \"Non-County Main\";\nELSE IF ($feature.ownedby == 3)\n Return \"Non-County Main\";\nELSE IF ($feature.ownedby == 4)\n Return \"Non-County Main\";\nELSE IF ($feature.ownedby == 5)\n Return \"Non-County Main\";\nELSE IF ($feature.ownedby == 100)\n Return \"Non-County Main\";\nELSE \n Return \"Other\"","valueExpressionTitle":"Custom","uniqueValueGroups":[{"heading":"Mains","classes":[{"label":"County Main","description":"County Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":2},"values":[["County Main"]]},{"label":"Non-County Main","description":"Non-County Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[168,112,0,255],"width":2},"values":[["Non-County Main"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":2},"value":"County Main","label":"County Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[168,112,0,255],"width":2},"value":"Non-County Main","label":"Non-County Main"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[227,25,28,255],"toColor":[227,25,28,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[55,126,184,255],"toColor":[55,126,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[77,176,74,255],"toColor":[77,176,74,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[152,78,163,255],"toColor":[152,78,163,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,128,0,255],"toColor":[255,128,0,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,255,51,255],"toColor":[255,255,51,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[166,86,40,255],"toColor":[166,86,40,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[247,129,192,255],"toColor":[247,129,192,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.Asset_ID","title":"Custom"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"none","multiPart":"labelPerFeature","useClippedGeometry":true,"stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"all","removeDuplicatesDistance":0,"stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":3809.55452249082,"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":[255,255,255,255],"haloSize":1,"font":{"family":"Tahoma","size":10,"style":"normal","weight":"bold","decoration":"none"}}}]}
HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
assetgroup (type: esriFieldTypeInteger, alias: Asset Group, SQL Type: sqlTypeOther, nullable: false, editable: true)
Asset_ID (type: esriFieldTypeInteger, alias: Asset ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
assetid (type: esriFieldTypeInteger, alias: Asset ID [Old], SQL Type: sqlTypeOther, nullable: true, editable: true)
assetNum (type: esriFieldTypeString, alias: Asset Number - AMS [Old], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assettype (type: esriFieldTypeSmallInteger, alias: Asset Type, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [41: Collector Force Main], [42: Interceptor Force Main])
sewershedsubnetworkname (type: esriFieldTypeString, alias: Sewershed Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true, Coded Values: [0: Heeia], [1: Hilo], [2: Honokaa], ... 9 more ...)
isconnected (type: esriFieldTypeSmallInteger, alias: Is Connected, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True], [2: Unknown])
presentstatus (type: esriFieldTypeSmallInteger, alias: Present Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Inactive], [3: Active], [4: Abandoned], ... 2 more ...)
ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: County of Hawaii (WWD)], [2: County of Hawaii (not WWD)], ... 4 more ...)
installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
material (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Acrylonitrile Butadiene Styrene - ABS], [2: Asbestos Cement - AC], ... 32 more ...)
dateDigitized (type: esriFieldTypeDate, alias: Date Digitized, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
lastupdate (type: esriFieldTypeDate, alias: Last Update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
updatedby (type: esriFieldTypeString, alias: Updated By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.5: 1/2"], [0.75: 3/4"], ... 28 more ...)
PIPELENGTH (type: esriFieldTypeDouble, alias: Pipe Length, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 10000])
upelev (type: esriFieldTypeDouble, alias: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
downelev (type: esriFieldTypeDouble, alias: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
slope (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
DFULLFLOW (type: esriFieldTypeDouble, alias: Design Full Pipe Flow, SQL Type: sqlTypeOther, nullable: true, editable: true)
DVELOCITY (type: esriFieldTypeDouble, alias: Design Full Pipe Velocity, SQL Type: sqlTypeOther, nullable: true, editable: true)
DHALFFLOW (type: esriFieldTypeDouble, alias: Design Half Pipe Flow, SQL Type: sqlTypeOther, nullable: true, editable: true)
FRICTIONFACTOR (type: esriFieldTypeDouble, alias: Friction Factor, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: 0.015], [2: 0.013], ... 1 more ...)
FLOWSPLIT (type: esriFieldTypeSmallInteger, alias: Flow Split, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 100])
SheetID (type: esriFieldTypeInteger, alias: SheetID, SQL Type: sqlTypeOther, nullable: true, editable: true)
SPSBasin (type: esriFieldTypeInteger, alias: SPS Basin, SQL Type: sqlTypeOther, nullable: true, editable: true)
spatialsource (type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built Map], [2: Design Map], ... 5 more ...)
MapID (type: esriFieldTypeInteger, alias: MapID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Unpaved/Easement], [2: Minor Roadway], [3: Major Roadway], ... 6 more ...)
Street_Name (type: esriFieldTypeString, alias: StreetName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

assetgroup: 0
assettype: 0
sewershedsubnetworkname:
isconnected: 2
presentstatus: 3
ownedby: 1
PIPELENGTH: 0
DFULLFLOW: -1
DVELOCITY: -1
DHALFFLOW: -1
FLOWSPLIT: 100
SheetID: 0
SPSBasin: -1
MapID: 0

assetgroup: 3
assettype: 0
sewershedsubnetworkname:
isconnected: 2
presentstatus: 3
ownedby: 1
PIPELENGTH: 0
DFULLFLOW: -1
DVELOCITY: -1
DHALFFLOW: -1
FLOWSPLIT: 100
SheetID: 0
SPSBasin: -1
MapID: 0

assetgroup: 4
assettype: 0
sewershedsubnetworkname:
isconnected: 2
presentstatus: 3
ownedby: 1
PIPELENGTH: 0
DFULLFLOW: -1
DVELOCITY: -1
DHALFFLOW: -1
FLOWSPLIT: 100
SheetID: 0
SPSBasin: -1
MapID: 0

assetgroup: 5
assettype: 0
sewershedsubnetworkname:
isconnected: 2
presentstatus: 3
ownedby: 1
PIPELENGTH: 0
DFULLFLOW: -1
DVELOCITY: -1
DHALFFLOW: -1
FLOWSPLIT: 100
SheetID: 0
SPSBasin: -1
MapID: 0

assetgroup: 6
assettype: 0
sewershedsubnetworkname:
isconnected: 2
presentstatus: 3
ownedby: 1
PIPELENGTH: 0
DFULLFLOW: -1
DVELOCITY: -1
DHALFFLOW: -1
FLOWSPLIT: 100
SheetID: 0
SPSBasin: -1
MapID: 0

assetgroup: 7
assettype: 0
sewershedsubnetworkname:
isconnected: 2
presentstatus: 3
ownedby: 1
PIPELENGTH: 0
DFULLFLOW: -1
DVELOCITY: -1
DHALFFLOW: -1
FLOWSPLIT: 100
SheetID: 0
SPSBasin: -1
MapID: 0

assetgroup: 1
assettype: 0
sewershedsubnetworkname:
isconnected: 2
presentstatus: 3
ownedby: 1
PIPELENGTH: 0
DFULLFLOW: -1
DVELOCITY: -1
DHALFFLOW: -1
SheetID: 0
SPSBasin: -1
MapID: 0

assetgroup: 2
assettype: 0
sewershedsubnetworkname:
isconnected: 2
presentstatus: 3
ownedby: 1
PIPELENGTH: 0
DFULLFLOW: -1
DVELOCITY: -1
DHALFFLOW: -1
SheetID: 0
SPSBasin: -1
MapID: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/3/2025 12:40:36 AM

Schema Last Edit Date: 12/3/2025 12:40:36 AM

Data Last Edit Date: 12/3/2025 12:40:36 AM

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