TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Ask HN: Where can I obtain location based db for all the schools/univs?

7 点作者 expertcs超过 14 年前
I am developing an app where I need to provide a list of all the schools, universities, and training centers based on location. Are there databases available with such information that I can obtain for free or paid? Any help in general for obtaining such information will be appreciated.

1 comment

bigsassy超过 14 年前
The TIGER data set may have what you're looking for. It's essentially government data collected during the Census. In it's technical documentation, it has special MTFCC codes for Universities as well as Schools/Academys that you could query on (WHERE MTFCC IN ('K2540', 'K2543')). See section 6-155 here:<p><a href="http://www.census.gov/geo/www/tiger/tgrshp2010/TGRSHP10AF.pdf" rel="nofollow">http://www.census.gov/geo/www/tiger/tgrshp2010/TGRSHP10AF.pd...</a><p>Take this with a grain of salt, but I believe you'd want to pull the data out of the following shape files:<p>ftp://ftp2.census.gov/geo/tiger/TIGER2010/POINTLM/<p>These files are brand spanking new, and in fact not all the data has been added yet (5 states are missing). The entire dataset for 2010 will probably be up by the end of the month.<p>You can see the layout of the shape file here (see Landmark (Point) Shape File Layout in section 6-104):<p><a href="http://www.census.gov/geo/www/tiger/tgrshp2010/TGRSHP10AA.pdf" rel="nofollow">http://www.census.gov/geo/www/tiger/tgrshp2010/TGRSHP10AA.pd...</a><p>For what it's worth, it looks like the TIGER dataset also has school district info, which could allow you to lookup a person's school(s) based on their address (reverse geolocate their address and use the coordinates to query districts where the point exists).<p>If that doesn't work out (or it's missing some data) you could try looking at these websites:<p><a href="http://gos2.geodata.gov/wps/portal/gos" rel="nofollow">http://gos2.geodata.gov/wps/portal/gos</a><p><a href="http://www.data.gov/catalog/geodata" rel="nofollow">http://www.data.gov/catalog/geodata</a><p><a href="http://nationalatlas.gov/" rel="nofollow">http://nationalatlas.gov/</a><p><a href="http://simplegeo.com/" rel="nofollow">http://simplegeo.com/</a><p><a href="http://market.weogeo.com/" rel="nofollow">http://market.weogeo.com/</a><p><a href="http://data.geocomm.com/" rel="nofollow">http://data.geocomm.com/</a><p><a href="http://geocommons.com/" rel="nofollow">http://geocommons.com/</a>