Select to view content in your preferred language

Convert Lat/Longs to Blob/Shape-thing

2757
11
08-09-2019 12:32 PM
EricThomas3
Emerging Contributor

I'm trying to POST lat/longs to a database that feeds Portal. My GIS guy says I need to convert the lat/longs to a "Blob/Shape" as shown below. 

1. What is this Blob/Shape-thing?

2. How do I programmatically convert Latitude and Longitudes to this Blob/Shape-thing WITHOUT using ArcGIS desktop or Python?

Is there an API / service somewhere that does this?

Thank you


Example:

Convert FROM

35.649783386

TO 

01012d1d003b2d1d0d0000000001000080ded0e3bd188098bb97e013003130310d040000c0050190d9493141a062da26da214841c0050190d9493141a062da26da2148410000000000408fc00000000000408fc03130300000040d413149d9900105c0414821da26da62a0413149d9900105c0414821da26da62a0c08f400000000000c08f400000000000
0 Kudos
11 Replies
EricThomas3
Emerging Contributor

Thanks for the continued guidance. 

Reading through the docs provided, I'm still unclear on how I would POST Lat/Long pairs as "...one of the common spatial data interchange formats to the DBMS geometry constructor". 

Example:

  • The DB2 database has a REST web service that I can POST data to
  • LocID: 1234
  • Lat: 47.123
  • Long: -122.345
  • etc.

What happens when I get to this ST_Geometry-type column? 

What do I feed it?

Is it a calculated column based on the Lat/Long columns?

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

If the DB2 database has a REST web service where you can post Lat/Long, and you are working with Points, what is the issue?  The REST service should take the Lat/Long and convert it to the appropriate native spatial type on the backend.

0 Kudos