Hello, I'm not sure if this belongs in the forum or not, but I'll give it a shot.

I'm looking for a free downloadable file that lists all zip codes, US cities, counties, and states with time zone, Lat and Long. Unfortunately the only thing I can find online is at https://zipcodedownload.com/Directory/ZIP5, or http://www.zip-code-database.com. While these are free, I cannot download a file and so I'm looking for an updated current file I can download. If anybody has an up-to-date source for this I'd be grateful.

If I need to move this topic just let me know!

Hi James, and welcome to the FM Forums,

I sent you a Private Message

As you might imagine, this need comes up from time to time,

Do this search of Google and follow the links as I'm sure you will find what you need.

site fmforums.com zip code

HTH

Lee

curious why would want to maintain this data, bloating your solution - don't get me wrong I've done it myself it does increase the size of your backups and can be slow to 'lookup' 

you might consider just using an API call to a service to validate an address. smartystreets or googleplaces come to mind.

You can see an implementation of this over at https://www.geistinteractive.com/2018/10/01/introduction-to-karbonfm/

Thank you for the replies. I will examine both of your ideas.