Office Depot (completed)

Great! Miss POI should already have the Office Depot project photo I sent her when you get the file completed.

With bloodshot eyes, I've finished the data entry for all the Office Depots in the US and Canada. 1274 locations in all.

Alphabetically, I've edited the stores thru Florida to correct the addresses to post office standards. I can't seem to find my address correction CD, so I've been eyeballing the list. So far, I've found 11 stores (from their site) that are giving the USPS site fits in recognizing them... some of them are listed in the Garmin.

Taking the weekend off to play...

AJ

Welcome to the wonderful world of making accurate POI files.

That was one of the first problems I ran into when I started - company websites whose store locator function gave addresses that did not follow USPS standards. They didn't geocode correctly.

So, in order to create an accurate POI file to upload to POI Factory, yeah, you end up spending countless hours manually correcting the errors. I feel your pain.

But, in the end, it will be worth it - fewer emails or forum posts telling you there is an error in your POI file with location X. The equivalent of "calling your baby ugly."

Keep up the good work!

While your are doing this would you please put the state with each one as it makes it easier to sort and pull just the states you want. Also when looking at the whole file it is hard to find if a store by you is in the file. Just a comment.
Know it is hard work but the more work the better the poi.

johnm45...

Can you clarify exactly what you mean?

Since the unit will cull the closest ones to your location, do you mean for the list to name the city & state of the store first?

...or do you mean have separate files for the states and one master file for all stores?

AJ

If you look at most poi's for all states combined they just have the long/lat name and address but not state. I think that the state should be there also this way when someone looks at the poi they can see if their state and city store is there. The Walmart file is a good one to look at not only does is show the store number but it shows the address, city and state.

Gotcha, johnm, I'll d/l the Walmart file and check it out. I am about 25 addresses away from completing the address verification of the Office Depot's US stores. Whoever inserted the addresses for their stores on the website needs to have his head handed to him/her. Sheesh. I've used the yellow pages and now a reverse phone directory to nail down the proper locations.

Such is life! AJ

OK, Office Depot (U.S. and Canada) has been submitted. A full description of what I did was submitted with the .csv file.

Johnm, I looked at the WalMart file and decided not to put the address in the 1st line. Since the unit cuts off the address, I still had to perform more touches to see where it was located.

I decided to order the list in store location number order and that is what shows on the search result screen... "Office Depot #0001" and so on.

Outside of that, the file is very neat and clean. I hope you like it, I may attempt OfficeMax next. LOL!

No matter what info is posted if it is accurate then it is helpfull and all other thing can be overcome. Thanks for the hard work Will look at it next. I use office depot alot here.

I appreciate your work on this file.