I am trying to create a database in SQL Server with a customized dataset containing census information from the American Community Survey content available online. I want to show a granularity in my dataset and would like to download blocks & census tract level data of USA for 5 or 3-year timeframe ranging from [2009-2013]. I tried several methods to download both blocks & census tract level information. I could not get my hands on a data that would let me create tables and import values to them from the downloaded files.

I downloaded the block level data present in the PostgreSQL database section mentioned on the following link

and got one 15GB file in the FILE format. Then, I tried to download a block group level data for USA from the link mentioned below

and that gave me a collection of gdb related files. After which, I followed a couple of video and pdf tutorials to download content similar to this and got a lot of data with tons of label names with no reference. Could someone please help me obtain a good dataset in a usable format that contains block or census tract level information.

Your Answer

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

Browse other questions tagged or ask your own question.