u.s. census data options for downloading and importing data into arcmap treg christopher oct 31,...
TRANSCRIPT
![Page 1: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/1.jpg)
U.S. Census Data U.S. Census Data Options for downloading and importing
data into ArcMap
Treg ChristopherOct 31, 2008
![Page 2: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/2.jpg)
Types of Census DataTypes of Census Data Decennial Census
◦ SF1:Sex,Age,Race,Hshld income, size Info for each field at:
http://factfinder.census.gov/servlet/MetadataBrowserServlet?type=dataset&id=DEC_2000_SF1_U&_lang=en
◦ SF2:Similar info as SF1 but detailed for each of 200+ ethnicities Guide for finding specific info:
http://ssdc.ucsd.edu/ssdc/cen2k/raceguide.pdf
◦ SF3:Long form…intensive info from a sample of people from each Block http://factfinder.census.gov/servlet/MetadataBrowserServlet?type=dataset&id=DEC_2000_SF3_U&_l
ang=en
◦ SF4:Similar info as SF3 but detailed for many ethnicities Community Surveys Economic Surveys
![Page 3: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/3.jpg)
Census Geographic FilesCensus Geographic Files TIGER (Topologically Integrated Geographic Encoding and
Referencing )◦ Source:
Variety of sources but mainly from1:100,000 USGS topo maps◦ Positional Accuracy (Horizontal):
National Map Accuracy standards for 1:100k is approx +/- 167 feet
Relationship betw/ scale and acuuracy: http://www.tceq.state.tx.us/gis/natmap.html
◦ Most sources have already converted these TIGER files into a more usable format (e.g. shapefiles) If not:
Use Toolbox in ArcMap (Need ArcInfo workstation installed) Use a 3rd Party conversion software
◦ Refer to: http://www.census.gov/geo/www/tiger/overview.html and http://www.census.gov/geo/www/tiger/faq-index.html for more info
![Page 4: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/4.jpg)
Census UnitsCensus Units
Block Group ID: 12 Digits= State (2) + County (3) + Tract (6) + BG (1) So you can always aggregate data and analyses from the single BG ID
![Page 5: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/5.jpg)
Data Sources for Census Data Sources for Census DataDataESRI Geography Network
◦http://www.esri.com/data/download/census2000_tigerline/index.html
Federal GIS Clearinghouse ◦http://gos2.geodata.gov
Vermont Spatial Data (at VCGI)◦http://www.vcgi.org/
U.S. Census◦American Factfinder at
www.census.gov
![Page 6: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/6.jpg)
ESRI Geography NetworkESRI Geography Network
![Page 7: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/7.jpg)
Project WorkspaceProject Workspace
Census SF1 Table
Census Shapefile
![Page 8: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/8.jpg)
Joining Tables to Joining Tables to ShapefilesShapefiles
![Page 9: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/9.jpg)
Download data for
entire state
Download data for AOI
(Area of Interest)
![Page 10: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/10.jpg)
VCGI Data for Entire StateVCGI Data for Entire State
![Page 11: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/11.jpg)
VCGI Custom SelectionVCGI Custom Selection
![Page 12: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/12.jpg)
VCGI Custom Selection of B-VCGI Custom Selection of B-tonton
![Page 13: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/13.jpg)
Data from Data from www.census.govwww.census.gov
or
![Page 14: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/14.jpg)
![Page 15: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/15.jpg)
![Page 16: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/16.jpg)
![Page 17: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/17.jpg)
Table Types in ArcMapTable Types in ArcMapTables can be added to ArcMap if
they are:◦Dbf files◦From a database (e.g. Access)
(Doesn’t have to be an ESRI personal geodatabase)
DBF not available in Office 2007!◦Import xls or csv file directly into
Access◦Import xls or csv file into Open Office
and save as dbf
![Page 18: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/18.jpg)
Import CSV file into Excel or Import CSV file into Excel or AccessAccess
Can usually skip this page unless Excel sets wrong
data type
ID showing
as # instead of text
![Page 19: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/19.jpg)
Boundary Files from Boundary Files from www.census.govwww.census.gov
Don’t use these..they have
generalized boundaries
(explained at: http://www.census.gov/ge
o/www/cob/scale.html )
![Page 20: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/20.jpg)
Appending Census Appending Census BoundariesBoundaries
What to do if you want a single, large coverage from multiple, smaller areas◦Copy the largest GIS file
(shapefile,pgdb,file gdb) and rename (e.g. “MasterCensusBnd”)
◦Use the Append command in ArcMap to merge these multiple files
![Page 21: U.S. Census Data Options for downloading and importing data into ArcMap Treg Christopher Oct 31, 2008](https://reader035.vdocuments.us/reader035/viewer/2022062518/56649f2a5503460f94c450e5/html5/thumbnails/21.jpg)
Comments for ProjectsComments for ProjectsIndices at:
http://www.census.gov/hhes/www/housing/housing_patterns/app_b.html
Panel/Longitudinal Study?◦i.e. how something changes over
time?◦Be aware that the actual boundaries
(and the unit ID ) may change between censuses