Automatic dot-to-dot

[PaulLewis]

Just wondering if there is an appetite to be able to automatically create a linear feature (in my case the line of a pipe) from breadcrumb data collected?
I have a .xlsx file with pipeline inspection data that I can manually turn in to a pipeline feature on ArcGIS by manually joining the dots, but there a hundreds of points to join. In my case I want to use all the girth weld locations to fix the shape and location of the pipeline.
It's be fantastic if there was an ability to  click 'select all' on the field you want to use and ArcGIS Online does the rest.
Also it'd be even better if there was a way to smooth out the line in the event there was an errant reading, or the ability to remove that from the feature layer.

[JasonBennett]

[REMOVED]

[DavidPike]

If you don't have access to any desktop GIS, you can likely find an online tool to convert the coordinates into Shapefile, GeoJSON or KML tracks (probably the easiest).  Obviously beware of the data you're sharing and apply common sense if  the website doesn't seem legitimate.

[PaulLewis]

@DavidPike It's an interesting option, but we can't push our data on to another site due to security. 

Just wonder how much effort it is to create a tool within the ArcGIS online environment to do this...

[DavidPike]

I had a look at the GeoJSON spec and it looks fairly simple.  Same for KML.

#GeoJSON

{ "type": "FeatureCollection",
  "features": [
    { "type": "Feature",
      "geometry": {
        "type": "LineString",
        "coordinates": [
          [102.0, 0.0], [103.0, 1.0], [104.0, 0.0], [105.0, 1.0]
          ]
        },
      "properties": {
        "prop0": "value0",
        "prop1": 0.0
        }
      }
    ]
  }

For GeoJSON could have a python script or powershell or various to populate what is essentially just a list of coordinates in order.  Save it then upload to ArcGIS Online.

https://gist.github.com/wavded/1200773?short_path=99c1af9

https://github.com/openlayers/openlayers/blob/main/examples/data/geojson/roads-seoul.geojson?short_p...

https://developers.google.com/kml/documentation/kml_tut#paths