Home PageFacebookRSS News Feed
PocketGPS
Web
SatNav,GPS,Navigation
Brixly - Fast, Reliable, Secure UK Web Hosting
Pocket GPS World - SatNavs | GPS | Speed Cameras: Forums

Pocket GPS World :: View topic - bulk OS grid to lat long conversion
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

bulk OS grid to lat long conversion

 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs)
View previous topic :: View next topic  
Author Message
vitty
Occasional Visitor


Joined: Feb 17, 2006
Posts: 2

PostPosted: Fri Feb 17, 2006 6:34 pm    Post subject: bulk OS grid to lat long conversion Reply with quote

Hi,
I have around 5000 (!) os grid refs of sites i work on (mobile phone masts) that i'd like to enter into my garmin i3.
Anyone have an excel file that will do this conversion? i know i can do them one at a time using web based apps, but 5k of them may take a while!!

Ideas?

Vitty
Back to top
View user's profile Send private message
barryd
Frequent Visitor


Joined: Mar 27, 2004
Posts: 285
Location: Cheshire, England

PostPosted: Fri Feb 17, 2006 9:42 pm    Post subject: Reply with quote

Chris n Maria's Waypoint Workbench is an Excel tool for doing exactly this:
Quote:
Provides conversions:
from DD MM SS, DD MM.MMM, DD.DDDD, UTM,UK National Grid ,UK National Grid N&E
to DD MM SS, DD MM.MMM, DD.DDDD, UTM, UK National Grid ,UK National Grid N&E

It's targeted mostly at UK geocachers.
_________________
Barry Davies
Back to top
View user's profile Send private message
vitty
Occasional Visitor


Joined: Feb 17, 2006
Posts: 2

PostPosted: Sun Feb 19, 2006 2:34 pm    Post subject: Reply with quote

spot on! thanks very much. any idea how many points the i3 can handle?
Back to top
View user's profile Send private message
barryd
Frequent Visitor


Joined: Mar 27, 2004
Posts: 285
Location: Cheshire, England

PostPosted: Mon Feb 20, 2006 12:27 am    Post subject: Reply with quote

No idea as I don't have one. There's a FAQ about POI Loader on the garmin website that suggests 5000 may be ambitious, depending on the name lengths:
Quote:
Q. How many POIs can I fit into my unit?
A. There is no set limit on how many POIs can be loaded into the Garmin device. This depends on the size of the POI files and the space available for POIs. The size of the loaded POIs will depend on the amount of text included with each POI and the size of any included bitmaps. Since POIs can be loaded into internal memory or onto SD cards, the space available will vary widely. Typically, the user should be able to fit more than 3000 POIs onto a unit. If the available space is exceeded, POI Loader will tell the user how much space is available in the device and how much space would be required to fit all the POIs that were chosen.

_________________
Barry Davies
Back to top
View user's profile Send private message
limans75
Occasional Visitor


Joined: Mar 14, 2006
Posts: 41

PostPosted: Thu Nov 09, 2006 6:11 pm    Post subject: Reply with quote

vitty wrote:
spot on! thanks very much. any idea how many points the i3 can handle?


Vitti,

I work in the industry and have PM'd you / emailed you on this service, Would like to swap POI's for operators.

Steve
Back to top
View user's profile Send private message







Posted: Today    Post subject: Pocket GPS Advertising

Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs) All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Make a Donation



CamerAlert Database

Click here for the PocketGPSWorld.com Speed Camera Database

Download Speed Camera Database
22.053 (15 May 24)



WORLDWIDE SPEED CAMERA SPOTTERS WANTED!

Click here to submit camera positions to the PocketGPSWorld.com Speed Camera Database


12mth Subscriber memberships awarded every week for verified new camera reports!

Submit Speed Camera Locations Now


CamerAlert Apps



iOS QR Code






Android QR Code







© Terms & Privacy


GPS Shopping