topic Googlesheets CSV auto-update polylines to ESRI Online Maps in Forestry Questions https://community.esri.com/t5/forestry-questions/googlesheets-csv-auto-update-polylines-to-esri/m-p/754022#M27 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have been trying to solve this question now for sometime with little luck. I have been able to establish a ESRI online map that auto-updates from a CSV spreadsheet within Google Sheets. The data that is auto-updating is point data with associated tabular data that will change over time, the spatial data will likely remain the same.&nbsp;</P><P></P><P>The issue lies in establishing polyline data in a CSV Google sheets file. I associated tabular data with points to test out the process, which has been shown to work. Now I need to have each row in the CSV to have the spatial information to form a polyline, as opposed to the lat and lon, which is required to draw a point in ESRI online.</P><P></P><P>Is there some sort of Arc tool that can take all the vertexes within a polyline, and establish those as functional lat and lon within a row of a CSV or shapefile field for drawing that polyline within ESRI online. I have seen various coding solutions on the web, which I am not sure would actually address the goal I am trying to achieve.&nbsp;</P><P></P><P>Any advice would be greatly appreciated!</P><P></P><P>Best Regards,</P><P>Evan</P></BODY></HTML> Wed, 14 Feb 2018 19:20:05 GMT EvanMorgan2 2018-02-14T19:20:05Z Googlesheets CSV auto-update polylines to ESRI Online Maps https://community.esri.com/t5/forestry-questions/googlesheets-csv-auto-update-polylines-to-esri/m-p/754022#M27 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have been trying to solve this question now for sometime with little luck. I have been able to establish a ESRI online map that auto-updates from a CSV spreadsheet within Google Sheets. The data that is auto-updating is point data with associated tabular data that will change over time, the spatial data will likely remain the same.&nbsp;</P><P></P><P>The issue lies in establishing polyline data in a CSV Google sheets file. I associated tabular data with points to test out the process, which has been shown to work. Now I need to have each row in the CSV to have the spatial information to form a polyline, as opposed to the lat and lon, which is required to draw a point in ESRI online.</P><P></P><P>Is there some sort of Arc tool that can take all the vertexes within a polyline, and establish those as functional lat and lon within a row of a CSV or shapefile field for drawing that polyline within ESRI online. I have seen various coding solutions on the web, which I am not sure would actually address the goal I am trying to achieve.&nbsp;</P><P></P><P>Any advice would be greatly appreciated!</P><P></P><P>Best Regards,</P><P>Evan</P></BODY></HTML> Wed, 14 Feb 2018 19:20:05 GMT https://community.esri.com/t5/forestry-questions/googlesheets-csv-auto-update-polylines-to-esri/m-p/754022#M27 EvanMorgan2 2018-02-14T19:20:05Z