Integration Services (BIDS)

  • I have a flat file whose rows and columns need to be reversed (transformed). Can BIDS handle that?

    thanks

    f

  • I'm assuming that "reversing columns and rows" you mean that the data needs to be pivoted.

    There are a few ways to do this. The SSIS Pivot Transformation task will work (If I am understanding your requirement correctly). You could also bring in the flat file as is and use T-SQL to pivot the data once it's imported.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • My problem is that the flat file doesn't appear to have any "standard format", for example: see below.

    I want the output table to be 4 columns: X,Y, Record #, Point Order [within the record].

    My Input file looks like the follow (except it has many more records).

    Any further ideas?

    thanks

    frank

    ___________

    Record:0

    [NumPoints:66]{X=-86.971284, Y=36.369636},{X=-86.971365, Y=36.369658},{X=-86.97202, Y=36.369832},{X=-86.973135, Y=36.370131},{X=-86.975785, Y=36.370845},{X=-86.976626, Y=36.371075},{X=-86.978209, Y=36.3715},{X=-86.978693, Y=36.371624},{X=-86.978911, Y=36.37168},{X=-86.979975, Y=36.371971},{X=-86.980453, Y=36.372114},{X=-86.98054, Y=36.372144},{X=-86.980924, Y=36.372271},{X=-86.981182, Y=36.372371},{X=-86.981334, Y=36.372439},{X=-86.981431, Y=36.372483},{X=-86.981859, Y=36.372699},{X=-86.982133, Y=36.372853},{X=-86.982396, Y=36.373018},{X=-86.982549, Y=36.373122},{X=-86.983478, Y=36.373797},{X=-86.983541, Y=36.373843},{X=-86.984159, Y=36.374304},{X=-86.984371, Y=36.374463},{X=-86.985007, Y=36.37494},{X=-86.98503, Y=36.374957},{X=-86.985216, Y=36.375104},{X=-86.985299, Y=36.375169},{X=-86.985686, Y=36.375456},{X=-86.985773, Y=36.375521},{X=-86.986198, Y=36.375828},{X=-86.986765, Y=36.376246},{X=-86.987106, Y=36.376505},{X=-86.987324, Y=36.376671},{X=-86.987569, Y=36.376868},{X=-86.987808, Y=36.377059},{X=-86.988355, Y=36.377498},{X=-86.988496, Y=36.37762},{X=-86.988521, Y=36.377642},{X=-86.988752, Y=36.377845},{X=-86.989193, Y=36.378234},{X=-86.990156, Y=36.379111},{X=-86.990568, Y=36.379501},{X=-86.991771, Y=36.380669},{X=-86.991891, Y=36.380786},{X=-86.992161, Y=36.381039},{X=-86.992827, Y=36.381678},{X=-86.993454, Y=36.382278},{X=-86.994201, Y=36.382995},{X=-86.995745, Y=36.384479},{X=-86.997729, Y=36.386373},{X=-86.99836, Y=36.386933},{X=-86.9992, Y=36.387659},{X=-86.999341, Y=36.387772},{X=-86.999506, Y=36.387892},{X=-86.99983, Y=36.388153},{X=-87.000224, Y=36.388455},{X=-87.000805, Y=36.388886},{X=-87.000957, Y=36.388995},{X=-87.001277, Y=36.389224},{X=-87.001668, Y=36.389498},{X=-87.00239, Y=36.389986},{X=-87.003199, Y=36.390498},{X=-87.003655, Y=36.390774},{X=-87.004146, Y=36.391067},{X=-87.004436, Y=36.391232}

    Record:1

    [NumPoints:2]{X=-84.567017, Y=38.360526},{X=-84.56704, Y=38.360684}

    Record:2

    [NumPoints:2]{X=-84.568051, Y=38.348926},{X=-84.568009, Y=38.349212}

    Record:3

    [NumPoints:295]{X=-73.087234, Y=41.535622},{X=-73.087652, Y=41.534786},{X=-73.087836, Y=41.534483},{X=-73.088079, Y=41.53383},{X=-73.088287, Y=41.532999},{X=-73.088312, Y=41.532823},{X=-73.088417, Y=41.532111},{X=-73.088442, Y=41.531106},{X=-73.088438, Y=41.529874},{X=-73.088449, Y=41.527648},{X=-73.08845, Y=41.527637},{X=-73.088579, Y=41.526912},{X=-73.088771, Y=41.52632},{X=-73.088917, Y=41.525978},{X=-73.089285, Y=41.525346},{X=-73.089527, Y=41.524986},{X=-73.089639, Y=41.52482},{X=-73.089647, Y=41.52481},{X=-73.090088, Y=41.524309},{X=-73.090568, Y=41.523867},{X=-73.091038, Y=41.523497},{X=-73.091373, Y=41.523239},{X=-73.091694, Y=41.523031},{X=-73.092961, Y=41.522416},{X=-73.093007, Y=41.522394},{X=-73.094239, Y=41.521901},{X=-73.096102, Y=41.521161},{X=-73.098691, Y=41.520134},{X=-73.099545, Y=41.519792},{X=-73.10041, Y=41.519481},{X=-73.101564, Y=41.519149},{X=-73.101746, Y=41.519102},{X=-73.103689, Y=41.518608},{X=-73.103926, Y=41.518551},{X=-73.104637, Y=41.518381},{X=-73.104875, Y=41.518325},{X=-73.10503, Y=41.518288},{X=-73.105334, Y=41.518209},{X=-73.105474, Y=41.518174},{X=-73.106718, Y=41.517888},{X=-73.10718, Y=41.517782},{X=-73.107818, Y=41.517635},{X=-73.107843, Y=41.51763},{X=-73.109729, Y=41.517182},{X=-73.110366, Y=41.517031},{X=-73.111908, Y=41.516686},{X=-73.112745, Y=41.516494},{X=-73.115422, Y=41.515884},{X=-73.117296, Y=41.515413},{X=-73.118384, Y=41.5151},{X=-73.119827, Y=41.514659},{X=-73.121898, Y=41.514027},{X=-73.122162, Y=41.513952},{X=-73.12239, Y=41.513878},{X=-73.124596, Y=41.513205},{X=-73.124736, Y=41.51316},{X=-73.12696, Y=41.512464},{X=-73.129096, Y=41.511816},{X=-73.131684, Y=41.511039},{X=-73.132464, Y=41.510795},{X=-73.135036, Y=41.509993},{X=-73.135205, Y=41.509939},{X=-73.135715, Y=41.509781},{X=-73.135885, Y=41.509728},{X=-73.136055, Y=41.509675},{X=-73.136271, Y=41.509605},{X=-73.137084, Y=41.509347},{X=-73.137433, Y=41.509242},{X=-73.137822, Y=41.509126},{X=-73.138576, Y=41.508863},{X=-73.138627, Y=41.50884},{X=-73.139415, Y=41.508506},{X=-73.139934, Y=41.508265},{X=-73.140619, Y=41.507933},{X=-73.140842, Y=41.507844},{X=-73.140965, Y=41.507785},{X=-73.141175, Y=41.507687},{X=-73.141505, Y=41.507513},{X=-73.141694, Y=41.507408},{X=-73.141725, Y=41.507395},{X=-73.142021, Y=41.507223},{X=-73.143716, Y=41.506232},{X=-73.147197, Y=41.504197},{X=-73.148817, Y=41.50326},{X=-73.149092, Y=41.503105},{X=-73.149699, Y=41.502761},{X=-73.151524, Y=41.501729},{X=-73.151706, Y=41.501625},{X=-73.151995, Y=41.501453},{X=-73.153098, Y=41.500768},{X=-73.153314, Y=41.500635},{X=-73.154246, Y=41.500004},{X=-73.155315, Y=41.499182},{X=-73.156152, Y=41.498503},{X=-73.157029, Y=41.497843},{X=-73.158002, Y=41.497112},{X=-73.158106, Y=41.497042},{X=-73.158303, Y=41.496897},{X=-73.158341, Y=41.496868},{X=-73.158417, Y=41.496809},{X=-73.158649, Y=41.496634},{X=-73.158726, Y=41.496576},{X=-73.158794, Y=41.496523},{X=-73.159001, Y=41.496366},{X=-73.15907, Y=41.496315},{X=-73.159189, Y=41.496191},{X=-73.159377, Y=41.496042},{X=-73.15974, Y=41.495756},{X=-73.160355, Y=41.49529},{X=-73.16043, Y=41.495234},{X=-73.160692, Y=41.495054},{X=-73.16097, Y=41.494863},{X=-73.161016, Y=41.494834},{X=-73.161552, Y=41.494497},{X=-73.162019, Y=41.494222},{X=-73.162357, Y=41.494024},{X=-73.162721, Y=41.493833},{X=-73.163, Y=41.493692},{X=-73.163891, Y=41.493244},{X=-73.164979, Y=41.492796},{X=-73.165024, Y=41.492778},{X=-73.165663, Y=41.492556},{X=-73.167101, Y=41.492004},{X=-73.167356, Y=41.491913},{X=-73.169071, Y=41.491302},{X=-73.170166, Y=41.490874},{X=-73.171345, Y=41.490414},{X=-73.172426, Y=41.490036},{X=-73.172451, Y=41.490026},{X=-73.173856, Y=41.489504},{X=-73.174151, Y=41.4894},{X=-73.174411, Y=41.489296},{X=-73.174987, Y=41.489081},{X=-73.17656, Y=41.488494},{X=-73.177509, Y=41.488163},{X=-73.178355, Y=41.487869},{X=-73.179275, Y=41.487549},{X=-73.180231, Y=41.487199},{X=-73.182901, Y=41.486225},{X=-73.183521, Y=41.485999},{X=-73.185851, Y=41.485164},{X=-73.187727, Y=41.484493},{X=-73.188042, Y=41.48438},{X=-73.188645, Y=41.484164},{X=-73.188988, Y=41.484043},{X=-73.189304, Y=41.483933},{X=-73.190035, Y=41.483677},{X=-73.190409, Y=41.483548},{X=-73.191723, Y=41.483097},{X=-73.193639, Y=41.482466},{X=-73.193738, Y=41.482433},{X=-73.194852, Y=41.482073},{X=-73.19491, Y=41.482054},{X=-73.196152, Y=41.481673},{X=-73.19681, Y=41.481479},{X=-73.197202, Y=41.481365},{X=-73.198887, Y=41.480894},{X=-73.199685, Y=41.480659},{X=-73.201761, Y=41.480107},{X=-73.20273, Y=41.479861},{X=-73.204279, Y=41.479471},{X=-73.204717, Y=41.47937},{X=-73.205123, Y=41.479276},{X=-73.205467, Y=41.479183},{X=-73.207007, Y=41.478772},{X=-73.207704, Y=41.478573},{X=-73.208448, Y=41.478362},{X=-73.209041, Y=41.478131},{X=-73.209535, Y=41.477939},{X=-73.210627, Y=41.477432},{X=-73.210785, Y=41.477355},{X=-73.211049, Y=41.477229},{X=-73.211353, Y=41.477068},{X=-73.211419, Y=41.477032},{X=-73.211621, Y=41.476926},{X=-73.211688, Y=41.476891},{X=-73.212178, Y=41.47661},{X=-73.212464, Y=41.476426},{X=-73.212675, Y=41.476293},{X=-73.213384, Y=41.475816},{X=-73.213891, Y=41.47544},{X=-73.214647, Y=41.474816},{X=-73.214692, Y=41.47478},{X=-73.215138, Y=41.474449},{X=-73.215405, Y=41.474329},{X=-73.215473, Y=41.47427},{X=-73.215644, Y=41.474125},{X=-73.215676, Y=41.47409},{X=-73.215738, Y=41.474024},{X=-73.215905, Y=41.473843},{X=-73.216271, Y=41.473449},{X=-73.216411, Y=41.473306},{X=-73.216584, Y=41.473131},{X=-73.216987, Y=41.472755},{X=-73.217226, Y=41.472515},{X=-73.217683, Y=41.47203},{X=-73.217755, Y=41.471938},{X=-73.218598, Y=41.470884},{X=-73.219132, Y=41.470183},{X=-73.21969, Y=41.469392},{X=-73.220372, Y=41.46831},{X=-73.220681, Y=41.467866},{X=-73.221312, Y=41.466963},{X=-73.221687, Y=41.466533},{X=-73.221777, Y=41.466417},{X=-73.221965, Y=41.466252},{X=-73.22242, Y=41.465854},{X=-73.222873, Y=41.465518},{X=-73.222891, Y=41.465507},{X=-73.223237, Y=41.465312},{X=-73.223266, Y=41.465295},{X=-73.223353, Y=41.465245},{X=-73.223383, Y=41.465229},{X=-73.224237, Y=41.464746},{X=-73.224802, Y=41.464445},{X=-73.226341, Y=41.463627},{X=-73.226395, Y=41.463598},{X=-73.229094, Y=41.462151},{X=-73.230322, Y=41.461494},{X=-73.230517, Y=41.461374},{X=-73.23087, Y=41.461178},{X=-73.231408, Y=41.460871},{X=-73.23167, Y=41.460722},{X=-73.232374, Y=41.46024},{X=-73.232917, Y=41.45983},{X=-73.23384, Y=41.459009},{X=-73.233907, Y=41.45895},{X=-73.234549, Y=41.458271},{X=-73.23495, Y=41.457859},{X=-73.235154, Y=41.457648},{X=-73.23583, Y=41.456957},{X=-73.236182, Y=41.456651},{X=-73.236408, Y=41.456457},{X=-73.236628, Y=41.456288},{X=-73.236692, Y=41.456238},{X=-73.236718, Y=41.456219},{X=-73.236904, Y=41.45613},{X=-73.236983, Y=41.456092},{X=-73.237155, Y=41.455957},{X=-73.23732, Y=41.455851},{X=-73.237604, Y=41.455671},{X=-73.23807, Y=41.455442},{X=-73.238432, Y=41.455301},{X=-73.238883, Y=41.455127},{X=-73.239525, Y=41.4549},{X=-73.240851, Y=41.4544},{X=-73.24109, Y=41.45431},{X=-73.243567, Y=41.453406},{X=-73.245166, Y=41.452741},{X=-73.246176, Y=41.452256},{X=-73.246826, Y=41.451877},{X=-73.247159, Y=41.451657},{X=-73.24775, Y=41.451189},{X=-73.248047, Y=41.450888},{X=-73.248292, Y=41.450573},{X=-73.248391, Y=41.450403},{X=-73.248532, Y=41.4502},{X=-73.248747, Y=41.44988},{X=-73.24907, Y=41.449285},{X=-73.249216, Y=41.449019},{X=-73.249467, Y=41.448483},{X=-73.249627, Y=41.448069},{X=-73.249863, Y=41.447368},{X=-73.250028, Y=41.446492},{X=-73.250122, Y=41.445565},{X=-73.250121, Y=41.445539},{X=-73.2501, Y=41.444809},{X=-73.250038, Y=41.444234},{X=-73.250028, Y=41.444141},{X=-73.250004, Y=41.443912},{X=-73.249994, Y=41.443863},{X=-73.249977, Y=41.443772},{X=-73.249963, Y=41.443701},{X=-73.249921, Y=41.44349},{X=-73.249908, Y=41.44342},{X=-73.249858, Y=41.443168},{X=-73.249743, Y=41.442575},{X=-73.249709, Y=41.442415},{X=-73.249656, Y=41.442165},{X=-73.249647, Y=41.44214},{X=-73.24962, Y=41.442068},{X=-73.249611, Y=41.442044},{X=-73.249604, Y=41.442025},{X=-73.249583, Y=41.441968},{X=-73.249576, Y=41.441949},{X=-73.249481, Y=41.441706},{X=-73.249379, Y=41.441514},{X=-73.248709, Y=41.440249},{X=-73.248697, Y=41.440226},{X=-73.248528, Y=41.43984},{X=-73.248515, Y=41.439814},{X=-73.248427, Y=41.439644},{X=-73.248165, Y=41.439134},{X=-73.248091, Y=41.43899},{X=-73.248078, Y=41.438964}

    Record:4

    [NumPoints:4]{X=-77.007803, Y=39.015817},{X=-77.007565, Y=39.015752},{X=-77.006266, Y=39.015393},{X=-77.006058, Y=39.015336}

    Record:5

    [NumPoints:5]{X=-102.441231, Y=35.246358},{X=-102.442907, Y=35.247032},{X=-102.444171, Y=35.247566},{X=-102.445069, Y=35.24789},{X=-102.445657, Y=35.248021}

    Record:6

    [NumPoints:453]{X=-94.601284, Y=39.187274},{X=-94.601383, Y=39.18733},{X=-94.602832, Y=39.187978},{X=-94.602938, Y=39.188018},{X=-94.603208, Y=39.188118},{X=-94.60359, Y=39.188248},{X=-94.603979, Y=39.188368},{X=-94.604373, Y=39.188476},{X=-94.604656, Y=39.188547},{X=-94.604835, Y=39.188587},{X=-94.604913, Y=39.188605},{X=-94.605049, Y=39.188636},{X=-94.605316, Y=39.188692},{X=-94.605498, Y=39.188724},{X=-94.60558, Y=39.188739},{X=-94.605851, Y=39.188792},{X=-94.606446, Y=39.188909},{X=-94.609723, Y=39.189477},{X=-94.610023, Y=39.189531},{X=-94.610363, Y=39.189598},{X=-94.610667, Y=39.189658},{X=-94.612391, Y=39.189997},{X=-94.612755, Y=39.19008},{X=-94.613341, Y=39.190236},{X=-94.613509, Y=39.190291},{X=-94.613541, Y=39.190301},{X=-94.613726, Y=39.190353},{X=-94.614077, Y=39.190471},{X=-94.614517, Y=39.190638},{X=-94.614804, Y=39.190759},{X=-94.615131, Y=39.190912},{X=-94.615224, Y=39.190955},{X=-94.615656, Y=39.191163},{X=-94.615892, Y=39.191319},{X=-94.616129, Y=39.191483},{X=-94.616358, Y=39.191671},{X=-94.616525, Y=39.191833},{X=-94.616678, Y=39.192003},{X=-94.617052, Y=39.192493},{X=-94.61713, Y=39.192586},{X=-94.617289, Y=39.192794},{X=-94.617434, Y=39.193009},{X=-94.617592, Y=39.193272},{X=-94.617699, Y=39.193438},{X=-94.617963, Y=39.193849},{X=-94.618063, Y=39.194006},{X=-94.618239, Y=39.194223},{X=-94.618325, Y=39.194322},{X=-94.618931, Y=39.19494},{X=-94.619227, Y=39.195196},{X=-94.619261, Y=39.195226},{X=-94.619491, Y=39.195409},{X=-94.619645, Y=39.195524},{X=-94.62055, Y=39.19613},{X=-94.620773, Y=39.196279},{X=-94.622121, Y=39.19718},{X=-94.622923, Y=39.197717},{X=-94.628071, Y=39.201222},{X=-94.631044, Y=39.203211},{X=-94.631545, Y=39.203545},{X=-94.632351, Y=39.204081},{X=-94.632642, Y=39.204285},{X=-94.63293, Y=39.204493},{X=-94.633214, Y=39.204705},{X=-94.633491, Y=39.204921},{X=-94.633765, Y=39.20514},{X=-94.633999, Y=39.205334},{X=-94.634296, Y=39.20559},{X=-94.634554, Y=39.20582},{X=-94.634807, Y=39.206054},{X=-94.635054, Y=39.206291},{X=-94.63517, Y=39.206421},{X=-94.635413, Y=39.206694},{X=-94.636631, Y=39.208072},{X=-94.638607, Y=39.210296},{X=-94.638856, Y=39.210547},{X=-94.639595, Y=39.211401},{X=-94.639916, Y=39.211801},{X=-94.640247, Y=39.212196},{X=-94.640587, Y=39.212587},{X=-94.641097, Y=39.213149},{X=-94.641623, Y=39.213692},{X=-94.645145, Y=39.217691},{X=-94.645352, Y=39.217927},{X=-94.645642, Y=39.218257},{X=-94.649183, Y=39.222255},{X=-94.649314, Y=39.22242},{X=-94.649509, Y=39.222682},{X=-94.649672, Y=39.222921},{X=-94.649824, Y=39.223164},{X=-94.649965, Y=39.223411},{X=-94.650094, Y=39.223662},{X=-94.650213, Y=39.223916},{X=-94.650702, Y=39.225124},{X=-94.651449, Y=39.226965},{X=-94.652035, Y=39.22835},{X=-94.652218, Y=39.228781},{X=-94.652346, Y=39.229053},{X=-94.652486, Y=39.229321},{X=-94.652639, Y=39.229586},{X=-94.652803, Y=39.229846},{X=-94.653027, Y=39.230168},{X=-94.653263, Y=39.230476},{X=-94.65346, Y=39.23071},{X=-94.655142, Y=39.232615},{X=-94.655388, Y=39.232892},{X=-94.655626, Y=39.233163},{X=-94.657042, Y=39.23476},{X=-94.657256, Y=39.235041},{X=-94.657425, Y=39.235283},{X=-94.657582, Y=39.235529},{X=-94.657797, Y=39.235905},{X=-94.657926, Y=39.236161},{X=-94.658044, Y=39.23642},{X=-94.658198, Y=39.236815},{X=-94.658326, Y=39.237215},{X=-94.658396, Y=39.237484},{X=-94.658454, Y=39.237755},{X=-94.658498, Y=39.238019},{X=-94.658533, Y=39.238301},{X=-94.658554, Y=39.238575},{X=-94.65856, Y=39.238712},{X=-94.658558, Y=39.239117},{X=-94.658555, Y=39.239689},{X=-94.658533, Y=39.243958},{X=-94.65853, Y=39.244556},{X=-94.6585, Y=39.246849},{X=-94.658498, Y=39.246979},{X=-94.658495, Y=39.247234},{X=-94.658465, Y=39.248042},{X=-94.658444, Y=39.24863},{X=-94.658449, Y=39.24892},{X=-94.65845, Y=39.250545},{X=-94.65845, Y=39.251019},{X=-94.658426, Y=39.25205},{X=-94.658403, Y=39.253415},{X=-94.658411, Y=39.254153},{X=-94.658411, Y=39.254412},{X=-94.658419, Y=39.254645},{X=-94.658423, Y=39.254782},{X=-94.658445, Y=39.255095},{X=-94.658454, Y=39.255231},{X=-94.658478, Y=39.255461},{X=-94.658538, Y=39.255908},{X=-94.65858, Y=39.256159},{X=-94.658681, Y=39.256659},{X=-94.65874, Y=39.256907},{X=-94.658804, Y=39.257155},{X=-94.65895, Y=39.257648},{X=-94.659136, Y=39.258189},{X=-94.659305, Y=39.25865},{X=-94.65938, Y=39.258843},{X=-94.659598, Y=39.259332},{X=-94.659815, Y=39.259776},{X=-94.659955, Y=39.260047},{X=-94.660055, Y=39.260234},{X=-94.660313, Y=39.260681},{X=-94.660591, Y=39.26112},{X=-94.660738, Y=39.261337},{X=-94.660924, Y=39.2616},{X=-94.663076, Y=39.264549},{X=-94.664661, Y=39.266716},{X=-94.665162, Y=39.267389},{X=-94.666075, Y=39.268615},{X=-94.666842, Y=39.269678},{X=-94.667634, Y=39.270776},{X=-94.669529, Y=39.273375},{X=-94.669616, Y=39.273494},{X=-94.671293, Y=39.275837},{X=-94.671851, Y=39.27659},{X=-94.673918, Y=39.279379},{X=-94.675852, Y=39.282021},{X=-94.677419, Y=39.284159},{X=-94.680057, Y=39.287785},{X=-94.683775, Y=39.29294},{X=-94.68408, Y=39.293363},{X=-94.684309, Y=39.293682},{X=-94.684434, Y=39.2939},{X=-94.684594, Y=39.294179},{X=-94.684738, Y=39.294449},{X=-94.684877, Y=39.294722},{X=-94.685009, Y=39.294996},{X=-94.685255, Y=39.29555},{X=-94.68537, Y=39.295823},{X=-94.685455, Y=39.296039},{X=-94.685543, Y=39.296282},{X=-94.685681, Y=39.296697},{X=-94.685806, Y=39.297139},{X=-94.685862, Y=39.297362},{X=-94.685958, Y=39.297809},{X=-94.686033, Y=39.298259},{X=-94.686136, Y=39.299001},{X=-94.686166, Y=39.29927},{X=-94.686202, Y=39.299659},{X=-94.686207, Y=39.299709},{X=-94.68623, Y=39.300064},{X=-94.686246, Y=39.300419},{X=-94.686254, Y=39.300774},{X=-94.686253, Y=39.302802},{X=-94.686291, Y=39.303404},{X=-94.686343, Y=39.304004},{X=-94.686376, Y=39.304309},{X=-94.686431, Y=39.30478},{X=-94.686486, Y=39.305204},{X=-94.686578, Y=39.305802},{X=-94.686694, Y=39.30645},{X=-94.686898, Y=39.307448},{X=-94.686965, Y=39.307737},{X=-94.687129, Y=39.308358},{X=-94.68722, Y=39.308659},{X=-94.687318, Y=39.308958},{X=-94.687422, Y=39.309257},{X=-94.687533, Y=39.309554},{X=-94.68765, Y=39.309849},{X=-94.688019, Y=39.310692},{X=-94.688111, Y=39.310886},{X=-94.688203, Y=39.311081},{X=-94.688418, Y=39.311501},{X=-94.688624, Y=39.311881},{X=-94.688792, Y=39.312173},{X=-94.688966, Y=39.312463},{X=-94.689147, Y=39.31275},{X=-94.689334, Y=39.313035},{X=-94.689528, Y=39.313317},{X=-94.689994, Y=39.313946},{X=-94.690294, Y=39.314324},{X=-94.690569, Y=39.314656},{X=-94.690852, Y=39.314985},{X=-94.691142, Y=39.31531},{X=-94.691439, Y=39.31563},{X=-94.69202, Y=39.316225},{X=-94.693939, Y=39.318125},{X=-94.694394, Y=39.318568},{X=-94.694712, Y=39.318877},{X=-94.695818, Y=39.319954},{X=-94.695977, Y=39.320109},{X=-94.696289, Y=39.320388},{X=-94.696628, Y=39.32067},{X=-94.696949, Y=39.320919},{X=-94.697297, Y=39.32117},{X=-94.697655, Y=39.321413},{X=-94.697994, Y=39.321626},{X=-94.699902, Y=39.322608},{X=-94.701145, Y=39.323247},{X=-94.703089, Y=39.32425},{X=-94.704586, Y=39.325039},{X=-94.704699, Y=39.325074},{X=-94.705243, Y=39.325359},{X=-94.706976, Y=39.326264},{X=-94.709955, Y=39.32784},{X=-94.711508, Y=39.328658},{X=-94.711568, Y=39.32869},{X=-94.711789, Y=39.328806},{X=-94.712878, Y=39.329378},{X=-94.715115, Y=39.330553},{X=-94.716724, Y=39.33138},{X=-94.720187, Y=39.333225},{X=-94.726264, Y=39.336428},{X=-94.728367, Y=39.337487},{X=-94.728664, Y=39.337627},{X=-94.728968, Y=39.337759},{X=-94.729433, Y=39.337942},{X=-94.729737, Y=39.338048},{X=-94.730072, Y=39.338155},{X=-94.730563, Y=39.338292},{X=-94.730892, Y=39.338371},{X=-94.732955, Y=39.338954},{X=-94.735677, Y=39.339722},{X=-94.736417, Y=39.339938},{X=-94.736698, Y=39.340026},{X=-94.737214, Y=39.340194},{X=-94.737998, Y=39.340472},{X=-94.738131, Y=39.340523},{X=-94.738386, Y=39.340619},{X=-94.738947, Y=39.340844},{X=-94.739527, Y=39.341091},{X=-94.74004, Y=39.341351},{X=-94.740988, Y=39.34183},{X=-94.742114, Y=39.3424},{X=-94.742378, Y=39.342534},{X=-94.742601, Y=39.342647},{X=-94.742877, Y=39.342786},{X=-94.743015, Y=39.342856},{X=-94.743035, Y=39.342866},{X=-94.743127, Y=39.342913},{X=-94.743405, Y=39.343053},{X=-94.743679, Y=39.343192},{X=-94.748082, Y=39.345421},{X=-94.748319, Y=39.345541},{X=-94.748541, Y=39.345659},{X=-94.748872, Y=39.345825},{X=-94.749251, Y=39.346001},{X=-94.749443, Y=39.346086},{X=-94.749834, Y=39.346246},{X=-94.750231, Y=39.346397},{X=-94.750677, Y=39.346549},{X=-94.752881, Y=39.347182},{X=-94.754699, Y=39.347795},{X=-94.755043, Y=39.347949},{X=-94.755354, Y=39.3481},{X=-94.755673, Y=39.348269},{X=-94.755953, Y=39.348428},{X=-94.756241, Y=39.348604},{X=-94.75644, Y=39.348733},{X=-94.756658, Y=39.348882},{X=-94.756943, Y=39.349066},{X=-94.757039, Y=39.349163},{X=-94.757104, Y=39.349221},{X=-94.758528, Y=39.350477},{X=-94.759105, Y=39.350987},{X=-94.759686, Y=39.351441},{X=-94.760459, Y=39.352179},{X=-94.760667, Y=39.352365},{X=-94.760964, Y=39.352633},{X=-94.762067, Y=39.353617},{X=-94.764339, Y=39.355639},{X=-94.764785, Y=39.356037},{X=-94.766385, Y=39.35751},{X=-94.766655, Y=39.357803},{X=-94.766907, Y=39.358088},{X=-94.767117, Y=39.358337},{X=-94.767522, Y=39.358843},{X=-94.767903, Y=39.359359},{X=-94.768085, Y=39.359621},{X=-94.768261, Y=39.359886},{X=-94.768431, Y=39.360152},{X=-94.768595, Y=39.360421},{X=-94.768904, Y=39.360966},{X=-94.769176, Y=39.361546},{X=-94.769565, Y=39.362374},{X=-94.770309, Y=39.36396},{X=-94.770537, Y=39.364446},{X=-94.77112, Y=39.365666},{X=-94.771167, Y=39.365765},{X=-94.772366, Y=39.368272},{X=-94.773689, Y=39.371067},{X=-94.773867, Y=39.371444},{X=-94.774512, Y=39.372808},{X=-94.774665, Y=39.373054},{X=-94.774781, Y=39.373227},{X=-94.774914, Y=39.373416},{X=-94.775094, Y=39.373652},{X=-94.775284, Y=39.373882},{X=-94.775484, Y=39.374107},{X=-94.775803, Y=39.374434},{X=-94.775878, Y=39.374505},{X=-94.776144, Y=39.374748},{X=-94.776383, Y=39.374949},{X=-94.776631, Y=39.375143},{X=-94.776887, Y=39.375331},{X=-94.777043, Y=39.375439},{X=-94.77737, Y=39.375652},{X=-94.777869, Y=39.375957},{X=-94.780556, Y=39.377597},{X=-94.780875, Y=39.37779},{X=-94.784196, Y=39.379799},{X=-94.786016, Y=39.3809},{X=-94.786421, Y=39.381146},{X=-94.786695, Y=39.381377},{X=-94.786789, Y=39.381464},{X=-94.787162, Y=39.381791},{X=-94.787382, Y=39.382002},{X=-94.787602, Y=39.382228},{X=-94.787811, Y=39.382459},{X=-94.787987, Y=39.382665},{X=-94.788394, Y=39.383213},{X=-94.788542, Y=39.383438},{X=-94.788769, Y=39.383824},{X=-94.788906, Y=39.384087},{X=-94.789032, Y=39.384353},{X=-94.789145, Y=39.384622},{X=-94.789246, Y=39.384894},{X=-94.78929, Y=39.385032},{X=-94.789334, Y=39.385168},{X=-94.789424, Y=39.385499},{X=-94.78944, Y=39.385574},{X=-94.789463, Y=39.38568},{X=-94.789502, Y=39.385863},{X=-94.789547, Y=39.386144},{X=-94.789579, Y=39.386426},{X=-94.789598, Y=39.386709},{X=-94.789605, Y=39.386992},{X=-94.789623, Y=39.387624},{X=-94.789611, Y=39.388629},{X=-94.789624, Y=39.391416},{X=-94.789647, Y=39.394467},{X=-94.789668, Y=39.397264},{X=-94.789697, Y=39.401314},{X=-94.789718, Y=39.40479},{X=-94.789819, Y=39.41829},{X=-94.789824, Y=39.418947},{X=-94.789831, Y=39.419819},{X=-94.789857, Y=39.423077},{X=-94.789906, Y=39.42911},{X=-94.789913, Y=39.42946},{X=-94.789915, Y=39.429582},{X=-94.789911, Y=39.430361},{X=-94.789889, Y=39.43114},{X=-94.78985, Y=39.431919},{X=-94.789793, Y=39.432697},{X=-94.789779, Y=39.432947},{X=-94.789769, Y=39.433126},{X=-94.789756, Y=39.433349},{X=-94.789358, Y=39.440278},{X=-94.789351, Y=39.440412},{X=-94.789235, Y=39.442497},{X=-94.788967, Y=39.447294},{X=-94.788946, Y=39.447665},{X=-94.788846, Y=39.449495},{X=-94.788758, Y=39.451095},{X=-94.788718, Y=39.4518},{X=-94.788645, Y=39.453089},{X=-94.788027, Y=39.464793},{X=-94.787956, Y=39.466168},{X=-94.787759, Y=39.46965},{X=-94.787715, Y=39.470404},{X=-94.787662, Y=39.471335},{X=-94.787583, Y=39.472766},{X=-94.78756, Y=39.4731},{X=-94.787472, Y=39.474433},{X=-94.787205, Y=39.478586},{X=-94.787186, Y=39.478915},{X=-94.786895, Y=39.483843},{X=-94.786603, Y=39.488984},{X=-94.786537, Y=39.490243},{X=-94.786342, Y=39.494399},{X=-94.786317, Y=39.494792},{X=-94.7863, Y=39.495186},{X=-94.786292, Y=39.49558},{X=-94.786293, Y=39.495973},{X=-94.786303, Y=39.496367},{X=-94.786322, Y=39.496773},{X=-94.786352, Y=39.497724},{X=-94.786376, Y=39.498551},{X=-94.7864, Y=39.499469},{X=-94.786563, Y=39.505609},{X=-94.786566, Y=39.505681},{X=-94.786672, Y=39.509738},{X=-94.786768, Y=39.510933},{X=-94.78679, Y=39.511433},{X=-94.786803, Y=39.514124},{X=-94.786808, Y=39.514399},{X=-94.786898, Y=39.516523},{X=-94.786901, Y=39.51657},{X=-94.786938, Y=39.517493},{X=-94.786969, Y=39.518525},{X=-94.786976, Y=39.518744},{X=-94.786978, Y=39.518813},{X=-94.787022, Y=39.520827},{X=-94.787091, Y=39.522789},{X=-94.787325, Y=39.530131},{X=-94.787328, Y=39.530275},{X=-94.787345, Y=39.531879}

    Record:7

    [NumPoints:11]{X=-78.754157, Y=35.123068},{X=-78.754438, Y=35.123118},{X=-78.754561, Y=35.123154},{X=-78.755364, Y=35.123475},{X=-78.755508, Y=35.123525},{X=-78.756299, Y=35.123737},{X=-78.756762, Y=35.123871},{X=-78.757404, Y=35.124088},{X=-78.757723, Y=35.124206},{X=-78.75895, Y=35.124715},{X=-78.759478, Y=35.124958}

    Record:8

    [NumPoints:22]{X=-78.920166, Y=34.959679},{X=-78.920276, Y=34.959664},{X=-78.921904, Y=34.958023},{X=-78.922508, Y=34.95738},{X=-78.923369, Y=34.956458},{X=-78.92426, Y=34.95517},{X=-78.924437, Y=34.954896},{X=-78.9251, Y=34.953874},{X=-78.927103, Y=34.950925},{X=-78.928859, Y=34.948207},{X=-78.929756, Y=34.946905},{X=-78.931086, Y=34.944919},{X=-78.931938, Y=34.943591},{X=-78.932444, Y=34.942865},{X=-78.93309, Y=34.941847},{X=-78.933739, Y=34.940871},{X=-78.933872, Y=34.94072},{X=-78.935535, Y=34.938831},{X=-78.937406, Y=34.93669},{X=-78.938786, Y=34.935123},{X=-78.939228, Y=34.934598},{X=-78.939669, Y=34.934122}

    Record:9

    [NumPoints:11]{X=-78.754157, Y=35.123068},{X=-78.754438, Y=35.123118},{X=-78.754561, Y=35.123154},{X=-78.755364, Y=35.123475},{X=-78.755508, Y=35.123525},{X=-78.756299, Y=35.123737},{X=-78.756762, Y=35.123871},{X=-78.757404, Y=35.124088},{X=-78.757723, Y=35.124206},{X=-78.75895, Y=35.124715},{X=-78.759478, Y=35.124958}

    Record:10

    [NumPoints:329]{X=-78.630443, Y=35.247412},{X=-78.631766, Y=35.245091},{X=-78.634166, Y=35.240906},{X=-78.635143, Y=35.239202},{X=-78.637463, Y=35.235125},{X=-78.639768, Y=35.231213},{X=-78.641966, Y=35.227572},{X=-78.64223, Y=35.227135},{X=-78.64235, Y=35.226948},{X=-78.642535, Y=35.226708},{X=-78.642681, Y=35.226519},{X=-78.643074, Y=35.22604},{X=-78.643415, Y=35.225649},{X=-78.643756, Y=35.225275},{X=-78.644171, Y=35.224844},{X=-78.644589, Y=35.224432},{X=-78.644998, Y=35.22405},{X=-78.645408, Y=35.223687},{X=-78.645808, Y=35.223349},{X=-78.646919, Y=35.222395},{X=-78.649437, Y=35.220205},{X=-78.649772, Y=35.219914},{X=-78.652319, Y=35.217746},{X=-78.653235, Y=35.21696},{X=-78.654603, Y=35.215772},{X=-78.655028, Y=35.215403},{X=-78.655661, Y=35.214853},{X=-78.656609, Y=35.21403},{X=-78.658668, Y=35.212255},{X=-78.659576, Y=35.211551},{X=-78.659699, Y=35.211457},{X=-78.663253, Y=35.208329},{X=-78.664346, Y=35.207378},{X=-78.666047, Y=35.205911},{X=-78.66833, Y=35.203955},{X=-78.668913, Y=35.203455},{X=-78.669386, Y=35.20305},{X=-78.67152, Y=35.201221},{X=-78.671929, Y=35.200901},{X=-78.673152, Y=35.199841},{X=-78.674211, Y=35.198922},{X=-78.677295, Y=35.196039},{X=-78.67909, Y=35.194338},{X=-78.680482, Y=35.193036},{X=-78.680867, Y=35.192669},{X=-78.682311, Y=35.19129},{X=-78.685662, Y=35.188142},{X=-78.686243, Y=35.187578},{X=-78.689067, Y=35.184915},{X=-78.693135, Y=35.181058},{X=-78.694072, Y=35.180185},{X=-78.696126, Y=35.178249},{X=-78.697144, Y=35.177283},{X=-78.697674, Y=35.176779},{X=-78.698297, Y=35.176188},{X=-78.701249, Y=35.173384},{X=-78.702331, Y=35.172396},{X=-78.703902, Y=35.170879},{X=-78.706496, Y=35.168447},{X=-78.707931, Y=35.167102},{X=-78.710327, Y=35.164821},{X=-78.71114, Y=35.164063},{X=-78.712347, Y=35.162895},{X=-78.713727, Y=35.161603},{X=-78.715813, Y=35.159652},{X=-78.716203, Y=35.159287},{X=-78.716361, Y=35.159139},{X=-78.71674, Y=35.158785},{X=-78.719152, Y=35.156529},{X=-78.72281, Y=35.153088},{X=-78.724773, Y=35.151242},{X=-78.724804, Y=35.151211},{X=-78.729463, Y=35.146796},{X=-78.729901, Y=35.146381},{X=-78.731659, Y=35.144714},{X=-78.732277, Y=35.144128},{X=-78.732523, Y=35.143895},{X=-78.735027, Y=35.141521},{X=-78.73541, Y=35.141158},{X=-78.738471, Y=35.138198},{X=-78.741906, Y=35.134981},{X=-78.74283, Y=35.134115},{X=-78.743955, Y=35.133053},{X=-78.747409, Y=35.12979},{X=-78.749762, Y=35.127562},{X=-78.749889, Y=35.127443},{X=-78.750049, Y=35.127291},{X=-78.750891, Y=35.126494},{X=-78.751283, Y=35.12611},{X=-78.752184, Y=35.12523},{X=-78.754355, Y=35.123196},{X=-78.754438, Y=35.123118},{X=-78.754546, Y=35.123017},{X=-78.755466, Y=35.122155},{X=-78.757091, Y=35.120632},{X=-78.758009, Y=35.11976},{X=-78.759868, Y=35.117995},{X=-78.761798, Y=35.116163},{X=-78.762398, Y=35.115593},{X=-78.765189, Y=35.113015},{X=-78.766123, Y=35.112081},{X=-78.766396, Y=35.111785},{X=-78.766655, Y=35.111482},{X=-78.766901, Y=35.11117},{X=-78.767123, Y=35.110863},{X=-78.767331, Y=35.11055},{X=-78.767415, Y=35.110415},{X=-78.770061, Y=35.106581},{X=-78.770601, Y=35.105839},{X=-78.773258, Y=35.102022},{X=-78.775057, Y=35.099399},{X=-78.775132, Y=35.099291},{X=-78.775788, Y=35.098351},{X=-78.776117, Y=35.097879},{X=-78.777499, Y=35.095899},{X=-78.778431, Y=35.094563},{X=-78.778903, Y=35.093932},{X=-78.78002, Y=35.092656},{X=-78.779947, Y=35.092678},{X=-78.78017, Y=35.092394},{X=-78.780346, Y=35.092211},{X=-78.780941, Y=35.091568},{X=-78.781823, Y=35.090692},{X=-78.782203, Y=35.090267},{X=-78.782406, Y=35.090059},{X=-78.783465, Y=35.088656},{X=-78.783575, Y=35.08851},{X=-78.785074, Y=35.086222},{X=-78.785353, Y=35.085796},{X=-78.786938, Y=35.08294},{X=-78.787229, Y=35.082415},{X=-78.787882, Y=35.081309},{X=-78.788332, Y=35.080547},{X=-78.788775, Y=35.079702},{X=-78.789085, Y=35.079171},{X=-78.789333, Y=35.078716},{X=-78.789673, Y=35.078108},{X=-78.789858, Y=35.077762},{X=-78.790012, Y=35.077476},{X=-78.790377, Y=35.076699},{X=-78.7907, Y=35.075936},{X=-78.790993, Y=35.075185},{X=-78.791565, Y=35.073761},{X=-78.79183, Y=35.072999},{X=-78.792063, Y=35.072168},{X=-78.792952, Y=35.068777},{X=-78.794211, Y=35.063615},{X=-78.794427, Y=35.062703},{X=-78.794737, Y=35.061405},{X=-78.794941, Y=35.060756},{X=-78.795405, Y=35.059357},{X=-78.79559, Y=35.058959},{X=-78.795692, Y=35.058741},{X=-78.796002, Y=35.058118},{X=-78.796297, Y=35.057564},{X=-78.796633, Y=35.056966},{X=-78.796749, Y=35.056773},{X=-78.797063, Y=35.056251},{X=-78.797356, Y=35.055854},{X=-78.797829, Y=35.055109},{X=-78.798996, Y=35.053629},{X=-78.799313, Y=35.053227},{X=-78.799957, Y=35.052364},{X=-78.800307, Y=35.051805},{X=-78.801108, Y=35.050353},{X=-78.801597, Y=35.049316},{X=-78.801772, Y=35.048805},{X=-78.801967, Y=35.04831},{X=-78.802125, Y=35.047799},{X=-78.8023, Y=35.047256},{X=-78.802476, Y=35.046729},{X=-78.80264, Y=35.046194},{X=-78.80279, Y=35.045707},{X=-78.803064, Y=35.044749},{X=-78.80324, Y=35.044286},{X=-78.803525, Y=35.043404},{X=-78.803655, Y=35.042997},{X=-78.803743, Y=35.042719},{X=-78.803906, Y=35.04221},{X=-78.804654, Y=35.039805},{X=-78.805933, Y=35.035692},{X=-78.806164, Y=35.034849},{X=-78.806229, Y=35.03461},{X=-78.80727, Y=35.030808},{X=-78.807737, Y=35.029331},{X=-78.808565, Y=35.02661},{X=-78.808676, Y=35.026261},{X=-78.808864, Y=35.02576},{X=-78.809122, Y=35.025099},{X=-78.809348, Y=35.024624},{X=-78.809951, Y=35.023305},{X=-78.810575, Y=35.022284},{X=-78.811055, Y=35.021546},{X=-78.811539, Y=35.0209},{X=-78.811757, Y=35.020609},{X=-78.812815, Y=35.01938},{X=-78.813672, Y=35.018503},{X=-78.814255, Y=35.017817},{X=-78.815541, Y=35.016222},{X=-78.816653, Y=35.014704},{X=-78.816765, Y=35.014565},{X=-78.817265, Y=35.013804},{X=-78.818251, Y=35.012123},{X=-78.818472, Y=35.01171},{X=-78.818708, Y=35.011269},{X=-78.818808, Y=35.011082},{X=-78.820678, Y=35.00768},{X=-78.820828, Y=35.007408},{X=-78.820874, Y=35.007325},{X=-78.821025, Y=35.007096},{X=-78.822265, Y=35.005222},{X=-78.822843, Y=35.004423},{X=-78.823262, Y=35.00395},{X=-78.823602, Y=35.003513},{X=-78.823942, Y=35.003161},{X=-78.824327, Y=35.002752},{X=-78.824551, Y=35.002498},{X=-78.824983, Y=35.00201},{X=-78.825233, Y=35.00174},{X=-78.825311, Y=35.001662},{X=-78.825585, Y=35.001387},{X=-78.825798, Y=35.001174},{X=-78.826523, Y=35.000497},{X=-78.827281, Y=34.999819},{X=-78.828108, Y=34.999142},{X=-78.829302, Y=34.998119},{X=-78.830257, Y=34.997299},{X=-78.831367, Y=34.996348},{X=-78.831582, Y=34.996149},{X=-78.832028, Y=34.995737},{X=-78.832974, Y=34.994863},{X=-78.83585, Y=34.99205},{X=-78.836659, Y=34.99124},{X=-78.838005, Y=34.989811},{X=-78.841838, Y=34.985901},{X=-78.842167, Y=34.985609},{X=-78.842559, Y=34.985289},{X=-78.842853, Y=34.985066},{X=-78.843154, Y=34.984849},{X=-78.843504, Y=34.984614},{X=-78.843889, Y=34.984373},{X=-78.844243, Y=34.984167},{X=-78.844647, Y=34.983948},{X=-78.844947, Y=34.983797},{X=-78.847548, Y=34.982621},{X=-78.848229, Y=34.982313},{X=-78.848355, Y=34.982256},{X=-78.848681, Y=34.982108},{X=-78.85124, Y=34.980894},{X=-78.851428, Y=34.980787},{X=-78.85209, Y=34.980412},{X=-78.852173, Y=34.980365},{X=-78.853058, Y=34.979824},{X=-78.85396, Y=34.979256},{X=-78.854433, Y=34.978929},{X=-78.85626, Y=34.977669},{X=-78.856585, Y=34.977443},{X=-78.857292, Y=34.976951},{X=-78.857475, Y=34.976824},{X=-78.857846, Y=34.976582},{X=-78.859018, Y=34.97579},{X=-78.860057, Y=34.975167},{X=-78.860911, Y=34.974695},{X=-78.861795, Y=34.974254},{X=-78.862657, Y=34.973849},{X=-78.864175, Y=34.973245},{X=-78.865159, Y=34.972934},{X=-78.867622, Y=34.972197},{X=-78.871503, Y=34.971142},{X=-78.872644, Y=34.970825},{X=-78.873789, Y=34.970511},{X=-78.876483, Y=34.969771},{X=-78.877401, Y=34.969537},{X=-78.878831, Y=34.969067},{X=-78.879974, Y=34.968616},{X=-78.880933, Y=34.968163},{X=-78.88133, Y=34.967976},{X=-78.882534, Y=34.96736},{X=-78.883725, Y=34.966655},{X=-78.886008, Y=34.965032},{X=-78.887224, Y=34.96412},{X=-78.889606, Y=34.962062},{X=-78.893867, Y=34.958381},{X=-78.894082, Y=34.958195},{X=-78.895945, Y=34.956579},{X=-78.898282, Y=34.954553},{X=-78.904005, Y=34.949686},{X=-78.906482, Y=34.947545},{X=-78.90722, Y=34.947006},{X=-78.907916, Y=34.946501},{X=-78.908774, Y=34.945878},{X=-78.910968, Y=34.944315},{X=-78.912119, Y=34.94354},{X=-78.91348, Y=34.942723},{X=-78.915521, Y=34.941562},{X=-78.916347, Y=34.94114},{X=-78.917178, Y=34.940716},{X=-78.919567, Y=34.939684},{X=-78.920573, Y=34.939267},{X=-78.922779, Y=34.93842},{X=-78.926878, Y=34.936846},{X=-78.927429, Y=34.936634},{X=-78.931386, Y=34.935077},{X=-78.934511, Y=34.93392},{X=-78.935464, Y=34.933389},{X=-78.936324, Y=34.932858},{X=-78.937508, Y=34.932083},{X=-78.937991, Y=34.931704},{X=-78.93822, Y=34.931524},{X=-78.938359, Y=34.931408},{X=-78.938638, Y=34.931176},{X=-78.940146, Y=34.929515},{X=-78.94098, Y=34.928342},{X=-78.942029, Y=34.926926},{X=-78.942098, Y=34.926838},{X=-78.942193, Y=34.926717},{X=-78.943645, Y=34.924867},{X=-78.944452, Y=34.923959},{X=-78.944861, Y=34.923493},{X=-78.94523, Y=34.923072},{X=-78.945989, Y=34.92223},{X=-78.946604, Y=34.921526},{X=-78.947569, Y=34.920461},{X=-78.9501, Y=34.917756},{X=-78.951275, Y=34.916468},{X=-78.951913, Y=34.915686},{X=-78.95274, Y=34.914646},{X=-78.95349, Y=34.913573},{X=-78.954391, Y=34.912125}

  • SSIS can't handle files like these. You'll need a script component to parse it.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • The SSIS Script Component would probably be the best way to go, but in my experience it is also one of the more difficult SSIS features to get a handle on.

    The other solution would be to import the file as is into a SQL table and use a SQL script to parse it into temp table(s)and insert the final results into your destination table. The script below creates a splitter function which can be used like this:

    SELECT * FROM dbo.split_delimited_string(@s,'},')

    where @s-2 is the string of coordinates. It will yield these results:

    [NumPoints:66]{X=-86.971284, Y=36.369636

    {X=-86.971365, Y=36.369658

    {X=-86.97202, Y=36.369832

    {X=-86.973135, Y=36.370131

    {X=-86.975785, Y=36.370845

    {X=-86.976626, Y=36.371075

    .. . . . . .

    which you could then further split, etc. I haven't thought this out thru completion, but hopefully you get the idea. Good luck!

    CREATE FUNCTION [dbo].[split_delimited_string]

    (

    @STR NVARCHAR(MAX),

    @sep NVARCHAR(MAX)

    )

    RETURNS @value TABLE (Value NVARCHAR(MAX))

    AS

    BEGIN

    DECLARE @xml XML

    SELECT @xml = CONVERT(XML,'<r>' + REPLACE(@str,@sep,'</r><r>') + '</r>')

    INSERT INTO @value(Value)

    SELECT t.value('.','NVARCHAR(MAX)')

    FROM @xml.nodes('/r') AS x(t)

    RETURN;

    END

  • Thanks for all the tips gang!

    Atleast I have a clue now,

    Frank

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply