OnlineMap - Location
OnlineMap - Location
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);
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 (24.33 KiB) Viewed 15422 times
Re: OnlineMap - Location
Maybe i have to try with a value that contains (latutide, longitude):
https://learn.microsoft.com/en-us/bingm ... tion-class
https://learn.microsoft.com/en-us/bingm ... tion-class
-
- Posts: 7287
- Joined: Tue Mar 20, 2018 5:34 am
Re: OnlineMap - Location
Hello,
Please use the Postcode option.
Thank you.
Please use the Postcode option.
Thank you.
- Attachments
-
- photo_2023-04-14_09-38-04.jpg (27.03 KiB) Viewed 15398 times
Re: OnlineMap - Location
I've tried but it doesn't work:
- Attachments
-
- ViewData.png (7.31 KiB) Viewed 15390 times
-
- Postcode.png (85.07 KiB) Viewed 15390 times
Re: OnlineMap - Location
Hello.
You should select postcode level for your requirements.
You should select postcode level for your requirements.
- Attachments
-
- Screenshot 2023-04-17 125819.png (120.83 KiB) Viewed 15366 times
Re: OnlineMap - Location
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.
My postal code are all in Italy, i have tried with postcode 1,2,3,4 but it doesn't work.
Re: OnlineMap - Location
Hello.
If you not satisfied with postcodes you need to use latitude\longitude values.
If you not satisfied with postcodes you need to use latitude\longitude values.