Plotting on MapInfo given edge geometry in row?

Question

I have a file of road geometry of the Washington State downloaded from GIS cup 2012. Each row in the file is of the type, 5,service,15.9316766209136,47.2981713,-122.2481928,47.2981800,-122.2482596,47.2981866,-122.2483008,47.2981947,-122.2483457,47.2981996,-122.2483712,47.2982065,-122.2483972" which is basically road id, road type, length in meters and then latitude and longitude of each point on the road edge.

How to plot this in MapInfo and, if opening in excel, how do I separate each line segment of the above polyline?

Example to :

Row 1: 5,service,15.9316766209136,47.2981713,-122.2481928,47.2981800,-122.2482596
Row 2: 5,service,15.9316766209136,47.2981800,-122.2482596,47.2981866,-122.2483008
Row 3: 5,service,15.9316766209136,47.2981866,-122.2483008,47.2981947,-122.2483457
Row 4: 5,service,15.9316766209136,47.2981947,-122.2483457,47.2981996,-122.2483712
Row 5: 5,service,15.9316766209136,47.2981996,-122.2483712,47.2982065,-122.2483972

Answer 1

Depending on what format the data file is in, I would ask on an MS Office or Excel forum regarding splitting the data into each line segment in Excel.

Once you have split the data into segments (make sure there is a unique identifier for each polyline) and loaded the file into MapInfo you can follow the instructions here http://testdrive.mapinfo.com/techsupp/miprod.nsf/kbase_by_product/704C383D587B1F848525654D006DA6E3 to create lines from your data.

Now you've got a bunch of individual line segments for each polyline you can use Table > Combine Objects using Column..., specifying the unique identifying column and checking the data aggregation settings to ensure you carry over the data correctly, to combine your line objects into polyline objects.

Probably best to do the combine into a new table.