POI by state?

Well it depends on the POIs you are wanting. You will just have to do your search for the POIs you want and see if there is just a state version.

If there is only a USA version then all you have to do is copy the USA file and remove all the other states.

When you have done that you could then upload that state only version back to poi-factory for the rest of us.

i did DL a list but it's confusing looking at it being listed on MS Excel,can't tell what from what(states)?

Do a quick search for Extra_POI_Editor.

It will help you greatly in your endevors.

Can you show us how to pull out "TX" from "Home Depot USA.csv" using "Extra_POI_Editor". I don't see how it can be done.

I just did it for Chick-fil-A in Texas from the main Chick-fil-A download. For some reason, the main download has 221 locations, but the TX one just had 68??? I used Excel.

I copied the entire address column into another column - maybe Column J. Then do a Find/Replace All for *TX* - repl w/ TX.

Then I scrolled down the sheet and deleted the rows for all the locations that were not the easily recognizable short TX. Then delete the new column, and save the file as ****_TX.csv.

A bit of a pain but it worked.

Oooops. Did not realize you were talking about .csv files with no address associated with them.

Well then I would take the .csv file and covert it using GPXVisualizer, can be found on the internet, and get it to a KML and then open it in Google Earth and pick out the ones you want. Then reconvert it to a GPX and fill in any missing information with EPOIE.

The file requested was "Home Depot USA.csv" not "Chick-fil-A" and the program to use was "Extra_POI_Editor" not Excel. I guess you were trying to be helpful so thanks anyway.

The file requested was "Home Depot USA.csv" not "Chick-fil-A" and the program to use was "Extra_POI_Editor" not Excel. I guess you were trying to be helpful so thanks anyway.

Well actually I was trying to be helpful. And the original question was generic in that it didn't start out hunting Extra_POI_Editor. I was just offering another approach. One can use my approach with any of the .csv files (that have addresses -- that part was unclear in the request) -- doesn't really matter which group of POI's it is.

I thought a big objective of the site was to share info and be helpful.............

You quoted my post that specified ""Home Depot USA.csv" and "Extra_POI_Editor", if you were answering the original post then I suggest you should have quoted that post. I said "thanks" so let's not turn this into a Federal case, Okay?

Hmmm seems pretty confusing for me,lol, i guess i'll just live with the USA list...

thanks everybody.

The address is in the file, you just need to click on a cell in column D if you open the file in Excel.

ASAP is a Add-on utility for Excel. If the address is located on the POI then ASAP can DELETE every row that has a address outside of MI.

Let me know if you need a detail example.

You can find the latitude and longitude values for the borders of your state (on a map), for example. Then Sort the spreadsheet by latitude and eliminate those greater than and less than latitude values for your state. On the remaining data, sort by longitude and do the same thing. This will leave you with the locations that are within a rectangle close to the borders of your state (it will include a few locations just outside the state borders as we are are dealing with a rectangle, however that shouldn't be a problem when you are on the road. This method also works for larger or smaller areas as it is not state or zip code dependent.

I need a detail example using "Home Depot USA.csv" for "TX" that will leave a lat./long. on each line.

Thanks, but it doesn't work too good on "TX", I get parts of Louisiana, Arkansas, Oklahoma, New Mexico, and Mexico. I don't think there is an easy way to do this.

1) Install ASAP
2) open "Home Depot USA.csv" in Excel
3) Select column D (click top of column D)
4) Select ASAP Ultilities/Select/conditional row and...Delete
5) Search option = not like (text)
6) place *, TX* into next open box
7) Handle Row or column? = check row
8) What to do with found... = check delete
9) Click Start
10) click close
11) Save new file

mmullins98 - all you need to do is create a simple find query that looks for ", TX" in the fourth column. Then sort by the results. All of the rows which contain ", TX" will return a number while the rest of the rows will return #VALUE!. Then just delete the #VALUE! rows. Simple.

Never mind, I don't want to spend $49.00 for a solution.

DRMCMTR, Thank you for taking the time to create a step by step direction for creating an automated sorting method for any item from a .csv file in Excel.

It is free for the older version.....

This is one of those damned if you do and damned if you don't type of questions. It is possible to develop POI by state and post them and it is just as easy to do them for the entire country. If you do a state by state listing, then you receive complaints about having to load so many individual files to get the entire country.

Creating one for the entire country results in this type of question - can you do one for my state? I have a POI of over 4000 entries broken down by state and province. I posted the provinces and got the "But I wanted one file for all of Canada" complaint. Retired Technician's POI Verifier II did have the ability to extract a single state from a file, but complaints about having to pay $10 for the software caused him to pull it and discontinue support. So, damned if you do, damned if you don't.

I provided mmullins an easy way to sort the POI's by state. But he hasn't responded. So either he was just trying to cause trouble or he overlooked my post.

Provide more info, just saying create a "simple find query" doesn't tell anybody enough.

If you think I'm trying to create trouble then just butt out and the rest of us will continue.

You don't need POI editor, it's fine but overkill for this. Download a free copy of grep (a common Unix / Linux utility but freely available for Windows). Grep extracts line of text that contain a matching string. The pattern matching can get pretty fancy, but if you would want to just look for TX you would type in the command line:

grep TX POIfilename.csv >POITXfile.csv

and it would search POIfilename.csv and create a new file named POITXfile.csv with just the lines that include TX. If you leave out the >POITXfile.csv it just sends the results to the screen, which itself can be handy or can be a quick check before you create the final file.

This is a very handy tool, and works on any text file, not just POI .csv files. (I just used it not five minutes ago for something completely unrelated to GPS use).

If POIs were consistent this would work great, but unfortunately there are a lot of POIs that don't include the state information at all. In other cases people may express their own individual creativity in putting in a state name (rather than PA you might see Pennsylvania, Penna. Pa. or something else or even a combination of these forms in the same file). But if you dare suggest any guidance for submitters, someone will quickly call you "gestapo" or worse.

Thanks to you also but I have tried grep and the results on "Home Depot USA.csv" yield nothing but:

ABILENE, TX 7960
ALLEN, TX 75013
ALVIN, TX 77511
AMARILLO, TX 791
AMARILLO, TX 791
ARLINGTON, TX 76
ARLINGTON, TX 76
AUSTIN, TX 78704
AUSTIN, TX 78717
AUSTIN, TX 78726
AUSTIN, TX 78744
AUSTIN, TX 78752
AUSTIN, TX 78753

Downloaded the oldest version I could see Mar 19, 2007 Ver. 4.1.0 and it wants to update and will not run.

Download the latest version and retry:

According to thier license agreement:

SOFTWARE VERSIONS; EVALUATION AND REGISTRATION
The SOFTWARE exists in two versions: an Unregistered Version and a Registered (paid) Version. Subject to the terms of this agreement, you are hereby licensed to use the SOFTWARE for evaluation purposes without charge for a maximum of 90 days for commercial purposes. Subject to the terms of this agreement, you are hereby licensed to use the SOFTWARE without charge in a non-commercial organization or for home-use.

i do realise that just having your state poi's IS just a matter of preference. However I just want to point out that since the entire file takes up such little space why not leave it the way it is. After all garmin sorts by distance and i do not think you will get to NY before finding what you need in your state. If sorting by state is your preference...GOOD LUCK!

Store your POIs on a SD card.
Use the ones you want.

I have seen mention over and over again that having excessively many POIs on a GPS will slow it down. True enough, the files are relatively small but that's hardly a reason to put things that you absolutely know that you'll never need on the GPS, or to fault someone else who wants to make the effort to limit bloat.

While I can see the merit of having some national POI lists on a GPS, in many cases the user can easily make a determination that the information contained in a national list just isn't relevant for him. In that case no one should find fault in trying to trim down the list to a more practical set of points.

One other option is to use POI editor to select POIs withing a set radius of you, say 200 miles or so. This may even turn out to be more useful than selection by state.

If using POI editor you may want to

Looks like the file may contain some kind of embedded line break. Might even be some reason that the author thought this should be, but the current guideline offered by many for csv file creation is to just throw in whatever you want and that it would be oppressive to do otherwise. I'll look at the actual file in question and see if I can see what is happening.

By the way, just in case it isn't obvious to any reader, the grep technique is only intended for cvs files, not gpx files. It would work on gpx files if they were one long line per POI, but most gpx files will spam several lines per POI.

"I have seen mention over and over again that having excessively many POIs on a GPS will slow it down."
Is this true if the POIs are on a SD card?
I can understand not wanting to "bloat" the GPS itself.

This file does indeed contain extra line breaks inside what should be filed 4 of the CSV file. My understanding is that this is done for formatting of field 4 on some nuvi models, but that it causes problems on some other nuvi models. I had not thought of this problem, but obviously it is also an issue. I have an approach for easily creating both types of files (as well as GPX files) from the same data, but that discussion has been silenced, so no point in beating a dead horse.

I am confused by one thing. I ran grep against this file too, and only got the city, state zip lines, but I did get the full 5 digit zip each time. I'm very confused on how you could have obtained the lines that are shows above with less than the full 5 digit sips when the city name is sufficiently long. The full city name, TX and zip are there in the file, and grep would not have shortened the lines when used as described (I can't even think of a way to tell grep to shorten the lines, although there very well might be some way to do it).

It was just my copy and paste action, I didn't notice the extra characters were cut off. Thanks again.

The csv does indeed have line breaks embedded. This was done for aesthetic reasons only. I would be glad to reformat the Home Depot USA file without line breaks if it will cause fewer problems.

Jim from Texas contacted me and asked if I could create a Texas state file. I can, and will, certainly do that. Interestingly enough, I started a Home Depot thread (about a year ago) asking members if they thought having the state files would be useful. The comments I received then indicated there was no pressing need for them.

Thanks for the offer however this is not the only file, I see the same in "Costco - USA_V.csv". There may be many more like this and the problem in my opinion is not worth redoing all. Therefore for me I would just say leave as is.

I'm not saying that this change should be made. I already know the unfortunate fact that some model nuvi use the line break while others use the <br> format. The <br> seems more common and I suspect it might cause less problems for nuvis that don't understand <br> than true line breaks cause for nuvi models that don't accept them. And it would be somewhat simpler for a replacement program to replace all <br> with line breaks than to go the other way, since not all line breaks in the file should be converted to <br>. But any discussion that tries to resolve the issue seems to anger some people and gets shut down.

Some people want less than a national file. I don't accept the "pois are small" or "just get a SD memory card" arguments as reasons that people should not be able to strip down a national POI file to just extract a state or two if they want to avoid the bloat. Your POI does least include the state and other important information, and if it were not for tripping over the line break issue the grep trick would have been a simple answer for anyone who wanted one or just a few states. Maintaining and posting one national file makes sense to me, as long as there is a good way to trim it down to one's desired local states. I just didn't anticipate the new line issue.

The Home Depot file contains line breaks.

Download and open the .csv file in Excel.

Copy everything in Excel to Word.

Turn on the "paragraph" symbol and determine a common break between records.

Find/Replace the paragraph" combination with a line break.

Find/Replace the paragraph symbols with tabs.

Copy the find into Excel.

In the column with states, replace , STATE to ,STATE.

Do a data text to columns on the ,.

Now sort by state.

Combine any columns that you want with the concatenate function.

Reading this thread reminds me of the days before Macs and Windows. DOS required the same sort of conversions, confusion and an understanding of the language. The complicated (to me) solutions provided here (Many people thank you for them) seem similar. I'll wait until there are commercial programs to do it.

MMullins, I hope that you receive all the help you desire, but I am somewhat concerned about your tone toward GadgetGuy, I believe that he was just trying to help and a come back like that was not truly in the spirit of the users of this forum.
This is not meant to elevate your ire, but to bring attention to my observation of this thread.

mmullins98, Did you get ASAP to load? There are other features that you will like in this utility.

ALL, you can convert the line breaks in Excel with a Find/Replace command. In the find box type the following (nothing will appear in the box) HOLD down ALT key and type 0010 then in the replace box type <br> or anything else.....

This should be applied to column D (address portion)

Yes I loaded ASAP and with your previous example it does solve the problem and is easy enough. Thanks for recommending ASAP and I'm sure I'll find more uses for it.

When you have time check out the following:

ASAP/information/Count duplicate in selection
ASAP/text/Delete leading and trailing spaces
ASAP/test/convert to upper/lower case
ASAP/Column&Row/Merge column
ASAP/format/Advance transpose