Store Point
Miles
Create
grid
10 Miles Grid
Remove
word
'Grid'
GridName=SUBSTRING([GridName],4,100)
GridName
Last
GridName
Parse
grid
x & y
1
A
2
B
3
C
4
D
5
E
6
F
7
G
8
H
9
I
10
J
11
K
12
L
13
M
14
N
15
O
16
P
17
Q
18
E
19
S
20
T
21
U
22
V
23
W
24
X
25
Y
26
Z
GridY
Number
Letter
FindAny
Replace
Change
rows to
letters
Force grids
to start at 1
GridX=[GridX]+1
GridY=[GridY]+1
Change
grid to
Integer
Create
final grid
code
GridFinal=[GridY]+[GridX]
C:\ProgramData\Alteryx\Engine\Engine_16400_264d2129b4d0442e9a4887def43e60dd_\Engine_16692_75cb2cf16c73441796403d362f26db45_.xml
5
9
3
Latest:Tele_Atlas_US
#fdfeff
False
Miles
10
0.5
IncomingConnection
Grid
Grid
GridFinal
IncomingConnection
Stores
Store Point
Store Num
Points
Stores
Stores
Base Layers - Points
Placeholder
Base Layers - Lines
Placeholder
Polygons
Grid
Grid
Base Layers - Polygons
Placeholder
Create
map
pdf
Layout
Continuous
1
squeeze
warning
Store Point Touches or Intersects Grid
PerRecord
H
Continuous
480
864
0
Create
map
border
Horizontal Layout
Each Individual Record
Basic
144
Always
Data
==
1
1
Row Rule 1
Create
table of
stores
Basic Table
Store Num - Ascending
PerRecord
H
Continuous
100%
0
Final
layout
Horizontal Layout
Each Individual Record
Layout
Above
\fs29\par
}
]]>
Title
Colorado Stores - North
Index ...
2138
2171 Prairie Center Pkwy
Brighton
CO
80601
39.9552220636093
-104.77737157407
Adams County
North
FS
10470
1001 E 120th Ave
Thornton
CO
80233
39.9142371325916
-104.97461
Adams County
North
FS
11623
14451 Orchard Pkwy
Westminster
CO
80023
39.9589645174803
-104.993910773208
Adams County
North
FS
1662
2800 Pearl St
Boulder
CO
80301
40.0222321701283
-105.257899365334
Boulder County
North
FS
8249
551 S Hover Rd
Longmont
CO
80501
40.1539758293748
-105.130880232718
Boulder County
North
FS
10153
400 Marshall Rd
Superior
CO
80027
39.95612
-105.170238898972
Boulder County
North
FS
2322
1660 W Midway Blvd
Broomfield
CO
80020
39.9219300176364
-105.087915408246
Broomfield County
North
FS
86
7899 Wadsworth Blvd
Arvada
CO
80003
39.840024796184
-105.082088467523
Jefferson County
North
FS
5077
1985 Sheridan Blvd
Edgewater
CO
80214
39.7475167852916
-105.053387902327
Jefferson County
North
FS
7244
14500 W Colfax Ave Unit B1
Lakewood
CO
80401
39.7353807812525
-105.158602165396
Jefferson County
North
FS
7259
456 S Vance St
Lakewood
CO
80226
39.7079750106666
-105.079593464114
Jefferson County
North
FS
7460
9390 W Cross Dr
Littleton
CO
80123
39.61025
-105.102561998008
Jefferson County
North
FS
10871
10445 Reed St
Westminster
CO
80021
39.887067720445
-105.07723297492
Jefferson County
North
FS
11756
5071 Kipling St
Wheat Ridge
CO
80033
39.7893
-105.109698464403
Jefferson County
North
FS
5265
105 W Troutman Pkwy
Fort Collins
CO
80525
40.5285028674084
-105.077762666667
Larimer County
North
FS
5368
2936 Council Tree Ave
Fort Collins
CO
80525
40.5263711037658
-105.021502926145
Larimer County
North
FS
8435
1725 Rocky Mtn Ave
Loveland
CO
80538
40.49141
-105.17206
Larimer County
North
FS
6063
4400 Centerplace Dr
Greeley
CO
80634
40.3949513128822
-104.752418242794
Weld County
North
FS
21798
10853 US Hwy #285 # 285
Conifer
CO
80433
39.44896
-105.26726
Jefferson County
North
Mall
25515
25637 Conifer Rd
Conifer
CO
80433
39.543101494927
-105.293062129297
Jefferson County
North
Mall
21628
8434 S Kipling Pkwy
Littleton
CO
80127
39.56334
-105.109652118474
Jefferson County
North
Mall
22753
9956 W Remington Pl # A1
Littleton
CO
80128
39.57475
-105.0763
Jefferson County
North
Mall
24117
12512 W Ken Caryl Ave
Littleton
CO
80127
39.580057056539
-105.136903768723
Jefferson County
North
Mall
21033
12442 W Ken Caryl Ave
Littleton
CO
80127
39.5801044500552
-105.136760098955
Jefferson County
North
Mall
28365
11747 W Ken Caryl Ave
Littleton
CO
80127
39.5809471325916
-105.130812857143
Jefferson County
North
Mall
26882
8246 W Bowles Ave Unit C
Littleton
CO
80123
39.6094828674084
-105.088932898551
Jefferson County
North
Mall
29514
9914 W Belleview Ave Unit A-1
Littleton
CO
80123
39.6240228674084
-105.108365405405
Jefferson County
North
Mall
28391
3851 S Hwy #74 # 74
Evergreen
CO
80439
39.64336
-105.39257
Jefferson County
North
Mall
24173
30931 Stagecoach Blvd
Evergreen
CO
80439
39.6517842791907
-105.348267043983
Jefferson County
North
Mall
23755
1896 S Wadsworth Blvd
Lakewood
CO
80232
39.68282
-105.081161811089
Jefferson County
North
Mall
23065
1545 S Kipling Ct
Lakewood
CO
80232
39.6883625587251
-105.110620155271
Jefferson County
North
Mall
21697
10611 W Florida Ave
Lakewood
CO
80232
39.6904909365183
-105.116926400552
Jefferson County
North
Mall
24755
13111 W Alameda Pkwy
Lakewood
CO
80228
39.6975007298898
-105.144863641207
Jefferson County
North
Mall
23283
12097 W Alameda Pkwy
Lakewood
CO
80228
39.7079054393072
-105.135200842008
Jefferson County
North
Mall
21063
92 Wadsworth Blvd
Lakewood
CO
80226
39.7183286363636
-105.081261719382
Jefferson County
North
Mall
29903
9160 W Colfax Ave
Lakewood
CO
80215
39.7400228674084
-105.099211343284
Jefferson County
North
Mall
26148
15231 E Colfax Ave
Aurora
CO
80011
39.7402871325916
-104.81208862069
Adams County
North
Mall
24754
2255 Sheridan Blvd
Edgewater
CO
80214
39.7498057659809
-105.053393461206
Jefferson County
North
Mall
28869
1701 Jackson St
Golden
CO
80401
39.7519931689841
-105.216319120787
Jefferson County
North
Mall
20633
1301 Washington Ave Unit A
Golden
CO
80401
39.754665716348
-105.220442263534
Jefferson County
North
Mall
22369
3400 Youngfield St
Wheat Ridge
CO
80033
39.7646015944572
-105.142331611689
Jefferson County
North
Mall
27667
3450 Youngfield St
Wheat Ridge
CO
80033
39.7647682611239
-105.142333549241
Jefferson County
North
Mall
29083
3795 Kipling St
Wheat Ridge
CO
80033
39.769162
-105.109898412188
Jefferson County
North
Mall
22047
3900 Wadsworth Blvd
Wheat Ridge
CO
80033
39.77118
-105.081191582582
Jefferson County
North
Mall
22195
5171 Kipling Street
Arvada
CO
80002
39.7907542370683
-105.109126079929
Jefferson County
North
Mall
24104
12680 W 64th Ave
Arvada
CO
80004
39.8124928674084
-105.141068235294
Jefferson County
North
Mall
24080
14605 W 64th Ave
Arvada
CO
80004
39.8126777196468
-105.162502636928
Jefferson County
North
Mall
20181
6600 Wadsworth Blvd
Arvada
CO
80003
39.8165024484059
-105.08114149344
Jefferson County
North
Mall
25207
7347 Federal Blvd
Westminster
CO
80030
39.829523
-105.025198568853
Adams County
North
Mall
25000
7561 W 80th Ave
Arvada
CO
80003
39.8420227855326
-105.080418162858
Jefferson County
North
Mall
21710
8071 Wadsworth Blvd
Arvada
CO
80003
39.84376
-105.082098605874
Jefferson County
North
Mall
24487
8410 Pearl St
Thornton
CO
80229
39.8492996828266
-104.979112402471
Adams County
North
Mall
22136
5545 Wadsworth By-Pass Unit #A # A
Arvada
CO
80007
39.85703
-105.19779
Jefferson County
North
Mall
26669
9372 Sheridan Blvd
Westminster
CO
80031
39.86724
-105.052871333013
Adams County
North
Mall
22928
811 Thornton Pkwy
Thornton
CO
80229
39.8709588274326
-104.976632823714
Adams County
North
Mall
29963
10005 Grant St Unit F
Thornton
CO
80229
39.8782446055372
-104.984008695654
Adams County
North
Mall
25667
10339 N Federal Boulevard #100 # 100
Westminster
CO
80031
39.88325
-105.025418708698
Adams County
North
Mall
29319
10300 Federal Blvd
Federal Heights
CO
80260
39.8835852855071
-105.024882218284
Adams County
North
Mall
27234
3840 E 104th Ave
Thornton
CO
80233
39.8846528674084
-104.942670909091
Adams County
North
Mall
29622
3896 E 120th Ave
Thornton
CO
80233
39.9136637681925
-104.942055041945
Adams County
North
Mall
22850
3904 E 120th Ave
Thornton
CO
80233
39.9136644824782
-104.941988613373
Adams County
North
Mall
25422
5180 W 120th Ave Unit B
Westminster
CO
80020
39.9139218299547
-105.051601008395
Adams County
North
Mall
20918
1171 W 120th Ave Unit B
Westminster
CO
80234
39.9142285895419
-105.000711071704
Adams County
North
Mall
20382
6775 W 120th Ave
Broomfield
CO
80020
39.9144469973524
-105.069762061611
Broomfield County
North
Mall
24370
1601 Coalton Rd
Superior
CO
80027
39.9290871325916
-105.14789
Boulder County
North
Mall
20973
645 Flatiron Marketplace Dr Unit C
Broomfield
CO
80021
39.9293577809137
-105.125855239343
Broomfield County
North
Mall
23175
1 W Flatiron Cir Ste 220
Broomfield
CO
80021
39.9300432027926
-105.130987760907
Broomfield County
North
Mall
26336
12900 Zuni St
Westminster
CO
80234
39.9305981629821
-105.015233192244
Adams County
North
Mall
22736
231 E Flatiron Crossing Dr
Broomfield
CO
80021
39.9310703761241
-105.123758723663
Broomfield County
North
Mall
24740
1170 US Highway 287 # D-400
Broomfield
CO
80020
39.9361851037923
-105.090392836142
Broomfield County
North
Mall
25264
305 McCaslin Blvd
Louisville
CO
80027
39.9513814616594
-105.165244970023
Boulder County
North
Mall
23919
1375 E South Boulder Rd
Louisville
CO
80027
39.95347
-105.15564
Boulder County
North
Mall
24445
3600 W 144th Ave
Broomfield
CO
80023
39.9575373173185
-105.035030624941
Broomfield County
North
Mall
20085
530 E Bromley Ln # 600
Brighton
CO
80601
39.9720159586318
-104.815534933921
Adams County
North
Mall
22092
59 Bush St
Brighton
CO
80601
39.9853812026993
-104.822710762591
Adams County
North
Mall
23428
535 W South Boulder Rd Ste 260
Lafayette
CO
80026
39.9871392692221
-105.094554752407
Boulder County
North
Mall
20011
555 W South Boulder Rd
Lafayette
CO
80026
39.9871771325916
-105.09784
Boulder County
North
Mall
23212
4800 Baseline Rd
Boulder
CO
80303
39.9998763653623
-105.234541748916
Boulder County
North
Mall
21226
480 US Highway 287
Lafayette
CO
80026
40.0020963920251
-105.102620980619
Boulder County
North
Mall
23287
1402 Broadway St
Boulder
CO
80302
40.0106060674755
-105.276707694969
Boulder County
North
Mall
26447
2798 Arapahoe Ave
Boulder
CO
80302
40.0144128998006
-105.259213891508
Boulder County
North
Mall
20261
3033 Arapahoe Ave
Boulder
CO
80303
40.0148471325916
-105.252984666667
Boulder County
North
Mall
21573
3333 Arapahoe Rd # B
Erie
CO
80516
40.0154671325916
-105.10099
Boulder County
North
Mall
28731
1427 Pearl St
Boulder
CO
80302
40.0186510281558
-105.277046015494
Boulder County
North
Mall
20817
2770 Pearl St Ste B
Boulder
CO
80302
40.0219292432754
-105.259181796282
Boulder County
North
Mall
20909
3325 28th St
Boulder
CO
80301
40.0358405257275
-105.258705178313
Boulder County
North
Mall
25592
1300 Dexter St
Fort Lupton
CO
80621
40.0790531841868
-104.803556916411
Weld County
North
Mall
20486
8134 County Rd 13
Firestone
CO
80520
40.1190356067078
-104.941828698349
Weld County
North
Mall
23343
1087 S Hover St Ste A
Longmont
CO
80501
40.146256026811
-105.130999323413
Boulder County
North
Mall
25858
1100 Ken Pratt Blvd Ste A
Longmont
CO
80501
40.1524603695932
-105.110654914833
Boulder County
North
Mall
29352
1050 Ken Pratt Blvd
Longmont
CO
80501
40.1524648686671
-105.109993550969
Boulder County
North
Mall
22551
6110 Firestone Blvd
Firestone
CO
80520
40.1604943874355
-104.938182433032
Weld County
North
Mall
23751
11169 I-25 Frontage Road A A
Firestone
CO
80504
40.1631702939267
-104.97689766605
Weld County
North
Mall
24875
1632 Hover St
Longmont
CO
80501
40.1870814285714
-105.130730493344
Boulder County
North
Mall
26649
1630 Pace St
Longmont
CO
80504
40.1875047063629
-105.073933223885
Boulder County
North
Mall
28421
815 17th Ave Unit C5
Longmont
CO
80501
40.1885728686394
-105.077639239369
Boulder County
North
Mall
20978
356 E Elkhorn Ave # 2
Estes Park
CO
80517
40.3769940215084
-105.519273421096
Larimer County
North
Mall
26603
451 E Wonder View Ave
Estes Park
CO
80517
40.3788552782935
-105.517178056634
Larimer County
North
Mall
23079
1317 Eagle Dr
Loveland
CO
80537
40.3792286019301
-105.098025976032
Larimer County
North
Mall
22929
4548 Centerplace Dr
Greeley
CO
80634
40.394939949713
-104.74957903
Weld County
North
Mall
25702
2604 11th Ave
Greeley
CO
80631
40.3953421946054
-104.696706240147
Weld County
North
Mall
20170
2045 10th Ave
Greeley
CO
80639
40.4052377244588
-104.694818826738
Weld County
North
Mall
25942
2030 35th Ave
Greeley
CO
80634
40.405893334227
-104.734825965024
Weld County
North
Mall
24282
5897 Sky Pond Dr Unit K151
Loveland
CO
80538
40.4106770825341
-104.988184865837
Larimer County
North
Mall
25485
4320 W 9th Street Rd # B101
Greeley
CO
80634
40.4225465143593
-104.748596011959
Weld County
North
Mall
20564
3526 W 10th St
Greeley
CO
80634
40.4225560783421
-104.736371248
Weld County
North
Mall
28168
1535 Main St
Windsor
CO
80550
40.4793091469989
-104.927899053051
Weld County
North
Mall
27744
1520 Main St
Windsor
CO
80550
40.4795804784618
-104.928428364041
Weld County
North
Mall
24090
4609 S Timberline Rd Unit A101 Unit 101A
Fort Collins
CO
80528
40.5231099816596
-105.03963040345
Larimer County
North
Mall
24326
250 E Harmony Rd
Fort Collins
CO
80525
40.5237486412786
-105.073524808632
Larimer County
North
Mall
25449
1426 E Harmony Rd
Fort Collins
CO
80525
40.5238698535449
-105.052767228723
Larimer County
North
Mall
28201
3600 S College Ave
Fort Collins
CO
80525
40.53803
-105.076789556379
Larimer County
North
Mall
24335
2601 S Lemay Ave Ste 130
Fort Collins
CO
80525
40.55208
-105.058160481477
Larimer County
North
Mall
23512
838 W Drake Rd Ste 101
Fort Collins
CO
80526
40.5528913509406
-105.090943794117
Larimer County
North
Mall
24168
2160 W Drake Rd Unit 6
Fort Collins
CO
80526
40.5530230357951
-105.116297713328
Larimer County
North
Mall
Double
Horizontal
Create an Indexed Map