Where can I find a database of cities and neighborhoods using MySQL? I'm only interested in US areas. Price doesn't matter.
在哪里可以找到使用MySQL的城市和社区数据库?我只对美国感兴趣。价格并不重要。
The database must help identify locations by ZIP code. I've already got a database showing cities and states, but I need to find surrounding neighborhoods as well.
数据库必须通过邮政编码帮助标识位置。我已经有了一个显示城市和州的数据库，但我也需要找到周围的社区。
I saw good example on http://www.oodle.com/.
我在http://www.oodle.com/上看到了很好的例子。
9 个解决方案
#1
6
The Zillow Neighborhood data has a CC-sharealike license and it is pretty comprehensive. It is widely used in the Geospatial world nowadays.
Zillow的社区数据具有cc - sharesame许可证，并且非常全面。它在当今地球空间世界中得到了广泛的应用。
Cheers
干杯
#2
5
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
收费的…您可以订阅Maponics的邻居数据集，而Maponics则主要提供GIS数据(例如)。我认为，允许人们在地图上精确定位社区的边界等)，简单的社区列表也可以使用。另一个商业广告是城市地图。
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).
在特定的市/县，你可以在。gov /。us网站上为特定的市/县找到大量的免费资源。不幸的是，除了定位此类资源的困难(似乎不存在此类本地gov管理的数据库的任何实际目录)之外，对于数据存储的格式或收集的数据的特定语义没有标准。幸运的是，ZIP-code是相当无anbiguous的，而且他的邻里概念相对通用(尽管社区本身可以是动态的，引入了新的邻居名，并稍微改变了边界)。
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.
编译此类数据库的任务总体复杂，数据的半衰期长，以及这些数据潜在的有利可图的用途，似乎解释了为什么很难找到非商业来源。
#3
3
This is an old question - but there is a far better and EASIER way of doing it as of June 2015: http://maps.googleapis.com/maps/api/geocode/json?address=YOUR_ADDRESS&sensor=false
这是一个老问题，但到2015年6月，有一个更好更简单的方法:http://maps.googleapis.com/maps/api/geocode/json? address_your_address&sensor_false。
例如:http://maps.googleapis.com/maps/api/geocode/json?address=11%20W%2053rd%20St%20New%20York&sensor=false
#4
2
Yelp has a neighborhood API. http://www.yelp.com/developers/documentation/technical_overview
Yelp有一个社区API。http://www.yelp.com/developers/documentation/technical_overview
#5
1
Here's a great site offering free databases for both cities and countries:
这里有一个很棒的网站，为城市和国家提供免费的数据库:
http://ipinfodb.com/ip_database.php
http://ipinfodb.com/ip_database.php
#6
1
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.
查看本文中的一些链接可能是值得的。有几个地方你可以找到你想要的数据。
#7
1
Infochimps has the Zillow Neighborhoods API:
infoapes有Zillow社区API:
http://www.infochimps.com/datasets/zillow-neighborhoods
http://www.infochimps.com/datasets/zillow-neighborhoods
#8
#9
0
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).
Urban Mapping有一个API来根据地址、城市/州来查找社区，根据您的情况需要，还有邮政编码(称为getNeighborhoodsByPostalCode方法)。
Here is a link to their demo apps which show how it works: URBANWARE API Demo Applications
下面是他们的演示应用程序的链接，展示了它是如何工作的:URBANWARE API演示应用程序
Edit:
Urban Mapping doesn't exist anymore, and the Demo link has linkrot; here's what it did look like, via Wayback Machine
编辑:城市地图不再存在，Demo链接有linkrot;这是它看起来的样子，通过Wayback机器。
[
(
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.
虽然这本身不是一个数据库，但是您可以通过为每个您感兴趣的邮政编码调用它们的API来快速填充自己的数据库。
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.
请注意，这是其高级API的一部分。如果您有每个城市的long/lat坐标，您可以使用它们的免费API获得一个包含long/lat坐标的社区列表。
#1
6
The Zillow Neighborhood data has a CC-sharealike license and it is pretty comprehensive. It is widely used in the Geospatial world nowadays.
Zillow的社区数据具有cc - sharesame许可证，并且非常全面。它在当今地球空间世界中得到了广泛的应用。
Cheers
干杯
#2
5
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
收费的…您可以订阅Maponics的邻居数据集，而Maponics则主要提供GIS数据(例如)。我认为，允许人们在地图上精确定位社区的边界等)，简单的社区列表也可以使用。另一个商业广告是城市地图。
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).
在特定的市/县，你可以在。gov /。us网站上为特定的市/县找到大量的免费资源。不幸的是，除了定位此类资源的困难(似乎不存在此类本地gov管理的数据库的任何实际目录)之外，对于数据存储的格式或收集的数据的特定语义没有标准。幸运的是，ZIP-code是相当无anbiguous的，而且他的邻里概念相对通用(尽管社区本身可以是动态的，引入了新的邻居名，并稍微改变了边界)。
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.
编译此类数据库的任务总体复杂，数据的半衰期长，以及这些数据潜在的有利可图的用途，似乎解释了为什么很难找到非商业来源。
#3
3
This is an old question - but there is a far better and EASIER way of doing it as of June 2015: http://maps.googleapis.com/maps/api/geocode/json?address=YOUR_ADDRESS&sensor=false
这是一个老问题，但到2015年6月，有一个更好更简单的方法:http://maps.googleapis.com/maps/api/geocode/json? address_your_address&sensor_false。
例如:http://maps.googleapis.com/maps/api/geocode/json?address=11%20W%2053rd%20St%20New%20York&sensor=false
#4
2
Yelp has a neighborhood API. http://www.yelp.com/developers/documentation/technical_overview
Yelp有一个社区API。http://www.yelp.com/developers/documentation/technical_overview
#5
1
Here's a great site offering free databases for both cities and countries:
这里有一个很棒的网站，为城市和国家提供免费的数据库:
http://ipinfodb.com/ip_database.php
http://ipinfodb.com/ip_database.php
#6
1
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.
查看本文中的一些链接可能是值得的。有几个地方你可以找到你想要的数据。
#7
1
Infochimps has the Zillow Neighborhoods API:
infoapes有Zillow社区API:
http://www.infochimps.com/datasets/zillow-neighborhoods
http://www.infochimps.com/datasets/zillow-neighborhoods
#8
1
Maponics has over 150,000 neighborhoods worldwide available in MySQL and other formats, as well as an API.
Maponics在全球有超过150,000个社区可以使用MySQL和其他格式以及API。
#9
0
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).
Urban Mapping有一个API来根据地址、城市/州来查找社区，根据您的情况需要，还有邮政编码(称为getNeighborhoodsByPostalCode方法)。
Here is a link to their demo apps which show how it works: URBANWARE API Demo Applications
下面是他们的演示应用程序的链接，展示了它是如何工作的:URBANWARE API演示应用程序
Edit:
Urban Mapping doesn't exist anymore, and the Demo link has linkrot; here's what it did look like, via Wayback Machine
编辑:城市地图不再存在，Demo链接有linkrot;这是它看起来的样子，通过Wayback机器。
[
(
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.
虽然这本身不是一个数据库，但是您可以通过为每个您感兴趣的邮政编码调用它们的API来快速填充自己的数据库。
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.
请注意，这是其高级API的一部分。如果您有每个城市的long/lat坐标，您可以使用它们的免费API获得一个包含long/lat坐标的社区列表。