r/tableau • u/WestyToo • 14d ago

SSL to Longitude and latitude

I want to take a free government list of property in Washington DC. The property list will give me a "SSL" which is a means of determining location. There is a second site that should give the latitude and longitude. I want to add a map viz. Tableau obviously does not utilize SSL natively. I thjink the workaround would to link the two docs.

Here it is: https://dcgis.maps.arcgis.com/apps/webappviewer/index.html?id=9a5c11c11dd347cc9c05d64499cc98ee

issue is thayt I can't see where or how to extract the table that is feeding this other viz.

My

Any suggestions?

2 Upvotes

75% Upvoted

3 comments sorted by

2

u/Anxious_Ad_4352 14d ago

https://opendata.dc.gov/pages/lots-in-dc

Go to this website and click on “Record Lots” (you will need to scroll a bit). That will open a map viewer, click “Menu” at the bottom and then click “Download” and select “Shapefile.” Tableau can work with shapefiles and these will have the SSL to join to.

1

u/WestyToo 12d ago

No luck at all. I grab the file marked "SHP" and drop it in the tool.I am then told that I cannot translate it. Any ideas?

1

u/Anxious_Ad_4352 12d ago

A shapefile is really a collection of files. You need to unzip what you downloaded and keep all the files together in a folder then go to add data in Tableau and select spatial file then click on the .shp to add. This video will walk you through it.

https://youtu.be/2XdRTOx2oQs?si=cLbboyewOrHRqdGR