I recently bought a new gps and wanted to add some poi csv files. I got those poi files from here but found that many of them had missing information (no city, state or zip code) so I decided to try to update them with the data from some gps-zip code files. My idea was to use the gps coordinates, search the gps-zipcode files and insert the closest matching city/state/zip code information into the address.
I downloaded 2 gps-zipcode files (one from poi-factory and one from another source) and tried to do the updates. While much of it worked I was still left with a lot of empty and missing information because the zip code files are old and have many missing zip codes (for example the zip code I live in is missing from both files). In addition one of the files contains some very strange zip codes (for example, 350XX and 350HH) and all of those entries are missing city names.
I was wondering if anyone had any links to recent zip code files that I could use or had any information about what zip codes ending in XX and HH mean. I was also wondering if there were any projects to update these files to fill in the missing information.
Have you tried opening in Excel and then expanding the Height of the Rows and the Width of the Columns?
It's likely that the information will be visible once you expand. Sample below
1255 Hamilton-Lebanon Rd
Monroe OH 45050
If a gpx file was created from a csv file, you might also find all the info, including address, in the Description portion, when you use EPE to open.
If the Latitude and Longitude are correct, the address and postal code are nice to have, but not absolutely necessary.
I don't know if it's only me, but when I try to do a "find" a zip code on EPE, it crashes. Probably it doesn't support 43,190 entries or zip codes such as the one downloaded from POI Factory.
My idea was to use the gps coordinates, search the gps-zipcode files and insert the closest matching city/state/zip code information into the address.
If they have street addresses, but not the city/state/zip, you could run them through an address normalizer. You'd sometimes have to pick from multiple matches, but you'd have something much better than guessing the zip.
If it would be of any help
terms | privacy | contactCopyright © 2006-2020