Sunday, 10 February 2008
Bacari in Venice
Using my gps logger and my camera, this time I realized an overview of where me and by friends have been.
Saturday, 22 December 2007
OpenStreetMap
Since I own a GPS logger and I've tracked a lot of my car movements, I thought it could have been a good idea to collaborate to a new project I found online. It's called OpenStreetMap.
This is the mapping of Padova before I started working on it.
This is the mapping of Padova before I started working on it.
Thursday, 29 November 2007
Latitude / longitude distance in mysql
This is the best function I've found for calculating the distance from two different locations using their latitude / longitude coordinates expressed in degrees. The number of km is returned.
Note that the IF-ENDIF part is not optional, since round-off errors tmp could be bigger than 1 (or smaller than -1).
For this value ACOS is not defined and will return a NULL value.
DELIMITER //
DROP FUNCTION IF EXISTS km_from_deg //
CREATE FUNCTION km_from_deg (latA DOUBLE, longA DOUBLE, latB DOUBLE, longB DOUBLE)
RETURNS DOUBLE
BEGIN
DECLARE tmp DOUBLE;
SET tmp =
COS(RADIANS(longA - longB)) * COS(RADIANS(latB))*COS(RADIANS(latA)) +
SIN(RADIANS(latB))*SIN(RADIANS(latA));
IF tmp > 1 THEN set tmp = 1;
ELSEIF tmp < -1 THEN set tmp = -1;
END IF;
return 6372 * ACOS(tmp);
END;
//
DELIMITER ;
Note that the IF-ENDIF part is not optional, since round-off errors tmp could be bigger than 1 (or smaller than -1).
For this value ACOS is not defined and will return a NULL value.
DELIMITER //
DROP FUNCTION IF EXISTS km_from_deg //
CREATE FUNCTION km_from_deg (latA DOUBLE, longA DOUBLE, latB DOUBLE, longB DOUBLE)
RETURNS DOUBLE
BEGIN
DECLARE tmp DOUBLE;
SET tmp =
COS(RADIANS(longA - longB)) * COS(RADIANS(latB))*COS(RADIANS(latA)) +
SIN(RADIANS(latB))*SIN(RADIANS(latA));
IF tmp > 1 THEN set tmp = 1;
ELSEIF tmp < -1 THEN set tmp = -1;
END IF;
return 6372 * ACOS(tmp);
END;
//
DELIMITER ;
Monday, 29 October 2007
Diet progress: 74 kg
A bit slower that expected, but I reached 74 kg.
I guess now it will take another month from now to lose another kilogram and reach the target.
I guess now it will take another month from now to lose another kilogram and reach the target.
Sunday, 7 October 2007
Diet progress: still 75 kg
This week I have to admit it, I didn't follow the diet in a strict way.
Too much beer on Wednesday, Friday and last night.
The results are pretty clear, no progress.
Too much beer on Wednesday, Friday and last night.
The results are pretty clear, no progress.
Thursday, 4 October 2007
Tracking my running sessions: 5
Wednesday, 3 October 2007
Tracking my running sessions: 4
Sunday, 30 September 2007
Diet progress: 75 kg
The balance is now telling me that I weight 75 kg. That means I've lost another 800 grams.
Not too much, but perfectly on target.
Not too much, but perfectly on target.
Monday, 24 September 2007
Sunday, 23 September 2007
Diet progress: -1.2 kg
When I put 73 kg as one month target I wasn't so sure I could make it.
But the progresses are promising: now I weight 75.8 kg, that means I've lost about 1.2 kg.
But the progresses are promising: now I weight 75.8 kg, that means I've lost about 1.2 kg.
Wednesday, 19 September 2007
Tracking Gabriele's running session
Tuesday, 18 September 2007
Tracking my running sessions: 2
Monday, 17 September 2007
Tracking my running sessions: 2
Sunday, 16 September 2007
New bet: to weight less than Davide
Lately Davide has been making fun of me because he eats like a pig and still weights less than I do. He is also so stubborn that he doesn't want to take a blood test, so these are the terms of the bet: "he'll take a blood test as soon as I will weight less than he does".
So the plan is simple: strict diet and a lot more of physical activity. With strict diet I don't mean I will not eat anything, that is very stupid. Instead I will choose carefully each food I'll eat during the day, avoiding to take any carbohydrate after lunch (1.30 pm) till the day after.
This isn't easy because it means i can't take any sugar in the coffee, drink a cola or having even a fruit. Pizza, pasta and bread are then prohibited at supper, so I could only have vegetables, meet or fish.
The explanation is that by keeping a very low sugar level in the blood, the body will start burning some of the lipids that have been with me for a long time. By not taking any carbohydrate after lunch it means that I will be burning lipids all night long.
So, let's being. Starting weight: 77 kg, one month target: 73 kg
So the plan is simple: strict diet and a lot more of physical activity. With strict diet I don't mean I will not eat anything, that is very stupid. Instead I will choose carefully each food I'll eat during the day, avoiding to take any carbohydrate after lunch (1.30 pm) till the day after.
This isn't easy because it means i can't take any sugar in the coffee, drink a cola or having even a fruit. Pizza, pasta and bread are then prohibited at supper, so I could only have vegetables, meet or fish.
The explanation is that by keeping a very low sugar level in the blood, the body will start burning some of the lipids that have been with me for a long time. By not taking any carbohydrate after lunch it means that I will be burning lipids all night long.
So, let's being. Starting weight: 77 kg, one month target: 73 kg
Subscribe to:
Posts (Atom)




