topic Re: Can you import multiple geocoded png files as point symbols? in ArcGIS Pro Questions

Can you import multiple geocoded png files as point symbols?

DavidZiegler — Wed, 17 Nov 2021 14:12:59 GMT

I have a hundreds of company logo png files that I am trying to batch import as point symbols. I haven't had much luck batch importing them to XY points (seems you have to do it individually...way too many for this).

However, could one geocode (associated XY coords) with the png files (via some software, or other) and then import them as point symbols?

Re: Can you import multiple geocoded png files as point symbols?

JoeBorgione — Wed, 17 Nov 2021 15:24:48 GMT

How wide-spread geographically are you points? You could georeference the images if you can figure out ground truth monuments. Do this images have some sort of xy notation?

Re: Can you import multiple geocoded png files as point symbols?

DavidZiegler — Wed, 17 Nov 2021 23:58:42 GMT

Joe, I have found programs that can assign lat-long (i.e. from an excel sheet with XY and png file columns) to each png file.

Re: Can you import multiple geocoded png files as point symbols?

JohannesLindner — Thu, 18 Nov 2021 07:44:45 GMT

You could assign geotags to the logos and run GeotaggedPhotosToPoints, creating an attachment tables from the logos and then symbolize the points with the attachments (see last point of the list below).

This might be simpler and can be done completely in ArcGIS:

Input: Table (Excel/CSV/etc) with X, Y, LogoPath
import table into ArcGIS Pro
right-click on the table -> Display XY Data -> save as point feature class
add field LogoData (BLOB)
read the logos into the feature class with this python script (run in ArcGIS Pro Python window)

with arcpy.da.UpdateCursor("NameOfLogoLayer", ["LogoPath", "LogoData"]) as cursor: for row in cursor: with open(row[0], "rb") as f: cursor.updateRow([row[0], f.read()])

symbolize the layer
- Single Symbol
- Allow symbol property connections
- Picture Marker, map File to LogoData, set size

Result:

Re: Can you import multiple geocoded png files as point symbols?

DavidZiegler — Wed, 08 Dec 2021 01:02:40 GMT

I am going to try this. Thanks for providing this--I hope it works. I may come back to ask you questions.

Re: Can you import multiple geocoded png files as point symbols?

DavidZiegler — Wed, 08 Dec 2021 01:05:37 GMT

add field LogoData (BLOB)

[Johannes, what does this mean?]

Re: Can you import multiple geocoded png files as point symbols?

JohannesLindner — Wed, 08 Dec 2021 08:43:52 GMT

@DavidZiegler Create a new field in the point feature class with the name "LogoData" and the field type BLOB (Binary Large OBject).

Fields of this type can store byte data, so everything you can think of. Images, PDFs, Excel, Word, music, video, etc.

We're going to use it to store the logo files directly in the feature class.

Re: Can you import multiple geocoded png files as point symbols?

DavidZiegler — Wed, 08 Dec 2021 14:52:27 GMT

Johannes,

I put the code verbatim into the Python script window (found in analysis); but, how do I run it? I don't see a go, or run.

Re: Can you import multiple geocoded png files as point symbols?

JohannesLindner — Wed, 08 Dec 2021 14:57:40 GMT

Change NameOfLogoLayer to the actual name of the logo layer (or the path to the feature class).

To run, skip to the end of the code and press enter.

Re: Can you import multiple geocoded png files as point symbols?

DavidZiegler — Wed, 08 Dec 2021 15:11:24 GMT

Does the Python need to be activated?

Re: Can you import multiple geocoded png files as point symbols?

DavidZiegler — Wed, 08 Dec 2021 19:07:16 GMT

Johannes: Sent you a direct message with attachment.

Re: Can you import multiple geocoded png files as point symbols?

DavidZiegler — Fri, 10 Dec 2021 14:17:50 GMT

Johannes: Sent another attachment, with code--the code ran this time, but got an error. Screen capture is in private message. Again, many thanks.

Re: Can you import multiple geocoded png files as point symbols?

DavidZiegler — Mon, 13 Dec 2021 17:24:03 GMT

Johannes: I have the URL of the logo in logo path--but what goes into logo data? I have nothing in that column--what should be there?

Re: Can you import multiple geocoded png files as point symbols?

DavidZiegler — Tue, 14 Dec 2021 14:08:54 GMT

Johannes has provided an effective path here to putting multiple company or other picture (png or other) logos on a map. I can't thank him enough.

Re: Can you import multiple geocoded png files as point symbols?

DavidZiegler — Fri, 17 Dec 2021 15:06:09 GMT

IT WORKED!!

Re: Can you import multiple geocoded png files as point symbols?

DavidZiegler — Sat, 18 Dec 2021 14:20:59 GMT

Ultimately, after several errors on my part, IT WORKED!

Re: Can you import multiple geocoded png files as point symbols?

m3 — Mon, 16 Oct 2023 17:38:33 GMT

Adding blob attachments as a label looks like a simple 3 step process, however no matter what I try, I just get the "broken image" icon. I'm on 2.9.9 and tried it on 3.1 with the same result. Is there some other setting I'm missing.

Re: Can you import multiple geocoded png files as point symbols?

JohannesLindner — Sat, 11 Nov 2023 15:28:30 GMT

@m3

It doesn't work with labels, only with symbology (but I guess you're actually using symbology)
It doesn't work with attachments. You have to read the byte data into the actual table.

Re: Can you import multiple geocoded png files as point symbols?

m3 — Fri, 17 Nov 2023 16:07:47 GMT

The instructions are simple enough but it doesn't work for me. 2.9 or 3.1-2. Different APRX, different images, just get the broken image symbol, I just gave up