Page 1 of 1

OnlineMap - Location

Posted: Thu Apr 13, 2023 8:51 am
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);

Re: OnlineMap - Location

Posted: Thu Apr 13, 2023 10:25 am
by d.boifava
Maybe i have to try with a value that contains (latutide, longitude):
https://learn.microsoft.com/en-us/bingm ... tion-class

Re: OnlineMap - Location

Posted: Fri Apr 14, 2023 7:39 am
by Lech Kulikowski
Hello,

Please use the Postcode option.

Thank you.

Re: OnlineMap - Location

Posted: Fri Apr 14, 2023 10:26 am
by d.boifava
I've tried but it doesn't work:

Re: OnlineMap - Location

Posted: Mon Apr 17, 2023 9:59 am
by Vadim
Hello.

You should select postcode level for your requirements.

Re: OnlineMap - Location

Posted: Tue Apr 18, 2023 9:02 am
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.

Re: OnlineMap - Location

Posted: Tue Apr 18, 2023 11:22 am
by Vadim
Hello.

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