问题描述
我被要求根据美国各州和城市生成一些人口统计报告(犯罪率，出生/死亡等).我拥有所有(由客户提供的)人口统计数据，但似乎找不到任何具有美国各州及其城市边界(读作:LAT/LONG)的地方.我们的数据是纬度/经度数据(例如犯罪，出生等)，我们想获取一些映射的报告，还希望使用Sql server来获取数据(我们正在使用MS Sql 2008，但这不应该)不会影响这个问题.
所以..谁能将我引导到存在某些州和城市边界来源的地方?我知道我们的政府可以在美国人口普查局免费获得所有这些信息，但我似乎无法了解在哪里找到以及如何提取此信息.
我假设此信息将采用经/纬多边形的形式(例如shapefile等)，然后我可以将其导入数据库并挖掘掉.
任何人都可以帮忙吗?
我可以建议发布 http://adventuresdotnet.blogspot.com/2009/06/sql-server-2008-importing-tigerline.html
i've been asked to generate some demographic reports (crime rates, birth/deaths, etc) based on state and cities for the USA. I have all the demographic data (provided by our client) but can't seem to find any places which have the boundaries (read: LAT/LONG's) of the USA States and their cities.
Our data are Lat/Long points of data (eg. a crime, a birth, etc) and we want to get some mapped reports and also datamine using Sql server (we're using MS Sql 2008, but that shouldn't impact this question).
So .. can anyone direct me to where there are some state and city boundary sources? I know our government has all this information available for free at the US Census Bureau, but i can't seem to understand where it's found and how to digest this info.
I'm assuming that this info will be in the form of lat/long polygons (eg. a shapefile, etc) which i can then import into the DB and mine away.
Can anyone help, please?
I can suggest the post http://adventuresdotnet.blogspot.com/2009/06/sql-server-2008-importing-tigerline.html
这篇关于美国各州和城市的Tiger/Lines或shapefile?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！