Download multiple census tiger files

The polygons allow you to Join economic and demographic data. They contain data items such as total population, total housing units, median age, population 16 years and over, population 65 years and over, race, relationship, average household size, and many others.

Some of the files are huge. TIGER overview. Select the tab for the year you want; generally the most recent will be best. When the data is first released, sometimes only the FTP interface is available.

It can be a little harder to use, so consider if you can use the previous year's data, since typically there are not many changes.

Maksim Maksim 6, 2 2 gold badges 20 20 silver badges 41 41 bronze badges. Add a comment. Active Oldest Votes. After installing and starting your FTP client software: Connect to ftp2. Improve this answer. Of course this is fine for getting the data, but you still have to unzip each of those files, one-by-one.

The solution I proposed automates the entire task from data acquisition, through unpacking, reprojecting via ogr2ogr if desired , and finally ingest into your DB instance. Im having an issue where the connection is timing out, and unable to connect to ftp2.

Some sample code would be beneficial. Maksim - try a couple of files, one at a time, first to see if you're still getting a timeout issue. You may have to set the transfer mode to passive in order to download multiple. The software's Help will show you how to do that. Says it times out, so unable to try files one at a time or at all. Show 3 more comments. AddError e. Adam Thom Adam Thom 1, 2 2 gold badges 16 16 silver badges 29 29 bronze badges.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Who is building clouds for the independent developer? Exploding turkeys and how not to thaw your frozen bird: Top turkey questions Featured on Meta.

Now live: A fully responsive profile. Reducing the weight of our footer. Related 5. Hot Network Questions.