Timeline for How to find ZCTA for the 2010 Census block code?
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 2, 2017 at 13:58 | comment | added | SteveC | I'm glad it worked. Yes, there is more recent data from the American Fact Finder website. There are some limitations you should be aware of though. The 2010 data are from the decennial census so they are from the measure of the full US population. The data from other years are from the American Community Survey. Only the five year rolling survey covers all places regardless of size. Additionally, as the geographies get smaller (as in the case of blocks), the margin of error increases as this is a sample of the population. Neither of these are of concern with the 2010 data. | |
| Apr 2, 2017 at 10:31 | comment | added | Andrey | Success :) Thank you. BTW There is data for later periods (upto 2016). Did you try to use it? It looks like the format is different then in 2010. | |
| Mar 31, 2017 at 15:59 | comment | added | SteveC | Check your attribute tables for the original ZCTA file you downloaded from TigerLine and the newly joined file. You should be able to figure out the association between them. I believe your ZCTA code should be under the attribute "GEOID 10" but I may be remembering that incorrectly. I'm away from my laptop for the rest of the day so play around with those tables. If you cannot find it, zip that new shapefile and post it here. | |
| Mar 31, 2017 at 15:50 | comment | added | Andrey | Sorry. I was wrong, dbf file was saved together with shp. I suppose I got the same file as yours (my has 11040 records). But I can't find ZCTA there (in my and yours file). Please, advise. | |
| Mar 31, 2017 at 15:49 | comment | added | SteveC | You don't need to export to dbf. After you complete the join and view the attribute table to make sure the join worked you will export the joined file to a new shapefile. The dbf is one of several files included in what is referred to as a shapefile. If you use your file explorer in Windows to navigate to the location where you exported the newly joined layer you will see several files with the name of the shapefile followed by a unique extension. In Excel or some other spreadsheet software open the file with the ".dbf" extension at that location. That should be the table you want. | |
| Mar 31, 2017 at 15:07 | comment | added | Andrey | I've loaded both shapefiles and imported them with "Add data" menu. Then I clicked on 'tl_2010_08031_tabblock10' and selected these menus: 'Join and Relates' -> 'Join'. Then I've tried to choose the result file but the only working option for 'Save as type' was 'shapefile'. When I've tried to save it as 'Database feature classes' I got an error: 'An error occured trying to save object named "Join_Output"'. I also tried to save the result as shape file and then to make 'Export Data' as 'Database feature classes' but the same problem appears. | |
| Mar 30, 2017 at 20:42 | comment | added | SteveC | Actually that is incorrect. I used the file "tl_2010_08031_tabblock10" as the basis for my join and joined features as shown above from "tl_2010_08_zcta510". The file you are referring to is geography for counties, not blocks. You can find the block shapefile in the same area but you need to select blocks from the pull-down if you are using the web interface. | |
| Mar 30, 2017 at 19:32 | comment | added | SteveC | I'm away from my laptop right now. I'll confirm the file name in about an hour but I believe that is correct. I used ArcMap 10.4. ArcGIS Pro would be able to do this as well but the process is different. | |
| Mar 30, 2017 at 18:27 | comment | added | Andrey | Thank you. I'm trying to make the test. I have few questions? Did you use ArcMap (this is the only one I happened to install)? If Did you use tl_2010_08_county10 as county data? | |
| Mar 27, 2017 at 14:22 | history | answered | SteveC | CC BY-SA 3.0 |