0:00Hey, it's Tim here. In today's video I'm
0:01covering a few features from 2021.3 that I
0:03hadn't covered
0:05and this one I'm covering is WKT or GeoJSON
0:08support. Now this is a bit of a weird one
0:10because
0:10I always thought these file types were
0:12already supported but actually when you dig
0:14into the
0:14details this is a very particular way of
0:16supporting these spatial files. Just to
0:18show you how this
0:19works let me go over here to a text file
0:21option. So typically when you connect to
0:23spatial datasets
0:24you go to the spatial options but this one
0:26you can actually go to a slightly different
0:28file type. So
0:29in this case I'm going to open up this tab
0:32separated file this TSV. If I click open
0:35you'll
0:35see that it opens this data source which
0:37has a data source over here and you can see
0:39that Tableau's
0:40brought it into its data model over here on
0:42the left. Now the important thing to notice
0:44here is
0:44that the sample county is the name which is
0:47fine but you can see my polygon data is
0:50actually
0:50contained in text inside of the file. So
0:53essentially if I open this file up let's go
0:56ahead and do that
0:57now very quickly. If I go over here to this
0:59particular file and just click open and it
1:02's
1:03going to ask me what to open it in. I'll
1:05just open it in WordPad just so you can see
1:06the file.
1:07You can see the data is actually there it's
1:09just held as text so it's not very a good
1:12format to
1:13connect to. Now previously what you'd have
1:15to do is you'd have to run a script to kind
1:17of get all
1:17of that set up into a shape file then you
1:19could bring it into Tableau but with this
1:21feature you
1:22can just go here to where it says abc and
1:24select the spatial option and there you go
1:27Tableau turns
1:28it into a polygon straight away and when we
1:30go to sheet one we can double click the
1:31polygon and
1:32voila we have the spatial data ready to
1:35visualize. Now I googled a bit about the w
1:38kt and geo json
1:39support and I actually found that this is
1:41actually quite a painful thing to do.
1:42Normally people have
1:43to run scripts to do this and it's just
1:45nice that Tableau has this ready to go so
1:47if you use Tableau
1:48this might be already a really good way of
1:50making sure that you've got the data set
1:51ready to go
1:52and you can work with it. Now you saw me
1:54open up a tsv that's essentially just a
1:56text file it's
1:57very similar to csv you could also do the
1:59same thing in excel it's no different it's
2:01exactly
2:02the same setup. Now what I'm going to do is
2:04open up a geo json file just to see how
2:06that works
2:06differently so to do this I'm actually just
2:08going to add a different spatial file here
2:10and I'm just
2:11going to go to the spatial file option
2:13because a geo json is actually a spatial
2:15file format and
2:16you can see here that I've got the file on
2:18my desktop. Let's go ahead and open that
2:20and when
2:20we open up we get the standard sort of view
2:23here that we're supposed to get and you can
2:26see here
2:26that I actually do get three different
2:28names and the three different polygons and
2:30it's automatically
2:31supported. If I go to a new sheet here and
2:33I just go ahead and put geometry on color
2:35just to make
2:36sure we've got everything we need. Actually
2:38I need to put name on color just so that we
2:39make
2:40sure we've got those three things set out
2:41and this is a slightly different sample
2:43data set so
2:44it looks slightly different to the previous
2:45one and you can see that we've got the
2:47three polygons
2:48there there's one there there's one here
2:49and there's one there and that's all
2:51working nicely.
2:52So again very easy to connect to these file
2:54types and get them working. That's pretty
2:56much it for
2:56the feature there's not much more to that I
2:58'm not a spatial expert so if you've got any
3:00questions put
3:00them in the comments below and I'll try and
3:02do some research to try and answer them in
3:03the future.
3:04Thanks for watching and I'll catch you in
3:06the next video.
Tableau | Data visualisation | Data prep