Wi-Fi Hotspot POI

LeNoir · Occasional Visitor Joined: Aug 17, 2005 Posts: 8

I have always been frutrated when out on the road at no being able to navigate to the nearest Wi-Fi spot and collect my e-mails! So I have created a WI-Fi hotspot POI. I wont distribute the database as I dont want to break anyones copyright but here is how I did it:

1. download the the latest hot spots from BT Openzone : http://www.btopenzone.com/downloads/BT_Openzone_Hotspot_List.xls
3. Removed all of the non uk sites from the sheet and edited down the detail to leave postocde (minus the space), name & site operator
2. Bought the Navman postocde lat long database from http://www.poisoft.co.uk/ (thanks to Steve, he was very helpful).
3 imported all of the POISoft data in to one table in access.
4. imported the cut down BT data to another table in access.
5. created a querry to return the lat and long for the postcode in the BT table.
6. Exported the data back to excel
7. Sperated the data by site operator so I can have a seperate logo for BT, T-mobile, Cloud and Surf.
8. Did the rest of the stuff on BoPeeps ecellent sticky for creating POI and hey presto I have the overlays!

As soon as I can get my TT5 upgrade working I'll let you know how accurate it is otherwise it is back to TT3 for me!

Here are the logo's I created for each of the WiFi Operators, feel free to use them.

LeNoir

[img]www.my-hci.com/clients/car/wi-fi%20BT.bmp[/img]
[img]http://www.my-hci.com/clients/car/wi-fi%20Cloud.bmp[/img] [img]http://www.my-hci.com/clients/car/wi-fi%20surf.bmp[/img] [img]http://www.my-hci.com/clients/car/wi-fi%20tmob.bmp[/img][/img]

PAUL-R-S · Posted: Sat Sep 03, 2005 12:19 pm Post subject:

hey if it works give me a shout. wouldnt mind that sort of thing on mine :D

LeNoir · Occasional Visitor Joined: Aug 17, 2005 Posts: 8

It works a treat! I am pleasantly surprised at how accurate the postcodes are and it has saved me hours in the car driving around looking for a hot spot!

clem556 · Posted: Thu Sep 15, 2005 6:14 pm Post subject:

A truly useful website.

all I need now it to wifi navman pin 570 (when I get it(hopefully next week)) Wink

anyone done this yet

SimonCatlin · Posted: Thu Sep 15, 2005 11:15 pm Post subject:

Remeber people, login to a network and not have permission is a crime...
http://news.bbc.co.uk/1/hi/technology/4721723.stm
_________________
iPhone5, TomTom, Google maps, Navfree, Viewranger and Apple Maps (ekk)

clem556 · Posted: Sat Sep 17, 2005 9:25 pm Post subject:

Ooh I didn't know that Embarassed

I thought it was ok, doh Exclamation

	PocketGPS
	Web