Bacari in Venice

Using my gps logger and my camera, this time I realized an overview of where me and by friends have been.

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.

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 could make tmp bigger than 1 or smaller than -1.

For those values 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 ;

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.

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.

Tracking my running sessions: 5

Ops, this time my GPS unit fell down and I've lost the on/off switch. No luck, so I went back running.
Notice the final sprint before stopping. It wasn't too difficult, only four laps this time.

Tracking my running sessions: 4

This time I had to take a break (quater of a lap) just before the final lap (the seventh).
At least it was a fast lap.

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.

Tracking my running sessions: 3

Longer run than usual (9 laps and a half), but with no speed variations.

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.

Tracking Gabriele's running session

A friend of mine, Gabriele, borrowed my GPS logging devices. A long run, and it could have been even longer if he had remembered to turn the GPS unit on few minutes before.
In fact all GPS unit needs few minutes to acquire a stable signal, especially when they have been switched off for a long time.

Tracking my running sessions: 2

This has been a much harder session: five laps ad medium speed, three laps of speed variations, stretching session and then some exercises.

Tracking my running sessions: 2

This has been a much harder session: five laps at medium speed, three laps of speed variations, stretching session and then some exercises.
During the last speed variation you can see how I gave the best of myself, in fact then I had to walk since I couldn't run anymore.

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

Tracking my running sessions: 1

It has been a long time since my last running session, so this has been an easy one. I joined Gigi, a soccer referee, too bad that I can't keep up with his pace.
We did three and a half laps around Prato della Valle at medium speed, then some speed variations for another two laps. Then a stretching session, and some running exercises.

Usurai.it

The domain usurai.it is now active.

New project: Usurai.it

Strange enough the domain usurai.it hasn't been registered by anybody, so I did it.

Pizza a Domicilio, removed again from Google (3)

I can't figure it out, look at here:
Google has removed pizza-a-domicilio.it from its index again! And still Google Webmaster Tools are not correct:

The only thing I can do now is to raise the daily budget on Google Adwords to 10 €.

PB: Traffic Record!

Yesterday (August 8th 2007) has been the day with the most traffic ever on Prezzi Benzina: 9975 page views.

Prezzi Benzina Traffic - August 2007

Prezzi Benzina Traffic - August 8th, 2007

Pizza a Domicilio, back again into Google index

After only twelve days it seems that buying mister-pizza.it has been useful.
Google is currently indexing Pizza a Domicilio in the first pages again.

This means that it's the perfect time to lower the maximum cpc from 0.03€ to 0.02€ on Google Adwords. Anyway I'll keep the maximum daily budget at 5.00€.