First time trying this and it's getting much more complicated that I originally thought but I'm trying to get a POI file for all of the marina's in Ontario. I can get a list from here http://www.discoverboating.ca/boating/marinas.aspx?p=ON but I'm having difficulty getting those addresses into a usable form for google earth to create coordinates and then the csv which would include the marina name, address, phone #, etc. Can anyone give me a hand as to suggestions as to how to get that into a useful format? Thanks!!
It looks like that website has most of the info you need. If putting the address into Google earth doesn't work then just zoom in at the city and look for a marina (usually pretty easy to spot.)That will give you the coordinates.
I've been working on a Boat Launch PoI. I find that I can see the boat ramps on Google Earth once I get close, so I can usually get accurate coordinates without having to visit the actual site.
Marinas ought to be even more visible, I would think. It's likely just a matter of getting close enough.
Sounds like a good project. Someone smarter than me will be along soon, I'm sure. If not, I'll try to help.
Given the amount of data available, I was hoping to get it somewhat automated rather than picking them up one by one so that's the part that I'm struggling with. Has anyone come across a tool that you can feed an excel or similar to get the coordinates automatically?
Actually my primary goal was the boat launches however since marinas tend to get associated with them, I took that tact first.
my project is different in that most of the boat launches here don't have addresses. So I started out with basic paper maps - some hand-drawn - found the launches on Google Earth and proceeded from there.
I'm now at the stage of physically verifying each location. Problem is, I keep finding more boat launches!
You have addresses! You can try a batch geocoder like
to get starting coordinates.
The batch geocoder seems pretty good however I'm going to be manually chaging all of the addresses for the remote locations as it has problems with RR#5, Postal codes, etc for addresses. For example, R.R. #6, Highway #7,Perth, ON K7H 3C8 geocodes to somewhere south of Guyana in South America
Yeah, you have to double check coordinates from batch geocoders. Strange things can happen.
I haven't used batch geocoding - I only played around with it - but I'm sure there are other geocoder sites and/or tools that would do the job. Maybe do it better.
Anyway, at least you have a starting point. Good luck and have fun!
terms | privacy | contactCopyright © 2006-2020