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

Pocket GPS World :: View topic - POI Database Cleanup Software
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

POI Database Cleanup Software

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


Joined: May 23, 2007
Posts: 11

PostPosted: Wed Jul 02, 2008 2:38 pm    Post subject: POI Database Cleanup Software Reply with quote

Does anyone know of any software that will cleanup a POI database?

I.e. Fuel database contains multiple POI's for the same Petrol Station - with each POI being in a very slighlty different location.

The sort of thing I am looking for is software that will detect POI's that are within say 100 Metres of each other and delete all aprt from the first POI
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Darren
Frequent Visitor


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

PostPosted: Wed Jul 02, 2008 3:17 pm    Post subject: Reply with quote

POI Grouper may work:

http://rjdavies.users.btopenworld.com/html/poigrouper.html
_________________
Darren Griffin
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Daggers
Lifetime Member


Joined: Jun 20, 2005
Posts: 1096
Location: Solihull, UK

PostPosted: Wed Jul 02, 2008 5:05 pm    Post subject: Reply with quote

POI Edit has a facility to detect duplicates within a specified distance of one another. Be wary not to set the distance so that you identify two stations on the opposite side of the road as a single duplicate!

However, if you have created your POI files by combining many sub-categories available from this site, you are likely to have got duplicates if you have included things like Unleaded, LPG, BioDiesel or Diesel Direct in your compilation. These are nearly always at a location which is already identified within one of the major fuel suppliers' lists. (E.g See 52.42504,-1.79589 for a site which has Shell and LPG POIs at the same location - for a perfectly valid reason).

If this is the case, you may find it easier to download again, but this time only select the major suppliers' sub-categories, and omit the ones mentioned above.
Back to top
View user's profile Send private message
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London

PostPosted: Wed Jul 02, 2008 6:20 pm    Post subject: Reply with quote

Good reply, Daggers Thumbs Up
Back to top
View user's profile Send private message
PGA_UK
Occasional Visitor


Joined: May 23, 2007
Posts: 11

PostPosted: Thu Jul 03, 2008 1:21 pm    Post subject: Reply with quote

I have downloaded the conslidated files, however - ther are still multiple instances - more noticable in 3d. I have tried POIEdit, but cant seem to find away of reducing the cathment area to less than 1m (mile??). Many thanks for the relies!
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London

PostPosted: Thu Jul 03, 2008 1:55 pm    Post subject: Reply with quote

PGA_UK wrote:
I have downloaded the conslidated files, however - ther are still multiple instances - more noticable in 3d.


That seems very odd...
Assuming we are still talking about your "Fuel" example, are you sure it isn't because of what Daggers said about diesel and LPG causing the duplicates?
If you just make a new download of just Asda, BP, Esso, Gulf, Shell, Sainsbury etc (ie unticking the ones like LPG, Fuelcards, Shell v-power diesel etc) what do you get then?

PGA_UK wrote:
I have tried POIEdit, but cant seem to find away of reducing the cathment area to less than 1m (mile??). Many thanks for the relies!


Nope, that's 1 metre!.
I just tried it and it seemed to work ok for me. Just load your file, go to edit/find duplicates. Enter the range and click on the binoculars icon to do the search.
Back to top
View user's profile Send private message
Daggers
Lifetime Member


Joined: Jun 20, 2005
Posts: 1096
Location: Solihull, UK

PostPosted: Thu Jul 03, 2008 6:30 pm    Post subject: Reply with quote

PGA_UK wrote:
I have downloaded the conslidated files, however - ther are still multiple instances - more noticable in 3d.


Perhaps you can give us an example of one of the locations where these multiple instances happens to be - then someone can look into it. It's a bit difficult to be certain without seeing a specific example of your problem. Yes, there maybe one or two instances where a filling station has changed hands that both old and new are recorded on the PGPSW database, but these are few and far between.

Jus another thought - you're not by any chance using both TomTom and PGPSW databases are you?
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.044 (24 Apr 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