TransWikia.com

Displaying in-database image on the map with ArcGIS

Geographic Information Systems Asked on January 18, 2021

I have an SQL database that contains a table with a coordinate, as well as a blob that contains an image associated with that location, as well as other columns expressing the width and height (in mm) of the area represented by the image.

I’m trying to have these images displayed at their location on a map.

I have been able to connect ArcGIS to my database and add the table to the map, so right now, ArcGIS displays a point ("single symbol") at the coordinates it extracted from the table.

But I’d want it to display the image from the blob column instead, like I accomplished easily with QGIS.

In QGIS, it was as simple as:

  • creating a layer from that database table.
  • add a "raster image marker" (with "'base64:'||to_base64(attribute('LayoutImage'))" as the expression)
  • set the "Width" to point to my "Width" column and select "milimeters" as the scale.

Done. All images display properly on the map.

But how to do that with ArcGIS Pro?

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP