new & interesting places for your GPS

Drive in movie

 

Jmarqua has put together a file that has over 500 drive in locations covering the US and Canada in raw form that is ready to be processed into longitude latitude coordinates so that we can get it into the database. Any volunteers send me an email and I will set you up with the file.

Miss Poi

Happy to help

Just let me know what I can do.

BTW, if you already have a file with the names, address, city, state, can't you save it in excel, copy the entire list, and paste it into batchgeocode?

--
Garmin StreetPilot c530, Mapsource

Miss POI, I have already

Miss POI,
I have already began working with JMarqua and more than 2/3 of those sites completed and will be sending the file back to him in day or so to put on the finishing touches.. but I do appreciate those who would have volunteered to help out..
NickJr

--
NickJr Nuvi 3597LMT

Thanks Nick ;) Miss Poi

Thanks Nick wink

Miss Poi

Mkahn, I have been doing the

Mkahn,
I have been doing the coding by hand, Could you tell for future coding how you go about doing it by batchgecoding.
Thanks
NickJr

--
NickJr Nuvi 3597LMT

Batch Geocoding

Nickjr
It is quite easy. You utilize the website: http://www.batchgeocode.com/

You need to supply the address, city, state, and/or optionally the zipcode in separate fields from an excel file.
What I do is create a spreadsheet as follows:
Name, Address, City, State, Zip. Make sure to use these headings in the first row.

Copy all of the fields in the spreadsheet (limit of 100 at a time). (Note, do not have quote marks in the fields as this seems to hang the program).

Paste into the appropriate field on batchgeocode.

Select button to verify. It will match the appropriate fields.

Select button to geocode.

Result is a listing (as you provided) with two additional columns, latitude, and longitude.

Copy the resulting data and paste into a new worksheet in excel.

My next step is to create a worksheet in the proper order for a .csv file. In the first column, the formula is = (the longitude field), the second column = (the latitude field), the third field is = to the name field, and the fourth field uses the concatenate function to join the city, state, zip into one field.

You can do the same thing by concatenating the 3rd field and or, you could have created an additional column to submit which includes the phone number for example.

Finally, save the worksheet as your final .csv file.

BTW, I only just found out about this simple method. Another member had mentioned the site in his posting. I just used it for creating a .csv file for all of my contacts. It took under 10 minutes from start to finish.

--
Garmin StreetPilot c530, Mapsource

Batch Geocoding

That is a SUPER site! Thank you very much. I just gave it a spin with my recent submittal of Roller coasters. I copied in my column four that included phone numbers to mess things up, and it found 43 of the 49 locations I tested. Nick, think we found a new partner on future project! I also want to add that I have already found one drive-in out of state that made our list, but soon will be condos. So I encourage ALL that if they find any other errors to let us know, and we can keep current. Doubt I will be driving past 576 drive-ins in the near future to verify all.

Garmin 350

Glad to help

Glad to help. I am looking forward to the listing of Drive-ins.

--
Garmin StreetPilot c530, Mapsource

mkahn, Thanks for the

mkahn,
Thanks for the information.. I will definitely try it the next time I create POI's

--
NickJr Nuvi 3597LMT

Thanks!

Wow I will have to try this on my Zoo POI when I have the time.

Michael

--
Garmin Nuvi 3597, Garmin StreetPilot 2720, Garmin 76CSx (Hand Held), Iphone 4S (Motion-X)

Was the Drive-In Movie POI's ever released?

I see only California. Even if they aren't confirmed we could use the phone# to call ahead. Thanks to all.

Full POI is listed as "Drive-In Theaters USA & Canada"

Sorry, was searching for "Movie". Is listed under Attractions category.

Batch Geocoding

jmarqua wrote:

That is a SUPER site! Thank you very much. I just gave it a spin with my recent submittal of Roller coasters. I copied in my column four that included phone numbers to mess things up, and it found 43 of the 49 locations I tested. Nick, think we found a new partner on future project! I also want to add that I have already found one drive-in out of state that made our list, but soon will be condos. So I encourage ALL that if they find any other errors to let us know, and we can keep current. Doubt I will be driving past 576 drive-ins in the near future to verify all.

Garmin 350

You must have missed it when it was posted before. Here is another site that I use for looking up single addresses, I haven't tried the batch mode on this one yet. I think I'll give it a test run and see if it will handle more then 100 addresses at a time. http://stevemorse.org/jcal/latlonbatch.html

--
Anytime you have a 50-50 chance of getting something right, there's a 90% probability you'll get it wrong.

Thanks for the information,

Thanks for the information, I plan to check it out soon.

--
NickJr Nuvi 3597LMT

Both are excellent sites!

Both are excellent sites! Thank you.

sponsored links



Navigation



User login

Leave this blank! This field helps block spambots.

poi factory



Who's online

There are currently 20 users and 70 guests online.

Online users

  • blackdragon79
  • AC50
  • ajh1165
  • mrnicerideny
  • charlesd45
  • evanpiq
  • gage wheel
  • netdoc
  • Ctwinger
  • brkaho