idea Automatic dot-to-dot in ArcGIS Online Ideas

Automatic dot-to-dot

PaulLewis — Mon, 24 Feb 2025 16:10:16 GMT

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.

Re: Automatic dot-to-dot

JasonBennett — Mon, 24 Feb 2025 16:36:58 GMT

[REMOVED]

Re: Automatic dot-to-dot

DavidPike — Mon, 24 Feb 2025 23:27:22 GMT

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.

Re: Automatic dot-to-dot

PaulLewis — Tue, 25 Feb 2025 10:03:41 GMT

@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...

Re: Automatic dot-to-dot

DavidPike — Tue, 25 Feb 2025 16:05:52 GMT

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