Home PageFacebookRSS News Feed
PocketGPS
Web
SatNav,GPS,Navigation
Pocket GPS World - SatNavs | GPS | Speed Cameras: Forums

Pocket GPS World :: View topic - Duplicate POI's
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

Duplicate POI's

 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> TomTom Portable Navigation Devices
View previous topic :: View next topic  
Author Message
cdelecole
Regular Visitor


Joined: Jan 05, 2005
Posts: 185

PostPosted: Tue Jan 11, 2005 2:15 pm    Post subject: Duplicate POI's Reply with quote

Simple question for you, dear experts ...

I've merged POI's from different sources, using POIEdit.

I'm pretty sure there are duplicate ones, and I'd like to find them into my POI list.

Do you know about any software that would allow me to look for diuplicate POI's (also POI's distant from 15 meters, for example), and possibli delete them ?

What is the best POI management tool I can use on a PC ? MS Autoroute ?

Thanks !
Back to top
View user's profile Send private message
rkm_hm
Frequent Visitor


Joined: Nov 28, 2004
Posts: 532
Location: Warwick, UK

PostPosted: Tue Jan 11, 2005 2:44 pm    Post subject: Reply with quote

I don't know of anything that will do it straight off. If I were faced with this problem, this is what I would do:
* Convert the .ov2 file to .csv and open it in MS Excel
* Sort it into Latitude order
* Create an additional column and put a formula on each row which compares each entry with the previous entry and returns "DUP" or somesuch if Lat and Long are both within specified tolerances (or calculate the distance from the previous point and set the flag if it is less than a specified amount)
* Scroll down the file looking at marked entries, and decide which ones to delete
* Get rid if the extra column and save the file as a .csv again
* Convert it back into a .ov2

It may sound complicated, but it probably took me longer to describe the prccess than it would to do it!

Roger
Back to top
View user's profile Send private message
Darren
Frequent Visitor


Joined: 11/07/2002 14:36:40
Posts: 23848
Location: Hampshire, UK

PostPosted: Tue Jan 11, 2005 3:01 pm    Post subject: Reply with quote

Oldie's excellent POI Manager will do what you require, it can both check for duplicate entries as well as weed out similar entries that exist within a user defined radius. Download it here.
_________________
Darren Griffin
Back to top
View user's profile Send private message Send e-mail Visit poster's website







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 -> TomTom Portable Navigation Devices 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.051 (01 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