This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've figured out that this is a UTM coordinate system and can get Alteryx to render the polygons. The problem is that they're in the wrong location. As soon as I can figure out the projection zone settings and get this in the right place, we'll be set. It seems like it should be in zones 13N-15N, but it keeps putting it in the Pacific Ocean south of Mexico.
Was there not a .PRJ file associated with the Shape file you received? When I save a .shp from Alteryx, a SHP, SHX, DBF, and PRJ file are produced. Alteryx could read this file directly, or we could view that PRJ file in a text editor to get the relevant information.
Assuming we are able to either obtain the prj file or figure out the "zero" point we need, is Alteryx capable then of producing a file which can be used as a background map in Tableau? For example, a .tms file or similar? I've done quite a bit of work with custom maps in Tableau before, but the files were always provided to me. At one point, even The Information Lab in the UK provided me with a map source file.
I enjoy a good projection problem so I wanted to take a shot at this. After trying a few UTM projections which clearly weren't correct, I landed on Iowa State Plane South - does this screenshot appear to draw the polygons in the correct locations?
Here's a link on Tableau Public for a map I created by hand several years ago. If you change the school level to High School, it should match what we have in these shape files. I have additional shape files for the elementary and middle schools.
Yes, once you have the projection issue fixed you should be able to use Alteryx to write out the data to a spatial format that is supported by Tableau (I think I read somewhere in this thread that Tableau can now use .shp format directly, which is awesome).
If you are having trouble with the workflow version, here is the projection info I used. You can set up your input tool to specify this projection:
1. Select the input tool
2. Select Projection under the Options list
3. Under Find Projection, search for NAD 1983 State Plane Iowa South FIPS 1402 FEET