• Replies 27 replies
  • Subscribers 346 subscribers
  • Views 205 views
  • Users 0 members are here
Related

Zip Codes and Radius

Matt Gonzales
$organization

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.

Parents
  • $organization
    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 Spieler
    IT Development and Training Manager

    FLORIDA 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!

Reply
  • $organization
    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 Spieler
    IT Development and Training Manager

    FLORIDA 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!

Children
No Data