Wiki Superchargers Visited

**** NOTE: We have transitioned to a new platform ****
More Info: Supercharging.Life database​

This is a friendly contest for Tesla owners to track the number of unique public Superchargers where they have charged

- "Supercharger count" is the number of unique public Superchargers where you have charged (just being there does not count), whether or not you were the person plugging in the vehicle (such as a Valet Parking garage or a Passenger) and whether or not it was your own personal vehicle (such as a rental, a loaner, or a friend's Tesla) as long as you were the one who drove >50% of the distance to reach the charger(s).
- The list of chargers in the supercharging.life database are the ones included in the game. If you think one should be added or removed from the list, let us know.
- Only chargers available to the public without special permission are included in the game.
- Chargers not connected to the grid are not counted.
- Doublet locations like the North/South Supercharger 'pairs' in CT, ME, NH, etc. count as individual locations.
- More than 1 charger at the same address, such as Lenox Square Mall (Atlanta, GA) or Montgomery Mall (Bethesda, MD) count as individual locations when they appear as a separate location on the Tesla Nav screen.
- Inactive competitors will be archived and removed from the leaderboard. Just post an update to be reactivated.

See Supercharging.Life database for info on how to post your own visits to the database (preferred), or post your locations with date visited to this thread and one of the admins will update your list for you. All visits must be posted to this thread - not just entered in supercharging.life. If you are the first in the game to visit a supercharger location, please post to the thread as soon as you can so others know it has been visited.

 

[Half Dollar Bill]

I’ve never kept an Inn, just stayed in some - but point taken!

The coal in Wyoming hasn’t been scrubbed “clean”, I’ve heard.

It was a rather momentous day for me/us. It solidified the gentlewomanly/gentlemanly nature of this game. Had we had all of these fancy new tools by @theflyer and his co-admins, perhaps we would have nailed it in Gillette.

I haven’t met a classier fellow Supercharger than @Bighorn over the last 8+ years (must be 10+ times), and we live 1300 miles apart.

I get to say I was first for a few weeks, but the community here is a macrocosm of the Custer meetup itself.

And it is much appreciated. Thanks to early adopters, thanks to the road warriors, thanks to the Admins!!

I still think your wife's note at the farewell dinner was the kindest and most loving statement I've ever heard.

 

[Tdreamer]

At this very moment, I think Tableau is showing something close to the correct values. I would appreciate confirmation that others are seeing the correct data. Then, let me know when you see it go bonkers again (I'd love to be wrong but expect it will). Tableau is calculating 792 visits but the spreadsheet leaderboard shows 796. Which are missing?

Looking much better today - thank you!

 

[Tdreamer]

I have yet to find a state enforcing any of these rules.

Agreed here - Mass is using the threat of enforcement only from what I can tell.

 

[Bighorn]

I dodged enforcement at the Florida border and avoided NYC when they cracked down. My BIL got stopped in FL about an hour before I got to the border, so I had fair warning. I have not encountered anything personally as a result.

 

[YYZ-IAD]

So out of curiosity, how do you validate that? I mean, sure, anyone can eyeball a map. But how do you validate that you have an optimized route, given the multiple destination points?
Not asking for doctoral thesis, just conceptual answer, because I figure it's probably interesting.

There has been a field of science around since WWII called Operations Research that involves design of algorithms (and computer code) that seek optimal solutions given an objective and constraints. (It does take a thesis to prove optimality). In this case, Traveling Salesman Problem (TSP) algorithms can iterate millions of times to strive to improve the solution - and inform when no better solution can be found. Designs are much more clever than trial and error by throwing away lots of cases that are proven to be worse than others. Not the sort of thing you would want to try by hand - at least for big problems. Danger of going way off topic for this forum -- but I hope to report back with theoretical shortest total distance to visit every SC in N.A. -- or we just ask @Bighorn to give us his odometer reading.

 

[Bighorn]

There has been a field of science around since WWII called Operations Research that involves design of algorithms (and computer code) that seek optimal solutions given an objective and constraints. (It does take a thesis to prove optimality). In this case, Traveling Salesman Problem (TSP) algorithms can iterate millions of times to strive to improve the solution - and inform when no better solution can be found. Designs are much more clever than trial and error by throwing away lots of cases that are proven to be worse than others. Not the sort of thing you would want to try by hand - at least for big problems. Danger of going way off topic for this forum -- but I hope to report back with theoretical shortest total distance to visit every SC in N.A. -- or we just ask @Bighorn to give us his odometer reading.

I’m thinking you can get to 1000 with fewer than 382k miles, by now

 

[Teefal]

For the moment, I'll likely just try to keep this running with bubble gum and baling wire in the hopes @Teefal can get his app going. Aurora could definitely be an option if needed.

I'm nearly done with RDS on AWS, with endpoints. Whole spreadsheet. I can prioritize Tableau connection before web/mobile app.

 

[dgpcolorado]

I also gave a PhD student the challenge of finding minimum distance (and time) to visit all USA National Parks in a Model 3 - including a listing of what SCs are required - and if any parks are not feasible due to distance from SC. Getting in and out of Big Bend in TX is a challenge without using L2s? She's still working on that one...

A difficult to visit National Park in the lower 48 is Glacier NP. It is about 134 miles from the Missoula MT Supercharger Station and that's not counting driving through the park on "Going to the Sun Road." Another moderately difficult to visit national park is Capitol Reef NP.

I'm sure there are others but those are two I've scoped out for possible visits. My difficulty is that my car has far less range than even the SR version of the Model 3.

 

[theflyer]

I'm nearly done with RDS on AWS, with endpoints. Whole spreadsheet. I can prioritize Tableau connection before web/mobile app.

Personally, I think that'd be great. In my view, the top four priorities are:

1. Get a relational database structure working and demonstrate that data from the spreadsheet can be imported.
2. Enable a connection that would allow me to create and test a copy of the Tableau visualizations using your RDS as the source.
   
3. Enable a way for the admins to update supercharger locations
4. Enable a way for each competitor to update their visits (and only their visits), admins can update all.
5. Build a feature-rich Android and IOS app

As soon as #1 is done, I could begin working on a new version of the existing visualization that would connect to the RDS instead of the spreadsheet.

Once features 3 and 4 are working in some manner and tested via an MVP app or tool, we could lock the spreadsheet and bring all data into the RDS instance and promulgate the new visualization. This would become the way we work going forward.

Then, everything else can build from there as time and interest allow.

 

[bmah]

I’m thinking you can get to 1000 with fewer than 382k miles, by now

Now for someone to tighten that upper bound...

Bruce.

 

[TreborThickweb]

@NKYTA
You don’t own an inn, you keep it

This article reminded me of our historic meetup with said keeper.

Opinion: This town powered America for decades. What do we owe them? — CNN

I found Gillette fascinating. Stayed in the Best Western one night and noticed a sign for a $5 tour of one of the strip mines. Worth the time and money. Notice the power cord running to the excavator, it’s all electric! Careful backing up! I think the mine, just north of the airport closed last year.

 

[juliusa]

I hope to report back with theoretical shortest total distance to visit every SC in N.A.

I wonder if it will calculate the shortest route before a new supercharger is opened and has to start over again.

 

[LoudMusic]

I don't know what format you're looking for on bulk data, so here you go!


Supercharger - Visited Date
Ozark, AR - 2020/11/21
Lowell, AR - 2020/11/21
Poncha Springs, CO - 2021/1/17
Colorado Springs, CO - 2020/12/29
Limon, CO - 2020/12/27
Silverthorne, CO - 2020/9/17
Washington - Market St NE, DC - 2020/11/27
Newark, DE - 2020/09/27
Olathe, KS - 2020/12/27
Colby, KS - 2020/12/27
Salina, KS - 2020/12/27
Hays, KS - 2020/12/27
Bowling Green, KY - 2020/12/06
Lexington, KY - 2020/12/06
Annapolis, MD - 2020/09/11
Gaithersburg, MD - 2020/09/18
North East, MD - 2020/11/05
Grasonville, MD - 2020/09/27
Mehlville, MO - 2020/08/07
Springfield, MO - 2020/12/26
Rolla, MO - 2020/08/07
Elizabeth, NJ - 2020/09/27
Edison, NJ - 2020/09/27
Lake Placid, NY - 2020/09/26
Clinton Corners, NY - 2020/09/27
Syracuse, NY - 2020/09/26
Utica, NY - 2020/09/26
Lancaster, PA - 2020/09/17
York, PA - 2020/09/17
Moosic, PA - 2020/09/25
Cookeville, TN - 2020/08/22
Dickson, TN - 2020/08/22
Bristol, TN - 2020/10/04
Memphis, TN - 2020/08/22
Jackson, TN - 2020/10/04
Knoxville, TN - 2020/10/30
Vienna, VA - 2020/10/03
Salem, VA - 2020/11/27
Staunton, VA - 2020/08/23
Haymarket, VA - 2020/11/06
Springfield, VA - 2020/08/25
Fredericksburg, VA - 2020/08/25
Mt. Jackson, VA - 2020/11/26
Wytheville, VA - 2020/08/23
Lexington, VA - 2020/12/05
Strasburg, VA - 2020/12/05
Morgantown, WV - 2020/12/06
Charleston, WV - 2020/12/06

 

[cpa]

View attachment 630242 I still think your wife's note at the farewell dinner was the kindest and most loving statement I've ever heard.

Are those maracas? Where are the mariachis? Where are your sombreros?

 

[cpa]

I posted the wrong maintenance window snippet, there was one a week ago - doing this on the iPad with no work access.
One of our DS engineers is doing a Tableau deep dive next week, I’ll report any findings.
Not used BigQuery (Google Cloud software).
Our DB(s) is/are Amazon Aurora RDS (MySQL) but we pay for Immuta, which is a middleware layer. In HealthCare, scrubbing ePHI is incredibly important. Immuta is costly, but not required for this purpose. But Aurora is relatively inexpensive. If you want to move in that direction, I have operational experience and cost knowledge and some TSLA $$ if I were to not HODL .

McClearly we evolved beyond Google Sheets!

This is a fun game! I'd like to play too.

Should the DSUE be elected? When and who should report IRD? Maybe we ought to debate the merits of a GRAT, CRUT, and CRAT. Should we file a Section 83 election on those stock options? Is there a substantial risk of forfeiture? How much are the hot assets in your partnership?

Your turn!

 

[Bighorn]

Are those maracas? Where are the mariachis? Where are your sombreros?

The maracas were, for a time, the leader’s prize to hold, like the Stanley Cup. We did have a nice Mexican repast across the street at Los Compadres.

 

[juliusa]

I don't know what format you're looking for on bulk data, so here you go!

Welcome to the game! Checking in with 48 visits.

 

[theflyer]

I don't know what format you're looking for on bulk data, so here you go!


Supercharger - Visited Date
Ozark, AR - 2020/11/21
Lowell, AR - 2020/11/21
Poncha Springs, CO - 2021/1/17
Colorado Springs, CO - 2020/12/29
Limon, CO - 2020/12/27
Silverthorne, CO - 2020/9/17
Washington - Market St NE, DC - 2020/11/27
Newark, DE - 2020/09/27
Olathe, KS - 2020/12/27
Colby, KS - 2020/12/27
Salina, KS - 2020/12/27
Hays, KS - 2020/12/27
Bowling Green, KY - 2020/12/06
Lexington, KY - 2020/12/06
Annapolis, MD - 2020/09/11
Gaithersburg, MD - 2020/09/18
North East, MD - 2020/11/05
Grasonville, MD - 2020/09/27
Mehlville, MO - 2020/08/07
Springfield, MO - 2020/12/26
Rolla, MO - 2020/08/07
Elizabeth, NJ - 2020/09/27
Edison, NJ - 2020/09/27
Lake Placid, NY - 2020/09/26
Clinton Corners, NY - 2020/09/27
Syracuse, NY - 2020/09/26
Utica, NY - 2020/09/26
Lancaster, PA - 2020/09/17
York, PA - 2020/09/17
Moosic, PA - 2020/09/25
Cookeville, TN - 2020/08/22
Dickson, TN - 2020/08/22
Bristol, TN - 2020/10/04
Memphis, TN - 2020/08/22
Jackson, TN - 2020/10/04
Knoxville, TN - 2020/10/30
Vienna, VA - 2020/10/03
Salem, VA - 2020/11/27
Staunton, VA - 2020/08/23
Haymarket, VA - 2020/11/06
Springfield, VA - 2020/08/25
Fredericksburg, VA - 2020/08/25
Mt. Jackson, VA - 2020/11/26
Wytheville, VA - 2020/08/23
Lexington, VA - 2020/12/05
Strasburg, VA - 2020/12/05
Morgantown, WV - 2020/12/06
Charleston, WV - 2020/12/06

@LoudMusic, welcome to the game! Be careful because it can become quite addictive. Your data is now on the visualization. You can use the following link to get to your maps:

• Your "not yet visited" map. This is configured to show construction locations as well. You'll see the structure of the URL and can remove the construction locations if you like.

Once you're on this map, there is a toggle in the upper right corner to flip over and see the locations you've visited color-coded by year.

In all cases, each dot has a menu of information about that location. Mouse over (tap on mobile) the dot to expose the pop-up. When the pop-up is open, click to expose the links.

 

[PLUS EV]

I dodged enforcement at the Florida border and avoided NYC when they cracked down. My BIL got stopped in FL about an hour before I got to the border, so I had fair warning. I have not encountered anything personally as a result.

What was the Florida border thing anyway? I just lied and said that I hadn't been to NJ, NY, CT, or LA within the last two weeks as I didn't want to be hassled obviously. The truth was that I had driven through LA earlier that day, but I literally only stopped at one supercharger in the wee hours and stayed in my car while I charged. I didn't stop for food or even to go to the bathroom in that state so the entirety of my LA exposure was touching the supercharger handle (and using hand sanitizer afterwards).

 

[LoudMusic]

What was the Florida border thing anyway? I just lied and said that I hadn't been to NJ, NY, CT, or LA within the last two weeks as I didn't want to be hassled obviously. The truth was that I had driven through LA earlier that day, but I literally only stopped at one supercharger in the wee hours and stayed in my car while I charged. I didn't stop for food or even to go to the bathroom in that state so the entirety of my LA exposure was touching the supercharger handle (and using hand sanitizer afterwards).

This is the recommended procedure for Louisiana even in non-covid times

But I'm in the top 100! And that's even when trying to avoid using Superchargers.

Here's a screenshot of a map I keep for myself. I've been dropping pins for J1772, Tesla Destination/wall, NEMA 14-50, and NEMA 5-15. Do I get a special badge if/when I visit all the Arkansas Superchargers?