A shapefile will come in the form of a group of several similarly named files with different extensions. These shapefiles will normally include some geographic attribute data such as names and id codes, but are mostly data-less. For the purposes of this guide we will be using a shapefile of the United States and joining it with population data.
Preparing your data
In order to join the two, you must ensure that both your data and your shapefile share a field or column with common values, called a key. This is often a name or ID code. In your data table, these identifiers must be unique, meaning one row per name or ID. Joining works by adding fields from your data table to the shapefile’s attribute table based on matching values found in the key columns.
In this example, the key in our data table will be
geoid. As you will soon see, there is a corresponding field in our shapefile. It would also be possible to use the name field here, but it is often risky to use place names due to the possibility of typos or spelling discrepancies.
Once your data is looking good you will want to save it as a .dbf file. This is the format that shapefile’s use to store data. Open your data in LibreOffice Calc and save it in .dbf format.
CSV format can also be used, but there is an extra step that must be done before joining. See the section at the bottom of this guide for more on this.
check this link:Joining data to shapefiles | Mapbox
Thank you Tharashasank.
Sorry for not making my initial question clear. I am not asking how to join demographic census data to a shape file. What I am asking is how to convert a TIGER-line gdb file to csv.
Just following up on this thread. Basically GIS files don't translate directly to CSV, but check out this company at this site:
for more information. Looks like they are more "Tableau-friendly" now.
Let me know if you have more questions.
Thank you Thomas. Maybe Alan Walker could come to our assistance. I have downloaded both of his TIGER-line Tableau census-tracts and ZCTA files but I can't really do anything with them. As soon as I go into the DATA tab Tableau crashes. It is not the machine either, because I am using a 64-bit desktop with more than plenty of GBs of RAM.
You can get the TIGER/lines data in the form of a shape file. Tableau handles .shp files quite well. The shape file comes with the 5 digit ZCTA code and polygon spatial object that defines the boundary, the GEOID, census classification, total land and water areas and the Zip Code approximate lat and lon of the centroid.
and select FTP site - ZCTA5 folder
There you should find a zip file with the current set of Zip Code shapes. (Note: the US Census file does NOT have all zip codes. It does not include sparsely populated areas or areas with exclusive geographic features like mountains or bodies of water)
Thank you Tim. I have mastered the suggested process already However for the benefit of other readers of this thread, you need to keep in mind that there will be count overlap if your original data set is measuring by any other geography, namely Zip Codes.