I am presently updating the entire file using the Shell website locator. The major problem with this updating is that the website locator listing ONLY incudes the street address. In order to obtain the City, State,Phone numbers and whether it has diesel, is to use ths coord/street address along with the use of Google Earth to obtain this information.
As you are aware, this is very time consuming and if anyone would like to volunteer to obtain this type of data for some of the new locations, it would be greatly appreciated.
Note: The listing in the Shell website locator consists of
-123.091221 47.201627 1528 OLYMPIC HWY S
and I am converting this to csv format of the following
Shell[Diesel]-Shelton,WA 1528 Olympic Hwy S,Shelton,WA 98584,
I have completed the Canadian locations. I deleted 89 locations and added 184 new locations,all of which I had to individually obtain the desired information. I am presently working on the update for the USA locations and it appears that there will be over 600 new locations, all of which I hope will include the data listed above. Again, if anyone wishes to help, please let me know.
You can download the "full" USA .csv file by clicking on the "Export entire country network(CSV)" icon below the locator map. When I downloaded the file (Shell only, no partner locations), it returned 13,947 locations with the following columns:
Name Address City Post code Country GPS Latitude GPS Longitude Telephone Unmanned Brand 24 Hour Shop Car wash Toilet Shower ATM Restaurant Pay at pump Truck friendly Truck only Parking Lanes Motorway Guarded parking Truck Adblue Shell Nitrogen Enriched Gasolines Diesel Shell ClearFLEX E-85 Shell Hydrogen Shell Diesel Fit ESI
1st row example:
1331 MINNESOTA AVE 1331 MINNESOTA AVE BENSON 56215-1855 United States -45.310329 -95.603529 3208432160 Manned Shell FALSE TRUE TRUE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE FALSE FALSE FALSE
Interestingly, there is no column for State. I uploaded the file to my server if you can't obtain it from Shell: http://seapup.com/temp/ShellLocationsUSA.csv
Let me know if I can be of more help. I can strip out extraneous columns, add state and convert to comma-delimited if need be.
Seapup, thanks for the response. I missed that "export entire country network" below the locator map. I used the gps direction icon just below the search block and the listing that I downloaded using this, included 13990 locations. Not sure why the difference, but as I mentioned in the initial thread, the only data was coordinates and the street address.
It would have been much easier for me to just go ahead and update the file using only this data. However, I prefer to have the entire address including street, city, state and phone numbers. I also didn't want to delete the present file and start a new one from scratch. There have been changes submitted by members in previous years and I had also added exit numbers from interstates as applicable. In addition, I had not updated this entire file for a number of years and thought that it was time.
At the present time, I am using the download that you mentioned for the city,zip codes and phone numbers and for finding the state,I am using each zip code. Slow process, but I am getting there. I just need to put the new locations in the proper format. Thanks again for pointing out this other file from the Shell website locator page. It has definitely saved me some time on the update.
terms | privacy | contactCopyright © 2006-2019