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 11459 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: 6196
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 11435 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 11427 times
Postcode.png
Postcode.png (85.07 KiB) Viewed 11427 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 11403 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