Editing large POI files

 

Is there an easy way to edit large custom poi files to leave only those pois which I will need? SPecifically, I've downloaded a list of sites in ALL 50 states. I want to edit out all but those in 5 or so states in my region. Any suggestions? THanks. Jim

Use Excel

If its a CSV, open it in MS Excel and sort by state. Then either delete everything unwanted, or copy out the states you need and save them to a new file. I can't get this to work in Open Office though, it wants to open .csv files in a text editor.

--
Chuck - Nuvi 200, Nuvi 255W

edit large poi files

Chuck I ran into one problem with that and that is in some of the files they don't put the state in a column so you can sort it

--
johnm405 660 & MSS&T

POI Verifier

you could always d/l POI Verifier and the seperate the indivisual states.

www.PoiVerifier.com

--
Rodney.. oditius.htc@gmail.com BMW Zumo 550 HTC Touch Pro - Garmin XT

Easy with Excel

johnm405 wrote:

Chuck I ran into one problem with that and that is in some of the files they don't put the state in a column so you can sort it

Is the state in the file at all, probably in the description field? Assuming that is the case, go to an empty cell, like A5 and grab the state with a formula, ie:

=RIGHT(A4, 2)

Drag that down through the whole list and then you should be able to sort on that.

On the other hand, if sortable data doesn't exist anywhere in the CSV, then you're SOL and will have to settle with a labor intensive process.

labor intensive???

mike987 wrote:

On the other hand, if sortable data doesn't exist anywhere in the CSV, then you're SOL and will have to settle with a labor intensive process.

Like Oditius said, you can use POI Verifier. Labor intensive?? I don't think so .... select the state abbreviation and away you go!! Don't even need the state name in the file.

RT

--
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."

suggestion

retiredtechnician: You should add text to the POI Verifier website that it can extract state info from the coordinates (or however it does) without having the state name or abbreviation in the file to start with. That is definitely a cool feature - it should be advertised.

answering my own suggestion

Found the text already there. smile

Guess I was skimming too fast. The verifier page stretches wider than my screen so it was harder to read.

Editing Large POI Files

There's an easy way using Excel. Select cell A1, click Data-Filter-AutoFilter. Pull down column filter that contain the states. Select Custom... that Contains - type in the state desired, as formated. Returns only cells with that state contained. Select, Copy and paste those cells visible to a new worksheet. When finished delete original worksheet and save as your new .csv file.

You can do two states at a time using the Custom AutoFilter by selecting: Contains (1st State) Or Contains (2nd State).

But ....

burdtr wrote:

There's an easy way using Excel. Select cell A1, click Data-Filter-AutoFilter. Pull down column filter that contain the states. Select Custom... that Contains - type in the state desired, as formated. Returns only cells with that state contained. Select, Copy and paste those cells visible to a new worksheet. When finished delete original worksheet and save as your new .csv file.

You can do two states at a time using the Custom AutoFilter by selecting: Contains (1st State) Or Contains (2nd State).

But the csv file needs to have the state entered for each POI; and the states have to be spelled the same in every POI ... i.e. always abbreviated or alway not-abbreviated. Many, if not most, POI files do not contain the state. POI Verifier doesn't care as its selections are based on coordinates.

RT

--
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."

Editing large POI files

The best editor I found for the POI is MapSource itself. Just open the file using MapSource and you can edit the POI all you want.

--
RogerLL

.

Except if they are CSV files, you will have to convert them first.