I would do Linux+. I know a lot of people that have it. They make good money with it.

Hello everyone ! You can now submit reviews on the site!!! Let me know if you have any errors

@scottalanmiller

its in there I need to fix the crods but its there.

@scottalanmiller

It should be in potty plotter! I got the dataset of everyone listed.

@DustinB3403 said in Potty Plotter:

Nevermind on the site you said

I'm on the app on android.

Yeah I need to add it.

@DustinB3403 Menu click "map key" if will come up on the button left.

@DustinB3403 said in Potty Plotter:

What I would recommend, if at all possible is a simple color code of "great potties" "good" "fair" "eh" and "avoid at all cost"

Green down to red etc. lol

Click the map key on the site

@DustinB3403 said in Potty Plotter:

Also I love being the 3rd person on the Google Play store to have downloaded an app.

What kind of details do you get from your side of things?

I can see all the database details like. Potties, Reviews, Searches that happen on the site. I can also see if a search on the site comes back with no potties. So that way I know what people want.

@DustinB3403 said in Potty Plotter:

The app seems like a great idea. As a side though if someone makes a travel plan on google maps is there a way to overlay the potty plotter app and make recommendations based on the potties along that way?

Or more importantly potties to avoid?

Hmm No there is not way to do that now but I well put that one the list of things to add. I love that idea.

@RojoLoco said in Potty Plotter:

Tried to add a potty, app crashed. When I reopened it, there was a blue dot, but it wasn't exactly where I tried to put it (really close). Potty name: Office 1

Yeah I saw it hit the database. Your lat lng was 0.0,0.0 Like there was a GPS problem.

@DustinB3403 said in Potty Plotter:

@thegillion said in Potty Plotter:

@DustinB3403 said in Potty Plotter:

Might I recommend adding a required flag for the name and review.

If the name is empty it doesn't allow the potty to be plotted.

Hrm... I know I put Dustin in.

Please remove it also.

Removed.

@DustinB3403 said in Potty Plotter:

Might I recommend adding a required flag for the name and review.

If the name is empty it doesn't allow the potty to be plotted.

@DustinB3403 The app looks at a 5 mile radius around the user. If the user moves it searches in the new radius. You may not have any potties in your area. If you want to test add one just let me know the name and I can remove once done.

@scale Thank you.

I see some people are adding potties.

@JaredBusch Did you get it was the play store ? I know you need to have 5.0 or higher android.

@StrongBad said in Potty Plotter:

@thegillion said in Potty Plotter:

@Dashrender yes that is correct you can only add parties from the app

That's good for security to some degree, but stops people with iPads, I assume (no GPS) and without phones or who don't have a signal at the time from adding potties. You'll limit the available information and growth.

Adding potties from the site is something I have been thinking about adding to the road map.

I would like to thank everyone on here. Also, I have added a lot more potties to the system and app updates. So if you have downloaded it please do so.

@scottalanmiller said in Help with SQL query:

Are you going to do a scheduled batch run on this (tee hee, batch run) like at night to update the reviews?

I was going to do that or pass the ID of the bathroom then fire it on a review or bathroom submission.

@scottalanmiller said in Help with SQL query:

Is this an intentional fast lookup cache table? Because this violated the database integrity. Just a thought while I'm looking for an answer.

The bathroom table is the main table for lookups so yes and the server runs on SSDs with 4gb of ram and two 3.2ghz vCores

@scottalanmiller said in Help with SQL query:

UPDATE bathrooms
   SET bathrooms.Rating = (SELECT AVG(Reviews.Rating)
                   FROM Reviews
                  WHERE Reviews.bathroom_ID = bathrooms.id)

@scottalanmiller said in Help with SQL query:

Did that work?

Yes it did work thank you!!!

@scottalanmiller yes