u/BorisDaGod

I analyzed 676,000 Columbus bird sightings. Almost every rare species in Franklin County funnels to the same few parks.
▲ 544 r/Columbus

I analyzed 676,000 Columbus bird sightings. Almost every rare species in Franklin County funnels to the same few parks.

Between January 2025 and April 2026, about 2,920 people filed 53,505 checklists across Franklin County on eBird, a citizen science platform where birders log what they see. 263 species across 5,373 locations. I went through all of it to figure out where each species is actually being seen.

The short answer: the common stuff is everywhere. Cardinals show up on 59% of all checklists county-wide. But for the rarer species, the data funnels overwhelmingly to a handful of specific parks, and for specific, explainable reasons.

Note: Thanks to eBird for giving me access to the data. Download eBird and Merlin, they're super cool.

#Battelle Darby Creek - Wet Prairie Restoration

Share of all county-wide sightings at this location:

  • Nelson's Sparrow: 100% - the only location in the county
  • Least Bittern: 96%
  • Sedge Wren: 93%
  • Virginia Rail: 92%
  • Henslow's Sparrow: 86%
  • Marsh Wren: 84%
  • Common Gallinule: 80%
  • Northern Bobwhite: 76%
  • Sora: 69%
  • Ring-necked Pheasant: 65%

Ten species, one park. They all need the same thing: tall native grass with shallow seasonal flooding over open ground. That habitat has mostly been eliminated across central Ohio by farming and development. Battelle Darby's restored prairie is one of the only places left in the county that provides it at any scale.

The Nelson's Sparrow stat is worth a closer look. This is a bird that breeds in the marshes of the northern Great Plains and Hudson Bay. It doesn't live in Ohio at all. It only passes through the state as a rare migrant, mostly turning up along Lake Erie in October. It's considered one of the last sparrows most Ohio birders will ever add to their state list. And yet all 15 sightings in Franklin County are at this one restored prairie. Every single one in October. Whatever Darby Plains is doing with its wet grassland habitat, it's creating something that briefly mimics the conditions these birds use on their migration south.

This park also holds 58% of American Bittern sightings and 51% of Wilson's Snipe.

#Pickerington Ponds

Share of all county-wide sightings at this location:

  • Wood Stork: 91%
  • Mississippi Kite: 85%
  • American Barn Owl: 81%

The Barn Owl is the standout. 191 of 235 checklists county-wide. Barn Owls need open grassland for hunting and old structures or cavities for roosting. Pickerington's combination of meadows, marshes, and outbuildings is one of the few spots in the county that provides both. If you want to see a Barn Owl in Franklin County, this is realistically the best place to go.

The Wood Stork is a different kind of story. Wood Storks are large wading birds that live in the swamps and marshes of the southeastern U.S. Their normal range runs from Florida through the Carolinas and along the Gulf Coast. They don't belong in Ohio. But after breeding season, they're known to wander north, sometimes hundreds of miles past their usual range. One showed up at Pickerington Ponds in June 2025 and all 45 checklists happened over just two days as birders descended on it.

#OSU Airport (Don Scott Field) Share of all county-wide sightings at this location:

  • Rough-legged Hawk: 87%
  • Short-eared Owl: 45%

Rough-legged Hawks breed on Arctic tundra and need flat, treeless, open ground in winter. The mowed grass fields around Don Scott's runways are the largest unbroken open space in the county, and these birds use them the same way they'd use tundra. 87% of county-wide sightings at one location makes this one of the cleanest monopolies in the data.

Short-eared Owls use the airport for the same reason, but they split their time - 45% at Don Scott, 38% at Darby Plains. Both species hunt by flying low over open grass at dusk in a slow, moth-like pattern. This isn't a Columbus quirk. Short-eared Owls have been drawn to airports across the eastern U.S. for decades wherever grassland habitat has disappeared around them. Philadelphia International Airport hosted dozens of wintering Short-eared Owls through the late 1980s. The Pennsylvania Game Commission has specifically identified airports as one of the last reliable habitat types for this species, which is listed as endangered in that state.

#Glen Echo Park Share of all county-wide sightings at this location:

  • Kentucky Warbler: 70%
  • Golden-winged Warbler: 58%
  • Worm-eating Warbler: 53%

Three declining warbler species, all concentrated at the same small neighborhood park in Clintonville. All three need deep shaded forest with dense understory in a ravine or bottomland near water. That's a literal description of Glen Echo: a steep wooded ravine with a creek at the bottom, walled in by topography on all sides. Most Columbus parks are too open, too manicured, or too fragmented to provide real interior forest. Glen Echo's ravine structure protects it from that, which is why migrating warblers consistently stop there. 70% of a county-wide species at a single neighborhood park is a pretty striking number.

#Clover Cemetery and Wetlands Share of all county-wide sightings at this location:

  • Long-billed Dowitcher: 69%
  • Ross's Goose: 63%
  • Greater White-fronted Goose: 55%
  • Snow Goose: 40%

Three uncommon Arctic-breeding goose species and a shorebird concentrated at one location that most people in Columbus have probably never heard of. These geese need open water next to short-grass areas for grazing. A maintained cemetery next to a wetland turns out to be a near-perfect version of that.

#McKinley Quarry Share of all county-wide sightings at this location:

  • Neotropic Cormorant: 89%
  • Snowy Egret: 67%

Neotropic Cormorants normally live in the tropics and subtropics. Their range runs from the southern U.S. Gulf Coast through Central and South America. They've been expanding northward in recent years, but central Ohio is still well outside their expected range. 67 of 75 county-wide sightings happen at one flooded quarry. Old quarries that fill with water create steep-banked, relatively warm, sheltered pools, not unlike the subtropical lakes and rivers these birds use in their normal range.

McKinley Quarry isn't on most people's birding radar, but the data says it should be.

#Hoover Reservoir Share of all county-wide sightings at this location:

  • Sanderling: 15 of 15 - the only location in the county
  • Red-throated Loon: 16 of 16 - the only location in the county
  • Red-breasted Merganser: 66%
  • Caspian Tern: 63%

These are all open-water and shoreline species, or birds you'd normally associate with the Great Lakes or the coast. Franklin County is landlocked, so the closest thing it has to open water at any scale is Hoover Reservoir. Sanderlings normally run along ocean beaches. Red-throated Loons breed on Arctic lakes and winter along the coast. They use Hoover because it's the only thing in the county that remotely resembles what they actually want.

All 15 Sanderling sightings were in September at the Walnut Boat Ramp. All 16 Red-throated Loon sightings were in November.

A few other notable single-location concentrations that didn't fit neatly into a section: Eastern Screech-Owl at Kiwanis Riverway Park (82%), Orange-crowned Warbler at Walnut Woods Tall Pines (67%), Long-tailed Duck at Duranceau Park (75%), and Black Scoter at Griggs Reservoir (67%).


Shameless Plug: I recently built knowyourblock.org , a free tool that shows reports of rats, mold, landlord negligence, etc, all throughout Columbus. If you can't tell, my next feature is going to be mapping the birds you'll likely see in each part of Columbus. I'd prefer to live at a place with less Starlings and House Sparrows and more Mourning Doves and Bluebirds, for example.

Data is from eBird (Cornell Lab of Ornithology), covering Franklin County from January 2025 through April 2026.

u/BorisDaGod — 23 hours ago

[OC] I analyzed 55,562 code enforcement reports in my city to map exactly where rats and mice are being reported the most.

u/BorisDaGod — 3 days ago

I turned 55,000+ code enforcement reports in my city into a free tool that shows where mold, rats, bad landlords, and more, are being reported across the city.

Ohio ranks near the bottom nationally for tenant protections, and a lot of the issues renters deal with (mold, rats, bedbugs) are things that just aren't going to show up on an apartment tour.

Landlords can (and will) paint over mold, rats are nocturnal and probably won't be out during a 2pm apartment tour, you're not gonna know about your neighbor's bedbugs until it's too late, and you won't know that the heating is effectively broken if you're moving in the middle of July.

Basically every city in Ohio collects data on all of this, but the data tends to be buried in systems that aren't really meant for regular people to dig through. So I pulled 55,000+ code enforcement reports from Columbus and put them into a free tool where you can search any address and see what's been reported on that block. You can see reports of mold, management negligence, rats and other pests, drugs, noise, and a bunch of problems worth knowing about.

Link: knowyourblock.org

Landlords have every incentive to not share negative info about a property, and because of the lax tenant protections, limited incentive to fix it once you find out. So a tool like this is really effective at surfacing issues you'd otherwise not see until you've already signed a 12 month lease

I'm admittedly a bit biased haha , but I think a tool like this is really effective at surfacing issues you'd otherwise not see until you've already signed a 12 month lease.

Looking to add more cities over time.

reddit.com
u/BorisDaGod — 3 days ago
▲ 82 r/Ohio

I turned 55,000+ Columbus, OH code enforcement reports into a free tool that shows where mold, rats, bad landlords, and more, are being reported across the city.

Ohio ranks near the bottom nationally for tenant protections, and a lot of the issues renters deal with (mold, rats, bedbugs) are things that just aren't going to show up on an apartment tour.

Landlords can (and will) paint over mold, rats are nocturnal, you're not gonna know about your neighbor's bedbugs until it's too late, and you won't know that the heating is effectively broken if you're moving in the middle of July.

Basically every city in Ohio collects data on all of this, but the data tends to be buried in systems that aren't really meant for regular people to dig through. So I pulled 55,000+ code enforcement reports from Columbus and put them into a free tool where you can search any address and see what's been reported on that block. You can see reports of mold, management negligence, rats and other pests, drugs, noise, and a bunch of problems worth knowing about.

Link: knowyourblock.org

Landlords have every incentive to not share negative info about a property, and because of the lax tenant protections, limited incentive to fix it once you find out. So a tool like this is really effective at surfacing issues you'd otherwise not see until you've already signed a 12 month lease

I'm admittedly a bit biased haha , but I think a tool like this is really effective at surfacing issues you'd otherwise not see until you've already signed a 12 month lease.

Looking to add additional Ohio cities here soon, but wanted to share.

PS - If anyone knows of cities that publish the data similarly to Columbus, please let me know lol.

reddit.com
u/BorisDaGod — 3 days ago
▲ 405 r/Columbus

I turned 50,000+ Columbus code enforcement reports into a free tool that shows where mold, rats, negligent landlords, and more are being reported across the city.

First: yes, I'm the same guy who posted the rat corridor analysis and the worst apartment complexes like a week ago. This time, I wanted to release the tool I've been building.

knowyourblock.org is a free, searchable map of 50,000+ Columbus code enforcement reports. Mold, rats, roaches, no heat, sewage, negligent management, drug activity, and more. Search any address and get a custom report showing what's been reported there and nearby.

A quick note on why code enforcement data is so effective at surfacing real problems:

The problem is information asymmetry.

No landlord is going to tell you their tenants have been reporting mold for two years or that the city has flagged them as unresponsive. Large apartment complexes might have Google reviews. Townhomes, Duplexes, triplexes, single-family rentals? You're going in blind. There's nowhere to look.

And even if your unit is perfect, what's happening around you matters. If half the houses on your block have recurring rat reports, those rats aren't respecting your property line. If the place next door is vacant and has repeat-squatters, that's worth knowing about. If other tenants in your building keeps reporting their heat going out and a totally unresponsive landlord, that means something.

You're not going to see any of this on a showing at 2 PM on a Tuesday. Rats are nocturnal and live in the walls. You'll never know until you're already moved in and hearing them at night. Mold gets painted over before every new tenant. The house two doors down that's had code enforcement out six times looks the same as every other house from the sidewalk. There's no amount of walking around the neighborhood that surfaces this stuff.

Code enforcement data does. Real people calling 311 about real problems they're living with. The city records all of it publicly. It just happens to be buried in a portal almost nobody knows exists (and quite frankly it's miserable to use).

What the tool does: categorizes every report by issue type, flags severity, detects apartment complexes so you can see patterns across an entire property, and surfaces chronic hotspots where problems keep coming back. Heatmap for city-wide patterns, drill down to individual reports at any address. You can also pull up a shareable report for any address, which is useful if you're sending it to a roommate or want to keep it as a reference before signing something.

All public data, nothing beyond what Columbus already publishes. Search your address or search the place you're considering. It's free.

Note: This is still a work in progress. There are some issues that I'm aware of and working through. There are almost certainly issues or bugs I'm not aware of.

I'm not a coder or developer. I work in an industry that is conceptually adjacent to this, but this is my first time attempting something even close to this scale. I'll be updating the info over time.

Candidly, I built this because I thought the data was interesting and I want to ensure people know what they're getting into before signing long leases or signing a 30 year mortgage.

If you work for the city, or a tool like this is particularly useful for what you do (ex. social workers, housing advocates, realtors) feel free to dm with thoughts or suggestions. Want to make sure this is as useful as possible.

Additional Note Strongly recommend using this on desktop for the time being.

reddit.com
u/BorisDaGod — 6 days ago
▲ 222 r/Columbus

I analyzed 2,454 rat and rodent reports across 16 months of Columbus code enforcement data. Here are the top three corridors that account for a wildly disproportionate share of them.

Intro Note: Long Post for sure but I think it's neat. Columbus code enforcement data is probably the highest signal tool to understanding what's going on with certain areas of the city. I also just really don't like rats lol. Heatmap of rat reports in the comments.

I've been building a tool that maps Columbus 311 and code enforcement data so renters can see what's actually happening at and around an address before they sign a lease. It pulls in heat maps, individual complaint reports, and map overlays, and you can sort by problem type (rats, bedbugs, trash, structural issues, etc). The point is to see beyond what's been reported at your address. It's what's going on at neighboring addresses too, because some of the stuff that affects your quality of life (hoarder houses, drug activity, illegal dumping, chronic vacancy) wouldn't be obvious on an apartment tour but shows up clearly in 311 data. Hoping to release this tool within the next week.

One quick caveat on the rat data specifically: code enforcement complaints skew heavily toward rental properties because most homeowners aren't going to report their own house to the city. So this is really a map of reported rodent activity, which in practice means a map of rental neighborhoods with rodent problems. That's worth noting, but for renters or prospective home buyers -- who are exactly the people searching for this -- it's also exactly the relevant dataset.

Rat reports aren't scattered evenly across the city. They cluster hard into specific corridors, and each corridor has a different story behind it.

#1) The Cleveland Avenue Spine (Linden into Northland)

Draw a band about six blocks wide centered on Cleveland Avenue from I-670 north to Karl Road. Inside that band: 426 rat reports across 328 different addresses. That's 17% of every rat report filed in the entire city, concentrated in less than 1% of its area.

Cleveland Avenue itself only accounts for about 15 of those reports. The other 96% are on the side streets feeding into it: Howey Rd, Grasmere Ave, E Weber Rd, E 18th, Atwood Terrace, Hamilton Ave, etc. Cleveland Ave is the spine. The rats live on the tributaries. The worst stretch is the Linden band between I-670 and Hudson: 158 reports from 116 different addresses. Roughly one out of every two distinct properties in that band filed a rat complaint in the last 16 months.

What's probably going on: this corridor is dominated by single-family rentals and small duplexes that turn over frequently and where maintenance is reactive, not preventive. Nobody's doing proactive rodent exclusion, nobody's coordinating with the neighbor, and code enforcement is complaint-driven so it's always one step behind.

One report describes garbage piled three feet high in a backyard, rats nesting in the pile since March, the health department finding multiple dead rats in the driveway, and two-foot-high grass. Another describes a duplex filled with trash that's never put out for collection, overgrown yards, and rats infesting the property, with squatters on one side.

What makes this corridor unusual is how continuous it is. It's a rat highway highway. The reports stretch for miles, every month, on every connecting street. There's no gap in the food, no gap in the cover, and no gap in the neglected yards that connect one block to the next. If you're apartment hunting on any side street within a few blocks of Cleveland Ave between I-670 and Hudson, the data says expect rodent activity. Not because your specific building is bad, but because the entire corridor is sustaining a population that no single landlord can solve.

##2) The Fairgrounds Zone (E 15th through E 26th)

Just south of where the Cleveland Ave corridor starts, there's a tight grid of numbered avenues that lights up on its own: 92 rat reports across 68 different addresses.

Every numbered avenue from E 15th to E 26th has at least 4 separate addresses reporting rats. E 18th Ave leads with 11 reports. Twelve different streets, all reporting independently, all within about a half mile of the Ohio State Fairgrounds.

I'll let you draw your own conclusions on that proximity. What I can say is what the data shows: the reports are there, they're dense, and they span every residential street in the area.

The Ohio Expo Center at 717 E 17th Ave is a massive complex with livestock facilities that hosts over 150 events a year: the Quarter Horse Congress (4,000+ horses over four weeks), the Ohio State Fair, the Ohio Beef Expo, and dozens of other livestock and food events. It has ties for 2,000 cattle. The buildings include turn-of-the-century pavilions with the kind of old foundations that harbor established rodent colonies. Year-round livestock events mean year-round animal feed, grain, and food vendor waste.

The surrounding neighborhood is Milo-Grogan: historically industrial, lots of old housing stock, significant vacancy. The Ohio History Connection is also running a major multi-year construction project on E 17th Ave that broke ground in fall 2024 and runs through 2027. Construction and demolition are one of the biggest triggers for displacing rat colonies into surrounding residential blocks. So you've got the fairgrounds generating a permanent food source, construction pushing existing colonies outward, and a surrounding neighborhood full of aging rentals with plenty of entry points. The rats (POSSIBLY) radiate from the fairgrounds onto every residential street in range.

#3) The Tamarack / Red Robin Zone (Northland)

This one is quieter in raw numbers (41 reports) but arguably the most revealing pattern in the dataset. The reports span across multiple apartment complexes, townhome courts, and independent houses throughout the zone. This isn't a situation where one poorly managed building is driving all the complaints.

This is the area around Tamarack Boulevard and Red Robin Road just north of Morse Road: a dense cluster of 1960s and early-70s garden-style apartment complexes surrounded by single-family homes and small townhome courts.

The count is low but the pattern is what matters: dozens of independent properties, not units inside one complex, all reporting rats in the same window. That means the rodent population isn't driven by one bad property manager. It's neighborhood-wide. These complexes all back up to each other with continuous green space, shared parking areas, and communal dumpsters. A rat doesn't see property lines. It sees one unbroken habitat from Karl Road to Cleveland Avenue. The complexes themselves are 50-60 years old with deteriorating building envelopes. But the surrounding single-family homes are reporting too, which tells you the population has outgrown the complexes and saturated the area.

#Summary/Takeaway

  1. I don't like rats.
  2. If you're looking at renting or buying a property in this area, do additional due-diligence. Or don't. I don't care at all really. I've just been locked into this data for the past few weeks and if I don't share stuff like this , I'm just a guy sitting alone in my room analyzing city code enforcement data for fun.
reddit.com
u/BorisDaGod — 11 days ago
▲ 311 r/Columbus

I analyzed 40,000+ Columbus code enforcement reports from the past 11 months. These are the 5 apartment complexes with the worst habitability records.

Long post but figured this was interesting enough to share lol. Been working through a ton of code enforcement data for a tool I'm building.

What I did: I pulled every code enforcement report filed in Columbus over roughly the past 11 months. I grouped reports by apartment complex, filtered to complexes with at least 5 buildings and 15+ reports, and scored them based on the type and severity of the violations. Life-safety emergencies like no heat, no electricity, sewage backups, and structural problems were weighted heaviest. I also factored in what percentage of a complex's reports were rated severe (level 3 or 4 out of 4) and how many different kinds of problems showed up.

#1) Lakeside Villas (Northland) 122 reports across 16 buildings. 48% rated severe. 44% rated critical.

The single highest-scoring complex in the dataset, and it's not close. The dominant pattern in the records is loss of heat and electricity. The data shows 51 separate no-heat reports and 31 no-electricity reports for this complex. The records paint a picture of what happened in late February 2026: electrical service to multiple buildings was apparently disconnected, leaving dozens of units without power or heat during one of the coldest stretches of winter. Reports describe this lasting two-plus weeks. Some reports then describe tenants running generators with extension cords routed through windows, which the city flagged as its own fire hazard. What puts this at #1 isn't just neglect of individual units. The records suggest a single infrastructure failure that took out services for an entire section of the complex at once, with no apparent rapid response from management. Pretty sure some units were also forced to evacuate during this.

#2) Village Court (Northland) 48 reports across 21 buildings. 79% rated severe.

This is the highest severity rate of any qualifying complex in the entire dataset. Every problem category in my scoring system fires here: pests, mold, no heat, structural issues, water shutoffs, unresponsive management. The records include a report where Columbus Fire forced entry into a unit because a smoke alarm was going off. According to the report, the alarm was triggered by smoke coming from a malfunctioning furnace in a unit that already had an open no-heat violation. Another report describes a unit where the upstairs neighbor's bathwater was draining into the downstairs tenant's toilet. Yet another describes a resident who filed maintenance requests by phone, online portal, and in person, and watched every one get marked "closed" without any work being done.

If Lakeside Villas is the worst by scale, the records suggest Village Court is the worst by concentration. Nearly 4 out of every 5 reports filed here are severe.

#3) Capital Park Apartments (North Linden) 118 reports across 44 buildings. The largest complex in the top 5. 42% severe, 26% critical.

The lower severity percentage is partly a function of size. Spread across 44 buildings, you get more lower-level reports mixed in. But there are still 31 critical-level events in the records. The pattern that stands out here is systematic safety-system failures: 9 reports of missing or inoperable smoke detectors, multiple reports of exposed wiring, open furnace covers, and flammable materials stored improperly. One report documents a single unit with an inoperable stove, no heat, no hot water, and inoperable smoke detectors all at once. Another describes homeless individuals sleeping in a flooded basement, with the leasing office aware of the situation.

#4) Gateway Apartments (Linden / Mifflin) 48 reports across 17 buildings. 56% severe. Every problem category fires.

Gateway stands out from the rest of this list for a specific reason: multiple reports describe what tenants characterize as retaliation. In at least three separate reports, tenants describe utilities (which were included in their rent) being shut off after they filed code complaints. That's a different pattern from the "ignore everything" approach described at the other complexes. Other records describe a tenant whose kitchen ceiling collapsed and whose unit flooded repeatedly. Reports indicate she had been staying in a hotel and in her car. Another describes a unit where Columbia Gas shut off service due to unresolved mechanical issues in the apartment, with the rental office reportedly not addressing it.

#5) Stonecreek Apartments (Northland, south of Morse Rd)

59 reports across 12 buildings. 54% severe.

The signature pattern here is building-wide pest infestation -- 11 rat reports and 7 roach reports, with residents describing the problem as affecting entire buildings, not just individual units. This is layered on top of recurring whole-building water and electric outages, and a report where Columbus Fire condemned a furnace for unsafe operation.

Caveats (please read)

  • This covers ~11 months of data. A complex could look terrible because of one catastrophic stretch rather than year-round neglect. Lakeside Villas and Stonehenge may fall into this category.
  • Small complexes get filtered out. A truly awful 5-unit building run by a slumlord might only generate a handful of reports and miss the threshold entirely.
  • I'm reporting what the code enforcement records say. I haven't independently verified the claims tenants made in their reports.
  • This isn't legal advice, and I'm not accusing anyone of anything. These are public records. If you're considering any of these properties, do your own research.
  • There are probably worse complexes than these all things considered -- code enforcement data tends to be light on violence-related data for example. This is just based on the data provided.
reddit.com
u/BorisDaGod — 12 days ago