Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am a complete newbie at GIS data, and am trying to do the following:

  1. Figure out census blocks in Miami-Dade (and several other counties) that have average household incomes > $75,000
  2. Get the latitude-longitude boundaries of those blocks
  3. Plot the blocks on a map

1 and 2 are the most important. What is the best way to get this data, and then the lat-long boundaries? Quickest, easiest, cheapest are of course the top criteria.

Thanks so much!

David

share|improve this question
2  
Hi David - we could probably give you a better answer if we knew what software you had access to. Or do you need help choosing the right software as well? –  Jason Baker Apr 19 '12 at 14:25
    
Yeah, definitely need advice on software. At this point I only have Excel. –  davidtspf Apr 19 '12 at 18:45
    
@davidtspf -the income details are in Summary file 3(pls read census.gov/prod/cen2000/doc/sf3.pdf).. –  vinayan Apr 20 '12 at 4:44
    
Very simple: www.incomesnoop.com. Gives income data directly from address. –  JT A 12 hours ago
    
I want to point out that website requires you enter a specific address to get a predicted income level based on Census tract information, according to their about page. It is not true block level information. –  Chris W 6 hours ago

3 Answers 3

Well if you were doing it in ArcGIS then it would probably be easier to do it in the opposite order. There is US Census data freely available.

Boundary files are here: http://www.census.gov/geo/www/cob/

Then you just need to append the data onto the attribute table. If you already have the average household income data with Census Tract IDs attached, it's a simple matter of joining the tables together. A join is done in ArcGIS based on fields, so if you have two Tract ID fields, join based on that (right click in table of contacts and choose join, then join by that field). Then go to the Selection menu, pick "Select by attributes" then write something in the field like

"income" > 75000

And it will select all tracts with those characteristics. Then you can export the data into a new shapefile (right click in the table of contents and choose export, and ensure you export it as a shapefile rather than a layer file, and choose to export the 'currently selected features')

There you have it. :)

share|improve this answer
    
Thanks! Where do I get the block-by-block income data? –  davidtspf Apr 19 '12 at 18:46
    
And, how do I get the latitude-longitude coordinates for each block with > $75,000 average? –  davidtspf Apr 19 '12 at 18:47
    
And note, we don't have ArcGIS, just Excel. –  davidtspf Apr 19 '12 at 18:49
    
I'm not really familiar with the US data so much, but the reply below has the data. Are blocks generally equivalent with Census Tracts or are they a finer level? Sometimes here the finer level data is not available easily, for example, we have dissemination blocks which are the lowest level and the data is only available for purchase or by academic researchers. The coordinates are inherently in the shapefiles which you download. You can open the dbf file that is part of the shapefile package and it should have information in it pertaining to coordinates. 1/2 –  Emily Apr 19 '12 at 18:57
1  
You may want to download GIS software, an open source one possibly like QGIS (qgis.org), in order to conduct the analysis more easily. I can't emphasise enough that it would be far easier to do in GIS software than not. 2/2 –  Emily Apr 19 '12 at 18:59

Be warned, joining census data to census tigerline shapefiles is a bit more complicated than a simple join. Downloading 2010 or 2000 Census Blocks is simple enough and can be found here:

http://www.census.gov/geo/www/tiger/tgrshp2010/tgrshp2010.html

When you select the file type you want there will be an option to download either the 2010 or 2000 version.

To get income data you will need to get it from the 2000 census because I don't believe income data has been release in the 2010 census yet. 2000 Census data can be found here:

http://www.census.gov/main/www/cen2000.html

You will need to find what summary file contains the information you want. Each summary file is broken out into multiple files containing different attributes so you will need to find which one has the attributes you want. There is also a geographic header file that you will need as well.

In summary you will need to extract the data you want, convert to excel spreadsheets, join the summary file attributes to the geographic header file then join that to the census geography. Make sure you using the correct summation level joining the data.

Reading the technical documentation is immensely helpful.

Good luck, hope this helps.

share|improve this answer
    
Thanks for your expansion, to be honest, I rarely if ever work with US Census data, I use Canadian datasets which are easily and readily joinable without a lot of effort. –  Emily Apr 19 '12 at 17:17
    
Yeah, I got the summary files but had no idea what to do with them. What programs are best to use them? –  davidtspf Apr 19 '12 at 18:46
    
See my above comments about dbfs –  Emily Apr 19 '12 at 18:59
    
you need to unzip the summary file. It will have comma delimited text files within that can be opened in Excel. Use tech doc to identify the one you want. –  Boyle300 Apr 19 '12 at 19:24

I don't think you can get income data at block level for privacy issues. For blocks, you can only get population and households. As far as I know, the lowest level of geography you can get income data for is block groups. Block groups typically contain between 600 and 3000 people, have an optimal size is ∼1500 people and ∼30 blocks, though in Miami-Dade BGs might be smaller. Block group boundaries follow visible and identifiable features and they tend to be fairly demographically homogenous. Starting in December 2010, five-year period estimates are available for census tracts/block groups from American Community Survey. That data will give you the lat and lon for the centroid of each block group. You might be able to even make the map using the Map View in FactFinder.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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