Dynamic list by zip code

Anh Le said:

I’d like to have a dynamic list of any patrons in our database who live within 50 miles of our theater.

If you have SQL access to your database, I'd recommend updating the geo_location column in your T_ADDRESS table. With that, creating a dynamic list by distance would be straightforward.

(We get monthly updates of Zip codes (among other data) from zip-codes.com, which includes latitude and longitude values, which I use to populate the geo_location data.)

Chris Jensen For the data from zip-code.com which of their services are you using and what is the level of accuracy of the geolocation lat. lon. data?

• Is it a centroid of a zip code
• Is it to the building, or at least approximate neighborhood. zip-code.com seem to have a zip+4 service.

Do you also use any of the Census data that they are including in their service?

Tom Brown (Past Member) said:

Is it a centroid of a zip code

I assume so. 

Tom Brown (Past Member) said:

Do you also use any of the Census data that they are including in their service?

Yes. We've done Zip updates to keep TR_CITYSTATE up-to-date for over ten years now, were happy with that, but noticed their Zip data includes congressional districts, which Devo had a need for. That eventually led us to upgrade our subscription to include Census data. We've downloaded the 2010 data, and have been informed that 2020 data will be arriving this month.

Tom Brown (Past Member) said:

Is it a centroid of a zip code

I assume so. 

Tom Brown (Past Member) said:

Do you also use any of the Census data that they are including in their service?

Yes. We've done Zip updates to keep TR_CITYSTATE up-to-date for over ten years now, were happy with that, but noticed their Zip data includes congressional districts, which Devo had a need for. That eventually led us to upgrade our subscription to include Census data. We've downloaded the 2010 data, and have been informed that 2020 data will be arriving this month.