TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

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

7 pointsby expertcsover 14 years ago
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

bigsassyover 14 years ago
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>