Pickleball is one of the fastest growing AMERICAN sports today. The usapa.org lists where to play on a sloppy excel spreadsheet. Can anyone create a POI from this? Right now I must add these 1 at a time as I'm still too new to create a POI file. I prefer GPX but can convert.
Thanks... this is my first post.
Welcome to poi-factory.
If it was a downloadable form it wouldn't be bad, but it is an on-line one and that means all the data has to be created one at a time.
We have numerous help files in our faq section. You could start small to make sure you have what you want and then go from there. You will find a lot of helpful members willing to guide and assist you.
One of the problems with the listings is the data isn't consistent in they all don't show the city, state (prov) and post code on a separate line. There are several other inconsistencies in the data that also makes generating a CSV or GPX from the web listing extremely difficult. It is nice they provide decimal coordinates, but each should be verified for accuracy.
I agree. That's why I said it was a sloppy spreadsheet.
I guess I'll need to create a clean spreadsheet to begin with... once created it should be easy, yes?
Never heard of it.
Around here, we play cornhole.
I was interested to see if anyone had done a Pickleball POI and my search ended up here at CBrownell's post. I had been manually entering all the PB locations in my area into my new GPS and thought that there must be a better way. As a recently retired computer programmer/analyst (and active Pickleballer), I decided to take on the creation of a Pickeball POI on as a challenge.
If you File Save As the Places To Play State webpage display with the option "Webpage HTML only (*.htm *.html)" to your local computer, you get a well-formed HTML. Dont save it as *.mht.
After looking at trying several options, I have been successful in writing a series of Perl scripts that convert any PB STATE webpage into a "POI formatted" csv file. I had to jam the state in the middle of the "city, zip code" field for the POI, etc.
I still need to test the csv by loading it on my GPS. A work in progress, as I am new at this GPS stuff. Let me know if you are interested in a particular state's PB POI as a csv.
I hjad great success getting KIA Canada's dealers, in exactly the format that I wanted, just by contacting them and explaining what I was trying to do, as well as providing a link to POI Factory for them to see.
I simply asked for a spreadsheet, with separate Columns for Name, Street Address, City, Province, Phone, etc.
I got an answer in about 2 weeks and I then manipulated the spreadsheet to suit my needs and imported into EPE.
Pickleball is played on a court that's roughly the size of a badminton court, with the net set roughly the height of a tennis net. The paddle looks like an over sized ping pong paddle about 8" x 10". The ball is a hard plastic wiffle ball roughly the size of a tennis ball.
If you think it's a slow game, because it's largely played by the +55 year crowd, you'd be mistaken, at least based on how we play it in Kitchener, Ontario.
The game is easier on the knees that tennis, due to the smaller court, but has many of the same elements, of both tennis and ping pong. You can put some nasty spins on the ball, like ping pong, but you have much of the strategy associated with tennis.
It's one awful good cardio workout and good social fun.
Thanks... this is my first post.
You don't allow us to contact you through the site. Please click on my site name and email me, so that I can send you sites in and around Kitchener, Ontario.
I have uploaded a new POI: "Pickleball - Places To Play (CSV)" based on data from the USAPA website. This initial version (from 2013-11-25) contains 2075 sites to play in the US, Canada, and Mexico. Each individual site contains the date it's information was last updated.
Download it from:
I plan to update the file periodically.
Anyone for a game???
terms | privacy | contactCopyright © 2006 - 2015