Layer: Hydrants (ID:47)

View In: Map Viewer

Name: Hydrants

Display Field: HYDRANT_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Hydrants including fire, flush, and post hydrants GPS collected by RCAP Solutions. Flush devices are also recorded here. Based on the ESRI Local Government Information Model, and RCAP Solutions custom modifications as seen fit to meet the needs of our clients in order to store, manage, and display geographic data. Data is 1.) Collected using mapping-grade GPS receivers with SBAS Corrections and/or 2.) Digitized based on best available references.

Copyright Text: RCAP Solutions (Rural Community Assistance Partnership, Northeast Region), ESRI Local Government Information Model

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":"Flow_Capacity_Color","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"d3cc8527566be1ae59fe3c01b5a6f291","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAcCAYAAAB75n/uAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAB5ElEQVRIieWWzStEURjGfyTKioVvS0VWir/AxoZiIXYsNNZStihWNhY2JntlQbmUhSWzMkWSDUn5KPmMkvLVMc/cOXeauXOMlPLUbe4598z7O+e+z/vOFPHLKvoXgFZgAqjRvVFcV1SfeQMmgPEsUHNFBGjLBxCxg5fqCCXAI3AGfKRgHtD1HUCtABQDLcABUCDALVAOVAGHifWdAnguALOjneSgCSgDjhUwqRjQLdBdYmoVGFZeQgH+Uc1uj4BZ3d9bi5qBIWBRr+w1MR1xAfh60Wd72CKgErjK16YfOZ5vAAOp4aULIODr+hy7uAGeU8OLXIBWJcvXObCZluCk1oA54Ck1FdG0lw3wZU2jOgvQCFQr2ftAr3y5CzxorcnXdeIr42EA4/8vmaQtAT0aTwHrQB8waB2zQTmYyhAjE8BXoXye1DYwCvSruLYUqU7rLABOgDdgxhp3AJPAHrCsvBjQCbAQ4rZ0gO8CUzhj1gOz+woBPLnBAE6B6SwxMgEmVcmmrwVUEPR7oMjMKaw6CK3kC6vRzWeIF6aoepFTDgIVuaKmlq5YsAYC7gkD+MVmnGRezUiOraujdro2O7+bvuMmtWtcAV6Wn0kXxV2b3bDdNhwVlwudkhxNPyp56k/8L/qRPgHlDGcxDyhCAQAAAABJRU5ErkJggg==","contentType":"image/png","width":18,"height":21,"angle":0,"xoffset":0,"yoffset":0},"value":"BLACK","label":"Black (Out of Service)"},{"symbol":{"type":"esriPMS","url":"513ec01b27046ce606c7c9050a5902d8","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAcCAYAAAB75n/uAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAC1ElEQVRIieWW3UuTURzHP8/jTFsvNCJtrgsvSiMRovUHRChJTNIg7KaMjBkU5Qi6TcGuutDCG4ddRBdFiEEuMAivyqtG5gveGFpoxnLZ3GqpcyfOs+fRzXy2aQRB36vfeXnO5/xezjmPhb8sy38AuCacKDSjYkfg1PoU/Aj8xPFyT/FvHtAkmoFbmi2S+hMgJypuPMJPm3J04wCPcCP0xQFreAr7VD953z8TtpUwVVyFyMlPwK6LXu4q1dkDrooiwC3NLdEgh7uPMRocQQHygK+ATcmhsOwiYxVeGTIXHlFNm9KbGSBjrvLGCMnBngp2BUd4DxQmTRsQy9SMdGErPMJc+WXpyTM8opE2xZseoKK7Ksj7EWB8doh2feffkqYdAi4heDTUSfhAHbF8G7rXGQCGokEWvHs187jpJODLIAUPSgk0BjZXpiLDeB9QbzTizGQGJGp8RftUC5Z4zBQQzLUSzd9tfPspPUAmWCZLSsb03DDTD8t5uSbBhnxAh9VO5NRK8chz4UuuplSAPDhSgbc4fKc1cxooBWQ2ZLKHgTOACxgEQuGPOHoqWbCVMFv7Qn4iz44JQFCkFftiiMD8JE+AWn2oFXgO1AEXQHcT9seXqJ+fpHUpsrqGaYhSnIGapPZr4AZwFhgDXoG2kkOfJzewnkwBy8Ady1aIRbX2CaAFeAf0gJYXCZpQFLrUXITmeiaAUQXb7MTKGrgp7dH7Wpfc/R4dIAPs1AEfcndyu7gKtjvWraRUQIwWLFRjK7VT2ZXoG00AlOR6T1LBDgcTJx8bzZn0J7lDkfQi/SbtNAufiby0K43Z5mCG2E8Y79YaT+Xtuc6kASCyEIIJHxS7UqrHHGActsUQat95LTSedPuOTGPrv8Jcg0te2e7sb1NrIfGmONlobtXM4jaN04u6+pJtSPKdXqPfAfIRlw+H/qJtaHFZhVklORHHFFfZpP6B/6I/1C+Bteas2kg+HgAAAABJRU5ErkJggg==","contentType":"image/png","width":18,"height":21,"angle":0,"xoffset":0,"yoffset":0},"value":"BLUE","label":"Blue ( >1500 GPM)"},{"symbol":{"type":"esriPMS","url":"ecab525b59ee474f2f94a86edf853c58","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAcCAYAAAB75n/uAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACv0lEQVRIid3WT4hVdRTA8c+dNz6R0dKhIeeJQbkIIhSaaB61SSHaOGCLamyjYIzLkMhFm2ZgAimEVkVDtXQGF4qOQovCTcqTfJEVtKqkoQY0JstRKr33xu/d+5p59v6NEUFn835/zj3f8zvn/M7v9fqXpff/Dxg+aihKjGMQQ/lyNaKa9Jg6/5zqHQPK08YlXmuyNZSqgcfKM6qVUY+uGDA8Y4wl470L9H1FdJWbgyxuIypmsPKM2cqoka4BT0wrxWoAPYsUJ/h0LovROszjZg8PP8nvNS07y0eMVF4w2xEQYh4nLtTnySTFOb7Bvcv0ziXsOsPm+yk+FTxxcnjG/vOjptoCotiICCnRr1z8nlNYjavL9B7CiyknPqb4OPqEz8J52gPqcmuRC/uz8Q5t5BKlA9zXYLYLQF3SDvsfYt/SdL4zIFWthSiXzQUKcWvAz6tJ1mbjiB/bAkKCJU6GcaGPrW/yxSt8dFuC6xJy89561h2s+2asfMSp5dXUAOhJjIWQXL/E9cNL6w9iI97Cl3g21CU+x+WfSF/n2iADr9aqKdyd5oCUUviNbzB3haN4Jt+bxGk8j71kx8SWmD1XOPQbA8FGmtloCmg4DXYtm5/FyxjF1/hE5s2mXO9QCzstASGvh0Mr+CObP40JXMQxWV4C6LuI9wtZhjsCQhWEHKxaT/923giLZ7K94P1ADpjN22oA/LCGd7ZR7M9tRI2V1Jjk1MQtRtaUDD6QX7LLOSA4uKeJh5v6ueulbJym5kVtbvLZ3TV6KXTSiHdbha+ZRExVdsvdagH4Szkxn8QsVLL5cWxooncOv9wg/owNjzRWT0tA/bLF1/j2bUL+DrRzfYF7PqgBdoaTd91NV93NY9NWJF1107RgNmr+THaU8E7fvvY3QHjEw8ORe7Mi46EKu0pyHscWHd6K5L//X/RP5U+cf8VG0lGgVgAAAABJRU5ErkJggg==","contentType":"image/png","width":18,"height":21,"angle":0,"xoffset":0,"yoffset":0},"value":"GREEN","label":"Green (1000-1499 GPM)"},{"symbol":{"type":"esriPMS","url":"854ff6a52d04276dfb640a7b6a177c2d","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAcCAYAAAB75n/uAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAClElEQVRIid2WX0hTURzHP1elESWlMGzrwehFiKJivfiYEEFtUFBbPTmIZg8FE3soCszwVejBBxP3EkRuhIEuCgqfSiIaFUo+RZLUQvJfiUa4TvzuPdNNd+fdIoK+cNn5nXvu73t+v9/3/M6q+Muo+v8JVAIfcAPwgDkWpPTTawTN3/IIVNx03F7glU8/EZUgZQQ5VDKBShDJdT4zDeNjMDsHHi/s3Q+uTRaZSjBkBAk4JlD38MruZPx9AaLtEJ+0clQNpIFMBVw9DK0t5id+FSdghBjakEDn/FXWvngTvkzCe6AuZ93ILzg5DN7dEDoCGAyqBC1GkN7iESgCGKAUzH+DgY8wCLiAuZxle4BzCvqfwLFGqN5qTkvUGxBoTC+A+7w1bqIIJqAxCmN95cqU4ngMXF41004I8nS9q1Iqak+w5AK3lR7B56IEusCScmq2wGgX7GuDp2sKnEUSeLQdYldWpiIqTjJXTWsjMKX5+gNc6lqdbAB2ALeAUeC06BJ4I/ZXCHdCvQfuXjPVJGfHlkD0z/wivJyCBPBcv+gEHgIhIJwNE6jPwKkp6FnK92FHsIIK4ESOLURtwBlgHHimPe3U63ps/NgSSF27pRX8tOyjQAfwFhjAqosQTRhwR4RgOCMwVeCpgeYmK8cMWy9k925NIAn2aYLZzfDuAByvzfdRmCBDB5UEGrx4+i5YUzFNIBtsLrDDg7XQH807B/Yn2Thrsnt1J71dOGhbyN1gtT7bCLJQpH8sw/0XlvlAzkWBZSPAp0VIpsDvy1ePLUH2sIlUw90g9Wsttu8ZuB4zCfwSueNuWrcNluOUCgfd1DBFUuiadIJ19/M6ArnE5eLIto0SkDJV6KTIOo95oVIm/v3/oj/Fb26/t4ksh4QHAAAAAElFTkSuQmCC","contentType":"image/png","width":18,"height":21,"angle":0,"xoffset":0,"yoffset":0},"value":"ORANGE","label":"Orange (500-999 GPM)"},{"symbol":{"type":"esriPMS","url":"9c87d81de8c02bc9d88a88ac2cec127d","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAcCAYAAAB75n/uAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAC/0lEQVRIid2Wz0tUURTHP/fNc0anBpT8NSP9mIR+uKkYIZ2gRZt+OZALqU0UCLoLI6GlCv0BLVqomyho40JBK1q0rKmo6Qf9QigmClMLs0kcm+e8d+O+makZc8bRiKDv6p57D+9z7jnn3vt0/rL0/x9g7K0PSM3qFQIvkoA9KYggiWBpg84HbyNrBiSCW3uRVo9QhsxaSIECaFaHEfRHnOFo46oBRtDfgZQ9GfuLYTIeW2B20cRbqtNQ7salCRuWaPaPue5FQ0UD5vdt9CHpUOO5pEn3yymG4gZewANMAqaA81UeztRXIqDle5M/VHo/OrYiQOUcy3qUsbteTTEdN3gL1GT5hSW0fprDu95FW40HTTBqBP2dznB0sCBAOmRIyFTKY4smI3GDUcAFfM3yawDagaHpbxza4MajO9S02nVhQEYzSRPfo/f2+EA+JzufBvufTvCkcdPa2lSusH4L6M74Srs8hQHSkhFh92VKW0RhyoImqNQ1eyzgY0GAXWBhqZRT4XDwZFcde55NcHtJgTO6Dtx06gzu+Lna8b3Jfz27m3J3oFl2az6dN+gan/45vR2oBS4Cz4E2oEX5AS8SSdpfTbG5rIQrO2vRNNTZWR4gwacyEjMtHiaSDAGt6bULwA3gOHAa7M5S2iwlbYkk/WYqj1Liy5uinM0Ax7Lsu8A54ATwGrgD9pfq0n79eb6TF2ACl9RVYKUiOwj0Ac+AYbDrokDvgKuqK0QRgEwXeEscnKz28FgZn+bsNRV9VRqgEhxIA2YdGi/KyzjsTH1KiNxOygEsask+3dJD28pKvAP1lfbc5TRABXhqmQh3O3Wubau2xxImRaGTvO7uB0X3pW5SBvKlL48GXfeinUXVwLKYNKRkeGbetkfUuVjGLwxMmBY3ZuMcqXDndE9eQOawxZIW7W8+o66ws4XiNpL0RGc4WuFuUTsv+jatKXGw0OxnlVr5NhWmGEP79ZKtSuqdXqLfAOoRVw9HOpriJYmoLiyqyOk85myVNerf/xf9qX4ACiUNFIbTq4YAAAAASUVORK5CYII=","contentType":"image/png","width":18,"height":21,"angle":0,"xoffset":0,"yoffset":0},"value":"RED","label":"Red ( <500 GPM)"},{"symbol":{"type":"esriPMS","url":"bdb4f70f326eae60498677a7495f0210","imageData":"iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAB1ElEQVQ4jbXUz0uUURTG8c84Y6OmmWaREkUuzAIXYZsIgraF/gPhKloFgm2CohCirUK0aBPUqohWWbsKChKSrCCCQBSRULIGHS1n1NGRd3yVcMZfYHfzcu6598tznvPeE7ODK/b/YO3ZZlF1W769YNTdSH8+rCPbYmrkufmZrUuprA/uteqO9KxVVqv3povJIZVzSbPZBe/+jBqYncwla2Klzu6uc7C4LBd/zKT0tfawr7G2cJll+3Ukvmn+/VWg7zwGwlRRJuV2ctCJML5ecVjfVhswhBJcRjm+4A2rsEIrD/YynRDHNTzB3nB/MVCDp4ji5+L8JrBUQufUsHt49Q8oVybu4Aw+4Ujo5fqwqWFZ/EVTgTICRfX4gMFMahNYLHCJdCAy6EcB4Hj4LY0U5Zq0PqzqmIYfb7VlUu7j6prDQRNKcQETxRV6N4QVxTysbnR6/LNLuIW2sJuv8RiPgn81aEZ8zyYw7MpZzQNcQUO4fzw0viSMi0XyLMiDvahvMVZeJ5FJezb6nsyyM99x48BJ58oP5eKR9MQGsAX9onGd89NUhXpqmpgcYG5atvKorpJqXSvnZ36x/LTG8mHB62/Pntr21OguNDVWgKwmt7t2dDguAczshWxmYRtBAAAAAElFTkSuQmCC","contentType":"image/png","width":14,"height":14,"angle":0,"xoffset":0,"yoffset":0},"value":"FLUSH","label":"Other (Blowoff / Flush / Post)"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,218,255],"toColor":[252,204,218,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[211,252,182,255],"toColor":[211,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,249,252,255],"toColor":[184,249,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[190,179,252,255],"toColor":[190,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,233,187,255],"toColor":[252,233,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[199,214,252,255],"toColor":[199,214,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,233,255],"toColor":[252,179,233,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,252,220,255],"toColor":[204,252,220,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[237,204,252,255],"toColor":[237,204,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,214,197,255],"toColor":[252,214,197,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,252,179,255],"toColor":[250,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[230,182,252,255],"toColor":[230,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[240,252,204,255],"toColor":[240,252,204,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: Flow_Capacity_Color

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
HYDRANT_ID (type: esriFieldTypeString, alias: Hydrant GIS Asset ID , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
HYD_NO (type: esriFieldTypeString, alias: Hydrant Number, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
TYPE (type: esriFieldTypeString, alias: Fire Rated Capacity or Flush Only? , SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [FIRE RATED - HYDRANT: Fire Rated], [FLUSH DEVICE - HYDRANT: Flush Device])
ADDRESS (type: esriFieldTypeString, alias: Street Name(s) / Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
STAMPED_NUMBERED (type: esriFieldTypeString, alias: Is No. Stamp visible?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
HYDRANT_MARKER (type: esriFieldTypeString, alias: Is there a Visible Marker Present? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
LOCATION_DESCRIPTION (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [By Road: By Road], [Intersection: Intersection], [Building/Structure: Next to Building/Structure], ... 5 more ...)
MANUFACTURER (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AMERICAN AVK COMPANY: AMERICAN AVK COMPANY], [AMERICAN DARLING VALVE: AMERICAN DARLING VALVE], [AMERICAN FOUNDRY AND MANUFACTURING COMPANY: AMERICAN FOUNDRY AND MANUFACTURING COMPANY], ... 23 more ...)
CAST_YEAR (type: esriFieldTypeSmallInteger, alias: Cast Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
MODEL (type: esriFieldTypeString, alias: Model , SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
BARREL_DIA (type: esriFieldTypeDouble, alias: Barrel Diameter (Main Valve Opening), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4.5: 4.5" NH (NST)], [5: 5" STORZ], [5.25: 5.25" NH (NST)], ... 1 more ...)
COLOR (type: esriFieldTypeString, alias: Color of Barrel / Body, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [BLACK: Black], [BLUE: Blue], [GREEN: Green], ... 11 more ...)
Flow_Painted (type: esriFieldTypeString, alias: Are Bonnet / Caps Painted by Flow Capacity?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Flow_Capacity_Color (type: esriFieldTypeString, alias: Color of Bonnet/Caps (Flow Rating), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [GREEN: Green (1000-1499 GPM)], [ORANGE: Orange (500-999 GPM)], [BLUE: Blue ( >1500 GPM)], ... 3 more ...)
DAMAGE (type: esriFieldTypeString, alias: Any Damage / Issues?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Leaking: Leaking], [Caps Missing: Caps Missing], [Chains Missing: Chains Missing], ... 6 more ...)
CONDITION (type: esriFieldTypeString, alias: Overall Hydrant Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [3: Fair (some aging / wear & tear)], [1: Very Good (relatively new)], [2: Good (newer, with no problems)], ... 2 more ...)
OPERABLE (type: esriFieldTypeString, alias: Operable / Functional?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Public: Public], [Private: Private])
COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
VALVE (type: esriFieldTypeString, alias: Hydrant have Gate Valve? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
WVAL_ID (type: esriFieldTypeString, alias: Valve ID, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
SURF_ELEV (type: esriFieldTypeSmallInteger, alias: Surface Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
BURY_DEPTH (type: esriFieldTypeDouble, alias: Bury Depth (feet), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hydrant_Flow (type: esriFieldTypeSmallInteger, alias: Calculated Flow Capacity at 20 PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
Static_Pressure (type: esriFieldTypeSmallInteger, alias: Static Pressure (PSI), SQL Type: sqlTypeOther, nullable: true, editable: true)
Pitot_Pressure (type: esriFieldTypeSmallInteger, alias: Flow Pressure (PSI) - Pitot, SQL Type: sqlTypeOther, nullable: true, editable: true)
Residual_Pressure (type: esriFieldTypeSmallInteger, alias: Residual Pressure (PSI), SQL Type: sqlTypeOther, nullable: true, editable: true)
MAIN_SIZE (type: esriFieldTypeDouble, alias: Main Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [0.625: 5/8], [0.75: 3/4"], ... 13 more ...)
LATERAL_SIZE (type: esriFieldTypeDouble, alias: Hydrant Lateral Pipe Size?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [6: 6"], [8: 8"], [10: 10"], ... 1 more ...)
Hose_Nozzle_Size (type: esriFieldTypeDouble, alias: Hydrant Hose Outlet Size (inches), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2.5: 2.5" NH (NST)], [4: 4" NH (NST)])
INSTALL_YEAR (type: esriFieldTypeSmallInteger, alias: Install Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
OPERNUT_CONDITION (type: esriFieldTypeString, alias: Operating Nut Condition?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [3: Fair (some aging / wear & tear)], [1: Very Good (relatively new)], [2: Good (newer, with no problems)], ... 2 more ...)
PAINT_YEAR (type: esriFieldTypeSmallInteger, alias: Last Paint Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
DRAINED_DATE (type: esriFieldTypeDate, alias: Last Drain Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MAINTEN_REQ (type: esriFieldTypeString, alias: Maintenance Request, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA])
MAINTEN_NOTES_SERVICES (type: esriFieldTypeString, alias: Maintenance Notes , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Flush_Date (type: esriFieldTypeDate, alias: Date of Latest Flushing, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Type_Flushing (type: esriFieldTypeString, alias: Conventional Flushing Performed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Conventional_Flushing: Conventional Flushing (1 Hydrant)], [Unidirectional_Flush: Undirectional Flushing (2+ Hydrants)])
Hydrant_Test_Option (type: esriFieldTypeString, alias: Hydrant_Test_Option, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Gauge_Option (type: esriFieldTypeString, alias: Was Pitot / Static Gauge Used During Flushing Last? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Pitot_Gauge: Pitot Gauge], [Pitot_Static_Gauge: Pitot and Static Gauge], [Static_Gauge: Static Gauge], ... 1 more ...)
Discharge_Rate (type: esriFieldTypeSmallInteger, alias: Flow GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
Water_Loss (type: esriFieldTypeString, alias: Water Loss from Latest Flush, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CREATEDATE (type: esriFieldTypeDate, alias: GIS / GPS Create Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
CREATOR (type: esriFieldTypeString, alias: Creator Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
MODIFYDATE (type: esriFieldTypeDate, alias: GPS / GIS Modified Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
MODIFYUSER (type: esriFieldTypeString, alias: Last Modify User, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: false)
ESRIGNSS_POSITIONSOURCETYPE (type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: false, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 2 more ...)
ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false, Coded Values: [EOS Arrow 100: EOS Arrow 100], [BadElf Surveyor: BadElf Surveyor], [Other: Other], ... 2 more ...)
ESRIGNSS_LATITUDE (type: esriFieldTypeDouble, alias: GPS Latitude, SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: GPS Longitude, SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_ALTITUDE (type: esriFieldTypeDouble, alias: GPS Altitude, SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_H_RMS (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_V_RMS (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_FIXDATETIME (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
ESRIGNSS_FIXTYPE (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: false, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
ESRIGNSS_CORRECTIONAGE (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_STATIONID (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: false, Range: [0 - 1023])
ESRIGNSS_NUMSATS (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: false, Range: [0 - 99])
ESRIGNSS_PDOP (type: esriFieldTypeDouble, alias: PDOP, SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_HDOP (type: esriFieldTypeDouble, alias: HDOP, SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_VDOP (type: esriFieldTypeDouble, alias: VDOP, SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_DIRECTION (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_SPEED (type: esriFieldTypeDouble, alias: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRISNSR_AZIMUTH (type: esriFieldTypeDouble, alias: Compass reading (°), SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_AVG_H_RMS (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_AVG_V_RMS (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_AVG_POSITIONS (type: esriFieldTypeSmallInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: false)
ESRIGNSS_H_STDDEV (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: false)
FIRE_DIST (type: esriFieldTypeString, alias: Fire District Associated with, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
EXT_USER (type: esriFieldTypeString, alias: Engineer / Contractor Name for Project, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
AGENCY (type: esriFieldTypeString, alias: Agency for GIS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CONTACT (type: esriFieldTypeString, alias: Contact Name for GIS, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
ATT_SOURCE (type: esriFieldTypeString, alias: Attribute Information provided by (Operator Name), SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
ATT_ISSUES (type: esriFieldTypeString, alias: Attribute Issues LIST HERE, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
XY_SOURCE (type: esriFieldTypeString, alias: GPS External Source Reference, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [AERIAL IMAGERY: KY1Z 12-INCH RESOLUTION: Aerial Imagery (12-INCH Meter Resolution)], [AERIAL IMAGERY: KY1Z 2-FOOT RESOLUTION: Aerial Imagery (2FT Resolution)], [AERIAL IMAGERY: KY1Z 6-INCH RESOLUTION: Aerial Imagery (6-INCH Resolution)], ... 6 more ...)
XY_ISSUES (type: esriFieldTypeString, alias: GPS Issues LIST HERE, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
POINT_X (type: esriFieldTypeDouble, alias: Calculated X - Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Y (type: esriFieldTypeDouble, alias: Calculated Y - Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Z (type: esriFieldTypeDouble, alias: Calculated Z - Surface Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
ELEV_SRC (type: esriFieldTypeString, alias: Elevation Source, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
SEQUENTIAL_ID (type: esriFieldTypeString, alias: Sequential ID to help with Asset ID Purposes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Types:

Field Name: TYPE
Inherited
Field Name: STAMPED_NUMBERED
Inherited
Field Name: HYDRANT_MARKER
Inherited
Field Name: LOCATION_DESCRIPTION
Inherited
Field Name: MANUFACTURER
Inherited
Field Name: BARREL_DIA
Inherited
Field Name: COLOR
Inherited
Field Name: Flow_Painted
Inherited
Field Name: Flow_Capacity_Color
Inherited
Field Name: DAMAGE
Inherited
Field Name: CONDITION
Inherited
Field Name: OPERABLE
Inherited
Field Name: OWNER
Inherited
Field Name: VALVE
Inherited
Field Name: MAIN_SIZE
Inherited
Field Name: LATERAL_SIZE
Inherited
Field Name: Hose_Nozzle_Size
Inherited
Field Name: OPERNUT_CONDITION
Inherited
Field Name: MAINTEN_REQ
Inherited
Field Name: Type_Flushing
Inherited
Field Name: Gauge_Option
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_RECEIVER
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Field Name: XY_SOURCE
Inherited

Flow_Painted: No
AGENCY: RCAP Solutions
TYPE: FIRE RATED - HYDRANT
HYDRANT_MARKER: Yes
LOCATION_DESCRIPTION: By Road
BARREL_DIA: 5.25
COLOR: RED
Flow_Capacity_Color: BLACK
OWNER: Public
VALVE: Yes
LATERAL_SIZE: 6
Hose_Nozzle_Size: 2.5
MAINTEN_REQ: No
XY_SOURCE: GPS: MAPPING GRADE OBSERVATION

Field Name: TYPE
Inherited
Field Name: STAMPED_NUMBERED
Inherited
Field Name: HYDRANT_MARKER
Inherited
Field Name: LOCATION_DESCRIPTION
Inherited
Field Name: MANUFACTURER
Inherited
Field Name: BARREL_DIA
Inherited
Field Name: COLOR
Inherited
Field Name: Flow_Painted
Inherited
Field Name: Flow_Capacity_Color
Inherited
Field Name: DAMAGE
Inherited
Field Name: CONDITION
Inherited
Field Name: OPERABLE
Inherited
Field Name: OWNER
Inherited
Field Name: VALVE
Inherited
Field Name: MAIN_SIZE
Inherited
Field Name: LATERAL_SIZE
Inherited
Field Name: Hose_Nozzle_Size
Inherited
Field Name: OPERNUT_CONDITION
Inherited
Field Name: MAINTEN_REQ
Inherited
Field Name: Type_Flushing
Inherited
Field Name: Gauge_Option
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_RECEIVER
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Field Name: XY_SOURCE
Inherited

Flow_Painted: No
AGENCY: RCAP Solutions
TYPE: FIRE RATED - HYDRANT
HYDRANT_MARKER: Yes
LOCATION_DESCRIPTION: By Road
BARREL_DIA: 5.25
COLOR: RED
Flow_Capacity_Color: BLUE
OWNER: Public
VALVE: Yes
LATERAL_SIZE: 6
Hose_Nozzle_Size: 2.5
MAINTEN_REQ: No
XY_SOURCE: GPS: MAPPING GRADE OBSERVATION

Field Name: TYPE
Inherited
Field Name: STAMPED_NUMBERED
Inherited
Field Name: HYDRANT_MARKER
Inherited
Field Name: LOCATION_DESCRIPTION
Inherited
Field Name: MANUFACTURER
Inherited
Field Name: BARREL_DIA
Inherited
Field Name: COLOR
Inherited
Field Name: Flow_Painted
Inherited
Field Name: Flow_Capacity_Color
Inherited
Field Name: DAMAGE
Inherited
Field Name: CONDITION
Inherited
Field Name: OPERABLE
Inherited
Field Name: OWNER
Inherited
Field Name: VALVE
Inherited
Field Name: MAIN_SIZE
Inherited
Field Name: LATERAL_SIZE
Inherited
Field Name: Hose_Nozzle_Size
Inherited
Field Name: OPERNUT_CONDITION
Inherited
Field Name: MAINTEN_REQ
Inherited
Field Name: Type_Flushing
Inherited
Field Name: Gauge_Option
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_RECEIVER
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Field Name: XY_SOURCE
Inherited

Flow_Painted: No
AGENCY: RCAP Solutions
TYPE: FIRE RATED - HYDRANT
HYDRANT_MARKER: Yes
LOCATION_DESCRIPTION: By Road
BARREL_DIA: 5.25
COLOR: RED
Flow_Capacity_Color: GREEN
OWNER: Public
VALVE: Yes
LATERAL_SIZE: 6
Hose_Nozzle_Size: 2.5
MAINTEN_REQ: No
XY_SOURCE: GPS: MAPPING GRADE OBSERVATION

Field Name: TYPE
Inherited
Field Name: STAMPED_NUMBERED
Inherited
Field Name: HYDRANT_MARKER
Inherited
Field Name: LOCATION_DESCRIPTION
Inherited
Field Name: MANUFACTURER
Inherited
Field Name: BARREL_DIA
Inherited
Field Name: COLOR
Inherited
Field Name: Flow_Painted
Inherited
Field Name: Flow_Capacity_Color
Inherited
Field Name: DAMAGE
Inherited
Field Name: CONDITION
Inherited
Field Name: OPERABLE
Inherited
Field Name: OWNER
Inherited
Field Name: VALVE
Inherited
Field Name: MAIN_SIZE
Inherited
Field Name: LATERAL_SIZE
Inherited
Field Name: Hose_Nozzle_Size
Inherited
Field Name: OPERNUT_CONDITION
Inherited
Field Name: MAINTEN_REQ
Inherited
Field Name: Type_Flushing
Inherited
Field Name: Gauge_Option
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_RECEIVER
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Field Name: XY_SOURCE
Inherited

Flow_Painted: No
AGENCY: RCAP Solutions
TYPE: FIRE RATED - HYDRANT
HYDRANT_MARKER: Yes
LOCATION_DESCRIPTION: By Road
BARREL_DIA: 5.25
COLOR: RED
Flow_Capacity_Color: ORANGE
OWNER: Public
VALVE: Yes
LATERAL_SIZE: 6
Hose_Nozzle_Size: 2.5
MAINTEN_REQ: No
XY_SOURCE: GPS: MAPPING GRADE OBSERVATION

Field Name: TYPE
Inherited
Field Name: STAMPED_NUMBERED
Inherited
Field Name: HYDRANT_MARKER
Inherited
Field Name: LOCATION_DESCRIPTION
Inherited
Field Name: MANUFACTURER
Inherited
Field Name: BARREL_DIA
Inherited
Field Name: COLOR
Inherited
Field Name: Flow_Painted
Inherited
Field Name: Flow_Capacity_Color
Inherited
Field Name: DAMAGE
Inherited
Field Name: CONDITION
Inherited
Field Name: OPERABLE
Inherited
Field Name: OWNER
Inherited
Field Name: VALVE
Inherited
Field Name: MAIN_SIZE
Inherited
Field Name: LATERAL_SIZE
Inherited
Field Name: Hose_Nozzle_Size
Inherited
Field Name: OPERNUT_CONDITION
Inherited
Field Name: MAINTEN_REQ
Inherited
Field Name: Type_Flushing
Inherited
Field Name: Gauge_Option
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_RECEIVER
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Field Name: XY_SOURCE
Inherited

Flow_Painted: No
AGENCY: RCAP Solutions
TYPE: FIRE RATED - HYDRANT
HYDRANT_MARKER: Yes
LOCATION_DESCRIPTION: By Road
BARREL_DIA: 5.25
COLOR: RED
Flow_Capacity_Color: RED
OWNER: Public
VALVE: Yes
LATERAL_SIZE: 6
Hose_Nozzle_Size: 2.5
MAINTEN_REQ: No
XY_SOURCE: GPS: MAPPING GRADE OBSERVATION

Field Name: TYPE
Inherited
Field Name: STAMPED_NUMBERED
Inherited
Field Name: HYDRANT_MARKER
Inherited
Field Name: LOCATION_DESCRIPTION
Inherited
Field Name: MANUFACTURER
Inherited
Field Name: BARREL_DIA
Inherited
Field Name: COLOR
Inherited
Field Name: Flow_Painted
Inherited
Field Name: Flow_Capacity_Color
Inherited
Field Name: DAMAGE
Inherited
Field Name: CONDITION
Inherited
Field Name: OPERABLE
Inherited
Field Name: OWNER
Inherited
Field Name: VALVE
Inherited
Field Name: MAIN_SIZE
Inherited
Field Name: LATERAL_SIZE
Inherited
Field Name: Hose_Nozzle_Size
Inherited
Field Name: OPERNUT_CONDITION
Inherited
Field Name: MAINTEN_REQ
Inherited
Field Name: Type_Flushing
Inherited
Field Name: Gauge_Option
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_RECEIVER
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited
Field Name: XY_SOURCE
Inherited

Flow_Painted: No
AGENCY: RCAP Solutions
TYPE: FIRE RATED - HYDRANT
HYDRANT_MARKER: Yes
LOCATION_DESCRIPTION: By Road
BARREL_DIA: 5.25
COLOR: RED
Flow_Capacity_Color: FLUSH
OWNER: Public
VALVE: Yes
LATERAL_SIZE: 6
Hose_Nozzle_Size: 2.5
MAINTEN_REQ: No
XY_SOURCE: GPS: MAPPING GRADE OBSERVATION

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/8/2026 3:19:41 PM

Schema Last Edit Date: 9/8/2026 3:19:41 PM

Data Last Edit Date: 9/8/2026 3:19:41 PM

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