CREATE TABLE [dbo].[Flightpath](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Distance] [nvarchar](50) NULL,
	[Route] [nvarchar](50) NULL,
	[location] [geography] NULL
) ON [PRIMARY]
GO

INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','Moscow - St. Petersburg (400 mi)','LINESTRING (30.24527110874179 59.80975282443724, 30.413366698533341 59.784665516466013, 30.4837139378631 59.77467173870842, 30.631238378706989 59.75540263412978, 37.8451751981999 55.443246814406208, 37.902489281341133 55.395845083201287)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','Taipei - Hong Kong (500 mi)','LINESTRING (113.89434186940061 22.309504323606571, 114.31331032151451 22.445800148000071, 120.7612401062777 24.709888700212279, 121.1384638569275 25.012329373127411, 121.24368384374969 25.094692082539719)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','Islamabad - Kabul (240 mi)','LINESTRING (73.116549186167646 33.608801128583792, 73.081434794508368 33.6246230923729, 72.977021710985781 33.672544161748228, 72.7882106884538 33.758872899037307, 69.64988235034167 34.453359216703667, 69.194537579539826 34.570358824539468)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','Istanbul - Athens (350 mi)','LINESTRING (23.943212246561671 37.923482108628463, 23.970992983183368 37.952833965674678, 24.02281052584782 38.012516671305313, 24.170727200495051 38.189421616281017, 24.275506053241379 38.256525851408448, 25.440416543543421 38.863078844755407, 27.52491998814277 40.368810938536477, 28.7174409881052 40.923652375169851, 28.80997721269415 40.965645695408412, 28.832744192264709 40.976112833711348)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','Denver - Houston (890 mi)','LINESTRING (-95.339452407963435 29.95744954561696, -95.496159168203377 30.209283128404191, -103.04514242755739 39.535882275815212, -104.6103961255279 39.8772449133476, -104.6619385507363 39.877553473851982)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','New York - Chicago (730 mi)','LINESTRING (-73.856105561663483 40.77172393064928, -74.483659987356418 41.072765323603868, -87.8416016754012 41.969229150384876, -87.921299280172647 41.9690029441137)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','Sydney - Melbourne (450 mi)','LINESTRING (145.09831481938409 -37.972600966324812, 145.3410307320417 -38.214010055494832, 151.15800308670089 -34.031311571102613, 151.1938798433477 -33.970768451113727, 151.18905743951771 -33.952440253151607)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','Cairo - Athens (700 mi)','LINESTRING (23.94510226160925 37.94916072490156, 23.918176295211431 37.9207284928726, 23.78053073736724 37.778997646735391, 23.754997186876931 37.497189926902628, 31.194951101375811 30.733017940405169, 31.415852081791261 30.110751257323479)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','Kuala Lumpur - Singapore (226 mi)','LINESTRING (104.0043125005316 1.3327634927029639, 104.2521489758943 1.9288909717798819, 103.9751247192425 2.197688314496216, 103.53213030605519 1.6946574510789909, 101.599738543893 3.0727340453011869, 101.557959191196 3.116033537915825, 101.5407901868209 3.145302878287497)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','London - Paris (250 mi)','LINESTRING (-0.43389030733781908 51.477628840578213, -0.49012115915240878 51.477562256735389, -0.73793770607980491 51.476144184526348, -1.052836568633069 51.215758241183082, -0.95736231314430142 50.757395548982892, 1.710875675627392 49.0154349456521, 2.253602564203149 49.009432720100769, 2.4465864440980312 49.01725453953442, 2.571009059764009 49.023745221673551)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','Christmas Island - Jakarta (370 mi)','LINESTRING (106.6744624234145 -6.13004823027633, 106.524777470905 -6.18841066885607, 105.7178403559506 -6.4823105148641256, 105.4375683555931 -6.840748705411297, 105.68814358547441 -10.400464313064569, 105.6900731601967 -10.440518973622989, 105.69175475750021 -10.46003618996631)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','Miami - Havana (250 mi)','LINESTRING (-82.426131923558231 22.97771346714147, -81.84184204814045 23.36500620399136, -80.6154363874268 24.1781401375123, -80.291670044502524 24.808800121680481, -79.903183198338553 25.603697522058049, -80.213533129286091 25.753810565561711, -80.303420358457245 25.799819100348781)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('<1000 Miles','Tel Aviv - Damascus (130 mi)','LINESTRING (34.8612441061441 32.012944331820123, 34.900421914518567 32.018775061680493, 34.975221142443942 32.028508240134407, 35.366930564878942 32.555838594137327, 36.533090666290533 33.436579443094473)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('1000-2000 Miles','Nairobi - Antananarivo (1400 mi)','LINESTRING (36.812007065483911 -1.3192717796019491, 36.821757624852921 -1.3287473638042779, 36.854238694904907 -1.3586321258881879, 41.6792969986179 -15.19316838149463, 47.062392638616437 -18.73315763262335, 47.49306908419846 -18.799060871185471)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('1000-2000 Miles','Tokyo - Beijing (1200 mi)','LINESTRING (116.5947620948044 40.089295634790147, 116.6278217889017 39.87222865470968, 116.6612320037711 39.676125757274463, 116.71063537354971 39.579123873367379, 116.79438704587611 39.537792315516462, 116.98890653650071 39.484506759404049, 139.43986732082561 35.511521127394722, 139.66880954619239 35.495705475619189, 139.761025321734 35.548863472656507, 139.77731450059261 35.56781786974868)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('1000-2000 Miles','Paris - St. Petersburg (1300 mi)','LINESTRING (30.28206970418459 59.790369302614167, 30.219002563054659 59.799739969175981, 30.100174711496219 59.818761922688921, 29.77094513963138 59.87056239292771, 28.352463735309541 60.086315767620789, 3.011932664697611 49.046199753112347, 2.6716609393843238 49.031762401310409, 2.5615599271150131 49.026616759755413, 2.524241299841421 49.024716524983383)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('>2000 Miles','Cape Town - Abuja (3000 mi)','LINESTRING (7.2533912922703081 8.9933300140439, 7.4843844233112407 9.3255107973305584, 8.2598783799645474 10.405357707915339, 8.6957166273583084 10.64734128657828, 9.5336050720281236 10.97301710108532, 10.44527669193219 10.644917380914009, 18.259966972534581 -31.3526961451028, 18.4828576816778 -33.777406017163408, 18.494132041667651 -33.859391515267923, 18.49873113764183 -33.907782305699662)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('>2000 Miles','London - Jakarta (7350 mi)','LINESTRING (106.67379386994909 -6.1303288411397281, 106.64297606941859 -6.1424001093357923, 106.4179359516821 -6.2221368834557991, 105.52081435199951 -6.5250407473608378, 103.4771202184061 -6.6001985635821283, 102.01025104288151 -5.371621847475395, 1.3363136213143041 51.470339480628553, -0.4343905167172295 51.465029168435777, -0.487025590160755 51.464791502252609)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('>2000 Miles','Honolulu - Los Angeles (2600 mi)','LINESTRING (-118.380995200288 33.939594412690973, -118.4190300472344 33.935745687335, -118.5079782869156 33.926569451783017, -149.591710252983 21.405649798740011, -157.45042875418571 21.30696499346557, -157.94541250175919 21.306683651170939)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('>2000 Miles','Chicago - Cairo (6250 mi)','LINESTRING (-87.8997652671144 41.952925477105929, -87.879088904606292 41.970318861523239, -87.811727604322343 42.028478935022342, -87.662228780767691 42.16749472995096, -87.528765788291537 42.260356606549337, 27.9864156397533 30.52024739004521, 29.0026203208609 29.68659925223168, 30.58855004382302 29.625988579348661, 31.305753688670329 30.030799177779311, 31.3980540296681 30.099478250448229, 31.429838601567059 30.123353224319541)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('>2000 Miles','Copenhagen - Nuuk (2200 mi)','LINESTRING (-51.679644093053831 64.189134502331427, -51.639802211457173 64.243522357833115, -51.48564881612252 64.47477261848492, -50.804660839498418 64.770596325586908, 12.492706232403931 55.679033742911933, 12.579456994074251 55.646379471731578, 12.670267627414569 55.612517095232619)')
INSERT INTO [Flightpath] (Distance, Route, location) VALUES ('>2000 Miles','Chicago - Tokyo (6200 mi)','LINESTRING (-87.902491118222031 41.963183291797627, -87.933180544276183 41.990459431180042, -88.001011050339912 42.053377806229307, -88.233106608584848 42.27334448502036, -88.696132465329569 42.81586148923472, -91.016558844119118 43.918114686871093, -179.22630070960631 56.959198116706872, 142.52836152662849 38.526532154716818, 140.4017335674026 36.269521853540112, 139.93898330082149 35.752188092234483, 139.7771605941644 35.567657616715543, 139.76112483723591 35.5487499559634)')