GPS POI Home POI FilesPOI ToolsGPS ReviewsPOI MapsGPS ForumSupport

Search   Memberlist   Register   Log in

GPS POI > GPS Forum > GPS POI tools > Customer address to Poi conversion

Post new GPS POI data or GPS devices related topic in GPS POI tools forum   Reply to topic Customer address to Poi conversion    
GPS-Data-Team.com  
Author Message
brendon
GPS:

Guest






PostPosted: 01/27/2009 05:21am    Post subject: Customer address to Poi conversion Reply with quote

Hi I have an extensive list of customer address's with all have post codes on and I want to convert these to poi but not one at a time?
List is in Excel. How do I go about this?
Back to top  |  Link
Terry-UK
GPS:

Guest






PostPosted: 01/27/2009 06:57am    Post subject: Re: UK post code to Poi conversion Reply with quote

I can do it for you if you are happy to pay for my work.
How many addresses?
Terry
Back to top  |  Link
brendon
GPS:

Guest






PostPosted: 01/27/2009 07:16am    Post subject: UK post code to Poi conversion Reply with quote

Problem is the list is evolving and will need regular update so need to learn how to do it myself...

Think I am part way there now!!
Got lat & long but the Long are all minus figures, does that sound right?
Back to top  |  Link
Terry-UK
GPS:

Guest






PostPosted: 01/27/2009 02:28pm    Post subject: Re: UK post code to Poi conversion Reply with quote

Check if the geocoded location is correct: http://garmin.gps-data-team.com/extra/
Back to top  |  Link
V-Power-LA
GPS:

Guest






PostPosted: 05/28/2009 05:55am    Post subject: Re: UK post code to Poi conversion Reply with quote

Terry-UK wrote:
Check if the geocoded location is correct: http://garmin.gps-data-team.com/extra/


You can load your file with addresses or simply copy and paste them to the geocoder input text box.

Here is an example:

30 Leicester Square, London, United Kingdom, WC2H 7LA
24 Grosvenor Square, London, W1A 1AE United Kingdom
23-28 Penn Street, London, N1 5DL

450 W. 33 Street, New York, NY 10001
1014 Fifth Avenue New York, NY 10028
202 W. 1st St., Los Angeles, CA 90012

280 Metcalfe Street; Ottawa
195 Rideau Street, Ottawa
491 Somerset Street Ottawa Ontario

Visualize and confirm all coordinates and save your file to Garmin or any other GPS unit.

Here is a Garmin final output saved as CSV file:

; This POI file was generated by GDT POI Manager - http://www.gps-data-team.com/
-0.1295953, 51.5101173, "30 Leicester Square London United Kingdom"
-0.1488319, 51.5000222, "24 Grosvenor Square London W1A 1AE United Kingdom"
-0.0844774, 51.5360824, "23-28 Penn Street London N1 5DL"
-73.9986466, 40.7535116, "450 W. 33 Street New York NY 10001"
-73.961644, 40.779157, "1014 Fifth Avenue New York NY 10028"
-118.245286, 34.052691, "202 W. 1st St. Los Angeles CA 90012"
-75.6913478, 45.4158297, "280 Metcalfe Street; Ottawa"
-75.6886083, 45.4275552, "195 Rideau Street Ottawa"
-75.7003255, 45.4137236, "491 Somerset Street Ottawa Ontario"

Cheers
Back to top  |  Link
Geotour
GPS:

Guest






PostPosted: 05/29/2009 09:23pm    Post subject: POI Verifier Reply with quote

Terry-UK wrote:
Check if the geocoded location is correct: http://garmin.gps-data-team.com/extra/


Thanks Terry, that is exactly what I need to verify my POI files.

Guide
Back to top  |  Link
basirb
GPS: Garmin Nuvi 255W








PostPosted: 02/15/2010 05:30am    Post subject: Re: Customer address to Poi conversion Reply with quote

brendon wrote:
List is in Excel. How do I go about this?


Brendon,
Export the list as a CSV file, or simply copy and paste all addresses to the geocoder text input box. I usualy firstly use the PoiManager to find GPS coordinates, save that file and load it with the GPX Editor to add media files and proximity tags.
Back to top  |  Link
View user's profile Visit poster's website
Display posts from previous:   

             
Post new GPS POI data or GPS devices related topic in GPS POI tools forum   Reply to topic Customer address to Poi conversion    GPS Forum Index -> GPS POI tools
Page 1 of 1

 
Jump to:  




Copyright Notice: This database and related files are protected by copyright. © GPS_data_team 2004-2010. All rights reserved.


Permalink: Customer address to Poi conversion in GPS POI tools forum