| View previous topic :: View next topic |
| Author |
Message |
PGA_UK
Occasional Visitor
Joined: May 23, 2007
Posts: 11
|
 Posted: Wed Jul 02, 2008 2:38 pm Post subject: POI Database Cleanup Software |
 |
|
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 |
|
 |
Darren
Frequent Visitor
Joined: 11/07/2002 14:36:40
Posts: 23848
Location: Hampshire, UK
|
|
| Back to top |
|
|
Daggers
Lifetime Member
Joined: Jun 20, 2005
Posts: 1096
Location: Solihull, UK
|
| Posted: Wed Jul 02, 2008 5:05 pm Post subject: |
|
|
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 |
|
|
Andy_P
Pocket GPS Moderator
Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London
|
| Posted: Wed Jul 02, 2008 6:20 pm Post subject: |
|
|
Good reply, Daggers  |
|
| Back to top |
|
|
PGA_UK
Occasional Visitor
Joined: May 23, 2007
Posts: 11
|
| Posted: Thu Jul 03, 2008 1:21 pm Post subject: |
|
|
| 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 |
|
|
Andy_P
Pocket GPS Moderator
Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London
|
| Posted: Thu Jul 03, 2008 1:55 pm Post subject: |
|
|
| 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 |
|
|
Daggers
Lifetime Member
Joined: Jun 20, 2005
Posts: 1096
Location: Solihull, UK
|
| Posted: Thu Jul 03, 2008 6:30 pm Post subject: |
|
|
| 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 |
|
|
|
![]() Posted: Today Post subject: Pocket GPS Advertising |
|
|
We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
Have you considered making a donation towards website running costs?. Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!
|
|
| Back to top |
|
|
|
Forum FAQ
Search
Usergroups
Profile
Log in for private messages
Log in
