AnsweredAssumed Answered

How can I convert lat/long pairs to SDEBinary?

Question asked by sanders0492 on Feb 15, 2018
Latest reply on Feb 19, 2018 by bixb0012

How can I convert lat/long pairs to SDEBinary using Python?


I was tasked with migrating data from one database (DatabaseA) to another (DatabaseB). DatabaseB and DatabaseA are formatted completely differently. DatabaseA represents everything using lat/long pairs, while DatabaseB uses SDEBinary to represent geodata.


I am working on a Python script to pull data from DatabaseA and insert it directly into DatabaseB using SQL. How can I convert the lat/longs on-the-fly into SDEBinary?


The link below is helpful in understanding how values are represented using Esri Binary spatial type (SDEBinary) but I hope to avoid writing a comprehensive conversion module for such a simple task.


Thanks in advance for any help!