Hi All - Thanks for all the advice in the past. I made a move to the aviation arena, and need some help making flight origination/destination tables standard to the industry in a flat format a bit more mappable.
I don't do code, but here is what I need (see below - apologies for length). Any ideas for an existing function or tool that's out there is much obliged. (Or estimates of work welcome). Not worried about the Great Circle issue, got that covered, just need a tool that will create line segments from a table with multiple origination/Destination (o/d) long/lat coordinate fields. Sinam Al-Khafaji Cartographer & Market Planner [EMAIL PROTECTED] Work 561.454.2683 Cell 561.665.0278 Jetson Systems 1801 S Federal Highway Delray Beach, FL 33483 Longitude -80.070666 Latitude 26.440834 The best example of what I want is the Table>Create Points ... dialog >already in MIPro. > >I want this type of functionality, but with the ability to give it >coordinate pairs to create line segments from a previously unmappable MI >table. > >Notes below and sample attached: Although the data sent to you is in a text >file format, I regularly transform it into its own native tab file for >development and testing. > > > >Location: > >Pulldown menu in MapInfo Table>Create Line Segments... (this starts as a >table operation to make an attribute table mappable as a line) > > > >Function: > >Creates line segments from a previously unmappable table given the >origination long/lat and destination long/lat per row > > > >Requirements: > >1.) O/D long & lat Columns pairs are to be selected by user in an interface >(much like the create points interface excepts for pairs) > > 2.) table size does not matter (some of these >tables are huge), either in column or record total counts > > 3.) Geography does not matter - could be coordinate >O/D pairs worldwide (London to New York) > > 4.) Input table is same as output, just mappable as >line segments > > > >Guarantees: > >Columns for o/d long/lat pairs will ALWAYS be- > > 1.) defined as a float field > > 2.) table will always be a native *.tab file > > 3.) Contain coordinates in Long/Lat Decimal Degrees > > > >Purpose: > >Quick Route geocoding tool to plot out the origination/destination (o/d) >data of aircraft. Attrbute data will be providng the coordinate > >pair information, with additional flight information that my be used in line >thematics once Create Line Segments... operation is complete. SAMPLE - LARGER DATASET ALSO ATTACHED > >"Orig_id___" "Dest_id___" "Drivedist_" "Drivetime_" >"Distance__" "Orig_lat__" "Orig_lon__" "Dest_lat__" >"Dest_lon__" > >"32003" "1" 230.28 212.20 170.80 30.104818 >-81.718689 27.765100 -82.626999 > >"32003" "5" 376.25 361.07 289.98 30.104818 >-81.718689 30.778799 -86.522102 > >"32003" "6" 367.98 328.55 275.60 30.104818 >-81.718689 26.378500 -80.107697 > >"32003" "9" 38.88 29.97 20.12 30.104818 >-81.718689 30.336300 -81.514397 > >"32003" "11" 145.27 127.98 99.74 30.104818 >-81.718689 28.867300 -82.571297 > >"32003" "12" 117.05 103.67 75.25 30.104818 >-81.718689 29.179899 -81.058098 > >"32003" "14" 392.05 377.85 284.49 30.104818 -81.718689 >30.400101 -86.471497 > >"32003" "21" 386.25 344.60 286.08 30.104818 -81.718689 >26.197300 -80.170700 > >"32003" "23" 23.90 19.60 13.04 30.104818 >-81.718689 30.277800 -81.805901 > >"32003" "24" 173.57 162.05 121.18 30.104818 -81.718689 >28.473600 -82.455399 > >"32003" "29" 435.72 405.95 317.92 30.104818 -81.718689 >25.647900 -80.432800 > >"32003" "30" 589.42 539.02 383.54 30.104818 -81.718689 >24.556101 -81.759598 > >"32003" "35" 201.68 188.33 147.37 30.104818 -81.718689 >27.988899 -82.018600 > >"32003" "36" 132.55 108.95 88.79 30.104818 >-81.718689 28.822701 -81.808998 > >"32003" "38" 285.65 272.53 212.43 30.104818 -81.718689 >30.837799 -85.181900 > >"32003" "40" 194.38 172.67 136.88 30.104818 -81.718689 >28.341600 -80.685501 > >"32003" "41" 419.92 394.40 310.50 30.104818 -81.718689 >25.793301 -80.290604 > >"32003" "51" 336.40 312.47 237.77 30.104818 -81.718689 >26.785000 -80.693398 > >"32003" "55" 427.82 412.15 327.36 30.104818 -81.718689 >30.473301 -87.187401 > >"32003" "56" 401.98 390.00 316.69 30.104818 -81.718689 >30.637600 -86.993698 > >"32003" "57" 196.10 181.55 147.94 30.104818 -81.718689 >28.000200 -82.164200 > >"32003" "61" 329.42 312.48 246.67 30.104818 -81.718689 >26.536200 -81.755203 > >"32003" "63" 128.00 113.13 81.53 30.104818 >-81.718689 29.080200 -81.046700 > >"32003" "67" 215.55 205.17 158.41 30.104818 -81.718689 >30.396500 -84.350304 > >"32003" "68" 209.08 192.87 155.19 30.104818 -81.718689 >27.975500 -82.533302 > >"32003" "69" 537.62 486.68 374.02 30.104818 -81.718689 >24.726101 -81.051399 > >"32003" "70" 197.68 182.57 149.39 30.104818 -81.718689 >28.014000 -82.345299 > >"32003" "72" 257.55 230.48 186.70 30.104818 -81.718689 >27.655600 -80.417900 > >"32003" "74" 194.92 183.63 141.15 30.104818 -81.718689 >28.062901 -81.753304 > >"32008" "1" 210.00 190.30 149.04 29.910507 >-82.873665 27.765100 -82.626999 > >"32008" "5" 285.38 278.00 225.74 29.910507 >-82.873665 30.778799 -86.522102 > >"32008" "6" 402.00 380.65 296.65 29.910507 >-82.873665 26.378500 -80.107697 > >"32008" "9" 121.93 106.07 86.43 29.910507 >-82.873665 30.336300 -81.514397 > >"32008" "11" 103.08 90.85 74.37 29.910507 >-82.873665 28.867300 -82.571297 > >"32008" "12" 189.17 173.90 120.29 29.910507 -82.873665 >29.179899 -81.058098 > >"32008" "14" 301.18 294.78 217.66 29.910507 -82.873665 >30.400101 -86.471497 > >"32008" "21" 414.88 390.17 305.02 29.910507 -82.873665 >26.197300 -80.170700 > >"32008" "23" 99.42 89.53 68.72 29.910507 >-82.873665 30.277800 -81.805901 > >"32008" "24" 143.13 130.08 102.48 29.910507 -82.873665 >28.473600 -82.455399 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4971
