article Digitizing floor plans for use in Qlik GeoAnalytics (QGA) in Qlik Sense Documents

Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Patric_Nordstrom — Fri, 02 Apr 2021 08:18:51 GMT

Update, the example app now have the drawing as a background.

Floor plans and cad drawings can be useful, for instance in production dashboards, to visualize status and flows in a factory. However cad drawings are in many cases a mess to work with.

Here's a simple, pragmatic approach to digitize rather than import the actual drawing. The major issue with most CAD drawings is lack of structure, details without meaning and the objects on the right level are missing. It’s not the format or alignment that is the problem. In many cases it's better to use the drawing as a input to produce the polygons and information needed.

In this tutorial I use QGIS for digitizing and out put to a format that is easy to import to QGA. In this example the drawing is digitized in a local reference system, ie no alignment is made with the rest of the world.

Step-by-step guide

Install QGA basic, Plus not needed if Dropbox et al is used.
Install QGIS (https://www.qgis.org)
Get a picture of the floor plan in an image format like PNG or JPG.
Drag and drop the image to the layers panel of QGIS. Choose a meter based Coordinate Reference System, for instance EPSG:3857 is a good choice.
Layer→ Create Layer→ New Shapefile Layer... Choose Polygon, same CRS, 3857. Add "Name" text field for convenience.
Save layer in a folder. Preferable in dropbox folder.
Right click on the new polygon layer and "Toggle editing" to start editing.
Start adding features (Ctrl +)
Click on the edges of the desired polygon, set id and name. Use node tool if fine tuning of edges is necessary.
When done "Toggle editing"to save.
Zip the shapefile to an archive and get the dropbox url. (replace www with dl to get direct link)
Create a new Sense app and use the drop url in the Load operator of QGA connector. CRS: EPSG:3857. Note change url from 'www' to 'dl' for direct file access in dropbox.

Example app

The example app features sites and a drawing visible when one site is selected.

If you want to add and image background, here's how to scale and translate the image, in my example:

Tip 1: get a white background use ='[[ [-180, -80], [-180, 80], [ 180, 80], [ 180, -80], [-180, -80] ]]' for location, set color to white and make the layer non selectable and not part of autozoom.

Tip 2, Use a bubble layer with coordinates for different sites, when one site is selected turn on drawing and the white background.

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

jfdierckx — Thu, 22 Nov 2018 06:34:35 GMT

This is a great way to leverage Geoanalytics !

Is there a way to get the original floor plan drawing as a background for this map ? This would allow to have other layers (such as points and density layers) directely on top of the drawing.

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

paulriedel — Mon, 17 Dec 2018 08:18:46 GMT

Hey @Patric_Nordstrom,

is there any chance of putting drawings as background layer within the map (regarding @jfdierckx's question)?

Thanks Paul

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Patric_Nordstrom — Mon, 17 Dec 2018 17:36:50 GMT

Hi,

Plain png image as background is on the roadmap for the native Qlik map chart for 2019.

Meanwhile check out Christof Schwarz work:

https://www.youtube.com/watch?v=4uWlmNm95n8

Thanks,

Patric

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

joe_warbington — Tue, 05 Mar 2019 15:59:14 GMT

This is among my favorite innovations at Qlik! Thanks @Patric_Nordstrom for writing out the process to make things like this possible: the Qlik Body Map app.

Qlik Body Map app

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Patric_Nordstrom — Tue, 05 Mar 2019 20:45:47 GMT

Thanks @joe_warbington !

I made a custom guide for converting an image into map, check this post:

https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Image-to-Map/ta-p/1552580

Thanks,

Patric

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

keshu00_09 — Mon, 15 Apr 2019 06:07:02 GMT

Hi @Patric_Nordstrom ,

I was implementing the steps as mentioned by Christof Schwartz to map a floor pan in Qlik Sense. However I am facing an issue. I have done all the steps asked by you but my floor pan is not mapping the points correctly. Its able to map the Latitude co-ordinates correctly but the longitude coordinates are not being mapped. So essentially i am getting all the points in a straight vertical line. Could you help me out?

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Patric_Nordstrom — Sun, 28 Apr 2019 07:54:10 GMT

@keshu00_09

Please check out Qlik Sense April 2019 ,the native mapchart now can have a plain image background, it's easier than the TMS approach unless the image is extremely big.

Thanks,

Patric

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Radu — Mon, 06 May 2019 11:18:05 GMT

Hi Patric, I am trying right now to insert an image layer in a map chart but I can't seem to succeed due to:

1) Chart size (looks like I need huge images to adapt to the chart and not to be displayed as small pins

2) Setting the upper left and lower right coordinates in order to fill the chart as best as possible with the image

and so on...

Is there any tutorial (except the help pages) that could point me to the required steps?

Thanks,

Radu

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Patric_Nordstrom — Wed, 08 May 2019 19:54:04 GMT

Image as map background

Having an image is a quick way to add floor plans or drawings to the map.

Usage

1. Set the map to blank projection and projection to undefined meters.

2. Add url to image (png, jpg, gif) (svg except in IE).

3. Define top left and bottom right, pixels is easiest.

4. Optional, add any layer on top using pixels as coordinates. Note that image software usually have origo in topleft corner while the geographic origo is bottom left.

Floor plans can also be added as CAD drawings but most of time the drawings are too messy and tends lacks the structure you want.

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Patric_Nordstrom — Wed, 08 May 2019 19:54:09 GMT

Image as map background

Having an image is a quick way to add floor plans or drawings to the map.

Usage

1. Set the map to blank projection and projection to undefined meters.

2. Add url to image (png, jpg, gif) (svg except in IE).

3. Define top left and bottom right, pixels is easiest.

4. Optional, add any layer on top using pixels as coordinates. Note that image software usually have origo in topleft corner while the geographic origo is bottom left.

Floor plans can also be added as CAD drawings but most of time the drawings are too messy and tends lacks the structure you want.

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Radu — Fri, 10 May 2019 08:49:08 GMT

Thanks for the tip Patric,

In the meanwhile I found this useful tutorial on youtube:

https://www.youtube.com/watch?v=hml7wX4O7Lw

And also there is a community post (with and example qvf attached):

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Adding-a-background-layer-in-Qlik-Sense-maps/ta-p/1576490

I also found out that for the moment there is no direct loading of local images, one has to set up an IIS locally to access them via URLs...it might be useful for the dev road-map to have also this functionality available (local files loading from file-system not URL). The thing that currently really beats my mind is how to set the bubble size according to the dimension / measure value.

Thanks

Radu

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Patric_Nordstrom — Fri, 10 May 2019 09:03:44 GMT

One way would be to use a Base64 data URI as the URL string.

https://www.base64-image.de/

Or to upload the image to the QS media library and then find out the URL to the image with JS dev tools F12.

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Radu — Fri, 10 May 2019 09:45:03 GMT

Thanks, for those in need here is a tried and verified setup:

1) The folder to load images from could be any custom XXX folder under:

...AppData\Local\Programs\Qlik\Sense\Client\img\...

2) The URL should look like:

='http://localhost:4848/resources/img/XXX/YYY.png'

@Patric_Nordstrom : I am still struggling with the topleft and rightbottom values according to the height/width value from the custom image in order not to have the image shrink inside the object canvas...

I thought that according to the above mentioned tutorial I need a loading script that should have this section:

bounds:
load * inline [
bid,by,bx
topleft,461,0
bottomright,0,909
];

where first parameter after topleft = image height (in pixels)

and second parameter after bottomright = image width (in pixels)

After that in the Background layer the Top (latitude) = image height (in pixels)

and Right (longitude) = image width (in pixels)

But still the image is not centered and shrinked inside the object canvas. Do you have any hints why?

Thanks

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Patric_Nordstrom — Fri, 10 May 2019 13:20:29 GMT

Please check settings in the app from the post.

In that example the image is 1182x1915px.

Btw, serving images from localhost won't work in a network. Better to use the full URL.

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

pwagner — Fri, 15 May 2020 10:05:35 GMT

Hello,

@jfdierckx and @paulriedel have you already found an solution to bring in the background image into the GeoAnalytics map?

I can create the shapefile in QGIS and I manage to load to shapefile into Qlik Sense with the GeoAnalytics operations 'Load'. Furthermore the polygons are on the GeoAnalytics map.

But how can I add the background image to the GeoAnalytics map? @Patric_Nordstrom or @ChristofSchwarz do you have an advice for me/us? Or should we use the 'standard' Qlik Sense map instead of the GeoAnalytics map for custom maps?

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Rolando_Montero — Thu, 14 Jan 2021 00:47:21 GMT

Hello Mr. Patric,

I am trying to do the same but with car parts. I manually drew the borders following an image which I later uploaded to a Qlik Sense library. I having some issues with the coordinates that are required to align both the image and the layer drawn in QGIS (I am using version 2.18.28). I have two questions pertaining to this:

Is there a way or method to get exactly the coordinates you need to align the image with the layer? If you see image 01, the image of the engine parts is not aligned with the shape layer. On the right, the pickup truck has a subtle difference at the back between the image and the layer; nevertheless, they are not in alignment with one another. In order to solve this, I tried a couple of numbers to no avail. As I mentioned before, the images in Qlik are the same ones I used to draw the lines in QGIS.

Am I missing something while exporting the shapefile from QGIS? Maybe, the scale of the image (Image 02.)

(Image 01)

(Image 02)

Best regards

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

Patric_Nordstrom — Thu, 14 Jan 2021 14:00:33 GMT

@Rolando_Montero

I would do small adjustment in the xscale "right (longitude)" (see my figure above) to squeeze the image width. That would probably do it.

Thanks,

Patric

Re: Digitizing floor plans for use in Qlik GeoAnalytics (QGA)

pedrohenriqueperna — Wed, 11 Dec 2024 20:06:00 GMT

@Patric_Nordstrom

Hi!

I'm trying to build something similar, if not exactly the same, but I'm having trouble combining the image and the shape/polygons in the map. Maybe you could give me some tips?

I have a floor plan of a retail store as an image that I wish to display in the map, along with an 'area'/shape dimension on top of if, just like you did in QGIS.

The problem is I'm not very familiar with maps in Qlik and I'm assuming this tutorial was made for desktop version, not SaaS, is that right?

What exactly is the QGA basic and plus? Do I really need to use dropbox?

I'm assuming I have to use this QGA Connector to add both the shape file and image, that's why you zipped the file, is that so?

Basically, I added the image to QGIS and manually drew the polygons to form the areas. For each polygon I drew I've set an ID. Finally I've exported the layer as KML and opened in the Qlik SaaS map object, which after changing some settings (no base map, projection, etc.) I managed to display the shapefile correctly, with selectable areas. Then I tried adding the floor plan image as a background layer using an url link, and it did work, except I can only display the image if I use "user defined meters", while I can only display the shapes if I select "mercator". I guess it has something to do with the coordinates type in the KML. I obviously need to set a coordinate for the image, I'm just not sure how to do it.

How can I combine the image with the shapes? How to match the coordinates for the image if it's a plain image?

The result I except is something similar to the image below: