Water Hydrants Open Data

Dataset Summary About this data: The City of Rochester's award-winning water supply is primarily drawn from Canadice and Hemlock lakes; pristine Finger Lakes located approximately 28 miles south of the city and distributed along a system that includes reservoirs in the town of Rush and in the City's Highland and Cobbs Hill Parks. The City also purchases some water from the Monroe County Water Authority. This dataset includes a point for each of the 7990 hydrants in the city of Rochester and fields that describe some features about each. Data Dictionary: System Name: The system where the hydrant is located (Canadice, Domestic, Holly, Upland). Facility Identifier: The unique identifier for a given hydrant. Install Date: The date the hydrant was installed (if known). Hydrant Type: Notes if the hydrant is private or conventional. Flow Rate (GPM): Notes the hydrant’s flow rate (if known). NFPA Rating: The NFPA color code on the hydrant which indicates available flow rate. Address Number: The street number or description where the hydrant is located at. Street Name: The name of the street the hydrant is located at. Locked: Notes if the hydrant is locked (Yes/No). Location Description: More detailed instructions on where to find the hydrant. Rotation: Notes the rotation of the hydrant (if known). Manufacturer: The hydrant manufacturer. Model Year: The year the hydrant model was released. Operable: Denotes if the hydrant can be operated (Yes/No). Last Service Date: Last Service order data from the mainframe. Enabled: Unused field. Active Flag: Unused field. Status: Notes if the hydrant is currently in active. Field Book - Field Page 1: The page number in the field book where information on the hydrant is found. Field Book - Field Page 2: The page number in the field book where information on the hydrant is found. Field Book - Field Page 3: The page number in the field book where information on the hydrant is found. Owned By: The organization that owns the hydrant. Managed By: The organization that manages the hydrant. Comments 1: Location and first comment fields pushed in from mainframe. Comments 2: Location and second comment fields pushed in from mainframe. Comments 3: Location and third comment fields pushed in from mainframe. Comments 4: Location and fourth comment fields pushed in from mainframe. PilotTemp: Temporary field that notes the size, model, and year of the hydrant (if known). Field Book - Field Page Link 1: A link to where information on the hydrant is found in the field book. Field Book - Field Page Link 2: A link to where information on the hydrant is found in the field book. Field Book - Field Page Link 3: A link to where information on the hydrant is found in the field book. Comments 5: Location and fifth comment fields pushed in from mainframe. Map Status: GIS Status field (Active/Out of Service/Abandoned). Requires Inspection: Notes if the hydrant requires inspection (Yes/No). Photos and Files: Pictures and files related to the given hydrant. Source: This data comes from the Department of Environmental Services, Bureau of Water.