This time I actually searched TASK and looked for any existing way to identify all constituents that live outside of a 70 mile radius of Houston. Unfortunately, nothing came up.
Would it be easier to identify all zip codes within a 70 mile radius and use a NOT IN (SELECT...) sort of thing, considering that there are a LOT less of those? Even so, how in the world would I do that? Surely, this has been addressed before...
I would appreciate any advice on the subject, Tessiturians.
Trivia Reward: Charles Manson once auditioned [unsuccessfully] for The Monkees.
Would this be data that you could “hook up” to, or would it require a periodic download and import?
Matt Gonzales
Database Administrator
510 Preston St. | Houston | TX 77002
T: 713-980-8702
E: mgonzales@hgo.org
Click here to view our website.
This message is confidential. It may also be privileged or otherwise protected by work product immunity or other legal rules. If you have received it by mistake, please let us know by e-mail reply and delete it from your system; you may not copy this message or disclose its contents to anyone. The integrity and security of this message cannot be guaranteed on the Internet.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick Reilingh Sent: Thursday, March 20, 2014 10:07 AM To: Matt Gonzales Subject: Re: [Tessitura Technical Forum] RE: RE: Zip Codes and Radius
Hi Andrew,
I was interested in getting my hands on this code as well -- can't seem to find it in your profile.
Does anyone have a recommended resource for obtaining up-to-date ZIP code data? I think if you tried hard enough, you could get it from the Google Maps API, but that's a bit beyond me at this moment.
From: Andrew Recinos <bounce-andrewrecinos5925@tessituranetwork.com> Sent: 5/5/2009 8:37:42 PM
Hi Matt,
I think Chris already sent you the sample code off-line, if anyone else is interested, I've posted it to my profile...
Thanks!
Andrew
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Aha -- found it, Andrew.
Matt, I'm pretty sure anything using the Google Maps API would have to be periodically imported -- I believe they keep track of usage and will ask you to pay for access if it seems like you're integrating it as a core part of your app.
I know that there are several commercial options for obtaining ZIP code data, but I just was able to find the publicly-accessible database of latitude and longitudes published by the US Census Bureau:
https://www.census.gov/geo/maps-data/data/gazetteer2013.html
At the bottom of the page content is an item for "ZIP Code Tabulation Areas" which could theoretically be imported into SQL Server for you to run Andrew's code on.