topic Re: OpenStreetMap Extension Object in QlikView

OpenStreetMap Extension Object

rbecher — Mon, 26 Jan 2026 16:26:21 GMT

This is an extension object which I made out of Alexander Karlsson's Google Map extension:

http://community.qlik.com/message/153412

It uses the CloudMade.com Web API to display OpenStreetMap tiles. This is a first version with marker custers and automate positioning dependend from the data selection. You can zoom and drag inside the map.

The extension needs Lat/Long as dimension and a marker label as expression, as you can see in my demo app. It was tested with QV11.

Any feedback is very welcome!

- Ralf

Caution: I have to mention here that a demo API key is used in the extension. If you realy want to use this in a production environment you should get your own personal API key at: www.cloudmade.com

Update: Alexander and I have improved slightly. Now you can enter the API key in the properties pane and you can switch the markers clustering

Re: OpenStreetMap Extension Object

Alexander_Thor — Thu, 30 Aug 2012 20:50:53 GMT

This is awesome, thanks for sharing!

Re: OpenStreetMap Extension Object

rbecher — Thu, 30 Aug 2012 20:53:42 GMT

Thanks! Still a lot to do, esp. selection of markers inside the map..

Hope there are no such limitations like on Google Maps.

Re: OpenStreetMap Extension Object

IAMDV — Thu, 30 Aug 2012 21:46:45 GMT

Super stuff! love it

Cheers,

www.QlikShare.com

Re: OpenStreetMap Extension Object

Gabriel — Fri, 31 Aug 2012 08:28:09 GMT

Hi Ralf,

This is cool stuff. Thanks for sharing.

Regards,

Gabriel

Re: OpenStreetMap Extension Object

Thu, 13 Sep 2012 19:01:56 GMT

Great stuff!

Re: OpenStreetMap Extension Object

Michael_Tarallo — Thu, 13 Sep 2012 23:51:13 GMT

Nice work!

Re: OpenStreetMap Extension Object

alexis — Fri, 14 Sep 2012 16:40:33 GMT

I followed your instructions, got my API key which I have entered in the parsameters, checked that my address is found in openstreetmap which it is but I dont appear to have the batch file startJSONproxy.bat Am I missing something?

I downloaded the FourSquareNew.qvw along with the qar file - when I double click the latter I get the message:

"In total 4 files in 1 directories where installed

Extension "CloudMadeWebMaps" installed and ready to use

Description: CloudMadfe Web <aps with Marker

Obviously without the batch file I get a failed to launch startJSONproxy.bat message

Can you help?

Alexis

Re: OpenStreetMap Extension Object

rbecher — Fri, 14 Sep 2012 16:59:08 GMT

Hi Alexis,

this thread is only about the extension object which can be used in every QlikView app with lat, long and a decription. If you want to check out the Foursquare app with the JSONproxy I can send you an actual version on Monday.

Just contact me by email: ralf.becher@tiq-solutions.de

- Ralf

Re: OpenStreetMap Extension Object

alexis — Fri, 14 Sep 2012 17:01:05 GMT

Cool thanx!

Re: OpenStreetMap Extension Object

chriscammers — Fri, 21 Sep 2012 16:14:01 GMT

I've been working on a modification to this that will provide different markers based on an additional dimension provided to the extension. I am looking at the Cloudmade site and I will address this question to them as well but when I get my own api key will I suddenly start seeing advertizing on the map. I assume I will have to get the "Select" license to avoid showing the ads.

I'm not looking for a detailed legal explanation of what we are obligated to purchase or display but your demo key does not show any ads and I am just wondering what to expect? I want to make sure I have my expectations aligned with reality.

Thanks

Re: OpenStreetMap Extension Object

rbecher — Sun, 23 Sep 2012 16:19:50 GMT

Hi Chris,

my API key has the Plan "Web Free" and the state "Unpublished". Maybe this helps..

- Ralf

Re: OpenStreetMap Extension Object

Thu, 29 Nov 2012 13:00:21 GMT

Thanks for a great plugin!

Just one question though. I have customers with a zip code which I translate to longitude and latitude using a script. Therefore alot of my customers get the same longitude and latitude. These are only shown as one customer on the map. Is there any solutionto this?

Re: OpenStreetMap Extension Object

rbecher — Thu, 29 Nov 2012 13:51:20 GMT

Hi,

maybe you can add a fraction of lat/long per client to spread the markers?

- Ralf

Re: OpenStreetMap Extension Object

Fri, 30 Nov 2012 07:53:26 GMT

Hi Ralf,

Thanx for the tip! Do you have any suggestions on how to do this. I right now have a load for customers and map data that looks like this:

Customers:
LOAD Customer, 
     PostalNumer,
     Sales
FROM
data.xlsx
(ooxml, embedded labels, table is sheet1);
MapData:
LOAD @2 as PostalNumer, 
     @10 as Latitude, 
     @11 as Longitude
FROM
[..\Downloads\SE (1)\SE.txt]
(txt, utf8, no labels, delimiter is '\t', msq);

Thanks in advance!

Re: OpenStreetMap Extension Object

rbecher — Fri, 30 Nov 2012 16:39:56 GMT

Btw. do you use the field Customer in the property Measurement?

Re: OpenStreetMap Extension Object

Mon, 03 Dec 2012 09:00:29 GMT

Right now i use sum(Sales) as measurement. But i might aswell use Customer.

Re: OpenStreetMap Extension Object

rbecher — Mon, 03 Dec 2012 20:42:48 GMT

If you use sum(Sales) all sales on the geo point will be aggregated. So, you will see only one marker per zipcode.

If you use Customer (-name) as measure you should see some amount of markers at one geo point (correspondingto the amount of customers at this zip code) ..

Re: OpenStreetMap Extension Object

Thu, 10 Jan 2013 08:24:44 GMT

Hello all,

can someone tell me how to make it possible to select markers in the map?

When I select a value in a field (in my version it is a cave) it will be selected in the map. But if I select a marker in the map I can only see the name of the cave in the map, the cave will not be selected in the field "caves".

The table caves has the fields name, lat, lon, description etc, the measurement in the map is defined as =[name].

I use my own API Key.

regards

Astrid

Re: OpenStreetMap Extension Object

rbecher — Thu, 10 Jan 2013 14:09:39 GMT

Hi Astrid,

if a marker is clicked the selection is made on the first dimension (latitude). You would see this in a selection box.

I know this is not a perfect solution. Maybe someone can help to improve this..

- Ralf