00:00
290
More
See all Show me
Joe Mako's videos
Preprocess shapefile for Tableau Tutorial Video:

1. Get your shapefile
2. Open shapefile in Quantum GIS (QGIS)
3. Copy attribute table data to a text file
4. Run my VBScript on the text file to generate two text files ready to be dropped into Tableau

VBScript:
makomethod.com/files/qgis_to_polygon.zip

Quantum GIS (QGIS):
qgis.org/

Credits

Likes

Tags

  • taylor mokris 1 year ago
    Joe - where can I get a zip code file?
  •  
  • taylor mokris 1 year ago
    Actually found the zip files...

    census.gov/geo/www/cob/z52000.html#shp
  •  
  • taylor mokris 1 year ago
    Joe - now how do I blend external data into the coloring? Say I have a file with the population per state, how do I color the states by this population?
  •  
  • Tom Brown 11 months ago
    Joe, I have done all this, seemed to be working great, but I fall at the final hurdle - it seems I might have a shape file using some other co-ordinate system than Lat/Long - possible eastings/northings as is often used in the UK. Do you know if this is even possible?

    Cheers

    Tom
  • Joe Mako plus 11 months ago
    Sounds like you need to change the Coordinate Reference System (CRS) used in the shapefile. With QGIS, you can add the vector layer, and then right-click the layer in the layer list, selecting "Save as..." and then you can set the CRS.
  •  
This conversation is missing your voice. Take five seconds to join Vimeo or log in.

Advertisement

About this video

MP4
00:04:50
  • 800x600, 12.85MB
  • Uploaded Mon February 14, 2011
  • Please join or log in to download
1 Related collection

Statistics

Date Plays Comments
Totals 877 2 5
Feb 23rd 1 0 0
Feb 22nd 2 0 0
Feb 21st 3 0 0
Feb 20th 2 0 0
Feb 19th 2 0 0
Feb 18th 0 0 0
Feb 17th 1 0 0