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