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.
All,
If you are interested in Geo-Coding at the ZipCode (Postal Code) Level. I’ve just noticed that in the T-Stats Server there is a table in the TStatsConfig database called dbo.PostalCodes with 2.4 million Lat Lon values that might be applied geocode all address by Lat Lon value in T_Address geo_location.
--Tom
…
718.724.8135
tbrown@BAM.org
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris JensenSent: Thursday, February 04, 2016 12:03 PMTo: Thomas Brown <tbrown@bam.org>Subject: Re: [Tessitura Technical Forum] RE: RE: Zip Codes and Radius
Arthur Curtis:Thank you. Just to be clear you are storing the Latitude and Longitude in the geo_location field within T_ADDRESS correct?
Arthur Curtis:
Thank you. Just to be clear you are storing the Latitude and Longitude in the geo_location field within T_ADDRESS correct?
Yep: "The SQL Server geography data type stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates."
https://msdn.microsoft.com/en-us/library/cc280766.aspx
From: Arthur Curtis <bounce-arthurcurtis5363@tessituranetwork.com>Sent: 2/4/2016 11:13:57 AM
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!