Subway File-Volunteers

 

This file was transferred to me a few days ago. Looking at it's history, it has not been updated in almost 7 years.
The present file has 22,215 locations and looking at the website locator, it indicates that there are 24,834 locations in the US.

Since the locator only lists 50 locations at a time, this is going to be a very time consuming process.
I don't like to make a request like this, but I hope that some of the members/maintainers will volunteer to update portions of the file.
At this time, with the exception of AK and AL, all states are available.

Looking at the present file, phone numbers are not included. Therefore the update should include these.
I have already updated Alaska and Alabama and these now include each phone number. I also decided to include the restaurant # since it is located right below the phone numbers.
Relatively ease (ha-ha) to obtain both with copy and paste.
I would really appreciate some help on this file.

Thanks in advance.

mahoney

I will work on Tennessee

John

Subway-TN

Thanks John

Subway Arkansas

I have completed the update of AR.

Added 91 locations
Deleted 41 locations
Corrected 18 addresses

Subway State Status

For those members considering helping to update this file, I decided to provide the latest state status as of 11/30/2018.

AK-completed
Al-completed
AR-completed
AZ-in work (mahoney)
CA-in work (mahoney)
RI-in work (mahoney)
TN-in work (jgermann)

Contact me if you have any questions.

A daunting project

I do not envy you your task Mahoney.

I have a similar POI in mind which I want to start from scratch and it has "only" 300 locations.
Tried to contact their head office by email and got no response. I'll have to try again when I get home, this time I'll try in person.

--
Nuvi 2797LMT, DriveSmart 50 LMT-HD, Using Windows 10. DashCam A108C with GPS.

Ohio

I'll work on Ohio

Subway-Ohio

Thanks eaglesft.

eaglesft has completed OH. Updated file has been uploaded

Subway Arizona

I have completed the update of AZ.

Added 73 locations
Deleted 37 locations
Corrected 15 addresses

Subway-California

I have completed the update of CA.

Added 465 locations
Deleted 381 locations
Corrected 103 addresses

Subway-Colorado

I have completed the update of CO

Added 71 locations
Deleted 51 locations
Corrected 18 addresses

Subway State Status Update

For those members considering helping to update this file, I decided to provide the latest state status as of 12/12/2018.

AK-completed
Al-completed
AR-completed
AZ-in work (mahoney)
CA-in work (mahoney)
RI-in work (mahoney)
TN-in work (jgermann)
CO-completed
CT-in work (mahoney)
DC-in work (mahoney)
DE-in work (mahoney)
FL-in work (mahoney)

NOTE: REMAINING STATES ARE STILL AVAILABLE FOR UPDATE.

I will do MA

I will do MA

--
Have a safe trip

Subway MA

Thanks Bald Camper

Update

mahoney wrote:

For those members considering helping to update this file, I decided to provide the latest state status as of 12/12/2018.

As of 12/24/2018

AK-completed (mahoney)
Al-completed (mahoney)
AR-completed (mahoney)
AZ-completed (mahoney)
CA-completed (mahoney)
RI-completed (mahoney)
TN-in work (jgermann)
CO-completed (mahoney)
CT-completed (mahoney)
DC-completed (mahoney)
DE-completed (mahoney)
FL-completed (mahoney)
OH-completed (eaglesft)
GA-in work (mahoney)
MA-completed (Bald Camper)
KY-in work (BCfromKy)
HI-in work (mahoney)
IA-in work (mahoney)
ID-in work (mahoney)
IL-in work (mahoney)

NOTE: REMAINING STATES ARE STILL AVAILABLE FOR UPDATE.

Subway Connecticut

I have completed the update of CT.

Added 92 locations
Deleted 58 locations
Corrected 34 addresses

Kentucky

I've started working on Kentucky

Subway Kentucky

Thanks Bill (BCfromKY)

Subway DC

Completed the update of DC.

Added 26 locations
Deleted 24 locations
Corrected 2 addresses

Subway DE

I have completed the update of Delaware

Added 8 locations
Deleted 13 locations
Corrected 5 addresses

Subway RI

Completed the update of Rhode Island

Added 21 locations
Deleted 12 locations
Corrected 6 addresses

Still working

Kentucky was a mess. I'm about half way through the existing list and there's a net gain so far of about 90 shops. Also some of the coordinates were so far off I'm double checking all of them.

Subway MA

Received the updated file for MA. Net increase of 44 locations.

Thanks Bald Camper

What is the status now.

What is the status now.

--
Have a safe trip

Latest Status as of 12/24/218

mahoney wrote:
mahoney wrote:

For those members considering helping to update this file, I decided to provide the latest state status as of 12/12/2018.

As of 12/24/2018

AK-completed (mahoney)
Al-completed (mahoney)
AR-completed (mahoney)
AZ-completed (mahoney)
CA-completed (mahoney)
RI-completed (mahoney)
TN-in work (jgermann)
CO-completed (mahoney)
CT-completed (mahoney)
DC-completed (mahoney)
DE-completed (mahoney)
FL-completed (mahoney)
OH-completed (eaglesft)
GA-in work (mahoney)
MA-completed (Bald Camper)
KY-in work (BCfromKy)
HI-in work (mahoney)
IA-in work (mahoney)
ID-in work (mahoney)
IL-in work (mahoney)

NOTE: REMAINING STATES ARE STILL AVAILABLE FOR UPDATE.

Latest file available for download includes the above completed states along with the states not updated.

IMHO, I love/hate

IMHO, I love/hate information. Adding info like the company restaurant NUMBER may be helpful, but I don't see it. It is definitely a hindrance, especially if it is placed in a location that preempts more usable info. I think most GPS units display one line of info. IMHO, the most important is the street name. The process is to lookup SUBWAY, then either find the one that is closest if you are not a local, or the one on a particular street if you are a local. If that info isn't first, then one must scroll to find that. Not very expedient. Phone numbers may be more useful than restaurant numbers but how many times are ppl going to look for them.
The previous structure of the file Was good. I think an improvement might be to place the building number AFTER the street name. Most of the time the numbers are impossible to find and that is what the GPS does for you. After all you are not going to mail them a letter.
It may be easy to add, but is it at all useful except for company employees?
The current structure that you have will require me to edit every update I download to make it usable for me. Maybe I just POIload these files a lot different than everyone else, but Subway-Anchorage,AK (or Subway-whatever) will appear on my screen for every listing and will do me no good. I already know that I am looking at Subway listings. If I am in Anchorage, I already know I am there, now I must scroll my screen to find a street, which I probably won't do since I am not a local in Anchorage and I am just looking for the closest one which the GPS is already telling me. So in this case all the info is pretty much useless. The info is also too verbose. It is obvious that #15777 is a restaurant number so why put "restaurant" in there?
Subway-Anchorage,AK
4608 Spenard Rd [Lakeshore Ctr ste F], Anchorage,AK 99503|907-248-2687, Restaurant #15777

My preferred listing would look like this
Spenard Rd,4608,Anchorage,AK,99503-907-248-2687
or if the # is needed
Spenard Rd,4608,Anchorage,AK,99503-907-248-2687,#15777

The most usable info will appear on the GPS screen, maybe
Spenard Rd,4608,Anchor...

Why would anyone need to know this unless they were operating without a GPS and therefore not using this file? >>> [Lakeshore Ctr ste F]

FYI - I separate fast food restaurants into one folder and POILoad the whole folder. When I want to find Subway in my GPS I first select Fast Food, then Subway. Every listing I see is for Subway, which is why I don't need to see "SUBWAY". YMMV

My feelings mostly exactly

ruggb wrote:

...My preferred listing would look like this
Spenard Rd,4608,Anchorage,AK,99503-907-248-2687...

I mostly agree with you about what information to include. I still put street address first then street name, but that's just me. Lately I'm even omitting the zip code. Just can't figure out why I might need it.

Phil

--
"No misfortune is so bad that whining about it won't make it worse."

Free Files

Merry Christmas to you too.

You must remember that the files are free..

mahoney wrote:

Merry Christmas to you too.

...and that someone has put an awful lot of work into creating those files. I can't imagine the time that Mahoney (and, some of the other maintainers) puts into these things. My feeling is that if one does not like the format, they can do one of two things. Accept them as they are, or, create your own files. As the old saying goes, don't bite the hand that feeds you. With that being said; I wish everyone a very Merry Christmas.

--
With God, all things are possible. ——State motto of the Great State of Ohio

@plunder thanks for your

@plunder thanks for your input. Hopefully, more people will have some reasonable input.

There is no question the these files are a PITA to organize, put together, and maintain. I have attempted to work on a small portion of NC, The Triangle - Raleigh, Durham, Chapel Hill -- a lot has changed for sure. I rethought my format and changed it to having the street number up front, because it is more difficult to verify/check/maintain without it. So I have gone back to this.

4830 Apex Highway 55,Park West Crossing,Durham,NC,919 544-6808,27713

Since some of these are in places like Walmart, or a hospital, that may appear instead of the shopping center name. I am still struggling with zip code and phone, but the phone may be important to verify hours or even if they are still there. The zip code is probably only good for package/mail delivery or maybe for maintenance sorting.

AND have a Happy Holiday, HO, HO, HO

Zip Code

I agree that the zip code is not much help, however, If you have a file that has more than 50 locations in a city (example
Subway locations in Chicago,IL, which has more than 112 locations), Zip code is needed in obtaining all locations. Just putting Chicago in the website locator does not give all locations. For this situation, I have to put in various zip codes in the website locator to ensure that I have all locations.This is the problem in a number of Fast Food files that I try to keep updated.

Subway Georgia and Hawaii

I have completed the update of GA and HI.

GA
Added 321 locations
Deleted 126 locations
Corrected 73 addresses

HI
Added 25 locations
Deleted 22 locations
Corrected 6 addresses

Update status-1/4/2019

mahoney wrote:
mahoney wrote:
mahoney wrote:

For those members considering helping to update this file, I decided to provide the latest state status as of 12/12/2018.

As of 1/4/2019

AK-completed (mahoney)
Al-completed (mahoney)
AR-completed (mahoney)
AZ-completed (mahoney)
CA-completed (mahoney)
RI-completed (mahoney)
TN-in work (jgermann) completed
CO-completed (mahoney)
CT-completed (mahoney)
DC-completed (mahoney)
DE-completed (mahoney)
FL-completed (mahoney)
OH-completed (eaglesft)
GA-completed (mahoney)
MA-completed (Bald Camper)
KY-in work (BCfromKy) completed
HI-completed (mahoney)
IA-in work (mahoney) completed
ID-in work (mahoney) completed
IL-in work (mahoney) completed
IN-in work (mahoney)
KS-in work (mahoney)
LA-in work (mahoney)
NC-in work (jgermann)
MD-in work (mahoney)
ME-in work (mahoney)
MI-in work (mahoney)

NOTE: REMAINING STATES ARE STILL AVAILABLE FOR UPDATE.

Latest file available for download includes the above completed states along with the states not updated.

Subway IOWA

Completed the update of IA.

Added 74 locations
Deleted 28 locations
Corrected 29 addresses

Subway-Kentucky

BCfromKY submitted the updated KY file.
Net increase of 47 locations.

Thanks BCfromKY.

Subway-Tennessee

jgermann submitted the updated listing of the TN locations.

Net increase of 45 locations.

Thanks, jgermann

Subway Idaho

I have completed the update of ID

Additions 31 locations
Deleted 17 locations
Corrected 1 address

Subway Illinois

Completed the update of IL

Added 335 locations
Deleted 208 locations
Corrected 114 addresses

Subway Indiana

Complete the update of IN

Added 182 locations
Deleted 96 locatons
Corrected 56 addresses

Subway-NC

jgermann submitted the update of North Carolina.

Thanks John

File Status - 2/13/2019 FILE UPDATE COMPLETED

mahoney wrote:
mahoney wrote:
mahoney wrote:
mahoney wrote:

For those members considering helping to update this file, I decided to provide the latest state status as of 12/12/2018.

As of 2/8/2019

AK-completed (mahoney)
Al-completed (mahoney)
AR-completed (mahoney)
AZ-completed (mahoney)
CA-completed (mahoney)
RI-completed (mahoney)
TN-in work (jgermann) completed
CO-completed (mahoney)
CT-completed (mahoney)
DC-completed (mahoney)
DE-completed (mahoney)
FL-completed (mahoney)
OH-completed (eaglesft)
GA-completed (mahoney)
MA-completed (Bald Camper)
KY-in work (BCfromKy) completed
HI-completed (mahoney)
IA-in work (mahoney) completed
ID-in work (mahoney) completed
IL-in work (mahoney) completed
IN-in work (mahoney) completed
KS-in work (mahoney) completed
LA-in work (mahoney) completed
NC-in work (jgermann) completed
MD-in work (mahoney) completed
ME-in work (mahoney) completed
MI-in work (mahoney) completed
MN-in work (mahoney) completed
MO-in work (mahoney) completed
SC-in work (jgermann) completed
MS-in work (mahoney) completed
MT-in work (mahoney) completed
ND-in work (mahoney) completed
NE-in work (mahoney) completed
NH-in work (mahoney) completed
NJ-in work (mahoney) completed
NM-in work (mahoney) completed
NV-in work (mahoney) completed
VA-in work (jgermann) completed
VT-in work (jgermann) completed
NY-in work (mahoney) completed
OK-in work (mahoney) completed
OR-in work (mahoney) completed
PA-in work (mahoney) completed
SD-in work (mahoney) completed
TX-in work (mahoney) completed
UT-in work (mahoney) completed
WA-in work (mahoney) completed
WI-in work (mahoney) completed
WV-in work (mahoney) completed
WY-in work (mahoney) completed

NOTE: NOTE: NOTE: NOTE: NOTE: NOTE: NOTE: NOTE: NOTE: NOTE: NOTE:

REMAINING STATES NOT LISTED ABOVE ARE STILL AVAILABLE FOR UPDATE.

Latest file available for download includes the above completed

states along with the states not updated.

File Update

The update of this file is complete. Thanks to those members that helped in this update.

jgermann (TN,NC,SC,VA and VT)
eaglesft (OH)
Bald Camper (MA)
BCfromKY (KY)