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.
Has anyone considered Fusion Tables?
https://support.google.com/fusiontables/answer/1657096
--Tom
…
718.724.8135
tbrown@BAM.org
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick ReilinghSent: Thursday, March 20, 2014 6:15 PMTo: Thomas BrownSubject: Re: [Tessitura Technical Forum] RE: RE: Zip Codes and Radius
Hmm. I suppose that’s logical, if we assume that POB-only ZIP codes aren’t tracked by the census bureau because they have no physical location. (This may or may not be true.) You could probably count up and/or down until you get a match and use the nearest codes as an approximation.
On Mar 20, 2014, at 5:54 PM, Lucie Spieler <bounce-luciespieler8144@tessituranetwork.com> wrote:
I looked at the census data. Missing are all postal codes (in my neighborhood, at least) that are PO boxes and not physical addresses.
______________________________Lucie SpielerIT Development and Training ManagerFLORIDA GRAND opera
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!