topic Re: Efficiently create Polyline in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/efficiently-create-polyline/m-p/447758#M12153 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for your advice on IGeometryBridge2, I dind't use the method you suggested: I found more efficient IGeometryBridge2.SetWKSPoints: the performance boost was awesome</SPAN></BODY></HTML> Thu, 22 Jul 2010 08:32:16 GMT deleted-user-pYdfRjvSAbTJ 2010-07-22T08:32:16Z Efficiently create Polyline https://community.esri.com/t5/arcobjects-sdk-questions/efficiently-create-polyline/m-p/447756#M12151 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><SPAN>I have a huge SQL Server table with 210 millions of rows (yes... millions, 10 GB of disk space): recorded GPS positions with lat/lon.</SPAN><BR /><SPAN>every row as a foreign key that refers to a field track (425.000 tracks), so every track has thousands of GPS points that defines its geometry (a polyline).</SPAN><BR /><SPAN>I have to import all this data in a geodatabase file with a procedure in ArcGIS Desktop.</SPAN><BR /><SPAN>the real problem that is very time consuming is the Polyline creation starting from a List of double pair (lat and lon). </SPAN><BR /><SPAN>I found only a way: create a PolylineClass, cast it to IPointCollection, then, for every lat/lon pair, create a PointClass and adding it to the IPointCollection.</SPAN><BR /><SPAN>computation time in this way is literally dramatic.</SPAN><BR /><SPAN>Is there a way to efficiently create a Polyline starting from a huge number of double pairs?</SPAN></BODY></HTML> Wed, 21 Jul 2010 15:26:59 GMT https://community.esri.com/t5/arcobjects-sdk-questions/efficiently-create-polyline/m-p/447756#M12151 deleted-user-pYdfRjvSAbTJ 2010-07-21T15:26:59Z Re: Efficiently create Polyline https://community.esri.com/t5/arcobjects-sdk-questions/efficiently-create-polyline/m-p/447757#M12152 <HTML><HEAD></HEAD><BODY><SPAN>Maybe try IGeometryBridge2.InsertPoints (or AddWKSPoints).</SPAN></BODY></HTML> Wed, 21 Jul 2010 15:29:18 GMT https://community.esri.com/t5/arcobjects-sdk-questions/efficiently-create-polyline/m-p/447757#M12152 KirkKuykendall 2010-07-21T15:29:18Z Re: Efficiently create Polyline https://community.esri.com/t5/arcobjects-sdk-questions/efficiently-create-polyline/m-p/447758#M12153 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for your advice on IGeometryBridge2, I dind't use the method you suggested: I found more efficient IGeometryBridge2.SetWKSPoints: the performance boost was awesome</SPAN></BODY></HTML> Thu, 22 Jul 2010 08:32:16 GMT https://community.esri.com/t5/arcobjects-sdk-questions/efficiently-create-polyline/m-p/447758#M12153 deleted-user-pYdfRjvSAbTJ 2010-07-22T08:32:16Z