IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Software and Applications Forum / Exactly
Post #241,821
by ben_tilly
1/18/06 9:26:04 PM
1/18/06 9:28:16 PM
Reply
New Exactly
Come to think of it, I really did need the geocoding.

There is a problem with apartment buildings where on one lot you have 2 buildings with different addresses, but they're really the same. So I counted as possible dupes to review any two that were close. (I used "within adjacent 100' by 100' boxes, so that range was 100-300 feet.) That I couldn't have done without geocoding, but it was only a nice to have anyways. And it obviously doesn't apply in this case.

Cheers,
Ben
I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Collapse Edited by ben_tilly Jan. 18, 2006, 09:28:16 PM EST
Exactly
I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Collapse All History
     Postal address list cleansing - (Steve Lowe) - (21) - Jan. 18, 2006, 04:11:09 PM EST
         I just did a deduping project kind of like that - (ben_tilly) - (1) - Jan. 18, 2006, 04:30:48 PM EST
             Thanks for the tip! - (Steve Lowe) - Jan. 18, 2006, 06:13:48 PM EST
         do a dump then sort by address. the dupes are identified - (boxley) - (4) - Jan. 18, 2006, 05:16:50 PM EST
             YM, delete HALF of them... Or NOBODY at that address is left -NT - (CRConrad) - Jan. 18, 2006, 05:32:18 PM EST
             2 things - (ben_tilly) - (2) - Jan. 18, 2006, 05:40:57 PM EST
                 so going by lat and long makes more sense, thx -NT - (boxley) - (1) - Jan. 18, 2006, 06:08:25 PM EST
                     There are apps that standardize addresses - (drewk) - Jan. 18, 2006, 06:18:11 PM EST
         Here ya go - (broomberg) - (12) - Jan. 18, 2006, 08:29:18 PM EST
             I think #2 does what I did - (ben_tilly) - (2) - Jan. 18, 2006, 09:02:40 PM EST
                 Your geocoding process standardized first - (broomberg) - (1) - Jan. 18, 2006, 09:10:51 PM EST
                     Exactly - (ben_tilly) - Jan. 18, 2006, 09:28:16 PM EST
             Re: Here ya go - (Steve Lowe) - (8) - Jan. 18, 2006, 11:29:46 PM EST
                 ObLRPD: "Vote him off the island!" - (Another Scott) - (3) - Jan. 18, 2006, 11:36:11 PM EST
                     That'd be harder than giving a bath to a bobcat. -NT - (admin) - (2) - Jan. 18, 2006, 11:49:43 PM EST
                         the trick is... - (cforde) - (1) - Jan. 19, 2006, 01:43:28 AM EST
                             Talk your talk, wee man. -NT - (admin) - Jan. 19, 2006, 07:45:39 AM EST
                 Firstlogic match/consolidate is verra nice - (broomberg) - (3) - Jan. 18, 2006, 11:50:33 PM EST
                     Thanks, having a look. -NT - (Steve Lowe) - Jan. 19, 2006, 02:09:27 AM EST
                     Re "How much is the cost to mail each duplicate each month?" - (CRConrad) - (1) - Jan. 19, 2006, 06:36:40 AM EST
                         Exactly - (Steve Lowe) - Jan. 19, 2006, 11:02:52 AM EST
         Send me a dump of the list in e-mail. - (folkert) - Jan. 19, 2006, 11:17:35 AM EST

Don't just embrace the crazy, sidle up next to it and lick its ear.
88 ms