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.649783386TO 01012d1d003b2d1d0d0000000001000080ded0e3bd188098bb97e013003130310d040000c0050190d9493141a062da26da214841c0050190d9493141a062da26da2148410000000000408fc00000000000408fc03130300000040d413149d9900105c0414821da26da62a0413149d9900105c0414821da26da62a0c08f400000000000c08f400000000000

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.

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?

Knowing it is DB2 helps. All databases with native spatial types include a range of geometry constructors that support common spatial data interchange formats, e.g., WKT, WKB, maybe GeoJSON, maybe GML, etc.... You should not have to generate the native spatial blob itself, simply pass one of the common spatial data interchange formats to the DBMS geometry constructor. See ST_Geometry function - DB2 - IBM Knowledge Center .

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Convert Lat/Longs to Blob/Shape-thing

EricThomas3

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

01012d1d003b2d1d0d0000000001000080ded0e3bd188098bb97e013003130310d040000c0050190d9493141a062da26da214841c0050190d9493141a062da26da2148410000000000408fc00000000000408fc03130300000040d413149d9900105c0414821da26da62a0413149d9900105c0414821da26da62a0c08f400000000000c08f400000000000

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

EricThomas2

Hi Joshua,

Do you know what the long hex string represents?

Is it a "spatial data structure"?

If so, where are these referred to in the ESRI docs?

JoshuaBixby

For starters, 35.649... isn't a complete coordinate, it is just a number. I have a hard time believing that long hex string is the direct translation of 35.649.... But beyond that, I am not going to start guessing spatial data structures. Your GIS guy really just needs to tell you what it is, and if he can't then he isn't really a GIS guy.

EricThomas2

Hi Joshua Bixby‌, thanks for the quick reply.
Yes, only points.

As far as I know, we work with whatever format this thing is:

Do you have any details on what exactly this is?

JoshuaBixby

I really hope some of the terminology from your "GIS guy" was lost in translation and that he isn't saying "blob/shape" because that is sufficiently vague to mean many things and nothing. Ask your GIS guy what spatial format, specifically, he can work with if not text-based coordinates. Also, are you just working with points?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.