Test upload from iPhone: INSERT INTO TripData (coords,[user],notes,purpose,start,version,source) VALUES (CAST('{"2010-09-2110:37:52":{"hac":10,"spd":8.999170949107583,"rec":"2010-09-2110:37:52","vac":19,"alt":297.9882507324219,"lon":-97.82889541349184,"lat":30.30642373238761},"2010-09-2110:37:47":{"hac":10,"spd":9.898708754348339,"rec":"2010-09-2110:37:47","vac":19,"alt":301.8101196289062,"lon":-97.8285320552563,"lat":30.30630462143213},"2010-09-2110:36:54":{"hac":10,"spd":0,"rec":"2010-09-2110:36:54","vac":19,"alt":311.8880004882812,"lon":-97.82903338692971,"lat":30.30603006746405},"2010-09-2110:36:49":{"hac":10,"spd":0,"rec":"2010-09-2110:36:49","vac":19,"alt":311.8880004882812,"lon":-97.82903338692971,"lat":30.30603006746405},"2010-09-2110:39:24":{"hac":5,"spd":13.54781672411702,"rec":"2010-09-2110:39:24","vac":9.5,"alt":244.0213165283203,"lon":-97.82763553961071,"lat":30.30477068799023},"2010-09-2110:39:44":{"hac":5,"spd":1.881399313668803,"rec":"2010-09-2110:39:44","vac":9.5,"alt":241.1486663818359,"lon":-97.82670797676005,"lat":30.30551780302748},"2010-09-2110:39:39":{"hac":5,"spd":1.48316002154553,"rec":"2010-09-2110:39:39","vac":9.5,"alt":241.1711578369141,"lon":-97.8267216020927,"lat":30.30551788568042},"2010-09-2110:39:59":{"hac":5,"spd":12.10891252622263,"rec":"2010-09-2110:39:59","vac":9.5,"alt":240.7567749023438,"lon":-97.82704852978506,"lat":30.30512738539749},"2010-09-2110:39:19":{"hac":5,"spd":13.68312775449467,"rec":"2010-09-2110:39:19","vac":9.5,"alt":248.0125579833984,"lon":-97.82832437929117,"lat":30.30450699575089},"2010-09-2110:38:51":{"hac":10,"spd":1.135440592413039,"rec":"2010-09-2110:38:51","vac":19,"alt":266.9152526855469,"lon":-97.829992104711,"lat":30.30453954534006},"2010-09-2110:39:02":{"hac":5,"spd":1.255334501379965,"rec":"2010-09-2110:39:02","vac":9.5,"alt":264.5831909179688,"lon":-97.82996325520415,"lat":30.30455399677155},"2010-09-2110:38:46":{"hac":10,"spd":0,"rec":"2010-09-2110:38:46","vac":19,"alt":268.0770874023438,"lon":-97.83000741632699,"lat":30.30455241463202},"2010-09-2110:41:29":{"hac":100,"spd":0,"rec":"2010-09-2110:41:29","vac":190,"alt":270.4041442871094,"lon":-97.82844510540694,"lat":30.30576169279847},"2010-09-2110:40:01":{"hac":10,"spd":12.85264304435654,"rec":"2010-09-2110:40:01","vac":19,"alt":240.5755157470703,"lon":-97.82724799074117,"lat":30.30497949860839},"2010-09-2110:38:04":{"hac":10,"spd":4.317671362156259,"rec":"2010-09-2110:38:04","vac":19,"alt":293.5648803710938,"lon":-97.82996318661601,"lat":30.30609134059188},"2010-09-2110:38:24":{"hac":10,"spd":5.612282295934934,"rec":"2010-09-2110:38:24","vac":19,"alt":280.3001098632812,"lon":-97.82944081995367,"lat":30.30471250859292},"2010-09-2110:38:19":{"hac":10,"spd":7.114987279767983,"rec":"2010-09-2110:38:19","vac":19,"alt":282.3672485351562,"lon":-97.82962073506832,"lat":30.30485357403693},"2010-09-2110:38:39":{"hac":10,"spd":5.796827271590644,"rec":"2010-09-2110:38:39","vac":19,"alt":268.5691833496094,"lon":-97.82989301992545,"lat":30.30454645020438},"2010-09-2110:37:51":{"hac":10,"spd":8.056661175048898,"rec":"2010-09-2110:37:51","vac":19,"alt":299.1152648925781,"lon":-97.82879581374625,"lat":30.30645276706823},"2010-09-2110:37:46":{"hac":10,"spd":10.98563247702772,"rec":"2010-09-2110:37:46","vac":19,"alt":302.2977905273438,"lon":-97.82848754752429,"lat":30.30621849805822},"2010-09-2110:36:53":{"hac":10,"spd":0,"rec":"2010-09-2110:36:53","vac":19,"alt":311.8880004882812,"lon":-97.82903338692971,"lat":30.30603006746405},"2010-09-2110:36:48":{"hac":10,"spd":0,"rec":"2010-09-2110:36:48","vac":19,"alt":311.8880004882812,"lon":-97.82903338692971,"lat":30.30603006746405},"2010-09-2110:39:23":{"hac":5,"spd":13.78213329757521,"rec":"2010-09-2110:39:23","vac":9.5,"alt":244.8076629638672,"lon":-97.827767688975,"lat":30.3047174609728},"2010-09-2110:39:43":{"hac":5,"spd":1.797531949710927,"rec":"2010-09-2110:39:43","vac":9.5,"alt":241.1612548828125,"lon":-97.82672447722624,"lat":30.30551991167373},"2010-09-2110:39:38":{"hac":5,"spd":2.351456350128994,"rec":"2010-09-2110:39:38","vac":9.5,"alt":241.1929779052734,"lon":-97.82670316534072,"lat":30.3055099664473},"2010-09-2110:39:58":{"hac":5,"spd":11.06493287738732,"rec":"2010-09-2110:39:58","vac":9.5,"alt":240.7037353515625,"lon":-97.82696579982107,"lat":30.30520696771124},"2010-09-2110:39:18":{"hac":5,"spd":13.47421001667507,"rec":"2010-09-2110:39:18","vac":9.5,"alt":248.8419342041016,"lon":-97.82846806331128,"lat":30.30446625989631},"2010-09-2110:38:50":{"hac":5,"spd":0,"rec":"2010-09-2110:38:50","vac":9.5,"alt":268.0770874023438,"lon":-97.83000741632699,"lat":30.30455241463202},"2010-09-2110:39:01":{"hac":5,"spd":0,"rec":"2010-09-2110:39:01","vac":9.5,"alt":266.3771057128906,"lon":-97.82998811923557,"lat":30.30452133151022},"2010-09-2110:38:45":{"hac":5,"spd":0,"rec":"2010-09-2110:38:45","vac":9.5,"alt":268.0770874023438,"lon":-97.83000741632699,"lat":30.30455241463202},"2010-09-2110:41:28":{"hac":100,"spd":0,"rec":"2010-09-2110:41:28","vac":190,"alt":270.4041442871094,"lon":-97.82844510540694,"lat":30.30576169279847},"2010-09-2110:40:00":{"hac":10,"spd":12.39658948757125,"rec":"2010-09-2110:40:00","vac":19,"alt":240.7889862060547,"lon":-97.82714175055608,"lat":30.30505185772705},"2010-09-2110:38:03":{"hac":10,"spd":6.153326581697262,"rec":"2010-09-2110:38:03","vac":19,"alt":293.9801025390625,"lon":-97.82992264804589,"lat":30.30611338054288},"2010-09-2110:38:23":{"hac":10,"spd":3.905319107801077,"rec":"2010-09-2110:38:23","vac":19,"alt":281.1704406738281,"lon":-97.82947704591335,"lat":30.30475019031054},"2010-09-2110:38:18":{"hac":10,"spd":9.615456735674284,"rec":"2010-09-2110:38:18","vac":19,"alt":283.552001953125,"lon":-97.82968527568779,"lat":30.30489842839345},"2010-09-2110:38:38":{"hac":10,"spd":6.877496917288,"rec":"2010-09-2110:38:38","vac":19,"alt":270.4331970214844,"lon":-97.82982830699363,"lat":30.30453076725453},"2010-09-2110:37:30":{"hac":65,"spd":-1,"rec":"2010-09-2110:37:30","vac":-1,"alt":0,"lon":-97.82898581428572,"lat":30.30615666285714},"2010-09-2110:37:50":{"hac":10,"spd":7.227691097171497,"rec":"2010-09-2110:37:50","vac":19,"alt":299.6956176757812,"lon":-97.8287084114922,"lat":30.30647054379209},"2010-09-2110:37:45":{"hac":10,"spd":8.589172055472913,"rec":"2010-09-2110:37:45","vac":19,"alt":302.6165161132812,"lon":-97.82843964471932,"lat":30.30612501282915},"2010-09-2110:37:25":{"hac":65,"spd":-1,"rec":"2010-09-2110:37:25","vac":-1,"alt":0,"lon":-97.82898581428572,"lat":30.30615666285714},"2010-09-2110:36:52":{"hac":10,"spd":0,"rec":"2010-09-2110:36:52","vac":19,"alt":311.8880004882812,"lon":-97.82903338692971,"lat":30.30603006746405},"2010-09-2110:36:47":{"hac":10,"spd":0,"rec":"2010-09-2110:36:47","vac":19,"alt":311.8880004882812,"lon":-97.82903338692971,"lat":30.30603006746405},"2010-09-2110:39:22":{"hac":5,"spd":13.98298417254186,"rec":"2010-09-2110:39:22","vac":9.5,"alt":245.58056640625,"lon":-97.82790266222474,"lat":30.30466253890607},"2010-09-2110:39:42":{"hac":5,"spd":0,"rec":"2010-09-2110:39:42","vac":9.5,"alt":241.1711578369141,"lon":-97.8267216020927,"lat":30.30551788568042},"2010-09-2110:39:37":{"hac":5,"spd":3.266954252744744,"rec":"2010-09-2110:39:37","vac":9.5,"alt":241.2066040039062,"lon":-97.82668314845853,"lat":30.30549139629235},"2010-09-2110:39:57":{"hac":5,"spd":9.727029849418249,"rec":"2010-09-2110:39:57","vac":9.5,"alt":240.66064453125,"lon":-97.82689580676583,"lat":30.30528177044953},"2010-09-2110:39:17":{"hac":5,"spd":13.02367742954053,"rec":"2010-09-2110:39:17","vac":9.5,"alt":249.6630859375,"lon":-97.82860971263578,"lat":30.3044353952313},"2010-09-2110:39:00":{"hac":5,"spd":0,"rec":"2010-09-2110:39:00","vac":9.5,"alt":266.3771057128906,"lon":-97.82998811923557,"lat":30.30452133151022},"2010-09-2110:38:44":{"hac":5,"spd":0,"rec":"2010-09-2110:38:44","vac":9.5,"alt":268.0770874023438,"lon":-97.83000741632699,"lat":30.30455241463202},"2010-09-2110:41:27":{"hac":100,"spd":0,"rec":"2010-09-2110:41:27","vac":190,"alt":270.4041442871094,"lon":-97.82844510540694,"lat":30.30576169279847},"2010-09-2110:38:59":{"hac":5,"spd":0,"rec":"2010-09-2110:38:59","vac":9.5,"alt":266.3771057128906,"lon":-97.82998811923557,"lat":30.30452133151022},"2010-09-2110:38:02":{"hac":10,"spd":7.597025947205447,"rec":"2010-09-2110:38:02","vac":19,"alt":294.4507141113281,"lon":-97.82986087567814,"lat":30.30613268347741},"2010-09-2110:38:22":{"hac":10,"spd":3.659706113009513,"rec":"2010-09-2110:38:22","vac":19,"alt":281.25537109375,"lon":-97.82950481580161,"lat":30.30477696547919},"2010-09-2110:38:17":{"hac":10,"spd":10.95610324624374,"rec":"2010-09-2110:38:17","vac":19,"alt":284.6433715820312,"lon":-97.82976517320057,"lat":30.3049590359303},"2010-09-2110:38:37":{"hac":10,"spd":7.507276675806326,"rec":"2010-09-2110:38:37","vac":19,"alt":272.1136474609375,"lon":-97.82975358685786,"lat":30.30451347940579},"2010-09-2110:37:24":{"hac":2782,"spd":-1,"rec":"2010-09-2110:37:24","vac":-1,"alt":0,"lon":-97.83031563999999,"lat":30.3095445},"2010-09-2110:37:44":{"hac":10,"spd":10.25172978137885,"rec":"2010-09-2110:37:44","vac":19,"alt":303.1330261230469,"lon":-97.82839924306583,"lat":30.30603901002994},"2010-09-2110:37:39":{"hac":30,"spd":2.501838827740328,"rec":"2010-09-2110:37:39","vac":57,"alt":307.9750671386719,"lon":-97.82847977328404,"lat":30.30583998012333},"2010-09-2110:37:59":{"hac":10,"spd":10.37459686130835,"rec":"2010-09-2110:37:59","vac":19,"alt":295.4419250488281,"lon":-97.8295880388693,"lat":30.30620207438999},"2010-09-2110:36:51":{"hac":10,"spd":0,"rec":"2010-09-2110:36:51","vac":19,"alt":311.8880004882812,"lon":-97.82903338692971,"lat":30.30603006746405},"2010-09-2110:36:46":{"hac":10,"spd":0,"rec":"2010-09-2110:36:46","vac":19,"alt":311.8880004882812,"lon":-97.82903338692971,"lat":30.30603006746405},"2010-09-2110:39:21":{"hac":5,"spd":14.1064082932692,"rec":"2010-09-2110:39:21","vac":9.5,"alt":246.3739318847656,"lon":-97.82804075805009,"lat":30.30460806980986},"2010-09-2110:39:41":{"hac":5,"spd":0,"rec":"2010-09-2110:39:41","vac":9.5,"alt":241.1711578369141,"lon":-97.8267216020927,"lat":30.30551788568042},"2010-09-2110:39:36":{"hac":5,"spd":3.782001983763058,"rec":"2010-09-2110:39:36","vac":9.5,"alt":241.2245330810547,"lon":-97.82666897825163,"lat":30.30546050594452},"2010-09-2110:39:56":{"hac":5,"spd":7.98454729965029,"rec":"2010-09-2110:39:56","vac":9.5,"alt":240.5752563476562,"lon":-97.82683887907598,"lat":30.30534781663978},"2010-09-2110:39:16":{"hac":10,"spd":12.68014397187904,"rec":"2010-09-2110:39:16","vac":19,"alt":250.1519317626953,"lon":-97.82874505534043,"lat":30.30441567666448},"2010-09-2110:38:43":{"hac":5,"spd":0,"rec":"2010-09-2110:38:43","vac":9.5,"alt":268.0770874023438,"lon":-97.83000741632699,"lat":30.30455241463202},"2010-09-2110:41:26":{"hac":100,"spd":0,"rec":"2010-09-2110:41:26","vac":190,"alt":270.4041442871094,"lon":-97.82844510540694,"lat":30.30576169279847},"2010-09-2110:39:09":{"hac":10,"spd":8.437592688233163,"rec":"2010-09-2110:39:09","vac":19,"alt":253.4463653564453,"lon":-97.82954731054144,"lat":30.30444397722823},"2010-09-2110:38:58":{"hac":5,"spd":0,"rec":"2010-09-2110:38:58","vac":9.5,"alt":266.3771057128906,"lon":-97.82998811923557,"lat":30.30452133151022},"2010-09-2110:38:01":{"hac":10,"spd":9.448564374129385,"rec":"2010-09-2110:38:01","vac":19,"alt":295.08984375,"lon":-97.82978382997207,"lat":30.3061541726224},"2010-09-2110:38:21":{"hac":10,"spd":3.41011036564089,"rec":"2010-09-2110:38:21","vac":19,"alt":281.3395690917969,"lon":-97.82953778569842,"lat":30.30479827687742},"2010-09-2110:38:16":{"hac":10,"spd":11.81655530552104,"rec":"2010-09-2110:38:16","vac":19,"alt":285.7935180664062,"lon":-97.82984907377453,"lat":30.30503121426606},"2010-09-2110:38:36":{"hac":10,"spd":7.638802192827824,"rec":"2010-09-2110:38:36","vac":19,"alt":273.4984130859375,"lon":-97.82967565858054,"lat":30.30449509455086},"2010-09-2110:37:43":{"hac":10,"spd":6.928550046623101,"rec":"2010-09-2110:37:43","vac":19,"alt":303.9888000488281,"lon":-97.82837127399188,"lat":30.30596077630656},"2010-09-2110:37:38":{"hac":30,"spd":0,"rec":"2010-09-2110:37:38","vac":57,"alt":308.3831787109375,"lon":-97.82861879765524,"lat":30.30586297881176},"2010-09-2110:37:58":{"hac":10,"spd":10.27732262454901,"rec":"2010-09-2110:37:58","vac":19,"alt":295.6190185546875,"lon":-97.82948398398148,"lat":30.30622721566272},"2010-09-2110:36:50":{"hac":10,"spd":0,"rec":"2010-09-2110:36:50","vac":19,"alt":311.8880004882812,"lon":-97.82903338692971,"lat":30.30603006746405},"2010-09-2110:36:45":{"hac":10,"spd":0,"rec":"2010-09-2110:36:45","vac":19,"alt":311.8880004882812,"lon":-97.82903338692971,"lat":30.30603006746405},"2010-09-2110:39:20":{"hac":5,"spd":13.81063436872191,"rec":"2010-09-2110:39:20","vac":9.5,"alt":247.1863403320312,"lon":-97.82818211918097,"lat":30.30455497797783},"2010-09-2110:39:40":{"hac":5,"spd":0,"rec":"2010-09-2110:39:40","vac":9.5,"alt":241.1711578369141,"lon":-97.8267216020927,"lat":30.30551788568042},"2010-09-2110:39:35":{"hac":5,"spd":4.528044595879118,"rec":"2010-09-2110:39:35","vac":9.5,"alt":241.2375640869141,"lon":-97.82666928513687,"lat":30.30542216734183},"2010-09-2110:39:55":{"hac":10,"spd":5.811216984191614,"rec":"2010-09-2110:39:55","vac":19,"alt":240.574462890625,"lon":-97.8267925214124,"lat":30.30540102041759},"2010-09-2110:39:15":{"hac":10,"spd":12.131914036962,"rec":"2010-09-2110:39:15","vac":19,"alt":250.3621826171875,"lon":-97.82887775158531,"lat":30.30440410428653},"2010-09-2110:38:42":{"hac":10,"spd":1.923795699922562,"rec":"2010-09-2110:38:42","vac":19,"alt":268.0770874023438,"lon":-97.83000741632699,"lat":30.30455241463202},"2010-09-2110:41:30":{"hac":100,"spd":0,"rec":"2010-09-2110:41:30","vac":190,"alt":270.4041442871094,"lon":-97.82844510540694,"lat":30.30576169279847},"2010-09-2110:41:25":{"hac":50,"spd":0,"rec":"2010-09-2110:41:25","vac":95,"alt":270.4041442871094,"lon":-97.82844510540694,"lat":30.30576169279847},"2010-09-2110:39:08":{"hac":10,"spd":7.625353216976768,"rec":"2010-09-2110:39:08","vac":19,"alt":254.4005279541016,"lon":-97.82963065947618,"lat":30.30446464428392},"2010-09-2110:38:57":{"hac":10,"spd":0,"rec":"2010-09-2110:38:57","vac":19,"alt":266.3771057128906,"lon":-97.82998811923557,"lat":30.30452133151022},"2010-09-2110:38:00":{"hac":10,"spd":10.21723708181532,"rec":"2010-09-2110:38:00","vac":19,"alt":295.4266052246094,"lon":-97.82969027926865,"lat":30.30617802495271},"2010-09-2110:38:20":{"hac":10,"spd":4.77488579018358,"rec":"2010-09-2110:38:20","vac":19,"alt":281.4226684570312,"lon":-97.82957346383918,"lat":30.30482122430533},"2010-09-2110:38:15":{"hac":10,"spd":12.54967557099489,"rec":"2010-09-2110:38:15","vac":19,"alt":286.9585571289062,"lon":-97.82990618956778,"lat":30.30512776830648},"2010-09-2110:38:35":{"hac":10,"spd":6.756321389244129,"rec":"2010-09-2110:38:35","vac":19,"alt":274.7190246582031,"lon":-97.82960033008334,"lat":30.30447688855758},"2010-09-2110:37:42":{"hac":10,"spd":5.697029985109308,"rec":"2010-09-2110:37:42","vac":19,"alt":305.3702087402344,"lon":-97.82836561167224,"lat":30.30591112962453},"2010-09-2110:37:37":{"hac":30,"spd":0,"rec":"2010-09-2110:37:37","vac":57,"alt":308.3831787109375,"lon":-97.82861879765524,"lat":30.30586297881176},"2010-09-2110:37:57":{"hac":10,"spd":9.928582730948458,"rec":"2010-09-2110:37:57","vac":19,"alt":295.7396240234375,"lon":-97.8293802698452,"lat":30.30625298786755},"2010-09-2110:39:14":{"hac":5,"spd":11.21596772860186,"rec":"2010-09-2110:39:14","vac":9.5,"alt":250.6143188476562,"lon":-97.82900533501612,"lat":30.30439966144298},"2010-09-2110:39:34":{"hac":5,"spd":5.341906267154029,"rec":"2010-09-2110:39:34","vac":9.5,"alt":241.2667999267578,"lon":-97.82669295590323,"lat":30.30537904516884},"2010-09-2110:39:54":{"hac":5,"spd":3.871475126748881,"rec":"2010-09-2110:39:54","vac":9.5,"alt":240.7301635742188,"lon":-97.82676023367654,"lat":30.30543991836761},"2010-09-2110:39:49":{"hac":5,"spd":1.29460848626294,"rec":"2010-09-2110:39:49","vac":9.5,"alt":240.9672393798828,"lon":-97.82670780414344,"lat":30.30550083648826},"2010-09-2110:39:29":{"hac":10,"spd":13.00624425982562,"rec":"2010-09-2110:39:29","vac":19,"alt":241.4535369873047,"lon":-97.8270327200416,"lat":30.30508638926655},"2010-09-2110:38:41":{"hac":5,"spd":3.027172211972564,"rec":"2010-09-2110:38:41","vac":9.5,"alt":268.2476196289062,"lon":-97.82998170055754,"lat":30.30455841334761},"2010-09-2110:41:24":{"hac":50,"spd":0,"rec":"2010-09-2110:41:24","vac":95,"alt":270.4041442871094,"lon":-97.82844510540694,"lat":30.30576169279847},"2010-09-2110:39:07":{"hac":10,"spd":7.245058028262965,"rec":"2010-09-2110:39:07","vac":19,"alt":255.6051483154297,"lon":-97.82970320449292,"lat":30.30448735655606},"2010-09-2110:38:56":{"hac":5,"spd":0,"rec":"2010-09-2110:38:56","vac":9.5,"alt":266.3771057128906,"lon":-97.82998811923557,"lat":30.30452133151022},"2010-09-2110:38:14":{"hac":10,"spd":13.30926256382845,"rec":"2010-09-2110:38:14","vac":19,"alt":288.0306091308594,"lon":-97.8299574814168,"lat":30.30523424784606},"2010-09-2110:38:34":{"hac":10,"spd":5.694330885617705,"rec":"2010-09-2110:38:34","vac":19,"alt":275.8560180664062,"lon":-97.82953367280338,"lat":30.30446202741211},"2010-09-2110:38:29":{"hac":10,"spd":3.086490045015912,"rec":"2010-09-2110:38:29","vac":19,"alt":277.4697875976562,"lon":-97.8293583641607,"lat":30.30450939885114},"2010-09-2110:38:09":{"hac":10,"spd":10.70218777516281,"rec":"2010-09-2110:38:09","vac":19,"alt":292.026123046875,"lon":-97.8300515839956,"lat":30.30581583687327},"2010-09-2110:37:41":{"hac":10,"spd":4.126050383815618,"rec":"2010-09-2110:37:41","vac":19,"alt":307.5479431152344,"lon":-97.8283880268027,"lat":30.30587151560482},"2010-09-2110:37:36":{"hac":30,"spd":0,"rec":"2010-09-2110:37:36","vac":57,"alt":308.6450500488281,"lon":-97.82873056670115,"lat":30.30590779573632},"2010-09-2110:37:56":{"hac":10,"spd":9.488672198193688,"rec":"2010-09-2110:37:56","vac":19,"alt":295.735595703125,"lon":-97.82927975237351,"lat":30.3062803207695},"2010-09-2110:39:13":{"hac":5,"spd":11.0468618405312,"rec":"2010-09-2110:39:13","vac":9.5,"alt":250.8785552978516,"lon":-97.82912558724317,"lat":30.30439802131017},"2010-09-2110:39:33":{"hac":10,"spd":7.113969886983315,"rec":"2010-09-2110:39:33","vac":19,"alt":241.3348999023438,"lon":-97.82673399855707,"lat":30.30533606402527},"2010-09-2110:39:53":{"hac":5,"spd":2.491191527249641,"rec":"2010-09-2110:39:53","vac":9.5,"alt":240.7567291259766,"lon":-97.82674035582352,"lat":30.30546483522458},"2010-09-2110:39:48":{"hac":5,"spd":1.374290948490217,"rec":"2010-09-2110:39:48","vac":9.5,"alt":241.0275726318359,"lon":-97.82670247842165,"lat":30.30550840567339},"2010-09-2110:39:28":{"hac":10,"spd":13.12868400239009,"rec":"2010-09-2110:39:28","vac":19,"alt":241.6141204833984,"lon":-97.82713792542286,"lat":30.30501012349192},"2010-09-2110:38:40":{"hac":5,"spd":3.95742852271532,"rec":"2010-09-2110:38:40","vac":9.5,"alt":268.4132080078125,"lon":-97.82994164453564,"lat":30.30455915658505},"2010-09-2110:41:23":{"hac":50,"spd":0,"rec":"2010-09-2110:41:23","vac":95,"alt":270.4041442871094,"lon":-97.82844510540694,"lat":30.30576169279847},"2010-09-2110:39:06":{"hac":5,"spd":7.041761068072188,"rec":"2010-09-2110:39:06","vac":9.5,"alt":257.1315002441406,"lon":-97.82977159386618,"lat":30.30450868871203},"2010-09-2110:38:55":{"hac":5,"spd":0,"rec":"2010-09-2110:38:55","vac":9.5,"alt":266.3771057128906,"lon":-97.82998811923557,"lat":30.30452133151022},"2010-09-2110:40:05":{"hac":5,"spd":14.73820606017651,"rec":"2010-09-2110:40:05","vac":9.5,"alt":239.6006927490234,"lon":-97.82779102981503,"lat":30.30474841550493},"2010-09-2110:38:13":{"hac":10,"spd":13.30926256382845,"rec":"2010-09-2110:38:13","vac":19,"alt":289.0431518554688,"lon":-97.8299854802744,"lat":30.30535398273133},"2010-09-2110:38:33":{"hac":10,"spd":4.096886106685084,"rec":"2010-09-2110:38:33","vac":19,"alt":277.060791015625,"lon":-97.82947699654571,"lat":30.30445080636423},"2010-09-2110:38:28":{"hac":10,"spd":3.463688384991401,"rec":"2010-09-2110:38:28","vac":19,"alt":277.5345458984375,"lon":-97.82936474764615,"lat":30.30453821566356},"2010-09-2110:38:08":{"hac":10,"spd":8.794148555515784,"rec":"2010-09-2110:38:08","vac":19,"alt":292.7379455566406,"lon":-97.83006139089512,"lat":30.30590862355355},"2010-09-2110:37:40":{"hac":10,"spd":2.828042413679917,"rec":"2010-09-2110:37:40","vac":19,"alt":307.7633666992188,"lon":-97.82842476681326,"lat":30.3058458951119},"2010-09-2110:37:35":{"hac":100,"spd":12.74725482336555,"rec":"2010-09-2110:37:35","vac":190,"alt":308.9967041015625,"lon":-97.82885980365678,"lat":30.30587791049968},"2010-09-2110:37:55":{"hac":10,"spd":9.092245608355141,"rec":"2010-09-2110:37:55","vac":19,"alt":295.8641662597656,"lon":-97.82918355589128,"lat":30.3063137582994},"2010-09-2110:39:12":{"hac":5,"spd":10.63330508433384,"rec":"2010-09-2110:39:12","vac":9.5,"alt":251.3113098144531,"lon":-97.82924264549843,"lat":30.3044010460612},"2010-09-2110:39:32":{"hac":10,"spd":9.923061465900725,"rec":"2010-09-2110:39:32","vac":19,"alt":241.4877014160156,"lon":-97.82678457257744,"lat":30.30528258911102},"2010-09-2110:39:52":{"hac":5,"spd":1.20892502465105,"rec":"2010-09-2110:39:52","vac":9.5,"alt":240.7947845458984,"lon":-97.82672850682424,"lat":30.30548035650497},"2010-09-2110:39:47":{"hac":5,"spd":0,"rec":"2010-09-2110:39:47","vac":9.5,"alt":241.1486663818359,"lon":-97.82670797676005,"lat":30.30551780302748},"2010-09-2110:39:27":{"hac":10,"spd":13.74110122584105,"rec":"2010-09-2110:39:27","vac":19,"alt":242.0225067138672,"lon":-97.82724608297444,"lat":30.30493449945607},"2010-09-2110:41:22":{"hac":50,"spd":0,"rec":"2010-09-2110:41:22","vac":95,"alt":270.4041442871094,"lon":-97.82844510540694,"lat":30.30576169279847},"2010-09-2110:39:05":{"hac":5,"spd":6.11815454954966,"rec":"2010-09-2110:39:05","vac":9.5,"alt":259.0158386230469,"lon":-97.82983709699431,"lat":30.30452534976426},"2010-09-2110:38:54":{"hac":10,"spd":0,"rec":"2010-09-2110:38:54","vac":19,"alt":266.3771057128906,"lon":-97.82998811923557,"lat":30.30452133151022},"2010-09-2110:38:49":{"hac":10,"spd":0,"rec":"2010-09-2110:38:49","vac":19,"alt":268.0770874023438,"lon":-97.83000741632699,"lat":30.30455241463202},"2010-09-2110:40:04":{"hac":5,"spd":14.68779236947304,"rec":"2010-09-2110:40:04","vac":9.5,"alt":239.614990234375,"lon":-97.82764880115542,"lat":30.30480291313536},"2010-09-2110:38:12":{"hac":10,"spd":13.32572925970781,"rec":"2010-09-2110:38:12","vac":19,"alt":290.2041320800781,"lon":-97.83000472915883,"lat":30.30547441839391},"2010-09-2110:38:32":{"hac":10,"spd":3.304865901921961,"rec":"2010-09-2110:38:32","vac":19,"alt":277.1830444335938,"lon":-97.8294319921838,"lat":30.30445265906522},"2010-09-2110:38:27":{"hac":10,"spd":5.193796175990838,"rec":"2010-09-2110:38:27","vac":19,"alt":277.6016540527344,"lon":-97.82937440154977,"lat":30.30456952655227},"2010-09-2110:38:07":{"hac":10,"spd":6.770334346290416,"rec":"2010-09-2110:38:07","vac":19,"alt":293.2216491699219,"lon":-97.83004214907731,"lat":30.3059811268044},"2010-09-2110:37:34":{"hac":50,"spd":12.74725482336555,"rec":"2010-09-2110:37:34","vac":95,"alt":308.9967041015625,"lon":-97.82896099368668,"lat":30.30595223116329},"2010-09-2110:37:54":{"hac":10,"spd":9.070611243770363,"rec":"2010-09-2110:37:54","vac":19,"alt":296.344482421875,"lon":-97.82909107705494,"lat":30.30635207923792},"2010-09-2110:37:49":{"hac":10,"spd":7.227691097171498,"rec":"2010-09-2110:37:49","vac":19,"alt":300.1931457519531,"lon":-97.82864282065306,"lat":30.30642642945312},"2010-09-2110:39:11":{"hac":5,"spd":9.900321194287764,"rec":"2010-09-2110:39:11","vac":9.5,"alt":251.9337768554688,"lon":-97.82935369721841,"lat":30.3044103408323},"2010-09-2110:39:31":{"hac":10,"spd":11.42137144162953,"rec":"2010-09-2110:39:31","vac":19,"alt":241.5781097412109,"lon":-97.82685237439232,"lat":30.30522320934762},"2010-09-2110:39:51":{"hac":5,"spd":1.157508038760501,"rec":"2010-09-2110:39:51","vac":9.5,"alt":240.8491973876953,"lon":-97.82671957944561,"lat":30.30548613421228},"2010-09-2110:39:46":{"hac":5,"spd":0,"rec":"2010-09-2110:39:46","vac":9.5,"alt":241.1486663818359,"lon":-97.82670797676005,"lat":30.30551780302748},"2010-09-2110:39:26":{"hac":10,"spd":13.64856602774636,"rec":"2010-09-2110:39:26","vac":19,"alt":242.5722198486328,"lon":-97.82737481117297,"lat":30.30487826061275},"2010-09-2110:41:21":{"hac":50,"spd":0,"rec":"2010-09-2110:41:21","vac":95,"alt":270.4041442871094,"lon":-97.82844510540694,"lat":30.30576169279847},"2010-09-2110:39:04":{"hac":5,"spd":4.800770301415024,"rec":"2010-09-2110:39:04","vac":9.5,"alt":261.3580017089844,"lon":-97.82989337868177,"lat":30.30453835260985},"2010-09-2110:38:53":{"hac":5,"spd":1.033212494397859,"rec":"2010-09-2110:38:53","vac":9.5,"alt":266.3771057128906,"lon":-97.82998811923557,"lat":30.30452133151022},"2010-09-2110:38:48":{"hac":10,"spd":0,"rec":"2010-09-2110:38:48","vac":19,"alt":268.0770874023438,"lon":-97.83000741632699,"lat":30.30455241463202},"2010-09-2110:40:03":{"hac":5,"spd":14.25791410313569,"rec":"2010-09-2110:40:03","vac":9.5,"alt":239.7986602783203,"lon":-97.82750949954108,"lat":30.30486036799942},"2010-09-2110:38:11":{"hac":10,"spd":12.71801472353863,"rec":"2010-09-2110:38:11","vac":19,"alt":291.1895751953125,"lon":-97.83002120460782,"lat":30.30559447628106},"2010-09-2110:38:31":{"hac":10,"spd":3.200192471191297,"rec":"2010-09-2110:38:31","vac":19,"alt":277.2958679199219,"lon":-97.82939857428326,"lat":30.30446312536565},"2010-09-2110:38:26":{"hac":10,"spd":6.047029457106666,"rec":"2010-09-2110:38:26","vac":19,"alt":278.5001220703125,"lon":-97.82939120952122,"lat":30.30461311463443},"2010-09-2110:38:06":{"hac":10,"spd":4.563755129335251,"rec":"2010-09-2110:38:06","vac":19,"alt":293.3766784667969,"lon":-97.83002060690256,"lat":30.30603654920742},"2010-09-2110:37:53":{"hac":5,"spd":9.203072270596412,"rec":"2010-09-2110:37:53","vac":9.5,"alt":296.9375305175781,"lon":-97.82899520440853,"lat":30.30638963291853},"2010-09-2110:37:48":{"hac":10,"spd":8.392566251428436,"rec":"2010-09-2110:37:48","vac":19,"alt":301.0293579101562,"lon":-97.82857725043172,"lat":30.30637878648166},"2010-09-2110:37:28":{"hac":65,"spd":-1,"rec":"2010-09-2110:37:28","vac":-1,"alt":0,"lon":-97.82898581428572,"lat":30.30615666285714},"2010-09-2110:39:10":{"hac":10,"spd":9.258398300651413,"rec":"2010-09-2110:39:10","vac":19,"alt":252.7310333251953,"lon":-97.82945476970438,"lat":30.30442531762125},"2010-09-2110:39:30":{"hac":10,"spd":11.66604430725655,"rec":"2010-09-2110:39:30","vac":19,"alt":241.4828796386719,"lon":-97.82694042658652,"lat":30.30515553128211},"2010-09-2110:39:50":{"hac":5,"spd":0,"rec":"2010-09-2110:39:50","vac":9.5,"alt":240.9672393798828,"lon":-97.82670780414344,"lat":30.30550083648826},"2010-09-2110:39:45":{"hac":5,"spd":0,"rec":"2010-09-2110:39:45","vac":9.5,"alt":241.1486663818359,"lon":-97.82670797676005,"lat":30.30551780302748},"2010-09-2110:39:25":{"hac":5,"spd":13.54602791107133,"rec":"2010-09-2110:39:25","vac":9.5,"alt":243.251220703125,"lon":-97.8275053172943,"lat":30.30482515529922},"2010-09-2110:38:52":{"hac":5,"spd":1.20156264027331,"rec":"2010-09-2110:38:52","vac":9.5,"alt":266.6497802734375,"lon":-97.8299898065799,"lat":30.30452965386505},"2010-09-2110:39:03":{"hac":5,"spd":2.801210414335979,"rec":"2010-09-2110:39:03","vac":9.5,"alt":264.2880249023438,"lon":-97.82993764473528,"lat":30.30454757339751},"2010-09-2110:38:47":{"hac":10,"spd":0,"rec":"2010-09-2110:38:47","vac":19,"alt":268.0770874023438,"lon":-97.83000741632699,"lat":30.30455241463202},"2010-09-2110:40:02":{"hac":10,"spd":13.61807224607512,"rec":"2010-09-2110:40:02","vac":19,"alt":240.164306640625,"lon":-97.82737625863356,"lat":30.30492111249363},"2010-09-2110:38:10":{"hac":10,"spd":12.34261537095875,"rec":"2010-09-2110:38:10","vac":19,"alt":291.7180480957031,"lon":-97.83003666781994,"lat":30.3057081307076},"2010-09-2110:38:30":{"hac":10,"spd":3.177403043092089,"rec":"2010-09-2110:38:30","vac":19,"alt":277.4025573730469,"lon":-97.82937329299085,"lat":30.3044823293793},"2010-09-2110:38:25":{"hac":10,"spd":6.407585226521828,"rec":"2010-09-2110:38:25","vac":19,"alt":279.4840087890625,"lon":-97.82941415020642,"lat":30.30466257166752},"2010-09-2110:38:05":{"hac":10,"spd":3.959634336027488,"rec":"2010-09-2110:38:05","vac":19,"alt":293.5445251464844,"lon":-97.82999646706176,"lat":30.3060702570696}}' as NVARCHAR(255)),'{"homeZIP":"78130","cyclingFreq":2,"age":"28","gender":"Male","workZIP":"78746"}','Cartest','Work-Related','2010-09-2110:36:45','2','iphone')