corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » General Chat » FAO: People with TomTom Navigator LINK REWORKING FOR A WHILE

Poll: FAO: People with TomTom Navigator LINK REWORKING FOR A WHILE
  Halfords
  Tescos
  Sainsburys
  Asda
  Postcodes
  Mcdonalds
  Click to see results


New Topic
New Poll 		  <<  1    2  >> Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author FAO: People with TomTom Navigator LINK REWORKING FOR A WHILE
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
2nd Jan 05 at 11:20   View Garage View User's Profile U2U Member Reply With Quote
If you have ever used tomtom built in postcode search u will kno how crap it is so I have compiled all the post codes in the uk into 10 poi overlays accurate to full postcode search, it is as good as multimap search using these overlays!

Scotland
Midlands
NW
NE
Anglia
SE
South central
SW
London
Wales

Who would want them? if i get enuff interest il upload them, be warned they amount to about 50meg in all if u had all overlays a storage card is needed.

i also have these aswell

Mcdonalds
Tescos
Asda
Sainsburys
Halfords

http://www.anorgett.f2s.com/pc.zip

11mb file extracts to 10 different POI's

thanks to SKINZ for hosting

[Edited on 04-01-2005 by GSiSteve]

[Edited on 11-01-2005 by GSiSteve]
Mikorsa16v
Member
Registered: 2nd Sep 02
Location: Burgess Hill, West Sussex
User status: Offline
2nd Jan 05 at 12:35   View User's Profile U2U Member Reply With Quote
thats a very good plan if it works well, i have heard of people talking/trying to create postcode overlays which don't seem to work well - i don't know why tom tom didn't build this in.

seems like a lot of effort on your part has gone into this, it might be worth contacting http://www.pocketgps.co.uk/tomtompoi.php to host the files.
leeshez
Member
Registered: 3rd May 01
Location: Great Harwood, Lancashire
User status: Offline
2nd Jan 05 at 12:37   View User's Profile U2U Member Reply With Quote
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
2nd Jan 05 at 12:44   View Garage View User's Profile U2U Member Reply With Quote
all postcodes are there, if u want give me a postcode il do a test, i have only compiled ne, midlands, london, and anglia so far rest shuld be dun by tmoz or day afta so gimmie a pc from one of them regions
Mikorsa16v
Member
Registered: 2nd Sep 02
Location: Burgess Hill, West Sussex
User status: Offline
2nd Jan 05 at 13:02   View User's Profile U2U Member Reply With Quote
ttt, i wouldn't know a pc from those areas! someone...
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
2nd Jan 05 at 13:48   View Garage View User's Profile U2U Member Reply With Quote
well they are all there and they all work ul have to wait and see
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
2nd Jan 05 at 14:09   View Garage View User's Profile U2U Member Reply With Quote
also nebody using checkpoint i strongly recommend moving over the poi warner, it is far better
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
2nd Jan 05 at 14:15   View Garage View User's Profile U2U Member Reply With Quote
Steve - do these ov2 files convert to csv easily?
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
2nd Jan 05 at 14:24   View Garage View User's Profile U2U Member Reply With Quote
I am using a bit of free software called POI Edit from http://www.dnote.nl/pda/poi/PoiEdit/index.html

but you can use this to convert the files to XLS

http://rjdavies.users.btopenworld.com/html/poiconverter.html
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
2nd Jan 05 at 14:24   View Garage View User's Profile U2U Member Reply With Quote
or CSV
Evil Ash
Member
Registered: 22nd Dec 02
User status: Offline
2nd Jan 05 at 15:46   View User's Profile U2U Member Reply With Quote
Try this site already has most of the overlays that you mention.

http://poiplace.oabsoftware.nl/index.php?MainURL=POIregister3.php
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
2nd Jan 05 at 15:49   View Garage View User's Profile U2U Member Reply With Quote
yes not the postcodes though, i find that site rubbish for poi's as most of them arent very up to date
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
2nd Jan 05 at 16:24   View Garage View User's Profile U2U Member Reply With Quote
there must be more cunts out there using tomtom, if not you are missing out!
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
2nd Jan 05 at 17:29   View Garage View User's Profile U2U Member Reply With Quote
quote:
Originally posted by GSiSteve
or CSV


Beast

code:


mysql> SELECT h. * , floor( sqrt( (

    -> abs( p.x - 354600 ) * abs( p.x - 354600 ) ) + ( abs( p.y - 404100 ) * abs( p.y - 404100 ) ) ) / 1609

    -> ) AS dist

    -> FROM hotspots h

    -> INNER JOIN postcodes p ON h.postcode = p.postcode

    -> ORDER BY `dist` ASC  LIMIT 0 , 20; 

+---------------------------+----------+------+

| name                      | postcode | dist |

+---------------------------+----------+------+

|  Orange House             | WN1      |    2 |

|  Chicago Rock Cafe        | WN1      |    2 |

|  Wigan Riley Snooker Club | WN1      |    2 |

|  Red Lion                 | WN4      |    3 |

|  Waterside                | WA11     |    3 |

|  Ship Inn                 | WA11     |    3 |

|  Robin Hood               | WN4      |    3 |

|  Market Tavern            | WA10     |    6 |

|  Sefton Arms              | WA10     |    6 |

|  Gerard Arms              | WA10     |    6 |

|  Chicago Rock Cafe        | WA10     |    6 |

|  PC World St. Helens      | WA9      |    6 |

|  Hilton - St Helens       | WA10     |    6 |

|  Ramada Jarvis Bolton     | BL6      |    7 |

|  Lostock Arms             | BL6      |    7 |

|  Yates'S                  | PR7      |    7 |

|  Greenwood Hotel          | BL6      |    7 |

|  Goose At Spinning Jenny  | WN7      |    7 |

|  Red Lion                 | WN7      |    7 |

|  George                   | PR7      |    7 |

+---------------------------+----------+------+

20 rows in set (3.35 sec)
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
2nd Jan 05 at 17:30   View Garage View User's Profile U2U Member Reply With Quote
what ru meant to be showing me ian? what as the code you use in your site to do with?
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
2nd Jan 05 at 17:33   View Garage View User's Profile U2U Member Reply With Quote
Thats wireless hotspot data from the site that Mikorsa16v posted.

Thats the list of hotspots closest to me according to location services in this database.

Got loads - Vauxhall dealers, all petrol stations etc.
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
2nd Jan 05 at 18:44   View Garage View User's Profile U2U Member Reply With Quote
ttt
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
2nd Jan 05 at 21:46   View Garage View User's Profile U2U Member Reply With Quote
bttt
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
3rd Jan 05 at 05:30   View Garage View User's Profile U2U Member Reply With Quote
stil nd hosting offer 10*4megs
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
3rd Jan 05 at 17:49   View Garage View User's Profile U2U Member Reply With Quote
i have finished compliling all postcodes for all of uk, if sumone would like to offer me a postcode and the area located in the uk, ie northwest, or wales, or southeast etc then il prove it

il try to get my mate to host the files on his pc tomorrow
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
3rd Jan 05 at 18:24   View Garage View User's Profile U2U Member Reply With Quote
I'll have the files from you.
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
3rd Jan 05 at 18:48   View Garage View User's Profile U2U Member Reply With Quote
il msn them to u, will take a while tho
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
3rd Jan 05 at 18:55   View Garage View User's Profile U2U Member Reply With Quote
ian get your anus back to msn
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
3rd Jan 05 at 20:22   View Garage View User's Profile U2U Member Reply With Quote
ttt
stubbsy
Member
Registered: 5th Jun 01
Location: stoke-on-trent
User status: Offline
3rd Jan 05 at 20:23   View User's Profile U2U Member Reply With Quote
make your own website with that info, charge people 50p or so per postcode wanted

  <<  1    2  >>
New Topic
New Poll

Corsa Sport » Message Board » General Chat » FAO: People with TomTom Navigator LINK REWORKING FOR A WHILE 22 database queries in 0.1109838 seconds