在哪里可以找到城市/社区数据库？
在哪里可以找到使用 MySQL 的城市和社区数据库？我只对美国地区感兴趣。价格并不重要。
该数据库必须帮助通过邮政编码识别位置。我已经有了一个显示城市和州的数据库，但我还需要找到周围的社区。
我在 http://www.oodle.com/ 上看到了很好的例子。
Where can I find a database of cities and neighborhoods using MySQL? I'm only interested in US areas. Price doesn't matter.
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/.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（8）
Zillow Neighborhood 数据 具有 CC 共享许可，而且非常全面。它当今在地理空间世界中广泛使用。
干杯
The Zillow Neighborhood data has a CC-sharealike license and it is pretty comprehensive. It is widely used in the Geospatial world nowadays.
Cheers
您可以付费订阅Maponics 邻里数据集
虽然 Maponics 主要提供 GIS 数据（例如，允许人们在地图上精确定位社区的边界等），但我认为简单的社区列表也是可用的。
另一种商业产品是城市测绘
当您定位特定城市/县时，通常可以在 .gov/.us 网站中找到针对特定城市和县的大量免费资源。不幸的是，除了定位此类资源的困难（似乎不存在此类地方政府管理的数据库的任何实用目录）之外，对于数据存储的格式或数据的特定语义也没有标准集。幸运的是，邮政编码相当明确，而且社区概念相对笼统（尽管社区本身可能非常动态，机器人引入了新的社区名称，并且边界发生了一些细微的变化）。
编译此类数据库任务的整体复杂性、数据的半衰期较长以及此类数据的潜在利润丰厚的用途，似乎解释了为什么很难找到非商业来源。
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.
这是一个老问题 - 但截至 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
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
Example:
http://maps.googleapis.com/maps/api/geocode/json?address=11%20W%2053rd%20St%20New%20York&sensor=false
这是一个提供城市和国家免费数据库的很棒的网站：
http://ipinfodb.com/ip_database.php
Here's a great site offering free databases for both cities and countries:
http://ipinfodb.com/ip_database.php
Yelp 有一个社区 API。
http://www.yelp.com/developers/documentation/technical_overview
Yelp has a neighborhood API.
http://www.yelp.com/developers/documentation/technical_overview
Infochimps 拥有 Zillow Neighborhoods API：
http://www.infochimps.com/datasets/zillow-neighborhoods< /a>
Infochimps has the Zillow Neighborhoods API:
http://www.infochimps.com/datasets/zillow-neighborhoods
Maponics 在 MySQL 中提供了全球超过 150,000 个社区其他格式，以及 API 。
Maponics has over 150,000 neighborhoods worldwide available in MySQL and other formats, as well as an API.
Urban Mapping 有一个 API，可以按地址、城市/州以及您的情况需要的邮政编码（称为 getNeighborhoodsByPostalCode 方法）查找社区。
以下是他们的演示应用程序的链接，展示了其工作原理：
URBANWARE API 演示应用程序
编辑：
Urban Mapping 已经不存在了，Demo 链接有 linkrot； 这就是它的样子，来自 Wayback Machine< /a>
[
虽然这本身不是数据库，但您可以通过为您有兴趣查看的每个邮政编码调用他们的 API 来快速填充您自己的数据库。
请注意，这是他们的高级 API 的一部分。如果您有每个城市的经/纬度坐标，您可以使用他们的免费 API 来获取边界包含经/纬度坐标的社区列表。
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
Edit:
Urban Mapping doesn't exist anymore, and the Demo link has linkrot; here's what it did look like, via Wayback Machine
[
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.