Input
Output
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg==
Weekly Challenge #6
Sales reps are travelling all over the US. The data contained in the workflow details the travel paths for 7 Reps to 7 different cities. The travel route is detailed as well.
The objective is to determine which Rep has logged the most miles. Please include the route traveled as a spatial object in the output.
Hartford-West Hartford-East Hartford, CT Metro
{ "type": "Point", "coordinates": [ -72.577485, 41.735909 ] }
Cathy
1
Indianapolis-Carmel-Anderson, IN Metro
{ "type": "Point", "coordinates": [ -86.206137, 39.747431 ] }
Cathy
2
Springfield, MA Metro
{ "type": "Point", "coordinates": [ -72.646741, 42.230068 ] }
Cathy
3
Reno, NV Metro
{ "type": "Point", "coordinates": [ -119.660656, 40.638609 ] }
Cathy
4
Cleveland-Elyria, OH Metro
{ "type": "Point", "coordinates": [ -81.683882, 41.375258 ] }
Cathy
5
Knoxville, TN Metro
{ "type": "Point", "coordinates": [ -84.138485, 36.047549 ] }
Cathy
6
Madison, WI Metro
{ "type": "Point", "coordinates": [ -89.591695, 43.078509 ] }
Cathy
7
Phoenix-Mesa-Scottsdale, AZ Metro
{ "type": "Point", "coordinates": [ -112.070554, 33.185508 ] }
Dan
1
Miami-Fort Lauderdale-West Palm Beach, FL Metro
{ "type": "Point", "coordinates": [ -80.497102, 26.129562 ] }
Dan
2
Lexington-Fayette, KY Metro
{ "type": "Point", "coordinates": [ -84.432749, 38.090933 ] }
Dan
3
Jackson, MS Metro
{ "type": "Point", "coordinates": [ -90.222604, 32.315710 ] }
Dan
4
Albuquerque, NM Metro
{ "type": "Point", "coordinates": [ -106.471533, 35.122281 ] }
Dan
5
Pittsburgh, PA Metro
{ "type": "Point", "coordinates": [ -79.830873, 40.439120 ] }
Dan
6
Burlington-South Burlington, VT Metro
{ "type": "Point", "coordinates": [ -72.987392, 44.685176 ] }
Dan
7
Los Angeles-Long Beach-Anaheim, CA Metro
{ "type": "Point", "coordinates": [ -118.149366, 34.222183 ] }
Diana
1
Boise City, ID Metro
{ "type": "Point", "coordinates": [ -116.143190, 43.012347 ] }
Diana
2
Bangor, ME Metro
{ "type": "Point", "coordinates": [ -68.649614, 45.401569 ] }
Diana
3
Billings, MT Metro
{ "type": "Point", "coordinates": [ -108.718932, 45.780888 ] }
Diana
4
Durham-Chapel Hill, NC Metro
{ "type": "Point", "coordinates": [ -79.099669, 35.990862 ] }
Diana
5
Myrtle Beach-Conway-North Myrtle Beach, SC-NC Metro
{ "type": "Point", "coordinates": [ -78.687107, 33.975596 ] }
Diana
6
Seattle-Tacoma-Bellevue, WA Metro
{ "type": "Point", "coordinates": [ -121.847665, 47.557175 ] }
Diana
7
Tuscaloosa, AL Metro
{ "type": "Point", "coordinates": [ -87.721321, 33.168895 ] }
James
1
Washington-Arlington-Alexandria, DC-VA-MD-WV Metro
{ "type": "Point", "coordinates": [ -77.479410, 38.835556 ] }
James
2
Topeka, KS Metro
{ "type": "Point", "coordinates": [ -95.803087, 39.043680 ] }
James
3
Minneapolis-St. Paul-Bloomington, MN-WI Metro
{ "type": "Point", "coordinates": [ -93.344795, 45.051728 ] }
James
4
Atlantic City-Hammonton, NJ Metro
{ "type": "Point", "coordinates": [ -74.677538, 39.481753 ] }
James
5
Eugene, OR Metro
{ "type": "Point", "coordinates": [ -122.846159, 43.938519 ] }
James
6
Salt Lake City, UT Metro
{ "type": "Point", "coordinates": [ -113.041258, 40.447264 ] }
James
7
Fayetteville-Springdale-Rogers, AR-MO Metro
{ "type": "Point", "coordinates": [ -94.123458, 36.194649 ] }
Mark
1
Atlanta-Sandy Springs-Roswell, GA Metro
{ "type": "Point", "coordinates": [ -84.400798, 33.692203 ] }
Mark
2
New Orleans-Metairie, LA Metro
{ "type": "Point", "coordinates": [ -89.967842, 29.934402 ] }
Mark
3
Columbia, MO Metro
{ "type": "Point", "coordinates": [ -92.309235, 38.991761 ] }
Mark
4
Rochester, NY Metro
{ "type": "Point", "coordinates": [ -77.515170, 42.969919 ] }
Mark
5
Providence-Warwick, RI-MA Metro
{ "type": "Point", "coordinates": [ -71.401369, 41.719232 ] }
Mark
6
Richmond, VA Metro
{ "type": "Point", "coordinates": [ -77.478352, 37.462083 ] }
Mark
7
Denver-Aurora-Lakewood, CO Metro
{ "type": "Point", "coordinates": [ -104.893931, 39.433975 ] }
Scott
1
Chicago-Naperville-Elgin, IL-IN-WI Metro
{ "type": "Point", "coordinates": [ -87.962153, 41.702848 ] }
Scott
2
Baltimore-Columbia-Towson, MD Metro
{ "type": "Point", "coordinates": [ -76.580825, 39.339686 ] }
Scott
3
Lincoln, NE Metro
{ "type": "Point", "coordinates": [ -96.870816, 40.819919 ] }
Scott
4
Fargo, ND-MN Metro
{ "type": "Point", "coordinates": [ -96.965552, 46.917820 ] }
Scott
5
Sioux Falls, SD Metro
{ "type": "Point", "coordinates": [ -96.990074, 43.499717 ] }
Scott
6
Morgantown, WV Metro
{ "type": "Point", "coordinates": [ -79.804105, 39.527107 ] }
Scott
7
Dover, DE Metro
{ "type": "Point", "coordinates": [ -75.568385, 39.086100 ] }
Steve
1
Cedar Rapids, IA Metro
{ "type": "Point", "coordinates": [ -91.630879, 42.091532 ] }
Steve
2
Detroit-Warren-Dearborn, MI Metro
{ "type": "Point", "coordinates": [ -83.236738, 42.721871 ] }
Steve
3
Manchester-Nashua, NH Metro
{ "type": "Point", "coordinates": [ -71.716636, 42.915407 ] }
Steve
4
Oklahoma City, OK Metro
{ "type": "Point", "coordinates": [ -97.503812, 35.429885 ] }
Steve
5
Dallas-Fort Worth-Arlington, TX Metro
{ "type": "Point", "coordinates": [ -97.028989, 32.817835 ] }
Steve
6
Cheyenne, WY Metro
{ "type": "Point", "coordinates": [ -104.689616, 41.307065 ] }
Steve
7
C:\Users\210693\AppData\Local\Temp\Engine_19612_05de4eba83934e42add68615e3223c8e_\Engine_23612_10ee0da79dbc4b84b99fd887a4e1c1ca_.yxdb
Single
Map
C:\Users\210693\AppData\Local\Temp\Engine_19612_05de4eba83934e42add68615e3223c8e_\Engine_23612_16724fb05c5f43c098ef99d2649dcfc8_.yxdb
Single
Map
Diana
{ "type": "LineString", "coordinates": [ [ -118.149366, 34.222183 ], [ -116.143190, 43.012347 ], [ -68.649614, 45.401569 ], [ -108.718932, 45.780888 ], [ -79.099669, 35.990862 ], [ -78.687107, 33.975596 ], [ -121.847665, 47.557175 ] ] }
9077.84409483893
Cathy
{ "type": "LineString", "coordinates": [ [ -72.577485, 41.735909 ], [ -86.206137, 39.747431 ], [ -72.646741, 42.230068 ], [ -119.660656, 40.638609 ], [ -81.683882, 41.375258 ], [ -84.138485, 36.047549 ], [ -89.591695, 43.078509 ] ] }
6777.00378612944
Dan
{ "type": "LineString", "coordinates": [ [ -112.070554, 33.185508 ], [ -80.497102, 26.129562 ], [ -84.432749, 38.090933 ], [ -90.222604, 32.315710 ], [ -106.471533, 35.122281 ], [ -79.830873, 40.439120 ], [ -72.987392, 44.685176 ] ] }
6220.99517315235
James
{ "type": "LineString", "coordinates": [ [ -87.721321, 33.168895 ], [ -77.479410, 38.835556 ], [ -95.803087, 39.043680 ], [ -93.344795, 45.051728 ], [ -74.677538, 39.481753 ], [ -122.846159, 43.938519 ], [ -113.041258, 40.447264 ] ] }
6157.01862626762
Steve
{ "type": "LineString", "coordinates": [ [ -75.568385, 39.086100 ], [ -91.630879, 42.091532 ], [ -83.236738, 42.721871 ], [ -71.716636, 42.915407 ], [ -97.503812, 35.429885 ], [ -97.028989, 32.817835 ], [ -104.689616, 41.307065 ] ] }
4250.38939773343
Scott
{ "type": "LineString", "coordinates": [ [ -104.893931, 39.433975 ], [ -87.962153, 41.702848 ], [ -76.580825, 39.339686 ], [ -96.870816, 40.819919 ], [ -96.965552, 46.917820 ], [ -96.990074, 43.499717 ], [ -79.804105, 39.527107 ] ] }
4178.88536328387
Mark
{ "type": "LineString", "coordinates": [ [ -94.123458, 36.194649 ], [ -84.400798, 33.692203 ], [ -89.967842, 29.934402 ], [ -92.309235, 38.991761 ], [ -77.515170, 42.969919 ], [ -71.401369, 41.719232 ], [ -77.478352, 37.462083 ] ] }
3210.91726741362
Airport City
Distance
SpatialObj
536870911
Empty
if [TripOrder] = 1 then null()
else ST_CreateLine([Row-1:Centroid],[Centroid])
endif
if [TripOrder] = 1 then null()
else ST_CreateLine([Row-1:Cent...
Segment Length = ST_Length([Distance],"Mi")
Segment Length = if [TripOrder] = 1 ...
C:\Users\210693\AppData\Local\Temp\Engine_19612_05de4eba83934e42add68615e3223c8e_\Engine_23612_4674837e548c4659a9e4417abd3303f7_.yxdb
Single
Map
Horizontal
challenge_6_start_file Bacher