Data Investigation
06030
39.0894700953993
-108.603844128782
West
193594
39309
50
3871.88
Avg
06063
40.3949513128822
-104.752418242794
North
102647
22028
347
295.812680115274
Low
06425
39.5659497521844
-104.963419627962
South
420723
40040
177
2376.96610169492
Avg
06485
39.547923345389
-105.004378379427
South
429420
8053
467
919.528907922912
Low
07244
39.7353807812525
-105.158602165396
North
272794
28257
500
545.588
Low
07259
39.7079750106666
-105.079593464114
North
396363
20423
98
4044.52040816327
High
07460
39.61025
-105.102561998008
North
278481
17795
141
1975.04255319149
Avg
07819
39.5360029559179
-104.882161280587
South
148536
33180
373
398.219839142091
Low
08249
40.1539758293748
-105.130880232718
North
50363
37998
426
118.223004694836
Low
08435
40.49141
-105.17206
North
440048
14585
422
1042.76777251185
Avg
08572
38.4445031764824
-107.868762521369
West
388466
33485
248
1566.39516129032
Avg
08718
39.512461936532
-104.773681099946
South
490621
31542
314
1562.4872611465
Avg
09054
38.2957684868545
-104.605575269211
South
250805
27939
207
1211.61835748792
Avg
09512
39.6509989218304
-105.009629985681
South
158651
15318
105
1510.9619047619
Avg
09624
39.63391
-106.07817
West
441613
46400
282
1566.00354609929
Avg
10153
39.95612
-105.170238898972
North
79900
9753
442
180.769230769231
Low
10470
39.9142371325916
-104.97461
North
126863
22287
185
685.745945945946
Low
10871
39.887067720445
-105.07723297492
North
480344
19145
73
6580.05479452055
High
11623
39.9589645174803
-104.993910773208
North
495435
23762
277
1788.57400722022
Avg
11756
39.7893
-105.109698464403
North
240991
4038
367
656.651226158038
Low
Store Information
False
True
Lat
Lon
False
FreeformAddress=True,StreetNumber=True,StreetName=True,MunicipalitySubdivision=True,Municipality=True,CountrySecondarySubdivision=True,CountrySubdivision=True,Country=True,CountryCode=True,CountryCodeISO3=False,PostalCode=True,Lat=True,Lon=True,Type=True,Score=True,SpatialObj=True
True
Reverse Geocode based on Lat/Lon
Store Num=False,Lat=False,Lon=False,Region=False,Total Sales=False,Credit Sales=False,Total Customers=False,Avg Sales per Customer=False,Perf Indicator=False,FreeformAddress=True,StreetNumber=True,StreetName=True,MunicipalitySubdivision=True,Municipality=True,CountrySecondarySubdivision=True,CountrySubdivision=True,Country=True,CountryCode=True,PostalCode=True,Lat/Lon Output=False
False
True
5000
False
10
Field Summary Tool to get an idea of summary information of Non-Street Address fields
C:\ProgramData\Alteryx\Engine\Engine_3560_bc6b39949bd744b69314165a07524b23_\Engine_9576_02e05aa4135a410b9ba2f8834897169b_.yxdb
Single
Report
CASS Validation
False
True
Lat
Lon
False
FreeformAddress=True,StreetNumber=True,StreetName=True,MunicipalitySubdivision=False,Municipality=False,CountrySecondarySubdivision=True,CountrySubdivision=True,Country=True,CountryCode=False,CountryCodeISO3=False,PostalCode=True,Lat=False,Lon=False,Type=False,Score=False,SpatialObj=False
True
Reverse Geocoder based on Lat/Lon
2
100
Corporate
No
JEAN
SMITH
39.7097342857143
-104.918581741593
3
100
Corporate
No
JULIA
CARRERA
39.7009275356545
-105.012175941854
5
100
Home Office
No
LINDA
TREVINO
39.7939240392764
-105.015644744517
6
106
Home Office
No
H
MACK
39.74162
-104.966148340861
7
105
Home Office
No
MARISSA
LATTA
39.6064016372081
-104.849237400256
8
101
Home Office
No
PHYLLIS
WALKER
39.5871251428571
-104.962487942571
9
105
Home Office
No
VIVIAN
GAULDEN
39.778242949727
-104.829779947848
10
100
Home Office
No
PAMELA
WRIGHT
39.7239928674084
-104.959232244898
11
106
Home Office
No
MARIA
GONZALEZ
39.7707029975632
-105.040646477717
12
108
Home Office
No
WANDA
MAYBERRY
39.746908566321
-105.082754280269
14
105
Small Business
No
KATHLEEN
KIRBACH
39.6743147430863
-104.835153505675
15
104
Small Business
Yes
BERNADETTE
MCKALE
39.6402369673855
-104.784774079027
16
103
Small Business
No
JEANNINE
QUINLAN
39.7940857151194
-105.052900133329
17
107
Small Business
No
CYNTHIA
LOUY
39.9180434365499
-105.082784784243
18
104
Small Business
No
MICHAELA
BOLLWITT
39.6449538652297
-104.823147225862
19
102
Small Business
No
JENNIFER
CAMPBELL
39.5682573035422
-104.722953273192
20
100
Small Business
No
KRISTA
FLOREZ
39.664674026209
-104.799148906669
21
100
Small Business
Yes
AVIVA
HEIFETS
39.6531879477447
-104.937241282934
23
107
Corporate
Yes
LUCINDA
MAIA
39.7856068421053
-105.062461545177
24
105
Corporate
No
ROBIN
WALLIN
39.7576487755102
-104.949018382359
Customer Information
FreeformAddress
PostalCode
Run through CASS to validate before mailing to customers
Horizontal
ReverseGeocoder_Examples