From wskinner@fast.net Thu Apr 29 09:21:09 1999 Received: from mxu3.u.washington.edu (mxu3.u.washington.edu [140.142.33.7]) by lists.u.washington.edu (8.9.3+UW99.02/8.9.3+UW99.01) with ESMTP id JAA36518 for ; Thu, 29 Apr 1999 09:21:08 -0700 Received: from jennyjump.state.nj.us (jennyjump.state.nj.us [199.20.64.40]) by mxu3.u.washington.edu (8.9.3+UW99.02/8.9.3+UW99.01) with ESMTP id JAA21421 for ; Thu, 29 Apr 1999 09:20:53 -0700 Received: from dohqb01.doh.state.nj.us (DOHQB01.doh.state.nj.us [205.148.40.1]) by jennyjump.state.nj.us (8.9.3/8.9.3) with SMTP id MAA17511; Thu, 29 Apr 1999 12:19:42 -0400 (EDT) Received: from [10.17.1.96] by dohqb01.doh.state.nj.us (AIX 4.1/UCB 5.64/4.03) id AA83378; Thu, 29 Apr 1999 12:20:03 -0400 Message-Id: <3728B0EB.32171AA0@fast.net> Date: Thu, 29 Apr 1999 12:20:11 -0700 From: Ric Skinner X-Mailer: Mozilla 4.5 [en] (WinNT; I) X-Accept-Language: en Mime-Version: 1.0 To: "GIS-L@geoint.com" , WAPHGIS Subject: Data Hygiene for Geocoding Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit We have a very large (1 million records) address file that contains dirty and missing values. The vast majority of dirty values are misspelled street names, misspelled city name, incorrect zip code. We envision data hygiene will correct the dirty data and fill in missing values. We propose to develop a MS-Access data hygiene application and pass the file through prior to geocoding. We are considering using data files from USPS ('City State File'; 'Five Digit ZIP Code File'; http://www.usps.gov/ncsc/products/) and Semaphore Corp's. 'ZIP4' software (http://www.semaphorecorp.com/cgi/zp4.html). Has anyone used any of these products for data hygiene in preparation for geocoding? What other methods are used for data hygiene of large files? I will summarize informative responses that may be of interest to others. -- Ric Skinner Research Scientist -- GIS NJ Dept. of Health & Senior Services Cancer Epidemiology Services 3635 Quakerbridge Rd. P.O. Box 369 Trenton, NJ 08625-0369 Phone: 609-588-3500 FAX: 609-588-3638 wskinner@fast.net and Co-Chair 2nd International Health Geographics Conference (in planning) 1st IHGC website: www.jhsph.edu/ihgc .