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.

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_path=84daf47

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