ZIP code 45247: Green Township and Cincinnati

Hamilton County · 23,293 residents · Cincinnati post office; 52% of residents live in the township of Green Township

Tap water here comes from 13 wells in the Great Miami Buried Valley Aquifer, treated at Charles M. Bolton Water Treatment Plant. The water here

Hamilton County

45247 in 10 facts

The 10 things that stand out about this ZIP against the other 1,232 in Ohio, each with its source.

  1. Where the water comes from Where the water here comes from: 13 wells in the Great Miami Buried Valley Aquifer along the Great Miami River near Fairfield, Butler Co.. Source: EPA SDWIS
  2. Local history 1809 The town here was settled around 1809, earlier than 53% of the Ohio ZIPs with a researched town. Source: Ohio History Connection
  3. Aquifer 100% This ZIP sits over a sensitive aquifer setting: 100% of the land is in an Ohio EPA sensitive geologic setting, more than 90% of Ohio ZIPs. Source: Ohio EPA geology layers
  4. Disasters 8 This ZIP has a lot of tornado history: 8 recorded with a track within 5 miles since 1950, more than 89% of Ohio ZIPs. Source: NOAA SPC tornado data
  5. Health 15.2% Self-reported health runs better here: 15.2% of adults report fair or poor health, lower than 90% of Ohio ZIPs. Source: CDC PLACES
  6. Social vulnerability 19 Social vulnerability runs low here: an average tract rank of 19 out of 100 on the CDC index, lower than 88% of Ohio ZIPs. Source: CDC/ATSDR SVI
  7. Groundwater 84 Groundwater here is less vulnerable than most: a DRASTIC index of 84, lower than 87% of Ohio ZIPs. Source: ODNR Geological Survey
  8. Dams 7 This ZIP has a lot of high-hazard dams nearby: 7 within 10 miles, more than 85% of Ohio ZIPs. Source: National Inventory of Dams
  9. Homes and income $288,400 Home values run high here: a median of $288,400, more than 86% of Ohio ZIPs. Source: Census ACS
  10. House by house 1983 The housing stock here is newer than most: a median year built of 1983, newer than 86% of Ohio ZIPs. Source: Hamilton County Auditor

Local events in 45247

15 events in the next 90 days from 1 public calendar. All local events in 45247

  1. Preschool Storytime

    10:15 to 10:45 a.m. · Monfort Heights Branch Library, Cincinnati · From Cincinnati & Hamilton County Public Library

  2. Library Babies

    11 to 11:30 a.m. · Monfort Heights Branch Library, Cincinnati · From Cincinnati & Hamilton County Public Library

  3. Preschool Storytime

    10:15 to 10:45 a.m. · Monfort Heights Branch Library, Cincinnati · From Cincinnati & Hamilton County Public Library

Checked October 20; the events page is refreshed daily.

Your ballot

Who represents 45247, and what is on its ballot for the November 3, 2026 general election.

Locator: Hamilton County and Hamilton's U.S. House, Ohio Senate and Ohio House districtsLocator: Hamilton County and Hamilton's U.S. House, Ohio Senate and Ohio House districts.Hamilton CountyU.S. House district 8: Warren Davidson (R)Ohio Senate district 8: not on the 2026 ballot; the sitting member is Louis W. Blessing III (R)Ohio House district 30: Mike Odioso (R)
Hamilton County and 45247's U.S. House, Ohio Senate and Ohio House districts.
45247's U.S. House, Ohio Senate and Ohio House districts
ChamberDistrictMemberParty
U.S. HouseDistrict 8——
Ohio SenateDistrict 8Louis W. Blessing IIIR
Ohio HouseDistrict 30 (52% of residents)Mike OdiosoR
Ohio HouseDistrict 29 (48% of residents)Cindy AbramsR

U.S. House districts were redrawn for 2026 (Ohio Redistricting Commission, October 31, 2025). The district shown is the one on the November 3, 2026 ballot, which may differ from the district of your current representative.

This ZIP code is split between districts. Your street address decides which one is on your ballot; your county board of elections' sample ballot shows it.

Statewide races:

45247's district races:

Local questions and issues on 45247's 2026 ballot
JurisdictionTypeQuestion
Hamilton CountyTax Levy (Renewal/Increase)Renews and increases a 5.61-mill property tax levy for the care & placement of children & children services of Hamilton County for 4 years, beginning in 2026.

Matched to this ZIP by jurisdiction name: Colerain Township, Colerain Township Township, Green Township, Green Township Township.

Last day of early in-person voting — 2026-11-01. Early in-person voting at county boards of elections ends on Sunday, November 1; the hours that day are 1 p.m. to 5 p.m. in the table above. By October 29, nearly 1.3 million Ohioans had already voted early in person or returned absentee ballots (Journal-News; Signal Ohio's counts from the Secretary of State's daily absentee file add to 1,289,090). The 2022 midterm saw 1.47 million early votes, then a record.

What's on my ballot in 45247 · Election 2026

Where does the tap water come from?

Where the tap water comes from and what is in it: the lake, river, reservoir or aquifer behind every tap, the plant that treats it, and what the compliance record and the lab results say about it.

Where the water comes from

Groundwater (wells)

13 wells in the Great Miami Buried Valley Aquifer along the Great Miami River near Fairfield, Butler Co.Charles M. Bolton Water Treatment Plant · Cincinnati Public Water System

Source: U.S. EPA SDWIS and Community Water System Service Area Boundaries (v3, 2026), Ohio EPA primacy data, 2020 census blocks: the system serving most residents, traced through purchases to the treating utility; Ohio EPA 2023 Sewer and Water… · EPA SDWIS · EPA service area boundaries · Ohio EPA drinking water · Ohio EPA rate survey

Elevation 483–950 ft, averaging 756 ft · Cincinnati 456–962 ft, averaging 666 · Hamilton County 454–1,069 ft (USGS 3DEP)

Great Miami Buried Valley Aquifer
Groundwater · via Cincinnati Public Water System
Drawn from: 13 wells in the Great Miami Buried Valley Aquifer along the Great Miami River near Fairfield, Butler Co.
Treated at Charles M. Bolton Water Treatment Plant, River Rd, Fairfield area, southern Butler County, OH 45014 (some directories list 6800 E. River Rd) · plant boundary estimated
Show everything served from this plant

Cincinnati Public Water System as a whole draws on: Ohio River (Miller Plant, ~88%) plus Great Miami Buried Valley Aquifer wells (~12%).

Cincinnati Public Water System is owned by a local government, with 244,716 service connections serving 750,200 people; it has substantially implemented source water protection under Ohio's program. Office: 513-591-7968 (SDWIS).

Bills, 2023: a household using 5,000 gallons a month paid about $378 a year for water ($32 a month; $239 at 2,500 gallons, $545 at 8,000) (Ohio EPA rate survey, inside-city rates).

Ohio EPA loans since 2016 for projects inside this ZIP: $4.4 million across 12 projects, $2.0 million of it forgiven (drinking water $2.4M, nonpoint runoff $2.0M); largest: Evelyn/Lincoln/Haubner/Farlook Water Main Replacement (Cincinnati, 2017, $2.4M); Hamilton County HSTS Repair/Replacement Project 2017 (Board of County Commissioners of Hamilto, 2017, $300K); Hamilton County HSTS Repair/Replacement Project 2016 (Board of County Commissioners of Hamilto, 2016, $300K).

Wells: EPA lists 13 active wells. ODNR well logs locate 1 public-supply well inside Cincinnati Public Water System's wellhead protection zone, 91 ft deep, in sand & gravel. Zoom in to see them as dots.
Well 1Well 2Well 3Well 4Well 5Well 6Well 7Well 8Well 9Well 10Well 11Well 12Well 13
Aquifer
Great Miami Buried Valley Aquifer
Water bodies
Ohio River
Raw intakes
Cincinnati Miller Ohio River
Cincinnati Miller Ohio River S
Active wells
13
Serves
750,200 people · Hamilton County
EPA ID
OH3102612

About this area's water

Entrance to the River Pumping Station at Cincinnati Water Works' Kellogg Avenue Ohio River intake
Entrance to the River Pumping Station at Cincinnati Water Works' Kellogg Avenue Ohio River intakePhoto: https://www.loc.gov/pictures/item/oh0105.photos.127321p, Public domain · Wikimedia Commons
Did you know
  • The Richard Miller plant is one of only a few in the country that pairs granular activated carbon with ultraviolet disinfection, and the GAC is regenerated on site in the plant's own reactivation furnace.
  • Cincinnati's 1839 purchase of a private water company for $300,000 made it Ohio's first municipally owned water system.
  • Rather than bury the problem in a storage tunnel, MSD dug up a mile of the long-buried Lick Run stream as green infrastructure, cutting about 400 million gallons of overflow a year.
  • The city's two plants could hardly be more different: Miller filters river water through carbon and UV, while Bolton simply softens well water with lime.
History5
  • 1821The Front Street Pumping Station begins operating for the private Cincinnati Manufacturing Company, chartered in 1817; it served until Nov. 1907.
  • 1839On June 25 the City of Cincinnati buys the water works for $300,000, becoming Ohio's first municipally owned water utility.
  • 1907On Oct. 22 the 'New Works' on Kellogg Ave., begun in 1898 about ten miles upstream, starts continuous rapid-sand filtration.
  • 2009MSD begins implementing its federal Clean Water Act wet weather program, one of the largest public works efforts in the region's history.
  • 2024PFOA and PFOS at the Bolton groundwater plant test above EPA's new 4 ppt limits, starting a compliance push ahead of the 2029 deadline.
Treatment & pressure

How it is treated

About 88% of supply is Ohio River water treated at the Richard Miller plant by coagulation, flocculation, sedimentation, rapid sand filtration, granular activated carbon, UV light and chlorine, with fluoride. The other 12% is Bolton well water, lime softened and chlorinated, with no GAC.

Water pressure

Not published as a system average. GCWW serves a hilly, multi-elevation area with numerous pressure districts, pump stations and storage tanks.

What it costs

GCWW publishes an annual 'Cost of Your Water' residential rate sheet; we found no per-1,000-gallon rate or effective year on its website.

Water quality & impurities7
ContaminantLevelLimitYear
TTHM
Range 14.0-60.3. Below MCL, no violation.
49.6 ppb802024
HAA5
Range 2.0-13.2. Far below MCL, helped by GAC treatment.
9.9 ppb602024
Lead (90th percentile)
Two monitoring periods; well below the action level, though 1 of 107 first-period samples exceeded it.
1.12-2.32 ppb152024
Copper (90th percentile)
No sites above the action level in either monitoring period.
0.019-0.024 ppm1.32024
PFOA
Bolton groundwater plant only; above the new EPA MCL. Miller plant stays below.
up to 4.7 ppt42024
PFOS
Bolton plant only; above the new EPA MCL, compliance required by 2029.
up to 6.1 ppt42024
Fluoride
Range 0.72-0.96; added for dental health, well under the MCL.
0.90 ppm42024

EPA compliance record

Lead at the tap: 90th-percentile result 2.1 ppb in 2026 (action level 15 ppb).

EPA record: no health-based violations since 2015.

Projects & plans3

Recent and current work

  • Lick Run Greenway · 2021 · completed
    Daylighted a buried stream in South Fairmount; eliminates roughly 400 million gal/yr of combined sewer overflow to Mill Creek.
  • MSD Wet Weather Program (consent decree) · 2009-present · under construction
    Has cut annual sewer overflow volume from about 14 billion to 5.9 billion gallons systemwide.

Planned or needed

  • Bolton plant PFAS treatment · planned
    GCWW has grant money to study treatment options and says it will install whatever is needed to meet the 2029 PFAS standards.
Supply stress

The Ohio River source is high-volume and drought-resilient, and the Miller plant's GAC gives it a strong barrier against spills and PFAS. The live concern is the Bolton groundwater plant, where PFOA and PFOS exceed the new federal limits for roughly 12% of GCWW customers ahead of the 2029 deadline.

Sewers

Sanitary

The Metropolitan Sewer District of Greater Cincinnati (MSD), a county-city partnership, provides sanitary sewers and wastewater treatment. MSD works under a federal Clean Water Act consent decree and has been implementing its wet weather program since 2009 to cut combined sewer overflows into Mill Creek and other waterways.

Storm

Much of the older urban core uses combined sanitary/storm sewers. MSD's wet weather plan mixes green infrastructure like the Lick Run Greenway with conventional separation and storage to reduce overflow-driven flooding.

Sourcesverified

Compiled from the utility's own reports and public records, then independently re-checked against primary sources.

Water systems in this ZIP

Source: U.S. EPA SDWIS and Community Water System Service Area Boundaries (v3, 2026), Ohio EPA primacy data, 2020 census blocks: the system serving most residents, traced through purchases to the treating utility; Ohio EPA 2023 Sewer and Water Rate Survey (Ohio State, May 2025) for household bills; Ohio EPA DEFA loan awards since 2016 for the loans paragraph · EPA SDWIS · EPA service area boundaries · Ohio EPA drinking water · Ohio EPA rate survey

Violationsnone since 2015, lead 2.1 ppbRadon3.1 pCi/L avg, 25% above 4Stream health86% of land drains to streams failing aquatic lifeNearest sewage plantTaylor Creek Wwtp, 3.2 mi, 10/12 quarters in violationGroundwaterDRASTIC 84, 80 well logsElectricDuke Energy OhioGas pipelinenearest transmission line 6.2 miNearest power plantMiami Fort 11.2 mi, 1,076 MW coalGasDuke Energy Ohio, 58% on gasSchool districtNorthwest LocalSocial vulnerability19th percentile in OhioUpward mobilityrank 46.6 for low-income childrenPeople39.9% with a degree, 3% born abroadJobs5K jobs hereSchool tax31.6 mills, ~$2,213 on a $200K homePhonealtafiberFlood0.1% in floodplainInternet100% served, fiber 95%Hazard risk35, above 35% of US tractsOil and gas wells2 in the ZIP, 0 producingSoilsUrban land, septic not ratedAbandoned minesnone mappedSpills8 reported since 2021, mostly diesel and fuel oilDisasters8 tornado tracks within 5 mi, 21 FEMA declarationsDams7 high-hazard within 10 mi, nearest 1.5 miTraffic79K a day on I-275Bridges1 of 45 rated poorRail crossingsnone; nearest 5.5 miTransit23% within half a mile of a stopWalkability7.6 of 20, below averageAirportCVG 11.2 mi, Amtrak 8.6 miClimate16" snow, 54°F averageAlgal toxinsraw water up to 0.46 µg/LPFASPFOA or PFOS up to 6.1 ng/L at the Charles M. Bolton Water Treatment PlantLead2.1 ppb at the 90th-percentile tap, 34,717 lead or galvanized lines, 45 unknownByproductsTTHM 39 µg/L (2019)Fluoridefluoridated, 8 treatment stepsWatershedLower Great Miami, Indiana, Ohio, Taylor CreekLocal governmentGreen TownshipCell signal5G on 99% of landU.S. HouseOH-8 Warren Davidson (R)Life expectancy80.1 yearsHealth15% fair or poor health, obesity 32%Nearest hospitalMercy Health - West Hospital, 2.8 mi, 4★Toxic sitesSuperfund 6.9 mi away, 0 TRIToxic releasesno TRI reporterAirPM2.5 9.5 µg/m³, monitor 6.7 miFire/EMSColerain Township Fire Department Station 103, 1.4 miLibraryMonfort Heights, 1.9 miGroceries57% over 1 mi from a supermarketEV chargersfast charger 1.6 mi, 2 stations hereHistoryincorporated 1809Historic placesnearest Old Gothic Barns, 2.9 miWetlands0.9% of land, 117 acresLand cover44% developed, 42% tree canopyParks2.2% public land, Hueston Woods State Park 24.4 miNursing homeLIBERTY NURSING CENTER OF COLERAIN INC, 1.6 mi, 1★PoliceGreen Township Police Department, 1.8 miCrime1.1 violent per 1,000, Green Township PoliceAquifer100% sensitive setting, karst, thin driftCollegeEmpire Beauty School-Cincinnati, 2.7 miSchool ratings4 stars, Northwest LocalHome prices$326K typical, +91% in ten yearsBuilding permits3,726 units 2016 to 2025 in Hamilton County building departmentHomes and income$288K home, $95K incomeHousesbuilt 1983, 8,808 homes

Infrastructure in this ZIP

6.62 mi of highway (I-74, I-275) · 3 transit routes (Cincinnati Metro (SORTA)) · 3.41 mi of oil, fuel or NGL pipeline (Sunoco (Energy Transfer)) · 0.03 mi of electric transmission line (Duke Energy) · 13.7 mi of large water mains mapped (Greater Cincinnati Water Works) · 9.79 mi of interceptor sewer mapped (MSD of Greater Cincinnati) · 1 airfield or heliport (Good Samaritan Medical Center) · 1 dam (Chateau Lakes No. 1 Dam) · 2 substations · 2 registered towers · 2 public EV charger listings · 1 pipeline incident since 2010 · 2 fire or EMS stations · 1 police station · 2 mapped lift stations, CSO structures or basins · 20 transit stops · 46 bridges and culverts in the inventory · 11 sites with underground fuel tanks in use · 3 open leaking-tank releases · 14 other permitted dischargers (5645-5647 Cheviot Rd Office Bldg, American Scaffolding Inc, Chateau Lakes Homeowners Assn) · 1 quarry or pit (East Miami Pit) · 2 stormwater (MS4) permit areas (Colerain Township, Green Township) · 1 brownfield or cleanup site · 1 tire or battery drop-off site · 2 mining permit areas (Richard and Kathy Burwinkel (permit IM-2333), East Miami Plant) · 2 traffic signals.

Draw them26 layers on the map

Intakes and plants

Groundwater (wells)

13 wells in the Great Miami Buried Valley Aquifer along the Great Miami River near Fairfield, Butler Co.Charles M. Bolton Water Treatment Plant · Cincinnati Public Water System

Source: U.S. EPA SDWIS and Community Water System Service Area Boundaries (v3, 2026), Ohio EPA primacy data, 2020 census blocks: the system serving most residents, traced through purchases to the treating utility; Ohio EPA 2023 Sewer and Water… · EPA SDWIS · Ohio EPA source water protection

Full detail

Loading the full detail… Or open it on the map.

Violations

No health-based violations since 2015

No health-based violations since 2015Cincinnati Public Water System · lead 2.1 ppb (2026)

Source: EPA SDWIS (Envirofacts, pulled September 2026): health-based violations since 2015, all violations since 2020, lead and copper 90th-percentile results, for the system serving most of the ZIP · EPA SDWIS (Envirofacts) · EPA ECHO

Full detail

Loading the full detail… Or open it on the map.

Disinfection byproducts

20 to 40

TTHM 39 µg/L (2019)Cincinnati Public Water System · HAA5 9 · worst year 40

Source: EPA Six-Year Review 4 compliance monitoring data, 2012 to 2019: total trihalomethanes and haloacetic acids (HAA5) sampled in the distribution system, nitrate, arsenic, combined radium, gross alpha and uranium at entry points; yearly means…

Full detail

Loading the full detail… Or open it on the map.

PFAS

PFOA or PFOS at 4 to 10 ng/L

PFOA or PFOS up to 6.1 ng/LCincinnati Public Water System · Charles M. Bolton Water Treatment Plant · UCMR 5, 7 samples · Ohio EPA 2020

Source: EPA UCMR 5 occurrence data (final release, August 2026: 29 PFAS and lithium at 347 Ohio systems) and Ohio EPA statewide PFAS sampling 2019 to 2021 (1,479 systems), for the system serving most of each ZIP; Ohio EPA water treatment plant… · Ohio EPA PFAS

Full detail

Loading the full detail… Or open it on the map.

Lead

Under 5 ppb

Lead 2.1 ppb at the 90th-percentile tapCincinnati Public Water System · period ending 2026-06 · 34,717 of 238,335 service lines lead or galvanized, 45 unknown

Source: SDWIS lead and copper 90th-percentile tap results (Envirofacts) and EPA's service line inventory dashboard (2026 Q2 submissions), for the system serving most of each ZIP; Ohio Department of Health high-risk ZIP code list for childhood… · ODH childhood lead testing · ODH high-risk ZIP list (CCBH PDF) · Ohio EPA lead and copper · H2Ohio

Full detail

Loading the full detail… Or open it on the map.

Fluoride and treatment

Fluoridated

FluoridatedCincinnati Public Water System · corrosion control, coagulation and settling, chlorine disinfection, iron and manganese removal

Source: CDC My Water's Fluoride (fluoridation status of each system as reported by the Ohio Department of Health, fetched 2026-09-10); SDWIS treatment table (Envirofacts): each system's registered treatment steps, inherited from the supplier for… · EPA SDWIS search

Full detail

Loading the full detail… Or open it on the map.

Algal toxins

Under 5 µg/L in raw water

Raw water up to 0.46 µg/L microcystinCincinnati Public Water System · 2019-10

Source: Ohio EPA public water system harmful algal bloom monitoring (geo.epa.ohio.gov DrinkingWater/HAB): microcystin results in raw and treated water since 2016 for surface-water systems, for the system serving most of each ZIP · Ohio EPA HAB information for public water systems

Full detail

Loading the full detail… Or open it on the map.

Groundwater

DRASTIC index under 100

DRASTIC 84 · Limestone and Shale80 well logs · median 48 ft deep · 135 karst and spring points

Source: ODNR Division of Geological Survey: DRASTIC groundwater vulnerability polygon at each ZIP's population center, mapped karst features, and the state water well log inventory (about 655,000 logs) counted inside each ZIP; ODNR glacial… · ODNR Geological Survey · Ohio EPA GIS services · USGS water data

Full detail

Loading the full detail… Or open it on the map.

Aquifer

85% or more

100% sensitive geologic settingkarst-prone bedrock, thin drift at the center · 73 verified sinkholes · under 0.5% wellhead protection

Source: Ohio EPA Sensitive Geologic Settings (geology/Geology layer 0) intersected with ZCTA polygons; ODNR karst geology at the ZIP center (layer 7, point query) and karst and spring points (layer 5); Ohio EPA source water protection areas… · Ohio EPA geology layers · Ohio EPA source water protection (SWAP) · ODNR Geological Survey

Full detail

Loading the full detail… Or open it on the map.

Sewage plants

8 to 11 quarters

Taylor Creek Wwtp · 3.2 mi10 of 12 quarters in violation · 5.5 MGD

Source: EPA ECHO Clean Water Act facilities, Ohio NPDES permits with a publicly owned treatment works component, plants of 0.1 MGD or more or designated major: nearest plant, design flow, significant-noncompliance status, quarters in… · EPA ECHO · EPA CSO inventory · Ohio EPA GIS services · EPA Facility Finder

Full detail

Loading the full detail… Or open it on the map.

Stream health

Three quarters or more

86% of the land drains to streams failing aquatic lifeTaylor Creek · unknown cause, other

Source: EPA ATTAINS, Ohio 2024 Integrated Report assessment units (1,545 watershed polygons) overlaid on ZCTAs in Albers equal-area with the Lake Erie units clipped out: share of land in units not supporting aquatic life, recreation, fish… · EPA ATTAINS · Ohio integrated report · Ohio sport fish advisory · Ohio EPA advisory map

Full detail

Loading the full detail… Or open it on the map.

Watershed

Drains to the Ohio River

Lower Great Miami, Indiana, Ohio subbasinTaylor Creek · drains to the Ohio River

Source: USGS Watershed Boundary Dataset: HUC-8 subbasins by resident share (2020 census blocks) and the HUC-12 subwatershed at each ZIP's population-weighted center with its downstream chain; USGS county water use 2015 (Dieter and others 2018) for… · USGS watershed boundaries · EPA EnviroAtlas · Ohio EPA 401 map · ODNR Water Withdrawal Atlas (archived copy) · USGS county water use 2015 · ODNR H2Ohio projects · ODNR Lake Erie Coastal Management Area · Ohio EPA source water protection (SWAP) · Ohio EPA nine-element plans · Ohio EPA 319, GLRI and SWIF project lists · Ohio EPA chloride reduction grants · NOAA Lake Erie water levels

Full detail

Loading the full detail… Or open it on the map.

Home

The houses themselves and what they cost: who lives in them, what a typical one looks like down to the parcel record, how much new housing has gone up, and what a household pays in property tax.

Homes and income

$250,000 to $350,000

Median home $288,400household income $94,603 · rent $1,107 · 79% own

Source: Census ACS 2020-2024 5-year by ZCTA: median home value, median gross rent, median household income, owner share, median year built; Eviction Lab tract estimates 2016 to 2018 (Gromis and others 2022), population-weighted to ZIPs; HUD fiscal… · Census ACS · Eviction Lab · HUD data · IRS ZIP statistics · Mapping Inequality · HUD eGIS open data · FDIC BankFind · NCUA call report data

Full detail

Loading the full detail… Or open it on the map.

House by house

1980 to 1999

Median year built 19838,808 homes · $255K median appraised

Source: Residential parcels (Ohio land-use classes 500 to 599, apartments 401 to 403, farmhouses) placed in ZIPs by scripts/join_parcels.py on 2026-09-15, the houses loading on demand; county auditors' appraisal records, house by house (year… · Hamilton County Auditor

Full detail

Loading the full detail… Or open it on the map.

Building permits

5 to 15

3,726 housing units permitted 2016 to 2025Hamilton County building department · 12.3 per 1,000 residents · 286 in 2025

Source: Census Bureau Building Permits Survey, annual place files 2016 to 2025: new privately owned housing units, buildings and construction value authorized by each Ohio permit office, given to each ZIP through the jurisdiction where most of its… · Census building permits

Full detail

Loading the full detail… Or open it on the map.

Home prices

75 to 100%

+91% in ten years+55% in five · +5% in 2025

Source: FHFA House Price Index, annual five-digit ZIP all-transactions series (repeat sales and refinance appraisals of conforming-mortgage homes, developmental, not seasonally adjusted): ten-, five- and one-year changes and the level against… · FHFA house price index · Zillow research data · Realtor.com data

Full detail

Loading the full detail… Or open it on the map.

School tax

30 to 40 mills

31.6 effective school millsNorthwest Local · about $2,213 a year on a $200,000 home

Source: Ohio Department of Taxation, Aggregate Property Tax Rates by School District, tax year 2025 (DTE 515), joined by IRN and weighted by each ZIP's residents in every district; school levies only; Ohio Department of Taxation The Finder rate… · Ohio tax data series · The Finder

Full detail

Loading the full detail… Or open it on the map.

Utilities and getting around

The companies and networks that keep a house running and a resident moving: electric, gas, phone and internet service, and the roads, transit, rail and airports around it.

Electric

Duke Energy Ohio

Duke Energy OhioInvestor-owned utility

Source: PUCO certified electric territories via ODOT plus HIFLD municipal systems (EIA-861) with ODOT corporate limits; EIA-861 reliability (outages), sales to ultimate customers (residential prices and bills), net metering and advanced meters by… · PUCO electricity · ODOT territories service · EIA-861 · DOE LEAD Tool · HIFLD retail service territories

Full detail

Loading the full detail… Or open it on the map.

Gas

Duke Energy Ohio

Duke Energy OhioPUCO-regulated utility · 58% of homes heat with utility gas

Source: PUCO 2026 county map of gas distribution companies, HIFLD/EIA-176 territory polygons, ACS 2020-2024 heating fuel · PUCO natural gas · HIFLD

Full detail

Loading the full detail… Or open it on the map.

Power plants

10 to 20 miles

Miami Fort · 11.2 micoal, 1,076 MW · 4 plants within 10 miles

Power plants within 10 miles

  1. Willey Battery UtilityBatteries · 6 MW · 6.0 mi
    Capacity
    6 MW
    Main source
    Batteries
    Technology
    Batteries
    Operator
    Willey Battery Utility, LLC
    Sector
    IPP Non-CHP
    Where
    Hamilton, Hamilton County
  2. Parking Lot ArraySolar · 4 MW · 8.1 mi
    Capacity
    4 MW
    Main source
    Solar
    Technology
    Solar Photovoltaic
    Operator
    Cincinnati Zoo & Botanical Garden
    Sector
    Commercial Non-CHP
    Where
    Cincinnati, Hamilton County
    Generating units
    2
    Built
    2011 (first unit); newest unit 2024
    EIA plant code
    63294
  3. Central Utility Plant CincinnatiNatural gas · 48 MW · 8.4 mi
    Capacity
    48 MW
    By fuel
    natural gas 46 MW, oil 2 MW
    Main source
    Natural gas
    Technology
    Natural Gas Fired Combined Cycle; Petroleum Liquids;
    Operator
    University of Cincinnati
    Sector
    Commercial CHP
    Where
    Cincinnati, Hamilton County
    Generating units
    4
    Built
    2004
    EIA plant code
    57908
  4. East Campus Utility PlantPetroleum · 6 MW · 8.5 mi
    Capacity
    6 MW
    Main source
    Petroleum
    Technology
    Petroleum Liquids
    Operator
    University of Cincinnati
    Sector
    Commercial Non-CHP
    Where
    Cincinnati, Hamilton County
    Generating units
    3
    Built
    2006 (first unit); newest unit 2022
    EIA plant code
    57929

Source: EIA-860 power plant inventory via HIFLD (February 2025), with plant codes, units and years from EIA-860 2025. Miles are straight-line from the ZIP's population-weighted center, as the card above measures them.

Source: EIA-860 power plant inventory via HIFLD (202 Ohio plants, February 2025): nearest plant, nearest plant of 100 MW or more, plants and capacity by fuel within 10 miles; USGS U.S. Wind Turbine Database (June 2026) and U.S. Large-Scale Solar… · EIA-860 · HIFLD · USGS wind turbines · USGS solar · NRC emergency planning zones

Full detail

Loading the full detail… Or open it on the map.

Pipelines

3 to 10 miles

Nearest transmission line 6.2 miTexas Gas Transmission Co (interstate)

Source: EIA natural gas interstate and intrastate transmission pipelines via Esri's Federal User Community copy on ArcGIS Online (data last updated July 2025; 1,239 segments in and around Ohio): miles inside each ZIP by operator, distance from the… · EIA U.S. Energy Atlas · ArcGIS Online item

Full detail

Loading the full detail… Or open it on the map.

Phone

altafiber (Cincinnati Bell)

altafiberIncumbent telephone company

Source: PUCO Telecom map service, layer 7 ILEC Company Service Area (incumbent local exchange carriers, fetched 2026-09-08) by resident share of 2020 census blocks · PUCO telephone

Full detail

Loading the full detail… Or open it on the map.

Internet

Under 2% lack 100/20 service

100% can get 100/20 Mbpsfiber 95% · cable 98% · 8,046 locations

Source: FCC Broadband Data Collection, June 2024, fixed availability by H3 hexagon (Esri Living Atlas, Ohio subset); Census ACS 2020-2024 table B28002 internet subscriptions; Ookla Open Data fixed speed tests 2025 Q2 by tile, averaged inside the… · FCC broadband map · Ookla open data · Census ACS

Full detail

Loading the full detail… Or open it on the map.

Cell signal

5G nearly everywhere

5G on 99% of the land4G or better 100% · AT&T 100% · T-Mobile 99% · Verizon 100%

Source: FCC Mobile Broadband Data Collection, carrier-reported 4G LTE and 5G coverage by H3 hexagon (Esri Living Atlas layer last updated 24 November 2025, most likely the June 30, 2025 filing round), fetched 2026-09-08; FCC Antenna Structure… · FCC broadband map · FCC antenna registration · Ookla open data

Full detail

Loading the full detail… Or open it on the map.

EV chargers

DC fast charger under 2 miles

Fast charger 1.6 mi: Meijer 223 (Cincinnati, OH)2 public stations in the ZIP (0 Level 2, 18 DC fast ports) · 15 within 5 miles of its center

Public EV charging inside ZIP 45247

  1. Meijer 223 (Cincinnati, OH) DC fast6 DC fast · Cincinnati · 1.6 mi
    Address
    6520 Harrison Ave, Cincinnati, OH 45247
    Ports
    6 DC fast
    Plugs
    CCS
    Network
    Electrify America
    Hours
    24 hours daily
    Phone
    833-632-2778
  2. Meijer - Tesla Supercharger DC fast12 DC fast · Cincinnati · 1.7 mi
    Address
    6550 Harrison Avenue, Cincinnati, OH 45247
    Ports
    12 DC fast
    Plugs
    Tesla (NACS)
    Network
    Tesla
    Hours
    24 hours daily. Please check Tesla's online station map to see if an adapter is required at this location.
    Phone
    877-798-3752

Source: NREL Alternative Fuels Data Center station list (May 2026), public and open stations, the posts at one address counted as one site. Miles are straight-line from the ZIP's population-weighted center.

Source: NREL Alternative Fuels Data Center station list as of May 29, 2026 (USDOT BTS copy: 2,136 Ohio electric stations, of which the 1,850 public and open are used, NREL restricted-access records such as dealer-service and hotel-guest chargers… · Alternative Fuels Data Center · BTS Alternative Fueling Stations (NTAD)

Full detail

Loading the full detail… Or open it on the map.

Transit

10 to 40%

23% within half a mile of a stop20 stops in the ZIP · Cincinnati Metro (SORTA)

None inside the ZIP; the nearest station or terminal

  1. Cincy StateTransit center or station · Cincinnati · 6.7 mi
    What it is
    Transit center or station
    City
    Cincinnati
    Coordinates
    39.15079, -84.53411

Source: BTS Intermodal Passenger Connectivity Database and National Transit Map (2025). Bus stops are counted on the card and drawn on the full map. Miles are straight-line from the ZIP's population-weighted center.

Source: USDOT BTS National Transit Map stops (National Transportation Atlas Database, 2025 vintage, fetched September 2026), plus the Springfield, Lancaster-Fairfield, Knox County Transit, WayGo and BGSU Shuttle GTFS feeds: share of residents… · BTS National Transit Map · BTS transportation atlas · Springfield City Area Transit GTFS feed · Lancaster-Fairfield Public Transit GTFS feed · Knox County Transit GTFS feed · WayGo GTFS feed · BGSU Shuttle GTFS feed

Full detail

Loading the full detail… Or open it on the map.

Walkability

Below average (5.76 to 10.5)

Walkability 7.6 of 2024 intersections per square mile · 20% near transit

Source: EPA National Walkability Index (Smart Location Database 3.0, 2021) by block group, population-weighted to ZIPs through 2020 census block points; car-free household share from Census ACS 2020 to 2024 table B25044, or where missing the Smart… · EPA walkability index · Smart Location Database · Census ACS

Full detail

Loading the full detail… Or open it on the map.

Rail crossings

No public rail crossing in the ZIP

0 public crossingsnearest crossing 5.5 mi (Indiana Eastern Railroad)

Source: FRA Grade Crossing Inventory (current records, Ohio): open at-grade crossings inside each ZIP, gates, trains a day at the busiest, timetable speed, railroads; nearest crossing to the population-weighted center; FRA highway-rail grade… · FRA crossing inventory (Form 71, current) · FRA crossing incidents (Form 57) · FRA rail equipment accidents (Form 54) · FRA safety data · DOT open data

Full detail

Loading the full detail… Or open it on the map.

Bridges

Under 5% of bridges poor

45 bridges, 1 rated poortypical build year 1969 · busiest Harrison Road, 33,151 vehicles a day

Bridges rated poor inside ZIP 45247

  1. Beerman Road over Brierly Creek BranchPoor · built 1910 · 0.8 mi
    Condition
    Poor: a deck, superstructure, substructure or culvert rated 4 or below on the 0 to 9 scale
    What it is
    Bridge
    Built
    1910
    Length
    10 ft
    Owner
    County
    Vehicles a day
    1,158
    Coordinates
    39.21607, -84.62358

Source: FHWA National Bridge Inventory 2025. "Poor" means one major part rated 4 or below on the 0 to 9 scale; it calls for repair, not closing, unless the state posts or closes the bridge. Miles are straight-line from the ZIP's population-weighted center.

Source: FHWA National Bridge Inventory 2025 (26,713 Ohio structures; 26,616 fall inside a ZIP area and are counted, the other 97 land outside every ZIP polygon): bridges inside each ZIP, poor-condition ratings, ages, traffic · FHWA bridge inventory · ODOT TIMS bridge inventory (live)

Full detail

Loading the full detail… Or open it on the map.

Traffic

50,000 to 100,000

78,918 vehicles a day on I-2759,944 trucks · 717K vehicle-miles a day inside the ZIP

Source: ODOT traffic count segments (2025 annual average daily traffic by road segment, ODOT Transportation Information Mapping System): segments assigned to the ZIP holding their midpoint; NHTSA Fatality Analysis Reporting System 2020 to 2024… · ODOT TIMS traffic count segments · NHTSA FARS

Full detail

Loading the full detail… Or open it on the map.

Airports and Amtrak

Airline airport under 15 miles

CVG · 11.2 miCincinnati / Northern Kentucky International · Amtrak at Cincinnati 8.6 mi

Source: FAA airport facilities (NASR landing-facility record) and Amtrak stations via USDOT BTS National Transportation Atlas Database, fetched September 2026: nearest airport with scheduled airline service (Part 139 class I), nearest public-use… · BTS transportation atlas

Full detail

Loading the full detail… Or open it on the map.

Land, air and risk

The ground itself and what can go wrong on it: radon, flood risk, air quality, old mines and wells, and the parks, wetlands and open land still left.

Radon

2 to 4 pCi/L

3.1 pCi/L average radon1,016 tests · 25% above 4 pCi/L · median 2.3

Source: Ohio Department of Health radon test results by ZIP code since 2010 (pre-mitigation), ZIPs with five or more tests · ODH radon program

Full detail

Loading the full detail… Or open it on the map.

Flood

Under 2% of residents

0.1% of residents in the 1% floodplain5% of the land is floodplain, 0% more in the 0.2% zone · zone AE

Source: FEMA National Flood Hazard Layer, flood hazard zones, fetched 2026-09-08; OpenFEMA NFIP redacted claims for Ohio (frozen June 2026), by reported ZIP; USGS NWIS annual peak flows for the nearest active stream gauge; NOAA Atlas 14… · FEMA flood hazard layer · FEMA Map Service Center · OpenFEMA · NOAA Atlas 14 · USGS stream gauges

Full detail

Loading the full detail… Or open it on the map.

Hazard risk

20 to 40

Risk score 35 · higher than about 35% of US tractsLandslide 88 · Tornado 79

Source: FEMA National Risk Index, census tracts, December 2025 release, population-weighted to ZIPs · FEMA National Risk Index · NRI census tract layer (ArcGIS)

Full detail

Loading the full detail… Or open it on the map.

Climate

Under 20 inches of snow a year

16" of snow a year · 53.8°F averageJanuary low 22° · July high 85° · 48" of precipitation

Source: NOAA NCEI 1991-2020 U.S. Climate Normals, annual and monthly, 261 Ohio stations; each ZIP takes the nearest station reporting each element from its population-weighted center; U.S. Drought Monitor weekly county statistics 2000 to 2026… · NOAA climate normals · NOAA climate at a glance · U.S. Drought Monitor

Full detail

Loading the full detail… Or open it on the map.

Air

9 to 10

PM2.5 9.5 µg/m³ at Cincinnati Near Road, 6.7 miozone 67 ppb at Colerain · Hamilton County median AQI 54

Source: EPA Air Quality System 2025 annual summaries: nearest PM2.5 and ozone monitors from each ZIP's population-weighted center, county AQI day counts; EPA ECHO Clean Air Act permitted sources in Ohio (air_rest_services, September 2026); EPA… · EPA air data files · EPA AirToxScreen · EPA Green Book · EPA ECHO

Full detail

Loading the full detail… Or open it on the map.

Toxic sites

3 to 8 miles

Nearest NPL site 6.9 mi: Feed Materials Production Center (USDOE)0 toxic-release reporters · 0 Superfund program sites in the ZIP

Source: EPA Facility Registry Service: Superfund NPL and SEMS sites, Toxics Release Inventory reporters (EPA geoplatform), fetched 2026-09-08; the nearest NPL site also considers sites in PA, WV, KY, IN and MI within about 20 miles of the border… · EPA Facility Registry · EPA Superfund sites · Ohio EPA cleanup sites · EPA UST Finder · EPA ECHO

Full detail

Loading the full detail… Or open it on the map.

Toxic releases

No data

No TRI-reporting facility

Source: EPA Toxics Release Inventory basic data files, Ohio, reporting years 2020 to 2024 (2024 shown, 2020 for the trend); facilities placed in the ZCTA holding their coordinates; dioxin rows reported in grams left out of pound totals · EPA TRI data files

Full detail

Loading the full detail… Or open it on the map.

Dams

6 to 10

7 high-hazard dams within 10 milesNearest: Chateau Lakes No. 1 Dam, 1.5 mi, condition fair

High-hazard dams within 10 miles

  1. Chateau Lakes No. 1 DamTributary To Taylor Creek · condition: fair · 1.5 mi
    Hazard class
    High: a failure would probably cost a life
    Condition
    Fair (assessed 06/03/2021)
    River or stream
    Tributary To Taylor Creek
    Purpose
    Recreation
    Type
    Earth
    Height
    68 ft
    Storage
    48 acre-feet
    Completed
    1975
    Owner type
    Private
    County
    Hamilton County
    Nearest town (NID)
    Taylors Creek
    Last inspection
    06/03/2021
    Emergency action plan
    Yes
    NID ID
    OH00936
  2. Aston Oaks Lake DamTributary To Ohio River · condition: fair · 5.9 mi
    Hazard class
    High: a failure would probably cost a life
    Condition
    Fair (assessed 05/06/2021)
    River or stream
    Tributary To Ohio River
    Purpose
    Flood Risk Reduction
    Type
    Earth
    Height
    66 ft
    Storage
    559 acre-feet
    Completed
    2000
    Owner type
    Private
    County
    Hamilton County
    Nearest town (NID)
    North Bend
    Last inspection
    05/06/2021
    Emergency action plan
    Yes
    NID ID
    OH03050
  3. Wright Farm West Detention Basin DamPleasant Run · condition: satisfactory · 7.3 mi
    Hazard class
    High: a failure would probably cost a life
    Condition
    Satisfactory (assessed 05/27/2021)
    River or stream
    Pleasant Run
    Purpose
    Flood Risk Reduction
    Type
    Earth
    Height
    26 ft
    Storage
    125 acre-feet
    Completed
    1996
    Owner type
    Local Government
    County
    Hamilton County
    Nearest town (NID)
    Pleasant Run
    Last inspection
    05/27/2021
    Emergency action plan
    Yes
    NID ID
    OH02907
  4. Ross Trails Lake DamTributary To Dry Run · condition: satisfactory · 7.8 mi
    Hazard class
    High: a failure would probably cost a life
    Condition
    Satisfactory (assessed 04/05/2022)
    River or stream
    Tributary To Dry Run
    Purpose
    Recreation
    Type
    Earth
    Height
    48 ft
    Storage
    141 acre-feet
    Completed
    1960
    Owner type
    Private
    County
    Butler County
    Nearest town (NID)
    Ross
    Last inspection
    06/22/2021
    Emergency action plan
    Yes
    NID ID
    OH00174
  5. West Fork of Mill Creek DamWest Fork of Mill Creek · condition: not available · 8.3 mi
    Hazard class
    High: a failure would probably cost a life
    Condition
    Not Available
    River or stream
    West Fork of Mill Creek
    Purpose
    Flood Risk Reduction;Recreation
    Type
    Earth
    Height
    106 ft
    Storage
    11,380 acre-feet
    Completed
    1952
    Owner type
    Federal
    County
    Hamilton County
    Nearest town (NID)
    Woodland
    Last inspection
    05/15/2025
    Emergency action plan
    Yes
    NID ID
    OH00029
  6. Fairfield Detention "C" DamTributary To Pleasant Run · condition: satisfactory · 9.2 mi
    Hazard class
    High: a failure would probably cost a life
    Condition
    Satisfactory (assessed 05/04/2021)
    River or stream
    Tributary To Pleasant Run
    Purpose
    Flood Risk Reduction
    Type
    Earth
    Height
    31 ft
    Storage
    490 acre-feet
    Completed
    1998
    Owner type
    Local Government
    County
    Butler County
    Nearest town (NID)
    Fairfield
    Last inspection
    05/04/2021
    Emergency action plan
    Yes
    NID ID
    OH02920
  7. Fairfield Detention "A" DamTributary To Pleasant Run · condition: satisfactory · 9.9 mi
    Hazard class
    High: a failure would probably cost a life
    Condition
    Satisfactory (assessed 05/04/2021)
    River or stream
    Tributary To Pleasant Run
    Purpose
    Flood Risk Reduction
    Type
    Earth
    Height
    24 ft
    Storage
    170 acre-feet
    Completed
    1997
    Owner type
    Local Government
    County
    Butler County
    Nearest town (NID)
    Fairfield
    Last inspection
    05/04/2021
    Emergency action plan
    Yes
    NID ID
    OH02911
  8. Lincoln Heights Upground ReservoirOffstream · condition: fair · 10.0 mi
    Hazard class
    High: a failure would probably cost a life
    Condition
    Fair (assessed 06/10/2021)
    River or stream
    Offstream
    Purpose
    Water Supply
    Type
    Earth
    Height
    30 ft
    Storage
    70 acre-feet
    Completed
    1942
    Owner type
    Public Utility
    County
    Hamilton County
    Nearest town (NID)
    Lincoln Heights
    Last inspection
    06/10/2021
    Emergency action plan
    Yes
    NID ID
    OH01703

Source: U.S. Army Corps of Engineers National Inventory of Dams, August 2026. "High hazard" rates what a failure would cost downstream, not how likely one is; the condition is the state's assessment. Miles are straight-line from the ZIP's population-weighted center, as the card above measures them.

Source: U.S. Army Corps of Engineers National Inventory of Dams (1,376 Ohio dams, August 2026; 26 Corps levees and dikes counted with their parent dam): high-hazard dams near each ZIP's population-weighted center, with the state's condition… · National Inventory of Dams

Full detail

Loading the full detail… Or open it on the map.

Disasters

6 to 10

8 tornado tracks within 5 miles since 19503 rated F2/EF2+ · 21 federal declarations for Hamilton County · 0 quakes M2+ within 25 mi

Source: NOAA Storm Prediction Center tornado database 1950-2025 (tracks within 5 miles of each ZIP's population-weighted center), OpenFEMA disaster declarations by county since 1956, USGS earthquake catalog M2+ since 1970 within 25 miles… · NOAA SPC tornado data · OpenFEMA · USGS earthquakes · NOAA storm events · IEM warning archive

Full detail

Loading the full detail… Or open it on the map.

Spills

5 to 14

8 spills reported since 2021mostly diesel and fuel oil · 1 reached water

Spills reported since 2021 inside ZIP 45247

  1. Fuel Diesel / Diesel Fuel (Vehicle On Or Off Road)2024-05-07 · Colerain Twp · 1.6 mi
    Reported
    2024-05-07
    What spilled
    Fuel Diesel / Diesel Fuel (Vehicle On Or Off Road)
    Largest amount reported
    25 gallons
    Where
    Colerain Twp, Hamilton County
    Ohio EPA district office
    SWDO
    Ohio EPA case number
    2405EPA0000764
  2. Fuel Diesel / Diesel Fuel (Vehicle On Or Off Road)2022-05-09 · Green Twp · 1.7 mi
    Reported
    2022-05-09
    What spilled
    Fuel Diesel / Diesel Fuel (Vehicle On Or Off Road)
    Largest amount reported
    30 gallons
    Where
    Green Twp, Hamilton County
    Ohio EPA district office
    SWDO
    Ohio EPA case number
    2205EPA0000657
  3. Ink / Printing Ink2022-04-08 · Green Twp · 1.8 mi
    Reported
    2022-04-08
    What spilled
    Ink / Printing Ink
    Largest amount reported
    500 gallons
    Where
    Green Twp, Hamilton County
    Ohio EPA district office
    SWDO
    Ohio EPA case number
    2204EPA0000485
  4. Fuel Diesel / Diesel Fuel (Vehicle On Or Off Road)2021-12-16 · Colerain Twp · 1.9 mi
    Reported
    2021-12-16
    What spilled
    Fuel Diesel / Diesel Fuel (Vehicle On Or Off Road)
    Largest amount reported
    100 gallons
    Where
    Colerain Twp, Hamilton County
    Ohio EPA district office
    SWDO
    Ohio EPA case number
    2112EPA0001868
  5. Fuel Gasoline ( 25% Ethanol Not E85)2026-03-27 · Colerain Twp · 1.9 mi
    Reported
    2026-03-27
    What spilled
    Fuel Gasoline ( 25% Ethanol Not E85)
    Where
    Colerain Twp, Hamilton County
    Ohio EPA district office
    SWDO
    Ohio EPA case number
    2603EPA0000507
  6. Asphalt / Bitumen Reached water2022-12-13 · Colerain Twp · 2.3 mi
    Reported
    2022-12-13
    What spilled
    Asphalt / Bitumen
    Reached a waterway
    Taylor Creek
    Where
    Colerain Twp, Hamilton County
    Ohio EPA district office
    SWDO
    Ohio EPA case number
    2212EPA0001850
  7. Oil Hydraulic Fluid(S)2025-01-15 · Colerain Twp · 2.4 mi
    Reported
    2025-01-15
    What spilled
    Oil Hydraulic Fluid(S)
    Largest amount reported
    50 gallons
    Where
    Colerain Twp, Hamilton County
    Ohio EPA district office
    SWDO
    Ohio EPA case number
    2501EPA0000052
  8. Fuel Diesel / Diesel Fuel (Vehicle On Or Off Road)2021-04-14 · Colerain Twp · 3.7 mi
    Reported
    2021-04-14
    What spilled
    Fuel Diesel / Diesel Fuel (Vehicle On Or Off Road)
    Where
    Colerain Twp, Hamilton County
    Ohio EPA district office
    SWDO
    Ohio EPA case number
    2104EPA0000523

Source: Ohio EPA emergency response spill reports, 2021 to September 2026, one point per case where Ohio EPA placed it. A report is what the caller or responder recorded; amounts are often blank or estimated. Miles are straight-line from the ZIP's population-weighted center.

Source: Ohio EPA emergency response spill reports (geo.epa.ohio.gov EmergResponse/Spills2_OpenData): cases with a location inside each ZIP, 2021 to date · Ohio EPA spills data · Ohio EPA Office of Emergency Response

Full detail

Loading the full detail… Or open it on the map.

Oil and gas wells

1 to 10 wells

2 wells in the ZIP0 producing · 0 shale · 0 orphan · nearest 2.05 mi

Source: ODNR Division of Oil and Gas Resources public well inventory (242,324 well heads, fetched 2026-09-08): wells inside each ZIP by status, horizontal shale wells, injection wells, orphan-program wells · ODNR oil and gas · ODNR GIS services

Full detail

Loading the full detail… Or open it on the map.

Abandoned mines

No mapped underground mine

No mapped minenearest mapped non-coal mine 45.2 mi

Source: ODNR Mines of Ohio: abandoned underground coal and industrial-mineral mines mapped before 1977 (5,116 polygons), overlaid on ZCTAs in Albers equal-area: share of each ZCTA's total area (land plus inland water) over a mapped mine; ODNR… · ODNR mines of Ohio · ODNR Geological Survey

Full detail

Loading the full detail… Or open it on the map.

Soils

No data

Urban land-Alfic Udarents-Ava complex, 0 to 12 percent slopesseptic not rated

Source: USDA NRCS SSURGO via Soil Data Access: the soil map unit under each ZIP's population-weighted center with its dominant component, drainage, hydric and farmland class, flooding, and the Ohio septic and basement interpretation ratings… · USDA Soil Data Access · Web Soil Survey · Open-Meteo elevation

Full detail

Loading the full detail… Or open it on the map.

Parks

2 to 5%

2.2% public land · 296 acresOak Glen Expansion Acquisition - Phase I · Hueston Woods State Park 24.4 mi

Source: USGS Protected Areas Database 4.1 (Ohio state package, flattened combined layer, open-access fee, designation and easement polygons plus the six ODNR state parks PAD-US codes closed by default: Buckeye Lake, Forked Run, Hueston Woods, Lake… · USGS PAD-US · ODNR GIS services

Full detail

Loading the full detail… Or open it on the map.

Wetlands

Under 1% of the land

0.9% wetland · 117 acrespond 84 · forested/shrub wetland 33

Source: USFWS National Wetlands Inventory, Ohio geodatabase (imagery mostly 2004 to 2007, Lake Erie basin 2021), freshwater wetlands and ponds clipped to each ZIP (lakes and rivers excluded); Ohio EPA potential high-quality vernal pools… · USFWS wetlands inventory · Ohio EPA GIS services

Full detail

Loading the full detail… Or open it on the map.

Land cover

40% to 75%

44% developed · 42% tree canopyforest 46% · pasture 7% · water 1%

Source: National Land Cover Database, 2021 edition (USGS and the MRLC consortium; MRLC has since published Annual NLCD and annual tree canopy through 2025, not yet pulled here): land cover, percent impervious surface and tree canopy at 30 m… · NLCD · USDA Cropland Data Layer · ODNR pre-settlement vegetation

Full detail

Loading the full detail… Or open it on the map.

People and health

Who lives here and how well: education, jobs, health and life expectancy, and how far the nearest hospital, police station or grocery store sits.

People

25 to 40%

39.9% bachelor's or higher85.1% white · 7.9% Black · 1.4% Hispanic · 0.9% Asian · 3% foreign-born

Source: Census ACS 2020-2024 5-year by ZCTA: educational attainment (B15003), race and Hispanic origin (B03002), nativity (B05002), veterans (B21001); IRS Statistics of Income county migration flows 2022 to 2023 for the county; Census Bureau… · Census ACS · Census population estimates · IRS migration data · USDA ERS county codes · USDA ERS commuting area codes · 2020 Census redistricting data · Census SAIPE · IRS exempt organizations

Full detail

Loading the full detail… Or open it on the map.

Jobs

0.25 to 0.6

5,449 jobs · 11,838 employed residentsHotels and restaurants leads

Source: Census LEHD LODES 8, 2023, all jobs: workplace and residence counts by census block summed into ZCTAs (workplace-only blocks by block-group or tract majority), origin-destination flows for where residents work; Census ZIP Code Business… · Census LEHD · BLS local unemployment · BLS QCEW · BEA county GDP · USAspending · OSHA enforcement data · Census ZIP Business Patterns · Census ACS · USDA ERS county typology · CDFI Fund Opportunity Zones

Full detail

Loading the full detail… Or open it on the map.

Economic history

Groundwater (wells)

13 wells in the Great Miami Buried Valley Aquifer along the Great Miami River near Fairfield, Butler Co.Charles M. Bolton Water Treatment Plant · Cincinnati Public Water System

Source: Historical economic data: Census Bureau historical county population via the NBER mirror (1900) and Census Bureau population estimates (current and peak), Census County Business Patterns, USDA Census of Agriculture, FHFA House Price Index… · FRED (Federal Reserve Bank of St. Louis) · Census County Business Patterns · USDA Census of Agriculture · FHFA House Price Index · BEA GDP by county · Census American Community Survey · IPUMS NHGIS historical census · Zillow Home Value Index

Full detail

Loading the full detail… Or open it on the map.

Upward mobility

45th to 50th

Percentile rank 46.6income rank at 35 for children of low-income parents · 1.87% incarcerated in 2010

Source: Opportunity Atlas (Chetty, Friedman, Hendren, Jones and Porter, Census Bureau): tract outcomes for children born 1978 to 1983, population-weighted to ZIPs through 2020 census blocks · Opportunity Atlas · Opportunity Insights data

Full detail

Loading the full detail… Or open it on the map.

Social vulnerability

Average tract rank in Ohio's least vulnerable fifth

19th percentile of Ohio tractssocioeconomic 13 · household 41 · minority status 31 · housing and transport 31

Source: CDC/ATSDR Social Vulnerability Index 2022 by census tract (percentile ranks among Ohio tracts), population-weighted to ZIPs through 2020 census blocks · CDC/ATSDR SVI

Full detail

Loading the full detail… Or open it on the map.

Health

12 to 16%

15.2% in fair or poor healthobesity 31.6% · diabetes 12.1% · smoking 11.8% · depression 25.3%

Source: CDC PLACES 2025 release, ZCTA model-based estimates of adult health (BRFSS 2023, ACS): fair or poor health, obesity, diabetes, smoking, depression, lack of health insurance among adults 18-64 and more; County Health Rankings 2025… · CDC PLACES · County Health Rankings · CDC overdose data · NCI cancer profiles · HRSA data

Full detail

Loading the full detail… Or open it on the map.

Life expectancy

79 to 82

80.1 years life expectancy10 tracts, from 76.6 to 82.3

Source: CDC/NCHS U.S. Small-area Life Expectancy Estimates Project (USALEEP, deaths 2010-2015, 2010 census tracts) weighted into ZIPs by 2020 block population · CDC USALEEP

Full detail

Loading the full detail… Or open it on the map.

Hospitals

Under 3 miles

Mercy Health - West Hospital · 2.8 miCincinnati · 565 beds · 5 within 10 miles

Hospitals within 5 miles

  1. Mercy Health - West HospitalGeneral hospital · Cincinnati · 2.8 mi
    What it is
    General hospital
    Address
    3300 Mercy Health Boulevard, Cincinnati, OH 45211
    County
    Hamilton County
    Beds
    565
    Helipad
    Yes
    Ownership
    Non-profit
    Medicare overall rating
    4 of 5 stars
    Emergency department (Medicare)
    Yes
    Phone
    (513) 215-5000
    Medicare ID
    360234
  2. Glenwood Behavioral Health HospitalPsychiatric hospital · Cincinnati · 3.4 mi
    What it is
    Psychiatric hospital
    Address
    2446 Kipling Avenue, Cincinnati, OH 45239
    County
    Hamilton County
    Beds
    80
    Ownership
    Proprietary
    Medicare overall rating
    not rated
    Emergency department (Medicare)
    No
    Phone
    (513) 866-2220
    Medicare ID
    364065
  3. Children's Hosp Mc - College HillPsychiatric hospital · Cincinnati · 5.0 mi
    What it is
    Psychiatric hospital
    Address
    5642 Hamilton Avenue, Cincinnati, OH 45224
    County
    Hamilton County
    Beds
    94
    Ownership
    Non-profit
    Phone
    (513) 803-0505

Source: HIFLD hospitals inventory via FEMA (closed hospitals it still lists left out, hospitals opened since added), with Medicare Care Compare ratings matched by name and address. Miles are straight-line from the ZIP's population-weighted center, as the card above measures them.

The nearest health centers

  1. Mt. Healthy Family Practice CenterHealth center · Cincinnati · 5.4 mi
    Run by
    a federally qualified health center
    Setting
    Clinic
    City
    Cincinnati
    Coordinates
    39.23094, -84.53923
  2. Crossroad Heath Center WestHealth center · Cincinnati · 5.6 mi
    Run by
    a federally qualified health center
    Setting
    Clinic
    City
    Cincinnati
    Coordinates
    39.12947, -84.61362

Source: HRSA health center service delivery sites, active, September 2026 (school-based sites left out). Health centers see patients whether or not they have insurance, with fees on a sliding scale. Miles are straight-line from the ZIP's population-weighted center, as the card above measures them.

Dialysis centers within 5 miles

  1. Davita Western Ridge DialysisDialysis · Cincinnati · 2.1 mi
    Address
    6909 Good Samaritan Dr. Suite C, Cincinnati, OH 45247
    Dialysis stations
    15
    Medicare star rating
    4 of 5 stars
    Services
    in-center hemodialysis
    Ownership
    for profit
    Chain
    DaVita
    Medicare certified since
    2016-11-22
    Phone
    (513) 353-0237
    Medicare ID
    362849
  2. Davita White Oak Home Training DialysisDialysis · Cincinnati · 2.2 mi
    Address
    5520 Cheviot Road, Suite B, Cincinnati, OH 45247
    Dialysis stations
    4
    Medicare star rating
    3 of 5 stars
    Services
    peritoneal dialysis, home hemodialysis training
    Ownership
    for profit
    Chain
    DaVita
    Medicare certified since
    2006-08-17
    Phone
    (513) 385-3580
    Medicare ID
    362687
  3. Davita White Oak DialysisDialysis · Cincinnati · 2.2 mi
    Address
    5520 Cheviot Road, Suite B, Cincinnati, OH 45247
    Dialysis stations
    20
    Medicare star rating
    2 of 5 stars
    Services
    in-center hemodialysis
    Ownership
    for profit
    Chain
    DaVita
    Medicare certified since
    2006-08-17
    Phone
    (513) 741-1062
    Medicare ID
    362688
  4. Dci - Western HillsDialysis · Cincinnati · 4.0 mi
    Address
    6432 Glenway Avenue, Cincinnati, OH 45211
    Dialysis stations
    13
    Medicare star rating
    1 of 5 stars
    Services
    in-center hemodialysis
    Ownership
    nonprofit
    Chain
    Dialysis Clinic, Inc.
    Medicare certified since
    2000-02-19
    Phone
    (513) 598-9050
    Medicare ID
    362621
  5. Davita Winton Road DialysisDialysis · Cincinnati · 4.3 mi
    Address
    3267 Westbourne, Cincinnati, OH 45248
    Dialysis stations
    24
    Medicare star rating
    2 of 5 stars
    Services
    in-center hemodialysis
    Shift starting after 5 pm
    Yes
    Ownership
    for profit
    Chain
    DaVita
    Medicare certified since
    1999-03-10
    Phone
    (513) 591-2900
    Medicare ID
    362611
  6. Davita Western Hills DialysisDialysis · Cincinnati · 4.3 mi
    Address
    3267 Westbourne Ave., Cincinnati, OH 45248
    Dialysis stations
    16
    Medicare star rating
    3 of 5 stars
    Services
    in-center hemodialysis
    Ownership
    for profit
    Chain
    DaVita
    Medicare certified since
    2000-09-13
    Phone
    (513) 347-0444
    Medicare ID
    362628
  7. Fmc Liberty Dialysis North College HillDialysis · Cincinnati · 4.7 mi
    Address
    1555 Goodman Avenue, Cincinnati, OH 45224
    Dialysis stations
    17
    Medicare star rating
    1 of 5 stars
    Services
    in-center hemodialysis, home hemodialysis training
    Ownership
    for profit
    Chain
    Fresenius Medical Care
    Medicare certified since
    2016-10-04
    Phone
    (513) 521-2018
    Medicare ID
    362845
  8. Davita College Hill DialysisDialysis · Cincinnati · 4.7 mi
    Address
    1550 Goodman Avenue, Cincinnati, OH 45224
    Dialysis stations
    17
    Medicare star rating
    2 of 5 stars
    Services
    in-center hemodialysis, peritoneal dialysis, home hemodialysis training
    Ownership
    for profit
    Chain
    DaVita
    Medicare certified since
    2021-06-17
    Phone
    (513) 538-3768
    Medicare ID
    362898

Source: CMS dialysis facility list, September 2026, geocoded with the Census Bureau batch geocoder (an address it could not place sits at its ZIP center). Miles are straight-line from the ZIP's population-weighted center, as the card above measures them.

Source: Nearest hospital: miles from each ZIP's population-weighted center to the nearest open general or critical-access hospital in Ohio, or, within 40 miles of the state line in Indiana, Kentucky, West Virginia, Pennsylvania and Michigan, the… · CMS Care Compare data · HIFLD · HRSA data · CMS NPI files

Full detail

Loading the full detail… Or open it on the map.

Nursing homes

1 to 3 miles

LIBERTY NURSING CENTER OF COLERAIN INC · 1.6 mi1 of 5 stars · 93 beds · 10 within 5 miles

Nursing homes within 3 miles, and the nearest beyond

  1. Liberty Nursing Center of Colerain Inc1 of 5 stars · Cincinnati · 1.6 mi
    Address
    8440 Livingston Road, Cincinnati, OH 45247
    Certified beds
    93
    Residents on an average day
    57
    Medicare overall rating
    1 of 5 stars
    Health inspections
    2 of 5 stars
    Staffing
    1 of 5 stars
    Quality measures
    2 of 5 stars
    Penalties since 2023
    none
    Ownership
    For profit - Corporation
    Takes
    Medicare and Medicaid
    Phone
    (513) 245-2100
    Medicare ID
    366427
  2. Covenant Village Care Center3 of 5 stars · Cincinnati · 2.8 mi
    Address
    3210 West Fork Road, Cincinnati, OH 45211
    Certified beds
    107
    Residents on an average day
    99
    Medicare overall rating
    3 of 5 stars
    Health inspections
    3 of 5 stars
    Staffing
    3 of 5 stars
    Quality measures
    4 of 5 stars
    Penalties since 2023
    none
    Ownership
    For profit - Corporation
    Takes
    Medicare and Medicaid
    Phone
    (513) 605-3000
    Medicare ID
    366399
  3. Lakeridge Villa Health Care Center1 of 5 stars · Cincinnati · 3.3 mi
    Address
    7220 Pippin Rd, Cincinnati, OH 45239
    Certified beds
    99
    Residents on an average day
    86
    Medicare overall rating
    1 of 5 stars
    Health inspections
    2 of 5 stars
    Staffing
    1 of 5 stars
    Quality measures
    4 of 5 stars
    Penalties since 2023
    none
    Ownership
    For profit - Limited Liability company
    Chain
    CARECORE HEALTH
    Takes
    Medicare and Medicaid
    Phone
    (513) 729-2300
    Medicare ID
    366145

Source: CMS Care Compare nursing home provider and penalties files; Medicare star ratings run 1 to 5. Miles are straight-line from the ZIP's population-weighted center, as the card above measures them.

Source: CMS Care Compare nursing home provider file (922 Ohio homes), addresses geocoded with the Census Bureau batch geocoder (67 unmatched placed at their ZIP center); CMS penalties file (fines and payment denials since 2023, matched by name and… · CMS Care Compare data

Full detail

Loading the full detail… Or open it on the map.

Crime

1 to 2.5

1.1 violent offenses per 1,000Green Township Police · 12.2 property per 1,000 · 12 months · 59% of violent cleared

Source: FBI Crime Data Explorer NIBRS incident files for Ohio, 2024 (2023 file for the trend), as downloaded in September 2026; the FBI keeps accepting agency revisions after release, so an agency's live Explorer totals for the same year can… · FBI Crime Data Explorer · USGS structures service

Full detail

Loading the full detail… Or open it on the map.

Police

1 to 2 miles

Green Township Police Department · 1.8 mi2 stations within 3 miles · post office 2.7 mi

Police stations within 3 miles

  1. Green Township Police DepartmentCincinnati · 1.8 mi
    Address
    6200 Harrison Avenue, Cincinnati, OH 45247
    Coordinates
    39.18491, -84.65052
  2. Colerain Police DepartmentColerain Township · 2.9 mi
    Address
    4200 Springdale Road, Colerain Township, OH 45251
    Coordinates
    39.24543, -84.61015

Source: USGS National Map structures, police stations, corrected and completed by hand (September 2026). The department that answers a call is set by jurisdiction, not by distance. Miles are straight-line from the ZIP's population-weighted center, as the card above measures them.

Source: USGS National Map structures: police stations (772 Ohio points: the inventory's 731 less 4 closed or duplicate records, with 4 wrong names corrected, plus 45 departments and sheriff's offices it lacks, placed from OpenStreetMap or the… · USGS structures service · OpenStreetMap · Census Bureau geocoder

Full detail

Loading the full detail… Or open it on the map.

Fire and EMS

1 to 2 miles

Colerain Township Fire Department Station 103 · 1.4 mi3 stations within 3 miles, 35 within 8

Fire and EMS stations within 3 miles

  1. Colerain Township Fire Department Station 103Cincinnati · 1.4 mi
    Address
    6000 Thompson Road, Cincinnati, OH 45247
    Coordinates
    39.22710, -84.64248
  2. Green Township Fire and EMS Department Station 53Cincinnati · 1.8 mi
    Address
    6303 Harrison Avenue, Cincinnati, OH 45247
    Coordinates
    39.18621, -84.65379
  3. Green Township Fire Department and Emergency Medical Service Station 55Cincinnati · 2.2 mi
    Address
    5410 Audro Drive, Cincinnati, OH 45247
    Coordinates
    39.18891, -84.60300

Source: USGS National Map structures (most Ohio records last updated 2019 to 2022), checked against the Columbus and Cleveland station lists. The department that answers a call is set by jurisdiction and mutual aid, not by distance. Miles are straight-line from the ZIP's population-weighted center, as the card above measures them.

Source: USGS National Map structures inventory (fire and EMS stations; most Ohio records last updated 2019 to 2022): 1,772 Ohio stations after removing duplicate records and checking Columbus- and Cleveland-area stations against the cities'… · USGS structures service · Columbus fire stations · Cleveland fire stations

Full detail

Loading the full detail… Or open it on the map.

Libraries

1 to 2 miles

Monfort Heights · 1.9 miCincinnati and Hamilton County Public Library · 2 within 3 miles, 16 within 8

Public libraries within 3 miles

  1. Monfort HeightsBranch · Cincinnati · 1.9 mi
    Address
    3825 West Fork Rd., Cincinnati, OH 45247
    What it is
    Branch
    Library system
    Cincinnati and Hamilton County Public Library
    Open
    3,016 hours a year, 52 weeks
    Building
    9,525 sq ft
    System's visits, FY2024
    4,091,256
    System's loans, FY2024
    20,126,186
    People the system serves
    830,639
    Phone
    (513) 369-4472
  2. GroesbeckBranch · Cincinnati · 2.9 mi
    Address
    2994 W Galbraith Rd, Cincinnati, OH 45239
    What it is
    Branch
    Library system
    Cincinnati and Hamilton County Public Library
    Open
    3,120 hours a year, 52 weeks
    Building
    15,000 sq ft
    System's visits, FY2024
    4,091,256
    System's loans, FY2024
    20,126,186
    People the system serves
    830,639
    Phone
    (513) 369-4454

Source: IMLS Public Libraries Survey FY2024 (outlets and their systems). Any Ohio resident can get a free card at any Ohio public library. Miles are straight-line from the ZIP's population-weighted center, as the card above measures them.

None inside the ZIP; the nearest museum

  1. Coleraine Historical SocietyHistorical society · Colerain Township · 2.5 mi
    What it is
    Historical society
    City
    Colerain Township
    Coordinates
    39.24036, -84.61439

    The museum list is IMLS's 2018 file; a museum may have closed or moved since.

Source: IMLS Museum Data Files, 2018. Miles are straight-line from the ZIP's population-weighted center.

Source: IMLS Public Libraries Survey FY2024 outlet and system files (720 open Ohio central libraries and branches of 251 systems, plus 62 bookmobiles); straight-line miles from each ZIP's population-weighted center to the nearest Ohio library… · IMLS Public Libraries Survey · IMLS Museum Data Files

Full detail

Loading the full detail… Or open it on the map.

Groceries

No residents in a flagged tract

No residents in a low-income, low-access tract57% over 1 mile from a supermarket · 4% of households on SNAP (ACS)

Source: USDA Food Access Research Atlas 2019 Large Retailer Access Map (2010 tracts, ERS's name for the file since July 2026) weighted by 2020 block population: distance to the nearest supermarket and low-income low-access flags; Census ACS… · USDA ERS Large Retailer Access Map · USDA SNAP retailers · Census ACS

Full detail

Loading the full detail… Or open it on the map.

History, schools and government

How the place began, who governs it now, and the schools that serve it, from the district boundary to its state report card.

Local history

1800 to 1814

Green Township · incorporated 1809first settled, platted or incorporated (earliest year recorded)

Source: Local history researched from Wikipedia, the 1880 county histories on archive.org, Ohio History Connection, National Register listings, Ohio historical markers, local historical societies and Wikimedia Commons, one file per municipality… · Ohio History Connection · Internet Archive (county histories) · Wikimedia Commons · Remarkable Ohio (historical markers)

Full detail

Loading the full detail… Or open it on the map.

Historic places

No listed place in the ZIP

0 listed historic placesnearest: Old Gothic Barns, 2.9 mi

Source: National Park Service, National Register of Historic Places point file (3,286 points for 3,232 of Ohio's roughly 4,200 listings; listings without a point are not counted, and a listing with several points is counted once); listings inside… · National Register data · USGS GNIS

Full detail

Loading the full detail… Or open it on the map.

Schools

369 local school districts

Northwest LocalLocal school district · 83% of residents, then Oak Hills Local

Public schools inside ZIP 45247, and the nearest outside it

  1. Diamond Oaks CdcCincinnati · 1.9 mi
    Address
    6375 Harrison Ave, Cincinnati, OH 45247
    Kind (NCES)
    Career and Technical School
    Students, 2023-24
    603
    Teachers (full-time equivalent)
    41
    NCES school ID
    390510604065
  2. Monfort Heights Elementary School3.5 of 5 stars · Cincinnati · 2.0 mi
    Address
    3711 W Fork Rd, Cincinnati, OH 45247
    School district
    Northwest Local School District
    Kind (NCES)
    Regular School
    Students, 2023-24
    575
    Teachers (full-time equivalent)
    31
    Report card, 2025-26
    3.5 of 5 stars
    Performance index
    80.5%
    Ohio building IRN
    025205
    NCES school ID
    390473602858

Source: NCES EDGE public school locations 2024-25 and Common Core of Data 2023-24 (type, students, teachers); Ohio School Report Cards 2025-26 (Department of Education and Workforce), matched by name within the district. Miles are straight-line from the ZIP's population-weighted center.

Private schools inside ZIP 45247

  1. St James the Greater SchoolPrivate, Catholic · Cincinnati · 1.9 mi
    Address
    6111 Cheviot Rd, Cincinnati, OH 45247
    Kind
    Catholic
    Students, 2023-24
    622
    Teachers (full-time equivalent)
    42.6
    Students per teacher
    14.6009
    Phone
    (513) 741-5333
    NCES private school ID
    01055398
  2. Skyward New HopePrivate, special education · Cincinnati · 2.1 mi
    Address
    3682 W Fork Rd, Cincinnati, OH 45247
    Kind
    special education
    Students, 2023-24
    25
    Teachers (full-time equivalent)
    4
    Students per teacher
    6.25
    Phone
    (513) 222-4611
    NCES private school ID
    A2302282
  3. St Bernard SchoolPrivate, Catholic · Cincinnati · 2.2 mi
    Address
    7115 Springdale Rd, Cincinnati, OH 45247
    Kind
    Catholic
    Students, 2023-24
    152
    Teachers (full-time equivalent)
    16.5
    Students per teacher
    9.21212
    Phone
    (513) 353-4224
    NCES private school ID
    A1903486

Source: NCES Private School Survey 2023-24. Miles are straight-line from the ZIP's population-weighted center.

Source: Ohio school district boundaries (U.S. Census Bureau TIGER/Line school districts, as of January 1, 2026) by resident share; NCES EDGE 2024-25 school buildings; NCES Private School Survey 2023-24 public-use file (schools inside the ZIP by… · ODOT GIS · NCES EDGE · NCES Common Core of Data · NCES private schools · Census SAIPE · Census school finances (F-33)

Full detail

Loading the full detail… Or open it on the map.

School ratings

4 stars

4 stars overallNorthwest Local · performance index 70.2% of the year's maximum · 96% graduate in four years

Source: Ohio School Report Cards 2024-2025 (Department of Education and Workforce): district overall and component star ratings, performance index, graduation rates, spending per pupil and teacher measures, for the district holding the largest… · Ohio school report cards

Full detail

Loading the full detail… Or open it on the map.

Colleges

Under 3 miles

Empire Beauty School-Cincinnati · 2.7 miCincinnati · 12 campuses within 10 miles

Colleges within 5 miles, and the nearest beyond

  1. Empire Beauty School-CincinnatiFor-profit career school · Cincinnati · 2.7 mi
    What it is
    For-profit career school
    City
    Cincinnati
    Students, 2023-24 (12-month count)
    293
    IPEDS unit ID
    407470
  2. Cincinnati School of Barbering & Hair DesignFor-profit two-year college · Cincinnati · 2.8 mi
    What it is
    For-profit two-year college
    City
    Cincinnati
    Students, 2023-24 (12-month count)
    69
    Graduation rate
    55% within three years (a class of 31)
    IPEDS unit ID
    490692
  3. Cincinnati State Technical and Community CollegePublic community or technical college · Cincinnati · 6.6 mi
    What it is
    Public community or technical college
    City
    Cincinnati
    Students, 2023-24 (12-month count)
    13,188
    Tuition and fees, in state
    $5,400
    Tuition and fees, out of state
    $9,801
    Graduation rate
    20% (all programs, within 150% of normal time) (a class of 470)
    IPEDS unit ID
    201928

Source: NCES IPEDS 2024 directory, 2023-24 enrollment and tuition, graduation rates for the 2017 (four-year) and 2020 (two-year) entering classes. Miles are straight-line from the ZIP's population-weighted center, as the card above measures them.

Source: NCES IPEDS: 2024 institutional directory (269 active Ohio institutions with coordinates, less the administrative units and the colleges that have closed since; plus 145 in Indiana, Kentucky, West Virginia, Pennsylvania and Michigan within… · NCES IPEDS

Full detail

Loading the full detail… Or open it on the map.

Local government

1308 townships

Green Township, Hamilton County52% of residents, then Colerain Township, Hamilton County

Source: ODOT municipal corporation and township boundaries by resident share of 2020 census blocks; Ohio EPA grants awarded in 2025 (OEPA_Achievements, MapServer layer 8); Auditor of State unauditable entities list · ODOT GIS · Auditor of State · Ohio EPA grants (OEPA_Achievements)

Full detail

Loading the full detail… Or open it on the map.

Representatives

OH-8 · Warren Davidson (R)Senate 8 Louis W. Blessing III · House 30 Mike Odioso

Source: ODOT TIMS Boundaries US_House_District, Ohio_Senate_District and Ohio_House_District (fetched 2026-09-08) by resident share of 2020 census blocks; members from the U.S. House, Ohio Senate and Ohio House directories, September 2026 · U.S. House · Ohio Senate · Ohio House · ODOT GIS

Full detail

Loading the full detail… Or open it on the map.

Rain and snow

How much has actually fallen on 45247 (Green Township and Cincinnati), day by day, from 1896 to now. Daily totals, not averages.

rain, last 30 days
1.04 in
2026-09-30 to 2026-10-29
rain so far in 2026
43.6 in
3.8 in above normal for the date
snow so far in 2026
14.9 in
a normal year brings 17.7 in
a normal year
47.1 in
average of 30 years, 1991-2020
The last twelve months
MonthRain (in)Snow (in)Days counted
October 2026 1.04 — 29
September 2026 5.71 — 30
August 2026 5.90 — 31
July 2026 3.97 — 31
June 2026 6.90 — 30
May 2026 6.90 — 31
April 2026 3.95 — 30
March 2026 6.53 0.5 31
February 2026 1.33 4.1 28
January 2026 1.37 10.3 31
December 2025 2.46 11.5 31
November 2025 4.08 2.0 30
On the record, 1896–2026
Wettest year2011 — 75.9 in
Driest year1934 — 22.8 in
Snowiest year1917 — 45.9 in
Wettest day on record5 March 1897 — 4.90 in
Heaviest snowfall in a day8 December 1917 — 11.62 in
Deepest snow on the ground20 December 1919 — 20.58 in

Mostly estimated. Only 6% of these days come from a gauge standing inside 45247 (Green Township and Cincinnati) - the rest are worked out from the nearest gauges around it, so read them as close estimates rather than readings.

45,970 days of records, 1896-09-01 to 2026-10-29. Source: NOAA NCEI GHCN-Daily, 3,240 gauges in and around Ohio. A day is "gauged" when a gauge standing inside the boundary reported it, and the value is the mean of those gauges. Otherwise it is interpolated by inverse distance from every gauge reporting within 50 miles. Nothing is carried forward, back-filled or smoothed. Against NOAA nClimDiv county monthly precipitation over 136,848 complete county-months (checked 2026-10-31): correlation 0.9515, median absolute difference 0.217 in a month. Built 2026-10-31 from the Cracked Buckeye precipitation archive. Snow is the softer number — snowfall is measured by hand with a ruler, no agency publishes a gridded county snowfall series, and blowing snow defeats every observer.

Environmental permits and filings

What Ohio EPA has on file for 45247 (Green Township and Cincinnati): permits, inspections, violations, cleanups and the state loans behind sewer and water work. Every line links to the agency's own document.

facilities and sites on file
32
those placed on the map inside 45247 (Green Township and Cincinnati)
What kind of permits
ProgramFacilities and sites
Wastewater and stormwater discharge15
Air pollution4
Contaminated-site cleanup3
Wetland and stream fill3
Voluntary cleanup2
Hazardous waste1
Landfills1
Public drinking water1
Sewer and water-line construction1
Source-water protection1
The latest filings
DateFacility or siteWhat
SKYRIDGE APARTMENT HOMES Wastewater and stormwater discharge notice of violation
ALEXANDER'S RIDGE Wastewater and stormwater discharge permit
SKYRIDGE APARTMENT HOMES Wastewater and stormwater discharge notice of violation
PARTH REAL ESTATE CORP Wastewater and stormwater discharge permit
BLUE BELL BEACH PWS Public drinking water notice of violation
LOP COORDINATION DRAVO DREDGING PROJECT Wetland and stream fill permit
HAM-74-1125 TAYLOR CREEK BANK REPAIR HAM113464 Wastewater and stormwater discharge permit
SKYRIDGE APARTMENT HOMES Sewer and water-line construction permit
SKYRIDGE APARTMENT HOMES Sewer and water-line construction permit
DON SANDER AUTO BODY Air pollution report
MONFORT HEIGHTS AUTO BODY Air pollution report
BRATFISH AUTO REPAIR Air pollution report
WHITEWATER CAR WASH - GREEN TWP Wastewater and stormwater discharge permit
SKYRIDGE APARTMENT HOMES Sewer and water-line construction permit
BRATFISH PROPERTIES III LLC 4732 BLUE ROCK Wastewater and stormwater discharge notice of violation
SKYRIDGE APARTMENT HOMES Wastewater and stormwater discharge report
HAMILTON COUNTY ENGINEERS E MIAMI RIVER ROAD Wastewater and stormwater discharge permit
PARTH REAL ESTATE CORP Wastewater and stormwater discharge permit
PARTH REAL ESTATE CORP Wastewater and stormwater discharge report
PARTH REAL ESTATE CORP Wastewater and stormwater discharge report
HAM-74-1125 TAYLOR CREEK BANK REPAIR HAM113464 Wastewater and stormwater discharge permit
BLUEASH SELF STORAGE Wastewater and stormwater discharge permit
SKYRIDGE APARTMENT COMPLEX - CLUBHOUSE Wastewater and stormwater discharge permit
BLUE BELL BEACH PWS Public drinking water notice of violation
SKYRIDGE APARTMENT HOMES Wastewater and stormwater discharge report

Source: Ohio EPA eDocument portal (edocpub.epa.ohio.gov), indexed 2026-10-14. Facilities are placed on the map from Ohio EPA's own map layers, EPA's Facility Registry, coordinates written in the filings, or a geocoded street address. A permit filed under a private person's name (most are household septic systems) is counted but never named, placed or linked; licenses for individual workers and open-burning notices are left out entirely.

Around here

Places in this ZIP

School districts

ZIP codes next door

The county

Hamilton County: 54 ZIP codes, 47 cities, villages and townships, 843,791 people. The county in numbers.

On the map

Infrastructure layers for this ZIP have not been compiled yet. Open this ZIP on the map to see what is drawn nearby.

Quick answers

What city is ZIP code 45247?

ZIP code 45247 is the Cincinnati, Ohio post office area in Hamilton County, home to 23,293 residents. Of its residents, 52% live in Green Township and 48% in Colerain Township.

What county is ZIP code 45247 in?

ZIP code 45247 is in Hamilton County, Ohio.

Where does the tap water in ZIP code 45247 come from?

13 wells in the Great Miami Buried Valley Aquifer along the Great Miami River near Fairfield, Butler Co. Charles M. Bolton Water Treatment Plant · Cincinnati Public Water System.

What school district is ZIP code 45247 in?

ZIP code 45247 is mostly in the Northwest Local School District; parts are in the Oak Hills Local School District.

Cite and data

Cite this page as:

Cracked Buckeye, "45247 · Green Township and Cincinnati, Hamilton County", https://crackedbuckeye.com/zip/45247/, built 2026-10-31, accessed [date].

How to cite · Report a correction · Built 2026-10-31