POI's by state

There is an application called "POI Verifier"
which will sort out POIs for an individual state.
It can be purchased for a very modest fee from Retired Technician.
It will also find certain errors in csv POI files that you generate or someone else generates.
Do a search for POI Verifier

program. Just load the file into the spreadsheet then use the sort feature to sort on the state feild (assuming the poi file has a state field - most of them do). Once sorted, select the poi's for your state and save them to a new "csv" file and voila you have your desired poi file!

I think most of the csv files do not have state by themselfs. the address,city,state, and zip is one field. Most common that i have seen are 4 fields..
1 = Long (or lat. I get them confussed.. hehe)
2 = Lat. (or long.. see above)
3 = Name/title of object or place
4 = Address, city,state,zip, and any comments

You still can sort on long and lat, that will get you close to the state you need. POI verifier is much more easyer to use and is a great tool to have in your collection.

field 1 : Long
field 2: Lat
field 3: "red light camera xxxxxx "(unique identifier)
field 4: state (AZ, CA etc ) city poi-factory MMM DD YY (last update)

Since field 4 starts with the STATE, if your sort on field 4 , you get a file sorted by state.......

Once the file is grouped by state, select the records for the state you are interested and save them to a separate file and you have a RED LIGHT POI file for a particular state

Unless the poi has a field that has the state in it you can't sort by state (Home Depot Utah) just example. I tred to do the reststops by lon,lat and it was a nightmare, as there are states where the lon and lat overlap.

Are there any advantages for keeping POI's in a state by state arrangement?

I keep the master Home Depot file as an Excel xls file. In that file, the name, address, city, state, zip, and phone are all separate fields. The csv is created as a new file after concatenating the various fields into the desired format. If the xls file were available, the downloaders could sort/filter to their hearts content. Does anyone know why no (that I've seen) xls files are normally posted on this site?

It would depend on what you are using them for. I use the reststop poi but it is hard to check to see it all of them are there for a certain state. I also use a number of other ones but like Wal Mart if they have the state in them it makes better use to look for different stores. I know when you do a search the gps will show you the one within a 50 mile radius. So to answer your question it all comes to how you are going to use the poi's I know others will have comments this is just mine.

In most poi's that are csv you open them with excel and you can view them that way but if the state info isn't there them they are not much good for state by state sorting. I think it could be a duplucate effort to save them both ways. Miss POI may have an answer for that.

Dear JG,

Thank you. That is a great idea. I had the state at the end of Field 3 in my HESS file. I have edited the file so that the state is now immediately to the right of the first word ("Hess") and the file has been re-sorted by state.

david