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.
Hi Tom,
I was just discussing this on another string: http://www.tessituranetwork.com/Community/forums/p/316/46443.aspx#46443
Arthur
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tom Brown Sent: Thursday, February 04, 2016 12:27 PM To: Curtis, Arthur Subject: Re: [Tessitura Technical Forum] RE: RE: Zip Codes and Radius
Is anyone geocoding their addresses more accurately than a Zipcode Centroids lookup?
Or stated diffrently is anyone actual stroring the Lat-Lon of the actual address given by the customer?
If so I'd be interested in the method folks are using to do this geocoding.
There are definitely services out there that one can query over a REST API and get the actual LAT - LON for a specific address.
What are the costs? How many can you do a day?
From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com> Sent: 2/4/2016 12:00:26 PM
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
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!