Name: Laterals

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:

XMin: 1455555.51548258
YMin: 82905.4300748259
XMax: 1808387.82425224
YMax: 459277.018537492
Spatial Reference: 102661 (102661)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"ownedby","uniqueValueGroups":[{"heading":"Owned By","classes":[{"label":"County Lateral","description":"County Lateral","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":2},"values":[["1"]]},{"label":"Non-County Lateral","description":"Non-County Lateral","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":2},"values":[["2"],["3"],["4"],["5"],["100"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":2},"value":"1","label":"County Lateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":2},"value":"2","label":"Non-County Lateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":2},"value":"3","label":"Non-County Lateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":2},"value":"4","label":"Non-County Lateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":2},"value":"5","label":"Non-County Lateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":2},"value":"100","label":"Non-County Lateral"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[214,207,252,255],"toColor":[214,207,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,252,179,255],"toColor":[184,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,179,255],"toColor":[252,210,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,252,248,255],"toColor":[192,252,248,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,179,252,255],"toColor":[250,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,202,255],"toColor":[252,182,202,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[251,252,184,255],"toColor":[251,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[217,252,212,255],"toColor":[217,252,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,202,247,255],"toColor":[252,202,247,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,213,255],"toColor":[252,212,213,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,179,252,255],"toColor":[194,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,234,252,255],"toColor":[207,234,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,242,215,255],"toColor":[252,242,215,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

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:

Type ID Field: ownedby

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• 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)
• assetgroup (type: esriFieldTypeInteger, alias: Asset Group, SQL Type: sqlTypeOther, nullable: false, editable: true)
• 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)
• dateDigitized (type: esriFieldTypeDate, alias: Date Digitized, 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 ...)
• 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)
• 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 ...)
• SheetID (type: esriFieldTypeInteger, alias: SheetID, 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)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 1
Name: County Lateral
Domains:

• Field Name: sewershedsubnetworkname
  Inherited
  
• Field Name: isconnected
  Inherited
  
• Field Name: presentstatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: PIPELENGTH
  Inherited
  
• Field Name: FRICTIONFACTOR
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: assettype
  Inherited
  
• Field Name: associationstatus
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: linertype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: FLOWSPLIT
  Inherited
  
• Field Name: Chk_Diameter
  Inherited
  
• Field Name: Chk_Material
  Inherited
  
• Field Name: Chk_Inverts
  Inherited
  
• Field Name: Chk_Length
  Inherited
  
• Field Name: Video_Laterals
  Inherited
  
• Field Name: Invert_Changed
  Inherited
  
• Field Name: TS_Survey
  Inherited
  
• Field Name: MH_Inspect
  Inherited
  
• Field Name: rehab
  Inherited
  
• Field Name: FieldVerify
  Inherited
  
• Field Name: COF
  Inherited
  
• Field Name: POF
  Inherited
  
• Field Name: Location
  Inherited
  
Templates:

Name: County Lateral
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 2
Name: Non-County Lateral
Domains:

• Field Name: sewershedsubnetworkname
  Inherited
  
• Field Name: isconnected
  Inherited
  
• Field Name: presentstatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: PIPELENGTH
  Inherited
  
• Field Name: FRICTIONFACTOR
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: assettype
  Inherited
  
• Field Name: associationstatus
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: linertype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: FLOWSPLIT
  Inherited
  
• Field Name: Chk_Diameter
  Inherited
  
• Field Name: Chk_Material
  Inherited
  
• Field Name: Chk_Inverts
  Inherited
  
• Field Name: Chk_Length
  Inherited
  
• Field Name: Video_Laterals
  Inherited
  
• Field Name: Invert_Changed
  Inherited
  
• Field Name: TS_Survey
  Inherited
  
• Field Name: MH_Inspect
  Inherited
  
• Field Name: rehab
  Inherited
  
• Field Name: FieldVerify
  Inherited
  
• Field Name: COF
  Inherited
  
• Field Name: POF
  Inherited
  
• Field Name: Location
  Inherited
  
Templates:

Name: Non-County Lateral
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 3
Name: Non-County Lateral
Domains:

• Field Name: sewershedsubnetworkname
  Inherited
  
• Field Name: isconnected
  Inherited
  
• Field Name: presentstatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: PIPELENGTH
  Inherited
  
• Field Name: FRICTIONFACTOR
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: assettype
  Inherited
  
• Field Name: associationstatus
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: linertype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: FLOWSPLIT
  Inherited
  
• Field Name: Chk_Diameter
  Inherited
  
• Field Name: Chk_Material
  Inherited
  
• Field Name: Chk_Inverts
  Inherited
  
• Field Name: Chk_Length
  Inherited
  
• Field Name: Video_Laterals
  Inherited
  
• Field Name: Invert_Changed
  Inherited
  
• Field Name: TS_Survey
  Inherited
  
• Field Name: MH_Inspect
  Inherited
  
• Field Name: rehab
  Inherited
  
• Field Name: FieldVerify
  Inherited
  
• Field Name: COF
  Inherited
  
• Field Name: POF
  Inherited
  
• Field Name: Location
  Inherited
  
Templates:

Name: Non-County Lateral (1)
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 4
Name: Non-County Lateral
Domains:

• Field Name: sewershedsubnetworkname
  Inherited
  
• Field Name: isconnected
  Inherited
  
• Field Name: presentstatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: PIPELENGTH
  Inherited
  
• Field Name: FRICTIONFACTOR
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: assettype
  Inherited
  
• Field Name: associationstatus
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: linertype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: FLOWSPLIT
  Inherited
  
• Field Name: Chk_Diameter
  Inherited
  
• Field Name: Chk_Material
  Inherited
  
• Field Name: Chk_Inverts
  Inherited
  
• Field Name: Chk_Length
  Inherited
  
• Field Name: Video_Laterals
  Inherited
  
• Field Name: Invert_Changed
  Inherited
  
• Field Name: TS_Survey
  Inherited
  
• Field Name: MH_Inspect
  Inherited
  
• Field Name: rehab
  Inherited
  
• Field Name: FieldVerify
  Inherited
  
• Field Name: COF
  Inherited
  
• Field Name: POF
  Inherited
  
• Field Name: Location
  Inherited
  
Templates:

Name: Non-County Lateral (2)
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 5
Name: Non-County Lateral
Domains:

• Field Name: sewershedsubnetworkname
  Inherited
  
• Field Name: isconnected
  Inherited
  
• Field Name: presentstatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: PIPELENGTH
  Inherited
  
• Field Name: FRICTIONFACTOR
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: assettype
  Inherited
  
• Field Name: associationstatus
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: linertype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: FLOWSPLIT
  Inherited
  
• Field Name: Chk_Diameter
  Inherited
  
• Field Name: Chk_Material
  Inherited
  
• Field Name: Chk_Inverts
  Inherited
  
• Field Name: Chk_Length
  Inherited
  
• Field Name: Video_Laterals
  Inherited
  
• Field Name: Invert_Changed
  Inherited
  
• Field Name: TS_Survey
  Inherited
  
• Field Name: MH_Inspect
  Inherited
  
• Field Name: rehab
  Inherited
  
• Field Name: FieldVerify
  Inherited
  
• Field Name: COF
  Inherited
  
• Field Name: POF
  Inherited
  
• Field Name: Location
  Inherited
  
Templates:

Name: Non-County Lateral (3)
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 100
Name: Non-County Lateral
Domains:

• Field Name: sewershedsubnetworkname
  Inherited
  
• Field Name: isconnected
  Inherited
  
• Field Name: presentstatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: PIPELENGTH
  Inherited
  
• Field Name: FRICTIONFACTOR
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: assettype
  Inherited
  
• Field Name: associationstatus
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: linertype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: FLOWSPLIT
  Inherited
  
• Field Name: Chk_Diameter
  Inherited
  
• Field Name: Chk_Material
  Inherited
  
• Field Name: Chk_Inverts
  Inherited
  
• Field Name: Chk_Length
  Inherited
  
• Field Name: Video_Laterals
  Inherited
  
• Field Name: Invert_Changed
  Inherited
  
• Field Name: TS_Survey
  Inherited
  
• Field Name: MH_Inspect
  Inherited
  
• Field Name: rehab
  Inherited
  
• Field Name: FieldVerify
  Inherited
  
• Field Name: COF
  Inherited
  
• Field Name: POF
  Inherited
  
• Field Name: Location
  Inherited
  
Templates:

Name: Non-County Lateral (4)
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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

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

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

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