地理编码 - 将多个地址分组到多个主要城市 [英] Geocoding - Grouping multiple addresses into major cities

问题描述

我需要将多个地址分组到不同的城市中心。我唯一的地址信息是城市，国家和州（如果适用）。例如，旧金山和英里内的所有地址都应列为旧金山。我需要知道收集到旧金山的地址数量。

我接受有关如何处理此问题的建议。如果可能，我不特别想手动确定主要城市的列表。有没有这些我可以从哪里开始的列表？

如何使用英里内所有地址的平均纬度/经度位置？当然，最终的中心点会随着平均值的变化而变化，但也许这是一个近似的解决方案。不太确定如何再次这样做，欣赏输入！

解决方案

好的问题。我想更普遍的是，你想要的是将城市卷入大都市区的一种标准方式，而你完全正确的做法是你不想创建或维护自己的列表。

Yahoo! GeoPlanet 提供了一个相当完整的层次结构的地理本体论。如果你对标准行政区划（如县或州）感到满意，那很容易，但我认为你正在寻找比这更普遍的东西。但GeoPlanet也经常在美国提供区域，包括该镇的大都市统计区 。

如果您有每个城市名称，则可以使用GeoPlanet查找该城市所属的任何MSA区域，然后汇总到该区域（并且GeoPlanet提供了一个边界框和每个MSA的质心，以便您可以轻松将其放置在地图上）。对于不属于美国人口普查局MSA部分的农村城镇，您可能不需要将其分组到最近的城市（无论如何，这可能很远）。

Been hunting through previous questions on Geocoding and while many are helpful I'm not finding one to my needs.

I need to group multiple addresses to the nearest city centers. My only address information is city, country, and state (if applicable). For example, all addresses in San Francisco and within miles should be listed as San Francisco. I'll need to know the count of addresses rolled-up to San Francisco.

I'm open to suggestions on how to approach this. I don't particularly want to manually identify a list of major cities if possible. Is there a list of these I can start from?

What about using an average lat/long location of all addresses within miles? Granted the final 'center point' would move around a bit as the average is computed but perhaps that is an approximate solution. Not quite sure how to do this so again, appreciate input!

解决方案

Great question. I think more generally what you want is some standard way of rolling up cities into metropolitan areas and you're exactly right that you don't want to create or maintain a list of your own.

Yahoo! GeoPlanet provides a geographic ontology with a pretty thorough hierarchy. If you were happy with standard administrative divisions (like county or state), it would be easy, but I think you're looking for something a little more general than that. But GeoPlanet also provides zones, often -- in the US -- including the town's Metropolitan Statistical Area.

If you have each city name, you could use GeoPlanet to find any MSA zones that the city belongs to and roll up to that (and GeoPlanet provides a bounding box and centroid for each MSA so you can easily place it on a map). For rural towns that aren't a part of a US census bureau MSA you may not need to group it to the nearest city (which may be far away anyway).

这篇关于地理编码 - 将多个地址分组到多个主要城市的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！