Name: Hydrants
Display Field: ASSET_ID
Type: Feature Layer
Geometry Type: esriGeometryPoint
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:
XMin: -20037507.8427882
YMin: -30240971.4583861
XMax: 20037507.8427882
YMax: 30240971.4583861
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"Flow_Capacity_Color","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"5d33060336c36d039c650dd3031ebbd2","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAaCAYAAAC3g3x9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAACNUlEQVRIib1VO27bQBScZeTKvQ3RVdS7oov0aUUdIAcgG0OQTyD6BAkCN+EBcgCu2vQuwkq9UnkJq7bKaIPZD8lQopgERgYguCSWs+/Ne/M4witj9P8I5zrCG0TYI0aAsXm3RwUBhT1yfBblnxPe6QQaX6ABCMDc4dZEgAQLfY9PIhsm9GTDWGKh0SU9FmFSr9a5vbYuu/MQmEyB9/V5S9zqHA9CHRLe6hBnKKARmedihngjsQQQui3lTiFf55DPJfDhu2d4wlzfeE0bwjNMa7JdhXAjUXRCn7rraltCbVY2WoLFAzqE2gXCjY8ZmMMNTuBbClBqkvpA+qocbcvBqqQ7ZSTooiHcQyIwkqECkOM0uKeGsOk2hLaJbd9dRlDvMqweM8t+BDxMXSfAJLYvNDLMdcnCjOpGpQ7U74c0RfH9w5V0d3/AylS8MlrjbUwdxxBgP8ajuiB0wU4hXOemkvyIoPSEcpE9uedkI02e5UXUo6HD2EXmCWXLeVct7Zgs26LsfH9AWHU28fyZ6z8eZqeE3XNYY3QIWZBJjPRFIXR2Y4QUh09t02a04fnY2pHgFKoJfyI1FqIes8J696tta0Z0tCfpZ+8UJiasSpbQmltgoRlEX7f04b49cX5PmQ1K4z+XJn5fmC5MbsziMrJpt9AQsrk1CrxUzqe2kr1gD5LsOlliruXhtAnc99SFg/NvEJhOS3u9/A+o/KIhZMh3mqc0E3sI/qfVW5SPgu4aGjQn8er/5V+d/sq+ECa06QAAAABJRU5ErkJggg==","contentType":"image/png","width":15,"height":19,"angle":0,"xoffset":0,"yoffset":0},"value":"BLUE","label":"Blue ( >1500 GPM)"},{"symbol":{"type":"esriPMS","url":"bd963a1507dc1b3138709e43533ae86d","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAaCAYAAAC3g3x9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAACX0lEQVRIib2Vv28SYRjHPy/FRtPBsphAXcqiiws0gaRuXYtxUGP/gMLu4OACXTr4H0g3FwhhKl1xM8oAu8uxWIgm5rqw1PZe89z7chxwlJI0fpPLve+9733ueZ9fF+eOFf9vwFyDLB5ZBQUgaR8PFQy8GNXOG7q3BubqFJXHp6g1DSiPYr7G0fcDKkuBPoxo2JQU5XwNZqFzQAXF8fh3G361YeSY+XoCNjOQPpxAd2tUvx4wmAPu1khdK06BrMx/fITnPWgAKbun60K1DV/68OzYPLtWnOca7Ix9GgCvFPvKwi5deNDDp4e1b68tB9weJDJ2wfPfmwYqTUrOKxt/NmEE7Nzgwv4JcGigMWtIpA9FT53lUSm54LrzzwOgXqOlPMoyHgLVJUDZc9+OPXvcAChJPM67jW0YvYKzJoYeIfnY1Z6JuC9NJdegK4HxgTGPooas+M/twl8JCiZ/xJKWvY8/cAY4rvF1Iuv7MYnn52PBB2qbGQKKt+GlfUlUsveBtezczl/3zDndNFOaC0rSWjYGtmy5ibaspSIpcLHiM0uA8kK46iUfXtj8S4a6hOwJymMRUALiZuDdBTx0JhZWLCBctMcJuJeAxwkzly4UANc0JSmhjTQ8eW9q988Hs1EsisrJbZvUIq0Zoo2XfKAtbpWvUZGCZxVpjjqhjjPtQ0131Ae5BqHAzErW5BTiovXN6bX4TIc+vbwA52QSyYVqmnb2aI9yrkFrrtuoawriWfFLvr7SoZHCGKdsZC2vKi1BsQqAYnKuTincsW8h/6f1bVFQOm/96lrWaG7Unf+X/wHP5MeC7FfOZAAAAABJRU5ErkJggg==","contentType":"image/png","width":15,"height":19,"angle":0,"xoffset":0,"yoffset":0},"value":"GREEN","label":"Green (1000-1499 GPM)"},{"symbol":{"type":"esriPMS","url":"be172574a3056b5cb699b1fa4fcc0448","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAaCAYAAAC3g3x9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAACA0lEQVRIib2VP27iQBjFfxY5wFKadLnCcISUNt1mlQs4R8h2eLvkCPEFIkwHlDlC5gp0gZITRLP65g8eHGxAivKkke3x+M2b9/3xFd+Mqx8jNDUK7MiB1E9vgQ1QJXfoswlNTQG89AgpzIx/yR/Kk4RnkDkkTM0M2qTHFAqhRfXmhl6759EQMgUvRUT6SpXcWxsOCc0rIwYsvG9MnkFcEqkjv0bv3AbjNbw/+ckBH6ZmHDxtFA7IAtl2B1rDR0t65sf1GlbaqfWQuxahYUTiFpZzF8ox3Xio3NEzR6r600aO1ENmCXew2X2dbwgTlsA0JFt1glDWRNAHhD6JbaqoGyh+QzX37Ecgm2W3kDcelqZGS2CCQkkEJf4ttQtKmBQlS38NG6x84MTrXFkfpZIkH/NAaDNDPFm9uUjuvfJXW280kU+1O6e66fIwLPTKRAVenfH315F3eZSfvYTyQVz1YtPE518adQntVad9hCJfKajEw3WjsPQEcdFWQ0iHkA/3U5uG8JMHKSEhXDy62p38davSjk4RJbVgi3EuWUJf3ImZUUrBcwnMYRtre6hFnYxNFJg25J2skROlvw7fNd3GJfdC8kvqNESyC3ruPCxumZqa5dduY8ilOYgvpuZSFCFlj9byxTBNae8JRbKp7S77jn0G7E+rMyjJna2uU42mF9/+X/4Py/Gs1aK3t5YAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":19,"angle":0,"xoffset":0,"yoffset":0},"value":"ORANGE","label":"Orange (500-999 GPM)"},{"symbol":{"type":"esriPMS","url":"f01f75190efd101e6456c42ebedf2eb7","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAaCAYAAAC3g3x9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAACiklEQVRIib1V22oTURRdZyYXaO1DQIyTkocmLz4JNoVo+gWaRtBfUFLwJxLpPwgJ+g1Cq/5Bi4JJwCdfrA+xDQFhhDSBOTSzZe85MyRpLhaKC4bMmZxZZ+3L2hPDDSP23wh1MV+A7ReIUFEKDj8jQk8B5/CtZuLLj9Y/E+rSVhXkN0CAEqbgudwzLL/qlXKvkyen9ZWEARkaq0JTRDWvlMMs6TyF1fDmbX8gV3voydpJ2Cin1vAmdzsiHe5mm+vH3fMrhMPdbCZOsUMQCrx+9r0Pyx2hCSBj9rT0GM3+AA8vND7fD57G/diZLuZ3wpxGhHGK7YVkPT1Gxx3hbEb6nrk2hx4+uiNRK7B9fm+akKAyCiQbD7p/wDHsYDFenf6W0MtMaoRMEU5CDT18xXLs67FEMouIUI3VESyq8X0PkNwtA++JoIJwI0LTxNJ32+tJvMim8K7rQtjngA97kt6IckiEui7mW1yYQKHlc+8VOH98haFUjZIj8xse8MEU7uCXK6Tl1JpDls/9WBFCAjLKbPrUH0glO+blffN7bpSFld90RxLn9npyfg5DOEYZq4BRZ5yHzYncVSb6cykhvzDpeu6Hp6b/+DCZEmYPq76zjHD7VgIPUmtocA6N3Vhh3RBMmraRsOHEY3icsGUtUygkvLQu99lCnI/399Li3effAnuyonmTImpqSEp6REGWhNCYW3mlXJ0Nj2uAlJoaY1Mhk0+tzshD+0KL/rAws+D/2kMtFb6bnC5DtJLmVv4htw77NKzkIrS6Lpy4jZfpjZou5o+uTBuyqaIIkhf9aOs6UUOMYVp2rpevC1IqsnZEyJJ1aYtPiSb2SiLz0VpYlMTJT3bXqkGzFDf+Xf4Lc+ASZUWTgicAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":19,"angle":0,"xoffset":0,"yoffset":0},"value":"RED","label":"Red ( <500 GPM)"},{"symbol":{"type":"esriPMS","url":"3619ea1bd03ed057bb446ab2004f7581","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA5klEQVQokZWSwQ2CQBREn8lWoCeN8UQHUIa0YRvWoW1gGdIBXgzBk7SAGfM/WVY4OMlmyf4/f2aWDQzDik225x/0TRtEKvvHM7ezDrjZLpSA14QKqNfZIWCFsxVq4Bo1dsAJOEZn6vkSU+S2auCVKDqCT/Umqd2TpgK4WH1CvBkhnyF5rsIE8lSRBUvC1mpdpDrJKLtL6JI9+JXH01LUtu9MWdbH36HwWJbK7GEk3YHqIuouRqLnENQgBw4168zrjp//KLtxVn3rccwSJR1D1jVAuaUuq1px3qAHq7e3dKMamg7m3bQf+RxAIISYEG8AAAAASUVORK5CYII=","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"FLUSH","label":"Other (Blowoff / Flush / Post)"},{"symbol":{"type":"esriPMS","url":"1aca1d0aac89f55f76ea9fbd09430077","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAaCAYAAAC3g3x9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABU0lEQVRIib1ViW3DMAy8AlpCzhjuGHXHSMZwMkY7RpM1NEasMVrQIdPTY1spgh5gWLCl4+lIUQ5PhvtPwl6fAYDXbxHABOATQHiEcA/gYyWY/D8BOLYQbpEZRn0fWwhbMer2pxphB+BLfZsx6Ar5ATVNVp9T0iuAV/OUCd+YzNiRTZBnx5Ju6GuEJmTGpGEb0a9muW/IymGhbhyNz5a5qF6tQeYQQk6YiJLtXqguciRp/S0dIQ2OSuXuA+hjVOmRAlzK7XolHVyekE4zKYvMK9B5u1KwWRJSFEnxOtkIRd23jnfk3aDBwxZhzCaJD++q2lOXCKWPdcJJt9mRQnOcD23RFXDjN8ID2ZPAt3WKaC45Yn/RwEvVsoQTC863HPJarKHmXY2wz/uBZLIBo1pdNIfG9VXsrWSrZ/kPiDZgQpEsUR7p2HZpLSZFTtdWo1nF0+/lHxqPU8jI5SXbAAAAAElFTkSuQmCC","contentType":"image/png","width":15,"height":19,"angle":0,"xoffset":0,"yoffset":0},"value":"BLACK","label":"Black (Out of Service)"}],"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:
IsSystemMaintained : True
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)
- ASSET_ID (type: esriFieldTypeString, alias: GIS Asset ID , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- HYD_NO (type: esriFieldTypeString, alias: Hydrant NO., 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])
- CAST_YEAR (type: esriFieldTypeSmallInteger, alias: Cast Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- INSTALL_YEAR (type: esriFieldTypeSmallInteger, alias: Install Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- 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 ...)
- 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: Is Bonnet / Caps Marked 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)
- 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)])
- 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 ...)
- MAIN_SIZE (type: esriFieldTypeDouble, alias: Main Pipe Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [0.625: 5/8], [0.75: 3/4"], ... 13 more ...)
- 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) (Average / Latest), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Pitot_Pressure (type: esriFieldTypeSmallInteger, alias: Pitot Pressure (PSI) (Average / Latest), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Residual_Pressure (type: esriFieldTypeSmallInteger, alias: Residual Pressure (PSI) (Average / Latest), 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)
- MAINTEN_REQ (type: esriFieldTypeString, alias: Maintenance Request, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- 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_LATITUDE (type: esriFieldTypeDouble, alias: GPS Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: GPS Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_ALTITUDE (type: esriFieldTypeDouble, alias: GPS Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_AVG_H_RMS (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_AVG_V_RMS (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Types:
ID: BLUE
Name: Blue ( >1500 GPM)
Domains:
- 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: Hose_Nozzle_Size
Inherited
- Field Name: LATERAL_SIZE
Inherited
- Field Name: MAIN_SIZE
Inherited
- Field Name: OPERNUT_CONDITION
Inherited
- Field Name: MAINTEN_REQ
Inherited
- Field Name: Type_Flushing
Inherited
- Field Name: Gauge_Option
Inherited
Templates:
Name: Blue ( >1500 GPM)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Flow_Painted: No
- BARREL_DIA: 5.25
- COLOR: RED
- Hose_Nozzle_Size: 2.5
- TYPE: FIRE RATED - HYDRANT
- HYDRANT_MARKER: Yes
- LOCATION_DESCRIPTION: By Road
- Flow_Capacity_Color: BLUE
- OWNER: Public
- VALVE: Yes
- LATERAL_SIZE: 6
- MAINTEN_REQ: No
ID: GREEN
Name: Green (1000-1499 GPM)
Domains:
- 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: Hose_Nozzle_Size
Inherited
- Field Name: LATERAL_SIZE
Inherited
- Field Name: MAIN_SIZE
Inherited
- Field Name: OPERNUT_CONDITION
Inherited
- Field Name: MAINTEN_REQ
Inherited
- Field Name: Type_Flushing
Inherited
- Field Name: Gauge_Option
Inherited
Templates:
Name: Green (1000-1499 GPM)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Flow_Painted: No
- BARREL_DIA: 5.25
- COLOR: RED
- Hose_Nozzle_Size: 2.5
- TYPE: FIRE RATED - HYDRANT
- HYDRANT_MARKER: Yes
- LOCATION_DESCRIPTION: By Road
- Flow_Capacity_Color: GREEN
- OWNER: Public
- VALVE: Yes
- LATERAL_SIZE: 6
- MAINTEN_REQ: No
ID: ORANGE
Name: Orange (500-999 GPM)
Domains:
- 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: Hose_Nozzle_Size
Inherited
- Field Name: LATERAL_SIZE
Inherited
- Field Name: MAIN_SIZE
Inherited
- Field Name: OPERNUT_CONDITION
Inherited
- Field Name: MAINTEN_REQ
Inherited
- Field Name: Type_Flushing
Inherited
- Field Name: Gauge_Option
Inherited
Templates:
Name: Orange (500-999 GPM)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Flow_Painted: No
- BARREL_DIA: 5.25
- COLOR: RED
- Hose_Nozzle_Size: 2.5
- TYPE: FIRE RATED - HYDRANT
- HYDRANT_MARKER: Yes
- LOCATION_DESCRIPTION: By Road
- Flow_Capacity_Color: ORANGE
- OWNER: Public
- VALVE: Yes
- LATERAL_SIZE: 6
- MAINTEN_REQ: No
ID: RED
Name: Red ( <500 GPM)
Domains:
- 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: Hose_Nozzle_Size
Inherited
- Field Name: LATERAL_SIZE
Inherited
- Field Name: MAIN_SIZE
Inherited
- Field Name: OPERNUT_CONDITION
Inherited
- Field Name: MAINTEN_REQ
Inherited
- Field Name: Type_Flushing
Inherited
- Field Name: Gauge_Option
Inherited
Templates:
Name: Red ( <500 GPM)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Flow_Painted: No
- BARREL_DIA: 5.25
- COLOR: RED
- Hose_Nozzle_Size: 2.5
- TYPE: FIRE RATED - HYDRANT
- HYDRANT_MARKER: Yes
- LOCATION_DESCRIPTION: By Road
- Flow_Capacity_Color: RED
- OWNER: Public
- VALVE: Yes
- LATERAL_SIZE: 6
- MAINTEN_REQ: No
ID: FLUSH
Name: Other (Blowoff / Flush / Post)
Domains:
- 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: Hose_Nozzle_Size
Inherited
- Field Name: LATERAL_SIZE
Inherited
- Field Name: MAIN_SIZE
Inherited
- Field Name: OPERNUT_CONDITION
Inherited
- Field Name: MAINTEN_REQ
Inherited
- Field Name: Type_Flushing
Inherited
- Field Name: Gauge_Option
Inherited
Templates:
Name: Other (Blowoff / Flush / Post)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Flow_Painted: No
- BARREL_DIA: 5.25
- COLOR: RED
- Hose_Nozzle_Size: 2.5
- TYPE: FIRE RATED - HYDRANT
- HYDRANT_MARKER: Yes
- LOCATION_DESCRIPTION: By Road
- Flow_Capacity_Color: FLUSH
- OWNER: Public
- VALVE: Yes
- LATERAL_SIZE: 6
- MAINTEN_REQ: No
ID: BLACK
Name: Black (Out of Service)
Domains:
- 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: Hose_Nozzle_Size
Inherited
- Field Name: LATERAL_SIZE
Inherited
- Field Name: MAIN_SIZE
Inherited
- Field Name: OPERNUT_CONDITION
Inherited
- Field Name: MAINTEN_REQ
Inherited
- Field Name: Type_Flushing
Inherited
- Field Name: Gauge_Option
Inherited
Templates:
Name: Black (Out of Service)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Flow_Painted: No
- BARREL_DIA: 5.25
- COLOR: RED
- Hose_Nozzle_Size: 2.5
- TYPE: FIRE RATED - HYDRANT
- HYDRANT_MARKER: Yes
- LOCATION_DESCRIPTION: By Road
- Flow_Capacity_Color: BLACK
- OWNER: Public
- VALVE: Yes
- LATERAL_SIZE: 6
- MAINTEN_REQ: No
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 12/12/2023 6:15:46 PM
Schema Last Edit Date: 8/22/2023 12:29:40 PM
Data Last Edit Date: 12/12/2023 6:15:46 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Attachments
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat