duplicate poi checker ?

POI Verifier application by Retired Technician will check and give you "duplicate" coordinate entries in .csv files. And will show you them in a log file.

It is a shareware (minimal fee) and can be found at http://www.poiverifier.com/

In your Excel Spread sheet at the time you want to check for duplicates how many columns have data?

I can build a Macro for Excel that will find all duplicates and delete them. But I need to know how many columns of data you are checking at that time.

PS. Do you know how to create a Macro in EXCEL if I provide the script in text?

There is a program that is a add on to excel called ASAP Utilities that will find duplicates and color code them.Is does all kind of good things.There is a free and licensed version. See http://www.download.com/ASAP-Utilities/3640-2077_4-10781628....

Does ASAP also work with Microsoft Works ???????

Please disregard the above post of mine.

My macro only works if the coordinates are identical.

I use this macro with the RR Xing data because the coordinate data "IS" identical on all duplicates in the Federal Railroad Admin Database.

You can use excel to calculate the approximate distance to a "home" point, then sorting by the distance you can easily find any duplicates.

The formula to calculate the approx distance would be:

=POWER(POWER(A2-$A$1,2)+POWER(B2-$B$1,2), 0.5)*101

This is not an exact distance, but is a very simple calculation to come pretty close to the real distance, the error will increase as the distance increases significantly.

Put the coordinates of your "home" location in the first row (A1 & B1) or hard code instead of the $A$1 and $B$1 in the formula, copy the formula to all rows in a new column, and then sort by that distance.

A macro could also be used to highlight POIs too close to each other.

UPDATE:

I just realized that this won't work, as you can have POIs in opposite directions that are at the same distance from the "home" (or reference) location, but deppending on the number and distribution of the POIs, this might help.

Oh well!

I've used this program to eliminate duplicate POIs in CSV files:
http://www.poiedit.com

You can specify the maximum distance used to determine if two POIs are duplicates.

I your POI file is less than say 500 POIs do a sort of columns A, B, and C all in assending order then visually look for duplicates in the data. Just a suggestion. If bigger than 500 pois it depends on how much programing time is involved vs. visual inspeciton of the data with the above sort.

I have now been using a editor called "CSVed" it really is quite good and can do a lot of differnt things. Search on google for the site. I am not sure the web page at this time.

Give it a try.. I use this with POI Verify .. Its the only real tools I need!!

I found this on the faq.

ASAP Utilities 4.2 will run on all computers that meet the requirements of MS Office Excel 2000, 2002/XP, 2003 or 2007 and have MS Windows as operating system (including the new Vista). For people that still use Excel 97 there is a (very) old version available

All,

Excel 2007 will do this for you. - no need to purchase ASAP or build a macro!

The SOFTWARE exists in two versions: an Unregistered Version and a Registered (paid) Version

You need to give it a try first.It does a lot of things plus shortcuts.

I totally agree with Charlesd45. If are you going to use Excel to edit Pois then you should load ASAP and see all of it benefits.

You don't have to put all them formulas in.It works great when going to a vendors web page to get all the locations that are more then one line with the info.A few clicks and all the data pulled to one line on excel without the formula.Can combine two columns of data very easy.Still learning all the ins and out of it.