Where can i find cities neighborhoods database?

Question

Hey Folks,

Where can i find (free/not-free) database of cities neighborhoods for MySQL ? Interested in US only areas. Any recommendations?

The database would help to identify location by zipcode. I`ve already got database showing city and state. But i need to find neighborhoods around.

I saw good example on site called http://www.oodle.com/

Answer 1

Here's a great site offering free databases for both cities and countries:

http://ipinfodb.com/ip%5Fdatabase.php

Answer 2

For a fee... you can subscribe to Maponics' Neighborhood dataset
While Maponics provides mostly GIS data, (eg. allowing one to pinpoint on a map the boundaries of neighborhoods and such), the simple neighborhood list is also available, I think.
Another commercial offering is Urban Mapping's

In you target particular cities/counties, there are plenty of free resources to be found, oft' in the .gov / .us sites, for specific cities and counties. Unfortunately aside from the difficulty of locating such resources (there doesn't seem to exist any practical directory for such local gov-managed databases), there is no standard as to the format in which the data is stored or the specific semantics of the data collected. Luckily, ZIP-code is rather unanbiguous, and he neighborhood concept relatively general (even though the neighborhoods themselves can be quite dynamic, with bot the introduction of new neighborhood names, and some minor shifting of boundaries).

The overall complexity of the task of compiling such databases, the long half-life of the data, and the potentially lucrative uses of such data, seem to explain why it is hard to find non-commercial sources.

Answer 3

It might be worth checking out some of the links in this article. There are several where you might find the data you're after.

Answer 4

The Zillow Neighborhood data has a CC-sharealike license and it is pretty comprehensive. It is widely used in the Geospatial world nowadays.

Cheers

Answer 5

Urban Mapping has an API to find neighborhoods by address, City/State, and as you need in your case, Zip Code (called the getNeighborhoodsByPostalCode method).

Here is a link to their demo apps which show how it works: URBANWARE API Demo Applications

While this isn't a database per se, you could quickly populate your own database by calling their API for every Zip code you'd be interested in seeing.

Note that this is part of their Premium API. If you have the long/lat coordinates of each city, you can use their free API to get a list of neighborhoods whose boundaries contain the long/lat coordinates.