creating address ranges

S

Shawn Johnson

I have a database of 911 civic addresses that does not include street ranges
just individual civic points and I would like to create street ranges from
the individual civic points. The street civic number ranges need to be
within individual communities only (I can't have the range span multiple
communities). I have included a sample, it might be overkill but I hope it
helps. The new table would have two new columns 1.) [Even range] 2 - 10
and 2.) [Odd Range] 1 - 9.

Hope this makes sense

Shawn J

Civic_Points_With_Route_Na Civic_# Street_Name Community Apt_# County
Latitude_Y Longitude_X ROUTE_NAME
2952 48 RD - RTE 5 ELLIOTVALE
QUN 46.2490882873535 -62.7929763793945 C0A_110
2981 48 RD - RTE 5 ELLIOTVALE
QUN 46.2495880126953 -62.7916450500488 C0A_110
2011 48 RD - RTE 5 AVONDALE
QUN 46.2485847473145 -62.8503952026367 C0A_110
1235 48 RD - RTE 5 LAKE VERDE
QUN 46.2412223815918 -62.8962669372559 C1A_220
1178 48 RD - RTE 5 LAKE VERDE
QUN 46.2403602600098 -62.8997955322266 C1A_220
1169 48 RD - RTE 5 LAKE VERDE
QUN 46.2405281066895 -62.9004592895508 C1A_220
1116 48 RD - RTE 5 LAKE VERDE
QUN 46.2397155761719 -62.9035949707031 C1A_220
1047 48 RD - RTE 5 LAKE VERDE
QUN 46.2392234802246 -62.9079246520996 C1A_220
1070 48 RD - RTE 5 LAKE VERDE
QUN 46.2392768859863 -62.9064407348633 C1A_220
1991 48 RD - RTE 5 LAKE VERDE
QUN 46.2483711242676 -62.8514976501465 C0A_110
1060 48 RD - RTE 5 LAKE VERDE
QUN 46.2391166687012 -62.907154083252 C1A_220
1313 48 RD - RTE 5 LAKE VERDE
QUN 46.242618560791 -62.8917617797852 C1A_220
1215 48 RD - RTE 5 LAKE VERDE
QUN 46.2410125732422 -62.8975639343262 C1A_220
1284 48 RD - RTE 5 LAKE VERDE
QUN 46.2418327331543 -62.8933525085449 C1A_220
1259 48 RD - RTE 5 LAKE VERDE
QUN 46.2416381835938 -62.8949241638184 C1A_220
1263 48 RD - RTE 5 LAKE VERDE
QUN 46.24169921875 -62.8947219848633 C1A_220
603 48 RD - RTE 5 MOUNT ALBION
QUN 46.2324714660645 -62.9350624084473 C1A_220
1154 48 RD - RTE 5 LAKE VERDE
QUN 46.2401084899902 -62.9011421203613 C1A_220
1053 48 RD - RTE 5 LAKE VERDE
QUN 46.239315032959 -62.9075736999512 C1A_220
91 48 RD - RTE 5 MOUNT ALBION
QUN 46.2247543334961 -62.9666633605957 C1A_220
490 48 RD - RTE 5 MOUNT ALBION
QUN 46.2304191589355 -62.9418182373047 C1A_220
93 48 RD - RTE 5 MOUNT ALBION
QUN 46.2248229980469 -62.9665451049805 C1A_220
143 48 RD - RTE 5 MOUNT ALBION
QUN 46.2262916564941 -62.9634170532227 C1A_220
339 48 RD - RTE 5 MOUNT ALBION
QUN 46.22900390625 -62.9512901306152 C1A_220
1270 48 RD - RTE 5 LAKE VERDE
QUN 46.2415771484375 -62.8942031860352 C1A_220
1063 48 RD - RTE 5 LAKE VERDE
QUN 46.2394485473633 -62.9069557189941 C1A_220
948 48 RD - RTE 5 MOUNT ALBION
QUN 46.2375755310059 -62.9138259887695 C1A_220
409 48 RD - RTE 5 MOUNT ALBION
QUN 46.2296905517578 -62.9469680786133 C1A_220
2065 48 RD - RTE 5 AVONDALE
QUN 46.2492713928223 -62.8469543457031 C0A_110
957 48 RD - RTE 5 MOUNT ALBION
QUN 46.2379264831543 -62.9135131835938 C1A_220
1326 48 RD - RTE 5 LAKE VERDE
QUN 46.2426338195801 -62.8908004760742 C1A_220
1445 48 RD - RTE 5 LAKE VERDE
QUN 46.2444648742676 -62.8834609985352 C1A_220
1521 48 RD - RTE 5 LAKE VERDE
QUN 46.2415046691895 -62.8805656433105 C0A_110
949 48 RD - RTE 5 MOUNT ALBION
QUN 46.2378311157227 -62.9139251708984 C1A_220
1728 48 RD - RTE 5 LAKE VERDE
QUN 46.2438583374023 -62.8672485351563 C0A_110
531 48 RD - RTE 5 MOUNT ALBION
QUN 46.2313003540039 -62.9394607543945 C1A_220
58 48 RD - RTE 5 MOUNT ALBION
QUN 46.2238502502441 -62.967586517334 C1A_220
923 48 RD - RTE 5 MOUNT ALBION
QUN 46.2374534606934 -62.9154472351074 C1A_220
892 48 RD - RTE 5 MOUNT ALBION
QUN 46.2367210388184 -62.9173545837402 C1A_220
870 48 RD - RTE 5 MOUNT ALBION
QUN 46.2364082336426 -62.9186325073242 C1A_220
806 48 RD - RTE 5 MOUNT ALBION
QUN 46.2354393005371 -62.9225921630859 C1A_220
295 48 RD - RTE 5 MOUNT ALBION
QUN 46.2285537719727 -62.9540786743164 C1A_220
453 48 RD - RTE 5 MOUNT ALBION
QUN 46.230094909668 -62.9441986083984 C1A_220
925 48 RD - RTE 5 MOUNT ALBION
QUN 46.237491607666 -62.9152641296387 C1A_220
809 48 RD - RTE 5 MOUNT ALBION
QUN 46.2357292175293 -62.9224624633789 C1A_220
1274 48 RD - RTE 5 LAKE VERDE
QUN 46.2416229248047 -62.8940620422363 C1A_220
544 48 RD - RTE 5 MOUNT ALBION
QUN 46.2312812805176 -62.9385375976563 C1A_220
2031 48 RD - RTE 5 AVONDALE
QUN 46.2488250732422 -62.8492012023926 C0A_110
556 48 RD - RTE 5 MOUNT ALBION
QUN 46.2315101623535 -62.9377365112305 C1A_220
633 48 RD - RTE 5 MOUNT ALBION
QUN 46.2329444885254 -62.9332695007324 C1A_220
2649 48 RD - RTE 5 AVONDALE
QUN 46.2459907531738 -62.8121109008789 C0A_110
655 48 RD - RTE 5 MOUNT ALBION
QUN 46.2333145141602 -62.9318656921387 C1A_220
675 48 RD - RTE 5 MOUNT ALBION
QUN 46.2336654663086 -62.9305191040039 C1A_220
497 48 RD - RTE 5 MOUNT ALBION
QUN 46.2307586669922 -62.941520690918 C1A_220
1044 48 RD - RTE 5 LAKE VERDE
QUN 46.2389221191406 -62.9081916809082 C1A_220
1023 48 RD - RTE 5 LAKE VERDE
QUN 46.2388877868652 -62.9095649719238 C1A_220
1174 48 RD - RTE 5 LAKE VERDE
QUN 46.2403602600098 -62.8997955322266 C1A_220
373 48 RD - RTE 5 MOUNT ALBION
QUN 46.2293167114258 -62.9492263793945 C1A_220
233 48 RD - RTE 5 MOUNT ALBION
QUN 46.2278060913086 -62.9579315185547 C1A_220
674 48 RD - RTE 5 MOUNT ALBION
QUN 46.2333755493164 -62.9305572509766 C1A_220
64 48 RD - RTE 5 MOUNT ALBION
QUN 46.2241363525391 -62.9671401977539 C1A_220
478 48 RD - RTE 5 MOUNT ALBION
QUN 46.2302474975586 -62.9425506591797 C1A_220
78 48 RD - RTE 5 MOUNT ALBION
QUN 46.2245025634766 -62.9665641784668 C1A_220
231 48 RD - RTE 5 MOUNT ALBION
QUN 46.2277946472168 -62.9580001831055 C1A_220
635 48 RD - RTE 5 MOUNT ALBION
QUN 46.2329750061035 -62.9331245422363 C1A_220
213 48 RD - RTE 5 MOUNT ALBION
QUN 46.2275543212891 -62.9591674804688 C1A_220
303 48 RD - RTE 5 MOUNT ALBION
QUN 46.2286491394043 -62.9534530639648 C1A_220
249 48 RD - RTE 5 MOUNT ALBION
QUN 46.2280044555664 -62.9570121765137 C1A_220
325 48 RD - RTE 5 MOUNT ALBION
QUN 46.2288589477539 -62.9521751403809 C1A_220
219 48 RD - RTE 5 MOUNT ALBION
QUN 46.2276458740234 -62.9587936401367 C1A_220
55 48 RD - RTE 5 MOUNT ALBION
QUN 46.2236251831055 -62.9684715270996 C1A_220
155 48 RD - RTE 5 MOUNT ALBION
QUN 46.2262687683105 -62.9633712768555 C1A_220
83 48 RD - RTE 5 MOUNT ALBION
QUN 46.2244338989258 -62.967170715332 C1A_220
765 48 RD - RTE 5 MOUNT ALBION
QUN 46.2350654602051 -62.9251937866211 C1A_220
4663 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.252986907959 -62.684009552002 C0A_110
5181 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2420043945313 -62.6552391052246 C0A_110
4357 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2563209533691 -62.7019500732422 C0A_110
4383 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2565650939941 -62.7001914978027 C0A_110
4384 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2563095092773 -62.7001647949219 C0A_110
4407 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.256763458252 -62.6987075805664 C0A_110
4450 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2569274902344 -62.6959190368652 C0A_110
4494 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2569847106934 -62.6931648254395 C0A_110
4540 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2558631896973 -62.6908798217773 C0A_110
5319 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2384071350098 -62.6483955383301 C0A_110
4345 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2562294006348 -62.7026596069336 C0A_110
4597 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2546615600586 -62.6875343322754 C0A_110
4342 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2559585571289 -62.7027626037598 C0A_110
4715 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2516326904297 -62.6812515258789 C0A_110
4784 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2496032714844 -62.6778450012207 C0A_110
4915 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2463150024414 -62.6707382202148 C0A_110
5033 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2432823181152 -62.664478302002 C0A_110
4106 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2555618286133 -62.7178726196289 C0A_110
4112 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2555274963379 -62.7176933288574 C0A_110
4349 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.256290435791 -62.7023963928223 C0A_110
5159 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2421417236328 -62.6565551757813 C0A_110
5173 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2420310974121 -62.6557884216309 C0A_110
5177 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2420387268066 -62.6554756164551 C0A_110
3548 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2567405700684 -62.7538032531738 C0A_110
4058 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2555732727051 -62.7211151123047 C0A_110
3501 48 RD - RTE 5 BALDWIN ROAD
KNS 46.25634765625 -62.7569046020508 C0A_110
3564 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2569122314453 -62.7528648376465 C0A_110
5195 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2419128417969 -62.6545066833496 C0A_110
4103 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2558250427246 -62.7184143066406 C0A_110
4168 48 RD - RTE 5 BALDWIN ROAD
KNS 46.255500793457 -62.7141342163086 C0A_110
3731 48 RD - RTE 5 BALDWIN ROAD
KNS 46.256217956543 -62.7423858642578 C0A_110
3747 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2561645507813 -62.7413673400879 C0A_110
3764 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2558212280273 -62.7401962280273 C0A_110
3770 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2558898925781 -62.7398262023926 C0A_110
4352 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2560043334961 -62.7021865844727 C0A_110
4006 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2556457519531 -62.7245254516602 C0A_110
4937 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2458648681641 -62.6695365905762 C0A_110
4067 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2558212280273 -62.7206802368164 C0A_110
4373 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2564811706543 -62.7009010314941 C0A_110
5267 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2405738830566 -62.6499366760254 C0A_110
4111 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2557907104492 -62.7178611755371 C0A_110
4109 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2557830810547 -62.7178649902344 C0A_110
4118 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2555084228516 -62.7172241210938 C0A_110
4146 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2554931640625 -62.7154846191406 C0A_110
4330 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2558403015137 -62.7035217285156 C0A_110
5414 48 RD - RTE 5 CARDIGAN
KNS 46.2370071411133 -62.64306640625 C0A_110
4331 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2560997009277 -62.7036094665527 C0A_110
3863 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2561683654785 -62.733772277832 C0A_110
4159 48 RD - RTE 5 BALDWIN ROAD
KNS 46.255744934082 -62.7147827148438 C0A_110
4776 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2498245239258 -62.6781692504883 C0A_110
5219 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2417221069336 -62.6528205871582 C0A_110
3214 48 RD - RTE 5 ELLIOTVALE
KNS 46.2520217895508 -62.7769393920898 C0A_110
3761 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2561492919922 -62.7403793334961 C0A_110
5304 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2399482727051 -62.6499214172363 C0A_110
3171 48 RD - RTE 5 ELLIOTVALE
KNS 46.2518577575684 -62.7797966003418 C0A_110
3178 48 RD - RTE 5 ELLIOTVALE
KNS 46.251708984375 -62.7792472839355 C0A_110
3322 48 RD - RTE 5 ELLIOTVALE
KNS 46.25341796875 -62.7703666687012 C0A_110
5328 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2372550964355 -62.6474418640137 C0A_110
5382 48 RD - RTE 5 CARDIGAN
KNS 46.2371444702148 -62.6451835632324 C0A_110
5430 48 RD - RTE 5 CARDIGAN
KNS 46.2371025085449 -62.6421165466309 C0A_110
5389 48 RD - RTE 5 CARDIGAN
KNS 46.2373733520508 -62.6447334289551 C0A_110
 
S

Shawn Johnson

Sorry,
from what I can tell, my fields didn't post as clearly as I had hoped.

Shawn J

Shawn Johnson said:
I have a database of 911 civic addresses that does not include street
ranges just individual civic points and I would like to create street
ranges from the individual civic points. The street civic number ranges
need to be within individual communities only (I can't have the range span
multiple communities). I have included a sample, it might be overkill but
I hope it helps. The new table would have two new columns 1.) [Even range]
2 - 10 and 2.) [Odd Range] 1 - 9.

Hope this makes sense

Shawn J

Civic_Points_With_Route_Na Civic_# Street_Name Community Apt_# County
Latitude_Y Longitude_X ROUTE_NAME
2952 48 RD - RTE 5 ELLIOTVALE
QUN 46.2490882873535 -62.7929763793945 C0A_110
2981 48 RD - RTE 5 ELLIOTVALE
QUN 46.2495880126953 -62.7916450500488 C0A_110
2011 48 RD - RTE 5 AVONDALE
QUN 46.2485847473145 -62.8503952026367 C0A_110
1235 48 RD - RTE 5 LAKE VERDE
QUN 46.2412223815918 -62.8962669372559 C1A_220
1178 48 RD - RTE 5 LAKE VERDE
QUN 46.2403602600098 -62.8997955322266 C1A_220
1169 48 RD - RTE 5 LAKE VERDE
QUN 46.2405281066895 -62.9004592895508 C1A_220
1116 48 RD - RTE 5 LAKE VERDE
QUN 46.2397155761719 -62.9035949707031 C1A_220
1047 48 RD - RTE 5 LAKE VERDE
QUN 46.2392234802246 -62.9079246520996 C1A_220
1070 48 RD - RTE 5 LAKE VERDE
QUN 46.2392768859863 -62.9064407348633 C1A_220
1991 48 RD - RTE 5 LAKE VERDE
QUN 46.2483711242676 -62.8514976501465 C0A_110
1060 48 RD - RTE 5 LAKE VERDE
QUN 46.2391166687012 -62.907154083252 C1A_220
1313 48 RD - RTE 5 LAKE VERDE
QUN 46.242618560791 -62.8917617797852 C1A_220
1215 48 RD - RTE 5 LAKE VERDE
QUN 46.2410125732422 -62.8975639343262 C1A_220
1284 48 RD - RTE 5 LAKE VERDE
QUN 46.2418327331543 -62.8933525085449 C1A_220
1259 48 RD - RTE 5 LAKE VERDE
QUN 46.2416381835938 -62.8949241638184 C1A_220
1263 48 RD - RTE 5 LAKE VERDE
QUN 46.24169921875 -62.8947219848633 C1A_220
603 48 RD - RTE 5 MOUNT ALBION
QUN 46.2324714660645 -62.9350624084473 C1A_220
1154 48 RD - RTE 5 LAKE VERDE
QUN 46.2401084899902 -62.9011421203613 C1A_220
1053 48 RD - RTE 5 LAKE VERDE
QUN 46.239315032959 -62.9075736999512 C1A_220
91 48 RD - RTE 5 MOUNT ALBION
QUN 46.2247543334961 -62.9666633605957 C1A_220
490 48 RD - RTE 5 MOUNT ALBION
QUN 46.2304191589355 -62.9418182373047 C1A_220
93 48 RD - RTE 5 MOUNT ALBION
QUN 46.2248229980469 -62.9665451049805 C1A_220
143 48 RD - RTE 5 MOUNT ALBION
QUN 46.2262916564941 -62.9634170532227 C1A_220
339 48 RD - RTE 5 MOUNT ALBION
QUN 46.22900390625 -62.9512901306152 C1A_220
1270 48 RD - RTE 5 LAKE VERDE
QUN 46.2415771484375 -62.8942031860352 C1A_220
1063 48 RD - RTE 5 LAKE VERDE
QUN 46.2394485473633 -62.9069557189941 C1A_220
948 48 RD - RTE 5 MOUNT ALBION
QUN 46.2375755310059 -62.9138259887695 C1A_220
409 48 RD - RTE 5 MOUNT ALBION
QUN 46.2296905517578 -62.9469680786133 C1A_220
2065 48 RD - RTE 5 AVONDALE
QUN 46.2492713928223 -62.8469543457031 C0A_110
957 48 RD - RTE 5 MOUNT ALBION
QUN 46.2379264831543 -62.9135131835938 C1A_220
1326 48 RD - RTE 5 LAKE VERDE
QUN 46.2426338195801 -62.8908004760742 C1A_220
1445 48 RD - RTE 5 LAKE VERDE
QUN 46.2444648742676 -62.8834609985352 C1A_220
1521 48 RD - RTE 5 LAKE VERDE
QUN 46.2415046691895 -62.8805656433105 C0A_110
949 48 RD - RTE 5 MOUNT ALBION
QUN 46.2378311157227 -62.9139251708984 C1A_220
1728 48 RD - RTE 5 LAKE VERDE
QUN 46.2438583374023 -62.8672485351563 C0A_110
531 48 RD - RTE 5 MOUNT ALBION
QUN 46.2313003540039 -62.9394607543945 C1A_220
58 48 RD - RTE 5 MOUNT ALBION
QUN 46.2238502502441 -62.967586517334 C1A_220
923 48 RD - RTE 5 MOUNT ALBION
QUN 46.2374534606934 -62.9154472351074 C1A_220
892 48 RD - RTE 5 MOUNT ALBION
QUN 46.2367210388184 -62.9173545837402 C1A_220
870 48 RD - RTE 5 MOUNT ALBION
QUN 46.2364082336426 -62.9186325073242 C1A_220
806 48 RD - RTE 5 MOUNT ALBION
QUN 46.2354393005371 -62.9225921630859 C1A_220
295 48 RD - RTE 5 MOUNT ALBION
QUN 46.2285537719727 -62.9540786743164 C1A_220
453 48 RD - RTE 5 MOUNT ALBION
QUN 46.230094909668 -62.9441986083984 C1A_220
925 48 RD - RTE 5 MOUNT ALBION
QUN 46.237491607666 -62.9152641296387 C1A_220
809 48 RD - RTE 5 MOUNT ALBION
QUN 46.2357292175293 -62.9224624633789 C1A_220
1274 48 RD - RTE 5 LAKE VERDE
QUN 46.2416229248047 -62.8940620422363 C1A_220
544 48 RD - RTE 5 MOUNT ALBION
QUN 46.2312812805176 -62.9385375976563 C1A_220
2031 48 RD - RTE 5 AVONDALE
QUN 46.2488250732422 -62.8492012023926 C0A_110
556 48 RD - RTE 5 MOUNT ALBION
QUN 46.2315101623535 -62.9377365112305 C1A_220
633 48 RD - RTE 5 MOUNT ALBION
QUN 46.2329444885254 -62.9332695007324 C1A_220
2649 48 RD - RTE 5 AVONDALE
QUN 46.2459907531738 -62.8121109008789 C0A_110
655 48 RD - RTE 5 MOUNT ALBION
QUN 46.2333145141602 -62.9318656921387 C1A_220
675 48 RD - RTE 5 MOUNT ALBION
QUN 46.2336654663086 -62.9305191040039 C1A_220
497 48 RD - RTE 5 MOUNT ALBION
QUN 46.2307586669922 -62.941520690918 C1A_220
1044 48 RD - RTE 5 LAKE VERDE
QUN 46.2389221191406 -62.9081916809082 C1A_220
1023 48 RD - RTE 5 LAKE VERDE
QUN 46.2388877868652 -62.9095649719238 C1A_220
1174 48 RD - RTE 5 LAKE VERDE
QUN 46.2403602600098 -62.8997955322266 C1A_220
373 48 RD - RTE 5 MOUNT ALBION
QUN 46.2293167114258 -62.9492263793945 C1A_220
233 48 RD - RTE 5 MOUNT ALBION
QUN 46.2278060913086 -62.9579315185547 C1A_220
674 48 RD - RTE 5 MOUNT ALBION
QUN 46.2333755493164 -62.9305572509766 C1A_220
64 48 RD - RTE 5 MOUNT ALBION
QUN 46.2241363525391 -62.9671401977539 C1A_220
478 48 RD - RTE 5 MOUNT ALBION
QUN 46.2302474975586 -62.9425506591797 C1A_220
78 48 RD - RTE 5 MOUNT ALBION
QUN 46.2245025634766 -62.9665641784668 C1A_220
231 48 RD - RTE 5 MOUNT ALBION
QUN 46.2277946472168 -62.9580001831055 C1A_220
635 48 RD - RTE 5 MOUNT ALBION
QUN 46.2329750061035 -62.9331245422363 C1A_220
213 48 RD - RTE 5 MOUNT ALBION
QUN 46.2275543212891 -62.9591674804688 C1A_220
303 48 RD - RTE 5 MOUNT ALBION
QUN 46.2286491394043 -62.9534530639648 C1A_220
249 48 RD - RTE 5 MOUNT ALBION
QUN 46.2280044555664 -62.9570121765137 C1A_220
325 48 RD - RTE 5 MOUNT ALBION
QUN 46.2288589477539 -62.9521751403809 C1A_220
219 48 RD - RTE 5 MOUNT ALBION
QUN 46.2276458740234 -62.9587936401367 C1A_220
55 48 RD - RTE 5 MOUNT ALBION
QUN 46.2236251831055 -62.9684715270996 C1A_220
155 48 RD - RTE 5 MOUNT ALBION
QUN 46.2262687683105 -62.9633712768555 C1A_220
83 48 RD - RTE 5 MOUNT ALBION
QUN 46.2244338989258 -62.967170715332 C1A_220
765 48 RD - RTE 5 MOUNT ALBION
QUN 46.2350654602051 -62.9251937866211 C1A_220
4663 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.252986907959 -62.684009552002 C0A_110
5181 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2420043945313 -62.6552391052246 C0A_110
4357 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2563209533691 -62.7019500732422 C0A_110
4383 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2565650939941 -62.7001914978027 C0A_110
4384 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2563095092773 -62.7001647949219 C0A_110
4407 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.256763458252 -62.6987075805664 C0A_110
4450 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2569274902344 -62.6959190368652 C0A_110
4494 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2569847106934 -62.6931648254395 C0A_110
4540 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2558631896973 -62.6908798217773 C0A_110
5319 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2384071350098 -62.6483955383301 C0A_110
4345 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2562294006348 -62.7026596069336 C0A_110
4597 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2546615600586 -62.6875343322754 C0A_110
4342 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2559585571289 -62.7027626037598 C0A_110
4715 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2516326904297 -62.6812515258789 C0A_110
4784 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2496032714844 -62.6778450012207 C0A_110
4915 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2463150024414 -62.6707382202148 C0A_110
5033 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2432823181152 -62.664478302002 C0A_110
4106 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2555618286133 -62.7178726196289 C0A_110
4112 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2555274963379 -62.7176933288574 C0A_110
4349 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.256290435791 -62.7023963928223 C0A_110
5159 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2421417236328 -62.6565551757813 C0A_110
5173 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2420310974121 -62.6557884216309 C0A_110
5177 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2420387268066 -62.6554756164551 C0A_110
3548 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2567405700684 -62.7538032531738 C0A_110
4058 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2555732727051 -62.7211151123047 C0A_110
3501 48 RD - RTE 5 BALDWIN ROAD
KNS 46.25634765625 -62.7569046020508 C0A_110
3564 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2569122314453 -62.7528648376465 C0A_110
5195 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2419128417969 -62.6545066833496 C0A_110
4103 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2558250427246 -62.7184143066406 C0A_110
4168 48 RD - RTE 5 BALDWIN ROAD
KNS 46.255500793457 -62.7141342163086 C0A_110
3731 48 RD - RTE 5 BALDWIN ROAD
KNS 46.256217956543 -62.7423858642578 C0A_110
3747 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2561645507813 -62.7413673400879 C0A_110
3764 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2558212280273 -62.7401962280273 C0A_110
3770 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2558898925781 -62.7398262023926 C0A_110
4352 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2560043334961 -62.7021865844727 C0A_110
4006 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2556457519531 -62.7245254516602 C0A_110
4937 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2458648681641 -62.6695365905762 C0A_110
4067 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2558212280273 -62.7206802368164 C0A_110
4373 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2564811706543 -62.7009010314941 C0A_110
5267 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2405738830566 -62.6499366760254 C0A_110
4111 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2557907104492 -62.7178611755371 C0A_110
4109 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2557830810547 -62.7178649902344 C0A_110
4118 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2555084228516 -62.7172241210938 C0A_110
4146 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2554931640625 -62.7154846191406 C0A_110
4330 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2558403015137 -62.7035217285156 C0A_110
5414 48 RD - RTE 5 CARDIGAN
KNS 46.2370071411133 -62.64306640625 C0A_110
4331 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2560997009277 -62.7036094665527 C0A_110
3863 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2561683654785 -62.733772277832 C0A_110
4159 48 RD - RTE 5 BALDWIN ROAD
KNS 46.255744934082 -62.7147827148438 C0A_110
4776 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2498245239258 -62.6781692504883 C0A_110
5219 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2417221069336 -62.6528205871582 C0A_110
3214 48 RD - RTE 5 ELLIOTVALE
KNS 46.2520217895508 -62.7769393920898 C0A_110
3761 48 RD - RTE 5 BALDWIN ROAD
KNS 46.2561492919922 -62.7403793334961 C0A_110
5304 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2399482727051 -62.6499214172363 C0A_110
3171 48 RD - RTE 5 ELLIOTVALE
KNS 46.2518577575684 -62.7797966003418 C0A_110
3178 48 RD - RTE 5 ELLIOTVALE
KNS 46.251708984375 -62.7792472839355 C0A_110
3322 48 RD - RTE 5 ELLIOTVALE
KNS 46.25341796875 -62.7703666687012 C0A_110
5328 48 RD - RTE 5 HEAD OF CARDIGAN
KNS 46.2372550964355 -62.6474418640137 C0A_110
5382 48 RD - RTE 5 CARDIGAN
KNS 46.2371444702148 -62.6451835632324 C0A_110
5430 48 RD - RTE 5 CARDIGAN
KNS 46.2371025085449 -62.6421165466309 C0A_110
5389 48 RD - RTE 5 CARDIGAN
KNS 46.2373733520508 -62.6447334289551 C0A_110
Click to expand...
 
S

Shawn Johnson

I created a new table grouping the streets and using the min and max
functions to give me my ranges from the individual civic points. At this
point I haven't been able to seperate the ranges into odds and evens, but
for what I need the ranges for, the combined odds and evens ranges will do.

Any suggestions on the evens and odds issue would be appreciated.

Shawn J
 
Top