Convert Google Long Lat Strings into line work

Question

We have a third party product for a permitting process that currently allows the applicant to add line work via a GoogleMap application. The line work LAT and LONG data is stored in a table in a single column (one for lat one for long) that is vertical bar delimited.

Any thoughts on how to process this data into our SDE? I can provide more information, but am lost as how to start this.

First Latitude

First Long

Latitude String

Longitude String44.86265251

-93.34430695

44.862652507372346|44.863808394490455|44.863838812259104|44.862835017407576

-93.34430694580078|-93.3444356918335|-93.34125995635986|-93.3413028717041

The first lat and long are a point, the strings are the line work.

XanderBakker · Answer

To show you a snippet of Python code to translate the lat and lon strings into a polyline, see the example below. I converted the data that you posted into a table in a fgdb to allow easy manipulation: ... and converted the strings into a line: Code used: def main(): import arcpy tbl = r'C:\GeoNet\LatLonString\data.gdb\LatLonData' fld_lat = 'LatitudeString' fld_lon = 'LongitudeString' sr = arcpy.SpatialReference(4326) # WGS 1984 fc_out = r'C:\GeoNet\LatLonString\data.gdb\lines' feats = [] flds = (fld_lat, fld_lon) with arcpy.da.SearchCursor(tbl, flds) as curs: for row in curs: lat_string = row[0] lon_string = row[1] lst_lat_txt = lat_string.split('|') lst_lon_txt = lon_string.split('|') if len(lst_lat_txt) == len(lst_lon_txt): pnts = [] for i in range(len(lst_lat_txt)): lat = float(lst_lat_txt[i]) lon = float(lst_lon_txt[i]) pnt = arcpy.Point(lon, lat) pnts.append(pnt) polyline = arcpy.Polyline(arcpy.Array(pnts), sr) feats.append(polyline) arcpy.CopyFeatures_management(feats, fc_out) if __name__ == '__main__': main()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

CharlesGerk · Answer

Thank you everyone for the quick responses! I will attempt at some point next week and report back!

Thank you all so much.

ThomasColson · Answer

Since you mention you're using SDE, this is really easy: STGeomFromText (geometry Data Type) | Microsoft Docs

Do that on a stand-alone table, then import the geography column into a new feature class. For updates, just write a trigger that will pass new geography from your standalone table to the SDE table.