Google
  Web www.gpspassion.com


GpsPasSion LIVE!
www.flickr.com
This is a Flickr badge showing public photos from GpsPasSion Live !. Make your own badge here.

www.NaviBlog.com



Versions

Links/Liens




Portal/Portail
Rechercher

- -

Polls/Sondages
Sondage
Pour vous guider sur la Route :
GPS Mobile (SEM)
GPS Intégré
Smartphone
Autre
Voter  -  Résultat des votes
Votes : 2266




Club GpsPasSion
Soutenez le site!

USA: (US$)
EUROPE: (€)
Guide Paypal


GpsPasSion Forums
Home | Profile | Register/Enregist. | Active Topics | Search/Recherche | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 www.POInUSA.com - Sharing Custom POIs
 Custom POI "Collections"
 LCBO (Ontario, Canada)
 New Topic  Reply/Répondre
 Printer Friendly
Author Previous Topic Topic Next Topic  

davidoh

Canada
15 Posts

Posted - 12 nov. 2006 :  20:59:12  Show Profile  Reply with Quote


LCBO (Ontario, Canada)


New collection




Manager : davidoh
Last Update : 11/16/2006
Number of POIs : 132
Coverage : Canada
Available Format(s) :csv (Garmin,...), ov2, xls
Download Link : DavidOh_LCBO.zip



This is a POI DB for LCBO locations in Ontario for the following cities:
Kitchener, Guelph, Milton, Oakville, Burlington, Mississuaga, and Toronto

For those who are ambitious, feel free to add other cities across Ontario. The LCBO site doesn't allow for a full location dump and requires the user to pick each city on at a time.

Included are a 16x16 logo BMP, a CSV, and an OV2 for TomTom Navigator users.
Enjoy!

LCBO

Edited by - jlb on 17 nov. 2006 10:54:07

Ads


jlb

France
29542 Posts

Posted - 13 nov. 2006 :  08:27:56  Show Profile  Reply with Quote
Hi davidoh,

Your file is now in a protected directory.

Jean
Team GpsPasSion - Moderator
Go to Top of Page

davidoh

Canada
15 Posts

Posted - 17 nov. 2006 :  01:40:04  Show Profile  Reply with Quote
All,

I've added the entire Ottawa region and Waterloo to the list... The updated .zip has XLS, CSV, OV2, and BMP.

LCBO 2006-11-16
Go to Top of Page

jlb

France
29542 Posts

Posted - 17 nov. 2006 :  10:10:39  Show Profile  Reply with Quote
Hi davidoh,

Link and first post updated.

Jean
Team GpsPasSion - Moderator
Go to Top of Page

mshe

Canada
30 Posts

Posted - 23 nov. 2006 :  08:26:09  Show Profile  Reply with Quote
Looks like for Windows machines - the line feeds in the CSV need to be converted.

UltraEdit can do this conversion.
Go to Top of Page

BobM

Canada
158 Posts

Posted - 23 nov. 2006 :  18:27:17  Show Profile  Reply with Quote
quote:
Originally posted by mshe

Looks like for Windows machines - the line feeds in the CSV need to be converted....

I just took a look at the LCBO.csv file and it seems to be in the correct format. There is only one line feed at the end of each record.

There are two CSV files in the zip and one seems to be for Windows (LCBO.csv) and one for MAC (._LCBO.csv). I didn't look at the MAC version.

Bob
Go to Top of Page

davidoh

Canada
15 Posts

Posted - 24 nov. 2006 :  03:01:39  Show Profile  Reply with Quote
quote:
Originally posted by BobM

quote:
Originally posted by mshe

Looks like for Windows machines - the line feeds in the CSV need to be converted....

I just took a look at the LCBO.csv file and it seems to be in the correct format. There is only one line feed at the end of each record.

There are two CSV files in the zip and one seems to be for Windows (LCBO.csv) and one for MAC (._LCBO.csv). I didn't look at the MAC version.

Bob

Go to Top of Page

davidoh

Canada
15 Posts

Posted - 24 nov. 2006 :  03:04:00  Show Profile  Reply with Quote
quote:
Originally posted by BobM

quote:
Originally posted by mshe

Looks like for Windows machines - the line feeds in the CSV need to be converted....

I just took a look at the LCBO.csv file and it seems to be in the correct format. There is only one line feed at the end of each record.

There are two CSV files in the zip and one seems to be for Windows (LCBO.csv) and one for MAC (._LCBO.csv). I didn't look at the MAC version.

Bob



Second try... :)

I did compile this using Excel on Mac. Ignore the ._LCBO.csv... it stored meta data on the file. If people are having issues using the .CSV, I can upload a corrected version...

Dave
Go to Top of Page

BobM

Canada
158 Posts

Posted - 24 nov. 2006 :  05:15:42  Show Profile  Reply with Quote
quote:
.... If people are having issues using the .CSV, I can upload a corrected version...

The CSV file did look OK but when I tried to run it on POI Loader it didn't work properly.

To fix the problem, I opened the LCBO.csv file in MS Word and then merely "Saved As" a type "Text Only (*.txt)" retaining the LCBO.csv name. It then correctly loaded all the records with POI Loader.

Bob
Go to Top of Page

admin_0

1 Posts

Posted - 20 janv. 2007 :  16:45:50  Show Profile  Reply with Quote
Hi,

Not sure if it is the proper way to add POIs, but here are 16 more LCBOs in Richmond Hill, Aurora, Newmarket area.

-79.447137 44.019833 Bayview & St.John
-79.465139 43.9893 Yonge & Brookland (Aurora)
-79.571019 44.112871 Hwy 11 & Holland (Bradford)
-79.431041 44.062545 Leslie & Davis
-79.480608 44.055982 Yonge & Davis
-79.439287 43.88024 Yonge & Elgin Mills
-79.430482 43.842411 Yonge & Hwy 7
-79.67701 44.004401 Hwys 27 & 9 (Schomberg)
-79.266142 43.967095 Hwys 48 & 47 (Stouffville)
-79.474065 44.241714 Simcoe & Queensway N (Keswick)
-79.356102 43.850249 Hwy 7 & Woodbine
-79.283546 43.873324 McCowan & Hwy 7
-79.53426 43.85022 Major Mackenzie & Jane
-79.707309 44.18873 Queen & King (Cookstown)
-79.426647 43.825758 Yonge & Uplands (Thornhill)
-79.805016 44.020113 Hwy 9 & Tottenham Rd
Go to Top of Page

davidoh

Canada
15 Posts

Posted - 31 janv. 2007 :  02:27:40  Show Profile  Reply with Quote
I've added to my master list and will upload an updated version soon. thanks!

quote:
Originally posted by Starshoy

Hi,

Not sure if it is the proper way to add POIs, but here are 16 more LCBOs in Richmond Hill, Aurora, Newmarket area.

-79.447137 44.019833 Bayview & St.John
-79.465139 43.9893 Yonge & Brookland (Aurora)
-79.571019 44.112871 Hwy 11 & Holland (Bradford)
-79.431041 44.062545 Leslie & Davis
-79.480608 44.055982 Yonge & Davis
-79.439287 43.88024 Yonge & Elgin Mills
-79.430482 43.842411 Yonge & Hwy 7
-79.67701 44.004401 Hwys 27 & 9 (Schomberg)
-79.266142 43.967095 Hwys 48 & 47 (Stouffville)
-79.474065 44.241714 Simcoe & Queensway N (Keswick)
-79.356102 43.850249 Hwy 7 & Woodbine
-79.283546 43.873324 McCowan & Hwy 7
-79.53426 43.85022 Major Mackenzie & Jane
-79.707309 44.18873 Queen & King (Cookstown)
-79.426647 43.825758 Yonge & Uplands (Thornhill)
-79.805016 44.020113 Hwy 9 & Tottenham Rd


Go to Top of Page

Nick Waterton

Canada
7 Posts

Posted - 29 sept. 2008 :  14:05:17  Show Profile  Reply with Quote
My local LCBO is the one in Heartland, Mississauga. You have it in the wrong location (seems to be placing it at Square One).

Here is the correct entry.
-79.41294,43.36774,Mavis & Britannia (Heartland Town Ctr)

Thanks.

Nick W
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply/Répondre
 Printer Friendly
Jump To:
GpsPasSion Forums © 2002-2014_GpsPasSion/Manzanite Go To Top Of Page
This page was generated in 0,69 seconds. Powered By: Snitz Forums 2000 Version 3.4.05