Today someone asked me if they could use an event floor plan as a map in Looker.
Since it took me a little bit of work to figure out the easiest way to do this, I thought I would spare you the effort by posting my method out here.
From a power point:
To this map in Looker
###Process
Which allowed me to eventually build this:
For each of the shapes created, selecting them on the map allows you to add attributes.
These attributes are the values Looker will be trying to link the dimensions to.
They are crucial to be able to map the table results to the map in Looker. (Notice the id field in the example)
Save your newly built map as a TopoJSON. (There is a button for that)
Open the TopoJSON file
Note the part at the end of the file looking like this: "transform":{"scale":[0.000775077507750775,0.0005000500050005],"translate":[0,0]},"bbox":[0,0,7.75,5]}
Modify the scale
part to be "transform":{"scale":[1,-1],"translate":[0,0]},"bbox":[0,0,7.75,5]}
This will allow a correct projection and representation in Looker. (However it will not display correctly in gistโs maps anymore.)
The rest of the process is the same as when using TopoJSON of โrealโ maps and can also be used as map_layers.
(For further details on this part please see this article.)
Load the TopoJSON in a gist.
Copy the URL from the โRawโ code.
Use the CDN URL provided by the โgist raw codeโ in Looker for your new map to appear.
Thanks Seb! Iโve just tried it out ๐
The last few links (raw gist and the Looker article) are now broken, but once I loaded my TopoJSON file to gist and then copied the URL from the โRawโ code, I had no trouble visualizing my data with Lookerโs custom maps option! Thanks for the guide.
Thank you Ruth!
Iโve updated the article with the new link and where to get the Raw link from gist directly.
Hi Sebastien! Thanks for sharing this article!
Iโm wondering how the โidโ attribute links to dimensions in tables? Is there an โidโ dimension in the tables in Looker?
Can this static map be visualized as a heatmap based on a measure, like a count of users in the region?
Thank you!
Omg this is so helpful. Searched across tons of posts finally found this and solved my problem ๐