Name: Pumps
Display Field: assetNum
Type: Feature Layer
Geometry Type: esriGeometryPoint
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: 1460965.83373016
YMin: 82813.2012566552
XMax: 1808387.82425224
YMax: 456471.210500821
Spatial Reference: 102661 (102661)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"ownedby","uniqueValueGroups":[{"heading":"Owned By","classes":[{"label":"County Pump","description":"County Pump","symbol":{"type":"esriPMS","url":"e60e9f4e02f11943a1285ab4eac51373","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA2UlEQVQ4jb3ToUsDURwH8M/JBINZxi3IqnFmmRj8U1YGCxaL0Wx2sD9AWBsIxoVhMIwVB1bDuTDQJBuiJ+KC5xjence+5ZX3+/D4vvdKCkqpcGjCzjtHWYYDbkMeE1DMXsAJeimdevy9JqFFhiHnaZQoS0cR93he7JvEnFZ4yFP27pz9KrOIVkAbh3mgnxmgYUX+hLbZfKIccxbQzQ29cY0pbsp0ckNzjr86Wv/LXpG7Vz78FwozfJnf0EHEZcrZGi6WoBmjLZppT4CrDcZLUJUX9DNAiRR2a5/JTyt9RoP+0QAAAABJRU5ErkJggg==","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"values":[["1"]]},{"label":"Non-County Pump","description":"Non-County Pump","symbol":{"type":"esriPMS","url":"d219e035d38dca1521f18075f7501329","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABBElEQVQ4jb3TP0iCQRjH8e9dryE0JA3R1u5ocxQO7i7W6tIS5B+CloYGZ+ndCpxcXqMtEBoboqEhXIxcnRqEmvKl8n3kFQdfLLxXX/xNB3fPh+O55ywiihU5VD9lc3VAOkyx9njK2XQDUOyXJFBWwp0JIoo9T4+WQWiclwObigl0UxhhZj1qlGgjfIzPvWvhLGfTCd9sYbufYCd/gesUOBkoroH98NBElOIROPpvfya08UXMKbKlhHMUt3ND/W+aWuiJ5v5tndr8UIKM36PlT/afEZ7XwGNR6NA2/zJBSLHbKHJlUiiQAqpTUBxarnBsegN/8H9WeJ2Cspd8Ag8hoEAie7UhZiJBDTIHPIsAAAAASUVORK5CYII=","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"values":[["2"],["3"],["4"],["5"],["100"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"e60e9f4e02f11943a1285ab4eac51373","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA2UlEQVQ4jb3ToUsDURwH8M/JBINZxi3IqnFmmRj8U1YGCxaL0Wx2sD9AWBsIxoVhMIwVB1bDuTDQJBuiJ+KC5xjence+5ZX3+/D4vvdKCkqpcGjCzjtHWYYDbkMeE1DMXsAJeimdevy9JqFFhiHnaZQoS0cR93he7JvEnFZ4yFP27pz9KrOIVkAbh3mgnxmgYUX+hLbZfKIccxbQzQ29cY0pbsp0ckNzjr86Wv/LXpG7Vz78FwozfJnf0EHEZcrZGi6WoBmjLZppT4CrDcZLUJUX9DNAiRR2a5/JTyt9RoP+0QAAAABJRU5ErkJggg==","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"1","label":"County Pump"},{"symbol":{"type":"esriPMS","url":"d219e035d38dca1521f18075f7501329","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABBElEQVQ4jb3TP0iCQRjH8e9dryE0JA3R1u5ocxQO7i7W6tIS5B+CloYGZ+ndCpxcXqMtEBoboqEhXIxcnRqEmvKl8n3kFQdfLLxXX/xNB3fPh+O55ywiihU5VD9lc3VAOkyx9njK2XQDUOyXJFBWwp0JIoo9T4+WQWiclwObigl0UxhhZj1qlGgjfIzPvWvhLGfTCd9sYbufYCd/gesUOBkoroH98NBElOIROPpvfya08UXMKbKlhHMUt3ND/W+aWuiJ5v5tndr8UIKM36PlT/afEZ7XwGNR6NA2/zJBSLHbKHJlUiiQAqpTUBxarnBsegN/8H9WeJ2Cspd8Ag8hoEAie7UhZiJBDTIHPIsAAAAASUVORK5CYII=","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"2","label":"Non-County Pump"},{"symbol":{"type":"esriPMS","url":"d219e035d38dca1521f18075f7501329","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABBElEQVQ4jb3TP0iCQRjH8e9dryE0JA3R1u5ocxQO7i7W6tIS5B+CloYGZ+ndCpxcXqMtEBoboqEhXIxcnRqEmvKl8n3kFQdfLLxXX/xNB3fPh+O55ywiihU5VD9lc3VAOkyx9njK2XQDUOyXJFBWwp0JIoo9T4+WQWiclwObigl0UxhhZj1qlGgjfIzPvWvhLGfTCd9sYbufYCd/gesUOBkoroH98NBElOIROPpvfya08UXMKbKlhHMUt3ND/W+aWuiJ5v5tndr8UIKM36PlT/afEZ7XwGNR6NA2/zJBSLHbKHJlUiiQAqpTUBxarnBsegN/8H9WeJ2Cspd8Ag8hoEAie7UhZiJBDTIHPIsAAAAASUVORK5CYII=","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"3","label":"Non-County Pump"},{"symbol":{"type":"esriPMS","url":"d219e035d38dca1521f18075f7501329","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABBElEQVQ4jb3TP0iCQRjH8e9dryE0JA3R1u5ocxQO7i7W6tIS5B+CloYGZ+ndCpxcXqMtEBoboqEhXIxcnRqEmvKl8n3kFQdfLLxXX/xNB3fPh+O55ywiihU5VD9lc3VAOkyx9njK2XQDUOyXJFBWwp0JIoo9T4+WQWiclwObigl0UxhhZj1qlGgjfIzPvWvhLGfTCd9sYbufYCd/gesUOBkoroH98NBElOIROPpvfya08UXMKbKlhHMUt3ND/W+aWuiJ5v5tndr8UIKM36PlT/afEZ7XwGNR6NA2/zJBSLHbKHJlUiiQAqpTUBxarnBsegN/8H9WeJ2Cspd8Ag8hoEAie7UhZiJBDTIHPIsAAAAASUVORK5CYII=","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"4","label":"Non-County Pump"},{"symbol":{"type":"esriPMS","url":"d219e035d38dca1521f18075f7501329","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABBElEQVQ4jb3TP0iCQRjH8e9dryE0JA3R1u5ocxQO7i7W6tIS5B+CloYGZ+ndCpxcXqMtEBoboqEhXIxcnRqEmvKl8n3kFQdfLLxXX/xNB3fPh+O55ywiihU5VD9lc3VAOkyx9njK2XQDUOyXJFBWwp0JIoo9T4+WQWiclwObigl0UxhhZj1qlGgjfIzPvWvhLGfTCd9sYbufYCd/gesUOBkoroH98NBElOIROPpvfya08UXMKbKlhHMUt3ND/W+aWuiJ5v5tndr8UIKM36PlT/afEZ7XwGNR6NA2/zJBSLHbKHJlUiiQAqpTUBxarnBsegN/8H9WeJ2Cspd8Ag8hoEAie7UhZiJBDTIHPIsAAAAASUVORK5CYII=","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"5","label":"Non-County Pump"},{"symbol":{"type":"esriPMS","url":"d219e035d38dca1521f18075f7501329","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABBElEQVQ4jb3TP0iCQRjH8e9dryE0JA3R1u5ocxQO7i7W6tIS5B+CloYGZ+ndCpxcXqMtEBoboqEhXIxcnRqEmvKl8n3kFQdfLLxXX/xNB3fPh+O55ywiihU5VD9lc3VAOkyx9njK2XQDUOyXJFBWwp0JIoo9T4+WQWiclwObigl0UxhhZj1qlGgjfIzPvWvhLGfTCd9sYbufYCd/gesUOBkoroH98NBElOIROPpvfya08UXMKbKlhHMUt3ND/W+aWuiJ5v5tndr8UIKM36PlT/afEZ7XwGNR6NA2/zJBSLHbKHJlUiiQAqpTUBxarnBsegN/8H9WeJ2Cspd8Ag8hoEAie7UhZiJBDTIHPIsAAAAASUVORK5CYII=","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"100","label":"Non-County Pump"}],"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: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field: ownedby
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: esriFieldTypeString, alias: Asset ID [Old], SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
- assetNum (type: esriFieldTypeString, alias: Asset Number - AMS [Old], SQL Type: sqlTypeOther, length: 255, nullable: true, 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 ...)
- tmk (type: esriFieldTypeInteger, alias: TMK, SQL Type: sqlTypeOther, nullable: true, editable: true)
- 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: false, editable: true, Coded Values: [1: Connected], [2: Permit Pending], [3: Not Connected], ... 7 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 ...)
- 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)
- SheetID (type: esriFieldTypeInteger, alias: SheetID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Types:
ID: 1
Name: County Pump
Domains:
- Field Name: sewershedsubnetworkname
Inherited
- Field Name: isconnected
Inherited
- Field Name: presentstatus
Inherited
- Field Name: ownedby
Inherited
- Field Name: spatialsource
Inherited
- Field Name: assettype
Inherited
- Field Name: material
Inherited
- Field Name: dischargeType
Inherited
- Field Name: cleanout
Inherited
- Field Name: inspection
Inherited
- Field Name: lateral
Inherited
- Field Name: vacantLot
Inherited
- Field Name: present_status
Inherited
- Field Name: Active_Billing_Account
Inherited
Templates:
Name: County Pump
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- presentstatus: 0
- assetgroup: 0
- sewershedsubnetworkname:
- isconnected: 2
- ownedby: 1
- MapID: 0
- SheetID: 0
ID: 2
Name: Non-County Pump
Domains:
- Field Name: sewershedsubnetworkname
Inherited
- Field Name: isconnected
Inherited
- Field Name: presentstatus
Inherited
- Field Name: ownedby
Inherited
- Field Name: spatialsource
Inherited
- Field Name: assettype
Inherited
- Field Name: material
Inherited
- Field Name: dischargeType
Inherited
- Field Name: cleanout
Inherited
- Field Name: inspection
Inherited
- Field Name: lateral
Inherited
- Field Name: vacantLot
Inherited
- Field Name: present_status
Inherited
- Field Name: Active_Billing_Account
Inherited
Templates:
Name: Non-County Pump
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- presentstatus: 0
- assetgroup: 0
- sewershedsubnetworkname:
- isconnected: 2
- ownedby: 2
- MapID: 0
- SheetID: 0
ID: 3
Name: Non-County Pump
Domains:
- Field Name: sewershedsubnetworkname
Inherited
- Field Name: isconnected
Inherited
- Field Name: presentstatus
Inherited
- Field Name: ownedby
Inherited
- Field Name: spatialsource
Inherited
- Field Name: assettype
Inherited
- Field Name: material
Inherited
- Field Name: dischargeType
Inherited
- Field Name: cleanout
Inherited
- Field Name: inspection
Inherited
- Field Name: lateral
Inherited
- Field Name: vacantLot
Inherited
- Field Name: present_status
Inherited
- Field Name: Active_Billing_Account
Inherited
Templates:
Name: Non-County Pump (1)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- presentstatus: 0
- assetgroup: 0
- sewershedsubnetworkname:
- isconnected: 2
- ownedby: 3
- MapID: 0
- SheetID: 0
ID: 4
Name: Non-County Pump
Domains:
- Field Name: sewershedsubnetworkname
Inherited
- Field Name: isconnected
Inherited
- Field Name: presentstatus
Inherited
- Field Name: ownedby
Inherited
- Field Name: spatialsource
Inherited
- Field Name: assettype
Inherited
- Field Name: material
Inherited
- Field Name: dischargeType
Inherited
- Field Name: cleanout
Inherited
- Field Name: inspection
Inherited
- Field Name: lateral
Inherited
- Field Name: vacantLot
Inherited
- Field Name: present_status
Inherited
- Field Name: Active_Billing_Account
Inherited
Templates:
Name: Non-County Pump (2)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- presentstatus: 0
- assetgroup: 0
- sewershedsubnetworkname:
- isconnected: 2
- ownedby: 4
- MapID: 0
- SheetID: 0
ID: 5
Name: Non-County Pump
Domains:
- Field Name: sewershedsubnetworkname
Inherited
- Field Name: isconnected
Inherited
- Field Name: presentstatus
Inherited
- Field Name: ownedby
Inherited
- Field Name: spatialsource
Inherited
- Field Name: assettype
Inherited
- Field Name: material
Inherited
- Field Name: dischargeType
Inherited
- Field Name: cleanout
Inherited
- Field Name: inspection
Inherited
- Field Name: lateral
Inherited
- Field Name: vacantLot
Inherited
- Field Name: present_status
Inherited
- Field Name: Active_Billing_Account
Inherited
Templates:
Name: Non-County Pump (3)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- presentstatus: 0
- assetgroup: 0
- sewershedsubnetworkname:
- isconnected: 2
- ownedby: 5
- MapID: 0
- SheetID: 0
ID: 100
Name: Non-County Pump
Domains:
- Field Name: sewershedsubnetworkname
Inherited
- Field Name: isconnected
Inherited
- Field Name: presentstatus
Inherited
- Field Name: ownedby
Inherited
- Field Name: spatialsource
Inherited
- Field Name: assettype
Inherited
- Field Name: material
Inherited
- Field Name: dischargeType
Inherited
- Field Name: cleanout
Inherited
- Field Name: inspection
Inherited
- Field Name: lateral
Inherited
- Field Name: vacantLot
Inherited
- Field Name: present_status
Inherited
- Field Name: Active_Billing_Account
Inherited
Templates:
Name: Non-County Pump (4)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- presentstatus: 0
- assetgroup: 0
- sewershedsubnetworkname:
- isconnected: 2
- ownedby: 100
- MapID: 0
- SheetID: 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