AnsweredAssumed Answered

Convert Google Long Lat Strings into line work

Question asked by cgerk_edinagis on Mar 29, 2018
Latest reply on Mar 29, 2018 by xander_bakker

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 String
44.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.

Outcomes