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,

I am curious how once you have the geo_location loaded, how do you select records wtihin a certain radius using the geo_location? 

Thanks,

Seth

Seth Ghitelman said:

I am curious how once you have the geo_location loaded, how do you select records wtihin a certain radius using the geo_location? 

Most recently I've used this data to find Edu constituents within X miles of the Guthrie for e-mail promotions. Please see a code sample attached. This example wasn't used in a dynamic list, but could be modified to do so.

Seth Ghitelman said:

I am curious how once you have the geo_location loaded, how do you select records wtihin a certain radius using the geo_location? 

Most recently I've used this data to find Edu constituents within X miles of the Guthrie for e-mail promotions. Please see a code sample attached. This example wasn't used in a dynamic list, but could be modified to do so.