Wiki Superchargers Visited

[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.

 

[tes-s]

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.

 

[tes-s]

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?

 

[Shesmyne2"]

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

thanks, HDB. I was super proud & really happy for them both. It was def a moment in time.

 

[Bighorn]

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).

We both had been in NJ for a funeral the previous week. He told the truth at the checkpoint and got pulled out of line for information gathering. I got detoured off 95 because Nav mapped me around the traffic at the check point, so I missed any encounter or need to lie.