Where can I find (on the site of a US government agency, I assume) raw data for the sizes of cities that I can programmatically process? Data indexed by FIPS place codes (i.e. those found here) would be optimal.

  • I'm on my way out but check out the US Census, and Tiger, also google should have plenty of answers, but try the dot gov websites first – dassouki Nov 5 '11 at 1:31

You can download the Census Bureau's 2010 TIGER/Line shapefiles of "Places" (at the state level) through their web interface. All of the features have a FIPS value. I believe these shapefiles include an area field but, if not (or if the area is given in units other than what you're looking for), you can easily create a new field and have the areas calculated automatically.

If all you're looking for is a table of data, download the shapefiles and simply use the .dbf file.

  • Thanks, that definitely looks helpful. I'm actually not familiar with processing GIS data in shapefile format... do you know of any way to get the data in a more basic flat text format? – jrdioko Nov 7 '11 at 18:36
  • @jrdioko you should be able to import the .dbf file from a given shapefile (which is not a single file, as the name suggest, but a collection of a few different files sharnig the same name but different extensions) into Excel and then save it out to whatever format you'd like to work with (XLS, TXT, CSV, etc.). – nmpeterson Nov 7 '11 at 18:46

You could try http://www.geonames.org/ - they have a map viewer so that you can look at the data before downloading, and a variety of ways to get the data, including an API and data dumps.

  • whoops, just saw the geonames link in your post. Is there a problem with Geonames data? – Stev_k Nov 5 '11 at 0:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.