The National Institute of Child Health and Human Development
GIS Technology: Esri ArcGIS Desktop
Database Technology: Microsoft Access
2010 census data for this longitudinal research project was requested at the block group level for the latest round of data updates, which was gathered from both U.S. Decennial Census and the U.S. American Community Survey. Geospatial Research & Solutions needed to reconcile requested information with the information that was currently available.
The U.S. Census has processed those data that are available to varying degrees. Data that were readily available were found in American FactFinder, a U.S. Census sponsored website, and were downloaded as Excel files to be processed. Data that were not currently available in American FactFinder were downloaded as raw data from the census website in large text files, processed in Access to import the data and then re-processed for final delivery.