OnlineMap - Location

Stimulsoft Dashboards.WEB discussion
Post Reply
d.boifava
Posts: 15
Joined: Fri Apr 07, 2023 4:00 pm

OnlineMap - Location

Post by d.boifava »

Hi, which data should i insert into the value "location" of the OnlineMap?
I have tried to use PostalCodes but it doesn't work.
Here's my data:

CREATE TABLE CittaLombardia
(
Citta varchar(50),
Latitudine float,
Longitudine float,
PostalCode int,
Value int
);

INSERT INTO CittaLombardia (Citta, Latitudine, Longitudine, PostalCode, Value)
VALUES
('Milano', 45.46427, 9.18951, 20121, 100),
('Brescia', 45.53558, 10.21472, 25121, 200),
('Bergamo', 45.695000, 9.670000, 24121, 300),
('Mantova', 45.15, 10.8, 46010, 400),
('Lecco', 45.8565698, 9.3976704, 23900, 500);
Attachments
OnlineMapLocation.png
OnlineMapLocation.png (24.33 KiB) Viewed 11460 times
d.boifava
Posts: 15
Joined: Fri Apr 07, 2023 4:00 pm

Re: OnlineMap - Location

Post by d.boifava »

Maybe i have to try with a value that contains (latutide, longitude):
https://learn.microsoft.com/en-us/bingm ... tion-class
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: OnlineMap - Location

Post by Lech Kulikowski »

Hello,

Please use the Postcode option.

Thank you.
Attachments
photo_2023-04-14_09-38-04.jpg
photo_2023-04-14_09-38-04.jpg (27.03 KiB) Viewed 11436 times
d.boifava
Posts: 15
Joined: Fri Apr 07, 2023 4:00 pm

Re: OnlineMap - Location

Post by d.boifava »

I've tried but it doesn't work:
Attachments
ViewData.png
ViewData.png (7.31 KiB) Viewed 11428 times
Postcode.png
Postcode.png (85.07 KiB) Viewed 11428 times
Vadim
Posts: 362
Joined: Tue Apr 23, 2013 11:23 am

Re: OnlineMap - Location

Post by Vadim »

Hello.

You should select postcode level for your requirements.
Attachments
Screenshot 2023-04-17 125819.png
Screenshot 2023-04-17 125819.png (120.83 KiB) Viewed 11404 times
d.boifava
Posts: 15
Joined: Fri Apr 07, 2023 4:00 pm

Re: OnlineMap - Location

Post by d.boifava »

Hi, Which postal code should I use?
My postal code are all in Italy, i have tried with postcode 1,2,3,4 but it doesn't work.
Vadim
Posts: 362
Joined: Tue Apr 23, 2013 11:23 am

Re: OnlineMap - Location

Post by Vadim »

Hello.

If you not satisfied with postcodes you need to use latitude\longitude values.
Post Reply