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.

http://edndoc.esri.com/arcsde/9.2/concepts/geometry/representations/compressed.htm#Physical

 

Thanks in advance for any help!

Outcomes