Metadata imported.
Process Date: 12/05/06
Metadata imported.
Process Date:
Geocoded unmatched rows from 1 to 149294 in 434 seconds
Street Level geocoding
Mixed Case Off
Geocoding Preferences --
House Number Required
Street Name Relaxed
City Name Not Required
Zip Code Relaxed
Clear output columns on no match
Offset from road = 20
Offset from corner = 25
Geocoding Results
Matched 142826 95.7%
Not matched 6468 4.3%
Previous Matched 0 0.0%
Deleted 0 0.0%
Of those matched
Street Matched 142826 95.7%
Point House (S8) 0 0.0%
Point House Interpolated (S7) 0 0.0%
Point Zip (S6) 22 0.0%
Street Level (S5) 133052 89.1%
ShapePath (S4) 1129 0.8%
ZIP+4 (S3) 1040 0.7%
ZIP+2 (S2) 5764 3.9%
ZIP Code (S1) 1627 1.1%
No Centroid (S0) 192 0.1%
ZIP Centroid Matched 0 0.0%
Point Zip (Z6) 0 0.0%
ZIP+4 (Z3) 0 0.0%
ZIP+2 (Z2) 0 0.0%
ZIP Code (Z1) 0 0.0%
No Centroid (Z0) 0 0.0%
Intersection Matches 0 0.0%
Addresses Corrected 11231 7.5%
House Number 0 0.0%
Street Name 1684 1.1%
City 9344 6.3%
ZIP Code 1377 0.9%
Process Date: 12/04/06
Dataset moved.
Process Date:
Metadata imported.
Process Date:
2/ 20/2007
GEOCODIN.RRS
UNDER
Data uality .. Process step
D:\Accumail\GEOCODIN.RRS report was run to extract records from the Centrax
database to create a file named Accumail.dbf
Centrax
2/ 20/2007
Accumail..DBF is processed to standardize Addresses
Smart Marketin Suit
3/20/07
Standardized file is run in MapMarker Plus V.12.1.0.16 file gests the latistude and
longitude fields populated. the following information below refers to the reesults of
this process
********************************************************************************
MapMarker (TM) Plus 12.1.0.16 Log Table D:\Accumail\Accumail.TAB Created
3-19-2007 03:33:23PM
Geocoded unmatched rows from 1 to 150244 in 601 seconds
Street Level geocoding
Mixed Case Off
Geocoding Preferences --
House Number Required
Street Name Relaxed
City Name Not Required
Zip Code Relaxed
Clear output columns on no match
Offset from road = 20
Offset from corner = 25
Geocoding Results
Matched 143898 95.8%
Not matched 6346 4.2%
Previous Matched 0 0.0%
Deleted 0 0.0%
Of those matched
Street Matched 143898 95.8%
Point House (S8) 0 0.0%
Point House Interpolated (S7) 0 0.0%
Point Zip (S6) 25 0.0%
Street Level (S5) 134394 89.5%
ShapePath (S4) 1135 0.8%
ZIP+4 (S3) 1048 0.7%
ZIP+2 (S2) 5753 3.8%
ZIP Code (S1) 1543 1.0%
No Centroid (S0) 0 0.0%
ZIP Centroid Matched 0 0.0%
Point Zip (Z6) 0 0.0%
ZIP+4 (Z3) 0 0.0%
ZIP+2 (Z2) 0 0.0%
ZIP Code (Z1) 0 0.0%
No Centroid (Z0) 0 0.0%
Intersection Matches 0 0.0%
Addresses Corrected 11160 7.4%
House Number 0 0.0%
Street Name 1547 1.0%
City 9404 6.3%
ZIP Code 1350 0.9%
Input columns:
Firm ------------>
Address ---------> Add1_fixed
Address2 -------->
City ------------> City
State -----------> State
ZIP -------------> Zip
ZIP+4 ----------->
Urbanization ---->
Output columns:
Longitude <------- Longitude
Latitude <-------- Latitude
ResultCode <------ Georesult
Firm <------------
Street <----------
City <------------
State <-----------
ZIP Code <--------
ZIP+4 <-----------
Urbanization <----
Census Block <---- Censusid
Delivery Point <--
OCheck Digit <----
Carrier Route <---
LACS <------------
PMB Designator <--
PMB Range <-------
Street2 <---------
Default Flag <----
Creating Points <- Yes
Dictionary Locations:
Dictionary Path: \\dohsdbshpe0001\apps\MapInfo\MapMarker\MapMarker_USA_v12\DATA
States Licensed: AA FL MX
States Available: FL MX
End of Report for table D:\Accumail\Accumail.TAB on 3-19-2007 03:33:23PM
********************************************************************************
Process description: Dataset moved.
Source used: S:\EH_Directors\EhgisData\Centrax\BioMedicalWaste
********************************************************************************
3/21/07 imported ans updated Metadata
Process Date: 2/20/07 - 3/21/07
May 3, 2007 D:\Accumail\GEOCODIN.RRS report was run to extract records from
the Centrax database to create a file named Accumail.dbf. Accumail..DBF file is
processed to standardize Addresses using Smart Marketing Suit. Once againg
using the file Accumail.sbf is run in MapMarker Plus V.12.1.0.16 prgram which
adds the latitude and longitude fields populated. The following information below
refers to the results for this process:
********************************************************************************
MapMarker (TM) Plus 12.1.0.16 Log Table D:\Accumail\Accumail.TAB Created 5-3-2007 11:56:36AM
Geocoded unmatched rows from 1 to 153410 in 405 seconds
Street Level geocoding
Mixed Case Off
Geocoding Preferences --
House Number Required
Street Name Relaxed
City Name Not Required
Zip Code Relaxed
On multiple match:
Pick Street Address over ZIP+4
Clear output columns on no match
Offset from road = 20
Offset from corner = 25
Geocoding Results
Matched 23753 15.5%
Not matched 129657 84.5%
Previous Matched 0 0.0%
Deleted 0 0.0%
Of those matched
Street Matched 23753 15.5%
Point House (S8) 0 0.0%
Point House Interpolated (S7) 0 0.0%
Point Zip (S6) 13 0.0%
Street Level (S5) 159 0.1%
ShapePath (S4) 22320 14.5%
ZIP+4 (S3) 2 0.0%
ZIP+2 (S2) 5 0.0%
ZIP Code (S1) 1254 0.8%
No Centroid (S0) 0 0.0%
ZIP Centroid Matched 0 0.0%
Point Zip (Z6) 0 0.0%
ZIP+4 (Z3) 0 0.0%
ZIP+2 (Z2) 0 0.0%
ZIP Code (Z1) 0 0.0%
No Centroid (Z0) 0 0.0%
Intersection Matches 0 0.0%
Addresses Corrected 15237 9.9%
House Number 0 0.0%
Street Name 8340 5.4%
City 4702 3.1%
ZIP Code 9100 5.9%
Input columns:
Firm ------------>
Address ---------> Name
Address2 -------->
City ------------> City
State -----------> State
ZIP -------------> Zip
ZIP+4 ----------->
Urbanization ---->
Output columns:
Longitude <------- Longitude
Latitude <-------- Latitude
ResultCode <------ Georesult
Firm <------------
Street <----------
City <------------
State <-----------
ZIP Code <--------
ZIP+4 <-----------
Urbanization <----
Census Block <---- Censusid
Delivery Point <--
OCheck Digit <----
Carrier Route <---
LACS <------------
PMB Designator <--
PMB Range <-------
Street2 <---------
Default Flag <----
Creating Points <- Yes
Dictionary Locations:
Dictionary Path: \\dohsdbshpe0001\apps\MapInfo\MapMarker\MapMarker_USA_v12\DATA
States Licensed: AA FL MX
States Available: FL MX
End of Report for table D:\Accumail\Accumail.TAB on 5-3-2007 11:56:36AM
********************************************************************************
May 3,2007 ArcMap Document was open and automatically updated with the
latest Accumail file. Files were exported according to its File Code and copied to
the S Drive
May 8, 2007 Metadata was imported and updated
Process Date: May 3-8, 2007
The following fields were added to the GEOCODIN.RRS report:
CTY_NAME: County Name
LAT: GPS Y coordinate
LONG:GPS X coordinate
June 8, 2007 D:\Accumail\GEOCODIN.RRS report was run to extract records
from the Centrax database to create a file named Accumail.dbf.June
12Accumail..DBF file is processed to standardize Addresses using Smart
Marketing Suit. June 14, using the file Accumail.sbf is run in MapMarker Plus
V.12.1.0.16 prgram which adds the latitude and longitude fields populated. The
following information below refers to the results for this process:
********************************************************************************
MapMarker (TM) Plus 12.1.0.16 Log Table D:\Accumail\Accumail.TAB Created 6-14-2007 10:55:42AM
Geocoded unmatched rows from 1 to 153887 in 600 seconds
Street Level geocoding
Mixed Case Off
Geocoding Preferences --
House Number Required
Street Name Relaxed
City Name Not Required
Zip Code Relaxed
On multiple match:
Pick Street Address over ZIP+4
Clear output columns on no match
Offset from road = 20
Offset from corner = 25
Geocoding Results
Matched 148019 96.2%
Not matched 5868 3.8%
Previous Matched 0 0.0%
Deleted 0 0.0%
Of those matched
Street Matched 148019 96.2%
Point House (S8) 0 0.0%
Point House Interpolated (S7) 0 0.0%
Point Zip (S6) 26 0.0%
Street Level (S5) 138058 89.7%
ShapePath (S4) 1249 0.8%
ZIP+4 (S3) 1063 0.7%
ZIP+2 (S2) 6012 3.9%
ZIP Code (S1) 1611 1.0%
No Centroid (S0) 0 0.0%
ZIP Centroid Matched 0 0.0%
Point Zip (Z6) 0 0.0%
ZIP+4 (Z3) 0 0.0%
ZIP+2 (Z2) 0 0.0%
ZIP Code (Z1) 0 0.0%
No Centroid (Z0) 0 0.0%
Intersection Matches 0 0.0%
Addresses Corrected 12285 8.0%
House Number 0 0.0%
Street Name 1814 1.2%
City 10235 6.7%
ZIP Code 1493 1.0%
Input columns:
Firm ------------>
Address ---------> Add1_fixed
Address2 -------->
City ------------> City
State -----------> State
ZIP -------------> Zip
ZIP+4 ----------->
Urbanization ---->
Output columns:
Longitude <------- Longitude
Latitude <-------- Latitude
ResultCode <------ Georesult
Firm <------------
Street <----------
City <------------
State <-----------
ZIP Code <--------
ZIP+4 <-----------
Urbanization <----
Census Block <---- Censusid
Delivery Point <--
OCheck Digit <----
Carrier Route <---
LACS <------------
PMB Designator <--
PMB Range <-------
Street2 <---------
Default Flag <----
Creating Points <- Yes
Dictionary Locations:
Dictionary Path: \\dohsdbshpe0001\apps\MapInfo\MapMarker\MapMarker_USA_v12\DATA
States Licensed: AA FL MX
States Available: FL MX
End of Report for table D:\Accumail\Accumail.TAB on 6-14-2007 10:55:42AM
********************************************************************************
June 14,2007 ArcMap Document was open and automatically updated with the
latest Accumail file. Files were exported according to its File Code and copied to
the S Drive
June 15, 2007 Metadata was imported and updated
June 18 data was posted to the Internet
Process Date: June 8-18, 2007
Metadata imported.
Process Date:
Report GEOCODIN.RRS was modified to have the following fields:
Added X,Y columns to contain information for field GPS collection
Renamed the headers for LATITUD/LONGITUD to LAT/LONG where the
geocoded coordinates are populated by MapMarker
Added the COUNTYNR, CITY_NAME, EDESCRIPT
June 28, 2007 D:\Accumail\GEOCODIN.RRS report was run to extract records
from the Centrax database to create a file named Accumail.dbf.
July 2 Accumail.DBF file is processed using using Smart Marketing Suit to
standardize Addresses .
July 6, using the file Accumail.sbf is run using MapMarker (TM) Plus 12.3.0.30 to
geocode and apopulates the latitude and longitude fields. The following
information below refers to the results for this process:
********************************************************************************
MapMarker (TM) Plus 12.3.0.30 Log Table D:\Accumail\Accumail.TAB Created 7-6-2007 02:41:32PM
The USPS data vintage is: April 2007
The Geographic data vintage is: April 2007
Geocoded unmatched rows from 1 to 149244 in 683 seconds
Street Level geocoding
Mixed Case Off
Geocoding Preferences --
House Number Required
Street Name Relaxed
City Name Not Required
Zip Code Relaxed
On multiple match:
Pick Street Address over ZIP+4
Clear output columns on no match
Offset from road = 20
Offset from corner = 25
Geocoding Results
Matched 143257 96.0%
Not matched 5987 4.0%
Previous Matched 0 0.0%
Deleted 0 0.0%
Of those matched
Street Matched 143257 96.0%
Point House (S8) 0 0.0%
Point House Interpolated (S7) 0 0.0%
Point Zip (S6) 26 0.0%
Street Level (S5) 135229 90.6%
ShapePath (S4) 1274 0.9%
ZIP+4 (S3) 640 0.4%
ZIP+2 (S2) 4899 3.3%
ZIP Code (S1) 1189 0.8%
No Centroid (S0) 0 0.0%
ZIP Centroid Matched 0 0.0%
Point Zip (Z6) 0 0.0%
ZIP+4 (Z3) 0 0.0%
ZIP+2 (Z2) 0 0.0%
ZIP Code (Z1) 0 0.0%
No Centroid (Z0) 0 0.0%
Intersection Matches 0 0.0%
Addresses Corrected 37614 25.2%
House Number 0 0.0%
Street Name 11098 7.4%
City 20065 13.4%
ZIP Code 10712 7.2%
Input columns:
Firm ------------>
Address ---------> Add1_fixed
Address2 -------->
City ------------> City
State -----------> State
ZIP -------------> Zip
ZIP+4 ----------->
Urbanization ---->
Output columns:
Longitude <------- Long
Latitude <-------- Lat
ResultCode <------ Georesult
Firm <------------
Street <----------
City <------------
State <-----------
ZIP Code <--------
ZIP+4 <-----------
Urbanization <----
Census Block <---- Censusid
Delivery Point <--
OCheck Digit <----
Carrier Route <--- Edescript
LACS <------------
PMB Designator <--
PMB Range <-------
Street2 <---------
Default Flag <----
Creating Points <- Yes
Dictionary Locations:
Dictionary Path: \\dohsdbshpe0001\apps\MapInfo\MapMarker\MapMarker_USA_v12\DATA
States Licensed: AA FL MX
States Available: FL MX
End of Report for table D:\Accumail\Accumail.TAB on 7-6-2007 02:41:32PM
********************************************************************************
July 6, 2007 ArcMap Document was open and updated with the latest Accumail
file. Files were exported according to its File Code and copied to the S Drive
June 9 2007 Metadata was imported and updated
July 10 data was posted to the Internet
Process Date: 6/28 - 7/10
Metadata imported.
Process Date:
July, 2007 D:\Accumail\GEOCODIN.RRS report was run to extract records from
the Centrax database to create a file named Accumail.dbf. Accumail..DBF file is
processed to standardize Addresses using Smart Marketing Suit. Once againg
using the file Accumail.sbf is run in MapMarker Plus V.12.1.0.16 program which
adds and populates fields for the latitude and longitude. The information below
refers to the results for this process:
********************************************************************************
MapMarker (TM) Plus 12.3.0.30 Log Table D:\Accumail\Accumail.TAB Created 8-7-2007 10:27:11AM
The USPS data vintage is: April 2007
The Geographic data vintage is: April 2007
Geocoded unmatched rows from 1 to 154593 in 658 seconds
Street Level geocoding
Mixed Case Off
Geocoding Preferences --
House Number Required
Street Name Relaxed
City Name Not Required
Zip Code Relaxed
On multiple match:
Pick Street Address over ZIP+4
Clear output columns on no match
Offset from road = 20
Offset from corner = 25
Geocoding Results
Matched 149505 96.7%
Not matched 5088 3.3%
Previous Matched 0 0.0%
Deleted 0 0.0%
Of those matched
Street Matched 149505 96.7%
Point House (S8) 0 0.0%
Point House Interpolated (S7) 0 0.0%
Point Zip (S6) 26 0.0%
Street Level (S5) 140393 90.8%
ShapePath (S4) 1373 0.9%
ZIP+4 (S3) 896 0.6%
ZIP+2 (S2) 5500 3.6%
ZIP Code (S1) 1317 0.9%
No Centroid (S0) 0 0.0%
ZIP Centroid Matched 0 0.0%
Point Zip (Z6) 0 0.0%
ZIP+4 (Z3) 0 0.0%
ZIP+2 (Z2) 0 0.0%
ZIP Code (Z1) 0 0.0%
No Centroid (Z0) 0 0.0%
Intersection Matches 0 0.0%
Addresses Corrected 13604 8.8%
House Number 0 0.0%
Street Name 2476 1.6%
City 10362 6.7%
ZIP Code 2262 1.5%
Input columns:
Firm ------------>
Address ---------> Add1_fixed
Address2 -------->
City ------------> City
State -----------> State
ZIP -------------> Zip
ZIP+4 ----------->
Urbanization ---->
Output columns:
Longitude <------- Long
Latitude <-------- Lat
ResultCode <------ Georesult
Firm <------------
Street <----------
City <------------
State <-----------
ZIP Code <--------
ZIP+4 <-----------
Urbanization <----
Census Block <---- Censusid
Delivery Point <--
OCheck Digit <----
Carrier Route <--- Edescript
LACS <------------
PMB Designator <--
PMB Range <-------
Street2 <---------
Default Flag <----
Creating Points <- Yes
Dictionary Locations:
Dictionary Path: \\dohsdbshpe0001\apps\MapInfo\MapMarker\MapMarker_USA_v12\DATA
States Licensed: AA FL MX
States Available: FL MX
End of Report for table D:\Accumail\Accumail.TAB on 8-7-2007 10:27:11AM
********************************************************************************
August, 2007 ArcMap Document was open and automatically updated with the latest Accumail
file. Files were exported according to its File Code and copied to the S Drive
August, 2007 Metadata was imported and updated
Process Date: Unknown
Metadata imported.
Process Date:
August, 2007 D:\Accumail\GEOCODIN.RRS report was run to extract records
from the Centrax database to create a file named Accumail.dbf. Accumail..DBF file
is processed to standardize Addresses using Smart Marketing Suit. Once againg
using the file Accumail.sbf is run in MapMarker Plus V.12.1.0.16 program which
adds and populates fields for the latitude and longitude. The information below
refers to the results for this process:
********************************************************************************
MapMarker (TM) Plus 12.3.0.30 Log Table D:\Accumail\Accumail.TAB Created 8-27-2007 08:25:42AM
The USPS data vintage is: April 2007
The Geographic data vintage is: April 2007
Geocoded unmatched rows from 1 to 154671 in 688 seconds
Street Level geocoding
Mixed Case Off
Geocoding Preferences --
House Number Required
Street Name Relaxed
City Name Not Required
Zip Code Relaxed
On multiple match:
Pick Street Address over ZIP+4
Clear output columns on no match
Offset from road = 20
Offset from corner = 25
Geocoding Results
Matched 149563 96.7%
Not matched 5108 3.3%
Previous Matched 0 0.0%
Deleted 0 0.0%
Of those matched
Street Matched 149563 96.7%
Point House (S8) 0 0.0%
Point House Interpolated (S7) 0 0.0%
Point Zip (S6) 26 0.0%
Street Level (S5) 140415 90.8%
ShapePath (S4) 1350 0.9%
ZIP+4 (S3) 891 0.6%
ZIP+2 (S2) 5529 3.6%
ZIP Code (S1) 1352 0.9%
No Centroid (S0) 0 0.0%
ZIP Centroid Matched 0 0.0%
Point Zip (Z6) 0 0.0%
ZIP+4 (Z3) 0 0.0%
ZIP+2 (Z2) 0 0.0%
ZIP Code (Z1) 0 0.0%
No Centroid (Z0) 0 0.0%
Intersection Matches 0 0.0%
Addresses Corrected 13667 8.8%
House Number 0 0.0%
Street Name 2497 1.6%
City 10412 6.7%
ZIP Code 2249 1.5%
Input columns:
Firm ------------>
Address ---------> Add1_fixed
Address2 -------->
City ------------> City
State -----------> State
ZIP -------------> Zip
ZIP+4 ----------->
Urbanization ---->
Output columns:
Longitude <------- Long
Latitude <-------- Lat
ResultCode <------ Georesult
Firm <------------
Street <----------
City <------------
State <-----------
ZIP Code <--------
ZIP+4 <-----------
Urbanization <----
Census Block <---- Censusid
Delivery Point <--
OCheck Digit <----
Carrier Route <--- Edescript
LACS <------------
PMB Designator <--
PMB Range <-------
Street2 <---------
Default Flag <----
Creating Points <- Yes
Dictionary Locations:
Dictionary Path: \\dohsdbshpe0001\apps\MapInfo\MapMarker\MapMarker_USA_v12\DATA
States Licensed: AA FL MX
States Available: FL MX
End of Report for table D:\Accumail\Accumail.TAB on 8-27-2007 08:25:42AM
********************************************************************************
August, 2007 ArcMap Document was open and updated with the latest Accumail
file. Files were exported according to its File Code and copied to the S Drive
and the Metadata was imported and updated
Process Date: August 2007
October, 2007 D:\Accumail\GEOCODIN.RRS report was run to extract records
from the Centrax database to create a file named Accumail.dbf. The file is
processed to standardize Addresses using Smart Marketing Suit. Next is run in
MapMarker Plus V.12.1.0.16 program which adds and populates fields for the
latitude and longitude. The information below refers to the results for this process:
********************************************************************************
MapMarker (TM) Plus 12.3.0.30 Log Table D:\Accumail\Accumail.TAB Created 10-19-2007 08:23:18AM
The USPS data vintage is: April 2007
The Geographic data vintage is: April 2007
Geocoded unmatched rows from 1 to 154620 in 695 seconds
Street Level geocoding
Mixed Case Off
Geocoding Preferences --
House Number Required
Street Name Relaxed
City Name Not Required
Zip Code Relaxed
On multiple match:
Pick Street Address over ZIP+4
Clear output columns on no match
Offset from road = 20
Offset from corner = 25
Geocoding Results
Matched 149499 96.7%
Not matched 5121 3.3%
Previous Matched 0 0.0%
Deleted 0 0.0%
Of those matched
Street Matched 149499 96.7%
Point House (S8) 0 0.0%
Point House Interpolated (S7) 0 0.0%
Point Zip (S6) 25 0.0%
Street Level (S5) 140282 90.7%
ShapePath (S4) 1342 0.9%
ZIP+4 (S3) 886 0.6%
ZIP+2 (S2) 5595 3.6%
ZIP Code (S1) 1369 0.9%
No Centroid (S0) 0 0.0%
ZIP Centroid Matched 0 0.0%
Point Zip (Z6) 0 0.0%
ZIP+4 (Z3) 0 0.0%
ZIP+2 (Z2) 0 0.0%
ZIP Code (Z1) 0 0.0%
No Centroid (Z0) 0 0.0%
Intersection Matches 0 0.0%
Addresses Corrected 13682 8.8%
House Number 0 0.0%
Street Name 2523 1.6%
City 10398 6.7%
ZIP Code 2251 1.5%
Input columns:
Firm ------------>
Address ---------> Add1_fixed
Address2 -------->
City ------------> City
State -----------> State
ZIP -------------> Zip
ZIP+4 ----------->
Urbanization ---->
Output columns:
Longitude <------- Long
Latitude <-------- Lat
ResultCode <------ Georesult
Firm <------------
Street <----------
City <------------
State <-----------
ZIP Code <--------
ZIP+4 <-----------
Urbanization <----
Census Block <---- Censusid
Delivery Point <--
OCheck Digit <----
Carrier Route <--- Edescript
LACS <------------
PMB Designator <--
PMB Range <-------
Street2 <---------
Default Flag <----
Creating Points <- Yes
Dictionary Locations:
Dictionary Path: \\dohsdbshpe0001\apps\MapInfo\MapMarker\MapMarker_USA_v12\DATA
States Licensed: AA FL MX
States Available: FL MX
End of Report for table D:\Accumail\Accumail.TAB on 10-19-2007 08:23:18AM
********************************************************************************
October 2007 ArcMap Document was open and updated with the latest Accumail
file. Files were exported according to its File Code to the S Drive and the Metadata
was imported and updated
Process Date: October
December 2007 D:\Accumail\GEOCODIN.RRS report was run to extract records
from the Centrax database to create a file named Accumail.dbf. Accumail.DBF file
is processed to standardize Addresses using Smart Marketing Suit. Once againg
using the file Accumail.dbf is run in MapMarker Plus V.12.1.0.16 program which
adds and populates fields for the latitude and longitude. The information below
refers to the results for this process:
********************************************************************************
MapMarker (TM) Plus 12.3.0.30 Log Table D:\Accumail\Accumail.TAB Created 12-3-2007 10:50:27AM
The USPS data vintage is: April 2007
The Geographic data vintage is: April 2007
Geocoded unmatched rows from 1 to 152319 in 1986 seconds
Street Level geocoding
Mixed Case Off
Geocoding Preferences --
House Number Required
Street Name Relaxed
City Name Not Required
Zip Code Relaxed
On multiple match:
Pick Street Address over ZIP+4
Clear output columns on no match
Offset from road = 20
Offset from corner = 25
Geocoding Results
Matched 147231 96.7%
Not matched 5088 3.3%
Previous Matched 0 0.0%
Deleted 0 0.0%
Of those matched
Street Matched 147231 96.7%
Point House (S8) 0 0.0%
Point House Interpolated (S7) 0 0.0%
Point Zip (S6) 25 0.0%
Street Level (S5) 138071 90.6%
ShapePath (S4) 1238 0.8%
ZIP+4 (S3) 874 0.6%
ZIP+2 (S2) 5635 3.7%
ZIP Code (S1) 1388 0.9%
No Centroid (S0) 0 0.0%
ZIP Centroid Matched 0 0.0%
Point Zip (Z6) 0 0.0%
ZIP+4 (Z3) 0 0.0%
ZIP+2 (Z2) 0 0.0%
ZIP Code (Z1) 0 0.0%
No Centroid (Z0) 0 0.0%
Intersection Matches 0 0.0%
Addresses Corrected 13548 8.9%
House Number 0 0.0%
Street Name 2459 1.6%
City 10335 6.8%
ZIP Code 2183 1.4%
Input columns:
Firm ------------>
Address ---------> Add1_fixed
Address2 -------->
City ------------> City
State -----------> State
ZIP -------------> Zip
ZIP+4 ----------->
Urbanization ---->
Output columns:
Longitude <------- Long
Latitude <-------- Lat
ResultCode <------ Georesult
Firm <------------
Street <----------
City <------------
State <-----------
ZIP Code <--------
ZIP+4 <-----------
Urbanization <----
Census Block <---- Censusid
Delivery Point <--
OCheck Digit <----
Carrier Route <--- Edescript
LACS <------------
PMB Designator <--
PMB Range <-------
Street2 <---------
Default Flag <----
Creating Points <- Yes
Dictionary Locations:
Dictionary Path: \\dohsdbshpe0001\apps\MapInfo\MapMarker\MapMarker_USA_v12\DATA
States Licensed: AA FL MX
States Available: FL MX
End of Report for table D:\Accumail\Accumail.TAB on 12-3-2007 10:50:27AM
********************************************************************************
ArcMap Document was open and updated with the latest Accumail file. Files were
exported accordinly to its File Code to to shape and converted to KML file formats
and saved in the S Drive. Metadata was imported and updated. Each individual
shape file and corresponding metadata were zip, KML and metadata files were zip
and all zip files were posted to the Internet
Process Date: Dec 5-10 2007
Metadata imported.
Process Date:
February 2008 D:\Accumail\GEOCODIN.RRS report was run to extract records
from the Centrax database to create a file named Accumail.dbf. Accumail.DBF file
is processed to standardize Addresses using Smart Marketing Suit. Once againg
using the file Accumail.dbf is run in MapMarker Plus V.12.1.0.16 program which
adds and populates fields for the latitude and longitude. The information below
refers to the results for this process:
MapMarker (TM) Plus 12.3.0.30 Log Table D:\Accumail\Accumail.TAB Created
1-30-2008 09:13:54AM
The USPS data vintage is: April 2007
The Geographic data vintage is: April 2007
Geocoded unmatched rows from 1 to 152940 in 647 seconds
Street Level geocoding
Mixed Case Off
Geocoding Preferences --
House Number Required
Street Name Relaxed
City Name Not Required
Zip Code Relaxed
On multiple match:
Pick Street Address over ZIP+4
Clear output columns on no match
Offset from road = 20
Offset from corner = 25
Geocoding Results
Matched 147813 96.6%
Not matched 5127 3.4%
Previous Matched 0 0.0%
Deleted 0 0.0%
Of those matched
Street Matched 147813 96.6%
Point House (S8) 0 0.0%
Point House Interpolated (S7) 0 0.0%
Point Zip (S6) 26 0.0%
Street Level (S5) 138611 90.6%
ShapePath (S4) 1220 0.8%
ZIP+4 (S3) 878 0.6%
ZIP+2 (S2) 5670 3.7%
ZIP Code (S1) 1408 0.9%
No Centroid (S0) 0 0.0%
ZIP Centroid Matched 0 0.0%
Point Zip (Z6) 0 0.0%
ZIP+4 (Z3) 0 0.0%
ZIP+2 (Z2) 0 0.0%
ZIP Code (Z1) 0 0.0%
No Centroid (Z0) 0 0.0%
Intersection Matches 0 0.0%
Addresses Corrected 13664 8.9%
House Number 0 0.0%
Street Name 2538 1.7%
City 10368 6.8%
ZIP Code 2207 1.4%
Input columns:
Firm ------------>
Address ---------> Add1_fixed
Address2 -------->
City ------------> City
State -----------> State
ZIP -------------> Zip
ZIP+4 ----------->
Urbanization ---->
Output columns:
Longitude <------- Long
Latitude <-------- Lat
ResultCode <------ Georesult
Firm <------------
Street <----------
City <------------
State <-----------
ZIP Code <--------
ZIP+4 <-----------
Urbanization <----
Census Block <---- Censusid
Delivery Point <--
OCheck Digit <----
Carrier Route <--- Edescript
LACS <------------
PMB Designator <--
PMB Range <-------
Street2 <---------
Default Flag <----
Creating Points <- Yes
Dictionary Locations:
Dictionary Path: \\dohsdbshpe0001\apps\MapInfo\MapMarker\MapMarker_USA_v12\DATA
States Licensed: AA FL MX
States Available: FL MX
End of Report for table D:\Accumail\Accumail.TAB on 1-30-2008 09:13:54AM
********************************************************************************
ArcMap Document was open and updated with the latest Accumail file. Files were
exported accordinly to its File Code to to shape and converted to KML file formats
and saved in the S Drive. Metadata was imported and updated. Each individual
shape file and corresponding metadata were zip, KML and metadata files were zip
and all zip files were posted to the Internet
Process Date: February 2008
GeoPlan downloaded this dataset from the Florida Department of Health in March
2008. The data downloaded was in shapefile format from the following webpage:
http://www.doh.state.fl.us/environment/programs/ehgis/EhGisDownload.htm
The data was in the following projection:
Albers, Datum North American 1983, Units: Meters
- 480 records deleted that had invalid coordinates outside state boundary
- All records were upcased.
- Changed original layer name from BioMedicalWaste.shp to biomed_waste_feb08
- A DESCRIPT field was added based on NAME
- A FGDLAQDATE field was added based on date GeoPlan downloaded the data
- Reprojected data to FGDL Albers HPGN
Process Date: 20080312
Data imported to ArcSDE and exported as a shapefile.
Process Date: 20080409
|